• Toll-free  888-665-8637
  • International  +1 717-220-0012
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Surfscience
#1 Posted : Tuesday, August 31, 2010 7:41:51 AM(UTC)
Surfscience

Rank: Member

Joined: 2/7/2006(UTC)
Posts: 66

Hi Folks,

I'm just completing an upgrade of BVC5 SP3.2 --> SP7.3 using the automatic upgrade tool. As far as I know the upgrader patched the files correctly. The SqlPatch.aspx kept timing out mid way through (and resulted in a DB with about half the updates made) so I rolled the DB back to it's pre-updated state and ran each of these SQL scripts on the DB through Management Studio:

BVAdmin/BVSql/SP4 (DataScript.sql and SchemaScript.sql)
BVAdmin/BVSql/SP5 (DataScript.sql and SchemaScript.sql)
BVAdmin/BVSql/SP6 (DataScript.sql and SchemaScript.sql)
BVAdmin/BVSql/SP7 (DataScript.sql and SchemaScript.sql)

I also checked the workflow configuration based on Justin's advice to another user on manually upgrading, they're all set correctly.

I spun it up and all seemed to be fine. The site shows that it's running 5.7.3 and it runs fine. The only problem is that when I try to complete an order I can the error message shown below.

I thought the problem would be the path to the AES keys but whilst I checked the path and it looked fine, when I actually look for the keys bvkeys.config (in my bin folder) the config file is not there.

I also noticed that although the 'Create New Store' exe has the option to create keys when you build a new store (which unfortunately I can't do becasue my SQL server does not have the correct collation to allow me to run) it does not seem to create any keys during the upgrade process so I might just be missing keys.

Any thoughts on how I can make some keys (if that's all that's required) or is there more to it (do they need to be inserted into the DB as well or something)?

As ever any help would be greatly appreciated.

Thanks, Matt

Code:

[b]BVSoftware.Cryptography.AesEncryption: Index was outside the bounds of the array.[/b]

ArgumentException: BVSoftware.Cryptography.AesEncryption: Index was outside the bounds of the array.

BVSoftware.Cryptography.AesEncryption.Encode(String message, String key) in c:\workspaces\cupertino\bvcommerce\Main\App\source\BVSoftware.Cryptography\AesEncryption.cs:44
BVSoftware.Bvc5.Core.Utilities.Cryptography.PciEncryption.Encode(String plainText, String salt) in c:\workspaces\cupertino\bvcommerce\Main\App\source\BVSoftware.Bvc5.Core\Utilities\Cryptography\PciEncryption.vb:54
BVSoftware.Bvc5.Core.Orders.Mapper.AddParametersToRequest(OrderPayment n, DataRequest request) in c:\workspaces\cupertino\bvcommerce\Main\App\source\BVSoftware.Bvc5.Core\Orders\OrderPayment.vb:412
BVSoftware.Bvc5.Core.Orders.Mapper.Insert(OrderPayment n) in c:\workspaces\cupertino\bvcommerce\Main\App\source\BVSoftware.Bvc5.Core\Orders\OrderPayment.vb:397
BVSoftware.Bvc5.Core.Orders.Order.AddPayment(OrderPayment op) in c:\workspaces\cupertino\bvcommerce\Main\App\source\BVSoftware.Bvc5.Core\Orders\Order.vb:855
BVModules_Controls_Payment.SavePaymentInfo(Order o) +795
BVModules_Checkouts_One_Page_Checkout_Checkout.btnSubmit_Click(Object sender, ImageClickEventArgs e) +316
System.Web.UI.WebControls.ImageButton.OnClick(ImageClickEventArgs e) +108
System.Web.UI.WebControls.ImageButton.RaisePostBackEvent(String eventArgument) +118
System.Web.UI.WebControls.ImageButton.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)
Marcus
#2 Posted : Tuesday, August 31, 2010 7:55:46 AM(UTC)
Marcus

Rank: Member

Joined: 11/5/2003(UTC)
Posts: 1,786

Login to the admin and navigate to GettingStartedEmail.aspx. That page will trigger the encryption key generation too.
Surfscience
#3 Posted : Tuesday, August 31, 2010 11:29:58 AM(UTC)
Surfscience

Rank: Member

Joined: 2/7/2006(UTC)
Posts: 66

Hi Marcus,

OK, I ran the GettingStartedEmail.aspx page (after changing the admin account name back to "admin") and it ran the page without error howvere there are still no keys in the Bin folder and the checkout page still fails with the same error (as above).

I looked at other pages that run the key generating script and tried tried the following options on the BVAdmin/Configuration/Security.aspx page:

Generate New Encryption Key Button --> Throws same error as above
Reload Encryption Keys --> "Encryption keys reloaded!"
Replace Master Encryption Key --> "Unable to replace master encryption key"

Any other ideas?
Surfscience
#4 Posted : Wednesday, September 1, 2010 3:25:32 AM(UTC)
Surfscience

Rank: Member

Joined: 2/7/2006(UTC)
Posts: 66

OK, further investigation reveals that the problem seems to be caused by permissions issues on the Bin folder. To test this (on my test site) I gave "EVERYONE" full permission to the Bin folder, created new keys (Admin > Settings > Security > Generate New Encryption Key) and the problem went away.

I'm not sure exactly what permissions I need for the keys to be created (write access for the ASPNET I guess) but I'll set those now and everything should be fine.

I hope this helps others with the same problem.
Marcus
#5 Posted : Wednesday, September 1, 2010 9:03:41 AM(UTC)
Marcus

Rank: Member

Joined: 11/5/2003(UTC)
Posts: 1,786

Thanks for posting your fix.
squeakerjg
#6 Posted : Tuesday, November 15, 2011 2:20:19 PM(UTC)
squeakerjg

Rank: Member

Joined: 8/16/2008(UTC)
Posts: 48
Location: United States

Thanks: 3 times
Was thanked: 2 time(s) in 1 post(s)
This worked for me too - thanks for the post!
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

©2024 Develisys. All rights reserved.
  • Toll-free  888-665-8637
  • International  +1 717-220-0012