• Replies 5 replies
  • Subscribers 337 subscribers
  • Views 48 views
  • Users 0 members are here
Related

Cannot create report in Infomaker

Former Member
Former Member $organization

Ugh, this is an SOS because soon I am going to tear my hair out!

I have two separate reports I am trying to create in infomaker, I have the sql created already.

When I go into infomaker and select the stored procedure to use I receive this error:

"Cannot create Datawindow Requested result set number 1 not found; execute stored procedure @ parameters"

The only thing I can think of is I have the sql doing different select statements depending on the mode that is chosen however all of that is inserted into a temp table and the final select is from the temp table.

Thanks!

Naomi

 

Parents
  • $organization

    Hi Naomi,

    Did you copy these .pbl's from other ones?
    I think I got a similar error lately because I had just gutted another report
    and forgot to delete the arguments.

    If you think this could be the case right click the column specification window and select stored procedure and click arguments to check.

Reply
  • $organization

    Hi Naomi,

    Did you copy these .pbl's from other ones?
    I think I got a similar error lately because I had just gutted another report
    and forgot to delete the arguments.

    If you think this could be the case right click the column specification window and select stored procedure and click arguments to check.

Children
  • $organization in reply to Ryan Rowell

    Sorry, I just realized that it sounds like you are "creating" these reports not copying them.



    [edited by: Ryan Rowell at 2:04 PM (GMT -6) on 17 Nov 2009]
  • $organization in reply to Ryan Rowell

    When a datawindow is created from a stored procedure, Infomaker tries to execute the procedure with NULL values for all of the parameters.  If your procedure does not generate a result set with all NULL values passed, this error can occur.

     

    The way to get around this is to temporarily pass enough parameter values inside the stored procedure to get a result set.  This is just so the column specifications can be built.  These hardcoded elements can be removed once the datawindow has been created.

    Ryan

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Ryan Rowell
    Sent: Tuesday, November 17, 2009 3:07 PM
    To: Ryan Creps
    Subject: Re: [Tessitura Technical Forum] Cannot create report in Infomaker

     

    Hi Naomi,

    Did you copy these .pbl's from other ones?
    I think I got a similar error lately because I had just gutted another report
    and forgot to delete the arguments.

    If you think this could be the case right click the column specification window and select stored procedure and click arguments to check.

    From: Naomi Williams <bounce-naomiwilliams9587@tessituranetwork.com>
    Sent: 11/17/2009 11:24:38 AM

    Ugh, this is an SOS because soon I am going to tear my hair out!

    I have two separate reports I am trying to create in infomaker, I have the sql created already.

    When I go into infomaker and select the stored procedure to use I receive this error:

    "Cannot create Datawindow Requested result set number 1 not found; execute stored procedure @ parameters"

    The only thing I can think of is I have the sql doing different select statements depending on the mode that is chosen however all of that is inserted into a temp table and the final select is from the temp table.

    Thanks!

    Naomi

     




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

  • $organization in reply to Ryan Creps (Past Staff Member)

    Hi Naomi, another clue! If your procedure has a conditional statement which might not return a result set you will get this error. Consider the following two simple procedures – firs one will give you this error and second one won’t.

     

    This one will give you the error you mentioned, in InfoMaker

    ------------------------------------------------------------------------------------

    CREATE PROCEDURE sample_proc

          @sample_param INT

    AS

    IF @sample_param=1

                SELECT 'Hello'

     

     

    This one won’t give you any error

    ----------------------------------------------------------

    CREATE PROCEDURE sample_proc

          @sample_param INT

    AS

    IF @sample_param=1

                SELECT 'Hello'

    Else

                SELECT 'Good Bye'

     

     

     

    Hope this helps.

     

    Mo

    Business Analyst

    The National Ballet of Canada

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Ryan Creps
    Sent: Tuesday, November 17, 2009 3:17 PM
    To: Mohiuddin Faruqe
    Subject: RE: [Tessitura Technical Forum] Cannot create report in Infomaker

     

    When a datawindow is created from a stored procedure, Infomaker tries to execute the procedure with NULL values for all of the parameters.  If your procedure does not generate a result set with all NULL values passed, this error can occur.

     

    The way to get around this is to temporarily pass enough parameter values inside the stored procedure to get a result set.  This is just so the column specifications can be built.  These hardcoded elements can be removed once the datawindow has been created.

    Ryan

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Ryan Rowell
    Sent: Tuesday, November 17, 2009 3:07 PM
    To: Ryan Creps
    Subject: Re: [Tessitura Technical Forum] Cannot create report in Infomaker

     

    Hi Naomi,

    Did you copy these .pbl's from other ones?
    I think I got a similar error lately because I had just gutted another report
    and forgot to delete the arguments.

    If you think this could be the case right click the column specification window and select stored procedure and click arguments to check.

    From: Naomi Williams <bounce-naomiwilliams9587@tessituranetwork.com>
    Sent: 11/17/2009 11:24:38 AM

    Ugh, this is an SOS because soon I am going to tear my hair out!

    I have two separate reports I am trying to create in infomaker, I have the sql created already.

    When I go into infomaker and select the stored procedure to use I receive this error:

    "Cannot create Datawindow Requested result set number 1 not found; execute stored procedure @ parameters"

    The only thing I can think of is I have the sql doing different select statements depending on the mode that is chosen however all of that is inserted into a temp table and the final select is from the temp table.

    Thanks!

    Naomi

     




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!