The execution failed in the publication process
Using the material that I indicated created hum Process, Form and realized the All Steps indicated no http://documentation.bonitasoft.com/getting-started-tutorial connection , however When running process appears the following error:
"The execution failed in the publication process Login attempt with the helen.kelly user failed ! Please check that the user exists ..."
Please help! Thanks!
Hello Nathalia,
in your logs I have seen:
Caused by: org.h2.jdbc.JdbcSQLException: Table "PDEPENDENCY" already exists; SQL statement:
Therefore purging the H2 .db as Pierre-yves Monnet has adviced could be a good starting point, as the installation seems to be somewhat broken now ...
But there is an even easier way to proceed. You could do a fresh installation of Bointa in a new folder. Why not download the version 6.5 make a fresh installation of it?
Bointa is a sophisticated product, if something went wrong somehow, just install a fresh version it! You can have several versions of Bointa on your box. You only shall not start them concurrently if you have not manipulated the tomcat-ports - what you probably do not want do at the beginning of the learning curve ...
With best regards,
Andreas
Hum.. could you provide the complete log : there are no error here ! When you use a Studio, you start a Tomcat. You can find the tomcat log via the menu OR directly in the path
Comments
The interger log is here:
2015-03-30 08:46:50 org.bonitasoft.tomcat.H2Listener Informações: Starting H2 server : [-tcp, -tcpPort, 9091, -baseDir, C:\BonitaBPMCommunity-6.4.2\workspace\tomcat/bonita/server/platform/work] 2015-03-30 08:47:50 org.bonitasoft.engine.EngineInitializer Informações: Initializing Bonita Engine... 2015-03-30 08:47:50 org.bonitasoft.engine.EngineInitializer Informações: Initializing Spring context... 2015-03-30 08:47:51 org.bonitasoft.engine.service.impl.AbsoluteFileSystemXmlApplicationContext Informações: Refreshing org.bonitasoft.engine.service.impl.AbsoluteFileSystemXmlApplicationContext@e218e52: startup date [Mon Mar 30 08:47:51 BRT 2015]; root of context hierarchy 2015-03-30 08:47:52 org.bonitasoft.engine.service.impl.AbsoluteFileSystemXmlApplicationContext Informações: Refreshing org.bonitasoft.engine.service.impl.AbsoluteFileSystemXmlApplicationContext@51ba5f4f: startup date [Mon Mar 30 08:47:52 BRT 2015]; parent: org.bonitasoft.engine.service.impl.AbsoluteFileSystemXmlApplicationContext@e218e52 2015-03-30 08:48:32 org.bonitasoft.engine.EngineInitializer Informações: Initializing platform... 2015-03-30 08:48:32 org.bonitasoft.engine.EngineInitializer Informações: Creating platform... 2015-03-30 08:48:34 org.bonitasoft.engine.EngineInitializer Informações: Platform is already initialized. org.bonitasoft.engine.exception.CreationException: Platform Creation failed. at org.bonitasoft.engine.api.impl.PlatformAPIImpl.createPlatform(PlatformAPIImpl.java:173) at org.bonitasoft.engine.api.impl.PlatformAPIImpl.createAndInitializePlatform(PlatformAPIImpl.java:214) at org.bonitasoft.engine.PlatformTenantManager.createPlatform(PlatformTenantManager.java:43) at org.bonitasoft.engine.EngineInitializer.initPlatform(EngineInitializer.java:140) at org.bonitasoft.engine.EngineInitializer.initializeEngine(EngineInitializer.java:93) at org.bonitasoft.engine.api.internal.servlet.EngineInitializerListener.contextInitialized(EngineInitializerListener.java:43) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4992) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5490) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649) at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:672) at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1862) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: org.bonitasoft.engine.platform.exception.SPlatformCreationException: Unable to create platform tables : org.h2.jdbc.JdbcSQLException: Table "PDEPENDENCY" already exists; SQL statement: CREATE TABLE pdependency ( id BIGINT NOT NULL, name VARCHAR(50) NOT NULL UNIQUE, description LONGVARCHAR, filename VARCHAR(255) NOT NULL, value_ LONGVARBINARY NOT NULL, PRIMARY KEY (id) ) [42101-170] at org.h2.message.DbException.getJdbcSQLException(DbException.java:329) at org.h2.message.DbException.get(DbException.java:169) at org.h2.message.DbException.get(DbException.java:146) at org.h2.command.ddl.CreateTable.update(CreateTable.java:108) at org.h2.command.CommandContainer.update(CommandContainer.java:75) at org.h2.command.Command.executeUpdate(Command.java:230) at org.h2.server.TcpServerThread.process(TcpServerThread.java:333) at org.h2.server.TcpServerThread.run(TcpServerThread.java:149) at java.lang.Thread.run(Unknown Source)
at org.bonitasoft.engine.platform.impl.PlatformServiceImpl.createPlatformTables(PlatformServiceImpl.java:164)
at org.bonitasoft.engine.api.impl.PlatformAPIImpl.createPlatform(PlatformAPIImpl.java:156)
... 18 more
Caused by: org.bonitasoft.engine.services.SPersistenceException: org.h2.jdbc.JdbcSQLException: Table "PDEPENDENCY" already exists; SQL statement: CREATE TABLE pdependency ( id BIGINT NOT NULL, name VARCHAR(50) NOT NULL UNIQUE, description LONGVARCHAR, filename VARCHAR(255) NOT NULL, value_ LONGVARBINARY NOT NULL, PRIMARY KEY (id) ) [42101-170] at org.h2.message.DbException.getJdbcSQLException(DbException.java:329) at org.h2.message.DbException.get(DbException.java:169) at org.h2.message.DbException.get(DbException.java:146) at org.h2.command.ddl.CreateTable.update(CreateTable.java:108) at org.h2.command.CommandContainer.update(CommandContainer.java:75) at org.h2.command.Command.executeUpdate(Command.java:230) at org.h2.server.TcpServerThread.process(TcpServerThread.java:333) at org.h2.server.TcpServerThread.run(TcpServerThread.java:149) at java.lang.Thread.run(Unknown Source)
at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.doExecuteSQLThroughJDBC(AbstractHibernatePersistenceService.java:906)
at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.doExecuteSQL(AbstractHibernatePersistenceService.java:860)
at org.bonitasoft.engine.persistence.AbstractDBPersistenceService.executeSQL(AbstractDBPersistenceService.java:251)
at org.bonitasoft.engine.persistence.AbstractDBPersistenceService.createStructure(AbstractDBPersistenceService.java:183)
at org.bonitasoft.engine.platform.impl.PlatformServiceImpl.createPlatformTables(PlatformServiceImpl.java:155)
... 19 more
Caused by: org.h2.jdbc.JdbcSQLException: Table "PDEPENDENCY" already exists; SQL statement: CREATE TABLE pdependency ( id BIGINT NOT NULL, name VARCHAR(50) NOT NULL UNIQUE, description LONGVARCHAR, filename VARCHAR(255) NOT NULL, value_ LONGVARBINARY NOT NULL, PRIMARY KEY (id) ) [42101-170] at org.h2.message.DbException.getJdbcSQLException(DbException.java:329) at org.h2.message.DbException.get(DbException.java:169) at org.h2.message.DbException.get(DbException.java:146) at org.h2.command.ddl.CreateTable.update(CreateTable.java:108) at org.h2.command.CommandContainer.update(CommandContainer.java:75) at org.h2.command.Command.executeUpdate(Command.java:230) at org.h2.server.TcpServerThread.process(TcpServerThread.java:333) at org.h2.server.TcpServerThread.run(TcpServerThread.java:149) at java.lang.Thread.run(Unknown Source)
at org.h2.engine.SessionRemote.done(SessionRemote.java:568)
at org.h2.command.CommandRemote.executeUpdate(CommandRemote.java:181)
at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:177)
at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:152)
at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.doExecuteSQLThroughJDBC(AbstractHibernatePersistenceService.java:893)
... 23 more
2015-03-30 08:48:34 org.bonitasoft.engine.EngineInitializer Informações: Starting platform... 2015-03-30 08:48:34 org.bonitasoft.engine.EngineInitializer Informações: Exception while initializing the engine: org.bonitasoft.engine.platform.PlatformNotFoundException: Can't start or stop platform if it is not created 2015-03-30 08:48:34 org.bonitasoft.engine.api.internal.servlet.EngineInitializerListener Grave: Error while initializing the Engine org.bonitasoft.engine.platform.PlatformNotFoundException: Can't start or stop platform if it is not created at org.bonitasoft.engine.PlatformTenantManager.updatePlatform(PlatformTenantManager.java:51) at org.bonitasoft.engine.PlatformTenantManager.startPlatform(PlatformTenantManager.java:61) at org.bonitasoft.engine.EngineInitializer.startPlatform(EngineInitializer.java:147) at org.bonitasoft.engine.EngineInitializer.initializeEngine(EngineInitializer.java:101) at org.bonitasoft.engine.api.internal.servlet.EngineInitializerListener.contextInitialized(EngineInitializerListener.java:43) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4992) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5490) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649) at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:672) at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1862) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source)
2015-03-30 08:48:35 org.bonitasoft.console.common.server.servlet.PlatformTenantListener Grave: Error while initializing the default tenant org.bonitasoft.engine.platform.NodeNotStartedException: The current node has not been started yet. Method PlatformAPI.startNode() must be called previously. at org.bonitasoft.engine.api.impl.ServerAPIImpl.checkMethodAccessibility(ServerAPIImpl.java:286) at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPIOutsideTransaction(ServerAPIImpl.java:279) at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:272) at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:128) at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:88) at com.sun.proxy.$Proxy7.login(Unknown Source) at org.bonitasoft.console.common.server.servlet.PlatformTenantListener.initializeDefaultTenant(PlatformTenantListener.java:61) at org.bonitasoft.console.common.server.servlet.PlatformTenantListener.contextInitialized(PlatformTenantListener.java:44) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4992) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5490) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649) at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:672) at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1862) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source)
2015-03-30 08:48:36 org.bonitasoft.console.server.listener.StudioWatchdogListener Advertência: Bonita Studio watchdog process has started on 6969 with a delay of 20000ms
Ty....
Hello Nathalia,
in your logs I have seen:
Caused by: org.h2.jdbc.JdbcSQLException: Table "PDEPENDENCY" already exists; SQL statement:
Therefore purging the H2 .db as Pierre-yves Monnet has adviced could be a good starting point, as the installation seems to be somewhat broken now ...
But there is an even easier way to proceed. You could do a fresh installation of Bointa in a new folder. Why not download the version 6.5 make a fresh installation of it?
Bointa is a sophisticated product, if something went wrong somehow, just install a fresh version it! You can have several versions of Bointa on your box. You only shall not start them concurrently if you have not manipulated the tomcat-ports - what you probably do not want do at the beginning of the learning curve ...
With best regards,
Andreas
Hi! Good Night!
Thank you too much!!! Really did need to instal the softeware... My friend have tried a process and success. She did pass me the import for i tried. Result: Success!
Thank you more once..
Xoxo, Nathália.
Comments
Hello Nathalia,
which version of Bonita are you using?
You could have a look on the actor configuration of the process.
Is an actor set in the process? Have you assigned a user of the organisation to that actor? Have you already deployed an organisation to the Bonita portal?
You could also check your settings under Preferences/Deployment/Server settings and there the entries for Username and Passwort. Can you login into the Portal with that credentials?
With best regards,
Andreas
Good Day Andreas ...
Thank you for answering me . So my version is 6.4.2 free . I followed step by step video that Bonita has the documentation. No video is made only those actions and the portal works. In theory if I did the same steps I could access the portal , but in practice gave that error.
Thank you again.
Hello Nathalia,
may I ask you if you have the portal already running?
Perhaps you could enter
under
and try to deploy again?
With best regards,
Andreas
Good Afternoon ...
So ... I sent running the portal and the error generated was this " org.bonitasoft.engine.platform.NodeNotStartedException "
The error reported previously occurs when I say run the process .
Thanks again .
Hello, If the engine didn't start (org.bonitasoft.engine.platform.NodeNotStartedException), you have to look why. In the studio, go to "help" / then Bonita BPM Engine log and look for the first error.
I understand you run under a Studio : which platform ? Windows ? Do you have an another tomcat running on your machine ?
Hi Pierre, thanks you for answer!
So.... The message is: "2015-03-30 08:48:36 org.bonitasoft.console.server.listener.StudioWatchdogListener Advertência: Bonita Studio watchdog process has started on 6969 with a delay of 20000ms" I don't have other Tomcat... I have only the Bonita BPM to development tool...
Ty!