Error Code:ERR.003.029.0021 Message:Invalid integer format in String:

[rakeshsagar]

Hi all,

In my translator I added the following

    public boolean supportsAggregatesCountStar()

    {

        return true;

    }

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.

Thanks

Rakesh.

[shawkins]

Hi Rakesh,

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.

Steve