ORDS 22.1:DATABASE ACTIONS: No Data is Displayed for Tables//Views (Doc ID 2868414.1)

Last updated on AUGUST 08, 2023

Applies to:

Symptoms

Post ORDS upgrade to 22.1, the SQL Developer Web(Database Actions) are not displaying data
for Tables/Views. The same was working in ORDS 21.4.2.

Following error occurs in browser console:

ojcorebundle.js:8 Converter of type datetime cannot be found. Please import the ojs/ojvalidation-datetime module.
main.js:70 Uncaught (in promise) TypeError: Unable to process binding "ojModule: function(){return {
viewName:'sdw/core/browser/Controls',viewModelFactory:{
createViewModel:$module['createControlsVM']}} }"
Message: Cannot read properties of null (reading 'createConverter')
at main.js:70:3987
at p._initFilterDataTypes (main.js:70:4017)
at new p (main.js:69:29725)
at Object.a.createControlsVM [as createViewModel] (main.js:72:16695)
at Object.ignore [as ignoreDependencies] (oj3rdpartybundle.js:17:5762)
at t.computed.disposeWhenNodeIsRemoved (ojcorebundle.js:22:167239)
at Function.evaluateImmediate_CallReadThenEndDependencyDetection (oj3rdpartybundle.js:17:17328)
at Function.evaluateImmediate_CallReadWithDependencyDetection (oj3rdpartybundle.js:17:16700)
at Function.evaluateImmediate (oj3rdpartybundle.js:17:16244)
at Object.a.computed.a.dependentObservable (oj3rdpartybundle.js:17:13938)

STEPS
-----------------------

1. Log into SQL Developer web.
2. Clicked on 'SQL' to open SQL Worksheet.
3. Right client and open any table.
4. Click on 'Data' to get data. But data is not displayed.

Changes

 ORDS was upgraded to 22.1

Cause

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