I am using Windchill PDMLink Release 12.0 and Datecode with CPS 14
In a customization (BOM Bulkload) we are transferring BOM data from SAP to Windchill.
Some of those requests take very long (up to 1h) and some of them are even failing – see details below. This results in data sync Issues between and Windchill and SAP and has a severe impact for Windchill end-users
Here are the errors that I faced
Symptoms
The BOM Bulkload is using following OOTB method to re-create links between the top-level part of the BOM and the associated (Described By) documents:
PartDocHelper.service.createPartDocDescribeLinks(part, documents);
Some of the requests take very long (up to 1h) and some of them are even failing with an exception and stack trace below.
Stack Trace:
2024-02-12 15:31:20,184 ERROR [SAPBOMQueue.PollingThread] ext.continental.wise.core.clms.creator.BillOfMaterialCreator Administrator - Message: Resource bundle/Message key = wt.pom.pomResource/101 ErrorID:12 wt.pom.ConnectionLostException: A database connection failure has occurred and the operation has been aborted.
Nested exception is: wt.pom.DatastoreException: A SQL error has occurred for the statement "SELECT 'wt.part.WTPartDescribeLink',A0.classnamekeyroleAObjectRef,A0.idA3A5,A0.classnamekeyroleBObjectRef,A0.idA3B5,TO_CHAR(A0.createStampA2,'dd mm yyyy hh24:mi:ss'),A0.markForDeleteA2,TO_CHAR(A0.modifyStampA2,'dd mm yyyy hh24:mi:ss'),A0.idA2A2,A0.updateCountA2,TO_CHAR(A0.updateStampA2,'dd mm yyyy hh24:mi:ss'),A0.branchIdA2typeDefinitionRefe,A0.idA2typeDefinitionReference,'wt.doc.WTDocument',A1.administrativeLockIsNull,A1.typeadministrativeLock,A1.blob$entrySetadHocAcl,A1.checkoutInfoIsNull,A1.statecheckoutInfo,A1.classnamekeycontainerReferen,A1.idA3containerReference,A1.department,A1.description,A1.docType,A1.classnamekeydomainRef,A1.idA3domainRef,A1.entrySetadHocAcl,A1.eventSet,A1.classnamekeyA2folderingInfo,A1.idA3A2folderingInfo,A1.classnamekeyB2folderingInfo,A1.idA3B2folderingInfo,A1.classnamekeyformat,A1.idA3format,A1.hasHangingChange,A1.hasPendingChange,A1.hasResultingChange,A1.hasSuspect,A1.hasVariance,A1.indexersindexerSet,A1.inheritedDomain,A1.iopStateinteropInfo,A1.stateinteropInfo,A1.branchIditerationInfo,A1.classnamekeyD2iterationInfo,A1.idA3D2iterationInfo,A1.classnamekeyE2iterationInfo,A1.idA3E2iterationInfo,A1.iterationIdA2iterationInfo,A1.latestiterationInfo,A1.classnamekeyB2iterationInfo,A1.idA3B2iterationInfo,A1.noteiterationInfo,A1.classnamekeyC2iterationInfo,A1.idA3C2iterationInfo,A1.stateiterationInfo,TO_CHAR(A1.datelock,'dd mm yyyy hh24:mi:ss'),A1.classnamekeyA2lock,A1.idA3A2lock,A1.notelock,A1.classnamekeymasterReference,A1.idA3masterReference,A1.oneOffVersionIdA2oneOffVersi,A1.classnamekeyA2ownership,A1.idA3A2ownership,A1.securityLabels,A1.atGatestate,A1.classnamekeyA2state,A1.idA3A2state,A1.statestate,A1.teamIdIsNull,A1.classnamekeyteamId,A1.idA3teamId,A1.teamTemplateIdIsNull,A1.classnamekeyteamTemplateId,A1.idA3teamTemplateId,A1.enabledtemplate,A1.templatedtemplate,TO_CHAR(A1.createStampA2,'dd mm yyyy hh24:mi:ss'),A1.markForDeleteA2,TO_CHAR(A1.modifyStampA2,'dd mm yyyy hh24:mi:ss'),A1.idA2A2,A1.updateCountA2,TO_CHAR(A1.updateStampA2,'dd mm yyyy hh24:mi:ss'),A1.title,A1.branchIdA2typeDefinitionRefe,A1.idA2typeDefinitionReference,A1.ptc_bln_1typeInfoWTDocument,A1.ptc_bln_2typeInfoWTDocument,A1.ptc_bln_3typeInfoWTDocument,A1.ptc_bln_4typeInfoWTDocument,A1.ptc_bln_5typeInfoWTDocument,A1.ptc_bln_6typeInfoWTDocument,A1.ptc_lng_1typeInfoWTDocument,A1.ptc_lng_10typeInfoWTDocument,A1.ptc_lng_11typeInfoWTDocument,A1.ptc_lng_12typeInfoWTDocument,A1.ptc_lng_2typeInfoWTDocument,A1.ptc_lng_3typeInfoWTDocument,A1.ptc_lng_4typeInfoWTDocument,A1.ptc_lng_5typeInfoWTDocument,A1.ptc_lng_6typeInfoWTDocument,A1.ptc_lng_7typeInfoWTDocument,A1.ptc_lng_8typeInfoWTDocument,A1.ptc_lng_9typeInfoWTDocument,A1.ptc_str_1typeInfoWTDocument,A1.ptc_str_10typeInfoWTDocument,A1.ptc_str_100typeInfoWTDocumen,A1.ptc_str_101typeInfoWTDocumen,A1.ptc_str_102typeInfoWTDocumen,A1.ptc_str_103typeInfoWTDocumen,A1.ptc_str_104typeInfoWTDocumen,A1.ptc_str_105typeInfoWTDocumen,A1.ptc_str_11typeInfoWTDocument,A1.ptc_str_12typeInfoWTDocument,A1.ptc_str_13typeInfoWTDocument,A1.ptc_str_14typeInfoWTDocument,A1.ptc_str_15typeInfoWTDocument,A1.ptc_str_16typeInfoWTDocument,A1.ptc_str_17typeInfoWTDocument,A1.ptc_str_18typeInfoWTDocument,A1.ptc_str_19typeInfoWTDocument,A1.ptc_str_2typeInfoWTDocument,A1.ptc_str_20typeInfoWTDocument,A1.ptc_str_21typeInfoWTDocument,A1.ptc_str_22typeInfoWTDocument,A1.ptc_str_23typeInfoWTDocument,A1.ptc_str_24typeInfoWTDocument,A1.ptc_str_25typeInfoWTDocument,A1.ptc_str_26typeInfoWTDocument,A1.ptc_str_27typeInfoWTDocument,A1.ptc_str_28typeInfoWTDocument,A1.ptc_str_29typeInfoWTDocument,A1.ptc_str_3typeInfoWTDocument,A1.ptc_str_30typeInfoWTDocument,A1.ptc_str_31typeInfoWTDocument,A1.ptc_str_32typeInfoWTDocument,A1.ptc_str_33typeInfoWTDocument,A1.ptc_str_34typeInfoWTDocument,A1.ptc_str_35typeInfoWTDocument,A1.ptc_str_36typeInfoWTDocument,A1.ptc_str_37typeInfoWTDocument,A1.ptc_str_38typeInfoWTDocument,A1.ptc_str_39typeInfoWTDocument,A1.ptc_str_4typeInfoWTDocument,A1.ptc_str_40typeInfoWTDocument,A1.ptc_str_41typeInfoWTDocument,A1.ptc_str_42typeInfoWTDocument,A1.ptc_str_43typeInfoWTDocument,A1.ptc_str_44typeInfoWTDocument,A1.ptc_str_45typeInfoWTDocument,A1.ptc_str_46typeInfoWTDocument,A1.ptc_str_47typeInfoWTDocument,A1.ptc_