Lesson Monitor Error

[Gatt]

Ok, not been in school today, but just checked email and got a load of emails about Lesson Monitor.

 

Someone was kind enough to give me the attached screendump

 

Any ideas?

 

At first glance I'd say an error with the cached Access DB file - but with multiple errors it's more likely to be at the server.

[MkII]

Is it related to the October update?

 

Some problems related on the capitaes forums suggest this version adds an intolerance of overlapping / duplicate timetable entries. Specifically effecting sims logons, lesson monitor and registration.

[Gatt]

Not been informed from the LEA about any updates being applied, and usually updates never go in smoothly either, and no mention of upgrade failures - will find more out tomorrow.

[barryfl]

Hmm we have big issues with LM since the last upgrade, seeing similar errors not this one I don't think. We worked around it by killing the LM process, deleting the LessonMonitor.MDB and TempTables.Mdb then re-launching LM

 

Might help, Might not but thats my 2 pence

 

Regards,

 

Barry

[Gatt]

Will give that a bash and see what happens.. though going round 100 PC's and manually deleting the files will be a ball-ache !!

[barryfl]

Will give that a bash and see what happens.. though going round 100 PC's and manually deleting the files will be a ball-ache !!

 

Welcome to my world.

[mac_shinobi]

deletion of the local mdb file does the trick for the most part for us, if not then its because of permissions ( there is a security exe that we run which we only found out about recently ) that fixes all the permissions to how they need or want it.

 

But deleting the local mdb should do the trick obviously whilst lm or sims isnt running

[Gatt]

Wouldn't be so bad if I had direct management over the staff network - but the LEA wont let me do that

[mattpant]

I would say 95% of problems with Lesson Monitor are due to the local Access Database file becoming somewhat corrupt.

 

I have added a line to our staff logon script that deletes the local database everytime they logon to the system.

 

That seems to have cured 95% of the problems!!!!!! :-)

 

Regards,

 

Matt

[mac_shinobi]

Now for the other 5% which is pebkac aka user error lol and then some lol

[Gatt]

I have added a line to our staff logon script that deletes the local database everytime they logon to the system.

If only I could do a simple thing like that

[kingswood]

Staff can delete the local database file using the tools menu (IIRC)- but only if you can get access to the blasted thing. We delete the local LessonMonitor DB file and then relaunch the module. This makes it rebuild the DB locally and then it should synchronise properly.

 

As Shane has said- there is an issue (for us) with permissions, but the two problems aren't necessarily related. You can get the DB corruption just from someone turning the machine off with SIMS still running. Not that staff do that sort of thing. No precious. We wants them not to- don'ts us.

 

:-)

[Gatt]

Staff can delete the local database file...

The last thing I'm going to do is tell them to manually delete the DB file!! Knowing this shower of they'll delete the wrong bloody file then blame me!!

 

Its hard enough to get them to run the Batch File i created for them to simplify it....

 

Me: Double click the file on the J Drive called lmfix.bat

Teacher: I dont know how to do that

Me: !!

[kingswood]

LOL.

 

Yeah- I can understand the hesitation. But it isn't like they are navigating to the C: directory from whence it lives and then just deleting it. They can- if LM is alive and well- simply go to the tools menu and choose (by themselves) to delete local access database. Voila! DB gone. Then when they reopen the application it is recreated.

 

If it were that easy I would tell them to do it. Normally LM bombs out with DB errors so they can't actually do it. So we go round and delete the local DB file manually (and by our lonesomes) so that the system can get back to...normality?

 

I understand though. I hear hammers work wonders....

[Gatt]

Typical - Salford just been on the phone as i'd asked if they could add the LM deletion script to all staff logins here

 

Salford's response - Oh i dont think we can do that..

 

Argh!! Now I'll need to go round all Pc's and add it to everyone's startup folder