Unable to reset a failed connector in 6.2

Submitted by vikkedia on Mon, 02/01/2016 - 12:35
1
0
-1

I am using 6.2.6 and am trying to reset a failed connector so I can rerun the failed job with replay using different parameter values.

I am using some of the sample code given in the documentation, but am unable to get it running.

        final SearchOptions searchOptions = new SearchOptionsBuilder(0, 1).filter(ConnectorInstancesSearchDescriptor.CONTAINER_ID, job.getJobDescriptorId())
                .filter(ConnectorInstancesSearchDescriptor.STATE, ConnectorState.FAILED).done();
        final SearchResult<ConnectorInstance> searchResult = api.searchConnectorInstances(searchOptions);
        final ConnectorInstance connectorInstance = searchResult.getResult().get(0);

Even though I am setting the FAILED as a value, it is still resulting in the error:

Exception in thread "main" org.bonitasoft.engine.exception.RetrieveException: org.bonitasoft.engine.persistence.SBonitaSearchException: org.bonitasoft.engine.persistence.SBonitaReadException: org.hibernate.exception.SQLGrammarException: could not execute query
at org.bonitasoft.engine.api.impl.ProcessAPIImpl.searchConnectorInstances(ProcessAPIImpl.java:5204)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:294)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.access$000(ServerAPIImpl.java:65)
at org.bonitasoft.engine.api.impl.ServerAPIImpl$1.call(ServerAPIImpl.java:263)
at org.bonitasoft.engine.transaction.JTATransactionServiceImpl.executeInTransaction(JTATransactionServiceImpl.java:257)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPIInTransaction(ServerAPIImpl.java:270)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:221)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:107)
at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:88)
at com.sun.proxy.$Proxy14.searchConnectorInstances(Unknown Source)
at org.bonitasoft.example.App.main(App.java:158)
Caused by: org.bonitasoft.engine.persistence.SBonitaSearchException: org.bonitasoft.engine.persistence.SBonitaReadException: org.hibernate.exception.SQLGrammarException: could not execute query
at org.bonitasoft.engine.core.connector.impl.ConnectorInstanceServiceImpl.getNumberOfConnectorInstances(ConnectorInstanceServiceImpl.java:318)
at org.bonitasoft.engine.search.connector.SearchConnectorInstances.executeCount(SearchConnectorInstances.java:41)
at org.bonitasoft.engine.search.AbstractSearchEntity.execute(AbstractSearchEntity.java:93)
at org.bonitasoft.engine.api.impl.ProcessAPIImpl.searchConnectorInstances(ProcessAPIImpl.java:5202)
... 14 more
Caused by: org.bonitasoft.engine.persistence.SBonitaReadException: org.hibernate.exception.SQLGrammarException: could not execute query
at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.selectList(AbstractHibernatePersistenceService.java:735)
at org.bonitasoft.engine.persistence.AbstractDBPersistenceService.getNumberOfEntities(AbstractDBPersistenceService.java:219)
at org.bonitasoft.engine.persistence.AbstractDBPersistenceService.getNumberOfEntities(AbstractDBPersistenceService.java:204)
at org.bonitasoft.engine.core.connector.impl.ConnectorInstanceServiceImpl.getNumberOfConnectorInstances(ConnectorInstanceServiceImpl.java:316)
... 17 more
Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.loader.Loader.doList(Loader.java:2545)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
at org.hibernate.loader.Loader.list(Loader.java:2271)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:459)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:365)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.selectList(AbstractHibernatePersistenceService.java:723)
... 20 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'FAILED' in 'where clause'
at com.mysql.jdbc.Util.handleNewInstance(Util.java:389)
at com.mysql.jdbc.Util.getInstance(Util.java:372)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:980)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3835)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3771)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2535)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1911)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2034)
at com.mysql.jdbc.jdbc2.optional.PreparedStatementWrapper.executeQuery(PreparedStatementWrapper.java:702)
at bitronix.tm.resource.jdbc.BaseProxyHandlerClass.invoke(BaseProxyHandlerClass.java:64)
at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.selectList(AbstractHibernatePersistenceService.java:723)
at org.bonitasoft.engine.persistence.AbstractDBPersistenceService.getNumberOfEntities(AbstractDBPersistenceService.java:219)
at org.bonitasoft.engine.persistence.AbstractDBPersistenceService.getNumberOfEntities(AbstractDBPersistenceService.java:204)
at org.bonitasoft.engine.core.connector.impl.ConnectorInstanceServiceImpl.getNumberOfConnectorInstances(ConnectorInstanceServiceImpl.java:316)
at org.bonitasoft.engine.search.connector.SearchConnectorInstances.executeCount(SearchConnectorInstances.java:41)
at org.bonitasoft.engine.search.AbstractSearchEntity.execute(AbstractSearchEntity.java:93)
at org.bonitasoft.engine.api.impl.ProcessAPIImpl.searchConnectorInstances(ProcessAPIImpl.java:5202)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:294)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.access$000(ServerAPIImpl.java:65)
at org.bonitasoft.engine.api.impl.ServerAPIImpl$1.call(ServerAPIImpl.java:263)
at org.bonitasoft.engine.transaction.JTATransactionServiceImpl.executeInTransaction(JTATransactionServiceImpl.java:257)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPIInTransaction(ServerAPIImpl.java:270)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:221)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:107)
at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:88)
... 1 more

I am not sure why FAILED is being referred to a column name when it is a value. How do I work around this?

Thanks,

No answers yet.
Notifications