Sage 100

 View Only
Expand all | Collapse all

Have a client getting error 47 substring reference

  • 1.  Have a client getting error 47 substring reference

    Posted 01-22-2018 13:04
    Have a client getting error 47 substring reference out of string program WOWSDA When trying to enter a new employee in Production Employee Maintenance. Couldn't find any think on KB or Sage City with this error in WO I can only find the error occurring when opening Sage. Anyone see this in WO before?


  • 2.  RE: Have a client getting error 47 substring reference

    Posted 01-22-2018 13:06
    Alicia, do they have Jobops or Manufacturing if so custom office update forms to current level. (i just did this myself)


  • 3.  RE: Have a client getting error 47 substring reference

    Posted 01-22-2018 13:32
    Thanks they do have Manufacturing , I will try it.


  • 4.  RE: Have a client getting error 47 substring reference

    Posted 01-22-2018 13:55
    Alicia, if jeremy's suggestion doesn't resolve the error, send me the program from your client and let me know the line number of the error in the DEBUG screen. I will be able to track it down for you.


  • 5.  RE: Have a client getting error 47 substring reference

    Posted 01-23-2018 08:00
    The Sage version and program error line # would help track this.


  • 6.  RE: Have a client getting error 47 substring reference

    Posted 01-23-2018 08:28
    The version is Sage Adv. 2016 5.30.3.0 and the error line is #7860 thanks


  • 7.  RE: Have a client getting error 47 substring reference

    Posted 01-23-2018 08:38
    Alicia, I don't have 2016 loaded but have a 2017 version and I'm not seeing a line 7860 in WOWSDA. I even looked at v4.50. This is why I need your client's version of the program to verify. Thanks.


  • 8.  RE: Have a client getting error 47 substring reference

    Posted 01-23-2018 08:52
    That area of the program is assigning values from the Production Employee File (WOG) to the screen variables (Employee #, name, etc). From Debug, Type: ? WOG$ to see the employee rec involved. Then type: BYE to exit. You can use DFDM on WOGccc file to see how that emp rec differs from the others.


  • 9.  RE: Have a client getting error 47 substring reference

    Posted 01-23-2018 09:19
    If your ""new"" employee rec is already in the WOGccc file, either the string portion of their rec is short, or some MFG changes are affecting it and expecting more data.


  • 10.  RE: Have a client getting error 47 substring reference

    Posted 01-23-2018 09:34
    yes the record that show in the debug is the new record trying to be added when getting the error


  • 11.  RE: Have a client getting error 47 substring reference

    Posted 01-23-2018 10:03
    Sounds like a modified program isn't working.


  • 12.  RE: Have a client getting error 47 substring reference

    Posted 01-23-2018 10:09
    yes I just found if I go to customizer selection I get the following error if I try to click on WO Error #11: Record not found or Duplicate key on write Program CM_SELECTOR_UI.pvc Loine 832


  • 13.  RE: Have a client getting error 47 substring reference

    Posted 01-23-2018 11:25
    Any recent installs or upgrades?