Ive seen a few posts with the same title but none of them asked this question. At least what I found.
I am trying to get my subreports to show up. However, all I can get them to say is Error: Subreport could not be shown.
How can I get the error that the subreport is throwing? My environment is VS 2005
Thanks.
I work for a Microsoft Gold Partner and I am having a problem with subreports in SSRS 2005 SP1.
Essentially, I have a report that contains subreports. The main report has a table that passes a parameter to a subreport in each row. The report renders properly when I preview it in Visual Studio, but once deployed to the server it only renders the first subreport for the first row, and every subreport thereafter displays the error, "Error: Subreport could not be shown."
I tested each subreport individually on the SSRS sever and each executes and displays fine. I turned on traces in the web.config file and found some additional information:
<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.2047.00</Product>
<Locale>en-US</Locale>
<TimeZone>Eastern Daylight Time</TimeZone>
<Path>C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFilesReportServer__07_16_2006_18_17_54.log</Path>
<SystemName>DEVBOX</SystemName>
<OSName>Microsoft Windows NT 5.2.3790 Service Pack 1</OSName>
<OSVersion>5.2.3790.65536</OSVersion>
</Header>
w3wp!webserver!5!7/16/2006-18:17:54:: i INFO: Reporting Web Server started
w3wp!library!5!7/16/2006-18:17:54:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
w3wp!library!5!7/16/2006-18:17:54:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
w3wp!library!5!7/16/2006-18:17:54:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
w3wp!library!5!7/16/2006-18:17:54:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
w3wp!library!5!7/16/2006-18:17:54:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
w3wp!library!5!7/16/2006-18:17:54:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!library!5!7/16/2006-18:17:54:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
w3wp!library!5!7/16/2006-18:17:54:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
w3wp!library!5!7/16/2006-18:17:54:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
w3wp!library!5!7/16/2006-18:17:54:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
w3wp!library!5!7/16/2006-18:17:54:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
w3wp!library!5!7/16/2006-18:17:54:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
w3wp!library!5!7/16/2006-18:17:54:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!5!7/16/2006-18:17:54:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
w3wp!library!5!7/16/2006-18:17:54:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
w3wp!library!5!7/16/2006-18:17:54:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
w3wp!library!5!7/16/2006-18:17:54:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
w3wp!library!5!7/16/2006-18:17:54:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
w3wp!library!5!7/16/2006-18:17:54:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
w3wp!library!5!7/16/2006-18:17:54:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
w3wp!library!5!7/16/2006-18:17:54:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!5!7/16/2006-18:17:54:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
w3wp!library!5!7/16/2006-18:17:54:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
w3wp!library!5!7/16/2006-18:17:54:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
w3wp!library!5!7/16/2006-18:17:54:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
w3wp!library!5!7/16/2006-18:17:54:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!5!7/16/2006-18:17:54:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!resourceutilities!5!7/16/2006-18:17:54:: i INFO: Reporting Services starting SKU: Enterprise
w3wp!resourceutilities!5!7/16/2006-18:17:54:: i INFO: Evaluation copy: 0 days left
w3wp!runningjobs!5!7/16/2006-18:17:54:: i INFO: Database Cleanup (Web Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
w3wp!runningjobs!5!7/16/2006-18:17:54:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!5!7/16/2006-18:17:54:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!5!7/16/2006-18:17:54:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!library!5!07/16/2006-18:17:56:: i INFO: Call to GetPermissions:/Reports/Project Scorecard - All Open by Team Member
w3wp!library!5!07/16/2006-18:17:56:: i INFO: Catalog SQL Server Edition = Enterprise
w3wp!library!5!07/16/2006-18:17:57:: i INFO: Call to GetSystemPermissions
w3wp!library!1!07/16/2006-18:18:01:: i INFO: Call to RenderFirst( '/Reports/Project Scorecard - All Open by Team Member' )
w3wp!processing!1!7/16/2006-18:18:13:: e ERROR: An exception has occurred in data source 'dsProjectScorecard'. Details: System.ArgumentException: Item has already been added. Key in dictionary: '28' Key being added: '28'
at System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add)
at System.Collections.Hashtable.Add(Object key, Object value)
at Microsoft.ReportingServices.ReportProcessing.TokensHashtable.Add(Int32 tokenID, Object tokenValue)
at Microsoft.ReportingServices.ReportProcessing.ReportDrillthroughInfo.AddRewrittenCommand(Int32 id, Object value)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.RunDataSetQuery()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.FirstPassInit()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPassProcess(Boolean& closeConnWhenFinish)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.Process()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.ProcessConcurrent(Object threadSet)
w3wp!processing!1!7/16/2006-18:18:13:: i INFO: Merge abort handler called for ID=325. Aborting data sources ...
w3wp!processing!1!7/16/2006-18:18:13:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing., ;
Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> System.ArgumentException: Item has already been added. Key in dictionary: '28' Key being added: '28'
at System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add)
at System.Collections.Hashtable.Add(Object key, Object value)
at Microsoft.ReportingServices.ReportProcessing.TokensHashtable.Add(Int32 tokenID, Object tokenValue)
at Microsoft.ReportingServices.ReportProcessing.ReportDrillthroughInfo.AddRewrittenCommand(Int32 id, Object value)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.RunDataSetQuery()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.FirstPassInit()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPassProcess(Boolean& closeConnWhenFinish)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.Process()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.ProcessConcurrent(Object threadSet)
--- End of inner exception stack trace ---
w3wp!processing!1!7/16/2006-18:18:13:: w WARN: Data source 'DataSourcePM': Report processing has been aborted.
w3wp!processing!1!7/16/2006-18:18:13:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing., ;
Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> System.ArgumentException: Item has already been added. Key in dictionary: '28' Key being added: '28'
at System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add)
at System.Collections.Hashtable.Add(Object key, Object value)
at Microsoft.ReportingServices.ReportProcessing.TokensHashtable.Add(Int32 tokenID, Object tokenValue)
at Microsoft.ReportingServices.ReportProcessing.ReportDrillthroughInfo.AddRewrittenCommand(Int32 id, Object value)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.RunDataSetQuery()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.FirstPassInit()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPassProcess(Boolean& closeConnWhenFinish)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.Process()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.ProcessConcurrent(Object threadSet)
--- End of inner exception stack trace ---
w3wp!processing!1!7/16/2006-18:18:13:: e ERROR: An exception has occurred in data source 'dsProjectScorecard'. Details: System.ArgumentException: Item has already been added. Key in dictionary: '28' Key being added: '28'
at System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add)
at System.Collections.Hashtable.Add(Object key, Object value)
at Microsoft.ReportingServices.ReportProcessing.TokensHashtable.Add(Int32 tokenID, Object tokenValue)
at Microsoft.ReportingServices.ReportProcessing.ReportDrillthroughInfo.AddRewrittenCommand(Int32 id, Object value)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.RunDataSetQuery()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.FirstPassInit()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPassProcess(Boolean& closeConnWhenFinish)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.Process()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.ProcessConcurrent(Object threadSet)
w3wp!processing!1!7/16/2006-18:18:13:: i INFO: Merge abort handler called for ID=328. Aborting data sources ...
w3wp!processing!1!7/16/2006-18:18:13:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing., ;
Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> System.ArgumentException: Item has already been added. Key in dictionary: '28' Key being added: '28'
at System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add)
at System.Collections.Hashtable.Add(Object key, Object value)
at Microsoft.ReportingServices.ReportProcessing.TokensHashtable.Add(Int32 tokenID, Object tokenValue)
at Microsoft.ReportingServices.ReportProcessing.ReportDrillthroughInfo.AddRewrittenCommand(Int32 id, Object value)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.RunDataSetQuery()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.FirstPassInit()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPassProcess(Boolean& closeConnWhenFinish)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.Process()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.ProcessConcurrent(Object threadSet)
--- End of inner exception stack trace ---
w3wp!processing!1!7/16/2006-18:18:13:: w WARN: Data source 'DataSourcePM': Report processing has been aborted.
w3wp!processing!1!7/16/2006-18:18:13:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing., ;
Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> System.ArgumentException: Item has already been added. Key in dictionary: '28' Key being added: '28'
at System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add)
at System.Collections.Hashtable.Add(Object key, Object value)
at Microsoft.ReportingServices.ReportProcessing.TokensHashtable.Add(Int32 tokenID, Object tokenValue)
at Microsoft.ReportingServices.ReportProcessing.ReportDrillthroughInfo.AddRewrittenCommand(Int32 id, Object value)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.RunDataSetQuery()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.FirstPassInit()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPassProcess(Boolean& closeConnWhenFinish)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.Process()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.ProcessConcurrent(Object threadSet)
--- End of inner exception stack trace ---
w3wp!processing!1!7/16/2006-18:18:13:: e ERROR: An exception has occurred in data source 'dsProjectScorecard'. Details: System.ArgumentException: Item has already been added. Key in dictionary: '28' Key being added: '28'
at System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add)
at System.Collections.Hashtable.Add(Object key, Object value)
at Microsoft.ReportingServices.ReportProcessing.TokensHashtable.Add(Int32 tokenID, Object tokenValue)
at Microsoft.ReportingServices.ReportProcessing.ReportDrillthroughInfo.AddRewrittenCommand(Int32 id, Object value)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.RunDataSetQuery()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.FirstPassInit()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPassProcess(Boolean& closeConnWhenFinish)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.Process()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.ProcessConcurrent(Object threadSet)
w3wp!processing!1!7/16/2006-18:18:13:: i INFO: Merge abort handler called for ID=336. Aborting data sources ...
w3wp!processing!1!7/16/2006-18:18:13:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing., ;
Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> System.ArgumentException: Item has already been added. Key in dictionary: '28' Key being added: '28'
at System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add)
at System.Collections.Hashtable.Add(Object key, Object value)
at Microsoft.ReportingServices.ReportProcessing.TokensHashtable.Add(Int32 tokenID, Object tokenValue)
at Microsoft.ReportingServices.ReportProcessing.ReportDrillthroughInfo.AddRewrittenCommand(Int32 id, Object value)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.RunDataSetQuery()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.FirstPassInit()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPassProcess(Boolean& closeConnWhenFinish)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.Process()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.ProcessConcurrent(Object threadSet)
--- End of inner exception stack trace ---
w3wp!processing!1!7/16/2006-18:18:13:: w WARN: Data source 'DataSourcePM': Report processing has been aborted.
w3wp!processing!1!7/16/2006-18:18:13:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing., ;
Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> System.ArgumentException: Item has already been added. Key in dictionary: '28' Key being added: '28'
at System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add)
at System.Collections.Hashtable.Add(Object key, Object value)
at Microsoft.ReportingServices.ReportProcessing.TokensHashtable.Add(Int32 tokenID, Object tokenValue)
at Microsoft.ReportingServices.ReportProcessing.ReportDrillthroughInfo.AddRewrittenCommand(Int32 id, Object value)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.RunDataSetQuery()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.FirstPassInit()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPassProcess(Boolean& closeConnWhenFinish)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.Process()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.ProcessConcurrent(Object threadSet)
--- End of inner exception stack trace ---
w3wp!processing!1!7/16/2006-18:18:13:: e ERROR: An exception has occurred in data source 'dsProjectScorecard'. Details: System.ArgumentException: Item has already been added. Key in dictionary: '28' Key being added: '28'
at System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add)
at System.Collections.Hashtable.Add(Object key, Object value)
at Microsoft.ReportingServices.ReportProcessing.TokensHashtable.Add(Int32 tokenID, Object tokenValue)
at Microsoft.ReportingServices.ReportProcessing.ReportDrillthroughInfo.AddRewrittenCommand(Int32 id, Object value)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.RunDataSetQuery()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.FirstPassInit()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPassProcess(Boolean& closeConnWhenFinish)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.Process()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.ProcessConcurrent(Object threadSet)
w3wp!processing!1!7/16/2006-18:18:13:: i INFO: Merge abort handler called for ID=344. Aborting data sources ...
w3wp!processing!1!7/16/2006-18:18:13:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing., ;
Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> System.ArgumentException: Item has already been added. Key in dictionary: '28' Key being added: '28'
at System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add)
at System.Collections.Hashtable.Add(Object key, Object value)
at Microsoft.ReportingServices.ReportProcessing.TokensHashtable.Add(Int32 tokenID, Object tokenValue)
at Microsoft.ReportingServices.ReportProcessing.ReportDrillthroughInfo.AddRewrittenCommand(Int32 id, Object value)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.RunDataSetQuery()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.FirstPassInit()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPassProcess(Boolean& closeConnWhenFinish)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.Process()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.ProcessConcurrent(Object threadSet)
--- End of inner exception stack trace ---
w3wp!processing!1!7/16/2006-18:18:13:: w WARN: Data source 'DataSourcePM': Report processing has been aborted.
w3wp!processing!1!7/16/2006-18:18:13:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing., ;
Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> System.ArgumentException: Item has already been added. Key in dictionary: '28' Key being added: '28'
at System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add)
at System.Collections.Hashtable.Add(Object key, Object value)
at Microsoft.ReportingServices.ReportProcessing.TokensHashtable.Add(Int32 tokenID, Object tokenValue)
at Microsoft.ReportingServices.ReportProcessing.ReportDrillthroughInfo.AddRewrittenCommand(Int32 id, Object value)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.RunDataSetQuery()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.FirstPassInit()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPassProcess(Boolean& closeConnWhenFinish)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.Process()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.ProcessConcurrent(Object threadSet)
--- End of inner exception stack trace ---
w3wp!processing!1!7/16/2006-18:18:13:: e ERROR: An exception has occurred in data source 'dsProjectScorecard'. Details: System.ArgumentException: Item has already been added. Key in dictionary: '28' Key being added: '28'
at System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add)
at System.Collections.Hashtable.Add(Object key, Object value)
at Microsoft.ReportingServices.ReportProcessing.TokensHashtable.Add(Int32 tokenID, Object tokenValue)
at Microsoft.ReportingServices.ReportProcessing.ReportDrillthroughInfo.AddRewrittenCommand(Int32 id, Object value)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.RunDataSetQuery()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.FirstPassInit()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPassProcess(Boolean& closeConnWhenFinish)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.Process()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.ProcessConcurrent(Object threadSet)
w3wp!processing!1!7/16/2006-18:18:13:: i INFO: Merge abort handler called for ID=352. Aborting data sources ...
w3wp!processing!1!7/16/2006-18:18:13:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing., ;
Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> System.ArgumentException: Item has already been added. Key in dictionary: '28' Key being added: '28'
at System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add)
at System.Collections.Hashtable.Add(Object key, Object value)
at Microsoft.ReportingServices.ReportProcessing.TokensHashtable.Add(Int32 tokenID, Object tokenValue)
at Microsoft.ReportingServices.ReportProcessing.ReportDrillthroughInfo.AddRewrittenCommand(Int32 id, Object value)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.RunDataSetQuery()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.FirstPassInit()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPassProcess(Boolean& closeConnWhenFinish)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.Process()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.ProcessConcurrent(Object threadSet)
--- End of inner exception stack trace ---
w3wp!processing!1!7/16/2006-18:18:13:: w WARN: Data source 'DataSourcePM': Report processing has been aborted.
w3wp!processing!1!7/16/2006-18:18:13:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing., ;
Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> System.ArgumentException: Item has already been added. Key in dictionary: '28' Key being added: '28'
at System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add)
at System.Collections.Hashtable.Add(Object key, Object value)
at Microsoft.ReportingServices.ReportProcessing.TokensHashtable.Add(Int32 tokenID, Object tokenValue)
at Microsoft.ReportingServices.ReportProcessing.ReportDrillthroughInfo.AddRewrittenCommand(Int32 id, Object value)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.RunDataSetQuery()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.FirstPassInit()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPassProcess(Boolean& closeConnWhenFinish)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.Process()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.ProcessConcurrent(Object threadSet)
--- End of inner exception stack trace ---
w3wp!processing!1!7/16/2006-18:18:13:: e ERROR: An exception has occurred in data source 'dsProjectScorecard'. Details: System.ArgumentException: Item has already been added. Key in dictionary: '28' Key being added: '28'
at System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add)
at System.Collections.Hashtable.Add(Object key, Object value)
at Microsoft.ReportingServices.ReportProcessing.TokensHashtable.Add(Int32 tokenID, Object tokenValue)
at Microsoft.ReportingServices.ReportProcessing.ReportDrillthroughInfo.AddRewrittenCommand(Int32 id, Object value)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.RunDataSetQuery()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.FirstPassInit()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPassProcess(Boolean& closeConnWhenFinish)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.Process()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.ProcessConcurrent(Object threadSet)
w3wp!processing!1!7/16/2006-18:18:13:: i INFO: Merge abort handler called for ID=360. Aborting data sources ...
w3wp!processing!1!7/16/2006-18:18:13:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing., ;
Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> System.ArgumentException: Item has already been added. Key in dictionary: '28' Key being added: '28'
at System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add)
at System.Collections.Hashtable.Add(Object key, Object value)
at Microsoft.ReportingServices.ReportProcessing.TokensHashtable.Add(Int32 tokenID, Object tokenValue)
at Microsoft.ReportingServices.ReportProcessing.ReportDrillthroughInfo.AddRewrittenCommand(Int32 id, Object value)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.RunDataSetQuery()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.FirstPassInit()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPassProcess(Boolean& closeConnWhenFinish)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.Process()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.ProcessConcurrent(Object threadSet)
--- End of inner exception stack trace ---
w3wp!processing!1!7/16/2006-18:18:13:: w WARN: Data source 'DataSourcePM': Report processing has been aborted.
w3wp!processing!1!7/16/2006-18:18:13:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing., ;
Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> System.ArgumentException: Item has already been added. Key in dictionary: '28' Key being added: '28'
at System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add)
at System.Collections.Hashtable.Add(Object key, Object value)
at Microsoft.ReportingServices.ReportProcessing.TokensHashtable.Add(Int32 tokenID, Object tokenValue)
at Microsoft.ReportingServices.ReportProcessing.ReportDrillthroughInfo.AddRewrittenCommand(Int32 id, Object value)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.RunDataSetQuery()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.FirstPassInit()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPassProcess(Boolean& closeConnWhenFinish)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.Process()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.ProcessConcurrent(Object threadSet)
--- End of inner exception stack trace ---
w3wp!processing!1!7/16/2006-18:18:13:: e ERROR: An exception has occurred in data source 'dsProjectScorecard'. Details: System.ArgumentException: Item has already been added. Key in dictionary: '28' Key being added: '28'
at System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add)
at System.Collections.Hashtable.Add(Object key, Object value)
at Microsoft.ReportingServices.ReportProcessing.TokensHashtable.Add(Int32 tokenID, Object tokenValue)
at Microsoft.ReportingServices.ReportProcessing.ReportDrillthroughInfo.AddRewrittenCommand(Int32 id, Object value)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.RunDataSetQuery()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.FirstPassInit()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPassProcess(Boolean& closeConnWhenFinish)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.Process()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.ProcessConcurrent(Object threadSet)
w3wp!processing!1!7/16/2006-18:18:13:: i INFO: Merge abort handler called for ID=368. Aborting data sources ...
w3wp!processing!1!7/16/2006-18:18:13:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing., ;
Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> System.ArgumentException: Item has already been added. Key in dictionary: '28' Key being added: '28'
at System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add)
at System.Collections.Hashtable.Add(Object key, Object value)
at Microsoft.ReportingServices.ReportProcessing.TokensHashtable.Add(Int32 tokenID, Object tokenValue)
at Microsoft.ReportingServices.ReportProcessing.ReportDrillthroughInfo.AddRewrittenCommand(Int32 id, Object value)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.RunDataSetQuery()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.FirstPassInit()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPassProcess(Boolean& closeConnWhenFinish)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.Process()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.ProcessConcurrent(Object threadSet)
--- End of inner exception stack trace ---
w3wp!processing!1!7/16/2006-18:18:13:: w WARN: Data source 'DataSourcePM': Report processing has been aborted.
w3wp!processing!1!7/16/2006-18:18:13:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing., ;
Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> System.ArgumentException: Item has already been added. Key in dictionary: '28' Key being added: '28'
at System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add)
at System.Collections.Hashtable.Add(Object key, Object value)
at Microsoft.ReportingServices.ReportProcessing.TokensHashtable.Add(Int32 tokenID, Object tokenValue)
at Microsoft.ReportingServices.ReportProcessing.ReportDrillthroughInfo.AddRewrittenCommand(Int32 id, Object value)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.RunDataSetQuery()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.FirstPassInit()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPassProcess(Boolean& closeConnWhenFinish)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.Process()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.ProcessConcurrent(Object threadSet)
--- End of inner exception stack trace ---
w3wp!library!1!07/16/2006-18:18:13:: Using folder C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesRSTempFiles for temporary files.
w3wp!processing!1!7/16/2006-18:18:15:: w WARN: The grouping expression for a category grouping returned a null value.
w3wp!processing!1!7/16/2006-18:18:15:: w WARN: The grouping expression for a category grouping returned a null value.
w3wp!webserver!1!07/16/2006-18:18:15:: i INFO: Processed report. Report='/Reports/Project Scorecard - All Open by Team Member', Stream=''
Any insight or assistance would be greatly appreciated.
Eric Hausig
Developer Lead
Artemis Solutions Group
eric.hausig@artemis-solutions.com
I have a problem with a report containing a number of subreports not running successfully when deployed to the Report Server.
The report runs successfully every time in the VS Development environment, so parameters are all setup correctly and the result is as expected accross the whole report.
No errors or warnings are listed when building or deploying.
All subreports are in the same project as the main report and deployed to the same folder in Report Manager. All the individual subreports run successfully both in VS Studio (Preview Tab) and in the Report Manager portal.
About 50% of the time, the main report runs but shows the error "Subreport could not be shown" for some or all of the subreports.
Running SQL 2005 SP1
Please advise.
I am trying to call a subreport in master report, if i try to run the sub report individually by passing hardcoded nonqueried values in the parameters it runs fine, but when i use it as subreport in a master report, it shows the error: subreport could not be shown,
In my subreport i am using the table control to populate all fields is there something to do with table control or i am calling the subreport control in the detail pane of main report, and all main reports fields are in the group header.
Please help.
error info: from error list:
Warning 1 [rsErrorExecutingSubreport] An error occurred while executing the subreport €˜subreport1€™: One or more parameters required to run the report have not been specified. c:aspnetccsreports2005ccsreports2005
ptNewIssueHRT.rdl 0 0
Thank you all very much for the info.
Hi,
I have been battling with this for days now and I cannot get this to work. I would really appreciate it if someone could advise me of where I am going wrong:
Default.aspx.vb:
Imports Microsoft.Reporting.WebForms
Partial Class _Default
Inherits System.Web.UI.Page
Dim odsItems As New ObjectDataSource
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
AddHandler ReportViewer1.LocalReport.SubreportProcessing, AddressOf ItemsSubreportProcessingEventHandler
ReportViewer1.LocalReport.Refresh()
End Sub
Private Sub ItemsSubreportProcessingEventHandler(ByVal sender As Object, ByVal e As SubreportProcessingEventArgs)
If odsItems Is Nothing Then
odsItems = LoadItemsData()
If (e.Parameters.Count > 0) Then
If (odsItems.SelectParameters.Count > 0) Then
odsItems.SelectParameters.RemoveAt(0)
odsItems.SelectParameters.Add(New Parameter("questionid", TypeCode.Int32, CInt(e.Parameters(0).Values(0).ToString)))
End If
End If
e.DataSources.Add(New Microsoft.Reporting.WebForms.ReportDataSource("DataSet2_templBPQues", odsItems))
End If
End Sub
Private Function LoadItemsData()
Dim ods As New ObjectDataSource
ods.TypeName = "DataSet2TableAdapters.templBPQuesTableAdapter"
ods.SelectMethod = "GetSubQuestions"
Return ods
End Function
End Class
Default.aspx:
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>
<%@ Register Assembly="Microsoft.ReportViewer.WebForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" Font-Size="8pt"
Height="400px" Width="400px">
<LocalReport ReportPath="c:inetpubwwwrootsrstestReport.rdlc">
<DataSources>
<rsweb:ReportDataSource DataSourceId="ObjectDataSource1" Name="DataSet1_templBPQues" />
</DataSources>
</LocalReport>
</rsweb:ReportViewer>
<asp:ObjectDataSource ID="ObjectDataSource1" runat="server" SelectMethod="GetQuestions"
TypeName="DataSet1TableAdapters.templBPQuesTableAdapter"></asp:ObjectDataSource>
<asp:ObjectDataSource ID="ObjectDataSource2" runat="server" SelectMethod="GetSubQuestions"
TypeName="DataSet2TableAdapters.templBPQuesTableAdapter" OldValuesParameterFormatString="original_{0}">
<SelectParameters>
<asp:Parameter Name="questionid" Type="Int32" />
</SelectParameters>
</asp:ObjectDataSource>
</div>
</form>
</body>
</html>
My report is one main report with no Parameters and a subreport which is passed one parameter from the main report "questionid".
No matter what I do I get the same error: Error: Subreport could not be shown. I have tried setting the param to string, integer, hidden whatever and nothing works.
Any help would be awesome. Thanks.
I seem to have run across the feared "Error: Subreport could not be shown" problem. I have very carefully checked everything I could find on the issue, but nothing seems to help--and I must admit, I'm at my wits' end here (though it's probably something absurdly simple).
I have a main report with one subreport. I am running ASP.NET, with a ReportViewer control on my ASPX page. The main report and subreport are both local reports, and pull data from SQL data sources.
Initially, I had the parent report pass a parameter to the subreport, but in the interest of keeping things simple I removed that--even though I verified that my handler for the subreport processing was valid and was obtaining valid values for the parameter.
Here's the applicable code from the CodeBehind's class:
Code Snippet
DataView vw;
protected void Page_Load(object sender, EventArgs e)
{
vw = (DataView)SqlDataSource2.Select(DataSourceSelectArguments.None);
rptAllCustomers.LocalReport.SubreportProcessing += new SubreportProcessingEventHandler(ProcessSubReports);
}
protected void ProcessSubReports(object sender, SubreportProcessingEventArgs e)
{
//vw.RowFilter = "SALES_INDEX = " + e.Parameters["SaleIndex"].Values[0];
e.DataSources.Add(new ReportDataSource("SALESConnectionString", vw));
}
And the applicable ASPX code:
Code Snippet
<rsweb:ReportViewer ID="rptAllCustomers" runat="server" Font-Names="Verdana"
Font-Size="8pt" Height="400px" Width="100%">
<!%--<localreport reportpath="App_GlobalResourcesSalesByProduct.rdlc">
</localreport>--%>
<localreport reportpath="App_GlobalResourcesBySale.rdlc"><datasources>
<rsweb:ReportDataSource DataSourceId="SqlDataSource1" Name="SalesData_SALES"></rsweb:ReportDataSource>
</datasources>
</localreport>
</rsweb:ReportViewer>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:sales %>"
SelectCommand="SELECT * FROM SALES WHERE SALE_DELETED = 'false'">
</asp:SqlDataSource>
<asp:SqlDataSource ID="SqlDataSource2" runat="server"
ConnectionString="<%$ ConnectionStrings:sales %>"
SelectCommand="SELECT * FROM CUSTOMER_PRODUCTS">
</asp:SqlDataSource>
Through debugging and other means, I have found the following:
1. The data being passed through vw in the ProcessSubReports is valid.
2. The subreport runs perfectly when placed into its own ReportViewer
3. The reports are all in the App_GlobalResources folder
4. The main report references a subreport by the name of SalesByProduct
5. App_GlobalResources/SalesByProduct.rdlc is the name of the report file
I should be able to provide more information on request.
Anyone have any clues?
I have a simple report which calls another subreport. I can run the report successfully in both the Report Designer and through the Reporting Manager. Security has been set for all users in the Report Manager for both the Main Report and the Sub Report.
When another user tries to run the report from Report Manager they get a one line error message in the Main Report which says "Subreport could not be shown".
I am a Systems Administrator, during testing I have added the other users to the System Administrator Group also, but this made no difference.
Can anyone give me any hints?
Thanks
Rae
I have a base folder (Report Folder A) which has several reports. One of these is a report that is simply a subreport of one of the others in the folder (it uses different default parameters, which is why it's necessary).
I then created another folder (Report Folder B) for users who only have access to some of the data in the reports...so they have browser access to Folder B but not Folder A. All of the reports for the users work except for the one that contains the subreport. When I run the report with a subreport I get the message: "Error: Subreport could not be shown". I'm guessing this is because the users don't have access to the base report. Does anyone have an idea of how to work around this without giving the users access to the base report (in Folder A)?
Thanks,
Richard
I am trying to get a simple SSRS Report containing a subreport to work in Sharepoint SSRS Integrated mode but have been unable to do so. I get "Error: Subreport could not be shown" message
The main report does nothing but host the subreport (if I get working, eventually main report will host multiple subreports (graphs))
In Visual Studio online help for Subreports I find:
Subreport
Type or select the name of the subreport to include in the report.
For a report published to a report server configured in SharePoint integrated mode, use a fully qualified URL including the file extension. Relative paths are not supported. For example, http://<SharePointservername>/<site>/Documents/Report1.rdl.
I have tried entering in the FQ URL, but Visual Studio will not compile the report then as it errors saying:
[rsInvalidReportNameCharacters] The ReportName for the subreport €˜TestSubReport€™ is not valid. Item names cannot contain the following reserved characters ;?&=+$,*<>|".
Any ideas??
Thanks
Since I had a bad error in replication, my replication monitor won't show the tab "Error details or messages of the select session".Â
I am not able to activate or to show this "tab", to get all information about my error.
I added two screeshots, one with the 3 tab, and the other, were the information about my error are missing. How i can my default view back?
Replication Monitor OK:
My Replication Monitor with missing tab:
I had to know, which ID is causing a primary key violation. Instead of Replication Monitor, I would use t-sql.
We have hidden few measure groups in cube for time being, where Users can browse the cube with Excel pivot. But, All these measures can be seen from Excel pivot in 'Show fields related to' drop down.
Need to remove the hidden measure groups from showing in Excel pivot and to remove 'All' option in 'Show Fields related to', So that users may not get confused by seeing all the measures. Can we achieve this.
I have a subreport within the details section of my main report. This is enclosed by a single group. When I preview the subreport alone, it diplays the subreport correctly with no data (meaning it still displays the header and footer without a detail section). When the subreport is run within the main report and no subreport data is returned the subreport does not show.
Based on other threads I understand that the default functionality is to display headers and footers when no data is returned. This appears accurate except on a subreport.
Hi,
I have some issues regarding subreports placed in table within body of a report.
I have a report Edit.rdl(functions as an Edit link) which is called in as a subreport in all Open Issues.rdl(Main Report)
When the same subreport is exported to excel then the following error message is displayed
'Subreports within table/matrix cells are ignored'.I tried to resolve this issue by first placing a list item in the table and then placing the subreport on top of List item but then the error mesage states that
'DataRegions within table/matrix cells are ignored'.
Your inputs will be of great help.
Thanks & Regards,
Kiran Kirdat
I have one report which has a list with subreports in it. If there is no data, I always got error " An internal error occurred on the report server. See the error log for more details". I tried the "NoRows" property, it didn't help either.
I noticed similar posts within this forum before, but haven't found the solution yet.
Could somebody shed some light on this?
Thanks!
Guohui
Here's my problem. I have a subreport that shows data and labels if data is returned. However, if no data is returned, the subreport doesn't show at all. I have a message on the subreport I would like to show if no data is returned, but the subreport won't show at all. Any ideas??
Thanks
Hi guys,
I have managed to pass a string parameter form the main report to the subreport with no problems, but when i try and use the same method to pass a datetime type, i am issued with the following error messase:
"[rsErrorExecutingSubreport] An error occurred while executing the subreport €˜SubReportName€™: The value provided for the report parameter 'MasterDate' is not valid for its type."
I cant see why it work for strings, but not for datetime. Any suggestions will be very much appreciated
Presently I have a main report and subreport, with the subreport having values for a carbon copy contact, which when it is displayed it shows these values:
Â
Peter Piper    #Error    #Error   peterpiper@mycompany.com    #Error
Donald Duck   #Error    #Error   donaldduck@mycompany.com   #Error
etc.
Â
When I run the subreport directly, it correctly returns all the values:
Â
Peter Piper    123-345-6789    Calgary   peterpiper@mycompany.com    T
Donald Duck   987-654-3210    Calgary  donaldduck@mycompany.com   F
Â
Here are the details on SQL Server 2008:
Â
Microsoft SQL Server 2008 (SP2) - 10.0.4064.0 (X64)  Feb 25 2011 13:56:11  Copyright (c) 1988-2008 Microsoft Corporation  Standard Edition (64-bit) on Windows NT 6.0 <X64> (Build 6002: Service Pack 2)Â
Â
why the #Error is showing up the the main report?
Hi every body
please tell me how I can show a user-friendly message in sql server instead of this kind of message:
Cannot insert explicit value for identity column in table 'Test' when IDENTITY_INSERT is set to OFF.
I don't want show the DBMS error to my clients. I want show a simple error instead of SQL error.
View 3 Replies View Related
I have an SSIS package set up to run various SQL scripts and to notify me if any of the SQL scripts fail. This is working fine, but when I get the email it only says that the script has failed. Is there any way to actually show the SQL result with the error in it? This would save me from having to go and manually run the script again to see the error message.
Thanks
Kate
In SQL 2000, the following message is logged to the NT event log every time the sp_configure 'show advanced options' command is executed. This did NOT occurr in SQL 7.
"Error: 15457, Severity: 0, State: 1
Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install."
Does anyone know if I can turn OFF the event logging of this message. It is confusing to the end users of our product that uses SQL 2000 as a back-end. Some of our product's code issues the sp_configure command that causes this message. It shows up as an informational message, but then the first word in the text is "Error:". I think I'll be getting a lot of support calls about this if I can't figure out a way to make it stop writting this to the event log :(
Any insight or suggestions would be most appreciated.
I can't install SQL 2005 Delveloper edition and show error with MSXML component
It shows these massage:
=== Verbose logging started: 6/11/2007 17:17:36 Build type: SHIP UNICODE 3.01.4000.4003 Calling process: C:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe ===
MSI (c) (A8:90) [17:17:36:545]: Resetting cached policy values
MSI (c) (A8:90) [17:17:36:545]: Machine policy value 'Debug' is 0
MSI (c) (A8:90) [17:17:36:545]: ******* RunEngine:
******* Product: \inwa202746-1GSQL Server x86ServersSetupmsxml6.msi
******* Action:
******* CommandLine: **********
MSI (c) (A8:90) [17:17:36:545]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (A8:90) [17:17:36:545]: Grabbed execution mutex.
MSI (c) (A8:90) [17:17:36:555]: Cloaking enabled.
MSI (c) (A8:90) [17:17:36:555]: Attempting to enable all disabled priveleges before calling Install on Server
MSI (c) (A8:90) [17:17:36:555]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (30:AC) [17:17:36:575]: Grabbed execution mutex.
MSI (s) (30:40) [17:17:36:575]: Resetting cached policy values
MSI (s) (30:40) [17:17:36:575]: Machine policy value 'Debug' is 0
MSI (s) (30:40) [17:17:36:575]: ******* RunEngine:
******* Product: \inwa202746-1GSQL Server x86ServersSetupmsxml6.msi
******* Action:
******* CommandLine: **********
MSI (s) (30:40) [17:17:36:675]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (30:40) [17:17:36:906]: Machine policy value 'DisableUserInstalls' is 0
MSI (s) (30:40) [17:17:37:176]: File will have security applied from OpCode.
MSI (s) (30:40) [17:17:39:119]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (s) (30:40) [17:17:39:269]: SOFTWARE RESTRICTION POLICY: Verifying package --> '\inwa202746-1GSQL Server x86ServersSetupmsxml6.msi' against software restriction policy
MSI (s) (30:40) [17:17:39:269]: SOFTWARE RESTRICTION POLICY: \inwa202746-1GSQL Server x86ServersSetupmsxml6.msi has a digital signature
MSI (s) (30:40) [17:17:41:702]: SOFTWARE RESTRICTION POLICY: \inwa202746-1GSQL Server x86ServersSetupmsxml6.msi is permitted to run at the 'unrestricted' authorization level.
MSI (s) (30:40) [17:17:41:702]: End dialog not enabled
MSI (s) (30:40) [17:17:41:702]: Original package ==> \inwa202746-1GSQL Server x86ServersSetupmsxml6.msi
MSI (s) (30:40) [17:17:41:702]: Package we're running from ==> C:WINDOWSInstaller3afbb9.msi
MSI (s) (30:40) [17:17:41:722]: APPCOMPAT: looking for appcompat database entry with ProductCode '{AEB9948B-4FF2-47C9-990E-47014492A0FE}'.
MSI (s) (30:40) [17:17:41:722]: APPCOMPAT: no matching ProductCode found in database.
MSI (s) (30:40) [17:17:41:722]: MSCOREE already loaded, using loaded copy
MSI (s) (30:40) [17:17:41:732]: Machine policy value 'TransformsSecure' is 0
MSI (s) (30:40) [17:17:41:732]: User policy value 'TransformsAtSource' is 0
MSI (s) (30:40) [17:17:41:732]: Note: 1: 2262 2: MsiFileHash 3: -2147287038
MSI (s) (30:40) [17:17:41:732]: Machine policy value 'DisablePatch' is 0
MSI (s) (30:40) [17:17:41:732]: Machine policy value 'AllowLockdownPatch' is 0
MSI (s) (30:40) [17:17:41:732]: Machine policy value 'DisableLUAPatching' is 0
MSI (s) (30:40) [17:17:41:732]: Machine policy value 'DisableFlyWeightPatching' is 0
MSI (s) (30:40) [17:17:41:732]: APPCOMPAT: looking for appcompat database entry with ProductCode '{AEB9948B-4FF2-47C9-990E-47014492A0FE}'.
MSI (s) (30:40) [17:17:41:732]: APPCOMPAT: no matching ProductCode found in database.
MSI (s) (30:40) [17:17:41:732]: Transforms are not secure.
MSI (s) (30:40) [17:17:41:732]: Command Line: STPSETUPTHREADID=3708 STPSETUPPROCESSID=424 EXTERNALCONTROL=1 ADDLOCAL=ALL SKIPPENDINGREBOOTCHECK=1 APPGUID={982DB00A-9C4E-436B-8707-18E113BAA44C} REBOOT=ReallySuppress CURRENTDIRECTORY=C:Program FilesMicrosoft SQL Server90Setup Bootstrap CLIENTUILEVEL=3 CLIENTPROCESSID=424
MSI (s) (30:40) [17:17:41:732]: PROPERTY CHANGE: Adding PackageCode property. Its value is '{A60D52F8-FAAB-4544-AF65-EAC1A22E5435}'.
MSI (s) (30:40) [17:17:41:732]: Product Code passed to Engine.Initialize: ''
MSI (s) (30:40) [17:17:41:732]: Product Code from property table before transforms: '{AEB9948B-4FF2-47C9-990E-47014492A0FE}'
MSI (s) (30:40) [17:17:41:732]: Product Code from property table after transforms: '{AEB9948B-4FF2-47C9-990E-47014492A0FE}'
MSI (s) (30:40) [17:17:41:732]: Product not registered: beginning first-time install
MSI (s) (30:40) [17:17:41:732]: PROPERTY CHANGE: Adding ProductState property. Its value is '-1'.
MSI (s) (30:40) [17:17:41:732]: Entering CMsiConfigurationManager:etLastUsedSource.
MSI (s) (30:40) [17:17:41:763]: User policy value 'SearchOrder' is 'nmu'
MSI (s) (30:40) [17:17:41:763]: Adding new sources is allowed.
MSI (s) (30:40) [17:17:41:763]: PROPERTY CHANGE: Adding PackagecodeChanging property. Its value is '1'.
MSI (s) (30:40) [17:17:41:763]: Package name extracted from package path: 'msxml6.msi'
MSI (s) (30:40) [17:17:41:763]: Package to be registered: 'msxml6.msi'
MSI (s) (30:40) [17:17:41:763]: Note: 1: 2262 2: AdminProperties 3: -2147287038
MSI (s) (30:40) [17:17:41:763]: Machine policy value 'DisableMsi' is 0
MSI (s) (30:40) [17:17:41:763]: Machine policy value 'AlwaysInstallElevated' is 0
MSI (s) (30:40) [17:17:41:763]: User policy value 'AlwaysInstallElevated' is 0
MSI (s) (30:40) [17:17:41:763]: Product installation will be elevated because user is admin and product is being installed per-machine.
MSI (s) (30:40) [17:17:41:763]: Running product '{AEB9948B-4FF2-47C9-990E-47014492A0FE}' with elevated privileges: Product is assigned.
MSI (s) (30:40) [17:17:41:763]: PROPERTY CHANGE: Adding STPSETUPTHREADID property. Its value is '3708'.
MSI (s) (30:40) [17:17:41:763]: PROPERTY CHANGE: Adding STPSETUPPROCESSID property. Its value is '424'.
MSI (s) (30:40) [17:17:41:763]: PROPERTY CHANGE: Adding EXTERNALCONTROL property. Its value is '1'.
MSI (s) (30:40) [17:17:41:763]: PROPERTY CHANGE: Adding ADDLOCAL property. Its value is 'ALL'.
MSI (s) (30:40) [17:17:41:763]: PROPERTY CHANGE: Adding SKIPPENDINGREBOOTCHECK property. Its value is '1'.
MSI (s) (30:40) [17:17:41:763]: PROPERTY CHANGE: Adding APPGUID property. Its value is '{982DB00A-9C4E-436B-8707-18E113BAA44C}'.
MSI (s) (30:40) [17:17:41:763]: PROPERTY CHANGE: Adding REBOOT property. Its value is 'ReallySuppress'.
MSI (s) (30:40) [17:17:41:763]: PROPERTY CHANGE: Adding CURRENTDIRECTORY property. Its value is 'C:Program FilesMicrosoft SQL Server90Setup Bootstrap'.
MSI (s) (30:40) [17:17:41:763]: PROPERTY CHANGE: Adding CLIENTUILEVEL property. Its value is '3'.
MSI (s) (30:40) [17:17:41:763]: PROPERTY CHANGE: Adding CLIENTPROCESSID property. Its value is '424'.
MSI (s) (30:40) [17:17:41:763]: TRANSFORMS property is now:
MSI (s) (30:40) [17:17:41:763]: PROPERTY CHANGE: Adding VersionDatabase property. Its value is '300'.
MSI (s) (30:40) [17:17:41:773]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminApplication Data
MSI (s) (30:40) [17:17:41:773]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminFavorites
MSI (s) (30:40) [17:17:41:773]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminNetHood
MSI (s) (30:40) [17:17:41:773]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminMy Documents
MSI (s) (30:40) [17:17:41:773]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminPrintHood
MSI (s) (30:40) [17:17:41:773]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminRecent
MSI (s) (30:40) [17:17:41:783]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminSendTo
MSI (s) (30:40) [17:17:41:783]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminTemplates
MSI (s) (30:40) [17:17:41:783]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAll UsersApplication Data
MSI (s) (30:40) [17:17:41:783]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminLocal SettingsApplication Data
MSI (s) (30:40) [17:17:41:783]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminMy DocumentsMy Pictures
MSI (s) (30:40) [17:17:41:783]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAll UsersStart MenuProgramsAdministrative Tools
MSI (s) (30:40) [17:17:41:783]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAll UsersStart MenuProgramsStartup
MSI (s) (30:40) [17:17:41:793]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAll UsersStart MenuPrograms
MSI (s) (30:40) [17:17:41:793]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAll UsersStart Menu
MSI (s) (30:40) [17:17:41:793]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAll UsersDesktop
MSI (s) (30:40) [17:17:41:793]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminStart MenuProgramsAdministrative Tools
MSI (s) (30:40) [17:17:41:793]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminStart MenuProgramsStartup
MSI (s) (30:40) [17:17:41:793]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminStart MenuPrograms
MSI (s) (30:40) [17:17:41:803]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminStart Menu
MSI (s) (30:40) [17:17:41:803]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminDesktop
MSI (s) (30:40) [17:17:41:803]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAll UsersTemplates
MSI (s) (30:40) [17:17:41:803]: SHELL32:HGetFolderPath returned: C:WINDOWSFonts
MSI (s) (30:40) [17:17:41:803]: Note: 1: 2898 2: MS Sans Serif 3: MS Sans Serif 4: 0 5: 16
MSI (s) (30:40) [17:17:41:803]: PROPERTY CHANGE: Adding Privileged property. Its value is '1'.
MSI (s) (30:40) [17:17:41:803]: Note: 1: 1402 2: HKEY_CURRENT_USERSoftwareMicrosoftMS Setup (ACME)User Info 3: 2
MSI (s) (30:40) [17:17:41:803]: PROPERTY CHANGE: Adding USERNAME property. Its value is 'Exact'.
MSI (s) (30:40) [17:17:41:803]: Note: 1: 1402 2: HKEY_CURRENT_USERSoftwareMicrosoftMS Setup (ACME)User Info 3: 2
MSI (s) (30:40) [17:17:41:803]: PROPERTY CHANGE: Adding COMPANYNAME property. Its value is 'Exact Software'.
MSI (s) (30:40) [17:17:41:803]: PROPERTY CHANGE: Adding DATABASE property. Its value is 'C:WINDOWSInstaller3afbb9.msi'.
MSI (s) (30:40) [17:17:41:803]: PROPERTY CHANGE: Adding OriginalDatabase property. Its value is '\inwa202746-1GSQL Server x86ServersSetupmsxml6.msi'.
MSI (s) (30:40) [17:17:41:803]: Note: 1: 2205 2: 3: PatchPackage
MSI (s) (30:40) [17:17:41:803]: Machine policy value 'DisableRollback' is 0
MSI (s) (30:40) [17:17:41:803]: User policy value 'DisableRollback' is 0
MSI (s) (30:40) [17:17:41:803]: PROPERTY CHANGE: Adding UILevel property. Its value is '2'.
=== Logging started: 6/11/2007 17:17:41 ===
MSI (s) (30:40) [17:17:41:803]: PROPERTY CHANGE: Adding Preselected property. Its value is '1'.
MSI (s) (30:40) [17:17:41:803]: PROPERTY CHANGE: Adding ACTION property. Its value is 'INSTALL'.
MSI (s) (30:40) [17:17:41:803]: Doing action: INSTALL
MSI (s) (30:40) [17:17:41:803]: Running ExecuteSequence
MSI (s) (30:40) [17:17:41:803]: Skipping action: SkipInstallCA (condition is false)
MSI (s) (30:40) [17:17:41:803]: Doing action: LaunchConditions
Action start 17:17:41: INSTALL.
Action start 17:17:41: LaunchConditions.
MSI (s) (30:40) [17:17:41:803]: Doing action: FindRelatedProducts
Action ended 17:17:41: LaunchConditions. Return value 1.
Action start 17:17:41: FindRelatedProducts.
MSI (s) (30:40) [17:17:41:813]: PROPERTY CHANGE: Adding NEWERFOUND.72DE5BCD_5CB0_4335_B118_AB4C4DA70AE1 property. Its value is '{A43BF6A5-D5F0-4AAA-BF41-65995063EC44}'.
MSI (s) (30:40) [17:17:41:813]: Skipping action: CA_SetRefCountUpgradeFlag (condition is false)
MSI (s) (30:40) [17:17:41:813]: Doing action: CA_SetRefCountNewerFoundFlag
Action ended 17:17:41: FindRelatedProducts. Return value 1.
MSI (s) (30:40) [17:17:41:813]: PROPERTY CHANGE: Adding NEWERFOUND999893F976BBB4A4DAD8F62CFA4D7C55 property. Its value is '1'.
Action start 17:17:41: CA_SetRefCountNewerFoundFlag.
MSI (s) (30:40) [17:17:41:813]: Doing action: IsPendingRebootKey
Action ended 17:17:41: CA_SetRefCountNewerFoundFlag. Return value 1.
MSI (s) (30:F8) [17:17:41:813]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI68.tmp, Entrypoint: IsPendingReboot
MSI (s) (30:1C) [17:17:41:813]: Generating random cookie.
MSI (s) (30:1C) [17:17:41:823]: Created Custom Action Server with PID 1832 (0x728).
MSI (s) (304) [17:17:41:873]: Running as a service.
MSI (s) (304) [17:17:41:873]: Hello, I'm your 32bit Impersonated custom action server.
Action start 17:17:41: IsPendingRebootKey.
No PendingFileRenameOperations
MSI (s) (30:40) [17:17:41:973]: Skipping action: CA_ErrorDifferentLang (condition is false)
MSI (s) (30:40) [17:17:41:973]: Skipping action: SetWOW (condition is false)
MSI (s) (30:40) [17:17:41:973]: Skipping action: SetWOWAppendCustomPath (condition is false)
MSI (s) (30:40) [17:17:41:973]: Skipping action: SetWOWINSTALLSQLSHAREDDIR_CUSTOMPATH (condition is false)
MSI (s) (30:40) [17:17:41:973]: Skipping action: SetWOWINSTALLSQLSHAREDDIR_CUSTOMPATH_ADD (condition is false)
MSI (s) (30:40) [17:17:41:973]: Doing action: Sqlmsirc_ValidateAppGuid_NewerFound.8AC30717_CC63_4611_9BB6_8CBCA668674D
Action ended 17:17:41: IsPendingRebootKey. Return value 1.
MSI (s) (30:50) [17:17:41:983]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI69.tmp, Entrypoint: Sqlmsirc_ValidateAppGuid
Action start 17:17:41: Sqlmsirc_ValidateAppGuid_NewerFound.8AC30717_CC63_4611_9BB6_8CBCA668674D.
<Func Name='Sqlmsirc_ValidateAppGuid'>
<EndFunc Name='Sqlmsirc_ValidateAppGuid' Return='0' GetLastError='0'>
MSI (s) (30:40) [17:17:42:003]: Doing action: Sqlmsirc_RefCountAppGuid_NewerFound.8AC30717_CC63_4611_9BB6_8CBCA668674D
Action ended 17:17:42: Sqlmsirc_ValidateAppGuid_NewerFound.8AC30717_CC63_4611_9BB6_8CBCA668674D. Return value 1.
MSI (s) (30:EC) [17:17:42:013]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI6A.tmp, Entrypoint: Sqlmsirc_RefCountAppGuid
Action start 17:17:42: Sqlmsirc_RefCountAppGuid_NewerFound.8AC30717_CC63_4611_9BB6_8CBCA668674D.
<Func Name='Sqlmsirc_RefCountAppGuid'>
<EndFunc Name='Sqlmsirc_RefCountAppGuid' Return='2' GetLastError='0'>
Action ended 17:17:42: Sqlmsirc_RefCountAppGuid_NewerFound.8AC30717_CC63_4611_9BB6_8CBCA668674D. Return value 3.
Action ended 17:17:42: INSTALL. Return value 3.
Property(S): ProductCode = {AEB9948B-4FF2-47C9-990E-47014492A0FE}
Property(S): Manufacturer = Microsoft Corporation
Property(S): ProductVersion = 6.00.3883.8
Property(S): ProductLanguage = 1033
Property(S): UpgradeCode = {1B117BA7-5BC1-419E-820E-7D4F3F412C7B}
Property(S): NEWERFOUND999893F976BBB4A4DAD8F62CFA4D7C55 = 1
Property(S): ARPPRODUCTICON = ARPIco
Property(S): PIDTemplate = 53934<````=````=````=````=`````>@@@@@
Property(S): PROMPTROLLBACKCOST = P
Property(S): DiskPrompt = [1]
Property(S): INSTALLLEVEL = 100
Property(S): ALLUSERS = 1
Property(S): InstallMode = Typical
Property(S): ErrorIcon = ErrorIco
Property(S): SuccessIcon = SuccessIco
Property(S): WarningIcon = WarningIco
Property(S): LicenseIcon = LicenseIco
Property(S): SetupIcon = SetupIco
Property(S): CompleteIcon = CompleteIco
Property(S): CustomIcon = CustomIco
Property(S): RepairIcon = RepairIco
Property(S): RemoveIcon = RemoveIco
Property(S): ModifyIcon = ModifyIco
Property(S): NewIcon = NewIco
Property(S): UpIcon = UpIco
Property(S): DialogBanner = BannerBmp
Property(S): WelcomeBmp = WelcomeBmp
Property(S): ApplicationUsers = AllUsers
Property(S): Details = 0
Property(S): AgreeToLicense = No
Property(S): _IsMaintenance = Reinstall
Property(S): _IsMaintenance2 = Modify
Property(S): ReinstallModeText = omus
Property(S): Display_IsBitmapDlg = 1
Property(S): Interrupted = 0
Property(S): ProductID = none
Property(S): ISENABLEDWUSFINISHDIALOG = 1
Property(S): SQLServerText1 = 0
Property(S): SQLServerVersionText1 = 0
Property(S): SQLServerVersionText2 = 0
Property(S): SQLServerVersionText3 = 0
Property(S): CA_ERRORCOUNT = 0
Property(S): CA_WARNINGCOUNT = 0
Property(S): CA_SUCCESSCOUNT = 0
Property(S): MINIMUMOS = true
Property(S): UI_SHOWCOPYRIGHT = yes
Property(S): ShowUserRegistrationDlg = 1
Property(S): ErrorDialog = ErrorDlg
Property(S): DefaultUIFont = Tahoma8
Property(S): NEWERFOUND.72DE5BCD_5CB0_4335_B118_AB4C4DA70AE1 = {A43BF6A5-D5F0-4AAA-BF41-65995063EC44}
Property(S): VersionNT = 501
Property(S): ARPHELPLINK = http://go.microsoft.com/fwlink/?LinkId=52156
Property(S): SecureCustomProperties = NEWERFOUND.72DE5BCD_5CB0_4335_B118_AB4C4DA70AE1;OLDERFOUND.72DE5BCD_5CB0_4335_B118_AB4C4DA70AE1;OLDERFOUND2.72DE5BCD_5CB0_4335_B118_AB4C4DA70AE1
Property(S): DesktopFolder = C:Documents and SettingsAll UsersDesktop
Property(S): ButtonTextStyle = {ButtonTextStyle}
Property(S): DlgTextStyle = {DlgTextStyle}
Property(S): DlgTextStyleB = {DlgTextStyleB}
Property(S): DlgTitleStyle = {DlgTitleStyle}
Property(S): DlgTitleStyleB = {DlgTitleStyleB}
Property(S): FixedStyle = {FixedStyle}
Property(S): COMPANYNAME = Exact Software
Property(S): USERNAME = Exact
Property(S): DialogTitleSetup = Setup
Property(S): DialogTitlePatch = Patch
Property(S): DialogTitleUpgrade = Upgrade
Property(S): Text_ArrowLeft = <
Property(S): Text_ArrowRight = >
Property(S): ButtonText_Next = Next
Property(S): ButtonText_Next_Hot = &Next
Property(S): ButtonText_Cancel = Cancel
Property(S): ButtonText_Cancel_Hot = &Cancel
Property(S): ButtonText_Back = Back
Property(S): ButtonText_Back_Hot = &Back
Property(S): ButtonText_Finish = Finish
Property(S): ButtonText_Finish_Hot = &Finish
Property(S): ButtonText_Update = Update >
Property(S): ButtonText_Update_Hot = &Update >
Property(S): ButtonText_Ok = OK
Property(S): ButtonText_Ok_Hot = &OK
Property(S): ButtonText_Yes = Yes
Property(S): ButtonText_Yes_Hot = &Yes
Property(S): ButtonText_No = No
Property(S): ButtonText_No_Hot = &No
Property(S): ButtonText_Abort = Abort
Property(S): ButtonText_Abort_Hot = &Abort
Property(S): ButtonText_Ignore = Ignore
Property(S): ButtonText_Ignore_Hot = &Ignore
Property(S): ButtonText_Retry = Retry
Property(S): ButtonText_Retry_Hot = &Retry
Property(S): ButtonText_Change = Change...
Property(S): ButtonText_Change_Hot = &Change...
Property(S): ButtonText_Help = Help
Property(S): ButtonText_Help_Hot = &Help
Property(S): ButtonText_Install = Install
Property(S): ButtonText_Install_Hot = &Install
Property(S): ButtonText_Exit = Exit
Property(S): ButtonText_Exit_Hot = &Exit
Property(S): ButtonText_Remove = Remove
Property(S): ButtonText_Remove_Hot = &Remove
Property(S): ButtonText_Space = Space
Property(S): ButtonText_Space_Hot = &Space
Property(S): ButtonText_Browse = Browse...
Property(S): ButtonText_Browse_Hot = Bro&wse...
Property(S): ButtonText_DiskCost = Disk Cost...
Property(S): ButtonText_DiskCost_Hot = &Disk Cost...
Property(S): LabelText_Status = Status
Property(S): LabelText_SerialNumber = &Serial Number:
Property(S): LabelText_UserName = &User Name
Property(S): LabelText_PersonName = Name
Property(S): LabelText_PersonOrganization = Company
Property(S): LabelText_InstallTo = Install to
Property(S): LabelText_Modify = &Modify
Property(S): LabelText_Repair = Re&pair
Property(S): LabelText_Remove = &Remove
Property(S): LabelText_Complete = &Complete
Property(S): LabelText_Custom = Cu&stom
Property(S): LabelText_NetworkLocation = &Network location:
Property(S): LabelText_LookIn = &Look in
Property(S): LabelText_FolderName = &Folder name
Property(S): LabelText_FeatureDescription = Feature description
Property(S): LabelText_CopyFilesFrom = Copy Files from
Property(S): LabelText_InstallFor = Install this application for
Property(S): HeadText_AdminWelcome = Welcome to the Install Wizard for
Property(S): HeadText_InstallWelcome = Welcome to the Install Wizard for
Property(S): HeadText_WelcomePatch = Welcome to the Patch for
Property(S): HeadText_SetupWelcome = Welcome to the
Property(S): HeadText_SetupWelcome2 = Setup
Property(S): HeadText_ResumeInstall = Resuming the Install Wizard for
Property(S): HeadText_SetupInterrupted = Setup Interrupted
Property(S): HeadText_LicenseAgreement = License Agreement
Property(S): HeadText_FeatureSelection = Feature Selection
Property(S): HeadText_NetworkLocation = Network Location
Property(S): HeadText_ProgramMaintenance = Program Maintenance
Property(S): HeadText_DiskSpaceRequirements = Disk Space Requirements
Property(S): HeadText_FilesInUse = Files in Use
Property(S): HeadText_DatabaseFolder = Database Folder
Property(S): HeadText_RegistrationInformation = Registration Information
Property(S): HeadText_CompletingSetup = Completing the
Property(S): HeadText_CompletingSetup2 = Setup
Property(S): HeadText_InstallingProduct = Installing
Property(S): HeadText_UninstallProduct = Uninstalling
Property(S): HeadText_ChangeDestinationFolder = Change Current Destination Folder
Property(S): HeadText_ReadyInstall = Ready to Install the Program
Property(S): HeadText_ReadyRepair = Ready to Repair the Program
Property(S): HeadText_ReadyModify = Ready to Modify the Program
Property(S): HeadText_RemoveProgram = Remove the Program
Property(S): HeadText_OutOfDiskSpace = Out of Disk Space
Property(S): DescText_FilesInUse = Some files that need to be updated are currently in use.
Property(S): DescText_RegistrationInformation = The following information will personalize your installation.
Property(S): DescText_ServerImage = Setup will create a server image of
Property(S): DescText_ServerImage2 = at a specified network location. To continue, click Next.
Property(S): DescText_InstallModifyRemove = Setup helps you install, modify or remove
Property(S): DescText_InstallModifyRemove2 = . To continue, click Next.
Property(S): DescText_PatchInstall = The Install Wizard will install the Patch for
Property(S): DescText_PatchInstall2 = on your computer. To continue, click Update.
Property(S): DescText_WizardComplete = The Install Wizard will complete the installation of
Property(S): DescText_WizardComplete2 = on your computer. To continue, click Next.
Property(S): DescText_CompleteSuspended = The Install Wizard will complete the suspended installation of
Property(S): DescText_CompleteSuspended2 = on your computer. To continue, click Next.
Property(S): DescText_SuccessfulInstallation = Setup has installed
Property(S): DescText_SuccessfulInstallation2 = successfully. Click Finish to exit.
Property(S): DescText_SuccessfulRemove = Setup has removed
Property(S): DescText_SuccessfulRemove2 = successfully. Click Finish to exit.
Property(S): DescText_SuccessfulRepair = Setup has repaired
Property(S): DescText_SuccessfulRepair2 = successfully. Click Finish to exit.
Property(S): DescText_SuccessfulModify = Setup has modified
Property(S): DescText_SuccessfulModify2 = successfully. Click Finish to exit.
Property(S): DescText_SetupInterrupted = Setup was interrupted before
Property(S): DescText_SetupInterrupted2 = could be completely installed.
Property(S): DescText_PreparingSetup = Setup is preparing the Install Wizard which will guide you through the program setup process. Please wait.
Property(S): DescText_FeatureSelection = Select the program features you want installed.
Property(S): DescText_ProgramFeaturesInstall = The program features you selected are being installed.
Property(S): DescText_ProgramFeaturesUninstall = The program features you selected are being uninstalled.
Property(S): DescText_ReadLicense = Please read the following license agreement carefully.
Property(S): DescText_SpecifyNetworkLocation = Specify a network location for the server image of the product.
Property(S): DescText_BrowseDestination = Browse to the destination folder.
Property(S): DescText_ModifyRepairRemove = Repair or remove the program.
Property(S): DescText_ReadyInstallation = Setup is ready to begin installation.
Property(S): DescText_ChosenRemove = You have chosen to remove the program from your system.
Property(S): DescText_DiskSpaceRequirements = The disk space required for the installation of the selected features.
Property(S): DescText_DiskExceedsAvailable = Disk space required for the installation exceeds available disk space.
Property(S): Text_ReRunSetup = Your system has not been modified. To complete installation at another time, please run setup again.
Property(S): Text_FinishExit = Click Finish to exit Setup.
Property(S): Text_RestoreState = You can either keep any existing installed elements on your system to continue this installation at a later time or you can restore your system to its original state prior to the installation.
Property(S): Text_RestoreClick = Click Restore or Continue Later to exit Setup.
Property(S): Text_InstallWait = Please wait while the Install Wizard installs
Property(S): Text_InstallWait2 = . This may take several minutes.
Property(S): Text_UninstallWaitText = Please wait while the Install Wizard uninstalls
Property(S): Text_UninstallWaitText2 = . This may take several minutes.
Property(S): Text_UninstallWait = Please wait while the Install Wizard uninstalls
Property(S): Text_UninstallWait2 = . This may take several minutes.
Property(S): Text_ProgressDone = Progress done
Property(S): Text_Copyright = WARNING: This program is protected by copyright law and international treaties.
Property(S): Text_BeginInstallation = Click Install to begin the installation.
Property(S): Text_ReviewChange = If you want to review or change any of your installation settings, click Back. Click Cancel to exit Setup.
Property(S): Text_AlterFeatureInstall = Click an icon in the following list to change how a feature is installed.
Property(S): Text_ConfirmExit = The installation is not yet complete. Are you sure you want to exit?
Property(S): Text_FeatureSelectionDescription = This feature requires 4 MB on your hard drive.
Property(S): Text_EnterNetworkLocation = Enter the network location or click Change to browse to a location. Click Install to create a server image of
Property(S): Text_EnterNetworkLocation2 = at the specified network location or click Cancel to exit Setup.
Property(S): Text_SelectDifferentDrive = The highlighted volumes do not have enough disk space available for the currently selected features. You can remove files from the highlighted volumes, choose to install less features onto local drives, or select different destination drives.
Property(S): Text_RepairInstallationErrors = Repair installation errors in the program. This option fixes missing or corrupt files, shortcuts, and registry entries.
Property(S): Text_RemoveFromComputer = Remove
Property(S): Text_RemoveFromComputer2 = from your computer.
Property(S): Text_UsingFilesRetry = The following applications are using files that need to be updated by this setup. Close these applications and click Retry to continue.
Property(S): Text_ClickRemove = Click Remove to remove
Property(S): Text_ClickRemove2 = from your computer. After removal, this program will no longer be available for use.
Property(S): Text_ReviewChangeBack = If you want to review or change any settings, click Back.
Property(S): Text_AllUsers = &Anyone who uses this computer (all users)
Property(S): Text_OnlyMe = Only for &me ([USERNAME])
Property(S): Text_NotAcceptTerms = I &do not accept the terms in the license agreement
Property(S): Text_AcceptTerms = I &accept the terms in the license agreement
Property(S): Text_RegInfoNameAndOrg = Enter your name and the name of your organization in the fields below.
Property(S): Text_RegInfoOrg = Enter the name of your organization in the field below.
Property(S): Upgrade_Confirmation = A lower version of this product has been detected on your system. Would you like to upgrade your existing installation?
Property(S): AdminMessage = Setup requires user to be in the administrator group in order to continue the installation process. Setup is aborting as the current user is not in the administrator group.
Property(S): SupportedOSMessage = Installation of this product failed because it is not supported on this operating system. For information on supported configurations, see the product documentation.
Property(S): ShortCutText = MSXML 6.0
Property(S): DialogTitle = MSXML 6.0 Parser Setup
Property(S): ProductName = MSXML 6.0 Parser
Property(S): ShortName = MSXML 6.0 Parser
Property(S): WrongPackage = This MSXML6.0 package is not supported on the current processor type.
Property(S): DialogPatchTitle = MSXML 6.0 Parser Patch
Property(S): SystemFolder = C:WINDOWSsystem32
Property(S): WdSfpCaMainModId.41646F16_4E6C_4E96_BF1B_772105414B9D = 86F857F6_A743_463D_B2FE_98CB5F727E09
Property(S): AppGuidRegKey = Wdsfpca_Uninstall_RegKey.86F857F6_A743_463D_B2FE_98CB5F727E09
Property(S): PackageCode = {A60D52F8-FAAB-4544-AF65-EAC1A22E5435}
Property(S): ProductState = -1
Property(S): PackagecodeChanging = 1
Property(S): STPSETUPTHREADID = 3708
Property(S): STPSETUPPROCESSID = 424
Property(S): EXTERNALCONTROL = 1
Property(S): ADDLOCAL = ALL
Property(S): SKIPPENDINGREBOOTCHECK = 1
Property(S): APPGUID = {982DB00A-9C4E-436B-8707-18E113BAA44C}
Property(S): REBOOT = ReallySuppress
Property(S): CURRENTDIRECTORY = C:Program FilesMicrosoft SQL Server90Setup Bootstrap
Property(S): CLIENTUILEVEL = 3
Property(S): CLIENTPROCESSID = 424
Property(S): VersionDatabase = 300
Property(S): VersionMsi = 3.01
Property(S): WindowsBuild = 2600
Property(S): ServicePackLevel = 2
Property(S): ServicePackLevelMinor = 0
Property(S): MsiNTProductType = 1
Property(S): WindowsFolder = C:WINDOWS
Property(S): WindowsVolume = C:
Property(S): System16Folder = C:WINDOWSsystem
Property(S): RemoteAdminTS = 1
Property(S): TempFolder = C:DOCUME~1AdminLOCALS~1Temp
Property(S): ProgramFilesFolder = C:Program Files
Property(S): CommonFilesFolder = C:Program FilesCommon Files
Property(S): AppDataFolder = C:Documents and SettingsAdminApplication Data
Property(S): FavoritesFolder = C:Documents and SettingsAdminFavorites
Property(S): NetHoodFolder = C:Documents and SettingsAdminNetHood
Property(S): PersonalFolder = C:Documents and SettingsAdminMy Documents
Property(S): PrintHoodFolder = C:Documents and SettingsAdminPrintHood
Property(S): RecentFolder = C:Documents and SettingsAdminRecent
Property(S): SendToFolder = C:Documents and SettingsAdminSendTo
Property(S): TemplateFolder = C:Documents and SettingsAll UsersTemplates
Property(S): CommonAppDataFolder = C:Documents and SettingsAll UsersApplication Data
Property(S): LocalAppDataFolder = C:Documents and SettingsAdminLocal SettingsApplication Data
Property(S): MyPicturesFolder = C:Documents and SettingsAdminMy DocumentsMy Pictures
Property(S): AdminToolsFolder = C:Documents and SettingsAll UsersStart MenuProgramsAdministrative Tools
Property(S): StartupFolder = C:Documents and SettingsAll UsersStart MenuProgramsStartup
Property(S): ProgramMenuFolder = C:Documents and SettingsAll UsersStart MenuPrograms
Property(S): StartMenuFolder = C:Documents and SettingsAll UsersStart Menu
Property(S): FontsFolder = C:WINDOWSFonts
Property(S): GPTSupport = 1
Property(S): OLEAdvtSupport = 1
Property(S): ShellAdvtSupport = 1
Property(S): Intel = 6
Property(S): PhysicalMemory = 1023
Property(S): VirtualMemory = 2183
Property(S): AdminUser = 1
Property(S): LogonUser = Administrator
Property(S): UserSID = S-1-5-21-842925246-1580818891-1957994488-500
Property(S): UserLanguageID = 1033
Property(S): ComputerName = CHUN107907-1
Property(S): SystemLanguageID = 1054
Property(S): ScreenX = 1024
Property(S): ScreenY = 768
Property(S): CaptionHeight = 25
Property(S): BorderTop = 1
Property(S): BorderSide = 1
Property(S): TextHeight = 16
Property(S): ColorBits = 32
Property(S): TTCSupport = 1
Property(S): Time = 17:17:42
Property(S): Date = 6/11/2007
Property(S): MsiNetAssemblySupport = 2.0.50727.42
Property(S): MsiWin32AssemblySupport = 5.1.2600.3019
Property(S): RedirectedDllSupport = 2
Property(S): Privileged = 1
Property(S): DATABASE = C:WINDOWSInstaller3afbb9.msi
Property(S): OriginalDatabase = \inwa202746-1GSQL Server x86ServersSetupmsxml6.msi
Property(S): UILevel = 2
Property(S): Preselected = 1
Property(S): ACTION = INSTALL
MSI (s) (30:40) [17:17:42:093]: Note: 1: 1708
MSI (s) (30:40) [17:17:42:093]: Product: MSXML 6.0 Parser -- Installation failed.
MSI (s) (30:40) [17:17:42:093]: Cleaning up uninstalled install packages, if any exist
MSI (s) (30:40) [17:17:42:093]: MainEngineThread is returning 1603
MSI (s) (30:AC) [17:17:42:193]: Destroying RemoteAPI object.
MSI (s) (30:1C) [17:17:42:193]: Custom Action Manager thread ending.
=== Logging stopped: 6/11/2007 17:17:42 ===
MSI (c) (A8:90) [17:17:42:193]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (A8:90) [17:17:42:193]: MainEngineThread is returning 1603
=== Verbose logging stopped: 6/11/2007 17:17:42 ===
Two of my databases are still listed under the "Database" folder in SQL Express, yet all objects are now gone. Tried detach/attach and says it works OK - yet no tables, etc.
The odd thing is that I CAN access the tables from Visual C++ Express, and all looks well (data, etc).
When I look at Properties for one of the DBs, and then click on "View Connection Properties" under the "Options" section, the error message pops up:
"Cannot show requested dialog.----------------------------
ADDITIONAL INFORMATION:
Could not load file or assembly 'file:///C:Program FilesMicrosoft SQL Server90ToolsBinnVSShellCommon7IDESqlManagerUi.dll' or one of its dependencies. The system cannot find the file specified. (mscorlib) ".
/////////////////////////////////////////////////////////////////////////////////
Also still throwing an error upon startup, "Unhandled exception has occurred in a component in your application. If you click continue the application will ignore this error...Cannot create a stable subkey under a volatile parent"
Clues?
Thanks
S
PS It would help to enable right click Copy and Paste in this forum -
Why does Error log show database restarting everytime a transactionlog backup runs?It also runs a checkdb as well.The log backups are scheduled through a maintenance plan.Is this normal?
View 1 Replies View RelatedI'm developing a database-driven program using SQL server 2000 and Visual Basic 2005.
Most of the guys say professional programming is doing the validation stuff (such as the constraints and data integrity stuff like" [0-9][1] " and the use of LIKE IN keywords etc.) in the databse itself.
say i did the data validation contraints in SQL server itself. and now i connect the database with the interface made in 2005. and say a person enters some invalid data through the interface. but the error messages are generated by SQL server. how am i to display the SQL server generated error messages in the VB made interface??
PLS HELP ME .. if the question is not clear pls tell so that i can explain it further.
PLS PLS PLS HELP ME
I'm developing a database-driven program using SQL server 2000 and Visual Basic 2005.
Most of the guys say professional programming is doing the validation stuff (such as the constraints and data integrity stuff like" [0-9][1] " and the use of LIKE IN keywords etc.) in the databse itself.
say i did the data validation contraints in SQL server itself. and now i connect the database with the interface made in 2005. and say a person enters some invalid data through the interface. but the error messages are generated by SQL server. how am i to display the SQL server generated error messages in the VB made interface??
PLS HELP ME .. if the question is not clear pls tell so that i can explain it further.
PLS PLS PLS HELP ME
I am trying to create a report with a sub report in Sql Server 2012 using Report Builder Version 3. Â I can run the subreport without any problems. Â I read where using a shared connection can cause this error so both the main report and the subreport use a connection that is embedded in my report. Â
For testing, I created the subreport without a parameter and added it to the main report. Â When I ran it that way, the report worked and sub report displayed the data. Â So I know it can read from the database.It seems to only give me this error when I am trying to tie the two reports together using a parameter. Â
Using SSRS 2014 and VS2013 rc5.
How do I hide a subreport if the parent report row containing the subreport is a certain value? I am attempting to create a statement with ageing buckets. In the main body of the report I have to display payments and invoices. If the invoice row is blank, I need to hide the row containing the subreport.
First, Is this even possible?
Second, How?
Hi,
I have a report which contains a subreport placed inside a list. when the subreport returns no data. it appears as a blank space in the main report. So i want to suppress the list when the subreport returns no data. Can somebody help me with this?
thanks
shri
Hi all,
I was wondering whether there is a way to show the user an error when the user did not select a specific parameter.
In my case, I have two optional parameters. The user has to select either one to view the report. If the user does not select either one, I would like to show some sort of an error page indicating so. However, all i am getting is a complete blank with no report in sight. I as a developer know this is an error as a result of missing parameters, but i was wondering whether I could produce a page or direct it to a page so that the user doesn't go all horrified at an empty page ?
Thanks
Bernard
I'm currently receiving the following error message whilst attempting to install SQL Server 2005 Standard Edition on Windows Server 2003 (32 Bit):
Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: The system cannot find the file specified.
This server already has an install of SQL Server 2000 as the default instance. I'm attempting to install a new named instance of SQL Server 2005.
Extract from log:
<Func Name='LaunchFunction'>
Function=Do_sqlPerfmon2
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='0'>
Doing Action: Do_sqlPerfmon2
PerfTime Start: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007
<Func Name='Do_sqlPerfmon2'>
<EndFunc Name='Do_sqlPerfmon2' Return='0' GetLastError='2'>
PerfTime Stop: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007
MSI (s) (4C:FC) [10:20:02:833]: Executing op: ActionStart(Name=Rollback_Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Removing performance counters,)
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (4C:FC) [10:20:02:849]: Executing op: CustomActionSchedule(Action=Rollback_Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1281,Source=BinaryData,Target=Rollback_Do_sqlPerfmon2,CustomActionData=100Removing performance counters200000DTSPipelineC:Program FilesMicrosoft SQL Server90DTSBinnDTSPERF.INI)
MSI (s) (4C:FC) [10:20:02:849]: Executing op: ActionStart(Name=Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Installing performance counters,)
MSI (s) (4C:FC) [10:20:02:849]: Executing op: CustomActionSchedule(Action=Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_sqlPerfmon2,CustomActionData=100Installing performance counters200000C:Program FilesMicrosoft SQL Server90DTSBinnDTSPERF.INIC:Program FilesMicrosoft SQL Server90DTSBinnDTSPERF.HC:Program FilesMicrosoft SQL Server90DTSBinnDTSPipelinePerf.dllDTSPipeline0DTSPipelinePrfData_OpenPrfData_CollectPrfData_Close)
MSI (s) (4C:94) [10:20:02:864]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI1683.tmp, Entrypoint: Do_sqlPerfmon2
<Func Name='LaunchFunction'>
Function=Do_sqlPerfmon2
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='0'>
Doing Action: Do_sqlPerfmon2
PerfTime Start: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007
<Func Name='Do_sqlPerfmon2'>
<EndFunc Name='Do_sqlPerfmon2' Return='2' GetLastError='2'>
PerfTime Stop: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007
Gathering darwin properties for failure handling.
Error Code: 2
MSI (s) (4C!F0) [10:23:46:381]: Product: Microsoft SQL Server 2005 Integration Services -- Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: The system cannot find the file specified.Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: The system cannot find the file specified.
You can ignore this and it will complete the installation, but subsequently trying to patch with SP2 will fail on the same sections - Hotfix.exe crashes whilst attempting to patch Database Services, Integration Services and Client Components (3 separate crashes).
I've removed SQL Server 2005 elements and tried to re-install, but it's not improved the situation.
Any ideas?
Hi -
I have an File System Task that copies a file from one directory ot another. When I hard code the target directory (c:dirfile.txt) it works fine. When I change it to a virtual directory (\serverdirfile.txt) I get a security error:
[File System Task] Error: An error occurred with the following error message: "Access to the path '\gracehbtest oS2TMM_Live_Title_000002.xml' is denied.".
Where do I change the security settings?
Thanks - Grace
I cannot execute a package by using Execute Package task.
I supplied sa credentials to connection manager, and it shows the list of Packages on SQL Server but when running the task it says
Error 0xC0202009 while preparing to load the package. An OLE DB error has occurred. Error code: 0x%1!8.8X!.
Any clue ?
Thanks,
Fahad