October 10, 2006 at 3:32 am
Hello.
Can anyone help me with this. It is probably difficult to say exactly what is wrong, but maybe someone can point me in the right direction. I don't even know where to look since it's only a general error.
This is my log file:
Package Name: mis_22_transfer
Package Description: EDB MIS 2.2 Transfer
Execution Started: 01/10/2006 13:32:35
Execution Completed: 01/10/2006 18:41:55
Total Execution Time: 18560.906 seconds
Package Steps execution information:
Step 'generate_balances_yesterday' was not executed
Step 'transfer_dimensions' succeeded
Step Execution Started: 01/10/2006 13:33:25
Step Execution Completed: 01/10/2006 13:40:30
Total Step Execution Time: 424.594 seconds
Progress count in Step: 0
Step 'transfer_facts_1' failed
Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description:General error -2147217900 (80040E14).
Step Error code: 80040E14
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:5300
Step Execution Started: 01/10/2006 13:40:30
Step Execution Completed: 01/10/2006 17:13:24
Total Step Execution Time: 12774.375 seconds
Progress count in Step: 0
Step 'transfer_facts_2' was not executed
Step 'drop_worktables' was not executed
Step 'update_statistics' was not executed
Step 'end_transfer_job' was not executed
Step 'init_transfer_job' succeeded
Step Execution Started: 01/10/2006 13:32:53
Step Execution Completed: 01/10/2006 13:33:25
Total Step Execution Time: 31.953 seconds
Progress count in Step: 0
Step 'verification' was not executed
Step 'housekeeping_of_queue' was not executed
Step 'check_foreign_keys' was not executed
Step 'generate_balances_historic' failed
Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description:General error -2147217900 (80040E14).
Step Error code: 80040E14
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:5300
Step Execution Started: 01/10/2006 13:33:25
Step Execution Completed: 01/10/2006 18:41:55
Total Step Execution Time: 18510.281 seconds
Progress count in Step: 0
Step 'build_aggregations' was not executed
Step 'clean_queue' was not executed
Step 'drop_worktables_2' was not executed
Step 'clean_queue_2' was not executed
Step 'init_connections' succeeded
Step Execution Started: 01/10/2006 13:32:53
Step Execution Completed: 01/10/2006 13:32:53
Total Step Execution Time: 0 seconds
Progress count in Step: 0
****************************************************************************************************
The execution of the following DTS Package succeeded:
Package Name: mis_22_transfer
Package Description: EDB MIS 2.2 Transfer
Execution Started: 02/10/2006 02:30:31
Execution Completed: 02/10/2006 02:31:03
Total Execution Time: 32.25 seconds
Package Steps execution information:
Step 'generate_balances_yesterday' was not executed
Step 'transfer_dimensions' was not executed
Step 'transfer_facts_1' was not executed
Step 'transfer_facts_2' was not executed
Step 'drop_worktables' was not executed
Step 'update_statistics' was not executed
Step 'end_transfer_job' was not executed
Step 'init_transfer_job' failed
Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description:General error -2147217900 (80040E14).
Step Error code: 80040E14
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:5300
Step Execution Started: 02/10/2006 02:30:50
Step Execution Completed: 02/10/2006 02:31:03
Total Step Execution Time: 13.547 seconds
Progress count in Step: 0
Step 'verification' was not executed
Step 'housekeeping_of_queue' was not executed
Step 'check_foreign_keys' was not executed
Step 'generate_balances_historic' was not executed
Step 'build_aggregations' was not executed
Step 'clean_queue' was not executed
Step 'drop_worktables_2' was not executed
Step 'clean_queue_2' was not executed
Step 'init_connections' succeeded
Step Execution Started: 02/10/2006 02:30:50
Step Execution Completed: 02/10/2006 02:30:50
Total Step Execution Time: 0.063 seconds
Progress count in Step: 0
****************************************************************************************************
Thanks in advance.
.lars
October 11, 2006 at 12:18 am
Hi
Have you tried running each step one by one? Do they all execute? Secondly if they do check you have the latest SQL Service pack installed. Use this SELECT SERVERPROPERTY ('productlevel')
Mike
October 11, 2006 at 12:55 am
Hi. Thanks.
This is a production system and has been running since Jan 1 2006. It has only failed 3 times, so the code as such is correct. I have been thinking about time-outs though.
The latest SP is installed.
Another problem is that this DB is in the UK and I am in another country, so it is not a quick process to get log entries etc.
.lars
October 11, 2006 at 1:42 am
Hi
I think you are onto something with the timeout...Can you monitor the network bandwith and check it against when you have errors in your DTS package?
Mike
October 11, 2006 at 1:46 am
I have been trying to get the Application log and other stored logs from the customer. I am still waiting for an answer 🙂
October 11, 2006 at 6:50 am
Hi,
I have seen the "general error" messages at times when the network just fails. Like suppose you are connecting to some network resource etc and the network just fails for an instant then the package fails with this "general error" and i have spent some time debugging it without a clue. So i am not sure if there would be any logs if there are any network issues. you might have to dig some event logs around to check.
Hema
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply