| Attached Files |  RES_SETOF_ERROR.txt [^] (27,239 bytes) 2015-03-27 13:47 [Show Content] [Hide Content]/*********************My Original Function*****************************/
/**** this function use a view srct_invoice_ddpprl for extract the last cost in purchase invoices (with a specified price list) ***/
CREATE OR REPLACE FUNCTION srct_get_ddp_invoice (p_ad_client_id character varying(32),p_ad_org_id character varying(32),p_m_product_id character varying(32), p_datelimit timestamp default now())
RETURNS SETOF record AS
$BODY$
DECLARE
reg record;
BEGIN
/**** srct_invoice_ddpprl is a view in my module, it's work correctly ****/
return query select pr.m_product_id,pr.documentno,pr.dateinvoiced,coalesce(pr.pricestd,0) pricestd
from srct_invoice_ddpprl pr
where pr.ad_client_id=p_ad_client_id
and AD_ISORGINCLUDED(pr.ad_org_id, p_ad_org_id, p_ad_client_id)<>-1
and pr.m_product_id=p_m_product_id
and pr.dateinvoiced<=p_datelimit
order by pr.dateinvoiced desc
limit 1;
END;
$BODY$
LANGUAGE plpgsql VOLATILE
COST 100;
/**********************Function's version in Postgresql tested*****************/
-- Function: srct_get_ddp_invoice(character varying, character varying, character varying, timestamp without time zone)
-- DROP FUNCTION srct_get_ddp_invoice(character varying, character varying, character varying, timestamp without time zone);
CREATE OR REPLACE FUNCTION srct_get_ddp_invoice(p_ad_client_id character varying, p_ad_org_id character varying, p_m_product_id character varying, p_datelimit timestamp without time zone DEFAULT now())
RETURNS SETOF record AS
$BODY$
DECLARE
reg record;
BEGIN
return query select pr.m_product_id,pr.documentno,pr.dateinvoiced,coalesce(pr.pricestd,0) pricestd
from srct_invoice_ddpprl pr
where pr.ad_client_id=p_ad_client_id
and AD_ISORGINCLUDED(pr.ad_org_id, p_ad_org_id, p_ad_client_id)<>-1
and pr.m_product_id=p_m_product_id
and pr.dateinvoiced<=p_datelimit
order by pr.dateinvoiced desc
limit 1;
END;
$BODY$
LANGUAGE plpgsql VOLATILE
COST 100
ROWS 1000;
ALTER FUNCTION srct_get_ddp_invoice(character varying, character varying, character varying, timestamp without time zone)
OWNER TO postgres;
/******* Exemple of my caller SQL sentence ***, tested in postgres////
select p.ad_org_id,p.m_product_id,p.value,p.name,cos.documentno,cos.dateinvoiced,cos.pricestd
from m_product p
left join srct_get_ddp_invoice(p.ad_client_id,p.ad_org_id,p.m_product_id) cos(m_product_id character varying(32),documentno character varying(30),dateinvoiced timestamp,pricestd numeric)
on cos.m_product_id=p.m_product_id
where p.value='202.010.009'
*/*******************Content Openbravo Module's xml file exported *////////////////////
<?xml version="1.0"?>
<database name="FUNCTION SRCT_GET_DDP_INVOICE">
<function name="SRCT_GET_DDP_INVOICE" type="VARCHAR">
<parameter name="p_ad_client_id" type="VARCHAR" mode="in">
<default/>
</parameter>
<parameter name="p_ad_org_id" type="VARCHAR" mode="in">
<default/>
</parameter>
<parameter name="p_m_product_id" type="VARCHAR" mode="in">
<default/>
</parameter>
<parameter name="p_datelimit" type="TIMESTAMP" mode="in">
<default/>
</parameter>
<body><![CDATA[reg record;
BEGIN
return query select pr.m_product_id,pr.documentno,pr.dateinvoiced,coalesce(pr.pricestd,0) pricestd
from srct_invoice_ddpprl pr
where pr.ad_client_id=p_ad_client_id
and AD_ISORGINCLUDED(pr.ad_org_id, p_ad_org_id, p_ad_client_id)<>-1
and pr.m_product_id=p_m_product_id
and pr.dateinvoiced<=p_datelimit
order by pr.dateinvoiced desc
limit 1;
END SRCT_GET_DDP_INVOICE
]]></body>
</function>
</database>
/**** Openbravo's rebuild logs ****/
set.code.rev:
code.rev:
init:
core.lib:
init:
compile:
build.jar:
build:
copy.core.lib:
database.lib:
init:
compile:
build.jar:
jar:
buildvalidation:
[sql] Executing commands
[sql] 2 of 2 SQL statements executed successfully
buildvalidation:
[java] 0 [main] INFO org.openbravo.buildvalidation.BuildValidationHandler - Executing build validation: org.openbravo.buildvalidation.AccountingTabs
[java] 1313 [main] INFO org.openbravo.buildvalidation.BuildValidationHandler - Executing build validation: org.openbravo.buildvalidation.DuplicateDocExchangeRate
[java] 1829 [main] INFO org.openbravo.buildvalidation.BuildValidationHandler - Executing build validation: org.openbravo.buildvalidation.DuplicatedJavaPackage
[java] 1868 [main] INFO org.openbravo.buildvalidation.BuildValidationHandler - Executing build validation: org.openbravo.buildvalidation.DuplicatedPriceListVersion
[java] 1918 [main] INFO org.openbravo.buildvalidation.BuildValidationHandler - Executing build validation: org.openbravo.buildvalidation.PaymentGLItemCheck
[java] 1969 [main] INFO org.openbravo.buildvalidation.BuildValidationHandler - Executing build validation: org.openbravo.buildvalidation.PreferenceConflict
[java] 2008 [main] INFO org.openbravo.buildvalidation.BuildValidationHandler - Executing build validation: org.openbravo.buildvalidation.User1Ready
[java] 2046 [main] INFO org.openbravo.buildvalidation.BuildValidationHandler - Executing build validation: org.openbravo.advpaymentmngt.buildvalidation.UniquePaymentForTransaction
[java] 2767 [main] INFO org.openbravo.buildvalidation.BuildValidationHandler - Executing build validation: org.openbravo.advpaymentmngt.buildvalidation.UnpostRefundPayments
[java] 3017 [main] INFO org.openbravo.buildvalidation.BuildValidationHandler - Executing build validation: org.openbravo.advpaymentmngt.buildvalidation.WrongPaymentScheduleDetailsCheck
update.database:
[sql] Executing commands
[sql] 2 of 2 SQL statements executed successfully
update.database.java:
[java] Executing database update process without checking changes in local files.
[java] 0 INFO - Database connection: jdbc:postgresql://127.0.0.1:5432/openbravo-erp. User: tad
[java] 1529 INFO - Executing full update.database
[java] 1585 INFO - Reading tables...
[java] 8665 INFO - Reading views...
[java] 9045 INFO - Reading sequences...
[java] 9070 INFO - Reading triggers...
[java] 9223 INFO - Reading functions...
[java] 9695 INFO - Sorting foreign keys, indexes and checks...
[java] 9894 INFO - Starting function and trigger standardization.
[java] 35403 INFO - Checking datatypes from the model loaded from the database
[java] 35416 INFO - Original model loaded from database.
[java] 35583 INFO - Reading model files...
[java] 42774 INFO - Checking datatypes from the model loaded from XML files
[java] 43056 INFO - Loading data from XML files
[java] 50210 INFO - Loading and applying configuration scripts
[java] 50230 INFO - Applying structure part of configuration script: org.openbravo.v3
[java] 50242 INFO - Loading configuration script: /home/openbravo/openbravoerp/modules/org.openbravo.v3/src-db/database/configScript.xml
[java] 50299 INFO - Applying structure part of configuration script: com.kyosei.serimax.customization.template
[java] 50309 INFO - Loading configuration script: /home/openbravo/openbravoerp/modules/com.kyosei.serimax.customization.template/src-db/database/configScript.xml
[java] 50336 INFO - Applying structure part of configuration script: com.kyoseicorp.serimax.advpaymentmngt.customization.template
[java] 50342 INFO - Loading configuration script: /home/openbravo/openbravoerp/modules/com.kyoseicorp.serimax.advpaymentmngt.customization.template/src-db/database/configScript.xml
[java] 50386 INFO - Applying structure part of configuration script: com.kyoseicorp.payment.financialaccountbyorg.template
[java] 50417 INFO - Loading configuration script: /home/openbravo/openbravoerp/modules/com.kyoseicorp.payment.financialaccountbyorg.template/src-db/database/configScript.xml
[java] 50445 INFO - Applying structure part of configuration script: com.kyosei.localization.paraguay.invoicesmanual.template
[java] 50451 INFO - Loading configuration script: /home/openbravo/openbravoerp/modules/com.kyosei.localization.paraguay.invoicesmanual.template/src-db/database/configScript.xml
[java] 50478 INFO - Applying structure part of configuration script: com.kyoseicorp.importdata.manufacturing.template
[java] 50484 INFO - Couldn't find configuration script for template: com.kyoseicorp.importdata.manufacturing.template (file: /home/openbravo/openbravoerp/modules/com.kyoseicorp.importdata.manufacturing.template/src-db/database/configScript.xml)
[java] 50501 INFO - Applying structure part of configuration script: com.kyoseicorp.sol.bpvalidate.template
[java] 50517 INFO - Loading configuration script: /home/openbravo/openbravoerp/modules/com.kyoseicorp.sol.bpvalidate.template/src-db/database/configScript.xml
[java] 50562 INFO - Applying structure part of configuration script: com.kyosei.sales.validate.partner.template
[java] 50593 INFO - Loading configuration script: /home/openbravo/openbravoerp/modules/com.kyosei.sales.validate.partner.template/src-db/database/configScript.xml
[java] 50686 INFO - Applying structure part of configuration script: com.kyoseicorp.bpvalidate_talonario.template
[java] 50708 INFO - Loading configuration script: /home/openbravo/openbravoerp/modules/com.kyoseicorp.bpvalidate_talonario.template/src-db/database/configScript.xml
[java] 50746 INFO - Applying structure part of configuration script: com.kyoseicorp.salesorderline.validatestock.template
[java] 50774 INFO - Loading configuration script: /home/openbravo/openbravoerp/modules/com.kyoseicorp.salesorderline.validatestock.template/src-db/database/configScript.xml
[java] 50802 INFO - Applying structure part of configuration script: com.kyosei.sales.validate.partner.callout.template
[java] 50808 INFO - Loading configuration script: /home/openbravo/openbravoerp/modules/com.kyosei.sales.validate.partner.callout.template/src-db/database/configScript.xml
[java] 50846 INFO - Applying structure part of configuration script: com.serimax.customization.template
[java] 50874 INFO - Loading configuration script: /home/openbravo/openbravoerp/modules/com.serimax.customization.template/src-db/database/configScript.xml
[java] Checking if database structure was modified locally.
[java] Checking if data has changed in the application dictionary.
[java] 54351 INFO - Executing default prescript
[java] 56766 INFO - Executed 117 SQL command(s) successfully
[java] 56790 INFO - Updating database model...
[java] 89504 WARN - SQL Command failed with: ERROR: no se puede usar RETURN QUERY en una función que no ha sido declarada SETOF
[java] Position: 403
[java] 89562 WARN - -- END
[java] -- -----------------------------------------------------------------------
[java] -- FUNCTION SRCT_GET_DDP_INVOICE
[java] -- -----------------------------------------------------------------------
[java] CREATE OR REPLACE FUNCTION SRCT_GET_DDP_INVOICE(p_ad_client_id IN VARCHAR, p_ad_org_id IN VARCHAR, p_m_product_id IN VARCHAR, p_datelimit IN TIMESTAMP) RETURNS VARCHAR
[java]
[java] AS $BODY$ DECLARE
[java] reg record;
[java] BEGIN
[java] return query select pr.m_product_id,pr.documentno,pr.dateinvoiced,coalesce(pr.pricestd,0) pricestd
[java] from srct_invoice_ddpprl pr
[java] where pr.ad_client_id=p_ad_client_id
[java] and AD_ISORGINCLUDED(pr.ad_org_id, p_ad_org_id, p_ad_client_id)<>-1
[java] and pr.m_product_id=p_m_product_id
[java] and pr.dateinvoiced<=p_datelimit
[java] order by pr.dateinvoiced desc
[java] limit 1;
[java] END ; $BODY$ LANGUAGE plpgsql;
[java] 89578 INFO - Executed 562 SQL command(s) with 1 error(s)
[java] 89629 INFO - Executed 7 forced SQL command(s) with 1 error(s)
[java] 89645 INFO - Model update complete.
[java] 90396 INFO - Disabling foreign keys
[java] 91061 INFO - Executed 362 SQL command(s) successfully
[java] 91069 INFO - Disabling triggers
[java] 91339 INFO - Executed 323 SQL command(s) successfully
[java] 91610 INFO - Executed 757 SQL command(s) successfully
[java] 91680 INFO - Executing moduleScript: org.openbravo.modulescript.AdminFlagOnCreateDefaults
[java] 92018 INFO - Executing moduleScript: org.openbravo.modulescript.AlertMASequenceProduct
[java] 92204 INFO - Executing moduleScript: org.openbravo.modulescript.ConvertImages
[java] 92336 INFO - Executing moduleScript: org.openbravo.modulescript.CreateDoctypeTemplate
[java] 92576 INFO - Executing moduleScript: org.openbravo.modulescript.CreateLineForSequenceProduct
[java] 92645 INFO - Executing moduleScript: org.openbravo.modulescript.DeleteDuplicateMatchInvoice
[java] 103059 INFO - Executing moduleScript: org.openbravo.modulescript.DeleteInventoryLines
[java] 104118 INFO - Executing moduleScript: org.openbravo.modulescript.DeleteRedundantTranslations
[java] 104468 INFO - Executing moduleScript: org.openbravo.modulescript.HBFix
[java] 105219 INFO - Executing moduleScript: org.openbravo.modulescript.InitializeAcctDimensionsInClient
[java] 106050 INFO - Executing moduleScript: org.openbravo.modulescript.InitializeAlertStatus
[java] 106392 INFO - Executing moduleScript: org.openbravo.modulescript.InitializeBPCurrency
[java] 106791 INFO - Executing moduleScript: org.openbravo.modulescript.InitializeCostingMigrationPreference
[java] 106950 INFO - Executing moduleScript: org.openbravo.modulescript.InitializeGeneralLedgerOrganization
[java] 107152 INFO - Executing moduleScript: org.openbravo.modulescript.InitializeIsPaymentPaid
[java] 107186 INFO - Executing moduleScript: org.openbravo.modulescript.InitializeOnHandWarehouse
[java] 107236 INFO - Executing moduleScript: org.openbravo.modulescript.Issue21640WrongMatchInvAccounting
[java] 107417 INFO - Executing moduleScript: org.openbravo.modulescript.PaymentZeroAmount
[java] 107650 INFO - Executing moduleScript: org.openbravo.modulescript.UniqueValidCombination
[java] 107933 INFO - Executing moduleScript: org.openbravo.modulescript.UpdateADClientInfo
[java] 108275 INFO - Executing moduleScript: org.openbravo.modulescript.UpdateADTrees
[java] 108490 INFO - Executing moduleScript: org.openbravo.modulescript.UpdateCostingRulesWhenNotCalculatedCosts
[java] 108618 INFO - Executing moduleScript: org.openbravo.modulescript.UpdateDueDate
[java] 109210 INFO - Executing moduleScript: org.openbravo.modulescript.UpdateEmailPasswords
[java] 109292 INFO - Executing moduleScript: org.openbravo.modulescript.UpdateFactAcctDescription
[java] 109333 INFO - Executing moduleScript: org.openbravo.modulescript.UpdateFinancialAccountAccounts
[java] 109399 INFO - Executing moduleScript: org.openbravo.modulescript.UpdateGrandTotal
[java] 109441 INFO - Executing moduleScript: org.openbravo.modulescript.UpdateMTransactionCostingStatus
[java] 109458 INFO - Executing moduleScript: org.openbravo.modulescript.UpdateOpenClosePeriodsButton
[java] 109476 INFO - Executing moduleScript: org.openbravo.modulescript.UpdatePaymentPlan
[java] 109492 INFO - Executing moduleScript: org.openbravo.modulescript.UpdateProcessGoodsJavaDocAction
[java] 109508 INFO - Executing moduleScript: org.openbravo.modulescript.UpdateProductPrice
[java] 110151 INFO - Executing moduleScript: org.openbravo.modulescript.UpdateRequestProcessOrg
[java] 110366 INFO - Executing moduleScript: org.openbravo.modulescript.UpdateReservationQtys
[java] 110422 INFO - Executing moduleScript: org.openbravo.modulescript.UpdateReversalDocumentTypes
[java] 111126 INFO - Executing moduleScript: org.openbravo.modulescript.UpgradeToPocEmail
[java] 111478 INFO - Executing moduleScript: org.openbravo.advpaymentmngt.modulescript.AlertsForWrongInvoices
[java] 118229 INFO - Executing moduleScript: org.openbravo.advpaymentmngt.modulescript.AlertsForWrongOrders
[java] 124644 INFO - Executing moduleScript: org.openbravo.advpaymentmngt.modulescript.CreateAccountingConfiguration
[java] 125336 INFO - Executing moduleScript: org.openbravo.advpaymentmngt.modulescript.CreateDocumentNoSequence
[java] 125703 INFO - Executing moduleScript: org.openbravo.advpaymentmngt.modulescript.InitializeAPRMReadyPreference
[java] 125756 INFO - Executing moduleScript: org.openbravo.advpaymentmngt.modulescript.LinkCreditPayments
[java] 126303 INFO - Executing moduleScript: org.openbravo.advpaymentmngt.modulescript.UpdateCustomerBalance
[java] 126342 INFO - Executing moduleScript: org.openbravo.advpaymentmngt.modulescript.UpdateGeneratedUsedCreditColumns
[java] 127536 INFO - Executing moduleScript: org.openbravo.advpaymentmngt.modulescript.UpdatePaymentScheduledetail
[java] 127574 INFO - Executing moduleScript: org.openbravo.advpaymentmngt.modulescript.UpdateReconciliationProcessButtonValue
[java] 127674 INFO - Executing moduleScript: org.openbravo.advpaymentmngt.modulescript.UpdateReconciliationStatementProcessedValue
[java] 127919 INFO - Executing moduleScript: org.openbravo.advpaymentmngt.modulescript.UpdateRecordId2Value
[java] 128086 INFO - Executing moduleScript: org.openbravo.advpaymentmngt.modulescript.UpdateTransactionBPExchangeRate
[java] 128542 INFO - Executing moduleScript: org.openbravo.idl.modulescript.RemoveOldIDLEntities
[java] 128634 INFO - Executing moduleScript: org.openbravo.userinterface.selector.UpdateLanguageColumn
[java] 128980 INFO - Executing moduleScript: org.openbravo.userinterface.skin.s250to300Comp.modulescript.DefaultSkin
[java] 129132 INFO - Executing moduleScript: org.openbravo.v3.datasets.SetDefaultRole
[java] 129208 INFO - Loading and applying configuration scripts
[java] 129381 INFO - Applying data part of configuration script: org.openbravo.v3
[java] 129420 INFO - Loading configuration script: /home/openbravo/openbravoerp/modules/org.openbravo.v3/src-db/database/configScript.xml
[java] 130223 INFO - Applying data part of configuration script: com.kyosei.serimax.customization.template
[java] 130304 INFO - Loading configuration script: /home/openbravo/openbravoerp/modules/com.kyosei.serimax.customization.template/src-db/database/configScript.xml
[java] 130431 INFO - Applying data part of configuration script: com.kyoseicorp.serimax.advpaymentmngt.customization.template
[java] 130472 INFO - Loading configuration script: /home/openbravo/openbravoerp/modules/com.kyoseicorp.serimax.advpaymentmngt.customization.template/src-db/database/configScript.xml
[java] Warning: old value in row not equal to expected one. Table:[AD_PROCESS_PARA] PK[: EBB0EC2A9E3C42CAAEA0D89EEA71B0FD] Old Value found: 5F2D5D136F784DEFA94DC26592634206 Old value expected null
[java] Warning: old value in row not equal to expected one. Table:[AD_COLUMN] PK[: 7FCAAFE989BCA375E040007F01007F0A] Old Value found: null Old value expected 12016E2EDE0245B5A36B84CBA144DBDF
[java] Warning: old value in row not equal to expected one. Table:[AD_MODULE] PK[: 3FCFD8608FE34FF292DB3C485D17F6AD] Old Value found: 1.0.10 Old value expected 1.0.2
[java] 130548 INFO - Applying data part of configuration script: com.kyoseicorp.payment.financialaccountbyorg.template
[java] 130575 INFO - Loading configuration script: /home/openbravo/openbravoerp/modules/com.kyoseicorp.payment.financialaccountbyorg.template/src-db/database/configScript.xml
[java] 130629 INFO - Applying data part of configuration script: com.kyosei.localization.paraguay.invoicesmanual.template
[java] 130670 INFO - Loading configuration script: /home/openbravo/openbravoerp/modules/com.kyosei.localization.paraguay.invoicesmanual.template/src-db/database/configScript.xml
[java] 130701 INFO - Applying data part of configuration script: com.kyoseicorp.importdata.manufacturing.template
[java] 130706 INFO - Couldn't find configuration script for template: com.kyoseicorp.importdata.manufacturing.template (file: /home/openbravo/openbravoerp/modules/com.kyoseicorp.importdata.manufacturing.template/src-db/database/configScript.xml)
[java] 130723 INFO - Applying data part of configuration script: com.kyoseicorp.sol.bpvalidate.template
[java] 130759 INFO - Loading configuration script: /home/openbravo/openbravoerp/modules/com.kyoseicorp.sol.bpvalidate.template/src-db/database/configScript.xml
[java] 130848 INFO - Applying data part of configuration script: com.kyosei.sales.validate.partner.template
[java] 130889 INFO - Loading configuration script: /home/openbravo/openbravoerp/modules/com.kyosei.sales.validate.partner.template/src-db/database/configScript.xml
[java] We didn't found the row that we wanted to change. Table:[AD_MENU] PK[: E1F659E30F4B495BBB0189F4111B4D02]
[java] We didn't found the row that we wanted to change. Table:[AD_PROCESS_PARA] PK[: 4991EADE21AD44B39925D1F048D5B3F5]
[java] We didn't found the row that we wanted to change. Table:[AD_PROCESS_PARA] PK[: 4991EADE21AD44B39925D1F048D5B3F5]
[java] We didn't found the row that we wanted to change. Table:[AD_PROCESS_PARA] PK[: 65B108F88E72428BB5716060D1EE400C]
[java] We didn't found the row that we wanted to change. Table:[AD_PROCESS_PARA] PK[: F8454286B34B491182CC573036CF95EC]
[java] We didn't found the row that we wanted to change. Table:[AD_PROCESS_PARA] PK[: F8454286B34B491182CC573036CF95EC]
[java] We didn't found the row that we wanted to change. Table:[AD_FIELD] PK[: 70695A9311B94C319D83E3DF1F948AF0]
[java] 131059 INFO - Applying data part of configuration script: com.kyoseicorp.bpvalidate_talonario.template
[java] 131088 INFO - Loading configuration script: /home/openbravo/openbravoerp/modules/com.kyoseicorp.bpvalidate_talonario.template/src-db/database/configScript.xml
[java] 131131 INFO - Applying data part of configuration script: com.kyoseicorp.salesorderline.validatestock.template
[java] 131156 INFO - Loading configuration script: /home/openbravo/openbravoerp/modules/com.kyoseicorp.salesorderline.validatestock.template/src-db/database/configScript.xml
[java] 131193 INFO - Applying data part of configuration script: com.kyosei.sales.validate.partner.callout.template
[java] 131214 INFO - Loading configuration script: /home/openbravo/openbravoerp/modules/com.kyosei.sales.validate.partner.callout.template/src-db/database/configScript.xml
[java] 131247 INFO - Applying data part of configuration script: com.serimax.customization.template
[java] 131288 INFO - Loading configuration script: /home/openbravo/openbravoerp/modules/com.serimax.customization.template/src-db/database/configScript.xml
[java] 131332 INFO - Comparing databases to find differences
[java] 136596 INFO - Updating Application Dictionary data...
[java] 150136 INFO - Removing invalid rows.
[java] 193762 INFO - Executed 82 SQL command(s) successfully
[java] 193776 INFO - Recreating Primary Keys
[java] 204767 INFO - Executed 18 SQL command(s) successfully
[java] 204775 INFO - Executing oncreatedefault statements for mandatory columns
[java] 211289 INFO - Executed 242 SQL command(s) successfully
[java] 211311 INFO - Recreating not null constraints
[java] 212978 INFO - Executed 917 SQL command(s) successfully
[java] 213012 INFO - Executing update final script (dropping temporary tables)
[java] 235320 INFO - Executed 224 SQL command(s) successfully
[java] 235597 INFO - Executed 6 forced SQL command(s) with 1 error(s)
[java] 235622 INFO - Executed 1 forced SQL command(s) with 1 error(s)
[java] 235638 INFO - Executed 1 forced SQL command(s) with 1 error(s)
[java] 235655 INFO - Executed 1 forced SQL command(s) with 1 error(s)
[java] 235672 INFO - Executed 1 forced SQL command(s) with 1 error(s)
[java] 235688 WARN - SQL Command failed with: ERROR: error de sintaxis en o cerca de «]»
[java] Position: 792
[java] 235804 WARN - There are still 1 forced commands not executed sucessfully (likely related to failed view statements).
[java] 235863 INFO - Enabling Foreign Keys and Triggers
[java] 296970 INFO - Executed 362 SQL command(s) successfully
[java] 298245 INFO - Executed 323 SQL command(s) successfully
[java] 298902 INFO - Executing default postscript
[java] 301046 INFO - Executed 13 SQL command(s) successfully
[java] 303013 ERROR - Not all the commands in the final update step were executed correctly. This likely means at least one foreign key was not activated successfully. Please review which one, and fix the missing references, or recover the backup of your sources.
[java] java.lang.Exception: There were serious problems while updating the database. Please review and fix them before continuing with the application rebuild
[java] at org.openbravo.ddlutils.task.AlterDatabaseDataAll.doExecute(AlterDatabaseDataAll.java:231)
[java] at org.openbravo.ddlutils.task.BaseDatabaseTask.execute(BaseDatabaseTask.java:86)
[java] at org.openbravo.ddlutils.task.AlterDatabaseJava.main(AlterDatabaseJava.java:38)
[java] Exception in thread "main" java.lang.Exception: There were serious problems while updating the database. Please review and fix them before continuing with the application rebuild
[java] at org.openbravo.ddlutils.task.AlterDatabaseDataAll.doExecute(AlterDatabaseDataAll.java:250)
[java] at org.openbravo.ddlutils.task.BaseDatabaseTask.execute(BaseDatabaseTask.java:86)
[java] at org.openbravo.ddlutils.task.AlterDatabaseJava.main(AlterDatabaseJava.java:38)
[java] Caused by: java.lang.Exception: There were serious problems while updating the database. Please review and fix them before continuing with the application rebuild
[java] at org.openbravo.ddlutils.task.AlterDatabaseDataAll.doExecute(AlterDatabaseDataAll.java:231)
[java] ... 2 more
[java] --- Nested Exception ---
[java] java.lang.Exception: There were serious problems while updating the database. Please review and fix them before continuing with the application rebuild
[java] at org.openbravo.ddlutils.task.AlterDatabaseDataAll.doExecute(AlterDatabaseDataAll.java:231)
[java] at org.openbravo.ddlutils.task.BaseDatabaseTask.execute(BaseDatabaseTask.java:86)
[java] at org.openbravo.ddlutils.task.AlterDatabaseJava.main(AlterDatabaseJava.java:38)
|
Relationships [ Relation Graph ]
[ Dependency Graph ]
Relationships 