Hi Friends,
1.We are getting error "Failure during execution of operator logic" while trying to load data into Teradata table using Mload.
2.when we use enterprise stage we are getting error
Teradata_Enterprise_15,0: TeraUtils:DB Call Error(success check) Info = 0, Code = 2633,
Message = Too many load/unload tasks running: try again later
please let me know the solution for the above 2 problem if you already faced..
Datastage:Teradata Mload giving alot of errors
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 194
- Joined: Thu May 11, 2006 9:42 am
Datastage:Teradata Mload giving alot of errors
Thanks,
Chris Jones
Chris Jones
-
- Charter Member
- Posts: 560
- Joined: Wed Jul 13, 2005 5:36 am
- Location: Ohio
-
- Participant
- Posts: 194
- Joined: Thu May 11, 2006 9:42 am
Datastage:Teradata Mload giving alot of errors
Krazykoolrohit wrote:Just one suggestion. May or may not be helpful.
Please check if the table is locked for any previous mload runs.
Thanks for you reply,
Please let me know what is the query to release the locked target table
Thanks,
Chris Jones
Chris Jones
-
- Charter Member
- Posts: 560
- Joined: Wed Jul 13, 2005 5:36 am
- Location: Ohio
Login to the server through unix.
execute the command bteq.
give your username and password.
type the following "release mload <tablename>"
you may also have to delete the temporary work tables manually. REad the mload script to get the name of temporary tables you need to delete.
this may not be an exact step to step guide as i dont have teradata with me now to check. but if you read your mload script of mload log, you wil lbe able to see the steps to login to teradata through unix. (you have to repeat the steps in script.)
execute the command bteq.
give your username and password.
type the following "release mload <tablename>"
you may also have to delete the temporary work tables manually. REad the mload script to get the name of temporary tables you need to delete.
this may not be an exact step to step guide as i dont have teradata with me now to check. but if you read your mload script of mload log, you wil lbe able to see the steps to login to teradata through unix. (you have to repeat the steps in script.)