Last updated on AUGUST 14, 2017
Applies to:Business Intelligence Suite Enterprise Edition - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
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..
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