Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1aQuwC-00061D-S2 for pgsql-admin@arkaria.postgresql.org; Wed, 03 Feb 2016 10:45:28 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1aQuwC-0007sm-Ac for pgsql-admin@arkaria.postgresql.org; Wed, 03 Feb 2016 10:45:28 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1aQuwB-0007sa-Oe for pgsql-admin@postgresql.org; Wed, 03 Feb 2016 10:45:27 +0000 Received: from smtp74.iad3a.emailsrvr.com ([173.203.187.74]) by magus.postgresql.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1aQuvw-00027w-O7 for pgsql-admin@postgresql.org; Wed, 03 Feb 2016 10:45:27 +0000 Received: from smtp26.relay.iad3a.emailsrvr.com (localhost.localdomain [127.0.0.1]) by smtp26.relay.iad3a.emailsrvr.com (SMTP Server) with ESMTP id 20BBC80197; Wed, 3 Feb 2016 05:45:10 -0500 (EST) X-SMTPDoctor-Processed: csmtpprox beta Received: from smtp26.relay.iad3a.emailsrvr.com (localhost.localdomain [127.0.0.1]) by smtp26.relay.iad3a.emailsrvr.com (SMTP Server) with ESMTP id 1D9B280231; Wed, 3 Feb 2016 05:45:10 -0500 (EST) Received: from app43.wa-webapps.iad3a (relay-webapps.rsapps.net [172.27.255.140]) by smtp26.relay.iad3a.emailsrvr.com (SMTP Server) with ESMTP id 15B6880197; Wed, 3 Feb 2016 05:45:10 -0500 (EST) X-Sender-Id: clingareddy@vsoftcorp.com Received: from app43.wa-webapps.iad3a (relay-webapps.rsapps.net [172.27.255.140]) by 0.0.0.0:25 (trex/5.5.4); Wed, 03 Feb 2016 05:45:10 -0500 Received: from vsoftcorp.com (localhost.localdomain [127.0.0.1]) by app43.wa-webapps.iad3a (Postfix) with ESMTP id 0831A380048; Wed, 3 Feb 2016 05:45:10 -0500 (EST) Received: by apps.rackspace.com (Authenticated sender: clingareddy@vsoftcorp.com, from: clingareddy@vsoftcorp.com) with HTTP; Wed, 3 Feb 2016 16:15:10 +0530 (IST) Date: Wed, 3 Feb 2016 16:15:10 +0530 (IST) Subject: =?utf-8?Q?invalid_memory_alloc_request_size_18446744073709551614=0A?= From: clingareddy@vsoftcorp.com To: pgsql-admin@postgresql.org Cc: "Chandra Kiran Lingareddy" MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_20160203161510000000_67417" Importance: Normal X-Priority: 3 (Normal) X-Type: html X-Auth-ID: clingareddy@vsoftcorp.com Message-ID: <1454496310.031717503@apps.rackspace.com> X-Mailer: webmail/12.0.0-RC X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org ------=_20160203161510000000_67417 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi Team, While running a Query in PostgreSQL i am getting below error. Query: SELECT count(1) ,SUM (DECODE(cr_ind, 'Y', NVL(numeric_amt, 0), 0)) cr_amt,= SUM (DECODE(cr_ind, 'Y', 0, NVL(numeric_amt, 0))) db_amt , sum(decode(cr_i= nd, 'Y', 1, 0)) cr_cnt, sum(decode(cr_ind, 'Y', 0, 1)) db_cnt FROM ITEM_20= 15_1 a WHERE a.NUMERIC_AMT =3D 13066.00 and NVL(a.FLD_6_NUM,0) =3D 000014 = and a.BUS_DATE =3D to_date('11212015','mmddyyyy') AND EXISTS (SELECT 1 = FROM batch_master b WHERE a.BUS_DATE =3D b..BUS_DATE AND a.JOB_ID =3D b.JOB= _ID AND a.BLK_NUM =3D b.BLK_NUM AND a.BCH_NUM =3D b.BCH_NUM ) Error: invalid memory alloc request size 18446744073709551614 Severity: ERROR Code: XX000 Thanks, Chandra kiran. Please do not print this email unless it is absolutely necessary. This email and any files transmitted with it are confidential and intended = solely for the use of the individual or entity to which they are addressed.= If you are not the intended recipient, you should not disseminate, distrib= ute or copy this e-mail. Please notify the sender immediately by e-mail and= destroy all copies of this message and any attachments. Any views or opini= ons presented in this email are solely those of the author and do not neces= sarily represent those of the company. Warning: Although the company has taken reasonable precautions to ensure no= viruses are present in this email, the company cannot accept responsibilit= y for any loss or damage arising from the use of this email or attachments. ------=_20160203161510000000_67417 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

Hi Team,

 

While running a Query in PostgreSQL i am getting below e= rror. 

 

 

Query:

 

 

SELECT count(1) &nb= sp;,SUM (DECODE(cr_ind, 'Y', NVL(numeric_amt, 0), 0)) cr_amt, SUM (DECODE(c= r_ind, 'Y', 0, NVL(numeric_amt, 0))) db_amt , sum(decode(cr_ind, 'Y', 1, 0)= ) cr_cnt, sum(decode(cr_ind, 'Y', 0, 1)) db_cnt  FROM ITEM_2015_1 a &n= bsp;WHERE a.NUMERIC_AMT =3D 13066.00 and NVL(a.FLD_6_NUM,0) =3D 000014 and =  a.BUS_DATE  =3D  to_date('11212015','mmddyyyy')  AND E= XISTS (SELECT 1 FROM batch_master b WHERE a.BUS_DATE =3D b.BUS_DATE AND a.J= OB_ID =3D b.JOB_ID AND a.BLK_NUM =3D b.BLK_NUM AND a.BCH_NUM =3D b.BCH_NUM = )

 

 

Error:

 

invalid memory alloc request size 18446744073709551614Severity: ERROR
Code: XX000

 

 

Thanks,

Chandra kiran.

 Please do not print this email unless it is absolutely necessary. This email and any files transmitted with it are confidential and intended = solely for the use of the individual or entity to which they are addressed.= If you are not the intended recipient, you should not disseminate, distrib= ute or copy this e-mail. Please notify the sender immediately by e-mail and= destroy all copies of this message and any attachments. Any views or opini= ons presented in this email are solely those of the author and do not neces= sarily represent those of the company. Warning: Although the company has taken reasonable precautions to ensure no= viruses are present in this email, the company cannot accept responsibilit= y for any loss or damage arising from the use of this email or attachments. ------=_20160203161510000000_67417--