Bacpac fails with error SQL71501

Question

Hi

I have been trying to backup an Azure SQL database. The size is precariously close to the Standard Tier limit of 1TB. I have been trying to backup to BLOB storage, but get the following error after only a minute.

One or more unsupported elements were found in the schema used as part of a data package.
Error SQL71501: Error validating element [jobs].[job_versions]: View: [jobs].[job_versions] contains an unresolved reference to an object. Either the object does not exist or the reference is ambiguous because it could refer to any of the following objects: [jobs_internal].[job_versions].[job_version_number], [jobs_internal].[job_versions].[jv] or [jobs_internal].[visible_jobs].[jv].

Is this a BLOB Storage size issue? Also the error is referring to views which are system created and not ones that I have implemented

Answer 1

It seems to me you are making reference to SQL Server jobs or Elastic Jobs inside that database. It seems you make reference to them to know the status or results of scheduled job executions from inside that database. Please examine the programming objects and views making reference to those jobs and remove those references.

Examine a view or object named [jobs].[job_versions]. To create a bacpac you need to eliminate external references (to objects not stored in this database)

NOTE ADDED Dec 14, 2021:
On Azure DevOps you may receive this error SQL71501 if the builds are targeting Azure SQL Database but they use a feature like File Table that is not supported on Azure SQL. Changing the target to SQL Server (if Production servers are SQL Server instances) can solve the issue.