Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 315560

Summary: [connector] Serena Business Mashup (SBM)
Product: z_Archived Reporter: Brian Rosenberger <bru>
Component: MylynAssignee: Project Inbox <mylyn-triaged>
Status: CLOSED MOVED QA Contact:
Severity: enhancement    
Priority: P4 CC: bru, jonnydee, pchan
Version: 3.3Keywords: helpwanted
Target Milestone: ---   
Hardware: All   
OS: All   
Whiteboard:
Attachments:
Description Flags
Error on query creation none

Description Brian Rosenberger CLA 2010-06-03 07:15:21 EDT
Build Identifier: 


Serena Business Mashups (SBM) is a commercial, workflow based ticket system.
An experimental Mylyn connector for SBM2009R2 can be found at this update site:
http://brutex.net/updates/

Help to improve this to a full featured, stable connector is very welcome.

Brian



Reproducible: Always
Comment 1 Steffen Pingel CLA 2010-07-09 00:58:54 EDT
Great to hear. Brian, please consider adding the connector the Mylyn extensions wiki page and Eclipse Marketplace.
Comment 2 Paul Chan CLA 2011-03-16 23:40:30 EDT
Created attachment 191371 [details]
Error on query creation
Comment 3 Paul Chan CLA 2011-03-16 23:40:51 EDT
Hi Brian,

I just tried the plug-in witt my SBM server.
However, I cannot create a new query because a "Query Synchronization Failed" was prompted.

It seems that some entries cannot be parsed properly, I attached the snapshot Query Synchronization Failed.PNG.

Is there a project in bugzilla to submit the bug, or I should use "mylyn" as the project in bugzilla?

Thanks.
Comment 4 Brian Rosenberger CLA 2011-03-17 05:01:16 EDT
(In reply to comment #3)
> Hi Brian,
> 
> I just tried the plug-in witt my SBM server.
> However, I cannot create a new query because a "Query Synchronization Failed"
> was prompted.
> 
> It seems that some entries cannot be parsed properly, I attached the snapshot
> Query Synchronization Failed.PNG.
> 
> Is there a project in bugzilla to submit the bug, or I should use "mylyn" as
> the project in bugzilla?
> 
> Thanks.

(In reply to comment #3)
> Hi Brian,
> 
> I just tried the plug-in witt my SBM server.
> However, I cannot create a new query because a "Query Synchronization Failed"
> was prompted.
> 
> It seems that some entries cannot be parsed properly, I attached the snapshot
> Query Synchronization Failed.PNG.
> 
> Is there a project in bugzilla to submit the bug, or I should use "mylyn" as
> the project in bugzilla?
> 
> Thanks.

Hi,

from the screenshot it is not obvious to me which query you used. It seems to be just empty (you can see the TS_ID>0 (()) part). I think the most easy solution here is to help you out directly using a remote session. I will contact you on your email address regarding this.

Currently there is no separate bugzilla project, so please use the mylyn project, but makre sure that you have "SBM Connector" in the title as well.

Cheers
Brian
Comment 5 Brian Rosenberger CLA 2011-03-22 02:55:44 EDT
(In reply to comment #4)

Resolution:
You have to use a query, the query window cannot be emtpy.
Examples: 

TS_ID>0 /*find all items*/

TS_STATE in (select TS_ID from TS_STATES where TS_NAME in ('NEW', 'ASSIGNED', 'IMPLEMENTATION') /*find items in certain states/*

TS_OWNER = (select TS_ID from TS_USERS where TS_LOGINID='<yourusername>') /*find items you own/*

TS_PROJECTID in (select TS_ID from TS_PROJECTS where TS_NAME like 'Brutex%') /*find all items in any project starting with Brutex*/

Cheers
Brian
Comment 6 Eclipse Webmaster CLA 2022-11-15 11:45:08 EST
Mylyn has been restructured, and our issue tracking has moved to GitHub [1].

We are closing ~14K Bugzilla issues to give the new team a fresh start. If you feel that this issue is still relevant, please create a new one on GitHub.

[1] https://github.com/orgs/eclipse-mylyn