Kbase P118285: Compaction job fails with error 3142
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
13/07/2007 |
|
Status: Unverified
FACT(s) (Environment):
Fathom Management 3.x
SYMPTOM(s):
Compaction job fails with error 3142
You do not have sufficient permission to increment sequence values. (3142)
Insufficient access privilege for table Cf_Sample. (234)
QUERY-OPEN for query requires a previous QUERY-PREPARE. (7312)
Cannot run GET methods on query until it is opened. (7313)
No Sample record is available. (91)
CAUSE:
The user does not have permission on the _sequence table to read the sequence values.
FIX:
1. Provide to the user the permission on the _Sequence table to read a sequence value. You do this through the Data Dictionary on UNIX, or the Data Administration tool on Windows.
On UNIX:
a) pro dbname -p _dict.p
b) Admin / Security / Edit Data Security menu.
c) When it asks for the table name, Enter "_sequence" without the quotes.
d) Change the _sequence schema as appropriate.
On Windows:
a) Data Administration tool.
b) Connect to your database.
c) Admin / Security / Edit Data Security menu.
d) Tick the "Show Hidden" toggle box.
e) Select the _sequence table.
f) Change the _sequence schema as appropriate.
2. Make sure that the database connection statement has the -U -P parameters and values.