Re: Regarding WQL indications.

OperationalStatus is an array property (note the square brackets), so it 
can have both values.  The ANY keyword along with [*] says this clause 
returns true if the array property includes 17 (or 2).

Paul

On 2/8/2010 12:04 PM, Kirk Augustin wrote:
> I am not an SQL expert, but:
>   AND ANY SourceInstance.CIM_ConcreteJob::OperationalStatus[*]  = 17
>   AND ANY SourceInstance.CIM_ConcreteJob::OperationalStatus[*] = 2
> can never be true.
> A particular field value can't be both 17 and 2 at the same time.
> I think an OR is called for.
>
> ------------------------------------------------------------------------
> *From:* Paul von Behren <[email protected]>
> *To:* [email protected]
> *Cc:* [email protected]; [email protected]; 
> [email protected]
> *Sent:* Mon, February 8, 2010 10:10:27 AM
> *Subject:* Re: Regarding WQL indications.
>
> George,
> I'm pretty sure your example is *not* valid CQL; I believe the ANY 
> keyword is mandatory.
>   SELECT * FROM CIM_InstModification
>   WHERE SourceInstance ISA CIM_ConcreteJob
>   AND ANY SourceInstance.CIM_ConcreteJob::OperationalStatus[*]  = 17
>   AND ANY SourceInstance.CIM_ConcreteJob::OperationalStatus[*] = 2
>
> My understanding is that Pegasus' CQL filter does accept your version 
> - but SMI-S requires the version with ANY.
>
> Paul
>
> On 2/8/2010 10:49 AM, [email protected] wrote:
>>
>> Do you have the same problem with CQL?
>>
>> SELECT * FROM CIM_InstModification
>> WHERE SourceInstance ISA CIM_ConcreteJob
>>
>> AND SourceInstance. CIM_ConcreteJob::OperationalStatus = 17
>>
>> AND SourceInstance.CIM_ConcreteJob::OperationalStatus = 2
>>
>> George
>>
>> *From:* Karl Schopmeyer [mailto:[email protected]]
>> *Sent:* Monday, February 08, 2010 11:03 AM
>> *To:* [email protected]; [email protected]
>> *Subject:* Re: Regarding WQL indications.
>>
>> There is code in the parser for this but it is conditionally compiled 
>> under PEGASSUS_SNIA_EXTENSIONS.
>> Karl
>> Thanks for your message at 06:29 AM 2/8/2010. Your message was:
>>
>> Hello ,
>>
>> I am trying to run CTP for a certain block services profile. The CTP 
>> version is 1.3.0.
>> CTP is subscribes for the WQL indication
>> “SELECT * FROM CIM_InstModification WHERE SourceInstance ISA 
>> CIM_ConcreteJob AND SourceInstance.OperationalStatus = 17 AND 
>> SourceInstance.OperationalStatus = 2”
>>
>> But CTP never receives the indication although the desired task is 
>> completed and the indication is dispatched to Pegasus by the.
>> The Pegasus version used is 2.9.1, it is complied with the 
>> SNIA_EXTENSIONS
>>
>> I have tried to create a filter , listener and subscription for the 
>> same WQL indication out of CTP.
>> I have found that the Pegasus is not able to parse the query itself. 
>> Following is the part of the Pegasus log,
>>
>> 1265107339s-370875us: IndicationService 
>> [1244:18446744073709551614:IndicationService.cpp:3848]: Entering 
>> method IndicationService::_checkRequiredProperty
>> 1265107339s-370875us: IndicationService 
>> [1244:18446744073709551614:IndicationService.cpp:3931]: Exiting 
>> method IndicationService::_checkRequiredProperty
>> 1265107339s-370875us: IndicationService 
>> [1244:18446744073709551614:IndicationService.cpp:4147]: Entering 
>> method IndicationService::_checkPropertyWithDefault
>> 1265107339s-370875us: IndicationService 
>> [1244:18446744073709551614:IndicationService.cpp:4211]: Exiting 
>> method IndicationService::_checkPropertyWithDefault
>> 1265107339s-370875us: IndicationService 
>> [1244:18446744073709551614:IndicationService.cpp:5130]: Entering 
>> method IndicationService::_getQueryExpression
>> 1265107339s-370875us: WQL 
>> [1244:18446744073709551614:WQLParser.cpp:105]: Entering method 
>> WQLParser::parse
>> 1265107339s-370875us: WQL 
>> [1244:18446744073709551614:WQLParser.cpp:55]: Entering method 
>> WQLParser::parse
>> 1265107339s-370875us: WQL 
>> [1244:18446744073709551614:WQLParser.cpp:148]: Entering method WQLInput
>> 1265107339s-370875us: WQL 
>> [1244:18446744073709551614:WQLParser.cpp:174]: Exiting method WQLInput
>> 1265107339s-370875us: WQL 
>> [1244:18446744073709551614:WQLParser.cpp:132]: Entering method WQL_error
>> 1265107339s-370875us: WQL 
>> [1244:18446744073709551614:WQLParser.cpp:142]: Exiting method WQL_error
>> 1265107339s-370875us: WQL 
>> [1244:18446744073709551614:WQLParser.cpp:114]: Entering method 
>> WQLParser::cleanup
>> 1265107339s-370875us: WQL 
>> [1244:18446744073709551614:WQLParser.cpp:123]: Exiting method 
>> WQLParser::cleanup
>> 1265107339s-370875us: WQL 
>> [1244:18446744073709551614:WQLParser.cpp:81]: Exiting method 
>> WQLParser::parse
>> 1265107339s-370875us: L10N 
>> [1244:18446744073709551614:MessageLoader.cpp:417]: Entering method 
>> MessageLoader::getMessage
>> 1265107339s-370875us: L10N 
>> [1244:18446744073709551614:MessageLoader.cpp:418]: Message ID = 
>> Common.InternalException.PARSE_ERROR
>> 1265107339s-370875us: L10N 
>> [1244:18446744073709551614:MessageLoader.cpp:478]: Entering method 
>> MessageLoader::openMessageFile
>> 1265107339s-370875us: L10N 
>> [1244:18446744073709551614:MessageLoader.cpp:507]: Exiting method 
>> MessageLoader::openMessageFile
>> 1265107339s-370875us: L10N 
>> [1244:18446744073709551614:MessageLoader.cpp:439]: Entering method 
>> MessageLoader::getMessage2
>> 1265107339s-370875us: L10N 
>> [1244:18446744073709551614:MessageLoader.cpp:529]: Entering method 
>> MessageLoader::formatDefaultMessage
>> 1265107339s-370875us: L10N 
>> [1244:18446744073709551614:MessageLoader.cpp:540]: Exiting method 
>> MessageLoader::formatDefaultMessage
>> 1265107339s-370875us: L10N 
>> [1244:18446744073709551614:MessageLoader.cpp:472]: Exiting method 
>> MessageLoader::getMessage2
>> 1265107339s-370875us: L10N 
>> [1244:18446744073709551614:MessageLoader.cpp:513]: Entering method 
>> MessageLoader::closeMessageFile
>> 1265107339s-370875us: L10N 
>> [1244:18446744073709551614:MessageLoader.cpp:523]: Exiting method 
>> MessageLoader::closeMessageFile
>> 1265107339s-370875us: L10N 
>> [1244:18446744073709551614:MessageLoader.cpp:433]: Exiting method 
>> MessageLoader::getMessage
>> 1265107339s-370875us: IndicationService 
>> [1244:18446744073709551614:IndicationService.cpp:5150]: Exiting 
>> method IndicationService::_getQueryExpression
>>
>>
>> I have tried to create a filter , listener and subscription for the 
>> another WQL indication ,in which the query was simpler , it did not 
>> contain any “.” , “::”  etc characters ,
>> For this case the WQL query parsed successfully but it gave error,
>>
>> 1265186845s-297625us: DiscardedData 
>> [6068:18446744073709551614:CIMxmlIndicationHandler.cpp:353]: 
>> CIMxmlIndicationHandler::handleIndication failed to deliver 
>> indication due to Exception: Missing CIMExport HTTP header
>> 1265186845s-297625us: IndicationHandler 
>> [6068:18446744073709551614:CIMxmlIndicationHandler.cpp:355]: Exiting 
>> method CIMxmlIndicationHandler::handleIndication()
>> 1265186845s-297625us: IndicationHandler 
>> [6068:18446744073709551614:IndicationHandlerService.cpp:363]: Exiting 
>> method IndicationHandlerService::__loadHandler()
>> 1265186845s-297625us: L10N 
>> [6068:18446744073709551614:MessageLoader.cpp:417]: Entering method 
>> MessageLoader::getMessage
>> 1
>>
>> Can somebody please let me know that is there a pacth or fix that 
>> needs to be applied in order to get the WQL indications working with 
>> the open peagsus.
>>
>>
>> _____________________________________________________________________
>>
>> This e-mail message may contain proprietary, confidential or legally 
>> privileged information for the sole use of the person or entity to 
>> whom this message was originally addressed. Any review, 
>> e-transmission dissemination or other use of or taking of any action 
>> in reliance upon this information by persons or entities other than 
>> the intended recipient is prohibited. If you have received this 
>> e-mail in error kindly delete this e-mail from your records. If it 
>> appears that this mail has been forwarded to you without proper 
>> authority, please notify us immediately at [email protected] and 
>> delete this mail.
>> _____________________________________________________________________
>>
>> Karl Schopmeyer                   Inova Development Inc.
>> 305 Spring Creek Village, Suite 475 -  Dallas TX, 75248 USA
>> EMAIL: [email protected]       FAX: 1-972-239-0326
>> Phone 1-972-814-5581
>> Skype: kschopmeyer         Skype Phone: (214) 556-5971
>>