Openbravo Issue Tracking System - Openbravo ERP
1) ERROR: operator does not exist: character varying = integer
2) ERROR: column "datedoc" is of type timestamp without time zone but expression is of type character varying
3) ERROR: null value in column "c_period_id" violates not-null constraint
2) Go to Financial management || Accounting || Transaction || G/L Journal || Batch.
3) Click New and fill the the mandatory fields. Mark template flag.
4) Select one period.
5) Move to Header tab, click New.
6) Save and move to the Lines tab.
7) Click New and select:
8) Click on the Account combination icon and select one.
9) Fill the Foreign Currency Debit. Save.
10) Click New and select:
11) Click on the Account combination icon and select one.
12) Fill the Foreign Currency Credit. Save.
13) Move back to Header tab and click on button "Complete".
14) Move back to Batch and click new. Fill the mandatory fields and save.
11:54:48 [http-8385-Processor23] ERROR org.openbravo.erpCommon.ad_process.CopyFromGLJournalData - SQL error in query: SELECT G.GL_JOURNALBATCH_ID, G.DOCUMENTNO, G.DESCRIPTION, G.ISACTIVE,(SELECT L.NAME FROM AD_REF_LIST L WHERE L.AD_REFERENCE_ID='125' AND L.VALUE=G.POSTINGTYPE) AS POSTINGTYPE, G.DATEDOC, G.DATEACCT, G.CONTROLAMT, G.TOTALDR, G.TOTALCR FROM GL_JOURNALBATCH G WHERE G.ISACTIVE='Y' AND ISTEMPLATE='Y' AND 1=1 AND G.AD_CLIENT_ID IN(1000000) AND G.AD_ORG_ID IN('0','1000000','1000002','1000003','1000004','1000005','1000006','1000007','1000008','1000009') AND EXISTS (SELECT 1 FROM GL_JOURNAL WHERE GL_JOURNALBATCH_ID = G.GL_JOURNALBATCH_ID) ORDER BY 2Exception:org.postgresql.util.PSQLException: ERROR: operator does not exist: character varying = integer
11:54:48 [http-8385-Processor23] ERROR org.openbravo.erpCommon.ad_process.CopyFromGLJournal - Error captured: javax.servlet.ServletException: @CODE=0@ERROR: operator does not exist: character varying = integer
Once it is resolved:
15) Press button Copy details button. Click search.
11:59:25 [http-8385-Processor24] ERROR org.openbravo.erpCommon.ad_process.CopyFromGLJournalData - SQL error in query: INSERT INTO GL_JOURNAL (GL_JOURNAL_ID, AD_CLIENT_ID, AD_ORG_ID, CREATED, CREATEDBY, UPDATED, UPDATEDBY, C_ACCTSCHEMA_ID,C_DOCTYPE_ID, DOCSTATUS,DOCACTION, ISAPPROVED, ISPRINTED, DESCRIPTION, POSTINGTYPE, GL_CATEGORY_ID, DATEDOC, DATEACCT,C_PERIOD_ID, C_CURRENCY_ID, CURRENCYRATETYPE,CURRENCYRATE, GL_JOURNALBATCH_ID, CONTROLAMT, DOCUMENTNO, PROCESSING, PROCESSED, POSTED) VALUES (?,?,?,now(),?,now(),?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)Exception:org.postgresql.util.PSQLException: ERROR: column "datedoc" is of type timestamp without time zone but expression is of type character varying
Once fixed this, a new bug arises:
12:16:14 [http-8385-Processor23] ERROR org.openbravo.erpCommon.ad_process.CopyFromGLJournalData - SQL error in query: INSERT INTO GL_JOURNAL (GL_JOURNAL_ID, AD_CLIENT_ID, AD_ORG_ID, CREATED, CREATEDBY, UPDATED, UPDATEDBY, C_ACCTSCHEMA_ID,C_DOCTYPE_ID, DOCSTATUS,DOCACTION, ISAPPROVED, ISPRINTED, DESCRIPTION, POSTINGTYPE, GL_CATEGORY_ID, DATEDOC, DATEACCT,C_PERIOD_ID, C_CURRENCY_ID, CURRENCYRATETYPE,CURRENCYRATE, GL_JOURNALBATCH_ID, CONTROLAMT, DOCUMENTNO, PROCESSING, PROCESSED, POSTED) VALUES (?,?,?,now(),?, now(),?,?,?,?,?,?,?, ?,?,?,TO_DATE(?),TO_DATE(?),?,?, ?,TO_NUMBER(?),?,TO_NUMBER(?),?,?,?,?)Exception:org.postgresql.util.PSQLException: ERROR: null value in column "c_period_id" violates not-null constraint
Review the patch and correct error 3.
patch-gljournal.diff (1,774) 2008-10-11 13:30https://issues.openbravo.com/file_download.php?file_id=319&type=bug