Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
mightyqlikers
Creator III
Creator III

Qlikview Expressor Error

Dear Qlikers,

Please find the below error while writing data from qvd to oracle table.

Compile Succeeded!

Executable: etask.exe

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

QlikView Expressor dataflow execution utility (etask) 3.12.0.27638 n (Build 27638) Apr 15 2014

<task dataflow="Dataflow2">

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

<step id="0" step_name="Step_1" process="5200" run="0" status="ok" start="2015-08-05T14:11:40">

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

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

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

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

Write Table 1 - ETOOL-0016-A: operator 2.0, type out-table, pid 9460 - initialize() failed. (Dataflow2.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'. (Dataflow2.controller)

  <status>failed</status>

</step>

<statistic>0.250</statistic>

</task>

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

Please help ASAP..

Regards
Sam

1 Reply
petter
Partner - Champion III
Partner - Champion III

The Oracle table that should be receiving content doesn't seem to exist.

So either you will have to get your DBA to create the table for you or you can checkmark the option "Create Missing Table" in the Write Table operator. The latter requires that the account running the Expressor Dataflow has the necessary rights on the Oracle database to create tables.

Good luck,

- Petter Skjolden