Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld online is next week! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

[Error] Did not recognize connector reply

Hi all,

I'm stuck with a loading issue

I built a table under SQL Server that containts instructions (SQL queries) for data loading on QV,

On my QV application I browse the table and execute each instruction

One of my instructions is trying to load ~ 300 fields

If I run directly the query in SQL Server Management Studio it perfectly works, when I'm trying to load the same under QV I have this error message (cf. image below)

2014-08-21_11h24_14.png

Have anyone faced the same problem before?

Thanks a lot

2 Replies
senpradip007
Specialist III
Specialist III

Could you upload the script?

Not applicable
Author

Hello, below the script

N.B : for some confidentiality reasons I've changed some parameters, but it's not a big deal

OLEDB CONNECT32 TO [Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Database;Data Source=Sever;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=ID;Use Encryption for Data=False;Tag with column collation when possible=False];

process:

LOAD ID,

    Generator,

    Process,

    Load,

    Instruction,

    Target_QVD,

    Description;

SQL SELECT *

FROM "GENERIC".dbo."GENERATOR";

let nb_process=fieldvaluecount('ID');

trace nb_process:$(nb_process);

let my_user=QVUser();

for a=0 to $(nb_process)-1

  let my_id=peek('ID',$(a),'process');

  let my_process=peek('Process',$(a),'process');

  let my_load=peek('Load',$(a),'process');

  trace $(my_load);

  let my_instruction=peek('Instruction',$(a),'process');

  trace $(my_instruction);

  let my_target_qvd=peek('Target_QVD',$(a),'process');

  trace $(my_target_qvd);

data:

load $(my_load);

$(my_instruction);

trace process over;

let count_row=NoOfRows('data');

store data into $(my_target_qvd);

drop table data;

let curr_process=$(a)+1;

trace processed :$(curr_process) out of  $(nb_process);

next