{"action":"created","issue":{"url":"https://api.github.com/repos/OHDSI/Achilles/issues/115","repository_url":"https://api.github.com/repos/OHDSI/Achilles","labels_url":"https://api.github.com/repos/OHDSI/Achilles/issues/115/labels{/name}","comments_url":"https://api.github.com/repos/OHDSI/Achilles/issues/115/comments","events_url":"https://api.github.com/repos/OHDSI/Achilles/issues/115/events","html_url":"https://github.com/OHDSI/Achilles/issues/115","id":156775737,"number":115,"title":"ExportToJson hangs at Generating Drug Treemap","user":{"login":"MaximMoinat","id":17825660,"avatar_url":"https://avatars.githubusercontent.com/u/17825660?v=3","gravatar_id":"","url":"https://api.github.com/users/MaximMoinat","html_url":"https://github.com/MaximMoinat","followers_url":"https://api.github.com/users/MaximMoinat/followers","following_url":"https://api.github.com/users/MaximMoinat/following{/other_user}","gists_url":"https://api.github.com/users/MaximMoinat/gists{/gist_id}","starred_url":"https://api.github.com/users/MaximMoinat/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MaximMoinat/subscriptions","organizations_url":"https://api.github.com/users/MaximMoinat/orgs","repos_url":"https://api.github.com/users/MaximMoinat/repos","events_url":"https://api.github.com/users/MaximMoinat/events{/privacy}","received_events_url":"https://api.github.com/users/MaximMoinat/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2016-05-25T15:10:36Z","updated_at":"2016-05-26T08:18:01Z","closed_at":null,"body":"The exportToJson function exports the first files, but freezes at the message 'Generating Drug Treemap', at 0 %. I let it run for 2 hours, but no progress at all and R even crashes at some point.\r\nI use the following command to export the json (after running the achilles command):\r\n```\r\nexportToJson(connectionDetails, \r\n             cdmDatabaseSchema=\"cdm5\", \r\n             resultsDatabaseSchema = \"results_achilles\", \r\n             outputPath = \"/Documents/achilles/data\",  \r\n             cdmVersion = \"5\")\r\n```\r\n\r\nR version 3.2.4, on Windows machine and the latest version of Achilles (installed with install_github('OHDSI/Achilles').\r\nOn my Mac laptop I cannot reproduce this problem.\r\n\r\nDoes anyone else have this problem?"},"comment":{"url":"https://api.github.com/repos/OHDSI/Achilles/issues/comments/221807023","html_url":"https://github.com/OHDSI/Achilles/issues/115#issuecomment-221807023","issue_url":"https://api.github.com/repos/OHDSI/Achilles/issues/115","id":221807023,"user":{"login":"MaximMoinat","id":17825660,"avatar_url":"https://avatars.githubusercontent.com/u/17825660?v=3","gravatar_id":"","url":"https://api.github.com/users/MaximMoinat","html_url":"https://github.com/MaximMoinat","followers_url":"https://api.github.com/users/MaximMoinat/followers","following_url":"https://api.github.com/users/MaximMoinat/following{/other_user}","gists_url":"https://api.github.com/users/MaximMoinat/gists{/gist_id}","starred_url":"https://api.github.com/users/MaximMoinat/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MaximMoinat/subscriptions","organizations_url":"https://api.github.com/users/MaximMoinat/orgs","repos_url":"https://api.github.com/users/MaximMoinat/repos","events_url":"https://api.github.com/users/MaximMoinat/events{/privacy}","received_events_url":"https://api.github.com/users/MaximMoinat/received_events","type":"User","site_admin":false},"created_at":"2016-05-26T08:18:01Z","updated_at":"2016-05-26T08:18:01Z","body":"Thanks for your answer.\r\nIn this case the drug exposure table just contained 10,000 rows. That shouldn't take such a long time to complete, right?\r\nOr is there another way, besides making the table smaller, to speed this step up?"}}
{"actor":{"display_login":"MaximMoinat"}}