AbleCommerce Shopping Cart Software

I had my web host install the 7.0.3 database into my development gold10 site. Then went to /install/upgrade.aspx and I am getting an error.

Invalid object name 'ac_StoreSettings'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Invalid object name 'ac_StoreSettings'.

Source Error:


Line 75:
Line 76: // UPDATE STORE SETTINGS
Line 77: IList<StoreSetting> settings = StoreSettingDataSource.LoadAll();
Line 78: CheckAndAddSetting(settings, "WebpagesDefaultLayout", "~/Layouts/LeftSidebar.master", errorList);
Line 79: CheckAndAddSetting(settings, "CategoriesDefaultLayout", "~/Layouts/Category.master", errorList);


Source File: d:\domains\cameoupgrade.com\wwwroot\Install\Upgrade.aspx.cs Line: 77

Stack Trace:


[SqlException (0x80131904): Invalid object name 'ac_StoreSettings'.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +2074174
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +5066268
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() +234
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2275
System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +33
System.Data.SqlClient.SqlDataReader.get_MetaData() +86
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +311
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +987
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +141
System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +12
System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader() +12
NHibernate.AdoNet.AbstractBatcher.ExecuteReader(IDbCommand cmd) +292
NHibernate.Loader.Loader.GetResultSet(IDbCommand st, Boolean autoDiscoverTypes, Boolean callable, RowSelection selection, ISessionImplementor session) +244
NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) +186
NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) +129
NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) +116

[GenericADOException: could not execute query
[ SELECT this_.StoreSettingId as StoreSet1_110_0_, this_.StoreId as StoreId110_0_, this_.FieldName as FieldName110_0_, this_.FieldValue as FieldValue110_0_ FROM ac_StoreSettings this_ ]
[SQL: SELECT this_.StoreSettingId as StoreSet1_110_0_, this_.StoreId as StoreId110_0_, this_.FieldName as FieldName110_0_, this_.FieldValue as FieldValue110_0_ FROM ac_StoreSettings this_]]
NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) +213
NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) +17
NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces, IType[] resultTypes) +79
NHibernate.Impl.SessionImpl.List(CriteriaImpl criteria, IList results) +481
NHibernate.Impl.CriteriaImpl.List(IList results) +56
NHibernate.Impl.CriteriaImpl.List() +58
CommerceBuilder.DomainModel.RepositoryWithTypedId`2.LoadAll(String sortExpression, Int32 maximumRows, Int32 startRowIndex) +131
CommerceBuilder.DomainModel.DataSourceWithTypedId`3.LoadAll() +69
Install_Upgrade.UpgradeButton_Click(Object sender, EventArgs e) in d:\domains\cameoupgrade.com\wwwroot\Install\Upgrade.aspx.cs:77
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +118
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +112
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5563

Can anyone explain this?
Thanks

First thought, it sounds like a permissions issue.

Have the hosting provider check the SQL credentials you are using in the Gold database.config against what is configured for the restored database. The SQL account in database.config might not have rights to the restored DB.

Second, could be a SQL schema issue. When a SQL database is restored, the schema permissions are restored with it. The hosting provider might need to run an update to replace the schema on the restored DB. For example, most installs list the tables in the database as "dbo.ac_StoreSettings". The "dbo" is the SQL schema.

But some systems use the SQL user name as the schema name. So the table might look like "sqlusername.ac_StoreSettings". So if "sqlusername" isn't configured as a schema for the restored database, you won't have permissions to the table.

When that 2nd issue happens to me, I just reassign the schema. But you must have access to the SQL database in order to do it. Here's an older blog post on how to update the schema: https://www.ablemods.com/blog/post/2008 ... stall.aspx

That post applies to older versions of SQL. So you may have google a newer way to do it if it's a recent flavor of SQL.

Hope that helps.

Could anything I did in the gold store cause this to fail? For example I had the gold store up and running with an sql database set up with the sample products in it. It worked fine. I did not use the same "storename" in setting it up. Not sure what that effects? Could that be the issue? Once I confirmed the store worked correctly I had my host make a backup of the AC7 store and restore it to the gold store. Which is on a different server. I then went directly to /install/upgrade.aspx and ran the upgrade which generated that error...I just want to make sure this is not something I have caused, before I ask the hosting company to look into all these other possibilities. Thanks

Store name doesn't have any impact.

Chris Hadden wrote:I had my host make a backup of the AC7 store and restore it to the gold store. Which is on a different server.

Are you saying the database was restored to a different database server, or the just the site is running on a different server but both databases are on the same SQL server?

Well I don't know the answer to this because I do not have an understanding of any of it... but when asked for a "server name" one would be sql2k5h and the other site would be sql2k5f so I assumed these were on different servers?

Yes, different servers is what you have.

ok, but does that have a likely impact on things?

Possibly. But it's tough to say at this point without more specifics.

Not sure how much more help I can be in an online forum. I would talk with your hosting provider and work with them to get the SQL connectivity working between the store and the database. They're the only ones that have all the pieces to the puzzle.

Will do thank you Joe.

Joe, My host said this:

Hello Chris,

I'm guessing there is some kind of conflict with the username.

I checked the usual things and user 'chadden' is set to db_owner, however when I try to reset permissions I get an error:

"The login already has an account under a different user name."


Since there is only one chadden account, this must be something with SID's. My recommendation is for this database (the one on sql2k5h), to either delete and recreate this user (I'd suggest a slightly different username to ensure no further issues)

If that doesn't resolve the problem please let us know. Don't forget to also update your web site's connection string with the new user details.



I currently have the same username for each database. They suggest I change that on the upgrade site. I can do that on the web control panel, Then I would have to change that connection string. ........Would I just start again at the install/default.aspx page? Put the same license key back in? then change the username and try the upgrade again?...I am just unsure whether that is the correct steps. Thanks

I renamed the database and ran the upgrade again. Now I am getting this message

The specified database is not a valid database version. The upgrade only works on AC7.0.6 or higher databases

I thought I could jump from 7.0.3 which is where I am to gold 10 ?

Chris Hadden wrote:I thought I could jump from 7.0.3 which is where I am to gold 10 ?

The error text is incorrect, something I reported a while back. According to Gold R8 release notes, you can upgrade from 7.0.3.

Since you are using Gold R10, that shouldn't be a problem.

Have you tried running the site and not going straight to the upgrade.aspx page? i.e. is it possible the database is already upgraded?

I don't think so. I am getting this error below when I try to go to the default.aspx page. Looks very similar to what I posted on the first attempt.



Server Error in '/' Application.
Invalid object name 'ac_Stores'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Invalid object name 'ac_Stores'.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[SqlException (0x80131904): Invalid object name 'ac_Stores'.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +2074174
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +5066268
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() +234
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2275
System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +33
System.Data.SqlClient.SqlDataReader.get_MetaData() +86
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +311
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +987
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +141
System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +12
System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader() +12
NHibernate.AdoNet.AbstractBatcher.ExecuteReader(IDbCommand cmd) +292
NHibernate.Loader.Loader.GetResultSet(IDbCommand st, Boolean autoDiscoverTypes, Boolean callable, RowSelection selection, ISessionImplementor session) +244
NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) +186
NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) +129
NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) +116

[GenericADOException: could not execute query
[ SELECT this_.StoreId as StoreId109_0_, this_.Name as Name109_0_, this_.ApplicationName as Applicat3_109_0_, this_.LoweredApplicationName as LoweredA4_109_0_, this_.LicenseKey as LicenseKey109_0_, this_.DefaultWarehouseId as DefaultW6_109_0_, this_.NextOrderId as NextOrde7_109_0_, this_.OrderIdIncrement as OrderIdI8_109_0_, this_.WeightUnitId as WeightUn9_109_0_, this_.MeasurementUnitId as Measure10_109_0_ FROM ac_Stores this_ ]
[SQL: SELECT this_.StoreId as StoreId109_0_, this_.Name as Name109_0_, this_.ApplicationName as Applicat3_109_0_, this_.LoweredApplicationName as LoweredA4_109_0_, this_.LicenseKey as LicenseKey109_0_, this_.DefaultWarehouseId as DefaultW6_109_0_, this_.NextOrderId as NextOrde7_109_0_, this_.OrderIdIncrement as OrderIdI8_109_0_, this_.WeightUnitId as WeightUn9_109_0_, this_.MeasurementUnitId as Measure10_109_0_ FROM ac_Stores this_]]
NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) +213
NHibernate.Loader.Loader.ListUsingQueryCache(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces, IType[] resultTypes) +159
NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces, IType[] resultTypes) +60
NHibernate.Impl.SessionImpl.List(CriteriaImpl criteria, IList results) +481
NHibernate.Impl.CriteriaImpl.List(IList results) +56
NHibernate.Impl.CriteriaImpl.List() +58
NHibernate.Criterion.QueryOver`1.List() +49
NHibernate.Criterion.QueryOver`1.NHibernate.IQueryOver<TRoot>.List() +41
CommerceBuilder.Services.StoreLocator.LocateCurrent() +127
CommerceBuilder.Common.AbleContext.a() +39
CommerceBuilder.Common.AbleContext.get_Store() +40
CommerceBuilder.Licensing.h.a(String A_0) +1066
CommerceBuilder.Services.HttpModule.b() +198
CommerceBuilder.Services.HttpModule.b(Object A_0, EventArgs A_1) +439
System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +148
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +75

Ok. So you've still got a permissions issue somewhere.

Only suggestion I have left is go back to the beginning. Set up a new SQL user account and password. Assign it to the database in your control panel. Then update your database.config and see if it works.

Otherwise, you're probably going to have to hire someone to go through the entire setup. Surprised the hosting provider didn't provide more help than they did - disappointing service in my opinion.

This is a permissions issue on the database. In other words, you likely have table names starting with something other than dbo.ac_StoreSettings.

To fix this issue, you'll need access to the database:

SELECT 'EXEC sp_changeobjectowner ''Snoopy.' + name + ''', ''dbo'''
FROM sys.tables
WHERE schema_id = SCHEMA_ID('Snoopy');

You need to replace Snoopy in two places to the incorrect name in front of the table. Run this query against the db. Then copy the results of the query and run that as a query to fix the dbo issue.

Please let us know if this fixes the issue.

Katie

I am still working on this, and enlisted my web host to have someone there look closer at the issue. I want to run his thoughts by you before I hire someone to look at the SCHEMA issue.

Here is what he said:

Hello Chris,
While looking at the current error for the upgrade site it doesn't look to be a permission error. ( Screenshot attached SITE_ERR1 ) Which lead me to this article from ablecommerce about steps that should be completed when moving the database. ( viewtopic.php?f=42&t=6745 )

From this article I found this line
....Then restore your development DB backup to the new DB. You might need to manually edit the ac_StoreSettings table entries so accomodate the new URL, SSL enabled etc. Checking the ac_storesettings for the upgrade database everything still points back to the main site.............

Would maybe changing these fields ( screenshot db_upgrade ) fix the current error for the site? I am looking at line 59 and 79 for this table. There maybe other fields to change but this should be a start

I don't want to post that screen shot here, I can send privately if you want. It shows that the ac_settings table still has all the urls from the other web site, and SSL as true and line 79 is "common site map" which again points to the original domain. Why is that? Would that be the issue?

The second question I have comes from that same post by Joe

The security for the database is not stored in the database itself. It's stored in the SQL instance master.mdf table.

So when you created the initial development user and assigned it to the AC7 database, SQL noted that user had rights to the database.

When you move the database to another SQL instance, you must have already created the same SQL user as you used in your development SQL instance. If you don't the SQL engine cannot match what the database says as the db-owner against the available user accounts configured in the SQL instance.

To fix it, you usually you just delete the new DB since it doesn't work anyways. Create the correct user account in the new SQL instance identical in name and password to your development user instance, then create a new empty DB. Assign the new user account full DBOwner rights to the new Db.

I originally used the same user ID as the original database but a different password. When we had issues the host suggested I add a new user name and delete the old user name as they thought that was causing the conflict......so what is it supposed to be? Does it have to be the same user name and password at the restored location?
Thanks
Chris

If you change the user and password for the database, then you'll need to update the database.config file in the app_data folder. But, if that were the case, then I don't think you would be getting this error "Invalid object name 'ac_StoreSettings'." It would be something more specific about the user not having access to the database.

Did your host run the change DBO script that I posted on Friday? This is often the cause of errors if the database has been restored from a backup. We run into this issue ALL THE TIME, so please make sure the script has been run against the database.

Thanks
Katie

Reference this post for the code to manually enter the un-encrypted connection string -

viewtopic.php?f=65&t=18399

It shows that the ac_settings table still has all the urls from the other web site, and SSL as true and line 79 is "common site map" which again points to the original domain

The store URL does nothing but prepend your emails with the correct info to generate the links. The site map path can be changed after you upgrade. The SSL should be set to false.

I believe that most of these issues are covered in this help document -
http://help.ablecommerce.com/faqs/ablec ... lation.htm

Thanks
Katie

Any luck with this Chris? I just wanted to make sure that we are giving the right advice.

Katie

Well I think we have all the connections correct, I did manually change the config file and my web host corrected the ssl issue....then tried the upgrade again with same results so I am pursuing doing the SCHEMA fix per your post. The web host said this is not something they can do so I am going to ask a friend of mine that is a web developer if he could do it. If not I will have to come to the board here and find someone. That is current status.

Really? Your webhost said that can't make this change? Did they give a reason why? This is pretty standard stuff for any host that maintains a database. You can search through the forums and see this solution given for other customers.

Hello Chris,
This is beyond the scope of our support you would need to consult with a DBA or your developer to run the requested task for you.

Applied Innovations Support

Well, if you are interested, we do offer hosting...and this is certainly something we would do for you at no cost. It would literally take 2-3 minutes. In fact, we'll even do the database upgrades for free, so private message me if you're interested.

Thanks,
Katie

Surprise, surprise the web host contacted me shortly after posting here they could not do the SCHEMA script fro me.......... Not sure if that was coincidence? or someone whispering in their ear., anyway they said it was done and I tried to do the upgrade which of coarse again failed, although I am getting a different error. So here is the new error:

Server Error in '/' Application.
Invalid column name 'TaxExemptionType'.
Invalid column name 'TaxExemptionReference'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Invalid column name 'TaxExemptionType'.
Invalid column name 'TaxExemptionReference'.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[SqlException (0x80131904): Invalid column name 'TaxExemptionType'.
Invalid column name 'TaxExemptionReference'.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +2074174
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +5066268
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() +234
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2275
System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +33
System.Data.SqlClient.SqlDataReader.get_MetaData() +86
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +311
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +987
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +141
System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +12
System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader() +12
NHibernate.AdoNet.AbstractBatcher.ExecuteReader(IDbCommand cmd) +292
NHibernate.Loader.Loader.GetResultSet(IDbCommand st, Boolean autoDiscoverTypes, Boolean callable, RowSelection selection, ISessionImplementor session) +244
NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) +186
NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) +129
NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) +116

[GenericADOException: could not execute query
[ SELECT this_.UserId as UserId121_0_, this_.StoreId as StoreId121_0_, this_.UserName as UserName121_0_, this_.LoweredUserName as LoweredU4_121_0_, this_.Email as Email121_0_, this_.LoweredEmail as LoweredE6_121_0_, this_.AffiliateId as Affiliat7_121_0_, this_.AffiliateReferralDate as Affiliat8_121_0_, this_.PrimaryWishlistId as PrimaryW9_121_0_, this_.PayPalId as PayPalId121_0_, this_.PasswordQuestion as Passwor11_121_0_, this_.PasswordAnswer as Passwor12_121_0_, this_.IsApproved as IsApproved121_0_, this_.IsAnonymous as IsAnony14_121_0_, this_.IsLockedOut as IsLocke15_121_0_, this_.CreateDate as CreateDate121_0_, this_.LastActivityDate as LastAct17_121_0_, this_.LastLoginDate as LastLog18_121_0_, this_.LastPasswordChangedDate as LastPas19_121_0_, this_.LastLockoutDate as LastLoc20_121_0_, this_.FailedPasswordAttemptCount as FailedP21_121_0_, this_.FailedPasswordAttemptWindowStart as FailedP22_121_0_, this_.FailedPasswordAnswerAttemptCount as FailedP23_121_0_, this_.FailedPasswordAnswerAttemptWindowStart as FailedP24_121_0_, this_.TaxExemptionType as TaxExem25_121_0_, this_.TaxExemptionReference as TaxExem26_121_0_, this_.Comment as Comment121_0_ FROM ac_Users this_ WHERE this_.LoweredUserName = @p0 ]
Name:cp0 - Value:e4c15211-6716-442c-84ec-6341504d92eb
[SQL: SELECT this_.UserId as UserId121_0_, this_.StoreId as StoreId121_0_, this_.UserName as UserName121_0_, this_.LoweredUserName as LoweredU4_121_0_, this_.Email as Email121_0_, this_.LoweredEmail as LoweredE6_121_0_, this_.AffiliateId as Affiliat7_121_0_, this_.AffiliateReferralDate as Affiliat8_121_0_, this_.PrimaryWishlistId as PrimaryW9_121_0_, this_.PayPalId as PayPalId121_0_, this_.PasswordQuestion as Passwor11_121_0_, this_.PasswordAnswer as Passwor12_121_0_, this_.IsApproved as IsApproved121_0_, this_.IsAnonymous as IsAnony14_121_0_, this_.IsLockedOut as IsLocke15_121_0_, this_.CreateDate as CreateDate121_0_, this_.LastActivityDate as LastAct17_121_0_, this_.LastLoginDate as LastLog18_121_0_, this_.LastPasswordChangedDate as LastPas19_121_0_, this_.LastLockoutDate as LastLoc20_121_0_, this_.FailedPasswordAttemptCount as FailedP21_121_0_, this_.FailedPasswordAttemptWindowStart as FailedP22_121_0_, this_.FailedPasswordAnswerAttemptCount as FailedP23_121_0_, this_.FailedPasswordAnswerAttemptWindowStart as FailedP24_121_0_, this_.TaxExemptionType as TaxExem25_121_0_, this_.TaxExemptionReference as TaxExem26_121_0_, this_.Comment as Comment121_0_ FROM ac_Users this_ WHERE this_.LoweredUserName = @p0]]
NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) +213
NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) +17
NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces, IType[] resultTypes) +79
NHibernate.Impl.SessionImpl.List(CriteriaImpl criteria, IList results) +481
NHibernate.Impl.CriteriaImpl.List(IList results) +56
NHibernate.Impl.CriteriaImpl.UniqueResult() +47
CommerceBuilder.Users.UserRepository.LoadForUserName(String userName, Boolean createMissing) +100
CommerceBuilder.Users.UserDataSource.LoadForUserName(String userName, Boolean createMissing) +37
CommerceBuilder.Services.Membership.WebUserLocator.Locate() +679
CommerceBuilder.Common.AbleContext.get_User() +50
CommerceBuilder.Services.PageTracker.Track(HttpApplication application, HttpContext context) +970
CommerceBuilder.Services.HttpModule.a(Object A_0, EventArgs A_1) +1118
System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +148
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +75

What page are you accessing when you get this error?

From the error, it looks as if the database was not upgraded to Gold. You may have a working connection string, but it is trying to connect with the old database.

In order to upgrade, you need to put in a blank database.config under App_Data. Then use install process and choose to use existing database. Basically, just start over with the 7.0.3 database that now has the correct permissions.