iProcess Engine generates the Oracle "SWLOCALMSG" not found error
Article ID: KB0073748
Updated On:
| Products | Versions |
|---|---|
| TIBCO iProcess Engine (Oracle) | 11.4.1 |
Description
iProcess sw_error.log contains multiple entries for:
1892-AQIQL: OCI function 'OCITypeByName(AQ Message type)' failed: ORA Error: OCI-22303: type "SWPRO"."SWLOCALMSG" not found
1892-AQIQL: OCI function 'OCITypeByName(AQ Message type)' failed: ORA Error: OCI-22303: type "SWPRO"."SWLOCALMSG" not found
Issue/Introduction
iProcess sw_error.log contains multiple entries for:
1892-AQIQL: OCI function 'OCITypeByName(AQ Message type)' failed: ORA Error: OCI-22303: type "SWPRO"."SWLOCALMSG" not found
Environment
TIBCO iProcess Engine (Oracle) - All versions
Resolution
1. Check that the SWLOCALMSG database objects exists and is valid by running the SQL:
select OBJECT_NAME,SUBOBJECT_NAME,OBJECT_TYPE,STATUS from user_objects where OBJECT_NAME ='SWLOCALMSG';
2. The iProcess engine connects to the database as the iProcess database user (default SWUSER)
Make sure that the iProcess database user has permission to use the objects in the iProcess schema by running:
GRANT EXECUTE ON SWPRO.SWLOCALMSG TO SWUSER;
GRANT EXECUTE ON SWPRO.SWPACKAGEMSG TO SWUSER;
GRANT EXECUTE ON SYS.DBMS_AQ TO SWUSER;
GRANT EXECUTE ON SYS.DBMS_AQADM TO SWUSER;
Change the database users SWPRO and SWUSER in the above grants to reflect the iProcess installation/configuration.
select OBJECT_NAME,SUBOBJECT_NAME,OBJECT_TYPE,STATUS from user_objects where OBJECT_NAME ='SWLOCALMSG';
2. The iProcess engine connects to the database as the iProcess database user (default SWUSER)
Make sure that the iProcess database user has permission to use the objects in the iProcess schema by running:
GRANT EXECUTE ON SWPRO.SWLOCALMSG TO SWUSER;
GRANT EXECUTE ON SWPRO.SWPACKAGEMSG TO SWUSER;
GRANT EXECUTE ON SYS.DBMS_AQ TO SWUSER;
GRANT EXECUTE ON SYS.DBMS_AQADM TO SWUSER;
Change the database users SWPRO and SWUSER in the above grants to reflect the iProcess installation/configuration.
Additional Information
TIBCO iProcess® Engine (Oracle) Administrator's Guide
Feedback
Yes
No
Powered by
