Sign in
Microsoft.com
 
System Center Mobile Device Manager TechCenter
 
 
 
System Center Mobile Device Manager TechCenter > Mobility Forums > System Center Mobile Device Manager > SCMDM08_ResourceKit_Reports_x64_V2_0 multiple fails in Process the Initial Set of Data
Ask a questionAsk a question
Search Forums:
 

AnswerSCMDM08_ResourceKit_Reports_x64_V2_0 multiple fails in Process the Initial Set of Data

  • Monday, June 29, 2009 9:19 AMjosemore Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote

    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

     

Answers

All Replies

  • Monday, June 29, 2009 9:33 AMjosemore Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    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
     
  • Tuesday, June 30, 2009 12:02 AMWayne Phillips.MVP, ModeratorUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    Sign In to Vote
    1
    Sign In to Vote

    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

     
  • Tuesday, June 30, 2009 11:43 AMjosemore Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote

    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.

     
  • Wednesday, July 01, 2009 7:38 AMjosemore Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    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.