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

Stored Procedure Universe in B.O 3.1

Hi,

I am working on creating a universe based on a stored procedure. There are around 245 IN parameters in the stored procedure. I have created the universe. When I run a Web Intelligence report on this universe, it keeps running forever and eventually throws an error "Invalid cursor state". I would like to know if there is any limit in BOBJ in terms of number of IN parameters in stored procedur.

It would be great if somebody helps me to resolve this issue. Would greatly appreciate your help.

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jul 16, 2012 at 09:04 AM

    Hello,

    From the latest update we have, (OSS logged with us) our NEXUS engineer has already got in touch with the project manager and has explained him that this is not a best practise and correct approach ( 245 IN parameters ) when using stored procedure Universe. Also there will be a follow up in next couples of weeks ( or days ) from the NEXUS engineer, who will be in touch with the project manager again to help him with a better approach and complete redesign of the universe.

    Regards

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 15, 2012 at 07:35 PM

    Hi Nithya,

    Please find the best practices SAP Note for creating stored procedures in the below link:

    https://bosap-support.wdf.sap.corp/sap(bD1lbiZjPTAwMQ==)/bc/bsp/sno/ui_entry/entry.htm?param=69765F6D6F64653D3030312669765F7361706E6F7465735F6E756D6265723D3135323435313626

    Also please let me know the following details:

    1.Business Objects Version:

    2.Database Server:

    3.Middleware Used:

    In case, if you are connecting to SQL Server, I would request you to test the issue by both ODBC and OLEDB drivers.

    Also, let me know if there are any temp tables being used in stored procedures.

    Although IN parameters are supported with business objects for stored procedures, I am not sure if 245 IN parameters will cause an issue.

    Please let me know if the above information helps you.

    Thank you

    Hyder

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 15, 2012 at 07:37 PM

    Hello Nityagowri,

    There is no limit for the number of input parameters, but not sure that it can handle those many parameters

    What is your database.
    Are you getting the issue with a simple stored procedure(With one or two input parameters.

    Please try the below step and test the issue.

    1. Open the odbc.sbo file located in the following path:
    <install dir>\ Business ObjectsXIR3\Business Objects Enterprise12.0\win32_x86\dataAccess\connectionServer\odbc
    2. Add the following parameter in MS SQL Server 2000 and MS SQL 2005 section(or your specific database section):
    <Parameter Name="Force Execute">Procedures</Parameter>
    3. Save the odbc.sbo file.

    Now test the issue.

    Hope this will helps you.

    Thanks,
    Pramod.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 13, 2012 at 11:44 AM

    Hi,

    If i'm not mistaken, you or a colleague submitted a ticket to Primary Support about this already?

    Please confirm the OSS number if applicable.


    Regards,

    henry

    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.