I started an export ALL to .def file for one of my 7.1.00.001 servers a bit ago - the Admin tool (same patch level) is on an XP machine with 1gb RAM and is using 400 mb and peaks CPU to only 15% every minute.
The servers: AR Server has run between 5% and 10% cpu almost continuously, with the separate SQL Server at 15% to 20% cpu continuously. Occasionally the AR Server will jump to 30% while the SQL Server drops to 0%, or the two will switch places. After 18 minutes the Admin Tool displayed an error "Malloc in client library failed (ARERR 154)" and declared the Export Complete. The exported file, however, is only 148 kb and has only 94 data visualization objects in it. Tried again on a Vista machine with 2 gb RAM - same patch level Admin Tool - this time it completed in about 15 minutes without any indication of an error, creating a 254 mb text file. The Data Visualization defs are at the very end of this file (they were the ONLY objects in the failed file). I tried loading this new file in the 7.1.00.001 Migrator and it loaded, although it issued an error at the end the file conversion process: There were errors while converting the AR System Definition File C:\~~\Remedy7ALL.def Error 9088 (missing rel op -- 1) Then it went on to Retrieve Objects and loaded 39,179 objects into a new .migrator file. Unfortunately, the source server has 39,372 objects when Migrator accesses it directly, so something in the exported file was still missing. I tried a second time and got the same error, but the final object count loaded from the same file was 39,181 (two more than the first time). If the Admin Tool cannot handle exporting all items on the server to def, or create a valid .def file when doing it, by the same token it probably cannot handle updating the search database for all items on the server. I guess they should have thought about that before building applications where the developers appear to have had a "pay by the object" model going for them. Christopher E. Strauss, Ph.D. Remedy Database Administrator University of North Texas Computing Center http://remedy.unt.edu/helpdesk/ -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of J.T. Shyman Sent: Friday, November 30, 2007 10:11 AM To: [email protected] Subject: Re: Synch Search Database, UNIX (UNCLASSIFIED) I'd be curious to see what the load on both the database backend and the remedy server (and what processes are causing the load) is during such an export. If there isn't any discernable load on either then I'd say there is a defect in either the ARServer or the admin tool that is getting stuck in an endless loop. I've got a 7.1 system, with no ITSM apps loaded yet, on RHEL 4 on VMWare. Maybe I'll try an export and see what happens. J.T. Shyman Column Technologies -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Drew Shuller Sent: Friday, November 30, 2007 11:02 AM To: [email protected] Subject: Re: Synch Search Database, UNIX (UNCLASSIFIED) Just so you know, I tried to export a form and All Related the other day. It was either the AST:People or the AST:AssetPeople form, I can't remember. But the export ran for about 30 minutes before I gave up and shut the admin tool down. And that was only exporting ONE form. Drew _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
