Skip to content Skip to main navigation Skip to footer

Control List

Error initializing list (XIE0R): Import error…

The following list load error has been seen in the old UI version 8.8.3a and earlier:

“Error initializing list (XIE0R): Import error on line X,XXX,XXX of file C:\Program Files\Wavecrest\CyBlock\wc\cyblock\plugin\~temp.bin: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by ‘SQL:XXXXXXXXXXXXXXXXX’ defined on ‘CONTROLLIST’

The above error will show immediately after logging on to the UI, indicating an issue with the list where it must be purged, and the latest list 8 must be downloaded. To resolve the issue, please do the following:

For CyBlock:

  1. Stop the CyBlock service.
  2. Go to …Wavecrest\CyBlock\wc\cyblock\db\plugin.
  3. Remove all files/folders from the plugin directory so that it is empty.
  4. Start the CyBlock service.
  5. Log on to CyBlock.
  6. Go to Administration – URL List – Download – Manual – Download Now.

 

For Cyfin:

  1. Stop the Cyfin service.
  2. Go to …Wavecrest\Cyfin\wc\cf\db\plugin.
  3. Remove all files/folders from the plugin directory so that it is empty.
  4. Start the Cyfin service.
  5. Log on to Cyfin.
  6. Go to Administration – URL List – Download – Manual – Download Now.

 

Once these steps are complete, you should see a “Category Resolution is Ready” message in green.

URL list not found (repairing a broken list automatically)

To repair a broken URL list:

  1. Navigate to Categorization – URL List – Repair¹.
  2. Click Submit.
  3. After the repair has completed, log back into the product.
  4. Navigate to Categorization – URL List – Download.
  5. Download the list manually. (You can also reconfigure the scheduled download settings if desired.)

(Note:  An automatic service restart will occur.)

 


¹ For version 6.8.3a/8.8.3a and earlier:

  1. Access the hidden screen: http://<servername or IP>:7999/admin/hidden.php.
  2. Select List Repair.
  3. After the repair has completed, log back into the product.
  4. Navigate to Setup – Download Settings and click Submit.
  5. Close the successful connection pop-up message, and click the Download Now button on the next page to download the list again.