After importing the RSClientPrint.dll type library into Delphi 7.0
Enterprise. A simple test app which calls then RSClientPrint .Print() method
returns these errors;
Error loading resource libraray. (0x80004002)
&
No such interface supported.Guess we have to get all SOAPed up to get this to work.
Showing posts with label enterprise. Show all posts
Showing posts with label enterprise. Show all posts
Wednesday, March 28, 2012
Wednesday, March 7, 2012
RS integrated with MOSS - Internal Error - AdjustTokenPrivileges
I'm running MOSS 2007 Enterprise, SQL 2005 SP2, RS integrated with MOSS and have a number of reports deployed to a Reports Library in MOSS. 3 out of 10 times I run a report I get a error message stating that 'An internal error occured on the report server.' Just hitting Apply on the parameter panel will fix the problem and render the report as expected.
Previous entries to the forum about this error hints at an error that supposedly was fixed in SP2; since I'm running SP2 something else must be the problem.
Any insight to what might cause the problem ?
Regards,
Trond
Relevant content from the RS error log included below:
04/26/07 11:42:21, ERROR , SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () failed (00000514)
04/26/07 11:42:21, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied
04/26/07 11:42:21, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,ProcessID = 7008
04/26/07 11:42:21, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,ThreadId = 0
04/26/07 11:42:21, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,Flags = 0x0
04/26/07 11:42:21, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,MiniDumpFlags = 0x0
04/26/07 11:42:21, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,SqlInfoPtr = 0x47405860
04/26/07 11:42:21, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,DumpDir = <NULL>
04/26/07 11:42:21, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,ExceptionRecordPtr = 0x00000000
04/26/07 11:42:21, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,ContextPtr = 0x00000000
04/26/07 11:42:21, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,ExtraFile = <NULL>
04/26/07 11:42:21, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,InstanceName = <NULL>
04/26/07 11:42:21, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,ServiceName = <NULL>
04/26/07 11:42:21, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used
04/26/07 11:42:21, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 15 not used
04/26/07 11:42:23, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
04/26/07 11:42:23, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\SQLDmpr0147.mdmp
04/26/07 11:42:23, ACTION,w3wp.exe, Watson Invoke: No
w3wp!processing!1!4/26/2007-11:42:21:: a ASSERT: Assertion failed!Call stack:
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.UpdateTimingInformation(RunningJobContext jobContext, Int64 totalDurationMs, Int64 reportDataRetrievalDurationMs, Int64 reportRenderingDurationMs)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(IRenderingExtension renderer, DateTime executionTimeStamp, GetReportChunk getCompiledDefinitionCallback, ProcessingContext pc, RenderingContext rc, CreateReportChunk cacheDataCallback, Boolean& dataCached)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(DateTime executionTimeStamp, GetReportChunk getCompiledDefinitionCallback, ProcessingContext pc, RenderingContext rc)
Microsoft.ReportingServices.Library.RSService.RenderAsLive(CatalogItemContext reportContext, ItemProperties properties, ParameterInfoCollection effectiveParameters, Guid reportId, ClientRequest session, String description, ReportSnapshot intermediateSnapshot, DataSourceInfoCollection thisReportDataSources, Boolean cachingRequested, Boolean isLinkedReport, Warning[]& warnings, ReportSnapshot& resultSnapshotData, DateTime& executionDateTime, RuntimeDataSourceInfoCollection& alldataSources, UserProfileState& usedUserProfile)
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters)
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService rs, CatalogItemContext reportContext, ClientRequest session, JobType type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.DoStreamedOperation(StreamedOperation operation)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.ProcessRequest(HttpContext context)
System.Web.HttpApplication+CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
System.Web.HttpApplication.ResumeSteps(Exception error)
System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr)
System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)
w3wp!library!1!4/26/2007-11:42:21:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., un-named assertion fired for component processing;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
Reapplying SP2, rebooting and then reapplying SP2 once more because I got frustrated beyond what's good for my health, seems to have fixed this issue.
Why the initial and the second SP2 didn't help is beyond my understanding.
Trond
rs Enterprise Edition
I wanted to upgrade to rs Enterprise edition so i could take advantage of
data drive subscriptions and found that the price tag is $24,000. I was
surprised at the jump from $0 to $24K for such a small difference in
features, so I am assuming that I am missing something. Can anyone tell me
what would account for the sharp difference in price?Hmmm, yes. It was never 0 in the first place. You have to pay a license for
SQL Server on any server that RS is installed on. So if you have a web farm
you have to have a license for each server, regardless of whether a SQL
Server database is installed on the machine (think of it like buying an
office license, I buy an office license doesn't mean I can put Word on one
machine, Excel on another, Powerpoint on a 3rd). Anyway, if you have SQL
Server standard already purchased and you install RS on the same server
(important point) then it is free. Same thing is true if you already had
Enterprise and installed RS on the same server.
Based on the amount you mention I assume you are doing a per processor
license, not a per user license.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"denny" <denny@.microsoft.com> wrote in message
news:uPPOU85SFHA.2916@.TK2MSFTNGP15.phx.gbl...
>I wanted to upgrade to rs Enterprise edition so i could take advantage of
>data drive subscriptions and found that the price tag is $24,000. I was
>surprised at the jump from $0 to $24K for such a small difference in
>features, so I am assuming that I am missing something. Can anyone tell
>me what would account for the sharp difference in price?
>|||We were in the same situation and thought that SQL Enterprise Edition was
required to for RS Enterprise Edition, but this is not true (just a bit
confusing). We installed RS Enterprise on our SQL Standard Edition server
just fine at no additional cost.
Neil
"Bruce L-C [MVP]" wrote:
> Hmmm, yes. It was never 0 in the first place. You have to pay a license for
> SQL Server on any server that RS is installed on. So if you have a web farm
> you have to have a license for each server, regardless of whether a SQL
> Server database is installed on the machine (think of it like buying an
> office license, I buy an office license doesn't mean I can put Word on one
> machine, Excel on another, Powerpoint on a 3rd). Anyway, if you have SQL
> Server standard already purchased and you install RS on the same server
> (important point) then it is free. Same thing is true if you already had
> Enterprise and installed RS on the same server.
> Based on the amount you mention I assume you are doing a per processor
> license, not a per user license.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "denny" <denny@.microsoft.com> wrote in message
> news:uPPOU85SFHA.2916@.TK2MSFTNGP15.phx.gbl...
> >I wanted to upgrade to rs Enterprise edition so i could take advantage of
> >data drive subscriptions and found that the price tag is $24,000. I was
> >surprised at the jump from $0 to $24K for such a small difference in
> >features, so I am assuming that I am missing something. Can anyone tell
> >me what would account for the sharp difference in price?
> >
>
>|||From a licensing perspective it very much is true. Also, whether it requires
for install or not is besides the point, an Enterprise SQL Server license is
required for RS Enterprise. They are one and the same as far as licensing is
concerned. RS is not a separate product it is part of SQL Server.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Neil Gould" <NeilGould@.discussions.microsoft.com> wrote in message
news:456D0FBF-4FBA-412B-B2F6-39306036EE0E@.microsoft.com...
> We were in the same situation and thought that SQL Enterprise Edition was
> required to for RS Enterprise Edition, but this is not true (just a bit
> confusing). We installed RS Enterprise on our SQL Standard Edition server
> just fine at no additional cost.
> Neil
> "Bruce L-C [MVP]" wrote:
> > Hmmm, yes. It was never 0 in the first place. You have to pay a license
for
> > SQL Server on any server that RS is installed on. So if you have a web
farm
> > you have to have a license for each server, regardless of whether a SQL
> > Server database is installed on the machine (think of it like buying an
> > office license, I buy an office license doesn't mean I can put Word on
one
> > machine, Excel on another, Powerpoint on a 3rd). Anyway, if you have SQL
> > Server standard already purchased and you install RS on the same server
> > (important point) then it is free. Same thing is true if you already had
> > Enterprise and installed RS on the same server.
> >
> > Based on the amount you mention I assume you are doing a per processor
> > license, not a per user license.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "denny" <denny@.microsoft.com> wrote in message
> > news:uPPOU85SFHA.2916@.TK2MSFTNGP15.phx.gbl...
> > >I wanted to upgrade to rs Enterprise edition so i could take advantage
of
> > >data drive subscriptions and found that the price tag is $24,000. I
was
> > >surprised at the jump from $0 to $24K for such a small difference in
> > >features, so I am assuming that I am missing something. Can anyone
tell
> > >me what would account for the sharp difference in price?
> > >
> >
> >
> >
data drive subscriptions and found that the price tag is $24,000. I was
surprised at the jump from $0 to $24K for such a small difference in
features, so I am assuming that I am missing something. Can anyone tell me
what would account for the sharp difference in price?Hmmm, yes. It was never 0 in the first place. You have to pay a license for
SQL Server on any server that RS is installed on. So if you have a web farm
you have to have a license for each server, regardless of whether a SQL
Server database is installed on the machine (think of it like buying an
office license, I buy an office license doesn't mean I can put Word on one
machine, Excel on another, Powerpoint on a 3rd). Anyway, if you have SQL
Server standard already purchased and you install RS on the same server
(important point) then it is free. Same thing is true if you already had
Enterprise and installed RS on the same server.
Based on the amount you mention I assume you are doing a per processor
license, not a per user license.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"denny" <denny@.microsoft.com> wrote in message
news:uPPOU85SFHA.2916@.TK2MSFTNGP15.phx.gbl...
>I wanted to upgrade to rs Enterprise edition so i could take advantage of
>data drive subscriptions and found that the price tag is $24,000. I was
>surprised at the jump from $0 to $24K for such a small difference in
>features, so I am assuming that I am missing something. Can anyone tell
>me what would account for the sharp difference in price?
>|||We were in the same situation and thought that SQL Enterprise Edition was
required to for RS Enterprise Edition, but this is not true (just a bit
confusing). We installed RS Enterprise on our SQL Standard Edition server
just fine at no additional cost.
Neil
"Bruce L-C [MVP]" wrote:
> Hmmm, yes. It was never 0 in the first place. You have to pay a license for
> SQL Server on any server that RS is installed on. So if you have a web farm
> you have to have a license for each server, regardless of whether a SQL
> Server database is installed on the machine (think of it like buying an
> office license, I buy an office license doesn't mean I can put Word on one
> machine, Excel on another, Powerpoint on a 3rd). Anyway, if you have SQL
> Server standard already purchased and you install RS on the same server
> (important point) then it is free. Same thing is true if you already had
> Enterprise and installed RS on the same server.
> Based on the amount you mention I assume you are doing a per processor
> license, not a per user license.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "denny" <denny@.microsoft.com> wrote in message
> news:uPPOU85SFHA.2916@.TK2MSFTNGP15.phx.gbl...
> >I wanted to upgrade to rs Enterprise edition so i could take advantage of
> >data drive subscriptions and found that the price tag is $24,000. I was
> >surprised at the jump from $0 to $24K for such a small difference in
> >features, so I am assuming that I am missing something. Can anyone tell
> >me what would account for the sharp difference in price?
> >
>
>|||From a licensing perspective it very much is true. Also, whether it requires
for install or not is besides the point, an Enterprise SQL Server license is
required for RS Enterprise. They are one and the same as far as licensing is
concerned. RS is not a separate product it is part of SQL Server.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Neil Gould" <NeilGould@.discussions.microsoft.com> wrote in message
news:456D0FBF-4FBA-412B-B2F6-39306036EE0E@.microsoft.com...
> We were in the same situation and thought that SQL Enterprise Edition was
> required to for RS Enterprise Edition, but this is not true (just a bit
> confusing). We installed RS Enterprise on our SQL Standard Edition server
> just fine at no additional cost.
> Neil
> "Bruce L-C [MVP]" wrote:
> > Hmmm, yes. It was never 0 in the first place. You have to pay a license
for
> > SQL Server on any server that RS is installed on. So if you have a web
farm
> > you have to have a license for each server, regardless of whether a SQL
> > Server database is installed on the machine (think of it like buying an
> > office license, I buy an office license doesn't mean I can put Word on
one
> > machine, Excel on another, Powerpoint on a 3rd). Anyway, if you have SQL
> > Server standard already purchased and you install RS on the same server
> > (important point) then it is free. Same thing is true if you already had
> > Enterprise and installed RS on the same server.
> >
> > Based on the amount you mention I assume you are doing a per processor
> > license, not a per user license.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "denny" <denny@.microsoft.com> wrote in message
> > news:uPPOU85SFHA.2916@.TK2MSFTNGP15.phx.gbl...
> > >I wanted to upgrade to rs Enterprise edition so i could take advantage
of
> > >data drive subscriptions and found that the price tag is $24,000. I
was
> > >surprised at the jump from $0 to $24K for such a small difference in
> > >features, so I am assuming that I am missing something. Can anyone
tell
> > >me what would account for the sharp difference in price?
> > >
> >
> >
> >
Tuesday, February 21, 2012
RS 2005 Subscription Disabled
Hello,
I'm using SQL 2005 SP2 build 3215 x64 Enterprise (4x dualcore 8Gram)
Everything is working OK (SQL,SSIS,AS,RS) except creating data driven
subscriptions.
I have an report with an custom data source (to AS) wich is working OK.
The credentials are stored in DB, SQL Agent is working a.so.
The web services is running under NT\SYSTEM, I am connected with a
domain user which is local admin.
Report Manager web interface:
I can create "normal" subscriptions and they are working OK.
I can't create data driven subscription (there is no option to create
it). (yes, it is enterprise version, see appendix :) )
Management Studio (started on the server via Remote desktop, logged in
as a domain user in the local admin group):
Both "New Subscription" and "New Data Driven Subscription" are grayed
out (disabled).
I can see the subscription created via Report Manager but I can't access
its properties , I can only delete it.
Question:
How can I create a data driven subscription from Management Studio?
How can I get the Items (create subscription) enabled in the context menu?
What I'm doing wrong ? :)
Cheers,
Radu
APPENDIX:
select @.@.version:
Microsoft SQL Server 2005 - 9.00.3215.00 (X64) Dec 8 2007 17:58:16
Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition
(64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
All the components SQL, AS, RS are running on the same server.I want to add that we have made some time ago an upgrade from Standard
Edition to Enterprise Edition
Maybe something get wrong with upgrading the RS?
Radu
I'm using SQL 2005 SP2 build 3215 x64 Enterprise (4x dualcore 8Gram)
Everything is working OK (SQL,SSIS,AS,RS) except creating data driven
subscriptions.
I have an report with an custom data source (to AS) wich is working OK.
The credentials are stored in DB, SQL Agent is working a.so.
The web services is running under NT\SYSTEM, I am connected with a
domain user which is local admin.
Report Manager web interface:
I can create "normal" subscriptions and they are working OK.
I can't create data driven subscription (there is no option to create
it). (yes, it is enterprise version, see appendix :) )
Management Studio (started on the server via Remote desktop, logged in
as a domain user in the local admin group):
Both "New Subscription" and "New Data Driven Subscription" are grayed
out (disabled).
I can see the subscription created via Report Manager but I can't access
its properties , I can only delete it.
Question:
How can I create a data driven subscription from Management Studio?
How can I get the Items (create subscription) enabled in the context menu?
What I'm doing wrong ? :)
Cheers,
Radu
APPENDIX:
select @.@.version:
Microsoft SQL Server 2005 - 9.00.3215.00 (X64) Dec 8 2007 17:58:16
Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition
(64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
All the components SQL, AS, RS are running on the same server.I want to add that we have made some time ago an upgrade from Standard
Edition to Enterprise Edition
Maybe something get wrong with upgrading the RS?
Radu
Subscribe to:
Posts (Atom)