[Update] Jasper connector in Bonita 7.2.4

amirah · 17 2017 02:03

Hi,

I have created a workflow to generate invoice using Bonita BPM Studio version 7.2.4. The flow of the process is as below:

User enter information to create the invoice.
The invoice is approved by approver.
The system will create the invoice using connector Jasper 5.0
User download the invoice.

However, the workflow encountered problem to generate invoice using Jasper. The workflow does not proceed and stay in the open task.
I have follow the instruction in the following page http://documentation.bonitasoft.com/6.x-7.2/jasper-50-1.

For your information, I use the following jar file and software respectively:

custom-jasper-impl-1.1.0
Jaspersoft Studio v5.6.2. Final

Is the Jaspersoft Studio v5.6.2 compatible with Bonita 7.2.4? Have anyone face this kind of problem?

Sean_McP · 18 2017 02:47

What do the Logs say?

amirah · 20 2017 09:15

The log does not say anything about error.

2017-03-20 14:46:00.377 +0800 org.bonitasoft.tomcat.H2Listener org.bonitasoft.tomcat.H2Listener lifecycleEvent
INFO: Starting H2 server : [-tcp, -tcpPort, 9091, -baseDir, C:\BonitaBPMSubscription-7.2.4\workspace\default\bonita_home/engine-server/work/platform]
2017-03-20 14:46:23.451 +0800 org.bonitasoft.engine.EngineInitializer org.bonitasoft.engine.EngineInitializer initializeEngine
INFO: Initializing Bonita Engine…
2017-03-20 14:46:23.452 +0800 org.bonitasoft.engine.EngineInitializer org.bonitasoft.engine.EngineInitializer initializeEngine
INFO: Initializing Spring context…
2017-03-20 14:46:23.610 +0800 org.bonitasoft.engine.service.impl.AbsoluteFileSystemXmlApplicationContext org.springframework.context.support.AbstractApplicationContext prepareRefresh
INFO: Refreshing org.bonitasoft.engine.service.impl.AbsoluteFileSystemXmlApplicationContext@6e75c70a: startup date [Mon Mar 20 14:46:23 SGT 2017]; root of context hierarchy
2017-03-20 14:46:23.934 +0800 org.bonitasoft.engine.service.impl.AbsoluteFileSystemXmlApplicationContext org.springframework.context.support.AbstractApplicationContext prepareRefresh
INFO: Refreshing org.bonitasoft.engine.service.impl.AbsoluteFileSystemXmlApplicationContext@7cabadef: startup date [Mon Mar 20 14:46:23 SGT 2017]; parent: org.bonitasoft.engine.service.impl.AbsoluteFileSystemXmlApplicationContext@6e75c70a
2017-03-20 14:46:27.468 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.core.process.instance.model.archive.impl.SAFlowNodeInstanceImpl]; using defaults.
2017-03-20 14:46:27.585 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.core.process.instance.model.impl.SFlowNodeInstanceImpl]; using defaults.
2017-03-20 14:46:27.603 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.data.instance.model.impl.SDataInstanceImpl]; using defaults.
2017-03-20 14:46:27.612 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.core.process.instance.model.event.handling.impl.SWaitingEventImpl]; using defaults.
2017-03-20 14:46:27.623 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.bar.SBARResource]; using defaults.
2017-03-20 14:46:27.665 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.core.process.comment.model.impl.SCommentImpl]; using defaults.
2017-03-20 14:46:27.685 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [com.bonitasoft.engine.core.reporting.SReportImpl]; using defaults.
2017-03-20 14:46:27.701 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.core.process.instance.model.event.trigger.impl.SEventTriggerInstanceImpl]; using defaults.
2017-03-20 14:46:27.729 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.core.process.instance.model.archive.impl.SAConnectorInstanceImpl]; using defaults.
2017-03-20 14:46:27.738 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.data.instance.model.archive.impl.SADataInstanceImpl]; using defaults.
2017-03-20 14:46:27.758 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.core.form.impl.SFormMappingImpl]; using defaults.
2017-03-20 14:46:27.769 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.scheduler.model.impl.SJobDescriptorImpl]; using defaults.
2017-03-20 14:46:27.835 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.core.process.instance.model.impl.SConnectorInstanceImpl]; using defaults.
2017-03-20 14:46:27.881 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.identity.model.impl.SUserLoginImpl]; using defaults.
2017-03-20 14:46:27.918 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.core.contract.data.SContractData]; using defaults.
2017-03-20 14:46:27.924 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.profile.model.impl.SProfileImpl]; using defaults.
2017-03-20 14:46:27.932 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.page.impl.SPageContentImpl]; using defaults.
2017-03-20 14:46:27.979 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.core.process.definition.model.impl.SProcessDefinitionDesignContentImpl]; using defaults.
2017-03-20 14:46:27.992 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.profile.model.impl.SProfileEntryImpl]; using defaults.
2017-03-20 14:46:27.998 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.page.impl.SPageWithContentImpl]; using defaults.
2017-03-20 14:46:28.009 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.identity.model.impl.SUserMembershipImpl]; using defaults.
2017-03-20 14:46:28.076 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.platform.command.model.impl.SPlatformCommandImpl]; using defaults.
2017-03-20 14:46:28.113 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.dependency.model.impl.SDependencyImpl]; using defaults.
2017-03-20 14:46:28.117 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.core.process.instance.model.archive.impl.SAProcessInstanceImpl]; using defaults.
2017-03-20 14:46:28.143 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.core.process.definition.model.impl.SProcessDefinitionDeployInfoImpl]; using defaults.
2017-03-20 14:46:28.185 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.identity.model.impl.SGroupImpl]; using defaults.
2017-03-20 14:46:28.191 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.queriablelogger.model.impl.SQueriableLogParameterImpl]; using defaults.
2017-03-20 14:46:28.195 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.profile.model.impl.SProfileMemberImpl]; using defaults.
2017-03-20 14:46:28.211 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.core.category.model.impl.SCategoryImpl]; using defaults.
2017-03-20 14:46:28.223 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.core.contract.data.SAContractData]; using defaults.
2017-03-20 14:46:28.281 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.core.process.instance.model.event.handling.impl.SMessageInstanceImpl]; using defaults.
2017-03-20 14:46:28.284 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.core.process.instance.model.archive.impl.business.data.SARefBusinessDataInstanceImpl]; using defaults.
2017-03-20 14:46:28.310 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.external.identity.mapping.model.impl.SExternalIdentityMappingImpl]; using defaults.
2017-03-20 14:46:28.347 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.identity.model.impl.SUserImpl]; using defaults.
2017-03-20 14:46:28.354 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.core.process.comment.model.archive.impl.SACommentImpl]; using defaults.
2017-03-20 14:46:28.412 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.queriablelogger.model.impl.SQueriableLogImpl]; using defaults.
2017-03-20 14:46:28.421 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.dependency.model.impl.SPlatformDependencyImpl]; using defaults.
2017-03-20 14:46:28.456 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.business.application.model.impl.SApplicationMenuImpl]; using defaults.
2017-03-20 14:46:28.461 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.platform.model.impl.STenantImpl]; using defaults.
2017-03-20 14:46:28.474 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.bar.SBARResourceLight]; using defaults.
2017-03-20 14:46:28.478 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.actor.mapping.model.impl.SActorMemberImpl]; using defaults.
2017-03-20 14:46:28.491 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.core.process.instance.model.impl.SPendingActivityMappingImpl]; using defaults.
2017-03-20 14:46:28.499 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.core.document.model.impl.SDocumentMappingImpl]; using defaults.
2017-03-20 14:46:28.519 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.page.impl.SPageImpl]; using defaults.
2017-03-20 14:46:28.524 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.page.impl.SPageMappingImpl]; using defaults.
2017-03-20 14:46:28.529 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.command.model.SCommandImpl]; using defaults.
2017-03-20 14:46:28.533 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.business.application.model.impl.SApplicationImpl]; using defaults.
2017-03-20 14:46:28.549 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.identity.model.impl.SCustomUserInfoDefinitionImpl]; using defaults.
2017-03-20 14:46:28.560 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.parameter.SParameterImpl]; using defaults.
2017-03-20 14:46:28.564 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.identity.model.impl.SRoleImpl]; using defaults.
2017-03-20 14:46:28.600 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.actor.mapping.model.impl.SActorImpl]; using defaults.
2017-03-20 14:46:28.622 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.supervisor.mapping.model.impl.SProcessSupervisorImpl]; using defaults.
2017-03-20 14:46:28.658 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.platform.model.impl.SPlatformImpl]; using defaults.
2017-03-20 14:46:28.679 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [com.bonitasoft.engine.core.reporting.SSaveReportWithContentImpl]; using defaults.
2017-03-20 14:46:28.685 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.core.process.instance.model.impl.SProcessInstanceImpl]; using defaults.
2017-03-20 14:46:28.725 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.theme.model.impl.SThemeImpl]; using defaults.
2017-03-20 14:46:32.617 +0800 org.hibernate.type.TypeFactory org.hibernate.type.TypeFactory$TypeScopeImpl injectSessionFactory
WARN: HHH000233: Scoping types to session factory org.hibernate.internal.SessionFactoryImpl@24f92283 after already scoped org.hibernate.internal.SessionFactoryImpl@684781f2
2017-03-20 14:46:32.618 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.core.process.instance.model.archive.impl.SAFlowNodeInstanceImpl]; using defaults.
2017-03-20 14:46:32.624 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.core.process.instance.model.impl.SFlowNodeInstanceImpl]; using defaults.
2017-03-20 14:46:32.631 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.data.instance.model.impl.SDataInstanceImpl]; using defaults.
2017-03-20 14:46:32.634 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.core.process.instance.model.event.handling.impl.SWaitingEventImpl]; using defaults.
2017-03-20 14:46:32.636 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.bar.SBARResource]; using defaults.
2017-03-20 14:46:32.651 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.core.process.comment.model.impl.SCommentImpl]; using defaults.
2017-03-20 14:46:32.659 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [com.bonitasoft.engine.core.reporting.SReportImpl]; using defaults.
2017-03-20 14:46:32.665 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.core.process.instance.model.event.trigger.impl.SEventTriggerInstanceImpl]; using defaults.
2017-03-20 14:46:32.678 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.core.process.instance.model.archive.impl.SAConnectorInstanceImpl]; using defaults.
2017-03-20 14:46:32.681 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.data.instance.model.archive.impl.SADataInstanceImpl]; using defaults.
2017-03-20 14:46:32.686 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.core.form.impl.SFormMappingImpl]; using defaults.
2017-03-20 14:46:32.689 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.scheduler.model.impl.SJobDescriptorImpl]; using defaults.
2017-03-20 14:46:32.706 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.core.process.instance.model.impl.SConnectorInstanceImpl]; using defaults.
2017-03-20 14:46:32.723 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.identity.model.impl.SUserLoginImpl]; using defaults.
2017-03-20 14:46:32.738 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.core.contract.data.SContractData]; using defaults.
2017-03-20 14:46:32.741 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.profile.model.impl.SProfileImpl]; using defaults.
2017-03-20 14:46:32.745 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.page.impl.SPageContentImpl]; using defaults.
2017-03-20 14:46:32.758 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.core.process.definition.model.impl.SProcessDefinitionDesignContentImpl]; using defaults.
2017-03-20 14:46:32.762 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.profile.model.impl.SProfileEntryImpl]; using defaults.
2017-03-20 14:46:32.765 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.page.impl.SPageWithContentImpl]; using defaults.
2017-03-20 14:46:32.769 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.identity.model.impl.SUserMembershipImpl]; using defaults.
2017-03-20 14:46:32.794 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.platform.command.model.impl.SPlatformCommandImpl]; using defaults.
2017-03-20 14:46:32.806 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.dependency.model.impl.SDependencyImpl]; using defaults.
2017-03-20 14:46:32.807 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.core.process.instance.model.archive.impl.SAProcessInstanceImpl]; using defaults.
2017-03-20 14:46:32.816 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.core.process.definition.model.impl.SProcessDefinitionDeployInfoImpl]; using defaults.
2017-03-20 14:46:32.833 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.identity.model.impl.SGroupImpl]; using defaults.
2017-03-20 14:46:32.836 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.queriablelogger.model.impl.SQueriableLogParameterImpl]; using defaults.
2017-03-20 14:46:32.837 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.profile.model.impl.SProfileMemberImpl]; using defaults.
2017-03-20 14:46:32.841 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.core.category.model.impl.SCategoryImpl]; using defaults.
2017-03-20 14:46:32.845 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.core.contract.data.SAContractData]; using defaults.
2017-03-20 14:46:32.865 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.core.process.instance.model.event.handling.impl.SMessageInstanceImpl]; using defaults.
2017-03-20 14:46:32.867 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.core.process.instance.model.archive.impl.business.data.SARefBusinessDataInstanceImpl]; using defaults.
2017-03-20 14:46:32.882 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.external.identity.mapping.model.impl.SExternalIdentityMappingImpl]; using defaults.
2017-03-20 14:46:32.898 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.identity.model.impl.SUserImpl]; using defaults.
2017-03-20 14:46:32.900 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.core.process.comment.model.archive.impl.SACommentImpl]; using defaults.
2017-03-20 14:46:32.922 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.queriablelogger.model.impl.SQueriableLogImpl]; using defaults.
2017-03-20 14:46:32.924 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.dependency.model.impl.SPlatformDependencyImpl]; using defaults.
2017-03-20 14:46:32.943 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.business.application.model.impl.SApplicationMenuImpl]; using defaults.
2017-03-20 14:46:32.946 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.platform.model.impl.STenantImpl]; using defaults.
2017-03-20 14:46:32.950 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.bar.SBARResourceLight]; using defaults.
2017-03-20 14:46:32.952 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.actor.mapping.model.impl.SActorMemberImpl]; using defaults.
2017-03-20 14:46:32.957 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.core.process.instance.model.impl.SPendingActivityMappingImpl]; using defaults.
2017-03-20 14:46:32.959 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.core.document.model.impl.SDocumentMappingImpl]; using defaults.
2017-03-20 14:46:32.969 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.page.impl.SPageImpl]; using defaults.
2017-03-20 14:46:32.971 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.page.impl.SPageMappingImpl]; using defaults.
2017-03-20 14:46:32.973 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.command.model.SCommandImpl]; using defaults.
2017-03-20 14:46:32.975 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.business.application.model.impl.SApplicationImpl]; using defaults.
2017-03-20 14:46:32.979 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.identity.model.impl.SCustomUserInfoDefinitionImpl]; using defaults.
2017-03-20 14:46:32.983 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.parameter.SParameterImpl]; using defaults.
2017-03-20 14:46:32.985 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.identity.model.impl.SRoleImpl]; using defaults.
2017-03-20 14:46:32.993 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.actor.mapping.model.impl.SActorImpl]; using defaults.
2017-03-20 14:46:33.000 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.supervisor.mapping.model.impl.SProcessSupervisorImpl]; using defaults.
2017-03-20 14:46:33.010 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.platform.model.impl.SPlatformImpl]; using defaults.
2017-03-20 14:46:33.020 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [com.bonitasoft.engine.core.reporting.SSaveReportWithContentImpl]; using defaults.
2017-03-20 14:46:33.022 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.core.process.instance.model.impl.SProcessInstanceImpl]; using defaults.
2017-03-20 14:46:33.036 +0800 org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory getCache
WARN: HHH020003: Could not find a specific ehcache configuration for cache named [org.bonitasoft.engine.theme.model.impl.SThemeImpl]; using defaults.
2017-03-20 14:46:35.592 +0800 org.bonitasoft.engine.EngineInitializer org.bonitasoft.engine.EngineInitializer initializeEngine
INFO: Initializing platform…
2017-03-20 14:46:35.592 +0800 org.bonitasoft.engine.EngineInitializer org.bonitasoft.engine.EngineInitializer initPlatform
INFO: Creating platform…
2017-03-20 14:46:38.893 +0800 org.bonitasoft.engine.EngineInitializer org.bonitasoft.engine.EngineInitializer initializeEngine
INFO: Platform initialized successfully.
2017-03-20 14:46:38.894 +0800 org.bonitasoft.engine.EngineInitializer org.bonitasoft.engine.EngineInitializer startPlatform
INFO: Starting platform…
2017-03-20 14:46:39.258 +0800 com.bonitasoft.engine.api.impl.PlatformAPIExt org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl log
INFO: THREAD_ID=26 | HOSTNAME=FSB-MIRA | Start service of platform : org.bonitasoft.engine.classloader.ClassLoaderServiceImpl
2017-03-20 14:46:39.258 +0800 com.bonitasoft.engine.api.impl.PlatformAPIExt org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl log
INFO: THREAD_ID=26 | HOSTNAME=FSB-MIRA | Start service of platform : org.bonitasoft.engine.cache.ehcache.PlatformEhCacheCacheService
2017-03-20 14:46:39.259 +0800 com.bonitasoft.engine.api.impl.PlatformAPIExt org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl log
INFO: THREAD_ID=26 | HOSTNAME=FSB-MIRA | Start service of platform : com.bonitasoft.engine.service.platform.PlatformInfoUpdateScheduledExecutor
2017-03-20 14:46:39.313 +0800 org.bonitasoft.engine.scheduler.impl.BonitaSchedulerFactory org.quartz.impl.StdSchedulerFactory instantiate
INFO: Using default implementation for ThreadExecutor
2017-03-20 14:46:39.347 +0800 org.bonitasoft.engine.scheduler.impl.BonitaJobStoreCMT org.quartz.impl.jdbcjobstore.JobStoreSupport initialize
INFO: Using db table-based data access locking (synchronization).
2017-03-20 14:46:39.351 +0800 org.bonitasoft.engine.scheduler.impl.BonitaJobStoreCMT org.quartz.impl.jdbcjobstore.JobStoreCMT initialize
INFO: JobStoreCMT initialized.
2017-03-20 14:46:39.353 +0800 org.bonitasoft.engine.scheduler.impl.BonitaSchedulerFactory org.quartz.impl.StdSchedulerFactory instantiate
INFO: Quartz scheduler ‘QuartzScheduler’ initialized from an externally provided properties instance.
2017-03-20 14:46:39.353 +0800 org.bonitasoft.engine.scheduler.impl.BonitaSchedulerFactory org.quartz.impl.StdSchedulerFactory instantiate
INFO: Quartz scheduler version: 2.2.1
2017-03-20 14:46:39.414 +0800 org.bonitasoft.engine.service.impl.AbsoluteFileSystemXmlApplicationContext org.springframework.context.support.AbstractApplicationContext prepareRefresh
INFO: Refreshing org.bonitasoft.engine.service.impl.AbsoluteFileSystemXmlApplicationContext@6d4306b0: startup date [Mon Mar 20 14:46:39 SGT 2017]; parent: org.bonitasoft.engine.service.impl.AbsoluteFileSystemXmlApplicationContext@7cabadef
2017-03-20 14:46:40.624 +0800 org.bonitasoft.engine.tracking.TimeTracker org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl log
INFO: THREAD_ID=26 | HOSTNAME=FSB-MIRA | TENANT_ID=1 | -----
Time Tracker ‘org.bonitasoft.engine.tracking.TimeTracker’:

trackingEnabled: false
flushIntervalInSeconds: 30000
activatedRecords: EVALUATE_EXPRESSIONS EXECUTE_CONNECTOR_INCLUDING_POOL_SUBMIT EXECUTE_CONNECTOR_WORK EXECUTE_CONNECTOR_OUTPUT_OPERATIONS EXECUTE_CONNECTOR_INPUT_EXPRESSIONS EXECUTE_CONNECTOR_CALLABLE EXECUTE_CONNECTOR_DISCONNECT EVALUATE_EXPRESSION_INCLUDING_CONTEXT EVALUATE_EXPRESSION
flushEventListeners: org.bonitasoft.engine.tracking.memory.MemoryFlushEventListener:
active: false
No DayRecord registered in memory. org.bonitasoft.engine.tracking.csv.CSVFlushEventListener:
active: true
outputFolder: C:\Users\Azlia\AppData\Local\Temp\
records.size: 0
last flush occurrence: Thu Jan 01 07:30:00 SGT 1970

2017-03-20 14:46:41.408 +0800 org.bonitasoft.engine.scheduler.impl.SchedulerServiceImpl org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl log
INFO: THREAD_ID=26 | HOSTNAME=FSB-MIRA | Start scheduler
2017-03-20 14:46:41.448 +0800 org.bonitasoft.engine.scheduler.impl.BonitaJobStoreCMT org.quartz.impl.jdbcjobstore.JobStoreSupport recoverJobs
INFO: Freed 1 triggers from ‘acquired’ / ‘blocked’ state.
2017-03-20 14:46:41.455 +0800 org.bonitasoft.engine.scheduler.impl.BonitaJobStoreCMT org.quartz.impl.jdbcjobstore.JobStoreSupport recoverJobs
INFO: Recovering 0 jobs that were in-progress at the time of the last shut-down.
2017-03-20 14:46:41.455 +0800 org.bonitasoft.engine.scheduler.impl.BonitaJobStoreCMT org.quartz.impl.jdbcjobstore.JobStoreSupport recoverJobs
INFO: Recovery complete.
2017-03-20 14:46:41.457 +0800 org.bonitasoft.engine.scheduler.impl.BonitaJobStoreCMT org.quartz.impl.jdbcjobstore.JobStoreSupport recoverJobs
INFO: Removed 0 ‘complete’ triggers.
2017-03-20 14:46:41.459 +0800 org.bonitasoft.engine.scheduler.impl.BonitaJobStoreCMT org.quartz.impl.jdbcjobstore.JobStoreSupport recoverJobs
INFO: Removed 0 stale fired job entries.
2017-03-20 14:46:41.467 +0800 org.bonitasoft.engine.handler.SchedulerServiceRestartHandler org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl log
INFO: THREAD_ID=26 | HOSTNAME=FSB-MIRA | Rescheduling all scheduler Triggers in ERROR state
2017-03-20 14:46:41.493 +0800 org.bonitasoft.engine.api.impl.StarterThread org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl log
INFO: THREAD_ID=26 | HOSTNAME=FSB-MIRA | Restarting elements in the Thread 47
2017-03-20 14:46:41.500 +0800 org.bonitasoft.engine.api.impl.StarterThread org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl log
INFO: THREAD_ID=47 | HOSTNAME=FSB-MIRA | Restarting elements for tenant 1
2017-03-20 14:46:41.514 +0800 org.bonitasoft.engine.EngineInitializer org.bonitasoft.engine.EngineInitializer startPlatform
INFO: Platform started successfully
2017-03-20 14:46:41.514 +0800 org.bonitasoft.engine.EngineInitializer org.bonitasoft.engine.EngineInitializer initializeEngine
INFO: Initialization of Bonita Engine done! ( took 18062ms)
2017-03-20 14:46:47.103 +0800 org.bonitasoft.web.designer.SpringWebApplicationInitializer org.bonitasoft.web.designer.SpringWebApplicationInitializer onStartup
INFO:
2017-03-20 14:46:47.103 +0800 org.bonitasoft.web.designer.SpringWebApplicationInitializer org.bonitasoft.web.designer.SpringWebApplicationInitializer onStartup
INFO: d8888b. .d88b. d8b db d888888b d888888b .d8b. .d8888. .d88b. d88888b d888888b
2017-03-20 14:46:47.103 +0800 org.bonitasoft.web.designer.SpringWebApplicationInitializer org.bonitasoft.web.designer.SpringWebApplicationInitializer onStartup
INFO: 88 8D .8P Y8. 888o 88 88’ ~~88~~' d8' 8b 88’ YP .8P Y8. 88’ ~~88~~' 2017-03-20 14:46:47.103 +0800 org.bonitasoft.web.designer.SpringWebApplicationInitializer org.bonitasoft.web.designer.SpringWebApplicationInitializer onStartup INFO: 88oooY' 88 88 88V8o 88 88 88 88ooo88 8bo. 88 88 88ooo 88
2017-03-20 14:46:47.103 +0800 org.bonitasoft.web.designer.SpringWebApplicationInitializer org.bonitasoft.web.designer.SpringWebApplicationInitializer onStartup
INFO: 88~~~b. 88 88 88 V8o88 88 88 88~~~88 Y8b. 88 88 88~~~ 88 2017-03-20 14:46:47.104 +0800 org.bonitasoft.web.designer.SpringWebApplicationInitializer org.bonitasoft.web.designer.SpringWebApplicationInitializer onStartup INFO: 88 8D 8b d8’ 88 V888 .88. 88 88 88 db 8D 8b d8' 88 88 2017-03-20 14:46:47.104 +0800 org.bonitasoft.web.designer.SpringWebApplicationInitializer org.bonitasoft.web.designer.SpringWebApplicationInitializer onStartup INFO: Y8888P' Y88P’ VP V8P Y888888P YP YP YP 8888Y' Y88P’ YP YP
2017-03-20 14:46:47.105 +0800 org.bonitasoft.web.designer.SpringWebApplicationInitializer org.bonitasoft.web.designer.SpringWebApplicationInitializer onStartup
INFO: ====================================================================================================
2017-03-20 14:46:47.106 +0800 org.bonitasoft.web.designer.SpringWebApplicationInitializer org.bonitasoft.web.designer.SpringWebApplicationInitializer onStartup
INFO: UI-DESIGNER : SP edition v.1.2.19
2017-03-20 14:46:47.106 +0800 org.bonitasoft.web.designer.SpringWebApplicationInitializer org.bonitasoft.web.designer.SpringWebApplicationInitializer onStartup
INFO: ====================================================================================================
2017-03-20 14:46:47.498 +0800 org.bonitasoft.web.designer.config.DesignerConfigConditional org.bonitasoft.web.designer.config.DesignerConfigConditional matches
INFO: Conf loaded : SP edition
2017-03-20 14:46:53.104 +0800 org.bonitasoft.web.designer.config.WebMvcConfiguration org.bonitasoft.web.designer.config.WebMvcConfiguration addViewControllers
INFO: Adding welcome page: file:/C:/BonitaBPMSubscription-7.2.4/workspace/tomcat/webapps/designer/WEB-INF/classes/static/index.html
2017-03-20 14:46:53.833 +0800 org.bonitasoft.console.server.listener.StudioWatchdogListener org.bonitasoft.console.server.listener.StudioWatchdogListener$1 run
WARNING: Bonita Studio watchdog process has started on 6969 with a delay of 20000ms
2017-03-20 14:46:55.856 +0800 org.bonitasoft.engine.execution.work.RestartFlowNodesHandler org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl log
INFO: THREAD_ID=69 | HOSTNAME=FSB-MIRA | TENANT_ID=1 | Restarting flow nodes…
2017-03-20 14:46:55.889 +0800 org.bonitasoft.engine.execution.work.RestartFlowNodesHandler org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl log
INFO: THREAD_ID=69 | HOSTNAME=FSB-MIRA | TENANT_ID=1 | Found 2 flow nodes to restart on tenant 1
2017-03-20 14:46:55.906 +0800 org.bonitasoft.engine.execution.work.RestartProcessHandler org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl log
INFO: THREAD_ID=69 | HOSTNAME=FSB-MIRA | TENANT_ID=1 | Found 0 process to restart on tenant 1
2017-03-20 14:46:55.907 +0800 org.bonitasoft.engine.execution.work.BPMEventWorksHandler org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl log
INFO: THREAD_ID=69 | HOSTNAME=FSB-MIRA | TENANT_ID=1 | Reinitializing message instances in non-stable state to make them reworked by BPMEventHandlingJob
2017-03-20 14:46:55.925 +0800 org.bonitasoft.engine.execution.work.BPMEventWorksHandler org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl log
INFO: THREAD_ID=69 | HOSTNAME=FSB-MIRA | TENANT_ID=1 | 0 message instances found and reset.
2017-03-20 14:46:55.925 +0800 org.bonitasoft.engine.execution.work.BPMEventWorksHandler org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl log
INFO: THREAD_ID=69 | HOSTNAME=FSB-MIRA | TENANT_ID=1 | Reinitializing waiting message events in non-stable state to make them reworked by BPMEventHandlingJob
2017-03-20 14:46:55.930 +0800 org.bonitasoft.engine.execution.work.BPMEventWorksHandler org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl log
INFO: THREAD_ID=69 | HOSTNAME=FSB-MIRA | TENANT_ID=1 | 0 waiting message events found and reset.
2017-03-20 14:46:56.924 +0800 org.bonitasoft.engine.api.impl.transaction.SetServiceState org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl log
INFO: THREAD_ID=69 | HOSTNAME=FSB-MIRA | TENANT_ID=1 | resume tenant-level service org.bonitasoft.engine.command.api.impl.CommandServiceImpl on tenant with ID 1
2017-03-20 14:46:56.924 +0800 org.bonitasoft.engine.api.impl.transaction.SetServiceState org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl log
INFO: THREAD_ID=69 | HOSTNAME=FSB-MIRA | TENANT_ID=1 | resume tenant-level service com.bonitasoft.engine.connector.impl.ConnectorExecutorTimedOut on tenant with ID 1
2017-03-20 14:46:56.926 +0800 org.bonitasoft.engine.api.impl.transaction.SetServiceState org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl log
INFO: THREAD_ID=69 | HOSTNAME=FSB-MIRA | TENANT_ID=1 | resume tenant-level service org.bonitasoft.engine.work.ExecutorWorkService on tenant with ID 1
2017-03-20 14:46:56.929 +0800 org.bonitasoft.engine.api.impl.transaction.SetServiceState org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl log
INFO: THREAD_ID=69 | HOSTNAME=FSB-MIRA | TENANT_ID=1 | resume tenant-level service org.bonitasoft.engine.tracking.TimeTracker on tenant with ID 1
2017-03-20 14:46:56.929 +0800 org.bonitasoft.engine.tracking.TimeTracker org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl log
INFO: THREAD_ID=69 | HOSTNAME=FSB-MIRA | TENANT_ID=1 | Starting TimeTracker…
2017-03-20 14:46:56.929 +0800 org.bonitasoft.engine.tracking.TimeTracker org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl log
INFO: THREAD_ID=69 | HOSTNAME=FSB-MIRA | TENANT_ID=1 | TimeTracker started.
2017-03-20 14:46:56.929 +0800 org.bonitasoft.engine.api.impl.transaction.SetServiceState org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl log
INFO: THREAD_ID=69 | HOSTNAME=FSB-MIRA | TENANT_ID=1 | resume tenant-level service org.bonitasoft.engine.theme.impl.ThemeServiceImpl on tenant with ID 1
2017-03-20 14:46:56.929 +0800 org.bonitasoft.engine.api.impl.transaction.SetServiceState org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl log
INFO: THREAD_ID=69 | HOSTNAME=FSB-MIRA | TENANT_ID=1 | resume tenant-level service org.bonitasoft.engine.service.impl.PermissionServiceImpl on tenant with ID 1
2017-03-20 14:46:56.940 +0800 org.bonitasoft.engine.api.impl.transaction.SetServiceState org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl log
INFO: THREAD_ID=69 | HOSTNAME=FSB-MIRA | TENANT_ID=1 | resume tenant-level service org.bonitasoft.engine.page.impl.PageServiceImpl on tenant with ID 1
2017-03-20 14:46:56.941 +0800 org.bonitasoft.engine.api.impl.transaction.SetServiceState org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl log
INFO: THREAD_ID=69 | HOSTNAME=FSB-MIRA | TENANT_ID=1 | resume tenant-level service org.bonitasoft.engine.cache.ehcache.EhCacheCacheService on tenant with ID 1
2017-03-20 14:46:56.942 +0800 org.bonitasoft.engine.api.impl.transaction.SetServiceState org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl log
INFO: THREAD_ID=69 | HOSTNAME=FSB-MIRA | TENANT_ID=1 | resume tenant-level service org.bonitasoft.engine.business.data.impl.JPABusinessDataRepositoryImpl on tenant with ID 1
2017-03-20 14:46:56.964 +0800 org.bonitasoft.engine.api.impl.transaction.SetServiceState org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl log
INFO: THREAD_ID=69 | HOSTNAME=FSB-MIRA | TENANT_ID=1 | resume tenant-level service com.bonitasoft.engine.core.reporting.ReportingServiceImpl on tenant with ID 1
2017-03-20 14:46:59.045 +0800 org.bonitasoft.engine.api.impl.StarterThread org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl log
INFO: THREAD_ID=69 | HOSTNAME=FSB-MIRA | TENANT_ID=1 | Restarting elements in the Thread 72
2017-03-20 14:46:59.046 +0800 org.bonitasoft.engine.api.impl.StarterThread org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl log
INFO: THREAD_ID=72 | HOSTNAME=FSB-MIRA | TENANT_ID=1 | Restarting elements for tenant 1
2017-03-20 14:46:59.047 +0800 org.bonitasoft.engine.execution.work.RestartFlowNodesHandler org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl log
INFO: THREAD_ID=72 | HOSTNAME=FSB-MIRA | TENANT_ID=1 | Restarting 2 flow nodes for tenant 1
2017-03-20 14:46:59.062 +0800 org.bonitasoft.engine.execution.work.RestartFlowNodesHandler org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl log
INFO: THREAD_ID=72 | HOSTNAME=FSB-MIRA | TENANT_ID=1 | Restarting flow node (Execute …) with name = , and id = <100004> in state =
2017-03-20 14:46:59.093 +0800 org.bonitasoft.engine.execution.work.RestartFlowNodesHandler org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl log
INFO: THREAD_ID=72 | HOSTNAME=FSB-MIRA | TENANT_ID=1 | Restarting flow node (Execute …) with name = , and id = <100027> in state =
2017-03-20 14:46:59.097 +0800 org.bonitasoft.engine.execution.work.RestartProcessHandler org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl log
INFO: THREAD_ID=72 | HOSTNAME=FSB-MIRA | TENANT_ID=1 | Restarting 0 processes for tenant 1
2017-03-20 14:46:59.302 +0800 org.bonitasoft.engine.profile.DefaultProfilesUpdater org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl log
INFO: THREAD_ID=72 | HOSTNAME=FSB-MIRA | TENANT_ID=1 | Default profiles are up to date
2017-03-20 14:49:40.179 +0800 org.bonitasoft.engine.api.impl.transaction.process.DisableProcess org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl log
INFO: THREAD_ID=67 | HOSTNAME=FSB-MIRA | TENANT_ID=1 | The user has disabled process <C.6 Fuel and Fresh Water Debit Credit Note TEST> in version <1.1.0> with id <7087473412838445990>
2017-03-20 14:49:44.501 +0800 org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/bonita] org.apache.catalina.core.ApplicationContext log
INFO: RestletServlet: [Restlet] ServerServlet: component class is null
2017-03-20 14:49:51.900 +0800 com.bonitasoft.engine.api.impl.ProcessManagementAPIExtDelegate org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl log
INFO: THREAD_ID=67 | HOSTNAME=FSB-MIRA | TENANT_ID=1 | The user has deleted process with id = <7087473412838445990>
2017-03-20 14:50:22.700 +0800 org.bonitasoft.engine.bar.BusinessArchiveServiceImpl org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl log
INFO: THREAD_ID=66 | HOSTNAME=FSB-MIRA | TENANT_ID=1 | The user has installed process <C.6 Fuel and Fresh Water Debit Credit Note TEST> in version <1.1.0> with id <7739187110568227399>
2017-03-20 14:50:26.378 +0800 org.bonitasoft.engine.api.impl.transaction.process.EnableProcess org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl log
INFO: THREAD_ID=66 | HOSTNAME=FSB-MIRA | TENANT_ID=1 | The user has enabled process <C.6 Fuel and Fresh Water Debit Credit Note TEST> in version <1.1.0> with id <7739187110568227399>
2017-03-20 14:50:30.406 +0800 org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/bonita] org.apache.catalina.core.ApplicationContext log
INFO: RestletServlet: [Restlet] Attaching application: com.bonitasoft.web.rest.server.BonitaSPRestletApplication@8c76cd6 to URI: /bonita/API
2017-03-20 14:50:30.446 +0800 org.restlet.Component.BonitaSPRestletApplication org.restlet.Application start
INFO: Starting com.bonitasoft.web.rest.server.BonitaSPRestletApplication application
2017-03-20 14:50:32.296 +0800 org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl org.bonitasoft.forms.server.util.FormLogger internalLog
INFO: Username Form<C.6 Fuel and Fresh Water Debit Credit Note TEST–1.1.0$entry> Process<C.6 Fuel and Fresh Water Debit Credit Note TEST 1.1.0> ### 14:50:32:294 - executeConnector - start
2017-03-20 14:50:32.378 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: username icon
2017-03-20 14:50:32.378 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: password ******
2017-03-20 14:50:32.378 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: script SELECT DISTINCT “c”.“vessel_name”
FROM “contract_main” AS “a” INNER JOIN “setup_vessel” AS “c” ON “a”.“vessel_code” = “c”.“vessel_code”
WHERE “actual_onhire_date” IS NOT NULL AND “contract_status” = ‘1’
ORDER BY “c”.“vessel_name” ASC

2017-03-20 14:50:32.379 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: separator null
2017-03-20 14:50:32.379 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: driver com.microsoft.sqlserver.jdbc.SQLServerDriver
2017-03-20 14:50:32.379 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: url jdbc:sqlserver://10.0.0.86:52916;databaseName=icon_test2
2017-03-20 14:50:32.379 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: outputType n_row
2017-03-20 14:50:33.181 +0800 org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl executeConnector
INFO: ### 14:50:33:181 - executeConnector - end
2017-03-20 14:54:26.606 +0800 org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl org.bonitasoft.forms.server.util.FormLogger internalLog
INFO: Username Form<C.6 Fuel and Fresh Water Debit Credit Note TEST–1.1.0$entry> Submitted Fields<ContractVessel (java.lang.String) => TANJUNG PUTERI 2 ; CustomerList (java.lang.String) => – Please Select – ; > Process<C.6 Fuel and Fresh Water Debit Credit Note TEST 1.1.0> ### 14:54:26:603 - executeConnector - start
2017-03-20 14:54:26.608 +0800 org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl org.bonitasoft.forms.server.util.FormLogger internalLog
INFO: Username Form<C.6 Fuel and Fresh Water Debit Credit Note TEST–1.1.0$entry> Submitted Fields<ContractNo (java.lang.String) => – Please Select – ; ContractVessel (java.lang.String) => TANJUNG PUTERI 2 ; CustomerList (java.lang.String) => – Please Select – ; > Process<C.6 Fuel and Fresh Water Debit Credit Note TEST 1.1.0> ### 14:54:26:607 - executeConnector - start
2017-03-20 14:54:26.622 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: username icon
2017-03-20 14:54:26.622 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: password ******
2017-03-20 14:54:26.622 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: script SELECT DISTINCT “dbo”.“setup_customer”.“customer_name”
FROM “dbo”.“setup_customer”
INNER JOIN “dbo”.“contract_main” ON “dbo”.“setup_customer”.“customer_no” = “dbo”.“contract_main”.“customer_code”
JOIN “dbo”.“setup_vessel” ON “dbo”.“contract_main”.“vessel_code” = “dbo”.“setup_vessel”.“vessel_code”
WHERE “contract_main”.“actual_onhire_date” IS NOT NULL AND “contract_main”.“contract_status” = ‘1’
AND “dbo”.“setup_vessel”.“vessel_name” = ‘TANJUNG PUTERI 2’
ORDER BY “dbo”.“setup_customer”.“customer_name” ASC
2017-03-20 14:54:26.622 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: separator null
2017-03-20 14:54:26.623 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: driver com.microsoft.sqlserver.jdbc.SQLServerDriver
2017-03-20 14:54:26.623 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: url jdbc:sqlserver://10.0.0.86:52916;databaseName=icon_test2
2017-03-20 14:54:26.623 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: outputType n_row
2017-03-20 14:54:26.623 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: username icon
2017-03-20 14:54:26.625 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: password ******
2017-03-20 14:54:26.626 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: script SELECT b.contract_no
FROM dbo.setup_customer AS a
INNER JOIN dbo.contract_main AS b
on a.customer_no = b.customer_code
JOIN dbo.setup_vessel AS c ON b.vessel_code = c.vessel_code
where b.actual_onhire_date IS NOT NULL and b.contract_status = ‘1’
and c.vessel_name = ‘TANJUNG PUTERI 2’
AND a.customer_name = ‘-- Please Select --’
ORDER BY b.contract_no ASC
2017-03-20 14:54:26.626 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: separator null
2017-03-20 14:54:26.626 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: driver com.microsoft.sqlserver.jdbc.SQLServerDriver
2017-03-20 14:54:26.626 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: url jdbc:sqlserver://10.0.0.86:52916;databaseName=icon_test2
2017-03-20 14:54:26.626 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: outputType n_row
2017-03-20 14:54:26.871 +0800 org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl executeConnector
INFO: ### 14:54:26:871 - executeConnector - end
2017-03-20 14:54:26.890 +0800 org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl executeConnector
INFO: ### 14:54:26:890 - executeConnector - end
2017-03-20 14:54:26.957 +0800 org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl org.bonitasoft.forms.server.util.FormLogger internalLog
INFO: Username Form<C.6 Fuel and Fresh Water Debit Credit Note TEST–1.1.0$entry> Submitted Fields<ContractNo (java.lang.String) => null ; ContractVessel (java.lang.String) => TANJUNG PUTERI 2 ; CustomerList (java.lang.String) => EXXONMOBIL EXPLORATION AND PRODUCTION MALAYSIA INC. ; > Process<C.6 Fuel and Fresh Water Debit Credit Note TEST 1.1.0> ### 14:54:26:955 - executeConnector - start
2017-03-20 14:54:26.966 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: username icon
2017-03-20 14:54:26.966 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: password ******
2017-03-20 14:54:26.966 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: script SELECT b.contract_no
FROM dbo.setup_customer AS a
INNER JOIN dbo.contract_main AS b
on a.customer_no = b.customer_code
JOIN dbo.setup_vessel AS c ON b.vessel_code = c.vessel_code
where b.actual_onhire_date IS NOT NULL and b.contract_status = ‘1’
and c.vessel_name = ‘TANJUNG PUTERI 2’
AND a.customer_name = ‘EXXONMOBIL EXPLORATION AND PRODUCTION MALAYSIA INC.’
ORDER BY b.contract_no ASC
2017-03-20 14:54:26.967 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: separator null
2017-03-20 14:54:26.967 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: driver com.microsoft.sqlserver.jdbc.SQLServerDriver
2017-03-20 14:54:26.967 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: url jdbc:sqlserver://10.0.0.86:52916;databaseName=icon_test2
2017-03-20 14:54:26.967 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: outputType n_row
2017-03-20 14:54:27.179 +0800 org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl executeConnector
INFO: ### 14:54:27:179 - executeConnector - end
2017-03-20 14:54:39.126 +0800 org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl org.bonitasoft.forms.server.util.FormLogger internalLog
INFO: Username Form<C.6 Fuel and Fresh Water Debit Credit Note TEST–1.1.0$entry> Submitted Fields<ContractVessel (java.lang.String) => TANJUNG PINANG 4 ; CustomerList (java.lang.String) => EXXONMOBIL EXPLORATION AND PRODUCTION MALAYSIA INC. ; > Process<C.6 Fuel and Fresh Water Debit Credit Note TEST 1.1.0> ### 14:54:39:123 - executeConnector - start
2017-03-20 14:54:39.135 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: username icon
2017-03-20 14:54:39.136 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: password ******
2017-03-20 14:54:39.136 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: script SELECT DISTINCT “dbo”.“setup_customer”.“customer_name”
FROM “dbo”.“setup_customer”
INNER JOIN “dbo”.“contract_main” ON “dbo”.“setup_customer”.“customer_no” = “dbo”.“contract_main”.“customer_code”
JOIN “dbo”.“setup_vessel” ON “dbo”.“contract_main”.“vessel_code” = “dbo”.“setup_vessel”.“vessel_code”
WHERE “contract_main”.“actual_onhire_date” IS NOT NULL AND “contract_main”.“contract_status” = ‘1’
AND “dbo”.“setup_vessel”.“vessel_name” = ‘TANJUNG PINANG 4’
ORDER BY “dbo”.“setup_customer”.“customer_name” ASC
2017-03-20 14:54:39.136 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: separator null
2017-03-20 14:54:39.136 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: driver com.microsoft.sqlserver.jdbc.SQLServerDriver
2017-03-20 14:54:39.136 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: url jdbc:sqlserver://10.0.0.86:52916;databaseName=icon_test2
2017-03-20 14:54:39.137 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: outputType n_row
2017-03-20 14:54:39.152 +0800 org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl org.bonitasoft.forms.server.util.FormLogger internalLog
INFO: Username Form<C.6 Fuel and Fresh Water Debit Credit Note TEST–1.1.0$entry> Submitted Fields<ContractNo (java.lang.String) => A2480247 ; ContractVessel (java.lang.String) => TANJUNG PINANG 4 ; CustomerList (java.lang.String) => EXXONMOBIL EXPLORATION AND PRODUCTION MALAYSIA INC. ; > Process<C.6 Fuel and Fresh Water Debit Credit Note TEST 1.1.0> ### 14:54:39:150 - executeConnector - start
2017-03-20 14:54:39.161 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: username icon
2017-03-20 14:54:39.161 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: password ******
2017-03-20 14:54:39.162 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: script SELECT b.contract_no
FROM dbo.setup_customer AS a
INNER JOIN dbo.contract_main AS b
on a.customer_no = b.customer_code
JOIN dbo.setup_vessel AS c ON b.vessel_code = c.vessel_code
where b.actual_onhire_date IS NOT NULL and b.contract_status = ‘1’
and c.vessel_name = ‘TANJUNG PINANG 4’
AND a.customer_name = ‘EXXONMOBIL EXPLORATION AND PRODUCTION MALAYSIA INC.’
ORDER BY b.contract_no ASC
2017-03-20 14:54:39.162 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: separator null
2017-03-20 14:54:39.162 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: driver com.microsoft.sqlserver.jdbc.SQLServerDriver
2017-03-20 14:54:39.162 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: url jdbc:sqlserver://10.0.0.86:52916;databaseName=icon_test2
2017-03-20 14:54:39.162 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: outputType n_row
2017-03-20 14:54:39.371 +0800 org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl executeConnector
INFO: ### 14:54:39:371 - executeConnector - end
2017-03-20 14:54:39.385 +0800 org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl executeConnector
INFO: ### 14:54:39:385 - executeConnector - end
2017-03-20 14:54:39.426 +0800 org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl org.bonitasoft.forms.server.util.FormLogger internalLog
INFO: Username Form<C.6 Fuel and Fresh Water Debit Credit Note TEST–1.1.0$entry> Submitted Fields<ContractNo (java.lang.String) => A2480247 ; ContractVessel (java.lang.String) => TANJUNG PINANG 4 ; CustomerList (java.lang.String) => SAPURA KENCANA ALLIED MARINE SDN BHD ; > Process<C.6 Fuel and Fresh Water Debit Credit Note TEST 1.1.0> ### 14:54:39:425 - executeConnector - start
2017-03-20 14:54:39.432 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: username icon
2017-03-20 14:54:39.432 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: password ******
2017-03-20 14:54:39.432 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: script SELECT b.contract_no
FROM dbo.setup_customer AS a
INNER JOIN dbo.contract_main AS b
on a.customer_no = b.customer_code
JOIN dbo.setup_vessel AS c ON b.vessel_code = c.vessel_code
where b.actual_onhire_date IS NOT NULL and b.contract_status = ‘1’
and c.vessel_name = ‘TANJUNG PINANG 4’
AND a.customer_name = ‘SAPURA KENCANA ALLIED MARINE SDN BHD’
ORDER BY b.contract_no ASC
2017-03-20 14:54:39.432 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: separator null
2017-03-20 14:54:39.433 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: driver com.microsoft.sqlserver.jdbc.SQLServerDriver
2017-03-20 14:54:39.433 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: url jdbc:sqlserver://10.0.0.86:52916;databaseName=icon_test2
2017-03-20 14:54:39.433 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: outputType n_row
2017-03-20 14:54:39.617 +0800 org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl executeConnector
INFO: ### 14:54:39:617 - executeConnector - end
2017-03-20 14:54:44.024 +0800 org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl org.bonitasoft.forms.server.util.FormLogger internalLog
INFO: Username Form<C.6 Fuel and Fresh Water Debit Credit Note TEST–1.1.0$entry> Submitted Fields<ContractVessel (java.lang.String) => TANJUNG PUTERI 1 ; CustomerList (java.lang.String) => SAPURA KENCANA ALLIED MARINE SDN BHD ; > Process<C.6 Fuel and Fresh Water Debit Credit Note TEST 1.1.0> ### 14:54:44:020 - executeConnector - start
2017-03-20 14:54:44.035 +0800 org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl org.bonitasoft.forms.server.util.FormLogger internalLog
INFO: Username Form<C.6 Fuel and Fresh Water Debit Credit Note TEST–1.1.0$entry> Submitted Fields<ContractNo (java.lang.String) => SKAMSB/BOSSS/IOG/LOA/00632/15 ; ContractVessel (java.lang.String) => TANJUNG PUTERI 1 ; CustomerList (java.lang.String) => SAPURA KENCANA ALLIED MARINE SDN BHD ; > Process<C.6 Fuel and Fresh Water Debit Credit Note TEST 1.1.0> ### 14:54:44:033 - executeConnector - start
2017-03-20 14:54:44.048 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: username icon
2017-03-20 14:54:44.048 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: username icon
2017-03-20 14:54:44.048 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: password ******
2017-03-20 14:54:44.049 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: password ******
2017-03-20 14:54:44.049 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: script SELECT DISTINCT “dbo”.“setup_customer”.“customer_name”
FROM “dbo”.“setup_customer”
INNER JOIN “dbo”.“contract_main” ON “dbo”.“setup_customer”.“customer_no” = “dbo”.“contract_main”.“customer_code”
JOIN “dbo”.“setup_vessel” ON “dbo”.“contract_main”.“vessel_code” = “dbo”.“setup_vessel”.“vessel_code”
WHERE “contract_main”.“actual_onhire_date” IS NOT NULL AND “contract_main”.“contract_status” = ‘1’
AND “dbo”.“setup_vessel”.“vessel_name” = ‘TANJUNG PUTERI 1’
ORDER BY “dbo”.“setup_customer”.“customer_name” ASC
2017-03-20 14:54:44.049 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: script SELECT b.contract_no
FROM dbo.setup_customer AS a
INNER JOIN dbo.contract_main AS b
on a.customer_no = b.customer_code
JOIN dbo.setup_vessel AS c ON b.vessel_code = c.vessel_code
where b.actual_onhire_date IS NOT NULL and b.contract_status = ‘1’
and c.vessel_name = ‘TANJUNG PUTERI 1’
AND a.customer_name = ‘SAPURA KENCANA ALLIED MARINE SDN BHD’
ORDER BY b.contract_no ASC
2017-03-20 14:54:44.049 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: separator null
2017-03-20 14:54:44.049 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: separator null
2017-03-20 14:54:44.049 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: driver com.microsoft.sqlserver.jdbc.SQLServerDriver
2017-03-20 14:54:44.049 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: driver com.microsoft.sqlserver.jdbc.SQLServerDriver
2017-03-20 14:54:44.049 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: url jdbc:sqlserver://10.0.0.86:52916;databaseName=icon_test2
2017-03-20 14:54:44.050 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: outputType n_row
2017-03-20 14:54:44.050 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: url jdbc:sqlserver://10.0.0.86:52916;databaseName=icon_test2
2017-03-20 14:54:44.051 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: outputType n_row
2017-03-20 14:54:44.268 +0800 org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl executeConnector
INFO: ### 14:54:44:268 - executeConnector - end
2017-03-20 14:54:44.297 +0800 org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl executeConnector
INFO: ### 14:54:44:296 - executeConnector - end
2017-03-20 14:54:44.350 +0800 org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl org.bonitasoft.forms.server.util.FormLogger internalLog
INFO: Username Form<C.6 Fuel and Fresh Water Debit Credit Note TEST–1.1.0$entry> Submitted Fields<ContractNo (java.lang.String) => null ; ContractVessel (java.lang.String) => TANJUNG PUTERI 1 ; CustomerList (java.lang.String) => PETRONAS CARIGALI SDN BHD ; > Process<C.6 Fuel and Fresh Water Debit Credit Note TEST 1.1.0> ### 14:54:44:349 - executeConnector - start
2017-03-20 14:54:44.357 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: username icon
2017-03-20 14:54:44.357 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: password ******
2017-03-20 14:54:44.357 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: script SELECT b.contract_no
FROM dbo.setup_customer AS a
INNER JOIN dbo.contract_main AS b
on a.customer_no = b.customer_code
JOIN dbo.setup_vessel AS c ON b.vessel_code = c.vessel_code
where b.actual_onhire_date IS NOT NULL and b.contract_status = ‘1’
and c.vessel_name = ‘TANJUNG PUTERI 1’
AND a.customer_name = ‘PETRONAS CARIGALI SDN BHD’
ORDER BY b.contract_no ASC
2017-03-20 14:54:44.357 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: separator null
2017-03-20 14:54:44.357 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: driver com.microsoft.sqlserver.jdbc.SQLServerDriver
2017-03-20 14:54:44.357 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: url jdbc:sqlserver://10.0.0.86:52916;databaseName=icon_test2
2017-03-20 14:54:44.357 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: outputType n_row
2017-03-20 14:54:44.576 +0800 org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl executeConnector
INFO: ### 14:54:44:576 - executeConnector - end
2017-03-20 14:54:48.805 +0800 org.bonitasoft.engine.api.impl.ProcessStarter org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl log
INFO: THREAD_ID=77 | HOSTNAME=FSB-MIRA | TENANT_ID=1 | The user has started the process instance <6001> of process <C.6 Fuel and Fresh Water Debit Credit Note TEST> in version <1.1.0> and id <7739187110568227399>
2017-03-20 14:54:49.092 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: username icon
2017-03-20 14:54:49.092 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: password ******
2017-03-20 14:54:49.092 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: script SELECT “a”.“contract_name”, “b”.“vessel_name”, “a”.“actual_onhire_date”,
“a”.“primary_offhire_date”, “a”.“contract_currency”, “c”.“customer_no”, “c”.“customer_name”
FROM “dbo”.“contract_main” AS “a”
INNER JOIN “dbo”.“setup_vessel” AS “b” ON “a”.“vessel_code” = “b”.“vessel_code”
JOIN “dbo”.“setup_customer” AS “c” ON “a”.“customer_code” = “c”.“customer_no”
WHERE “a”.“contract_no” = ‘CHO/2012/LOGISTICS(CHO)/0002’

2017-03-20 14:54:49.092 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: separator null
2017-03-20 14:54:49.092 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: driver com.microsoft.sqlserver.jdbc.SQLServerDriver
2017-03-20 14:54:49.093 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: url jdbc:sqlserver://10.0.0.86:52916;databaseName=icon_test2
2017-03-20 14:54:49.093 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: outputType one_row
2017-03-20 14:54:49.465 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: username icon
2017-03-20 14:54:49.469 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: password ******
2017-03-20 14:54:49.470 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: script SELECT TOP 1 “actual_offshire_date”
FROM “dbo”.“contract_extension”
WHERE “contract_no” = ‘CHO/2012/LOGISTICS(CHO)/0002’
ORDER BY “extension_id” DESC
2017-03-20 14:54:49.470 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: separator null
2017-03-20 14:54:49.470 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: driver com.microsoft.sqlserver.jdbc.SQLServerDriver
2017-03-20 14:54:49.470 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: url jdbc:sqlserver://10.0.0.86:52916;databaseName=icon_test2
2017-03-20 14:54:49.470 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: outputType single
2017-03-20 14:54:49.784 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: username icon
2017-03-20 14:54:49.784 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: password ******
2017-03-20 14:54:49.785 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: script SELECT “setup_vessel”.“vessel_name”
FROM “setup_vessel” INNER JOIN “setup_invoice_flow” ON “setup_vessel”.“vessel_code” = “setup_invoice_flow”.“vessel_code”
WHERE “setup_vessel”.“vessel_status” = ‘1’
ORDER BY “setup_vessel”.“vessel_name” ASC

2017-03-20 14:54:49.785 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: separator null
2017-03-20 14:54:49.785 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: driver com.microsoft.sqlserver.jdbc.SQLServerDriver
2017-03-20 14:54:49.785 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: url jdbc:sqlserver://10.0.0.86:52916;databaseName=icon_test2
2017-03-20 14:54:49.785 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: outputType n_row
2017-03-20 14:54:58.273 +0800 org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl org.bonitasoft.forms.server.util.FormLogger internalLog
INFO: Username Form<C.6 Fuel and Fresh Water Debit Credit Note TEST–1.1.0–Create Fuel & Fresh Water Debit/Credit Note$entry> Task<Create Fuel & Fresh Water Debit/Credit Note> ### 14:54:58:273 - executeConnector - start
2017-03-20 14:54:58.286 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: username icon
2017-03-20 14:54:58.286 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: password ******
2017-03-20 14:54:58.286 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: script SELECT “account_no”
FROM “dbo”.“setup_bank_details”
WHERE “account_currency” = ‘MYR’ AND “bank_status” = ‘1’

2017-03-20 14:54:58.286 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: separator null
2017-03-20 14:54:58.286 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: driver com.microsoft.sqlserver.jdbc.SQLServerDriver
2017-03-20 14:54:58.287 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: url jdbc:sqlserver://10.0.0.86:52916;databaseName=icon_test2
2017-03-20 14:54:58.287 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: outputType n_row
2017-03-20 14:54:58.489 +0800 org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl executeConnector
INFO: ### 14:54:58:489 - executeConnector - end
2017-03-20 14:54:58.490 +0800 org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl org.bonitasoft.forms.server.util.FormLogger internalLog
INFO: Username Form<C.6 Fuel and Fresh Water Debit Credit Note TEST–1.1.0–Create Fuel & Fresh Water Debit/Credit Note$entry> Task<Create Fuel & Fresh Water Debit/Credit Note> ### 14:54:58:490 - executeConnector - start
2017-03-20 14:54:58.502 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: username icon
2017-03-20 14:54:58.502 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: password ******
2017-03-20 14:54:58.503 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: script SELECT DISTINCT “bank_name”
FROM “dbo”.“setup_bank_details”
WHERE “account_currency” = ‘MYR’ AND “bank_status” = ‘1’

2017-03-20 14:54:58.503 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: separator null
2017-03-20 14:54:58.503 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: driver com.microsoft.sqlserver.jdbc.SQLServerDriver
2017-03-20 14:54:58.504 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: url jdbc:sqlserver://10.0.0.86:52916;databaseName=icon_test2
2017-03-20 14:54:58.504 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: outputType n_row
2017-03-20 14:54:58.678 +0800 org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl executeConnector
INFO: ### 14:54:58:678 - executeConnector - end
2017-03-20 14:54:58.678 +0800 org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl org.bonitasoft.forms.server.util.FormLogger internalLog
INFO: Username Form<C.6 Fuel and Fresh Water Debit Credit Note TEST–1.1.0–Create Fuel & Fresh Water Debit/Credit Note$entry> Task<Create Fuel & Fresh Water Debit/Credit Note> ### 14:54:58:678 - executeConnector - start
2017-03-20 14:54:58.688 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: username icon
2017-03-20 14:54:58.688 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: password ******
2017-03-20 14:54:58.688 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: script SELECT DISTINCT “beneficiary”
FROM “dbo”.“setup_bank_details”
WHERE “account_currency” = ‘MYR’ AND “bank_status” = ‘1’

2017-03-20 14:54:58.688 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: separator null
2017-03-20 14:54:58.688 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: driver com.microsoft.sqlserver.jdbc.SQLServerDriver
2017-03-20 14:54:58.688 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: url jdbc:sqlserver://10.0.0.86:52916;databaseName=icon_test2
2017-03-20 14:54:58.689 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: outputType n_row
2017-03-20 14:54:58.868 +0800 org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl executeConnector
INFO: ### 14:54:58:868 - executeConnector - end
2017-03-20 14:55:06.345 +0800 org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl org.bonitasoft.forms.server.util.FormLogger internalLog
INFO: Username Form<C.6 Fuel and Fresh Water Debit Credit Note TEST–1.1.0–Create Fuel & Fresh Water Debit/Credit Note$entry> Task<Create Fuel & Fresh Water Debit/Credit Note> There are no steps waiting in inbox.
2017-03-20 14:55:07.034 +0800 org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl org.bonitasoft.forms.server.util.FormLogger internalLog
INFO: Username Form<C.6 Fuel and Fresh Water Debit Credit Note TEST–1.1.0–Create Fuel & Fresh Water Debit/Credit Note$entry> Task<Create Fuel & Fresh Water Debit/Credit Note> ### 14:55:07:034 - executeConnector - start
2017-03-20 14:55:07.044 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: username icon
2017-03-20 14:55:07.044 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: password ******
2017-03-20 14:55:07.044 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: script SELECT “account_no”
FROM “dbo”.“setup_bank_details”
WHERE “account_currency” = ‘MYR’ AND “bank_status” = ‘1’

2017-03-20 14:55:07.045 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: separator null
2017-03-20 14:55:07.045 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: driver com.microsoft.sqlserver.jdbc.SQLServerDriver
2017-03-20 14:55:07.045 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: url jdbc:sqlserver://10.0.0.86:52916;databaseName=icon_test2
2017-03-20 14:55:07.045 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: outputType n_row
2017-03-20 14:55:07.247 +0800 org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl executeConnector
INFO: ### 14:55:07:247 - executeConnector - end
2017-03-20 14:55:07.248 +0800 org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl org.bonitasoft.forms.server.util.FormLogger internalLog
INFO: Username Form<C.6 Fuel and Fresh Water Debit Credit Note TEST–1.1.0–Create Fuel & Fresh Water Debit/Credit Note$entry> Task<Create Fuel & Fresh Water Debit/Credit Note> ### 14:55:07:248 - executeConnector - start
2017-03-20 14:55:07.274 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: username icon
2017-03-20 14:55:07.274 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: password ******
2017-03-20 14:55:07.275 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: script SELECT DISTINCT “bank_name”
FROM “dbo”.“setup_bank_details”
WHERE “account_currency” = ‘MYR’ AND “bank_status” = ‘1’

2017-03-20 14:55:07.275 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: separator null
2017-03-20 14:55:07.275 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: driver com.microsoft.sqlserver.jdbc.SQLServerDriver
2017-03-20 14:55:07.275 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: url jdbc:sqlserver://10.0.0.86:52916;databaseName=icon_test2
2017-03-20 14:55:07.275 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: outputType n_row
2017-03-20 14:55:07.464 +0800 org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl executeConnector
INFO: ### 14:55:07:464 - executeConnector - end
2017-03-20 14:55:07.466 +0800 org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl org.bonitasoft.forms.server.util.FormLogger internalLog
INFO: Username Form<C.6 Fuel and Fresh Water Debit Credit Note TEST–1.1.0–Create Fuel & Fresh Water Debit/Credit Note$entry> Task<Create Fuel & Fresh Water Debit/Credit Note> ### 14:55:07:465 - executeConnector - start
2017-03-20 14:55:07.487 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: username icon
2017-03-20 14:55:07.488 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: password ******
2017-03-20 14:55:07.488 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: script SELECT DISTINCT “beneficiary”
FROM “dbo”.“setup_bank_details”
WHERE “account_currency” = ‘MYR’ AND “bank_status” = ‘1’

2017-03-20 14:55:07.488 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: separator null
2017-03-20 14:55:07.488 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: driver com.microsoft.sqlserver.jdbc.SQLServerDriver
2017-03-20 14:55:07.488 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: url jdbc:sqlserver://10.0.0.86:52916;databaseName=icon_test2
2017-03-20 14:55:07.488 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: outputType n_row
2017-03-20 14:55:07.720 +0800 org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl executeConnector
INFO: ### 14:55:07:720 - executeConnector - end
2017-03-20 16:02:45.288 +0800 org.bonitasoft.forms.server.FormsServlet org.bonitasoft.forms.server.FormsServlet retrieveCredentialAndReturnTenantID
WARNING: There is no user in the HTTP session.
2017-03-20 16:02:45.289 +0800 org.bonitasoft.forms.server.FormsServletExt org.bonitasoft.forms.server.FormsServletExt getFormFieldUpdatedValue
INFO: Session timeout
2017-03-20 16:02:45.353 +0800 org.bonitasoft.console.common.server.login.datastore.LoginDatastoreExt org.bonitasoft.console.common.server.login.datastore.LoginDatastoreExt login
INFO: Impossible to login on the engine API : No user or password
2017-03-20 16:02:45.354 +0800 org.bonitasoft.console.common.server.login.datastore.LoginDatastoreExt org.bonitasoft.console.common.server.login.datastore.LoginDatastoreExt login
INFO: Error while logging in the engine API: javax.security.auth.login.LoginException: Impossible to login on the engine API : No user or password
2017-03-20 16:02:54.994 +0800 org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl org.bonitasoft.forms.server.util.FormLogger internalLog
INFO: Username Form<C.6 Fuel and Fresh Water Debit Credit Note TEST–1.1.0$entry> Process<C.6 Fuel and Fresh Water Debit Credit Note TEST 1.1.0> ### 16:02:54:994 - executeConnector - start
2017-03-20 16:02:55.053 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: username icon
2017-03-20 16:02:55.058 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: password ******
2017-03-20 16:02:55.059 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: script SELECT DISTINCT “c”.“vessel_name”
FROM “contract_main” AS “a” INNER JOIN “setup_vessel” AS “c” ON “a”.“vessel_code” = “c”.“vessel_code”
WHERE “actual_onhire_date” IS NOT NULL AND “contract_status” = ‘1’
ORDER BY “c”.“vessel_name” ASC

2017-03-20 16:02:55.059 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: separator null
2017-03-20 16:02:55.059 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: driver com.microsoft.sqlserver.jdbc.SQLServerDriver
2017-03-20 16:02:55.060 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: url jdbc:sqlserver://10.0.0.86:52916;databaseName=icon_test2
2017-03-20 16:02:55.060 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: outputType n_row
2017-03-20 16:02:55.239 +0800 org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl executeConnector
INFO: ### 16:02:55:239 - executeConnector - end
2017-03-20 16:03:00.065 +0800 org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl org.bonitasoft.forms.server.util.FormLogger internalLog
INFO: Username Form<C.6 Fuel and Fresh Water Debit Credit Note TEST–1.1.0$entry> Submitted Fields<ContractVessel (java.lang.String) => TANJUNG PUTERI 1 ; CustomerList (java.lang.String) => – Please Select – ; > Process<C.6 Fuel and Fresh Water Debit Credit Note TEST 1.1.0> ### 16:03:00:064 - executeConnector - start
2017-03-20 16:03:00.067 +0800 org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl org.bonitasoft.forms.server.util.FormLogger internalLog
INFO: Username Form<C.6 Fuel and Fresh Water Debit Credit Note TEST–1.1.0$entry> Submitted Fields<ContractNo (java.lang.String) => – Please Select – ; ContractVessel (java.lang.String) => TANJUNG PUTERI 1 ; CustomerList (java.lang.String) => – Please Select – ; > Process<C.6 Fuel and Fresh Water Debit Credit Note TEST 1.1.0> ### 16:03:00:067 - executeConnector - start
2017-03-20 16:03:00.070 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: username icon
2017-03-20 16:03:00.071 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: password ******
2017-03-20 16:03:00.071 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: script SELECT DISTINCT “dbo”.“setup_customer”.“customer_name”
FROM “dbo”.“setup_customer”
INNER JOIN “dbo”.“contract_main” ON “dbo”.“setup_customer”.“customer_no” = “dbo”.“contract_main”.“customer_code”
JOIN “dbo”.“setup_vessel” ON “dbo”.“contract_main”.“vessel_code” = “dbo”.“setup_vessel”.“vessel_code”
WHERE “contract_main”.“actual_onhire_date” IS NOT NULL AND “contract_main”.“contract_status” = ‘1’
AND “dbo”.“setup_vessel”.“vessel_name” = ‘TANJUNG PUTERI 1’
ORDER BY “dbo”.“setup_customer”.“customer_name” ASC
2017-03-20 16:03:00.071 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: separator null
2017-03-20 16:03:00.071 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: driver com.microsoft.sqlserver.jdbc.SQLServerDriver
2017-03-20 16:03:00.072 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: url jdbc:sqlserver://10.0.0.86:52916;databaseName=icon_test2
2017-03-20 16:03:00.072 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: outputType n_row
2017-03-20 16:03:00.074 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: username icon
2017-03-20 16:03:00.074 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: password ******
2017-03-20 16:03:00.074 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: script SELECT b.contract_no
FROM dbo.setup_customer AS a
INNER JOIN dbo.contract_main AS b
on a.customer_no = b.customer_code
JOIN dbo.setup_vessel AS c ON b.vessel_code = c.vessel_code
where b.actual_onhire_date IS NOT NULL and b.contract_status = ‘1’
and c.vessel_name = ‘TANJUNG PUTERI 1’
AND a.customer_name = ‘-- Please Select --’
ORDER BY b.contract_no ASC
2017-03-20 16:03:00.074 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: separator null
2017-03-20 16:03:00.074 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: driver com.microsoft.sqlserver.jdbc.SQLServerDriver
2017-03-20 16:03:00.075 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: url jdbc:sqlserver://10.0.0.86:52916;databaseName=icon_test2
2017-03-20 16:03:00.075 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: outputType n_row
2017-03-20 16:03:00.327 +0800 org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl executeConnector
INFO: ### 16:03:00:327 - executeConnector - end
2017-03-20 16:03:00.327 +0800 org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl executeConnector
INFO: ### 16:03:00:327 - executeConnector - end
2017-03-20 16:03:00.379 +0800 org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl org.bonitasoft.forms.server.util.FormLogger internalLog
INFO: Username Form<C.6 Fuel and Fresh Water Debit Credit Note TEST–1.1.0$entry> Submitted Fields<ContractNo (java.lang.String) => null ; ContractVessel (java.lang.String) => TANJUNG PUTERI 1 ; CustomerList (java.lang.String) => PETRONAS CARIGALI SDN BHD ; > Process<C.6 Fuel and Fresh Water Debit Credit Note TEST 1.1.0> ### 16:03:00:378 - executeConnector - start
2017-03-20 16:03:00.382 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: username icon
2017-03-20 16:03:00.383 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: password ******
2017-03-20 16:03:00.383 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: script SELECT b.contract_no
FROM dbo.setup_customer AS a
INNER JOIN dbo.contract_main AS b
on a.customer_no = b.customer_code
JOIN dbo.setup_vessel AS c ON b.vessel_code = c.vessel_code
where b.actual_onhire_date IS NOT NULL and b.contract_status = ‘1’
and c.vessel_name = ‘TANJUNG PUTERI 1’
AND a.customer_name = ‘PETRONAS CARIGALI SDN BHD’
ORDER BY b.contract_no ASC
2017-03-20 16:03:00.383 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: separator null
2017-03-20 16:03:00.383 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: driver com.microsoft.sqlserver.jdbc.SQLServerDriver
2017-03-20 16:03:00.383 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: url jdbc:sqlserver://10.0.0.86:52916;databaseName=icon_test2
2017-03-20 16:03:00.383 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: outputType n_row
2017-03-20 16:03:00.590 +0800 org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl executeConnector
INFO: ### 16:03:00:590 - executeConnector - end
2017-03-20 16:03:01.664 +0800 org.bonitasoft.engine.api.impl.ProcessStarter org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl log
INFO: THREAD_ID=69 | HOSTNAME=FSB-MIRA | TENANT_ID=1 | The user has started the process instance <6002> of process <C.6 Fuel and Fresh Water Debit Credit Note TEST> in version <1.1.0> and id <7739187110568227399>
2017-03-20 16:03:01.824 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: username icon
2017-03-20 16:03:01.824 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: password ******
2017-03-20 16:03:01.825 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: script SELECT “a”.“contract_name”, “b”.“vessel_name”, “a”.“actual_onhire_date”,
“a”.“primary_offhire_date”, “a”.“contract_currency”, “c”.“customer_no”, “c”.“customer_name”
FROM “dbo”.“contract_main” AS “a”
INNER JOIN “dbo”.“setup_vessel” AS “b” ON “a”.“vessel_code” = “b”.“vessel_code”
JOIN “dbo”.“setup_customer” AS “c” ON “a”.“customer_code” = “c”.“customer_no”
WHERE “a”.“contract_no” = ‘CHO/2012/LOGISTICS(CHO)/0002’

2017-03-20 16:03:01.825 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: separator null
2017-03-20 16:03:01.825 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: driver com.microsoft.sqlserver.jdbc.SQLServerDriver
2017-03-20 16:03:01.825 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: url jdbc:sqlserver://10.0.0.86:52916;databaseName=icon_test2
2017-03-20 16:03:01.825 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: outputType one_row
2017-03-20 16:03:02.068 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: username icon
2017-03-20 16:03:02.069 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: password ******
2017-03-20 16:03:02.069 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: script SELECT TOP 1 “actual_offshire_date”
FROM “dbo”.“contract_extension”
WHERE “contract_no” = ‘CHO/2012/LOGISTICS(CHO)/0002’
ORDER BY “extension_id” DESC
2017-03-20 16:03:02.069 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: separator null
2017-03-20 16:03:02.069 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: driver com.microsoft.sqlserver.jdbc.SQLServerDriver
2017-03-20 16:03:02.069 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: url jdbc:sqlserver://10.0.0.86:52916;databaseName=icon_test2
2017-03-20 16:03:02.069 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: outputType single
2017-03-20 16:03:02.286 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: username icon
2017-03-20 16:03:02.286 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: password ******
2017-03-20 16:03:02.287 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: script SELECT “setup_vessel”.“vessel_name”
FROM “setup_vessel” INNER JOIN “setup_invoice_flow” ON “setup_vessel”.“vessel_code” = “setup_invoice_flow”.“vessel_code”
WHERE “setup_vessel”.“vessel_status” = ‘1’
ORDER BY “setup_vessel”.“vessel_name” ASC

2017-03-20 16:03:02.287 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: separator null
2017-03-20 16:03:02.287 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: driver com.microsoft.sqlserver.jdbc.SQLServerDriver
2017-03-20 16:03:02.287 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: url jdbc:sqlserver://10.0.0.86:52916;databaseName=icon_test2
2017-03-20 16:03:02.288 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: outputType n_row
2017-03-20 16:03:05.501 +0800 org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl org.bonitasoft.forms.server.util.FormLogger internalLog
INFO: Username Form<C.6 Fuel and Fresh Water Debit Credit Note TEST–1.1.0–Create Fuel & Fresh Water Debit/Credit Note$entry> Task<Create Fuel & Fresh Water Debit/Credit Note> ### 16:03:05:501 - executeConnector - start
2017-03-20 16:03:05.511 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: username icon
2017-03-20 16:03:05.511 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: password ******
2017-03-20 16:03:05.511 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: script SELECT “account_no”
FROM “dbo”.“setup_bank_details”
WHERE “account_currency” = ‘MYR’ AND “bank_status” = ‘1’

2017-03-20 16:03:05.511 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: separator null
2017-03-20 16:03:05.511 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: driver com.microsoft.sqlserver.jdbc.SQLServerDriver
2017-03-20 16:03:05.511 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: url jdbc:sqlserver://10.0.0.86:52916;databaseName=icon_test2
2017-03-20 16:03:05.511 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: outputType n_row
2017-03-20 16:03:05.778 +0800 org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl executeConnector
INFO: ### 16:03:05:777 - executeConnector - end
2017-03-20 16:03:05.778 +0800 org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl org.bonitasoft.forms.server.util.FormLogger internalLog
INFO: Username Form<C.6 Fuel and Fresh Water Debit Credit Note TEST–1.1.0–Create Fuel & Fresh Water Debit/Credit Note$entry> Task<Create Fuel & Fresh Water Debit/Credit Note> ### 16:03:05:778 - executeConnector - start
2017-03-20 16:03:05.803 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: username icon
2017-03-20 16:03:05.803 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: password ******
2017-03-20 16:03:05.804 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: script SELECT DISTINCT “bank_name”
FROM “dbo”.“setup_bank_details”
WHERE “account_currency” = ‘MYR’ AND “bank_status” = ‘1’

2017-03-20 16:03:05.804 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: separator null
2017-03-20 16:03:05.804 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: driver com.microsoft.sqlserver.jdbc.SQLServerDriver
2017-03-20 16:03:05.804 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: url jdbc:sqlserver://10.0.0.86:52916;databaseName=icon_test2
2017-03-20 16:03:05.804 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: outputType n_row
2017-03-20 16:03:06.042 +0800 org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl executeConnector
INFO: ### 16:03:06:042 - executeConnector - end
2017-03-20 16:03:06.043 +0800 org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl org.bonitasoft.forms.server.util.FormLogger internalLog
INFO: Username Form<C.6 Fuel and Fresh Water Debit Credit Note TEST–1.1.0–Create Fuel & Fresh Water Debit/Credit Note$entry> Task<Create Fuel & Fresh Water Debit/Credit Note> ### 16:03:06:043 - executeConnector - start
2017-03-20 16:03:06.073 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: username icon
2017-03-20 16:03:06.074 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: password ******
2017-03-20 16:03:06.074 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: script SELECT DISTINCT “beneficiary”
FROM “dbo”.“setup_bank_details”
WHERE “account_currency” = ‘MYR’ AND “bank_status” = ‘1’

2017-03-20 16:03:06.074 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: separator null
2017-03-20 16:03:06.075 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: driver com.microsoft.sqlserver.jdbc.SQLServerDriver
2017-03-20 16:03:06.075 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: url jdbc:sqlserver://10.0.0.86:52916;databaseName=icon_test2
2017-03-20 16:03:06.075 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: outputType n_row
2017-03-20 16:03:06.416 +0800 org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl executeConnector
INFO: ### 16:03:06:416 - executeConnector - end
2017-03-20 16:03:19.639 +0800 org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl org.bonitasoft.forms.server.util.FormLogger internalLog
INFO: Username Form<C.6 Fuel and Fresh Water Debit Credit Note TEST–1.1.0–Create Fuel & Fresh Water Debit/Credit Note$entry> Submitted Fields<vesselCode1 (java.lang.String) => ; VesselAtWork1 (java.lang.String) => TANJUNG PUTERI 1 ; > Task<Create Fuel & Fresh Water Debit/Credit Note> ### 16:03:19:638 - executeConnector - start
2017-03-20 16:03:19.655 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: username icon
2017-03-20 16:03:19.655 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: password ******
2017-03-20 16:03:19.655 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: script SELECT “vessel_code”
FROM “dbo”.“setup_vessel”
WHERE “vessel_name” = ‘TANJUNG PUTERI 1’

2017-03-20 16:03:19.655 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: separator null
2017-03-20 16:03:19.655 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: driver com.microsoft.sqlserver.jdbc.SQLServerDriver
2017-03-20 16:03:19.656 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: url jdbc:sqlserver://10.0.0.86:52916;databaseName=icon_test2
2017-03-20 16:03:19.656 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: outputType single
2017-03-20 16:03:19.860 +0800 org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl executeConnector
INFO: ### 16:03:19:860 - executeConnector - end
2017-03-20 16:03:19.891 +0800 org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl org.bonitasoft.forms.server.util.FormLogger internalLog
INFO: Username Form<C.6 Fuel and Fresh Water Debit Credit Note TEST–1.1.0–Create Fuel & Fresh Water Debit/Credit Note$entry> Submitted Fields<vesselCode1 (java.lang.String) => 1101 ; smCode1 (java.lang.String) => ; > Task<Create Fuel & Fresh Water Debit/Credit Note> ### 16:03:19:891 - executeConnector - start
2017-03-20 16:03:19.906 +0800 org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl org.bonitasoft.forms.server.util.FormLogger internalLog
INFO: Username Form<C.6 Fuel and Fresh Water Debit Credit Note TEST–1.1.0–Create Fuel & Fresh Water Debit/Credit Note$entry> Submitted Fields<vesselCode1 (java.lang.String) => 1101 ; coCode1 (java.lang.String) => ; > Task<Create Fuel & Fresh Water Debit/Credit Note> ### 16:03:19:905 - executeConnector - start
2017-03-20 16:03:19.906 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: username icon
2017-03-20 16:03:19.906 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: password ******
2017-03-20 16:03:19.906 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: script SELECT “sm_entity_no”
FROM “setup_invoice_flow”
WHERE “vessel_code” = ‘1101’

2017-03-20 16:03:19.906 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: separator null
2017-03-20 16:03:19.906 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: driver com.microsoft.sqlserver.jdbc.SQLServerDriver
2017-03-20 16:03:19.906 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: url jdbc:sqlserver://10.0.0.86:52916;databaseName=icon_test2
2017-03-20 16:03:19.906 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: outputType single
2017-03-20 16:03:19.915 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: username icon
2017-03-20 16:03:19.916 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: password ******
2017-03-20 16:03:19.916 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: script SELECT “co_entity_no”
FROM “setup_invoice_flow”
WHERE “vessel_code” = ‘1101’
2017-03-20 16:03:19.916 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: separator null
2017-03-20 16:03:19.916 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: driver com.microsoft.sqlserver.jdbc.SQLServerDriver
2017-03-20 16:03:19.916 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: url jdbc:sqlserver://10.0.0.86:52916;databaseName=icon_test2
2017-03-20 16:03:19.916 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: outputType single
2017-03-20 16:03:20.117 +0800 org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl executeConnector
INFO: ### 16:03:20:117 - executeConnector - end
2017-03-20 16:03:20.127 +0800 org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl executeConnector
INFO: ### 16:03:20:127 - executeConnector - end
2017-03-20 16:03:20.137 +0800 org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl org.bonitasoft.forms.server.util.FormLogger internalLog
INFO: Username Form<C.6 Fuel and Fresh Water Debit Credit Note TEST–1.1.0–Create Fuel & Fresh Water Debit/Credit Note$entry> Submitted Fields<smCode1 (java.lang.String) => 12000 ; smEntityName1 (java.lang.String) => ; > Task<Create Fuel & Fresh Water Debit/Credit Note> ### 16:03:20:137 - executeConnector - start
2017-03-20 16:03:20.150 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: username icon
2017-03-20 16:03:20.150 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: password ******
2017-03-20 16:03:20.150 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: script SELECT “entity_name”
FROM “setup_entity”
WHERE “entity_no” = ‘12000’

2017-03-20 16:03:20.150 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: separator null
2017-03-20 16:03:20.150 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: driver com.microsoft.sqlserver.jdbc.SQLServerDriver
2017-03-20 16:03:20.151 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: url jdbc:sqlserver://10.0.0.86:52916;databaseName=icon_test2
2017-03-20 16:03:20.151 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: outputType single
2017-03-20 16:03:20.166 +0800 org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl org.bonitasoft.forms.server.util.FormLogger internalLog
INFO: Username Form<C.6 Fuel and Fresh Water Debit Credit Note TEST–1.1.0–Create Fuel & Fresh Water Debit/Credit Note$entry> Submitted Fields<coCode1 (java.lang.String) => 11000 ; coEntityName1 (java.lang.String) => ; > Task<Create Fuel & Fresh Water Debit/Credit Note> ### 16:03:20:166 - executeConnector - start
2017-03-20 16:03:20.176 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: username icon
2017-03-20 16:03:20.177 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: password ******
2017-03-20 16:03:20.177 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: script SELECT “entity_name”
FROM “setup_entity”
WHERE “entity_no” = ‘11000’

2017-03-20 16:03:20.177 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: separator null
2017-03-20 16:03:20.177 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: driver com.microsoft.sqlserver.jdbc.SQLServerDriver
2017-03-20 16:03:20.177 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: url jdbc:sqlserver://10.0.0.86:52916;databaseName=icon_test2
2017-03-20 16:03:20.177 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: outputType single
2017-03-20 16:03:20.692 +0800 org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl executeConnector
INFO: ### 16:03:20:692 - executeConnector - end
2017-03-20 16:03:20.692 +0800 org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl executeConnector
INFO: ### 16:03:20:692 - executeConnector - end
2017-03-20 16:03:58.242 +0800 org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl org.bonitasoft.forms.server.util.FormLogger internalLog
INFO: Username Form<C.6 Fuel and Fresh Water Debit Credit Note TEST–1.1.0–Create Fuel & Fresh Water Debit/Credit Note$entry> Submitted Fields<coGSTamount1 (java.lang.String) => 0.0 ; vesselCode1 (java.lang.String) => 1101 ; Next1 (java.lang.Boolean) => false ; fwQtyOffhire1 (java.lang.String) => 0.0 ; coDiscount1 (java.lang.String) => 0.0 ; ApproverComment1 (java.lang.String) => ; fuelRemarkOnhire1 (java.lang.String) => ; fuelAmountOnhire1 (java.lang.String) => 0.0 ; customerName1 (java.lang.String) => PETRONAS CARIGALI SDN BHD ; currExRate1 (java.lang.String) => ; coCode1 (java.lang.String) => 11000 ; coGrandTotal1 (java.lang.String) => 0.0 ; coCurr (java.lang.String) => MYR ; sm1 (java.lang.String) => ICON SHIP MANAGEMENT SDN BHD ; fwDifferenceAmount1 (java.lang.String) => 0.0 ; Copy_of_measureUnit1 (java.lang.String) => LITRE ; smAdminFee1 (java.lang.String) => 0.0 ; Submit6 (java.lang.Boolean) => false ; Submit2 (java.lang.Boolean) => false ; Submit3 (java.lang.Boolean) => true ; coGSTRate (java.lang.String) => SR-6% ; fuelDifferenceQty1 (java.lang.String) => 0.0 ; fwQtyOnhire1 (java.lang.String) => 0.0 ; ApproverName1 (java.lang.String) => ; Previous2 (java.lang.Boolean) => false ; VesselAtWork1 (java.lang.String) => TANJUNG PUTERI 1 ; fuelRateOnhire1 (java.lang.String) => 0.0000 ; Previous1 (java.lang.Boolean) => false ; fuelRateOffhire1 (java.lang.String) => 0.0000 ; smTotal1 (java.lang.String) => 0.0 ; fuelAmountOffhire1 (java.lang.String) => 0.0 ; fwAmountOnhire1 (java.lang.String) => 0.0 ; smGrandTotal1 (java.lang.String) => 0.0 ; vesselOffhireDate1 (java.util.Date) => Wed Mar 01 00:00:00 SGT 2017 ; actualOffhire1 (java.lang.String) => 31/12/2017 ; smGSTrate (java.lang.String) => GS-0% ; fuelRemarkOffhire1 (java.lang.String) => ; RateSMCO (java.lang.String) => ; co1 (java.lang.String) => ICON OFFSHORE GROUP SDN BHD ; coAdminFee1 (java.lang.String) => 0.0 ; fwDifferenceQty1 (java.lang.String) => 0.0 ; fwRateOnhire1 (java.lang.String) => 0.000000 ; endTime1 (java.lang.String) => 24:00 ; fuelDifferenceAmount1 (java.lang.String) => 0.0 ; fwRateOffhire1 (java.lang.String) => 0.000000 ; fwAmountOffhire1 (java.lang.String) => 0.0 ; fuelQtyOnhire1 (java.lang.String) => 0.0 ; primaryOffhire1 (java.lang.String) => 31/12/2017 ; startTime1 (java.lang.String) => 00:00 ; vesselOnhireDate1 (java.util.Date) => Wed Mar 01 00:00:00 SGT 2017 ; coEntityName1 (java.lang.String) => ICON OFFSHORE GROUP SDN BHD ; smGSTamount1 (java.lang.String) => 0.0 ; coSubtotal1 (java.lang.String) => 0.0 ; coTotal1 (java.lang.String) => 0.0 ; contractName1 (java.lang.String) => PROV. OF SIX (6) STRAIGHT SUPPLY VESSELS FOR PETRONAS CARIGALI BASE FLEET (“CONTRACT”) ; smDiscount1 (java.lang.String) => 0.0 ; contractNo1 (java.lang.String) => CHO/2012/LOGISTICS(CHO)/0002 ; smCurr (java.lang.String) => MYR ; smSubtotal1 (java.lang.String) => 0.0 ; currency1 (java.lang.String) => MYR ; actualOnhire1 (java.lang.String) => 01/01/2013 ; fuelQtyOffhire1 (java.lang.String) => 0.0 ; measureUnit1 (java.lang.String) => LITRE ; ReviewerComment1 (java.lang.String) => ; smCode1 (java.lang.String) => 12000 ; ReviewerName1 (java.lang.String) => ; smEntityName1 (java.lang.String) => ICON SHIP MANAGEMENT SDN BHD ; contractVessel1 (java.lang.String) => TANJUNG PUTERI 1 ; > Task<Create Fuel & Fresh Water Debit/Credit Note> ### 16:03:58:242 - executeConnector - start
2017-03-20 16:03:58.250 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: username icon
2017-03-20 16:03:58.250 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: password ******
2017-03-20 16:03:58.250 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: script SELECT DISTINCT “dbo”.“setup_bank_details”.“beneficiary”
FROM “dbo”.“setup_bank_details”, “dbo”.“setup_entity”
WHERE “dbo”.“setup_bank_details”.“beneficiary” = “dbo”.“setup_entity”.“entity_beneficiary”
AND “dbo”.“setup_entity”.“entity_no” = ‘12000’

2017-03-20 16:03:58.251 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: separator null
2017-03-20 16:03:58.251 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: driver com.microsoft.sqlserver.jdbc.SQLServerDriver
2017-03-20 16:03:58.251 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: url jdbc:sqlserver://10.0.0.86:52916;databaseName=icon_test2
2017-03-20 16:03:58.251 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: outputType single
2017-03-20 16:03:58.433 +0800 org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl executeConnector
INFO: ### 16:03:58:433 - executeConnector - end
2017-03-20 16:03:58.435 +0800 org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl org.bonitasoft.forms.server.util.FormLogger internalLog
INFO: Username Form<C.6 Fuel and Fresh Water Debit Credit Note TEST–1.1.0–Create Fuel & Fresh Water Debit/Credit Note$entry> Submitted Fields<coGSTamount1 (java.lang.String) => 0.0 ; vesselCode1 (java.lang.String) => 1101 ; Next1 (java.lang.Boolean) => false ; fwQtyOffhire1 (java.lang.String) => 0.0 ; coDiscount1 (java.lang.String) => 0.0 ; ApproverComment1 (java.lang.String) => ; fuelRemarkOnhire1 (java.lang.String) => ; fuelAmountOnhire1 (java.lang.String) => 0.0 ; customerName1 (java.lang.String) => PETRONAS CARIGALI SDN BHD ; currExRate1 (java.lang.String) => ; coCode1 (java.lang.String) => 11000 ; coGrandTotal1 (java.lang.String) => 0.0 ; coCurr (java.lang.String) => MYR ; sm1 (java.lang.String) => ICON SHIP MANAGEMENT SDN BHD ; fwDifferenceAmount1 (java.lang.String) => 0.0 ; Copy_of_measureUnit1 (java.lang.String) => LITRE ; smAdminFee1 (java.lang.String) => 0.0 ; Submit6 (java.lang.Boolean) => false ; Submit2 (java.lang.Boolean) => false ; Submit3 (java.lang.Boolean) => true ; coGSTRate (java.lang.String) => SR-6% ; fuelDifferenceQty1 (java.lang.String) => 0.0 ; fwQtyOnhire1 (java.lang.String) => 0.0 ; ApproverName1 (java.lang.String) => ; Previous2 (java.lang.Boolean) => false ; VesselAtWork1 (java.lang.String) => TANJUNG PUTERI 1 ; fuelRateOnhire1 (java.lang.String) => 0.0000 ; Previous1 (java.lang.Boolean) => false ; fuelRateOffhire1 (java.lang.String) => 0.0000 ; smTotal1 (java.lang.String) => 0.0 ; fuelAmountOffhire1 (java.lang.String) => 0.0 ; fwAmountOnhire1 (java.lang.String) => 0.0 ; smGrandTotal1 (java.lang.String) => 0.0 ; vesselOffhireDate1 (java.util.Date) => Wed Mar 01 00:00:00 SGT 2017 ; actualOffhire1 (java.lang.String) => 31/12/2017 ; smGSTrate (java.lang.String) => GS-0% ; fuelRemarkOffhire1 (java.lang.String) => ; RateSMCO (java.lang.String) => ; co1 (java.lang.String) => ICON OFFSHORE GROUP SDN BHD ; coAdminFee1 (java.lang.String) => 0.0 ; fwDifferenceQty1 (java.lang.String) => 0.0 ; fwRateOnhire1 (java.lang.String) => 0.000000 ; endTime1 (java.lang.String) => 24:00 ; fuelDifferenceAmount1 (java.lang.String) => 0.0 ; fwRateOffhire1 (java.lang.String) => 0.000000 ; fwAmountOffhire1 (java.lang.String) => 0.0 ; fuelQtyOnhire1 (java.lang.String) => 0.0 ; primaryOffhire1 (java.lang.String) => 31/12/2017 ; startTime1 (java.lang.String) => 00:00 ; vesselOnhireDate1 (java.util.Date) => Wed Mar 01 00:00:00 SGT 2017 ; coEntityName1 (java.lang.String) => ICON OFFSHORE GROUP SDN BHD ; smGSTamount1 (java.lang.String) => 0.0 ; coSubtotal1 (java.lang.String) => 0.0 ; coTotal1 (java.lang.String) => 0.0 ; contractName1 (java.lang.String) => PROV. OF SIX (6) STRAIGHT SUPPLY VESSELS FOR PETRONAS CARIGALI BASE FLEET (“CONTRACT”) ; smDiscount1 (java.lang.String) => 0.0 ; contractNo1 (java.lang.String) => CHO/2012/LOGISTICS(CHO)/0002 ; smCurr (java.lang.String) => MYR ; smSubtotal1 (java.lang.String) => 0.0 ; currency1 (java.lang.String) => MYR ; actualOnhire1 (java.lang.String) => 01/01/2013 ; fuelQtyOffhire1 (java.lang.String) => 0.0 ; measureUnit1 (java.lang.String) => LITRE ; ReviewerComment1 (java.lang.String) => ; smCode1 (java.lang.String) => 12000 ; ReviewerName1 (java.lang.String) => ; smEntityName1 (java.lang.String) => ICON SHIP MANAGEMENT SDN BHD ; contractVessel1 (java.lang.String) => TANJUNG PUTERI 1 ; > Task<Create Fuel & Fresh Water Debit/Credit Note> ### 16:03:58:434 - executeConnector - start
2017-03-20 16:03:58.452 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: username icon
2017-03-20 16:03:58.452 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: password ******
2017-03-20 16:03:58.452 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: script SELECT DISTINCT “dbo”.“setup_bank_details”.“beneficiary”
FROM “dbo”.“setup_bank_details”, “dbo”.“setup_entity”
WHERE “dbo”.“setup_bank_details”.“beneficiary” = “dbo”.“setup_entity”.“entity_beneficiary”
AND “dbo”.“setup_entity”.“entity_name” = ‘ICON OFFSHORE GROUP SDN BHD’

2017-03-20 16:03:58.452 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: separator null
2017-03-20 16:03:58.452 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: driver com.microsoft.sqlserver.jdbc.SQLServerDriver
2017-03-20 16:03:58.452 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: url jdbc:sqlserver://10.0.0.86:52916;databaseName=icon_test2
2017-03-20 16:03:58.453 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: outputType single
2017-03-20 16:03:58.656 +0800 org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl executeConnector
INFO: ### 16:03:58:655 - executeConnector - end
2017-03-20 16:03:58.657 +0800 org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl org.bonitasoft.forms.server.util.FormLogger internalLog
INFO: Username Form<C.6 Fuel and Fresh Water Debit Credit Note TEST–1.1.0–Create Fuel & Fresh Water Debit/Credit Note$entry> Submitted Fields<coGSTamount1 (java.lang.String) => 0.0 ; vesselCode1 (java.lang.String) => 1101 ; Next1 (java.lang.Boolean) => false ; fwQtyOffhire1 (java.lang.String) => 0.0 ; coDiscount1 (java.lang.String) => 0.0 ; ApproverComment1 (java.lang.String) => ; fuelRemarkOnhire1 (java.lang.String) => ; fuelAmountOnhire1 (java.lang.String) => 0.0 ; customerName1 (java.lang.String) => PETRONAS CARIGALI SDN BHD ; currExRate1 (java.lang.String) => ; coCode1 (java.lang.String) => 11000 ; coGrandTotal1 (java.lang.String) => 0.0 ; coCurr (java.lang.String) => MYR ; sm1 (java.lang.String) => ICON SHIP MANAGEMENT SDN BHD ; fwDifferenceAmount1 (java.lang.String) => 0.0 ; Copy_of_measureUnit1 (java.lang.String) => LITRE ; smAdminFee1 (java.lang.String) => 0.0 ; Submit6 (java.lang.Boolean) => false ; Submit2 (java.lang.Boolean) => false ; Submit3 (java.lang.Boolean) => true ; coGSTRate (java.lang.String) => SR-6% ; fuelDifferenceQty1 (java.lang.String) => 0.0 ; fwQtyOnhire1 (java.lang.String) => 0.0 ; ApproverName1 (java.lang.String) => ; Previous2 (java.lang.Boolean) => false ; VesselAtWork1 (java.lang.String) => TANJUNG PUTERI 1 ; fuelRateOnhire1 (java.lang.String) => 0.0000 ; Previous1 (java.lang.Boolean) => false ; fuelRateOffhire1 (java.lang.String) => 0.0000 ; smTotal1 (java.lang.String) => 0.0 ; fuelAmountOffhire1 (java.lang.String) => 0.0 ; fwAmountOnhire1 (java.lang.String) => 0.0 ; smGrandTotal1 (java.lang.String) => 0.0 ; vesselOffhireDate1 (java.util.Date) => Wed Mar 01 00:00:00 SGT 2017 ; actualOffhire1 (java.lang.String) => 31/12/2017 ; smGSTrate (java.lang.String) => GS-0% ; fuelRemarkOffhire1 (java.lang.String) => ; RateSMCO (java.lang.String) => ; co1 (java.lang.String) => ICON OFFSHORE GROUP SDN BHD ; coAdminFee1 (java.lang.String) => 0.0 ; fwDifferenceQty1 (java.lang.String) => 0.0 ; fwRateOnhire1 (java.lang.String) => 0.000000 ; endTime1 (java.lang.String) => 24:00 ; fuelDifferenceAmount1 (java.lang.String) => 0.0 ; fwRateOffhire1 (java.lang.String) => 0.000000 ; fwAmountOffhire1 (java.lang.String) => 0.0 ; fuelQtyOnhire1 (java.lang.String) => 0.0 ; primaryOffhire1 (java.lang.String) => 31/12/2017 ; startTime1 (java.lang.String) => 00:00 ; vesselOnhireDate1 (java.util.Date) => Wed Mar 01 00:00:00 SGT 2017 ; coEntityName1 (java.lang.String) => ICON OFFSHORE GROUP SDN BHD ; smGSTamount1 (java.lang.String) => 0.0 ; coSubtotal1 (java.lang.String) => 0.0 ; coTotal1 (java.lang.String) => 0.0 ; contractName1 (java.lang.String) => PROV. OF SIX (6) STRAIGHT SUPPLY VESSELS FOR PETRONAS CARIGALI BASE FLEET (“CONTRACT”) ; smDiscount1 (java.lang.String) => 0.0 ; contractNo1 (java.lang.String) => CHO/2012/LOGISTICS(CHO)/0002 ; smCurr (java.lang.String) => MYR ; smSubtotal1 (java.lang.String) => 0.0 ; currency1 (java.lang.String) => MYR ; actualOnhire1 (java.lang.String) => 01/01/2013 ; fuelQtyOffhire1 (java.lang.String) => 0.0 ; measureUnit1 (java.lang.String) => LITRE ; ReviewerComment1 (java.lang.String) => ; smCode1 (java.lang.String) => 12000 ; ReviewerName1 (java.lang.String) => ; smEntityName1 (java.lang.String) => ICON SHIP MANAGEMENT SDN BHD ; contractVessel1 (java.lang.String) => TANJUNG PUTERI 1 ; > Task<Create Fuel & Fresh Water Debit/Credit Note> ### 16:03:58:656 - executeConnector - start
2017-03-20 16:03:58.685 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: username icon
2017-03-20 16:03:58.685 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: password ******
2017-03-20 16:03:58.685 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: script SELECT DISTINCT “dbo”.“setup_bank_details”.“bank_name”
FROM “dbo”.“setup_bank_details”, “dbo”.“setup_entity”
WHERE “dbo”.“setup_bank_details”.“beneficiary” = “dbo”.“setup_entity”.“entity_beneficiary”
AND “dbo”.“setup_entity”.“entity_no” = ‘12000’
AND “dbo”.“setup_bank_details”.“account_currency” = ‘MYR’
AND “dbo”.“setup_bank_details”.“bank_status” = ‘1’

2017-03-20 16:03:58.685 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: separator null
2017-03-20 16:03:58.686 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: driver com.microsoft.sqlserver.jdbc.SQLServerDriver
2017-03-20 16:03:58.686 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: url jdbc:sqlserver://10.0.0.86:52916;databaseName=icon_test2
2017-03-20 16:03:58.686 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: outputType single
2017-03-20 16:03:58.918 +0800 org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl executeConnector
INFO: ### 16:03:58:917 - executeConnector - end
2017-03-20 16:03:58.919 +0800 org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl org.bonitasoft.forms.server.util.FormLogger internalLog
INFO: Username Form<C.6 Fuel and Fresh Water Debit Credit Note TEST–1.1.0–Create Fuel & Fresh Water Debit/Credit Note$entry> Submitted Fields<coGSTamount1 (java.lang.String) => 0.0 ; vesselCode1 (java.lang.String) => 1101 ; Next1 (java.lang.Boolean) => false ; fwQtyOffhire1 (java.lang.String) => 0.0 ; coDiscount1 (java.lang.String) => 0.0 ; ApproverComment1 (java.lang.String) => ; fuelRemarkOnhire1 (java.lang.String) => ; fuelAmountOnhire1 (java.lang.String) => 0.0 ; customerName1 (java.lang.String) => PETRONAS CARIGALI SDN BHD ; currExRate1 (java.lang.String) => ; coCode1 (java.lang.String) => 11000 ; coGrandTotal1 (java.lang.String) => 0.0 ; coCurr (java.lang.String) => MYR ; sm1 (java.lang.String) => ICON SHIP MANAGEMENT SDN BHD ; fwDifferenceAmount1 (java.lang.String) => 0.0 ; Copy_of_measureUnit1 (java.lang.String) => LITRE ; smAdminFee1 (java.lang.String) => 0.0 ; Submit6 (java.lang.Boolean) => false ; Submit2 (java.lang.Boolean) => false ; Submit3 (java.lang.Boolean) => true ; coGSTRate (java.lang.String) => SR-6% ; fuelDifferenceQty1 (java.lang.String) => 0.0 ; fwQtyOnhire1 (java.lang.String) => 0.0 ; ApproverName1 (java.lang.String) => ; Previous2 (java.lang.Boolean) => false ; VesselAtWork1 (java.lang.String) => TANJUNG PUTERI 1 ; fuelRateOnhire1 (java.lang.String) => 0.0000 ; Previous1 (java.lang.Boolean) => false ; fuelRateOffhire1 (java.lang.String) => 0.0000 ; smTotal1 (java.lang.String) => 0.0 ; fuelAmountOffhire1 (java.lang.String) => 0.0 ; fwAmountOnhire1 (java.lang.String) => 0.0 ; smGrandTotal1 (java.lang.String) => 0.0 ; vesselOffhireDate1 (java.util.Date) => Wed Mar 01 00:00:00 SGT 2017 ; actualOffhire1 (java.lang.String) => 31/12/2017 ; smGSTrate (java.lang.String) => GS-0% ; fuelRemarkOffhire1 (java.lang.String) => ; RateSMCO (java.lang.String) => ; co1 (java.lang.String) => ICON OFFSHORE GROUP SDN BHD ; coAdminFee1 (java.lang.String) => 0.0 ; fwDifferenceQty1 (java.lang.String) => 0.0 ; fwRateOnhire1 (java.lang.String) => 0.000000 ; endTime1 (java.lang.String) => 24:00 ; fuelDifferenceAmount1 (java.lang.String) => 0.0 ; fwRateOffhire1 (java.lang.String) => 0.000000 ; fwAmountOffhire1 (java.lang.String) => 0.0 ; fuelQtyOnhire1 (java.lang.String) => 0.0 ; primaryOffhire1 (java.lang.String) => 31/12/2017 ; startTime1 (java.lang.String) => 00:00 ; vesselOnhireDate1 (java.util.Date) => Wed Mar 01 00:00:00 SGT 2017 ; coEntityName1 (java.lang.String) => ICON OFFSHORE GROUP SDN BHD ; smGSTamount1 (java.lang.String) => 0.0 ; coSubtotal1 (java.lang.String) => 0.0 ; coTotal1 (java.lang.String) => 0.0 ; contractName1 (java.lang.String) => PROV. OF SIX (6) STRAIGHT SUPPLY VESSELS FOR PETRONAS CARIGALI BASE FLEET (“CONTRACT”) ; smDiscount1 (java.lang.String) => 0.0 ; contractNo1 (java.lang.String) => CHO/2012/LOGISTICS(CHO)/0002 ; smCurr (java.lang.String) => MYR ; smSubtotal1 (java.lang.String) => 0.0 ; currency1 (java.lang.String) => MYR ; actualOnhire1 (java.lang.String) => 01/01/2013 ; fuelQtyOffhire1 (java.lang.String) => 0.0 ; measureUnit1 (java.lang.String) => LITRE ; ReviewerComment1 (java.lang.String) => ; smCode1 (java.lang.String) => 12000 ; ReviewerName1 (java.lang.String) => ; smEntityName1 (java.lang.String) => ICON SHIP MANAGEMENT SDN BHD ; contractVessel1 (java.lang.String) => TANJUNG PUTERI 1 ; > Task<Create Fuel & Fresh Water Debit/Credit Note> ### 16:03:58:918 - executeConnector - start
2017-03-20 16:03:58.944 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: username icon
2017-03-20 16:03:58.944 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: password ******
2017-03-20 16:03:58.945 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: script SELECT DISTINCT “dbo”.“setup_bank_details”.“bank_name”
FROM “dbo”.“setup_bank_details”, “dbo”.“setup_entity”
WHERE “dbo”.“setup_bank_details”.“beneficiary” = “dbo”.“setup_entity”.“entity_beneficiary”
AND “dbo”.“setup_entity”.“entity_no” = ‘11000’
AND “dbo”.“setup_bank_details”.“account_currency” = ‘MYR’
AND “dbo”.“setup_bank_details”.“bank_status” = ‘1’

2017-03-20 16:03:58.945 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: separator null
2017-03-20 16:03:58.945 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: driver com.microsoft.sqlserver.jdbc.SQLServerDriver
2017-03-20 16:03:58.945 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: url jdbc:sqlserver://10.0.0.86:52916;databaseName=icon_test2
2017-03-20 16:03:58.945 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: outputType single
2017-03-20 16:03:59.174 +0800 org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl executeConnector
INFO: ### 16:03:59:174 - executeConnector - end
2017-03-20 16:03:59.176 +0800 org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl org.bonitasoft.forms.server.util.FormLogger internalLog
INFO: Username Form<C.6 Fuel and Fresh Water Debit Credit Note TEST–1.1.0–Create Fuel & Fresh Water Debit/Credit Note$entry> Submitted Fields<coGSTamount1 (java.lang.String) => 0.0 ; vesselCode1 (java.lang.String) => 1101 ; Next1 (java.lang.Boolean) => false ; fwQtyOffhire1 (java.lang.String) => 0.0 ; coDiscount1 (java.lang.String) => 0.0 ; ApproverComment1 (java.lang.String) => ; fuelRemarkOnhire1 (java.lang.String) => ; fuelAmountOnhire1 (java.lang.String) => 0.0 ; customerName1 (java.lang.String) => PETRONAS CARIGALI SDN BHD ; currExRate1 (java.lang.String) => ; coCode1 (java.lang.String) => 11000 ; coGrandTotal1 (java.lang.String) => 0.0 ; coCurr (java.lang.String) => MYR ; sm1 (java.lang.String) => ICON SHIP MANAGEMENT SDN BHD ; fwDifferenceAmount1 (java.lang.String) => 0.0 ; Copy_of_measureUnit1 (java.lang.String) => LITRE ; smAdminFee1 (java.lang.String) => 0.0 ; Submit6 (java.lang.Boolean) => false ; Submit2 (java.lang.Boolean) => false ; Submit3 (java.lang.Boolean) => true ; coGSTRate (java.lang.String) => SR-6% ; fuelDifferenceQty1 (java.lang.String) => 0.0 ; fwQtyOnhire1 (java.lang.String) => 0.0 ; ApproverName1 (java.lang.String) => ; Previous2 (java.lang.Boolean) => false ; VesselAtWork1 (java.lang.String) => TANJUNG PUTERI 1 ; fuelRateOnhire1 (java.lang.String) => 0.0000 ; Previous1 (java.lang.Boolean) => false ; fuelRateOffhire1 (java.lang.String) => 0.0000 ; smTotal1 (java.lang.String) => 0.0 ; fuelAmountOffhire1 (java.lang.String) => 0.0 ; fwAmountOnhire1 (java.lang.String) => 0.0 ; smGrandTotal1 (java.lang.String) => 0.0 ; vesselOffhireDate1 (java.util.Date) => Wed Mar 01 00:00:00 SGT 2017 ; actualOffhire1 (java.lang.String) => 31/12/2017 ; smGSTrate (java.lang.String) => GS-0% ; fuelRemarkOffhire1 (java.lang.String) => ; RateSMCO (java.lang.String) => ; co1 (java.lang.String) => ICON OFFSHORE GROUP SDN BHD ; coAdminFee1 (java.lang.String) => 0.0 ; fwDifferenceQty1 (java.lang.String) => 0.0 ; fwRateOnhire1 (java.lang.String) => 0.000000 ; endTime1 (java.lang.String) => 24:00 ; fuelDifferenceAmount1 (java.lang.String) => 0.0 ; fwRateOffhire1 (java.lang.String) => 0.000000 ; fwAmountOffhire1 (java.lang.String) => 0.0 ; fuelQtyOnhire1 (java.lang.String) => 0.0 ; primaryOffhire1 (java.lang.String) => 31/12/2017 ; startTime1 (java.lang.String) => 00:00 ; vesselOnhireDate1 (java.util.Date) => Wed Mar 01 00:00:00 SGT 2017 ; coEntityName1 (java.lang.String) => ICON OFFSHORE GROUP SDN BHD ; smGSTamount1 (java.lang.String) => 0.0 ; coSubtotal1 (java.lang.String) => 0.0 ; coTotal1 (java.lang.String) => 0.0 ; contractName1 (java.lang.String) => PROV. OF SIX (6) STRAIGHT SUPPLY VESSELS FOR PETRONAS CARIGALI BASE FLEET (“CONTRACT”) ; smDiscount1 (java.lang.String) => 0.0 ; contractNo1 (java.lang.String) => CHO/2012/LOGISTICS(CHO)/0002 ; smCurr (java.lang.String) => MYR ; smSubtotal1 (java.lang.String) => 0.0 ; currency1 (java.lang.String) => MYR ; actualOnhire1 (java.lang.String) => 01/01/2013 ; fuelQtyOffhire1 (java.lang.String) => 0.0 ; measureUnit1 (java.lang.String) => LITRE ; ReviewerComment1 (java.lang.String) => ; smCode1 (java.lang.String) => 12000 ; ReviewerName1 (java.lang.String) => ; smEntityName1 (java.lang.String) => ICON SHIP MANAGEMENT SDN BHD ; contractVessel1 (java.lang.String) => TANJUNG PUTERI 1 ; > Task<Create Fuel & Fresh Water Debit/Credit Note> ### 16:03:59:175 - executeConnector - start
2017-03-20 16:03:59.203 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: username icon
2017-03-20 16:03:59.203 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: password ******
2017-03-20 16:03:59.203 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: script SELECT “dbo”.“setup_bank_details”.“account_no”
FROM “dbo”.“setup_bank_details”, “dbo”.“setup_entity”
WHERE “dbo”.“setup_bank_details”.“beneficiary” = “dbo”.“setup_entity”.“entity_beneficiary”
AND “dbo”.“setup_entity”.“entity_no” = ‘12000’
AND “dbo”.“setup_bank_details”.“account_currency” = ‘MYR’
AND “dbo”.“setup_bank_details”.“bank_status” = ‘1’

2017-03-20 16:03:59.203 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: separator null
2017-03-20 16:03:59.203 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: driver com.microsoft.sqlserver.jdbc.SQLServerDriver
2017-03-20 16:03:59.203 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: url jdbc:sqlserver://10.0.0.86:52916;databaseName=icon_test2
2017-03-20 16:03:59.203 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: outputType single
2017-03-20 16:03:59.390 +0800 org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl executeConnector
INFO: ### 16:03:59:390 - executeConnector - end
2017-03-20 16:03:59.390 +0800 org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl org.bonitasoft.forms.server.util.FormLogger internalLog
INFO: Username Form<C.6 Fuel and Fresh Water Debit Credit Note TEST–1.1.0–Create Fuel & Fresh Water Debit/Credit Note$entry> Submitted Fields<coGSTamount1 (java.lang.String) => 0.0 ; vesselCode1 (java.lang.String) => 1101 ; Next1 (java.lang.Boolean) => false ; fwQtyOffhire1 (java.lang.String) => 0.0 ; coDiscount1 (java.lang.String) => 0.0 ; ApproverComment1 (java.lang.String) => ; fuelRemarkOnhire1 (java.lang.String) => ; fuelAmountOnhire1 (java.lang.String) => 0.0 ; customerName1 (java.lang.String) => PETRONAS CARIGALI SDN BHD ; currExRate1 (java.lang.String) => ; coCode1 (java.lang.String) => 11000 ; coGrandTotal1 (java.lang.String) => 0.0 ; coCurr (java.lang.String) => MYR ; sm1 (java.lang.String) => ICON SHIP MANAGEMENT SDN BHD ; fwDifferenceAmount1 (java.lang.String) => 0.0 ; Copy_of_measureUnit1 (java.lang.String) => LITRE ; smAdminFee1 (java.lang.String) => 0.0 ; Submit6 (java.lang.Boolean) => false ; Submit2 (java.lang.Boolean) => false ; Submit3 (java.lang.Boolean) => true ; coGSTRate (java.lang.String) => SR-6% ; fuelDifferenceQty1 (java.lang.String) => 0.0 ; fwQtyOnhire1 (java.lang.String) => 0.0 ; ApproverName1 (java.lang.String) => ; Previous2 (java.lang.Boolean) => false ; VesselAtWork1 (java.lang.String) => TANJUNG PUTERI 1 ; fuelRateOnhire1 (java.lang.String) => 0.0000 ; Previous1 (java.lang.Boolean) => false ; fuelRateOffhire1 (java.lang.String) => 0.0000 ; smTotal1 (java.lang.String) => 0.0 ; fuelAmountOffhire1 (java.lang.String) => 0.0 ; fwAmountOnhire1 (java.lang.String) => 0.0 ; smGrandTotal1 (java.lang.String) => 0.0 ; vesselOffhireDate1 (java.util.Date) => Wed Mar 01 00:00:00 SGT 2017 ; actualOffhire1 (java.lang.String) => 31/12/2017 ; smGSTrate (java.lang.String) => GS-0% ; fuelRemarkOffhire1 (java.lang.String) => ; RateSMCO (java.lang.String) => ; co1 (java.lang.String) => ICON OFFSHORE GROUP SDN BHD ; coAdminFee1 (java.lang.String) => 0.0 ; fwDifferenceQty1 (java.lang.String) => 0.0 ; fwRateOnhire1 (java.lang.String) => 0.000000 ; endTime1 (java.lang.String) => 24:00 ; fuelDifferenceAmount1 (java.lang.String) => 0.0 ; fwRateOffhire1 (java.lang.String) => 0.000000 ; fwAmountOffhire1 (java.lang.String) => 0.0 ; fuelQtyOnhire1 (java.lang.String) => 0.0 ; primaryOffhire1 (java.lang.String) => 31/12/2017 ; startTime1 (java.lang.String) => 00:00 ; vesselOnhireDate1 (java.util.Date) => Wed Mar 01 00:00:00 SGT 2017 ; coEntityName1 (java.lang.String) => ICON OFFSHORE GROUP SDN BHD ; smGSTamount1 (java.lang.String) => 0.0 ; coSubtotal1 (java.lang.String) => 0.0 ; coTotal1 (java.lang.String) => 0.0 ; contractName1 (java.lang.String) => PROV. OF SIX (6) STRAIGHT SUPPLY VESSELS FOR PETRONAS CARIGALI BASE FLEET (“CONTRACT”) ; smDiscount1 (java.lang.String) => 0.0 ; contractNo1 (java.lang.String) => CHO/2012/LOGISTICS(CHO)/0002 ; smCurr (java.lang.String) => MYR ; smSubtotal1 (java.lang.String) => 0.0 ; currency1 (java.lang.String) => MYR ; actualOnhire1 (java.lang.String) => 01/01/2013 ; fuelQtyOffhire1 (java.lang.String) => 0.0 ; measureUnit1 (java.lang.String) => LITRE ; ReviewerComment1 (java.lang.String) => ; smCode1 (java.lang.String) => 12000 ; ReviewerName1 (java.lang.String) => ; smEntityName1 (java.lang.String) => ICON SHIP MANAGEMENT SDN BHD ; contractVessel1 (java.lang.String) => TANJUNG PUTERI 1 ; > Task<Create Fuel & Fresh Water Debit/Credit Note> ### 16:03:59:390 - executeConnector - start
2017-03-20 16:03:59.402 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: username icon
2017-03-20 16:03:59.402 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: password ******
2017-03-20 16:03:59.402 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: script SELECT “dbo”.“setup_bank_details”.“account_no”
FROM “dbo”.“setup_bank_details”, “dbo”.“setup_entity”
WHERE “dbo”.“setup_bank_details”.“beneficiary” = “dbo”.“setup_entity”.“entity_beneficiary”
AND “dbo”.“setup_entity”.“entity_no” = ‘11000’
AND “dbo”.“setup_bank_details”.“account_currency” = ‘MYR’
AND “dbo”.“setup_bank_details”.“bank_status” = ‘1’

2017-03-20 16:03:59.402 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: separator null
2017-03-20 16:03:59.402 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: driver com.microsoft.sqlserver.jdbc.SQLServerDriver
2017-03-20 16:03:59.402 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: url jdbc:sqlserver://10.0.0.86:52916;databaseName=icon_test2
2017-03-20 16:03:59.402 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: outputType single
2017-03-20 16:03:59.582 +0800 org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl org.bonitasoft.forms.server.provider.impl.FormServiceProviderExtImpl executeConnector
INFO: ### 16:03:59:582 - executeConnector - end
2017-03-20 16:04:10.363 +0800 com.bonitasoft.engine.external.web.forms.ExecuteActionsAndTerminateTaskExt org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl log
INFO: THREAD_ID=69 | HOSTNAME=FSB-MIRA | TENANT_ID=1 | The user has executed the task [name = <Create Fuel & Fresh Water Debit/Credit Note>, display name = <Create Fuel & Fresh Water Debit/Credit Note>, id = <120012>, parent process instance = <6002>, root process instance = <6002>, process definition = <7739187110568227399>]
2017-03-20 16:04:25.221 +0800 com.bonitasoft.engine.external.web.forms.ExecuteActionsAndTerminateTaskExt org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl log
INFO: THREAD_ID=66 | HOSTNAME=FSB-MIRA | TENANT_ID=1 | The user has executed the task [name = <Preview Fuel & Fresh Water Debit/Credit Note>, display name = <Preview Fuel & Fresh Water Debit/Credit Note>, id = <120014>, parent process instance = <6002>, root process instance = <6002>, process definition = <7739187110568227399>]
2017-03-20 16:04:25.329 +0800 org.bonitasoft.connectors.email.EmailConnector org.bonitasoft.connectors.email.EmailConnector logInputParameter
INFO: charset UTF-8
2017-03-20 16:04:25.329 +0800 org.bonitasoft.connectors.email.EmailConnector org.bonitasoft.connectors.email.EmailConnector logInputParameter
INFO: message

Hi,

The following transaction is pending for your review:

Workflow: C.6 Fuel and Fresh Water Debit/Credit Note

Case ID: 6002

Contract No: CHO/2012/LOGISTICS(CHO)/0002

Customer Name: PETRONAS CARIGALI SDN BHD

Vessel At Work: TANJUNG PUTERI 1

Started By: Amirah Kamil

Please login to Bonitasoft System.

Regards,

System Administrator

2017-03-20 16:04:25.329 +0800 org.bonitasoft.connectors.email.EmailConnector org.bonitasoft.connectors.email.EmailConnector logInputParameter
INFO: html true
2017-03-20 16:04:25.329 +0800 org.bonitasoft.connectors.email.EmailConnector org.bonitasoft.connectors.email.EmailConnector logInputParameter
INFO: subject ICON Billing System - Review Fuel & Fresh Water Debit Note (Case ID: 6002)
2017-03-20 16:04:25.329 +0800 org.bonitasoft.connectors.email.EmailConnector org.bonitasoft.connectors.email.EmailConnector logInputParameter
INFO: bcc amirah@myformates.com, techsupport@myformates.com
2017-03-20 16:04:25.330 +0800 org.bonitasoft.connectors.email.EmailConnector org.bonitasoft.connectors.email.EmailConnector logInputParameter
INFO: cc null
2017-03-20 16:04:25.330 +0800 org.bonitasoft.connectors.email.EmailConnector org.bonitasoft.connectors.email.EmailConnector logInputParameter
INFO: to amirah@myformates.com
2017-03-20 16:04:25.330 +0800 org.bonitasoft.connectors.email.EmailConnector org.bonitasoft.connectors.email.EmailConnector logInputParameter
INFO: from copier@iconoffshore.com.my
2017-03-20 16:04:25.330 +0800 org.bonitasoft.connectors.email.EmailConnector org.bonitasoft.connectors.email.EmailConnector logInputParameter
INFO: userName copier@iconoffshore.com.my
2017-03-20 16:04:25.330 +0800 org.bonitasoft.connectors.email.EmailConnector org.bonitasoft.connectors.email.EmailConnector logInputParameter
INFO: starttlsSupport true
2017-03-20 16:04:25.330 +0800 org.bonitasoft.connectors.email.EmailConnector org.bonitasoft.connectors.email.EmailConnector logInputParameter
INFO: sslSupport false
2017-03-20 16:04:25.330 +0800 org.bonitasoft.connectors.email.EmailConnector org.bonitasoft.connectors.email.EmailConnector logInputParameter
INFO: smtpPort 587
2017-03-20 16:04:25.330 +0800 org.bonitasoft.connectors.email.EmailConnector org.bonitasoft.connectors.email.EmailConnector logInputParameter
INFO: smtpHost smtp.office365.com
2017-03-20 16:04:25.330 +0800 org.bonitasoft.connectors.email.EmailConnector org.bonitasoft.connectors.email.EmailConnector logInputParameter
INFO: replyTo null
2017-03-20 16:04:25.330 +0800 org.bonitasoft.connectors.email.EmailConnector org.bonitasoft.connectors.email.EmailConnector logInputParameters
INFO: password ******
2017-03-20 16:04:25.330 +0800 org.bonitasoft.connectors.email.EmailConnector org.bonitasoft.connectors.email.EmailConnector logInputParameters
INFO: Headers null
2017-03-20 16:04:25.331 +0800 org.bonitasoft.connectors.email.EmailConnector org.bonitasoft.connectors.email.EmailConnector logInputParameter
INFO: headers
2017-03-20 16:05:39.035 +0800 com.bonitasoft.engine.external.web.forms.ExecuteActionsAndTerminateTaskExt org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl log
INFO: THREAD_ID=73 | HOSTNAME=FSB-MIRA | TENANT_ID=1 | The user has executed the task [name = <Review Fuel & Fresh Water Debit/Credit Note>, display name = <Review Fuel & Fresh Water Debit/Credit Note>, id = <120016>, parent process instance = <6002>, root process instance = <6002>, process definition = <7739187110568227399>]
2017-03-20 16:05:41.599 +0800 org.bonitasoft.connectors.email.EmailConnector org.bonitasoft.connectors.email.EmailConnector logInputParameter
INFO: charset UTF-8
2017-03-20 16:05:41.599 +0800 org.bonitasoft.connectors.email.EmailConnector org.bonitasoft.connectors.email.EmailConnector logInputParameter
INFO: message

Hi,

The following transaction is pending for your approval:

Workflow: C.6 Fuel and Fresh Water Debit/Credit Note

Case ID: 6002

Contract No: CHO/2012/LOGISTICS(CHO)/0002

Customer Name: PETRONAS CARIGALI SDN BHD

Vessel At Work: TANJUNG PUTERI 1

Started By: Amirah Kamil

Reviewed By: Amirah Kamil

Please login to Bonitasoft System.

Regards,

System Administrator

2017-03-20 16:05:41.599 +0800 org.bonitasoft.connectors.email.EmailConnector org.bonitasoft.connectors.email.EmailConnector logInputParameter
INFO: html true
2017-03-20 16:05:41.599 +0800 org.bonitasoft.connectors.email.EmailConnector org.bonitasoft.connectors.email.EmailConnector logInputParameter
INFO: subject ICON Billing System - Approve Fuel & Fresh Water Debit Note (Case ID: 6002)
2017-03-20 16:05:41.599 +0800 org.bonitasoft.connectors.email.EmailConnector org.bonitasoft.connectors.email.EmailConnector logInputParameter
INFO: bcc amirah@myformates.com, techsupport@myformates.com
2017-03-20 16:05:41.600 +0800 org.bonitasoft.connectors.email.EmailConnector org.bonitasoft.connectors.email.EmailConnector logInputParameter
INFO: cc null
2017-03-20 16:05:41.600 +0800 org.bonitasoft.connectors.email.EmailConnector org.bonitasoft.connectors.email.EmailConnector logInputParameter
INFO: to amirah@myformates.com
2017-03-20 16:05:41.600 +0800 org.bonitasoft.connectors.email.EmailConnector org.bonitasoft.connectors.email.EmailConnector logInputParameter
INFO: from copier@iconoffshore.com.my
2017-03-20 16:05:41.600 +0800 org.bonitasoft.connectors.email.EmailConnector org.bonitasoft.connectors.email.EmailConnector logInputParameter
INFO: userName copier@iconoffshore.com.my
2017-03-20 16:05:41.600 +0800 org.bonitasoft.connectors.email.EmailConnector org.bonitasoft.connectors.email.EmailConnector logInputParameter
INFO: starttlsSupport true
2017-03-20 16:05:41.600 +0800 org.bonitasoft.connectors.email.EmailConnector org.bonitasoft.connectors.email.EmailConnector logInputParameter
INFO: sslSupport false
2017-03-20 16:05:41.600 +0800 org.bonitasoft.connectors.email.EmailConnector org.bonitasoft.connectors.email.EmailConnector logInputParameter
INFO: smtpPort 587
2017-03-20 16:05:41.600 +0800 org.bonitasoft.connectors.email.EmailConnector org.bonitasoft.connectors.email.EmailConnector logInputParameter
INFO: smtpHost smtp.office365.com
2017-03-20 16:05:41.600 +0800 org.bonitasoft.connectors.email.EmailConnector org.bonitasoft.connectors.email.EmailConnector logInputParameter
INFO: replyTo null
2017-03-20 16:05:41.600 +0800 org.bonitasoft.connectors.email.EmailConnector org.bonitasoft.connectors.email.EmailConnector logInputParameters
INFO: password ******
2017-03-20 16:05:41.600 +0800 org.bonitasoft.connectors.email.EmailConnector org.bonitasoft.connectors.email.EmailConnector logInputParameters
INFO: Headers null
2017-03-20 16:05:41.600 +0800 org.bonitasoft.connectors.email.EmailConnector org.bonitasoft.connectors.email.EmailConnector logInputParameter
INFO: headers
2017-03-20 16:06:15.814 +0800 org.bonitasoft.connectors.email.EmailConnector org.bonitasoft.connectors.email.EmailConnector logInputParameter
INFO: charset UTF-8
2017-03-20 16:06:15.814 +0800 org.bonitasoft.connectors.email.EmailConnector org.bonitasoft.connectors.email.EmailConnector logInputParameter
INFO: message

Hi Amirah Kamil,

Your Fuel & Fresh Water Debit Note transaction has been reviewed by Amirah Kamil on 20/03/2017 16:05. Details are shown below:

Workflow: C.6 Fuel and Fresh Water Debit/Credit Note

Case ID: 6002

Contract No: CHO/2012/LOGISTICS(CHO)/0002

Customer Name: PETRONAS CARIGALI SDN BHD

Vessel At Work: TANJUNG PUTERI 1

An email will be sent once the transaction has been approved.

Regards,

System Administrator

2017-03-20 16:06:15.815 +0800 org.bonitasoft.connectors.email.EmailConnector org.bonitasoft.connectors.email.EmailConnector logInputParameter
INFO: html true
2017-03-20 16:06:15.815 +0800 org.bonitasoft.connectors.email.EmailConnector org.bonitasoft.connectors.email.EmailConnector logInputParameter
INFO: subject ICON Billing System - Fuel & Fresh Water Debit Note transaction has been reviewed by Reviewer (Case ID: 6002)
2017-03-20 16:06:15.815 +0800 org.bonitasoft.connectors.email.EmailConnector org.bonitasoft.connectors.email.EmailConnector logInputParameter
INFO: bcc amirah@myformates.com, techsupport@myformates.com
2017-03-20 16:06:15.815 +0800 org.bonitasoft.connectors.email.EmailConnector org.bonitasoft.connectors.email.EmailConnector logInputParameter
INFO: cc null
2017-03-20 16:06:15.815 +0800 org.bonitasoft.connectors.email.EmailConnector org.bonitasoft.connectors.email.EmailConnector logInputParameter
INFO: to null
2017-03-20 16:06:15.815 +0800 org.bonitasoft.connectors.email.EmailConnector org.bonitasoft.connectors.email.EmailConnector logInputParameter
INFO: from copier@iconoffshore.com.my
2017-03-20 16:06:15.815 +0800 org.bonitasoft.connectors.email.EmailConnector org.bonitasoft.connectors.email.EmailConnector logInputParameter
INFO: userName copier@iconoffshore.com.my
2017-03-20 16:06:15.815 +0800 org.bonitasoft.connectors.email.EmailConnector org.bonitasoft.connectors.email.EmailConnector logInputParameter
INFO: starttlsSupport true
2017-03-20 16:06:15.815 +0800 org.bonitasoft.connectors.email.EmailConnector org.bonitasoft.connectors.email.EmailConnector logInputParameter
INFO: sslSupport false
2017-03-20 16:06:15.815 +0800 org.bonitasoft.connectors.email.EmailConnector org.bonitasoft.connectors.email.EmailConnector logInputParameter
INFO: smtpPort 587
2017-03-20 16:06:15.816 +0800 org.bonitasoft.connectors.email.EmailConnector org.bonitasoft.connectors.email.EmailConnector logInputParameter
INFO: smtpHost smtp.office365.com
2017-03-20 16:06:15.816 +0800 org.bonitasoft.connectors.email.EmailConnector org.bonitasoft.connectors.email.EmailConnector logInputParameter
INFO: replyTo null
2017-03-20 16:06:15.816 +0800 org.bonitasoft.connectors.email.EmailConnector org.bonitasoft.connectors.email.EmailConnector logInputParameters
INFO: password ******
2017-03-20 16:06:15.816 +0800 org.bonitasoft.connectors.email.EmailConnector org.bonitasoft.connectors.email.EmailConnector logInputParameters
INFO: Headers null
2017-03-20 16:06:15.816 +0800 org.bonitasoft.connectors.email.EmailConnector org.bonitasoft.connectors.email.EmailConnector logInputParameter
INFO: headers
2017-03-20 16:06:15.817 +0800 org.bonitasoft.engine.execution.work.FailureHandlingBonitaWork org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl log
SEVERE: THREAD_ID=82 | HOSTNAME=FSB-MIRA | TENANT_ID=1 | The work [ExecuteConnectorOfActivity: flowNodeInstanceId = 120017, connectorDefinitionName = emailToUser-reviewerReviewed] failed. The failure will be handled.
2017-03-20 16:06:15.832 +0800 org.bonitasoft.engine.execution.work.FailureHandlingBonitaWork org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl log
SEVERE: THREAD_ID=82 | HOSTNAME=FSB-MIRA | TENANT_ID=1 | org.bonitasoft.engine.core.connector.exception.SConnectorException : “PROCESS_DEFINITION_ID=7739187110568227399 | PROCESS_NAME=C.6 Fuel and Fresh Water Debit Credit Note TEST | PROCESS_VERSION=1.1.0 | PROCESS_INSTANCE_ID=6002 | ROOT_PROCESS_INSTANCE_ID=6002 | FLOW_NODE_DEFINITION_ID=7003294462048625066 | FLOW_NODE_INSTANCE_ID=120017 | FLOW_NODE_NAME=Email to Appover | CONNECTOR_IMPLEMENTATION_CLASS_NAME=emailToUser-reviewerReviewed | CONNECTOR_INSTANCE_ID=120011 | org.bonitasoft.engine.connector.exception.SConnectorException: java.util.concurrent.ExecutionException: org.bonitasoft.engine.connector.exception.SConnectorException: org.bonitasoft.engine.connector.ConnectorException: java.lang.NullPointerException”
org.bonitasoft.engine.core.connector.exception.SConnectorException: PROCESS_DEFINITION_ID=7739187110568227399 | PROCESS_NAME=C.6 Fuel and Fresh Water Debit Credit Note TEST | PROCESS_VERSION=1.1.0 | PROCESS_INSTANCE_ID=6002 | ROOT_PROCESS_INSTANCE_ID=6002 | FLOW_NODE_DEFINITION_ID=7003294462048625066 | FLOW_NODE_INSTANCE_ID=120017 | FLOW_NODE_NAME=Email to Appover | CONNECTOR_IMPLEMENTATION_CLASS_NAME=emailToUser-reviewerReviewed | CONNECTOR_INSTANCE_ID=120011 | org.bonitasoft.engine.connector.exception.SConnectorException: java.util.concurrent.ExecutionException: org.bonitasoft.engine.connector.exception.SConnectorException: org.bonitasoft.engine.connector.ConnectorException: java.lang.NullPointerException
at org.bonitasoft.engine.core.connector.impl.ConnectorServiceImpl.executeConnectorInClassloader(ConnectorServiceImpl.java:274)
at org.bonitasoft.engine.core.connector.impl.ConnectorServiceImpl.executeConnector(ConnectorServiceImpl.java:147)
at org.bonitasoft.engine.connector.ConnectorServiceDecorator.executeConnector(ConnectorServiceDecorator.java:114)
at org.bonitasoft.engine.execution.work.ExecuteConnectorWork.work(ExecuteConnectorWork.java:138)
at org.bonitasoft.engine.execution.work.failurewrapping.TxInHandleFailureWrappingWork.work(TxInHandleFailureWrappingWork.java:42)
at org.bonitasoft.engine.execution.work.failurewrapping.TxInHandleFailureWrappingWork.work(TxInHandleFailureWrappingWork.java:42)
at org.bonitasoft.engine.execution.work.failurewrapping.TxInHandleFailureWrappingWork.work(TxInHandleFailureWrappingWork.java:42)
at org.bonitasoft.engine.execution.work.failurewrapping.TxInHandleFailureWrappingWork.work(TxInHandleFailureWrappingWork.java:42)
at org.bonitasoft.engine.execution.work.FailureHandlingBonitaWork.work(FailureHandlingBonitaWork.java:66)
at org.bonitasoft.engine.work.BonitaWork.run(BonitaWork.java:56)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.bonitasoft.engine.connector.exception.SConnectorException: java.util.concurrent.ExecutionException: org.bonitasoft.engine.connector.exception.SConnectorException: org.bonitasoft.engine.connector.ConnectorException: java.lang.NullPointerException
at org.bonitasoft.engine.connector.impl.ConnectorExecutorImpl.execute(ConnectorExecutorImpl.java:125)
at org.bonitasoft.engine.core.connector.impl.ConnectorServiceImpl.executeConnectorInClassloader(ConnectorServiceImpl.java:268)
… 12 more
Caused by: java.util.concurrent.ExecutionException: org.bonitasoft.engine.connector.exception.SConnectorException: org.bonitasoft.engine.connector.ConnectorException: java.lang.NullPointerException
at java.util.concurrent.FutureTask.report(FutureTask.java:122)
at java.util.concurrent.FutureTask.get(FutureTask.java:206)
at com.bonitasoft.engine.connector.impl.ConnectorExecutorTimedOut.getValue(ConnectorExecutorTimedOut.java:54)
at org.bonitasoft.engine.connector.impl.ConnectorExecutorImpl.execute(ConnectorExecutorImpl.java:122)
… 13 more
Caused by: org.bonitasoft.engine.connector.exception.SConnectorException: org.bonitasoft.engine.connector.ConnectorException: java.lang.NullPointerException
at org.bonitasoft.engine.core.connector.impl.SConnectorAdapter.execute(SConnectorAdapter.java:75)
at org.bonitasoft.engine.connector.impl.ConnectorExecutorImpl$ExecuteConnectorCallable.call(ConnectorExecutorImpl.java:205)
at org.bonitasoft.engine.connector.impl.ConnectorExecutorImpl$ExecuteConnectorCallable.call(ConnectorExecutorImpl.java:176)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
… 3 more
Caused by: org.bonitasoft.engine.connector.ConnectorException: java.lang.NullPointerException
at org.bonitasoft.connectors.email.EmailConnector.executeBusinessLogic(EmailConnector.java:473)
at org.bonitasoft.engine.connector.AbstractConnector.execute(AbstractConnector.java:77)
at org.bonitasoft.engine.core.connector.impl.SConnectorAdapter.execute(SConnectorAdapter.java:73)
… 6 more
Caused by: java.lang.NullPointerException
at javax.mail.internet.AddressParser.tokenizeAddress(AddressParser.java:645)
at javax.mail.internet.AddressParser.parseAddressList(AddressParser.java:81)
at javax.mail.internet.InternetAddress.parse(InternetAddress.java:557)
at javax.mail.internet.InternetAddress.parse(InternetAddress.java:529)
at org.bonitasoft.connectors.email.EmailConnector.getEmail(EmailConnector.java:339)
at org.bonitasoft.connectors.email.EmailConnector.executeBusinessLogic(EmailConnector.java:470)
… 8 more

2017-03-20 16:06:41.556 +0800 com.bonitasoft.engine.external.web.forms.ExecuteActionsAndTerminateTaskExt org.bonitasoft.engine.log.technical.TechnicalLoggerSLF4JImpl log
INFO: THREAD_ID=64 | HOSTNAME=FSB-MIRA | TENANT_ID=1 | The user has executed the task [name = <Approve Fuel & Fresh Water Debit/Credit Note>, display name = <Approve Fuel & Fresh Water Debit/Credit Note>, id = <120018>, parent process instance = <6002>, root process instance = <6002>, process definition = <7739187110568227399>]
2017-03-20 16:06:41.851 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: username icon
2017-03-20 16:06:41.851 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: password ******
2017-03-20 16:06:41.851 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: script INSERT INTO “dbo”.“inv_fuel_fw” (“contract_no”, “vessel_at_work”,
“fuel_fw_currency”, “invoice_date”, “fuel_measure_unit”, “fuel_onhire_qty”,
“fuel_onhire_rate”, “fuel_onhire_amount”, “fuel_offhire_qty”,
“fuel_offhire_rate”, “fuel_offhire_amount”, “fuel_diff_qty”,
“fuel_total_amount”, “fw_measure_unit”, “fw_onhire_qty”, “fw_onhire_rate”,
“fw_onhire_amount”, “fw_offhire_qty”, “fw_offhire_rate”, “fw_offhire_amount”,
“fw_diff_qty”, “fw_total_amount”, “updated_by”, “updated_datetime”,
“work_from”, “work_to”, “start_time”, “end_time”, “case_id”,
“vessel_at_work_code”, “debit_credit_description”)
VALUES (‘CHO/2012/LOGISTICS(CHO)/0002’, ‘TANJUNG PUTERI 1’, ‘MYR’, ‘Mon Mar 20 00:00:00 SGT 2017’,
‘LITRE’, ‘0.0’, ‘0.0’,
‘0.0’, ‘0.0’, ‘0.0’,
‘0.0’, ‘0.0’, ‘0.0’,
‘LITRE’, ‘0.0’, ‘0.0’, ‘0.0’,
‘0.0’, ‘0.0’, ‘0.0’,
‘0.0’, ‘0.0’, ‘Amirah Kamil’,
‘Mon Mar 20 16:04:25 SGT 2017’, ‘Wednesday Mar 01 00:00:00 SGT 2017’, ‘Wednesday Mar 01 00:00:00 SGT 2017’,
‘00:00’, ‘24:00’, ‘6002’, ‘1101’, ‘TEST’)
2017-03-20 16:06:41.851 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: separator null
2017-03-20 16:06:41.851 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: driver com.microsoft.sqlserver.jdbc.SQLServerDriver
2017-03-20 16:06:41.852 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: url jdbc:sqlserver://10.0.0.86:52916;databaseName=icon_test2
2017-03-20 16:06:41.852 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: outputType null
2017-03-20 16:06:42.096 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: username icon
2017-03-20 16:06:42.096 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: password ******
2017-03-20 16:06:42.096 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: script INSERT INTO “dbo”.“inv_invoicing_debitnote” (“inv_left_op”, “contract_no”,
“invoice_type”, “debitnote_date”, “entity_type”, “entity_name”,
“sub_total”, “admin_fee”, “discount”, “total”, “gst_select”,
“gst_amount”, “amount_due_in_words”, “grand_total”, “beneficiary”,
“bank_name”, “account_currency”, “bank_account”, “updated_by”,
“updated_datetime”, “curr_exrate”, “total_exrate_amount”, “case_id”, “entity_no”)
VALUES (‘DN’, ‘CHO/2012/LOGISTICS(CHO)/0002’, ‘ffw’, ‘Mon Mar 20 00:00:00 SGT 2017’, ‘Manager’,
‘ICON SHIP MANAGEMENT SDN BHD’, ‘0.0’, ‘0.0’, ‘0.0’,
‘0.0’, ‘GS-0%’, ‘0.0’, ‘ZERO ONLY’,
‘0.0’, ‘ICON SHIP MANAGEMENT SDN BHD’, ‘MAYBANK ISLAMIC BERHAD’, ‘MYR’,
‘562188-106796’, ‘Amirah Kamil’, ‘Mon Mar 20 16:04:25 SGT 2017’, ‘0.0’,
‘0.0’, ‘6002’, ‘12000’)
2017-03-20 16:06:42.096 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: separator null
2017-03-20 16:06:42.097 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: driver com.microsoft.sqlserver.jdbc.SQLServerDriver
2017-03-20 16:06:42.097 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: url jdbc:sqlserver://10.0.0.86:52916;databaseName=icon_test2
2017-03-20 16:06:42.097 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: outputType null
2017-03-20 16:06:42.347 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: username icon
2017-03-20 16:06:42.348 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: password ******
2017-03-20 16:06:42.348 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: script INSERT INTO “dbo”.“inv_invoicing_debitnote” (“inv_left_op”, “contract_no”,
“debitnote_date”, “invoice_type”, “entity_type”, “entity_name”,
“sub_total”, “admin_fee”, “discount”, “total”, “gst_select”,
“gst_amount”, “amount_due_in_words”, “grand_total”, “beneficiary”,
“bank_name”, “account_currency”, “bank_account”, “updated_by”,
“updated_datetime”, “curr_exrate”, “total_exrate_amount”, “case_id”, “entity_no”)
VALUES (‘DN’, ‘CHO/2012/LOGISTICS(CHO)/0002’, ‘Mon Mar 20 00:00:00 SGT 2017’, ‘ffw’, ‘Contract Owner’,
‘ICON OFFSHORE GROUP SDN BHD’, ‘0.0’, ‘0.0’, ‘0.0’,
‘0.0’, ‘SR-6%’, ‘0.0’, ‘ZERO ONLY’,
‘0.0’, ‘ICON OFFSHORE GROUP SDN BHD’, ‘AFFIN BANK BERHAD’, ‘MYR’,
‘10-030-014962-6’, ‘Amirah Kamil’, ‘Mon Mar 20 16:04:25 SGT 2017’, ‘0.0’,
‘0.0’, ‘6002’, ‘11000’)
2017-03-20 16:06:42.348 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: separator null
2017-03-20 16:06:42.348 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: driver com.microsoft.sqlserver.jdbc.SQLServerDriver
2017-03-20 16:06:42.348 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: url jdbc:sqlserver://10.0.0.86:52916;databaseName=icon_test2
2017-03-20 16:06:42.348 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: outputType null
2017-03-20 16:06:42.591 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: username icon
2017-03-20 16:06:42.591 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: password ******
2017-03-20 16:06:42.591 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: script SELECT DISTINCT “address1”, “address2”, “address3”, “city”, “postcode”,
“state”, “country”, “swift_code”
FROM “dbo”.“setup_bank_details”
WHERE “beneficiary” = ‘ICON SHIP MANAGEMENT SDN BHD’ AND “account_no” = ‘562188-106796’
AND “bank_status” = ‘1’

2017-03-20 16:06:42.591 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: separator null
2017-03-20 16:06:42.591 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: driver com.microsoft.sqlserver.jdbc.SQLServerDriver
2017-03-20 16:06:42.591 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: url jdbc:sqlserver://10.0.0.86:52916;databaseName=icon_test2
2017-03-20 16:06:42.592 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: outputType one_row
2017-03-20 16:06:42.897 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: username icon
2017-03-20 16:06:42.897 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: password ******
2017-03-20 16:06:42.897 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: script SELECT DISTINCT “address1”, “address2”, “address3”, “city”, “postcode”,
“state”, “country”, “swift_code”
FROM “dbo”.“setup_bank_details”
WHERE “beneficiary” = ‘ICON OFFSHORE GROUP SDN BHD’ AND “account_no” = ‘10-030-014962-6’
AND “bank_status” = ‘1’

2017-03-20 16:06:42.897 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: separator null
2017-03-20 16:06:42.897 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: driver com.microsoft.sqlserver.jdbc.SQLServerDriver
2017-03-20 16:06:42.897 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: url jdbc:sqlserver://10.0.0.86:52916;databaseName=icon_test2
2017-03-20 16:06:42.897 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: outputType one_row
2017-03-20 16:06:43.091 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: username icon
2017-03-20 16:06:43.091 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: password ******
2017-03-20 16:06:43.091 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: script SELECT DISTINCT “entity_address1”, “entity_address2”, “entity_address3”,
“entity_city”, “entity_postcode”, “entity_state”, “entity_country”,
“entity_telno”, “entity_faxno”, “entity_website”, “entity_attention”,
“entity_company_no”, “entity_gst_reg_no”
FROM “dbo”.“setup_entity”
WHERE “entity_no” = ‘11000’ AND “entity_type” = ‘Contract Owner’

2017-03-20 16:06:43.091 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: separator null
2017-03-20 16:06:43.091 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: driver com.microsoft.sqlserver.jdbc.SQLServerDriver
2017-03-20 16:06:43.091 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: url jdbc:sqlserver://10.0.0.86:52916;databaseName=icon_test2
2017-03-20 16:06:43.091 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: outputType one_row
2017-03-20 16:06:43.415 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: username icon
2017-03-20 16:06:43.415 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: password ******
2017-03-20 16:06:43.415 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: script SELECT “address1”, “address2”, “address3”, “city”, “postcode”,
“state”, “country”, “customer_terms”, “attention”
FROM “dbo”.“setup_customer”
WHERE “customer_no” = ‘TR-P04’ AND “cust_status” = ‘1’

2017-03-20 16:06:43.415 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: separator null
2017-03-20 16:06:43.415 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: driver com.microsoft.sqlserver.jdbc.SQLServerDriver
2017-03-20 16:06:43.415 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: url jdbc:sqlserver://10.0.0.86:52916;databaseName=icon_test2
2017-03-20 16:06:43.416 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: outputType one_row
2017-03-20 16:06:43.658 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: username icon
2017-03-20 16:06:43.658 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: password ******
2017-03-20 16:06:43.658 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: script SELECT DISTINCT “entity_company_no”, “entity_address1”, “entity_address2”,
“entity_address3”, “entity_city”, “entity_postcode”, “entity_state”,
“entity_country”, “entity_telno”, “entity_faxno”, “entity_website”,
“entity_gst_reg_no”
FROM “dbo”.“setup_entity”
WHERE “entity_no” = ‘12000’ AND “entity_status” = ‘1’

2017-03-20 16:06:43.659 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: separator null
2017-03-20 16:06:43.659 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: driver com.microsoft.sqlserver.jdbc.SQLServerDriver
2017-03-20 16:06:43.659 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: url jdbc:sqlserver://10.0.0.86:52916;databaseName=icon_test2
2017-03-20 16:06:43.659 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: outputType one_row
2017-03-20 16:06:43.910 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: username icon
2017-03-20 16:06:43.910 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: password ******
2017-03-20 16:06:43.911 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: script SELECT MAX(“inv_id”)
FROM “dbo”.“inv_invoicing_debitnote”
WHERE “invoice_type” = ‘ffw’ AND “contract_no” = ‘CHO/2012/LOGISTICS(CHO)/0002’
AND “entity_type” = ‘Manager’
AND “updated_datetime” = ‘Mon Mar 20 16:04:25 SGT 2017’

2017-03-20 16:06:43.911 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: separator null
2017-03-20 16:06:43.911 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: driver com.microsoft.sqlserver.jdbc.SQLServerDriver
2017-03-20 16:06:43.911 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: url jdbc:sqlserver://10.0.0.86:52916;databaseName=icon_test2
2017-03-20 16:06:43.911 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: outputType single
2017-03-20 16:06:44.107 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: username icon
2017-03-20 16:06:44.107 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: password ******
2017-03-20 16:06:44.108 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: script SELECT MAX(“inv_id”)
FROM “dbo”.“inv_invoicing_debitnote”
WHERE “invoice_type” = ‘ffw’ AND “entity_type” = ‘Contract Owner’
AND “contract_no” = ‘CHO/2012/LOGISTICS(CHO)/0002’
AND “updated_datetime” = ‘Mon Mar 20 16:04:25 SGT 2017’

2017-03-20 16:06:44.108 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: separator null
2017-03-20 16:06:44.108 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: driver com.microsoft.sqlserver.jdbc.SQLServerDriver
2017-03-20 16:06:44.108 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: url jdbc:sqlserver://10.0.0.86:52916;databaseName=icon_test2
2017-03-20 16:06:44.108 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: outputType single
2017-03-20 16:06:44.329 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: username icon
2017-03-20 16:06:44.329 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: password ******
2017-03-20 16:06:44.329 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: script SELECT MAX(“inv_id”)
FROM “dbo”.“inv_invoicing_creditnote”
WHERE “contract_no” = ‘CHO/2012/LOGISTICS(CHO)/0002’ AND “invoice_type” = ‘ffw’
AND “entity_type” = ‘Manager’
AND “updated_datetime” = ‘Mon Mar 20 16:04:25 SGT 2017’

2017-03-20 16:06:44.329 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: separator null
2017-03-20 16:06:44.329 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: driver com.microsoft.sqlserver.jdbc.SQLServerDriver
2017-03-20 16:06:44.329 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: url jdbc:sqlserver://10.0.0.86:52916;databaseName=icon_test2
2017-03-20 16:06:44.329 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: outputType single
2017-03-20 16:06:44.541 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: username icon
2017-03-20 16:06:44.541 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: password ******
2017-03-20 16:06:44.541 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: script SELECT MAX(“inv_id”)
FROM “dbo”.“inv_invoicing_creditnote”
WHERE “invoice_type” = ‘ffw’ AND “contract_no” = ‘CHO/2012/LOGISTICS(CHO)/0002’
AND “entity_type” = ‘Contract Owner’
AND “updated_datetime” = ‘Mon Mar 20 16:04:25 SGT 2017’

2017-03-20 16:06:44.541 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: separator null
2017-03-20 16:06:44.541 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: driver com.microsoft.sqlserver.jdbc.SQLServerDriver
2017-03-20 16:06:44.542 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: url jdbc:sqlserver://10.0.0.86:52916;databaseName=icon_test2
2017-03-20 16:06:44.542 +0800 org.bonitasoft.connectors.database.jdbc.JdbcConnector org.bonitasoft.connectors.database.jdbc.JdbcConnector setInputParameters
INFO: outputType single

romualdo.s.rs · 3 2017 17:25

I’m having trouble getting my jasper connector working too, I tested at the Jasper Studio and it worked normally, did you get your jasper connector working?

Topic		Replies	Views
How to use Jasper connector to generate report from scratch? Q&A	9	0	3 2017
Bonita Community 7.1.0 Tomcat Dev bundle with Jasper Connector - Blank PDF Q&A	3	0	4 2017
Is JasperStudio 5.6.0 compatible with BonitaSoft 7.3.3? Q&A	3	0	3 2017
Free Version Reports Q&A	10	0	25 2015
JBoss 7 - Bonita 7.1.0 - ClassNotFoundException and NoClassDefFoundError Q&A	0	1	7 January 2016

[Update] Jasper connector in Bonita 7.2.4

Related Topics