[nQSError: 17001] ORA-12899: value too large for column "SIEBEL"."S_NQ_ACCT_OBI"."QUERY_TEXT" (actual: 1026, maximum: 1024)

Dear All,

Usage tracking gives these errors in the nQServer.log file for queries that are too large:
[59048] Usage Tracking encountered an insert statement execution error. This error has occurred 1 times and resulted in the loss of 1 insert statements since this message was last logged.

[nQSError: 17001] Oracle Error code: 12899, message: ORA-12899: value too large for column "SIEBEL"."S_NQ_ACCT_OBI"."QUERY_TEXT" (actual: 1026, maximum: 1024)

OBIEE 11.1.1.7 dashboard does not open in IE10 /IE11

Dear All,

The current version of OBIEE does not support IE 11/10 version. Recently, we had to reach to Oracle for the issue and we get the below feedback.

OBIEE Developer : Experienced Professional Interview Questions

Dear All,

Oracle Business Intelligence Foundation Suite 11g provides comprehensive capabilities for business intelligence, including enterprise reporting, dashboards, ad-hoc analysis, multi-dimensional OLAP, scorecards, and predictive analytics on an integrated platform. It is also a core component of Oracle Exalytics, the industry’s first engineered in-memory analytics machine designed to deliver extreme performance.

OBIEE 11G Upgrade: List of Issues

Dear All,

OBIEE 11.1.1.7 is the latest version of OBIEE. All the applications built in OBIEE 10G version, are being planned to upgrade to the latest version of OBIEE. Upgrading of  OBIEE 10G web catalog and RPD is not a cumbersome task. We can upgrade it through UA assistant. How we can upgrade OBIEE 10G RPD and webcat, we will deal it in another blog.

In this post, we will put down the list of the issues faced in OBIEE 10G upgrade to OBIEE 11G.

OBIEE: Display the Fiscal Period Months of the Fiscal Quarter based on the Fiscal Period selected in the Prompt

Dear All,

In one of my project, I faced a task where I had to display the current fiscal months and its previous months in a fiscal quarter in the report based on the fiscal period selected.