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.




Scheduler error

web-app

I create 2 gmail mailboxes for according projects in Gemini:

        Name="CustomerManager1"
        POPServer="pop.gmail.com"
        POPServerPort="995"
        AuthenticationMethod="AUTO"
        UseSSL="true"
        POPMailbox="paynovasupport.cm@gmail.com"
        POPUsername="paynovasupport.cm@gmail.com"
        POPPassword="*******"
        DeleteMessages="false"
        SubjectLikeRegExp=".*"
        SubjectNOTLikeRegExp=""
        ProjectID="3"
        UserID="1"
        ComponentID="16"
        IssueType="9"
        IssuePriority="1"
        DebugFile = "c:\\Gemini_CM_POP3_log.txt"
        DebugMode = "true"

Scheduler service start successfully. Here log:

[12:49:01.46] [INFO] Assembly version: 3.1.2.90. [12:49:01.46] [INFO] Will resolve host "pop.gmail.com". [12:49:01.55] [INFO] Host "pop.gmail.com" resolved to IP address(es) 72.14.221.109, 72.14.221.111. [12:49:01.56] [INFO] Will connect to host "pop.gmail.com" on port 995. [12:49:01.60] [INFO] Socket connected to IP address 72.14.221.109 on port 995. [12:49:01.60] [INFO] Will create TLS/SSL credentials. [12:49:01.60] [INFO] TLS/SSL credentials created. [12:49:01.60] [INFO] Will start TLS/SSL negotiation sequence. [12:49:01.69] [INFO] TLS/SSL negotiation completed. [12:49:01.69] [RECV] +OK Gpop ready for requests from 195.250.62.254 d6pf2673682fga.0\r\n [12:49:01.69] [INFO] Connected to mail service at host "pop.gmail.com" on port 995 and ready. [12:49:01.69] [INFO] Get the list of POP3 capabilities via CAPA command. [12:49:01.69] [SEND] CAPA\r\n [12:49:01.72] [RECV] +OK Capability list follows\r\nUSER\r\nRESP-CODES\r\nEXPIRE 0\r\nLOGIN-DELAY 300\r\nX-GOOGLE-VERHOEVEN\r\nUIDL\r\n.\r\n [12:49:01.72] [INFO] Will login as "paynovasupport.cm@gmail.com". [12:49:01.72] [INFO] Will try regular USER/PASS authentication. [12:49:01.72] [SEND] USER paynovasupport.cm@gmail.com\r\n [12:49:02.53] [RECV] +OK send PASS\r\n [12:49:02.53] [SEND] PASS **\r\n [12:49:02.78] [RECV] +OK Welcome.\r\n [12:49:02.78] [INFO] Logged in as "paynovasupport.cm@gmail.com". [12:49:02.78] [INFO] Download inbox statistics. [12:49:02.78] [SEND] STAT\r\n [12:49:02.99] [RECV] +OK 0 0\r\n [12:49:02.99] [INFO] Inbox was empty. Zero messages downloaded. [12:49:03.00] [SEND] QUIT\r\n [12:49:04.00] [RECV] +OK Farewell.\r\n [12:49:04.00] [INFO] Will disconnect from host "pop.gmail.com". [12:49:04.00] [INFO] Disconnected from host "pop.gmail.com".

But when I start Scheduler service, it write in windows events log follow record:

System.Web.Services - System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> NHibernate.ADOException: could not insert: [CounterSoft.Gemini.Commons.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) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] ---> System.Data.SqlClient.SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint "geminiissuesissuerisklevelidfk". The conflict occurred in database "GeminiSample", table "dbo.gemini_issuerisklevels", column 'risklevelid'. The statement has been terminated.

How I can specify risk level for issues, that created from mail?

IUnknown
· 1
IUnknown
Replies (2)
helpful
0
not helpful

This is a known bug with the scheduler. We have fixed it and will be releasing it this week.


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

Please download and install Gemini Scheduler 2.0.1 Build 1972 (released today).


Harvey Kandola
· 212
Harvey Kandola