Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0039328 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Modules] Analytics | major | always | 2018-09-20 12:42 | 2019-03-28 14:56 | |||
| Reporter | JONHM | View Status | public | |||||
| Assigned To | AtulOpenbravo | |||||||
| Priority | high | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | ddb90b170977 | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Regression date | ||||||||
| Regression introduced by commit | ||||||||
| Regression level | ||||||||
| Review Assigned To | dmiguelez | |||||||
| Regression introduced in release | ||||||||
| Summary | 0039328: Analytics should not have referential integrity with transactional data | |||||||
| Description | Analytics should not have referential integrity. Hibernate loads the children associations that are marked as delete cascade when deleting a parent. Some of the consequences: - Deletes are slower - Cannot have a database with the analytics tables only - Need indexes so the database size is increased | |||||||
| Steps To Reproduce | - | |||||||
| Tags | No tags attached. | |||||||
| Attached Files |  factsDB [^] (122,571 bytes) 2018-09-20 12:47 [Show Content] [Hide Content]$ grep 41/178822 postgresql-9.3-main.log-20180904
2018-09-04 16:57:12 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 0 LOG: duration: 56905.903 ms execute S_85969/C_85970: select obanalyfac0_.C_Order_ID as C9_622_1_, obanalyfac0_.Obanaly_Fact_Salesordheader_ID as Obanaly1_1_, obanalyfac0_.Obanaly_Fact_Salesordheader_ID as Obanaly1_527_0_, obanalyfac0_.AD_Client_ID as AD2_527_0_, obanalyfac0_.AD_Org_ID as AD3_527_0_, obanalyfac0_.Isactive as Isactive527_0_, obanalyfac0_.Created as Created527_0_, obanalyfac0_.Createdby as Createdby527_0_, obanalyfac0_.Updated as Updated527_0_, obanalyfac0_.Updatedby as Updatedby527_0_, obanalyfac0_.C_Order_ID as C9_527_0_, obanalyfac0_.C_Bpartner_ID as C10_527_0_, obanalyfac0_.C_Bp_Group_ID as C11_527_0_, obanalyfac0_.C_Bp_Taxcategory_ID as C12_527_0_, obanalyfac0_.C_Location_ID as C13_527_0_, obanalyfac0_.C_Region_ID as C14_527_0_, obanalyfac0_.C_Country_ID as C15_527_0_, obanalyfac0_.M_Warehouse_ID as M16_527_0_, obanalyfac0_.C_Currency_ID as C17_527_0_, obanalyfac0_.C_Doctype_ID as C18_527_0_, obanalyfac0_.C_Doctypetarget_ID as C19_527_0_, obanalyfac0_.Salesrep_ID as Salesrep20_527_0_, obanalyfac0_.Billto_Location_ID as Billto21_527_0_, obanalyfac0_.C_Invoice_Region_ID as C22_527_0_, obanalyfac0_.C_Invoice_Country_ID as C23_527_0_, obanalyfac0_.Delivery_Location_ID as Delivery24_527_0_, obanalyfac0_.Delivery_Region_ID as Delivery25_527_0_, obanalyfac0_.Delivery_Country_ID as Delivery26_527_0_, obanalyfac0_.C_Paymentterm_ID as C27_527_0_, obanalyfac0_.M_Pricelist_ID as M28_527_0_, obanalyfac0_.FIN_Paymentmethod_ID as FIN29_527_0_, obanalyfac0_.C_Return_Reason_ID as C30_527_0_, obanalyfac0_.Documentno as Documentno527_0_, obanalyfac0_.Orderdate as Orderdate527_0_, obanalyfac0_.Dateordered as Dateord33_527_0_, obanalyfac0_.Datepromised as Datepro34_527_0_, obanalyfac0_.Linecount as Linecount527_0_, obanalyfac0_.Quantity as Quantity527_0_, obanalyfac0_.Qtynet as Qtynet527_0_, obanalyfac0_.Qtyreturned as Qtyretu38_527_0_, obanalyfac0_.Amount as Amount527_0_, obanalyfac0_.Amtnet as Amtnet527_0_, obanalyfac0_.Amtreturn as Amtreturn527_0_, obanalyfac0_.Taxamount as Taxamount527_0_, obanalyfac0_.Taxamtnet as Taxamtnet527_0_, obanalyfac0_.Taxamtreturn as Taxamtr44_527_0_, obanalyfac0_.Discamount as Discamount527_0_, obanalyfac0_.Discamtnet as Discamtnet527_0_, obanalyfac0_.Discamtreturn as Discamt47_527_0_, obanalyfac0_.Dirdiscamount as Dirdisc48_527_0_, obanalyfac0_.Dirdiscamtnet as Dirdisc49_527_0_, obanalyfac0_.Dirdiscamtreturn as Dirdisc50_527_0_, obanalyfac0_.Conversiondate as Convers51_527_0_, obanalyfac0_.EM_Obretan_Applications_ID as EM52_527_0_, obanalyfac0_.Weeknum as Weeknum527_0_, obanalyfac0_.EM_Obretan_Terminaltype_ID as EM54_527_0_, obanalyfac0_.Yearnum as Yearnum527_0_, obanalyfac0_.Ordertime as Ordertime527_0_, obanalyfac0_.M_Offer_ID as M57_527_0_, obanalyfac0_.City as City527_0_, obanalyfac0_.Postalcode as Postalcode527_0_, obanalyfac0_.Birthdate as Birthdate527_0_, obanalyfac0_.Hournum as Hournum527_0_, obanalyfac0_.Weekday as Weekday527_0_, obanalyfac0_.Monthnum as Monthnum527_0_, obanalyfac0_.C_Costcenter_ID as C64_527_0_ from OBANALY_FACT_SALESORDHEADER obanalyfac0_ where obanalyfac0_.C_Order_ID=$1
2018-09-04 16:57:12 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 0 DETAIL: parameters: $1 = 'EC02A976FDFB4C3BB36298895E72BD22'
2018-09-04 17:01:05 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 LOG: duration: 229559.616 ms execute <unnamed>: delete from C_Order where C_Order_ID=$1
2018-09-04 17:01:05 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 DETAIL: parameters: $1 = 'EC02A976FDFB4C3BB36298895E72BD22'
2018-09-04 17:01:11 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 LOG: duration: 6135.047 ms execute S_85969/C_85996: select obanalyfac0_.C_Order_ID as C9_622_1_, obanalyfac0_.Obanaly_Fact_Salesordheader_ID as Obanaly1_1_, obanalyfac0_.Obanaly_Fact_Salesordheader_ID as Obanaly1_527_0_, obanalyfac0_.AD_Client_ID as AD2_527_0_, obanalyfac0_.AD_Org_ID as AD3_527_0_, obanalyfac0_.Isactive as Isactive527_0_, obanalyfac0_.Created as Created527_0_, obanalyfac0_.Createdby as Createdby527_0_, obanalyfac0_.Updated as Updated527_0_, obanalyfac0_.Updatedby as Updatedby527_0_, obanalyfac0_.C_Order_ID as C9_527_0_, obanalyfac0_.C_Bpartner_ID as C10_527_0_, obanalyfac0_.C_Bp_Group_ID as C11_527_0_, obanalyfac0_.C_Bp_Taxcategory_ID as C12_527_0_, obanalyfac0_.C_Location_ID as C13_527_0_, obanalyfac0_.C_Region_ID as C14_527_0_, obanalyfac0_.C_Country_ID as C15_527_0_, obanalyfac0_.M_Warehouse_ID as M16_527_0_, obanalyfac0_.C_Currency_ID as C17_527_0_, obanalyfac0_.C_Doctype_ID as C18_527_0_, obanalyfac0_.C_Doctypetarget_ID as C19_527_0_, obanalyfac0_.Salesrep_ID as Salesrep20_527_0_, obanalyfac0_.Billto_Location_ID as Billto21_527_0_, obanalyfac0_.C_Invoice_Region_ID as C22_527_0_, obanalyfac0_.C_Invoice_Country_ID as C23_527_0_, obanalyfac0_.Delivery_Location_ID as Delivery24_527_0_, obanalyfac0_.Delivery_Region_ID as Delivery25_527_0_, obanalyfac0_.Delivery_Country_ID as Delivery26_527_0_, obanalyfac0_.C_Paymentterm_ID as C27_527_0_, obanalyfac0_.M_Pricelist_ID as M28_527_0_, obanalyfac0_.FIN_Paymentmethod_ID as FIN29_527_0_, obanalyfac0_.C_Return_Reason_ID as C30_527_0_, obanalyfac0_.Documentno as Documentno527_0_, obanalyfac0_.Orderdate as Orderdate527_0_, obanalyfac0_.Dateordered as Dateord33_527_0_, obanalyfac0_.Datepromised as Datepro34_527_0_, obanalyfac0_.Linecount as Linecount527_0_, obanalyfac0_.Quantity as Quantity527_0_, obanalyfac0_.Qtynet as Qtynet527_0_, obanalyfac0_.Qtyreturned as Qtyretu38_527_0_, obanalyfac0_.Amount as Amount527_0_, obanalyfac0_.Amtnet as Amtnet527_0_, obanalyfac0_.Amtreturn as Amtreturn527_0_, obanalyfac0_.Taxamount as Taxamount527_0_, obanalyfac0_.Taxamtnet as Taxamtnet527_0_, obanalyfac0_.Taxamtreturn as Taxamtr44_527_0_, obanalyfac0_.Discamount as Discamount527_0_, obanalyfac0_.Discamtnet as Discamtnet527_0_, obanalyfac0_.Discamtreturn as Discamt47_527_0_, obanalyfac0_.Dirdiscamount as Dirdisc48_527_0_, obanalyfac0_.Dirdiscamtnet as Dirdisc49_527_0_, obanalyfac0_.Dirdiscamtreturn as Dirdisc50_527_0_, obanalyfac0_.Conversiondate as Convers51_527_0_, obanalyfac0_.EM_Obretan_Applications_ID as EM52_527_0_, obanalyfac0_.Weeknum as Weeknum527_0_, obanalyfac0_.EM_Obretan_Terminaltype_ID as EM54_527_0_, obanalyfac0_.Yearnum as Yearnum527_0_, obanalyfac0_.Ordertime as Ordertime527_0_, obanalyfac0_.M_Offer_ID as M57_527_0_, obanalyfac0_.City as City527_0_, obanalyfac0_.Postalcode as Postalcode527_0_, obanalyfac0_.Birthdate as Birthdate527_0_, obanalyfac0_.Hournum as Hournum527_0_, obanalyfac0_.Weekday as Weekday527_0_, obanalyfac0_.Monthnum as Monthnum527_0_, obanalyfac0_.C_Costcenter_ID as C64_527_0_ from OBANALY_FACT_SALESORDHEADER obanalyfac0_ where obanalyfac0_.C_Order_ID=$1
2018-09-04 17:01:11 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 DETAIL: parameters: $1 = 'DE23C98F09A742AA9D8E557B2558F269'
2018-09-04 17:04:37 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 LOG: duration: 199649.408 ms execute <unnamed>: delete from C_Order where C_Order_ID=$1
2018-09-04 17:04:37 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 DETAIL: parameters: $1 = 'DE23C98F09A742AA9D8E557B2558F269'
2018-09-04 17:04:43 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 LOG: duration: 6084.936 ms execute S_85969/C_86011: select obanalyfac0_.C_Order_ID as C9_622_1_, obanalyfac0_.Obanaly_Fact_Salesordheader_ID as Obanaly1_1_, obanalyfac0_.Obanaly_Fact_Salesordheader_ID as Obanaly1_527_0_, obanalyfac0_.AD_Client_ID as AD2_527_0_, obanalyfac0_.AD_Org_ID as AD3_527_0_, obanalyfac0_.Isactive as Isactive527_0_, obanalyfac0_.Created as Created527_0_, obanalyfac0_.Createdby as Createdby527_0_, obanalyfac0_.Updated as Updated527_0_, obanalyfac0_.Updatedby as Updatedby527_0_, obanalyfac0_.C_Order_ID as C9_527_0_, obanalyfac0_.C_Bpartner_ID as C10_527_0_, obanalyfac0_.C_Bp_Group_ID as C11_527_0_, obanalyfac0_.C_Bp_Taxcategory_ID as C12_527_0_, obanalyfac0_.C_Location_ID as C13_527_0_, obanalyfac0_.C_Region_ID as C14_527_0_, obanalyfac0_.C_Country_ID as C15_527_0_, obanalyfac0_.M_Warehouse_ID as M16_527_0_, obanalyfac0_.C_Currency_ID as C17_527_0_, obanalyfac0_.C_Doctype_ID as C18_527_0_, obanalyfac0_.C_Doctypetarget_ID as C19_527_0_, obanalyfac0_.Salesrep_ID as Salesrep20_527_0_, obanalyfac0_.Billto_Location_ID as Billto21_527_0_, obanalyfac0_.C_Invoice_Region_ID as C22_527_0_, obanalyfac0_.C_Invoice_Country_ID as C23_527_0_, obanalyfac0_.Delivery_Location_ID as Delivery24_527_0_, obanalyfac0_.Delivery_Region_ID as Delivery25_527_0_, obanalyfac0_.Delivery_Country_ID as Delivery26_527_0_, obanalyfac0_.C_Paymentterm_ID as C27_527_0_, obanalyfac0_.M_Pricelist_ID as M28_527_0_, obanalyfac0_.FIN_Paymentmethod_ID as FIN29_527_0_, obanalyfac0_.C_Return_Reason_ID as C30_527_0_, obanalyfac0_.Documentno as Documentno527_0_, obanalyfac0_.Orderdate as Orderdate527_0_, obanalyfac0_.Dateordered as Dateord33_527_0_, obanalyfac0_.Datepromised as Datepro34_527_0_, obanalyfac0_.Linecount as Linecount527_0_, obanalyfac0_.Quantity as Quantity527_0_, obanalyfac0_.Qtynet as Qtynet527_0_, obanalyfac0_.Qtyreturned as Qtyretu38_527_0_, obanalyfac0_.Amount as Amount527_0_, obanalyfac0_.Amtnet as Amtnet527_0_, obanalyfac0_.Amtreturn as Amtreturn527_0_, obanalyfac0_.Taxamount as Taxamount527_0_, obanalyfac0_.Taxamtnet as Taxamtnet527_0_, obanalyfac0_.Taxamtreturn as Taxamtr44_527_0_, obanalyfac0_.Discamount as Discamount527_0_, obanalyfac0_.Discamtnet as Discamtnet527_0_, obanalyfac0_.Discamtreturn as Discamt47_527_0_, obanalyfac0_.Dirdiscamount as Dirdisc48_527_0_, obanalyfac0_.Dirdiscamtnet as Dirdisc49_527_0_, obanalyfac0_.Dirdiscamtreturn as Dirdisc50_527_0_, obanalyfac0_.Conversiondate as Convers51_527_0_, obanalyfac0_.EM_Obretan_Applications_ID as EM52_527_0_, obanalyfac0_.Weeknum as Weeknum527_0_, obanalyfac0_.EM_Obretan_Terminaltype_ID as EM54_527_0_, obanalyfac0_.Yearnum as Yearnum527_0_, obanalyfac0_.Ordertime as Ordertime527_0_, obanalyfac0_.M_Offer_ID as M57_527_0_, obanalyfac0_.City as City527_0_, obanalyfac0_.Postalcode as Postalcode527_0_, obanalyfac0_.Birthdate as Birthdate527_0_, obanalyfac0_.Hournum as Hournum527_0_, obanalyfac0_.Weekday as Weekday527_0_, obanalyfac0_.Monthnum as Monthnum527_0_, obanalyfac0_.C_Costcenter_ID as C64_527_0_ from OBANALY_FACT_SALESORDHEADER obanalyfac0_ where obanalyfac0_.C_Order_ID=$1
2018-09-04 17:04:43 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 DETAIL: parameters: $1 = '67A344719192490C9E0B152671EA66B1'
2018-09-04 17:09:37 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 LOG: duration: 294220.519 ms execute <unnamed>: delete from C_Order where C_Order_ID=$1
2018-09-04 17:09:37 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 DETAIL: parameters: $1 = '67A344719192490C9E0B152671EA66B1'
2018-09-04 17:09:45 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 LOG: duration: 8158.133 ms execute S_85969/C_86019: select obanalyfac0_.C_Order_ID as C9_622_1_, obanalyfac0_.Obanaly_Fact_Salesordheader_ID as Obanaly1_1_, obanalyfac0_.Obanaly_Fact_Salesordheader_ID as Obanaly1_527_0_, obanalyfac0_.AD_Client_ID as AD2_527_0_, obanalyfac0_.AD_Org_ID as AD3_527_0_, obanalyfac0_.Isactive as Isactive527_0_, obanalyfac0_.Created as Created527_0_, obanalyfac0_.Createdby as Createdby527_0_, obanalyfac0_.Updated as Updated527_0_, obanalyfac0_.Updatedby as Updatedby527_0_, obanalyfac0_.C_Order_ID as C9_527_0_, obanalyfac0_.C_Bpartner_ID as C10_527_0_, obanalyfac0_.C_Bp_Group_ID as C11_527_0_, obanalyfac0_.C_Bp_Taxcategory_ID as C12_527_0_, obanalyfac0_.C_Location_ID as C13_527_0_, obanalyfac0_.C_Region_ID as C14_527_0_, obanalyfac0_.C_Country_ID as C15_527_0_, obanalyfac0_.M_Warehouse_ID as M16_527_0_, obanalyfac0_.C_Currency_ID as C17_527_0_, obanalyfac0_.C_Doctype_ID as C18_527_0_, obanalyfac0_.C_Doctypetarget_ID as C19_527_0_, obanalyfac0_.Salesrep_ID as Salesrep20_527_0_, obanalyfac0_.Billto_Location_ID as Billto21_527_0_, obanalyfac0_.C_Invoice_Region_ID as C22_527_0_, obanalyfac0_.C_Invoice_Country_ID as C23_527_0_, obanalyfac0_.Delivery_Location_ID as Delivery24_527_0_, obanalyfac0_.Delivery_Region_ID as Delivery25_527_0_, obanalyfac0_.Delivery_Country_ID as Delivery26_527_0_, obanalyfac0_.C_Paymentterm_ID as C27_527_0_, obanalyfac0_.M_Pricelist_ID as M28_527_0_, obanalyfac0_.FIN_Paymentmethod_ID as FIN29_527_0_, obanalyfac0_.C_Return_Reason_ID as C30_527_0_, obanalyfac0_.Documentno as Documentno527_0_, obanalyfac0_.Orderdate as Orderdate527_0_, obanalyfac0_.Dateordered as Dateord33_527_0_, obanalyfac0_.Datepromised as Datepro34_527_0_, obanalyfac0_.Linecount as Linecount527_0_, obanalyfac0_.Quantity as Quantity527_0_, obanalyfac0_.Qtynet as Qtynet527_0_, obanalyfac0_.Qtyreturned as Qtyretu38_527_0_, obanalyfac0_.Amount as Amount527_0_, obanalyfac0_.Amtnet as Amtnet527_0_, obanalyfac0_.Amtreturn as Amtreturn527_0_, obanalyfac0_.Taxamount as Taxamount527_0_, obanalyfac0_.Taxamtnet as Taxamtnet527_0_, obanalyfac0_.Taxamtreturn as Taxamtr44_527_0_, obanalyfac0_.Discamount as Discamount527_0_, obanalyfac0_.Discamtnet as Discamtnet527_0_, obanalyfac0_.Discamtreturn as Discamt47_527_0_, obanalyfac0_.Dirdiscamount as Dirdisc48_527_0_, obanalyfac0_.Dirdiscamtnet as Dirdisc49_527_0_, obanalyfac0_.Dirdiscamtreturn as Dirdisc50_527_0_, obanalyfac0_.Conversiondate as Convers51_527_0_, obanalyfac0_.EM_Obretan_Applications_ID as EM52_527_0_, obanalyfac0_.Weeknum as Weeknum527_0_, obanalyfac0_.EM_Obretan_Terminaltype_ID as EM54_527_0_, obanalyfac0_.Yearnum as Yearnum527_0_, obanalyfac0_.Ordertime as Ordertime527_0_, obanalyfac0_.M_Offer_ID as M57_527_0_, obanalyfac0_.City as City527_0_, obanalyfac0_.Postalcode as Postalcode527_0_, obanalyfac0_.Birthdate as Birthdate527_0_, obanalyfac0_.Hournum as Hournum527_0_, obanalyfac0_.Weekday as Weekday527_0_, obanalyfac0_.Monthnum as Monthnum527_0_, obanalyfac0_.C_Costcenter_ID as C64_527_0_ from OBANALY_FACT_SALESORDHEADER obanalyfac0_ where obanalyfac0_.C_Order_ID=$1
2018-09-04 17:09:45 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 DETAIL: parameters: $1 = '24E95D1C8D7843F6966165A9334AE479'
2018-09-04 17:13:16 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 LOG: duration: 210132.249 ms execute <unnamed>: delete from C_Order where C_Order_ID=$1
2018-09-04 17:13:16 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 DETAIL: parameters: $1 = '24E95D1C8D7843F6966165A9334AE479'
2018-09-04 17:13:34 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 LOG: duration: 18655.440 ms execute S_85969/C_86027: select obanalyfac0_.C_Order_ID as C9_622_1_, obanalyfac0_.Obanaly_Fact_Salesordheader_ID as Obanaly1_1_, obanalyfac0_.Obanaly_Fact_Salesordheader_ID as Obanaly1_527_0_, obanalyfac0_.AD_Client_ID as AD2_527_0_, obanalyfac0_.AD_Org_ID as AD3_527_0_, obanalyfac0_.Isactive as Isactive527_0_, obanalyfac0_.Created as Created527_0_, obanalyfac0_.Createdby as Createdby527_0_, obanalyfac0_.Updated as Updated527_0_, obanalyfac0_.Updatedby as Updatedby527_0_, obanalyfac0_.C_Order_ID as C9_527_0_, obanalyfac0_.C_Bpartner_ID as C10_527_0_, obanalyfac0_.C_Bp_Group_ID as C11_527_0_, obanalyfac0_.C_Bp_Taxcategory_ID as C12_527_0_, obanalyfac0_.C_Location_ID as C13_527_0_, obanalyfac0_.C_Region_ID as C14_527_0_, obanalyfac0_.C_Country_ID as C15_527_0_, obanalyfac0_.M_Warehouse_ID as M16_527_0_, obanalyfac0_.C_Currency_ID as C17_527_0_, obanalyfac0_.C_Doctype_ID as C18_527_0_, obanalyfac0_.C_Doctypetarget_ID as C19_527_0_, obanalyfac0_.Salesrep_ID as Salesrep20_527_0_, obanalyfac0_.Billto_Location_ID as Billto21_527_0_, obanalyfac0_.C_Invoice_Region_ID as C22_527_0_, obanalyfac0_.C_Invoice_Country_ID as C23_527_0_, obanalyfac0_.Delivery_Location_ID as Delivery24_527_0_, obanalyfac0_.Delivery_Region_ID as Delivery25_527_0_, obanalyfac0_.Delivery_Country_ID as Delivery26_527_0_, obanalyfac0_.C_Paymentterm_ID as C27_527_0_, obanalyfac0_.M_Pricelist_ID as M28_527_0_, obanalyfac0_.FIN_Paymentmethod_ID as FIN29_527_0_, obanalyfac0_.C_Return_Reason_ID as C30_527_0_, obanalyfac0_.Documentno as Documentno527_0_, obanalyfac0_.Orderdate as Orderdate527_0_, obanalyfac0_.Dateordered as Dateord33_527_0_, obanalyfac0_.Datepromised as Datepro34_527_0_, obanalyfac0_.Linecount as Linecount527_0_, obanalyfac0_.Quantity as Quantity527_0_, obanalyfac0_.Qtynet as Qtynet527_0_, obanalyfac0_.Qtyreturned as Qtyretu38_527_0_, obanalyfac0_.Amount as Amount527_0_, obanalyfac0_.Amtnet as Amtnet527_0_, obanalyfac0_.Amtreturn as Amtreturn527_0_, obanalyfac0_.Taxamount as Taxamount527_0_, obanalyfac0_.Taxamtnet as Taxamtnet527_0_, obanalyfac0_.Taxamtreturn as Taxamtr44_527_0_, obanalyfac0_.Discamount as Discamount527_0_, obanalyfac0_.Discamtnet as Discamtnet527_0_, obanalyfac0_.Discamtreturn as Discamt47_527_0_, obanalyfac0_.Dirdiscamount as Dirdisc48_527_0_, obanalyfac0_.Dirdiscamtnet as Dirdisc49_527_0_, obanalyfac0_.Dirdiscamtreturn as Dirdisc50_527_0_, obanalyfac0_.Conversiondate as Convers51_527_0_, obanalyfac0_.EM_Obretan_Applications_ID as EM52_527_0_, obanalyfac0_.Weeknum as Weeknum527_0_, obanalyfac0_.EM_Obretan_Terminaltype_ID as EM54_527_0_, obanalyfac0_.Yearnum as Yearnum527_0_, obanalyfac0_.Ordertime as Ordertime527_0_, obanalyfac0_.M_Offer_ID as M57_527_0_, obanalyfac0_.City as City527_0_, obanalyfac0_.Postalcode as Postalcode527_0_, obanalyfac0_.Birthdate as Birthdate527_0_, obanalyfac0_.Hournum as Hournum527_0_, obanalyfac0_.Weekday as Weekday527_0_, obanalyfac0_.Monthnum as Monthnum527_0_, obanalyfac0_.C_Costcenter_ID as C64_527_0_ from OBANALY_FACT_SALESORDHEADER obanalyfac0_ where obanalyfac0_.C_Order_ID=$1
2018-09-04 17:13:34 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 DETAIL: parameters: $1 = 'CAC7C6177111459F837297F44375329D'
2018-09-04 17:17:02 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 LOG: duration: 207611.213 ms execute S_86046: delete from C_Order where C_Order_ID=$1
2018-09-04 17:17:02 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 DETAIL: parameters: $1 = 'CAC7C6177111459F837297F44375329D'
2018-09-04 17:17:50 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 LOG: duration: 46998.621 ms execute S_85969/C_86050: select obanalyfac0_.C_Order_ID as C9_622_1_, obanalyfac0_.Obanaly_Fact_Salesordheader_ID as Obanaly1_1_, obanalyfac0_.Obanaly_Fact_Salesordheader_ID as Obanaly1_527_0_, obanalyfac0_.AD_Client_ID as AD2_527_0_, obanalyfac0_.AD_Org_ID as AD3_527_0_, obanalyfac0_.Isactive as Isactive527_0_, obanalyfac0_.Created as Created527_0_, obanalyfac0_.Createdby as Createdby527_0_, obanalyfac0_.Updated as Updated527_0_, obanalyfac0_.Updatedby as Updatedby527_0_, obanalyfac0_.C_Order_ID as C9_527_0_, obanalyfac0_.C_Bpartner_ID as C10_527_0_, obanalyfac0_.C_Bp_Group_ID as C11_527_0_, obanalyfac0_.C_Bp_Taxcategory_ID as C12_527_0_, obanalyfac0_.C_Location_ID as C13_527_0_, obanalyfac0_.C_Region_ID as C14_527_0_, obanalyfac0_.C_Country_ID as C15_527_0_, obanalyfac0_.M_Warehouse_ID as M16_527_0_, obanalyfac0_.C_Currency_ID as C17_527_0_, obanalyfac0_.C_Doctype_ID as C18_527_0_, obanalyfac0_.C_Doctypetarget_ID as C19_527_0_, obanalyfac0_.Salesrep_ID as Salesrep20_527_0_, obanalyfac0_.Billto_Location_ID as Billto21_527_0_, obanalyfac0_.C_Invoice_Region_ID as C22_527_0_, obanalyfac0_.C_Invoice_Country_ID as C23_527_0_, obanalyfac0_.Delivery_Location_ID as Delivery24_527_0_, obanalyfac0_.Delivery_Region_ID as Delivery25_527_0_, obanalyfac0_.Delivery_Country_ID as Delivery26_527_0_, obanalyfac0_.C_Paymentterm_ID as C27_527_0_, obanalyfac0_.M_Pricelist_ID as M28_527_0_, obanalyfac0_.FIN_Paymentmethod_ID as FIN29_527_0_, obanalyfac0_.C_Return_Reason_ID as C30_527_0_, obanalyfac0_.Documentno as Documentno527_0_, obanalyfac0_.Orderdate as Orderdate527_0_, obanalyfac0_.Dateordered as Dateord33_527_0_, obanalyfac0_.Datepromised as Datepro34_527_0_, obanalyfac0_.Linecount as Linecount527_0_, obanalyfac0_.Quantity as Quantity527_0_, obanalyfac0_.Qtynet as Qtynet527_0_, obanalyfac0_.Qtyreturned as Qtyretu38_527_0_, obanalyfac0_.Amount as Amount527_0_, obanalyfac0_.Amtnet as Amtnet527_0_, obanalyfac0_.Amtreturn as Amtreturn527_0_, obanalyfac0_.Taxamount as Taxamount527_0_, obanalyfac0_.Taxamtnet as Taxamtnet527_0_, obanalyfac0_.Taxamtreturn as Taxamtr44_527_0_, obanalyfac0_.Discamount as Discamount527_0_, obanalyfac0_.Discamtnet as Discamtnet527_0_, obanalyfac0_.Discamtreturn as Discamt47_527_0_, obanalyfac0_.Dirdiscamount as Dirdisc48_527_0_, obanalyfac0_.Dirdiscamtnet as Dirdisc49_527_0_, obanalyfac0_.Dirdiscamtreturn as Dirdisc50_527_0_, obanalyfac0_.Conversiondate as Convers51_527_0_, obanalyfac0_.EM_Obretan_Applications_ID as EM52_527_0_, obanalyfac0_.Weeknum as Weeknum527_0_, obanalyfac0_.EM_Obretan_Terminaltype_ID as EM54_527_0_, obanalyfac0_.Yearnum as Yearnum527_0_, obanalyfac0_.Ordertime as Ordertime527_0_, obanalyfac0_.M_Offer_ID as M57_527_0_, obanalyfac0_.City as City527_0_, obanalyfac0_.Postalcode as Postalcode527_0_, obanalyfac0_.Birthdate as Birthdate527_0_, obanalyfac0_.Hournum as Hournum527_0_, obanalyfac0_.Weekday as Weekday527_0_, obanalyfac0_.Monthnum as Monthnum527_0_, obanalyfac0_.C_Costcenter_ID as C64_527_0_ from OBANALY_FACT_SALESORDHEADER obanalyfac0_ where obanalyfac0_.C_Order_ID=$1
2018-09-04 17:17:50 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 DETAIL: parameters: $1 = '9A7173A693674C4E9BAC4BB7D59CD60C'
2018-09-04 17:21:33 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 LOG: duration: 223872.515 ms execute S_86046: delete from C_Order where C_Order_ID=$1
2018-09-04 17:21:33 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 DETAIL: parameters: $1 = '9A7173A693674C4E9BAC4BB7D59CD60C'
2018-09-04 17:22:04 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 LOG: duration: 29891.331 ms execute S_85969/C_86058: select obanalyfac0_.C_Order_ID as C9_622_1_, obanalyfac0_.Obanaly_Fact_Salesordheader_ID as Obanaly1_1_, obanalyfac0_.Obanaly_Fact_Salesordheader_ID as Obanaly1_527_0_, obanalyfac0_.AD_Client_ID as AD2_527_0_, obanalyfac0_.AD_Org_ID as AD3_527_0_, obanalyfac0_.Isactive as Isactive527_0_, obanalyfac0_.Created as Created527_0_, obanalyfac0_.Createdby as Createdby527_0_, obanalyfac0_.Updated as Updated527_0_, obanalyfac0_.Updatedby as Updatedby527_0_, obanalyfac0_.C_Order_ID as C9_527_0_, obanalyfac0_.C_Bpartner_ID as C10_527_0_, obanalyfac0_.C_Bp_Group_ID as C11_527_0_, obanalyfac0_.C_Bp_Taxcategory_ID as C12_527_0_, obanalyfac0_.C_Location_ID as C13_527_0_, obanalyfac0_.C_Region_ID as C14_527_0_, obanalyfac0_.C_Country_ID as C15_527_0_, obanalyfac0_.M_Warehouse_ID as M16_527_0_, obanalyfac0_.C_Currency_ID as C17_527_0_, obanalyfac0_.C_Doctype_ID as C18_527_0_, obanalyfac0_.C_Doctypetarget_ID as C19_527_0_, obanalyfac0_.Salesrep_ID as Salesrep20_527_0_, obanalyfac0_.Billto_Location_ID as Billto21_527_0_, obanalyfac0_.C_Invoice_Region_ID as C22_527_0_, obanalyfac0_.C_Invoice_Country_ID as C23_527_0_, obanalyfac0_.Delivery_Location_ID as Delivery24_527_0_, obanalyfac0_.Delivery_Region_ID as Delivery25_527_0_, obanalyfac0_.Delivery_Country_ID as Delivery26_527_0_, obanalyfac0_.C_Paymentterm_ID as C27_527_0_, obanalyfac0_.M_Pricelist_ID as M28_527_0_, obanalyfac0_.FIN_Paymentmethod_ID as FIN29_527_0_, obanalyfac0_.C_Return_Reason_ID as C30_527_0_, obanalyfac0_.Documentno as Documentno527_0_, obanalyfac0_.Orderdate as Orderdate527_0_, obanalyfac0_.Dateordered as Dateord33_527_0_, obanalyfac0_.Datepromised as Datepro34_527_0_, obanalyfac0_.Linecount as Linecount527_0_, obanalyfac0_.Quantity as Quantity527_0_, obanalyfac0_.Qtynet as Qtynet527_0_, obanalyfac0_.Qtyreturned as Qtyretu38_527_0_, obanalyfac0_.Amount as Amount527_0_, obanalyfac0_.Amtnet as Amtnet527_0_, obanalyfac0_.Amtreturn as Amtreturn527_0_, obanalyfac0_.Taxamount as Taxamount527_0_, obanalyfac0_.Taxamtnet as Taxamtnet527_0_, obanalyfac0_.Taxamtreturn as Taxamtr44_527_0_, obanalyfac0_.Discamount as Discamount527_0_, obanalyfac0_.Discamtnet as Discamtnet527_0_, obanalyfac0_.Discamtreturn as Discamt47_527_0_, obanalyfac0_.Dirdiscamount as Dirdisc48_527_0_, obanalyfac0_.Dirdiscamtnet as Dirdisc49_527_0_, obanalyfac0_.Dirdiscamtreturn as Dirdisc50_527_0_, obanalyfac0_.Conversiondate as Convers51_527_0_, obanalyfac0_.EM_Obretan_Applications_ID as EM52_527_0_, obanalyfac0_.Weeknum as Weeknum527_0_, obanalyfac0_.EM_Obretan_Terminaltype_ID as EM54_527_0_, obanalyfac0_.Yearnum as Yearnum527_0_, obanalyfac0_.Ordertime as Ordertime527_0_, obanalyfac0_.M_Offer_ID as M57_527_0_, obanalyfac0_.City as City527_0_, obanalyfac0_.Postalcode as Postalcode527_0_, obanalyfac0_.Birthdate as Birthdate527_0_, obanalyfac0_.Hournum as Hournum527_0_, obanalyfac0_.Weekday as Weekday527_0_, obanalyfac0_.Monthnum as Monthnum527_0_, obanalyfac0_.C_Costcenter_ID as C64_527_0_ from OBANALY_FACT_SALESORDHEADER obanalyfac0_ where obanalyfac0_.C_Order_ID=$1
2018-09-04 17:22:04 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 DETAIL: parameters: $1 = 'B6F3CB773F2842ECA2D976BA4CC54095'
2018-09-04 17:24:52 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 LOG: duration: 168059.401 ms execute S_86046: delete from C_Order where C_Order_ID=$1
2018-09-04 17:24:52 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 DETAIL: parameters: $1 = 'B6F3CB773F2842ECA2D976BA4CC54095'
2018-09-04 17:25:05 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 LOG: duration: 12528.152 ms execute S_85969/C_86076: select obanalyfac0_.C_Order_ID as C9_622_1_, obanalyfac0_.Obanaly_Fact_Salesordheader_ID as Obanaly1_1_, obanalyfac0_.Obanaly_Fact_Salesordheader_ID as Obanaly1_527_0_, obanalyfac0_.AD_Client_ID as AD2_527_0_, obanalyfac0_.AD_Org_ID as AD3_527_0_, obanalyfac0_.Isactive as Isactive527_0_, obanalyfac0_.Created as Created527_0_, obanalyfac0_.Createdby as Createdby527_0_, obanalyfac0_.Updated as Updated527_0_, obanalyfac0_.Updatedby as Updatedby527_0_, obanalyfac0_.C_Order_ID as C9_527_0_, obanalyfac0_.C_Bpartner_ID as C10_527_0_, obanalyfac0_.C_Bp_Group_ID as C11_527_0_, obanalyfac0_.C_Bp_Taxcategory_ID as C12_527_0_, obanalyfac0_.C_Location_ID as C13_527_0_, obanalyfac0_.C_Region_ID as C14_527_0_, obanalyfac0_.C_Country_ID as C15_527_0_, obanalyfac0_.M_Warehouse_ID as M16_527_0_, obanalyfac0_.C_Currency_ID as C17_527_0_, obanalyfac0_.C_Doctype_ID as C18_527_0_, obanalyfac0_.C_Doctypetarget_ID as C19_527_0_, obanalyfac0_.Salesrep_ID as Salesrep20_527_0_, obanalyfac0_.Billto_Location_ID as Billto21_527_0_, obanalyfac0_.C_Invoice_Region_ID as C22_527_0_, obanalyfac0_.C_Invoice_Country_ID as C23_527_0_, obanalyfac0_.Delivery_Location_ID as Delivery24_527_0_, obanalyfac0_.Delivery_Region_ID as Delivery25_527_0_, obanalyfac0_.Delivery_Country_ID as Delivery26_527_0_, obanalyfac0_.C_Paymentterm_ID as C27_527_0_, obanalyfac0_.M_Pricelist_ID as M28_527_0_, obanalyfac0_.FIN_Paymentmethod_ID as FIN29_527_0_, obanalyfac0_.C_Return_Reason_ID as C30_527_0_, obanalyfac0_.Documentno as Documentno527_0_, obanalyfac0_.Orderdate as Orderdate527_0_, obanalyfac0_.Dateordered as Dateord33_527_0_, obanalyfac0_.Datepromised as Datepro34_527_0_, obanalyfac0_.Linecount as Linecount527_0_, obanalyfac0_.Quantity as Quantity527_0_, obanalyfac0_.Qtynet as Qtynet527_0_, obanalyfac0_.Qtyreturned as Qtyretu38_527_0_, obanalyfac0_.Amount as Amount527_0_, obanalyfac0_.Amtnet as Amtnet527_0_, obanalyfac0_.Amtreturn as Amtreturn527_0_, obanalyfac0_.Taxamount as Taxamount527_0_, obanalyfac0_.Taxamtnet as Taxamtnet527_0_, obanalyfac0_.Taxamtreturn as Taxamtr44_527_0_, obanalyfac0_.Discamount as Discamount527_0_, obanalyfac0_.Discamtnet as Discamtnet527_0_, obanalyfac0_.Discamtreturn as Discamt47_527_0_, obanalyfac0_.Dirdiscamount as Dirdisc48_527_0_, obanalyfac0_.Dirdiscamtnet as Dirdisc49_527_0_, obanalyfac0_.Dirdiscamtreturn as Dirdisc50_527_0_, obanalyfac0_.Conversiondate as Convers51_527_0_, obanalyfac0_.EM_Obretan_Applications_ID as EM52_527_0_, obanalyfac0_.Weeknum as Weeknum527_0_, obanalyfac0_.EM_Obretan_Terminaltype_ID as EM54_527_0_, obanalyfac0_.Yearnum as Yearnum527_0_, obanalyfac0_.Ordertime as Ordertime527_0_, obanalyfac0_.M_Offer_ID as M57_527_0_, obanalyfac0_.City as City527_0_, obanalyfac0_.Postalcode as Postalcode527_0_, obanalyfac0_.Birthdate as Birthdate527_0_, obanalyfac0_.Hournum as Hournum527_0_, obanalyfac0_.Weekday as Weekday527_0_, obanalyfac0_.Monthnum as Monthnum527_0_, obanalyfac0_.C_Costcenter_ID as C64_527_0_ from OBANALY_FACT_SALESORDHEADER obanalyfac0_ where obanalyfac0_.C_Order_ID=$1
2018-09-04 17:25:05 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 DETAIL: parameters: $1 = '04D7B78894EA42C2B7430C8BDA97421E'
2018-09-04 17:27:31 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 LOG: duration: 144631.263 ms execute S_86046: delete from C_Order where C_Order_ID=$1
2018-09-04 17:27:31 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 DETAIL: parameters: $1 = '04D7B78894EA42C2B7430C8BDA97421E'
2018-09-04 17:28:11 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 LOG: duration: 40184.599 ms execute S_85969/C_86092: select obanalyfac0_.C_Order_ID as C9_622_1_, obanalyfac0_.Obanaly_Fact_Salesordheader_ID as Obanaly1_1_, obanalyfac0_.Obanaly_Fact_Salesordheader_ID as Obanaly1_527_0_, obanalyfac0_.AD_Client_ID as AD2_527_0_, obanalyfac0_.AD_Org_ID as AD3_527_0_, obanalyfac0_.Isactive as Isactive527_0_, obanalyfac0_.Created as Created527_0_, obanalyfac0_.Createdby as Createdby527_0_, obanalyfac0_.Updated as Updated527_0_, obanalyfac0_.Updatedby as Updatedby527_0_, obanalyfac0_.C_Order_ID as C9_527_0_, obanalyfac0_.C_Bpartner_ID as C10_527_0_, obanalyfac0_.C_Bp_Group_ID as C11_527_0_, obanalyfac0_.C_Bp_Taxcategory_ID as C12_527_0_, obanalyfac0_.C_Location_ID as C13_527_0_, obanalyfac0_.C_Region_ID as C14_527_0_, obanalyfac0_.C_Country_ID as C15_527_0_, obanalyfac0_.M_Warehouse_ID as M16_527_0_, obanalyfac0_.C_Currency_ID as C17_527_0_, obanalyfac0_.C_Doctype_ID as C18_527_0_, obanalyfac0_.C_Doctypetarget_ID as C19_527_0_, obanalyfac0_.Salesrep_ID as Salesrep20_527_0_, obanalyfac0_.Billto_Location_ID as Billto21_527_0_, obanalyfac0_.C_Invoice_Region_ID as C22_527_0_, obanalyfac0_.C_Invoice_Country_ID as C23_527_0_, obanalyfac0_.Delivery_Location_ID as Delivery24_527_0_, obanalyfac0_.Delivery_Region_ID as Delivery25_527_0_, obanalyfac0_.Delivery_Country_ID as Delivery26_527_0_, obanalyfac0_.C_Paymentterm_ID as C27_527_0_, obanalyfac0_.M_Pricelist_ID as M28_527_0_, obanalyfac0_.FIN_Paymentmethod_ID as FIN29_527_0_, obanalyfac0_.C_Return_Reason_ID as C30_527_0_, obanalyfac0_.Documentno as Documentno527_0_, obanalyfac0_.Orderdate as Orderdate527_0_, obanalyfac0_.Dateordered as Dateord33_527_0_, obanalyfac0_.Datepromised as Datepro34_527_0_, obanalyfac0_.Linecount as Linecount527_0_, obanalyfac0_.Quantity as Quantity527_0_, obanalyfac0_.Qtynet as Qtynet527_0_, obanalyfac0_.Qtyreturned as Qtyretu38_527_0_, obanalyfac0_.Amount as Amount527_0_, obanalyfac0_.Amtnet as Amtnet527_0_, obanalyfac0_.Amtreturn as Amtreturn527_0_, obanalyfac0_.Taxamount as Taxamount527_0_, obanalyfac0_.Taxamtnet as Taxamtnet527_0_, obanalyfac0_.Taxamtreturn as Taxamtr44_527_0_, obanalyfac0_.Discamount as Discamount527_0_, obanalyfac0_.Discamtnet as Discamtnet527_0_, obanalyfac0_.Discamtreturn as Discamt47_527_0_, obanalyfac0_.Dirdiscamount as Dirdisc48_527_0_, obanalyfac0_.Dirdiscamtnet as Dirdisc49_527_0_, obanalyfac0_.Dirdiscamtreturn as Dirdisc50_527_0_, obanalyfac0_.Conversiondate as Convers51_527_0_, obanalyfac0_.EM_Obretan_Applications_ID as EM52_527_0_, obanalyfac0_.Weeknum as Weeknum527_0_, obanalyfac0_.EM_Obretan_Terminaltype_ID as EM54_527_0_, obanalyfac0_.Yearnum as Yearnum527_0_, obanalyfac0_.Ordertime as Ordertime527_0_, obanalyfac0_.M_Offer_ID as M57_527_0_, obanalyfac0_.City as City527_0_, obanalyfac0_.Postalcode as Postalcode527_0_, obanalyfac0_.Birthdate as Birthdate527_0_, obanalyfac0_.Hournum as Hournum527_0_, obanalyfac0_.Weekday as Weekday527_0_, obanalyfac0_.Monthnum as Monthnum527_0_, obanalyfac0_.C_Costcenter_ID as C64_527_0_ from OBANALY_FACT_SALESORDHEADER obanalyfac0_ where obanalyfac0_.C_Order_ID=$1
2018-09-04 17:28:11 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 DETAIL: parameters: $1 = '44B6849C39C147D6BE95EA12EA707F09'
2018-09-04 17:29:59 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 LOG: duration: 102715.663 ms execute S_86046: delete from C_Order where C_Order_ID=$1
2018-09-04 17:29:59 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 DETAIL: parameters: $1 = '44B6849C39C147D6BE95EA12EA707F09'
2018-09-04 17:30:05 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 LOG: duration: 6066.966 ms execute S_85969/C_86107: select obanalyfac0_.C_Order_ID as C9_622_1_, obanalyfac0_.Obanaly_Fact_Salesordheader_ID as Obanaly1_1_, obanalyfac0_.Obanaly_Fact_Salesordheader_ID as Obanaly1_527_0_, obanalyfac0_.AD_Client_ID as AD2_527_0_, obanalyfac0_.AD_Org_ID as AD3_527_0_, obanalyfac0_.Isactive as Isactive527_0_, obanalyfac0_.Created as Created527_0_, obanalyfac0_.Createdby as Createdby527_0_, obanalyfac0_.Updated as Updated527_0_, obanalyfac0_.Updatedby as Updatedby527_0_, obanalyfac0_.C_Order_ID as C9_527_0_, obanalyfac0_.C_Bpartner_ID as C10_527_0_, obanalyfac0_.C_Bp_Group_ID as C11_527_0_, obanalyfac0_.C_Bp_Taxcategory_ID as C12_527_0_, obanalyfac0_.C_Location_ID as C13_527_0_, obanalyfac0_.C_Region_ID as C14_527_0_, obanalyfac0_.C_Country_ID as C15_527_0_, obanalyfac0_.M_Warehouse_ID as M16_527_0_, obanalyfac0_.C_Currency_ID as C17_527_0_, obanalyfac0_.C_Doctype_ID as C18_527_0_, obanalyfac0_.C_Doctypetarget_ID as C19_527_0_, obanalyfac0_.Salesrep_ID as Salesrep20_527_0_, obanalyfac0_.Billto_Location_ID as Billto21_527_0_, obanalyfac0_.C_Invoice_Region_ID as C22_527_0_, obanalyfac0_.C_Invoice_Country_ID as C23_527_0_, obanalyfac0_.Delivery_Location_ID as Delivery24_527_0_, obanalyfac0_.Delivery_Region_ID as Delivery25_527_0_, obanalyfac0_.Delivery_Country_ID as Delivery26_527_0_, obanalyfac0_.C_Paymentterm_ID as C27_527_0_, obanalyfac0_.M_Pricelist_ID as M28_527_0_, obanalyfac0_.FIN_Paymentmethod_ID as FIN29_527_0_, obanalyfac0_.C_Return_Reason_ID as C30_527_0_, obanalyfac0_.Documentno as Documentno527_0_, obanalyfac0_.Orderdate as Orderdate527_0_, obanalyfac0_.Dateordered as Dateord33_527_0_, obanalyfac0_.Datepromised as Datepro34_527_0_, obanalyfac0_.Linecount as Linecount527_0_, obanalyfac0_.Quantity as Quantity527_0_, obanalyfac0_.Qtynet as Qtynet527_0_, obanalyfac0_.Qtyreturned as Qtyretu38_527_0_, obanalyfac0_.Amount as Amount527_0_, obanalyfac0_.Amtnet as Amtnet527_0_, obanalyfac0_.Amtreturn as Amtreturn527_0_, obanalyfac0_.Taxamount as Taxamount527_0_, obanalyfac0_.Taxamtnet as Taxamtnet527_0_, obanalyfac0_.Taxamtreturn as Taxamtr44_527_0_, obanalyfac0_.Discamount as Discamount527_0_, obanalyfac0_.Discamtnet as Discamtnet527_0_, obanalyfac0_.Discamtreturn as Discamt47_527_0_, obanalyfac0_.Dirdiscamount as Dirdisc48_527_0_, obanalyfac0_.Dirdiscamtnet as Dirdisc49_527_0_, obanalyfac0_.Dirdiscamtreturn as Dirdisc50_527_0_, obanalyfac0_.Conversiondate as Convers51_527_0_, obanalyfac0_.EM_Obretan_Applications_ID as EM52_527_0_, obanalyfac0_.Weeknum as Weeknum527_0_, obanalyfac0_.EM_Obretan_Terminaltype_ID as EM54_527_0_, obanalyfac0_.Yearnum as Yearnum527_0_, obanalyfac0_.Ordertime as Ordertime527_0_, obanalyfac0_.M_Offer_ID as M57_527_0_, obanalyfac0_.City as City527_0_, obanalyfac0_.Postalcode as Postalcode527_0_, obanalyfac0_.Birthdate as Birthdate527_0_, obanalyfac0_.Hournum as Hournum527_0_, obanalyfac0_.Weekday as Weekday527_0_, obanalyfac0_.Monthnum as Monthnum527_0_, obanalyfac0_.C_Costcenter_ID as C64_527_0_ from OBANALY_FACT_SALESORDHEADER obanalyfac0_ where obanalyfac0_.C_Order_ID=$1
2018-09-04 17:30:05 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 DETAIL: parameters: $1 = 'F68F6FAB6501415FA88458FA49E6B40A'
2018-09-04 17:31:05 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 LOG: duration: 60339.651 ms execute S_86046: delete from C_Order where C_Order_ID=$1
2018-09-04 17:31:05 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 DETAIL: parameters: $1 = 'F68F6FAB6501415FA88458FA49E6B40A'
2018-09-04 17:31:11 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 LOG: duration: 6201.586 ms execute S_85969/C_86115: select obanalyfac0_.C_Order_ID as C9_622_1_, obanalyfac0_.Obanaly_Fact_Salesordheader_ID as Obanaly1_1_, obanalyfac0_.Obanaly_Fact_Salesordheader_ID as Obanaly1_527_0_, obanalyfac0_.AD_Client_ID as AD2_527_0_, obanalyfac0_.AD_Org_ID as AD3_527_0_, obanalyfac0_.Isactive as Isactive527_0_, obanalyfac0_.Created as Created527_0_, obanalyfac0_.Createdby as Createdby527_0_, obanalyfac0_.Updated as Updated527_0_, obanalyfac0_.Updatedby as Updatedby527_0_, obanalyfac0_.C_Order_ID as C9_527_0_, obanalyfac0_.C_Bpartner_ID as C10_527_0_, obanalyfac0_.C_Bp_Group_ID as C11_527_0_, obanalyfac0_.C_Bp_Taxcategory_ID as C12_527_0_, obanalyfac0_.C_Location_ID as C13_527_0_, obanalyfac0_.C_Region_ID as C14_527_0_, obanalyfac0_.C_Country_ID as C15_527_0_, obanalyfac0_.M_Warehouse_ID as M16_527_0_, obanalyfac0_.C_Currency_ID as C17_527_0_, obanalyfac0_.C_Doctype_ID as C18_527_0_, obanalyfac0_.C_Doctypetarget_ID as C19_527_0_, obanalyfac0_.Salesrep_ID as Salesrep20_527_0_, obanalyfac0_.Billto_Location_ID as Billto21_527_0_, obanalyfac0_.C_Invoice_Region_ID as C22_527_0_, obanalyfac0_.C_Invoice_Country_ID as C23_527_0_, obanalyfac0_.Delivery_Location_ID as Delivery24_527_0_, obanalyfac0_.Delivery_Region_ID as Delivery25_527_0_, obanalyfac0_.Delivery_Country_ID as Delivery26_527_0_, obanalyfac0_.C_Paymentterm_ID as C27_527_0_, obanalyfac0_.M_Pricelist_ID as M28_527_0_, obanalyfac0_.FIN_Paymentmethod_ID as FIN29_527_0_, obanalyfac0_.C_Return_Reason_ID as C30_527_0_, obanalyfac0_.Documentno as Documentno527_0_, obanalyfac0_.Orderdate as Orderdate527_0_, obanalyfac0_.Dateordered as Dateord33_527_0_, obanalyfac0_.Datepromised as Datepro34_527_0_, obanalyfac0_.Linecount as Linecount527_0_, obanalyfac0_.Quantity as Quantity527_0_, obanalyfac0_.Qtynet as Qtynet527_0_, obanalyfac0_.Qtyreturned as Qtyretu38_527_0_, obanalyfac0_.Amount as Amount527_0_, obanalyfac0_.Amtnet as Amtnet527_0_, obanalyfac0_.Amtreturn as Amtreturn527_0_, obanalyfac0_.Taxamount as Taxamount527_0_, obanalyfac0_.Taxamtnet as Taxamtnet527_0_, obanalyfac0_.Taxamtreturn as Taxamtr44_527_0_, obanalyfac0_.Discamount as Discamount527_0_, obanalyfac0_.Discamtnet as Discamtnet527_0_, obanalyfac0_.Discamtreturn as Discamt47_527_0_, obanalyfac0_.Dirdiscamount as Dirdisc48_527_0_, obanalyfac0_.Dirdiscamtnet as Dirdisc49_527_0_, obanalyfac0_.Dirdiscamtreturn as Dirdisc50_527_0_, obanalyfac0_.Conversiondate as Convers51_527_0_, obanalyfac0_.EM_Obretan_Applications_ID as EM52_527_0_, obanalyfac0_.Weeknum as Weeknum527_0_, obanalyfac0_.EM_Obretan_Terminaltype_ID as EM54_527_0_, obanalyfac0_.Yearnum as Yearnum527_0_, obanalyfac0_.Ordertime as Ordertime527_0_, obanalyfac0_.M_Offer_ID as M57_527_0_, obanalyfac0_.City as City527_0_, obanalyfac0_.Postalcode as Postalcode527_0_, obanalyfac0_.Birthdate as Birthdate527_0_, obanalyfac0_.Hournum as Hournum527_0_, obanalyfac0_.Weekday as Weekday527_0_, obanalyfac0_.Monthnum as Monthnum527_0_, obanalyfac0_.C_Costcenter_ID as C64_527_0_ from OBANALY_FACT_SALESORDHEADER obanalyfac0_ where obanalyfac0_.C_Order_ID=$1
2018-09-04 17:31:11 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 DETAIL: parameters: $1 = '34F256E50E9D4075ADBF364C4D195155'
2018-09-04 17:31:56 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 LOG: duration: 40187.020 ms execute S_86046: delete from C_Order where C_Order_ID=$1
2018-09-04 17:31:56 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 DETAIL: parameters: $1 = '34F256E50E9D4075ADBF364C4D195155'
2018-09-04 17:32:02 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 LOG: duration: 5752.471 ms execute S_85969/C_86130: select obanalyfac0_.C_Order_ID as C9_622_1_, obanalyfac0_.Obanaly_Fact_Salesordheader_ID as Obanaly1_1_, obanalyfac0_.Obanaly_Fact_Salesordheader_ID as Obanaly1_527_0_, obanalyfac0_.AD_Client_ID as AD2_527_0_, obanalyfac0_.AD_Org_ID as AD3_527_0_, obanalyfac0_.Isactive as Isactive527_0_, obanalyfac0_.Created as Created527_0_, obanalyfac0_.Createdby as Createdby527_0_, obanalyfac0_.Updated as Updated527_0_, obanalyfac0_.Updatedby as Updatedby527_0_, obanalyfac0_.C_Order_ID as C9_527_0_, obanalyfac0_.C_Bpartner_ID as C10_527_0_, obanalyfac0_.C_Bp_Group_ID as C11_527_0_, obanalyfac0_.C_Bp_Taxcategory_ID as C12_527_0_, obanalyfac0_.C_Location_ID as C13_527_0_, obanalyfac0_.C_Region_ID as C14_527_0_, obanalyfac0_.C_Country_ID as C15_527_0_, obanalyfac0_.M_Warehouse_ID as M16_527_0_, obanalyfac0_.C_Currency_ID as C17_527_0_, obanalyfac0_.C_Doctype_ID as C18_527_0_, obanalyfac0_.C_Doctypetarget_ID as C19_527_0_, obanalyfac0_.Salesrep_ID as Salesrep20_527_0_, obanalyfac0_.Billto_Location_ID as Billto21_527_0_, obanalyfac0_.C_Invoice_Region_ID as C22_527_0_, obanalyfac0_.C_Invoice_Country_ID as C23_527_0_, obanalyfac0_.Delivery_Location_ID as Delivery24_527_0_, obanalyfac0_.Delivery_Region_ID as Delivery25_527_0_, obanalyfac0_.Delivery_Country_ID as Delivery26_527_0_, obanalyfac0_.C_Paymentterm_ID as C27_527_0_, obanalyfac0_.M_Pricelist_ID as M28_527_0_, obanalyfac0_.FIN_Paymentmethod_ID as FIN29_527_0_, obanalyfac0_.C_Return_Reason_ID as C30_527_0_, obanalyfac0_.Documentno as Documentno527_0_, obanalyfac0_.Orderdate as Orderdate527_0_, obanalyfac0_.Dateordered as Dateord33_527_0_, obanalyfac0_.Datepromised as Datepro34_527_0_, obanalyfac0_.Linecount as Linecount527_0_, obanalyfac0_.Quantity as Quantity527_0_, obanalyfac0_.Qtynet as Qtynet527_0_, obanalyfac0_.Qtyreturned as Qtyretu38_527_0_, obanalyfac0_.Amount as Amount527_0_, obanalyfac0_.Amtnet as Amtnet527_0_, obanalyfac0_.Amtreturn as Amtreturn527_0_, obanalyfac0_.Taxamount as Taxamount527_0_, obanalyfac0_.Taxamtnet as Taxamtnet527_0_, obanalyfac0_.Taxamtreturn as Taxamtr44_527_0_, obanalyfac0_.Discamount as Discamount527_0_, obanalyfac0_.Discamtnet as Discamtnet527_0_, obanalyfac0_.Discamtreturn as Discamt47_527_0_, obanalyfac0_.Dirdiscamount as Dirdisc48_527_0_, obanalyfac0_.Dirdiscamtnet as Dirdisc49_527_0_, obanalyfac0_.Dirdiscamtreturn as Dirdisc50_527_0_, obanalyfac0_.Conversiondate as Convers51_527_0_, obanalyfac0_.EM_Obretan_Applications_ID as EM52_527_0_, obanalyfac0_.Weeknum as Weeknum527_0_, obanalyfac0_.EM_Obretan_Terminaltype_ID as EM54_527_0_, obanalyfac0_.Yearnum as Yearnum527_0_, obanalyfac0_.Ordertime as Ordertime527_0_, obanalyfac0_.M_Offer_ID as M57_527_0_, obanalyfac0_.City as City527_0_, obanalyfac0_.Postalcode as Postalcode527_0_, obanalyfac0_.Birthdate as Birthdate527_0_, obanalyfac0_.Hournum as Hournum527_0_, obanalyfac0_.Weekday as Weekday527_0_, obanalyfac0_.Monthnum as Monthnum527_0_, obanalyfac0_.C_Costcenter_ID as C64_527_0_ from OBANALY_FACT_SALESORDHEADER obanalyfac0_ where obanalyfac0_.C_Order_ID=$1
2018-09-04 17:32:02 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 DETAIL: parameters: $1 = '34C4B398F29E4F11817ED5FE05D68E16'
2018-09-04 17:32:38 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 LOG: duration: 35089.776 ms execute S_86046: delete from C_Order where C_Order_ID=$1
2018-09-04 17:32:38 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 DETAIL: parameters: $1 = '34C4B398F29E4F11817ED5FE05D68E16'
2018-09-04 17:32:44 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 LOG: duration: 6126.596 ms execute S_85969/C_86158: select obanalyfac0_.C_Order_ID as C9_622_1_, obanalyfac0_.Obanaly_Fact_Salesordheader_ID as Obanaly1_1_, obanalyfac0_.Obanaly_Fact_Salesordheader_ID as Obanaly1_527_0_, obanalyfac0_.AD_Client_ID as AD2_527_0_, obanalyfac0_.AD_Org_ID as AD3_527_0_, obanalyfac0_.Isactive as Isactive527_0_, obanalyfac0_.Created as Created527_0_, obanalyfac0_.Createdby as Createdby527_0_, obanalyfac0_.Updated as Updated527_0_, obanalyfac0_.Updatedby as Updatedby527_0_, obanalyfac0_.C_Order_ID as C9_527_0_, obanalyfac0_.C_Bpartner_ID as C10_527_0_, obanalyfac0_.C_Bp_Group_ID as C11_527_0_, obanalyfac0_.C_Bp_Taxcategory_ID as C12_527_0_, obanalyfac0_.C_Location_ID as C13_527_0_, obanalyfac0_.C_Region_ID as C14_527_0_, obanalyfac0_.C_Country_ID as C15_527_0_, obanalyfac0_.M_Warehouse_ID as M16_527_0_, obanalyfac0_.C_Currency_ID as C17_527_0_, obanalyfac0_.C_Doctype_ID as C18_527_0_, obanalyfac0_.C_Doctypetarget_ID as C19_527_0_, obanalyfac0_.Salesrep_ID as Salesrep20_527_0_, obanalyfac0_.Billto_Location_ID as Billto21_527_0_, obanalyfac0_.C_Invoice_Region_ID as C22_527_0_, obanalyfac0_.C_Invoice_Country_ID as C23_527_0_, obanalyfac0_.Delivery_Location_ID as Delivery24_527_0_, obanalyfac0_.Delivery_Region_ID as Delivery25_527_0_, obanalyfac0_.Delivery_Country_ID as Delivery26_527_0_, obanalyfac0_.C_Paymentterm_ID as C27_527_0_, obanalyfac0_.M_Pricelist_ID as M28_527_0_, obanalyfac0_.FIN_Paymentmethod_ID as FIN29_527_0_, obanalyfac0_.C_Return_Reason_ID as C30_527_0_, obanalyfac0_.Documentno as Documentno527_0_, obanalyfac0_.Orderdate as Orderdate527_0_, obanalyfac0_.Dateordered as Dateord33_527_0_, obanalyfac0_.Datepromised as Datepro34_527_0_, obanalyfac0_.Linecount as Linecount527_0_, obanalyfac0_.Quantity as Quantity527_0_, obanalyfac0_.Qtynet as Qtynet527_0_, obanalyfac0_.Qtyreturned as Qtyretu38_527_0_, obanalyfac0_.Amount as Amount527_0_, obanalyfac0_.Amtnet as Amtnet527_0_, obanalyfac0_.Amtreturn as Amtreturn527_0_, obanalyfac0_.Taxamount as Taxamount527_0_, obanalyfac0_.Taxamtnet as Taxamtnet527_0_, obanalyfac0_.Taxamtreturn as Taxamtr44_527_0_, obanalyfac0_.Discamount as Discamount527_0_, obanalyfac0_.Discamtnet as Discamtnet527_0_, obanalyfac0_.Discamtreturn as Discamt47_527_0_, obanalyfac0_.Dirdiscamount as Dirdisc48_527_0_, obanalyfac0_.Dirdiscamtnet as Dirdisc49_527_0_, obanalyfac0_.Dirdiscamtreturn as Dirdisc50_527_0_, obanalyfac0_.Conversiondate as Convers51_527_0_, obanalyfac0_.EM_Obretan_Applications_ID as EM52_527_0_, obanalyfac0_.Weeknum as Weeknum527_0_, obanalyfac0_.EM_Obretan_Terminaltype_ID as EM54_527_0_, obanalyfac0_.Yearnum as Yearnum527_0_, obanalyfac0_.Ordertime as Ordertime527_0_, obanalyfac0_.M_Offer_ID as M57_527_0_, obanalyfac0_.City as City527_0_, obanalyfac0_.Postalcode as Postalcode527_0_, obanalyfac0_.Birthdate as Birthdate527_0_, obanalyfac0_.Hournum as Hournum527_0_, obanalyfac0_.Weekday as Weekday527_0_, obanalyfac0_.Monthnum as Monthnum527_0_, obanalyfac0_.C_Costcenter_ID as C64_527_0_ from OBANALY_FACT_SALESORDHEADER obanalyfac0_ where obanalyfac0_.C_Order_ID=$1
2018-09-04 17:32:44 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 DETAIL: parameters: $1 = '01628AE091ED4EEFA3DA466EB4E663B8'
2018-09-04 17:33:22 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 LOG: duration: 38336.794 ms execute S_86046: delete from C_Order where C_Order_ID=$1
2018-09-04 17:33:22 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 DETAIL: parameters: $1 = '01628AE091ED4EEFA3DA466EB4E663B8'
2018-09-04 17:33:28 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 LOG: duration: 6013.408 ms execute S_85969/C_86182: select obanalyfac0_.C_Order_ID as C9_622_1_, obanalyfac0_.Obanaly_Fact_Salesordheader_ID as Obanaly1_1_, obanalyfac0_.Obanaly_Fact_Salesordheader_ID as Obanaly1_527_0_, obanalyfac0_.AD_Client_ID as AD2_527_0_, obanalyfac0_.AD_Org_ID as AD3_527_0_, obanalyfac0_.Isactive as Isactive527_0_, obanalyfac0_.Created as Created527_0_, obanalyfac0_.Createdby as Createdby527_0_, obanalyfac0_.Updated as Updated527_0_, obanalyfac0_.Updatedby as Updatedby527_0_, obanalyfac0_.C_Order_ID as C9_527_0_, obanalyfac0_.C_Bpartner_ID as C10_527_0_, obanalyfac0_.C_Bp_Group_ID as C11_527_0_, obanalyfac0_.C_Bp_Taxcategory_ID as C12_527_0_, obanalyfac0_.C_Location_ID as C13_527_0_, obanalyfac0_.C_Region_ID as C14_527_0_, obanalyfac0_.C_Country_ID as C15_527_0_, obanalyfac0_.M_Warehouse_ID as M16_527_0_, obanalyfac0_.C_Currency_ID as C17_527_0_, obanalyfac0_.C_Doctype_ID as C18_527_0_, obanalyfac0_.C_Doctypetarget_ID as C19_527_0_, obanalyfac0_.Salesrep_ID as Salesrep20_527_0_, obanalyfac0_.Billto_Location_ID as Billto21_527_0_, obanalyfac0_.C_Invoice_Region_ID as C22_527_0_, obanalyfac0_.C_Invoice_Country_ID as C23_527_0_, obanalyfac0_.Delivery_Location_ID as Delivery24_527_0_, obanalyfac0_.Delivery_Region_ID as Delivery25_527_0_, obanalyfac0_.Delivery_Country_ID as Delivery26_527_0_, obanalyfac0_.C_Paymentterm_ID as C27_527_0_, obanalyfac0_.M_Pricelist_ID as M28_527_0_, obanalyfac0_.FIN_Paymentmethod_ID as FIN29_527_0_, obanalyfac0_.C_Return_Reason_ID as C30_527_0_, obanalyfac0_.Documentno as Documentno527_0_, obanalyfac0_.Orderdate as Orderdate527_0_, obanalyfac0_.Dateordered as Dateord33_527_0_, obanalyfac0_.Datepromised as Datepro34_527_0_, obanalyfac0_.Linecount as Linecount527_0_, obanalyfac0_.Quantity as Quantity527_0_, obanalyfac0_.Qtynet as Qtynet527_0_, obanalyfac0_.Qtyreturned as Qtyretu38_527_0_, obanalyfac0_.Amount as Amount527_0_, obanalyfac0_.Amtnet as Amtnet527_0_, obanalyfac0_.Amtreturn as Amtreturn527_0_, obanalyfac0_.Taxamount as Taxamount527_0_, obanalyfac0_.Taxamtnet as Taxamtnet527_0_, obanalyfac0_.Taxamtreturn as Taxamtr44_527_0_, obanalyfac0_.Discamount as Discamount527_0_, obanalyfac0_.Discamtnet as Discamtnet527_0_, obanalyfac0_.Discamtreturn as Discamt47_527_0_, obanalyfac0_.Dirdiscamount as Dirdisc48_527_0_, obanalyfac0_.Dirdiscamtnet as Dirdisc49_527_0_, obanalyfac0_.Dirdiscamtreturn as Dirdisc50_527_0_, obanalyfac0_.Conversiondate as Convers51_527_0_, obanalyfac0_.EM_Obretan_Applications_ID as EM52_527_0_, obanalyfac0_.Weeknum as Weeknum527_0_, obanalyfac0_.EM_Obretan_Terminaltype_ID as EM54_527_0_, obanalyfac0_.Yearnum as Yearnum527_0_, obanalyfac0_.Ordertime as Ordertime527_0_, obanalyfac0_.M_Offer_ID as M57_527_0_, obanalyfac0_.City as City527_0_, obanalyfac0_.Postalcode as Postalcode527_0_, obanalyfac0_.Birthdate as Birthdate527_0_, obanalyfac0_.Hournum as Hournum527_0_, obanalyfac0_.Weekday as Weekday527_0_, obanalyfac0_.Monthnum as Monthnum527_0_, obanalyfac0_.C_Costcenter_ID as C64_527_0_ from OBANALY_FACT_SALESORDHEADER obanalyfac0_ where obanalyfac0_.C_Order_ID=$1
2018-09-04 17:33:28 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 DETAIL: parameters: $1 = '6B9426F4370C422BAAC2FF41AD435104'
2018-09-04 17:34:02 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 LOG: duration: 33378.640 ms execute S_86046: delete from C_Order where C_Order_ID=$1
2018-09-04 17:34:02 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 DETAIL: parameters: $1 = '6B9426F4370C422BAAC2FF41AD435104'
2018-09-04 17:34:07 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 LOG: duration: 4919.408 ms execute S_85969/C_86190: select obanalyfac0_.C_Order_ID as C9_622_1_, obanalyfac0_.Obanaly_Fact_Salesordheader_ID as Obanaly1_1_, obanalyfac0_.Obanaly_Fact_Salesordheader_ID as Obanaly1_527_0_, obanalyfac0_.AD_Client_ID as AD2_527_0_, obanalyfac0_.AD_Org_ID as AD3_527_0_, obanalyfac0_.Isactive as Isactive527_0_, obanalyfac0_.Created as Created527_0_, obanalyfac0_.Createdby as Createdby527_0_, obanalyfac0_.Updated as Updated527_0_, obanalyfac0_.Updatedby as Updatedby527_0_, obanalyfac0_.C_Order_ID as C9_527_0_, obanalyfac0_.C_Bpartner_ID as C10_527_0_, obanalyfac0_.C_Bp_Group_ID as C11_527_0_, obanalyfac0_.C_Bp_Taxcategory_ID as C12_527_0_, obanalyfac0_.C_Location_ID as C13_527_0_, obanalyfac0_.C_Region_ID as C14_527_0_, obanalyfac0_.C_Country_ID as C15_527_0_, obanalyfac0_.M_Warehouse_ID as M16_527_0_, obanalyfac0_.C_Currency_ID as C17_527_0_, obanalyfac0_.C_Doctype_ID as C18_527_0_, obanalyfac0_.C_Doctypetarget_ID as C19_527_0_, obanalyfac0_.Salesrep_ID as Salesrep20_527_0_, obanalyfac0_.Billto_Location_ID as Billto21_527_0_, obanalyfac0_.C_Invoice_Region_ID as C22_527_0_, obanalyfac0_.C_Invoice_Country_ID as C23_527_0_, obanalyfac0_.Delivery_Location_ID as Delivery24_527_0_, obanalyfac0_.Delivery_Region_ID as Delivery25_527_0_, obanalyfac0_.Delivery_Country_ID as Delivery26_527_0_, obanalyfac0_.C_Paymentterm_ID as C27_527_0_, obanalyfac0_.M_Pricelist_ID as M28_527_0_, obanalyfac0_.FIN_Paymentmethod_ID as FIN29_527_0_, obanalyfac0_.C_Return_Reason_ID as C30_527_0_, obanalyfac0_.Documentno as Documentno527_0_, obanalyfac0_.Orderdate as Orderdate527_0_, obanalyfac0_.Dateordered as Dateord33_527_0_, obanalyfac0_.Datepromised as Datepro34_527_0_, obanalyfac0_.Linecount as Linecount527_0_, obanalyfac0_.Quantity as Quantity527_0_, obanalyfac0_.Qtynet as Qtynet527_0_, obanalyfac0_.Qtyreturned as Qtyretu38_527_0_, obanalyfac0_.Amount as Amount527_0_, obanalyfac0_.Amtnet as Amtnet527_0_, obanalyfac0_.Amtreturn as Amtreturn527_0_, obanalyfac0_.Taxamount as Taxamount527_0_, obanalyfac0_.Taxamtnet as Taxamtnet527_0_, obanalyfac0_.Taxamtreturn as Taxamtr44_527_0_, obanalyfac0_.Discamount as Discamount527_0_, obanalyfac0_.Discamtnet as Discamtnet527_0_, obanalyfac0_.Discamtreturn as Discamt47_527_0_, obanalyfac0_.Dirdiscamount as Dirdisc48_527_0_, obanalyfac0_.Dirdiscamtnet as Dirdisc49_527_0_, obanalyfac0_.Dirdiscamtreturn as Dirdisc50_527_0_, obanalyfac0_.Conversiondate as Convers51_527_0_, obanalyfac0_.EM_Obretan_Applications_ID as EM52_527_0_, obanalyfac0_.Weeknum as Weeknum527_0_, obanalyfac0_.EM_Obretan_Terminaltype_ID as EM54_527_0_, obanalyfac0_.Yearnum as Yearnum527_0_, obanalyfac0_.Ordertime as Ordertime527_0_, obanalyfac0_.M_Offer_ID as M57_527_0_, obanalyfac0_.City as City527_0_, obanalyfac0_.Postalcode as Postalcode527_0_, obanalyfac0_.Birthdate as Birthdate527_0_, obanalyfac0_.Hournum as Hournum527_0_, obanalyfac0_.Weekday as Weekday527_0_, obanalyfac0_.Monthnum as Monthnum527_0_, obanalyfac0_.C_Costcenter_ID as C64_527_0_ from OBANALY_FACT_SALESORDHEADER obanalyfac0_ where obanalyfac0_.C_Order_ID=$1
2018-09-04 17:34:07 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 DETAIL: parameters: $1 = 'C5D43E181E0A46F594EA5592935E9688'
2018-09-04 17:34:42 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 LOG: duration: 35097.376 ms execute S_86046: delete from C_Order where C_Order_ID=$1
2018-09-04 17:34:42 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 DETAIL: parameters: $1 = 'C5D43E181E0A46F594EA5592935E9688'
2018-09-04 17:34:48 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 LOG: duration: 5234.743 ms execute S_85969/C_86213: select obanalyfac0_.C_Order_ID as C9_622_1_, obanalyfac0_.Obanaly_Fact_Salesordheader_ID as Obanaly1_1_, obanalyfac0_.Obanaly_Fact_Salesordheader_ID as Obanaly1_527_0_, obanalyfac0_.AD_Client_ID as AD2_527_0_, obanalyfac0_.AD_Org_ID as AD3_527_0_, obanalyfac0_.Isactive as Isactive527_0_, obanalyfac0_.Created as Created527_0_, obanalyfac0_.Createdby as Createdby527_0_, obanalyfac0_.Updated as Updated527_0_, obanalyfac0_.Updatedby as Updatedby527_0_, obanalyfac0_.C_Order_ID as C9_527_0_, obanalyfac0_.C_Bpartner_ID as C10_527_0_, obanalyfac0_.C_Bp_Group_ID as C11_527_0_, obanalyfac0_.C_Bp_Taxcategory_ID as C12_527_0_, obanalyfac0_.C_Location_ID as C13_527_0_, obanalyfac0_.C_Region_ID as C14_527_0_, obanalyfac0_.C_Country_ID as C15_527_0_, obanalyfac0_.M_Warehouse_ID as M16_527_0_, obanalyfac0_.C_Currency_ID as C17_527_0_, obanalyfac0_.C_Doctype_ID as C18_527_0_, obanalyfac0_.C_Doctypetarget_ID as C19_527_0_, obanalyfac0_.Salesrep_ID as Salesrep20_527_0_, obanalyfac0_.Billto_Location_ID as Billto21_527_0_, obanalyfac0_.C_Invoice_Region_ID as C22_527_0_, obanalyfac0_.C_Invoice_Country_ID as C23_527_0_, obanalyfac0_.Delivery_Location_ID as Delivery24_527_0_, obanalyfac0_.Delivery_Region_ID as Delivery25_527_0_, obanalyfac0_.Delivery_Country_ID as Delivery26_527_0_, obanalyfac0_.C_Paymentterm_ID as C27_527_0_, obanalyfac0_.M_Pricelist_ID as M28_527_0_, obanalyfac0_.FIN_Paymentmethod_ID as FIN29_527_0_, obanalyfac0_.C_Return_Reason_ID as C30_527_0_, obanalyfac0_.Documentno as Documentno527_0_, obanalyfac0_.Orderdate as Orderdate527_0_, obanalyfac0_.Dateordered as Dateord33_527_0_, obanalyfac0_.Datepromised as Datepro34_527_0_, obanalyfac0_.Linecount as Linecount527_0_, obanalyfac0_.Quantity as Quantity527_0_, obanalyfac0_.Qtynet as Qtynet527_0_, obanalyfac0_.Qtyreturned as Qtyretu38_527_0_, obanalyfac0_.Amount as Amount527_0_, obanalyfac0_.Amtnet as Amtnet527_0_, obanalyfac0_.Amtreturn as Amtreturn527_0_, obanalyfac0_.Taxamount as Taxamount527_0_, obanalyfac0_.Taxamtnet as Taxamtnet527_0_, obanalyfac0_.Taxamtreturn as Taxamtr44_527_0_, obanalyfac0_.Discamount as Discamount527_0_, obanalyfac0_.Discamtnet as Discamtnet527_0_, obanalyfac0_.Discamtreturn as Discamt47_527_0_, obanalyfac0_.Dirdiscamount as Dirdisc48_527_0_, obanalyfac0_.Dirdiscamtnet as Dirdisc49_527_0_, obanalyfac0_.Dirdiscamtreturn as Dirdisc50_527_0_, obanalyfac0_.Conversiondate as Convers51_527_0_, obanalyfac0_.EM_Obretan_Applications_ID as EM52_527_0_, obanalyfac0_.Weeknum as Weeknum527_0_, obanalyfac0_.EM_Obretan_Terminaltype_ID as EM54_527_0_, obanalyfac0_.Yearnum as Yearnum527_0_, obanalyfac0_.Ordertime as Ordertime527_0_, obanalyfac0_.M_Offer_ID as M57_527_0_, obanalyfac0_.City as City527_0_, obanalyfac0_.Postalcode as Postalcode527_0_, obanalyfac0_.Birthdate as Birthdate527_0_, obanalyfac0_.Hournum as Hournum527_0_, obanalyfac0_.Weekday as Weekday527_0_, obanalyfac0_.Monthnum as Monthnum527_0_, obanalyfac0_.C_Costcenter_ID as C64_527_0_ from OBANALY_FACT_SALESORDHEADER obanalyfac0_ where obanalyfac0_.C_Order_ID=$1
2018-09-04 17:34:48 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 DETAIL: parameters: $1 = '4C5EC9AF9EE74AA4B74740AD6E5888F7'
2018-09-04 17:35:29 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 LOG: duration: 41475.964 ms execute S_86046: delete from C_Order where C_Order_ID=$1
2018-09-04 17:35:29 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 DETAIL: parameters: $1 = '4C5EC9AF9EE74AA4B74740AD6E5888F7'
2018-09-04 17:35:36 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 LOG: duration: 7152.132 ms execute S_85969/C_86221: select obanalyfac0_.C_Order_ID as C9_622_1_, obanalyfac0_.Obanaly_Fact_Salesordheader_ID as Obanaly1_1_, obanalyfac0_.Obanaly_Fact_Salesordheader_ID as Obanaly1_527_0_, obanalyfac0_.AD_Client_ID as AD2_527_0_, obanalyfac0_.AD_Org_ID as AD3_527_0_, obanalyfac0_.Isactive as Isactive527_0_, obanalyfac0_.Created as Created527_0_, obanalyfac0_.Createdby as Createdby527_0_, obanalyfac0_.Updated as Updated527_0_, obanalyfac0_.Updatedby as Updatedby527_0_, obanalyfac0_.C_Order_ID as C9_527_0_, obanalyfac0_.C_Bpartner_ID as C10_527_0_, obanalyfac0_.C_Bp_Group_ID as C11_527_0_, obanalyfac0_.C_Bp_Taxcategory_ID as C12_527_0_, obanalyfac0_.C_Location_ID as C13_527_0_, obanalyfac0_.C_Region_ID as C14_527_0_, obanalyfac0_.C_Country_ID as C15_527_0_, obanalyfac0_.M_Warehouse_ID as M16_527_0_, obanalyfac0_.C_Currency_ID as C17_527_0_, obanalyfac0_.C_Doctype_ID as C18_527_0_, obanalyfac0_.C_Doctypetarget_ID as C19_527_0_, obanalyfac0_.Salesrep_ID as Salesrep20_527_0_, obanalyfac0_.Billto_Location_ID as Billto21_527_0_, obanalyfac0_.C_Invoice_Region_ID as C22_527_0_, obanalyfac0_.C_Invoice_Country_ID as C23_527_0_, obanalyfac0_.Delivery_Location_ID as Delivery24_527_0_, obanalyfac0_.Delivery_Region_ID as Delivery25_527_0_, obanalyfac0_.Delivery_Country_ID as Delivery26_527_0_, obanalyfac0_.C_Paymentterm_ID as C27_527_0_, obanalyfac0_.M_Pricelist_ID as M28_527_0_, obanalyfac0_.FIN_Paymentmethod_ID as FIN29_527_0_, obanalyfac0_.C_Return_Reason_ID as C30_527_0_, obanalyfac0_.Documentno as Documentno527_0_, obanalyfac0_.Orderdate as Orderdate527_0_, obanalyfac0_.Dateordered as Dateord33_527_0_, obanalyfac0_.Datepromised as Datepro34_527_0_, obanalyfac0_.Linecount as Linecount527_0_, obanalyfac0_.Quantity as Quantity527_0_, obanalyfac0_.Qtynet as Qtynet527_0_, obanalyfac0_.Qtyreturned as Qtyretu38_527_0_, obanalyfac0_.Amount as Amount527_0_, obanalyfac0_.Amtnet as Amtnet527_0_, obanalyfac0_.Amtreturn as Amtreturn527_0_, obanalyfac0_.Taxamount as Taxamount527_0_, obanalyfac0_.Taxamtnet as Taxamtnet527_0_, obanalyfac0_.Taxamtreturn as Taxamtr44_527_0_, obanalyfac0_.Discamount as Discamount527_0_, obanalyfac0_.Discamtnet as Discamtnet527_0_, obanalyfac0_.Discamtreturn as Discamt47_527_0_, obanalyfac0_.Dirdiscamount as Dirdisc48_527_0_, obanalyfac0_.Dirdiscamtnet as Dirdisc49_527_0_, obanalyfac0_.Dirdiscamtreturn as Dirdisc50_527_0_, obanalyfac0_.Conversiondate as Convers51_527_0_, obanalyfac0_.EM_Obretan_Applications_ID as EM52_527_0_, obanalyfac0_.Weeknum as Weeknum527_0_, obanalyfac0_.EM_Obretan_Terminaltype_ID as EM54_527_0_, obanalyfac0_.Yearnum as Yearnum527_0_, obanalyfac0_.Ordertime as Ordertime527_0_, obanalyfac0_.M_Offer_ID as M57_527_0_, obanalyfac0_.City as City527_0_, obanalyfac0_.Postalcode as Postalcode527_0_, obanalyfac0_.Birthdate as Birthdate527_0_, obanalyfac0_.Hournum as Hournum527_0_, obanalyfac0_.Weekday as Weekday527_0_, obanalyfac0_.Monthnum as Monthnum527_0_, obanalyfac0_.C_Costcenter_ID as C64_527_0_ from OBANALY_FACT_SALESORDHEADER obanalyfac0_ where obanalyfac0_.C_Order_ID=$1
2018-09-04 17:35:36 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 DETAIL: parameters: $1 = '23989E5A9C2D428FB1D620686E8EFC49'
2018-09-04 17:36:11 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 LOG: duration: 34588.749 ms execute S_86046: delete from C_Order where C_Order_ID=$1
2018-09-04 17:36:11 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 DETAIL: parameters: $1 = '23989E5A9C2D428FB1D620686E8EFC49'
2018-09-04 17:36:15 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 LOG: duration: 4253.954 ms execute S_85969/C_86229: select obanalyfac0_.C_Order_ID as C9_622_1_, obanalyfac0_.Obanaly_Fact_Salesordheader_ID as Obanaly1_1_, obanalyfac0_.Obanaly_Fact_Salesordheader_ID as Obanaly1_527_0_, obanalyfac0_.AD_Client_ID as AD2_527_0_, obanalyfac0_.AD_Org_ID as AD3_527_0_, obanalyfac0_.Isactive as Isactive527_0_, obanalyfac0_.Created as Created527_0_, obanalyfac0_.Createdby as Createdby527_0_, obanalyfac0_.Updated as Updated527_0_, obanalyfac0_.Updatedby as Updatedby527_0_, obanalyfac0_.C_Order_ID as C9_527_0_, obanalyfac0_.C_Bpartner_ID as C10_527_0_, obanalyfac0_.C_Bp_Group_ID as C11_527_0_, obanalyfac0_.C_Bp_Taxcategory_ID as C12_527_0_, obanalyfac0_.C_Location_ID as C13_527_0_, obanalyfac0_.C_Region_ID as C14_527_0_, obanalyfac0_.C_Country_ID as C15_527_0_, obanalyfac0_.M_Warehouse_ID as M16_527_0_, obanalyfac0_.C_Currency_ID as C17_527_0_, obanalyfac0_.C_Doctype_ID as C18_527_0_, obanalyfac0_.C_Doctypetarget_ID as C19_527_0_, obanalyfac0_.Salesrep_ID as Salesrep20_527_0_, obanalyfac0_.Billto_Location_ID as Billto21_527_0_, obanalyfac0_.C_Invoice_Region_ID as C22_527_0_, obanalyfac0_.C_Invoice_Country_ID as C23_527_0_, obanalyfac0_.Delivery_Location_ID as Delivery24_527_0_, obanalyfac0_.Delivery_Region_ID as Delivery25_527_0_, obanalyfac0_.Delivery_Country_ID as Delivery26_527_0_, obanalyfac0_.C_Paymentterm_ID as C27_527_0_, obanalyfac0_.M_Pricelist_ID as M28_527_0_, obanalyfac0_.FIN_Paymentmethod_ID as FIN29_527_0_, obanalyfac0_.C_Return_Reason_ID as C30_527_0_, obanalyfac0_.Documentno as Documentno527_0_, obanalyfac0_.Orderdate as Orderdate527_0_, obanalyfac0_.Dateordered as Dateord33_527_0_, obanalyfac0_.Datepromised as Datepro34_527_0_, obanalyfac0_.Linecount as Linecount527_0_, obanalyfac0_.Quantity as Quantity527_0_, obanalyfac0_.Qtynet as Qtynet527_0_, obanalyfac0_.Qtyreturned as Qtyretu38_527_0_, obanalyfac0_.Amount as Amount527_0_, obanalyfac0_.Amtnet as Amtnet527_0_, obanalyfac0_.Amtreturn as Amtreturn527_0_, obanalyfac0_.Taxamount as Taxamount527_0_, obanalyfac0_.Taxamtnet as Taxamtnet527_0_, obanalyfac0_.Taxamtreturn as Taxamtr44_527_0_, obanalyfac0_.Discamount as Discamount527_0_, obanalyfac0_.Discamtnet as Discamtnet527_0_, obanalyfac0_.Discamtreturn as Discamt47_527_0_, obanalyfac0_.Dirdiscamount as Dirdisc48_527_0_, obanalyfac0_.Dirdiscamtnet as Dirdisc49_527_0_, obanalyfac0_.Dirdiscamtreturn as Dirdisc50_527_0_, obanalyfac0_.Conversiondate as Convers51_527_0_, obanalyfac0_.EM_Obretan_Applications_ID as EM52_527_0_, obanalyfac0_.Weeknum as Weeknum527_0_, obanalyfac0_.EM_Obretan_Terminaltype_ID as EM54_527_0_, obanalyfac0_.Yearnum as Yearnum527_0_, obanalyfac0_.Ordertime as Ordertime527_0_, obanalyfac0_.M_Offer_ID as M57_527_0_, obanalyfac0_.City as City527_0_, obanalyfac0_.Postalcode as Postalcode527_0_, obanalyfac0_.Birthdate as Birthdate527_0_, obanalyfac0_.Hournum as Hournum527_0_, obanalyfac0_.Weekday as Weekday527_0_, obanalyfac0_.Monthnum as Monthnum527_0_, obanalyfac0_.C_Costcenter_ID as C64_527_0_ from OBANALY_FACT_SALESORDHEADER obanalyfac0_ where obanalyfac0_.C_Order_ID=$1
2018-09-04 17:36:15 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 DETAIL: parameters: $1 = '12D12E3E21F641F98E1A0F9CB08CE3C3'
2018-09-04 17:36:52 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 LOG: duration: 35991.385 ms execute S_86046: delete from C_Order where C_Order_ID=$1
2018-09-04 17:36:52 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 DETAIL: parameters: $1 = '12D12E3E21F641F98E1A0F9CB08CE3C3'
2018-09-04 17:36:57 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 LOG: duration: 5213.532 ms execute S_85969/C_86244: select obanalyfac0_.C_Order_ID as C9_622_1_, obanalyfac0_.Obanaly_Fact_Salesordheader_ID as Obanaly1_1_, obanalyfac0_.Obanaly_Fact_Salesordheader_ID as Obanaly1_527_0_, obanalyfac0_.AD_Client_ID as AD2_527_0_, obanalyfac0_.AD_Org_ID as AD3_527_0_, obanalyfac0_.Isactive as Isactive527_0_, obanalyfac0_.Created as Created527_0_, obanalyfac0_.Createdby as Createdby527_0_, obanalyfac0_.Updated as Updated527_0_, obanalyfac0_.Updatedby as Updatedby527_0_, obanalyfac0_.C_Order_ID as C9_527_0_, obanalyfac0_.C_Bpartner_ID as C10_527_0_, obanalyfac0_.C_Bp_Group_ID as C11_527_0_, obanalyfac0_.C_Bp_Taxcategory_ID as C12_527_0_, obanalyfac0_.C_Location_ID as C13_527_0_, obanalyfac0_.C_Region_ID as C14_527_0_, obanalyfac0_.C_Country_ID as C15_527_0_, obanalyfac0_.M_Warehouse_ID as M16_527_0_, obanalyfac0_.C_Currency_ID as C17_527_0_, obanalyfac0_.C_Doctype_ID as C18_527_0_, obanalyfac0_.C_Doctypetarget_ID as C19_527_0_, obanalyfac0_.Salesrep_ID as Salesrep20_527_0_, obanalyfac0_.Billto_Location_ID as Billto21_527_0_, obanalyfac0_.C_Invoice_Region_ID as C22_527_0_, obanalyfac0_.C_Invoice_Country_ID as C23_527_0_, obanalyfac0_.Delivery_Location_ID as Delivery24_527_0_, obanalyfac0_.Delivery_Region_ID as Delivery25_527_0_, obanalyfac0_.Delivery_Country_ID as Delivery26_527_0_, obanalyfac0_.C_Paymentterm_ID as C27_527_0_, obanalyfac0_.M_Pricelist_ID as M28_527_0_, obanalyfac0_.FIN_Paymentmethod_ID as FIN29_527_0_, obanalyfac0_.C_Return_Reason_ID as C30_527_0_, obanalyfac0_.Documentno as Documentno527_0_, obanalyfac0_.Orderdate as Orderdate527_0_, obanalyfac0_.Dateordered as Dateord33_527_0_, obanalyfac0_.Datepromised as Datepro34_527_0_, obanalyfac0_.Linecount as Linecount527_0_, obanalyfac0_.Quantity as Quantity527_0_, obanalyfac0_.Qtynet as Qtynet527_0_, obanalyfac0_.Qtyreturned as Qtyretu38_527_0_, obanalyfac0_.Amount as Amount527_0_, obanalyfac0_.Amtnet as Amtnet527_0_, obanalyfac0_.Amtreturn as Amtreturn527_0_, obanalyfac0_.Taxamount as Taxamount527_0_, obanalyfac0_.Taxamtnet as Taxamtnet527_0_, obanalyfac0_.Taxamtreturn as Taxamtr44_527_0_, obanalyfac0_.Discamount as Discamount527_0_, obanalyfac0_.Discamtnet as Discamtnet527_0_, obanalyfac0_.Discamtreturn as Discamt47_527_0_, obanalyfac0_.Dirdiscamount as Dirdisc48_527_0_, obanalyfac0_.Dirdiscamtnet as Dirdisc49_527_0_, obanalyfac0_.Dirdiscamtreturn as Dirdisc50_527_0_, obanalyfac0_.Conversiondate as Convers51_527_0_, obanalyfac0_.EM_Obretan_Applications_ID as EM52_527_0_, obanalyfac0_.Weeknum as Weeknum527_0_, obanalyfac0_.EM_Obretan_Terminaltype_ID as EM54_527_0_, obanalyfac0_.Yearnum as Yearnum527_0_, obanalyfac0_.Ordertime as Ordertime527_0_, obanalyfac0_.M_Offer_ID as M57_527_0_, obanalyfac0_.City as City527_0_, obanalyfac0_.Postalcode as Postalcode527_0_, obanalyfac0_.Birthdate as Birthdate527_0_, obanalyfac0_.Hournum as Hournum527_0_, obanalyfac0_.Weekday as Weekday527_0_, obanalyfac0_.Monthnum as Monthnum527_0_, obanalyfac0_.C_Costcenter_ID as C64_527_0_ from OBANALY_FACT_SALESORDHEADER obanalyfac0_ where obanalyfac0_.C_Order_ID=$1
2018-09-04 17:36:57 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 DETAIL: parameters: $1 = '8281DD5CF3224AC2AFAB4D4C65D0A361'
2018-09-04 17:37:32 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 LOG: duration: 34079.182 ms execute S_86046: delete from C_Order where C_Order_ID=$1
2018-09-04 17:37:32 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 DETAIL: parameters: $1 = '8281DD5CF3224AC2AFAB4D4C65D0A361'
2018-09-04 17:37:36 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 LOG: duration: 4845.868 ms execute S_85969/C_86252: select obanalyfac0_.C_Order_ID as C9_622_1_, obanalyfac0_.Obanaly_Fact_Salesordheader_ID as Obanaly1_1_, obanalyfac0_.Obanaly_Fact_Salesordheader_ID as Obanaly1_527_0_, obanalyfac0_.AD_Client_ID as AD2_527_0_, obanalyfac0_.AD_Org_ID as AD3_527_0_, obanalyfac0_.Isactive as Isactive527_0_, obanalyfac0_.Created as Created527_0_, obanalyfac0_.Createdby as Createdby527_0_, obanalyfac0_.Updated as Updated527_0_, obanalyfac0_.Updatedby as Updatedby527_0_, obanalyfac0_.C_Order_ID as C9_527_0_, obanalyfac0_.C_Bpartner_ID as C10_527_0_, obanalyfac0_.C_Bp_Group_ID as C11_527_0_, obanalyfac0_.C_Bp_Taxcategory_ID as C12_527_0_, obanalyfac0_.C_Location_ID as C13_527_0_, obanalyfac0_.C_Region_ID as C14_527_0_, obanalyfac0_.C_Country_ID as C15_527_0_, obanalyfac0_.M_Warehouse_ID as M16_527_0_, obanalyfac0_.C_Currency_ID as C17_527_0_, obanalyfac0_.C_Doctype_ID as C18_527_0_, obanalyfac0_.C_Doctypetarget_ID as C19_527_0_, obanalyfac0_.Salesrep_ID as Salesrep20_527_0_, obanalyfac0_.Billto_Location_ID as Billto21_527_0_, obanalyfac0_.C_Invoice_Region_ID as C22_527_0_, obanalyfac0_.C_Invoice_Country_ID as C23_527_0_, obanalyfac0_.Delivery_Location_ID as Delivery24_527_0_, obanalyfac0_.Delivery_Region_ID as Delivery25_527_0_, obanalyfac0_.Delivery_Country_ID as Delivery26_527_0_, obanalyfac0_.C_Paymentterm_ID as C27_527_0_, obanalyfac0_.M_Pricelist_ID as M28_527_0_, obanalyfac0_.FIN_Paymentmethod_ID as FIN29_527_0_, obanalyfac0_.C_Return_Reason_ID as C30_527_0_, obanalyfac0_.Documentno as Documentno527_0_, obanalyfac0_.Orderdate as Orderdate527_0_, obanalyfac0_.Dateordered as Dateord33_527_0_, obanalyfac0_.Datepromised as Datepro34_527_0_, obanalyfac0_.Linecount as Linecount527_0_, obanalyfac0_.Quantity as Quantity527_0_, obanalyfac0_.Qtynet as Qtynet527_0_, obanalyfac0_.Qtyreturned as Qtyretu38_527_0_, obanalyfac0_.Amount as Amount527_0_, obanalyfac0_.Amtnet as Amtnet527_0_, obanalyfac0_.Amtreturn as Amtreturn527_0_, obanalyfac0_.Taxamount as Taxamount527_0_, obanalyfac0_.Taxamtnet as Taxamtnet527_0_, obanalyfac0_.Taxamtreturn as Taxamtr44_527_0_, obanalyfac0_.Discamount as Discamount527_0_, obanalyfac0_.Discamtnet as Discamtnet527_0_, obanalyfac0_.Discamtreturn as Discamt47_527_0_, obanalyfac0_.Dirdiscamount as Dirdisc48_527_0_, obanalyfac0_.Dirdiscamtnet as Dirdisc49_527_0_, obanalyfac0_.Dirdiscamtreturn as Dirdisc50_527_0_, obanalyfac0_.Conversiondate as Convers51_527_0_, obanalyfac0_.EM_Obretan_Applications_ID as EM52_527_0_, obanalyfac0_.Weeknum as Weeknum527_0_, obanalyfac0_.EM_Obretan_Terminaltype_ID as EM54_527_0_, obanalyfac0_.Yearnum as Yearnum527_0_, obanalyfac0_.Ordertime as Ordertime527_0_, obanalyfac0_.M_Offer_ID as M57_527_0_, obanalyfac0_.City as City527_0_, obanalyfac0_.Postalcode as Postalcode527_0_, obanalyfac0_.Birthdate as Birthdate527_0_, obanalyfac0_.Hournum as Hournum527_0_, obanalyfac0_.Weekday as Weekday527_0_, obanalyfac0_.Monthnum as Monthnum527_0_, obanalyfac0_.C_Costcenter_ID as C64_527_0_ from OBANALY_FACT_SALESORDHEADER obanalyfac0_ where obanalyfac0_.C_Order_ID=$1
2018-09-04 17:37:36 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 DETAIL: parameters: $1 = 'E2D916DB65364C93A52E859294BBE83D'
2018-09-04 17:38:10 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 LOG: duration: 33130.947 ms execute S_86046: delete from C_Order where C_Order_ID=$1
2018-09-04 17:38:10 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 DETAIL: parameters: $1 = 'E2D916DB65364C93A52E859294BBE83D'
2018-09-04 17:38:15 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 LOG: duration: 4547.112 ms execute S_85969/C_86271: select obanalyfac0_.C_Order_ID as C9_622_1_, obanalyfac0_.Obanaly_Fact_Salesordheader_ID as Obanaly1_1_, obanalyfac0_.Obanaly_Fact_Salesordheader_ID as Obanaly1_527_0_, obanalyfac0_.AD_Client_ID as AD2_527_0_, obanalyfac0_.AD_Org_ID as AD3_527_0_, obanalyfac0_.Isactive as Isactive527_0_, obanalyfac0_.Created as Created527_0_, obanalyfac0_.Createdby as Createdby527_0_, obanalyfac0_.Updated as Updated527_0_, obanalyfac0_.Updatedby as Updatedby527_0_, obanalyfac0_.C_Order_ID as C9_527_0_, obanalyfac0_.C_Bpartner_ID as C10_527_0_, obanalyfac0_.C_Bp_Group_ID as C11_527_0_, obanalyfac0_.C_Bp_Taxcategory_ID as C12_527_0_, obanalyfac0_.C_Location_ID as C13_527_0_, obanalyfac0_.C_Region_ID as C14_527_0_, obanalyfac0_.C_Country_ID as C15_527_0_, obanalyfac0_.M_Warehouse_ID as M16_527_0_, obanalyfac0_.C_Currency_ID as C17_527_0_, obanalyfac0_.C_Doctype_ID as C18_527_0_, obanalyfac0_.C_Doctypetarget_ID as C19_527_0_, obanalyfac0_.Salesrep_ID as Salesrep20_527_0_, obanalyfac0_.Billto_Location_ID as Billto21_527_0_, obanalyfac0_.C_Invoice_Region_ID as C22_527_0_, obanalyfac0_.C_Invoice_Country_ID as C23_527_0_, obanalyfac0_.Delivery_Location_ID as Delivery24_527_0_, obanalyfac0_.Delivery_Region_ID as Delivery25_527_0_, obanalyfac0_.Delivery_Country_ID as Delivery26_527_0_, obanalyfac0_.C_Paymentterm_ID as C27_527_0_, obanalyfac0_.M_Pricelist_ID as M28_527_0_, obanalyfac0_.FIN_Paymentmethod_ID as FIN29_527_0_, obanalyfac0_.C_Return_Reason_ID as C30_527_0_, obanalyfac0_.Documentno as Documentno527_0_, obanalyfac0_.Orderdate as Orderdate527_0_, obanalyfac0_.Dateordered as Dateord33_527_0_, obanalyfac0_.Datepromised as Datepro34_527_0_, obanalyfac0_.Linecount as Linecount527_0_, obanalyfac0_.Quantity as Quantity527_0_, obanalyfac0_.Qtynet as Qtynet527_0_, obanalyfac0_.Qtyreturned as Qtyretu38_527_0_, obanalyfac0_.Amount as Amount527_0_, obanalyfac0_.Amtnet as Amtnet527_0_, obanalyfac0_.Amtreturn as Amtreturn527_0_, obanalyfac0_.Taxamount as Taxamount527_0_, obanalyfac0_.Taxamtnet as Taxamtnet527_0_, obanalyfac0_.Taxamtreturn as Taxamtr44_527_0_, obanalyfac0_.Discamount as Discamount527_0_, obanalyfac0_.Discamtnet as Discamtnet527_0_, obanalyfac0_.Discamtreturn as Discamt47_527_0_, obanalyfac0_.Dirdiscamount as Dirdisc48_527_0_, obanalyfac0_.Dirdiscamtnet as Dirdisc49_527_0_, obanalyfac0_.Dirdiscamtreturn as Dirdisc50_527_0_, obanalyfac0_.Conversiondate as Convers51_527_0_, obanalyfac0_.EM_Obretan_Applications_ID as EM52_527_0_, obanalyfac0_.Weeknum as Weeknum527_0_, obanalyfac0_.EM_Obretan_Terminaltype_ID as EM54_527_0_, obanalyfac0_.Yearnum as Yearnum527_0_, obanalyfac0_.Ordertime as Ordertime527_0_, obanalyfac0_.M_Offer_ID as M57_527_0_, obanalyfac0_.City as City527_0_, obanalyfac0_.Postalcode as Postalcode527_0_, obanalyfac0_.Birthdate as Birthdate527_0_, obanalyfac0_.Hournum as Hournum527_0_, obanalyfac0_.Weekday as Weekday527_0_, obanalyfac0_.Monthnum as Monthnum527_0_, obanalyfac0_.C_Costcenter_ID as C64_527_0_ from OBANALY_FACT_SALESORDHEADER obanalyfac0_ where obanalyfac0_.C_Order_ID=$1
2018-09-04 17:38:15 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 DETAIL: parameters: $1 = '3EECB9C31703422298F006B3681A96D0'
2018-09-04 17:38:48 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 LOG: duration: 32191.968 ms execute S_86046: delete from C_Order where C_Order_ID=$1
2018-09-04 17:38:48 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 DETAIL: parameters: $1 = '3EECB9C31703422298F006B3681A96D0'
2018-09-04 17:38:53 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 LOG: duration: 5188.929 ms execute S_85969/C_86290: select obanalyfac0_.C_Order_ID as C9_622_1_, obanalyfac0_.Obanaly_Fact_Salesordheader_ID as Obanaly1_1_, obanalyfac0_.Obanaly_Fact_Salesordheader_ID as Obanaly1_527_0_, obanalyfac0_.AD_Client_ID as AD2_527_0_, obanalyfac0_.AD_Org_ID as AD3_527_0_, obanalyfac0_.Isactive as Isactive527_0_, obanalyfac0_.Created as Created527_0_, obanalyfac0_.Createdby as Createdby527_0_, obanalyfac0_.Updated as Updated527_0_, obanalyfac0_.Updatedby as Updatedby527_0_, obanalyfac0_.C_Order_ID as C9_527_0_, obanalyfac0_.C_Bpartner_ID as C10_527_0_, obanalyfac0_.C_Bp_Group_ID as C11_527_0_, obanalyfac0_.C_Bp_Taxcategory_ID as C12_527_0_, obanalyfac0_.C_Location_ID as C13_527_0_, obanalyfac0_.C_Region_ID as C14_527_0_, obanalyfac0_.C_Country_ID as C15_527_0_, obanalyfac0_.M_Warehouse_ID as M16_527_0_, obanalyfac0_.C_Currency_ID as C17_527_0_, obanalyfac0_.C_Doctype_ID as C18_527_0_, obanalyfac0_.C_Doctypetarget_ID as C19_527_0_, obanalyfac0_.Salesrep_ID as Salesrep20_527_0_, obanalyfac0_.Billto_Location_ID as Billto21_527_0_, obanalyfac0_.C_Invoice_Region_ID as C22_527_0_, obanalyfac0_.C_Invoice_Country_ID as C23_527_0_, obanalyfac0_.Delivery_Location_ID as Delivery24_527_0_, obanalyfac0_.Delivery_Region_ID as Delivery25_527_0_, obanalyfac0_.Delivery_Country_ID as Delivery26_527_0_, obanalyfac0_.C_Paymentterm_ID as C27_527_0_, obanalyfac0_.M_Pricelist_ID as M28_527_0_, obanalyfac0_.FIN_Paymentmethod_ID as FIN29_527_0_, obanalyfac0_.C_Return_Reason_ID as C30_527_0_, obanalyfac0_.Documentno as Documentno527_0_, obanalyfac0_.Orderdate as Orderdate527_0_, obanalyfac0_.Dateordered as Dateord33_527_0_, obanalyfac0_.Datepromised as Datepro34_527_0_, obanalyfac0_.Linecount as Linecount527_0_, obanalyfac0_.Quantity as Quantity527_0_, obanalyfac0_.Qtynet as Qtynet527_0_, obanalyfac0_.Qtyreturned as Qtyretu38_527_0_, obanalyfac0_.Amount as Amount527_0_, obanalyfac0_.Amtnet as Amtnet527_0_, obanalyfac0_.Amtreturn as Amtreturn527_0_, obanalyfac0_.Taxamount as Taxamount527_0_, obanalyfac0_.Taxamtnet as Taxamtnet527_0_, obanalyfac0_.Taxamtreturn as Taxamtr44_527_0_, obanalyfac0_.Discamount as Discamount527_0_, obanalyfac0_.Discamtnet as Discamtnet527_0_, obanalyfac0_.Discamtreturn as Discamt47_527_0_, obanalyfac0_.Dirdiscamount as Dirdisc48_527_0_, obanalyfac0_.Dirdiscamtnet as Dirdisc49_527_0_, obanalyfac0_.Dirdiscamtreturn as Dirdisc50_527_0_, obanalyfac0_.Conversiondate as Convers51_527_0_, obanalyfac0_.EM_Obretan_Applications_ID as EM52_527_0_, obanalyfac0_.Weeknum as Weeknum527_0_, obanalyfac0_.EM_Obretan_Terminaltype_ID as EM54_527_0_, obanalyfac0_.Yearnum as Yearnum527_0_, obanalyfac0_.Ordertime as Ordertime527_0_, obanalyfac0_.M_Offer_ID as M57_527_0_, obanalyfac0_.City as City527_0_, obanalyfac0_.Postalcode as Postalcode527_0_, obanalyfac0_.Birthdate as Birthdate527_0_, obanalyfac0_.Hournum as Hournum527_0_, obanalyfac0_.Weekday as Weekday527_0_, obanalyfac0_.Monthnum as Monthnum527_0_, obanalyfac0_.C_Costcenter_ID as C64_527_0_ from OBANALY_FACT_SALESORDHEADER obanalyfac0_ where obanalyfac0_.C_Order_ID=$1
2018-09-04 17:38:53 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 DETAIL: parameters: $1 = '18AB763F38E84568B58B49F9D536EA84'
2018-09-04 17:39:24 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 LOG: duration: 31623.835 ms execute S_86046: delete from C_Order where C_Order_ID=$1
2018-09-04 17:39:24 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 DETAIL: parameters: $1 = '18AB763F38E84568B58B49F9D536EA84'
2018-09-04 17:39:30 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 LOG: duration: 5907.907 ms execute S_85969/C_86298: select obanalyfac0_.C_Order_ID as C9_622_1_, obanalyfac0_.Obanaly_Fact_Salesordheader_ID as Obanaly1_1_, obanalyfac0_.Obanaly_Fact_Salesordheader_ID as Obanaly1_527_0_, obanalyfac0_.AD_Client_ID as AD2_527_0_, obanalyfac0_.AD_Org_ID as AD3_527_0_, obanalyfac0_.Isactive as Isactive527_0_, obanalyfac0_.Created as Created527_0_, obanalyfac0_.Createdby as Createdby527_0_, obanalyfac0_.Updated as Updated527_0_, obanalyfac0_.Updatedby as Updatedby527_0_, obanalyfac0_.C_Order_ID as C9_527_0_, obanalyfac0_.C_Bpartner_ID as C10_527_0_, obanalyfac0_.C_Bp_Group_ID as C11_527_0_, obanalyfac0_.C_Bp_Taxcategory_ID as C12_527_0_, obanalyfac0_.C_Location_ID as C13_527_0_, obanalyfac0_.C_Region_ID as C14_527_0_, obanalyfac0_.C_Country_ID as C15_527_0_, obanalyfac0_.M_Warehouse_ID as M16_527_0_, obanalyfac0_.C_Currency_ID as C17_527_0_, obanalyfac0_.C_Doctype_ID as C18_527_0_, obanalyfac0_.C_Doctypetarget_ID as C19_527_0_, obanalyfac0_.Salesrep_ID as Salesrep20_527_0_, obanalyfac0_.Billto_Location_ID as Billto21_527_0_, obanalyfac0_.C_Invoice_Region_ID as C22_527_0_, obanalyfac0_.C_Invoice_Country_ID as C23_527_0_, obanalyfac0_.Delivery_Location_ID as Delivery24_527_0_, obanalyfac0_.Delivery_Region_ID as Delivery25_527_0_, obanalyfac0_.Delivery_Country_ID as Delivery26_527_0_, obanalyfac0_.C_Paymentterm_ID as C27_527_0_, obanalyfac0_.M_Pricelist_ID as M28_527_0_, obanalyfac0_.FIN_Paymentmethod_ID as FIN29_527_0_, obanalyfac0_.C_Return_Reason_ID as C30_527_0_, obanalyfac0_.Documentno as Documentno527_0_, obanalyfac0_.Orderdate as Orderdate527_0_, obanalyfac0_.Dateordered as Dateord33_527_0_, obanalyfac0_.Datepromised as Datepro34_527_0_, obanalyfac0_.Linecount as Linecount527_0_, obanalyfac0_.Quantity as Quantity527_0_, obanalyfac0_.Qtynet as Qtynet527_0_, obanalyfac0_.Qtyreturned as Qtyretu38_527_0_, obanalyfac0_.Amount as Amount527_0_, obanalyfac0_.Amtnet as Amtnet527_0_, obanalyfac0_.Amtreturn as Amtreturn527_0_, obanalyfac0_.Taxamount as Taxamount527_0_, obanalyfac0_.Taxamtnet as Taxamtnet527_0_, obanalyfac0_.Taxamtreturn as Taxamtr44_527_0_, obanalyfac0_.Discamount as Discamount527_0_, obanalyfac0_.Discamtnet as Discamtnet527_0_, obanalyfac0_.Discamtreturn as Discamt47_527_0_, obanalyfac0_.Dirdiscamount as Dirdisc48_527_0_, obanalyfac0_.Dirdiscamtnet as Dirdisc49_527_0_, obanalyfac0_.Dirdiscamtreturn as Dirdisc50_527_0_, obanalyfac0_.Conversiondate as Convers51_527_0_, obanalyfac0_.EM_Obretan_Applications_ID as EM52_527_0_, obanalyfac0_.Weeknum as Weeknum527_0_, obanalyfac0_.EM_Obretan_Terminaltype_ID as EM54_527_0_, obanalyfac0_.Yearnum as Yearnum527_0_, obanalyfac0_.Ordertime as Ordertime527_0_, obanalyfac0_.M_Offer_ID as M57_527_0_, obanalyfac0_.City as City527_0_, obanalyfac0_.Postalcode as Postalcode527_0_, obanalyfac0_.Birthdate as Birthdate527_0_, obanalyfac0_.Hournum as Hournum527_0_, obanalyfac0_.Weekday as Weekday527_0_, obanalyfac0_.Monthnum as Monthnum527_0_, obanalyfac0_.C_Costcenter_ID as C64_527_0_ from OBANALY_FACT_SALESORDHEADER obanalyfac0_ where obanalyfac0_.C_Order_ID=$1
2018-09-04 17:39:30 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 DETAIL: parameters: $1 = '73D9208C281A46F194C19F2AE0842F5C'
2018-09-04 17:40:04 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 LOG: duration: 33577.882 ms execute S_86046: delete from C_Order where C_Order_ID=$1
2018-09-04 17:40:04 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 DETAIL: parameters: $1 = '73D9208C281A46F194C19F2AE0842F5C'
2018-09-04 17:40:09 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 LOG: duration: 5007.214 ms execute S_85969/C_86315: select obanalyfac0_.C_Order_ID as C9_622_1_, obanalyfac0_.Obanaly_Fact_Salesordheader_ID as Obanaly1_1_, obanalyfac0_.Obanaly_Fact_Salesordheader_ID as Obanaly1_527_0_, obanalyfac0_.AD_Client_ID as AD2_527_0_, obanalyfac0_.AD_Org_ID as AD3_527_0_, obanalyfac0_.Isactive as Isactive527_0_, obanalyfac0_.Created as Created527_0_, obanalyfac0_.Createdby as Createdby527_0_, obanalyfac0_.Updated as Updated527_0_, obanalyfac0_.Updatedby as Updatedby527_0_, obanalyfac0_.C_Order_ID as C9_527_0_, obanalyfac0_.C_Bpartner_ID as C10_527_0_, obanalyfac0_.C_Bp_Group_ID as C11_527_0_, obanalyfac0_.C_Bp_Taxcategory_ID as C12_527_0_, obanalyfac0_.C_Location_ID as C13_527_0_, obanalyfac0_.C_Region_ID as C14_527_0_, obanalyfac0_.C_Country_ID as C15_527_0_, obanalyfac0_.M_Warehouse_ID as M16_527_0_, obanalyfac0_.C_Currency_ID as C17_527_0_, obanalyfac0_.C_Doctype_ID as C18_527_0_, obanalyfac0_.C_Doctypetarget_ID as C19_527_0_, obanalyfac0_.Salesrep_ID as Salesrep20_527_0_, obanalyfac0_.Billto_Location_ID as Billto21_527_0_, obanalyfac0_.C_Invoice_Region_ID as C22_527_0_, obanalyfac0_.C_Invoice_Country_ID as C23_527_0_, obanalyfac0_.Delivery_Location_ID as Delivery24_527_0_, obanalyfac0_.Delivery_Region_ID as Delivery25_527_0_, obanalyfac0_.Delivery_Country_ID as Delivery26_527_0_, obanalyfac0_.C_Paymentterm_ID as C27_527_0_, obanalyfac0_.M_Pricelist_ID as M28_527_0_, obanalyfac0_.FIN_Paymentmethod_ID as FIN29_527_0_, obanalyfac0_.C_Return_Reason_ID as C30_527_0_, obanalyfac0_.Documentno as Documentno527_0_, obanalyfac0_.Orderdate as Orderdate527_0_, obanalyfac0_.Dateordered as Dateord33_527_0_, obanalyfac0_.Datepromised as Datepro34_527_0_, obanalyfac0_.Linecount as Linecount527_0_, obanalyfac0_.Quantity as Quantity527_0_, obanalyfac0_.Qtynet as Qtynet527_0_, obanalyfac0_.Qtyreturned as Qtyretu38_527_0_, obanalyfac0_.Amount as Amount527_0_, obanalyfac0_.Amtnet as Amtnet527_0_, obanalyfac0_.Amtreturn as Amtreturn527_0_, obanalyfac0_.Taxamount as Taxamount527_0_, obanalyfac0_.Taxamtnet as Taxamtnet527_0_, obanalyfac0_.Taxamtreturn as Taxamtr44_527_0_, obanalyfac0_.Discamount as Discamount527_0_, obanalyfac0_.Discamtnet as Discamtnet527_0_, obanalyfac0_.Discamtreturn as Discamt47_527_0_, obanalyfac0_.Dirdiscamount as Dirdisc48_527_0_, obanalyfac0_.Dirdiscamtnet as Dirdisc49_527_0_, obanalyfac0_.Dirdiscamtreturn as Dirdisc50_527_0_, obanalyfac0_.Conversiondate as Convers51_527_0_, obanalyfac0_.EM_Obretan_Applications_ID as EM52_527_0_, obanalyfac0_.Weeknum as Weeknum527_0_, obanalyfac0_.EM_Obretan_Terminaltype_ID as EM54_527_0_, obanalyfac0_.Yearnum as Yearnum527_0_, obanalyfac0_.Ordertime as Ordertime527_0_, obanalyfac0_.M_Offer_ID as M57_527_0_, obanalyfac0_.City as City527_0_, obanalyfac0_.Postalcode as Postalcode527_0_, obanalyfac0_.Birthdate as Birthdate527_0_, obanalyfac0_.Hournum as Hournum527_0_, obanalyfac0_.Weekday as Weekday527_0_, obanalyfac0_.Monthnum as Monthnum527_0_, obanalyfac0_.C_Costcenter_ID as C64_527_0_ from OBANALY_FACT_SALESORDHEADER obanalyfac0_ where obanalyfac0_.C_Order_ID=$1
2018-09-04 17:40:09 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 DETAIL: parameters: $1 = '6B5960B281E24A6F93BEE4105A7030A7'
2018-09-04 17:40:44 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 LOG: duration: 34880.047 ms execute S_86046: delete from C_Order where C_Order_ID=$1
2018-09-04 17:40:44 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 DETAIL: parameters: $1 = '6B5960B281E24A6F93BEE4105A7030A7'
2018-09-04 17:40:49 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 LOG: duration: 4939.202 ms execute S_85969/C_86323: select obanalyfac0_.C_Order_ID as C9_622_1_, obanalyfac0_.Obanaly_Fact_Salesordheader_ID as Obanaly1_1_, obanalyfac0_.Obanaly_Fact_Salesordheader_ID as Obanaly1_527_0_, obanalyfac0_.AD_Client_ID as AD2_527_0_, obanalyfac0_.AD_Org_ID as AD3_527_0_, obanalyfac0_.Isactive as Isactive527_0_, obanalyfac0_.Created as Created527_0_, obanalyfac0_.Createdby as Createdby527_0_, obanalyfac0_.Updated as Updated527_0_, obanalyfac0_.Updatedby as Updatedby527_0_, obanalyfac0_.C_Order_ID as C9_527_0_, obanalyfac0_.C_Bpartner_ID as C10_527_0_, obanalyfac0_.C_Bp_Group_ID as C11_527_0_, obanalyfac0_.C_Bp_Taxcategory_ID as C12_527_0_, obanalyfac0_.C_Location_ID as C13_527_0_, obanalyfac0_.C_Region_ID as C14_527_0_, obanalyfac0_.C_Country_ID as C15_527_0_, obanalyfac0_.M_Warehouse_ID as M16_527_0_, obanalyfac0_.C_Currency_ID as C17_527_0_, obanalyfac0_.C_Doctype_ID as C18_527_0_, obanalyfac0_.C_Doctypetarget_ID as C19_527_0_, obanalyfac0_.Salesrep_ID as Salesrep20_527_0_, obanalyfac0_.Billto_Location_ID as Billto21_527_0_, obanalyfac0_.C_Invoice_Region_ID as C22_527_0_, obanalyfac0_.C_Invoice_Country_ID as C23_527_0_, obanalyfac0_.Delivery_Location_ID as Delivery24_527_0_, obanalyfac0_.Delivery_Region_ID as Delivery25_527_0_, obanalyfac0_.Delivery_Country_ID as Delivery26_527_0_, obanalyfac0_.C_Paymentterm_ID as C27_527_0_, obanalyfac0_.M_Pricelist_ID as M28_527_0_, obanalyfac0_.FIN_Paymentmethod_ID as FIN29_527_0_, obanalyfac0_.C_Return_Reason_ID as C30_527_0_, obanalyfac0_.Documentno as Documentno527_0_, obanalyfac0_.Orderdate as Orderdate527_0_, obanalyfac0_.Dateordered as Dateord33_527_0_, obanalyfac0_.Datepromised as Datepro34_527_0_, obanalyfac0_.Linecount as Linecount527_0_, obanalyfac0_.Quantity as Quantity527_0_, obanalyfac0_.Qtynet as Qtynet527_0_, obanalyfac0_.Qtyreturned as Qtyretu38_527_0_, obanalyfac0_.Amount as Amount527_0_, obanalyfac0_.Amtnet as Amtnet527_0_, obanalyfac0_.Amtreturn as Amtreturn527_0_, obanalyfac0_.Taxamount as Taxamount527_0_, obanalyfac0_.Taxamtnet as Taxamtnet527_0_, obanalyfac0_.Taxamtreturn as Taxamtr44_527_0_, obanalyfac0_.Discamount as Discamount527_0_, obanalyfac0_.Discamtnet as Discamtnet527_0_, obanalyfac0_.Discamtreturn as Discamt47_527_0_, obanalyfac0_.Dirdiscamount as Dirdisc48_527_0_, obanalyfac0_.Dirdiscamtnet as Dirdisc49_527_0_, obanalyfac0_.Dirdiscamtreturn as Dirdisc50_527_0_, obanalyfac0_.Conversiondate as Convers51_527_0_, obanalyfac0_.EM_Obretan_Applications_ID as EM52_527_0_, obanalyfac0_.Weeknum as Weeknum527_0_, obanalyfac0_.EM_Obretan_Terminaltype_ID as EM54_527_0_, obanalyfac0_.Yearnum as Yearnum527_0_, obanalyfac0_.Ordertime as Ordertime527_0_, obanalyfac0_.M_Offer_ID as M57_527_0_, obanalyfac0_.City as City527_0_, obanalyfac0_.Postalcode as Postalcode527_0_, obanalyfac0_.Birthdate as Birthdate527_0_, obanalyfac0_.Hournum as Hournum527_0_, obanalyfac0_.Weekday as Weekday527_0_, obanalyfac0_.Monthnum as Monthnum527_0_, obanalyfac0_.C_Costcenter_ID as C64_527_0_ from OBANALY_FACT_SALESORDHEADER obanalyfac0_ where obanalyfac0_.C_Order_ID=$1
2018-09-04 17:40:49 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 DETAIL: parameters: $1 = 'BCB2123AFE6C461FB6C507003E2EA0F9'
2018-09-04 17:41:23 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 LOG: duration: 33096.579 ms execute S_86046: delete from C_Order where C_Order_ID=$1
2018-09-04 17:41:23 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 DETAIL: parameters: $1 = 'BCB2123AFE6C461FB6C507003E2EA0F9'
2018-09-04 17:41:28 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 LOG: duration: 5321.142 ms execute S_85969/C_86340: select obanalyfac0_.C_Order_ID as C9_622_1_, obanalyfac0_.Obanaly_Fact_Salesordheader_ID as Obanaly1_1_, obanalyfac0_.Obanaly_Fact_Salesordheader_ID as Obanaly1_527_0_, obanalyfac0_.AD_Client_ID as AD2_527_0_, obanalyfac0_.AD_Org_ID as AD3_527_0_, obanalyfac0_.Isactive as Isactive527_0_, obanalyfac0_.Created as Created527_0_, obanalyfac0_.Createdby as Createdby527_0_, obanalyfac0_.Updated as Updated527_0_, obanalyfac0_.Updatedby as Updatedby527_0_, obanalyfac0_.C_Order_ID as C9_527_0_, obanalyfac0_.C_Bpartner_ID as C10_527_0_, obanalyfac0_.C_Bp_Group_ID as C11_527_0_, obanalyfac0_.C_Bp_Taxcategory_ID as C12_527_0_, obanalyfac0_.C_Location_ID as C13_527_0_, obanalyfac0_.C_Region_ID as C14_527_0_, obanalyfac0_.C_Country_ID as C15_527_0_, obanalyfac0_.M_Warehouse_ID as M16_527_0_, obanalyfac0_.C_Currency_ID as C17_527_0_, obanalyfac0_.C_Doctype_ID as C18_527_0_, obanalyfac0_.C_Doctypetarget_ID as C19_527_0_, obanalyfac0_.Salesrep_ID as Salesrep20_527_0_, obanalyfac0_.Billto_Location_ID as Billto21_527_0_, obanalyfac0_.C_Invoice_Region_ID as C22_527_0_, obanalyfac0_.C_Invoice_Country_ID as C23_527_0_, obanalyfac0_.Delivery_Location_ID as Delivery24_527_0_, obanalyfac0_.Delivery_Region_ID as Delivery25_527_0_, obanalyfac0_.Delivery_Country_ID as Delivery26_527_0_, obanalyfac0_.C_Paymentterm_ID as C27_527_0_, obanalyfac0_.M_Pricelist_ID as M28_527_0_, obanalyfac0_.FIN_Paymentmethod_ID as FIN29_527_0_, obanalyfac0_.C_Return_Reason_ID as C30_527_0_, obanalyfac0_.Documentno as Documentno527_0_, obanalyfac0_.Orderdate as Orderdate527_0_, obanalyfac0_.Dateordered as Dateord33_527_0_, obanalyfac0_.Datepromised as Datepro34_527_0_, obanalyfac0_.Linecount as Linecount527_0_, obanalyfac0_.Quantity as Quantity527_0_, obanalyfac0_.Qtynet as Qtynet527_0_, obanalyfac0_.Qtyreturned as Qtyretu38_527_0_, obanalyfac0_.Amount as Amount527_0_, obanalyfac0_.Amtnet as Amtnet527_0_, obanalyfac0_.Amtreturn as Amtreturn527_0_, obanalyfac0_.Taxamount as Taxamount527_0_, obanalyfac0_.Taxamtnet as Taxamtnet527_0_, obanalyfac0_.Taxamtreturn as Taxamtr44_527_0_, obanalyfac0_.Discamount as Discamount527_0_, obanalyfac0_.Discamtnet as Discamtnet527_0_, obanalyfac0_.Discamtreturn as Discamt47_527_0_, obanalyfac0_.Dirdiscamount as Dirdisc48_527_0_, obanalyfac0_.Dirdiscamtnet as Dirdisc49_527_0_, obanalyfac0_.Dirdiscamtreturn as Dirdisc50_527_0_, obanalyfac0_.Conversiondate as Convers51_527_0_, obanalyfac0_.EM_Obretan_Applications_ID as EM52_527_0_, obanalyfac0_.Weeknum as Weeknum527_0_, obanalyfac0_.EM_Obretan_Terminaltype_ID as EM54_527_0_, obanalyfac0_.Yearnum as Yearnum527_0_, obanalyfac0_.Ordertime as Ordertime527_0_, obanalyfac0_.M_Offer_ID as M57_527_0_, obanalyfac0_.City as City527_0_, obanalyfac0_.Postalcode as Postalcode527_0_, obanalyfac0_.Birthdate as Birthdate527_0_, obanalyfac0_.Hournum as Hournum527_0_, obanalyfac0_.Weekday as Weekday527_0_, obanalyfac0_.Monthnum as Monthnum527_0_, obanalyfac0_.C_Costcenter_ID as C64_527_0_ from OBANALY_FACT_SALESORDHEADER obanalyfac0_ where obanalyfac0_.C_Order_ID=$1
2018-09-04 17:41:28 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 DETAIL: parameters: $1 = '386293DDB26845F0925B8AF483803F31'
2018-09-04 17:42:05 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 LOG: duration: 36613.235 ms execute S_86046: delete from C_Order where C_Order_ID=$1
2018-09-04 17:42:05 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 DETAIL: parameters: $1 = '386293DDB26845F0925B8AF483803F31'
2018-09-04 17:42:10 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 LOG: duration: 5779.617 ms execute S_85969/C_86348: select obanalyfac0_.C_Order_ID as C9_622_1_, obanalyfac0_.Obanaly_Fact_Salesordheader_ID as Obanaly1_1_, obanalyfac0_.Obanaly_Fact_Salesordheader_ID as Obanaly1_527_0_, obanalyfac0_.AD_Client_ID as AD2_527_0_, obanalyfac0_.AD_Org_ID as AD3_527_0_, obanalyfac0_.Isactive as Isactive527_0_, obanalyfac0_.Created as Created527_0_, obanalyfac0_.Createdby as Createdby527_0_, obanalyfac0_.Updated as Updated527_0_, obanalyfac0_.Updatedby as Updatedby527_0_, obanalyfac0_.C_Order_ID as C9_527_0_, obanalyfac0_.C_Bpartner_ID as C10_527_0_, obanalyfac0_.C_Bp_Group_ID as C11_527_0_, obanalyfac0_.C_Bp_Taxcategory_ID as C12_527_0_, obanalyfac0_.C_Location_ID as C13_527_0_, obanalyfac0_.C_Region_ID as C14_527_0_, obanalyfac0_.C_Country_ID as C15_527_0_, obanalyfac0_.M_Warehouse_ID as M16_527_0_, obanalyfac0_.C_Currency_ID as C17_527_0_, obanalyfac0_.C_Doctype_ID as C18_527_0_, obanalyfac0_.C_Doctypetarget_ID as C19_527_0_, obanalyfac0_.Salesrep_ID as Salesrep20_527_0_, obanalyfac0_.Billto_Location_ID as Billto21_527_0_, obanalyfac0_.C_Invoice_Region_ID as C22_527_0_, obanalyfac0_.C_Invoice_Country_ID as C23_527_0_, obanalyfac0_.Delivery_Location_ID as Delivery24_527_0_, obanalyfac0_.Delivery_Region_ID as Delivery25_527_0_, obanalyfac0_.Delivery_Country_ID as Delivery26_527_0_, obanalyfac0_.C_Paymentterm_ID as C27_527_0_, obanalyfac0_.M_Pricelist_ID as M28_527_0_, obanalyfac0_.FIN_Paymentmethod_ID as FIN29_527_0_, obanalyfac0_.C_Return_Reason_ID as C30_527_0_, obanalyfac0_.Documentno as Documentno527_0_, obanalyfac0_.Orderdate as Orderdate527_0_, obanalyfac0_.Dateordered as Dateord33_527_0_, obanalyfac0_.Datepromised as Datepro34_527_0_, obanalyfac0_.Linecount as Linecount527_0_, obanalyfac0_.Quantity as Quantity527_0_, obanalyfac0_.Qtynet as Qtynet527_0_, obanalyfac0_.Qtyreturned as Qtyretu38_527_0_, obanalyfac0_.Amount as Amount527_0_, obanalyfac0_.Amtnet as Amtnet527_0_, obanalyfac0_.Amtreturn as Amtreturn527_0_, obanalyfac0_.Taxamount as Taxamount527_0_, obanalyfac0_.Taxamtnet as Taxamtnet527_0_, obanalyfac0_.Taxamtreturn as Taxamtr44_527_0_, obanalyfac0_.Discamount as Discamount527_0_, obanalyfac0_.Discamtnet as Discamtnet527_0_, obanalyfac0_.Discamtreturn as Discamt47_527_0_, obanalyfac0_.Dirdiscamount as Dirdisc48_527_0_, obanalyfac0_.Dirdiscamtnet as Dirdisc49_527_0_, obanalyfac0_.Dirdiscamtreturn as Dirdisc50_527_0_, obanalyfac0_.Conversiondate as Convers51_527_0_, obanalyfac0_.EM_Obretan_Applications_ID as EM52_527_0_, obanalyfac0_.Weeknum as Weeknum527_0_, obanalyfac0_.EM_Obretan_Terminaltype_ID as EM54_527_0_, obanalyfac0_.Yearnum as Yearnum527_0_, obanalyfac0_.Ordertime as Ordertime527_0_, obanalyfac0_.M_Offer_ID as M57_527_0_, obanalyfac0_.City as City527_0_, obanalyfac0_.Postalcode as Postalcode527_0_, obanalyfac0_.Birthdate as Birthdate527_0_, obanalyfac0_.Hournum as Hournum527_0_, obanalyfac0_.Weekday as Weekday527_0_, obanalyfac0_.Monthnum as Monthnum527_0_, obanalyfac0_.C_Costcenter_ID as C64_527_0_ from OBANALY_FACT_SALESORDHEADER obanalyfac0_ where obanalyfac0_.C_Order_ID=$1
2018-09-04 17:42:10 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 DETAIL: parameters: $1 = '85A3F6C0DDAE4F16A140D16EEE972277'
2018-09-04 17:42:45 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 LOG: duration: 34771.187 ms execute S_86046: delete from C_Order where C_Order_ID=$1
2018-09-04 17:42:45 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 DETAIL: parameters: $1 = '85A3F6C0DDAE4F16A140D16EEE972277'
2018-09-04 17:42:53 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 LOG: duration: 7484.535 ms execute S_85969/C_86356: select obanalyfac0_.C_Order_ID as C9_622_1_, obanalyfac0_.Obanaly_Fact_Salesordheader_ID as Obanaly1_1_, obanalyfac0_.Obanaly_Fact_Salesordheader_ID as Obanaly1_527_0_, obanalyfac0_.AD_Client_ID as AD2_527_0_, obanalyfac0_.AD_Org_ID as AD3_527_0_, obanalyfac0_.Isactive as Isactive527_0_, obanalyfac0_.Created as Created527_0_, obanalyfac0_.Createdby as Createdby527_0_, obanalyfac0_.Updated as Updated527_0_, obanalyfac0_.Updatedby as Updatedby527_0_, obanalyfac0_.C_Order_ID as C9_527_0_, obanalyfac0_.C_Bpartner_ID as C10_527_0_, obanalyfac0_.C_Bp_Group_ID as C11_527_0_, obanalyfac0_.C_Bp_Taxcategory_ID as C12_527_0_, obanalyfac0_.C_Location_ID as C13_527_0_, obanalyfac0_.C_Region_ID as C14_527_0_, obanalyfac0_.C_Country_ID as C15_527_0_, obanalyfac0_.M_Warehouse_ID as M16_527_0_, obanalyfac0_.C_Currency_ID as C17_527_0_, obanalyfac0_.C_Doctype_ID as C18_527_0_, obanalyfac0_.C_Doctypetarget_ID as C19_527_0_, obanalyfac0_.Salesrep_ID as Salesrep20_527_0_, obanalyfac0_.Billto_Location_ID as Billto21_527_0_, obanalyfac0_.C_Invoice_Region_ID as C22_527_0_, obanalyfac0_.C_Invoice_Country_ID as C23_527_0_, obanalyfac0_.Delivery_Location_ID as Delivery24_527_0_, obanalyfac0_.Delivery_Region_ID as Delivery25_527_0_, obanalyfac0_.Delivery_Country_ID as Delivery26_527_0_, obanalyfac0_.C_Paymentterm_ID as C27_527_0_, obanalyfac0_.M_Pricelist_ID as M28_527_0_, obanalyfac0_.FIN_Paymentmethod_ID as FIN29_527_0_, obanalyfac0_.C_Return_Reason_ID as C30_527_0_, obanalyfac0_.Documentno as Documentno527_0_, obanalyfac0_.Orderdate as Orderdate527_0_, obanalyfac0_.Dateordered as Dateord33_527_0_, obanalyfac0_.Datepromised as Datepro34_527_0_, obanalyfac0_.Linecount as Linecount527_0_, obanalyfac0_.Quantity as Quantity527_0_, obanalyfac0_.Qtynet as Qtynet527_0_, obanalyfac0_.Qtyreturned as Qtyretu38_527_0_, obanalyfac0_.Amount as Amount527_0_, obanalyfac0_.Amtnet as Amtnet527_0_, obanalyfac0_.Amtreturn as Amtreturn527_0_, obanalyfac0_.Taxamount as Taxamount527_0_, obanalyfac0_.Taxamtnet as Taxamtnet527_0_, obanalyfac0_.Taxamtreturn as Taxamtr44_527_0_, obanalyfac0_.Discamount as Discamount527_0_, obanalyfac0_.Discamtnet as Discamtnet527_0_, obanalyfac0_.Discamtreturn as Discamt47_527_0_, obanalyfac0_.Dirdiscamount as Dirdisc48_527_0_, obanalyfac0_.Dirdiscamtnet as Dirdisc49_527_0_, obanalyfac0_.Dirdiscamtreturn as Dirdisc50_527_0_, obanalyfac0_.Conversiondate as Convers51_527_0_, obanalyfac0_.EM_Obretan_Applications_ID as EM52_527_0_, obanalyfac0_.Weeknum as Weeknum527_0_, obanalyfac0_.EM_Obretan_Terminaltype_ID as EM54_527_0_, obanalyfac0_.Yearnum as Yearnum527_0_, obanalyfac0_.Ordertime as Ordertime527_0_, obanalyfac0_.M_Offer_ID as M57_527_0_, obanalyfac0_.City as City527_0_, obanalyfac0_.Postalcode as Postalcode527_0_, obanalyfac0_.Birthdate as Birthdate527_0_, obanalyfac0_.Hournum as Hournum527_0_, obanalyfac0_.Weekday as Weekday527_0_, obanalyfac0_.Monthnum as Monthnum527_0_, obanalyfac0_.C_Costcenter_ID as C64_527_0_ from OBANALY_FACT_SALESORDHEADER obanalyfac0_ where obanalyfac0_.C_Order_ID=$1
2018-09-04 17:42:53 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 DETAIL: parameters: $1 = '162F6C0CF6BE45E392963217CFDEA9E6'
2018-09-04 17:43:26 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 LOG: duration: 32811.999 ms execute S_86046: delete from C_Order where C_Order_ID=$1
2018-09-04 17:43:26 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 DETAIL: parameters: $1 = '162F6C0CF6BE45E392963217CFDEA9E6'
2018-09-04 17:43:30 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 LOG: duration: 4887.177 ms execute S_85969/C_86364: select obanalyfac0_.C_Order_ID as C9_622_1_, obanalyfac0_.Obanaly_Fact_Salesordheader_ID as Obanaly1_1_, obanalyfac0_.Obanaly_Fact_Salesordheader_ID as Obanaly1_527_0_, obanalyfac0_.AD_Client_ID as AD2_527_0_, obanalyfac0_.AD_Org_ID as AD3_527_0_, obanalyfac0_.Isactive as Isactive527_0_, obanalyfac0_.Created as Created527_0_, obanalyfac0_.Createdby as Createdby527_0_, obanalyfac0_.Updated as Updated527_0_, obanalyfac0_.Updatedby as Updatedby527_0_, obanalyfac0_.C_Order_ID as C9_527_0_, obanalyfac0_.C_Bpartner_ID as C10_527_0_, obanalyfac0_.C_Bp_Group_ID as C11_527_0_, obanalyfac0_.C_Bp_Taxcategory_ID as C12_527_0_, obanalyfac0_.C_Location_ID as C13_527_0_, obanalyfac0_.C_Region_ID as C14_527_0_, obanalyfac0_.C_Country_ID as C15_527_0_, obanalyfac0_.M_Warehouse_ID as M16_527_0_, obanalyfac0_.C_Currency_ID as C17_527_0_, obanalyfac0_.C_Doctype_ID as C18_527_0_, obanalyfac0_.C_Doctypetarget_ID as C19_527_0_, obanalyfac0_.Salesrep_ID as Salesrep20_527_0_, obanalyfac0_.Billto_Location_ID as Billto21_527_0_, obanalyfac0_.C_Invoice_Region_ID as C22_527_0_, obanalyfac0_.C_Invoice_Country_ID as C23_527_0_, obanalyfac0_.Delivery_Location_ID as Delivery24_527_0_, obanalyfac0_.Delivery_Region_ID as Delivery25_527_0_, obanalyfac0_.Delivery_Country_ID as Delivery26_527_0_, obanalyfac0_.C_Paymentterm_ID as C27_527_0_, obanalyfac0_.M_Pricelist_ID as M28_527_0_, obanalyfac0_.FIN_Paymentmethod_ID as FIN29_527_0_, obanalyfac0_.C_Return_Reason_ID as C30_527_0_, obanalyfac0_.Documentno as Documentno527_0_, obanalyfac0_.Orderdate as Orderdate527_0_, obanalyfac0_.Dateordered as Dateord33_527_0_, obanalyfac0_.Datepromised as Datepro34_527_0_, obanalyfac0_.Linecount as Linecount527_0_, obanalyfac0_.Quantity as Quantity527_0_, obanalyfac0_.Qtynet as Qtynet527_0_, obanalyfac0_.Qtyreturned as Qtyretu38_527_0_, obanalyfac0_.Amount as Amount527_0_, obanalyfac0_.Amtnet as Amtnet527_0_, obanalyfac0_.Amtreturn as Amtreturn527_0_, obanalyfac0_.Taxamount as Taxamount527_0_, obanalyfac0_.Taxamtnet as Taxamtnet527_0_, obanalyfac0_.Taxamtreturn as Taxamtr44_527_0_, obanalyfac0_.Discamount as Discamount527_0_, obanalyfac0_.Discamtnet as Discamtnet527_0_, obanalyfac0_.Discamtreturn as Discamt47_527_0_, obanalyfac0_.Dirdiscamount as Dirdisc48_527_0_, obanalyfac0_.Dirdiscamtnet as Dirdisc49_527_0_, obanalyfac0_.Dirdiscamtreturn as Dirdisc50_527_0_, obanalyfac0_.Conversiondate as Convers51_527_0_, obanalyfac0_.EM_Obretan_Applications_ID as EM52_527_0_, obanalyfac0_.Weeknum as Weeknum527_0_, obanalyfac0_.EM_Obretan_Terminaltype_ID as EM54_527_0_, obanalyfac0_.Yearnum as Yearnum527_0_, obanalyfac0_.Ordertime as Ordertime527_0_, obanalyfac0_.M_Offer_ID as M57_527_0_, obanalyfac0_.City as City527_0_, obanalyfac0_.Postalcode as Postalcode527_0_, obanalyfac0_.Birthdate as Birthdate527_0_, obanalyfac0_.Hournum as Hournum527_0_, obanalyfac0_.Weekday as Weekday527_0_, obanalyfac0_.Monthnum as Monthnum527_0_, obanalyfac0_.C_Costcenter_ID as C64_527_0_ from OBANALY_FACT_SALESORDHEADER obanalyfac0_ where obanalyfac0_.C_Order_ID=$1
2018-09-04 17:43:30 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 DETAIL: parameters: $1 = '5CE8D992C41D4D229952F73AB27926E5'
2018-09-04 17:44:06 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 LOG: duration: 35431.034 ms execute S_86046: delete from C_Order where C_Order_ID=$1
2018-09-04 17:44:06 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 DETAIL: parameters: $1 = '5CE8D992C41D4D229952F73AB27926E5'
2018-09-04 17:44:11 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 LOG: duration: 4743.295 ms execute S_85969/C_86379: select obanalyfac0_.C_Order_ID as C9_622_1_, obanalyfac0_.Obanaly_Fact_Salesordheader_ID as Obanaly1_1_, obanalyfac0_.Obanaly_Fact_Salesordheader_ID as Obanaly1_527_0_, obanalyfac0_.AD_Client_ID as AD2_527_0_, obanalyfac0_.AD_Org_ID as AD3_527_0_, obanalyfac0_.Isactive as Isactive527_0_, obanalyfac0_.Created as Created527_0_, obanalyfac0_.Createdby as Createdby527_0_, obanalyfac0_.Updated as Updated527_0_, obanalyfac0_.Updatedby as Updatedby527_0_, obanalyfac0_.C_Order_ID as C9_527_0_, obanalyfac0_.C_Bpartner_ID as C10_527_0_, obanalyfac0_.C_Bp_Group_ID as C11_527_0_, obanalyfac0_.C_Bp_Taxcategory_ID as C12_527_0_, obanalyfac0_.C_Location_ID as C13_527_0_, obanalyfac0_.C_Region_ID as C14_527_0_, obanalyfac0_.C_Country_ID as C15_527_0_, obanalyfac0_.M_Warehouse_ID as M16_527_0_, obanalyfac0_.C_Currency_ID as C17_527_0_, obanalyfac0_.C_Doctype_ID as C18_527_0_, obanalyfac0_.C_Doctypetarget_ID as C19_527_0_, obanalyfac0_.Salesrep_ID as Salesrep20_527_0_, obanalyfac0_.Billto_Location_ID as Billto21_527_0_, obanalyfac0_.C_Invoice_Region_ID as C22_527_0_, obanalyfac0_.C_Invoice_Country_ID as C23_527_0_, obanalyfac0_.Delivery_Location_ID as Delivery24_527_0_, obanalyfac0_.Delivery_Region_ID as Delivery25_527_0_, obanalyfac0_.Delivery_Country_ID as Delivery26_527_0_, obanalyfac0_.C_Paymentterm_ID as C27_527_0_, obanalyfac0_.M_Pricelist_ID as M28_527_0_, obanalyfac0_.FIN_Paymentmethod_ID as FIN29_527_0_, obanalyfac0_.C_Return_Reason_ID as C30_527_0_, obanalyfac0_.Documentno as Documentno527_0_, obanalyfac0_.Orderdate as Orderdate527_0_, obanalyfac0_.Dateordered as Dateord33_527_0_, obanalyfac0_.Datepromised as Datepro34_527_0_, obanalyfac0_.Linecount as Linecount527_0_, obanalyfac0_.Quantity as Quantity527_0_, obanalyfac0_.Qtynet as Qtynet527_0_, obanalyfac0_.Qtyreturned as Qtyretu38_527_0_, obanalyfac0_.Amount as Amount527_0_, obanalyfac0_.Amtnet as Amtnet527_0_, obanalyfac0_.Amtreturn as Amtreturn527_0_, obanalyfac0_.Taxamount as Taxamount527_0_, obanalyfac0_.Taxamtnet as Taxamtnet527_0_, obanalyfac0_.Taxamtreturn as Taxamtr44_527_0_, obanalyfac0_.Discamount as Discamount527_0_, obanalyfac0_.Discamtnet as Discamtnet527_0_, obanalyfac0_.Discamtreturn as Discamt47_527_0_, obanalyfac0_.Dirdiscamount as Dirdisc48_527_0_, obanalyfac0_.Dirdiscamtnet as Dirdisc49_527_0_, obanalyfac0_.Dirdiscamtreturn as Dirdisc50_527_0_, obanalyfac0_.Conversiondate as Convers51_527_0_, obanalyfac0_.EM_Obretan_Applications_ID as EM52_527_0_, obanalyfac0_.Weeknum as Weeknum527_0_, obanalyfac0_.EM_Obretan_Terminaltype_ID as EM54_527_0_, obanalyfac0_.Yearnum as Yearnum527_0_, obanalyfac0_.Ordertime as Ordertime527_0_, obanalyfac0_.M_Offer_ID as M57_527_0_, obanalyfac0_.City as City527_0_, obanalyfac0_.Postalcode as Postalcode527_0_, obanalyfac0_.Birthdate as Birthdate527_0_, obanalyfac0_.Hournum as Hournum527_0_, obanalyfac0_.Weekday as Weekday527_0_, obanalyfac0_.Monthnum as Monthnum527_0_, obanalyfac0_.C_Costcenter_ID as C64_527_0_ from OBANALY_FACT_SALESORDHEADER obanalyfac0_ where obanalyfac0_.C_Order_ID=$1
2018-09-04 17:44:11 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 DETAIL: parameters: $1 = '4A0DC9BEFD574F76B8BECB9EA52188ED'
2018-09-04 17:44:44 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 LOG: duration: 33280.877 ms execute S_86046: delete from C_Order where C_Order_ID=$1
2018-09-04 17:44:44 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 DETAIL: parameters: $1 = '4A0DC9BEFD574F76B8BECB9EA52188ED'
2018-09-04 17:44:50 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 LOG: duration: 5503.451 ms execute S_85969/C_86396: select obanalyfac0_.C_Order_ID as C9_622_1_, obanalyfac0_.Obanaly_Fact_Salesordheader_ID as Obanaly1_1_, obanalyfac0_.Obanaly_Fact_Salesordheader_ID as Obanaly1_527_0_, obanalyfac0_.AD_Client_ID as AD2_527_0_, obanalyfac0_.AD_Org_ID as AD3_527_0_, obanalyfac0_.Isactive as Isactive527_0_, obanalyfac0_.Created as Created527_0_, obanalyfac0_.Createdby as Createdby527_0_, obanalyfac0_.Updated as Updated527_0_, obanalyfac0_.Updatedby as Updatedby527_0_, obanalyfac0_.C_Order_ID as C9_527_0_, obanalyfac0_.C_Bpartner_ID as C10_527_0_, obanalyfac0_.C_Bp_Group_ID as C11_527_0_, obanalyfac0_.C_Bp_Taxcategory_ID as C12_527_0_, obanalyfac0_.C_Location_ID as C13_527_0_, obanalyfac0_.C_Region_ID as C14_527_0_, obanalyfac0_.C_Country_ID as C15_527_0_, obanalyfac0_.M_Warehouse_ID as M16_527_0_, obanalyfac0_.C_Currency_ID as C17_527_0_, obanalyfac0_.C_Doctype_ID as C18_527_0_, obanalyfac0_.C_Doctypetarget_ID as C19_527_0_, obanalyfac0_.Salesrep_ID as Salesrep20_527_0_, obanalyfac0_.Billto_Location_ID as Billto21_527_0_, obanalyfac0_.C_Invoice_Region_ID as C22_527_0_, obanalyfac0_.C_Invoice_Country_ID as C23_527_0_, obanalyfac0_.Delivery_Location_ID as Delivery24_527_0_, obanalyfac0_.Delivery_Region_ID as Delivery25_527_0_, obanalyfac0_.Delivery_Country_ID as Delivery26_527_0_, obanalyfac0_.C_Paymentterm_ID as C27_527_0_, obanalyfac0_.M_Pricelist_ID as M28_527_0_, obanalyfac0_.FIN_Paymentmethod_ID as FIN29_527_0_, obanalyfac0_.C_Return_Reason_ID as C30_527_0_, obanalyfac0_.Documentno as Documentno527_0_, obanalyfac0_.Orderdate as Orderdate527_0_, obanalyfac0_.Dateordered as Dateord33_527_0_, obanalyfac0_.Datepromised as Datepro34_527_0_, obanalyfac0_.Linecount as Linecount527_0_, obanalyfac0_.Quantity as Quantity527_0_, obanalyfac0_.Qtynet as Qtynet527_0_, obanalyfac0_.Qtyreturned as Qtyretu38_527_0_, obanalyfac0_.Amount as Amount527_0_, obanalyfac0_.Amtnet as Amtnet527_0_, obanalyfac0_.Amtreturn as Amtreturn527_0_, obanalyfac0_.Taxamount as Taxamount527_0_, obanalyfac0_.Taxamtnet as Taxamtnet527_0_, obanalyfac0_.Taxamtreturn as Taxamtr44_527_0_, obanalyfac0_.Discamount as Discamount527_0_, obanalyfac0_.Discamtnet as Discamtnet527_0_, obanalyfac0_.Discamtreturn as Discamt47_527_0_, obanalyfac0_.Dirdiscamount as Dirdisc48_527_0_, obanalyfac0_.Dirdiscamtnet as Dirdisc49_527_0_, obanalyfac0_.Dirdiscamtreturn as Dirdisc50_527_0_, obanalyfac0_.Conversiondate as Convers51_527_0_, obanalyfac0_.EM_Obretan_Applications_ID as EM52_527_0_, obanalyfac0_.Weeknum as Weeknum527_0_, obanalyfac0_.EM_Obretan_Terminaltype_ID as EM54_527_0_, obanalyfac0_.Yearnum as Yearnum527_0_, obanalyfac0_.Ordertime as Ordertime527_0_, obanalyfac0_.M_Offer_ID as M57_527_0_, obanalyfac0_.City as City527_0_, obanalyfac0_.Postalcode as Postalcode527_0_, obanalyfac0_.Birthdate as Birthdate527_0_, obanalyfac0_.Hournum as Hournum527_0_, obanalyfac0_.Weekday as Weekday527_0_, obanalyfac0_.Monthnum as Monthnum527_0_, obanalyfac0_.C_Costcenter_ID as C64_527_0_ from OBANALY_FACT_SALESORDHEADER obanalyfac0_ where obanalyfac0_.C_Order_ID=$1
2018-09-04 17:44:50 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 DETAIL: parameters: $1 = '506F7F447EEB4D04B46DB3BEE21E9692'
2018-09-04 17:45:32 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 LOG: duration: 41653.577 ms execute S_86046: delete from C_Order where C_Order_ID=$1
2018-09-04 17:45:32 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 DETAIL: parameters: $1 = '506F7F447EEB4D04B46DB3BEE21E9692'
2018-09-04 17:45:38 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 LOG: duration: 5733.393 ms execute S_85969/C_86411: select obanalyfac0_.C_Order_ID as C9_622_1_, obanalyfac0_.Obanaly_Fact_Salesordheader_ID as Obanaly1_1_, obanalyfac0_.Obanaly_Fact_Salesordheader_ID as Obanaly1_527_0_, obanalyfac0_.AD_Client_ID as AD2_527_0_, obanalyfac0_.AD_Org_ID as AD3_527_0_, obanalyfac0_.Isactive as Isactive527_0_, obanalyfac0_.Created as Created527_0_, obanalyfac0_.Createdby as Createdby527_0_, obanalyfac0_.Updated as Updated527_0_, obanalyfac0_.Updatedby as Updatedby527_0_, obanalyfac0_.C_Order_ID as C9_527_0_, obanalyfac0_.C_Bpartner_ID as C10_527_0_, obanalyfac0_.C_Bp_Group_ID as C11_527_0_, obanalyfac0_.C_Bp_Taxcategory_ID as C12_527_0_, obanalyfac0_.C_Location_ID as C13_527_0_, obanalyfac0_.C_Region_ID as C14_527_0_, obanalyfac0_.C_Country_ID as C15_527_0_, obanalyfac0_.M_Warehouse_ID as M16_527_0_, obanalyfac0_.C_Currency_ID as C17_527_0_, obanalyfac0_.C_Doctype_ID as C18_527_0_, obanalyfac0_.C_Doctypetarget_ID as C19_527_0_, obanalyfac0_.Salesrep_ID as Salesrep20_527_0_, obanalyfac0_.Billto_Location_ID as Billto21_527_0_, obanalyfac0_.C_Invoice_Region_ID as C22_527_0_, obanalyfac0_.C_Invoice_Country_ID as C23_527_0_, obanalyfac0_.Delivery_Location_ID as Delivery24_527_0_, obanalyfac0_.Delivery_Region_ID as Delivery25_527_0_, obanalyfac0_.Delivery_Country_ID as Delivery26_527_0_, obanalyfac0_.C_Paymentterm_ID as C27_527_0_, obanalyfac0_.M_Pricelist_ID as M28_527_0_, obanalyfac0_.FIN_Paymentmethod_ID as FIN29_527_0_, obanalyfac0_.C_Return_Reason_ID as C30_527_0_, obanalyfac0_.Documentno as Documentno527_0_, obanalyfac0_.Orderdate as Orderdate527_0_, obanalyfac0_.Dateordered as Dateord33_527_0_, obanalyfac0_.Datepromised as Datepro34_527_0_, obanalyfac0_.Linecount as Linecount527_0_, obanalyfac0_.Quantity as Quantity527_0_, obanalyfac0_.Qtynet as Qtynet527_0_, obanalyfac0_.Qtyreturned as Qtyretu38_527_0_, obanalyfac0_.Amount as Amount527_0_, obanalyfac0_.Amtnet as Amtnet527_0_, obanalyfac0_.Amtreturn as Amtreturn527_0_, obanalyfac0_.Taxamount as Taxamount527_0_, obanalyfac0_.Taxamtnet as Taxamtnet527_0_, obanalyfac0_.Taxamtreturn as Taxamtr44_527_0_, obanalyfac0_.Discamount as Discamount527_0_, obanalyfac0_.Discamtnet as Discamtnet527_0_, obanalyfac0_.Discamtreturn as Discamt47_527_0_, obanalyfac0_.Dirdiscamount as Dirdisc48_527_0_, obanalyfac0_.Dirdiscamtnet as Dirdisc49_527_0_, obanalyfac0_.Dirdiscamtreturn as Dirdisc50_527_0_, obanalyfac0_.Conversiondate as Convers51_527_0_, obanalyfac0_.EM_Obretan_Applications_ID as EM52_527_0_, obanalyfac0_.Weeknum as Weeknum527_0_, obanalyfac0_.EM_Obretan_Terminaltype_ID as EM54_527_0_, obanalyfac0_.Yearnum as Yearnum527_0_, obanalyfac0_.Ordertime as Ordertime527_0_, obanalyfac0_.M_Offer_ID as M57_527_0_, obanalyfac0_.City as City527_0_, obanalyfac0_.Postalcode as Postalcode527_0_, obanalyfac0_.Birthdate as Birthdate527_0_, obanalyfac0_.Hournum as Hournum527_0_, obanalyfac0_.Weekday as Weekday527_0_, obanalyfac0_.Monthnum as Monthnum527_0_, obanalyfac0_.C_Costcenter_ID as C64_527_0_ from OBANALY_FACT_SALESORDHEADER obanalyfac0_ where obanalyfac0_.C_Order_ID=$1
2018-09-04 17:45:38 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 DETAIL: parameters: $1 = '271C6B0DECE54B2DA4A5B05576DBFA7F'
2018-09-04 17:46:12 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 LOG: duration: 34612.531 ms execute S_86046: delete from C_Order where C_Order_ID=$1
2018-09-04 17:46:12 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 DETAIL: parameters: $1 = '271C6B0DECE54B2DA4A5B05576DBFA7F'
2018-09-04 17:46:21 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 LOG: duration: 5429.461 ms execute S_85969/C_86419: select obanalyfac0_.C_Order_ID as C9_622_1_, obanalyfac0_.Obanaly_Fact_Salesordheader_ID as Obanaly1_1_, obanalyfac0_.Obanaly_Fact_Salesordheader_ID as Obanaly1_527_0_, obanalyfac0_.AD_Client_ID as AD2_527_0_, obanalyfac0_.AD_Org_ID as AD3_527_0_, obanalyfac0_.Isactive as Isactive527_0_, obanalyfac0_.Created as Created527_0_, obanalyfac0_.Createdby as Createdby527_0_, obanalyfac0_.Updated as Updated527_0_, obanalyfac0_.Updatedby as Updatedby527_0_, obanalyfac0_.C_Order_ID as C9_527_0_, obanalyfac0_.C_Bpartner_ID as C10_527_0_, obanalyfac0_.C_Bp_Group_ID as C11_527_0_, obanalyfac0_.C_Bp_Taxcategory_ID as C12_527_0_, obanalyfac0_.C_Location_ID as C13_527_0_, obanalyfac0_.C_Region_ID as C14_527_0_, obanalyfac0_.C_Country_ID as C15_527_0_, obanalyfac0_.M_Warehouse_ID as M16_527_0_, obanalyfac0_.C_Currency_ID as C17_527_0_, obanalyfac0_.C_Doctype_ID as C18_527_0_, obanalyfac0_.C_Doctypetarget_ID as C19_527_0_, obanalyfac0_.Salesrep_ID as Salesrep20_527_0_, obanalyfac0_.Billto_Location_ID as Billto21_527_0_, obanalyfac0_.C_Invoice_Region_ID as C22_527_0_, obanalyfac0_.C_Invoice_Country_ID as C23_527_0_, obanalyfac0_.Delivery_Location_ID as Delivery24_527_0_, obanalyfac0_.Delivery_Region_ID as Delivery25_527_0_, obanalyfac0_.Delivery_Country_ID as Delivery26_527_0_, obanalyfac0_.C_Paymentterm_ID as C27_527_0_, obanalyfac0_.M_Pricelist_ID as M28_527_0_, obanalyfac0_.FIN_Paymentmethod_ID as FIN29_527_0_, obanalyfac0_.C_Return_Reason_ID as C30_527_0_, obanalyfac0_.Documentno as Documentno527_0_, obanalyfac0_.Orderdate as Orderdate527_0_, obanalyfac0_.Dateordered as Dateord33_527_0_, obanalyfac0_.Datepromised as Datepro34_527_0_, obanalyfac0_.Linecount as Linecount527_0_, obanalyfac0_.Quantity as Quantity527_0_, obanalyfac0_.Qtynet as Qtynet527_0_, obanalyfac0_.Qtyreturned as Qtyretu38_527_0_, obanalyfac0_.Amount as Amount527_0_, obanalyfac0_.Amtnet as Amtnet527_0_, obanalyfac0_.Amtreturn as Amtreturn527_0_, obanalyfac0_.Taxamount as Taxamount527_0_, obanalyfac0_.Taxamtnet as Taxamtnet527_0_, obanalyfac0_.Taxamtreturn as Taxamtr44_527_0_, obanalyfac0_.Discamount as Discamount527_0_, obanalyfac0_.Discamtnet as Discamtnet527_0_, obanalyfac0_.Discamtreturn as Discamt47_527_0_, obanalyfac0_.Dirdiscamount as Dirdisc48_527_0_, obanalyfac0_.Dirdiscamtnet as Dirdisc49_527_0_, obanalyfac0_.Dirdiscamtreturn as Dirdisc50_527_0_, obanalyfac0_.Conversiondate as Convers51_527_0_, obanalyfac0_.EM_Obretan_Applications_ID as EM52_527_0_, obanalyfac0_.Weeknum as Weeknum527_0_, obanalyfac0_.EM_Obretan_Terminaltype_ID as EM54_527_0_, obanalyfac0_.Yearnum as Yearnum527_0_, obanalyfac0_.Ordertime as Ordertime527_0_, obanalyfac0_.M_Offer_ID as M57_527_0_, obanalyfac0_.City as City527_0_, obanalyfac0_.Postalcode as Postalcode527_0_, obanalyfac0_.Birthdate as Birthdate527_0_, obanalyfac0_.Hournum as Hournum527_0_, obanalyfac0_.Weekday as Weekday527_0_, obanalyfac0_.Monthnum as Monthnum527_0_, obanalyfac0_.C_Costcenter_ID as C64_527_0_ from OBANALY_FACT_SALESORDHEADER obanalyfac0_ where obanalyfac0_.C_Order_ID=$1
2018-09-04 17:46:21 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 DETAIL: parameters: $1 = 'E0998765E2804BAB8D5F9B35AEA8F721'
2018-09-04 17:46:54 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 LOG: duration: 32955.617 ms execute S_86046: delete from C_Order where C_Order_ID=$1
2018-09-04 17:46:54 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 DETAIL: parameters: $1 = 'E0998765E2804BAB8D5F9B35AEA8F721'
2018-09-04 17:47:00 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 LOG: duration: 5374.420 ms execute S_85969/C_86427: select obanalyfac0_.C_Order_ID as C9_622_1_, obanalyfac0_.Obanaly_Fact_Salesordheader_ID as Obanaly1_1_, obanalyfac0_.Obanaly_Fact_Salesordheader_ID as Obanaly1_527_0_, obanalyfac0_.AD_Client_ID as AD2_527_0_, obanalyfac0_.AD_Org_ID as AD3_527_0_, obanalyfac0_.Isactive as Isactive527_0_, obanalyfac0_.Created as Created527_0_, obanalyfac0_.Createdby as Createdby527_0_, obanalyfac0_.Updated as Updated527_0_, obanalyfac0_.Updatedby as Updatedby527_0_, obanalyfac0_.C_Order_ID as C9_527_0_, obanalyfac0_.C_Bpartner_ID as C10_527_0_, obanalyfac0_.C_Bp_Group_ID as C11_527_0_, obanalyfac0_.C_Bp_Taxcategory_ID as C12_527_0_, obanalyfac0_.C_Location_ID as C13_527_0_, obanalyfac0_.C_Region_ID as C14_527_0_, obanalyfac0_.C_Country_ID as C15_527_0_, obanalyfac0_.M_Warehouse_ID as M16_527_0_, obanalyfac0_.C_Currency_ID as C17_527_0_, obanalyfac0_.C_Doctype_ID as C18_527_0_, obanalyfac0_.C_Doctypetarget_ID as C19_527_0_, obanalyfac0_.Salesrep_ID as Salesrep20_527_0_, obanalyfac0_.Billto_Location_ID as Billto21_527_0_, obanalyfac0_.C_Invoice_Region_ID as C22_527_0_, obanalyfac0_.C_Invoice_Country_ID as C23_527_0_, obanalyfac0_.Delivery_Location_ID as Delivery24_527_0_, obanalyfac0_.Delivery_Region_ID as Delivery25_527_0_, obanalyfac0_.Delivery_Country_ID as Delivery26_527_0_, obanalyfac0_.C_Paymentterm_ID as C27_527_0_, obanalyfac0_.M_Pricelist_ID as M28_527_0_, obanalyfac0_.FIN_Paymentmethod_ID as FIN29_527_0_, obanalyfac0_.C_Return_Reason_ID as C30_527_0_, obanalyfac0_.Documentno as Documentno527_0_, obanalyfac0_.Orderdate as Orderdate527_0_, obanalyfac0_.Dateordered as Dateord33_527_0_, obanalyfac0_.Datepromised as Datepro34_527_0_, obanalyfac0_.Linecount as Linecount527_0_, obanalyfac0_.Quantity as Quantity527_0_, obanalyfac0_.Qtynet as Qtynet527_0_, obanalyfac0_.Qtyreturned as Qtyretu38_527_0_, obanalyfac0_.Amount as Amount527_0_, obanalyfac0_.Amtnet as Amtnet527_0_, obanalyfac0_.Amtreturn as Amtreturn527_0_, obanalyfac0_.Taxamount as Taxamount527_0_, obanalyfac0_.Taxamtnet as Taxamtnet527_0_, obanalyfac0_.Taxamtreturn as Taxamtr44_527_0_, obanalyfac0_.Discamount as Discamount527_0_, obanalyfac0_.Discamtnet as Discamtnet527_0_, obanalyfac0_.Discamtreturn as Discamt47_527_0_, obanalyfac0_.Dirdiscamount as Dirdisc48_527_0_, obanalyfac0_.Dirdiscamtnet as Dirdisc49_527_0_, obanalyfac0_.Dirdiscamtreturn as Dirdisc50_527_0_, obanalyfac0_.Conversiondate as Convers51_527_0_, obanalyfac0_.EM_Obretan_Applications_ID as EM52_527_0_, obanalyfac0_.Weeknum as Weeknum527_0_, obanalyfac0_.EM_Obretan_Terminaltype_ID as EM54_527_0_, obanalyfac0_.Yearnum as Yearnum527_0_, obanalyfac0_.Ordertime as Ordertime527_0_, obanalyfac0_.M_Offer_ID as M57_527_0_, obanalyfac0_.City as City527_0_, obanalyfac0_.Postalcode as Postalcode527_0_, obanalyfac0_.Birthdate as Birthdate527_0_, obanalyfac0_.Hournum as Hournum527_0_, obanalyfac0_.Weekday as Weekday527_0_, obanalyfac0_.Monthnum as Monthnum527_0_, obanalyfac0_.C_Costcenter_ID as C64_527_0_ from OBANALY_FACT_SALESORDHEADER obanalyfac0_ where obanalyfac0_.C_Order_ID=$1
2018-09-04 17:47:00 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 DETAIL: parameters: $1 = '9884E28A3DA1462CA96872C185BABEDC'
2018-09-04 17:47:19 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 ERROR: canceling statement due to user request
2018-09-04 17:47:19 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 CONTEXT: SQL statement "DELETE FROM ONLY "public"."obanaly_fact_order" WHERE $1::pg_catalog.text OPERATOR(pg_catalog.=) "c_order_id"::pg_catalog.text"
2018-09-04 17:47:19 CDT 2018-09-04 08:46:14 CDT 68807 41/178822 702979439 STATEMENT: delete from C_Order where C_Order_ID=$1
$ grep "41/178822.*duration" postgresql-9.3-main.log-20180904 | sed -E 's#.*duration: (.*) ms execute .*: (select|delete) .*#\2 \1#' | awk '{action[$1]+=$2} END {for (i in action) {print i, action[i]/60000}}'
select 6.05283
delete 44.1608
| |||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||||||||||
|
|||||||||||||||||
 Relationships |
|
Notes |
|
|
(0107156) Sandrahuguet (developer) 2018-10-04 13:11 |
this is no an issue, the real issue is: https://issues.openbravo.com/view.php?id=39329 [^] |
|
(0110034) dmiguelez (developer) 2019-02-22 13:09 |
Having Foreign Keys in Fact tables is not necessary and it makes the insertion of the data slow. Remove the foreign keys for the Fact tables to improve performance. The tables affected are: - From org.openbravo.client.analytics: - obanaly_fact_discounts - obanaly_fact_order - obanaly_fact_salesordheader - From org.openbravo.retail.analytics: - obretan_fact_sessions |
|
(0110077) dmiguelez (developer) 2019-02-26 08:30 |
From org.openbravo.financial.dimensionalpandlreport: - OBDPL_FACT_ACCT_PL |
|
(0110223) dmiguelez (developer) 2019-03-05 11:46 |
Note: Tested in client environment |
|
(0110224) hgbot (developer) 2019-03-05 11:47 |
Repository: erp/devel/pi Changeset: 46a06da3a17ae0b6b8105a4a6bccfe06718ebe16 Author: Atul Gaware <atul.gaware <at> openbravo.com> Date: Fri Mar 01 13:37:14 2019 +0530 URL: http://code.openbravo.com/erp/devel/pi/rev/46a06da3a17ae0b6b8105a4a6bccfe06718ebe16 [^] Related To Issue 39328:Analytics should not have referential integrity with transactional data ** Add tables to white list to avoid fk checks to avoid warnings during export database task obanaly_fact_discounts, obanaly_fact_order, obanaly_fact_salesordheader, obretan_fact_sessions and obdpl_fact_acct_pl ** Added existing ignored table ad_module_install in the white list --- M src/org/openbravo/service/system/DatabaseValidator.java --- |
|
(0110225) hgbot (developer) 2019-03-05 11:47 |
Repository: erp/pmods/org.openbravo.client.analytics Changeset: 34a0b0030a81698ddb2623ef16fe83b8e3284e0b Author: Atul Gaware <atul.gaware <at> openbravo.com> Date: Wed Feb 27 16:40:54 2019 +0530 URL: http://code.openbravo.com/erp/pmods/org.openbravo.client.analytics/rev/34a0b0030a81698ddb2623ef16fe83b8e3284e0b [^] Fixes Issue 0039328: Analytics should not have referential integrity with transactional data **Remove Foriegn Keys from table **OBANALY_FACT_DISCOUNTS.xml **OBANALY_FACT_ORDER **OBANALY_FACT_SALESORHEADER --- M src-db/database/model/tables/OBANALY_FACT_DISCOUNTS.xml M src-db/database/model/tables/OBANALY_FACT_ORDER.xml M src-db/database/model/tables/OBANALY_FACT_SALESORDHEADER.xml --- |
|
(0110226) hgbot (developer) 2019-03-05 11:47 |
Repository: erp/pmods/org.openbravo.financial.dimensionalpandlreport Changeset: bced16249a139de1bcd69ca94a4b0a97744050d7 Author: Atul Gaware <atul.gaware <at> openbravo.com> Date: Wed Feb 27 16:45:43 2019 +0530 URL: http://code.openbravo.com/erp/pmods/org.openbravo.financial.dimensionalpandlreport/rev/bced16249a139de1bcd69ca94a4b0a97744050d7 [^] Fixes Issue 0039328: Analytics should not have referential integrity with transactional data **Remove Foriegn Keys from table OBDPL_FACT_ACCT_PL --- M src-db/database/model/tables/OBDPL_FACT_ACCT_PL.xml --- |
|
(0110227) hgbot (developer) 2019-03-05 11:47 |
Repository: erp/pmods/org.openbravo.retail.analytics Changeset: ddb90b1709774e7892aa11f7638f6fa886ebdea1 Author: Atul Gaware <atul.gaware <at> openbravo.com> Date: Wed Feb 27 16:44:54 2019 +0530 URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.analytics/rev/ddb90b1709774e7892aa11f7638f6fa886ebdea1 [^] Fixes Issue 0039328: Analytics should not have referential integrity with transactional data **Remove Foriegn Keys from table OBRETAN_FACT_SESSIONS **Remove Foriegn Keys from client analytics module tables --- M src-db/database/model/modifiedTables/OBANALY_FACT_DISCOUNTS.xml M src-db/database/model/modifiedTables/OBANALY_FACT_ORDER.xml M src-db/database/model/modifiedTables/OBANALY_FACT_SALESORDHEADER.xml M src-db/database/model/tables/OBRETAN_FACT_SESSIONS.xml --- |
|
(0110228) dmiguelez (developer) 2019-03-05 11:48 |
Code Review + Testing Ok |
|
(0110845) hudsonbot (developer) 2019-03-28 14:56 |
A changeset related to this issue has been promoted main and to the Central Repository, after passing a series of tests. Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/b2fbc1588df4 [^] Maturity status: Test |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2018-09-20 12:42 | JONHM | New Issue | |
| 2018-09-20 12:42 | JONHM | Assigned To | => platform |
| 2018-09-20 12:42 | JONHM | Resolution time | => 1539208800 |
| 2018-09-20 12:47 | JONHM | File Added: factsDB | |
| 2018-09-20 12:58 | JONHM | Relationship added | related to 0039329 |
| 2018-09-21 07:43 | alostale | Assigned To | platform => Triage Finance |
| 2018-10-04 13:11 | Sandrahuguet | Review Assigned To | => Sandrahuguet |
| 2018-10-04 13:11 | Sandrahuguet | Note Added: 0107156 | |
| 2018-10-04 13:11 | Sandrahuguet | Status | new => closed |
| 2018-10-04 13:11 | Sandrahuguet | Resolution | open => no change required |
| 2019-02-22 13:09 | dmiguelez | Note Added: 0110034 | |
| 2019-02-22 13:09 | dmiguelez | Status | closed => new |
| 2019-02-22 13:09 | dmiguelez | Resolution | no change required => open |
| 2019-02-22 13:09 | dmiguelez | Resolution time | 1539208800 => 1552604400 |
| 2019-02-22 13:10 | Sandrahuguet | Assigned To | Triage Finance => AtulOpenbravo |
| 2019-02-26 08:30 | dmiguelez | Note Added: 0110077 | |
| 2019-02-27 12:28 | AtulOpenbravo | Status | new => scheduled |
| 2019-02-28 20:00 | AtulOpenbravo | Relationship added | related to 0040302 |
| 2019-03-05 11:46 | dmiguelez | Note Added: 0110223 | |
| 2019-03-05 11:47 | hgbot | Checkin | |
| 2019-03-05 11:47 | hgbot | Note Added: 0110224 | |
| 2019-03-05 11:47 | hgbot | Checkin | |
| 2019-03-05 11:47 | hgbot | Note Added: 0110225 | |
| 2019-03-05 11:47 | hgbot | Status | scheduled => resolved |
| 2019-03-05 11:47 | hgbot | Resolution | open => fixed |
| 2019-03-05 11:47 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/pmods/org.openbravo.client.analytics/rev/34a0b0030a81698ddb2623ef16fe83b8e3284e0b [^] |
| 2019-03-05 11:47 | hgbot | Checkin | |
| 2019-03-05 11:47 | hgbot | Note Added: 0110226 | |
| 2019-03-05 11:47 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/pmods/org.openbravo.client.analytics/rev/34a0b0030a81698ddb2623ef16fe83b8e3284e0b [^] => http://code.openbravo.com/erp/pmods/org.openbravo.financial.dimensionalpandlreport/rev/bced16249a139de1bcd69ca94a4b0a97744050d7 [^] |
| 2019-03-05 11:47 | hgbot | Checkin | |
| 2019-03-05 11:47 | hgbot | Note Added: 0110227 | |
| 2019-03-05 11:47 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/pmods/org.openbravo.financial.dimensionalpandlreport/rev/bced16249a139de1bcd69ca94a4b0a97744050d7 [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.analytics/rev/ddb90b1709774e7892aa11f7638f6fa886ebdea1 [^] |
| 2019-03-05 11:48 | dmiguelez | Review Assigned To | Sandrahuguet => dmiguelez |
| 2019-03-05 11:48 | dmiguelez | Note Added: 0110228 | |
| 2019-03-05 11:48 | dmiguelez | Status | resolved => closed |
| 2019-03-28 14:56 | hudsonbot | Checkin | |
| 2019-03-28 14:56 | hudsonbot | Note Added: 0110845 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |