Thanks, Geeth. It works fine now. BTW, there is some small correction to be made in error description. It should be "Exception @ deletePolicy() function in deleting *entries from* Tables".
Cheers. *Dilan U. Ariyaratne* Software Engineer WSO2 Inc. <http://wso2.com/> Mobile: +94775149066 lean . enterprise . middleware On Tue, May 26, 2015 at 1:35 PM, Geeth Munasinghe <ge...@wso2.com> wrote: > Hi Dilan, > > This is fixed now. > > Thanks > Geeth > > > *G. K. S. Munasinghe* > *Senior Software Engineer,* > *WSO2, Inc. http://wso2.com <http://wso2.com/> * > *lean.enterprise.middleware.* > > email: ge...@wso2.com > phone:(+94) 777911226 > > On Tue, May 26, 2015 at 4:04 AM, Geeth Munasinghe <ge...@wso2.com> wrote: > >> Hi Dilan, >> >> I will fix this. >> >> Thanks >> Geeth >> >> >> *G. K. S. Munasinghe* >> *Senior Software Engineer,* >> *WSO2, Inc. http://wso2.com <http://wso2.com/> * >> *lean.enterprise.middleware.* >> >> email: ge...@wso2.com >> phone:(+94) 777911226 >> >> On Tue, May 26, 2015 at 3:17 AM, Dilan Udara Ariyaratne <dil...@wso2.com> >> wrote: >> >>> Hi Guys, >>> >>> I am getting following exception in trying to delete a policy from MDM >>> UI. >>> It seems that several tables referenced at the function, including the >>> following (DM_LOCATION) do not really exist in the DB. >>> >>> Caused by: org.h2.jdbc.JdbcSQLException: Table "DM_LOCATION" not found; >>> SQL statement: >>> DELETE FROM DM_LOCATION WHERE POLICY_ID = ? [42102-140] >>> at >>> org.h2.message.DbException.getJdbcSQLException(DbException.java:327) >>> at org.h2.message.DbException.get(DbException.java:167) >>> at org.h2.message.DbException.get(DbException.java:144) >>> at org.h2.command.Parser.readTableOrView(Parser.java:4498) >>> at org.h2.command.Parser.readTableOrView(Parser.java:4478) >>> at org.h2.command.Parser.readSimpleTableFilter(Parser.java:683) >>> at org.h2.command.Parser.parseDelete(Parser.java:701) >>> at org.h2.command.Parser.parsePrepared(Parser.java:323) >>> at org.h2.command.Parser.parse(Parser.java:275) >>> at org.h2.command.Parser.parse(Parser.java:247) >>> at org.h2.command.Parser.prepare(Parser.java:201) >>> at org.h2.command.Parser.prepareCommand(Parser.java:214) >>> at org.h2.engine.Session.prepareLocal(Session.java:434) >>> at org.h2.engine.Session.prepareCommand(Session.java:384) >>> at >>> org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1071) >>> at >>> org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:71) >>> at >>> org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:234) >>> at sun.reflect.GeneratedMethodAccessor29.invoke(Unknown Source) >>> at >>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >>> at java.lang.reflect.Method.invoke(Method.java:606) >>> at >>> org.apache.tomcat.jdbc.pool.ProxyConnection.invoke(ProxyConnection.java:126) >>> at >>> org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109) >>> at >>> org.wso2.carbon.ndatasource.rdbms.ConnectionRollbackOnReturnInterceptor.invoke(ConnectionRollbackOnReturnInterceptor.java:51) >>> at >>> org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109) >>> at >>> org.apache.tomcat.jdbc.pool.interceptor.AbstractCreateStatementInterceptor.invoke(AbstractCreateStatementInterceptor.java:67) >>> at >>> org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109) >>> at >>> org.apache.tomcat.jdbc.pool.interceptor.ConnectionState.invoke(ConnectionState.java:153) >>> at >>> org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109) >>> at >>> org.apache.tomcat.jdbc.pool.TrapException.invoke(TrapException.java:41) >>> at >>> org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109) >>> at >>> org.apache.tomcat.jdbc.pool.DisposableConnectionFacade.invoke(DisposableConnectionFacade.java:80) >>> at com.sun.proxy.$Proxy13.prepareStatement(Unknown Source) >>> at >>> org.wso2.carbon.policy.mgt.core.dao.impl.PolicyDAOImpl.deleteAllPolicyRelatedConfigs(PolicyDAOImpl.java:1185) >>> ... 61 more >>> >>> - - - - - - - - - - - - - - - - - - - - - - - - - >>> >>> Cheers. >>> >>> *Dilan U. Ariyaratne* >>> Software Engineer >>> WSO2 Inc. <http://wso2.com/> >>> Mobile: +94775149066 >>> lean . enterprise . middleware >>> >> >> >
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
