8 Replies Latest reply: Dec 29, 2015 12:54 PM by Andre Moreira RSS

    Exception 'GenericOdbcOpException' occurred

    Andre Moreira

      Hi Guys,

       

      Someone already had this issue? Try to load a spreadsheet with hundreds of thousands of records, but QlikView Expressor return the output below:

       

      SQL Server (QA) - OPERATOR-0016-F: toolId 2.0, name 'SQL Server (QA)' - Exception 'GenericOdbcOpException' occurred in the 'process' function for thread 0. (Dataflow1.Step_1)
      SQL Server (QA) - GEN_ODBC_OP-0007-A: Transaction commit failed in Write Table. (Dataflow1.Step_1)
      SQL Server (QA) - OPERATOR-0005-F: toolId 2.0, name 'SQL Server (QA)' - the 'process' function failed for thread 0. (Dataflow1.Step_1)
      SQL Server (QA) - OPERATOR-0081-F: toolId 2.0, name 'SQL Server (QA)' - Exception 'GenericOdbcOpException' occurred in the 'shutdown' function. (Dataflow1.Step_1)
      SQL Server (QA) - GEN_ODBC_OP-0007-A: Transaction commit failed in Write Table. (Dataflow1.Step_1)
      SQL Server (QA) - OPERATOR-0007-F: toolId 2.0, name 'SQL Server (QA)' - the 'shutdown' function failed. (Dataflow1.Step_1)
      SQL Server (QA) - ETOOL-0006-F: operator 2.0, type out-table, name 'SQL Server (QA)': etool failed, phase shutdown. (Dataflow1.Step_1)
      SQL Server (QA) - ETOOL-0017-A: operator 2.0, type out-table - shutdown failed. (Dataflow1.Step_1)
        <status>failed</status>
       </step>
       <statistic>1765.212</statistic>
      </task>
      dataflow controller - ETASK-0038-F: Processing has completed abnormally. (Dataflow1.controller)
      

       

      Currently  I'm  trying to  use  this  article to  discovery the issue:

       

      QlikView Expressor: Tracing an ODBC Connection

       

      []'s

      Andre Moreira