iProcess Engine not starting after Oracle database repoint

iProcess Engine not starting after Oracle database repoint

book

Article ID: KB0081542

calendar_today

Updated On:

Products Versions
TIBCO iProcess Engine (Oracle) 11.5.0.16

Description

The iProcess Engine would not start after it had been moved from the Linux Red Hat  Server to a new Sun Solaris 10 server

Following the migration, the iProcess Engine would not start - the warning reported in the sw_warn.log is:

2018/01/09 06:33:07.969003(PROCMGR:2:7413:2::::pro:/aqiel.c:84579:306): 1878-AQ PubSub - Function loci_unsubscribe_event, Error Message OCISubscriptionUnRegister() failed, OCI Error ORA-24950: unregister failed, registration not found
 

Environment

TIBCO iProcess Engine (Oracle) 11.5.0.16 Redhat Enterprise Server 7.4 (Maipo) Oracle Database 11.2.0.4 Solaris Solaris (SPARC) 10 1/13

Resolution

Previously, the iProcess Engine had been running successfully on a LINUX Redhat 7.4 server.

The iProcess Engine on a Sun Solaris 10 server was pointed to the iProcess database.

The iProcess Engine would not start on the Sun Solaris 10 server.
 
The sw_warn.log entry indicates an issue with Oracle events and subscriptions.

The sys.reg$ table in the Oracle database contained old subscriptions for the iProcess Engine on the Redhat server.
 
These old subscriptions were deleted from the sys.reg$ table and iProcess started successfully on the Sun Solaris 10 server.


 

Issue/Introduction

iProcess Engine not starting after iProcess migration sw_warn.log: 2018/01/09 06:33:07.969003(PROCMGR:2:7413:2::::pro:/aqiel.c:84579:306): 1878-AQ PubSub - Function loci_unsubscribe_event, Error Message OCISubscriptionUnRegister() failed, OCI Error ORA-24950: unregister failed, registration not found