AnsweredAssumed Answered

Error:Could not execute JDBC batch update for Custom Aspect

Question asked by amarendrakt on Jul 7, 2008
Hi All,

  I am using Alfresco Community 2.1 version and designed custom content type and aspect for the project.
I am using database MS SQL Server 2005. After deploying the alfresco war file with all the chages I can see the custom content types and aspect in the UI and I can upload the document, applying these content type and can add aspect to the same document.
But after applying both the custom content type as well as aspect if I tried to change the metadata/properties of document I am getting following exception:
20:40:00,063 ERROR [ui.common.Utils] A system error happened during the operation: Could not execute JDBC batch update
org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
   at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
   at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
   at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:249)
   at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:235)
   at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:142)
   at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
   at org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:41)
   at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:969)
   at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1114)
   at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
   at org.alfresco.repo.attributes.hibernate.MapEntryDAOHibernate.get(MapEntryDAOHibernate.java:79)
   at org.alfresco.repo.attributes.MapAttributeImpl.entrySet(MapAttributeImpl.java:152)
   at org.alfresco.service.cmr.repository.datatype.DefaultTypeConverter$23.convert(DefaultTypeConverter.java:311)
   at org.alfresco.service.cmr.repository.datatype.DefaultTypeConverter$23.convert(DefaultTypeConverter.java:308)
   at org.alfresco.service.cmr.repository.datatype.TypeConverter.convert(TypeConverter.java:120)
   at org.alfresco.repo.domain.PropertyValue$ValueType$11.convert(PropertyValue.java:199)
   at org.alfresco.repo.domain.PropertyValue.getValue(PropertyValue.java:836)
   at org.alfresco.repo.node.AbstractNodeServiceImpl.makeSerializableValue(AbstractNodeServiceImpl.java:689)
   at org.alfresco.repo.node.db.DbNodeServiceImpl.getPropertiesImpl(DbNodeServiceImpl.java:918)
   at org.alfresco.repo.node.db.DbNodeServiceImpl.getProperties(DbNodeServiceImpl.java:903)
   at sun.reflect.GeneratedMethodAccessor194.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:585)
   at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:281)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:187)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:154)
   at org.alfresco.repo.transaction.TransactionResourceInterceptor.invoke(TransactionResourceInterceptor.java:138)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210)
   at $Proxy2.getProperties(Unknown Source)
   at sun.reflect.GeneratedMethodAccessor194.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:585)
   at org.alfresco.repo.service.StoreRedirectorProxyFactory$RedirectorInvocationHandler.invoke(StoreRedirectorProxyFactory.java:221)
   at $Proxy3.getProperties(Unknown Source)
   at sun.reflect.GeneratedMethodAccessor194.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:585)
   at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:281)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:187)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:154)
   at org.alfresco.repo.node.MLPropertyInterceptor.invoke(MLPropertyInterceptor.java:175)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
   at org.alfresco.repo.node.MLPropertyInterceptor.invoke(MLPropertyInterceptor.java:175)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
   at org.alfresco.repo.node.NodeRefPropertyMethodInterceptor.invoke(NodeRefPropertyMethodInterceptor.java:204)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
   at org.alfresco.repo.node.NodeRefPropertyMethodInterceptor.invoke(NodeRefPropertyMethodInterceptor.java:204)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210)
   at $Proxy2.getProperties(Unknown Source)
   at org.alfresco.repo.node.integrity.IncompleteNodeTagger.processNode(IncompleteNodeTagger.java:354)
   at org.alfresco.repo.node.integrity.IncompleteNodeTagger.beforeCommit(IncompleteNodeTagger.java:343)
   at org.alfresco.repo.transaction.AlfrescoTransactionSupport$TransactionSynchronizationImpl.doBeforeCommit(AlfrescoTransactionSupport.java:631)
   at org.alfresco.repo.transaction.AlfrescoTransactionSupport$TransactionSynchronizationImpl.doBeforeCommit(AlfrescoTransactionSupport.java:613)
   at org.alfresco.repo.transaction.AlfrescoTransactionSupport$TransactionSynchronizationImpl.beforeCommit(AlfrescoTransactionSupport.java:591)
   at org.springframework.transaction.support.TransactionSynchronizationUtils.triggerBeforeCommit(TransactionSynchronizationUtils.java:48)
   at org.springframework.transaction.support.AbstractPlatformTransactionManager.triggerBeforeCommit(AbstractPlatformTransactionManager.java:821)
   at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:637)
   at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:624)
   at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:307)
   at org.alfresco.util.transaction.SpringAwareUserTransaction.commit(SpringAwareUserTransaction.java:420)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:242)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:158)
   at org.alfresco.web.bean.dialog.BaseDialogBean.finish(BaseDialogBean.java:124)
   at org.alfresco.web.bean.dialog.DialogManager.finish(DialogManager.java:347)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:585)
   at org.apache.myfaces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:132)
   at org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:61)
   at javax.faces.component.UICommand.broadcast(UICommand.java:109)
   at javax.faces.component.UIViewRoot._broadcastForPhase(UIViewRoot.java:97)
   at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:171)
   at org.apache.myfaces.lifecycle.InvokeApplicationExecutor.execute(InvokeApplicationExecutor.java:32)
   at org.apache.myfaces.lifecycle.LifecycleImpl.executePhase(LifecycleImpl.java:95)
   at org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:70)
   at javax.faces.webapp.FacesServlet.service(FacesServlet.java:139)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
   at org.alfresco.web.app.servlet.AuthenticationFilter.doFilter(AuthenticationFilter.java:81)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
   at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)
   at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
   at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
   at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
   at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
   at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.BatchUpdateException: com.microsoft.sqlserver.jdbc.SQLServerException: Violation of PRIMARY KEY constraint 'PK__alf_node_propert__5812160E'. Cannot insert duplicate key in object 'dbo.alf_node_properties'.
   at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeBatch(Unknown Source)
   at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:294)
   at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
   at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:242)
   … 93 more

If I am using HSQL database everything works fine and there is no exception.

Also with MS SQL 2005 databse, if I remove the custom aspect and retain the custom content type, I can edit the properties and can save them but the time I add aspect to the document and start editing properties it gives me the exception.

Why is this happening?
Please need your help in this case. Is there is any issue with the databse setup or configuration for Alfresco?
I have followed all the instructions for db configuration. Also my custom model file is also as per the standrads of Alfresco custom-model.xml.

Here is my custom-model.xml which defines custom content type and custom aspect.

<?xml version="1.0" encoding="UTF-8"?>

<!– Definition of new Model –>

<!– The important part here is the name - Note: the use of the cis: namespace
     which is defined further on in the document –>

<model name="wks:testmodel" xmlns="http://www.alfresco.org/model/dictionary/1.0">
   <description>Test Meta-data Model</description>
   <author></author>
   <version>1.0</version>

   <!– Imports are required to allow references to definitions in other models –>  
   <imports>
        <!– Import Alfresco Dictionary Definitions –>
      <import uri="http://www.alfresco.org/model/dictionary/1.0" prefix="d"/>
      <!– Import Alfresco Content Domain Model Definitions –>
      <import uri="http://www.alfresco.org/model/content/1.0" prefix="cm"/>
   </imports>

   <namespaces>
      <!– Define a Namespace for new definitions –>
      <namespace uri="wks.test.model" prefix="wks"/>
   </namespaces>

   <types>
   <!– Definition of new Content Type: Custom Content –>
      <type name="wks:wksdocs">
         <title>Test Documents</title>
            <parent>cm:content</parent>
         <properties>
            <!– <property name="wks:type">
               <title>Document Type</title>
               <type>d:text</type>
            </property>
            <property name="wks:title">
               <title>Document Title/Web Display</title>
               <type>d:text</type>
            </property>
            <property name="wks:orginalName">
               <title>Original Doc Name</title>
               <type>d:text</type>
            </property>
            <property name="wks:author">
               <title>Document Author</title>
               <type>d:text</type>
            </property>–>
            <property name="wks:comments">
               <title>Comments</title>
               <type>d:text</type>
            </property>
            <property name="wks:releasedDate">
               <title>Doc Release Date</title>
               <type>d:date</type>
            </property>
            <property name="wks:subType">
               <title>Sub Type</title>
               <type>d:text</type>
               <default>All</default>
            </property>
            <property name="wks:webPublish">
               <title>Web Publish</title>
               <type>d:boolean</type>
            </property>
         </properties>
      </type>
     
      <type name="wks:AddmAgenda">
         <title>Addendum/Agendas/Reports to Council/Special Meeting/Letters to Council</title>
            <parent>wks:wksdocs</parent>
         <properties>         
            <property name="wks:fiscalYear">
               <title>Fiscal Year</title>
               <type>d:int</type>
            </property>
            <property name="wks:meetingDate">
               <title>Meeting Date</title>
               <type>d:date</type>
            </property>
            <property name="wks:securityGroup">
               <title>Committee Name</title>
               <type>d:text</type>
            </property>
         </properties>
      </type>
     
      <type name="wks:minutes">
         <title>Minutes</title>
            <parent>wks:wksdocs</parent>
         <properties>
            <property name="wks:minSecurityGroup">
               <title>Committee Name</title>
               <type>d:text</type>
            </property>
         </properties>
      </type>
     
      <type name="wks:rollcallArchive">
         <title>RollCall-Archive</title>
            <parent>wks:wksdocs</parent>
         <properties>
            <property name="wks:archiveDate">
               <title>Archive Date</title>
               <type>d:date</type>
            </property>
         </properties>
      </type>
     
      <type name="wks:reportNetworkDoc">
         <title>Report/Network Documentation</title>
            <parent>wks:wksdocs</parent>
         <properties>
            <property name="wks:fiscalYearTest">
               <title>Fiscal Year Test</title>
               <type>d:int</type>
            </property>
         </properties>
      </type>
     
      <type name="wks:financeDeptReports">
         <title>Report/Network Documentation</title>
            <parent>wks:wksdocs</parent>
         <properties>
            <property name="wks:finFiscalYear">
               <title>Fiscal Year</title>
               <type>d:int</type>
            </property>
         </properties>
      </type>
     
      <type name="wks:itInvoices">
         <title>IT Invoices</title>
            <parent>wks:wksdocs</parent>
         <properties>
            <property name="wks:itHTENumber">
               <title>HTE Number</title>
               <type>d:text</type>
            </property>
            <property name="wks:itOrderNumber">
               <title>Order Number</title>
               <type>d:text</type>
            </property>
            <property name="wks:itVendorName">
               <title>Vendor Name</title>
               <type>d:text</type>
            </property>
         </properties>
      </type>
     
      <type name="wks:accidentReport">
         <title>Accident Report</title>
            <parent>wks:wksdocs</parent>
         <properties>
            <property name="wks:stateAccidentNumber">
               <title>State Accident Number</title>
               <type>d:text</type>
            </property>
            <property name="wks:HTENumber">
               <title>HTE Number</title>
               <type>d:text</type>
            </property>
            <property name="wks:accidentLocation">
               <title>Accident Location</title>
               <type>d:text</type>
            </property>
            <property name="wks:accidentDate">
               <title>Accident Date</title>
               <type>d:date</type>
            </property>
            <property name="wks:operator1Name">
               <title>Operator 1 Name</title>
               <type>d:text</type>
            </property>
            <property name="wks:operator2Name">
               <title>Operator 2 Name</title>
               <type>d:text</type>
            </property>
            <property name="wks:owner1Name">
               <title>Owner 1 Name</title>
               <type>d:text</type>
            </property>
            <property name="wks:owner2Name">
               <title>Owner 2 Name</title>
               <type>d:text</type>
            </property>
            <property name="wks:contractType">
               <title>Contract Type</title>
               <type>d:text</type>
            </property>
            <property name="wks:alternateName">
               <title>Alternate Name</title>
               <type>d:text</type>
            </property>
            <property name="wks:department">
               <title>Department</title>
               <type>d:text</type>
            </property>
         </properties>
      </type>
     
      <type name="wks:taxbillPropertyOccu">
         <title>Tax Bill/Property</title>
            <parent>wks:wksdocs</parent>
         <properties>
            <property name="wks:taxkey">
               <title>Tax Key</title>
               <type>d:text</type>
            </property>
            <property name="wks:streetNumber">
               <title>Street Number</title>
               <type>d:text</type>
            </property>
            <property name="wks:preDirection">
               <title>PreDirection</title>
               <type>d:text</type>
            </property>
            <property name="wks:streetName">
               <title>Street Name</title>
               <type>d:text</type>
            </property>
            <property name="wks:streetType">
               <title>Street Type</title>
               <type>d:text</type>
            </property>
            <property name="wks:postDirection">
               <title>Post Direction</title>
               <type>d:text</type>
            </property>
            <property name="wks:streetSuffix">
               <title>Street Suffix</title>
               <type>d:text</type>
            </property>
            <property name="wks:taxFiscalYear">
               <title>Fiscal Year</title>
               <type>d:text</type>
            </property>
         </properties>
      </type>
     
      <type name="wks:plansBldgPlan">
         <title>Plans-Bldg/Plans-Plan</title>
            <parent>wks:taxbillProperty</parent>
         <properties>
            <property name="wks:dateReceived">
               <title>Date Received</title>
               <type>d:date</type>
            </property>
            <property name="wks:planMeetingDate">
               <title>Meeting Date</title>
               <type>d:date</type>
            </property>
            <property name="wks:planContractType">
               <title>Contract Type</title>
               <type>d:text</type>
            </property>
            <property name="wks:planAlternateName">
               <title>Alternate Name</title>
               <type>d:text</type>
            </property>
            <property name="wks:planDepartment">
               <title>Department</title>
               <type>d:text</type>
            </property>
         </properties>
      </type>
     
      <type name="wks:mobileVideo">
         <title>Mobile Video</title>
            <parent>wks:taxbillProperty</parent>
         <properties>
            <property name="wks:primary">
               <title>Primary</title>
               <type>d:boolean</type>
            </property>
            <property name="wks:propertyAddress">
               <title>Property Address</title>
               <type>d:text</type>
            </property>
            <property name="wks:mobContractType">
               <title>Contract Type</title>
               <type>d:text</type>
            </property>
            <property name="wks:mobAlternateName">
               <title>Alternate Name</title>
               <type>d:text</type>
            </property>
            <property name="wks:mobDepartment">
               <title>Department</title>
               <type>d:text</type>
            </property>
         </properties>
      </type>
     
   </types>
  
      <aspects>
      <aspect name="wks:migrationAspect">
         <title>Document Migration</title>
         <properties>
               <property name="wks:dId">
               <title>Document Id</title>
               <type>d:text</type>
               </property>
               <property name="wks:docId">
                  <title>Doc Id</title>
                  <type>d:text</type>
               </property>
               <property name="wks:Type">
                  <title>Document Type</title>
                  <type>d:text</type>
               </property>
               <property name="wks:Title">
                  <title>Document Title</title>
                  <type>d:text</type>
               </property>
               <property name="wks:OrginalName">
                  <title>Original Doc Name</title>
                  <type>d:text</type>
               </property>
               <property name="wks:Author">
                  <title>Document Author</title>
                  <type>d:text</type>
               </property>
               <property name="wks:secuGrp">
                  <title>Committee Name</title>
                  <type>d:text</type>
               </property>
               <property name="wks:ReleasedDate">
                  <title>Doc Release Date</title>
                  <type>d:date</type>
               </property>
            </properties>
         </aspect>
   </aspects>

</model>

Here is custom web-client-config.xml:


<alfresco-config>

  
   <config evaluator="string-compare" condition="Content Wizards">
      <!– The list of custom content types to show in the content wizards –>
      <content-types>
         <type name="wks:wksdocs" />
         <type name="wks:AddmAgenda" />
         <type name="wks:accidentReport" />
         <type name="wks:minutes" />
         <type name="wks:reportNetworkDoc" />
         <type name="wks:taxbillPropertyOccu" />
         <type name="wks:rollcallArchive" />
         <type name="wks:mobileVideo" />
         <type name="wks:plansBldgPlan" />
         <type name="wks:itInvoices" />
         <type name="wks:financeDeptReports" />
      </content-types>
   </config>
<!– For Test Doc Details.xml –>

   <config evaluator="node-type" condition="wks:wksdocs">
      <property-sheet>
         <show-property name="mimetype" display-label-id="content_type"
                        component-generator="MimeTypeSelectorGenerator" read-only="true"  />
         <show-property name="size" display-label-id="size"
                        converter="org.alfresco.faces.ByteSizeConverter"
                        show-in-edit-mode="false" /> 
       <!– <show-association name="wks:type" />
       <show-property name="wks:type" read-only="false"  /> 
       <show-association name="wks:title" />
         <show-property name="wks:title" read-only="false"  />
         <show-association name="wks:orginalName" />
         <show-property name="wks:orginalName" read-only="false"  />
         <show-association name="wks:author" />
         <show-property name="wks:author" read-only="false"  />
         <show-association name="wks:author" />
         <show-property name="wks:author" read-only="false"  />–>
         <show-association name="wks:webPublish" />
         <show-property name="wks:webPublish" read-only="false"  />
       <show-association name="wks:comments" />
       <show-property name="wks:comments" read-only="False" component-generator="TextAreaGenerator" />
       <show-association name="wks:releasedDate" />
         <show-property name="wks:releasedDate" read-only="false"  />
         <show-association name="wks:subType" />
         <show-property name="wks:subType" read-only="false" />
    </property-sheet>
   </config>
  
   <config evaluator="node-type" condition="wks:accidentReport">      
      <property-sheet>
         <show-property name="mimetype" display-label-id="content_type"
                        component-generator="MimeTypeSelectorGenerator" read-only="true"  />
         <show-property name="size" display-label-id="size"
                        converter="org.alfresco.faces.ByteSizeConverter"
                        show-in-edit-mode="false" /> 
       <show-association name="wks:stateAccidentNumber" />
       <show-property name="wks:stateAccidentNumber" read-only="false"  /> 
       <show-association name="wks:HTENumber" />
         <show-property name="wks:HTENumber" read-only="false"  />
         <show-association name="wks:accidentLocation" />
         <show-property name="wks:accidentLocation" read-only="false"  />
         <show-association name="wks:operator1Name" />
         <show-property name="wks:operator1Name" read-only="false"  />
         <show-association name="wks:operator2Name" />
         <show-property name="wks:operator2Name" read-only="false"  />
         <show-association name="wks:owner1Name" />
         <show-property name="wks:owner1Name" read-only="false"  />
         <show-association name="wks:owner2Name" />
         <show-property name="wks:owner2Name" read-only="false"  />
       <show-association name="wks:accidentDate" />
         <show-property name="wks:accidentDate" read-only="false"  />
       <!– <show-association name="wks:type" />
       <show-property name="wks:type" read-only="false"  /> 
       <show-association name="wks:title" />
         <show-property name="wks:title" read-only="false"  />
         <show-association name="wks:orginalName" />
         <show-property name="wks:orginalName" read-only="false"  />
         <show-association name="wks:author" />
         <show-property name="wks:author" read-only="false"  />
         <show-association name="wks:author" />
         <show-property name="wks:author" read-only="false"  />–>
         <show-association name="wks:webPublish" />
         <show-property name="wks:webPublish" read-only="false"  />
       <show-association name="wks:comments" />
       <show-property name="wks:comments" read-only="False" component-generator="TextAreaGenerator" />
       <show-association name="wks:releasedDate" />
         <show-property name="wks:releasedDate" read-only="false"  />
         <show-association name="wks:subType" />
         <show-property name="wks:subType" read-only="false" />
    </property-sheet>
   </config>
  
   <config evaluator="node-type" condition="wks:AddmAgenda">
      <property-sheet>
         <show-property name="mimetype" display-label-id="content_type"
                        component-generator="MimeTypeSelectorGenerator" read-only="true"  />
         <show-property name="size" display-label-id="size"
                        converter="org.alfresco.faces.ByteSizeConverter"
                        show-in-edit-mode="false" /> 
       <show-association name="wks:fiscalYear" />
       <show-property name="wks:fiscalYear" read-only="false"  /> 
       <show-association name="wks:meetingDate" />
         <show-property name="wks:meetingDate" read-only="false"  />
         <show-association name="wks:securityGroup" />
         <show-property name="wks:securityGroup" read-only="false"  />
         <!– <show-association name="wks:type" />
       <show-property name="wks:type" read-only="false"  /> 
       <show-association name="wks:title" />
         <show-property name="wks:title" read-only="false"  />
         <show-association name="wks:orginalName" />
         <show-property name="wks:orginalName" read-only="false"  />
         <show-association name="wks:author" />
         <show-property name="wks:author" read-only="false"  />
         <show-association name="wks:author" />
         <show-property name="wks:author" read-only="false"  />–>
         <show-association name="wks:webPublish" />
         <show-property name="wks:webPublish" read-only="false"  />
       <show-association name="wks:comments" />
       <show-property name="wks:comments" read-only="False" component-generator="TextAreaGenerator" />
       <show-association name="wks:releasedDate" />
         <show-property name="wks:releasedDate" read-only="false"  />
         <show-association name="wks:subType" />
         <show-property name="wks:subType" read-only="false" />
    </property-sheet>
   </config>
  
   <config evaluator="node-type" condition="wks:minutes">
      <property-sheet>
         <show-property name="mimetype" display-label-id="content_type"
                        component-generator="MimeTypeSelectorGenerator" read-only="true"  />
         <show-property name="size" display-label-id="size"
                        converter="org.alfresco.faces.ByteSizeConverter"
                        show-in-edit-mode="false" /> 
       <show-association name="wks:minSecurityGroup" />
       <show-property name="wks:minSecurityGroup" read-only="false"  />
       <!– <show-association name="wks:type" />
       <show-property name="wks:type" read-only="false"  /> 
       <show-association name="wks:title" />
         <show-property name="wks:title" read-only="false"  />
         <show-association name="wks:orginalName" />
         <show-property name="wks:orginalName" read-only="false"  />
         <show-association name="wks:author" />
         <show-property name="wks:author" read-only="false"  />
         <show-association name="wks:author" />
         <show-property name="wks:author" read-only="false"  />–>
         <show-association name="wks:webPublish" />
         <show-property name="wks:webPublish" read-only="false"  />
       <show-association name="wks:comments" />
       <show-property name="wks:comments" read-only="False" component-generator="TextAreaGenerator" />
       <show-association name="wks:releasedDate" />
         <show-property name="wks:releasedDate" read-only="false"  />
         <show-association name="wks:subType" />
         <show-property name="wks:subType" read-only="false" />
    </property-sheet>
   </config>
  
   <config evaluator="node-type" condition="wks:reportNetworkDoc">
      <property-sheet>
         <show-property name="mimetype" display-label-id="content_type"
                        component-generator="MimeTypeSelectorGenerator" read-only="true"  />
         <show-property name="size" display-label-id="size"
                        converter="org.alfresco.faces.ByteSizeConverter"
                        show-in-edit-mode="false" /> 
       <show-association name="wks:fiscalYearTest" />
       <show-property name="wks:fiscalYearTest" read-only="false"  />
       <!– <show-association name="wks:type" />
       <show-property name="wks:type" read-only="false"  /> 
       <show-association name="wks:title" />
         <show-property name="wks:title" read-only="false"  />
         <show-association name="wks:orginalName" />
         <show-property name="wks:orginalName" read-only="false"  />
         <show-association name="wks:author" />
         <show-property name="wks:author" read-only="false"  />
         <show-association name="wks:author" />
         <show-property name="wks:author" read-only="false"  />–>
         <show-association name="wks:webPublish" />
         <show-property name="wks:webPublish" read-only="false"  />
       <show-association name="wks:comments" />
       <show-property name="wks:comments" read-only="False" component-generator="TextAreaGenerator" />
       <show-association name="wks:releasedDate" />
         <show-property name="wks:releasedDate" read-only="false"  />
         <show-association name="wks:subType" />
         <show-property name="wks:subType" read-only="false" />
    </property-sheet>
   </config>
  
   <config evaluator="node-type" condition="wks:financeDeptReports">
      <property-sheet>
         <show-property name="mimetype" display-label-id="content_type"
                        component-generator="MimeTypeSelectorGenerator" read-only="true"  />
         <show-property name="size" display-label-id="size"
                        converter="org.alfresco.faces.ByteSizeConverter"
                        show-in-edit-mode="false" /> 
       <show-association name="wks:finFiscalYear" />
       <show-property name="wks:finFiscalYear" read-only="false"  />
       <!– <show-association name="wks:type" />
       <show-property name="wks:type" read-only="false"  /> 
       <show-association name="wks:title" />
         <show-property name="wks:title" read-only="false"  />
         <show-association name="wks:orginalName" />
         <show-property name="wks:orginalName" read-only="false"  />
         <show-association name="wks:author" />
         <show-property name="wks:author" read-only="false"  />
         <show-association name="wks:author" />
         <show-property name="wks:author" read-only="false"  />–>
         <show-association name="wks:webPublish" />
         <show-property name="wks:webPublish" read-only="false"  />
       <show-association name="wks:comments" />
       <show-property name="wks:comments" read-only="False" component-generator="TextAreaGenerator" />
       <show-association name="wks:releasedDate" />
         <show-property name="wks:releasedDate" read-only="false"  />
         <show-association name="wks:subType" />
         <show-property name="wks:subType" read-only="false" />
    </property-sheet>
   </config>
  
   <config evaluator="node-type" condition="wks:itInvoices">
      <property-sheet>
         <show-property name="mimetype" display-label-id="content_type"
                        component-generator="MimeTypeSelectorGenerator" read-only="true"  />
         <show-property name="size" display-label-id="size"
                        converter="org.alfresco.faces.ByteSizeConverter"
                        show-in-edit-mode="false" /> 
       <show-association name="wks:itHTENumber" />
       <show-property name="wks:itHTENumber" read-only="false"  />
       <show-association name="wks:itOrderNumber" />
       <show-property name="wks:itOrderNumber" read-only="false"  />
       <show-association name="wks:itVendorName" />
       <show-property name="wks:itVendorName" read-only="false"  />
       <!– <show-association name="wks:type" />
       <show-property name="wks:type" read-only="false"  /> 
       <show-association name="wks:title" />
         <show-property name="wks:title" read-only="false"  />
         <show-association name="wks:orginalName" />
         <show-property name="wks:orginalName" read-only="false"  />
         <show-association name="wks:author" />
         <show-property name="wks:author" read-only="false"  />
         <show-association name="wks:author" />
         <show-property name="wks:author" read-only="false"  />–>
         <show-association name="wks:webPublish" />
         <show-property name="wks:webPublish" read-only="false"  />
       <show-association name="wks:comments" />
       <show-property name="wks:comments" read-only="False" component-generator="TextAreaGenerator" />
       <show-association name="wks:releasedDate" />
         <show-property name="wks:releasedDate" read-only="false"  />
         <show-association name="wks:subType" />
         <show-property name="wks:subType" read-only="false" />
    </property-sheet>
   </config>
  
   <config evaluator="node-type" condition="wks:taxbillPropertyOccu">
      <property-sheet>
         <show-property name="mimetype" display-label-id="content_type"
                        component-generator="MimeTypeSelectorGenerator" read-only="true"  />
         <show-property name="size" display-label-id="size"
                        converter="org.alfresco.faces.ByteSizeConverter"
                        show-in-edit-mode="false" /> 
       <show-association name="wks:taxkey" />
       <show-property name="wks:taxkey" read-only="false"  />
       <show-association name="wks:streetNumber" />
       <show-property name="wks:streetNumber" read-only="false"  />
       <show-association name="wks:preDirection" />
       <show-property name="wks:preDirection" read-only="false"  />
       <show-association name="wks:streetName" />
       <show-property name="wks:streetName" read-only="false"  />
       <show-association name="wks:streetType" />
       <show-property name="wks:streetType" read-only="false"  />
       <show-association name="wks:postDirection" />
       <show-property name="wks:postDirection" read-only="false"  />
       <show-association name="wks:streetSuffix" />
       <show-property name="wks:streetSuffix" read-only="false"  />
       <show-association name="wks:taxFiscalYear" />
       <show-property name="wks:taxFiscalYear" read-only="false"  />      
       <!– <show-association name="wks:type" />
       <show-property name="wks:type" read-only="false"  /> 
       <show-association name="wks:title" />
         <show-property name="wks:title" read-only="false"  />
         <show-association name="wks:orginalName" />
         <show-property name="wks:orginalName" read-only="false"  />
         <show-association name="wks:author" />
         <show-property name="wks:author" read-only="false"  />
         <show-association name="wks:author" />
         <show-property name="wks:author" read-only="false"  />–>
         <show-association name="wks:webPublish" />
         <show-property name="wks:webPublish" read-only="false"  />
       <show-association name="wks:comments" />
       <show-property name="wks:comments" read-only="False" component-generator="TextAreaGenerator" />
       <show-association name="wks:releasedDate" />
         <show-property name="wks:releasedDate" read-only="false"  />
         <show-association name="wks:subType" />
         <show-property name="wks:subType" read-only="false" />
    </property-sheet>
   </config>
  
   <config evaluator="node-type" condition="wks:plansBldgPlan">
      <property-sheet>
         <show-property name="mimetype" display-label-id="content_type"
                        component-generator="MimeTypeSelectorGenerator" read-only="true"  />
         <show-property name="size" display-label-id="size"
                        converter="org.alfresco.faces.ByteSizeConverter"
                        show-in-edit-mode="false" /> 
       <show-association name="wks:taxkey" />
       <show-property name="wks:taxkey" read-only="false"  />
       <show-association name="wks:streetNumber" />
       <show-property name="wks:streetNumber" read-only="false"  />
       <show-association name="wks:preDirection" />
       <show-property name="wks:preDirection" read-only="false"  />
       <show-association name="wks:streetName" />
       <show-property name="wks:streetName" read-only="false"  />
       <show-association name="wks:streetType" />
       <show-property name="wks:streetType" read-only="false"  />
       <show-association name="wks:postDirection" />
       <show-property name="wks:postDirection" read-only="false"  />
       <show-association name="wks:streetSuffix" />
       <show-property name="wks:streetSuffix" read-only="false"  />
       <show-association name="wks:taxFiscalYear" />
       <show-property name="wks:taxFiscalYear" read-only="false"  />
       <show-association name="wks:dateReceived" />
       <show-property name="wks:dateReceived" read-only="false"  />
       <show-association name="wks:planMeetingDate" />
       <show-property name="wks:planMeetingDate" read-only="false"  />
       <show-association name="wks:planContractType" />
       <show-property name="wks:planContractType" read-only="false"  />
       <show-association name="wks:planAlternateName" />
       <show-property name="wks:planAlternateName" read-only="false"  />
       <show-association name="wks:planDepartment" />
       <show-property name="wks:planDepartment" read-only="false"  />             
       <!– <show-association name="wks:type" />
       <show-property name="wks:type" read-only="false"  /> 
       <show-association name="wks:title" />
         <show-property name="wks:title" read-only="false"  />
         <show-association name="wks:orginalName" />
         <show-property name="wks:orginalName" read-only="false"  />
         <show-association name="wks:author" />
         <show-property name="wks:author" read-only="false"  />
         <show-association name="wks:author" />
         <show-property name="wks:author" read-only="false"  />–>
         <show-association name="wks:webPublish" />
         <show-property name="wks:webPublish" read-only="false"  />
       <show-association name="wks:comments" />
       <show-property name="wks:comments" read-only="False" component-generator="TextAreaGenerator" />
       <show-association name="wks:releasedDate" />
         <show-property name="wks:releasedDate" read-only="false"  />
         <show-association name="wks:subType" />
         <show-property name="wks:subType" read-only="false" />
    </property-sheet>
   </config>
  
   <config evaluator="node-type" condition="wks:mobileVideo">
      <property-sheet>
         <show-property name="mimetype" display-label-id="content_type"
                        component-generator="MimeTypeSelectorGenerator" read-only="true"  />
         <show-property name="size" display-label-id="size"
                        converter="org.alfresco.faces.ByteSizeConverter"
                        show-in-edit-mode="false" /> 
       <show-association name="wks:taxkey" />
       <show-property name="wks:taxkey" read-only="false"  />
       <show-association name="wks:streetNumber" />
       <show-property name="wks:streetNumber" read-only="false"  />
       <show-association name="wks:preDirection" />
       <show-property name="wks:preDirection" read-only="false"  />
       <show-association name="wks:streetName" />
       <show-property name="wks:streetName" read-only="false"  />
       <show-association name="wks:streetType" />
       <show-property name="wks:streetType" read-only="false"  />
       <show-association name="wks:postDirection" />
       <show-property name="wks:postDirection" read-only="false"  />
       <show-association name="wks:streetSuffix" />
       <show-property name="wks:streetSuffix" read-only="false"  />
       <show-association name="wks:primary" />
       <show-property name="wks:primary" read-only="false"  />
       <show-association name="wks:propertyAddress" />
       <show-property name="wks:propertyAddress" read-only="false"  />
       <show-association name="wks:mobContractType" />
       <show-property name="wks:mobContractType" read-only="false"  />
       <show-association name="wks:mobAlternateName" />
       <show-property name="wks:mobAlternateName" read-only="false"  />
       <show-association name="wks:mobDepartment" />
       <show-property name="wks:mobDepartment" read-only="false"  />             
       <!– <show-association name="wks:type" />
       <show-property name="wks:type" read-only="false"  /> 
       <show-association name="wks:title" />
         <show-property name="wks:title" read-only="false"  />
         <show-association name="wks:orginalName" />
         <show-property name="wks:orginalName" read-only="false"  />
         <show-association name="wks:author" />
         <show-property name="wks:author" read-only="false"  />
         <show-association name="wks:author" />
         <show-property name="wks:author" read-only="false"  />–>
         <show-association name="wks:webPublish" />
         <show-property name="wks:webPublish" read-only="false"  />
       <show-association name="wks:comments" />
       <show-property name="wks:comments" read-only="False" component-generator="TextAreaGenerator" />
       <show-association name="wks:releasedDate" />
         <show-property name="wks:releasedDate" read-only="false"  />
         <show-association name="wks:subType" />
         <show-property name="wks:subType" read-only="false" />
    </property-sheet>
   </config>
  
   <config evaluator="node-type" condition="wks:rollcallArchive">
      <property-sheet>
         <show-property name="mimetype" display-label-id="content_type"
                        component-generator="MimeTypeSelectorGenerator" read-only="true"  />
         <show-property name="size" display-label-id="size"
                        converter="org.alfresco.faces.ByteSizeConverter"
                        show-in-edit-mode="false" /> 
       <show-association name="wks:archiveDate" />
       <show-property name="wks:archiveDate" read-only="false"  />
       <!– <show-association name="wks:type" />
       <show-property name="wks:type" read-only="false"  /> 
       <show-association name="wks:title" />
         <show-property name="wks:title" read-only="false"  />
         <show-association name="wks:orginalName" />
         <show-property name="wks:orginalName" read-only="false"  />
         <show-association name="wks:author" />
         <show-property name="wks:author" read-only="false"  />
         <show-association name="wks:author" />
         <show-property name="wks:author" read-only="false"  />–>
         <show-association name="wks:webPublish" />
         <show-property name="wks:webPublish" read-only="false"  />
       <show-association name="wks:comments" />
       <show-property name="wks:comments" read-only="False" component-generator="TextAreaGenerator" />
       <show-association name="wks:releasedDate" />
         <show-property name="wks:releasedDate" read-only="false"  />
         <show-association name="wks:subType" />
         <show-property name="wks:subType" read-only="false" />
    </property-sheet>
   </config>

   <config evaluator="string-compare" condition="Action Wizards">
      <aspects>
         <aspect name="wks:migrationAspect"/>
      </aspects>

     <specialise-types>
      <type name="wks:wksdocs"/>
      <type name="wks:AddmAgenda" />
         <type name="wks:accidentReport" />
         <type name="wks:minutes" />
         <type name="wks:report" />
         <type name="wks:taxbillProperty" />
         <type name="wks:rollcallArchive" />
   </specialise-types>
   </config>

   <config evaluator="aspect-name" condition="wks:migrationAspect">
      <property-sheet>     
         <show-property name="wks:dId"/>
         <show-property name="wks:docId"/>
         <show-property name="wks:Type"/>
         <show-property name="wks:Title"/>
         <show-property name="wks:OrginalName"/>
         <show-property name="wks:Author"/>
         <show-property name="wks:secuGrp"/>
         <show-property name="wks:ReleasedDate"/>      
      </property-sheet>
   </config>
   
</alfresco-config>
Please let me know if I am wrong anywhere.

Thanks in advance,
Amarendra

Outcomes