What if Android Market updates doesn’t work for apps installed on SD card


Android Market

Image via Wikipedia

The problem: under Android OS applications installed to SD card using Android Market cannot be updated, showing error message.

The solution (found here, thanks to cdore…@gmail.com):

  1. Connect your device to PC.
  2. On your device select Mount or External drive option.
  3. Open your device as a drive in My Computer.
  4. Find folder “.android.secure” or “/mnt/secure/asec/”
  5. Delete file “smdl2tmp1.asec” (L before the 2nd letter and letter 1 after “tmp”).
  6. Try to re-download updates via Android Market.
Hope that helps!
Advertisements

Statistics generation: custom solution instead of Reporting Services


Today we’ve finished one project which took a plenty of time to be realised – a custom statistis module based on SQL data and realised as MOSS\WSS (SharePoint) webparts kit.

We have extremely tough queries and quite complicated data model, so we decided to get another solution:

  • The whole thing is divided into 5 parts each describing different business viewpoint of the data; all these viewpoints have been deployed as custom web-parts with initial constructor implemented with 1st webpart.
  • SQL code takes about 14 500 (!) lines in 6 different UDFs, which all were written by one person; another guy created webparts.

Finally, we’ve done it. Hurray!