Skip to Main Content

OBIEE 11g Dashboard report throws ODBC error intermittently but works fine on clicking Refresh

2672598May 14 2014

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

Comments
Post Details
Added on May 14 2014
0 comments
725 views