Migration failure after 9414- ChangeConfigurations table
Error Trace:
[SYSERR] [INFO] : org.xml.sax.SAXException: Already a row with the same set of primary keys found in this object, this row <ChangeConfigurations CONFIG_ID="1" CATEGORY="GlobaEditOnAllStages" PARAMETER="IsCOAllowed" PARAMVALUE="false" DESCRIPTION="Indicates whether or not to allow the Change Owner to globally Edit a Change Request in all the stages of the change." /> already exists in this dataobject <WritableDataObject><Tables>
Solution:
Please follow the given steps and try to upgrade again:
1)Run the following update queries:
1. update uvhvalues set genvalues=2 where pattern like '%ChangeConfigurations:CONFIG_ID:2%';
2. update changeconfigurations set config_id=2 where category='GlobaEditOnAllStages';
2)Run the insert query:
insert into changeconfigurations values(1,'StatusUpdateNotification','IsViewable','false',' Change stage and status update message along with notification sent status ');
New to ADSelfService Plus?
Related Articles
Migration failure for Postgres Database with a blank space in it
Trace : \ManageEngine\ServiceDesk\Patch\AdventNet_ManageEngine_ServiceDesk_Plus-14.2.0-SP-1.0.0\SERVICEDESK\PreInstall\pg_migrate\pgsql_old\bin\pg_dumpall.exe", -U, postgres, -p, 65433, -h, 127.0.0.1, -r, -w, |, ...Upgrade failure when migrating privileges for removed functions
LOG Trace : 03.08.2023 12:50:36 [com.zoho.postgres.migrate.DumpMigration] [SCHWERWIEGEND] : Problem during upgrade.com.zoho.postgres.exception.MigrationFailureException: Restoration failed for PRE_DATA at ...Upgrade Failure due to the presence of CtrlZ Failure
This issue (SD-118352) in fixed in version 14710. Post this release, these characters are handled in the migration itself. If you are planning to migrate from version less than 14610 to 14610, then you can directly migrate to 14710, to handle this ...Data Migration - ESM Build
Requirement: All the tickets that are assigned to specific sites has to be moved to a corresponding instances that are built for the sites. For example: Site A ticket from IT instance should be moved to Instance A. The tickets once moved should be ..."General failure while fetching agent configuration" when accessing Agent Configuration page with "NatAddress" not found trace.
Issue: "General failure while fetching agent configuration" error message is showing up when accessing Agent Configuration page under Admin -> Discovery. This happens in two cases. Case 1: Build Version: DC - 11.1.2240.1 and above. Trace: SDP: ...