Monday, October 3, 2011

Upgrade Oracle Team Productivity Center to 11.1.2.1 / Hudson Plugin

From Version: 11.1.1.5 
To Version: 11.1.2.1

Prepare

Check the content of the current otpc schema

SQL> select * from otpc_version t;

                 ID       DB_UPGRADE_NUM DB_VERSION                                                                    VERSION

-------------------- -------------------- ---------------------------------------------------------------- --------------------

                  1                    2 11.1.1.5.37.60.13                                                                   1

Download tpcinstaller.jar from OTN

Installation

Start new installer

jar -jar tpcinstaller.jar

0000@2570_2570-41266996bfbd4018

Click Next

0001@2570_2570-41266996c019ca25

Great: The installer recognized everything, so you really can expect the installation process will do the right thing

Choose: NExt

0003@2570_2570-41266996c1f19691

Point to the autodeploy directory of the privious installation. If you just point to the DOMAIN_HOME Location you will get an exception:

0004@2570_2570-41266996c22e4506

TPC-90026: The otpc.war of current installation for upgrade is missing in the server deployment directory

(Enhencement request: The installer should be smart enough to be able to check for otpc.war in the given domain!)

0005@2570_2570-41266996c4153d10

Choose: Next

0006@2570_2570-41266996c433944a

Choose: Next

0007@2570_2570-41266996c44a55b6

...

0008@2570_2570-41266996c45e0e69

...

0009@2570_2570-41266996c4765432

Upgrade completed. Plus Hudson Plugin installed.

Verify installation/ Upgrade

Verify  otpc_version in database schema:

SQL> select * from otpc_version t;

                 ID       DB_UPGRADE_NUM DB_VERSION                                                                    VERSION

-------------------- -------------------- ---------------------------------------------------------------- --------------------

                  1                    2 11.1.2.1.38.60.81                                                                   2

SQL>

Everything worked as expected. Nice.

Lets start weblogic and check if otpc server is running

0010@2570_2570-41266996c6ebe636

Seems to run, but (as stated in one of my privious posts) nobody can be sure which version actually is running. Especially from an ALM tool which now integrates with hudson I REALLY CAN EXPECT to see a BUILD-Number here! Dear Oracle, if you are reading this, please log an enhencement request to integrate a build number in the otpc server homepage! Further it would be nice if that homepage lists all installed otpc plugins (plus which version of course). Thanks.

BTW:

After starting the new otpc server a new folder has been created in DOMAIN_HOME

activemq-data

=> Oracle uses ActiveMQ now. I think in order to be able multi app server compatible. And ActiveMQ is obviously tinier than the WLS one.

OTPC Hudson Plugin

Now I am really interessted in how the hudson plugin looks like. So lets start my local hudson sanbox.

java -jar hudson-2.1.1.war -httpPort=8081 (8080 is used by the XE DB)

Observing the Hudson > Plugin Manager > Installed

=> No hints to a newly installed plugin

Looking into Hudson > Plugin Manager > Available

=> Bingo.

0011@2570_2570-41266996ce3bec47

(Additional info. The plugin has been put to

$HUDSON_HOME/HudsonTpcPlugin.hpi

by the OTPC installer and not into the $HUDSON_HOME/plugins/ as I would expect.)

Ok, move on

0012@2570_2570-41266996ceed6a92

Restart hudson.

The otpc plugin shows up in the installed section of the plugin manager.

0013@2570_2570-41266996cff6e5d5

So now we can use the plugin in our hudson jobs. Choose your job and configure..

0014@2570_2570-41266996d1950c84

Save changes and run your job.

Check the jobs console output

"The test result(s) Testergebnis will be sent to the Oracle Team Productivity Team Server at http://localhost:7001.

Successfully loggedin."


Thats all so far. Nothing else shows up in your hudson ui ;-(



What's next



Check OTPC in new JDev 11.1.2.1



0015@2570_2570-4126699b4bcdf012



0016@2570_2570-4126699b4bec474d



0017@2570_2570-4126699b4c0795cf



Let's open an old task repository



0019@2570_2570-4126699b51493271



Hhhm. let's create a new task repository



0018@2570_2570-4126699b4e450673



Same problem here.



Conclusion



OTPC is still not enterprise ready. OTPC should improve in the following




  1. Task repository connection does not work in new version! Wow. Where is the mistake? the server logs



WARNUNG: RepositoryServerServiceImpl.getAll() 10/03/2011 17:43:29 MESZ - reposit



ory server 'New Repository Server11121'  does not have any parameters by parentN



ame 'REPOSITORY_SERVER.New Repository Server11121.OTCP Task Repository11121'.



03.10.2011 17:43:29 oracle.alminternal.server.core.RepositoryServerServiceImpl g



etAll




  1. Integration BUILD-Number into otpc server homepage


  2. List installed connectors on otpc server homepage


  3. Integrate LDAP vor OTPC Users/Groups. Provide a mapping from those users/groups to OTPC Roles


  4. Integrate some nice charts in the hudson jobs webpages ;)



Like (in general about OTPC)




  1. Saving the IDE context for a specific task.!! This really rocks!

No comments:

Post a Comment