I am getting these errors in a job where I am inserting and updating records in MS SQLserver stage
D_Employee,1: Failure during execution of operator logic.
Fatal Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '@P7'.
Player 30 terminated unexpectedly.
APT_PMsectionLeader(2, node2), player 30 - Unexpected exit status 1.
Join,1: Failure during execution of operator logic.
Join,1: Fatal Error: Unable to allocate communication resources
node_node2: Player 18 terminated unexpectedly.
2: Fatal Error: Caught unknown exception in parallel process: terminating.
The Section Leader on node node2 has terminated unexpectedly.
can anyone help...whats the meaning of "Incorrect syntax near '@P7'".
APT_CombinedOperatorController(6)
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 94
- Joined: Sun Jul 18, 2010 11:35 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 94
- Joined: Sun Jul 18, 2010 11:35 pm
No, we mean to define and set the environment variable $APT_DISABLE_COMBINATION to "true" in your job's parameters.
Last edited by ArndW on Mon Oct 18, 2010 6:07 am, edited 1 time in total.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Ray - I corrected the original post, but you slipped in earlier
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
May be something that worth checking :-
1. Whether connectivity is working fine or not !
You can select some other table and check for the connectivity and giving the results as expected..
2. You can enable the APT_DUMP_SCORE true, to get the detailed logs so that you can Trace the data.
3. You can also check whether data is in proper format
4. Whether lengh of all the columns are defined correclty and your input/output is compatible with that..
Hope this helps!
1. Whether connectivity is working fine or not !
You can select some other table and check for the connectivity and giving the results as expected..
2. You can enable the APT_DUMP_SCORE true, to get the detailed logs so that you can Trace the data.
3. You can also check whether data is in proper format
4. Whether lengh of all the columns are defined correclty and your input/output is compatible with that..
Hope this helps!
-----------------------------------
Regards
MK
What would you attempt to do if you knew you could not fail?
-----------------------------------
Regards
MK
What would you attempt to do if you knew you could not fail?
-----------------------------------