Vipers
30-01-2003, 14:37
we have goldmine running on SQL server 2000.
we also have a bespoke piece of vb software that looks at this goldmine database.
we have about 20 users on goldmine, and about 5 that are constantly using the bespoke software.
when 1 of the users leaves goldmine open (doing nothing) and the bespoke software (also doing nothing). for a period of time ( i need to determine how long) it creates a block on sql server, and blocks 2 particular users. then inturn those two users then block the other 17 users.
i have only recently boiled it down to being this particular user leaving those 2 programs open. and have been told now that i know where its coming from i need to get it sorted very quikly, i understand this and agree, but how? has anyone had a similar problem??
for the now i suggested to the "accused" user to turn off those 2 applications when not using them, she said no way not a chance blah blah, so i stopped listening and said fine.
so because of her arkwardness to not do this till i get it fixed, if it happens again shes going to cost the company money, iun the following ways.
for arguments sake it creates this blocks for 10 mins in total for each user, this will cost the company 200mins of working time 3 .3 hrs!! also me the time and effort to unblock them and because i am unblocking them, it means i am not using that time to fix the problem. which means its costing me double the time and effort. also the other users. and 3 of the users are in credit control so if goldmine is hanging due to theis problem credit control may get a phone call where if they had the info they could get in £2000. also affects accounts cuz if it blocks and therefore hangs goldmine then sometimes manages to crash the computer if they're processing a sale or posting etc, then it will require me to unlock that user form accounts package, and more than likely have to restore the accounts database from backup cuz if that crashes while posting or invoicing it corrupts the database for the accounts.
also in affect cuz that effect 3.3hrs no work is being done, it will be done later so costs the company double the time, 6.6 company hours are lost plus all the time it costs me.
we also have a bespoke piece of vb software that looks at this goldmine database.
we have about 20 users on goldmine, and about 5 that are constantly using the bespoke software.
when 1 of the users leaves goldmine open (doing nothing) and the bespoke software (also doing nothing). for a period of time ( i need to determine how long) it creates a block on sql server, and blocks 2 particular users. then inturn those two users then block the other 17 users.
i have only recently boiled it down to being this particular user leaving those 2 programs open. and have been told now that i know where its coming from i need to get it sorted very quikly, i understand this and agree, but how? has anyone had a similar problem??
for the now i suggested to the "accused" user to turn off those 2 applications when not using them, she said no way not a chance blah blah, so i stopped listening and said fine.
so because of her arkwardness to not do this till i get it fixed, if it happens again shes going to cost the company money, iun the following ways.
for arguments sake it creates this blocks for 10 mins in total for each user, this will cost the company 200mins of working time 3 .3 hrs!! also me the time and effort to unblock them and because i am unblocking them, it means i am not using that time to fix the problem. which means its costing me double the time and effort. also the other users. and 3 of the users are in credit control so if goldmine is hanging due to theis problem credit control may get a phone call where if they had the info they could get in £2000. also affects accounts cuz if it blocks and therefore hangs goldmine then sometimes manages to crash the computer if they're processing a sale or posting etc, then it will require me to unlock that user form accounts package, and more than likely have to restore the accounts database from backup cuz if that crashes while posting or invoicing it corrupts the database for the accounts.
also in affect cuz that effect 3.3hrs no work is being done, it will be done later so costs the company double the time, 6.6 company hours are lost plus all the time it costs me.