RE: Error while importing .csv file from SharePoint folder in ER configuration
Hi Ludwig,
We are trying to import the customer receipts files (ISO20022 camt.054 credit advice) and the vendor payment status report files (ISO20022 pain.002) from SharePoint Online. We have got this configured and working successfully on our internal environment, but we are running into an issue on the customer's environment.
When uploaded manually from the user’s browser, the same files upload successfully on the customer's environment. The files are visible (with a status of Ready) in the File states for the sources table and the system seems to try to import them, but we then get a status of Failed:
Below is the error message we are getting, at first sight it seems like an issue with the ER configuration or model mapping. However, the manual import works, so that would suggests the ER configuration should be fine.
camt.054 message:
Evaluating expression for path 'model/$FilteredPayments'.
Evaluating expression for path 'Payments'.
Evaluating expression for path '$AllTransactionDetails'.
Evaluating expression for path 'format/Document/BkToCstmrDbtCdtNtfctn/Ntfctn'.
Cannot edit a record in File states for the sources (ERImportFormatFileSourceStateTable). Update must be performed inside a transaction.
Error while evaluating expression for path 'format/Document/BkToCstmrDbtCdtNtfctn/Ntfctn'.
pain.002 message:
Evaluating expression for path '$TransactionsForMapping'.
Evaluating expression for path 'model/OriginalGroupInformationAndStatus/$TransactionsByJournalNum'.
Evaluating expression for path '$Status/PaymentStatus'.
Evaluating expression for path 'GroupStatus'.
Evaluating expression for path 'format/Document/CstmrPmtStsRpt/OrgnlGrpInfAndSts/GrpSts/IsMatched'.
Cannot edit a record in File states for the sources (ERImportFormatFileSourceStateTable). Update must be performed inside a transaction.
(S)\Classes\FormFunctionButtonControl\clicked
Error while evaluating expression for path 'format/Document/CstmrPmtStsRpt/OrgnlGrpInfAndSts/GrpSts/IsMatched'.
As you can see the only consistent part is the text highlighted in red.
Any ideas / hints will be much appreciated,
Thank you
