Re: Crystal report limitation on fetching records?
What is your setting in Remedy User for Tools/Options/Behaviors/Limit Number of Items Returned? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of roseta Sent: Saturday, August 23, 2008 6:43 AM To: arslist@ARSLIST.ORG Subject: Re: Crystal report limitation on fetching records? Hello, This does not apply on Crystal report. It just applies on Remedy. the same issue is there. Regards, Rozita Radfar roseta wrote: > > Hello, > > I use crystal report to get reports from incident. Our HPD:Helpdesk view > now has 1.7 million records. but it seems that it does not filter through > all records for reporting. for example I want to get count of product > category on incidents in one month time. if I put the time for two days it > shows the count of category A 1000 but if I put that two days + next 20 > days it will show the count of same category 1 %-| > > I think it is not considering all records , does it have any limitation on > counting and considering records. > > > Regards, > Rozita Radfar > -- View this message in context: http://www.nabble.com/Crystal-report-limitation-on-fetching-records--tp1 9119182p19120829.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" This message is subject to and does not create or vary any contractual relationship between TuringSMI, SMI Technologies, SMI Telco, its subsidiaries or affiliates and you. Internet communications are not secure and therefore the TuringSMI Group does not accept any legal responsibility for the contents of this message. Any views or opinions expressed are those of the author. This message is intended for the addressee(s) only and its contents and any attached files are strictly confidential. If you have received it in error, please contact the sender on the number above. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Anticipated timeframe for an AR Server Upgrade?
5.1.2 to 6 then to 6.3 then to 7. Since you left out a version it may not work. If it did work previously time frame is difficult to know since all forms and workflow will be touched. -Original Message- From: McManus Michael A SSgt HQ 754 ELSG/DOMH <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Sat, 23 Aug 2008 12:56 am Subject: Anticipated timeframe for an AR Server Upgrade? ** Listers, We’re upgrading our AR Server tonight from 5.1.2 to 7.0. A direct upgrade didn’t appear to be working so I went with 5.1.2 to 6.3. I kicked it off about 6 hours ago and it still appears to be steadily chugging along at the “Upgrading the AR System Database” screen. I did this previously on a development environment, but kicked it off in the afternoon and came in the next morning so I’m not sure on the actual time this normally takes. I’m sure hardware and database size play a role, but can anyone give me a rough estimate for how long this normally takes? I’d like to sleep before my next birthday J Thanks much, Michael A. McManus, SSgt, USAF Remedy Developer HQ 754 ELSG/DOMH __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Crystal report limitation on fetching records?
Hello, This does not apply on Crystal report. It just applies on Remedy. the same issue is there. Regards, Rozita Radfar roseta wrote: > > Hello, > > I use crystal report to get reports from incident. Our HPD:Helpdesk view > now has 1.7 million records. but it seems that it does not filter through > all records for reporting. for example I want to get count of product > category on incidents in one month time. if I put the time for two days it > shows the count of category A 1000 but if I put that two days + next 20 > days it will show the count of same category 1 %-| > > I think it is not considering all records , does it have any limitation on > counting and considering records. > > > Regards, > Rozita Radfar > -- View this message in context: http://www.nabble.com/Crystal-report-limitation-on-fetching-records--tp19119182p19120829.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Transferring ATTACHMENTS using Remedy Link for SQL
** This document shows all the supported data types for AIE. http://developer.bmc.com:8080/jiveProd/entry.jspa?externalID=2986 Attachment is not on the list. Kelly Deaver [EMAIL PROTECTED] (Yes, I work for BMC. This post reflects the opinions of the poster and not the offical opinion of BMC) Original Message Subject: Re: Transferring ATTACHMENTS using Remedy Link for SQLFrom: "Ramy S. Ayoub" <[EMAIL PROTECTED]>Date: Sat, August 23, 2008 3:44 amTo: arslist@ARSLIST.ORG** George, The attachment type are excel , or what .. in case of attachment you have to find away to map the field , i believe its fail because there is no mapping On Fri, Aug 22, 2008 at 10:38 PM, Payne, George <[EMAIL PROTECTED]> wrote: ** ARS 7.0.01 P08 – AIX 5.3 Oracle 10g on a separate AIX 5.3 Remedy Link for SQL 7.0 P05 We are successfully moving data between our Remedy database and an MS SQL 2005 database in both directions. We are being asked to move ATTACHMENTS from Remedy to the SQL database. The word I'm getting is the SQL 2005 doesn't have a data type for an attachment and whenever we try to move an attachment over the Remedy Link to SQL, the service on the PC dies (or at least gets hung) and has to be re-started. Has anybody done this kind of transfer? Any hints or suggestions? Should I abandon EIE/AIE? Gp George Payne Corporate Applications Developer Electric Reliability Council of Texas (512) 248-3940 [EMAIL PROTECTED]__Platinum Sponsor: http://www.rmsportal.com/ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___
Re: Transferring ATTACHMENTS using Remedy Link for SQL
George, The attachment type are excel , or what .. in case of attachment you have to find away to map the field , i believe its fail because there is no mapping On Fri, Aug 22, 2008 at 10:38 PM, Payne, George <[EMAIL PROTECTED]> wrote: > ** > > ARS 7.0.01 P08 – AIX 5.3 > > Oracle 10g on a separate AIX 5.3 > > Remedy Link for SQL 7.0 P05 > > > > We are successfully moving data between our Remedy database and an MS SQL > 2005 database in both directions. > > > > We are being asked to move ATTACHMENTS from Remedy to the SQL database. > > > > The word I'm getting is the SQL 2005 doesn't have a data type for an > attachment and whenever we try to move an attachment over the Remedy Link to > SQL, the service on the PC dies (or at least gets hung) and has to be > re-started. > > > > Has anybody done this kind of transfer? Any hints or suggestions? Should > I abandon EIE/AIE? > > > > Gp > > > > George Payne > > Corporate Applications Developer > > Electric Reliability Council of Texas > > (512) 248-3940 > > [EMAIL PROTECTED] > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Importing file using Run Process using escalation
Rick, did you try something like this? $PROCESS$ @x: cmd.exe /C "F:\x\x\x\ImportCompFile.bat" Mario "Trevino, Rick" <[EMAIL PROTECTED] SYS.COM> To Sent by: "Action arslist@ARSLIST.ORG Request System cc discussion list(ARSList)"Subject <[EMAIL PROTECTED] Re: Importing file using Run ORG> Process using escalation 23.08.2008 00:10 Please respond to [EMAIL PROTECTED] RG ** I did a search and did not find any folders or files with arfork in them, this is a windows environment, I believe I have seen arfork in A Unix environment From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: Friday, August 22, 2008 4:51 PM To: arslist@ARSLIST.ORG Subject: Re: Importing file using Run Process using escalation What about looking in the arfork.log. That is where external commands are logged to. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Trevino, Rick Sent: Friday, August 22, 2008 4:36 PM To: arslist@ARSLIST.ORG Subject: Re: Importing file using Run Process using escalation That was one of the first things I did to debug, and it had no errors, this is the only message I got Checking SOT:ImportCompData (enabled) : going to fire in 604470 seconds on +SOT:TotalStorage Productivity Center Staging Form From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Leonard Neely - FOJ Sent: Friday, August 22, 2008 4:28 PM To: arslist@ARSLIST.ORG Subject: Re: Importing file using Run Process using escalation Have you looked at the escalation log? What does it say when this error occurs? Leonard From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Trevino, Rick Sent: Friday, August 22, 2008 2:11 PM To: arslist@ARSLIST.ORG Subject: Re: Importing file using Run Process using escalation Leonard, I tried that and got the same thing, My problem is that on one line it says no error, but the previous one says there is a failure Fri Aug 22 16:05:59 2008 390603 : Failure while trying to run the filter/escalation process (ARERR 24) Fri Aug 22 16:05:59 2008 No error : $PROCESS$ F:\ImportCompFile.bat any other suggestions would be appreciated Thanks ! From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Leonard Neely - FOJ Sent: Friday, August 22, 2008 3:53 PM To: arslist@ARSLIST.ORG Subject: Re: Importing file using Run Process using escalation Run from an escalation, wouldn’t the syntax just be: $PROCESS$ F:\x\x\x\ImportCompFile.bat Leonard Neely From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Trevino, Rick Sent: Friday, August 22, 2008 1:29 PM To: arslist@ARSLIST.ORG Subject: Importing file using Run Process using escalation Hi everyone, Has anyone had any issues trying to import a bat file using a run process in a escalation ? We currently run a windows environment and use remedy v7.0.1 This is the run process I am using $PROCESS$ @x: F:\x\x\x\ImportCompFile.bat This is the error I get on the log: Fri Aug 22 15:17:00 2008 390603 : Failure while trying to run the filter/escalation process (ARERR 24) Fri Aug 22 15:17:00 2008 No error : $PROCESS$ @x: F:\x\x\x\ImportCompFile.bat I can run the batch file from the server and it imports the file into Remedy, but when I try to run the batch through a run process it seems To do nothing Thanks ! __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___
Re: Crystal report limitation on fetching records?
Hi Rozita. Log on a User-Tool with the user that access your reports. In the Menu: Tools-Options-Behaviours Remove the limitations of 1000 records on query /Rune Sorlid 2008/8/23 roseta <[EMAIL PROTECTED]> > Hello, > > I use crystal report to get reports from incident. Our HPD:Helpdesk view > now > has 1.7 million records. but it seems that it does not filter through all > records for reporting. for example I want to get count of product category > on incidents in one month time. if I put the time for two days it shows the > count of category A 1000 but if I put that two days + next 20 days it will > show the count of same category 1 %-| > > I think it is not considering all records , does it have any limitation on > counting and considering records. > > > Regards, > Rozita Radfar > -- > View this message in context: > http://www.nabble.com/Crystal-report-limitation-on-fetching-records--tp19119182p19119182.html > Sent from the ARS (Action Request System) mailing list archive at > Nabble.com. > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
