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

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

Answers

  • deepikaymdeepikaym Employee

    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?

  • sreeblrsreeblr Employee

    Yes after we had reset permission the error went away.

  • Jim_KnicelyJim_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
    
    

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.