HY000: Failed to connect to datasource: No description available in database ::c:/program files/vembu/vembubdr/data/sgserver.db

HY000: Failed to connect to datasource: No description available in database ::c:/program files/vembu/vembubdr/data/sgserver.db

KB ID: 115069
Cause:
The above alert is thrown while logging in from the console of BDRSuite/OffsiteDR if there exists an issue in PostgreSQL connectivity. It will be shown in the following cases:
1. First login post fresh installation.
2. Logging in an existing Server.
3. First login post upgrade from an older version to a new version.
Solution:
For Fresh Installation and Upgrade:
In this case, the issue may be due to the improper installation of the ODBC driver while installing PostgreSQL. To check this,
1. Go to Start and Search for ‘ODBC Data Sources’ and open it.
2. Select the SystemDSN tab and click on PostGreDBConnection.
3. Now select configure and check for the following:
  1. DataSource: PostGreDBConnection
  2. Database: SGDatabase
  3. Server: localhost
  4. Username: postgres
  5. Port: 32010 (or the port specified during installation)
  6. Password: admin (type admin in the tab given)
4. After checking for all the above parameters, click Test. If the result is a success, then the issue is rectified.
5. If the result is shown as failed, then go to "C:/Program Files/Vembu/VembuBDR/conf” and open SGConfiguration.conf in any text editor. Search for ODBC and verify with the Database name, username, and password as it was mentioned in ODBC Datasource connection.
6. If the SGConfiguration.conf file is edited and saved, a restart of the BDRSuite service from services.msc is required.
7. If the datasource name is not listed, then re-installation of Server is required (this is due to the intermediate failure of PostgreSQL installation in rare cases).
For Existing Server Case:
For this case, the issue might occur if PostgreSQL is stopped or if it has reached the maximum number of sockets. To rectify this:
1. Restart PostgreSQL services from services.msc.