You are viewing limited content. For full access, please sign in.

Question

Question

general database error (9008)

SDK
asked on October 14, 2014

We started getting this error lately and today nothing works. It's been a working system for several years.

The LF support site mentions possible data corruption issue. Is there a utility under Laserfiche that would fix this error ?

0 0

Answer

APPROVED ANSWER
replied on October 15, 2014

Are you using MSDE or Full SQL? 

If you are using MSDE, a 'PRIMARY' filegroup is full" message would mean that you are either running into the MSDE limit imposed by Microsoft or the hard drive that you actually have your SQL files in is running out of space. 

0 0

Replies

replied on October 14, 2014

The application event log on the Laserfiche Server computer should contain additional details pertaining to the 9008 error. 9008 usually means a problem with the Laserfiche Server interacting with SQL.

0 0
replied on October 14, 2014

log file attached. 

Can't make anything out of it though.

Any help is appreciated.

Steve Yu in Houston

lf.xlsx (21.92 KB)
0 0
replied on October 14, 2014

Not sure how you generated this Excel file, but it only lists Workflow events, nothing from the Laserfiche Server or a 9008 error.

0 0
replied on October 14, 2014

that's the only part of the Event Viewer app log section that seems related to LaserFiche.

0 0
replied on October 14, 2014

here is the log record:

============================================

Microsoft][SQL Native Client][SQL Server]Could not allocate space for object 'dbo.activity_log'.'activity_log_pk' in database 'LFDB-Crown-Mark' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.; SQL Statement: '{call create_entry(?                ,?                  ,?             ,?              ,?                     ,?                 ,?                     ,?  

=============================================

The primary filegroup is set to autogrow 1MB with unlimited growth. the log file is set to autogrow with 10% and restricted size (2,xxx,xxx MB) and not modifiable.

Help appreciated.

Steve Yu in Houston     

0 0
APPROVED ANSWER
replied on October 15, 2014

Are you using MSDE or Full SQL? 

If you are using MSDE, a 'PRIMARY' filegroup is full" message would mean that you are either running into the MSDE limit imposed by Microsoft or the hard drive that you actually have your SQL files in is running out of space. 

0 0
replied on October 16, 2014

The SQL software itself is very vague. It took a LF support expert to figure out that we indeed have the express version and ran into the 4G limit.

Thanks for the help.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.