Connexion
Microsoft.com
 
Pour les professionnels de l’informatique
 
 
 
Pour les professionnels de l’informatique > Forums - Accueil > System Center Mobile Device Manager > SCMDM08_ResourceKit_Reports_x64_V2_0 multiple fails in Process the Initial Set of Data
Poser une questionPoser une question
Rechercher dans les forums :
 

TraitéeSCMDM08_ResourceKit_Reports_x64_V2_0 multiple fails in Process the Initial Set of Data

  • lundi 29 juin 2009 09:19josemore Médailles de l'utilisateurMédailles de l'utilisateurMédailles de l'utilisateurMédailles de l'utilisateurMédailles de l'utilisateur
     
    Connectez-vous pour voter
    0
    Connectez-vous pour voter

    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

     

Réponses

Toutes les réponses