OBIEE 11g: Usage Tracking Bulk Insert Failure When Using SQL Server
Last updated on APRIL 06, 2018
Applies to:Business Intelligence Suite Enterprise Edition - Version 126.96.36.199.0 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..
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 hundreds of Community platforms