Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Cannot create a record...
Microsoft Dynamics AX (Archived)

Cannot create a record in SysXppAssembly

(0) ShareShare
ReportReport
Posted on by Community Member

I get this error on my production environment. meanwhile, everything is working fine so far.

I know how to fix it by performing the following steps as stated here:

  1. Stop the AOS
  2. Navigate to the XppIL folder in your AOS server “C:\Program Files\Microsoft Dynamics AX\60\Server\YourAXInstanceName\bin\XppIL”
  3. Backup the files from the XppIL folder.
  4. Delete the files from the XppIL folder. Note: files only not sub folders.
  5. Restart the AOS
  6. The XppIL folder files will be created after the AOS restart

the thing is we are an E-Commerce which it is really difficult to stop our website to perform full CIL as it is very time consuming.

Questions:

1. Is there any other way rather than Full CIL to fix the issue?

2. What are the consequences of this error if I want to postpone the fix (fix it later in a more appropriate time)?

*This post is locked for comments

  • Suggested answer
    Muthusamy Profile Picture
    Muthusamy 4 on at
    RE: Cannot create a record in SysXppAssembly

    Hi Mehrdad,

    1).Stop the AOS

    2).Navigate to the XppIL folder in your AOS server “C:\Program Files\Microsoft Dynamics      AX\60\Server\YourAXInstanceName\bin\XppIL”

    3).Backup the files from the XppIL folder.

    4).Delete the files from the XppIL folder. Note: files only not sub folders.

    5). Truncate the SYSXPPAssembly table through SQL query. (truncate table sysxppassembly).

    6).Restart the AOS

    If Its not working,

    After restarting the AOS, do the Build compile (If you have version Ax2012 R2 CU7 or above that)

    If you are getting any errors, solve the compilation errors and generate the Full CIL.

    Thanks,

  • Suggested answer
    Vilmos Kintera Profile Picture
    Vilmos Kintera 46,149 on at
    RE: Cannot create a record in SysXppAssembly

    Compilation issues are related to the imperfection of the AXBuild tool. To address your problem with minimal downtime, the best thing to do is to do a compile forward on the affected classes (or yet better full compile in the AX client) in your Staging environment.

    After that do a Full CIL in Staging, and prepare the modelstore to be released to Production. Then after it is released, in Prod you will do the regular tasks (Data Dictionary Synchronize, activate AIF port, etc., and it should be working fine.

    Deleting the XPPIL folder contents is not really required. Also make sure that debugging is disabled in your AX AOS configuration for Prod.

    Also make sure you only have 1 AX AOS instance running during the maintenance, and when the release tasks are completed, you may start the rest of them.

  • Martin Dráb Profile Picture
    Martin Dráb 231,782 Most Valuable Professional on at
    RE: Cannot create a record in SysXppAssembly

    Also make sure you stop all AOS services.

  • Mea_ Profile Picture
    Mea_ 60,278 on at
    RE: Cannot create a record in SysXppAssembly

    Hi Mehrdad Kamelzadeh,

    Actually you missing a step, after 4. Delete the files from the XppIL folder. Note: files only not sub folders. you should truncate the SysXppAssembly table in SQL. and then start AOS. Please don't forget to take a DB backup before doing this. 

  • Community Member Profile Picture
    Community Member on at
    RE: Cannot create a record in SysXppAssembly

    I wanted to deploy new customization on the our Production environment. For that, I followed the "

    Deploying customizations across Microsoft Dynamics environments" white paper.

    •  Imported the customized model into staging environment
    • Performed Full CIL on the staging environment
    • Exported the ModelStore of staging environment after a successful build and then imported on Production environment.
    • Deactivated/Activated one of our AIF services (on Production) and it got two errors on the customization I had done. I resolved them by performing "Compile Forward" on those two classes.
    • I tried to do Incremental CIL however, this time I got the following error:

    "Cannot create a record in SysXppAssembly (SysXppAssembly). The record already exists"

    • To solve this issue I deleted the XppIL folder and restarted the AOS. but still the issue remained.

    The most important question is what shall I worry about now?

    the second question is how to resolve that with minimum downtime?

  • Martin Dráb Profile Picture
    Martin Dráb 231,782 Most Valuable Professional on at
    RE: Cannot create a record in SysXppAssembly

    Could you please start with explaining what exactly is the problem? What exactly happens and when? When did it start happening?

    Basheeruddin is right your process doesn't build CIL at all - that would be done by running "Generate CIL", but I wouldn't do it in production. Anyway, the title talks about a problem with writing to SysXppAssembly table, not about the problem with files on disk, so you seem to be playing with a wrong thing,

  • Community Member Profile Picture
    Community Member on at
    RE: Cannot create a record in SysXppAssembly

    I did that. I deleted whole files and folders inside XppIL folder and restarted AOS but I got the same error again. What do you think about consequences. Right now I don't have time to fix it and I want to postpone that. Is there any consideration I have to be aware of?

  • Basheer17 Profile Picture
    Basheer17 2,720 on at
    RE: Cannot create a record in SysXppAssembly

    In the steps that you've mentioned, you are not doing Full CIL. You are deleting the XppIL and restarting the AOS to get the IL assemblies of last successful Full CIL. The downtime required is the time to restart the service.

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,910 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,782 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans