Blogroll

Get a website with Godaddy


Logo designer Fiverr Frelancer

Thursday, May 29, 2014

Debug - Commit Failed when entering in P4210


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

Amazon store

alidropship plugin

alidropship plugin
alidropship plugin

Total Pageviews

About