Bulk Insert Failure by OBIEE 11g Usage Tracking (Doc ID 2103304.1)

Last updated on AUGUST 14, 2017

Applies to:

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

Symptoms

OBIEE 11g getting error during Bulk insert task:

[2016-01-20T15:48:39.242-05:00] [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..

Cause

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