topic Re: [Error] Did not recognize connector reply in QlikView

[Error] Did not recognize connector reply

Thu, 21 Aug 2014 09:38:28 GMT

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)

Have anyone faced the same problem before?

Thanks a lot

Re: [Error] Did not recognize connector reply

senpradip007 — Thu, 21 Aug 2014 09:41:03 GMT

Could you upload the script?

Re: Re: [Error] Did not recognize connector reply

Thu, 21 Aug 2014 09:51:42 GMT

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);