Topic
  • 7 replies
  • Latest Post - ‏2013-03-25T15:42:30Z by kuki2333
kuki2333
kuki2333
24 Posts

Pinned topic Upgrade from IBM BPM 8.0.0 to IBM BPM 8.0.1

‏2013-03-24T21:57:37Z |
We tried to upgrade BPM and had some errors ,can i please have stages for doing such an upgrade .We using DB2 as the db backend.
Updated on 2013-03-25T15:42:30Z at 2013-03-25T15:42:30Z by kuki2333
  • kuki2333
    kuki2333
    24 Posts

    Re: Upgrade from IBM BPM 8.0.0 to IBM BPM 8.0.1

    ‏2013-03-24T22:01:26Z  
    We running AIX
  • kolban
    kolban
    3322 Posts

    Re: Upgrade from IBM BPM 8.0.0 to IBM BPM 8.0.1

    ‏2013-03-24T22:25:58Z  
    • kuki2333
    • ‏2013-03-24T22:01:26Z
    We running AIX
    Hi there,
    See the following InfoCenter article:

    http://pic.dhe.ibm.com/infocenter/dmndhelp/v8r0m1/topic/com.ibm.wbpm.imuc.doc/topics/tmig_upgrading_bpm.html

    Neil
  • vlit
    vlit
    933 Posts

    Re: Upgrade from IBM BPM 8.0.0 to IBM BPM 8.0.1

    ‏2013-03-25T07:05:31Z  
    Is is not a forum of extrasenses.
    Please publish your errors.

    Vladlen | http://bpmadmin.blogspot.com
  • kolban
    kolban
    3322 Posts

    Re: Upgrade from IBM BPM 8.0.0 to IBM BPM 8.0.1

    ‏2013-03-25T14:53:14Z  
    • vlit
    • ‏2013-03-25T07:05:31Z
    Is is not a forum of extrasenses.
    Please publish your errors.

    Vladlen | http://bpmadmin.blogspot.com
    Vladlen,
    Really ... hmmm.

    In my opinion my next 4 answers to questions not yet asked will be:

    1. Yes definitely.
    2. Only on Sundays.
    3. IBM wanted to make that work but the person who knew how to do that won the lottery.
    4. I understand, I grew up with a sheep too.

    Neil
  • kuki2333
    kuki2333
    24 Posts

    Re: Upgrade from IBM BPM 8.0.0 to IBM BPM 8.0.1

    ‏2013-03-25T15:36:01Z  
    • kolban
    • ‏2013-03-25T14:53:14Z
    Vladlen,
    Really ... hmmm.

    In my opinion my next 4 answers to questions not yet asked will be:

    1. Yes definitely.
    2. Only on Sundays.
    3. IBM wanted to make that work but the person who knew how to do that won the lottery.
    4. I understand, I grew up with a sheep too.

    Neil
    Hi These are the steps I am following ,but when we did the upgrade ,one of the Messeging Engines failed to startup and we had some DB2 errors during upgrade

    Please confirm if this is the right procedure and am not sure of Step 14 if we need to run upgrade scripts for the DB manually first on DB2 or if it is run automatically .

    Upgrade procedure for ProdSim:

    Upgrade DMGR on usopap1

    1. Upgrade Installation Manager to V1.6.1

    2. Stop all processes (DMGR, Nodes, servers and HTTP servers)

    3. Make a backup of the whole /web/WebSphere8ND/bpm directory

    4. Make a backup of the whole /web/WebSphere7ND/im directory

    5. Backup Config and Databases

    6. Install 8.0.1 using IM

    7. Install iFix JR44669

    8. Install 8.0.0.4-WS-WASProd-IFPM72955

    9. Install 8.0.0.5-WS-WAS-IFPM74175

    10. Install 8.0.0.0-WS-WAS-IFPM75937

    11. Install 8.0.0.3-WS-WAS-IFPM75338

    12. Install 8.0.0.3-WS-WASND-IFPM75877

    13. Generate sql scripts to upgrade databases

    /web/WebSphere8ND/bpm/bin/BPMGenerateUpgradeSchemaScripts.sh -upgrade 8.0.0.0 BPMPSDmgr01

    The SQL scripts are stored in /web/WebSphere8ND/bpm/profiles/BPMPSDmgr01/dbscripts/component_name

    14. Upgrade Databases using generated scripts

    15. Start DMGR

    Upgrade Managed Nodes usopap2 (Only do where managed node is not installed on same LPAR as DMGR)

    1. Upgrade Installation Manager to V1.6.1

    2. Stop all processes (Nodes and servers)

    3. Make a backup of the whole /web/WebSphere8ND/bpm directory

    4. Make a backup of the whole /web/WebSphere7ND/im directory

    5. Backup Config

    6. Install 8.0.1 using IM

    7. Install iFix JR44669

    8. Install 8.0.0.4-WS-WASProd-IFPM72955

    9. Install 8.0.0.5-WS-WAS-IFPM74175

    10. Install 8.0.0.0-WS-WAS-IFPM75937

    11. Install 8.0.0.3-WS-WAS-IFPM75338

    12. Install 8.0.0.3-WS-WASND-IFPM75877

    Upgrade Clusters on the DMGR node usopap1

    1. Stop DMGR

    2. /web/WebSphere8ND/bpm/bin/ws_ant.sh -f /web/WebSphere8ND/bpm/util/upgrade/BPMProfileUpgrade.ant -profileName BPMPSDmgr01 -Dupgrade=true -Duser=wasadmin -Dpassword=xxxx -Dcluster=BPMPS.AppTarget

    /web/WebSphere8ND/bpm/bin/ws_ant.sh -f /web/WebSphere8ND/bpm/util/upgrade/BPMProfileUpgrade.ant -profileName BPMPSDmgr01 -Dupgrade=true -Duser=wasadmin -Dpassword=xxxx -Dcluster=BPMPS.Messaging

    /web/WebSphere8ND/bpm/bin/ws_ant.sh -f /web/WebSphere8ND/bpm/util/upgrade/BPMProfileUpgrade.ant -profileName BPMPSDmgr01 -Dupgrade=true -Duser=wasadmin -Dpassword=xxxx -Dcluster=BPMPS.Support

    /web/WebSphere8ND/bpm/bin/ws_ant.sh -f /web/WebSphere8ND/bpm/util/upgrade/BPMProfileUpgrade.ant -profileName BPMPSDmgr01 -Dupgrade=true -Duser=wasadmin -Dpassword=xxxx -Dcluster=BPMPS.WebApp

    3. Update Database data on usopap1

    /web/WebSphere8ND/bpm/BPM/Lombardi/tools/upgrade/UpgradeProcessData/upgradeProcessData.sh -wasHome /web/WebSphere8ND/bpm -profileName BPMPSDmgr01 -nodeName usopap1bpmNode01 -serverName BPMPS.AppTarget.usopap1bpmNode01.0 -perfNodeName usopap1bpmNode01 -perfServerName BPMPS.Support.usopap1bpmNode01.0

    4. /web/WebSphere8ND/bpm/profiles/BPMPSDmgr01/dbscripts/ProcessChoreographer/DB2/PSBPEDB/schema_name

    upgradeSchema_SchemaStatus.sql on the database server for PSBPEDB

    5. Start DMGR and start each node and server
  • kuki2333
    kuki2333
    24 Posts

    Re: Upgrade from IBM BPM 8.0.0 to IBM BPM 8.0.1

    ‏2013-03-25T15:41:24Z  
    • kolban
    • ‏2013-03-25T14:53:14Z
    Vladlen,
    Really ... hmmm.

    In my opinion my next 4 answers to questions not yet asked will be:

    1. Yes definitely.
    2. Only on Sundays.
    3. IBM wanted to make that work but the person who knew how to do that won the lottery.
    4. I understand, I grew up with a sheep too.

    Neil
    We got SQL errors like

    Error executing SQL statement: DB2 SQL Error: SQLCODE=-964, SQLSTATE=57011, SQLERRMC=null, DRIVER=4.11.69 SQL statement that failed: ALTER TABLE LSW_EPV ADD COLUMN DESCRIPTION_TMP CLOB(2147483647)
    Error executing SQL statement: DB2 SQL Error: SQLCODE=-964, SQLSTATE=57011, SQLERRMC=null, DRIVER=4.11.69 SQL statement that failed: ALTER TABLE LSW_EPV ADD COLUMN EXT_DESCRIPTION_TMP CLOB(2147483647)
    Error executing SQL statement: DB2 SQL Error: SQLCODE=-964, SQLSTATE=57011, SQLERRMC=null, DRIVER=4.11.69 SQL statement that failed: ALTER TABLE LSW_EPV_VAR ADD COLUMN EXT_DESCRIPTION_TMP CLOB(2147483647)
    Error executing SQL statement: DB2 SQL Error: SQLCODE=-964, SQLSTATE=57011, SQLERRMC=null, DRIVER=4.11.69 SQL statement that failed: ALTER TABLE LSW_EPV_VAR_VALUE ADD COLUMN VALUE_TMP CLOB(2147483647)
    Error executing SQL statement: DB2 SQL Error: SQLCODE=-964, SQLSTATE=57011, SQLERRMC=null, DRIVER=4.11.69 SQL statement that failed: ALTER TABLE LSW_EPV_VAR_VALUE ADD COLUMN REASON_TMP CLOB(2147483647)
    Error executing SQL statement: DB2 SQL Error: SQLCODE=-964, SQLSTATE=57011, SQLERRMC=null, DRIVER=4.11.69 SQL statement that failed: ALTER TABLE LSW_REPORT ADD COLUMN DESCRIPTION_TMP CLOB(2147483647)
  • kuki2333
    kuki2333
    24 Posts

    Re: Upgrade from IBM BPM 8.0.0 to IBM BPM 8.0.1

    ‏2013-03-25T15:42:30Z  
    • kolban
    • ‏2013-03-25T14:53:14Z
    Vladlen,
    Really ... hmmm.

    In my opinion my next 4 answers to questions not yet asked will be:

    1. Yes definitely.
    2. Only on Sundays.
    3. IBM wanted to make that work but the person who knew how to do that won the lottery.
    4. I understand, I grew up with a sheep too.

    Neil
    We also failed to startup one of the engines after the upgrade

    This is the error

    3/16/13 15:41:16:752 SAST 0000004b wle_servlet W CWLLG0095W: The repository contact failed with a status of: 500
    3/16/13 15:41:22:794 SAST 00000066 DataTransferS E CWLLG1031E: An exception has occurred. Error: CWSIA0241E: An exception was received during the call to the method JmsManagedConnectionFactoryImpl.createConnection: com.ibm.websphere.sib.exception.SIResourceException: CWSIT0008E: A successful connection was made to the bootstrap server at dsopap1.standardbank.co.za:7287:BootstrapSecureMessaging but the server returned an error condition: CWSIT0088E: There are currently no messaging engines in bus PERFDW.dsopap1Cell01.Bus running. Additional failure information: CWSIT0103E: No messaging engine was found that matched the following parameters: bus=PERFDW.dsopap1Cell01.Bus, targetGroup=null, targetType=BusMember, targetSignificance=Preferred, transportChain=InboundSecureMessaging, proximity=Bus..
    com.lombardisoftware.core.TeamWorksException: CWSIA0241E: An exception was received during the call to the method JmsManagedConnectionFactoryImpl.createConnection: com.ibm.websphere.sib.exception.SIResourceException: CWSIT0008E: A successful connection was made to the bootstrap server at dsopap1.standardbank.co.za:7287:BootstrapSecureMessaging but the server returned an error condition: CWSIT0088E: There are currently no messaging engines in bus PERFDW.dsopap1Cell01.Bus running. Additional failure information: CWSIT0103E: No messaging engine was found that matched the following parameters: bus=PERFDW.dsopap1Cell01.Bus, targetGroup=null, targetType=BusMember, targetSignificance=Preferred, transportChain=InboundSecureMessaging, proximity=Bus..
    at com.lombardisoftware.core.TeamWorksException.asTeamWorksException(TeamWorksException.java:136)
    at com.lombardisoftware.server.queue.RecordQueue.queue(RecordQueue.java:358)
    at com.lombardisoftware.server.tracking.queue.DataTransferQueue.queueForProcessing(DataTransferQueue.java:71)
    at com.lombardisoftware.server.tracking.queue.DataTransferQueue.queueDataTransfer(DataTransferQueue.java:55)
    at com.ibm.bpm.server.startup.trackingserver.DataTransferScheduleManagerStartupBean$1$1.run(DataTransferScheduleManagerStartupBean.java:97)
    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:897)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:919)
    at java.lang.Thread.run(Thread.java:772)
    Caused by: javax.jms.JMSException: CWSIA0241E: An exception was received during the call to the method JmsManagedConnectionFactoryImpl.createConnection: com.ibm.websphere.sib.exception.SIResourceException: CWSIT0008E: A successful connection was made to the bootstrap server at dsopap1.standardbank.co.za:7287:BootstrapSecureMessaging but the server returned an error condition: CWSIT0088E: There are currently no messaging engines in bus PERFDW.dsopap1Cell01.Bus running. Additional failure information: CWSIT0103E: No messaging engine was found that matched the following parameters: bus=PERFDW.dsopap1Cell01.Bus, targetGroup=null, targetType=BusMember, targetSignificance=Preferred, transportChain=InboundSecureMessaging, proximity=Bus..
    at com.ibm.ws.sib.api.jms.impl.JmsManagedConnectionFactoryImpl.createConnection(JmsManagedConnectionFactoryImpl.java:195)
    at com.ibm.ws.sib.api.jms.impl.JmsManagedQueueConnectionFactoryImpl.createQueueConnection(JmsManagedQueueConnectionFactoryImpl.java:84)
    at com.lombardisoftware.server.queue.RecordQueue.queue(RecordQueue.java:324)
    ... 6 more
    Caused by: com.ibm.websphere.sib.exception.SIResourceException: CWSIT0008E: A successful connection was made to the bootstrap server at dsopap1.standardbank.co.za:7287:BootstrapSecureMessaging but the server returned an error condition: CWSIT0088E: There are currently no messaging engines in bus PERFDW.dsopap1Cell01.Bus running. Additional failure information: CWSIT0103E: No messaging engine was found that matched the following parameters: bus=PERFDW.dsopap1Cell01.Bus, targetGroup=null, targetType=BusMember, targetSignificance=Preferred, transportChain=InboundSecureMessaging, proximity=Bus.
    at com.ibm.ws.sib.trm.client.TrmSICoreConnectionFactoryImpl.generateException(TrmSICoreConnectionFactoryImpl.java:951)
    at com.ibm.ws.sib.trm.client.TrmSICoreConnectionFactoryImpl.remoteBootstrap(TrmSICoreConnectionFactoryImpl.java:638)
    at com.ibm.ws.sib.trm.client.TrmSICoreConnectionFactoryImpl.connectFromInsideServer(TrmSICoreConnectionFactoryImpl.java:418)
    at com.ibm.ws.sib.trm.client.TrmSICoreConnectionFactoryImpl.localBootstrap(TrmSICoreConnectionFactoryImpl.java:323)
    at com.ibm.ws.sib.trm.client.TrmSICoreConnectionFactoryImpl.createConnection(TrmSICoreConnectionFactoryImpl.java:304)
    at com.ibm.ws.sib.trm.client.TrmSICoreConnectionFactoryImpl.createConnection(TrmSICoreConnectionFactoryImpl.java:222)
    at com.ibm.ws.sib.api.jmsra.impl.JmsJcaManagedConnectionFactoryImpl.createManagedConnection(JmsJcaManagedConnectionFactoryImpl.java:471)
    at com.ibm.ejs.j2c.FreePool.createManagedConnectionWithMCWrapper(FreePool.java:2097)
    at com.ibm.ejs.j2c.FreePool.createOrWaitForConnection(FreePool.java:1778)
    at com.ibm.ejs.j2c.PoolManager.reserve(PoolManager.java:3258)
    at com.ibm.ejs.j2c.PoolManager.reserve(PoolManager.java:2599)
    at com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java:1500)
    at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:1012)
    at com.ibm.ws.sib.api.jmsra.impl.JmsJcaConnectionFactoryImpl.createConnection(JmsJcaConnectionFactoryImpl.java:509)
    at com.ibm.ws.sib.api.jms.impl.JmsManagedConnectionFactoryImpl.createConnection(JmsManagedConnectionFactoryImpl.java:165)
    ... 8 more
    Caused by: com.ibm.websphere.sib.exception.SIResourceException: CWSIT0009W: A client connect to bus PERFDW.dsopap1Cell01.Bus failed in the bootstrap server with endpoint dsopap1.standardbank.co.za:7287:BootstrapSecureMessaging with reason: CWSIT0088E: There are currently no messaging engines in bus PERFDW.dsopap1Cell01.Bus running. Additional failure information: CWSIT0103E: No messaging engine was found that matched the following parameters: bus=PERFDW.dsopap1Cell01.Bus, targetGroup=null, targetType=BusMember, targetSignificance=Preferred, transportChain=InboundSecureMessaging, proximity=Bus..
    at com.ibm.ws.sib.trm.client.TrmSICoreConnectionFactoryImpl.generateException(TrmSICoreConnectionFactoryImpl.java:951)
    at com.ibm.ws.sib.trm.client.TrmSICoreConnectionFactoryImpl.contactBootstrapService(TrmSICoreConnectionFactoryImpl.java:745)
    at com.ibm.ws.sib.trm.client.TrmSICoreConnectionFactoryImpl.remoteBootstrap(TrmSICoreConnectionFactoryImpl.java:589)
    ... 21 more