Author Topic: "Program cannot set property into main Storage"...  (Read 10853 times)

0 Members and 1 Guest are viewing this topic.

leomalav

  • Guest
"Program cannot set property into main Storage"...
« on: June 02, 2006, 07:25:06 PM »
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".  :)

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.  :)

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

Offline Lisandro

  • Avast team
  • Certainly Bot
  • *
  • Posts: 67194
Re: "Program cannot set property into main Storage"...
« Reply #1 on: June 02, 2006, 07:28:40 PM »
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...
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?
The best things in life are free.

leomalav

  • Guest
Re: "Program cannot set property into main Storage"...
« Reply #2 on: June 02, 2006, 07:43:57 PM »
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...
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?

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

leomalav

  • Guest
Re: "Program cannot set property into main Storage"...
« Reply #3 on: June 02, 2006, 08:52:57 PM »
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

Offline Lisandro

  • Avast team
  • Certainly Bot
  • *
  • Posts: 67194
Re: "Program cannot set property into main Storage"...
« Reply #4 on: June 02, 2006, 09:23:57 PM »
Storage query "INSERT INTO LocalProperties (Object, Property, Val) VALUES (1121051540, 'ScanAreas', 'QuickStartupMem');" failed. Error description: "database is locked".
Any ideas?
Leo, I have an 'idea'...
The database could be avast4.mdb file into the <avast>\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.  ::)
The best things in life are free.

leomalav

  • Guest
Re: "Program cannot set property into main Storage"...
« Reply #5 on: June 02, 2006, 10:01:02 PM »
Storage query "INSERT INTO LocalProperties (Object, Property, Val) VALUES (1121051540, 'ScanAreas', 'QuickStartupMem');" failed. Error description: "database is locked".
Any ideas?
Leo, I have an 'idea'...
The database could be avast4.mdb file into the <avast>\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.  ::)

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

Offline Vlk

  • Avast CEO
  • Serious Graphoman
  • *
  • Posts: 11656
  • Please don't send me IM's. Email only. Thx.
    • ALWIL Software
Re: "Program cannot set property into main Storage"...
« Reply #6 on: June 02, 2006, 10:22:45 PM »
Is there anything relevant in the file <avast>\data\error.log?
If at first you don't succeed, then skydiving's not for you.

leomalav

  • Guest
Re: "Program cannot set property into main Storage"...
« Reply #7 on: June 02, 2006, 10:58:37 PM »
Is there anything relevant in the file <avast>\data\error.log?

Hi Vlk

The situation now is the following...  :)

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!  :)

Thanks

Leonardo

Offline Lisandro

  • Avast team
  • Certainly Bot
  • *
  • Posts: 67194
Re: "Program cannot set property into main Storage"...
« Reply #8 on: June 03, 2006, 03:46:59 AM »
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!
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.
The best things in life are free.

Offline Vlk

  • Avast CEO
  • Serious Graphoman
  • *
  • Posts: 11656
  • Please don't send me IM's. Email only. Thx.
    • ALWIL Software
Re: "Program cannot set property into main Storage"...
« Reply #9 on: June 03, 2006, 09:02:34 AM »
Database is locked, hmm, interesting, indeed...
I really wonder what might be causing this
If at first you don't succeed, then skydiving's not for you.

Offline Lisandro

  • Avast team
  • Certainly Bot
  • *
  • Posts: 67194
Re: "Program cannot set property into main Storage"...
« Reply #10 on: June 03, 2006, 04:35:47 PM »
I really wonder what might be causing this
Access rights  ::) ???
The best things in life are free.

Offline Vlk

  • Avast CEO
  • Serious Graphoman
  • *
  • Posts: 11656
  • Please don't send me IM's. Email only. Thx.
    • ALWIL Software
Re: "Program cannot set property into main Storage"...
« Reply #11 on: June 03, 2006, 05:48:10 PM »
Tech, this is Win98... :P
If at first you don't succeed, then skydiving's not for you.

leomalav

  • Guest
Re: "Program cannot set property into main Storage"...
« Reply #12 on: June 03, 2006, 06:21:06 PM »
Database is locked, hmm, interesting, indeed...
I really wonder what might be causing this

Hi Vlk

I don't know if I should feel proud or scared!  :D

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

Offline Lisandro

  • Avast team
  • Certainly Bot
  • *
  • Posts: 67194
Re: "Program cannot set property into main Storage"...
« Reply #13 on: June 04, 2006, 12:55:47 AM »
Tech, this is Win98... :P
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)...  ::)
The best things in life are free.

leomalav

  • Guest
Re: "Program cannot set property into main Storage"...
« Reply #14 on: June 05, 2006, 02:13:22 PM »
Tech, this is Win98... :P
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)...  ::)

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