Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Error while sending insert statement to oracle database in qliksense

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?

6 Replies
joaopaulo_delco
Partner - Creator III
Partner - Creator III

I have the same issue trying to execute a procedure.

How did you solve the problem? 

Help users find answers! Don't forget to mark a solution that worked for you!
Vegar
MVP
MVP

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
Partner - Creator III
Partner - Creator III

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

Help users find answers! Don't forget to mark a solution that worked for you!
Vegar
MVP
MVP

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
Partner - Creator III
Partner - Creator III

Yes Vegar. This procedure perform insert into database. And worked well at Nov/2018 version.
Help users find answers! Don't forget to mark a solution that worked for you!
joaopaulo_delco
Partner - Creator III
Partner - Creator III

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

Before I was using a direct oracle connection.

conexao ora oledb.png

This is my script:

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

SQL {CALL infomlog."TST_MONITORACAO_PEDIDOS_VENDA"};

Help users find answers! Don't forget to mark a solution that worked for you!