set.code.rev: code.rev: init: update.database: set.code.rev: code.rev: init: database.lib: init: [mkdir] Created dir: /opt/AppsOpenbravo/src-db/build/classes [mkdir] Created dir: /opt/AppsOpenbravo/src-db/build/lib [mkdir] Created dir: /opt/AppsOpenbravo/src-db/docs compile: [javac] Compiling 4 source files to /opt/AppsOpenbravo/src-db/build/classes build.jar: [jar] Building jar: /opt/AppsOpenbravo/src-db/build/lib/dbmanager.jar jar: [copy] Copying 1 file to /opt/AppsOpenbravo/src-db/database/lib set.code.rev: code.rev: init: core.lib: init: compile: build.jar: [jar] Building jar: /opt/AppsOpenbravo/src-core/lib/openbravo-core.jar build: copy.core.lib: [copy] Copying 1 file to /opt/AppsOpenbravo/lib/runtime update.database: Database connection: jdbc:postgresql://localhost:5432/openbravo. User: tad Executing default prescript Executed 113 SQL command(s) with 0 error(s) Reading tables... Reading views... Reading sequences... Reading triggers... Reading functions... Sorting foreign keys and checks... Starting function and trigger standardization. Original model loaded from database. Loading data from XML files Loading and applying configuration scripts Comparing databases to find differences Comparing table AD_Dataset_Column Comparing table AD_Dataset Comparing table AD_Dataset_Table Updating database model... Processing Trigger Trigger [name=C_BP_GROUP_TRG; ] (removed from database PostgreSql server) Processing Trigger Trigger [name=C_BPARTNER_TRG; ] (removed from database PostgreSql server) Processing Trigger Trigger [name=C_VALIDCOMBINATION_TRG; ] (removed from database PostgreSql server) Processing Trigger Trigger [name=M_PRODUCT_TRG; ] (removed from database PostgreSql server) Processing Trigger Trigger [name=AD_FORM_TRG2; ] (removed from database PostgreSql server) Processing Trigger Trigger [name=AD_FORM_TRG2; ] (created for the database PostgreSql server) Processing Trigger Trigger [name=C_BPARTNER_TRG; ] (created for the database PostgreSql server) Processing Trigger Trigger [name=C_BP_GROUP_TRG; ] (created for the database PostgreSql server) Processing Trigger Trigger [name=C_VALIDCOMBINATION_TRG; ] (created for the database PostgreSql server) Processing Trigger Trigger [name=M_PRODUCT_TRG; ] (created for the database PostgreSql server) Processing Column EXPORTALLOWED of table AD_DATASET (changed because of the onCreateDefault value) Processing Column HASCHARTOFACCOUNTS of table AD_MODULE (changed because of the onCreateDefault value) Processing Column ISTRANSLATIONMODULE of table AD_MODULE (changed because of the onCreateDefault value) Processing Column HASREFERENCEDATA of table AD_MODULE (changed because of the onCreateDefault value) Processing Column VERSION_LABEL (created for table AD_MODULE) Processing Column VERSION_ID (created for table AD_MODULE) Processing Foreign key Foreign key [name=ADSEQUENCEBP_ADORGACCTSCHEMA; onupdate=null; ondelete=null; foreign table=AD_SEQUENCE; 1 references] (created for table AD_ORG_ACCTSCHEMA) Processing Foreign key Foreign key [name=ADSEQUENCEPR_ADORGACCTSCHEMA; onupdate=null; ondelete=null; foreign table=AD_SEQUENCE; 1 references] (created for table AD_ORG_ACCTSCHEMA) Processing Check Constraint check [name=ADORGACCTSCH_ISACTIVE_CHECK; condition=ISACTIVE IN ('Y', 'N')] (created for the table AD_ORG_ACCTSCHEMA) Processing Check Constraint check [name=ADORGACCTSCH_ISBPNEWACCT_CHECK; condition=ISBPNEWACCOUNT IN ('Y', 'N')] (created for the table AD_ORG_ACCTSCHEMA) Processing Check Constraint check [name=ADORGACCTSCH_ISPRNEWACCT_CHECK; condition=ISPRNEWACCOUNT IN ('Y', 'N')] (created for the table AD_ORG_ACCTSCHEMA) Processing Column AD_SEQUENCE_BP_ID (created for table AD_ORG_ACCTSCHEMA) Processing Column AD_SEQUENCE_PR_ID (created for table AD_ORG_ACCTSCHEMA) Processing Column ISBPNEWACCOUNT (created for table AD_ORG_ACCTSCHEMA) Processing Column ISPRNEWACCOUNT (created for table AD_ORG_ACCTSCHEMA) Processing Column ACCT_LENGTH (created for table AD_ORG_ACCTSCHEMA) Processing Column SUBACCT_LENGTH (created for table AD_ORG_ACCTSCHEMA) Processing Column UIPATTERN (created for table AD_TAB) Processing Unique C_ELEMENTVALUE_VALUE (removed from table C_ELEMENTVALUE) Processing Unique C_EXTPOSCAT_PRODCATEGORY_UN (removed from table C_EXTERNALPOS_CATEGORY) Processing Unique C_EXTPOSCAT_PRODCATEGORY_UN (created for table C_EXTERNALPOS_CATEGORY) Processing Unique C_EXTPOSPROD_PRODUCT_UN (removed from table C_EXTERNALPOS_PRODUCT) Processing Unique C_EXTPOSPROD_PRODUCT_UN (created for table C_EXTERNALPOS_PRODUCT) Processing Foreign key Foreign key [name=CTAX_CGLITEM; onupdate=null; ondelete=null; foreign table=C_TAX; 1 references] (created for table C_GLITEM) Processing Foreign key Foreign key [name=CWITHHOLDING_CGLITEM; onupdate=null; ondelete=null; foreign table=C_WITHHOLDING; 1 references] (created for table C_GLITEM) Processing Check Constraint check [name=C_GLITEM_TAXANDWH_CHECK; condition=(C_TAX_ID IS NULL) OR (C_WITHHOLDING_ID IS NULL)] (created for the table C_GLITEM) Processing Column C_TAX_ID (created for table C_GLITEM) Processing Column C_WITHHOLDING_ID (created for table C_GLITEM) Processing Column LASTREGACCUMAMT of table C_TAXREGISTER (changed because of the scale) Processing Column TAXTOTALAMT of table C_TAXREGISTER (changed because of the scale) Processing Column TAXBASEAMT of table C_TAXREGISTERLINE (changed because of the scale) Processing Column TAXAMT of table C_TAXREGISTERLINE (changed because of the scale) Processing Column TOTALAMT of table C_TAXREGISTERLINE (changed because of the scale) Processing Column TAXUNDAMT of table C_TAXREGISTERLINE (changed because of the scale) Processing Column EXEMPTAMT of table C_TAXREGISTERLINE (changed because of the scale) Processing Column NOVATAMT of table C_TAXREGISTERLINE (changed because of the scale) Processing Foreign key Foreign key [name=CWITHHOLDING_FACTACCT; onupdate=null; ondelete=null; foreign table=C_WITHHOLDING; 1 references] (created for table FACT_ACCT) Processing Column C_WITHHOLDING_ID (created for table FACT_ACCT) Processing Foreign key Foreign key [name=CTAX_GLJOURNALLINE; onupdate=null; ondelete=null; foreign table=C_TAX; 1 references] (created for table GL_JOURNALLINE) Processing Foreign key Foreign key [name=CWITHHOLDING_GLJOURNALLINE; onupdate=null; ondelete=null; foreign table=C_WITHHOLDING; 1 references] (created for table GL_JOURNALLINE) Processing Check Constraint check [name=GLJOURNLINE_WHANDTAX_CHECK; condition=(C_TAX_ID IS NULL) OR (C_WITHHOLDING_ID IS NULL)] (created for the table GL_JOURNALLINE) Processing Column C_WITHHOLDING_ID (created for table GL_JOURNALLINE) Processing Column C_TAX_ID (created for table GL_JOURNALLINE) Processing View View [name=C_INVOICE_CANDIDATE_V; ] (created for the database PostgreSql server) Processing Function Function [notation=AD_SYNCHRONIZE(VARCHAR); ] (removed from database PostgreSql server) Processing Function Function [notation=C_CASH_POST(VARCHAR); ] (removed from database PostgreSql server) Processing Function Function [notation=C_CHK_OPEN_PERIOD(VARCHAR, TIMESTAMP, VARCHAR, VARCHAR); ] (removed from database PostgreSql server) Processing Function Function [notation=C_GENERATESOFROMPROJECTORDER(VARCHAR); ] (removed from database PostgreSql server) Processing Function Function [notation=C_INVOICE_CREATE(VARCHAR, VARCHAR, VARCHAR); ] (removed from database PostgreSql server) Processing Function Function [notation=C_INVOICE_POST(VARCHAR, VARCHAR); ] (removed from database PostgreSql server) Processing Function Function [notation=C_REMITTANCE_POST(VARCHAR, VARCHAR); ] (removed from database PostgreSql server) Processing Function Function [notation=C_TAXPAYMENT_POST(VARCHAR); ] (removed from database PostgreSql server) Processing Function Function [notation=M_INOUT_CREATEINVOICE(VARCHAR); ] (removed from database PostgreSql server) Processing Function Function [notation=M_PRODUCTION_RUN(VARCHAR); ] (removed from database PostgreSql server) Processing Function Function [notation=UUID_GENERATE_V4(); ] (removed from database PostgreSql server) Processing Function Function [notation=AD_SYNCHRONIZE(VARCHAR); ] (created for the database PostgreSql server) Processing Function Function [notation=C_CASH_POST(VARCHAR); ] (created for the database PostgreSql server) Processing Function Function [notation=C_CHK_OPEN_PERIOD(VARCHAR, TIMESTAMP, VARCHAR, VARCHAR); ] (created for the database PostgreSql server) Processing Function Function [notation=C_GENERATESOFROMPROJECTORDER(VARCHAR); ] (created for the database PostgreSql server) Processing Function Function [notation=C_INVOICE_CREATE(VARCHAR, VARCHAR, VARCHAR); ] (created for the database PostgreSql server) Processing Function Function [notation=C_INVOICE_POST(VARCHAR, VARCHAR); ] (created for the database PostgreSql server) Processing Function Function [notation=C_REMITTANCE_POST(VARCHAR, VARCHAR); ] (created for the database PostgreSql server) Processing Function Function [notation=C_TAXPAYMENT_POST(VARCHAR); ] (created for the database PostgreSql server) Processing Function Function [notation=C_VALIDCOMBINATION_CLONE(VARCHAR, VARCHAR, VARCHAR, NUMERIC, NUMERIC, VARCHAR); ] (created for the database PostgreSql server) Processing Function Function [notation=M_INOUT_CREATEINVOICE(VARCHAR); ] (created for the database PostgreSql server) Processing Function Function [notation=M_PRODUCTION_RUN(VARCHAR); ] (created for the database PostgreSql server) Executed 398 SQL command(s) with 0 error(s) Model update complete. Disabling foreign keys Executed 2185 SQL command(s) with 0 error(s) Disabling triggers Executed 418 SQL command(s) with 0 error(s) Dataset DS has changed. We need to update it. Dataset DS updated succesfully. Reinitializing DAL Comparing table AD_Dataset_Table Comparing table AD_Dataset_Column Comparing table AD_Model_Object_Para Comparing table AD_Exceptions Comparing table AD_Model_Object Comparing table AD_Model_Object_Mapping Comparing table AD_Package Comparing table AD_TreeNode Comparing table AD_Ref_Search Comparing table AD_FieldGroup Comparing table AD_Ref_Search_Column Comparing table AD_Module Comparing table AD_Ref_Table Comparing table AD_Tab Comparing table AD_Dataset Comparing table AD_Field Comparing table AD_Module_Dependency Comparing table AD_Table Comparing table AD_TextInterfaces Comparing table AD_Workflow Comparing table AD_Val_Rule Comparing table AD_WF_Node Comparing table AD_Process Comparing table AD_Element Comparing table AD_Menu Comparing table AD_Process_Para Comparing table AD_Message Comparing table AD_Reference Comparing table AD_AuxiliarInput Comparing table AD_Callout Comparing table AD_Module_Dbprefix Comparing table AD_Ref_List Comparing table AD_Column Comparing table AD_WF_NodeNext Comparing table AD_Form Comparing table AD_Window Data changes we will perform: Change in column [SEQNO] in table [AD_MODEL_OBJECT]: PK:36A67D2D76A5488491850AF14F83A6FF Old Value: New Value: <10> Change in column [SEQNO] in table [AD_MODEL_OBJECT]: PK:88420DFF1C6D48A18800FB91A91362AA Old Value: New Value: <20> Change in column [SEQNO] in table [AD_MODEL_OBJECT]: PK:CD9445A64E6B435AA70BFF526289C69B Old Value: New Value: <30> Change in column [SEQNO] in table [AD_MODEL_OBJECT]: PK:DF2601D0FF9041F49B069600B7603FE0 Old Value: New Value: <40> Change in column [SEQNO] in table [AD_TREENODE]: PK:52118BF1A2AA4D84E040007F01005FEC Old Value: <10> New Value: <20> Change in column [SEQNO] in table [AD_TREENODE]: PK:52118BF1A2AB4D84E040007F01005FEC Old Value: <20> New Value: <30> Change in column [VERSION] in table [AD_MODULE]: PK:0 Old Value: <2.50.14184> New Value: <2.50.14389> Change in column [COMMITWARNING] in table [AD_TAB]: PK:145 Old Value: New Value: Change in column [SEQNO] in table [AD_FIELD]: PK:312 Old Value: <140> New Value: <150> Change in column [SEQNO] in table [AD_FIELD]: PK:713 Old Value: <10> New Value: Change in column [SEQNO] in table [AD_FIELD]: PK:714 Old Value: <20> New Value: <10> Change in column [SEQNO] in table [AD_FIELD]: PK:715 Old Value: <70> New Value: <60> Change in column [SEQNO] in table [AD_FIELD]: PK:716 Old Value: <40> New Value: <30> Change in column [SEQNO] in table [AD_FIELD]: PK:724 Old Value: <50> New Value: <40> Change in column [SEQNO] in table [AD_FIELD]: PK:725 Old Value: <60> New Value: <50> Change in column [SEQNO] in table [AD_FIELD]: PK:727 Old Value: <90> New Value: <80> Change in column [SEQNO] in table [AD_FIELD]: PK:728 Old Value: <140> New Value: <130> Change in column [SEQNO] in table [AD_FIELD]: PK:729 Old Value: <150> New Value: <140> Change in column [SEQNO] in table [AD_FIELD]: PK:730 Old Value: <160> New Value: <150> Change in column [SEQNO] in table [AD_FIELD]: PK:731 Old Value: <170> New Value: <160> Change in column [SEQNO] in table [AD_FIELD]: PK:884 Old Value: <80> New Value: <70> Change in column [SEQNO] in table [AD_FIELD]: PK:895 Old Value: <120> New Value: <110> Change in column [SEQNO] in table [AD_FIELD]: PK:903 Old Value: <30> New Value: <20> Change in column [SEQNO] in table [AD_FIELD]: PK:925 Old Value: <110> New Value: <100> Change in column [SEQNO] in table [AD_FIELD]: PK:927 Old Value: <150> New Value: <160> Change in column [SEQNO] in table [AD_FIELD]: PK:928 Old Value: <160> New Value: <170> Change in column [ISACTIVE] in table [AD_FIELD]: PK:929 Old Value: New Value: Change in column [ISDISPLAYED] in table [AD_FIELD]: PK:929 Old Value: New Value: Change in column [SEQNO] in table [AD_FIELD]: PK:929 Old Value: <130> New Value: <140> Change in column [SEQNO] in table [AD_FIELD]: PK:1293 Old Value: <100> New Value: <90> Change in column [SEQNO] in table [AD_FIELD]: PK:1294 Old Value: <180> New Value: <170> Change in column [SEQNO] in table [AD_FIELD]: PK:1295 Old Value: <190> New Value: <180> Change in column [SEQNO] in table [AD_FIELD]: PK:1546 Old Value: <210> New Value: <220> Change in column [SEQNO] in table [AD_FIELD]: PK:1548 Old Value: <230> New Value: <240> Change in column [SEQNO] in table [AD_FIELD]: PK:1549 Old Value: <260> New Value: <270> Change in column [SEQNO] in table [AD_FIELD]: PK:1550 Old Value: <240> New Value: <250> Change in column [SEQNO] in table [AD_FIELD]: PK:2575 Old Value: <220> New Value: <230> Change in column [SEQNO] in table [AD_FIELD]: PK:3205 Old Value: <300> New Value: <310> Change in column [SEQNO] in table [AD_FIELD]: PK:4724 Old Value: <130> New Value: <120> Change in column [SEQNO] in table [AD_FIELD]: PK:4956 Old Value: <270> New Value: <280> Change in column [SEQNO] in table [AD_FIELD]: PK:5131 Old Value: <290> New Value: <300> Change in column [SEQNO] in table [AD_FIELD]: PK:5707 Old Value: <170> New Value: <180> Change in column [SEQNO] in table [AD_FIELD]: PK:5708 Old Value: <200> New Value: <210> Change in column [SEQNO] in table [AD_FIELD]: PK:5709 Old Value: <180> New Value: <190> Change in column [SEQNO] in table [AD_FIELD]: PK:6432 Old Value: <190> New Value: <200> Change in column [SEQNO] in table [AD_FIELD]: PK:800168 Old Value: <250> New Value: <260> Change in column [SEQNO] in table [AD_FIELD]: PK:800619 Old Value: <0> New Value: Change in column [SEQNO] in table [AD_FIELD]: PK:801108 Old Value: <280> New Value: <290> Change in column [SEQNO] in table [AD_FIELD]: PK:1001300001 Old Value: <60> New Value: <80> Change in column [ISFIRSTFOCUSEDFIELD] in table [AD_FIELD]: PK:1004400102 Old Value: New Value: Change in column [SEQNO] in table [AD_FIELD]: PK:565E666A61AF2693E040007F01002851 Old Value: <100> New Value: <120> Change in column [SEQNO] in table [AD_FIELD]: PK:565E666A61B02693E040007F01002851 Old Value: <110> New Value: <130> Change in column [SEQNO] in table [AD_FIELD]: PK:565E666A61B12693E040007F01002851 Old Value: <80> New Value: <100> Change in column [SEQNO] in table [AD_FIELD]: PK:565E666A61B42693E040007F01002851 Old Value: <190> New Value: <210> Change in column [SEQNO] in table [AD_FIELD]: PK:565E666A61B62693E040007F01002851 Old Value: <70> New Value: <90> Change in column [SEQNO] in table [AD_FIELD]: PK:565E666A61B72693E040007F01002851 Old Value: <210> New Value: <230> Change in column [DESCRIPTION] in table [AD_FIELD]: PK:565E666A61B92693E040007F01002851 Old Value: New Value: Change in column [HELP] in table [AD_FIELD]: PK:565E666A61B92693E040007F01002851 Old Value: New Value: Change in column [ISCENTRALLYMAINTAINED] in table [AD_FIELD]: PK:565E666A61B92693E040007F01002851 Old Value: New Value: Change in column [SEQNO] in table [AD_FIELD]: PK:565E666A61B92693E040007F01002851 Old Value: <50> New Value: <60> Change in column [ISSAMELINE] in table [AD_FIELD]: PK:565E666A61B92693E040007F01002851 Old Value: New Value: Change in column [SEQNO] in table [AD_FIELD]: PK:5663A9C58E5D9AF1E040007F01007B6F Old Value: <90> New Value: <110> Change in column [SEQNO] in table [AD_FIELD]: PK:56EB0A0CAC4FB232E040007F01001BD8 Old Value: <200> New Value: <220> Change in column [SEQNO] in table [AD_FIELD]: PK:56EB0A0CAC50B232E040007F01001BD8 Old Value: <180> New Value: <200> Change in column [SEQNO] in table [AD_FIELD]: PK:56EB0A0CAC51B232E040007F01001BD8 Old Value: <60> New Value: <50> Change in column [SEQNO] in table [AD_FIELD]: PK:56EE494063ADD85BE040007F0100423B Old Value: <220> New Value: <240> Change in column [SEQNO] in table [AD_FIELD]: PK:58E0AFDC8162B4CCE040007F01006F95 Old Value: <140> New Value: <160> Change in column [SEQNO] in table [AD_FIELD]: PK:58E0AFDC8164B4CCE040007F01006F95 Old Value: <120> New Value: <140> Change in column [SEQNO] in table [AD_FIELD]: PK:59CB79777A22C96CE040007F0100347D Old Value: <160> New Value: <180> Change in column [SEQNO] in table [AD_FIELD]: PK:59CB79777A23C96CE040007F0100347D Old Value: <150> New Value: <170> Change in column [SEQNO] in table [AD_FIELD]: PK:59CB79777A24C96CE040007F0100347D Old Value: <130> New Value: <150> Change in column [HELP] in table [AD_FIELD]: PK:59D388C6AF9CDD4EE040007F010043D6 Old Value: New Value: Change in column [SEQNO] in table [AD_FIELD]: PK:59D388C6AF9CDD4EE040007F010043D6 Old Value: <240> New Value: <260> Change in column [SEQNO] in table [AD_FIELD]: PK:5AC5BD9E47401294E040007F01001710 Old Value: <230> New Value: <250> Change in column [SEQNO] in table [AD_FIELD]: PK:5E3EE87E53095CB9E040007F01007C36 Old Value: <170> New Value: <190> Change in column [HELP] in table [AD_FIELD]: PK:6BDD5BBDFE623D4BE040007F01013540 Old Value: New Value: A Point in Time report is obtained as of a given date, taking into account the whole historical financial movements; an example of point in time report is the Balance Sheet.
A periodic report is executed for a date range and it does not carry forward the balance of accounting movements previous to the range; an example of periodic report is the Income Statement.> Change in column [HELP] in table [AD_FIELD]: PK:EED4952EC06A11DDB413001B388C61A4 Old Value: New Value: Change in column [PO_WINDOW_ID] in table [AD_TABLE]: PK:800018 Old Value: New Value: <183> Change in column [ISUSED] in table [AD_TEXTINTERFACES]: PK:805810 Old Value: New Value: Change in column [TEXT] in table [AD_TEXTINTERFACES]: PK:577D6154AC3C92F8E040007F010043D5 Old Value: New Value: Change in column [CODE] in table [AD_VAL_RULE]: PK:C9A72C5855CB4E29AFEB5DC17A5A9177 Old Value: New Value: Change in column [HELP] in table [AD_PROCESS]: PK:4062D3F4448547C3A2BCDFB09D062BA2 Old Value: New Value: Change in column [HELP] in table [AD_ELEMENT]: PK:6BDD5E11747C51DAE040007F01013550 Old Value: New Value: A Point in Time report is obtained as of a given date, taking into account the whole historical financial movements; an example of point in time report is the Balance Sheet.
A periodic report is executed for a date range and it does not carry forward the balance of accounting movements previous to the range; an example of periodic report is the Income Statement.> Change in column [HELP] in table [AD_ELEMENT]: PK:AC84AE28C06C11DD80E0001B388C61A4 Old Value: New Value: Change in column [MSGTEXT] in table [AD_MESSAGE]: PK:800223 Old Value: New Value: Change in column [ISACTIVE] in table [AD_COLUMN]: PK:2044 Old Value: New Value: Change in column [ISMANDATORY] in table [AD_COLUMN]: PK:2044 Old Value: New Value: Change in column [DEVELOPMENTSTATUS] in table [AD_COLUMN]: PK:2044 Old Value: New Value: Change in column [DEFAULTVALUE] in table [AD_COLUMN]: PK:802453 Old Value: <@SQL=SELECT (CASE WHEN @IsReport@='Y' OR @IsJasper@='Y' THEN 'R' WHEN @AD_MODULE_ID@ IS NOT NULL THEN 'M' ELSE 'P' END) FROM DUAL> New Value: <@SQL=SELECT (CASE WHEN @IsReport@='Y' OR @IsJasper@='Y' THEN 'R' ELSE 'P' END) FROM DUAL> Change in column [DEFAULTVALUE] in table [AD_COLUMN]: PK:803553 Old Value: New Value: <1> Change in column [VALUEMIN] in table [AD_COLUMN]: PK:803553 Old Value: <0> New Value: <1> Change in column [DEFAULTVALUE] in table [AD_COLUMN]: PK:1000500068 Old Value: New Value: Change in column [AD_CALLOUT_ID] in table [AD_COLUMN]: PK:1000500068 Old Value: New Value: <1000100000> Change in column [DEVELOPMENTSTATUS] in table [AD_COLUMN]: PK:1005400231 Old Value: New Value: Change in column [AD_VAL_RULE_ID] in table [AD_COLUMN]: PK:58D503FCDD9FD53FE040007F01016BBB Old Value: New Value: Change in column [HELP] in table [AD_COLUMN]: PK:6BDD5BBDFE613D4BE040007F01013540 Old Value: New Value: A Point in Time report is obtained as of a given date, taking into account the whole historical financial movements; an example of point in time report is the Balance Sheet.
A periodic report is executed for a date range and it does not carry forward the balance of accounting movements previous to the range; an example of periodic report is the Income Statement.> Change in column [HELP] in table [AD_COLUMN]: PK:E98BE9B0C06911DD88FA001B388C61A4 Old Value: New Value: Change in column [HELP] in table [AD_WINDOW]: PK:1005400002 Old Value: New Value: New row in table [AD_MODEL_OBJECT_PARA]: New row in table [AD_MODEL_OBJECT_PARA]: New row in table [AD_MODEL_OBJECT_PARA]: New row in table [AD_MODEL_OBJECT_PARA]: New row in table [AD_MODEL_OBJECT_PARA]: New row in table [AD_MODEL_OBJECT_PARA]: New row in table [AD_MODEL_OBJECT_PARA]: New row in table [AD_MODEL_OBJECT_PARA]: New row in table [AD_MODEL_OBJECT_PARA]: New row in table [AD_MODEL_OBJECT_PARA]: New row in table [AD_MODEL_OBJECT_PARA]: New row in table [AD_MODEL_OBJECT_PARA]: New row in table [AD_MODEL_OBJECT_PARA]: New row in table [AD_MODEL_OBJECT_PARA]: New row in table [AD_MODEL_OBJECT_PARA]: New row in table [AD_MODEL_OBJECT_PARA]: New row in table [AD_MODEL_OBJECT_PARA]: New row in table [AD_MODEL_OBJECT_PARA]: New row in table [AD_MODEL_OBJECT_PARA]: New row in table [AD_MODEL_OBJECT_PARA]: New row in table [AD_MODEL_OBJECT_PARA]: New row in table [AD_MODEL_OBJECT_PARA]: New row in table [AD_MODEL_OBJECT]: New row in table [AD_MODEL_OBJECT]: New row in table [AD_MODEL_OBJECT]: New row in table [AD_MODEL_OBJECT_MAPPING]: New row in table [AD_MODEL_OBJECT_MAPPING]: New row in table [AD_TREENODE]: New row in table [AD_FIELD]: New row in table [AD_FIELD]: New row in table [AD_FIELD]: New row in table [AD_FIELD]: New row in table [AD_FIELD]: New row in table [AD_FIELD]: New row in table [AD_FIELD]: New row in table [AD_FIELD]: New row in table [AD_FIELD]: New row in table [AD_FIELD]: New row in table [AD_FIELD]: New row in table [AD_FIELD]: New row in table [AD_FIELD]: New row in table [AD_FIELD]: New row in table [AD_TEXTINTERFACES]: New row in table [AD_TEXTINTERFACES]: New row in table [AD_TEXTINTERFACES]: New row in table [AD_TEXTINTERFACES]: New row in table [AD_TEXTINTERFACES]: New row in table [AD_TEXTINTERFACES]: New row in table [AD_TEXTINTERFACES]: New row in table [AD_TEXTINTERFACES]: New row in table [AD_TEXTINTERFACES]: New row in table [AD_TEXTINTERFACES]: New row in table [AD_TEXTINTERFACES]: New row in table [AD_TEXTINTERFACES]: New row in table [AD_TEXTINTERFACES]: New row in table [AD_TEXTINTERFACES]: New row in table [AD_TEXTINTERFACES]: New row in table [AD_TEXTINTERFACES]: New row in table [AD_TEXTINTERFACES]: New row in table [AD_TEXTINTERFACES]: New row in table [AD_TEXTINTERFACES]: New row in table [AD_TEXTINTERFACES]: New row in table [AD_TEXTINTERFACES]: New row in table [AD_TEXTINTERFACES]: New row in table [AD_TEXTINTERFACES]: New row in table [AD_TEXTINTERFACES]: New row in table [AD_TEXTINTERFACES]: New row in table [AD_TEXTINTERFACES]: New row in table [AD_TEXTINTERFACES]: New row in table [AD_TEXTINTERFACES]: New row in table [AD_TEXTINTERFACES]: New row in table [AD_TEXTINTERFACES]: New row in table [AD_TEXTINTERFACES]: New row in table [AD_PROCESS]: New row in table [AD_ELEMENT]: New row in table [AD_ELEMENT]: New row in table [AD_ELEMENT]: New row in table [AD_ELEMENT]: New row in table [AD_ELEMENT]: New row in table [AD_ELEMENT]: New row in table [AD_ELEMENT]: New row in table [AD_ELEMENT]: New row in table [AD_MENU]: New row in table [AD_MESSAGE]: New row in table [AD_MESSAGE]: New row in table [AD_MESSAGE]: New row in table [AD_MESSAGE]: New row in table [AD_MESSAGE]: New row in table [AD_MESSAGE]: New row in table [AD_REFERENCE]: New row in table [AD_AUXILIARINPUT]: New row in table [AD_REF_LIST]: New row in table [AD_REF_LIST]: New row in table [AD_REF_LIST]: New row in table [AD_REF_LIST]: New row in table [AD_REF_LIST]: New row in table [AD_COLUMN]: New row in table [AD_COLUMN]: New row in table [AD_COLUMN]: New row in table [AD_COLUMN]: New row in table [AD_COLUMN]: New row in table [AD_COLUMN]: New row in table [AD_COLUMN]: New row in table [AD_COLUMN]: New row in table [AD_COLUMN]: New row in table [AD_COLUMN]: New row in table [AD_COLUMN]: New row in table [AD_COLUMN]: New row in table [AD_COLUMN]: New row in table [AD_COLUMN]: Updating database data... Removing invalid rows. Executed 157 SQL command(s) with 0 error(s) Executing update final script (NOT NULLs and dropping temporal tables Processing Trigger Trigger [name=C_BP_GROUP_TRG; ] (removed from database PostgreSql server) Processing Trigger Trigger [name=C_BPARTNER_TRG; ] (removed from database PostgreSql server) Processing Trigger Trigger [name=C_VALIDCOMBINATION_TRG; ] (removed from database PostgreSql server) Processing Trigger Trigger [name=M_PRODUCT_TRG; ] (removed from database PostgreSql server) Processing Trigger Trigger [name=AD_FORM_TRG2; ] (removed from database PostgreSql server) Processing Trigger Trigger [name=AD_FORM_TRG2; ] (created for the database PostgreSql server) Processing Trigger Trigger [name=C_BPARTNER_TRG; ] (created for the database PostgreSql server) Processing Trigger Trigger [name=C_BP_GROUP_TRG; ] (created for the database PostgreSql server) Processing Trigger Trigger [name=C_VALIDCOMBINATION_TRG; ] (created for the database PostgreSql server) Processing Trigger Trigger [name=M_PRODUCT_TRG; ] (created for the database PostgreSql server) Processing Column EXPORTALLOWED of table AD_DATASET (changed because of the onCreateDefault value) Processing Column HASCHARTOFACCOUNTS of table AD_MODULE (changed because of the onCreateDefault value) Processing Column ISTRANSLATIONMODULE of table AD_MODULE (changed because of the onCreateDefault value) Processing Column HASREFERENCEDATA of table AD_MODULE (changed because of the onCreateDefault value) Processing Column VERSION_LABEL (created for table AD_MODULE) Processing Column VERSION_ID (created for table AD_MODULE) Processing Foreign key Foreign key [name=ADSEQUENCEBP_ADORGACCTSCHEMA; onupdate=null; ondelete=null; foreign table=AD_SEQUENCE; 1 references] (created for table AD_ORG_ACCTSCHEMA) Processing Foreign key Foreign key [name=ADSEQUENCEPR_ADORGACCTSCHEMA; onupdate=null; ondelete=null; foreign table=AD_SEQUENCE; 1 references] (created for table AD_ORG_ACCTSCHEMA) Processing Check Constraint check [name=ADORGACCTSCH_ISACTIVE_CHECK; condition=ISACTIVE IN ('Y', 'N')] (created for the table AD_ORG_ACCTSCHEMA) Processing Check Constraint check [name=ADORGACCTSCH_ISBPNEWACCT_CHECK; condition=ISBPNEWACCOUNT IN ('Y', 'N')] (created for the table AD_ORG_ACCTSCHEMA) Processing Check Constraint check [name=ADORGACCTSCH_ISPRNEWACCT_CHECK; condition=ISPRNEWACCOUNT IN ('Y', 'N')] (created for the table AD_ORG_ACCTSCHEMA) Processing Column AD_SEQUENCE_BP_ID (created for table AD_ORG_ACCTSCHEMA) Processing Column AD_SEQUENCE_PR_ID (created for table AD_ORG_ACCTSCHEMA) Processing Column ISBPNEWACCOUNT (created for table AD_ORG_ACCTSCHEMA) Processing Column ISPRNEWACCOUNT (created for table AD_ORG_ACCTSCHEMA) Processing Column ACCT_LENGTH (created for table AD_ORG_ACCTSCHEMA) Processing Column SUBACCT_LENGTH (created for table AD_ORG_ACCTSCHEMA) Processing Column UIPATTERN (created for table AD_TAB) Processing Unique C_ELEMENTVALUE_VALUE (removed from table C_ELEMENTVALUE) Processing Unique C_EXTPOSCAT_PRODCATEGORY_UN (removed from table C_EXTERNALPOS_CATEGORY) Processing Unique C_EXTPOSCAT_PRODCATEGORY_UN (created for table C_EXTERNALPOS_CATEGORY) Processing Unique C_EXTPOSPROD_PRODUCT_UN (removed from table C_EXTERNALPOS_PRODUCT) Processing Unique C_EXTPOSPROD_PRODUCT_UN (created for table C_EXTERNALPOS_PRODUCT) Processing Foreign key Foreign key [name=CTAX_CGLITEM; onupdate=null; ondelete=null; foreign table=C_TAX; 1 references] (created for table C_GLITEM) Processing Foreign key Foreign key [name=CWITHHOLDING_CGLITEM; onupdate=null; ondelete=null; foreign table=C_WITHHOLDING; 1 references] (created for table C_GLITEM) Processing Check Constraint check [name=C_GLITEM_TAXANDWH_CHECK; condition=(C_TAX_ID IS NULL) OR (C_WITHHOLDING_ID IS NULL)] (created for the table C_GLITEM) Processing Column C_TAX_ID (created for table C_GLITEM) Processing Column C_WITHHOLDING_ID (created for table C_GLITEM) Processing Column LASTREGACCUMAMT of table C_TAXREGISTER (changed because of the scale) Processing Column TAXTOTALAMT of table C_TAXREGISTER (changed because of the scale) Processing Column TAXBASEAMT of table C_TAXREGISTERLINE (changed because of the scale) Processing Column TAXAMT of table C_TAXREGISTERLINE (changed because of the scale) Processing Column TOTALAMT of table C_TAXREGISTERLINE (changed because of the scale) Processing Column TAXUNDAMT of table C_TAXREGISTERLINE (changed because of the scale) Processing Column EXEMPTAMT of table C_TAXREGISTERLINE (changed because of the scale) Processing Column NOVATAMT of table C_TAXREGISTERLINE (changed because of the scale) Processing Foreign key Foreign key [name=CWITHHOLDING_FACTACCT; onupdate=null; ondelete=null; foreign table=C_WITHHOLDING; 1 references] (created for table FACT_ACCT) Processing Column C_WITHHOLDING_ID (created for table FACT_ACCT) Processing Foreign key Foreign key [name=CTAX_GLJOURNALLINE; onupdate=null; ondelete=null; foreign table=C_TAX; 1 references] (created for table GL_JOURNALLINE) Processing Foreign key Foreign key [name=CWITHHOLDING_GLJOURNALLINE; onupdate=null; ondelete=null; foreign table=C_WITHHOLDING; 1 references] (created for table GL_JOURNALLINE) Processing Check Constraint check [name=GLJOURNLINE_WHANDTAX_CHECK; condition=(C_TAX_ID IS NULL) OR (C_WITHHOLDING_ID IS NULL)] (created for the table GL_JOURNALLINE) Processing Column C_WITHHOLDING_ID (created for table GL_JOURNALLINE) Processing Column C_TAX_ID (created for table GL_JOURNALLINE) Processing View View [name=C_INVOICE_CANDIDATE_V; ] (created for the database PostgreSql server) Processing Function Function [notation=AD_SYNCHRONIZE(VARCHAR); ] (removed from database PostgreSql server) Processing Function Function [notation=C_CASH_POST(VARCHAR); ] (removed from database PostgreSql server) Processing Function Function [notation=C_CHK_OPEN_PERIOD(VARCHAR, TIMESTAMP, VARCHAR, VARCHAR); ] (removed from database PostgreSql server) Processing Function Function [notation=C_GENERATESOFROMPROJECTORDER(VARCHAR); ] (removed from database PostgreSql server) Processing Function Function [notation=C_INVOICE_CREATE(VARCHAR, VARCHAR, VARCHAR); ] (removed from database PostgreSql server) Processing Function Function [notation=C_INVOICE_POST(VARCHAR, VARCHAR); ] (removed from database PostgreSql server) Processing Function Function [notation=C_REMITTANCE_POST(VARCHAR, VARCHAR); ] (removed from database PostgreSql server) Processing Function Function [notation=C_TAXPAYMENT_POST(VARCHAR); ] (removed from database PostgreSql server) Processing Function Function [notation=M_INOUT_CREATEINVOICE(VARCHAR); ] (removed from database PostgreSql server) Processing Function Function [notation=M_PRODUCTION_RUN(VARCHAR); ] (removed from database PostgreSql server) Processing Function Function [notation=UUID_GENERATE_V4(); ] (removed from database PostgreSql server) Processing Function Function [notation=AD_SYNCHRONIZE(VARCHAR); ] (created for the database PostgreSql server) Processing Function Function [notation=C_CASH_POST(VARCHAR); ] (created for the database PostgreSql server) Processing Function Function [notation=C_CHK_OPEN_PERIOD(VARCHAR, TIMESTAMP, VARCHAR, VARCHAR); ] (created for the database PostgreSql server) Processing Function Function [notation=C_GENERATESOFROMPROJECTORDER(VARCHAR); ] (created for the database PostgreSql server) Processing Function Function [notation=C_INVOICE_CREATE(VARCHAR, VARCHAR, VARCHAR); ] (created for the database PostgreSql server) Processing Function Function [notation=C_INVOICE_POST(VARCHAR, VARCHAR); ] (created for the database PostgreSql server) Processing Function Function [notation=C_REMITTANCE_POST(VARCHAR, VARCHAR); ] (created for the database PostgreSql server) Processing Function Function [notation=C_TAXPAYMENT_POST(VARCHAR); ] (created for the database PostgreSql server) Processing Function Function [notation=C_VALIDCOMBINATION_CLONE(VARCHAR, VARCHAR, VARCHAR, NUMERIC, NUMERIC, VARCHAR); ] (created for the database PostgreSql server) Processing Function Function [notation=M_INOUT_CREATEINVOICE(VARCHAR); ] (created for the database PostgreSql server) Processing Function Function [notation=M_PRODUCTION_RUN(VARCHAR); ] (created for the database PostgreSql server) Executed 326 SQL command(s) with 0 error(s) Enabling Foreign Keys and Triggers Executed 2185 SQL command(s) with 0 error(s) Executed 418 SQL command(s) with 0 error(s) Executing default postscript Executed 10 SQL command(s) with 0 error(s) database.postupdate.POSTGRE: [sql] Executing commands [sql] Failed to execute: SELECT AD_UPDATE_ACCESS() The following error occurred while executing this line: /opt/AppsOpenbravo/src-db/database/build.xml:126: The following error occurred while executing this line: /opt/AppsOpenbravo/src-db/database/build.xml:383: org.postgresql.util.PSQLException: ERROR: function uuid_generate_v4() does not exist /opt/AppsOpenbravo/build.xml:542: The following error occurred while executing this line: /opt/AppsOpenbravo/src-db/database/build.xml:126: The following error occurred while executing this line: /opt/AppsOpenbravo/src-db/database/build.xml:383: org.postgresql.util.PSQLException: ERROR: function uuid_generate_v4() does not exist /opt/AppsOpenbravo/build.xml:542: The following error occurred while executing this line: /opt/AppsOpenbravo/src-db/database/build.xml:126: The following error occurred while executing this line: /opt/AppsOpenbravo/src-db/database/build.xml:383: org.postgresql.util.PSQLException: ERROR: function uuid_generate_v4() does not exist at org.apache.tools.ant.ProjectHelper.addLocationToBuildException(ProjectHelper.java:508) at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:418) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288) at sun.reflect.GeneratedMethodAccessor160.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106) at org.apache.tools.ant.Task.perform(Task.java:348) at org.apache.tools.ant.Target.execute(Target.java:357) at org.apache.tools.ant.Target.performTasks(Target.java:385) at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1337) at org.apache.tools.ant.Project.executeTarget(Project.java:1306) at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41) at org.apache.tools.ant.Project.executeTargets(Project.java:1189) at org.openbravo.erpCommon.utility.AntExecutor.runTask(AntExecutor.java:222) at org.openbravo.erpCommon.ad_process.ApplyModules.startApply(ApplyModules.java:230) at org.openbravo.erpCommon.ad_process.ApplyModules.doPost(ApplyModules.java:63) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at org.openbravo.base.HttpBaseServlet.serviceInitialized(HttpBaseServlet.java:224) at org.openbravo.base.secureApp.HttpSecureAppServlet.service(HttpSecureAppServlet.java:324) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.openbravo.utils.SessionExpirationFilter.doFilter(SessionExpirationFilter.java:66) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.openbravo.utils.CharsetFilter.doFilter(CharsetFilter.java:35) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.openbravo.dal.core.DalRequestFilter$1.doAction(DalRequestFilter.java:79) at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:46) at org.openbravo.dal.core.DalRequestFilter.doFilter(DalRequestFilter.java:85) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.java:427) at org.apache.coyote.ajp.AjpAprProtocol$AjpConnectionHandler.process(AjpAprProtocol.java:384) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1527) at java.lang.Thread.run(Thread.java:619) Caused by: /opt/AppsOpenbravo/src-db/database/build.xml:126: The following error occurred while executing this line: /opt/AppsOpenbravo/src-db/database/build.xml:383: org.postgresql.util.PSQLException: ERROR: function uuid_generate_v4() does not exist at org.apache.tools.ant.ProjectHelper.addLocationToBuildException(ProjectHelper.java:508) at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:418) at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:105) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288) at sun.reflect.GeneratedMethodAccessor160.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106) at org.apache.tools.ant.Task.perform(Task.java:348) at org.apache.tools.ant.Target.execute(Target.java:357) at org.apache.tools.ant.Target.performTasks(Target.java:385) at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1337) at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38) at org.apache.tools.ant.Project.executeTargets(Project.java:1189) at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:416) ... 42 more Caused by: /opt/AppsOpenbravo/src-db/database/build.xml:383: org.postgresql.util.PSQLException: ERROR: function uuid_generate_v4() does not exist at org.apache.tools.ant.taskdefs.SQLExec.execute(SQLExec.java:463) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288) at sun.reflect.GeneratedMethodAccessor160.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106) at org.apache.tools.ant.Task.perform(Task.java:348) at org.apache.tools.ant.Target.execute(Target.java:357) at org.apache.tools.ant.Target.performTasks(Target.java:385) at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1337) at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38) at org.apache.tools.ant.Project.executeTargets(Project.java:1189) at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:416) ... 55 more Caused by: org.postgresql.util.PSQLException: ERROR: function uuid_generate_v4() does not exist 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:337) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:329) at org.apache.tools.ant.taskdefs.SQLExec.execSQL(SQLExec.java:565) at org.apache.tools.ant.taskdefs.SQLExec.runStatements(SQLExec.java:535) at org.apache.tools.ant.taskdefs.SQLExec$Transaction.runTransaction(SQLExec.java:764) at org.apache.tools.ant.taskdefs.SQLExec$Transaction.access$000(SQLExec.java:706) at org.apache.tools.ant.taskdefs.SQLExec.execute(SQLExec.java:449) ... 67 more --- Nested Exception --- /opt/AppsOpenbravo/src-db/database/build.xml:126: The following error occurred while executing this line: /opt/AppsOpenbravo/src-db/database/build.xml:383: org.postgresql.util.PSQLException: ERROR: function uuid_generate_v4() does not exist at org.apache.tools.ant.ProjectHelper.addLocationToBuildException(ProjectHelper.java:508) at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:418) at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:105) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288) at sun.reflect.GeneratedMethodAccessor160.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106) at org.apache.tools.ant.Task.perform(Task.java:348) at org.apache.tools.ant.Target.execute(Target.ja va:357) at org.apache.tools.ant.Target.performTasks(Target.java:385) at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1337) at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38) at org.apache.tools.ant.Project.executeTargets(Project.java:1189) at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:416) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288) at sun.reflect.GeneratedMethodAccessor160.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106) at org.apache.tools.ant.Task.perform(Task.java:348) at org.apache.tools.ant.Target.execute(Target.java:357) at org.apache.tools.ant.Target.performTasks(Target.java:385) at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1337) at org.apache.tools.ant.Project.executeTarget(Project.java:1306) at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41) at org.apache.tools.ant.Project.executeTargets(Project.java:1189) at org.openbravo.erpCommon.utility.AntExecutor.runTask(AntExecutor.java:222) at org.openbravo.erpCommon.ad_process.ApplyModules.startApply(ApplyModules.java:230) at org.openbravo.erpCommon.ad_process.ApplyModules.doPost(ApplyModules.java:63) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at org.openbravo.base.HttpBaseServlet.serviceInitialized(HttpBaseServlet.java:224) at org.openbravo.base.secureApp.HttpSecureAppServlet.service(HttpSecureAppServlet.java:324) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.openbravo.utils.SessionExpirationFilter.doFilter(SessionExpirationFilter.java:66) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.openbravo.utils.CharsetFilter.doFilter(CharsetFilter.java:35) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.openbravo.dal.core.DalRequestFilter$1.doAction(DalRequestFilter.java:79) at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:46) at org.openbravo.dal.core.DalRequestFilter.doFilter(DalRequestFilter.java:85) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.java:427) at org.apache.coyote.ajp.AjpAprProtocol$AjpConnectionHandler.process(AjpAprProtocol.java:384) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1527) at java.lang.Thread.run(Thread.java:619) Caused by: /opt/AppsOpenbravo/src-db/database/build.xml:383: org.postgresql.util.PSQLException: ERROR: function uuid_generate_v4() does not exist at org.apache.tools.ant.taskdefs.SQLExec.execute(SQLExec.java:463) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288) at sun.reflect.GeneratedMethodAccessor160.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106) at org.apache.tools.ant.Task.perform(Task.java:348) at org.apache.tools.ant.Target.execute(Target.java:357) at org.apache.tools.ant.Target.performTasks(Target.java:385) at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1337) at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38) at org.apache.tools.ant.Project.executeTargets(Project.java:1189) at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:416) ... 55 more Caused by: org.postgresql.util.PSQLException: ERROR: function uuid_generate_v4() does not exist 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:337) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:329) at org.apache.tools.ant.taskdefs.SQLExec.execSQL(SQLExec.java:565) at org.apache.tools.ant.taskdefs.SQLExec.runStatements(SQLExec.java:535) at org.apache.tools.ant.taskdefs.SQLExec$Transaction.runTransaction(SQLExec.java:764) at org.apache.tools.ant.taskdefs.SQLExec$Transaction.access$000(SQLExec.java:706) at org.apache.tools.ant.taskdefs.SQLExec.execute(SQLExec.java:449) ... 67 more --- Nested Exception --- /opt/AppsOpenbravo/src-db/database/build.xml:383: org.postgresql.util.PSQLException: ERROR: function uuid_generate_v4() does not exist at org.apache.tools.ant.taskdefs.SQLExec.execute(SQLExec.java:463) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288) at sun.reflect.GeneratedMethodAccessor160.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106) at org.apache.tools.ant.Task.perform(Task.java:348) at org.apache.tools.ant.Target.execute(Target.java:357) at org.apache.tools.ant.Target.performTasks(Target.java:385) at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1337) at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38) at org.apache.tools.ant.Project.executeTargets(Project.java:1189) at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:416) at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:105) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288) at sun.reflect.GeneratedMethodAccessor160.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106) at org.apache.tools.ant.Task.perform(Task.java:348) at org.apache.tools.ant.Target.execute(Target.java:357) at org.apache.tools.ant.Target.performTasks(Target.java:385) at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1337) at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38) at org.apache.tools.ant.Project.executeTargets(Project.java:1189) at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:416) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288) at sun.reflect.GeneratedMethodAccessor160.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106) at org.apache.tools.ant.Task.perform(Task.java:348) at org.apache .tools.ant.Target.execute(Target.java:357) at org.apache.tools.ant.Target.performTasks(Target.java:385) at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1337) at org.apache.tools.ant.Project.executeTarget(Project.java:1306) at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41) at org.apache.tools.ant.Project.executeTargets(Project.java:1189) at org.openbravo.erpCommon.utility.AntExecutor.runTask(AntExecutor.java:222) at org.openbravo.erpCommon.ad_process.ApplyModules.startApply(ApplyModules.java:230) at org.openbravo.erpCommon.ad_process.ApplyModules.doPost(ApplyModules.java:63) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at org.openbravo.base.HttpBaseServlet.serviceInitialized(HttpBaseServlet.java:224) at org.openbravo.base.secureApp.HttpSecureAppServlet.service(HttpSecureAppServlet.java:324) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.openbravo.utils.SessionExpirationFilter.doFilter(SessionExpirationFilter.java:66) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.openbravo.utils.CharsetFilter.doFilter(CharsetFilter.java:35) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.openbravo.dal.core.DalRequestFilter$1.doAction(DalRequestFilter.java:79) at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:46) at org.openbravo.dal.core.DalRequestFilter.doFilter(DalRequestFilter.java:85) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.java:427) at org.apache.coyote.ajp.AjpAprProtocol$AjpConnectionHandler.process(AjpAprProtocol.java:384) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1527) at java.lang.Thread.run(Thread.java:619) Caused by: org.postgresql.util.PSQLException: ERROR: function uuid_generate_v4() does not exist 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:337) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:329) at org.apache.tools.ant.taskdefs.SQLExec.execSQL(SQLExec.java:565) at org.apache.tools.ant.taskdefs.SQLExec.runStatements(SQLExec.java:535) at org.apache.tools.ant.taskdefs.SQLExec$Transaction.runTransaction(SQLExec.java:764) at org.apache.tools.ant.taskdefs.SQLExec$Transaction.access$000(SQLExec.java:706) at org.apache.tools.ant.taskdefs.SQLExec.execute(SQLExec.java:449) ... 67 more --- Nested Exception --- org.postgresql.util.PSQLException: ERROR: function uuid_generate_v4() does not exist 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:337) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:329) at org.apache.tools.ant.taskdefs.SQLExec.execSQL(SQLExec.java:565) at org.apache.tools.ant.taskdefs.SQLExec.runStatements(SQLExec.java:535) at org.apache.tools.ant.taskdefs.SQLExec$Transaction.runTransaction(SQLExec.java:764) at org.apache.tools.ant.taskdefs.SQLExec$Transaction.access$000(SQLExec.java:706) at org.apache.tools.ant.taskdefs.SQLExec.execute(SQLExec.java:449) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288) at sun.reflect.GeneratedMethodAccessor160.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106) at org.apache.tools.ant.Task.perform(Task.java:348) at org.apache.tools.ant.Target.execute(Target.java:357) at org.apache.tools.ant.Target.performTasks(Target.java:385) at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1337) at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38) at org.apache.tools.ant.Project.executeTargets(Project.java:1189) at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:416) at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:105) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288) at sun.reflect.GeneratedMethodAccessor160.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106) at org.apache.tools.ant.Task.perform(Task.java:348) at org.apache.tools.ant.Target.execute(Target.java:357) at org.apache.tools.ant.Target.performTasks(Target.java:385) at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1337) at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38) at org.apache.tools.ant.Project.executeTargets(Project.java:1189) at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:416) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288) at sun.reflect.GeneratedMethodAccessor160.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106) at org.apache.tools.ant.Task.perform(Task.java:348) at org.apache.tools.ant.Target.execute(Target.java:357) at org.apache.tools.ant.Target.performTasks(Target.java:385) at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1337) at org.apache.tools.ant.Project.executeTarget(Project.java:1306) at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41) at org.apache.tools.ant.Project.executeTargets(Project.java:1189) at org.openbravo.erpCommon.utility.AntExecutor.runTask(AntExecutor.java:222) at org.openbravo.erpCommon.ad_process.ApplyModules.startApply(ApplyModules.java:230) at org.openbravo.erpCommon.ad_process.ApplyModules.doPost(ApplyModules.java:63) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at org.openbravo.base.HttpBaseServlet.serviceInitialized(HttpBaseServlet.java:224) at org.openbravo.base.secureApp.HttpSecureAppServlet.service(HttpSecureAppServlet.java:324) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:2 90) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.openbravo.utils.SessionExpirationFilter.doFilter(SessionExpirationFilter.java:66) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.openbravo.utils.CharsetFilter.doFilter(CharsetFilter.java:35) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.openbravo.dal.core.DalRequestFilter$1.doAction(DalRequestFilter.java:79) at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:46) at org.openbravo.dal.core.DalRequestFilter.doFilter(DalRequestFilter.java:85) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.java:427) at org.apache.coyote.ajp.AjpAprProtocol$AjpConnectionHandler.process(AjpAprProtocol.java:384) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1527) at java.lang.Thread.run(Thread.java:619) finished