Agile Requirement designer Service layer reported

book

Article ID: 127965

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

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.

Additional Information

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.