Error Importing HTML Template And Deleting Component - PLS-00306: wrong number or types of arguments in call to 'SYNCRN' (Doc ID 1624549.1)

Last updated on MARCH 08, 2017

Applies to:

Portal - Version 11.1.1.6.0 and later
Information in this document applies to any platform.

Symptoms

After attempting to import an HTML template into an 11.1.1.6.0 Portal running on a 11.2.0.4 database, an error is seen in the log.

...
Context: WWUTL_API_IMPORT_PAGEGROUP.merge_approval BPEL is in...
Context: WWUTL_API_IMPORT_PAGEGROUP.merge_approval BPEL is merging...
Context: WWUTL_API_IMPORT_PAGEGROUP.MergeImportedSite Rolling back merge phase changes...
Context: WWUTL_API_IMPORT_PAGEGROUP.Start_Import ORA-01086: savepoint 'IMPORT_SITE' never established in this session or is invalid ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'SYNCRN' ORA-06550: line 1, column 7: PL/SQL: Statement ignored
ORA-01086: savepoint 'IMPORT_SITE' never established in this session or is invalid ORA-06512: at "LBV_PORTAL.WWUTL_API_IMPORT_PAGEGROUP", line 28100 ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'SYNCRN' ORA-06550: line 1, column 7: PL/SQL: Statement ignored


Also when attempting to delete any component through Portal web UI, this error is seen :

Unable to process request. Please check the log file for more details.


The corresponding Portal Diagnostic log has the following :-

[2014-02-14T10:06:50.615+01:00] [WLS_PORTAL] [ERROR] [] [oracle.portal] [tid: [ACTIVE].ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: ] [ecid: 4080075447457,0:1:1:1] [APP: portal] [URI: /portal/pls/portal/LBV_PORTAL.wwpob_page_dialogs.showconfirmdelete] ERROR: Repository Gateway error: Database Error: ORA=6550 ORA-06550: line 1, column 7:[[
PLS-00306: wrong number or types of arguments in call to 'SYNCRN'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
ORA-06512: at "XXX_PORTAL.WPG_SESSION", line 367
ORA-06512: at line 43
]]
[2014-02-14T10:06:50.616+01:00] [WLS_PORTAL] [NOTIFICATION] [] [oracle.portal] [tid: [ACTIVE].ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: ] [ecid: 4080075447457,0:1:1:1] [APP: portal] [URI: /portal/pls/portal/XXX_PORTAL.wwpob_page_dialogs.showconfirmdelete] Oracle error: ORA-6550

 

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