T123 and User_Cache tables
Hello, I am relatively new to ARS. I just stumbled upon two tables in the schema T123 ( obtained from the query select * from arschema where name = 'User') and User_Cache. Both seem to contain more or less, same information about users created in ARS. Table attached to user form looks to be T123. So the question is what is table User_Cache doing? Regards, Yogesh ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: T123 and User_Cache tables
User_Cache is a cache table that remedy uses internally, TXXX is the data table that holds the data from the user form. Don't interact with the user_cache table directly. There are utilities for interacting with the cache if it ever becomes necessary (arreload and arcache). On Wed, Feb 20, 2013 at 1:38 AM, Yogesh Ketkar yogesh.ket...@vyomlabs.comwrote: ** Hello, ** ** I am relatively new to ARS. I just stumbled upon two tables in the schema T123 ( obtained from the query *select * from arschema where name = 'User' *) and User_Cache. Both seem to contain more or less, same information about users created in ARS. Table attached to user form looks to be T123. So the question is what is table User_Cache doing? ** ** Regards, Yogesh ** ** _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: T123 and User_Cache tables
Hi, Actually, do NOT interact with Any tables directly in the database. Use the client or any of the programming interfaces that do not bypass the application layer. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11/12): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. User_Cache is a cache table that remedy uses internally, TXXX is the data table that holds the data from the user form. Don't interact with the user_cache table directly. There are utilities for interacting with the cache if it ever becomes necessary (arreload and arcache). On Wed, Feb 20, 2013 at 1:38 AM, Yogesh Ketkar yogesh.ket...@vyomlabs.comwrote: ** Hello, ** ** I am relatively new to ARS. I just stumbled upon two tables in the schema T123 ( obtained from the query *select * from arschema where name = 'User' *) and User_Cache. Both seem to contain more or less, same information about users created in ARS. Table attached to user form looks to be T123. So the question is what is table User_Cache doing? ** ** Regards, Yogesh ** ** _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 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: $MENU$ pattern Problem in Remedy 7.6
What menu do you have attached to the field(s)? Without the pattern matching does the menu on the field(s) work? Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Heba Hashem, Vodafone Egypt Sent: Wednesday, February 20, 2013 6:53 AM To: arslist@ARSLIST.ORG Subject: $MENU$ pattern Problem in Remedy 7.6 ** Dears, Please I need a support form you as when I put $MENU$ pattern in some fields in Remedy 7.6 I can't submit any record on this form as I got the below error although when I remove them,it's working well. ARERR [552] The SQL database operation failed. : 536870935 ARERR [552] The SQL database operation failed. : 536870981 Heba Hashem SYSTEM ANALYST Customer Management Vodafone Egypt Telec. SA Mobile: +20 (10) 07033053 Email: heba.has...@vodafone.com vodafone.com.eg ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Service Packs and Patches
Thanks Vaibhav and David for the clarification! On Tue, Feb 19, 2013 at 5:27 PM, Easter, David david_eas...@bmc.com wrote: ** Also note that this the numbering policy is documented here: ** ** Time-based Support Policy (Effective for Releases from September 1, 2011 to present)http://www.bmc.com/support/prod-support-policy-time-based.html BMC Software uses a three-level numbering scheme with formats VV.RR.SP (*formerly VV.RR.MM http://vv.rr.mm/*) or YY.YY.RR For VV.RR.SP: VV=major version, RR=minor release, and SP = Service Pack ** ** *3rd level - Service Pack* A cumulative maintenance deliverable (SP) of a BMC Software product to resolve a specific set of defects and/or release new features to improve the quality, usability and performance of the product. Service Packs (formerly Maintenance Releases) are typically released 1-3 times per year. Installation of Service Packs is highly recommended, to improve product performance and stability. *GA Patch * A deliverable for cumulative critical fixes that cannot wait for a major/minor/maintenance/SP release. Patches are applicable to products designated as Full or Limited support only. GA Patches will be included in future releases of the product. Customer Support may direct customers to upgrade. ** ** -David J. Easter Manager of Product Management, AR System BSM Atrium Solutions Management BMC Software, Inc. The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. ** ** *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *vaibhav wadekar *Sent:* Monday, February 18, 2013 11:09 AM *To:* arslist@ARSLIST.ORG *Subject:* Re: Service Packs and Patches ** ** ** Hello Rishi, This new process started with 8.0 will continue with next releases. The patch install will be on top of the GA build or Service Packs. The patch installer requires that the product already be installed at the appropriate version and Service Pack level for that particular patch. The patch installer only includes items (files and defs) that were fixed in that patch and is not a complete install of the products. The patch install checks for the correctly installed versions. Service Packs will be roll-ups of patches and will generally include all the fixes from the prior patches.The Service Pack install is a complete install and the GA build does not have to be installed first. In general, a Service Pack should always be applied with the installer rather than trying to do a file by file install. If a customer wants to do an initial install of say 8.0 Patch 2, he must: 1. Install 8.0 2. Install Patch 2 3. Same goes with any subsequent patches; the Hotfixes should only be built off the latest patch unless a significant business case arises. Once a Service Pack comes out, then the hotfixes will be based on that until its first patch comes out. Service Packs, Patches, and Hotfixes are cumulative. They contain all the fixes that were built prior to its release. Hope this helps. Regards/Vaibhav ** ** ** ** On Mon, Feb 18, 2013 at 9:47 AM, Rishi R remedyri...@gmail.com wrote:*** * ** Hi List, With 7.6.xx, the BMC product updates were “Service Packs” instead of “Patches” – presumably for compliance etc. (new functionality can be added in “Service Packs” and not “Patches” – I am told) Come 8.0, it seems “Patches” are back – does anyone know if the policy has changed back to pre-7.6.xx era? Or there could be 8.0 Service Packs and Patches as well? Thanks, _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_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: $MENU$ pattern Problem in Remedy 7.6
I seem to recall that pattern matching a search menu never worked for me back on ARS 7.0.1, it would never see a match even when the field value did match a value found by the search menu. I don't know if that has changed in the last few years with newer versions. -Rick ___ Rick Westbrock QMX Support Services -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Wednesday, February 20, 2013 5:37 AM To: arslist@ARSLIST.ORG Subject: Re: $MENU$ pattern Problem in Remedy 7.6 What menu do you have attached to the field(s)? Without the pattern matching does the menu on the field(s) work? Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Heba Hashem, Vodafone Egypt Sent: Wednesday, February 20, 2013 6:53 AM To: arslist@ARSLIST.ORG Subject: $MENU$ pattern Problem in Remedy 7.6 ** Dears, Please I need a support form you as when I put $MENU$ pattern in some fields in Remedy 7.6 I can't submit any record on this form as I got the below error although when I remove them,it's working well. ARERR [552] The SQL database operation failed. : 536870935 ARERR [552] The SQL database operation failed. : 536870981 Heba Hashem SYSTEM ANALYST Customer Management Vodafone Egypt Telec. SA Mobile: +20 (10) 07033053 Email: heba.has...@vodafone.com vodafone.com.eg ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org 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: $MENU$ pattern Problem in Remedy 7.6
$MENU$ works Sounds to me like maybe there is an attribute the Menu uses that is not getting set (Example) 'ztmpkeyword'=$53687913$ ($53687913$ is not getting set) Doug -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Westbrock Sent: Wednesday, February 20, 2013 11:07 AM To: arslist@ARSLIST.ORG Subject: Re: $MENU$ pattern Problem in Remedy 7.6 I seem to recall that pattern matching a search menu never worked for me back on ARS 7.0.1, it would never see a match even when the field value did match a value found by the search menu. I don't know if that has changed in the last few years with newer versions. -Rick ___ Rick Westbrock QMX Support Services -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Wednesday, February 20, 2013 5:37 AM To: arslist@ARSLIST.ORG Subject: Re: $MENU$ pattern Problem in Remedy 7.6 What menu do you have attached to the field(s)? Without the pattern matching does the menu on the field(s) work? Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Heba Hashem, Vodafone Egypt Sent: Wednesday, February 20, 2013 6:53 AM To: arslist@ARSLIST.ORG Subject: $MENU$ pattern Problem in Remedy 7.6 ** Dears, Please I need a support form you as when I put $MENU$ pattern in some fields in Remedy 7.6 I can't submit any record on this form as I got the below error although when I remove them,it's working well. ARERR [552] The SQL database operation failed. : 536870935 ARERR [552] The SQL database operation failed. : 536870981 Heba Hashem SYSTEM ANALYST Customer Management Vodafone Egypt Telec. SA Mobile: +20 (10) 07033053 Email: heba.has...@vodafone.com vodafone.com.eg ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org 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 This email is subject to certain disclaimers, which may be reviewed via the following link. http://compass-usa.com/Pages/Disclaimer.aspx ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: T123 and User_Cache tables
Yogesh, The T123 table on your system is the database table for the User form. This is a data table just like any other data table in the system for any form in the system. This is just a data table. It does feed the User_Cache table with a subset of the data in the table. It is the User Interface if you will of the User_Cache. User_Cache is a system table that is used to hold the definitions of users that are defined within the AR System environment for authorization and authentication. This is the table actually used for security checks and interaction within the system. In the original design, we allowed for the User_Cache to be managed from remote machines or environments. So, you could have a User form on one system updating a User_Cache on the other. This is not a general practice in the current configuration of the system. So, there is history here and some designs allowing for different options for managing users. But today, the User_Cache is essentially a partial copy of the User form in almost every configuration. You should not worry about the User_Cache form. You should not be manually updating it or in fact interacting with it in any way. It is an internal management table. There are checksums on the data so if you do manual manipulate it, it will invalidate entries (this is to prevent people from changing rights or settings to break system security). I home this helps, Doug Mueller From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Yogesh Ketkar Sent: Wednesday, February 20, 2013 1:39 AM To: arslist@ARSLIST.ORG Subject: T123 and User_Cache tables ** Hello, I am relatively new to ARS. I just stumbled upon two tables in the schema T123 ( obtained from the query select * from arschema where name = 'User') and User_Cache. Both seem to contain more or less, same information about users created in ARS. Table attached to user form looks to be T123. So the question is what is table User_Cache doing? Regards, Yogesh _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: T123 and User_Cache tables
Doug, Thanks for the explanation. I always like to hear how things actually get made - or how the decisions have come about. So - a suggestion… I think it would be fun to have a WWRUG session on how it's made for ARS… Things like -- why the table numbers, why the required fields… to some -- that would be interesting history. Thanks again, -John On Wed, Feb 20, 2013 at 12:07 PM, Mueller, Doug doug_muel...@bmc.comwrote: ** Yogesh, ** ** The T123 table on your system is the database table for the User form. This is a data table just like any other data table in the system for any form in the system. This is just a data table. It does feed the User_Cache table with a subset of the data in the table. It is the User Interface if you will of the User_Cache. ** ** User_Cache is a system table that is used to hold the definitions of users that are defined within the AR System environment for authorization and authentication. This is the table actually used for security checks and interaction within the system. ** ** In the original design, we allowed for the User_Cache to be managed from remote machines or environments. So, you could have a User form on one system updating a User_Cache on the other. This is not a general practice in the current configuration of the system. ** ** So, there is history here and some designs allowing for different options for managing users. But today, the User_Cache is essentially a partial copy of the User form in almost every configuration. ** ** You should not worry about the User_Cache form. You should not be manually updating it or in fact interacting with it in any way. It is an internal management table. There are checksums on the data so if you do manual manipulate it, it will invalidate entries (this is to prevent people from changing rights or settings to break system security). ** ** I home this helps, ** ** Doug Mueller ** ** *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Yogesh Ketkar *Sent:* Wednesday, February 20, 2013 1:39 AM *To:* arslist@ARSLIST.ORG *Subject:* T123 and User_Cache tables ** ** ** Hello, ** ** I am relatively new to ARS. I just stumbled upon two tables in the schema T123 ( obtained from the query *select * from arschema where name = 'User' *) and User_Cache. Both seem to contain more or less, same information about users created in ARS. Table attached to user form looks to be T123. So the question is what is table User_Cache doing? ** ** Regards, Yogesh ** ** _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ -- *John Sundberg* Kinetic Data, Inc. Your Business. Your Process. *Save The Date! *Second Annual KEG (Kinetic Enthusiasts Group) Feb. 25th - March 1st in Denver, CO. For more information click here - KEGhttp://www.kineticdata.com/Events/KEG.html 651-556-0930 I john.sundb...@kineticdata.com www.kineticdata.com I community.kineticdata.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: $MENU$ pattern Problem in Remedy 7.6
Another possibility is there is an active link changing the menu. In order to attach a menu to a field there must be an original menu on the field. The $MENU$ pattern is applies against that original menu only, and will fail if the menu is changed. I know it worked that way in 6.3 and would be surprised if it is not the same in 7.6. Mark -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Tanner, Doug Sent: Wednesday, February 20, 2013 11:11 AM To: arslist@ARSLIST.ORG Subject: Re: $MENU$ pattern Problem in Remedy 7.6 $MENU$ works Sounds to me like maybe there is an attribute the Menu uses that is not getting set (Example) 'ztmpkeyword'=$53687913$ ($53687913$ is not getting set) Doug -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Westbrock Sent: Wednesday, February 20, 2013 11:07 AM To: arslist@ARSLIST.ORG Subject: Re: $MENU$ pattern Problem in Remedy 7.6 I seem to recall that pattern matching a search menu never worked for me back on ARS 7.0.1, it would never see a match even when the field value did match a value found by the search menu. I don't know if that has changed in the last few years with newer versions. -Rick ___ Rick Westbrock QMX Support Services -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Wednesday, February 20, 2013 5:37 AM To: arslist@ARSLIST.ORG Subject: Re: $MENU$ pattern Problem in Remedy 7.6 What menu do you have attached to the field(s)? Without the pattern matching does the menu on the field(s) work? Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Heba Hashem, Vodafone Egypt Sent: Wednesday, February 20, 2013 6:53 AM To: arslist@ARSLIST.ORG Subject: $MENU$ pattern Problem in Remedy 7.6 ** Dears, Please I need a support form you as when I put $MENU$ pattern in some fields in Remedy 7.6 I can't submit any record on this form as I got the below error although when I remove them,it's working well. ARERR [552] The SQL database operation failed. : 536870935 ARERR [552] The SQL database operation failed. : 536870981 Heba Hashem SYSTEM ANALYST Customer Management Vodafone Egypt Telec. SA Mobile: +20 (10) 07033053 Email: heba.has...@vodafone.com vodafone.com.eg ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org 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 This email is subject to certain disclaimers, which may be reviewed via the following link. http://compass-usa.com/Pages/Disclaimer.aspx ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
T123 and User_Cache tables
Sometimes, T123 and User_Cache can get out of sync, hence I tend to look at User_Cache as that seems to be what AR System looks at during the authentication process. But maybe that's not how it works. :) ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
JOB - Permanent Developer Position - Omaha
Please do not reply to this posting as all inquiries must be made to First Data's personnel department. First Data has an immediate full-time position for a Remedy developer in Omaha NE. No contractors. Competitive salary, full benefits, and relocation dollars. Position is for a junior to experienced developer. Please see official posting on First Data site. http://www.firstdata.com/en_us/about-first-data/careers-home/search.html?req=27460BR If you are interested please apply or feel free to forward to other appropriate candidates. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: T123 and User_Cache tables
How things are broken would also be an interesting topic :-). I had developed a natural flair for it in my very early Remedy days - teaches you a thing or two I tell you! Joe _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of John Sundberg Sent: Wednesday, February 20, 2013 1:20 PM To: arslist@ARSLIST.ORG Subject: Re: T123 and User_Cache tables ** Doug, Thanks for the explanation. I always like to hear how things actually get made - or how the decisions have come about. So - a suggestion. I think it would be fun to have a WWRUG session on how it's made for ARS. Things like -- why the table numbers, why the required fields. to some -- that would be interesting history. Thanks again, -John On Wed, Feb 20, 2013 at 12:07 PM, Mueller, Doug doug_muel...@bmc.com wrote: ** Yogesh, The T123 table on your system is the database table for the User form. This is a data table just like any other data table in the system for any form in the system. This is just a data table. It does feed the User_Cache table with a subset of the data in the table. It is the User Interface if you will of the User_Cache. User_Cache is a system table that is used to hold the definitions of users that are defined within the AR System environment for authorization and authentication. This is the table actually used for security checks and interaction within the system. In the original design, we allowed for the User_Cache to be managed from remote machines or environments. So, you could have a User form on one system updating a User_Cache on the other. This is not a general practice in the current configuration of the system. So, there is history here and some designs allowing for different options for managing users. But today, the User_Cache is essentially a partial copy of the User form in almost every configuration. You should not worry about the User_Cache form. You should not be manually updating it or in fact interacting with it in any way. It is an internal management table. There are checksums on the data so if you do manual manipulate it, it will invalidate entries (this is to prevent people from changing rights or settings to break system security). I home this helps, Doug Mueller From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Yogesh Ketkar Sent: Wednesday, February 20, 2013 1:39 AM To: arslist@ARSLIST.ORG Subject: T123 and User_Cache tables ** Hello, I am relatively new to ARS. I just stumbled upon two tables in the schema T123 ( obtained from the query select * from arschema where name = 'User') and User_Cache. Both seem to contain more or less, same information about users created in ARS. Table attached to user form looks to be T123. So the question is what is table User_Cache doing? Regards, Yogesh _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ -- John Sundberg Kinetic Data, Inc. Your Business. Your Process. Save The Date! Second Annual KEG (Kinetic Enthusiasts Group) Feb. 25th - March 1st in Denver, CO. For more information click here - http://www.kineticdata.com/Events/KEG.html KEG 651-556-0930 I john.sundb...@kineticdata.com http://www.kineticdata.com/ www.kineticdata.com I http://community.kineticdata.com/ community.kineticdata.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Computer User Agent?
I'm popping in late here, but rather than calling another server side script, you can leverage navigator.UserAgent in javascript. There's are also other properties that can be accessed: navigator.platform navigator.appVersion navigator.appName Just a thought. Thanks, Steve On Tue, Feb 19, 2013 at 2:15 PM, William Rentfrow wrentf...@stratacominc.com wrote: ** Hi all - ** ** We've had a request to allow approvals in CM 7.6.04 (same ARS version) via mobile devices. All mobile devices we have can access our regular MT page but we are probably going to provide a light version of Approval Central for those users with a new URL. ** ** We were also asked if we could capture statistics on the type of devices -typically this would be the user agent of the remote device to the Web server. ** ** I have NO idea if we can track that in Remedy - has anyone ever been able to capture the device type automatically within Remedy from a MT? Is there some way to do ** ** William Rentfrow wrentf...@stratacominc.com Office: 715-204-3061 Cell: 715-398-5056 ** ** _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
how to get full SQL logs?
** Hi List ^_^I have a little question, when I log "SQL" with ARS it happens that some very long SQL queries (like nearly 4k) are "truncated" and finish by "...", for example (I just post the begin and the end of it):///SELECT COUNT(*) FROM T2120 WHERE T2120.C23009 = 'ACTIVITY') AND (T2120.C100427 = 'SGP0211') AND (T2120.C7 = 20) AND (T2120.C7 = 40)) OR ((T2120.C23009 = 'MAINCHANGE') AND ((T2120.C100427 = 'SGP0211') OR (T2120.C100079 = 'SGP0211') OR (T2120.C100079 = 'SGP0211'))(...)OR (T2120.C60900 LIKE '%;20031;%') OR (T2120.C60900 LIKE '%;17;%') OR (T2120.C60900 LIKE '%;100107;%') OR (T2120.C60900 LIKE '%;2;%') OR (T2120.C60900 L...///Is there a way to get / log the full SQL query? I mean, apart asking the DBA since when we have those logs it's too late to ask them for it.Best regards.Laurent._ARSlist: "Where the Answers Are" and have been for 20 years_
Re: how to get full SQL logs?
You can try parameter Enable-Unlimited-Log-Line-Length: T From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of laurent matheo Sent: Thursday, 21 February 2013 10:33 AM To: arslist@ARSLIST.ORG Subject: how to get full SQL logs? ** Hi List ^_^ I have a little question, when I log SQL with ARS it happens that some very long SQL queries (like nearly 4k) are truncated and finish by ..., for example (I just post the begin and the end of it): /// SELECT COUNT(*) FROM T2120 WHERE T2120.C23009 = 'ACTIVITY') AND (T2120.C100427 = 'SGP0211') AND (T2120.C7 = 20) AND (T2120.C7 = 40)) OR ((T2120.C23009 = 'MAINCHANGE') AND ((T2120.C100427 = 'SGP0211') OR (T2120.C100079 = 'SGP0211') OR (T2120.C100079 = 'SGP0211')) (...) OR (T2120.C60900 LIKE '%;20031;%') OR (T2120.C60900 LIKE '%;17;%') OR (T2120.C60900 LIKE '%;100107;%') OR (T2120.C60900 LIKE '%;2;%') OR (T2120.C60900 L... /// Is there a way to get / log the full SQL query? I mean, apart asking the DBA since when we have those logs it's too late to ask them for it. Best regards. Laurent. _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: how to get full SQL logs?
Yes it's looks like non admin user performing some operation as it looking for groups to which user belong to. If it is admin user, you might see short version of SQL. To get complete SQL statement, you can set the parameter Rahul suggested in ar.cfg Regards/Vaibhav On Wednesday, February 20, 2013, laurent matheo wrote: ** Hi List ^_^ I have a little question, when I log SQL with ARS it happens that some very long SQL queries (like nearly 4k) are truncated and finish by ..., for example (I just post the begin and the end of it): /// SELECT COUNT(*) FROM T2120 WHERE T2120.C23009 = 'ACTIVITY') AND (T2120.C100427 = 'SGP0211') AND (T2120.C7 = 20) AND (T2120.C7 = 40)) OR ((T2120.C23009 = 'MAINCHANGE') AND ((T2120.C100427 = 'SGP0211') OR (T2120.C100079 = 'SGP0211') OR (T2120.C100079 = 'SGP0211')) (...) OR (T2120.C60900 LIKE '%;20031;%') OR (T2120.C60900 LIKE '%;17;%') OR (T2120.C60900 LIKE '%;100107;%') OR (T2120.C60900 LIKE '%;2;%') OR (T2120.C60900 L... /// Is there a way to get / log the full SQL query? I mean, apart asking the DBA since when we have those logs it's too late to ask them for it. Best regards. Laurent. _ARSlist: Where the Answers Are and have been for 20 years_ -- Sent from Gmail Mobile ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: how to get full SQL logs?
** Hi :)Thanks a lot, both of you :)Yep indeed it's a query from overview console on hpd:help desk.Laurent ;)On 21 Feb, 2013,at 06:25 AM, vaibhav wadekar wadekar.vaib...@gmail.com wrote:** Yes it's looks like non admin user performing some operation as it looking for groups to which user belong to. If it is admin user, you might see short version of SQL.To get complete SQL statement, you can set the parameter Rahul suggested in ar.cfgRegards/VaibhavOn Wednesday, February 20, 2013, laurent matheo wrote:**Hi List ^_^I have a little question, when I log "SQL" with ARS it happens that some very long SQL queries (like nearly 4k) are "truncated" and finish by "...", for example (I just post the begin and the end of it):///SELECT COUNT(*) FROM T2120 WHERE T2120.C23009 = 'ACTIVITY') AND (T2120.C100427 = 'SGP0211') AND (T2120.C7 = 20) AND (T2120.C7 = 40)) OR ((T2120.C23009 = 'MAINCHANGE') AND ((T2120.C100427 = 'SGP0211') OR (T2120.C100079 = 'SGP0211') OR (T2120.C100079 = 'SGP0211'))(...)OR (T2120.C60900 LIKE '%;20031;%') OR (T2120.C60900 LIKE '%;17;%') OR (T2120.C60900 LIKE '%;100107;%') OR (T2120.C60900 LIKE '%;2;%') OR (T2120.C60900 L...///Is there a way to get / log the full SQL query? I mean, apart asking the DBA since when we have those logs it's too late to ask them for it.Best regards.Laurent._ARSlist: "Where the Answers Are" and have been for 20 years_-- Sent from Gmail Mobile _ARSlist: "Where the Answers Are" and have been for 20 years__ARSlist: "Where the Answers Are" and have been for 20 years_
