Release Process Manager Installation

[Milton Silva]

Hello people,

This is my first topic here and I hope that someone can help me with this problem. 

I'm trying to install Release Process Manager on the Maximo 7.1 installation, but I got an error in the step 23 when the Process Solution Installer trying to deploy the file Release71IDD.war. When I've started the Maximo console, I can see the Release links in the menu, but when I've tryed to open any Release link, I've got a form with errors in all fields. If I've try to reinstall the package, I've got the same error. 

I've searching about the uninstallation in the manual, the uninstallation method needs the pkguuid number, but because the error, I can't find this number, the installation not finished sucessfully and I want to know if exists an other method to uninstall and reinstall this package.

Thank you so much and sorry about the english errors, I hope that you can understand. 

Milton.

[Milton Silva]

I've solved this error, but I've got another... 

These are the logs of the Release Process Manager installation:

java.lang.Exception: DATABASE SCRIPT UPDATE COMPLETED WITH ERROR. Assignment of a NULL value to a NOT NULL column "TBSPACEID=3, TABLEID=547, COLNO=32" is not allowed.
   at psdi.tools.UpdateDB.startProcess(Unknown Source)
   at psdi.tools.UpdateDB.startProcess(Unknown Source)
   at psdi.tools.UpdateDB.loadScriptInfo(Unknown Source)
   at psdi.tools.UpdateDB.main(Unknown Source)
C:\IBM\SMP/jacl/solutions/updatedbWrapper.bat encountered an error running the Maximo 'updatedb' script
ERRORLEVEL was 1
returning value '1' to the Solution Install runtime at Fri 12/19/2008 13:53:14.28
Wrapper encountered error executing command. ERRORLEVEL was 1 from command C:\IBM\SMP/jacl/solutions/updatedbWrapper.bat.
Returning value 1 to Solution Install runtime.
Exiting wrapper.bat at Fri 12/19/2008 13:53:14.28

Someone have any suggestions to solve this?

Thank you so much!

[Milton Silva]

Now I've found another log and this is the lines with error:

DBRELEASE_PMP: V710-17, Current release DB build: V710-35, Last release DB build: V710-00
Database script  update in progress, please wait..........
Current version :V710-17
Updating To     :V710-35
Error running file: V710_18
Script Update complete: Error
Updatedb process ends: ERROR

I've tryed to search the file that update the Release DB but I've didn't found this file... 

[amdisuk]

I've solved this error, but I've got another... 

These are the logs of the Release Process Manager installation:

java.lang.Exception: DATABASE SCRIPT UPDATE COMPLETED WITH ERROR. Assignment of a NULL value to a NOT NULL column "TBSPACEID=3, TABLEID=547, COLNO=32" is not allowed.
   at psdi.tools.UpdateDB.startProcess(Unknown Source)
   at psdi.tools.UpdateDB.startProcess(Unknown Source)
   at psdi.tools.UpdateDB.loadScriptInfo(Unknown Source)
   at psdi.tools.UpdateDB.main(Unknown Source)
C:\IBM\SMP/jacl/solutions/updatedbWrapper.bat encountered an error running the Maximo 'updatedb' script
ERRORLEVEL was 1
returning value '1' to the Solution Install runtime at Fri 12/19/2008 13:53:14.28
Wrapper encountered error executing command. ERRORLEVEL was 1 from command C:\IBM\SMP/jacl/solutions/updatedbWrapper.bat.
Returning value 1 to Solution Install runtime.
Exiting wrapper.bat at Fri 12/19/2008 13:53:14.28

Someone have any suggestions to solve this?

Thank you so much!

This could be a genuine bug. It could also be that you have some customizations that are stopping the update from working.

You could get round this by going into Database Configuration and changing TBSPACEID so that it can be null. There is a configuration field that determines if a field can be null or not. I'm not sure what the table name is but it should be easy enough to find. Re-run the script and see what happens.

Al

[yhyoun]

I got the same error when I installed release71IDD.war. How did you solve the error? 

[Yesterday]

• Not able to access the ma... by Dileep Kumar [Yesterday at 06:57:40 am]
• How to Connect to Fax Mac... by Dileep Kumar [May 16, 2012, 06:26:22 am]
• Is there a way to track t... by rickmac [May 14, 2012, 06:43:03 am]
• how to change the backgou... by gorgehemtr [May 12, 2012, 06:15:14 am]
• How to break description ... by murugovind [May 11, 2012, 12:40:26 pm]
• Enabling Attachment on CL... by G Jeevan [May 11, 2012, 12:24:33 pm]
• Data insertion in Work Or... by Sarbjeet.Jassal [May 09, 2012, 09:06:53 am]
• Want userdefined name whi... by G Jeevan [May 08, 2012, 10:43:40 am]
• my newly created continio... by G Jeevan [May 08, 2012, 10:41:22 am]
• All User Account unable t... by bphome [May 03, 2012, 05:09:47 pm]