[4700] [55000] ERROR: Sequence tablename_columnname_seq has not been accessed in the session
sreeblr
- Select Field - Employee
Any idea why this error occurs and how to fix.?
0
Best Answer
-
Jim_Knicely Administrator
Note that you also get this error when calling CURRVAL but not first calling NEXTVAL:
Example:
dbadmin=> CREATE SEQUENCE s; CREATE SEQUENCE dbadmin=> SELECT s.CURRVAL; ERROR 4700: Sequence s has not been accessed in the session
5
Answers
Hi, did you check the table and Cloumn's permission which is seeing this?
Is the transaction run using dbadmin ort another user who is not having access to the table?
Yes after we had reset permission the error went away.