Question & Answer
Question
We were running interactions like memsearch, memputqual etc and we encountered errors like the following: AUDIT iatesystems.hub.logging.AuditLog: UID=1, IXN=MEMPUTQUAL, ERR=ENOREC, SMT=5312 DBSQL itiatesystems.hub.logging.SqlLog: MAD_DbxAbort: stmt='rollback' Why are we getting these errors?
Cause
The error means that the search input data was bucket-able, but those buckets occur too frequently. It is likely that Frequency Based Bucketing (FBB) or Dynamic Frequency Based Bucketing (DFBB) is enabled and that is ignoring/deleting those buckets. The error stack may resemble the following:
ALGO systems.hub.logging.AlgorithmLog: MPI_DvdInfo_ChkFreq: bktRole=3, bktVal='01702+S', ignored, freq=2868, max=1000.
ALGO systems.hub.logging.AlgorithmLog: MPI_DvdInfo_ChkFreq: bktRole=5, bktVal='0000500006', ignored, freq=3074, max=1000.
ALGO systems.hub.logging.AlgorithmLog: MPI_DvdInfo_ChkFreq: bktRole=5, bktVal='11371', ignored, freq=5068523, max=1000.
ALGO systems.hub.logging.AlgorithmLog: MPI_DvdInfo_ChkFreq: bktRole=5, bktVal='0000500006+11371', ignored, freq=3074, max=1000.
WARN atesystems.hub.logging.NativeLog: MPI_MxmGetCandSearch: search input data was bucketable, but occurs too frequently.
AUDIT iatesystems.hub.logging.AuditLog: UID=1, IXN=MEMPUTQUAL, ERR=ENOREC, SMT=5312
DBSQL itiatesystems.hub.logging.SqlLog: MAD_DbxAbort: stmt='rollback'
Answer
From the error stack above, we can clearly see that the buckets have been ignored because the frequency exceeds the maximum specified for marking them as anonymous. If all the buckets are anonymous, then the search can not proceed and we will get SMT 5312 error.
If you provided multiple parameters for search and not just the one whose buckets exceed the FBB threshold, then it suggests that the rest of the parameters were not bucketed on. The IxnMemPutQual is specifically coded to return this error code when there are no buckets and it would prevent a duplicate member from being created when a matching member already exists.
Product Synonym
MDS;Master Data Service;MDM;MDMSE;Master Data Management;IBM Infosphere Master Data Service;MDM Standard Edition;MDM Hybrid Edition;Initiate;Initiate Systems
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21664968