Question

Laserfiche Server: I'm getting 'General Database Error [9008]

Laserfiche

Updated January 7, 2014

asked on January 6, 2014

When executing search command, NewSearch.command, we are getting error "Object reference not set to an instance of an object".

This might be coming due to null value of string which we are passing in search criteria.

But the problem is that after some time, we start getting "General Database Error [9008]" when we try to connect to server repository in version 8.3.

I'm looking for an instant solution to this problem, so that when it occurs, atleast, we can go for that solution and able to login to server repository within some time.

2 0

Replies

replied on January 6, 2014

Start with the basics.

Make sure SQL is up and running, make sure you can reach sql from your Laserfiche server if they are on different machines.

I'd also consider doing a reboot of the machine the SQL server is on. (hopefully by now two hours later you've done that!)

Unfortunately this error message almost always means a issue with SQL itself, and that's not something LF support will be able to help you with in most cases.

3 0

replied on January 6, 2014

If you look in the LFServer's Windows event log, there should be a more detailed error message. Like Chris said, it's most likely something with SQL itself, but a badly written search query can generate a 9008 error as well. There is no instant solution as there is no one single cause for it.

2 0

replied on January 6, 2014

can you check below link

https://support.laserfiche.com/kb/1012566

2 1

replied on January 6, 2014

I suspect that search query in my script is causing this.

My query below is in vb.net. In what circumstances this query can throw errors like "object not identified..." or "object reference not set to an instance of an object"

searchterm = "{LF:LOOKIN=""\folder1\folder2\folder3"",SUBFOLDERS=1} & {[]:[VN]=""" & VNum & """} & {[]:[ET]=""" & DocET & """}"

NewSearch.Command = searchterm

0 0

replied on January 6, 2014

Could you look up the error on the LFServer's event log and post it here too, please?

1 0

replied on January 7, 2014

Yes, It was problem with SQL transaction log files (no more disk space problem).

The error could be seen from LFServer's Windows event log.

Thanks for your responses on this question.

3 0

You are not allowed to follow up in this post.

Question

Question

Laserfiche Server: I'm getting 'General Database Error [9008]

Replies

Sign in to reply to this post.