[Update] Jasper connector in Bonita 7.2.4

Submitted by amirah on Fri, 03/17/2017 - 03:03
1
0
-1

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:
1. User enter information to create the invoice.
2. The invoice is approved by approver.
3. The system will create the invoice using connector Jasper 5.0
4. 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:
1. custom-jasper-impl-1.1.0
2. 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?

Comments

Submitted by Sean McP on Sat, 03/18/2017 - 03:47

What do the Logs say?

Permalink
Submitted by amirah on Mon, 03/20/2017 - 10: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 8888' ~~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 88ooo888bo. 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 8D8b 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 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 -- 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 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 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 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 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 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 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 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 ### 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 ### 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 ### 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 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 ### 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 ### 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 ### 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 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 -- 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 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 ### 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 ### 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 ### 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 ; VesselAtWork1 (java.lang.String) => TANJUNG PUTERI 1 ; > Task ### 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 1101 ; smCode1 (java.lang.String) => ; > Task ### 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 1101 ; coCode1 (java.lang.String) => ; > Task ### 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 12000 ; smEntityName1 (java.lang.String) => ; > Task ### 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 11000 ; coEntityName1 (java.lang.String) => ; > Task ### 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 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 ### 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 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 ### 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 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 ### 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 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 ### 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 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 ### 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 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 ### 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 = , display name = , 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 =

, display name = , 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

<body>

<P  style="margin: 4;"align = "left">Hi,</P>
<br>
<P  style="margin: 4;"align = "left">The following transaction is pending for your review:</P>
<br>
<P  style="margin: 4;"align = "left"><b>Workflow</b>: C.6 Fuel and Fresh Water Debit/Credit Note</P>
<P  style="margin: 4;"align = "left"><b>Case ID</b>: 6002</P>
<P  style="margin: 4;"align = "left"><b>Contract No</b>: CHO/2012/LOGISTICS(CHO)/0002</P>
<P  style="margin: 4;"align = "left"><b>Customer Name</b>: PETRONAS CARIGALI SDN BHD</P>
<P  style="margin: 4;"align = "left"><b>Vessel At Work</b>: TANJUNG PUTERI 1</P>
<P  style="margin: 4;"align = "left"><b>Started By</b>: Amirah Kamil</P>
<br>
<P  style="margin: 4;"align = "left">Please login to Bonitasoft System.</P>
<br>
<P  style="margin: 4;"align = "left">Regards,</P>
<P  style="margin: 4;"align = "left">System Administrator</P>
<br>
<br>

</body>

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 = , display name = , 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

<body>

<P  style="margin: 4;"align = "left">Hi,</P>
<br>
<P  style="margin: 4;"align = "left">The following transaction is pending for your approval:</P>
<br>
<P  style="margin: 4;"align = "left"><b>Workflow:</b> C.6 Fuel and Fresh Water Debit/Credit Note</P>
<P  style="margin: 4;"align = "left"><b>Case ID:</b> 6002</P>
<P  style="margin: 4;"align = "left"><b>Contract No:</b> CHO/2012/LOGISTICS(CHO)/0002</P>
<P  style="margin: 4;"align = "left"><b>Customer Name:</b> PETRONAS CARIGALI SDN BHD</P>
<P  style="margin: 4;"align = "left"><b>Vessel At Work:</b> TANJUNG PUTERI 1</P>
<P  style="margin: 4;"align = "left"><b>Started By:</b> Amirah Kamil</P>
<P  style="margin: 4;"align = "left"><b>Reviewed By:</b> Amirah Kamil</P>
<br>
<P  style="margin: 4;"align = "left">Please login to Bonitasoft System.</P>
<br>
<P  style="margin: 4;"align = "left">Regards,</P>
<P  style="margin: 4;"align = "left">System Administrator</P>
<br>
<br>

</body>

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

<body>

<P  style="margin: 4;"align = "left">Hi Amirah Kamil,</P>
<br>
<P  style="margin: 4;"align = "left">Your Fuel & Fresh Water Debit Note transaction has been reviewed by Amirah Kamil on 20/03/2017 16:05. Details are shown below:</P>
<br>
<P  style="margin: 4;"align = "left"><b>Workflow:</b> C.6 Fuel and Fresh Water Debit/Credit Note</P>
<P  style="margin: 4;"align = "left"><b>Case ID:</b> 6002</P>
<P  style="margin: 4;"align = "left"><b>Contract No:</b> CHO/2012/LOGISTICS(CHO)/0002</P>
<P  style="margin: 4;"align = "left"><b>Customer Name:</b> PETRONAS CARIGALI SDN BHD</P>
<P  style="margin: 4;"align = "left"><b>Vessel At Work:</b> TANJUNG PUTERI 1</P>
<br>
<P  style="margin: 4;"align = "left">An email will be sent once the transaction has been approved.</P>
<br>
<P  style="margin: 4;"align = "left">Regards,</P>
<P  style="margin: 4;"align = "left">System Administrator</P>
<br>
<br>

</body>

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 = , display name = , 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

Permalink
Submitted by romualdo.s.rs on Thu, 08/03/2017 - 19: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?

Permalink
No answers yet.
Notifications