I am trying to use ARD but getting a service Layer error:
Service layer reported the following error:
Fault code s:Client: Operation: GetTableDataPageStart: Error executing: CREATE VIEW mv_659461916_7806_2621 AS SELECT r.tr_row_number ... Column names in each view or function must be unique. Column name 'FID_A' in view or function 'mv_659461916_7806_2621' is specified more than once.
Environment
Release: Component: TDMDTM
Resolution
The table in question contains two columns called 'FID A' and 'FID-a'. These columns will then will translated into FID_A because space and dash are converted into underscores. To resolve problem rename one of the columns.