Message "Cannot access Staffware" displayed when accessing iProcess Administrator User Manager

Message "Cannot access Staffware" displayed when accessing iProcess Administrator User Manager

book

Article ID: KB0082991

calendar_today

Updated On:

Products Versions
TIBCO iProcess Workspace (Windows) All supported versions

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:
User Manager message
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