Erro durante a instalação do lbr 3.6.0


#1

Bom dia pessoal,
Passei dias tentando instalar o AD e sempre com problemas, certamente estou errando alguma coisa e repito o erro, pesquisei bastante e nada, então aqui estamos estreiando no fórum e agradecendo antecipadamente a ajuda de vocês. Vamos lá:

-Windows XP
-2GB memória
-Baixei do site ADEMPIERELBR a versão para Postgres do LBR 3.6.0, o customization.jar(baixi na pasta LIB do AD) e o ExpDat.dmp(baixei na pasta DAT do AD)
-Baixei e instalei o Java JDK 6.24
-Baixei e instalei o Postgres 8.3.14-1
-Baixei o PL/Java 14, depois descobrí que do AD 3.2 em diante não precisa mais…
-Ajustei as variáveis de ambiente ADEMPIERE_HOME, JAVA_HOME, o path para o java e para o Postgres
-No Postgres criei a role adempiere, depois criei o BD adempiere e coloquei adempiere como proprietário e codificação UTF8
-Rodei o RUN_SETUP.BAT sem problema, primeiro para BD localhost, depois aprendí a liberar endereços de conexão no Postgres e fiz tbem para remoto

*Aqui começam os problemas, ao rodar o RUN_DBRESTORE.BAT com o dump que baixei do site adempierelbr deu um monte de pau, msg de truncar campos para tamanho de 4 e por aí afora, vi que não ia dar certo
-Matei o BD e criei novamente, então utilizei o RUN_ImportAdempiere que criou toda a estrutura legal na base do create table, alter table e tal…
-Agora rodei o RUN_SERVER2.BAT para startar o bicho, daqui é que não consigo passar pois dá pau pra caramba, segue abaixo:

Setting myEnvironment …
Start Adempiere Apps Server C:\ADempiere (adempiere)

JBoss Bootstrap Environment

JBOSS_HOME: C:\Adempiere\jboss

JAVA: C:\Arquivos de programas\Java\bin\java

JAVA_OPTS: -server -Xms64M -Xmx512M -DADEMPIERE_HOME=C:\ADempiere -Dorg.ademp
iere.server.embedded=true -Dprogram.name=run.bat -server -Xms128m -Xmx512m -XX:M
axPermSize=128m -Dsun.rmi.dgc.client.gcInterval=3600000 -Dsun.rmi.dgc.server.gcI
nterval=3600000

CLASSPATH: C:\Arquivos de programas\Java\lib\tools.jar;C:\Adempiere\jboss\bin
run.jar

===============================================================================

10:41:49,046 INFO [Server] Starting JBoss (MX MicroKernel)…
10:41:49,046 INFO [Server] Release ID: JBoss [Trinity] 4.2.3.GA (build: SVNTag=
JBoss_4_2_3_GA date=200807181417)
10:41:49,062 INFO [Server] Home Dir: C:\Adempiere\jboss
10:41:49,062 INFO [Server] Home URL: file:/C:/Adempiere/jboss/
10:41:49,062 INFO [Server] Patch URL: null
10:41:49,062 INFO [Server] Server Name: adempiere
10:41:49,062 INFO [Server] Server Home Dir: C:\Adempiere\jboss\server\adempiere

10:41:49,062 INFO [Server] Server Home URL: file:/C:/Adempiere/jboss/server/ade
mpiere/
10:41:49,062 INFO [Server] Server Log Dir: C:\Adempiere\jboss\server\adempiere
log
10:41:49,062 INFO [Server] Server Temp Dir: C:\Adempiere\jboss\server\adempiere
\tmp
10:41:49,078 INFO [Server] Root Deployment Filename: jboss-service.xml
10:41:51,656 INFO [ServerInfo] Java version: 1.6.0_13,Sun Microsystems Inc.
10:41:51,656 INFO [ServerInfo] Java VM: Java HotSpot™ Server VM 11.3-b02,Sun
Microsystems Inc.
10:41:51,656 INFO [ServerInfo] OS-System: Windows XP 5.1,x86
10:42:00,390 INFO [Server] Core system initialized
10:42:14,671 INFO [WebService] Using RMI server codebase: leonardo:8083/

10:42:14,687 INFO [Log4jService$URLWatchTimerTask] Configuring from URL: resour
ce:jboss-log4j.xml
10:42:17,015 INFO [TransactionManagerService] JBossTS Transaction Service (JTA
version) - JBoss Inc.
10:42:17,015 INFO [TransactionManagerService] Setting up property manager MBean
and JMX layer
10:42:17,687 INFO [TransactionManagerService] Starting recovery manager
10:42:18,062 INFO [TransactionManagerService] Recovery manager started
10:42:18,062 INFO [TransactionManagerService] Binding TransactionManager JNDI R
eference
10:42:30,937 INFO [EJB3Deployer] Starting java:comp multiplexer
10:42:34,609 INFO [Embedded] Catalina naming disabled
10:42:35,234 INFO [AprLifecycleListener] The Apache Tomcat Native library which
allows optimal performance in production environments was not found on the java
.library.path: C:\Arquivos de programas\Java\bin;.;C:\WINDOWS\Sun\Java\bin;C:\WI
NDOWS\system32;C:\WINDOWS;C:\Arquivos de programas\PHP;C:\ARQUIVOS DE PROGRAMAS
\ARQUIVOS COMUNS\BORLAND SHARED\BDE;C:\ARQUIVOS DE PROGRAMAS\BORLAND\BDS\3.0\BI
N;C:\WINDOWS\SYSTEM32;C:\WINDOWS;C:\WINDOWS\SYSTEM32\WBEM;C:\WINDOWS;C:\WINDOWS
SYSTEM32\WBEM;C:\WINDOWS\SYSTEM32;C:\Arquivos de programas\TortoiseSVN\bin;C:\Ar
quivos de programas\Java\bin;C:\Arquivos de programas\Java\jre\bin;C:\Arquivos d
e programas\Java\jre\bin\client;C:\Arquivos de programas\PostgreSQL\8.3\bin;C:\D
ocuments and Settings\Leonardo\Meus documentos\Borland Studio Projects\Bpl
10:42:35,468 INFO [Http11Protocol] Initializing Coyote HTTP/1.1 on http-leonard
o%2F192.168.1.153-8080
10:42:37,984 INFO [Http11Protocol] Initializing Coyote HTTP/1.1 on http-8443
10:42:38,000 INFO [AjpProtocol] Initializing Coyote AJP/1.3 on ajp-leonardo%2F1
92.168.1.153-8009
10:42:38,000 INFO [Catalina] Initialization processed in 3387 ms
10:42:38,000 INFO [StandardService] Starting service jboss.web
10:42:38,187 INFO [StandardEngine] Starting Servlet Engine: JBossWeb/2.0.1.GA
10:42:38,328 INFO [Catalina] Server startup in 324 ms
10:42:38,718 INFO [TomcatDeployer] deploy, ctxPath=/, warUrl=…/deploy/jboss-w
eb.deployer/ROOT.war/
10:42:42,531 INFO [RARDeployment] Required license terms exist, view META-INF/r
a.xml in …/deploy/jboss-ha-local-jdbc.rar
10:42:42,671 INFO [RARDeployment] Required license terms exist, view META-INF/r
a.xml in …/deploy/jboss-ha-xa-jdbc.rar
10:42:42,781 INFO [RARDeployment] Required license terms exist, view META-INF/r
a.xml in …/deploy/jboss-local-jdbc.rar
10:42:42,968 INFO [RARDeployment] Required license terms exist, view META-INF/r
a.xml in …/deploy/jboss-xa-jdbc.rar
10:42:43,078 INFO [RARDeployment] Required license terms exist, view META-INF/r
a.xml in …/deploy/mail-ra.rar
10:42:45,859 INFO [ConnectionFactoryBindingService] Bound ConnectionManager ‘jb
oss.jca:service=DataSourceBinding,name=DefaultDS’ to JNDI name ‘java:DefaultDS’
10:42:47,125 INFO [EARDeployer] Init J2EE application: file:/C:/Adempiere/jboss
/server/adempiere/deploy/adempiere.ear/
10:46:12,484 INFO [JmxKernelAbstraction] creating wrapper delegate for: org.jbo
ss.ejb3.stateless.StatelessContainer
10:46:12,515 INFO [JmxKernelAbstraction] installing MBean: jboss.j2ee:ear=ademp
iere.ear,jar=adempiereRoot.jar,name=adempiereServer,service=EJB3 with dependenci
es:
10:46:12,640 INFO [EJBContainer] STARTED EJB: org.compiere.session.ServerBean e
jbName: adempiereServer
10:46:12,890 INFO [JmxKernelAbstraction] creating wrapper delegate for: org.jbo
ss.ejb3.stateless.StatelessContainer
10:46:12,890 INFO [JmxKernelAbstraction] installing MBean: jboss.j2ee:ear=ademp
iere.ear,jar=adempiereRoot.jar,name=adempiereStatus,service=EJB3 with dependenci
es:
10:46:12,937 INFO [EJBContainer] STARTED EJB: org.compiere.session.StatusBean e
jbName: adempiereStatus
10:46:12,984 INFO [EJB3Deployer] Deployed: file:/C:/Adempiere/jboss/server/adem
piere/deploy/adempiere.ear/adempiereRoot.jar
10:46:13,000 INFO [TomcatDeployer] deploy, ctxPath=/adempiere, warUrl=…/tmp/d
eploy/tmp1230584712543611738adempiereApps-exp.war/
10:46:16,468 INFO [STDOUT] CLogFile[C:\ADempiere\log\2011-03-09_0.log,Level=ALL
]
10:46:16,484 ERROR [STDERR] *** 2011-03-09 10:46:16.484 Adempiere Log (ConsoleHa
ndler) ***
10:46:16.484 Adempiere.startup: ADempiere® 360LTS.010_2010-06-14 -Smart Suite
ERP,CRM and SCM- © 1999-2010 ADempiere®; Implementation: ${ADEMPIERE_VERSION
} 20110308-1650 - ${ADEMPIERE_VENDOR}
10:46:16,484 INFO [STDOUT] *** 2011-03-09 10:46:16.484 Adempiere Log (CLogConso
le) ***
10:46:16.484 Adempiere.startup: ADempiere® 360LTS.010_2010-06-14 -Smart Suite
ERP,CRM and SCM- © 1999-2010 ADempiere®; Implementation: ${ADEMPIERE_VERSION
} 20110308-1650 - ${ADEMPIERE_VENDOR}
10:46:16,531 ERROR [STDERR] 10:46:16.531 Ini.loadProperties: C:\ADempiere\Adempi
ere.properties #29
10:46:16,531 INFO [STDOUT] 10:46:16.531 Ini.loadProperties: C:\ADempiere\Adempi
ere.properties #29
10:46:21,359 ERROR [STDERR] [INFO] MLog clients using com.mchange.v2.log.Fallbac
kMLog logging.
10:46:22,078 ERROR [STDERR] [INFO] Initializing c3p0-0.9.1.2 [built 21-May-2007
15:04:56; debug? true; trace: 10]
10:46:22,734 ERROR [STDERR] [INFO] Initializing c3p0 pool… com.mchange.v2.c3p0
.ComboPooledDataSource [ acquireIncrement -> 3, acquireRetryAttempts -> 2, acqui
reRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, br
eakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClass
Name -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConne
ctionTester, dataSourceName -> AdempiereDS, debugUnreturnedConnectionStackTraces
-> false, description -> null, driverClass -> org.postgresql.Driver, factoryCla
ssLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken ->
1hge17d8e16yxox31mi5bz5|92ed85, idleConnectionTestPeriod -> 1200, initialPoolSi
ze -> 10, jdbcUrl -> jdbc:postgresql://leonardo:5432/adempiere?encoding=UNICODE,
maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 1200, max
IdleTimeExcessConnections -> 1200, maxPoolSize -> 150, maxStatements -> 0, maxSt
atementsPerConnection -> 0, minPoolSize -> 5, numHelperThreads -> 3, numThreadsA
waitingCheckoutDefaultUser -> 0, preferredTestQuery -> SELECT Version FROM AD_Sy
stem, properties -> {user=******, password=******}, propertyCycle -> 0, testConn
ectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectio
nTimeout -> 0, usesTraditionalReflectiveProxies -> false ]
10:46:35,296 ERROR [STDERR] -----------> EMail.setFrom: you @ company.org: javax
.mail.internet.AddressException: Local address contains control or whitespace in
string you @ company.org'' 10:46:35,296 ERROR [STDERR] -----------> EMail.setFrom: you @ company.org: javax .mail.internet.AddressException: Local address contains control or whitespace in stringyou @ company.org’’
10:46:35,406 ERROR [STDERR] -----------> EMail.addTo: you @ company.org: javax.m
ail.internet.AddressException: Local address contains control or whitespace in s
tring you @ company.org'' 10:46:35,406 ERROR [STDERR] -----------> EMail.addTo: you @ company.org: javax.m ail.internet.AddressException: Local address contains control or whitespace in s tringyou @ company.org’’
10:46:35,421 ERROR [STDERR] -----------> EMail.isValid: From is invalid=null
10:46:35,421 ERROR [STDERR] -----------> EMail.isValid: From is invalid=null
10:46:35,421 ERROR [STDERR] -----------> EMail.isValid: From is invalid=null
10:46:35,453 ERROR [STDERR] -----------> EMail.isValid: From is invalid=null
10:46:35,468 ERROR [STDERR] -----------> MClient.sendEMail: Could NOT Send Email
: Server started: ? to you @ company.org: Invalid Data (System)
10:46:35,468 ERROR [STDERR] -----------> MClient.sendEMail: Could NOT Send Email
: Server started: ? to you @ company.org: Invalid Data (System)
10:46:35,875 INFO [TomcatDeployer] deploy, ctxPath=/admin, warUrl=…/tmp/deplo
y/tmp3157156727259832799adempiereRoot-exp.war/
10:46:36,468 ERROR [STDERR] ===========> Env.getContextAsDate: No value for: #Da
te
10:46:39,687 ERROR [STDERR] ===========> Env.getContextAsDate: No value for: #Da
te
10:46:49,156 INFO [TomcatDeployer] deploy, ctxPath=/, warUrl=…/tmp/deploy/tmp
7401189514847629046adempiereWebCM-exp.war/
10:46:49,734 INFO [TomcatDeployer] deploy, ctxPath=/wstore, warUrl=…/tmp/depl
oy/tmp882615913830352173adempiereWebStore-exp.war/
10:46:51,187 INFO [TomcatDeployer] deploy, ctxPath=/posterita, warUrl=…/tmp/d
eploy/tmp1745678764510137858posterita-exp.war/
10:46:51,359 INFO [WebappClassLoader] validateJarFile(C:\Adempiere\jboss\server
\adempiere.\tmp\deploy\tmp1745678764510137858posterita-exp.war\WEB-INF\lib\serv
let.jar) - jar not loaded. See Servlet Spec 2.3, section 9.7.2. Offending class:
javax/servlet/Servlet.class
10:46:51,781 ERROR [STDERR] log4j:ERROR A “org.jboss.logging.appender.FileAppend
er” object is not assignable to a “org.apache.log4j.Appender” variable.
10:46:51,781 ERROR [STDERR] log4j:ERROR The class “org.apache.log4j.Appender” wa
s loaded by
10:46:51,781 ERROR [STDERR] log4j:ERROR [WebappClassLoader
delegate: false
repositories:
/WEB-INF/classes/
----------> Parent Classloader:
java.net.FactoryURLClassLoader@1b1a986
] whereas object of type
10:46:51,781 ERROR [STDERR] log4j:ERROR "org.jboss.logging.appender.FileAppender
" was loaded by [org.jboss.system.server.NoAnnotationURLClassLoader@13caecd].
10:46:51,781 ERROR [STDERR] log4j:ERROR Could not instantiate appender named “FI
LE”.
10:46:51,968 INFO [STDOUT] 10:46:51,968 INFO [ResponseOverrideFilter] Filter i
nitialized. Response buffering is enabled
10:46:56,796 INFO [TomcatDeployer] deploy, ctxPath=/webui, warUrl=…/tmp/deplo
y/tmp1838356028820038499webui-exp.war/
10:47:04,609 INFO [EARDeployer] Started J2EE application: file:/C:/Adempiere/jb
oss/server/adempiere/deploy/adempiere.ear/
10:47:04,843 INFO [Http11Protocol] Starting Coyote HTTP/1.1 on http-leonardo%2F
192.168.1.153-8080
10:47:04,906 INFO [Http11Protocol] Starting Coyote HTTP/1.1 on http-8443
10:47:04,953 INFO [AjpProtocol] Starting Coyote AJP/1.3 on ajp-leonardo%2F192.1
68.1.153-8009
10:47:05,000 INFO [Server] JBoss (MX MicroKernel) [4.2.3.GA (build: SVNTag=JBos
s_4_2_3_GA date=200807181417)] Started in 5m:15s:922ms
10:47:48,812 ERROR [STDERR] -----------> EMail.setFrom: you @ company.org: javax
.mail.internet.AddressException: Local address contains control or whitespace in
string you @ company.org'' [11] 10:47:48,812 ERROR [STDERR] -----------> EMail.setFrom: you @ company.org: javax .mail.internet.AddressException: Local address contains control or whitespace in stringyou @ company.org’’ [11]
10:47:48,812 ERROR [STDERR] -----------> EMail.addTo: admin @ gardenworld.com: j
avax.mail.internet.AddressException: Local address contains control or whitespac
e in string admin @ gardenworld.com'' [11] 10:47:48,812 ERROR [STDERR] -----------> EMail.addTo: admin @ gardenworld.com: j avax.mail.internet.AddressException: Local address contains control or whitespac e in stringadmin @ gardenworld.com’’ [11]
10:47:48,812 ERROR [STDERR] -----------> EMail.isValid: From is invalid=null [11
]
10:47:48,828 ERROR [STDERR] -----------> EMail.isValid: From is invalid=null [11
]
10:47:48,828 ERROR [STDERR] -----------> EMail.isValid: From is invalid=null [11
]
10:47:48,828 ERROR [STDERR] -----------> EMail.isValid: From is invalid=null [11
]
10:47:49,296 ERROR [STDERR] -----------> MClient.sendEmailNow: Could NOT Send Em
ail: Inactivity Alert: Request 10000002 to admin @ gardenworld.com: Invalid Data
(GardenWorld) [11]
10:47:49,296 ERROR [STDERR] -----------> MClient.sendEmailNow: Could NOT Send Em
ail: Inactivity Alert: Request 10000002 to admin @ gardenworld.com: Invalid Data
(GardenWorld) [11]

*Tentei diversas vezes e mesmo problema, pensei ter errado algum detalhe na instalação e varrí a internet, li manuais e postagens, nada…
-Pensando que poderia ter errado algum passo baixei do adempiere.org a versão que instala tudo para vc, o super111, então arranquei tudo que era java e postgres da minha maquina e deixei por conta do super111, alias achei legal a musica do Red1. Acabei descobrindo que o postgres que ele instala não tem o executor de linha de comando PSQL, arranquei fora o postgres que o super111 instalou e instalei o mei, aí sim pude rodar os batches, no entanto deu o mesmo problema na hora de rodar o RUN_SERVER2.BAT
-Ahí partí para outra maquina para ter um comparativo, instalei o super111, sempre tendo que trocar o postgres no final, deu mesma coisa
-Nisso aí acabou o carnaval, não consegui rodar mas tenho certeza que ainda vai dar certo, além do que ainda tenho que aprender: usar o AD, aprender sua parametrização, criar campos e tabelas, carregar ele no Eclipse para fazer programação adicional, então muita coisa vai dar errado ainda e conto com a ajuda de vocês…

Muito obrigado e desculpem a extensão do post,

Leonardo


#2

Olá Leonardo,

Bem-vindo ao fórum.

Por padrão o Adempiere vem com uma empresa de exemplo (GardenWorld), onde você pode fazer seus testes. Nesta empresa a configuração de e-mail não funciona até que você preencha com dados válidos, até lá vão aparecer estes erros na hora de subir o RUN_Server2.bat.

Para ver se você fez tudo certo, tente abrir a página WEB após rodar o RUN_Server2.bat (IP:PORTA), lembre-se de configurar o hostname da máquina no seu servidor de DNS ou no hosts da máquina, pois se você configurar como localhost o RUN_Server2.bat só vai funcionar no servidor.

Abs


#3

Quer dizer que estava funcionando o tempo todo e o que eu julgava serem erros eram apenas advertências, quanto sofrimento a toa, hehehe.
Mas blz, consegui entrar pelo fatclient, entrei no sistema pela primeira vez(que emoção…) só que tudo em português, vou procurar aqui no forum que lembro de ter topado com os passos para chavear para português.

Agora via navegador não consegui, tentei a mesma porta que aparece no RUN_ADEMPIERE que é 1099 e lá colocando o nome do servidor fica okverdinho, mas no navegador quando coloco leonardo:1099 ele pede para abrir ou fazer download de um arquivo não identificado do tipo octet stream que se chama uhyhm3jl.part ???

Muito obrigado,

Leonardo


#4

Leonardo,

1099 é a porta que a aplicação vai usar, no browser vc conecta pela porta web que também é um parâmetro da configuração. Se você não mudou deve ser a 80, mas verifique se o IIS não está rodando nesta porta, se estiver é só mudar na configuração do Adempiere para 8080 ou outra porta de sua preferência e rodar o RUN_setup ou RUN_silentsetup para efetivar a mudança.

Att.


#5

Legal, era isso mesmo, utilizei a porta 8080 e show de bola, agora vou em frente para aprender a estrutura do ERP e a forma de operacionalizar, estou em Curitiba e qualquer troca de ideia é bem vinda. Ricardo muito obrigado e um pouco mais para frente estaremos colaborando com o projeto,

Sds,

Leonardo


#6

Ao instalar o ADempiere 3.6.0, após rodar o RUN_setup.sh, ocorre este erro:

BUILD SUCCESSFUL
Total time: 8 minutes 16 seconds

*** 2011-05-03 10:10:50.844 Adempiere Log (CLogConsole) ***

===================================
Make .sh executable
Install Adempiere Server
Setting myEnvironment …

Sign Database Build

CLogFile[/opt/Adempiere/log/2011-05-03_1.log,Level=ALL]
*** 2011-05-03 10:11:02.23 Adempiere Log (ConsoleHandler) ***
10:11:02.229 Adempiere.startup: ADempiere® Release 3.6.0LTS_2010-06-14 -Smart Suite ERP,CRM and SCM- © 1999-2010 ADempiere®; Implementation: ${ADEMPIERE_VERSION} 20110503-1002 - ${ADEMPIERE_VENDOR}
*** 2011-05-03 10:11:02.23 Adempiere Log (CLogConsole) ***
10:11:02.229 Adempiere.startup: ADempiere® Release 3.6.0LTS_2010-06-14 -Smart Suite ERP,CRM and SCM- © 1999-2010 ADempiere®; Implementation: ${ADEMPIERE_VERSION} 20110503-1002 - ${ADEMPIERE_VENDOR}
10:11:02.264 Ini.loadProperties: /opt/Adempiere/Adempiere.properties #29
10:11:02.264 Ini.loadProperties: /opt/Adempiere/Adempiere.properties #29
[INFO] MLog clients using com.mchange.v2.log.FallbackMLog logging.
[INFO] Failed to get local InetAddress for VMID. This is unlikely to matter. At all. We’ll add some extra randomnessjava.net.UnknownHostException: erpserver: erpserver
at java.net.InetAddress.getLocalHost(InetAddress.java:1354)
at com.mchange.v2.c3p0.impl.C3P0ImplUtils.generateVmId(C3P0ImplUtils.java:120)
at com.mchange.v2.c3p0.impl.C3P0ImplUtils.(C3P0ImplUtils.java:98)
at com.mchange.v2.c3p0.impl.PoolBackedDataSourceBase.(PoolBackedDataSourceBase.java:227)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.(AbstractPoolBackedDataSource.java:62)
at com.mchange.v2.c3p0.ComboPooledDataSource.(ComboPooledDataSource.java:109)
at com.mchange.v2.c3p0.ComboPooledDataSource.(ComboPooledDataSource.java:105)
at org.compiere.db.DB_PostgreSQL.getDataSource(DB_PostgreSQL.java:550)
at org.compiere.db.CConnection.getDatabase(CConnection.java:1223)
at org.compiere.db.CConnection.getConnection(CConnection.java:1304)
at org.compiere.util.DB.createConnection(DB.java:443)
at org.compiere.util.DB.getConnectionRW(DB.java:373)
at org.compiere.util.DB.isConnected(DB.java:341)
at org.compiere.util.DB.isConnected(DB.java:319)
at org.compiere.Adempiere.startupEnvironment(Adempiere.java:524)
at org.compiere.Adempiere.startup(Adempiere.java:511)
at org.compiere.Adempiere.startupEnvironment(Adempiere.java:523)
at org.adempiere.process.SignDatabaseBuild.main(SignDatabaseBuild.java:40)

[INFO] Initializing c3p0-0.9.1.2 [built 21-May-2007 15:04:56; debug? true; trace: 10]
[INFO] Initializing c3p0 pool… com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 3, acquireRetryAttempts -> 2, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> AdempiereDS, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> org.postgresql.Driver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> gnbmypd8kjiu1k44vlt|1d520c4, idleConnectionTestPeriod -> 1200, initialPoolSize -> 10, jdbcUrl -> jdbc:postgresql://10.0.0.181:5432/adempiere?encoding=UNICODE, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 1200, maxIdleTimeExcessConnections -> 1200, maxPoolSize -> 150, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 5, numHelperThreads -> 3, numThreadsAwaitingCheckoutDefaultUser -> 0, preferredTestQuery -> SELECT Version FROM AD_System, properties -> {user=******, password=******}, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false ]
===========> MTable.get: SELECT * FROM AD_Table WHERE UPPER(TableName)=?
org.postgresql.util.PSQLException: ERROR: relation “ad_table” does not exist; State=42P01; ErrorCode=0
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.compiere.db.StatementProxy.invoke(StatementProxy.java:100)
at $Proxy0.executeQuery(Unknown Source)
at org.compiere.model.MTable.get(MTable.java:104)
at org.compiere.model.Query.(Query.java:121)
at org.compiere.model.MSystem.get(MSystem.java:70)
at org.compiere.Adempiere.startupEnvironment(Adempiere.java:529)
at org.compiere.Adempiere.startup(Adempiere.java:511)
at org.compiere.Adempiere.startupEnvironment(Adempiere.java:523)
at org.adempiere.process.SignDatabaseBuild.main(SignDatabaseBuild.java:40)

===========> MTable.get: SELECT * FROM AD_Table WHERE UPPER(TableName)=?
org.postgresql.util.PSQLException: ERROR: relation “ad_table” does not exist; State=42P01; ErrorCode=0
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.compiere.db.StatementProxy.invoke(StatementProxy.java:100)
at $Proxy0.executeQuery(Unknown Source)
at org.compiere.model.MTable.get(MTable.java:104)
at org.compiere.model.Query.(Query.java:121)
at org.compiere.model.MSystem.get(MSystem.java:70)
at org.compiere.model.MIssue.create(MIssue.java:68)
at org.compiere.util.CLogErrorBuffer.publish(CLogErrorBuffer.java:222)
at java.util.logging.Logger.log(Logger.java:481)
at java.util.logging.Logger.doLog(Logger.java:503)
at java.util.logging.Logger.log(Logger.java:592)
at org.compiere.model.MTable.get(MTable.java:113)
at org.compiere.model.Query.(Query.java:121)
at org.compiere.model.MSystem.get(MSystem.java:70)
at org.compiere.Adempiere.startupEnvironment(Adempiere.java:529)
at org.compiere.Adempiere.startup(Adempiere.java:511)
at org.compiere.Adempiere.startupEnvironment(Adempiere.java:523)

===========> MTable.get: SELECT * FROM AD_Table WHERE UPPER(TableName)=?
org.postgresql.util.PSQLException: ERROR: relation “ad_table” does not exist; State=42P01; ErrorCode=0
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.compiere.db.StatementProxy.invoke(StatementProxy.java:100)
at $Proxy0.executeQuery(Unknown Source)
at org.compiere.model.MTable.get(MTable.java:104)
at org.compiere.model.Query.(Query.java:121)
at org.compiere.model.MSystem.get(MSystem.java:70)
at org.compiere.model.MIssue.create(MIssue.java:68)
at org.compiere.util.CLogErrorBuffer.publish(CLogErrorBuffer.java:222)
at java.util.logging.Logger.log(Logger.java:481)
at java.util.logging.Logger.doLog(Logger.java:503)
at java.util.logging.Logger.log(Logger.java:592)
at org.compiere.model.MTable.get(MTable.java:113)
at org.compiere.model.Query.(Query.java:121)
at org.compiere.model.MSystem.get(MSystem.java:70)
at org.compiere.Adempiere.startupEnvironment(Adempiere.java:529)
at org.compiere.Adempiere.startup(Adempiere.java:511)
at org.compiere.Adempiere.startupEnvironment(Adempiere.java:523)

===========> MTable.get: SELECT * FROM AD_Table WHERE UPPER(TableName)=?
org.postgresql.util.PSQLException: ERROR: relation “ad_table” does not exist; State=42P01; ErrorCode=0
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.compiere.db.StatementProxy.invoke(StatementProxy.java:100)
at $Proxy0.executeQuery(Unknown Source)
at org.compiere.model.MTable.get(MTable.java:104)
at org.compiere.model.Query.(Query.java:121)
at org.compiere.model.MSystem.get(MSystem.java:70)
at org.compiere.Adempiere.startupEnvironment(Adempiere.java:529)
at org.compiere.Adempiere.startup(Adempiere.java:511)
at org.compiere.Adempiere.startupEnvironment(Adempiere.java:523)
at org.adempiere.process.SignDatabaseBuild.main(SignDatabaseBuild.java:40)

===========> MTable.get: SELECT * FROM AD_Table WHERE UPPER(TableName)=?
org.postgresql.util.PSQLException: ERROR: relation “ad_table” does not exist; State=42P01; ErrorCode=0
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.compiere.db.StatementProxy.invoke(StatementProxy.java:100)
at $Proxy0.executeQuery(Unknown Source)
at org.compiere.model.MTable.get(MTable.java:104)
at org.compiere.model.Query.(Query.java:121)
at org.compiere.model.MSystem.get(MSystem.java:70)
at org.compiere.Adempiere.startupEnvironment(Adempiere.java:529)
at org.compiere.Adempiere.startup(Adempiere.java:511)
at org.compiere.Adempiere.startupEnvironment(Adempiere.java:523)
at org.adempiere.process.SignDatabaseBuild.main(SignDatabaseBuild.java:40)

Exception in thread “main” java.lang.IllegalArgumentException: Table Name Not Found - AD_System
at org.compiere.model.Query.(Query.java:123)
at org.compiere.model.MSystem.get(MSystem.java:70)
at org.compiere.Adempiere.startupEnvironment(Adempiere.java:529)
at org.compiere.Adempiere.startup(Adempiere.java:511)
at org.compiere.Adempiere.startupEnvironment(Adempiere.java:523)
at org.adempiere.process.SignDatabaseBuild.main(SignDatabaseBuild.java:40)

*** 2011-05-03 10:11:13.644 Adempiere Log (CLogConsole) ***
Set Unix Environment

Setup Client Environment

$JAVA_HOME is set to /opt/jdk1.6.0_24 and $ADEMPIERE_HOME is set to /opt/Adempiere
.
For problems, check log file in base directory

O que seria?


#7

Boa tarde,

para os que estão ou estavam com problemas com a instalação do ADempiere 360LBR, na hora de restaurar o banco, usando o comando RUN_DBRestore.sh,
basta abrir o terminal e digitar export PATH=$PATH: e colocar o caminho aonde você instalou o plsql do seu postgresql .

Aqui no meu deu certo, para o Fedora 14 usando o Postgresql 8.4.

Obrigado pela ajuda Ricardo.

Abraço.