Open Forum

Expand all | Collapse all

Autoincrement Serial Number Item Entries

  • 1.  Autoincrement Serial Number Item Entries

    Posted Dec 04, 2018 09:50 AM
      |   view attached
    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


    Error.docx   496K 1 version

  • 2.  RE: Autoincrement Serial Number Item Entries

    Posted Dec 05, 2018 12:35 PM
    Edited by Geovanny Fuentes Dec 06, 2018 06:37 PM

    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

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