Error while sending insert statement to oracle database in qliksense

[Anonymous]

The following  error happens when sending an insert statement to Oracle database.

Error: QVX_UNEXPECTED_END_OF_DATA: Unable to get column information for the fields that are used in the query:

Object reference not set to an instance of an object.

It happens only in the central node server but not in Rim node.

What can be the reason?Can anyone help in this?

[joaopaulo_delco]

I have the same issue trying to execute a procedure.

How did you solve the problem? 

[Vegar]

Can can only use SQL SELECT from databases in QlikView/Qlik Sense, it is not possible to achieve what you are trying to do from the script editor.

[joaopaulo_delco]

Vegar

      Before I update to Feb/2019 version my script was working well.

I'm just calling a procedure to execute. Loot to my script

LIB CONNECT TO 'Oracle MDLog (qliksense_administrador)';

SQL {CALL infomlog."TST_MONITORACAO_PEDIDOS_VENDA"}; //the error appears here

QVX_UNEXPECTED_END_OF_DATA: Unable to get column information for the fields that are used in the query: Referência de objeto não definida para uma instância de um objeto.: SQL {CALL infomlog."TST_MONITORACAO_PEDIDOS_VENDA"}

[Vegar]

This is performing an insert into your database? Wow, I learned something new today.

Then I.m not able to help you further. I will monitor this thread to see if an solution comes around.

[joaopaulo_delco]

Yes Vegar. This procedure perform insert into database. And worked well at Nov/2018 version.

[joaopaulo_delco]

I changed the connection to OLE DB and the problem was solved.

Before I was using a direct oracle connection.

This is my script:

LIB CONNECT TO 'Oracle MDLog OleDB (qliksense_administrador)';

SQL {CALL infomlog."TST_MONITORACAO_PEDIDOS_VENDA"};