Hello folks,
Messing around with InfoMaker for the first time, and upon connecting to our test database, InfoMaker reports "Catalog tables could not be created and are not available for use."
I can move forward from there, but the report I'm working on (subscription renewal notice) doesn't generate a preview. Not sure if that's specific to the DataWindow or if it has to do with the catalog table issue.
Can someone enlighten me?
Hi Nick
When an Infomaker client first logs in to a new db, it tries to create a set of ‘Catalog tables’ under the user’s name, which it then uses to speed things up ( I presume).
But the user has to have the right to do that sort of thing, which ordinary users don’t tend to have, and of course you don’t want your db cluttered up with lots of random catalog tables anyway.
So you can share one set of catalog tables by adding a different user as the catalog table owner into any db profile that you’re using.
Fairly standard to just use dbo, I think, like this:
Ken
________________________________ Ken McSwain
Systems and Technology Manager
Australian Chamber Orchestra
Email: ken.mcswain@aco.com.au
Ph: +61 (0)2 8274 3833
Mob: +61 (0)418 659 360
Fax: +61 (0)2 8274 3801
Opera Quays, 2 East Circular Quay, Sydney NSW 2000
Website | Facebook | Twitter | YouTube
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Nick Reilingh Sent: Sunday, 11 May 2014 12:15 To: Ken McSwain Subject: Re: [Tessitura Technical Forum] InfoMaker "Catalog tables" not available
Hm, I guess it was the user I was connecting with, in part. I changed the login to a sysadmin, and I presume either the tables were now accessible or they were created. Is this the appropriate thing to do on the live database?
Still not getting any preview, but I'm guessing I have to define some parameters somewhere...
From: Nick Reilingh <bounce-nicholasreilingh4883@tessituranetwork.com> Sent: 5/10/2014 9:00:56 PM
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!
Jumping in to an old thread, is there a way to query Infomaker's catalog of report definitions in the database? I found a query for doing this in generic Infomaker, but the query doesn't work for me (searches ReportServer.dbo.Catalog).
Hi Gawain
I don't think those catalog tables hold anything to do with reports - just data about the db for Infomaker to use.
If you're trying to document existing reports and their relationships with each other and the db sources, there is a tool called PBDOC which you can run against pbl files, which will produce a set of documentation tables and a html interface to them.
It's not entirely intuitive, and it's really intended for documenting Powerbuilder apps, and of course it's a bit flaky, like most things to do with Infomaker. But it's really useful if you're trying to hunt through IM report definitions to solve puzzles, without having to open them one by one.