My Oracle Support Banner

API_CREATE_ORA_DEM_USER Fails With ORA-29273 and ORA-12535 (Doc ID 2303321.1)

Last updated on JULY 20, 2020

Applies to:

Oracle Demantra Demand Management - Version 7.3.0 to 12.2.4.1 [Release 7.3.0 to 12.2]
Information in this document applies to any platform.

Symptoms

1) Executed the following store procedure:

execute API_CREATE_ORA_DEM_USER ('<USER>', '<PASSWORD>', '<FIRSTNAME>', '<LASTNAME>', '37', ' ', ' ', '<EMAIL>', 9, 4 ,'Demand Management', '' ,'UPDATE');

And got the following error:

execute API_CREATE_ORA_DEM_USER ('<USER>', '<PASSWORD>', '<FIRSTNAME>', '<LASTNAME>', '37', ' ', ' ', '<EMAIL>', 9, 4 ,'Demand Management', '' ,'UPDATE');

ERROR at line 1:
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1817
ORA-12535: TNS:operation timed out
ORA-06512: at "DEMANTRA.HELPER", line 2135
ORA-06512: at "DEMANTRA.API_CREATE_ORA_DEM_USER", line 529
ORA-06512: at line 1
29273. 00000 - "HTTP request failed"
*Cause: The UTL_HTTP package failed to execute the HTTP request.
*Action: Use get_detailed_sqlerrm to check the detailed error message.
  Fix the error and retry the HTTP request.

Subsequent attempts to use new connection information fails

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. execute API_CREATE_ORA_DEM_USER
2. Observe the noted error
3. Observe that attempts to log in to collaborator workbench fail using the updated information.

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
References


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