Question

Getting timeouts when removing a field from a template

Laserfiche Version 9 Administration

Updated March 27, 2015

asked on March 25, 2015

When we attempt to remove a field from a template, the admin console stops responding. After several minutes, the message shows that the operation has timed out.

Once the timeout message occurs, the template properties will no longer open, documents won't open, and other dialogs that rely on the template will error out when opening them. It gives a message that the object is locked.

The template we are attempting to modify is assigned a very large number of documents (250,000+)

This does not occur with a brand new template we created and removed and modified fields of.

The database backend is Oracle 11g

Server OS is Windows 2012

0 0

Answer

SELECTED ANSWER

replied on March 27, 2015

We ended up setting up the query on its own.

After that removing the fields from the template completed using the admin console.

1 0

Replies

replied on March 25, 2015

The above query needs to run. Maybe your Oracle DBA can investigate the query plan and see if there's a way to make this query run faster. The propval.prop_id and toc.pset_id columns should both be indexed.

1 0

replied on March 25, 2015

Below is the SQL command that the Oracle DBA has said is running.

delete from propval where prop_id = :propid1 and str_val is null
and num_val is null and date_val is null and bin_val is null an
d tocid in (select tocid from toc where pset_id = :psetid1)

this command is causing the database server to basically halt, before timing out several minutes later.

0 0

You are not allowed to follow up in this post.

Question

Question

Getting timeouts when removing a field from a template

Answer

Replies

Sign in to reply to this post.