Sage 100

 View Only
  • 1.  MAS200 SQL v4.5 is randomly ""forgetting"" companies

    Posted 07-16-2013 14:26
    MAS200 SQL v4.5 is randomly ""forgetting"" companies exist. The MAS_xxx folder is still in place, and when the customer re-creates the company MAS states the db is already there and ""do you want to use it"". But why are the companies just randomly disapearing? This happened with several companies over the weekend and some additional companies about a month ago. (Additional info: Customer moved the db on the SQL server to a different drive on the same server toward the end of June.)


  • 2.  RE: MAS200 SQL v4.5 is randomly ""forgetting"" companies

    Posted 07-16-2013 15:31
    What is the symptom for SQL not thinking the company exists? When this occurs, does company exist in SY_Company?


  • 3.  RE: MAS200 SQL v4.5 is randomly ""forgetting"" companies

    Posted 07-16-2013 17:42
    Are new companies being added? Every new company removing an older company? And users too?


  • 4.  RE: MAS200 SQL v4.5 is randomly ""forgetting"" companies

    Posted 07-16-2013 18:31
    It is happening when users try to switch companies. The companies have all been recreated/reactivated, so I am not sure if it was in the company listing prior to them restoring them. I think we are on hold until it happens again.