Numeric overflow Error while executing count(*) on VDB

[adi22]

org.teiid.jdbc.TeiidSQLException: TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 SrcModel_2: JZ00B Unexpected exception while translating results: JZ00B: Numeric overflow.

        at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:131)

        at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:67)

        at org.teiid.jdbc.StatementImpl.postReceiveResults(StatementImpl.java:743)

        at org.teiid.jdbc.StatementImpl.access$100(StatementImpl.java:61)

        at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:557)

        at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:131)

        at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:36)

        at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:75)

        at org.teiid.net.socket.SocketServerInstanceImpl.receivedMessage(SocketServerInstanceImpl.java:281)

        at org.teiid.net.socket.SocketServerInstanceImpl.read(SocketServerInstanceImpl.java:333)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

        at java.lang.reflect.Method.invoke(Method.java:498)

        at org.teiid.net.socket.SocketServerConnectionFactory$ShutdownHandler.invoke(SocketServerConnectionFactory.java:94)

        at com.sun.proxy.$Proxy1.read(Unknown Source)

        at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.get(SocketServerInstanceImpl.java:423)

        at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:566)

        at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:419)

        at org.teiid.jdbc.StatementImpl.executeQuery(StatementImpl.java:350)

        at JDBCClient.execute(JDBCClient.java:76)

        at JDBCClient.main(JDBCClient.java:43)

[van.halbert]

Aditi,

Can you post the full stacktrace from the server?   Seeing "JZ00B" in the message suggest that this is a message coming from the data source, because this isn't verbiage in a Teiid exception.

Thanks.

Van

[shawkins]

We'll need to see the associated source query as well.  You are for example able to overflow the count aggregate as it's a 32 bit signed integer.

Steve

[adi22]

How to enable full stack trace from the server?

-Aditi

[shawkins]

> How to enable full stack trace from the server?

An exception like this should create a warning entry in the server log unless you have adjusted the logging levels.  Can you check the server log?