obx.export.validateModules: [echo] Validating Module... [validateModules] 5283 [main] INFO org.openbravo.dal.core.DalLayerInitializer - Initializing in-memory model... [validateModules] 5307 [main] INFO org.openbravo.base.model.ModelProvider - Building runtime model [validateModules] 15348 [main] INFO org.openbravo.dal.core.DalLayerInitializer - Model read in-memory, generating mapping... [validateModules] 23503 [main] INFO org.openbravo.dal.core.DalLayerInitializer - Dal layer initialized [validateModules] 23825 [main] INFO SystemValidation - Validating Modules [validateModules] 23908 [main] INFO SystemValidation - Validating DB [validateModules] 25200 [main] INFO org.apache.ddlutils.platform.PlatformImplBase - Reading tables... [validateModules] 91627 [main] INFO org.apache.ddlutils.platform.PlatformImplBase - Reading views... [validateModules] 91712 [main] INFO org.apache.ddlutils.platform.PlatformImplBase - Reading materialized views... [validateModules] java.sql.SQLSyntaxErrorException: ORA-00933: comando SQL no terminado correctamente [validateModules] [validateModules] at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509) [validateModules] at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461) [validateModules] at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104) [validateModules] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:550) [validateModules] at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:268) [validateModules] at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655) [validateModules] at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:270) [validateModules] at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:91) [validateModules] at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:807) [validateModules] at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:983) [validateModules] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168) [validateModules] at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3666) [validateModules] at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1426) [validateModules] at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3713) [validateModules] at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1167) [validateModules] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) [validateModules] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) [validateModules] at org.apache.ddlutils.platform.ModelLoaderBase.readList(ModelLoaderBase.java:812) [validateModules] at org.apache.ddlutils.platform.ModelLoaderBase.readMaterializedViews(ModelLoaderBase.java:605) [validateModules] at org.apache.ddlutils.platform.ModelLoaderBase.readDatabase(ModelLoaderBase.java:214) [validateModules] at org.apache.ddlutils.platform.ModelLoaderBase.readDatabase(ModelLoaderBase.java:189) [validateModules] at org.apache.ddlutils.platform.ModelLoaderBase.getDatabase(ModelLoaderBase.java:142) [validateModules] at org.apache.ddlutils.platform.PlatformImplBase.loadModelFromDatabase(PlatformImplBase.java:2313) [validateModules] at org.openbravo.service.system.SystemValidationTask.doExecute(SystemValidationTask.java:94) [validateModules] at org.openbravo.dal.core.DalInitializingTask.execute(DalInitializingTask.java:129) [validateModules] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:292) [validateModules] at jdk.internal.reflect.GeneratedMethodAccessor4.invoke(Unknown Source) [validateModules] at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [validateModules] at java.base/java.lang.reflect.Method.invoke(Method.java:566) [validateModules] at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:99) [validateModules] at org.apache.tools.ant.Task.perform(Task.java:350) [validateModules] at org.apache.tools.ant.Target.execute(Target.java:449) [validateModules] at org.apache.tools.ant.Target.performTasks(Target.java:470) [validateModules] at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1401) [validateModules] at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:36) [validateModules] at org.apache.tools.ant.Project.executeTargets(Project.java:1264) [validateModules] at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:437) [validateModules] at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:106) [validateModules] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:292) [validateModules] at jdk.internal.reflect.GeneratedMethodAccessor4.invoke(Unknown Source) [validateModules] at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [validateModules] at java.base/java.lang.reflect.Method.invoke(Method.java:566) [validateModules] at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:99) [validateModules] at org.apache.tools.ant.Task.perform(Task.java:350) [validateModules] at org.apache.tools.ant.Target.execute(Target.java:449) [validateModules] at org.apache.tools.ant.Target.performTasks(Target.java:470) [validateModules] at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1401) [validateModules] at org.apache.tools.ant.Project.executeTarget(Project.java:1374) [validateModules] at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41) [validateModules] at org.apache.tools.ant.Project.executeTargets(Project.java:1264) [validateModules] at org.apache.tools.ant.Main.runBuild(Main.java:827) [validateModules] at org.apache.tools.ant.Main.startAnt(Main.java:223) [validateModules] at org.apache.tools.ant.launch.Launcher.run(Launcher.java:284) [validateModules] at org.apache.tools.ant.launch.Launcher.main(Launcher.java:101) [validateModules] Caused by: Error : 933, Position : 43, Sql = SELECT MVIEW_NAME, QUERY FROM USER_MVIEWS AND (UPPER(MVIEW_NAME) LIKE 'EUCNTRY\_%' ESCAPE '\' OR (upper(MVIEW_NAME) IN (SELECT upper(name1) FROM AD_EXCEPTIONS WHERE AD_MODULE_ID='19BF10F39699483AA7F095501B8E2679'))), OriginalSql = SELECT MVIEW_NAME, QUERY FROM USER_MVIEWS AND (UPPER(MVIEW_NAME) LIKE 'EUCNTRY\_%' ESCAPE '\' OR (upper(MVIEW_NAME) IN (SELECT upper(name1) FROM AD_EXCEPTIONS WHERE AD_MODULE_ID='19BF10F39699483AA7F095501B8E2679'))), Error Msg = ORA-00933: comando SQL no terminado correctamente [validateModules] [validateModules] at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:513) [validateModules] ... 53 more [validateModules] 91738 [main] ERROR org.apache.ddlutils.DatabaseOperationException - ORA-00933: comando SQL no terminado correctamente [validateModules] [validateModules] java.sql.SQLSyntaxErrorException: ORA-00933: comando SQL no terminado correctamente [validateModules] [validateModules] at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509) ~[ojdbc8-19.3.0.0.jar:19.3.0.0.0] [validateModules] at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461) ~[ojdbc8-19.3.0.0.jar:19.3.0.0.0] [validateModules] at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104) ~[ojdbc8-19.3.0.0.jar:19.3.0.0.0] [validateModules] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:550) ~[ojdbc8-19.3.0.0.jar:19.3.0.0.0] [validateModules] at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:268) ~[ojdbc8-19.3.0.0.jar:19.3.0.0.0] [validateModules] at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655) ~[ojdbc8-19.3.0.0.jar:19.3.0.0.0] [validateModules] at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:270) ~[ojdbc8-19.3.0.0.jar:19.3.0.0.0] [validateModules] at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:91) ~[ojdbc8-19.3.0.0.jar:19.3.0.0.0] [validateModules] at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:807) ~[ojdbc8-19.3.0.0.jar:19.3.0.0.0] [validateModules] at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:983) ~[ojdbc8-19.3.0.0.jar:19.3.0.0.0] [validateModules] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168) ~[ojdbc8-19.3.0.0.jar:19.3.0.0.0] [validateModules] at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3666) ~[ojdbc8-19.3.0.0.jar:19.3.0.0.0] [validateModules] at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1426) ~[ojdbc8-19.3.0.0.jar:19.3.0.0.0] [validateModules] at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3713) ~[ojdbc8-19.3.0.0.jar:19.3.0.0.0] [validateModules] at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1167) ~[ojdbc8-19.3.0.0.jar:19.3.0.0.0] [validateModules] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) ~[commons-dbcp-1.4.jar:1.4] [validateModules] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) ~[commons-dbcp-1.4.jar:1.4] [validateModules] at org.apache.ddlutils.platform.ModelLoaderBase.readList(ModelLoaderBase.java:812) ~[dbsourcemanager.jar:?] [validateModules] at org.apache.ddlutils.platform.ModelLoaderBase.readMaterializedViews(ModelLoaderBase.java:605) ~[dbsourcemanager.jar:?] [validateModules] at org.apache.ddlutils.platform.ModelLoaderBase.readDatabase(ModelLoaderBase.java:214) ~[dbsourcemanager.jar:?] [validateModules] at org.apache.ddlutils.platform.ModelLoaderBase.readDatabase(ModelLoaderBase.java:189) ~[dbsourcemanager.jar:?] [validateModules] at org.apache.ddlutils.platform.ModelLoaderBase.getDatabase(ModelLoaderBase.java:142) ~[dbsourcemanager.jar:?] [validateModules] at org.apache.ddlutils.platform.PlatformImplBase.loadModelFromDatabase(PlatformImplBase.java:2313) [dbsourcemanager.jar:?] [validateModules] at org.openbravo.service.system.SystemValidationTask.doExecute(SystemValidationTask.java:94) [classes/:?] [validateModules] at org.openbravo.dal.core.DalInitializingTask.execute(DalInitializingTask.java:129) [classes/:?] [validateModules] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:292) [ant.jar:1.10.9] [validateModules] at jdk.internal.reflect.GeneratedMethodAccessor4.invoke(Unknown Source) ~[?:?] [validateModules] at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?] [validateModules] at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?] [validateModules] at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:99) [ant.jar:?] [validateModules] at org.apache.tools.ant.Task.perform(Task.java:350) [ant.jar:1.10.9] [validateModules] at org.apache.tools.ant.Target.execute(Target.java:449) [ant.jar:1.10.9] [validateModules] at org.apache.tools.ant.Target.performTasks(Target.java:470) [ant.jar:1.10.9] [validateModules] at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1401) [ant.jar:1.10.9] [validateModules] at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:36) [ant.jar:?] [validateModules] at org.apache.tools.ant.Project.executeTargets(Project.java:1264) [ant.jar:1.10.9] [validateModules] at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:437) [ant.jar:?] [validateModules] at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:106) [ant.jar:?] [validateModules] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:292) [ant.jar:1.10.9] [validateModules] at jdk.internal.reflect.GeneratedMethodAccessor4.invoke(Unknown Source) ~[?:?] [validateModules] at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?] [validateModules] at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?] [validateModules] at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:99) [ant.jar:?] [validateModules] at org.apache.tools.ant.Task.perform(Task.java:350) [ant.jar:1.10.9] [validateModules] at org.apache.tools.ant.Target.execute(Target.java:449) [ant.jar:1.10.9] [validateModules] at org.apache.tools.ant.Target.performTasks(Target.java:470) [ant.jar:1.10.9] [validateModules] at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1401) [ant.jar:1.10.9] [validateModules] at org.apache.tools.ant.Project.executeTarget(Project.java:1374) [ant.jar:1.10.9] [validateModules] at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41) [ant.jar:?] [validateModules] at org.apache.tools.ant.Project.executeTargets(Project.java:1264) [ant.jar:1.10.9] [validateModules] at org.apache.tools.ant.Main.runBuild(Main.java:827) [ant.jar:1.10.9] [validateModules] at org.apache.tools.ant.Main.startAnt(Main.java:223) [ant.jar:1.10.9] [validateModules] at org.apache.tools.ant.launch.Launcher.run(Launcher.java:284) [ant-launcher.jar:?] [validateModules] at org.apache.tools.ant.launch.Launcher.main(Launcher.java:101) [ant-launcher.jar:?] [validateModules] Caused by: oracle.jdbc.OracleDatabaseException: ORA-00933: comando SQL no terminado correctamente [validateModules] [validateModules] at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:513) ~[ojdbc8-19.3.0.0.jar:19.3.0.0.0] [validateModules] ... 53 more BUILD FAILED /home/fcasado/openbravo/obisources/build.xml:747: The following error occurred while executing this line: /home/fcasado/openbravo/obisources/build.xml:739: org.apache.ddlutils.DatabaseOperationException: java.sql.SQLSyntaxErrorException: ORA-00933: comando SQL no terminado correctamente at org.apache.ddlutils.platform.PlatformImplBase.loadModelFromDatabase(PlatformImplBase.java:2316) at org.openbravo.service.system.SystemValidationTask.doExecute(SystemValidationTask.java:94) at org.openbravo.dal.core.DalInitializingTask.execute(DalInitializingTask.java:129) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:292) at jdk.internal.reflect.GeneratedMethodAccessor4.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:99) at org.apache.tools.ant.Task.perform(Task.java:350) at org.apache.tools.ant.Target.execute(Target.java:449) at org.apache.tools.ant.Target.performTasks(Target.java:470) at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1401) at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:36) at org.apache.tools.ant.Project.executeTargets(Project.java:1264) at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:437) at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:106) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:292) at jdk.internal.reflect.GeneratedMethodAccessor4.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:99) at org.apache.tools.ant.Task.perform(Task.java:350) at org.apache.tools.ant.Target.execute(Target.java:449) at org.apache.tools.ant.Target.performTasks(Target.java:470) at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1401) at org.apache.tools.ant.Project.executeTarget(Project.java:1374) at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41) at org.apache.tools.ant.Project.executeTargets(Project.java:1264) at org.apache.tools.ant.Main.runBuild(Main.java:827) at org.apache.tools.ant.Main.startAnt(Main.java:223) at org.apache.tools.ant.launch.Launcher.run(Launcher.java:284) at org.apache.tools.ant.launch.Launcher.main(Launcher.java:101) Caused by: java.sql.SQLSyntaxErrorException: ORA-00933: comando SQL no terminado correctamente at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:550) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:268) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:270) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:91) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:807) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:983) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3666) at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1426) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3713) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1167) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) at org.apache.ddlutils.platform.ModelLoaderBase.readList(ModelLoaderBase.java:812) at org.apache.ddlutils.platform.ModelLoaderBase.readMaterializedViews(ModelLoaderBase.java:605) at org.apache.ddlutils.platform.ModelLoaderBase.readDatabase(ModelLoaderBase.java:214) at org.apache.ddlutils.platform.ModelLoaderBase.readDatabase(ModelLoaderBase.java:189) at org.apache.ddlutils.platform.ModelLoaderBase.getDatabase(ModelLoaderBase.java:142) at org.apache.ddlutils.platform.PlatformImplBase.loadModelFromDatabase(PlatformImplBase.java:2313) ... 31 more Caused by: Error : 933, Position : 43, Sql = SELECT MVIEW_NAME, QUERY FROM USER_MVIEWS AND (UPPER(MVIEW_NAME) LIKE 'EUCNTRY\_%' ESCAPE '\' OR (upper(MVIEW_NAME) IN (SELECT upper(name1) FROM AD_EXCEPTIONS WHERE AD_MODULE_ID='19BF10F39699483AA7F095501B8E2679'))), OriginalSql = SELECT MVIEW_NAME, QUERY FROM USER_MVIEWS AND (UPPER(MVIEW_NAME) LIKE 'EUCNTRY\_%' ESCAPE '\' OR (upper(MVIEW_NAME) IN (SELECT upper(name1) FROM AD_EXCEPTIONS WHERE AD_MODULE_ID='19BF10F39699483AA7F095501B8E2679'))), Error Msg = ORA-00933: comando SQL no terminado correctamente at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:513) ... 53 more