My Oracle Support Banner

OBIEE 11g: Usage Tracking Bulk Insert Failure When Using SQL Server (Doc ID 2103304.1)

Last updated on MARCH 05, 2021

Applies to:

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


You have configured usage tracking to store the data in a SQL Server database, but the process fails.

This error is seen on the OBIS component log (nqserver.log):

[<timestamp>] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 000000SM5fs3z0LqyOFg6G00_03u0000BH,0:1:1] [tid: 1516] [nQSError: 16022] A bulkInsert statement has failed after successfully inserted 0 rows but failed in batch 1. Maximum batch size 66. Current batch size 1 [[
file: server/Query/Execution/DbGateway/Odbc35/../Odbc/Src/SQXDGOdbcBulkInsert.cpp; line: 689
Properties: description= PopulateTable BulkInsertGateway Exchange; producerID=4734978208; requestID=4294967295; sessionID=4294967295;
[nQSError: 16001] ODBC error state: S1021 code: 0 message: [DataDirect][ODBC SQL Server Wire Protocol driver]Timestamp parameters with a scale, must have a scale less than ten and a precision equal to 20 plus the scale. You specified a precision of 20 and scale of 16. Error in parameter 5..


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

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

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