Unified Operations & Dynamics AX Forum

Expand all | Collapse all

unusual error when creating schema using Axuil

  • 1.  unusual error when creating schema using Axuil

    Posted 14 days ago
    We were doing a release tonight and got a strange error when attempting to create a schema in preparation for importing a model store,

    ERROR: The instance of the SQL Server Database Engine cannot obtain a LOCK resource at this time. Rerun your statement when there are fewer active users. Ask the database administrator to check the lock and memory configuration for this instance, or to check for long-running transactions.

    ran the procedure sp_lock and there are locks on databases other than model store.  What is a good way to release these locks or set to a higher threshold so we can proceed?

    Thanks,

    ------------------------------
    Rich Wasson
    Senior Developer
    Affinity Specialty Apparel, Inc.
    West Chester OH
    ------------------------------


  • 2.  RE: unusual error when creating schema using Axuil

    Posted 12 days ago
    The reason we ran into this issue appears to be that the max degree of parallelism for some reason was set to 32.  The AX install guide of course states that this should be set to 1.  Once this was done, the issue appears to have gone away.

    ------------------------------
    Rich Wasson
    Senior Developer
    Affinity Specialty Apparel, Inc.
    West Chester OH
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role