Can't initialize BusinessConnect instance when using MySQL Database
Article ID: KB0079607
Updated On:
| Products | Versions |
|---|---|
| TIBCO BusinessConnect | 6.4.0, 7.0.0 |
Description
When connecting to a MySQL database for the first time, the user is able to connect successfully. However, when clicking on the Initialize button, the following error occurs:
When initializing a BusinessConnect instance for the first time on a MySQL database, the following error occurs: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Invalid default value for 'VALID_START'
When initializing a BusinessConnect instance for the first time on a MySQL database, the following error occurs: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Invalid default value for 'VALID_START'
Issue/Introduction
When initializing a BusinessConnect instance for the first time on a MySQL database, the following error occurs: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Invalid default value for 'VALID_START'
Environment
all platforms using MySQL database
Resolution
Some MySQL databases have strict validation of input fields which conflict with the internal SQL script that BusinessConnect uses to create its tables at initialization.
To work around the issue, go into the MySQL administrator, and look for the variable 'sql_mode'. There are two values "NO_ZERO_IN_DATE,NO_ZERO_DATE" that need to be removed from this variable. Save the revised variable, and the Initialize button will create the schema correctly without error.
To work around the issue, go into the MySQL administrator, and look for the variable 'sql_mode'. There are two values "NO_ZERO_IN_DATE,NO_ZERO_DATE" that need to be removed from this variable. Save the revised variable, and the Initialize button will create the schema correctly without error.
Feedback
Yes
No
Powered by
