Oracle Management Cloud

Introduction to Oracle Management Cloud We have been seeing so many products of Oracle off late. A new suite from Oracle named Oracle Manage...

Thursday, April 4, 2013

Concurrent Program failed with Error ORA-20003: FAILURE: AppServ Notification for Profile

Issue:

In ASCP, Concurrent Program using utl_http package has failed with below error in the log file:


ORA-20003: FAILURE: AppServ Notification for Profile ID=461Failed Return value: <!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 2.0//EN">
<HTML><HEAD>
<TITLE


Cause:

Pval in sys_params under Demantra Schema (MDSEM in our case) table has wrong value for pname AppServerURL 

Verification:

SQL>  select pname,PVAL
  2  from msdem.sys_params
  3  where PNAME='AppServerURL';

PNAME         PVAL
------------  --------------------------------------------
AppServerURL  http://demuatapp01.xyz.com:7778/demantra_uat


Solution:

SQL> update msdem.sys_params
set pval='http://demuatapp01.xyz.com:7778/demantra_uat11
where pname='AppServerURL';

SQL> Commit;

Now restart demantra application services.




No comments:

Post a Comment

Most Viewed Posts