migration version 1.7.2 to 2.2 get inconsitance rid for edge creation

[jaya raj]

Hi,

   I could migrate orient db 1.7.2 to 2.2 database and imported records.

  The below table properties store_has_points_transaction(E) when create new edge @rid should be new one created.

  so i am getting problem in existing query.

METADATA			PROPERTIES					IN
@rid	@version	@class	created_date	is_deleted	is_credit	points	bill_no	store_has_points_transaction	customer_has_points_transaction
#306:3547	3	points_transaction	2015-10-27 15:52:29	false	true	20	QSDFRT1236	#311:7	#309:7
#306:3546	3	points_transaction	2015-10-27 15:17:16	false	true	10	FGHRE56982	#311:6	#309:6
#306:3545	3	points_transaction	2015-10-27 11:44:59	false	true	40	DRF659845	#311:5	#309:5
#306:3544	3	points_transaction	2015-10-27 11:40:23	false	true	40	G48664552	#311:4	#309:4
#306:3543	3	points_transaction	2015-10-26 12:01:22	false	false	10	265974	#311:3	#309:3
#306:3542	3	points_transaction	2015-10-24 14:11:15	false	false	30		#311:2	#309:2
#306:3541	3	points_transaction	2015-10-24 14:09:20	false	false	30		#311:1	#309:1
#306:3540	3	points_transaction	2015-10-24 13:21:05	false	false	30		#311:0	#309:0
#306:3539	1	points_transaction	2015-10-19 22:16:58	false	true	134.45	10620	#48:467	#260:29799
#306:3538	1	points_transaction	2015-10-19 19:02:52	false	true	23.4		#48:941	#260:34338

[alexander anguiano]

I'm not sure about what you are facing, but i do want to tell you that the sql in 2.2 is more strict and may not work.  I got errors in my logs.  You can get it to be less strict by adding this to your database

ALTER DATABASE custom strictSQL=false

...