Hi,

I have a problem that sometimes no description is added to the request even though the customer has written one. I have tried to figure out when this occurs, because it does not occur always, but failed. From the same customer I have got two requests where one contained the description and one didn't.

I found the following in the logfiles for the request that was created without description.

Any ideas why this occurs??

Regards/Helena

From logfile:
|: Processing mails from 1 to 1|
[10:11:20:749]|[09-11-2007]|[com.adventnet.servicedesk.helpdesk.mail.task.MailFetchingTask]|[INFO]|[23]|: ----------------------------------------------------------|
[10:11:20:749]|[09-11-2007]|[com.adventnet.servicedesk.helpdesk.mail.task.MailFetchingTask]|[INFO]|[23]|: S T A R T |
[10:11:20:749]|[09-11-2007]|[com.adventnet.servicedesk.helpdesk.mail.task.MailFetchingTask]|[INFO]|[23]|: ----------------------------------------------------------|
[10:11:20:749]|[09-11-2007]|[com.adventnet.servicedesk.helpdesk.mail.task.MailFetchingTask]|[INFO]|[23]|: Start processing message : 1|
[10:11:20:749]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.MailProcessor]|[INFO]|[23]|: FFF Inside the message constructor of MailProcessor|
[10:11:20:968]|[09-11-2007]|[com.adventnet.servicedesk.helpdesk.mail.task.MailFetchingTask]|[INFO]|[23]|: Processing message with subject : SV: exportfil and messageid : <003501c7f44b$1a0813d0$b30a0a0a@Foresta.local>|
[10:11:20:968]|[09-11-2007]|[com.adventnet.servicedesk.helpdesk.mail.task.MailFetchingTask]|[INFO]|[23]|: Before initializing the variables...|
[10:11:20:968]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.MailProcessor]|[INFO]|[23]|: FFF Inside initVariables|
[10:11:20:968]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.MailProcessor]|[INFO]|[23]|: FFF emailModeID : 1 FFF defPriorityID : 2 FFF defCategoryID : null FFF defStatusID : 1 FFF defLevelID : null|
[10:11:20:968]|[09-11-2007]|[com.adventnet.servicedesk.helpdesk.mail.task.MailFetchingTask]|[INFO]|[23]|: Before processing the email...|
[10:11:20:968]|[09-11-2007]|[com.adventnet.servicedesk.helpdesk.mail.task.MailFetchingTask]|[INFO]|[23]|: @@@@@@@@@@@@@@@ Txn suspended @@@@@@@@@@|
[10:11:20:968]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.ProcessMailMessage]|[INFO]|[23]|: >>> Inside processMailHeaders of ProcessMailMessage <<<|
[10:11:20:968]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.ProcessMailMessage]|[INFO]|[23]|: ReInitializing the variables :: reinitializeVariables .............|
[10:11:20:968]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.ProcessMailMessage]|[INFO]|[23]|: mailSize : 1614|
[10:11:20:968]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.ProcessMailMessage]|[INFO]|[23]|: uniqueMailID : <003501c7f44b$1a0813d0$b30a0a0a@nnnnnnn.local>|
[10:11:20:968]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.ProcessMailMessage]|[INFO]|[23]|: fromHeader : nnnnn <nnnn.nnnnnn@nnnnnn.se>|
[10:11:20:968]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.ProcessMailMessage]|[INFO]|[23]|: sendersName : nnnnn
[10:11:20:968]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.ProcessMailMessage]|[INFO]|[23]|: fromAddress : nnnn.nnnnnn@nnnnnn.se
[10:11:20:968]|[09-11-2007]|[SYSOUT]|[INFO]|[23]|: Input :: --support@nnnnnnn.se--|
[10:11:20:968]|[09-11-2007]|[SYSOUT]|[INFO]|[23]|: Output :--support@nnnnnn.se--|
[10:11:20:968]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.ProcessMailMessage]|[INFO]|[23]|: toAddress : nnnnn@nnnnn.se|
[10:11:20:968]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.ProcessMailMessage]|[INFO]|[23]|: ccAddress : Not Provided|
[10:11:20:968]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.ProcessMailMessage]|[INFO]|[23]|: bccAddress : Not Provided|
[10:11:21:187]|[09-11-2007]|[SYSOUT]|[INFO]|[23]|: Date : Tue, 11 Sep 2007 10:09:38 +0200|
[10:11:21:187]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.ProcessMailMessage]|[INFO]|[23]|: mailDate : Tue, 11 Sep 2007 10:09:38 +0200|
[10:11:21:187]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.ProcessMailMessage]|[INFO]|[23]|: sentDate : Tue Sep 11 10:09:38 CEST 2007|
[10:11:21:187]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.ProcessMailMessage]|[INFO]|[23]|: replyTo : nnnn.nnnnnn@nnnnnn.se|
[10:11:21:187]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.ProcessMailMessage]|[INFO]|[23]|: subjectOfMail : SV: exportfil|
[10:11:21:406]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.ProcessMailMessage]|[INFO]|[23]|: XMailer : Microsoft Outlook CWS, Build 9.0.2416 (9.0.2910.0)|
[10:11:21:624]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.ProcessMailMessage]|[INFO]|[23]|: XComments : null|
[10:11:21:843]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.ProcessMailMessage]|[INFO]|[23]|: XComments2 : null|
[10:11:22:062]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.ProcessMailMessage]|[INFO]|[23]|: inRT : <002f01c7f449$7f7da880$7e78f980$@inbox@timeplan.se>|
[10:11:22:062]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.ProcessMailMessage]|[INFO]|[23]|: finalRef : <002f01c7f449$7f7da880$7e78f980$@inbox@nnnnnnnn.se>|
[10:11:22:062]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.ProcessMailMessage]|[INFO]|[23]|: inReplyTo : <002f01c7f449$7f7da880$7e78f980$@inbox@nnnnnnnn.se>|
[10:11:22:062]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.ProcessMailMessage]|[INFO]|[23]|: Inside setReferenceHeader....|
[10:11:22:281]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.ProcessMailMessage]|[INFO]|[23]|: referencesHeader : null|
[10:11:22:499]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.ProcessMailMessage]|[INFO]|[23]|: XPriority : 3 (Normal)|
[10:11:22:499]|[09-11-2007]|[SYSOUT]|[INFO]|[23]|: Input :: --nnn.nnnn@kund.se--|
[10:11:22:499]|[09-11-2007]|[SYSOUT]|[INFO]|[23]|: Output :--nnnnn.nnnn@kund.se--|
[10:11:22:499]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.ProcessMailMessage]|[INFO]|[23]|: replyAddress : nnnn.nnnnnn@nnnnnn.se|
[10:11:22:718]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.ProcessMailMessage]|[INFO]|[23]|: receivedHeader : null|
[10:11:22:718]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.ProcessMailMessage]|[INFO]|[23]|: SentDateInLong : 1189498178000|
[10:11:22:718]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.ProcessMailMessage]|[INFO]|[23]|: ReceivedDate : Tue Sep 11 10:11:22 CEST 2007|
[10:11:22:718]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.ProcessMailMessage]|[INFO]|[23]|: ReceivedDateInLong : 1189498282703|
[10:11:22:718]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.ProcessMailMessage]|[INFO]|[23]|: sqlDate : 2007-09-11|
[10:11:22:718]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.ProcessMailMessage]|[INFO]|[23]|: sqlTime : 10:09:38|
[10:11:22:718]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.ProcessMailMessage]|[INFO]|[23]|: >>> Inside processMail of ProcessMailMessage <<<|
[10:11:22:718]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.ProcessMailMessage]|[INFO]|[23]|: Inside void processMailContent of ProcessMailMessage|
[10:11:22:718]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.ProcessMailMessage]|[SEVERE]|[23]|: p : com.sun.mail.imap.IMAPMessage@e2bc10|
[10:11:22:937]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.ProcessMailMessage]|[INFO]|[23]|: Inside text/*|
[10:11:22:937]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.ProcessMailMessage]|[INFO]|[23]|: Inside fileName == null|
[10:11:22:937]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.ProcessMailMessage]|[INFO]|[23]|: Category : text/plain|
[10:11:22:937]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.ProcessMailMessage]|[INFO]|[23]|: partMimeType : text/plain|
[10:11:22:937]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.ProcessMailMessage]|[INFO]|[23]|: Before StringTokenizer tok2|
[10:11:22:937]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.ProcessMailMessage]|[INFO]|[23]|: p.getContentType() : text/plain; charset=iso-8859-1|
[10:11:22:937]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.ProcessMailMessage]|[INFO]|[23]|: blah : text/plain|
[10:11:22:937]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.ProcessMailMessage]|[INFO]|[23]|: Before tok2 while|
[10:11:22:937]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.ProcessMailMessage]|[INFO]|[23]|: Inside tok2 while|
[10:11:22:937]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.ProcessMailMessage]|[INFO]|[23]|: charset iso-8859-1|
[10:11:22:937]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.ProcessMailMessage]|[INFO]|[23]|: Inside BR try|
[10:11:22:937]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.ProcessMailMessage]|[INFO]|[23]|: Before readLine while : token : |
[10:11:23:156]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.ProcessMailMessage]|[WARNING]|[23]|: Problem in process mail content|java.io.IOException: No content
at com.sun.mail.imap.IMAPInputStream.fill(IMAPInputStream.java:83)
at com.sun.mail.imap.IMAPInputStream.read(IMAPInputStream.java:130)
at sun.nio.cs.StreamDecoder$CharsetSD.readBytes(Unknown Source)
at sun.nio.cs.StreamDecoder$CharsetSD.implRead(Unknown Source)
at sun.nio.cs.StreamDecoder.read(Unknown Source)
at java.io.InputStreamReader.read(Unknown Source)
at java.io.BufferedReader.fill(Unknown Source)
at java.io.BufferedReader.readLine(Unknown Source)
at java.io.BufferedReader.readLine(Unknown Source)
at com.adventnet.servicedesk.mailutils.ProcessMailMessage.processMailContent(ProcessMailMessage.java:1622)
at com.adventnet.servicedesk.mailutils.ProcessMailMessage.processMail(ProcessMailMessage.java:2263)
at com.adventnet.servicedesk.mailutils.MailProcessor.processEMail(MailProcessor.java:107)
at com.adventnet.servicedesk.helpdesk.mail.task.MailFetchingTask.emailThread(MailFetchingTask.java:264)
at com.adventnet.servicedesk.helpdesk.mail.task.MailFetchingTask.<init>(MailFetchingTask.java:57)
at sun.reflect.GeneratedConstructorAccessor53.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at java.lang.Class.newInstance0(Unknown Source)
at java.lang.Class.newInstance(Unknown Source)
at com.adventnet.workengine.task.internal.TaskManagerImpl.executeTask(TaskManagerImpl.java:705)
at com.adventnet.workengine.executor.internal.WorkFlowExecutor.executeStartingTask(WorkFlowExecutor.java:160)
at com.adventnet.workengine.executor.internal.WorkFlowExecutor.executeWorkFlowTemplate(WorkFlowExecutor.java:115)
at com.adventnet.workengine.executor.internal.WorkFlowExecutor.executeWorkFlow(WorkFlowExecutor.java:105)
at com.adventnet.workengine.workflow.ejb.internal.WorkFlowExecutorBean.executeWorkFlow(WorkFlowExecutorBean.java:105)
at sun.reflect.GeneratedMethodAccessor95.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:683)
at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:186)
at org.jboss.ejb.plugins.AbstractInterceptor.invoke(AbstractInterceptor.java:94)
at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:72)
at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:84)
at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:315)
at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:148)
at com.adventnet.authorization.AuthorizationInterceptor.invoke(AuthorizationInterceptor.java:88)
at com.adventnet.authentication.interceptor.SecurityInterceptor.invoke(SecurityInterceptor.java:108)
at com.adventnet.audit.interceptor.AuditInterceptor.invoke(AuditInterceptor.java:128)
at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
at com.adventnet.logging.tracing.TracingInterceptor.invoke(TracingInterceptor.java:136)
at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
at org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionContainer.java:331)
at org.jboss.ejb.Container.invoke(Container.java:709)
at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFactory.java:419)
at org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSessionProxy.java:83)
at $Proxy98.executeWorkFlow(Unknown Source)
at com.adventnet.workengine.executor.internal.RemoteWorkFlowExecutionHandler.execute(RemoteWorkFlowExecutionHandler.java:77)
at com.adventnet.workengine.internal.WorkEngineImpl$WorkFlowExecutorThread.run(WorkEngineImpl.java:923)
at com.adventnet.workengine.service.ThreadPoolService$WorkerThread.run(ThreadPoolService.java:256)
at java.lang.Thread.run(Unknown Source)

[10:11:23:374]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.ProcessMailMessage]|[INFO]|[23]|: flagStatus : Seen --- |
[10:11:23:374]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.ProcessMailMessage]|[INFO]|[23]|: charset : iso-8859-1|
[10:11:23:374]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.MailProcessor]|[INFO]|[23]|: FFF FFF fileHash : {}|
[10:11:23:374]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.MailProcessor]|[INFO]|[23]|: FFF FFF fileNamesVec : []|
[10:11:23:374]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.MailProcessor]|[INFO]|[23]|: Though reply id : <002f01c7f449$7f7da880$7e78f980$@inbox@nnnnnn.se> is present, no request is there to match the replyid, hence setting the replyid to null|
[10:11:23:374]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.MailProcessor]|[INFO]|[23]|: Reference Id : null|
[10:11:23:374]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.MailProcessor]|[INFO]|[23]|: FFF FFF isThreadedReq : false FFF FFF replyID : null|
[10:11:23:374]|[09-11-2007]|[SYSOUT]|[INFO]|[23]|: F_ADD : The criteria is : ((GlobalConfig.CATEGORY = 'Outgoing_ReplyAddress') AND (GlobalConfig.PARAMETER = 'PRODUCT_BASED'))|
[10:11:23:374]|[09-11-2007]|[SYSOUT]|[INFO]|[23]|: F_ADD : paramValue is :: false|
[10:11:23:374]|[09-11-2007]|[SYSOUT]|[INFO]|[23]|: F_ADD : This is NOT product_based|
[10:11:23:484]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.ProcessMailMessage]|[INFO]|[23]|: charset : iso-8859-1|
[10:11:23:484]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.MailProcessor]|[INFO]|[23]|: FFF sendersName : NNNNN NNNNN FFF fromAddress : nnnn.nnnnnn@nnnnnn.se FFF toAddress : support@nnnnnn.se FFF ccAddress : Not Provided FFF bccAddress : Not Provided|
[10:11:23:484]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.MailProcessor]|[INFO]|[23]|: Inside To address parsing... : support@nnnnnnn.se|
[10:11:23:484]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.MailProcessor]|[INFO]|[23]|: the Contact Query is : select AaaContactInfo.CONTACTINFO_ID FROM AaaUserContactInfo LEFT JOIN AaaContactInfo ON AaaUserContactInfo.CONTACTINFO_ID = AaaContactInfo.CONTACTINFO_ID LEFT JOIN SDUser ON AaaUserContactInfo.USER_ID = SDUser.USERID WHERE (EMAILID = 'nnnn.nnnnnn@nnnnnn.se' OR SECONDEMAILID = 'nnnn.nnnnnn@nnnnnn.se')|
[10:11:23:484]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.MailProcessor]|[INFO]|[23]|: FFF Getting the contactId|
[10:11:23:484]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.MailProcessor]|[INFO]|[23]|: FFF Before first try for contactid|
[10:11:23:484]|[09-11-2007]|[SYSOUT]|[INFO]|[23]|: before iterating rs...|
[10:11:23:484]|[09-11-2007]|[SYSOUT]|[INFO]|[23]|: the value is 103|
[10:11:23:484]|[09-11-2007]|[SYSOUT]|[INFO]|[23]|: returning the single value|
[10:11:23:484]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.MailProcessor]|[INFO]|[23]|: FFF loginId : null FFF contact_id : 103|
[10:11:23:484]|[09-11-2007]|[com.adventnet.servicedesk.utils.ServiceDeskUtil]|[INFO]|[23]|: mailDO for Mail ticket creation details: <WritableDataObject>
<Tables>
[GlobalConfig] </Tables>
SelectQuery Object:
Select columnNames=[GlobalConfig.CATEGORY, GlobalConfig.PARAMETER, GlobalConfig.PARAMVALUE]
Criteria=((GlobalConfig.CATEGORY = 'MailTicketCreation') AND (GlobalConfig.PARAMETER = 'UnknownRequester'))
Number of Objects=0
Starting row=1
Order by columnNames=[]
Table List=[GlobalConfig AS GlobalConfig]
Joins=
SetLock= false
<JoinsInDO>
</JoinsInDO>
<Operations>
</Operations>
<Rows>
<GlobalConfig CATEGORY="MailTicketCreation" PARAMETER="UnknownRequester" PARAMVALUE="EnableLogin" />
</Rows>
</WritableDataObject>
|
[10:11:23:484]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.MailProcessor]|[INFO]|[23]|: Mail detail configuration ONDBEnableLogin|
[10:11:23:484]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.MailProcessor]|[INFO]|[23]|: FFF Getting the UserID|
[10:11:23:484]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.MailProcessor]|[INFO]|[23]|: FFF userID : 84|
[10:11:23:484]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.MailProcessor]|[INFO]|[23]|: FFF Before putting the userID : 84|
[10:11:23:484]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.MailProcessor]|[INFO]|[23]|: FFF crTimeLongVV : 1189498283390|
[10:11:23:484]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.MailProcessor]|[INFO]|[23]|: FFF WorkOrderStates table...|
[10:11:23:703]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.ProcessMailMessage]|[INFO]|[23]|: charset : iso-8859-1|
[10:11:23:703]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.MailProcessor]|[INFO]|[23]|: Checking if this is a forum mail|
[10:11:23:703]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.MailProcessor]|[INFO]|[23]|: userID : 84|
[10:11:23:703]|[09-11-2007]|[SYSOUT]|[INFO]|[23]|: Get supportPlan Query : SelectQuery Object:
Select columnNames=[Customer.CUSTOMER_ID, Customer.CUSTOMERTYPE_ID]
Criteria=(Customer_Requester.REQUESTER_ID = '84')
Number of Objects=0
Starting row=1
Order by columnNames=[]
Table List=[Customer AS Customer, Customer_Requester AS Customer_Requester]
Joins= Join := Customer AS Customer LEFT JOIN Customer_Requester AS Customer_Requester ON Customer.CUSTOMER_ID=Customer_Requester.CUSTOMER_ID
SetLock= false|
[10:11:23:703]|[09-11-2007]|[SYSOUT]|[INFO]|[23]|: Get supportPlan dobj : <WritableDataObject>
<Tables>
[Customer] </Tables>
SelectQuery Object:
Select columnNames=[Customer.CUSTOMER_ID, Customer.CUSTOMERTYPE_ID]
Criteria=(Customer_Requester.REQUESTER_ID = '84')
Number of Objects=0
Starting row=1
Order by columnNames=[]
Table List=[Customer AS Customer, Customer_Requester AS Customer_Requester]
Joins= Join := Customer AS Customer LEFT JOIN Customer_Requester AS Customer_Requester ON Customer.CUSTOMER_ID=Customer_Requester.CUSTOMER_ID
SetLock= false
<JoinsInDO>
Join := Customer AS Customer LEFT JOIN Customer_Requester AS Customer_Requester ON Customer.CUSTOMER_ID=Customer_Requester.CUSTOMER_ID
</JoinsInDO>
<Operations>
</Operations>
<Rows>
<Customer CUSTOMER_ID="20" C_ID="null" CUSTOMER_SITE="null" CUSTOMERTYPE_ID="null" INDUSTRY_ID="null" ANNUALREVENUE="null" OWNERSHIP_ID="null" SICCODE="null" TICKERSYMBOL="null" TIMEZONE_ID="null" />
</Rows>
</WritableDataObject>
|
[10:11:23:703]|[09-11-2007]|[SYSOUT]|[INFO]|[23]|: dobj not empty|
[10:11:23:703]|[09-11-2007]|[SYSOUT]|[INFO]|[23]|: dobj contains CUSTOMER table|
[10:11:23:703]|[09-11-2007]|[SYSOUT]|[INFO]|[23]|: returning supId : null|
[10:11:23:703]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.MailProcessor]|[INFO]|[23]|: supPlanIdForRequester : null|
[10:11:23:703]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.MailProcessor]|[INFO]|[23]|: Trying to get the account for contact : {CustomerName=kunden, CustomerID=20}|
[10:11:23:703]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.MailProcessor]|[INFO]|[23]|: accountOfRequester : 20|
[10:11:23:703]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.MailProcessor]|[INFO]|[23]|: FFF FFF isThreadedReq : false|
[10:11:23:703]|[09-11-2007]|[com.adventnet.servicedesk.utils.WorkOrderUtil]|[INFO]|[23]|: Inside applyBusinessRule |
[10:11:23:906]|[09-11-2007]|[com.adventnet.servicedesk.utils.WorkOrderUtil]|[INFO]|[23]|: ruleID 1|
[10:11:23:906]|[09-11-2007]|[com.adventnet.servicedesk.utils.WorkOrderUtil]|[INFO]|[23]|: queryID 15|
[10:11:23:906]|[09-11-2007]|[com.adventnet.servicedesk.utils.WorkOrderUtil]|[INFO]|[23]|: queryCriteria ((WorkOrderStates.CATEGORYID = '2') OR (WorkOrder.TITLE LIKE '*warranty*'))|
[10:11:23:906]|[09-11-2007]|[com.adventnet.servicedesk.utils.WorkOrderUtil]|[INFO]|[23]|: Inside getSLAID |
[10:11:23:906]|[09-11-2007]|[com.adventnet.servicedesk.utils.WorkOrderUtil]|[INFO]|[23]|: slaID null|
[10:11:23:906]|[09-11-2007]|[com.adventnet.servicedesk.utils.WorkOrderUtil]|[INFO]|[23]|: dueByTime -1|
[10:11:23:906]|[09-11-2007]|[com.adventnet.sqlone.search.dbcrawler.ejb.internal.DatabaseCrawler]|[INFO]|[23]|: Connection obtained for crawling the database <AppIndexingInfo CRID="125" APPLICATIONID="1" APPLICATIONNAME="ServiceDesk" APPDSNAME="default" MAXWORDSIZE="200" INDEXINGDELIMITERS=",:@-. (){}" ENABLEPARTIALSEARCH="true" ENABLEDYNAMICINDEXING="true" ENABLEINCREMENTALINDEXING="false" POPULATE_FK_REL="false" STATUS="0" />|
[10:11:23:906]|[09-11-2007]|[com.adventnet.servicedesk.utils.ServiceDeskUtil]|[INFO]|[23]|: queryID 12|
[10:11:24:015]|[09-11-2007]|[com.adventnet.servicedesk.utils.ServiceDeskUtil]|[INFO]|[23]|: queryID 12|
[10:11:24:015]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.MailProcessor]|[INFO]|[23]|: the admin user id for logging history is : 1|
[10:11:24:015]|[09-11-2007]|[com.adventnet.sqlone.search.dbcrawler.ejb.internal.DatabaseCrawler]|[INFO]|[23]|: Connection obtained for crawling the database <AppIndexingInfo CRID="125" APPLICATIONID="1" APPLICATIONNAME="ServiceDesk" APPDSNAME="default" MAXWORDSIZE="200" INDEXINGDELIMITERS=",:@-. (){}" ENABLEPARTIALSEARCH="true" ENABLEDYNAMICINDEXING="true" ENABLEINCREMENTALINDEXING="false" POPULATE_FK_REL="false" STATUS="0" />|
[10:11:24:015]|[09-11-2007]|[com.adventnet.servicedesk.mailutils.MailProcessor]|[INFO]|[23]|: FFF FFF No attachments found... |