Troubleshooting Common Problems

Solve common problems when installing and using VMware vFabric SQLFire.

Licensing Problems

If you install an invalid serial number or if SQLFire cannot obtain a dynamic license from the vFabric License Server, SQLFire fails to start and throws an exception. In this case, depending on your licensing configuration, you may need to perform one of the following fixes:
  • Replace the invalid serial number or serial numbers specified either in sqlfire.properties or in serial number files with valid (non-expired) serial licenses, and restart the server.
  • Remove the invalid serial number or serial numbers from sqlfire.properties and restart the server. When the server restarts, it will use the default evaluation license.
  • Remove the keyword "dynamic" from sqlfire.properties and restart the server. When the server restarts, it will use the default evaluation license.
  • Increase the amount of time specified in license-server-timeout. This option is only applicable if you are running SQLFire on a vSphere virtual machine and using the vFabric License Server to acquire licenses dynamically.
  • Configure the license locally in sqlfire.properties. Keep in mind that the vFabric License Server cannot provide a standalone license for SQLFire Professional or SQLFire Enterprise. You can only use a license server configuration if you are running SQLFire on a vSphere virtual machine as part of vFabric Suite.

Connection Problems

These are common problems that occur when connecting to a SQLFire distributed system:
  • You receive SQL State 08001 Error: 'Failed after trying all available servers: []'

    This problem can be caused if you specify null values for the username and password connection properties in the JDBC connection URL. Some third-party tools specify automatically supply null values but include the connection properties if you do not specify user credentials.

    If authentication is disabled in your distributed system, then you can specify any temporary username and password value when connecting. Connect to vFabric SQLFire with JDBC Tools provides more details.