Re: Regarding WQL indications.

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
>
>