I ran into an error when publishing a customization project that I haven’t seen before: “The '<project name>' customization project contains a prohibited database script”. The customization has published without errors and the db script in it executes fine on many different Acumatica instances except for this particular one. The db script just drops a view if it exists, and then creates the view. The Acumatica build is 21.115.0017. The error shows up right away after selecting Publish. Did I miss something in the release notes somewhere where certain db commands are no longer allowed in scripts, or could it be a licensing or permissions issue of some kind?
Solved
What is a prohibited database script?
+1Best answer by Tony Lanzer
Apparently this is happening due to a 3rd party license manager from EIS that is installed on this one instance.
+19Hi,
DROP VIEW IF EXISTS KNTestView
GO
Create View [dbo].[KNTestView]
as
Select * from XXXX
Can you please share the screenshot of that error?
+1There’s no issue with my script. As I said, it executes fine on many instances. The issue is the error prohibiting the customization from publishing on this one instance.
+19Hi
If you are looking for immediate support on this, I would recommend you to raise support.
Naveen B - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
+1Apparently this is happening due to a 3rd party license manager from EIS that is installed on this one instance.
1 person likes this
+1I’m going to post a related question on this because it is actually related to an Acumatica-owned product - Imperium.
1 person likes this
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.