I'm trying to write data to a SQL Server 2005 table. I tested my connection with a test job (to a test table) successfully. When using the actual data (both in the test job and the real job), I get the following:
APT_CombinedOperatorController,0: Failure during execution of operator logic.
APT_CombinedOperatorController,0: Internal Error: (0): odbcwrite.C: 746
Sequential_File_4,0: Internal Error: (shbuf): iomgr\iomgr.C: 1880
node_node2: Player 1 terminated unexpectedly.
node_node1: Player 2 terminated unexpectedly.
main_program: APT_PMsectionLeader(1, node1), player 2 - Unexpected exit status 1.
There were some repeat error messages, but you get the basic idea. If there was an issue with the data, metadata, or connection, I would expect a more informing error message, but these internal errors are throwing me off.
Any ideas?
Matt
Internal Error When Using ODBC Connection
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Sorry about that. I had disabled it on the big job, but not here. Here are the updated error messages.
ODBC_Enterprise_0,1: Failure during execution of operator logic.
ODBC_Enterprise_0,1: Internal Error: (0): odbcwrite.C: 746
Copy_5,1: Internal Error: (shbuf): iomgr\iomgr.C: 1880
node_node2: Player 2 terminated unexpectedly.
I already knew it's the ODBC stage, as I can delete it and the job runs. I just don't understand why it causes the abort when using it with junk data to a junk table works perfectly.
ODBC_Enterprise_0,1: Failure during execution of operator logic.
ODBC_Enterprise_0,1: Internal Error: (0): odbcwrite.C: 746
Copy_5,1: Internal Error: (shbuf): iomgr\iomgr.C: 1880
node_node2: Player 2 terminated unexpectedly.
I already knew it's the ODBC stage, as I can delete it and the job runs. I just don't understand why it causes the abort when using it with junk data to a junk table works perfectly.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: