DBMS table not found [42S02:[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid object name 'GDO.ElnetUN'.] [GDO.ElnetUN]

Question

Hi,

I have installed a new PC with ArcGIS Pro 3.5.4 and whenever I try to create a new Utility Network feature service with Share As Web Map I get the following error for the Utility Network:

DBMS table not found [42S02:[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid object name 'GDO.ElnetUN'.] [GDO.ElnetUN] I can run the exact same process with same database and portal on other machines and it publishes without any errors. I have also tried reinstalling both ArcGIS Pro and ODBC drivers, but get the same result. Any ideas as to why i get this error and how it can be fixed?

MalteSørensen · Answer

Hi Robert,

I am using same connection file on both machines, which is using the credentials of  the data owner, so I am guessing it has something to do with the installation.

It only seems to have issues with the UtilityNetwork layer, as I can publish maps not containing this without issues.

RobertKrisher · Answer

Is the connection file using the credentials of the data owner?

It sounds like there may be a difference in the connection files between the machines. If you copy one of the connection files from the other machines to this one, does it work?