Symptom
- You are running Sybase ASE
- Your table or column name is 'merge' or 'MERGE'
- You are running the SQL command 'reorg rebuild'
- You see that 'reorg rebuild' fails
- Upon failure you may see errors 156, 11050 and 11934 raised
- If the column name is 'merge' or 'MERGE' you will receive errors similar to following
Beginning REORG REBUILD of table '<table with column "merge" or "MERGE">'.
Msg 156, Level 15, State 2:
Server '<servername or SID>', Line 1:
Incorrect syntax near the keyword 'MERGE INTO'.
Msg 11050, Level 16, State 3:
Server '<servername or SID>', Line 1:
Adaptive Server cannot process this ALTER TABLE statement due to one or more preceding errors.
If there are no preceding errors, please contact Sybase Technical Support.
Msg 11934, Level 16, State 1:
Server '<servername or SID>', Line 3:
REORG REBUILD of table '<table>' failed due to an internal error. Please contact SYBASE Technical Support.
- If the table name is 'merge' or 'MERGE', you will receive errors similar to this:
Beginning REORG REBUILD of table 'merge'.
Msg 156, Level 15, State 2:
Server '<servername or SID>', Line 1:
Incorrect syntax near the keyword 'merge partition'.
Msg 11934, Level 16, State 1:
Server '<servername or SID>', Line 1:
REORG REBUILD of table 'merge' failed due to an internal error. Please contact SYBASE Technical Support.
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 15.7 or higher for Business Suite (BS)
SAP Adaptive Server Enterprise (ASE) 15.7 or higher
Product
Keywords
CR736622, CR#736622, 736622, SQL156, SQL11050, SQL11934 , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.