TPT10508: RDBMS error 3510: Too many END TRANSACTION statements.

Database

TPT10508: RDBMS error 3510: Too many END TRANSACTION statements.

Hi All,

One of our TPT script fails with error "TPT10508: RDBMS error 3510: Too many END TRANSACTION statements.". Failure is not frequent but we need to resolve it. There is another bteq loading same table but both the scripts(TPT & BTEQ) run at different times & therefore there is no possibility of deadlock of that table. So want to know what will be the reason for failure when there is no deadlock or force END TRANSACTION etc.

 

Below is the poart of log of the TPT script which often fails. Let me know if more details needed.

Public log:


Using memory mapped file for IPC

TPT_INFRA: TPT04101: Warning: Teradata PT cannot connect to Unity EcoSystem Manager.
The job will continue without event messages being sent to Unity EcoSystem Manager.
TPT_INFRA: TPT04197: Warning: OMD API failed to initialize
Teradata Parallel Transporter Executor Version 15.10.01.01
Teradata Parallel Transporter Executor Version 15.10.01.01
Teradata Parallel Transporter Coordinator Version 15.10.01.01
Teradata Parallel Transporter DataConnector Operator Version 15.10.01.01
RO_4_INPUTLAYOUT[1]: TPT19206 Attribute 'TraceLevel' value reset to 'Statistics Only'.
RO_4_INPUTLAYOUT[1]: Instance 1 directing private log report to 'Read-1'.
Teradata Parallel Transporter Stream Operator Version 15.10.01.01
o_tpump: private log specified: Load
RO_4_INPUTLAYOUT[1]: DataConnector Producer operator Instances: 1
RO_4_INPUTLAYOUT[1]: ECI operator ID: 'RO_4_INPUTLAYOUT-61773'
RO_4_INPUTLAYOUT[1]: Operator instance 1 processing file '/cfs/app/etl_p22/ecdw_apps_p22/ovals/files/tgtfiles/daily/conn_cmnty.20180506.1.dat'.
o_tpump: Start-up Rate: UNLIMITED statements per Minute
o_tpump: Operator Command ID for External Command Interface: o_tpump61772
o_tpump: connecting sessions
o_tpump: ArraySupport is turned off
Task(APPLY_1[0001]): checkpoint completed, status = Success
Task(SELECT_2[0001]): checkpoint completed, status = Success
o_tpump: entering Load Phase
Task(SELECT_2[0001]) ready to checkpoint

TPT_INFRA: TPT02255: Message Buffers Sent/Received = 2, Total Rows Received = 4108, Total Rows Sent = 0
o_tpump: TPT10508: RDBMS error 3510: Too many END TRANSACTION statements.
o_tpump: disconnecting sessions
o_tpump: Total processor time used = '1.41 Second(s)'
o_tpump: Start : Sun May 6 19:44:58 2018
o_tpump: End : Sun May 6 19:46:01 2018
TPT_INFRA: TPT02600: Error: DSAC_DataStreamSingularOutput::write_checkpoint - send error
Task(SELECT_2[0001]): checkpoint completed, status = Success
TPT_INFRA: TPT02255: Message Buffers Sent/Received = 5, Total Rows Received = 0, Total Rows Sent = 7133

1 REPLY
Senior Apprentice

Re: TPT10508: RDBMS error 3510: Too many END TRANSACTION statements.

Hi,

I doubt if you can fix this, I think you need to open an incident on TaYS.

 

The 3510 basically says that an error has occurred during processing, causing the existing transaction to roll back and terminate. After that processing, the application continues and then issues an 'ET;' (end transaction) command but at this point there is no transaction to terminate - hence the error.

 

The 3510 error has nothing (directly) to do with anything else that may be happening at the same time. It may be that whatever else is happening is causing the transaction to be rolled back, but that itself does not cause the 3510. This is a programming error - and I think it is in the TPT code.

 

HTH

Dave

Ward Analytics Ltd - information in motion
www: http://www.ward-analytics.com