I'm trying to publish a feature service (and its two related tables) with Validation capability enabled, but I am getting error 00298: Validation error table must be referenced by a layer. I have all four validation layers in my map, so I don't understand why I am getting the error.
I've created attribute rules. The data is versioned (Branch), the service's Layer Configuration also has Version Management enabled (in addition to Validation) and in the Feature Properties it has Sync enabled. Disabling any of these options does not resolve the error. I've also tried deleting and re-generating the validation tables per: How To: Regenerate Validation Tables for Attribute Rules. This was also unsuccessful.
How do I resolve this error and publish my layer?
I'm using Pro 3.1.3
Server 11.1
Portal 11.1
Enterprise GDB hosted on SQL Server 15.0.4280.7
GDB Version ArcGIS Pro 3.1.2 - 11.1.0.41833
Thank you!
ben
Check the properties of those validation layers. What are the connection properties?
@BenRomlein Along with @MikeMillerGIS suggestion are the validation features and table branch versioned as well.
https://pro.arcgis.com/en/pro-app/latest/help/sharing/analyzer-error-messages/00298-validation-error...
@MikeMillerGISI'm not sure what you mean by the connection properties. When I call connectionProperties on one of the validation layers this is the output:
{'dataset': 'DBO.GDB_ValidationPointErrors', 'workspace_factory': 'SDE',
'connection_info': {'authentication_mode': 'DBMS', 'branch': 'sde.DEFAULT',
'database': 'mydb', 'dbclient': 'sqlserver', 'db_connection_properties':
'myhost\\myinstance', 'password': '<*********>', 'instance':
'sde:sqlserver:myhost\\myinstance', 'server': 'myhost', 'user': 'myuser'}}
When I check the Source section of the layer properties, I get what looks like the expected data source properties. Is there a required property or something I should be looking for?
@Jake_S The validation features are branch versioned. I just tried manually un-versioning the features and I get the same error when I go to share as web layer
@BenRomlein do you remember if and how you solved this? I'm getting the same error
Update: It worked for me today after the sharing panel was closed and reopened
@BenRomlein same question from me also, did you get to a resolution?
@MikeMillerGIS I am also seeing the same error when attempting to publish the Sewer Expanded UN v2.2 Solution in Pro 3.5.3 with AGE 11.5. Is there an additional step required here?
Update: even after using the 'Add to map' option from the three dots menu at the right of each item, the errors persist when running analyze again despite a green tick displaying after adding each to the map in turn:
Unfortunately I still haven't solved this one.
I suspect something is wrong with the underlying table because (if I remember correctly) other validation workflows on this table were also not working correctly.
I was planning to migrate the data to a new table and try again but that migration process has proven more complicated and I haven't finished it yet.
Thanks Ben. I ended up unchecking 'Validation' prior to publishing to get around this.