Forum Stats

  • 3,854,767 Users
  • 2,264,418 Discussions
  • 7,905,778 Comments

Discussions

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

2672598
2672598 Member Posts: 1

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

Tagged:
This discussion has been closed.