• Replies 3 replies
  • Subscribers 337 subscribers
  • Views 18 views
  • Users 0 members are here
Related

Duplicate orders being created

Rosa Alvarez
$organization

Does anyone have any idea why when we create and process a new order it would be creating a duplicate order with the exact same order number?

 

Parents
  • $organization
    I second Gawain. We had the same problem here, and it was immediately fixed when we corrected the setup issue that Gawain pointed out. The order isn't actually duplicated them when you look at the database level, it's just displaying things twice. So no customers are being double-charged or anything; it's just very confusing to view. Luckily, it's a very easy fix.

    Beth


    *   *   *   *   *
    How do astronauts get to space? How do they eat, sleep, and do research in a weightless environment? And how do they go to the bathroom? Find out during an unforgettable day of space exploration at the world premiere Space exhibition. It's now open at the Science Museum of Minnesota, along with the brand new Omnitheater film, Journey to Space. Visit www.smm.org/space to plan your visit today!

    From: "Sean Pinto" <bounce-seanpinto6111@tessituranetwork.com>
    To: evarro@smm.org
    Sent: Thursday, June 11, 2015 3:51:13 PM
    Subject: Re: [Tessitura Technical Forum] Duplicate orders being created

    Hi Rosa,

     

    Technically speaking I don’t think that it is possible to have two orders with the same order number simply because at the database table level, the order number is the primary key.  There cannot exists two records with the same order number.  I’m not sure what’s going on with your system but I suspect something else is at play because the database would never allow two orders with the same order number to exist.  What happens when you run this query, substituting in the order number in question?

    SELECT * FROM T_ORDER WHERE order_no = <insert order number here>

    You should only get one row returned, if not then you have a serious problem on your hand and you should contact Tessitura ASAP.

    If you get more than one row you can also run this to identify which order numbers have duplicate entries:

    SELECT order_no FROM T_ORDER GROUP BY order_no HAVING COUNT(1) > 1

    Hope that helps!

    Sean

    From: Rosa Alvarez <bounce-rosaalvarez7844@tessituranetwork.com>
    Sent: 6/11/2015 4:05:41 PM

    Does anyone have any idea why when we create and process a new order it would be creating a duplicate order with the exact same order number?

     




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
Reply
  • $organization
    I second Gawain. We had the same problem here, and it was immediately fixed when we corrected the setup issue that Gawain pointed out. The order isn't actually duplicated them when you look at the database level, it's just displaying things twice. So no customers are being double-charged or anything; it's just very confusing to view. Luckily, it's a very easy fix.

    Beth


    *   *   *   *   *
    How do astronauts get to space? How do they eat, sleep, and do research in a weightless environment? And how do they go to the bathroom? Find out during an unforgettable day of space exploration at the world premiere Space exhibition. It's now open at the Science Museum of Minnesota, along with the brand new Omnitheater film, Journey to Space. Visit www.smm.org/space to plan your visit today!

    From: "Sean Pinto" <bounce-seanpinto6111@tessituranetwork.com>
    To: evarro@smm.org
    Sent: Thursday, June 11, 2015 3:51:13 PM
    Subject: Re: [Tessitura Technical Forum] Duplicate orders being created

    Hi Rosa,

     

    Technically speaking I don’t think that it is possible to have two orders with the same order number simply because at the database table level, the order number is the primary key.  There cannot exists two records with the same order number.  I’m not sure what’s going on with your system but I suspect something else is at play because the database would never allow two orders with the same order number to exist.  What happens when you run this query, substituting in the order number in question?

    SELECT * FROM T_ORDER WHERE order_no = <insert order number here>

    You should only get one row returned, if not then you have a serious problem on your hand and you should contact Tessitura ASAP.

    If you get more than one row you can also run this to identify which order numbers have duplicate entries:

    SELECT order_no FROM T_ORDER GROUP BY order_no HAVING COUNT(1) > 1

    Hope that helps!

    Sean

    From: Rosa Alvarez <bounce-rosaalvarez7844@tessituranetwork.com>
    Sent: 6/11/2015 4:05:41 PM

    Does anyone have any idea why when we create and process a new order it would be creating a duplicate order with the exact same order number?

     




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
Children
No Data