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'.