Question on a DB Insert Transform Error: [RECORD[@id='Record']] could not be found in document. (6 replies)
What do you have in your Audit Summary?
I added field-level audit info but this is all I'm seeing in the Audit Log :
Job [KKIASC_MASTERMP_ICITEM Kit Drop and Load] has aborted due to a transform failure.
Error occurred whilst processing transform [InsertItemCost_Kit]. [RECORD[@id='Record']] could not be found in document.
The Errors.txt entry has this:
[RECORD[@id='Record']] could not be found in document.
Time='09/06/19 10:13:27' App='IManEngine:3.2.100' ADO-version='6.3' Computer='XXXX'
Method: XMLWrapper.GetNodeFromXPath
Number: 7703 = &H1E17 = vbObjectError + 2147229207 = ERRMAP_APP_FIRST + 2147224009
Source: HuntERR.Check
Description: [RECORD[@id='Record']] could not be found in document.
Call Stack: XMLWrapper.GetNodeFromXPath(sXPath='RECORD[@id='Record']') ---------------------------
Env: sSafePath=''
Call Stack: TransformDefinition.RecordNode(vTranID='Record') -------------------------------------
Call Stack: TransformTaskListGenerator.GenerateDistinctValueList(sTransactionId='Record') --------
Env: sKey='', sField='', sVal='', l=0, lFldCnt=0, bRequiresIteration =False
Call Stack: TransformTaskListGenerator.GenerateMatchingFiles(sStatement={Text}) ------------------
Value Of sStatement:
'%Record.PROCESSED Records Processed. %Record.INSERTED Created. %Record.UPDATED Updated. %Record.ERRORS Errors.'
Env: l=0, sTransactionId='Record'
Call Stack: AuditLogger.ReplaceSummaryTokens(sTfmId='InsertItemCost_Kit', sSummaryString={Text})
Value Of sSummaryString:
'%Record.PROCESSED Records Processed. %Record.INSERTED Created. %Record.UPDATED Updated. %Record.ERRORS Errors.'
Env: l=0, sResult =''
Call Stack: AuditLogger.GenerateEmailHeader() ----------------------------------------------------
Env: l=1, sResult={Text}
Value Of sResult:
'
Inserting rows where KeyPurpose = ItemCost_Kit
'
Call Stack: AuditLogger.AddTransformSummaries(sTransformId='InsertItemCost_Kit') -----------------
Call Stack: TransformCoordinator.RunTransform(sTransformId='InsertItemCost_Kit') -----------------
Env: eTransformType=2, bWriteSummaries=True, bSummariesHandled=False
Call Stack: TransformCoordinator.RunTransformStream(sParentTransform='Read_ItemCost_Kit') --------
Env: sTransformId='InsertItemCost_Kit', l=0, m=0
Call Stack: TransformCoordinator.RunTransformStream(sParentTransform='') -------------------------
Env: sTransformId='Read_ItemCost_Kit', l=1, m=1
Call Stack: TransformCoordinator.Process() -------------------------------------------------------
Call Stack: IntManEng.Main() ---------------------------------------------------------------------
Env: sCmd={Text}
Value Of sCmd:
'"KKIASC_MASTERMP_ICITEM Kit Drop and Load"'
Arline, please attached a screenshots of the Field Mapping and Audit Summary.
Attached is an image of field mapping & audit summary screens.
Text of audit summary:
%Record.PROCESSED Records Processed. %Record.INSERTED Created. %Record.UPDATED Updated. %Record.ERRORS Errors.
Key Purpose %mwmvbuyz.KeyPurpose Field1 %mwmvbuyz.Field1 Field2 %mwmvbuyz.Field2 Field 3 %mwmvbuyz.Field3
Change %Record to %mwmvbuyz
Interesting, we're all good now. Thanks for the advice!
Error occurred whilst processing transform [InsertItemCost_Kit]. [RECORD[@id='Record']] could not be found in document.
Not sure what to make of this error. I receive this error when running the job in the scheduler. When I run it within the designer, I don't get the error. It's preceded by a script task but there is not auditing associated with the script task. No errors in that either when I run in the designer.
The point of the transform is to insert new records to an Extender table (custom table) in Sage 300 ERP. Why would it fail via scheduler but succeed in the designer?
Also, what does the error mean?
Assembly Versions:
Realisable.IManWebUI.DLL
3.2.0.0
Product Update: PU1
Config Version: 3.21
DB Version: 3.12