{"action":"created","issue":{"url":"https://api.github.com/repos/OHDSI/WebAPI/issues/433","repository_url":"https://api.github.com/repos/OHDSI/WebAPI","labels_url":"https://api.github.com/repos/OHDSI/WebAPI/issues/433/labels{/name}","comments_url":"https://api.github.com/repos/OHDSI/WebAPI/issues/433/comments","events_url":"https://api.github.com/repos/OHDSI/WebAPI/issues/433/events","html_url":"https://github.com/OHDSI/WebAPI/issues/433","id":325025632,"node_id":"MDU6SXNzdWUzMjUwMjU2MzI=","number":433,"title":"Unable to \"Generate With Features\" in ATLAS","user":{"login":"lrasmus","id":967970,"node_id":"MDQ6VXNlcjk2Nzk3MA==","avatar_url":"https://avatars1.githubusercontent.com/u/967970?v=4","gravatar_id":"","url":"https://api.github.com/users/lrasmus","html_url":"https://github.com/lrasmus","followers_url":"https://api.github.com/users/lrasmus/followers","following_url":"https://api.github.com/users/lrasmus/following{/other_user}","gists_url":"https://api.github.com/users/lrasmus/gists{/gist_id}","starred_url":"https://api.github.com/users/lrasmus/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lrasmus/subscriptions","organizations_url":"https://api.github.com/users/lrasmus/orgs","repos_url":"https://api.github.com/users/lrasmus/repos","events_url":"https://api.github.com/users/lrasmus/events{/privacy}","received_events_url":"https://api.github.com/users/lrasmus/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":14,"created_at":"2018-05-21T19:07:02Z","updated_at":"2018-07-31T16:39:38Z","closed_at":null,"author_association":"NONE","body":"I am unable to use the \"Generate With Features\" capability in ATLAS.  I have a cohort definition that will run successfully (via Generate), but will error out when run as \"Generate With Features\".  In review of the logs, the following exception is coming back:\r\n\r\n```\r\nSQL state [S0001]; error code [2714]; There is already an object named '#raw_data' in the database.; nested exception is java.sql.BatchUpdateException: There is already an object named '#raw_data' in the database.\r\n    \tat org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:84)\r\n    \tat org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)\r\n    \tat org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)\r\n    \tat org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:419)\r\n    \tat org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:600)\r\n    \tat org.ohdsi.webapi.cohortfeatures.GenerateCohortFeaturesTasklet.doTask(GenerateCohortFeaturesTasklet.java:150)\r\n    \t... 23 more\r\n    Caused by: java.sql.BatchUpdateException: There is already an object named '#raw_data' in the database.\r\n    \tat com.microsoft.sqlserver.jdbc.SQLServerStatement.executeBatch(SQLServerStatement.java:1915)\r\n    \tat org.springframework.jdbc.core.JdbcTemplate$1BatchUpdateStatementCallback.doInStatement(JdbcTemplate.java:561)\r\n    \tat org.springframework.jdbc.core.JdbcTemplate$1BatchUpdateStatementCallback.doInStatement(JdbcTemplate.java:548)\r\n    \tat org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:408)\r\n    \t... 25 more\r\n```\r\n\r\nI am able to get the full SQL code from the log and see the same error when run directly against the database (no big surprise there).  Our setup is using Broadsea containers for ATLAS and WebAPI, running against a SQL Server 2017 Standard database."},"comment":{"url":"https://api.github.com/repos/OHDSI/WebAPI/issues/comments/409286853","html_url":"https://github.com/OHDSI/WebAPI/issues/433#issuecomment-409286853","issue_url":"https://api.github.com/repos/OHDSI/WebAPI/issues/433","id":409286853,"node_id":"MDEyOklzc3VlQ29tbWVudDQwOTI4Njg1Mw==","user":{"login":"chrisknoll","id":6818777,"node_id":"MDQ6VXNlcjY4MTg3Nzc=","avatar_url":"https://avatars0.githubusercontent.com/u/6818777?v=4","gravatar_id":"","url":"https://api.github.com/users/chrisknoll","html_url":"https://github.com/chrisknoll","followers_url":"https://api.github.com/users/chrisknoll/followers","following_url":"https://api.github.com/users/chrisknoll/following{/other_user}","gists_url":"https://api.github.com/users/chrisknoll/gists{/gist_id}","starred_url":"https://api.github.com/users/chrisknoll/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/chrisknoll/subscriptions","organizations_url":"https://api.github.com/users/chrisknoll/orgs","repos_url":"https://api.github.com/users/chrisknoll/repos","events_url":"https://api.github.com/users/chrisknoll/events{/privacy}","received_events_url":"https://api.github.com/users/chrisknoll/received_events","type":"User","site_admin":false},"created_at":"2018-07-31T16:39:38Z","updated_at":"2018-07-31T16:39:38Z","author_association":"CONTRIBUTOR","body":"Aha! Ok, i'll check or that temp table as well.\r\n\r\nThank you!\r\n"}}
{"actor":{"display_login":"chrisknoll"}}