4 Replies Latest reply on Jun 7, 2015 11:59 AM by chris.schultz

    Unable to create extract beacuse of following error [NCR][ODBC Teradata Driver][Teradata Database] Insufficient memory to parse this request, during QueryRewrite phase.

    Rishiraj Abhange

      I am connecting Teradata to Tableau and running a custom sql in Tableau.

      A complex view is created in Teradata and I am selecting some columns from the same.

      The query is running fine & there is no performance issue in Teradata. But when I am trying to run the same query in Tableau, it is popping the following error while executing:

       

      [NCR][ODBC Teradata Driver][Teradata Database] Insufficient memory to parse this request, during QueryRewrite phase

      Unable to create extract

      [NCR][ODBC Teradata Driver][Teradata Database] Insufficient memory to parse this request, during QueryRewrite phase


      Also, When I check the logs, I am finding the following details:

       

      ODBCProtocolImpl::ReadMetadataImpl: Warning: Unable to read metadata using SQLPrepare.

      2013-12-17 23:40:23.453 (-,-,-,-) 4bdd8: --- ODBC Error -------------------------------------------------------------

      2013-12-17 23:40:23.453 (-,-,-,-) 4bdd8: File:         db\ODBCProtocolImpl.cpp, Line: 2742

      2013-12-17 23:40:23.453 (-,-,-,-) 4bdd8: Error Code:   -1 (SQL_ERROR)

      2013-12-17 23:40:23.453 (-,-,-,-) 4bdd8: -------------

      2013-12-17 23:40:23.453 (-,-,-,-) 4bdd8: Error Record: 1

      2013-12-17 23:40:23.453 (-,-,-,-) 4bdd8: Description:  '[Teradata][ODBC Teradata Driver][Teradata Database] Insufficient memory to parse this request, during QueryRewrite phase. '

      2013-12-17 23:40:23.453 (-,-,-,-) 4bdd8: SQLState:     HY001 (SQLSTATE_API_MEMORY_ALLOCATION_ERROR)

      2013-12-17 23:40:23.453 (-,-,-,-) 4bdd8: Native Error: -3710

      2013-12-17 23:40:23.453 (-,-,-,-) 4bdd8: ----------------------------------------------------------------------------

      2013-12-17 23:40:23.453 (-,-,-,-) 4bdd8:

      2013-12-17 23:40:23.454 (-,-,-,-) 4bdd8: ODBCProtocolImpl::ReadMetadataImpl: SQLPrepare failed. Reading metadata using an executed query.

      2013-12-17 23:40:52.816 (-,-,-,-) 4bdd8: ODBCProtocolImpl::ReadMetadataImpl: Error: Unable to read metadata from query results.

      2013-12-17 23:40:52.816 (-,-,-,-) 4bdd8: --- ODBC Error -------------------------------------------------------------

      2013-12-17 23:40:52.816 (-,-,-,-) 4bdd8: File:         db\ODBCProtocolImpl.cpp, Line: 2761

       

      Can anybody please highlight me on this issue?

       

      Thanks!