Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / The SQL database has i...
Microsoft Dynamics AX (Archived)

The SQL database has issued an error.

(0) ShareShare
ReportReport
Posted on by Sathish_Chinnappan 1,307

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

  • Suggested answer
    Faqruddin Profile Picture
    Faqruddin 1,869 on at
    RE: The SQL database has issued an error.

    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

  • Suggested answer
    Ajit Profile Picture
    Ajit 8,755 on at
    RE: The SQL database has issued an error.

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

  • Suggested answer
    Marco iembo Profile Picture
    Marco iembo 105 on at
    RE: The SQL database has issued an error.

    Hi Sabih,

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

  • account payable Profile Picture
    account payable 670 on at
    RE: The SQL database has issued an error.

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

    4237.error.PNG

  • Sathish_Chinnappan Profile Picture
    Sathish_Chinnappan 1,307 on at
    RE: The SQL database has issued an error.

    Hi Iulian,

    I will try to synchronize and let u know.

  • Suggested answer
    Iulian Cordobin Profile Picture
    Iulian Cordobin 8,201 on at
    RE: The SQL database has issued an error.

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans