Error on Output columns

I got a weard situation going on when I go to Output columns on a complex query I get the flowing error: 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>A BIRT exception occurred.
Plug-in Provider:Eclipse.org
Plug-in Name:BIRT Data Engine
Plug-in ID:org.eclipse.birt.data
Version:2.6.1.v20100915
Error Code:odaconsumer.CannotOpenConnection
Error Message:Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc.
org.eclipse.birt.report.data.oda.jdbc.JDBCException: There is an error in get connection, I/O-uitzondering: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=169869824)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4)))).</pre>
 
But if I go to preview results the query works just fine. Becouse it go's wrong on output comlumns I can not create a table based on the query (it does not show the output columns). 
 
Any idea on how to fix this?

Find more posts tagged with

Comments

thuston

Something is breaking the MetaData Collection and translation to BIRT types.

When you preview, do all the columns have normal alpha-numeric names?

You should be able to narrow it down to an issue with a specific part of the query.
Reduce the columns returned in your query to a single simple one.
Then add them back a few at a time until it breaks.