Date Calculation issue
Hi All, Our remedy version is 7.1, Server - Windows 2003 R2 Server, Datebase - MS SQL 2005. *In Dev System:* I used the below date function in one of the workflow, which worked fine and the result were as expected. I got the date is '30/09/2014 11:59:59 PM'. DATEADD( day, ( - DATENUM( day, DATEADD( month, 1, $DATE$))), DATEADD( month, 1, $DATE$)) + (86400 - 1) *In Production:* When i used the same Date function in Production system, it give the Date '02/01/1970 11:00:30 AM' The issue looks very strange and i am unable to figure it out, please help me on this. *Thanks and Regards,* *Karthick S* ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Unable to search the published Knowledge Articles in RKM 8.1.01
Hi Team, We have created the KA in Knowledge mgmt. app. and even after changing the status to Published. Not able to search them in the list. Also other related articles are searched at ease but the newly created were not retrieved in the list. Regards, Abhishek Anand ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Unable to search the published Knowledge Articles in RKM 8.1.01
Did you assign any visibility groups? Make sure your users have a company restriction if they do not have Unrestricted Access Sent from my iPhone On Sep 1, 2014, at 8:10 AM, Abhishek Anand abhi.masc...@gmail.com wrote: Hi Team, We have created the KA in Knowledge mgmt. app. and even after changing the status to Published. Not able to search them in the list. Also other related articles are searched at ease but the newly created were not retrieved in the list. Regards, Abhishek Anand ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Unable to search the published Knowledge Articles in RKM 8.1.01
Also, .. Can the admin see it in the KM console view? Sent from my iPhone On Sep 1, 2014, at 8:10 AM, Abhishek Anand abhi.masc...@gmail.com wrote: Hi Team, We have created the KA in Knowledge mgmt. app. and even after changing the status to Published. Not able to search them in the list. Also other related articles are searched at ease but the newly created were not retrieved in the list. Regards, Abhishek Anand ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Unable to search the published Knowledge Articles in RKM 8.1.01
yes On Mon, Sep 1, 2014 at 6:02 PM, Tauf Chowdhury taufc...@gmail.com wrote: Also, .. Can the admin see it in the KM console view? Sent from my iPhone On Sep 1, 2014, at 8:10 AM, Abhishek Anand abhi.masc...@gmail.com wrote: Hi Team, We have created the KA in Knowledge mgmt. app. and even after changing the status to Published. Not able to search them in the list. Also other related articles are searched at ease but the newly created were not retrieved in the list. Regards, Abhishek Anand ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years -- Regards, Abhishek Anand http://www.vyomlabs.com/ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Unable to search the published Knowledge Articles in RKM 8.1.01
Then it's probably the visibility groups within the article or your FTS indexer is stopped or errored out before indexing the article for searching Sent from my iPhone On Sep 1, 2014, at 9:14 AM, Abhi$hek abhi.masc...@gmail.com wrote: ** yes On Mon, Sep 1, 2014 at 6:02 PM, Tauf Chowdhury taufc...@gmail.com wrote: Also, .. Can the admin see it in the KM console view? Sent from my iPhone On Sep 1, 2014, at 8:10 AM, Abhishek Anand abhi.masc...@gmail.com wrote: Hi Team, We have created the KA in Knowledge mgmt. app. and even after changing the status to Published. Not able to search them in the list. Also other related articles are searched at ease but the newly created were not retrieved in the list. Regards, Abhishek Anand ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years -- Regards, Abhishek Anand _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
ARInside 3.1.1 released
Hello List, today I’m announcing the release of ARInside 3.1.1. The 3.1.x version focuses on redesign of the documentation layout and more dynamic functionality. Currently only the schema page is redesigned but everything else will follow and will receive further improvements. And it has updated support for ARS version 8.1. You could find the download and the changes of this version at the ARInside website (http://arinside.org). -John- ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Unable to search the published Knowledge Articles in RKM 8.1.01
Visibility group is set fine and also FTS indexer is working fine. But still the problem exists. On Mon, Sep 1, 2014 at 6:53 PM, Tauf Chowdhury taufc...@gmail.com wrote: ** Then it's probably the visibility groups within the article or your FTS indexer is stopped or errored out before indexing the article for searching Sent from my iPhone On Sep 1, 2014, at 9:14 AM, Abhi$hek abhi.masc...@gmail.com wrote: ** yes On Mon, Sep 1, 2014 at 6:02 PM, Tauf Chowdhury taufc...@gmail.com wrote: Also, .. Can the admin see it in the KM console view? Sent from my iPhone On Sep 1, 2014, at 8:10 AM, Abhishek Anand abhi.masc...@gmail.com wrote: Hi Team, We have created the KA in Knowledge mgmt. app. and even after changing the status to Published. Not able to search them in the list. Also other related articles are searched at ease but the newly created were not retrieved in the list. Regards, Abhishek Anand ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years -- Regards, Abhishek Anand http://www.vyomlabs.com/ _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ -- Regards, Abhishek Anand http://www.vyomlabs.com/ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Web Service - complex structure
Web service with complex object I need to create a webservice to insert new records in HPD:IncidentInterfase_Create form and also details about alarms in a custom form GC_ASTRO_Alarma. I’ve reviewed the information about this and found a way to get this. However, third party is expecting a WDSL structure that I can’t reach. Basically, the details about the alarm must be in a complex object and this object included in another complex object and this must be the final element type that will be invoked by the Third Party, but Remedy only generated the a complex element for the detail form. Here some details about my request. Thank you in advance Principal Form in HPD:IncidentInterfase_Create Detail Form: GC_ASTRO_Alarma Expected structure xsd:element type=s0:detailedAlarmListType name=detailedAlarmList minOccurs=0 maxOccurs=1 /xsd:element …. xsd:complexType name=detailedAlarmType xsd:sequence xsd:element type=xsd:string name=alarmID minOccurs=0 maxOccurs=1/ xsd:element type=quot;xsd:stringquot; name=quot;alertNamequot; minOccurs=quot;0quot; maxOccurs=quot;1quot;/ lt;xsd:element type=quot;xsd:stringquot; name=quot;amoquot; minOccurs=quot;0quot; maxOccurs=quot;1quot;/ xsd:element type=xsd:string name=alarmedEquipment minOccurs=0 maxOccurs=1/ xsd:element type=xsd:string name=severity minOccurs=0 maxOccurs=1/ xsd:element type=xsd:string name=specificProblem minOccurs=0 maxOccurs=1/ xsd:element type=xsd:string name=probableCause minOccurs=0 maxOccurs=1/ xsd:element type=xsd:dateTime name=asociationDate minOccurs=0 maxOccurs=1/ xsd:element type=xsd:dateTime name=alertDate minOccurs=0 maxOccurs=1/ xsd:element type=xsd:dateTime name=clearDate minOccurs=0 maxOccurs=1//xsd:sequence /xsd:complexType … xsd:complexType name=detailedAlarmListType xsd:sequence xsd:element type=s0:detailedAlarmType name=detailedAlarm minOccurs=0 maxOccurs=unbounded /xsd:element /xsd:sequence /xsd:complexType Structure Remedy generates. xsd:element name=detaiLedALarmType maxOccurs=unbounded xsd:complexType xsd:sequence xsd:element type=xsd:string name=alarmID minOccurs=0/ xsd:element type=xsd:string name=aLertName minOccurs=0/ xsd:element type=xsd:string name=amo minOccurs=0/ xsd:element type=xsd:string name=severitry minOccurs=0/ xsd:element type=xsd:string name=specificProblem minOccurs=0/ xsd:element type=xsd:string name=probableCause minOccurs=0/ xsd:element type=xsd:dateTime name=asociationDate minOccurs=0/ xsd:element type=xsd:dateTime name=aLertDate minOccurs=0/ xsd:element type=xsd:dateTime name=cLearDate minOccurs=0/ /xsd:sequence /xsd:complexType /xsd:element http://ars-action-request-system.1.n7.nabble.com/file/n118707/Developer.jpg -- View this message in context: http://ars-action-request-system.1.n7.nabble.com/Web-Service-complex-structure-tp118707.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Date Calculation issue
Hi, Could you please describe what you want to accomplish? If you want to get the last second of the current month, I would do somethinglike: DATEADD(month, 1, DATEADD(day, 1-DAY($DATE$), $DATE$)) - 1 And in two steps: Get the first second of the current month: firstsecond = DATEADD(day, 1-DAY($DATE$), $DATE$) Get the last second based on the first second of the month lastsecond = DATEADD(month, 1, $firstsecond$) - 1 Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Hi All, Our remedy version is 7.1, Server - Windows 2003 R2 Server, Datebase - MS SQL 2005. *In Dev System:* I used the below date function in one of the workflow, which worked fine and the result were as expected. I got the date is '30/09/2014 11:59:59 PM'. DATEADD( day, ( - DATENUM( day, DATEADD( month, 1, $DATE$))), DATEADD( month, 1, $DATE$)) + (86400 - 1) *In Production:* When i used the same Date function in Production system, it give the Date '02/01/1970 11:00:30 AM' The issue looks very strange and i am unable to figure it out, please help me on this. *Thanks and Regards,* *Karthick S* ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: ARInside 3.1.1 released
Hi, I have not tried it yet, but thank you for keeping up the good work and keeping ARInside up to date after Stefan Nerlich moved on to other projects! Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Hello List, today I’m announcing the release of ARInside 3.1.1. The 3.1.x version focuses on redesign of the documentation layout and more dynamic functionality. Currently only the schema page is redesigned but everything else will follow and will receive further improvements. And it has updated support for ARS version 8.1. You could find the download and the changes of this version at the ARInside website (http://arinside.org). -John- ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Date Calculation issue
Hi Misi, Your calculation works fine in our Dev environment, but when i use the same date calculation in production system it gives this date '01/01/1970 11:00:31 AM'. On Tue, Sep 2, 2014 at 2:50 AM, Misi Mladoniczky m...@rrr.se wrote: Hi, Could you please describe what you want to accomplish? If you want to get the last second of the current month, I would do somethinglike: DATEADD(month, 1, DATEADD(day, 1-DAY($DATE$), $DATE$)) - 1 And in two steps: Get the first second of the current month: firstsecond = DATEADD(day, 1-DAY($DATE$), $DATE$) Get the last second based on the first second of the month lastsecond = DATEADD(month, 1, $firstsecond$) - 1 Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Hi All, Our remedy version is 7.1, Server - Windows 2003 R2 Server, Datebase - MS SQL 2005. *In Dev System:* I used the below date function in one of the workflow, which worked fine and the result were as expected. I got the date is '30/09/2014 11:59:59 PM'. DATEADD( day, ( - DATENUM( day, DATEADD( month, 1, $DATE$))), DATEADD( month, 1, $DATE$)) + (86400 - 1) *In Production:* When i used the same Date function in Production system, it give the Date '02/01/1970 11:00:30 AM' The issue looks very strange and i am unable to figure it out, please help me on this. *Thanks and Regards,* *Karthick S* ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years -- *Thanks and Regards,* *Karthick S* ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Unable to search the published Knowledge Articles in RKM 8.1.01
check the FTS logging to find out whether the index is created for this record or not. Also is it a server group? Is it the case Article is searchable from 1 server not from other(s)? On Mon, Sep 1, 2014 at 5:40 PM, Abhishek Anand abhi.masc...@gmail.com wrote: Hi Team, We have created the KA in Knowledge mgmt. app. and even after changing the status to Published. Not able to search them in the list. Also other related articles are searched at ease but the newly created were not retrieved in the list. Regards, Abhishek Anand ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Date Calculation issue
Hi, Is your target field a char-field? Try splitting things up to find where it goes wrong: tmpint1 = $DATE$ tmpint2 = DATEADD(day, 1-DAY($tmpint1$), $tmpint1$) tmpdate = DATEADD(month, 1, $tmpint2$) - 1 Best Regards - Misi, RRR AB, http://rrr.se Hi Misi, Your calculation works fine in our Dev environment, but when i use the same date calculation in production system it gives this date '01/01/1970 11:00:31 AM'. On Tue, Sep 2, 2014 at 2:50 AM, Misi Mladoniczky m...@rrr.se wrote: Hi, Could you please describe what you want to accomplish? If you want to get the last second of the current month, I would do somethinglike: DATEADD(month, 1, DATEADD(day, 1-DAY($DATE$), $DATE$)) - 1 And in two steps: Get the first second of the current month: firstsecond = DATEADD(day, 1-DAY($DATE$), $DATE$) Get the last second based on the first second of the month lastsecond = DATEADD(month, 1, $firstsecond$) - 1 Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Hi All, Our remedy version is 7.1, Server - Windows 2003 R2 Server, Datebase - MS SQL 2005. *In Dev System:* I used the below date function in one of the workflow, which worked fine and the result were as expected. I got the date is '30/09/2014 11:59:59 PM'. DATEADD( day, ( - DATENUM( day, DATEADD( month, 1, $DATE$))), DATEADD( month, 1, $DATE$)) + (86400 - 1) *In Production:* When i used the same Date function in Production system, it give the Date '02/01/1970 11:00:30 AM' The issue looks very strange and i am unable to figure it out, please help me on this. *Thanks and Regards,* *Karthick S* ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years -- *Thanks and Regards,* *Karthick S* ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Unable to search the published Knowledge Articles in RKM 8.1.01
FTS is working fine as required for the old articles but not working for the newly created articles. And also one thing noticed that the articles which are created yesterday are now searchable. But still the Articles which are created today are not searchable as of now. On Tue, Sep 2, 2014 at 7:10 AM, Mayuresh Wagh mayurbw...@gmail.com wrote: ** check the FTS logging to find out whether the index is created for this record or not. Also is it a server group? Is it the case Article is searchable from 1 server not from other(s)? On Mon, Sep 1, 2014 at 5:40 PM, Abhishek Anand abhi.masc...@gmail.com wrote: Hi Team, We have created the KA in Knowledge mgmt. app. and even after changing the status to Published. Not able to search them in the list. Also other related articles are searched at ease but the newly created were not retrieved in the list. Regards, Abhishek Anand ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years _ARSlist: Where the Answers Are and have been for 20 years_ -- Regards, Abhishek Anand http://www.vyomlabs.com/ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years