Slow performance loading Case documents and files in DigEplan

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

1. Goto C:\Oracle\glassfish3\glassfish\domains\AutoVue\applications\av_con\WEB-INF\web.xml (this may not be in the C: drive)
2. Locate parameter CASETOOL_db_URL
3. 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

1. Goto C:\Oracle\glassfish3\glassfish\domains\AutoVue\applications\av_con_ws\WEB-INF\web.xml (this may not be in the C: drive)
2. Locate parameter CASETOOL_db_URL
3. 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