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?
What is a prohibited database script?
Hi,
DROP VIEW IF EXISTS KNTestView
GO
Create View [dbo].[KNTestView]
as
Select * from XXXX
Can you please share the screenshot of that error?
There’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.
Hi
If you are looking for immediate support on this, I would recommend you to raise support.
Apparently this is happening due to a 3rd party license manager from EIS that is installed on this one instance.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.