Sage 100

 View Only
  • 1.  Error 117 SY_Session.pvc Statement 5398 occurs af

    Posted 07-10-2012 11:53
    Error 117 SY_Session.pvc Statement 5398 occurs after user enters logon name and password to MAS 90. I have tried renaming the SY_Workstation file and that does not work. Ideas? This particular error message is not logged on Sage's site.


  • 2.  RE: Error 117 SY_Session.pvc Statement 5398 occurs af

    Posted 07-10-2012 12:01
    Is it all workstations/users?


  • 3.  RE: Error 117 SY_Session.pvc Statement 5398 occurs af

    Posted 07-10-2012 12:03
    Yes, all of them.


  • 4.  RE: Error 117 SY_Session.pvc Statement 5398 occurs af

    Posted 07-10-2012 12:05
    This is all I can find. Did the Sy_workstation.m4t file get recreated after renaming it? Is it 90 or 200? http://infosource.sagesoftwareonline.com/sw_attach/kdb.asp?isresolutionconceptid=528429


  • 5.  RE: Error 117 SY_Session.pvc Statement 5398 occurs af

    Posted 07-10-2012 12:15
    The statement number is different in the Sage link you gave me. I know it is close, but I actually think it has to do with the System Activity Log files ... they are up to .004. I'm reinstalling software now.


  • 6.  RE: Error 117 SY_Session.pvc Statement 5398 occurs af

    Posted 07-12-2012 14:36
    I think the problem had to do with a corrupt SY_ActivityLog file ... they were up to .004 as VI jobs write to this table, which seems like a waste ... why does it write out each record that it imports? I renamed all the SY_ActivityLog files as well as the SY_workstation ile, reinstalled the software and my problem was cured.


  • 7.  RE: Error 117 SY_Session.pvc Statement 5398 occurs af

    Posted 07-12-2012 17:27
    We find that if the SY_ActivityLog grows too big, it can cause all sorts of issues. Yours sounded massive!


  • 8.  RE: Error 117 SY_Session.pvc Statement 5398 occurs af

    Posted 07-12-2012 18:38
    Thanks Dawn. It is good to hear a confirmation of what I thought about that file.