No response from server testing connection

Eulderma · Post by **Eulderma** » Wed Feb 28, 2007 10:07 am

When choosing to check the connection of an ODBC via the button √ in the connection manager view the job starts in ProfileStage but there is no response from the server. Even after more than 4 hours waiting nothing has happened. Has anyone experienced issues related to the response from a server when trying to verify whether or not a connection works.

ray.wurlod · Post by **ray.wurlod** » Wed Feb 28, 2007 2:47 pm

Can you connect using any other ODBC client, such as MS Query?

lstsaur · Post by **lstsaur** » Wed Feb 28, 2007 4:16 pm

Check your TestConnection_xxx.err file in the Analysis Server's LogFile folder. You will see detailed information such as the following regarding why the connection failed:
Unable to continue.
Unable to connect to database using DSN/service 'ODBC FOR DB2'. Review connection information and correct if needed. Connection error: CoreOdbc::_ExecOpenDbSql_ODBC: Error in opening database connection to 'ODBC FOR DB2'.

Who can afford waiting for 4 hours to see....?

ray.wurlod · Post by **ray.wurlod** » Wed Feb 28, 2007 5:41 pm

...anyone being paid by the hour!

Eulderma · Post by **Eulderma** » Thu Mar 01, 2007 6:05 am

Thank you for the respons.

With regard to the solution. I searched for the mentioned TestConnection_xxx.err file. But what I see in the relevant folder are only ini-files. There are no log files as from start this week. Before this week I had no problems whatsoever. So it appears that no log-files are being made. Maybe an underlying issue?

Concerning waiting. The process sits for 4 hours in the background because I'm not paid by the hour

. So while processing I have other work to do.

lstsaur · Post by **lstsaur** » Thu Mar 01, 2007 12:30 pm

You should have other files such as .log, .err for the ColumnAnalysis, GenOdbc2Mxf, PKeyAnalysis, SelectTables, TestConnection, etc.

Please check your MGXPgmInit.log file and search word "PISERVER" to confirm that MGXPgmInit daemon and Message Switch are still connected with each other. This file gives you the detailed information regarding the results of every step of your ProfileStage jobs.

Eulderma · Post by **Eulderma** » Fri Mar 02, 2007 2:22 am

Hi Istsaur,

Thanks very much for your help, this resolved our problem. I saw in the MGXPgmInit.log file that there were no more activities with jobs. So I stopped and started both related message switch services. After this the first job 'select tables' worked fine again.

Again thanks

ray.wurlod · Post by **ray.wurlod** » Fri Mar 02, 2007 4:49 am

I should have thought of that. One of the very first things you do in ProfileStage diagnosis is to check the logs, particularly for message switch activity.

Please mark the thread as resolved.