If your DigEplan application suddenly becomes very slow loading the original files, but does not crash, this could be due to a change to the Case system database settings or access credentials.
Note: Answers in this article will require Administrative access to the DigEplan servers
To check the system in this event, please follow these instructions
On the DigEplan View & Conversion server
- Goto C:\Oracle\glassfish3\glassfish\domains\AutoVue\applications\av_con\WEB-INF\web.xml (this may not be in the C: drive)
- Locate parameter CASETOOL_db_URL
- Check the database connection string in the Param Value (see the example below)
<!-- Oracle example : value="jdbc:oracle:thin:@Nofa02.Nofa.local:1521:tgvg1891" -->
<!-- MySQL example : value="jdbc:mysql://localhost:3306/lct" -->
<!-- MySQL example : value="jdbc:mysql://localhost:3306/centricgisvb" -->
<init-param id="CASETOOL_db_URL">
<param-name>CASETOOL_db_URL</param-name>
<param-value>jdbc:DriverType://HostName:Port;DatabaseName</param-value>
</init-param>
On the Conversion server
- Goto C:\Oracle\glassfish3\glassfish\domains\AutoVue\applications\av_con_ws\WEB-INF\web.xml (this may not be in the C: drive)
- Locate parameter CASETOOL_db_URL
- Check the database connection string in the Param Value (see the example below)
<!-- Oracle example : value="jdbc:oracle:thin:@Nofa02.Nofa.local:1521:tgvg1891" -->
<!-- MySQL example : value="jdbc:mysql://localhost:3306/lct" -->
<!-- MySQL example : value="jdbc:mysql://localhost:3306/centricgisvb" -->
<init-param id="CASETOOL_db_URL">
<param-name>CASETOOL_db_URL</param-name>
<param-value>jdbc:DriverType://HostName:Port;DatabaseName</param-value>
</init-param>
If the HostName:Port:DatabaseName are correct, please also validate the Username and Password are valid in the following parameters
<init-param id="CASETOOL_db_username">
<param-name>CASETOOL_db_username</param-name>
<param-value>UserName</param-value>
</init-param>
<init-param id="CASETOOL_db_password">
<param-name>CASETOOL_db_password</param-name>
<param-value>Password</param-value>
</init-param>
If any details are incorrect, please update using notepad ('run as' administrator may be required) and reload the corresponding web applications - How to reload a Glassfish web application
Comments