0033417: Loading config script for a module template in install.source task fails in pgsql 9.3

Anonymous | Login

Project:

News | My View | View Issues | Roadmap | Summary

View Revisions: Issue #33417		[ Back to Issue ]
Summary	0033417: Loading config script for a module template in install.source task fails in pgsql 9.3

Revision	2016-07-04 15:58 by Sandrahuguet
Steps To Reproduce	-install the following module template: https://code.openbravo.com/erp/pmods/org.openbravo.retail.storeserver.synchronization.template [^] -ant install.source Notice that the following error occurs in the execution of the task: Loading config script for module Store Server Synchronized Tables for Retail Template. Path: /srv/ci/workspace/mod-simple-ci23.140/src-db/database/../../modules/org.openbravo.retail.storeserver.synchronization.template/src-db/database/configScript.xml SQL Command failed with: ERROR: syntax error at or near "Y" Position: 135 -- END UPDATE AD_TAB SET HQLWHERECLAUSE = 'e.obstsynMobserver.id = (select id from OBMOBC_SERVER_DEFINITION ms where ms.iscurrent=\'Y\')' WHERE AD_TAB_ID = '8E5972CF3664486D9D887BDEDA88627D' SQL Command failed with: ERROR: syntax error at or near "Y" Position: 70 -- END UPDATE AD_TAB SET HQLFILTERCLAUSE = 'e.securityBasedOnRole=\'Y\' or e.userContact.id=@user@\n' WHERE AD_TAB_ID = '8E5972CF3664486D9D887BDEDA88627D' SQL Command failed with: ERROR: syntax error at or near "Y" Position: 182 -- END UPDATE AD_TAB SET HQLWHERECLAUSE = 'e.processRequest.id = @ProcessRequest.id@ and e.obstsynMobserver.id = (select id from OBMOBC_SERVER_DEFINITION ms where ms.iscurrent=\'Y\')' WHERE AD_TAB_ID = 'A22C68A803DA43D3AE1FFD51BBA3234A' Executed 5 SQL command(s) with 3 error(s)

Revision	2016-07-04 15:56 by Sandrahuguet
Steps To Reproduce	-install the following module template: https://code.openbravo.com/erp/pmods/org.openbravo.retail.storeserver.synchronization.template [^] -install.source Notice that the following error occurs in the execution of the task: Loading config script for module Store Server Synchronized Tables for Retail Template. Path: /srv/ci/workspace/mod-simple-ci23.140/src-db/database/../../modules/org.openbravo.retail.storeserver.synchronization.template/src-db/database/configScript.xml SQL Command failed with: ERROR: syntax error at or near "Y" Position: 135 -- END UPDATE AD_TAB SET HQLWHERECLAUSE = 'e.obstsynMobserver.id = (select id from OBMOBC_SERVER_DEFINITION ms where ms.iscurrent=\'Y\')' WHERE AD_TAB_ID = '8E5972CF3664486D9D887BDEDA88627D' SQL Command failed with: ERROR: syntax error at or near "Y" Position: 70 -- END UPDATE AD_TAB SET HQLFILTERCLAUSE = 'e.securityBasedOnRole=\'Y\' or e.userContact.id=@user@\n' WHERE AD_TAB_ID = '8E5972CF3664486D9D887BDEDA88627D' SQL Command failed with: ERROR: syntax error at or near "Y" Position: 182 -- END UPDATE AD_TAB SET HQLWHERECLAUSE = 'e.processRequest.id = @ProcessRequest.id@ and e.obstsynMobserver.id = (select id from OBMOBC_SERVER_DEFINITION ms where ms.iscurrent=\'Y\')' WHERE AD_TAB_ID = 'A22C68A803DA43D3AE1FFD51BBA3234A' Executed 5 SQL command(s) with 3 error(s)