Open Forum

SQL Server Message 515

  • 1.  SQL Server Message 515

    GOLD CONTRIBUTOR
    Posted Jul 01, 2019 01:04 PM
      |   view attached
    Boy when it rains it pours...

    Anyone get this error message before?
    Balance type in the batch and gltran tables are 'A'


    ------------------------------
    Karla Johnson
    System Architect
    Schneider Electric
    Carrollton TX
    ------------------------------


  • 2.  RE: SQL Server Message 515

    GOLD CONTRIBUTOR
    Posted Jul 01, 2019 02:23 PM
    I would first look for a GLTran row that has a bad or missing LedgerID value:

    SELECT LedgerID, *
    FROM dbo.GLTran AS t
    WHERE NOT EXISTS
    (SELECT *
     FROM dbo.Ledger
     WHERE LedgerID = t.LedgerID);


    ------------------------------
    Jonathan Van Houtte
    Architect
    XLstatements, LLC
    Clifton Park NY
    ------------------------------



  • 3.  RE: SQL Server Message 515

    GOLD CONTRIBUTOR
    Posted Jul 01, 2019 03:00 PM
    That is correct Jonathan!  Thanks!
    I was looking for everything BUT ledgerID.

    ------------------------------
    Karla Johnson
    System Architect
    Schneider Electric IT Mission Critical Services, Inc
    Carrollton TX
    ------------------------------