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

Seat 'reserved, paid' but no order...

Christopher Hill
$organization


Hia

 

We have had a situation where a customers order was being processed and there was a network problem halfway through.

The result is a seat that is marked as ‘Reserved, Paid’ but there is no order and no transaction record for it.

 

I have identified the TX_Seat_Perf record that it is locked with, but am wondering if anyone has a procedural method of freeing up a seat like this? I don’t want to just remove the TX_Perf_Seat record without realising any impacts it may have on other tables etc…?

 

Any help anyone would give is greatly appreciated! J

 

Regards

 

Christopher Hill

Swyddog Dadansoddi a Chymorth SQL

SQL Support Analyst

Canolfan Mileniwm Cymru

Wales Millennium Centre

 

Ebost\Email Christopher.Hill@wmc.org.uk

Ffon\Tel 029 2063 6372

 

www.wmc.org.uk

 

Dy Le Di

Make it Yours this year

 

Cysylltwch yn Gymraeg neu'n Saesneg fel dymunwch

Contact us in English or Welsh as you prefer

 

Plas Bute\Bute Place

Bae Caerdydd\Cardiff Bay

CF10 5AL

P Meddyliwch am yr amgylchedd cyn printio / Please consider the environment before printing this email

 



Mae’r ohebiaeth hon at ddefnydd y derbynnydd/derbynyddion bwriadedig yn unig. Os nad chi yw’r derbynnydd/derbynyddion bwriadedig, nodwch fod dosbarthu, copïo neu ddefnyddio’r ohebiaeth hon neu’r wybodaeth ynddi mewn unrhyw ffordd wedi ei wahardd yn gyfangwbl a gall fod yn anghyfreithlon. Os ydych wedi derbyn yr ohebiaeth hon trwy gamgymeriad a fyddech cystal â’i ddychwelyd i’r anfonwr. Yn yr achos hwn byddem yn ddiolchgar pe gallech hefyd anfon yr ohebiaeth at administrator@wmc.org.uk ac yna dileu’r e-bost a dinistrio unrhyw gopïau ohono. Cwmni cyfyngedig dan warrant, cofrestrwyd yng Nghymru a Lloegr. Rhif Cwmni 3221924. Rhif Elusen 1060458. Swyddfa gofrestredig: Plas Bute, Bae Caerdydd, Caerdydd CF10 3AL

This communication is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful.If you have received this communication in error please return it to the sender. In this event would be grateful if you would also copy the communication to administrator@wmc.org.uk then delete the email and destroy any copies of it. A company limited by guarantee, registered in England and Wales. Company number 3221924. Charity number 1060458. Registered office: Bute Place, Cardiff Bay, Cardiff CF10 5AL
  • $organization


    Hia

     

    We have had a situation where a customers order was being processed and there was a network problem halfway through.

    The result is a seat that is marked as ‘Reserved, Paid’ but there is no order and no transaction record for it.

     

    I have identified the TX_Seat_Perf record that it is locked with, but am wondering if anyone has a procedural method of freeing up a seat like this? I don’t want to just remove the TX_Perf_Seat record without realising any impacts it may have on other tables etc…?

     

    Any help anyone would give is greatly appreciated! J

     

    Regards

     

    Christopher Hill

    Swyddog Dadansoddi a Chymorth SQL

    SQL Support Analyst

    Canolfan Mileniwm Cymru

    Wales Millennium Centre

     

    Ebost\Email Christopher.Hill@wmc.org.uk

    Ffon\Tel 029 2063 6372

     

    www.wmc.org.uk

     

    Dy Le Di

    Make it Yours this year

     

    Cysylltwch yn Gymraeg neu'n Saesneg fel dymunwch

    Contact us in English or Welsh as you prefer

     

    Plas Bute\Bute Place

    Bae Caerdydd\Cardiff Bay

    CF10 5AL

    P Meddyliwch am yr amgylchedd cyn printio / Please consider the environment before printing this email

     



    Mae’r ohebiaeth hon at ddefnydd y derbynnydd/derbynyddion bwriadedig yn unig. Os nad chi yw’r derbynnydd/derbynyddion bwriadedig, nodwch fod dosbarthu, copïo neu ddefnyddio’r ohebiaeth hon neu’r wybodaeth ynddi mewn unrhyw ffordd wedi ei wahardd yn gyfangwbl a gall fod yn anghyfreithlon. Os ydych wedi derbyn yr ohebiaeth hon trwy gamgymeriad a fyddech cystal â’i ddychwelyd i’r anfonwr. Yn yr achos hwn byddem yn ddiolchgar pe gallech hefyd anfon yr ohebiaeth at administrator@wmc.org.uk ac yna dileu’r e-bost a dinistrio unrhyw gopïau ohono. Cwmni cyfyngedig dan warrant, cofrestrwyd yng Nghymru a Lloegr. Rhif Cwmni 3221924. Rhif Elusen 1060458. Swyddfa gofrestredig: Plas Bute, Bae Caerdydd, Caerdydd CF10 3AL

    This communication is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful.If you have received this communication in error please return it to the sender. In this event would be grateful if you would also copy the communication to administrator@wmc.org.uk then delete the email and destroy any copies of it. A company limited by guarantee, registered in England and Wales. Company number 3221924. Charity number 1060458. Registered office: Bute Place, Cardiff Bay, Cardiff CF10 5AL
  • Former Member
    Former Member $organization
    Christopher, I see that you have submitted a help ticket about this (thank you) and are getting assistance now.  I did want to mention here though that with one exception, you would never want to delete any rows from TX_PERF_SEAT.  If you delete a row from this table, the seat will be removed from inventory and you would no longer be able to see it on the map or sell it.  The only time a row would be deleted from TX_PERF_SEAT would be in the case where a seat was removed from the seat map in Facility Manager because it no longer exists and the desire is to remove the seat from performance/package inventory that was created before the seat was removed in Facility Manager.  Support is at the ready to give advice about this when the situation arises.
     
    Bob

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Christopher Hill
    Sent: Thursday, December 17, 2009 7:22 AM
    To: Robert Bell
    Subject: [Tessitura Technical Forum] Seat 'reserved, paid' but no order...



    Hia

     

    We have had a situation where a customers order was being processed and there was a network problem halfway through.

    The result is a seat that is marked as ‘Reserved, Paid’ but there is no order and no transaction record for it.

     

    I have identified the TX_Seat_Perf record that it is locked with, but am wondering if anyone has a procedural method of freeing up a seat like this? I don’t want to just remove the TX_Perf_Seat record without realising any impacts it may have on other tables etc…?

     

    Any help anyone would give is greatly appreciated! J

     

    Regards

     

    Christopher Hill

    Swyddog Dadansoddi a Chymorth SQL

    SQL Support Analyst

    Canolfan Mileniwm Cymru

    Wales Millennium Centre

     

    Ebost\Email Christopher.Hill@wmc.org.uk

    Ffon\Tel 029 2063 6372

     

    www.wmc.org.uk

     

    Dy Le Di

    Make it Yours this year

     

    Cysylltwch yn Gymraeg neu'n Saesneg fel dymunwch

    Contact us in English or Welsh as you prefer

     

    Plas Bute\Bute Place

    Bae Caerdydd\Cardiff Bay

    CF10 5AL

    P Meddyliwch am yr amgylchedd cyn printio / Please consider the environment before printing this email

     



    Mae’r ohebiaeth hon at ddefnydd y derbynnydd/derbynyddion bwriadedig yn unig. Os nad chi yw’r derbynnydd/derbynyddion bwriadedig, nodwch fod dosbarthu, copïo neu ddefnyddio’r ohebiaeth hon neu’r wybodaeth ynddi mewn unrhyw ffordd wedi ei wahardd yn gyfangwbl a gall fod yn anghyfreithlon. Os ydych wedi derbyn yr ohebiaeth hon trwy gamgymeriad a fyddech cystal â’i ddychwelyd i’r anfonwr. Yn yr achos hwn byddem yn ddiolchgar pe gallech hefyd anfon yr ohebiaeth at administrator@wmc.org.uk ac yna dileu’r e-bost a dinistrio unrhyw gopïau ohono. Cwmni cyfyngedig dan warrant, cofrestrwyd yng Nghymru a Lloegr. Rhif Cwmni 3221924. Rhif Elusen 1060458. Swyddfa gofrestredig: Plas Bute, Bae Caerdydd, Caerdydd CF10 3AL

    This communication is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful.If you have received this communication in error please return it to the sender. In this event would be grateful if you would also copy the communication to administrator@wmc.org.uk then delete the email and destroy any copies of it. A company limited by guarantee, registered in England and Wales. Company number 3221924. Charity number 1060458. Registered office: Bute Place, Cardiff Bay, Cardiff CF10 5AL


    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!
  • $organization in reply to Former Member

    Many thanks Bob

     

    I have just received some sound advice regarding the TP_CHECK_SEAT_STATUS procedure and this has worked a treat. J

    Thanks again for your response Bob!

     

    All the best!

     

    Chris

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Bob Bell
    Sent: 17 December 2009 14:52
    To: Christopher Hill
    Subject: RE: [Tessitura Technical Forum] Seat 'reserved, paid' but no order...

     

    Christopher, I see that you have submitted a help ticket about this (thank you) and are getting assistance now.  I did want to mention here though that with one exception, you would never want to delete any rows from TX_PERF_SEAT.  If you delete a row from this table, the seat will be removed from inventory and you would no longer be able to see it on the map or sell it.  The only time a row would be deleted from TX_PERF_SEAT would be in the case where a seat was removed from the seat map in Facility Manager because it no longer exists and the desire is to remove the seat from performance/package inventory that was created before the seat was removed in Facility Manager.  Support is at the ready to give advice about this when the situation arises.

     

    Bob

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Christopher Hill
    Sent: Thursday, December 17, 2009 7:22 AM
    To: Robert Bell
    Subject: [Tessitura Technical Forum] Seat 'reserved, paid' but no order...

     

    Hia

     

    We have had a situation where a customers order was being processed and there was a network problem halfway through.

    The result is a seat that is marked as ‘Reserved, Paid’ but there is no order and no transaction record for it.

     

    I have identified the TX_Seat_Perf record that it is locked with, but am wondering if anyone has a procedural method of freeing up a seat like this? I don’t want to just remove the TX_Perf_Seat record without realising any impacts it may have on other tables etc…?

     

    Any help anyone would give is greatly appreciated! J

     

    Regards

     

    Christopher Hill

    Swyddog Dadansoddi a Chymorth SQL

    SQL Support Analyst

    Canolfan Mileniwm Cymru

    Wales Millennium Centre

     

    Ebost\Email Christopher.Hill@wmc.org.uk

    Ffon\Tel 029 2063 6372

     

    www.wmc.org.uk

     

    Dy Le Di

    Make it Yours this year

     

    Cysylltwch yn Gymraeg neu'n Saesneg fel dymunwch

    Contact us in English or Welsh as you prefer

     

    Plas Bute\Bute Place

    Bae Caerdydd\Cardiff Bay

    CF10 5AL

    P Meddyliwch am yr amgylchedd cyn printio / Please consider the environment before printing this email

     



    Mae’r ohebiaeth hon at ddefnydd y derbynnydd/derbynyddion bwriadedig yn unig. Os nad chi yw’r derbynnydd/derbynyddion bwriadedig, nodwch fod dosbarthu, copïo neu ddefnyddio’r ohebiaeth hon neu’r wybodaeth ynddi mewn unrhyw ffordd wedi ei wahardd yn gyfangwbl a gall fod yn anghyfreithlon. Os ydych wedi derbyn yr ohebiaeth hon trwy gamgymeriad a fyddech cystal â’i ddychwelyd i’r anfonwr. Yn yr achos hwn byddem yn ddiolchgar pe gallech hefyd anfon yr ohebiaeth at administrator@wmc.org.uk ac yna dileu’r e-bost a dinistrio unrhyw gopïau ohono. Cwmni cyfyngedig dan warrant, cofrestrwyd yng Nghymru a Lloegr. Rhif Cwmni 3221924. Rhif Elusen 1060458. Swyddfa gofrestredig: Plas Bute, Bae Caerdydd, Caerdydd CF10 3AL

    This communication is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful.If you have received this communication in error please return it to the sender. In this event would be grateful if you would also copy the communication to administrator@wmc.org.uk then delete the email and destroy any copies of it. A company limited by guarantee, registered in England and Wales. Company number 3221924. Charity number 1060458. Registered office: Bute Place, Cardiff Bay, Cardiff CF10 5AL


    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!




    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!