My Oracle Support Banner

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

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
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.