Hi everyone,
I am using MS SQL 17 and ArcGIS Pro 2.5. What I want to do is to publish a utility network from a file geodatabase. So I started with an attempt to copy/paste my utility network to Enterprise geodatabase. However, that was not possible because I would non stop get an error 000260. I played with some script to fix that, it didn't work. My next idea was to export an asset package from a file geodatabase and apply it to Enterprise. I have created the same service area and Utility network in Enterprise gdb and applied the asset package. That worked perfectly.
However, after that, I deleted/drop the database from the SQL server(what I have read it is the recommended way to delete Gdb by some users in Pro) because of some issues with versioning and tried to repeat previous steps. And now I am experiencing several errors. Pro would create the UN on Enterprise gdb without any errors but every time I would try to add that newly created UN layer to the map or try to see the properties of the UN layer ArcGIS Pro would crash. If I try to apply an asset package to it, it would say that the only data owner has permission to do that. However, I am logged with the right portal account which is the data owner. I believe it can not read the UN layer properly because is broken.
Now I have a question, what would cause this? At first, I didn't have any problems. I deleted DB from MS SQL studio but left the SDE table, so I am very suspicious that I haven't deleted something right. And I don't know if it might be important it is SDE owned schema gdb. Or that on the portal I am still assigned as Utility network owner of the previous network?
I tried to create gdb with a new database from SQL, new users. Nope. Same error.
Thank you
