Welcome Serena Central users! CLICK HERE
The migration of the Serena Central community is currently underway. Be sure to read THIS MESSAGE to get your new login set up to access your account.
valerio.quarta@ Absent Member.
Absent Member.
590 views

Sql query produced for Asset Channel wrong results

Hi guys,

I 'm testing my smart connector asset import and the manager take me this error:

[2013-04-10 12:06:35,933][WARN ][default.com.arcsight.common.dynachannel.QueryDynaChannelImpl][getSequenceForBucketHelper] Sql query produced for Asset Channel wrong results: ( select /* GetBucketIdQuery for Channel name=Asset Channel, channelID=Qmddm8z0BABCA+XIn9qkvIQ=H, sessionID=3nk5ptp2b341e1cd0-5d85-41a9-bea8-3c8d318b1ee7 */  Asset.id "ID" from  arc_device Asset , arc_tc where 1=1  and (Asset.id in (select target from ARC_TC where source = '0cWtl8z0BABCw0R66c9XM5w==') and Asset.hostname = 'Pippo84138') and Asset.id  = arc_tc.target AND arc_tc.source IN ('01000100010001004')  order by UPPER(Asset.hostname) ASC ,Asset.id ASC  ), offset = 0, actualLength = 1, returned = 0 for bucket {_count=1, _key=[Pippo84138]}

What i can do?

Thanks at all,

Valerio.

Labels (2)
Tags (2)
0 Likes
Reply
4 Replies
samdc_be Absent Member.
Absent Member.

Re: Sql query produced for Asset Channel wrong results

Valerio,

We have a very similar warning filling our server logs. Only difference is that in our case it's related to an active channel.

Please find below the response I received from HP Support regarding this issue.

'...[doGetSequenceForBucket] Sql query produced for <channel name> wrong results:(....)'

This issue is a known bug with ID ESM-28137.
The status is still "Open" and "Unresolved", and the Severity is "Normal", that is not affecting Manager in terms of performance and quality.

Meanwhile, your Channel may stop updating and the timestamp on the Start and End of the Channel will be not updated.
Although it is a very repetitive exception in server.log file, but it does not have any other impact on Manager performance.

I don't find any reference to this bug id in the self solve sequence so I requested this.

Best regards,

Sam De Coster

0 Likes
Reply
Honored Contributor.. dhartman Honored Contributor..
Honored Contributor..

Re: Sql query produced for Asset Channel wrong results

By chance did they ever fix this for you guys?

0 Likes
Reply
Trusted Contributor.. thebeno1 Trusted Contributor..
Trusted Contributor..

Re: Sql query produced for Asset Channel wrong results

HI All

Until Arcsight-ESM 6.9.1c automatic asset creation was horrible. This version was first which is usable. Version 6.11 is even better. But I have still simmilar problem.

Arcsight is using for showing assets this select from mysql db:

select Asset.hostname "Host Name",count(Asset.id) "Count(ID)"
from arc_device Asset
LEFT OUTER JOIN arc_relationship groupid_rel
ON Asset.id = groupid_rel.targetid
AND groupid_rel.relationship_type = 4
LEFT OUTER JOIN arc_resource groupid
ON groupid_rel.sourceid = groupid.id, arc_tc where 1=1
and groupid.id = BINARY '06q+v6VwBABCAWpP7hc5o5w=='
and Asset.id = arc_tc.target
AND arc_tc.source IN ('01000100010001004')
group by Asset.hostname

which is wrong and does not show all asked assets because of this condition:

AND arc_tc.source IN ('01000100010001004')

 I dont know for what is there but without it the select return correct output.

select Asset.hostname "Host Name",count(Asset.id) "Count(ID)"
from arc_device Asset
LEFT OUTER JOIN arc_relationship groupid_rel
ON Asset.id = groupid_rel.targetid
AND groupid_rel.relationship_type = 4
LEFT OUTER JOIN arc_resource groupid
ON groupid_rel.sourceid = groupid.id, arc_tc where 1=1
and groupid.id = BINARY '06q+v6VwBABCAWpP7hc5o5w=='
and Asset.id = arc_tc.target
group by Asset.hostname

This select is OK.

 

QUESTION:

what the table arc_tc is for.

Why the data looks like this

mysql> select distinct(source)  from arc_tc;                                  
+---------------------------+
| source                    |
+---------------------------+
| 0+0Em8lQBABDrPLTN1ov-qA== |
| 0+0Em8lQBABDrPRoRyB9How== |
| 0+8GD+U8BABCAqejollm8fw== |
| 0+c2uB08BABCADvM-0lDYSw== |
| 0+twGgFABABC5G3-5RPN8Bw== |
| 0-1h89CcBABCAOcM4q0u5nw== |
| 0-AabQwABABC7IW9lz88Fjg== |
| 0-Bx2TlgBABDGOdZDH4P91g== |
| 0-cmEWVwBABCAiLpSXP7zFg== |
| 0-wNaHAwBABCFUGvLDCwdyQ== |
| 0-zs05U4BABCWoyFaTdLvAw== |
| 00-ZsbFgBABCA93lcJ0RPcw== |
| 002EqqPsAABCAF4quTWGPKA== |
| 00Od0TlgBABDGAGQz3q0AzA== |
| 01-rYSv4AABCBluE79fxMNQ== |
| 01000100010001004         |
| 01000100010001029         |
| 01000100010001031         |
| 01000100010001040         |
| 0164jU1gBABDArAgTYipS+w== |
| 01GZXBFoBABCoNIN1CPSiug== |
| 01P5kWVwBABCATlp7fMlZ8Q== |

especialy when all data looks like hash why is there 4 lines beginning with 100010001000010?

maybe GroupID=01000100010001004 = /All Assets/

buy this condition is wrong because noone assets belongs directly to /All Assets/

or all assets should belong to /All Assets/ and they not belongs there

 

 From my perspective it looks like developers expect that any assets belongs to /All Assets/

and in some cases some assets do not belong there. It is not "possible" but it happend.

0 Likes
Reply
Highlighted
Trusted Contributor.. thebeno1 Trusted Contributor..
Trusted Contributor..

Re: Sql query produced for Asset Channel wrong results

Hi

In my case it could be that assets was wrong created during migration from 6.9.1 to 6.11

and some of then does not belong to /All Assets/

Peter

 

0 Likes
Reply
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.