Kbase P79693: Receive 2913 error when trying to add users to a table via a 4GL application.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
04/10/2010 |
|
Status: Unverified
SYMPTOM(s):
Receive 2913 error when trying to add users to a table via a 4GL application.
Unknown sequence expression <sequence name>. (2913)
Unknown sequence expression user-num. (2913)
The seqtempfix option to proutil has been used earlier to address some earlier 3191 errors.
SYSTEM ERROR: Failed to extract field <field-num> from <file-name> record (table <table-num>) with recid <RECID>. (3191)
FACT(s) (Environment):
HP-UX
Progress 9.1C
proutil <dbname> -C seqtempfix
CAUSE:
Sequence user-num was missing from the data dictionary.
FIX:
Added the sequence for user-num to the database via the data dictionary.
1. Connect to Database
2. Go into Data Dictionary
3. Select Options -> Sequence Mode
4. Left column shows database you are connected to. Right column shows all Sequences loaded for this database.
5. Select Create Sequence and add Sequence information.