topic Re: Error while sending insert statement to oracle database in qliksense in Management & Governance

Error while sending insert statement to oracle database in qliksense

Anonymous — Fri, 10 Aug 2018 07:43:35 GMT

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?

Re: Error while sending insert statement to oracle database in qliksense

joaopaulo_delco — Tue, 30 Apr 2019 17:09:04 GMT

I have the same issue trying to execute a procedure.

How did you solve the problem?

Re: Error while sending insert statement to oracle database in qliksense

Vegar — Tue, 30 Apr 2019 17:46:34 GMT

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.

Re: Error while sending insert statement to oracle database in qliksense

joaopaulo_delco — Tue, 30 Apr 2019 18:06:42 GMT

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"}

Re: Error while sending insert statement to oracle database in qliksense

Vegar — Tue, 30 Apr 2019 18:10:31 GMT

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.

Re: Error while sending insert statement to oracle database in qliksense

joaopaulo_delco — Tue, 30 Apr 2019 18:23:09 GMT

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

Re: Error while sending insert statement to oracle database in qliksense

joaopaulo_delco — Thu, 02 May 2019 12:07:25 GMT

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"};