uCMDB 10.10CUP2and CP 13.3 Integration with Microsoft SCCM 2012

Hello all...,

I'm trying integrate SCCM 2012 with uCMDB 10.10 using the Out of the Box adapter in uCMDB.

But facing an issue when it tries to retrieve the data from SCCM where in it says, The server supports a maximum of 2100 parameters. But what i'm not able decipher is that the error is due to SCCM side SQL server or uCMDB  side.

When you try to google the error statement, the search results shows that the error is on SQL server side but which of the DB server is my question?.

If any of you had faced this issue before and knwo the workaround for this, kindly let me know.

Have pasted the entire error message below.

 

Failed running population. Destination ID: SCCMtoUCMDB, Failed during query: SCCM Nodes Population, all queries: [SCCM Nodes Population], finished queries: [].
ERROR: com.mercury.topaz.cmdb.shared.base.CmdbException: [ErrorCode [802] General Integration Error{SCCMtoUCMDB}]
appilog.framework.shared.manage.impl.MamResponseException: [ErrorCode [802] General Integration Error{SCCMtoUCMDB}]
CMDB Operation Internal Error: class com.mercury.topaz.cmdb.shared.fcmdb.dataAccess.exception.AdapterAccessGeneralException : java.sql.SQLException: [mercury][SQLServer JDBC Driver][SQLServer]The incoming request has too many parameters. The server supports a maximum of 2100 parameters. Reduce the number of parameters and resend the request. : operation DataAccess Query: Retrieve By Pattern From Changes Source Adapter operation
at com.mercury.topaz.cmdb.shared.manage.operation.impl.AbstractCommonOperation.execute(AbstractCommonOperation.java:161)
at com.hp.ucmdb.dataAccess.manager.DataAccessAdapterManagerProbeImpl.executeOperation(DataAccessAdapterManagerProbeImpl.java:50)
at com.hp.ucmdb.discovery.probe.agents.probemgr.adapters.DataAccessAdaptersFacade.invokeOperation(DataAccessAdaptersFacade.java:392)
at com.hp.ucmdb.discovery.probe.services.dynamic.core.AdapterService.getChangesTopologyActionData(AdapterService.java:1072)
at com.hp.ucmdb.discovery.probe.services.dynamic.core.AdapterService.runQueriesOnChangesAdapter(AdapterService.java:791)
at com.hp.ucmdb.discovery.probe.services.dynamic.core.AdapterService.runQueries(AdapterService.java:365)
at com.hp.ucmdb.discovery.probe.services.dynamic.core.AdapterService.runDiscovery(AdapterService.java:199)
at com.hp.ucmdb.discovery.probe.services.dynamic.core.AdapterService.discover(AdapterService.java:150)
at com.hp.ucmdb.discovery.probe.agents.probemgr.taskexecuter.JobExecuter.launchTask(JobExecuter.java:1199)
at com.hp.ucmdb.discovery.probe.agents.probemgr.taskexecuter.JobExecuter$JobExecuterWorker.launch(JobExecuter.java:946)
at com.hp.ucmdb.discovery.probe.agents.probemgr.taskexecuter.JobExecuter$JobExecuterWorker.executeTask(JobExecuter.java:870)
at com.hp.ucmdb.discovery.probe.agents.probemgr.taskexecuter.JobExecuter$JobExecuterWorker.run(JobExecuter.java:733)
Caused by: appilog.framework.shared.manage.impl.MamResponseException: [ErrorCode [802] General Integration Error{SCCMtoUCMDB}]
CMDB Operation Internal Error: class com.mercury.topaz.cmdb.shared.fcmdb.dataAccess.exception.AdapterAccessGeneralException : java.sql.SQLException: [mercury][SQLServer JDBC Driver][SQLServer]The incoming request has too many parameters. The server supports a maximum of 2100 parameters. Reduce the number of parameters and resend the request. : operation DataAccess Query: Retrieve By Pattern From Changes Source Adapter operation
at com.mercury.topaz.cmdb.shared.manage.operation.impl.AbstractCommonOperation$OperationExecuteFlowTrackingCommand.execute(AbstractCommonOperation.java:113)
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:159)
... 11 more
Caused by: com.mercury.topaz.cmdb.shared.fcmdb.dataAccess.exception.AdapterAccessGeneralException: [ErrorCode [802] General Integration Error{SCCMtoUCMDB}]
java.sql.SQLException: [mercury][SQLServer JDBC Driver][SQLServer]The incoming request has too many parameters. The server supports a maximum of 2100 parameters. Reduce the number of parameters and resend the request.
at com.hp.ucmdb.dataAccess.exceptions.ExceptionConverter.createAdapterAccessGeneralException(ExceptionConverter.java:331)
at com.hp.ucmdb.dataAccess.exceptions.ExceptionConverter.createAdapterAccessException(ExceptionConverter.java:165)
at com.hp.ucmdb.dataAccess.exceptions.ExceptionConverter.createAdapterAccessException(ExceptionConverter.java:65)
at com.hp.ucmdb.dataAccess.operations.AbstractDataAccessAdapterOperation.createAdapterAccessException(AbstractDataAccessAdapterOperation.java:54)
at com.hp.ucmdb.dataAccess.operations.AbstractDataAccessAdapterOperation.doExecute(AbstractDataAccessAdapterOperation.java:39)
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)
... 15 more
Caused by: com.mercury.topaz.fcmdb.adapters.dbAdapter.dal.command.exception.FcmdbDalException: [ErrorCode [-2147483648] undefined error code]
java.sql.SQLException: [mercury][SQLServer JDBC Driver][SQLServer]The incoming request has too many parameters. The server supports a maximum of 2100 parameters. Reduce the number of parameters and resend the request.
at com.mercury.topaz.fcmdb.adapters.dbAdapter.DBAdapter.getFullTopology(DBAdapter.java:1124)
at com.hp.ucmdb.dataAccess.operations.DataAccessAdapterQueryRetrieveByPatternFromChangesSource.getResult(DataAccessAdapterQueryRetrieveByPatternFromChangesSource.java:55)
at com.hp.ucmdb.dataAccess.operations.DataAccessAdapterQueryRetrieveByPatternFromChangesSource.doDataAccessQueryExecute(DataAccessAdapterQueryRetrieveByPatternFromChangesSource.java:44)
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)
... 17 more
Caused by: java.sql.SQLException: [mercury][SQLServer JDBC Driver][SQLServer]The incoming request has too many parameters. The server supports a maximum of 2100 parameters. Reduce the number of parameters and resend the request.
at com.mercury.jdbc.sqlserverbase.ddcw.b(Unknown Source)
at com.mercury.jdbc.sqlserverbase.ddcw.a(Unknown Source)
at com.mercury.jdbc.sqlserverbase.ddcv.b(Unknown Source)
at com.mercury.jdbc.sqlserverbase.ddcv.a(Unknown Source)
at com.mercury.jdbc.sqlserver.tds.ddr.v(Unknown Source)
at com.mercury.jdbc.sqlserver.tds.ddr.a(Unknown Source)
at com.mercury.jdbc.sqlserver.tds.ddq.a(Unknown Source)
at com.mercury.jdbc.sqlserver.tds.ddr.a(Unknown Source)
at com.mercury.jdbc.sqlserver.dda3.m(Unknown Source)
at com.mercury.jdbc.sqlserverbase.dde7.e(Unknown Source)
at com.mercury.jdbc.sqlserverbase.dde7.a(Unknown Source)
at com.mercury.jdbc.sqlserverbase.ddd2.a(Unknown Source)
at com.mercury.jdbc.sqlserverbase.dde7.v(Unknown Source)
at com.mercury.jdbc.sqlserverbase.dde7.u(Unknown Source)
at com.mercury.jdbc.sqlserverbase.ddd2.executeQuery(Unknown Source)
at com.mercury.jdbc.sqlserverbase.ddd6.executeQuery(Unknown Source)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at com.mercury.topaz.fcmdb.adapters.dbAdapter.dal.FcmdbDalJPADAO.calculateSqlResult(FcmdbDalJPADAO.java:320)
at com.mercury.topaz.fcmdb.adapters.dbAdapter.dal.FcmdbDalJPADAO.access$300(FcmdbDalJPADAO.java:85)
at com.mercury.topaz.fcmdb.adapters.dbAdapter.dal.FcmdbDalJPADAO$TqlCalculatorWork.execute(FcmdbDalJPADAO.java:640)
at com.mercury.topaz.fcmdb.adapters.dbAdapter.dal.FcmdbDalJPADAO.calculateSqlUsingNativeConnection(FcmdbDalJPADAO.java:268)
at com.mercury.topaz.fcmdb.adapters.dbAdapter.dal.FcmdbDalJPADAO.getResultTopology(FcmdbDalJPADAO.java:260)
at com.mercury.topaz.fcmdb.adapters.dbAdapter.tql.FcmdbTqlCalculator.calculateTqlUsingSql(FcmdbTqlCalculator.java:195)
at com.mercury.topaz.fcmdb.adapters.dbAdapter.tql.FcmdbTqlCalculator.runTql(FcmdbTqlCalculator.java:151)
at com.mercury.topaz.fcmdb.adapters.dbAdapter.tql.FcmdbTqlCalculator.getTopology(FcmdbTqlCalculator.java:91)
at com.mercury.topaz.fcmdb.adapters.dbAdapter.DBAdapter.getInternalTopology(DBAdapter.java:717)
at com.mercury.topaz.fcmdb.adapters.dbAdapter.DBAdapter.getTopologyCmdbFormat(DBAdapter.java:684)
at com.mercury.topaz.fcmdb.adapters.dbAdapter.DBAdapter.getTopology(DBAdapter.java:625)
at com.hp.ucmdb.adapters.sccm.plugins.replication.SccmReplicationPlugin.getTopologyIdsForQuery(SccmReplicationPlugin.java:299)
at com.hp.ucmdb.adapters.sccm.plugins.replication.SccmReplicationPlugin.getFullTopology(SccmReplicationPlugin.java:61)
at com.mercury.topaz.fcmdb.adapters.dbAdapter.DBAdapter.getFullTopology(DBAdapter.java:1118)
... 23 more

Parents Reply Children