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. |
Copyright © Cloud Software Group, Inc. All rights reserved.