Spec : E810 TR :8.93.I1
Scenario : Doing P4210, Commit failed
Step 1, Check your fat client's jde.ini . Turn on the debug log for the process ID
4060/3164 FOREIGN_THREAD Tue May 27 11:48:40.879000 Jdb_exet.c6928
JDB9900849 - Failed to commit user
4060/3164 FOREIGN_THREAD Tue May 27 11:48:40.879001 Dlg_msgb.cpp170
Commit Failed or was Canceled. Transaction not committed.
Step 2 : Turn on debug log on jde.ini: (callobjectkernel)
May 27 12:17:44.551047 - 1156/3500
WRK:Starting jdeCallObject IN->[ 30] <Item>:
mnProcessID
<type>: MATH_NUMERIC
<Value>: [5772]
May 27 12:17:44.551059 - 1156/3500
WRK:Starting jdeCallObject For BSFN[F4211EditDoc] Error count: Sent
- #Error[0] #Warning[1]
From above debug log (callobjectkernel). it stated processID 5772 is assigned to server. Open logic server's ddp\log\jde_5772.log
Step 3: Check through this server jde.log.
5772/4484 WRK:Starting jdeCallObject Tue May 27 12:14:01.752000 Jdbodbc.c8352
ODB0000163 - wSQLExecute failure. rc=-1
5772/4484 WRK:Starting jdeCallObject Tue May 27 12:14:01.752001 Jdbodbc.c8352
ODB0000164 - STMT:00 [23000][2627] [Microsoft][SQL Native Client][SQL Server]Violation of PRIMARY KEY constraint 'F4945_PK'. Cannot insert duplicate key in object 'CRPDTA.F4945'.
5772/4484 WRK:Starting jdeCallObject Tue May 27 12:14:01.752002 Jdbodbc.c8352
ODB0000164 - STMT:01 [01000][3621] [Microsoft][SQL Native Client][SQL Server]The statement has been terminated.
From there, you may have found Violation of Primary key of F4945..
Step 4 In order to fix this violation error, you may refer below screenshot :
Hope that helps..
No comments:
Post a Comment