|
By Ardik - Mon 7 Oct 2013
|
Another Update (2013-10-20): I've tried again completely form the start with the same results. Please see my separate post in this thread where I tried to document as completely as possible.
Update: The headline issue (timeout) is resolved and was of no importance.
A slightly different but fatal error (NullReferenceException at PageBaseClass.InitializeCulture) remains after several new installation attempts even on different servers.
I'll post a new issue tomorrow and will delete this one then.
Right now I just want to indicate there's no need to waste anyone's time with this one ...
Original Post:
I'm importing from cactushop 6 to kartris 2.5
The main import process (full import) took some 12 hours but seemed to work without problems (and the new db appears to be well populated).
But at the end, when the tool reports "Setting default values..." it fails with an error popup informing me about a server timeout.
The logfile doesn't show any error, though:
Setting default values...
====== Data Upgrade finished on 07.10.2013 13:29:53. Total Elapsed Time: 59,72 mins. ======
(this log is from a 2nd try when I only imported product related data to save time.)
I have no idea where I could adjust timeout settings (presumably it's timeout settings in the Data Tool?).
any suggestions are highly appreciated.
(I admit, I *could* try running the tool directly on the database server, but I hesitate to install .NET 4.0 *only* to be able to run the data tool there. If there are other sensible alternatives I'd prefer them.)
ETA:
1. both databases are MSSQL
2. When I then try to access the store I get an argumentNullException (while the blank new store was well accessable):
-----------------------------------------------------------------------------
>> Unhandled Error occurred in Page:http://store.bookcrossing.com/Admin/_Default.aspx
-----------------------------------------------------------------------------
>> 07.10.2013 14:24:50
>> Version:2,5005
>> URL:http://store.bookcrossing.com/Admin/_Default.aspx
>> 93.198.17.60
>> DESCRIPTION:
System.ArgumentNullException: String reference not set to an instance of a String.
Parameter name: name
at System.Globalization.CultureInfo..ctor(String name, Boolean useUserOverride)
at _PageBaseClass.InitializeCulture()
at ASP.admin__default_aspx.__BuildControlTree(admin__default_aspx __ctrl)
at ASP.admin__default_aspx.FrameworkInitialize()
at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest()
at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
at System.Web.UI.Page.ProcessRequest(HttpContext context)
at ASP.admin__default_aspx.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
Many thanks,
Ardik
|
|
By Paul - Wed 9 Oct 2013
|
|
Would be handy if you could say what the timeout was, even if you feel it's not important or it's not related to kartris. It might help someone else, so that information is always useful to have recorded. Even if you feel it was a silly error on your part, chances are someone else may well do the same and might benefit from your post.
|
|
By Paul - Mon 14 Oct 2013
|
|
I think the 'string reference not set' issue is because there aren't the right permissions to read data from the database, even if the connection is ok.
|
|
By Ardik - Sun 20 Oct 2013
|
I apologize for the delay on my end.
The timeout message was highly unspecific. As far as I remember it was nothing but "A timeout error has occurred." (or similar wording) and I couldn't find further details in log files (I may have missed certain log files?). Otherwise I would have bothered quoting the full message (as I usually consider this standard procedure).
I abandoned the idea of reproducing it once more since that would again require a many-hours-import-process.
As for the other error message I meanwhile suspect that the database scheme might not have been created completely (since there was another timeout during the katris setup when the db was built - I had forgotten about this at first place). In a certain environment this is highly reproducible. I'll create a separate thread about this in the appropriate forum
|
|
By Ardik - Sun 20 Oct 2013
|
I started anew and ended up with the same issue.
Here it is, now as completely documented as possible (I think).
Cactushop db lives remotely (MSSQL Server 2008).
Kartris installation, kartris db and Data Tool all live on localhost (Win / MSSQL 2008 R2).
Installation went almost smoothly (only stumbled a bit when it came to saving web.config. Not just telling me to download it but showing an empty error, too. Possibly it got confused because it *did* have all right on the file - but IIS had locked it? whatever.
I could access front and back end and successfully created cat / prod / version which then was visible on the front end. Also I could update currency rates and this reflected on the front end. I didn't test further.
I started Data Tool to import from cactushop: full data upgrade, no password encryption, no import of images.
It started with a somewhat strange message about missing cursors (see first attachment). I didn't worry but assumed the Tool tries to clean up a database that's already empty.
The import process is running apparently smoothly for about an hour until the very end when, while "Setting default values..." a vague Timeout message appears (see 2nd attachment).
After confirming the message the process instantly finishes with a final message "Transfer finished with errors" (3rd attachment).
Searching the Data Tool log for "error" shows a few hits close to the very beginning, all included in the following snippet:
Time;Logger;Level;Message
2013-10-20 18:31:08.4559;Cactushop to Kartris;Info; ======= Database:Cactushop >> Database:BookCrossingStore2 =======
2013-10-20 18:31:08.4659;Cactushop to Kartris;Info; ======= Data Upgrade Started on 20.10.2013 18:31:08... ========
2013-10-20 18:31:08.4659;Cactushop to Kartris;Info;Clearing product data...
2013-10-20 18:31:08.9780;Cactushop to Kartris;Info;Done.
2013-10-20 18:31:08.9780;Cactushop to Kartris;Info;Clearing order data...
2013-10-20 18:31:09.1080;Cactushop to Kartris;Info;Done.
2013-10-20 18:31:09.1080;Cactushop to Kartris;Info;Clearing session data...
2013-10-20 18:31:09.1670;Cactushop to Kartris;Info;Done.
2013-10-20 18:31:09.1670;Cactushop to Kartris;Info;Clearing content data...
2013-10-20 18:31:20.8883;Cactushop to Kartris;Info;Done.
2013-10-20 18:31:21.4984;Cactushop to Kartris;Info;Importing 5 record(s) to tblKartrisLanguages...
2013-10-20 18:31:21.4984;Cactushop to Kartris;Info;Done.Processing the rest of tblKartrisLanguages...
2013-10-20 18:31:21.5684;Cactushop to Kartris;Info;Done.
2013-10-20 18:31:21.5834;Cactushop to Kartris;Info;There were 1 EXISTING record(s) updated.
2013-10-20 18:31:21.5834;Cactushop to Kartris;Info;There were 4 NEW record(s) added.
2013-10-20 18:31:21.5834;Cactushop to Kartris;Info;======================================================================
2013-10-20 18:31:21.8635;Cactushop to Kartris;Info;Importing 4 record(s) to tblKartrisTaxRates...
2013-10-20 18:31:21.8635;Cactushop to Kartris;Info;Done.Processing the rest of tblKartrisTaxRates...
2013-10-20 18:31:21.8895;Cactushop to Kartris;Info;Done.
2013-10-20 18:31:21.8895;Cactushop to Kartris;Info;There were 4 EXISTING record(s) updated.
2013-10-20 18:31:21.8895;Cactushop to Kartris;Info;======================================================================
2013-10-20 18:31:22.1615;Cactushop to Kartris;Error;Error while transfering data from tblKartrisCurrencies...
2013-10-20 18:31:22.1615;Cactushop to Kartris;Error;Column 'CUR_OrderNo' does not belong to table tblKartrisCurrencies.
2013-10-20 18:31:22.1615;Cactushop to Kartris;Error;"
======================================================================"
2013-10-20 18:31:22.3646;Cactushop to Kartris;Info;Importing 1 record(s) to tblKartrisShippingMethods...
2013-10-20 18:31:22.3646;Cactushop to Kartris;Info;Done.Processing the rest of tblKartrisShippingMethods...
2013-10-20 18:31:22.3876;Cactushop to Kartris;Info;Done.
2013-10-20 18:31:22.3946;Cactushop to Kartris;Info;There were 1 NEW record(s) added.
2013-10-20 18:31:22.3946;Cactushop to Kartris;Info;======================================================================
2013-10-20 18:31:22.6166;Cactushop to Kartris;Error;Skipping tblCactuShop1ShippingZones...
2013-10-20 18:31:22.6166;Cactushop to Kartris;Error;Object reference not set to an instance of an object.
2013-10-20 18:31:22.6166;Cactushop to Kartris;Error;"
======================================================================"
2013-10-20 18:31:22.6166;Cactushop to Kartris;Info;Importing 2 record(s) to tblKartrisShippingZones...
2013-10-20 18:31:22.6166;Cactushop to Kartris;Info;Done.Processing the rest of tblKartrisShippingZones...
2013-10-20 18:31:22.6346;Cactushop to Kartris;Info;Done.
2013-10-20 18:31:22.6346;Cactushop to Kartris;Info;There were 1 EXISTING record(s) updated.
2013-10-20 18:31:22.6346;Cactushop to Kartris;Info;There were 1 NEW record(s) added.
2013-10-20 18:31:22.6346;Cactushop to Kartris;Info;======================================================================
2013-10-20 18:31:23.8577;Cactushop to Kartris;Info;Importing 246 record(s) to tblKartrisDestination...
2013-10-20 18:31:23.8617;Cactushop to Kartris;Info;Done.Processing the rest of tblKartrisDestination...
2013-10-20 18:31:24.0507;Cactushop to Kartris;Info;Done.
2013-10-20 18:31:24.0647;Cactushop to Kartris;Info;There were 202 EXISTING record(s) updated.
2013-10-20 18:31:24.0647;Cactushop to Kartris;Info;There were 44 NEW record(s) added.
2013-10-20 18:31:24.0647;Cactushop to Kartris;Info;======================================================================
2013-10-20 18:31:25.0488;Cactushop to Kartris;Info;Importing 6 record(s) to tblKartrisShippingRates...
2013-10-20 18:31:25.0488;Cactushop to Kartris;Info;Done.Processing the rest of tblKartrisShippingRates...
2013-10-20 18:31:25.0708;Cactushop to Kartris;Info;Done.
2013-10-20 18:31:25.0708;Cactushop to Kartris;Info;There were 6 NEW record(s) added.
[...]
And this is the very end of the log:
[...]
2013-10-20 19:31:50.9339;Cactushop to Kartris;Info;Importing 520 record(s) to tblKartrisLanguageElements...
2013-10-20 19:31:50.9539;Cactushop to Kartris;Info;Done.Processing the rest of tblKartrisLanguageElements...
2013-10-20 19:31:51.2919;Cactushop to Kartris;Info;Done.
2013-10-20 19:31:51.3079;Cactushop to Kartris;Info;There were 520 NEW record(s) added.
2013-10-20 19:31:51.3079;Cactushop to Kartris;Info;======================================================================
2013-10-20 19:31:51.3429;Cactushop to Kartris;Info;Setting default values...
2013-10-20 19:35:15.8046;Cactushop to Kartris;Info; ====== Data Upgrade finished on 20.10.2013 19:35:15. Total Elapsed Time: 64,12 mins. ======
When I then try to access the store front I get an "Oops" and the log "2013.10.20.config" tells me:
-----------------------------------------------------------------------------
>> Unhandled Error occurred in Page:http://store.bookcrossing.com/default.aspx
-----------------------------------------------------------------------------
>> 20.10.2013 19:37:10
>> Version:2,5005
>> URL:http://store.bookcrossing.com/default.aspx
>> 93.198.53.203
>> DESCRIPTION:
System.NullReferenceException: Object reference not set to an instance of an object.
at PageBaseClass.InitializeCulture()
at ASP.default_aspx.__BuildControlTree(default_aspx __ctrl)
at ASP.default_aspx.FrameworkInitialize()
at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest()
at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
at System.Web.UI.Page.ProcessRequest(HttpContext context)
at ASP.default_aspx.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
==================================================
Now I'm lost.
Any help *highly* appreciated.
|
|
By Mart - Mon 21 Oct 2013
|
Are the language elements present in the database?
I've seen that error before when the database is empty (ie its just structure without eg config settings or language elements)
|
|
By Ardik - Mon 21 Oct 2013
|
Yes, they are.
NB: In Cactushop we only used the main language (English). We did have a 2nd language activated (back end only) but since we never really populated it we removed it later (just by setting it non-live).
This seems to be properly reflected in [tblKartrisLanguages] (5 rows, the last three with many NULL values). The [LANG_Culture], [LANG_UICulture], [LANG_Master], [LANG_Theme] columns have NULL values for *all* languages, fwiw (in cactushop LANG_ISO is NULL, too).
[tblKartrisLanguageElements] holds some 14000 rows.
12000 of them have NULL in LE_Value. Most of these have LE_LanguageID > 1 but some 1100 of them are for the 1st language.
- Other language tables, probably not affected by the data import, anyway:
[tblKartrisLanguageElementFieldNames] has just 9 rows.
[tblKartrisLanguageElementTypes] has 17 rows.
[tblKartrisLanguageElementTypeFields] has 41 rows with data that seems to correspond to the latter two tables.
[tblKartrisLanguageStrings] holds 1627 rows for one language only. Makes sense to me.
I'm sorry if this was a bit too verbose, but you never know ... ;-)
|
|
By Paul - Tue 22 Oct 2013
|
Do you have any extra fields or modifications to your CactuShop db? The DT can sometimes have problems if there are modifications to the db, though in many cases it makes no difference.
One thing you could try is to approach it in two steps - first try importing just product data and then customer data later.
|