Oklahoma DOT Pro Upgrade - Share as web layers issues

[Alexander_Couch]

Happy Monday RHUG! ODOT is in the final steps of upgrading to RH Pro and we have hit a major snag. I'll be the first to admit that my tech knowledge is limited when it comes to doing any sort of system upgrade. 

Everything has gone relatively smoothly until we started trying to publish our LRS as a web layer. We were able to publish our Routes/Centerlines/Calibration points as a "Route Editing Service" but when we try to do the same thing with all of our events (77 events and our LRS Road Network layer) we run into publishing errors. More specifically, we keep getting Error 001369 and at times Error 001487. Has anyone run into these issues and if you did how did you resolve them? I've attached and highlighted the logs from Server Manager for context.

Thanks for absolutely any help or any ideas yall have!

[AyanPalit]

@Alexander_Couch What are the versions of ArcGIS Enterprise and Pro?

Recommend reviewing the 'underlying dbms error ora-03114'

Looks like, the portal credentials used for publishing, is failing to have full access to the data layers in the Oracle RDBMS.  

[Alexander_Couch]

Enterprise is 11.3 and Pro is 3.3. We'll look into the portal credentials.

We unfortunately were set back a little because the employee who set up our portal and had all of that great knowledge left so I'm left learning how to do it all on the fly!

[AyanPalit]

@Alexander_Couch 

I assume the LRS dataset is branch-versioned. There are specific requirements around that as well. 

Here are some references :

When the Version Management capability is enabled, the following requirements exist:

• All datasets in the map you're publishing must be branch versioned. You cannot publish traditional and branch versioned datasets in the web feature layer.
• You must own the data you're publishing. That means the credentials you use in the database connection that accesses the data must be those of the data owner.

https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/overview/publish-branch-versioned-da... 

https://pro.arcgis.com/en/pro-app/latest/help/production/roads-highways/share-as-web-layers.htm