Kbase 19826: How to recover if the _user table is cleared through 4GL
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
GOAL:
How to recover if the _user table is cleared through 4GL
FIX:
If the _User table is cleared through 4GL in UNIX, clients will not be able to connect to the database. When they log in, they immediately are logged out.
This occurs because Progress has other data in the table besides the user records, such as, for example, code page information.
If the log out problem happens, take the following steps:
1) Add a user record to the _user table in the Sports database.
2) Export the table.
3) Import the table into the damaged database.
4) Connect to the damaged database using the -U username option.
5) Go into Data Administration & delete the user record.
Now the _user table will be fine and clients can connect to the database.
These steps are not necessary on a Windows platform. On Windows, it is possible to dump the _user table from any database, including one with zero records, and then load it into the damaged database.