E1: OMW: TDA: Database Password Entry Box Pops Up in OMW (Fat Client) When Performing Table / Index Generation (Doc ID 2826098.1)

Last updated on MAY 08, 2023

Applies to:

Symptoms

Database Password Entry pop up windows appears when doing Table / Index Generation in Object Management Workbench (OMW) in either Business Data - TEST (TESTDTA) or Business Data - CRP (CRPDTA).

The following errors are seen in the fat client jdedebug.log:

In this particular case, there are 2 database instances:

Production Database Instance : <Database1> where the following data sources reside: PRODDTA, PRODCTL, SY920, OL920, SVM920, DD920, DV920, PY920, PD920, PS920

Test Database Instance : <Database2> where the following data sources reside: CRPDTA, CRPCTL, TESTDTA, TESTCTL

(Note that the System - 920 data source (SY920) exists in <Database1>)

Below are the settings from the fat client jde.ini :

[DB SYSTEM SETTINGS]
Version=43
Default User=JDE
Default Role=*ALL
Default Env=DV920
Default PathCode=DV920
Base Datasource=System - 920
Object Owner=SY920
Server=<ServerName>
Database=<Database1>
Load Library=
Decimal Shift=Y
Julian Dates=Y
Use Owner=Y
Secured=Y
Type=O
...

Changes

Cause

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