Re: how can i enable arerror.log in remedy 7
Hi, Arerror.log is always turned on. It can not be turned off. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * 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. I think there is no enabling checkbox any thing like that. Just by timestamp you can search. mahmoudshalaby wrote: hi how acan i enable arerror.log in remedy 7 ? -- View this message in context: http://old.nabble.com/how-can-i-enable-arerror.log-in-remedy-7-tp33443323p33448182.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ 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: Remedy Table Recreation
Hi, That is a lot of useful info. Thanks for that. We're working on SQL Server DB Replication for reporting purposes. The reporting DB uses views. When a field is added to a regular/join form, does the view get dropped and recreated or does it get altered? When the DB Replication is ON, we are not being allowed to modify forms using Developer Studio. We're forced to remove the replication, modify forms and then install Replication again. Is there an alternative to this? SQL Server 2008 is what we use. Thanks Radhika +44 20718 20431 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Axton Sent: Wednesday, February 29, 2012 11:57 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy Table Recreation ** The information you provide is always helpful. Thanks to your first response we have what we need to move forward. Axton On Feb 29, 2012 12:06 PM, Mueller, Doug doug_muel...@bmc.com wrote: Axton, OK, the implementation was not carried to the complete degree for Oracle as was originally planned. There is again discussion about why not. For ALL databases, all data tables (T/H/B all have the entry ID as a unique value) and ALL metadata tables (several of the ones you call out you will find have a new column in later releases that provides that unique value) have a unique value that should have unique index on it. Sybase and MS SQL have these unique keys all defined as primary keys. Oracle at this time did not take that final step of defining them as unique keys and just have them as unique indexes. The argument of the team was that the DB replication technology of Sybase and MS SQL required the use of primary keys so we did that. The DB replication technology of Oracle just required a unique indexed field exist so we did that for Oracle and didn't go the last step as it was not required for DB replication. Now, you can of course add the primary key characteristic if you want to all of the tables (and it is being discussed internally). Now, one final challenge for you is that this work has been being done over a couple of releases and it is not fully in place for everyone until the 7.6.04 release. So, you will not have some of the work that was done for Oracle in your 7.5 installation. Sorry for the slightly incorrect information about Oracle and the primary key. We are there with other DBs and at the doorstep with Oracle with unique indexes on every table. I hope this correction is helpful, Doug Mueller -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Axton Sent: Monday, February 27, 2012 1:27 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy Table Recreation We did not see a primary key defined for the T, H, or B tables, or the meta-data tables, so we created a primary key on those tables. We did, however, see a unique index on all the T, H, and B tables. We are rethinking our approach because in later versions of Oracle Streams they added an option to use a unique index, versus an explicit primary key, for replication purposes. I was referred to this KA on my inquiry to support: https://kb.bmc.com/infocenter/index?page=contentid=KA305401 Which, at the end, states: In essence this is not something that is currently available in AR System, the only primary keys added was for Sql Server and Sybase because those were the only two databases that needed primary keys for replication. The thought was that other databases don't need to have primary keys and they can be replicated just with the presence of unique indexes. While this appears to be true today, this was no always the case. This is still not true for some of the meta-data tables because they have neither a unique index or a primary key constraint (e.g., actlink_set_char, actlink_set, filter_notify). While replication can still work on these tables, it forces the database to perform a table scan for each replicated record, comparing the value of every column. The primary key can be defined at the time the table is created or after the table is created and is different from a unique index. Take this DDL from a stock system for table B1: create table b1 ( c1 varchar2(15 byte) not null enable, c158 varchar2(255 byte), co158 number(15,0), cc158 number(15,0)) / create unique index ib1 on b1 (c1) / While this table has a unique constraint through index ib1, it does not have a primary key defined. Compare this to the DDL for the same table with the primary key constraint: create table b1 ( c1 varchar2(15 byte) not null enable, c158 varchar2(255 byte), co158 number(15,0), cc158 number(15,0), constraint sys_pk_3933 primary key (c1) / create unique index ib1 on b1 (c1) / We looked to add this to the ardb.conf at the time a form is created, but that is a no go because the ardb.conf entries only append a suffix to the create table statements,
Re: Remedy Table Recreation
I know on Oracle a view can not be altered. It can only be dropped and created. Not sure if the same applies to MSSQL. On Tue, Mar 6, 2012 at 8:17 AM, Narayanan, Radhika radhika.naraya...@logica.com wrote: ** Hi, That is a lot of useful info. Thanks for that. We’re working on SQL Server DB Replication for reporting purposes. The reporting DB uses views. When a field is added to a regular/join form, does the view get dropped and recreated or does it get altered? When the DB Replication is ON, we are not being allowed to modify forms using Developer Studio. We’re forced to remove the replication, modify forms and then install Replication again. Is there an alternative to this? SQL Server 2008 is what we use. Thanks Radhika +44 20718 20431 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Axton Sent: Wednesday, February 29, 2012 11:57 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy Table Recreation ** The information you provide is always helpful. Thanks to your first response we have what we need to move forward. Axton On Feb 29, 2012 12:06 PM, Mueller, Doug doug_muel...@bmc.com wrote: Axton, OK, the implementation was not carried to the complete degree for Oracle as was originally planned. There is again discussion about why not. For ALL databases, all data tables (T/H/B all have the entry ID as a unique value) and ALL metadata tables (several of the ones you call out you will find have a new column in later releases that provides that unique value) have a unique value that should have unique index on it. Sybase and MS SQL have these unique keys all defined as primary keys. Oracle at this time did not take that final step of defining them as unique keys and just have them as unique indexes. The argument of the team was that the DB replication technology of Sybase and MS SQL required the use of primary keys so we did that. The DB replication technology of Oracle just required a unique indexed field exist so we did that for Oracle and didn't go the last step as it was not required for DB replication. Now, you can of course add the primary key characteristic if you want to all of the tables (and it is being discussed internally). Now, one final challenge for you is that this work has been being done over a couple of releases and it is not fully in place for everyone until the 7.6.04 release. So, you will not have some of the work that was done for Oracle in your 7.5 installation. Sorry for the slightly incorrect information about Oracle and the primary key. We are there with other DBs and at the doorstep with Oracle with unique indexes on every table. I hope this correction is helpful, Doug Mueller -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Axton Sent: Monday, February 27, 2012 1:27 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy Table Recreation We did not see a primary key defined for the T, H, or B tables, or the meta-data tables, so we created a primary key on those tables. We did, however, see a unique index on all the T, H, and B tables. We are rethinking our approach because in later versions of Oracle Streams they added an option to use a unique index, versus an explicit primary key, for replication purposes. I was referred to this KA on my inquiry to support: https://kb.bmc.com/infocenter/index?page=contentid=KA305401 Which, at the end, states: In essence this is not something that is currently available in AR System, the only primary keys added was for Sql Server and Sybase because those were the only two databases that needed primary keys for replication. The thought was that other databases don't need to have primary keys and they can be replicated just with the presence of unique indexes. While this appears to be true today, this was no always the case. This is still not true for some of the meta-data tables because they have neither a unique index or a primary key constraint (e.g., actlink_set_char, actlink_set, filter_notify). While replication can still work on these tables, it forces the database to perform a table scan for each replicated record, comparing the value of every column. The primary key can be defined at the time the table is created or after the table is created and is different from a unique index. Take this DDL from a stock system for table B1: create table b1 ( c1 varchar2(15 byte) not null enable, c158 varchar2(255 byte), co158 number(15,0), cc158 number(15,0)) / create unique index ib1 on b1 (c1) / While this table has a unique constraint through index ib1, it does not have a primary key defined. Compare this to the DDL for the same table with the primary key constraint: create table b1 ( c1 varchar2(15 byte) not null enable, c158 varchar2(255 byte),
Re: Automate Cache Flush - RANT
You obviously didn't read the text of this thread. :) Perhaps you meant to post this to the main Automate Cache Flush thread? - http://www.javasystemsolutions.com/arslist/view/89045563 What is engineering going to do to relieve the effort and time spent by your customers in managing this flush process? It is too cumbersome, slow, and painful as it stands today. Please refer to the start of this thread - Automate Cache Flush - RANT - http://www.javasystemsolutions.com/arslist/view/89045588 Regards, Andrew Goodall Software Engineer 2 | Development Services | jcpenney . www.jcp.com -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of SUBSCRIBE arslist Jimmy Wu Sent: Monday, March 05, 2012 4:36 PM To: arslist@ARSLIST.ORG Subject: Re: Automate Cache Flush - RANT Yes, Remedy eng is watching on this list. Actually it is not difficult to do the automate cache flush at all. You can create a jsp file (say flushAllCache.jsp) like below and put it in mid-tier/shared directory, then you can involve the Flush command by this dos prompt (Unix version could be different, but similar) start http://mid-tier_host:port#/arsys/shared/flushAllCache.jsp Regards, Jimmy. =flushAllCache.jsp %@ page contentType=text/html;charset=UTF-8 language=java % %@ page import=com.remedy.arsys.share.Cache % %@ page import=com.remedy.arsys.prefetch.PrefetchTask % % Cache.flush(false, null); //PluginFactory.cleanup(); PrefetchTask.schedule(PrefetchTask.PREFETCH_DELAY); //restart prefetch on cache flush % html head All Server caches flushed. /head bodytitleBMC Remedy Mid Tier - Flush Mid-Tier Cache/title/body /html ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are font face=monospacesize=-3brThe information transmitted is intended only for the person or entity to which it is addressed and brmay contain confidential and/or privileged material. If the reader of this message is not the intendedbrrecipient, you are hereby notified that your access is unauthorized, and any review, dissemination,brdistribution or copying of this message including any attachments is strictly prohibited. If you are notbrthe intended recipient, please contact the sender and delete the material from any computer.br ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Remedy Table Recreation
I don't think every supported database has the CREATE OR REPLACE VIEW syntax, so I believe the system drops and creates a new view. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Axton Sent: Tuesday, March 06, 2012 8:52 AM To: arslist@ARSLIST.ORG Subject: Re: Remedy Table Recreation I know on Oracle a view can not be altered. It can only be dropped and created. Not sure if the same applies to MSSQL. -Original Message- On Tue, Mar 6, 2012 at 8:17 AM, Narayanan, Radhika wrote: ** Hi, That is a lot of useful info. Thanks for that. We're working on SQL Server DB Replication for reporting purposes. The reporting DB uses views. When a field is added to a regular/join form, does the view get dropped and recreated or does it get altered? When the DB Replication is ON, we are not being allowed to modify forms using Developer Studio. We're forced to remove the replication, modify forms and then install Replication again. Is there an alternative to this? SQL Server 2008 is what we use. Thanks Radhika +44 20718 20431 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Axton Sent: Wednesday, February 29, 2012 11:57 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy Table Recreation ** The information you provide is always helpful. Thanks to your first response we have what we need to move forward. Axton -Original Message- On Feb 29, 2012 12:06 PM, Mueller, Doug wrote: Axton, OK, the implementation was not carried to the complete degree for Oracle as was originally planned. There is again discussion about why not. For ALL databases, all data tables (T/H/B all have the entry ID as a unique value) and ALL metadata tables (several of the ones you call out you will find have a new column in later releases that provides that unique value) have a unique value that should have unique index on it. Sybase and MS SQL have these unique keys all defined as primary keys. Oracle at this time did not take that final step of defining them as unique keys and just have them as unique indexes. The argument of the team was that the DB replication technology of Sybase and MS SQL required the use of primary keys so we did that. The DB replication technology of Oracle just required a unique indexed field exist so we did that for Oracle and didn't go the last step as it was not required for DB replication. Now, you can of course add the primary key characteristic if you want to all of the tables (and it is being discussed internally). Now, one final challenge for you is that this work has been being done over a couple of releases and it is not fully in place for everyone until the 7.6.04 release. So, you will not have some of the work that was done for Oracle in your 7.5 installation. Sorry for the slightly incorrect information about Oracle and the primary key. We are there with other DBs and at the doorstep with Oracle with unique indexes on every table. I hope this correction is helpful, Doug Mueller -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Axton Sent: Monday, February 27, 2012 1:27 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy Table Recreation We did not see a primary key defined for the T, H, or B tables, or the meta-data tables, so we created a primary key on those tables. We did, however, see a unique index on all the T, H, and B tables. We are rethinking our approach because in later versions of Oracle Streams they added an option to use a unique index, versus an explicit primary key, for replication purposes. I was referred to this KA on my inquiry to support: https://kb.bmc.com/infocenter/index?page=contentid=KA305401 Which, at the end, states: In essence this is not something that is currently available in AR System, the only primary keys added was for Sql Server and Sybase because those were the only two databases that needed primary keys for replication. The thought was that other databases don't need to have primary keys and they can be replicated just with the presence of unique indexes. While this appears to be true today, this was no always the case. This is still not true for some of the meta-data tables because they have neither a unique index or a primary key constraint (e.g., actlink_set_char, actlink_set, filter_notify). While replication can still work on these tables, it forces the database to perform a table scan for each replicated record, comparing the value of every column. The primary key can be defined at the time the table is created or after the table is created and is different from a unique index. Take this DDL from a stock system for table B1: create table b1 ( c1 varchar2(15 byte) not null enable, c158 varchar2(255
Re: Remedy Table Recreation
CREATE or REPLACE is available only in Oracle to the best of my knowledge. I haven't tried it on MS-SQL. The AR System however does not use CREATE or REPLACE even if the underlying DB is Oracle. It just does a DROP VIEW and then a CREATE. Joe -Original Message- From: Grooms, Frederick W Sent: Tuesday, March 06, 2012 10:02 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Remedy Table Recreation I don't think every supported database has the CREATE OR REPLACE VIEW syntax, so I believe the system drops and creates a new view. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Axton Sent: Tuesday, March 06, 2012 8:52 AM To: arslist@ARSLIST.ORG Subject: Re: Remedy Table Recreation I know on Oracle a view can not be altered. It can only be dropped and created. Not sure if the same applies to MSSQL. -Original Message- On Tue, Mar 6, 2012 at 8:17 AM, Narayanan, Radhika wrote: ** Hi, That is a lot of useful info. Thanks for that. We're working on SQL Server DB Replication for reporting purposes. The reporting DB uses views. When a field is added to a regular/join form, does the view get dropped and recreated or does it get altered? When the DB Replication is ON, we are not being allowed to modify forms using Developer Studio. We're forced to remove the replication, modify forms and then install Replication again. Is there an alternative to this? SQL Server 2008 is what we use. Thanks Radhika +44 20718 20431 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Axton Sent: Wednesday, February 29, 2012 11:57 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy Table Recreation ** The information you provide is always helpful. Thanks to your first response we have what we need to move forward. Axton -Original Message- On Feb 29, 2012 12:06 PM, Mueller, Doug wrote: Axton, OK, the implementation was not carried to the complete degree for Oracle as was originally planned. There is again discussion about why not. For ALL databases, all data tables (T/H/B all have the entry ID as a unique value) and ALL metadata tables (several of the ones you call out you will find have a new column in later releases that provides that unique value) have a unique value that should have unique index on it. Sybase and MS SQL have these unique keys all defined as primary keys. Oracle at this time did not take that final step of defining them as unique keys and just have them as unique indexes. The argument of the team was that the DB replication technology of Sybase and MS SQL required the use of primary keys so we did that. The DB replication technology of Oracle just required a unique indexed field exist so we did that for Oracle and didn't go the last step as it was not required for DB replication. Now, you can of course add the primary key characteristic if you want to all of the tables (and it is being discussed internally). Now, one final challenge for you is that this work has been being done over a couple of releases and it is not fully in place for everyone until the 7.6.04 release. So, you will not have some of the work that was done for Oracle in your 7.5 installation. Sorry for the slightly incorrect information about Oracle and the primary key. We are there with other DBs and at the doorstep with Oracle with unique indexes on every table. I hope this correction is helpful, Doug Mueller -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Axton Sent: Monday, February 27, 2012 1:27 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy Table Recreation We did not see a primary key defined for the T, H, or B tables, or the meta-data tables, so we created a primary key on those tables. We did, however, see a unique index on all the T, H, and B tables. We are rethinking our approach because in later versions of Oracle Streams they added an option to use a unique index, versus an explicit primary key, for replication purposes. I was referred to this KA on my inquiry to support: https://kb.bmc.com/infocenter/index?page=contentid=KA305401 Which, at the end, states: In essence this is not something that is currently available in AR System, the only primary keys added was for Sql Server and Sybase because those were the only two databases that needed primary keys for replication. The thought was that other databases don't need to have primary keys and they can be replicated just with the presence of unique indexes. While this appears to be true today, this was no always the case. This is still not true for some of the meta-data tables because they have neither a unique index or a primary key constraint (e.g., actlink_set_char, actlink_set, filter_notify). While replication can still work on these tables, it
Trying to build a view form to a Remote Oracle DB from a Remedy SQL DB
I have a need to build a view form to a table on a Remote Oracle DB 10g from our ARS 7.1.06 running sql 2005 DB server Has anyone been sucessful doing this? We created the DBlink between the 2 dbs and we are able to connect from the sql server via other tools like odbc or sql plus and see the table on oracle db. ARAdmin is the oracle table owner and has read/write access, (I am still scptical) attempted to create the view using the parameter LINK.DATABASE.TABLEOWNER.TABLE and I always recieve the error in the Admin tool Failure during SQL operation to the database : CMS_TEST.CMSTEST.ARADMIN.REMEDY_CASES (ARERR 552) SQL Log posts this error *** ERROR *** Invalid use of schema or catalog for OLE DB provider MSDASQL for linked server CMS_TEST. A four-part name was supplied, but the provider does not expose the necessary interfaces to use a catalog or schema. (SQL Server 7312) I have worked with BMC Support and they back up all of our configuration and settings in the ar.cfg file, and all other system settings. Any Ideas? -- Gary Dries OSSNMS / Sr. Remedy Developer T-Mobile USA Office (972) 464-3235 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
JOB: Contract to Perm Remedy Opp in Chantilly, Va
Good Afternoon I wanted to reach out and see if anyone here is actively in the job market. I currently have 8 different level BMC Remedy Positions Including Developers, Architects, Engineers, Administrators, BladeLogic Consultants and Remedy SME opportunities in Chantilly, VA . Please e mail me if you are interested in any of these opportunities and I can give you more information about the individual positions. **If you are not in the job market but have a friend who is, please pass on my contact information and hopefully i can help them get a job and maybe even get you a referral bonus for helping us out !! ** Have a great day ! Thanks, Annie anne.vie...@elevatets.com 774-201-1399 ANNE VIEIRA Client Delivery Executive Elevate Technology Solutions anne.vie...@elevatets.com m 774-201-1399 w elevatets.com 'Exceeding Expectations - Raising the Bar' Elevate is now on Facebook, Twitter, and Linked in! ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Trying to build a view form to a Remote Oracle DB from a Remedy SQL DB
Hi Gary, According to my experience, creating a view form on a db link does not work well. What I usually do in that case is creating an SQL view, in the DB direclty, that will use the db link; and then create the view form on the SQL view. Best regards, Jean-Louis Halleux -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Gary Dries Sent: mardi 6 mars 2012 16:44 To: arslist@ARSLIST.ORG Subject: Trying to build a view form to a Remote Oracle DB from a Remedy SQL DB I have a need to build a view form to a table on a Remote Oracle DB 10g from our ARS 7.1.06 running sql 2005 DB server Has anyone been sucessful doing this? We created the DBlink between the 2 dbs and we are able to connect from the sql server via other tools like odbc or sql plus and see the table on oracle db. ARAdmin is the oracle table owner and has read/write access, (I am still scptical) attempted to create the view using the parameter LINK.DATABASE.TABLEOWNER.TABLE and I always recieve the error in the Admin tool Failure during SQL operation to the database : CMS_TEST.CMSTEST.ARADMIN.REMEDY_CASES (ARERR 552) SQL Log posts this error *** ERROR *** Invalid use of schema or catalog for OLE DB provider MSDASQL for linked server CMS_TEST. A four-part name was supplied, but the provider does not expose the necessary interfaces to use a catalog or schema. (SQL Server 7312) I have worked with BMC Support and they back up all of our configuration and settings in the ar.cfg file, and all other system settings. Any Ideas? -- Gary Dries OSSNMS / Sr. Remedy Developer T-Mobile USA Office (972) 464-3235 ___ 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
Date Push field question
Hi All, I have an date/time field on Form A and want to push only the date to a character field on Form B. The push field is creating a new record on Form B. Not sure how to build the string. Any suggests would be much appreciated. Thanks Mark Mark Brittain Remedy Developer ITILv3 Foundation NaviSite - A Time Warner Cable Company mbritt...@navisite.com Office: 315-453-2912 x5335 Mobile: 315-317-2897 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 attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Date Push field question
Mark, Easiest way I can think would be to create a display only date only field on form B, then have a filter that fires on submit that does a setfield from that field to your Char field.that way Remedy is doing the translation for you. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Brittain, Mark Sent: Tuesday, March 06, 2012 9:19 AM To: arslist@ARSLIST.ORG Subject: Date Push field question ** Hi All, I have an date/time field on Form A and want to push only the date to a character field on Form B. The push field is creating a new record on Form B. Not sure how to build the string. Any suggests would be much appreciated. Thanks Mark Mark Brittain Remedy Developer ITILv3 Foundation NaviSite - A Time Warner Cable Company mbritt...@navisite.com Office: 315-453-2912 x5335 Mobile: 315-317-2897 _ 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. _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
Strange behavior - Mid Tier related..
We are on ARS 7.6.03 (Mid-Tier of the same version) and basically an all round windows shop.. The IE versions on our clients is 7.0.5730.13. This happens on only a few of our clients and we haven’t able to isolate the difference that may be causing this problem. Strictly speaking, all of our clients are supposed to be identical in terms of versions, settings etc. There shouldn’t really be a difference on any of them. However on some of the clients, when the user double clicks on an entry from the Overview Console, the new window opens only for a brief fraction of a second and shuts down. There is no error or warning on why it shuts itself down – it just does. There is nothing written to the event log. However on the clients that this behavior manifests, if the user holds down the CTRL key and then double clicks the entry, the new window opens and stays open – no problems.. Any of you’ll have experienced this and found a fix for it? Apparently we had opened a ticket with BMC Support, who could not find a fix for this as they were not able to get to the cause of the problem and that ticket was closed unresolved. Joe ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Re : Re : too many Migrator errors.
Hi Frex, Maybe I am coming too late on this discussion. I would like to share some inputs. I work with Migrator since many years and all version against almost all ARS servers. Yes sometimes it's hard to make it running as we want (I mean as we imagine to want), but in my experience usually it's because we forgot something on the Migrator configuration or in the sequence we want to use it. In your case, hoping to help you, I suggest to check the following: If you are migrating objects - - Migrate regular forms before joins. - Migrate FLT and AL before respective Guides - Check the Option to not migrate any DATA. - etc... I am quite sure you did check this. If you are confident with the objects you are migrating, make sure to disable all required objects on the Migrator Options (Migration/Required Objects). This will make faster and easier the migration...but you must secure the source objects (make sure to have the right ones). Make sure the source server is allowing unqualified search (permissions for AL and forms are depending on this option in your server configuration because it queries the Groups). When migrating data: Keep in mind the DATA model you want to change and make sure you understand how the IDs are managed (it works in a similar way as AR Import). Also Keep in mind that Migrator is doing a Merge, so all workflow triggering on Merge may fire...so you will have a Filter Limitation... Usually, you have to set the option to avoid workflow firing. But I use to add a filter that bypasses all workflow (goto ). After a migration, run a difference report to make sure nothing was forgotten. There are several things like that to double check, but once this is done, Migrator is a powerfull tool and it works fine. Additionally, it provides a detailed migration report which helps a lot to understand what run wrong, writen in an ARS language. Hope this helps. Cheers ilidio Moreira da Silva Silogis International SA Zurich - Switzerland Le 03-Mar-12 5:46 PM, Frex Popo a écrit : ** Yes heard about it but never had time to look at it... but now could be the time. :) Thanks *De :* Rick Cook remedyr...@gmail.com *À :* arslist@ARSLIST.ORG *Envoyé le :* Vendredi 2 mars 2012 12h29 *Objet :* Re: Re : too many Migrator errors. ** Frex, I find it amazing that errors like these have existed in the product for years, and have not been addressed. I like a lot of BMC's applications, but this one needs a complete rearchitecture. Try Panacea, or any of the other tools developed with this century's technology. Rick On Mar 1, 2012 2:54 PM, Frex Popo frexp...@yahoo.fr mailto:frexp...@yahoo.fr wrote: _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Date Push field question - SOLVED
Thanks LJ. Turns out it was simple. Just need to use DATE function like DATE($Date/Time Field$) which strips out the time portion. Didn't see it on the bottom of the previous page in the basic guide. Mark From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: Tuesday, March 06, 2012 11:40 AM To: arslist@ARSLIST.ORG Subject: Re: Date Push field question ** Mark, Easiest way I can think would be to create a display only date only field on form B, then have a filter that fires on submit that does a setfield from that field to your Char field...that way Remedy is doing the translation for you. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Brittain, Mark Sent: Tuesday, March 06, 2012 9:19 AM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Date Push field question ** Hi All, I have an date/time field on Form A and want to push only the date to a character field on Form B. The push field is creating a new record on Form B. Not sure how to build the string. Any suggests would be much appreciated. Thanks Mark Mark Brittain Remedy Developer ITILv3 Foundation NaviSite - A Time Warner Cable Company mbritt...@navisite.commailto:mbritt...@navisite.com Office: 315-453-2912 x5335 Mobile: 315-317-2897 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. _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Strange behavior - Mid Tier related..
Joe, I’m assuming that you have done a cache clear and such on the affected machines and no difference? From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Tuesday, March 06, 2012 10:10 AM To: arslist@ARSLIST.ORG Subject: Strange behavior - Mid Tier related.. ** We are on ARS 7.6.03 (Mid-Tier of the same version) and basically an all round windows shop.. The IE versions on our clients is 7.0.5730.13. This happens on only a few of our clients and we haven’t able to isolate the difference that may be causing this problem. Strictly speaking, all of our clients are supposed to be identical in terms of versions, settings etc. There shouldn’t really be a difference on any of them. However on some of the clients, when the user double clicks on an entry from the Overview Console, the new window opens only for a brief fraction of a second and shuts down. There is no error or warning on why it shuts itself down – it just does. There is nothing written to the event log. However on the clients that this behavior manifests, if the user holds down the CTRL key and then double clicks the entry, the new window opens and stays open – no problems.. Any of you’ll have experienced this and found a fix for it? Apparently we had opened a ticket with BMC Support, who could not find a fix for this as they were not able to get to the cause of the problem and that ticket was closed unresolved. Joe _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Strange behavior - Mid Tier related..
Yup... List of things already done.. 1) Cache cleared on local browsers 2) Compared browsers Advanced Settings 3) Compared other browser settings (pop ups, security, etc.) 4) Checked the PC’s Event Viewer for any possible errors and found none. Everything seems to check out.. Joe From: LJ LongWing Sent: Tuesday, March 06, 2012 12:34 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Strange behavior - Mid Tier related.. ** Joe, I’m assuming that you have done a cache clear and such on the affected machines and no difference? From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Tuesday, March 06, 2012 10:10 AM To: arslist@ARSLIST.ORG Subject: Strange behavior - Mid Tier related.. ** We are on ARS 7.6.03 (Mid-Tier of the same version) and basically an all round windows shop.. The IE versions on our clients is 7.0.5730.13. This happens on only a few of our clients and we haven’t able to isolate the difference that may be causing this problem. Strictly speaking, all of our clients are supposed to be identical in terms of versions, settings etc. There shouldn’t really be a difference on any of them. However on some of the clients, when the user double clicks on an entry from the Overview Console, the new window opens only for a brief fraction of a second and shuts down. There is no error or warning on why it shuts itself down – it just does. There is nothing written to the event log. However on the clients that this behavior manifests, if the user holds down the CTRL key and then double clicks the entry, the new window opens and stays open – no problems.. Any of you’ll have experienced this and found a fix for it? Apparently we had opened a ticket with BMC Support, who could not find a fix for this as they were not able to get to the cause of the problem and that ticket was closed unresolved. Joe ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Strange behavior - Mid Tier related..
Browser plugins can also wreak havoc on browser behavior. You may try checking, and possibly disabling, all the browser plugins on the machines that have issues and see if that fixes things. Axton Grams On Tue, Mar 6, 2012 at 11:44 AM, Joe Martin D'Souza jdso...@shyle.net wrote: ** Yup... List of things already done.. 1) Cache cleared on local browsers 2) Compared browsers Advanced Settings 3) Compared other browser settings (pop ups, security, etc.) 4) Checked the PC’s Event Viewer for any possible errors and found none. Everything seems to check out.. Joe From: LJ LongWing Sent: Tuesday, March 06, 2012 12:34 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Strange behavior - Mid Tier related.. ** Joe, I’m assuming that you have done a cache clear and such on the affected machines and no difference? From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Tuesday, March 06, 2012 10:10 AM To: arslist@ARSLIST.ORG Subject: Strange behavior - Mid Tier related.. ** We are on ARS 7.6.03 (Mid-Tier of the same version) and basically an all round windows shop.. The IE versions on our clients is 7.0.5730.13. This happens on only a few of our clients and we haven’t able to isolate the difference that may be causing this problem. Strictly speaking, all of our clients are supposed to be identical in terms of versions, settings etc. There shouldn’t really be a difference on any of them. However on some of the clients, when the user double clicks on an entry from the Overview Console, the new window opens only for a brief fraction of a second and shuts down. There is no error or warning on why it shuts itself down – it just does. There is nothing written to the event log. However on the clients that this behavior manifests, if the user holds down the CTRL key and then double clicks the entry, the new window opens and stays open – no problems.. Any of you’ll have experienced this and found a fix for it? Apparently we had opened a ticket with BMC Support, who could not find a fix for this as they were not able to get to the cause of the problem and that ticket was closed unresolved. Joe _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Strange behavior - Mid Tier related..
Did you try installing a different browser may be firefox and see if it is just related to IE or across the board. I had this complaint before but that user was using google toolbar and he has to manually disable popup blocker from the google tool bar apart from IE settings. But since you already mentioned you compared browsers already with other clients I guess this might not be the cause. On Tuesday, March 6, 2012 11:10:09 AM UTC-6, Joe Martin D'Souza wrote: ** We are on ARS 7.6.03 (Mid-Tier of the same version) and basically an all round windows shop.. The IE versions on our clients is 7.0.5730.13. This happens on only a few of our clients and we haven’t able to isolate the difference that may be causing this problem. Strictly speaking, all of our clients are supposed to be identical in terms of versions, settings etc. There shouldn’t really be a difference on any of them. However on some of the clients, when the user double clicks on an entry from the Overview Console, the new window opens only for a brief fraction of a second and shuts down. There is no error or warning on why it shuts itself down – it just does. There is nothing written to the event log. However on the clients that this behavior manifests, if the user holds down the CTRL key and then double clicks the entry, the new window opens and stays open – no problems.. Any of you’ll have experienced this and found a fix for it? Apparently we had opened a ticket with BMC Support, who could not find a fix for this as they were not able to get to the cause of the problem and that ticket was closed unresolved. Joe _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Trying to build a view form to a Remote Oracle DB from a Remedy SQL DB
Gary, Jean-Louis is correct. I am trying the same thing on ARS 7.6.03. Had the DBA create a Linked Server on MS SQL using DTS. I created a view in the ARSystem database using MS SQL Server management Studio. SELECT CAST(CONTROL_UNIQUE_ID AS int) AS UNIQUE_ID, CAST(CONTROL_NUM AS varchar) AS Control_Num, CAST(PLANT_CODE AS varchar) AS Plant_Code FROM LINKNAME..DATABASENAME.TABLENAME AS TABLENAME_1 I could then create an ARSystem View Form but that is as far as I got. I can query either view in MS SQL Studio and get results but not from the WUT running a search on the View Form. I even tried a Direct SQL set fields action with no luck. I'll post more if I get something working. --- John J. Reiser Remedy Developer/Administrator Senior Software Development Analyst Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Halleux, Jean-Louis Sent: Tuesday, March 06, 2012 11:04 AM To: arslist@ARSLIST.ORG Subject: EXTERNAL: Re: Trying to build a view form to a Remote Oracle DB from a Remedy SQL DB Hi Gary, According to my experience, creating a view form on a db link does not work well. What I usually do in that case is creating an SQL view, in the DB direclty, that will use the db link; and then create the view form on the SQL view. Best regards, Jean-Louis Halleux -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Gary Dries Sent: mardi 6 mars 2012 16:44 To: arslist@ARSLIST.ORG Subject: Trying to build a view form to a Remote Oracle DB from a Remedy SQL DB I have a need to build a view form to a table on a Remote Oracle DB 10g from our ARS 7.1.06 running sql 2005 DB server Has anyone been sucessful doing this? We created the DBlink between the 2 dbs and we are able to connect from the sql server via other tools like odbc or sql plus and see the table on oracle db. ARAdmin is the oracle table owner and has read/write access, (I am still scptical) attempted to create the view using the parameter LINK.DATABASE.TABLEOWNER.TABLE and I always recieve the error in the Admin tool Failure during SQL operation to the database : CMS_TEST.CMSTEST.ARADMIN.REMEDY_CASES (ARERR 552) SQL Log posts this error *** ERROR *** Invalid use of schema or catalog for OLE DB provider MSDASQL for linked server CMS_TEST. A four-part name was supplied, but the provider does not expose the necessary interfaces to use a catalog or schema. (SQL Server 7312) I have worked with BMC Support and they back up all of our configuration and settings in the ar.cfg file, and all other system settings. Any Ideas? -- Gary Dries OSSNMS / Sr. Remedy Developer T-Mobile USA Office (972) 464-3235 ___ 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 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Strange behavior - Mid Tier related..
Are you running best practice views or classic? It could be related to pop up blockers. Sent from my iPhone On Mar 6, 2012, at 12:22 PM, Joe Martin D'Souza jdso...@shyle.net wrote: ** We are on ARS 7.6.03 (Mid-Tier of the same version) and basically an all round windows shop.. The IE versions on our clients is 7.0.5730.13. This happens on only a few of our clients and we haven’t able to isolate the difference that may be causing this problem. Strictly speaking, all of our clients are supposed to be identical in terms of versions, settings etc. There shouldn’t really be a difference on any of them. However on some of the clients, when the user double clicks on an entry from the Overview Console, the new window opens only for a brief fraction of a second and shuts down. There is no error or warning on why it shuts itself down – it just does. There is nothing written to the event log. However on the clients that this behavior manifests, if the user holds down the CTRL key and then double clicks the entry, the new window opens and stays open – no problems.. Any of you’ll have experienced this and found a fix for it? Apparently we had opened a ticket with BMC Support, who could not find a fix for this as they were not able to get to the cause of the problem and that ticket was closed unresolved. Joe _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Strange behavior - Mid Tier related..
Ok….trying to help you with this…. Ctrl-Click in IE gives you an ‘open in new tab’ functionality ‘explicitly’…..so….based on other comments, it does sound like it may be a popup blocker of some sort that’s killing the window…I know several toolbars have that ability….any toolbars installed? From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Tuesday, March 06, 2012 10:44 AM To: arslist@ARSLIST.ORG Subject: Re: Strange behavior - Mid Tier related.. ** Yup... List of things already done.. 1) Cache cleared on local browsers 2) Compared browsers Advanced Settings 3) Compared other browser settings (pop ups, security, etc.) 4) Checked the PC’s Event Viewer for any possible errors and found none. Everything seems to check out.. Joe From: LJ LongWing mailto:lj.longw...@gmail.com Sent: Tuesday, March 06, 2012 12:34 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Strange behavior - Mid Tier related.. ** Joe, I’m assuming that you have done a cache clear and such on the affected machines and no difference? From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Tuesday, March 06, 2012 10:10 AM To: arslist@ARSLIST.ORG Subject: Strange behavior - Mid Tier related.. ** We are on ARS 7.6.03 (Mid-Tier of the same version) and basically an all round windows shop.. The IE versions on our clients is 7.0.5730.13. This happens on only a few of our clients and we haven’t able to isolate the difference that may be causing this problem. Strictly speaking, all of our clients are supposed to be identical in terms of versions, settings etc. There shouldn’t really be a difference on any of them. However on some of the clients, when the user double clicks on an entry from the Overview Console, the new window opens only for a brief fraction of a second and shuts down. There is no error or warning on why it shuts itself down – it just does. There is nothing written to the event log. However on the clients that this behavior manifests, if the user holds down the CTRL key and then double clicks the entry, the new window opens and stays open – no problems.. Any of you’ll have experienced this and found a fix for it? Apparently we had opened a ticket with BMC Support, who could not find a fix for this as they were not able to get to the cause of the problem and that ticket was closed unresolved. Joe _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Strange behavior - Mid Tier related..
Axton, Pat, You guys were right on the money about the plugins being the issue! Turned out to be one of the Google addon called Google Toolbar and it now works! The other 2 Google addons Google Toolbar Helper Google Toolbar Notifier BHO does not impact my machine.. I’ll need to pass this information to the others that have this problem and hopefully this should resolve their problems too! Thank you so much for this information!! Joe From: patchsk Sent: Tuesday, March 06, 2012 12:53 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Strange behavior - Mid Tier related.. ** Did you try installing a different browser may be firefox and see if it is just related to IE or across the board. I had this complaint before but that user was using google toolbar and he has to manually disable popup blocker from the google tool bar apart from IE settings. But since you already mentioned you compared browsers already with other clients I guess this might not be the cause. On Tuesday, March 6, 2012 11:10:09 AM UTC-6, Joe Martin D'Souza wrote: ** We are on ARS 7.6.03 (Mid-Tier of the same version) and basically an all round windows shop.. The IE versions on our clients is 7.0.5730.13. This happens on only a few of our clients and we haven’t able to isolate the difference that may be causing this problem. Strictly speaking, all of our clients are supposed to be identical in terms of versions, settings etc. There shouldn’t really be a difference on any of them. However on some of the clients, when the user double clicks on an entry from the Overview Console, the new window opens only for a brief fraction of a second and shuts down. There is no error or warning on why it shuts itself down – it just does. There is nothing written to the event log. However on the clients that this behavior manifests, if the user holds down the CTRL key and then double clicks the entry, the new window opens and stays open – no problems.. Any of you’ll have experienced this and found a fix for it? Apparently we had opened a ticket with BMC Support, who could not find a fix for this as they were not able to get to the cause of the problem and that ticket was closed unresolved. Joe ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Trying to build a view form to a Remote Oracle DB from a Remedy SQL DB
John, Have you checked the SQL log when doing the search (Open the Form in the User Tool, Turn on the SQL log, Try the search, Turn off the log) and you can then see exactly what SQL the system is trying to run. It may have something to do with the CAST and if you have the fields set for Leading, Anywhere, or Exact QBE matching. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Reiser, John J Sent: Tuesday, March 06, 2012 12:07 PM To: arslist@ARSLIST.ORG Subject: Re: Trying to build a view form to a Remote Oracle DB from a Remedy SQL DB Gary, Jean-Louis is correct. I am trying the same thing on ARS 7.6.03. Had the DBA create a Linked Server on MS SQL using DTS. I created a view in the ARSystem database using MS SQL Server management Studio. SELECT CAST(CONTROL_UNIQUE_ID AS int) AS UNIQUE_ID, CAST(CONTROL_NUM AS varchar) AS Control_Num, CAST(PLANT_CODE AS varchar) AS Plant_Code FROM LINKNAME..DATABASENAME.TABLENAME AS TABLENAME_1 I could then create an ARSystem View Form but that is as far as I got. I can query either view in MS SQL Studio and get results but not from the WUT running a search on the View Form. I even tried a Direct SQL set fields action with no luck. I'll post more if I get something working. --- John J. Reiser Remedy Developer/Administrator Senior Software Development Analyst Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Halleux, Jean-Louis Sent: Tuesday, March 06, 2012 11:04 AM To: arslist@ARSLIST.ORG Subject: EXTERNAL: Re: Trying to build a view form to a Remote Oracle DB from a Remedy SQL DB Hi Gary, According to my experience, creating a view form on a db link does not work well. What I usually do in that case is creating an SQL view, in the DB direclty, that will use the db link; and then create the view form on the SQL view. Best regards, Jean-Louis Halleux -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Gary Dries Sent: mardi 6 mars 2012 16:44 To: arslist@ARSLIST.ORG Subject: Trying to build a view form to a Remote Oracle DB from a Remedy SQL DB I have a need to build a view form to a table on a Remote Oracle DB 10g from our ARS 7.1.06 running sql 2005 DB server Has anyone been sucessful doing this? We created the DBlink between the 2 dbs and we are able to connect from the sql server via other tools like odbc or sql plus and see the table on oracle db. ARAdmin is the oracle table owner and has read/write access, (I am still scptical) attempted to create the view using the parameter LINK.DATABASE.TABLEOWNER.TABLE and I always recieve the error in the Admin tool Failure during SQL operation to the database : CMS_TEST.CMSTEST.ARADMIN.REMEDY_CASES (ARERR 552) SQL Log posts this error *** ERROR *** Invalid use of schema or catalog for OLE DB provider MSDASQL for linked server CMS_TEST. A four-part name was supplied, but the provider does not expose the necessary interfaces to use a catalog or schema. (SQL Server 7312) I have worked with BMC Support and they back up all of our configuration and settings in the ar.cfg file, and all other system settings. Any Ideas? -- Gary Dries OSSNMS / Sr. Remedy Developer T-Mobile USA Office (972) 464-3235 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Trying to build a view form to a Remote Oracle DB from a Remedy SQL DB
Thanks for the insight, this is definitely an option. The main concern with this solution is that I am not the SQL DBA and do not have and admin access to the DB or application servers, so I am now dependant on 3 parties to help support this process (myself, Oracle DBA, SQL DBA), plus it adds another point of failure. My main goal was to control as much of the process at the application level and let ARS do what it is designed to do. I have built a dblink and a view form from remedy to a remote db in the past, about 6 years ago, but in a different configuration ARS on Oracle and the external db on SQL and that worked with any issues at all. The difference was not only the order of the db servers but I also had full Server Admin rights, where I am at now, I do not have the elevated privileges. On 3/6/12, Reiser, John J john.j.rei...@lmco.com wrote: Gary, Jean-Louis is correct. I am trying the same thing on ARS 7.6.03. Had the DBA create a Linked Server on MS SQL using DTS. I created a view in the ARSystem database using MS SQL Server management Studio. SELECT CAST(CONTROL_UNIQUE_ID AS int) AS UNIQUE_ID, CAST(CONTROL_NUM AS varchar) AS Control_Num, CAST(PLANT_CODE AS varchar) AS Plant_Code FROM LINKNAME..DATABASENAME.TABLENAME AS TABLENAME_1 I could then create an ARSystem View Form but that is as far as I got. I can query either view in MS SQL Studio and get results but not from the WUT running a search on the View Form. I even tried a Direct SQL set fields action with no luck. I'll post more if I get something working. --- John J. Reiser Remedy Developer/Administrator Senior Software Development Analyst Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Halleux, Jean-Louis Sent: Tuesday, March 06, 2012 11:04 AM To: arslist@ARSLIST.ORG Subject: EXTERNAL: Re: Trying to build a view form to a Remote Oracle DB from a Remedy SQL DB Hi Gary, According to my experience, creating a view form on a db link does not work well. What I usually do in that case is creating an SQL view, in the DB direclty, that will use the db link; and then create the view form on the SQL view. Best regards, Jean-Louis Halleux -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Gary Dries Sent: mardi 6 mars 2012 16:44 To: arslist@ARSLIST.ORG Subject: Trying to build a view form to a Remote Oracle DB from a Remedy SQL DB I have a need to build a view form to a table on a Remote Oracle DB 10g from our ARS 7.1.06 running sql 2005 DB server Has anyone been sucessful doing this? We created the DBlink between the 2 dbs and we are able to connect from the sql server via other tools like odbc or sql plus and see the table on oracle db. ARAdmin is the oracle table owner and has read/write access, (I am still scptical) attempted to create the view using the parameter LINK.DATABASE.TABLEOWNER.TABLE and I always recieve the error in the Admin tool Failure during SQL operation to the database : CMS_TEST.CMSTEST.ARADMIN.REMEDY_CASES (ARERR 552) SQL Log posts this error *** ERROR *** Invalid use of schema or catalog for OLE DB provider MSDASQL for linked server CMS_TEST. A four-part name was supplied, but the provider does not expose the necessary interfaces to use a catalog or schema. (SQL Server 7312) I have worked with BMC Support and they back up all of our configuration and settings in the ar.cfg file, and all other system settings. Any Ideas? -- Gary Dries OSSNMS / Sr. Remedy Developer T-Mobile USA Office (972) 464-3235 ___ 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 ___ 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: Strange behavior - Mid Tier related..
Initially I thought it was pop-up blockers too – but considering it wasn’t a popup but a new window I had my doubts... It was the plugins as Axton and Pat pointed out.. Thank you all for sharing your thoughts experiences.. Appreciate it.. Learnt one more thing today! Joe From: LJ LongWing Sent: Tuesday, March 06, 2012 1:11 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Strange behavior - Mid Tier related.. ** Ok….trying to help you with this…. Ctrl-Click in IE gives you an ‘open in new tab’ functionality ‘explicitly’…..so….based on other comments, it does sound like it may be a popup blocker of some sort that’s killing the window…I know several toolbars have that ability….any toolbars installed? From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Tuesday, March 06, 2012 10:44 AM To: arslist@ARSLIST.ORG Subject: Re: Strange behavior - Mid Tier related.. ** Yup... List of things already done.. 1) Cache cleared on local browsers 2) Compared browsers Advanced Settings 3) Compared other browser settings (pop ups, security, etc.) 4) Checked the PC’s Event Viewer for any possible errors and found none. Everything seems to check out.. Joe From: LJ LongWing Sent: Tuesday, March 06, 2012 12:34 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Strange behavior - Mid Tier related.. ** Joe, I’m assuming that you have done a cache clear and such on the affected machines and no difference? From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Tuesday, March 06, 2012 10:10 AM To: arslist@ARSLIST.ORG Subject: Strange behavior - Mid Tier related.. ** We are on ARS 7.6.03 (Mid-Tier of the same version) and basically an all round windows shop.. The IE versions on our clients is 7.0.5730.13. This happens on only a few of our clients and we haven’t able to isolate the difference that may be causing this problem. Strictly speaking, all of our clients are supposed to be identical in terms of versions, settings etc. There shouldn’t really be a difference on any of them. However on some of the clients, when the user double clicks on an entry from the Overview Console, the new window opens only for a brief fraction of a second and shuts down. There is no error or warning on why it shuts itself down – it just does. There is nothing written to the event log. However on the clients that this behavior manifests, if the user holds down the CTRL key and then double clicks the entry, the new window opens and stays open – no problems.. Any of you’ll have experienced this and found a fix for it? Apparently we had opened a ticket with BMC Support, who could not find a fix for this as they were not able to get to the cause of the problem and that ticket was closed unresolved. Joe ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Fluid on Mac - work???
I like to use Fluid on the Mac… (makes for great demos) Fluid allows me to enter a URL and then it generates a custom browser just for that URL. It allows me to have MidTier (or any application) show up like a normal application when you alt-tab around… Also - allows me to login as multiple different people from the same machine. You can minimize it, etc… Also - if it crashes - or any other app crashes your browser - all the apps are independent - therefore you have a more stable system. Anyway -- when I make a fluid out of MidTier 7.6.4 -- and then login -- it goes BOOM!!! That is weird - as it really is just the safari browser but with a different executable name. Safari itself seems to be fine. Is anybody else doing this? And - I could be totally wrong -- as I get the same message from Chrome… Does MidTier work in Chrome/Mac? Actual message: *root cause* java.lang.NoClassDefFoundError: Could not initialize class org.apache.catalina.core.ApplicationDispatcher org.apache.catalina.connector.Request.getRequestDispatcher(Request.java:1219) org.apache.catalina.connector.RequestFacade.getRequestDispatcher(RequestFacade.java:569) com.remedy.arsys.session.LoginServlet.doThePost(Unknown Source) com.remedy.arsys.session.LoginServlet.doRequest(Unknown Source) com.remedy.arsys.stubs.GoatHttpServlet.postInternal(Unknown Source) com.remedy.arsys.stubs.GoatHttpServlet.doPost(Unknown Source) javax.servlet.http.HttpServlet.service(HttpServlet.java:709) javax.servlet.http.HttpServlet.service(HttpServlet.java:802) -John -- John David Sundberg 235 East 6th Street, Suite 400B St. Paul, MN 55101 (651) 556-0930-work (651) 247-6766-cell (651) 695-8577-fax john.sundb...@kineticdata.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Strange behavior - Mid Tier related..
And them my though... BMC closed the case because they couldn't find the root cause. In one hour a lot of people guided you in the right direction. But BMC's support team wasn't able to solve it Jose M. Huerta Project Manager** Movil: 661 665 088 Telf.: 971 75 03 24 Fax: 971 75 07 94 http://www.sm2baleares.es/ SM2 Baleares S.A. C/Rita Levi Edificio SM2 Parc Bit 07121 Palma de Mallorca http://es-es.facebook.com/pages/SM2-Baleares/158608627954 http://twitter.com/#!/SM2Baleares http://www.linkedin.com/company/sm2-baleares La información contenida en este mensaje de correo electrónico es confidencial. La misma, es enviada con la intención de que únicamente sea leída por la persona(s) a la(s) que va dirigida. El acceso a este mensaje por otras personas no está autorizado, por lo que en tal caso, le rogamos que nos lo comunique por la misma vía, se abstenga de realizar copias del mensaje o remitirlo o entregarlo a otra persona y proceda a borrarlo de inmediato. P Por favor, no imprima este mensaje ni sus documentos adjuntos si no es necesario. On Tue, Mar 6, 2012 at 19:22, Joe Martin D'Souza jdso...@shyle.net wrote: ** Initially I thought it was pop-up blockers too – but considering it wasn’t a popup but a new window I had my doubts... It was the plugins as Axton and Pat pointed out.. Thank you all for sharing your thoughts experiences.. Appreciate it.. Learnt one more thing today! Joe *From:* LJ LongWing lj.longw...@gmail.com *Sent:* Tuesday, March 06, 2012 1:11 PM *Newsgroups:* public.remedy.arsystem.general *To:* arslist@ARSLIST.ORG *Subject:* Re: Strange behavior - Mid Tier related.. ** Ok….trying to help you with this…. Ctrl-Click in IE gives you an ‘open in new tab’ functionality ‘explicitly’…..so….based on other comments, it does sound like it may be a popup blocker of some sort that’s killing the window…I know several toolbars have that ability….any toolbars installed? *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Joe Martin D'Souza *Sent:* Tuesday, March 06, 2012 10:44 AM *To:* arslist@ARSLIST.ORG *Subject:* Re: Strange behavior - Mid Tier related.. ** Yup... List of things already done.. 1) Cache cleared on local browsers 2) Compared browsers Advanced Settings 3) Compared other browser settings (pop ups, security, etc.) 4) Checked the PC’s Event Viewer for any possible errors and found none.** ** Everything seems to check out.. Joe *From:* LJ LongWing lj.longw...@gmail.com *Sent:* Tuesday, March 06, 2012 12:34 PM *Newsgroups:* public.remedy.arsystem.general *To:* arslist@ARSLIST.ORG *Subject:* Re: Strange behavior - Mid Tier related.. ** Joe, I’m assuming that you have done a cache clear and such on the affected machines and no difference? *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Joe Martin D'Souza *Sent:* Tuesday, March 06, 2012 10:10 AM *To:* arslist@ARSLIST.ORG *Subject:* Strange behavior - Mid Tier related.. ** We are on ARS 7.6.03 (Mid-Tier of the same version) and basically an all round windows shop.. The IE versions on our clients is 7.0.5730.13. This happens on only a few of our clients and we haven’t able to isolate the difference that may be causing this problem. Strictly speaking, all of our clients are supposed to be identical in terms of versions, settings etc. There shouldn’t really be a difference on any of them. However on some of the clients, when the user double clicks on an entry from the Overview Console, the new window opens only for a brief fraction of a second and shuts down. There is no error or warning on why it shuts itself down – it just does. There is nothing written to the event log. However on the clients that this behavior manifests, if the user holds down the CTRL key and then double clicks the entry, the new window opens and stays open – no problems.. Any of you’ll have experienced this and found a fix for it? Apparently we had opened a ticket with BMC Support, who could not find a fix for this as they were not able to get to the cause of the problem and that ticket was closed unresolved. Joe _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 image003.jpgimage004.jpgimage002.jpgimage001.jpg
Re: Strange behavior - Mid Tier related..
To their credit, it wasn’t any of their applications problem :-). Its what they claimed when they closed the ticket saying they have ruled out everything from the application end and it has nothing to do with their application and we would need to check our environment – which in a way, in this case turned out to be true.. The faster response time on this list is what made it my favorite resource over these years .. Joe From: Jose Huerta Sent: Tuesday, March 06, 2012 2:44 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Strange behavior - Mid Tier related.. ** And them my though... BMC closed the case because they couldn't find the root cause. In one hour a lot of people guided you in the right direction. But BMC's support team wasn't able to solve it Jose M. Huerta Project Manager Movil: 661 665 088 Telf.: 971 75 03 24 Fax: 971 75 07 94 SM2 Baleares S.A. C/Rita Levi Edificio SM2 Parc Bit 07121 Palma de Mallorca La información contenida en este mensaje de correo electrónico es confidencial. La misma, es enviada con la intención de que únicamente sea leída por la persona(s) a la(s) que va dirigida. El acceso a este mensaje por otras personas no está autorizado, por lo que en tal caso, le rogamos que nos lo comunique por la misma vía, se abstenga de realizar copias del mensaje o remitirlo o entregarlo a otra persona y proceda a borrarlo de inmediato. P Por favor, no imprima este mensaje ni sus documentos adjuntos si no es necesario. On Tue, Mar 6, 2012 at 19:22, Joe Martin D'Souza jdso...@shyle.net wrote: ** Initially I thought it was pop-up blockers too – but considering it wasn’t a popup but a new window I had my doubts... It was the plugins as Axton and Pat pointed out.. Thank you all for sharing your thoughts experiences.. Appreciate it.. Learnt one more thing today! Joe From: LJ LongWing Sent: Tuesday, March 06, 2012 1:11 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Strange behavior - Mid Tier related.. ** Ok….trying to help you with this…. Ctrl-Click in IE gives you an ‘open in new tab’ functionality ‘explicitly’…..so….based on other comments, it does sound like it may be a popup blocker of some sort that’s killing the window…I know several toolbars have that ability….any toolbars installed? From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Tuesday, March 06, 2012 10:44 AM To: arslist@ARSLIST.ORG Subject: Re: Strange behavior - Mid Tier related.. ** Yup... List of things already done.. 1) Cache cleared on local browsers 2) Compared browsers Advanced Settings 3) Compared other browser settings (pop ups, security, etc.) 4) Checked the PC’s Event Viewer for any possible errors and found none. Everything seems to check out.. Joe From: LJ LongWing Sent: Tuesday, March 06, 2012 12:34 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Strange behavior - Mid Tier related.. ** Joe, I’m assuming that you have done a cache clear and such on the affected machines and no difference? From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Tuesday, March 06, 2012 10:10 AM To: arslist@ARSLIST.ORG Subject: Strange behavior - Mid Tier related.. ** We are on ARS 7.6.03 (Mid-Tier of the same version) and basically an all round windows shop.. The IE versions on our clients is 7.0.5730.13. This happens on only a few of our clients and we haven’t able to isolate the difference that may be causing this problem. Strictly speaking, all of our clients are supposed to be identical in terms of versions, settings etc. There shouldn’t really be a difference on any of them. However on some of the clients, when the user double clicks on an entry from the Overview Console, the new window opens only for a brief fraction of a second and shuts down. There is no error or warning on why it shuts itself down – it just does. There is nothing written to the event log. However on the clients that this behavior manifests, if the user holds down the CTRL key and then double clicks the entry, the new window opens and stays open – no problems.. Any of you’ll have experienced this and found a fix for it? Apparently we had opened a ticket with BMC Support, who could not find a fix for this as they were not able to get to the cause of the problem and that ticket was closed unresolved. Joe _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE
Re: Strange behavior - Mid Tier related..
While I agree with and understand their position…I feel that it’s very short sighted of them. I’ve had problems in my environment that come to me because the user is using my application while it occurs…but just because it’s not my application’s fault it’s happening, I still consider it my responsibility to fix it because my application is affected by the problem….it’s in my best interest to fix it or the company could decide ‘there are too many problems with that app, lets replace it’…. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Tuesday, March 06, 2012 2:02 PM To: arslist@ARSLIST.ORG Subject: Re: Strange behavior - Mid Tier related.. ** To their credit, it wasn’t any of their applications problem :-). Its what they claimed when they closed the ticket saying they have ruled out everything from the application end and it has nothing to do with their application and we would need to check our environment – which in a way, in this case turned out to be true.. The faster response time on this list is what made it my favorite resource over these years .. Joe From: Jose Huerta mailto:jose.hue...@sm2baleares.es Sent: Tuesday, March 06, 2012 2:44 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Strange behavior - Mid Tier related.. ** And them my though... BMC closed the case because they couldn't find the root cause. In one hour a lot of people guided you in the right direction. But BMC's support team wasn't able to solve it Jose M. Huerta Project Manager Movil: 661 665 088 Telf.: 971 75 03 24 Fax: 971 75 07 94 http://www.sm2baleares.es/ SM2 Baleares S.A. C/Rita Levi Edificio SM2 Parc Bit 07121 Palma de Mallorca http://es-es.facebook.com/pages/SM2-Baleares/158608627954 http://twitter.com/#!/SM2Baleares http://www.linkedin.com/company/sm2-baleares La información contenida en este mensaje de correo electrónico es confidencial. La misma, es enviada con la intención de que únicamente sea leída por la persona(s) a la(s) que va dirigida. El acceso a este mensaje por otras personas no está autorizado, por lo que en tal caso, le rogamos que nos lo comunique por la misma vía, se abstenga de realizar copias del mensaje o remitirlo o entregarlo a otra persona y proceda a borrarlo de inmediato. P Por favor, no imprima este mensaje ni sus documentos adjuntos si no es necesario. On Tue, Mar 6, 2012 at 19:22, Joe Martin D'Souza jdso...@shyle.net wrote: ** Initially I thought it was pop-up blockers too – but considering it wasn’t a popup but a new window I had my doubts... It was the plugins as Axton and Pat pointed out.. Thank you all for sharing your thoughts experiences.. Appreciate it.. Learnt one more thing today! Joe From: LJ LongWing mailto:lj.longw...@gmail.com Sent: Tuesday, March 06, 2012 1:11 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Strange behavior - Mid Tier related.. ** Ok….trying to help you with this…. Ctrl-Click in IE gives you an ‘open in new tab’ functionality ‘explicitly’…..so….based on other comments, it does sound like it may be a popup blocker of some sort that’s killing the window…I know several toolbars have that ability….any toolbars installed? From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Tuesday, March 06, 2012 10:44 AM To: arslist@ARSLIST.ORG Subject: Re: Strange behavior - Mid Tier related.. ** Yup... List of things already done.. 1) Cache cleared on local browsers 2) Compared browsers Advanced Settings 3) Compared other browser settings (pop ups, security, etc.) 4) Checked the PC’s Event Viewer for any possible errors and found none. Everything seems to check out.. Joe From: LJ LongWing mailto:lj.longw...@gmail.com Sent: Tuesday, March 06, 2012 12:34 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Strange behavior - Mid Tier related.. ** Joe, I’m assuming that you have done a cache clear and such on the affected machines and no difference? From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Tuesday, March 06, 2012 10:10 AM To: arslist@ARSLIST.ORG Subject: Strange behavior - Mid Tier related.. ** We are on ARS 7.6.03 (Mid-Tier of the same version) and basically an all round windows shop.. The IE versions on our clients is 7.0.5730.13. This happens on only a few of our clients and we haven’t able to isolate the difference that may be causing this problem. Strictly speaking, all of our clients are supposed to be identical in terms of versions, settings etc. There shouldn’t really be a difference on any of them. However on some of the clients, when the user
Re: Strange behavior - Mid Tier related..
How many IE with google toolbar do exist? I can't believe that they haven't the problem documented as a known error. That's my point. Jose M. Huerta Project Manager** Movil: 661 665 088 Telf.: 971 75 03 24 Fax: 971 75 07 94 http://www.sm2baleares.es/ SM2 Baleares S.A. C/Rita Levi Edificio SM2 Parc Bit 07121 Palma de Mallorca http://es-es.facebook.com/pages/SM2-Baleares/158608627954 http://twitter.com/#!/SM2Baleares http://www.linkedin.com/company/sm2-baleares La información contenida en este mensaje de correo electrónico es confidencial. La misma, es enviada con la intención de que únicamente sea leída por la persona(s) a la(s) que va dirigida. El acceso a este mensaje por otras personas no está autorizado, por lo que en tal caso, le rogamos que nos lo comunique por la misma vía, se abstenga de realizar copias del mensaje o remitirlo o entregarlo a otra persona y proceda a borrarlo de inmediato. P Por favor, no imprima este mensaje ni sus documentos adjuntos si no es necesario. On Tue, Mar 6, 2012 at 22:11, LJ LongWing lj.longw...@gmail.com wrote: ** While I agree with and understand their position…I feel that it’s very short sighted of them. I’ve had problems in my environment that come to me because the user is using my application while it occurs…but just because it’s not my application’s fault it’s happening, I still consider it my responsibility to fix it because my application is affected by the problem….it’s in my best interest to fix it or the company could decide ‘there are too many problems with that app, lets replace it’…. ** ** *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Joe Martin D'Souza *Sent:* Tuesday, March 06, 2012 2:02 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Strange behavior - Mid Tier related.. ** ** ** To their credit, it wasn’t any of their applications problem :-). Its what they claimed when they closed the ticket saying they have ruled out everything from the application end and it has nothing to do with their application and we would need to check our environment – which in a way, in this case turned out to be true.. The faster response time on this list is what made it my favorite resource over these years .. Joe *From:* Jose Huerta jose.hue...@sm2baleares.es *Sent:* Tuesday, March 06, 2012 2:44 PM *Newsgroups:* public.remedy.arsystem.general *To:* arslist@ARSLIST.ORG *Subject:* Re: Strange behavior - Mid Tier related.. ** And them my though... BMC closed the case because they couldn't find the root cause. In one hour a lot of people guided you in the right direction. But BMC's support team wasn't able to solve it Jose M. Huerta Project Manager Movil: 661 665 088 Telf.: 971 75 03 24 Fax: 971 75 07 94 http://www.sm2baleares.es/ SM2 Baleares S.A. C/Rita Levi Edificio SM2 Parc Bit 07121 Palma de Mallorca http://es-es.facebook.com/pages/SM2-Baleares/158608627954 http://twitter.com/#!/SM2Baleares http://www.linkedin.com/company/sm2-baleares La información contenida en este mensaje de correo electrónico es confidencial. La misma, es enviada con la intención de que únicamente sea leída por la persona(s) a la(s) que va dirigida. El acceso a este mensaje por otras personas no está autorizado, por lo que en tal caso, le rogamos que nos lo comunique por la misma vía, se abstenga de realizar copias del mensaje o remitirlo o entregarlo a otra persona y proceda a borrarlo de inmediato. P Por favor, no imprima este mensaje ni sus documentos adjuntos si no es necesario. On Tue, Mar 6, 2012 at 19:22, Joe Martin D'Souza jdso...@shyle.net wrote: ** Initially I thought it was pop-up blockers too – but considering it wasn’t a popup but a new window I had my doubts... It was the plugins as Axton and Pat pointed out.. Thank you all for sharing your thoughts experiences.. Appreciate it..*** * Learnt one more thing today! Joe *From:* LJ LongWing lj.longw...@gmail.com *Sent:* Tuesday, March 06, 2012 1:11 PM *Newsgroups:* public.remedy.arsystem.general *To:* arslist@ARSLIST.ORG *Subject:* Re: Strange behavior - Mid Tier related.. ** Ok….trying to help you with this…. Ctrl-Click in IE gives you an ‘open in new tab’ functionality ‘explicitly’…..so….based on other comments, it does sound like it may be a popup blocker of some sort that’s killing the window…I know several toolbars have that ability….any toolbars installed? *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Joe Martin D'Souza *Sent:* Tuesday, March 06, 2012 10:44 AM *To:*
Re: Strange behavior - Mid Tier related..
@ LJ : That’s what I try to do too. I wasn’t here with this company at the time that this problem was reported so – again to BMC Supports credit, here is the history.. They were willing to keep the ticket open. Its our users that were not being very responsive when BMC Support was available to check out the problem. Our administrators (after a period of over 4 weeks) getting tired of waiting for our users to respond and be available for the problem to be evaluated by BMC, asked BMC to close the ticket.. That is what I just heard when I asked about the history of this problem here at this site. So I was wrong when I assumed that it was BMC that closed the ticket.. It wasn’t them. @ Jose: I agree with you Jose.. If this seems to be as common a problem as it appears to be where I got a accurate solution from this list in under 5 minutes or so from reporting it to you’ll, then they should have encounter this problem in their tests where a tool like Google Toolbar is common in many environments these days. By now there should have been a fix to it and not the workaround of having to disable the toolbar. And its not even documented as a known problem which should have been a start to begin the whole process with.. That toolbar could probably be a useful tool to some.. Joe From: LJ LongWing Sent: Tuesday, March 06, 2012 4:11 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Strange behavior - Mid Tier related.. ** While I agree with and understand their position…I feel that it’s very short sighted of them. I’ve had problems in my environment that come to me because the user is using my application while it occurs…but just because it’s not my application’s fault it’s happening, I still consider it my responsibility to fix it because my application is affected by the problem….it’s in my best interest to fix it or the company could decide ‘there are too many problems with that app, lets replace it’…. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Tuesday, March 06, 2012 2:02 PM To: arslist@ARSLIST.ORG Subject: Re: Strange behavior - Mid Tier related.. ** To their credit, it wasn’t any of their applications problem :-). Its what they claimed when they closed the ticket saying they have ruled out everything from the application end and it has nothing to do with their application and we would need to check our environment – which in a way, in this case turned out to be true.. The faster response time on this list is what made it my favorite resource over these years .. Joe From: Jose Huerta Sent: Tuesday, March 06, 2012 2:44 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Strange behavior - Mid Tier related.. ** And them my though... BMC closed the case because they couldn't find the root cause. In one hour a lot of people guided you in the right direction. But BMC's support team wasn't able to solve it Jose M. Huerta Project Manager Movil: 661 665 088 Telf.: 971 75 03 24 Fax: 971 75 07 94 SM2 Baleares S.A. C/Rita Levi Edificio SM2 Parc Bit 07121 Palma de Mallorca La información contenida en este mensaje de correo electrónico es confidencial. La misma, es enviada con la intención de que únicamente sea leída por la persona(s) a la(s) que va dirigida. El acceso a este mensaje por otras personas no está autorizado, por lo que en tal caso, le rogamos que nos lo comunique por la misma vía, se abstenga de realizar copias del mensaje o remitirlo o entregarlo a otra persona y proceda a borrarlo de inmediato. P Por favor, no imprima este mensaje ni sus documentos adjuntos si no es necesario. On Tue, Mar 6, 2012 at 19:22, Joe Martin D'Souza jdso...@shyle.net wrote: ** Initially I thought it was pop-up blockers too – but considering it wasn’t a popup but a new window I had my doubts... It was the plugins as Axton and Pat pointed out.. Thank you all for sharing your thoughts experiences.. Appreciate it.. Learnt one more thing today! Joe From: LJ LongWing Sent: Tuesday, March 06, 2012 1:11 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Strange behavior - Mid Tier related.. ** Ok….trying to help you with this…. Ctrl-Click in IE gives you an ‘open in new tab’ functionality ‘explicitly’…..so….based on other comments, it does sound like it may be a popup blocker of some sort that’s killing the window…I know several toolbars have that ability….any toolbars installed? From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Tuesday, March 06, 2012 10:44 AM To: arslist@ARSLIST.ORG Subject: Re: Strange behavior - Mid Tier related.. ** Yup... List of things
Re: Strange behavior - Mid Tier related..
I’ll say that it’s encouraging that BMC didn’t just ‘drop it’ J…regarding a ‘fix’…I’m not sure there is one…the Google Toolbar was likely just suppressing popups….BMC readily says that you need to enable them to be able to use the application properly, so I suspect that if you went back and re-enabled it, but disabled it’s popup suppression options, there wouldn’t be a problem with it being installed. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Tuesday, March 06, 2012 2:54 PM To: arslist@ARSLIST.ORG Subject: Re: Strange behavior - Mid Tier related.. ** @ LJ : That’s what I try to do too. I wasn’t here with this company at the time that this problem was reported so – again to BMC Supports credit, here is the history.. They were willing to keep the ticket open. Its our users that were not being very responsive when BMC Support was available to check out the problem. Our administrators (after a period of over 4 weeks) getting tired of waiting for our users to respond and be available for the problem to be evaluated by BMC, asked BMC to close the ticket.. That is what I just heard when I asked about the history of this problem here at this site. So I was wrong when I assumed that it was BMC that closed the ticket.. It wasn’t them. @ Jose: I agree with you Jose.. If this seems to be as common a problem as it appears to be where I got a accurate solution from this list in under 5 minutes or so from reporting it to you’ll, then they should have encounter this problem in their tests where a tool like Google Toolbar is common in many environments these days. By now there should have been a fix to it and not the workaround of having to disable the toolbar. And its not even documented as a known problem which should have been a start to begin the whole process with.. That toolbar could probably be a useful tool to some.. Joe From: LJ LongWing mailto:lj.longw...@gmail.com Sent: Tuesday, March 06, 2012 4:11 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Strange behavior - Mid Tier related.. ** While I agree with and understand their position…I feel that it’s very short sighted of them. I’ve had problems in my environment that come to me because the user is using my application while it occurs…but just because it’s not my application’s fault it’s happening, I still consider it my responsibility to fix it because my application is affected by the problem….it’s in my best interest to fix it or the company could decide ‘there are too many problems with that app, lets replace it’…. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Tuesday, March 06, 2012 2:02 PM To: arslist@ARSLIST.ORG Subject: Re: Strange behavior - Mid Tier related.. ** To their credit, it wasn’t any of their applications problem :-). Its what they claimed when they closed the ticket saying they have ruled out everything from the application end and it has nothing to do with their application and we would need to check our environment – which in a way, in this case turned out to be true.. The faster response time on this list is what made it my favorite resource over these years .. Joe From: Jose Huerta mailto:jose.hue...@sm2baleares.es Sent: Tuesday, March 06, 2012 2:44 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Strange behavior - Mid Tier related.. ** And them my though... BMC closed the case because they couldn't find the root cause. In one hour a lot of people guided you in the right direction. But BMC's support team wasn't able to solve it Jose M. Huerta Project Manager Movil: 661 665 088 Telf.: 971 75 03 24 Fax: 971 75 07 94 http://www.sm2baleares.es/ SM2 Baleares S.A. C/Rita Levi Edificio SM2 Parc Bit 07121 Palma de Mallorca http://es-es.facebook.com/pages/SM2-Baleares/158608627954 http://twitter.com/#!/SM2Baleares http://www.linkedin.com/company/sm2-baleares La información contenida en este mensaje de correo electrónico es confidencial. La misma, es enviada con la intención de que únicamente sea leída por la persona(s) a la(s) que va dirigida. El acceso a este mensaje por otras personas no está autorizado, por lo que en tal caso, le rogamos que nos lo comunique por la misma vía, se abstenga de realizar copias del mensaje o remitirlo o entregarlo a otra persona y proceda a borrarlo de inmediato. P Por favor, no imprima este mensaje ni sus documentos adjuntos si no es necesario. On Tue, Mar 6, 2012 at 19:22, Joe Martin D'Souza jdso...@shyle.net wrote: ** Initially I thought it was pop-up blockers too – but considering it wasn’t a popup but a new window I had my doubts... It was the plugins as Axton and Pat pointed out.. Thank you all for sharing your thoughts
Receiveing ARERR 552 within SRM
Hello List, I was attempting to build a Query menu within the SRM application. There is not much info to go on and the logs are not helping. Win 2008 64 SQL 2008 R2 ITSM 7.6.04 Thank you.. I need some help with the following: Mar 6, 2012 4:00:18 PM - SEVERE (com.remedy.log.SERVLET) : GoatException during NDXRequest: 1/021/SRM:QuestionsFormName12/w86sandrem0122/SRM:QuestionManagement12/w86sandrem0112/SRM:ARSchema94/2\2\2\4\1\1\303800600\2\2\1\4\1\1\303800600\2\2\2\4\1\1\303800600\2\2\3\4\1\1\303800600\2\2\5\0/1/10/2/0/2/0/2/0/2/0/2/0/2/0/2/0/2/0/2/0/ = ARERR [552] The SQL database operation failed. : Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. (HRESULT: 0X80040E21) at com.remedy.arsys.goat.menu.Menu.expandMenu(Unknown Source) at com.remedy.arsys.goat.menu.QueryMenu.emitJS(Unknown Source) at com.remedy.arsys.backchannel.ExpandMenuAgent.process(Unknown Source) at com.remedy.arsys.backchannel.NDXRequest.processRequest(Unknown Source) at com.remedy.arsys.backchannel.NDXRequest.init(Unknown Source) at com.remedy.arsys.backchannel.EntryListBase.init(Unknown Source) at com.remedy.arsys.backchannel.NDXExpandMenu.init(Unknown Source) at com.remedy.arsys.backchannel.ExpandMenuAgent.init(Unknown Source) at com.remedy.arsys.backchannel.NDXFactory.handleRequest(Unknown Source) at com.remedy.arsys.stubs.BackchannelServlet.doRequest(Unknown Source) at com.remedy.arsys.stubs.GoatServlet.postInternal(Unknown Source) at com.remedy.arsys.stubs.GoatHttpServlet.doGet(Unknown Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190) at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291) at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769) at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698) at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690) at java.lang.Thread.run(Unknown Source) Caused by: ERROR (552): The SQL database operation failed.; Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. (HRESULT: 0X80040E21) ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Receiveing ARERR 552 within SRM
I would suggest taking an SQL log to see what SQL failed. A combined SQL and API log may prove to be useful too although at this stage an SQL log would be more useful. Joe -Original Message- From: Robert Heverley Sent: Tuesday, March 06, 2012 8:24 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Receiveing ARERR 552 within SRM Hello List, I was attempting to build a Query menu within the SRM application. There is not much info to go on and the logs are not helping. Win 2008 64 SQL 2008 R2 ITSM 7.6.04 Thank you.. I need some help with the following: Mar 6, 2012 4:00:18 PM - SEVERE (com.remedy.log.SERVLET) : GoatException during NDXRequest: 1/021/SRM:QuestionsFormName12/w86sandrem0122/SRM:QuestionManagement12/w86sandrem0112/SRM:ARSchema94/2\2\2\4\1\1\303800600\2\2\1\4\1\1\303800600\2\2\2\4\1\1\303800600\2\2\3\4\1\1\303800600\2\2\5\0/1/10/2/0/2/0/2/0/2/0/2/0/2/0/2/0/2/0/2/0/ = ARERR [552] The SQL database operation failed. : Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. (HRESULT: 0X80040E21) at com.remedy.arsys.goat.menu.Menu.expandMenu(Unknown Source) at com.remedy.arsys.goat.menu.QueryMenu.emitJS(Unknown Source) at com.remedy.arsys.backchannel.ExpandMenuAgent.process(Unknown Source) at com.remedy.arsys.backchannel.NDXRequest.processRequest(Unknown Source) at com.remedy.arsys.backchannel.NDXRequest.init(Unknown Source) at com.remedy.arsys.backchannel.EntryListBase.init(Unknown Source) at com.remedy.arsys.backchannel.NDXExpandMenu.init(Unknown Source) at com.remedy.arsys.backchannel.ExpandMenuAgent.init(Unknown Source) at com.remedy.arsys.backchannel.NDXFactory.handleRequest(Unknown Source) at com.remedy.arsys.stubs.BackchannelServlet.doRequest(Unknown Source) at com.remedy.arsys.stubs.GoatServlet.postInternal(Unknown Source) at com.remedy.arsys.stubs.GoatHttpServlet.doGet(Unknown Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190) at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291) at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769) at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698) at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690) at java.lang.Thread.run(Unknown Source) Caused by: ERROR (552): The SQL database operation failed.; Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. (HRESULT: 0X80040E21) ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Receiveing ARERR 552 within SRM
Hi Joe, Thank you for the input. That is another part of the issue.. The SQL logs and AR Server logs are not showing any detailed information.. Here is some added information since my posting.. The functionality works when using the User Tool but, not when using Midtier.. Thanks again.. Rob On Tue, Mar 6, 2012 at 5:32 PM, Joe Martin D'Souza jdso...@shyle.netwrote: I would suggest taking an SQL log to see what SQL failed. A combined SQL and API log may prove to be useful too although at this stage an SQL log would be more useful. Joe -Original Message- From: Robert Heverley Sent: Tuesday, March 06, 2012 8:24 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Receiveing ARERR 552 within SRM Hello List, I was attempting to build a Query menu within the SRM application. There is not much info to go on and the logs are not helping. Win 2008 64 SQL 2008 R2 ITSM 7.6.04 Thank you.. I need some help with the following: Mar 6, 2012 4:00:18 PM - SEVERE (com.remedy.log.SERVLET) : GoatException during NDXRequest: 1/021/SRM:QuestionsFormName12/**w86sandrem0122/SRM:** QuestionManagement12/**w86sandrem0112/SRM:ARSchema94/** 2\2\2\4\1\1\303800600\2\2\1\4\**1\1\303800600\2\2\2\4\1\1\** 303800600\2\2\3\4\1\1\**303800600\2\2\5\0/1/10/2/0/2/**0/2/0/2/0/2/0/2/0/2/0/2/0/2/0/ = ARERR [552] The SQL database operation failed. : Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. (HRESULT: 0X80040E21) at com.remedy.arsys.goat.menu.**Menu.expandMenu(Unknown Source) at com.remedy.arsys.goat.menu.**QueryMenu.emitJS(Unknown Source) at com.remedy.arsys.backchannel.**ExpandMenuAgent.process(**Unknown Source) at com.remedy.arsys.backchannel.**NDXRequest.processRequest(**Unknown Source) at com.remedy.arsys.backchannel.**NDXRequest.init(Unknown Source) at com.remedy.arsys.backchannel.**EntryListBase.init(Unknown Source) at com.remedy.arsys.backchannel.**NDXExpandMenu.init(Unknown Source) at com.remedy.arsys.backchannel.**ExpandMenuAgent.init(Unknown Source) at com.remedy.arsys.backchannel.**NDXFactory.handleRequest(**Unknown Source) at com.remedy.arsys.stubs.**BackchannelServlet.doRequest(**Unknown Source) at com.remedy.arsys.stubs.**GoatServlet.postInternal(**Unknown Source) at com.remedy.arsys.stubs.**GoatHttpServlet.doGet(Unknown Source) at javax.servlet.http.**HttpServlet.service(**HttpServlet.java:617) at javax.servlet.http.**HttpServlet.service(**HttpServlet.java:717) at org.apache.catalina.core.**ApplicationFilterChain.**internalDoFilter(** ApplicationFilterChain.java:**290) at org.apache.catalina.core.**ApplicationFilterChain.**doFilter(** ApplicationFilterChain.java:**206) at org.apache.catalina.core.**StandardWrapperValve.invoke(** StandardWrapperValve.java:233) at org.apache.catalina.core.**StandardContextValve.invoke(** StandardContextValve.java:191) at org.apache.catalina.core.**StandardHostValve.invoke(** StandardHostValve.java:128) at org.apache.catalina.valves.**ErrorReportValve.invoke(** ErrorReportValve.java:102) at org.apache.catalina.core.**StandardEngineValve.invoke(** StandardEngineValve.java:109) at org.apache.catalina.connector.**CoyoteAdapter.service(** CoyoteAdapter.java:293) at org.apache.jk.server.**JkCoyoteHandler.invoke(** JkCoyoteHandler.java:190) at org.apache.jk.common.**HandlerRequest.invoke(**HandlerRequest.java:291) at org.apache.jk.common.**ChannelSocket.invoke(**ChannelSocket.java:769) at org.apache.jk.common.**ChannelSocket.**processConnection(** ChannelSocket.java:698) at org.apache.jk.common.**ChannelSocket$**SocketConnection.runIt(** ChannelSocket.java:891) at org.apache.tomcat.util.**threads.ThreadPool$**ControlRunnable.run(** ThreadPool.java:690) at java.lang.Thread.run(Unknown Source) Caused by: ERROR (552): The SQL database operation failed.; Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. (HRESULT: 0X80040E21) __**__** ___ 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: Receiveing ARERR 552 within SRM
That is indeed strange considering that even when using the User Tool, the DVF field that displays the SRM application, uses the Mid-Tier to display those fields. Have you tried the age old thing – uninstall and reinstall the Mid-Tier in the hope that what's broken gets fixed?? Joe From: Robert Heverley Sent: Tuesday, March 06, 2012 9:36 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Receiveing ARERR 552 within SRM ** Hi Joe, Thank you for the input. That is another part of the issue.. The SQL logs and AR Server logs are not showing any detailed information.. Here is some added information since my posting.. The functionality works when using the User Tool but, not when using Midtier.. Thanks again.. Rob On Tue, Mar 6, 2012 at 5:32 PM, Joe Martin D'Souza jdso...@shyle.net wrote: I would suggest taking an SQL log to see what SQL failed. A combined SQL and API log may prove to be useful too although at this stage an SQL log would be more useful. Joe -Original Message- From: Robert Heverley Sent: Tuesday, March 06, 2012 8:24 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Receiveing ARERR 552 within SRM Hello List, I was attempting to build a Query menu within the SRM application. There is not much info to go on and the logs are not helping. Win 2008 64 SQL 2008 R2 ITSM 7.6.04 Thank you.. I need some help with the following: Mar 6, 2012 4:00:18 PM - SEVERE (com.remedy.log.SERVLET) : GoatException during NDXRequest: 1/021/SRM:QuestionsFormName12/w86sandrem0122/SRM:QuestionManagement12/w86sandrem0112/SRM:ARSchema94/2\2\2\4\1\1\303800600\2\2\1\4\1\1\303800600\2\2\2\4\1\1\303800600\2\2\3\4\1\1\303800600\2\2\5\0/1/10/2/0/2/0/2/0/2/0/2/0/2/0/2/0/2/0/2/0/ = ARERR [552] The SQL database operation failed. : Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. (HRESULT: 0X80040E21) at com.remedy.arsys.goat.menu.Menu.expandMenu(Unknown Source) at com.remedy.arsys.goat.menu.QueryMenu.emitJS(Unknown Source) at com.remedy.arsys.backchannel.ExpandMenuAgent.process(Unknown Source) at com.remedy.arsys.backchannel.NDXRequest.processRequest(Unknown Source) at com.remedy.arsys.backchannel.NDXRequest.init(Unknown Source) at com.remedy.arsys.backchannel.EntryListBase.init(Unknown Source) at com.remedy.arsys.backchannel.NDXExpandMenu.init(Unknown Source) at com.remedy.arsys.backchannel.ExpandMenuAgent.init(Unknown Source) at com.remedy.arsys.backchannel.NDXFactory.handleRequest(Unknown Source) at com.remedy.arsys.stubs.BackchannelServlet.doRequest(Unknown Source) at com.remedy.arsys.stubs.GoatServlet.postInternal(Unknown Source) at com.remedy.arsys.stubs.GoatHttpServlet.doGet(Unknown Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190) at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291) at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769) at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698) at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690) at java.lang.Thread.run(Unknown Source) Caused by: ERROR (552): The SQL database operation failed.; Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. (HRESULT: 0X80040E21) ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Receiveing ARERR 552 within SRM
Is the error actually within SRM's display of the service request or the actual interface to build the questions? Sent from my iPhone On Mar 6, 2012, at 9:53 PM, Joe Martin D'Souza jdso...@shyle.net wrote: ** That is indeed strange considering that even when using the User Tool, the DVF field that displays the SRM application, uses the Mid-Tier to display those fields. Have you tried the age old thing – uninstall and reinstall the Mid-Tier in the hope that what's broken gets fixed?? Joe *From:* Robert Heverley robert.hever...@gmail.com *Sent:* Tuesday, March 06, 2012 9:36 PM *Newsgroups:* public.remedy.arsystem.general *To:* arslist@ARSLIST.ORG *Subject:* Re: Receiveing ARERR 552 within SRM ** Hi Joe, Thank you for the input. That is another part of the issue.. The SQL logs and AR Server logs are not showing any detailed information.. Here is some added information since my posting.. The functionality works when using the User Tool but, not when using Midtier.. Thanks again.. Rob On Tue, Mar 6, 2012 at 5:32 PM, Joe Martin D'Souza jdso...@shyle.netwrote: I would suggest taking an SQL log to see what SQL failed. A combined SQL and API log may prove to be useful too although at this stage an SQL log would be more useful. Joe -Original Message- From: Robert Heverley Sent: Tuesday, March 06, 2012 8:24 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Receiveing ARERR 552 within SRM Hello List, I was attempting to build a Query menu within the SRM application. There is not much info to go on and the logs are not helping. Win 2008 64 SQL 2008 R2 ITSM 7.6.04 Thank you.. I need some help with the following: Mar 6, 2012 4:00:18 PM - SEVERE (com.remedy.log.SERVLET) : GoatException during NDXRequest: 1/021/SRM:QuestionsFormName12/**w86sandrem0122/SRM:** QuestionManagement12/**w86sandrem0112/SRM:ARSchema94/** 2\2\2\4\1\1\303800600\2\2\1\4\**1\1\303800600\2\2\2\4\1\1\** 303800600\2\2\3\4\1\1\**303800600\2\2\5\0/1/10/2/0/2/**0/2/0/2/0/2/0/2/0/2/0/2/0/2/0/ = ARERR [552] The SQL database operation failed. : Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. (HRESULT: 0X80040E21) at com.remedy.arsys.goat.menu.**Menu.expandMenu(Unknown Source) at com.remedy.arsys.goat.menu.**QueryMenu.emitJS(Unknown Source) at com.remedy.arsys.backchannel.**ExpandMenuAgent.process(**Unknown Source) at com.remedy.arsys.backchannel.**NDXRequest.processRequest(**Unknown Source) at com.remedy.arsys.backchannel.**NDXRequest.init(Unknown Source) at com.remedy.arsys.backchannel.**EntryListBase.init(Unknown Source) at com.remedy.arsys.backchannel.**NDXExpandMenu.init(Unknown Source) at com.remedy.arsys.backchannel.**ExpandMenuAgent.init(Unknown Source) at com.remedy.arsys.backchannel.**NDXFactory.handleRequest(**Unknown Source) at com.remedy.arsys.stubs.**BackchannelServlet.doRequest(**Unknown Source) at com.remedy.arsys.stubs.**GoatServlet.postInternal(**Unknown Source) at com.remedy.arsys.stubs.**GoatHttpServlet.doGet(Unknown Source) at javax.servlet.http.**HttpServlet.service(**HttpServlet.java:617) at javax.servlet.http.**HttpServlet.service(**HttpServlet.java:717) at org.apache.catalina.core.**ApplicationFilterChain.**internalDoFilter(** ApplicationFilterChain.java:**290) at org.apache.catalina.core.**ApplicationFilterChain.**doFilter(** ApplicationFilterChain.java:**206) at org.apache.catalina.core.**StandardWrapperValve.invoke(** StandardWrapperValve.java:233) at org.apache.catalina.core.**StandardContextValve.invoke(** StandardContextValve.java:191) at org.apache.catalina.core.**StandardHostValve.invoke(** StandardHostValve.java:128) at org.apache.catalina.valves.**ErrorReportValve.invoke(** ErrorReportValve.java:102) at org.apache.catalina.core.**StandardEngineValve.invoke(** StandardEngineValve.java:109) at org.apache.catalina.connector.**CoyoteAdapter.service(** CoyoteAdapter.java:293) at org.apache.jk.server.**JkCoyoteHandler.invoke(** JkCoyoteHandler.java:190) at org.apache.jk.common.**HandlerRequest.invoke(**HandlerRequest.java:291) at org.apache.jk.common.**ChannelSocket.invoke(**ChannelSocket.java:769) at org.apache.jk.common.**ChannelSocket.**processConnection(** ChannelSocket.java:698) at org.apache.jk.common.**ChannelSocket$**SocketConnection.runIt(** ChannelSocket.java:891) at org.apache.tomcat.util.**threads.ThreadPool$**ControlRunnable.run(** ThreadPool.java:690) at java.lang.Thread.run(Unknown Source) Caused by: ERROR (552): The SQL database operation failed.; Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. (HRESULT: 0X80040E21) _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
Re: Receiveing ARERR 552 within SRM
Trying the build the question.. On Tue, Mar 6, 2012 at 5:55 PM, Tauf Chowdhury taufc...@gmail.com wrote: ** Is the error actually within SRM's display of the service request or the actual interface to build the questions? Sent from my iPhone On Mar 6, 2012, at 9:53 PM, Joe Martin D'Souza jdso...@shyle.net wrote: ** That is indeed strange considering that even when using the User Tool, the DVF field that displays the SRM application, uses the Mid-Tier to display those fields. Have you tried the age old thing – uninstall and reinstall the Mid-Tier in the hope that what's broken gets fixed?? Joe *From:* Robert Heverley robert.hever...@gmail.com *Sent:* Tuesday, March 06, 2012 9:36 PM *Newsgroups:* public.remedy.arsystem.general *To:* arslist@ARSLIST.ORG *Subject:* Re: Receiveing ARERR 552 within SRM ** Hi Joe, Thank you for the input. That is another part of the issue.. The SQL logs and AR Server logs are not showing any detailed information.. Here is some added information since my posting.. The functionality works when using the User Tool but, not when using Midtier.. Thanks again.. Rob On Tue, Mar 6, 2012 at 5:32 PM, Joe Martin D'Souza jdso...@shyle.netwrote: I would suggest taking an SQL log to see what SQL failed. A combined SQL and API log may prove to be useful too although at this stage an SQL log would be more useful. Joe -Original Message- From: Robert Heverley Sent: Tuesday, March 06, 2012 8:24 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Receiveing ARERR 552 within SRM Hello List, I was attempting to build a Query menu within the SRM application. There is not much info to go on and the logs are not helping. Win 2008 64 SQL 2008 R2 ITSM 7.6.04 Thank you.. I need some help with the following: Mar 6, 2012 4:00:18 PM - SEVERE (com.remedy.log.SERVLET) : GoatException during NDXRequest: 1/021/SRM:QuestionsFormName12/**w86sandrem0122/SRM:** QuestionManagement12/**w86sandrem0112/SRM:ARSchema94/** 2\2\2\4\1\1\303800600\2\2\1\4\**1\1\303800600\2\2\2\4\1\1\** 303800600\2\2\3\4\1\1\**303800600\2\2\5\0/1/10/2/0/2/**0/2/0/2/0/2/0/2/0/2/0/2/0/2/0/ = ARERR [552] The SQL database operation failed. : Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. (HRESULT: 0X80040E21) at com.remedy.arsys.goat.menu.**Menu.expandMenu(Unknown Source) at com.remedy.arsys.goat.menu.**QueryMenu.emitJS(Unknown Source) at com.remedy.arsys.backchannel.**ExpandMenuAgent.process(**Unknown Source) at com.remedy.arsys.backchannel.**NDXRequest.processRequest(**Unknown Source) at com.remedy.arsys.backchannel.**NDXRequest.init(Unknown Source) at com.remedy.arsys.backchannel.**EntryListBase.init(Unknown Source) at com.remedy.arsys.backchannel.**NDXExpandMenu.init(Unknown Source) at com.remedy.arsys.backchannel.**ExpandMenuAgent.init(Unknown Source) at com.remedy.arsys.backchannel.**NDXFactory.handleRequest(**Unknown Source) at com.remedy.arsys.stubs.**BackchannelServlet.doRequest(**Unknown Source) at com.remedy.arsys.stubs.**GoatServlet.postInternal(**Unknown Source) at com.remedy.arsys.stubs.**GoatHttpServlet.doGet(Unknown Source) at javax.servlet.http.**HttpServlet.service(**HttpServlet.java:617) at javax.servlet.http.**HttpServlet.service(**HttpServlet.java:717) at org.apache.catalina.core.**ApplicationFilterChain.**internalDoFilter(* *ApplicationFilterChain.java:**290) at org.apache.catalina.core.**ApplicationFilterChain.**doFilter(** ApplicationFilterChain.java:**206) at org.apache.catalina.core.**StandardWrapperValve.invoke(** StandardWrapperValve.java:233) at org.apache.catalina.core.**StandardContextValve.invoke(** StandardContextValve.java:191) at org.apache.catalina.core.**StandardHostValve.invoke(** StandardHostValve.java:128) at org.apache.catalina.valves.**ErrorReportValve.invoke(** ErrorReportValve.java:102) at org.apache.catalina.core.**StandardEngineValve.invoke(** StandardEngineValve.java:109) at org.apache.catalina.connector.**CoyoteAdapter.service(** CoyoteAdapter.java:293) at org.apache.jk.server.**JkCoyoteHandler.invoke(** JkCoyoteHandler.java:190) at org.apache.jk.common.**HandlerRequest.invoke(** HandlerRequest.java:291) at org.apache.jk.common.**ChannelSocket.invoke(**ChannelSocket.java:769) at org.apache.jk.common.**ChannelSocket.**processConnection(** ChannelSocket.java:698) at org.apache.jk.common.**ChannelSocket$**SocketConnection.runIt(** ChannelSocket.java:891) at org.apache.tomcat.util.**threads.ThreadPool$**ControlRunnable.run(** ThreadPool.java:690) at java.lang.Thread.run(Unknown Source) Caused by: ERROR (552): The SQL database operation failed.; Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. (HRESULT: 0X80040E21) _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist:
