SV: Java ARDBC plugin failing with multiple instances "No suitable driver found for "

[Jonas Stumph Stevnsvig]

Hi Jarl and Sean,

I tried the  approach, and it didn't resolve anything. I still get 
this error for the second plugin:

Error establishing jdbc connection to the datasource jdbc:db2:CD99  No suitable 
driver found for jdbc:db2:CD99 


I have yet to try the dual java pluginserver approach, just have another 
assignment blocking the pipe at the moment - I hope I can set it up tonight.






with regards,



Jonas Stumph Stevnsvig
Remedy Developer
BEC Competence Centre
Phone  (+45) 46 38 20 08
Mobile  (+45) 61 56 20 08
jonas.stumph.stevns...@bec.dk
becrem...@bec.dk


-Oprindelig meddelelse-
Fra: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] På vegne af Jarl Grøneng
Sendt: 18. august 2009 19:51
Til: arslist@ARSLIST.ORG
Emne: Re: Java ARDBC plugin failing with multiple instances "No suitable driver 
found for "

Plugingroups are done this way:





  CD99
  ARDBC
  JAVA
  C:/Program Files/BMC
Software/ARSystem/Arserver/api/javaplugins/BECplugins/arapi.jar
  com.bmc.arsys.plugins.jdbc.JdbcDataSource
  C:/Programmer/IBM/SQLLIB/java/db2java.zip
  
jdbc:db2:CD99
COM.ibm.db2.jdbc.app.DB2Driver
someUser
somePassword
T
CD99
  


  OD99
  ARDBC
  JAVA
  C:/Program Files/BMC
Software/ARSystem/Arserver/api/javaplugins/BECplugins/arapi.jar
  com.bmc.arsys.plugins.jdbc.JdbcDataSource
  C:/Programmer/IBM/SQLLIB/java/db2java.zip
  
jdbc:db2:OD99
COM.ibm.db2.jdbc.app.DB2Driver
someOtherUser
someOtherpassword
TD
OD99
  



JARL.SUPER.PLUGIN
ARDBC
JAVA
jarl.jar
com.bmc.jarl
in the cloud
in the cloud


---

2009/8/18 Jonas Stumph Stevnsvig :
> **
> Hi - I'm still messing with this problem.
> I just stumbled across this:
>
>
>  * Note: If you are using the same class as two different plugins 
> identified by two
>  * different ids,  then these will not be able to share any 
> resources as they are
>  * loaded by two different classloaders, unless they were grouped 
> in a plugingroup
>  * in the plugin configuration, in which case they will be able to 
> share resources.
>  in this file:
> http://svn.arswiki.org/arapi/releases/win71/src/javaplugins/samplesrc/
> java/com/bmc/arsys/plugin/sample/ARDBCSample.java
>
>
>
> has anyone got an idea how to group the plugins in pluginsvr_config.xml??
>
>
>
> 
>
> 
>
> ...
>
> 
>
> 
>
> ...
>
> 
>
> 
>
> does not load anything at all - nor does it give an error... I wish 
> there was a DTD i could refer to.
>
> Med venlig hilsen
>
> Jonas Stumph Stevnsvig
> Remedy Udvikler
> BEC Kompetence Centret
> Telefon (+45) 46 38 20 08
> Mobil   (+45) 61 56 20 08
> jonas.stumph.stevns...@bec.dk
>
> Til remedy spørgsmål: becrem...@bec.dk
>
> BEC - det fælles it-hus, der gør forskellen for finansielle 
> virksomheder
>
>
> 
> Fra: Action Request System discussion list(ARSList) 
> [mailto:arsl...@arslist.org] På vegne af Jonas Stumph Stevnsvig
> Sendt: 14. august 2009 14:32
> Til: arslist@ARSLIST.ORG
> Emne: Java ARDBC plugin failing with multiple instances "No suitable 
> driver found for "
>
> **
> Hi listers,
>
> I really hope one of you has a solution for me here.
>
> We have developed an  ARDBC driver for connection to a DB2 database. 
> in the production environment we need to connect to two different 
> databases, so I have configured two  in pluginsvr_config.xml:
>
>
>
>     
>   CD99
>   ARDBC
>   JAVA
>   C:/Program Files/BMC
> Software/ARSystem/Arserver/api/javaplugins/BECplugins/arapi.jar ame>
>   com.bmc.arsys.plugins.jdbc.JdbcDataSource
>    type="location">C:/Programmer/IBM/SQLLIB/java/db2java.zip >
>   
>     jdbc:db2:CD99
>     COM.ibm.db2.jdbc.app.DB2Driver
>     someUser
>     somePassword
>     T
>     CD99
>
>   
>     
>
>     
>   OD99
>   ARDBC
>   JAVA
>   C:/Program Files/BMC
> Software/ARSystem/Arserver/api/javaplugins/BECplugins/arapi.jar ame>
>   com.bmc.arsys.plugins.jdbc.JdbcDataSource
>    type="location">C:/Programmer/IBM/SQLLIB/java/db2java.zip >
>   
>     jdbc:db2:OD99
>     COM.ibm.db2.jdbc.app.DB2Driver
>     someOtherUser
>     someOtherpassword
>     TD
>     OD99
>   
>     
>
> If I enable one of them, I can connect with no problem whatsoever, 
> however; as soon as I enable the second driver, It gives me the following 
> error:
>
>
>
> 2009-08-14 14:02:10,676 INFO  [pool-2-thread-1] 
> com.bmc.arsys.pluginsvr.plugins.g (?:?) - Attempting to Create an 
> instance of the plugin CD99
> 2009-08-14 14:02:10,676 INFO  [pool-2-thread-1] 
> com.bmc.arsys.pluginsvr.plugins.ARPluginContext (?:?) - 
> initialize()
> 2009-08-14

Re: ARERR 552 - Database link is not open

[Jiri Pospisil]

++
Please Read The Disclaimer At The Bottom Of This Email
++

Hi,

It has been a while, but I remember similar issue where the DB link connection 
closed after a certain period of inactivity. When a query ran after the 
link/session was closed, we were getting similar error message.
The way around it was to run a dummy query just before performing the real 
query.

Hope this will be of some help.

Jiri Pospisil
LCH.Clearnet



From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of William Rentfrow
Sent: 18 August 2009 19:32
To: arslist@ARSLIST.ORG
Subject: ARERR 552 - Database link is not open

**
We are doing an upgrade - as part of that we're porting a stored procedure to 
the new db instance.

The DBA can login as ARAdmin and execute this stored procedure as expected.  
However, when we do the exact same command from workflow (filter Run Process) 
we get this along with the ARERR 552:

*** ERROR ***  ORA-02081: database link is not open
ORA-06512: at "ARADMIN.V_EMP_NEW", line 50
ORA-02081: database link is not open
ORA-06512: at line 1

Any guesses? Again this works for the DBA as user ARAdmin.

William Rentfrow
Principal Consultant, StrataCom Inc.
wrentf...@stratacominc.com
Corporate Website, www.stratacominc.com
Blog, www.williamrentfrow.com
715-410-8156 C

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_

*

This email is intended for the named recipient(s) only. Its contents are  
confidential and may only be retained by the named recipient(s) and may only be 
copied or disclosed with the consent of LCH.Clearnet Limited.   If you are not 
an intended recipient please delete this e-mail and notify 
postmas...@lchclearnet.com.

The contents of this email are subject to contract in all cases, and 
LCH.Clearnet Limited makes no contractual commitment save where confirmed by 
hard copy.  LCH.Clearnet Limited accepts no liability, including liability for 
negligence, in respect of any statement in this email.

LCH.Clearnet Limited, Registered Office: Aldgate House, 33 Aldgate High Street, 
London EC3N 1EA.Recognised as a Clearing House under the Financial Services 
& Markets Act 2000. Reg in England No.25932 
Telephone: +44 20 7426 7000  Internet: http://www.lchclearnet.com

*


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

SV: Java ARDBC plugin failing with multiple instances "No suitable driver found for "

[Jonas Stumph Stevnsvig]

Slightly OT :

No static init routine found, skipping init call

which function is the "static init routine" ?? I have initialize() - is there 
another?


And on another note - noticed this in the logs:

Loading Java PluginSet DB2
Number of shared URLs for group DB2 is 0
Loading all Java Plugins for the group DB2
Attempting to load Java Plugin TD99
Number of URLs for plugin TD99 is 2
URL1: 
file:/C:/Program%20Files/BMC%20Software/ARSystem/Arserver/api/javaplugins/BECplugins/arapi.jar
URL2: file:/C:/Programmer/IBM/SQLLIB/java/db2java.zip
No static init routine found, skipping init call - TD99
Done  to call init plugin TD99
Successfully loaded Java Plugin TD99

It appears that the dual plugin server solution is the only answer. I'll look 
into that tonight.



Med venlig hilsen

Jonas Stumph Stevnsvig
Remedy Udvikler
BEC Kompetence Centret
Telefon (+45) 46 38 20 08
Mobil   (+45) 61 56 20 08
jonas.stumph.stevns...@bec.dk 

Til remedy spørgsmål: becrem...@bec.dk

BEC - det fælles it-hus, der gør forskellen for finansielle virksomheder

-Oprindelig meddelelse-
Fra: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] På vegne af Jonas Stumph Stevnsvig
Sendt: 19. august 2009 10:14
Til: arslist@ARSLIST.ORG
Emne: SV: Java ARDBC plugin failing with multiple instances "No suitable driver 
found for "

Hi Jarl and Sean,

I tried the  approach, and it didn't resolve anything. I still get 
this error for the second plugin:

Error establishing jdbc connection to the datasource jdbc:db2:CD99  No suitable 
driver found for jdbc:db2:CD99 


I have yet to try the dual java pluginserver approach, just have another 
assignment blocking the pipe at the moment - I hope I can set it up tonight.






with regards,



Jonas Stumph Stevnsvig
Remedy Developer
BEC Competence Centre
Phone  (+45) 46 38 20 08
Mobile  (+45) 61 56 20 08
jonas.stumph.stevns...@bec.dk
becrem...@bec.dk


-Oprindelig meddelelse-
Fra: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] På vegne af Jarl Grøneng
Sendt: 18. august 2009 19:51
Til: arslist@ARSLIST.ORG
Emne: Re: Java ARDBC plugin failing with multiple instances "No suitable driver 
found for "

Plugingroups are done this way:





  CD99
  ARDBC
  JAVA
  C:/Program Files/BMC
Software/ARSystem/Arserver/api/javaplugins/BECplugins/arapi.jar
  com.bmc.arsys.plugins.jdbc.JdbcDataSource
  C:/Programmer/IBM/SQLLIB/java/db2java.zip
  
jdbc:db2:CD99
COM.ibm.db2.jdbc.app.DB2Driver
someUser
somePassword
T
CD99
  


  OD99
  ARDBC
  JAVA
  C:/Program Files/BMC
Software/ARSystem/Arserver/api/javaplugins/BECplugins/arapi.jar
  com.bmc.arsys.plugins.jdbc.JdbcDataSource
  C:/Programmer/IBM/SQLLIB/java/db2java.zip
  
jdbc:db2:OD99
COM.ibm.db2.jdbc.app.DB2Driver
someOtherUser
someOtherpassword
TD
OD99
  



JARL.SUPER.PLUGIN
ARDBC
JAVA
jarl.jar
com.bmc.jarl
in the cloud
in the cloud


---

2009/8/18 Jonas Stumph Stevnsvig :
> **
> Hi - I'm still messing with this problem.
> I just stumbled across this:
>
>
>  * Note: If you are using the same class as two different plugins 
> identified by two
>  * different ids,  then these will not be able to share any 
> resources as they are
>  * loaded by two different classloaders, unless they were grouped 
> in a plugingroup
>  * in the plugin configuration, in which case they will be able to 
> share resources.
>  in this file:
> http://svn.arswiki.org/arapi/releases/win71/src/javaplugins/samplesrc/
> java/com/bmc/arsys/plugin/sample/ARDBCSample.java
>
>
>
> has anyone got an idea how to group the plugins in pluginsvr_config.xml??
>
>
>
> 
>
> 
>
> ...
>
> 
>
> 
>
> ...
>
> 
>
> 
>
> does not load anything at all - nor does it give an error... I wish 
> there was a DTD i could refer to.
>
> Med venlig hilsen
>
> Jonas Stumph Stevnsvig
> Remedy Udvikler
> BEC Kompetence Centret
> Telefon (+45) 46 38 20 08
> Mobil   (+45) 61 56 20 08
> jonas.stumph.stevns...@bec.dk
>
> Til remedy spørgsmål: becrem...@bec.dk
>
> BEC - det fælles it-hus, der gør forskellen for finansielle 
> virksomheder
>
>
> 
> Fra: Action Request System discussion list(ARSList) 
> [mailto:arsl...@arslist.org] På vegne af Jonas Stumph Stevnsvig
> Sendt: 14. august 2009 14:32
> Til: arslist@ARSLIST.ORG
> Emne: Java ARDBC plugin failing with multiple instances "No suitable 
> driver found for "
>
> **
> Hi listers,
>
> I really hope one of you has a solution for me here.
>
> We have developed an  ARDBC driver for connection to a DB2 database. 
> in the production environment we need to connect to two different 
> databases, so I have configured two  in

Re: Java ARDBC plugin failing with multiple instances "No suitable driver found for "

[Jarl Grøneng]

Static init method is something like this:


/**
* Implementation of the static init method, to do any static
initialization for this class.
* This method is called once for each class that implements one of the
ARPluggable interface
* on plugin server startup
* @param context
*/
public static void init(ARPluginContext context){
System.out.println("Static initialize method invoked");
System.out.println("UserDefined value for sample " +
context.getConfigItem("sample"));
}



--
Jarl

2009/8/19 Jonas Stumph Stevnsvig :
> Slightly OT :
>
> No static init routine found, skipping init call
>
> which function is the "static init routine" ?? I have initialize() - is there 
> another?
>
>
> And on another note - noticed this in the logs:
>
> Loading Java PluginSet DB2
> Number of shared URLs for group DB2 is 0
> Loading all Java Plugins for the group DB2
> Attempting to load Java Plugin TD99
> Number of URLs for plugin TD99 is 2
> URL1: 
> file:/C:/Program%20Files/BMC%20Software/ARSystem/Arserver/api/javaplugins/BECplugins/arapi.jar
> URL2: file:/C:/Programmer/IBM/SQLLIB/java/db2java.zip
> No static init routine found, skipping init call - TD99
> Done  to call init plugin TD99
> Successfully loaded Java Plugin TD99
>
> It appears that the dual plugin server solution is the only answer. I'll look 
> into that tonight.
>
>
>
> Med venlig hilsen
>
> Jonas Stumph Stevnsvig
> Remedy Udvikler
> BEC Kompetence Centret
> Telefon (+45) 46 38 20 08
> Mobil   (+45) 61 56 20 08
> jonas.stumph.stevns...@bec.dk
>
> Til remedy spørgsmål: becrem...@bec.dk
>
> BEC - det fælles it-hus, der gør forskellen for finansielle virksomheder
>
> -Oprindelig meddelelse-
> Fra: Action Request System discussion list(ARSList) 
> [mailto:arsl...@arslist.org] På vegne af Jonas Stumph Stevnsvig
> Sendt: 19. august 2009 10:14
> Til: arslist@ARSLIST.ORG
> Emne: SV: Java ARDBC plugin failing with multiple instances "No suitable 
> driver found for "
>
> Hi Jarl and Sean,
>
> I tried the  approach, and it didn't resolve anything. I still get 
> this error for the second plugin:
>
> Error establishing jdbc connection to the datasource jdbc:db2:CD99  No 
> suitable driver found for jdbc:db2:CD99
>
>
> I have yet to try the dual java pluginserver approach, just have another 
> assignment blocking the pipe at the moment - I hope I can set it up tonight.
>
>
>
>
>
>
> with regards,
>
>
>
> Jonas Stumph Stevnsvig
> Remedy Developer
> BEC Competence Centre
> Phone  (+45) 46 38 20 08
> Mobile  (+45) 61 56 20 08
> jonas.stumph.stevns...@bec.dk
> becrem...@bec.dk
>
>
> -Oprindelig meddelelse-
> Fra: Action Request System discussion list(ARSList) 
> [mailto:arsl...@arslist.org] På vegne af Jarl Grøneng
> Sendt: 18. august 2009 19:51
> Til: arslist@ARSLIST.ORG
> Emne: Re: Java ARDBC plugin failing with multiple instances "No suitable 
> driver found for "
>
> Plugingroups are done this way:
>
> 
> 
> 
>    
>      CD99
>      ARDBC
>      JAVA
>      C:/Program Files/BMC
> Software/ARSystem/Arserver/api/javaplugins/BECplugins/arapi.jar
>      com.bmc.arsys.plugins.jdbc.JdbcDataSource
>       type="location">C:/Programmer/IBM/SQLLIB/java/db2java.zip
>      
>        jdbc:db2:CD99
>        COM.ibm.db2.jdbc.app.DB2Driver
>        someUser
>        somePassword
>        T
>        CD99
>      
>    
>    
>      OD99
>      ARDBC
>      JAVA
>      C:/Program Files/BMC
> Software/ARSystem/Arserver/api/javaplugins/BECplugins/arapi.jar
>      com.bmc.arsys.plugins.jdbc.JdbcDataSource
>       type="location">C:/Programmer/IBM/SQLLIB/java/db2java.zip
>      
>        jdbc:db2:OD99
>        COM.ibm.db2.jdbc.app.DB2Driver
>        someOtherUser
>        someOtherpassword
>        TD
>        OD99
>      
>    
> 
>        
>                JARL.SUPER.PLUGIN
>                ARDBC
>                JAVA
>                jarl.jar
>                com.bmc.jarl
>                in the cloud
>                in the cloud
>        
> 
> ---
>
> 2009/8/18 Jonas Stumph Stevnsvig :
>> **
>> Hi - I'm still messing with this problem.
>> I just stumbled across this:
>>
>>
>>      * Note: If you are using the same class as two different plugins
>> identified by two
>>      * different ids,  then these will not be able to share any
>> resources as they are
>>      * loaded by two different classloaders, unless they were grouped
>> in a plugingroup
>>      * in the plugin configuration, in which case they will be able to
>> share resources.
>>  in this file:
>> http://svn.arswiki.org/arapi/releases/win71/src/javaplugins/samplesrc/
>> java/com/bmc/arsys/plugin/sample/ARDBCSample.java
>>
>>
>>
>> has anyone got an idea how to group the plugins in pluginsvr_config.xml??
>>
>>
>>
>> 
>>
>> 
>>
>> ...
>>
>> 
>>
>> 
>>
>> ...
>>
>> 
>>
>> 
>>
>> does not load anything at all - nor does it give an error... I wish
>> there was a DTD i could refer to.
>>
>> Med venlig hilsen
>>
>> Jonas Stumph Stevnsvig
>> Remedy U

Re: Convert Remedy Time to GMT

[Ashton, Jim (JUS)]

I use the following function (which also attempts to account for time
zone offsets and DST):

USE [msdb]
GO
/** Object:  UserDefinedFunction [dbo].[fnGetRemedyDate2]Script
Date: 02/12/2009 10:13:15 **/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER FUNCTION [dbo].[fnGetRemedyDate2](@RemedySeconds int) RETURNS
datetime AS BEGIN
/* In it's DST adjustment mechanism, WIN2K does not take into account
DST settings for years prior to 2007.  
In other words, dates in 2006 and prior are adjusted as though the new
DST rules apply.  
Therefore dates being returned by this function for years preceding 2007
require a different adjustment for the period from the beginning of old
DST (1st Sunday in April) to the end of old DST (last Sunday in October)
than do the years from 2007 forward which adjust DST from the beginning
of new DST (2nd Sunday in March) to the end of new DST (1st Sunday in
November).
*/
 DECLARE
 @strSDT varchar(15),
@sdt smalldatetime, 
@edt smalldatetime,
@i tinyint,
 @Offset int,
 @DSTBias int,
 @RemedyDate datetime,
 @UTCDate datetime,
 @Year int
 SELECT @UTCDate = DATEADD(second, @RemedySeconds, '1970-01-01')
-- value of Remedy (epoch) time GMT 

 -- determine standard offset value by reading from registry with
undocumented extended sp xp_regread  EXEC master.dbo.xp_regread 
 
@rootkey='HKEY_LOCAL_MACHINE',@key='SYSTEM\CurrentControlSet\Control\Tim
eZoneInformation',
 @value_name='Bias', @val...@offset OUTPUT
 -- Bias reads in minutes; convert standard offset to seconds  SELECT
@Offset = @Offset * 60

 -- get DST bias value from registry
 EXEC master.dbo.xp_regread 
 
@rootkey='HKEY_LOCAL_MACHINE',@key='SYSTEM\CurrentControlSet\Control\Tim
eZoneInformation',
 @value_name='DaylightBias', @val...@dstbias OUTPUT
 -- Bias reads in minutes; convert standard offset to seconds  SELECT
@DSTBias = @DSTBias * 60

 -- do analysis to determine year - adjustment may be required based on
DST bias (do this with GMT time only-if date is on cusp of year, it will
not affect DST)  SELECT @Year=YEAR(DATEADD(second,@RemedySeconds,
'1970-01-01'))  IF (@Year > 2006)  BEGIN
  -- find second Sunday in March - between 8th and 14th
  SET @i = 8
  WHILE @i < 15
  BEGIN 
   SET @strSDT = RTRIM(YEAR(@UTCDate))+'03'
   IF (@i < 10)
SET @strSDT = @strSDT + '0'
   SET @strSDT = @strSDT +RTRIM(@i)+' 02:00'
   SET @s...@strsdt
   IF DATEPART(weekday,@sdt)=1  
   BEGIN 
SET @i = 14 
   END 
   SET @i = @i + 1
  END
  -- find first Sunday in November
  SET @i = 1
  WHILE @i < 8
  BEGIN 
   SET @edt =
RTRIM(YEAR(@UTCDate))+'110'+RTRIM(@i)+' 02:00'
   IF DATEPART(weekday,@edt)=1  
   BEGIN 
SET @i = 7 
   END 
   SET @i = @i + 1
  END
 END
 ELSE
 BEGIN
  -- find first Sunday in April
  SET @i = 1
  WHILE @i < 8
  BEGIN 
   SET @sdt =
RTRIM(YEAR(@UTCDate))+'040'+RTRIM(@i)+' 02:00'
   IF DATEPART(weekday,@sdt)=1  
   BEGIN 
SET @i = 7 
   END 
   SET @i = @i + 1
  END
  -- find last Sunday in October
  SET @i = 31
  WHILE @i > 24
  BEGIN 
   SET @edt = RTRIM(YEAR(@UTCDate))+'10'+RTRIM(@i)
+ ' 02:00' 
   IF DATEPART(weekday,@edt)=1  
   BEGIN 
SET @i = 24 
   END 
   SET @i = @i - 1
  END
 END

 IF (@UTCDate>=...@sdt AND @UTCDate<@edt)
  SET @offset = @offset + @DSTBias -- adjust  offset by value of DST
bias obtained from registry above

 SELECT @RemedyDate = DATEADD(second,(@RemedySeconds - @Offset),
'1970-01-01')
 RETURN(@RemedyDate)
END


Cheers,
Jim.

(Previously posted Feb 2009)



___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Convert Remedy Time to GMT

[Ashton, Jim (JUS)]

I use the following function (which also attempts to account for time
zone offsets and DST):

USE [msdb]
GO
/** Object:  UserDefinedFunction [dbo].[fnGetRemedyDate2]Script
Date: 02/12/2009 10:13:15 **/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER FUNCTION [dbo].[fnGetRemedyDate2](@RemedySeconds int) RETURNS
datetime AS BEGIN
/* In it's DST adjustment mechanism, WIN2K does not take into account
DST settings for years prior to 2007.  
In other words, dates in 2006 and prior are adjusted as though the new
DST rules apply.  
Therefore dates being returned by this function for years preceding 2007
require a different adjustment for the period from the beginning of old
DST (1st Sunday in April) to the end of old DST (last Sunday in October)
than do the years from 2007 forward which adjust DST from the beginning
of new DST (2nd Sunday in March) to the end of new DST (1st Sunday in
November).
*/
 DECLARE
 @strSDT varchar(15),
@sdt smalldatetime, 
@edt smalldatetime,
@i tinyint,
 @Offset int,
 @DSTBias int,
 @RemedyDate datetime,
 @UTCDate datetime,
 @Year int
 SELECT @UTCDate = DATEADD(second, @RemedySeconds, '1970-01-01')
-- value of Remedy (epoch) time GMT 

 -- determine standard offset value by reading from registry with
undocumented extended sp xp_regread  EXEC master.dbo.xp_regread 
 
@rootkey='HKEY_LOCAL_MACHINE',@key='SYSTEM\CurrentControlSet\Control\Tim
eZoneInformation',
 @value_name='Bias', @val...@offset OUTPUT
 -- Bias reads in minutes; convert standard offset to seconds  SELECT
@Offset = @Offset * 60

 -- get DST bias value from registry
 EXEC master.dbo.xp_regread 
 
@rootkey='HKEY_LOCAL_MACHINE',@key='SYSTEM\CurrentControlSet\Control\Tim
eZoneInformation',
 @value_name='DaylightBias', @val...@dstbias OUTPUT
 -- Bias reads in minutes; convert standard offset to seconds  SELECT
@DSTBias = @DSTBias * 60

 -- do analysis to determine year - adjustment may be required based on
DST bias (do this with GMT time only-if date is on cusp of year, it will
not affect DST)  SELECT @Year=YEAR(DATEADD(second,@RemedySeconds,
'1970-01-01'))  IF (@Year > 2006)  BEGIN
  -- find second Sunday in March - between 8th and 14th
  SET @i = 8
  WHILE @i < 15
  BEGIN 
   SET @strSDT = RTRIM(YEAR(@UTCDate))+'03'
   IF (@i < 10)
SET @strSDT = @strSDT + '0'
   SET @strSDT = @strSDT +RTRIM(@i)+' 02:00'
   SET @s...@strsdt
   IF DATEPART(weekday,@sdt)=1  
   BEGIN 
SET @i = 14 
   END 
   SET @i = @i + 1
  END
  -- find first Sunday in November
  SET @i = 1
  WHILE @i < 8
  BEGIN 
   SET @edt =
RTRIM(YEAR(@UTCDate))+'110'+RTRIM(@i)+' 02:00'
   IF DATEPART(weekday,@edt)=1  
   BEGIN 
SET @i = 7 
   END 
   SET @i = @i + 1
  END
 END
 ELSE
 BEGIN
  -- find first Sunday in April
  SET @i = 1
  WHILE @i < 8
  BEGIN 
   SET @sdt =
RTRIM(YEAR(@UTCDate))+'040'+RTRIM(@i)+' 02:00'
   IF DATEPART(weekday,@sdt)=1  
   BEGIN 
SET @i = 7 
   END 
   SET @i = @i + 1
  END
  -- find last Sunday in October
  SET @i = 31
  WHILE @i > 24
  BEGIN 
   SET @edt = RTRIM(YEAR(@UTCDate))+'10'+RTRIM(@i)
+ ' 02:00' 
   IF DATEPART(weekday,@edt)=1  
   BEGIN 
SET @i = 24 
   END 
   SET @i = @i - 1
  END
 END

 IF (@UTCDate>=...@sdt AND @UTCDate<@edt)
  SET @offset = @offset + @DSTBias -- adjust  offset by value of DST
bias obtained from registry above

 SELECT @RemedyDate = DATEADD(second,(@RemedySeconds - @Offset),
'1970-01-01')
 RETURN(@RemedyDate)
END


Cheers,
Jim.

(Previously posted Feb 2009)



___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Support Renewal - developer Plus

[Sokol, Brian]

I just was sent our annual support renewal. One of the items is Remedy
Developer Plus. Is there any reason to pay for this product? Isn't this
product discontinued? Should I have it removed?

Thanks,

Brian Sokol 
Manager, Desktop Services
Scholastic Inc. 
557 Broadway 
NY, NY 10012 
(212) 343-6494 
http://www.Scholastic.com   



___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Convert Remedy Time to GMT

[Jim Fox]

Roger: I dealt with this problem years ago and found that the only way to
deal with dates from way back to present is to hard-code the times that DST
applies each year and hard-code your timezone.

Since DST (at least in US) is subject to the whims of legislators, there is
clearly no systematic formula that will compute the dates DST is on and
barring connecting GPS to your computer and reading its data into the
function, there is no surefire way to know where the user is located when
they may be moving from place to place (i.e., with portable computer or PDA,
etc.)

Fluxman

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Frank Caruso
Sent: 08/19/2009 12:31 AM
To: arslist@ARSLIST.ORG
Subject: Re: Convert Remedy Time to GMT

I am thinking quickly on this and have not tested the solution but ...

What if you used a SQL statement to get the CreateDate value directly
from the database, which is in GMT. Then, using the DateAdd function
in Remedy, add that value to 01/01/1970 and store it in a date field.
Take that value and set it to a character field and use in your web
service.

HTH

Frank

On Tue, Aug 18, 2009 at 10:23 PM, Nall, Roger
wrote:
> **
> Hello All,
>
> I have a request to send the Create Date of a ticket to an external
> application via a Web Service. This must be passed as a string and needs
to
> be in GMT. My server is in NJ thus the server time is Eastern. The issue
is
> how to handle Daylight Savings time. I could do this by checking the
> date/time value to see if it falls between March 8 and November 1 but that
> only takes care of this year. I wanted to check to see if anyone may be
> doing something like this now that they can share.
>
> Thanks,
>
> Roger Nall
> Manager, SA Remedy
> Desk Phone: 972-464-3712
> Mobile: 973-652-6723
>
>
>
> _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
> Are"_


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Query against two forms

[Mark Seiler]

Thanks Shawn it looks like taking an approach more like you suggest
is going to work out.
Cheers,
Mark

On Tue, Aug 18, 2009 at 10:40 AM, Pierson, Shawn wrote:

> **
>
> I think your underlying flow is part of the problem.  Why not just have a
> field on the ALLrecs form such as the Status that can have only two values
> of “New” and “Processed”?  Even if you have a real need to push the records
> to the ProcessedRecs table, you could have a filter on the ProcessedRecs
> table push back the “Processed” value to the Allrecs table, at which point
> your query in the Allrecs table can be where ‘Status’ = 0 (e.g. New)?
>
>
>
> I think rather than trying to make what you are doing work, you may want to
> take a step back and look at your design and make sure you are proceeding
> down the right path.
>
>
>
> Shawn Pierson
>
>
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> arsl...@arslist.org] *On Behalf Of *Mark Seiler
> *Sent:* Tuesday, August 18, 2009 8:35 AM
> *To:* arslist@ARSLIST.ORG
> *Subject:* Query against two forms
>
>
>
> **
>
> Hi Listers,
> I'm looking for some guidance on doing the following:
> I have 2 regular forms called ALLrecs and PROCESSEDrecs, each having fields
> like F1, F2 and F3
> I'm looking to populate a third form to contain the results of a query such
> that the user can select from a list of AVAILABLE records (everything in
> ALLrecs less all the records in PROCESSEDrecs). A working SQL statement to
> do this is:
>
> SELECT F1, F2, F3
> FROM ALLrecs
> WHERE (F1 NOT IN (SELECT F1, F2, F3 FROM PROCESSEDrecs))
>
> Making this new AVAILABLE form a join form (inner or outer) doesn't seem to
> be giving me the results I want. Perhaps a Direct SQL or table walk on
> ALLrecs? arrgh.
> This AVAILABLE data has to be updated or recreated each time the user
> performs this activity.
>
> Ultimately the users selections from AVAILABLE will be further processed,
> then will update the PROCESSEDrecs form etc etc (I've got that part).
>
> Thanks for any thoughts.
> -Mark
>
>
>  Win Server 2003/MS SQL 2000
>  ARS 7.1 patch 6
>  ITSM 7.0.03 patch 006
>
> _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
> Are"_
> Private and confidential as detailed 
> here.
> If you cannot access hyperlink, please e-mail sender.
>  _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
> Are"_
>

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Filter / notify / phase 3 question

[Sean Harrodine]

Hi everyone,

I have an action in a filter that sends out a notification if a certain field 
is populated, but because its a notification, it gets delayed to "phase 3".

The 2nd action in the filter is to empty the field, so by the time the phase 3 
occurs, the field is empty.

So
Q : Are you able to force a filter action to not wait for phase 3 and to run 
immediately (namely, before i empty the field)?


I know i could create a duplicate field and then use that in the email but it 
seems unnecessary, and i could also push it out to another form and email from 
there but again, it seems overkill.

Any ideas ?

TIA

Sean




___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
  

Re: Filter / notify / phase 3 question

[Frank Caruso]

If you put a "`!" at the end of the filter it will process the filter
immediately.

On Wed, Aug 19, 2009 at 6:55 PM, Sean Harrodine wrote:
> **
> Hi everyone,
>
> I have an action in a filter that sends out a notification if a certain
> field is populated, but because its a notification, it gets delayed to
> "phase 3".
>
> The 2nd action in the filter is to empty the field, so by the time the phase
> 3 occurs, the field is empty.
>
> So
> Q : Are you able to force a filter action to not wait for phase 3 and to run
> immediately (namely, before i empty the field)?
>
>
> I know i could create a duplicate field and then use that in the email but
> it seems unnecessary, and i could also push it out to another form and email
> from there but again, it seems overkill.
>
> Any ideas ?
>
> TIA
>
> Sean
>
> _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
> Are"_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Filter / notify / phase 3 question

[jham36]

I have tried what Frank suggested yesterday while working on a similar
issue that Sean has.  My problem is that I need the data in that
"cleared" field to be included in the email.  Even though my notify
action fired before phase 3, it seems that there are a number of
system workflow objects that fire at phase 3 to generate the email.
At that point, the field is empty and that data would not be included
in the email.

James

On Aug 19, 11:58 am, Frank Caruso  wrote:
> If you put a "`!" at the end of the filter it will process the filter
> immediately.
>
>
>
> On Wed, Aug 19, 2009 at 6:55 PM, Sean Harrodine 
> wrote:
> > **
> > Hi everyone,
>
> > I have an action in a filter that sends out a notification if a certain
> > field is populated, but because its a notification, it gets delayed to
> > "phase 3".
>
> > The 2nd action in the filter is to empty the field, so by the time the phase
> > 3 occurs, the field is empty.
>
> > So
> > Q : Are you able to force a filter action to not wait for phase 3 and to run
> > immediately (namely, before i empty the field)?
>
> > I know i could create a duplicate field and then use that in the email but
> > it seems unnecessary, and i could also push it out to another form and email
> > from there but again, it seems overkill.
>
> > Any ideas ?
>
> > TIA
>
> > Sean
>
> > _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
> > Are"_
>
> ___
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Support Renewal - developer Plus

[jham36]

It still works with a 7.1 server.  I believe it becomes obsolete with
7.5

James

On Aug 19, 9:33 am, "Sokol, Brian"  wrote:
> I just was sent our annual support renewal. One of the items is Remedy
> Developer Plus. Is there any reason to pay for this product? Isn't this
> product discontinued? Should I have it removed?
>
> Thanks,
>
> Brian Sokol
> Manager, Desktop Services
> Scholastic Inc.
> 557 Broadway
> NY, NY 10012
> (212) 343-6494http://www.Scholastic.com  
>
> ___
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Workflow Documentation 7.1

[Kathy Morris]

Hi All,
 
I am trying to run a tool to document our workflow on our system (AR 7.1,  
ITSM) on Windows.  I had been using AR system, but the AL are displaying,  
but the forms are not displaying - is there another free tool I can use to  
document the workflow?

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Filter / notify / phase 3 question

[Rick Cook]

James,

The contents of a field, even a Display-Only field, remain static until one
of two things happen:

1)  Other workflow changes it.
2)  The current transaction is complete.

So if your Filter is firing on Modify, all Modify Filters will fire against
that record, and the data will remain under the control of the Filters until
they are done.  At that point, the DO field is cleared by AR System.  Since
I haven't seen anything indicating your Filters are firing on different
actions, and both actions are in the same Filter, I suspect that other
workflow is changing (or nulling) the value of the field.  Remember that the
Phase 3 action (Notify) will be deferred until all of the other Phase 2
actions have completed.  Look at your Filter logs to find what might be
setting that field.

Rick

On Wed, Aug 19, 2009 at 10:52 AM, jham36  wrote:

> I have tried what Frank suggested yesterday while working on a similar
> issue that Sean has.  My problem is that I need the data in that
> "cleared" field to be included in the email.  Even though my notify
> action fired before phase 3, it seems that there are a number of
> system workflow objects that fire at phase 3 to generate the email.
> At that point, the field is empty and that data would not be included
> in the email.
>
> James
>
> On Aug 19, 11:58 am, Frank Caruso  wrote:
> > If you put a "`!" at the end of the filter it will process the filter
> > immediately.
> >
> >
> >
> > On Wed, Aug 19, 2009 at 6:55 PM, Sean Harrodine
> wrote:
> > > **
> > > Hi everyone,
> >
> > > I have an action in a filter that sends out a notification if a certain
> > > field is populated, but because its a notification, it gets delayed to
> > > "phase 3".
> >
> > > The 2nd action in the filter is to empty the field, so by the time the
> phase
> > > 3 occurs, the field is empty.
> >
> > > So
> > > Q : Are you able to force a filter action to not wait for phase 3 and
> to run
> > > immediately (namely, before i empty the field)?
> >
> > > I know i could create a duplicate field and then use that in the email
> but
> > > it seems unnecessary, and i could also push it out to another form and
> email
> > > from there but again, it seems overkill.
> >
> > > Any ideas ?
> >
> > > TIA
> >
> > > Sean
> >
> > > _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the
> Answers
> > > Are"_
> >
> >
> ___
> > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> > Platinum 
> > Sponsor:rmisoluti...@verizon.netARSlist:
> >  "Where the Answers Are"
>
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> Platinum 
> Sponsor:rmisoluti...@verizon.netARSlist: 
> "Where the Answers Are"
>

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

ARERR 9351 - Need Help

[bruce sisk]

Hello,

We are experiencing a problem with our mid-tier users in that they get a 5-10 
minute screen lock whenever they try to access the Incident management Console 
by clicking the link on the Home page.  When the screen finally unlocks, they 
get the error:

Unable to setup data connection, which is preventing the application from 
working correctly. (ARERR 9351)

Environment:

ARS 7.1 Patch 7
Oracle 10 (remote server)
Mid-tier 7.1 patch 7 (2 remote servers running Tomcat and IIS6 with a load 
balancer)
Users are browsing with both IE 6 and 7.  We get the error in both.

The problem is intermitent...not everyone is having the problem...those who 
have it don't have it all the time.

Done so far:

Have researched the issue on Remedy's KB...not much information.
Have researched the issue on ARSList...several postings, but no solutions.
Have opened an issue with Remedy support...we seem to just be sending them log 
files.

Have tried to turn on client side logging for users having the issue...with 
logging turned on (setting through Preferences form), the issue completely goes 
away.
Server side logging does not reveal any issues or errors.
Have downloaded and installed Fiddler (a suggestion from the ARSList 
postings)...again, while logging through Fiddler, the issue completely goes 
away.
Have downloaded and installed Firefox 3.5 the issue goes away.

Some things we CAN'T do:

IE is the "official" browser for this company, so Firefox is NOT an option.
The Workflow logging window that opens with client side remedy logging is 
irritating people so that can't be considered a permanent solution.

This is a plea for any insight or solutions from those who have had this issue 
in the past and what you did to resolve it.

Thanks,

Bruce Sisk
BFS Enterprises


PeoplePC Online
A better way to Internet
http://www.peoplepc.com

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Support Renewal - developer Plus

[Easter, David]

The product is not discontinued - but is not being further enhanced.  If you 
are on AR System 7.5.00, then you now have the basic capabilities of RDP built 
into Dev Studio.  However, if you are still on AR System 7.1.00 or previous, 
then RDP is still relevant in your environment and could be retained if you're 
finding value from it.

-David J. Easter
Sr. Product Manager, Solution Strategy and Development
BMC Software, Inc.

The opinions, statements, and/or suggested courses of action expressed in this 
E-mail do not necessarily reflect those of BMC Software, Inc.  My voluntary 
participation in this forum is not intended to convey a role as a spokesperson, 
liaison or public relations representative for BMC Software, Inc.

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Sokol, Brian
Sent: Wednesday, August 19, 2009 6:34 AM
To: arslist@ARSLIST.ORG
Subject: Support Renewal - developer Plus

**

I just was sent our annual support renewal. One of the items is Remedy 
Developer Plus. Is there any reason to pay for this product? Isn't this product 
discontinued? Should I have it removed?

Thanks,

Brian Sokol
Manager, Desktop Services
Scholastic Inc.
557 Broadway
NY, NY 10012
(212) 343-6494
http://www.Scholastic.com

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Workflow Documentation 7.1

[Meyer, Jennifer L]

ARInside: www.arinside.org



Jennifer Meyer


From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Kathy Morris
Sent: Wednesday, August 19, 2009 2:11 PM
To: arslist@ARSLIST.ORG
Subject: Workflow Documentation 7.1

Hi All,

I am trying to run a tool to document our workflow on our system (AR 7.1, ITSM) 
on Windows.  I had been using AR system, but the AL are displaying, but the 
forms are not displaying - is there another free tool I can use to document the 
workflow?


_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_

E-mail correspondence to and from this address may be subject to the North 
Carolina Public Records Law and may be disclosed to third parties by an 
authorized state official.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: ARERR 9351 - Need Help

[William Rentfrow]

I ran into something like this a while ago.

If you can limit the results on the table field which refreshes on open.
We were having performance problems due to issues on the Oracle side and
a refresh of data in that console when it opened would produce exactly
the same result.

You might try turning on chunking or temporarily changing code so that
it doesn't refresh when it opens. 


William Rentfrow
Principal Consultant, StrataCom Inc.
wrentf...@stratacominc.com
Corporate Website, www.stratacominc.com
Blog, www.williamrentfrow.com
715-410-8156 C

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of bruce sisk
Sent: Wednesday, August 19, 2009 1:20 PM
To: arslist@ARSLIST.ORG
Subject: ARERR 9351 - Need Help

Hello,

We are experiencing a problem with our mid-tier users in that they get a
5-10 minute screen lock whenever they try to access the Incident
management Console by clicking the link on the Home page.  When the
screen finally unlocks, they get the error:

Unable to setup data connection, which is preventing the application
from working correctly. (ARERR 9351)

Environment:

ARS 7.1 Patch 7
Oracle 10 (remote server)
Mid-tier 7.1 patch 7 (2 remote servers running Tomcat and IIS6 with a
load balancer) Users are browsing with both IE 6 and 7.  We get the
error in both.

The problem is intermitent...not everyone is having the problem...those
who have it don't have it all the time.

Done so far:

Have researched the issue on Remedy's KB...not much information.
Have researched the issue on ARSList...several postings, but no
solutions.
Have opened an issue with Remedy support...we seem to just be sending
them log files.

Have tried to turn on client side logging for users having the
issue...with logging turned on (setting through Preferences form), the
issue completely goes away.
Server side logging does not reveal any issues or errors.
Have downloaded and installed Fiddler (a suggestion from the ARSList
postings)...again, while logging through Fiddler, the issue completely
goes away.
Have downloaded and installed Firefox 3.5 the issue goes away.

Some things we CAN'T do:

IE is the "official" browser for this company, so Firefox is NOT an
option.
The Workflow logging window that opens with client side remedy logging
is irritating people so that can't be considered a permanent solution.

This is a plea for any insight or solutions from those who have had this
issue in the past and what you did to resolve it.

Thanks,

Bruce Sisk
BFS Enterprises


PeoplePC Online
A better way to Internet
http://www.peoplepc.com


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum
Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: ARERR 552 - Database link is not open

[William Rentfrow]

We have made some progress on this - it appears the issus is tied to a
difference between Oracle 9i and 10g and how the "Alter Session" command
works in a stored procedure.
 
William Rentfrow
Principal Consultant, StrataCom Inc.
wrentf...@stratacominc.com
Corporate Website, www.stratacominc.com  
Blog, www.williamrentfrow.com  
715-410-8156 C
 



From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Joe DeSouza
Sent: Tuesday, August 18, 2009 7:31 PM
To: arslist@ARSLIST.ORG
Subject: Re: ARERR 552 - Database link is not open


** 
William,
 
How are you running the Stored Proceedure from Remedy? I mean the exact
syntax of how you are trying to execute it..
 
Joe



From: William Rentfrow 
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"_ 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Support Renewal - developer Plus

[Shyam Attavar]

If you see value in using Remedy Developer Plus, then you may continue
support.

IMHO, the tool is very slow and does not perform all the things that I was
used to, with IT Masters tool that RDP replaced. So, we did not continue
support for RDP.

My 2¢
--
Shyam

"jham36"  wrote in message
news:<01c95ad5-0506-4643-adfa-9dbf3c221...@d32g2000yqh.googlegroups.com>
It still works with a 7.1 server.  I believe it becomes obsolete with
7.5

James

On Aug 19, 9:33 am, "Sokol, Brian"  wrote:
> I just was sent our annual support renewal. One of the items is Remedy
> Developer Plus. Is there any reason to pay for this product? Isn't this
> product discontinued? Should I have it removed?
>
> Thanks,
>
> Brian Sokol
> Manager, Desktop Services
> Scholastic Inc.
> 557 Broadway
> NY, NY 10012
> (212) 343-6494http://www.Scholastic.com  
>
>

___
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

--

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: ARERR 9351 - Need Help

[Cesaro, Tony M[EQ]]

Bruce,

We have the EXACT same environment and we are experiencing the same symptoms.  
BMC support has been no help and has concluded to us that it is a network 
latency issue that we need to resolve ourselves.  This does seem to be related 
to network because I cannot reproduce the errors on my LAN connection with the 
server, while users about 3 states away are experiencing it 3-5 times a day.

Surely there is some sort of timeout threshold (in Tomcat itself or the 
Mid-Tier servlets) that we can tune to make this more tolerable to the latency 
of the data transfer to fill the field with large amounts of data.  I've even 
upgraded Tomcat to version 5.5.27 as recommended in KB doc 20003714, which 
didn't resolve the issue.

Hopefully someone out there has come up with a sure-fire resolution to this one 
as we too have investigated this to no end.  Thanks to anyone who can help us 
out!

Regards,

Tony Cesaro


-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of bruce sisk
Sent: Wednesday, August 19, 2009 14:20
To: arslist@ARSLIST.ORG
Subject: ARERR 9351 - Need Help

Hello,

We are experiencing a problem with our mid-tier users in that they get a 5-10 
minute screen lock whenever they try to access the Incident management Console 
by clicking the link on the Home page.  When the screen finally unlocks, they 
get the error:

Unable to setup data connection, which is preventing the application from 
working correctly. (ARERR 9351)

Environment:

ARS 7.1 Patch 7
Oracle 10 (remote server)
Mid-tier 7.1 patch 7 (2 remote servers running Tomcat and IIS6 with a load 
balancer)
Users are browsing with both IE 6 and 7.  We get the error in both.

The problem is intermitent...not everyone is having the problem...those who 
have it don't have it all the time.

Done so far:

Have researched the issue on Remedy's KB...not much information.
Have researched the issue on ARSList...several postings, but no solutions.
Have opened an issue with Remedy support...we seem to just be sending them log 
files.

Have tried to turn on client side logging for users having the issue...with 
logging turned on (setting through Preferences form), the issue completely goes 
away.
Server side logging does not reveal any issues or errors.
Have downloaded and installed Fiddler (a suggestion from the ARSList 
postings)...again, while logging through Fiddler, the issue completely goes 
away.
Have downloaded and installed Firefox 3.5 the issue goes away.

Some things we CAN'T do:

IE is the "official" browser for this company, so Firefox is NOT an option.
The Workflow logging window that opens with client side remedy logging is 
irritating people so that can't be considered a permanent solution.

This is a plea for any insight or solutions from those who have had this issue 
in the past and what you did to resolve it.

Thanks,

Bruce Sisk
BFS Enterprises


PeoplePC Online
A better way to Internet
http://www.peoplepc.com

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Workflow Documentation 7.1

[Kathy Morris]

Do you need to more than 2 GIG of RAM to run this product -  because the 
arinside executes, then freezes after about 1 hour, and then I  get an 
exception error.  Is this common with this tool.  The exception  error comes 
before 
the forms are generated in the HTML format.  Active  
links/filters/applications are displayed
 
 
In a message dated 8/19/2009 3:06:04 P.M. Eastern Daylight Time,  
jennifer.me...@its.nc.gov writes:

** 
 
ARInside: _www.arinside.org_ (http://www.arinside.org/)  
 
Jennifer  Meyer
 
  

 
From: Action  Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Kathy Morris
Sent: Wednesday, August 19, 2009 2:11  PM
To:  arslist@ARSLIST.ORG
Subject:  Workflow Documentation 7.1
 
Hi  All,
 

 
I am trying to run a  tool to document our workflow on our system (AR 7.1, 
ITSM) on Windows.  I  had been using AR system, but the AL are displaying, 
but the forms are  not displaying - is there another free tool I can use to 
document the  workflow?
 
  

 


_Platinum Sponsor: rmisoluti...@verizon.net  ARSlist: "Where the Answers 
Are"_
 

E-mail correspondence to and from this  address may be subject to the North 
Carolina Public Records Law and may be  disclosed to third parties by an 
authorized state  official.
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist:  "Where the Answers 
Are"_


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Approval Server

[Rosemary]

Hi Vijay,

I have seen this before and this is the information BMC Support provided to
fix the issue

-


STEPS to REBUILD AP:NOTIFY-x Filters:



AP:Notification is the form that holds the notification records, there are
14 of them.  The filters are built against the 3-way join:
CHG:InfrastructureChangeAPDetail



Do a view/by form in the admin tool for CHG:InfrastructureChangeAPDetail and
check to see if the AP:Notify filters are there. Probably not, but if they
are, they may not be updated .



Export the data out (all 14 records) of the AP:Notificaiton form and
reimport to AP:Notification, with approval server running. The Approval
server should then build those filters. (This should have occurred
automatically, but it has been seen where there will be data in the
AP:Notification form, but the accompanying AP:Notifiy filters will not have
been generated. It is believed that the approval server, since it is what
creates the filters, was not running or operational at the time that the
Change Management application was installed, or during the approval server
install/upgrade).



Before you import the records, you may need to delete the 14 filters
starting with the name:



   AP:Notify-0xx



these filters will be recreated upon import of hte records to the
AP:Notification form.



When you import, set preferences in the AR Import tool, under
File/Preferences, Duplicate Request ID, choose "Update old record with new
record's data." (Only if there are existing AP:Notify records).  Upon import
of this data, the approval server should generate the new filters.  The
exact notification ID used for the AP:Notify-x filter name is the value
used in the AP:Notification form under the Administrative Information tab
for Notification ID. Your exact number may not be the same as those in the
attachment, but they only need to be unique, so yours may vary.



If this does not work you will need to get approval debug logging and filter
logging capturing the problem.



>From the Admin tool,  there should be 14 AP:Notify- filters, firing on
Submit/Modify from CHG:ChangeAPDetailSignature form:



AP:Notify-001  AP:Notify-008

AP:Notify-002  AP:Notify-009

AP:Notify-003  AP:Notify-010

AP:Notify-004  AP:Notify-011

AP:Notify-005  AP:Notify-012

AP:Notify-006  AP:Notify-013

AP:Notify-007  AP:Notify-014


On Wed, Aug 19, 2009 at 4:06 PM, Vijayalakshmi Paulraj <
vijayalaksh...@virtusa.com> wrote:

> **
>
> Hi  All,
>
> One of my server is not sending mails or alerts when a approver is added to
> a Change ticket reason being the Filters which trigger the notification
> process is missing.
>
> E.g.,
>
> AP:Notify-001;
>
> I am not sure why these filters are missing in one server and available in 
> other
> server. Please write to me if anybody has come across this situation?
>
> I want to know how these filters get created?
>
> Thanks & Regards,
>
> Vijayalakshmi Paulraj
>
>   
> -
>
> 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.
>
> -
>
> _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
> Are"_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: ARERR 9351 - Need Help

[Joe DeSouza]

Bruce,

What patch of the "ITSM Applications" (NOT ARS) are you guys on? I remember 
there used to be an issue with the ardbcQuery.dll with the early releases of 
ITSM 7 that used to result in that error.

I am not sure which patch resolved that problem. I'm pretty sure it was either 
Patch 3 or above though.

Joe




From: bruce sisk 
To: arslist@ARSLIST.ORG
Sent: Wednesday, August 19, 2009 2:20:08 PM
Subject: ARERR 9351 - Need Help

Hello,

We are experiencing a problem with our mid-tier users in that they get a 5-10 
minute screen lock whenever they try to access the Incident management Console 
by clicking the link on the Home page.  When the screen finally unlocks, they 
get the error:

Unable to setup data connection, which is preventing the application from 
working correctly. (ARERR 9351)

Environment:

ARS 7.1 Patch 7
Oracle 10 (remote server)
Mid-tier 7.1 patch 7 (2 remote servers running Tomcat and IIS6 with a load 
balancer)
Users are browsing with both IE 6 and 7.  We get the error in both.

The problem is intermitent...not everyone is having the problem...those who 
have it don't have it all the time.

Done so far:

Have researched the issue on Remedy's KB...not much information.
Have researched the issue on ARSList...several postings, but no solutions.
Have opened an issue with Remedy support...we seem to just be sending them log 
files.

Have tried to turn on client side logging for users having the issue...with 
logging turned on (setting through Preferences form), the issue completely goes 
away.
Server side logging does not reveal any issues or errors.
Have downloaded and installed Fiddler (a suggestion from the ARSList 
postings)...again, while logging through Fiddler, the issue completely goes 
away.
Have downloaded and installed Firefox 3.5 the issue goes away.

Some things we CAN'T do:

IE is the "official" browser for this company, so Firefox is NOT an option.
The Workflow logging window that opens with client side remedy logging is 
irritating people so that can't be considered a permanent solution.

This is a plea for any insight or solutions from those who have had this issue 
in the past and what you did to resolve it.

Thanks,

Bruce Sisk
BFS Enterprises


PeoplePC Online
A better way to Internet
http://www.peoplepc.com




___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Support Renewal - developer Plus

[Tanner, Doug]

Yeah, ITMasters Rocked!

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Shyam Attavar
Sent: Wednesday, August 19, 2009 3:30 PM
To: arslist@ARSLIST.ORG
Subject: Re: Support Renewal - developer Plus

If you see value in using Remedy Developer Plus, then you may continue
support.

IMHO, the tool is very slow and does not perform all the things that I was
used to, with IT Masters tool that RDP replaced. So, we did not continue
support for RDP.

My 2¢
--
Shyam

"jham36"  wrote in message
news:<01c95ad5-0506-4643-adfa-9dbf3c221...@d32g2000yqh.googlegroups.com>
It still works with a 7.1 server.  I believe it becomes obsolete with
7.5

James

On Aug 19, 9:33 am, "Sokol, Brian"  wrote:
> I just was sent our annual support renewal. One of the items is Remedy
> Developer Plus. Is there any reason to pay for this product? Isn't this
> product discontinued? Should I have it removed?
>
> Thanks,
>
> Brian Sokol
> Manager, Desktop Services
> Scholastic Inc.
> 557 Broadway
> NY, NY 10012
> (212) 343-6494http://www.Scholastic.com  
>
>

___
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

--

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"


DISCLAIMER Important! This message is intended for the above named person(s) 
only and is CONFIDENTIAL AND PROPRIETARY. If you are not the intended recipient 
of this e-mail and have received it in error, please immediately notify the 
sender by return email and then delete it from your mailbox. This message may 
be protected by the attorney-client privilege and/or work product doctrine.  
Accessing, copying, disseminating or re-using any of the information contained 
in this e-mail by anyone other than the intended recipient is strictly 
prohibited. Finally, you should check this email and any attachments for the 
presence of viruses, as the sender accepts no liability for any damage caused 
by any virus transmitted by this email.  Thank you.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Support Renewal - developer Plus

[Jarl Grøneng]

UWIP rocked also! :-)

(thanks for the software)

--
Jarl



2009/8/19 Tanner, Doug :
> Yeah, ITMasters Rocked!
>
> -Original Message-
> From: Action Request System discussion list(ARSList) 
> [mailto:arsl...@arslist.org] On Behalf Of Shyam Attavar
> Sent: Wednesday, August 19, 2009 3:30 PM
> To: arslist@ARSLIST.ORG
> Subject: Re: Support Renewal - developer Plus
>
> If you see value in using Remedy Developer Plus, then you may continue
> support.
>
> IMHO, the tool is very slow and does not perform all the things that I was
> used to, with IT Masters tool that RDP replaced. So, we did not continue
> support for RDP.
>
> My 2¢
> --
> Shyam
>
> "jham36"  wrote in message
> news:<01c95ad5-0506-4643-adfa-9dbf3c221...@d32g2000yqh.googlegroups.com>
> It still works with a 7.1 server.  I believe it becomes obsolete with
> 7.5
>
> James
>
> On Aug 19, 9:33 am, "Sokol, Brian"  wrote:
>> I just was sent our annual support renewal. One of the items is Remedy
>> Developer Plus. Is there any reason to pay for this product? Isn't this
>> product discontinued? Should I have it removed?
>>
>> Thanks,
>>
>> Brian Sokol
>> Manager, Desktop Services
>> Scholastic Inc.
>> 557 Broadway
>> NY, NY 10012
>> (212) 343-6494http://www.Scholastic.com
>>
>>
> 
> ___
>> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
>> Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
>
> --
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
>
>
> DISCLAIMER Important! This message is intended for the above named person(s) 
> only and is CONFIDENTIAL AND PROPRIETARY. If you are not the intended 
> recipient of this e-mail and have received it in error, please immediately 
> notify the sender by return email and then delete it from your mailbox. This 
> message may be protected by the attorney-client privilege and/or work product 
> doctrine.  Accessing, copying, disseminating or re-using any of the 
> information contained in this e-mail by anyone other than the intended 
> recipient is strictly prohibited. Finally, you should check this email and 
> any attachments for the presence of viruses, as the sender accepts no 
> liability for any damage caused by any virus transmitted by this email.  
> Thank you.
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
>

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Support Renewal - developer Plus

[Julie Sellers]

Absolutely!!!





From: "Tanner, Doug" 
To: arslist@ARSLIST.ORG
Sent: Wednesday, August 19, 2009 3:47:35 PM
Subject: Re: Support Renewal - developer Plus

Yeah, ITMasters Rocked!

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Shyam Attavar
Sent: Wednesday, August 19, 2009 3:30 PM
To: arslist@ARSLIST.ORG
Subject: Re: Support Renewal - developer Plus

If you see value in using Remedy Developer Plus, then you may continue
support.

IMHO, the tool is very slow and does not perform all the things that I was
used to, with IT Masters tool that RDP replaced. So, we did not continue
support for RDP.

My 2¢
--
Shyam

"jham36"  wrote in message
news:<01c95ad5-0506-4643-adfa-9dbf3c221...@d32g2000yqh.googlegroups.com>
It still works with a 7.1 server.  I believe it becomes obsolete with
7.5

James

On Aug 19, 9:33 am, "Sokol, Brian"  wrote:
> I just was sent our annual support renewal. One of the items is Remedy
> Developer Plus. Is there any reason to pay for this product? Isn't this
> product discontinued? Should I have it removed?
>
> Thanks,
>
> Brian Sokol
> Manager, Desktop Services
> Scholastic Inc.
> 557 Broadway
> NY, NY 10012
> (212) 343-6494http://www.Scholastic.com  
>
>

___
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

--

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"


DISCLAIMER Important! This message is intended for the above named person(s) 
only and is CONFIDENTIAL AND PROPRIETARY. If you are not the intended recipient 
of this e-mail and have received it in error, please immediately notify the 
sender by return email and then delete it from your mailbox. This message may 
be protected by the attorney-client privilege and/or work product doctrine.  
Accessing, copying, disseminating or re-using any of the information contained 
in this e-mail by anyone other than the intended recipient is strictly 
prohibited. Finally, you should check this email and any attachments for the 
presence of viruses, as the sender accepts no liability for any damage caused 
by any virus transmitted by this email.  Thank you.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"





___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: ARERR 9351 - Need Help

[bruce sisk]

**
Sorry...tried hard to include all the environment...We are running ITSM 7.0.3 Patch 8.-Original Message-
From: Joe DeSouza 
Sent: Aug 19, 2009 3:45 PM
To: arslist@ARSLIST.ORG
Subject: Re: ARERR 9351 - Need Help

**

Bruce,
 
What patch of the "ITSM Applications" (NOT ARS) are you guys on? I remember there used to be an issue with the ardbcQuery.dll with the early releases of ITSM 7 that used to result in that error.
 
I am not sure which patch resolved that problem. I'm pretty sure it was either Patch 3 or above though.
 
Joe



From: bruce sisk To: arslist@ARSLIST.ORGSent: Wednesday, August 19, 2009 2:20:08 PMSubject: ARERR 9351 - Need HelpHello,We are experiencing a problem with our mid-tier users in that they get a 5-10 minute screen lock whenever they try to access the Incident management Console by clicking the link on the Home page.  When the screen finally unlocks, they get the error:Unable to setup data connection, which is preventing the application from working correctly. (ARERR 9351)Environment:ARS 7.1 Patch 7Oracle 10 (remote server)Mid-tier 7.1 patch 7 (2 remote servers running Tomcat and IIS6 with a load balancer)Users are browsing with both IE 6 and 7.  We get the error in
 both.The problem is intermitent...not everyone is having the problem...those who have it don't have it all the time.Done so far:Have researched the issue on Remedy's KB...not much information.Have researched the issue on ARSList...several postings, but no solutions.Have opened an issue with Remedy support...we seem to just be sending them log files.Have tried to turn on client side logging for users having the issue...with logging turned on (setting through Preferences form), the issue completely goes away.Server side logging does not reveal any issues or errors.Have downloaded and installed Fiddler (a suggestion from the ARSList postings)...again, while logging through Fiddler, the issue completely goes away.Have downloaded and installed Firefox 3.5 the issue goes away.Some things we CAN'T do:IE is the "official" browser for this company, so Firefox is NOT an option.The Workflow
 logging window that opens with client side remedy logging is irritating people so that can't be considered a permanent solution.This is a plea for any insight or solutions from those who have had this issue in the past and what you did to resolve it.Thanks,Bruce SiskBFS EnterprisesPeoplePC OnlineA better way to Internethttp://www.peoplepc.com

  
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_


PeoplePC Online
A better way to Internet
http://www.peoplepc.com
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_

Re: ARERR 9351 - Need Help

[bruce sisk]

we are already chunking the table...50 records at a time.

-Original Message-
>From: William Rentfrow 
>Sent: Aug 19, 2009 3:24 PM
>To: arslist@ARSLIST.ORG
>Subject: Re: ARERR 9351 - Need Help
>
>I ran into something like this a while ago.
>
>If you can limit the results on the table field which refreshes on open.
>We were having performance problems due to issues on the Oracle side and
>a refresh of data in that console when it opened would produce exactly
>the same result.
>
>You might try turning on chunking or temporarily changing code so that
>it doesn't refresh when it opens. 
>
>
>William Rentfrow
>Principal Consultant, StrataCom Inc.
>wrentf...@stratacominc.com
>Corporate Website, www.stratacominc.com
>Blog, www.williamrentfrow.com
>715-410-8156 C
>
>-Original Message-
>From: Action Request System discussion list(ARSList)
>[mailto:arsl...@arslist.org] On Behalf Of bruce sisk
>Sent: Wednesday, August 19, 2009 1:20 PM
>To: arslist@ARSLIST.ORG
>Subject: ARERR 9351 - Need Help
>
>Hello,
>
>We are experiencing a problem with our mid-tier users in that they get a
>5-10 minute screen lock whenever they try to access the Incident
>management Console by clicking the link on the Home page.  When the
>screen finally unlocks, they get the error:
>
>Unable to setup data connection, which is preventing the application
>from working correctly. (ARERR 9351)
>
>Environment:
>
>ARS 7.1 Patch 7
>Oracle 10 (remote server)
>Mid-tier 7.1 patch 7 (2 remote servers running Tomcat and IIS6 with a
>load balancer) Users are browsing with both IE 6 and 7.  We get the
>error in both.
>
>The problem is intermitent...not everyone is having the problem...those
>who have it don't have it all the time.
>
>Done so far:
>
>Have researched the issue on Remedy's KB...not much information.
>Have researched the issue on ARSList...several postings, but no
>solutions.
>Have opened an issue with Remedy support...we seem to just be sending
>them log files.
>
>Have tried to turn on client side logging for users having the
>issue...with logging turned on (setting through Preferences form), the
>issue completely goes away.
>Server side logging does not reveal any issues or errors.
>Have downloaded and installed Fiddler (a suggestion from the ARSList
>postings)...again, while logging through Fiddler, the issue completely
>goes away.
>Have downloaded and installed Firefox 3.5 the issue goes away.
>
>Some things we CAN'T do:
>
>IE is the "official" browser for this company, so Firefox is NOT an
>option.
>The Workflow logging window that opens with client side remedy logging
>is irritating people so that can't be considered a permanent solution.
>
>This is a plea for any insight or solutions from those who have had this
>issue in the past and what you did to resolve it.
>
>Thanks,
>
>Bruce Sisk
>BFS Enterprises
>
>
>PeoplePC Online
>A better way to Internet
>http://www.peoplepc.com
>
>
>___
>UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum
>Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
>
>___
>UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"



PeoplePC Online
A better way to Internet
http://www.peoplepc.com

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Remedy Email Engine Configuration.

[Raj]

Hello all,
After following the documents to configure remedy email outbox, and
testing it , I got the following error in the email error log.

--
ERROR (90): Cannot establish a network connection to the AR System
server; ONC/RPC program not registered
DORRMKI0.dor.revenue.colorado.gov
at com.bmc.arsys.api.ProxyJRpcBase.a(Unknown Source)
at com.bmc.arsys.api.ProxyJRpcBase.getRpcClient(Unknown Source)
at com.bmc.arsys.api.ProxyJRpc.(Unknown Source)
at com.bmc.arsys.api.ProxyManager.createProxy(Unknown Source)
at com.bmc.arsys.api.DefaultProxyManager.getProxy(Unknown Source)
at com.bmc.arsys.api.ARServerUser.verifyUser(Unknown Source)
at com.bmc.arsys.emaildaemon.EmailUtil.createARServerUser
(EmailUtil.java:475)
at com.bmc.arsys.emaildaemon.LoggingModule.setUserInfo
(LoggingModule.java:753)
at com.bmc.arsys.emaildaemon.EmailDaemon.startLoggingModule
(EmailDaemon.java:122)
at com.bmc.arsys.emaildaemon.EmailDaemon.(EmailDaemon.java:93)
at com.bmc.arsys.emaildaemon.EmailDaemon.newInstance(EmailDaemon.java:
158)
at com.bmc.arsys.emaildaemon.EmailDaemon.startMonitor
(EmailDaemon.java:877)
at com.bmc.arsys.emaildaemon.EmailDaemon.executeComandLine
(EmailDaemon.java:595)
at com.bmc.arsys.emaildaemon.EmailDaemon.main(EmailDaemon.java:316)
ERROR (90): Cannot establish a network connection to the AR System
server; ONC/RPC program not registered
DORRMKI0.dor.revenue.colorado.gov
at com.bmc.arsys.api.ProxyJRpcBase.a(Unknown Source)
at com.bmc.arsys.api.ProxyJRpcBase.getRpcClient(Unknown Source)
at com.bmc.arsys.api.ProxyJRpc.(Unknown Source)
at com.bmc.arsys.api.ProxyManager.createProxy(Unknown Source)
at com.bmc.arsys.api.DefaultProxyManager.getProxy(Unknown Source)
at com.bmc.arsys.api.ARServerUser.verifyUser(Unknown Source)
at com.bmc.arsys.emaildaemon.EmailUtil.createARServerUser
(EmailUtil.java:475)
at com.bmc.arsys.emaildaemon.EmailDaemon.setUserInfo(EmailDaemon.java:
922)
at com.bmc.arsys.emaildaemon.EmailDaemon.executeComandLine
(EmailDaemon.java:606)
at com.bmc.arsys.emaildaemon.EmailDaemon.main(EmailDaemon.java:316)
Exception in thread "Email Daemon" java.lang.NullPointerException
at com.bmc.arsys.emaildaemon.LoggingModule.doWork(LoggingModule.java:
98)
at com.bmc.arsys.emaildaemon.ThreadBase.run(ThreadBase.java:293)
at java.lang.Thread.run(Unknown Source)

--

Could anybody tell, what is the cause of this problem ?

Please note: I have only configured Remedy Outbox and we are using
SMTP for that. I followed the documents accurately but don't know
where I am doing wrong ?

Please advise.

Thanks,
Raj

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Remedy Email Engine Configuration.

[Lyle Taylor]

It sounds like your email engine service may not know what server and/or port 
to connect to.  Take a look at the EmailDaemon.properties file under your 
e-mail engine's installation directory and validate the value of the following 
line:

com.bmc.arsys.emaildaemon.servers=
com.bmc.arsys.emaildaemon.chqpvuw2203.TCP=

If you configured your server to use the port mapper, you may be able to not 
include the second line, or set it to 0 (zero).

Lyle

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Raj
Sent: Wednesday, August 19, 2009 5:57 PM
To: arslist@ARSLIST.ORG
Subject: Remedy Email Engine Configuration.

Hello all,
After following the documents to configure remedy email outbox, and
testing it , I got the following error in the email error log.

--
ERROR (90): Cannot establish a network connection to the AR System
server; ONC/RPC program not registered
DORRMKI0.dor.revenue.colorado.gov
at com.bmc.arsys.api.ProxyJRpcBase.a(Unknown Source)
at com.bmc.arsys.api.ProxyJRpcBase.getRpcClient(Unknown Source)
at com.bmc.arsys.api.ProxyJRpc.(Unknown Source)
at com.bmc.arsys.api.ProxyManager.createProxy(Unknown Source)
at com.bmc.arsys.api.DefaultProxyManager.getProxy(Unknown Source)
at com.bmc.arsys.api.ARServerUser.verifyUser(Unknown Source)
at com.bmc.arsys.emaildaemon.EmailUtil.createARServerUser
(EmailUtil.java:475)
at com.bmc.arsys.emaildaemon.LoggingModule.setUserInfo
(LoggingModule.java:753)
at com.bmc.arsys.emaildaemon.EmailDaemon.startLoggingModule
(EmailDaemon.java:122)
at com.bmc.arsys.emaildaemon.EmailDaemon.(EmailDaemon.java:93)
at com.bmc.arsys.emaildaemon.EmailDaemon.newInstance(EmailDaemon.java:
158)
at com.bmc.arsys.emaildaemon.EmailDaemon.startMonitor
(EmailDaemon.java:877)
at com.bmc.arsys.emaildaemon.EmailDaemon.executeComandLine
(EmailDaemon.java:595)
at com.bmc.arsys.emaildaemon.EmailDaemon.main(EmailDaemon.java:316)
ERROR (90): Cannot establish a network connection to the AR System
server; ONC/RPC program not registered
DORRMKI0.dor.revenue.colorado.gov
at com.bmc.arsys.api.ProxyJRpcBase.a(Unknown Source)
at com.bmc.arsys.api.ProxyJRpcBase.getRpcClient(Unknown Source)
at com.bmc.arsys.api.ProxyJRpc.(Unknown Source)
at com.bmc.arsys.api.ProxyManager.createProxy(Unknown Source)
at com.bmc.arsys.api.DefaultProxyManager.getProxy(Unknown Source)
at com.bmc.arsys.api.ARServerUser.verifyUser(Unknown Source)
at com.bmc.arsys.emaildaemon.EmailUtil.createARServerUser
(EmailUtil.java:475)
at com.bmc.arsys.emaildaemon.EmailDaemon.setUserInfo(EmailDaemon.java:
922)
at com.bmc.arsys.emaildaemon.EmailDaemon.executeComandLine
(EmailDaemon.java:606)
at com.bmc.arsys.emaildaemon.EmailDaemon.main(EmailDaemon.java:316)
Exception in thread "Email Daemon" java.lang.NullPointerException
at com.bmc.arsys.emaildaemon.LoggingModule.doWork(LoggingModule.java:
98)
at com.bmc.arsys.emaildaemon.ThreadBase.run(ThreadBase.java:293)
at java.lang.Thread.run(Unknown Source)

--

Could anybody tell, what is the cause of this problem ?

Please note: I have only configured Remedy Outbox and we are using
SMTP for that. I followed the documents accurately but don't know
where I am doing wrong ?

Please advise.

Thanks,
Raj

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"


 NOTICE: This email message is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information. Any unauthorized 
review, use, disclosure or distribution is prohibited. If you are not the 
intended recipient, please contact the sender by reply email and destroy all 
copies of the original message.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"

Re: Workflow Documentation 7.1

[LJ Longwing]

Kathy,
Honestly, I've never worked with the ITSM suite nor run ARInside against it,
but am one of the developers keeping the project alive.  The way ARInside
works is it loads all of the objects into memory, then cross references them
to provide the output.  I know there are LOTS of problems with doing things
with the ITSM code base.  One thing I can recommend trying however is to
utilize the 'exclude list' functionality.  The way this works is you create
a packing list on your server that contains a list of everything you don't
want it to document, that workflow is then excluded from the documentation
output, and may make it possible to document 'part' of the system with less
memory requirements.  Please go out to arinside.com and open a ticket for
the problem if you would like.  Giving as much detail as possible so we can
try to pinpoint a solution.

  _  

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Kathy Morris
Sent: Wednesday, August 19, 2009 1:34 PM
To: arslist@ARSLIST.ORG
Subject: Re: Workflow Documentation 7.1


** 
Do you need to more than 2 GIG of RAM to run this product - because the
arinside executes, then freezes after about 1 hour, and then I get an
exception error.  Is this common with this tool.  The exception error comes
before the forms are generated in the HTML format.  Active
links/filters/applications are displayed
 
In a message dated 8/19/2009 3:06:04 P.M. Eastern Daylight Time,
jennifer.me...@its.nc.gov writes:

** 

ARInside: www.arinside.org  

 

 

Jennifer Meyer


  _  


From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Kathy Morris
Sent: Wednesday, August 19, 2009 2:11 PM
To: arslist@ARSLIST.ORG
Subject: Workflow Documentation 7.1

 

Hi All,

 

I am trying to run a tool to document our workflow on our system (AR 7.1,
ITSM) on Windows.  I had been using AR system, but the AL are displaying,
but the forms are not displaying - is there another free tool I can use to
document the workflow?

 


  _  

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"_

  _  

E-mail correspondence to and from this address may be subject to the North
Carolina Public Records Law and may be disclosed to third parties by an
authorized state official.
_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"_


  _  

_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"_ 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"