Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

ASE 15.5, not able to select from a table:

Hey,

Live backup restored to Reporting server and while selecting from the table ASE engine crashed
dbcc checktable(pm_schedule) says, page 8583904,partition ID 262552269 of object 262552269, contains an orphan row at offset 44 which is marked committed delete and is not.

An attempt was made to fetch logical page 8583905 for database pmt, object 'pm_schedule' (262552269), from cache 'default data cache'. Wrong logical page '1768843040' was found in cache.

1. select * into to different table failed
2. bcp failed
3. dbcc checktable((pm_schedule) - failed


Please do let me know if there is any option to recover the data completely.</p>

Former Member
Not what you were looking for? View more on this topic or Ask a question