SAP Knowledge Base Article - Preview

2818609 - Msg 156 raised by sp_dropdevice - SAP ASE

Symptom

  • When executing sp_dropdevice after a recent upgrade to SP03 PL07, error message 156 is reported:

1> sp_dropdevice mydevice, dropfile
2> go
Msg 156, Level 15, State 2:
Server 'ase16', Procedure 'sp_dropdevice', Line 236:
Incorrect syntax near the keyword 'else'.
Msg 11031, Level 16, State 1:
Server 'ase16', Procedure 'sp_dropdevice', Line 236:
Execution of procedure sp_dropdevice failed because of errors parsing the source
text in syscomments during upgrade. Please drop and recreate dbo.sp_dropdevice.

  • Alternately, dbcc upgrade_object("sybsystemprocs","sp_dropdevice", "check") will report error 153:

1> dbcc upgrade_object("sybsystemprocs", "sp_dropdevice", "check")
2> go
DBCC upgrade_object: Syntax checking PROCEDURE dbo.sp_dropdevice
Msg 156, Level 15, State 2:
Server 'ase16', Procedure 'sp_dropdevice', Line 236:
Incorrect syntax near the keyword 'else'.
Msg 11031, Level 16, State 1:
Server 'ase16', Procedure 'sp_dropdevice', Line 236:
Execution of procedure sp_dropdevice failed because of errors parsing the source
text in syscomments during upgrade. Please drop and recreate dbo.sp_dropdevice.
DBCC upgrade_object: PROCEDURE dbo.sp_dropdevice syntax check failed


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) SP03 PL07

Product

SAP Adaptive Server Enterprise 16.0

Keywords

CR819746, CR#819746, 819746 , KBA , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.