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?
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