Issue executing Teradata stored procedure
Posted: Thu Nov 02, 2017 9:15 am
Hi,
I am using Teradata connector stage to call the stored procedure through select statement using LDAP mechanism.
CALL stageDB.uspTransformPipeline ('BatchId=11232',otParam )
Stored procedure is failing with the below error message.
Error Message - Teradata_Connector_4,0: RDBMS code 3510: Too many END TRANSACTION statements. SQL statement: ET (CC_TeraConnection::execute, file CC_TeraConnection.cpp, line 3,553)
Same procedure is running fine if it is executed from Teradata SQL assistant.
I am using peek stage to output the message returned by the procedure to log. I can see that the procedure has executed successfully and the "Success" message has been logged in the director. However the job is getting aborted with the above mentioned error.
Please advice how to resolve this issue.
Datastage version used : 11.5
Thank you.
Regards
Vikram
I am using Teradata connector stage to call the stored procedure through select statement using LDAP mechanism.
CALL stageDB.uspTransformPipeline ('BatchId=11232',otParam )
Stored procedure is failing with the below error message.
Error Message - Teradata_Connector_4,0: RDBMS code 3510: Too many END TRANSACTION statements. SQL statement: ET (CC_TeraConnection::execute, file CC_TeraConnection.cpp, line 3,553)
Same procedure is running fine if it is executed from Teradata SQL assistant.
I am using peek stage to output the message returned by the procedure to log. I can see that the procedure has executed successfully and the "Success" message has been logged in the director. However the job is getting aborted with the above mentioned error.
Please advice how to resolve this issue.
Datastage version used : 11.5
Thank you.
Regards
Vikram