User310637483 posted
Message
Executed as user: NDPINNACLE\SYSTEM. Microsoft (R) SQL Server Execute Package Utility Version 10.50.1600.1 for 32-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 3:00:00 PM Progress: 2014-01-16 15:00:01.84 Source: Classification
Validating: 0% complete End Progress Progress: 2014-01-16 15:00:01.84 Source: Classification Validating: 50% complete End Progress Warning: 2014-01-16 15:00:03.23 Code: 0x802092A7 Source: Classification OLE DB Destination [239] Description: Truncation may
occur due to inserting data from data flow column "EP_PROJECT_NUMBER" with a length of 50 to database column "EP_PROJECT_NUMBER" with a length of 25. End Warning Warning: 2014-01-16 15:00:03.23 Code: 0x802092A7 Source: Classification OLE DB Destination [239]
Description: Truncation may occur due to inserting data from data flow column "OPERATION_MODE" with a length of 50 to database column "OPERATION_MODE" with a length of 10. End Warning Warning: 2014-01-16 15:00:03.23 Code: 0x802092A7 Source: Classification
OLE DB Destination [239] Description: Truncation may occur due to inserting data from data flow column "RECORD_STATUS" with a length of 50 to database column "RECORD_STATUS" with a length of 1. End Warning Progress: 2014-01-16 15:00:03.23 Source: Classification
Validating: 100% complete End Progress Progress: 2014-01-16 15:00:03.24 Source: Keymembers Validating: 0% complete End Progress Progress: 2014-01-16 15:00:03.24 Source: Keymembers Validating: 50% complete End Progress Error: 2014-01-16 15:00:12.60 Code: 0xC0202009
Source: PINNORA_PROJECTS_PHASE1_2 Connection manager "HSOracleERP_EPIFACE" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft OLE DB Provider for Oracle" Hresult:
0x80004005 Description: "ORA-12537: TNS:connection closed ". End Error Error: 2014-01-16 15:00:12.60 Code: 0xC020801C Source: Keymembers OLE DB Destination [997] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection
method call to the connection manager "HSOracleERP_EPIFACE" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. End Error Error: 2014-01-16 15:00:12.60 Code:
0xC0047017 Source: Keymembers SSIS.Pipeline Description: component "OLE DB Destination" (997) failed validation and returned error code 0xC020801C. End Error Progress: 2014-01-16 15:00:12.60 Source: Keymembers Validating: 100% complete End Progress Error:
2014-01-16 15:00:12.60 Code: 0xC004700C Source: Keymembers SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2014-01-16 15:00:12.60 Code: 0xC0024107 Source: Keymembers Description: There were errors during task validation.
End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 3:00:00 PM Finished: 3:00:12 PM Elapsed: 12.402 seconds. Process Exit Code 1. The step failed.
