JDBC Palette Error Codes

This section describes the error messages that can be reported by the activities or entities associated with the JDBC palette.

Error Codes Error Message Error Resolution
TIBCO-BW-PALETTE-JDBC-000001 The JDBC activity [{0}] is NOT part of a JDBC Transaction Group. However the activity references the same shared resource as used in the group This is an internal product error. Contact TIBCO Support.
TIBCO-BW-PALETTE-JDBC-200001 The JDBC activity [{0}] is first activity in the JDBC Transaction. This is a debug message and resolution is not applicable.
TIBCO-BW-PALETTE-JDBC-200002 JDBC activity [{0}] initialized successfully. This is a debug message and resolution is not applicable.
TIBCO-BW-PALETTE-JDBC-200003 JDBC activity [{0}] task submitted to Threadpool for execution This is a debug message and resolution is not applicable.
TIBCO-BW-PALETTE-JDBC-200004 Executing SQL Statement [{0}] for activity [{1}]. This is a debug message and resolution is not applicable.
TIBCO-BW-PALETTE-JDBC-200005 Connection received from Datasource for activity [{0}]. This is a debug message and resolution is not applicable.
TIBCO-BW-PALETTE-JDBC-200006 Parameters set for activity [{0}] with sql statement [{1}]. This is a debug message and resolution is not applicable.
TIBCO-BW-PALETTE-JDBC-200007 Output for activity [{0}] is [{1}]. This is a debug message and resolution is not applicable.
TIBCO-BW-PALETTE-JDBC-200008 Executing SQL Statement for activity [{0}]. This is a debug message and resolution is not applicable.
TIBCO-BW-PALETTE-JDBC-200009 Executing Prepared Statement for activity [{0}].
TIBCO-BW-PALETTE-JDBC-200010 Successfully executed sql statement [{0}] for activity [{1}]. This is a debug message and resolution is not applicable.
TIBCO-BW-PALETTE-JDBC-200011 Last subset reached for activity [{0}]. This is a debug message and resolution is not applicable.
TIBCO-BW-PALETTE-JDBC-200012 Process in subset output for activity [{0}] with noofRecords [{1}] is [{2}]. This is a debug message and resolution is not applicable.
TIBCO-BW-PALETTE-JDBC-200013 All Parameters set successfully on Statement for activity [{0}]. This is a debug message and resolution is not applicable.
TIBCO-BW-PALETTE-JDBC-200014 Number of updates for JDBC Update activity is [{0}]. This is a debug message and resolution is not applicable.
TIBCO-BW-PALETTE-JDBC-200015 Number of updates for JDBC Update activity is 0. Executing Insert Statement [{0}] since activity is in Upsert mode. This is a debug message and resolution is not applicable.
TIBCO-BW-PALETTE-JDBC-500001 Batch updates failed on update number [{0}]. Check the activity configuration and if the database is up.
TIBCO-BW-PALETTE-JDBC-500002 Invalid procedure name specified. Procedure name can not be null. Check the activity configuration Procedure name field.
TIBCO-BW-PALETTE-JDBC-500003 {0} input parameters declared in the SQL statement but no input parameters provided. Check the activity configuration Prepared Parameters table.
TIBCO-BW-PALETTE-JDBC-500004 Duplicate field name [{0}] found. Modify the query and create unique aliases for duplicate fields. Modify the query and create unique aliases for duplicate fields.
TIBCO-BW-PALETTE-JDBC-500005 Improper SQL statement used. {0} Check the syntax of the SQL Statement specified.
TIBCO-BW-PALETTE-JDBC-500006 Exception occurred occurred when attempting to create a JDBC Connection for JDBC Transaction. Check the Shared Resource configuration this activity is configure with and also that the database is running.
TIBCO-BW-PALETTE-JDBC-500007 Missing Input Value for required Column [{0}]. Check the input tab of the activity and set the column value
TIBCO-BW-PALETTE-JDBC-500009 SQL Exception occurred (SQL STATE = {0}) - detailMessage - {1} Check the activity configuration and the state of the database the activity is connected to.
TIBCO-BW-PALETTE-JDBC-500010 {0} is not a valid timezone. Check the activity configuration input tab and enter a valid timezone
TIBCO-BW-PALETTE-JDBC-500011 Could not create Connection to server using Shared Resource [{0}]. Check the JDBC Connection Shared Resource configuration which is configured on the activity.
TIBCO-BW-PALETTE-JDBC-500012 INVALID_JDBC_ACTIVITY_CONFIGURATION = Invalid Activity Configuration. Missing required configuration Field [{0}] in activity [{1}] Check the activity configuration and enter values for missing fields specified in the message.
TIBCO-BW-PALETTE-JDBC-500013 INVALID_SQL_STATEMENT = Invalid Activity Configuration. Invalid SQL Statement [{0}] in activity [{1}] expected a statement with [{2}] Check the activity configuration for the SQL statement syntax.
TIBCO-BW-PALETTE-JDBC-500014 PREPARED_PARAMETERS_MORE_THAN_QUESTION_MARKS = Invalid Activity Configuration. Number of Prepared Parameters in activity configuration exceed number of '?' in SQL Statement Check the activity configuration for the Prepared Parameters specified.
TIBCO-BW-PALETTE-JDBC-500015 PREPARED_PARAMETERS_LESS_THAN_QUESTION_MARKS = Invalid Activity Configuration. Number of Prepared Parameters in activity configuration is less than number of '?' in SQL Statement Check the activity configuration for the Prepared Parameters specified.
TIBCO-BW-PALETTE-JDBC-500016 BATCH_UPDATE_WITHOUT_PREPARED_PARAMS = Batch Update mode works only with Prepared Statements Check the SQL statement in the activity configuration to ensure that it is a SQL statement with prepared parameters.
TIBCO-BW-PALETTE-JDBC-500019 JDBC Connection login timed out. Check the configuration details or increase the login timeout.