Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
query called multiple times
Migrateduser
Hi all,<br />
<br />
I have suddenly noticed that when I have a query that contains an error in runs 46 times.<br />
and each time it returns with the same error message.<br />
<br />
The reason that I noticed it is that in some cases that cause the connection to my DB to drop and therefor I can't display any part of my report.<br />
<br />
I'm using birt 4.2.1 and Postgresql 9.1<br />
<br />
When I'm running the report I see this error message in the Postgresql log file:<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
2013-03-24 17:01:48 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:01:48 IST STATEMENT: select age1 from test1
2013-03-24 17:01:48 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:01:48 IST STATEMENT: select age1 from test1
2013-03-24 17:01:48 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:01:48 IST STATEMENT: select age1 from test1
2013-03-24 17:01:48 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:01:48 IST STATEMENT: select age1 from test1
2013-03-24 17:01:48 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:01:48 IST STATEMENT: select age1 from test1
2013-03-24 17:01:48 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:01:48 IST STATEMENT: select age1 from test1
2013-03-24 17:01:48 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:01:48 IST STATEMENT: select age1 from test1
2013-03-24 17:01:48 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:01:48 IST STATEMENT: select age1 from test1
2013-03-24 17:01:48 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:01:48 IST STATEMENT: select age1 from test1
2013-03-24 17:01:48 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:01:48 IST STATEMENT: select age1 from test1
2013-03-24 17:01:48 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:01:48 IST STATEMENT: select age1 from test1
2013-03-24 17:01:48 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:01:48 IST STATEMENT: select age1 from test1
2013-03-24 17:01:48 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:01:48 IST STATEMENT: select age1 from test1
2013-03-24 17:01:48 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:01:48 IST STATEMENT: select age1 from test1
2013-03-24 17:01:48 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:01:48 IST STATEMENT: select age1 from test1
2013-03-24 17:01:48 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:01:48 IST STATEMENT: select age1 from test1
2013-03-24 17:02:06 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:06 IST STATEMENT: select age1 from test1
2013-03-24 17:02:06 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:06 IST STATEMENT: select age1 from test1
2013-03-24 17:02:06 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:06 IST STATEMENT: select age1 from test1
2013-03-24 17:02:06 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:06 IST STATEMENT: select age1 from test1
2013-03-24 17:02:06 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:06 IST STATEMENT: select age1 from test1
2013-03-24 17:02:06 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:06 IST STATEMENT: select age1 from test1
2013-03-24 17:02:06 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:06 IST STATEMENT: select age1 from test1
2013-03-24 17:02:06 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:06 IST STATEMENT: select age1 from test1
2013-03-24 17:02:06 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:06 IST STATEMENT: select age1 from test1
2013-03-24 17:02:06 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:06 IST STATEMENT: select age1 from test1
2013-03-24 17:02:06 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:06 IST STATEMENT: select age1 from test1
2013-03-24 17:02:06 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:06 IST STATEMENT: select age1 from test1
2013-03-24 17:02:06 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:06 IST STATEMENT: select age1 from test1
2013-03-24 17:02:06 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:06 IST STATEMENT: select age1 from test1
2013-03-24 17:02:06 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:06 IST STATEMENT: select age1 from test1
2013-03-24 17:02:06 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:06 IST STATEMENT: select age1 from test1
2013-03-24 17:02:08 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:08 IST STATEMENT: select age1 from test1
2013-03-24 17:02:08 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:08 IST STATEMENT: select age1 from test1
2013-03-24 17:02:08 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:08 IST STATEMENT: select age1 from test1
2013-03-24 17:02:08 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:08 IST STATEMENT: select age1 from test1
2013-03-24 17:02:08 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:08 IST STATEMENT: select age1 from test1
2013-03-24 17:02:08 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:08 IST STATEMENT: select age1 from test1
2013-03-24 17:02:34 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:34 IST STATEMENT: select age1 from test1
2013-03-24 17:02:34 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:34 IST STATEMENT: select age1 from test1
2013-03-24 17:02:34 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:34 IST STATEMENT: select age1 from test1
2013-03-24 17:02:34 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:34 IST STATEMENT: select age1 from test1
2013-03-24 17:02:34 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:34 IST STATEMENT: select age1 from test1
2013-03-24 17:02:34 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:34 IST STATEMENT: select age1 from test1
2013-03-24 17:02:34 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:34 IST STATEMENT: select age1 from test1
2013-03-24 17:02:34 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:34 IST STATEMENT: select age1 from test1
2013-03-24 17:02:34 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:34 IST STATEMENT: select age1 from test1
2013-03-24 17:02:34 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:34 IST STATEMENT: select age1 from test1
2013-03-24 17:02:35 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:35 IST STATEMENT: select age1 from test1
2013-03-24 17:02:35 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:35 IST STATEMENT: select age1 from test1
2013-03-24 17:02:35 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:35 IST STATEMENT: select age1 from test1
2013-03-24 17:02:35 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:35 IST STATEMENT: select age1 from test1
2013-03-24 17:02:35 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:35 IST STATEMENT: select age1 from test1
2013-03-24 17:02:35 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:35 IST STATEMENT: select age1 from test1
2013-03-24 17:02:37 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:37 IST STATEMENT: select age1 from test1
2013-03-24 17:02:37 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:37 IST STATEMENT: select age1 from test1
2013-03-24 17:02:37 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:37 IST STATEMENT: select age1 from test1
2013-03-24 17:02:37 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:37 IST STATEMENT: select age1 from test1
2013-03-24 17:02:37 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:37 IST STATEMENT: select age1 from test1
2013-03-24 17:02:37 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:37 IST STATEMENT: select age1 from test1
2013-03-24 17:02:38 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:38 IST STATEMENT: select age1 from test1
2013-03-24 17:02:38 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:38 IST STATEMENT: select age1 from test1
2013-03-24 17:02:38 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:38 IST STATEMENT: select age1 from test1
2013-03-24 17:02:38 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:38 IST STATEMENT: select age1 from test1
2013-03-24 17:02:38 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:38 IST STATEMENT: select age1 from test1
2013-03-24 17:02:38 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:38 IST STATEMENT: select age1 from test1
2013-03-24 17:02:46 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:46 IST STATEMENT: select age1 from test1
2013-03-24 17:02:46 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:46 IST STATEMENT: select age1 from test1
2013-03-24 17:02:46 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:46 IST STATEMENT: select age1 from test1
2013-03-24 17:02:46 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:46 IST STATEMENT: select age1 from test1
2013-03-24 17:02:46 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:46 IST STATEMENT: select age1 from test1
2013-03-24 17:02:46 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:46 IST STATEMENT: select age1 from test1
2013-03-24 17:02:46 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:46 IST STATEMENT: select age1 from test1
2013-03-24 17:02:46 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:46 IST STATEMENT: select age1 from test1
2013-03-24 17:02:46 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:46 IST STATEMENT: select age1 from test1
2013-03-24 17:02:46 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:46 IST STATEMENT: select age1 from test1
2013-03-24 17:02:46 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:46 IST STATEMENT: select age1 from test1
2013-03-24 17:02:46 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:46 IST STATEMENT: select age1 from test1
2013-03-24 17:02:47 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:47 IST STATEMENT: select age1 from test1
2013-03-24 17:02:47 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:47 IST STATEMENT: select age1 from test1
2013-03-24 17:02:47 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:47 IST STATEMENT: select age1 from test1
2013-03-24 17:02:47 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:47 IST STATEMENT: select age1 from test1
2013-03-24 17:02:47 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:47 IST STATEMENT: select age1 from test1
2013-03-24 17:02:47 IST ERROR: column "age1" does not exist at character 8
2013-03-24 17:02:47 IST STATEMENT: select age1 from test1
</pre>
<br />
This is the message that I got when the connection to the DB was drooped.<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
IST FATAL: sorry, too many clients already
</pre>
<br />
And finally this is the query that I used (<strong class='bbc'>I know that it's <span class='bbc_underline'>incorrect</span></strong>, but I'm using it to show that birt tries to call it many time and gets the same error message).<br />
<strong class='bbc'>Query:</strong><br />
<pre class='_prettyXprint _lang-auto _linenums:0'>select age1 from test1</pre>
<br />
Please help me to figer out how can I fix this issue so that I will not have issue with drooping the connection to the DB when I have an error in one of my SQL queries.<br />
<br />
Thanks, Shlomi
Find more posts tagged with
Comments
There are no comments yet