Scheduler error
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 |
|
Tuesday, May 27, 2008, 11:57:18 AM |