Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Migration of 2.3.1 example does not work in windows 11g XE HR Schema, 0 items processed #5

Open
tkleiber opened this issue Sep 13, 2017 · 2 comments

Comments

@tkleiber
Copy link

Hi!

Despite I have run the example before, so an entry is listed in ut_package, the migration package does not process anything.

See attached sql script and outputs from sql developer.

utplsql_migrate_2_to_3.sql.txt
utplsql_migrate_2_to_3.dbms.output.txt
utplsql_migrate_2_to_3.script.output.txt

Kind regards
Torsten

@jgebal
Copy link
Member

jgebal commented Sep 14, 2017

Hi @tkleiber,
Thanks for detailed report.
Let us review it and get back to you.

@just-doit
Copy link

just-doit commented Nov 13, 2019

Hi,

I think the SELECT statement in ut_v2_migration.migrate_v2_packages is not correct. In my case it returns no rows. After changing it to

SELECT p.owner,
       p.prefix || p.name AS name,
       p.description AS package_desc,
       NVL(p.prefix, c.prefix) prefix,
       s.name suite_name,
       s.description AS suite_desc,
       o.status
  FROM utp.ut_package p, utp.ut_suite s, utp.ut_config c, all_objects o
 WHERE     p.id IN (  SELECT MAX(p2.id) KEEP (DENSE_RANK FIRST ORDER BY p2.suite_id DESC NULLS LAST)
                        FROM utp.ut_package p2
                    GROUP BY UPPER(p2.owner), UPPER(p2.name))
       AND p.suite_id = s.id(+)
       AND p.owner = c.username(+)
       AND p.owner = o.owner
       AND p.prefix || p.name = o.object_name
       AND o.object_type IN ('PACKAGE')
       AND p.owner = NVL(:a_owner_name, p.owner)
       AND p.name = NVL(:a_package_name, p.name)
       AND (   s.name = :a_suite_name
            OR :a_suite_name IS NULL)

it worked.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants