Hi,
I am facing an ODBC error in the Dashboard reports in OBIEE 11g (Oracle Business Intelligence 11.1.1.7.131017)
intermittently.
On clicking Refresh the report works fine giving the required results.
On verifying NQServer log , find the below error:
[nQSError: 16001] ODBC error state: S1000 code: 0 message: [TimesTen][TimesTen 11.2.2.5.0 ODBC Driver]General error.
]]
[2014-05-13T15:23:00.000+10:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 738ce33a088c5fba:-72a43293:145e5eb970d:-8000-000000000004b2f0,0:1:127:5:1] [tid: 4930b940] [nQSError: 16002] Cannot obtain number of columns for the query result. [[
[nQSError: 16001] ODBC error state: S1000 code: 0 message: [TimesTen][TimesTen 11.2.2.5.0 ODBC Driver]General error.
]]
Please advise what might be causing this error and the solution to this issue.
Thanks,
Timothy