1 Reply Latest reply: Apr 26, 2013 2:57 AM by Pietro..G-Oracle RSS

    Flex family  definition name is greater than 32 get import error by csdt

    Abhishek98
      Hi,
      I am using Oracle WebCenter Sites 11gR1 11.1.1.6.0. I create a sites on my local setup and i take backup(export) of this sites by using csdt.

      When i try to import sites on my second webcentre sites intance which is also 11gR1 11.1.1.6.0 i got an error related to field length.

      In my scenario i have created a flex family which is as below -
      Product_A : Product attribute
      Product_PD : Product parent defination
      Product_D :Product defination
      Product_P : Product parent
      Product_C : Product


      Prodect defination contains 2 definition .These definition name is greater that 32 characters.
      I have created some assets using these definition when i try to import asset created by these definition i got sql error in error log.
      Product_C table contains column subtype in which is sores definition name which is use to create these assets. But this column length is SUBTYPE  VARCHAR2(32).




      Thanks,

      Edited by: Abhishek98 on Apr 22, 2013 4:42 AM

      Edited by: Abhishek98 on Apr 22, 2013 9:36 AM
        • 1. Re: Flex family  definition name is greater than 32 get import error by csdt
          Pietro..G-Oracle
          RE:"I am using Oracle WebCenter Sites 11gR1 11.1.1.6.0. I create a sites on my local setup and i take backup(export) of this sites by using csdt."

          did you use a JSK to create content locally ?


          From the release notes for WCS 11gR1 : http://docs.oracle.com/cd/E29495_01/doc.1111/webcenter_sites_release_notes.html#_Toc339017244


          · For a given database, the name of a flex asset type must have ten characters less than the maximum number of characters that are allowed for database table names.

          · For a given database, the name of a basic asset type must have five characters less than the maximum number of characters that are allowed for database table names.


          regards,
          P