In SQL 7.0 we exported our primary Remedy database and our busobj Repository database from Server A to Server B.
On our WEBI server and our BO clients, we changed the ODBC to point to the new server.
Webi and client users can log in fine but get the following errors:
-When trying to open a document in WEBI = “This page is empty.” -Full client users can open a document, but when they try to refresh it they get “Invalid Object dbo.fab_tracking” Note: dbo.fab_tracking is the main table used in all reports.
I tried to resolve the “Invalid Objects dbo.fab_tracking” error by pulling the table back in through Designer and rejoining it to the other tables, but when I double click the white space to pull the table back in, the table is not listed and neither are the others.
I suspect that this is a permissions problem in SQL but I’m not sure. Our DBA checked the permissions(on both databases) to Server A and Server B and he says they match.
Any help you could provide would be appreciated. Thanks!
Cynthia L. Spears, SSgt, USAF
HQ SSG/SWSX 596-3376
Cynthia.spears@gunter.af.mil
You need to look at all / test all the connections in supervisor - start with the universe and document domain connections, but also your individual universe connections… sounds like something has changed - did you do exports for the users that support the different domains?
In our scenario, I have 4 users that need to be set up for my repository and then document domains - the main users, EDWPROD, has the primary security domain. The other users each have a document domain, and when I set up my test instance of Oracle, for 5.01 testing, I had to create those users and then import their data / rights from the other instance.
Does any of this sound like it may describe your setup?
Brent
Also, do you have ODBC settings on this server that you may need, connections to other databases? Is your new TNSNAMES file correct?
In SQL 7.0 we exported our primary Remedy database and our busobj
Repository database from Server A to Server B.
On our WEBI server and our BO clients, we changed the ODBC to point to
the new server.
Webi and client users can log in fine but get the following errors:
-When trying to open a document in WEBI = “This page is empty.”
-Full client users can open a document, but when they try to refresh
it they get “Invalid Object dbo.fab_tracking” Note: dbo.fab_tracking is
the main table used in all reports.
I tried to resolve the “Invalid Objects dbo.fab_tracking” error by
pulling the table back in through Designer and rejoining it to the other
tables, but when I double click the white space to pull the table back in,
the table is not listed and neither are the others.
I suspect that this is a permissions problem in SQL but I’m not sure.
Our DBA checked the permissions(on both databases) to Server A and Server B
and he says they match.
Any help you could provide would be appreciated. Thanks!
Cynthia L. Spears, SSgt, USAF
HQ SSG/SWSX 596-3376
Cynthia.spears@gunter.af.mil