Data tool import - completed with errors

Posted By simonrl Fri 22 Aug 2014
Add to Favorites0
Author Message
simonrl
 Posted Fri 22 Aug 2014
Supreme Being

Supreme Being - (12,884 reputation)Supreme Being - (12,884 reputation)Supreme Being - (12,884 reputation)Supreme Being - (12,884 reputation)Supreme Being - (12,884 reputation)Supreme Being - (12,884 reputation)Supreme Being - (12,884 reputation)Supreme Being - (12,884 reputation)Supreme Being - (12,884 reputation)

Group: Forum Members
Last Active: Tue 23 Feb 2021
Posts: 18, Visits: 88
Hi Guys

I'm trying to do an import of data from Cactus 6, very little data, 61 categories, 100 products, 433 versions.

Cactus data is in SQL 2005, Cactus version is v6.061

Kartirs data is in SQL 2008 R2, Kartris version is v2.5009

Data tool is v2.5070

Initially I tried a full import including customer data. That failed with errors. So I reloaded blank Kartris database files and tried again just with the product data. Same result.

The Kartris web site is now falling over on the home page with:

Object reference not set to an instance of an object.

Log file from data tool shown below.

Any ideas what's going wrong please? Is it a case of manually correcting the issues in the Cactus database one by one?

Thanks,
Simon

Time,Logger,Level,Message
2014-08-22 11:34:13.7588,Cactushop to Kartris,Info, ======= Database:Cactushop >> Database:dbKartrisStore =======
2014-08-22 11:34:13.7598,Cactushop to Kartris,Info, ======= Data Upgrade Started on 22/08/2014 11:34:13... ========
2014-08-22 11:34:13.7598,Cactushop to Kartris,Info,Clearing Kartris database product data...
2014-08-22 11:34:21.8376,Cactushop to Kartris,Info,Done.
2014-08-22 11:34:22.2706,Cactushop to Kartris,Info,Importing 61 record(s) to tblKartrisCategories...
2014-08-22 11:34:22.2706,Cactushop to Kartris,Info,Done.Processing the rest of tblKartrisCategories...
2014-08-22 11:34:23.7638,Cactushop to Kartris,Info,Done.
2014-08-22 11:34:23.7758,Cactushop to Kartris,Info,There were 61 NEW record(s) added.
2014-08-22 11:34:23.7758,Cactushop to Kartris,Info,======================================================================
2014-08-22 11:34:24.0198,Cactushop to Kartris,Info,Importing 100 record(s) to tblKartrisProducts...
2014-08-22 11:34:24.0198,Cactushop to Kartris,Info,Done.Processing the rest of tblKartrisProducts...
2014-08-22 11:34:27.2451,Cactushop to Kartris,Info,Done.
2014-08-22 11:34:27.2561,Cactushop to Kartris,Info,There were 100 NEW record(s) added.
2014-08-22 11:34:27.2561,Cactushop to Kartris,Info,======================================================================
2014-08-22 11:34:27.6992,Cactushop to Kartris,Error,Skipping tblCactuShop10027Versions...
2014-08-22 11:34:27.6992,Cactushop to Kartris,Error,Value was either too large or too small for an Int16.Couldn't store <38330> in V_OrderByValue Column. Expected type is Int16.
2014-08-22 11:34:27.6992,Cactushop to Kartris,Error,"
======================================================================"
2014-08-22 11:34:28.3092,Cactushop to Kartris,Info,Importing 433 record(s) to tblKartrisVersions...
2014-08-22 11:34:28.3092,Cactushop to Kartris,Info,Done.Processing the rest of tblKartrisVersions...
2014-08-22 11:34:42.6917,Cactushop to Kartris,Info,Done.
2014-08-22 11:34:42.7007,Cactushop to Kartris,Info,There were 432 NEW record(s) added.
2014-08-22 11:34:42.7007,Cactushop to Kartris,Error,Failed in importing 1 records. See error details below...
2014-08-22 11:34:42.7007,Cactushop to Kartris,Info,======================================================================
2014-08-22 11:34:42.7007,Cactushop to Kartris,Error,"1. Cannot insert the value NULL into column 'V_OrderByValue', table 'dbKartrisStore.dbo.tblKartrisVersions'; column does not allow nulls. INSERT fails.The statement has been terminated.ROW DETAILS:=============V_ID = 710 V_CodeNumber = FTR33038 V_ProductID = 524 V_Price = 79 V_Tax = 12 V_Weight = 0 V_DeliveryTime = 0 V_Quantity = 0 V_QuantityWarnLevel = 0 V_Live = True V_DownLoadInfo = V_DownloadType = n V_OrderByValue = V_RRP = 0 V_Type = v V_CustomerGroupID = V_CustomizationType = V_CustomizationDesc = V_CustomizationCost = 0 V_Tax2 = V_TaxExtra =============="
2014-08-22 11:34:42.7007,Cactushop to Kartris,Info,======================================================================
2014-08-22 11:34:42.8507,Cactushop to Kartris,Info,Importing 3 record(s) to tblKartrisOptionGroups...
2014-08-22 11:34:42.8507,Cactushop to Kartris,Info,Done.Processing the rest of tblKartrisOptionGroups...
2014-08-22 11:34:42.9547,Cactushop to Kartris,Info,Done.
2014-08-22 11:34:42.9547,Cactushop to Kartris,Info,There were 3 NEW record(s) added.
2014-08-22 11:34:42.9547,Cactushop to Kartris,Info,======================================================================
2014-08-22 11:34:43.0797,Cactushop to Kartris,Info,Importing 9 record(s) to tblKartrisOptions...
2014-08-22 11:34:43.0797,Cactushop to Kartris,Info,Done.Processing the rest of tblKartrisOptions...
2014-08-22 11:34:43.5297,Cactushop to Kartris,Info,Done.
2014-08-22 11:34:43.5297,Cactushop to Kartris,Info,There were 9 NEW record(s) added.
2014-08-22 11:34:43.5297,Cactushop to Kartris,Info,======================================================================
2014-08-22 11:34:43.6598,Cactushop to Kartris,Info,Importing 6 record(s) to tblKartrisAttributes...
2014-08-22 11:34:43.6598,Cactushop to Kartris,Info,Done.Processing the rest of tblKartrisAttributes...
2014-08-22 11:34:43.8228,Cactushop to Kartris,Info,Done.
2014-08-22 11:34:43.8228,Cactushop to Kartris,Info,There were 6 NEW record(s) added.
2014-08-22 11:34:43.8228,Cactushop to Kartris,Info,======================================================================
2014-08-22 11:34:44.1118,Cactushop to Kartris,Info,Importing 61 record(s) to tblKartrisCategoryHierarchy...
2014-08-22 11:34:44.1118,Cactushop to Kartris,Info,Done.Processing the rest of tblKartrisCategoryHierarchy...
2014-08-22 11:34:46.0550,Cactushop to Kartris,Info,Done.
2014-08-22 11:34:46.0550,Cactushop to Kartris,Info,There were 61 NEW record(s) added.
2014-08-22 11:34:46.0550,Cactushop to Kartris,Info,======================================================================
2014-08-22 11:34:46.1850,Cactushop to Kartris,Info,Importing 1 record(s) to tblKartrisRelatedProducts...
2014-08-22 11:34:46.1850,Cactushop to Kartris,Info,Done.Processing the rest of tblKartrisRelatedProducts...
2014-08-22 11:34:46.2470,Cactushop to Kartris,Info,Done.
2014-08-22 11:34:46.2470,Cactushop to Kartris,Info,There were 1 NEW record(s) added.
2014-08-22 11:34:46.2470,Cactushop to Kartris,Info,======================================================================
2014-08-22 11:34:47.0031,Cactushop to Kartris,Info,Importing 421 record(s) to tblKartrisProductCategoryLink...
2014-08-22 11:34:47.0051,Cactushop to Kartris,Info,Done.Processing the rest of tblKartrisProductCategoryLink...
2014-08-22 11:35:39.5704,Cactushop to Kartris,Info,Done.
2014-08-22 11:35:39.5814,Cactushop to Kartris,Info,There were 420 NEW record(s) added.
2014-08-22 11:35:39.5814,Cactushop to Kartris,Error,Failed in importing 1 records. See error details below...
2014-08-22 11:35:39.5814,Cactushop to Kartris,Info,======================================================================
2014-08-22 11:35:39.5814,Cactushop to Kartris,Error,"1. The INSERT statement conflicted with the FOREIGN KEY constraint ""FK_tblKartrisProductCategoryLink_tblKartrisProducts"". The conflict occurred in database ""dbKartrisStore"", table ""dbo.tblKartrisProducts"", column 'P_ID'.The statement has been terminated.ROW DETAILS:=============PCAT_ProductID = 637 PCAT_CategoryID = 115 PCAT_OrderNo =============="
2014-08-22 11:35:39.5814,Cactushop to Kartris,Info,======================================================================
2014-08-22 11:35:45.1859,Cactushop to Kartris,Info,Importing 1000 record(s) to tblKartrisLanguageElements...
2014-08-22 11:35:45.1859,Cactushop to Kartris,Info,Done.Processing the rest of tblKartrisLanguageElements...
2014-08-22 11:37:00.4784,Cactushop to Kartris,Info,Done.
2014-08-22 11:37:00.4864,Cactushop to Kartris,Info,There were 1000 NEW record(s) added.
2014-08-22 11:37:00.4864,Cactushop to Kartris,Info,======================================================================
2014-08-22 11:37:02.2046,Cactushop to Kartris,Info,Importing 525 record(s) to tblKartrisLanguageElements...
2014-08-22 11:37:02.2046,Cactushop to Kartris,Info,Done.Processing the rest of tblKartrisLanguageElements...
2014-08-22 11:37:28.1702,Cactushop to Kartris,Info,Done.
2014-08-22 11:37:28.1782,Cactushop to Kartris,Info,There were 525 NEW record(s) added.
2014-08-22 11:37:28.1782,Cactushop to Kartris,Info,======================================================================
2014-08-22 11:37:34.3398,Cactushop to Kartris,Info,Importing 1008 record(s) to tblKartrisLanguageElements...
2014-08-22 11:37:34.3398,Cactushop to Kartris,Info,Done.Processing the rest of tblKartrisLanguageElements...
2014-08-22 11:38:25.5319,Cactushop to Kartris,Info,Done.
2014-08-22 11:38:25.5419,Cactushop to Kartris,Info,There were 1008 NEW record(s) added.
2014-08-22 11:38:25.5419,Cactushop to Kartris,Info,======================================================================
2014-08-22 11:38:31.5525,Cactushop to Kartris,Info,Importing 1008 record(s) to tblKartrisLanguageElements...
2014-08-22 11:38:31.5525,Cactushop to Kartris,Info,Done.Processing the rest of tblKartrisLanguageElements...
2014-08-22 11:39:15.8170,Cactushop to Kartris,Info,Done.
2014-08-22 11:39:15.8230,Cactushop to Kartris,Info,There were 1008 NEW record(s) added.
2014-08-22 11:39:15.8230,Cactushop to Kartris,Info,======================================================================
2014-08-22 11:39:21.8336,Cactushop to Kartris,Info,Importing 1008 record(s) to tblKartrisLanguageElements...
2014-08-22 11:39:21.8336,Cactushop to Kartris,Info,Done.Processing the rest of tblKartrisLanguageElements...
2014-08-22 11:40:45.8840,Cactushop to Kartris,Info,Done.
2014-08-22 11:40:45.8890,Cactushop to Kartris,Info,There were 1008 NEW record(s) added.
2014-08-22 11:40:45.8890,Cactushop to Kartris,Info,======================================================================
2014-08-22 11:40:49.3533,Cactushop to Kartris,Info,Importing 576 record(s) to tblKartrisLanguageElements...
2014-08-22 11:40:49.3533,Cactushop to Kartris,Info,Done.Processing the rest of tblKartrisLanguageElements...
2014-08-22 11:41:40.3014,Cactushop to Kartris,Info,Done.
2014-08-22 11:41:40.3174,Cactushop to Kartris,Info,There were 576 NEW record(s) added.
2014-08-22 11:41:40.3174,Cactushop to Kartris,Info,======================================================================
2014-08-22 11:41:45.1249,Cactushop to Kartris,Info,Importing 1000 record(s) to tblKartrisLanguageElements...
2014-08-22 11:41:45.1249,Cactushop to Kartris,Info,Done.Processing the rest of tblKartrisLanguageElements...
2014-08-22 11:42:43.9498,Cactushop to Kartris,Info,Done.
2014-08-22 11:42:43.9528,Cactushop to Kartris,Info,There were 1000 NEW record(s) added.
2014-08-22 11:42:43.9528,Cactushop to Kartris,Info,======================================================================
2014-08-22 11:42:48.5552,Cactushop to Kartris,Info,Importing 1000 record(s) to tblKartrisLanguageElements...
2014-08-22 11:42:48.5552,Cactushop to Kartris,Info,Done.Processing the rest of tblKartrisLanguageElements...
2014-08-22 11:44:09.7324,Cactushop to Kartris,Info,Done.
2014-08-22 11:44:09.7414,Cactushop to Kartris,Info,There were 1000 NEW record(s) added.
2014-08-22 11:44:09.7414,Cactushop to Kartris,Info,======================================================================
2014-08-22 11:44:14.3718,Cactushop to Kartris,Info,Importing 1000 record(s) to tblKartrisLanguageElements...
2014-08-22 11:44:14.3748,Cactushop to Kartris,Info,Done.Processing the rest of tblKartrisLanguageElements...
2014-08-22 11:45:33.2967,Cactushop to Kartris,Info,Done.
2014-08-22 11:45:33.2997,Cactushop to Kartris,Info,There were 1000 NEW record(s) added.
2014-08-22 11:45:33.2997,Cactushop to Kartris,Info,======================================================================
2014-08-22 11:45:37.9412,Cactushop to Kartris,Info,Importing 1000 record(s) to tblKartrisLanguageElements...
2014-08-22 11:45:37.9412,Cactushop to Kartris,Info,Done.Processing the rest of tblKartrisLanguageElements...
2014-08-22 11:46:56.4580,Cactushop to Kartris,Info,Done.
2014-08-22 11:46:56.4670,Cactushop to Kartris,Info,There were 1000 NEW record(s) added.
2014-08-22 11:46:56.4670,Cactushop to Kartris,Info,======================================================================
2014-08-22 11:46:58.0342,Cactushop to Kartris,Info,Importing 330 record(s) to tblKartrisLanguageElements...
2014-08-22 11:46:58.0342,Cactushop to Kartris,Info,Done.Processing the rest of tblKartrisLanguageElements...
2014-08-22 11:47:12.3276,Cactushop to Kartris,Info,Done.
2014-08-22 11:47:12.3326,Cactushop to Kartris,Info,There were 330 NEW record(s) added.
2014-08-22 11:47:12.3326,Cactushop to Kartris,Info,======================================================================
2014-08-22 11:47:12.5916,Cactushop to Kartris,Info,Importing 30 record(s) to tblKartrisLanguageElements...
2014-08-22 11:47:12.5916,Cactushop to Kartris,Info,Done.Processing the rest of tblKartrisLanguageElements...
2014-08-22 11:47:14.8419,Cactushop to Kartris,Info,Done.
2014-08-22 11:47:14.8469,Cactushop to Kartris,Info,There were 30 NEW record(s) added.
2014-08-22 11:47:14.8469,Cactushop to Kartris,Info,======================================================================
2014-08-22 11:47:15.0789,Cactushop to Kartris,Info,Importing 45 record(s) to tblKartrisLanguageElements...
2014-08-22 11:47:15.0789,Cactushop to Kartris,Info,Done.Processing the rest of tblKartrisLanguageElements...
2014-08-22 11:47:18.7303,Cactushop to Kartris,Info,Done.
2014-08-22 11:47:18.7453,Cactushop to Kartris,Info,There were 45 NEW record(s) added.
2014-08-22 11:47:18.7453,Cactushop to Kartris,Info,======================================================================
2014-08-22 11:47:18.9633,Cactushop to Kartris,Info,Importing 30 record(s) to tblKartrisLanguageElements...
2014-08-22 11:47:18.9633,Cactushop to Kartris,Info,Done.Processing the rest of tblKartrisLanguageElements...
2014-08-22 11:47:20.5094,Cactushop to Kartris,Info,Done.
2014-08-22 11:47:20.5234,Cactushop to Kartris,Info,There were 30 NEW record(s) added.
2014-08-22 11:47:20.5234,Cactushop to Kartris,Info,======================================================================
2014-08-22 11:47:20.6535,Cactushop to Kartris,Info,Setting default values...
2014-08-22 11:47:31.5285,Cactushop to Kartris,Info,Done.
2014-08-22 11:47:31.5285,Cactushop to Kartris,Info,Starting image import...
2014-08-22 11:47:31.5285,Cactushop to Kartris,Info,"Processing ""\images_products_large\"" folder..."
2014-08-22 11:47:33.8158,Cactushop to Kartris,Info,Done.
2014-08-22 11:47:33.8158,Cactushop to Kartris,Info,"Processing ""\images_products\"" folder..."
2014-08-22 11:47:37.0281,Cactushop to Kartris,Info,Done.
2014-08-22 11:47:37.0281,Cactushop to Kartris,Info,"Processing ""\images_categories_large\"" folder..."
2014-08-22 11:47:37.1401,Cactushop to Kartris,Info,Done.
2014-08-22 11:47:37.1401,Cactushop to Kartris,Info,"Processing ""\images_categories\"" folder..."
2014-08-22 11:47:37.3871,Cactushop to Kartris,Info,Done.
2014-08-22 11:47:37.3871,Cactushop to Kartris,Info,"Processing ""\images_versions_large"" folder..."
2014-08-22 11:47:44.6429,Cactushop to Kartris,Error,!Error in processing C:\inetpub\wwwroot\www.abcstore.co.uk\IMPORT\images_versions_large\850.jpg --- Conversion from type 'DBNull' to type 'Integer' is not valid.
2014-08-22 11:47:45.5679,Cactushop to Kartris,Info,Done.
2014-08-22 11:47:45.5679,Cactushop to Kartris,Info,"Processing ""\images_versions"" folder..."
2014-08-22 11:47:52.4116,Cactushop to Kartris,Error,!Error in processing C:\inetpub\wwwroot\www.abcstore.co.uk\IMPORT\images_versions\850.jpg --- Conversion from type 'DBNull' to type 'Integer' is not valid.
2014-08-22 11:47:52.6587,Cactushop to Kartris,Info,Done.
2014-08-22 11:47:52.6597,Cactushop to Kartris,Info,Image import done!
2014-08-22 11:47:52.6757,Cactushop to Kartris,Info, ====== Data Upgrade finished on 22/08/2014 11:47:52. Total Elapsed Time: 13.63 mins. ======


Similar Topics

Expand / Collapse

Reading This Topic

Expand / Collapse

Back To Top