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

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

  
Forge Component
(20)
Published on 23 Nov (3 weeks ago) by Johan den Ouden
20 votes
Published on 23 Nov (3 weeks ago) 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