JDBC Error Codes
This section describes error codes that can be returned by activities in the JDBC palette.
BW-JDBC-100000: Failed to find or create the JDBC driver : %1
-
Role: errorRole
-
Category: BW-Plugin
-
Description: Failed to find or create the JDBC driver.
-
Resolution: Check the CLASSPATH and/or JDBC driver specification.
BW-JDBC-100001: Missing SQL statement
-
Role: errorRole
-
Category: BW-Plugin
-
Description: Missing SQL statement.
-
Resolution: Specify the SQL statement.
BW-JDBC-100002: Some or all of the prepared parameters do not have data types specified
-
Role: errorRole
-
Category: BW-Plugin
-
Description: Some or all of the prepared parameters do not have data types specified.
-
Resolution: Make sure all the prepared parameters have data types specified.
BW-JDBC-100003: A JDBC driver that supports metadata access is required
-
Role: errorRole
-
Category: BW-Plugin
-
Description: A JDBC driver that supports metadata access is required.
-
Resolution: Use a JDBC driver which allows metadata access.
BW-JDBC-100004: This is not a valid SQL type: %1
-
Role: errorRole
-
Category: BW-Plugin
-
Description: Data type specified is not a valid SQL type.
-
Resolution: Specify a valid SQL data type.
BW-JDBC-100005: You must select a JDBC Connection shared configuration resource
-
Role: errorRole
-
Category: BW-Plugin
-
Description: You must select a JDBC Connection shared configuration resource.
-
Resolution: Select a JDBC Connection shared configuration resource.
BW-JDBC-100006: Cannot find shared JDBC configuration: %1
-
Role: errorRole
-
Category: BW-Plugin
-
Description: Cannot find shared JDBC configuration.
-
Resolution: Please Contact TIBCO Support.
BW-JDBC-100007: Cannot find TIbase.jar in the classpath
-
Role: errorRole
-
Category: BW-Plugin
-
Description: Cannot find TIbase.jar in the classpath.
-
Resolution: Please Contact TIBCO Support.
BW-JDBC-100008: Improper SQL statement used. %1
-
Role: errorRole
-
Category: BW-Plugin
-
Description: Improper SQL statement used. Details provided.
-
Resolution: Correct and provide proper SQL statement.
BW-JDBC-100009: Cannot load JDBC Driver: %1
-
Role: errorRole
-
Category: BW-Plugin
-
Description: Cannot load specified JDBC Driver.
-
Resolution: Please Contact TIBCO Support.
BW-JDBC-100010: Duplicate field name found '%1', please modify the query and create unique aliases for duplicate fields
-
Role: errorRole
-
Category: BW-Plugin
-
Description: Duplicate field name found, please modify the query and create unique aliases for duplicate fields.
-
Resolution: Modify the query and create unique aliases for duplicate fields.
BW-JDBC-100011: At least one parameter must have a value
-
Role: errorRole
-
Category: BW-Plugin
-
Description: At least one parameter must have a value.
-
Resolution: Set a value for any parameter.
BW-JDBC-100012: %1 is not a valid timezone. Please either choose a timezone from the list provided in the Constants tab or refer to the list of valid timezones in the documentation
-
Role: errorRole
-
Category: BW-Plugin
-
Description: Invalid timezone specified. Please either choose a timezone from the list provided in the Constants tab or refer to the list of valid timezones in the documentation.
-
Resolution: Please either choose a timezone from the list provided in the Constants tab or refer to the list of valid timezones in the documentation.
BW-JDBC-100013: JDBC plugin initialization failed: %1
-
Role: errorRole
-
Category: BW-Plugin
-
Description: JDBC plugin initialization failed. Details provided.
-
Resolution: Please Contact TIBCO Support.
BW-JDBC-100014: JDBC error reported: (SQLState = %1) - %2
-
Role: errorRole
-
Category: BW-Plugin
-
Description: JDBC error reported. Details provided.
-
Resolution: Please Contact TIBCO Support.
BW-JDBC-100015: JDBC plugin evaluation error: %1
-
Role: errorRole
-
Category: BW-Plugin
-
Description: JDBC plugin evaluation error. Details provided.
-
Resolution: Please Contact TIBCO Support.
BW-JDBC-100016: No JDBC connection available
-
Role: errorRole
-
Category: BW-Plugin
-
Description: No JDBC connection available.
-
Resolution: Please Contact TIBCO Support.
BW-JDBC-100017: Failed to create input and/or output schema(s): %1
-
Role: errorRole
-
Category: BW-Plugin
-
Description: Failed to create input and/or output schema(s). Details provided.
-
Resolution: Please Contact TIBCO Support.
BW-JDBC-100018: %1 input parameters declared in the SQL statement but no input parameters provided
-
Role: errorRole
-
Category: BW-Plugin
-
Description: Some input parameters declared in the SQL statement but no corresponding input parameters provided.
-
Resolution: Provide input parameters declared in the SQL statement.
BW-JDBC-100019: Unexpected number of input parameters. %1 declared in the SQL statement but %2 input parameters provided
-
Role: errorRole
-
Category: BW-Plugin
-
Description: Number of input parameters declared in the SQL statement does not match number of input parameters provided.
-
Resolution: Make sure the number of input parameters declared in the SQL statement match number of input parameters provided.
BW-JDBC-100020: Unexpected input parameters. No input parameter declared in the SQL statement but %1 input parameters provided
-
Role: errorRole
-
Category: BW-Plugin
-
Description: There is no input parameter declared in the SQL statement but some input parameters provided.
-
Resolution: Remove all the input parameter provided.
BW-JDBC-100021: JDBC plugin configuration error: %1
-
Role: errorRole
-
Category: BW-Plugin
-
Description: JDBC plugin configuration error. Details provided.
-
Resolution: Please Contact TIBCO Support.
BW-JDBC-100022: Global variable %1 not defined
-
Role: errorRole
-
Category: BW-Plugin
-
Description: Specified global variable not defined.
-
Resolution: Define such global variable.
BW-JDBC-100023: JDBC activity timed out
-
Role: errorRole
-
Category: BW-Plugin
-
Description: JDBC activity timed out.
-
Resolution: Please Contact TIBCO Support.
BW-JDBC-100024: Invalid procedure name specified. %1
-
Role: errorRole
-
Category: BW-Plugin
-
Description: Invalid procedure name specified. Details provided.
-
Resolution: Provide a valid stored procedure name.
BW-JDBC-100025: Unable to obfuscate password. %1
-
Role: errorRole
-
Category: BW-Plugin
-
Description: Unable to obfuscate password. Details provided.
-
Resolution: Please Contact TIBCO Support.
BW-JDBC-100026: Unable to deobfuscate password. %1
-
Role: errorRole
-
Category: BW-Plugin
-
Description: Unable to deobfuscate password. Details provided.
-
Resolution: Please Contact TIBCO Support.
BW-JDBC-100027: %1 is not a valid SQL statement. It does not generate any output schema. Please press 'Fetch' button to (re)fetch output schema or correct the SQL statement
-
Role: errorRole
-
Category: BW-Plugin
-
Description: Invalid SQL statement specified. It does not generate any output schema. Please press 'Fetch' button to (re)fetch output schema or correct the SQL statement.
-
Resolution: Please press 'Fetch' button to (re)fetch output schema or correct the SQL statement.
BW-JDBC-100028: Invalid procedure name specified. It can not be null
-
Role: errorRole
-
Category: BW-Plugin
-
Description: Invalid procedure name specified. It can not be null.
-
Resolution: Provide a valid stored procedure name.
BW-JDBC-100029: The JNDI Configuration reference [%1] not found
-
Role: errorRole
-
Category: BW-Plugin
-
Description: The JNDI Configuration reference specified not found.
-
Resolution: Provide a valid JNDI Configuration reference.
BW-JDBC-100030: The JNDI Configuration reference [%1] not found in repository
-
Role: errorRole
-
Category: BW-Plugin
-
Description: The JNDI Configuration reference specified not found in repository.
-
Resolution: Provide a valid JNDI Configuration reference.
BW-JDBC-100031: The JNDI Configuration reference [%1] contains incorrect field values
-
Role: errorRole
-
Category: BW-Plugin
-
Description: The JNDI Configuration reference specified contains incorrect field values
-
Resolution: Check and correct specified JNDI Configuration reference.
BW-JDBC-100032: Exception occurred while trying to obtain the JNDI Configuration reference [%1]: %2
-
Role: errorRole
-
Category: BW-Plugin
-
Description: Exception occurred while trying to obtain the JNDI Configuration reference. Details provided.
-
Resolution: Please Contact TIBCO Support.
BW-JDBC-100033: Configuration Test Failed. %1
-
Role: errorRole
-
Category: BW-Plugin
-
Description: Configuration Test Failed. Details provided.
-
Resolution: Please Contact TIBCO Support.
BW-JDBC-100034: Configuration Test Failed. Exception [%1] occurred.
-
Role: errorRole
-
Category: BW-Plugin
-
Description: Configuration Test Failed. Exception occurred. Details provided.
-
Resolution: Please Contact TIBCO Support.
BW-JDBC-100035: Invalid object looked up, must be either DataSource or XADataSource: %1
-
Role: errorRole
-
Category: BW-Plugin
-
Description: Invalid object looked up, must be either DataSource or XADataSource. JNDI lookup name provided.
-
Resolution: Make sure JNDI lookup name bound to either DataSource or XADataSource object.
BW-JDBC-100036: JNDI look up failed, object is null: %1
-
Role: errorRole
-
Category: BW-Plugin
-
Description: JNDI look up failed, object is null. JNDI lookup name provided.
-
Resolution: Make sure JNDI look up returns not null object.
BW-JDBC-100037: Batch updates failed on update number: %1
-
Role: errorRole
-
Category: BW-Plugin
-
Description: Batch updates failed on provided update numbers.
-
Resolution: Resolve these individual updates.
BW-JDBC-100038: Can't participlate in this transaction group. Correct JDBC Connection type or enable [Override Transaction Behavior]
-
Role: errorRole
-
Category: BW-Plugin
-
Description: Can't participlate in this transaction group. Correct JDBC Connection type or enable [Override Transaction Behavior].
-
Resolution: Correct JDBC Connection type or enable [Override Transaction Behavior].
BW-JDBC-100039: JDBC Connection Login timed out
-
Role: errorRole
-
Category: BW-Plugin
-
Description: JDBC Connection Login timed out.
-
Resolution: Increase login timeout.
BW-JDBC-100040: Invalid timeout value [%1]. The value must be an integer greater than or equal to '0'
-
Role: errorRole
-
Category: BW-Plugin
-
Description: Invalid timeout value specified. The value must be an integer greater than or equal to '0'.
-
Resolution: Set timeout to an integer greater than or equal to '0'.