Skip to Content
author's profile photo Former Member
Former Member

Can't Import SAP IQ Stored Procedures - (BODI-1112335)

Has anyone working with SAP IQ ever tried importing a stored procedure into data services designer?


SQL Server SPs seem to import fine. But I'm having no luck with SAP IQ.


I'm getting BODI-1112335. Stored Procedure or function <Stored procedure name > was not found in the source DataStore.

The SP works fine when called from Interactive SQL.


Sap Data Services Designer - 14.2.4.668

Sap Data Services Repository- 14.2.4.0000

Sap IQ 16.0.0.807-sp08.01



Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Posted on Mar 18, 2015 at 06:24 AM

    Check out below links, Hope it helps

    http://scn.sap.com/thread/3370867

    http://scn.sap.com/docs/DOC-53584

    Best !

    Deep

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Mar 18, 2015 at 02:37 PM

    Hi Edgae,

    You need to Import the Sybase IQ Stored Procedure Name using the below format

    While using Import By Name use the name of the stored procedure and the group number, such as StoredProc;2

    Hope this helps!!!

    Regards

    Arun Sasi

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 20, 2015 at 12:41 AM

    Hi,

    The only way that allowed me to import stored procedures is that their names were in uppercase, because when their names are in lowercase not find them.

    Thanks for your help!

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 16, 2015 at 09:41 PM

    This error occurs usually when the BODS account(User_ID) that is used to run the jobs has no access to the objects in the data base.

    make sure the user_id has at least read access to the Stored procedures.

    Having access to the tables doesn't guarantee he access to SPs. The access can be restricted at different levels based on the object types.

    Thanks,
    Sarath

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.