Error 126 on Insight : QE-DEF-0285
Hi guys. We are dealing with an urgent issue here, may be someone can help us.
We have Insight v1.0.0.2 version installed. Everything was working ok, but ever since we restarted the Insight WAS instance we are getting a logon error message QE-DEF-0285:
http://img375.imageshack.us/img375/5504/errormsginsight1.th.jpg
We have restarted again the WAS and we have also restarted the systemOS (windows server 2003 sp2 enterprise edition).
We also have checked the Insight registry values, and they seem ok.
An important detail: on Framework Manager, we are able to test a datasource and tables, and it pulls data ok (Test Sample feature).
So can I assume that ODBCs are ok? Running a report on Insight requires JDBC, right? Any ideas on that?
On Congnos Configutarion section, when we test the datasource connection we get an error (failed). We get that error using both localhost and hostname accessing from outside.
We had a WAS Admin guy checked the WAS and he found everything ok, so we are actually running out of options here.
This is an error we get running any report, not just a specific one.
Any ideas? We are running out of options here, and I would like to classify the issue, whether is an Insight issue or WAS issue.
Thanks in advance!
We have Insight v1.0.0.2 version installed. Everything was working ok, but ever since we restarted the Insight WAS instance we are getting a logon error message QE-DEF-0285:
We have restarted again the WAS and we have also restarted the systemOS (windows server 2003 sp2 enterprise edition).
We also have checked the Insight registry values, and they seem ok.
An important detail: on Framework Manager, we are able to test a datasource and tables, and it pulls data ok (Test Sample feature).
So can I assume that ODBCs are ok? Running a report on Insight requires JDBC, right? Any ideas on that?
On Congnos Configutarion section, when we test the datasource connection we get an error (failed). We get that error using both localhost and hostname accessing from outside.
We had a WAS Admin guy checked the WAS and he found everything ok, so we are actually running out of options here.
This is an error we get running any report, not just a specific one.
Any ideas? We are running out of options here, and I would like to classify the issue, whether is an Insight issue or WAS issue.
Thanks in advance!
3 answers
I have seen such error before, definitely it is caused by incorrect environment settings. For Insight 1.0.0.2, I got some bug reports about this error, most of them are caused by try to deploy Insight on a 64-bit OS, if that the case, there is nothing to do, I would suggest customer re-deploy Insight on a 32-bit OS.
If they encountered this issue on a 32-bit OS, I would like to ask you check the following settings.
1. JVM
Please make sure Insight JVM is on top of the other settings, C:\Program Files\IBM\Rational Insight\jdk\jre\bin\classic.
2. Check ODBC
Please make sure you have the following key, and Driver and LibPath has correct settings.
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\IBM Rational XML ODBC Driver
BTW, another way to reproduce it, just open ODBC DSN in ODBC DS Administrator, double click a DSN of Insight, you will see the '126' error if you have incorrect configuration.
If they encountered this issue on a 32-bit OS, I would like to ask you check the following settings.
1. JVM
Please make sure Insight JVM is on top of the other settings, C:\Program Files\IBM\Rational Insight\jdk\jre\bin\classic.
2. Check ODBC
Please make sure you have the following key, and Driver and LibPath has correct settings.
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\IBM Rational XML ODBC Driver
BTW, another way to reproduce it, just open ODBC DSN in ODBC DS Administrator, double click a DSN of Insight, you will see the '126' error if you have incorrect configuration.
And, your problem looks like your WAS instance could not load ODBC driver, can you paste all items under your WAS instance of the following node.
Application servers > RationalReportServer > Process definition > Environment Entries
Hi Jiang. Below you will find a screenshot of what you are asking for:
Thanks a lot for your help!