iProcess Web Services Server Plug-in – ORA-01401 error when running the Security Manager
Article ID: KB0078056
Updated On:
| Products | Versions |
|---|---|
| TIBCO iProcess Web Services Server Plug-in | 11.3.0 |
Description
iProcess Web Services Server Plug-in – ORA-01401 error when running the Security Manager (securitymanager.sh on Unix or securitymanager.cmd on windows)
ORA-01401:no data found
ORA-96512: at “SWPRO.SP_EAIWS_SEC_PROF_SEQUENCE”, line 4
ORA-06512: at line 1
ORA-01401:no data found
ORA-96512: at “SWPRO.SP_EAIWS_SEC_PROF_SEQUENCE”, line 4
ORA-06512: at line 1
Issue/Introduction
iProcess Web Services Server Plug-in – ORA-01401 error when running the Security Manager (securitymanager.sh on Unix or securitymanager.cmd on windows)
ORA-01401:no data found
ORA-96512: at “SWPRO.SP_EAIWS_SEC_PROF_SEQUENCE”, line 4
ORA-06512: at line 1
Environment
TIBCO iProcess Web Services Server Plug-in
All platforms using an Oracle database
Resolution
The Security Manager is supported by database objects including tables, stored procedures, and rows in the SEQUENCES database table.
The stored procedure SP_EAIWS_SEC_PROF_SEQUENCE failed to find the relevant row in the SEQUENCES database table.
The rows in the SEQUENCES database table were missing for:
Sequence 22 with the name EAIWS_URL_ALIAS
Sequence 23 with the name EAIWS_SECURITY_PROFILE
The resolution is to insert the rows in the SEQUENCES database table and set the SEQ_VAL column to the correct value using the SQL:
insert into SEQUENCES values (22,0,’EAIWS_URL_ALIAS’);
insert into SEQUENCES values (23,0,’EAIWS_SECURITY_PROFILE’);
update SEQUENCES set SEQ_VAL = NVL((select max(ALIAS_ID)+1 from EAIWS_URL_ALIAS),0) where SEQ_ID=22;
update SEQUENCES set SEQ_VAL = NVL((select max(ID)+1 from EAIWS_SECURITY_PROFILE),0) where SEQ_ID=23;
The SQL should be run as the iProcess database schema owner (default SWPRO).
The stored procedure SP_EAIWS_SEC_PROF_SEQUENCE failed to find the relevant row in the SEQUENCES database table.
The rows in the SEQUENCES database table were missing for:
Sequence 22 with the name EAIWS_URL_ALIAS
Sequence 23 with the name EAIWS_SECURITY_PROFILE
The resolution is to insert the rows in the SEQUENCES database table and set the SEQ_VAL column to the correct value using the SQL:
insert into SEQUENCES values (22,0,’EAIWS_URL_ALIAS’);
insert into SEQUENCES values (23,0,’EAIWS_SECURITY_PROFILE’);
update SEQUENCES set SEQ_VAL = NVL((select max(ALIAS_ID)+1 from EAIWS_URL_ALIAS),0) where SEQ_ID=22;
update SEQUENCES set SEQ_VAL = NVL((select max(ID)+1 from EAIWS_SECURITY_PROFILE),0) where SEQ_ID=23;
The SQL should be run as the iProcess database schema owner (default SWPRO).
Additional Information
TIBCO iProcess Web Services Server Plug-in Installation Guide
TIBCO iProcess Web Services Plug-in User Guide
TIBCO iProcess Web Services Plug-in User Guide
Feedback
Yes
No
Powered by
