Table Name Not Found - AD_System [Solved]

[joaquin65]

Hi!
My name is Joaquín. I've spent the last couple of days trying to install Adempiere without success.
I've read a lot about some political trouble of the comunity, and concluded that iDempiere seems the best option.
But since iDemp has no official release yet, I'm trying to install Ademp to get used to the interface and start learning how to use it.

I've listed the process of instalation and setup that i've followed.
I'd like to get some help, if possible.
So, let's begin

Minor issues:
There are some issues I found while trying to install the software.

1.- The windows installers don't have the Adempiere.dmp files in the /data directory nor elsewhere.

Because of this I had to manually install the adempiere piece (I have to use the Java that comes with the adempiere windows installer because of the following issue).
PostgreSQL seems to work either way.

2.- It seems that Adempiere doesn't work with the latest version of Java. I installed 1.7 and adempiere complains and asks for 1.6.

3.- The installer named Adempiere361Aug_Setup.exe gives me the "Adempiere not bound" error when testing the connection with the server (which I host locally, already started in 6s700ms (smells wrong xD))

That's all regarding compatibility issues, or little problems.
Now with the serious stuff.

Serious Stuff

I got a step higher by installing the latest standalone Adempiere (unzipped in C:\) and using the Java and PostgreSQL installed by the adempiere windows installer (both installed in C:\). I will copy and paste the relevant parts from the post I made in the support forums.

In first place (after installing everything) I log into the windows user "postgres", open pgadmin and create the database "adempiere".
Then I use the RUN_Setup script. Put all the correct data and hit "Test" button. Everything seems okay (with the corresponding checkmark at the right) except the Database name field. The value here is "adempiere", the same name of the database I created earlier. But I don't get the checkmark.
The ugly part starts when I run the RUN_ImportAdempiere thing.
First I get:

Code: Select all

WARNING: valor no valido para el parametro Â<<search_pathÂ>>: Â<<adempiere, sqlj, pg_catalogÂ>> DETALLE: no existe el esquema Â<<adempiereÂ>>

and some more similar stuff
(That means something like "not valid value for parameter Â<<search_pathÂ>>: Â<<adempiere, sqlj, pg_catalogÂ>>. Â<<adempiereÂ>> schema doesnt exist.)

Then I get lots of the following messages:

Code: Select all

CREATE TABLE psql:C/Adempiere/data/Adempiere_pg.dmp:13020: ERROR: no existe el rol Â<<adempiereÂ>>

(that means "role Â<<adempiereÂ>> doesn't exist" or something like that.).

Then I log in the windows user "postgres" with my password, check the pg admin and yes, there are lots of tables under the adempiere schema.
Then I go back to my main user, start the server, and open the client. I check the app server and database thing (both green checkmarks), and try to log in with the user that comes by default.

Code: Select all

Table Name Not Found - AD_System

That's as far as I could get.
I did this several times now, and already read all the installation guides.
I also noted that there's a big hole in the step-by-step AdempiereSUPER1s.pdf guide, right in the part between ending the installation process and start using the program.
It skips the RUN_Setup part, RUN_ImportAdempiere, RUN_Server2 and god knows what more.
If I get the software to work I'd be glad to contribute to the comunity as a way of retribution.
Besides, I'd probably have to customize some things to fit my needs, these customizations can be contributed as well.

Thanks,
Joaquín.

EDIT: I downloaded the windows 64 packages provided here: http://www.globalqss.com/wiki/index.php ... Installers
iDempiere seems to have the same java compatibility issue. This time I have java 1.6, and I get the following message when executing adempiere-client

Code: Select all

Java HotSpot(TM) 64-Bit Server VM - 1.7.0_4 <> 1.5.0

[red1]

Hi joaquin65,
Welcome to the wild world of the bazaar!
You wrote quite alot to allow anyone to focus on which part to help you. Since you tried the latest WindowsInstaller let me just help you with that:
1. Just try it again because it has worked everywhere else. There is no Adempiere.dmp there because i use the ExpDat.dmp instead (adding some more later works into it, thus it is backup into the ExpDat.dmp).
2. Any other error must be conditions with your PC environment which you can google to find out why.

3. I am finishing up the latest installer for iDempiere so you can practice with present installer until that comes out, so you be a bit more experienced then.

Good luck.

[joaquin65]

Hi.
In first place, thanks for the answer.

As you said, I tried again. Clean unninstall and all. Didn't work either.
According to the Adempiere wiki, the windows installer should work right out of the box.
This is not my case.
I will try on other computers to continue with the testing.

EDIT: Removed the words of disappointment about the poor support.

Good bye.

[globalqss]

> In first place (after installing everything) I log into the windows user "postgres",
> open pgadmin and create the database "adempiere".

This is unneeded - and indeed is wrong - adempiere requires a user adempiere (at least in postgresql), and with this user you create the database.

[joaquin65]

AT LAST, I could login.
I created a windows user "adempiere" and installed everything under that user.
I also created a role in pgadmin called "adempiere".
I had to install the lastest version of PostgreSQL downloaded from their website in order to make it work (the one that came by defaul lacked psql.exe in %POSTGRES_HOME%/bin).

Gracias!