TIBCO ActiveMatrix Adapter for Database fails to start with the DSN error: "2 contains an invalid bit for the BulkLoadOptions bitmask. Valid values are any combination of the following: 128".
Article ID: KB0093209
Updated On:
| Products | Versions |
|---|---|
| TIBCO ActiveMatrix BusinessWorks Plug-in for Database | - |
| Not Applicable | - |
Description
Description:
TIBCO ActiveMatrix Adapter for Database instance fails to start up with the following error:
***********************************************************************************
<Timestamp> <ADB_Instance> Error [Database] AEADB-910007
Startup Error. Unable to create a connection with the target database using the dsn <DSN>. The database error is:
DBError: 5
ErrorCode: HY000
ServerCode: 0
Message: [Data Direct][ODBC Oracle Wire Protocol driver]2 contains an invalid bit for the BulkLoadOptions bitmask. Valid values are any combination of the following: 128.
***********************************************************************************
Resolution
This is caused by invalid characters in the odbc.ini file. From the error message, we can narrow down the problem to the parameter 'BulkLoadOptions'. We have introduced the detailed usage of the parameter 'BulkLoadOptions' from the ODBC document under <ADB_HOME>/odbc/help/help.htm -> 8 The Oracle Wire Protocol Driver : Connection Option Descriptions.
To solve this problem, remove the parameter 'BulkLoadOptions' from the section of <DSN> in the odbc.ini file. If it is required to customize this parameter, the valid value is 0 or 128.
Issue/Introduction
TIBCO ActiveMatrix Adapter for Database fails to start with the DSN error: "2 contains an invalid bit for the BulkLoadOptions bitmask. Valid values are any combination of the following: 128".
Feedback
Yes
No
Powered by
