[4700] [55000] ERROR: Sequence tablename_columnname_seq has not been accessed in the session

sreeblr

Any idea why this error occurs and how to fix.?

Jim_Knicely

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

deepikaym

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?

sreeblr

Yes after we had reset permission the error went away.