Join forms in ITSM
Hi, I have created some outer join forms in an 'add-on module' besides ITSM. I have used AST:BusinessService and AST:AssetPeople And AST:BusinessService and FIN:CostAssociationJoin The meaning is to make a report for Business Services and Relations, and Business Services with/without costs. Seems to works fine, but would it have been more correct if I had used BMC.CORE:BMC_BaseElement instead of AST:BusinessService? The number of entries returned when searching is the same if I use DataSetID BMC.ASSET in BMC.CORE:BMC_BaseElement Best regards, Lars, Vattenfall Sweden ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Poor Web service peformance on Remedy join forms
Hello everyone: I was wondering if anyone else has experienced this. Environment: Red Hat Linux 6.4 Mid Tier 8.1.01 SP1 20140514135 Hotfix Apache Tomcat 6.0 Remedy Server 8.1.01 201401281910 Oracle Database When consuming web services that are based on join forms in Remedy, we have experienced a significant performance degradation in response time. For example, to query 2000 rows in the base form with a web service against the base form, 3 seconds. If we create a self-join and do the same web service .. approx 17 seconds. Has anyone else seen this? Thanks. Terry ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Poor Web service peformance on Remedy join forms
For further information: Remedy User Tool against the join form: 1 second MidTier direct access against the join form: 5 seconds So, it is not a join-form or indexing issue. Terry On 2015-01-06 12:12, tboot...@objectpath.com wrote: Hello everyone: I was wondering if anyone else has experienced this. Environment: Red Hat Linux 6.4 Mid Tier 8.1.01 SP1 20140514135 Hotfix Apache Tomcat 6.0 Remedy Server 8.1.01 201401281910 Oracle Database When consuming web services that are based on join forms in Remedy, we have experienced a significant performance degradation in response time. For example, to query 2000 rows in the base form with a web service against the base form, 3 seconds. If we create a self-join and do the same web service .. approx 17 seconds. Has anyone else seen this? Thanks. Terry ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Poor Web service peformance on Remedy join forms
Hi :) I guess you could log and compare and check where the time is consumed when using the WS. If API + SQL calls are the same, then it’s « elsewhere ». Le 6 janv. 2015 à 18:15, Terry Bootsma tboot...@objectpath.com a écrit : ** For further information: Remedy User Tool against the join form: 1 second MidTier direct access against the join form: 5 seconds So, it is not a join-form or indexing issue. Terry On 2015-01-06 12:12, tboot...@objectpath.com wrote: Hello everyone: I was wondering if anyone else has experienced this. Environment: Red Hat Linux 6.4 Mid Tier 8.1.01 SP1 20140514135 Hotfix Apache Tomcat 6.0 Remedy Server 8.1.01 201401281910 Oracle Database When consuming web services that are based on join forms in Remedy, we have experienced a significant performance degradation in response time. For example, to query 2000 rows in the base form with a web service against the base form, 3 seconds. If we create a self-join and do the same web service .. approx 17 seconds. Has anyone else seen this? Thanks. Terry _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Poor Web service peformance on Remedy join forms
Terry, Do you experience similar delay when pulling the same 2000 records directly from the user/web tool, or only when done through web services? Are the fields used in the qualification of the join indexed properly? On Tue, Jan 6, 2015 at 10:12 AM, Terry Bootsma tboot...@objectpath.com wrote: ** Hello everyone: I was wondering if anyone else has experienced this. Environment: Red Hat Linux 6.4 Mid Tier 8.1.01 SP1 20140514135 Hotfix Apache Tomcat 6.0 Remedy Server 8.1.01 201401281910 Oracle Database When consuming web services that are based on join forms in Remedy, we have experienced a significant performance degradation in response time. For example, to query 2000 rows in the base form with a web service against the base form, 3 seconds. If we create a self-join and do the same web service .. approx 17 seconds. Has anyone else seen this? Thanks. Terry _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Poor Web service peformance on Remedy join forms
Okso, have you turned on API/SQL/Filter logging into a single file and isolated the transaction to determine where the time is going? On Tue, Jan 6, 2015 at 10:15 AM, Terry Bootsma tboot...@objectpath.com wrote: ** For further information: Remedy User Tool against the join form: 1 second MidTier direct access against the join form: 5 seconds So, it is not a join-form or indexing issue. Terry On 2015-01-06 12:12, tboot...@objectpath.com wrote: Hello everyone: I was wondering if anyone else has experienced this. Environment: Red Hat Linux 6.4 Mid Tier 8.1.01 SP1 20140514135 Hotfix Apache Tomcat 6.0 Remedy Server 8.1.01 201401281910 Oracle Database When consuming web services that are based on join forms in Remedy, we have experienced a significant performance degradation in response time. For example, to query 2000 rows in the base form with a web service against the base form, 3 seconds. If we create a self-join and do the same web service .. approx 17 seconds. Has anyone else seen this? Thanks. Terry _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Poor Web service peformance on Remedy join forms
This is definitely something in how the mid-tier handles web services against the join form. I was hoping that I couldn't be the only one that has experienced this and was hoping someone might chime in with a golden egg. ;-) Terry On 2015-01-06 12:17, laurent matheo wrote: ** Hi :) I guess you could log and compare and check where the time is consumed when using the WS. If API + SQL calls are the same, then it's « elsewhere ». Le 6 janv. 2015 à 18:15, Terry Bootsma tboot...@objectpath.com a écrit : ** For further information: Remedy User Tool against the join form: 1 second MidTier direct access against the join form: 5 seconds So, it is not a join-form or indexing issue. Terry On 2015-01-06 12:12, tboot...@objectpath.com wrote: Hello everyone: I was wondering if anyone else has experienced this. Environment: Red Hat Linux 6.4 Mid Tier 8.1.01 SP1 20140514135 Hotfix Apache Tomcat 6.0 Remedy Server 8.1.01 201401281910 Oracle Database When consuming web services that are based on join forms in Remedy, we have experienced a significant performance degradation in response time. For example, to query 2000 rows in the base form with a web service against the base form, 3 seconds. If we create a self-join and do the same web service .. approx 17 seconds. Has anyone else seen this? Thanks. Terry _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Multiple level join forms
We have a custom application that has a TEN layers deep join form. Something like Company::YYY:Form1-Form2-Form3-Form4-Form5-Form6-Form7-Form8-Form9-Form10_join. BMC documentation (for 7.5) says that six is the practical limit for join levels. There are a large number of rows in this form, and the form is about average size (80~ columns). I didn't build it, but I'm trying to get the people who did to understand why this is a bad idea, beyond It's a performance impacting design. Can someone share their experiences with what happens beyond the BMC-specified event horizon? I'm guessing that the searches increase exponentially (or at least logarithmically) in time as the complexity increases. The two base forms are pretty well-indexed - about six each, I think. Rick Cook ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Multiple level join forms
I'd work with the DBAs to run sql profiler or something while running queries against that table so they could make the argument for you with actual statistics rather than hypotheticals. Thanks, Shawn Pierson Remedy Developer | Energy Transfer From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Cook Sent: Friday, January 03, 2014 11:58 AM To: arslist@ARSLIST.ORG Subject: Multiple level join forms ** We have a custom application that has a TEN layers deep join form. Something like Company::YYY:Form1-Form2-Form3-Form4-Form5-Form6-Form7-Form8-Form9-Form10_join. BMC documentation (for 7.5) says that six is the practical limit for join levels. There are a large number of rows in this form, and the form is about average size (80~ columns). I didn't build it, but I'm trying to get the people who did to understand why this is a bad idea, beyond It's a performance impacting design. Can someone share their experiences with what happens beyond the BMC-specified event horizon? I'm guessing that the searches increase exponentially (or at least logarithmically) in time as the complexity increases. The two base forms are pretty well-indexed - about six each, I think. Rick Cook _ARSlist: Where the Answers Are and have been for 20 years_ Private and confidential as detailed here: http://www.energytransfer.com/mail_disclaimer.aspx . If you cannot access the link, please e-mail sender. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Multiple level join forms
When ARS performs data interaction with a Join form, it simply issues the appropriate SQL against the SQL View it created to represent the Join (named Tschema id of the join). In situations like yours, that SQL View itself references other SQL Views representing the lower level joins, and so on. So, what's really happening is that the DB optimizer must string all this stuff together and compile the result before execution. Fortunately, this process is O(N), where N is the total number of joins, so itself is not very bad at all. The resulting SQL is similar to what you might create yourself if you had to write the SQL to join all those forms (tables) together, though perhaps not as well optimized as it could be. Obviously, the more tables involved in a query, the more complex it is and the longer it takes the database to compute. However, if this level of complexity is what is needed to get the result you need, then it's what you need. So, the point of all this is that all the complexity of pulling data from such a Join is completely managed by the database itself, and not by ARS (if you're pushing data into this thing...ugh...that's a different story). I'm not sure why BMC mentions that practical limit, though I would suspect it has to do with the amount of work YOU have to do to maintain all those Joins (more on this below). I agree with Shawn, though: if you're concerned it's well worth your time to understand the execution path being used by your queries to this thing, and whether or not your indexes are being used correctly. I've long since moved away from using ARS Join forms, and instead exclusively use (and recommend) manually created SQL View on top of which I create ARS View forms. One immediate advantage for this particular example is that instead of dealing with 9 ARS Join forms (for your 10 base forms), you only need to deal with one View type form. Another advantage is that you can structure the SQL to make maximum use of available indexes (in Oracle, for example, you absolutely CAN include HINTs in the SQL definition of the view to direct the optimizer to appropriately leverage the available indexes). A third advantage is the reduced maintenance. For example, let me assume that in your example you first joined Form1 to Form 2, then joined that to Form 3, and so on. Now, with the ARS Join based solution, if you want to add a field from Form 1 you have to separately modify each of the 9 Joins (this may be why BMC suggests that practical limit of 6). With the SQL View-Remedy View solution, you first modify the SQL view (to include the column), then modify the ARS View form to add the field on top of the column. A fourth advantage is the ability to insert computed columns. For example, ARS Table fields of course only allow you to select one Selection type field on which to base row coloring. However, it may be the case that the coloring scheme you wish to apply is more complex, and is based on factors from some combination of fields (or even from foreign fields). If so, your only pure ARS based solution is to create a real (i.e. Optional or Required) Selection field, and maintain its value through workflow. This can get VERY complicated. In the SQL View/ARS View, the solution is very simple: just create a CASE statement in the SQL View and in the ARS View, create a Selection field on top of it. In this paradigm, the ColorStatus (which is what I always call the column field) can be arbitrarily complex, yet simple to implement and maintain. Of course, one trade off is that this type of solution is a bit more obscure than the Join based solution (because the SQL View is not visible from within Dev Studio). It also of course requires SQL knowledge, though personally I feel this is an essential skill in Remedy application development. And finally, it requires some understanding of of the ARS data dictionary (at least enough to know how to identify and interact with the SQL Views ARS creates for such use (NOT the T/B/SH tables and views, but the views it creates using your form and field names). But I've been doing this now for many years and find this solution far more manageable. Anyway, my 2 cents. Hope something in here helps. -charlie On Fri, Jan 3, 2014 at 11:30 AM, Pierson, Shawn shawn.pier...@energytransfer.com wrote: ** I’d work with the DBAs to run sql profiler or something while running queries against that table so they could make the argument for you with actual statistics rather than hypotheticals. Thanks, *Shawn Pierson * Remedy Developer | Energy Transfer *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Rick Cook *Sent:* Friday, January 03, 2014 11:58 AM *To:* arslist@ARSLIST.ORG *Subject:* Multiple level join forms ** We have a custom application that has a TEN layers deep join form. Something like Company::YYY:Form1-Form2-Form3-Form4-Form5-Form6-Form7-Form8-Form9
Re: Join Forms in ITSM 76 Apps
I believe all of the Applications in ITSM 7.6 sp2 and later expect you to be using overlays. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Frank Caruso Sent: Tuesday, August 28, 2012 10:10 AM To: arslist@ARSLIST.ORG Subject: Re: Join Forms in ITSM 76 Apps Does anybody have a solution for this issue? Thank you -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Frank Caruso Sent: Monday, August 20, 2012 7:00 AM To: arslist@ARSLIST.ORG Subject: Join Forms in ITSM 76 Apps ITSM 7.6 sp2 ARS 7.6sp2 Want to create a join form between two classes. One class is BMC:PhysicalLocation and the other is a custom class. I can create the join form using the developer tool but none of the underlying forms permissions (roles) are carried forward, not even Public. I tried adding my join form directly to the Asset Management application but that was not allowed. I then tried creating the join form from the Asset Management Application but it said I had to Overlay the object first, which is not possible unless you change your development mode and that does not sound like something I want to do. How does one easily create join forms against classes that carry forward underlying permissions? Thank you Frank ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Join Forms in ITSM 76 Apps
Frank - What is the Question? On Tue, Aug 28, 2012 at 11:10 AM, Frank Caruso caruso.fr...@gmail.comwrote: Does anybody have a solution for this issue? Thank you ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Join Forms in ITSM 76 Apps
Does anybody have a solution for this issue? Thank you ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Join Forms in ITSM 76 Apps
ITSM 7.6 sp2 ARS 7.6sp2 Want to create a join form between two classes. One class is BMC:PhysicalLocation and the other is a custom class. I can create the join form using the developer tool but none of the underlying forms permissions (roles) are carried forward, not even Public. I tried adding my join form directly to the Asset Management application but that was not allowed. I then tried creating the join form from the Asset Management Application but it said I had to Overlay the object first, which is not possible unless you change your development mode and that does not sound like something I want to do. How does one easily create join forms against classes that carry forward underlying permissions? Thank you Frank ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Join Forms and Outer Joins
If I have a join form with an outer join, doesn't that mean that the join form should have all records from Form A and Form B? I have a join form that is joined by 2 fields (no other query or anything) and when I swap the forms for Form A to be primary I get different results than when I choose Form B to be a primary. Is it because I'm joining the forms using 2 fields instead of one? Or maybe it's always been that way, and I just need a vacation. Lisa Kemes AR System Developer TEIS - USA +1 717 810 2408 tel +1 717 602 9460 mobile lisa.ke...@te.commailto:lisa.ke...@te.com 100 Amp Drive Harrisburg, PA 17112 [http://www.te.com/images/socialmedia/smallTElogo.gif]http://www.te.com/ www.te.comhttp://www.te.com/ [http://www.te.com/images/socialmedia/twitter.png]http://twitter.com/teconnectivity [http://www.te.com/images/socialmedia/facebook.png] http://www.facebook.com/teconnectivity [http://www.te.com/images/socialmedia/flickr.png] http://www.flickr.com/photos/teconnectivity/ [http://www.te.com/images/socialmedia/linkedin.png] http://www.linkedin.com/groups?gid=1591657 [http://www.te.com/images/socialmedia/youtube.png] http://www.youtube.com/teconnectivity ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Join Forms and Outer Joins
Lisa, A Left Outer join gives you all records from Left, and only those from Right that match the join criteria. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa Sent: Thursday, October 27, 2011 12:04 PM To: arslist@ARSLIST.ORG Subject: Join Forms and Outer Joins ** If I have a join form with an outer join, doesn't that mean that the join form should have all records from Form A and Form B? I have a join form that is joined by 2 fields (no other query or anything) and when I swap the forms for Form A to be primary I get different results than when I choose Form B to be a primary. Is it because I'm joining the forms using 2 fields instead of one? Or maybe it's always been that way, and I just need a vacation. Lisa Kemes AR System Developer TEIS - USA +1 717 810 2408 tel +1 717 602 9460 mobile lisa.ke...@te.com 100 Amp Drive Harrisburg, PA 17112 http://www.te.com/ www.te.com http://www.te.com/ http://twitter.com/teconnectivity http://www.facebook.com/teconnectivity http://www.flickr.com/photos/teconnectivity/ http://www.linkedin.com/groups?gid=1591657 http://www.youtube.com/teconnectivity _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ~WRD000.jpg
Re: Join Forms and Outer Joins
Got it, so the Primary form (on my Join Form) will be the one with all the records on the join form. Weird, I never noticed that. Thanks! Lisa From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: Thursday, October 27, 2011 2:37 PM To: arslist@ARSLIST.ORG Subject: Re: Join Forms and Outer Joins ** Lisa, A Left Outer join gives you all records from Left, and only those from Right that match the join criteria. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa Sent: Thursday, October 27, 2011 12:04 PM To: arslist@ARSLIST.ORG Subject: Join Forms and Outer Joins ** If I have a join form with an outer join, doesn't that mean that the join form should have all records from Form A and Form B? I have a join form that is joined by 2 fields (no other query or anything) and when I swap the forms for Form A to be primary I get different results than when I choose Form B to be a primary. Is it because I'm joining the forms using 2 fields instead of one? Or maybe it's always been that way, and I just need a vacation. Lisa Kemes AR System Developer TEIS - USA +1 717 810 2408 tel +1 717 602 9460 mobile lisa.ke...@te.commailto:lisa.ke...@te.com 100 Amp Drive Harrisburg, PA 17112 [cid:308331119@27102011-2242]http://www.te.com/ www.te.comhttp://www.te.com/ [cid:308331119@27102011-2242]http://twitter.com/teconnectivity[cid:308331119@27102011-2242]http://www.facebook.com/teconnectivity[cid:308331119@27102011-2242]http://www.flickr.com/photos/teconnectivity/[cid:308331119@27102011-2242]http://www.linkedin.com/groups?gid=1591657[cid:308331119@27102011-2242]http://www.youtube.com/teconnectivity _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are inline: ~WRD000.jpg
Service filter and join forms, performance...
Hi, Created a service filter on a join form. When accessing the service(from another form and filter) I see in the SQL logs that the service does a query against the join form with no where clause. The service filter does what it is told to do, but the query happend at the end of the service filter. With 700 000 + records in the join form it takes a while... AR Server 7.5 p4 Oracle 10 Regards, Jarl ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Importing Join Forms with Dev Studio7.5p3
Has anyone else had issues with importing join form objects into Remedy 7.5p3 with Developer Studio 7.5p3? We are having all sorts of issues (form corruption, form not found errors, reporting errors) with imported join forms on this version. Importing these objects with the old Admin Tool seems to work just fine. AR 7.5p3 ITSM 7.6 CMDB 7.6p1 Tommy Morris ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Join Forms
The BMC Documentation says For optimal performance, use indexed fields in the join criteria. If I use a qualification for the Join Criteria of ( 'Survey Number' = $Survey Number$) AND ( 'Network ID' = $Network ID$) AND ( 'TEIS Request ID' = $Request ID$), for optimal performance should each of these fields be indexed on each form? Or would it be OK for just one of these fields on each form? 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 attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Join Forms
It depends on your data. If you don't have too much data, then you can just index one field (note that the request ID - field 1 - is always indexed by default). If you have a lot of data, then it can be beneficial to index more fields. Basically, the way it works is that if you have one field indexed, it will search based on that index, and then scan all the results to find items that match the rest of the qualification. If you have more fields indexed, then it can go more directly to the item you're searching for, which is more efficient. Note that for this to be effective, you need a single index that includes all the fields rather than having a separate index on each of the fields. Otherwise, the database will simply choose one of the indexes (whichever one it thinks will be most efficient) and use that, ignoring the others. Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kemes, Lisa Sent: Tuesday, April 13, 2010 2:09 PM To: arslist@ARSLIST.ORG Subject: Join Forms ** The BMC Documentation says For optimal performance, use indexed fields in the join criteria. If I use a qualification for the Join Criteria of ( 'Survey Number' = $Survey Number$) AND ( 'Network ID' = $Network ID$) AND ( 'TEIS Request ID' = $Request ID$), for optimal performance should each of these fields be indexed on each form? Or would it be OK for just one of these fields on each form? Lisa Kemes AR System Developer Tyco Electronics 717-810-2408 tel 717-810-2124 fax lisa.ke...@tycoelectronics.com _attend WWRUG10 www.wwrug.com 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 attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Join Forms
Lisa, The fields that represent values ($ fields) in the join criteria are the ones that need to be indexed, providing they qualify. You cannot really index a character field that is 255 characters in length or above.. Character fields that are indexed need to be of length 254 and below. The idea is to design a good query around which you can build indexes that can be created if not already created. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Kemes, Lisa Sent: Tuesday, April 13, 2010 4:09 PM To: arslist@ARSLIST.ORG Subject: Join Forms ** The BMC Documentation says For optimal performance, use indexed fields in the join criteria. If I use a qualification for the Join Criteria of ( 'Survey Number' = $Survey Number$) AND ( 'Network ID' = $Network ID$) AND ( 'TEIS Request ID' = $Request ID$), for optimal performance should each of these fields be indexed on each form? Or would it be OK for just one of these fields on each form? 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 attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Join forms using join field that are not indexed.
Dear all, I am looking at an issue with some join forms. I found a couple using fields - in the join criteria - that are not indexed. However since we have over a 100 join forms and would like to check them all, I would like to know if anyone - without reinventing the wheel - has a sql query which looks at the data dictionary tables and tell me which join form(s) is using a field in the join criteria that is not indexed. Environment: ARS7.1/AR SQL 2005 Regards frex ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
View and Vendor forms not allowed in Join Forms
Good morning all, I was hoping not to create extra forms and workflow... but I have 1 View form and 1 Vendor form.. I need to combine the data from both, however can't use either in a join form. Any ideas on what would work best, without creating 2 new staging forms, extra workflow to create a join of the data? Thanks, Kevin P. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: View and Vendor forms not allowed in Join Forms
Since nobody else has responded, I'll just go ahead and tell you. I have good news and bad news. The good news is that you don't have to create two new staging forms. The bad news is that you probably still have to create at least one regular form where both have escalations writing data to. Sorry, Shawn Pierson From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kevin Pulsen Sent: Tuesday, June 03, 2008 12:12 PM To: arslist@ARSLIST.ORG Subject: View and Vendor forms not allowed in Join Forms ** Good morning all, I was hoping not to create extra forms and workflow... but I have 1 View form and 1 Vendor form.. I need to combine the data from both, however can't use either in a join form. Any ideas on what would work best, without creating 2 new staging forms, extra workflow to create a join of the data? Thanks, Kevin P. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ Private and confidential as detailed here: http://www.sug.com/disclaimers/default.htm#Mail . If you cannot access the link, please e-mail sender. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: View and Vendor forms not allowed in Join Forms
Kevin, What are the original sources of this view and the vendor form?? Are they both database tables or views??? If so you can create a database view that is a join view of both those tables/views and take it from there. If one or both of the tables is not a database table or view, then creating a join would not be possible. You would need to create a staging table that would contain all the data from that source before you can do anything.. Joe - Original Message From: Kevin Pulsen [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Tuesday, June 3, 2008 1:12:00 PM Subject: View and Vendor forms not allowed in Join Forms ** Good morning all, I was hoping not to create extra forms and workflow... but I have 1 View form and 1 Vendor form.. I need to combine the data from both, however can't use either in a join form. Any ideas on what would work best, without creating 2 new staging forms, extra workflow to create a join of the data? Thanks, Kevin P. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Problem With ARS 6.3 Patch 20 and Querying Join Forms
Good morning listers. I was just curious to know if anyone else has encountered this little peculiar aspect of AR System behavior. We upgraded to ARS 6.3 Patch 20 (running on a Solaris 8 server) and now, if you go to a Join form in the ARS User tool and try to search using the Query By Example method and placing a value in the 'Join Request ID' field, then you get the following error message when trying to initiate the search. ARERR [101] Entry ID parameter value is longer than the maximum allowed length However, if you go to the advanced search bar and issue the following query, the search executes. 'Join Request ID' = NOM0037|NODE001|0101931 This happens whether the user is running with the ARS 6.3 Patch 20 or 7.0.1 patch 1 User tools. Derek __ Derek Berube [EMAIL PROTECTED] Wildstar Technologies, LLC. 1453 Riverview Run Lane Suwanee, Georgia 30024 (678) 229-1475 - Office (678) 229-1476 - FAX (404) 444-5283 - Mobile http://www.wildstartech.com/ AIM Handle: BerubeDB Jabber: [EMAIL PROTECTED] MSN Messenger: [EMAIL PROTECTED] Yahoo! Messenger: derekberube ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Problem With ARS 6.3 Patch 20 and Querying Join Forms
We experienced the same issue but we did not install patch 20 on our User tool. I confirmed that the issue does not occur on our production environment which is on patch 16 but it happens on our development environment which is on patch 20. It seems this is not an issue with Patch 20 for the client but Patch 20 for AR Server. We are on Windows 2003 for our application servers. Thanks Peter Lammey ESPN MIT Technical Services Applications Management 860-766-4761 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Derek Berube Sent: Tuesday, February 27, 2007 10:34 AM To: arslist@ARSLIST.ORG Subject: Problem With ARS 6.3 Patch 20 and Querying Join Forms Good morning listers. I was just curious to know if anyone else has encountered this little peculiar aspect of AR System behavior. We upgraded to ARS 6.3 Patch 20 (running on a Solaris 8 server) and now, if you go to a Join form in the ARS User tool and try to search using the Query By Example method and placing a value in the 'Join Request ID' field, then you get the following error message when trying to initiate the search. ARERR [101] Entry ID parameter value is longer than the maximum allowed length However, if you go to the advanced search bar and issue the following query, the search executes. 'Join Request ID' = NOM0037|NODE001|0101931 This happens whether the user is running with the ARS 6.3 Patch 20 or 7.0.1 patch 1 User tools. Derek __ Derek Berube [EMAIL PROTECTED] Wildstar Technologies, LLC. 1453 Riverview Run Lane Suwanee, Georgia 30024 (678) 229-1475 - Office (678) 229-1476 - FAX (404) 444-5283 - Mobile http://www.wildstartech.com/ AIM Handle: BerubeDB Jabber: [EMAIL PROTECTED] MSN Messenger: [EMAIL PROTECTED] Yahoo! Messenger: derekberube ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Problem With ARS 6.3 Patch 20 and Querying Join Forms
I've seen this on our 7.0.01 and 7.0.01 p001 servers using the respective version of the user tool for each. Axton Grams On 2/27/07, Derek Berube [EMAIL PROTECTED] wrote: Good morning listers. I was just curious to know if anyone else has encountered this little peculiar aspect of AR System behavior. We upgraded to ARS 6.3 Patch 20 (running on a Solaris 8 server) and now, if you go to a Join form in the ARS User tool and try to search using the Query By Example method and placing a value in the 'Join Request ID' field, then you get the following error message when trying to initiate the search. ARERR [101] Entry ID parameter value is longer than the maximum allowed length However, if you go to the advanced search bar and issue the following query, the search executes. 'Join Request ID' = NOM0037|NODE001|0101931 This happens whether the user is running with the ARS 6.3 Patch 20 or 7.0.1 patch 1 User tools. Derek __ Derek Berube [EMAIL PROTECTED] Wildstar Technologies, LLC. 1453 Riverview Run Lane Suwanee, Georgia 30024 (678) 229-1475 - Office (678) 229-1476 - FAX (404) 444-5283 - Mobile http://www.wildstartech.com/ AIM Handle: BerubeDB Jabber: [EMAIL PROTECTED] MSN Messenger: [EMAIL PROTECTED] Yahoo! Messenger: derekberube ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Problem With ARS 6.3 Patch 20 and Querying Join Forms
We had discovered this very same issue, however, this started occurring prior to installing Patch 20. So I don't think this is Patch 20 specific. This is occurring on our development servers that has Patch 18. If anyone has an answer to how it is happening and how it can be corrected we would love to hear it. Christopher Pruitt Consultant Specialist EDS - Bank of America mailto:[EMAIL PROTECTED] Confidentiality Notice: This message and any files transmitted with it are intended for the sole use of the entity or individual to whom it is addressed, and may contain information that is confidential, privileged, and exempt from disclosure under applicable law. If you are not the intended addressee for this e-mail, you are hereby notified that any copying, distribution, or dissemination of this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately destroy, erase, or discard this message. Please notify the sender immediately by return e-mail if you have received this e-mail by mistake. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Lammey, Peter A. Sent: Tuesday, February 27, 2007 9:51 AM To: arslist@ARSLIST.ORG Subject: Re: Problem With ARS 6.3 Patch 20 and Querying Join Forms We experienced the same issue but we did not install patch 20 on our User tool. I confirmed that the issue does not occur on our production environment which is on patch 16 but it happens on our development environment which is on patch 20. It seems this is not an issue with Patch 20 for the client but Patch 20 for AR Server. We are on Windows 2003 for our application servers. Thanks Peter Lammey ESPN MIT Technical Services Applications Management 860-766-4761 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Derek Berube Sent: Tuesday, February 27, 2007 10:34 AM To: arslist@ARSLIST.ORG Subject: Problem With ARS 6.3 Patch 20 and Querying Join Forms Good morning listers. I was just curious to know if anyone else has encountered this little peculiar aspect of AR System behavior. We upgraded to ARS 6.3 Patch 20 (running on a Solaris 8 server) and now, if you go to a Join form in the ARS User tool and try to search using the Query By Example method and placing a value in the 'Join Request ID' field, then you get the following error message when trying to initiate the search. ARERR [101] Entry ID parameter value is longer than the maximum allowed length However, if you go to the advanced search bar and issue the following query, the search executes. 'Join Request ID' = NOM0037|NODE001|0101931 This happens whether the user is running with the ARS 6.3 Patch 20 or 7.0.1 patch 1 User tools. Derek __ Derek Berube [EMAIL PROTECTED] Wildstar Technologies, LLC. 1453 Riverview Run Lane Suwanee, Georgia 30024 (678) 229-1475 - Office (678) 229-1476 - FAX (404) 444-5283 - Mobile http://www.wildstartech.com/ AIM Handle: BerubeDB Jabber: [EMAIL PROTECTED] MSN Messenger: [EMAIL PROTECTED] Yahoo! Messenger: derekberube ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Problem With ARS 6.3 Patch 20 and Querying Join Forms
Ah ha. I was thinking about adding that. We jumped from 6.0.1 patch 1414 to 6.0.3 Patch 20. I've been instructed to apply patch 21 and see if the problem goes away. So I'll let the list know how it goes! Thanks for the confirmation that I'm not alone ;-) Derek On Feb 27, 2007, at 11:04 AM, Pruitt, Christopher J wrote: We had discovered this very same issue, however, this started occurring prior to installing Patch 20. So I don't think this is Patch 20 specific. This is occurring on our development servers that has Patch 18. If anyone has an answer to how it is happening and how it can be corrected we would love to hear it. Christopher Pruitt Consultant Specialist EDS - Bank of America mailto:[EMAIL PROTECTED] Confidentiality Notice: This message and any files transmitted with it are intended for the sole use of the entity or individual to whom it is addressed, and may contain information that is confidential, privileged, and exempt from disclosure under applicable law. If you are not the intended addressee for this e-mail, you are hereby notified that any copying, distribution, or dissemination of this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately destroy, erase, or discard this message. Please notify the sender immediately by return e-mail if you have received this e- mail by mistake. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Lammey, Peter A. Sent: Tuesday, February 27, 2007 9:51 AM To: arslist@ARSLIST.ORG Subject: Re: Problem With ARS 6.3 Patch 20 and Querying Join Forms We experienced the same issue but we did not install patch 20 on our User tool. I confirmed that the issue does not occur on our production environment which is on patch 16 but it happens on our development environment which is on patch 20. It seems this is not an issue with Patch 20 for the client but Patch 20 for AR Server. We are on Windows 2003 for our application servers. Thanks Peter Lammey ESPN MIT Technical Services Applications Management 860-766-4761 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Derek Berube Sent: Tuesday, February 27, 2007 10:34 AM To: arslist@ARSLIST.ORG Subject: Problem With ARS 6.3 Patch 20 and Querying Join Forms Good morning listers. I was just curious to know if anyone else has encountered this little peculiar aspect of AR System behavior. We upgraded to ARS 6.3 Patch 20 (running on a Solaris 8 server) and now, if you go to a Join form in the ARS User tool and try to search using the Query By Example method and placing a value in the 'Join Request ID' field, then you get the following error message when trying to initiate the search. ARERR [101] Entry ID parameter value is longer than the maximum allowed length However, if you go to the advanced search bar and issue the following query, the search executes. 'Join Request ID' = NOM0037|NODE001|0101931 This happens whether the user is running with the ARS 6.3 Patch 20 or 7.0.1 patch 1 User tools. Derek __ Derek Berube [EMAIL PROTECTED] Wildstar Technologies, LLC. 1453 Riverview Run Lane Suwanee, Georgia 30024 (678) 229-1475 - Office (678) 229-1476 - FAX (404) 444-5283 - Mobile http://www.wildstartech.com/ AIM Handle: BerubeDB Jabber: [EMAIL PROTECTED] MSN Messenger: [EMAIL PROTECTED] Yahoo! Messenger: derekberube __ __ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are __ __ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are __ _ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Problem With ARS 6.3 Patch 20 and Querying Join Forms
Has anyone on the list reported this issue to BMC Remedy? Christopher Pruitt Consultant Specialist EDS - Bank of America I3-Inventory IW Infrastructure Team Phone: +1-972-605-7702 (8-835) mailto:[EMAIL PROTECTED] Confidentiality Notice: This message and any files transmitted with it are intended for the sole use of the entity or individual to whom it is addressed, and may contain information that is confidential, privileged, and exempt from disclosure under applicable law. If you are not the intended addressee for this e-mail, you are hereby notified that any copying, distribution, or dissemination of this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately destroy, erase, or discard this message. Please notify the sender immediately by return e-mail if you have received this e-mail by mistake. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Derek Berube Sent: Tuesday, February 27, 2007 10:25 AM To: arslist@ARSLIST.ORG Subject: Re: Problem With ARS 6.3 Patch 20 and Querying Join Forms Ah ha. I was thinking about adding that. We jumped from 6.0.1 patch 1414 to 6.0.3 Patch 20. I've been instructed to apply patch 21 and see if the problem goes away. So I'll let the list know how it goes! Thanks for the confirmation that I'm not alone ;-) Derek On Feb 27, 2007, at 11:04 AM, Pruitt, Christopher J wrote: We had discovered this very same issue, however, this started occurring prior to installing Patch 20. So I don't think this is Patch 20 specific. This is occurring on our development servers that has Patch 18. If anyone has an answer to how it is happening and how it can be corrected we would love to hear it. Christopher Pruitt Consultant Specialist EDS - Bank of America mailto:[EMAIL PROTECTED] Confidentiality Notice: This message and any files transmitted with it are intended for the sole use of the entity or individual to whom it is addressed, and may contain information that is confidential, privileged, and exempt from disclosure under applicable law. If you are not the intended addressee for this e-mail, you are hereby notified that any copying, distribution, or dissemination of this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately destroy, erase, or discard this message. Please notify the sender immediately by return e-mail if you have received this e- mail by mistake. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Lammey, Peter A. Sent: Tuesday, February 27, 2007 9:51 AM To: arslist@ARSLIST.ORG Subject: Re: Problem With ARS 6.3 Patch 20 and Querying Join Forms We experienced the same issue but we did not install patch 20 on our User tool. I confirmed that the issue does not occur on our production environment which is on patch 16 but it happens on our development environment which is on patch 20. It seems this is not an issue with Patch 20 for the client but Patch 20 for AR Server. We are on Windows 2003 for our application servers. Thanks Peter Lammey ESPN MIT Technical Services Applications Management 860-766-4761 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Derek Berube Sent: Tuesday, February 27, 2007 10:34 AM To: arslist@ARSLIST.ORG Subject: Problem With ARS 6.3 Patch 20 and Querying Join Forms Good morning listers. I was just curious to know if anyone else has encountered this little peculiar aspect of AR System behavior. We upgraded to ARS 6.3 Patch 20 (running on a Solaris 8 server) and now, if you go to a Join form in the ARS User tool and try to search using the Query By Example method and placing a value in the 'Join Request ID' field, then you get the following error message when trying to initiate the search. ARERR [101] Entry ID parameter value is longer than the maximum allowed length However, if you go to the advanced search bar and issue the following query, the search executes. 'Join Request ID' = NOM0037|NODE001|0101931 This happens whether the user is running with the ARS 6.3 Patch 20 or 7.0.1 patch 1 User tools. Derek __ Derek Berube [EMAIL PROTECTED] Wildstar Technologies, LLC. 1453 Riverview Run Lane Suwanee, Georgia 30024 (678) 229-1475 - Office (678) 229-1476 - FAX (404) 444-5283 - Mobile http://www.wildstartech.com/ AIM Handle: BerubeDB Jabber: [EMAIL PROTECTED] MSN Messenger: [EMAIL PROTECTED] Yahoo! Messenger: derekberube __ __ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers
Re: Problem With ARS 6.3 Patch 20 and Querying Join Forms
I did not, my join entry id was 176 characters in length (11 way join). I thought it was a byproduct of this, so I didn't think twice about it. Axton Grams On 2/27/07, Pruitt, Christopher J [EMAIL PROTECTED] wrote: Has anyone on the list reported this issue to BMC Remedy? Christopher Pruitt Consultant Specialist EDS - Bank of America I3-Inventory IW Infrastructure Team Phone: +1-972-605-7702 (8-835) mailto:[EMAIL PROTECTED] Confidentiality Notice: This message and any files transmitted with it are intended for the sole use of the entity or individual to whom it is addressed, and may contain information that is confidential, privileged, and exempt from disclosure under applicable law. If you are not the intended addressee for this e-mail, you are hereby notified that any copying, distribution, or dissemination of this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately destroy, erase, or discard this message. Please notify the sender immediately by return e-mail if you have received this e-mail by mistake. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Derek Berube Sent: Tuesday, February 27, 2007 10:25 AM To: arslist@ARSLIST.ORG Subject: Re: Problem With ARS 6.3 Patch 20 and Querying Join Forms Ah ha. I was thinking about adding that. We jumped from 6.0.1 patch 1414 to 6.0.3 Patch 20. I've been instructed to apply patch 21 and see if the problem goes away. So I'll let the list know how it goes! Thanks for the confirmation that I'm not alone ;-) Derek On Feb 27, 2007, at 11:04 AM, Pruitt, Christopher J wrote: We had discovered this very same issue, however, this started occurring prior to installing Patch 20. So I don't think this is Patch 20 specific. This is occurring on our development servers that has Patch 18. If anyone has an answer to how it is happening and how it can be corrected we would love to hear it. Christopher Pruitt Consultant Specialist EDS - Bank of America mailto:[EMAIL PROTECTED] Confidentiality Notice: This message and any files transmitted with it are intended for the sole use of the entity or individual to whom it is addressed, and may contain information that is confidential, privileged, and exempt from disclosure under applicable law. If you are not the intended addressee for this e-mail, you are hereby notified that any copying, distribution, or dissemination of this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately destroy, erase, or discard this message. Please notify the sender immediately by return e-mail if you have received this e- mail by mistake. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Lammey, Peter A. Sent: Tuesday, February 27, 2007 9:51 AM To: arslist@ARSLIST.ORG Subject: Re: Problem With ARS 6.3 Patch 20 and Querying Join Forms We experienced the same issue but we did not install patch 20 on our User tool. I confirmed that the issue does not occur on our production environment which is on patch 16 but it happens on our development environment which is on patch 20. It seems this is not an issue with Patch 20 for the client but Patch 20 for AR Server. We are on Windows 2003 for our application servers. Thanks Peter Lammey ESPN MIT Technical Services Applications Management 860-766-4761 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Derek Berube Sent: Tuesday, February 27, 2007 10:34 AM To: arslist@ARSLIST.ORG Subject: Problem With ARS 6.3 Patch 20 and Querying Join Forms Good morning listers. I was just curious to know if anyone else has encountered this little peculiar aspect of AR System behavior. We upgraded to ARS 6.3 Patch 20 (running on a Solaris 8 server) and now, if you go to a Join form in the ARS User tool and try to search using the Query By Example method and placing a value in the 'Join Request ID' field, then you get the following error message when trying to initiate the search. ARERR [101] Entry ID parameter value is longer than the maximum allowed length However, if you go to the advanced search bar and issue the following query, the search executes. 'Join Request ID' = NOM0037|NODE001|0101931 This happens whether the user is running with the ARS 6.3 Patch 20 or 7.0.1 patch 1 User tools. Derek __ Derek Berube [EMAIL PROTECTED] Wildstar Technologies, LLC. 1453 Riverview Run Lane Suwanee, Georgia 30024 (678) 229-1475 - Office (678) 229-1476 - FAX (404) 444-5283 - Mobile http://www.wildstartech.com/ AIM Handle: BerubeDB Jabber: [EMAIL PROTECTED] MSN Messenger: [EMAIL PROTECTED] Yahoo! Messenger: derekberube
Re: Problem With ARS 6.3 Patch 20 and Querying Join Forms
Indirectly. The client I'm working with utilizes an Authorized Support Partner. I've reported the problem to that partner and I'm not sure what gets funneled up to BMC/Remedy engineering. Even though there is no mention in the readme file for patch 21, I got the tier 1 support analyst there is a new patch out now, so try it and see if the problem goes away response. So I'm jumping through the requisite hoops in the hopes that the problem will get addressed/resolved. Derek On Feb 27, 2007, at 12:31 PM, Pruitt, Christopher J wrote: Has anyone on the list reported this issue to BMC Remedy? Christopher Pruitt Consultant Specialist EDS - Bank of America I3-Inventory IW Infrastructure Team Phone: +1-972-605-7702 (8-835) mailto:[EMAIL PROTECTED] Confidentiality Notice: This message and any files transmitted with it are intended for the sole use of the entity or individual to whom it is addressed, and may contain information that is confidential, privileged, and exempt from disclosure under applicable law. If you are not the intended addressee for this e-mail, you are hereby notified that any copying, distribution, or dissemination of this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately destroy, erase, or discard this message. Please notify the sender immediately by return e-mail if you have received this e- mail by mistake. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Derek Berube Sent: Tuesday, February 27, 2007 10:25 AM To: arslist@ARSLIST.ORG Subject: Re: Problem With ARS 6.3 Patch 20 and Querying Join Forms Ah ha. I was thinking about adding that. We jumped from 6.0.1 patch 1414 to 6.0.3 Patch 20. I've been instructed to apply patch 21 and see if the problem goes away. So I'll let the list know how it goes! Thanks for the confirmation that I'm not alone ;-) Derek On Feb 27, 2007, at 11:04 AM, Pruitt, Christopher J wrote: We had discovered this very same issue, however, this started occurring prior to installing Patch 20. So I don't think this is Patch 20 specific. This is occurring on our development servers that has Patch 18. If anyone has an answer to how it is happening and how it can be corrected we would love to hear it. Christopher Pruitt Consultant Specialist EDS - Bank of America mailto:[EMAIL PROTECTED] Confidentiality Notice: This message and any files transmitted with it are intended for the sole use of the entity or individual to whom it is addressed, and may contain information that is confidential, privileged, and exempt from disclosure under applicable law. If you are not the intended addressee for this e-mail, you are hereby notified that any copying, distribution, or dissemination of this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately destroy, erase, or discard this message. Please notify the sender immediately by return e-mail if you have received this e- mail by mistake. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Lammey, Peter A. Sent: Tuesday, February 27, 2007 9:51 AM To: arslist@ARSLIST.ORG Subject: Re: Problem With ARS 6.3 Patch 20 and Querying Join Forms We experienced the same issue but we did not install patch 20 on our User tool. I confirmed that the issue does not occur on our production environment which is on patch 16 but it happens on our development environment which is on patch 20. It seems this is not an issue with Patch 20 for the client but Patch 20 for AR Server. We are on Windows 2003 for our application servers. Thanks Peter Lammey ESPN MIT Technical Services Applications Management 860-766-4761 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Derek Berube Sent: Tuesday, February 27, 2007 10:34 AM To: arslist@ARSLIST.ORG Subject: Problem With ARS 6.3 Patch 20 and Querying Join Forms Good morning listers. I was just curious to know if anyone else has encountered this little peculiar aspect of AR System behavior. We upgraded to ARS 6.3 Patch 20 (running on a Solaris 8 server) and now, if you go to a Join form in the ARS User tool and try to search using the Query By Example method and placing a value in the 'Join Request ID' field, then you get the following error message when trying to initiate the search. ARERR [101] Entry ID parameter value is longer than the maximum allowed length However, if you go to the advanced search bar and issue the following query, the search executes. 'Join Request ID' = NOM0037|NODE001|0101931 This happens whether the user is running with the ARS 6.3 Patch 20 or 7.0.1 patch 1 User tools. Derek _ _ Derek Berube [EMAIL PROTECTED] Wildstar Technologies, LLC. 1453 Riverview
Re: Problem With ARS 6.3 Patch 20 and Querying Join Forms
Hi, Derek: So is the only issue with join forms on the Join Request ID? I understand that this is important, but wanted to make sure there wasn't anything else. Michelle -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Derek Berube Sent: Tuesday, February 27, 2007 1:34 PM To: arslist@ARSLIST.ORG Subject: Re: Problem With ARS 6.3 Patch 20 and Querying Join Forms For those of you who are interested, this still happens with patch 21. QBE searching on the 'Join Request ID' field yields an ARERR [101] Entry ID parameter value is longer than the maximum allowed length error message. On Feb 27, 2007, at 2:14 PM, Derek Berube wrote: Indirectly. The client I'm working with utilizes an Authorized Support Partner. I've reported the problem to that partner and I'm not sure what gets funneled up to BMC/Remedy engineering. Even though there is no mention in the readme file for patch 21, I got the tier 1 support analyst there is a new patch out now, so try it and see if the problem goes away response. So I'm jumping through the requisite hoops in the hopes that the problem will get addressed/resolved. Derek On Feb 27, 2007, at 12:31 PM, Pruitt, Christopher J wrote: Has anyone on the list reported this issue to BMC Remedy? Christopher Pruitt Consultant Specialist EDS - Bank of America I3-Inventory IW Infrastructure Team Phone: +1-972-605-7702 (8-835) mailto:[EMAIL PROTECTED] Confidentiality Notice: This message and any files transmitted with it are intended for the sole use of the entity or individual to whom it is addressed, and may contain information that is confidential, privileged, and exempt from disclosure under applicable law. If you are not the intended addressee for this e-mail, you are hereby notified that any copying, distribution, or dissemination of this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately destroy, erase, or discard this message. Please notify the sender immediately by return e-mail if you have received this e- mail by mistake. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Derek Berube Sent: Tuesday, February 27, 2007 10:25 AM To: arslist@ARSLIST.ORG Subject: Re: Problem With ARS 6.3 Patch 20 and Querying Join Forms Ah ha. I was thinking about adding that. We jumped from 6.0.1 patch 1414 to 6.0.3 Patch 20. I've been instructed to apply patch 21 and see if the problem goes away. So I'll let the list know how it goes! Thanks for the confirmation that I'm not alone ;-) Derek On Feb 27, 2007, at 11:04 AM, Pruitt, Christopher J wrote: We had discovered this very same issue, however, this started occurring prior to installing Patch 20. So I don't think this is Patch 20 specific. This is occurring on our development servers that has Patch 18. If anyone has an answer to how it is happening and how it can be corrected we would love to hear it. Christopher Pruitt Consultant Specialist EDS - Bank of America mailto:[EMAIL PROTECTED] Confidentiality Notice: This message and any files transmitted with it are intended for the sole use of the entity or individual to whom it is addressed, and may contain information that is confidential, privileged, and exempt from disclosure under applicable law. If you are not the intended addressee for this e-mail, you are hereby notified that any copying, distribution, or dissemination of this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately destroy, erase, or discard this message. Please notify the sender immediately by return e-mail if you have received this e- mail by mistake. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Lammey, Peter A. Sent: Tuesday, February 27, 2007 9:51 AM To: arslist@ARSLIST.ORG Subject: Re: Problem With ARS 6.3 Patch 20 and Querying Join Forms We experienced the same issue but we did not install patch 20 on our User tool. I confirmed that the issue does not occur on our production environment which is on patch 16 but it happens on our development environment which is on patch 20. It seems this is not an issue with Patch 20 for the client but Patch 20 for AR Server. We are on Windows 2003 for our application servers. Thanks Peter Lammey ESPN MIT Technical Services Applications Management 860-766-4761 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Derek Berube Sent: Tuesday, February 27, 2007 10:34 AM To: arslist@ARSLIST.ORG Subject: Problem With ARS 6.3 Patch 20 and Querying Join Forms Good morning listers. I was just curious to know if anyone else has encountered this little peculiar aspect of AR System
Re: Problem With ARS 6.3 Patch 20 and Querying Join Forms
Yep. That appears to be the only problem. And the funny thing about it is that if you use the Advanced Search Criteria, you get no errors at all. On Feb 27, 2007, at 6:32 PM, Lucero, Michelle - IST contractor wrote: Hi, Derek: So is the only issue with join forms on the Join Request ID? I understand that this is important, but wanted to make sure there wasn't anything else. Michelle -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Derek Berube Sent: Tuesday, February 27, 2007 1:34 PM To: arslist@ARSLIST.ORG Subject: Re: Problem With ARS 6.3 Patch 20 and Querying Join Forms For those of you who are interested, this still happens with patch 21. QBE searching on the 'Join Request ID' field yields an ARERR [101] Entry ID parameter value is longer than the maximum allowed length error message. On Feb 27, 2007, at 2:14 PM, Derek Berube wrote: Indirectly. The client I'm working with utilizes an Authorized Support Partner. I've reported the problem to that partner and I'm not sure what gets funneled up to BMC/Remedy engineering. Even though there is no mention in the readme file for patch 21, I got the tier 1 support analyst there is a new patch out now, so try it and see if the problem goes away response. So I'm jumping through the requisite hoops in the hopes that the problem will get addressed/resolved. Derek On Feb 27, 2007, at 12:31 PM, Pruitt, Christopher J wrote: Has anyone on the list reported this issue to BMC Remedy? Christopher Pruitt Consultant Specialist EDS - Bank of America I3-Inventory IW Infrastructure Team Phone: +1-972-605-7702 (8-835) mailto:[EMAIL PROTECTED] Confidentiality Notice: This message and any files transmitted with it are intended for the sole use of the entity or individual to whom it is addressed, and may contain information that is confidential, privileged, and exempt from disclosure under applicable law. If you are not the intended addressee for this e-mail, you are hereby notified that any copying, distribution, or dissemination of this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately destroy, erase, or discard this message. Please notify the sender immediately by return e-mail if you have received this e- mail by mistake. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Derek Berube Sent: Tuesday, February 27, 2007 10:25 AM To: arslist@ARSLIST.ORG Subject: Re: Problem With ARS 6.3 Patch 20 and Querying Join Forms Ah ha. I was thinking about adding that. We jumped from 6.0.1 patch 1414 to 6.0.3 Patch 20. I've been instructed to apply patch 21 and see if the problem goes away. So I'll let the list know how it goes! Thanks for the confirmation that I'm not alone ;-) Derek On Feb 27, 2007, at 11:04 AM, Pruitt, Christopher J wrote: We had discovered this very same issue, however, this started occurring prior to installing Patch 20. So I don't think this is Patch 20 specific. This is occurring on our development servers that has Patch 18. If anyone has an answer to how it is happening and how it can be corrected we would love to hear it. Christopher Pruitt Consultant Specialist EDS - Bank of America mailto:[EMAIL PROTECTED] Confidentiality Notice: This message and any files transmitted with it are intended for the sole use of the entity or individual to whom it is addressed, and may contain information that is confidential, privileged, and exempt from disclosure under applicable law. If you are not the intended addressee for this e-mail, you are hereby notified that any copying, distribution, or dissemination of this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately destroy, erase, or discard this message. Please notify the sender immediately by return e-mail if you have received this e- mail by mistake. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Lammey, Peter A. Sent: Tuesday, February 27, 2007 9:51 AM To: arslist@ARSLIST.ORG Subject: Re: Problem With ARS 6.3 Patch 20 and Querying Join Forms We experienced the same issue but we did not install patch 20 on our User tool. I confirmed that the issue does not occur on our production environment which is on patch 16 but it happens on our development environment which is on patch 20. It seems this is not an issue with Patch 20 for the client but Patch 20 for AR Server. We are on Windows 2003 for our application servers. Thanks Peter Lammey ESPN MIT Technical Services Applications Management 860-766-4761 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Derek Berube Sent: Tuesday, February 27, 2007 10:34 AM To: arslist@ARSLIST.ORG Subject: Problem With ARS 6.3 Patch 20 and Querying Join Forms Good
Re: Question re: Self-join forms - what are they? (sp. AST: Forms for Asset 7.0 app)
Cindy, In a nutshell: - the BMC join forms join classes together according to the class hirearchy and are created by the cmdb application. You should not modify these in the admin tool as your changes could get overwritten if changes are made to the classes in the class manager. If you look at these forms you will see that they are not laid out for user access. - the AST join forms are effectively views of the BMC forms created as user interface forms. They are generally not affected by changes to the CMDB. You can lay these out as you want to in the admin tool, add fields from the underlying BMC form and add display-only fields as you need for any specific workflow you create. HTH Cheers Peter Cindy Sapochetti writes: Hi Listers - Happy Holidays! I have a basic question regarding self join forms (I'm specifically looking at AST: forms from the Asset 7.0 app). For example - AST:ComputerSystem is a join of BMC.CORE:BMC_ComputerSystem to another BMC.CORE:BMC_ComputerSystem. What's the purpose of this? If I trace this all back from a database standpoint, AST_ComputerSystem is a view, which is based on two other views, those are based on four other views, which are based on joins of 5 tables, 2 views...etc...etc...lots of nesting. I'm not sure I understand the design principle behind this, and it would be helpful if someone could point me to the documentation that might speak to this, or give me the Remedy BackEnd Design for Dummies synopsis. Thanks! Cindy ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Question re: Self-join forms - what are they? (sp. AST: Forms for Asset 7.0 app)
Hi Listers - Happy Holidays! I have a basic question regarding self join forms (I'm specifically looking at AST: forms from the Asset 7.0 app). For example - AST:ComputerSystem is a join of BMC.CORE:BMC_ComputerSystem to another BMC.CORE:BMC_ComputerSystem. What's the purpose of this? If I trace this all back from a database standpoint, AST_ComputerSystem is a view, which is based on two other views, those are based on four other views, which are based on joins of 5 tables, 2 views...etc...etc...lots of nesting. I'm not sure I understand the design principle behind this, and it would be helpful if someone could point me to the documentation that might speak to this, or give me the Remedy BackEnd Design for Dummies synopsis. Thanks! Cindy ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Question re: Self-join forms - what are they? (sp. AST: Forms for Asset 7.0 app)
One of the use of self joins is to relate one ticket to many others from the same form so a one-to-many kind of a relationship. I do not have a CMDB installation I can look at to help you understand what that particular join may be used for, but you could try to dig around and see if there is a one-to-many kind of a relationship in that join that is either used for reporting or any other workflow within the application. Joe - Original Message From: Cindy Sapochetti [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, December 18, 2006 4:46:19 PM Subject: Question re: Self-join forms - what are they? (sp. AST: Forms for Asset 7.0 app) Hi Listers - Happy Holidays! I have a basic question regarding self join forms (I'm specifically looking at AST: forms from the Asset 7.0 app). For example - AST:ComputerSystem is a join of BMC.CORE:BMC_ComputerSystem to another BMC.CORE:BMC_ComputerSystem. What's the purpose of this? If I trace this all back from a database standpoint, AST_ComputerSystem is a view, which is based on two other views, those are based on four other views, which are based on joins of 5 tables, 2 views...etc...etc...lots of nesting. I'm not sure I understand the design principle behind this, and it would be helpful if someone could point me to the documentation that might speak to this, or give me the Remedy BackEnd Design for Dummies synopsis. Thanks! Cindy __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
driver.exe: bringing in fields from Join forms
Thanks to a helper on the list, he helped me out with trying to use driver.exe. While I have been able to do just about anything, there is only one thing that I cannot do and which I will ask the list for assistance on. I am trying to add a field onto a join form. This field is supposed to be pulled from either the primary or secondary form. So far, I've tried to create the field in its entirety, or I have simply tried to create a field with no display properties. Either way, I get this error: (273) Invalid field mapping type. When doing a gsf on the field I plan to use driver on, I notice this: ARGetField results ReturnCode: OK Field name: Part Number Field mapping: Field type: JOIN Schema Index: 0 Field Id : 20013 Datatype: 4 Field option: 2 Field create mode: 1 Field Bit Option: 0 Note where it says Field Mapping and Field Type. I'm betting that the Field Mapping type error I'm getting is because I am not defining it as a join form. However, I do not know what the correct field mapping type is. Anyone care to help me out? Thanks. Alex. ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: driver.exe: bringing in fields from Join forms
Alex, I'm pretty sure for a join field, the field mapping type is 2. Then you need to supply schema index and the real fieldId. Colleen Eilbert Alex Straph wrote: Thanks to a helper on the list, he helped me out with trying to use driver.exe. While I have been able to do just about anything, there is only one thing that I cannot do and which I will ask the list for assistance on. I am trying to add a field onto a join form. This field is supposed to be pulled from either the primary or secondary form. So far, I've tried to create the field in its entirety, or I have simply tried to create a field with no display properties. Either way, I get this error: (273) Invalid field mapping type. When doing a gsf on the field I plan to use driver on, I notice this: ARGetField results ReturnCode: OK Field name: Part Number Field mapping: Field type: JOIN Schema Index: 0 Field Id : 20013 Datatype: 4 Field option: 2 Field create mode: 1 Field Bit Option: 0 Note where it says Field Mapping and Field Type. I'm betting that the Field Mapping type error I'm getting is because I am not defining it as a join form. However, I do not know what the correct field mapping type is. Anyone care to help me out? Thanks. Alex. ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: driver.exe: bringing in fields from Join forms
When in doubt about an API call...look at the C header files... I would bet that your talking about these values: #define AR_FIELD_NONE 0 /* null field */ #define AR_FIELD_REGULAR 1 /* field of regular schema */ #define AR_FIELD_JOIN 2 /* field of join schema */ #define AR_FIELD_VIEW 3 /* field of view schema */ #define AR_FIELD_VENDOR 4 /* field of vendor schema */ #define AR_FIELD_INHERITANCE 5 /* field of inheritance type */ Aside: What #5 is about.. .well, maybe the future will tell more. :) I think the right answer for csf's Datatype prompt is join = 30. #define AR_DATA_TYPE_JOIN 30 Then the Field Mapping Type would be 2: #define AR_FIELD_JOIN 2 /* field of join schema */ schema index: 0 = primary form? 1 = secondary form? etc... ( I hope you can take it from there.) Looks like that worked for me with the v7 driver on a test server.. :) -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On 9/19/06, Alex Straph [EMAIL PROTECTED] wrote: Thanks to a helper on the list, he helped me out with trying to use driver.exe. While I have been able to do just about anything, there is only one thing that I cannot do and which I will ask the list for assistance on. I am trying to add a field onto a join form. This field is supposed to be pulled from either the primary or secondary form. So far, I've tried to create the field in its entirety, or I have simply tried to create a field with no display properties. Either way, I get this error: (273) Invalid field mapping type. When doing a gsf on the field I plan to use driver on, I notice this: ARGetField results ReturnCode: OK Field name: Part Number Field mapping: Field type: JOIN Schema Index: 0 Field Id : 20013 Datatype: 4 Field option: 2 Field create mode: 1 Field Bit Option: 0 Note where it says Field Mapping and Field Type. I'm betting that the Field Mapping type error I'm getting is because I am not defining it as a join form. However, I do not know what the correct field mapping type is. Anyone care to help me out? Thanks. Alex. ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Importing data into join forms in Asset Management module SOLVED
I've been working on a Remedy Asset Management project on and off for some time now. also, ive taken the atrium cmdb: administering course which I can reccommend if you'll have to create any integration with the CMDB at some point. Regards, MIchiel On 5/11/06, Dwayne Martin [EMAIL PROTECTED] wrote: Thanks, Michiel and James and Roger, I did a mass update on BMC:BMC_ComputerSystem and set DatasetID to BMC.ASSET. Now they show up in AST:ComputerSystem. I am trying not to be a Lazy poster. I searched the Asset Management pdf document for DatasetID and didn't find anything. I've also taken the Asset Management Administering class and can't find anything about DatasetID in the course manual. (I may not have looked in the right place.) How did you guys learn all this? Dwayne Original message Date: Thu, 11 May 2006 09:05:20 +0200 From: Michiel Beijen [EMAIL PROTECTED] Subject: Re: Importing data into join forms in Asset Management module To: arslist@ARSLIST.ORG You probably mean the Instance ID field. Since this is field ID 179 it is automatically generated by the system as long as you don't map it in the Import tool. Regards, Michiel On 5/11/06, McKenzie, James J C-E LCMC HQISEC/L3 [EMAIL PROTECTED] wrote: ** Roger and all: I forgot about that one. Also, the item id (I forget which field this is but it is the field directly above the data set id and is quite a few characters in length) must be unique. If there is not workflow to set this, I would create such so that it functions on Merge and gives the asset a different set of ids than that set by the 'other' workflow. Also, I would like to state that I was very successful in RE-IMPORTING data back into the AST:Computer System form, but if you are trying to import NEW data, you have to use the BMC: forms (I don't know why, but this is the only way that I was able to do so.) I would set the dataset ID to BMC.ASSET or your items will not appear. James McKenzie L-3 GSI -Original Message- From: Action Request System discussion list(ARSList) To: arslist@ARSLIST.ORG Sent: 5/10/2006 1:22 PM Subject: Re: Importing data into join forms in Asset Management module ** On import the field datasetid must be set to BMC.ASSET -Original Message- From: Dwayne Martin [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Wed, 10 May 2006 15:34:49 -0400 Subject: Importing data into join forms in Asset Management module Hello everyone, We are trying to import data into the Asset module AST:Computer system form. This is a self-join of BMC:BMC_ComputerSystem on InstanceId. BMC:BMC_ComputerSystem in turn is a join of BMC:BMC_ComputerSystem_ and BMC:BMC_AssetBase, again based on InstanceId. The data imports and BMC:BMC_ComputerSystem_, BMC:BMC_AssetBase, BMC:BMC_ComputerSystem each have thousands of records. Most importantly, they all have matching InstanceId values. But when we query the AST:Computer system form it has no records. BMC:BMC_ComputerSystem has thousands of records, with values in InstanceId. So how can you join it to itself based on InstanceId and not get any records? What are we missing? ARS 6.3, HPUX 11 server, Oracle 9.2 db Dwayne Martin Computing Support James Madison University ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org http://www.wwrug.org __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org Dwayne Martin Computing Support James Madison University ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Importing data into join forms in Asset Management module
You probably mean the Instance ID field. Since this is field ID 179 it is automatically generated by the system as long as you don't map it in the Import tool. Regards, Michiel On 5/11/06, McKenzie, James J C-E LCMC HQISEC/L3 [EMAIL PROTECTED] wrote: ** Roger and all: I forgot about that one. Also, the item id (I forget which field this is but it is the field directly above the data set id and is quite a few characters in length) must be unique. If there is not workflow to set this, I would create such so that it functions on Merge and gives the asset a different set of ids than that set by the 'other' workflow. Also, I would like to state that I was very successful in RE-IMPORTING data back into the AST:Computer System form, but if you are trying to import NEW data, you have to use the BMC: forms (I don't know why, but this is the only way that I was able to do so.) I would set the dataset ID to BMC.ASSET or your items will not appear. James McKenzie L-3 GSI -Original Message- From: Action Request System discussion list(ARSList) To: arslist@ARSLIST.ORG Sent: 5/10/2006 1:22 PM Subject: Re: Importing data into join forms in Asset Management module ** On import the field datasetid must be set to BMC.ASSET -Original Message- From: Dwayne Martin [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Wed, 10 May 2006 15:34:49 -0400 Subject: Importing data into join forms in Asset Management module Hello everyone, We are trying to import data into the Asset module AST:Computer system form. This is a self-join of BMC:BMC_ComputerSystem on InstanceId. BMC:BMC_ComputerSystem in turn is a join of BMC:BMC_ComputerSystem_ and BMC:BMC_AssetBase, again based on InstanceId. The data imports and BMC:BMC_ComputerSystem_, BMC:BMC_AssetBase, BMC:BMC_ComputerSystem each have thousands of records. Most importantly, they all have matching InstanceId values. But when we query the AST:Computer system form it has no records. BMC:BMC_ComputerSystem has thousands of records, with values in InstanceId. So how can you join it to itself based on InstanceId and not get any records? What are we missing? ARS 6.3, HPUX 11 server, Oracle 9.2 db Dwayne Martin Computing Support James Madison University ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org http://www.wwrug.org __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Importing data into join forms in Asset Management module
It is my understanding that you can submit to a Join form but the submit in and of itself does nothing. You can however create workflow that fires on submit to create the underlying entries in the appropriate tables. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ron Fariss Sent: Thursday, May 11, 2006 9:03 AM To: arslist@ARSLIST.ORG Subject: Re: Importing data into join forms in Asset Management module Question - It is my understanding that Join forms contain data that result from a database search. I do updates via joins, but have never tried to import new data directly into a join. If, as in the original question the join is the product of one form and an initial join of 2 other forms, does the import attempt to create 3 new records (1 in each form) if all of the required fields are present? Ron Fariss AIG Technologies Remedy TelAlert Administration Work: (713) 831-2365 Cell: (281) 782-0979 McKenzie, James J C-E LCMC To: arslist@ARSLIST.ORG HQISEC/L3cc: [EMAIL PROTECTED]Subject: Re: Importing data into join forms in Asset Management module S.ARMY.MIL Sent by: Action Request System discussion list(ARSList) [EMAIL PROTECTED] RG 05/10/2006 09:48 PM Please respond to arslist ** Roger and all: I forgot about that one. Also, the item id (I forget which field this is but it is the field directly above the data set id and is quite a few characters in length) must be unique. If there is not workflow to set this, I would create such so that it functions on Merge and gives the asset a different set of ids than that set by the 'other' workflow. Also, I would like to state that I was very successful in RE-IMPORTING data back into the AST:Computer System form, but if you are trying to import NEW data, you have to use the BMC: forms (I don't know why, but this is the only way that I was able to do so.) I would set the dataset ID to BMC.ASSET or your items will not appear. James McKenzie L-3 GSI -Original Message- From: Action Request System discussion list(ARSList) To: arslist@ARSLIST.ORG Sent: 5/10/2006 1:22 PM Subject: Re: Importing data into join forms in Asset Management module ** On import the field datasetid must be set to BMC.ASSET -Original Message- From: Dwayne Martin [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Wed, 10 May 2006 15:34:49 -0400 Subject: Importing data into join forms in Asset Management module Hello everyone, We are trying to import data into the Asset module AST:Computer system form. This is a self-join of BMC:BMC_ComputerSystem on InstanceId. BMC:BMC_ComputerSystem in turn is a join of BMC:BMC_ComputerSystem_ and BMC:BMC_AssetBase, again based on InstanceId. The data imports and BMC:BMC_ComputerSystem_, BMC:BMC_AssetBase, BMC:BMC_ComputerSystem each have thousands of records. Most importantly, they all have matching InstanceId values. But when we query the AST:Computer system form it has no records. BMC:BMC_ComputerSystem has thousands of records, with values in InstanceId. So how can you join it to itself based on InstanceId and not get any records? What are we missing? ARS 6.3, HPUX 11 server, Oracle 9.2 db Dwayne Martin Computing Support James Madison University ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org http://www.wwrug.org __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Importing data into join forms in Asset Management module SOLVED
Thanks, Michiel and James and Roger, I did a mass update on BMC:BMC_ComputerSystem and set DatasetID to “BMC.ASSET.” Now they show up in AST:ComputerSystem. I am trying not to be a “Lazy poster.” I searched the Asset Management pdf document for “DatasetID” and didn’t find anything. I’ve also taken the “Asset Management Administering” class and can’t find anything about “DatasetID” in the course manual. (I may not have looked in the right place.) How did you guys learn all this? Dwayne Original message Date: Thu, 11 May 2006 09:05:20 +0200 From: Michiel Beijen [EMAIL PROTECTED] Subject: Re: Importing data into join forms in Asset Management module To: arslist@ARSLIST.ORG You probably mean the Instance ID field. Since this is field ID 179 it is automatically generated by the system as long as you don't map it in the Import tool. Regards, Michiel On 5/11/06, McKenzie, James J C-E LCMC HQISEC/L3 [EMAIL PROTECTED] wrote: ** Roger and all: I forgot about that one. Also, the item id (I forget which field this is but it is the field directly above the data set id and is quite a few characters in length) must be unique. If there is not workflow to set this, I would create such so that it functions on Merge and gives the asset a different set of ids than that set by the 'other' workflow. Also, I would like to state that I was very successful in RE-IMPORTING data back into the AST:Computer System form, but if you are trying to import NEW data, you have to use the BMC: forms (I don't know why, but this is the only way that I was able to do so.) I would set the dataset ID to BMC.ASSET or your items will not appear. James McKenzie L-3 GSI -Original Message- From: Action Request System discussion list(ARSList) To: arslist@ARSLIST.ORG Sent: 5/10/2006 1:22 PM Subject: Re: Importing data into join forms in Asset Management module ** On import the field datasetid must be set to BMC.ASSET -Original Message- From: Dwayne Martin [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Wed, 10 May 2006 15:34:49 -0400 Subject: Importing data into join forms in Asset Management module Hello everyone, We are trying to import data into the Asset module AST:Computer system form. This is a self-join of BMC:BMC_ComputerSystem on InstanceId. BMC:BMC_ComputerSystem in turn is a join of BMC:BMC_ComputerSystem_ and BMC:BMC_AssetBase, again based on InstanceId. The data imports and BMC:BMC_ComputerSystem_, BMC:BMC_AssetBase, BMC:BMC_ComputerSystem each have thousands of records. Most importantly, they all have matching InstanceId values. But when we query the AST:Computer system form it has no records. BMC:BMC_ComputerSystem has thousands of records, with values in InstanceId. So how can you join it to itself based on InstanceId and not get any records? What are we missing? ARS 6.3, HPUX 11 server, Oracle 9.2 db Dwayne Martin Computing Support James Madison University ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org http://www.wwrug.org __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org Dwayne Martin Computing Support James Madison University
Re: Importing data into join forms in Asset Management module
** On import the field datasetid must be set to BMC.ASSET-Original Message-From: Dwayne Martin [EMAIL PROTECTED]To: arslist@ARSLIST.ORGSent: Wed, 10 May 2006 15:34:49 -0400Subject: Importing data into join forms in Asset Management module Hello everyone, We are trying to import data into the Asset module AST:Computer system form. This is a self-join of BMC:BMC_ComputerSystem on InstanceId. BMC:BMC_ComputerSystem in turn is a join of BMC:BMC_ComputerSystem_ and BMC:BMC_AssetBase, again based on InstanceId. The data imports and BMC:BMC_ComputerSystem_, BMC:BMC_AssetBase, BMC:BMC_ComputerSystem each have thousands of records. Most importantly, they all have matching InstanceId values. But when we query the AST:Computer system form it has no records. BMC:BMC_ComputerSystem has thousands of records, with values in InstanceId. So how can you join it to itself based on InstanceId and not get any records? What are we missing? ARS 6.3, HPUX 11 server, Oracle 9.2 db Dwayne Martin Computing Support James Madison University ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it___