Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) The transaction log fo...

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

All responses (5)

Answers (3)

Akbarpasha on at

Like (1)

Report

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

Hi ievgen,

Thank you, i have marked.
Verified answer

Mea_ 60,278 on at

Like (0)

Report

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

Hi Akbarpasha,

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

Like (0)

Report

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

Hi ievgen/Nikolaos,

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

nmaenpaa 101,156 on at

Like (0)

Report

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

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

Mea_ 60,278 on at

Like (0)

Report

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

Hi Akbarpasha,

Increase size of the log file for MicrosoftDynamicsAX_model data base.