SAP Knowledge Base Article - Preview

1526234 - CLR stored procedures cannot be imported

Symptom

  • Error when trying to import a CLR stored procedure from SQL Server into Data Services
  • Error similar to:
    (12.2) 10-19-10 16:43:42 (E) (4400:2904) DBS-070105: Function <MYDATABASE.DBO.SOME_PROC;1> could not be imported. Possible causes: (1) The return value of the function
    is not a Data Services supported data type; (2) The function name is not specified or is not a valid database stored procedure
    or function name; (3) The function is invalid; it has either compilation or authorization errors; (4) It is not supported by
    the version of the current repository.


Read more...

Environment

  • SQL Server 2008
  • Data Services 3.2 (12.2)

Product

SAP Data Integrator XI R2 ; SAP Data Integrator XI R2 Accelerated ; SAP Data Services XI 3.0 ; SAP Data Services XI 3.1 ; SAP Data Services XI 3.2

Keywords

BODS, BODI, DS, DI , KBA , EIM-DI , Data Integrator, Composer , EIM-DS , Data Services , Product Enhancement

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.