• Replies 4 replies
  • Subscribers 338 subscribers
  • Views 106 views
  • Users 0 members are here
Related

Infomaker problem

David Preschel
$organization

Hi,

I have a custom report that I need to add a new field to the report.  I've added a new column stored procedure and all works well inside sql server mgmt studio.  But I'm having a problem in Infomaker.  I am able to connect to the database from inside Infomaker,  but not getting anything in the new field when running the report.  It appears that Infomaker is not seeing the new column from the stored procedure.

If I run/preview the report in info maker,  I get the following error message: 

"Select Error: SQLSTATE=42000
Microsoft OLEDB Provider for SQL Server
Could not find stored procedure
'dbo.LP_YALE_PERFORMACE_CUMULATIVE_SALES_2'

The Stored procedure does exist and is working. One thing I noticed is when browsing the database from within Infomaker,  I don't see any of the stored procedures,  only system stored procedures. Is there a permissions setting in sql server that will allow Infomaker to see the procedures?  Any ideas?

 

Thanks,

Dave

  • $organization

    Hey Dave,

    Infomaker is a little odd about updates to procedures, there are two things you're probably going to want to do. One is check under your Database Painter that your SQL connection has extended properties of database=impresario

    And then on the actual report, you'll need to go to the column specification and manually append a new row for the column you added:

    Hope that helps!

  • Former Member
    Former Member $organization

    If Paul's excellent suggestions don't help, make sure that the user account being used in Infomaker for the database connection is mapped as a member of ImpUsers. If it is not, all you will see are system stored procedures.

    Hope this helps!

  • $organization in reply to Former Member

    Paul & Steven,

    Thanks!  I think I'm almost there!   Adding 'database=impresario' to the extended properties allowed me to see the procedures and tables within Infomaker,   and I'm able to run the procedure and get results (and correct results at that,  the procedure is returning what I expect it to).   

    I may also have an issue with the data types between sql server and info maker,  or somehow not mapping the fields correctly (I've appended a new row to the column specification).  The column I added to the report is a decimal,  and i have the result in sql server cast to decimal.  But,  I am getting an odd random number on the report.  I  tried changing the data types to strings and get the same odd value.

    Thanks, 

    Dave

  • Former Member
    Former Member $organization

    Do you have the order of your fields exactly the same in both the SQL procedure and the Infomaker column listing?  For example, if you added the new field in the stored procedure as the second to last field, but then added the new column in Infomaker as the last column, instead of second to last, it could display incorrect data.  Just a thought…

     

     

    Penny Tabor

    IT Manager

    Midland Center for the Arts

    Midland, MI 48640    

                                         Comptia                                              

     

     

     

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of David Preschel
    Sent: Monday, July 28, 2014 6:46 PM
    To: Tabor, Penny
    Subject: Re: [Tessitura Technical Forum] Infomaker problem

     

    Paul & Steven,

    Thanks!  I think I'm almost there!   Adding 'database=impresario' to the extended properties allowed me to see the procedures and tables within Infomaker,   and I'm able to run the procedure and get results (and correct results at that,  the procedure is returning what I expect it to).   

    I may also have an issue with the data types between sql server and info maker,  or somehow not mapping the fields correctly (I've appended a new row to the column specification).  The column I added to the report is a decimal,  and i have the result in sql server cast to decimal.  But,  I am getting an odd random number on the report.  I  tried changing the data types to strings and get the same odd value.

    Thanks, 

    Dave

    From: Steven Bras <bounce-stevenbras7585@tessituranetwork.com>
    Sent: 7/28/2014 4:52:12 PM

    If Paul's excellent suggestions don't help, make sure that the user account being used in Infomaker for the database connection is mapped as a member of ImpUsers. If it is not, all you will see are system stored procedures.

    Hope this helps!




    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!