Project:
| View Revisions: Issue #48748 | [ Back to Issue ] | ||
| Summary | 0048748: Open database connections are left open when printing reports (post upgrade from 18Q3 to 21Q2.3) | ||
| Revision | 2022-03-08 19:12 by ivazquez | ||
| Description | The process definition "Print National Invoices" prints invoices applying some filters, this report is a report containing two images. One is obtained from the form: org.openbravo.erpCommon.utility.Utility.showImageLogo("yourcompanylegal", $F{organizationid}) and the other of the form: org.openbravo.erpCommon.utility.Utility.showImage($F{org_invoice_image}). Each time the report is called, two connections remain open until postgres finally blocks the connections from reaching the maximum. Connections that remain open: a) select adimage0_.AD_Image_ID as AD_Image1_48_0_, adimage0_.AD_Client_ID as AD_Clien2_48_0_, adimage0_.AD_Org_ID as AD_Org_I3_48_0_, adimage0_.IsActive as IsActive4_48_0_, adimage0_.Created as Created5_48_0_, adimage0_.CreatedBy as CreatedB6_48_0_, adimage0_.Updated as Updated7_48_0_, adimage0_.UpdatedBy as UpdatedB8_48_0_, adimage0_.Name as Name9_48_0_, adimage0_.ImageURL as ImageUR10_48_0_, adimage0_.BinaryData as BinaryD11_48_0_, adimage0_.Width as Width12_48_0_, adimage0_.Height as Height13_48_0_, adimage0_.Mimetype as Mimetyp14_48_0_ from AD_Image adimage0_ where adimage0_.AD_Image_ID=$1 b) select adimage0_.AD_Image_ID as AD_Image1_48_0_, adimage0_.AD_Client_ID as AD_Clien2_48_0_, adimage0_.AD_Org_ID as AD_Org_I3_48_0_, adimage0_.IsActive as IsActive4_48_0_, adimage0_.Created as Created5_48_0_, adimage0_.CreatedBy as CreatedB6_48_0_, adimage0_.Updated as Updated7_48_0_, adimage0_.UpdatedBy as UpdatedB8_48_0_, adimage0_.Name as Name9_48_0_, adimage0_.ImageURL as ImageUR10_48_0_, adimage0_.BinaryData as BinaryD11_48_0_, adimage0_.Width as Width12_48_0_, adimage0_.Height as Height13_48_0_, adimage0_.Mimetype as Mimetyp14_48_0_ from AD_Image adimage0_ where adimage0_.AD_Image_ID in ($1, $2) This error has also been occurring since the customer upgraded from 18Q3 to 21Q2.3. -Attached images: 1.- The process definition that the customer uses to print invoices 3.- The definition of a process definition in the Application Dictionary 4.- How the connections look like after 3 runs of the invoice printing (each run opens two new connections) |
||
| Revision | 2022-03-08 19:11 by ivazquez | ||
| Description | The process definition "Print National Invoices" prints invoices applying some filters, this report is a report containing two images. One is obtained from the form: org.openbravo.erpCommon.utility.Utility.showImageLogo("yourcompanylegal", $F{organizationid}) and the other of the form: org.openbravo.erpCommon.utility.Utility.showImage($F{org_invoice_image}). Each time the report is called, two connections remain open until postgres finally blocks the connections from reaching the maximum. Connections that remain open: a) select adimage0_.AD_Image_ID as AD_Image1_48_0_, adimage0_.AD_Client_ID as AD_Clien2_48_0_, adimage0_.AD_Org_ID as AD_Org_I3_48_0_, adimage0_.IsActive as IsActive4_48_0_, adimage0_.Created as Created5_48_0_, adimage0_.CreatedBy as CreatedB6_48_0_, adimage0_.Updated as Updated7_48_0_, adimage0_.UpdatedBy as UpdatedB8_48_0_, adimage0_.Name as Name9_48_0_, adimage0_.ImageURL as ImageUR10_48_0_, adimage0_.BinaryData as BinaryD11_48_0_, adimage0_.Width as Width12_48_0_, adimage0_.Height as Height13_48_0_, adimage0_.Mimetype as Mimetyp14_48_0_ from AD_Image adimage0_ where adimage0_.AD_Image_ID=$1 b) select adimage0_.AD_Image_ID as AD_Image1_48_0_, adimage0_.AD_Client_ID as AD_Clien2_48_0_, adimage0_.AD_Org_ID as AD_Org_I3_48_0_, adimage0_.IsActive as IsActive4_48_0_, adimage0_.Created as Created5_48_0_, adimage0_.CreatedBy as CreatedB6_48_0_, adimage0_.Updated as Updated7_48_0_, adimage0_.UpdatedBy as UpdatedB8_48_0_, adimage0_.Name as Name9_48_0_, adimage0_.ImageURL as ImageUR10_48_0_, adimage0_.BinaryData as BinaryD11_48_0_, adimage0_.Width as Width12_48_0_, adimage0_.Height as Height13_48_0_, adimage0_.Mimetype as Mimetyp14_48_0_ from AD_Image adimage0_ where adimage0_.AD_Image_ID in ($1, $2) This error has also been occurring since the customer upgraded from 18Q3 to 21Q2.3. -Attached images: 1.- The process definition that the customer uses to print invoices 2.- The resulting report that has 2 images 3.- The definition of a process definition in the Application Dictionary 4.- How the connections look like after 3 runs of the invoice printing (each run opens two new connections) |
||
| Copyright © 2000 - 2009 MantisBT Group |
 |