1 Reply Latest reply on Aug 23, 2011 12:25 PM by Steven Hawkins

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

    Rakesh Balguri Expert

      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.