SQL Job error

  • we have real time ETL jobs in reporting server that will sync with transactional database.

    one of the SQL ETL job failed with following error. Is this network related issue?

    Experts - Please advise

    Message

    Executed as user: domain\z_gwpdbrepsqlservice. Microsoft (R) SQL Server Execute Package Utility Version 10.0.5500.0 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 11:03:56 PM Error: 2012-07-09 23:04:29.99 Code: 0xC0202009 Source: dft_aq1extacuheader LKP_Dim_acuheader [1141] Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Login timeout expired". An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.". An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "TCP Provider: Only one usage of each socket address (protocol/network address/port) is normally permitted. ". End Error Error: 2012-07-09 23:04:30.11 Code: 0xC0208253 Source: dft_aq1extacuheader LKP_Dim_acuheader [1141] Description: OLE DB error occurred while fetching parameterized rowset. Check SQLCommand and SqlCommandParam properties. End Error Error: 2012-07-09 23:04:30.25 Code: 0xC0047022 Source: dft_aq1extacuheader SSIS.Pipeline Description: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "LKP_Dim_acuheader" (1141) failed with error code 0xC0208253 while processing input "Lookup Input" (1142). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure. End Error Error: 2012-07-09 23:04:31.25 Code: 0xC02020C4 Source: dft_aq1extacuheader source_aq1extacuheader [16] Description: The attempt to add a row to the Data Flow task buffer failed with error code 0xC0047020. End Error Error: 2012-07-09 23:04:31.36 Code: 0xC0047038 Source: dft_aq1extacuheader SSIS.Pipeline Description: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "source_aq1extacuheader" (16) returned error code 0xC02020C4. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 11:03:56 PM Finished: 11:04:31 PM Elapsed: 35.234 seconds. The package execution failed. NOTE: The step was retried the requested number of times (50) without succeeding. The step failed.

  • It certainly looks that way:

    "Login timeout expired".

    "A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections."

    TCP Provider: Only one usage of each socket address (protocol/network address/port) is normally permitted.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply