Infomaker and Stored Procedure - not playing together

Couple of things to note here:

1.       Make sure that you are using datawindows in an Infomaker library (library.PBL) and not individual PSR files for each report datawindow.  The use of PSR files is to be considered deprecated and is no longer supported.

2.       Make sure that you don’t have a duplicate datawindow with the same name in another library referenced by the application.  If you have a datawindow with the same name in another library, the application may be trying to reference this one first.  Check the LOCAL_LIBRARY_LIST entry in T_DEFAULTS to see what PBL files are used by the application.

-Ryan

I've got a pretty simple stored procedure, and created a new infomaker tabular report with it. In infomaker, it runs in preview mode, but when I try to run it in Tessitura, I get no results.

I've double checked the permissions on the sp - ImpUsers and tessitura_app have execute rights. In fact, the same sp is used in a different report with no issues. When I did a trace in Profiler, I can see it selecting the right psr:

Select ISNULL ( psr_file , '' ) From gooesoft_report Where id ='d_groups_merge'

, and when I run that bit in management studio, it returns the name correct name for the psr, but I never see the sp executed.

So, I'm at a loss. Does this ring any bells with the infomaker experts in the crowd here? Any ideas would be greatly appreciated.

thanks

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!