Error while running report in Profile Stage

shaonli · Post by **shaonli** » Fri Dec 14, 2007 6:20 am

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

ray.wurlod · Post by **ray.wurlod** » Fri Dec 14, 2007 11:37 pm

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?

shaonli · Post by **shaonli** » Mon Dec 17, 2007 2:43 am

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