hiscockp
Member
We have an issue with multiple parallel runs of the R03B525 - A/R Credit/Cash Management Build program.
The program is taking 6+ hours to execute over a customer base of some 300,000 customers. JD Edwards White Paper (SAR 3117466) has been applied to allow multiple runs of the R03B525 program.
The issue is that we sometimes receive an Index Violation error in the Job Log file when runnning 2 versions of the job concurrently. The error is as follows
361/446 Thu Nov 29 17:46:12 2001 DBPERFRQ226
OCI0000178 - Unable to execute - 0 - INSERT INTO CARDTA.F03B31
(ZGAVID, ZGAIT, ZGAN8, ZGCO, ZGUKID, ZGAIPR, ZGDTI, ZGRMK,
ZGAA1, ZGAA2, ZGUSER, ZGPID, ZGUPMJ, ZGUPMT, ZGJOBN)
VALUES
BND1,:BND2,:BND3,:BND4,:BND5,:BND6,:BND7,:BND8,:BND9,
:BND10,:BND11,:BND12,:BND13,:BND14,:BND15)
361/446 Thu Nov 29 17:46:12 2001 DBPERFRQ233
OCI0000179 - Error - ORA-00001: unique constraint (CARDTA.F03B31_1) violated
361/446 Thu Nov 29 17:46:12 2001 JDB_DRVM840
JDB9900170 - Failed to execute db request
361/446 Thu Nov 29 17:46:12 2001 JDB_EXET4359
JDB3400009 - Failed to perform Insert for F03B31
F03B31 is the Customer Activity Table.
The error occurs about 4 times during parallel processing of the job regardless of whether the jobs are run on the same or different Application Servers. We have not
detected any particular pattern associated with the error. We have checked the data and have not found any conditions that might lead to duplication of F03B31 records.
Is anyone using R03B525 in the Multiple Run situation?
Has anyone experienced this type of error on B7332 SP 11.3 - NT/RS6000-AIX/Oracle?
B733.2 - SP11.3, NT, RS6000, Oracle
The program is taking 6+ hours to execute over a customer base of some 300,000 customers. JD Edwards White Paper (SAR 3117466) has been applied to allow multiple runs of the R03B525 program.
The issue is that we sometimes receive an Index Violation error in the Job Log file when runnning 2 versions of the job concurrently. The error is as follows
361/446 Thu Nov 29 17:46:12 2001 DBPERFRQ226
OCI0000178 - Unable to execute - 0 - INSERT INTO CARDTA.F03B31
(ZGAVID, ZGAIT, ZGAN8, ZGCO, ZGUKID, ZGAIPR, ZGDTI, ZGRMK,
ZGAA1, ZGAA2, ZGUSER, ZGPID, ZGUPMJ, ZGUPMT, ZGJOBN)
VALUES
BND1,:BND2,:BND3,:BND4,:BND5,:BND6,:BND7,:BND8,:BND9,:BND10,:BND11,:BND12,:BND13,:BND14,:BND15)
361/446 Thu Nov 29 17:46:12 2001 DBPERFRQ233
OCI0000179 - Error - ORA-00001: unique constraint (CARDTA.F03B31_1) violated
361/446 Thu Nov 29 17:46:12 2001 JDB_DRVM840
JDB9900170 - Failed to execute db request
361/446 Thu Nov 29 17:46:12 2001 JDB_EXET4359
JDB3400009 - Failed to perform Insert for F03B31
F03B31 is the Customer Activity Table.
The error occurs about 4 times during parallel processing of the job regardless of whether the jobs are run on the same or different Application Servers. We have not
detected any particular pattern associated with the error. We have checked the data and have not found any conditions that might lead to duplication of F03B31 records.
Is anyone using R03B525 in the Multiple Run situation?
Has anyone experienced this type of error on B7332 SP 11.3 - NT/RS6000-AIX/Oracle?
B733.2 - SP11.3, NT, RS6000, Oracle
