Data tool import - completed with errors

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. ======

Thanks Tiggywiggler

I went through the Cactus CMS deleting products that had the null values and making sure out of range integers were set to something in range.

The import now falls over with hundreds of foreign key conflicts. No idea why. This is running against a brand new Kartris install. Have tried full import and product data only import.

Thanks,
Simon

Here is just one part of one section (9/433 error lines for the specified table)

Time,Logger,Level,Message
2014-08-26 10:59:49.1262,Cactushop to Kartris,Info, ======= Database:Cactushop >> Database:dbKartrisStore =======
2014-08-26 10:59:49.1472,Cactushop to Kartris,Info, ======= Data Upgrade Started on 26/08/2014 10:59:49... ========
2014-08-26 10:59:49.1472,Cactushop to Kartris,Info,Clearing Kartris database product data...
2014-08-26 10:59:53.5156,Cactushop to Kartris,Info,Done.
2014-08-26 10:59:53.7076,Cactushop to Kartris,Info,Importing 61 record(s) to tblKartrisCategories...
2014-08-26 10:59:53.7076,Cactushop to Kartris,Info,Done.Processing the rest of tblKartrisCategories...
2014-08-26 10:59:57.2760,Cactushop to Kartris,Info,Done.
2014-08-26 10:59:57.2760,Cactushop to Kartris,Info,There were 61 NEW record(s) added.
2014-08-26 10:59:57.2760,Cactushop to Kartris,Info,======================================================================
2014-08-26 10:59:57.5310,Cactushop to Kartris,Info,Importing 100 record(s) to tblKartrisProducts...
2014-08-26 10:59:57.5310,Cactushop to Kartris,Info,Done.Processing the rest of tblKartrisProducts...
2014-08-26 11:00:03.3566,Cactushop to Kartris,Info,Done.
2014-08-26 11:00:08.1841,Cactushop to Kartris,Info,There were 100 NEW record(s) added.
2014-08-26 11:00:08.1841,Cactushop to Kartris,Info,======================================================================
2014-08-26 11:00:08.4891,Cactushop to Kartris,Error,Skipping tblCactuShop10027Versions...
2014-08-26 11:00:08.4891,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-26 11:00:08.4911,Cactushop to Kartris,Error,"
======================================================================"
2014-08-26 11:00:09.1122,Cactushop to Kartris,Info,Importing 433 record(s) to tblKartrisVersions...
2014-08-26 11:00:09.1122,Cactushop to Kartris,Info,Done.Processing the rest of tblKartrisVersions...
2014-08-26 11:00:11.0964,Cactushop to Kartris,Error,Failed. No records imported for this table. See individual row error details below...
2014-08-26 11:00:11.1134,Cactushop to Kartris,Info,======================================================================
2014-08-26 11:00:11.1134,Cactushop to Kartris,Error,"1. The INSERT statement conflicted with the FOREIGN KEY constraint ""FK_tblKartrisVersions_tblKartrisTaxRates"". The conflict occurred in database ""dbKartrisStore"", table ""dbo.tblKartrisTaxRates"", column 'T_ID'.The statement has been terminated.ROW DETAILS:=============V_ID = 441 V_CodeNumber = 104511-78780 V_ProductID = 426 V_Price = 12 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 = 0 V_RRP = 0 V_Type = v V_CustomerGroupID = V_CustomizationType = V_CustomizationDesc = V_CustomizationCost = 0 V_Tax2 = V_TaxExtra =============="
2014-08-26 11:00:11.1134,Cactushop to Kartris,Error,"2. The INSERT statement conflicted with the FOREIGN KEY constraint ""FK_tblKartrisVersions_tblKartrisTaxRates"". The conflict occurred in database ""dbKartrisStore"", table ""dbo.tblKartrisTaxRates"", column 'T_ID'.The statement has been terminated.ROW DETAILS:=============V_ID = 442 V_CodeNumber = 128270-12540 V_ProductID = 427 V_Price = 32.7 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 = 0 V_RRP = 0 V_Type = v V_CustomerGroupID = V_CustomizationType = V_CustomizationDesc = V_CustomizationCost = 0 V_Tax2 = V_TaxExtra =============="
2014-08-26 11:00:11.1134,Cactushop to Kartris,Error,"3. The INSERT statement conflicted with the FOREIGN KEY constraint ""FK_tblKartrisVersions_tblKartrisTaxRates"". The conflict occurred in database ""dbKartrisStore"", table ""dbo.tblKartrisTaxRates"", column 'T_ID'.The statement has been terminated.ROW DETAILS:=============V_ID = 443 V_CodeNumber = 104500-55710 V_ProductID = 428 V_Price = 8.2 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 = 0 V_RRP = 0 V_Type = v V_CustomerGroupID = V_CustomizationType = V_CustomizationDesc = V_CustomizationCost = 0 V_Tax2 = V_TaxExtra =============="
2014-08-26 11:00:11.1134,Cactushop to Kartris,Error,"4. The INSERT statement conflicted with the FOREIGN KEY constraint ""FK_tblKartrisVersions_tblKartrisTaxRates"". The conflict occurred in database ""dbKartrisStore"", table ""dbo.tblKartrisTaxRates"", column 'T_ID'.The statement has been terminated.ROW DETAILS:=============V_ID = 445 V_CodeNumber = 27210-200200 V_ProductID = 430 V_Price = 5.3 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 = 1 V_RRP = 0 V_Type = v V_CustomerGroupID = V_CustomizationType = V_CustomizationDesc = V_CustomizationCost = 0 V_Tax2 = V_TaxExtra =============="
2014-08-26 11:00:11.1134,Cactushop to Kartris,Error,"5. The INSERT statement conflicted with the FOREIGN KEY constraint ""FK_tblKartrisVersions_tblKartrisTaxRates"". The conflict occurred in database ""dbKartrisStore"", table ""dbo.tblKartrisTaxRates"", column 'T_ID'.The statement has been terminated.ROW DETAILS:=============V_ID = 449 V_CodeNumber = 119305-35151 V_ProductID = 434 V_Price = 8.9 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 = 0 V_RRP = 0 V_Type = v V_CustomerGroupID = V_CustomizationType = V_CustomizationDesc = V_CustomizationCost = 0 V_Tax2 = V_TaxExtra =============="
2014-08-26 11:00:11.1134,Cactushop to Kartris,Error,"6. The INSERT statement conflicted with the FOREIGN KEY constraint ""FK_tblKartrisVersions_tblKartrisTaxRates"". The conflict occurred in database ""dbKartrisStore"", table ""dbo.tblKartrisTaxRates"", column 'T_ID'.The statement has been terminated.ROW DETAILS:=============V_ID = 450 V_CodeNumber = 128170-77350 V_ProductID = 435 V_Price = 12.3 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 = 29 V_RRP = 0 V_Type = v V_CustomerGroupID = V_CustomizationType = V_CustomizationDesc = V_CustomizationCost = 0 V_Tax2 = V_TaxExtra =============="
2014-08-26 11:00:11.1134,Cactushop to Kartris,Error,"7. The INSERT statement conflicted with the FOREIGN KEY constraint ""FK_tblKartrisVersions_tblKartrisTaxRates"". The conflict occurred in database ""dbKartrisStore"", table ""dbo.tblKartrisTaxRates"", column 'T_ID'.The statement has been terminated.ROW DETAILS:=============V_ID = 452 V_CodeNumber = 128176-42071 V_ProductID = 437 V_Price = 17.8 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 = 1 V_RRP = 0 V_Type = v V_CustomerGroupID = V_CustomizationType = V_CustomizationDesc = V_CustomizationCost = 0 V_Tax2 = V_TaxExtra =============="
2014-08-26 11:00:11.1274,Cactushop to Kartris,Error,"8. The INSERT statement conflicted with the FOREIGN KEY constraint ""FK_tblKartrisVersions_tblKartrisTaxRates"". The conflict occurred in database ""dbKartrisStore"", table ""dbo.tblKartrisTaxRates"", column 'T_ID'.The statement has been terminated.ROW DETAILS:=============V_ID = 454 V_CodeNumber = 104211-42071 V_ProductID = 439 V_Price = 25.8 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 = 1 V_RRP = 0 V_Type = v V_CustomerGroupID = V_CustomizationType = V_CustomizationDesc = V_CustomizationCost = 0 V_Tax2 = V_TaxExtra =============="
2014-08-26 11:00:11.1274,Cactushop to Kartris,Error,"9. The INSERT statement conflicted with the FOREIGN KEY constraint ""FK_tblKartrisVersions_tblKartrisTaxRates"". The conflict occurred in database ""dbKartrisStore"", table ""dbo.tblKartrisTaxRates"", column 'T_ID'.The statement has been terminated.ROW DETAILS:=============V_ID = 457 V_CodeNumber = STM0051 V_ProductID = 442 V_Price = 11.25 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 = 0 V_RRP = 0 V_Type = v V_CustomerGroupID = V_CustomizationType = V_CustomizationDesc = V_CustomizationCost = 0 V_Tax2 = V_TaxExtra =============="

Author	Message
simonrl	Posted Fri 22 Aug 2014
Supreme Being Group: Forum Members Last Active: Tue 23 Feb 2021 Posts: 18, Visits: 88 12,886	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. ======
	REPLY QUOTE LIKE 480
Tiggywiggler	Posted Fri 22 Aug 2014
Supreme Being Group: Forum Members Last Active: Mon 6 Dec 2021 Posts: 235, Visits: 750 124,052	It looks like your import has failed for various reasons, the most common being integers being out of range (above 32768) and some null columns. When Kartris is attempting to read data from one of these failed import rows it is throwing an error. The Object reference not set to an instance of an object. error relates to a null object reference which tends to mean that somewhere in the system Kartris is not validating its data correctly. To see where this error is coming from you need to read the logs in Kartris (see http://userguide.kartris.com/Default.aspx?headID=93) We are always willing to help out the community or pitch in to help you fix a problem. However, if you want a complete solution made such as a code module or new feature added you have two options. Either 1) Reach out to the Kartris internal development team at http://www.kartris.com/Contact.aspx. 2) Contact one of the Kartris approved partners at http://www.kartris.com/t-Worldwide-Developers.aspx. Have fun and good luck coding.
	REPLY QUOTE LIKE 468
simonrl	Posted Tue 26 Aug 2014
Supreme Being Group: Forum Members Last Active: Tue 23 Feb 2021 Posts: 18, Visits: 88 12,886	Thanks Tiggywiggler I went through the Cactus CMS deleting products that had the null values and making sure out of range integers were set to something in range. The import now falls over with hundreds of foreign key conflicts. No idea why. This is running against a brand new Kartris install. Have tried full import and product data only import. Thanks, Simon Here is just one part of one section (9/433 error lines for the specified table) Time,Logger,Level,Message 2014-08-26 10:59:49.1262,Cactushop to Kartris,Info, ======= Database:Cactushop >> Database:dbKartrisStore ======= 2014-08-26 10:59:49.1472,Cactushop to Kartris,Info, ======= Data Upgrade Started on 26/08/2014 10:59:49... ======== 2014-08-26 10:59:49.1472,Cactushop to Kartris,Info,Clearing Kartris database product data... 2014-08-26 10:59:53.5156,Cactushop to Kartris,Info,Done. 2014-08-26 10:59:53.7076,Cactushop to Kartris,Info,Importing 61 record(s) to tblKartrisCategories... 2014-08-26 10:59:53.7076,Cactushop to Kartris,Info,Done.Processing the rest of tblKartrisCategories... 2014-08-26 10:59:57.2760,Cactushop to Kartris,Info,Done. 2014-08-26 10:59:57.2760,Cactushop to Kartris,Info,There were 61 NEW record(s) added. 2014-08-26 10:59:57.2760,Cactushop to Kartris,Info,====================================================================== 2014-08-26 10:59:57.5310,Cactushop to Kartris,Info,Importing 100 record(s) to tblKartrisProducts... 2014-08-26 10:59:57.5310,Cactushop to Kartris,Info,Done.Processing the rest of tblKartrisProducts... 2014-08-26 11:00:03.3566,Cactushop to Kartris,Info,Done. 2014-08-26 11:00:08.1841,Cactushop to Kartris,Info,There were 100 NEW record(s) added. 2014-08-26 11:00:08.1841,Cactushop to Kartris,Info,====================================================================== 2014-08-26 11:00:08.4891,Cactushop to Kartris,Error,Skipping tblCactuShop10027Versions... 2014-08-26 11:00:08.4891,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-26 11:00:08.4911,Cactushop to Kartris,Error," ======================================================================" 2014-08-26 11:00:09.1122,Cactushop to Kartris,Info,Importing 433 record(s) to tblKartrisVersions... 2014-08-26 11:00:09.1122,Cactushop to Kartris,Info,Done.Processing the rest of tblKartrisVersions... 2014-08-26 11:00:11.0964,Cactushop to Kartris,Error,Failed. No records imported for this table. See individual row error details below... 2014-08-26 11:00:11.1134,Cactushop to Kartris,Info,====================================================================== 2014-08-26 11:00:11.1134,Cactushop to Kartris,Error,"1. The INSERT statement conflicted with the FOREIGN KEY constraint ""FK_tblKartrisVersions_tblKartrisTaxRates"". The conflict occurred in database ""dbKartrisStore"", table ""dbo.tblKartrisTaxRates"", column 'T_ID'.The statement has been terminated.ROW DETAILS:=============V_ID = 441 V_CodeNumber = 104511-78780 V_ProductID = 426 V_Price = 12 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 = 0 V_RRP = 0 V_Type = v V_CustomerGroupID = V_CustomizationType = V_CustomizationDesc = V_CustomizationCost = 0 V_Tax2 = V_TaxExtra ==============" 2014-08-26 11:00:11.1134,Cactushop to Kartris,Error,"2. The INSERT statement conflicted with the FOREIGN KEY constraint ""FK_tblKartrisVersions_tblKartrisTaxRates"". The conflict occurred in database ""dbKartrisStore"", table ""dbo.tblKartrisTaxRates"", column 'T_ID'.The statement has been terminated.ROW DETAILS:=============V_ID = 442 V_CodeNumber = 128270-12540 V_ProductID = 427 V_Price = 32.7 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 = 0 V_RRP = 0 V_Type = v V_CustomerGroupID = V_CustomizationType = V_CustomizationDesc = V_CustomizationCost = 0 V_Tax2 = V_TaxExtra ==============" 2014-08-26 11:00:11.1134,Cactushop to Kartris,Error,"3. The INSERT statement conflicted with the FOREIGN KEY constraint ""FK_tblKartrisVersions_tblKartrisTaxRates"". The conflict occurred in database ""dbKartrisStore"", table ""dbo.tblKartrisTaxRates"", column 'T_ID'.The statement has been terminated.ROW DETAILS:=============V_ID = 443 V_CodeNumber = 104500-55710 V_ProductID = 428 V_Price = 8.2 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 = 0 V_RRP = 0 V_Type = v V_CustomerGroupID = V_CustomizationType = V_CustomizationDesc = V_CustomizationCost = 0 V_Tax2 = V_TaxExtra ==============" 2014-08-26 11:00:11.1134,Cactushop to Kartris,Error,"4. The INSERT statement conflicted with the FOREIGN KEY constraint ""FK_tblKartrisVersions_tblKartrisTaxRates"". The conflict occurred in database ""dbKartrisStore"", table ""dbo.tblKartrisTaxRates"", column 'T_ID'.The statement has been terminated.ROW DETAILS:=============V_ID = 445 V_CodeNumber = 27210-200200 V_ProductID = 430 V_Price = 5.3 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 = 1 V_RRP = 0 V_Type = v V_CustomerGroupID = V_CustomizationType = V_CustomizationDesc = V_CustomizationCost = 0 V_Tax2 = V_TaxExtra ==============" 2014-08-26 11:00:11.1134,Cactushop to Kartris,Error,"5. The INSERT statement conflicted with the FOREIGN KEY constraint ""FK_tblKartrisVersions_tblKartrisTaxRates"". The conflict occurred in database ""dbKartrisStore"", table ""dbo.tblKartrisTaxRates"", column 'T_ID'.The statement has been terminated.ROW DETAILS:=============V_ID = 449 V_CodeNumber = 119305-35151 V_ProductID = 434 V_Price = 8.9 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 = 0 V_RRP = 0 V_Type = v V_CustomerGroupID = V_CustomizationType = V_CustomizationDesc = V_CustomizationCost = 0 V_Tax2 = V_TaxExtra ==============" 2014-08-26 11:00:11.1134,Cactushop to Kartris,Error,"6. The INSERT statement conflicted with the FOREIGN KEY constraint ""FK_tblKartrisVersions_tblKartrisTaxRates"". The conflict occurred in database ""dbKartrisStore"", table ""dbo.tblKartrisTaxRates"", column 'T_ID'.The statement has been terminated.ROW DETAILS:=============V_ID = 450 V_CodeNumber = 128170-77350 V_ProductID = 435 V_Price = 12.3 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 = 29 V_RRP = 0 V_Type = v V_CustomerGroupID = V_CustomizationType = V_CustomizationDesc = V_CustomizationCost = 0 V_Tax2 = V_TaxExtra ==============" 2014-08-26 11:00:11.1134,Cactushop to Kartris,Error,"7. The INSERT statement conflicted with the FOREIGN KEY constraint ""FK_tblKartrisVersions_tblKartrisTaxRates"". The conflict occurred in database ""dbKartrisStore"", table ""dbo.tblKartrisTaxRates"", column 'T_ID'.The statement has been terminated.ROW DETAILS:=============V_ID = 452 V_CodeNumber = 128176-42071 V_ProductID = 437 V_Price = 17.8 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 = 1 V_RRP = 0 V_Type = v V_CustomerGroupID = V_CustomizationType = V_CustomizationDesc = V_CustomizationCost = 0 V_Tax2 = V_TaxExtra ==============" 2014-08-26 11:00:11.1274,Cactushop to Kartris,Error,"8. The INSERT statement conflicted with the FOREIGN KEY constraint ""FK_tblKartrisVersions_tblKartrisTaxRates"". The conflict occurred in database ""dbKartrisStore"", table ""dbo.tblKartrisTaxRates"", column 'T_ID'.The statement has been terminated.ROW DETAILS:=============V_ID = 454 V_CodeNumber = 104211-42071 V_ProductID = 439 V_Price = 25.8 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 = 1 V_RRP = 0 V_Type = v V_CustomerGroupID = V_CustomizationType = V_CustomizationDesc = V_CustomizationCost = 0 V_Tax2 = V_TaxExtra ==============" 2014-08-26 11:00:11.1274,Cactushop to Kartris,Error,"9. The INSERT statement conflicted with the FOREIGN KEY constraint ""FK_tblKartrisVersions_tblKartrisTaxRates"". The conflict occurred in database ""dbKartrisStore"", table ""dbo.tblKartrisTaxRates"", column 'T_ID'.The statement has been terminated.ROW DETAILS:=============V_ID = 457 V_CodeNumber = STM0051 V_ProductID = 442 V_Price = 11.25 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 = 0 V_RRP = 0 V_Type = v V_CustomerGroupID = V_CustomizationType = V_CustomizationDesc = V_CustomizationCost = 0 V_Tax2 = V_TaxExtra ==============" Edited Tue 26 Aug 2014 by simonrl
	REPLY QUOTE LIKE 467
Tiggywiggler	Posted Tue 26 Aug 2014
Supreme Being Group: Forum Members Last Active: Mon 6 Dec 2021 Posts: 235, Visits: 750 124,052	Hello, Your list of errors point to the tax rates table. It is saying taht it cannot import the products becuase thier assigned tax rate is not actually in the tax rates table. can you check to see if all of the tax ratesa re in the tax rate table and if not can you find the part of the error log that points to insert errors on the tax rate table please? We are always willing to help out the community or pitch in to help you fix a problem. However, if you want a complete solution made such as a code module or new feature added you have two options. Either 1) Reach out to the Kartris internal development team at http://www.kartris.com/Contact.aspx. 2) Contact one of the Kartris approved partners at http://www.kartris.com/t-Worldwide-Developers.aspx. Have fun and good luck coding.
	REPLY QUOTE LIKE 472
simonrl	Posted Tue 26 Aug 2014
Supreme Being Group: Forum Members Last Active: Tue 23 Feb 2021 Posts: 18, Visits: 88 12,886	Thanks. The originating Cactus database has T_ID values of 12 and 13 for the tax rates that corresponded with 2 and 1 respectively in the Kartris data. So I changed those to match and now the tax rates import correctly. Getting there, thank you for your help! Edited Tue 26 Aug 2014 by simonrl
	REPLY QUOTE LIKE 434
Tiggywiggler	Posted Tue 26 Aug 2014
Supreme Being Group: Forum Members Last Active: Mon 6 Dec 2021 Posts: 235, Visits: 750 124,052	Simon, You just posted a snag regarding language elements and I had written a reply but it now appears that you have deleted your snag. Has the problem been resolved please? We are always willing to help out the community or pitch in to help you fix a problem. However, if you want a complete solution made such as a code module or new feature added you have two options. Either 1) Reach out to the Kartris internal development team at http://www.kartris.com/Contact.aspx. 2) Contact one of the Kartris approved partners at http://www.kartris.com/t-Worldwide-Developers.aspx. Have fun and good luck coding.
	REPLY QUOTE LIKE 454
simonrl	Posted Tue 26 Aug 2014
Supreme Being Group: Forum Members Last Active: Tue 23 Feb 2021 Posts: 18, Visits: 88 12,886	Sort of... I was getting lots and lots of errors like this: 2014-08-26 13:11:10.2605,Cactushop to Kartris,Info,Importing 1000 record(s) to tblKartrisLanguageElements... 2014-08-26 13:11:10.2605,Cactushop to Kartris,Info,Done.Processing the rest of tblKartrisLanguageElements... 2014-08-26 13:11:17.7573,Cactushop to Kartris,Info,Done. 2014-08-26 13:11:17.7593,Cactushop to Kartris,Info,There were 200 NEW record(s) added. 2014-08-26 13:11:17.7593,Cactushop to Kartris,Error,Failed in importing 800 records. See error details below... 2014-08-26 13:11:17.7593,Cactushop to Kartris,Info,====================================================================== 2014-08-26 13:11:17.7593,Cactushop to Kartris,Error,"1. The INSERT statement conflicted with the FOREIGN KEY constraint ""FK_tblKartrisLanguageElements_tblKartrisLanguages"". The conflict occurred in database ""dbKartrisStore"", table ""dbo.tblKartrisLanguages"", column 'LANG_ID'.The statement has been terminated.ROW DETAILS:=============LE_LanguageID = 2 LE_TypeID = 3 LE_FieldID = 1 LE_ParentID = 109 LE_Value = LE_ID = -6=============" I then realise that the number of rows failing was exactly 4/5 of the rows cited so it was trying to import Cactus languages 2, 3, 4 and 5 when the originating data has only 1 language. Both originating Cactus database and target Kartris database have only 1 language record; English of LANG_ID = 1. Seems a bit odd. But the import does at least seem to have worked. Is this behaviour of the data tool to be expected / and nothing to worry about? Thanks, Simon
	REPLY QUOTE LIKE 467
Tiggywiggler	Posted Tue 26 Aug 2014
Supreme Being Group: Forum Members Last Active: Mon 6 Dec 2021 Posts: 235, Visits: 750 124,052	The problem was because the import tool was expecting your language to have ID = 2 and your language had ID = 1. The data tool doesn't seem to have been coded to import correctly because primary key references like this really ought to be maintained during an import. I am sure someone will notice this and fix it in a later revision. Personally I am waiting for version 3.0.0 to come out and see what happens then. We are always willing to help out the community or pitch in to help you fix a problem. However, if you want a complete solution made such as a code module or new feature added you have two options. Either 1) Reach out to the Kartris internal development team at http://www.kartris.com/Contact.aspx. 2) Contact one of the Kartris approved partners at http://www.kartris.com/t-Worldwide-Developers.aspx. Have fun and good luck coding.
	REPLY QUOTE LIKE 490
simonrl	Posted Tue 26 Aug 2014
Supreme Being Group: Forum Members Last Active: Tue 23 Feb 2021 Posts: 18, Visits: 88 12,886	Agreed. But there would be no language ID = 2 since the site only has one language (ID = 1) However it did import language ID = 1 correctly. But then it looped through language ID = 2, 3, 4 and 5, attempting to write strings of (presumably) the same ID (hence the primary key conflict and the thousands of error lines). What it would have done if it had found data for language ID 2, 3, 4 and 5 I have no idea! Thanks for all your help. I think I've got enough data transferred to make a usable site.
	REPLY QUOTE LIKE 470

Data tool import - completed with errors

Data tool import - completed with errors

Similar Topics

Reading This Topic