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 ...solution for postgres 11 upgrade issues
When Supportcenter Plus is upgraded to 14300 or later, postgres is also upgraded to 11.17. If you are using bundled postgres, data migration through pgdump and restore mechanism also happens. To ensure efficiency in Postgres 11.17, make sure your ...SDP MSP solution for postgres 11 upgrade issues
When ServiceDesk Plus MSP is upgraded to 14300 or later, postgres is also upgraded to 11.17. If you are using bundled postgres, data migration through pgdump and restore mechanism also happens. To ensure efficiency in Postgres 11.17, make sure your ...Migration of SCP from one server to another
1. Stop the application on the production server. 2. Take a trimmed backup of the application (backup without attachments) if you are using the default PgSQL database. If you are using MSSQL, you can take a SQL backup (.bak). 3. Download and install ...