Gemini Community Support Site

This Gemini community support site can be used to find solutions to product issues. You can log in using Open Id, Google Profile and even Facebook. Feel free to ask a question or browse FAQs and documentation. Product tour videos are also available along with how-to videos demonstrating key Gemini capabilities.




Create Issue Partial

api

How I creates new Issue based upon provided IssueEN object?

I try sent minimum issue data(ProjectID, IssueSummary, IssueLongDesc, ReportedBy, IssueTypeId) is don't work.

Thank, June

Punchai
· 1
Punchai
Replies (5)
helpful
0
not helpful

You need to make sure that you have defaults set up for your project (project administration -> default values).
What error do you get? Check Gemini's system log.


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

IssueEN issue = new IssueEN(); issue.ProjectID = 47; issue.IssueSummary = item.Subject; issue.IssueLongDesc = item.Notes; issue.ReportedBy = techId; issue.IssueType = 19; issue = _proxy.CreateIssue(issue);

error message::

Exception has been thrown by the target of an invocation. could not insert: [CounterSoft.Gemini.Commons.Entity.IssueBareEN][SQL: INSERT INTO geminiissues (projectid, issuetypeid, issuepriorityid, issueseverityid, issuestatusid, issueresolutionid, reportedby, fixedinversionid, summary, longdesc, revised, startdate, duedate, resolveddate, closeddate, issuerisklevelid, userdata1, userdata2, userdata3, percentcomplete, estimatedays, estimatehours, estimateminutes, visibility, visibilitymembertype, parentissueid, originatortype, originatorreply, originatordata, originatorprocessed, isparent, hierarchykey, repeated) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?); select SCOPEIDENTITY()] The INSERT statement conflicted with the FOREIGN KEY constraint "geminiissuesissuepriorityidfk". The conflict occurred in database "GeminiTest", table "dbo.geminiissuepriorities", column 'priorityid'. The statement has been terminated.


Punchai
· 1
Punchai
helpful
0
not helpful

It seems like the priority use have passed it is invalid (not in the list of priorities). did you set default values?


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

Yes, I try it.

IssueEN issue = new IssueEN(); issue.ProjectID = 47; issue.IssueSummary = item.Subject; issue.IssueLongDesc = item.Notes; issue.ReportedBy = techId; issue.IssueType = 19; issue.IssuePriority = 4;

but is don't work.


Punchai
· 1
Punchai
helpful
0
not helpful
ANSWER

Please check that the priority id of 4 exists in the priorities table.


Mark Wing
· 9108
Mark Wing