Skip to main content
Solved

Heavy migration issues

MWitczak
Hero (Customer)
Forum|alt.badge.img+10

I am trying to bring over customer and supplier invoices using the heavy migration tool.  The containers load successfully, migration prerequisites job executes without error, but when we try to bring over a couple of items to test, nothing is written to the tables.  There are no errors, but it simply leaves the row unprocessed.  The execution log:

Start migration: MTK_SUPPLIER_INVOICE_API/Phase:1 Jun 16, 2020 16:56:17

Live mode migration.

Processing entire primary input cursor.

Displaying message level info1 and higher.

Setting Database Optimizer Object Statistics preference CONCURRENT = OFF . . .

Prerequisites completed successfully.

Migrating invoices matching Company: % and InvoiceNo: % . . .

End migration: MTK_SUPPLIER_INVOICE_API/Phase: 1 Jun 16, 2020 16:56:19

Insert error count:  0

Other error count:  0

Commits performed:  2

Rollbacks performed:  0

TableMonitoring_Update: Oracle Cost Based Optimizer statistics updated in 2 seconds.

 

Is there any way to get any more information?  Without knowing why this row is unprocessed, it is very challenging to troubleshoot.  Thank you in advance for any help.

 

Marty

Best answer by eqbstal

Uh, OK. I would suggest to look at:

I was confused with the ‘IFS Heave Migration Tool'. This doesn't exist as such. Either it is called FND Migration or Data Migration.

Steve

View original
    Did this topic help you find an answer to your question?

    8 replies

    eqbstal
    Superhero (Partner)
    Forum|alt.badge.img+21
    • eqbstal
    • Superhero (Partner)
    • 672 replies
    • June 18, 2020

    Marty,

    I have a IFS Applications back ground and MTK_SUPPLIER_INVOICE_API doesn't ring a bell at all to me. Which application/version are you using?

    Steve

    Thanks for using the community, it helps me. I hope I can help you.
    MWitczak
    Hero (Customer)
    Forum|alt.badge.img+10
    • MWitczak
    • Author
    • Hero (Customer)
    • 59 replies
    • June 18, 2020

    We are using IFS10 Update 6 - working on importing AR and AP invoices.

    eqbstal
    Superhero (Partner)
    Forum|alt.badge.img+21
    • eqbstal
    • Superhero (Partner)
    • 672 replies
    • June 18, 2020

    Marty,

    I have an IFS 10 update 6 environment as well and there is no MTK% view nor MTK% package. I have the idea that this is a custom api.

    Which options (what is the path) are you using in IFS?

    Steve

    Thanks for using the community, it helps me. I hope I can help you.
    MWitczak
    Hero (Customer)
    Forum|alt.badge.img+10
    • MWitczak
    • Author
    • Hero (Customer)
    • 59 replies
    • June 18, 2020

    Steve,

     

    The path is:

    Data Migration Applications → Execution → Migration Execution

     

    We are going from a different ERP system and using the IFS Heavy Migration Tool to bring in this data.

     

    By the way, I appreciate you taking the time to respond to the question!

     

    Marty

    eqbstal
    Superhero (Partner)
    Forum|alt.badge.img+21
    • eqbstal
    • Superhero (Partner)
    • 672 replies
    • Answer
    • June 18, 2020

    Uh, OK. I would suggest to look at:

    I was confused with the ‘IFS Heave Migration Tool'. This doesn't exist as such. Either it is called FND Migration or Data Migration.

    Steve

    Thanks for using the community, it helps me. I hope I can help you.
    MWitczak
    Hero (Customer)
    Forum|alt.badge.img+10
    • MWitczak
    • Author
    • Hero (Customer)
    • 59 replies
    • June 18, 2020

    Understood.  I am new to data migration - this is my first foray using the MTK module and we have a couple hundred to bring in.  Is the method I was referring to as the “Heavy Migration Tool” simply known as “Data Migration?”

    eqbstal
    Superhero (Partner)
    Forum|alt.badge.img+21
    • eqbstal
    • Superhero (Partner)
    • 672 replies
    • June 18, 2020

    This is what I understand to be data migration:

     

    Thanks for using the community, it helps me. I hope I can help you.
    MWitczak
    Hero (Customer)
    Forum|alt.badge.img+10
    • MWitczak
    • Author
    • Hero (Customer)
    • 59 replies
    • June 18, 2020

    Steve,

     

    OK.  Thank you for your input - we are going to look at your suggestion of using the external file to start.  I appreciate the suggestion!

     

    Marty

    Reply


    Terms & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings