{"action":"created","issue":{"url":"https://api.github.com/repos/delphix/masking-initializer/issues/1","repository_url":"https://api.github.com/repos/delphix/masking-initializer","labels_url":"https://api.github.com/repos/delphix/masking-initializer/issues/1/labels{/name}","comments_url":"https://api.github.com/repos/delphix/masking-initializer/issues/1/comments","events_url":"https://api.github.com/repos/delphix/masking-initializer/issues/1/events","html_url":"https://github.com/delphix/masking-initializer/issues/1","id":320899081,"node_id":"MDU6SXNzdWUzMjA4OTkwODE=","number":1,"title":"MSSQL environment restore: internal server error (Status code 500) on creation of rulesets","user":{"login":"slusardi01","id":39063916,"node_id":"MDQ6VXNlcjM5MDYzOTE2","avatar_url":"https://avatars2.githubusercontent.com/u/39063916?v=4","gravatar_id":"","url":"https://api.github.com/users/slusardi01","html_url":"https://github.com/slusardi01","followers_url":"https://api.github.com/users/slusardi01/followers","following_url":"https://api.github.com/users/slusardi01/following{/other_user}","gists_url":"https://api.github.com/users/slusardi01/gists{/gist_id}","starred_url":"https://api.github.com/users/slusardi01/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/slusardi01/subscriptions","organizations_url":"https://api.github.com/users/slusardi01/orgs","repos_url":"https://api.github.com/users/slusardi01/repos","events_url":"https://api.github.com/users/slusardi01/events{/privacy}","received_events_url":"https://api.github.com/users/slusardi01/received_events","type":"User","site_admin":false},"labels":[{"id":872244690,"node_id":"MDU6TGFiZWw4NzIyNDQ2OTA=","url":"https://api.github.com/repos/delphix/masking-initializer/labels/question","name":"question","color":"d876e3","default":true}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":13,"created_at":"2018-05-07T18:04:21Z","updated_at":"2018-07-03T22:06:48Z","closed_at":null,"author_association":"NONE","body":"After a complete backup, I tried to restore a single MSSQL environment (as all our testing had been with oracle to date).  I made the necessary edits to the base.Json file to contain only the one MSSQL environment as well as the correlating application.json file to add passwords for the connectors.  \r\n\r\nI ended up with an internal server error, status code 500  during creation of rule sets.\r\n\r\n2018-05-01 12:35:29.600 [main] DEBUG com.delphix.masking.initializer.maskingApi.endpointCaller.ApiCallDriver - Response body: {\"errorMessage\":\"Encountered internal server error, please see the logs for more details\"}\r\n\r\n2018-05-01 12:35:29.600 [main] ERROR com.delphix.masking.initializer.maskingApi.SetupDriver - Got status code: [500] with message [Encountered internal server error, please see the logs for more details] trying to hit URL: [http://myhostname.  \r\n\r\nAttached is a tail of the All.log file:\r\n[MSSQL_TailOfAll.log](https://github.com/delphix/masking-initializer/files/1980927/MSSQL_TailOfAll.log)\r\n:8282/masking/api/table-metadata] [POST]"},"comment":{"url":"https://api.github.com/repos/delphix/masking-initializer/issues/comments/402305927","html_url":"https://github.com/delphix/masking-initializer/issues/1#issuecomment-402305927","issue_url":"https://api.github.com/repos/delphix/masking-initializer/issues/1","id":402305927,"node_id":"MDEyOklzc3VlQ29tbWVudDQwMjMwNTkyNw==","user":{"login":"bpg130","id":8633516,"node_id":"MDQ6VXNlcjg2MzM1MTY=","avatar_url":"https://avatars1.githubusercontent.com/u/8633516?v=4","gravatar_id":"","url":"https://api.github.com/users/bpg130","html_url":"https://github.com/bpg130","followers_url":"https://api.github.com/users/bpg130/followers","following_url":"https://api.github.com/users/bpg130/following{/other_user}","gists_url":"https://api.github.com/users/bpg130/gists{/gist_id}","starred_url":"https://api.github.com/users/bpg130/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bpg130/subscriptions","organizations_url":"https://api.github.com/users/bpg130/orgs","repos_url":"https://api.github.com/users/bpg130/repos","events_url":"https://api.github.com/users/bpg130/events{/privacy}","received_events_url":"https://api.github.com/users/bpg130/received_events","type":"User","site_admin":false},"created_at":"2018-07-03T22:06:48Z","updated_at":"2018-07-03T22:06:48Z","author_association":"COLLABORATOR","body":"I found the following in the masking logs at the time of the error noted above.\r\n```\r\n2018-05-01 16:35:29,600  [http-nio-8282-exec-21] ERROR c.dmsuite.common.utils.DBConnection - Error while getting sql server Connection Object\r\njava.sql.SQLException: Login failed for user '<USER_NAME>'.\r\n\tat net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372)\r\n\tat net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820)\r\n\tat net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258)\r\n\tat net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:603)\r\n\tat net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:352)\r\n\tat net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)\r\n\tat net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:185)\r\n\tat java.sql.DriverManager.getConnection(DriverManager.java:664)\r\n```\r\nSo it looks like it is failing to authenticate with your database.\r\n\r\nDid you fill in the passwords for this backup file? See [this](https://github.com/delphix/masking-initializer/#password-limitations) section in the `README` for information on filling in the passwords. This section was accidentally removed from the `README` in a previous version, so this part of the restore process might have been overlooked."}}
{"actor":{"display_login":"bpg130"}}