The SQL database has issued an error.

Hi All,

When i opened the AX application following error is showing in infolog:

Cannot select a record in Country/region (LogisticsAddressCountryRegion).
The SQL database has issued an error.

SQL error description: [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name ‘MEMBEROFCUSTOMSUNION_RU’.

SQL statement: SELECT T1.COUNTRYREGIONID,T1.ISOCODE,T1.ADDRFORMAT,T1.CURRENCYCODE,T1.TIMEZONE,T1.ADDRESSUSEZIPPLUS4,T1.ISIMMUTABLE,T1.BACENCODE_BR,T1.OKSMCODE_RU,T1.MCRIOR_FACILITY_ID,T1.RPAYPARENTCOUNTRYREGIONID,T1.MEMBEROFCUSTOMSUNION_RU,T1.RECVERSION,T1.PARTITION,T1.RECID FROM LOGISTICSADDRESSCOUNTRYREGION T1 WHERE (PARTITION=?)

Can anyone help me on this…

Can you try by doing a Full synchronization ?

Hi,

thanks for the reply.

I will and let u know.