ARCHIVED E1: TC: Custom TCs Fail Locally after Tools Release upgrade with error "JDB9900419 - No roles assigned to user" (Doc ID 652202.1)

Last updated on JANUARY 03, 2023

Applies to:

This document was previously published as Customer Connection Solution 201031186

Symptoms

I receive an error on all custom Table Conversion (TC) programs when attempting to either run the TC locally or open the TC in design after upgrading my tools release to 8.94.O2. Before the tools release upgrade, I was on 8.94.D1 and table conversions worked fine. If I revert back to 8.94.D1, the table conversions will work again successfully.

I receive the following errors in the JDE.LOG file.

484/500 MAIN_THREAD                                Tue Mar 29 09:17:23.684022              Jdb_ctl.c3381

            Starting OneWorld

484/500 MAIN_THREAD                                Tue Mar 29 09:17:41.137000              Jdb_omp1.c1775

            JDB9900419 - No roles assigned to user <USER>

484/500 MAIN_THREAD                                Tue Mar 29 09:17:41.247085              Jdb_ctl.c3763

            JDB9901500 - No role associated with the *ALL.  Failed to signon the user.

I also gets the following error when going into Start Table Conversion Design Aid from OMW.

            Unable to load input environment.

Changes

 Beginning with Tools Release 8.94.E1, users using *ALL role to sign on may experience this problem.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.