How To Determine If WebLogic Portal (WLP) Patch CR244936 Was Applied? (Doc ID 884444.1)

Last updated on FEBRUARY 12, 2025

Applies to:

Symptoms

How to determine if patch # CR244936 was applied in a WebLogic Portal (WLP) 8.1.6 environment in order to determine whether or not to run the pf9_drop_columns.sql script on the WLP Database (DB). The 10.3.0 upgrade notes state the following:

7. If you are upgrading a main WebLogic Portal database from 8.1 SP4, SP5, or SP6, determine if patch # CR244936 was applied. If this patch was applied, manual upgrade of the main WebLogic Portal database is complete. This patch is described in the WLP 8.1.5 Release Notes as follows:

CR237251 - If markup contains more than 4000 bytes, an attempt to store it in the database causes an error. If your database does not contain a PF_MARKUP_XML table that has been populated with data (for example, Select count(*) from PF_MARKUP_XML returns 0 rows) and the PF_MARKUP_DEFINITION table does not contain the BEGIN_XML and END_XML columns, then this patch was not applied.

8. If you are upgrading a main WebLogic Portal database from 8.1 SP4, SP5, or SP6 and patch # CR244936 has not been applied, run the following script against your database:

<WLPORTAL_HOME>\portal\db\<DBMS>\pf9_drop_columns.sql

If you perform the DB upgrade and patch CR244936 has not been applied, you might see the following type of error during application deployment:

javax.ejb.EJBException: SQL Error while trying to createMarkupDefinition: SQL [insert into PF_MARKUP_DEFINITION ( MARKUP_DEFINITION_ID, MARKUP_NAME, MARKUP_TYPE, WEBAPP_NAME, MARKUP_FILE) values (?,?,?,?,?)] database error code [1,400] SQL state [23000]. Possible markup duplication of [
MarkupDefinition:
webAppName = <WEBAPP NAME>
type = Shell
name = bookOnly
file = /framework/markup/shell/bookOnly.shell
beginXml =
endXml =
MarkupDefinitionId = null].; nested exception is: java.sql.SQLException: [BEA][Oracle JDBC Driver][Oracle]ORA-01400: cannot insert NULL into ("<DATABASE>"."PF_MARKUP_DEFINITION"."BEGIN_XML")

at com.bea.netuix.application.manager.persistence.jdbc.MarkupDefinitionDelegate.createMarkupDefinition(MarkupDefinitionDelegate.java:871)

Cause

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