This document has not been formally reviewed for accuracy and is provided "as is" for your convenience.
Summary
Discovery module is not runnig using command line and GUI
Error
Aug 06, 2020 5:41:24 PM groovy.sql.Sql$AbstractQueryCommand execute
WARNING: Failed to execute: SELECT count(*) as cnt FROM obtdiscovery.obtsdd_datasource because: ERROR: relation "obtdiscovery.obtsdd_datasource" does not exist
Position: 29
Aug 06, 2020 5:41:24 PM groovy.sql.Sql$AbstractQueryCommand execute
WARNING: Failed to execute: SELECT count(*) as cnt FROM obtdiscovery.obtsdd_datasource because: ERROR: relation "obtdiscovery.obtsdd_datasource" does not exist
Position: 29
Exception in thread "main" java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.outerbay.foundation.services.util.OBTLoader.main(OBTLoader.java:119)
Caused by: org.postgresql.util.PSQLException: ERROR: relation "obtdiscovery.obtsdd_datasource" does not exist
Position: 29
Cause
In Discovery 1.6.5 there are 20 tables in obtdiscovery schema. In Discovery 1.6.6 there are 7 more additional tables obtsdd_datasource is one of those missing tables.
Fix
- Make sure Postgres repository is properly upgraded. Discovery 1.6.6 (SDM 7.64) supports Postgres 12.
- Read Chapter 3: Upgrade Discovery in Upgrade Guide 7.64
- Do steps included in that guide, in order to do a succesfull Discovery upgrade.
- https://mysupport.microfocus.com/document