Re: Archiving strategy on ITSM 7.6 +
We implemented a data-driven archive functionality for ITSP. This was written by Abydos. This is roughly the strategy we followed: 1. Determine which module to set up the archiving for (we started with Incident Management) 2. Determine which associated forms (WorkLogs, Attachments etc) to carry over 3. Determine the archive criteria (Number of days after closure no associations for example) 4. New field added CC_Chk_ArchiveFlag 5. Archive process enabled on the server and on the relevant forms (Qualification CC_Chk_ArchiveFlag = “Yes”) 6. Table qualifications on the parent archive form are amended to point to new archive forms (e.g. WorkLog table now points to ARC_HPD:WorkLog) Our data driven solution works in the following way: 1. All the matching parent records are updated using an escalation that reads a SQL script and updates the CC_Chk_ArchiveFlag field Example Script: UPDATE HPD_Help_Desk SET CC_Chk_ArchiveFlag = 0 WHERE (NOT EXISTS (SELECT chg.Request_ID01 FROM CHG_Associations chg WHERE chg.Request_ID01 = Incident_Number AND chg.Status 5) AND NOT EXISTS (SELECT hpd.Request_ID01 FROM HPD_Associations hpd WHERE hpd.Request_ID01 = Incident_Number AND hpd.Status 5) AND NOT EXISTS (SELECT pke.Request_ID01 FROM PBM_Known_Error_Associations pke WHERE pke.Request_ID01 = Incident_Number AND pke.Status 5) AND NOT EXISTS (SELECT pia.Request_ID01 FROM PBM_Investigation_Associations pia WHERE pia.Request_ID01 = Incident_Number AND pia.Status 5) AND NOT EXISTS (SELECT srm.Request_ID01 FROM SRM_Associations srm WHERE srm.Request_ID01 = Incident_Number AND srm.Status 5)) AND Status = 5 AND Closed_Date 132192 2. All the related child records are updated using an escalation that reads a SQL script and updates the records. Example Script: UPDATE (SELECT secondaryform.CC_Chk_ArchiveFlag as archiveFlag FROM HPD_Help_Desk primaryform, HPD_WorkLog secondaryform WHERE secondaryform.Incident_Number = primaryform.Incident_Number AND primaryform.CC_Chk_ArchiveFlag = 0) SET archiveFlag=0 3. Once all the parent and child records have the CC_Chk_ArchiveFlag set, the normal archive process (defined on the server) takes over and archives the child records first and then the parent records. The process is performed in this order to ensure that the normal HPD:Help Desk filters that fire on delete do not delete the child records. The above solution is easily extendible. The difficult bit is working out the SQL! It works well, and we are looking to roll out to other modules. Hope this helps. I can give more information off list if required. Gavin Coleman Senior Analyst/Programmer Computacenter (UK) Ltd Services Solutions Hatfield Avenue Hatfield, Hertfordshire, AL10 9TW, United Kingdom T: +44 (0) 1707 631662 E: gavin.cole...@computacenter.commailto:gavin.cole...@computacenter.com W: www.computacenter.comhttp://www.computacenter.com From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Matthew Kunkel Sent: 26 January 2012 22:18 To: arslist@ARSLIST.ORG Subject: Re: Archiving strategy on ITSM 7.6 + ** Two options we have seen from BMC are DSO and custom scripts, both require custom mappings for each of ~1000 regular forms. Additionally, structure changes would need to be maintained in custom mappings when customizations, patches, and upgrades are installed. Since BMC no longer includes the change details in ITSM patch release documentation, both solutions are problematic. There are database level products that allow some mining of the redo logs and should give a hybrid replication/archive functionality. One strategy under development is strip purge job deletes from the redo logs and propagate all other data/structure changes. Two products that we have encountered are Oracle Golden Gate and IBM Change Data Capture (neither is in use yet and this is not an endorsement or recommendation). Matthew Kunkel Systems Engineer Phone 479.277.3392 mtku...@wal-mart.com Walmart 805 Moberly Lane, MS32 Bentonville, AR 72716 Save money. Live better. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of patchsk Sent: Tuesday, January 24, 2012 2:19 PM To: arslist@ARSLIST.ORG Subject: Archiving strategy on ITSM 7.6 + ** We just started to looking at archiving our production data. We are currently in ITSM 7.6.03. With so many related forms to main forms, it would be tricky and take significant effort to properly draw the archiving plan like which forms need to archived in which order so that relationships are carried over so that a closed incident will be moved to a different server or a different form with all of its relationships in tact. Anyone done this already, if so can you provide a few details on the strategy you followed. DSO is another option we are looking at it but have not made decision yet. We can not use DB
Re: 7.6.04 - Configuring custom Ticket prefixes for Incidents for diff companies?
Making this change on the requestID field value probably isn't the best route to use, or at least the format. The field is limited to 15 characters and your customization is using up 8. This leaves only 7 numbers available for ticket number which results in a max of 10,000,000 tickets less 1 in your system. Sure the prefix changes, but the counter portion doesn't. Once you hit ticket ten million, your workflow overwrites the 1 and you now ether have a duplicate ticket number or you were saved by the prefix for a different company. At this stage the number of errors start. We use the instancID field to break things up by company and ticket type. The field is 38 characters and most values are only 30 characters in length. Brent... Sent from my iPhone, so typo's or funky words can and do happen! On Jan 30, 2012, at 6:28 AM, Chuck cpg...@gmail.com wrote: You'll have to do it with code. Look at the following Filter: You will have to find the Filters and Activelinks that fetch the Incident Number and then create new code to change it when the number is retrieved. On Jan 27, 11:18 am, Antonio Remedy antonio.rem...@gmail.com wrote: ARS Listers, Good afternoon. We're looking through the documentation and wanted to know if there is a way to create custom prefixes for Incident tickets via configuration. We're not sure if we can make this change via configuration or if this custom prefix must be created via code. Our 7.6.04 environment is a multi-tenant environment and we'd like to separate out each Incident by adding a company's abbreviation in the INC number prefix. Here's a sample of what we're looking to do: COMPANY ABBREVIATION SAMPLE CUSTOM INCIDENT PREFIX - ABCINC_ABC_001 - DEFINC_DEF_005 - XYZ INC_XYZ_007 Again, just wondering if this can be done via configuration and not via creating customized workflow. The idea/question popped up as the sample Incidents in 7.6.04 for Calbo have the following Incident prefix: INC_CAL_000123 Thanks in advance, ~Antonio ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org attend wwrug12www.wwrug12.comARSList: 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
Re: Archiving strategy on ITSM 7.6 +
Thanks to all for your time. I think now I have a starting point. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Dataimport.bat
I'm trying to get our import working (we used to use the arimport.exe tool. I really miss that tool). :( We are on ARS 7.6.04 SP2. Can anyone assist me? Right now, just trying to kick off an import at the cmd line: C:\Program Files\BMC Software\ARSystem\dataimporttool dataimport.bat -x usy90ap421.us.tycoelectronics.com -a 5213 -u username -p password -l c:\ARProcesses\Log s\JobImport.log -M C:\ARProcesses\Importmap\JobImport.armx -o C:\temp\TWS_Jobs.csv But nothing happens, no log file either. My dataimport.bat file looks like. I put a REM before the java line (after the Launch the Import Line) because I'm launching the import from a cmd file) Is this correct? set CUR_DIR=%~dp0 rem Save the environment variables we are changing so we can reset them set _CLASSPATH=%CLASSPATH% set _PATH=%PATH% rem -- Set up the environment variables. set APIDROP=.\plugins\com.bmc.arsys.studio.api_7.6.04\lib if not exist %JAVA_HOME% set JAVA_HOME=jdkPath set PATH=%JAVA_HOME%\bin;%PATH%;%APIDROP% rem Set the classpath to include all the required jar files set CLASSPATH=%CLASSPATH%;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\arapiext7604_build002.jar;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\arapi7604_build002.jar;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\log4j-1.2.14.jar;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\activation.jar; rem Launch the import rem java -Xms64m -Xmx512m com.bmc.arsys.apiext.data.DataImport %* rem Reset the environment set CLASSPATH=%_CLASSPATH% set PATH=%_PATH% Lisa Kemes AR System Developer TEIS - USA +1 717 810 2408 tel +1 717 602 9460 mobile lisa.ke...@te.commailto:lisa.ke...@te.com 100 Amp Drive Harrisburg, PA 17112 [http://www.te.com/images/socialmedia/smallTElogo.gif]http://www.te.com/ www.te.comhttp://www.te.com/ [http://www.te.com/images/socialmedia/twitter.png]http://twitter.com/teconnectivity [http://www.te.com/images/socialmedia/facebook.png] http://www.facebook.com/teconnectivity [http://www.te.com/images/socialmedia/flickr.png] http://www.flickr.com/photos/teconnectivity/ [http://www.te.com/images/socialmedia/linkedin.png] http://www.linkedin.com/groups?gid=1591657 [http://www.te.com/images/socialmedia/youtube.png] http://www.youtube.com/teconnectivity ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Dataimport.bat
Lisa, when you rem out that java line, nothing happens because that is what runs the actual import of the data, the dataimport.bat sets up the environment variables needed to run java and call the dataimport class and then takes all of the parameters you specify on the command line and runs java, calls that class and passes the parameters to it. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa Sent: Monday, January 30, 2012 3:30 PM To: arslist@ARSLIST.ORG Subject: Dataimport.bat ** I'm trying to get our import working (we used to use the arimport.exe tool. I really miss that tool). :( We are on ARS 7.6.04 SP2. Can anyone assist me? Right now, just trying to kick off an import at the cmd line: C:\Program Files\BMC Software\ARSystem\dataimporttool dataimport.bat -x usy90ap421.us.tycoelectronics.com -a 5213 -u username -p password -l c:\ARProcesses\Log s\JobImport.log -M C:\ARProcesses\Importmap\JobImport.armx -o C:\temp\TWS_Jobs.csv But nothing happens, no log file either. My dataimport.bat file looks like. I put a REM before the java line (after the Launch the Import Line) because I'm launching the import from a cmd file) Is this correct? set CUR_DIR=%~dp0 rem Save the environment variables we are changing so we can reset them set _CLASSPATH=%CLASSPATH% set _PATH=%PATH% rem -- Set up the environment variables. set APIDROP=.\plugins\com.bmc.arsys.studio.api_7.6.04\lib if not exist %JAVA_HOME% set JAVA_HOME=jdkPath set PATH=%JAVA_HOME%\bin;%PATH%;%APIDROP% rem Set the classpath to include all the required jar files set CLASSPATH=%CLASSPATH%;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\arapiext7604_build002.jar;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\arapi7604_build002.jar;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\log4j-1.2.14.jar;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\activation.jar; rem Launch the import rem java -Xms64m -Xmx512m com.bmc.arsys.apiext.data.DataImport %* rem Reset the environment set CLASSPATH=%_CLASSPATH% set PATH=%_PATH% Lisa Kemes AR System Developer TEIS - USA +1 717 810 2408 tel +1 717 602 9460 mobile lisa.ke...@te.commailto:lisa.ke...@te.com 100 Amp Drive Harrisburg, PA 17112 [http://www.te.com/images/socialmedia/smallTElogo.gif]http://www.te.com/ www.te.comhttp://www.te.com/ [http://www.te.com/images/socialmedia/twitter.png]http://twitter.com/teconnectivity[http://www.te.com/images/socialmedia/facebook.png]http://www.facebook.com/teconnectivity[http://www.te.com/images/socialmedia/flickr.png]http://www.flickr.com/photos/teconnectivity/[http://www.te.com/images/socialmedia/linkedin.png]http://www.linkedin.com/groups?gid=1591657[http://www.te.com/images/socialmedia/youtube.png]http://www.youtube.com/teconnectivity _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
Re: Dataimport.bat
Thanks! OK, so the documentation suggests this: java -classpath %APIDROP%\arapi7604.jar;%APIDROP%\arapiext7604.jar; .com.bmc.arsys.apiext.data.DataImport [options] So this isn't what I'd put in this area is it? And I don't need to specify any options do I, if I'm specifying them in the command line? Thanks! Lisa From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Campbell, Paul (Paul) Sent: Monday, January 30, 2012 3:41 PM To: arslist@ARSLIST.ORG Subject: Re: Dataimport.bat ** Lisa, when you rem out that java line, nothing happens because that is what runs the actual import of the data, the dataimport.bat sets up the environment variables needed to run java and call the dataimport class and then takes all of the parameters you specify on the command line and runs java, calls that class and passes the parameters to it. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa Sent: Monday, January 30, 2012 3:30 PM To: arslist@ARSLIST.ORG Subject: Dataimport.bat ** I'm trying to get our import working (we used to use the arimport.exe tool. I really miss that tool). :( We are on ARS 7.6.04 SP2. Can anyone assist me? Right now, just trying to kick off an import at the cmd line: C:\Program Files\BMC Software\ARSystem\dataimporttool dataimport.bat -x usy90ap421.us.tycoelectronics.com -a 5213 -u username -p password -l c:\ARProcesses\Log s\JobImport.log -M C:\ARProcesses\Importmap\JobImport.armx -o C:\temp\TWS_Jobs.csv But nothing happens, no log file either. My dataimport.bat file looks like. I put a REM before the java line (after the Launch the Import Line) because I'm launching the import from a cmd file) Is this correct? set CUR_DIR=%~dp0 rem Save the environment variables we are changing so we can reset them set _CLASSPATH=%CLASSPATH% set _PATH=%PATH% rem -- Set up the environment variables. set APIDROP=.\plugins\com.bmc.arsys.studio.api_7.6.04\lib if not exist %JAVA_HOME% set JAVA_HOME=jdkPath set PATH=%JAVA_HOME%\bin;%PATH%;%APIDROP% rem Set the classpath to include all the required jar files set CLASSPATH=%CLASSPATH%;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\arapiext7604_build002.jar;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\arapi7604_build002.jar;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\log4j-1.2.14.jar;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\activation.jar; rem Launch the import rem java -Xms64m -Xmx512m com.bmc.arsys.apiext.data.DataImport %* rem Reset the environment set CLASSPATH=%_CLASSPATH% set PATH=%_PATH% Lisa Kemes AR System Developer TEIS - USA +1 717 810 2408 tel +1 717 602 9460 mobile lisa.ke...@te.commailto:lisa.ke...@te.com 100 Amp Drive Harrisburg, PA 17112 [http://www.te.com/images/socialmedia/smallTElogo.gif]http://www.te.com/ www.te.comhttp://www.te.com/ [http://www.te.com/images/socialmedia/twitter.png]http://twitter.com/teconnectivity[http://www.te.com/images/socialmedia/facebook.png]http://www.facebook.com/teconnectivity[http://www.te.com/images/socialmedia/flickr.png]http://www.flickr.com/photos/teconnectivity/[http://www.te.com/images/socialmedia/linkedin.png]http://www.linkedin.com/groups?gid=1591657[http://www.te.com/images/socialmedia/youtube.png]http://www.youtube.com/teconnectivity _attend WWRUG12 www.wwrug.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
Re: Dataimport.bat
If you are in the directory like your example shows, you shouldn't have to set anything assuming the batch file can find java and the java line in the batch file is not remmed out From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa Sent: Monday, January 30, 2012 3:52 PM To: arslist@ARSLIST.ORG Subject: Re: Dataimport.bat ** Thanks! OK, so the documentation suggests this: java -classpath %APIDROP%\arapi7604.jar;%APIDROP%\arapiext7604.jar; .com.bmc.arsys.apiext.data.DataImport [options] So this isn't what I'd put in this area is it? And I don't need to specify any options do I, if I'm specifying them in the command line? Thanks! Lisa From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Campbell, Paul (Paul) Sent: Monday, January 30, 2012 3:41 PM To: arslist@ARSLIST.ORG Subject: Re: Dataimport.bat ** Lisa, when you rem out that java line, nothing happens because that is what runs the actual import of the data, the dataimport.bat sets up the environment variables needed to run java and call the dataimport class and then takes all of the parameters you specify on the command line and runs java, calls that class and passes the parameters to it. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa Sent: Monday, January 30, 2012 3:30 PM To: arslist@ARSLIST.ORG Subject: Dataimport.bat ** I'm trying to get our import working (we used to use the arimport.exe tool. I really miss that tool). :( We are on ARS 7.6.04 SP2. Can anyone assist me? Right now, just trying to kick off an import at the cmd line: C:\Program Files\BMC Software\ARSystem\dataimporttool dataimport.bat -x usy90ap421.us.tycoelectronics.com -a 5213 -u username -p password -l c:\ARProcesses\Log s\JobImport.log -M C:\ARProcesses\Importmap\JobImport.armx -o C:\temp\TWS_Jobs.csv But nothing happens, no log file either. My dataimport.bat file looks like. I put a REM before the java line (after the Launch the Import Line) because I'm launching the import from a cmd file) Is this correct? set CUR_DIR=%~dp0 rem Save the environment variables we are changing so we can reset them set _CLASSPATH=%CLASSPATH% set _PATH=%PATH% rem -- Set up the environment variables. set APIDROP=.\plugins\com.bmc.arsys.studio.api_7.6.04\lib if not exist %JAVA_HOME% set JAVA_HOME=jdkPath set PATH=%JAVA_HOME%\bin;%PATH%;%APIDROP% rem Set the classpath to include all the required jar files set CLASSPATH=%CLASSPATH%;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\arapiext7604_build002.jar;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\arapi7604_build002.jar;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\log4j-1.2.14.jar;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\activation.jar; rem Launch the import rem java -Xms64m -Xmx512m com.bmc.arsys.apiext.data.DataImport %* rem Reset the environment set CLASSPATH=%_CLASSPATH% set PATH=%_PATH% Lisa Kemes AR System Developer TEIS - USA +1 717 810 2408 tel +1 717 602 9460 mobile lisa.ke...@te.commailto:lisa.ke...@te.com 100 Amp Drive Harrisburg, PA 17112 [http://www.te.com/images/socialmedia/smallTElogo.gif]http://www.te.com/ www.te.comhttp://www.te.com/ [http://www.te.com/images/socialmedia/twitter.png]http://twitter.com/teconnectivity[http://www.te.com/images/socialmedia/facebook.png]http://www.facebook.com/teconnectivity[http://www.te.com/images/socialmedia/flickr.png]http://www.flickr.com/photos/teconnectivity/[http://www.te.com/images/socialmedia/linkedin.png]http://www.linkedin.com/groups?gid=1591657[http://www.te.com/images/socialmedia/youtube.png]http://www.youtube.com/teconnectivity _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.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
Re: Archiving strategy on ITSM 7.6 +
Yurbi Connect can also be used for this purpose and solves the difficult part of building the SQL. Yurbi comes with an out of the box connector to BMC and any customizations can be made to our out of the box integration, or you can build a Yurbi App from scratch using our AnyDB technology. - http://www.yurbi.com/solutions/bmc-itsm-remedy/ Using Yurbi you can create all your data extracts based on the extraction rules you like. - Video here of that process - http://yurbi.tv/index.php?p=216 Then you can pass that report/data into our Yurbi Connect process which can allow you to schedule it and insert it into any ODBC datasource for archiving or data mart building. No video of the data mart building process but you can see how easy the Yurbi Connect workflow is by looking at this email to Service Desk example - http://yurbi.tv/index.php?p=138 The benefit is instead of hardcoding a lot of scripting you've got a solution that is easy to modify or add when you change or add forms. thanks, David On Mon, Jan 30, 2012 at 6:07 AM, Coleman, Gavin gavin.cole...@computacenter.com wrote: ** We implemented a data-driven archive functionality for ITSP. This was written by Abydos. This is roughly the strategy we followed: ** ** **1. **Determine which module to set up the archiving for (we started with Incident Management) ** ** **2. **Determine which associated forms (WorkLogs, Attachments etc) to carry over ** ** **3. **Determine the archive criteria (Number of days after closure no associations for example) ** ** **4. **New field added CC_Chk_ArchiveFlag ** ** **5. **Archive process enabled on the server and on the relevant forms (Qualification CC_Chk_ArchiveFlag = “Yes”) ** ** **6. **Table qualifications on the parent archive form are amended to point to new archive forms (e.g. WorkLog table now points to ARC_HPD:WorkLog) ** ** ** ** Our data driven solution works in the following way: ** ** **1. **All the matching parent records are updated using an escalation that reads a SQL script and updates the CC_Chk_ArchiveFlag field ** ** Example Script: ** ** UPDATE HPD_Help_Desk SET CC_Chk_ArchiveFlag = 0 WHERE (NOT EXISTS (SELECT chg.Request_ID01 FROM CHG_Associations chg WHERE chg.Request_ID01 = Incident_Number AND chg.Status 5) AND NOT EXISTS (SELECT hpd.Request_ID01 FROM HPD_Associations hpd WHERE hpd.Request_ID01 = Incident_Number AND hpd.Status 5) AND NOT EXISTS (SELECT pke.Request_ID01 FROM PBM_Known_Error_Associations pke* *** WHERE pke.Request_ID01 = Incident_Number AND pke.Status 5) AND NOT EXISTS (SELECT pia.Request_ID01 FROM PBM_Investigation_Associations pia WHERE pia.Request_ID01 = Incident_Number AND pia.Status 5) AND NOT EXISTS (SELECT srm.Request_ID01 FROM SRM_Associations srm WHERE srm.Request_ID01 = Incident_Number AND srm.Status 5)) AND Status = 5 AND Closed_Date 132192 ** ** ** ** **2. **All the related child records are updated using an escalation that reads a SQL script and updates the records. ** ** Example Script: ** ** UPDATE (SELECT secondaryform.CC_Chk_ArchiveFlag as archiveFlag FROM HPD_Help_Desk primaryform, HPD_WorkLog secondaryform WHERE secondaryform.Incident_Number = primaryform.Incident_Number AND primaryform.CC_Chk_ArchiveFlag = 0) SET archiveFlag=0 ** ** **3. **Once all the parent and child records have the CC_Chk_ArchiveFlag set, the normal archive process (defined on the server) takes over and archives the child records first and then the parent records. The process is performed in this order to ensure that the normal HPD:Help Desk filters that fire on delete do not delete the child records. ** ** ** ** The above solution is easily extendible. The difficult bit is working out the SQL! It works well, and we are looking to roll out to other modules.** ** ** ** Hope this helps. I can give more information off list if required. ** ** *Gavin Coleman* *Senior Analyst/Programmer * *Computacenter (UK) Ltd* Services Solutions Hatfield Avenue Hatfield, Hertfordshire, AL10 9TW, United Kingdom T: +44 (0) 1707 631662 E: *gavin.cole...@computacenter.com* W: *www.computacenter.com* ** ** *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Matthew Kunkel *Sent:* 26 January 2012 22:18 *To:* arslist@ARSLIST.ORG *Subject:* Re: Archiving strategy on ITSM 7.6 + ** ** ** Two options we have seen from BMC are DSO and custom scripts, both require custom mappings for each of ~1000 regular forms. Additionally, structure changes would need to be maintained in custom mappings when customizations, patches, and upgrades are installed. Since BMC no longer includes the
Re: Dataimport.bat
If I'm getting this error: 'java' is not recognized as an internal or external command,operable program or batch file. Does this mean that it can't find java? Thanks! Lisa From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Campbell, Paul (Paul) Sent: Monday, January 30, 2012 4:51 PM To: arslist@ARSLIST.ORG Subject: Re: Dataimport.bat ** If you are in the directory like your example shows, you shouldn't have to set anything assuming the batch file can find java and the java line in the batch file is not remmed out From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa Sent: Monday, January 30, 2012 3:52 PM To: arslist@ARSLIST.ORG Subject: Re: Dataimport.bat ** Thanks! OK, so the documentation suggests this: java -classpath %APIDROP%\arapi7604.jar;%APIDROP%\arapiext7604.jar; .com.bmc.arsys.apiext.data.DataImport [options] So this isn't what I'd put in this area is it? And I don't need to specify any options do I, if I'm specifying them in the command line? Thanks! Lisa From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Campbell, Paul (Paul) Sent: Monday, January 30, 2012 3:41 PM To: arslist@ARSLIST.ORG Subject: Re: Dataimport.bat ** Lisa, when you rem out that java line, nothing happens because that is what runs the actual import of the data, the dataimport.bat sets up the environment variables needed to run java and call the dataimport class and then takes all of the parameters you specify on the command line and runs java, calls that class and passes the parameters to it. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa Sent: Monday, January 30, 2012 3:30 PM To: arslist@ARSLIST.ORG Subject: Dataimport.bat ** I'm trying to get our import working (we used to use the arimport.exe tool. I really miss that tool). :( We are on ARS 7.6.04 SP2. Can anyone assist me? Right now, just trying to kick off an import at the cmd line: C:\Program Files\BMC Software\ARSystem\dataimporttool dataimport.bat -x usy90ap421.us.tycoelectronics.com -a 5213 -u username -p password -l c:\ARProcesses\Log s\JobImport.log -M C:\ARProcesses\Importmap\JobImport.armx -o C:\temp\TWS_Jobs.csv But nothing happens, no log file either. My dataimport.bat file looks like. I put a REM before the java line (after the Launch the Import Line) because I'm launching the import from a cmd file) Is this correct? set CUR_DIR=%~dp0 rem Save the environment variables we are changing so we can reset them set _CLASSPATH=%CLASSPATH% set _PATH=%PATH% rem -- Set up the environment variables. set APIDROP=.\plugins\com.bmc.arsys.studio.api_7.6.04\lib if not exist %JAVA_HOME% set JAVA_HOME=jdkPath set PATH=%JAVA_HOME%\bin;%PATH%;%APIDROP% rem Set the classpath to include all the required jar files set CLASSPATH=%CLASSPATH%;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\arapiext7604_build002.jar;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\arapi7604_build002.jar;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\log4j-1.2.14.jar;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\activation.jar; rem Launch the import rem java -Xms64m -Xmx512m com.bmc.arsys.apiext.data.DataImport %* rem Reset the environment set CLASSPATH=%_CLASSPATH% set PATH=%_PATH% Lisa Kemes AR System Developer TEIS - USA +1 717 810 2408 tel +1 717 602 9460 mobile lisa.ke...@te.commailto:lisa.ke...@te.com 100 Amp Drive Harrisburg, PA 17112 [http://www.te.com/images/socialmedia/smallTElogo.gif]http://www.te.com/ www.te.comhttp://www.te.com/ [http://www.te.com/images/socialmedia/twitter.png]http://twitter.com/teconnectivity[http://www.te.com/images/socialmedia/facebook.png]http://www.facebook.com/teconnectivity[http://www.te.com/images/socialmedia/flickr.png]http://www.flickr.com/photos/teconnectivity/[http://www.te.com/images/socialmedia/linkedin.png]http://www.linkedin.com/groups?gid=1591657[http://www.te.com/images/socialmedia/youtube.png]http://www.youtube.com/teconnectivity _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.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
BCAC Discovery Integration for CMDB (CDI) v8.2 - install issues
Hey folks, I'm curious if anyone out there has had success in installing the CDI 8.2 integration into a CMDB which has or had an older (v8.1) CDI already in place. We have been fighting multiple issues with the various components the installer lays down, and are curious if we are the only ones having these challenges and if there are any lessons learned floating around that might help us along. Many components of the install (RE, AIE, etc.) are cmdb extensions, arx files, etc. but there is a lot of black-box magic happening within the InstallShield package. This is quite frustrating, since there is no clear way to validate what the installer lays down, combined with the fact that you are not able to execute the individual bits by hand when troubleshooting. Instructions state to uninstall the previous integration before putting in the new one -- this contributes to some of the issues we have experienced, listed below: - Installer fails on extending BaseElement BMC_Software. Cause: The CDI attributes already exist from a previous version, and the uninstall (thankfully) does not drop the attributes. Workaround: Create a dummy SHARE:Application Properties record for the schema extensions, so that they are skipped. The uninstall removes these records, you have to put them back. You can let the others run, since the uninstall does clean that data out correctly. remedy.cmdbextloader.install.details.1=Configuration Discovery Schema Extension for BMC Atrium CMDB:SKIP remedy.cmdbextloader.install.details.2=Configuration Discovery Integration for BMC Atrium CMDB:SUCCESS remedy.cmdbextloader.install.details.3=Configuration Discovery Trusted Dataset Import Into BMC Atrium CMDB:SUCCESS remedy.cmdbextloader.install.details.4=Configuration Discovery Federation Data: :SUCESS - Installer fails on setting up the Normalization Jobs and rule modifications Cause: No clue Workaround: BMC support provided a shell script hotfix to execute the Java class which the installer calls. We have dug into the 8753 error below, but all of the NE functions seem to be operating properly. [Thu 01/26/2012 17:09:05.69]: Configuration Discovery Integration (CDI) 8.2.00 NE Settings started. [Thu 01/26/2012 17:09:05.69]: ARServer Name: server [Thu 01/26/2012 17:09:05.69]: ARServer UserName: user ERROR (8753): Error in plugin; BMC.FILTERAPI.NORM.ENGINE at com.bmc.arsys.api.ProxyJRpcBase.verifyStatus(Unknown Source) at com.bmc.arsys.api.ProxyJRpcBase.a(Unknown Source) at com.bmc.arsys.api.ProxyJRpcBase.arCall(Unknown Source) at com.bmc.arsys.api.ProxyJRpc.ARServiceEntry(Unknown Source) at com.bmc.arsys.api.ARServerUser.executeService(Unknown Source) at com.bmc.ne.api.NEClientFactory$ClientInvocationHandler.invoke(Unknown Source) at $Proxy4.createJob(Unknown Source) at CDINESettings.createNEBatchJob(CDINESettings.java:238) at CDINESettings.main(CDINESettings.java:30 [Thu 01/26/2012 17:09:07.83]: Configuration Discovery Integration (CDI) 8.2.00 NE Settings is Failed. - Installer fails on creating the federated plugin, along with required federated class for BCAC Software Usage Cause: No clue Workaround: None yet [Thu 01/26/2012 17:10:37.02]: Configuration Discovery Integration (CDI) 8.2.00 Federation Manager Settings Started. [Thu 01/26/2012 17:10:37.02]: ARServer Name: server [Thu 01/26/2012 17:10:37.02]: ARServer UserName: user [Thu 01/26/2012 17:10:37.02]: Federation Manager Settings are not Applicable to Install. Our goal is to run the installer end-to-end, without error and have all bits installed. We are working with BMC Support, but I wanted to reach out to the community to see if anyone has any been there done that info they could share. Thanks, Tony ARS 7.5p6 AtriumCore 7.6p2 ITSM 7.6p2 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Dataimport.bat
Lisa are you typing in the command as you wrote below? open a DOS command box and type java, see what you get. If you get the error you are mentioning then you do not have java installed on the machine you are trying to run the command from. otherwise you will get the help from the java command. As for the import, you can run it from the ..\dataimporttool or the Developer Studio directory, you can also run it from a custom directory but then you have to make a slight change to the bat file. If you are still stuck email me directly and I will walk you through it. thanks Shafqat Ayaz From: Kemes, Lisa lisa.ke...@te.com To: arslist@ARSLIST.ORG Sent: Monday, January 30, 2012 10:01 PM Subject: Re: Dataimport.bat ** If I'm getting this error: 'java' is not recognized as an internal or external command,operable program or batch file. Does this mean that it can't find java? Thanks! Lisa From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Campbell, Paul (Paul) Sent: Monday, January 30, 2012 4:51 PM To: arslist@ARSLIST.ORG Subject: Re: Dataimport.bat ** If you are in the directory like your example shows, you shouldn’t have to set anything assuming the batch file can find java and the java line in the batch file is not remmed out From:Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa Sent: Monday, January 30, 2012 3:52 PM To: arslist@ARSLIST.ORG Subject: Re: Dataimport.bat ** Thanks! OK, so the documentation suggests this: java -classpath %APIDROP%\arapi7604.jar;%APIDROP%\arapiext7604.jar; .com.bmc.arsys.apiext.data.DataImport [options] So this isn't what I'd put in this area is it? And I don't need to specify any options do I, if I'm specifying them in the command line? Thanks! Lisa From:Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Campbell, Paul (Paul) Sent: Monday, January 30, 2012 3:41 PM To: arslist@ARSLIST.ORG Subject: Re: Dataimport.bat ** Lisa, when you rem out that java line, nothing happens because that is what runs the actual import of the data, the dataimport.bat sets up the environment variables needed to run java and call the dataimport class and then takes all of the parameters you specify on the command line and runs java, calls that class and passes the parameters to it. From:Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa Sent: Monday, January 30, 2012 3:30 PM To: arslist@ARSLIST.ORG Subject: Dataimport.bat ** I'm trying to get our import working (we used to use the arimport.exe tool. I really miss that tool). :( We are on ARS 7.6.04 SP2. Can anyone assist me? Right now, just trying to kick off an import at the cmd line: C:\Program Files\BMC Software\ARSystem\dataimporttool dataimport.bat -x usy90ap421.us.tycoelectronics.com -a 5213 -u username -p password -l c:\ARProcesses\Log s\JobImport.log -M C:\ARProcesses\Importmap\JobImport.armx -o C:\temp\TWS_Jobs.csv But nothing happens, no log file either. My dataimport.bat file looks like. I put a REM before the java line (after the Launch the Import Line) because I'm launching the import from a cmd file) Is this correct? set CUR_DIR=%~dp0 rem Save the environment variables we are changing so we can reset them set _CLASSPATH=%CLASSPATH% set _PATH=%PATH% rem -- Set up the environment variables. set APIDROP=.\plugins\com.bmc.arsys.studio.api_7.6.04\lib if not exist %JAVA_HOME% set JAVA_HOME=jdkPath set PATH=%JAVA_HOME%\bin;%PATH%;%APIDROP% rem Set the classpath to include all the required jar files set CLASSPATH=%CLASSPATH%;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\arapiext7604_build002.jar;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\arapi7604_build002.jar;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\log4j-1.2.14.jar;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\activation.jar; rem Launch the import rem java -Xms64m -Xmx512m com.bmc.arsys.apiext.data.DataImport %* rem Reset the environment set CLASSPATH=%_CLASSPATH% set PATH=%_PATH% Lisa Kemes AR System Developer TEIS - USA +1 717 810 2408 tel +1 717 602 9460 mobile lisa.ke...@te.com 100 Amp Drive Harrisburg, PA 17112 www.te.com _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.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
Re: Dataimport.bat
Correct ... It means that the Java executable can not be found in the PATH on that machine From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa Sent: Monday, January 30, 2012 4:01 PM To: arslist@ARSLIST.ORG Subject: Re: Dataimport.bat ** If I'm getting this error: 'java' is not recognized as an internal or external command,operable program or batch file. Does this mean that it can't find java? Thanks! Lisa From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Campbell, Paul (Paul) Sent: Monday, January 30, 2012 4:51 PM To: arslist@ARSLIST.ORG Subject: Re: Dataimport.bat ** If you are in the directory like your example shows, you shouldn't have to set anything assuming the batch file can find java and the java line in the batch file is not remmed out From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa Sent: Monday, January 30, 2012 3:52 PM To: arslist@ARSLIST.ORG Subject: Re: Dataimport.bat ** Thanks! OK, so the documentation suggests this: java -classpath %APIDROP%\arapi7604.jar;%APIDROP%\arapiext7604.jar; .com.bmc.arsys.apiext.data.DataImport [options] So this isn't what I'd put in this area is it? And I don't need to specify any options do I, if I'm specifying them in the command line? Thanks! Lisa From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Campbell, Paul (Paul) Sent: Monday, January 30, 2012 3:41 PM To: arslist@ARSLIST.ORG Subject: Re: Dataimport.bat ** Lisa, when you rem out that java line, nothing happens because that is what runs the actual import of the data, the dataimport.bat sets up the environment variables needed to run java and call the dataimport class and then takes all of the parameters you specify on the command line and runs java, calls that class and passes the parameters to it. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa Sent: Monday, January 30, 2012 3:30 PM To: arslist@ARSLIST.ORG Subject: Dataimport.bat ** I'm trying to get our import working (we used to use the arimport.exe tool. I really miss that tool). :( We are on ARS 7.6.04 SP2. Can anyone assist me? Right now, just trying to kick off an import at the cmd line: C:\Program Files\BMC Software\ARSystem\dataimporttool dataimport.bat -x usy90ap421.us.tycoelectronics.com -a 5213 -u username -p password -l c:\ARProcesses\Log s\JobImport.log -M C:\ARProcesses\Importmap\JobImport.armx -o C:\temp\TWS_Jobs.csv But nothing happens, no log file either. My dataimport.bat file looks like. I put a REM before the java line (after the Launch the Import Line) because I'm launching the import from a cmd file) Is this correct? set CUR_DIR=%~dp0 rem Save the environment variables we are changing so we can reset them set _CLASSPATH=%CLASSPATH% set _PATH=%PATH% rem -- Set up the environment variables. set APIDROP=.\plugins\com.bmc.arsys.studio.api_7.6.04\lib if not exist %JAVA_HOME% set JAVA_HOME=jdkPath set PATH=%JAVA_HOME%\bin;%PATH%;%APIDROP% rem Set the classpath to include all the required jar files set CLASSPATH=%CLASSPATH%;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\arapiext7604_build002.jar;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\arapi7604_build002.jar;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\log4j-1.2.14.jar;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\activation.jar; rem Launch the import rem java -Xms64m -Xmx512m com.bmc.arsys.apiext.data.DataImport %* rem Reset the environment set CLASSPATH=%_CLASSPATH% set PATH=%_PATH% Lisa Kemes AR System Developer TEIS - USA +1 717 810 2408 tel +1 717 602 9460 mobile lisa.ke...@te.commailto:lisa.ke...@te.com 100 Amp Drive Harrisburg, PA 17112 [http://www.te.com/images/socialmedia/smallTElogo.gif]http://www.te.com/ www.te.comhttp://www.te.com/ [http://www.te.com/images/socialmedia/twitter.png]http://twitter.com/teconnectivity[http://www.te.com/images/socialmedia/facebook.png]http://www.facebook.com/teconnectivity[http://www.te.com/images/socialmedia/flickr.png]http://www.flickr.com/photos/teconnectivity/[http://www.te.com/images/socialmedia/linkedin.png]http://www.linkedin.com/groups?gid=1591657[http://www.te.com/images/socialmedia/youtube.png]http://www.youtube.com/teconnectivity _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.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
Re: Dataimport.bat
If you liked using the arimport tool Of old...why don't you use the data import tool now? Dataimporttool.exe? It's a little different...but accomplishes the exact same thing. Just a thought... Bruce Sent from my iPad On Jan 30, 2012, at 5:26 PM, Grooms, Frederick W frederick.w.gro...@xo.com wrote: ** Correct … It means that the Java executable can not be found in the PATH on that machine From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa Sent: Monday, January 30, 2012 4:01 PM To: arslist@ARSLIST.ORG Subject: Re: Dataimport.bat ** If I'm getting this error: 'java' is not recognized as an internal or external command,operable program or batch file. Does this mean that it can't find java? Thanks! Lisa From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Campbell, Paul (Paul) Sent: Monday, January 30, 2012 4:51 PM To: arslist@ARSLIST.ORG Subject: Re: Dataimport.bat ** If you are in the directory like your example shows, you shouldn’t have to set anything assuming the batch file can find java and the java line in the batch file is not remmed out From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa Sent: Monday, January 30, 2012 3:52 PM To: arslist@ARSLIST.ORG Subject: Re: Dataimport.bat ** Thanks! OK, so the documentation suggests this: java -classpath %APIDROP%\arapi7604.jar;%APIDROP%\arapiext7604.jar; .com.bmc.arsys.apiext.data.DataImport [options] So this isn't what I'd put in this area is it? And I don't need to specify any options do I, if I'm specifying them in the command line? Thanks! Lisa From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Campbell, Paul (Paul) Sent: Monday, January 30, 2012 3:41 PM To: arslist@ARSLIST.ORG Subject: Re: Dataimport.bat ** Lisa, when you rem out that java line, nothing happens because that is what runs the actual import of the data, the dataimport.bat sets up the environment variables needed to run java and call the dataimport class and then takes all of the parameters you specify on the command line and runs java, calls that class and passes the parameters to it. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa Sent: Monday, January 30, 2012 3:30 PM To: arslist@ARSLIST.ORG Subject: Dataimport.bat ** I'm trying to get our import working (we used to use the arimport.exe tool. I really miss that tool). :( We are on ARS 7.6.04 SP2. Can anyone assist me? Right now, just trying to kick off an import at the cmd line: C:\Program Files\BMC Software\ARSystem\dataimporttool dataimport.bat -x usy90ap421.us.tycoelectronics.com -a 5213 -u username -p password -l c:\ARProcesses\Log s\JobImport.log -M C:\ARProcesses\Importmap\JobImport.armx -o C:\temp\TWS_Jobs.csv But nothing happens, no log file either. My dataimport.bat file looks like. I put a REM before the java line (after the Launch the Import Line) because I'm launching the import from a cmd file) Is this correct? set CUR_DIR=%~dp0 rem Save the environment variables we are changing so we can reset them set _CLASSPATH=%CLASSPATH% set _PATH=%PATH% rem -- Set up the environment variables. set APIDROP=.\plugins\com.bmc.arsys.studio.api_7.6.04\lib if not exist %JAVA_HOME% set JAVA_HOME=jdkPath set PATH=%JAVA_HOME%\bin;%PATH%;%APIDROP% rem Set the classpath to include all the required jar files set CLASSPATH=%CLASSPATH%;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\arapiext7604_build002.jar;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\arapi7604_build002.jar;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\log4j-1.2.14.jar;%CUR_DIR%\plugins\com.bmc.arsys.studio.api_7.6.4.build002\lib\activation.jar; rem Launch the import rem java -Xms64m -Xmx512m com.bmc.arsys.apiext.data.DataImport %* rem Reset the environment set CLASSPATH=%_CLASSPATH% set PATH=%_PATH% Lisa Kemes AR System Developer TEIS - USA +1 717 810 2408 tel +1 717 602 9460 mobile lisa.ke...@te.com 100 Amp Drive Harrisburg, PA 17112 www.te.com _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.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
Remedy on Demand
Dear Listers, After almost 15 years of service our custom built AR System applications are bing replaced by Remedy on Demand. Up until recently I have not been allowed to be involved as they were hoping it would all run out of the box. However, they now need some work doing to get the RoD system to talk to our other systems (Sophos anti-virus emails from PCs and interaction with our third-party maintainers, to name but two). Now; for the last week we having been talking to BMC to work out how I should get Developer Studio access to our development RoD system. I have been given VPN access to what I believe is the relevant BMC network. I have even been told to obtain a copy of the Cisco VPN client (which I think is now no longer easily downloadable from Cisco) from the University of Ghent in Belgium (which didn't really sound right - doesn't BMC have proper routes for distributing software). I also been told the server address and port number, which I presume is so that Dev Studio can access the server. The trouble is that with all this in place I can't get Dev Studio to talk to our RoD server. What I'm wondering is whether any one on this list has attempted this sort of thing before. If so how did you gain access? BMC RoD support doesn't seem to be able to come up with an answer - at least not yet. Thanks in advance, Ian Ian Trimnell, Systems Programmer, Information Technology The Open University, Milton Keynes, UK Phone: +44 (0)1908 6 53741tel:01908%206%2053741 web: http://www.open.ac.uk/ -- The Open University is incorporated by Royal Charter (RC 000391), an exempt charity in England Wales and a charity registered in Scotland (SC 038302). ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are