2017-10-30 07:37:58 EDT [21531]: [19977-1] db=openbravo,user=tad,app=[unknown],client=127.0.0.1 LOG:  duration: 137701.434 ms  execute <unnamed>:       SELECT COALESCE(SUM(AMTACCTDR),0) AS TOTALACCTDR, COALESCE(SUM(AMTACCTCR),0) AS TOTALACCTCR,      COALESCE(SUM(AMTACCTDR-AMTACCTCR),0) AS TOTAL      FROM FACT_ACCT      WHERE 1=1  AND FACT_ACCT.C_ACCTSCHEMA_ID = $1        AND FACT_ACCT.ACCOUNT_ID = $2      AND DATEACCT < TO_DATE($3)      AND FACT_ACCT.AD_ORG_ID IN ('E168567EAFF94B4793996B0AB415930B','C002170F73544C6E9AAEC8DD7FBB5750','AA6E6D54ACC94E3DA142B1CA42C332E6','9F488865B7FF4341938EBA9D94204795','664FFE8B17974ABCBE4215D77996BB16','61D784C8E7B24C61864CAAC67AC3554F','33DD7E752F9E4370AAE84B7B6B1EA5AD','2A85B2F756EA492897FA0C5061D35C04','24D0809B7ACB4BEEBFD742E6D3BF1004','0A733B3F5292414BA2310836A3EE9B73')
2017-10-30 07:37:58 EDT [21531]: [19978-1] db=openbravo,user=tad,app=[unknown],client=127.0.0.1 DETAIL:  parameters: $1 = '27686AACFDAB4E7E95F23F75BA26D9DE', $2 = '94A48FFC2FE744A6A107FAC6069A159D', $3 = '09-01-2017'



2017-10-30 07:40:19 EDT [21531]: [19981-1] db=openbravo,user=tad,app=[unknown],client=127.0.0.1 LOG:  duration: 141435.570 ms  execute <unnamed>:       SELECT COALESCE(SUM(AMTACCTDR),0) AS TOTALACCTDR, COALESCE(SUM(AMTACCTCR),0) AS TOTALACCTCR,      COALESCE(SUM(AMTACCTDR-AMTACCTCR),0) AS TOTAL      FROM FACT_ACCT      WHERE 1=1  AND FACT_ACCT.C_ACCTSCHEMA_ID = $1        AND FACT_ACCT.ACCOUNT_ID = $2      AND DATEACCT < TO_DATE($3)      AND FACT_ACCT.AD_ORG_ID IN ('E168567EAFF94B4793996B0AB415930B','C002170F73544C6E9AAEC8DD7FBB5750','AA6E6D54ACC94E3DA142B1CA42C332E6','9F488865B7FF4341938EBA9D94204795','664FFE8B17974ABCBE4215D77996BB16','61D784C8E7B24C61864CAAC67AC3554F','33DD7E752F9E4370AAE84B7B6B1EA5AD','2A85B2F756EA492897FA0C5061D35C04','24D0809B7ACB4BEEBFD742E6D3BF1004','0A733B3F5292414BA2310836A3EE9B73')
2017-10-30 07:40:19 EDT [21531]: [19982-1] db=openbravo,user=tad,app=[unknown],client=127.0.0.1 DETAIL:  parameters: $1 = '27686AACFDAB4E7E95F23F75BA26D9DE', $2 = '94A48FFC2FE744A6A107FAC6069A159D', $3 = '10-02-2017'