Re: Performance Issue with Active Links- Reg.,
Hello Vinod, Last time I had this problem, I found that the OOTB Indexes on the Helpdesk form had become corrupt. You can check that in the database. Regards, Murtuza. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rabi Tripathi Sent: Thursday, April 12, 2007 7:56 AM To: [EMAIL PROTECTED] Subject: Re: Performance Issue with Active Links- Reg., Vinod: It makes sense that Helpdesk form's objects open relatively slower than smaller forms'. The question is whether 100 seconds is reasobable for your setup or not. No way to judge that without details of what you mean by... ...from a remote machine What do you mean by remote? What's the link between the client and the server? Dialup, LAN, WAN? VPN? You essentially need to think of the link between your client and the server as a pipe with numerous links in series and figure out whether it's choking...your client PC, your local network, remote network, server (hardware, software setup, database)? Use basic elimination techniques to rule out what is *not* a problem and look at the remaining suspects more closely. For example, if access through Remedy User from the same client PC is rather fast, the network is likely not an issue. If access using Remedy admin on the server itself is fast, then server side stuff including database is not an issue. Also, is it slow for others in your local network..for others in some other network? You get the idea. Another important question is whether it suddenly become slow or it has always been like this. If you want listers to point out the suspect, you will need to post details of you client PC, the network, the server hardware, the database details, concurrent user load etc. The last time I saw unusually slow opening of objects was when somebody had hacked into the underlying database to change the last modified date of all the objects and set them to some future date by mistake. Very unusual issue, **most likely irrelevant to you**. Sorry, I can't tell you exactly what the issue is in your environment. There is no substitute to following basic troubleshooting steps. Regards. --- Vinod [EMAIL PROTECTED] wrote: Hi, We currently work on one of the customised HelpDesk application. Whenever i open any active link of the HelpDesk form from a remote machine, it takes around 90-100 seconds whereas when i open an activelink of any other form in the same environment, it takes around 15 seconds. Taking 15 seconds for opening an object from a remote machine is acceptable but 100 seconds is too high. I am trying to find out the reason for the issue and i am looking for ways to improve the performance, whenever i open the active links of our HelpDesk form. Please provide me with some insight/thoughts on what may be the reason for such performance issue? Any suggestions or ideas for rectifying the issue is highly appretiated. Server : ARSystem 6.3 Admin Tool : 6.3 (Patch 20) THanks and Regards, Vinod ___ Yahoo! Answers - Got a question? Someone out there knows the answer. Try it now. http://uk.answers.yahoo.com/ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are Don't pick lemons. See all the new 2007 cars at Yahoo! Autos. http://autos.yahoo.com/new_cars.html ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Date/time field defaulting to 1/1/1970 while importing
Hi Anoop, I have found that opening the csv in MS excel sets the date format to the Windows setting. This could be the cause of your problem. Trying opening the csv in notepad and see the format. Regards, Murtuza. _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Anoop Sasidharan Sent: Friday, April 13, 2007 10:27 PM To: [EMAIL PROTECTED] Subject: Date/time field defaulting to 1/1/1970 while importing ** Listers, On one of the custom forms, I have a date/time field with display type as date. On the remedy client, if I set the date format to dd/mm/ and then import a record(using import tool), the date/time field defaults to 1/1/1970 for all the records imported. I then tried creating a date field and followed the same process as above and when I imported the records, it works fine.It displays the expected date. However if I can change the date format on the client tool to mm/dd/, then everything works fine. What could be the possible problem? Is this how the date/time field works or am I missing any setting change.? P.S On the import tool also date format is set to dd/mm/. Thanks Anoop. _ Windows Live Spaces is here! It's easy to create your own personal Web site. Check it out! http://spaces.live.com/?mkt=en-in __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Cannot delete class from CMDB Class Manager
Hello Terry, There is a very good white paper on this in the Remedy KB. But this order of deletions should do it: 1. Entry from OBJSTR:Pending 2. Entry from OBJSTR:Attributes 3. Entry from OBJSTR:Class 4. The actual forms BMC... And AST... Regards, Murtuza. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Terry Bootsma Sent: Friday, April 13, 2007 4:37 PM To: [EMAIL PROTECTED] Subject: Cannot delete class from CMDB Class Manager Hello everyone: CMDB Version 1.1.0 Patch 004 Windows 2003 Server Remedy ARS 6.3 Well, I thought I would go to the list for a little support on this one. I wanted to see if anyone had experienced this problem and/or solution before. I am in the CMDB class manager on one of my environments and I tried to delete a CMDB class which I had created earlier. When I try to do this, I get the following error message in the entry in the Class Manager Console (The class is in a status of DELETE PENDING). 03/27/2007 8:10:08 AM Remedy Application Service Sync Class: BMC:NAV_TestingClass 03/27/2007 8:10:08 AM Remedy Application Service ERROR: 120002 Class does not exist. OB0003FFE4C39C_gsQRQwZCoBQOwAA I've tried stopping/restarting the Remedy and the CMDB engine, but it appears to be stuck. This class inherits from BMC_ComputerSystem. I have only added one character attribute called TestField (Character field) The following forms exist in the admin tool for this form: AST:NAV_TestingClass BMC:NAV_TestingClass BMC:NAV_TestingClass_ At this point, I would like to know the series of forms that I would need to delete this information from in order to remove this Class from my environment. I had been instructed by support to remove entries from objstr:class, but that would leave several other entries in other forms orphaned. Can anyone out there give me a complete list of the forms for which I need to delete the class definition attributes from if I want to COMPLETELY remove this class from my environment? Thanks.. Terry P.S - This issue has been opened with support since March 29th with no resolution to date ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Upgrade to v6.3 and portmapper will not work - prod server down
I need some help !!! I just did an upgrade from 5.1.2 to v6.3 on the way to 7. But I cannot get past 6.3 because I cannot get the portmapper to start. I think part of the problem is that it's pointing to an executeable that doesn't exist. I copied the v7 one from the dev server to the prod server but that doesn't work either. There's nothing in the doc or knowledge base about this at all. When I try to start the portmapper I get an error 913: oxc1 I've put a ticket in for support but I don't know if they will call to help since we have m-f support. I would greatly appreciate anyone's help on this. Thanks, Susan Windows 2003 Just upgraded Oracle from 9r2 to 10g today before v6.3 install ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Upgrade to v6.3 and portmapper will not work - prod server down
Look in the Event log on the server and see if it tells what is happening when Portmapper tries to start. On 4/14/07, Susan Palmer [EMAIL PROTECTED] wrote: ** I need some help !!! I just did an upgrade from 5.1.2 to v6.3 on the way to 7. But I cannot get past 6.3 because I cannot get the portmapper to start. I think part of the problem is that it's pointing to an executeable that doesn't exist. I copied the v7 one from the dev server to the prod server but that doesn't work either. There's nothing in the doc or knowledge base about this at all. When I try to start the portmapper I get an error 913: oxc1 I've put a ticket in for support but I don't know if they will call to help since we have m-f support. I would greatly appreciate anyone's help on this. Thanks, Susan Windows 2003 Just upgraded Oracle from 9r2 to 10g today before v6.3 install __20060125___This posting was submitted with HTML in it___ -- Frank Caruso Specific Integration, Inc. Senior Remedy Engineer, ITIL Foundation Certified www.specificintegration.com 703-376-1249 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Upgrade to v6.3 and portmapper will not work - prod server down
Well ... went ahead and did the v7.0.1P1 install and it cured the portmapper problem. Now the ARS server won't start. There were no errors in the install log until the very end when it was trying to start the service. I find it somewhat humorous that it asks you to do something you cannot to correct the problem, import the samples ... lol The entries from the install log: 17:00:55 Setup created the AR System License File directory: C:\Program Files\Common Files\AR System\Licenses\remsrv 17:00:55 Registry Key successfully set: 17:00:55 Key: Software\Remedy\ARServer\remsrv 17:00:55 Name: ArMonitorConfigFile 17:00:55 Value: C:\Program Files\AR System\remsrv\conf\armonitor.cfg 17:00:55 Installing services... 17:00:55 -[ShowMsg]: Installing services... 17:00:59 Portmapper service installed successfully. 17:00:59 Installed server service: Remedy Action Request System Server 17:00:59 Registry Key successfully set: 17:00:59 Key: Software\Remedy\ARServer\remsrv 17:00:59 Name: ServiceName 17:00:59 Value: Remedy Action Request System Server 17:00:59 Registry Key successfully set: 17:00:59 Key: Software\Remedy\ARServer\remsrv 17:00:59 Name: InstPort 17:00:59 Value: 1 17:00:59 Registry Key successfully set: 17:00:59 Key: Software\Remedy\ARServer\remsrv 17:00:59 Name: Language 17:00:59 Value: 17:00:59 -[ShowMsg]: Starting services... 17:01:02 -[ShowMsg]: Starting AR System Portmapper Service. 17:01:05 Checking for service: AR System Portmapper 17:01:05 Specified service is installed: AR System Portmapper 17:01:05 Trying to start the service: AR System Portmapper 17:01:08 Waited 5 secs for service to start. 17:01:08 Service has been started: AR System Portmapper 17:01:08 -[ShowMsg]: Starting AR System Server Service. 17:01:11 Checking for service: Remedy Action Request System Server 17:01:11 Specified service is installed: Remedy Action Request System Server 17:01:11 Trying to start the service: Remedy Action Request System Server 17:01:13 -[ERROR]: Failed to start the service: Remedy Action Request System Server 17:01:13 -[ERROR]: Unable to start the AR System Server service 17:01:16 -[ERROR]: The AR System Server could not be started. You can start it manually using the Services icon in the Control Panel. This error occurred after the installation of the AR System was completed. To correct this error, import the sample applications from the samples subdirectory. 17:01:24 -[ERROR]: Failed to complete AR Server installation. I can sql into the database so I know it's up. What could be causing this? Thanks, Susan On 4/14/07, Susan Palmer [EMAIL PROTECTED] wrote: I need some help !!! I just did an upgrade from 5.1.2 to v6.3 on the way to 7. But I cannot get past 6.3 because I cannot get the portmapper to start. I think part of the problem is that it's pointing to an executeable that doesn't exist. I copied the v7 one from the dev server to the prod server but that doesn't work either. There's nothing in the doc or knowledge base about this at all. When I try to start the portmapper I get an error 913: oxc1 I've put a ticket in for support but I don't know if they will call to help since we have m-f support. I would greatly appreciate anyone's help on this. Thanks, Susan Windows 2003 Just upgraded Oracle from 9r2 to 10g today before v6.3 install ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Upgrade to v6.3 and portmapper will not work - prod server down
Went ahead and did the v7 upgrade ... took away the portmapper issue. Now the AR Service won't start. I put the log entry in the last email. Appreciate any help you can provide. Susan On 4/14/07, Frank Caruso [EMAIL PROTECTED] wrote: ** Look in the Event log on the server and see if it tells what is happening when Portmapper tries to start. On 4/14/07, Susan Palmer [EMAIL PROTECTED] wrote: ** I need some help !!! I just did an upgrade from 5.1.2 to v6.3 on the way to 7. But I cannot get past 6.3 because I cannot get the portmapper to start. I think part of the problem is that it's pointing to an executeable that doesn't exist. I copied the v7 one from the dev server to the prod server but that doesn't work either. There's nothing in the doc or knowledge base about this at all. When I try to start the portmapper I get an error 913: oxc1 I've put a ticket in for support but I don't know if they will call to help since we have m-f support. I would greatly appreciate anyone's help on this. Thanks, Susan Windows 2003 Just upgraded Oracle from 9r2 to 10g today before v6.3 install __20060125___This posting was submitted with HTML in it___ -- Frank Caruso Specific Integration, Inc. Senior Remedy Engineer, ITIL Foundation Certified www.specificintegration.com 703-376-1249 __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Upgrade to v6.3 and portmapper will not work - prod server down
Susan, I posted this a couple of weeks ago. The install was for SQL 2000 to 2005, but I thought I would post it anyway because of the correlation to the portmapper issue that you have encountered (step 9 specific). As for why 7 won't start, I didn't experience those issues going from 6.3 P21 to 7.01 P1: Eric, Is SQL 2005 supported for 6.03? I didn't think it was. However, I just went through several upgrades with a customer from 5.1.2 to 6.03 on several boxes, but this was under SQL 2000. But, I did do the same steps listed below when I took them from 6.0.3 to 7.0.1 with SQL 2005. I'm not sure of the order that everything was installed in your environment, but the procedure listed below has worked successfully for me, time and time again. Based on not knowing the steps that you have taken to get to this point, this would be my recommendation to follow if the ARSystem DB will even run on SQL 2005. 1) Start with SQL 2000 on the Dev Box. 2) Restore a good 5.1.2 2000 backup to it - Run the scripts tfserver etc. to remove server references, the command to change ownership of all forms / views to dbo, and then change the dbowner to ARAdmin. 3) Run the 6.0.3 (NO PATCH) Server install against the SQL 2000 DB. 4) Validate successful implementation by logging into the User Tool. 5) Backup ARSystem DB. 6) Uninstall SQL 2000 7) Install SQL 2005 8) Change dbowner back to ARAdmin - You might have to add that login first in the SQL 2005 Manager (I did). 9) Make sure you reboot your App Server before continuing - (There is a problem with the installer that I have been able to repeat. If you keep running the installers, something gets jacked up with the Portmap.exe. It is almost as though too many registry entries get created (not uninstalled / re-installed). If I reboot after running the installer twice, I will get an Explorer message upon reboot about the Portmap.exe dying. This will cause the Server to go out to lunch because it can't find the correct port mapper entry to use. Just FYI! - I have been able to reproduce this problem numerous times). 10) Run the 6.0.3 Patch 21 Server Install against the SQL 2005 DB 11) Validate successful implementation by logging into the User Tool. Thanks, G. Rogers - Original Message - From: Susan Palmer Newsgroups: public.remedy.arsystem.general To: [EMAIL PROTECTED] Sent: Saturday, April 14, 2007 3:20 PM Subject: Re: Upgrade to v6.3 and portmapper will not work - prod server down ** Well ... went ahead and did the v7.0.1P1 install and it cured the portmapper problem. Now the ARS server won't start. There were no errors in the install log until the very end when it was trying to start the service. I find it somewhat humorous that it asks you to do something you cannot to correct the problem, import the samples ... lol The entries from the install log: 17:00:55 Setup created the AR System License File directory: C:\Program Files\Common Files\AR System\Licenses\remsrv 17:00:55 Registry Key successfully set: 17:00:55 Key: Software\Remedy\ARServer\remsrv 17:00:55 Name: ArMonitorConfigFile 17:00:55 Value: C:\Program Files\AR System\remsrv\conf\armonitor.cfg 17:00:55 Installing services... 17:00:55 -[ShowMsg]: Installing services... 17:00:59 Portmapper service installed successfully. 17:00:59 Installed server service: Remedy Action Request System Server 17:00:59 Registry Key successfully set: 17:00:59 Key: Software\Remedy\ARServer\remsrv 17:00:59 Name: ServiceName 17:00:59 Value: Remedy Action Request System Server 17:00:59 Registry Key successfully set: 17:00:59 Key: Software\Remedy\ARServer\remsrv 17:00:59 Name: InstPort 17:00:59 Value: 1 17:00:59 Registry Key successfully set: 17:00:59 Key: Software\Remedy\ARServer\remsrv 17:00:59 Name: Language 17:00:59 Value: 17:00:59 -[ShowMsg]: Starting services... 17:01:02 -[ShowMsg]: Starting AR System Portmapper Service. 17:01:05 Checking for service: AR System Portmapper 17:01:05 Specified service is installed: AR System Portmapper 17:01:05 Trying to start the service: AR System Portmapper 17:01:08 Waited 5 secs for service to start. 17:01:08 Service has been started: AR System Portmapper 17:01:08 -[ShowMsg]: Starting AR System Server Service. 17:01:11 Checking for service: Remedy Action Request System Server 17:01:11 Specified service is installed: Remedy Action Request System Server 17:01:11 Trying to start the service: Remedy Action Request System Server 17:01:13 -[ERROR]: Failed to start the service: Remedy Action Request System Server 17:01:13 -[ERROR]: Unable to start the AR System Server service 17:01:16 -[ERROR]: The AR System Server could not be started. You can start it manually using the Services icon in the Control Panel. This error occurred after the installation of the AR System was completed. To correct
Re: Upgrade to v6.3 and portmapper will not work - prod server down
Thanks for the input. I think 6.3 has a problem with the portmapper. There was no portmap.exe with the install. Haven't got a clue as to what the issue is. I also notice that the installer wanted to put the installation in a slightly different folder than the 5.1.2 install. It put another level there, the server name, then all the files. In effect you still have 5.1.2 installed but yet not installed because the db has been updated. I can connect to the db via sql tool, just cannot get AR System to start. Not giving up yet ... if I do a restore I probably won't get another date for 6 months! Thanks,, Susan On 4/14/07, GRogers [EMAIL PROTECTED] wrote: ** Susan, I posted this a couple of weeks ago. The install was for SQL 2000 to 2005, but I thought I would post it anyway because of the correlation to the portmapper issue that you have encountered (step 9 specific). As for why 7 won't start, I didn't experience those issues going from 6.3 P21 to 7.01P1: Eric, Is SQL 2005 supported for 6.03? I didn't think it was. However, I just went through several upgrades with a customer from 5.1.2 to 6.03 on several boxes, but this was under SQL 2000. But, I did do the same steps listed below when I took them from 6.0.3 to 7.0.1 with SQL 2005. I'm not sure of the order that everything was installed in your environment, but the procedure listed below has worked successfully for me, time and time again. Based on not knowing the steps that you have taken to get to this point, this would be my recommendation to follow if the ARSystem DB will even run on SQL 2005. 1) Start with SQL 2000 on the Dev Box. 2) Restore a good 5.1.2 2000 backup to it - Run the scripts tfserver etc. to remove server references, the command to change ownership of all forms / views to dbo, and then change the dbowner to ARAdmin. 3) Run the 6.0.3 (NO PATCH) Server install against the SQL 2000 DB. 4) Validate successful implementation by logging into the User Tool. 5) Backup ARSystem DB. 6) Uninstall SQL 2000 7) Install SQL 2005 8) Change dbowner back to ARAdmin - You might have to add that login first in the SQL 2005 Manager (I did). 9) Make sure you reboot your App Server before continuing - (There is a problem with the installer that I have been able to repeat. If you keep running the installers, something gets jacked up with the Portmap.exe. It is almost as though too many registry entries get created (not uninstalled / re-installed). If I reboot after running the installer twice, I will get an Explorer message upon reboot about the Portmap.exe dying. This will cause the Server to go out to lunch because it can't find the correct port mapper entry to use. Just FYI! - I have been able to reproduce this problem numerous times). 10) Run the 6.0.3 Patch 21 Server Install against the SQL 2005 DB 11) Validate successful implementation by logging into the User Tool. Thanks, G. Rogers - Original Message - *From:* Susan Palmer [EMAIL PROTECTED] *Newsgroups:* public.remedy.arsystem.general *To:* [EMAIL PROTECTED] *Sent:* Saturday, April 14, 2007 3:20 PM *Subject:* Re: Upgrade to v6.3 and portmapper will not work - prod server down ** Well ... went ahead and did the v7.0.1P1 install and it cured the portmapper problem. Now the ARS server won't start. There were no errors in the install log until the very end when it was trying to start the service. I find it somewhat humorous that it asks you to do something you cannot to correct the problem, import the samples ... lol The entries from the install log: 17:00:55 Setup created the AR System License File directory: C:\Program Files\Common Files\AR System\Licenses\remsrv 17:00:55 Registry Key successfully set: 17:00:55 Key: Software\Remedy\ARServer\remsrv 17:00:55 Name: ArMonitorConfigFile 17:00:55 Value: C:\Program Files\AR System\remsrv\conf\armonitor.cfg 17:00:55 Installing services... 17:00:55 -[ShowMsg]: Installing services... 17:00:59 Portmapper service installed successfully. 17:00:59 Installed server service: Remedy Action Request System Server 17:00:59 Registry Key successfully set: 17:00:59 Key: Software\Remedy\ARServer\remsrv 17:00:59 Name: ServiceName 17:00:59 Value: Remedy Action Request System Server 17:00:59 Registry Key successfully set: 17:00:59 Key: Software\Remedy\ARServer\remsrv 17:00:59 Name: InstPort 17:00:59 Value: 1 17:00:59 Registry Key successfully set: 17:00:59 Key: Software\Remedy\ARServer\remsrv 17:00:59 Name: Language 17:00:59 Value: 17:00:59 -[ShowMsg]: Starting services... 17:01:02 -[ShowMsg]: Starting AR System Portmapper Service. 17:01:05 Checking for service: AR System Portmapper 17:01:05 Specified service is installed: AR System Portmapper 17:01:05 Trying to start the service: AR System Portmapper 17:01:08 Waited 5 secs for service to start. 17:01:08 Service has been started: AR System Portmapper 17:01:08 -[ShowMsg]: Starting AR System Server Service. 17:01:11 Checking for
Re: Upgrade to v6.3 and portmapper will not work - prod server down
Susan, If you have to backout of this and can't get 7 running today, I would suggest the following for the next pass: 1) Upgrade ARS to 6.3 no patch under Oracle 9i 2) Test for connectivity (User tool) 3) Backup the 6.3 database 4) Reboot APP and DB server 5) Install ARS 6.3 Patch 21 (DST) 6) Test for connectivity (User tool) 7) Backup the 6.3 P21 database 8) Reboot APP and DB server 9) Install ARS 7.0 (NO PATCH - I know patch 1 of 7.0 has email issues) 10) Test for connectivity (User tool) 11) Backup the 7.0 database 12) Uninstall Oracle 9i / Install 10g or Upgrade. 13) Restore 7.0 database 14) Enter any commands to change DB ownership. 15) Reboot APP and DB server 16) Install ARS 7.0.1 Patch 1 (This will bring the DB into conformity with the new version) 17) Test for connectivity (User tool) You can probably skip steps 1 - 4, but for the sake of flakiness between the installers, this has worked successfully for me and my customers. By following this process it might add an additional hour or two, but the results have been pain free. Hope you get it going. Thanks, George - Original Message - From: Susan Palmer Newsgroups: public.remedy.arsystem.general To: [EMAIL PROTECTED] Sent: Saturday, April 14, 2007 4:12 PM Subject: [Norton AntiSpam] Re: Upgrade to v6.3 and portmapper will not work - prod server down ** Thanks for the input. I think 6.3 has a problem with the portmapper. There was no portmap.exe with the install. Haven't got a clue as to what the issue is. I also notice that the installer wanted to put the installation in a slightly different folder than the 5.1.2 install. It put another level there, the server name, then all the files. In effect you still have 5.1.2 installed but yet not installed because the db has been updated. I can connect to the db via sql tool, just cannot get AR System to start. Not giving up yet ... if I do a restore I probably won't get another date for 6 months! Thanks,, Susan On 4/14/07, GRogers [EMAIL PROTECTED] wrote: ** Susan, I posted this a couple of weeks ago. The install was for SQL 2000 to 2005, but I thought I would post it anyway because of the correlation to the portmapper issue that you have encountered (step 9 specific). As for why 7 won't start, I didn't experience those issues going from 6.3 P21 to 7.01 P1: Eric, Is SQL 2005 supported for 6.03? I didn't think it was. However, I just went through several upgrades with a customer from 5.1.2 to 6.03 on several boxes, but this was under SQL 2000. But, I did do the same steps listed below when I took them from 6.0.3 to 7.0.1 with SQL 2005. I'm not sure of the order that everything was installed in your environment, but the procedure listed below has worked successfully for me, time and time again. Based on not knowing the steps that you have taken to get to this point, this would be my recommendation to follow if the ARSystem DB will even run on SQL 2005. 1) Start with SQL 2000 on the Dev Box. 2) Restore a good 5.1.2 2000 backup to it - Run the scripts tfserver etc. to remove server references, the command to change ownership of all forms / views to dbo, and then change the dbowner to ARAdmin. 3) Run the 6.0.3 (NO PATCH) Server install against the SQL 2000 DB. 4) Validate successful implementation by logging into the User Tool. 5) Backup ARSystem DB. 6) Uninstall SQL 2000 7) Install SQL 2005 8) Change dbowner back to ARAdmin - You might have to add that login first in the SQL 2005 Manager (I did). 9) Make sure you reboot your App Server before continuing - (There is a problem with the installer that I have been able to repeat. If you keep running the installers, something gets jacked up with the Portmap.exe. It is almost as though too many registry entries get created (not uninstalled / re-installed). If I reboot after running the installer twice, I will get an Explorer message upon reboot about the Portmap.exe dying. This will cause the Server to go out to lunch because it can't find the correct port mapper entry to use. Just FYI! - I have been able to reproduce this problem numerous times). 10) Run the 6.0.3 Patch 21 Server Install against the SQL 2005 DB 11) Validate successful implementation by logging into the User Tool. Thanks, G. Rogers - Original Message - From: Susan Palmer Newsgroups: public.remedy.arsystem.general To: [EMAIL PROTECTED] Sent: Saturday, April 14, 2007 3:20 PM Subject: Re: Upgrade to v6.3 and portmapper will not work - prod server down ** Well ... went ahead and did the v7.0.1P1 install and it cured the portmapper problem. Now the ARS server won't start. There were no errors in the install log until the very end when it was trying to start the service. I find it somewhat humorous that it asks you to do
Showing related records.
Hello, Ive got 2 tables, lets say A and B First one holds some records added manually On the second I'd like to have all records related to those from table A I think I need to loop over the table A , get each record ID and pass it to the qualification on table B. First thing: my actl guide doesnt seem to work correctly, it always gives me only one ID (Table loop Selected Rows checkbox is unchecked) Second thing: how to pass the obtained ID to the Table B to use it with the qualification. Any advices are welcome. Thanks. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are