Open Forum

Expand all | Collapse all

Autoincrement Serial Number Item Entries

  • 1.  Autoincrement Serial Number Item Entries

    SILVER CONTRIBUTOR
    Posted 14 days ago
      |   view attached
    Hi,
    In order to prevent blocking on Tables we decided to use autoincrement for the table with Item Entries.
    This table contains millions of records.
    When importing the fob from TEST to the Production we received an SQL time out error.
    Does anyone have experience with this error?


    ------------------------------
    Annette van der Muur
    Application Manager
    Hal Leonard
    The Netherlands
    ------------------------------

    Attachment(s)

    docx
    Error.docx   496K 1 version


  • 2.  RE: Autoincrement Serial Number Item Entries

    TOP CONTRIBUTOR
    Posted 13 days ago
    Edited by Geovanny Fuentes 11 days ago

    Many factors to discuss here.
    But let's start simple:

    Just importing cause the issue? Was it during off hours? Did you stop/start the service connections again including any Job queue you have?
    Have you tested it in your TEST DB with actual simulation of users where you were getting issues?
    Do you currently have a TIMEOUT session as this may need to take a while to compile/update keys etc that will get disconnected?

    Good luck.



    ------------------------------
    Geovanny Fuentes
    San Diego CA
    ------------------------------