Tuesday, March 22, 2011

Where are images files in Laserfiche?

We are working with our LaserFiche (LF) vendor to upgrade our LaserFiche software. After the LaserFiche upgrade, we and some of the LaserFiche users perform some checks if there are any issues. This is important because the users are using the LaserFiche software almost all the time and if there are any issues, we can settle the issues quickly. 

About 5 to 10 minutes later, we got calls from the same few users that they were unable to view the scanned images (tiff format) in LF client. Viewing the tiff generate error message: Failed to load Image and General Database error.(Error number: 9008). Strangely, the users were able to open and viewed the pdf documents in the client.

Looking at the error messages in the help section, it suggested that if the LaserFiche service is logged in using a Windows account and checked if the rights to access the database are given. That should not be the case because some users are actually able to add / remove / drage / drop the documents in the client itself.

Let us looked at the second suggestion. It mentioned that if using MSDE or SQL Server express, check to see that all expansion databases were attached. First of all, we are using not the Express version of the SQL server, but the 2008 version for the SQL Server. The databases were all included in the LaserFiche but why did the error message appeared and shown General Database Error? Very strange....

Our vendor suggested that the service itself was not running and recommended that the service should be restarted. It was thought that the services that connect the database were not running in the server and by restarting the services, it would work. Hmmm… Restarting the services still remained the same. The error messages remained the same.

We hunted around and figured that the scanned images were not recently scanned and therefore, the “link” was somehow not updated in the database itself. And thus the error message. Looking at the error message again, we took us a while to figure that the missing “link” was due to the old database was not attached. Bear in mind that the old database contained all the scanned images and other documents and all along we all thought it was attached! 

We hunted for the databases and we found that there are 4 such databases in the data itself (about 4Gb in total). So we tried to attached it manually and try again.
 
We tried to access it again and found that the scanned images are able to load and the error message disappeared. We checked with our users again and they confirmed that the error message did not appeared.


- wong chee tat :)

VirtualBox

Downloaded and tried out the new version of virtualbox, which is release on Feb 17th 2011. The change log is here.

I am currently testing with different OSes (Windows 2008 Server, etc) and on different platforms. I will post more later on.

- wong chee tat :)