Olá pessoal!
Estou me documentando sobre o Adempiere para implantá-lo na nossa empresa. A instalação parece que deu certo, salvo por uma coisa.
O problema aparece ao iniciar o Adempiere. Acontece igual que o caso do Carlos Pauluk, após digitar as informações nas telas de login, eu uma mensagem parecida à dele, mas falando que a versão do BD é mais nova que a que o programa espera:
The program assumes Database version 2008-12-08, but Database has Version 2008-03-26.
This is likely to cause hard to fix errors.
Please stop and migrate the database immediately.
Aparecem dois botões, NO e MIGRATE.
Se eu selecionar o NO, ele entra no programa. O MIGRATE me direciona para uma página na web.
O funcionamento do programa parece correto, pero descubri que tem erros (suponho que pelas versões diferentes do BD). Por exemplo, ao ver “Informação de Produto”, e fazer a pesquisa do produto, no eclipse aparece o erro a seguir:
[code][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 -> 2rxcsc8911wxzth19rhtoc|12be1bd, idleConnectionTestPeriod -> 1200, initialPoolSize -> 1, jdbcUrl -> jdbc:postgresql://localhost:5432/adempiere?encoding=UNICODE, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 900, maxIdleTimeExcessConnections -> 1200, maxPoolSize -> 15, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 1, numHelperThreads -> 3, numThreadsAwaitingCheckoutDefaultUser -> 0, preferredTestQuery -> SELECT Version FROM AD_System, properties -> {user=******, password=******}, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false ]
-----------> DB.isBuildOK: Build Version Error
The program assumes build version ADempiere, but database has build version ${env.ADEMPIERE_VERSION} 20100624-0830.
This is likely to cause hard to fix errors.
Please contact administrator.
-----------> Msg.getMsg: NOT found: ProductCategory [11]
-----------> Msg.getMsg: NOT found: Brand [11]
-----------> Msg.translate: NOT found: Attributes [11]
-----------> Msg.translate: NOT found: UOM [11]
-----------> Msg.translate: NOT found: Brand [11]
===========> InfoProduct.run: SELECT Distinct(p.M_Product_ID), p.Discontinued, p.Value, p.Name, (select uot.name from c_uom_trl uot where uot.c_uom_id = p.c_uom_id and uot.ad_language = ‘pt_BR’) as uom, p.lbr_Brand, bomQtyAvailable(p.M_Product_ID,?,0) AS QtyAvailable, bomPriceList(p.M_Product_ID, pr.M_PriceList_Version_ID) AS PriceList, bomPriceStd(p.M_Product_ID, pr.M_PriceList_Version_ID) AS PriceStd, bomQtyOnHand(p.M_Product_ID,?,0) AS QtyOnHand, bomQtyReserved(p.M_Product_ID,?,0) AS QtyReserved, bomQtyOrdered(p.M_Product_ID,?,0) AS QtyOrdered, pa.IsInstanceAttribute, p.UPC FROM M_Product p LEFT OUTER JOIN M_ProductPrice pr ON (p.M_Product_ID=pr.M_Product_ID AND pr.IsActive=‘Y’) LEFT OUTER JOIN M_AttributeSet pa ON (p.M_AttributeSet_ID=pa.M_AttributeSet_ID) LEFT OUTER JOIN M_Product_PO ppo ON (p.M_Product_ID=ppo.M_Product_ID) LEFT OUTER JOIN C_BPartner bp ON (ppo.C_BPartner_ID=bp.C_BPartner_ID) WHERE p.IsActive=‘Y’ AND p.IsSummary=‘N’ AND pr.M_PriceList_Version_ID=? AND M_Product_Category_ID IN (111,112,105,106,107,108,109,110,2000000,2000001,0) AND p.AD_Client_ID IN(2000001,0) AND p.AD_Org_ID IN(2000001,0) AND p.M_Product_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 208 AND AD_User_ID <> 2000003 AND IsActive = ‘Y’ ) AND pa.M_AttributeSet_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 560 AND AD_User_ID <> 2000003 AND IsActive = ‘Y’ ) AND bp.C_BPartner_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 291 AND AD_User_ID <> 2000003 AND IsActive = ‘Y’ ) ORDER BY p.Name ASC [12]
org.postgresql.util.PSQLException: ERRO: coluna p.lbr_brand não existe; State=42703; ErrorCode=0
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:351)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:255)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at org.compiere.util.CPreparedStatement.executeQuery(CPreparedStatement.java:121)
at org.compiere.apps.search.Info$Worker.run(Info.java:1083)
===========> InfoProduct.run: SELECT Distinct(p.M_Product_ID), p.Discontinued, p.Value, p.Name, (select uot.name from c_uom_trl uot where uot.c_uom_id = p.c_uom_id and uot.ad_language = ‘pt_BR’) as uom, p.lbr_Brand, bomQtyAvailable(p.M_Product_ID,?,0) AS QtyAvailable, bomPriceList(p.M_Product_ID, pr.M_PriceList_Version_ID) AS PriceList, bomPriceStd(p.M_Product_ID, pr.M_PriceList_Version_ID) AS PriceStd, bomQtyOnHand(p.M_Product_ID,?,0) AS QtyOnHand, bomQtyReserved(p.M_Product_ID,?,0) AS QtyReserved, bomQtyOrdered(p.M_Product_ID,?,0) AS QtyOrdered, pa.IsInstanceAttribute, p.UPC FROM M_Product p LEFT OUTER JOIN M_ProductPrice pr ON (p.M_Product_ID=pr.M_Product_ID AND pr.IsActive=‘Y’) LEFT OUTER JOIN M_AttributeSet pa ON (p.M_AttributeSet_ID=pa.M_AttributeSet_ID) LEFT OUTER JOIN M_Product_PO ppo ON (p.M_Product_ID=ppo.M_Product_ID) LEFT OUTER JOIN C_BPartner bp ON (ppo.C_BPartner_ID=bp.C_BPartner_ID) WHERE p.IsActive=‘Y’ AND p.IsSummary=‘N’ AND pr.M_PriceList_Version_ID=? AND M_Product_Category_ID IN (111,112,105,106,107,108,109,110,2000000,2000001,0) AND p.AD_Client_ID IN(2000001,0) AND p.AD_Org_ID IN(2000001,0) AND p.M_Product_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 208 AND AD_User_ID <> 2000003 AND IsActive = ‘Y’ ) AND pa.M_AttributeSet_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 560 AND AD_User_ID <> 2000003 AND IsActive = ‘Y’ ) AND bp.C_BPartner_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 291 AND AD_User_ID <> 2000003 AND IsActive = ‘Y’ ) ORDER BY p.Name ASC [13]
org.postgresql.util.PSQLException: ERRO: coluna p.lbr_brand não existe; State=42703; ErrorCode=0
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:351)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:255)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at org.compiere.util.CPreparedStatement.executeQuery(CPreparedStatement.java:121)
at org.compiere.apps.search.Info$Worker.run(Info.java:1083)[/code]
- Tentei instalar a versão 343 mas dava erros devido a funções do LBR que tinham sido modificadas no Adempiere.
- Tentei instalar o trunk, mas estava com mais de 100 erros no código e não deu nem para compilar.
- Instalei a versão 341 e fiz a migração até a versão RC-110, mas aparece este erro da versão do BD…
Alguem pode me ajudar??
Obrigado
