Qlikview Expressor Error

mightyqlikers — Wed, 05 Aug 2015 08:49:00 GMT

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

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>

</task>

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

Please help ASAP..

Regards
Sam

Re: Qlikview Expressor Error

petter — Thu, 06 Aug 2015 08:48:19 GMT

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

topic Re: Qlikview Expressor Error in QlikView

Qlikview Expressor Error

Re: Qlikview Expressor Error