阅读:2607
回复:3
|
[BUG反馈]子表插入报错,id重复异常。导致子流程报错
版本 net 9.2.7
主流程中,在主表上选择子表数据,子表选择人员。然后下一流程点是子流程,子流程根据子表选择的人员分别发送待办。 报错: 主流程中子流程是状态为 “启动中” 日志如下。插入的标就是子表。重复键的值是子表选择的某一个人员的id。报错之后查看数据库,发现子表对象都已经正常插入了。这是插入了两遍么。跪求指导啊。 [table=756.8,#ffffff,,1][tr][td]Exception has been thrown by the target of an invocation. at OThinker.Clusterware.xea93bc06112e2031.InvokeMethod_I(String InternalTokenId, Boolean IsClientInvoking, String LogicUnitCode, String CFName, String CurrentUICultureName, String ModuleName, String MethodName, Object[] Parameters, Object[]& Parameters2) at OThinker.Clusterware.x9ea53fd36a4b0781.xb5e5f6f955fc3ca0(String x108a63fdfbe34327, String xfddc6ab564e933d7, String x74faa26c4a22e1cc, String xc67bed94fbe02767, String x36d12ad1eed49cd3, Object[] x69ff6456126e289b, Object[]& xec53d23bc7994bff) at OThinker.Clusterware.LogicUnitModule.InvokeCFMethod(String CFName, String MethodName, Object[] Parameters) at OThinker.H3.DataModel.BizObjectManager.InvokeBizObjectMethod(String UserId, BoolMatchValue Transactional, String SchemaCode, BizObjectType BizObjectType, String ObjectId, String MethodName, BizStructure Params) at OThinker.H3.DataModel.BizObject._Invoke(String UserId, BoolMatchValue Transactional, String MethodName, BizStructure Params, InstanceData InstanceData, Boolean WriteValueToObject) at OThinker.H3.DataModel.BizObject._Update(String UserId, BoolMatchValue Transactional, BizStructure Params) at OThinker.H3.Instance.InstanceData.CopyInstanceData(String DestBizObjectSchemaCode, String DestBizObjectId, String DestInstanceID, Int32 DestTokenID, String[] SourcePropertyNames, String[] DestPropertyNames, Boolean[] Overrides) at OThinker.H3.SmartFlow.SmartWorkflow.x12cb12b5d2cad53d(StartInstanceMessage xd397bb1e465ce45e, Message[]& xfe56116f4d06e041) at OThinker.H3.SmartFlow.SmartWorkflow.DisposeMessage(InstanceMessage Message, Message[]& RollbackedMessages) at OThinker.H3.Instance.MessageDisptacher.DispatchMessage(Message Message, Message[]& RollbackedMessages, Message[]& ToOtherInstanceMessages) System.Exception: INSERT INTO I_InvitationedSupplier(ObjectID, [ParentObjectID], [ParentPropertyName], [ParentIndex], [Supplier], [IsJoin], [PretrialPass], [CreateTime], [ReplyTime], [JoinStage], [BeginJudge], [SkillJudged], [BusiJudged], [QualScore], [SkillScore], [BusiScore], [TotalScore], [BidPrice], [PriceTwo], [Selected], [PriceScore], [PretrialRemark], [ReplyRemarks], [FileQual], [FileSkill], [FileBusi], [KeepAmountFile], [UserState]) VALUES ('f882f485-9bfe-48dd-a949-bae3eef60be7', @ParentObjectID, @ParentPropertyName, @ParentIndex, @Supplier, null, @PretrialPass, null, null, null, @BeginJudge, @SkillJudged, @BusiJudged, null, null, null, null, null, null, @Selected, null, null, null, null, null, null, null, null) ---> System.Data.SqlClient.SqlException: 违反了 PRIMARY KEY 约束“PK__I_Invita__9A6192B1B0E22C0A”。不能在对象“dbo.I_InvitationedSupplier”中插入重复键。重复键值为 (f882f485-9bfe-48dd-a949-bae3eef60be7)。 语句已终止。 at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at OThinker.Data.Database.CommandExecutor.ExecuteNonQuery(ExecutionContext[] Executions) --- End of inner exception stack trace --- at OThinker.H3.DataModel.BizObjectSchemaManager.InvokeMethod(String SchemaCode, String MethodName, String UserId, BoolMatchValue Transactional, BizObjectType BizObjectType, String ObjectId, BizStructure Params, BizObjectSchema& Schema, MethodGroupSchema& Method, BizObjectPropertyTrack[]& Tracks) at OThinker.H3.Apps.AppManager.InvokeMethod(String SchemaCode, String MethodName, String UserId, BoolMatchValue Transactional, BizObjectType BizObjectType, String ObjectId, BizStructure Params, BizObjectSchema& Schema, MethodGroupSchema& Method, BizObjectPropertyTrack[]& Tracks) at OThinker.H3.DataModel.BizObjectManager._InvokeBizObjectMethod(String UserId, BoolMatchValue Transactional, String SchemaCode, BizObjectType BizObjectType, String ObjectId, String MethodName, BizStructure Params)[/td][/tr][/table] |
2楼#
发布于:2018-11-12 14:43
|
|