Jump to content
Goldy

After upgraiding to 10.4.343, KSC not runing.[In progress]

Recommended Posts

Hi.

 

After upgrading to 10.4.343 (from 10.3.407) , KSC is not running any more:

 

Level Date and Time Source Event ID Task Category

Information 08/04/2017 16:22:13 klnagent 1 None Application 'Kaspersky Security 10 for Windows Server' started

Information 08/04/2017 16:22:10 klnagent 1 None Kaspersky Network Agent 10.4.343 started

Error 08/04/2017 16:21:06 kladminserver 1 None "Failed to run service ""kladminserver"". #1950 (1785) Generic db error: ""1785 '{42000} Introducing FOREIGN KEY constraint 'FK_pol_outbreak_policy__pol_policy_policy_id' on table 'pol_outbreak_policy' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.; Introducing FOREIGN KEY constraint 'FK_pol_outbreak_policy__pol_policy_policy_id' on table 'pol_outbreak_policy' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.' LastStatement='IF ([dbo].[upgd_if_constraint_exists]('FK_pol_outbreak_policy__pol_policy_policy_id') = 0)

ALTER TABLE pol_outbreak_policy

ADD

CONSTRAINT FK_pol_outbreak_policy__pol_policy_policy_id

FOREIGN KEY

(

nIdPolicy

) REFERENCES pol_policy (

policy_id

) ON DELETE CASCADE ON UPDATE CASCADE'"""

Error 08/04/2017 16:21:06 kladminserver 1 None "Service 'kladminserver' has been stopped due to an error. #1950 (1785) Generic db error: ""1785 '{42000} Introducing FOREIGN KEY constraint 'FK_pol_outbreak_policy__pol_policy_policy_id' on table 'pol_outbreak_policy' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.; Introducing FOREIGN KEY constraint 'FK_pol_outbreak_policy__pol_policy_policy_id' on table 'pol_outbreak_policy' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.' LastStatement='IF ([dbo].[upgd_if_constraint_exists]('FK_pol_outbreak_policy__pol_policy_policy_id') = 0)

ALTER TABLE pol_outbreak_policy

ADD

CONSTRAINT FK_pol_outbreak_policy__pol_policy_policy_id

FOREIGN KEY

(

nIdPolicy

) REFERENCES pol_policy (

policy_id

) ON DELETE CASCADE ON UPDATE CASCADE'"""

Information 08/04/2017 16:21:04 kladminserver 1 None Kaspersky Administration Server stopped.

Error 08/04/2017 16:21:04 kladminserver 1 None "Stop due to error. #1950 (1785) Generic db error: ""1785 '{42000} Introducing FOREIGN KEY constraint 'FK_pol_outbreak_policy__pol_policy_policy_id' on table 'pol_outbreak_policy' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.; Introducing FOREIGN KEY constraint 'FK_pol_outbreak_policy__pol_policy_policy_id' on table 'pol_outbreak_policy' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.' LastStatement='IF ([dbo].[upgd_if_constraint_exists]('FK_pol_outbreak_policy__pol_policy_policy_id') = 0)

ALTER TABLE pol_outbreak_policy

ADD

CONSTRAINT FK_pol_outbreak_policy__pol_policy_policy_id

FOREIGN KEY

(

nIdPolicy

) REFERENCES pol_policy (

policy_id

) ON DELETE CASCADE ON UPDATE CASCADE'"""

Error 08/04/2017 16:21:04 kladminserver 1 None "...upgrading Administration Server has completed with an error. Error: #1950 (1785) Generic db error: ""1785 '{42000} Introducing FOREIGN KEY constraint 'FK_pol_outbreak_policy__pol_policy_policy_id' on table 'pol_outbreak_policy' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.; Introducing FOREIGN KEY constraint 'FK_pol_outbreak_policy__pol_policy_policy_id' on table 'pol_outbreak_policy' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.' LastStatement='IF ([dbo].[upgd_if_constraint_exists]('FK_pol_outbreak_policy__pol_policy_policy_id') = 0)

ALTER TABLE pol_outbreak_policy

ADD

CONSTRAINT FK_pol_outbreak_policy__pol_policy_policy_id

FOREIGN KEY

(

nIdPolicy

) REFERENCES pol_policy (

policy_id

) ON DELETE CASCADE ON UPDATE CASCADE'"""

Error 08/04/2017 16:21:04 kladminserver 1 None "...upgrading Administration Server has completed with an error in script 1, batch 2377. Error: #1950 (1785) Generic db error: ""1785 '{42000} Introducing FOREIGN KEY constraint 'FK_pol_outbreak_policy__pol_policy_policy_id' on table 'pol_outbreak_policy' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.; Introducing FOREIGN KEY constraint 'FK_pol_outbreak_policy__pol_policy_policy_id' on table 'pol_outbreak_policy' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.' LastStatement='IF ([dbo].[upgd_if_constraint_exists]('FK_pol_outbreak_policy__pol_policy_policy_id') = 0)

ALTER TABLE pol_outbreak_policy

ADD

CONSTRAINT FK_pol_outbreak_policy__pol_policy_policy_id

FOREIGN KEY

(

nIdPolicy

) REFERENCES pol_policy (

policy_id

) ON DELETE CASCADE ON UPDATE CASCADE'"""

Error 08/04/2017 16:21:04 kladminserver 1 None "Database error occured: #1950 (1785) Generic db error: ""1785 '{42000} Introducing FOREIGN KEY constraint 'FK_pol_outbreak_policy__pol_policy_policy_id' on table 'pol_outbreak_policy' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.; Introducing FOREIGN KEY constraint 'FK_pol_outbreak_policy__pol_policy_policy_id' on table 'pol_outbreak_policy' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.' LastStatement='IF ([dbo].[upgd_if_constraint_exists]('FK_pol_outbreak_policy__pol_policy_policy_id') = 0)

ALTER TABLE pol_outbreak_policy

ADD

CONSTRAINT FK_pol_outbreak_policy__pol_policy_policy_id

FOREIGN KEY

(

nIdPolicy

) REFERENCES pol_policy (

policy_id

) ON DELETE CASCADE ON UPDATE CASCADE'"""

Information 08/04/2017 16:19:29 kladminserver 1 None Upgrading Administration Server...

Information 08/04/2017 16:17:50 klnagent 1 None Backup of Network Agent data successfully completed

Information 08/04/2017 16:17:50 klnagent 1 None Network Agent data backup.

Information 08/04/2017 16:17:47 klwebsrv 1 None Kaspersky Web Server has been started.

Information 08/04/2017 16:17:47 klactprx 1 None Kaspersky Lab activation proxy server service is running.

Information 08/04/2017 16:17:45 klactprx 1 None Starting the Kaspersky Lab activation proxy server service...

Information 08/04/2017 16:17:45 klwebsrv 1 None Attempt to start Kaspersky Web Server...

Information 08/04/2017 16:02:56 klsecuritycenter 1 None Performing backup of Administration Server

 

Hope somone can help me with it.

 

Goldy.

Share this post


Link to post
Hi.

 

After upgrading to 10.4.343 (from 10.3.407) , KSC is not running any more:

 

Level Date and Time Source Event ID Task Category

Information 08/04/2017 16:22:13 klnagent 1 None Application 'Kaspersky Security 10 for Windows Server' started

Information 08/04/2017 16:22:10 klnagent 1 None Kaspersky Network Agent 10.4.343 started

Error 08/04/2017 16:21:06 kladminserver 1 None "Failed to run service ""kladminserver"". #1950 (1785) Generic db error: ""1785 '{42000} Introducing FOREIGN KEY constraint 'FK_pol_outbreak_policy__pol_policy_policy_id' on table 'pol_outbreak_policy' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.; Introducing FOREIGN KEY constraint 'FK_pol_outbreak_policy__pol_policy_policy_id' on table 'pol_outbreak_policy' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.' LastStatement='IF ([dbo].[upgd_if_constraint_exists]('FK_pol_outbreak_policy__pol_policy_policy_id') = 0)

ALTER TABLE pol_outbreak_policy

ADD

CONSTRAINT FK_pol_outbreak_policy__pol_policy_policy_id

FOREIGN KEY

(

nIdPolicy

) REFERENCES pol_policy (

policy_id

) ON DELETE CASCADE ON UPDATE CASCADE'"""

Error 08/04/2017 16:21:06 kladminserver 1 None "Service 'kladminserver' has been stopped due to an error. #1950 (1785) Generic db error: ""1785 '{42000} Introducing FOREIGN KEY constraint 'FK_pol_outbreak_policy__pol_policy_policy_id' on table 'pol_outbreak_policy' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.; Introducing FOREIGN KEY constraint 'FK_pol_outbreak_policy__pol_policy_policy_id' on table 'pol_outbreak_policy' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.' LastStatement='IF ([dbo].[upgd_if_constraint_exists]('FK_pol_outbreak_policy__pol_policy_policy_id') = 0)

ALTER TABLE pol_outbreak_policy

ADD

CONSTRAINT FK_pol_outbreak_policy__pol_policy_policy_id

FOREIGN KEY

(

nIdPolicy

) REFERENCES pol_policy (

policy_id

) ON DELETE CASCADE ON UPDATE CASCADE'"""

Information 08/04/2017 16:21:04 kladminserver 1 None Kaspersky Administration Server stopped.

Error 08/04/2017 16:21:04 kladminserver 1 None "Stop due to error. #1950 (1785) Generic db error: ""1785 '{42000} Introducing FOREIGN KEY constraint 'FK_pol_outbreak_policy__pol_policy_policy_id' on table 'pol_outbreak_policy' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.; Introducing FOREIGN KEY constraint 'FK_pol_outbreak_policy__pol_policy_policy_id' on table 'pol_outbreak_policy' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.' LastStatement='IF ([dbo].[upgd_if_constraint_exists]('FK_pol_outbreak_policy__pol_policy_policy_id') = 0)

ALTER TABLE pol_outbreak_policy

ADD

CONSTRAINT FK_pol_outbreak_policy__pol_policy_policy_id

FOREIGN KEY

(

nIdPolicy

) REFERENCES pol_policy (

policy_id

) ON DELETE CASCADE ON UPDATE CASCADE'"""

Error 08/04/2017 16:21:04 kladminserver 1 None "...upgrading Administration Server has completed with an error. Error: #1950 (1785) Generic db error: ""1785 '{42000} Introducing FOREIGN KEY constraint 'FK_pol_outbreak_policy__pol_policy_policy_id' on table 'pol_outbreak_policy' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.; Introducing FOREIGN KEY constraint 'FK_pol_outbreak_policy__pol_policy_policy_id' on table 'pol_outbreak_policy' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.' LastStatement='IF ([dbo].[upgd_if_constraint_exists]('FK_pol_outbreak_policy__pol_policy_policy_id') = 0)

ALTER TABLE pol_outbreak_policy

ADD

CONSTRAINT FK_pol_outbreak_policy__pol_policy_policy_id

FOREIGN KEY

(

nIdPolicy

) REFERENCES pol_policy (

policy_id

) ON DELETE CASCADE ON UPDATE CASCADE'"""

Error 08/04/2017 16:21:04 kladminserver 1 None "...upgrading Administration Server has completed with an error in script 1, batch 2377. Error: #1950 (1785) Generic db error: ""1785 '{42000} Introducing FOREIGN KEY constraint 'FK_pol_outbreak_policy__pol_policy_policy_id' on table 'pol_outbreak_policy' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.; Introducing FOREIGN KEY constraint 'FK_pol_outbreak_policy__pol_policy_policy_id' on table 'pol_outbreak_policy' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.' LastStatement='IF ([dbo].[upgd_if_constraint_exists]('FK_pol_outbreak_policy__pol_policy_policy_id') = 0)

ALTER TABLE pol_outbreak_policy

ADD

CONSTRAINT FK_pol_outbreak_policy__pol_policy_policy_id

FOREIGN KEY

(

nIdPolicy

) REFERENCES pol_policy (

policy_id

) ON DELETE CASCADE ON UPDATE CASCADE'"""

Error 08/04/2017 16:21:04 kladminserver 1 None "Database error occured: #1950 (1785) Generic db error: ""1785 '{42000} Introducing FOREIGN KEY constraint 'FK_pol_outbreak_policy__pol_policy_policy_id' on table 'pol_outbreak_policy' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.; Introducing FOREIGN KEY constraint 'FK_pol_outbreak_policy__pol_policy_policy_id' on table 'pol_outbreak_policy' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.' LastStatement='IF ([dbo].[upgd_if_constraint_exists]('FK_pol_outbreak_policy__pol_policy_policy_id') = 0)

ALTER TABLE pol_outbreak_policy

ADD

CONSTRAINT FK_pol_outbreak_policy__pol_policy_policy_id

FOREIGN KEY

(

nIdPolicy

) REFERENCES pol_policy (

policy_id

) ON DELETE CASCADE ON UPDATE CASCADE'"""

Information 08/04/2017 16:19:29 kladminserver 1 None Upgrading Administration Server...

Information 08/04/2017 16:17:50 klnagent 1 None Backup of Network Agent data successfully completed

Information 08/04/2017 16:17:50 klnagent 1 None Network Agent data backup.

Information 08/04/2017 16:17:47 klwebsrv 1 None Kaspersky Web Server has been started.

Information 08/04/2017 16:17:47 klactprx 1 None Kaspersky Lab activation proxy server service is running.

Information 08/04/2017 16:17:45 klactprx 1 None Starting the Kaspersky Lab activation proxy server service...

Information 08/04/2017 16:17:45 klwebsrv 1 None Attempt to start Kaspersky Web Server...

Information 08/04/2017 16:02:56 klsecuritycenter 1 None Performing backup of Administration Server

 

Hope somone can help me with it.

 

Goldy.

 

Hello,

 

please attach installation logs.

Thank you.

 

Share this post


Link to post
Hello,

 

please attach installation logs.

Thank you.

 

 

where can i find it?

 

Share this post


Link to post

Having a similar issue after upgrade from 10.3.407 to 10.4.343. Uninstalled and reinstalled 10.3.407 and restored settings using KLBackup utility.

Share this post


Link to post

I'm using VM and before i upgraded, i took a snapshot, so going back is one click away...

:b_lol1:

Share this post


Link to post

Same here, but have had problems with reverting snapshots in regards to duplicate names in AD in our environment so I just manually uninstalled and reinstalled. I am curious as to why KSC would not open. I checked event log and there were no errors. Installed version 10.4.343 from scratch and KSC opened without an issue.

 

KSC is currently being used to manage KSV Agentless 3.1.0, KSV Light Agent 3.4.44, KES 10.2.5.3201

Share this post


Link to post
Same here, but have had problems with reverting snapshots in regards to duplicate names in AD in our environment so I just manually uninstalled and reinstalled. I am curious as to why KSC would not open. I checked event log and there were no errors. Installed version 10.4.343 from scratch and KSC opened without an issue.

 

KSC is currently being used to manage KSV Agentless 3.1.0, KSV Light Agent 3.4.44, KES 10.2.5.3201

 

Let's see if Kaspersky guys will com out with something.

As for now, i wouldn't recommend production IT to upgrade the SC.

Share this post


Link to post

Hi NVaZN.

 

Tried your suggestion.

 

I Uninstalled KSC and install the new one - all is well.

Open the new KSC - no problem.

Load the backup - the same issues as before.

KSC refuse to work.

Share this post


Link to post
Hello,

 

did you install it on a domain controller ?

Thank you.

 

Hello!

 

Please create a incident via companyaccount.kaspersky.com to investigate and solve this problem.

 

Thanks!

Share this post


Link to post
Hello!

 

Please create a incident via companyaccount.kaspersky.com to investigate and solve this problem.

 

Thanks!

 

I did.

They will return to me in 3 (???) business days.

Share this post


Link to post

Hi Goldy,

Yes I experienced the same exact issue after installing fresh copy. It worked until I loaded the backup. Unfortunately since KSC is being used for our VDI and Physical environment, I didn't have the time nor resources to work with support. I uninstalled and reinstalled version 10.3.407 of KSC and ran the KLBackup utility to restore and it worked. I found this thread to see when I was searching to see if anyone experienced a similar issue. Are you using any of the same components that I listed?

 

Hi NVaZN.

 

Tried your suggestion.

 

I Uninstalled KSC and install the new one - all is well.

Open the new KSC - no problem.

Load the backup - the same issues as before.

KSC refuse to work.

 

Share this post


Link to post
Hi NVaZN.

 

Tried your suggestion.

 

I Uninstalled KSC and install the new one - all is well.

Open the new KSC - no problem.

Load the backup - the same issues as before.

KSC refuse to work.

 

Hello.

 

As NVaZN suggests,a particular backup may be faulty, in which case you might try the previous one, or using the method described.

 

Thank you.

Share this post


Link to post
Hello.

 

As NVaZN suggests,a particular backup may be faulty, in which case you might try the previous one, or using the method described.

 

Thank you.

 

Tried it several times.

Like I said, KSC running on a virtual machine, so after every experiment, I go back to my original situation (previous version).

Saying that, every time I'm taking new backup, so unless something is wrong the way I do it (not my first time), I doubt it that all backups I took are corrupted.

Never the less, i have a Backup from a version before my current version (10.3.407) ,so I'll give it a try.

Share this post


Link to post
Tried it several times.

Like I said, KSC running on a virtual machine, so after every experiment, I go back to my original situation (previous version).

Saying that, every time I'm taking new backup, so unless something is wrong the way I do it (not my first time), I doubt it that all backups I took are corrupted.

Never the less, i have a Backup from a version before my current version (10.3.407) ,so I'll give it a try.

 

We will wait for the information from you.

 

Thanks!

Share this post


Link to post
We will wait for the information from you.

 

Thanks!

 

Nop.

 

didn't work with the old backup also.

It always work OK, until I load a any backup (or try to upgrade).

:dash1:

Edited by Goldy

Share this post


Link to post

Hi,

 

i have the same problem after upgrading.

I found out that my KAv Database was in am SQL 2000 compatible Mode.

I change it on the Database to SQL 2005 and the upgrade was successfully :-)

 

You ca try it.

 

 

Share this post


Link to post
Hi,

 

i have the same problem after upgrading.

I found out that my KAv Database was in am SQL 2000 compatible Mode.

I change it on the Database to SQL 2005 and the upgrade was successfully :-)

 

You ca try it.

Hi,

 

For your problem we have two script, for MySQL and for MS SQL. Please run one of this scripts on your server where installed your sql base for KSC.

Please inform us about result.

 

topic_368303_MSSQL.7z

topic_368303_MySQL.7z

 

Thank you!

Share this post


Link to post

Kaspersky support logged in my KSC server today and after a while and several checking they manage to fix the problem.

 

There was some problems encountered during the installation of Kaspersky Security Center server 10.4.343 version.

They ran a script that fixed those problems and restarted the Kaspersky Security Center Administration server service.

After that the Administration server service run successfully and the Console connected to the server.

 

Apparently it has something to with the data base (like it was mention here).

 

so for now - :bravo:

Edited by Goldy

Share this post


Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×

Important Information

We use cookies to make your experience of our websites better. By using and further navigating this website you accept this. Detailed information about the use of cookies on this website is available by clicking on more information.