The transaction log for database 'MicrosoftDynamicsAX_model' is full due to 'ACTIVE_TRANSACTION' , getting this error while importing modelstore

(0) Share

Report

Posted on by Akbarpasha

Hi All,

We are getting the below error while importing the model store in Dev environment, we have stopped the AOS service and trying to import the model store.

Import-AXModelStore : The pipeline has been stopped.
At line:1 char:1
+ Import-AXModelStore -File "D:\temp\Prod_modelstore_10092018.axmodelst ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : OperationStopped: (:) [Import-AXModelStore], PipelineStoppedException
+ FullyQualifiedErrorId : The transaction log for database 'MicrosoftDynamicsAX_model' is full due to 'ACTIVE_TRANSACTION'.,Microsoft.Dynamics.AX.
Framework.Tools.ModelManagement.PowerShell.ImportStoreCommand

Kindly advise us how to proceed.

Regards,

Akbar

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (3)

Verified answer

Mea_ 60,284 on at

Like (0)

Report

Hi Akbarpasha,

Increase size of the log file for MicrosoftDynamicsAX_model data base.

Was this reply helpful? Yes No
Verified answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

You can also consider changing the recovery mode of your model database to Simple. If you backup your model database before importing new modelstore, you always have the option to roll back, without needing to have Full recovery mode set up for the database.

Was this reply helpful? Yes No
Akbarpasha on at

Like (0)

Report

Hi ievgen/Nikolaos,

We have increased the size of log file and able to import the model store properly.
Thank you all.

Was this reply helpful? Yes No
Verified answer

Mea_ 60,284 on at

Like (0)

Report

Hi Akbarpasha,

If you issue is solved please mark answer(s) that helped you as verified to close the thread.

Was this reply helpful? Yes No
Akbarpasha on at

Like (1)

Report

Hi ievgen,

Thank you, i have marked.

Was this reply helpful? Yes No