BVMC Create Process Pack Error

Buildfile: C:\BV1TO1\lib\deploy-pack.xml

init:

deployBundle:

init:

deployBundle_JBoss:
[java] DeployBundle: started.
[java] DeployBundle: deploying ClassifiedPack/000015
[java] 2009.04.15 17:42:00,312 SGT: executing bundle ClassifiedPack/000015
[java] 2009.04.15 17:42:00,343 SGT: executing Task readinessCheck by rootAgent

[java] -------- Performing readiness checking task --------

[java] Checking whether the application server is running ...

[java] The application server is up.

[java] ======== Finished readiness checking task ========

[java] 2009.04.15 17:42:09,359 SGT: finished Task, readinessCheck, finished by rootAgent: 9016 millis elapsed
[java] 2009.04.15 17:42:09,359 SGT: executing Task common by rootAgent

[java] -------- Performing common SSP deployment task --------

[java] updateProcessPack: true
[java] preCompileJSP: true
[java] validatePack: true
[java] Setting the package 'ClassifiedPack' to status In-Deployment ...
[java] Deploying package 'ClassifiedPack' version 3 ...
[java] Checking package dependency ...

[java] The list of JSPs and AA classes are logged to the following file:
[java] C:\BV1TO1\var/logs/ClassifiedPack_ManualDeploy.log

[java] 2009.04.15 17:42:15,843 SGT: Populating database tables ...

[java] 2009.04.15 17:42:16,93 SGT: invoking deployAllPolicies()

[java] Deploying policies to database ...
[java] Deploying policy 'CheckNewContent.bpolicy'.
[java] Loading rule 'CheckNewContent.rule'.
[java] 2009.04.15 17:42:16,906 SGT: invoking deployAllPageflowJsp()
[java] Copying all pageflow JSPs ...
[java] 2009.04.15 17:42:16,906 SGT: invoking deployAllForms()
[java] Deploying forms ....
[java] runtimeRoot: appConfig/bv_framework/sspPackages/ClassifiedPack/version3
[java] packageRoot: C:\BV1TO1\var\appConfig\bv_framework\deployer\bundles\ClassifiedPack\000015
[java] Runtime Directory: C:\BV1TO1\var\appConfig\bv_framework\sspPackages\ClassifiedPack\version3\originals
[java] Bundle Directory: C:\BV1TO1\var\appConfig\bv_framework\deployer\bundles\ClassifiedPack\000015
[java] Processing: forms/CreateUpdateCLASSIFIEDForm.form
[java] Generating JSP files for form 'CreateUpdateCLASSIFIEDForm_Portal'.
[java] Processing: forms/CreateUpdateCLASSIFIEDForm_Portal.form
[java] Generating JSP files for form 'CreateUpdateCLASSIFIEDForm_Portal'.
[java] Processing: forms/ViewCLASSIFIEDForm.form
[java] Generating JSP files for form 'ViewCLASSIFIEDForm'.
[java] Processing: forms/ViewCLASSIFIEDVersionForm.form
[java] Generating JSP files for form 'ViewCLASSIFIEDVersionForm'.
[java] Generating standard error pages ...

[java] Compiling all form JSPs ...

[java] [PageFlowJspLoader] Parsing JSP in C:\BV1TO1\var\appConfig\bv_framework\deployer\bundles\ClassifiedPack\000015\generated\formJsp...
[java] execute JBoss jasper compiler
[java] 2009.04.15 17:42:30,500 SGT: invoking deployAllCollabTemplates()
[java] Deploying collaboration templates ....
[java] 2009.04.15 17:42:30,500 SGT: invoking deployActorAndGroupTable()

[java] 2009.04.15 17:42:30,765 SGT: invoking populateProcessTables()
[java] Deploying processes ...
[java] Deploying process 'CreateUpdateCLASSIFIED'
[java] 139578739
[java] Deploying process 'CreateUpdateCLASSIFIED_Portal'
[java] com.broadvision.data.exceptions.DuplicateDataException: SQL ErrorCode=-9, State=23000, Message=Violation of unique index: BV_PROCESS_KEY_IDX in statement [INSERT INTO BV_PROCESS (NAME, TYPE, GUID, DESCRIPTION, PACKAGE_NAME, DEFINITION_OID, STATUS, OID, STORE_ID, CREATION_TIME, DELETED, LAST_MOD_TIME)VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]
[java] at com.broadvision.data.exceptions.DBExceptionHandler.HSQLDBHandler(DBExceptionHandler.java:249)
[java] at com.broadvision.data.exceptions.DBExceptionHandler.handle(DBExceptionHandler.java:91)
[java] at com.broadvision.data.exceptions.DBExceptionHandler.handle(DBExceptionHandler.java:61)
[java] at com.broadvision.data.server.ContentDao.insertBVContent(ContentDao.java:1953)
[java] at com.broadvision.data.server.ContentDao.insertContent(ContentDao.java:661)
[java] at com.broadvision.data.ejb.content.ContentDbSLBean.createContent(ContentDbSLBean.java:1202)
[java] at sun.reflect.GeneratedMethodAccessor1636.invoke(Unknown Source)
[java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[java] at java.lang.reflect.Method.invoke(Method.java:585)
[java] at org.jboss.invocation.Invocation.performCall(Invocation.java:359)
[java] at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:237)
[java] at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:158)
[java] at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:169)
[java] at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63)
[java] at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:121)
[java] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:350)
[java] at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:181)
[java] at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:168)
[java] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205)
[java] at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:136)
[java] at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:648)
[java] at org.jboss.ejb.Container.invoke(Container.java:954)
[java] at sun.reflect.GeneratedMethodAccessor330.invoke(Unknown Source)
[java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[java] at java.lang.reflect.Method.invoke(Method.java:585)
[java] at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
[java] at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
[java] at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
[java] at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
[java] at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
[java] at org.jboss.invocation.local.LocalInvoker$MBeanServerAction.invoke(LocalInvoker.java:169)
[java] at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:118)
[java] at org.jboss.invocation.InvokerInterceptor.invokeLocalMarshalled(InvokerInterceptor.java:295)
[java] at org.jboss.invocation.MarshallingInvokerInterceptor.invoke(MarshallingInvokerInterceptor.java:61)
[java] at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:61)
[java] at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:70)
[java] at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:112)
[java] at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:100)
[java] at $Proxy144.createContent(Unknown Source)
[java] at com.broadvision.data.ejb.content.ContentInfoSLBean.createContent(ContentInfoSLBean.java:1455)
[java] at sun.reflect.GeneratedMethodAccessor1635.invoke(Unknown Source)
[java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[java] at java.lang.reflect.Method.invoke(Method.java:585)
[java] at org.jboss.invocation.Invocation.performCall(Invocation.java:359)
[java] at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:237)
[java] at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:158)
[java] at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63)
[java] at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:121)
[java] at org.jboss.ejb.plugins.AbstractTxInterceptorBMT.invokeNext(AbstractTxInterceptorBMT.java:173)
[java] at org.jboss.ejb.plugins.TxInterceptorBMT.invoke(TxInterceptorBMT.java:77)
[java] at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:169)
[java] at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:168)
[java] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205)
[java] at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:136)
[java] at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:648)
[java] at org.jboss.ejb.Container.invoke(Container.java:954)
[java] at sun.reflect.GeneratedMethodAccessor330.invoke(Unknown Source)
[java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[java] at java.lang.reflect.Method.invoke(Method.java:585)
[java] at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
[java] at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
[java] at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
[java] at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
[java] at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
[java] at org.jboss.invocation.jrmp.server.JRMPInvoker$MBeanServerAction.invoke(JRMPInvoker.java:819)
[java] at org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:420)
[java] at sun.reflect.GeneratedMethodAccessor335.invoke(Unknown Source)
[java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[java] at java.lang.reflect.Method.invoke(Method.java:585)
[java] at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:294)
[java] at sun.rmi.transport.Transport$1.run(Transport.java:153)
[java] at java.security.AccessController.doPrivileged(Native Method)
[java] at sun.rmi.transport.Transport.serviceCall(Transport.java:149)
[java] at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:466)
[java] at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:707)
[java] at java.lang.Thread.run(Thread.java:595)
[java] at sun.rmi.transport.StreamRemoteCall.exceptionReceivedFromServer(StreamRemoteCall.java:247)
[java] at sun.rmi.transport.StreamRemoteCall.executeCall(StreamRemoteCall.java:223)
[java] at sun.rmi.server.UnicastRef.invoke(UnicastRef.java:126)
[java] at org.jboss.invocation.jrmp.server.JRMPInvoker_Stub.invoke(Unknown Source)
[java] at org.jboss.invocation.jrmp.interfaces.JRMPInvokerProxy.invoke(JRMPInvokerProxy.java:133)
[java] at org.jboss.invocation.InvokerInterceptor.invokeInvoker(InvokerInterceptor.java:365)
[java] at org.jboss.invocation.MarshallingInvokerInterceptor.invoke(MarshallingInvokerInterceptor.java:63)
[java] at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:61)
[java] at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:70)
[java] at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:112)
[java] at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:100)
[java] at $Proxy5.createContent(Unknown Source)
[java] at com.broadvision.data.client.DataManagerImpl.createContent(DataManagerImpl.java:580)
[java] at com.broadvision.data.client.DataManager.createContent(DataManager.java:1026)
[java] at com.broadvision.ssp.deployment.SspProcessDeploy.populateProcessTables(SspProcessDeploy.java:526)
[java] at com.broadvision.ssp.deployment.SspPackageDeploy.populateProcessTables(SspPackageDeploy.java:897)
[java] at com.broadvision.ssp.deployment.SspPackageDeploy.populateDbTables(SspPackageDeploy.java:558)
[java] at com.broadvision.ssp.deployment.CommonTask.deployPackage(CommonTask.java:273)
[java] at com.broadvision.ssp.deployment.CommonTask.performTask(CommonTask.java:188)
[java] at com.broadvision.ssp.deployment.CommonTask.perform(CommonTask.java:108)
[java] at com.broadvision.deployer.tasks.TaskExecution.run(TaskExecution.java:122)
[java] at com.broadvision.deployer.agent.LocalAgent.performTask(LocalAgent.java:59)
[java] at com.broadvision.deployer.coord.LocalCoordinator.executeBundle(LocalCoordinator.java:204)
[java] at com.broadvision.deployer.coord.LocalCoordinator.executeBundle(LocalCoordinator.java:153)
[java] at com.broadvision.deployer.utils.DeployBundle.doIt(DeployBundle.java:35)
[java] at com.broadvision.deployer.utils.DeployBundle.main(DeployBundle.java:57)
[java] com.broadvision.ssp.exceptions.SspDeployException: SQL ErrorCode=-9, State=23000, Message=Violation of unique index: BV_PROCESS_KEY_IDX in statement [INSERT INTO BV_PROCESS (NAME, TYPE, GUID, DESCRIPTION, PACKAGE_NAME, DEFINITION_OID, STATUS, OID, STORE_ID, CREATION_TIME, DELETED, LAST_MOD_TIME)VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]
[java] at com.broadvision.ssp.deployment.SspProcessDeploy.populateProcessTables(SspProcessDeploy.java:554)
[java] at com.broadvision.ssp.deployment.SspPackageDeploy.populateProcessTables(SspPackageDeploy.java:897)
[java] at com.broadvision.ssp.deployment.SspPackageDeploy.populateDbTables(SspPackageDeploy.java:558)
[java] at com.broadvision.ssp.deployment.CommonTask.deployPackage(CommonTask.java:273)
[java] at com.broadvision.ssp.deployment.CommonTask.performTask(CommonTask.java:188)
[java] at com.broadvision.ssp.deployment.CommonTask.perform(CommonTask.java:108)
[java] at com.broadvision.deployer.tasks.TaskExecution.run(TaskExecution.java:122)
[java] at com.broadvision.deployer.agent.LocalAgent.performTask(LocalAgent.java:59)
[java] at com.broadvision.deployer.coord.LocalCoordinator.executeBundle(LocalCoordinator.java:204)
[java] at com.broadvision.deployer.coord.LocalCoordinator.executeBundle(LocalCoordinator.java:153)
[java] at com.broadvision.deployer.utils.DeployBundle.doIt(DeployBundle.java:35)
[java] at com.broadvision.deployer.utils.DeployBundle.main(DeployBundle.java:57)
[java] Setting the package 'ClassifiedPack' to status Error ...
[java] com.broadvision.ssp.exceptions.SspDeployException: SQL ErrorCode=-9, State=23000, Message=Violation of unique index: BV_PROCESS_KEY_IDX in statement [INSERT INTO BV_PROCESS (NAME, TYPE, GUID, DESCRIPTION, PACKAGE_NAME, DEFINITION_OID, STATUS, OID, STORE_ID, CREATION_TIME, DELETED, LAST_MOD_TIME)VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]
[java] at com.broadvision.ssp.deployment.CommonTask.performTask(CommonTask.java:215)
[java] at com.broadvision.ssp.deployment.CommonTask.perform(CommonTask.java:108)
[java] at com.broadvision.deployer.tasks.TaskExecution.run(TaskExecution.java:122)
[java] at com.broadvision.deployer.agent.LocalAgent.performTask(LocalAgent.java:59)
[java] at com.broadvision.deployer.coord.LocalCoordinator.executeBundle(LocalCoordinator.java:204)
[java] at com.broadvision.deployer.coord.LocalCoordinator.executeBundle(LocalCoordinator.java:153)
[java] at com.broadvision.deployer.utils.DeployBundle.doIt(DeployBundle.java:35)
[java] at com.broadvision.deployer.utils.DeployBundle.main(DeployBundle.java:57)
[java] SQL ErrorCode=-9, State=23000, Message=Violation of unique index: BV_PROCESS_KEY_IDX in statement [INSERT INTO BV_PROCESS (NAME, TYPE, GUID, DESCRIPTION, PACKAGE_NAME, DEFINITION_OID, STATUS, OID, STORE_ID, CREATION_TIME, DELETED, LAST_MOD_TIME)VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]
[java] The deployment common task failed.
[java] 2009.04.15 17:42:31,500 SGT: failed to finish Task, common, finished by rootAgent: 22141 millis elapsed
[java] DeployBundle: failed to deploy ClassifiedPack/000015.
[java] DeployBundle: finished (-3).
[DEPLOY_STDERR]-->

BUILD FAILED
C:\BV1TO1\lib\deploy-pack.xml:577: The following error occurred while executing this line:
C:\BV1TO1\lib\deploy-pack.xml:584: Java returned: -3

Total time: 35 seconds
<--[DEPLOY_STDERR]

Solution:

Delete the key from table BV_PROCESS

SELECT * FROM BV_PROCESS

DELETE FROM BV_PROCESS WHERE OID = 8707

.... and then deploy again..

u'll success...

... and then... another problem raised!!!