Thread: Credit Card Processing

Hi,
I Noticed and issue with credit card processing on my Site.

when any customer uses a credit card with insufficient funds, instead of giving error message, my website is saying Opps page cant display (PagenotFound.aspx)


could any one help me how i can fix it back to show the error message.

thanks

You'll need to have your host or IT people check Event Viewer on the server and see what the actual error was. It sounds like something's not being returned properly from the gateway on those orders so the site errors out. Get those error details and then submit a ticket and we'll take a look!

Originally Posted by AspDotNetStorefront Staff - Scott

You'll need to have your host or IT people check Event Viewer on the server and see what the actual error was. It sounds like something's not being returned properly from the gateway on those orders so the site errors out. Get those error details and then submit a ticket and we'll take a look!

Could you please explain how can i check event on the server

can you please help me understand what this log means

Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 10/11/2010 8:56:39 AM
Event time (UTC): 10/11/2010 12:56:39 PM
Event ID: 42bed0f7521d41dc976657856f1782c0
Event sequence: 334
Event occurrence: 3
Event detail code: 0

Application information:
Application domain: /LM/W3SVC/1392/ROOT-1-129312719845293961
Trust level: Full
Application Virtual Path: /
Application Path: D:\Domains\mydomain.com\wwwroot\
Machine name: WEB07

Process information:
Process ID: 41196
Process name: w3wp.exe
Account name: WEB07\mydomain.com_web

Exception information:
Exception type: SqlException
Exception message: The EXECUTE permission was denied on the object 'sp_OACreate', database 'mssqlsystemresource', schema 'sys'.

Request information:
Request URL: https://mydomain.com:443/checkoutrev...tmethod=CREDIT CARD
Request path: /checkoutreview.aspx
User host address: 63.119.227.74
User: a5a8278e-0c0f-42e3-b14f-c991f4a31c99
Is authenticated: True
Authentication Type: Forms
Thread account name: WEB07\mydomain.com_web

Thread information:
Thread ID: 10
Thread account name: WEB07\mydomain.com_web
Is impersonating: False
Stack trace: at AspDotNetStorefrontCore.DB.ExecuteSQL(String Sql)
at AspDotNetStorefrontGateways.Gateway.SVjddAI9r(Shop pingCart , String , String , Int32 , Int32 , Address , String , Address , Decimal , Boolean , String , String , String , String& , String& , String& , String& , String& , String& )
at AspDotNetStorefrontGateways.Gateway.MakeOrder(Stri ng PaymentGatewayToUse, String TransactionMode, ShoppingCart cart, Int32 OrderNumber, String CAVV, String ECI, String XID, String RecurringSubscriptionID)
at AspDotNetStorefront.checkoutreview.ProcessCheckout ()
at AspDotNetStorefront.checkoutreview.ContinueCheckou t()
at AspDotNetStorefront.checkoutreview.btnContinueChec kout1_Click(Object sender, EventArgs e)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Web.UI.WebControls.Button.OnClick(EventArgs e)
at System.Web.UI.WebControls.Button.RaisePostBackEven t(String eventArgument)
at System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEventHandler.RaisePostBackEvent(String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler sourceControl, String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

what should i do to fix this error

It looks to me like the user on ur sql box doesn't have the correct permissions to continue with the script.

How can i change the user permissions.