This discussion is archived
1 Reply Latest reply: Jan 3, 2013 2:38 AM by wkobargs RSS

Data Quality tab for migration isn't working as expected.

570934 Newbie
Currently Being Moderated
I was doing a test migration from DB2 (9.7) database to Oracle 11g using SQL Developer Version 3.2.20.09 Build MAIN-09.87. I found that the Data Quality tab for record count comparison from migration project wasn't working as expected.
It’s not showing the record count from source database. It is showing following error in logging page after every refresh. It is happening because tool is populating SOURCENAME as "DB2"."SCHEMANAME"."TABLENAME" whereas the SOURCENAME should be consist of schema name and table name only. I have gone through the MD_META package and Database views, which are written for repository and found that its appending catalog name in case of source database is DB2.

Is this a known issue? Do we have fix available? I think we need a change in QUOTE function of MD_META package and DB views. Please suggest.


SEVERE     1377     2     oracle.dbtools.db.DBUtil     Warning, unhandled exception: DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC: DB2.CDSWEB.PRODUCTLICTYPE
  • 1. Re: Data Quality tab for migration isn't working as expected.
    wkobargs Journeyer
    Currently Being Moderated
    Hello,
    Is this a known issue?
    Yes, it is a known issue. Bug 11778359: DB2:RUN DATA QUALITY REPORT GET UNHANDLED EXCEPTION: DB2 SQL ERROR
    The bug is unpublished so you can't see it in My Oracle Support, I just mentioned it for reference.
    Do we have fix available?
    Not yet. A fix shall be available in a future version of SQL Developer. Don't ask me in which one and when, I have no idea.
    I think we need a change in QUOTE function of MD_META package and DB views
    I don't agree. I don't know what might break if you manipulate that package.

    Sorry that I have no better answer.

    Best regards
    Wolfgang

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points