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

Date: 2026-07-14 09:46:22
Duration: 0ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide

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-14 13:56:12
Duration: 0ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide

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-14 13:55:57
Duration: 0ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide

Times Reported Time consuming queries #1

x Hide

[ User: postgres - Total duration: 1s - Times executed: 1 ]

x Hide

[ Application: psql - Total duration: 1s - Times executed: 1 ]

x Hide

SELECT profile.take_sample ();

Date: 2026-07-14 12:00:02
Duration: 1s
Database: etendo
User: postgres
Remote: [local]
Application: psql

x Hide

Times Reported Time consuming queries #1

x Hide

[ User: postgres - Total duration: 1s - Times executed: 1 ]

x Hide

[ Application: psql - Total duration: 1s - Times executed: 1 ]

x Hide

SELECT profile.take_sample ();

Date: 2026-07-14 12:00:02
Duration: 1s
Database: etendo
User: postgres
Remote: [local]
Application: psql

x Hide

Times Reported Time consuming queries #1

x Hide

[ User: postgres - Total duration: 1s - Times executed: 1 ]

x Hide

[ Application: psql - Total duration: 1s - Times executed: 1 ]

x Hide

SELECT profile.take_sample ();

Date: 2026-07-14 12:00:02
Duration: 1s
Database: etendo
User: postgres
Remote: [local]
Application: psql

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-14 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-14 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-14 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: 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-14 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
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-14 15:30:00
Database: etendo
Application: openbravo
User: tad
Remote: 127.0.0.1

x Hide