My Oracle Support Banner

DQM Parallel Sync Index Child Program Failing With ORA-06502 ORA-20000: Oracle Text error: DRG-50857: Oracle Error in drftpwait ORA-06510 (Doc ID 1670601.1)

Last updated on JULY 30, 2018

Applies to:

Oracle Trading Community - Version 12.1.1 and later
Information in this document applies to any platform.


Post R12 Upgrade:

Attempting to run the concurrent program "DQM Parallel Sync Index Child Program" and receive the following error:

ORACLE error 6502 in FDPSTP

Cause: FDPSTP failed due to ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "APPS.HZ_DQM_SYNC", line 2856
ORA-20000: Oracle Text error:
DRG-50857: oracle error in drftpwait
Start of log messages from FND_FILE
 Starting Sync Index Parallel Child concurrent Program for index AR.hz_stage_party_sites_t1
 Schema name stripped index is HZ_STAGE_PARTY_SITES_T1
 index owner is AR
End of log messages from FND_FILE




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.