Updated August 2, 2016
When trying to register an Oracle instance, the wizard can error out with the following error:
org.springframework.webflow.execution.ActionExecutionException: Exception thrown executing [AnnotatedAction@34a37e84 targetAction = [RegisterMonDbAction@328c7c34 formObjectName = 'idcFormData',formObjectClass = RegisterMonDbData, formObjectScope = FLOW], attributes = map['method' -> 'calidateConnInfo']] in state 'validateConnInfo' of flow 'register-mondb-flow' -- action execution attributes were 'mapempty'
With the following error stack:
StatementCallback; SQL [SELECT tsdata.tablespace_name,tsdata.megsfree,tsdata.initial_extent,tsdata.min_extents,tsdata.next_extent,tsdata.pct_increaseDECODE (NVL (filedata.tablespace_name, ''), '', 'NO', 'YES')autoextensible FROM ( SELECT t.tablespace_name,NVL (FLOOR (SUM (f.bytes) / 1024 / 1024), 0) megsfree,
t.initial_extent,t.min_extents,t.next_extent,t.pct_increaseFROM dba_tablespaces t, dba_free_space fWHERE t.tablespace_name = f.tablespace_name(+) AND t.contents <> 'TEMPORARY' AND t.contents <> 'UNDO'
AND t.status = 'ONLINE' GROUP BY t.tablespace_name,t.initial_extent,t.min_extents,t.next_extent,t.pct_increase) tsdata,
(SELECT DISTINCT tablespace_name
FROM dba_data_files
WHERE autoextensible = 'YES' AND status = 'AVAILABLE') filedata
WHERE tsdata.tablespace_name = filedata.tablespace_name(+)
ORDER BY tablespace_name]
Any Oracle environment and version
We run this query to validate tablespace information in the target instance and it can timeout or not return expected data.