Close

Azure (DMA) Data migration Assistant warning when migrating database to Azure Web Services [ProductLoadAllPagedNopAjaxFilters]

ehubcap
3 years ago
#21424 Quote
Avatar
  • 43
https://www.dropbox.com/s/60kui0ueuaywu6j/ProductLoadAllPagedNopAjaxFilters_error_migrating_database_TractionDemo4.0_0110917.jpg?dl=0
todor.atanasov
3 years ago
#21426 Quote
Avatar
  • Moderator
  • 249


Greetings,

Thank you for reaching out to us!

I'm afraid I don't have permission to see the image through the provided link. Could you provide more information and try to provide permission for the image?

Looking forward to your reply!
Best regards,
Todor Atanasov
Nop-templates.com
[email protected]
8 months ago
#22224 Quote
Avatar
  • 4
Hi,
We are having similar problems.

Basic description: If you would like to migrate your DB from AWS to Azure (or similar) The migration tools ('Export data-Tier Application' or 'Data Migration Assistant') give the follwoing error:

One or more unsupported elements were found in the schema used as part of a data package.
Error SQL71564: Error validating element [dbo].[ProductLoadAllPagedNopAjaxFilters]: The element [dbo].[ProductLoadAllPagedNopAjaxFilters] cannot be deployed as the script body is encrypted.
(Microsoft.SqlServer.Dac)

So People will need solution. Please help.
Boyko
8 months ago
#22225 Quote
Avatar
  • Moderator
  • 1570
[email protected] wrote:
Hi,
We are having similar problems.

Basic description: If you would like to migrate your DB from AWS to Azure (or similar) The migration tools ('Export data-Tier Application' or 'Data Migration Assistant') give the follwoing error:

One or more unsupported elements were found in the schema used as part of a data package.
Error SQL71564: Error validating element [dbo].[ProductLoadAllPagedNopAjaxFilters]: The element [dbo].[ProductLoadAllPagedNopAjaxFilters] cannot be deployed as the script body is encrypted.
(Microsoft.SqlServer.Dac)

So People will need solution. Please help.


Hi Omer,

That is because the stored procedure we use in the Ajax Filters is encrypted.
Please refer to this post.
Regards,
Nop-Templates.com Team