Post Closed
33
Views
1
Comments
[BPT Utils] Issue deleting processes with subprocesses
bpt-utils
Web icon
Forge asset by Messias Pedro Peralta
Application Type
Traditional Web

I'm having issues deleting processes with sub-processes via Process_BulkDelete.

The cleanup of simple processes works fine.

And when I perform a delete directly via the database of first the sub-processes and then the top process, it works.

Encountered error:
ORA-02292: Integriteitsbeperking (OSADMIN.OSFRK_OSSYS_BPM_PROCESS_O13642) is geschonden - onderliggend record is gevonden.ORA-06512: in regel 6   at OracleInternal.ServiceObjects.OracleConnectionImpl.VerifyExecution(Int32& cursorId, Boolean bThrowArrayBindRelatedErrors, SqlStatementType sqlStatementType, Int32 arrayBindCount, OracleException& exceptionForArrayBindDML, Boolean& hasMoreRowsInDB, Boolean bFirstIterationDone)   at OracleInternal.ServiceObjects.OracleCommandImpl.ExecuteNonQuery(String commandText, OracleParameterCollection paramColl, CommandType commandType, OracleConnectionImpl connectionImpl, Int32 longFetchSize, Int64 clientInitialLOBFS, OracleDependencyImpl orclDependencyImpl, Int64[]& scnFromExecution, OracleParameterCollection& bindByPositionParamColl, Boolean& bBindParamPresent, OracleException& exceptionForArrayBindDML, OracleConnection connection, Boolean isFromEF)   at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteNonQuery()   at OutSystems.HubEdition.Extensibility.Data.ExecutionService.BaseExecutionService.ExecuteNonQuery(IDbCommand cmd)   at OutSystems.Internal.Db.DatabaseAccess.ExecuteWithoutRequestTimeout[T](Func`1 action)   at OutSystems.Internal.Db.Command.ExecuteNonQuery(String description, Boolean isApplication, Boolean skipLog, Boolean applyTransformationsToParameters)   at OutSystems.HubEdition.RuntimePlatform.RuntimePublic.Db.DBProcess.rpf#gwgffkrz(Transaction apn, String apo, Nullable`1 app, Nullable`1 apq, Nullable`1 apr)   at rpf#kspodoia.rpf#rpylftma(Transaction aqa, Nullable`1 aqb, Nullable`1 aqc, Nullable`1 aqd)   at rpf#kspodoia.rpf#rpylftmb(Transaction axk, Nullable`1 axl, Nullable`1 axm, Nullable`1 axn, Nullable`1 axo)   at OutSystems.HubEdition.RuntimePlatform.ProcessDeletion.DeleteProcesses(Transaction trans)   at OutSystems.RuntimePublic.Processes.ProcessDeletion.DeleteProcesses()   at OutSystems.NssBPT_API.CssBPT_API.MssProcess_BulkDelete(DateTime ssProcessesOlderThan, Int32 ssProcessDefinitionId, Int32 ssMaxDeletedProcesses, Boolean& ssHasMoreToDelete)   at ssBPTArchiver.RssExtensionBPT_API.MssProcess_BulkDelete(HeContext heContext, DateTime inParamProcessesOlderThan, Int32 inParamProcessDefinitionId, Int32 inParamMaxDeletedProcesses, Boolean& outParamHasMoreToDelete) 

Any else also experiencing the same issue?

2025-09-25 14-38-22
Lokesh Kumar Yadav

Yes, this is a known issue when using Process_BulkDelete on processes that have sub-processes. The error:

pgsqlCopyEditORA-02292: Integrity constraint violated - child record found

means that the parent process cannot be deleted because related sub-processes (child records) still exist, violating the foreign key constraint (OSFRK_OSSYS_BPM_PROCESS_O13642).   Try with this