2 Replies Latest reply: Nov 12, 2012 1:31 AM by MOHAMMED IRFAN GHOURI PERVEZ RSS

    Run time exception when trying to load .qvx file data into sql server db

      Hi all,

       

       

      Run time exception when trying to load .qvx file data into sql server DB

       

      Table Structur in SQL Server DB

      q1.JPG

       

      Dataflow:
      q2.JPG

       

      Schema:

      q.JPG

       

       

      Exception:

       

      dataflow controller - ETASK-0017-N: Using Desktop license for QlikView Expressor Processor; resource utilization limited. (etask.controller)

      expressor dataflow execution utility (etask) 3.8.0.23255 n (Build 23255) Oct 13 2012

      <task dataflow="QVX_DB_Flow">

      <!-- project.home[(null)], project[..] -->

      <step id="0" step_name="Step_1" process="4264" run="0" status="ok" start="2012-11-11T11:29:19">

      Write Table 1 - OPERATOR-0037-S: The connection parameter 'schemaOverride' is not set. (QVX_DB_Flow.Step_1)

      Write Table 1 - OPERATOR-0037-S: The connection parameter 'uid' is not set. (QVX_DB_Flow.Step_1)

      Write Table 1 - OPERATOR-0037-S: The connection parameter 'pwd' is not set. (QVX_DB_Flow.Step_1)

      SQLSTATE:[01000], Code:[5701], Msg:[QVExpressor][ODBC SQL Server Wire Protocol driver][Microsoft SQL Server]Changed database context to 'irf'.

      SQLSTATE:[01000], Code:[5703], Msg:[QVExpressor][ODBC SQL Server Wire Protocol driver][Microsoft SQL Server]Changed language setting to us_english.

       

       

      Write Table 1 - OPERATOR-0050-F: toolId 2.0, name 'Write Table 1' - Exception 'OutTableGenericOdbcOpException' occurred in the 'initialize' function. (QVX_DB_Flow.Step_1)

      Write Table 1 - GEN_ODBC_OP-0023-A: Operator cannot find specified table 'CompositeType1', please verify that it exists in the database. (QVX_DB_Flow.Step_1)

      Write Table 1 - OPERATOR-0003-F: toolId 2.0, name 'Write Table 1' - the 'initialize' function failed. (QVX_DB_Flow.Step_1)

      Write Table 1 - ETOOL-0006-F: operator 2.0, type out-table, name 'Write Table 1': etool failed, phase runInitialize. (QVX_DB_Flow.Step_1)

      Write Table 1 - ETOOL-0016-A: operator 2.0, type out-table, pid 6236 - initialize() failed. (QVX_DB_Flow.Step_1)

      dataflow controller - ETASK-0079-F: Operator 'Write Table 1' has terminated unexpectedly. ID=2, status=starting (11), type='out-table', name='out-table'. (QVX_DB_Flow.controller)

        <status>failed</status>

      </step>

      <statistic>1.686</statistic>

      </task>

      dataflow controller - ETASK-0038-F: Processing has completed abnormally. (QVX_DB_Flow.controller)

       

       

      please help me out to sort the issue.