Network Analyst Services Throwing "Invalid object name '##SDE_session'" Errors

sferreira

My organization is currently running ArcGIS Enterprise, with a SQL Server back-end, and we're in the process of upgrading to 10.9.1. While the main platform upgrade has been handled successfully, it appears that we're unable to run Network Analyst services on the new version.

We currently use three Network Analyst map services in our workflow: 

Routing
Closest Facility
Vehicle Routing Problem

In 10.9.1, we've been able to deploy these services successfully. However, attempts to run these services are failing, as the session log file tables aren't being created. We're receiving the following error in return:

Invalid object name '##SDE_session[SessionID]_[DBID]'

- where SessionID is the relevant Session ID, and DBID is the relevant database ID.

We've looked through the system to ensure that we are using the latest ODBC drivers, and we are connecting to the database; moreover, session tables are being created in the database, as we're seeing "##SDE_[ID]_[SessioniD]_[DBName]" tables in the database.

Is there anything that could lead to our map services being unable to create the named session log tables, or something that we could be overlooking that could lead to this case?

MaxZeng

Seems like you might run into this bug, and here is the patch to get this fixed. 

One additional thing I want to mention, is that 10.9.1 is the last release that supports Vehicle Routing Problem as map service with network analysis capabilities. Route and Closest Facility are still supported as map service with network analysis capabilities in later releases. You probably want to switch to use Vehicle Routing Problem as geoprocessing service. At 10.9.1, you can run publish routing services utility to publish vehicle routing problems as geoprocessing service (you could specify -S as VehicleRoutingProblem to just publish this, or you could leave out -S which publish all the services). Once you have vehicle routing service geoprocessing service published, here is the documentation for the rest API parameters, https://developers.arcgis.com/rest/services-reference/enterprise/vehicle-routing-problem-service.htm.