I would like to execute the query given below for getting events bw process.

select id ,Accountid,OwnerID ,subject,location,description,createdDate  from event where EventId IN ( select EventId from eventattendee where AttendeeId ='0233000000021IIAAY' and status ='Accepted')

I am getting

        MALFORMED_QUERY: malformed query: unexpected token: select

Please suggest the correct query and how do i achieve it.

Hi

I created a process in BW 5.2.The activiies are

start>login>getEvents>end

login: Working fine

SOAPRequestReply with username/password

getEvents:

SoapRequestReply with i/p

sessionid = loginResponse.sessionid

endpointUrl=loginResponse.serverUrl

Query=select location from event

When i execute this process, it stops at getEvent activity with color yellow and only start to Login transition remains the green. next transition remains black.

in window>show console window i am getting following error

java.lang.RuntimeException: The secure protocol cannot be null.

 at com.tibco.plugin.share.http.client.BwSimpleConnectionManager.getConnection(BwSimpleConnectionManager.java:16)

thanks & regards

Premdutt Gaur

*****************************************Exception*****************************************************************

job dispatcher with 8 threads, max queued = 1

2005 Feb 26 01:52:43:558 GMT +8 BW.CI Info [BW-Core] BWENGINE-300006 Engine CI terminating

Using work space directory C:\Documents and Settings\Administrator\.tibco\working\CI

Creating trace file C:\Documents and Settings\Administrator\.tibco\logs\CI.log

Using XMLReader org.apache.xerces.parsers.SAXParser

2005 Feb 26 01:53:26:049 GMT +8 BW.CI Info [BW-Core] BWENGINE-300001 Process Engine version 5.2.0, build V21, 2004-12-10

2005 Feb 26 01:53:26:049 GMT +8 BW.CI Info [BW-Core] BWENGINE-300009 BW Plugins: version 5.2.0, build V21, 2004-12-10

2005 Feb 26 01:53:26:049 GMT +8 BW.CI Info [BW-Core] BWENGINE-300010 XML Support: TIBCOXML Version 5.2.0 V23 of Fri, Dec 3, 2004 13:55 PST on golden

2005 Feb 26 01:53:26:049 GMT +8 BW.CI Info [BW-Core] BWENGINE-300011 Java version: Java HotSpot(TM) Client VM 1.4.2_06-b03

2005 Feb 26 01:53:26:049 GMT +8 BW.CI Info [BW-Core] BWENGINE-300012 OS version: x86 Windows XP 5.1

2005 Feb 26 01:53:27:301 GMT +8 BW.CI Info [BW-Core] BWENGINE-300013 Tibrv string encoding: ISO8859-1

2005 Feb 26 01:53:27:762 GMT +8 BW.CI Info [BW-Core] BWENGINE-300002 Engine CI started

2005 Feb 26 01:53:29:314 GMT +8 BW.CI Error [BW-Core] BWENGINE-100001 The secure protocol cannot be null.

java.lang.RuntimeException: The secure protocol cannot be null.

 at com.tibco.plugin.share.http.client.BwSimpleConnectionManager.getConnection(BwSimpleConnectionManager.java:16)

 at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:613)

 at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:497)

 at com.tibco.plugin.share.http.client.JakartaHttpTransportDriver$RequestExecutor.run(JakartaHttpTransportDriver.java:235)

 at com.tibco.pe.util.ThreadPool$ThreadPoolThread.run(ThreadPool.java:99)

2005 Feb 26 01:59:50:852 GMT +8 BW.CI Error [BW-Core] BWENGINE-100001 The secure protocol cannot be null.

java.lang.RuntimeException: The secure protocol cannot be null.

 at com.tibco.plugin.share.http.client.BwSimpleConnectionManager.getConnection(BwSimpleConnectionManager.java:16)

 at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:613)

 at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:497)

 at com.tibco.plugin.share.http.client.JakartaHttpTransportDriver$RequestExecutor.run(JakartaHttpTransportDriver.java:235)

 at com.tibco.pe.util.ThreadPool$ThreadPoolThread.run(ThreadPool.java:99)

job dispatcher with 8 threads, max queued = 1

2005 Feb 26 02:09:25:849 GMT +8 BW.CI Info [BW-Core] BWENGINE-300006 Engine CI terminating

Hi

I created a process in BW 5.2.The activiies are

start>login>getEvents>end

login: Working fine

SOAPRequestReply with username/password

getEvents:

SoapRequestReply with i/p

sessionid = loginResponse.sessionid

endpointUrl=loginResponse.serverUrl

Query=select location from event

When i execute this process, it stops at getEvent activity with color yellow and only start to Login transition remains the green. next transition remains black.

in window>show console window i am getting following error

java.lang.RuntimeException: The secure protocol cannot be null.

 at com.tibco.plugin.share.http.client.BwSimpleConnectionManager.getConnection(BwSimpleConnectionManager.java:16)

thanks & regards

Premdutt Gaur

*****************************************Exception*****************************************************************

job dispatcher with 8 threads, max queued = 1

2005 Feb 26 01:52:43:558 GMT +8 BW.CI Info [BW-Core] BWENGINE-300006 Engine CI terminating

Using work space directory C:\Documents and Settings\Administrator\.tibco\working\CI

Creating trace file C:\Documents and Settings\Administrator\.tibco\logs\CI.log

Using XMLReader org.apache.xerces.parsers.SAXParser

2005 Feb 26 01:53:26:049 GMT +8 BW.CI Info [BW-Core] BWENGINE-300001 Process Engine version 5.2.0, build V21, 2004-12-10

2005 Feb 26 01:53:26:049 GMT +8 BW.CI Info [BW-Core] BWENGINE-300009 BW Plugins: version 5.2.0, build V21, 2004-12-10

2005 Feb 26 01:53:26:049 GMT +8 BW.CI Info [BW-Core] BWENGINE-300010 XML Support: TIBCOXML Version 5.2.0 V23 of Fri, Dec 3, 2004 13:55 PST on golden

2005 Feb 26 01:53:26:049 GMT +8 BW.CI Info [BW-Core] BWENGINE-300011 Java version: Java HotSpot(TM) Client VM 1.4.2_06-b03

2005 Feb 26 01:53:26:049 GMT +8 BW.CI Info [BW-Core] BWENGINE-300012 OS version: x86 Windows XP 5.1

2005 Feb 26 01:53:27:301 GMT +8 BW.CI Info [BW-Core] BWENGINE-300013 Tibrv string encoding: ISO8859-1

2005 Feb 26 01:53:27:762 GMT +8 BW.CI Info [BW-Core] BWENGINE-300002 Engine CI started

2005 Feb 26 01:53:29:314 GMT +8 BW.CI Error [BW-Core] BWENGINE-100001 The secure protocol cannot be null.

java.lang.RuntimeException: The secure protocol cannot be null.

 at com.tibco.plugin.share.http.client.BwSimpleConnectionManager.getConnection(BwSimpleConnectionManager.java:16)

 at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:613)

 at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:497)

 at com.tibco.plugin.share.http.client.JakartaHttpTransportDriver$RequestExecutor.run(JakartaHttpTransportDriver.java:235)

 at com.tibco.pe.util.ThreadPool$ThreadPoolThread.run(ThreadPool.java:99)

2005 Feb 26 01:59:50:852 GMT +8 BW.CI Error [BW-Core] BWENGINE-100001 The secure protocol cannot be null.

java.lang.RuntimeException: The secure protocol cannot be null.

 at com.tibco.plugin.share.http.client.BwSimpleConnectionManager.getConnection(BwSimpleConnectionManager.java:16)

 at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:613)

 at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:497)

 at com.tibco.plugin.share.http.client.JakartaHttpTransportDriver$RequestExecutor.run(JakartaHttpTransportDriver.java:235)

 at com.tibco.pe.util.ThreadPool$ThreadPoolThread.run(ThreadPool.java:99)

job dispatcher with 8 threads, max queued = 1

2005 Feb 26 02:09:25:849 GMT +8 BW.CI Info [BW-Core] BWENGINE-300006 Engine CI terminating