Unable to publish the Project

Hi All,

 

      We are getting following error in cordys while publishing the project in Dev server.

Let us know if any one have idea on this issue.

Error details: 

The "UpdateSearchableAttributes" request did not process successfully because of "<update reply="no"><tuple><new><NOTIFICATION_SEARCH_COLRUNNING><SEARCH_TYPE_ID>005056A1-0084-11E1-FD73-9F4E9CB693E9</SEARCH_TYPE_ID><DATATYPE>STRING</DATATYPE><AVAILABLE_COLUMN>1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25</AVAILABLE_COLUMN></NOTIFICATION_SEARCH_COLRUNNING></new><error TYPE="Enumeration"><elem>Error :java.sql.SQLException: ORA-00001: unique constraint (CAPS2NEW.NSCR_PK) violated

</elem></error></tuple></update>".

at com.cordys.cws.internal.client.SoapClientBase.convertSOAPFaultToException(SoapClientBase.java:293)

at com.cordys.cws.internal.client.SoapClientBase.sendRequest(SoapClientBase.java:106)

at com.cordys.cws.internal.client.SoapClientBase.sendRequest(SoapClientBase.java:71)

at com.cordys.cws.internal.client.SoapClientBase.sendRequest(SoapClientBase.java:153)

at com.cordys.workflow.modeler.WorkflowSoapClient.execute(DeployWorkFlowDeliveryModel.java:209)

at com.cordys.workflow.modeler.DeployBuildWorkFlowDeliveryModelTask.execute(DeployWorkFlowDeliveryModel.java:135)

at com.cordys.cws.tasks.StudioTaskHelper.executeTask(StudioTaskHelper.java:50)

at com.cordys.cws.tasks.StudioTaskHelper.executeTasks(StudioTaskHelper.java:63)

at com.cordys.cws.tasks.StudioTaskHelper.executeTasks(StudioTaskHelper.java:71)

at com.cordys.cws.internal.deploy.DeployEngine.deployDocument(DeployEngine.java:666)

at com.cordys.cws.internal.deploy.DeployEngine.deployDependencyBox(DeployEngine.java:993)

at com.cordys.cws.internal.deploy.DeployEngine.deployDocument(DeployEngine.java:654)

at com.cordys.cws.internal.deploy.DeployEngine.deployDocument(DeployEngine.java:718)

at com.cordys.cws.internal.deploy.DeployEngine.deployDependencyBox(DeployEngine.java:993)

at com.cordys.cws.internal.deploy.DeployEngine.deployDocument(DeployEngine.java:703)

at com.cordys.cws.internal.deploy.DeployEngine.deployDocument(DeployEngine.java:718)

at com.cordys.cws.internal.deploy.DeployEngine.deployDocument(DeployEngine.java:718)

at com.cordys.cws.internal.deploy.DeployEngine.deployDocument(DeployEngine.java:718)

at com.cordys.cws.internal.deploy.DeployEngine.deployDocument(DeployEngine.java:147)

at com.cordys.cws.deploy.Deployer.doOperation(Deployer.java:180)

at com.cordys.cws.internal.operation.OperationBase.execute(OperationBase.java:110)

at com.cordys.cws.internal.operation.CompositeOperation.doOperation(CompositeOperation.java:64)

at com.cordys.cws.internal.operation.OperationBase.execute(OperationBase.java:110)

at com.cordys.cws.internal.operation.runner.OperationRunner$AsynchronousOperationRunner$AsyncBrokerOperation.execute(OperationRunner.java:295)

at com.cordys.cws.internal.operation.broker.BrokerServerOperationThread.runOperation(BrokerServerOperationThread.java:74)

at com.cordys.cws.internal.operation.pool.CustomOperationThread.run(CustomOperationThread.java:206)

-- Harish Munaga DH

------------------------------------------------------------------------------------------------------------------------------------------------

Hi All,

     I searched in the cordys db for "NOTIFICATION_SEARCH_COLRUNNING" table and i found out the record. Please check it in below

  Present cordys db details:

SEARCH_TYPE_ID=005056A1-0084-11E1-FD73-9F4E9CB693E9

DATATYPE=STRING

AVAILABLE_COLUMN=6,13,14,16,17,24,8,20,2,3,18,5,23,7,25,9,4,11,12,2,3,18,5,23,20,7,25,9,4,11,12,22,15,19,8,10,21,1,2,3,18,5,23,20,7,25,9,4,11,12,22,15,19,8,10,21,1,1,22,15,19,8,10,21,20,2,3,18,5,23,7,25

I don't know what to do in order to resolve this issue.If any one know this issue let us know ASAP.

-- Harish Munaga DH

-------------------------------------------------------------------------------------------------------------------------------------------------

Hi Amit,

No we have not changed anything in the cordys Dattabase,

We just republish the project folder by folder and then the complete project.

-- Rajneet Patel

--------------------------------------------------------------------------------------------------------------------------------------------------