Upload jobs failing on weekends

[Picha Pie]

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.

[rmiao]

Is it ssis package? Did you check those 4 posibilities?

[Picha Pie]

DTS.
I've looked at possibilities it might be #2 because nobody uses the DB on weekend and maybe IT did some maintenance but that's unlikely.

[skhanal]

Did you see any error about transaction log getting full in SQL Server error log?.

You said it is DTS, but it looks like Business Objects Data Integrator job?

[Picha Pie]

That's the datasource

[rmiao]

Is data source available during that time period?

[Picha Pie]

This is exactly the analysis I need from experts looking at the trace I've provided as nobody in my organization can give me a definite answer why it only happens on weekend. As far as we know nothing gets disconnected as people are using it.

[rmiao]

What's error <51005>? Doesn't look like from sql. Did you check db log size? Any db maintenance job running on weekend?