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

 

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.

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

 

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.

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

 

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

 

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.

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!