Skip to content
+1-888-319-3663

COMMUNITY FORUM

Smartconnect Process Errors

Mick asked 6 years ago
Recently the Process Errors stopped displaying the current errors, and only very old errors appeared.
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?
Thanks,
Mick
Answers
Lorren Zemke Staff answered 6 years ago
Mick,
You can delete the data in the LogXXX tables in the SmartConnect database. 
Lorren
Mick replied 6 years ago

Lorren,
Thanks very much, will give that a try.
Mick

Patrick Roth Staff answered 6 years ago
Mick,
“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.
patrick
Mick replied 6 years ago

Patrick,
Must be hard to interpret the xml, but thank you very much, will see if the errors start showing correctly after the refresh.
Mick

Patrick Roth Staff replied 6 years ago

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.

Mick answered 6 years ago
Just some feedback, after clearing the ProcessErrors and Log Tables the Process Errors started to appear correctly again.
 
Mick

If you would like to submit an answer or comment, please sign in to the eOne portal.