Error while posting the Batch

[Far]

When i am posting a batch of payroll from P0011 and batch type 7 i am getting the error below.

2180/8052 MAIN_THREAD Tue Oct 13 16:04:29.298000 Runbatch.c319
INITIALIZING RUNBATCH job: 174836

2180/8052 MAIN_THREAD Tue Oct 13 16:04:29.345000 ipcmisc.c299
process 2180 <runbatch.exe> registered in entry 28

2180/8052 MAIN_THREAD Tue Oct 13 16:04:29.392000 Runbatch.c464
Startup for User=PSFT, Env=JPD811, Role=*ALL, Job#=174836

2180/8052 MAIN_THREAD Tue Oct 13 16:04:29.407000 Runbatch.c481
bAPListening=0

2180/8052 MAIN_THREAD Tue Oct 13 16:04:30.376000 zdrv.cpp328
Initializing the Z Driver

2180/8052 MAIN_THREAD Tue Oct 13 16:04:30.376001 zdrv.cpp342
Gettting user data from hEnv

2180/8052 MAIN_THREAD Tue Oct 13 16:04:30.407000 zdrv.cpp364
User data is PSFT, JPD811

2180/8052 MAIN_THREAD Tue Oct 13 16:04:30.423000 zdrv.cpp373
Creating XML Session

2180/8052 WRK:Starting jdeCallObject Tue Oct 13 16:04:40.720000 Jdbodbc.c8349
ODB0000163 - wSQLExecute failure. rc=-1

2180/8052 WRK:Starting jdeCallObject Tue Oct 13 16:04:40.720001 Jdbodbc.c8349
ODB0000164 - STMT:00 [23000][2627] [Microsoft][SQL Native Client][SQL Server]Violation of PRIMARY KEY constraint 'F01131M_PK'. Cannot insert duplicate key in object 'PRODDTA.F01131M'.

2180/8052 WRK:Starting jdeCallObject Tue Oct 13 16:04:40.736000 Jdbodbc.c8349
ODB0000164 - STMT:01 [01000][3621] [Microsoft][SQL Native Client][SQL Server]The statement has been terminated.

2180/8052 WRK:Starting jdeCallObject Tue Oct 13 16:04:40.751000 Jdb_drvm.c1096
JDB9900401 - Failed to execute db request

2180/8052 WRK:Starting jdeCallObject Tue Oct 13 16:04:40.767000 Jdb_exet.c5906
JDB3400009 - Failed to perform Insert for F01131M

2180/8052 WRK:Starting jdeCallObject Tue Oct 13 16:04:40.782000 b0100011.c2357
*** PPAT error. Insert to F01131M failure. ***

2180/8052 MAIN_THREAD Tue Oct 13 16:04:47.033000 ipcmisc.c299
API ipcSawUnregisterProcV1 : process 2180 unregistered in entry 28

2180/8052 MAIN_THREAD Tue Oct 13 16:04:47.033001 zdrv.cpp389
Terminating Z driver

2180/8052 MAIN_THREAD Tue Oct 13 16:04:47.048000 zdrv.cpp406
Calling freeSession


Even we check i check the amount is not out of balance.

Can anyone help me.

 

[Mountain_Dave]

I voted for "Reply"...good luck!

 

[peterbruce]

Far,

The error in the log you provide is:

[ QUOTE ]
ODB0000164 - STMT:00 [23000][2627] [Microsoft][SQL Native Client][SQL Server]Violation of PRIMARY KEY constraint 'F01131M_PK'. Cannot insert duplicate key in object 'PRODDTA.F01131M'.


[/ QUOTE ]

Which means that the process is trying to insert a row in the F01131M which already exists (the unique key - ZMPSRK, ZMSERK - already exists). How many times have you tried to post the batch? Does this occur with all batch posting? Have you received the same error each time? I would suggest that you get your DBA and/or CNC to look at it.

 

[llallen1113]

I've run into this issue before with other tables. Take a look at the raw data, check to see if there is a corrupted record in that table (something maybe with null values in the primary key fields). If so, you need to delete the corrupted record. To do this, you may need to remove the primary key constraint, maybe even the primary key. Once the data is cleaned up, you should be able to add the key and constraint back to the table by using the generate indexes function in the JDE devlopment toolset.

I would consult with your DBA or CNC before doing anything.