This page has solutions to problems that may occur during the implementation of the Roads & Highways Interface.

Problem:

See this error during the Roads and Highways Interface task of the system job:

sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

Something went wrong running EXPORT_NETWORK job.

Solution:

The solution to this certification problem is as follows:

We received cert files from the customer's IT that included all machines used by ArcGIS server. (There may be more than one if load balancing is used. It usually has a .crt suffix.)
From the command line on the machine with the TomCat server, enter a command similar to this one to import a signed primary certificate from the Roads and Highways interface to an existing Java keystore:
```
keytool -import -trustcacerts -alias mydomain -file mydomain.crt -keystore keystore.jks
```

Import New CA into Trusted Certs

keytool -import -trustcacerts -file /path/to/ca/ca.pem -alias CA_ALIAS -keystore $JAVA_HOME/jre/lib/security/cacerts

When asked for a password, enter it.
When asked if you accept the new cert, type “Y”.
Restart the TomCat service.

OR ArcGIS server may have been set to https-only and needs to be reset (if http is the intended configuration):

Log in to the ArcGIS Server Administrator Directory. The URL is typically available at https://gisserver.domain.com:6443/arcgis/admin.
Navigate to Security > Config > Update.
Set the Protocol to HTTP-only and click the Update button.

Problem:

See this error during the Roads and Highways Interface task of the system job:

Could not initialize class com.agileassetsinc.core.gisnew.formats.fgdb.core.Geodatabase

Solution:

Restart Tomcat or make sure the FGDB API is installed correctly. See the Roads and Highways User's Guide for instructions on FGDB API installation.

Problem:

See this error during the Roads and Highways Interface task of the system job:

Error occurred when executing 'Roads/Highways Interface':

Native Library C:\RnH\soft\apache-tomcat-7.0.56\bin\core.dll already loaded in another classloader

Solution:

Restart Tomcat.

Problem:

See this error during the Roads and Highways Interface task of the system job:

com.agileassetsinc.core.TRDIException: ORA-02289: sequence does not exist

Solution:

Replace the outdated sequence named NET_EXT_RH_LOC_IDENT_SEQ with S_NET_EXT_RH_LOC_IDENT. This is a problem that has been fixed in newer versions. If you are experiencing this, then an upgrade to newer software may be needed.

Problem:

See this error during the Roads and Highways Interface task of the system job:

ORA-01400: cannot insert NULL into ("AMS_NC_69SSP2_HF_031016"."NET_EXT_LRMS"."NET_LRM_ID")

Solution:

Populate Net_LRM_ID in Setup_Loc_Ref. Instructions for this are in the Roads and Highways User's Guide.

Problem:

See this error during the Roads and Highways Interface task of the system job:

ORA-00904: "E"."TEMPO_EFF_BIRTH_DATE": invalid identifier

Solution:

Make sure Setup_Loc_Ident has TEMPO_EFF_BIRTH_DATE field by making one of the event tables temporal. Instructions for this are in the Roads and Highways User's Guide.

If making an event temporal does not work it may be because there is no entry for SETUP_LOC_IDENT in SETUP_TABLES. Add that in and try again.

Problem:

See this error during the LRS Gateway task of the system job:

Java heap space

Solution:

Increase TomCat server memory with a command similar to this:

CATALINA_OPTS="-server -Xmx8092m -Xms2048m -XX:MaxPermSize=1024m ..."

Gather stats on key tables (replace the parts in red with the appropriate owner)

begin

dbms_stats.gather_index_stats(ownname => 'AMS_NC_06_09SP3HF1', indname => 'SETUP_NETWORK_LINES_NM_UI', estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE);

dbms_stats.gather_index_stats(ownname => 'AMS_NC_06_09SP3HF1', indname => 'SETUP_NETWORK_LINES_NC_UI', estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE);

dbms_stats.gather_index_stats(ownname => 'AMS_NC_06_09SP3HF1', indname => 'SETUP_NETWORK_LINES_PK', estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE);

dbms_stats.gather_index_stats(ownname => 'AMS_NC_06_09SP3HF1', indname => 'NET_EXT_LOCATIONS_U_OUT_UI', estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE);

dbms_stats.gather_table_stats(ownname => 'AMS_NC_06_09SP3HF1', tabname => 'SETUP_NETWORK_LINES', estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE, method_opt=>'FOR ALL COLUMNS SIZE AUTO');

dbms_stats.gather_table_stats(ownname => 'AMS_NC_06_09SP3HF1', tabname => 'NETWORK_LANES_COUNT', estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE, method_opt=>'FOR ALL COLUMNS SIZE AUTO');

dbms_stats.gather_table_stats(ownname => 'AMS_NC_06_09SP3HF1', tabname => 'NET_EXT_LOCATIONS_U_OUT', estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE, method_opt=>'FOR ALL COLUMNS SIZE AUTO');

end;

/

Problem:

See this error during the Roads and Highways Interface task of the system job:

“no core in java.library.path”.

Solution:

Load the FGDB API libraries. Instructions for this are in the Roads and Highways User's Guide.

Problem:

See this error during the LRS Gateway task:

Error occurred when executing 'LRS Gateway':

java.lang.ArrayIndexOutOfBoundsException

Solution:

This is a problem that has been fixed in newer versions. If you are experiencing this then an upgrade to newer software may be needed.

Problem:

See an error like this during the Roads and Highways Interface task of the system job:

Error while populating EXT tables:
For input string: "11500002750016C99"

Solution:

This is a problem that has been fixed in newer versions. If you are experiencing this then an upgrade to newer software may be needed.

Problem:

See this error during the Roads and Highways Interface task:

Error occurred when executing 'Roads/Highways Interface':
unexpected element...

Solution:

The FGDB API needs the exact version we are working with. This is a problem that has been fixed in newer versions. If you are experiencing this then an upgrade to newer software may be needed.

Problem:

See this error during the Roads and Highways Interface task of the system job:

ORA-00933: SQL command not properly ended

Solution:

Make at least one table that links to setup_loc_ident temporal. Instructions for this are in the Roads and Highways User's Guide.

Problem:

Routes are copied over through the interface with null geometry

Solution:

This is a known problem associated with routes that use curves as part of their geometry. The Esri-built FGDB API cannot handle this kind of geometry. The solution is to redigitize these routes without curves. This can be done with the Esri Densify command. You can identify routes with curves using the Identify True Curves tool in ArcMap (https://www.arcgis.com/home/item.html?id=267ce9c896a5480982cfa4bfa1747018).

Space shortcuts

Page tree

Problem:

Solution:

Problem:

Solution:

Problem:

Solution:

Problem:

Solution:

Problem:

Solution:

Problem:

Solution:

Problem:

Solution:

Problem:

Solution:

Problem:

Solution:

Problem:

Solution:

Problem:

Solution:

Problem:

Solution:

Problem:

Solution:

Space shortcuts

Page tree

Troubleshooting for the Roads and Highways Interface

Problem:

Solution:

Problem:

Solution:

Problem:

Solution:

Problem:

Solution:

Problem:

Solution:

Problem:

Solution:

Problem:

Solution:

Problem:

Solution:

Problem:

Solution:

Problem:

Solution:

Problem:

Solution:

Problem:

Solution:

Problem:

Solution: