[SQL.SqlCheckAdminError]: Failed to check AAD admin 'todolista469e7'. maxPageSize is not supported by this operation

[ge25kev]

Hi guys,

Trying to build the ToDoList sample app with SQL backend (https://github.com/OfficeDev/TeamsFx-Samples/tree/v1.1.0/todo-list-with-Azure-backend) , I keep getting the error message:

[SQL.SqlCheckAdminError]: Failed to check AAD admin 'todolista469e7'. maxPageSize is not supported by this operation.

I couldn't find anything on Stackoverflow and after asking Chat GPT-3 I only realise that the parameter maxPageSize may not even be needed for such a simple application. It's answer:

This error might occur while trying to connect an SQL instance to an Azure AD tenant.
This feature is typically used to limit the number of items returned in a query to a specific number. If the maxPageSize parameter is set to a value other than 0, the query will return a maximum of that number of items. In this case, it seems that the operation being performed does not support this parameter.

Even so, not sure how to resolve this issue and where to find the maxPageSize parameter. Any help would be much appreciated

[arunkumarperumal]

@ge25kev
I faced a similar issue. Issue seems to be provisioning azure sql using bicep.

Below is how I was able to overcome the issue.

1. Set the parameter "provision" for "azure-sql" to false.
2. Manually create the tables and sql if not created and then add the permissions required for the account. Follow steps in the below article to manually add user with permissions to the sql database

https://github.com/OfficeDev/TeamsFx/blob/dev/docs/fx-core/sql-help.md#step-2-add-database-user-manually

[xzf0587]

Hi @ge25kev,
sorry for late reply.
This error for maxPageSize is caused by the change of @azure/arm-sql interface.
The Teams toolkit 4.2.5 has fix this problem. You can use the version to retry.