Erro RUN_DBRestore.sh

Tópicos sobre a extensão das funcionalides do Compiere / Adempiere utilizando apenas o Dicionário da Aplicação
xefdomingos
Mensagens: 5
Registrado em: Sex Mai 11, 2012 1:05 pm

Erro RUN_DBRestore.sh

Mensagempor xefdomingos » Seg Ago 13, 2012 2:40 pm

Instalei o Adempiere na maquina Debian occoreu tudo certo porem nao estou conseguindo rodar o script RUN_DBRestore.sh
aparece a seguinte mensagen
...........................................................................................................................................................................................................
Setting myEnvironment ....
Restore Adempiere Database from Export- /opt/Adempiere (adempiere)
Re-Create Adempiere User and import /opt/Adempiere/data/ExpDat.dmp
== The import will show warnings. This is OK ==
26748 -rw-r--r-- 1 henrique henrique 27354855 Dez 22 2010 /opt/Adempiere/data/ExpDat.dmp
Press enter to continue ...

./RUN_DBRestore.sh: 19: postgresql/DBRestore.sh: not found
Install Adempiere Server
Setting myEnvironment ....
===================================
Sign Database Build
===================================
CLogFile[/opt/Adempiere/log/2012-08-13_11.log,Level=ALL]
*** 2012-08-13 14:33:48.789 Adempiere Log (ConsoleHandler) ***
14:33:48.788 Adempiere.startup: ADempiere(r) Release 3.6.0LTS_2010-06-14 -Smart Suite ERP,CRM and SCM- (c) 1999-2010 ADempiere(r); Implementation: ${ADEMPIERE_VERSION} 20120806-1024 - ${ADEMPIERE_VENDOR}
*** 2012-08-13 14:33:48.789 Adempiere Log (CLogConsole) ***
14:33:48.788 Adempiere.startup: ADempiere(r) Release 3.6.0LTS_2010-06-14 -Smart Suite ERP,CRM and SCM- (c) 1999-2010 ADempiere(r); Implementation: ${ADEMPIERE_VERSION} 20120806-1024 - ${ADEMPIERE_VENDOR}
14:33:48.808 Ini.loadProperties: /opt/Adempiere/Adempiere.properties #34
14:33:48.808 Ini.loadProperties: /opt/Adempiere/Adempiere.properties #34
[INFO] MLog clients using com.mchange.v2.log.FallbackMLog logging.
[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 -> z8kfsx8p9648c21mo1p2h|4cc39a20, idleConnectionTestPeriod -> 1200, initialPoolSize -> 10, jdbcUrl -> jdbc:postgresql://localhost: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.<init>(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.<init>(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:478)
at java.util.logging.Logger.doLog(Logger.java:500)
at java.util.logging.Logger.log(Logger.java:589)
at org.compiere.model.MTable.get(MTable.java:113)
at org.compiere.model.Query.<init>(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.<init>(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:478)
at java.util.logging.Logger.doLog(Logger.java:500)
at java.util.logging.Logger.log(Logger.java:589)
at org.compiere.model.MTable.get(MTable.java:113)
at org.compiere.model.Query.<init>(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.<init>(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.<init>(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.<init>(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)

*** 2012-08-13 14:33:56.15 Adempiere Log (CLogConsole) ***
............................................................................................................................................................................
Anexos
Captura_de_tela-4.png
Captura_de_tela-4.png (142.23 KiB) Visto 1402 vezes
Captura_de_tela-2.png
Captura_de_tela-2.png (133.49 KiB) Visto 1402 vezes

ralexsander
Mensagens: 564
Registrado em: Ter Nov 21, 2006 7:43 am
Localização: São Paulo
Contato:

Re: Erro RUN_DBRestore.sh

Mensagempor ralexsander » Seg Ago 13, 2012 2:49 pm

Verifique a sua instalação do Adempiere, pois aparentemente está faltando um arquivo:

Código: Selecionar todos

postgresql/DBRestore.sh: not found
Ricardo Alexsander Santana
http://www.kenos.com.br


Voltar para “Desenvolvimento - AD”

Quem está online

Usuários neste fórum: Nenhum usuário registrado e 1 visitante