Re: How to get a table in a form to be populated with data on form load
Hi Angus, Generally the right event to be firing your table refresh on would be Display this runs after the data is loaded into an existing request form prior to it being displayed. The window loaded event is only applicable to new submits or to search windows and also to dialog windows. Rod Harris On 1 July 2013 05:11, Angus Comber arsl...@iteloffice.com wrote: ** ** Hi I have a Table on a Form and I have set the columns to be fields in another form - a contacts form with eg name, age, address, etc. When the form is loaded it does not display any of the records. But if I click on one of the column headers it then displays the daya in the table. I tried an active link run process - PERFORM-ACTION-TABLE_REFRESH, execute on Window loaded. I tried an active link with a set fields, field the table Value Default, execute on Window loaded. But neither of those work. What should I be doing to display the data in the table on window loaded? Angus _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Modify All Disabled on all CI Types
What is the ITSM version ?I could see it enabled for AST:ComputerSystem in dev stuif i go to Form properties and Menu access option.ITSM 7.6.04 On Mon, Jul 1, 2013 at 11:58 PM, Kemes, Lisa A DLA CTR INFORMATION OPERATIONS lisa.kemes@dla.mil wrote: ** Is there a reason why the modify all Action field is disabled out of the box for the join forms like AST:Equipment, AST:ComputerSystem etc? ** ** The Manage Bulk Update link only allows you to update the location (sans the room and floor for some reason) and relate the CI’s to people. ** ** Just wondering…. ** ** Lisa Kemes Remedy Consultant Dev Technology Group DLA Office: (717) 770-6437 Cell Phone: (717) 602-6430 lisa.ke...@devtechnology.com ** ** ** ** _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Result list show in web view
I think that's a throwback to the early versions of the mid-tier, is it not? When the MT was first released the Results List field had to be manually added to a web view, same thing with the Advanced Search bar. Once you remove those from your view the normal versions of both should work as expected. I have a couple of older custom applications that taught me this. -Rick ___ Rick Westbrock QMX Support Services From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Longwing, Lj Sent: Monday, July 01, 2013 22:07 PM To: arslist@ARSLIST.ORG Subject: Re: Result list show in web view ** Yea, don't have that field on the form :) On Monday, July 1, 2013, clemence clemence...@gmail.commailto:clemence...@gmail.com wrote: ** currently when a user performs a search in AR Client, the result list is shown at the top with details at the bottom. However, when the user perform the same search via mid tier, the results are shown in results list table. Is there a way to have the mid tier same view (result list at top, details at the bottom) as client ? _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ Important: This email is intended for the above named only and may be confidential, proprietary, and/or legally privileged. If this email has come to you in error, you must take no action on it, nor may you copy or show it to anyone. Please contact the sender and delete the material from any computer. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Modify All Disabled on all CI Types
Sorry, it's enabled, but when I try to do a Modify All, it says Modify All is not supported in sandbox mode We are on 7.6.04 Sp2. Thanks! -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Smita Ithape Sent: Tuesday, July 02, 2013 11:32 AM To: arslist@ARSLIST.ORG Subject: Re: Modify All Disabled on all CI Types ** What is the ITSM version ?I could see it enabled for AST:ComputerSystem in dev stuif i go to Form properties and Menu access option.ITSM 7.6.04 On Mon, Jul 1, 2013 at 11:58 PM, Kemes, Lisa A DLA CTR INFORMATION OPERATIONS lisa.kemes@dla.mil wrote: ** Is there a reason why the modify all Action field is disabled out of the box for the join forms like AST:Equipment, AST:ComputerSystem etc? The Manage Bulk Update link only allows you to update the location (sans the room and floor for some reason) and relate the CI's to people. Just wondering Lisa Kemes Remedy Consultant Dev Technology Group DLA Office: (717) 770-6437 Cell Phone: (717) 602-6430 lisa.ke...@devtechnology.com _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
'Save Next' menu button
Has anyone tried to add the 'Save Next' menu button to the menu items that are along the top of the window on the web? It an available menu item on the client but wasn't brought into the web. ARServer/Mid-tier 7.6.4 sp3 MS-SQL 2008 Windows 2005 Thank you in advance. Marc ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: 'Save Next' menu button
This to the best of my knowledge is (was) available only on the thick client. You could however 'build' something similar with a table walk by building a result list field. The button could be out on the form menu. I had personally to be honest, never noticed its absence on the middle tier, until you pointed it out. Maybe it would qualify for a RFE if there is a good business case for it - that is if a lot of users like that feature from the user client and if they would like to see it ported over to the middle tier. Joe _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Marc Burick Sent: Tuesday, July 02, 2013 12:37 PM To: arslist@ARSLIST.ORG Subject: 'Save Next' menu button ** Has anyone tried to add the 'Save Next' menu button to the menu items that are along the top of the window on the web? It an available menu item on the client but wasn't brought into the web. ARServer/Mid-tier 7.6.4 sp3 MS-SQL 2008 Windows 2005 Thank you in advance. Marc ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Tomcat Errors in Catalina Logs
Hi all, I'm running Remedy Mid-Tier 7.6.4 SP3 on a Linux Red Hat Server 6.2 with Tomcat 6.0. Our ARSystem is 7.6.4 SP3. CASFilter appears in the null receipt error below. It's what we use for our single sign on. Occasionally, we see some java errors showing up in the logs that I have had no luck troubleshooting. They are intermittently throwing Null Receipt errors and Null Pointer errors. Any ideas of how to get a handle on them? Jul 01, 2013 1:28:52 PM org.apache.catalina.core.StandardWrapperValve invoke SEVERE: Servlet.service() for servlet BackchannelServlet threw exception java.lang.NullPointerException at com.remedy.arsys.stubs.ServerLogin.threadDepartingGoatSpace(Unknown Source) at com.remedy.arsys.stubs.GoatServlet.teardownSessionData(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 edu.yale.its.tp.cas.client.filter.CASFilter.doFilter(CASFilter.java:336) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) 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.coyote.http11.Http11Processor.process(Http11Processor.java:849) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454) at java.lang.Thread.run(Thread.java:722) Jul 01, 2013 4:30:20 PM org.apache.catalina.core.StandardWrapperValve invoke SEVERE: Servlet.service() for servlet HomeServlet threw exception java.lang.IllegalArgumentException: Cannot evaluate a null receipt. at edu.yale.its.tp.cas.client.filter.CASFilter.isReceiptAcceptable(CASFilter.java:459) at edu.yale.its.tp.cas.client.filter.CASFilter.doFilter(CASFilter.java:413) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) 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.coyote.http11.Http11Processor.process(Http11Processor.java:849) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454) at java.lang.Thread.run(Thread.java:722) Thanks in advance, Scott This email is subject to certain disclaimers, which may be reviewed via the following link. http://compass-usa.com/Pages/Disclaimer.aspx ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Linked Server Puzzle
Just my two cents but maybe the name is case sensitive? And the ODBC driver might me converting to all caps or all small and breaking things? If the above is a possible reason, try altering the source table and its columns if that is possible to have its name in all caps or all small. Joe _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Warren R. Baltimore II Sent: Monday, July 01, 2013 2:15 PM To: arslist@ARSLIST.ORG Subject: Linked Server Puzzle ** First off. ARS 7.6.04 patch 1 Windows Server 2008 R2 Standard ITSM 7.6.04 MS SQL 2008 R2 Windwos Server 2008 R2 Standard Linking to an Oracle 10g db I am attempting to create a view form of the legacy server at my current project. It's a NON unicode database. My current db is Unicode. I've installed Oracle Client on the production db server. I've tried 2 methods to connect 1. I created an ODBC connection to the Oracle server. I get a successfful connection. I then access the current SQL server and create a linked server using the ODBC connection I had created. All tables show up, however when I attempt to select a table, I get an error that the table (any of them) contains no columns or the current user does not have permissions on that object. This is strange as I am using the db owners login to access the data. Additionally, if I go ahead and attempt to create the view form at this point, Remedy will pull back all of the fields on the form, but if I try to save the form, I receive the ARError message 552: The SQL database operation failed. : Invalid object name \[2 task name]\[table name]. (SQL Server 208) 2. Instead of using the ODBC drivers, I instead tried to create the Linked Server using the Oracle Provider for OLE DB provider. I set it up with the Product name of Oracle and the Data Source name is the appropriate 2 task name listed in the TNSNAMES.ORA file that I loaded on the server when I installed the Oracle Client. I am using the Oracle user that owns the db to connect. When I attempt to create it, I get the error The Linked server has been created but failed a connection test. Do you want to keep the linked server. Additionally, it tells me that An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) and Cannot create an instance of OLE DB Provider OraOLEDB.Oracle for linked server [2 task name]. (Microsoft SQL Server, Error: 7302). Additionally, in the SQL Server log, I am seeing the error The OLD DB initialization service failed to load. Reinstall Microsoft Data Access Components. If the problem persists, contact product support for the OLEDB provider. I was going through the kbase and google, and I came across references to making sure that Named Pipes and TCP are enabled (they are) and that the db user (ARAdmin) has local admin privelages on the db server (it does). I'm more than a bit stumped. I don't currently have a lot of DBa support, so I'm hoping someone in ARSlist land may have run into this and knows what direction to point me. Thanks much in advance! -- Warren R. Baltimore II Remedy Developer 410-533-5367 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: 'Save Next' menu button
Joe, Thanks for your response. Your thought's are the same as mine but because of the layout of our application (homegrown), the location of adding a Save Next button is the same amount of click as Save and choosing the next record. Marc From: Joe D'Souza jdso...@shyle.net To: arslist@ARSLIST.ORG, Date: 07/02/2013 01:49 PM Subject:Re: 'Save Next' menu button Sent by:Action Request System discussion list(ARSList) arslist@ARSLIST.ORG ** This to the best of my knowledge is (was) available only on the thick client. You could however ?build? something similar with a table walk by building a result list field. The button could be out on the form menu. I had personally to be honest, never noticed its absence on the middle tier, until you pointed it out. Maybe it would qualify for a RFE if there is a good business case for it ? that is if a lot of users like that feature from the user client and if they would like to see it ported over to the middle tier. Joe From: Action Request System discussion list(ARSList) [ mailto:arslist@ARSLIST.ORG] On Behalf Of Marc Burick Sent: Tuesday, July 02, 2013 12:37 PM To: arslist@ARSLIST.ORG Subject: 'Save Next' menu button ** Has anyone tried to add the 'Save Next' menu button to the menu items that are along the top of the window on the web? It an available menu item on the client but wasn't brought into the web. ARServer/Mid-tier 7.6.4 sp3 MS-SQL 2008 Windows 2005 Thank you in advance. Marc _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Linked Server Puzzle
Thanks JoeIt's not case sensitive I've tried it about every which way I can try. It's an old SHR:People table on a legacy box that's going away. We're trying to come up with a way to keep the new CTM:People form in sync with the old (50,000 + entries to maintain on both systems). I was hoping this would be a little bit easier then what it is turning out to be! *sigh* On Tue, Jul 2, 2013 at 2:03 PM, Joe D'Souza jdso...@shyle.net wrote: ** Just my two cents but maybe the name is case sensitive? And the ODBC driver might me converting to all caps or all small and breaking things?** ** ** ** If the above is a possible reason, try altering the source table and its columns if that is possible to have its name in all caps or all small. ** ** Joe ** ** -- *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Warren R. Baltimore II *Sent:* Monday, July 01, 2013 2:15 PM *To:* arslist@ARSLIST.ORG *Subject:* Linked Server Puzzle ** ** ** First off. ARS 7.6.04 patch 1 Windows Server 2008 R2 Standard ITSM 7.6.04 MS SQL 2008 R2 Windwos Server 2008 R2 Standard Linking to an Oracle 10g db I am attempting to create a view form of the legacy server at my current project. It's a NON unicode database. My current db is Unicode. I've installed Oracle Client on the production db server. I've tried 2 methods to connect 1. I created an ODBC connection to the Oracle server. I get a successfful connection. I then access the current SQL server and create a linked server using the ODBC connection I had created. All tables show up, however when I attempt to select a table, I get an error that the table (any of them) contains no columns or the current user does not have permissions on that object. This is strange as I am using the db owners login to access the data. Additionally, if I go ahead and attempt to create the view form at this point, Remedy will pull back all of the fields on the form, but if I try to save the form, I receive the ARError message 552: The SQL database operation failed. : Invalid object name \[2 task name]\[table name]. (SQL Server 208) 2. Instead of using the ODBC drivers, I instead tried to create the Linked Server using the Oracle Provider for OLE DB provider. I set it up with the Product name of Oracle and the Data Source name is the appropriate 2 task name listed in the TNSNAMES.ORA file that I loaded on the server when I installed the Oracle Client. I am using the Oracle user that owns the db to connect. When I attempt to create it, I get the error The Linked server has been created but failed a connection test. Do you want to keep the linked server. Additionally, it tells me that An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) and Cannot create an instance of OLE DB Provider OraOLEDB.Oracle for linked server [2 task name]. (Microsoft SQL Server, Error: 7302). Additionally, in the SQL Server log, I am seeing the error The OLD DB initialization service failed to load. Reinstall Microsoft Data Access Components. If the problem persists, contact product support for the OLEDB provider. I was going through the kbase and google, and I came across references to making sure that Named Pipes and TCP are enabled (they are) and that the db user (ARAdmin) has local admin privelages on the db server (it does). I'm more than a bit stumped. I don't currently have a lot of DBa support, so I'm hoping someone in ARSlist land may have run into this and knows what direction to point me. Thanks much in advance! -- Warren R. Baltimore II Remedy Developer 410-533-5367 _ARSlist: Where the Answers Are and have been for 20 years_ -- Warren R. Baltimore II Remedy Developer 410-533-5367 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Linked Server Puzzle
Good idea! I'll give that a try. On Tue, Jul 2, 2013 at 2:19 PM, Grooms, Frederick W frederick.w.gro...@xo.com wrote: ** Have you tried creating a local SQL view of the remote table using the ODBC driver (either to the Oracle view or to the T table directly) and then creating a ARS view form on that? ** ** Fred ** ** ** ** *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Warren R. Baltimore II *Sent:* Tuesday, July 02, 2013 1:14 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Linked Server Puzzle ** ** ** Thanks JoeIt's not case sensitive I've tried it about every which way I can try. It's an old SHR:People table on a legacy box that's going away. We're trying to come up with a way to keep the new CTM:People form in sync with the old (50,000 + entries to maintain on both systems). I was hoping this would be a little bit easier then what it is turning out to be! *sigh* On Tue, Jul 2, 2013 at 2:03 PM, Joe D'Souza jdso...@shyle.net wrote: ** Just my two cents but maybe the name is case sensitive? And the ODBC driver might me converting to all caps or all small and breaking things?** ** If the above is a possible reason, try altering the source table and its columns if that is possible to have its name in all caps or all small. Joe -- *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Warren R. Baltimore II *Sent:* Monday, July 01, 2013 2:15 PM *To:* arslist@ARSLIST.ORG *Subject:* Linked Server Puzzle ** First off. ARS 7.6.04 patch 1 Windows Server 2008 R2 Standard ITSM 7.6.04 MS SQL 2008 R2 Windwos Server 2008 R2 Standard Linking to an Oracle 10g db I am attempting to create a view form of the legacy server at my current project. It's a NON unicode database. My current db is Unicode. I've installed Oracle Client on the production db server. I've tried 2 methods to connect 1. I created an ODBC connection to the Oracle server. I get a successfful connection. I then access the current SQL server and create a linked server using the ODBC connection I had created. All tables show up, however when I attempt to select a table, I get an error that the table (any of them) contains no columns or the current user does not have permissions on that object. This is strange as I am using the db owners login to access the data. Additionally, if I go ahead and attempt to create the view form at this point, Remedy will pull back all of the fields on the form, but if I try to save the form, I receive the ARError message 552: The SQL database operation failed. : Invalid object name \[2 task name]\[table name]. (SQL Server 208) 2. Instead of using the ODBC drivers, I instead tried to create the Linked Server using the Oracle Provider for OLE DB provider. I set it up with the Product name of Oracle and the Data Source name is the appropriate 2 task name listed in the TNSNAMES.ORA file that I loaded on the server when I installed the Oracle Client. I am using the Oracle user that owns the db to connect. When I attempt to create it, I get the error The Linked server has been created but failed a connection test. Do you want to keep the linked server. Additionally, it tells me that An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) and Cannot create an instance of OLE DB Provider OraOLEDB.Oracle for linked server [2 task name]. (Microsoft SQL Server, Error: 7302). Additionally, in the SQL Server log, I am seeing the error The OLD DB initialization service failed to load. Reinstall Microsoft Data Access Components. If the problem persists, contact product support for the OLEDB provider. I was going through the kbase and google, and I came across references to making sure that Named Pipes and TCP are enabled (they are) and that the db user (ARAdmin) has local admin privelages on the db server (it does). ** ** I'm more than a bit stumped. I don't currently have a lot of DBa support, so I'm hoping someone in ARSlist land may have run into this and knows what direction to point me. Thanks much in advance! -- Warren R. Baltimore II Remedy Developer 410-533-5367 ** ** _ARSlist: Where the Answers Are and have been for 20 years_ -- Warren R. Baltimore II Remedy Developer 410-533-5367 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: 'Save Next' menu button
I see your point - the whole idea of using that button on the thick client is minimizing the number of clicks and adding a menu item would not really do that unless off course you create an actual box type button behind that function. But that would stick out like a sore thumb in case you have not created save modify and search buttons as well to accompany that new Save and Next button. Joe _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Marc Burick Sent: Tuesday, July 02, 2013 2:08 PM To: arslist@ARSLIST.ORG Subject: Re: 'Save Next' menu button ** Joe, Thanks for your response. Your thought's are the same as mine but because of the layout of our application (homegrown), the location of adding a Save Next button is the same amount of click as Save and choosing the next record. Marc From:Joe D'Souza jdso...@shyle.net To:arslist@ARSLIST.ORG, Date:07/02/2013 01:49 PM Subject:Re: 'Save Next' menu button Sent by:Action Request System discussion list(ARSList) arslist@ARSLIST.ORG _ ** This to the best of my knowledge is (was) available only on the thick client. You could however 'build' something similar with a table walk by building a result list field. The button could be out on the form menu. I had personally to be honest, never noticed its absence on the middle tier, until you pointed it out. Maybe it would qualify for a RFE if there is a good business case for it - that is if a lot of users like that feature from the user client and if they would like to see it ported over to the middle tier. Joe _ From: Action Request System discussion list(ARSList) [ mailto:arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG] On Behalf Of Marc Burick Sent: Tuesday, July 02, 2013 12:37 PM To: arslist@ARSLIST.ORG Subject: 'Save Next' menu button ** Has anyone tried to add the 'Save Next' menu button to the menu items that are along the top of the window on the web? It an available menu item on the client but wasn't brought into the web. ARServer/Mid-tier 7.6.4 sp3 MS-SQL 2008 Windows 2005 Thank you in advance. Marc ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Linked Server Puzzle
Have you played with ODBC settings like use of underscores and ANSI settings on the SQL server? I recall having to use underscores to resolve some ODBC related issues where forms contained special characters. And having to set ANSI ON on the SQL server, for some other similar type of problems. Changing ANSI configuration may require SQL restart. Joe _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Tuesday, July 02, 2013 2:19 PM To: arslist@ARSLIST.ORG Subject: Re: Linked Server Puzzle Have you tried creating a local SQL view of the remote table using the ODBC driver (either to the Oracle view or to the T table directly) and then creating a ARS view form on that? Fred From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Warren R. Baltimore II Sent: Tuesday, July 02, 2013 1:14 PM To: arslist@ARSLIST.ORG Subject: Re: Linked Server Puzzle ** Thanks JoeIt's not case sensitive I've tried it about every which way I can try. It's an old SHR:People table on a legacy box that's going away. We're trying to come up with a way to keep the new CTM:People form in sync with the old (50,000 + entries to maintain on both systems). I was hoping this would be a little bit easier then what it is turning out to be! *sigh* On Tue, Jul 2, 2013 at 2:03 PM, Joe D'Souza jdso...@shyle.net wrote: ** Just my two cents but maybe the name is case sensitive? And the ODBC driver might me converting to all caps or all small and breaking things? If the above is a possible reason, try altering the source table and its columns if that is possible to have its name in all caps or all small. Joe _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Warren R. Baltimore II Sent: Monday, July 01, 2013 2:15 PM To: arslist@ARSLIST.ORG Subject: Linked Server Puzzle ** First off. ARS 7.6.04 patch 1 Windows Server 2008 R2 Standard ITSM 7.6.04 MS SQL 2008 R2 Windwos Server 2008 R2 Standard Linking to an Oracle 10g db I am attempting to create a view form of the legacy server at my current project. It's a NON unicode database. My current db is Unicode. I've installed Oracle Client on the production db server. I've tried 2 methods to connect 1. I created an ODBC connection to the Oracle server. I get a successfful connection. I then access the current SQL server and create a linked server using the ODBC connection I had created. All tables show up, however when I attempt to select a table, I get an error that the table (any of them) contains no columns or the current user does not have permissions on that object. This is strange as I am using the db owners login to access the data. Additionally, if I go ahead and attempt to create the view form at this point, Remedy will pull back all of the fields on the form, but if I try to save the form, I receive the ARError message 552: The SQL database operation failed. : Invalid object name \[2 task name]\[table name]. (SQL Server 208) 2. Instead of using the ODBC drivers, I instead tried to create the Linked Server using the Oracle Provider for OLE DB provider. I set it up with the Product name of Oracle and the Data Source name is the appropriate 2 task name listed in the TNSNAMES.ORA file that I loaded on the server when I installed the Oracle Client. I am using the Oracle user that owns the db to connect. When I attempt to create it, I get the error The Linked server has been created but failed a connection test. Do you want to keep the linked server. Additionally, it tells me that An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) and Cannot create an instance of OLE DB Provider OraOLEDB.Oracle for linked server [2 task name]. (Microsoft SQL Server, Error: 7302). Additionally, in the SQL Server log, I am seeing the error The OLD DB initialization service failed to load. Reinstall Microsoft Data Access Components. If the problem persists, contact product support for the OLEDB provider. I was going through the kbase and google, and I came across references to making sure that Named Pipes and TCP are enabled (they are) and that the db user (ARAdmin) has local admin privelages on the db server (it does). I'm more than a bit stumped. I don't currently have a lot of DBa support, so I'm hoping someone in ARSlist land may have run into this and knows what direction to point me. Thanks much in advance! -- Warren R. Baltimore II Remedy Developer 410-533-5367 _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
RKM federation to Sharepoint possible?
All, Has anyone managed to get the Remedy 7.6 Knowledge Management to federate and pull in a Sharepoint site? We are running ARS 7.6 MS SQL 2012 Windows Server 2008 I have tried setting up the access on the sharepoint directories, but it still fails at the plugin level: Caused by: ERROR (8753): Error in plugin; RMDY.ITSM.RKM.FILESYSTEM A RKM File System source is corrupted.The path [\\\x\xx\x\x\xx\] does not exist or you don't have read permission to this folder. I've gone through the documentation, but don't see any place where you can federate to a website, and sharepoint has some strange permissions and access around it's directories when trying to access it as a file share. Thanks, Matt P. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: RKM federation to Sharepoint possible?
Matt, I was unsuccessful with this with Analytics but the same concept applies. Even though share point looks like it can be accessed using UNC, there is some security or other translation done in the background. I ended up using WinSCP to push the files from share point to a normal network share so I could consume the data. Sent from my iPhone On Jul 2, 2013, at 4:22 PM, Matthew Perrault matthew.perra...@genmills.com wrote: ** All, Has anyone managed to get the Remedy 7.6 Knowledge Management to federate and pull in a Sharepoint site? We are running ARS 7.6 MS SQL 2012 Windows Server 2008 I have tried setting up the access on the sharepoint directories, but it still fails at the plugin level: Caused by: ERROR (8753): Error in plugin; RMDY.ITSM.RKM.FILESYSTEM A RKM File System source is corrupted.The path [\\\x\xx\x\x\xx\] does not exist or you don't have read permission to this folder. I’ve gone through the documentation, but don’t see any place where you can federate to a website, and sharepoint has some strange permissions and access around it’s directories when trying to access it as a file share. Thanks, Matt P. _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: SRM v760 migrate (import/export) to SRM v8.1
Hi Peter it's getting another environment and then setting up with the current config (ARS v7.5, customized ITSM v703, SRM v760, etc...). We already have an out of the box v764 env.. and my thinking was export/import the SRD(s) from my current PROD to the v764 and export/import into our new out of the box v8.1 env. If we get another ARS v75/ITSM v704/SRM v760 env... are you saying that we can directly go to v8.1 ARS/ITSM/SRM...without running into any issues? dave ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: RKM federation to Sharepoint possible?
Great That's what I was afraid ofick... The person in charge/owner of the Knowledge base is not going to be happy about that... From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Tauf Chowdhury Sent: Tuesday, July 02, 2013 3:40 PM To: arslist@ARSLIST.ORG Subject: Re: RKM federation to Sharepoint possible? ** Matt, I was unsuccessful with this with Analytics but the same concept applies. Even though share point looks like it can be accessed using UNC, there is some security or other translation done in the background. I ended up using WinSCP to push the files from share point to a normal network share so I could consume the data. Sent from my iPhone On Jul 2, 2013, at 4:22 PM, Matthew Perrault matthew.perra...@genmills.commailto:matthew.perra...@genmills.com wrote: ** All, Has anyone managed to get the Remedy 7.6 Knowledge Management to federate and pull in a Sharepoint site? We are running ARS 7.6 MS SQL 2012 Windows Server 2008 I have tried setting up the access on the sharepoint directories, but it still fails at the plugin level: Caused by: ERROR (8753): Error in plugin; RMDY.ITSM.RKM.FILESYSTEM A RKM File System source is corrupted.The path [\\\x\xx\x\x\xx\] does not exist or you don't have read permission to this folder. I've gone through the documentation, but don't see any place where you can federate to a website, and sharepoint has some strange permissions and access around it's directories when trying to access it as a file share. Thanks, Matt P. _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: RKM federation to Sharepoint possible?
Hey Matt, What if you mapped a drive on the AR app server under the service account that runs the AR server service to the share point folder and then try to connect to that? Sent from my iPhone On Jul 2, 2013, at 4:51 PM, Matthew Perrault matthew.perra...@genmills.com wrote: ** Great…. That’s what I was afraid of….ick… The person in charge/owner of the Knowledge base is not going to be happy about that… *From:* Action Request System discussion list(ARSList) [ mailto:arslist@ARSLIST.ORG arslist@ARSLIST.ORG] *On Behalf Of *Tauf Chowdhury *Sent:* Tuesday, July 02, 2013 3:40 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: RKM federation to Sharepoint possible? ** Matt, I was unsuccessful with this with Analytics but the same concept applies. Even though share point looks like it can be accessed using UNC, there is some security or other translation done in the background. I ended up using WinSCP to push the files from share point to a normal network share so I could consume the data. Sent from my iPhone On Jul 2, 2013, at 4:22 PM, Matthew Perrault matthew.perra...@genmills.com wrote: ** All, Has anyone managed to get the Remedy 7.6 Knowledge Management to federate and pull in a Sharepoint site? We are running ARS 7.6 MS SQL 2012 Windows Server 2008 I have tried setting up the access on the sharepoint directories, but it still fails at the plugin level: Caused by: ERROR (8753): Error in plugin; RMDY.ITSM.RKM.FILESYSTEM A RKM File System source is corrupted.The path [\\\x\xx\x\x\xx\] does not exist or you don't have read permission to this folder. I’ve gone through the documentation, but don’t see any place where you can federate to a website, and sharepoint has some strange permissions and access around it’s directories when trying to access it as a file share. Thanks, Matt P. _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: RKM federation to Sharepoint possible?
I found this: The document library shared by SharePoint server is not a real Shared Folder; it is shared through Web folders. In order to access the web folder you need to have WebClient service installed and running on the machine which you want to access the web folder from. By default Windows Server 2008 does not have that service installed. To install the WebClient on Windows server 2008 , do the followings: 1. Start the server manager on your server 2. Select the Feature node from the left hand side nodes. 3. On right hand side, select Add Feature. 4. On the popup screen, select “Desktop Experience” checkbox then click on Next. 5. Click on Install, the installation process will take like 5 min (that depends on server hardware) 6. After installation process finish, close the dialog box 7. After installing the Service, you need to restart your server. Hope that helps with both of your issues. Dale Hurtt From: Tauf Chowdhury taufc...@gmail.com To: arslist@ARSLIST.ORG Sent: Tuesday, July 2, 2013 1:40 PM Subject: Re: RKM federation to Sharepoint possible? ** Matt, I was unsuccessful with this with Analytics but the same concept applies. Even though share point looks like it can be accessed using UNC, there is some security or other translation done in the background. I ended up using WinSCP to push the files from share point to a normal network share so I could consume the data. Sent from my iPhone On Jul 2, 2013, at 4:22 PM, Matthew Perrault matthew.perra...@genmills.com wrote: ** All, Has anyone managed to get the Remedy 7.6 Knowledge Management to federate and pull in a Sharepoint site? We are running ARS 7.6 MS SQL 2012 Windows Server 2008 I have tried setting up the access on the sharepoint directories, but it still fails at the plugin level: Caused by: ERROR (8753): Error in plugin; RMDY.ITSM.RKM.FILESYSTEM A RKM File System source is corrupted.The path [\\\x\xx\x\x\xx\] does not exist or you don't have read permission to this folder. I’ve gone through the documentation, but don’t see any place where you can federate to a website, and sharepoint has some strange permissions and access around it’s directories when trying to access it as a file share. Thanks, Matt P. _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: RKM federation to Sharepoint possible?
Thanks Dale. This enables the server to behave just like the desktop OS does which is needed to map the drive. This was at a previous client so I may not try this unless I have the opportunity. Sent from my iPhone On Jul 2, 2013, at 5:42 PM, Dale Hurtt dale_hu...@yahoo.com wrote: ** I found this: The document library shared by SharePoint server is not a real Shared Folder; it is shared through Web folders. In order to access the web folder you need to have WebClient service installed and running on the machine which you want to access the web folder from. By default Windows Server 2008 does not have that service installed. To install the WebClient on Windows server 2008 , do the followings: 1. Start the server manager on your server 2. Select the Feature node from the left hand side nodes. 3. On right hand side, select Add Feature. 4. On the popup screen, select “Desktop Experience” checkbox then click on Next. 5. Click on Install, the installation process will take like 5 min (that depends on server hardware) 6. After installation process finish, close the dialog box 7. After installing the Service, you need to restart your server. Hope that helps with both of your issues. Dale Hurtt -- *From:* Tauf Chowdhury taufc...@gmail.com *To:* arslist@ARSLIST.ORG *Sent:* Tuesday, July 2, 2013 1:40 PM *Subject:* Re: RKM federation to Sharepoint possible? ** Matt, I was unsuccessful with this with Analytics but the same concept applies. Even though share point looks like it can be accessed using UNC, there is some security or other translation done in the background. I ended up using WinSCP to push the files from share point to a normal network share so I could consume the data. Sent from my iPhone On Jul 2, 2013, at 4:22 PM, Matthew Perrault matthew.perra...@genmills.com wrote: ** All, Has anyone managed to get the Remedy 7.6 Knowledge Management to federate and pull in a Sharepoint site? We are running ARS 7.6 MS SQL 2012 Windows Server 2008 I have tried setting up the access on the sharepoint directories, but it still fails at the plugin level: Caused by: ERROR (8753): Error in plugin; RMDY.ITSM.RKM.FILESYSTEM A RKM File System source is corrupted.The path [\\\x\xx\x\x\xx\] does not exist or you don't have read permission to this folder. I’ve gone through the documentation, but don’t see any place where you can federate to a website, and sharepoint has some strange permissions and access around it’s directories when trying to access it as a file share. Thanks, Matt P. _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: RKM federation to Sharepoint possible?
Dale, Thanks for the info, but still no luck. We even hit the Microsoft KM article: http://support.microsoft.com/kb/956943 doesn’t seem like it wants to allow access to that directory… From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Dale Hurtt Sent: Tuesday, July 02, 2013 4:40 PM To: arslist@ARSLIST.ORG Subject: Re: RKM federation to Sharepoint possible? ** I found this: The document library shared by SharePoint server is not a real Shared Folder; it is shared through Web folders. In order to access the web folder you need to have WebClient service installed and running on the machine which you want to access the web folder from. By default Windows Server 2008 does not have that service installed. To install the WebClient on Windows server 2008 , do the followings: 1. Start the server manager on your server 2. Select the Feature node from the left hand side nodes. 3. On right hand side, select Add Feature. 4. On the popup screen, select “Desktop Experience” checkbox then click on Next. 5. Click on Install, the installation process will take like 5 min (that depends on server hardware) 6. After installation process finish, close the dialog box 7. After installing the Service, you need to restart your server. Hope that helps with both of your issues. Dale Hurtt From: Tauf Chowdhury taufc...@gmail.commailto:taufc...@gmail.com To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Sent: Tuesday, July 2, 2013 1:40 PM Subject: Re: RKM federation to Sharepoint possible? ** Matt, I was unsuccessful with this with Analytics but the same concept applies. Even though share point looks like it can be accessed using UNC, there is some security or other translation done in the background. I ended up using WinSCP to push the files from share point to a normal network share so I could consume the data. Sent from my iPhone On Jul 2, 2013, at 4:22 PM, Matthew Perrault matthew.perra...@genmills.commailto:matthew.perra...@genmills.com wrote: ** All, Has anyone managed to get the Remedy 7.6 Knowledge Management to federate and pull in a Sharepoint site? We are running ARS 7.6 MS SQL 2012 Windows Server 2008 I have tried setting up the access on the sharepoint directories, but it still fails at the plugin level: Caused by: ERROR (8753): Error in plugin; RMDY.ITSM.RKM.FILESYSTEM A RKM File System source is corrupted.The path [\\\x\xx\x\x\xx\] does not exist or you don't have read permission to this folder. I’ve gone through the documentation, but don’t see any place where you can federate to a website, and sharepoint has some strange permissions and access around it’s directories when trying to access it as a file share. Thanks, Matt P. _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
