Error: 00504 WSP CRP Cannot relocate pointer

forum.sqlbase (2000-2010)
NewsgroupServer
Robot
Robot
Posts: 118939
Joined: 24 Feb 2017, 12:00
Location: World wide

Error: 00504 WSP CRP Cannot relocate pointer

Post by NewsgroupServer » 23 Feb 2009, 18:12

 Posted by:  Jeannie Washburn 

I received the above error as I was dropping a table to recreate it
because of a corrupt index.

Last week, a user accessed part of our application that is used very
little. A corrupt index error occurred when she was accessing the table.
I ran a check index on it, and it said the index did not exist (even
though I see it in SqlConsole). When I run a check table on the table
that is being indexed, it comes back as okay. I unloaded the table and
looked at the file, and the create index statement is there. So I
figured I would just drop and recreate the table (it is small), but I
receive the above error when I try to drop the table. Also, when I ran
the check database command, it came back okay.

I'd appreciate any help!

I am running Sqlbase 9.0.

NewsgroupServer
Robot
Robot
Posts: 118939
Joined: 24 Feb 2017, 12:00
Location: World wide

Error: 00504 WSP CRP Cannot relocate pointer

Post by NewsgroupServer » 24 Feb 2009, 09:57

 Posted by:  Rainer Ebert 

I would unload and load the whole database.
Regards,
Rainer

Return to “forum.sqlbase”

Who is online

Users browsing this forum: Ccbot [Crawler] and 0 guests