What have you done to debug it? Have you determined which call to the stored procedure is breaking? (i.e., what parameters?). You may have to use extended events or a...

msdb, model, & tempdb can be moved through relatively normal means (though you have to restart SQL Server afterwards).

master requires modifying startup parameters and the registry... and maybe a prayer...

Your odds might be better in an Oracle forum  like Oracle Communities or orafaq than in a Microsoft SQL Server forum.

Microsoft says you can, but recommends excluding most folders and file types associated with SQL Server: https://support.microsoft.com/en-us/topic/how-to-choose-antivirus-software-to-run-on-computers-that-are-running-sql-server-feda079b-3e24-186b-945a-3051f6f3a95b#:~:text=You%20can%20run%20antivirus%20software,is%20a%20cluster%2Daware%20version.&text=C%3A%5CWindows%5CCluster

... as well as the following on cluster servers:

Q:\ (Quorum drive)

C:\Windows\Cluster

MSDTC directory in...

Why the empty date shows '1900-01-01' and how to avoid?

Because that's what an empty string casts to (the equivalent of 0).

If you want NULL, use NULL instead of empty string.

What...

What version/patch # is the server at?

What ODBC driver version is each client using? Do they have identical hardware (CPU, amount of RAM, speed of RAM, etc.)?

Are they pointing at...

Ideally from the source/designer of the XML. Barring that, maybe Generate an Inline XSD Schema

Here's another link: Generate XSD from Sql query using FOR XML

This is a  post to the more appropriate forum of the question asked in Metrics/Order Detail -MSSQL, in which you were repeatedly, politely asked NOT to post excel file...

https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help

Posting consumable DDL & data serves several purposes:

• It saves time for the people whom you are asking to help you.
• It protects the people whom you are asking to...

https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/database-level-roles?view=sql-server-ver15

Only db_ddl_admin & db_owner roles inherently have create table permissions.

db_datareader, db_denydatareader, db_datawriter, & db_denydatawriter roles do not.

1. No, you can't restore from a newer version to an older version. You would have to rebuild the database -- scripts, Copy Database wizard in SSMS, Export Data, etc.

2....

It would help if you provided DDL and insert statements for data... and if your query column names matched those you provided in the table descriptions -- WorkCenterName != WCName

Given...

TLDR: Analyze server specs, compare to actual workload, & test consolidation.

It's not really about the version of SQL Server, but about the size/rate of transactions (inserts, updates, deletes), the size/rate...

Is the font installed on the server where SSRS is running?

That is where the export takes place, and where the font has to be embedded in the PDF. Font embedding...

Not sure what you mean by generic, but a report with barcodes doesn't sound generic.

How are the bar codes generated? Given the behavior, I suspect they are using a bar...