Have I misunderstood something? [Vendor forms and DataType.Attachment]

[Jonas Stumph Stevnsvig]

HI listers,

I have this nagging problem. I just read through this plugin one of my 
colleagues has writtenm since it keeps inserting thousand seperators in integer 
values, which makes it impossible to use the value for a further lookup.
eg 861002000 becomes 861.002.000 - now to the fun stuff:

The field in the database is an integer.
The field is regarded as a decimal in remedy.
The API only formats fields of type Datatype.ATTACHMENT as %s.%s.%s

and finally, my questions:

1. I thought Remedy disallowed attachemnt fields in vendor forms?
2. why is the integer interpreted as an attachment?
3. how can remedy justify allowing multiple decimal points in a decimal field?


(ARS 7.5 patch 2, W2k3, MSSQL, vendor form connects to DB2 DB)

I hope someone can help me spread some light on this subject.


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

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

SV: Have I misunderstood something? [Vendor forms and DataType.Attachment]

[Jonas Stumph Stevnsvig]

Hi again

It turns out that it was a regional setting in windows, which was in turn 
formatting the number in the field with the set digit separator...




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




Fra: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] På vegne af Jonas Stumph Stevnsvig
Sendt: 13. august 2009 10:00
Til: arslist@ARSLIST.ORG
Emne: Have I misunderstood something? [Vendor forms and DataType.Attachment]

**
HI listers,

I have this nagging problem. I just read through this plugin one of my 
colleagues has writtenm since it keeps inserting thousand seperators in integer 
values, which makes it impossible to use the value for a further lookup.
eg 861002000 becomes 861.002.000 - now to the fun stuff:

The field in the database is an integer.
The field is regarded as a decimal in remedy.
The API only formats fields of type Datatype.ATTACHMENT as %s.%s.%s

and finally, my questions:

1. I thought Remedy disallowed attachemnt fields in vendor forms?
2. why is the integer interpreted as an attachment?
3. how can remedy justify allowing multiple decimal points in a decimal field?


(ARS 7.5 patch 2, W2k3, MSSQL, vendor form connects to DB2 DB)

I hope someone can help me spread some light on this subject.


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

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

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

[Jonas Stumph Stevnsvig]

Hi listers,

I really hope one of you has a solution for me here.

We have developed an SRDBC 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
  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
  


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 14:02:10,755 INFO  [main] com.bmc.arsys.pluginsvr.ARPluginServerMain 
(?:?) - AR System Plugin Server Version 7.5.00 Patch 002 200906100308
2009-08-14 14:02:11,083 INFO  [pool-2-thread-1] 
com.bmc.arsys.pluginsvr.plugins.g (?:?) - Thread 11 successfully created an 
instance of CD99
2009-08-14 14:02:11,098 INFO  [pool-2-thread-1] 
com.bmc.arsys.pluginsvr.plugins.g (?:?) - Attempting to Create an instance of 
the plugin OD99
2009-08-14 14:02:11,098 INFO  [pool-2-thread-1] 
com.bmc.arsys.pluginsvr.plugins.ARPluginContext (?:?) - initialize()
No suitable driver found for jdbc:db2:OD992009-08-14 14:02:11,114 INFO  
[pool-2-thread-1] com.bmc.arsys.pluginsvr.plugins.g (?:?) - Thread 11 
successfully created an instance of OD99
2009-08-14 14:02:11,114 INFO  [pool-2-thread-1] com.bmc.arsys.pluginsvr.d.b 
(?:?) - Done iniPlugins for thread: 11
2009-08-14 14:02:11,114 INFO  [pool-2-thread-1] com.bmc.arsys.pluginsvr.d.b 
(?:?) - Java plug-in server has initialized plug-ins for all 1 core threads. 
The server is ready to receive RPC calls.
Java plug-in server has initialized plug-ins for all 1 core threads. The server 
is ready to receive RPC calls.

I have a feeling that it has something to do with a limitation of the driver, 
but I am not sure - any bits and bids are most welcome



Cheers



Jonas Stevnsvig



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

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


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 14:02:10,755 INFO  [main] com.bmc.arsys.pluginsvr.ARPluginServerMain 
(?:?) - AR System Plugin Server Version 7.5.00 Patch 002 200906100308
2009-08-14 14:02:11,083 INFO  [pool-2-thread-1] 
com.bmc.arsys.pluginsvr.plugins.g (?:?) - Thread 11 successfully created an 
instance of CD99
2009-08-14 14:02:11,098 INFO  [pool-2-thread-1] 
com.bmc.arsys.pluginsvr.plugins.g (?:?) - Attempting to Create an instance of 
the plugin OD99
2009-08-14 14:02:11,098 INFO  [pool-2-thread-1] 
com.bmc.arsys.pluginsvr.plugins.ARPluginContext (?:?) - initialize()
No suitable driver found for jdbc:db2:OD992009-08-14 14:02:11,114 INFO  
[pool-2-thread-1] com.bmc.arsys.pluginsvr.plugins.g (?:?) - Thread 11 
successfully created an instance of OD99
2009-08-14 14:02:11,114 INFO  [pool-2-thread-1] com.bmc.arsys.pluginsvr.d.b 
(?:?) - Done iniPlugins for thread: 11
2009-08-14 14:02:11,114 INFO  [pool-2-thread-1] com.bmc.arsys.pluginsvr.d.b 
(?:?) - Java plug-in server has initialized plug-ins for all 1 core threads. 
The server is ready to receive RPC calls.
Java plug-in server has initialized plug-ins for all 1 core threads. The server 
is ready to receive RPC calls.

I have a feeling that it has something to do with a limitation of the driver, 
but I am not sure - any bits and bids are most welcome



Cheers



Jonas Stevnsvig



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

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 con

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

Field limits and date only fields

[Jonas Stumph Stevnsvig]

Hi guys, (is it going to be "Jarl to the rescue" again :-D)

I have a weird bahviour in a vendor form:

I have a Date field, which fails when a date is pushed to it by an active link. 
The value is taken from a Date/Time field and run through the 
DATE($mydatetimefield$) function.

the error:

"ARERR [306] Value does not fall within the limits specified for the field :  
(0 - 0) : 536870922"


from the log:
" (536870922) = 24. august 2009"

as far as I can tell the date field limit is defined by the 
DateOnlyFieldLimit(); method in Java, and I can't see any restrictions in the 
database section of the field properties - so i guess the 0 - 0 is a wild goose 
chase.

I've had some other bothers with regional settings - is that whats bothering me 
here to? shouldn't the value be "24-08-2009" and in that case, how to I get my 
active link to format the date properly?


thanks in advance,
ARS 7...@w2k3


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

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

SV: Field limits and date only fields

[Jonas Stumph Stevnsvig]

Hi Frederick, and rick

Same deal - no luck.

Created a date field on the "sending" form, made a set fields to set it to the 
date, and then pushed that value to the vendor form - exaclty the same error. 
Any other suggestions?

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 Grooms, Frederick W
Sendt: 20. august 2009 16:59
Til: arslist@ARSLIST.ORG
Emne: Re: Field limits and date only fields

In your Active Link set a Display Only Date field equal to the result of the 
DATE function and push that Display Only field to the vendor form (So you are 
pushing a Date Only field to a Date Only field).  

Fred

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Rick Cook
Sent: Thursday, August 20, 2009 8:58 AM
To: arslist@ARSLIST.ORG
Subject: Re: Field limits and date only fields


Jonas,

Active links pull Date/Time formats from the Regional settings of the client. 
You might start there. 
Rick

-Original Message-----
From: Jonas Stumph Stevnsvig
Date: Thu, 20 Aug 2009 15:46:57 +0200
To: 
Subject: Field limits and date only fields Hi guys, (is it going to be "Jarl to 
the rescue" again :-D)
 
I have a weird bahviour in a vendor form:
 
I have a Date field, which fails when a date is pushed to it by an active link. 
The value is taken from a Date/Time field and run through the 
DATE($mydatetimefield$) function.
 
the error:
 
"ARERR [306] Value does not fall within the limits specified for the field :  
(0 - 0) : 536870922"
 
from the log:
" (536870922) = 24. august 2009"
 
as far as I can tell the date field limit is defined by the 
DateOnlyFieldLimit(); method in Java, and I can't see any restrictions in the 
database section of the field properties - so i guess the 0 - 0 is a wild goose 
chase.
 
I've had some other bothers with regional settings - is that whats bothering me 
here to? shouldn't the value be "24-08-2009" and in that case, how to I get my 
active link to format the date properly?
 
 
thanks in advance,
ARS 7...@w2k3

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 

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

SV: Field limits and date only fields

[Jonas Stumph Stevnsvig]

Hi again

Same behaviour, both with setting the value in an integer field first, and in a 
filter. The think that's puzzling me is that the error doesn't seem to come 
from the API, but from the AR system itself.



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 Jarl Grøneng
Sendt: 22. august 2009 20:12
Til: arslist@ARSLIST.ORG
Emne: Re: Field limits and date only fields

Hi,

Do you get a diffrent behviour if you do the same operation in a filter?

--
Jarl



2009/8/20 Jonas Stumph Stevnsvig :
> **
> Hi guys, (is it going to be "Jarl to the rescue" again :-D)
>
> I have a weird bahviour in a vendor form:
>
> I have a Date field, which fails when a date is pushed to it by an 
> active link. The value is taken from a Date/Time field and run through 
> the
> DATE($mydatetimefield$) function.
>
> the error:
>
> "ARERR [306] Value does not fall within the limits specified for the 
> field
> :  (0 - 0) : 536870922"
>
>
> from the log:
> " (536870922) = 24. august 2009"
>
> as far as I can tell the date field limit is defined by the 
> DateOnlyFieldLimit(); method in Java, and I can't see any restrictions 
> in the database section of the field properties - so i guess the 0 - 0 
> is a wild goose chase.
>
> I've had some other bothers with regional settings - is that whats 
> bothering me here to? shouldn't the value be "24-08-2009" and in that 
> case, how to I get my active link to format the date properly?
>
>
> thanks in advance,
> ARS 7...@w2k3
>
> 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
>
> _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"

SV: Field limits and date only fields

[Jonas Stumph Stevnsvig]

Hi

The DB2 field is a "Date", the Remedy Vendor form is marked as "Date", and 
there is a conversion method in the plugin we developed - but it never gets 
that far - it's the AR server coming with the error, not the plugin or the 
database. I think I'll try setting a "0" in the field, since it tells me that 
the limit is 0-0, and see what happens.


/Jonas

-Oprindelig meddelelse-
Fra: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] På vegne af Jarl Grøneng
Sendt: 25. august 2009 17:40
Til: arslist@ARSLIST.ORG
Emne: Re: Field limits and date only fields

Hi,

Have you tried to "convert" the date to the server date format?

The fieldtype in the plugin, it that a date or date-time field?

--
Jarl

2009/8/25 Jonas Stumph Stevnsvig :
> Hi again
>
> Same behaviour, both with setting the value in an integer field first, and in 
> a filter. The think that's puzzling me is that the error doesn't seem to come 
> from the API, but from the AR system itself.
>
>
>
> 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 Jarl Grøneng
> Sendt: 22. august 2009 20:12
> Til: arslist@ARSLIST.ORG
> Emne: Re: Field limits and date only fields
>
> Hi,
>
> Do you get a diffrent behviour if you do the same operation in a filter?
>
> --
> Jarl
>
>
>
> 2009/8/20 Jonas Stumph Stevnsvig :
>> **
>> Hi guys, (is it going to be "Jarl to the rescue" again :-D)
>>
>> I have a weird bahviour in a vendor form:
>>
>> I have a Date field, which fails when a date is pushed to it by an 
>> active link. The value is taken from a Date/Time field and run 
>> through the
>> DATE($mydatetimefield$) function.
>>
>> the error:
>>
>> "ARERR [306] Value does not fall within the limits specified for the 
>> field
>> :  (0 - 0) : 536870922"
>>
>>
>> from the log:
>> " (536870922) = 24. august 2009"
>>
>> as far as I can tell the date field limit is defined by the 
>> DateOnlyFieldLimit(); method in Java, and I can't see any 
>> restrictions in the database section of the field properties - so i 
>> guess the 0 - 0 is a wild goose chase.
>>
>> I've had some other bothers with regional settings - is that whats 
>> bothering me here to? shouldn't the value be "24-08-2009" and in that 
>> case, how to I get my active link to format the date properly?
>>
>>
>> thanks in advance,
>> ARS 7...@w2k3
>>
>> 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
>>
>> _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"
>

___
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: Field limits and date only fields

[Jonas Stumph Stevnsvig]

Hi again

It did the trick - I can now insert dates, and I am extremely puzzled as to why 
the Integer, real, etc fields have their limits displayed in the editor, and 
the date field does not - it would have saved me from a lot of trouble.





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: 26. august 2009 09:40
Til: arslist@ARSLIST.ORG
Emne: SV: Field limits and date only fields

Hi

The DB2 field is a "Date", the Remedy Vendor form is marked as "Date", and 
there is a conversion method in the plugin we developed - but it never gets 
that far - it's the AR server coming with the error, not the plugin or the 
database. I think I'll try setting a "0" in the field, since it tells me that 
the limit is 0-0, and see what happens.


/Jonas

-Oprindelig meddelelse-
Fra: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] På vegne af Jarl Grøneng
Sendt: 25. august 2009 17:40
Til: arslist@ARSLIST.ORG
Emne: Re: Field limits and date only fields

Hi,

Have you tried to "convert" the date to the server date format?

The fieldtype in the plugin, it that a date or date-time field?

--
Jarl

2009/8/25 Jonas Stumph Stevnsvig :
> Hi again
>
> Same behaviour, both with setting the value in an integer field first, and in 
> a filter. The think that's puzzling me is that the error doesn't seem to come 
> from the API, but from the AR system itself.
>
>
>
> 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 Jarl Grøneng
> Sendt: 22. august 2009 20:12
> Til: arslist@ARSLIST.ORG
> Emne: Re: Field limits and date only fields
>
> Hi,
>
> Do you get a diffrent behviour if you do the same operation in a filter?
>
> --
> Jarl
>
>
>
> 2009/8/20 Jonas Stumph Stevnsvig :
>> **
>> Hi guys, (is it going to be "Jarl to the rescue" again :-D)
>>
>> I have a weird bahviour in a vendor form:
>>
>> I have a Date field, which fails when a date is pushed to it by an 
>> active link. The value is taken from a Date/Time field and run 
>> through the
>> DATE($mydatetimefield$) function.
>>
>> the error:
>>
>> "ARERR [306] Value does not fall within the limits specified for the 
>> field
>> :  (0 - 0) : 536870922"
>>
>>
>> from the log:
>> " (536870922) = 24. august 2009"
>>
>> as far as I can tell the date field limit is defined by the 
>> DateOnlyFieldLimit(); method in Java, and I can't see any 
>> restrictions in the database section of the field properties - so i 
>> guess the 0 - 0 is a wild goose chase.
>>
>> I've had some other bothers with regional settings - is that whats 
>> bothering me here to? shouldn't the value be "24-08-2009" and in that 
>> case, how to I get my active link to format the date properly?
>>
>>
>> thanks in advance,
>> ARS 7...@w2k3
>>
>> 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
>>
>> _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"
>

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

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

Hi guys

I have experimented with multiple plugin servers, starting with two to start 
off with.

I have copied the contents of the %ARSYSTEMHOME%\pluginsvr directory to 
%ARSYSTEMHOME%\pluginsvr2 and set up the second server to listen on port 9998, 
then I modified the armonitor.cfg so it contained the following two lines:


"C:\Program Files\Java\jdk1.6.0_12\jre\bin\java" -Xmx512m -classpath 
"C:\Program Files\BMC Software\ARSystem\pluginsvr;C:\Program Files\BMC 
Software\ARSystem\pluginsvr\arpluginsvr75.jar" 
com.bmc.arsys.pluginsvr.ARPluginServerMain -x b00011101496 -i "C:\Program 
Files\BMC Software\ARSystem" -m

"C:\Program Files\Java\jdk1.6.0_12\jre\bin\java" -Xmx512m -classpath 
"C:\Program Files\BMC Software\ARSystem\pluginsvr2;C:\Program Files\BMC 
Software\ARSystem\pluginsvr2\arpluginsvr75.jar" 
com.bmc.arsys.pluginsvr.ARPluginServerMain -x b00011101496 -i "C:\Program 
Files\BMC Software\ARSystem" -m

Also making sure that the jar file containing our ARDBC plugin is in a 
subdirectory to the pluginsvr/pluginsvr2 dir.

The peculiar thing is, that the armonitor never starts either of the servers. I 
went further with my experiments, and not even the original pluginsvr will 
start via armonitor now.

I checked armonitor.log and found several lines like: 
Wed Sep 02 19:08:44 2009 No such file or directory : "C:\Program 
Files\Java\jdk1.6.0_12\jre\bin\java" -Xmx512m -classpath "C:\Program Files\BMC 
Software\ARSystem\pluginsvr;C:\Program Files\BMC 
Software\ARSystem\pluginsvr\arpluginsvr75.jar" 
com.bmc.arsys.pluginsvr.ARPluginServerMa


I can run both plugins manually at the same time, but when i try to run either 
of them through armonitor they fail. In an attempt to get a clean log under 
100.000 kb i backed up and deleted armonitor.log and now it simply doesn't log 
any more


Any suggestions are very welcome!




best 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: 19. august 2009 11:22
Til: arslist@ARSLIST.ORG
Emne: Re: Java ARDBC plugin failing with multiple instances "No suitable driver 
found for "

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/javaplug
> ins/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

SV: DATE function - Server Date Format

[Jonas Stumph Stevnsvig]

Hi Kali

I presume that you are using the WUT, I have experienced similar oddities with 
it, regarding number formatting.
Have a look at your regional settings on the client machine, that is probably 
the culprit.




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




Fra: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] På vegne af Kali Obsum
Sendt: 2. september 2009 08:29
Til: arslist@ARSLIST.ORG
Emne: DATE function - Server Date Format

**
Hi,

We have a FILTER action that uses the DATE function to push values from a 
character field into a date/time field.
ex: Field1 = character field, Field2 = date/time field
Field2=DATE($Field1$)

The string value of Field1 is in format: MM/DD/.
Value of Field2 becomes 01/01/1970 10:00:01 AM

Does this have anything to do with the Server Date Format of Remedy? If yes, 
how do I check what's the server date format being used?

Also, the behavior is different in production env and in UAT env. In UAT, even 
if the format of Field1 is MM/DD/, the filter is able to convert it 
properly to the correct date. I'm not sure but I think the server date formats 
are the same in prod and UAT. If this is the case, then there are other factors 
that are causing the date to not be converted properly?

Regards,
Kali


NOTICE

The information contained in this email is confidential. If you are not the 
intended recipient, you must not disclose or use the information in this email 
in any way. If you received it in error, please tell us immediately by return 
email and delete the document. We do not guarantee the integrity of any e-mails 
or attached files and are not responsible for any changes made to them by any 
other person.



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

Application Dispatcher configuration

[Jonas Stumph Stevnsvig]

Hi listers!

I spent the majority of yesterday trying to figure out why the approval server. 
didn't receive any requests.

It turned out that the problem was the Application Dispatcher (arsvcdsp.exe) 
was not being started properly.

The error we encountered was that it was looking for the ar.lck. 
file in "c:\arservdb" instead of in the installation directory "C:\Program 
Files\BMC Software\ARSystem\Arserver\Db".

According to the configuration guide, the path "c:\arservdb" is a standard 
path, which is used if an alternate is not provided, which is reasonable. It 
does not make sense however, that all our other servers (development, test, 4x 
production) have similar configuration files, and they all run perfectly with 
the lockfiles in "C:\Program Files\BMC Software\ARSystem\Arserver\Db".

Have any of you encountered similar problems?



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

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

Hi again

Just wanted to close this subject off.

I tried it off on another server and it worked beautifully.

Thanks for the help!


Best 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 Jonas Stumph Stevnsvig
Sendt: 2. september 2009 19:46
Til: arslist@ARSLIST.ORG
Emne: SV: Java ARDBC plugin failing with multiple instances "No suitable driver 
found for "

Hi guys

I have experimented with multiple plugin servers, starting with two to start 
off with.

I have copied the contents of the %ARSYSTEMHOME%\pluginsvr directory to 
%ARSYSTEMHOME%\pluginsvr2 and set up the second server to listen on port 9998, 
then I modified the armonitor.cfg so it contained the following two lines:


"C:\Program Files\Java\jdk1.6.0_12\jre\bin\java" -Xmx512m -classpath 
"C:\Program Files\BMC Software\ARSystem\pluginsvr;C:\Program Files\BMC 
Software\ARSystem\pluginsvr\arpluginsvr75.jar" 
com.bmc.arsys.pluginsvr.ARPluginServerMain -x b00011101496 -i "C:\Program 
Files\BMC Software\ARSystem" -m

"C:\Program Files\Java\jdk1.6.0_12\jre\bin\java" -Xmx512m -classpath 
"C:\Program Files\BMC Software\ARSystem\pluginsvr2;C:\Program Files\BMC 
Software\ARSystem\pluginsvr2\arpluginsvr75.jar" 
com.bmc.arsys.pluginsvr.ARPluginServerMain -x b00011101496 -i "C:\Program 
Files\BMC Software\ARSystem" -m

Also making sure that the jar file containing our ARDBC plugin is in a 
subdirectory to the pluginsvr/pluginsvr2 dir.

The peculiar thing is, that the armonitor never starts either of the servers. I 
went further with my experiments, and not even the original pluginsvr will 
start via armonitor now.

I checked armonitor.log and found several lines like:
Wed Sep 02 19:08:44 2009 No such file or directory : "C:\Program 
Files\Java\jdk1.6.0_12\jre\bin\java" -Xmx512m -classpath "C:\Program Files\BMC 
Software\ARSystem\pluginsvr;C:\Program Files\BMC 
Software\ARSystem\pluginsvr\arpluginsvr75.jar" 
com.bmc.arsys.pluginsvr.ARPluginServerMa


I can run both plugins manually at the same time, but when i try to run either 
of them through armonitor they fail. In an attempt to get a clean log under 
100.000 kb i backed up and deleted armonitor.log and now it simply doesn't log 
any more


Any suggestions are very welcome!




best 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: 19. august 2009 11:22
Til: arslist@ARSLIST.ORG
Emne: Re: Java ARDBC plugin failing with multiple instances "No suitable driver 
found for "

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/javaplug
> ins/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å 

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

[Jonas Stumph Stevnsvig]

Hi Jarl,

The solution was to create an additional pluginsvr folder with duplicates xml 
configuration files, add an extra line in armonitor.cfg to start the additional 
plugin server, and restart the ar server process.

Here are my two lines in armonitor.cfg:

"C:\Program Files\Java\jdk1.6.0_12\jre\bin\java" -Xmx512m -classpath 
"C:\Program Files\BMC Software\ARSystem\pluginsvr;C:\Program Files\BMC 
Software\ARSystem\pluginsvr\arpluginsvr75.jar" 
com.bmc.arsys.pluginsvr.ARPluginServerMain -x b00011101496 -i "C:\Program 
Files\BMC Software\ARSystem" -m

"C:\Program Files\Java\jdk1.6.0_12\jre\bin\java" -Xmx512m -classpath 
"C:\Program Files\BMC Software\ARSystem\pluginsvr2;C:\Program Files\BMC 
Software\ARSystem\pluginsvr2\arpluginsvr75.jar" 
com.bmc.arsys.pluginsvr.ARPluginServerMain -x b00011101496 -i "C:\Program 
Files\BMC Software\ARSystem" -m


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: 8. september 2009 08:51
Til: arslist@ARSLIST.ORG
Emne: Re: Java ARDBC plugin failing with multiple instances "No suitable driver 
found for "

And the solution was?

Regards,
Jarl


2009/9/6 Jonas Stumph Stevnsvig :
> Hi again
>
> Just wanted to close this subject off.
>
> I tried it off on another server and it worked beautifully.
>
> Thanks for the help!
>
>
> Best 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 Jonas Stumph Stevnsvig
> Sendt: 2. september 2009 19:46
> Til: arslist@ARSLIST.ORG
> Emne: SV: Java ARDBC plugin failing with multiple instances "No suitable 
> driver found for "
>
> Hi guys
>
> I have experimented with multiple plugin servers, starting with two to start 
> off with.
>
> I have copied the contents of the %ARSYSTEMHOME%\pluginsvr directory to 
> %ARSYSTEMHOME%\pluginsvr2 and set up the second server to listen on port 
> 9998, then I modified the armonitor.cfg so it contained the following two 
> lines:
>
>
> "C:\Program Files\Java\jdk1.6.0_12\jre\bin\java" -Xmx512m -classpath
> "C:\Program Files\BMC Software\ARSystem\pluginsvr;C:\Program Files\BMC
> Software\ARSystem\pluginsvr\arpluginsvr75.jar"
> com.bmc.arsys.pluginsvr.ARPluginServerMain -x b00011101496 -i
> "C:\Program Files\BMC Software\ARSystem" -m
>
> "C:\Program Files\Java\jdk1.6.0_12\jre\bin\java" -Xmx512m -classpath
> "C:\Program Files\BMC Software\ARSystem\pluginsvr2;C:\Program
> Files\BMC Software\ARSystem\pluginsvr2\arpluginsvr75.jar"
> com.bmc.arsys.pluginsvr.ARPluginServerMain -x b00011101496 -i
> "C:\Program Files\BMC Software\ARSystem" -m
>
> Also making sure that the jar file containing our ARDBC plugin is in a 
> subdirectory to the pluginsvr/pluginsvr2 dir.
>
> The peculiar thing is, that the armonitor never starts either of the servers. 
> I went further with my experiments, and not even the original pluginsvr will 
> start via armonitor now.
>
> I checked armonitor.log and found several lines like:
> Wed Sep 02 19:08:44 2009 No such file or directory : "C:\Program
> Files\Java\jdk1.6.0_12\jre\bin\java" -Xmx512m -classpath "C:\Program
> Files\BMC Software\ARSystem\pluginsvr;C:\Program Files\BMC
> Software\ARSystem\pluginsvr\arpluginsvr75.jar"
> com.bmc.arsys.pluginsvr.ARPluginServerMa
>
>
> I can run both plugins manually at the same time, but when i try to
> run either of them through armonitor they fail. In an attempt to get a
> clean log under 100.000 kb i backed up and deleted armonitor.log and
> now it simply doesn't log any more
>
>
> Any suggestions are very welcome!
>
>
>
>
> best 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: 19. august 2009 11:22
> Til: arslist@ARSLIST.ORG
> Emne: Re: Java ARDBC plugin failing with multiple instances "No suitable 
> driver found for "
>
> Static init method is something lik

Approval server ARAPPERR 4605 & 4611

[Jonas Stumph Stevnsvig]

Hi listers,

I sincerely hope that there are some insomniacs out there with some knowledge 
of the approval server's innard, because I am well and truly STUCK.

We have migrated an application from a 6.3 environment with approval server 6.X 
to a 7.5 server with approval server 7.5, and everything seems to be fine and 
dandy on the surface. Simple approvals pass without incident, but if we use 
certain flow rules, we get an ARAPPERR 4605, after executing a "Det-Cancelled" 
command


"Sig-xxx command requires process to match details if process is specified.
The process specified in the issued command (sig-approved, sig-rejected, 
sig-cancelled, sig-reassign, sig-notify) does not match the process specified 
in the details record of this pending approval request."

which - as far as I can gather, means that there is a missing link somewhere 
between the AP:detail, AP:Signature and our request form.

I have gone over the approval server documentation several times, and verified 
that all required fields are present on the three way and two way join forms, 
and that all permissions and IDs are set correctly.

As an attempt to verify my work, i ran the arjoinfix.exe command and got 
another ARAPPERR, #4611:

No join is defined between the form and the approval detail form (ARAPPERR 4611)
   LAK:Bestilling-Detail-Signature


No join is defined between the form and the approval detail form.
Before you use the Approval Server with your application, you must join your 
application form to the AP:Detail form.
Instructions are in the Approval Server Guide.

if any of you have a hint or two for me - please feel free to reply.

thanks in advance



regards,



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

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

SV: Approval server ARAPPERR 4605 & 4611

[Jonas Stumph Stevnsvig]

Hi again

I Just tried the command on the AP-sample three way join form, and got the same 
result...

C:\Program Files\BMC Software\ARSystem\approval\bin>arjoinfix -portnum 2020

Action Request System(R) Approval Server   Version 7.5.00 Patch 002 200906100308
(c) Copyright 1999-2009 BMC Software, Inc.


Enter the name of the form: AP-Sample:Lunch-Detail-Signatu


--Menu--

1. Update Join Criteria

2. Add New Fields In 3-Way Join Form

Default: Quit


Make your choice & Press : 2

No join is defined between the form and the approval detail form (ARAPPERR 4611)
   AP-Sample:Lunch-Detail-Signatu

Press  to exit the program
C:\Program Files\BMC Software\ARSystem\approval\bin>


Now the questions are:
- is this an error in arjoinfix?
- is this an error in the sample APP (and my app)?
- is this an error in the AP:Detail form?

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


Fra: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] På vegne af Jonas Stumph Stevnsvig
Sendt: 10. september 2009 21:48
Til: arslist@ARSLIST.ORG
Emne: Approval server ARAPPERR 4605 & 4611

**
Hi listers,

I sincerely hope that there are some insomniacs out there with some knowledge 
of the approval server's innard, because I am well and truly STUCK.

We have migrated an application from a 6.3 environment with approval server 6.X 
to a 7.5 server with approval server 7.5, and everything seems to be fine and 
dandy on the surface. Simple approvals pass without incident, but if we use 
certain flow rules, we get an ARAPPERR 4605, after executing a "Det-Cancelled" 
command


"Sig-xxx command requires process to match details if process is specified.
The process specified in the issued command (sig-approved, sig-rejected, 
sig-cancelled, sig-reassign, sig-notify) does not match the process specified 
in the details record of this pending approval request."

which - as far as I can gather, means that there is a missing link somewhere 
between the AP:detail, AP:Signature and our request form.

I have gone over the approval server documentation several times, and verified 
that all required fields are present on the three way and two way join forms, 
and that all permissions and IDs are set correctly.

As an attempt to verify my work, i ran the arjoinfix.exe command and got 
another ARAPPERR, #4611:

No join is defined between the form and the approval detail form (ARAPPERR 4611)
   LAK:Bestilling-Detail-Signature


No join is defined between the form and the approval detail form.
Before you use the Approval Server with your application, you must join your 
application form to the AP:Detail form.
Instructions are in the Approval Server Guide.

if any of you have a hint or two for me - please feel free to reply.

thanks in advance



regards,



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

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

SV: ARServer Plugin Server

[Jonas Stumph Stevnsvig]

Hi Franklin 
If I remember correctly, the Arpluginsvr is monitored by the armonitor (on 
windows anyway), I have noticed that the Armonitor process restarts any process 
it is monitoring as soon as it is killed. I assume that the behaviour is 
similar on *nix systems.

I frequently restart the Java plugin server in this way, and that is also 
"under" the armonitor.


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 Thomas J. Mutaffis
Sendt: 14. september 2009 20:07
Til: arslist@ARSLIST.ORG
Emne: Re: ARServer Plugin Server

Franklin,

I can't speak for UNIX, but for windows you can set the parameters regarding 
the restart of a service.  Right-click on the specific service and select 
properties. Then go to the tab marked "Recovery." You then can choose "First 
Failure" action, "Second Failure" action and then "Subsequent Failures" action. 
There are a few other items by those I mention will greatly increase your 
control. Default is "Take No Action."

Tom

Thomas J. Mutaffis (RSP)




- Original Message -
From: "Jordan, Franklin" 
Newsgroups: public.remedy.arsystem.general
To: 
Sent: Monday, September 14, 2009 1:56 PM
Subject: ARServer Plugin Server


Good Day,

Question; Is there a method to restart the AR Server Plugin Server without 
restarting the Application as a whole.

Thanks

Franklin A. Jordan,
Energy Enterprise Solutions, LLC C-048/GTN
DOE Office of the CIO - Energy IT Services Infrastructure, Integration, and 
Architecture Division (IM-622.1)
Phone: 301-903-8502
Fax: 301-903-9885
Mobile: 240-350-4181
Email: franklin.jor...@hq.doe.gov

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


---
avast! Antivirus: Inbound message clean.
Virus Database (VPS): 090914-0, 09/14/2009
Tested on: 9/14/2009 1:59:37 PM
avast! - copyright (c) 1988-2009 ALWIL Software.
http://www.avast.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"

Remedy handling numbers differently on two servers

[Jonas Stumph Stevnsvig]

Hi Listers,

I am having an odd thing happending with numercial values.

I have a filter doing a set fields with a decimal field (from a vendor form) as 
source and a character field as destination.

One one of our servers, the value is written correctly (240001000) on the other 
server it is written in scientific notation (2,40001E8)

We can't see any pbvious difference in the setup of the servers. have any of 
you experienced the similar behaviour?




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

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

SV: Remedy handling numbers differently on two servers

[Jonas Stumph Stevnsvig]

Hi Misi

I assumed as much, but the regional settings are the same on alle the servers, 
with exactly the same workflow and forms. 

My worry isn't the comma, but rather that the result is in Scientific form, 
instead of "just" the plain numbers.




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 Misi Mladoniczky
Sendt: 30. september 2009 11:30
Til: arslist@ARSLIST.ORG
Emne: Re: Remedy handling numbers differently on two servers

Hi,

The regional settings of the server probably differ.

The 2,40001E8 indicates that you have comma "," as decimal separator. This 
should be standard in Danish regional settings.

Make sure to apply the settings for the default user profile as well as the one 
you are logged in as.

Best Regards - Misi, RRR AB, http://www.rrr.se

Products from RRR Scandinavia:
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
* RRR|Translator - Manage and automate your language translations.
Find these products, and many free tools and utilities, at http://rrr.se.

> Hi Listers,
>
> I am having an odd thing happending with numercial values.
>
> I have a filter doing a set fields with a decimal field (from a vendor
> form) as source and a character field as destination.
>
> One one of our servers, the value is written correctly (240001000) on 
> the other server it is written in scientific notation (2,40001E8)
>
> We can't see any pbvious difference in the setup of the servers. have 
> any of you experienced the similar behaviour?
>
>
>
>
> 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
>
> __
> _ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org 
> Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
>
> --
> This message was scanned by ESVA and is believed to be clean.
>
>

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

Escalations on vendor forms

[Jonas Stumph Stevnsvig]

Hello all you merrymakers and hardworking folk,

I have a little bit of a bother with an escalation which will not run on 7.5 
but ran fine on 6.3;

The escalation runs on a vendor form, but no matter what I try, it comes up 
with the message " --> Failed qualification" even if my qualification is empty.

I even tried making a separate escalation on a different vendorform - same 
result.

has anyone met this before?

with best regards and Seasonal greetings



with regards,



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




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

SV: Escalations on vendor forms

[Jonas Stumph Stevnsvig]

Hello again,

Do any of you have escalations running on vendor forms on a 7.5 server? I am 
having a bit of a hard time beleiving that I am the only one with the problem. 
And BMC's supporters apparently aren't reading my questions properly.

We're on 7.5 patch 3.



with regards,



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

________
Fra: Jonas Stumph Stevnsvig [mailto:jonas.stumph.stevns...@bec.dk]
Sendt: 4. december 2009 09:39
Emne: Escalations on vendor forms

**
Hello all you merrymakers and hardworking folk,

I have a little bit of a bother with an escalation which will not run on 7.5 
but ran fine on 6.3;

The escalation runs on a vendor form, but no matter what I try, it comes up 
with the message " --> Failed qualification" even if my qualification is empty.

I even tried making a separate escalation on a different vendorform - same 
result.

has anyone met this before?

with best regards and Seasonal greetings



with regards,



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



_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: Escalations on vendor forms

[Jonas Stumph Stevnsvig]

Hi Jarl, Misi

The escalations fail on vendor forms in general. And on three unique Remedy 7.5 
patch 3 servers.

With regards to the implementation of the ARDBC API - I have implemented the 
getEntry() (Java API)call (and the getListEntryWithFields()), and my log shows 
that several entries are being returned, and that the proper qualification is 
sent to the underlying DB.


Eg:

Qualification in Remedy:
('REMEDY_ID LIKE' "E%") AND ('STATUS_ID' LIKE "Auto%")


Escalation log:

  /* fr dec 04 
2009 13:42:26.3820 */Checking CM:TIMP0010:AutogenerateEmergencyChangeFromHost 
(enabled) : ready to fire now on CM:HOST_TIMP0010
 --> Failed 
qualification
  /* fr dec 04 
2009 13:42:26.4760 */CM:TIMP0010:AutogenerateEmergencyChangeFromHost completed

Java plugin ARDBC driver log( I know it's a different timestamp):

09-12-04 13:16:24,503 INFO  [pool-2-thread-5] - getDB2Records() Executing 
Query:
SELECT * FROM TD99.TIMP0010CHANGEREQ  WHERE REMEDY_ID LIKE 'E%'  AND STATUS_ID 
LIKE 'Auto%' 
2009-12-04 13:16:24,503 INFO  [pool-2-thread-5] - getDB2Records() 
returning 3 records.





with regards, 



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




-Oprindelig meddelelse-
Fra: Jarl Grøneng [mailto:jarl.gron...@gmail.com] 
Sendt: 8. december 2009 10:11
Emne: Re: Escalations on vendor forms

Hi,

Do escalation fail on one vendor form, or vendor forms in general?

Regards,
Jarl



2009/12/8 Jonas Stumph Stevnsvig :
> **
> Hello again,
>
> Do any of you have escalations running on vendor forms on a 7.5 
> server? I am having a bit of a hard time beleiving that I am the only 
> one with the problem. And BMC's supporters apparently aren't reading 
> my questions properly.
>
> We're on 7.5 patch 3.
>
>
> with regards,
>
> Jonas Stumph Stevnsvig
> Remedy Developer
> BEC
> Phone  (+45) 46 38 20 08
> Mobile  (+45) 61 56 20 08
> jonas.stumph.stevns...@bec.dk
> becrem...@bec.dk
>
> 
> Fra: Jonas Stumph Stevnsvig [mailto:jonas.stumph.stevns...@bec.dk]
> Sendt: 4. december 2009 09:39
> Emne: Escalations on vendor forms
>
> **
> Hello all you merrymakers and hardworking folk,
>
> I have a little bit of a bother with an escalation which will not run 
> on 7.5 but ran fine on 6.3;
>
> The escalation runs on a vendor form, but no matter what I try, it 
> comes up with the message " --> Failed qualification" even if my 
> qualification is empty.
>
> I even tried making a separate escalation on a different vendorform - 
> same result.
>
> has anyone met this before?
>
> with best regards and Seasonal greetings
>
>
> with regards,
>
> Jonas Stumph Stevnsvig
> Remedy Developer
> BEC
> Phone  (+45) 46 38 20 08
> Mobile  (+45) 61 56 20 08
> jonas.stumph.stevns...@bec.dk
> becrem...@bec.dk
>
>
>
> _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"

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

Asset Management Console size issue on midtier

[Jonas Stumph Stevnsvig]

Hi Listers

I'm having an odd issue.

We have two midtier servers connected to one ARS server; 

For some users, clicking on asset management or CMDB from the homepage produces 
a window with the toolbar, and a 20px tall view of the requested page - which 
is unusable.

When it happens, it only happens on one of the midtiers, and never in the User 
tool. It appears that it's always the same midtier. Logging in from another 
machine produces the same result ... and several users can try from the same 
machine with the same browser, but not all get the anomaly. Flushing the 
midtier cache clears the anomaly temporarily.

I can see that the div with class PageHolder is getting a Height of 20px - on 
the erroneous midtier, while on the other it gets a height of 461px.

We're running ARS 7.5 midtiers with ITSM 7.6, with internet explorer 8 as the 
only available browser.

Have any of you experienced anything similar?

Best regards

Jonas Stevnsvig

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

Re: Asset Management Console size issue on midtier

[Jonas Stumph Stevnsvig]

It's set to the deafult - but the problem isn't that it isn't loading or 
showing. the problem is that the displayed area is 20px high, and as wide as 
the screen.

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

Re: Demo

[Jonas Stumph Stevnsvig]

**

  
  
Now I'm curious - how can you harden the server to prevent this
workaround?

Den 15-11-2011 22:47, Kemes, Lisa skrev:
**
  
  
  Thanks so much!!  I
used this and it worked!   
  Lisa 
   
  
  

From: Action Request System
  discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On
Behalf Of Nathan Aker
  Sent: Tuesday, November 15, 2011 4:38 PM
  To: arslist@ARSLIST.ORG
  Subject: Re: Demo 

  
  **
  
  
  
  
Haven’t tried this
procedure in a while, but it should create a new Admin
account.  The last parameter sets it up a as an Admin. 
Nate.
 
 
 
Go
to a command line, and CD to the install directory.  Look
for a binary called arcache
 
When
you get to it, type the following:
 
arcache
-Ua -eTEMP999 -lw 1 -n "TEMPADMIN"-p"" -s 
-g "1;"
 

 
Then,
log into the server with a login of TEMPADMIN, no password
 
Nathan
  Aker
ITSM Solution Architect
McAfee,
  Inc.

  
 
From:
Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes,
Lisa
Sent: Tuesday, November 15, 2011 2:43 PM
To: arslist@ARSLIST.ORG
Subject: Demo 
 
** 
I hope
others have done the same thing.

   


  Installed
  AR System Application Software 7.6.04 SP2 on Windows 2008
  server (we are using Oracle 11gR2).


   


  After
  install, I logged on using Demo, then went to the User
  Form and added my account and then changed the Demo
  Account from Fixed to Read (so I could add 2 other users).


   


  Logged
  out and logged in as myself and DOH! I didn't add
  administrator permissions on my account so I don't have
  admin privileges.


   


  Logged
  out and then back in as Demo and I guess when I changed
  the license from fixed to Read it took out the Admin
  Privilege?


   


  I have
  some info from the ARSlist archives to use arcache to add
  a fixed license back to demo, but will it give it the
  admin priv's back?


   


   

Lisa Kemes
AR
System Developer
TEIS - USA
+1
717 810 2408 tel
+1 717 602 9460 mobile
lisa.ke...@te.com
100 Amp Drive
Harrisburg,
PA 17112
  
  
  
  www.te.com
  
  
  

   

_attend WWRUG12 www.wwrug.com ARSlist:
  "Where the Answers Are"_ 
  
  _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_
  _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_


  

_attend WWRUG12 www.wwrug.com  ARSlist: "Where the Answers Are"_

Re: Demo

[Jonas Stumph Stevnsvig]

**

  
  
Agreed, but I assume that is only completely safe provided that the
arcache executable connects through a socket and not through tcp
connections... I see I'll have to RTM about it.

thanks for the prompt answer on my query.

/Jonas Stevnsvig

Den 15-11-2011 23:24, Pierson, Shawn skrev:
**
  
  
  
  
  
Since
someone would have to have to be on the server to execute
that command, it should be relatively safe providing that
your server itself is
secure.
 
Thanks,
 
Shawn Pierson 
Remedy
Developer | Southern
Union
 

  From: Action
  Request System discussion
  list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf
    Of Jonas Stumph
  Stevnsvig
  Sent: Tuesday, November 15, 2011 3:57 PM
  To: arslist@ARSLIST.ORG
  Subject: Re: Demo 

 
** 
Now I'm curious - how can you harden the
  server to prevent
  this workaround?
  
  Den 15-11-2011 22:47, Kemes, Lisa skrev: 
** 
Thanks
so much!!  I used this and it worked! 
 
Lisa 

   

 

  

From:
Action Request System discussion
list(ARSList) [mailto:arslist@ARSLIST.ORG]
On Behalf Of Nathan Aker
Sent: Tuesday, November 15, 2011 4:38 PM
To: arslist@ARSLIST.ORG
Subject: Re: Demo 
** 
Haven’t
tried
this procedure in a while, but it should create a new Admin
account.  The last parameter sets it up a as an Admin. 
Nate.
 
 
 
Go
to a command line, and CD to the install directory. 
Look for a binary called arcache
 
When
you get to it, type the following:
 
arcache
-Ua -eTEMP999 -lw 1 -n
"TEMPADMIN"-p"" -s  -g "1;"
 
 
Then,
log into the server with a login of TEMPADMIN, no password
 
Nathan
  Aker
ITSM Solution Architect
McAfee,
  Inc.


  
 
From:
Action Request
System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG]
On Behalf Of Kemes, Lisa
Sent: Tuesday, November 15, 2011 2:43 PM
To: arslist@ARSLIST.ORG
Subject: Demo 
 
** 
I
hope others have done the same thing.

   


  Installed
  AR System Application Software 7.6.04 SP2 on Windows 2008
  server (we are using Oracle 11gR2).


   


  After
  install, I logged on using Demo, then went to the User
  Form
  and added my account and then changed the Demo Account
  from Fixed to
  Read (so I could add 2 other users).


   


  Logged
  out and logged in as myself and DOH! I didn't add
  administrator
  permissions on my account so I don't have admin
  privileges.


   


  Logged
  out and then back in as Demo and I guess when I changed
  the
  license from fixed to Read it took out the Admin
  Privilege?


   


  I
  have some info from the ARSlist archives to use arcache to
  add a
  fixed license back to demo, but will it give it the admin
  priv's back?


   


   

Lisa Kemes
AR System Developer
TEIS - USA
+1 717 810 2408 tel
+1 717 602 9460 mobile
lisa.ke...@te.com
100 Amp Drive
Harrisburg, PA 17112
  
  
  
  www.te.com
  
  
  

   

_attend WWRUG12 www.wwrug.com
  ARSlist: "Where the Answers Are"_ 
_attend WWRUG12 www.wwrug.com
  ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.com
  ARSlist: "Where the Answers
  Are"_ 
 
_attend
WWRUG12 www.wwrug.com
ARSlist: "Where the Answers Are"_ 
  
  Private and confidential as detailed here.
  If you cannot access hyper

Re: Demo

[Jonas Stumph Stevnsvig]

**

  
  
Doug

Thank you for the very detailed explanaion. I will take this into
account while going through the securing of our servers. 

warmest regards

Jonas Stevnsvig

Den 15-11-2011 23:49, Mueller, Doug skrev:
**
  
  
  
  
  
Jonas,
 
You
will find that arcache cannot be run from anything but the
server that you are trying to set the
value
on.  It still does connect through the API which is a TCP
connection, but the server will only allow
the
work to be done by someone coming from the same machine.
 
So,
we believe it is as secure as it is possible to make it
without making it impossible for you to get into
the
system in case of accident.
 
1) 
  You
can configure the system to not allow the program to connect
to the server so the server will
not accept any commands from these API calls (so even if you
try and write a
custom program
that issues the same API calls, it is blocked).
2) 
  You
cannot run arcache from any machine other than the machine
running the server you are
trying to update and have it work.
3) 
  You
can update the config setting as an Admin to control the use
of this utility and you could
manually update the config file and restart the server to
change the setting
but this requires that
you have appropriate, likely Admin, access to the physical
machine to be able
to change those
settings.
 
We
could protect #3 as well, but if we did that, then there
would be no way to get into the system if
you
had no Admin user and there would be no
workaround/alternative.  We figure having to have
serious
levels of access to the physical machine and then the
knowledge of the config file and changing
it
and restarting the server to allow running the utility to
give access sufficient protection.
 
Now,
if you wanted to be more secure, you could delete the
arcache program from the system so the
user
would then have to bring his own copy of arcache with him
and be able to save it to the machine to
be
able to run it to add an extra level of security…..
 
I
hope this helps,
 
Doug
Mueller
 

  From: Action
  Request System discussion
  list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf
Of Jonas Stumph
  Stevnsvig
  Sent: Tuesday, November 15, 2011 2:32 PM
  To: arslist@ARSLIST.ORG
  Subject: Re: Demo 

 
** 
Agreed, but I assume that is only
  completely safe provided
  that the arcache executable connects through a socket and not
  through tcp connections...
  I see I'll have to RTM about it.
  
  thanks for the prompt answer on my query.
  
  /Jonas Stevnsvig
  
  Den 15-11-2011 23:24, Pierson, Shawn skrev: 
** 
Since
someone would have to have to be on the server to execute
that command, it should be relatively safe providing that
your server itself is
secure.
 
Thanks,
 
Shawn Pierson 
Remedy
Developer | Southern Union
 

  From: Action
  Request System discussion
  list(ARSList) [mailto:arslist@ARSLIST.ORG]
  On Behalf Of Jonas Stumph Stevnsvig
  Sent: Tuesday, November 15, 2011 3:57 PM
  To: arslist@ARSLIST.ORG
  Subject: Re: Demo 

 
** 
Now I'm curious - how can you harden the
  server to prevent
  this workaround?
  
  Den 15-11-2011 22:47, Kemes, Lisa skrev: 
** 
Thanks
so much!!  I used this and it worked! 
 
Lisa 

   

 

  

From:
Action Request System discussion
list(ARSList) [mailto:arslist@ARSLIST.ORG]
On Behalf Of Nathan Aker
Sent: Tuesday, November 15, 2011 4:38 PM
To: arslist@ARSLIST.ORG
Subject: Re: Demo 
** 
Haven’t
tried
this procedure in a while, but it should create a

Adding a header to all pages on the mid tier

[Jonas Stumph Stevnsvig]

Hi listers 

I would like to dynamically  add a header or footer on all forms with the text  
"Development Server", for example. One of the best practices for Servlets is to 
have all output channeled through a JSP file, which I hope is what the remedy 
midtier does. So I would like to be able to do it there, so I can make 
difference reports between the servers and not get the banner up as a 
difference.

Do any of you know if this is the case for remedy? Or do I have to get even 
more creative to get my banner without modifying the remedy forms?

best regards

Jonas Stumph Stevnsvig

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

ars & cmdb 7.6.04 upgrade - any successes?

[Jonas Stumph Stevnsvig]

Hi all

We're battling with an upgrade of ARS 7.5 , ITSM 7.5, CMDB 7.6.00 to ARS 
7.6.04.0002, CMDB 7.6.04.0002, ITSM 7.5 (64-bit) but the atrium core installer 
never completes. It always freezes on a 7.6.03.000 xml file...

We've had a barebone install go fine on a 64bit win2k8r2, and had a 32bit 
win2k3 get to freeze on a 7.6.04.000 xml file, but no successes upgrading yet.

I'd like to hear if anyone has had a success with upgrading to atrium core 
7.6.04.002?

best regards 

Jonas Stumph Stevnsvig

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

Re: ars & cmdb 7.6.04 upgrade - any successes?

[Jonas Stumph Stevnsvig]

We let the installer sit from friday to wednesday, with it still on the same 
step, no sql activity, only process active was java.exe checking arerror.log 
and cmdd install log frequently...

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

Re: 7.6.04.02 Windows install oracle Failed to connect to the database

[Jonas Stumph Stevnsvig]

have you created your tnsnames.ora file?

Den 19-01-2012 19:45, Grooms, Frederick W skrev:

**

What about TWO_TASK and TNS_ADMIN in the env?  (TWO_TASK is the 
 tnsnames entry and TNS_ADMIN is the directory the tnsnames.ora file 
is in)


One suggestion I have also heard is to make sure there is a tnsnames 
entry with the same name as the SID you are connecting to and use that 
entry for the install.


Fred

*From: * Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] *On Behalf Of *patrick zandi

*Sent:* Thursday, January 19, 2012 12:37 PM
*To:* arslist@ARSLIST.ORG
*Subject:* 7.6.04.02 Windows install oracle Failed to connect to the 
database


** ENV:: removed MS Patch KB2509553:
   Windows 2008 R2
   Oracle 11r2 X64 installed
   TNSping is good:
   ping hostname is good
   LNSRCTL show the db orcl
   sqlplus as system good
  ORACLE_HOME is in the env
  ORACLE_SID is in the env
  ORACLE_UNQNAME is in the env

run installer getting: Warning! Failed to connect to the database. 
Possible causes: Path variable points to incorrect Oracle client 
tnsnames.ora does not exist or has incorrect connection details 
Missing 64 bit Oracle client libraries.



Oracle side is working fine:: yes it is 64bit installed.. Rebooted 
several times, the installer says it see the DB as it goes down the 
list, then right at installation...stops.

---
I am about to install Patch1 just because I know it works.
---
Anyone see or fix?

--
Patrick Zandi

_attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ 



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

Re: AR Server or DB issue

[Jonas Stumph Stevnsvig]

Hi Ron

I noticed the arAPPnote - indicating an approval notice. I've recently 
hotfxed our servers which were presenting us with ARERR 93 (server busy) 
or the same error you are getting (ARERR 92). Our servers would hang 
upon handling some approval actions. The symtom turned out to be 
unbelievable numbers of notifications being triggered - by a single 
Approval on a change. We got 13 entries in NTE:SYS-NT Proces Control 
for a single change. hotfix was SW00369891 Knowledgebase article is KA 
354923 - just a hunch - but check your NTE:SYS-NT Proces Control  form 
(or select from the Database if your server is unresponsive as ours was).


br

Jonas

Den 10-02-2012 16:34, Peters, Ron skrev:

**

Hello all,

Having some AR server issues. Something has been happening in the 
mornings about 6am in that our service desk can't access Remedy. This 
started in Decemeber but only once. Then twice in January and now a 
couple times this week. The first few times it resolved itself after 
about 30 minutes but this week we had to restart the AR service on the 
server to get it back. The following is the arerror log from this 
morning. I've contacted our DBA's to see if they notice anything but 
since an AR restart resolves it, I'm not convinced it's a DB issue. 
Any thoughts?


Thanks.

Fri Feb 10 06:25:30 2012  AssignEng : Timeout during database update 
-- the operation has been accepted by the server and will usually 
complete successfully (OUR_AR_SERVER)  ARERR - 92


Fri Feb 10 06:25:30 2012  AssignEng : AR System Application server 
terminated -- fatal error encountered (ARAPPNOTE 4501)


Fri Feb 10 06:25:31 2012  SLMCS : Timeout during database update -- 
the operation has been accepted by the server and will usually 
complete successfully (OUR_AR_SERVER)  ARERR - 92


Fri Feb 10 06:25:31 2012  SLMCS : AR System Application server 
terminated -- fatal error encountered (ARAPPNOTE 4501)


Fri Feb 10 06:27:32 2012  AssignEng : Timeout during database update 
-- the operation has been accepted by the server and will usually 
complete successfully (OUR_AR_SERVER)  ARERR - 92


Fri Feb 10 06:27:32 2012  AssignEng : AR System Application server 
terminated -- fatal error encountered (ARAPPNOTE 4501)


Fri Feb 10 06:27:32 2012  SLMCS : Timeout during database update -- 
the operation has been accepted by the server and will usually 
complete successfully (OUR_AR_SERVER)  ARERR - 92


Fri Feb 10 06:27:32 2012  SLMCS : AR System Application server 
terminated -- fatal error encountered (ARAPPNOTE 4501)


Fri Feb 10 06:29:32 2012  AssignEng : Timeout during database update 
-- the operation has been accepted by the server and will usually 
complete successfully (OUR_AR_SERVER)  ARERR - 92


Fri Feb 10 06:29:32 2012  AssignEng : AR System Application server 
terminated -- fatal error encountered (ARAPPNOTE 4501)


Fri Feb 10 06:29:32 2012  SLMCS : Timeout during database update -- 
the operation has been accepted by the server and will usually 
complete successfully (OUR_AR_SERVER)  ARERR - 92


Fri Feb 10 06:29:32 2012  SLMCS : AR System Application server 
terminated -- fatal error encountered (ARAPPNOTE 4501)


Fri Feb 10 06:30:05 2012  BRIE : Timeout during database query -- 
consider using more specific search criteria to narrow the results, 
and retry the operation (OUR_AR_SERVER)  ARERR - 94


Fri Feb 10 06:31:32 2012  AssignEng : Timeout during database update 
-- the operation has been accepted by the server and will usually 
complete successfully (OUR_AR_SERVER)  ARERR - 92


Fri Feb 10 06:31:32 2012  AssignEng : AR System Application server 
terminated -- fatal error encountered (ARAPPNOTE 4501)


Fri Feb 10 06:31:32 2012  SLMCS : Timeout during database update -- 
the operation has been accepted by the server and will usually 
complete successfully (OUR_AR_SERVER)  ARERR - 92


Fri Feb 10 06:31:32 2012  SLMCS : AR System Application server 
terminated -- fatal error encountered (ARAPPNOTE 4501)


Fri Feb 10 06:33:32 2012  AssignEng : Timeout during database update 
-- the operation has been accepted by the server and will usually 
complete successfully (OUR_AR_SERVER)  ARERR - 92


Fri Feb 10 06:33:32 2012  AssignEng : AR System Application server 
terminated -- fatal error encountered (ARAPPNOTE 4501)


Fri Feb 10 06:33:32 2012  SLMCS : Timeout during database update -- 
the operation has been accepted by the server and will usually 
complete successfully (OUR_AR_SERVER)  ARERR - 92


Fri Feb 10 06:33:32 2012  SLMCS : AR System Application server 
terminated -- fatal error encountered (ARAPPNOTE 4501)


Fri Feb 10 06:35:02 2012  CMDB Dispatcher : Timeout during database 
query -- consider using more specific search criteria to narrow the 
results, and retry the operation (OUR_AR_SERVER)  ARERR - 94


Fri Feb 10 06:35:05 2012  BRIE : Timeout during database query -- 
consider using more specific search criteria to narrow the results, 
and retry the operation (OUR_AR_SERVER)  ARERR - 94


Fri Feb 10 06:3

Disalowing 7.5 developer tool on a 7.6.04 system

[Jonas Stumph Stevnsvig]

Hi listers

I have a little question which bothers me, and I hope you can give me some 
insight.

The background:
We are about to go live with a new 7.6.04 sp2 environment. We have several 
consultants, not all of which are familiar with overlays. We almost had a 
catastrophe today with a person logging onto the new server with a 7.5 dev 
studio. He did not get any warnings about base/overlay mode, and almost wrecked 
a form by deleting fields from the wrong place.

I am aware of the  lowest api level, but our ITSM installation is still at 
7.6.00 so there are some old plugins at api level 7.5 (or thereabout).

The Question:
How do I disallow dev studio connections < 7.6.04 without disallowing the 
plugins?

Any suggestions?

Best regards

Jonas

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

Re: Remedy Approval 7.6.04

[Jonas Stumph Stevnsvig]

Hi Dan

Try the health check in the utilitied directory of the uinstaller. It's 
my experience that it gives a little more detail thanthe post install 
sanity check.


BR

Jonas Stevsnvig

Den 28-02-2012 16:02, Dan skrev:

Listers,

We are in the process of building a new system.  windows 2008, AR
server 7.6.04 install.   The approval server failed to install
initially due to some group permissions on the server set by the
network lockdown.  We have resolved those but now the approval server
fails its post install sanity check.
I get the following Warnings.

LOG EVENT {Description=[Approval server post install sanity check
execution - timed out]}
LOG EVENT {Description=[BMC_APPROVAL_SERVER_SANITY_FAILED],Detail=[The
Approval Server post installation check failed.]}

Any ideas what could/would cause this.
What is it trying to do during the sanity check that could cause a
time out.

I have a feeling it may be something on the server that is causing it
to time out but just not sure where to look as I am not sure what it
is trying to do during this part of the sanity check.


Thanks

Dan

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


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

Re: Tomcat URL Redirect question

[Jonas Stumph Stevnsvig]

You should create an index.jsp to replace the standard index.html of the 
tomcat installation. here is an example based on our setup (we have a 
separate hostname for SRM for ease of use).


<%@ page session="false" %>
<%
String redirectURL = "http://"+request.getHeader("host")+"/arsys/home"; 
//default redirect to default AR server


if (request.getHeader("host").equals("www.IwantServerA.com")) 
{//redirect to server A (SRM)
redirectURL = 
"http://"+request.getHeader("host")+"/arsys/shared/login.jsp?/arsys/forms/ServerA/SRS%3AServiceRequestConsole/enduser";

} else if (request.getHeader("host").equals("www.IwantServerB.com")) {
redirectURL = 
"http://"+request.getHeader("host")+"/arsys/shared/login.jsp?/arsys/forms/ServerB/Home+Page";

}

response.sendRedirect(redirectURL);
%>

Hope it helps

Jonas
jonas.stumph.stevns...@nordea.com


Den 16-03-2012 20:06, Pruitt, Christopher (Bank of America Account) skrev:

**
I am hoping someone on this list has done this before and can provide 
some quick answers.
We are setting up a several new Mid-Tier servers along with several 
new AR System Servers. The Mid-Tier servers will have a load balancer 
hardware in front of it.  What I have been asked to do is to set up 
Tomcat on these two new Mid-Tier servers so that Tomcat has the 
ability to evaluate the URL the user is coming in on from the internet 
and redirecting that user to a specific server.
This is what we are planning. We have two servers ARServer A and 
ARServer B and the user uses the URL "_www.Iwant ServerA.com_ 
" we want Tomcat to redirect them to 
ARServerA (SUN) if they use a different URL say "_www.Iwant 
ServerB.com_ " Tomcat would redirect 
them to ARServerB (HP).
Is this possible in Tomcat? If so, where can I find the instructions 
on how to do that?

We are running
Two UNIX Servers One server is a SUN OS 5.9 and the other server is an 
HP-UX 11i v3 and both have AR Server 7.1 patch 11 installed.
Two Windows Server 2008 64 Bit R2 Enterprise Editionrunning Apache 
Tomcat 5.5.25 Server

*Christopher Pruitt*
Business Consulting III
*HP Enterprises Services
*_christopher.pru...@hp.com
__www.hp.com_ 
_/*Confidentiality Notice:*/_This message and any files transmitted 
with it are intended for the sole use of the entity or individual to 
whom it is addressed, and may contain information that is 
confidential, privileged, and exempt from disclosure under applicable 
law. If you are not the intended addressee for this e-mail, you are 
hereby notified that any copying, distribution, or dissemination of 
this e-mail is strictly prohibited. If you have received this e-mail 
in error, please immediately destroy, erase, or discard this message. 
Please notify the sender immediately by return e-mail if you have 
received this e-mail by mistake.
_attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ 



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

ARS ARDBC plugin development

[Jonas Stumph Stevnsvig]

Dearest ARSlisters,

(I appologize if this is a dual post  - I have been battling with the listserv 
since it didn't like an alias to my email.)

I have had a few difficulties with the development of  an ARDBC plugin. I am 
trying to update an existing code, but without much luck.

I started off compiling the code, and verifying that I could see the plugin in 
the list of available vendor names when creating new vendor tables - that went 
fine.
I then selected the vendor name, selected a table, and was presented with a 
long list of nothing.

I've spent a lot of time trying to discover the best way to debug the driver, 
ending up with making sure that the following was appended to the ar.cfg:
Plugin-Log-Level: 400 # guess - not sure whether it makes a difference
Debug-mode: 131072
# see ConfigGuide-630.pdf for debug-mode.
# 131072 : ARPLUGIN logging

I now get a lot of information about the plugins being loaded, eg:
ARDBC   Plug-In Loaded: BEC.ARDBC.TDIV0310 version 2
ARPluginSetPropertiesundefined
ARPluginInitialization   defined
ARPluginTermination  defined
ARPluginCreateInstance   defined
ARPluginDeleteInstance   defined
ARPluginEventundefined
ARDBCCreateEntry defined
ARDBCGetEntrydefined
ARDBCSetEntrydefined
ARDBCDeleteEntry defined
ARDBCGetEntryBLOBdefined
ARDBCGetListEntryWithFields  defined
ARDBCGetEntryStatistics  defined
ARDBCCommitTransaction   defined
ARDBCRollbackTransaction defined
ARDBCGetListSchemas  defined
ARDBCGetMultipleFields   defined

As well as information about when the plugin's functions are being called, 
which is nice and neat.

Now I am having trouble with Remedy administrator starting to hang after I 
select vendor tables in the create vendor form dialog.




The AR System Plug-In server is not responding.  Cannot connect to the system 
at this time.  Contact your AR System Administrator for assistance. : RPC: 
Timed out (ARERR 8939).

I've tried to follow the sparse guides on how to write to the arplugin.log, but 
I am having a spot of trouble getting my head round the ARPluginSetProperties 
implementation needed - I find the available documentation a bit sparse.  A 
point in the right direction is much appreciated.

I'm using the C API, and coding for 6.03 on a windows platform. (we're in the 
midst of migrating to 7.5, but need to get this corrected for 6.03 anyway)

Thanks in advance.



With regards,



Jonas Stumph Stevnsvig


Remedy Developer

BEC Intern IT
Phone (+45) 46 38 20 08
jonas.stumph.stevns...@bec.dk



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

SV: ARS ARDBC plugin development

[Jonas Stumph Stevnsvig]

Beautiful Axton,- I'll have a try, thanks for the response so far.



Regards, Jonas




Fra: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] På vegne af Axton
Sendt: 1. maj 2009 17:42
Til: arslist@ARSLIST.ORG
Emne: Re: ARS ARDBC plugin development

** I put the doxygen generated docs for the files here:

http://arswiki.org/doxygen/arfprng/trunk/html/files.html

Axton Grams

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.

On Fri, May 1, 2009 at 10:34 AM, Axton 
mailto:axton.gr...@gmail.com>> wrote:
I have some examples of the ARPluginSetProperties, related to logging and 
others, available here:

http://arswiki.org/projects/arfprng/browser/trunk/lib/arfprng.c#L48
http://arswiki.org/projects/arfprng/browser/trunk/lib/arfprng.c#L123

and a wrapper for the log functions here:

http://arswiki.org/projects/arfprng/browser/trunk/lib/logger.c

and an example using the log wrapper function here:
http://arswiki.org/projects/arfprng/browser/trunk/lib/arfprng.c#L255


Basically, the plugin server provides a pointer to a function that it 
implements which can be retrieved/referenced using the ARPropList in the 
ARPluginSetProperties.  You just need to get the value of the pointer and make 
it globally available so that you can call the function from within your code.  
There are a number of other undocumented functions that I found that are 
interesting too, such as AR_PLUGIN_PROP_GETUSER_FUNCTION, which returns the 
username, password, auth string, etc. of the calling user.  These other 
functions are not documented anywhere, but they are outlined in the header 
files.

Axton Grams

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.


On Fri, May 1, 2009 at 3:35 AM, Jonas Stumph Stevnsvig 
mailto:jonas.stumph.stevns...@bec.dk>> wrote:
**
Dearest ARSlisters,

(I appologize if this is a dual post  - I have been battling with the listserv 
since it didn't like an alias to my email.)

I have had a few difficulties with the development of  an ARDBC plugin. I am 
trying to update an existing code, but without much luck.

I started off compiling the code, and verifying that I could see the plugin in 
the list of available vendor names when creating new vendor tables - that went 
fine.
I then selected the vendor name, selected a table, and was presented with a 
long list of nothing.

I've spent a lot of time trying to discover the best way to debug the driver, 
ending up with making sure that the following was appended to the ar.cfg:
Plugin-Log-Level: 400 # guess - not sure whether it makes a difference
Debug-mode: 131072
# see ConfigGuide-630.pdf for debug-mode.
# 131072 : ARPLUGIN logging

I now get a lot of information about the plugins being loaded, eg:
ARDBC   Plug-In Loaded: BEC.ARDBC.TDIV0310 version 2
ARPluginSetPropertiesundefined
ARPluginInitialization   defined
ARPluginTermination  defined
ARPluginCreateInstance   defined
ARPluginDeleteInstance   defined
ARPluginEventundefined
ARDBCCreateEntry defined
ARDBCGetEntrydefined
ARDBCSetEntrydefined
ARDBCDeleteEntry defined
ARDBCGetEntryBLOBdefined
ARDBCGetListEntryWithFields  defined
ARDBCGetEntryStatistics  defined
ARDBCCommitTransaction   defined
ARDBCRollbackTransaction defined
ARDBCGetListSchemas  defined
ARDBCGetMultipleFields   defined

As well as information about when the plugin's functions are being called, 
which is nice and neat.

Now I am having trouble with Remedy administrator starting to hang after I 
select vendor tables in the create vendor form dialog.




The AR System Plug-In server is not responding.  Cannot connect to the system 
at this time.  Contact your AR System Administrator for assistance. : RPC: 
Timed out (ARERR 8939).

I've tried to follow the sparse guides on how to write to the arplugin.log, but 
I am having a spot of trouble getting my head round the ARPluginSetProperties 
implementation needed - I find the available documentation a bit sparse.  A 
point in the right direction is much appreciated.

I'm using the C API, and coding for 6.03 on a windows platform. (we're in the 
midst of migrating 

SV: ARS ARDBC plugin development

[Jonas Stumph Stevnsvig]

Hi again,

I got the logging function working - inspired by the code you linked to, but I 
think there is a bug  - maybe an infinite loop, becuase I get "The AR System 
Plug-In server is not responding.  Cannot connect to the system at this time.  
Contact your AR System Administrator for assistance. : RPC: Timed out (ARERR 
8939)." after a while, and it stops after the first call to my logging function.

Is there a way to attach a debugger like GDB/DBX to Remedy to be able to debug 
the plugin?

Observe that the ARS6.3 server is not the same machine as the one i'm running 
my C development environment on.


Thanks in advance

Jonas


Fra: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] På vegne af Axton
Sendt: 1. maj 2009 17:42
Til: arslist@ARSLIST.ORG
Emne: Re: ARS ARDBC plugin development

** I put the doxygen generated docs for the files here:

http://arswiki.org/doxygen/arfprng/trunk/html/files.html

Axton Grams

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.

On Fri, May 1, 2009 at 10:34 AM, Axton 
mailto:axton.gr...@gmail.com>> wrote:
I have some examples of the ARPluginSetProperties, related to logging and 
others, available here:

http://arswiki.org/projects/arfprng/browser/trunk/lib/arfprng.c#L48
http://arswiki.org/projects/arfprng/browser/trunk/lib/arfprng.c#L123

and a wrapper for the log functions here:

http://arswiki.org/projects/arfprng/browser/trunk/lib/logger.c

and an example using the log wrapper function here:
http://arswiki.org/projects/arfprng/browser/trunk/lib/arfprng.c#L255


Basically, the plugin server provides a pointer to a function that it 
implements which can be retrieved/referenced using the ARPropList in the 
ARPluginSetProperties.  You just need to get the value of the pointer and make 
it globally available so that you can call the function from within your code.  
There are a number of other undocumented functions that I found that are 
interesting too, such as AR_PLUGIN_PROP_GETUSER_FUNCTION, which returns the 
username, password, auth string, etc. of the calling user.  These other 
functions are not documented anywhere, but they are outlined in the header 
files.

Axton Grams

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.


On Fri, May 1, 2009 at 3:35 AM, Jonas Stumph Stevnsvig 
mailto:jonas.stumph.stevns...@bec.dk>> wrote:
**
Dearest ARSlisters,

(I appologize if this is a dual post  - I have been battling with the listserv 
since it didn't like an alias to my email.)

I have had a few difficulties with the development of  an ARDBC plugin. I am 
trying to update an existing code, but without much luck.

I started off compiling the code, and verifying that I could see the plugin in 
the list of available vendor names when creating new vendor tables - that went 
fine.
I then selected the vendor name, selected a table, and was presented with a 
long list of nothing.

I've spent a lot of time trying to discover the best way to debug the driver, 
ending up with making sure that the following was appended to the ar.cfg:
Plugin-Log-Level: 400 # guess - not sure whether it makes a difference
Debug-mode: 131072
# see ConfigGuide-630.pdf for debug-mode.
# 131072 : ARPLUGIN logging

I now get a lot of information about the plugins being loaded, eg:
ARDBC   Plug-In Loaded: BEC.ARDBC.TDIV0310 version 2
ARPluginSetPropertiesundefined
ARPluginInitialization   defined
ARPluginTermination  defined
ARPluginCreateInstance   defined
ARPluginDeleteInstance   defined
ARPluginEventundefined
ARDBCCreateEntry defined
ARDBCGetEntrydefined
ARDBCSetEntrydefined
ARDBCDeleteEntry defined
ARDBCGetEntryBLOBdefined
ARDBCGetListEntryWithFields  defined
ARDBCGetEntryStatistics  defined
ARDBCCommitTransaction   defined
ARDBCRollbackTransaction defined
ARDBCGetListSchemas  defined
ARDBCGetMultipleFields   defined

As well as information about when the plugin's functions are being called, 
which is nice and neat.

Now I am having trouble with Remedy administrator starting to hang after I 
select vendor tables in the create vendor form dialog.




The AR System

SV: Preparing import file with date fields in Excel

[Jonas Stumph Stevnsvig]

Hi dwayne - I am using a localized version of excel, but I've tried just that. 
My solution was:

TEKST(O2;"dd-mm-åå")

So for an english excel my guess is 

TEXT(O2;"dd-mm-yy")


Observe that this is not applicable for VBA - that is an entierly different 
approach.



with regards,



Jonas Stumph Stevnsvig


Remedy Developer

BEC Intern IT
jonas.stumph.stevns...@bec.dk 

-Oprindelig meddelelse-
Fra: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] På vegne af Dwayne Martin
Sendt: 7. maj 2009 17:09
Til: arslist@ARSLIST.ORG
Emne: Preparing import file with date fields in Excel

Dear List,

This is really an Excel question, but I can't find the answer so I'll try you 
all.

I am trying to create a template for exporting data from one form and importing 
it into a very different form.  So I've exported the data from the first form 
into a comma-separated-file (csv), and opened the file in Excel.  In the cell 
after all the data columns I am trying to build the import file data row. The 
date fields appear as dates in the main spreadsheet.  But when I try to insert 
them into a formula they appear as long decimal numbers.

Eg in the O2 cell I see "5/6/2009  4:34:00 PM", but when I insert "O2" into a 
formula as:

. . . &CHAR(34)&O2&CHAR(34)&. . .

the O2 value appears as "39939.690278".

I've tried the DATE and DATEVALUE.  The formula that Excel uses to create these 
date numbers is way too complicated to convert into a Remedy date integer.

How can I get the date to appear as a date in my formulated field?

Dwayne Martin
James Madison University

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

ARDBC plugin development again

[Jonas Stumph Stevnsvig]

Hi listers

I'm currently in the process of creating a "hello world" in remedy, based on 
the ardbcskl.c

Unfortunately my efforts are not going well.. I'm getting an error 129 - which 
i have resolved to  "Field limit definition is invalid.
The field limit specified for this field is invalid.

 For a numeric field, make sure that the high range is greater than the low 
range.

 For a character field, make sure that the pattern is within the size limit of 
the field. Also, verify
that the specified character menu, the menu style setting, and the match 
operation setting are
legal.

 For a selection field, verify that the value is a legal value for the field."
Using the 7.5 error messages guide (I get "Message not in catalog; Message 
number = 129 DummyChar,  129,  TEST:JSS:HB2") When i try to save the form.
I get another error if I try to make an integer field - any help is appreciated

(ARS7.5, MSSQL 2005 DB, WIN2k3)


/*/
/*   */
/* ARDBCGetMultipleFields*/
/*   */
/*/
/*   */
/*   Description:  This is used to get a list of candidate fields to which   */
/*  fields on a vendor forms can be attached.*/
/*   */
/*/

ARPLUGIN_EXPORT int ARDBCGetMultipleFields(
void  *object,  /* IN; plug-in instance */
ARCompoundSchema  *schema,  /* IN; form containing the data */
ARFieldMappingList *mapping,/* OUT; list of fields */
ARFieldLimitList  *limit,   /* OUT; corresponding field limits */
ARUnsignedIntList *dataType,/* OUT; corresponding data types */
ARStatusList  *status   /* OUT; status of the operation */
)
{
//dummy tæller
int antalElementer = 1;

//initialiser structs
mapping->numItems = antalElementer;
mapping->mappingList = 
calloc(mapping->numItems,sizeof(ARFieldMappingStruct));

dataType->numItems = antalElementer;
dataType->intList = calloc(dataType->numItems, sizeof(int));

limit->numItems = antalElementer;
limit->fieldLimitList = 
calloc(limit->numItems,sizeof(ARFieldLimitStruct));

//første felt (char)
mapping->mappingList[0].fieldType = AR_DATA_TYPE_CHAR;
memcpy(mapping->mappingList[0].u.vendor.fieldName, "DummyChar",9);

limit->fieldLimitList[0].dataType = AR_DATA_TYPE_CHAR;
limit->fieldLimitList[0].u.charLimits.maxLength = 200;
//limit->fieldLimitList[0].u.charLimits.lengthUnits = 1;
//limit->fieldLimitList[0].u.charLimits.storageOptionForCLOB = 0;
//limit->fieldLimitList[0].u.charLimits.pattern = "$ALPHA$";

dataType->intList[0] = AR_DATA_TYPE_CHAR;

//andet felt (int)
/*  mapping->mappingList[1].fieldType = AR_DATA_TYPE_INTEGER;
memcpy(mapping->mappingList[1].u.vendor.fieldName, "DummyInt",8);

limit->fieldLimitList[1].dataType = AR_DATA_TYPE_INTEGER;
limit->fieldLimitList[1].u.intLimits.rangeLow = -100;
limit->fieldLimitList[1].u.intLimits.rangeHigh = 100;

dataType->intList[1] = AR_DATA_TYPE_INTEGER;
*/

return AR_RETURN_OK;
}


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

SV: ARDBC plugin development again

[Jonas Stumph Stevnsvig]

Thanks for the response Jarl. You said that you would do it the Java way today? 
As far as I have read, ARDBC plugins for vendor forms must still be in dll 
form? Or have I missed something?


with regards,



Jonas Stumph Stevnsvig
Remedy Developer
BEC 
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: 11. juni 2009 17:03
Til: arslist@ARSLIST.ORG
Emne: Re: ARDBC plugin development again

This is how I used this. Its a few years since I wrote this, and would 
definitly do it the Java way today:


ARPLUGIN_EXPORT int ARDBCGetMultipleFields(
void  *object,  /* IN; plug-in instance */
ARCompoundSchema  *schema,  /* IN; form containing the data */ 
ARFieldMappingList *mapping,/* OUT; list of fields */
ARFieldLimitList  *limit,   /* OUT; corresponding field limits */
ARUnsignedIntList *dataType,/* OUT; corresponding data types */
ARStatusList  *status   /* OUT; status of the operation */
)
{
   /* verify that the form name is the one we know about otherwise */
   /* we will ignore this request  */

   if (schema->schemaType == AR_SCHEMA_VENDOR &&
   strcmp(schema->u.vendor.tableName, VENDOR_FORM_NAME) == 0)
   {
  /* fill the field mapping list with the three fields other than */
  /* the id field that we are exposing*/

  mapping->numItems = 3;

  mapping->mappingList =
 (ARFieldMappingStruct *) malloc(sizeof(ARFieldMappingStruct) *
 mapping->numItems);
  if (mapping->mappingList == NULL)
 return AddErrorMessage(status, NULL, AR_RETURN_ERROR,
PLUGIN_ERROR_MEMORY, "");

  mapping->mappingList[0].fieldType = AR_FIELD_VENDOR;
  strcpy(mapping->mappingList[0].u.vendor.fieldName, "employee_name");
  mapping->mappingList[1].fieldType = AR_FIELD_VENDOR;
  strcpy(mapping->mappingList[1].u.vendor.fieldName, "employee_phone");
  mapping->mappingList[2].fieldType = AR_FIELD_VENDOR;
  strcpy(mapping->mappingList[2].u.vendor.fieldName, "employee_email");

  /* fill the field limit list (in case the Admin Tool uses it someday) */

  limit->numItems = 3;

  limit->fieldLimitList =
 (ARFieldLimitStruct *) calloc(limit->numItems,
   sizeof(ARFieldLimitStruct));
  if (limit->fieldLimitList == NULL)
 return AddErrorMessage(status, NULL, AR_RETURN_ERROR,
PLUGIN_ERROR_MEMORY, "");

  limit->fieldLimitList[0].dataType = AR_DATA_TYPE_CHAR;
  limit->fieldLimitList[0].u.charLimits.maxLength = 50;
  limit->fieldLimitList[0].u.charLimits.menuStyle = AR_MENU_APPEND;
  limit->fieldLimitList[0].u.charLimits.qbeMatchOperation = 
AR_QBE_MATCH_ANYWHERE;
  limit->fieldLimitList[0].u.charLimits.fullTextOptions = 
AR_FULLTEXT_OPTIONS_NONE;
  limit->fieldLimitList[1].dataType = AR_DATA_TYPE_CHAR;
  limit->fieldLimitList[1].u.charLimits.maxLength = 20;
  limit->fieldLimitList[1].u.charLimits.menuStyle = AR_MENU_APPEND;
  limit->fieldLimitList[1].u.charLimits.qbeMatchOperation = 
AR_QBE_MATCH_ANYWHERE;
  limit->fieldLimitList[1].u.charLimits.fullTextOptions = 
AR_FULLTEXT_OPTIONS_NONE;
  limit->fieldLimitList[2].dataType = AR_DATA_TYPE_CHAR;
  limit->fieldLimitList[2].u.charLimits.maxLength = 50;
  limit->fieldLimitList[2].u.charLimits.menuStyle = AR_MENU_APPEND;
  limit->fieldLimitList[2].u.charLimits.qbeMatchOperation = 
AR_QBE_MATCH_ANYWHERE;
  limit->fieldLimitList[2].u.charLimits.fullTextOptions = 
AR_FULLTEXT_OPTIONS_NONE;

  /* fill the data type list */

  dataType->numItems = 3;

  dataType->intList =
 (unsigned int *) malloc(sizeof(unsigned) * dataType->numItems);
  if (dataType->intList == NULL)
 return AddErrorMessage(status, NULL, AR_RETURN_ERROR,
PLUGIN_ERROR_MEMORY, "");

  dataType->intList[0] = AR_DATA_TYPE_CHAR;
  dataType->intList[1] = AR_DATA_TYPE_CHAR;
  dataType->intList[2] = AR_DATA_TYPE_CHAR;
   }

   return AR_RETURN_OK;


2009/6/11 Jonas Stumph Stevnsvig :
> **
> Hi listers
>
> I'm currently in the process of creating a "hello world" in remedy, 
> based on the ardbcskl.c
>
> Unfortunately my efforts are not going well.. I'm getting an error 129 
> - which i have resolved to  "Field limit definition is invalid.
> The field limit specified for this field is invalid.
> 
 For a numeric field, make sure that the high range is greater than 
> the low range.

Java ARDBC

[Jonas Stumph Stevnsvig]

.b (?:?) - Java 
plug-in server is initializing all plug-ins for 5 core threads. Please wait ...
2009-06-30 09:23:31,711 INFO  [pool-2-thread-5] com.bmc.arsys.pluginsvr.d.b 
(?:?) - Will iniPlugins for thread: 16 Thread[pool-2-thread-5,5,main]
2009-06-30 09:23:31,711 INFO  [pool-2-thread-4] com.bmc.arsys.pluginsvr.d.b 
(?:?) - Will iniPlugins for thread: 15 Thread[pool-2-thread-4,5,main]
2009-06-30 09:23:31,711 INFO  [pool-2-thread-3] com.bmc.arsys.pluginsvr.d.b 
(?:?) - Will iniPlugins for thread: 14 Thread[pool-2-thread-3,5,main]
2009-06-30 09:23:31,726 INFO  [pool-2-thread-2] com.bmc.arsys.pluginsvr.d.b 
(?:?) - Will iniPlugins for thread: 13 Thread[pool-2-thread-2,5,main]
2009-06-30 09:23:31,726 INFO  [pool-2-thread-1] com.bmc.arsys.pluginsvr.d.b 
(?:?) - Will iniPlugins for thread: 12 Thread[pool-2-thread-1,5,main]
2009-06-30 09:23:31,742 INFO  [pool-2-thread-5] 
com.bmc.arsys.pluginsvr.plugins.g (?:?) - Attempting to Create an instance of 
the plugin JdbcDataSourceDBIX
2009-06-30 09:23:31,742 INFO  [pool-2-thread-5] 
com.bmc.arsys.pluginsvr.plugins.ARPluginContext (?:?) - 
initialize()
2009-06-30 09:23:31,742 INFO  [pool-2-thread-5] 
com.bmc.arsys.pluginsvr.plugins.g (?:?) - Thread 16 successfully created an 
instance of JdbcDataSourceDBIX
2009-06-30 09:23:31,742 INFO  [pool-2-thread-5] com.bmc.arsys.pluginsvr.d.b 
(?:?) - Done iniPlugins for thread: 16
2009-06-30 09:23:31,742 INFO  [pool-2-thread-1] 
com.bmc.arsys.pluginsvr.plugins.g (?:?) - Attempting to Create an instance of 
the plugin JdbcDataSourceDBIX
2009-06-30 09:23:31,742 INFO  [pool-2-thread-1] 
com.bmc.arsys.pluginsvr.plugins.ARPluginContext (?:?) - 
initialize()
2009-06-30 09:23:31,742 INFO  [pool-2-thread-1] 
com.bmc.arsys.pluginsvr.plugins.g (?:?) - Thread 12 successfully created an 
instance of JdbcDataSourceDBIX
2009-06-30 09:23:31,742 INFO  [pool-2-thread-1] com.bmc.arsys.pluginsvr.d.b 
(?:?) - Done iniPlugins for thread: 12
2009-06-30 09:23:31,742 INFO  [pool-2-thread-2] 
com.bmc.arsys.pluginsvr.plugins.g (?:?) - Attempting to Create an instance of 
the plugin JdbcDataSourceDBIX
2009-06-30 09:23:31,742 INFO  [pool-2-thread-2] 
com.bmc.arsys.pluginsvr.plugins.ARPluginContext (?:?) - 
initialize()
2009-06-30 09:23:31,742 INFO  [pool-2-thread-2] 
com.bmc.arsys.pluginsvr.plugins.g (?:?) - Thread 13 successfully created an 
instance of JdbcDataSourceDBIX
2009-06-30 09:23:31,742 INFO  [pool-2-thread-2] com.bmc.arsys.pluginsvr.d.b 
(?:?) - Done iniPlugins for thread: 13
2009-06-30 09:23:31,742 INFO  [pool-2-thread-3] 
com.bmc.arsys.pluginsvr.plugins.g (?:?) - Attempting to Create an instance of 
the plugin JdbcDataSourceDBIX
2009-06-30 09:23:31,742 INFO  [pool-2-thread-3] 
com.bmc.arsys.pluginsvr.plugins.ARPluginContext (?:?) - 
initialize()
2009-06-30 09:23:31,757 INFO  [pool-2-thread-3] 
com.bmc.arsys.pluginsvr.plugins.g (?:?) - Thread 14 successfully created an 
instance of JdbcDataSourceDBIX
2009-06-30 09:23:31,757 INFO  [pool-2-thread-3] com.bmc.arsys.pluginsvr.d.b 
(?:?) - Done iniPlugins for thread: 14
2009-06-30 09:23:31,757 INFO  [pool-2-thread-4] 
com.bmc.arsys.pluginsvr.plugins.g (?:?) - Attempting to Create an instance of 
the plugin JdbcDataSourceDBIX
2009-06-30 09:23:31,757 INFO  [pool-2-thread-4] 
com.bmc.arsys.pluginsvr.plugins.ARPluginContext (?:?) - 
initialize()
2009-06-30 09:23:31,757 INFO  [pool-2-thread-4] 
com.bmc.arsys.pluginsvr.plugins.g (?:?) - Thread 15 successfully created an 
instance of JdbcDataSourceDBIX
2009-06-30 09:23:31,757 INFO  [pool-2-thread-4] com.bmc.arsys.pluginsvr.d.b 
(?:?) - Done iniPlugins for thread: 15
2009-06-30 09:23:31,757 INFO  [pool-2-thread-4] com.bmc.arsys.pluginsvr.d.b 
(?:?) - Java plug-in server has initialized plug-ins for all 5 core threads. 
The server is ready to receive RPC calls.
2009-06-30 09:23:31,820 INFO  [main] com.bmc.arsys.pluginsvr.ARPluginServerMain 
(?:?) - AR System Plugin Server Version 7.5.00 Patch 001 200903100038

I'm running ARS 7.5 on win2k3

Any help is much appreciated.

best 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



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

SV: Java ARDBC

[Jonas Stumph Stevnsvig]

Hi again,

their trial download link appears broken. I'd still like to try to get a hole 
through with the java plugin. any help is appreciated





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




Fra: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] På vegne af Frank Caruso
Sendt: 30. juni 2009 11:33
Til: arslist@ARSLIST.ORG
Emne: Re: Java ARDBC

**
I remember seeing your past postings but do not recall why you were building 
the plugin. However, if you are trying to build a plugin to connect to a 
database I would highly recommend using the plugins from James Croom 
(http://croomconsulting.com/). I used them at my last company and they worked 
perfectly. Also, the development time it would've taken to build the plugin 
would've far exceeded the purchase price.

Frank

On Tue, Jun 30, 2009 at 11:48 AM, Jonas Stumph Stevnsvig 
mailto:jonas.stumph.stevns...@bec.dk>> wrote:
**
Hi listers

As some of you may have noticed - I've been battling to get some ARDBC 
connections up and running. After plenty of reading and advice, and 
considerable problems with our C developer tools, I've decided to switch to 
Java. I started off by downloading the 7.1 Java ARDBC/filter plugin sample from 
http://developer.bmc.com/communities/docs/DOC-2548 . Unfortunately I cannot get 
the code to work as intended. I have tried with several different JDBC drivers, 
and the  result is always the same:

Here is the plugin

JdbcDataSourceDBIX
ARDBC
JAVA
C:/Program Files/BMC 
Software/ARSystem/Arserver/api/javaplugins/BECplugins/arapi.jar

com.bmc.arsys.plugins.jdbc.JdbcDataSource

C:/Programmer/IBM/SQLLIB/TOOLS/db2jdbcext.jar

jdbc:db2:TD99

COM.ibm.db2.jdbc.app.DB2Driver






The thread quits with a nullPointerException, when the getTables method is 
called, which leads me to think that there is something going wrong in the 
initialize function. Unfortunately initialize is called so soon after starting 
the server, that i cannot connect the debugger fast enough to debug it.
Here is a snippet from the logs which puzzles me:

2009-06-30 09:23:31,695 INFO  [main] com.bmc.arsys.pluginsvr.plugins.g (?:?) - 
No static init routine found, skipping init call - JdbcDataSourceDBIX
2009-06-30 09:23:31,695 DEBUG [main] com.bmc.arsys.pluginsvr.plugins.g (?:?) - 
Failed  found init plugin JdbcDataSourceDBIX
2009-06-30 09:23:31,695 INFO  [main] com.bmc.arsys.pluginsvr.plugins.g (?:?) - 
Done  to call init plugin JdbcDataSourceDBIX

Is it looking for an init routine? I can't seem to find any references in the 
API documentation, other than the initialize method!? Or is it skipping the 
method it found?

I have not modified the code found on the bmc developer site, and as far as I 
can see others have used it successfully - what am I doing wrong?


And here the logs for that attempt:

2009-06-30 09:23:31,054 INFO  [main] com.bmc.arsys.pluginsvr.f (?:?) - Loading 
the Configuration File 
::file:/C:/Program%20Files/BMC%20Software/ARSystem/pluginsvr/pluginsvr_config.xml
2009-06-30 09:23:31,070 ERROR [main] com.bmc.arsys.pluginsvr.f (?:?) - Java 
plug-in server does not support C plug-ins. Contact Customer Support for 
details.
2009-06-30 09:23:31,070 DEBUG [main] com.bmc.arsys.pluginsvr.f (?:?) - Plugin 
Accessible Configured Values:
2009-06-30 09:23:31,070 DEBUG [main] com.bmc.arsys.pluginsvr.f (?:?) - port 
2009-06-30 09:23:31,070 DEBUG [main] com.bmc.arsys.pluginsvr.f (?:?) - 
numCoreThreads 5
2009-06-30 09:23:31,211 WARN  [main] 
org.apache.commons.configuration.ConfigurationFactory$FileConfigurationFactory 
(ConfigurationFactory.java:530) - Could not load optional configuration 
arsys_api.xml
2009-06-30 09:23:31,304 DEBUG [main] com.bmc.arsys.pluginsvr.c.a (?:?) - 
os.name<http://os.name/>: Windows 2003
2009-06-30 09:23:31,304 DEBUG [main] com.bmc.arsys.pluginsvr.c.a (?:?) - 
os.arch: x86
2009-06-30 09:23:31,304 DEBUG [main] com.bmc.arsys.pluginsvr.c.a (?:?) - 
java.vendor: Sun Microsystems Inc.
2009-06-30 09:23:31,304 DEBUG [main] com.bmc.arsys.pluginsvr.c.a (?:?) - 
Constructor ARPluginServerEncryptionInfo
2009-06-30 09:23:31,648 INFO  [main] com.bmc.arsys.pluginsvr.plugins.g (?:?) - 
Loading all Java Plugins and Plugin sets
2009-06-30 09:23:31,648 INFO  [main] com.bmc.arsys.pluginsvr.plugins.g (?:?) - 
Attempting to load Java Plugin JdbcDataSourceDBIX
2009-06-30 09:23:31,648 INFO  [main] com.bmc.arsys.pluginsvr.pl

SV: Java ARDBC

[Jonas Stumph Stevnsvig]

Hi Jarl,
Thanks for the detailed response.

I had disabled running the java plugin server through armonitor and set it up 
to listen on port 8000 for debuggers. The trouble was that the initialize 
function was called a long time before I could attach the dbugger using my IDE.

Fortunately we had a breakthrough late last night - it turned out that it was a 
mismatch in the name of the JDBC driver and the jar file we had indicated.

This morning we have a connection to the Database, and only need to modify the 
code to talk to DB2 instead of MSSQL

Thanks for all the help.

Best regards,

Jonas

-Oprindelig meddelelse-
Fra: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] På vegne af Jarl Grøneng
Sendt: 30. juni 2009 18:44
Til: arslist@ARSLIST.ORG
Emne: Re: Java ARDBC

Can it be that the gettable return no tables, then you get a nullpointer?

Here is some information from Appajee on how to attach at debugger to a plugin:
--
At this point, its debugger time!! :-)

Assuming you're using Eclipse as your Java IDE, following information may 
be useful in debugging your plug-in :

The java plugin server is typically started by the armonitor, which also starts 
all other ARSystem processes.  The armonitor starts all processes listed in a 
file /conf/armonitor.conf
or cfg.  So instead of the pain of restarting the whole ARServer while 
debugging or plugin development process, you can just comment out (put a # at 
the start of the line) the line that looks like below from your armonitor.conf 
file.
"C:\Program Files\Java\jre1.6.0_03\bin\java" -Xmx512m -classpath 
"...whatever... arpluginsvr71.jar" 
com.bmc.arsys.pluginsvr.ARPluginServerMain -x YourServerHere -i 
"YourInstallDir" -m

Restart server/the service.  So monitor won't start java plugin server anymore. 
 Now you can start the java plugin server from command line.
For that you would just copy the command line from the armonitor.cfg and use in 
the command prompt.
Now for debugging, we mostly use the jvm remote debugging mechanism.
You would add this jvm debugging options (below) to the java command line
 -Xdebug -Xrunjdwp:transport=dt_socket,address=8000,suspend=n,server=y
to get the command line as:
"C:\Program Files\Java\jre1.6.0_03\bin\java" -Xmx512m 
-Xrunjdwp:transport=dt_socket,address=8000,suspend=n,server=y
-classpath "...whatever... arpluginsvr71.jar" 
com.bmc.arsys.pluginsvr.ARPluginServerMain -x YourHostNameHere -i 
"YourInstallDir" -m

To attach the Eclipse debugger to the process, it has to be told which machine 
the external program is running on and what port it can use to communicate with 
it. This information is entered through the Launcher dialog. Select from the 
main menu Run, Debug to open the Launcher dialog specific to debugging. Select 
Remote Java Application as the configuration type and click New. This 
configuration information will be used by the debugger to connect to the plugin 
server jvm. Enter the following configuration information:

Name: Java Plugin Server
Project: My Plugin Project
Connection Type: Standard (Socket Attach) Connection Properties: Host: 
localhost Connection Properties: Port: 8000

Setup breakpoints in your plugin as needed, and click Debug to start up the 
debugger. Key things here are matching up the host name and debug port (8000 in 
my example) between your Java command line and the eclipse debugger.

Hope that helps.

Appajee
--


Regards,
Jarl

2009/6/30 Jonas Stumph Stevnsvig :
> **
> Hi listers
>
> As some of you may have noticed - I've been battling to get some ARDBC 
> connections up and running. After plenty of reading and advice, and 
> considerable problems with our C developer tools, I've decided to 
> switch to Java. I started off by downloading the 7.1 Java ARDBC/filter 
> plugin sample from http://developer.bmc.com/communities/docs/DOC-2548 
> . Unfortunately I cannot get the code to work as intended. I have 
> tried with several different JDBC drivers, and the  result is always the same:
>
> Here is the plugin
> 
>     JdbcDataSourceDBIX
>     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/TOOLS/db2jdbcext.jar ment>
>     
>     jdbc:db2:TD99
>     
>
> COM.ibm.db2.jdbc.app.DB2Driver
>     
>     
>
>     
>     
>
> The thread quits with a nullPointerE

SV: Java ARDBC

[Jonas Stumph Stevnsvig]

Hi Carey

The API actually offers a log4j configuration interface, apparently I have 
misconfigured it, since I did not get anything out of it. 




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 Carey Matthew Black
Sendt: 30. juni 2009 14:03
Til: arslist@ARSLIST.ORG
Emne: Re: Java ARDBC

Jonas,

I must start by saying that I have not yet had a need to play with the ARDBC 
API.

However, this part of your post caught my eye...

"I started off by downloading the 7.1 Java ARDBC/filter plugin sample from 
http://developer.bmc.com/communities/docs/DOC-2548.";

VS

" I'm running ARS 7.5 on win2k3 "

If you are using a "major release"(7.1 vs 7.5) newer of the ARS server (and 
likely the plug in server too) then I would suggest that you at least start 
with the v7.5 Java API. You may simply be struggling with differences between 
the two versions.

Beyond that..

I would try to hunt down the null pointer exception. :) I know it sounds 
dumb... but at least make your code fail in a better way. If you have not yet 
used it, I would suggest the use of log4j ( http://logging.apache.org/log4j/ ) 
to produce a good way to do logging outside of the ARS API. (Although you may 
be able to use the Java API to do logging functions too. I think I remember 
seeing some details about that in the v7.5 api docs.)

HTH.

--
Carey Matthew Black
BMC Remedy AR System Skilled Professional (RSP) ARS = Action Request 
System(Remedy)

Love, then teach
Solution = People + Process + Tools
Fast, Accurate, Cheap Pick two.

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

Migrator messing up with locale

[Jonas Stumph Stevnsvig]

Hi everyone

has anyone experienced problems with the remedy migrator tool?

we keep encountering problems relating to a non-terminated string for about 5% 
of the migrated forms (always the same 5%):
/* fr jul 10 2009 14:02:00.5520 */UPDATE vui SET vuiName=N'Default Admin 
View',locale=N'$,owner=N'someuser',lastChanged=N'someotheruser',timestamp=1247227320
 WHERE schemaId=414 AND vuiId=536870912
*** ERROR ***  Unclosed quotation mark after the character string 
',timestamp=1247227320 WHERE schemaId=414 AND vuiId=536870912'. (SQL Server 
105)Incorrect syntax near 'someuser'. (SQL Server 102)

The locale field has not been set, and sometimes it helps to set it and then 
delete it - for other forms it still doesn't work, and we have to write a 
locale in the field to migrate.

My guess is that there is some sort of delimiter problem in the migrator, but 
does anyone else experience it?

We're running ARS 7.5 on a MSSQL 2005 Cluster with migrator 7.5




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

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

SV: Migrator messing up with locale

[Jonas Stumph Stevnsvig]

Hi guys,

I haven't discovered any similarity other than the fact that they have all been 
previously migrated to the first 7.5 server from a 6.3 server.

With regards to the missing fields - I have done extensive comparisons, and 
haven't found any fields missing (the majority of our problems with this 
migration is that previous remedy developers have had a nasty habit of 
modifying core forms).

Jarl: you mentioned recreating the vui - could you explain a bit more detailed 
what you mean please?


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: 10. juli 2009 14:52
Til: arslist@ARSLIST.ORG
Emne: Re: Migrator messing up with locale

Hi,

Shot in the dark;

Is there any similarity of the forms? Are those forms created by an earlier 
version of AR System, or by the new version.

Does the same happend if you recreate the vui?

Regards,
Jarl



2009/7/10 Jonas Stumph Stevnsvig :
> **
> Hi everyone
>
> has anyone experienced problems with the remedy migrator tool?
>
> we keep encountering problems relating to a non-terminated string for 
> about 5% of the migrated forms (always the same 5%):
> /* fr jul 10 2009 14:02:00.5520 */UPDATE vui SET vuiName=N'Default 
> Admin 
> View',locale=N'$,owner=N'someuser',lastChanged=N'someotheruser',timest
> amp=1247227320 WHERE schemaId=414 AND vuiId=536870912
> *** ERROR ***  Unclosed quotation mark after the character string 
> ',timestamp=1247227320 WHERE schemaId=414 AND vuiId=536870912'. (SQL 
> Server 105)Incorrect syntax near 'someuser'. (SQL Server 102)
>
> The locale field has not been set, and sometimes it helps to set it 
> and then delete it - for other forms it still doesn't work, and we 
> have to write a locale in the field to migrate.
>
> My guess is that there is some sort of delimiter problem in the 
> migrator, but does anyone else experience it?
>
> We're running ARS 7.5 on a MSSQL 2005 Cluster with migrator 7.5
>
>
>
> 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
>
> _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"

SV: Migrator messing up with locale

[Jonas Stumph Stevnsvig]

Ah - thanks.
Seems to work.

Regards, 

Jonas

-Oprindelig meddelelse-
Fra: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] På vegne af Jarl Grøneng
Sendt: 14. juli 2009 19:24
Til: arslist@ARSLIST.ORG
Emne: Re: Migrator messing up with locale

Copy the view you got of the form, then delete the old view.


Regards,
Jarl



2009/7/13 Jonas Stumph Stevnsvig :
> Hi guys,
>
> I haven't discovered any similarity other than the fact that they have all 
> been previously migrated to the first 7.5 server from a 6.3 server.
>
> With regards to the missing fields - I have done extensive comparisons, and 
> haven't found any fields missing (the majority of our problems with this 
> migration is that previous remedy developers have had a nasty habit of 
> modifying core forms).
>
> Jarl: you mentioned recreating the vui - could you explain a bit more 
> detailed what you mean please?
>
>
> 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: 10. juli 2009 14:52
> Til: arslist@ARSLIST.ORG
> Emne: Re: Migrator messing up with locale
>
> Hi,
>
> Shot in the dark;
>
> Is there any similarity of the forms? Are those forms created by an earlier 
> version of AR System, or by the new version.
>
> Does the same happend if you recreate the vui?
>
> Regards,
> Jarl
>
>
>
> 2009/7/10 Jonas Stumph Stevnsvig :
>> **
>> Hi everyone
>>
>> has anyone experienced problems with the remedy migrator tool?
>>
>> we keep encountering problems relating to a non-terminated string for 
>> about 5% of the migrated forms (always the same 5%):
>> /* fr jul 10 2009 14:02:00.5520 */UPDATE vui SET vuiName=N'Default 
>> Admin 
>> View',locale=N'$,owner=N'someuser',lastChanged=N'someotheruser',times
>> t amp=1247227320 WHERE schemaId=414 AND vuiId=536870912
>> *** ERROR ***  Unclosed quotation mark after the character string 
>> ',timestamp=1247227320 WHERE schemaId=414 AND vuiId=536870912'. (SQL 
>> Server 105)Incorrect syntax near 'someuser'. (SQL Server 102)
>>
>> The locale field has not been set, and sometimes it helps to set it 
>> and then delete it - for other forms it still doesn't work, and we 
>> have to write a locale in the field to migrate.
>>
>> My guess is that there is some sort of delimiter problem in the 
>> migrator, but does anyone else experience it?
>>
>> We're running ARS 7.5 on a MSSQL 2005 Cluster with migrator 7.5
>>
>>
>>
>> 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
>>
>> _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"
>

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

SV: DEF File Manipulator

[Jonas Stumph Stevnsvig]

It might be overkill, but I think that the Remedy Migrator package offers 
extensive def file manipulation.



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 Frank Caruso
Sendt: 15. juli 2009 10:41
Til: arslist@ARSLIST.ORG
Emne: DEF File Manipulator

**
Is there a utility that will allow me to easily remove objects from a DEF file?

Would like to be able to view all of the objects in a DEF file and selectively 
remove items. I could manually edit the file but I have had issues with this in 
the past.

Thank you.

Frank
_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"

Packing lists

[Jonas Stumph Stevnsvig]

Hi people,

We have tight functional seperation in our company, which for instance means 
that we as developers do not have admin rights to the production system, which 
in turn means that we have to give detailed information to our Remedy platform 
administrators about which objects to migrate, in case of a change.

To facilitate that work, we have talked about loading modified objects related 
to a change into packing lists, and using those as documentation of the change. 
Now to my question:
- How does Remedy store the Packing lists? - I presume that it's a table (or 
tables) in the database, which I can access using a view form, and make some 
reporting on; to attach to the changes?




with regards,



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



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

SV: Packing lists

[Jonas Stumph Stevnsvig]

Hi Carey, Peter, Ben, 

Thank you for the responses. My idea of going to the database was just the only 
way I had envisioned the solution - it is far too complex. I am now hooked om 
the XML solution, which contains exactly what I needed. After your posst, I 
investigated the export to XML, and realised that there was an "Save as 
Import/Export command" which basically exports the titles of all the objects  
attached to the packing list, which was basically what I needed.


Thanks for the help.



with regards,



Jonas Stumph Stevnsvig
Remedy Developer
BEC 
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 Carey Matthew Black
Sendt: 16. juli 2009 15:06
Til: arslist@ARSLIST.ORG
Emne: Re: Packing lists

Jonas Stumph Stevnsvig,

I am not sure why you would want to go to the DB to get this information. Often 
if you better define the details of what information you need, instead of how 
you think you need to get it, then you can get a better (for focused) response 
to those needs.

If you want to get it programmatically, then I suggest you use the ARS API to 
get this information. (And let the application server deal with the DB end of 
things.)

However, there are several ways to serialize ARS objects with standard ARS 
tools that may serve your needs too. Peter points out one way.
Another would be to use the XML object def file and use XSLT transformations to 
get any detail about the objects in the list too. ( For example if you need to 
document "last changed" date and time values in the change process then you 
could get to that level of detail this way. You could even translate the entire 
object into text for the reviewers to read through the If ... then... else 
logic of the workflow too. It just mean more XSLT transformation work.)

Hope that helps.

Oh. Another way that I have considered dealing with this kind of separation is 
to more heavily use ARS deployable applications. They would also provide a way 
to move data along with the objects. This feature may drastically reduce the 
number of steps that your production support team needs to do to make the 
changes on production.

The packing list is a good way to keep, well, a list. However the deployable 
application is a more holistic approach to ARS applications than just a list of 
objects. They do have their own downsides however, so be warned that is may not 
be as obvious how to develop with this methodology as it might first appear.

--
Carey Matthew Black
BMC Remedy AR System Skilled Professional (RSP) ARS = Action Request 
System(Remedy)

Love, then teach
Solution = People + Process + Tools
Fast, Accurate, Cheap Pick two.



On Thu, Jul 16, 2009 at 8:03 AM, Lammey, Peter A. 
wrote:
> **
> What I do with the Packing List in order to document it for a release 
> is open up the Packing List and then you can export the list into XML.
> When you open the Packing List in XML using Excel then you can get 
> columns of cells that contain the Forms, Active Links, Filters, etc 
> that are included in the Packing List that you can then copy and paste 
> into a Change request for your release.
>
>
> Thanks
> Peter Lammey
> ESPN IT Client Architecture and Automation
> 860-766-4761
>
>
> 
> From: Action Request System discussion list(ARSList) 
> [mailto:arsl...@arslist.org] On Behalf Of Jonas Stumph Stevnsvig
> Sent: Thursday, July 16, 2009 5:45 AM
> To: arslist@ARSLIST.ORG
> Subject: Packing lists
>
> **
> Hi people,
>
> We have tight functional seperation in our company, which for instance 
> means that we as developers do not have admin rights to the production 
> system, which in turn means that we have to give detailed information 
> to our Remedy platform administrators about which objects to migrate, in case 
> of a change.
>
> To facilitate that work, we have talked about loading modified objects 
> related to a change into packing lists, and using those as 
> documentation of the change. Now to my question:
> - How does Remedy store the Packing lists? - I presume that it's a 
> table (or
> tables) in the database, which I can access using a view form, and 
> make some reporting on; to attach to the changes?
>
>
> with regards,
>
> Jonas Stumph Stevnsvig
> Remedy Developer
> BEC
> Phone  (+45) 46 38 20 08
> Mobile  (+45) 61 56 20 08
> jonas.stumph.stevns...@bec.dk
> becrem...@bec.dk

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

ARERR 91

[Jonas Stumph Stevnsvig]

Hi listers.

I have an ARDBC plugin (java based) which is working fine on most of our vendor 
forms. Except one. I have One form, on which I cannot add extra fields; when I 
right click and choose Add fileds from  I don't get the list of 
fields, but the following error:

ERROR (91): RPC call failed; RPC: can't decode result (ARERR 91)

The AR Error message guide reccomends API logging. But I am getting the error 
in the developer studio - not in the User tool.

I have been able to circumvent the error by duplicating an existing field, and 
correcting its data to suit my purposes.

Have any of you experienced similar errors?`




with regards,



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



quote from the AR error message guide:

91

Error

RPC call failed.

AR System clients use the RPC layer to connect to the AR System server's TCP 
port. This error

occurs when an RPC call fails for some reason. Some possible causes of this 
error include but are

not limited to:


 An invalid RPC packet was detected

...

If this is a recurring error, and increasing the file descriptors or file 
handles available to the

AR System server does not resolve the problem, turn on ARAPILOGGING for the 
client that

receives the error to isolate the API call that is failing with ARERR 91. For 
information about how

to configure and use client-side API logging, see the Optimizing and 
Troubleshooting Guide.

A less common cause of this error is running an API program that is 
incompatible with the AR

System server. In this case, recompiling the API program with the same API 
version used by the

AR System server might resolve the error.

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

SV: ARERR 91

[Jonas Stumph Stevnsvig]

 
Hi Jarl.

Worked like a charm. Now to debug...

You have certainly helped me out a few times - I'll buy you a beer or two if we 
meet some day.

Have a nice weekend.



with regards, 



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



-Oprindelig meddelelse-
Fra: Jarl Grøneng [mailto:jarl.gron...@gmail.com] 
Sendt: 23. februar 2010 09:27
Emne: Re: ARERR 91

HI,

Rename the arsys_sample.xml file to arsys_api.xml. The file is located
here: (depending on your installation)
C:\Program Files\BMC
Software\ARSystem\DeveloperStudio\plugins\com.bmc.arsys.studio.api_7.5.0

Edit the file like his:


arcatalog
10
0
1000

com.bmc.arsys.api.NoPrefixToStringStyle.NO_PREFIX_STYLE
false
false
24
1


*Note the 24 section.

Restart developer studio. The logfiles gets created here:
C:\Program Files\BMC Software\ARSystem\DeveloperStudio

Regards,
Jarl


2010/2/23 Jonas Stumph Stevnsvig :
> **
> Hi listers.
>
> I have an ARDBC plugin (java based) which is working fine on most of 
> our vendor forms. Except one. I have One form, on which I cannot add 
> extra fields; when I right click and choose Add fileds from 
>  I don't get the list of fields, but the following error:
>
> ERROR (91): RPC call failed; RPC: can't decode result (ARERR 91)
>
> The AR Error message guide reccomends API logging. But I am getting 
> the error in the developer studio - not in the User tool.
>
> I have been able to circumvent the error by duplicating an existing 
> field, and correcting its data to suit my purposes.
>
> Have any of you experienced similar errors?`
>
>
>
> with regards,
>
> Jonas Stumph Stevnsvig
> Remedy Developer
> BEC
> Phone  (+45) 46 38 20 08
> Mobile  (+45) 61 56 20 08
> jonas.stumph.stevns...@bec.dk
> becrem...@bec.dk
>
>
>
> quote from the AR error message guide:
>
> 91
>
> Error
>
> RPC call failed.
>
> AR System clients use the RPC layer to connect to the AR System 
> server's TCP port. This error
>
> occurs when an RPC call fails for some reason. Some possible causes of 
> this error include but are
>
> not limited to:
>
> An invalid RPC packet was detected
>
> ...
>
> If this is a recurring error, and increasing the file descriptors or 
> file handles available to the
>
> AR System server does not resolve the problem, turn on ARAPILOGGING 
> for the client that
>
> receives the error to isolate the API call that is failing with ARERR 91.
> For information about how
>
> to configure and use client-side API logging, see the Optimizing and 
> Troubleshooting Guide.
>
> A less common cause of this error is running an API program that is 
> incompatible with the AR
>
> System server. In this case, recompiling the API program with the same 
> API version used by the
>
> AR System server might resolve the error.
>
> _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"

ARERR 9350 on vendor forms in mid tier

[Jonas Stumph Stevnsvig]

Hi listers,

We are experiencing some odd. We have a Remedy application which pushes records 
to a Vendor form on submit, which works fine.
unfortunately all our forms which read from a vendor form halt with ARERR 9350 
on the midtier - they all work without problems in the User Tool.

Even opening a vendor form directly and doing a search gives the same error.


ARERR 9350 form the manual:

Network protocol/data error when performing data operation. Please contact 
administrator.

An internal error occurred because parameters passed to the back channel were 
incorrect.

I<http://communities.bmc.com/communities/message/84278#84278> have searched 
aruond, but been unable to find a solution to the problem.

Do any of you have a suggestion or two?




with regards,



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

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

Re: ARERR 9350 on vendor forms in mid tier

[Jonas Stumph Stevnsvig]

Hi

it' tomcat 6.0 , the one bundled with the ars 7.5  server (of which we are 
running path 3)


with regards,



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




Fra: Frank Caruso [mailto:caruso.fr...@gmail.com]
Sendt: 5. marts 2010 12:13
Emne: Re: ARERR 9350 on vendor forms in mid tier

**
What version?

On Fri, Mar 5, 2010 at 2:07 PM, Jonas Stumph Stevnsvig 
mailto:jonas.stumph.stevns...@bec.dk>> wrote:
**
Hi listers,

We are experiencing some odd. We have a Remedy application which pushes records 
to a Vendor form on submit, which works fine.
unfortunately all our forms which read from a vendor form halt with ARERR 9350 
on the midtier - they all work without problems in the User Tool.

Even opening a vendor form directly and doing a search gives the same error.


ARERR 9350 form the manual:

Network protocol/data error when performing data operation. Please contact 
administrator.

An internal error occurred because parameters passed to the back channel were 
incorrect.

I<http://communities.bmc.com/communities/message/84278#84278> have searched 
aruond, but been unable to find a solution to the problem.

Do any of you have a suggestion or two?




with regards,



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

_Platinum Sponsor: rmisoluti...@verizon.net<mailto: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
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

ODBC not returning the expected values from Incident form

[Jonas Stumph Stevnsvig]

Hi listers

I have an interesting problem.

I have been tasked with fetching some data from HPD:Help Desk (ITSM v
7.6.03 both client and ARS server, v 7.6.03)

I ran into an oddity; When Fetching data through ODC (I used Excel to
start with) I only got about 1000 Records. But i expected 12000. I then
removed a couple of fields from the list of those i wanted returned, and
received the full 12k.

To further investigate I copied the connection string and SQL to a vbs
script I had for another purpose, and altered the sql to find the culprit.

By only altering the FROM part of the SQL clause (note - no WHERE clause
at all) I got significantly different results (see below)


My question is: have any of you experienced this?

I hope that is is something to do with data corruption (and then again I
pray that it isn't), since if it's not corrupted data, the ODBC driver is
not to be trusted to provide correct data, which would be catastrophic.


** SELECT with approx 60 records
SELECT
 *
FROM
 HPD_Help_Desk
ORDER BY
 Incident_Number DESC

** SELECT with approx 1000 records
SELECT
 Incident_Number,
 Product_Categorization_Tier_1, Product_Categorization_Tier_2,
Product_Categorization_Tier_3,
 First_Name, Last_Name, Site, Status, Priority, Assignee, Assigned_Group,
Assignee_Login_ID,
 Categorization_Tier_1, Categorization_Tier_2, Categorization_Tier_3,
 Corporate_ID, Reported_Source, Service_Type, Submit_Date, Submitter
FROM
 HPD_Help_Desk
ORDER BY
 Incident_Number DESC

** SELECT with approx 9500 records
SELECT
 Incident_Number,
 Product_Categorization_Tier_1, Product_Categorization_Tier_2,
Product_Categorization_Tier_3,
 First_Name, Last_Name, Site, Status, Priority, Assignee, Assigned_Group,
Assignee_Login_ID,
 Categorization_Tier_1, Categorization_Tier_2, Categorization_Tier_3,
 Corporate_ID, Reported_Source, Submit_Date, Submitter
FROM
 HPD_Help_Desk
ORDER BY
 Incident_Number DESC




** FULL VBS SCRIPT BELOW HERE 


Dim objConnection
Dim sql_query, strOutputLine
Dim arrInputLine, strInputLine
Dim objFSO, objOutFile
Dim intCount, intCountNumber
Dim currDir, connStr
Dim fso, folder, files, NewsFile,sFolder, strFileName
Dim bolDEBUG
Dim strServer, strUser, strPass, strPort

'For DB connections
Const adOpenStatic = 3, adLockOptimistic = 3

'bolDEBUG Flag
bolDEBUG = false

'Define variables for folders and files
Set objFSO = CreateObject("Scripting.FileSystemObject")
Const ForReading = 1, ForWriting = 2, ForAppending = 8

currDir   = CreateObject("Wscript.shell").currentdirectory
dbFile= currDir & "\RKS-Medlemmer.mdb"
inputDir  = currDir & "\Input"
strFileName = "Output_" & Date & "_" & DatePart("h", Now) & "-" &
DatePart("n", Now) & "-" & DatePart("s", Now) & ".csv"
Set objOutFile = objFSO.OpenTextFile(strFileName, ForAppending, True)

'Set Variables for connection
strServer = "servername"
strUser = "username"
strPass = "password"
strPort = "5500"

'build Connection String
connStr = "DRIVER={AR System ODBC Driver};ARUseUnderscores=1;ARServer=" &
strServer & ";" & _
"ARServerPort=" & strPort & ";" & _
"UID=" & strUser & ";" & _
"PWD=" & strPass & ";" & _
"ARAuthentication=;SERVER=NotTheServer"

'** SELECT with approx 60 records

'sql_query = "SELECT " & _
'"* " & _
'"FROM HPD_Help_Desk " & _
'"ORDER BY Incident_Number DESC"

'** SELECT with approx 1000 records

'sql_query = "SELECT " & _
'   "Incident_Number, " & _
'   "Product_Categorization_Tier_1, Product_Categorization_Tier_2,
Product_Categorization_Tier_3, " & _
'   "First_Name, " & _
'   "Last_Name, " & _
'   "Site, " & _
'   "Status, " & _
'   "Priority, " & _
'   "Assignee, " & _
'   "Assigned_Group, " & _
'   "Assignee_Login_ID, " & _
'   "Categorization_Tier_1, Categorization_Tier_2, Categorization_Tier_3, " 
& _
'   "Corporate_ID, " & _
'   "Reported_Source, " & _
'   "Service_Type, " & _

'potential culprit!!!
'   "Submit_Date, " & _
'   "Submitter " & _
'"FROM HPD_Help_Desk " & _
'"ORDER BY Incident_Number DESC"


'** SELECT with approx 1000 records
sql_query = "SELECT " & _
"Incident_Number, " & _
"Product_Categorization_Tier_1, Product_Categorization_Tier_2,
Product_Categorization_Tier_3, " & _
"First_Name, " & _
"Last_Name, " & _
"Site, " & _
"Status, " & _
"Priority, " & _
"Assignee, " & _
"Assigned_Group, " & _
"Assignee_Login_ID, " & _
"Categorization_Tier_1, Categorization_Tier_2, Categorization_Tier_3, " 
& _
"Corporate_ID, " & _
"Reported_Source, " & _
"Submit_Date, " & _
"Submitter " & _
"FROM HPD_Help_Desk " & _
"ORDER BY Incident_Number DESC"

 '** Dump the data
 set objConnection = CreateObject("ADODB.Connection")  'create and
open O

Re: ODBC not returning the expected values from Incident form

[Jonas Stumph stevnsvig]

Hi again.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Re: ODBC not returning the expected values from Incident form

[Jonas Stumph stevnsvig]

Hi again.

I am still fiddling with this problem, concering ARODBC and the number 
of records to be returned.


I and querying the incident form on a server with 12000 records, and 
getting very big variations in how many records are being returned. I 
started in excel, and moved to VBscript to  1) ascertain whether it was 
an excel or ARODBC error. and 2)



** SELECT with approximately 60 records returned, of 12000 total
SELECT
 *
FROM
 HPD_Help_Desk
ORDER BY
 Incident_Number DESC

** SELECT with approximately 1000 records returned, of 12000 total
SELECT
 Incident_Number,
 Product_Categorization_Tier_1,
 Product_Categorization_Tier_2,
 Product_Categorization_Tier_3,
 First_Name,
 Last_Name,
 Site,
 Status,
 Priority,
 Assignee,
 Assigned_Group,
 Assignee_Login_ID,
 Categorization_Tier_1,
 Categorization_Tier_2,
 Categorization_Tier_3,
 Corporate_ID,
 Reported_Source,
 Service_Type,
 Submit_Date,
 Submitter
FROM
 HPD_Help_Desk
ORDER BY
 Incident_Number DESC

** SELECT with approximately 9500 records returned, of 12000 total
SELECT
 Incident_Number,
 Product_Categorization_Tier_1,
 Product_Categorization_Tier_2,
 Product_Categorization_Tier_3,
 First_Name,
 Last_Name,
 Site,
 Status,
 Priority,
 Assignee,
 Assigned_Group,
 Assignee_Login_ID,
 Categorization_Tier_1,
 Categorization_Tier_2,
 Categorization_Tier_3,
 Corporate_ID,
 Reported_Source,
 Submit_Date,
 Submitter
FROM
 HPD_Help_Desk
ORDER BY
 Incident_Number DESC

 ** SELECT with 12000 records returned, of 12000 total
SELECT
 Incident_Number,
 Product_Categorization_Tier_1,
 Product_Categorization_Tier_2,
 Product_Categorization_Tier_3,
 First_Name,
 Last_Name,
 Site,
 Status,
 Priority,
 Assignee,
 Assigned_Group,
 Assignee_Login_ID,
 Corporate_ID,
 Reported_Source,
 Submit_Date,
 Submitter
FROM
 HPD_Help_Desk
ORDER BY
 Incident_Number DESC

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Re: ODBC not returning the expected values from Incident form

[Jonas Stumph stevnsvig]

Hi again, I'll try not to hit ctrl+enter again... sorry for the triple 
posts.



I am still fiddling with this problem, concering ARODBC and the number
of records to be returned.

I and querying the incident form on a server with 12000 records, and
getting very big variations in how many records are being returned. I
started in excel, and moved to VBscript to
1) ascertain whether it was an excel or ARODBC error.
and
2) to be able to correct and experiment faster than waiting for the GUIs in the 
ODBC system in excel to refresh.

I have tried several different variations of where clauses, as previously suggested 
(eg. WHERE Incident_Number<>  'ThisOldString') but to no avail.

BMC support is misunderstanding me, and thinks that I am trying on different 
databases, wih different numbers of records, so I have tried to clarfy my query 
to them.

Does anyone else have any ideas of what else I can try?

Best regards, Jonas Stevnsvig


** SELECT with approximately 60 records returned, of 12000 total
SELECT
 *
FROM
 HPD_Help_Desk
ORDER BY
 Incident_Number DESC

** SELECT with approximately 1000 records returned, of 12000 total
SELECT
 Incident_Number,
 Product_Categorization_Tier_1,
 Product_Categorization_Tier_2,
 Product_Categorization_Tier_3,
 First_Name,
 Last_Name,
 Site,
 Status,
 Priority,
 Assignee,
 Assigned_Group,
 Assignee_Login_ID,
 Categorization_Tier_1,
 Categorization_Tier_2,
 Categorization_Tier_3,
 Corporate_ID,
 Reported_Source,
 Service_Type,
 Submit_Date,
 Submitter
FROM
 HPD_Help_Desk
ORDER BY
 Incident_Number DESC

** SELECT with approximately 9500 records returned, of 12000 total
SELECT
 Incident_Number,
 Product_Categorization_Tier_1,
 Product_Categorization_Tier_2,
 Product_Categorization_Tier_3,
 First_Name,
 Last_Name,
 Site,
 Status,
 Priority,
 Assignee,
 Assigned_Group,
 Assignee_Login_ID,
 Categorization_Tier_1,
 Categorization_Tier_2,
 Categorization_Tier_3,
 Corporate_ID,
 Reported_Source,
 Submit_Date,
 Submitter
FROM
 HPD_Help_Desk
ORDER BY
 Incident_Number DESC

 ** SELECT with 12000 records returned, of 12000 total
SELECT
 Incident_Number,
 Product_Categorization_Tier_1,
 Product_Categorization_Tier_2,
 Product_Categorization_Tier_3,
 First_Name,
 Last_Name,
 Site,
 Status,
 Priority,
 Assignee,
 Assigned_Group,
 Assignee_Login_ID,
 Corporate_ID,
 Reported_Source,
 Submit_Date,
 Submitter
FROM
 HPD_Help_Desk
ORDER BY
 Incident_Number DESC

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Re: Separation of Admin and Development Duties

[Jonas Stumph Stevnsvig]

My previous place of employment had similar protocols. To ensure 
quality, We had four environments:
Development, which is the ONLY environment on which the Devs have admin 
rights.
Test, which is in theory the Admin's olayground - a place to test 
patches, and so on, so that the Admin does not obstruct the DEVs work.
Pre-Production, which was used for End-user accept testing before 
production.

and of course, Production.

Besides this, we used object reservation on all servers, with system 
forms locked by a per-server account, to prevent accidental modification 
(we had a strict policy of not altering system forms).
The different tiers also means that basic things such as user privileges 
and server configuration changes are well described, since the Devs are 
forced to test on environments where they have no admin rights.


We had one further modification; all the Admin forms the Devs would need 
access to in order to troubleshoot were given an extra permission group, 
which the Devs would get on their PRod user.


Hope this is inspiration.

best regards,

Jonas Stevnsvig

Den 05-08-2011 21:31, Arner, Todd skrev:

**

We have been given a directive to separate the Remedy Development and 
Administrative functions.  Basically, we have been instructed to come 
up with a way to ensure that no one person can make development 
changes and also be able to set up users accounts.  We currently split 
the roles between two groups so that no one person is doing both, 
however, since the developers and admins have Administrator 
privileges, there is nothing stopping either from performing all 
functions.


Does anyone else out there have a similar requirement?  If so, can you 
share your solution?


I am just not seeing a way to do this.  Or maybe I just don't want to 
see the way. :)  Seems to me both rolls need to have Administrator 
privileges to complete their tasks.


Any insight is greatly appreciated.

ARS 7.5 p7
MS SQL 2005
Windows 2003 SP2

Thanks,
Todd Arner
Great Lakes


The information contained in this communication may be confidential, is intended
only for the use of the recipient(s) named above, and may be legally
privileged.  If the reader of this message is not the intended recipient, you
are hereby notified that any dissemination, distribution, or copying of this
communication, or any of its contents, is strictly prohibited.  If you have
received this communication in error, please notify the sender immediately and
destroy or delete the original message and any copy of it from your computer
system.  If you have any questions concerning this message, please contact the
sender.

_attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ 



___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Re: Extracting just the API files

[Jonas Stumph Stevnsvig]

Just open the gzip file.

i think i did that one time with the windows' API files - it's not a 
breeze, as you have to navigate through the archived files.


Den 05-08-2011 22:58, L G Robinson skrev:

Hi Folks,

Do you know if it is possible to extract the ARSystem/api directory
from the Linux install without actually running the installer? My
systems guys want to try to build a new ARSPerl for Linux and need the
latest API files. This would be for 7.6.04 for Red Hat.

Thanks.
Larry


Larry Robinson
Remedy Admin / Developer
NC State University
Raleigh, NC
n...@ncsu.edu

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Re: Separation of Admin and Development Duties

[Jonas Stumph Stevnsvig]

OT: At least you get a swiveling chari ;-P

Den 05-08-2011 23:25, patrick zandi skrev:
** Huh !  I must be getting ripped, I have always been told by my 
boss, see that chair? "Yes sir" ... It Swivels..



On Fri, Aug 5, 2011 at 5:08 PM, Jonas Stumph Stevnsvig 
mailto:arsl...@stevnsvig.com>> wrote:


**
My previous place of employment had similar protocols. To ensure
quality, We had four environments:
Development, which is the ONLY environment on which the Devs have
admin rights.
Test, which is in theory the Admin's olayground - a place to test
patches, and so on, so that the Admin does not obstruct the DEVs work.
Pre-Production, which was used for End-user accept testing before
production.
and of course, Production.

Besides this, we used object reservation on all servers, with
system forms locked by a per-server account, to prevent accidental
modification (we had a strict policy of not altering system forms).
The different tiers also means that basic things such as user
privileges and server configuration changes are well described,
since the Devs are forced to test on environments where they have
no admin rights.

We had one further modification; all the Admin forms the Devs
would need access to in order to troubleshoot were given an extra
permission group, which the Devs would get on their PRod user.

Hope this is inspiration.

best regards,

Jonas Stevnsvig

Den 05-08-2011 21:31, Arner, Todd skrev:

**

We have been given a directive to separate the Remedy Development
and Administrative functions.  Basically, we have been instructed
to come up with a way to ensure that no one person can make
development changes and also be able to set up users accounts. 
We currently split the roles between two groups so that no one

person is doing both, however, since the developers and admins
have Administrator privileges, there is nothing stopping either
from performing all functions.

Does anyone else out there have a similar requirement?  If so,
can you share your solution?

I am just not seeing a way to do this.  Or maybe I just don't
want to see the way. :)  Seems to me both rolls need to have
Administrator privileges to complete their tasks.

Any insight is greatly appreciated.

ARS 7.5 p7
MS SQL 2005
Windows 2003 SP2

Thanks,
Todd Arner
Great Lakes



The information contained in this communication may be confidential, is 
intended
only for the use of the recipient(s) named above, and may be legally
privileged.  If the reader of this message is not the intended recipient, 
you
are hereby notified that any dissemination, distribution, or copying of this
communication, or any of its contents, is strictly prohibited.  If you have
received this communication in error, please notify the sender immediately 
and
destroy or delete the original message and any copy of it from your computer
system.  If you have any questions concerning this message, please contact 
the
sender.


_attend WWRUG11 www.wwrug.com <http://www.wwrug.com> ARSlist:
"Where the Answers Are"_ 


_attend WWRUG11 www.wwrug.com <http://www.wwrug.com> ARSlist:
"Where the Answers Are"_




--
Patrick Zandi
_attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ 



___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Re: Def files back up

[Jonas Stumph Stevnsvig]

Hi

Run it without parameters and you get a list.

something like

-u username -x servername -p password -e outputfile.def -Q -T -A -B -C -D
-E -F -G -H

regards

Jonas Stevnsvig
> what are the parameters to the DefinitionExport.bat any help?
>
>
> Regards,
> Pramod
>
> On Mon, Aug 8, 2011 at 7:07 PM, LJ LongWing  wrote:
>
>> **
>>
>> Jaya,
>>
>> I would recommend looking in your dev studio dir for
>> DefinitionExport.bat.
>> I use this daily in my environment to take backups of my system.
>>
>> ** **
>>
>> *From:* Action Request System discussion list(ARSList) [mailto:
>> arslist@ARSLIST.ORG] *On Behalf Of *jaya munjal
>> *Sent:* Sunday, August 07, 2011 9:33 PM
>> *To:* arslist@ARSLIST.ORG
>> *Subject:* Def files back up
>>
>> ** **
>>
>> ** 
>>
>> Hi list
>>
>>  
>>
>> Please can someone suggest whats the best way to take back up of def
>> files
>> on a daily basis. Below is our environment details, we do have a daily
>> DB
>> level back up taken but we would like to take additional def file backs
>> for
>> easy restoration of functionality.
>>
>>  
>>
>> Environment
>>
>>  
>>
>> ARS 7.6.03
>>
>> DB - Oracle 10g
>>
>> OS - Windows 2008 64 bit
>>
>> ITSM 7.6
>>
>>  
>>
>> Thanks
>>
>> Jaya
>>
>> _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_
>> _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_
>>
>
>
>
> --
> Pramod
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
>

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

REP password

[Jonas Stumph Stevnsvig]

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

String to Date

[Jonas Stumph Stevnsvig]

Hi all

I am having a spot of trouble with strings and dates...

I have an import which gives me dates in the following format: MMDD,
and puts them in a Character field.

I want to parse the date, so i created a setfields action with a value of
SUBSTR($ImportedDateCharField$, 6, 7) + "-") +
SUBSTR($ImportedDateCharField$, 4, 5)) + "-") +
SUBSTR($ImportedDateCharField$, 0, 3)) + " 01:00:00"

If this is put in another char field the value displayed is "31-05-2001
01:00:00"
If I put that value in the date field, I get "Tue, 9 Aug, 11 1:33:57 "

But if i hard code the textual value "31-05-2001 01:00:00" in the
date/time field - it works great.

PS I am using the data import tool for the import - I thought I could
define the format in the options pane, but that is apparently only for
displaying - not for parsing date/times ???

I hope someone can see where I am going wrong.

best regards

Jonas Stevnsvig

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Re: String to Date

[Jonas Stumph Stevnsvig]

Oh sorry

ARS 7.6.03 on w2k3

I tried MM/DD/ as well - no luck with that either...

/Jonas

> Since you didn't give us the ARS version and which operating system, my
> first suggestion would be to look up the ARDATE environment variable
>
> Another option would be to string manipulate the date into the format of
> MM/DD/ before putting it into the date time field.
>
> Fred
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:arslist@ARSLIST.ORG] On Behalf Of Jonas Stumph Stevnsvig
> Sent: Tuesday, August 09, 2011 7:54 AM
> To: arslist@ARSLIST.ORG
> Subject: String to Date
>
> Hi all
>
> I am having a spot of trouble with strings and dates...
>
> I have an import which gives me dates in the following format: MMDD,
> and puts them in a Character field.
>
> I want to parse the date, so i created a setfields action with a value of
> SUBSTR($ImportedDateCharField$, 6, 7) + "-") +
> SUBSTR($ImportedDateCharField$, 4, 5)) + "-") +
> SUBSTR($ImportedDateCharField$, 0, 3)) + " 01:00:00"
>
> If this is put in another char field the value displayed is "31-05-2001
> 01:00:00"
> If I put that value in the date field, I get "Tue, 9 Aug, 11 1:33:57 "
>
> But if i hard code the textual value "31-05-2001 01:00:00" in the
> date/time field - it works great.
>
> PS I am using the data import tool for the import - I thought I could
> define the format in the options pane, but that is apparently only for
> displaying - not for parsing date/times ???
>
> I hope someone can see where I am going wrong.
>
> best regards
>
> Jonas Stevnsvig
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
>

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Re: String to Date

[Jonas Stumph Stevnsvig]

The server is set to english(us) and expects m/d/

I logged on to the dev tool on the server itself, instead of my workstation, 
and had a look at the date representation. It matched the server setting. But 
even after replacing the string with
> SUBSTR($ImportedDateCharField$, 4, 5) + "/") +
> SUBSTR($ImportedDateCharField$, 6, 7)) + "/") +
> SUBSTR($ImportedDateCharField$, 0, 3)) + " 01:00:00"


And checking that it resolves to the right string (06/30/2011 01:00:00) i get 9 
aug 2011 1:39:07 am as the date...



Den 09/08/2011 kl. 15.43 skrev LJ LongWing :

> What is the regional setting of the server?  What format does the windows
> server expect dates to be in?
> 
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:arslist@ARSLIST.ORG] On Behalf Of Jonas Stumph Stevnsvig
> Sent: Tuesday, August 09, 2011 5:54 AM
> To: arslist@ARSLIST.ORG
> Subject: String to Date
> 
> Hi all
> 
> I am having a spot of trouble with strings and dates...
> 
> I have an import which gives me dates in the following format: MMDD,
> and puts them in a Character field.
> 
> I want to parse the date, so i created a setfields action with a value of
> SUBSTR($ImportedDateCharField$, 6, 7) + "-") +
> SUBSTR($ImportedDateCharField$, 4, 5)) + "-") +
> SUBSTR($ImportedDateCharField$, 0, 3)) + " 01:00:00"
> 
> If this is put in another char field the value displayed is "31-05-2001
> 01:00:00"
> If I put that value in the date field, I get "Tue, 9 Aug, 11 1:33:57 "
> 
> But if i hard code the textual value "31-05-2001 01:00:00" in the
> date/time field - it works great.
> 
> PS I am using the data import tool for the import - I thought I could
> define the format in the options pane, but that is apparently only for
> displaying - not for parsing date/times ???
> 
> I hope someone can see where I am going wrong.
> 
> best regards
> 
> Jonas Stevnsvig
> 
> 
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
> 
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Re: String to Date

[Jonas Stumph Stevnsvig]

Thank you.  it's Much appreciated.  I`ll try it out later tonight.

Have a great day

 LJ LongWing  skrev: 

Jonas,
Ok...just spent a few min's with this and figured it out for you.  The
problem is that when you are doing the + and "/" and etcremedy is
considering it a mathematical formulation in the Date field.  So, the
solution I came up with is to first do all of your substr functions into the
char field that you are using for validations, then set your date field (in
another setfield) to the value of your char field.  Works like a charm.

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Jonas Stumph Stevnsvig
Sent: Tuesday, August 09, 2011 8:43 AM
To: arslist@ARSLIST.ORG
Subject: Re: String to Date

The server is set to english(us) and expects m/d/

I logged on to the dev tool on the server itself, instead of my workstation,
and had a look at the date representation. It matched the server setting.
But even after replacing the string with
> SUBSTR($ImportedDateCharField$, 4, 5) + "/") +
> SUBSTR($ImportedDateCharField$, 6, 7)) + "/") +
> SUBSTR($ImportedDateCharField$, 0, 3)) + " 01:00:00"


And checking that it resolves to the right string (06/30/2011 01:00:00) i
get 9 aug 2011 1:39:07 am as the date...



Den 09/08/2011 kl. 15.43 skrev LJ LongWing :

> What is the regional setting of the server?  What format does the windows
> server expect dates to be in?
> 
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:arslist@ARSLIST.ORG] On Behalf Of Jonas Stumph Stevnsvig
> Sent: Tuesday, August 09, 2011 5:54 AM
> To: arslist@ARSLIST.ORG
> Subject: String to Date
> 
> Hi all
> 
> I am having a spot of trouble with strings and dates...
> 
> I have an import which gives me dates in the following format: MMDD,
> and puts them in a Character field.
> 
> I want to parse the date, so i created a setfields action with a value of
> SUBSTR($ImportedDateCharField$, 6, 7) + "-") +
> SUBSTR($ImportedDateCharField$, 4, 5)) + "-") +
> SUBSTR($ImportedDateCharField$, 0, 3)) + " 01:00:00"
> 
> If this is put in another char field the value displayed is "31-05-2001
> 01:00:00"
> If I put that value in the date field, I get "Tue, 9 Aug, 11 1:33:57 "
> 
> But if i hard code the textual value "31-05-2001 01:00:00" in the
> date/time field - it works great.
> 
> PS I am using the data import tool for the import - I thought I could
> define the format in the options pane, but that is apparently only for
> displaying - not for parsing date/times ???
> 
> I hope someone can see where I am going wrong.
> 
> best regards
> 
> Jonas Stevnsvig
> 
>

> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
> 
>

___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Panel holders and hidden tabs

[Jonas Stumph Stevnsvig]

Hi All

I recall in ars 7.0/7.1, that you could create what is now a page holder, and 
create pages with no labels, so that the midtier would display only the visible 
page, with no tabs. This doesn't seem to work the same way in 7.6.04. Dó i have 
to use STS ked pages or somethinh else instead to get the same functionality?
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Re: BMC Remedy Data Import Tool not launching

[Jonas Stumph Stevnsvig]

Hi Sam

try opening a console and navigating to the installation folder of the 
data import tool (%programFiles%\BMC Software\ARSystem\dataimporttool) 
and then running dataimport.bat


You should get a usage "screen" - if you don't, you should get an error 
indicating what is wrong... if it doesn't help, paste your findings to 
the list, and we might get some mre to go on ;-)


regards  Jonas

Den 19-08-2011 17:43, Sam Cerrato skrev:

When I try to launch (open) the data import tool, I get a splash page (BMC 
Remedy Action Request System Version 7.6) for about 2 seconds and then it 
disappears. No error message, no login screen. It just doesn't load.

I'm running it on my laptop which is Windows XP, Intel i5 CPU with 4 GB RAM and 
250 GB of storage. I've ensured I'm running the latest version of Java and I 
also uninstalled and reinstalled Remedy on the laptop but still can't get the 
data tool to launch. User and Developer Studio open just fine.

Any suggestions?
Thanks,
Sam

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Re: BMC Remedy Data Import Tool not launching

[Jonas Stumph Stevnsvig]

Strange

Try doing the same, but with the .exe file - the .bat file seems to work

(the bat file essentially launches the non-gui version of the data 
import tool)


Den 19-08-2011 18:30, Sam Cerrato skrev:

Thanks Don and Jonas...here's the dataimport.bat file:


C:\Program Files\BMC Software\ARSystem\dataimporttool>DataImport.bat
Command Line Options:
 -u   : Required login parameter that identifies the user 
accou
nt.
 -p   : Optional login parameter that identifies the password.
Omit the option if the user account has no password.
 -x : Login parameter that specifies the server to log in 
to.
  This option overrides the server specified in the mapping. If this option is 
no
t specified, the server name in the mapping is used.
 -w  : Name of an external authentication string or Windows 
NT
  domain. This is related to the Login window Authentication field, which is 
disc
ussed in the Configuring guide.
 -r  : RPC program number. Private server, for example, if a 
d
edicated import server is available. If not specified, the default is the admin
server 390600.
 -a: TCP port number. Port number for the server. This 
value
  is especially important in a multiple server environment. The option also 
ident
ifies a TCP specific port, if chosen.
 -l: Full path name of the log file. Use this option to log
details of the import execution.
 -e   : Duplicate fields. IDs of the fields to check for 
duplic
ate data. For example, for the Short Description field, you would enter the valu
e 8. By default, the Request ID field (field ID 1) is used when -e parameter is
omitted. Multiple values can be specified by separatng them with commas (2,4,8)
 -n : Suppress filters. When the system is merging entries 
on
  forms, this command instructs arimportcmd to suppress the merge filters.
 -t : Multiple match option. Use when more than one entry 
mat
ches. Enter a value of 3 to affect the first match, and a value of 5 to affect a
ll matches.
 -o   : Data file name. Name of the file containing data to 
imp
ort. If specified, this option overrides the data file specified in the mapping.
  If not specified, the data file specified in the mapping is used.
 -o  : To use multithreaded data import tool use this option 
w
ith directory name. All the files under this directory will be imported. All thi
s data will be imported in the schema provided in the command. If mapping file i
s provided and data dir contains different types of files like .arx,.csv,.xml an
d .asc then this mapping file should be same for all these files.
 -f  : Destination form name. Name of the form to import 
into.
  If specified, this option overrides the form specified in the mapping. If not 
s
pecified, the form specified in the mapping is used.
 -v : Forces override. If the user has logged in from a 
diffe
rent IP address, this option tells the server to use the new IP address of the B
MC Remedy Import client and invalidates the old IP address.
 -i : Suppress default values. If specified this option is 
sp
ecified import will ignore the default values of fields if the value in the data
  file is null or not supplied.
 -M: Full path name of mapping file. Required fully 
qualifie
d path name of the mapping file to use.
 -D : Duplicate ID. Defines how to process records that 
conta
in request IDs, which duplicate those already in the form. With this option, you
  must include one of the following numbers:
 0 : Generate new ID for all records
 1 : Reject duplicate records
 2 : Generate new ID for duplicate records
 3 : Replace old record with new record
 4 : Update old record with new records data (the 
def
ault)
 -q : Suppresses the required field property for non core 
fie
lds.
 -c : Truncates character values longer than the field 
length
  for character fields.
 -h : Suppresses pattern matching for fields. If supplied 
the
  $PATTERN$ field limit is ignored
 -charset : Specifies the character set used in the data file. The
character set name must be supplied as listed in the IANA Charset Registry
 -b : Sets the transaction size to use.
 -threads: Sets the Maximum Thread Pool size. This is optional par
ameter, if not specified then it is set to default value 50
 -filelist   : Comma separated list of 
files(report.arx,test.csv,data.
xml). When -o option is data directory then only this option can be used else th
is is of no use. This is optional and takes precedence over -pattern.
 -pattern   : Specifies a pattern for matching file names and import
them using multiple threads. When -o option is data directory then only this opt
ion can be used else this is of no use. This is optional.
 -custom  

Re: Disable/Hide X (exit) button when using mid-tier

[Jonas Stumph Stevnsvig]

If you are referring to the browser's x Button, there is no way to remove it



Den 26/08/2011 kl. 09.32 skrev Kali Obsum :

> **
> Hi,
>  
> When using a display-only/dialog form, there is an option "Show Close 
> Button". However, this only works in the User Tool. When accessing through 
> the web, the pop-up window still has an x button. Is there any way to 
> hide/disable the x button?
>  
> Thanks!
>  
> Regards,
> Kali
> NOTICE
> 
> The information contained in this email is confidential. If you are not the 
> intended recipient, you must not disclose or use the information in this 
> email in any way. If you received it in error, please tell us immediately by 
> return email and delete the document. We do not guarantee the integrity of 
> any e-mails or attached files and are not responsible for any changes made to 
> them by any other person.
> 
>  
> 
> _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Re: Disable/Hide X (exit) button when using mid-tier

[Jonas Stumph Stevnsvig]

I investigated the possibilities of preventing users from using the 
next/back buttons, closing windows and so on, while working on a CMS 
system, and none of these actions can be controlled, due to "safety 
precautions". A user will always be able to close a browser window. the 
most you can do is add an "are you sure" dialog, which  is not certain 
to work. only option I can see is developing browser-specific plugins to 
try to handle this, and that is afaik not implementable in ARS.


Den 26-08-2011 12:09, Kali Obsum skrev:

**
Is there a way to prevent users from closing a window when using the 
web tool? We tried putting an Error message upon Window Close event 
and it works for User Tool but we're still not getting the desired 
behavior on the web.

Regards,
*Kali Obsum*
GS GR - Software Services  | 30/F Tower 1 The Enterprise Centre | 6766 
Ayala Ave. 1226 Makati City | Philippines

( +63 2 917 1910 | 5  +63 927 225 6009 | *
kali.ob...@macquarie.com <mailto:kali.ob...@macquarie.com>
Shift Pattern: MNL Business Hours
Upcoming Leave or Training: None
For urgent requests, please call ITG Service Desk (x54321) or email 
the team at itgserviced...@macquarie.com 
<mailto:itgserviced...@macquarie.com>



*From:* Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] *On Behalf Of *Jonas Stumph Stevnsvig

*Sent:* Friday, 26 August 2011 3:44 PM
*To:* arslist@ARSLIST.ORG
*Subject:* Re: Disable/Hide X (exit) button when using mid-tier

**
If you are referring to the browser's x Button, there is no way to 
remove it




Den 26/08/2011 kl. 09.32 skrev Kali Obsum <mailto:kali.ob...@macquarie.com>>:



**
Hi,
When using a display-only/dialog form, there is an option "Show Close 
Button". However, this only works in the User Tool. When accessing 
through the web, the pop-up window still has an x button. Is there 
any way to hide/disable the x button?

Thanks!
Regards,
*Kali *

NOTICE

The information contained in this email is confidential. If you are 
not the intended recipient, you must not disclose or use the 
information in this email in any way. If you received it in error, 
please tell us immediately by return email and delete the document. 
We do not guarantee the integrity of any e-mails or attached files 
and are not responsible for any changes made to them by any other person.


_attend WWRUG11 www.wwrug.com <http://www.wwrug.com> ARSlist: "Where 
the Answers Are"_
_attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ 
_attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ 



___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Re: Prevent MT Login

[Jonas Stumph Stevnsvig]

Hi Aditya

I had a similar issue, but in reverse - have a look at the 
"*Disable-Client-Operation*" directive in ar.conf 
(https://docs.bmc.com/docs/display/public/ars8000/ar.cfg+or+ar.conf+options+C-D) 
you can disable it for all, but members of a specific group. ie - all 
others are made members of "allow-midtier-access" group (lets say gid = 
9000), except the user you want to disallow, and you add

Disable-Client-Operation: 9 9000,1
that should solve your problem without workflow.

Best regards Jonas


Den 06-09-2013 21:58, SUBSCRIBE arslist Aditya Sharma skrev:

Hi Listers,

I have a requirement to prevent a particular user to be able login through mid 
tier but same user should be able to login to client tools. Has anyone 
implemented such requirement? What can be the best way to achieve this?

Specifically looking for a non-workflow mechanism.

Regards,
Aditya
Sent from my BlackBerry® smartphone from !DEA

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"



___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: Prevent MT Login

[Jonas Stumph Stevnsvig]

We considered it to try to curb "unauthorized" ODBC queries being run, 
to avoid performance issues.


Den 10-09-2013 08:07, Joe D'Souza skrev:

**

I find the time option on this particularly useful -- for when you are 
in the process of some sort of system maintenance.. Cool option..


Joe



*From:*Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] *On Behalf Of *Jason Miller

*Sent:* Monday, September 09, 2013 6:05 PM
*To:* arslist@ARSLIST.ORG
*Subject:* Re: Prevent MT Login

**

That is sweet!  I overlooked that one complete.  I'll have to try this 
out with some of our webservice-only accounts.


Jason

On Sat, Sep 7, 2013 at 1:29 PM, Jonas Stumph Stevnsvig 
mailto:arsl...@stevnsvig.com>> wrote:


**

Hi Aditya

I had a similar issue, but in reverse - have a look at the 
"**Disable-Client-Operation**" directive in ar.conf 
(https://docs.bmc.com/docs/display/public/ars8000/ar.cfg+or+ar.conf+options+C-D) 
you can disable it for all, but members of a specific group. ie - all 
others are made members of "allow-midtier-access" group (lets say gid 
= 9000), except the user you want to disallow, and you add

Disable-Client-Operation: 9 9000,1
that should solve your problem without workflow.

Best regards Jonas


Den 06-09-2013 21:58, SUBSCRIBE arslist Aditya Sharma skrev:


Hi Listers,
  
I have a requirement to prevent a particular user to be able login through mid tier but same user should be able to login to client tools. Has anyone implemented such requirement? What can be the best way to achieve this?
  
Specifically looking for a non-workflow mechanism.
  
Regards,

Aditya
Sent from my BlackBerry® smartphone from !DEA
  
___

UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org  
<http://www.arslist.org>
"Where the Answers Are, and have been for 20 years"


_ARSlist: "Where the Answers Are" and have been for 20 years_

_ARSlist: "Where the Answers Are" and have been for 20 years_

_ARSlist: "Where the Answers Are" and have been for 20 years_ 



___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Links to TMS:Task in 8.1

[Jonas Stumph Stevnsvig]

Hi listers

I have noticed an odd behaviour:

links to TMS:Task will redirect to SHR:LandingConsole, showing TMS:Task in 
serach mode, but dropping any qualification

both 
http://cmccsm/servlet/ViewFormServlet?form=TMS%3ATask&server=cmccsmappsrv&qual=%27Task%20ID%27%3D%22TAS01033674%22

and 
http://cmccsm/forms/cmccsmappsrv/TMS%3ATask?1=TAS01033674

will fail, whereas
http://cmccsm/forms/cmccsmappsrv/HPD%3AHelp%20Desk?F100161=INC8102
and
http://cmccsm/arsys/servlet/ViewFormServlet?form=CHG%3AInfrastructure%20Change&server=cmccsmappsrv&qual=%27Change%20ID*%2B%27=%22INC8102%22
 
and
http://cmccsm/arsys/servlet/ViewFormServlet?form=CTM%3APeople&server=cmccsmappsrv&qual=%27Corporate%20ID%27=%22g45877%22

all work as expected - just opening the form in search mode and displaying the 
requred record.

have any of you experienced something similar? and have you got any tips?

br 

Jonas

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: Help needed for installing a hotfix for 7.6.04 SP4-S

[Jonas Stumph Stevnsvig]

that depends on how you have deployed the midtier to weblogic. have you 
tried searching for said folders on the weblogic server?


Den 30-09-2013 14:42, tristan.rop...@t-online.de skrev:

Hi folks,

i need your help for installing a hotfix for Midtier.
Im not familiar with WebLogic servers.
We have to install this hotfix in a WebLogic instance, and not in a Tomcat 
instance.

In the manuals there is the description, that we have to delete these 
directories

/cache
/cachetemp (if exists)
/PluginsCache

But where can i find this under WebLogic ?

BR

Tristan

Tristan

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: production issue - arserverd, arforkd keeps restarting

[Jonas Stumph Stevnsvig]

which version of ARS are you on?


there was a flash message about this exact issue from BMC saturday - TCP 
connection leak leading to the .exe plugins not being able to connect, 
people getting server unavailable messages...



Den 30-09-2013 19:33, Raj skrev:

**
Hi All,
There is an ongoing issue on our Production environment where 
arserverd and arforkd processes keeps restarting.
Started since last week and this happens randomly and noticed that 
when it happens atleast once in 4-6hrs and when it happens it throws 
error:
ARERR (90) Cannot establish a network connection to the AR System 
Server..RPC: Miscellaneous tli error - System error (Socket error 
- 10060).
After about 10-15mins, the server stabilizes and the error is gone 
until this re-surfaces again.

Current Production:
Environment Info:
AR Server Version : 5.01.02 Patch 1313
Hardware : sun4u
Operating System : SunOS 5.10
DB : SQL -- Oracle
DB Version : 10.2.0.5.0 - 64bi

Captured various logs - API, SQL, Filter, Escalation, etc but can't 
find much helpful information. Also, initiated a critical ticket with 
BMC but so far we haven't received any proper support but asking us to 
update the server to patch 1494. At this moment, we atleast would like 
to know the root cause if this issue rather than just blindly applying 
the patch. We also discussed with network folks and they mentioned 
there are no changes made on the network side recently.
When it happens, we also tried gracefully bringing Remedy down and 
restarting it again but no luck. This is ongoing issue.
We are thinking to reboot the server but atleast would like to know 
why this issue is occurring repeatedly.


Please advise.
Thank you,
Raj
_ARSlist: "Where the Answers Are" and have been for 20 years_ 



___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: BMC Customer Support

[Jonas Stumph Stevnsvig]

you should get a hold of your account manager, and he can get a 
"customer satisfaction manager" - or something along those lines, I 
forget the exact title -  assigned to your case...


Den 02-10-2013 18:05, Kathy Morris skrev:

**

Hi,

Does anyone know who we can contact on a Sr. Management level at BMC 
regarding technical support?


We are not happy at all with the level of support we are receiving.

If you like, you contact me directly for any recommendations.

_ARSlist: "Where the Answers Are" and have been for 20 years_ 



___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: Search feature in devloper studio

[Jonas Stumph Stevnsvig]

I always use "show relationships" - just right click the form in the
forms list - don't think i have had the pleasure of a search working as
desired.



/Jonas


On 03/10/2013 18:41 "Campbell, Paul (Paul)"  wrote:

> **
> So has anyone gotten the search feature to work in developer studio to
> really work, I am am using Dev Studio 8.1 searching against a 7.6.04
> server and I am trying to do something that seems really simple, but I
> can’t seem to find any matches, so I want to find all filters that
> fire
> on submit or modify where primary form = X, and I put the form name in
> the search text, I set the search in to be Forms: Workflow; Guides and
> all it finds is the form, no filters. I’ve tried setting a
> qualification
> of Only These Locations, Object Type =Filter and TargetText Location =
> Form, still no filters. Object Relationships are on, I just can’t seem
> to get the right criteria. Any search wizards out there?
> _ARSlist: "Where the Answers Are" and have been for 20 years_
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: Java API

[Jonas Stumph Stevnsvig]

Hi




firstly, It seems as if you are confusing Java and Javascript - i assume
that you are talking pure Java, and "Java Script" is a "Java
Application" - ie a java .class file run with java.exe




Java is a requirement of the Remedy installation as far as I recall, so
it is present on the server. with regards to the JDK, you have to check
by opening a commandline and typing "javac -version" (no quotes)




/Jonas



On 04/10/2013 12:36 "Neha Khandelwal"  wrote:

> Hi List,
> 
> 
> Please help me with your expertise on below query.
> I am working on ITSM 7.6 version. I have requirement to create a Java
> script which should extract HPD:Help Desk form data through Java API.
> 
> Now I need to check do I have everything already installed or
> configured to run Java script at Remedy side.
> As I looked into installation directory of ARSystem I found at
> following path .../ARSystem/api, have direcories for
> Javaplugins
> Javadriver
> include
> lib
> 
> Is that mean Java is already installed Or I need to install it
> specifically.
> 
> Can you please assist?
> 
> Regards
> Neha Khandelwal
> 
> __
> _
> UNSUBSCRIBE or access ARSlist Archives at 
> "Where the Answers Are, and have been for 20 years"
> 
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: Java API

[Jonas Stumph Stevnsvig]

Correct



On 04/10/2013 13:02 "Neha Khandelwal"  wrote:

> Hi Jonas,
> 
> Thanks for replying. Yes, I am not very much invloved into Java. After
> typing command suggested by you, I got javac version as 1.6.0_30,
> which means jdk is installed, right?
> 
> Regards
> Neha Khandelwal
> 
> __
> _
> UNSUBSCRIBE or access ARSlist Archives at 
> "Where the Answers Are, and have been for 20 years"
> 
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: 2013 MVP

[Jonas Stumph Stevnsvig]

So explain already!


On 04/10/2013 14:31 "Susan Palmer"  wrote:

> **
> Ok David  you don't want to scare away any non-attendee newbies
> with
> that pic and no explanation!
> 
> 
> 
> 
> 
> On Fri, Oct 4, 2013 at 12:22 AM, Shellman, David
> <> wrote:
> 
> >
> >
> >
> > 
> > __
> > _
> > UNSUBSCRIBE or access ARSlist Archives at 
> > "Where the Answers Are, and have been for 20 years"
> >
> 
> 
> _ARSlist: "Where the Answers Are" and have been for 20 years_
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

prompt bar vs popup

[Jonas Stumph Stevnsvig]

I seem to recall being able to specify whether I want errors as popups
or as those prompts at the top of the page - or a popup displaying the
error. But I can't find the setting anywhere - am I hallucinating?

-- 

Best regards

Jonas Stumph Stevnsvig



___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: prompt bar vs popup

[Jonas Stumph Stevnsvig]

Wasn't there a user preference configuration item to override the
setting?
We have a lot of users complaining that they don't notice the prompts at
the top of the screen...




(We just went from itsm 7.6 on ARS 7.6.04 to 8.1)



-- 

Best regards

Jonas Stumph Stevnsvig




On 16/10/2013 15:11 "LJ LongWing"  wrote:

> **
> each message has the ability to choose where (at least active links
> do)...plus, in the admin console, on the configuration tab, there is
> the
> field named 'Use Prompt Bar for'...which controls 'some' messages...
> 
> 
> 
> 
> On Wed, Oct 16, 2013 at 7:06 AM, Jonas Stumph Stevnsvig
> <> wrote:
> 
> > **
> > I seem to recall being able to specify whether I want errors as
> > popups
> > or as those prompts at the top of the page - or a popup displaying
> > the
> > error. But I can't find the setting anywhere - am I hallucinating?--
> > 
> >
> > Best regards
> >
> > Jonas Stumph Stevnsvig
> >
> > 
> > 
> > _ARSlist: "Where the Answers Are" and have been for 20 years_
> 
> 
> _ARSlist: "Where the Answers Are" and have been for 20 years_
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: OT - All time great error messages - Just for fun!

[Jonas Stumph Stevnsvig]

My favourite error message:

"Bad user. Replace and strike any key."

(From a dos program with a list of entries, navigated with up and down 
arrow keys, selection with enter key - you got the error message if you 
pressed left or right key)


Den 18-10-2013 15:06, laurent matheo skrev:

**
I'm coding a program that checks BMC foundation data and I enforced a 
unicity on « first name + middle name + last name » and a customer 
told that « BMC Doesn't do that », here was my reply:


Yeah but it's so dirty to have that... And then later customers 
complain people of service desk have a lot of problems identifying 
people...


The check is done with middle name, so the point would be to have 
"John Henry Smith ».
If there are two John Smith with the same middle name, I would 
consider suing my dad for cheating on my mom and having a queer sense 
of humour :)



No answer yet...

De : Gordon Frank mailto:gjj...@comcast.net>>
Répondre à : mailto:arslist@ARSLIST.ORG>>
Date : vendredi 18 octobre 2013 15:00
À : mailto:arslist@ARSLIST.ORG>>
Objet : OT - All time great error messages - Just for fun!

**

This might be fun on a Friday!

The best\non-useful error message I have ever seen was on an old Data 
General RDOS Mini-Computer (remember those?)


A "system level" violation came back and said:

>Error: You Can't Do That

BMC Remedy is full of these and they need to at least point you to an 
object or a line in the object. But, it's cheaper to just say, "You 
can't do that." (Unrecognized server information)


Gordon



*From: *"LJ LongWing" >

*To: *arslist@ARSLIST.ORG 
*Sent: *Friday, October 18, 2013 8:14:41 AM
*Subject: *Re: A bit of Friday humour in BMC's Error messages

**

What code is giving this?

On Oct 18, 2013 12:40 AM, "Ben Chernys" 
> wrote:


**

I just got the following errors with the 8.1 API against an 8.1
server (VERSION = 8.1.00 201301251157)

ARGetServerInfo ==> 2, 123, Unrecognized server information tag 358

ARGetServerInfo ==> 2, 123, Unrecognized server information tag 357

ARGetServerInfo ==> 2, 123, Unrecognized server information tag 356

ARGetServerInfo ==> 2, 123, Unrecognized server information tag 355

ARGetServerInfo ==> 2, 123, Unrecognized server information tag 354

These are the new ones for 8.1.  The humour comes from the 7.6.04
Error Messages Guide:

123



*Unrecognized server information tag.*

Error



You specified a code for server information that was not
recognized. Verify that the #define

statements in the include file ar.h have a list of all valid codes
that can be specified.

Yup.  Verified.  The 8.1 ar.h does not have a list of valid codes J

Ben Chernys
Senior Software Architect
logoSthInc-sm

Canada / Deutschland
Mobile: +49 171 380 2329 GMT + 1
+ [ DST ]
Email: ben.cher...@softwaretoolhouse.com

Web: www.softwaretoolhouse.com 

We are a BMC Technology Alliance Partner.


Check out Software Tool House's free Diary Editor and out Freebies

Section for ITSM 7.6.04, 8.0, and 8.1 Fields spreadsheets.

*Meta-Update**,*our premium ARS Data tool, lets you automate
your imports, migrations, *in no time at all*, without programming,
without staging forms, without merge workflow.
http://www.softwaretoolhouse.com/

_ARSlist: "Where the Answers Are" and have been for 20 years_

_ARSlist: "Where the Answers Are" and have been for 20 years_
_ARSlist: "Where the Answers Are" and have been for 20 years_ 
_ARSlist: "Where the Answers Are" and have been for 20 years_ 



___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: Installer hanged up on a fresh install of Ar System 7604 sp3

[Jonas Stumph Stevnsvig]

If you let it sit for a couple of hours do you get an arerr93? And does the 
oracle database show an sql*net break/reset to client?




Mvh
Jonas Stumph Stevnsvig

Den 15/10/2012 kl. 07.49 skrev patrick zandi :

> ** I think the minimum java version changed on this as well.. better double 
> check.. 
> the new installers are checking memory and space.. and indeed you need some 
> crazy numbers for the newer versions. .like 
> 9 gig for ITSM / ARS / SRM of ram.. and 2 gig table space, with 1 gig temp 
> space.. minimums.. 
> -- not sure if that helps ya.. 
> 
> 
> On Mon, Oct 15, 2012 at 10:37 AM, Prasad nampally  
> wrote:
> ** initially tried using 7604sp4 we had the similar issue, so moved to 
> 7604sp3 but still having the same issue.
> 
> On Mon, Oct 15, 2012 at 9:31 AM, patrick zandi  wrote:
> ** I had problems with sp 3 as well, but my recommendation is to skip this .. 
> shoot for sp 4.. 
> which is out,   just a thought.. 
> 
> On Mon, Oct 15, 2012 at 10:19 AM, Prasad nampally  
> wrote:
> **
> Hi,
> I am trying to install BMC Remedy AR System 7604 SP3 on Windows 2008 R2, 
> Oracle DB , the installer got hanged up restarting the AR Server Service, 
> their is notting i can see in the install log  AR Error or Monitor log. The 
> AR System Service came up with a memory  60MB isn't should be some whee about 
> 500 to 600Mb on a fresh install. Did any came across this kind of issue on a 
> fresh install.
> At the database level is their any session limit that need to be set at the 
> time of installing AR server?
> Thanks
> Ravi
> _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_
> 
> 
> 
> -- 
> Patrick Zandi
> _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_
> 
> _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_
> 
> 
> 
> -- 
> Patrick Zandi
> _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_

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

Re: Windows 8 and ITSM 8.1

[Jonas Stumph Stevnsvig]

Technically Tomcat is an application server - not a web server.

Apache, IIS, lighttpd, etc are all webservers - and excel in delivering 
(preferably static) content fast and accurately.
Application servers such as tomcat, glassfish, weblogic, websphere, are 
for running J2ee (Java servlets and jsp).


The midtier for Remedy is basically a java application (j2ee application 
- you can't run it on a standard JRE) which takes the layouts of the 
forms and converts them to HTML and the active links and convert them to 
javascript, communicating with the ARS via the Java API.


given this, the IIS has never been able to run the midtier, and never 
will be able to do so - but it has acted as a proxy server caching all 
the static stuff so the tomcat server isn't burdened with that, and the 
communication is through a plugin for IIS (jakarta i think apache call 
it) which allows them to interact in the proper fashion.


br

Jonas

Den 30-04-2013 02:53, Joe D'Souza skrev:

I have not had the opportunity to play with 8.1 yet. But having read this
thread, does it mean that the option to install the mid-tier using IIS as a
web server has been completely deprecated?

What other web server options are available in addition to Tomcat?

Joe


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of John Baker
Sent: Monday, April 29, 2013 1:33 PM
To: arslist@ARSLIST.ORG
Subject: Windows 8 and ITSM 8.1

Install Tomcat if not already installed. Drop Mid Tier war file into
webaps directory. Start Tomcat, browse to
http://localhost:8080/arsys/shared/config/config.jsp and go from there...


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

intermittent dropping of DB connections

[Jonas Stumph Stevnsvig]

HI listers

I was wondering if any of you had experienced the following:

Every so often one or two of our Remedy servers loses some of it's Database 
connections. Never all of them. The symptom is that the users experience 
sporadic "no entries in menu" or "no results" when clicking menus or 
searching/opening requests. No errors relating to missing DB connections appear 
in the Logs or in the User tool. (we only use the WuT).

We are on 7.5.003 in a servergroup (4 servers) on virtualized win2k3 server 
with a MsSQL cluster as backend. The problem is on different of our 4 servers, 
and there are no errors in the error log to help us.



best regards,



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

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