Planning Analytics with Watson

I've installed Predictive insights v 1.3.6, I've created a model and deployed the model successfully using APM db2 data source connection following this topic:

https://www.ibm.com/support/pages/predictive-insights-extracting-data-apm

When I tried to use the integration pack in the following link:

https://www.ibm.com/support/knowledgecenter/en/SSJQQ3_1.3.6/com.ibm.scapi.doc/admin_guide/t_oapi_adminguide_configurepmmodel.html

The model deployment didn't work giving me this error:

Could not access datasource

jdbc:db2://192.168.11.20:50000/WAREHOUS

com.ibm.tivoli.netcool.pa.mediation.model.validate.ModelValidationException: Could not access datasource

jdbc:db2://192.168.1.210:50000/WAREHOUS

Schema name db2apm in invalid

The schema name is :ITMUSER not db2apm

The username is db2apm

When I use test connection, the connection is successful

When I tried to deploy the first model that I created before using integration Pack model it gave me the same error

Here is the log file from "mediationtool.log" file

DEBUGreleasing instance

DEBUGCP_DISCONNECT-144-jdbc:db2://192.168.1.210:50000/WAREHOUS-null

DEBUGcall have been destroyed

DEBUGpreparing new instance for source

DEBUG not found in the cache - create it source

DEBUGconfiguring connection ...

DEBUGDB_URL jdbc:db2://192.168.1.210:50000/WAREHOUS

DEBUGDB_TESTSQL null

DEBUGDB_USER db2apm

DEBUGCP_NEW_POOL-144-jdbc:db2://192.168.1.210:50000/WAREHOUS

DEBUGCP_NEW_CONNECTION-144-jdbc:db2://192.168.1.210:50000/WAREHOUS-null

DEBUG[java.lang.Thread.getStackTraceImpl(Native Method), java.lang.Thread.getStackTrace(Thread.java:1117), com.ibm.tivoli.netcool.pa.dao.ConnectionPool.getConnection(ConnectionPool.java:335), com.ibm.tivoli.netcool.pa.dao.ConnectionPool.getConnection(ConnectionPool.java:297), com.ibm.tivoli.netcool.pa.mediation.source.db.DatabaseSource.<init>(DatabaseSource.java:63), com.ibm.tivoli.netcool.pa.mediation.source.IoFactory$DataSourcePool.createInstance(IoFactory.java:55), com.ibm.tivoli.netcool.pa.mediation.source.IoFactory$DataSourcePool.createInstance(IoFactory.java:35), com.ibm.tivoli.netcool.pa.mediation.source.AbstractPool.create(AbstractPool.java:74), com.ibm.tivoli.netcool.pa.mediation.source.IoFactory.createDataSource(IoFactory.java:133), com.ibm.tivoli.netcool.pa.mediation.model.ModelConfigManagerImpl.validateConnection(ModelConfigManagerImpl.java:141), com.ibm.tivoli.pa.model.ui.edit.ConnectionTestWorkspaceOperation$1.call(ConnectionTestWorkspaceOperation.java:51), com.ibm.tivoli.pa.model.ui.edit.ConnectionTestWorkspaceOperation$1.call(ConnectionTestWorkspaceOperation.java:47), java.util.concurrent.FutureTask.run(FutureTask.java:277), java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1153), java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628), java.lang.Thread.run(Thread.java:785)]

TRACEvalidate schema [ITMUSER] for datasource

TRACEdatabase metadata obtained from connection

TRACEobtained list of schemas from database metadata

TRACEschema discovered: 1

TRACEschema name: IBM_TRAM

TRACEschema discovered: 2

TRACEschema name: ITMUSER

TRACEschema found matching case

DEBUGpreparinfg of call for source completed

DEBUGreleasing instance

DEBUGcall not found in the cache - nothing to do

DEBUGpreparing new instance for null

DEBUG not found in the cache - create it null

TRACEvalidate schema [db2apm] for datasource

TRACEdatabase metadata obtained from connection

TRACEobtained list of schemas from database metadata

TRACEschema discovered: 1

TRACEschema name: IBM_TRAM

TRACEschema discovered: 2

TRACEschema name: ITMUSER

TRACEschema discovered: 3

TRACEschema name: NULLID

TRACEschema discovered: 4

TRACEschema name: SQLJ

TRACEschema discovered: 5

TRACEschema name: SYSCAT

TRACEschema discovered: 6

TRACEschema name: SYSFUN

TRACEschema discovered: 7

TRACEschema name: SYSIBM

TRACEschema discovered: 8

TRACEschema name: SYSIBMADM

TRACEschema discovered: 9

TRACEschema name: SYSIBMINTERNAL

TRACEschema discovered: 10

TRACEschema name: SYSIBMTS

TRACEschema discovered: 11

TRACEschema name: SYSPROC

TRACEschema discovered: 12

TRACEschema name: SYSPUBLIC

TRACEschema discovered: 13

TRACEschema name: SYSSTAT

TRACEschema discovered: 14

TRACEschema name: SYSTOOLS

TRACEmore then one schema found not matching case, can't choose

INFOERR_DB_CONFIG_FAILED[,For database URL: jdbc:db2://192.168.1.210:50000/WAREHOUS]

!ENTRY com.ibm.tivoli.pa.model.ui.nature 4 0 2020-12-05 20:12:17.349

!MESSAGE Unexpected Exception

!STACK 0

java.util.concurrent.ExecutionException: com.ibm.tivoli.netcool.pa.mediation.model.validate.ModelValidationException: Could not access datasource

jdbc:db2://192.168.1.210:50000/WAREHOUS

at java.util.concurrent.FutureTask.report(FutureTask.java:133)

at java.util.concurrent.FutureTask.get(FutureTask.java:203)

at com.ibm.tivoli.pa.model.ui.edit.SynchronizedWorkspaceOperation.call(SynchronizedWorkspaceOperation.java:123)

at com.ibm.tivoli.pa.model.ui.edit.MultiModelDeployWorkspaceOperation.execute(MultiModelDeployWorkspaceOperation.java:126)

at com.ibm.tivoli.pa.model.ui.edit.MultiModelDeployWorkspaceOperation.execute(MultiModelDeployWorkspaceOperation.java:51)

at com.ibm.tivoli.pa.model.ui.edit.SynchronizedWorkspaceOperation.execute(SynchronizedWorkspaceOperation.java:103)

at org.eclipse.ui.actions.WorkspaceModifyOperation$1.run(WorkspaceModifyOperation.java:106)

at org.eclipse.core.internal.resources.Workspace.run(Workspace.java:2313)

at org.eclipse.ui.actions.WorkspaceModifyOperation.run(WorkspaceModifyOperation.java:118)

at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:122)

Caused by: com.ibm.tivoli.netcool.pa.mediation.model.validate.ModelValidationException: Could not access datasource

jdbc:db2://192.168.1.210:50000/WAREHOUS

at com.ibm.tivoli.netcool.pa.mediation.model.ModelConfigManagerImpl.validateConnection(ModelConfigManagerImpl.java:146)

at com.ibm.tivoli.netcool.pa.mediation.model.ModelConfigManagerImpl.createConn(ModelConfigManagerImpl.java:895)

at com.ibm.tivoli.netcool.pa.mediation.model.ModelConfigManagerImpl.listTopics(ModelConfigManagerImpl.java:861)

at com.ibm.tivoli.pa.model.ui.edit.MultiModelDeployWorkspaceOperation.mergeModels(MultiModelDeployWorkspaceOperation.java:223)

at com.ibm.tivoli.pa.model.ui.edit.MultiModelDeployWorkspaceOperation.deployModels(MultiModelDeployWorkspaceOperation.java:131)

at com.ibm.tivoli.pa.model.ui.edit.MultiModelDeployWorkspaceOperation$1.call(MultiModelDeployWorkspaceOperation.java:120)

at com.ibm.tivoli.pa.model.ui.edit.MultiModelDeployWorkspaceOperation$1.call(MultiModelDeployWorkspaceOperation.java:116)

at java.util.concurrent.FutureTask.run(FutureTask.java:277)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1153)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)

at java.lang.Thread.run(Thread.java:785)

Caused by: com.ibm.tivoli.netcool.pa.mediation.MediationException: ERR_CONFIGURATION

at com.ibm.tivoli.netcool.pa.mediation.source.db.DatabaseSource.<init>(DatabaseSource.java:87)

at com.ibm.tivoli.netcool.pa.mediation.source.IoFactory$DataSourcePool.createInstance(IoFactory.java:55)

at com.ibm.tivoli.netcool.pa.mediation.source.IoFactory$DataSourcePool.createInstance(IoFactory.java:35)

at com.ibm.tivoli.netcool.pa.mediation.source.AbstractPool.create(AbstractPool.java:74)

at com.ibm.tivoli.netcool.pa.mediation.source.IoFactory.createDataSource(IoFactory.java:133)

at com.ibm.tivoli.netcool.pa.mediation.model.ModelConfigManagerImpl.validateConnection(ModelConfigManagerImpl.java:141)

... 10 more

Caused by: com.ibm.tivoli.netcool.pa.mediation.model.validate.ModelValidationException: Schema name db2apm in invalid

at com.ibm.tivoli.netcool.pa.mediation.source.db.DatabaseSource.<init>(DatabaseSource.java:81)

... 15 more

The solution is: you have to make sure you are deploying the PI model into the SCAPIDB database, which id the PI database not the database you are importing the data from.