SVU fails with ERROR: ORA-06502: PL/SQL: numeric or value error: Bulk Bind: Truncated (Doc ID 1964132.1)

Last updated on MARCH 08, 2017

Applies to:

Portal - Version 11.1.1.6.0 and later
Information in this document applies to any platform.

Symptoms


When attempting to run SVU in Report Mode, the following error occurs.

# ERROR: An error occured when validating parent id for pages
# ERROR: ORA-06502: PL/SQL: numeric or value error: Bulk Bind: Truncated

Complete error stack:

# ERROR: An error occured when validating parent id for pages
# ERROR: ORA-06502: PL/SQL: numeric or value error: Bulk Bind: Truncated
# ----- PL/SQL Call Stack -----
 object      line  object
 handle    number  name
0x277e04110       434  package body DEV_PORTAL.WWPOF
0x27771cc28      2942  package body DEV_PORTAL.WWUTL_PAGE_VALIDATION
0x27771cc28      4178  package body DEV_PORTAL.WWUTL_PAGE_VALIDATION
0x27792d828       208  package body DEV_PORTAL.WWUTL_SCHEMA_VALIDATION
0x27792d828       308  package body DEV_PORTAL.WWUTL_SCHEMA_VALIDATION
0x2778fa770        88  anonymous block

# Handling exception
# ERROR: An error occured when validating all pages
# ERROR: ORA-20000:
ORA-06512: en "DEV_PORTAL.WWPOF", linea 440
ORA-06512: en "DEV_PORTAL.WWUTL_PAGE_VALIDATION", linea 2942
ORA-06502: PL/SQL: numeric or value error: Bulk Bind: Truncated

# ----- PL/SQL Call Stack -----
 object      line  object
 handle    number  name
0x277e04110       434  package body DEV_PORTAL.WWPOF
0x27771cc28      4258  package body DEV_PORTAL.WWUTL_PAGE_VALIDATION
0x27792d828       208  package body DEV_PORTAL.WWUTL_SCHEMA_VALIDATION
0x27792d828       308  package body DEV_PORTAL.WWUTL_SCHEMA_VALIDATION
0x2778fa770        88  anonymous block

# Handling exception
# ERROR: An error occured when executing schema validation utility
# ERROR: ORA-20000:
ORA-06512: en "DEV_PORTAL.WWPOF", linea 440
ORA-06512: en "DEV_PORTAL.WWUTL_PAGE_VALIDATION", linea 4258
ORA-20000:
ORA-06512: en "DEV_PORTAL.WWPOF", linea 440
ORA-06512: en "DEV_PORTAL.WWUTL_PAGE_VALIDATION", linea 2942
ORA-06502: PL/SQL: numeric or value error: Bulk Bind: Truncated

# ----- PL/SQL Call Stack -----
 object      line  object
 handle    number  name
0x277e04110       434  package body DEV_PORTAL.WWPOF
0x27792d828       273  package body DEV_PORTAL.WWUTL_SCHEMA_VALIDATION
0x27792d828       308  package body DEV_PORTAL.WWUTL_SCHEMA_VALIDATION
0x2778fa770        88  anonymous block

# Handling exception
# ERROR: Error while running schema validation utility
# ERROR: ORA-20000:
ORA-06512: en "DEV_PORTAL.WWPOF", linea 440
ORA-06512: en "DEV_PORTAL.WWUTL_SCHEMA_VALIDATION", linea 273
ORA-20000:
ORA-06512: en "DEV_PORTAL.WWPOF", linea 440
ORA-06512: en "DEV_PORTAL.WWUTL_PAGE_VALIDATION", linea 4258
ORA-20000:
ORA-06512: en "DEV_PORTAL.WWPOF", linea 440
ORA-06512: en "DEV_PORTAL.WWUTL_PAGE_VALIDATION", linea 2942
ORA-06502: PL/SQL: numeric or value error: Bulk Bind: Truncated

# ----- PL/SQL Call Stack -----
 object      line  object
 handle    number  name
0x277e04110       434  package body DEV_PORTAL.WWPOF
0x2778fa770       115  anonymous block

 

Cause

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 hundreds of Community platforms