Erro RUN_DBRestore.sh


#1

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® Release 3.6.0LTS_2010-06-14 -Smart Suite ERP,CRM and SCM- © 1999-2010 ADempiere®; Implementation: ${ADEMPIERE_VERSION} 20120806-1024 - ${ADEMPIERE_VENDOR}
*** 2012-08-13 14:33:48.789 Adempiere Log (CLogConsole) ***
14:33:48.788 Adempiere.startup: ADempiere® Release 3.6.0LTS_2010-06-14 -Smart Suite ERP,CRM and SCM- © 1999-2010 ADempiere®; 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.(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: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.(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: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.(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)

*** 2012-08-13 14:33:56.15 Adempiere Log (CLogConsole) ***


#2

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

postgresql/DBRestore.sh: not found