My Oracle Support Banner

OBIEE 12c/ OAS ( Oracle Analytics Server )- Init Blocks logging issue: Records not inserting into S_NQ_INITBLOCK table. (Doc ID 2684642.1)

Last updated on JUNE 25, 2020

Applies to:

Oracle Analytics Server - Version 5.5.0 and later
Information in this document applies to any platform.

Symptoms

Problem Summary
---------------------------------------------------
OAS - Init Blocks logging issues

Problem Description
---------------------------------------------------
Installed OAS 5.5.0 and enabled Usage Tracking. Records were getting inserted into S_NQ_ACCT and S_NQ_DB_ACCT tables.

As part of configuration, enabled init block logging by adding below statements in NQSConfig.INI file.

INIT_BLOCK_TABLE_NAME
INIT_BLOCK_CONNECTION_POOL

But, records were not inserting into S_NQ_INITBLOCK table. 

Steps were followed as per OAS guide link:-

 

https://docs.oracle.com/en/middleware/bi/analytics-server/administer-oas/track-usage-1.html

 

Changes

 Configured USAGE TRACKING

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.