In my translator I added the following
public boolean supportsAggregatesCountStar()
This should support the count star in the SQL.
When I execute the following query against teiid, I am getting the error Error Code:ERR.003.029.0021 Message:Invalid integer format in String:
select count(*) from DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AX where AX.dsConf='DEFAULT' and AX.dsGroup='DA0G' and AX.dsSystem='' and AX.dsSSID=''
[PROCESSOR] Processing exception 'Error Code:ERR.003.029.0021 Message:Invalid integer format in String: ' for request +HAyc7r6Pu/V.0. Exception type org.teiid.core.types.TransformationException thrown from org.teiid.core.types.basic.StringToIntegerTransform.transformDirect(StringToIntegerTransform.java:43). Enable more detailed logging to see the entire stacktrace.
The exception message is indicating that one of the blank strings (in the dsSystem and dsSSID equality predicates) is being converted to an integer value. You probably want 0 instead of a blank string, or one of the types is wrong.