Datastage:Teradata Mload giving alot of errors

chrisjones · Post by **chrisjones** » Fri Oct 20, 2006 12:09 pm

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..

Krazykoolrohit · Post by **Krazykoolrohit** » Fri Oct 20, 2006 12:19 pm

Just one suggestion. May or may not be helpful.

Please check if the table is locked for any previous mload runs.

chrisjones · Post by **chrisjones** » Fri Oct 20, 2006 12:36 pm

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

Krazykoolrohit · Post by **Krazykoolrohit** » Fri Oct 20, 2006 12:45 pm

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.)