FAQ   |   Knowledgebase   |   Downloads   |   Blog

Go Back

Deleting the data from a partially imported XML file

If the import task is interrupted for any reason (stopping the service during processing, system crash, power failure, etc.) it is possible that some, but not all, of the records contained in the import XML file would have been inserted into the OC_Import database. If this occurs the user must delete the existing records from the OC_Import database prior to reprocessing the import.

Use the following instructions to remove the incomplete date:

  1. View the log file for the import task that was partially imported.
  2. Record the Batch ID number.
  3. Open the SQL Query Analyzer.
  4. Select the OC_Import database.
  5. Delete the import records from the “Import” table that match the batch ID recorded in the log file.
  6. Create a new import task and import the XML file that had previously failed.

Facebook Twitter DZone It! Digg It! StumbleUpon Technorati Del.icio.us NewsVine Reddit Blinklist Add diigo bookmark

Post a comment!
  1. Formatting options
       
     
     
     
     
       

Risk Assessment Offer
An ODRA (Office Deployment Risk Appraisal) can discover what your real risks are - and you may qualify for a free one.
Learn More »
Upgrading to Office 2010?
Download this FREE Webinar PowerPoint presentation prepared by Forrester Research, Inc. Analyst Sheri McLeish.
Download Now»
CertificationsMore On Microsoft