Back to forum list… Back to How Do I?...

Question on a DB Insert Transform Error: [RECORD[@id='Record']] could not be found in document. (6 replies)

Arline Welty
5 years ago
Arline Welty 5 years ago

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

Support
5 years ago
Support 5 years ago

What do you have in your Audit Summary?

Arline Welty
5 years ago
Arline Welty 5 years ago

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"'

Support
5 years ago
Support 5 years ago

Arline, please attached a screenshots of the Field Mapping and Audit Summary.

https://www.realisable.co.uk/wp-content/uploads/2019/09/DBWriterAuditSummary-2.png
https://www.realisable.co.uk/wp-content/uploads/2019/09/DBWriterAuditSummary-1.png
Arline Welty
5 years ago
Arline Welty 5 years ago

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

Support
5 years ago
Support 5 years ago

Change %Record to %mwmvbuyz

Arline Welty
5 years ago
Arline Welty 5 years ago

Interesting, we're all good now. Thanks for the advice!

Contact

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close

Request Demo

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close

Access Downloads

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close