Installation and Technical Issues

[s2pursuit]

Hello,

I am new to MAS500.  We are using Sage MAS 500 February 2010 Update (Version 7.30.2.0)

A user just discovered a report, based on a view, that does not return accurate records.  It does not appear that views vsmUserCompanyGrp and vdvUserTaskList reflect the same data as shown in the tables. 

Table tsmUsercompanyGrp shows accurate data.

Does anyone know why this would happen or how to fix? 

Possibly related...our development db errors out when trying to view the data in the same views.  It appears to be trying to reference an object in the production environment.

Thank You,

Chris

[JohnHanrahan]

Sounds like you've had someone modifying the standard code.  One way to fix is to install a new database.  Script the objects from there and put in your database.  Make sure you back up everything before doing this.  And I am totally serious about someone modifying something, good chance of that.

J

[s2pursuit]

Thanks John.  I think I have identified the issue.  Not sure why, but the view points to a _sys database instead of the _app database.  The _app db has the correct data, the _sys does not appear to be updating.

[LouDavis · Accepted solution]

The _sys database is from an older version of MAS 500 and is no longer used in MAS 500 7.3.  As you have discovered, the view was moved to the _app database during a past upgrade of your system.

[s2pursuit]

Thank you Lou. That would explain it. It also explains why there are errors in our dev db, as the dev db does not have the _sys data.