ARJAVAPLUGIN Timeout setting (web service consumption)

2013-10-20 Thread Leihkauff, Kenneth G
Hello,

I am able to use a filter to successfully consume a remote web service when the 
filter runs on a Solaris, Oracle, AR 7.6.04 system.  The same filter, however, 
generates a timeout error (see arjavaplugin.log below) indicating a ws timeout 
of 2 seconds when I run it on a Windows/MSSQL/AR7.6.04 SP4 system.  
Apparently, the default web service (axis?) timeout is only 2 seconds for the 
windows install compared to the Solaris/oracle install.  The windows system 
arjavaplugin seems to be ok fundamentally, however, since other ws calls are 
working.  When I migrated the workflow to the Solaris system to compare the 
results, I used exactly the same data and I am consuming the same target web 
service.

Does anyone know how to adjust the timeout related to the error seen in the log 
below? (see yellow below)

This does not seem to be related to the typical AR timeouts which are shown 
below:.  There is no Server-Plugin-Default-Timeout setting in the ar.cfg file 
so based on documentation it should default to 60 seconds (not sure if this 
applies).

[cid:image001.png@01CECDBA.670735E0]

Thanks for any insight you may have on this issue.

Ken Leihkauff

PS - windows system is AR 7.6.04 SP4; oracle/solaris AR is 7.6.04 SP1

==   ARJAVAPLUGIN LOG FILE 
=

ERROR (9130): Error encountered while executing a Web Service; ; nested 
exception is:
java.net.SocketTimeoutException: Read timed out
at 
com.bmc.arsys.ws.plugin.WSPlugin.ThrowException(WSPlugin.java:158)
at 
com.bmc.arsys.ws.plugin.WSPlugin.filterAPICall(WSPlugin.java:151)
at 
com.bmc.arsys.pluginsvr.plugins.ARFilterAPIPluginRepository.ARFilterApiCall(Unknown
 Source)
at com.bmc.arsys.pluginsvr.a.ArEsFilterApi_5(Unknown Source)
at com.bmc.arsys.pluginsvr.a.ArEsFilterApi_4(Unknown Source)
at 
com.bmc.arsys.arrpc.ARPluginServerDispatcher.dispatchOncRpcCall(Unknown Source)
at 
com.bmc.arsys.arrpc.nio.ArRpcCallHandler.dispatchCall(Unknown Source)
at com.bmc.arsys.arrpc.nio.ArRpcCallHandler.if(Unknown Source)
at 
com.bmc.arsys.arrpc.nio.ArRpcCallHandler.processRpcCall(Unknown Source)
at 
com.bmc.arsys.arrpc.nio.ArRpcCallHandler$Processor.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown 
Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown 
Source)
at java.lang.Thread.run(Unknown Source)
2013-10-18 19:31:56,145 ERROR [pool-2-thread-1] 
com.bmc.arsys.pluginsvr.plugins.ARPluginContext (?:?) - 
ARSYS.ARF.WEBSERVICEjava.net.SocketTimeoutException: Read timed out
2013-10-18 19:31:56,146 ERROR [pool-2-thread-1] 
com.bmc.arsys.pluginsvr.plugins.ARPluginContext (?:?) - 
ARSYS.ARF.WEBSERVICEWS timeout setting  = 2 sec
2013-10-18 19:31:56,146 ERROR [pool-2-thread-1] 
com.bmc.arsys.pluginsvr.plugins.ARPluginContext (?:?) - 
ARSYS.ARF.WEBSERVICEAxisFault during  = 2210 millisec
2013-10-18 19:31:56,146 ERROR [pool-2-thread-1] 
com.bmc.arsys.pluginsvr.plugins.ARPluginContext (?:?) - 
ARSYS.ARF.WEBSERVICEsoapService = IT06NOCMEMPHISService
2013-10-18 19:31:56,146 ERROR [pool-2-thread-1] 
com.bmc.arsys.pluginsvr.plugins.ARPluginContext (?:?) - 
ARSYS.ARF.WEBSERVICEsoapMethod = New_Create_Operation_1
2013-10-18 19:31:56,146 ERROR [pool-2-thread-1] 
com.bmc.arsys.pluginsvr.plugins.ARPluginContext (?:?) - 
ARSYS.ARF.WEBSERVICEsoapURL = 
https://servicedeskn2.naismc.com/arsys/services/ARService?server=narmdy2webService=IT06NOCMEMPHIS
2013-10-18 19:31:56,147 ERROR [pool-2-thread-1] 
com.bmc.arsys.pluginsvr.plugins.ARPluginContext (?:?) - 
ARSYS.ARF.WEBSERVICEsoapNamespace = urn:IT06NOCMEMPHIS
2013-10-18 19:31:56,147 ERROR [pool-2-thread-1] 
com.bmc.arsys.pluginsvr.plugins.ARPluginContext (?:?) - 
ARSYS.ARF.WEBSERVICEsoapInputDocument = ?xml version=1.0 
encoding=windows-1252?
ns0:ROOT xmlns:ns0=urn:IT06NOCMEMPHIS 
xmlns:xsd=http://www.w3.org/2001/XMLSchema; 
xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance;
ns0:SOAPHeader
ns0:AuthenticationInfo

ns0:userNameleihk/ns0:userName

ns0:password/ns0:password
/ns0:AuthenticationInfo
/ns0:SOAPHeader
ns0:PriorityMedium/ns0:Priority
ns0:CategoryServer/ns0:Category
ns0:TypeVMWare/ns0:Type
ns0:ItemOutage/ns0:Item
ns0:GroupService Desk/ns0:Group
ns0:Location100 N Main Street/ns0:Location
ns0:Impact3-Moderate/Limited/ns0:Impact
ns0:Urgency3-Medium/ns0:Urgency
ns0:special_projectNA/ns0:special_project
ns0:Source8/ns0:Source
  

Install ITSM 7.6.04 with SQL 2012?

2012-06-26 Thread Leihkauff, Kenneth G
Hello,

I am planning on installing ITSM 7.6.04 using VMWare/Windows/MSSQL.   Since SQL 
2012 is fairly new I wanted to check if there are any known problems with this 
version of the database.  Do you recommend going with SQL 2012 or 2008 R2?  
Thanks for your suggestions.


Ken Leihkauff
North American Integrated Services Management Center (NAISMC)
Science Applications International Corp. (SAIC)


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


Problem Importing Definitions (7.6.04SP1)

2011-12-19 Thread Leihkauff, Kenneth G
Hello,

We are having peculiar symptoms when importing some definition files. (The 
definition files were exported from a 7.6.04SP1 system.)

If I export a deployable application or a fairly large set of forms and related 
workflow (say 40 forms), I am able to import the definitions into a NEWLY 
installed AR 7.6.04SP1 system with no problems.  But, if I try to import this 
same file into an UPGRADED 7.6.04SP1 system, the import fails.  There are no 
errors and the import appears to terminate normally, but nothing is actually 
imported.  If I decrease the number of objects to 4 or 5 forms then it will 
import ok.  Again, notice that it works flawlessly with a NEWLY installed AR 
7.6 but only fails when trying to import to any of our UPGRADED 7.6 systems.  
All these upgraded systems appear to function and perform properly from a user 
perspective.

While running the import against one of the upgraded 7.6 systems, I enabled API 
and SQL logging, but there are no API or ORA errors.

Background:  All UPGRADED systems were from 7.1p6 to 7.6.04SP1, and Oracle 10g 
to 11g.  All NEW systems are 7.6.04SP1 with Oracle 11g.  All systems are 
Solaris 10 for AR and Oracle.  We do not use AR Server Groups.

Thanks for any insight you may have regarding this issue.

Ken Leihkauff

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


Re: ARS 7.1 Upgrade to 7.6.04 SP1 - Installer ORA ERRORS

2011-10-13 Thread Leihkauff, Kenneth G
Thank you, Frederick, that worked!



-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W
Sent: Wednesday, October 12, 2011 2:24 PM
To: arslist@ARSLIST.ORG
Subject: Re: ARS 7.1 Upgrade to 7.6.04 SP1 - Installer ORA ERRORS

I wonder if it a Solaris only upgrade problem.  I believe we found it 4 times  
FIELD_ENUM.ENUMSTYLE, FILTER_NOTIFY.BEHAVIOR, FILTER_NOTIFY.PERMISSION, and 
SCHEMA_ARCHIVE.ARCHIVEFROMFORM

What we ended up doing was to clone the table to a new name, null the affected 
fields, alter the data type, and put the value back (by selecting it from the 
cloned table) and then run the installer

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Leihkauff, Kenneth G
Sent: Wednesday, October 12, 2011 11:24 AM
To: arslist@ARSLIST.ORG
Subject: ARS 7.1 Upgrade to 7.6.04 SP1 - Installer ORA ERRORS

** 
Hello, 

Has anyone experienced similar problems when upgrading from 7.1 to 7.6 ARS?  
I've submitted a ticket to BMC but they have not indicated this is a known 
problem.  

More specifically, I'm upgrading 7.1 patch 6 ARS to 7.6.04 SP1 ARS.  This is 
Solaris 10, Oracle 11g.  The installer completes as failed with the following 
errors (see below).  We manually fixed the first error at the Oracle level and 
then re-ran the installer, but keep getting the same type of errors but on 
different AR data dictionary tables/columns.  Each time one of the columns is 
fixed and the installer is re-run, it appears to advance and find yet another 
of the same type of problems.  The ORA-01439 error suggests that it wants to 
change the data type.  For example, in the last error below, the 7.1 data 
dictionary documentations shows this column to be an integer, and the 7.6 
installer wants to change it to a number(15).  But, because there is data in 
the column, it fails.  The installer does not appear to have been written to 
handle this.  I would expect lots of people would be getting this error for 
upgrading 7.1 to 7.6, and BMC would need to fix the installer.  Thoughts, 
insight?  Thank you!

(Note: this is only an ARS upgrade -- Not ITSM/CMDB.)

Errors: ORA-01440  ORA-01439:
-

  LOG EVENT {Description=[[SQLERROR] [DESCRIPTION] Failed to upgrade the 
database schema],Detail=[[SQLERRORCODE]=0 [SQLMESSAGE]=Failed to run SQL 
statement [ALTER TABLE FIELD_ENUM MODIFY ( ENUMSTYLE NUMBER(15) )] Due to 
[ORA-01440: column to be modified must be empty to decrease precision or scale

  LOG EVENT {Description=[[SQLERROR] [DESCRIPTION] Failed to upgrade the 
database schema],Detail=[[SQLERRORCODE]=0 [SQLMESSAGE]=Failed to run SQL 
statement [ALTER TABLE FILTER_NOTIFY MODIFY ( BEHAVIOR NUMBER(15) )] Due to 
[ORA-01440: column to be modified must be empty to decrease precision or scale

  LOG EVENT {Description=[[SQLERROR] [DESCRIPTION] Failed to upgrade the 
database schema],Detail=[[SQLERRORCODE]=0 [SQLMESSAGE]=Failed to run SQL 
statement [ALTER TABLE SCHEMA_ARCHIVE MODIFY ( ARCHIVEFROMFORM NUMBER(15) )] 
Due to [ORA-01439: column to be modified must be empty to change datatype


Ken Leihkauff

___
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


ARS 7.1 Upgrade to 7.6.04 SP1 - Installer ORA ERRORS

2011-10-12 Thread Leihkauff, Kenneth G
Hello,

Has anyone experienced similar problems when upgrading from 7.1 to 7.6 ARS?  
I've submitted a ticket to BMC but they have not indicated this is a known 
problem.

More specifically, I'm upgrading 7.1 patch 6 ARS to 7.6.04 SP1 ARS.  This is 
Solaris 10, Oracle 11g.  The installer completes as failed with the following 
errors (see below).  We manually fixed the first error at the Oracle level and 
then re-ran the installer, but keep getting the same type of errors but on 
different AR data dictionary tables/columns.  Each time one of the columns is 
fixed and the installer is re-run, it appears to advance and find yet another 
of the same type of problems.  The ORA-01439 error suggests that it wants to 
change the data type.  For example, in the last error below, the 7.1 data 
dictionary documentations shows this column to be an integer, and the 7.6 
installer wants to change it to a number(15).  But, because there is data in 
the column, it fails.  The installer does not appear to have been written to 
handle this.  I would expect lots of people would be getting this error for 
upgrading 7.1 to 7.6, and BMC would need to fix the installer.  Thoughts, 
insight?  Thank you!

(Note: this is only an ARS upgrade -- Not ITSM/CMDB.)

Errors: ORA-01440  ORA-01439:
-

  LOG EVENT {Description=[[SQLERROR] [DESCRIPTION] Failed to upgrade the 
database schema],Detail=[[SQLERRORCODE]=0 [SQLMESSAGE]=Failed to run SQL 
statement [ALTER TABLE FIELD_ENUM MODIFY ( ENUMSTYLE NUMBER(15) )] Due to 
[ORA-01440: column to be modified must be empty to decrease precision or scale

  LOG EVENT {Description=[[SQLERROR] [DESCRIPTION] Failed to upgrade the 
database schema],Detail=[[SQLERRORCODE]=0 [SQLMESSAGE]=Failed to run SQL 
statement [ALTER TABLE FILTER_NOTIFY MODIFY ( BEHAVIOR NUMBER(15) )] Due to 
[ORA-01440: column to be modified must be empty to decrease precision or scale

  LOG EVENT {Description=[[SQLERROR] [DESCRIPTION] Failed to upgrade the 
database schema],Detail=[[SQLERRORCODE]=0 [SQLMESSAGE]=Failed to run SQL 
statement [ALTER TABLE SCHEMA_ARCHIVE MODIFY ( ARCHIVEFROMFORM NUMBER(15) )] 
Due to [ORA-01439: column to be modified must be empty to change datatype


Ken Leihkauff


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


Email Engine Scaling

2011-08-11 Thread Leihkauff, Kenneth G (LEIHKAUFFK)
Hello,

Background: We have an AR system running 7.1, Oracle 10g, Solaris 10.  The ARS 
is running on the same server as the database; there is no Server Group 
configuration.

Question: To scale the email engine, is it possible to run two instances of the 
email engine on the same server and configure each to process separate defined 
mailboxes in the AR System Email Configuration form?  Based on the email engine 
documentation, this seems to be supported.  Do you recommend doing this when 
you are not using a server group and need to scale to accommodate a 
considerably higher volume of messages.  The current configuration (with 
adjustments to the email properties file) performs well, however, we are 
concerned that the email engine may backlog when we double the total volume of 
outgoing messages (we will be doubling the activity in a couple of days).

Thanks for your guidance and experiences.

Ken Leihkauff
North American Integrated Services Management Center (NAISMC)
Science Applications International Corp. (SAIC)

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


Remedy ARS 508 Compliance Evaluation for Government

2011-06-01 Thread Leihkauff, Kenneth G (LEIHKAUFFK)
Hello,

Does anyone know if BMC has provided help with completing the government's 508 
Evaluation Template, like the one shown below?  Thanks for any guidance or 
insight to completing the template or obtaining details from BMC.  I have seen 
BMC's whitepaper for guidance when developing ARS applications, but need to 
complete the required evaluation template when pursuing federal work.

Thank you.

Ken Leihkauff
SAIC

Section 1194.22 Web-based Internet information and applications
*  Refer to ( http://www.access-board.gov/sec508/guide/1194.22.htm) for details 
on the guidelines listed below.

Criteria

Supporting Features

Remarks and explanations

(a) A text equivalent for every non-text element shall be provided (e.g., via 
alt, longdesc, or in element content).





(b) Equivalent alternatives for any multimedia presentation shall be 
synchronized with the presentation.





(c) Web pages shall be designed so that all information conveyed with color is 
also available without color, for example from context or markup.





(d) Documents shall be organized so they are readable without requiring an 
associated style sheet.





(e) Redundant text links shall be provided for each active region of a 
server-side image map.





(f) Client-side image maps shall be provided instead of server-side image maps 
except where the regions cannot be defined with an available geometric shape.





(g) Row and column headers shall be identified for data tables.





(h) Markup shall be used to associate data cells and header cells for data 
tables that have two or more logical levels of row or column headers.





(i) Frames shall be titled with text that facilitates frame identification and 
navigation





(j) Pages shall be designed to avoid causing the screen to flicker with a 
frequency greater than 2 Hz and lower than 55 Hz.





(k) A text-only page, with equivalent information or functionality, shall be 
provided to make a web site comply with the provisions of this part, when 
compliance cannot be accomplished in any other way. The content of the 
text-only page shall be updated whenever the primary page changes.





(l) When pages utilize scripting languages to display content, or to create 
interface elements, the information provided by the script shall be identified 
with functional text that can be read by Assistive Technology.





(m) When a web page requires that an applet, plug-in or other application be 
present on the client system to interpret page content, the page must provide a 
link to a plug-in or applet that complies with 1194.21(a) through (l).





(n) When electronic forms are designed to be completed on-line, the form shall 
allow people using Assistive Technology to access the information, field 
elements, and functionality required for completion and submission of the form, 
including all directions and cues.





(o) A method shall be provided that permits users to skip repetitive navigation 
links.





(p) When a timed response is required, the user shall be alerted and given 
sufficient time to indicate more time is required.









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


Re: Remedy ARS 508 Compliance Evaluation for Government

2011-06-01 Thread Leihkauff, Kenneth G (LEIHKAUFFK)
Thank  you, David!

Ken Leihkauff
North American Integrated Services Management Center (NAISMC)
Science Applications International Corp. (SAIC)
865-481-1329 office
865-659-7440 cell

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Easter, David
Sent: Wednesday, June 01, 2011 6:39 PM
To: arslist@ARSLIST.ORG
Subject: Re: Remedy ARS 508 Compliance Evaluation for Government

**
Yes.  All BMC Remedy products have a VPAT (Voluntary Product Assessment 
Template) available.  Just contact a BMC representative (sales, support, etc.) 
who will have access to them.

-David J. Easter
Manager of Product Management, Remedy Platform
BMC Software, Inc.

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

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Leihkauff, Kenneth G (LEIHKAUFFK)
Sent: Wednesday, June 01, 2011 03:14 PM
To: arslist@ARSLIST.ORG
Subject: Remedy ARS 508 Compliance Evaluation for Government

**
Hello,

Does anyone know if BMC has provided help with completing the government's 508 
Evaluation Template, like the one shown below?  Thanks for any guidance or 
insight to completing the template or obtaining details from BMC.  I have seen 
BMC's whitepaper for guidance when developing ARS applications, but need to 
complete the required evaluation template when pursuing federal work.

Thank you.

Ken Leihkauff
SAIC

Section 1194.22 Web-based Internet information and applications
*  Refer to ( http://www.access-board.gov/sec508/guide/1194.22.htm) for details 
on the guidelines listed below.

Criteria

Supporting Features

Remarks and explanations

(a) A text equivalent for every non-text element shall be provided (e.g., via 
alt, longdesc, or in element content).





(b) Equivalent alternatives for any multimedia presentation shall be 
synchronized with the presentation.





(c) Web pages shall be designed so that all information conveyed with color is 
also available without color, for example from context or markup.





(d) Documents shall be organized so they are readable without requiring an 
associated style sheet.





(e) Redundant text links shall be provided for each active region of a 
server-side image map.





(f) Client-side image maps shall be provided instead of server-side image maps 
except where the regions cannot be defined with an available geometric shape.





(g) Row and column headers shall be identified for data tables.





(h) Markup shall be used to associate data cells and header cells for data 
tables that have two or more logical levels of row or column headers.





(i) Frames shall be titled with text that facilitates frame identification and 
navigation





(j) Pages shall be designed to avoid causing the screen to flicker with a 
frequency greater than 2 Hz and lower than 55 Hz.





(k) A text-only page, with equivalent information or functionality, shall be 
provided to make a web site comply with the provisions of this part, when 
compliance cannot be accomplished in any other way. The content of the 
text-only page shall be updated whenever the primary page changes.





(l) When pages utilize scripting languages to display content, or to create 
interface elements, the information provided by the script shall be identified 
with functional text that can be read by Assistive Technology.





(m) When a web page requires that an applet, plug-in or other application be 
present on the client system to interpret page content, the page must provide a 
link to a plug-in or applet that complies with 1194.21(a) through (l).





(n) When electronic forms are designed to be completed on-line, the form shall 
allow people using Assistive Technology to access the information, field 
elements, and functionality required for completion and submission of the form, 
including all directions and cues.





(o) A method shall be provided that permits users to skip repetitive navigation 
links.





(p) When a timed response is required, the user shall be alerted and given 
sufficient time to indicate more time is required.








_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