Poi error in Bonita 7.x.x

1
0
-1

Hello, this is my first question in bonitasoft community forum, and... I dont speak english very well so I must apologise for that...
Well the question is I'm currently using bonita 6.5.3 with very good results, but with the new vertion released i'm triying to upgrade to bonita 7.x.x.
My first step was import the actual process (6.5.3) to the design enviroment and try to run the process but i'm getting stuck in an assignment that return a java.util.list as the result of reading an excel document.

The code is the next:

import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.ss.usermodel.DateUtil

String nombre_file = "erSel.xlsx";
List Tabla = new ArrayList();
List Fila = new ArrayList();

File temporal = new File(nombre_file);  //se crea un puntero file temporal
FileOutputStream data_out= new FileOutputStream(temporal); //se crea un puntero para escribir en el archivo creado
data_out.write(doc_a_cargar.getContent()); //se carga con el puntero outputstream el contenido obtenido desde el archivo en el form de bonita
data_out.close(); //se cierra el puntero de escritura para liberar el archivo y dejar disponible su lectura

InputStream ExcelFileToRead = new FileInputStream(nombre_file); // Se carga el puntero de lectura con el archivo recientemente creado
XSSFWorkbook wb =  new XSSFWorkbook(ExcelFileToRead); // Se carga el libro excel desde el puntero de lectura

XSSFSheet sheet = wb.getSheetAt(0); // Se carga la primera pagina del libro apuntado
XSSFRow row;
XSSFCell cell;
int noOfRows = sheet.getLastRowNum();
int noOfCols = 0;
int i, j;
Iterator it_fila = sheet.rowIterator();
if (it_fila.hasNext())
{
        row = (XSSFRow) it_fila.next();
        //get the number of cells in the header row
        noOfCols = row.getPhysicalNumberOfCells();
}
for (i = 0; i <= noOfRows; i++){
        for (j = 0; j < noOfCols; j++){
                if(sheet.getRow(i).getCell(j) != null){
                        if (sheet.getRow(i).getCell(j).getCellType() == XSSFCell.CELL_TYPE_STRING){
                                Fila.add(sheet.getRow(i).getCell(j).getStringCellValue());
                        }
                        else if(sheet.getRow(i).getCell(j).getCellType() == XSSFCell.CELL_TYPE_NUMERIC){
                                if(DateUtil.isCellDateFormatted(sheet.getRow(i).getCell(j))){
                                        Fila.add(sheet.getRow(i).getCell(j).getDateCellValue().format("dd/MM/YYYY"));
                                }
                                else {
                                        Fila.add((int) sheet.getRow(i).getCell(j).getNumericCellValue());
                                }
                        }
                        else{
                                Fila.add("");
                        }      
                }
                else{
                        Fila.add("");
                }      
        }
        Tabla.add(Fila)
        Fila = new ArrayList();
}
return Tabla

I'ts a very simple code but helps me a lot loading data from excel documents and works very fine in the 6.x.x versions, this is the engine log:

2016-08-11 13:28:01.711 -0400 INFORMACIÓN: org.bonitasoft.connectors.database.jdbc.JdbcConnector outputType null
2016-08-11 13:28:16.017 -0400 GRAVE: org.bonitasoft.console.common.server.utils.BPMEngineAPIUtil A error occured while executing the command.
org.bonitasoft.engine.command.CommandExecutionException: USERNAME=dquiroga | org.bonitasoft.engine.command.SCommandExecutionException: Error executing command 'Map<String, Serializable> ExecuteActionsAndTerminateTask(List, Map<String, Serializable>, long activityInstanceId)'
at org.bonitasoft.engine.api.impl.CommandAPIImpl.executeCommand(CommandAPIImpl.java:197)
at org.bonitasoft.engine.api.impl.CommandAPIImpl.execute(CommandAPIImpl.java:167)
at org.bonitasoft.engine.api.impl.CommandAPIImpl.execute(CommandAPIImpl.java:156)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:462)
at org.bonitasoft.engine.api.impl.ServerAPIImpl$2.call(ServerAPIImpl.java:431)
at org.bonitasoft.engine.transaction.JTATransactionServiceImpl.executeInTransaction(JTATransactionServiceImpl.java:312)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPIInTransaction(ServerAPIImpl.java:438)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:272)
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:124)
at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:86)
at com.sun.proxy.$Proxy100.execute(Unknown Source)
at org.bonitasoft.console.common.server.utils.BPMEngineAPIUtil.executeCommand(BPMEngineAPIUtil.java:186)
at org.bonitasoft.forms.server.api.impl.FormWorkflowAPIImpl.executeActionsAndTerminate(FormWorkflowAPIImpl.java:409)
at org.bonitasoft.forms.server.provider.impl.FormServiceProviderImpl.executeActions(FormServiceProviderImpl.java:991)
at org.bonitasoft.forms.server.FormsServlet.executeActions(FormsServlet.java:814)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:561)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:208)
at org.bonitasoft.forms.server.FormsServlet.processCall(FormsServlet.java:123)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:248)
at com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:176)
at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145)
at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92)
at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:394)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.bonitasoft.console.common.server.login.filter.AuthenticationFilter.doFilter(AuthenticationFilter.java:115)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.bonitasoft.console.common.server.login.filter.NoCacheFilter.doFilter(NoCacheFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.bonitasoft.console.security.SessionFixationValve.invoke(SessionFixationValve.java:77)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:423)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1079)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Unknown Source)
Caused by: org.bonitasoft.engine.command.SCommandExecutionException: Error executing command 'Map<String, Serializable> ExecuteActionsAndTerminateTask(List, Map<String, Serializable>, long activityInstanceId)'
at org.bonitasoft.engine.external.web.forms.ExecuteActionsAndTerminateTask.execute(ExecuteActionsAndTerminateTask.java:85)
at org.bonitasoft.engine.external.web.forms.ExecuteActionsAndTerminateTask.execute(ExecuteActionsAndTerminateTask.java:55)
at org.bonitasoft.engine.api.impl.CommandAPIImpl.executeCommand(CommandAPIImpl.java:195)
... 61 more
Caused by: org.bonitasoft.engine.core.operation.exception.SOperationExecutionException: org.bonitasoft.engine.expression.exception.SExpressionEvaluationException: Groovy script throws an exception of type class java.lang.NoClassDefFoundError with message = org/openxmlformats/schemas/spreadsheetml/x2006/main/CTExtensionList
Expression : SExpressionImpl [name=n/a:info_scv, content=import org.apache.poi.xssf.usermodel.XSSFWorkbook;

import org.apache.poi.xssf.usermodel.XSSFSheet;

import org.apache.poi.xssf.usermodel.XSSFRow;

import org.apache.poi.xssf.usermodel.XSSFCell;

import org.apache.poi.ss.usermodel.DateUtil

String nombre_file = "erSel.xlsx";

List Tabla = new ArrayList();

List Fila = new ArrayList();

File temporal = new File(nombre_file); //se crea un puntero file temporal

FileOutputStream data_out= new FileOutputStream(temporal); //se crea un puntero para escribir en el archivo creado

data_out.write(doc_a_cargar.getContent()); //se carga con el puntero outputstream el contenido obtenido desde el archivo en el form de bonita

data_out.close(); //se cierra el puntero de escritura para liberar el archivo y dejar disponible su lectura

InputStream ExcelFileToRead = new FileInputStream(nombre_file); // Se carga el puntero de lectura con el archivo recientemente creado

XSSFWorkbook wb = new XSSFWorkbook(ExcelFileToRead); // Se carga el libro excel desde el puntero de lectura

//XSSFWorkbook test = new XSSFWorkbook(); //

XSSFSheet sheet = wb.getSheetAt(0); // Se carga la primera pagina del libro apuntado

XSSFRow row;

XSSFCell cell;

int noOfRows = sheet.getLastRowNum();

int noOfCols = 0;

int i, j;

Iterator it_fila = sheet.rowIterator();

if (it_fila.hasNext())

{

row = (XSSFRow) it_fila.next();

//get the number of cells in the header row

noOfCols = row.getPhysicalNumberOfCells();

}

for (i = 0; i <= noOfRows; i++){

for (j = 0; j < noOfCols; j++){



    if(sheet.getRow(i).getCell(j) != null){

        if (sheet.getRow(i).getCell(j).getCellType() == XSSFCell.CELL_TYPE_STRING){

            Fila.add(sheet.getRow(i).getCell(j).getStringCellValue());

        }

        else if(sheet.getRow(i).getCell(j).getCellType() == XSSFCell.CELL_TYPE_NUMERIC){

            if(DateUtil.isCellDateFormatted(sheet.getRow(i).getCell(j))){

                Fila.add(sheet.getRow(i).getCell(j).getDateCellValue().format("dd/MM/YYYY"));

            }

            else {

                Fila.add((int) sheet.getRow(i).getCell(j).getNumericCellValue());

            }

        }

        else{

            Fila.add("");

        }





    }

    else{

        Fila.add("");

    }

/*

    if (sheet.getRow(i).getCell(j).getStringCellValue() == "") {

        Fila.add("");



    } else {

        Fila.add(sheet.getRow(i).getCell(j).getStringCellValue());



    }

*/

}

Tabla.add(Fila)

Fila = new ArrayList();

}

return Tabla, returnType=java.util.List, dependencies=[SExpressionImpl [name=doc_a_cargar, content=doc_a_cargar, returnType=org.bonitasoft.engine.bpm.document.DocumentValue, dependencies=[], expressionKind=ExpressionKind [interpreter=NONE, type=TYPE_VARIABLE]]], expressionKind=ExpressionKind [interpreter=GROOVY, type=TYPE_READ_ONLY_SCRIPT]]
at org.bonitasoft.engine.core.operation.impl.OperationServiceImpl.evaluateRightOperandExpression(OperationServiceImpl.java:199)
at org.bonitasoft.engine.core.operation.impl.OperationServiceImpl.calculateRightOperandValue(OperationServiceImpl.java:120)
at org.bonitasoft.engine.core.operation.impl.OperationServiceImpl.executeOperators(OperationServiceImpl.java:105)
at org.bonitasoft.engine.core.operation.impl.OperationServiceImpl.execute(OperationServiceImpl.java:94)
at org.bonitasoft.engine.external.web.forms.ExecuteActionsAndTerminateTask.updateActivityInstanceVariables(ExecuteActionsAndTerminateTask.java:128)
at org.bonitasoft.engine.external.web.forms.ExecuteActionsAndTerminateTask.execute(ExecuteActionsAndTerminateTask.java:77)
... 63 more
Caused by: org.bonitasoft.engine.expression.exception.SExpressionEvaluationException: Groovy script throws an exception of type class java.lang.NoClassDefFoundError with message = org/openxmlformats/schemas/spreadsheetml/x2006/main/CTExtensionList
Expression : SExpressionImpl [name=n/a:info_scv, content=import org.apache.poi.xssf.usermodel.XSSFWorkbook;

import org.apache.poi.xssf.usermodel.XSSFSheet;

import org.apache.poi.xssf.usermodel.XSSFRow;

import org.apache.poi.xssf.usermodel.XSSFCell;

import org.apache.poi.ss.usermodel.DateUtil

String nombre_file = "erSel.xlsx";

List Tabla = new ArrayList();

List Fila = new ArrayList();

File temporal = new File(nombre_file); //se crea un puntero file temporal

FileOutputStream data_out= new FileOutputStream(temporal); //se crea un puntero para escribir en el archivo creado

data_out.write(doc_a_cargar.getContent()); //se carga con el puntero outputstream el contenido obtenido desde el archivo en el form de bonita

data_out.close(); //se cierra el puntero de escritura para liberar el archivo y dejar disponible su lectura

InputStream ExcelFileToRead = new FileInputStream(nombre_file); // Se carga el puntero de lectura con el archivo recientemente creado

XSSFWorkbook wb = new XSSFWorkbook(ExcelFileToRead); // Se carga el libro excel desde el puntero de lectura

//XSSFWorkbook test = new XSSFWorkbook(); //

XSSFSheet sheet = wb.getSheetAt(0); // Se carga la primera pagina del libro apuntado

XSSFRow row;

XSSFCell cell;

int noOfRows = sheet.getLastRowNum();

int noOfCols = 0;

int i, j;

Iterator it_fila = sheet.rowIterator();

if (it_fila.hasNext())

{

row = (XSSFRow) it_fila.next();

//get the number of cells in the header row

noOfCols = row.getPhysicalNumberOfCells();

}

for (i = 0; i <= noOfRows; i++){

for (j = 0; j < noOfCols; j++){



    if(sheet.getRow(i).getCell(j) != null){

        if (sheet.getRow(i).getCell(j).getCellType() == XSSFCell.CELL_TYPE_STRING){

            Fila.add(sheet.getRow(i).getCell(j).getStringCellValue());

        }

        else if(sheet.getRow(i).getCell(j).getCellType() == XSSFCell.CELL_TYPE_NUMERIC){

            if(DateUtil.isCellDateFormatted(sheet.getRow(i).getCell(j))){

                Fila.add(sheet.getRow(i).getCell(j).getDateCellValue().format("dd/MM/YYYY"));

            }

            else {

                Fila.add((int) sheet.getRow(i).getCell(j).getNumericCellValue());

            }

        }

        else{

            Fila.add("");

        }





    }

    else{

        Fila.add("");

    }

/*

    if (sheet.getRow(i).getCell(j).getStringCellValue() == "") {

        Fila.add("");



    } else {

        Fila.add(sheet.getRow(i).getCell(j).getStringCellValue());



    }

*/

}

Tabla.add(Fila)

Fila = new ArrayList();

}

return Tabla, returnType=java.util.List, dependencies=[SExpressionImpl [name=doc_a_cargar, content=doc_a_cargar, returnType=org.bonitasoft.engine.bpm.document.DocumentValue, dependencies=[], expressionKind=ExpressionKind [interpreter=NONE, type=TYPE_VARIABLE]]], expressionKind=ExpressionKind [interpreter=GROOVY, type=TYPE_READ_ONLY_SCRIPT]]
at org.bonitasoft.engine.expression.impl.GroovyScriptExpressionExecutorCacheStrategy.evaluate(GroovyScriptExpressionExecutorCacheStrategy.java:159)
at org.bonitasoft.engine.expression.impl.ExpressionServiceImpl.evaluate(ExpressionServiceImpl.java:86)
at org.bonitasoft.engine.core.expression.control.api.impl.ExpressionResolverServiceImpl.evaluateExpressionWithResolvedDependencies(ExpressionResolverServiceImpl.java:213)
at org.bonitasoft.engine.core.expression.control.api.impl.ExpressionResolverServiceImpl.evaluateExpressionsFlatten(ExpressionResolverServiceImpl.java:120)
at org.bonitasoft.engine.core.expression.control.api.impl.ExpressionResolverServiceImpl.evaluate(ExpressionResolverServiceImpl.java:83)
at org.bonitasoft.engine.core.operation.impl.OperationServiceImpl.evaluateRightOperandExpression(OperationServiceImpl.java:194)
... 68 more
Caused by: java.lang.NoClassDefFoundError: org/openxmlformats/schemas/spreadsheetml/x2006/main/CTExtensionList
at java.lang.Class.getDeclaredMethods0(Native Method)
at java.lang.Class.privateGetDeclaredMethods(Unknown Source)
at java.lang.Class.privateGetPublicMethods(Unknown Source)
at java.lang.Class.getMethods(Unknown Source)
at org.codehaus.groovy.reflection.stdclasses.CachedSAMClass.getSAMMethod(CachedSAMClass.java:164)
at org.codehaus.groovy.reflection.ClassInfo.isSAM(ClassInfo.java:359)
at org.codehaus.groovy.reflection.ClassInfo.createCachedClass(ClassInfo.java:349)
at org.codehaus.groovy.reflection.ClassInfo.access$700(ClassInfo.java:41)
at org.codehaus.groovy.reflection.ClassInfo$LazyCachedClassRef.initValue(ClassInfo.java:497)
at org.codehaus.groovy.reflection.ClassInfo$LazyCachedClassRef.initValue(ClassInfo.java:488)
at org.codehaus.groovy.util.LazyReference.getLocked(LazyReference.java:49)
at org.codehaus.groovy.util.LazyReference.get(LazyReference.java:36)
at org.codehaus.groovy.reflection.ClassInfo.getCachedClass(ClassInfo.java:111)
at org.codehaus.groovy.reflection.ReflectionCache.getCachedClass(ReflectionCache.java:110)
at org.codehaus.groovy.reflection.ParameterTypes.getParametersTypes0(ParameterTypes.java:81)
at org.codehaus.groovy.reflection.ParameterTypes.getParameterTypes(ParameterTypes.java:67)
at org.codehaus.groovy.reflection.CachedMethod.compareToMethod(CachedMethod.java:186)
at org.codehaus.groovy.reflection.CachedMethod.compareTo(CachedMethod.java:142)
at org.codehaus.groovy.reflection.CachedMethod$MyComparator.compare(CachedMethod.java:315)
at java.util.Arrays.binarySearch0(Unknown Source)
at java.util.Arrays.binarySearch(Unknown Source)
at org.codehaus.groovy.reflection.CachedMethod.find(CachedMethod.java:68)
at groovy.lang.MetaClassImpl.applyPropertyDescriptors(MetaClassImpl.java:2522)
at groovy.lang.MetaClassImpl.setupProperties(MetaClassImpl.java:2261)
at groovy.lang.MetaClassImpl.addProperties(MetaClassImpl.java:3302)
at groovy.lang.MetaClassImpl.initialize(MetaClassImpl.java:3266)
at org.codehaus.groovy.reflection.ClassInfo.getMetaClassUnderLock(ClassInfo.java:254)
at org.codehaus.groovy.reflection.ClassInfo.getMetaClass(ClassInfo.java:285)
at org.codehaus.groovy.reflection.ClassInfo.getMetaClass(ClassInfo.java:295)
at org.codehaus.groovy.runtime.metaclass.MetaClassRegistryImpl.getMetaClass(MetaClassRegistryImpl.java:261)
at org.codehaus.groovy.runtime.InvokerHelper.getMetaClass(InvokerHelper.java:871)
at org.codehaus.groovy.runtime.callsite.CallSiteArray.createPojoSite(CallSiteArray.java:125)
at org.codehaus.groovy.runtime.callsite.CallSiteArray.createCallSite(CallSiteArray.java:166)
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:48)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:113)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:117)
at BScript25.run(BScript25.groovy:87)
at org.bonitasoft.engine.expression.impl.GroovyScriptExpressionExecutorCacheStrategy.evaluate(GroovyScriptExpressionExecutorCacheStrategy.java:141)
... 73 more
Caused by: java.lang.ClassNotFoundException: org.openxmlformats.schemas.spreadsheetml.x2006.main.CTExtensionList
at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1856)
at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1705)
at org.bonitasoft.engine.classloader.VirtualClassLoader.loadClass(VirtualClassLoader.java:88)
at org.bonitasoft.engine.classloader.BonitaClassLoader.loadClass(BonitaClassLoader.java:169)
at org.bonitasoft.engine.classloader.VirtualClassLoader.loadClass(VirtualClassLoader.java:86)
at org.bonitasoft.engine.classloader.BonitaClassLoader.loadClass(BonitaClassLoader.java:169)
at java.lang.ClassLoader.loadClass(Unknown Source)
... 111 more

2016-08-11 13:28:16.027 -0400 GRAVE: org.bonitasoft.forms.server.provider.impl.FormServiceProviderImpl Username Form Submitted Fields tmp_8931302659876354190.xlsx ; Tabla1 (java.util.Collection) => [] ; TextField1 (java.lang.String) => Denisse Quiroga ; Texto1 (java.lang.String) => Valparaiso ; > Task Error while communicating with the engine.
org.bonitasoft.console.common.server.utils.BPMEngineException: A error occured while executing the command.
at org.bonitasoft.console.common.server.utils.BPMEngineAPIUtil.executeCommand(BPMEngineAPIUtil.java:204)
at org.bonitasoft.forms.server.api.impl.FormWorkflowAPIImpl.executeActionsAndTerminate(FormWorkflowAPIImpl.java:409)
at org.bonitasoft.forms.server.provider.impl.FormServiceProviderImpl.executeActions(FormServiceProviderImpl.java:991)
at org.bonitasoft.forms.server.FormsServlet.executeActions(FormsServlet.java:814)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:561)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:208)
at org.bonitasoft.forms.server.FormsServlet.processCall(FormsServlet.java:123)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:248)
at com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:176)
at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145)
at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92)
at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:394)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.bonitasoft.console.common.server.login.filter.AuthenticationFilter.doFilter(AuthenticationFilter.java:115)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.bonitasoft.console.common.server.login.filter.NoCacheFilter.doFilter(NoCacheFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.bonitasoft.console.security.SessionFixationValve.invoke(SessionFixationValve.java:77)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:423)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1079)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Unknown Source)

I didn't found information about this or simply i cant understand the error, but why this process work fine in 6.x.x and cant run in 7.x.x?
any suggestions?

Regards, and thank you all

Comments

Submitted by Sean McP on Fri, 08/12/2016 - 01:17

Hi and welcome....

A small hint here. Don't use the "code" buttons from Bonita (as above) they don't work as you can see,

Start code and log blocks with < code > and end with < /code > removing the spaces and it will format the code and logs correctly/better.

Allows us to read them better...

I'll get to look at this later

regards
Seán

1 answer

1
+1
-1
This one is the BEST answer!

It looks like you're missing something from the prerequisites or /lib folders.

Looking at the missing class CTExtensionList on http://snacktrace.com/search/CTExtensionList/pages/1 shows several requirements for the class.

You should check the jars you've copied from the old environment to the new.

regards
Seán

PS: If this reply answers your question, please mark as resolved.

Comments

Submitted by julian.lopez on Tue, 08/16/2016 - 14:39

Importing this jar "ooxml-schemas-1.1.jar" my process was able to run without problems, i dont know why in the 6.x.x versions was running fine (i never import this file).
I can continue working now, thanks for all Sean

Regards
Julian

(I dont know how to mark this question as resolved)

Submitted by Sean McP on Tue, 08/16/2016 - 21:42

You've done it by ticking the big arrow. Thanks

Submitted by Sean McP on Tue, 08/16/2016 - 21:42

You've done it by ticking the big arrow. Thanks

Notifications