Demantra Upgrade Error ORA-06502 In Apply Grant Process sys_grants.sql on GRANT_HTTP_TO_DEMANTRA.sql (Doc ID 2056789.1)

Last updated on JUNE 23, 2017

Applies to:

Oracle Demantra Demand Management - Version 12.2.4 and later
Information in this document applies to any platform.

Goal

I was applying the patch#19973580 to upgrade our demantra from 7.3.1.4 to 12.2.4.

During the process I got the error message " Errors were encountered during the execution of the "Apply Grants" process.


Below are the error from upgrade log file.

==========================
-09-14 16:13:14,390 [DEBUG] - STDOUT> Demantra User : DP
2015-09-14 16:13:14,390 [DEBUG] - STDOUT> ACL Type : STANDARD
2015-09-14 16:13:14,390 [DEBUG] - STDOUT> AppServerURL :xxxxxxxxxx:0000/demantra
2015-09-14 16:13:14,390 [DEBUG] - STDOUT> ACL Name : /sys/acls/demantra.xml
2015-09-14 16:13:14,390 [DEBUG] - STDOUT> DECLARE -- grant_http_to_demantra $Revision: 1.12 $
2015-09-14 16:13:14,390 [DEBUG] - STDOUT> *
2015-09-14 16:13:14,390 [DEBUG] - STDOUT> ERROR at line 1:
2015-09-14 16:13:14,390 [DEBUG] - STDOUT> ORA-06502: PL/SQL: numeric or value error: character to number conversion error
2015-09-14 16:13:14,390 [DEBUG] - STDOUT> ORA-06512: at line 579
2015-09-14 16:13:14,390 [DEBUG] - STDOUT>
2015-09-14 16:13:14,390 [DEBUG] - STDOUT>
2015-09-14 16:13:14,390 [DEBUG] - STDOUT> Disconnected from Oracle Database 11g Enterprise Release 11.2.0.3.0 - 64bit Production
2015-09-14 16:13:14,390 [DEBUG] - STDOUT> With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
2015-09-14 16:13:14,390 [DEBUG] - STDOUT> Data Mining and Real Application Testing options
2015-09-14 16:13:14,453 [DEBUG] - exitCode = proc.exitValue(): 6502
2015-09-14 16:13:14,547 [DEBUG] - Log file: null
2015-09-14 16:13:14,547 [DEBUG] - task.isFailed(): true
2015-09-14 16:13:14,547 [DEBUG] - Errors: * ORA-06502: PL/SQL: numeric or value error: character to number conversion error
* ORA-06512: at line 579

2015-09-14 16:13:14,547 [DEBUG] - Done executing com.demantra.panels.ExecuteDatabaseTasksPanel.



When tried to run GRANT_HTTP_TO_DEMANTRA.sql manually, get the same error message.

SQL> @GRANT_HTTP_TO_DEMANTRA.sql
Enter value for 1: xxxx
Enter value for 2:
SP2-0137: DEFINE requires a value following equal sign
Enter value for 3:
SP2-0137: DEFINE requires a value following equal sign
Enter value for acl_type:
Enter value for acl_name:
Demantra User : DP
ACL Type :
AppServerURL : xxxxxxxxxxx:0000/demantra
ACL Name : /sys/acls/demantra.xml
DECLARE -- grant_http_to_demantra $Revision: 1.12 $
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at line 579
 

Solution

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