I came across an interesting problem today when importing an Oracle OLAP cube using the Administration Tool that comes with the OBIEE 11g Client Tools. The import failed with the error message: [nQSError: 77005] An invalid parameter was passed to the nQWebIBotAPI.dll. Verify that the Agent configuration is correct. When you install the client tools [...]
While applying a one-off patch to an OBIEE environment via OPatch it failed with this message: The response file for OCM configuration does not exist (or) is not readable. Please provide a valid response file. In this environment we were not using OCM so it hadn’t been configured. It seems OPatch will create a new [...]
I’ve blogged in the past about the annoying Transactional update failed message that is seen when editing the OBIEE 11.x repository in online mode. Well it seems Oracle have finally released a patch to fix this – #9884975. It can be downloaded once you’ve obtained the necessary password via a Service Request.
Ever wondered what happens when you try and open an OBIEE 18.104.22.168 repository in online mode from the 22.214.171.124 Administration Tool? Well you might get this lovely error message: [nQSError: 46036] Internal Assertion: Condition m_pFile->Read(&*bytes.begin() + sizeof(int32)), numChars * sizeof(uint16)) == numChars * sizeof(uint16), file server\objectmodel\Src\SORpArchivePersistStream.cpp, line 456. Needless to say the 2 versions aren’t [...]
I came across an interesting error recently. I had a very simple data model with 1 fact table and 1 dimension, both coming from a SQL Server 2008 database. When querying the model through Answers I would get ODBC driver errors like the ones below. State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A [...]
Does this error sound familiar? [nQSError: 15019] Table <Logical table name> is functionally dependent upon level <Logical level>, but a more detailed child level has associated columns from that same table or a more detailed table. The problem is most often encountered when you have multiple logical table sources, each with a different grain and a single [...]
Following on from my earlier post on this topic, I’d like to point out that Oracle have released patch 10125516 to fix this bug in 126.96.36.199 on Windows. You can download it from the Support website under ‘Patches & Updates’.
If you often edit an OBIEE repository in online mode then chances are you will have come across this error at some point. As far as I understand it, this refers to any number of problems relating to checking-in objects that are currently checked out. It seems the Administration Tool thinks it is unable to [...]
I came across a strange problem today when trying to use the Ago time series function. I made a simple formula to show the change in a measure between current month and last month. Easy you would think: Folder.Measure – Ago(Folder.Measure, DateFolder.Month, 1) However, this resulted in: [nQSError: 59012] UnderFlow occurred during the execution of [...]
There seems to be a number of causes for this error but in my experience it is most often encountered in a federated data model bringing data from different fact tables – joined by conformed dimensions – in which you have multiple sources for logical tables in the Business Model and Mapping layer. If you [...]keep looking »