I am planning to upgrade MWS from 10.5 to 10.15 and gonna use migration utility.
I’ve installed MWS 10.15 with fixes and have given cloned database URL of old version.
Have migrated cloned database component to latest version using db configurator.
But MWS 10.15 is not coming Up with cloned database.
I’ve observed MWS 10.15 is coming up by creating new database component.
Can I use new database component to make MWS up and provide cloned database URL during running custom migration utility to migrate the old version instance?
Im not sure I understand what you mean with the above?
You can use a new DB for newly created instance or use cloned DB for migrations. What is the error you get when you run the migrated MWS against the cloned and migrated DB.
Did you shutdown MWS before running the migration scripts? Make sure you shut everything down (IS and MWS and possibly Optimize, basically everything that has access to the cloned db) before running the migration scripts. Also check the clusters from mws and make sure the old installation and new installations are not in a cluster and edit cluster.xml file and deploy it back it they are clustered with old installation.
You can run migration scripts again, they may have failed. When you run migration scripts again, please take a copy of the logs and share them here if the issue persists.
I’m having the same issue of MWS shutting down automatically because of failure in db configuration. I tried shutting down MWS and then installing db migration scripts. However, the migration script for MWS keeps on failing with the output:
error: java.sql.SQLIntegrityConstraintViolationException: [SoftwareAG][Oracle JDBC Driver][Oracle]ORA-01400: cannot insert NULL into (“WEBM_COPY”.“COMPONENT_EVENT”.“COMPONENT_EVENT_ID”)
on {webMethods1015 dir}/common/db/MywebMethodsServer/MywebMethodsServer/scripts/10.5.fix1-10.7/oracle/migrate.sql
It seems to run fine on all the folders with names < 10.5. I’m trying to upgrade webMethods 10.5 to 10.15. Furthermore, the db configuration seems to work fine for TN, IS, Process Engine and Process Audit.
Here is a snippet from the log file with the error:
Runner # 93 | c.s.d.a.Runner . run | java.lang.RuntimeException: java.sql.SQLIntegrityConstraintViolationException: [SoftwareAG][Oracle JDBC Driver][Oracle]ORA-01400: cannot insert NULL into (“WEBM_COPY”.“COMPONENT_EVENT”.“COMPONENT_EVENT_ID”)