Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

About Transactional Update Failed [nQSError:37005]

ac5d3180-4b7e-4b2f-b001-cd05d6144a17Sep 17 2014 — edited Sep 17 2014

I have kept getting this annoying error recently when I open an online repository and tried to save any update. I've tried a lot of ways to get rid of it. And finally I successfully got rid of it. Here I post my way for your reference.

I found when ever I got the error 37005, there will be an error logged in the file nqserver.log, find this log file in your server:

/u01/obi/instances/instance1/diagnostics/logs/OracleBIServerComponent/coreapplication_obis1 /nqserver.log

[2014-09-15T12:58:18.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 0050lDvj3KMCslSMyEmZMG00005^000KGA] [tid: bd919700] [nQSError: 28021] Near Line 276, <POPULATE_STATEMENT_INSERT_HINT>: is an invalid feature.

Indicate, that the feature <POPULATE_STATEMENT_INSERT_HINT>: is an invalid feature.

I found for a physical DB I have created, there is a feature that has this name:

clipboard.png

I was using BI server 11.1.6 and administrator 11.1.7

Then I decided to down grade my administrator to 11.1.6, I found there is no <POPULATE_STATEMENT_INSERT_HINT> feature in this version:

clipboard.png

Now I can freely to update and save my online repository without any error, and in the log file, the error's gone.

So in my case, to down grade administrator to 11.1.6 solved this problem. And the clue is to check the log nqserver.log each time you got this error to find exact error in the server side.

have fun and good luck.

Jerry

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details