Page 1 of 1

Database Locking on every order

PostPosted: Fri Jul 20, 2001 9:59 am
by George B. Hug
Hello all,

A little desperate for help here. Our store has been down for two days now,
and I have about 50 Database locked messages. I've used the unlock database
feature, but every single time a new order is attempted, the database locks
up again. We have never experienced this situation before.

I can't seem to get through to our service provider HostPro, so I can't even
get support from them right now, and the last time I tried, they claimed
they no longer support Shopsite, even tho they are listed as one of the US
Partners on the Shopsite website.

If anyone can help, please let me know, because we are out of business right
now, and have lost two days and counting of sales.

Thanks so much for any advice!

Regards,



--
George B. Hug - President
NorthWest Builders Network, Inc.
News, Resources, & Innovative Products for the AEC Industry
Tel: (541) 895-5061
Web: http://www.nwbuildnet.com/

Re: Database Locking on every order

PostPosted: Sun Jul 22, 2001 12:06 pm
by Jake VanNoy
See my note about "V5 for NT". You may be having the same problem.]

Jake VanNoy

Re: Database Locking on every order

PostPosted: Tue Jul 24, 2001 12:15 am
by Gehrig Ikeda
George,
I received the following E-mail from Shopsite TODAY. (Monday) I dont know if
it applies to you but you can read it to see if it does.

Gehrig Ikeda
GSI Software, Inc.
www.productsofhawaii.com

Dear ShopSite Tech Bulletin Subscriber:

If you use VeriSign (formerly Signio, PaymentNet, Seque Systems, and On-line
Analysis) as a payment gateway with ShopSite version
4.3 or earlier you need to be aware of the following information.

Sometime Thursday evening on July 19, 2001 the VeriSign payment gateway
stopped working in ShopSite versions 4.3 and earlier.
Symptoms of the problem include:

1) The order does not complete from the billing page when you click on
the "Submit this Order" (or "Finalize Order") button. The
CGI (browser page) times out.
2) After the above happens you may get "The database is locked" messages.
Clearing the locks via the ShopSite Utilities menu does
not solve the problem because the next time an order is placed the CGI times
out and a new lock remains.

To immediately work-around or solve this problem you can either:

1) Set ShopSite to capture orders for manual processing and then re-enter
them via your VeriSign web interface.
2) Upgrade to ShopSite v5.0.1

ShopSite, Inc. is providing VeriSign information and test stores so that
they can diagnose the problem. Hopefully a solution will
be found quickly but in the meantime the above two options are the only
solutions.

MANUAL PROCESSING
To instruct ShopSite to capture orders for manual processing:
1) Go to Commerce Setup
2) Click on the Payment button
3) Select the "manual (off-line)" radio button
4) Save the changes

UPGRADING TO 5.0.1
To upgrade to ShopSite v5.0.1:
1) If you are hosted at a ShopSite partner contact your ISP.
2) If you are not hosted at a ShopSite partner have your admin e-mail
info@shopsite.com and note that you want to upgrade to 5.0.1
to solve a VeriSign payment gateway problem.
Note that Version 5.x is not available for the NT or Windows 2000 server
platform (but a beta version is available). It is also not
available for Solaris Intel platforms.

WHY DOES SHOPSITE v5.x WORK?
ShopSite versions 4.3 and earlier used version 1.x of the VeriSign payment
gateway interface. ShopSite v5.0 uses version 2.x of
VeriSign's interface. It may be that the current problems are unique to the
1.x VeriSign gateway interface.

HOW WILL I KNOW WHEN THERE IS A FIX?
If there is new information on this issue it will be e-mailed to the
technical bulletin listserver and posted on the newsgroup. For
information on subscribing (for free) to these services view the support
page at:
http://www.shopsite.com/support/index.html
Regards,
The ShopSite Technical Support Team


"George B. Hug" <gbhug@nwbuildnet.com> wrote in message
news:B77DB188.1EBB1%gbhug@nwbuildnet.com...
Hello all,

A little desperate for help here. Our store has been down for two days
now,
and I have about 50 Database locked messages. I've used the unlock
database
feature, but every single time a new order is attempted, the database
locks
up again. We have never experienced this situation before.

I can't seem to get through to our service provider HostPro, so I can't
even
get support from them right now, and the last time I tried, they claimed
they no longer support Shopsite, even tho they are listed as one of the US
Partners on the Shopsite website.

If anyone can help, please let me know, because we are out of business
right
now, and have lost two days and counting of sales.

Thanks so much for any advice!

Regards,



--
George B. Hug - President
NorthWest Builders Network, Inc.
News, Resources, & Innovative Products for the AEC Industry
Tel: (541) 895-5061
Web: http://www.nwbuildnet.com/