Buildfile: build.xml init: code.rev: update.database: init: database.lib: clean: [delete] Deleting directory /home/openbravo/work/ob_branches/r2.40/src-db/build/classes [delete] Deleting directory /home/openbravo/work/ob_branches/r2.40/src-db/build/lib [delete] Deleting directory /home/openbravo/work/ob_branches/r2.40/src-db/docs init: [mkdir] Created dir: /home/openbravo/work/ob_branches/r2.40/src-db/build/classes [mkdir] Created dir: /home/openbravo/work/ob_branches/r2.40/src-db/build/lib [mkdir] Created dir: /home/openbravo/work/ob_branches/r2.40/src-db/docs compile: [javac] Compiling 4 source files to /home/openbravo/work/ob_branches/r2.40/src-db/build/classes build.jar: [jar] Building jar: /home/openbravo/work/ob_branches/r2.40/src-db/build/lib/dbmanager.jar jar: [copy] Copying 1 file to /home/openbravo/work/ob_branches/r2.40/src-db/database/lib update.database: [alterdatabasedata] Executing default prescript [alterdatabasedata] SQL Command failed with: ORA-00955: name is already used by an existing object [alterdatabasedata] [alterdatabasedata] -- create temporary tables [alterdatabasedata] CREATE GLOBAL TEMPORARY TABLE C_TEMP_SELECTION [alterdatabasedata] ( [alterdatabasedata] C_TEMP_SELECTION_ID NUMBER(10) NOT NULL, [alterdatabasedata] CONSTRAINT C_TEMP_SELECTION_key PRIMARY KEY (C_TEMP_SELECTION_ID) [alterdatabasedata] ) [alterdatabasedata] ON COMMIT DELETE ROWS [alterdatabasedata] SQL Command failed with: ORA-00955: name is already used by an existing object [alterdatabasedata] [alterdatabasedata] -- END [alterdatabasedata] [alterdatabasedata] CREATE GLOBAL TEMPORARY TABLE C_TEMP_SELECTION2 [alterdatabasedata] ( [alterdatabasedata] QUERY_ID NUMBER(10) NOT NULL, [alterdatabasedata] C_TEMP_SELECTION_ID NUMBER(10) NOT NULL, [alterdatabasedata] CONSTRAINT C_TEMP_SELECTION2_key PRIMARY KEY (QUERY_ID, C_TEMP_SELECTION_ID) [alterdatabasedata] ) [alterdatabasedata] ON COMMIT PRESERVE ROWS [alterdatabasedata] Executed 3 SQL command(s) with 2 error(s) [alterdatabasedata] Reading tables... [alterdatabasedata] Reading views... [alterdatabasedata] Reading sequences... [alterdatabasedata] Reading triggers... [alterdatabasedata] Reading functions... [alterdatabasedata] Sorting foreign keys and checks... [alterdatabasedata] Original model loaded from database. [alterdatabasedata] Processing Trigger Trigger [name=C_CONVERSION_RATE_TRG2; ] (removed from database Oracle server) [alterdatabasedata] Processing Trigger Trigger [name=C_CONVERSION_RATE_TRG2; ] (created for the database Oracle server) [alterdatabasedata] Processing Table AD_MONTH_TRL (added) [alterdatabasedata] Processing Column C_ACCTSCHEMA_GL_ID (created for table C_ACCTSCHEMA_GL) [alterdatabasedata] The primary key of table C_ACCTSCHEMA_GL will be changed [alterdatabasedata] Processing Column UPC of table M_PRODUCT (changed because of the type) [alterdatabasedata] Processing Column SKU of table M_PRODUCT (changed because of the type) [alterdatabasedata] Processing Column UPC of table M_PRODUCT_CUSTOMER (changed because of the type) [alterdatabasedata] Processing Function Function [notation=A_ASSET_POST(NUMERIC, NUMERIC); ] (removed from database Oracle server) [alterdatabasedata] Processing Function Function [notation=M_GET_OFFERS_NAME(TIMESTAMP, NUMERIC, NUMERIC); ] (removed from database Oracle server) [alterdatabasedata] Processing Function Function [notation=M_REQUISITION_CREATEPO(NUMERIC); ] (removed from database Oracle server) [alterdatabasedata] Processing Function Function [notation=C_INVOICE_CREATE(NUMERIC, NUMERIC, NUMERIC); ] (removed from database Oracle server) [alterdatabasedata] Processing Function Function [notation=MA_PRODUCTIONRUN_STANDARD(NUMERIC); ] (removed from database Oracle server) [alterdatabasedata] Processing Function Function [notation=MRP_RUN_INITIALIZE(NUMERIC, NUMERIC, NUMERIC, NUMERIC, NUMERIC, NUMERIC, NUMERIC, NUMERIC, NUMERIC, NUMERIC, NUMERIC, TIMESTAMP, CHAR); ] (removed from database Oracle server) [alterdatabasedata] Processing Function Function [notation=AD_LANGUAGE_CREATE(NUMERIC); ] (removed from database Oracle server) [alterdatabasedata] Processing Function Function [notation=BOM_QTY_ONHAND(NUMERIC, NUMERIC, NUMERIC); ] (removed from database Oracle server) [alterdatabasedata] Processing Function Function [notation=GET_PRODUCT_COST(NUMERIC, TIMESTAMP, CHAR); ] (removed from database Oracle server) [alterdatabasedata] Processing Function Function [notation=AD_LANGUAGE_CREATE(NUMERIC); ] (created for the database Oracle server) [alterdatabasedata] Processing Function Function [notation=A_ASSET_POST(NUMERIC, NUMERIC); ] (created for the database Oracle server) [alterdatabasedata] Processing Function Function [notation=BOM_QTY_ONHAND(NUMERIC, NUMERIC, NUMERIC); ] (created for the database Oracle server) [alterdatabasedata] Processing Function Function [notation=C_INVOICE_CREATE(NUMERIC, NUMERIC, NUMERIC); ] (created for the database Oracle server) [alterdatabasedata] Processing Function Function [notation=GET_PRODUCT_COST(NUMERIC, TIMESTAMP, CHAR); ] (created for the database Oracle server) [alterdatabasedata] Processing Function Function [notation=MA_PRODUCTIONRUN_STANDARD(NUMERIC); ] (created for the database Oracle server) [alterdatabasedata] Processing Function Function [notation=MRP_RUN_INITIALIZE(NUMERIC, NUMERIC, NUMERIC, NUMERIC, NUMERIC, NUMERIC, NUMERIC, NUMERIC, NUMERIC, NUMERIC, NUMERIC, TIMESTAMP, CHAR); ] (created for the database Oracle server) [alterdatabasedata] Processing Function Function [notation=M_GET_OFFERS_NAME(TIMESTAMP, NUMERIC, NUMERIC); ] (created for the database Oracle server) [alterdatabasedata] Processing Function Function [notation=M_REQUISITION_CREATEPO(NUMERIC); ] (created for the database Oracle server) [alterdatabasedata] Executed 211 SQL command(s) with 0 error(s) [alterdatabasedata] Executed 68 SQL command(s) with 0 error(s) [alterdatabasedata] Executed 133 SQL command(s) with 0 error(s) [alterdatabasedata] Processing Trigger Trigger [name=C_CONVERSION_RATE_TRG2; ] (removed from database Oracle server) [alterdatabasedata] Processing Trigger Trigger [name=C_CONVERSION_RATE_TRG2; ] (created for the database Oracle server) [alterdatabasedata] Processing Table AD_MONTH_TRL (added) [alterdatabasedata] Processing Column C_ACCTSCHEMA_GL_ID (created for table C_ACCTSCHEMA_GL) [alterdatabasedata] The primary key of table C_ACCTSCHEMA_GL will be changed [alterdatabasedata] Processing Column UPC of table M_PRODUCT (changed because of the type) [alterdatabasedata] Processing Column SKU of table M_PRODUCT (changed because of the type) [alterdatabasedata] Processing Column UPC of table M_PRODUCT_CUSTOMER (changed because of the type) [alterdatabasedata] Processing Function Function [notation=A_ASSET_POST(NUMERIC, NUMERIC); ] (removed from database Oracle server) [alterdatabasedata] Processing Function Function [notation=M_GET_OFFERS_NAME(TIMESTAMP, NUMERIC, NUMERIC); ] (removed from database Oracle server) [alterdatabasedata] Processing Function Function [notation=M_REQUISITION_CREATEPO(NUMERIC); ] (removed from database Oracle server) [alterdatabasedata] Processing Function Function [notation=C_INVOICE_CREATE(NUMERIC, NUMERIC, NUMERIC); ] (removed from database Oracle server) [alterdatabasedata] Processing Function Function [notation=MA_PRODUCTIONRUN_STANDARD(NUMERIC); ] (removed from database Oracle server) [alterdatabasedata] Processing Function Function [notation=MRP_RUN_INITIALIZE(NUMERIC, NUMERIC, NUMERIC, NUMERIC, NUMERIC, NUMERIC, NUMERIC, NUMERIC, NUMERIC, NUMERIC, NUMERIC, TIMESTAMP, CHAR); ] (removed from database Oracle server) [alterdatabasedata] Processing Function Function [notation=AD_LANGUAGE_CREATE(NUMERIC); ] (removed from database Oracle server) [alterdatabasedata] Processing Function Function [notation=BOM_QTY_ONHAND(NUMERIC, NUMERIC, NUMERIC); ] (removed from database Oracle server) [alterdatabasedata] Processing Function Function [notation=GET_PRODUCT_COST(NUMERIC, TIMESTAMP, CHAR); ] (removed from database Oracle server) [alterdatabasedata] Processing Function Function [notation=AD_LANGUAGE_CREATE(NUMERIC); ] (created for the database Oracle server) [alterdatabasedata] Processing Function Function [notation=A_ASSET_POST(NUMERIC, NUMERIC); ] (created for the database Oracle server) [alterdatabasedata] Processing Function Function [notation=BOM_QTY_ONHAND(NUMERIC, NUMERIC, NUMERIC); ] (created for the database Oracle server) [alterdatabasedata] Processing Function Function [notation=C_INVOICE_CREATE(NUMERIC, NUMERIC, NUMERIC); ] (created for the database Oracle server) [alterdatabasedata] Processing Function Function [notation=GET_PRODUCT_COST(NUMERIC, TIMESTAMP, CHAR); ] (created for the database Oracle server) [alterdatabasedata] Processing Function Function [notation=MA_PRODUCTIONRUN_STANDARD(NUMERIC); ] (created for the database Oracle server) [alterdatabasedata] Processing Function Function [notation=MRP_RUN_INITIALIZE(NUMERIC, NUMERIC, NUMERIC, NUMERIC, NUMERIC, NUMERIC, NUMERIC, NUMERIC, NUMERIC, NUMERIC, NUMERIC, TIMESTAMP, CHAR); ] (created for the database Oracle server) [alterdatabasedata] Processing Function Function [notation=M_GET_OFFERS_NAME(TIMESTAMP, NUMERIC, NUMERIC); ] (created for the database Oracle server) [alterdatabasedata] Processing Function Function [notation=M_REQUISITION_CREATEPO(NUMERIC); ] (created for the database Oracle server) [alterdatabasedata] Executed 219 SQL command(s) with 0 error(s) [alterdatabasedata] Executing default postscript [alterdatabasedata] Executed 10 SQL command(s) with 0 error(s) database.postcreate.ORACLE: [sql] Executing commands [sql] 8 of 8 SQL statements executed successfully BUILD SUCCESSFUL Total time: 3 minutes 18 seconds