Article - CS236796

Getting error "ATTENTION: A "String" attribute cannot be created because database columns of the following datatypes are not available" when trying to create Synchronized attribute in FlexPLM

Modified: 18-Dec-2023   


Applies To

  • FlexPLM 10.2 to 12.0

Description

  • Unable to create Synchronized String attribute on Product (LCSProduct) or Colorway (LCSSKU)
  • Below error message printed in MethodServer logs when trying to create Synchronized attribute:
    Caused by: wt.util.WTException: A "String" attribute cannot be created because database columns of the following datatypes are not available: java.lang.String : count : 1. Contact your system administrator to execute the AddColumns utility to allocate the necessary database columns.
    Nested exception is: com.ptc.core.meta.common.CorrectableException: A "String" attribute cannot be created because database columns of the following datatypes are not available: java.lang.String : count : 1. Contact your system administrator to execute the AddColumns utility to allocate the necessary database columns.
        at com.ptc.core.lwc.client.forms.GenericLWCFormProcessor.doOperation(GenericLWCFormProcessor.java:82)
        at com.ptc.core.components.forms.DefaultFormProcessorController.executeDoOperation(DefaultFormProcessorController.java:538)
        at com.ptc.core.components.forms.DefaultFormProcessorController.performExecuteDoOperationAndPostProcess(DefaultFormProcessorController.java:342)
 
This is a printer-friendly version of Article 236796 and may be out of date. For the latest version click CS236796