1. 

   mfiorentino, Member

   Hi,
   I'm trying to call a select of a table from a remote server to my main server using dbr.remote.call.
   This in my code:
   

   DROP PROCEDURE IF EXISTS sp_DBR_remote_call
   
   $$
   
   CREATE PROCEDURE `sp_DBR_remote_call`(inDate date)
   
   BEGIN
   
   drop table if exists remote_data_tmp;
   
   create table remote_data_tmp (
   
   id_coris int(8),
   
   id_tran_ticket bigint,
   
   cantidad_pasajeros int(2),
   
   plan varchar(255),
   
   nota varchar(255)
   
   );
   
   select 'dbr.remote.prepare', 'Server_Madrid', 'remote_data_tmp', 'sp_DBR_remote_first',inDate;
   
   select 'dbr.remote.call', 'sp_DBR_show_remote';
   
   END
   
   $$
   
   

   
   Always i have sintax error:
   Could not execute the report. There was an error in the report.
   You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '()' at line 1

   when i use dbr.remote.call.
   if I use call sp_DBR_show_remote instead of select 'dbr.remote.call', 'sp_DBR_show_remote' work but return me empty table i think that it's for a time problem

   thanks
2. 

   myDBR Team, Key Master

   It was a bug in the dbr.remote.call. Fixed now in the latest build. Just run the updater.

   --
   myDBR Team
3. 

   mfiorentino, Member

   thanks it's now work.
   now i have another problem with this code:
   DROP PROCEDURE IF EXISTS sp_DBR_remote_call
   $$
   CREATE PROCEDURE `sp_DBR_remote_call`()
   BEGIN
   drop temporary table if exists remote_data_tmp_station;
   create temporary table remote_data_tmp_station (
   id_station int(11),
   station_number int(11),
   station_name varchar(250),
   id_terminal int(11),
   id_country int(11),
   aeropuerto varchar(3),
   num_terminal int(1),
   num_oper_venta bigint(20),
   num_oper_apertura_cierre bigint(20),
   num_oper_cierre bigint(20),
   num_oper_rd bigint(20),
   savia_local_id varchar(50),
   cont_global_trans int(15),
   cont_oper_venta int(15),
   cont_oper_apertura int(15),
   cont_oper_cierre int(15),
   cont_oper_rd int(15),
   cont_Ma int(5),
   id_tpv varchar(2),
   version_tpv varchar(45),
   version_tpv_instalada varchar(45),
   fecha_ultimo_login datetime,
   ip_ultimo_login varchar(45),
   guardar_ip varchar(3),
   interaccion_plataforma_sim varchar(5),
   interaccion_plataforma_firstdata varchar(5),
   interaccion_plataforma_ipcall varchar(5),
   interaccion_plataforma_ekit varchar(5),
   iva_recargas int(2),
   habilita_huella_digital varchar(3)
   );
   select 'dbr.remote.prepare', 'Server_Madrid', 'remote_data_tmp_station', 'sp_DBR_remote_Station';
   select 'dbr.remote.call', 'sp_DBR_show_remoteStation';
   END
   $$

   answare is:
   Fatal error: Cannot use object of type stdClass as array in /var/www/html/mydbr.tuttogroup.com/apps/showReport.php on line 3659

   can you help me please?

   thanks
4. 

   myDBR Team, Key Master

   Something unexpected is returned from the remote server. We also would be interested of seeing what error is causing this. Update to the newest build and add following line to user/defaults.php:

   $mydbr_defaults['remote_server']['debug_result'] = true;

   This will show the call made to the remote server and also the returned data (should be an JSON array).

   You can also open a support ticket with this one.
   --
   myDBR Team

Reply

You must log in to post.