SELECT TO_DATE($1) + to_number($2) as fecha FROM DUAL;

Date: 2026-07-15 13:28:10
Duration: 0ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide

Times Reported Most Frequent Error / Event #1

x Hide

ERROR: invalid input syntax for type numeric: "A1"

Context: PL/pgSQL function redm_getinvidsinvalidseq(character varying) line 55 at RAISE
Statement: SELECT * FROM (select c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'El documento ' || documentno || ' para el documento ' || doc.name ||' tiene un salto de número en la secuencia del tipo de documento de la factura' as description, 'Y' as isActive, inv.ad_org_id, inv.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier('c_invoice', c_invoice_id, 'es_ES') AS RECORD_ID FROM c_invoice inv left join c_doctype doc on doc.c_doctype_id = inv.c_doctype_id WHERE c_invoice_id IN ( select distinct unnest(string_to_array(string_agg(redm_getinvidsinvalidseq(dt.docnosequence_id), ','), ',')) as idsinvoices from c_doctype dt where dt.isactive='Y' and dt.issotrx='Y' and dt.docbasetype='ARI' and dt.ad_table_id='318') order by doc.name, documentno ) AAA where not exists (select 1 from ad_alert a where a.ad_alertrule_id = $1 and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED')

Date: 2026-07-15 08:00:00
Database: etendo
Application: openbravo
User: tad
Remote: 127.0.0.1

ERROR: invalid input syntax for type numeric: "A1"

Context: PL/pgSQL function redm_getinvidsinvalidseq(character varying) line 55 at RAISE
Statement: SELECT * FROM (select c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'El documento ' || documentno || ' para el documento ' || doc.name ||' tiene un salto de número en la secuencia del tipo de documento de la factura' as description, 'Y' as isActive, inv.ad_org_id, inv.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier('c_invoice', c_invoice_id, 'es_ES') AS RECORD_ID FROM c_invoice inv left join c_doctype doc on doc.c_doctype_id = inv.c_doctype_id WHERE c_invoice_id IN ( select distinct unnest(string_to_array(string_agg(redm_getinvidsinvalidseq(dt.docnosequence_id), ','), ',')) as idsinvoices from c_doctype dt where dt.isactive='Y' and dt.issotrx='Y' and dt.docbasetype='ARI' and dt.ad_table_id='318') order by doc.name, documentno ) AAA where not exists (select 1 from ad_alert a where a.ad_alertrule_id = $1 and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED')

Date: 2026-07-15 10:00:00
Database: etendo
Application: openbravo
User: tad
Remote: 127.0.0.1

ERROR: invalid input syntax for type numeric: "A1"

Context: PL/pgSQL function redm_getinvidsinvalidseq(character varying) line 55 at RAISE
Statement: SELECT * FROM (select c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'El documento ' || documentno || ' para el documento ' || doc.name ||' tiene un salto de número en la secuencia del tipo de documento de la factura' as description, 'Y' as isActive, inv.ad_org_id, inv.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier('c_invoice', c_invoice_id, 'es_ES') AS RECORD_ID FROM c_invoice inv left join c_doctype doc on doc.c_doctype_id = inv.c_doctype_id WHERE c_invoice_id IN ( select distinct unnest(string_to_array(string_agg(redm_getinvidsinvalidseq(dt.docnosequence_id), ','), ',')) as idsinvoices from c_doctype dt where dt.isactive='Y' and dt.issotrx='Y' and dt.docbasetype='ARI' and dt.ad_table_id='318') order by doc.name, documentno ) AAA where not exists (select 1 from ad_alert a where a.ad_alertrule_id = $1 and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED')

Date: 2026-07-15 12:00:00
Database: etendo
Application: openbravo
User: tad
Remote: 127.0.0.1

x Hide

Times Reported Most Frequent Error / Event #2

x Hide

ERROR: new row for relation "gl_journalline" violates check constraint "gl_journalline_mgl_glj_check"

Detail: Failing row contains (E0763E414F8B48938F993ACF553CF3E5, 73C274948F8740F79262757A4C49F520, 1E1950FA7CAE42B2ABB35B4CB3A2E201, Y, 2026-07-15 18:40:02.317, D3A2F512BCFA457F97CC8B343C38DA08, 2026-07-15 18:40:02.317, D3A2F512BCFA457F97CC8B343C38DA08, 51DE3E96C5F2406BB4DD9E7EA051E82F, 10, N, APLICACION RESULTADO 2024 PROJECTUM, 0, 0, 102, S, 1, 0.00, 0.00, 100, 0, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, N, null, null, null, Y).
Statement: insert into GL_JournalLine (AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, GL_Journal_ID, Line, IsGenerated, Description, AmtSourceDr, AmtSourceCr, C_Currency_ID, CurrencyRateType, CurrencyRate, AmtAcctDr, AmtAcctCr, C_UOM_ID, Open_Items, EM_Aprm_Addpayment, GL_JournalLine_ID) values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22)

Date: 2026-07-15 18:40:02
Database: etendo
Application: openbravo
User: tad
Remote: 127.0.0.1

ERROR: new row for relation "gl_journalline" violates check constraint "gl_journalline_mgl_glj_check"

Detail: Failing row contains (7F7A4BF3C3834FD3BA043C3A1CD2C873, 73C274948F8740F79262757A4C49F520, 1E1950FA7CAE42B2ABB35B4CB3A2E201, Y, 2026-07-15 18:40:23.222, D3A2F512BCFA457F97CC8B343C38DA08, 2026-07-15 18:40:23.222, D3A2F512BCFA457F97CC8B343C38DA08, 51DE3E96C5F2406BB4DD9E7EA051E82F, 20, N, APLICACION RESULTADO 2024 PROJECTUM, 0, 0, 102, S, 1, 0.00, 0.00, 100, 0, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, N, null, null, null, Y).
Statement: insert into GL_JournalLine (AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, GL_Journal_ID, Line, IsGenerated, Description, AmtSourceDr, AmtSourceCr, C_Currency_ID, CurrencyRateType, CurrencyRate, AmtAcctDr, AmtAcctCr, C_UOM_ID, Open_Items, EM_Aprm_Addpayment, GL_JournalLine_ID) values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22)

Date: 2026-07-15 18:40:23
Database: etendo
Application: openbravo
User: tad
Remote: 127.0.0.1

x Hide

Times Reported Most Frequent Error / Event #3

x Hide

ERROR: more than one row returned by a subquery used as an expression

Context: SQL statement "UPDATE obdpl_fact_acct_pl pl SET ismodified = 'Y' WHERE ismodified IS NULL AND pl.account_id = (SELECT COALESCE(tr.parent_id, OLD.account_id) FROM obfdr_translate_accounts tr WHERE tr.node_id = OLD.account_id) AND pl.ad_client_id = OLD.ad_client_id AND pl.c_acctschema_id = OLD.c_acctschema_id AND pl.dateacct = OLD.dateacct AND COALESCE(pl.c_period_id, '0') = COALESCE(OLD.c_period_id, '0') AND COALESCE(pl.c_bpartner_id, '0') = COALESCE(OLD.c_bpartner_id, '0') AND COALESCE(pl.m_product_id, '0') = COALESCE(OLD.m_product_id, '0') AND COALESCE(pl.c_project_id, '0') = COALESCE(OLD.c_project_id, '0') AND COALESCE(pl.user1_id, '0') = COALESCE(OLD.user1_id, '0') AND COALESCE(pl.c_costcenter_id, '0') = COALESCE(OLD.c_costcenter_id, '0') AND COALESCE(pl.user2_id, '0') = COALESCE(OLD.user2_id, '0') AND COALESCE(pl.c_activity_id, '0') = COALESCE(OLD.c_activity_id, '0') AND COALESCE(pl.c_campaign_id, '0') = COALESCE(OLD.c_campaign_id, '0') AND COALESCE(pl.ad_org_id, '0') = COALESCE(OLD.ad_org_id, '0') AND COALESCE(pl.obanaly_accountingdate, '0') = COALESCE(OLD.em_obanaly_accountingdate, '0') AND COALESCE(pl.ad_orgtrx_id, '0') = COALESCE(OLD.ad_orgtrx_id, '0') AND COALESCE(pl.c_locfrom_id, '0') = COALESCE(OLD.c_locfrom_id, '0') AND COALESCE(pl.c_locto_id, '0') = COALESCE(OLD.c_locto_id, '0') AND COALESCE(pl.c_salesregion_id, '0') = COALESCE(OLD.c_salesregion_id, '0') AND COALESCE(pl.a_asset_id, '0') = COALESCE(OLD.a_asset_id, '0') AND COALESCE(pl.m_locator_id, '0') = COALESCE(OLD.m_locator_id, '0') AND COALESCE(pl.fact_acct_group_id, '0') = COALESCE(OLD.fact_acct_group_id, '0')" PL/pgSQL function obdpl_fact_acct_trg() line 43 at SQL statement
Statement: update Fact_Acct set EM_Obanaly_Accountingdate=$1 where DateAcct=$2 and (DateAcct is not null and EM_Obanaly_Accountingdate is null)

Date: 2026-07-15 10:56:03
Database: etendo
Application: openbravo
User: tad
Remote: 127.0.0.1

ERROR: more than one row returned by a subquery used as an expression

Context: SQL statement "UPDATE obdpl_fact_acct_pl pl SET ismodified = 'Y' WHERE ismodified IS NULL AND pl.account_id = (SELECT COALESCE(tr.parent_id, OLD.account_id) FROM obfdr_translate_accounts tr WHERE tr.node_id = OLD.account_id) AND pl.ad_client_id = OLD.ad_client_id AND pl.c_acctschema_id = OLD.c_acctschema_id AND pl.dateacct = OLD.dateacct AND COALESCE(pl.c_period_id, '0') = COALESCE(OLD.c_period_id, '0') AND COALESCE(pl.c_bpartner_id, '0') = COALESCE(OLD.c_bpartner_id, '0') AND COALESCE(pl.m_product_id, '0') = COALESCE(OLD.m_product_id, '0') AND COALESCE(pl.c_project_id, '0') = COALESCE(OLD.c_project_id, '0') AND COALESCE(pl.user1_id, '0') = COALESCE(OLD.user1_id, '0') AND COALESCE(pl.c_costcenter_id, '0') = COALESCE(OLD.c_costcenter_id, '0') AND COALESCE(pl.user2_id, '0') = COALESCE(OLD.user2_id, '0') AND COALESCE(pl.c_activity_id, '0') = COALESCE(OLD.c_activity_id, '0') AND COALESCE(pl.c_campaign_id, '0') = COALESCE(OLD.c_campaign_id, '0') AND COALESCE(pl.ad_org_id, '0') = COALESCE(OLD.ad_org_id, '0') AND COALESCE(pl.obanaly_accountingdate, '0') = COALESCE(OLD.em_obanaly_accountingdate, '0') AND COALESCE(pl.ad_orgtrx_id, '0') = COALESCE(OLD.ad_orgtrx_id, '0') AND COALESCE(pl.c_locfrom_id, '0') = COALESCE(OLD.c_locfrom_id, '0') AND COALESCE(pl.c_locto_id, '0') = COALESCE(OLD.c_locto_id, '0') AND COALESCE(pl.c_salesregion_id, '0') = COALESCE(OLD.c_salesregion_id, '0') AND COALESCE(pl.a_asset_id, '0') = COALESCE(OLD.a_asset_id, '0') AND COALESCE(pl.m_locator_id, '0') = COALESCE(OLD.m_locator_id, '0') AND COALESCE(pl.fact_acct_group_id, '0') = COALESCE(OLD.fact_acct_group_id, '0')" PL/pgSQL function obdpl_fact_acct_trg() line 43 at SQL statement
Statement: update Fact_Acct set EM_Obanaly_Accountingdate=$1 where DateAcct=$2 and (DateAcct is not null and EM_Obanaly_Accountingdate is null)

Date: 2026-07-15 15:30:00
Database: etendo
Application: openbravo
User: tad
Remote: 127.0.0.1

x Hide

Times Reported Most Frequent Error / Event #4

x Hide

ERROR: @20633@

Context: PL/pgSQL function m_product_trg() line 97 at RAISE
Statement: update M_Product set Updated=$1, M_AttributeSet_ID=$2 where M_Product_ID=$3

Date: 2026-07-15 11:29:55
Database: etendo
Application: openbravo
User: tad
Remote: 127.0.0.1

x Hide

Times Reported Most Frequent Error / Event #5

x Hide

ERROR: Purchase Order-1000091,@ActivePoSo@

Context: PL/pgSQL function m_product_trg() line 121 at RAISE
Statement: update M_Product set Updated=$1, Weight=$2, M_AttributeSet_ID=$3, C_Uom_Weight_ID=$4, EM_Opxtrd_Pais_Origen=$5, EM_Opxtrd_Partida_Arancelaria=$6, EM_Opxtrd_Peso_Bruto=$7 where M_Product_ID=$8

Date: 2026-07-15 08:22:10
Database: etendo
Application: openbravo
User: tad
Remote: 127.0.0.1

x Hide

Times Reported Most Frequent Error / Event #6

x Hide

ERROR: update or delete on table "m_product" violates foreign key constraint "c_orderline_m_product" on table "c_orderline"

Detail: Key (m_product_id)=(C21BBD9F4F944189BA3593D2AD6EFBA0) is still referenced from table "c_orderline".
Statement: delete from M_Product where M_Product_ID=$1

Date: 2026-07-15 08:17:14
Database: etendo
Application: openbravo
User: tad
Remote: 127.0.0.1

x Hide

Times Reported Most Frequent Error / Event #7

x Hide

ERROR: @APRM_JSAMOUNTDIFFTOZERO@

Context: PL/pgSQL function gl_journalline_trg() line 67 at RAISE
Statement: insert into GL_JournalLine (AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, GL_Journal_ID, Line, IsGenerated, Description, AmtSourceDr, AmtSourceCr, C_Currency_ID, CurrencyRateType, CurrencyRate, AmtAcctDr, AmtAcctCr, C_UOM_ID, C_ValidCombination_ID, Open_Items, EM_Aprm_Addpayment, GL_JournalLine_ID) values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23)

Date: 2026-07-15 18:39:58
Database: etendo
Application: openbravo
User: tad
Remote: 127.0.0.1

x Hide