Hi Gorka, It seems that the change related to this issue is the cause of the failure in Oracle. https://code.openbravo.com/erp/devel/pi/rev/8bc60787fdd0#l1.8
It seems that piece of code is the one failing. I'll check and fix it. Regards, Iván On Mon, Aug 29, 2011 at 5:34 PM, Gorka Gil <gorka....@openbravo.com> wrote: > Hi, > > Asier, Jon, Ivan, > > Could you please take a look to this build fail, > It don't show the login page in oracle and shows this page [1] > > Regards, > Gorka > > [1] > > HTTP Status 500 - > > type Exception report > > message > > description The server encountered an internal error () that prevented > it from fulfilling this request. > > exception > > org.openbravo.base.exception.OBException: Exception thrown could not > execute query > org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:63) > > org.openbravo.dal.core.DalRequestFilter.doFilter(DalRequestFilter.java:103) > root cause > > org.hibernate.exception.SQLGrammarException: could not execute query > > org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92) > > org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) > org.hibernate.loader.Loader.doList(Loader.java:2536) > org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276) > org.hibernate.loader.Loader.list(Loader.java:2271) > > org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:119) > org.hibernate.impl.SessionImpl.list(SessionImpl.java:1716) > org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:347) > org.openbravo.dal.service.OBCriteria.list(OBCriteria.java:89) > org.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:369) > org.openbravo.dal.service.OBCriteria.uniqueResult(OBCriteria.java:128) > org.openbravo.dal.service.OBCriteria.count(OBCriteria.java:102) > org.openbravo.erpCommon.security.Login.printPageLogin30(Login.java:263) > org.openbravo.erpCommon.security.Login.doPost(Login.java:75) > org.openbravo.base.HttpBaseServlet.doGet(HttpBaseServlet.java:287) > javax.servlet.http.HttpServlet.service(HttpServlet.java:617) > org.openbravo.base.HttpBaseServlet.service(HttpBaseServlet.java:245) > javax.servlet.http.HttpServlet.service(HttpServlet.java:717) > > org.openbravo.utils.SessionExpirationFilter.doFilter(SessionExpirationFilter.java:66) > org.openbravo.utils.CharsetFilter.doFilter(CharsetFilter.java:35) > > org.openbravo.dal.core.DalRequestFilter$1.doAction(DalRequestFilter.java:81) > org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:46) > > org.openbravo.dal.core.DalRequestFilter.doFilter(DalRequestFilter.java:103) > root cause > > java.sql.SQLSyntaxErrorException: ORA-00932: inconsistent datatypes: > expected - got CLOB > > oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440) > oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) > oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837) > oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445) > oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191) > oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523) > > oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207) > > oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:863) > > oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1153) > > oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1275) > > oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576) > > oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3620) > > oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491) > > org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208) > org.hibernate.loader.Loader.getResultSet(Loader.java:1953) > org.hibernate.loader.Loader.doQuery(Loader.java:802) > > org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274) > org.hibernate.loader.Loader.doList(Loader.java:2533) > org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276) > org.hibernate.loader.Loader.list(Loader.java:2271) > > org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:119) > org.hibernate.impl.SessionImpl.list(SessionImpl.java:1716) > org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:347) > org.openbravo.dal.service.OBCriteria.list(OBCriteria.java:89) > org.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:369) > org.openbravo.dal.service.OBCriteria.uniqueResult(OBCriteria.java:128) > org.openbravo.dal.service.OBCriteria.count(OBCriteria.java:102) > org.openbravo.erpCommon.security.Login.printPageLogin30(Login.java:263) > org.openbravo.erpCommon.security.Login.doPost(Login.java:75) > org.openbravo.base.HttpBaseServlet.doGet(HttpBaseServlet.java:287) > javax.servlet.http.HttpServlet.service(HttpServlet.java:617) > org.openbravo.base.HttpBaseServlet.service(HttpBaseServlet.java:245) > javax.servlet.http.HttpServlet.service(HttpServlet.java:717) > > org.openbravo.utils.SessionExpirationFilter.doFilter(SessionExpirationFilter.java:66) > org.openbravo.utils.CharsetFilter.doFilter(CharsetFilter.java:35) > > org.openbravo.dal.core.DalRequestFilter$1.doAction(DalRequestFilter.java:81) > org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:46) > > org.openbravo.dal.core.DalRequestFilter.doFilter(DalRequestFilter.java:103) > note The full stack trace of the root cause is available in the Apache > Tomcat/6.0.26 logs. > > Apache Tomcat/6.0.26 > > > > > > On Mon, Aug 29, 2011 at 13:57, <jenk...@builds.openbravo.com> wrote: >> int-gui-oracle - Build # 255 - Failure: >> >> Check console output at http://builds.openbravo.com/job/int-gui-oracle/255/ >> to view the results. >> >> >> Committers since last success: >> >> Changes for Build #255 >> >> Iván Perdomo <ivan.perd...@openbravo.com> >> Fixes issue 18297: Changed the logic to display button >> - Show the button always unless the preference is set to N. This avoids the >> need to add a new preference by default >> src/org/openbravo/erpCommon/security/Login.java >> >> Asier Lostalé <asier.lost...@openbravo.com> >> Support for httpclient multipart requests >> >> modules/org.openbravo.service.integration.openid/lib/runtime/httpmime-4.1.jar >> >> Iván Perdomo <ivan.perd...@openbravo.com> >> Fixes issue 18297: Added new Preference to disable G button >> - Activated instances have the posibility to disable the G button in the >> login >> page >> src/org/openbravo/erpCommon/security/Login.java >> >> Iván Perdomo <ivan.perd...@openbravo.com> >> Issue 18297: Added new preference property >> >> modules/org.openbravo.service.integration.google/src-db/database/sourcedata/AD_REF_LIST.xml >> >> Jon Alegría <jon.aleg...@openbravo.com> >> Fixes issue 0018346: Is not possible to apply Discount=10% at sales order >> line >> as discount field is recalculated >> src/org/openbravo/erpCommon/ad_callouts/SL_Order_Amt.java >> src/org/openbravo/erpCommon/ad_callouts/SL_Order_Amt_data.xsql >> >> RM packaging bot <staff...@openbravo.com> >> CI: merge back from main >> >> RM packaging bot <staff...@openbravo.com> >> CI: update AD_MODULE to version 13603 >> >> modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_MODULE.xml >> >> modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml >> >> modules/org.openbravo.base.weld/src-db/database/sourcedata/AD_MODULE.xml >> >> modules/org.openbravo.base.weld/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml >> >> modules/org.openbravo.client.application/src-db/database/sourcedata/AD_MODULE.xml >> >> modules/org.openbravo.client.application/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml >> >> modules/org.openbravo.client.htmlwidget/src-db/database/sourcedata/AD_MODULE.xml >> >> modules/org.openbravo.client.htmlwidget/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml >> >> modules/org.openbravo.client.kernel/src-db/database/sourcedata/AD_MODULE.xml >> >> modules/org.openbravo.client.kernel/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml >> >> modules/org.openbravo.client.myob/src-db/database/sourcedata/AD_MODULE.xml >> >> modules/org.openbravo.client.myob/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml >> >> modules/org.openbravo.client.querylist/src-db/database/sourcedata/AD_MODULE.xml >> >> modules/org.openbravo.client.querylist/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml >> >> modules/org.openbravo.client.widgets/src-db/database/sourcedata/AD_MODULE.xml >> >> modules/org.openbravo.client.widgets/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml >> >> modules/org.openbravo.financial.paymentreport/src-db/database/sourcedata/AD_MODULE.xml >> >> modules/org.openbravo.financial.paymentreport/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml >> >> modules/org.openbravo.reports.ordersawaitingdelivery/src-db/database/sourcedata/AD_MODULE.xml >> >> modules/org.openbravo.reports.ordersawaitingdelivery/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml >> >> modules/org.openbravo.service.datasource/src-db/database/sourcedata/AD_MODULE.xml >> >> modules/org.openbravo.service.datasource/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml >> >> modules/org.openbravo.service.integration.google/src-db/database/sourcedata/AD_MODULE.xml >> >> modules/org.openbravo.service.integration.google/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml >> >> modules/org.openbravo.service.integration.openid/src-db/database/sourcedata/AD_MODULE.xml >> >> modules/org.openbravo.service.integration.openid/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml >> >> modules/org.openbravo.service.json/src-db/database/sourcedata/AD_MODULE.xml >> >> modules/org.openbravo.service.json/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml >> >> modules/org.openbravo.userinterface.selector/src-db/database/sourcedata/AD_MODULE.xml >> >> modules/org.openbravo.userinterface.selector/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml >> >> modules/org.openbravo.userinterface.skin.250to300Comp/src-db/database/sourcedata/AD_MODULE.xml >> >> modules/org.openbravo.userinterface.skin.250to300Comp/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml >> >> modules/org.openbravo.userinterface.smartclient/src-db/database/sourcedata/AD_MODULE.xml >> >> modules/org.openbravo.userinterface.smartclient/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml >> >> modules/org.openbravo.v3.datasets/src-db/database/sourcedata/AD_MODULE.xml >> >> modules/org.openbravo.v3.datasets/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml >> >> modules/org.openbravo.v3.framework/src-db/database/sourcedata/AD_MODULE.xml >> >> modules/org.openbravo.v3.framework/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml >> modules/org.openbravo.v3/src-db/database/sourcedata/AD_MODULE.xml >> >> modules/org.openbravo.v3/src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml >> src-db/database/sourcedata/AD_MODULE.xml >> >> >> >> >> Last 20 lines of the console output: >> >> [...truncated 141 lines...] >> [junit] 123845 [main] DEBUG com.openbravo.test.integration.selenium.Sleep >> - Sleep for 1000 milliseconds >> [junit] 125009 [main] INFO >> com.openbravo.test.integration.erp.testscripts.OpenbravoERPTest - Save the >> screenshot. >> [junit] Build info: version: 'unknown', revision: 'unknown', time: >> 'unknown' >> [junit] System info: os.name: 'Linux', os.arch: 'amd64', os.version: >> '2.6.32-305-ec2', java.version: '1.6.0_20' >> [junit] Driver info: driver.version: unknown) >> [junit] >> >> BUILD FAILED >> /srv/hudson/workspace/int-gui-oracle/SANDBOX/automation/pi/src-test/com/openbravo/test/integration/erp/testsuites/guiunit/build.xml:26: >> The following error occurred while executing this line: >> /srv/hudson/workspace/int-gui-oracle/SANDBOX/automation/pi/src-test/com/openbravo/test/integration/erp/testsuites/guiunit/build.xml:32: >> The following error occurred while executing this line: >> /srv/hudson/workspace/int-gui-oracle/SANDBOX/automation/pi/build.xml:69: >> Test com.openbravo.test.integration.erp.testsuites.guiunit.LoginSuccess >> failed >> >> Total time: 2 minutes 25 seconds >> Build step 'Execute shell' marked build as failure >> [locks-and-latches] Releasing all the locks >> [locks-and-latches] All the locks released >> Recording test results >> Email was triggered for: Failure >> Sending email for trigger: Failure >> >> > -- Iván Perdomo ------------------------------------------------------------------------------ EMC VNX: the world's simplest storage, starting under $10K The only unified storage solution that offers unified management Up to 160% more powerful than alternatives and 25% more efficient. Guaranteed. http://p.sf.net/sfu/emc-vnx-dev2dev _______________________________________________ Openbravo-builds mailing list Openbravo-builds@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/openbravo-builds
