Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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
Valued Contributor III

Re: [Error] Did not recognize connector reply

Could you upload the script?

Not applicable

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

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

Community Browser