x
login Signup

My EFlow server stucks at step "INFO Making any necessary pre-schema-creation database setting changes" when connecting to MSSql server, what happend?

In the log there is no error found. but flow server just get stuck at this step.

Could you please help check what could be the reason for getting stuck at this step? What database settings changes need to made at this step? and what are the required access rights for those changes?

DB:MS SQL server 2016 Enterprise EFlow:9.0.1

avatar image By holy 47 asked Apr 18 at 11:49 PM
more ▼
(comments are locked)
10|750 characters needed characters left

2 answers: sort voted first

there are two SQL statements we run to configure the database properly:

ALTER DATABASE "xxx" SET allow_snapshot_isolation ON ALTER DATABASE "xxx" SET read_committed_snapshot ON WITH ROLLBACK IMMEDIATE

("xxx" is the name of the database instance.)

These two statements are required for SQL Server to work properly with ElectricFlow.

You might see if you can run those statements manually against the database GIC is using -- perhaps it's a permission error (though that doesn't explain why it hangs).

avatar image By holy 47 answered Apr 18 at 11:50 PM
more ▼
(comments are locked)
10|750 characters needed characters left

It turned out that they have turned on Database Audit which caused the hanging of executing statement ALTER DATABASE "xxx" SET allow_snapshot_isolation ON Now they turned off audit and we executed those two statements from SQL Management Suite successfully. Then DBA turned on audit again.

The Flow server started smoothly now. Thanks!

avatar image By holy 47 answered Apr 18 at 11:51 PM
more ▼
(comments are locked)
10|750 characters needed characters left
Your answer
toggle preview:

Up to 8 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.