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#