ORA-01403: When Running sys_grants.sql (Doc ID 1963211.1)

Last updated on AUGUST 21, 2016

Applies to:

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

Symptoms

When user runs the work flow RUN ENGINE it fails at setup RunLinuxForecast , they get the below error message in Collaborator Workbench


Process ID: 785575
Schema ID: 1313
Schema name: ’’Run Engine’’
Step ID: ’’Step3’’
Step name: ’’RunLinuxForecast’’

Error description ’’Database internal error:ORA-29273: HTTP request failed’’

Checking the error from db_exception_log table, they realize that they need to create the ACLs.

  Below is the Exception from dbexception_log table.
  URL "http://xxxxxx.xxx.com:1234/engineManager/EngineManagerStarterServlet?command=start&mode=1&profile_id=1" returned error:
  -29273 : ORA-29273: HTTP request failed
  ORA-06512: at "SYS.UTL_HTTP", line 1819
  ORA-24247: network access denied by access control list (ACL)


When they run the sys_grants.sql to grant ACL privileges they got the below error message
 
  ERROR at line 1:
  ORA-44416: Invalid ACL: Unresolved principal 'DEMANTRA2'
  ORA-06512: at "SYS.DBMS_NETWORK_ACL_ADMIN", line 384
  ORA-06512: at line 1


They dropped their ACLS and then re ran sys_grants but it fails with

Demantra User  : DEMANTRA
ACL Type       : STANDARD
AppServerURL   : http://xxxxxx.xxx.com:1234/demantra
ACL Name       : /sys/acls/demantra.xml
ACL Server     : xxxxxx.xxx.com
ACL Port       : 1234
DECLARE  -- grant_http_to_demantra $Revision: 1.5.2.1.4.2 $
*
ERROR at line 1:
ORA-01403: no data found
ORA-01403: no data found
ORA-06512: at line 579


When they try to create the ACLs manually, they are getting the following

SQL> sho user
USER is "SYS"
SQL> BEGIN
DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL (
acl => '/sys/acls/demantra.xml', host=> 'xxxxxx.xxx.com',lower_port => 1234, upper_port => 1234);
COMMIT;
END;
/   2    3    4    5    6
BEGIN
*
ERROR at line 1:
ORA-01403: no data found
ORA-06512: at "SYS.DBMS_NETWORK_ACL_ADMIN", line 556
ORA-06512: at "SYS.DBMS_NETWORK_ACL_ADMIN", line 488
ORA-06512: at line 2




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