{"action":"created","issue":{"url":"https://api.github.com/repos/orientechnologies/orientdb-etl/issues/101","labels_url":"https://api.github.com/repos/orientechnologies/orientdb-etl/issues/101/labels{/name}","comments_url":"https://api.github.com/repos/orientechnologies/orientdb-etl/issues/101/comments","events_url":"https://api.github.com/repos/orientechnologies/orientdb-etl/issues/101/events","html_url":"https://github.com/orientechnologies/orientdb-etl/issues/101","id":112098837,"number":101,"title":"[MERGE]Stop working in odb214","user":{"login":"simper66","id":13797323,"avatar_url":"https://avatars.githubusercontent.com/u/13797323?v=3","gravatar_id":"","url":"https://api.github.com/users/simper66","html_url":"https://github.com/simper66","followers_url":"https://api.github.com/users/simper66/followers","following_url":"https://api.github.com/users/simper66/following{/other_user}","gists_url":"https://api.github.com/users/simper66/gists{/gist_id}","starred_url":"https://api.github.com/users/simper66/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/simper66/subscriptions","organizations_url":"https://api.github.com/users/simper66/orgs","repos_url":"https://api.github.com/users/simper66/repos","events_url":"https://api.github.com/users/simper66/events{/privacy}","received_events_url":"https://api.github.com/users/simper66/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/orientechnologies/orientdb-etl/labels/bug","name":"bug","color":"fc2929"}],"state":"open","locked":false,"assignee":{"login":"robfrank","id":413587,"avatar_url":"https://avatars.githubusercontent.com/u/413587?v=3","gravatar_id":"","url":"https://api.github.com/users/robfrank","html_url":"https://github.com/robfrank","followers_url":"https://api.github.com/users/robfrank/followers","following_url":"https://api.github.com/users/robfrank/following{/other_user}","gists_url":"https://api.github.com/users/robfrank/gists{/gist_id}","starred_url":"https://api.github.com/users/robfrank/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/robfrank/subscriptions","organizations_url":"https://api.github.com/users/robfrank/orgs","repos_url":"https://api.github.com/users/robfrank/repos","events_url":"https://api.github.com/users/robfrank/events{/privacy}","received_events_url":"https://api.github.com/users/robfrank/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/orientechnologies/orientdb-etl/milestones/10","html_url":"https://github.com/orientechnologies/orientdb-etl/milestones/2.1.x%20(next%20hotfix)","labels_url":"https://api.github.com/repos/orientechnologies/orientdb-etl/milestones/10/labels","id":1282410,"number":10,"title":"2.1.x (next hotfix)","description":"","creator":{"login":"lvca","id":312606,"avatar_url":"https://avatars.githubusercontent.com/u/312606?v=3","gravatar_id":"","url":"https://api.github.com/users/lvca","html_url":"https://github.com/lvca","followers_url":"https://api.github.com/users/lvca/followers","following_url":"https://api.github.com/users/lvca/following{/other_user}","gists_url":"https://api.github.com/users/lvca/gists{/gist_id}","starred_url":"https://api.github.com/users/lvca/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lvca/subscriptions","organizations_url":"https://api.github.com/users/lvca/orgs","repos_url":"https://api.github.com/users/lvca/repos","events_url":"https://api.github.com/users/lvca/events{/privacy}","received_events_url":"https://api.github.com/users/lvca/received_events","type":"User","site_admin":false},"open_issues":3,"closed_issues":3,"state":"open","created_at":"2015-08-31T16:45:36Z","updated_at":"2015-10-19T10:15:14Z","due_on":null,"closed_at":null},"comments":6,"created_at":"2015-10-19T08:38:49Z","updated_at":"2015-10-19T14:34:30Z","closed_at":null,"body":"Hi, \r\n\r\nI think Merge has stopped working in odb214.\r\n\r\nThe lookup goes fine but the merge is not being done.\r\n\r\n[0:merge] DEBUG Transformer input: {geoNameISO:ES,geoNameISO3:ESP,..........}\r\n[0:merge] DEBUG joinValue=2510, lookupResult=Country#20:0{geoNameId:2510,......} v1\r\n[0:merge] DEBUG Transformer output: null\r\n\r\n\r\nThe output in odb21 works as expected:\r\n\r\n[0:merge] DEBUG Transformer input: {geoNameISO:**ES**,....}\r\n[0:merge] DEBUG joinValue=**2510**, lookupResult=Country#20:0{geoNameId:**2510**,...} v1\r\n[0:merge] DEBUG merged record Country#20:0{geoNameId:**2510**, geoNameISO:**ES**,...}\r\n[0:merge] DEBUG Transformer output: Country#20:0{geoNameId:**2510**, geoNameISO:**ES**,..} v1\r\n\r\n\r\n\r\n\r\nEnviroment:\r\n\r\nOrientDB: OrientDB 2.1.4 GA Community Edition (October 13, 2015)\r\nSO: Windows7\r\nJDK: Jdk 1.8.0_45\r\nOrientDB Configuration: No special configuration. The one out of the box.\r\nMode: Standalone. server.bat & oetl.bat\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/orientechnologies/orientdb-etl/issues/comments/149233294","html_url":"https://github.com/orientechnologies/orientdb-etl/issues/101#issuecomment-149233294","issue_url":"https://api.github.com/repos/orientechnologies/orientdb-etl/issues/101","id":149233294,"user":{"login":"simper66","id":13797323,"avatar_url":"https://avatars.githubusercontent.com/u/13797323?v=3","gravatar_id":"","url":"https://api.github.com/users/simper66","html_url":"https://github.com/simper66","followers_url":"https://api.github.com/users/simper66/followers","following_url":"https://api.github.com/users/simper66/following{/other_user}","gists_url":"https://api.github.com/users/simper66/gists{/gist_id}","starred_url":"https://api.github.com/users/simper66/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/simper66/subscriptions","organizations_url":"https://api.github.com/users/simper66/orgs","repos_url":"https://api.github.com/users/simper66/repos","events_url":"https://api.github.com/users/simper66/events{/privacy}","received_events_url":"https://api.github.com/users/simper66/received_events","type":"User","site_admin":false},"created_at":"2015-10-19T14:34:30Z","updated_at":"2015-10-19T14:34:30Z","body":"I have looked better and i create the \"base\" vertex with the same class that the \"merge\" vertex.\r\n\r\nSo,  in the DB SCRIPT we can change the last line:\r\n\r\nCREATE VERTEX **Location** SET geoNameId = 2510769;\r\nwith:\r\nCREATE VERTEX **Country** SET geoNameId = 2510769;\r\n\r\nIt fails anyway...\r\n\r\n\r\n\r\n"}}