Highlighted
Honored Contributor.
Honored Contributor.
292 views

uCMDB - Asset Manager Integration - Failed pushing CIs

Hi,

We are getting an error following types of error while pushing CIs from uCMDB into Asset Manager using AMGenericAdapter.

Type1: 

Caused by: Error (12,001): line 1: syntax error 'swap'; 'swap' should be Select_field
line 1: syntax error 'swap'; 'swap' should be CLOSEPAR
line 1: syntax error ','; ',' should be Eof
Format error:

at com.peregrine.ac.api.AmApi97JNI.AmDbExecAql(Native Method)
at com.peregrine.ac.api.AmApi97.AmDbExecAql(AmApi97.java:81)
at com.peregrine.ac.api.AmApi.execAql(AmApi.java:228)
... 49 more
INSERT INTO amLogicalDrive ( lLogDriveId, Device, GlobalId, Label, Media, MountPoint, Name, Type, lCompId, lFreeSpaceMb, lTotalSizeMb) values (12286162, 'swap', '439e192e8e7ca1cabe9ebe2a63465623', '/system/volatile', 'FixedDisk', '/syst

[VALUE CUT OFF DUE TO SIZE LIMIT]

 

Type 2

Caused by: Error (12,001): line 1: syntax error 'tmpfs
'; 'tmpfs
' should be Select_field
line 1: syntax error ''; '' should be Eof
Format error:

at com.peregrine.ac.api.AmApi97JNI.AmDbExecAql(Native Method)
at com.peregrine.ac.api.AmApi97.AmDbExecAql(AmApi97.java:81)
at com.peregrine.ac.api.AmApi.execAql(AmApi.java:228)
... 50 more
UPDATE amLogicalDrive SET Device = 'swap', GlobalId = '40ae0de3667295b8afdf1b104b86e6fe', Label = '/tmp', Media = 'FixedDisk', MountPoint = '/tmp', Name = 'swap', Type = 'tmpfs
swap', lCompId = '2969691', lFreeSp

[VALUE CUT OFF DUE TO SIZE LIMIT]

 

Type 3

Caused by: Error (12,001): line 1: syntax error 'PKGPARAM: ERROR: UNABLE TO LOCATE PARAMETER INFORMATION FOR "SUNWEXPLU"
'; 'PKGPARAM: ERROR: UNABLE TO LOCATE PARAMETER INFORMATION FOR "SUNWEXPLU"
' should be Select_field
line 1: syntax error ''; '' should be Eof
Format error:

at com.peregrine.ac.api.AmApi97JNI.AmDbExecAql(Native Method)
at com.peregrine.ac.api.AmApi97.AmDbExecAql(AmApi97.java:81)
at com.peregrine.ac.api.AmApi.execAql(AmApi.java:228)
... 50 more

com.hp.amadapter.push.exception.AMPushAdapterException: Failed executing AQL: java.lang.reflect.UndeclaredThrowableException

Type 4

Caused by: Error (12,011): Index error: A record in table 'Physical drives (amPhysicalDrive)' with the value '45356d3abbcf2cc9951d7f9ff087b329' for field 'Global Id (GlobalId)' already exists in the database.

at com.peregrine.ac.api.AmApi97JNI.AmDbExecAql(Native Method)
at com.peregrine.ac.api.AmApi97.AmDbExecAql(AmApi97.java:81)
at com.peregrine.ac.api.AmApi.execAql(AmApi.java:228)
... 49 more
INSERT INTO amPhysicalDrive ( lPhysDriveId, Description, GlobalId, lCompId, lTotalSizeMb) values (12284353, 'NONE_fixed_disk', '45356d3abbcf2cc9951d7f9ff087b329', '517236', '20480')INSERT

com.hp.amadapter.push.exception.AMPushAdapterException: Failed executing AQL: java.lang.reflect.UndeclaredThrowableException
at com.sun.proxy.$Pr

 

Type 5

Caused by: Error (12,001): This modification alters the behavior of an overflow link. Certain records in the table 'IT equipment' (overflow table of the table 'Portfolio items') will not be coherent with the new structure.
Agent 'COverflowChangeAgent' returned error : '-54'
An integrity was not correctly applied (no additional information available).
Format error:

at com.peregrine.ac.api.AmApi97JNI.AmDbExecAql(Native Method)
at com.peregrine.ac.api.AmApi97.AmDbExecAql(AmApi97.java:81)
at com.peregrine.ac.api.AmApi.execAql(AmApi.java:228)
... 50 more

 

Any help is appreciated in resolving above failure when pushing servers CI from uCMDB into Asset Manager.

Thanks & Regards,

Rohit S

0 Likes
4 Replies
Highlighted
Micro Focus Frequent Contributor
Micro Focus Frequent Contributor

Re: uCMDB - Asset Manager Integration - Failed pushing CIs

 
 
0 Likes
Highlighted
New Member..
New Member..

Re: uCMDB - Asset Manager Integration - Failed pushing CIs

Hi

Was there any resolution to the issues you have? We are also experiencing the exact same error as in example 'Type 4'

Many thanks in advance

0 Likes
Highlighted
Honored Contributor.
Honored Contributor.

Re: uCMDB - Asset Manager Integration - Failed pushing CIs

Please find the workaround to resolve these errors:

Type1: 

Caused by: Error (12,001): line 1: syntax error 'swap'; 'swap' should be Select_field
line 1: syntax error 'swap'; 'swap' should be CLOSEPAR
line 1: syntax error ','; ',' should be Eof
Format error:

at com.peregrine.ac.api.AmApi97JNI.AmDbExecAql(Native Method)
at com.peregrine.ac.api.AmApi97.AmDbExecAql(AmApi97.java:81)
at com.peregrine.ac.api.AmApi.execAql(AmApi.java:228)
... 49 more
INSERT INTO amLogicalDrive ( lLogDriveId, Device, GlobalId, Label, Media, MountPoint, Name, Type, lCompId, lFreeSpaceMb, lTotalSizeMb) values (12286162, 'swap', '439e192e8e7ca1cabe9ebe2a63465623', '/system/volatile', 'FixedDisk', '/syst

[VALUE CUT OFF DUE TO SIZE LIMIT]

Solution: Remove the tmpfs or swap filesystem by applying necessary filter on Filesystem CIT.

Type 2

Caused by: Error (12,001): line 1: syntax error 'tmpfs
'; 'tmpfs
' should be Select_field
line 1: syntax error ''; '' should be Eof
Format error:

at com.peregrine.ac.api.AmApi97JNI.AmDbExecAql(Native Method)
at com.peregrine.ac.api.AmApi97.AmDbExecAql(AmApi97.java:81)
at com.peregrine.ac.api.AmApi.execAql(AmApi.java:228)
... 50 more
UPDATE amLogicalDrive SET Device = 'swap', GlobalId = '40ae0de3667295b8afdf1b104b86e6fe', Label = '/tmp', Media = 'FixedDisk', MountPoint = '/tmp', Name = 'swap', Type = 'tmpfs
swap', lCompId = '2969691', lFreeSp

[VALUE CUT OFF DUE TO SIZE LIMIT]

Solution: Remove the tmpfs or swap filesystem by applying necessary filter on Filesystem CIT.

Type 3

Caused by: Error (12,001): line 1: syntax error 'PKGPARAM: ERROR: UNABLE TO LOCATE PARAMETER INFORMATION FOR "SUNWEXPLU"
'; 'PKGPARAM: ERROR: UNABLE TO LOCATE PARAMETER INFORMATION FOR "SUNWEXPLU"
' should be Select_field
line 1: syntax error ''; '' should be Eof
Format error:

at com.peregrine.ac.api.AmApi97JNI.AmDbExecAql(Native Method)
at com.peregrine.ac.api.AmApi97.AmDbExecAql(AmApi97.java:81)
at com.peregrine.ac.api.AmApi.execAql(AmApi.java:228)
... 50 more

com.hp.amadapter.push.exception.AMPushAdapterException: Failed executing AQL: java.lang.reflect.UndeclaredThrowableException

Solution: Make sure attribute value of CI should not have ';' value .

Type 4

Caused by: Error (12,011): Index error: A record in table 'Physical drives (amPhysicalDrive)' with the value '45356d3abbcf2cc9951d7f9ff087b329' for field 'Global Id (GlobalId)' already exists in the database.

at com.peregrine.ac.api.AmApi97JNI.AmDbExecAql(Native Method)
at com.peregrine.ac.api.AmApi97.AmDbExecAql(AmApi97.java:81)
at com.peregrine.ac.api.AmApi.execAql(AmApi.java:228)
... 49 more
INSERT INTO amPhysicalDrive ( lPhysDriveId, Description, GlobalId, lCompId, lTotalSizeMb) values (12284353, 'NONE_fixed_disk', '45356d3abbcf2cc9951d7f9ff087b329', '517236', '20480')INSERT

com.hp.amadapter.push.exception.AMPushAdapterException: Failed executing AQL: java.lang.reflect.UndeclaredThrowableException
at com.sun.proxy.$Pr

Solution:  To get ride of error: A record in table 'Physical drives (amPhysicalDrive)' with the value <GlobalId> for field 'Global Id (GlobalId)' already exists in the database.

- Remove/Delete the already existing record from amPhysicalDrive table with GlobalId in the error.

Type 5

Caused by: Error (12,001): This modification alters the behavior of an overflow link. Certain records in the table 'IT equipment' (overflow table of the table 'Portfolio items') will not be coherent with the new structure.
Agent 'COverflowChangeAgent' returned error : '-54'
An integrity was not correctly applied (no additional information available).
Format error:

at com.peregrine.ac.api.AmApi97JNI.AmDbExecAql(Native Method)
at com.peregrine.ac.api.AmApi97.AmDbExecAql(AmApi97.java:81)
at com.peregrine.ac.api.AmApi.execAql(AmApi.java:228)
... 50 more

Solution:  To get ride of error: This modification alters the behavior of an overflow link.

- Remove/Delete the PortfolioItem/Computer/Asset recored and push it back from uCMDB.

- The reason for above error is that Model of computer record present does not match with Model  which is being pushed in the latest push job execution for computer.

0 Likes
Highlighted
Honored Contributor.
Honored Contributor.

Re: uCMDB - Asset Manager Integration - Failed pushing CIs

Type 6

Error: Entity didn't push due to validation script

Solution:

Comment out following line in the am-push-config.xml file

 <target-ci-validation attribute-name="dtLastScan" validation-script="mappings.scripts.AMReconcil.isDateAfter(vNewVal, vOldVal)" failed-validation-error-code="45404"/>

 

Type 7

[ERROR] [AdHoc:AD_HOC_TASK_PATTERN_ID-12591-1584285999158] (DataAdapterLoggerImpl.java:93) - uCMDB_AM_Push >>  [AM Adapter] com.hp.amadapter.push.exception.AMPushDataException: Duplicate records found by the reconciliation key

                at com.hp.amadapter.push.PushDirector.getAMResultHolder(PushDirector.java:1636)

                at com.hp.amadapter.push.PushDirector.calculatePrimaryIdUsingReconciliation(PushDirector.java:1360)

 

Solution:

Above error generally comes when uCMDB has 2 computers with same serial number.

Therefore, to get rid of above error for computer which has the duplicate serial number.

- These nodes needs to be pushed first using <Lighthweight TQL> Integration job. In this job, serial number and component Cis are excluded but key attributes like Portfolio.GlobalId, TcpIpHostname, Portfolio.Model  and Portfolio.Model.Brand.Name are pushed from uCMDB.

- Then these nodes to be pushed using its actual job <Heavy weight TQL> . In this job, serial number and component Cis are included.

Therefore it is necessary that these nodes should be created using Global ID, Model and Name but without SerialNumber and later they should be updated with serial number and other inventory details.

 

Thanks & Regards,

Rohit Sobhani

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.