Need help in iDempiere installation: Can't login because login dialog's Role combo box is empty

[Rudikha]

Hi all,

I just installed iDempiere in linux following this tutorial:

http://www.globalqss.com/wiki/index.php/IDempiere/Installing_from_Installers

But when I run the swing client, at login dialog, the Role combo box is empty. Thus I can't login.

I checked the AD_ROLE table, there are records of GardenWorld Admin and GardenWorld User role. So what's wrong here? Anyone can help me?

Regards,

Rudikha

[Henrique Meira]

Try logon as System (Role System Administration, if possible) and run "Role Access Update".

henrique.

2012/10/24 Rudikha <rdyf...@gmail.com>

[Carlos Antonio Ruiz Gomez]

Hi Rudikha, this is still an intermediate version, so you must apply the
migration scripts on the database
http://www.globalqss.com/wiki/index.php/IDempiere/Importing_DB_Seed_Manually#Applying_additional_migration_scripts

Regards,

Carlos Ruiz

[Rudikha]

@henrique:

The Role combo box is empty for any users, even for the System user.

@Carlos:

Thanks, I will check it out.

[Rudikha]

Hi,

I had applied the seed from Adempiere_pg.dmp and $IDEMPIERE_REPOSITORY/org.adempiere.server-feature/data/seed/LAST_SCRIPT_APPLIED_ON_THIS_SEED => 847_FillNewUUIDs.sql, but the Role combo box is still empty.

Do I have to apply every scripts above 847_FillNewUUIDs.sql ?



Regards,
Rudikha

[Carlos Ruiz]

> Do I have to apply every scripts above 847_FillNewUUIDs.sql ?

Yes

[Rudikha]

Hi Carlos,

I had applied all scripts from 848_*.sql to 946_*.sql and the Role showed up now, but I got error message: "nulljava.lang.ClassNotFoundException: org.idempiere.fa.model.ModelValidator global" when clicked OK button to proceed (see above screenshot).

Error stack trace:
java.lang.ClassNotFoundException: org.idempiere.fa.model.ModelValidator
    at org.eclipse.osgi.internal.loader.BundleLoader.findClassInternal(BundleLoader.java:513)
    at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:429)
    at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:417)
    at org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.loadClass(DefaultClassLoader.java:107)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:266)
    at java.lang.Class.forName0(Native Method)
    at java.lang.Class.forName(Class.java:186)
    at org.compiere.model.ModelValidationEngine.loadValidatorClass(ModelValidationEngine.java:163)
    at org.compiere.model.ModelValidationEngine.<init>(ModelValidationEngine.java:104)
    at org.compiere.model.ModelValidationEngine.get(ModelValidationEngine.java:75)
    at org.compiere.model.PO.save(PO.java:2050)
    at org.compiere.util.Login.getClients(Login.java:1465)
    at org.compiere.apps.ALogin.tryConnection(ALogin.java:868)
    at org.compiere.apps.ALogin.connectionOK(ALogin.java:624)
    at org.compiere.apps.ALogin.actionPerformed(ALogin.java:574)
    at org.compiere.apps.AppsAction.actionPerformed(AppsAction.java:286)
    at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2012)
    at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2335)
    at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:404)
    at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
    at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)
    at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:289)
    at java.awt.Component.processMouseEvent(Component.java:6268)
    at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
    at java.awt.Component.processEvent(Component.java:6033)
    at java.awt.Container.processEvent(Container.java:2045)
    at java.awt.Component.dispatchEventImpl(Component.java:4629)
    at java.awt.Container.dispatchEventImpl(Container.java:2103)
    at java.awt.Component.dispatchEvent(Component.java:4455)
    at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4633)
    at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4297)
    at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4227)
    at java.awt.Container.dispatchEventImpl(Container.java:2089)
    at java.awt.Window.dispatchEventImpl(Window.java:2517)
    at java.awt.Component.dispatchEvent(Component.java:4455)
    at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:649)
    at java.awt.EventQueue.access$000(EventQueue.java:96)
    at java.awt.EventQueue$1.run(EventQueue.java:608)
    at java.awt.EventQueue$1.run(EventQueue.java:606)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:105)
    at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:116)
    at java.awt.EventQueue$2.run(EventQueue.java:622)
    at java.awt.EventQueue$2.run(EventQueue.java:620)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:105)
    at java.awt.EventQueue.dispatchEvent(EventQueue.java:619)
    at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:275)
    at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:200)
    at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:194)
    at java.awt.Dialog$1.run(Dialog.java:1072)
    at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:226)
    at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:647)
    at java.awt.EventQueue.access$000(EventQueue.java:96)
    at java.awt.EventQueue$1.run(EventQueue.java:608)
    at java.awt.EventQueue$1.run(EventQueue.java:606)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:105)
    at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:116)
    at java.awt.EventQueue$2.run(EventQueue.java:622)
    at java.awt.EventQueue$2.run(EventQueue.java:620)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:105)
    at java.awt.EventQueue.dispatchEvent(EventQueue.java:619)
    at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:275)
    at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:200)
    at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:190)
    at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:185)
    at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:177)
    at java.awt.EventDispatchThread.run(EventDispatchThread.java:138)
12:45:37.023===========> Login.validateLogin: Refused: nulljava.lang.ClassNotFoundException: org.idempiere.fa.model.ModelValidator global
 [11]
12:45:37.178-----------> Msg.getMsg: NOT found: nulljava.lang.ClassNotFoundException: org.idempiere.fa.model.ModelValidator global
 [11]

[Carlos Antonio Ruiz Gomez]

Ah, the issue is that iDempiere is still changing too fast.  You need to download latest installers, that class was added yesterday.

Regards,

Carlos Ruiz

[Rudikha]

Hi carlos,

I download the source code again and I found there are three new scripts in: idempiere/migration/360lts-release/postgresql folder.

If I run migration_postgresql.sh like this:

./migrate_postgresql.sh 360lts-release commit | psql -U adempiere -d idempiere > 354a-trunk.lst 

Will it import only the three new scripts or will it import all scripts inside the 360lts-release folder?

[Heng Sin Low]

it will import everything. I usually copy the new script to another folder, say "360lts-new" and execute the command below:

./migrate_postgresql.sh 360lts-new commit | psql -U adempiere -d idempiere 

[Rudikha]

Thanks hengsin.

Now I can login, but there is another error again ^^

I can login as System (System Administrator Role), but I can't open any window. There is error dialog popped-up (see above screenshot).

This is the error message:

org.postgresql.util.PSQLException: The column name AD_Tab_UU was not found in this ResultSet.; State=42703; ErrorCode=0
    at org.postgresql.jdbc2.AbstractJdbc2ResultSet.findColumn(AbstractJdbc2ResultSet.java:2727)
    at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getString(AbstractJdbc2ResultSet.java:2567)
    at com.mchange.v2.c3p0.impl.NewProxyResultSet.getString(NewProxyResultSet.java:3342)
    at org.compiere.model.GridTabVO.loadTabDetails(GridTabVO.java:104)
    at org.compiere.model.GridTabVO.create(GridTabVO.java:59)
    at org.compiere.model.GridWindowVO.createTabs(GridWindowVO.java:234)
    at org.compiere.model.GridWindowVO.create(GridWindowVO.java:202)
    at org.compiere.util.Env.getMWindowVO(Env.java:1725)
    at org.compiere.apps.APanel.initPanel(APanel.java:721)
    at org.compiere.apps.AWindow.initWindow(AWindow.java:102)
    at org.compiere.apps.AMenuStartItem.startWindow(AMenuStartItem.java:249)
    at org.compiere.apps.AMenuStartItem.run(AMenuStartItem.java:147)

13:56:29.750===========> GridWindowVO.createTabs: No Tabs - AD_Window_ID=151 - SELECT * FROM AD_Tab_v WHERE AD_Window_ID=? ORDER BY SeqNo [18]