Frequently asked questions about Esri Roads and Highways

Database questions

Database administrator questions

Roadway Characteristics Editor questions

During an edit operation, an error is thrown and my changes are not propagated within the database. What causes this?

Your edits are not applied to the database when an error occurs. During your transaction, there was a failure that occurred which caused your edits to roll back to its previously saved state.

Transaction failures include:

  • The RDBMS becomes disconnected from your edit session.
  • The staging table does not exist or cannot be found.
  • An element of the ALRS schema does not exist or cannot be found.

I have point and line events in my ArcMap session that are pointing to tables in a Microsoft SQL Server database. In an edit session, when I open the attribute table and right-click column header X or Y, then click Calculate Geometry, why do I get an Underlying DBMS error?

The error you are experiencing is specific to SQL Server databases and happens when one of the rows does not have a shape, for example, in the attribute table, where the field name Loc_Error displays Route Location Not Found.

For events, ArcMap is trying to write NaN into a Double field in SQL Server. As a result, SQL Server databases return an error. You can choose to ignore this error because the row that prompts the error is an empty shape, hence the X and Y values are null.

For events, Esri Roads and Highways checks for the database and inserts NaN to ensure an error is not thrown.

If you do not want to see the Underlying DBMS error, you can manually select rows in the attribute table where the field named Loc_Error displays No Error and calculate X and Y.

When I leave ArcMap idle for a long period of time in an edit session connected to an Oracle database, why do I get an Underlying DBMS error or ORA-01012: not logged on message when I resume my edit session?

By default, an Oracle database will time out an idle connection after 60 minutes of nonactivity. This time-out may be more or less depending on your Oracle configuration. Once an idle connection time-out has occurred, the Oracle database session is ended and an error message will display.

As a best practice, it is recommended that you save edits and stop editing prior to leaving your ArcMap session. However, if an error occurs, you can close ArcMap and reopen the MXD.

Does Roads and Highways support ArcSDE multiuser editing in a versioned environment?

Yes.

Users can edit their Roads and Highways LRS leveraging the versioning capability in ArcSDE. The LRS can be edited and event behaviors applied in a different version than default. Special care must be taken, though, when resolving conflicts on edits against the same routes and/or events as it is possible to take the Route feature class out of alignment with the Centerline feature class, Centerline Sequence table, Route table, and Calibration Point feature class. It is also possible to change calibration when resolving conflicts to change route calibration without applying event measure behaviors. As such, it is recommended that only one user edit a route and associated events at a time across all versions.

When I navigate a map in ArcGIS with Roads and Highway's network and events, the navigation is slow. Is there any way to boost performance?

Yes.

First, ensure that the Roads and Highways minimum schema tables are indexed. If they are not indexed, performance for large data volumes will not be optimal.

Second, ensure that map authoring best practices are being followed. Event data is dynamically segmented and located on the map from its route and measure values at map render time. The performance of events are not as good as features in ArcGIS (since features have already been located, the shape stored, and spatial indexing possible). Compensate by setting scale dependencies in your map that matches ArcGIS's ability to render your event data with your performance expectations. In addition, be judicious with the number of layers being visualized at one time.

Third, ensure Roads and Highways 10.0 Service Pack 3 is installed. At Service Pack 3 the network layer is persisted in the Geodatabase as a feature class and no longer a dynamic route layer. This change results in feature class level ArcGIS mapping performance and faster event mapping as well.

When I log on to ArcGIS Server to query a server, I get error code: 500 Object reference not set to an instance of an object. What do I do to correct this error so I can query the server?

When you see error code: 500 Object reference not set to an instance of an object, this means the map document for that map service contains at least one invalid layer. This could be due to a data source connection or a configuration issue.

To resolve the error, ensure that all layers in the map documents are valid when publishing LRS-enabled map services.

Is it possible to access the Roads and Highways GP tools on ArcGIS for Server?

Yes. In order to access the tools on ArcGIS for Server, the tools need to be published as part of a geoprocessing model. Please reference the toolbox located in your Esri Roads and Highways Server installation directory for an example of how to build a model to incorporate the GP tools.

Can I publish an MSD with Linear Referencing Capability?

No. You must publish an MXD. Event layers are not supported by MSD publishing.

When I am working in the Roadway Characteristics Editor, why can I not edit certain records in the Event Attributes grid?

If an event record's event ID field is <null>, the user can not edit the event in the Event Attributes grid. For more information about the importance of Event ID's when editing events, see RCE Deployment Guide Overview and Editing Event Records.


12/19/2012