Microsoft Dynamics AX (Archived)

The SQL database has issued an error.

(0) Share

Report

Posted on by Sathish_Chinnappan

1,318

Hi,

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..

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Iulian Cordobin 8,201 on at

Like (1)

Report

Perform a Data Dictionary Synchronize on the table LOGISTICSADDRESSCOUNTRYREGION. That should solve your problem. You can also perform a Synchronize on the entire Data Dictionary, if you want to make sure other problems will not appear.

Was this reply helpful? Yes No
Sathish_Chinnappan 1,318 on at

Like (0)

Report

Hi Iulian,

I will try to synchronize and let u know.

Was this reply helpful? Yes No
account payable 670 on at

Like (0)

Report

am getting same issue from EcoResCategory..if you know please help

Was this reply helpful? Yes No
Suggested answer

Marco iembo 105 on at

Like (0)

Report

Hi Sabih,

synchronize and compile the table ECORESCATEGORY. That should solve your problem.

Was this reply helpful? Yes No
Suggested answer

Ajit 8,755 on at

Like (0)

Report

This particular issue is already resolved here - [View:https://community.dynamics.com/ax/f/33/p/245646/680347#680347]

Was this reply helpful? Yes No
Suggested answer

Faqruddin 1,883 on at

Like (0)

Report

Hello Sathish,

The column 'MEMBEROFCUSTOMSUNION_RU' is standard column on LogisticsAddressCountryRegion table. First compile LogisticsAddressCountryRegion table and check there is any errors and try to fix it. If problem still exists try following solutions..

1. SysAdmin->Periodic-DataBase->SQL Administration->Table Actions and select Synchronization Database

or

2. Stop AOS & SQL database service. Delete XPO files from User and Xppil folder and Start AOS service.

or

3. Go to Development environment Tools->Caches and refresh all caches 2 or 3 times.

or

4. Do full CIL

Thanks

Faqru

Was this reply helpful? Yes No