Post reply

MD: database_id = 1 INVALID(INVALID)

  • March 7, 2016 at 5:01 am

    #311876

    Hi All,

    I have a process that runs large batch operations from a Navision application server that seem to run forever. On closer inspections (exec stats) I find a lot of the above waiting resources while executing? Can anyone explain what "MD: database_id = 1 INVALID(INVALID)" means?

    Kind regards

  • March 29, 2016 at 12:11 pm

    #1868367

    do you see any errors on the SQL Server logs?

  • April 1, 2016 at 3:55 am

    #1869086

    I have never seen that message in SQL before... reminds me of Oracle syntax.

  • April 1, 2016 at 6:58 am

    #1869134

    Resources labeled MD are for metadata. I've seen blocking around those before, but not with that INVALID (INVALID) description.

    Exactly what code were you running that returned that description for the resource?

    Cheers!

  • April 4, 2016 at 3:30 am

    #1869427

    Hi All,

    Thanks for your replies.

    This is a MS Dynamics Navision database server. The problem specifically occurs on an Average Costing run. There are no other errors in the log file.

    Kind regards

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply