My Oracle Support Banner

E1: TDA: Table Generation Fails with Error 'Create Table Failed' On-Screen and "Could not find database ID <ID>, name '<name>'. The database may be offline. Wait a few minutes and try again" in the jde log - Specific to SQL Server database (Doc ID 2956468.1)

Last updated on JUNE 21, 2023

Applies to:

JD Edwards EnterpriseOne Tools - Version 9.2 and later
Information in this document applies to any platform.
Specific to SQL Server database


When trying to generate tables in a specific environment datasource, the generation fails with below error message:

Steps to replicate:

  1. Login to a JDE Fat client /Development Client Machine
  2. Open application P98220 - 'Object Management Workbench' (OMW) by typing OMW in Fast Path
  3. Add the custom table to any test project and click on 'Design' button
  4. Click on the tab 'Table Operations'
  5. Click on 'Generate Table' button
  6. Select the required datasource in datasource field and enter the owner's password if required by your setup
  7. Click OK
  8. Notice the Error "Create Table Failed' on screen


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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