Thank Misi, I will keep that in mind. I had already started my own application to do imports and am using a SQL script and the driver (not the java driver) on a solaris server to do the exports.
On Thu, Sep 20, 2012 at 10:23 AM, Misi Mladoniczky <[email protected]> wrote: > Hi, > > As it happens I had something back in my closet that might help you, in > part, with this. At least with your DEF export problems. > > I made this tool because I had two main problems: > 1. Exporting a complete (ITSM) system just did not work in DevStudio > 2. Exporting packing lists sometimes missed a few objects... > > It can also export named objects, or a specific object type such as > regular forms. It also supports exporting of deployable applications. > > So without further ado RRR|ExportDef: > https://www.rrr.se/cgi/tools/main#rrrExportDef > > Let me know if you need Linux or Solaris versions. > > Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) > > Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): > * 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. > > > I wrote a system some time ago that used packing lists as its 'source' of > > what needed to be exported, and then exported each object to filesystem > > individually, then later, at time of import, re-assembled the files into > a > > Forms and Applications file, and everything else into another file. > Never > > had a problem with either Export OR Import once I moved it into this > > process...but then again, I can't say that 30K objects were involved in > > the import...but I fully expect the export process would have worked in > > that scenario. > > > > -----Original Message----- > > From: Action Request System discussion list(ARSList) > > [mailto:[email protected]] On Behalf Of W Scott Russell > > Sent: Thursday, September 20, 2012 8:22 AM > > To: [email protected] > > Subject: Re: Imports/Exports in ARS 7.6.4 patch 2 > > > > ** I did try the DefinitionExport.bat (in the Dev Studio directory) which > > looks to be a call into dev studio's export function; but it failed with > > the same error as dev studio. I will give the java driver (hopefully > > later today), but I am not expecting much ;) > > > > > > On Thu, Sep 20, 2012 at 8:17 AM, Longwing, LJ CTR MDA/IC > > <[email protected]> wrote: > > > > > > Interesting theory. I would be interested to see your results > using the > > JavaDriver (yea, it's there) and see if you get similar results. > > > > > > -----Original Message----- > > From: Action Request System discussion list(ARSList) > > [mailto:[email protected]] On Behalf Of W Scott Russell > > > > Sent: Thursday, September 20, 2012 8:16 AM > > To: [email protected] > > Subject: Re: Imports/Exports in ARS 7.6.4 patch 2 > > > > ** > > Ben - the arsignals that we have been using is with the -r. This > issue > > appears that the import is modifying the arserverd process/memory but is > > not being written to disk; therefore, when using the -r, the "user" > > servers do not get the change. > > > > LJ - Yes we are working with BMC; however, engineering has not been > > responsive to this issue. As for the export to one file, it worked in > > 7.1 and started failing with 7.6.4 (maybe earlier as we went from 7.1.to > > 7.6.4). The hot fix was to address RPC timeouts between dev studio and > > the arserverd; however, it only works some of the times (I tried 600 > > objects yesterday that failed with a chunking error). If I use the > > driver program, I am able to export much more (almost 30,000 yesterday). > > To me, it looks like an issue with the java api that the c api does not > > have. > > > > > > On Thu, Sep 20, 2012 at 7:43 AM, Longwing, LJ CTR MDA/IC > > <[email protected]> wrote: > > > > > > Scott, > > I feel your pain, but the only real solution I see for you > is to > > get BMC to get their code straight. You SHOULD be able to export > > from server A and import to server B, and as long as you chose > > the correct options, have server B look EXACTLY like the export > > from A, if that's not working, BMC needs to fix it. > > > > Regarding the exports/imports failing....I have personally > found > > on large export/import that separating the forms into one file > > and everything else into another file has solved all of my > > timeout issues I personally have experienced. > > > > > > -----Original Message----- > > From: Action Request System discussion list(ARSList) > > [mailto:[email protected]] On Behalf Of W Scott Russell > > > > Sent: Thursday, September 20, 2012 7:19 AM > > To: [email protected] > > Subject: Imports/Exports in ARS 7.6.4 patch 2 > > > > ** > > > > Looking to see if anyone else is having issues with > > Imports/Exports in this version of Remedy. > > > > Env: > > ARS 7.6.4 patch 002 (Server Group with many servers) > Solaris 10 > > Oracle 11g Total Custom Build Applications in Base Mode > > > > We have multiple environment so that we can develop, test, > and > > train on our application prior to moving it to production. > > Therefore, we rely on the ability to perform exports and imports > > of changed workflow (tracked via server events and another custom > > application) to move the changes from environment to environment. > > After upgrading to 7.6.4 patch 2 (from 7.1) we have found that > > we can no longer export our entire environment into one def file > > - also, most of the time, export via dev studio (or devil studio > > as we are calling it now) fails with various errors. We have > > been working the issue for several months with BMC and got a > > hotfix; however, it only works some of the time. Therefore, we > > have resorted to using the driver program to perform the export. > > As for imports, everything looked good until a developer > > accidentally added fields to all views of a form. We found it > > after we imported the form into our test environment. So we went > > back to the development environment and removed the fields from > > the other views and exported the form. Here is the main issue, > > when reimporting the form, the fields are NOT removed from the > > other views. We tried multiple different options on the import; > > however nothing worked. BMC told us to use the driver program to > > perform the import and add in the import option of > > AR_IMPORT_OPT_OVERWRITE_DISP_PROPS = 16777216 and that this > > option is not available in dev studio. We did this and the form > > looked correct on the "admin" server in our server group; > > however, our user reported that the form was not fixed. After > > days of research, multiple bounces of the "user" servers, > > multiple arsignals we found that when looking at the "user" > > servers via dev studio, the form was not fixed - but it looked > > fine on the "admin" server. Further investigation, found that > > the "admin" server had not been bounce after the import; > > therefore, it was showing the corrected form. Once the "admin" > > server was bounced, it no longer showed the corrected form. So, > > if dev studio and the driver will not import (and correct) a form > > (dev studio - java api; driver - c api), it looks like the only > > option left is to code directly in each environment - which lead > > to all kinds of other issues. > > > > Thus far, nothing back from engineering. So I am hoping > someone > > else has seen this and (really hoping) has found a better > > resolution. > > > > Thanks, > > Scott > > > > _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers > Are"_ > > > > > > > _______________________________________________________________________________ > > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > > attend wwrug12 www.wwrug12.com ARSList: "Where the > Answers Are" > > > > > > > > _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ > > > > > _______________________________________________________________________________ > > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > > attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" > > > > > > > > _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ > > > > > _______________________________________________________________________________ > > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > > attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" > > > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
