Troubleshooting Errors: WWC-40019, ORA-24247, WWC-00006 and WWC-41417 After Upgrading Portal Metadata Repository from 10g to 11g (Doc ID 751842.1)

Last updated on NOVEMBER 21, 2016

Applies to:

Portal - Version 10.1.4.2 and later
Information in this document applies to any platform.
Checked for relevance on 01-Apr-2013

Symptoms

 

 

SymptomError
After performing the upgrade to Portal 10.1.4.2.0 using the Application Server 10.1.2.3 patch and upgrading the stand alone Metadata Repository to version 11, Web Cache Invalidation from Portal no longer works. The error WWC-40019 is generated when making any page change which will generate a cache
invalidation message to Web Cache such as editing the page content or structure.

In addition the following error will occur if an attempt is made to personalize the page.

Internal error (WWC-00006)
Unexpected error encountered in wwptl_fapp.show_edit_list (ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1674
ORA-24247: network access denied by access control list (ACL)) (WWC-41417)
The system failed to retrieve the necessary HTTP request to the SSO Server. (WWC-41447)
Upgrade metadata repository for portal schemas failed (Portal10.1.4.2 to Portal11.1.1.4.0) ### Connect to OID as Application Entry

>>> Running upg/common/prechk/bindapp.sql .
Portal SQL script started at Wed Feb 23 11:26:39 2011
# Beginning outer script: prechk/bindapp
#-- Beginning inner script: prechk/bindapp
# Pre-check to test bind to OracleAS Internet Directory Server
declare
*
ERROR at line 1:
ORA-20000:
ORA-06512: at "PORTAL.WWPOF", line 1069
ORA-06512: at line 28
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-24247: network access denied by access control list (ACL)


# Connecting to OracleAS Internet Directory as the Application Entry
# Handling exception
# ERROR: WWU-00031: LDAP ERROR: ORA-24247: network access denied by
# access control list (ACL) Unable to connect to the Oracle
# Internet Directory server.
# CAUSE: An error was encountered while connecting to the Oracle
# Internet Directory server.
# ACTION: The error message above may provide more information about
# the cause. Make sure that the Oracle Internet Directory
# server is up and running on host owl.cuny.edu and port 389
# and OracleAS Portal has been wired correctly against it.
# ERROR: User-Defined Exception
# ----- PL/SQL Call Stack -----
object line object
handle number name
3a703d598 1063 package body PORTAL.WWPOF
3a78a6dd0 28 anonymous block

###
### ERROR: Exception Executing upg/common/prechk/bindapp.sql 0 for Subscriber: 1
###
### Check Failed at Wed Feb 23 11:26:39 2011 Continuing as PreCheck mode is specified
Unable to Login to Portal after upgrade the Portal Metadata Repository from 11.2.0.1 to 11.2.0.2 Internal error (WWC-00006)
Unexpected error encountered in wwsec_app_priv.process_signon (User-Defined Exception) (WWC-41417)
Error while connecting to the Oracle Internet Directory. (WWC-41470)

Portal logging shows the following error:

URL: http://abc.com:7788/portal/pls/portal.wwsec_app_priv.process_signon
sqlerrm=User-Defined Exception
LDAP error=ORA-24247: network access denied by access control list (ACL)
[START-ERROR-STACK]
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-24247: network access denied by access control list (ACL)
[END-ERROR-STACK]
[START-CALL-STACK]

 

Changes

Upgrade the Oracle Portal Metadata Repository Database to 11g and above and/or Oracle Portal to 10.1.4.2.0 to Oracle Portal 11g.

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