Re: JSP and ARS

2008-12-24 Thread Carey Matthew Black
Guillermo, AR System form names standards are not required to be compliant with SQL object name standards. You likely are trying to search on an DB object that does not exists. I think the ARODBC driver uses the views that exist in the AR System DB and that you need to use the DB names of those

AR Server Crash - Not sure why... - ARS 7.1 patch 2

2008-12-24 Thread Chowdhury, Tauf
All, OK, this is a new issue that started this week. Environment: AR: Server group, win2k3, 2 AR servers. 2 Mid tier servers running exclusively on tomcat. Remote Oracle 10g DB on Unix cluster. ITSM 7.0.3 p7 ARS 7.1 patch 2, mid tier on tomcat 5.5.20. Symptoms: 1. Users cannot log

OT: Seasons Greetings..

2008-12-24 Thread Joe D'Souza
Wish you all on the list a Very Merry Christmas and a bright and prosperous New Year ahead. For those of you who are non Christians, I wish you a very happy holidays and a Happy New Year.. Have a safe celebration. Cheers Joseph D'Souza No virus found in this outgoing message. Checked by AVG.

Re: AR Server Crash - Not sure why... - ARS 7.1 patch 2

2008-12-24 Thread Joe D'Souza
Tauf, The RPC call GLEWF is a Get List Entry With Fields, a call that seems to be failing while trying to populate the form after a search with fields in the current entry as well as populate the Results List.. I would begin with asking djones what he or she did at the time when the error

Re: AR Server Crash - Not sure why... - ARS 7.1 patch 2

2008-12-24 Thread Rick Cook
Is there anything new in the Oracle configuration? This sounds like AR server is losing connectivity with the db. Rick Sent from my Verizon Wireless BlackBerry -Original Message- From: Chowdhury, Tauf tauf.chowdh...@frx.com Date: Wed, 24 Dec 2008 10:10:38 To:

Re: AR Server Crash - Not sure why... - ARS 7.1 patch 2

2008-12-24 Thread Chowdhury, Tauf
Joe, Thanks for the quick response. I think RPC is the clue. The reason I think that is because after this happened, when I tried using RDP to remote into the 'secondary' AR server, I got an RPC error. RPC Unavailable. So what that leads me to believe is that because the 1 server could not

Re: AR Server Crash - Not sure why... - ARS 7.1 patch 2

2008-12-24 Thread Joe D'Souza
Not really, that doesn't sound too logical. Failure on one ARS Server in a server group shouldn't impact other ARS Servers in the same server group if the database is intact. Try finding out what search the user tried to run and investigate if there is anything that the search returns that the AR

Re: JSP and ARS

2008-12-24 Thread Joe D'Souza
Also view names cannot be more than 30 characters in length and if that means that you get two forms that might generate a duplicate view, the second form will get post fixed with its schemaid. Also recently I got to know through one of the members on the list on a similar thread that if there is

Re: Regarding Macros

2008-12-24 Thread Ron Pierce
Macro will overwrite the defaults. You need to pass the values in the macro. I would recommend using an AL Open Window action though as the Macro action is fairly outdated for this. Ron Date: Tue, 23 Dec 2008 17:33:15 +From: rav...@rediffmail.comsubject: Regarding MacrosTo:

Re: AR Server Crash - Not sure why... - ARS 7.1 patch 2

2008-12-24 Thread Ron Pierce
Tauf, I had a similarissue, about exact actually, last week. It ended up being 1 User Tool Client that was crashing when any workflow kicked off and, somehow, it was crashing the ARS server as well. Once the single User Tool instance was identified and the User closed and restarted the UT

Creating Decrementing value in Table

2008-12-24 Thread Amey Bhosale
Hi All,   I am currently working on ARS 7.1 and have a query to ask you all.   I have created a Regular Form on which i have added a table field(holding data into anothe form) which displays only those records which have a flag set to Yes   On this Regular Form i have added a Add/Modify  and

Re: Creating Decrementing value in Table

2008-12-24 Thread Opela, Gary L CTR USAF AFMC 72 CS/SCBAH
I'm assuming that whenever you 'delete' a record, you are simply changing the status so that it doesn't show up on the table, then refreshing the table. You could add a filter that runs on the child form, the one from which the table is pulling its data, and have that filter run whenever the

Re: Creating Decrementing value in Table

2008-12-24 Thread Arlist333
You could use a single SQL statement in an Active Link to update records to order_id -1, where the order_id than that for the record just deleted. Just add an integer display only field 'zTmpCurOrderId' which is set to the order_id for the current record about to be deleted. Use this

cmdb2.x import templates

2008-12-24 Thread Jason Niu
Hi there, I am trying to create some excel templates, so that I can import cmdb data in CSV file into CMDB. What is the best way to generate the templates? Or what is your approach to this? I am concerning there are too many fields in each cmdb Class and also there are over 10 classes I

Re: cmdb2.x import templates

2008-12-24 Thread Rick Cook
I would start with an export from existing records. That way you will get the hidden fields. Make sure you don't import data that is supposed to be created by work flow. Rick Sent from my Verizon Wireless BlackBerry -Original Message- From: Jason Niu thevis...@optonline.net

Re: Creating Decrementing value in Table

2008-12-24 Thread AMEY BHOSALE
Hi Mike, Can you tell me whether writing SQL statement will it affect the performance of checking each record and then updating it? Also would you be able to send me the code at amey.x.bhos...@jpmorgan.com id so that i can check and test the same? Regards Amey On Wed, Dec 24, 2008 at 10:20

Re: Creating Decrementing value in Table

2008-12-24 Thread AMEY BHOSALE
Hi Opela, Thanks for the response. On Delete Button i have set an AL which set the record status to No which was initially Yes and hence the record will no longer appear in the Table as the qualification of table is to display only those records which are Yes.So now this record will still

Re: Creating Decrementing value in Table

2008-12-24 Thread Opela, Gary L CTR USAF AFMC 72 CS/SCBAH
Well, if you are wanting to increment the counter, then you are going to have to increment any ticket that has a counter greater than the counter on the current ticket. This could potentially get to be a very large update, depending on how many records are in this table. Now, how you accomplish

OT: May we all find happiness in the upcoming year

2008-12-24 Thread Howard Richter
The past year has been hard for some members of this list, and my hope is next year that are all just a little happer and a little better off. With that said, now for one of my my quotes; *True happiness is to enjoy the present, without anxious dependence upon the future, not to amuse ourselves

Rajini K Sanapala is out of the office.

2008-12-24 Thread Rajini K Sanapala
I will be out of the office starting 25/12/2008 and will not return until 26/12/2008. Thank you for your message, I will respond to your message when I return. ___ UNSUBSCRIBE or access ARSlist Archives at

ADM:Merry insert celebration of your choice

2008-12-24 Thread Daniel Bloom
I expect traffic on the list to be light for the next week or so, therefore allow me to: 1) Wish you all the best... Christmas, Hannukah, Kwanza or other celebration of the Season 2) Wish you a Happy New Year! For those that follow the western calendar 3) In these difficult times, both