SAP Knowledge Base Article - Preview

2437480 - bcp out or cross-database select from view with UDF failed with error 2846 -- SAP ASE

Symptom

  • A view is created with a column based on a SQL UDF (User-Defined Functions) call.
      
  • SELECT from the view from within the same database works fine.
      
  • BCP out or a cross-database select from the view fails with error 2846:
        
    Msg 2846, Level 16, State 1:
    Server 'XXXX', Line 1:
    SQL function 'dbo.title' not found. Specify owner.objectname or use sp_help to checkwhether the object exists (sp_help may produce lots of output)


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) on ALL versions.

Product

SAP Adaptive Server Enterprise all versions

Keywords

Msg, Server Message, 2846, view, UDF, User-Defined Functions, bcp, select , 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 for Me (Login required).

Search for additional results

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