Firestone Technical Resources

"Personal service for your impersonal technology."

News Articles

Articles posted here are for the use of our clients to get quick self help answers to questions and simple solutions to problems. News reports are not necessarily the opion of our company but for reference only. We don't provide any guarantee that solutions posted or referenced will work for your situation and that you should use them at your own risk. None of the information posted should be used for illegal practices.

VMware vCenter Server Appliance with embedded database fails due to full database partition

vCenter Server Appliance with an embedded vPostgres database may stop running with out any warning. After logging into the web user interface (web UI) of the appliance you may notice that, in the Storage Usage on the Summary tab, the database statistics are showing 100%. Attempting to start the vCenter Server services at this point will result in the service running for a brief moment before is automatically shuts down again. This occurs because a disk partition on the vPostgres database contains no free space.

VMware doesn't have any recommended preventative maintenance tasks at this time but it doesn't hurt to establish your own in order to prevent this sort of issue in the first place. There is a retention policy for the database and we will look at why that may not be adequate for some installations.

Continue reading
0
  2741 Hits
  0 Comments
2741 Hits
0 Comments

MySQL Import of SQL file fails with error 1064

On a number of occasions I have attempted to import an exported MySQL database file and received the following message.

/* SQL Error (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?# -------------------------------------------------------- # Host:     ' at line 1 */
/* Error with snippets directory: The specified path was not found */

# --------------------------------------------------------
# Host:                         127.0.0.1
# Server version:               5.5.40 - MySQL Community Server (GPL)
# Server OS:                    Win32
# HeidiSQL version:             7.0.0.4053
# Date/time:                    2014-01-20 09:48:36
# --------------------------------------------------------

Continue reading
0
  2023 Hits
  0 Comments
2023 Hits
0 Comments

QuickBooks database server will not start - SQLANY 17.0 cannot be found

​Issues with the QuickBooks database server used to be a fairly rare occurrence. But since 2019, many of the servers running QuickBooks have been updated to new versions of the Windows Server OS and the QuickBooksDB##. The end user will typically get the following error when attempting to connect to the server in a multiuser setting."Error Code: H2...
Continue reading
0
  105 Hits
  0 Comments
105 Hits
0 Comments