Skip to Content

error 7114 sybase ASE

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 09 at 11:59 AM

    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

    Add comment
    10|10000 characters needed characters exceeded