We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


INTERNAL 4624: ROSSALColumnAccess position not found — Vertica Forum

INTERNAL 4624: ROSSALColumnAccess position not found

shalevsshalevs ✭
in General Discussion

Hi.
I have encountered this error for a specific table.
After some investigation, I found that the error occurs only when accessing one of the buddy projections.
Solution that worked:
1. Create a new super projection
2. Drop the old one
3. Rename if needed

Tagged:

Comments

  • Bryan_HBryan_H Vertica Employee Administrator
    edited July 2019

    Hi, that is the correct fix since it's usually due to a corrupt ROS index file, but we haven't seen this issue since version 7.2. Newer ROS file format and catalog improvements should not experience this issue. What version are you running?

  • shalevsshalevs ✭

    At first the error occurred in 9.1.1-11 and again in 9.2.1-11.
    Support responded that the issue fixed in 9.2.1-8 (VER-69389), but it seems that it's not the case.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...