Skip to main content
Best answer by HelesicPetr

Hi @RS_10128209 

Maybe you use wrong type.

it is hard to say if you do not provide full log error.

PetrH

5 replies

MarcoTosin
MarcoTosin21-Topaz I
21-Topaz I
March 23, 2023

I think that, in order to get a response from some experienced users in the community, this request needs to be much more detailed.
The way it is worded it is too general.

 

Marco
    HelesicPetr
    HelesicPetr22-Sapphire II
    22-Sapphire II
    March 23, 2023

    Hi @RS_10128209 

    A general question can be answered just with general answer.

     

    1. Plan what data are migrated

    2. Create MAP of your  data in a old system and in a new system

    3 Define what information should be migrated based on the map 

    4. Define a way how the information are migrated 

    5  Find or crate tool for migration

    6 Test the migration on just small amount data

    7 Test full migration

    9 identify the problem data

    10 solve problem data

    11 plan the production migration.

     

    I may forget some steps but generally this is good start

     

    PetrH

    R
    RS_1012820912-AmethystAuthor
    12-Amethyst
    March 28, 2023

    Hi @HelesicPetr Thanks for the reply.

    I have performed all steps and loaded wtdocument into target but while loading Content of wtdocument using its throwing me a error query

     

    SELECT staging.sequencenumber AS SEQUENCENUMBER ,staging.type AS CLASS FROM CONTENTMETADATA staging, CONTENTMETADATAWBMStatus st WHERE staging.migrated =0 AND staging.sequencenumber = st.sequencenumber AND st.POSTVERIFICATIONSTATUS IS NULL AND st.loadstatus = 'STARTED';

     

    Everything is right but as its trying to fetch sequencenumber and type from CONTENTMETADATA and CONTENTMETADATAWBMStatus, Type is not available in CONTENTMETADATAWBMStatus then how it will pass the query?

    HelesicPetr
    HelesicPetr22-Sapphire IIAnswer
    22-Sapphire II
    March 28, 2023

    Hi @RS_10128209 

    Maybe you use wrong type.

    it is hard to say if you do not provide full log error.

    PetrH

    Terms & ConditionsAccessibility statement