AbleCommerce Shopping Cart Software

Folks,

I am in the middle of trying to solve some issues with a client's use of AC8. I decided to install a 30day trial on the hosting site I use for other clients (http://www.hostek.com). I set up a website on hostek's facilities. I created a new empty MS SQL database. I uploaded the AC9 stuff using filezilla to wwwroot.

When I logged in:
I Received the AC setup page,
I accepted the page,
I put in info for 30 day trial,
I put in info about server, username, password etc.,
I received a runtime error stating "An exception occurred while processing your request. Additionally, another exception occurred while executing the custom error page for the first exception. The request has been terminated."

Where do I go to find more info about what has happened? Any suggestions?

Thanks

Miles Sandin
msandin@SheltieSys.com

Under Website/App_Data/Logs/app.log may contain some details.

Thanks,

This is what I see in the log:
Any Thoughts???


2015-02-19 07:36:57,420 ERROR AbleCommerce An error has occured at http://testvcm-com.secure42.ezhostingse ... gure1.aspx
System.Web.HttpUnhandledException (0x80004005): Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.ArgumentException: Format of the initialization string does not conform to specification starting at index 0.
at System.Data.Common.DbConnectionOptions.GetKeyValuePair(String connectionString, Int32 currentPosition, StringBuilder buffer, Boolean useOdbcRules, String& keyname, String& keyvalue)
at System.Data.Common.DbConnectionOptions.ParseInternal(Hashtable parsetable, String connectionString, Boolean buildChain, Hashtable synonyms, Boolean firstKey)
at System.Data.Common.DbConnectionOptions..ctor(String connectionString, Hashtable synonyms, Boolean useOdbcRules)
at System.Data.SqlClient.SqlConnectionString..ctor(String connectionString)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous)
at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(DbConnectionPoolKey key, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions)
at System.Data.SqlClient.SqlConnection.ConnectionString_Set(DbConnectionPoolKey key)
at System.Data.SqlClient.SqlConnection.set_ConnectionString(String value)
at NHibernate.Connection.DriverConnectionProvider.GetConnection()
at NHibernate.Tool.hbm2ddl.SuppliedConnectionProviderConnectionHelper.Prepare()
at NHibernate.Tool.hbm2ddl.SchemaMetadataUpdater.GetReservedWords(Dialect dialect, IConnectionHelper connectionHelper)
at NHibernate.Tool.hbm2ddl.SchemaMetadataUpdater.Update(ISessionFactory sessionFactory)
at NHibernate.Impl.SessionFactoryImpl..ctor(Configuration cfg, IMapping mapping, Settings settings, EventListeners listeners)
at NHibernate.Cfg.Configuration.BuildSessionFactory()
at CommerceBuilder.Common.DatabaseConfiguration.get_SessionFactory()
at CommerceBuilder.Common.DatabaseSessionManager.GetSession()
at CommerceBuilder.DomainModel.NHibernateHelper.QueryOver[T]()
at CommerceBuilder.Services.StoreLocator.LocateCurrent()
at CommerceBuilder.Common.AbleContext.a()
at CommerceBuilder.Common.AbleContext.get_Store()
at AbleCommerce.Errors.GeneralError.GetContact()
at ASP.errors_generalerror_aspx.__Render__control1(HtmlTextWriter __w, Control parameterContainer)
at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)
at System.Web.UI.Page.Render(HtmlTextWriter writer)
at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.HandleError(Exception e)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest()
at System.Web.UI.Page.ProcessRequest(HttpContext context)
at ASP.errors_generalerror_aspx.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
2015-02-19 07:36:57,826 ERROR AbleCommerce Could not write to online error log.
System.ArgumentException: Format of the initialization string does not conform to specification starting at index 0.
at System.Data.Common.DbConnectionOptions.GetKeyValuePair(String connectionString, Int32 currentPosition, StringBuilder buffer, Boolean useOdbcRules, String& keyname, String& keyvalue)
at System.Data.Common.DbConnectionOptions.ParseInternal(Hashtable parsetable, String connectionString, Boolean buildChain, Hashtable synonyms, Boolean firstKey)
at System.Data.Common.DbConnectionOptions..ctor(String connectionString, Hashtable synonyms, Boolean useOdbcRules)
at System.Data.SqlClient.SqlConnectionString..ctor(String connectionString)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous)
at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(DbConnectionPoolKey key, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions)
at System.Data.SqlClient.SqlConnection.ConnectionString_Set(DbConnectionPoolKey key)
at System.Data.SqlClient.SqlConnection.set_ConnectionString(String value)
at NHibernate.Connection.DriverConnectionProvider.GetConnection()
at NHibernate.Tool.hbm2ddl.SuppliedConnectionProviderConnectionHelper.Prepare()
at NHibernate.Tool.hbm2ddl.SchemaMetadataUpdater.GetReservedWords(Dialect dialect, IConnectionHelper connectionHelper)
at NHibernate.Tool.hbm2ddl.SchemaMetadataUpdater.Update(ISessionFactory sessionFactory)
at NHibernate.Impl.SessionFactoryImpl..ctor(Configuration cfg, IMapping mapping, Settings settings, EventListeners listeners)
at NHibernate.Cfg.Configuration.BuildSessionFactory()
at CommerceBuilder.Common.DatabaseConfiguration.get_SessionFactory()
at CommerceBuilder.Utility.Logger.a(MessageSeverity A_0, String A_1, String A_2)

I found two different forum discussions where they ran into this error.

viewtopic.php?f=65&t=17312

viewtopic.php?f=42&t=8843

I hope one of them helps you.

Thanks
Katie

Folks,

I passed info on to the support folks at Hostek. Below is their response. Can you give me any further direction?

Thanks so much for your help.

Miles Sandin
msandin@SheltieSys.com

=======================================================

Hello,

Unfortunately we have had little success getting this application to run on the server. We've tried the following:

- Enabled Full Trust
- Enabled 32-bit applications
- Created the database on a SQL 2008 server (from 2014)
- Attempted to use custom connection string

Our research indicates that this application should run on Server 2012, so we've refrained from migrating the domain to an older server.

The app.log file indicates the issue to be related to the database connection.

At this point, we have exhausted our resources and you will need to consult with the application developer for further assistance.

We apologize for the inconvenience. Please let us know if we can assist you further.

Regards,

David C.
Hostek.com Support

Hostek.com
Shared, Reseller, VPS, & Cloud Hosting Solutions
US Based 24/7 Customer Support

http://www.hostek.com | support@hostek.com | +1 (918) 392-7870
twitter.com/hostek | facebook.com/hostekdotcom



------------- Original Message -------------
> Folks,
>
> This a post I made to the Able Commerce support site.
>
> I am in the middle of trying to solve some issues with a client's use of Able Commerce version 8. I decided to install a 30day trial on the hosting site I use for other clients (http://www.hostek.com). I set up a website on hostek's facilities. I created a new empty MS SQL database. I uploaded the latest Able Commerce version 9 stuff using filezilla to wwwroot.
>
> When I logged in:
> I Received the AC setup page,
> I accepted the page,
> I put in info for 30 day trial,
> I put in info about server, username, password etc.,
> I received a runtime error stating "An exception occurred while processing your request. Additionally, another exception occurred while executing the custom error page for the first exception. The request has been terminated."
>
> Where do I go to find more info about what has happened? Any suggestions?
>
> People on the Able Commerce support site suggested that I look at the log located at:
>
> /App_Data/Logs/app.log
>
> I have attached that log file.
>
> Folks, This stuff is really out of my sphere of experience. Can you give me any thoughts of how to proceed?
>
> Miles Sandin
> msandin@SheltieSys.com
>
> I am a reseller client of yours.
>
> STEPS TO REPRODUCE ISSUE:
> Don't' have any additional info to add at this time

Attempted to use custom connection string

What did they enter for the custom connection string?

Usually, AbleCommerce is easy to install. I've even installed using GoDaddy hosted accounts without any trouble.

Katie and anybody else:

With the info you provided, Hostek has solved the basic problem for me. They are now able to get further along. They turned off custom errors and the system is not finding ac_stores. And there is only 3 tables in the database. This is to be expected IMHO. I have a complete database dump from the ACR8 system (Done from admin, Data, Database Backup). How do I re-load that backup (.zip file)?

Thanks so much for your help...

I see light at the end of the tunnel... hopefully it's not a train coming in the opposite direction!

Miles

The backup is an .sql file which can be used by your host. It's just a script containing the SQL table definitions and data.

I'm surprised that the installation still failed. With a clean new database, it should have populated the tables on the last page of the install wizard. Maybe they didn't get that far?

If you are trying to move the installation, then you can also restore a backup of the database. This is the .bak file created by SQL server which is a little different than having to run the script. It just depends on what your host prefers.

Katie,

The .bak file is created how? I didn't see anything on our AC7 to do that. Would that be a function of SQL itself?

Thanks...

Yes, it's a function of SQL server.

Folks,

I'm still trying to resolve issues with my 30 day trial installation.

My ISP is showing the following for me... Is this OK?

IIS version 8
MS SQL 2014
ASP net 4.0-4.5

Thanks...

Hello,

there is only 3 tables in the database.

The install didn't complete, you should create a new blank database and try again. The server configuration (windows 2012, sql 2014 and .net 4.5) is known to be working fine! AbleCommerce should be easy to install on this environment, I'm sorry your having so much trouble with this host.

Is this a virtual host where we would be able to remote desktop into the installation?

This is just a test area. Please feel free to look at it.

[Sensitive Information Removed]

msandin wrote:This is just a test area. Please feel free to look at it.

[Sensitive Information Removed]

I removed sensitive information from your post. Please don't post your account details publicly, you can use private messaging feature just in case you want to share details with another forum member. I would recommend you change your passwords for accounts you shared publicly.

OK,

If someone will contact me, I'll provide details of how to get into the account to look at it.

I really need help with this.

Thanks, folks...

You can send a private message to my forum user or email support@ablecommerce.com.

Thanks
Katie

Update: We never could get the installation to work with a new blank database. The permissions were not sufficient for the user to create tables.

Later, I was informed that a SQL database backup script (from Gold R8) was used on a 2014 database. Some errors occurred, but it appears that Miles was able to figure it out on his own. In case someone else experiences the same problem, Miles has kindly documented the issue and the fix. (see below)

--------------------------------
Thanks for all your help. I decided to take a different tact towards my goal. I took a database backup file created by AC R8 build 7345, and used Microsoft SQL Server Management Studio ver 12.0.2000.8 to build the database. The name of the backup file was "DatabaseBackup_20150126_191945.sql"

During this process I encountered some problems...

The error was "cannot find data type byte"

I changed it to "Int" and I was able to complete the build.

create table ac_UserPasswords (
UserPasswordId INT IDENTITY NOT NULL,
UserId INT not null,
PasswordNumber byte not null,
Password nvarchar(255) not null,
PasswordFormat nvarchar(10) null,
CreateDate DATETIME not null,
ForceExpiration BIT not null,
primary key (UserPasswordId),
unique (UserId, PasswordNumber)
)

Katie,

I am also "playing" with the web api interface. In our "semi live" system (R8), I am able to access ".../api/products" via http which gives me an xml formatted product list.

In the new installation which came from your download site (R9), I don't see an "api" folder.

Can you help me?

Miles