No TQL Query Configured in smPopConf.xml

Error Message

If you have not yet added a TQL query to your job, you cannot select this query from the list while you create or update your job.

If you have already added this TQL query to your job, but forgot to add the configuration for this query in smPopConf.xml, you will get a “Failed” status while you run this population job. In addition, in the Universal CMDB studio, you will get an error message like the following (see How to Check the Error Message of a Failed Population Job).

running population. Destination ID: sm, Failed during query: SM Business Application Population 2.0, all queries: [SM Business Application Population 2.0, SM Business Service Population 2.0],  finished queries: [].
ERROR: com.mercury.topaz.cmdb.shared.base.CmdbException: [ErrorCode [802] General Integration Error{sm}]
appilog.framework.shared.manage.impl.MamResponseException: [ErrorCode [802] General Integration Error{sm}]
CMDB Operation Internal Error: class com.mercury.topaz.cmdb.shared.fcmdb.dataAccess.exception.AdapterAccessGeneralException : Unsupported Query [SM Business Application Population 2.0], only population TQL is supported : operation Data Access Adapter Query: Retrieve Changed Data
	at com.mercury.topaz.cmdb.shared.manage.operation.impl.AbstractCommonOperation.execute(AbstractCommonOperation.java:160)
	at com.hp.ucmdb.dataAccess.manager.DataAccessAdapterManagerProbeImpl.executeOperation(DataAccessAdapterManagerProbeImpl.java:50)
	at com.hp.ucmdb.discovery.probe.agents.probemgr.adapters.DataAccessAdaptersFacade.invokeOperation(DataAccessAdaptersFacade.java:406)
	at com.hp.ucmdb.discovery.probe.services.dynamic.core.AdapterService.runChangesOnPopulateChangesAdapter(AdapterService.java:1262)
	at com.hp.ucmdb.discovery.probe.services.dynamic.core.AdapterService.runQueriesOnPopulateChangesAdapter(AdapterService.java:1102)
	at com.hp.ucmdb.discovery.probe.services.dynamic.core.AdapterService.runQueries(AdapterService.java:354)
	at com.hp.ucmdb.discovery.probe.services.dynamic.core.AdapterService.runDiscovery(AdapterService.java:198)
	at com.hp.ucmdb.discovery.probe.services.dynamic.core.AdapterService.discover(AdapterService.java:149)
	at com.hp.ucmdb.discovery.probe.agents.probemgr.taskexecuter.JobExecuter.launchTask(JobExecuter.java:1188)
	at com.hp.ucmdb.discovery.probe.agents.probemgr.taskexecuter.JobExecuter$JobExecuterWorker.launch(JobExecuter.java:945)

In the fcmdb.push.all.log file, you can find more details like the following:

2014-11-20 10:40:50,949 [JobExecuterWorker-0:DS_sm_SM BS pop] ERROR - sm >> Fail to Create or Return PopulationConnectorOutput
com.hp.ucmdb.federationspi.exception.DataAccessGeneralException: Unsupported Query [SM Business Application Population 2.0], only population TQL is supported
	at com.hp.ucmdb.adapter.smpush.ServiceManagerGenericAdapter.populate(ServiceManagerGenericAdapter.java:337)
	at com.hp.ucmdb.adapters.GenericAdapter.getChanges(GenericAdapter.java:881)
	at com.hp.ucmdb.dataAccess.operations.DataAccessAdapterQueryRetrieveChanges.getChangesResult(DataAccessAdapterQueryRetrieveChanges.java:50)
	at com.hp.ucmdb.dataAccess.operations.DataAccessAdapterQueryRetrieveChanges.doDataAccessQueryExecute(DataAccessAdapterQueryRetrieveChanges.java:38)
	at com.hp.ucmdb.dataAccess.operations.AbstractDataAccessLifeCycleAdapterQuery.doLifeCycleExecute(AbstractDataAccessLifeCycleAdapterQuery.java:34)
	at com.hp.ucmdb.dataAccess.operations.AbstractDataAccessLifeCycleAdapterOperation.doDataAccessExecute(AbstractDataAccessLifeCycleAdapterOperation.java:57)
	at com.hp.ucmdb.dataAccess.operations.AbstractDataAccessAdapterOperation.dataAccessExecute(AbstractDataAccessAdapterOperation.java:59)
	at com.hp.ucmdb.dataAccess.operations.AbstractDataAccessAdapterOperation.doExecute(AbstractDataAccessAdapterOperation.java:37)
	at com.mercury.topaz.cmdb.shared.manage.operation.impl.AbstractFrameworkOperation.commonExecute(AbstractFrameworkOperation.java:17)
	at com.mercury.topaz.cmdb.shared.manage.operation.impl.AbstractCommonOperation$OperationExecuteFlowTrackingCommand.execute(AbstractCommonOperation.java:87)
	at com.mercury.topaz.cmdb.shared.manage.operation.impl.AbstractCommonOperation$OperationExecuteFlowTrackingCommand.execute(AbstractCommonOperation.java:60)
	at com.mercury.topaz.cmdb.shared.manage.flowmanagement.api.FlowManager.execute(FlowManager.java:227)
	at com.mercury.topaz.cmdb.shared.manage.operation.flow.OperationInFlowDefaultExecutor.execute(OperationInFlowDefaultExecutor.java:23)
	at com.mercury.topaz.cmdb.shared.manage.operation.impl.AbstractCommonOperation.execute(AbstractCommonOperation.java:158)
	at com.hp.ucmdb.dataAccess.manager.DataAccessAdapterManagerProbeImpl.executeOperation(DataAccessAdapterManagerProbeImpl.java:50)
	at com.hp.ucmdb.discovery.probe.agents.probemgr.adapters.DataAccessAdaptersFacade.invokeOperation(DataAccessAdaptersFacade.java:406)
	at com.hp.ucmdb.discovery.probe.services.dynamic.core.AdapterService.runChangesOnPopulateChangesAdapter(AdapterService.java:1262)
	at com.hp.ucmdb.discovery.probe.services.dynamic.core.AdapterService.runQueriesOnPopulateChangesAdapter(AdapterService.java:1102)
	at com.hp.ucmdb.discovery.probe.services.dynamic.core.AdapterService.runQueries(AdapterService.java:354)
	at com.hp.ucmdb.discovery.probe.services.dynamic.core.AdapterService.runDiscovery(AdapterService.java:198)
	at com.hp.ucmdb.discovery.probe.services.dynamic.core.AdapterService.discover(AdapterService.java:149)
	at com.hp.ucmdb.discovery.probe.agents.probemgr.taskexecuter.JobExecuter.launchTask(JobExecuter.java:1188)
	at com.hp.ucmdb.discovery.probe.agents.probemgr.taskexecuter.JobExecuter$JobExecuterWorker.launch(JobExecuter.java:945)
	at com.hp.ucmdb.discovery.probe.agents.probemgr.taskexecuter.JobExecuter$JobExecuterWorker.executeTask(JobExecuter.java:867)
	at com.hp.ucmdb.discovery.probe.agents.probemgr.taskexecuter.JobExecuter$JobExecuterWorker.run(JobExecuter.java:728)

Solution

Search for text string “Unsupported Query by this adapter” to find out the TQL query name that has not yet been configured, and then configure it in the smPopConf.xml file.