Select to view content in your preferred language

Definition query should show the descriptive error message from the database, not a generic error message

1121
1
12-11-2022 09:31 AM
Status: Open
Labels (1)
Bud
by
Honored Contributor

If I try to create a definition query that has invalid syntax, ArcGIS Pro displays a generic error message:

The SQL expression has invalid syntax.

Bud_0-1670779398122.png

That generic error message isn't very helpful.

The database is likely throwing a more descriptive error message behind the scenes:

ORA-00942: table or view does not exist
00942. 00000 - "table or view does not exist"
*Cause:
*Action:
Error at Line: 5 Column: 13

SQL Developer:

Bud_2-1670779724431.png

Could ArcGIS Pro be enhanced so that the more descriptive database error messages are displayed in the definition query window? That would help with debugging.

Thanks.


ArcGIS Pro 2.6.8; Oracle 18c 10.7.1 enterprise geodatabase
and ArcGIS Pro 3.0.3; mobile geodatabase

 

1 Comment
SSWoodward

Thanks for the Idea @Bud 

I've changed the label on this idea to 'Map Authoring' to make sure it gets in front of the correct team.