Support Article
Dataset-Execute : Truncate actually issues a Delete SQL
SA-33416
Summary
Dataset-Execute : Truncate actually issues a Delete SQL which causes a performance issue, and ultimately fails with ORA-30036 errors.
Error Messages
User ID: System
Last SQL: DELETE FROM <schema>.<table>
java.sql.SQLException: ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1'
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522)
......
Steps to Reproduce
Run the Dataset-Execute with Truncate and verify the SQL in Log.
Root Cause
This issue was determined to be a product enhancement request. Multiple classes can be mapped to one table in Pega platform. That is why Dataset-Execute Truncate is implemented as Delete SQL. Entered an enhancement request for the future consideration so that users will be given an option to perform native table truncation for the case where one class is mapped a single table.
Resolution
An enhancement request FDBK-18243 has been created for the consideration of future release.
Published August 23, 2017 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.