Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error occurs when collecting SQL server and database #41

Closed
jihyungSong opened this issue Dec 12, 2022 · 0 comments
Closed

Error occurs when collecting SQL server and database #41

jihyungSong opened this issue Dec 12, 2022 · 0 comments
Assignees
Labels
bug Something isn't working

Comments

@jihyungSong
Copy link
Contributor

Below is the error that occurs when collecting SQL Server data.
(Errors that occur during Database collection are also the same)

2022-12-12T08:00:06.549Z [ERROR] tnx-ae02ea21206f    (server_manager.py:128) [list_instances] /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/ZZZ-RG/providers/Microsoft.Sql/servers/mzcsqlserver (DatabaseDoesNotExist) Database 'mzctestsqlpool' does not exist. Make sure that the name is entered correctly.
Code: DatabaseDoesNotExist
Message: Database 'mzctestsqlpool' does not exist. Make sure that the name is entered correctly.
Traceback (most recent call last):
  File "/usr/local/lib/python3.8/site-packages/plugin_azure_cloud_services-1.6.0-py3.8.egg/spaceone/inventory/manager/sql_servers/server_manager.py", line 78, in collect_cloud_service
    databases_list = self.list_databases(sql_servers_conn=sql_servers_conn,
  File "/usr/local/lib/python3.8/site-packages/plugin_azure_cloud_services-1.6.0-py3.8.egg/spaceone/inventory/manager/sql_servers/server_manager.py", line 343, in list_databases
    'sync_group': self.get_sync_group_by_databases(sql_servers_conn, resource_group_name, server_name,
  File "/usr/local/lib/python3.8/site-packages/plugin_azure_cloud_services-1.6.0-py3.8.egg/spaceone/inventory/manager/sql_servers/server_manager.py", line 432, in get_sync_group_by_databases
    for sync_group in sync_group_obj:
  File "/usr/local/lib/python3.8/site-packages/azure/core/paging.py", line 128, in __next__
    return next(self._page_iterator)
  File "/usr/local/lib/python3.8/site-packages/azure/core/paging.py", line 76, in __next__
    self._response = self._get_next(self.continuation_token)
  File "/usr/local/lib/python3.8/site-packages/azure/mgmt/sql/operations/_sync_groups_operations.py", line 1105, in get_next
    map_error(status_code=response.status_code, response=response, error_map=error_map)
  File "/usr/local/lib/python3.8/site-packages/azure/core/exceptions.py", line 107, in map_error
    raise error
azure.core.exceptions.ResourceNotFoundError: (DatabaseDoesNotExist) Database 'mzctestsqlpool' does not exist. Make sure that the name is entered correctly.
Code: DatabaseDoesNotExist
Message: Database 'mzctestsqlpool' does not exist. Make sure that the name is entered correctly.

Sync Group set in the database or SQL server was collected using list_sync_groups_by_database() , but an error occurred with the message that the database does not exist.

@jihyungSong jihyungSong added the bug Something isn't working label Dec 12, 2022
@jihyungSong jihyungSong moved this to Todo in Sprint Board Dec 12, 2022
@ImMin5 ImMin5 moved this from Todo to Development in Sprint Board Feb 23, 2023
@ImMin5 ImMin5 moved this from Development to Todo in Sprint Board Feb 23, 2023
@ImMin5 ImMin5 moved this from Todo to Development in Sprint Board Feb 23, 2023
@ImMin5 ImMin5 moved this from Development to Todo in Sprint Board Feb 23, 2023
@whdalsrnt whdalsrnt removed this from Sprint Board Apr 5, 2023
ImMin5 added a commit that referenced this issue Jul 4, 2023
Signed-off-by: ImMin5 <mino@megazone.com>
@ImMin5 ImMin5 mentioned this issue Jul 4, 2023
5 tasks
ImMin5 added a commit that referenced this issue Jul 4, 2023
Signed-off-by: ImMin5 <mino@megazone.com>
@ImMin5 ImMin5 closed this as completed Jul 14, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants