Sage 100

 View Only

  • 1.  error 15 so_salesorderprinting_rpt.pvc Line 747

    Posted 03-22-2022 15:13

    Trying to print a sales order form - the Standard, unaltered one - and receive this error.  The Sage KB article says it is because the SQL table allows nulls.  This client is on 2021 premium.

    Is there a command at debug that someone can give me to tell me which field it is bombing on?  I do not want to uncheck Allow Nulls on all fields in the SQL DB for SO Header and SO Detail!



    ------------------------------
    Jane Scanlan
    Partner
    Next Level Manufacturing Consulting Group
    ------------------------------


  • 2.  RE: error 15 so_salesorderprinting_rpt.pvc Line 747

    Posted 03-22-2022 15:21
    That KB article actually references a different line number (597), and was supposedly resolved in 2016.3 and 2017.  Does it only error on one (or just a few) orders?  If so, examine those orders in SQL Manager and see if any fields are null that shouldn't be.

    ------------------------------
    Phil McIntosh
    President
    Friendly Systems, Inc.
    ------------------------------



  • 3.  RE: error 15 so_salesorderprinting_rpt.pvc Line 747

    Posted 03-22-2022 16:34
    If it is Sage 2021.2, then line 747 is trying to write to the workfile.

    Lee

    ------------------------------
    Lee Graham
    Friendly Systems, Inc.
    ------------------------------



  • 4.  RE: error 15 so_salesorderprinting_rpt.pvc Line 747

    Posted 03-22-2022 16:40
    Jane - Since it's an Error 15 click on Debug and type one of the following to get the SQL error:

    ? MSG(-1)
    or
    CLIP_BOARD WRITE MSG(-1)  ! Now paste or Ctrl-V into Notepad or email

    Like Lee said it's writing to the worktable but in this case that would be the one in TempDB.

    ------------------------------
    Alnoor Cassim

    Email: alnoor@asifocus.com
    Ph:
    ------------------------------

    Original Message


  • 5.  RE: error 15 so_salesorderprinting_rpt.pvc Line 747

    Posted 03-22-2022 16:41
    If you increased the field size of a source data UDF, make sure to do the same with linked work table UDF's.  SQL column settings are linked to the UDF mask / field size.

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    ------------------------------



  • 6.  RE: error 15 so_salesorderprinting_rpt.pvc Line 747

    Posted 03-22-2022 18:32
    This is one of those Sage Advanced to SQL things -- where Providex doesn't care so much about masking that you set in a numeric UDF, but SQL does.  I found the culprit UDF and changed the numeric mask to the normal size.  

    Just love how this type of thing isn't a problem in Sage Advanced/Providex but becomes a problem in SQL.  Oh well.

    ------------------------------
    Jane Scanlan
    Partner
    Next Level Manufacturing Consulting Group
    ------------------------------

    Original Message


  • 7.  RE: error 15 so_salesorderprinting_rpt.pvc Line 747

    Posted 03-22-2022 18:39
    This is part of the "cost" of never having to Rebuild Key Files in Premium (which is a huge gain)... but it would be nice if the error messages were more friendly though.

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    ------------------------------

    Original Message


Related Content