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

[Former Member]

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

[Former Member]

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

[Former Member]

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!

[former_member198401]

Cool!! Ready to go !!!

[former_member198401]

Cool!! Ready to go !!!

[former_member198401]

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

[former_member182007]

Check out below links, Hope it helps

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

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

Best !

Deep