Hello everyone,
We have an issue when scheduling a billing archive job through the CMDB. The scheduled job is not triggering to run at the scheduled time which causes us billing issues. What we are doing is rebooting the server and then rescheduling the job and then it runs fine. Has anyone had these issues before ? We currently run Version 7.0.1 Window platform DB = Sql server Thanks Rick. ________________________________ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe DeSouza Sent: Thursday, January 08, 2009 9:17 AM To: arslist@ARSLIST.ORG Subject: Re: Active Link works on dev; not on prod So the Remedy function COLCOUNT() has no bearing if the table field is chunked? I distinctly remember having some issue with something similar in the past but not sure if it was with COLCOUNT() or something else.. Or maybe it was a limitation of that version?? Joe ________________________________ From: "Opela, Gary L CTR USAF AFMC 72 CS/SCBAH" <gary.opela....@tinker.af.mil> To: arslist@ARSLIST.ORG Sent: Thursday, January 8, 2009 9:19:52 AM Subject: Re: Active Link works on dev; not on prod Carey, I understand what you are saying, but either way you use colcount, it's still counting rows, not columns. That's what my point was, colcount is not something I would have ever looked at by its name and though, "Oh, I'll bet this function will count the number of rows." Gary -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Carey Matthew Black Sent: Thursday, January 08, 2009 8:15 AM To: arslist@ARSLIST.ORG Subject: Re: Active Link works on dev; not on prod Gary, Actually ...there is a difference between COLCOUNT and a "ROWCOUNT" function. REF: BasicGuide-630.2006.05.09.pdf Pg 647 " COLCOUNT (column) or (table) " <snip> " For a table or results list field, returns the total number of rows. For a column field, returns the total number of non-NULL rows in a given column. " So if you call COLCOUNT and pass it a reference to a Table field then it does a "row count". However, if you pass it a column of a table then it counts the non-null rows in that column. The reason that can be very helpful is if you are using the updatability of columns. (For example.) The user may want/need to know that there are N rows that need attention before they can continue with a given task. So... as implemented, Remedy's COLCOUNT function is a super set of what ROWCOUNT could do if it worked the way I think you would want it to work. But I am not clear as to what the number would be if table chunking was involved. I would guess that it would give you the current chunk size and not the total number of records in all of the data chunks. So if your feeling chunky in your table fields... do some testing if you want the Total total instead of the chunk total. But I think $ LASTCOUNT $ should always get the Total total just after the table was refreshed in an active link. HTH. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap.... Pick two. __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"