View Issue Details

IDProjectCategoryView StatusLast Update
0007551VALENTINA STUDIOTool - Data Transferpublic2016-03-16 11:19
ReporterSergio Zordan Assigned Toyuriy_velichko  
PriorityhighSeveritymajorReproducibilityalways
Status resolvedResolutionfixed 
PlatformINTELOSWindowsOS Version10
Product Version6.3.x 
Target Version6.4.xFixed in Version6.4.x 
Summary0007551: The data transfer does nothing
DescriptionI am trying to transfer some data between tables on two PostgreSQL databases. After the field mapping, if I press the RUN button I have a "Transfer progress" panel, on wich I see nothing, there is only a Close button but the panel has no messages and no data has been transfered between tables.
TagsNo tags attached.
Working with DB:postgreSQL Server
Version of your DB9.5

Activities

yuriy_velichko

yuriy_velichko

2016-03-11 11:12

reporter   ~0008864

How many records in the table?
Sergio Zordan

Sergio Zordan

2016-03-11 11:24

reporter   ~0008866

There are about 6400 records in that table.
yuriy_velichko

yuriy_velichko

2016-03-11 12:49

reporter   ~0008868

Can't reproduce for now.
Can you provide more info about the table structure? Will be great to get the table dump(with records or only structure), but a list of fields types should be enough to try figure out the reason of such strange behaviour.
Sergio Zordan

Sergio Zordan

2016-03-11 14:43

reporter   ~0008869

--
-- ON SOURCE DATABASE
--
CREATE TABLE public.box_magazzino (
  id_magazzino_master character(2) NOT NULL,
  id_zona_magazzino character(4) NOT NULL,
  id_lato_box character(4) NOT NULL,
  nr_box integer NOT NULL,
  id_tipo_box character(4) NOT NULL,
  piano integer NOT NULL,
  posto integer NOT NULL,
  seq_id_zona_magazzino character(4) NOT NULL,
  seq_id_lato_box character(4) NOT NULL,
  seq_nr_box integer NOT NULL DEFAULT 0,
  seq_id_tipo_box character(4) NOT NULL,
  seq_piano integer NOT NULL DEFAULT 0,
  seq_posto integer NOT NULL DEFAULT 0,
  cm_altezza integer NOT NULL DEFAULT 0,
  cm_larghezza integer NOT NULL DEFAULT 0,
  cm_profondita integer NOT NULL DEFAULT 0,
  id_articolo integer,
  yn_utilizzabile boolean NOT NULL DEFAULT false,
  fila character(2) NOT NULL,
  seq_fila character(2) NOT NULL DEFAULT ''::bpchar,
  yn_centrale boolean NOT NULL DEFAULT false,
  CONSTRAINT pk_box_magazzino PRIMARY KEY (id_magazzino_master, id_zona_magazzino, fila, id_lato_box, nr_box, id_tipo_box, piano, posto)
);
Sergio Zordan

Sergio Zordan

2016-03-11 14:44

reporter   ~0008870

--
-- ON DESTINATION DATABASE
--
CREATE TABLE public.box_magazzino (
  cd_box_magazzino SERIAL NOT NULL,
  cd_magazzino character(4) NOT NULL,
  cd_zona_magazzino character(4) NOT NULL,
  cd_fila_box character(4) NOT NULL,
  cd_lato_box character(4) NOT NULL,
  nr_box integer NOT NULL,
  cd_tipo_box character(4) NOT NULL,
  piano integer NOT NULL,
  posto integer NOT NULL,
  seq_cd_zona_magazzino character(4) NOT NULL,
  seq_cd_fila_box character(4) NOT NULL DEFAULT ''::bpchar,
  seq_cd_lato_box character(4) NOT NULL,
  seq_nr_box integer NOT NULL DEFAULT 0,
  seq_cd_tipo_box character(4) NOT NULL,
  seq_piano integer NOT NULL DEFAULT 0,
  seq_posto integer NOT NULL DEFAULT 0,
  cm_altezza integer NOT NULL DEFAULT 0,
  cm_larghezza integer NOT NULL DEFAULT 0,
  cm_profondita integer NOT NULL DEFAULT 0,
  cd_articolo integer,
  yn_utilizzabile boolean NOT NULL DEFAULT false,
  yn_centrale boolean NOT NULL DEFAULT false,
  CONSTRAINT box_magazzino_pkey PRIMARY KEY (cd_box_magazzino)
);
Sergio Zordan

Sergio Zordan

2016-03-11 14:44

reporter  

mapping_test.vmp (57 bytes)
Sergio Zordan

Sergio Zordan

2016-03-11 14:45

reporter   ~0008871

I have also uploaded a saved mapping. Note that not all the fields are mapped and on destination the char fields are larger.
yuriy_velichko

yuriy_velichko

2016-03-11 14:48

reporter   ~0008872

Thanks, Sergio!
I'll try to find the problem right now.
Sergio Zordan

Sergio Zordan

2016-03-11 14:51

reporter   ~0008873

PS: the load mapping... does not load the mapping I saved (it does not load anything)
yuriy_velichko

yuriy_velichko

2016-03-11 15:01

reporter   ~0008874

Somehow the file is empty - the mapping is absent, only xml signature .
Sergio Zordan

Sergio Zordan

2016-03-11 15:03

reporter   ~0008875

I've pressed the [save mapping...] button after defining the mapping.
yuriy_velichko

yuriy_velichko

2016-03-11 15:08

reporter   ~0008876

I have done the same right now and got a valid map file. Ok, will try to figure out the reason.
Sergio Zordan

Sergio Zordan

2016-03-11 15:12

reporter   ~0008877

Got it! If you don't map the destination table with right click on source it does nothing.
If you have a destination table with the same name AND you don't map the destination table with right click, you can map the destination fields and the program goes on saying nothing but also doing nothing. As a side note the table list is not sorted in the right way. I send you a picture of mapping.
Sergio Zordan

Sergio Zordan

2016-03-11 15:12

reporter  

map fields.png (24,689 bytes)
Sergio Zordan

Sergio Zordan

2016-03-11 15:14

reporter   ~0008878

As you can see in the picture I've not mapped the destination table but I can map the fields of the destination table because the table name is the same...
yuriy_velichko

yuriy_velichko

2016-03-11 15:18

reporter   ~0008879

Confirmed!
Thanks for your reports!
The bug will be fixed in nearest time.
yuriy_velichko

yuriy_velichko

2016-03-11 15:44

reporter   ~0008880

Fixed in version 6.3.6.

Now on mapping field the parent table will be mapped automatically.

Issue History

Date Modified Username Field Change
2016-03-11 10:48 Sergio Zordan New Issue
2016-03-11 11:12 yuriy_velichko Note Added: 0008864
2016-03-11 11:24 Sergio Zordan Note Added: 0008866
2016-03-11 12:12 yuriy_velichko Assigned To => yuriy_velichko
2016-03-11 12:12 yuriy_velichko Status new => assigned
2016-03-11 12:49 yuriy_velichko Note Added: 0008868
2016-03-11 14:43 Sergio Zordan Note Added: 0008869
2016-03-11 14:44 Sergio Zordan Note Added: 0008870
2016-03-11 14:44 Sergio Zordan File Added: mapping_test.vmp
2016-03-11 14:45 Sergio Zordan Note Added: 0008871
2016-03-11 14:48 yuriy_velichko Note Added: 0008872
2016-03-11 14:51 Sergio Zordan Note Added: 0008873
2016-03-11 15:01 yuriy_velichko Note Added: 0008874
2016-03-11 15:03 Sergio Zordan Note Added: 0008875
2016-03-11 15:08 yuriy_velichko Note Added: 0008876
2016-03-11 15:12 Sergio Zordan Note Added: 0008877
2016-03-11 15:12 Sergio Zordan File Added: map fields.png
2016-03-11 15:14 Sergio Zordan Note Added: 0008878
2016-03-11 15:18 yuriy_velichko Note Added: 0008879
2016-03-11 15:42 yuriy_velichko Product Version => 6.3.x
2016-03-11 15:42 yuriy_velichko Target Version => 6.3.x
2016-03-11 15:44 yuriy_velichko Note Added: 0008880
2016-03-11 15:44 yuriy_velichko Status assigned => resolved
2016-03-11 15:44 yuriy_velichko Fixed in Version => 6.3.x
2016-03-11 15:44 yuriy_velichko Resolution open => fixed
2016-03-16 11:19 Ruslan Zasukhin Fixed in Version 6.3.x => 6.4.x
2016-03-16 11:19 Ruslan Zasukhin Target Version 6.3.x => 6.4.x