Highlighted
Honored Contributor.
Honored Contributor.
160 views

Error while integrating Ud and AM

Failed pushing to Asset Manager:

Failed executing AQL: INSERT INTO amComputer ( lComputerId, BIOSSource, BiosAssetTag, CPUInternal, CPUType, ComputerDesc, ComputerType, OSBuildNumber, OSServiceLevel, OperatingSystem, PhysicalAddress, Portfolio.Asset.SerialNo, Portfolio.Asset.sMaxCnxCount, Portfolio.CMDBId, Portfolio.GlobalId, Portfolio.dtInvent, Portfolio.lModelId, ScannerDesc, ScannerVersion, TcpIpAddress, TcpIpDomain, TcpIpHostName, Workgroup, bGroup, bTcpIpRouting, dtHardScan, dtLastScan, dtNetworkScan, dtSoftScan, fCPUNumber, lCPUCoreNumber, lCPUSpeedMHz, lColorDepth, lDiskSizeMb, lHorizontalRes, lLogicalCPUNumber, lMaxMemory, lMemorySizeMb, lMinMemory, lNumCorePerCPU, lNumCorePerSocket, lNumSockets, lSwapSizeMb, lVerticalRes) values (145537, null, '3392-6368-0945-5687-3381-1663-61', 'Intel Xeon  X5672', 'Intel Xeon', 'Microsoft Corporation Virtual Machine', 'Windows server computer', '9600', null, 'Windows 2012 R2', '00155D 05791F', '5485-1100-6773-9926-4662-6072-17', null, 'ca3463e067cc52dfd76359ea41fd604d', 'ca3463e067cc52dfd76359ea41fd604d', #2016-03-10 07:31:06#, '138561', null, null, null, 'ho.ndc.net', 'ndcscvmm', null, 0, 0, null, #2016-03-10 07:31:06#, null, null, 1.0, 4, 3200, null, 0.0, null, 0, null, 8192, null, 4, 4, 1, 0, null)

please help , facing below kinds of error 

 

 

 

thanks
0 Likes
5 Replies
Highlighted
Micro Focus Expert
Micro Focus Expert

Re: Error while integrating Ud and AM

Can you paste the error message also ?

I dont see the exception of the error.

0 Likes
Highlighted
Honored Contributor.
Honored Contributor.

Re: Error while integrating Ud and AM

Failed pushing to Asset Manager:

Failed executing AQL: INSERT INTO amComputer ( lComputerId, BIOSSource, BiosAssetTag, CPUInternal, CPUType, ComputerDesc, ComputerType, OSBuildNumber, OSServiceLevel, OperatingSystem, PhysicalAddress, Portfolio.Asset.SerialNo, Portfolio.Asset.sMaxCnxCount, Portfolio.CMDBId, Portfolio.GlobalId, Portfolio.dtInvent, Portfolio.lModelId, ScannerDesc, ScannerVersion, TcpIpAddress, TcpIpDomain, TcpIpHostName, Workgroup, bGroup, bTcpIpRouting, dtHardScan, dtLastScan, dtNetworkScan, dtSoftScan, fCPUNumber, lCPUCoreNumber, lCPUSpeedMHz, lColorDepth, lDiskSizeMb, lHorizontalRes, lLogicalCPUNumber, lMaxMemory, lMemorySizeMb, lMinMemory, lNumCorePerCPU, lNumCorePerSocket, lNumSockets, lSwapSizeMb, lVerticalRes) values (145537, null, '3392-6368-0945-5687-3381-1663-61', 'Intel Xeon  X5672', 'Intel Xeon', 'Microsoft Corporation Virtual Machine', 'Windows server computer', '9600', null, 'Windows 2012 R2', '00155D 05791F', '5485-1100-6773-9926-4662-6072-17', null, 'ca3463e067cc52dfd76359ea41fd604d', 'ca3463e067cc52dfd76359ea41fd604d', #2016-03-10 07:31:06#, '138561', null, null, null, 'ho.ndc.net', 'ndcscvmm', null, 0, 0, null, #2016-03-10 07:31:06#, null, null, 1.0, 4, 3200, null, 0.0, null, 0, null, 8192, null, 4, 4, 1, 0, null)

 

com.hp.ucmdb.adapters.ampush.exception.AMPushDataException: Failed executing AQL: INSERT INTO amComputer ( lComputerId, BIOSSource, BiosAssetTag, CPUInternal, CPUType, ComputerDesc, ComputerType, OSBuildNumber, OSServiceLevel, OperatingSystem, PhysicalAddress, Portfolio.Asset.SerialNo, Portfolio.Asset.sMaxCnxCount, Portfolio.CMDBId, Portfolio.GlobalId, Portfolio.dtInvent, Portfolio.lModelId, ScannerDesc, ScannerVersion, TcpIpAddress, TcpIpDomain, TcpIpHostName, Workgroup, bGroup, bTcpIpRouting, dtHardScan, dtLastScan, dtNetworkScan, dtSoftScan, fCPUNumber, lCPUCoreNumber, lCPUSpeedMHz, lColorDepth, lDiskSizeMb, lHorizontalRes, lLogicalCPUNumber, lMaxMemory, lMemorySizeMb, lMinMemory, lNumCorePerCPU, lNumCorePerSocket, lNumSockets, lSwapSizeMb, lVerticalRes) values (145537, null, '3392-6368-0945-5687-3381-1663-61', 'Intel Xeon  X5672', 'Intel Xeon', 'Microsoft Corporation Virtual Machine', 'Windows server computer', '9600', null, 'Windows 2012 R2', '00155D 05791F', '5485-1100-6773-9926-4662-6072-17', null, 'ca3463e067cc52dfd76359ea41fd604d', 'ca3463e067cc52dfd76359ea41fd604d', #2016-03-10 07:31:06#, '138561', null, null, null, 'ho.ndc.net', 'ndcscvmm', null, 0, 0, null, #2016-03-10 07:31:06#, null, null, 1.0, 4, 3200, null, 0.0, null, 0, null, 8192, null, 4, 4, 1, 0, null)

 

com.hp.ucmdb.adapters.ampush.exception.AMPushDataException: Failed executing AQL: INSERT INTO amComputer ( lComputerId, BIOSSource, BiosAssetTag, CPUInternal, CPUType, ComputerDesc, ComputerType, OSBuildNumber, OSServiceLevel, OperatingSystem, PhysicalAddress, Portfolio.Asset.SerialNo, Portfolio.Asset.sMaxCnxCount, Portfolio.CMDBId, Portfolio.GlobalId, Portfolio.dtInvent, Portfolio.lModelId, ScannerDesc, ScannerVersion, TcpIpAddress, TcpIpDomain, TcpIpHostName, Workgroup, bGroup, bTcpIpRouting, dtHardScan, dtLastScan, dtNetworkScan, dtSoftScan, fCPUNumber, lCPUCoreNumber, lCPUSpeedMHz, lColorDepth, lDiskSizeMb, lHorizontalRes, lLogicalCPUNumber, lMaxMemory, lMemorySizeMb, lMinMemory, lNumCorePerCPU, lNumCorePerSocket, lNumSockets, lSwapSizeMb, lVerticalRes) values (145537, null, '3392-6368-0945-5687-3381-1663-61', 'Intel Xeon  X5672', 'Intel Xeon', 'Microsoft Corporation Virtual Machine', 'Windows server computer', '9600', null, 'Windows 2012 R2', '00155D 05791F', '5485-1100-6773-9926-4662-6072-17', null, 'ca3463e067cc52dfd76359ea41fd604d', 'ca3463e067cc52dfd76359ea41fd604d', #2016-03-10 07:31:06#, '138561', null, null, null, 'ho.ndc.net', 'ndcscvmm', null, 0, 0, null, #2016-03-10 07:31:06#, null, null, 1.0, 4, 3200, null, 0.0, null, 0, null, 8192, null, 4, 4, 1, 0, null)

                at com.hp.ucmdb.adapters.ampush.push.PushDirector.executeAQL(PushDirector.java:1472)

                at com.hp.ucmdb.adapters.ampush.push.PushDirector.insertOrUpdateNode(PushDirector.java:820)

                at com.hp.ucmdb.adapters.ampush.push.PushDirector.executeDependencyNodeTransaction(PushDirector.java:300)

                at com.hp.ucmdb.adapters.ampush.push.PushDirector.legacyTransaction(PushDirector.java:1721)

                at com.hp.ucmdb.adapters.ampush.push.PushDirector.pushToAM(PushDirector.java:114)

                at com.hp.ucmdb.adapters.ampush.AMPushAdapter.pushTreeNodes(AMPushAdapter.java:106)

                at com.hp.ucmdb.adapters.InstancePushAdapter.pushToRemoteDataSource(InstancePushAdapter.java:117)

                at com.hp.ucmdb.adapters.GenericAdapter.updateData(GenericAdapter.java:335)

                at com.hp.ucmdb.adapters.InstancePushAdapter.internalUpdateData(InstancePushAdapter.java:186)

                at com.hp.ucmdb.adapters.push.PushAdapter.internalUpdateData(PushAdapter.java:123)

                at com.hp.ucmdb.adapters.push.PushAdapter.updateData(PushAdapter.java:112)

                at com.hp.ucmdb.dataAccess.manager.DirectBasicDataAdapterWrapper.updateData(DirectBasicDataAdapterWrapper.java:420)

                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:497)

                at com.hp.ucmdb.discovery.probe.processor.GenericPushProbeRequestProcessor.processRequest(GenericPushProbeRequestProcessor.java:36)

                at com.hp.ucmdb.discovery.probe.processor.GenericPushProbeRequestProcessor.processRequest(GenericPushProbeRequestProcessor.java:13)

                at com.hp.ucmdb.discovery.probe.processor.AbstractProbeProcessor.process(AbstractProbeProcessor.java:56)

                at com.hp.ucmdb.discovery.probe.processor.AbstractProbeProcessor.process(AbstractProbeProcessor.java:19)

                at com.hp.ucmdb.discovery.probe.agents.probemgr.adhoctasks.AdHocProbeRequestOperation.performAction(AdHocProbeRequestOperation.java:64)

                at com.hp.ucmdb.discovery.probe.agents.probemgr.taskdispatcher.AdHocTaskDispatcher.dispatchTask(AdHocTaskDispatcher.java:70)

                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:497)

                at sun.reflect.misc.Trampoline.invoke(MethodUtil.java:71)

                at sun.reflect.GeneratedMethodAccessor23.invoke(Unknown Source)

                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

                at java.lang.reflect.Method.invoke(Method.java:497)

                at sun.reflect.misc.MethodUtil.invoke(MethodUtil.java:275)

                at com.sun.jmx.mbeanserver.StandardMBeanIntrospector.invokeM2(StandardMBeanIntrospector.java:112)

                at com.sun.jmx.mbeanserver.StandardMBeanIntrospector.invokeM2(StandardMBeanIntrospector.java:46)

                at com.sun.jmx.mbeanserver.MBeanIntrospector.invokeM(MBeanIntrospector.java:237)

                at com.sun.jmx.mbeanserver.PerInterface.invoke(PerInterface.java:138)

                at com.sun.jmx.mbeanserver.MBeanSupport.invoke(MBeanSupport.java:252)

                at javax.management.StandardMBean.invoke(StandardMBean.java:405)

                at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:819)

                at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:801)

                at javax.management.MBeanServerInvocationHandler.invoke(MBeanServerInvocationHandler.java:292)

                at org.springframework.jmx.access.MBeanClientInterceptor.doInvoke(MBeanClientInterceptor.java:405)

                at org.springframework.jmx.access.MBeanClientInterceptor.invoke(MBeanClientInterceptor.java:353)

                at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

                at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)

                at com.sun.proxy.$Proxy54.dispatchTask(Unknown Source)

                at com.hp.ucmdb.discovery.probe.agents.probegw.managementtasks.adhoctasks.AdhocThread.run(AdhocThread.java:54)

                at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635)

                at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:555)

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

Caused by: java.lang.reflect.UndeclaredThrowableException

                at com.sun.proxy.$Proxy86.execAql(Unknown Source)

                at com.hp.ucmdb.adapters.ampush.push.PushDirector.executeAQL(PushDirector.java:1438)

                ... 48 more

Caused by: java.lang.reflect.InvocationTargetException

                at sun.reflect.GeneratedMethodAccessor140.invoke(Unknown Source)

                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

                at java.lang.reflect.Method.invoke(Method.java:497)

                at com.hp.ucmdb.adapters.ampush.AMApiProxy.invoke(AMApiProxy.java:36)

                ... 50 more

Caused by: Error (12,011): ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert duplicate key row in object 'dbo.amPortfolio' with unique index 'Asgmt_FullName'. The duplicate key value is (/001002/). SQLSTate: 23000

ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated. SQLSTate: 01000

Index error: A record in table 'Portfolio items (amPortfolio)' with the value '/001002/' for field 'Full name (FullName)' already exists in the database.

               

                at com.peregrine.ac.api.AmApi95JNI.AmDbExecAql(Native Method)

                at com.peregrine.ac.api.AmApi95.AmDbExecAql(AmApi95.java:77)

                at com.peregrine.ac.api.AmApi.execAql(AmApi.java:228)

                ... 54 more

thanks
0 Likes
Highlighted
Micro Focus Expert
Micro Focus Expert

Re: Error while integrating Ud and AM

Hi ankita,

 

which version of UD and AM do you have?

 

Thanks,

DCV

0 Likes
Highlighted
Micro Focus Expert
Micro Focus Expert

Re: Error while integrating Ud and AM

... and which CP?

0 Likes
Highlighted
Honored Contributor.
Honored Contributor.

Re: Error while integrating Ud and AM

UD 10.22 and CUp 18 and AM is 9.5

thanks
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.