Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0020172Openbravo ERP01. General setuppublic2012-03-31 20:542012-04-18 10:23
aplattsmier 
marvintm 
urgentcriticalalways
closedduplicate 
30CentOS 6.2
3.0MP8.1 
 
Internet Explorer
Core
No
0020172: Stuck in Maintenance Mode after successful rebuild
Openbravo 3.0MP8.1 is stuck in maintenance mode and cannot clear.
In Application -> General Setup -> Application -> Module Management has no indicator that rebuild is necessary. Performed an 'ant update.database compile.complete -Dforce=yes' and build was successful. Restarted Tomcat 6 and restarted database. Still not able to get out of maintenance mode.
Application -> Application Dictionary -> Maintenance -> Update Table Identifiers completes successfully. Restart Tomcat/Postgres..still not working.
Application -> Application Dictionary -> Maintenance -> Recompile DB Objects produces the following error:
    
java.lang.Exception: @CODE=0@ERROR: function dba_recompile(character varying) does not exist Hint: No function matches the given name and argument types. You might need to add explicit type casts. Position: 15
Postgres Function dba_recompile does in fact not exist in Postgres.
Install the identified stack from this issue report.
Install the US Localization - Community COA - 3.0.0 - English (USA) Module
Execute the recompile.
Recompile fails.
Run 'ant update.database compile.complete -Dforce=yes'
Still unable to login.
Supply the Postgres Function. Provide manual way of clearing the maintenance mode even after rebuild is successful.
No tags attached.
duplicate of defect 0020174 closed marvintm Update to MP9 from MP8.1 Failure during build 
Issue History
2012-03-31 20:54aplattsmierNew Issue
2012-03-31 20:54aplattsmierAssigned To => vmromanos
2012-03-31 20:54aplattsmierWeb browser => Internet Explorer
2012-03-31 20:54aplattsmierModules => Core
2012-04-11 11:31vmromanosAssigned Tovmromanos => alostale
2012-04-11 11:42alostaleAssigned Toalostale => marvintm
2012-04-18 10:23marvintmRelationship addedduplicate of 0020174
2012-04-18 10:23marvintmNote Added: 0047687
2012-04-18 10:23marvintmStatusnew => closed
2012-04-18 10:23marvintmResolutionopen => duplicate

Notes
(0047687)
marvintm   
2012-04-18 10:23   
This problem basically happened due to the problem described in issue 20174. To fix it, just do:

ant smartbuild -Dlocal=no -Dforce=yes