My Oracle Support Banner

Unable to Insert Usage Tracking Data Into a SQL Server Database (Doc ID 2394045.1)

Last updated on NOVEMBER 23, 2021

Applies to:

Business Intelligence Suite Enterprise Edition - Version 12.2.1.2.0 and later
Information in this document applies to any platform.

Symptoms

You have setup Usage Tracking as per the instructions in the System Administrator's Guide and are using a SQL Server database to store the data.

However, no data is stored and you see this error in the obis component log (<DOMAIN_HOME>/servers/obisn/logs/obisn-diagnosticn.log):

[OBIS] [ERROR:1] [] [] [ecid: ] [sik: ssi] [tid: 1dd8] [nQSError: 16022] A bulkInsert statement has failed after successfully inserted 0 rows but failed in batch 1. Maximum batch size 14. Current batch size 1 [[
file: server\Query\Execution\DbGateway\Odbc35\..\Odbc\Src\SQXDGOdbcBulkInsert.cpp; line: 731
Properties: description= PopulateTable BulkInsertGateway Exchange; producerID=0x44890008; requestID=0xffffffff; sessionID=0xffffffff;
[nQSError: 16001] ODBC error state: S0002 code: 208 message: [DataDirect][ODBC SQL Server Wire Protocol driver][Microsoft SQL Server]Invalid object name 'S_NQ_ACCT'..
[nQSError: 16001] ODBC error state: S1000 code: 8180 message: [DataDirect][ODBC SQL Server Wire Protocol driver][Microsoft SQL Server]Statement(s) could not be prepared..
Insert statement: <statement>

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
Cause
Solution
References


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