Page 1 of 1
Error while running report in Profile Stage
Posted: Fri Dec 14, 2007 6:20 am
by shaonli
Hi,
I am very new to profile stage.While running report in profile stage after running job for column analysys I am getting the following error "Error Printing report 20599-Can't open SQL server".
Please help.
Thanks
Shaonli
Posted: Fri Dec 14, 2007 11:37 pm
by ray.wurlod
Tell us more about your configuration. In particular, what are you using for your ProfileStage DataBase (PSDB)? How is the ODBC connection to the PSDB configured?
Posted: Mon Dec 17, 2007 2:43 am
by shaonli
ProfileStage DataBase (PSDB) Repository is in Oracle.
To connect this repository from analysis server we have created a DSN through Oracle IBM wire protocol.We also have one DSN to connect to source database(File database present in Unix server) from analysis server.
But we don't have any DSN to connect to source Database from client m/c which is prerequisite before installing Analysis server.
In addition to this in our PSDB there is no temporary tablespace called TEMP which is prerequisite before installing Analysis server.
When we are running query in views of PSDB it is showing an error that there is no connection between SQL client and server.
Is these creating problem while running report?
Please suggest.
Thanks
Shaonli