dahlholm Absent Member.
Absent Member.
2871 views

An error occurred while attempting to update the database

Hi
the update from 2.82 to 2.9.0 fails for me with following message
An error occurred while attempting to update the database.

the update log ends like this

[Microsoft][ODBC SQL Server Driver][SQL Server]DELETE failed because the
following SET options have incorrect settings: 'QUOTED_IDENTIFIER'. Verify
that SET options are correct for use with indexed views and/or indexes on
computed columns and/or filtered indexes and/or query notifications and/or XML
data type methods and/or spatial index operations.
1> 2> 3> [16:56:20] RunShellCommand: Command: osql exited with code: 1
[16:56:20] RunShellCommand: Exit code indicates failure.
[16:56:20] UpdateDatabase: Failed to run database update script.

hope that anyone can solv this for me
0 Likes
2 Replies
dahlholm Absent Member.
Absent Member.

Re: An error occurred while attempting to update the databas

It seems that my problem is with one of ldapservers.
When the periodic update runs.
then there will be error periodic update failed
log file mdm_error looks like this


[00:01:46] Failed running query:
IF NOT EXISTS(SELECT LDAPContainerName FROM LDAPContainers WHERE LDAPContainerName=? AND LDAPServerSAKey = ?)
BEGIN INSERT INTO LDAPContainers(LDAPContainerName, DisplayName, LDAPContainerType, ParentContainerSAKey,
LDAPServerSAKey, LDAPMemberType, AllowHandsOffEnrollment) VALUES (?,?, 2,
(SELECT LDAPContainerSAKey FROM LDAPContainers WHERE LDAPContainerName =? AND LDAPServerSAKey =?) , ?, 1, 1) END
SQLError:

I think this is the reason that the upgrade fails.
How can i solve this?
0 Likes
tech-man83 Absent Member.
Absent Member.

Re: An error occurred while attempting to update the databas

I just had an issue updating and got a similar message. Well at least regarding the QUOTED IDENTIFIER + Upgrade. Using the SQL management studio I ran something similar to this:

Delete from serverupdates


Mine had a couple of entries with garbage data causing the update to fail. It's a temporary table which stores data about the available updates, so quite safe to empty.
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.