Upload jobs failing on weekends
Kinda weird as this jobs work on weekedays and fails on weekends. Below is the trace:
Mail from: </IL_SFDC_ALL> sent at: Mon Sep 08 03:16:18 2008
Message:
=======
The job IL_SFDC_ALL has the following trace lines and errors:
Last 8 lines from Trace Log file: <C:\Program Files\Business Objects\Data Integrator 11.7/log/JSPROD_BLADE/nycsqlsrv01_prod_di_bobi/trace_09_07_2008_22_00_02_7__779b2104_6d7a_4b64_99 72_f505705c9d61.txt>.
=======
(11.7) 09-08-08 03:16:06 (3648:3660) DATAFLOW: Data flow <DF_IL_Organization_Current_Yr_SE> is started.
(11.7) 09-08-08 03:16:06 (3648:3660) DATAFLOW: Cache statistics for data flow <DF_IL_Organization_Current_Yr_SE> are not available to be used for optimization and need to be
collected before they can be used.
(11.7) 09-08-08 03:16:06 (3648:3660) DATAFLOW: Data flow <DF_IL_Organization_Current_Yr_SE> using PAGEABLE Cache with <1536 MB> buffer pool.
(11.7) 09-08-08 03:16:17 (3648:3660) DATAFLOW: Data flow <DF_IL_Organization_Current_Yr_SE> is terminated due to error <51005>.
(11.7) 09-08-08 03:16:17 (3648:3660) DATAFLOW: Process to execute data flow <DF_IL_Organization_Current_Yr_SE> is completed.
(11.7) 09-08-08 03:16:18 (3952:1692) WORKFLOW: Work flow <WF_IL_Organization_Active_Flag_Update> is terminated due to an error <51005>.
Last 19 lines from Error Log file: <C:\Program Files\Business Objects\Data Integrator 11.7/log/JSPROD_BLADE/nycsqlsrv01_prod_di_bobi/error_09_07_2008_22_00_02_7__779b2104_6d7a_4b64_99 72_f505705c9d61.txt>.
=======
Driver]String data, right truncation>, SQLState <01004>.
(11.7) 09-08-08 01:33:22 (W) (3100:2772) DBS-070402: |Dataflow DF_DeltaOpportunity_SFDC|Reader OuterJoinQuery
ODBC data source <nycsqlsrv01> warning message for operation <SQLFetchScroll(rowStsArray[])>: <[Microsoft][ODBC SQL Server
Driver]String data, right truncation>, SQLState <01004>.
(11.7) 09-08-08 01:34:35 (W) (3100:2772) DBS-070402: |Dataflow DF_DeltaOpportunity_SFDC|Reader OuterJoinQuery
ODBC data source <nycsqlsrv01> warning message for operation <SQLFetchScroll(rowStsArray[])>: <[Microsoft][ODBC SQL Server
Driver]String data, right truncation>, SQLState <01004>.
(11.7) 09-08-08 01:40:52 (W) (3100:2772) DBS-070402: |Dataflow DF_DeltaOpportunity_SFDC|Reader OuterJoinQuery
ODBC data source <nycsqlsrv01> warning message for operation <SQLFetchScroll(rowStsArray[])>: <[Microsoft][ODBC SQL Server
Driver]String data, right truncation>, SQLState <01004>.
(11.7) 09-08-08 03:16:07 (E) (3648:2772) DBS-070404: |Dataflow DF_IL_Organization_Current_Yr_SE|Loader Query_IL_ORGANIZATION_DIM
SQL submitted to ODBC data source <nycsqlsrv01> resulted in error <>. The SQL submitted is <SQLTransact>.
(11.7) 09-08-08 03:16:07 (E) (3648:2772) RUN-051005: |Dataflow DF_IL_Organization_Current_Yr_SE|Loader Query_IL_ORGANIZATION_DIM
Execution of <Regular Load Operations> for target <IL_ORGANIZATION_DIM> failed. Possible causes: (1) Error in the SQL syntax;
(2) Database connection is broken; (3) Database related errors such as transaction log is full, etc.; (4) The user defined in
the datastore has insufficient privileges to execute the SQL. If the error is for preload or postload operation, or if it is
for regular load operation and load triggers are defined, please check the SQL. Otherwise, for (3) and (4), please contact your
local DBA.
