Who Me Too'd this topic

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Who Me Too'd this topic

Install fails with "Alter database statement not allowed within multi-statement transaction"

A little bit of background: after failing to install the AWS ePO Quickstart repeatedly with little feedback as to why, I instead opted to try manually installing the application on EC2 instances using the installation package. I created a fairly basic SQL Server 2017 RDS instance, then started the installer. It consistently errors out, with this indicated in the core-install log:

[echo] Executing turn_off_snapshot_isolation_level.sql ...
[run-sql]
[run-sql] ****** Failed to execute the following SQL due to SQLException: ALTER DATABASE statement not allowed within multi-statement transaction.
[run-sql]
[run-sql] [run-sql] -- Get the current database name.
[run-sql] DECLARE @dbname nvarchar(127) = (SELECT DB_NAME())
[run-sql]
[run-sql] -- Set single_user mode since we cannot change the state of read_committed_snapshot if any other connections are open.
[run-sql] exec ('ALTER DATABASE [' + @dbname + '] SET SINGLE_USER WITH ROLLBACK IMMEDIATE');
[run-sql]
[run-sql] exec('ALTER DATABASE [' + @dbname + '] set read_committed_snapshot off with NO_WAIT');
[run-sql] -- exec('ALTER DATABASE [' + @dbname + '] set allow_snapshot_isolation off');
[run-sql]
[run-sql] -- Reset back to multi-user mode.
[run-sql] exec ('ALTER DATABASE [' + @dbname + '] SET MULTI_USER');

BUILD FAILED C:\Program Files (x86)\McAfee\ePolicy Orchestrator\Installer\core\build.xml:1268:
The following error occurred while executing this line:
C:\Program Files (x86)\McAfee\ePolicy Orchestrator\Installer\core\build.xml:711: java.sql.SQLException: ALTER DATABASE statement not allowed within multi-statement transaction.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:373)

The exception goes on. Is there something I'm missing?

Who Me Too'd this topic

Community Help Hub

    New to the forums or need help finding your way around the forums? There's a whole hub of community resources to help you.

  • Find Forum FAQs
  • Learn How to Earn Badges
  • Ask for Help
Go to Community Help

Join the Community

    Thousands of customers use the McAfee Community for peer-to-peer and expert product support. Enjoy these benefits with a free membership:

  • Get helpful solutions from McAfee experts.
  • Stay connected to product conversations that matter to you.
  • Participate in product groups led by McAfee employees.
Join the Community
Join the Community