Changing Login Names

[Prashant Patil]

Dear friends,

There is a requirement with one of our clients to change their login names.
They were earlier using LDAP iPlanet email server for authentication and now
they are moving to LDAP Active Directory.

Please advice on what steps to take on changing all the login names in the
system. Client is using ARS 6.0.1, HD 5.6 with Oracle 9iR2 on Solaris 8.



Thanks and regards,

Prashant

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: JDBC ARDBC Plugin

[Jarl Grøneng]

Hi,

For me it would be nice 5-10 years ago, but today almost all of the
integration are done aplication - application(and also trough
middleware), and not to the databases. SOAP and J2EE rules the
integration at the moment...

--
Jarl

On 9/8/07, Axton <[EMAIL PROTECTED]> wrote:
> With the new java based plugin server introduced in 7.1, can I get a
> show of hands in who would the interested in a jdbc driver implemented
> as an ARDBC plugin?
>
> Seems that a generic implementation would allow access to any remote
> db that provides a jdbc driver (Oracle, MSSQL, MySQL, LDAP, MS Access,
> SQLLite, PostgreSQL, Domino, DB2, etc.).
>
> Seems the targets could be almost endless.
>
> Axton Grams
>
> ___
> 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: AR 6.3 How to Populate a Table with a SQL Query?

[Jarl Grøneng]

Just remember that you can not use the rownum to up update the remote table.

--
Jarl

On 9/8/07, Grooms, Frederick W <[EMAIL PROTECTED]> wrote:
> Since it is a view of an external DB do the following.
>
> Create a local view of the external DB.  Inside the local view add
> Rownum as a column in the query from the external database (use
> LPAD(rownum,15,'0') to create a 15 character "0" padded columm).
>
> Have your Remedy View form use the local view as it's source and the
> Rownum column as the unique key.
>
> Personally I never create a Remedy view form across a dbLink.  I always
> make a local db view.  This way when I move a form from Dev to Test to
> Production the form does not change even if the dbLink has to change
> between environments.
>
> Fred
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:[EMAIL PROTECTED] On Behalf Of Paul Blasquez
> Sent: Friday, September 07, 2007 4:28 PM
> To: arslist@ARSLIST.ORG
> Subject: Re: AR 6.3 How to Populate a Table with a SQL Query?
>
> Unfortunately, neither of these solutions creates a column that is a
> suitable key field.  From the documentation:
>
> The database table must have a column (field) that enforces non-null and
> unique values. This column will act as the Request ID. If the
> administrator chooses a column that is non-unique or allows nulls, data
> corruption will probably occur. The Request ID field must be an integer
> field or a character field that is no less than 6 and no greater than 15
> characters.
> Otherwise, the Key field list will be empty, and you will not be able to
> create the view form.
>
>
> My DBA and I are still trying to create a column that meets this
> requirement.
>
> -Paul
>
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W
> Sent: Friday, September 07, 2007 12:14 PM
> To: arslist@ARSLIST.ORG
> Subject: Re: AR 6.3 How to Populate a Table with a SQL Query?
>
> Add the Column ROWNUM to the view
>
> Fred
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:[EMAIL PROTECTED] On Behalf Of Nall, Roger
> Sent: Friday, September 07, 2007 2:11 PM
> To: arslist@ARSLIST.ORG
> Subject: Re: AR 6.3 How to Populate a Table with a SQL Query?
>
> If it truly a view then you should be able to add a column to the view
> that will act as Request ID. Make sure that you increment the column by
> 1 for each record.
>
> HTH,
>
> Roger A. Nall
> Manager, OSSNMS Remedy
> T-Mobile USA
> Desk: 813-348-2556
> Cell: 973-652-6723
> FAX: 813-348-2565
> sf49fanv AIM IM
> RogerNall   Yahoo IM
>
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:[EMAIL PROTECTED] On Behalf Of Paul Blasquez
> Sent: Friday, September 07, 2007 3:08 PM
> To: arslist@ARSLIST.ORG
> Subject: Re: AR 6.3 How to Populate a Table with a SQL Query?
>
> Ah yes, view forms. (You can tell I'm new at this.)
>
> Unfortunately, while creating the view, none of my database fields
> qualify as an index (tripping up on the 6-15 char window).
>
> I'm trying to work around this in oracle (the table is actually a view
> of an external DB so I have no control of that varchar limit), any other
> methods of implementing are appreciated.
>
> Thanks!
>
> -Paul
>
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:[EMAIL PROTECTED] On Behalf Of Opela, Gary L Contr
> OC-ALC/ITMA
> Sent: Friday, September 07, 2007 11:43 AM
> To: arslist@ARSLIST.ORG
> Subject: Re: AR 6.3 How to Populate a Table with a SQL Query?
>
> You cannot populate a table via direct SQL (unfortunately). You can,
> however, create a remedy view and point it to a database SQL view of
> what you need, then point the remedy table to the view you created.
>
> Now, to pass a dynamic variable in the table qualification field, check
> out EXTERNAL() function in the AR Admin basic book.
>
> Thanks,
>
>
> Gary Opela, Jr
>
> Sr. Remedy Developer
>
> Leader Communications, Inc.
>
> 405 736 3211
>
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:[EMAIL PROTECTED] On Behalf Of Paul Blasquez
> Sent: Friday, September 07, 2007 12:16 PM
> To: arslist@ARSLIST.ORG
> Subject: AR 6.3 How to Populate a Table with a SQL Query?
>
> Hello,
>
> I have a 'Customer Data' page on my main form in which there is one
> read/write character field named 'Company Name+', and several read-only
> character fields.  I have set up a menu that reads from an Oracle View
> SQL query our database of customers, attached it to the 'Customer Data'
> field. and set up a couple active links so that when a search term is
> entered into Customer Data, or a Customer is chosen from the menu, the
> read-only fields are filled in with the appropriate SQL result columns.
>
> Now, my issue is that I would also like to have a table on the page that
> I can populate wi

Re: Changing Login Names

[Jarl Grøneng]

This it not an easy task!

But there is a tool from RRR (https://www.rrr.se),rrrLoginConv,  that
may help you a bit on the way. Still there will be some manual
convert...

"This tool will go through one or all forms of an ARServer and convert
login names as dictated by your convertfile.

Conversion of ordinary character fields, diary-entries and
status-history is done."

--
Jarl

On 9/9/07, Prashant Patil <[EMAIL PROTECTED]> wrote:
> **
>
> Dear friends,
>
> There is a requirement with one of our clients to change their login names.
> They were earlier using LDAP iPlanet email server for authentication and now
> they are moving to LDAP Active Directory.
>
> Please advice on what steps to take on changing all the login names in the
> system. Client is using ARS 6.0.1, HD 5.6 with Oracle 9iR2 on Solaris 8.
>
>
>
> Thanks and regards,
>
> Prashant
>  __20060125___This posting was
> submitted with HTML in it___

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: EIE/Marimba connect error

[Kelly Deaver]

Drew,

You have a wrong value in your Oracle settings somewhere. That is what error 
550 means.
Make sure, for Oracle, that everything is listed uppercase. If that doesn't do 
it,
try connecting, from the AR Server, with the oracle client. This is what EIE is 
doing,
if you can't connect directly with the values, neither can EIE.

Once you have the values set where you think they should work, try running 
rulehelper to
connect to the DB. This will give you clearer indication of your connect vs 
running through
an exchange.

Normally, the order is - Do it from the Oracle client. When you succeed there, 
usse those
values to access via rulehelper.  When you succeed with rulehelper, set the 
values you know
to work as the values for your exchanges.

-
Kelly Deaver
[EMAIL PROTECTED]


>  Original Message 
> Subject: EIE/Marimba connect error
> From: Drew Shuller <[EMAIL PROTECTED]>
> Date: Fri, September 07, 2007 3:05 pm
> To: arslist@ARSLIST.ORG
>
> We're having trouble getting our CMDB/Marimba integration to work. It
> seems that we're having problems reading the Marimba data. Hopefully
> somone on the ARS list has seen these errors (Oracle/solaris environment):
>
> We're seeing the following database connection errors:
> /apps/remedy/arsystem/eie/service/debug
>
>   more Pull_Keys_ars_inv_videocard.dbg
> [Thu Sep  6 22:17:38 2007] - Oracle.Initialize: Verifying configuration
> parameters
> [Thu Sep  6 22:17:38 2007] - Scheduled Only mode
> [Thu Sep  6 22:17:38 2007] - CONNECT inventory
> [Thu Sep  6 22:17:38 2007] - *** ERROR ***  ORA-12154: TNS:could not
> resolve the connect identifier specified
> [Thu Sep  6 22:17:38 2007] - VendorOpenConnection: unable to connect to
> database, rc = 550
> [Thu Sep  6 22:17:38 2007] - Error: Adapter.OpenConnection completed with
> errors issued
> [Thu Sep  6 22:17:38 2007] - StartDataHandlers: Vendor Data Handler failed
> to start.
> [Thu Sep  6 22:18:38 2007] - CONNECT inventory
> [Thu Sep  6 22:18:38 2007] - *** ERROR ***  ORA-12154: TNS:could not
> resolve the connect identifier specified
> [Thu Sep  6 22:18:38 2007] - VendorOpenConnection: unable to connect to
> database, rc = 550
> [Thu Sep  6 22:18:38 2007] - Error: Adapter.OpenConnection completed with
> errors issued
>
>
> Drew
> Tulsa
>
> ___
> 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: OT:Remedy Recruiters

[Roy Stark]

Hi Kelly,

We specialise in Remedy Recruitment.

Regards,

 

Roy Stark

Master Place Ltd

Tel: +44 (0)29 2019-5299

Mobile: +44 (0)773 420-6952

Web: http://www.master-place.co.uk

Any view or opinions expressed are those of the author and do not
necessarily reflect those of Master Place Ltd. This message contains
information which is confidential and is intended solely for the use of
the individual or entity to which this is addressed and is subject to
legal privilege. If you are not the intended recipient, you may not
peruse, use, disseminate, distribute or copy this message. If you have
received this message in error, please notify the sender immediately by
email, facsimile or telephone and return or destroy the original
message. All outgoing messages are scanned by Trend Anti Virus.

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Pierson, Shawn
Sent: 05 September 2007 20:46
To: arslist@ARSLIST.ORG
Subject: Re: OT:Remedy Recruiters

I think Kelly is looking for a recruiter that specifically finds Remedy
people, rather than one who does a little of everything and ends up
wasting time by floating bad resumes around.

Many times when you are trying to hire someone, you end up being given
dozens of resumes of people that know Remedy from a user standpoint,
e.g. they worked on a helpdesk somewhere, just because they keyword
"Remedy" appeared on their resume.

Shawn Pierson

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Drew Shuller
Sent: Wednesday, September 05, 2007 2:33 PM
To: arslist@ARSLIST.ORG
Subject: Re: OT:Remedy Recruiters


Kelly,

Put a "remedy" resume out on dice and monster and you'll have a lot of 
recruiters contact you. Make sure that your phone number is NOT on the 
resume. Your email address will work fine.

This isn't as good as using a reference from the arslist but it 
will net you a group of recruiters.

Drew

On Wed, 5 Sep 2007, Gatewood 
Kelly wrote:

> Does anyone know of any recruiters that specialize in Remedy 
> Consultants?
>
> Kelly Gatewood
>
>
> __
> _
> 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"

Private and confidential as detailed http://www.sug.com/disclaimers/default.htm#Mail";>here.  If you
cannot access hyperlink, please e-mail sender.


___
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: Error: Plug-In server is not responding

[Jarl Grøneng]

It was avaible in version 51.2 patch 1357
http://developer.bmc.com/jiveProd/entry!default.jspa?categoryID=528&externalID=22&fromSearchPage=true


Face the same problem with Java FitlerAPI, and the loopback fixed the
issue

--
Jarl


On 9/7/07, Papolu, Appajee <[EMAIL PROTECTED]> wrote:
>
> **
>
> Hi
>
>
>
> This is a "loopback" scenario – client issues a call to Server; AR System
> delegates call to a plug-in; which in turn calls back the Server again.
>
> You should configure your Server as noted (in the "Configuring … "
> document)
>
>
>
> Plugin-Loopback-RPC-Socket:
>
>
>
> The RPC socket number for the private server queue to which loopback
>
> plug-in API calls should be directed. The acceptable values are in the
>
> following ranges: 390621–390634, 390636–390669, and 390680–390694.
>
> Loopback plug-ins (like the Report Creator plug-in) that make calls back
>
> into AR System, will use this value to determine the queue to request. By
>
> default, the API calls that the plug-in makes are directed to a queue that
>
> corresponds with the call type. To be effective, the server must be
>
> configured to have the designated private queue for this setting.
>
>
>
>
>
> So, try some thing as below:
>
> -  Stop your AR Server
>
> -  Open your ar.cfg and add the following two lines (or, alter
> existing content to reflect some thing similar to below)
>
> Private-RPC-Socket: 390621   2   2
>
> Plugin-Loopback-RPC-Socket: 390621
>
> -  Restart your AR Server
>
> -  Try your test scenario. It should work better even when the
> plug-in issues calls back to the same AR Server.
>
>
>
> Regards
>
> Appajee
>
> PS: this feature is at least available in 7.0 & greater, I am not quite
> sure whether it was originally introduced in 6.3 or before. Give a quick
> try; if things don't work quite right, I can try digging around some more on
> this.
>  --
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> [EMAIL PROTECTED] *On Behalf Of *Gopala Krishna Peela
> *Sent:* Friday, September 07, 2007 8:54 AM
> *To:* arslist@ARSLIST.ORG
> *Subject:* Error: Plug-In server is not responding
>
>
>
> HI,
>
>
>
>  Please find below failure scenario where I have been facing issues
> with remedy-.net integration.
>
>
>
>
>
>  Failure Scenario
>
>
>
>1. Calling .NET Web Service from ARS Filter
>2. There are .NET API Calls in .NET Web Service for Getting Entry
>and Creating Entry (ARS filter and .NET Remedy API calls are belongs
>to same Server).
>
>
>
>  I am getting below error while execution of the above 2 steps even
> the API Calls executed successfully.
>
>
>
> ARERR [8939] The AR System Plug-In server is not responding.  Cannot
> connect to the system at this time.  Contact your AR System Administrator
> for assistance.
>
>
>
> How to avoid the above error from the application.
>
>
>
>
>
> Success Scenario
>
>
>
>1. Calling .NET Web Service from ARS Filter
>2. There are .NET API Calls in .NET Web Service for Getting Entry
>and Creating Entry (ARS filter belongs to one server and .NET Remedy
>API calls made on different Server).
>
>
>
> Please help me on solving this  issue.
>
>
>
>
>
>
>
>
>
>
>
> *Thanks &Regards,*
>
> *Gopala Krishna.Peela*
>
> _
>
> ' BTGS ESG;  Virtusa India (P) Ltd.,  India - 044-42002700- Extn 3253 *
> [EMAIL PROTECTED] <[EMAIL PROTECTED]>*
>
>
>
> -
> This message, including any attachments, contains confidential information
> intended for a specific individual and purpose, and is intended for the
> addressee only. Any unauthorized disclosure, use, dissemination, copying, or
> distribution of this message or any of its attachments or the information
> contained in this e-mail, or the taking of any action based on it, is
> strictly prohibited. If you are not the intended recipient, please notify
> the sender immediately by return e-mail and delete this message.
>  __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: JDBC ARDBC Plugin

[Tim Widowfield]

Jarl,

I agree that SOAP is the hottest integration technology when it comes to
sharing data between enterprises, but I think there are still cases where
in-house you might want the tighter integration and sheer convenience an ARDBC
JDBC plug-in could give you.

It's astonishing how many organizations are still, after all these years,
relying on nightly CSV dumps from external databases.  Where's that single,
enterprise-wide, federated, distributed database they promised us back in the
90's?  And where's my flying car???

--Tim


--- Jarl Grøneng <[EMAIL PROTECTED]> wrote:

> Hi,
> 
> For me it would be nice 5-10 years ago, but today almost all of the
> integration are done aplication - application(and also trough
> middleware), and not to the databases. SOAP and J2EE rules the
> integration at the moment...
> 
> --
> Jarl
> 
> On 9/8/07, Axton <[EMAIL PROTECTED]> wrote:
> > With the new java based plugin server introduced in 7.1, can I get a
> > show of hands in who would the interested in a jdbc driver implemented
> > as an ARDBC plugin?
> >
> > Seems that a generic implementation would allow access to any remote
> > db that provides a jdbc driver (Oracle, MSSQL, MySQL, LDAP, MS Access,
> > SQLLite, PostgreSQL, Domino, DB2, etc.).
> >
> > Seems the targets could be almost endless.
> >
> > Axton Grams
> >
> >
>
___
> > 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"

New Java Plugin Server Problems

[Axton]

Having trouble getting the new java based plugin server started under
armonitor.  armonitor.log shows the following:

Sun Sep  9 18:21:46 2007  Failure occurred during execl() (ARERR 33)
Sun Sep  9 18:21:46 2007 Bad address : ./java
Sun Sep  9 18:21:46 2007   (ARNOTE 0)
Sun Sep  9 18:21:46 2007 ARMonitor child process (pid:25366) started.
./java
Sun Sep  9 18:21:46 2007   (ARNOTE 0)
Sun Sep  9 18:21:46 2007 ARMonitor child process (pid:25366) died with 0.
./java

...

Sun Sep  9 18:21:46 2007  Failure occurred during execl() (ARERR 33)
Sun Sep  9 18:21:46 2007 Bad address : ./java
Sun Sep  9 18:21:46 2007   (ARNOTE 0)
Sun Sep  9 18:21:46 2007
Tried 4 restarts in 30 seconds. I give up at Sun Sep  9 18:21:46 2007


If I manually start the process with the command listed in armonitor,
all seems well; the process starts and continues running.

[EMAIL PROTECTED] /usr/ar/sundev71/bin]$  java -Xmx512m -classpath
/usr/ar/sundev71/pluginsvr:/usr/ar/sundev71/pluginsvr/arpluginsvr71.jar
com.bmc.arsys.plugin
vr.ARPluginServerMain -x sundev71 -i /usr/ar/sundev71 -m
AR System Plugin Server Version 7.1.00 Build 200708221849

This is on Solaris 10 sparc64x2 with a remote Oracle 10g instance
running on linux x86-32x2.

This only seems to be an issue when using libumem as the memory
management library (enabled by setting the following at the top of the
arsystem script):

UMEM_DEBUG=default
UMEM_LOGGING=transaction
LD_PRELOAD=libumem.so.1
export UMEM_DEBUG UMEM_LOGGING LD_PRELOAD

Without this, it starts just fine.

Some system information:

[EMAIL PROTECTED] /usr/ar/sundev71/bin]$ which java
/usr/bin/java
[EMAIL PROTECTED] /usr/ar/sundev71/bin]$ java -version
java version "1.5.0_12"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_12-b04)
Java HotSpot(TM) Server VM (build 1.5.0_12-b04, mixed mode)

[EMAIL PROTECTED] /usr/ar/sundev71/bin]$ /usr/java/bin/java -version
java version "1.5.0_12"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_12-b04)
Java HotSpot(TM) Server VM (build 1.5.0_12-b04, mixed mode)

[EMAIL PROTECTED] /usr/ar/sundev71/bin]$ uname -a
SunOS sundev01 5.10 Generic_118833-33 sun4u sparc SUNW,Sun-Fire-280R

# psrinfo -v
Status of virtual processor 0 as of: 09/09/2007 18:40:17
  on-line since 09/03/2007 03:06:09.
  The sparcv9 processor operates at 900 MHz,
and has a sparcv9 floating point processor.
Status of virtual processor 1 as of: 09/09/2007 18:40:17
  on-line since 09/03/2007 03:06:11.
  The sparcv9 processor operates at 900 MHz,
and has a sparcv9 floating point processor.

[EMAIL PROTECTED] /usr/ar/sundev71/bin]$ cat
/etc/arsystem/sundev71/armonitor.conf
Monitor-directory: /usr/ar/sundev71
SNMP-agent-enabled: F
#/usr/ar/sundev71/bin/arsnmpd --server sundev71 -f -c
/usr/ar/sundev71/conf/arsnmpd.conf udp:161
/usr/ar/sundev71/bin/arserverd -s sundev71 -i /usr/ar/sundev71 -l
/etc/arsystem/sundev71
/usr/ar/sundev71/bin/arsvcdsp -s sundev71 -d /usr/ar/sundev71
#/usr/ar/sundev71/bin/arservdsd -s sundev71 -i /usr/ar/sundev71
/usr/ar/sundev71/bin/arplugin -s sundev71 -i /usr/ar/sundev71
java -Xmx512m -classpath
/usr/ar/sundev71/pluginsvr:/usr/ar/sundev71/pluginsvr/arpluginsvr71.jar
com.bmc.arsys.pluginsvr.ARPluginServerMain -x sundev71 -i /um
/usr/ar/sundev71/apps/aremail/emaild.sh start

[EMAIL PROTECTED] /usr/ar/sundev71/bin]$ file /usr/ar/sundev71/bin/armonitor
/usr/ar/sundev71/bin/armonitor: ELF 32-bit MSB executable SPARC
Version 1, dynamically linked, stripped
[EMAIL PROTECTED] /usr/ar/sundev71/bin]$ file /usr/ar/sundev71/pluginsvr
/usr/ar/sundev71/pluginsvr: directory
[EMAIL PROTECTED] /usr/ar/sundev71/bin]$ file
/usr/ar/sundev71/pluginsvr/libarpluginjni71.so
/usr/ar/sundev71/pluginsvr/libarpluginjni71.so: ELF 32-bit MSB dynamic
lib SPARC Version 1, dynamically linked, not stripped
[EMAIL PROTECTED] /usr/ar/sundev71/bin]$ file
/usr/ar/sundev71/pluginsvr/libarjni71.so
/usr/ar/sundev71/pluginsvr/libarjni71.so:   ELF 32-bit MSB dynamic
lib SPARC Version 1, dynamically linked, not stripped


The question I have, is how do I start all the processes under
armonitor with libumem, with the exception of the java based plugin
server, until these issues are resolved?

Axton Grams

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: Error: Plug-In server is not responding

[Gopala Krishna Peela]

Hi Jarl,



I tried even loopback.. But still facing the same issue.



   I have configured below lines into ar.cfg file

   Private-RPC-Socket:  390693   4   4

   Plugin-Loopback-RPC-Socket: 390693



   Environment details: Windows XP, remedy 6.3 patch 18. Mid Tier 6.3, .Net API 
7.0





Thanks &Regards,

Gopala Krishna.Peela

_

' BTGS ESG;  Virtusa India (P) Ltd.,  India - 044-42002700- Extn 3253 [EMAIL 
PROTECTED] 



From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Jarl Grøneng
Sent: Monday, September 10, 2007 12:46 AM
To: arslist@ARSLIST.ORG
Subject: Re: Error: Plug-In server is not responding



**
It was avaible in version 51.2 patch 1357
http://developer.bmc.com/jiveProd/entry!default.jspa?categoryID=528&externalID=22&fromSearchPage=true


Face the same problem with Java FitlerAPI, and the loopback fixed the issue

--
Jarl



On 9/7/07, Papolu, Appajee < [EMAIL PROTECTED]  > 
wrote:

**

Hi



This is a "loopback" scenario - client issues a call to Server; AR System 
delegates call to a plug-in; which in turn calls back the Server again.

You should configure your Server as noted (in the "Configuring ... " document)



Plugin-Loopback-RPC-Socket :



The RPC socket number for the private server queue to which loopback

plug-in API calls should be directed. The acceptable values are in the

following ranges: 390621-390634, 390636-390669, and 390680-390694.

Loopback plug-ins (like the Report Creator plug-in) that make calls back

into AR System, will use this value to determine the queue to request. By

default, the API calls that the plug-in makes are directed to a queue that

corresponds with the call type. To be effective, the server must be

configured to have the designated private queue for this setting.





So, try some thing as below:

-  Stop your AR Server

-  Open your ar.cfg and add the following two lines (or, alter existing 
content to reflect some thing similar to below)

Private-RPC-Socket: 390621   2   2

Plugin-Loopback-RPC-Socket : 390621

-  Restart your AR Server

-  Try your test scenario. It should work better even when the plug-in 
issues calls back to the same AR Server.



Regards

Appajee

PS: this feature is at least available in 7.0 & greater, I am not quite sure 
whether it was originally introduced in 6.3 or before. Give a quick try; if 
things don't work quite right, I can try digging around some more on this.



HI,



 Please find below failure scenario where I have been facing issues with 
remedy-.net integration.

  Failure Scenario



1.  Calling .NET Web Service from ARS Filter
2.  There are .NET API Calls in .NET Web Service for Getting Entry and 
Creating Entry (ARS filter and .NET Remedy API calls are belongs to same 
Server).



 I am getting below error while execution of the above 2 steps even the API 
Calls executed successfully.



ARERR [8939] The AR System Plug-In server is not responding.  Cannot connect to 
the system at this time.  Contact your AR System Administrator for assistance.

 How to avoid the above error from the application. 

Success Scenario



1.  Calling .NET Web Service from ARS Filter
2.  There are .NET API Calls in .NET Web Service for Getting Entry and 
Creating Entry (ARS filter belongs to one server and .NET Remedy API calls made 
on different Server).



Please help me on solving this  issue.











Thanks &Regards,

Gopala Krishna.Peela

_

' BTGS ESG;  Virtusa India (P) Ltd.,  India - 044-42002700- Extn 3253 
gopalakrishnap @virtusa.com  



-
This message, including any attachments, contains confidential information 
intended for a specific individual and purpose, and is intended for the 
addressee only. Any unauthorized disclosure, use, dissemination, copying, or 
distribution of this message or any of its attachments or the information 
contained in this e-mail, or the taking of any action based on it, is strictly 
prohibited. If you are not the intended recipient, please notify the sender 
immediately by return e-mail and delete this message.

__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___



-
This message, including any attachments, contains confidential information 
intended for a specific individual and purpose, and is intended for the 
addressee only. Any unauthorized discl

Re: JDBC ARDBC Plugin

[Carey Matthew Black]

Axton,

And after a bit of thought I think an ARDBC that reads Server side
menu files would be a good tool to have too.

I think one might be able to:
  Read data from the file (Set Field actions)
  add/remove records from the file
 ( or maybe re-build the whole file from an ARS form's data)


The main advantage I see to this would be to be able to allow multiple
(more than 5) levels of grouping for the menu objects that is still
based on ARS data that can be controlled by work flow from creation to
deletion. It would also allow for a "path forward" for the older
server file menus as a whole.

And if the ARS data to File Menu part of this is general enough then,
then even the JDBC plugin could be used as a source of data for an ARS
menu. :)

But maybe it is just me stuck with server side menus that would find
such a features set to be helpful?

-- 
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 9/8/07, Carey Matthew Black <[EMAIL PROTECTED]> wrote:
> Axton,
>
> I think it is a great idea. And the sample ARDBC Java plugin looks
> fairly good at first blush. :)
>
> From 
> (...\Api\javaplugins\samplesrc.jar!\java\com\bmc\arsys\plugin\sample\ARDBCSample.java)
>
>
> /**
>  * A sample ARDBC plugin implementation as an example of how to use the sdk.
>  *
>  * This plugin extends ARDBCPlugin object. Alternatively, one could
> implement the interface ARDBCPluggable.
>  *
>  * This implementation fetches the jdbc connection information as
> config items using the plugin context.
>  * Uses that information to establish a jdbc connection to a SQL
> Server database. Provides a way of creating
>  * vendor forms using tables in the underlying database.
>  */
>
>
> But I have not tested it out yet either.
>
> And there is also AREASample.java, and FilterAPISample.java too.
>
> --
> 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 9/8/07, Axton <[EMAIL PROTECTED]> wrote:
> > With the new java based plugin server introduced in 7.1, can I get a
> > show of hands in who would the interested in a jdbc driver implemented
> > as an ARDBC plugin?
> >
> > Seems that a generic implementation would allow access to any remote
> > db that provides a jdbc driver (Oracle, MSSQL, MySQL, LDAP, MS Access,
> > SQLLite, PostgreSQL, Domino, DB2, etc.).
> >
> > Seems the targets could be almost endless.
> >
> > Axton Grams

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: New Java Plugin Server Problems

[Axton]

If I modify the java plugin server start script with the following
changes, then place a reference to that script in armonitor.conf, it
runs without a hitch.

[EMAIL PROTECTED] /usr/ar/sundev71/pluginsvr]$ diff -ub
pluginsvrstartup.sh.bak pluginsvrstartup.sh
--- pluginsvrstartup.sh.bak Sun Sep  9 20:36:18 2007
+++ pluginsvrstartup.sh Sun Sep  9 20:33:35 2007
@@ -1,9 +1,16 @@
-#! /bin/sh
+#!/bin/sh

-export LD_LIBRARY_PATH=.:../bin
-export SHLIB_PATH=.:../bin
-export LIBPATH=.:../bin
+UMEM_DEBUG=default
+UMEM_LOGGING=transaction
+LD_PRELOAD=libumem.so.1
+export UMEM_DEBUG UMEM_LOGGING LD_PRELOAD

-export 
CLASSPATH=.:arapi71.jar:arrpc71.jar:arcmn71.jar:arpluginsvr71.jar:oncrpc.jar:portmap.jar:log4j-1.2.14.jar:spring.jar:commons-logging-1.1.jar:commons-r
+LD_LIBRARY_PATH=.:../bin
+SHLIB_PATH=.:../bin
+LIBPATH=.:../bin

+CLASSPATH=.:arapi71.jar:arrpc71.jar:arcmn71.jar:arpluginsvr71.jar:oncrpc.jar:portmap.jar:log4j-1.2.14.jar:spring.jar:commons-logging-1.1.jar:commons-configur
+
+export LD_LIBRARY_PATH SHLIB_PATH LIBPATH CLASSPATH
+
 $JAVA_HOME/bin/java -Xmx512m
com.bmc.arsys.pluginsvr.ARPluginServerMain -x localhost -i ./..

[EMAIL PROTECTED] /etc/arsystem/sundev71]$ diff -ub armonitor.conf.orig
armonitor.conf
--- armonitor.conf.orig Sun Sep  9 20:37:04 2007
+++ armonitor.conf  Sun Sep  9 20:34:23 2007
@@ -5,5 +5,6 @@
 /usr/ar/sundev71/bin/arsvcdsp -s sundev71 -d /usr/ar/sundev71
 #/usr/ar/sundev71/bin/arservdsd -s sundev71 -i /usr/ar/sundev71
 /usr/ar/sundev71/bin/arplugin -s sundev71 -i /usr/ar/sundev71
-java -Xmx512m -classpath
/usr/ar/sundev71/pluginsvr:/usr/ar/sundev71/pluginsvr/arpluginsvr71.jar
com.bmc.arsys.pluginsvr.ARPluginServerMain -x sundev71 -i /m
+#java -Xmx512m -classpath
/usr/ar/sundev71/pluginsvr:/usr/ar/sundev71/pluginsvr/arpluginsvr71.jar
com.bmc.arsys.pluginsvr.ARPluginServerMain -x sundev71 -i m
+/usr/ar/sundev71/pluginsvr/pluginsvrstartup.sh
 /usr/ar/sundev71/apps/aremail/emaild.sh start


Odd.

Axton Grams


On 9/9/07, Axton <[EMAIL PROTECTED]> wrote:
> Having trouble getting the new java based plugin server started under
> armonitor.  armonitor.log shows the following:
>
> Sun Sep  9 18:21:46 2007  Failure occurred during execl() (ARERR 33)
> Sun Sep  9 18:21:46 2007 Bad address : ./java
> Sun Sep  9 18:21:46 2007   (ARNOTE 0)
> Sun Sep  9 18:21:46 2007 ARMonitor child process (pid:25366) started.
> ./java
> Sun Sep  9 18:21:46 2007   (ARNOTE 0)
> Sun Sep  9 18:21:46 2007 ARMonitor child process (pid:25366) died with 0.
> ./java
>
> ...
>
> Sun Sep  9 18:21:46 2007  Failure occurred during execl() (ARERR 33)
> Sun Sep  9 18:21:46 2007 Bad address : ./java
> Sun Sep  9 18:21:46 2007   (ARNOTE 0)
> Sun Sep  9 18:21:46 2007
> Tried 4 restarts in 30 seconds. I give up at Sun Sep  9 18:21:46 2007
>
>
> If I manually start the process with the command listed in armonitor,
> all seems well; the process starts and continues running.
>
> [EMAIL PROTECTED] /usr/ar/sundev71/bin]$  java -Xmx512m -classpath
> /usr/ar/sundev71/pluginsvr:/usr/ar/sundev71/pluginsvr/arpluginsvr71.jar
> com.bmc.arsys.plugin
> vr.ARPluginServerMain -x sundev71 -i /usr/ar/sundev71 -m
> AR System Plugin Server Version 7.1.00 Build 200708221849
>
> This is on Solaris 10 sparc64x2 with a remote Oracle 10g instance
> running on linux x86-32x2.
>
> This only seems to be an issue when using libumem as the memory
> management library (enabled by setting the following at the top of the
> arsystem script):
>
> UMEM_DEBUG=default
> UMEM_LOGGING=transaction
> LD_PRELOAD=libumem.so.1
> export UMEM_DEBUG UMEM_LOGGING LD_PRELOAD
>
> Without this, it starts just fine.
>
> Some system information:
>
> [EMAIL PROTECTED] /usr/ar/sundev71/bin]$ which java
> /usr/bin/java
> [EMAIL PROTECTED] /usr/ar/sundev71/bin]$ java -version
> java version "1.5.0_12"
> Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_12-b04)
> Java HotSpot(TM) Server VM (build 1.5.0_12-b04, mixed mode)
>
> [EMAIL PROTECTED] /usr/ar/sundev71/bin]$ /usr/java/bin/java -version
> java version "1.5.0_12"
> Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_12-b04)
> Java HotSpot(TM) Server VM (build 1.5.0_12-b04, mixed mode)
>
> [EMAIL PROTECTED] /usr/ar/sundev71/bin]$ uname -a
> SunOS sundev01 5.10 Generic_118833-33 sun4u sparc SUNW,Sun-Fire-280R
>
> # psrinfo -v
> Status of virtual processor 0 as of: 09/09/2007 18:40:17
>   on-line since 09/03/2007 03:06:09.
>   The sparcv9 processor operates at 900 MHz,
> and has a sparcv9 floating point processor.
> Status of virtual processor 1 as of: 09/09/2007 18:40:17
>   on-line since 09/03/2007 03:06:11.
>   The sparcv9 processor operates at 900 MHz,
> and has a sparcv9 floating point processor.
>
> [EMAIL PROTECTED] /usr/ar/sundev71/bin]$ cat
> /etc/arsystem/sundev71/armonitor.conf
> Monitor-directory: /usr/ar/sundev71
> SNMP-agent-enabled: F
> #/usr/ar/sundev71/bin/arsnmpd --server sundev71 -f -c
> /usr/ar/sundev71/conf/arsnmpd.conf udp:161
> /usr/ar/sundev71/bin/arse

Re: JDBC ARDBC Plugin

[Axton]

The nice thing about the way JDBC was implemented is that there is a
common abstraction layer regardless of the source.  The thing I am
thinking about writing would implement the common interfaces and
methods, regardless of the jdbc driver, thus allowing the use of any
data source where a jdbc driver was available.  Whether this included
a fs based jdbc driver, a mysql driver, an ldap driver, or whatever it
happens to be, on component would be capable of serving all those
types of requests, so long as the driver was available in the
classpath.

Axton Grams

On 9/9/07, Carey Matthew Black <[EMAIL PROTECTED]> wrote:
> Axton,
>
> And after a bit of thought I think an ARDBC that reads Server side
> menu files would be a good tool to have too.
>
> I think one might be able to:
>   Read data from the file (Set Field actions)
>   add/remove records from the file
>  ( or maybe re-build the whole file from an ARS form's data)
>
>
> The main advantage I see to this would be to be able to allow multiple
> (more than 5) levels of grouping for the menu objects that is still
> based on ARS data that can be controlled by work flow from creation to
> deletion. It would also allow for a "path forward" for the older
> server file menus as a whole.
>
> And if the ARS data to File Menu part of this is general enough then,
> then even the JDBC plugin could be used as a source of data for an ARS
> menu. :)
>
> But maybe it is just me stuck with server side menus that would find
> such a features set to be helpful?
>
> --
> 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 9/8/07, Carey Matthew Black <[EMAIL PROTECTED]> wrote:
> > Axton,
> >
> > I think it is a great idea. And the sample ARDBC Java plugin looks
> > fairly good at first blush. :)
> >
> > From 
> > (...\Api\javaplugins\samplesrc.jar!\java\com\bmc\arsys\plugin\sample\ARDBCSample.java)
> >
> >
> > /**
> >  * A sample ARDBC plugin implementation as an example of how to use the sdk.
> >  *
> >  * This plugin extends ARDBCPlugin object. Alternatively, one could
> > implement the interface ARDBCPluggable.
> >  *
> >  * This implementation fetches the jdbc connection information as
> > config items using the plugin context.
> >  * Uses that information to establish a jdbc connection to a SQL
> > Server database. Provides a way of creating
> >  * vendor forms using tables in the underlying database.
> >  */
> >
> >
> > But I have not tested it out yet either.
> >
> > And there is also AREASample.java, and FilterAPISample.java too.
> >
> > --
> > 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 9/8/07, Axton <[EMAIL PROTECTED]> wrote:
> > > With the new java based plugin server introduced in 7.1, can I get a
> > > show of hands in who would the interested in a jdbc driver implemented
> > > as an ARDBC plugin?
> > >
> > > Seems that a generic implementation would allow access to any remote
> > > db that provides a jdbc driver (Oracle, MSSQL, MySQL, LDAP, MS Access,
> > > SQLLite, PostgreSQL, Domino, DB2, etc.).
> > >
> > > Seems the targets could be almost endless.
> > >
> > > Axton Grams
>
> ___
> 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"

Notification Issue

[Oza, Veeral]

Hi All,
 
This is what is happening:-
1) User creates a new Incident Ticket and it is assigned to XYZ person
2) XYZ person opens the ticket and uses the Process Flow Status bar to go to 
directly to Incident closure, skipping the Resolution and Recovery phase.
3) A dialog form pops up (which is another view of HPD:HelpDesk) and he enters 
Resolution text.
4) A notification is sent to the requester about the resolution details.
 
Now, We have Customised the Notification with the Tag 
"SRM:SRV:IndividualSurveyMessage" and included Resolution field in the 
notification body.
 
Now beacuse the user is skipping Resolution and Recovery phase, the system is 
unable to capture the value of Resolution field.
 
Any ideas will be much appreciated.
 
Environment:
ITSM 7 Patch 2,
Oracle on Solaris.
 
Regards,
Veeral Oza,
Application Developer,
Column Technologies,
Cell: 224-587-0765
Desk: 847-632-3327

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: Notification Issue

[Joe D'Souza]

If I remember right, isn't that a display only field?

Joe
  -Original Message-
  From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of Oza, Veeral
  Sent: Sunday, September 09, 2007 8:58 PM
  To: arslist@ARSLIST.ORG
  Subject: Notification Issue


  **
  Hi All,

  This is what is happening:-
  1) User creates a new Incident Ticket and it is assigned to XYZ person
  2) XYZ person opens the ticket and uses the Process Flow Status bar to go
to directly to Incident closure, skipping the Resolution and Recovery phase.
  3) A dialog form pops up (which is another view of HPD:HelpDesk) and he
enters Resolution text.
  4) A notification is sent to the requester about the resolution details.

  Now, We have Customised the Notification with the Tag
"SRM:SRV:IndividualSurveyMessage" and included Resolution field in the
notification body.

  Now beacuse the user is skipping Resolution and Recovery phase, the system
is unable to capture the value of Resolution field.

  Any ideas will be much appreciated.

  Environment:
  ITSM 7 Patch 2,
  Oracle on Solaris.

  Regards,
  Veeral Oza,
  Application Developer,
  Column Technologies,
  Cell: 224-587-0765
  Desk: 847-632-3327
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.485 / Virus Database: 269.13.12/997 - Release Date: 9/9/2007
10:17 AM

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: Question: Finding Text

[Joe D'Souza]

Sure.. let me know how it goes or if you need some more help on that..

Joe
  -Original Message-
  From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of Tyrone Dee
  Sent: Saturday, September 08, 2007 1:34 PM
  To: arslist@ARSLIST.ORG
  Subject: Re: Question: Finding Text


  **
  Thanks – I will give it a try.



  T.





--

  From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza
  Sent: Saturday, September 08, 2007 12:57 PM
  To: arslist@ARSLIST.ORG
  Subject: Re: Question: Finding Text



  Tyron,



  You can use the function STRSTR($FieldToSearchYourString$, "Street
Address:") + LEN("Street Address:") to return an integer value of the
position where "Street Address:" ends in your string
$FieldToSearchYourString$. Then do what you want to do with that..



  Let me know if that helped - or if you require any further help using a
combination of these functions..



  Cheers



  Joe



  -Original Message-

  From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of Tyrone Dee

  Sent: Friday, September 07, 2007 11:30 PM

  To: arslist@ARSLIST.ORG

  Subject: Re: Question: Finding Text





  There will be the words "Street Address:" first and then the address to
follow - "Street Address" will always be the same, but what comes after it
will be different.  Can I some how grab that and place it in a temporary
field?



  THANKS!



  T.





  

  From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza

  Sent: Friday, September 07, 2007 7:32 PM

  To: arslist@ARSLIST.ORG

  Subject: Re: Question: Finding Text



  On the basis of what will you identify the text then.. If you have a way
to identify the text yes there are ways with the available functions in
Remedy to do what you want.



  Joe



  -Original Message-

  From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of Tyrone Dee

  Sent: Friday, September 07, 2007 7:14 PM

  To: arslist@ARSLIST.ORG

  Subject: Question: Finding Text





  I was wondering how I would take a field with (zero character length) and
through workflow find a specific text (i.e. 123 Jones Avenue) and set it to
a temporary field.  The text I am looking for will not necessarily be in the
same place all the time and may not be the same length all the time.



  Is this possible?



  Any help is appreciated.



  Thanks.



  T.

No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.485 / Virus Database: 269.13.12/997 - Release Date: 9/9/2007
10:17 AM


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: Notification Issue

[Oza, Veeral]

Nope, its a char field.



From: Action Request System discussion list(ARSList) on behalf of Joe D'Souza
Sent: Sun 9/9/2007 9:01 PM
To: arslist@ARSLIST.ORG
Subject: Re: Notification Issue


** 
If I remember right, isn't that a display only field?
 
Joe

-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL 
PROTECTED] Behalf Of Oza, Veeral
Sent: Sunday, September 09, 2007 8:58 PM
To: arslist@ARSLIST.ORG
Subject: Notification Issue


** 
Hi All,
 
This is what is happening:-
1) User creates a new Incident Ticket and it is assigned to XYZ person
2) XYZ person opens the ticket and uses the Process Flow Status bar to 
go to directly to Incident closure, skipping the Resolution and Recovery phase.
3) A dialog form pops up (which is another view of HPD:HelpDesk) and he 
enters Resolution text.
4) A notification is sent to the requester about the resolution details.
 
Now, We have Customised the Notification with the Tag 
"SRM:SRV:IndividualSurveyMessage" and included Resolution field in the 
notification body.
 
Now beacuse the user is skipping Resolution and Recovery phase, the 
system is unable to capture the value of Resolution field.
 
Any ideas will be much appreciated.
 
Environment:
ITSM 7 Patch 2,
Oracle on Solaris.
 
Regards,
Veeral Oza,
Application Developer,
Column Technologies,
Cell: 224-587-0765
Desk: 847-632-3327

__20060125___This posting was submitted with HTML in it___ 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: JDBC ARDBC Plugin

[Jarl Grøneng]

Tim,

Yes, we all know :-) Still running several small batch jobs; export
from LDAP, write to file, ftp file to another server, import the file.
Beautiful :-)

--
Jarl

On 9/10/07, Tim Widowfield <[EMAIL PROTECTED]> wrote:
> Jarl,
>
> I agree that SOAP is the hottest integration technology when it comes to
> sharing data between enterprises, but I think there are still cases where
> in-house you might want the tighter integration and sheer convenience an ARDBC
> JDBC plug-in could give you.
>
> It's astonishing how many organizations are still, after all these years,
> relying on nightly CSV dumps from external databases.  Where's that single,
> enterprise-wide, federated, distributed database they promised us back in the
> 90's?  And where's my flying car???
>
> --Tim
>
>
> --- Jarl Grøneng <[EMAIL PROTECTED]> wrote:
>
> > Hi,
> >
> > For me it would be nice 5-10 years ago, but today almost all of the
> > integration are done aplication - application(and also trough
> > middleware), and not to the databases. SOAP and J2EE rules the
> > integration at the moment...
> >
> > --
> > Jarl
> >
> > On 9/8/07, Axton <[EMAIL PROTECTED]> wrote:
> > > With the new java based plugin server introduced in 7.1, can I get a
> > > show of hands in who would the interested in a jdbc driver implemented
> > > as an ARDBC plugin?
> > >
> > > Seems that a generic implementation would allow access to any remote
> > > db that provides a jdbc driver (Oracle, MSSQL, MySQL, LDAP, MS Access,
> > > SQLLite, PostgreSQL, Domino, DB2, etc.).
> > >
> > > Seems the targets could be almost endless.
> > >
> > > Axton Grams
> > >
> > >
> >
> ___
> > > 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"

Re: EIE/Marimba connect error

[Anthony K R]

Drew,

I faced similar error but while connecting to SQL server from windows
environment. I had to run the rulehelper.exe from command prompt to pass
all the arguments for arserver, vendor and also with -t and restart the
EIE service.


Regards,
Anthony

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kelly Deaver
Sent: Sunday, September 09, 2007 6:44 PM
To: arslist@ARSLIST.ORG
Subject: Re: EIE/Marimba connect error

Drew,

You have a wrong value in your Oracle settings somewhere. That is what
error 550 means.
Make sure, for Oracle, that everything is listed uppercase. If that
doesn't do it,
try connecting, from the AR Server, with the oracle client. This is what
EIE is doing,
if you can't connect directly with the values, neither can EIE.

Once you have the values set where you think they should work, try
running rulehelper to
connect to the DB. This will give you clearer indication of your connect
vs running through
an exchange.

Normally, the order is - Do it from the Oracle client. When you succeed
there, usse those
values to access via rulehelper.  When you succeed with rulehelper, set
the values you know
to work as the values for your exchanges.

-
Kelly Deaver
[EMAIL PROTECTED]


>  Original Message 
> Subject: EIE/Marimba connect error
> From: Drew Shuller <[EMAIL PROTECTED]>
> Date: Fri, September 07, 2007 3:05 pm
> To: arslist@ARSLIST.ORG
>
> We're having trouble getting our CMDB/Marimba integration to work. It
> seems that we're having problems reading the Marimba data. Hopefully
> somone on the ARS list has seen these errors (Oracle/solaris
environment):
>
> We're seeing the following database connection errors:
> /apps/remedy/arsystem/eie/service/debug
>
>   more Pull_Keys_ars_inv_videocard.dbg
> [Thu Sep  6 22:17:38 2007] - Oracle.Initialize: Verifying
configuration
> parameters
> [Thu Sep  6 22:17:38 2007] - Scheduled Only mode
> [Thu Sep  6 22:17:38 2007] - CONNECT inventory
> [Thu Sep  6 22:17:38 2007] - *** ERROR ***  ORA-12154: TNS:could not
> resolve the connect identifier specified
> [Thu Sep  6 22:17:38 2007] - VendorOpenConnection: unable to connect
to
> database, rc = 550
> [Thu Sep  6 22:17:38 2007] - Error: Adapter.OpenConnection completed
with
> errors issued
> [Thu Sep  6 22:17:38 2007] - StartDataHandlers: Vendor Data Handler
failed
> to start.
> [Thu Sep  6 22:18:38 2007] - CONNECT inventory
> [Thu Sep  6 22:18:38 2007] - *** ERROR ***  ORA-12154: TNS:could not
> resolve the connect identifier specified
> [Thu Sep  6 22:18:38 2007] - VendorOpenConnection: unable to connect
to
> database, rc = 550
> [Thu Sep  6 22:18:38 2007] - Error: Adapter.OpenConnection completed
with
> errors issued
>
>
> Drew
> Tulsa
>
>

___
> 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"

Re: Notification Issue

[Rami S Ayoub]

**

Hi Veeral, 

 

Patch 5 will resolve your issue I face the same problem in that time I have 
create filter to notify the requester when the case is resolved and there 
filter run when Status updated change the qualification to run only when the 
status In progress ...etc remove the resolved which resolved in the filter = 
completed because this update from SRM form.

 

Also if you want to add status reason it will become like filed no data you 
should do the same for the pending.

 

Hope this will help

 

Regards,

Rami

 



From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Joe D'Souza
Sent: Monday, September 10, 2007 5:01 AM
To: arslist@ARSLIST.ORG
Subject: Re: Notification Issue

 

If I remember right, isn't that a display only field?

 

Joe

-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
Behalf Of Oza, Veeral
Sent: Sunday, September 09, 2007 8:58 PM
To: arslist@ARSLIST.ORG
Subject: Notification Issue

** 

Hi All,

 

This is what is happening:-

1) User creates a new Incident Ticket and it is assigned to XYZ person

2) XYZ person opens the ticket and uses the Process Flow Status bar to go to 
directly to Incident closure, skipping the Resolution and Recovery phase.

3) A dialog form pops up (which is another view of HPD:HelpDesk) and he enters 
Resolution text.

4) A notification is sent to the requester about the resolution details.

 

Now, We have Customised the Notification with the Tag 
"SRM:SRV:IndividualSurveyMessage" and included Resolution field in the 
notification body.

 

Now beacuse the user is skipping Resolution and Recovery phase, the system is 
unable to capture the value of Resolution field.

 

Any ideas will be much appreciated.

 

Environment:

ITSM 7 Patch 2,

Oracle on Solaris.

 

Regards,

Veeral Oza,

Application Developer,

Column Technologies,

Cell: 224-587-0765

Desk: 847-632-3327


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"