KM filling database log

[Former Member]

We have a process that runs and creates document links in a KM repository. The method we use to create documents links is:

aResource = aCollection.createResource(doc.getDocName(), null, aContent);

For some reason when we run this process for about 3000 documents there are database log archives that fill up and cause the Portal to crash.

Does anyone know the cause of this? It appears to us that certain insert and select statements are getting executed multiple times for each document. The insert statement is below. We have checked our code, and based on our log output statements we are creating each document once. But KM seems to be executing multiple inserts.

INSERT INTO "KMC_DBRM_TMPNODES" ("NODEID") SELECT "CHILDNODEID" FROM "KMC_DBRM_RELATIONS" WHERE "PARENTNODEID" = :1#

[Former Member]

1) Can you please post the complete log entry?

2) Any chance that at the same time somebody else is/was locking parts of the document tree?

Best regards, Julian