Error Importing content from VCM 7.6 to WEM 8.0

Atul_Sood

Hi All,

I am facing an issue when migrating content from VCM 7.6 to WEM 8.0. The problem seems to be with the custom Query Components. Our custom query component has a attribute named TTL whose DataType in VCM 7.6 was NUMBER, but according to the Vignette support, this datatype is not supported in WEM 8.0 and i was asked to change the Datatype to VARCHAR2.

After making the necessary DB changes and CTD structural changes, i was still unable to migrate the content. And as agreed with Support, i disabled the com.vignette.ext.templating.client.javabean.VgnExtTemplatingObjectListener from the events, and then i was able to import the Presentation Pages/Custom Query Components.

However now when i try to update/modify the Default TTL value on the Custom Query component instance, i get the following error

"Unable to commit the content instance: Content is not allowed in prolog"

I have had a look on the Internet about this error, and it seems to be some XML  Parsing exception.

I am confused how to resolve this issue, and hoping someone on this forum might have come across this issue before and knows how to resolve it?

According to me this issue could have been caused as i imported the content after disabling the "VgnExtTemplatingObjectListener" which would have performed some pre-persistence actions otherwise.

However if i enable the the listener and re-import the content i get the following error

"java.lang.ClassCastException: java.lang.Integer". I think this is because the packageBody.xml from 7.6 has the TTL value set as Integer and when persisting the value in WEM 8.0 it is unable to convert it to a String.

But this is my theory, any inputs from will be much appreciated.

 

 I have attached the runtime logs from the time this issue happened. the error can be traced in the log file at the following timestamp: 2013-09-09 16:44:05,318

Many Thanks
Atul

Jack_Ji

Hi Atul,

     Try following two ways,

     1. Create a new table which exactly the same with the one you want to export in 7.6 but have TTL as varchar2 type. Change the CTD to use new table. Do table data transformation/copy from old table to new table,  do exporting/importing again.

     2. Create the content with the CTD in 8.0 and export the content, do the same thing in 7.6 and compare the packageBody.xml. Get the difference of TTL field in the xml and change the TTL attribute in 7.6 packageBody.xml to match that in 8.0 then do exporting again.

 

 

Quoted Atul Sood on 2013-09-11 10:35:

 

Hi All,

I am facing an issue when migrating content from VCM 7.6 to WEM 8.0. The problem seems to be with the custom Query Components. Our custom query component has a attribute named TTL whose DataType in VCM 7.6 was NUMBER, but according to the Vignette support, this datatype is not supported in WEM 8.0 and i was asked to change the Datatype to VARCHAR2.

After making the necessary DB changes and CTD structural changes, i was still unable to migrate the content. And as agreed with Support, i disabled the com.vignette.ext.templating.client.javabean.VgnExtTemplatingObjectListener from the events, and then i was able to import the Presentation Pages/Custom Query Components.

However now when i try to update/modify the Default TTL value on the Custom Query component instance, i get the following error

"Unable to commit the content instance: Content is not allowed in prolog"

I have had a look on the Internet about this error, and it seems to be some XML  Parsing exception.

I am confused how to resolve this issue, and hoping someone on this forum might have come across this issue before and knows how to resolve it?

According to me this issue could have been caused as i imported the content after disabling the "VgnExtTemplatingObjectListener" which would have performed some pre-persistence actions otherwise.

However if i enable the the listener and re-import the content i get the following error

"java.lang.ClassCastException: java.lang.Integer". I think this is because the packageBody.xml from 7.6 has the TTL value set as Integer and when persisting the value in WEM 8.0 it is unable to convert it to a String.

But this is my theory, any inputs from will be much appreciated.

 

 I have attached the runtime logs from the time this issue happened. the error can be traced in the log file at the following timestamp: 2013-09-09 16:44:05,318

Many Thanks
Atul