book
Article ID: KB0082991
calendar_today
Updated On:
Description
When attempting to access the TIBCO iProcess Administrator the message "Cannot access Staffware" is displayed and the User Manager fails to open.
See example:
The message may also be displayed when attempting to open the Tables Manager or List Manager.
Issue/Introduction
Message "Cannot access Staffware" displayed when accessing iProcess Administrator User Manager
Environment
All supported operating systems
Resolution
One or more of the rows in the flag_table is missing. There should be four rows in the flag_table. Here is an example of the default values,
SQL> select * from flag_table;
AREA_ID AREA_LOCKED AREA_CHANGED MOVE_REQ USER_NAME
---------- ----------- ------------ ---------- --------------------------------
1 0 0 0
2 0 0 0
3 0 0 0
4 0 0 0
Add one or more of the following entries to the table depending on which rows are missing.
INSERT INTO flag_table VALUES (1, 0, 0, 0, NULL);
INSERT INTO flag_table VALUES (2, 0, 0, 0, NULL);
INSERT INTO flag_table VALUES (3, 0, 0, 0, NULL);
INSERT INTO flag_table VALUES (4, 0, 0, 0, NULL);
Once these have been committed, login to the iProcess Administrator User Manager.
Additional Information
For a definition of the flag_table and its rows, refer to the following.
TIBCO iProcess Engine (Oracle/SQL/DB2) Administrator's Guide