Unable to generate script for StoredProcedure '[dbo].[ProductLoadAllPagegNopAjaxFilters]'.

Hi,

We are working with nopcommerce 3.4 with Traction theme.After successful up gradation we are trying to restore the DB on the server through "Generate script" option. Everything is good except the script generation of SP "[ProductLoadAllPagegNopAjaxFilters".

The error is

Property TextHeader is not available for StoredProcedure '[dbo].[ProductLoadAllPagegNopAjaxFilters]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. The text is encrypted. (Microsoft.SqlServer.Smo)

We are stopped to go online because of this. Very urgent.kindly help us on this.

Regards,
Ela
BlueMed Dev Team

Hi Ela,

When you generate the script you need to exclude this stored procedure as it is encrypted.
Then when you run the script on another SQL server you need to install the Ajax Filters again in order to have the stored procedure generated again and the Filters to work.
We have already discussed this here.

Thank you so much very much timely response..thanks a lot.

Regards,
Ela
BlueMed Dev Team