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

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