First describe my old Openbravo ERP environment as below:
Openbravo ERP 3.0MP1
windows 2003 server R2
Now I want to upgrade from MP1 to MP7.2 which are latest QA approved version.
Then I entered "Module Management" to Scan updates and installed all updates successfully ant gave me the hint of "Rebuild system". And then I click to rebuild system. then error occurs which shows that some tables do not exist in database like OBUIAPP_PROCESS,OBUIAPP_PROCESS_ACCESS,OBUIAPP_REF_WINDOW,OBUIAPP_UIPERSONALIZATION, then i created these tables with columns shown in .xml files.
then run ant export.database, it finished successfully.
and then rebuild system, another error occurs which gives the following message:
[java] org.apache.ddlutils.model.ModelException: There are multiple column
with the name MA_SEQUENCEPRODUCT_ID in the table MA_SEQUENCEPRODUCT
But I am very sure that there is only ONE MA_SEQUENCEPRODUCT_ID in MA_SEQUENCEPRODUCT table.
could you give me some useful advice on how to resolve this problem?
My OB ERP system has now fully refused to work, no one can login into it including system account.
i am so badly looking forward to your advice.
thank you so much.