Capture query question
All, How to capture a single query string. How can I capture the QBE search criteria and the '1005' search criteria, combine them into a single search string, without executing the search. This will then be passed to an EXTERNAL() field for a table qualification. I can do this with a lot of workflow but I would prefer a leaner solution. Remedy combines the search criteria and sends it to the DB and AR System Searches Preference. So the question is how does Remedy combine the search criteria? More Detail: Contracts has 7 contract type forms; one for support, one for warranty, etc. All 7 contract forms are a join of CTR:ContractBase and another *_ form. The information in the *_ base form is not important for this function. Users want to be able to search all contract types (7 forms) at one time. Searches will need to go against CTR:ContractBase_Locale (which is another join of CTR:ContractBase), note that I will need to create a search view and restrict access to just the search view. Users must view the results in the Contract Console as this is where all contract types can be displayed and opened from a single location. Users will not be permitted to make changes directly in CTR:ContractBase_Locale. Again, I want to open CTR:ContractBase_Locale (new search view with only access to the view) for users to perform the search. I can expect QBE and advanced search used together. There are many fields so creating an EXTERNAL() for each field is just not practical. Do you know of a way I can capture the QBE and advanced search criteria in a single string, *without executing the search*, so that users can close the window and set the table qualification in the contract console and refresh the table? Thanks, Pete -- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
Re: DB connection from the AR Server installer
Steve, That was the magic bullet that will allow me to complete the task at hand. I still need to determine why this EV is needed. Many thanks for the quick response!!! Best, Pete On Mon, Aug 21, 2017 at 7:58 AM, Murnane, Phil <phil.murn...@windward.com> wrote: > ** > > Hi Peter, > > > > I’m far from an expert here, but in the past I’ve resolved some Oracle > connection problems by setting the TWO_TASK environment variable. Some > notes here: http://www.orafaq.com/wiki/TWO_TASK . It’s a long shot, but > couldn’t hurt to try. > > > > HTH, > > --Phil > > > > *From:* Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] *On Behalf Of *Peter Joran > *Sent:* Sunday, August 20, 2017 2:34 PM > *To:* arslist@ARSLIST.ORG > *Subject:* DB connection from the AR Server installer > > > > ** > > All, > I am trying to get the Remedy installer to connect with the DB to install > the application. > > SQLPlus > As a preliminary test I tested the connection using SQLPlus from the > Remedy server. > Without appending the pw with @sid the connection failed (ERROR:ORA-12560: > TNS:protocol adapter error) > PW with @sid appended connects successfully > > Remedy Installer > In this case I'm only installing the AR Server 8.1.02 files as the DB > (Oracle 11g) is in place. > The issue is that the application installer does a validation check and it > fails. > Without the @sid it validates and performs the installation but then fails > when its time to connect to the DB at the very end of the installation. > Appending the pw @sid the installer validation fails. > > Any thoughts on how to connect to the DB (SQLPlus or application > installer) without using the @sid would be greatly appreciated. > > Different servers > ping the db server, by name and IP = success > > DB is started and open > > lsnrctl status = success > > tnsping sid = success > > Adding server env var ORACLE_SID=sid did not help > > > > > Thanks > Pete > > _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"
DB connection from the AR Server installer
All, I am trying to get the Remedy installer to connect with the DB to install the application. SQLPlus As a preliminary test I tested the connection using SQLPlus from the Remedy server. Without appending the pw with @sid the connection failed (ERROR:ORA-12560: TNS:protocol adapter error) PW with @sid appended connects successfully Remedy Installer In this case I'm only installing the AR Server 8.1.02 files as the DB (Oracle 11g) is in place. The issue is that the application installer does a validation check and it fails. Without the @sid it validates and performs the installation but then fails when its time to connect to the DB at the very end of the installation. Appending the pw @sid the installer validation fails. Any thoughts on how to connect to the DB (SQLPlus or application installer) without using the @sid would be greatly appreciated. Different servers ping the db server, by name and IP = success DB is started and open lsnrctl status = success tnsping sid = success Adding server env var ORACLE_SID=sid did not help Thanks Pete ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: OT (Friday humor): Sometimes the humor is right in front of us.
This has been around for a while but it remains a great lesson on how to explain systems. ;-) http://www.youtube.com/watch?v=rLDgQg6bq7o On Fri, Jun 7, 2013 at 11:16 AM, Smerz, Christian cesm...@eprod.com wrote: ** The SISS principle, Skeep It Simple Stupid *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Thad Esser *Sent:* Friday, June 07, 2013 10:13 AM *To:* arslist@ARSLIST.ORG *Subject:* OT (Friday humor): Sometimes the humor is right in front of us. ** We gotter make sure we dun skeep 'em reel good. [image: Inline image 1] (In case the image doesn't come through, there's a filter in SRM 8.1 named SRD:SRD:SkeepStatusRules_110) _ARSlist: Where the Answers Are and have been for 20 years_ -- This message (including any attachments) is confidential and intended for a specific individual and purpose. If you are not the intended recipient, please notify the sender immediately and delete this message. _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: OT:Log scrubber question
Very nice! Thanks again Steve Pete On Thu, May 30, 2013 at 1:49 PM, Steve Kallestad st...@tabtonic.com wrote: ** Yes on both counts Peter. I'm also thinking that it should optionally grab login names and auto-replace them with user001, user002 and have an options file or gui so you don't have to remember the command line. It's in progress... On Thu, May 30, 2013 at 4:36 AM, Peter Joran ppjo...@gmail.com wrote: ** The ARSList is simply the best!! Steve, many thanks for what you have done! I never expected anyone to write something to solve the issue. Your time and effort is greatly appreciated! At the risk of being a cad, how easy would it be to allow the user to determine what the replacement string should be? For example, replace 1.1.1.1 with AR Server, 2.2.2.2 with Mid-tier server, 3.3.3.3 with Database Server, Demo with Admin account, jfrost with Approver account, etc. Meaningful replacement strings would help support to maintain context when reviewing the logs. Also, can the utility be made to run on all files in a folder? Many thanks again Pete On Wed, May 29, 2013 at 8:42 PM, Steve Kallestad st...@tabtonic.comwrote: ** I was going to give some technical advice since I couldn't find any standalone utility like this, but I decided instead to just write one for you. It's pretty straight forward - it needs an input file, an output file, and a private terms file. The private terms file is a file containing words to be censored. They can be space separated, line separated or both. It will read the input file, replace all private terms with *s and it will also replace phone numbers, social security numbers, and email addresses with *s. I couldn't find one of those 2GB log files to test with, but it ran through a 20MB file in about 6 seconds. I shared it on Google Drive: https://docs.google.com/file/d/0ByjmQ_f5-wyKcEhqUTgyTDNLdE0/edit It requires java to be installed. Other than that, just drop it anywhere on your windows box and run it from the command line. Let me know if you have any issues or if you have any feedback on changes that would be useful. Thanks, Steve On Wed, May 29, 2013 at 1:35 PM, Francois Seegers franco...@blueturtle.co.za wrote: ** Hi Pete, If you are running v8 and up you might want to use the Atrium Integrator transformations running scripts on the files…just a thought… Regards Francois *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Peter Joran *Sent:* Wednesday, May 29, 2013 10:32 PM *To:* arslist@ARSLIST.ORG *Subject:* OT:Log scrubber question ** All I have a need to clean log files before sending them to BMC support. I'm looking for a tool that will allow me to create multiple search and replace configurations (rules) that can be used at any time. Not having to create search and replace every time would be a huge time saver. I also need the rules to be persistent and editable as well as being able to apply the search and replace function to a single file or all files in a directory. For example, apply search and replace Rule 1 to file x or apply search and replace Rule 1 to all files in folder y. Rule 1: Find Replace With (could be 1 or 100 replacement items) 1 a 2 b 3 c Rule 2: tom Jones david Parker etc Anyone know of such a tool? Many thanks Pete _ARSlist: Where the Answers Are and have been for 20 years_ -- Blue Turtle Technologies (Pty) Limited | Reg. no.: 2003/002610/07 | http://www.blueturtle.co.za Gauteng : Tel: +27 (0)11 206 5600 | Fax: +27 (0)86 208 0237 | Midridge Office Estate, International Business Gateway, cnr New Road Sixth Street, Midrand, 1685 | P O Box 31331, Kyalami, 1684 Western Cape: Tel: +27 (0)87 721 1874 | Fax: +27 (0)21 552 7764 | Unit E6, Century Square, Heron Crescent, Century City, Cape Town, 7446 DISCLAIMER: This email and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to whom they are addressed. This communication represents the originator's personal views and opinions, which do not necessarily reflect those of Blue Turtle Technologies (Pty) Ltd. If you are not the original recipient or the person responsible for delivering the email to the intended recipient, be advised that you have received this email in error, and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you received this email in error, please immediately notify the sender. Thank you. _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_
Re: OT:Log scrubber question
The ARSList is simply the best!! Steve, many thanks for what you have done! I never expected anyone to write something to solve the issue. Your time and effort is greatly appreciated! At the risk of being a cad, how easy would it be to allow the user to determine what the replacement string should be? For example, replace 1.1.1.1 with AR Server, 2.2.2.2 with Mid-tier server, 3.3.3.3 with Database Server, Demo with Admin account, jfrost with Approver account, etc. Meaningful replacement strings would help support to maintain context when reviewing the logs. Also, can the utility be made to run on all files in a folder? Many thanks again Pete On Wed, May 29, 2013 at 8:42 PM, Steve Kallestad st...@tabtonic.com wrote: ** I was going to give some technical advice since I couldn't find any standalone utility like this, but I decided instead to just write one for you. It's pretty straight forward - it needs an input file, an output file, and a private terms file. The private terms file is a file containing words to be censored. They can be space separated, line separated or both. It will read the input file, replace all private terms with *s and it will also replace phone numbers, social security numbers, and email addresses with *s. I couldn't find one of those 2GB log files to test with, but it ran through a 20MB file in about 6 seconds. I shared it on Google Drive: https://docs.google.com/file/d/0ByjmQ_f5-wyKcEhqUTgyTDNLdE0/edit It requires java to be installed. Other than that, just drop it anywhere on your windows box and run it from the command line. Let me know if you have any issues or if you have any feedback on changes that would be useful. Thanks, Steve On Wed, May 29, 2013 at 1:35 PM, Francois Seegers franco...@blueturtle.co.za wrote: ** Hi Pete, If you are running v8 and up you might want to use the Atrium Integrator transformations running scripts on the files…just a thought… Regards Francois *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Peter Joran *Sent:* Wednesday, May 29, 2013 10:32 PM *To:* arslist@ARSLIST.ORG *Subject:* OT:Log scrubber question ** All I have a need to clean log files before sending them to BMC support. I'm looking for a tool that will allow me to create multiple search and replace configurations (rules) that can be used at any time. Not having to create search and replace every time would be a huge time saver. I also need the rules to be persistent and editable as well as being able to apply the search and replace function to a single file or all files in a directory. For example, apply search and replace Rule 1 to file x or apply search and replace Rule 1 to all files in folder y. Rule 1: Find Replace With (could be 1 or 100 replacement items) 1 a 2 b 3 c Rule 2: tom Jones david Parker etc Anyone know of such a tool? Many thanks Pete _ARSlist: Where the Answers Are and have been for 20 years_ -- Blue Turtle Technologies (Pty) Limited | Reg. no.: 2003/002610/07 | http://www.blueturtle.co.za Gauteng : Tel: +27 (0)11 206 5600 | Fax: +27 (0)86 208 0237 | Midridge Office Estate, International Business Gateway, cnr New Road Sixth Street, Midrand, 1685 | P O Box 31331, Kyalami, 1684 Western Cape: Tel: +27 (0)87 721 1874 | Fax: +27 (0)21 552 7764 | Unit E6, Century Square, Heron Crescent, Century City, Cape Town, 7446 DISCLAIMER: This email and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to whom they are addressed. This communication represents the originator's personal views and opinions, which do not necessarily reflect those of Blue Turtle Technologies (Pty) Ltd. If you are not the original recipient or the person responsible for delivering the email to the intended recipient, be advised that you have received this email in error, and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you received this email in error, please immediately notify the sender. Thank you. _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
OT:Log scrubber question
All I have a need to clean log files before sending them to BMC support. I'm looking for a tool that will allow me to create multiple search and replace configurations (rules) that can be used at any time. Not having to create search and replace every time would be a huge time saver. I also need the rules to be persistent and editable as well as being able to apply the search and replace function to a single file or all files in a directory. For example, apply search and replace Rule 1 to file x or apply search and replace Rule 1 to all files in folder y. Rule 1: Find Replace With (could be 1 or 100 replacement items) 1 a 2 b 3 c Rule 2: tom Jones david Parker etc Anyone know of such a tool? Many thanks Pete ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Link alignment issue
All, In custom views there are buttons, with images, displayed as URLs. The image is not displayed when the Display Type is set to URL but I need the image to input an Alternative Text value. The issue I’m having is that the links are aligned center and not left as configured. If I change the Display Type to Button the Label text is also centered. However, the issue is not consistent as some links are aligned left. The issue is consistent between IE, FF, and the WUT. All buttons/URLs are configured the same and Alignments are correct when viewed in Dev Studio. Label Justify = Left Image Position = LeftI have also tried Center and Right with change. Removing the image did not change anything either. Any thoughts on how I can resolve the alignment issue are much appreciated. Many thanks Pete AR 7604 SP2 Hotfix 1020120531604 ITSM 760401 WUT and Dev Studio 7604 SP3 IE 8 FF 15 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
CSS Styling question
All This topic is a little OT but the CSS forums are not as responsive as the good folks here in the arslist. There is one KB that addresses the issue but the style sheet syntax did not seem very clear to me; probably due to lack of understanding of CSS. I need to apply styling to a field (trim text) that is inside a div. The view source is below. div id=WIN_0_536870988 arid=536870988 artype=Trim arsubtype=3 ardbn=txt_MyRequests arcolor=white class=h1 arfid536870988 ardbntxt_MyRequests trimdiv style=z-index:1103#59;top:17#59; left:534#59; width:210#59; height:40#59;background-color:white#59; Specifically, I want to change the color to Blue and justify the text Left. I know I can do this particular style with the field attributes but this is just a test run before trying more complex CSS solutions. The style is not being applied and I have cleared the browser cache and flushed the MT cache. This is what my style sheet looks like and added div#WIN_0_536870988 to the Custom CSS Style field attribute. div#WIN_0_536870988 { color:blue; text-align:left; font-weight:bold; } All thoughts gratefully accepted! Many thanks Pete ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Skip Navigation Question
Tim It helps indeed. Thanks Pete On Mon, Aug 6, 2012 at 2:18 PM, Timothy Powell timothy.pow...@pbs-consulting.com wrote: ** We played with this a while back. One of the solutions we played with, we called a Jump Menu, and was as follows: ** ** Make the first field in your form a drop down menu field that can be called with the arrow keys. It’s important that it be the first field, because the keyboard shortcut for Home (Shift-Ctrl-Home) will always take the user back to this field. Each value in the drop-down menu corresponds with a section on your form. So if the first value in the menu was “Assignment”, then there would be an “Assignment” section on the form. Head that section up with a character field displayed as text. When the section is picked from the drop down, set focus to the section heading. The fact that you created the heading as a character field displayed as text will allow a typical support screen reader like JAWS to “read” the heading back to the user for verification (screen readers have difficulty reading trim text). ** ** That was the base design. We even went a few steps further and added required fields within sections as a menu choice and we provided the capability for people to add custom jump points to the Jump Menu. ** ** And not really tied to skip navigation, but it’s VERY important for 508 to have your tabbing order be very clean and concise. ** ** HTH, Tim ** ** ** ** *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Peter Joran *Sent:* Monday, August 06, 2012 12:07 PM *To:* arslist@ARSLIST.ORG *Subject:* Skip Navigation Question ** ** ** All Our customer wants to build in skip navigation into customer facing forms to meet 508 compliance requirements. I've looked on-line and in documentation but I'm finding references on how to do this in Remedy. If anyone has a thought or idea on how to build in skip navigation I would be grateful. Many thanks Pete ARS\ITSM 7604 01 _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
Skip Navigation Question
All Our customer wants to build in skip navigation into customer facing forms to meet 508 compliance requirements. I've looked on-line and in documentation but I'm finding references on how to do this in Remedy. If anyone has a thought or idea on how to build in skip navigation I would be grateful. Many thanks Pete ARS\ITSM 7604 01 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Approval Server Auto Approval issue
All I've configured an rule base approval process that has one rule, an auto approval rule for a service request. The SR is created via a custom bulk upload form that creates a record in the SR interface create form. The SR record is created but is always set to Rejected. Looking at the logs there is another approval process that is throwing an error and stopping the approval process. I inactivated the approval process and its rules that is throwing the error but it still gets evaluated. I'm obviously missing something. For a reason I have yet to figure out the auto approval is not being evaluated before other approval processes, including the process throwing the error? How can I ensure that the auto approval process is evaluated first and then stops the approval process? All thoughts welcome. Pete ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: DMT 7.6 Validation Error-RESOLVED
Pete Many thanks for the heads-up! Cheers Pete On Wed, Jul 11, 2012 at 12:50 PM, Peter Romain p.romain.arsl...@parsolutions.co.uk wrote: ** Glad to help. ** ** There may be other gotchas in the DMT too – I know of one other, the filter guide AST:DLP:Validate_FG needs the 'EXIT' label moved to after the filter 'AST:DLP:ValidateProdDict_SetErr' ** ** *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Peter Joran *Sent:* 11 July 2012 17:46 *To:* arslist@ARSLIST.ORG *Subject:* Re: DMT 7.6 Validation Error-RESOLVED ** ** ** Pete You're the man!! Thanks for the help. Pete On Tue, Jul 10, 2012 at 11:43 AM, Peter Romain p.romain.arsl...@parsolutions.co.uk wrote: ** The RunIf of filter SHR:ATR:SetErrorMessage_013_Loop has ('z1D_Parse' != $NULL$) AND ('z1D_Parse' != ) Try removing the space from the last term so that it becomes ('z1D_Parse' != $NULL$) AND ('z1D_Parse' != ) *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Peter Joran *Sent:* 10 July 2012 15:59 *To:* arslist@ARSLIST.ORG *Subject:* DMT 7.6 Validation Error ** All I’m attempting to troubleshoot a validation error in the Data Management tool. The issue is that when I click on a record from the results list in the COM:LoadCompany form that is flagged as having an error (Error_Flag = Yes) the record hangs for a while and then ARERR 298 is thrown and the data is not displayed. ARERR [298] Too many filters processed during this operation I can select a non-error flagged record from the results list and the data will display as expected and without issue. I've tried increasing max filters to 9 and increasing max stack filter to 10 and the settings did not resolve the issue. All thoughts welcome Thanks Pete ar server 75 p7 itsm 76 p1 windows 2008 r2 sql svr 2008 r2 The plugin log does not show an error. The arerror log only logs arrerr 298. The filter log is looping the following lines: Checking SHR:ATR:SetErrorMessage_012 (12) Checking SHR:ATR:SetErrorMessage_012_First (12) Checking SHR:ATR:SetErrorMessage_013_Loop (13) Checking SHR:ATR:ParseErrorCode_011_GetMessage (11) Log section: FLTR TID: 002632 RPC ID: 009425 Queue: Fast Client-RPC: 390620USER: appadmin 0: Goto Action FLTR TID: 002632 RPC ID: 009425 Queue: Fast Client-RPC: 390620USER: appadmin Goto Execution Order: 11 FLTR TID: 002632 RPC ID: 009425 Queue: Fast Client-RPC: 390620USER: appadmin /* Tue Jul 10 2012 10:45:51.0510 */ Filter Level:0 Number Of Filters:29717 Checking SHR:ATR:ParseErrorCode_011_GetMessage (11) FLTR TID: 002632 RPC ID: 009425 Queue: Fast Client-RPC: 390620USER: appadmin -- Passed -- perform actions FLTR TID: 002632 RPC ID: 009425 Queue: Fast Client-RPC: 390620USER: appadmin 0: Set Fields FLTR TID: 002632 RPC ID: 009425 Queue: Fast Client-RPC: 390620USER: appadmin z1D_ParseTmp (302767100) = FLTR TID: 002632 RPC ID: 009425 Queue: Fast Client-RPC: 390620USER: appadmin 1: Set Fields FLTR TID: 002632 RPC ID: 009425 Queue: Fast Client-RPC: 390620USER: appadmin z1D_Parse (302766900) = FLTR TID: 002632 RPC ID: 009425 Queue: Fast Client-RPC: 390620USER: appadmin 2: Set Fields FLTR TID: 002632 RPC ID: 009425 Queue: Fast Client-RPC: 390620USER: appadmin z1D_ParseTmp (302767100) = FLTR TID: 002632 RPC ID: 009425 Queue: Fast Client-RPC: 390620USER: appadmin /* Tue Jul 10 2012 10:45:51.1780 */ Filter Level:0 Number Of Filters:29718 Checking SHR:ATR:SetErrorMessage_012 (12) FLTR TID: 002632 RPC ID: 009425 Queue: Fast Client-RPC: 390620USER: appadmin -- Failed qualification FLTR TID: 002632 RPC ID: 009425 Queue: Fast Client-RPC: 390620USER: appadmin /* Tue Jul 10 2012 10:45:51.2140 */ Filter Level:0 Number Of Filters:29719 Checking SHR:ATR:SetErrorMessage_012_First (12) FLTR TID: 002632 RPC ID: 009425 Queue: Fast Client-RPC: 390620USER: appadmin -- Failed qualification FLTR TID: 002632 RPC ID: 009425 Queue: Fast Client-RPC: 390620USER: appadmin /* Tue Jul 10 2012 10:45:51.2520 */ Filter Level:0 Number Of Filters:29720 Checking SHR:ATR:SetErrorMessage_013_Loop (13) FLTR TID: 002632 RPC ID: 009425 Queue: Fast Client-RPC: 390620USER: appadmin -- Passed -- perform actions
Re: DMT 7.6 Validation Error-RESOLVED
Pete You're the man!! Thanks for the help. Pete On Tue, Jul 10, 2012 at 11:43 AM, Peter Romain p.romain.arsl...@parsolutions.co.uk wrote: ** The RunIf of filter SHR:ATR:SetErrorMessage_013_Loop has ('z1D_Parse' != $NULL$) AND ('z1D_Parse' != ) ** ** Try removing the space from the last term so that it becomes ('z1D_Parse' != $NULL$) AND ('z1D_Parse' != ) ** ** *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Peter Joran *Sent:* 10 July 2012 15:59 *To:* arslist@ARSLIST.ORG *Subject:* DMT 7.6 Validation Error ** ** ** All I’m attempting to troubleshoot a validation error in the Data Management tool. The issue is that when I click on a record from the results list in the COM:LoadCompany form that is flagged as having an error (Error_Flag = Yes) the record hangs for a while and then ARERR 298 is thrown and the data is not displayed. ARERR [298] Too many filters processed during this operation I can select a non-error flagged record from the results list and the data will display as expected and without issue. I've tried increasing max filters to 9 and increasing max stack filter to 10 and the settings did not resolve the issue. All thoughts welcome Thanks Pete ar server 75 p7 itsm 76 p1 windows 2008 r2 sql svr 2008 r2 The plugin log does not show an error. The arerror log only logs arrerr 298. The filter log is looping the following lines: Checking SHR:ATR:SetErrorMessage_012 (12) Checking SHR:ATR:SetErrorMessage_012_First (12) Checking SHR:ATR:SetErrorMessage_013_Loop (13) Checking SHR:ATR:ParseErrorCode_011_GetMessage (11) Log section: FLTR TID: 002632 RPC ID: 009425 Queue: Fast Client-RPC: 390620USER: appadmin 0: Goto Action FLTR TID: 002632 RPC ID: 009425 Queue: Fast Client-RPC: 390620USER: appadmin Goto Execution Order: 11 FLTR TID: 002632 RPC ID: 009425 Queue: Fast Client-RPC: 390620USER: appadmin /* Tue Jul 10 2012 10:45:51.0510 */ Filter Level:0 Number Of Filters:29717 Checking SHR:ATR:ParseErrorCode_011_GetMessage (11) FLTR TID: 002632 RPC ID: 009425 Queue: Fast Client-RPC: 390620USER: appadmin -- Passed -- perform actions FLTR TID: 002632 RPC ID: 009425 Queue: Fast Client-RPC: 390620USER: appadmin 0: Set Fields FLTR TID: 002632 RPC ID: 009425 Queue: Fast Client-RPC: 390620USER: appadmin z1D_ParseTmp (302767100) = FLTR TID: 002632 RPC ID: 009425 Queue: Fast Client-RPC: 390620USER: appadmin 1: Set Fields FLTR TID: 002632 RPC ID: 009425 Queue: Fast Client-RPC: 390620USER: appadmin z1D_Parse (302766900) = FLTR TID: 002632 RPC ID: 009425 Queue: Fast Client-RPC: 390620USER: appadmin 2: Set Fields FLTR TID: 002632 RPC ID: 009425 Queue: Fast Client-RPC: 390620USER: appadmin z1D_ParseTmp (302767100) = FLTR TID: 002632 RPC ID: 009425 Queue: Fast Client-RPC: 390620USER: appadmin /* Tue Jul 10 2012 10:45:51.1780 */ Filter Level:0 Number Of Filters:29718 Checking SHR:ATR:SetErrorMessage_012 (12) FLTR TID: 002632 RPC ID: 009425 Queue: Fast Client-RPC: 390620USER: appadmin -- Failed qualification FLTR TID: 002632 RPC ID: 009425 Queue: Fast Client-RPC: 390620USER: appadmin /* Tue Jul 10 2012 10:45:51.2140 */ Filter Level:0 Number Of Filters:29719 Checking SHR:ATR:SetErrorMessage_012_First (12) FLTR TID: 002632 RPC ID: 009425 Queue: Fast Client-RPC: 390620USER: appadmin -- Failed qualification FLTR TID: 002632 RPC ID: 009425 Queue: Fast Client-RPC: 390620USER: appadmin /* Tue Jul 10 2012 10:45:51.2520 */ Filter Level:0 Number Of Filters:29720 Checking SHR:ATR:SetErrorMessage_013_Loop (13) FLTR TID: 002632 RPC ID: 009425 Queue: Fast Client-RPC: 390620USER: appadmin -- Passed -- perform actions FLTR TID: 002632 RPC ID: 009425 Queue: Fast Client-RPC: 390620USER: appadmin 0: Goto Action FLTR TID: 003328 RPC ID: 010065 Queue: Fast Client-RPC: 390620USER: appadmin /* Tue Jul 10 2012 10:45:51.3000 */ Start filter processing (phase 1) -- Operation - SET on AR System Administration: Server Information:Save Attachment - 001 FLTR TID: 003328 RPC ID: 010065 Queue: Fast Client-RPC: 390620USER: appadmin /* Tue Jul 10 2012 10:45:51.3000 */ Filter Level:0 Number Of Filters:0 Checking AR System
DMT 7.6 Validation Error
All I’m attempting to troubleshoot a validation error in the Data Management tool. The issue is that when I click on a record from the results list in the COM:LoadCompany form that is flagged as having an error (Error_Flag = Yes) the record hangs for a while and then ARERR 298 is thrown and the data is not displayed. ARERR [298] Too many filters processed during this operation I can select a non-error flagged record from the results list and the data will display as expected and without issue. I've tried increasing max filters to 9 and increasing max stack filter to 10 and the settings did not resolve the issue. All thoughts welcome Thanks Pete ar server 75 p7 itsm 76 p1 windows 2008 r2 sql svr 2008 r2 The plugin log does not show an error. The arerror log only logs arrerr 298. The filter log is looping the following lines: Checking SHR:ATR:SetErrorMessage_012 (12) Checking SHR:ATR:SetErrorMessage_012_First (12) Checking SHR:ATR:SetErrorMessage_013_Loop (13) Checking SHR:ATR:ParseErrorCode_011_GetMessage (11) Log section: FLTR TID: 002632 RPC ID: 009425 Queue: Fast Client-RPC: 390620USER: appadmin 0: Goto Action FLTR TID: 002632 RPC ID: 009425 Queue: Fast Client-RPC: 390620USER: appadmin Goto Execution Order: 11 FLTR TID: 002632 RPC ID: 009425 Queue: Fast Client-RPC: 390620USER: appadmin /* Tue Jul 10 2012 10:45:51.0510 */ Filter Level:0 Number Of Filters:29717 Checking SHR:ATR:ParseErrorCode_011_GetMessage (11) FLTR TID: 002632 RPC ID: 009425 Queue: Fast Client-RPC: 390620USER: appadmin -- Passed -- perform actions FLTR TID: 002632 RPC ID: 009425 Queue: Fast Client-RPC: 390620USER: appadmin 0: Set Fields FLTR TID: 002632 RPC ID: 009425 Queue: Fast Client-RPC: 390620USER: appadmin z1D_ParseTmp (302767100) = FLTR TID: 002632 RPC ID: 009425 Queue: Fast Client-RPC: 390620USER: appadmin 1: Set Fields FLTR TID: 002632 RPC ID: 009425 Queue: Fast Client-RPC: 390620USER: appadmin z1D_Parse (302766900) = FLTR TID: 002632 RPC ID: 009425 Queue: Fast Client-RPC: 390620USER: appadmin 2: Set Fields FLTR TID: 002632 RPC ID: 009425 Queue: Fast Client-RPC: 390620USER: appadmin z1D_ParseTmp (302767100) = FLTR TID: 002632 RPC ID: 009425 Queue: Fast Client-RPC: 390620USER: appadmin /* Tue Jul 10 2012 10:45:51.1780 */ Filter Level:0 Number Of Filters:29718 Checking SHR:ATR:SetErrorMessage_012 (12) FLTR TID: 002632 RPC ID: 009425 Queue: Fast Client-RPC: 390620USER: appadmin -- Failed qualification FLTR TID: 002632 RPC ID: 009425 Queue: Fast Client-RPC: 390620USER: appadmin /* Tue Jul 10 2012 10:45:51.2140 */ Filter Level:0 Number Of Filters:29719 Checking SHR:ATR:SetErrorMessage_012_First (12) FLTR TID: 002632 RPC ID: 009425 Queue: Fast Client-RPC: 390620USER: appadmin -- Failed qualification FLTR TID: 002632 RPC ID: 009425 Queue: Fast Client-RPC: 390620USER: appadmin /* Tue Jul 10 2012 10:45:51.2520 */ Filter Level:0 Number Of Filters:29720 Checking SHR:ATR:SetErrorMessage_013_Loop (13) FLTR TID: 002632 RPC ID: 009425 Queue: Fast Client-RPC: 390620USER: appadmin -- Passed -- perform actions FLTR TID: 002632 RPC ID: 009425 Queue: Fast Client-RPC: 390620USER: appadmin 0: Goto Action FLTR TID: 003328 RPC ID: 010065 Queue: Fast Client-RPC: 390620USER: appadmin /* Tue Jul 10 2012 10:45:51.3000 */ Start filter processing (phase 1) -- Operation - SET on AR System Administration: Server Information:Save Attachment - 001 FLTR TID: 003328 RPC ID: 010065 Queue: Fast Client-RPC: 390620USER: appadmin /* Tue Jul 10 2012 10:45:51.3000 */ Filter Level:0 Number Of Filters:0 Checking AR System Administration:ServerInformation:SaveAttachmen:Add Attachment (500) FLTR TID: 003328 RPC ID: 010065 Queue: Fast Client-RPC: 390620USER: appadmin -- Passed -- perform actions FLTR TID: 003328 RPC ID: 010065 Queue: Fast Client-RPC: 390620USER: appadmin 0: Set Fields ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Unsubscribe
This electronic message contains information from CACI International Inc or subsidiary companies, which may be company sensitive, proprietary, privileged or otherwise protected from disclosure. The information is intended to be used solely by the recipient(s) named above. If you are not an intended recipient, be aware that any review, disclosure, copying, distribution or use of this transmission or its contents is prohibited. If you have received this transmission in error, please notify us immediately at [EMAIL PROTECTED] With the exception of messages sent by authorized CACI contracts or purchasing personnel, nothing in this message may be interpreted as a digital or electronic signature that can be used to: (a) authenticate either the submission or the acceptance of a proposal or offer to contract, or (b) modify an existing contract. ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Nested SELECT table qualification?
All I'm hoping for a simple answer for a simple question. How can you do a nested SELECT in a table field qualification? If there is no simple way what's the opinion regarding an enhancement request? Many Thanks! Pete Oracle AR7 For Example: SELECT C536870913,C536870914,C536870915 FROM T191 WHERE C536870913 != 'SID25' AND C536870914 IN (SELECT C536870914 FROM T191 WHERE C536870913 = 'SID25' AND C536870915 IN (SELECT C536870915 FROM T191 WHERE C536870913 = 'SID25')) ORDER BY C536870914;This electronic message contains information from CACI International Inc or subsidiary companies, which may be company sensitive, proprietary, privileged or otherwise protected from disclosure. The information is intended to be used solely by the recipient(s) named above. If you are not an intended recipient, be aware that any review, disclosure, copying, distribution or use of this transmission or its contents is prohibited. If you have received this transmission in error, please notify us immediately at [EMAIL PROTECTED] With the exception of messages sent by authorized CACI contracts or purchasing personnel, nothing in this message may be interpreted as a digital or electronic signature that can be used to: (a) authenticate either the submission or the acceptance of a proposal or offer to contract, or (b) modify an existing contract. ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Nested SELECT table qualification?
Thanks for the replies! I do have a need to use an EXTERNAL qualification. Pete -Action Request System discussion list(ARSList) arslist@ARSLIST.ORG wrote: - To: arslist@ARSLIST.ORG From: Axton [EMAIL PROTECTED] ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org