Showing posts with label full text search db2. Show all posts
Showing posts with label full text search db2. Show all posts

Monday, September 14, 2015

Installing Maximo 7.6 with DB2 on Hyper-V

Goal:
Install Maximo 7.6 with DB2 database on a Windows 2012 server in Hyper V



Existing Configuration:

Previously I used VMWare for my VM's. With my Windows Phone development I use hyper V for Emulators. Hyper-V can also be used for other virtual Machines, so why not use it for Maximo VM's 

My Hyper-V machine setup:
  • Windows Server 2012
  • 8GB RAM (dynamic)
  • One disk, 85 GB

Used Documents:



Step 1: Setting up the needed files

I extracted all the zip files listed below in one directory:

  • MAM_7.6.0.0_WIN64.zip
  • Middl_Inst_DB2_105_Win_x86-64.zip
  • Middl_Inst_WAS_855_1of3_Win.zip
  • Middl_Inst_WAS_855_2of3_Win.zip
  • Middl_Inst_WAS_855_3of3_Win.zip



Next I create a Snapshot in Hyper-V.
So if I want to start again, I just revert to the snapshot.  (screenshot below is in Dutch)





Step 2: Installing

Right click on launchpad64.exe and choose "run as Administrator"






Next I follow the steps provided in the IBM Blog (see link at top of this post) I will only describe any abnormalities in details. Otherwise I just follow the IBM Blog.

I select "Install Product" on the left side, leave the options as is and click the link "Install IBM Maximo Asset Management components"




I make sure all packages are selected and click [Next]




On the Install Packages screen accept the license agreements and click [Next]



I accept the defaults and click [Next]




Again not modifying anything and clicking [Next]

In the following also clicking [Next] (using English language)

In the following screen the Features are shown, I do not change anything, and click [Next]

Now the DB2 installation page is shown. I leave the defaults and enter a password that meets the complexity rules of the Windows server and I check the option "Use the DB2 administration server user password"  See at the bottom of this blog post what happend when i entered a simple password.



I accept the defaults on the IBM HTTP Server screen and click [Next]

Finally, on the summary page I click [Install]




The files are being retreived and installed





After a while everything is installed





Step 3: Prepare Websphere

I Click [Finish] and the "IBM Tivoli process automation engine configuration utility" launches




There I click on "Prepare Websphere Application Server for configuration"

I leave everything as-is and click [Next]




On the next screen I scroll down and enter the password for Websphere and click [Next]




I want the service to run as the local system account and click [Next]




Next make you choice for Authentication, I use the default and click [Next]




I leave all the options checked and click [Finish]









Step below takes a very long time:


Finally I got: (one hour later)





Step 4: Configure websphere

When finished the "IBM Tivoli process automation engine configuration utility" is shown 
again. The Prepare option is gone, now I click on the "Configure a new Deployment" link




I leave the defaults in the next screen and enter a password in the "Use a default password value for all password values" and click [Finish]




The next screen shows some configuration options, I check the "Create sample data in the database" and click [Next]





Now the DB2 database information is shown,

I change the database password to "maximo" and click [Next]



I check the box "Enable full text search" and click [Next]



I leave the next screen as-is and click [Next]



I change the passwords for easy reference and click [Next]



I set the Base language to English and select Dutch as Additional Language




In the next screen i first only select Validate, like on the IBM blog and click [Finish]



I get an Validation error



The error is on the DB2 Instance

[10:39:42 AM CEST] DB2 Instance-CTGIN2032E: The port number is not listening on the host.
[10:39:46 AM CEST] Apply Deployment Operations-CTGIN5135E: Error configuring the database for DB2 Text Search. Unable to connect to the database specified.
[10:39:46 AM CEST] Apply Deployment Operations-CTGIN5009E: Validation of properties for reconfiguration failed. See previous messages for information on the failure.

So it seems because I enabled Full Text Search the database must exist...
I go back and disable the Full Text Search


then I go back to the Validation and click [Finish] again.
Now the following error shows:



[10:48:27 AM CEST] Apply Deployment Operations-Starting validation and configuration ....
[10:48:29 AM CEST] DB2 Instance-CTGIN2032E: The port number is not listening on the host.
[10:48:30 AM CEST] Apply Deployment Operations-CTGIN5009E: Validation of properties for reconfiguration failed. See previous messages for information on the failure.

So DB2 is not available

I change the port to 50000 and click [Finish] again


Again a error

[10:50:57 AM CEST] Apply Deployment Operations-Starting validation and configuration ....
[10:51:00 AM CEST] Apply Deployment Operations-Validating application server parameters...
[10:51:10 AM CEST] Apply Deployment Operations-CTGIN5059I: Property validation check completed successfully. All required properties were found.
[10:51:10 AM CEST] Apply Deployment Operations-CTGIN2094I: The preCheck function completed successfully.
[10:51:10 AM CEST] Apply Deployment Operations-CTGIN5060E: Authentication to WebSphere Application Server Deployment Manager win2k12.local.com with user name wasadmin failed because the user doesn't exist or the password is incorrect.
[10:51:10 AM CEST] Apply Deployment Operations-CTGIN5009E: Validation of properties for reconfiguration failed. See previous messages for information on the failure.
[10:51:10 AM CEST] Apply Deployment Operations-Validating database parameters...
[10:51:13 AM CEST] Apply Deployment Operations-CTGIN2102E: Error: Cannot connect to the database with user maximo.
[10:51:13 AM CEST] Apply Deployment Operations-CTGIN5009E: Validation of properties for reconfiguration failed. See previous messages for information on the failure.


Cannot connect to the database... that is no suprise because the database isn't there yet... I go and check the IBM blog.

I cancel the screen and click on "Configure a New Deployment" again. No I check the "Create and configure the database" and fill in the Windows Server information and click [Finish]
 In the screenshot on the IBM blog this was not filled in, But I guess we need to create the database here. 


Now I fill in the steps again. Now some steps have som additional information, like on the screenshots on the IBM blog. 

I leave all the defaults (but do check the "Enable full text search" and set some passwords to other values.)

No the validation goes and I get a question about wanting to complete the other steps. I click [Yes]



I check all the boxes and click [Finish]



All options will now be installed.

I started on 11:09, the progss can be viewed in the Console below




After a while I got an error:



[11:21:10 AM CEST] Apply Deployment Operations-CTGIN2321E: The port number 50000 is in use on win2k12.local.com.


I go back to the DB2 Instance page and change the port to 50005 and click [Finish]
This was the port we set up earlier for ctginst1



Now the setup continues. Something that ditn't not match in the IBM Blog, but I should have seen it when following the blog. So make sure you think about what you fill in :)

Now the user fails, so must be a password I missed.





[11:53:24 AM CEST] Apply Deployment Operations-CTGIN5398E: Unable to connect to the database. The userid 'maximo' and password combination were not accepted by the database system.
[11:53:24 AM CEST] Apply Deployment Operations-[jcc][t4][2013][11249][4.11.69] Connection authorization failure occurred.  Reason: User ID or Password invalid. ERRORCODE=-4214, SQLSTATE=28000

[11:53:24 AM CEST] Apply Deployment Operations-CTGIN2102E: Error: Cannot connect to the database with user maximo.

I re-enter the password on the DB2 information and click [Finish] again.

Now the installer get to the part of creating the database



This is part of the log when rechecking the maximo user information:

[11:56:20 AM CEST] Apply Deployment Operations-Starting validation and configuration ....
[11:56:23 AM CEST] Apply Deployment Operations-CTGIN5110I: Successfully connected to the database.
[11:56:23 AM CEST] Apply Deployment Operations-CTGIN5109I: DB2 database server version 10.5.400.191 meets the requirements for DB2 Text Search support.
[11:56:23 AM CEST] Apply Deployment Operations-Validating application server parameters...
[11:56:23 AM CEST] Apply Deployment Operations-Application server parameter validation successful.
[11:56:23 AM CEST] Apply Deployment Operations-Validating database parameters...
[11:56:24 AM CEST] Apply Deployment Operations-CTGIN5398E: Unable to connect to the database. The userid 'maximo' and password combination were not accepted by the database system.
[11:56:24 AM CEST] Apply Deployment Operations-[jcc][t4][2013][11249][4.11.69] Connection authorization failure occurred.  Reason: User ID or Password invalid. ERRORCODE=-4214, SQLSTATE=28000
[11:56:27 AM CEST] Apply Deployment Operations-CTGIN5398E: Unable to connect to the database. The userid 'maximo' and password combination were not accepted by the database system.
[11:56:27 AM CEST] Apply Deployment Operations-[jcc][t4][2013][11249][4.11.69] Connection authorization failure occurred.  Reason: User ID or Password invalid. ERRORCODE=-4214, SQLSTATE=28000
[11:56:27 AM CEST] Apply Deployment Operations-Database parameter validation successful.
[11:56:27 AM CEST] Apply Deployment Operations-Saving configuration parameters...
[11:56:27 AM CEST] Apply Deployment Operations-Starting configuration...
[11:56:28 AM CEST] Apply Deployment Operations-CTGIN5398E: Unable to connect to the database. The userid 'maximo' and password combination were not accepted by the database system.
[11:56:28 AM CEST] Apply Deployment Operations-[jcc][t4][2013][11249][4.11.69] Connection authorization failure occurred.  Reason: User ID or Password invalid. ERRORCODE=-4214, SQLSTATE=28000
[11:56:28 AM CEST] Apply Deployment Operations-CTGIN5398E: Unable to connect to the database. The userid 'maximo' and password combination were not accepted by the database system.
[11:56:28 AM CEST] Apply Deployment Operations-[jcc][t4][2013][11249][4.11.69] Connection authorization failure occurred.  Reason: User ID or Password invalid. ERRORCODE=-4214, SQLSTATE=28000
[11:56:28 AM CEST] Apply Deployment Operations-CTGIN5010I: Validation of pending updates completed successfully.
[11:56:28 AM CEST] Apply Deployment Operations-CTGIN5011I: Saving updated property values.
[11:56:29 AM CEST] Apply Deployment Operations-CTGIN5068I: The configuration of the environment has started.
[11:56:31 AM CEST] Apply Deployment Operations-CTGIN5071I: System users required for DB2 access were created successfully and assigned to appropriate system user groups.
[11:56:32 AM CEST] Apply Deployment Operations-CTGIN2089I: Process automation engine database instance has previously been created. Instance creation task skipped.
[11:56:32 AM CEST] Apply Deployment Operations-CTGIN2087I: Process automation engine database has previously been created. Database creation task skipped.
[11:56:33 AM CEST] Apply Deployment Operations-CTGIN2135I: Table space MAXDATA created successfully.
[11:56:33 AM CEST] Apply Deployment Operations-CTGIN2135I: Table space MAXINDEX created successfully.
[11:56:33 AM CEST] Apply Deployment Operations-CTGIN2135I: Table space MAXTEMP created successfully.
[11:56:33 AM CEST] Apply Deployment Operations-CTGIN2085I: Process automation engine database user has previously been created. User creation task skipped.
[11:56:35 AM CEST] Apply Deployment Operations-CTGIN2123I: The database user maximo was configured.
[11:56:35 AM CEST] Apply Deployment Operations-CTGIN5426I: Multi-tenancy is not enabled.

[11:56:36 AM CEST] Apply Deployment Operations-CTGIN5372I: Running the maxinst task to create the database. This task can take an extended period of time to complete, based upon your environment.

The process started at 11:56 and finished at 13:59. So it took over 2 hours to complete


I Click [OK]

Maximo should be running now.

I navigate to http://win2k12.local.com/maximo/ and ad the site to the trusted sites




And I login to maximo with the maxadmin account




Up and Running.





Problem installing DB2, maybe usefull for someone encoutering the same problem:

On my first try I got the following error:

Error during "install" phase:
An error occured while creating the user "db2admin" for the DB2 Administration Server. The return value is "5150"



I tried it again and got:

Explanation: The Ant process exited with code 1 while running C:\IBM\SQLLIB\TPAEAutomation\DB2_10\DB2_10.xml



When troubleshooting I tried to manually install DB2 and got another error.
When enetering 'dbadmin' as password i got the error 

password too short

I made the password longer, but the same error occured. Then I used a complex password and it was accepted. So in the procedure above I used a complex password and the installation went ok. 

So note that the installer will accept a standard password, but when installing it can fail.



GNZ