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.

Symptoms

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
ORA-06510:
---------------------------------------------------------------------------
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
---------------------------------------------------------------------------

Changes

 

Cause

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

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


In this Document
Symptoms
Changes
Cause
Solution
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
References


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