Skip to content

Error occurs when collecting SQL server and database #41

Closed
@jihyungSong

Description

@jihyungSong

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.

Metadata

Metadata

Assignees

Labels

bugSomething isn't working

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions