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!

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 /workspace/tomcat and logs inside the sub directory logs.
You should have minimum a line with the message "org.bonitasoft.engine.platform.NodeNotStartedException ".

Ok, I see.
Try :
1/ reset your engine (server / reset engine)
2/ if it is not work (search and purge the *.db files under the \workspace\tomcat\bonita\server\platform\work

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

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

  • the login and password for this admin-user in the portal

under

  • Preferences/Deployment/Server settings in the studio

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!

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.