I migrated my system from SQL2000 to SQL2005, now my MDX reports don't want to work with the data-driven subscriptions. The SQL reports run fine.
Any help, comments, or even suggestions will be very welcome.
Kind Regards
Carel Greaves
Hi,
Is the SSAS also 2005 or is it 2000?
|||What do you have in the RS windows service logfile <Program Files>\Microsoft SQL Server\MSSQL.#\Reporting Services\LogFiles\ReportServerService__<timestamp>.log at the time when DD subscription fires?|||SSAS is also 2005, i had a problem with the cubes before SP1 was released, but after SP! the Cubes and SSAS 2005 seems to be working fine|||There are two log files there so i pasted both for you
<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.2047.00</Product>
<Locale>en-US</Locale>
<TimeZone>South Africa Standard Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServer__11_22_2006_00_04_51.log</Path>
<SystemName>FORGE2005</SystemName>
<OSName>Microsoft Windows NT 5.2.3790 Service Pack 1</OSName>
<OSVersion>5.2.3790.65536</OSVersion>
</Header>
w3wp!library!7!11/22/2006-00:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-00:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-00:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-00:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-00:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-00:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-01:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-01:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-01:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-01:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-01:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-01:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-02:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-02:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-02:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-02:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-02:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-02:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-03:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-03:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-03:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-03:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-03:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-03:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-04:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-04:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-04:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-04:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-04:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-04:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-05:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-05:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-05:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-05:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-05:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-05:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-06:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-06:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-06:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-06:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-06:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-06:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-07:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-07:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-07:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-07:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-07:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-07:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-08:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-08:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-08:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-08:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-08:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-08:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-09:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-09:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-09:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-09:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-09:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-09:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-10:00:33:: i INFO: Call to GetSystemPermissions
w3wp!library!7!11/22/2006-10:00:34:: i INFO: Call to GetSystemPermissions
w3wp!library!1!11/22/2006-10:00:36:: i INFO: Call to GetSystemPermissions
w3wp!library!8!11/22/2006-10:01:15:: i INFO: Call to GetSystemPermissions
w3wp!library!8!11/22/2006-10:01:15:: i INFO: Call to ListTasks
w3wp!library!6!11/22/2006-10:01:15:: i INFO: Call to GetRoleProperties:System Administrator
w3wp!library!6!11/22/2006-10:01:24:: i INFO: Call to SetRoleProperties:System Administrator
w3wp!library!8!11/22/2006-10:01:27:: i INFO: Call to GetSystemPermissions
w3wp!library!8!11/22/2006-10:01:27:: i INFO: Call to ListTasks
w3wp!library!8!11/22/2006-10:01:27:: i INFO: Call to GetRoleProperties:System User
w3wp!library!8!11/22/2006-10:01:28:: i INFO: Call to SetRoleProperties:System User
w3wp!library!7!11/22/2006-10:01:39:: i INFO: Call to GetSystemPermissions
w3wp!library!7!11/22/2006-10:01:40:: i INFO: Call to GetSystemPermissions
w3wp!library!7!11/22/2006-10:01:59:: i INFO: Call to GetPermissions:/FutureCOM/90-10 Report
w3wp!library!7!11/22/2006-10:01:59:: i INFO: Call to GetPermissions:/FutureCOM/90-10 Report
w3wp!library!8!11/22/2006-10:02:00:: i INFO: Call to GetSystemPermissions
w3wp!library!1!11/22/2006-10:02:11:: i INFO: Call to GetPermissions:/FutureCOM/90-10 Report
w3wp!library!8!11/22/2006-10:02:11:: i INFO: Call to GetPermissions:/FutureCOM/90-10 Report
w3wp!library!1!11/22/2006-10:02:12:: i INFO: Call to GetSystemPermissions
w3wp!library!8!11/22/2006-10:02:20:: i INFO: Call to GetPermissions:/FutureCOM/90-10 Report
w3wp!library!8!11/22/2006-10:02:22:: i INFO: Call to GetPermissions:/FutureCOM/90-10 Report
w3wp!library!1!11/22/2006-10:02:22:: i INFO: Call to ListHistory( '/FutureCOM/90-10 Report' )
w3wp!library!7!11/22/2006-10:02:23:: i INFO: Call to GetPermissions:/FutureCOM/90-10 Report
w3wp!library!8!11/22/2006-10:02:23:: i INFO: Call to GetPermissions:/FutureCOM/90-10 Report
w3wp!library!8!11/22/2006-10:02:24:: i INFO: Call to GetSystemPermissions
w3wp!library!1!11/22/2006-10:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-10:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-10:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-10:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-10:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-10:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-11:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-11:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-11:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-11:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-11:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-11:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-12:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-12:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-12:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-12:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!webserver!6!11/22/2006-12:36:42:: i INFO: Reporting Web Server stopped
And the Second one is:
<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.2047.00</Product>
<Locale>en-US</Locale>
<TimeZone>South Africa Standard Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServerWebApp__11_21_2006_07_34_32.log</Path>
<SystemName>FORGE2005</SystemName>
<OSName>Microsoft Windows NT 5.2.3790 Service Pack 1</OSName>
<OSVersion>5.2.3790.65536</OSVersion>
</Header>
w3wp!library!1!11/21/2006-07:34:33:: i INFO: Initializing ReportBuilderTrustLevel to '0' as specified in Configuration file.
w3wp!library!1!11/21/2006-07:34:33:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!1!11/21/2006-07:34:33:: i INFO: Initializing MaxScheduleWait to default value of '1' second(s) because it was not specified in Configuration file.
w3wp!library!1!11/21/2006-07:34:33:: i INFO: Initializing DatabaseQueryTimeout to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!11/21/2006-07:34:33:: i INFO: Initializing ProcessRecycleOptions to default value of '0' because it was not specified in Configuration file.
w3wp!library!1!11/21/2006-07:34:33:: i INFO: Initializing RunningRequestsScavengerCycle to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!11/21/2006-07:34:33:: i INFO: Initializing RunningRequestsDbCycle to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!11/21/2006-07:34:33:: i INFO: Initializing RunningRequestsAge to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!11/21/2006-07:34:33:: i INFO: Initializing CleanupCycleMinutes to default value of '10' minute(s) because it was not specified in Configuration file.
w3wp!library!1!11/21/2006-07:34:33:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!1!11/21/2006-07:34:33:: i INFO: Initializing WatsonFlags to default value of '1064' because it was not specified in Configuration file.
w3wp!library!1!11/21/2006-07:34:33:: i INFO: Initializing WatsonDumpOnExceptions to default value of 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' because it was not specified in Configuration file.
w3wp!library!1!11/21/2006-07:34:33:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to default value of 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' because it was not specified in Configuration file.
w3wp!library!1!11/21/2006-07:34:33:: i INFO: Initializing SecureConnectionLevel to default value of '1' because it was not specified in Configuration file.
w3wp!library!1!11/21/2006-07:34:33:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!1!11/21/2006-07:34:33:: i INFO: Initializing WebServiceUseFileShareStorage to default value of 'False' because it was not specified in Configuration file.|||Unfortunately these logs are not what I asked. This is from the webserver log, but subscription execution error if any gets written into the RS windows service log file named ReportServerService__<timestamp>.log. Also you don’t need to copy the whole log file contents - find entries (by timestamp in each entry) where you expect subscription to fire and copy entries with errors if any are present.|||Sorry about that Igor, but i have just gone through all the logs and it seems that as soon as it starts to give the error then it stops logging on the Log File, otherwise i would have most likely read what the error was and tried to fix it or at least have posted a better description of what is happening. Do you perhaps have any other suggestions for me?
Kind Regards|||Here is my Stored Proc that i use to run the reports in a batch along with an error that i got in the log file, perhaps there is something here that you could find missing, although this stored proc worked perfectly in SQL2000:
The error below has a problem with month, but i tried to pass it the value of <Month> and of <monthNumber>
--My Stored Procedure
set ANSI_NULLS ON
set QUOTED_IDENTIFIER OFF
GO
-- ******************************************************************
-- FSP GET SCHEDULE PARAMETERS
-- Returns a ful list of clients forthe reporting services schedules
--
-- TEST
-- fsp_GetScheduleParameters
-- ******************************************************************
ALTER PROCEDURE [dbo].[fsp_GetScheduleParametersOriginal]
AS
BEGIN
SELECT '[Client].[All Client].[' + LTRIM(RTRIM(Province)) + ']' AS [@.paramProvince],
'[Client].[All Client].[' + LTRIM(RTRIM(Province)) + '].[' + LTRIM(RTRIM(City)) + ']' AS [@.paramCity],
'[Client].[All Client].[' + LTRIM(RTRIM(Province)) + '].[' + LTRIM(RTRIM(City)) + '].[' + RTRIM(Client_Name) + ']' AS [@.Client],
dbo.fnc_GetSubscriptionYear(GetDate()) AS [Year],
dbo.fnc_GetSubscriptionMonth(GetDate()) AS [Month],
'd:\Reporting Services Output\' + Client_SerialNo AS [FileName],
LTRIM(RTRIM(Province)) AS [ProvinceName],
LTRIM(RTRIM(City)) AS [CityName],
Client_KEY AS [ClientKEY],
dbo.fnc_GetSubscriptionMonthNumber(GetDate()) AS [MonthNumber]
FROM dbo.DIM_Client
WHERE Client_KEY IN (2)
--WHERE Client_KEY NOT IN (7, 8, 9, 10, 11, 12, 21, 55, 56, 57, 58, 59, 60, 62)
ORDER BY Client_SerialNo
END
One RUN on two reports: ERROR
1/10/2007 7:32:10 AM.
ReportingServicesService!dbpolling!d!1/10/2007-07:32:10:: EventPolling finished processing item fab79ac0-b671-4455-9052-4797819e7f82
ReportingServicesService!dbpolling!a!1/10/2007-07:32:10:: EventPolling processing 2 more items. 2 Total items in internal queue.
ReportingServicesService!dbpolling!d!1/10/2007-07:32:10:: EventPolling processing item 74701900-4bcc-4228-8dbd-fe9fa6f5a892
ReportingServicesService!dbpolling!f!1/10/2007-07:32:10:: EventPolling processing item da61a67f-7f25-4a5b-85ed-b91bcc919615
ReportingServicesService!dbpolling!d!1/10/2007-07:32:10:: EventPolling finished processing item 74701900-4bcc-4228-8dbd-fe9fa6f5a892
ReportingServicesService!dbpolling!f!1/10/2007-07:32:10:: EventPolling finished processing item da61a67f-7f25-4a5b-85ed-b91bcc919615
ReportingServicesService!dbpolling!a!1/10/2007-07:32:10:: NotificationPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!f!1/10/2007-07:32:10:: NotificationPolling processing item a9a25328-7fd8-4882-848b-fd9feded8f30
ReportingServicesService!library!f!01/10/2007-07:32:10:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportParameterException: Default value or value provided for the report parameter 'Month' is not a valid value., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportParameterException: Default value or value provided for the report parameter 'Month' is not a valid value.
ReportingServicesService!notification!f!01/10/2007-07:32:10:: Notification a9a25328-7fd8-4882-848b-fd9feded8f30 completed. Success: False, Status: , DeliveryExtension: Report Server FileShare, Report: Unscanned Totals, Attempt 0
ReportingServicesService!dbpolling!f!01/10/2007-07:32:10:: NotificationPolling finished processing item a9a25328-7fd8-4882-848b-fd9feded8f30
ReportingServicesService!dbpolling!a!1/10/2007-07:32:10:: NotificationPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!d!1/10/2007-07:32:10:: NotificationPolling processing item ff57f016-470c-49d8-82db-30001b7f7fc9
ReportingServicesService!library!d!01/10/2007-07:32:11:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportParameterException: Default value or value provided for the report parameter 'Month' is not a valid value., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportParameterException: Default value or value provided for the report parameter 'Month' is not a valid value.
ReportingServicesService!notification!d!01/10/2007-07:32:11:: Notification ff57f016-470c-49d8-82db-30001b7f7fc9 completed. Success: False, Status: , DeliveryExtension: Report Server FileShare, Report: Assistant Activity Log Disp, Attempt 0
ReportingServicesService!dbpolling!d!01/10/2007-07:32:11:: NotificationPolling finished processing item ff57f016-470c-49d8-82db-30001b7f7fc9|||Have you checked that value returned for Month is within the valid range as it's defined by your report?|||I managed to track down my problem and there were a few, so if anyone is sitting with the same problem then please try to follow.
My reports read their path to place them from the stored procedure under d:\reporting services output\<client_serial> which is incorrect, i had to change that to a mapped path because reporting services requests a URL for a path to place the created reports, so i mapped a folder on my server and changed the path to \\reporting services output
Concerning my MDX reports, there is still a major flaw in Microsoft's design referring to the space handling in MDX
My MDX reports wouldn't build with the data-driven subscriptions because i had lines between my code such as:
CODE ASD:LKADL:ASJDLAS:JDSA:JDKLA
MORE CODE ASDL:KD:ASJD:SAJDL:ASJDSKL
MORE CODE ASDKJAHSFKLFHDAKLJHDKLJHDFLA
it should have just been without the spaces: - Weird i know, but that was a major problem for me why my Data-driven subscription wouldn't build my MDX reports
CODE ASD:LKADL:ASJDLAS:JDSA:JDKLA
MORE CODE ASDL:KD:ASJD:SAJDL:ASJDSKL
MORE CODE ASDKJAHSFKLFHDAKLJHDKLJHDFLA
I hope that this will help other people in the future that have or had the same problem:
Kind Regards
Carel Greaves|||
Hi All
I have the same error...
ReportingServicesService!library!1a40!02/28/2007-17:51:05:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportParameterException: Default value or value provided for the report parameter 'servco_no' is not a valid value., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportParameterException: Default value or value provided for the report parameter 'servco_no' is not a valid value.
Eagle1984, I don't understand... Which code are you talking about? I have an xml page and stored procedures, I think that's all.
Can you please be more explient? Thank you.
Regards,
Thomas.
|||Hi Thomas, please explain your whole problem to me and what u are trying to find out or do then i might be able to help you out.Kind Regards
Carel Greaves
