Skip to Content
0

error 7114 sybase ASE

May 08 at 06:53 AM

31

avatar image
Former Member

Dear All

someone know how to manage the error 7114 for a table. We have this problem with TST03 and we do not know how to overcome.

There's a way to put to "null" the faulting page or delete the record?

please let me know.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Mehrab Bucktowar
May 09 at 11:59 AM
0

Hello Bruno,

Here is the writeup on error 7114:

Error 7114 occurs when Adaptive Server attempts to access or update a table’s text or image data, but the retrieved page is found to be a non-text page.

The tablename TST03 seems like a DDIC table. Try fixing the corruption using the dbcc command below and see if the error goes away:

isql -Usapsa -S<SID> -X 

1> use <SID>
2> go
1> setuser 'SAPSR3'
2> go
1> dbcc textalloc (TST03)
2> go

Hope this helps.

Mehrab

Share
10 |10000 characters needed characters left characters exceeded