Re: Attachment replacement - Filter not firing?!
Hi Doug, thanks a lot for the explanation and help. You writte: In the filter run if condition, we do not compare file content. What we compare when you compare attachements is file names. Fair enough. I don't really care if the file. I just want to catch is there was a change in terms of replacing the file or attaching a new one. So, if you have file x attached, and you attach a new file x, you will get the DB.attach value matching the attach value because the filename is the same. If the filename was different, the values would not match. For some reason my filter is not firing even when I test 'DB.Attach1' ! = Attach1 and my *file name is diffrent*. But this one: TR.attach != $NULL$ works just fine. Thanks, Mark ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Runmacro issue
Any login information within the macro? From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Hyunkel v2.0 Sent: Wednesday, January 06, 2010 2:53 PM To: arslist@ARSLIST.ORG Subject: Runmacro issue ** I'm trying to generate a macro to create a new record on an specific form, I'm performing this via Unix shell, I'm seeing the runmacro process being triggered by the script and no error code is returned, but I'm not seeing any record created on the ARS side... This is what I have on my macro push Set-schema: HR_FIT_MACRO delldevopas Submit: HR_FIT_MACRO delldevopas| 8=Default submit value 7=0 4=Hugo Ruesga 2=Hugo Ruesga end It's very simple, but i don't have any idea why the record is not being created. Any help will be greatly appreciated. Hugo Ruesga perotsystems® US 972.577.7000 MX +52 (33) 3332.3868 P Please consider the environment before printing this email The information contained in and transferred with this electronic message is intended only for the recipient(s) designated above, it is protected by law and it may contain information which is privileged and confidential. If you are not the intended recipient, please do not read, copy, or use it, and do not disclose it to others. Please notify the sender of the delivery error by replying to this message, and then delete it from your system. Thank you. Windows 7 te la pone aún más fácil a ti, que eres estudiantehttp://www.windows7paraestudiantes.com.mx _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Runmacro issue
You may want to consider using arimportcmd (command-line import utility). Your script creates the input file. You can use arguments or a pre-built map file for field mappings. Most important, you can specify a log file to record the execution - normal termination, errors, whatever. Depending on the error that you got, there may be something in your Remedy server error log. Mike White EMail michael.wh...@verizon.com Office 813.978.2192 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Shellman, David Sent: Thursday, January 07, 2010 8:38 AM To: arslist@ARSLIST.ORG Subject: Re: Runmacro issue ** Any login information within the macro? From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Hyunkel v2.0 Sent: Wednesday, January 06, 2010 2:53 PM To: arslist@ARSLIST.ORG Subject: Runmacro issue ** I'm trying to generate a macro to create a new record on an specific form, I'm performing this via Unix shell, I'm seeing the runmacro process being triggered by the script and no error code is returned, but I'm not seeing any record created on the ARS side... This is what I have on my macro push Set-schema: HR_FIT_MACRO delldevopas Submit: HR_FIT_MACRO delldevopas| 8=Default submit value 7=0 4=Hugo Ruesga 2=Hugo Ruesga end It's very simple, but i don't have any idea why the record is not being created. Any help will be greatly appreciated. Hugo Ruesga perotsystems® US 972.577.7000 MX +52 (33) 3332.3868 P Please consider the environment before printing this email The information contained in and transferred with this electronic message is intended only for the recipient(s) designated above, it is protected by law and it may contain information which is privileged and confidential. If you are not the intended recipient, please do not read, copy, or use it, and do not disclose it to others. Please notify the sender of the delivery error by replying to this message, and then delete it from your system. Thank you. Windows 7 te la pone aún más fácil a ti, que eres estudiante http://www.windows7paraestudiantes.com.mx _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: ARServer Status monitor
There is a set length of time that the app server will attempt to reconnect to the DB instance. If it has re-established the connection after that length of time the system is in a state of limbo. You can add a variable (Db-Connection-Retries) in the conf file that will increase the length of time that the app server will attempts the database connection. Dave From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Jason Miller Sent: Wednesday, January 06, 2010 6:09 PM To: arslist@ARSLIST.ORG Subject: Re: ARServer Status monitor ** Ah, I used to have a 7.1 servers that would do that. The app and db server were plugged into the same darn switch but they would lose connection. Fortunately it was short enough that ARS usually recovered with no issue. I am surprise that a restart of Portmapper would resolve the issue. Do you have DSO? You could check available by transferring records. If not you could create a web service that does a simple query against a small form on prod and then have an Escalation on dev that would call the web service. If there is an error you could have dev perform whatever action you wish. This would include the Mid-Tier as a point of failure but maybe you want to make sure that MT is responding at the same time? Another idea would be to call runmacro from an Escalation on the dev server to try export a small set of records from prod. You can then either parse the return for error messages or if no file was created assume that the server is down. Look at the sc (Service Control) command to start/stop remote services. HTH, Jason On Wed, Jan 6, 2010 at 1:42 PM, Reiser, John J john.j.rei...@lmco.commailto:john.j.rei...@lmco.com wrote: ** Jason, The Service looked like it was running but there were entries in the error.log file that pointed to a dropped network connection or DB unavailable. General network error. Check your network documentation. (SQL Server 11) SQL Server does not exist or access denied. (SQL Server 17) Cannot open database ARSystem requested by the login. The login failed. (SQL Server 4060) Then all night long the error.log was filled with Dispatch : Timeout during database query -- consider using more specific search criteria to narrow the results, and retry the operation (servername removed) ARERR - 94 Distrib : Timeout during database query -- consider using more specific search criteria to narrow the results, and retry the operation (ARERR 94) This happened every 6 minutes until they called me at 6 AM and I kick started the Portmapper. Thanks, --- John J. Reiser Senior Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of Jason Miller Sent: Wednesday, January 06, 2010 3:54 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: ARServer Status monitor ** Hi John, Is ARS actually down on production or is just not allowing connections because Portmapper unhappy? Jason On Wed, Jan 6, 2010 at 10:10 AM, Reiser, John J john.j.rei...@lmco.commailto:john.j.rei...@lmco.com wrote: ** Hello Listers, ARServer 7.1 Patch 4 MS SQL Server 2005 Has anyone used server A to watch for outages on server B? Since we do have slow periods overnight the production server has occasionally been knocked offline and panic sets in a 5AM when the day shift comes on. It always just takes a ARSystem Portmapper restart to get things going again. I'd like to set up something with the development server, which seems to be unaffected, to periodically ping the production server and perform X if it gets no response. Like Query a form on production every 30 minutes between Midnight and 5 AM. No reply of a known value will either: (In order of preference) 1. Restart the services on Production and send an email to let everyone know that a restart happened. 2. Email the Admin (me) 3. Email the operations team with instructions on restarting the services. (Operations people don't like to restart things because they get blamed for unrelated breakage.) Thanks, --- John J. Reiser Senior Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me _Platinum Sponsor: rmisoluti...@verizon.netmailto:rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.netmailto:rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.netmailto:rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor:
Re: Issues in SLM 7.0.3
Dear ARSList, ARS Version : 7.1.00 Patch 006 SLM Version : 7.0.03 We are facing some issues in SLM 7.0.3, like to check any of you have any information\experienced this issues: 1) When the Incident is created in Pending state directly, the SLA status is moved to Pending state but after 15 min (15 is the Goal set for this SLA) the Status is getting changed to “Missed Goal” which causes the SLA to Missed though it’s in Pending state. The SLA is configured to Exclude Status = Pending. It Appears this issue is fixed in SLM 7.1 patch 002 . 2) This issue is related to the First one, the Milestones for the SLAs are also firing though the Status is Pending. This is happening even the Incident is created with any other state (New\Assigned) and then moved to Pending as well. I think we need to add the “Exclude if” condition in the Milestones also. Will that help ? 3) While calculating the Compliance for the Monthly review period, the Compliance is not considering the Incidents that are in Met state, its counting only the Missed records. In Development Server this is getting calculated correctly but not in production. But the Service target\SLA configuration is the same in both the servers. Appreciate your help and please let me know if you have any related information. THANKS ARSList!! Thanks, Viswa ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: ARServer Status monitor
Hi We have a small shell script (runs on Solaris/Linux) which uses wget (or curl) to log into the mid-tier, display the home page and then log out. Both output pages are stored in separate files. Wget is set to timeout in 15 seconds, and the script runs every couple minutes. The home page displays the quick link list, which exercises all of the system components including mid-tier, arserver and database. If the second file isn't there, somethings wrong and the admins get mailed, paged, etc. This is Solaris, so the script runs as a cron job. I'm not sure it's a good idea to use Remedy to monitor itself. You'd need something to run the test and something else to check for non results, and that would be both messy and obscure. Just for fun, try passing the same DSO record bsck and forth every minute. If your copy is older than a couple minutes, the other server needs attention :-) Doug -- Doug Blair Sent from my iPhone, typographic errors likely +1-224-558-5462 On Jan 7, 2010, at 7:50 AM, Shellman, David dave.shell...@tycoelectronics.com wrote: ** There is a set length of time that the app server will attempt to reconnect to the DB instance. If it has re-established the connection after that length of time the system is in a state of limbo. You can add a variable (Db-Connection-Retries) in the conf file that will increase the length of time that the app server will attempts the database connection. Dave From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Jason Miller Sent: Wednesday, January 06, 2010 6:09 PM To: arslist@ARSLIST.ORG Subject: Re: ARServer Status monitor ** Ah, I used to have a 7.1 servers that would do that. The app and db server were plugged into the same darn switch but they would lose connection. Fortunately it was short enough that ARS usually recovered with no issue. I am surprise that a restart of Portmapper would resolve the issue. Do you have DSO? You could check available by transferring records. If not you could create a web service that does a simple query against a small form on prod and then have an Escalation on dev that would call the web service. If there is an error you could have dev perform whatever action you wish. This would include the Mid-Tier as a point of failure but maybe you want to make sure that MT is responding at the same time? Another idea would be to call runmacro from an Escalation on the dev server to try export a small set of records from prod. You can then either parse the return for error messages or if no file was created assume that the server is down. Look at the sc (Service Control) command to start/stop remote services. HTH, Jason On Wed, Jan 6, 2010 at 1:42 PM, Reiser, John J john.j.rei...@lmco.com wrote: ** Jason, The Service looked like it was running but there were entries in the error.log file that pointed to a dropped network connection or DB unavailable. General network error. Check your network documentation. (SQL Server 11) SQL Server does not exist or access denied. (SQL Server 17) Cannot open database ARSystem requested by the login. The login failed. (SQL Server 4060) Then all night long the error.log was filled with Dispatch : Timeout during database query -- consider using more specific search criteria to narrow the results, and retry the operation (servername removed) ARERR - 94 Distrib : Timeout during database query -- consider using more specific search criteria to narrow the results, and retry the operation (ARERR 94) This happened every 6 minutes until they called me at 6 AM and I kick started the Portmapper. Thanks, --- John J. Reiser Senior Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Jason Miller Sent: Wednesday, January 06, 2010 3:54 PM To: arslist@ARSLIST.ORG Subject: Re: ARServer Status monitor ** Hi John, Is ARS actually down on production or is just not allowing connections because Portmapper unhappy? Jason On Wed, Jan 6, 2010 at 10:10 AM, Reiser, John J john.j.rei...@lmco.com wrote: ** Hello Listers, ARServer 7.1 Patch 4 MS SQL Server 2005 Has anyone used server A to watch for outages on server B? Since we do have slow periods overnight the production server has occasionally been knocked offline and panic sets in a 5AM when the day shift comes on. It always just takes a ARSystem Portmapper restart to get things going again. I’d like to set up something with the development server, which seem s to be unaffected, to periodically ping the production server and p erform X if it gets no response. Like Query a form on production every 30
DataCache Error on MidTier Logs
We are getting this warning on our Midtier logs every 30 seconds. It's been happening for about 3 weeks now. I restarted the Apache services, but it still keeps coming back. Jan 7, 2010 8:52:48 AM - WARNING (com.remedy.log.SESSION) : DataCache: System form not defined for ActorViewsGlobal Jan 7, 2010 8:53:18 AM - WARNING (com.remedy.log.SESSION) : DataCache: System form not defined for ActorViewsGlobal Any idea of where I can look? I'm not seeing any errors on the AR Server, just on our Midtier Server and the armidtier.log file. ARS 7.1 p7 Midtier 7.5 p3 Windows 2003 This is only on our Dev server thanks goodness. Looks like our Prod is doing fine. Some of these DataCache errors appear on the Prod armidtier.log file here and there, but not like this! Lisa Kemes AR System Developer Tyco Electronics 717-810-2408 tel 717-810-2124 fax lisa.ke...@tycoelectronics.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Data types are not appropriate for relational operation, 313, error message
List, I am on 7.5 and I noticed that I am getting these error messages quite frequently when working with our of the box selection fields. Has anyone else been getting these. For example I am working with filter RQC:REQ:RequesterInfo_080_SetRequestedBytoRequestedFor and all I want to do is add an additional item to the run if so that does not fire for a specific instance I am setting it to. When I try to save my changes I keep getting that error message Data types are not appropriate for relational operation, 313, It looks like the out of the box code is getting the error message. For instance if you go in that filter and change one of the selection fields to a different value, such as 'UnknownUser' from False to True I get that error message. Is there something querky going on with 7.5, is it something with the server I am on, or the developer tool etc I never got these on the admin tool prior to 7.5 Env: windows 2003 server, AR Server 7.5, ITSM 7.5 -- Kevin Begosh ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Data types are not appropriate for relational operation, 313, error message
Sorry I meant to say this before I sent it out. I seems like it is only happening on one of our environments, one developer tool etc... Any reason anyone know why this would be happening. What is wrong with that environment that the developer tool would be mistaking on selection values, I guess more so not recognizing them? Kevin On Thu, Jan 7, 2010 at 12:02 PM, Kevin Begosh kbeg...@gmail.com wrote: List, I am on 7.5 and I noticed that I am getting these error messages quite frequently when working with our of the box selection fields. Has anyone else been getting these. For example I am working with filter RQC:REQ:RequesterInfo_080_SetRequestedBytoRequestedFor and all I want to do is add an additional item to the run if so that does not fire for a specific instance I am setting it to. When I try to save my changes I keep getting that error message Data types are not appropriate for relational operation, 313, It looks like the out of the box code is getting the error message. For instance if you go in that filter and change one of the selection fields to a different value, such as 'UnknownUser' from False to True I get that error message. Is there something querky going on with 7.5, is it something with the server I am on, or the developer tool etc I never got these on the admin tool prior to 7.5 Env: windows 2003 server, AR Server 7.5, ITSM 7.5 -- Kevin Begosh -- Kevin Begosh ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
EIE Exchange field mapping
Hi list Need a little help I am trying to run a single data exchange for computer system from SMS to CMDB and I have errors during the exchange. The Product Categorization Tiers, Product Name and Manufacturer combination is not valid. The fields I have mapped are the Domain, System Type, Manufacturer, Model, Name, NumberofProcessors, Owner Name and AssetLifeCyclestatus. I'm wandering if it does a reverse lookup on the model and then tries to populate their own tiers. Does anyone know how I can fix this data mapping? What I want is to bring in the Model of the system and do a reverse lookup and have it populate the correct tiers for that model (to BMC.Core:BMC_ComputerSystem) once I get it there I can then bring it into the Asset. Has anyone done this? What is the best way to populate the tiers? JK * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free.
Seeking method to create new People asset (BMC:CORE:BMC_Person) records from existing CTM:People records en masse.
Good Day, I'm running into an ITSM 7.5 error when manually trying to relate a person to an asset in the Used By role. Supported By,Owned By, Managed By, Created By, Approved By all work properly. ARERR [326] Required field cannot be reset to a NULL value : BMC.CORE:BMC_Dependency : Destination.InstanceId Attribute does not exist. : 490009000 (ARERR 120004) It looks like this is occurring because BMC.CORE:BMC_Person records don't exist for all of our CTM:People records. Certain changes to a CTM:People record cause the people asset to be created, but not reliably under bulk operations (i.e. Modify All or escalation). I'm looking to create ~13K new people/asset (BMC:CORE:BMC_Person) records from existing CTM:People records. What is the best method to do so? Thanks In Advance, John -- View this message in context: http://old.nabble.com/Seeking-method-to-create-new-People-asset-%28BMC%3ACORE%3ABMC_Person%29-records-from-existing-CTM%3APeople-records-en-masse.-tp27063624p27063624.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:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Seeking method to create new People asset (BMC:CORE:BMC_Person) records from existing CTM:People records en masse.
Good Day, I'm running into an ITSM 7.5 error when manually trying to relate a person to an asset in the Used By role. Supported By,Owned By, Managed By, Created By, Approved By all work properly. ARERR [326] Required field cannot be reset to a NULL value : BMC.CORE:BMC_Dependency : Destination.InstanceId Attribute does not exist. : 490009000 (ARERR 120004) It looks like this is occurring because BMC.CORE:BMC_Person records don't exist for all of our CTM:People records. Certain changes to a CTM:People record cause the people asset to be created, but not reliably under bulk operations (i.e. Modify All or escalation). I'm looking to create ~13K new people/asset (BMC:CORE:BMC_Person) records from existing CTM:People records. What is the best method to do so? Thanks In Advance, John -- View this message in context: http://old.nabble.com/Seeking-method-to-create-new-People-asset-%28BMC%3ACORE%3ABMC_Person%29-records-from-existing-CTM%3APeople-records-en-masse.-tp27063652p27063652.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:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: EIE Exchange field mapping
It would help to know the versions you have installed. Turn on filter logging and try and create an entry manually in the BMC.CORE:BMC_ComputerSystem form using some sample data you are getting from SMS. The logs will reveal where the problem is. I suspect that the model/manufacturer is being looked up in the PCT:ProductCatalog form and, because no value(s) exist for the computers coming from SMS, the tiering is being left null. This assumes you are on CMDB 2.1 or earlier. CMDB 7.5 uses the normalisation engine which you can configure to continue even if the categorisation isn't found. You must also be mapping the dataset value otherwise the import will fail. Cheers Peter Hi list Need a little help I am trying to run a single data exchange for computer system from SMS to CMDB and I have errors during the exchange. The Product Categorization Tiers, Product Name and Manufacturer combination is not valid. The fields I have mapped are the Domain, System Type, Manufacturer, Model, Name, NumberofProcessors, Owner Name and AssetLifeCyclestatus. I'm wandering if it does a reverse lookup on the model and then tries to populate their own tiers. Does anyone know how I can fix this data mapping? What I want is to bring in the Model of the system and do a reverse lookup and have it populate the correct tiers for that model (to BMC.Core:BMC_ComputerSystem) once I get it there I can then bring it into the Asset. Has anyone done this? What is the best way to populate the tiers? JK * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: EIE Exchange field mapping
If you are running 2.1 (which it seems like), then you will have to already have the CTI categorization created within your product catalog. So you will need Category, type, item, model, manufacturer filled out. However, if you feel up to running the filter log, you will see that there is a filter (forget which) that will let you fill in the CTI only if the Manufacturer or some other attribute is BMC_UNKNOWN . However, in my environment, I have the Marimba CDI installed so I'm not sure if that workflow is a part of the integration. Tauf Chowdhury | Forest Laboratories, Inc. Analyst, Service Management Mobile:646.483.2779 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Peter Romain Sent: Thursday, January 07, 2010 12:57 PM To: arslist@ARSLIST.ORG Subject: Re: EIE Exchange field mapping It would help to know the versions you have installed. Turn on filter logging and try and create an entry manually in the BMC.CORE:BMC_ComputerSystem form using some sample data you are getting from SMS. The logs will reveal where the problem is. I suspect that the model/manufacturer is being looked up in the PCT:ProductCatalog form and, because no value(s) exist for the computers coming from SMS, the tiering is being left null. This assumes you are on CMDB 2.1 or earlier. CMDB 7.5 uses the normalisation engine which you can configure to continue even if the categorisation isn't found. You must also be mapping the dataset value otherwise the import will fail. Cheers Peter Hi list Need a little help I am trying to run a single data exchange for computer system from SMS to CMDB and I have errors during the exchange. The Product Categorization Tiers, Product Name and Manufacturer combination is not valid. The fields I have mapped are the Domain, System Type, Manufacturer, Model, Name, NumberofProcessors, Owner Name and AssetLifeCyclestatus. I'm wandering if it does a reverse lookup on the model and then tries to populate their own tiers. Does anyone know how I can fix this data mapping? What I want is to bring in the Model of the system and do a reverse lookup and have it populate the correct tiers for that model (to BMC.Core:BMC_ComputerSystem) once I get it there I can then bring it into the Asset. Has anyone done this? What is the best way to populate the tiers? JK * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ** This e-mail and its attachments may contain Forest Laboratories, Inc. proprietary information that is privileged, confidential or subject to copyright belonging to Forest Laboratories, Inc. This e-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this e-mail, or the employee or agent responsible for delivering this e-mail to the intended recipient, you are hereby notified that any dissemination, distribution, copying or action taken in relation to the contents of and attachments to this e-mail is strictly prohibited and may be unlawful. If you have received this e-mail in error, please notify the sender immediately and permanently delete the original and any copy of this e-mail and any printout. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: EIE Exchange field mapping
Also, if it's CMDB 2.1 or earlier, you can make the dataset you're importing to a Trusted Dataset. This will automatically build the Product Catalog entries if it doesn't find an existing catalog record. To do this, just create a record in the Trusted Dataset form, adding your dataset. Thomas Worth IT Prophets, LLC -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Peter Romain Sent: Thursday, January 07, 2010 12:57 PM To: arslist@ARSLIST.ORG Subject: Re: EIE Exchange field mapping It would help to know the versions you have installed. Turn on filter logging and try and create an entry manually in the BMC.CORE:BMC_ComputerSystem form using some sample data you are getting from SMS. The logs will reveal where the problem is. I suspect that the model/manufacturer is being looked up in the PCT:ProductCatalog form and, because no value(s) exist for the computers coming from SMS, the tiering is being left null. This assumes you are on CMDB 2.1 or earlier. CMDB 7.5 uses the normalisation engine which you can configure to continue even if the categorisation isn't found. You must also be mapping the dataset value otherwise the import will fail. Cheers Peter Hi list Need a little help I am trying to run a single data exchange for computer system from SMS to CMDB and I have errors during the exchange. The Product Categorization Tiers, Product Name and Manufacturer combination is not valid. The fields I have mapped are the Domain, System Type, Manufacturer, Model, Name, NumberofProcessors, Owner Name and AssetLifeCyclestatus. I'm wandering if it does a reverse lookup on the model and then tries to populate their own tiers. Does anyone know how I can fix this data mapping? What I want is to bring in the Model of the system and do a reverse lookup and have it populate the correct tiers for that model (to BMC.Core:BMC_ComputerSystem) once I get it there I can then bring it into the Asset. Has anyone done this? What is the best way to populate the tiers? JK * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Seeking method to create new People asset (BMC:CORE:BMC_Person) records from existing CTM:People records en masse.
I think this relates to the sandbox mechanism that was introduced in CMDB 7.5. If I remember right, adding a record to CTM:People causes the creation of a person CI directly in the sandbox dataset. A recon job triggers immediately to create the production dataset version. During bulk people entries the recon job is triggered for every entry which causes many to not be created. BMC came out with a fix using a bulk update dataset but I don't have the details available. Maybe BMC support can help? Cheers Peter Good Day, I'm running into an ITSM 7.5 error when manually trying to relate a person to an asset in the Used By role. Supported By,Owned By, Managed By, Created By, Approved By all work properly. ARERR [326] Required field cannot be reset to a NULL value : BMC.CORE:BMC_Dependency : Destination.InstanceId Attribute does not exist. : 490009000 (ARERR 120004) It looks like this is occurring because BMC.CORE:BMC_Person records don't exist for all of our CTM:People records. Certain changes to a CTM:People record cause the people asset to be created, but not reliably under bulk operations (i.e. Modify All or escalation). I'm looking to create ~13K new people/asset (BMC:CORE:BMC_Person) records from existing CTM:People records. What is the best method to do so? Thanks In Advance, John -- View this message in context: http://old.nabble.com/Seeking-method-to-create-new-People-asset-%28BMC%3ACORE%3ABMC_Person%29-records-from-existing-CTM%3APeople-records-en-masse.-tp27063652p27063652.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:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
collection of servers
Hello List, I've been asked if it is possible to create a group of servers (i.e. 50 servers) and assign it a group name (i.e. group A) that could be used in Change Management when relating assets. I already have these servers loaded into my CMDB. The goal is for users to create a change ticket and relate group A to the change ticket. if others wanted to get a list of servers affected by this change, they would need to open the group in the CI Viewer (maybe). Not sure if this makes sense? What would be the best approach to accomplish this? Thanks, Marcelo Martinez ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: collection of servers
Relate them to the same Application Service. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Martinez, Marcelo A Sent: Thursday, January 07, 2010 1:36 PM To: arslist@ARSLIST.ORG Subject: collection of servers Hello List, I've been asked if it is possible to create a group of servers (i.e. 50 servers) and assign it a group name (i.e. group A) that could be used in Change Management when relating assets. I already have these servers loaded into my CMDB. The goal is for users to create a change ticket and relate group A to the change ticket. if others wanted to get a list of servers affected by this change, they would need to open the group in the CI Viewer (maybe). Not sure if this makes sense? What would be the best approach to accomplish this? Thanks, Marcelo Martinez ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: collection of servers
Duh... hit send too quickly. Then all you have to do is relate the Application Service to the CRQ instead of individual servers. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Martinez, Marcelo A Sent: Thursday, January 07, 2010 1:36 PM To: arslist@ARSLIST.ORG Subject: collection of servers Hello List, I've been asked if it is possible to create a group of servers (i.e. 50 servers) and assign it a group name (i.e. group A) that could be used in Change Management when relating assets. I already have these servers loaded into my CMDB. The goal is for users to create a change ticket and relate group A to the change ticket. if others wanted to get a list of servers affected by this change, they would need to open the group in the CI Viewer (maybe). Not sure if this makes sense? What would be the best approach to accomplish this? Thanks, Marcelo Martinez ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: collection of servers
I think you could also use Cluster. Class that stores information about groups of two or more computer systems (clusters) or applications that operate together as a functional whole to increase the performance or resources of the BMC_System component. Use the BMC_Cluster class to classify or update groups of software or hardware to maintain and improve the reliability, serviceability, and availability of your operating-system environment. For example, an accounting department might create a cluster and link it with relationships to specific computer systems to obtain a complete picture of their business environment and assess the performance of computers individually and collectively. To do so, they could use the BMC_Component relationship to connect Computer A, Computer B, and Computer C to a performance measurement CI in the BMC_Cluster class. This class corresponds to the DMTF class CIM_Cluster. Thanks Edward On Thu, Jan 7, 2010 at 12:43 PM, Tommy Morris tommy.mor...@radioshack.comwrote: Duh... hit send too quickly. Then all you have to do is relate the Application Service to the CRQ instead of individual servers. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Martinez, Marcelo A Sent: Thursday, January 07, 2010 1:36 PM To: arslist@ARSLIST.ORG Subject: collection of servers Hello List, I've been asked if it is possible to create a group of servers (i.e. 50 servers) and assign it a group name (i.e. group A) that could be used in Change Management when relating assets. I already have these servers loaded into my CMDB. The goal is for users to create a change ticket and relate group A to the change ticket. if others wanted to get a list of servers affected by this change, they would need to open the group in the CI Viewer (maybe). Not sure if this makes sense? What would be the best approach to accomplish this? Thanks, Marcelo Martinez ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.netsponsor%3armisoluti...@verizon.netARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.netsponsor%3armisoluti...@verizon.netARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: collection of servers
Forgot to mentioned... Our server team has divided our servers into 4 server groups; these groups are used for patching (MS patches, etc). once a month, during a maintenance window, a group of servers will get patched. The group of servers do not necessarily have anything to do with each other, that's why I don't think I should relate them to an application service. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Tommy Morris Sent: Thursday, January 07, 2010 1:42 PM To: arslist@ARSLIST.ORG Subject: Re: collection of servers Relate them to the same Application Service. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Martinez, Marcelo A Sent: Thursday, January 07, 2010 1:36 PM To: arslist@ARSLIST.ORG Subject: collection of servers Hello List, I've been asked if it is possible to create a group of servers (i.e. 50 servers) and assign it a group name (i.e. group A) that could be used in Change Management when relating assets. I already have these servers loaded into my CMDB. The goal is for users to create a change ticket and relate group A to the change ticket. if others wanted to get a list of servers affected by this change, they would need to open the group in the CI Viewer (maybe). Not sure if this makes sense? What would be the best approach to accomplish this? Thanks, Marcelo Martinez ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: EIE Exchange field mapping
CMDB2.1 I added that Trusted Dataset and now when I exchange, it comes over to the BMC.CORE:BMC_ComputerSystem form with NULL values. Now I will try Peters Suggestion. I'll let you know. JK Thomas Worth two...@itprophets.com Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 01/07/2010 01:01 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: EIE Exchange field mapping Also, if it's CMDB 2.1 or earlier, you can make the dataset you're importing to a Trusted Dataset. This will automatically build the Product Catalog entries if it doesn't find an existing catalog record. To do this, just create a record in the Trusted Dataset form, adding your dataset. Thomas Worth IT Prophets, LLC -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Peter Romain Sent: Thursday, January 07, 2010 12:57 PM To: arslist@ARSLIST.ORG Subject: Re: EIE Exchange field mapping It would help to know the versions you have installed. Turn on filter logging and try and create an entry manually in the BMC.CORE:BMC_ComputerSystem form using some sample data you are getting from SMS. The logs will reveal where the problem is. I suspect that the model/manufacturer is being looked up in the PCT:ProductCatalog form and, because no value(s) exist for the computers coming from SMS, the tiering is being left null. This assumes you are on CMDB 2.1 or earlier. CMDB 7.5 uses the normalisation engine which you can configure to continue even if the categorisation isn't found. You must also be mapping the dataset value otherwise the import will fail. Cheers Peter Hi list Need a little help I am trying to run a single data exchange for computer system from SMS to CMDB and I have errors during the exchange. The Product Categorization Tiers, Product Name and Manufacturer combination is not valid. The fields I have mapped are the Domain, System Type, Manufacturer, Model, Name, NumberofProcessors, Owner Name and AssetLifeCyclestatus. I'm wandering if it does a reverse lookup on the model and then tries to populate their own tiers. Does anyone know how I can fix this data mapping? What I want is to bring in the Model of the system and do a reverse lookup and have it populate the correct tiers for that model (to BMC.Core:BMC_ComputerSystem) once I get it there I can then bring it into the Asset. Has anyone done this? What is the best way to populate the tiers? JK * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free.
Re: collection of servers
What if you related them all to a BMC_ConcreteCollection class. That seems generic enough to meet your circumstances. The Cluster class has meaning that's more specific and tailored to different needs, but this class just seems to mean it's a collection of something. Lyle -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Martinez, Marcelo A Sent: Thursday, January 07, 2010 12:53 PM To: arslist@ARSLIST.ORG Subject: Re: collection of servers Forgot to mentioned... Our server team has divided our servers into 4 server groups; these groups are used for patching (MS patches, etc). once a month, during a maintenance window, a group of servers will get patched. The group of servers do not necessarily have anything to do with each other, that's why I don't think I should relate them to an application service. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Tommy Morris Sent: Thursday, January 07, 2010 1:42 PM To: arslist@ARSLIST.ORG Subject: Re: collection of servers Relate them to the same Application Service. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Martinez, Marcelo A Sent: Thursday, January 07, 2010 1:36 PM To: arslist@ARSLIST.ORG Subject: collection of servers Hello List, I've been asked if it is possible to create a group of servers (i.e. 50 servers) and assign it a group name (i.e. group A) that could be used in Change Management when relating assets. I already have these servers loaded into my CMDB. The goal is for users to create a change ticket and relate group A to the change ticket. if others wanted to get a list of servers affected by this change, they would need to open the group in the CI Viewer (maybe). Not sure if this makes sense? What would be the best approach to accomplish this? Thanks, Marcelo Martinez ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: collection of servers
Tell me if this makes sense: Source: Server Group A (Class: BMC_Cluster) Destination: Server1 , Server2, Server3, and so on... (Class: BMC:ComputerSystem) Relationship Type: BMC_MemberOfCollection Or should the relationship type be BMC_Component ??? Thanks all From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of DCI Remedy Sent: Thursday, January 07, 2010 1:52 PM To: arslist@ARSLIST.ORG Subject: Re: collection of servers ** I think you could also use Cluster. Class that stores information about groups of two or more computer systems (clusters) or applications that operate together as a functional whole to increase the performance or resources of the BMC_System component. Use the BMC_Cluster class to classify or update groups of software or hardware to maintain and improve the reliability, serviceability, and availability of your operating-system environment. For example, an accounting department might create a cluster and link it with relationships to specific computer systems to obtain a complete picture of their business environment and assess the performance of computers individually and collectively. To do so, they could use the BMC_Component relationship to connect Computer A, Computer B, and Computer C to a performance measurement CI in the BMC_Cluster class. This class corresponds to the DMTF class CIM_Cluster. Thanks Edward On Thu, Jan 7, 2010 at 12:43 PM, Tommy Morris tommy.mor...@radioshack.commailto:tommy.mor...@radioshack.com wrote: Duh... hit send too quickly. Then all you have to do is relate the Application Service to the CRQ instead of individual servers. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of Martinez, Marcelo A Sent: Thursday, January 07, 2010 1:36 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: collection of servers Hello List, I've been asked if it is possible to create a group of servers (i.e. 50 servers) and assign it a group name (i.e. group A) that could be used in Change Management when relating assets. I already have these servers loaded into my CMDB. The goal is for users to create a change ticket and relate group A to the change ticket. if others wanted to get a list of servers affected by this change, they would need to open the group in the CI Viewer (maybe). Not sure if this makes sense? What would be the best approach to accomplish this? Thanks, Marcelo Martinez ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.orghttp://www.arslist.org/ Platinum Sponsor:rmisoluti...@verizon.netmailto:sponsor%3armisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.orghttp://www.arslist.org/ Platinum Sponsor:rmisoluti...@verizon.netmailto:sponsor%3armisoluti...@verizon.net ARSlist: Where the Answers Are _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: EIE Exchange field mapping
To get the benefit of the trusted dataset you'd need to map the tier 1-3 values to constants in your data exchange. This is what, for example, BMC Configuration Discovery does (all computer systems are Hardware, Processing Unit, Server). You may be able to add all possible computer systems, with appropriate tiering, to the product catalog. The product name/manufacturer combination should then fetch the correct tiering for each computer created. When a new type of computer is discovered the trusted dataset will allow a new product catalog entry to be created automatically and the computer will be saved without error. You could then monitor the product catalog for new entries with the default tiering and deal with these by changing the tier values and updating the computer CIs. Discovery returns only what it finds so you may need to take care of multiple different ways of referring to the same manufacturer (eg MS, Microsoft, Microsoft Inc, etc) and multiple ways of referring to the same computer model. The CMDB normalisation engine uses product and manufacturer aliases to deal with this. The addition of a few filters in CMDB 2.1 would allow you to do the same using the existing manufacture and product alias forms. Cheers Peter _ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of John Kelley Sent: 07 January 2010 19:58 To: arslist@ARSLIST.ORG Subject: Re: EIE Exchange field mapping CMDB2.1 I added that Trusted Dataset and now when I exchange, it comes over to the BMC.CORE:BMC_ComputerSystem form with NULL values. Now I will try Peters Suggestion. I'll let you know. JK Thomas Worth two...@itprophets.com Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 01/07/2010 01:01 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: EIE Exchange field mapping Also, if it's CMDB 2.1 or earlier, you can make the dataset you're importing to a Trusted Dataset. This will automatically build the Product Catalog entries if it doesn't find an existing catalog record. To do this, just create a record in the Trusted Dataset form, adding your dataset. Thomas Worth IT Prophets, LLC -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Peter Romain Sent: Thursday, January 07, 2010 12:57 PM To: arslist@ARSLIST.ORG Subject: Re: EIE Exchange field mapping It would help to know the versions you have installed. Turn on filter logging and try and create an entry manually in the BMC.CORE:BMC_ComputerSystem form using some sample data you are getting from SMS. The logs will reveal where the problem is. I suspect that the model/manufacturer is being looked up in the PCT:ProductCatalog form and, because no value(s) exist for the computers coming from SMS, the tiering is being left null. This assumes you are on CMDB 2.1 or earlier. CMDB 7.5 uses the normalisation engine which you can configure to continue even if the categorisation isn't found. You must also be mapping the dataset value otherwise the import will fail. Cheers Peter Hi list Need a little help I am trying to run a single data exchange for computer system from SMS to CMDB and I have errors during the exchange. The Product Categorization Tiers, Product Name and Manufacturer combination is not valid. The fields I have mapped are the Domain, System Type, Manufacturer, Model, Name, NumberofProcessors, Owner Name and AssetLifeCyclestatus. I'm wandering if it does a reverse lookup on the model and then tries to populate their own tiers. Does anyone know how I can fix this data mapping? What I want is to bring in the Model of the system and do a reverse lookup and have it populate the correct tiers for that model (to BMC.Core:BMC_ComputerSystem) once I get it there I can then bring it into the Asset. Has anyone done this? What is the best way to populate the tiers? JK * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist
Re: DST Issues
Not sure if this is the same thing (we are NOT dealing with Business Time in this scenario), but wanted to see what people were doing in this situation. I have an On Call System that allows the user to create multiple records if they are on call every XX number of days. So if someone were to type in a Start Date of 2/2/2010 12:00:00 AM and an End Date of 2/3/2010 12:00:00 AM and add multiple records every 100 days for 3 times, I get: Start 2/2/2010 12:00:00 AM End 2/3/2010 12:00:00 AM Start 5/13/2010 1:00:00 AM End 5/14/2010 1:00:00 AM Start 8/21/2010 1:00:00 AM End 8/22/2010 1:00:00 AM Start 11/29/2010 12:00:00 AM End 11/30/2010 12:00:00 AM (I'm adding 60 * 60) * 24) * $Day Interval$) * $IntervalCounter$) to the Start Date and End Date) We understand WHY this happens, but wondering what people do about this? Once March 14th rolls around, the times in May and August will still be 1:00:00 AM correct? (the customer wants 12:00:00 AM) I checked the database (hoping that in the DB it was correct and the it was only displaying in the client differently) but the Database is also showing these dates and times. We are thinking about creating a separate table to clarify DST Dates and Times and if a date falls on a certain date and time, subtracting or adding an hour to the Start Date or End Date. UGH! --- David: Have a look at Test3, it appears that the business time 1 subtract function, using a unit of days, has a different result than all other units; it is off by 1 hour. Maybe this is being calculated incorrectly? * Test 3 Business Time Type: Business Time 1 TestID: 202 Start: 3/10/2007 11:00:00 PM End: 3/11/2007 11:00:00 PM Diff Seconds: 86400 Diff Minutes: 1440 Diff Hours: 24 Diff Days: 1 Workday: 24 Hr Tag Holiday: 24 Hr Tag Result of Add to Start (Seconds): 3/11/2007 11:00:00 PM Result of Add to Start (Minutes): 3/11/2007 11:00:00 PM Result of Add to Start (Hours): 3/11/2007 11:00:00 PM Result of Add to Start (Days): 3/11/2007 11:00:00 PM Result of Subtract from End (Seconds): 3/10/2007 11:00:00 PM Result of Subtract from End (Minutes): 3/10/2007 11:00:00 PM Result of Subtract from End (Hours): 3/10/2007 11:00:00 PM Result of Subtract from End (Days): 3/11/2007 12:00:00 AM * DB Values: REQUEST_ID: 202 STARTDATE: 1173585600 ENDDATE: 1173668400 ENDDATE-STARTDATE: 82800 Axton Grams On 3/6/07, Easter, David david_eas...@bmc.com wrote: Business Time is not DST aware. This has been true for quite some time now, and is probably why you're seeing the issue. Basically, Business Time doesn't know that the change from Standard to DST is a 23 hour day nor that from DST to Standard is a 25 hour day. It's unrelated to the changes in DST rules for 2007 - i.e. folks have been dealing with this for years. This is somewhat obliquely mentioned in the tech bulletin: In addition, as happens during any DST event, when DST begins, the day loses one hour (hour interchange of −1). At this date, a full hour is skipped and does not exist either before or after the transition, so this date includes only 23 hours. Workflow that is designed to fire only during that lost hour may not fire properly. However, since this issue occurs during every DST event, we expect that customers that would be affected by this event have already compensated for this issue. This issue is not related to AR System and thus affects all versions of AR System. Due to the raised level of concern on this issue, BMC is looking into adding more intelligence into Business Time in the next release (i.e. 7.1.00) to deal with DST and time zones more gracefully. One may also be able to write some workflow that influences Business Time results to compensate for the lost (or gained) hour during the switch between Standard and Daylight. Thanks, -David J. Easter Sr. Product Manager, Service Management Business Unit BMC Software, Inc. The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Axton Sent: Tuesday, March 06, 2007 4:56 PM To: arslist@ARSLIST.ORG Subject: DST Issues Reposting this because I've seen no replies and wasn't sure if it went into a black hole today when no posts were being sent. I really need a sanity check on this to make sure I'm not out of whack. Axton I am seeing some strange results in my DST testing in regards to business time. Environment: ARServer 7.0.01 patch 001 SunOS 5.9 Generic_118558-26 Mid-Tier 7.0.01 patch 001 IBM WebSphere Application Server/6.0 IBM Java 1.4.2_11 I took 2 dates, a start and end
Re: DST Issues
Wanted to clarify that we are on ARS 7.1 P7 with Windows 2003 and Oracle as our DB. Lisa -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of lisakemes Sent: Thursday, January 07, 2010 4:55 PM To: arslist@ARSLIST.ORG Subject: Re: DST Issues Not sure if this is the same thing (we are NOT dealing with Business Time in this scenario), but wanted to see what people were doing in this situation. I have an On Call System that allows the user to create multiple records if they are on call every XX number of days. So if someone were to type in a Start Date of 2/2/2010 12:00:00 AM and an End Date of 2/3/2010 12:00:00 AM and add multiple records every 100 days for 3 times, I get: Start 2/2/2010 12:00:00 AM End 2/3/2010 12:00:00 AM Start 5/13/2010 1:00:00 AM End 5/14/2010 1:00:00 AM Start 8/21/2010 1:00:00 AM End 8/22/2010 1:00:00 AM Start 11/29/2010 12:00:00 AM End 11/30/2010 12:00:00 AM (I'm adding 60 * 60) * 24) * $Day Interval$) * $IntervalCounter$) to the Start Date and End Date) We understand WHY this happens, but wondering what people do about this? Once March 14th rolls around, the times in May and August will still be 1:00:00 AM correct? (the customer wants 12:00:00 AM) I checked the database (hoping that in the DB it was correct and the it was only displaying in the client differently) but the Database is also showing these dates and times. We are thinking about creating a separate table to clarify DST Dates and Times and if a date falls on a certain date and time, subtracting or adding an hour to the Start Date or End Date. UGH! --- David: Have a look at Test3, it appears that the business time 1 subtract function, using a unit of days, has a different result than all other units; it is off by 1 hour. Maybe this is being calculated incorrectly? * Test 3 Business Time Type: Business Time 1 TestID: 202 Start: 3/10/2007 11:00:00 PM End: 3/11/2007 11:00:00 PM Diff Seconds: 86400 Diff Minutes: 1440 Diff Hours: 24 Diff Days: 1 Workday: 24 Hr Tag Holiday: 24 Hr Tag Result of Add to Start (Seconds): 3/11/2007 11:00:00 PM Result of Add to Start (Minutes): 3/11/2007 11:00:00 PM Result of Add to Start (Hours): 3/11/2007 11:00:00 PM Result of Add to Start (Days): 3/11/2007 11:00:00 PM Result of Subtract from End (Seconds): 3/10/2007 11:00:00 PM Result of Subtract from End (Minutes): 3/10/2007 11:00:00 PM Result of Subtract from End (Hours): 3/10/2007 11:00:00 PM Result of Subtract from End (Days): 3/11/2007 12:00:00 AM * DB Values: REQUEST_ID: 202 STARTDATE: 1173585600 ENDDATE: 1173668400 ENDDATE-STARTDATE: 82800 Axton Grams On 3/6/07, Easter, David david_eas...@bmc.com wrote: Business Time is not DST aware. This has been true for quite some time now, and is probably why you're seeing the issue. Basically, Business Time doesn't know that the change from Standard to DST is a 23 hour day nor that from DST to Standard is a 25 hour day. It's unrelated to the changes in DST rules for 2007 - i.e. folks have been dealing with this for years. This is somewhat obliquely mentioned in the tech bulletin: In addition, as happens during any DST event, when DST begins, the day loses one hour (hour interchange of −1). At this date, a full hour is skipped and does not exist either before or after the transition, so this date includes only 23 hours. Workflow that is designed to fire only during that lost hour may not fire properly. However, since this issue occurs during every DST event, we expect that customers that would be affected by this event have already compensated for this issue. This issue is not related to AR System and thus affects all versions of AR System. Due to the raised level of concern on this issue, BMC is looking into adding more intelligence into Business Time in the next release (i.e. 7.1.00) to deal with DST and time zones more gracefully. One may also be able to write some workflow that influences Business Time results to compensate for the lost (or gained) hour during the switch between Standard and Daylight. Thanks, -David J. Easter Sr. Product Manager, Service Management Business Unit BMC Software, Inc. The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Axton Sent: Tuesday, March 06, 2007 4:56 PM To: arslist@ARSLIST.ORG Subject: DST Issues Reposting this because I've seen no replies and wasn't sure if it went into a black hole today when no posts were being
Re: Seeking method to create new People asset (BMC:CORE:BMC_Person) records from existing CTM:People records en masse.
Hi John Contact BMC Support there is a hotfix for defect SW0332153 which sorts this or you can get hold of the ITSM super hotfix which also sorts it along with a lot of other items. Can't say if it works as have only just got it and not yet applied it. Cheers Robert -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of jc2010 Sent: 07 January 2010 17:22 To: arslist@ARSLIST.ORG Subject: Seeking method to create new People asset (BMC:CORE:BMC_Person) records from existing CTM:People records en masse. Good Day, I'm running into an ITSM 7.5 error when manually trying to relate a person to an asset in the Used By role. Supported By,Owned By, Managed By, Created By, Approved By all work properly. ARERR [326] Required field cannot be reset to a NULL value : BMC.CORE:BMC_Dependency : Destination.InstanceId Attribute does not exist. : 490009000 (ARERR 120004) It looks like this is occurring because BMC.CORE:BMC_Person records don't exist for all of our CTM:People records. Certain changes to a CTM:People record cause the people asset to be created, but not reliably under bulk operations (i.e. Modify All or escalation). I'm looking to create ~13K new people/asset (BMC:CORE:BMC_Person) records from existing CTM:People records. What is the best method to do so? Thanks In Advance, John -- View this message in context: http://old.nabble.com/Seeking-method-to-create-new-People-asset-%28BMC%3ACOR E%3ABMC_Person%29-records-from-existing-CTM%3APeople-records-en-masse.-tp270 63624p27063624.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:rmisoluti...@verizon.net ARSlist: Where the Answers Are No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.432 / Virus Database: 270.14.128/2604 - Release Date: 01/07/10 07:35:00 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Data types are not appropriate for relational operation, 313, error message
** Did you change thelabels on any of your enums? I hit this all the time if I changed something. Example- A filterwas created with a Qualification of Status "Work In Progress". You changedthe enum 7 from "Work In Progress" to "Development in Progress". Now you open a filter that included this qualification and look at the qualification.. Guess what, it still says "Work In Progress". As long as you don't touch the qualificationyou can still save the filter. Once you touch the qualification, even to add another clause, then Developer Studio checks that the qualification is valid.. which it isn't because it didn't properly translate the enum to words. You have to edit the Qualification and say Status 7 which will get it to resolve to Development in Progress and now you can happily save.. This is frustrating.. Is it just me or did Admin Tool do this properly and translate the enum label for you when you opened the Filter for editing Kelly Deaverkdea...@kellydeaver.com (ARSlist mail) Original Message Subject: Re: Data types are not appropriate for relational operation,313, error messageFrom: Kevin Begosh kbeg...@gmail.comDate: Thu, January 07, 2010 11:13 amTo: arslist@ARSLIST.ORG** Sorry I meant to say this before I sent it out. I seems like it is only happening on one of our environments, one developer tool etc... Any reason anyone know why this would be happening. What is wrong with that environment that the developer tool would be mistaking on selection values, I guess more so not recognizing them? Kevin On Thu, Jan 7, 2010 at 12:02 PM, Kevin Begosh kbeg...@gmail.comwrote: List, I am on 7.5 and I noticed that I am getting these error messages quite frequently when working with our of the box selection fields. Has anyone else been getting these. For example I am working with filter RQC:REQ:RequesterInfo_080_SetRequestedBytoRequestedFor and all I want to do is add an additional item to the run if so that does not fire for a specific instance I am setting it to. When I try to save my changes I keep getting that error message Data types are not appropriate for relational operation, 313, It looks like the out of the box code is getting the error message. For instance if you go in that filter and change one of the selection fields to a different value, such as 'UnknownUser' from False to True I get that error message. Is there something querky going on with 7.5, is it something with the server I am on, or the developer tool etc I never got these on the admin tool prior to 7.5 Env: windows 2003 server, AR Server 7.5, ITSM 7.5 -- Kevin Begosh-- Kevin Begosh_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_
Re: Data types are not appropriate for relational operation, 313, error message
Do you have the most recent patch version of Developer Studio? I haven’t run into this particular problem yet, and I have changed labels before, but maybe I just haven’t done this particular scenario yet. I wouldn’t be surprised if it is related to the fact that DS caches objects you’ve opened to disk. I have seen where the cache is out of date or otherwise inaccurate, and that has caused me grief. The fix was to delete the files that DS created in the workspace directory and then reopen the object. I suspect that there are issues around how DS determines whether the cached object is correct/up to date. Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kelly Deaver Sent: Thursday, January 07, 2010 3:33 PM To: arslist@ARSLIST.ORG Subject: Re: Data types are not appropriate for relational operation, 313, error message ** Did you change the labels on any of your enums? I hit this all the time if I changed something. Example - A filter was created with a Qualification of Status Work In Progress. You changed the enum 7 from Work In Progress to Development in Progress. Now you open a filter that included this qualification and look at the qualification.. Guess what, it still says Work In Progress. As long as you don't touch the qualification you can still save the filter. Once you touch the qualification, even to add another clause, then Developer Studio checks that the qualification is valid.. which it isn't because it didn't properly translate the enum to words. You have to edit the Qualification and say Status 7 which will get it to resolve to Development in Progress and now you can happily save.. This is frustrating.. Is it just me or did Admin Tool do this properly and translate the enum label for you when you opened the Filter for editing Kelly Deaver kdea...@kellydeaver.com (ARSlist mail) Original Message Subject: Re: Data types are not appropriate for relational operation, 313, error message From: Kevin Begosh kbeg...@gmail.com Date: Thu, January 07, 2010 11:13 am To: arslist@ARSLIST.ORG ** Sorry I meant to say this before I sent it out. I seems like it is only happening on one of our environments, one developer tool etc... Any reason anyone know why this would be happening. What is wrong with that environment that the developer tool would be mistaking on selection values, I guess more so not recognizing them? Kevin On Thu, Jan 7, 2010 at 12:02 PM, Kevin Begosh kbeg...@gmail.commailto:kbeg...@gmail.com wrote: List, I am on 7.5 and I noticed that I am getting these error messages quite frequently when working with our of the box selection fields. Has anyone else been getting these. For example I am working with filter RQC:REQ:RequesterInfo_080_SetRequestedBytoRequestedFor and all I want to do is add an additional item to the run if so that does not fire for a specific instance I am setting it to. When I try to save my changes I keep getting that error message Data types are not appropriate for relational operation, 313, It looks like the out of the box code is getting the error message. For instance if you go in that filter and change one of the selection fields to a different value, such as 'UnknownUser' from False to True I get that error message. Is there something querky going on with 7.5, is it something with the server I am on, or the developer tool etc I never got these on the admin tool prior to 7.5 Env: windows 2003 server, AR Server 7.5, ITSM 7.5 -- Kevin Begosh -- Kevin Begosh _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message.
Re: Attachment replacement - Filter not firing?!
This is what I do as well. Also works when someone deletes an attachment. I like to capture that action as well. Lisa -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Mark Milke Sent: Thursday, January 07, 2010 3:42 AM To: arslist@ARSLIST.ORG Subject: Re: Attachment replacement - Filter not firing?! Hi Doug, thanks a lot for the explanation and help. You writte: In the filter run if condition, we do not compare file content. What we compare when you compare attachements is file names. Fair enough. I don't really care if the file. I just want to catch is there was a change in terms of replacing the file or attaching a new one. So, if you have file x attached, and you attach a new file x, you will get the DB.attach value matching the attach value because the filename is the same. If the filename was different, the values would not match. For some reason my filter is not firing even when I test 'DB.Attach1' ! = Attach1 and my *file name is diffrent*. But this one: TR.attach != $NULL$ works just fine. Thanks, Mark ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Data types are not appropriate for relational operation, 313, error message
** I just started getting this error and happened to notice this thread. I was definitely fiddling with the enumeration numbers on several fields on a custom form. AR System 7.5 P3, Dev Studio 7.5 P3 on Windows 7 The oddest thing is, I can add any singular clause like "FieldX = 0" A moment later it will resolve that to "FieldX = "Yes". I can save it just fine. However, if I add another clause such as "AND FieldY = 0" It will resolve that and upon save get the error. And yet FieldY = 0, by itself, does not produce the error. In fact, duplicating a clause causes the error as well (FieldX = 0 AND FieldX = 0). So it seems it is merely having 2 or more clauses that causes the problem, not a resolution or caching problem... I've deleted my entire devstudio wkspace folder... I've tried making an entirely new filter, same problem I've tried an entirely new filter on a different form that I haven't modified lately-- same problems. I'll have to start down the restarting things path... Brien On 1/7/2010 3:43 PM, Lyle Taylor wrote: Do you have the most recent patch version of Developer Studio? I haven’t run into this particular problem yet, and I have changed labels before, but maybe I just haven’t done this particular scenario yet. I wouldn’t be surprised if it is related to the fact that DS caches objects you’ve opened to disk. I have seen where the cache is out of date or otherwise inaccurate, and that has caused me grief. The fix was to delete the files that DS created in the workspace directory and then reopen the object. I suspect that there are issues around how DS determines whether the cached object is correct/up to date. Lyle From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kelly Deaver Sent: Thursday, January 07, 2010 3:33 PM To: arslist@ARSLIST.ORG Subject: Re: Data types are not appropriate for relational operation, 313, error message ** Did you change the labels on any of your enums? I hit this all the time if I changed something. Example - A filter was created with a Qualification of Status "Work In Progress". You changed the enum 7 from "Work In Progress" to "Development in Progress". Now you open a filter that included this qualification and look at the qualification.. Guess what, it still says "Work In Progress". As long as you don't touch the qualification you can still save the filter. Once you touch the qualification, even to add another clause, then Developer Studio checks that the qualification is valid.. which it isn't because it didn't properly translate the enum to words. You have to edit the Qualification and say Status 7 which will get it to resolve to Development in Progress and now you can happily save.. This is frustrating.. Is it just me or did Admin Tool do this properly and translate the enum label for you when you opened the Filter for editing Kelly Deaver kdea...@kellydeaver.com (ARSlist mail) Original Message Subject: Re: Data types are not appropriate for relational operation, 313, error message From: Kevin Begosh kbeg...@gmail.com Date: Thu, January 07, 2010 11:13 am To: arslist@ARSLIST.ORG ** Sorry I meant to say this before I sent it out. I seems like it is only happening on one of our environments, one developer tool etc... Any reason anyone know why this would be happening. What is wrong with that environment that the developer tool would be mistaking on selection values, I guess more so not recognizing them? Kevin On Thu, Jan 7, 2010 at 12:02 PM, Kevin Begosh kbeg...@gmail.com wrote: List, I am on 7.5 and I noticed that I am getting these error messages quite frequently when working with our of the box selection fields. Has anyone else been getting these. For example I am working with filter RQC:REQ:RequesterInfo_080_SetRequestedBytoRequestedFor and all I want to do is add an additional item to the run if so that does not fire for a specific instance I am setting it to. When I try to save my changes I keep getting that error message Data types are not appropriate for relational operation, 313, It looks like the out of the box code is getting the error message. For instance if you go in that filter and change one of the selection fields to a different value, such as 'UnknownUser' from False to True I get that error message. Is there something querky going on with 7.5, is it something with the server I am on, or the developer tool etc I never got these on the admin tool prior to 7.5 Env: windows 2003 server,
Re: Data types are not appropriate for relational operation, 313, error message
I’ve seen errors numerous times where DS thought that the value specified in a qualification for an Enumeration was not valid, even when it did like you said and replaced a numerical value with the label itself. I get a different error than what you reported (something along the lines of the value not being valid), but still get an error. I have not found a way to work around it except to use the Admin tool to make the change instead (we’re still on ARS 7.1, so the Admin tool is still an option when necessary). If you or someone figures out how to deal with this, I’d love to know the answer. Lyle From: Brien Dieterle [mailto:brien.diete...@cgcmail.maricopa.edu] Sent: Thursday, January 07, 2010 4:34 PM To: arslist@ARSLIST.ORG Cc: Lyle Taylor Subject: Re: Data types are not appropriate for relational operation, 313, error message I just started getting this error and happened to notice this thread. I was definitely fiddling with the enumeration numbers on several fields on a custom form. AR System 7.5 P3, Dev Studio 7.5 P3 on Windows 7 The oddest thing is, I can add any singular clause like FieldX = 0 A moment later it will resolve that to FieldX = Yes. I can save it just fine. However, if I add another clause such as AND FieldY = 0 It will resolve that and upon save get the error. And yet FieldY = 0, by itself, does not produce the error. In fact, duplicating a clause causes the error as well (FieldX = 0 AND FieldX = 0). So it seems it is merely having 2 or more clauses that causes the problem, not a resolution or caching problem... I've deleted my entire devstudio wkspace folder... I've tried making an entirely new filter, same problem I've tried an entirely new filter on a different form that I haven't modified lately-- same problems. I'll have to start down the restarting things path... Brien On 1/7/2010 3:43 PM, Lyle Taylor wrote: Do you have the most recent patch version of Developer Studio? I haven’t run into this particular problem yet, and I have changed labels before, but maybe I just haven’t done this particular scenario yet. I wouldn’t be surprised if it is related to the fact that DS caches objects you’ve opened to disk. I have seen where the cache is out of date or otherwise inaccurate, and that has caused me grief. The fix was to delete the files that DS created in the workspace directory and then reopen the object. I suspect that there are issues around how DS determines whether the cached object is correct/up to date. Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kelly Deaver Sent: Thursday, January 07, 2010 3:33 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: Data types are not appropriate for relational operation, 313, error message ** Did you change the labels on any of your enums? I hit this all the time if I changed something. Example - A filter was created with a Qualification of Status Work In Progress. You changed the enum 7 from Work In Progress to Development in Progress. Now you open a filter that included this qualification and look at the qualification.. Guess what, it still says Work In Progress. As long as you don't touch the qualification you can still save the filter. Once you touch the qualification, even to add another clause, then Developer Studio checks that the qualification is valid.. which it isn't because it didn't properly translate the enum to words. You have to edit the Qualification and say Status 7 which will get it to resolve to Development in Progress and now you can happily save.. This is frustrating.. Is it just me or did Admin Tool do this properly and translate the enum label for you when you opened the Filter for editing Kelly Deaver kdea...@kellydeaver.commailto:kdea...@kellydeaver.com (ARSlist mail) Original Message Subject: Re: Data types are not appropriate for relational operation, 313, error message From: Kevin Begosh kbeg...@gmail.commailto:kbeg...@gmail.com Date: Thu, January 07, 2010 11:13 am To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG ** Sorry I meant to say this before I sent it out. I seems like it is only happening on one of our environments, one developer tool etc... Any reason anyone know why this would be happening. What is wrong with that environment that the developer tool would be mistaking on selection values, I guess more so not recognizing them? Kevin On Thu, Jan 7, 2010 at 12:02 PM, Kevin Begosh kbeg...@gmail.commailto:kbeg...@gmail.com wrote: List, I am on 7.5 and I noticed that I am getting these error messages quite frequently when working with our of the box selection fields. Has anyone else been getting these. For example I am working with filter RQC:REQ:RequesterInfo_080_SetRequestedBytoRequestedFor and all I want to do is add an additional item to the run if so that does not fire for a specific instance I am setting it to. When I try
Re: Data types are not appropriate for relational operation, 313, error message
Hi, Yes this is a problem with patch 3 of DS. I have found that you need to do 2 things to avoid using the old admin tool for editing some qualifications. 1. Use the button to open up the expression editor. 2. Replace all enums with their numeric equivalent. (Not just the new one.) Failing to do both of these will give you the error message. I currently need to use the admin tool for 2 things in patch 3. 1. Search menus that reference fields on the form hosting the menu 2. Adding new forms to applications. On the bright side patch 3 seems to fix issues I had earlier with table field qualifications. For some reason I have issues adding new fields to set field and push field actions. Quite often they don't take on the first attempt. I love the show relationships feature and now use it all the time to locate workflow to modify. Rod 2010/1/8 Lyle Taylor tayl...@ldschurch.org: I’ve seen errors numerous times where DS thought that the value specified in a qualification for an Enumeration was not valid, even when it did like you said and replaced a numerical value with the label itself. I get a different error than what you reported (something along the lines of the value not being valid), but still get an error. I have not found a way to work around it except to use the Admin tool to make the change instead (we’re still on ARS 7.1, so the Admin tool is still an option when necessary). If you or someone figures out how to deal with this, I’d love to know the answer. Lyle From: Brien Dieterle [mailto:brien.diete...@cgcmail.maricopa.edu] Sent: Thursday, January 07, 2010 4:34 PM To: arslist@ARSLIST.ORG Cc: Lyle Taylor Subject: Re: Data types are not appropriate for relational operation, 313, error message I just started getting this error and happened to notice this thread. I was definitely fiddling with the enumeration numbers on several fields on a custom form. AR System 7.5 P3, Dev Studio 7.5 P3 on Windows 7 The oddest thing is, I can add any singular clause like FieldX = 0 A moment later it will resolve that to FieldX = Yes. I can save it just fine. However, if I add another clause such as AND FieldY = 0 It will resolve that and upon save get the error. And yet FieldY = 0, by itself, does not produce the error. In fact, duplicating a clause causes the error as well (FieldX = 0 AND FieldX = 0). So it seems it is merely having 2 or more clauses that causes the problem, not a resolution or caching problem... I've deleted my entire devstudio wkspace folder... I've tried making an entirely new filter, same problem I've tried an entirely new filter on a different form that I haven't modified lately-- same problems. I'll have to start down the restarting things path... Brien On 1/7/2010 3:43 PM, Lyle Taylor wrote: Do you have the most recent patch version of Developer Studio? I haven’t run into this particular problem yet, and I have changed labels before, but maybe I just haven’t done this particular scenario yet. I wouldn’t be surprised if it is related to the fact that DS caches objects you’ve opened to disk. I have seen where the cache is out of date or otherwise inaccurate, and that has caused me grief. The fix was to delete the files that DS created in the workspace directory and then reopen the object. I suspect that there are issues around how DS determines whether the cached object is correct/up to date. Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kelly Deaver Sent: Thursday, January 07, 2010 3:33 PM To: arslist@ARSLIST.ORG Subject: Re: Data types are not appropriate for relational operation, 313, error message ** Did you change the labels on any of your enums? I hit this all the time if I changed something. Example - A filter was created with a Qualification of Status Work In Progress. You changed the enum 7 from Work In Progress to Development in Progress. Now you open a filter that included this qualification and look at the qualification.. Guess what, it still says Work In Progress. As long as you don't touch the qualification you can still save the filter. Once you touch the qualification, even to add another clause, then Developer Studio checks that the qualification is valid.. which it isn't because it didn't properly translate the enum to words. You have to edit the Qualification and say Status 7 which will get it to resolve to Development in Progress and now you can happily save.. This is frustrating.. Is it just me or did Admin Tool do this properly and translate the enum label for you when you opened the Filter for editing Kelly Deaver kdea...@kellydeaver.com (ARSlist mail) Original Message Subject: Re: Data types are not appropriate for relational operation, 313, error message From: Kevin Begosh kbeg...@gmail.com Date: Thu, January 07, 2010 11:13 am To: arslist@ARSLIST.ORG
Re: Data types are not appropriate for relational operation, 313, error message
** Doing all my qualifications as numbers for enums is how I've gotten around it too! I wish we could use relationships! We tried enabling it and it took the server to its knees and caused so many timeouts that the admin responsible for platform turned it off!! Kelly Deaverkdea...@kellydeaver.com(ARSlist mail) Original Message Subject: Re: Data types are not appropriate for relational operation,313, error messageFrom: Rod Harris r...@smapps.com.auDate: Thu, January 07, 2010 5:57 pmTo: arslist@ARSLIST.ORGHi,Yes this is a problem with patch 3 of DS. I have found that you needto do 2 things to avoid using the old admin tool for editing somequalifications.1. Use the button to open up the _expression_ editor.2. Replace all enums with their numeric equivalent. (Not just the new one.)Failing to do both of these will give you the error message.I currently need to use the admin tool for 2 things in patch 3.1. Search menus that reference fields on the form hosting the menu2. Adding new forms to applications.On the bright side patch 3 seems to fix issues I had earlier withtable field qualifications.For some reason I have issues adding new fields to set field and pushfield actions. Quite often they don't take on the first attempt.I love the "show relationships" feature and now use it all the time tolocate workflow to modify.Rod2010/1/8 Lyle Taylor tayl...@ldschurch.org: I’ve seen errors numerous times where DS thought that the value specified in a qualification for an Enumeration was not valid, even when it did like you said and replaced a numerical value with the label itself. I get a different error than what you reported (something along the lines of the value not being valid), but still get an error. I have not found a way to work around it except to use the Admin tool to make the change instead (we’re still on ARS 7.1, so the Admin tool is still an option when necessary). If you or someone figures out how to deal with this, I’d love to know the answer. Lyle From: Brien Dieterle [mailto:brien.dieterle@cgcmail.maricopa.edu] Sent: Thursday, January 07, 2010 4:34 PM To: arslist@ARSLIST.ORG Cc: Lyle Taylor Subject: Re: Data types are not appropriate for relational operation, 313, error message I just started getting this error and happened to notice this thread. I was definitely fiddling with the enumeration numbers on several fields on a custom form. AR System 7.5 P3, Dev Studio 7.5 P3 on Windows 7 The oddest thing is, I can add any singular clause like "FieldX = 0" A moment later it will resolve that to "FieldX = "Yes". I can save it just fine. However, if I add another clause such as "AND FieldY = 0" It will resolve that and upon save get the error. And yet FieldY = 0, by itself, does not produce the error. In fact, duplicating a clause causes the error as well (FieldX = 0 AND FieldX = 0). So it seems it is merely having 2 or more clauses that causes the problem, not a resolution or caching problem... I've deleted my entire devstudio wkspace folder... I've tried making an entirely new filter, same problem I've tried an entirely new filter on a different form that I haven't modified lately-- same problems. I'll have to start down the restarting things path... Brien On 1/7/2010 3:43 PM, Lyle Taylor wrote: Do you have the most recent patch version of Developer Studio? I haven’t run into this particular problem yet, and I have changed labels before, but maybe I just haven’t done this particular scenario yet. I wouldn’t be surprised if it is related to the fact that DS caches objects you’ve opened to disk. I have seen where the cache is out of date or otherwise inaccurate, and that has caused me grief. The fix was to delete the files that DS created in the workspace directory and then reopen the object. I suspect that there are issues around how DS determines whether the cached object is correct/up to date. Lyle From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kelly Deaver Sent: Thursday, January 07, 2010 3:33 PM To: arslist@ARSLIST.ORG Subject: Re: Data types are not appropriate for relational operation, 313, error message ** Did you change thelabels on any of your enums? I hit this all the time if I changed something. Example- A filterwas created with a Qualification of Status "Work In Progress". You changedthe enum 7 from "Work In Progress" to "Development in Progress". Now you open a filter that included this qualification and look at the qualification.. Guess what, it still says "Work In Progress". As long as you don't touch the qualificationyou can still save the filter. Once you touch the qualification, even to add another clause, then Developer Studio checks that the qualification is valid.. which it isn't because it didn't properly translate the enum to words. You have to edit the Qualification and say Status 7 which will get it to resolve to Development in Progress and now you can happily save.. This is frustrating.. Is it just me or did
Re: Data types are not appropriate for relational operation, 313, error message
Ok, so I am not crazy. I was trying to add a form to an application yesterday it it just wouldn't take. I agree patch 3 is getting there. The adding new fields to set/push fields not taking the first time is gets old fast. I am afraid to do the initial load of building the relationships. But in general I LOVE the Dev Studio. 3 Jason On Thu, Jan 7, 2010 at 3:57 PM, Rod Harris r...@smapps.com.au wrote: Hi, Yes this is a problem with patch 3 of DS. I have found that you need to do 2 things to avoid using the old admin tool for editing some qualifications. 1. Use the button to open up the expression editor. 2. Replace all enums with their numeric equivalent. (Not just the new one.) Failing to do both of these will give you the error message. I currently need to use the admin tool for 2 things in patch 3. 1. Search menus that reference fields on the form hosting the menu 2. Adding new forms to applications. On the bright side patch 3 seems to fix issues I had earlier with table field qualifications. For some reason I have issues adding new fields to set field and push field actions. Quite often they don't take on the first attempt. I love the show relationships feature and now use it all the time to locate workflow to modify. Rod 2010/1/8 Lyle Taylor tayl...@ldschurch.org: I’ve seen errors numerous times where DS thought that the value specified in a qualification for an Enumeration was not valid, even when it did like you said and replaced a numerical value with the label itself. I get a different error than what you reported (something along the lines of the value not being valid), but still get an error. I have not found a way to work around it except to use the Admin tool to make the change instead (we’re still on ARS 7.1, so the Admin tool is still an option when necessary). If you or someone figures out how to deal with this, I’d love to know the answer. Lyle From: Brien Dieterle [mailto:brien.diete...@cgcmail.maricopa.edu] Sent: Thursday, January 07, 2010 4:34 PM To: arslist@ARSLIST.ORG Cc: Lyle Taylor Subject: Re: Data types are not appropriate for relational operation, 313, error message I just started getting this error and happened to notice this thread. I was definitely fiddling with the enumeration numbers on several fields on a custom form. AR System 7.5 P3, Dev Studio 7.5 P3 on Windows 7 The oddest thing is, I can add any singular clause like FieldX = 0 A moment later it will resolve that to FieldX = Yes. I can save it just fine. However, if I add another clause such as AND FieldY = 0 It will resolve that and upon save get the error. And yet FieldY = 0, by itself, does not produce the error. In fact, duplicating a clause causes the error as well (FieldX = 0 AND FieldX = 0). So it seems it is merely having 2 or more clauses that causes the problem, not a resolution or caching problem... I've deleted my entire devstudio wkspace folder... I've tried making an entirely new filter, same problem I've tried an entirely new filter on a different form that I haven't modified lately-- same problems. I'll have to start down the restarting things path... Brien On 1/7/2010 3:43 PM, Lyle Taylor wrote: Do you have the most recent patch version of Developer Studio? I haven’t run into this particular problem yet, and I have changed labels before, but maybe I just haven’t done this particular scenario yet. I wouldn’t be surprised if it is related to the fact that DS caches objects you’ve opened to disk. I have seen where the cache is out of date or otherwise inaccurate, and that has caused me grief. The fix was to delete the files that DS created in the workspace directory and then reopen the object. I suspect that there are issues around how DS determines whether the cached object is correct/up to date. Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kelly Deaver Sent: Thursday, January 07, 2010 3:33 PM To: arslist@ARSLIST.ORG Subject: Re: Data types are not appropriate for relational operation, 313, error message ** Did you change the labels on any of your enums? I hit this all the time if I changed something. Example - A filter was created with a Qualification of Status Work In Progress. You changed the enum 7 from Work In Progress to Development in Progress. Now you open a filter that included this qualification and look at the qualification.. Guess what, it still says Work In Progress. As long as you don't touch the qualification you can still save the filter. Once you touch the qualification, even to add another clause, then Developer Studio checks that the qualification is valid.. which it isn't because it didn't properly translate the enum to words. You have to edit the Qualification and
Custom application upgrade ARS 4.3 to 7.5 on AIX
Hi folks, Our client is planning to upgrade a custom application from 4. 3 to 7.5 on AIX platform with Oracle database. If we export the def files from v 4.3 and import them into 7.5 can we view the application as is in the newer version ? Will all the workflow work as it used to work ? or Is there a need to rebuild the whole application in the new version? Did you implement this before on any other platform other than AIX ? If yes, did you face any potential issues ? this might sound pretty silly question but haven't done this before. Appreciate your response. RD -- View this message in context: http://old.nabble.com/Custom-application-upgrade-ARS-4.3-to-7.5-on-AIX-tp27070839p27070839.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:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Custom application upgrade ARS 4.3 to 7.5 on AIX
Some things are going to cause you problems. In the old versions you could have core fields on display only forms. In later versions you can not. There are probably a few other things that could cause you problems too, but I don't remember anything else. On Thu, Jan 7, 2010 at 9:16 PM, remedydon mrohinikanth2...@gmail.comwrote: Hi folks, Our client is planning to upgrade a custom application from 4. 3 to 7.5 on AIX platform with Oracle database. If we export the def files from v 4.3 and import them into 7.5 can we view the application as is in the newer version ? Will all the workflow work as it used to work ? or Is there a need to rebuild the whole application in the new version? Did you implement this before on any other platform other than AIX ? If yes, did you face any potential issues ? this might sound pretty silly question but haven't done this before. Appreciate your response. RD -- View this message in context: http://old.nabble.com/Custom-application-upgrade-ARS-4.3-to-7.5-on-AIX-tp27070839p27070839.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:rmisoluti...@verizon.netsponsor%3armisoluti...@verizon.netARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Runmacro issue
Hi Hugo, Can I have the details related to the unix shell, how you are running the mocro ? I am quite doubtful as remedy doesn;t support the unix client ? Cheers, Mahendra Mahalkar On Jan 7, 12:52 am, Hyunkel v2.0 lord_dyna...@hotmail.com wrote: I'm trying to generate a macro to create a new record on an specific form, I'm performing this via Unix shell, I'm seeing the runmacro process being triggered by the script and no error code is returned, but I'm not seeing any record created on the ARS side... This is what I have on my macro push Set-schema: HR_FIT_MACRO delldevopas Submit: HR_FIT_MACRO delldevopas| 8=Default submit value 7=0 4=Hugo Ruesga 2=Hugo Ruesga end It's very simple, but i don't have any idea why the record is not being created. Any help will be greatly appreciated. Hugo Ruesga perotsystems® US972.577.7000972.577.7000 MX +52 (33) 3332.3868+52 (33) 3332.3868 P Please consider the environment before printing this email The information contained in and transferred with this electronic message is intended only for the recipient(s) designated above, it is protected by law and it may contain information which is privileged and confidential. If you are not the intended recipient, please do not read, copy, or use it, and do not disclose it to others. Please notify the sender of the delivery error by replying to this message, and then delete it from your system. Thank you. _ Juega y gana con Samsung y Windows Livehttp://www.equipatucasa.com.mx ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Upgrade to 7.5, is it possible without any errors?
Hi, I've done a few upgrades from 6.3 and 7.01 to 7.5. And none of them installes without any errors - bin/arsystem (Unix startup file) contains errors, upgrade failes when the installer restart the server - armonitor.conf/armonitor.cfg does not get created - database upgrade in 3 tablss failes due to illegal operation (Oracle) - addinng unique index on form AR System User Cental File failes - serveradmin form does not contain any information - Approval/Assignment-engine failes to install if the server does not run when starting the installation-program - Upgrade fails if you do not have a admin user named Demo - tnsnames.ora need to have an SID entry containing the ip-adress, with domain name is failes. All the upgrades has been done against servers installed prior to version 6.3. Upgrading servers which where original installed as 6.3 or 7.01 does not fail. Opening a ticket with support did not give any value to the issues. After 5-6 weeks, we fixed most of the issues (need to do a lot manual work during the installation), and the response from support was; Can I close the ticket now? They was not not intressting in how the issues was solved. This answer ended up in my worst satisfaction survey ever! Looking forward to the CMDB upgrade Regards, Jarl ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Customising the CI viewer .
Hello to everyone, The CI viewer/mid-tier does not pick up changes in the config.xml in the Data Visualisation Definition form. I am trying to customise the context menu in the CI viewer so that it opens up the AST form instead of the BMC.CORE form. I would rather not create a federated interface/link for each CI as we are using too many classes and it is not. For example a simple change like removing the View menu option in the config.xml file and restarting the mid-tier does not work. Is there an embedded definition that the mid-tier reads from? Could this be a local issue... The file contains everything in English whereas the menu is still showing in French? Am I missing something or is this a bug? Kind Regards frex Asset Management: 7.0.3 patch 008 CMDB: 2.1.00 patch 003 ___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
CMDB 7.6 upgrade, group install failes....
Hi, Upgrading CMDB from version 2.01 to 7.6 on a 7.5 server. When the CMDB installer wants to install a set of groups this error occour: Failure during SQL operation to the database -- ORA-00904: C9: invalid identifier ( 552 ) I see this happend because there is no C9 column in the Group table. The C9 column resides in the T2C9 table, as a LONG column This gonna be a long day :-) Regards, Jarl ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are