SCMDM08_ResourceKit_Reports_x64_V2_0 multiple fails in Process the Initial Set of Data

Mon, 29 Jun 2009 09:19:03 Z

Hello, I'm trying use the reporting services of SCMDM 2008 sp1. The installation completed successfully, but when I start the job MDMRPTSSISJob, this fails:
Log Job History (MDMRPTSSISJob)

Step ID  1
Server  REPPILOTMDM
Job Name  MDMRPTSSISJob
Step Name  MDMStaging
Duration  00:00:03
Sql Severity  0
Sql Message ID  0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted  0

Message
Executed as user: pilotoscmdm\administrator. ...42.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Started: 9:33:13 Error: 2009-06-29 09:33:15.56     Code: 0xC0202009     Source: DF_ME_EnrolmentLog Get EnrolmentLog [1]     Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E21. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E21 Description: "Invalid character value for cast specification". End Error Error: 2009-06-29 09:33:15.58     Code: 0xC004701A     Source: DF_ME_EnrolmentLog DTS.Pipeline     Description: component "Get EnrolmentLog" (1) failed the pre-execute phase and returned error code 0xC0202009. End Error Error: 2009-06-29 09:33:15.80     Code: 0xC0202009     Source: Load TEEDB_vw_TaskOperationResult Get TaskOperationResults [1]     Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80... The package execution fa... The step failed.

The Job fail in the first step (MDMStaging) and not continue, if I modify the properties (on failure action) it fail but continue executing the next steps, after it fail in ADDevice:

Date  29/06/2009 11:02:48
Log  Job History (MDMRPTSSISJob)

Step ID  4
Server  REPPILOTMDM
Job Name  MDMRPTSSISJob
Step Name  ADDevice
Duration  00:00:02
Sql Severity  0
Sql Message ID  0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted  0

Message
Executed as user: pilotoscmdm\administrator. Microsoft (R) SQL Server Execute Package Utility Version 9.00.3042.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 11:02:48 Error: 2009-06-29 11:02:49.69 Code: 0x00000002 Source: GetDeviceDetails Description: The script threw an exception: The statement has been terminated. The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 11:02:48 Finished: 11:02:49 Elapsed: 1.062 seconds. The package execution failed. The step failed.

And after in EvenLogPull (I've opend the ports in the firewall an use administrator acount for the gateway connection):

Message
Executed as user: pilotoscmdm\administrator. Microsoft (R) SQL Server Execute Package Utility Version 9.00.3042.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 11:05:34 Error: 2009-06-29 11:06:20.49 Code: 0x00000002 Source: Pull Event Logs For Each Gateway Description: The script threw an exception: The statement has been terminated. The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 11:05:34 Finished: 11:06:20 Elapsed: 45.64 seconds. The package execution failed. The step failed.

I'm using two DB servers, one with MDM DB an other for SSRS and SSIS, all run over WS 2003 sp2 x64 and SQL server 2005 SP2 x64.
In the reporting server I've installed the all software with the Administrator acount and configured the SQL services for run with the Administrator Acount.

Thank you very much

SCMDM08_ResourceKit_Reports_x64_V2_0 multiple fails in Process the Initial Set of Data

Mon, 29 Jun 2009 09:33:03 Z

Uff, after one week trying solve it I've found part of the problem, I'm use the Spanish reginal settings, I've changed the format of the date from spanish format dd/mm/yyyy to yyyy/mm/dd and it run, only persist the problem with MDMStaging step.

any suggestions?

thankyou

SCMDM08_ResourceKit_Reports_x64_V2_0 multiple fails in Process the Initial Set of Data

Tue, 30 Jun 2009 00:02:05 Z

There can be issues if you don’t run everything in US English or your Local Language. Since this is a pilot system, could you try running this in US English. There are a few references to Language prerequisites. Check out Install and Configure SQL Server for MDM and MDM Deployment Checklists for Language references.

You might want to check out Marco’s documents SCMDM 2008 SP1 Reporting Services Overview and SQL Server 2005 Reporting Services (SSRS) Installation and Configuration for SCMDM 2008 SP1 Reporting Services outlining the reporting services.

Cheers Wayne

Airloom

SCMDM08_ResourceKit_Reports_x64_V2_0 multiple fails in Process the Initial Set of Data

Tue, 30 Jun 2009 11:43:36 Z

Thanks for your response, All is installed in English, least Regional Settings (in Spanish) and the server Collation of SQL (in Modern_Spanish_CI_AS). I can try to change this Settings, but I dont know if this change can affect to the devices connections, the devices have the Spanish Version of Windows Mobile.

When I test it, I write here the results.

SCMDM08_ResourceKit_Reports_x64_V2_0 multiple fails in Process the Initial Set of Data

Wed, 01 Jul 2009 07:38:31 Z

Hello, I've tested this,

now the reports run OK, the only change I've maked is the regional settings on all MDM servers and reporting server to English (US).

Now the conections of the devices not run properly if this have configured the Spanish Reginal Settings, This run OK in English (US), but I needuse the Spanish regional Settings :( .

I think the only solution if I want Use the repports whit the Spanish reginal settings is modify the repports. I supose

I guess that the problem will be a variable, try to locate and modify it, if someone can give me some clue will be very grateful.

Regards.