#1667 Migration Problem with 252c

[Victor Perez Juarez]

Hi Jorg

I tried to make the migration and got this error:

CLogFile[/app/compiere/e-evolution/ok/install/build/Compiere2/log/2005-04-25_7.log,Level=ALL]
Exception in thread "main"
java.lang.IllegalArgumentException: Invalid PO Info -
POInfo[null,AD_Table_ID=531]
at org.compiere.model.PO.<init>(PO.java:104)
at org.compiere.model.PO.<init>(PO.java:76)
at
org.compiere.model.X_AD_System.<init>(X_AD_System.java:31)
at
org.compiere.model.MSystem.<init>(MSystem.java:98)
at org.compiere.model.MSystem.get(MSystem.java:48)
at
org.compiere.Compiere.startupEnvironment(Compiere.java:459)
at org.compiere.Compiere.startup(Compiere.java:439)
at
com.compiere.client.StartMaintain.main(Unknown Source)

The problem is when RUN_Migrate try to start the new
version 252c not find field AD_Role.ISUSEUSERORGACCESS
,AD_Column.COLUMNSQL && Table AD_USER_ORGACCESS.

I resolve the problem execute this scrip attachment.

Cheers
Victor

[Victor Perez Juarez]

migration

[Jorg Janke]

Logged In: YES
user_id=87038

Found it ... Victor: PLEASE TEST

[Victor Perez Juarez]

Logged In: YES
user_id=332830

Hi Jorg!

I got some errors while migration, I attacht the log file
the first problem was resolved , but now after the
migration, when you run after migration the system show this
error:

*** 2005-04-28 13:33:14.184 Compiere Log (CLogConsole) ***
13:33:14.183 Compiere.startup: Compiere(r) Release
2.5.2c_2005-04-22 - Smart ERP & CRM - (c) 1999-2005 Compiere
(r); Implementation: 2.5.2c 20050428-0204 - ComPiere Inc.
(C) 1999-2005 Jorg Janke
13:33:14.185 Compiere.startup: - Java HotSpot(TM) Client VM
1.4.2_07-b05 - Linux 2.6.8-24.14-default unknown
13:33:16.485 Ini.loadProperties: /root/Compiere.properties #30
Exception occurred during event dispatching:
java.lang.IllegalArgumentException: Invalid PO Info -
POInfo[null,AD_Table_ID=770]
at org.compiere.model.PO.<init>(PO.java:104)
at org.compiere.model.PO.<init>(PO.java:64)
at
org.compiere.model.X_M_CostElement.<init>(X_M_CostElement.java:15)
at
org.compiere.model.MCostElement.<init>(MCostElement.java:146)
at
org.compiere.model.MCostElement.getMaterialCostElement(MCostElement.java:78)
at
org.compiere.model.MAcctSchema.checkCosting(MAcctSchema.java:369)
at org.compiere.util.DB.afterMigration(DB.java:112)
at
org.compiere.apps.ALogin.connectionOK(ALogin.java:441)
at
org.compiere.apps.ALogin.actionPerformed(ALogin.java:396)
at
javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1786)
at
javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButton.java:1839)
at
javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)
at
javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
at
javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:245)
at
java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:231)
at
java.awt.Component.processMouseEvent(Component.java:5100)
at java.awt.Component.processEvent(Component.java:4897)
at java.awt.Container.processEvent(Container.java:1569)
at
java.awt.Component.dispatchEventImpl(Component.java:3615)
at
java.awt.Container.dispatchEventImpl(Container.java:1627)
at java.awt.Component.dispatchEvent(Component.java:3477)
at
java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3483)
at
java.awt.LightweightDispatcher.processMouseEvent(Container.java:3198)
at
java.awt.LightweightDispatcher.dispatchEvent(Container.java:3128)
at
java.awt.Container.dispatchEventImpl(Container.java:1613)
at java.awt.Window.dispatchEventImpl(Window.java:1606)
at java.awt.Component.dispatchEvent(Component.java:3477)
at
java.awt.EventQueue.dispatchEvent(EventQueue.java:456)
at
java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:201)
at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:151)
at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:141)
at java.awt.Dialog$1.run(Dialog.java:540)
at
java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:178)
at
java.awt.EventQueue.dispatchEvent(EventQueue.java:454)
at
java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:201)
at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:151)
at
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:145)
at
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:137)
at
java.awt.EventDispatchThread.run(EventDispatchThread.java:100)

[Jorg Janke]

Logged In: YES
user_id=87038

Fixed.

[Victor Perez Juarez]

Logged In: YES
user_id=332830

** Bug set to Pending. Please update it and set the status back to
Open as we can only act on open bugs. If the problem was
resolved, please close the bug **

[Victor Perez Juarez]

Logged In: YES
user_id=332830

Hi Jorg!

I test the new version for migation and I got this error:

17:46:27.475 DB.afterMigration: Costing [11]
17:46:29.768 ModelValidationEngine.<init>:
ModelValidationEngine[Validators=#0, ModelChange=#0,
DocValidate=#0] [11]
17:46:43.100 MCostType.saveNew: M_CostType -
M_CostType_ID=1000003 [11]
17:46:44.589 PO.setDocWorkflowMgr:
DocWorkflowManager[Called=0,Stated=0] [11]
Exception occurred during event dispatching:
java.lang.IllegalArgumentException: Invalid PO Info -
POInfo[null,AD_Table_ID=770]
at org.compiere.model.PO.<init>(PO.java:104)
at org.compiere.model.PO.<init>(PO.java:64)
at
org.compiere.model.X_M_CostElement.<init>(X_M_CostElement.java:15)
at
org.compiere.model.MCostElement.<init>(MCostElement.java:146)
at
org.compiere.model.MCostElement.getMaterialCostElement(MCostElement.java:78)
at
org.compiere.model.MAcctSchema.checkCosting(MAcctSchema.java:369)
at org.compiere.util.DB.afterMigration(DB.java:112)
at
org.compiere.apps.ALogin.connectionOK(ALogin.java:441)
at
org.compiere.apps.ALogin.actionPerformed(ALogin.java:396)
at
javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1786)
at
javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButton.java:1839)
at
javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)
at
javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
at
javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:245)
at
java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:231)
at
java.awt.Component.processMouseEvent(Component.java:5100)
at java.awt.Component.processEvent(Component.java:4897)
at java.awt.Container.processEvent(Container.java:1569)
at
java.awt.Component.dispatchEventImpl(Component.java:3615)
at
java.awt.Container.dispatchEventImpl(Container.java:1627)
at java.awt.Component.dispatchEvent(Component.java:3477)
at
java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3483)
at
java.awt.LightweightDispatcher.processMouseEvent(Container.java:3198)
at
java.awt.LightweightDispatcher.dispatchEvent(Container.java:3128)
at
java.awt.Container.dispatchEventImpl(Container.java:1613)
at java.awt.Window.dispatchEventImpl(Window.java:1606)
at java.awt.Component.dispatchEvent(Component.java:3477)
at
java.awt.EventQueue.dispatchEvent(EventQueue.java:456)
at
java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:201)
at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:151)
at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:141)
at java.awt.Dialog$1.run(Dialog.java:540)
at
java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:178)
at
java.awt.EventQueue.dispatchEvent(EventQueue.java:454)
at
java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:201)
at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:151)
at
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:145)
at
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:137)
at
java.awt.EventDispatchThread.run(EventDispatchThread.java:100)
17:49:07.616 AEnv.showCenterScreen:
17:49:08.169 Env.reset: reset - finalCall=true
17:49:08.170 CacheMgt.reset: CCache[POInfo,Exp=120, #8]
17:49:08.173 CacheMgt.reset: CCache[msg_lang,Exp=0, #1]
17:49:08.173 CacheMgt.reset: CCache[AD_Message,Exp=0, #747]
17:49:08.175 CacheMgt.reset: CCache[AD_Role,Exp=120, #1]
17:49:08.177 CacheMgt.reset: CCache[AD_Client,Exp=120, #3]
17:49:08.178 CacheMgt.reset:
CCache[AD_ClientInfo,Exp=120, #1]
17:49:08.180 CacheMgt.reset:
CCache[C_AcctSchema,Exp=120, #1]
17:49:08.181 CacheMgt.reset: #7 (762)
17:49:10.879 DB_Oracle.close:
DB_Oracle[jdbc:oracle:thin:@//vpj:1521/cmpcs-OracleDataSource,ImplCache=true,MaxStmts=20]
17:49:10.880 DB.closeTarget: closed
17:49:10.881 Env.exitEnv: