IBM Support

Reporter Server connection to Oracle fails on Linux

Technote (FAQ)


Why does the Reporter Server give the error:

"GRSqlWkr 0 failed to login to ODBC_MSSQL as repository_two"

when connecting to Oracle on Linux?


Check that you have correctly configured the odbc.ini file as per the existing Reporter 2.2 Admin Guide, and that the $ODBCINI variable points to it - i.e.

Next, ensure the $INFOHOME/server/dbtype file reads 'ODBC_MSSQL' (pre FP7) or 'ODBC' (post FP7) - eg

[root@monkey server]# cat $INFOHOME/server/dbtype


[root@monkey server]# cat $INFOHOME/server/dbtype

then stop and restart the Reporter processes.

*Please note that 'ODBC_MSSQL' is the expected value if you are running a version previous to v2.2.0.7. After applying the FP0007 patch for Reporter v2.2, the value becomes 'ODBC'. Both values work well, however.*

Document information

More support for: Tivoli Netcool/Reporter

Software version: 2.2

Operating system(s): Linux

Software edition: All Editions

Reference #: 1328850

Modified date: 10 July 2017

Translate this page: