"Program cannot set property into main Storage"...

Avast Free Antivirus / Premium Security
1

Hi everybody

I’ve been using Avast Home Edition flawlessly in my Win 98 SE PC for quite some time…

After a couple of days using version 4.7.844 (automatic update), I received an error message today, while I was working. It stated that there was some unexpected error and asked whether I wanted to send a report to the Avast team or not… I was quite busy, so I chose “cancel”. :slight_smile:

After that the whole Avast program shut off (residents and all), so I decided to reboot.

Everything came back ok (the resident protection, etc.), but when I tried to open the main client, I got this pop-up:

“The process can’t access the file because it’s already…” (I guess it’s close to that… It was in portuguese, and the phrase was cut-off. :slight_smile:

Below it read:

“Program cannot set property into main Storage”

In order to bypass this pop-up at the splash screen, I had to resort to the win 98 Task Manager… After I terminate the “splash screen”, the client opens normaly (but it skips, of course, the memory check).

In the error message there’s also a link to a troubleshooting topic (install ODBC again or change the database to XML in the .ini file), but it wasn’t helful, as I did some research and found out that neither ODBC nor XML are used anymore in versions 4.7 and up…

The “error log” showed a lot of variations of this:

Storage query “INSERT INTO LocalProperties (Object, Property, Val) VALUES (1121051540, ‘ScanAreas’, ‘QuickStartupMem’);” failed. Error description: “database is locked”.

I guess this is it! The resident protection is working, or so it seems, but I can’t open the main client!

Any ideas on how to fix this (other than reinstallling) ?

Thanks in advance

Leonardo

2

Yes… since version 4.7.807 a new data storage called SQLT is used by avast!

Maybe the Jet drivers (MDAC package) of Microsoft could help (http://www.microsoft.com/data).
Or the MDAC Utility: Component Checker: http://www.microsoft.com/downloads/details.aspx?FamilyId=8F0A8DF6-4A21-4B43-BF53-14332EF092C9&displaylang=en
There’s also an MDAC/Jet repair tool… http://www.macropool.com/en/download/mdac.html#Repair

Repairing your installation through Control Panel does not help?

3

Hi Tech

I already reinstalled the ODBC package and tried to repair the Avast installation through the Control Panel, both to no avail!

The “Program cannot set property into main Storage” error pop-up is still there!

Leonardo

4

Hi again

I was reading back the whole thing, and I guess there’s some important info in the log entry:

Storage query “INSERT INTO LocalProperties (Object, Property, Val) VALUES (1121051540, ‘ScanAreas’, ‘QuickStartupMem’);” failed. Error description: “database is locked”.

Any ideas?

Thanks

Leonardo

5

Leo, I have an ‘idea’…
The database could be avast4.mdb file into the \data folder.
If there is a temporary file that locks it and it is not deleted after using the file (maybe a power failure, etc.), the file is set as ‘being used’ when in fact it’s not. ::slight_smile:

6

Hi Tech

I’ve just run some tests and you’re right!

But the database that is causing the error is avast4.db and not avast4.mdb!

I booted in safe mode, renamed avast4.db to avast4.old and then rebooted.

The good news is that the “Program cannot set property into main Storage” error message didn’t appear and the memory scan was performed as usual!

The bad news is that the resident protection no longer works (it’s disabled and can’t be restarted). I guess the needed information was in the (now) avast4.old!

Any workaround to this?

Thanks

Leonardo

7

Is there anything relevant in the file \data\error.log?

8

Hi Vlk

The situation now is the following… :slight_smile:

If I use the “original” avast4.db (50k):

  • the “Program cannot set property into main Storage” error occurs
  • entry in the error log as follows: Storage query “INSERT INTO LocalProperties (Object, Property, Val) VALUES (1121051540, ‘ScanAreas’, ‘QuickStartupMem’);” failed. Error description: “database is locked”
  • the resident protection still works perfectly.

If I rename the “original” avast4.db to something else and let the program create a new one at reboot (13k):

  • the “Program cannot set property into main Storage” will not occur
  • no entry at the error log
  • the resident protection will be disabled and can’t be restart (error: providers can’t be found)

I wouldn’t want to have to choose between opening the client or having the resident protection running! :slight_smile:

Thanks

Leonardo

9

You’re right… that file must be there in order to avast work properly…
Leo, please, check in the file that Vlk posted the way to see what’s happening. Post the error.log content here.

10

Database is locked, hmm, interesting, indeed…
I really wonder what might be causing this

11

Access rights ::slight_smile: ???

12

Tech, this is Win98… :stuck_out_tongue:

13

Hi Vlk

I don’t know if I should feel proud or scared! :smiley:

What I really don’t get is why the avast4.db database is in use by the resident protection and locked to the main client!

Leonardo

14

Good old times ;D
Well, I was thinking in read only file (atributes) or registry locking (I thought MS Access could lock the database even in Windows 98)… ::slight_smile:

15

Hi Tech

I just checked and the avast4.db file is not set as “read only”… And it’s dated 02/06/06 17:50, so the resident protection (which is working perfectly) has been able to change it without a problem.

Here’s the error.log as requested (I received the Avast error message between 02/06/06 11:12 and 02/06/06 11:19):

02/06/06 11:12:58 1149257578 usuario 4292917831 AAVM - scanning error: Aavm: FetchGlobalCounters cannot open mapping - server DOWN???, 0000007B.
02/06/06 11:12:58 1149257578 usuario 4292917831 AAVM - scanning error: Aavm: FetchGlobalCounters cannot open mapping - server DOWN???, 0000007B.
02/06/06 11:12:59 1149257579 usuario 4292917831 AAVM - scanning error: Aavm: FetchGlobalCounters cannot open mapping - server DOWN???, 0000007B.
02/06/06 11:19:10 1149257950 usuario 4293140251 Storage query “INSERT INTO LocalProperties (Object, Property, Val) VALUES (1121051540, ‘ScanAreas’, ‘QuickStartupMem’);” failed. Error description: “database is locked”.
02/06/06 11:21:10 1149258070 usuario 4293519067 Storage query “INSERT INTO LocalProperties (Object, Property, Val) VALUES (1833544834, ‘ScanPackers’, ‘All’);” failed. Error description: “database is locked”.
02/06/06 11:21:10 1149258070 usuario 4293519067 Storage query “INSERT INTO LocalProperties (Object, Property, Val) VALUES (1833544834, ‘ScanType’, ‘Extensions’);” failed. Error description: “database is locked”.
02/06/06 11:21:10 1149258070 usuario 4293519067 Storage query “INSERT INTO LocalProperties (Object, Property, Val) VALUES (1833544834, ‘ScanTypes’, ‘Default’);” failed. Error description: “database is locked”.
02/06/06 11:21:10 1149258070 usuario 4293519067 Storage query “INSERT INTO LocalProperties (Object, Property, Val) VALUES (1833544834, ‘ScanFor’, ‘Standard;Polymorphic;Macro’);” failed. Error description: “database is locked”.
02/06/06 11:21:10 1149258070 usuario 4293519067 Storage query “INSERT INTO LocalProperties (Object, Property, Val) VALUES (1833544834, ‘ScanFullFiles’, ‘0’);” failed. Error description: “database is locked”.
02/06/06 11:21:10 1149258070 usuario 4293519067 Storage query “INSERT INTO LocalProperties (Object, Property, Val) VALUES (1833544834, ‘ScanIgnoreTargeting’, ‘0’);” failed. Error description: “database is locked”.
02/06/06 11:21:23 1149258083 usuario 4293140251 Storage query “INSERT INTO LocalProperties (Object, Property, Val) VALUES (1121051540, ‘ScanAreas’, ‘QuickStartupMem’);” failed. Error description: “database is locked”.
02/06/06 11:23:37 1149258217 usuario 4293235271 Storage query “INSERT INTO LocalProperties (Object, Property, Val) VALUES (1833544834, ‘ScanPackers’, ‘All’);” failed. Error description: “database is locked”.
02/06/06 11:23:37 1149258217 usuario 4293235271 Storage query “INSERT INTO LocalProperties (Object, Property, Val) VALUES (1833544834, ‘ScanType’, ‘Extensions’);” failed. Error description: “database is locked”.
02/06/06 11:23:37 1149258217 usuario 4293235271 Storage query “INSERT INTO LocalProperties (Object, Property, Val) VALUES (1833544834, ‘ScanTypes’, ‘Default’);” failed. Error description: “database is locked”.
02/06/06 11:23:37 1149258217 usuario 4293235271 Storage query “INSERT INTO LocalProperties (Object, Property, Val) VALUES (1833544834, ‘ScanFor’, ‘Standard;Polymorphic;Macro’);” failed. Error description: “database is locked”.
02/06/06 11:23:37 1149258217 usuario 4293235271 Storage query “INSERT INTO LocalProperties (Object, Property, Val) VALUES (1833544834, ‘ScanFullFiles’, ‘0’);” failed. Error description: “database is locked”.
02/06/06 11:23:37 1149258217 usuario 4293235271 Storage query “INSERT INTO LocalProperties (Object, Property, Val) VALUES (1833544834, ‘ScanIgnoreTargeting’, ‘0’);” failed. Error description: “database is locked”.
02/06/06 11:29:35 1149258575 usuario 4292893647 Storage query “INSERT INTO LocalProperties (Object, Property, Val) VALUES (1121051540, ‘ScanAreas’, ‘QuickStartupMem’);” failed. Error description: “database is locked”.
02/06/06 11:32:56 1149258776 usuario 4293428583 Storage query “INSERT INTO LocalProperties (Object, Property, Val) VALUES (1833544834, ‘ScanPackers’, ‘All’);” failed. Error description: “database is locked”.
02/06/06 11:32:56 1149258776 usuario 4293428583 Storage query “INSERT INTO LocalProperties (Object, Property, Val) VALUES (1833544834, ‘ScanType’, ‘Extensions’);” failed. Error description: “database is locked”.
02/06/06 11:32:56 1149258776 usuario 4293428583 Storage query “INSERT INTO LocalProperties (Object, Property, Val) VALUES (1833544834, ‘ScanTypes’, ‘Default’);” failed. Error description: “database is locked”.
02/06/06 11:32:56 1149258776 usuario 4293428583 Storage query “INSERT INTO LocalProperties (Object, Property, Val) VALUES (1833544834, ‘ScanFor’, ‘Standard;Polymorphic;Macro’);” failed. Error description: “database is locked”.
02/06/06 11:32:56 1149258776 usuario 4293428583 Storage query “INSERT INTO LocalProperties (Object, Property, Val) VALUES (1833544834, ‘ScanFullFiles’, ‘0’);” failed. Error description: “database is locked”.
02/06/06 11:32:56 1149258776 usuario 4293428583 Storage query “INSERT INTO LocalProperties (Object, Property, Val) VALUES (1833544834, ‘ScanIgnoreTargeting’, ‘0’);” failed. Error description: “database is locked”.
02/06/06 11:40:58 1149259258 usuario 4293280723 Storage query “INSERT INTO LocalProperties (Object, Property, Val) VALUES (1121051540, ‘ScanAreas’, ‘QuickStartupMem’);” failed. Error description: “database is locked”.
02/06/06 11:41:42 1149259302 usuario 4293415803 Storage query “INSERT INTO LocalProperties (Object, Property, Val) VALUES (1833544834, ‘ScanPackers’, ‘All’);” failed. Error description: “database is locked”.
02/06/06 11:41:42 1149259302 usuario 4293415803 Storage query “INSERT INTO LocalProperties (Object, Property, Val) VALUES (1833544834, ‘ScanType’, ‘Extensions’);” failed. Error description: “database is locked”.
02/06/06 11:41:42 1149259302 usuario 4293415803 Storage query “INSERT INTO LocalProperties (Object, Property, Val) VALUES (1833544834, ‘ScanTypes’, ‘Default’);” failed. Error description: “database is locked”.
02/06/06 11:41:42 1149259302 usuario 4293415803 Storage query “INSERT INTO LocalProperties (Object, Property, Val) VALUES (1833544834, ‘ScanFor’, ‘Standard;Polymorphic;Macro’);” failed. Error description: “database is locked”.
02/06/06 11:41:42 1149259302 usuario 4293415803 Storage query “INSERT INTO LocalProperties (Object, Property, Val) VALUES (1833544834, ‘ScanFullFiles’, ‘0’);” failed. Error description: “database is locked”.
02/06/06 11:41:42 1149259302 usuario 4293415803 Storage query “INSERT INTO LocalProperties (Object, Property, Val) VALUES (1833544834, ‘ScanIgnoreTargeting’, ‘0’);” failed. Error description: “database is locked”.
02/06/06 11:41:47 1149259307 usuario 4293280723 Storage query “INSERT INTO LocalProperties (Object, Property, Val) VALUES (1121051540, ‘ScanAreas’, ‘QuickStartupMem’);” failed. Error description: “database is locked”.
02/06/06 11:42:10 1149259330 usuario 4293350791 Storage query “INSERT INTO LocalProperties (Object, Property, Val) VALUES (1833544834, ‘ScanPackers’, ‘All’);” failed. Error description: “database is locked”.
02/06/06 11:42:10 1149259330 usuario 4293350791 Storage query “INSERT INTO LocalProperties (Object, Property, Val) VALUES (1833544834, ‘ScanType’, ‘Extensions’);” failed. Error description: “database is locked”.
02/06/06 11:42:10 1149259330 usuario 4293350791 Storage query “INSERT INTO LocalProperties (Object, Property, Val) VALUES (1833544834, ‘ScanTypes’, ‘Default’);” failed. Error description: “database is locked”.
02/06/06 11:42:10 1149259330 usuario 4293350791 Storage query “INSERT INTO LocalProperties (Object, Property, Val) VALUES (1833544834, ‘ScanFor’, ‘Standard;Polymorphic;Macro’);” failed. Error description: “database is locked”.
02/06/06 11:42:10 1149259330 usuario 4293350791 Storage query “INSERT INTO LocalProperties (Object, Property, Val) VALUES (1833544834, ‘ScanFullFiles’, ‘0’);” failed. Error description: “database is locked”.
02/06/06 11:42:10 1149259330 usuario 4293350791 Storage query “INSERT INTO LocalProperties (Object, Property, Val) VALUES (1833544834, ‘ScanIgnoreTargeting’, ‘0’);” failed. Error description: “database is locked”.
02/06/06 11:51:13 1149259873 usuario 4293246277 Storage query “INSERT INTO LocalProperties (Object, Property, Val) VALUES (1121051540, ‘ScanAreas’, ‘QuickStartupMem’);” failed. Error description: “database is locked”.

I hope this helps!

Thanks

Leonardo

16

Leo, this is beyond my knowleadge… I can’t help further.
Maybe my only guess is updating the MDAC drivers…

17

Hi Tech

Thanks a lot for you time and help!

Any last ideas? Anyone else?

Or should I wait for the next update and hope the problem is fixed during its installation? :slight_smile:

Leonardo