Discovery module is not working after an upgrade

  • KM03690210
  • 13-Aug-2020
  • 13-Aug-2020

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

  1. Make sure Postgres repository is properly upgraded. Discovery 1.6.6 (SDM 7.64) supports Postgres 12.
  2. Read Chapter 3: Upgrade Discovery  in Upgrade Guide 7.64
  3. Do steps included in that guide, in order to do a succesfull Discovery upgrade.
  4. https://mysupport.microfocus.com/document