Table Name Not Found - AD_UserPreference

[Enamur Reza]

Hi All,

I have successfully installed idempiere in eclipse.

But when I like to log in, it says:

Table Name Not Found - AD_UserPreference,

Where can I get this table, or current DB script.

After searching here in the groups, I got few shell script available from Carlos Ruiz.

But those are Shell scripts, I am running in windows.

Any clue ...

Thanks in advance,

//Enamur Reza.

[Nicolas Micoud]

Hi,

I got exactly same message yesterday - was migrating my old v3 version to lastest sources (on ubuntu)
I just miss to execute scripts in $IDEMPIERE_REPOSITORY/migration/processes_post_migration

See: http://wiki.idempiere.org/en/Importing_DB_Seed_Manually

Regards,

Nicolas

[Enamur Reza]

Hi Nicolas,

Thanks for your reply.

But I am a bit confused.

I have followed the link, but I have found there are many folder and many SQL scripts under migration folder.

Here two things to consider.

* First of all I am running in Windows

* Second thing I have downloaded the source and running under eclipse for the first time.

So as a newbie and fresh install from within eclipse which all SQL scripts shall I run ?

Can any one direct me to the appropriate direction please, am stuck for two days ....

Thanks in advance for your kind help.

//Enamur Reza.

[Carlos Antonio Ruiz Gomez]

Hi Enamur, fastest way, just download from daily installers - those don't need to apply patches or scripts:

http://www.idempiere.org/downloads

Regards,

Carlos Ruiz


El 10/08/15 a las 00:45, Enamur Reza escribió:

[Alfredo Flores Aybar]

Hi, import the updates from resource file 2.0 ---- 2.1 this would create new tables .

regards.

[Enrique Molina Ramirez]

Hi All,

I’ve just deployed my compiled version of iDempiere (sources downloaded from https://bitbucket.org/idempiere/idempiere on 15.09.2015) to my Linux

server, but when it comes to logging (SuperUser, System), it throws the following error message: “Table Name Not Found - AD_UserPreference”.

The file “…/myexperiment/org.adempiere.server-feature/feature.xml” tells that my iDempiere version is "3.0.0.qualifier”, 

so, based on that and following the official tutorial (http://wiki.idempiere.org/en/Importing_DB_Seed_Manually) I couldn’t find any migration scrips aimed at 

iDempiere-3.0 at the following location: “…/myexperiment/migration”, there are only scripts intended for i2.0(z), i1.0(z) BUT iDempiere-Dev-3.0.

Regardless of this, I also executed the automated “syncApplied.sh for PostgreSQL” and it states this: ”Database is up to date, no scripts to apply”.

Furthermore, I also executed all *.sql scripts located at this location: “…/myexperiment/migration/processes_post_migration/postgresql” successfully but it doesn’t change my situation.

Then, I watched the generated logs in the location “/opt/idempiere.gtk.linux.x86_64/idempiere-server/log” and the last one tracked the following:

[

java.lang.IllegalArgumentException: Table Name Not Found - AD_UserPreference

at org.compiere.model.Query.<init>(Query.java:126)

at org.compiere.model.MUserPreference.getUserPreference(MUserPreference.java:68)

at org.compiere.util.Login.loadUserPreferences(Login.java:1012)

at org.compiere.util.Login.loadPreferences(Login.java:843)

at org.adempiere.webui.panel.RolePanel.validateRoles(RolePanel.java:613)

at org.adempiere.webui.panel.RolePanel.onEvent(RolePanel.java:528)

at org.zkoss.zk.ui.AbstractComponent.onEvent(AbstractComponent.java:2752)

…

]

It seems that I followed all required and proper steps, could you please give me some advices on this matters, I’m really interested in learning and get involved with such project.

My configurations:

Server OS: Centos 7 (3.10.0-229.11.1.el7.x86_64)

Postgres: psql (PostgreSQL) 9.4.4

Database: idempiere_dev

Java: java version "1.7.0_85"

Url: http://192.168.188.100:8080/webui/

Development Environment:

OS: Mac OS X 10.9.3

Java: Oracle jdk1.7.0_75.jdk/

Eclipse: Eclipse Java EE Luna SR1 (4.4..1)

Thank you in advance for your support!

Regards, 

Enrique Molina.

[Dirk Niemeyer]

Hi Enrique,

as long as the next version is not officially released you have to apply
the migration scipts of tghe former version with a "z" attached.

Currently that means you have to apply 2.1z migrations.

You may just copy your syncApplied.sh to syncApplied21z.sh for example
and change the following lines:

JENKINSURL=http://ci.idempiere.org/job/iDempiere2.1Daily
to
JENKINSURL=http://ci.idempiere.org/job/iDempiereDaily

and further down
for FOLDER in i2.1
to
for FOLDER in i2.1z

Regards,
Dirk Niemeyer

Am 16.09.2015 um 19:43 schrieb Enrique Molina Ramirez:
>
> Hi All,
>
> I’ve just deployed my compiled version of iDempiere (sources downloaded
> from https://bitbucket.org/idempiere/idempiere on 15.09.2015) to my Linux
>
> server, but when it comes to logging (SuperUser, System), it throws the
> following error message: “Table Name Not Found - AD_UserPreference”.
>
>

> The file “…/myexperiment/org.adempiere.server-feature/*feature.xml*” tells

[Enrique Molina Ramirez]

Hi Dirk Niemeyer, 

Thank you for answering so promptly, I've just done what you said and it resolved my problem, by the way I only used my local migration scripts instead those you mentioned from http://ci.idempiere.org/job/iDempiere2.1Daily.

Procedure:

# cd /root/iDempiere_Dev/migration/i2.1z/postgresql

# cat *.sql | psql -d idempiere_dev -U adempiere

# password [******]

All done successfully.

Then, I tried the application and it works like a charm, so far.

Thank you so much Dirk Niemeyer!

Regards

Enrique M.