Smartconnect Process Errors
The Header for the Run information appears to come from the ProcessErrors Table, but cannot find which table stores the Import Data.
Is it alright to clear out the Process Errors Table and all the Log Tables so Smartconnect can start a fresh with the Process Errors?
Which table stores the Import Detail for the Process Errors to attempt the import, or this stored in an XML document?
You can delete the data in the LogXXX tables in the SmartConnect database.
Thanks very much, will give that a try.
“Which table stores the Import Detail for the Process Errors to attempt the import, or this stored in an XML document?”
The import data is stored as XML in one of the columns in the ProcessErrors table.
If you want to “start fresh”, you can delete all the records in that table.
Must be hard to interpret the xml, but thank you very much, will see if the errors start showing correctly after the refresh.
it is a bit difficult for humans to read the unformatted string. but if you pull it out of the column and paste it into an .xml file and open it with ie/chrome/other it’ll format it nicely for you.
If you would like to submit an answer or comment, please sign in to the eOne portal.