Here is a list of common issues when attempting to install or run control room applications and how they can be resolved.
(Error: 40) Could not open a connection to SQL Server
Navigate to the following path:
C:\ProgramData\Micromine\PITRAM\Configuration\Machine
In this folder, locate the file:
ClientDatabaseConnectionConfiguration.xml
Open the XML file for editing and find the tag:
<UseSQLite>value</UseSQLite>
Ensure the value is set to true. If the tag is missing, you can manually add it to the file.
"<UseSQLite>true</UseSQLite>"
Client Layer Initialisation - Unable to obtain Client ID
If the application cannot connect to Pitram services, first check the WebServiceClientConfiguration.xml file located at:
C:\ProgramData\Micromine\PITRAM\Configuration\Machine
Ensure that the four service addresses are correctly pointing to the server. Additionally, verify that:
- The firewall isn’t blocking the connection.
- The machine is connected to the network or VPN.
Ports 951, 952, 953, 954 need to be configured as such, where 'localhost' is the application server address for your site.
Failed to find a Major Version - Version Compatibility
Ensure the version of the installed application matches the version on the application server and that the clocks are synced with the server.
Attempt to write to a readonly Database
The client databases are located under C:\ProgramData\Micromine\
Right click the folder, go to Properties and then the security tab.
"All Users" group should have MODIFY permissions to Micromine folder.
(GSS_027) Could not establish trust relationship for the SSL/TLS.
The SSL certificate, which is used for secure communications (HTTPS), had expired. Pitram was configured to use SSL for authentication, and the expired certificate caused an authentication failure.
Reconfigure the system to use HTTP (non-secure) instead of HTTPS (secure) to bypass the expired certificate.
1. Locate folder (root drive may vary):C:\ProgramData\Micromine\PITRAM\Configuration\Machine
2. Edit Serversecurityconfiguration.xml
3. Set the tag here to false: <AlwaysSecure>false</AlwaysSecure>
4. Save
Otherwise, obtain and install a new SSL certificate to restore secure connections via HTTPS.
Verify with your ITS team if SSL (secure HTTPS) connections are required for their operations beyond Pitram.
If security is critical, ensure that a valid SSL certificate is in place as soon as possible to restore secure connections.
-
Deleting the Local Database
If issues persist, consider deleting the local database.
Note: make sure DA/EE are closed before doing this.
Navigate to the following path:
C:\ProgramData\Micromine\PITRAM\ClientDatabase
Delete the local database files, then restart the application to generate a fresh copy.
Additionally, you can run either DA or EE 'As Administrator'.
Want to learn more?
Online Help Manuals - Click here for the latest version
Learning Management System - Click here to login or here to request access
Comments
0 comments
Please sign in to leave a comment.