[Human Readable Change History] Incorrect syntax near '.'.

Forge Component
(22)
Published on 8 Apr by Johan den Ouden
22 votes
Published on 8 Apr by Johan den Ouden

Hi,

I was getting the following error :
Error in advanced query GetReferencedRecord_Original_OSSYS in Translation_GetValuesFromReferencedEntity in DiffEntityDataToText (SELECT @NameAttribute  FROM ossys@PhysicalTableName  WHERE @IdAttribute = @RecordId): Incorrect syntax near '.'.

It appears that in "Translation_GetValuesFromReferencedEntity" action it was expected that the physical name of the table contains either "OSUSR" or "OSSYS".

It happens that for some reason on our system we had a name not respecting these premises, so we added the following filter Entity.Physical_Table_Name like "%OSUSR%"
or Entity.Physical_Table_Name like "%OSSYS%"
to GetEntityAttributes aggreggate on Translation_BuildChangedString_Record.

That restricted the results to only those expected. 

Do you see any problem with that approach ? 



Thanks,

Pedro Neto


What table name did you actually have?

J.Ja

It was something like [Appname].[dbo].[tablename] and there are a couple of them like that. 

Pedro Neto

Justin James wrote:

What table name did you actually have?

J.Ja



Need specific examples, were these system tables or application data tables?

J.Ja