Issue executing Teradata stored procedure

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
vikram_hm
Participant
Posts: 1
Joined: Tue Jun 19, 2012 6:25 am
Location: Bangalore

Issue executing Teradata stored procedure

Post by vikram_hm »

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
Vikram
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Just because I hate to see posts with no replies whatsoever, I'll say "sorry, no clue" and ask - have you involved your official support provider? And are you current on your fix packs?
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply