Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Upgrade 8.02 -> 9.10 failure

SOLVED
Go to solution
Highlighted
hyllplan
Frequent Visitor

Upgrade 8.02 -> 9.10 failure

I get the following error during upgrade to 9.10, anyone that can give some advice?:

 

Passed:    Fri Sep 30 14:55:40 CEST 2011
Duration:  00h:00m:07s

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Task:      sqlscript UPDATE_KINS_ACTIONS
Started:   Fri Sep 30 14:55:40 CEST 2011
           This step has already been run and does not need to be run at this time
Passed:    Fri Sep 30 14:55:40 CEST 2011
Duration:  00h:00m:00s

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Task:      javaobject DSH_SEED
Started:   Fri Sep 30 14:55:40 CEST 2011
[javaobject] java.lang.reflect.InvocationTargetException
           This step has not been run, will run now
FAILED:    Fri Sep 30 14:55:46 CEST 2011
Duration:  00h:00m:05s

BUILD FAILED
D:\PPM\upgrade_910\xml\upgrade.xml:67: java.lang.reflect.InvocationTargetException

Total time: 8 minutes 4 seconds
java.lang.reflect.InvocationTargetException
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
 at java.lang.reflect.Method.invoke(Unknown Source)
 at com.kintana.upgrade.xml.elements.JavaTask.execute_params(JavaTask.java:130)
 at com.kintana.upgrade.xml.elements.JavaTask.execute_impl(JavaTask.java:68)
 at com.kintana.upgrade.xml.commands.JavaObjectCommand.runJavaObject(JavaObjectCommand.java:64)
 at com.kintana.upgrade.xml.commands.JavaObjectCommand.execute(JavaObjectCommand.java:45)
 at com.kintana.upgrade.xml.elements.JavaTask.execute(JavaTask.java:54)
 at org.apache.tools.ant.Task.perform(Task.java:364)
 at org.apache.tools.ant.Target.execute(Target.java:341)
 at org.apache.tools.ant.Target.performTasks(Target.java:369)
 at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1216)
 at org.apache.tools.ant.Project.executeTarget(Project.java:1185)
 at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:40)
 at org.apache.tools.ant.Project.executeTargets(Project.java:1068)
 at com.kintana.upgrade.xml.ItgCheema.runBuild(ItgCheema.java:432)
 at com.kintana.upgrade.xml.ItgCheema.start(ItgCheema.java:300)
 at com.kintana.ismp.bean.actions.CheemaRunner.action(CheemaRunner.java:98)
 at com.kintana.ismp.bean.actions.KintanaAction.execute(KintanaAction.java:90)
 at com.installshield.wizard.RunnableWizardBeanContext.run(RunnableWizardBeanContext.java:21)
Caused by: java.lang.RuntimeException: Seeding failed
 at com.mercury.dashboard.install.DashboardInstaller.seedDashboardData(DashboardInstaller.java:161)
 at com.mercury.dashboard.install.DashboardInstaller.seedDashboard(DashboardInstaller.java:139)
 at com.mercury.dashboard.install.DashboardInstaller.seedItgDashboard(DashboardInstaller.java:261)
 at com.mercury.dashboard.install.DashboardInstaller.seedItgDashboard(DashboardInstaller.java:245)
 ... 21 more

10 REPLIES
kintanadan
Regular Collector

Re: Upgrade 8.02 -> 9.10 failure

Can you post the tail end of the D:\PPMVE_TST\upgrade_910\logs\<highest number>\ppm_upgrade.log

 

Regards

hyllplan
Frequent Visitor

Re: Upgrade 8.02 -> 9.10 failure

Not much in there though... /Johan

 

(Sep 30, 2011 2:55:49 PM), , com.kintana.ismp.kupgrade.actions.SummaryScreenAction, dbg,
beanId:SummaryScreenAction description:The upgrade to HP Project and Portfolio Management Center Version 9.10 has failed. error message:Failed action(s):
Updating Dashboard seed data...
UpgradePPM

 logs:Main log:
D:\PPMVE_TST\upgrade_910\ppm_upgrade.log

Action log(s):
D:\PPMVE_TST\upgrade_910\logs\4/DB/UpgradePPM/upgrade-80-to-91.log
 whatToDoPlease review the log file(s) for the failed action. After you resolve the problem, you can rerun the upgrade. Although you will be prompted for the same information, the upgrade will continue from the point at which it failed.


(Sep 30, 2011 2:55:49 PM), , com.installshield.wizardx.conditions.PlatformWizardBeanCondition, dbg.platform, target platform: name="Windows 2003" version="5.2" arch="x86"
(Sep 30, 2011 2:55:49 PM), , com.installshield.wizardx.conditions.PlatformWizardBeanCondition, dbg.platform, condition platform: name="Windows .*" version="." arch="."
(Sep 30, 2011 2:55:49 PM), , com.kintana.ismp.bean.actions.WindowsServicePerServerAction, msg1, Kintana Action: bean ID:WindowsServiceInstall
(Sep 30, 2011 2:55:49 PM), , com.kintana.ismp.bean.actions.WindowsServicePerServerAction, msg1, Install Service for server PPM_VE_SRV
(Sep 30, 2011 2:55:49 PM), , com.kintana.ismp.bean.actions.WindowsServicePerServerAction, msg1, Install Service for server PPM_VE_USR_1
(Sep 30, 2011 2:55:49 PM), , com.kintana.ismp.bean.actions.WindowsServicePerServerAction, msg1, Install Service for server PPM_VE_USR_2
(Sep 30, 2011 2:55:49 PM), , com.kintana.ismp.kupgrade.actions.SummaryLogAction, msg1, ALL ACTIONS FINISHED WITH FAILURE
(Sep 30, 2011 2:55:49 PM), , com.kintana.ismp.kupgrade.actions.SummaryLogAction, msg1, Failed steps: UpgradePPM:DSH_SEED, UpgradePPM
(Sep 30, 2011 2:55:49 PM), , com.kintana.ismp.kupgrade.conditions.UpgradeToVersion, msg1, upgradeTo=$W(Version.upgradingTo),str=9,1,0,4982
(Sep 30, 2011 2:55:49 PM), , com.kintana.ismp.kupgrade.conditions.UpgradeToVersion, msg1, Checking version. UpgradeToVersion: before bean: InstallAction
(Sep 30, 2011 2:55:49 PM), , com.kintana.ismp.kupgrade.conditions.UpgradeToVersion, msg1, Versions: is 8.0.2.343 less than 9.1.0.4982?
(Sep 30, 2011 2:55:49 PM), , com.kintana.ismp.kupgrade.conditions.UpgradeToVersion, msg1, upgradeTo=$P(description),str=9,1,0,4982
(Sep 30, 2011 2:55:49 PM), , com.kintana.ismp.kupgrade.conditions.UpgradeToVersion, msg1, Checking version. UpgradeToVersion: before bean: CleanDeploy
(Sep 30, 2011 2:55:49 PM), , com.kintana.ismp.kupgrade.conditions.UpgradeToVersion, msg1, Versions: is 8.0.2.343 less than 9.1.0.4982?
(Sep 30, 2011 2:55:49 PM), , com.kintana.ismp.kupgrade.conditions.UpgradeToVersion, msg1, upgradeTo=$P(description),str=9,1,0,4982
(Sep 30, 2011 2:55:49 PM), , com.kintana.ismp.kupgrade.conditions.UpgradeToVersion, msg1, Checking version. UpgradeToVersion: before bean: FileSystemCleanup
(Sep 30, 2011 2:55:49 PM), , com.kintana.ismp.kupgrade.conditions.UpgradeToVersion, msg1, Versions: is 8.0.2.343 less than 9.1.0.4982?
(Sep 30, 2011 2:55:49 PM), , com.kintana.ismp.kupgrade.conditions.UpgradeToVersion, msg1, upgradeTo=$L(com.kintana.ismp.kupgrade.i18n.Upgrade,Constants.KNTA_PPM),str=9.1.0.0
(Sep 30, 2011 2:55:49 PM), , com.kintana.ismp.kupgrade.conditions.UpgradeToVersion, msg1, Checking version. UpgradeToVersion: before bean: wizardSequence
(Sep 30, 2011 2:55:49 PM), , com.kintana.ismp.kupgrade.conditions.UpgradeToVersion, msg1, Versions: is 8.0.2.343 less than 9.1.0.0?

Kerim KILIC
Frequent Visitor

Re: Upgrade 8.02 -> 9.10 failure

seems something wrong with seed data, this is a test env right? can you try to exp imp from prod and run upgrade again? and also please submit whole log file.
hyllplan
Frequent Visitor

Re: Upgrade 8.02 -> 9.10 failure

We did exp / imp before upgrade. It is prod data. Seed data, wahat is the definition of that?

Kerim KILIC
Frequent Visitor

Re: Upgrade 8.02 -> 9.10 failure

hi,

 

error comes at this line

 

try {
      ImportPreferences prefs = new ImportPreferences(replacePortletDefs, replaceModules, true, null);
      boolean successful = importDashboardObjects(userContext, seedDataFileName, prefs);
      if (!successful) {
        throw new RuntimeException("Seeding failed");
      }

      logger.debug("Installing dashboard data completed");
    } catch (Exception e) {
      logger.debug("Installing dashboard data failed");
      throw e;
    }

 

did you take any error at prevalidation step? and can you please try with fresh upgrade bundle, may be the files you are using for upgrade are corrupted.

 

regards

hyllplan
Frequent Visitor

Re: Upgrade 8.02 -> 9.10 failure

Yes I did a successful prevalidation. Here´s the dashboard_install.log with the actual error:

 

[DEBUG] 30 Sep 2011 14:55:40 (DashboardInstaller.java:seedDashboard:136)
Installing dashboard data...

[DEBUG] 30 Sep 2011 14:55:46 (DashboardInstaller.java:importDashboardObjects:201)
Importing module: Standard PPM Dashboard<br>Module already exists. <b>NOT</b> replacing.<br>Importing module: Demand Manager<br>Module already exists. <b>NOT</b> replacing.<br>Importing module: Portfolio Manager<br>Module already exists. <b>NOT</b> replacing.<br>Importing module: Program Manager<br>Module already exists. <b>NOT</b> replacing.<br>Importing module: Team Manager<br>Module already exists. <b>NOT</b> replacing.<br>Importing module: Time Management<br>Module already exists. <b>NOT</b> replacing.<br>Importing module: Capital Exposure<br>Module already exists. <b>NOT</b> replacing.<br>Importing module: Create Module<br>Module already exists. <b>NOT</b> replacing.<br>Importing portlet definition: Request Activity<br>Portlet definition already exists. Replacing.<br>Importing portlet definition: Open Requests by Priority<br>Portlet definition already exists. Replacing.<br>Importing portlet definition: Request Summary<br>Portlet definition already exists. Replacing.<br>Importing portlet definition: Package Activity<br>Portlet definition already exists. Replacing.<br>Importing portlet definition: Summary Task List<br>Portlet definition already exists. Replacing.<br>Importing portlet definition: Request List<br>Portlet definition already exists. Replacing.<br>Importing portlet definition: Project Current Cost Metrics<br>Portlet definition already exists. Replacing.<br>Importing portlet definition: Project Cost Summary<br>Portlet definition already exists. Replacing.<br>Importing portlet definition: Program Cost Summary<br>Portlet definition already exists. Replacing.<br>Importing portlet definition: Resource Gantt<br>Portlet definition already exists. Replacing.<br>Importing portlet definition: Project Gantt<br>Portlet definition already exists. Replacing.<br>Importing portlet definition: Analyze Assignment Load<br>Portlet definition already exists. Replacing.<br>java.lang.reflect.InvocationTargetException
 at sun.reflect.GeneratedMethodAccessor397.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
 at java.lang.reflect.Method.invoke(Unknown Source)
 at com.mercury.dashboard.app.migrator.abs.AbstractXMLHandlersManager.handle(AbstractXMLHandlersManager.java:84)
 at com.mercury.dashboard.app.migrator.df45.importing.ExportListImporter.handleReplacePortletDefinitions(ExportListImporter.java:237)
 at com.mercury.dashboard.app.migrator.df45.importing.ExportListImporter.save(ExportListImporter.java:85)
 at com.mercury.dashboard.app.migrator.ImportController.XmlAnnotationsImport(ImportController.java:158)
 at com.mercury.dashboard.app.migrator.ImportController.newImportObjects(ImportController.java:112)
 at com.mercury.dashboard.app.migrator.ImportController.importObjects(ImportController.java:83)
 at com.mercury.dashboard.install.DashboardInstaller.importDashboardObjects(DashboardInstaller.java:193)
 at com.mercury.dashboard.install.DashboardInstaller.seedDashboardData(DashboardInstaller.java:159)
 at com.mercury.dashboard.install.DashboardInstaller.seedDashboard(DashboardInstaller.java:139)
 at com.mercury.dashboard.install.DashboardInstaller.seedItgDashboard(DashboardInstaller.java:261)
 at com.mercury.dashboard.install.DashboardInstaller.seedItgDashboard(DashboardInstaller.java:245)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
 at java.lang.reflect.Method.invoke(Unknown Source)
 at com.kintana.upgrade.xml.elements.JavaTask.execute_params(JavaTask.java:130)
 at com.kintana.upgrade.xml.elements.JavaTask.execute_impl(JavaTask.java:68)
 at com.kintana.upgrade.xml.commands.JavaObjectCommand.runJavaObject(JavaObjectCommand.java:64)
 at com.kintana.upgrade.xml.commands.JavaObjectCommand.execute(JavaObjectCommand.java:45)
 at com.kintana.upgrade.xml.elements.JavaTask.execute(JavaTask.java:54)
 at org.apache.tools.ant.Task.perform(Task.java:364)
 at org.apache.tools.ant.Target.execute(Target.java:341)
 at org.apache.tools.ant.Target.performTasks(Target.java:369)
 at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1216)
 at org.apache.tools.ant.Project.executeTarget(Project.java:1185)
 at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:40)
 at org.apache.tools.ant.Project.executeTargets(Project.java:1068)
 at com.kintana.upgrade.xml.ItgCheema.runBuild(ItgCheema.java:432)
 at com.kintana.upgrade.xml.ItgCheema.start(ItgCheema.java:300)
 at com.kintana.ismp.bean.actions.CheemaRunner.action(CheemaRunner.java:98)
 at com.kintana.ismp.bean.actions.KintanaAction.execute(KintanaAction.java:90)
 at com.installshield.wizard.RunnableWizardBeanContext.run(RunnableWizardBeanContext.java:21)
Caused by: com.mercury.dashboard.arch.InternalDashboardException: null index column for collection: com.mercury.dashboard.model.portletdef.BuilderPortletDefinitionPreference.localizedProperties
 at com.mercury.dashboard.arch.hibernate.HibernateTransaction.delete(HibernateTransaction.java:97)
 at com.mercury.dashboard.arch.hibernate.HibernateTransaction.deleteAll(HibernateTransaction.java:126)
 at com.mercury.dashboard.app.migrator.df45.importing.AbstractObjectCreator.deleteCollection(AbstractObjectCreator.java:65)
 at com.mercury.dashboard.app.migrator.df45.importing.ReplacePortletDefinitionHandler.handleBuilderPortletDefinition(ReplacePortletDefinitionHandler.java:259)
 at com.mercury.dashboard.app.migrator.df45.importing.ReplacePortletDefinitionHandler.handle(ReplacePortletDefinitionHandler.java:78)
 ... 35 more
Caused by: org.hibernate.HibernateException: null index column for collection: com.mercury.dashboard.model.portletdef.BuilderPortletDefinitionPreference.localizedProperties
 at org.hibernate.persister.collection.AbstractCollectionPersister.readIndex(AbstractCollectionPersister.java:710)
 at org.hibernate.collection.PersistentMap.readFrom(PersistentMap.java:258)
 at org.hibernate.loader.Loader.readCollectionElement(Loader.java:1008)
 at org.hibernate.loader.Loader.readCollectionElements(Loader.java:646)
 at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:591)
 at org.hibernate.loader.Loader.doQuery(Loader.java:701)
 at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
 at org.hibernate.loader.Loader.loadCollection(Loader.java:1994)
 at org.hibernate.loader.collection.CollectionLoader.initialize(CollectionLoader.java:36)
 at org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:565)
 at org.hibernate.event.def.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:60)
 at org.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java:1716)
 at org.hibernate.collection.AbstractPersistentCollection.initialize(AbstractPersistentCollection.java:344)
 at org.hibernate.collection.AbstractPersistentCollection.read(AbstractPersistentCollection.java:86)
 at org.hibernate.collection.PersistentMap.values(PersistentMap.java:234)
 at org.hibernate.type.MapType.getElementsIterator(MapType.java:39)
 at org.hibernate.type.CollectionType.getElementsIterator(CollectionType.java:200)
 at org.hibernate.engine.CascadingAction.getAllElementsIterator(CascadingAction.java:415)
 at org.hibernate.engine.CascadingAction.access$100(CascadingAction.java:27)
 at org.hibernate.engine.CascadingAction$1.getCascadableChildrenIterator(CascadingAction.java:125)
 at org.hibernate.engine.Cascade.cascadeCollectionElements(Cascade.java:294)
 at org.hibernate.engine.Cascade.cascadeCollection(Cascade.java:242)
 at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:219)
 at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:169)
 at org.hibernate.engine.Cascade.cascade(Cascade.java:130)
 at org.hibernate.event.def.DefaultDeleteEventListener.cascadeBeforeDelete(DefaultDeleteEventListener.java:307)
 at org.hibernate.event.def.DefaultDeleteEventListener.deleteEntity(DefaultDeleteEventListener.java:246)
 at org.hibernate.event.def.DefaultDeleteEventListener.onDelete(DefaultDeleteEventListener.java:141)
 at org.hibernate.event.def.DefaultDeleteEventListener.onDelete(DefaultDeleteEventListener.java:52)
 at org.hibernate.impl.SessionImpl.fireDelete(SessionImpl.java:766)
 at org.hibernate.impl.SessionImpl.delete(SessionImpl.java:744)
 at com.mercury.dashboard.arch.hibernate.HibernateTransaction.delete(HibernateTransaction.java:95)
 ... 39 more


[DEBUG] 30 Sep 2011 14:55:46 (DashboardInstaller.java:seedDashboardData:166)
Installing dashboard data failed

 

Kerim KILIC
Frequent Visitor

Re: Upgrade 8.02 -> 9.10 failure

hi

may be this is helpful

 

Caused by: org.hibernate.HibernateException: null index column for collection: com.mercury.dashboard.model.portletdef.BuilderPort

letDefinitionPreference.localizedProperties

can you check null data in the tables for analyze assignment load portlet

hyllplan
Frequent Visitor

Re: Upgrade 8.02 -> 9.10 failure

Im not sure what tables or columns to check how would i find out?
Abhi_Agrawal
Regular Collector

Re: Upgrade 8.02 -> 9.10 failure

Mainly in KRSC_RSC_POOL_PERIOD_SUM and RSC_RP_DISTRIBUTION_ENTRIES tables

hyllplan
Frequent Visitor
Solution

Re: Upgrade 8.02 -> 9.10 failure

Solution;

We have  build our own language pack and the installation did not like that, we had to add:
sv= Swedish
to SupportedLanguages.properties
in upgrade_910\lib\dashboard-install.jar\com\mercury\dashboard\
 
that did the trick

However we still have problems with the newly created langpack not applying properly in 9.12, we have to manully apply stuff in the dashboard.jar file. For some reason it is just skipping to fix that file during kDeploy -lang sv. Someone that also created their own langpack?
//Add this to "OnDomLoad" event