Not all FLOCs sent from SAP have records created in the dataloader


 Product(s):APM Implementation and Performance Management
 Version(s):7.10
 Environment:N\A
 Area:N/A
 Subarea:N\A

Problem

When I triggered the job for "Data Loader asset SAP functional location" about 10000 assets out of 24000 were not updated with the SAP FLOC reference. There were no records for them in the data loader table at any stage (e.g. waiting to be processed or Failed). It seems that they were not picked up by the data loader at all.

An exception when creating FLOC dataloader records means that many records are missed. The problem lay in the code

"m_SAPFLOCNumberToOID.Add( StagingRec.FunctionalLocation, FLOCOID );

The problem is that the Key has already been added to the dictionary.This should never happen, we should be getting unique FunctionalLocation names from SAP. The problem happens intermittently and if it does happen we get a "KeyNotFound" and stop creating staging records.



Solution

A VSTS item was created for this VSTS#37284 -"SAP FLOC import: Exception when creating FLOC dataloader records means that many records are missed". The code is being updated for release 7.12. A hotfix was requested for release 7.10 - VSTS 37734.

See Also

https://bentleysystems.service-now.com/community?id=kb_article_view&sysparm_article=KB0089211