服务流程执行提示“ORA-00600: 内部错误代码”

1 问题描述

• 场景说明：连接配置为Oracle数据库、或系统的数据库是Oracle。对数据库进行查询、新增、更新语句；对日期类型的字段没有使用占位符

• 日志异常：

  报错日志Oracle的内部错误代码为：ORA-00600

• 在跑部分服务流程（对固定服务流程是必现的）时，报错日志如下：
   ORA-00600: 内部错误代码, 参数: [4097], [36], [15], [411264], [24], [0], [], [], [], [], [], []
   
  RequestContext: tenantId=thdev01, accountId=1433416885638004736
  TX: TXContext.41035:tag=isc_sf_proc_inst.save, level=1, propagation=REQUIRES_NEW, rollback=false, halt=false, ended=false
  SQL: /*ORM*/ UPDATE t_isc_sf_proc_inst SET fstate=?,fmodified_time=?,fcontext=?,fcontext_tag=?,fserver_instance=?,fcontext_length=?,ferror_message=?,fexec_time=?,fmodifier=? WHERE FId=?
  Parameters: [[Failed, Thu Apr 18 15:22:36 GMT+08:00 2024, ..., {"memory":{"canceled":"false","executions":[{"parent":"","def":"$","ip":"30000000","id":"1","recovery":"15000000"},{"parent":"1","def":"38","priorNodeId":"41","ip":"30000000","entryTransition":"43","id":"14","recovery":"5000000","priorId":"13"}],"crc":"9580FB93","values":["120230010",null,[120230010 ],["1437901779097361409""1437903889738243074","1437903889738244098","1437903889738243075","1437903889738244099","1437903889738243076","1437903889738244100","1437903889738243077","1610040261243583488","1766722444581711872","1614646339252004864","1610881946487905280","1692875227203133440","1590752193529536512"],null,null,null,[{"number":"ORG-00001","enable":"1","isbizorg":true,"id":"1436927185477703680","$id":"1436927185477703680","$pk":"id"}],"1436927185477703680","0","0","1437901779097361409",null,"{\"orgId\":\"1436927185477703680\",\"bookTypeId\":\"237528347981256704\",\"accountTableId\":\"1436944010517157888\",\"periodId\":\"120230010\",\"accountAssgrp\":{\"1437901779097361409\":null},\"selector\":[\"org\",\"booktype\",\"accounttable\",\"account\",\"dc\",\"assgrp\",\"currency\",\"measureunit\",\"beginfor\",\"debitfor\",\"creditfor\",\"endfor\",\"beginlocal\",\"debitlocal\",\"creditlocal\",\"endlocal\",\"yeardebitfor\",\"yeardebitlocal\",\"yearcreditfor\",\"yearcreditlocal\"],\"groupBy\":[\"account\",\"org\",\"assgrp\",\"booktype\",\"accounttable\",\"currency\",\"measureunit\",\"dc\"]}","237528347981256704","1436944010517157888","0",null,"0",[{"number":"100001","enable":"1","id":"237528347981256704","$id":"237528347981256704","$pk":"id","status":"C"}],"202301","202302","2023-01-31 23:59:59.0",null,null,[{"number":"6301","id":"1437901845635801088","$id":"1437901845635801088","$pk":"id"}],["1437901845635801088"],"1","1",[{"number":"0001","id":"1","$id":"1","$pk":"id"}]],"host":"","id":"0","flow":"1931266550296308736"},"profile":"NONE","last-execution":"1","id":"1931266676444153856","state":"Suspended","counter":"15","properties":[{"type":"map","value":{"1":{"start_time":"2024-04-18 15:22:08.463","count":1 ,"end_time":"2024-04-18 15:22:08.463","state":"complete"},"18":{"elapsed":"12","start_time":"2024-04-18 15:22:08.463","total_elapsed":"12","count":1 ,"end_time":"2024-04-18 15:22:08.475","state":"complete"},"73":{"elapsed":"7","start_time":"2024-04-18 15:22:08.475","total_elapsed":"7","count":1 ,"end_time":"2024-04-18 15:22:08.482","state":"complete"},"20":{"start_time":"2024-04-18 15:22:08.482","count":1 ,"end_time":"2024-04-18 15:22:08.482","state":"complete"},"60":{"elapsed":"5","start_time":"2024-04-18 15:22:08.482","total_elapsed":"5","count":1 ,"end_time":"2024-04-18 15:22:08.487","state":"complete"},"75":{"elapsed":"6","start_time":"2024-04-18 15:22:08.487","total_elapsed":"6","count":1 ,"end_time":"2024-04-18 15:22:08.493","state":"complete"},"61":{"start_time":"2024-04-18 15:22:08.493","count":1 ,"end_time":"2024-04-18 15:22:08.493","state":"complete"},"3":{"elapsed":"2","start_time":"2024-04-18 15:22:08.493","total_elapsed":"2","count":1 ,"end_time":"2024-04-18 15:22:08.495","state":"complete"},"45":{"elapsed":"1","start_time":"2024-04-18 15:22:08.495","total_elapsed":"1","count":1 ,"end_time":"2024-04-18 15:22:08.496","state":"complete"},"27":{"elapsed":"8","start_time":"2024-04-18 15:22:08.496","total_elapsed":"8","count":1 ,"end_time":"2024-04-18 15:22:08.503","state":"complete"},"29":{"start_time":"2024-04-18 15:22:08.504","count":1 ,"end_time":"2024-04-18 15:22:08.504","state":"complete"},"41":{"start_time":"2024-04-18 15:22:08.504","count":1 ,"end_time":"2024-04-18 15:22:08.504","state":"complete"},"38":{"elapsed":"12848","start_time":"2024-04-18 15:22:08.504","total_elapsed":"12848","count":1 ,"end_time":"2024-04-18 15:22:21.352","state":"failed"}},"key":"acts"},{"value":"5L4VJ4TOV6B1B","key":"number"},{"type":"map","value":{"19":"true","21":"true","74":"true","22":"true","62":"true","76":"true","63":"true","46":"true","47":"true","30":"true","49":"true","43":"true"},"key":"trans"}],"execution-queue":[]}, E3F1C4649ED4174ECD0E301B40EACB23@FB42, 20996, ORA-00600: 内部错误代码, 参数: [4097], [36], [15], [411264], [24], [0], [], [], [], [], [], []
   
  RequestContext: tenantId=thdev01, accountId=1433416885638004736 …, 28618, 1436897715291161601, 1931266676444153856]]
  
   
   
  ISC_TASK_WORKER-5/traceId:a06b3654e1e37528/time:1713424928451
  kd.bos.exception.KDException: 
  at kd.bos.exception.SecureExceptionUtil.wrapSQLException(SecureExceptionUtil.java:29)
  at kd.bos.db.ExceptionWrapper.wrapSQLException(ExceptionWrapper.java:248)
  at kd.bos.db.ExceptionWrapper.wrapperRethrowCause(ExceptionWrapper.java:131)
  at kd.bos.db.ExceptionWrapper.wrapper(ExceptionWrapper.java:58)
  at kd.bos.db.ExceptionWrapper.getLogCause(ExceptionWrapper.java:99)
  at kd.bos.db.BaseDB.rethrow(BaseDB.java:600)
  at kd.bos.db.DBImpl.executeBatch(DBImpl.java:495)
  at kd.bos.db.DBImpl.executeBatch(DBImpl.java:101)
  at kd.bos.db.DB.executeBatch(DB.java:330)
  at kd.bos.orm.dataentity.BatchUpdateTask.execute(BatchUpdateTask.java:69)
  at kd.bos.orm.dataentity.OrmDBTasks.executeDbTasks(OrmDBTasks.java:84)
  at kd.bos.orm.dataentity.OrmDBTasks.commitDbTask(OrmDBTasks.java:72)
  at kd.bos.orm.dataentity.DataManagerImplement.SaveDataSet(DataManagerImplement.java:1160)
  at kd.bos.orm.dataentity.DataManagerImplement.SavePrivate(DataManagerImplement.java:440)
  at kd.bos.orm.dataentity.DataManagerImplement.access$000(DataManagerImplement.java:113)
  at kd.bos.orm.dataentity.DataManagerImplement$2.apply(DataManagerImplement.java:322)
  at kd.bos.orm.dataentity.DataManagerImplement$2.apply(DataManagerImplement.java:319)
  at kd.bos.orm.dataentity.DataManagerImplement.AutoBatchExecute(DataManagerImplement.java:1523)
  at kd.bos.orm.dataentity.DataManagerImplement.save(DataManagerImplement.java:319)
  at kd.bos.data.BusinessDataWriter.save(BusinessDataWriter.java:97)
  at kd.bos.servicehelper.operation.SaveServiceHelper.save(SaveServiceHelper.java:153)
  at kd.bos.servicehelper.operation.SaveServiceHelper.save(SaveServiceHelper.java:183)
  at kd.bos.servicehelper.operation.SaveServiceHelper.save(SaveServiceHelper.java:123)
  at kd.isc.iscb.platform.core.sf.runtime.ProcessRuntime.innerSaveState(ProcessRuntime.java:295)
  at kd.isc.iscb.platform.core.sf.runtime.ProcessRuntime.saveState(ProcessRuntime.java:243)
  at kd.isc.iscb.platform.core.sf.runtime.ProcessRuntime.saveState(ProcessRuntime.java:227)
  at kd.isc.iscb.platform.core.sf.runtime.AbstractProcessJob.handleError(AbstractProcessJob.java:120)
  at kd.isc.iscb.platform.core.sf.runtime.AbstractProcessJob.run(AbstractProcessJob.java:99)
  at kd.isc.iscb.platform.core.job.Job.runX(Job.java:71)
  at kd.isc.iscb.platform.core.job.JobRunner.run(JobRunner.java:76)
  at kd.isc.iscb.platform.core.job.JobRunner.innerExecute(JobRunner.java:66)
  at kd.isc.iscb.platform.core.job.JobRunner.access$000(JobRunner.java:21)
  at kd.isc.iscb.platform.core.job.JobRunner$1.run(JobRunner.java:57)
  at kd.isc.iscb.util.trace.TraceTask.invoke(TraceTask.java:24)
  at kd.isc.iscb.util.trace.TraceManager.trace(TraceManager.java:24)
  at kd.isc.iscb.platform.core.trace.TraceStack.traceJob(TraceStack.java:63)
  at kd.isc.iscb.platform.core.job.JobRunner.doJob(JobRunner.java:54)
  at kd.isc.iscb.platform.core.job.AbstractJobProxy.run(AbstractJobProxy.java:45)
  at kd.isc.iscb.platform.core.task.TaskWorker.innerExecute(TaskWorker.java:160)
  at kd.isc.iscb.platform.core.task.TaskWorker.execute(TaskWorker.java:1