Important Notice from AspDotNetStorefront
It is with dismay that we report that we have been forced, through the action of hackers, to shut off write-access to this forum. We are keen to leave the wealth of material available to you for research. We have opened a new forum from which our community of users can seek help, support and advice from us and from each other. To post a new question to our community, please visit: http://forums.vortx.com
Results 1 to 10 of 10

Thread: Missing orders?

  1. #1
    nirmal is offline Member
    Join Date
    May 2009
    Location
    Conyers, GA
    Posts
    35

    Default Missing orders?

    Going through the Orders table in the database I noticed that we have been missing numerous orders. The order numbers skip in no particular pattern eg:
    127381
    127382
    127383
    127385

    I am unable to think of any way by which orders would be "missing". Anyone noticed similar issues or know of the cause? BTW we are currently using the older ML v7.1

    Thanks

  2. #2
    esedirect is offline Senior Member
    Join Date
    Feb 2010
    Location
    Norfolk, UK
    Posts
    343

    Default

    For us, in v8, it's because there's been a failed payment gateway transaction.
    http://www.esedirect.co.uk
    --------------------------------------------------------------------------
    Using MS 9.2.0.0 with the following customisations:

    Lightbox/Fancybox enlarged images;
    Auto-suggest searchbox;
    Extra product information shown only to our IP Address (such as supplier info, costs, etc.);
    Failed transactions emailed via trigger;
    Custom app to show basket contents when customer online;
    Orders pushed through to accounting systems.

    All the above without source!

  3. #3
    nirmal is offline Member
    Join Date
    May 2009
    Location
    Conyers, GA
    Posts
    35

    Default

    Quote Originally Posted by esedirect View Post
    For us, in v8, it's because there's been a failed payment gateway transaction.
    We don't authorize transactions on our website. They are downloaded into our Catalog Manager and then authorized.

  4. #4
    chrismartz is offline Senior Member
    Join Date
    Apr 2010
    Posts
    339

    Default

    Are you using multistore? I believe it will use order numbers across all stores.

  5. #5
    nirmal is offline Member
    Join Date
    May 2009
    Location
    Conyers, GA
    Posts
    35

    Default

    We are not using Multistore. We use V7.1 (officially unsupported)

  6. #6
    AspDotNetStorefront Staff - Scott's Avatar
    AspDotNetStorefront Staff - Scott is offline Administrator
    Join Date
    Mar 2007
    Location
    Ashland, OR
    Posts
    2,390

    Default

    Check your FailedTransactions table in the DB and see if your missing orders are in there. Even without a live gateway hooked up, there are a few rare issues that could arise that would prevent an order from going through.

  7. #7
    nirmal is offline Member
    Join Date
    May 2009
    Location
    Conyers, GA
    Posts
    35

    Default

    Wow, I didn't even know that FailedTransaction table existed! Unfortunately it is empty, something strange is going on..

  8. #8
    deanfp is offline Senior Member
    Join Date
    May 2009
    Location
    Sweden
    Posts
    556

    Default

    Can you check the orders.dbo within SQL to check?

  9. #9
    esedirect is offline Senior Member
    Join Date
    Feb 2010
    Location
    Norfolk, UK
    Posts
    343

    Default

    OP would be better checking the OrderNumbers table like this:

    Code:
    select ONo.*, O.OrderNumber
    FROM OrderNumbers ONo (NOLOCK)
    LEFT JOIN Orders O (NOLOCK) ON ONo.OrderNumber = O.OrderNumber
    WHERE o.OrderNumber IS NULL
    if [dbo].[OrderNumbers] exists in ML7.1, of course.

    This will show what OrderNumber was generated, but not used. Also you could then use the CreatedOn date/time to maybe pinpoint something in your IIS logs as to any errors.
    Last edited by esedirect; 08-18-2011 at 02:19 AM.
    http://www.esedirect.co.uk
    --------------------------------------------------------------------------
    Using MS 9.2.0.0 with the following customisations:

    Lightbox/Fancybox enlarged images;
    Auto-suggest searchbox;
    Extra product information shown only to our IP Address (such as supplier info, costs, etc.);
    Failed transactions emailed via trigger;
    Custom app to show basket contents when customer online;
    Orders pushed through to accounting systems.

    All the above without source!

  10. #10
    timmerk is offline Junior Member
    Join Date
    Feb 2007
    Posts
    5

    Default

    We have the same problem in ML v7.x. The order appears in the database in the OrderNumbers table, but not in the Orders table. The order doesn't appear in the FailedTransactions table. The payment processor is Authorize.Net and they receive the charge and charge it successfully.

    UPDATE: I found an error log that shows the user in question with the missing order experienced a general exception during checkout:

    InnerException: Thread was being aborted.
    Message: System.Threading.ThreadAbortException: Thread was being aborted.at System.Threading.Thread.AbortInternal()at System.Threading.Thread.Abort(Object stateInfo)at System.Web.HttpResponse.End()at System.Web.HttpResponse.Redirect(String url, Boolean endResponse)at System.Web.HttpResponse.Redirect(String url)at AspDotNetStorefront.Modules.ASPDNSF_Checkout.check outreview.ProcessCheckout()

    Any ideas how to prevent this in the future? Thanks!

    UPDATE #2: Maybe that above error is unrelated. It looks like Response.Redirect *Always* throws an thread aborted exception (which is expected, according to Microsoft).
    Last edited by timmerk; 01-30-2013 at 12:51 PM.