[RESOLVIDO] Sincronizador de Terminologia não funciona

catia.alessandra · 2011-01-25 16:04:16 UTC

Criei algumas tabelas no ADempiere, assim como suas janelas, e quando rodei o Sincronizador de Terminologia, os campos em inglês (Client, Organization) não traduziram.
Alguém sabe de um motivo para isso ocorrer?

Desde ja agradeço.

ralexsander · 2011-01-25 16:13:28 UTC

Olhe o log para ver se gerou algum erro. No Adempiere 342 existia um BUG que não deixava o processo ser executado por completo, caso tenha sido criado algum registro na aba Parâmetro da Janela Processo, sem respeitar as maiúsculas e minúsculas.

catia.alessandra · 2011-01-25 16:23:30 UTC

Realmente, retornou 20erros:

===========> DB.executeUpdate: UPDATE AD_MENU SET Name = (SELECT p.Name FROM AD_WORKFLOW p WHERE AD_MENU.AD_Workflow_ID=p.AD_Workflow_ID), Description = (SELECT p.Description FROM AD_WORKFLOW p WHERE AD_MENU.AD_Workflow_ID=p.AD_Workflow_ID) WHERE AD_MENU.AD_Workflow_ID IS NOT NULL AND AD_MENU.“action” = ‘F’ [SvrProcess_4c973a77-09bc-482f-b5d5-f27c15ad63f1] [16]
org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block; State=25P02; 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.executeUpdate(AbstractJdbc2Statement.java:305)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
at org.compiere.util.CPreparedStatement.executeUpdate(CPreparedStatement.java:188)
at org.compiere.util.DB.executeUpdate(DB.java:903)
at org.compiere.util.DB.executeUpdate(DB.java:832)
at org.compiere.process.SynchronizeTerminology.doIt(SynchronizeTerminology.java:633)
at org.compiere.process.SvrProcess.process(SvrProcess.java:134)
at org.compiere.process.SvrProcess.startProcess(SvrProcess.java:92)
at org.adempiere.util.ProcessUtil.startJavaProcess(ProcessUtil.java:116)
at org.compiere.apps.ProcessCtl.startProcess(ProcessCtl.java:653)
at org.compiere.apps.ProcessCtl.run(ProcessCtl.java:396)
at java.lang.Thread.run(Thread.java:619)

===========> DB.saveError: DBExecuteError - ERROR: current transaction is aborted, commands ignored until end of transaction block [16]

===========> DB.executeUpdate: UPDATE AD_MENU_TRL SET Name = (SELECT pt.Name FROM AD_WORKFLOW_TRL pt, AD_MENU m WHERE AD_MENU_TRL.AD_Menu_ID=m.AD_Menu_ID AND m.AD_Workflow_ID=pt.AD_Workflow_ID AND AD_MENU_TRL.AD_LANGUAGE=pt.AD_LANGUAGE), Description = (SELECT pt.Description FROM AD_WORKFLOW_TRL pt, AD_MENU m WHERE AD_MENU_TRL.AD_Menu_ID=m.AD_Menu_ID AND m.AD_Workflow_ID=pt.AD_Workflow_ID AND AD_MENU_TRL.AD_LANGUAGE=pt.AD_LANGUAGE), IsTranslated = (SELECT pt.IsTranslated FROM AD_WORKFLOW_TRL pt, AD_MENU m WHERE AD_MENU_TRL.AD_Menu_ID=m.AD_Menu_ID AND m.AD_Workflow_ID=pt.AD_Workflow_ID AND AD_MENU_TRL.AD_LANGUAGE=pt.AD_LANGUAGE) WHERE EXISTS (SELECT 1 FROM AD_WORKFLOW_TRL pt, AD_MENU m WHERE AD_MENU_TRL.AD_Menu_ID=m.AD_Menu_ID AND m.AD_Workflow_ID=pt.AD_Workflow_ID AND AD_MENU_TRL.AD_LANGUAGE=pt.AD_LANGUAGE AND m.AD_Workflow_ID IS NOT NULL AND “action” = ‘F’) [SvrProcess_4c973a77-09bc-482f-b5d5-f27c15ad63f1] [16]
org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block; State=25P02; 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.executeUpdate(AbstractJdbc2Statement.java:305)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
at org.compiere.util.CPreparedStatement.executeUpdate(CPreparedStatement.java:188)
at org.compiere.util.DB.executeUpdate(DB.java:903)
at org.compiere.util.DB.executeUpdate(DB.java:832)
at org.compiere.process.SynchronizeTerminology.doIt(SynchronizeTerminology.java:651)
at org.compiere.process.SvrProcess.process(SvrProcess.java:134)
at org.compiere.process.SvrProcess.startProcess(SvrProcess.java:92)
at org.adempiere.util.ProcessUtil.startJavaProcess(ProcessUtil.java:116)
at org.compiere.apps.ProcessCtl.startProcess(ProcessCtl.java:653)
at org.compiere.apps.ProcessCtl.run(ProcessCtl.java:396)
at java.lang.Thread.run(Thread.java:619)

===========> DB.saveError: DBExecuteError - ERROR: current transaction is aborted, commands ignored until end of transaction block [16]

===========> DB.executeUpdate: UPDATE AD_MENU SET Name = (SELECT Name FROM AD_TASK f WHERE AD_MENU.AD_Task_ID=f.AD_Task_ID), Description = (SELECT Description FROM AD_TASK f WHERE AD_MENU.AD_Task_ID=f.AD_Task_ID) WHERE AD_Task_ID IS NOT NULL AND “action” = ‘T’ [SvrProcess_4c973a77-09bc-482f-b5d5-f27c15ad63f1] [16]
org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block; State=25P02; 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.executeUpdate(AbstractJdbc2Statement.java:305)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
at org.compiere.util.CPreparedStatement.executeUpdate(CPreparedStatement.java:188)
at org.compiere.util.DB.executeUpdate(DB.java:903)
at org.compiere.util.DB.executeUpdate(DB.java:832)
at org.compiere.process.SynchronizeTerminology.doIt(SynchronizeTerminology.java:661)
at org.compiere.process.SvrProcess.process(SvrProcess.java:134)
at org.compiere.process.SvrProcess.startProcess(SvrProcess.java:92)
at org.adempiere.util.ProcessUtil.startJavaProcess(ProcessUtil.java:116)
at org.compiere.apps.ProcessCtl.startProcess(ProcessCtl.java:653)
at org.compiere.apps.ProcessCtl.run(ProcessCtl.java:396)
at java.lang.Thread.run(Thread.java:619)

===========> DB.saveError: DBExecuteError - ERROR: current transaction is aborted, commands ignored until end of transaction block [16]

===========> DB.executeUpdate: UPDATE AD_MENU_TRL SET Name = (SELECT ft.Name FROM AD_TASK_TRL ft, AD_MENU m WHERE AD_MENU_TRL.AD_Menu_ID=m.AD_Menu_ID AND m.AD_Task_ID=ft.AD_Task_ID AND AD_MENU_TRL.AD_LANGUAGE=ft.AD_LANGUAGE), Description = (SELECT ft.Description FROM AD_TASK_TRL ft, AD_MENU m WHERE AD_MENU_TRL.AD_Menu_ID=m.AD_Menu_ID AND m.AD_Task_ID=ft.AD_Task_ID AND AD_MENU_TRL.AD_LANGUAGE=ft.AD_LANGUAGE), IsTranslated = (SELECT ft.IsTranslated FROM AD_TASK_TRL ft, AD_MENU m WHERE AD_MENU_TRL.AD_Menu_ID=m.AD_Menu_ID AND m.AD_Task_ID=ft.AD_Task_ID AND AD_MENU_TRL.AD_LANGUAGE=ft.AD_LANGUAGE) WHERE EXISTS (SELECT 1 FROM AD_TASK_TRL ft, AD_MENU m WHERE AD_MENU_TRL.AD_Menu_ID=m.AD_Menu_ID AND m.AD_Task_ID=ft.AD_Task_ID AND AD_MENU_TRL.AD_LANGUAGE=ft.AD_LANGUAGE AND m.AD_Task_ID IS NOT NULL AND “action” = ‘T’) [SvrProcess_4c973a77-09bc-482f-b5d5-f27c15ad63f1] [16]
org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block; State=25P02; 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.executeUpdate(AbstractJdbc2Statement.java:305)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
at org.compiere.util.CPreparedStatement.executeUpdate(CPreparedStatement.java:188)
at org.compiere.util.DB.executeUpdate(DB.java:903)
at org.compiere.util.DB.executeUpdate(DB.java:832)
at org.compiere.process.SynchronizeTerminology.doIt(SynchronizeTerminology.java:679)
at org.compiere.process.SvrProcess.process(SvrProcess.java:134)
at org.compiere.process.SvrProcess.startProcess(SvrProcess.java:92)
at org.adempiere.util.ProcessUtil.startJavaProcess(ProcessUtil.java:116)
at org.compiere.apps.ProcessCtl.startProcess(ProcessCtl.java:653)
at org.compiere.apps.ProcessCtl.run(ProcessCtl.java:396)
at java.lang.Thread.run(Thread.java:619)

===========> DB.saveError: DBExecuteError - ERROR: current transaction is aborted, commands ignored until end of transaction block [16]

===========> DB.executeUpdate: UPDATE AD_COLUMN SET Name=e.Name,Description=e.Description,Help=e.Help FROM AD_ELEMENT e WHERE AD_COLUMN.AD_Element_ID=e.AD_Element_ID AND EXISTS (SELECT 1 FROM AD_ELEMENT e WHERE AD_COLUMN.AD_Element_ID=e.AD_Element_ID AND AD_COLUMN.Name<>e.Name) [SvrProcess_4c973a77-09bc-482f-b5d5-f27c15ad63f1] [16]
org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block; State=25P02; 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.executeUpdate(AbstractJdbc2Statement.java:305)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
at org.compiere.util.CPreparedStatement.executeUpdate(CPreparedStatement.java:188)
at org.compiere.util.DB.executeUpdate(DB.java:903)
at org.compiere.util.DB.executeUpdate(DB.java:832)
at org.compiere.process.SynchronizeTerminology.doIt(SynchronizeTerminology.java:692)
at org.compiere.process.SvrProcess.process(SvrProcess.java:134)
at org.compiere.process.SvrProcess.startProcess(SvrProcess.java:92)
at org.adempiere.util.ProcessUtil.startJavaProcess(ProcessUtil.java:116)
at org.compiere.apps.ProcessCtl.startProcess(ProcessCtl.java:653)
at org.compiere.apps.ProcessCtl.run(ProcessCtl.java:396)
at java.lang.Thread.run(Thread.java:619)

===========> DB.saveError: DBExecuteError - ERROR: current transaction is aborted, commands ignored until end of transaction block [16]

===========> DB.executeUpdate: UPDATE AD_COLUMN_TRL SET Name = (SELECT e.Name FROM AD_COLUMN c INNER JOIN AD_ELEMENT_TRL e ON (c.AD_Element_ID=e.AD_Element_ID) WHERE AD_COLUMN_TRL.AD_Column_ID=c.AD_Column_ID AND AD_COLUMN_TRL.AD_LANGUAGE=e.AD_LANGUAGE) WHERE EXISTS (SELECT 1 FROM AD_COLUMN c INNER JOIN AD_ELEMENT_TRL e ON (c.AD_Element_ID=e.AD_Element_ID) WHERE AD_COLUMN_TRL.AD_Column_ID=c.AD_Column_ID AND AD_COLUMN_TRL.AD_LANGUAGE=e.AD_LANGUAGE AND AD_COLUMN_TRL.Name<>e.Name) [SvrProcess_4c973a77-09bc-482f-b5d5-f27c15ad63f1] [16]
org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block; State=25P02; 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.executeUpdate(AbstractJdbc2Statement.java:305)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
at org.compiere.util.CPreparedStatement.executeUpdate(CPreparedStatement.java:188)
at org.compiere.util.DB.executeUpdate(DB.java:903)
at org.compiere.util.DB.executeUpdate(DB.java:832)
at org.compiere.process.SynchronizeTerminology.doIt(SynchronizeTerminology.java:702)
at org.compiere.process.SvrProcess.process(SvrProcess.java:134)
at org.compiere.process.SvrProcess.startProcess(SvrProcess.java:92)
at org.adempiere.util.ProcessUtil.startJavaProcess(ProcessUtil.java:116)
at org.compiere.apps.ProcessCtl.startProcess(ProcessCtl.java:653)
at org.compiere.apps.ProcessCtl.run(ProcessCtl.java:396)
at java.lang.Thread.run(Thread.java:619)

===========> DB.saveError: DBExecuteError - ERROR: current transaction is aborted, commands ignored until end of transaction block [16]

===========> DB.executeUpdate: UPDATE AD_TABLE SET Name=e.Name,Description=e.Description FROM AD_ELEMENT e WHERE AD_TABLE.TableName||’_ID’=e.ColumnName AND EXISTS (SELECT 1 FROM AD_ELEMENT e WHERE AD_TABLE.TableName||’_ID’=e.ColumnName AND AD_TABLE.Name<>e.Name) [SvrProcess_4c973a77-09bc-482f-b5d5-f27c15ad63f1] [16]
org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block; State=25P02; 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.executeUpdate(AbstractJdbc2Statement.java:305)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
at org.compiere.util.CPreparedStatement.executeUpdate(CPreparedStatement.java:188)
at org.compiere.util.DB.executeUpdate(DB.java:903)
at org.compiere.util.DB.executeUpdate(DB.java:832)
at org.compiere.process.SynchronizeTerminology.doIt(SynchronizeTerminology.java:714)
at org.compiere.process.SvrProcess.process(SvrProcess.java:134)
at org.compiere.process.SvrProcess.startProcess(SvrProcess.java:92)
at org.adempiere.util.ProcessUtil.startJavaProcess(ProcessUtil.java:116)
at org.compiere.apps.ProcessCtl.startProcess(ProcessCtl.java:653)
at org.compiere.apps.ProcessCtl.run(ProcessCtl.java:396)
at java.lang.Thread.run(Thread.java:619)

===========> DB.saveError: DBExecuteError - ERROR: current transaction is aborted, commands ignored until end of transaction block [16]

===========> DB.executeUpdate: UPDATE AD_TABLE_TRL SET Name = (SELECT e.Name FROM AD_TABLE t INNER JOIN AD_ELEMENT ex ON (t.TableName||’_ID’=ex.ColumnName) INNER JOIN AD_ELEMENT_TRL e ON (ex.AD_Element_ID=e.AD_Element_ID) WHERE AD_TABLE_TRL.AD_Table_ID=t.AD_Table_ID AND AD_TABLE_TRL.AD_LANGUAGE=e.AD_LANGUAGE) WHERE EXISTS (SELECT 1 FROM AD_TABLE t INNER JOIN AD_ELEMENT ex ON (t.TableName||’_ID’=ex.ColumnName) INNER JOIN AD_ELEMENT_TRL e ON (ex.AD_Element_ID=e.AD_Element_ID) WHERE AD_TABLE_TRL.AD_Table_ID=t.AD_Table_ID AND AD_TABLE_TRL.AD_LANGUAGE=e.AD_LANGUAGE AND AD_TABLE_TRL.Name<>e.Name) [SvrProcess_4c973a77-09bc-482f-b5d5-f27c15ad63f1] [16]
org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block; State=25P02; 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.executeUpdate(AbstractJdbc2Statement.java:305)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
at org.compiere.util.CPreparedStatement.executeUpdate(CPreparedStatement.java:188)
at org.compiere.util.DB.executeUpdate(DB.java:903)
at org.compiere.util.DB.executeUpdate(DB.java:832)
at org.compiere.process.SynchronizeTerminology.doIt(SynchronizeTerminology.java:727)
at org.compiere.process.SvrProcess.process(SvrProcess.java:134)
at org.compiere.process.SvrProcess.startProcess(SvrProcess.java:92)
at org.adempiere.util.ProcessUtil.startJavaProcess(ProcessUtil.java:116)
at org.compiere.apps.ProcessCtl.startProcess(ProcessCtl.java:653)
at org.compiere.apps.ProcessCtl.run(ProcessCtl.java:396)
at java.lang.Thread.run(Thread.java:619)

===========> DB.saveError: DBExecuteError - ERROR: current transaction is aborted, commands ignored until end of transaction block [16]

===========> DB.executeUpdate: UPDATE AD_TABLE SET Name=e.Name||’ Trl’,Description=e.Description FROM AD_ELEMENT e WHERE SUBSTR(AD_TABLE.TableName,1,LENGTH(AD_TABLE.TableName)-4)||’_ID’=e.ColumnName AND AD_TABLE.TableName LIKE ‘%_Trl’ AND EXISTS (SELECT 1 FROM AD_ELEMENT e WHERE SUBSTR(AD_TABLE.TableName,1,LENGTH(AD_TABLE.TableName)-4)||’_ID’=e.ColumnName AND AD_TABLE.Name<>e.Name) [SvrProcess_4c973a77-09bc-482f-b5d5-f27c15ad63f1] [16]
org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block; State=25P02; 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.executeUpdate(AbstractJdbc2Statement.java:305)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
at org.compiere.util.CPreparedStatement.executeUpdate(CPreparedStatement.java:188)
at org.compiere.util.DB.executeUpdate(DB.java:903)
at org.compiere.util.DB.executeUpdate(DB.java:832)
at org.compiere.process.SynchronizeTerminology.doIt(SynchronizeTerminology.java:739)
at org.compiere.process.SvrProcess.process(SvrProcess.java:134)
at org.compiere.process.SvrProcess.startProcess(SvrProcess.java:92)
at org.adempiere.util.ProcessUtil.startJavaProcess(ProcessUtil.java:116)
at org.compiere.apps.ProcessCtl.startProcess(ProcessCtl.java:653)
at org.compiere.apps.ProcessCtl.run(ProcessCtl.java:396)
at java.lang.Thread.run(Thread.java:619)

===========> DB.saveError: DBExecuteError - ERROR: current transaction is aborted, commands ignored until end of transaction block [16]

===========> DB.executeUpdate: UPDATE AD_TABLE_TRL SET Name = (SELECT e.Name || ’ **’ FROM AD_TABLE t INNER JOIN AD_ELEMENT ex ON (SUBSTR(t.TableName,1,LENGTH(t.TableName)-4)||’_ID’=ex.ColumnName) INNER JOIN AD_ELEMENT_TRL e ON (ex.AD_Element_ID=e.AD_Element_ID) WHERE AD_TABLE_TRL.AD_Table_ID=t.AD_Table_ID AND AD_TABLE_TRL.AD_LANGUAGE=e.AD_LANGUAGE) WHERE EXISTS (SELECT 1 FROM AD_TABLE t INNER JOIN AD_ELEMENT ex ON (SUBSTR(t.TableName,1,LENGTH(t.TableName)-4)||’_ID’=ex.ColumnName) INNER JOIN AD_ELEMENT_TRL e ON (ex.AD_Element_ID=e.AD_Element_ID) WHERE AD_TABLE_TRL.AD_Table_ID=t.AD_Table_ID AND AD_TABLE_TRL.AD_LANGUAGE=e.AD_LANGUAGE AND t.TableName LIKE ‘%_Trl’ AND AD_TABLE_TRL.Name<>e.Name) [SvrProcess_4c973a77-09bc-482f-b5d5-f27c15ad63f1] [16]
org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block; State=25P02; 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.executeUpdate(AbstractJdbc2Statement.java:305)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
at org.compiere.util.CPreparedStatement.executeUpdate(CPreparedStatement.java:188)
at org.compiere.util.DB.executeUpdate(DB.java:903)
at org.compiere.util.DB.executeUpdate(DB.java:832)
at org.compiere.process.SynchronizeTerminology.doIt(SynchronizeTerminology.java:752)
at org.compiere.process.SvrProcess.process(SvrProcess.java:134)
at org.compiere.process.SvrProcess.startProcess(SvrProcess.java:92)
at org.adempiere.util.ProcessUtil.startJavaProcess(ProcessUtil.java:116)
at org.compiere.apps.ProcessCtl.startProcess(ProcessCtl.java:653)
at org.compiere.apps.ProcessCtl.run(ProcessCtl.java:396)
at java.lang.Thread.run(Thread.java:619)

===========> DB.saveError: DBExecuteError - ERROR: current transaction is aborted, commands ignored until end of transaction block [16]

Não sei o que pode ser, vou dar uma procurada, se alguem souber ajudar, agradeço.

Obrigada

ralexsander · 2011-01-26 14:03:05 UTC

Neste log não dá pra saber ao certo qual é erro, pois o Adempiere está mostrando apenas os últimos erros, mas com certeza ocorreu algum erro antes, o que gerou os erros seguintes, se tiver como rodar pelo eclipse da pra ver todos os erros. Dá pra perceber pela mensagem: ERROR: current transaction is aborted, commands ignored until end of transaction block

Tente olhar nos últimos processos que foram criados na sua empresa, se existe algum em que o nome da coluna esteja tudo em minúsculo e mude para case-sensitive.

Att.

catia.alessandra · 2011-01-29 13:05:59 UTC

Eu alterei alguns processos que estavam todo em minúsculo, coloquei as iniciais em maiúsculo e tal, mas continua dando o mesmo log de erro.
O estranho, é que quando é gerado um relatório, os itens que são em inglês, aparecem traduzidos no relatório!

mgrigioni · 2011-01-31 10:58:31 UTC

UPDATE AD_Process_Para SET IsCentrallyMaintained = 'N' where ad_element_id IS NULL;

execute este update no seu banco e depois tente novamente o processo de sincronizar terminologia.

catia.alessandra · 2011-01-31 11:27:27 UTC

Continua gerando o log de erro. Não sei mais o que pode ser.
Meu colega de trabalho disse que até mais ou menos um mês atrás estava funcionando.

mgrigioni · 2011-01-31 11:42:27 UTC

[code]SELECT UPPER(e.ColumnName), COUNT(*)

FROM AD_Element e

group by UPPER(e.ColumnName)[/code]

verifique se vc não tem elementos com o mesmo nome, pode ser ai um problema

catia.alessandra · 2011-01-31 11:49:44 UTC

Todos vieram com o count 1.
Isso quer dizer que não está repetido, correto?

mgrigioni · 2011-01-31 12:39:27 UTC

Se está com 1 em tudo e vc rodou aquele update do AD_Process_Para, juro que não sei qual é o problema…

Faz o seguinte, roda em modo debug o processo SynchronizeTerminology que está em base/src/org.compiere.process e dai verifica em qual statement ele tá dando erro… e dai precisa caçar a causa…

Em algum lugar ele está bloqueando a transaction e dai todos os statements seguintes tbm vão dar erro.

catia.alessandra · 2011-01-31 15:43:35 UTC

Está dando esse erro:

[i]===========> DB.executeUpdate: UPDATE AD_PROCESS_PARA SET ColumnName = (SELECT e.ColumnName FROM AD_ELEMENT e WHERE e.ColumnName=AD_PROCESS_PARA.ColumnName) WHERE AD_PROCESS_PARA.IsCentrallyMaintained=‘Y’ AND AD_PROCESS_PARA.IsActive=‘Y’ AND EXISTS (SELECT 1 FROM AD_ELEMENT e WHERE UPPER(e.ColumnName)=UPPER(AD_PROCESS_PARA.ColumnName) AND e.ColumnName<>AD_PROCESS_PARA.ColumnName) [SvrProcess_a1c2840d-6ab6-4503-b2c0-a2e4806586a2] [11]
org.postgresql.util.PSQLException: ERROR: null value in column “columnname” violates not-null constraint; State=23502; 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.executeUpdate(AbstractJdbc2Statement.java:305)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
at org.compiere.util.CPreparedStatement.executeUpdate(CPreparedStatement.java:188)
at org.compiere.util.DB.executeUpdate(DB.java:903)
at org.compiere.util.DB.executeUpdate(DB.java:832)
at org.compiere.process.SynchronizeTerminology.doIt(SynchronizeTerminology.java:300)
at org.compiere.process.SvrProcess.process(SvrProcess.java:134)
at org.compiere.process.SvrProcess.startProcess(SvrProcess.java:92)
at org.adempiere.util.ProcessUtil.startJavaProcess(ProcessUtil.java:116)
at org.compiere.apps.ProcessCtl.startProcess(ProcessCtl.java:653)
at org.compiere.apps.ProcessCtl.run(ProcessCtl.java:396)
at java.lang.Thread.run(Thread.java:619)

===========> DB.saveError: DBExecuteError - ERROR: null value in column “columnname” violates not-null constraint [11][/i]

Verifiquei todos os dados, aparentemente não tem nenhum registo nulo!

mgrigioni · 2011-01-31 16:00:13 UTC

Catia, altera o fonte e tenta colocar assim

+/- linha 311

// Sync Parameter ColumnName sql="UPDATE AD_PROCESS_PARA f" +" SET ColumnName = (SELECT e.ColumnName FROM AD_ELEMENT e" +" WHERE UPPER(e.ColumnName)=UPPER(f.ColumnName))" // +" WHERE e.ColumnName=f.ColumnName)" +" WHERE f.IsCentrallyMaintained='Y' AND f.IsActive='Y'" +" AND EXISTS (SELECT 1 FROM AD_ELEMENT e" +" WHERE UPPER(e.ColumnName)=UPPER(f.ColumnName)" +" AND e.ColumnName<>f.ColumnName)";

Na 3.6.0, eles fizeram uma alteração no select para comparar os dois campos com UPPER()… acho que isso deveria ser um bug mesmo…

catia.alessandra · 2011-01-31 16:19:49 UTC

Ah, agora funcionou!!!
Muito Obrigada pela ajuda.
Uma linha ‘descomentada’ e a outra comentada
hehehehe