2 Replies Latest reply: Aug 21, 2014 5:51 AM by abdelmalek khettouf RSS

    [Error] Did not recognize connector reply

    abdelmalek khettouf

      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

        • Re: [Error] Did not recognize connector reply
          Pradip Sen

          Could you upload the script?

            • Re: Re: [Error] Did not recognize connector reply
              abdelmalek khettouf

              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