AbleCommerce Gold Upgrade errors from 7.0.7

by Joe Payne 14. February 2014 11:00

Ran into an odd timeout issue today.  It was disguising itself as an nHibernate problem during the upgrade of an AbleCommerce 7.0.7 store to AbleCommerce Gold R6.

 

The initial error was complaining about nHibernate null Id issues with Catalog.Webpage.  Which made no sense since the upgrade is converting the data, not adding to it.

So I dug into the /install/upgrade.aspx page and saw that indeed new web pages were being added.  And the error was crashing when store.settings.Save() was being called.

I eventually noticed an “errorList” string array variable and exposed it via debug.   It showed me that the SQL upgrade scripts were causing a timeout.   This was silently crashing the upgrade.

After a quick Google search, I found the solution.  In the RunScript() routine within Upgrade.aspx.cs, you have to increase the command timeout value.   Apparently the database I was upgrading was enormous and my local SQL server isn’t really known for speed.  Combine the two factors and you can easily result in timeouts.

Note the addition of setting the CommandTimeout parameter below:

try
{
    SqlCommand command = new SqlCommand(sql, conn);
    command.CommandTimeout = 300;
    command.ExecuteNonQuery();
}

Tags: , , , ,

AbleCommerce Gold | Tech Support

ABF shipping gateway base written and working

by Joe Payne 2. February 2014 09:13

Spent some time this morning and put together the complete shell for an ABF shipping gateway in AbleCommerce Gold.    It’s only purpose is to provide tracking URL support for ABF shipments when marking orders as shipped.

It was interesting how Able has implemented a default provider interface, leveraged embedded resources and connected it all to specific configure and register pages in the admin.  I’ve worked on various shipping gateway pieces several times, but never a brand new AbleCommerce Gold gateway implementation.   Kinda slick how they did it.

I have to see if ABF will approve my request for an account.  It’s needed to access their API.   If I can get API access, I can build a fully functional gateway.

Now that the learning curve is over, it will be far easier for me to build new shipping gateways in AbleCommerce Gold.

Tags: ,

AbleCommerce Gold | Personal

Month List