How to set Server language after upgrade - 6.3 - 7.1
Hello List! My environment is the following - Oracle 9.2, Windows 2003, ARS 6.3, However the Oracle DB Charset is UTF-8, there was stated - Server Language - RUS;1251 in the Server Information - Configuration tab. After I upgraded ARS to 7.1 version there is stated - Server Language - RUS; UTF-8 in the Server Information - Configuration tab, and cyrillic characters became unreadable. I assume that I need to set the Server Language back to RUS;1251 in order to solve the problem, but I do not know how to do this. I tried to set NLS_LANG variable in the ar.cfg file, but that does not work at all. Thank you for your help in advance. Kind Regards Dmitry Bezhenar
Re: Export Form Data to Excel on Button Action (UNCLASSIFIED)
Hello Frank, Thank you for your useful answer. I have a question reg. item 7 in your list. How is it possible to tie a report, which exports data to application, to an Open Window action? There are only 3 options - screen, file and printer. Kind Regards / C ? Dmitry Bezhenar -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of FRANK, GORDON CTR DISA JSSC Sent: Monday, November 19, 2007 4:54 PM To: arslist@ARSLIST.ORG Subject: Re: Export Form Data to Excel on Button Action (UNCLASSIFIED) Classification: UNCLASSIFIED Caveats: NONE This can be done in the following way: 1. Create a DDE.ini file in your Home directory 2. Copy the following into the DDE.ini text file [excelrecord] Path=c:\excel\excel.exe Application=excel Topic=system Format=TAB XFRDATA=Clipboard Command1=[NEW(1)][PASTE()][SAVE.AS(,0)] 3. Enable Report to Application option is selected in the Options dialog box 4. Build and save a report in the Remedy User tool 5. Choose Report Export to Application from the Report menu bar 6. Your query and created report will be sent to Excel 7. Tie this report to an Open Window action in an Active Link with a Button (Permissions: Public) Below is a web link with explains this in more detail: http://service-it-remedy.web.cern.ch/service-it-remedy/clients/aruser/Re ports15.html A description is also available in the Remedy User Tool help. You can also execute Visual Basic code. To do this you will need to substitute VB for the Command1=[NEW(1)][PASTE()][SAVE.AS(,0)] see VB Help for more detail. You will have to work with relative addressing in Visual Basic (a recorded macro in VB will give you static addressing). Gordon M. Frank DISA\Version FNS -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Anesh A Kurian Sent: Monday, November 19, 2007 7:30 AM To: arslist@ARSLIST.ORG Subject: Export Form Data to Excel on Button Action ** Hi Listers, I require to perform a data export of a regular form to an excel sheet on click of a button. And also that it shouldnt require the user to interact other than clicking the button. I tried by using the Open window action to run a report but here again it requires the user to select a format to which the data has to be saved as. i require that the workflow automatically opens an excel sheet and displays the exported data on to the excel sheet. i would appreciate if some one could shed some light on this or if anyone has done the same to share the idea. thanks and regards Anesh __20060125___This posting was submitted with HTML in it___ Classification: UNCLASSIFIED Caveats: NONE ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Export Form Data to Excel
Hi List, I have a charset encoding problem after exporting data to excel using DDE. Export to a csv file works without any problems. Anybody knows where I can control encoding settings when using DDE? Thank you! Kind Regards Dmitry Bezhenar ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
First patch for ARS 7.1
Hello List, Anyone of you know about when the first patch for ARS 7.1 will be released? Just out of curiosity. Thank you! Kind Regards / C ? Dmitry Bezhenar ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Current connected users
Hi John, I believe it tracks User tool users only? Is it possible to track MidTier users somehow? Thank you. Kind Regards / C ? Dmitry Bezhenar From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of John Magnussen Sent: Tuesday, July 03, 2007 4:34 PM To: arslist@ARSLIST.ORG Subject: Re: Current connected users ** Hi Daniel, Log on to Admin Tool, Select File, Server Information, Licenses, Manage Licenses This shows all users currently signed on to your system. Regards, John M On 7/3/07, CONDREA, Daniel [EMAIL PROTECTED] wrote: Hello All, Can anybody suggest a way to get a list of connected uses to an Action Request System version 6.3? Best regards, Daniel -- *DISCLAIMER* The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorized to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking action in reliance of the contents of this information is strictly prohibited and may be unlawful. Orange Romania S.A. is neither liable for the proper, complete transmission of the information contained in this communication nor any delay in its receipt. *END OF DISCLAIMER* ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
How to create an AD account using Remedy vendor form?
Hello List, I am just curious if it is possible to create AD accounts using vendor forms? I tried to create one, but got this error - The LDAP operation has failed : Object class violation (LDAPERR 65)207B: UpdErr: DSID-03050FB5, problem 6002 (OBJ_CLASS_VIOLATION), data 0 (ARERR 3377) I think the problem is Request ID field (samAccountname in my case). Remedy does not allow to enter data into this Request ID field during request creation and I have absolutely no idea how to avoid this. Any help would be highly appreciated. Thank you. Kind Regards / C ? Dmitry Bezhenar ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Date/time format
Hello List, I have a problem with the date/time format on our ARS server. At the moment our format is like this (if I write $TIMESTAMP$ somewhere) MM/DD/YY HH:MM:SS AM/PM But we use the following format in Russia - DD/MM/YY HH:MM:SS without AM/PM I tried to find how to change the date/time format in the documentation, but this doesn't describe how to set it - ARDATE The date format used by the program. UNIX only-This value consists of a string of operators as defined by the strftime library call (some combinations appear successfully, but cannot be translated for input). If you do not set this variable, the system uses the date format for the language specified by the LANG environment variable. What does it mean - as defined by the strftime library call? Could you give an example? Thank you. ENV: ARS 6.3 Oracle 9.2i Solaris 9 Kind Regards / C ? Dmitry Bezhenar ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
How to search a request using Enter keyboard button without having a focus on the Search button
Hello List, Our users ask me to implement the following functionality - On the HPD:Helpdesk form in the search mode they enter some data and then have to press the Search button. Is it possible to search for requests using Enter button on the keyboard without setting focus to the Search button before. Thank you. ARS 6.3 PS: Sorry for a long title. Kind regards / С уважением Dmitry Bezhenar SIEMENS Siemens IT Solutions and Services Kozhevnicheskij Per. 6 Moscow / Russia Tel.+7 495 737 2697 Mob. +7 916 615 7978 Email [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
Re: How to search a request using Enter button RESOLVED
Thanks, Norm. Kind Regards / C уважением Dmitry Bezhenar From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96 CS/SCCE Sent: Monday, June 18, 2007 6:34 PM To: arslist@ARSLIST.ORG Subject: Re: How to search a request using Enter keyboard button without having a focus on the Search button ** Sure. Do create an active link that fires on RETURN in the field and question and then the RUN IF should be a run process: PERFORM-ACTION-APPLY. Norm From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Bezhenar, Dmitry Sent: Monday, June 18, 2007 8:26 AM To: arslist@ARSLIST.ORG Subject: How to search a request using Enter keyboard button without having a focus on the Search button Hello List, Our users ask me to implement the following functionality - On the HPD:Helpdesk form in the search mode they enter some data and then have to press the Search button. Is it possible to search for requests using Enter button on the keyboard without setting focus to the Search button before. Thank you. ARS 6.3 PS: Sorry for a long title. Kind regards / С уважением Dmitry Bezhenar SIEMENS Siemens IT Solutions and Services Kozhevnicheskij Per. 6 Moscow / Russia Tel.+7 495 737 2697 Mob. +7 916 615 7978 Email [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
How to refresh a parent form?
Hello List, I use an additional display-only form to set some values into the parent regular. After changes are commited and a user closes the display-only form I need to refresh the parent form in order to display the new values without pressing F5 button. How can I do it? Thank you. Kind regards / С уважением Dmitry Bezhenar SIEMENS Siemens IT Solutions and Services Kozhevnicheskij Per. 6 Moscow / Russia Tel.+7 495 737 2697 Mob. +7 916 615 7978 Email [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
Re: How to refresh a parent form?
OK. Thanks. What action should AL perform on receiving an event in order to refresh the active request? Kind Regards / C уважением Dmitry Bezhenar -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mike Chepaykin Sent: Thursday, June 07, 2007 4:52 PM To: arslist@ARSLIST.ORG Subject: Re: How to refresh a parent form? You have to send EVENT from child form and handle it in parent. Take a look at PERFORM-ACTION-SEND-EVENT RunProcess command. I use an additional display-only form to set some values into the parent regular. After changes are commited and a user closes the display-only form I need to refresh the parent form in order to display the new values without pressing F5 button. How can I do it? -- Mike Chepaykin ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: How to refresh a parent form?
I did it using push fields action and got this refresh issue. Now I am trying to use Open Window On-Close field mapping. It doesn't work yet. Now I'm going to take a look into the AL.log in order to find out if this AL(which open display-only window) is executed on closing or not. Kind Regards / C уважением Dmitry Bezhenar -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mike Chepaykin Sent: Thursday, June 07, 2007 5:36 PM To: arslist@ARSLIST.ORG Subject: Re: How to refresh a parent form? What action should AL perform on receiving an event in order to refresh the active request? You have to refresh a table field on parent form, or refresh datafields in regular form? If regular form, how do you set new data to parent form from chind form - with OnClose option of Open Window action or with PushFields action? -- Mike Chepaykin ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: How to refresh a parent form? - Resolved
Yes, you are right. I missed the commit action. Now I got it. Thanks ARslist. Perfect community. :) Kind Regards / C уважением Dmitry Bezhenar -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mike Chepaykin Sent: Thursday, June 07, 2007 5:56 PM To: arslist@ARSLIST.ORG Subject: Re: How to refresh a parent form? I did it using push fields action and got this refresh issue. Bad design :) Now I am trying to use Open Window On-Close field mapping. It doesn't work yet. Now I'm going to take a look into the AL.log in order to find out if this AL(which open display-only window) is executed on closing or not. You have to know, that OnOpen and OnClose options are NOT logged. But I have an idea why your OnClose is not working - you have to do CommitChanges action before CloseWindow action in child form. -- Mike Chepaykin ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: External MS SQL Data/SMS
Hi John, What platform are you using for Oracle? If your Oracle is under Windows try using tg4msql. Otherwise you can still use a tg4msql, but you will need an intermediate Oracle-on-Windows instance. Kind Regards / C ? Dmitry Bezhenar From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of John Kovalcik Sent: Wednesday, April 11, 2007 4:26 PM To: arslist@ARSLIST.ORG Subject: External MS SQL Data/SMS ** Listers, What is the easiest way to access SMS data that resides in an external MS SQL database ? All I want to do is read the data. Our current environment is ARS 6.3 and Oracle 10g. Thanks, John M. Kovalcik Kennametal Inc. __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
OT: javac [newbie question]
Hello List,
I experience some problems while compiling the MyAuthenticator.java file.
I execute the following command -
javac -classpath C:\Program Files\Apache Software Foundation\Tomcat
5.5\common\lib\servlet-api.jar c:\MyAuthenticator.java
And get the following errors -
c:\MyAuthenticator.java:15: package com.remedy.arsys.session does not exist
import com.remedy.arsys.session.Authenticator;
^
c:\MyAuthenticator.java:16: package com.remedy.arsys.session does not exist
import com.remedy.arsys.session.UserCredentials;
^
c:\MyAuthenticator.java:24: cannot find symbol
symbol: class Authenticator
public class MyAuthenticator implements Authenticator {
^
c:\MyAuthenticator.java:48: cannot find symbol
symbol : class UserCredentials
location: class com.yourcompany.sso.MyAuthenticator
public UserCredentials getAuthenticatedCredentials(
^
c:\MyAuthenticator.java:56: cannot find symbol
symbol : class UserCredentials
location: class com.yourcompany.sso.MyAuthenticator
return new UserCredentials(user.toLowerCase(), pw, authStr);
^
5 errors
Did I miss something in classpath?
Thank you.
Kind Regards / C ?
Dmitry Bezhenar
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the
Answers Are
Re: Password + LDAP authentification = NO Encrypt ion?
That is not a real link. Just an example. You should have your own certsrv. Kind Regards / C ? Dmitry Bezhenar -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Zinoviev Alexander Sent: Friday, April 06, 2007 5:45 PM To: arslist@ARSLIST.ORG Subject: Re: Password + LDAP authentification = NO Encrypt ion? Hello, Jarl, Link https://dcldap1.eng.remedy.com/certsrv/ doesn`t work... It means that this description is not actual... Kind regards, Alexander Zinoviev -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jarl Groneng Sent: Friday, April 06, 2007 4:30 PM To: arslist@ARSLIST.ORG Subject: Re: Password + LDAP authentification = NO Encrypt ion? Can't find any dead links in the document provided. BTW; you stated that there is no actual description, not that you asked for an actual description. -- Jarl On 4/6/07, Zinoviev Alexander [EMAIL PROTECTED] wrote: Thank you for the answer, but I asked ACTUAL description. This document contains dead links and I can`t get sertificates... Kind regards, Alexander Zinoviev -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Vincent RIEDWEG Sent: Friday, April 06, 2007 4:10 PM To: arslist@ARSLIST.ORG Subject: RE: Password + LDAP authentification = NO Encrypt ion? Hi, Look at here and enjoy :) http://www.bmc.com/arsystem/dht/archive/11-01-2005_A.htm Regards, Vincent. De: Action Request System discussion list(ARSList) de la part de Zinoviev Alexander Date: ven. 06/04/2007 13:35 À: arslist@ARSLIST.ORG Objet : Password + LDAP authentification = NO Encryption? ** Hello, I can see non-encrypted domain password in my traffic. Does anybody have an experience with LDAP SSL configuring? There is no actual documentation how to do it (to get a sertificate). Kind regards, Alexander Zinoviev __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Unable to submit requests on a view form. Request ID is an IDENTITY column.
Hello List, Is it possible to omit Request ID field (C1) during INSERT operation into the view form? My key field is IDENTITY (auto increamental) and denies submission into that field. Thank you. Kind regards / С уважением Dmitry Bezhenar SIEMENS OOO Siemens Business Services Kozhevnicheskij Per. 6 Moscow / Russia Tel.+7 495 737 2697 Mob. +7 916 615 7978 Email [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
Inserting into view form - request ID issue
Hello List,
I experience some problems with inserting rows into our view forms.
The SQL log shows
INSERT INTO T3321 (C536870913,C1) VALUES ('test',1)
*** ERROR *** ORA-02047: cannot join the distributed transaction in progress
C1 field is a key (request ID), it should be incremental.
I have 50 records already in that table and C1 cannot equal 1.
Is it possible to assign Request ID for view forms manually?
Maybe I should recreate this view form and make Request ID field another way?
Thank you.
Kind regards / С уважением
Dmitry Bezhenar
SIEMENS
OOO Siemens Business Services
Kozhevnicheskij Per. 6
Moscow / Russia
Tel.+7 495 737 2697
Mob. +7 916 615 7978
Email [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
FW: Inserting into view form - request ID issue
Executing -
update arschema set nextid = 200 where schemaid='3321';
did not help.
The same error occures -
INSERT INTO T3321 (C536870913,C1) VALUES ('test',200)
*** ERROR *** ORA-02047: cannot join the distributed transaction in progress
While now I can execute successfully this coomand
INSERT INTO T3321 (C536870913,C1) VALUES ('test',200)
using SQLPlus.
Our environment is -
Solaris 9 + Oracle 9.2
Kind Regards / C уважением
Dmitry Bezhenar
From: Bezhenar, Dmitry
Sent: Monday, March 12, 2007 12:28 PM
To: 'arslist@ARSLIST.ORG'
Subject: Inserting into view form - request ID issue
Hello List,
I experience some problems with inserting rows into our view forms.
The SQL log shows
INSERT INTO T3321 (C536870913,C1) VALUES ('test',1)
*** ERROR *** ORA-02047: cannot join the distributed transaction in progress
C1 field is a key (request ID), it should be incremental.
I have 50 records already in that table and C1 cannot equal 1.
Is it possible to assign Request ID for view forms manually?
Maybe I should recreate this view form and make Request ID field another way?
Thank you.
Kind regards / С уважением
Dmitry Bezhenar
SIEMENS
OOO Siemens Business Services
Kozhevnicheskij Per. 6
Moscow / Russia
Tel.+7 495 737 2697
Mob. +7 916 615 7978
Email [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
Re: Unicode and Kanji on the web.- I am bummed
Have you set up Db-character-set: UTF-8 parameter in the ar.conf file? Kind Regards / C уважением Dmitry Bezhenar -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rocky Rockwell Sent: Friday, March 02, 2007 5:45 AM To: arslist@ARSLIST.ORG Subject: Unicode and Kanji on the web.- I am bummed Hi guru folks I am in a dilemma, I am trying to mid-tier 7.0.1 to work with Kanji and I am failing miserably. I have mid-tier on solaris 9, weblogic 8.1.sp3 web server and mid-tier 7.0.1, Oracle 10g has been configured for utf-8 User testing has a user preference setting of Japan for locale and the mid-tier is set to use user preference going to the correct system ARS is 7.0.1 configured for utf-8, all of the variables for both oracle and ARS are set up correctly as far as I can tell. Yet is still come up with ?? in the description field were they are using IE6 on a Japan PC. Anyone have any ideas as to what I have missed/overlooked/forgotten/etc. This should not be rocket science, but maybe it is. any and all help is /*extremely*//* welcome*/! -- *Rocky* Rocky Rockwell eMA Team – Remedy Developer [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Ph#1: 214-567-8874 Ph#2: 325-884-1263 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Database was succesfully migrated to Unicode. NLS_LANG problem
Hello Everybody, Recently I have successfully migrated Remedy database to Unicode. SQL select * from nls_database_parameters where parameter like '%CHARACTERSET'; NLS_CHARACTERSET AL32UTF8 NLS_NCHAR_CHARACTERSET AL16UTF16 However, if I try to run arsystem with $NLS_LANG = American_America.AL32UTF8 the ars server does not start. It starts only if I use singlebyte charset for NLS_LANG variable - WE8ISO8859P1 or CL8MSWIN1251. The problem is that this NLS_LANG value allows only WE8ISO8859P1 or CL8MSWIN1251 characters (depending on the NLS_LANG value) to work properly. Did I miss something? Thank you. Env: Oracle 9.2 Solaris 9 Remedy ARS 6.3 Kind Regards / C ? Dmitry Bezhenar ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
ARDBC - some AD fields are not visible
Hello List, I need to create a vendor form using ARDBC connection to our Active Directory. There are hundreds or fields available for selection(objectclass=user), but some fields are missing, i.e. extensionAttribute1 , extensionAttribute2, etc.. We store a lot of useful information in these fields? Anybody knows how to add them to a vendor form? Thank you. Kind Regards / C ? Dmitry Bezhenar ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Error while creating a view form (ORA-00904)
Hello List, I've set up a connection between ORACLE and MS SQL server using tg4msql. Now I'm trying to create a view form directly on the MS SQL table ([EMAIL PROTECTED]) After clicking on the LOAD button it shows me the list of fields and I choose the unique identifier. When I click the CREATE button it shows me the following error - Failure during SQL operation to the database : ORA-00904: ROLEID: invalid identifier (ARERR 552). After switching on the sql logging I found an SQL statement, which fires this error - CREATE VIEW T3294 (C1) AS SELECT RoleID FROM [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] I tried to input the same statement using SQL'plus - it really fires Oracle error - ORA-00904: ROLEID: invalid identifier At the same time if I type RoleID in quotes it works - SELECT RoleID FROM [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Anybody knows a workaround for this. Thank you. PS: I need this view form in order to be able to modify data in MS SQL tables. PPS: Our environment: ARS 6.3.16 on Oracle 9.2.0.7 on MS Windows 2003 + MS SQL 2000 (8.0.818) Kind Regards / C ? Dmitry Bezhenar ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
FW: Error while creating a view form (ORA-00904) - SOLVED
I've found a workaround by myself. (-: Only upper-case columns are visible this way. Thank you. Kind Regards / C ? Dmitry Bezhenar From: Bezhenar, Dmitry Sent: Tuesday, January 30, 2007 8:57 PM To: 'arslist@ARSLIST.ORG' Subject: Error while creating a view form (ORA-00904) Hello List, I've set up a connection between ORACLE and MS SQL server using tg4msql. Now I'm trying to create a view form directly on the MS SQL table ([EMAIL PROTECTED]) After clicking on the LOAD button it shows me the list of fields and I choose the unique identifier. When I click the CREATE button it shows me the following error - Failure during SQL operation to the database : ORA-00904: ROLEID: invalid identifier (ARERR 552). After switching on the sql logging I found an SQL statement, which fires this error - CREATE VIEW T3294 (C1) AS SELECT RoleID FROM [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] I tried to input the same statement using SQL'plus - it really fires Oracle error - ORA-00904: ROLEID: invalid identifier At the same time if I type RoleID in quotes it works - SELECT RoleID FROM [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Anybody knows a workaround for this. Thank you. PS: I need this view form in order to be able to modify data in MS SQL tables. PPS: Our environment: ARS 6.3.16 on Oracle 9.2.0.7 on MS Windows 2003 + MS SQL 2000 (8.0.818) Kind Regards / C ? Dmitry Bezhenar ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Newbie workflow question
Hello List, Sorry for a newbie question. I have several escalations which take data from different vendor and view forms and put them into different regular forms. I would like to link these Push fields actions to a button click. I tried to transform all escalations into ALs and then link them together using AL guide. Unfortunately it does not work. When I click a button (with a Call guide action) it pushes only one record. How should I construct my workflow to have import on a button click? Thank you. Kind regards / ? ? Dmitry Bezhenar ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Newbie workflow question
Thanks for your explanation Carey. One thing I don't understand is executing an action on every row in a table (i.e. view/vendor form). For example, escalation can set field to a specified value in every row in the table. Since I want to do it using a button-click I cannot use escalations here. Filter does another thing - it is triggered on submitting/modifiing/etc.. But I cannot run it on every row. The row has to be already modified by something else to trigger a filter. Kind Regards Dmitry Bezhenar -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black Sent: Wednesday, January 17, 2007 5:40 PM To: arslist@ARSLIST.ORG Subject: Re: Newbie workflow question Dmitry, No problem. ( You said you are new so here is a bit of my ARS design thoughts. Sorry it is so long. :) ) In general Escalations are a lot like a Push action with the Modify all matching condition. Which can be done from an Active Link or a Filter. Except that the Escalation is triggered by time passing and Active Links and Filters are triggered by a single user action or data transaction. The the point is that: Escalations and Active Links can trigger a Filter. However Escalations and Filters can NOT trigger an Active Link. Nor can a Filter or an Active Link trigger an Escalation. So if your design is to implement it once and trigger from various triggers then you put the workflow in Filters and you can then call it from Active Links, Filters, or Escalations. :) I know it might seem complicated at first, but it really is very simple at the end of the day. If you know any programming language, then ARS is likely strange. Well until you learn these objects and how they interact. If you do not know any programming language, then ARS is likely very different but also approachable for very simple application tasks. ( The more programming experience you have the more design patterns you can identify in ARS. The more design patterns you actually use then the more compact and scalable your ARS applications will be. However that is more a speed/return on investment measurement. You can be very functional in ARS with very little programming experience too. However you will likely spend a lot of time repeating what you did somewhere else in the application, over and over again.) Good luck. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On 1/17/07, Bezhenar, Dmitry [EMAIL PROTECTED] wrote: Thank you Carey, Though I didn't think it would be so complicated. :) Kind Regards / C ? Dmitry Bezhenar ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Newbie workflow question
Yes, it works! Thanks Joe, Carey and L.J. and God :) Kind Regards / C ? Dmitry Bezhenar From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joseph Kubasek Sent: Wednesday, January 17, 2007 6:51 PM To: arslist@ARSLIST.ORG Subject: Re: Newbie workflow question ** Dmitry, As I understand it, you want to do a push from each and every row in a form and have that triggered by workflow on a button. There are a few different ways that you can do this, but Carey's suggestion is probably the simplest. Try this. (I will assume that you want to do a push from every row in FormA or some subset of the fields.) 1. Add a display only field on FormA. Make sure that who ever will be pushing the button has write access it it. 2. Add a filter that fires on modify when the display only field equals some fixed value, say DOITNOW. 3. Add a button on what ever form you want that has an active link with a push action that pushes the value DOITNOW into the dsiplay only field you added to FORMA. Make sure that the qualification includes every row in FormA, or every row that you are interested in pushing from. You need both the filter on the form and the push action to every row on the button. The filter performs the action you want and the active link selects the rows that you want to act on. Joe Kubasek The Ohio State University On 1/17/07, Bezhenar, Dmitry [EMAIL PROTECTED] wrote: Thanks for your explanation Carey. One thing I don't understand is executing an action on every row in a table (i.e. view/vendor form). For example, escalation can set field to a specified value in every row in the table. Since I want to do it using a button-click I cannot use escalations here. Filter does another thing - it is triggered on submitting/modifiing/etc.. But I cannot run it on every row. The row has to be already modified by something else to trigger a filter. Kind Regards Dmitry Bezhenar -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black Sent: Wednesday, January 17, 2007 5:40 PM To: arslist@ARSLIST.ORG Subject: Re: Newbie workflow question Dmitry, No problem. ( You said you are new so here is a bit of my ARS design thoughts. Sorry it is so long. :) ) In general Escalations are a lot like a Push action with the Modify all matching condition. Which can be done from an Active Link or a Filter. Except that the Escalation is triggered by time passing and Active Links and Filters are triggered by a single user action or data transaction. The the point is that: Escalations and Active Links can trigger a Filter. However Escalations and Filters can NOT trigger an Active Link. Nor can a Filter or an Active Link trigger an Escalation. So if your design is to implement it once and trigger from various triggers then you put the workflow in Filters and you can then call it from Active Links, Filters, or Escalations. :) I know it might seem complicated at first, but it really is very simple at the end of the day. If you know any programming language, then ARS is likely strange. Well until you learn these objects and how they interact. If you do not know any programming language, then ARS is likely very different but also approachable for very simple application tasks. ( The more programming experience you have the more design patterns you can identify in ARS. The more design patterns you actually use then the more compact and scalable your ARS applications will be. However that is more a speed/return on investment measurement. You can be very functional in ARS with very little programming experience too. However you will likely spend a lot of time repeating what you did somewhere else in the application, over and over again.) Good luck. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On 1/17/07, Bezhenar, Dmitry [EMAIL PROTECTED] wrote: Thank you Carey, Though I didn't think it would be so complicated. :) Kind Regards / C ? Dmitry Bezhenar
How to force midtier to convert Charset?
Hi List, As an alternative to Unicode we use different character sets for different clients. For example, the character set of a server is Western European (WE8ISO8859P15). If you connect to this server from a Remedy client with another One-byte character set (for example, a cyrillic one) you could work with cyrillic data. Though if you take a look at the contents of the DB through Oracle Content Viewer there would be garbage. The problem appears when you try to work with that data using Mid-Tier. It shows the same garbage as Oracle Content Viewer does. Is there a way to force Mid-Tier to convert charset before displaying? Thank you. Env: ARS 6.3.16 Sol 9 Oracle 9.2 Tomcat on 5.5 on Windows 2003 Kind regards / С уважением Dmitry Bezhenar SIEMENS OOO Siemens Business Services Kozhevnicheskij Per. 6 Moscow / Russia Tel.+7 495 737 2697 Mob. +7 916 615 7978 Email [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
Re: Import Tool v6.3 P19 or BMCRemedy's Import Fix Debacle
Hi All, If you need Excel to export csv's in the right format - take a look at this link - http://support.microsoft.com/kb/291296 I've used this procedure for some time and I didn't notice any problems. Kind Regards / C ? Dmitry Bezhenar From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Hugo Visser Sent: Monday, December 18, 2006 1:05 PM To: arslist@ARSLIST.ORG Subject: Re: Import Tool v6.3 P19 or BMCRemedy's Import Fix Debacle ** Michelle, Unfortunately there is no true csv format. There are several variants, some supporting returns. Some use quoted values, some do not. From a technical point of view it is very hard to support just csv. The import tool should be detecting the csv variant, but obviously it is only sticking to one format, which they even fixed. What you could do is process the exported csv in such a way that the import tool will import those correctly (for example replacing the return characters). Or use a more reliable format such as xml for the export and import. Btw, Excel tends to change long colums to # in my csv export, and it's also using ; (the list separator) in my csv files. For csv I've ditched Excel and I'm using OpenOffice. OpenOffice allows me to control how my csv is exported and it is working great. Hugo On 12/15/06, Lucero, Michelle - IST contractor [EMAIL PROTECTED] wrote: Hey, Folks: First, am I only the one who takes issue with this statement? Remedy was never meant to import data from other sources, Tech Support by way of backline engineering. ...and working as designed. We have fixed something that was broken [for almost 15] years. I have an issue that I have been fighting since May 1, 2006. The original issue is fixed however engineering has introduced another. I mean a HUGE one that they consider to be a fix. I wholeheartedly disagree. TEST A: (Export data from external application. Import into a test Remedy form with these steps) Export about 25 records from an application with large text fields that might contain returns or commas. For sanity sake, open it in Excel. Verify that you see 25 rows of data. (You will. Excel comprehends true CSV.) Close file without saving. Open ANY other version of the import tool BESIDES Import Tool 6.3 P19. Map fields accordingly to your Remedy form. Import. Expected Results: Check test form. You should see the 25 records imported. TEST B: (Follow the same steps as listed above, with one exception. Use the 6.3 Patch 19 import tool. Undesired Results: Your 25 records might turn into 35, 40, 50, etc. For the extra records that are created, data will be thrown into incorrect fields. The first 25 rows that are listed will not contain all of the data. TEST B according to Remedy Engineering is a FIX and is working as designed. I call it an UNUSABLE data disaster. That was the bad news. The worse news is that this will be the fix for all subsequent patches. If Remedy Engineering really meant what they said, Remedy was never meant to import data from other sources. Then how would new customers ever expect to migrate their data into a Remedy form. Since, I thought the statement was the most ludicrous thing I'd ever heard, I asked for it to be repeated...and it was. Since this has been going on for so long (it started with the fallback mapping issue). I honestly would welcome someone from BMC Remedy to tell me that there has been a huge miscommunication. Because if Patch 19 is the fix for something that has been working properly since the first time I imported data, then the import tool has now been rendered useless. We will now have to tell potential customers, I'm sorry there is no way for us to migrate your existing data. Stepping down from my soapbox, Michelle ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Wrong $TIMESTAMP$ time in notifications
Hello list, We have configured our Helpdesk notifications with a $Timestamp$ in the mail subject. Now when I create a ticket for myself (just for example) I receive a notification with a wrong $TIMESTAMP$. For example, if I create a ticket at 8:30, I receive a notification that a ticket was created at 5:30 (always 3 hours less). When I type date on the server (Solaris 9, Oracle9) I receive the right time. Where should I set the offset? Thank you. Kind Regards / C ? Dmitry Bezhenar ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Wrong $TIMESTAMP$ time in notifications
Yes, Joe, you are right. The output of date command was with a GMT time (without offset), which is incorrect. Our offset is GMT + 3. I will now correct the time on the server. Thanks a lot. Kind Regards / C ? Dmitry Bezhenar From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Tuesday, December 12, 2006 4:35 PM To: arslist@ARSLIST.ORG Subject: Re: Wrong $TIMESTAMP$ time in notifications ** Dmitry, Whats the output when you type date?? You might be getting 8:30 but what time zone? If your timezone is right, check your environment settings for your timezone for the user that runs the AR System deamons. Cheers Joe - Original Message From: Bezhenar, Dmitry [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Tuesday, December 12, 2006 5:43:57 AM Subject: Wrong $TIMESTAMP$ time in notifications Hello list, We have configured our Helpdesk notifications with a $Timestamp$ in the mail subject. Now when I create a ticket for myself (just for example) I receive a notification with a wrong $TIMESTAMP$. For example, if I create a ticket at 8:30, I receive a notification that a ticket was created at 5:30 (always 3 hours less). When I type date on the server (Solaris 9, Oracle9) I receive the right time. Where should I set the offset? Thank you. Kind Regards / C ? Dmitry Bezhenar Everyone is raving about the all-new Yahoo! Mail beta. http://us.rd.yahoo.com/evt=42297/*http://advision.webevents.yahoo.com/mailbeta __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: How to access MS SQL tables from Oracle? - SOLVED
Hi List, I've created a link from Oracle on Solaris to MS SQL database using one additional Oracle-on-Windows server (with tg4msql installed). Now I can make SQL requests to MS SQL database from sqlplus - for example, select * from Tablename.DBlink-name; Now I need to create a view form in Remedy Administrator. There is a statement in Basic manual that I should use the following format for the table name - [EMAIL PROTECTED] Whatever I try to input here the following error occurs - Requested database table not found. Please check the spelling (table name is case-sensitive) (ARERR 481). Should I do anything else with a DBLink? Thank you. Kind Regards / C ? Dmitry Bezhenar From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Luke, Brian Sent: Friday, November 24, 2006 7:55 AM To: arslist@ARSLIST.ORG Subject: Re: How to access MS SQL tables from Oracle? ** There are a couple of options: 1.) Purchase Croom Consultings ARDBC adapter for SQL Server, this is an ARS Application level connection. This requires that ARS run on Windows. 2.) Use the MSSQL ODBC Driver with Oracle Heterogeneous Services / Oracle generic connectivity. This requires that Oracle be on Windows. 3.) If Oracle is on Linux/UNIX, you can purchase the DataDirect SQL Server ODBC driver and use it with Oracle Heterogeneous Services / Oracle generic connectivity. -Brian From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Bezhenar, Dmitry Sent: Thursday, November 23, 2006 12:12 AM To: arslist@ARSLIST.ORG Subject: OT: How to access MS SQL tables from Oracle? ** Hello List, Is there any third-party products for accessing MS SQL tables from Oracle database? I would like to create an MS-SQL-based view form within Oracle-based ARS. I know that MS SQL allows to create DB-links for accessing Oracle tables. It is a built-in functionality. Thank you. Kind Regards Dmitry Bezhenar __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: How to access MS SQL tables from Oracle? - SOLVED
Thank you, Carey. Now it works. Additionaly I had to substitute * with column names in quotes. Otherwise only select * from worked with the view. Kind Regards / C уважением Dmitry Bezhenar -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black Sent: Monday, November 27, 2006 5:49 PM To: arslist@ARSLIST.ORG Subject: Re: How to access MS SQL tables from Oracle? - SOLVED Dmitry, You could try creating a local view object in the ARS DB. Have the view do all of the fancy DB LINK stuff. This way ARS only sees a simple table and does not have to do anything special to select/update the linked table. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On 11/27/06, Bezhenar, Dmitry [EMAIL PROTECTED] wrote: ** Hi List, I've created a link from Oracle on Solaris to MS SQL database using one additional Oracle-on-Windows server (with tg4msql installed). Now I can make SQL requests to MS SQL database from sqlplus - for example, select * from Tablename.DBlink-name; Now I need to create a view form in Remedy Administrator. There is a statement in Basic manual that I should use the following format for the table name - [EMAIL PROTECTED] Whatever I try to input here the following error occurs - Requested database table not found. Please check the spelling (table name is case-sensitive) (ARERR 481). Should I do anything else with a DBLink? Thank you. Kind Regards / C уважением Dmitry Bezhenar ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
After converting charset in Oracle (WE8ISO8859P15 - AL32UTF8) ARS service can not start
Hello List, another Oracle question. I am now in process of converting the charset in our Oracle database from WE8ISO8859P15 to AL32UTF8. The procedure is mostly similar to the following description - Character Set Scanner utility though the change from US7ACII to UTF8 could be done with only using the 'alter database command' we will use the character set scanner utility CSSCAN to scan for any change required. Installing the CSSCAN schema. Before using the cssan you must install the schema as a user with DBA privileges. This is done by executing the csminst.sql script located at $ORACLE_HOME/rdbms/admin cd $ORACLE_HOME/rdbms/admin $sqlplus / as sysdba SQL*Plus: Release 9.2.0.6.0 - Production on Tue Oct 17 16:00:16 2006 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to: Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.6.0 - Production SQL START csminst.sql Executing CSSCAN The CSSCAN executable is located at the $ORACLE_HOME/bin. After executing the script you must connect to the Database as a user with DBA privileges. The CSSCAN utility prompts you with options to scan a table, schema or the enter database. We choose to scan the entire database in our case. The CSSCAN displays your current character set version and prompts you to enter the new character set version. $ csscan Character Set Scanner v1.1 : Release 9.2.0.1.0 - Production on Tue Oct 17 16:03:15 2006 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Username: system Password: Connected to: Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.6.0 - Production (1) Full database, (2) User, (3) Table: 1 1 Enter new database character set name: UTF8 Enter number of scan processes to utilize (1..32): 1 After the successful completion of the scan three report files will be created scan.txt, scan.out and scan.err. In my case I have exported the database objects with exceptions as specified in the scan.out and plan to import it back after the database conversion is done. Changing the Character Set at Database Level Shutdown all application services and the database and listener. You must do a clean shutdown of your database and start it up in restricted mode before changing the character set. Also you must not have any active sessions before issuing the alter database command. SQL alter database character set internal_use UTF8; alter database character set internal_use UTF8 Import Back Database Objects. After a successful character set conversion at the database level now you can import back the objects and rebuild the indexes specified the in scan.out report. I've searched for all the objects that are not convertible using this csscan utility, modified these objects (mostly it was exceed column size error and I just enlarged column sizes). Then I switched the charset (alter database character set internal_use UTF8). The database seemed to work fine. So I started the ARS service. But the service did not start. There are two possible explanations - 1. The procedure described above is not right. It is not possible to upgrade the database to Unicode this way. If so, what is a right procedure? 2. I need to change something in ARS configuration files also. ARS can not connect to a database with another char set so easily. If so, what should I correct in ARS? Thank you for your assistance. I tried to find the procedure of switching/upgrading to Unicode within ARS manuals with no success. Environment: Oracle 9.2 + ARS 6.3 on a Win2003 platform. This is our test/development server. I will have to switch our productive one (ARS 6.3 + Oracle 9.2 + Solaris 9) later on also. Kind regards Dmitry Bezhenar
Re: After converting charset in Oracle (WE8ISO8859P15 - AL32UTF8) ARS service can not start
Hello Axton, ARADMIN.FIELD_DISPPROP - I enlarged the column size of the PROPSHORT column. That's all. :) Also I had to rebuild some indexes - SYS.I_COL1 OE.CUST_EMAIL_IX ARADMIN.ACTLINK_IND ARADMIN.ARCTR_IND ARADMIN.CHAR_MENU_IND ARADMIN.FILTER_IND ARADMIN.I2725_706000322_1 ARADMIN.I2920_536870913_1 ARADMIN.I2921_536870913_1 ARADMIN.I832_536870916_1 When I try to view contents of the database I see some strange values - ?DERUNG (should be ÄNDERUNG). I suppose some European characters did not convert correctly. arerror.log contents - ORA-00020: maximum number of processes (%s) exceeded 390600 : Verbindung mit SQL-Datenbank kann nicht initialisiert werden. (ARERR 551) Stop server 390600 : AR System-Server wurde beendet - Schwerwiegender Fehler ist aufgetreten (ARNOTE 21) Also I've set NLS_LANG to American_America.AL32UTF8. Is it correct? Thank you. Kind Regards Dmitry Bezhenar From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Friday, November 24, 2006 12:01 PM To: arslist@ARSLIST.ORG Subject: Re: After converting charset in Oracle (WE8ISO8859P15 - AL32UTF8) ARS service can not start ** arerror.log and arapi.log output would be extremely helpful. There are some ar.conf values that need to be set to use a unicode db. Something like Db-Character-Set. ...and I just enlarged column sizes What tables/columns? Axton Grams On 11/24/06, Bezhenar, Dmitry [EMAIL PROTECTED] wrote: Hello List, another Oracle question. I am now in process of converting the charset in our Oracle database from WE8ISO8859P15 to AL32UTF8. The procedure is mostly similar to the following description - Character Set Scanner utility though the change from US7ACII to UTF8 could be done with only using the 'alter database command' we will use the character set scanner utility CSSCAN to scan for any change required. Installing the CSSCAN schema. Before using the cssan you must install the schema as a user with DBA privileges. This is done by executing the csminst.sql script located at $ORACLE_HOME/rdbms/admin cd $ORACLE_HOME/rdbms/admin $sqlplus / as sysdba SQL*Plus: Release 9.2.0.6.0 - Production on Tue Oct 17 16:00:16 2006 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to: Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.6.0 - Production SQL START csminst.sql Executing CSSCAN The CSSCAN executable is located at the $ORACLE_HOME/bin. After executing the script you must connect to the Database as a user with DBA privileges. The CSSCAN utility prompts you with options to scan a table, schema or the enter database. We choose to scan the entire database in our case. The CSSCAN displays your current character set version and prompts you to enter the new character set version. $ csscan Character Set Scanner v1.1 : Release 9.2.0.1.0 - Production on Tue Oct 17 16:03:15 2006 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Username: system Password: Connected to: Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.6.0 - Production (1) Full database, (2) User, (3) Table: 1 1 Enter new database character set name: UTF8 Enter number of scan processes to utilize (1..32): 1 After the successful completion of the scan three report files will be created scan.txt, scan.out and scan.err. In my case I have exported the database objects with exceptions as specified in the scan.out and plan to import it back after the database conversion is done. Changing the Character Set at Database Level Shutdown all application services and the database and listener. You must do a clean shutdown of your database and start it up in restricted mode before changing the character set. Also you must not have any active sessions before issuing the alter database command. SQL alter database character set internal_use UTF8; alter database character set internal_use UTF8 Import Back Database Objects. After a successful character set conversion at the database level now you can import back the objects and rebuild the indexes specified the in scan.out report. I've searched for all the objects that are not convertible using this csscan utility, modified
Re: How to access MS SQL tables from Oracle?
Sorry, I didn't post our environment description. Oracle 9.2i on a Solaris 9 platform - ARS (v6.3) is also on this server. MS SQL 2000 on a Win2003 server. What do you think about Remedy Link for SQL Server? Brian, from your post it seems to me that only the third option is suitable for us. Thank you for your answers. Kind Regards / C ? Dmitry Bezhenar From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Luke, Brian Sent: Friday, November 24, 2006 7:55 AM To: arslist@ARSLIST.ORG Subject: Re: How to access MS SQL tables from Oracle? ** There are a couple of options: 1.) Purchase Croom Consultings ARDBC adapter for SQL Server, this is an ARS Application level connection. This requires that ARS run on Windows. 2.) Use the MSSQL ODBC Driver with Oracle Heterogeneous Services / Oracle generic connectivity. This requires that Oracle be on Windows. 3.) If Oracle is on Linux/UNIX, you can purchase the DataDirect SQL Server ODBC driver and use it with Oracle Heterogeneous Services / Oracle generic connectivity. -Brian From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Bezhenar, Dmitry Sent: Thursday, November 23, 2006 12:12 AM To: arslist@ARSLIST.ORG Subject: OT: How to access MS SQL tables from Oracle? ** Hello List, Is there any third-party products for accessing MS SQL tables from Oracle database? I would like to create an MS-SQL-based view form within Oracle-based ARS. I know that MS SQL allows to create DB-links for accessing Oracle tables. It is a built-in functionality. Thank you. Kind Regards Dmitry Bezhenar __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
OT: How to access MS SQL tables from Oracle?
Hello List, Is there any third-party products for accessing MS SQL tables from Oracle database? I would like to create an MS-SQL-based view form within Oracle-based ARS. I know that MS SQL allows to create DB-links for accessing Oracle tables. It is a built-in functionality. Thank you. Kind Regards Dmitry Bezhenar ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Mid-tier 7.0.1 (Tomcat) + ARS 6.3 problem
Hello List, I am trying to connect a Mid-tier 7.0.1 to our ARS 6.3 Server. Mid-tier 7.0.1 is installed the following way - (Windows 2003) 1. JRE 1.5 (It didn't ask for SDK). 2. Tomcat 5.5.17 3. Copied arsys.war (aka Mid-tier 7.0.1) to \webapps 4. Restarted Tomcat service. Seemed to work since I could access Midtier-config tool, but I did not know the dafault password, so 5. Removed arsystem.password Now I could access Midtier config tool with an emplty password 6. Added our ARS server (Solaris 9) IP-address and it's port number onto AR Server Settings http://helpdesk/arsys/shared/config/config_arslist.jsp form. (It aslo asked for Admin Password) but I didn't understand which password does it mean, so I didn't enter any. That's all. Now I tryed to access ARS server, but whatever login and password I enter it shows me the following error - type Exception report message description The server encountered an internal error () that prevented it from fulfilling this request. exception javax.servlet.ServletException: Servlet execution threw an exception root cause java.lang.NoClassDefFoundError com.remedy.arsys.api.ProxyPool.get(ProxyPool.java:62) com.remedy.arsys.api.PoolingProxyManager.getProxy(PoolingProxyManager.java:66) com.remedy.arsys.api.Util.ARSetSessionConfiguration(Util.java:184) com.remedy.arsys.session.LoginServlet.authenticate(Unknown Source) com.remedy.arsys.session.LoginServlet.doLogin(Unknown Source) 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) note The full stack trace of the root cause is available in the Apache Tomcat/5.5.17 logs. What is wrong? Did I miss something? Where can I find a more detailed error log? Thank you. Kind Regards / C ? Dmitry Bezhenar ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Mid-tier 7.0.1 (Tomcat) + ARS 6.3 problem
After restarting Tomcat and trying to set midtier passwod for the ARS server once again - the following error appeared - type Exception report message description The server encountered an internal error () that prevented it from fulfilling this request. exception javax.servlet.ServletException: Servlet execution threw an exception root cause java.lang.UnsatisfiedLinkError: no arutiljni70 in java.library.path java.lang.ClassLoader.loadLibrary(Unknown Source) java.lang.Runtime.loadLibrary0(Unknown Source) java.lang.System.loadLibrary(Unknown Source) com.remedy.arsys.util.ARUtilEgcp.clinit(ARUtilEgcp.java:7) com.remedy.arsys.config.ConfigServlet.addServer(Unknown Source) com.remedy.arsys.config.ConfigServlet.editServer(Unknown Source) com.remedy.arsys.config.ConfigServlet.performOperation(Unknown Source) com.remedy.arsys.config.ConfigServlet.doRequest(Unknown Source) com.remedy.arsys.config.ConfigServlet.postInternal(Unknown Source) com.remedy.arsys.config.ConfigServlet.doPost(Unknown Source) javax.servlet.http.HttpServlet.service(HttpServlet.java:709) javax.servlet.http.HttpServlet.service(HttpServlet.java:802) note The full stack trace of the root cause is available in the Apache Tomcat/5.5.17 logs. Kind Regards / C ? Dmitry Bezhenar From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ian Trimnell Sent: Friday, November 17, 2006 12:50 PM To: arslist@ARSLIST.ORG Subject: Re: Mid-tier 7.0.1 (Tomcat) + ARS 6.3 problem ** Bezhenar, Dmitry wrote: ** Hello List, I am trying to connect a Mid-tier 7.0.1 to our ARS 6.3 Server. Mid-tier 7.0.1 is installed the following way - (Windows 2003) 1. JRE 1.5 (It didn't ask for SDK). 2. Tomcat 5.5.17 3. Copied arsys.war (aka Mid-tier 7.0.1) to \webapps 4. Restarted Tomcat service. Seemed to work since I could access Midtier-config tool, but I did not know the dafault password, so 5. Removed arsystem.password Now I could access Midtier config tool with an emplty password 6. Added our ARS server (Solaris 9) IP-address and it's port number onto AR Server Settings http://helpdesk/arsys/shared/config/config_arslist.jsp form. (It aslo asked for Admin Password) but I didn't understand which password does it mean, so I didn't enter any. That's all. Now I tryed to access ARS server, but whatever login and password I enter it shows me the following error - Kind Regards / C ? Dmitry Bezhenar Dmitry, I think what you need here is to set the Mid-Tier Admin Password in the Admin Tool first. Then use that password in the Midtier config tool and you should be able to connect through. When you install a 7.0.x ARS server the installation process requires you to enter passwords for both the Application Service and Mid-Tier, which I think is a new requirement. Hope this helps. Ian Ian Trimnell, AR System Lead Developer (amongst other jobs), Specialist Support Information Team, Academic Administrative Computing Service Open University, MILTON KEYNES, UK Phone: 01908 653741 web: http://www.open.ac.uk/ __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
How to determine a filter which denies deleting requests from a form?
** Hello List, I am trying to delete requests from a form using "Ctrl + D", but nothing happens.Actions - Delete button in also "frozen". It seems to me that some filter denies deletes on this form, but I can not determine which one exactly.Could anybody tell me what should I search for in the list of filters related to this form? Thank you. PS: Iam in the "Administrator" group on this server. Kind Regards/ CDmitry Bezhenar __20060125___This posting was submitted with HTML in it___
Re: How to determine a filter which denies deleting requests from a form? - Resolved
Hi Misi, Yes you're right. The problem was in MenuAccess for the current View. My assuption about filter limitations was wrong. Thank you. Kind Regards / C ? Dmitry Bezhenar -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Misi Mladoniczky Sent: Monday, October 23, 2006 2:28 PM To: arslist@ARSLIST.ORG Subject: Re: How to determine a filter which denies deleting requests from a form? Hi Dmitry, What do you mean by frozen? Do you mean disabled? In that case, I would check ARAdmin-Form-CurrentView-Properties-MenuAccess-Delete. A filter stopping the operation should give you an Error Message. Best Regards - Misi, RRR AB, http://www.rrr.se Hello List, I am trying to delete requests from a form using Ctrl + D, but nothing happens. Actions - Delete button in also frozen. It seems to me that some filter denies deletes on this form, but I can not determine which one exactly. Could anybody tell me what should I search for in the list of filters related to this form? Thank you. PS: I am in the Administrator group on this server. Kind Regards / C ? Dmitry Bezhenar ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Unix/Oracle - Windows/SQL Server - SOLVED
Thank you, I've downloaded the ARInside tool. The best there is. BTW, I didn't find it on http://www.mattreinfeldt.com/ Another link - http://system.devdor.net/software.php#arinside Kind Regards Dmitry Bezhenar -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of L. J. Head Sent: Friday, October 06, 2006 8:47 PM To: arslist@ARSLIST.ORG Subject: Re: Unix/Oracle - Windows/SQL Server ARInside will give you several listing options. One of which is to look at all AL's by Actions and will give you a list of how many AL's (and filters for that matter) have each type of action as well as details of those actions L. J. Head Software Engineer Remedy Approved Consultant -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Bezhenar, Dmitry Sent: Friday, October 06, 2006 1:25 AM To: arslist@ARSLIST.ORG Subject: Unix/Oracle - Windows/SQL Server Hello List, We are now migrating our server from Solaris 9 - Oracle 9.2 environment to Windows - SQL Server one. There are 2 problems with this process - 1. Run process 2. Direct SQL Is there a way to search for every workflow element which contains these actions? In order to find out if this particular action will work on a different platform. Thank you. PS: I've tried to do it with a *.def files using notepad with no success. Kind Regards Dmitry Bezhenar ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Unix/Oracle - Windows/SQL Server
Hello List, We are now migrating our server from Solaris 9 - Oracle 9.2 environment to Windows - SQL Server one. There are 2 problems with this process - 1. Run process 2. Direct SQL Is there a way to search for every workflow element which contains these actions? In order to find out if this particular action will work on a different platform. Thank you. PS: I've tried to do it with a *.def files using notepad with no success. Kind Regards Dmitry Bezhenar ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Migrator - how to copy difference only?
Hello List, We have two development servers with a huge ammount of objects (3000 forms, 15000 filters, etc...). In the beginning these two servers were equal, but then different developers worked with each server for some time. Now there is a task to clone one server onto another one. Since there is little difference between these two servers there should be a way to copy differences only using Migrator... Could anybody help us with this? Thank you. ARS 6.3.16 + Oracle 9.2.0.7 Kind Regards Dmitry Bezhenar ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
OT: Oracle question
Hello List, I am a newbie in Oracle and I have some problems with importing a full database dump. During the import process I receive the following errors - IMP-00041: Warning: object created with compilation warnings (many times) IMP-00017: following statement failed with ORACLE error 12154: IMP-3: ORACLE error 12154 encountered ORA-12154: TNS:could not resolve service name (twice) Thank you. PS: The import command is the following Imp system/*** file=*** full=y log=*** Kind Regards Dmitry Bezhenar ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Oracle question
Title: RE: Oracle question ** Hi James, I've just installed a new clear Oracle, created Aradmin user in it (see KM-6831), created "Arsystem" tablespace and now I am trying to import this full_blabla.dmp file. Kind Regards Dmitry Bezhenar From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3Sent: Thursday, September 14, 2006 8:17 PMTo: arslist@ARSLIST.ORGSubject: Re: Oracle question ** Dmitry: Are you attempting to import to an existing database or a brand new one? James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Bezhenar, Dmitry Sent: Thursday, September 14, 2006 9:15 AM To: arslist@ARSLIST.ORG Subject: OT: Oracle question Hello List, I am a newbie in Oracle and I have some problems with importing a full database dump. During the import process I receive the following errors - IMP-00041: Warning: object created with compilation warnings (many times) IMP-00017: following statement failed with ORACLE error 12154: IMP-3: ORACLE error 12154 encountered ORA-12154: TNS:could not resolve service name (twice) Thank you. PS: The import command is the following Imp system/*** file=*** full=y log=*** Kind Regards Dmitry Bezhenar ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: Oracle question
Thank you Axton and James, I will try your suggestions tomorrow, now it's a late evening in Russia. :) Kind Regards / C ? Dmitry Bezhenar -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Thursday, September 14, 2006 9:15 PM To: arslist@ARSLIST.ORG Subject: Re: Oracle question The text after the IMP-00041 is necessary to debug the issue of improperly compiled objects. Chances are these are the db views for some join forms that were not properly compiled properly before the export (common for join forms) on the last db; or db views for view forms that reference a db link. For the ORA-12154, chances are you have a view form that uses a db link that does not exist on the oracle instance to which you are importing the dump. If this is the case, correct this by creating the db links before running the import. Axton Grams On 9/14/06, McKenzie, James J C-E LCMC HQISEC/L3 [EMAIL PROTECTED] wrote: ** Dmitry: Are you attempting to import to an existing database or a brand new one? James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Bezhenar, Dmitry Sent: Thursday, September 14, 2006 9:15 AM To: arslist@ARSLIST.ORG Subject: OT: Oracle question Hello List, I am a newbie in Oracle and I have some problems with importing a full database dump. During the import process I receive the following errors - IMP-00041: Warning: object created with compilation warnings (many times) IMP-00017: following statement failed with ORACLE error 12154: IMP-3: ORACLE error 12154 encountered ORA-12154: TNS:could not resolve service name (twice) Thank you. PS: The import command is the following Imp system/*** file=*** full=y log=*** Kind Regards Dmitry Bezhenar ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
ITSM 6 installation speed up
Title: Workflow to fire on every restart of Remedy ** Hello List, some months ago I noticed a post with some useful tips how to speed up ITSM 6 installation on ARS 6.3. Unfortunately I can not find that post now. Does anybodyremember it? Thank you. Kind regardsDmitry Bezhenar __20060125___This posting was submitted with HTML in it___
Re: Oracle database - full export file (.dmp)
Title: RE: Oracle database - full export file (.dmp) ** James, There are some additional catalogs - such as /approval, /helpdesk, /assetetc.. If I create a new instance of ARS using Oracle import - all these catalogs are missing... Does it mean that I need to install all Remedy software before doing import, or it is not necessary? The source infrastructure is Solaris 9 + Oracle 9.2 , ARS 6.3.17 (ITSM 6) + numerous customizations. My infrastructure is Win2003 + Oracle 9.2, ARS 6.3.17 Many thanks. Kind Regards/ CуважениемDmitry Bezhenar From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3Sent: Wednesday, August 30, 2006 6:34 PMTo: arslist@ARSLIST.ORGSubject: Re: Oracle database - full export file (.dmp) ** Dmitry: There is an option to overwrite existing tables when you do an import. You have to use that option or you will get this error. Migrator is always a good option to doing a complete database import or restoral. The fact that you are on Windows2K3 and the other system is Solaris should not cause this error. Remedy uses different builds of the same program between Solaris and Windows2K3. James McKenzie From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Bezhenar, Dmitry Sent: Wednesday, August 30, 2006 7:17 AM To: arslist@ARSLIST.ORG Subject: Re: Oracle database - full export file (.dmp) ** Thank you, James. Does it matter that my colleague used Oracle under Solaris, and I am under win2003? Maybe using Migrator would be a better alternative in this case? While trying to startup ARS after import I am getting the following error in the arerror.log - 390600 : The form definition file field count does not match number of fields in the file (ARERR 403) What is wrong? Thanks for your patience. Kind Regards / C уважением Dmitry Bezhenar From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3 Sent: Wednesday, August 30, 2006 5:54 PM To: arslist@ARSLIST.ORG Subject: Re: Oracle database - full export file (.dmp) ** Dmitry: Install the EXACT same version of ARS onto a new Oracle database. Then run the import process to bring in the .dmp file. This should work without a problem. James Mckenzie From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Bezhenar, Dmitry Sent: Wednesday, August 30, 2006 6:02 AM To: arslist@ARSLIST.ORG Subject: Oracle database - full export file (.dmp) ** Hello list, My collegue sent me an Oracle database export file (bla_bla.dmp). Could you please explain me the procedure of reproducing ARS using this export file. What should I do first? Install clear ARS on my Oracle instance or import .dmp file into my database? Thank you for your assistance. Kind Regards / C уважением Dmitry Bezhenar __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Oracle database - full export file (.dmp)
** Hello list, My collegue sent me an Oracle database export file (bla_bla.dmp). Could you please explain me the procedure of reproducing ARS using this export file. What should I do first? Install clear ARS on my Oracle instance or import .dmp file into my database? Thank you for your assistance. Kind Regards/ CDmitry Bezhenar __20060125___This posting was submitted with HTML in it___
Re: Oracle database - full export file (.dmp)
Title: RE: Oracle database - full export file (.dmp) ** Thank you, James. Does it matterthat my colleague usedOracle under Solaris, and I am under win2003? Maybe using Migrator would be a better alternative in this case? While trying to startup ARS after import I am getting the following error in the arerror.log - 390600 : The form definition file field count does not match number of fields in the file (ARERR 403) What is wrong? Thanks for your patience. Kind Regards/ CуважениемDmitry Bezhenar From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3Sent: Wednesday, August 30, 2006 5:54 PMTo: arslist@ARSLIST.ORGSubject: Re: Oracle database - full export file (.dmp) ** Dmitry: Install the EXACT same version of ARS onto a new Oracle database. Then run the import process to bring in the .dmp file. This should work without a problem. James Mckenzie From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Bezhenar, Dmitry Sent: Wednesday, August 30, 2006 6:02 AM To: arslist@ARSLIST.ORG Subject: Oracle database - full export file (.dmp) ** Hello list, My collegue sent me an Oracle database export file (bla_bla.dmp). Could you please explain me the procedure of reproducing ARS using this export file. What should I do first? Install clear ARS on my Oracle instance or import .dmp file into my database? Thank you for your assistance. Kind Regards / C уважением Dmitry Bezhenar __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
MidTier on Linux / Windows
** Thank you, Derek! Could you also share with us some tomcat performance best practices? If you know any. Thanks, again. Kind Regards/ CDmitry Bezhenar From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Derek BerubeSent: Monday, July 31, 2006 4:22 PMTo: arslist@ARSLIST.ORGSubject: Re: MidTier on Linux ** I've included my comments in your original message below. Derek On Jul 30, 2006, at 12:59 PM, Jason McDonald wrote: ** Thanks. I went through the installation instructions, but was unsure what other softwares I need to DL and which exact file to DL. When I visited some of the websites which host the additional softwares reqd. , I was overwhelmed by the amount of links there were for a single product. I just need: I am assuming that i'll be setting up a mid-tier for: 1) ARS 7.0 2) Windows platform 3) I don't have IIS (Is it licensed or free?) IIS is free and included as part of the operating system. If you're running on Windows XP, I believe it is called "Personal Web Sharing". On Windows Server 2003, it may be an optional install. As is the case with Apache, unless you need IIS for something other than Mid-Tier, I would not bother installing it at all. Anything related to Mid-Tier is going to be handed off to ServletExec or Tomcat (depending on which you install) and that is where the real "work" happens. In this specific scenario, introducing IIS just adds another unnecessary layer. The only advantage I may see with using IIS on Windows is perhaps for ARS Mid-Tier sites which are very busy. Since IIS is integrated into the operating system, I would like to assume that it has been very finely tuned to effectively manage a high number of socket connections. In performance intensive situations, people tend to use either the Apache Portable Runtime with Tomcat or the Grizzly connector to manage socket-based communications. If you decide to use Tomcat with IIS, you're going to need to install the ISAPI filter for Tomcat. 4) Should i DL tomcat or apache or both? And from what exact link should i DL for windows 32 bit version? Unless you need Apache for other features, I would just install Tomcat. Much of my reasoning behind this can be found in the earlier discussion for using IIS. Since Tomcat is 100% pure Java, there is no 32/64-bit choice. Just download Tomcat 5.5.17 and install it. 5) Apart from tomcat or apache or both, what other S/w is needed? You will need to have the Java Development Kit installed. I would install Sun's Java Standard Edition 5.0 Release 7 Development Kit (a.k.a., J2SE 1.5 release 7). There are other options from other vendors, but this is the one I generally use. I'd be curious to know how many on the list are using JRockit or the IBM JVM. It's been a while since I've looked at benchmarks. 6) In what order should i install these products? JDK IIS or Apache (optional) Tomcat Mid-Tier If you are going to use Tomcat alone, then when prompted to choose a web server, select the "Other" option. Do the same for the question about the Servlet Engine. I don't normally do this in LINUX/UNIX (I use symbolic links instead), but when you install Mid-Tier, install it to the Tomcat_Installation/webapps/arsys folder. For example, if you install Tomcat to C:\Program Files\Apache Tomcat, then install Mid-Tier to C:\Program Files\Apache Tomcat\webapps\arsys. Good luck with your install! __20060125___This posting was submitted with HTML in it___
Re: Many ARDBC connections
Hi Carey, What do you mean by just had to write the second, third,... n th, ARDBC yourself ?? What is the difference between writing an ARDBC and writing an AREA Plugin? Thank you. Kind Regards Dmitry Bezhenar -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black Sent: Tuesday, July 18, 2006 6:54 PM To: arslist@ARSLIST.ORG Subject: Re: Many ARDBC connections Rick, v5 could do that. You just had to write the second, third,... n th, ARDBC yourself. Or, if we are talking about AREA LDAP connections, then you had to write your own AREA plugin. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. Never ascribe to malice, that which can be explained by incompetence. On 7/18/06, Rick Cook [EMAIL PROTECTED] wrote: From what I have heard, the answer is that it does. Read the docs for more info. Rick -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Bezhenar, Dmitry Sent: Monday, July 17, 2006 11:56 PM To: arslist@ARSLIST.ORG Subject: Many ARDBC connections Hello List, Does ARS 7 support more than 1 concurrent ARDBC connections to different LDAP servers? Thank you. Kind Regards / C ? Dmitry Bezhenar ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Many ARDBC connections
OK, Thank you, Rick. Unfortunately I do not have acces to the v7 docs currently. Kind Regards / C ? Dmitry Bezhenar -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook Sent: Tuesday, July 18, 2006 7:25 PM To: arslist@ARSLIST.ORG Subject: Re: Many ARDBC connections Matt, I think the question was whether more than one CONCURRENT connection was supported. V7 is the first version that does that, from what I have seen and heard. Rick -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black Sent: Tuesday, July 18, 2006 7:54 AM To: arslist@ARSLIST.ORG Subject: Re: Many ARDBC connections Rick, v5 could do that. You just had to write the second, third,... n th, ARDBC yourself. Or, if we are talking about AREA LDAP connections, then you had to write your own AREA plugin. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. Never ascribe to malice, that which can be explained by incompetence. On 7/18/06, Rick Cook [EMAIL PROTECTED] wrote: From what I have heard, the answer is that it does. Read the docs for more info. Rick -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Bezhenar, Dmitry Sent: Monday, July 17, 2006 11:56 PM To: arslist@ARSLIST.ORG Subject: Many ARDBC connections Hello List, Does ARS 7 support more than 1 concurrent ARDBC connections to different LDAP servers? Thank you. Kind Regards / C ? Dmitry Bezhenar ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Remedy and MS SQL
Hello list, We are using self-written ServiceDesk software, which stores our asset data in MS SQL database. Is it possible to create an engine which would parse the asset database on a regular basis and update asset data in the Remedy ITSM OOTB? I’ve seen something similar in the CMDB Configuration Guide (Reconciliation Engine?..), but I could not understand how to set it to work with MS SQL tables. Thank you for assistance. Kind regards Dmitry Bezhenar
Re: First ARS 7.0 Document
Rick, Do you have any information on ITSM 7 and CMDB 2 release date? Is it soon ;) or not very soon (in 60-90 days)? Kind regards Dmitry Bezhenar -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook Sent: Wednesday, May 03, 2006 12:29 AM To: arslist@ARSLIST.ORG Subject: Re: First ARS 7.0 Document I don't know why they don't just say ARS 7.0 will be released on X date. I was told a date today, and though I can't (for some reason) say what it is, I will say it's very soon. And ITSM 7/CMDB 2.0 will follow sometime after that. Maybe they should just say, like Duke Nuke'm Forever, that it will be ready When it's ready. Rick -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Chuck Sears Sent: Tuesday, May 02, 2006 12:42 PM To: arslist@ARSLIST.ORG Subject: First ARS 7.0 Document I was just looking at the document download section the Remedy support page and the first 7.0 document has been released. It is titled BMC Remedy Virtual Environment Statement of Direction. It looks like we may see the release of 7.0 soon. ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Removing entries from a form.
** Hello list,I am a newbie in ARS development.Could you explain how to remove entries from a form. For instance I would like to remove a person entryfrom a "Person Information" form (Remedy ITSM 6 OOTB) using an ActiveLink. Thank you for assistance. Kind regards / Dmitry Bezhenar __20060125___This posting was submitted with HTML in it___
Re: Removing entries from a form.
** Yes, The name of the form is SHR:Person. I thought there should be a method similar to "push fields"... Maybe "pop fields"? ;-) Kind regards / С уважением Dmitry Bezhenar From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dave BarberSent: Saturday, May 06, 2006 4:40 PMTo: arslist@ARSLIST.ORGSubject: Re: Removing entries from a form. I got into using direct SQL a little while back (for everything possible, it seemed), and used that method - DELETE FROM formname WHERE criteria Of course, you've got to be darned careful on the criteria. I'm nowhere near our servers at the moment, but I think the form would be SHR_Person? Regards Dave On 06/05/06, Bezhenar, Dmitry [EMAIL PROTECTED] wrote: ** Hello list,I am a newbie in ARS development.Could you explain how to remove entries from a form. For instance I would like to remove a person entryfrom a "Person Information" form (Remedy ITSM 6 OOTB) using an ActiveLink. Thank you for assistance. Kind regards / С уважениемDmitry Bezhenar__20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: Removing entries from a form.
** Arun, Is it possible to remove multiple entries that way? I would like ot remove all the entries from the "SHR:People" form. Kind regards / С уважением Dmitry Bezhenar From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Arun KandelSent: Saturday, May 06, 2006 4:46 PMTo: arslist@ARSLIST.ORGSubject: Re: Removing entries from a form. Run process: Application-Delete-Entry "SHR:People" $Entry-Id$ should do it. Arun On 5/6/06, Bezhenar, Dmitry [EMAIL PROTECTED] wrote: ** Hello list,I am a newbie in ARS development.Could you explain how to remove entries from a form. For instance I would like to remove a person entryfrom a "Person Information" form (Remedy ITSM 6 OOTB) using an ActiveLink. Thank you for assistance. Kind regards / С уважениемDmitry Bezhenar__20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: Removing entries from a form.
** Thank you for detailed response. "Ctrl+D" is enough for the moment. I've just tried to create an Activelink(run process Application-Query-Delete-Entry ...), but the foollowing erroroccured after executing "The system cannot find the file specified.". I think I should set some enviromental variables in order to perform Remedy commands... Thank you again. Kind regards / С уважением Dmitry Bezhenar From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Roney SamuelSent: Saturday, May 06, 2006 6:49 PMTo: arslist@ARSLIST.ORGSubject: Re: Removing entries from a form. Dear Dmitry, It depends on how many entries you have on the form.If its just a simple deletion of entries you can use the user tool and delete the entries (CTRL + D). If you want to build workflow to delete the entries you have to write an AL guide and get the list of entry ids on the form. Use the Run Process commands to delete the entries after looping through the records. Read theguides you will know exactly what i am talking about. Let me know if you require more clarification. Regards, Roney Samuel Varghese On 5/6/06, Bezhenar, Dmitry [EMAIL PROTECTED] wrote: ** Arun, Is it possible to remove multiple entries that way? I would like ot remove all the entries from the "SHR:People" form. Kind regards / С уважением Dmitry Bezhenar From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG ] On Behalf Of Arun KandelSent: Saturday, May 06, 2006 4:46 PM To: arslist@ARSLIST.ORGSubject: Re: Removing entries from a form. Run process: Application-Delete-Entry "SHR:People" $Entry-Id$ should do it. Arun On 5/6/06, Bezhenar, Dmitry [EMAIL PROTECTED] wrote: ** Hello list,I am a newbie in ARS development.Could you explain how to remove entries from a form. For instance I would like to remove a person entryfrom a "Person Information" form (Remedy ITSM 6 OOTB) using an ActiveLink. Thank you for assistance. Kind regards / С уважениемDmitry Bezhenar__20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
