Microsoft.Dynamics.GP.IntegrationManager.IMProvider, Status Code: 48285313 ERROR: Unable to open source queries because Query 'XXX' is not found in the database. - [Microsoft][ODBC SQL Server Driver]Timeout expired

Microsoft.Dynamics.GP.IntegrationManager.IMProvider, Status Code: 48285313     ERROR: Unable to open source queries because Query 'XXX' is not found in the database. - [Microsoft][ODBC SQL Server Driver]Timeout expired

The 'XXX' is the name of my source location, I've have everything mapped right and manually run the the intergration queries, to see if a server timeout occurs....the queris ran fine and and less than 3 seconds.

Not sure what else to check.

  • im not sure this is enough info.

  • In reply to george hardy:

    is there anything else i can use the help me solve the problem...

    - I've looked at the intergration log files and that's the error the came up.

    - i've look ran connected to the data souce and ran the "SQL Statment" query (no timeout)

    - I've ran the before and after document queries (not time out)

    ... kinda out of options and suggestions

  • In reply to Chad Sellers:

    George...below is the log file may this can add clearification to the problem...

    Integration Log
    Integration: XXX (ID: 94)
    Action: None
    Start Time: 2/26/2013 2:55:40 AM

      2/26/2013 2:55:40 AM Source: IIntegrationEngine_Run, Status Code: 0    Opening source query...
      2/26/2013 6:15:41 AM Source: Microsoft.Dynamics.GP.IntegrationManager.IMProvider, Status Code: 48285313     ERROR: Unable to open source queries because Query 'XXX' is not found in the database. - [Microsoft][ODBC SQL Server Driver]Timeout expired
    [Microsoft][ODBC SQL Server Driver]Timeout expired
    Unable to open source queries because Query 'X
      2/26/2013 6:15:41 AM Source: Microsoft.Dynamics.GP.IntegrationManager.IMProvider, Status Code: 48285313     XX' is not found in the database. - [Microsoft][ODBC SQL Server Driver]Timeout expired
    [Microsoft][ODBC SQL Server Driver]Timeout expired
      2/26/2013 6:15:41 AM Source: FinishIntegration, Status Code: 3    Integration Failed
      2/26/2013 6:15:41 AM Source: FinishIntegration, Status Code: 3    Integration Results
        0 documents were read from the source query.
        0 documents were attempted:
            0 integrated without warnings.
            0 integrated with warnings.
            0 failed to integrate.

    Finish Time: 2/26/2013 6:15:41 AM

    Source Total: 0
    Successfully Integrated: 0
    Integrated With Warning: 0
    Failed: 0

    Completion Status: Incomplete
    Integration Status: No Documents Succeeded

Related
Recommended