Failed Data Repo - Tables Map Anomolies

[Former Member]

I've come across an 'error' in IS_FD_TABLES_MAP that I am struggling to understand.

I have several tasks that include a particular table, and if I run any of them, a new duplicate row gets generated in the tables map.

Illustrated:

SELECT        TOP (100) PERCENT PROJECT_NAME, CONNECTION_NAME, FQ_TABLE_NAME, TABLE_ALIAS

FROM            dbo.IS_FD_TABLES_MAP

WHERE        (FQ_TABLE_NAME = N'0000_ACTIVECUSTOMERS')

PROJECT_NAME	CONNECTION_NAME	FQ_TABLE_NAME	TABLE_ALIAS
P_DQ_LB_EU_Cu	Views	0000_ACTIVECUSTOMERS	0000_ACTIVEC_P36621T37021
P_DQ_LB_EU_Cu	Views	0000_ACTIVECUSTOMERS	0000_ACTIVEC_P36621T37021
P_DQ_LB_EU_Cu	Views	0000_ACTIVECUSTOMERS	0000_ACTIVEC_P36621T37021
P_DQ_LB_EU_Cu	Views	0000_ACTIVECUSTOMERS	0000_ACTIVEC_P36621T37021
P_DQ_LB_EU_Cu	Views	0000_ACTIVECUSTOMERS	0000_ACTIVEC_P36621T37021

I have sat for many hours trying to recreate this behavior in a new project.

Adding columns to a data view, removing columns, creating multiple tasks .. all sorts of combinations .. but I cannot recreate this error.

Update:

I took some actions to try and resolve.

I deleted all _FD,_FR,_VW & _VIEW objects relating to the project.

I also removed all entries related to the aliases in  TABLES_MAP, RUN_HISTORY & RULES_INFO.

Unfortunately all the above did nothing to rectify my problem.

Has anyone else seen this happen ?

Any ideas as to cause ?

Many Thanks

Message was edited by: Simon Bush Simply updated post with details of a hopeful fix - that  failed.

[Former Member · Accepted solution]

Cause has now been identified.

After contacting SAP and sharing some log info, seems that this affects views whose name begins with any other than a-Z character.

Seems the SQL behind the scenes is not wrapping names in appropriate identifiers.

Note: our repo is in SQL Server - I assume other platforms may behave differently.

Workaround is to rename and avoid offending naming convention.

A proper fix is promised ... no idea when.