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.
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.
Video URL on how to open a Support Case - https://communities.ca.com/videos/5898-demo-how-to-open-a-support-case
You can download the latest version of ARD by following the directions in this document: https://comm.support.ca.com/kb/How-to-Download-Agile-Requirements-Designer/KB000009613
To contact support, go to https://www.ca.com/us/services-support/ca-support/contact-support.html.