Select to view content in your preferred language

Error 00298 - Can't Publish a Service with Validation Enabled

1145
8
11-02-2023 01:41 PM
BenRomlein
Frequent Contributor

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?

Screenshot 2023-11-02 155928.png

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

8 Replies
MikeMillerGIS
Esri Frequent Contributor

Check the properties of those validation layers.  What are the connection properties?  

Jake_S
by Esri Contributor
Esri Contributor

@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...

0 Kudos
BenRomlein
Frequent Contributor

@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

0 Kudos
ChelseaRozek
MVP Regular Contributor

@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

Matt_McCready_Esri_UK
Occasional Contributor

@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?

0 Kudos
Matt_McCready_Esri_UK
Occasional Contributor

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: 

Matt_McCready_Esri_UK_1-1757337485663.png

 

0 Kudos
BenRomlein
Frequent Contributor

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.

0 Kudos
Matt_McCready_Esri_UK
Occasional Contributor

Thanks Ben. I ended up unchecking 'Validation' prior to publishing to get around this.

0 Kudos