SAP Knowledge Base Article - Preview

2275334 - Cannot execute 'drop function' from installmaster script - SAP ASE

Symptom

  • Running the installmaster script
  • ASE shows the following errors:

Msg 3705, Level 16, State 1:
Server 'SYBASE', Line 4:
Cannot use DROP FUNCTION with 'sp_jdbc_column_default' because 'sp_jdbc_column_default' is a procedure. Use DROP PROCEDURE.

Msg 2714, Level 16, State 1:
Server 'SYBASE', Procedure 'sp_jdbc_column_default', Line 168:
There is already an object named 'sp_jdbc_column_default' in the database.

Msg 2809, Level 18, State 1:
Server 'SYBASE', Procedure 'sp_jdbc_columns', Line 70:
The request for function 'dbo.sp_jdbc_column_default' failed because 'dbo.sp_jdbc_column_default' is a procedure object.

Msg 14217, Level 16, State 1:
Server 'SYBASE', Procedure 'sp_jdbc_columns', Line 70:
SQL function not found. If you are attempting to call a java UDF, Java services are not enabled.

Msg 7988, Level 16, State 1:
Server 'SYBASE', Procedure 'sp_procxmode', Line 159:
The specified object 'sp_jdbc_columns' is not found in database 'sybsystemprocs'. Check sysobjects to make sure you own the object.

Msg 208, Level 16, State 2:
Server 'SYBASE', Line 1:
sp_jdbc_columns not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7
  • SAP Adaptive Server Enterprise (ASE) 16.0
  • SAP Adaptive Server Enterprise SDK 15.7
  • SAP Adaptive Server Enterprise SDK 16.0

Product

SAP Adaptive Server Enterprise SDK 16.0 ; SAP Adaptive Server Enterprise all versions ; Sybase Adaptive Server Enterprise all versions ; Sybase Software Developer Kit 15.7

Keywords

"drop function", sp_jdbc_column_default, sp_jdbc_columns, sp_drv_column_default , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-SYB-SDK , SDK , Problem

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.