Cannot create a record in SysXppAssembly

(0) Share

Report

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:

Stop the AOS
Navigate to the XppIL folder in your AOS server “C:\Program Files\Microsoft Dynamics AX\60\Server\YourAXInstanceName\bin\XppIL”
Backup the files from the XppIL folder.
Delete the files from the XppIL folder. Note: files only not sub folders.
Restart the AOS
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

I have the same question (0)

All responses (8)

Answers (0)

Basheer17 2,720 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Martin Dráb 237,976 Most Valuable Professional on at

Like (0)

Report

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,

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
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?

Was this reply helpful? Yes No
Mea_ 60,284 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Martin Dráb 237,976 Most Valuable Professional on at

Like (0)

Report

Also make sure you stop all AOS services.

Was this reply helpful? Yes No
Suggested answer

Vilmos Kintera 46,149 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Muthusamy 4 on at

Like (0)

Report

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,

Was this reply helpful? Yes No