Luminata: Troubleshooting Database Connection Problems

Description

If the user is experiencing issues with connecting to the Remote database, there are steps that can be taken by internal database administrator (DB admin) to resolve the problem before reaching out to Support. The following instructions are intended for the DB admin working on the SDBES (Spectrus DB Enterprise Server).

Solution

1. Navigate to Spectrus DB Server folder > SERVICES.SRV > SMC.EXE.
2. Ensure that Spectrus DB Enterprise Server status is Started.
3. Run ESMC as administrator, right-click server name and log in as administrator account.
4. Right-click database server and select Properties and make sure the Connection String and Port number are correct. Click Test. You should receive a pop-up message: Success.
5. Check if there are any conflicts with different versions by noting which versions are installed and what programs are running in Task Manager.
6. Open ODBC Data Sources (64-bit) and navigate to Drivers tab. Confirm you see the Oracle or PostgreSQL drivers in the list.
7. Check the SDBES installation log files for errors. Located at:

…\Folder with Spectrus DB Server\SPECTRUSDB.SRV\cbookserver_errors.log

…\Folder with Spectrus DB Server\SPECTRUSDB.SRV\cbookreindexer_errors.log

…\Folder with Spectrus DB Server\SPECTRUSDB.SRV\cbookserver_scripts.log

…\Folder with Spectrus DB Server\SPECTRUSDB.SRV\bug_reports\

8. Contact Support and provide all the details.