0 Replies Latest reply: Jan 19, 2018 4:45 AM by Ishan Awasthi RSS

    QlikView returning a XML line as output for a procedure call, whereas QlikSense returning data perfectly

    Ishan Awasthi

      I am unable to execute the stored procedure in QV using below line of code. In QlikSense it is getting executed correctly with data. In QlikView it is giving one column with XML version (attached below). It is although giving correct count of records in XML output.


      Checks Done:-

      Database Grants are verified for the procedure and for the QV user

      I am able to execute the procedure in database manually.


      QV Code:-

      Test:

      load

      *;

      $(must_include=../Datasources/envconfig.qvs);

      SQL exec dbo.ABC;

       

      store Test into [../QVD/Test.qvd];

      DROP table Test;

       

      Test_Main:

      Load

      *

      FROM

      [../QVD/Test.qvd];

      QV Issue.PNG