BMC Atrium Discovery Community Forum

This forum is now closed. Please check sticky posts and announcements for further information.

Links to new community:

forgot password?
   
 
Query does no longer work on ADDM9
Posted: 06 February 2014 08:17 AM   [ Ignore ]  
RankRankRankRank
Guru
Total Posts:  97
Joined:  2010-06-10

We are migrating an an set of export mappings from ADDM 8.3 to 9.02 and they all work nicely except one that uses the following query:

SEARCH Host

WITH #InferredElement:Inference:Primary:HostInfo AS info , hash(#ContainedHost:HostContainment:HostContainer:HostContainer.key) AS hckey

, toNumber(single(split(#InferredElement:Inference:Primary:HostInfo.lpar_desired_memory))) AS num_desired_memory

WHERE partition

SHOW hash(key) AS ‘host_key’

, name AS ‘host_name’ , vendor AS ‘host_vendor’ , model AS ‘host_model’ , serial AS ‘host_serial’ , info.lpar_minimum_virtual_cpus AS ‘hostinfo_lpar_minimum_virtual_cpus’ , info.lpar_desired_virtual_cpus AS ‘hostinfo_lpar_desired_virtual_cpus’ , info.lpar_maximum_virtual_cpus AS ‘hostinfo_lpar_maximum_virtual_cpus’ , info.lpar_minimum_memory AS ‘hostinfo_lpar_minimum_memory’ , @num_desired_memory AS ‘hostinfo_lpar_desired_memory’

If the toNumber function is removed from line 4 the query work:

SEARCH Host WITH #InferredElement:Inference:Primary:HostInfo AS info , hash(#ContainedHost:HostContainment:HostContainer:HostContainer.key) AS hckey , single(split(#InferredElement:Inference:Primary:HostInfo.lpar_desired_memory)) AS num_desired_memory WHERE partition SHOW hash(key) AS ‘host_key’ , name AS ‘host_name’ , vendor AS ‘host_vendor’ , model AS ‘host_model’ , serial AS ‘host_serial’ , info.lpar_minimum_virtual_cpus AS ‘hostinfo_lpar_minimum_virtual_cpus’ , info.lpar_desired_virtual_cpus AS ‘hostinfo_lpar_desired_virtual_cpus’ , info.lpar_maximum_virtual_cpus AS ‘hostinfo_lpar_maximum_virtual_cpus’ , info.lpar_minimum_memory AS ‘hostinfo_lpar_minimum_memory’ , @num_desired_memory AS ‘hostinfo_lpar_desired_memory’

However I am finding it difficult to understand why this would cause a problem since:

- HostInfo.lpar_desired_memory has not changed between versions and is still held as an integer and display as “XXXX MB” – All the functions used have remained unchanged between versions.

Any explanations would be most appreciated.

Profile