3 Replies Latest reply on Jun 29, 2015 2:36 PM by rareddy

select query without "where" clause gives error -Invalid column types.

prashanthi1 Jun 29, 2015 8:48 AM

Hello,

We have created a VDB by importing Oracle database, and tried to Execute the VDB.

query -> {select * from <TableName> where "cloumnName" = 1234} is giving correct output, but just {select *from <TableName>} is giving error "Invalid column type".

Any reason for this behaviour? Is it because of any restrictions on database or large amount of data being fetched?

Thanks in advance.

Prashanthi.

1. Re: select query without "where" clause gives error -Invalid column types.

van.halbert Jun 29, 2015 8:56 AM (in response to prashanthi1)

Prashanthi,

Can you post the full stack trace?

Van
Actions
2. Re: select query without "where" clause gives error -Invalid column types.

prashanthi1 Jun 29, 2015 12:20 PM (in response to van.halbert)

Hi Van,

Please find the below trace.

org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote org.teiid.core.TeiidProcessingException: TEIID30504 SubmissionUseCaseSourceModel: Unexpected exception while translating results: Invalid column type

Thanks,
Prashanthi.
Actions
3. Re: select query without "where" clause gives error -Invalid column types.

rareddy Jun 29, 2015 2:36 PM (in response to prashanthi1)

Check if it similar situation as here https://developer.jboss.org/message/934879?et=watches.email.thread#934879
Actions

Go to original post