date:20151020

Re: Upgrade advice

2015-10-20 Thread Rick Cook

Assuming that you are talking about custom code, there shouldn't be any
issues between 8.x and 9.  If you were pre-v7, there would be a few issues,
but you're probably good.

Rick
On Oct 20, 2015 5:35 AM, "Williamson, Victoria (CIV)" <
victoria.william...@usdoj.gov> wrote:

> **
>
> Good Morning Y’all!
>
>
>
> I will be upgrading a unique system where as the majority of the
> modifications are done as ARSystem and not in ITSM.  I have the
> documentation on the how to for the ITSM 8.2 => 9.*.  The question is
> what’s the best plan for the ‘other stuff’.  Because it’s built in ARSystem
> does it need to be upgraded too?  Or can we ‘reuse’ it after the ITSM
> upgrade? Any advice on this endeavor is very welcome.  Thank you.
>
>
>
> Very Respectfully,
>
>
>
> Victoria Williamson
>
> Remedy Development Manager
>
> 202-514-4759
>
>
> _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"

Remedy 9.0 SQL requirements

2015-10-20 Thread Ryan Nicosia

I've looked through the 9.0 upgrade documentation and outside of some basic 
sizing guidelines I'm not really finding what I'm looking for.

I've also downloaded the worksheet that BMC put together for planning your 
resource requirements for 9.0 install based on users, ticket throughput, etc.

What I am after are recommendations on a virtualized Microsoft SQL cluster and 
what we should provide to our SQL team on how SQL should be provisioned to 
support Remedy.  In the past, we ran into several issues with DB connectivity 
from ARS due to an unidentifiable issue with latency between the cluster 
(veritas in this instance) and the storage array where the database was 
actually housed.  The only solution was to revert back to a physical SQL server.

We want to avoid this situation with our 9.0 upgrade by ensuring all of the SQL 
requirements are provided up front.  Unfortunately, it looks like BMC 
documentation is kind of lacking in this regard.

So, for anybody that has upgraded to 9.0 and has a large user base and large DB 
with a lot of transactions, do you have any lessons learned or recommendations 
for Microsoft SQL server in a clustered environment?

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

Re: Upgrade advice

2015-10-20 Thread Williamson, Victoria (CIV)

Yes, this makes sense.  Thank you.

V/R,

~Vic
X44759

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of BradRemedy
Sent: Tuesday, October 20, 2015 9:48 AM
To: arslist@ARSLIST.ORG
Subject: Re: Upgrade advice

**
Hi Williamson

Probably best to review what that modifications are doing. Do these 
modifications integrate with ITSM at all or are they a totally separate 
application?

Depending on what the modifications are doing will affect whether you can 
simple bring them across untouched or whether you need to review the code and 
amend where required.

Hope this makes sense

Cheers
Brad

On Tue, Oct 20, 2015 at 2:15 PM, Williamson, Victoria (CIV) 
> wrote:
**
Good Morning Y’all!

I will be upgrading a unique system where as the majority of the modifications 
are done as ARSystem and not in ITSM.  I have the documentation on the how to 
for the ITSM 8.2 => 9.*.  The question is what’s the best plan for the ‘other 
stuff’.  Because it’s built in ARSystem does it need to be upgraded too?  Or 
can we ‘reuse’ it after the ITSM upgrade? Any advice on this endeavor is very 
welcome.  Thank you.

Very Respectfully,

Victoria Williamson
Remedy Development Manager
202-514-4759

_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: Upgrade advice

2015-10-20 Thread Williamson, Victoria (CIV)

Yes; Thank you.

V/R,

~Vic
X44759

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Cook
Sent: Tuesday, October 20, 2015 9:59 AM
To: arslist@ARSLIST.ORG
Subject: Re: Upgrade advice

**

Assuming that you are talking about custom code, there shouldn't be any issues 
between 8.x and 9.  If you were pre-v7, there would be a few issues, but you're 
probably good.

Rick
On Oct 20, 2015 5:35 AM, "Williamson, Victoria (CIV)" 
> wrote:
**
Good Morning Y’all!

I will be upgrading a unique system where as the majority of the modifications 
are done as ARSystem and not in ITSM.  I have the documentation on the how to 
for the ITSM 8.2 => 9.*.  The question is what’s the best plan for the ‘other 
stuff’.  Because it’s built in ARSystem does it need to be upgraded too?  Or 
can we ‘reuse’ it after the ITSM upgrade? Any advice on this endeavor is very 
welcome.  Thank you.

Very Respectfully,

Victoria Williamson
Remedy Development Manager
202-514-4759

_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: Email Struggles

2015-10-20 Thread Warren R. Baltimore II

We've tried upgrading Java in the past.  Darn thing won't work with the
newer versions!  I'll take a look.

Warren

On Mon, Oct 19, 2015 at 10:10 PM,  wrote:

> **
> Would not be surprised here warren
> 1.4.2_07 ?  Really???
>
> This might help
> I would update a few versions
> I do see 6.x and still wondering why...
> But I would not be surprised if your Java has a lot to do with it. It
> could be as simple as you are using TLS 1.0
> Would have to look at it...
>
> http://www.oracle.com/technetwork/java/javase/documentation/overview-142120.html
>
> Sent from my iPhone
>
> On Oct 19, 2015, at 11:45 AM, Ken Pritchard  > wrote:
>
> **
>
> Did something in your environment change to where certificates are now
> needed when they weren’t before?  Not necessarily just the Remedy system,
> but also network protocols?  I’m not a big cert guy, but I know in our
> environment new policies come out from time to time that affect how
> connections and ‘stuff’ work.
>
>
>
> *From:* Action Request System discussion list(ARSList) [
> mailto:arslist@ARSLIST.ORG ] *On Behalf Of *Warren
> R. Baltimore II
> *Sent:* Monday, October 19, 2015 9:24 AM
> *To:* arslist@ARSLIST.ORG 
> *Subject:* Re: Email Struggles
>
>
>
> **
>
> Problem is, I can't find a cert that expired on that day!  In fact, none
> of them are set to expire this year.
>
>
>
> On Mon, Oct 19, 2015 at 9:15 AM,  wrote:
>
> Warren:
>
> Sounds like your cert has expired on your server that is running the
> Remedy Email client.  All certs have an expiry date.  You will have to go
> to your server management group and have them re-issue the cert for this
> server (from your cert provider, whomever that is).  Then, you can install
> it on your server and you should be golden.
>
>
>
> You should also have them check the expiry date of the Microsoft 365
> server certificate as well... :-)
>
>
>
> Terry
>
>
>
>
>
>
>
> On 2015-10-19 08:32, Warren R. Baltimore II wrote:
>
> **
>
> ARS 6.3 patch 16
>
> Solaris SunOS 5.10
>
> Java SDK 1.4.2_07
>
>
>
> I'm having a problem.
>
>
>
> I connect using IMAP4 to a Microsoft 365 server to download my email.
> I've been using this method for a couple of years now without problems.
> Prior to that, I had been using MBOX.  I have been supporting this server
> for 7 years now and not once have I loaded a certificate for SSL.
>
>
>
> On Wednesday evening, my server stopped downloading email from Office
> 365.  In the aremaild.sh_log file, I see the following error:
>
>
>
> Oct 19, 2015 7:55:27 AM com.sun.mail.imap.IMAPStore protocolConnect
>
> SEVERE: sun.security.validator.ValidatorException: No trusted certificate
> found;
>
>   nested exception is:
>
> javax.net.ssl.SSLHandshakeException:
> sun.security.validator.ValidatorException: No trusted certificate found
>
> javax.mail.MessagingException: sun.security.validator.ValidatorException:
> No trusted certificate found;
>
>   nested exception is:
>
> javax.net.ssl.SSLHandshakeException:
> sun.security.validator.ValidatorException: No trusted certificate found
>
> at com.sun.mail.imap.IMAPStore.protocolConnect(IMAPStore.java:303)
>
> at javax.mail.Service.connect(Service.java:233)
>
> at javax.mail.Service.connect(Service.java:134)
>
> at
> com.remedy.arsys.emaildaemon.ReceiverModule.initializeIncommingMailbox(ReceiverModule.java:1687)
>
> at
> com.remedy.arsys.emaildaemon.ReceiverModule.initialization(ReceiverModule.java:470)
>
> at
> com.remedy.arsys.emaildaemon.ReceiverModule.doWork(ReceiverModule.java:170)
>
> at com.remedy.arsys.emaildaemon.ThreadBase.run(ThreadBase.java:268)
>
> at java.lang.Thread.run(Thread.java:534)
>
>
>
>  Microsoft has said that they have not made any changes on their end.  My
> UNIX team tells me no changes have been made there (and I believe them).
>
>
>
> I've done quite a few searches against these errors.  Everything seems to
> be pointing to a certificate issue on my end.  But I'm not really sure
> exactly what I need to do to update it.  From what I can tell, I need to
> make the change to the cacerts file at:  /usr/java142_07/jre/lib/security.
> I'm afraid the instructions for updating or creating these certs are a bit
> hazy.  And the manual from Remedy is next to useless (due to the multiple
> methodologies to do this thing).  Could somebody point me in the right
> direction?  Do I need a cert from Microsoft?  Or is this something I need
> to get from somewhere else?
>
>
>
> Any suggestions would be greatly appreciated!
>
> --
>
>
>
> Warren R. Baltimore II
> Remedy Developer
> 410-533-5367
>
> _ARSlist: "Where the Answers Are" and have been for 20 years_
>
>
>
>
> --
>
> Warren R. Baltimore II
> Remedy Developer
> 410-533-5367
>
> _ARSlist: "Where the Answers Are" and have been for 20 years_
> _ARSlist: "Where the Answers Are" and have been for

Upgrade advice

2015-10-20 Thread Williamson, Victoria (CIV)

Good Morning Y'all!

I will be upgrading a unique system where as the majority of the modifications 
are done as ARSystem and not in ITSM.  I have the documentation on the how to 
for the ITSM 8.2 => 9.*.  The question is what's the best plan for the 'other 
stuff'.  Because it's built in ARSystem does it need to be upgraded too?  Or 
can we 'reuse' it after the ITSM upgrade? Any advice on this endeavor is very 
welcome.  Thank you.

Very Respectfully,

Victoria Williamson
Remedy Development Manager
202-514-4759


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

Re: Email Struggles

2015-10-20 Thread Warren R. Baltimore II

Mission accomplished!  In the past, when we attempted to use the newer
versions of Java, it would kill the email process.  I got to thinking that
when we tried that previously, we were using very different approaches to
the retrieving email (MBOX).  I had never tried using the newer versions
with IMAP.  So, I pointed the email daemon at the newest version
(jdk1.6.0_101) and surprise!  It worked!

Thanks for getting me to think about that Pat!

On Tue, Oct 20, 2015 at 7:49 AM, Warren R. Baltimore II <
warrenbaltim...@gmail.com> wrote:

> We've tried upgrading Java in the past.  Darn thing won't work with the
> newer versions!  I'll take a look.
>
> Warren
>
> On Mon, Oct 19, 2015 at 10:10 PM,  wrote:
>
>> **
>> Would not be surprised here warren
>> 1.4.2_07 ?  Really???
>>
>> This might help
>> I would update a few versions
>> I do see 6.x and still wondering why...
>> But I would not be surprised if your Java has a lot to do with it. It
>> could be as simple as you are using TLS 1.0
>> Would have to look at it...
>>
>> http://www.oracle.com/technetwork/java/javase/documentation/overview-142120.html
>>
>> Sent from my iPhone
>>
>> On Oct 19, 2015, at 11:45 AM, Ken Pritchard > > wrote:
>>
>> **
>>
>> Did something in your environment change to where certificates are now
>> needed when they weren’t before?  Not necessarily just the Remedy system,
>> but also network protocols?  I’m not a big cert guy, but I know in our
>> environment new policies come out from time to time that affect how
>> connections and ‘stuff’ work.
>>
>>
>>
>> *From:* Action Request System discussion list(ARSList) [
>> mailto:arslist@ARSLIST.ORG ] *On Behalf Of *Warren
>> R. Baltimore II
>> *Sent:* Monday, October 19, 2015 9:24 AM
>> *To:* arslist@ARSLIST.ORG 
>> *Subject:* Re: Email Struggles
>>
>>
>>
>> **
>>
>> Problem is, I can't find a cert that expired on that day!  In fact, none
>> of them are set to expire this year.
>>
>>
>>
>> On Mon, Oct 19, 2015 at 9:15 AM,  wrote:
>>
>> Warren:
>>
>> Sounds like your cert has expired on your server that is running the
>> Remedy Email client.  All certs have an expiry date.  You will have to go
>> to your server management group and have them re-issue the cert for this
>> server (from your cert provider, whomever that is).  Then, you can install
>> it on your server and you should be golden.
>>
>>
>>
>> You should also have them check the expiry date of the Microsoft 365
>> server certificate as well... :-)
>>
>>
>>
>> Terry
>>
>>
>>
>>
>>
>>
>>
>> On 2015-10-19 08:32, Warren R. Baltimore II wrote:
>>
>> **
>>
>> ARS 6.3 patch 16
>>
>> Solaris SunOS 5.10
>>
>> Java SDK 1.4.2_07
>>
>>
>>
>> I'm having a problem.
>>
>>
>>
>> I connect using IMAP4 to a Microsoft 365 server to download my email.
>> I've been using this method for a couple of years now without problems.
>> Prior to that, I had been using MBOX.  I have been supporting this server
>> for 7 years now and not once have I loaded a certificate for SSL.
>>
>>
>>
>> On Wednesday evening, my server stopped downloading email from Office
>> 365.  In the aremaild.sh_log file, I see the following error:
>>
>>
>>
>> Oct 19, 2015 7:55:27 AM com.sun.mail.imap.IMAPStore protocolConnect
>>
>> SEVERE: sun.security.validator.ValidatorException: No trusted certificate
>> found;
>>
>>   nested exception is:
>>
>> javax.net.ssl.SSLHandshakeException:
>> sun.security.validator.ValidatorException: No trusted certificate found
>>
>> javax.mail.MessagingException: sun.security.validator.ValidatorException:
>> No trusted certificate found;
>>
>>   nested exception is:
>>
>> javax.net.ssl.SSLHandshakeException:
>> sun.security.validator.ValidatorException: No trusted certificate found
>>
>> at com.sun.mail.imap.IMAPStore.protocolConnect(IMAPStore.java:303)
>>
>> at javax.mail.Service.connect(Service.java:233)
>>
>> at javax.mail.Service.connect(Service.java:134)
>>
>> at
>> com.remedy.arsys.emaildaemon.ReceiverModule.initializeIncommingMailbox(ReceiverModule.java:1687)
>>
>> at
>> com.remedy.arsys.emaildaemon.ReceiverModule.initialization(ReceiverModule.java:470)
>>
>> at
>> com.remedy.arsys.emaildaemon.ReceiverModule.doWork(ReceiverModule.java:170)
>>
>> at
>> com.remedy.arsys.emaildaemon.ThreadBase.run(ThreadBase.java:268)
>>
>> at java.lang.Thread.run(Thread.java:534)
>>
>>
>>
>>  Microsoft has said that they have not made any changes on their end.  My
>> UNIX team tells me no changes have been made there (and I believe them).
>>
>>
>>
>> I've done quite a few searches against these errors.  Everything seems to
>> be pointing to a certificate issue on my end.  But I'm not really sure
>> exactly what I need to do to update it.  From what I can tell, I need to
>> make the change to the cacerts file at:  /usr/java142_07/jre/lib/security.
>> I'm afraid the

Re: User tool and Newer AR server

2015-10-20 Thread LJ LongWing

hmmm...not sure how 20K is breaking downbut the interesting thing for
me is that both the log for user and web both show 20k, but you say the web
is working but user isn't

On Tue, Oct 20, 2015 at 11:54 AM, Grooms, Frederick W <
frederick.w.gro...@xo.com> wrote:

> **
>
> 1000
>
>
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> arslist@ARSLIST.ORG] *On Behalf Of *LJ LongWing
> *Sent:* Tuesday, October 20, 2015 11:31 AM
> *To:* arslist@ARSLIST.ORG
> *Subject:* Re: User tool and Newer AR server
>
>
>
> **
>
> I've seen that be the server side table chunk size too, what's that set to?
>
> Sent with AquaMail for Android
> http://www.aqua-mail.com
>
> -Original Message-
>
> On October 20, 2015 10:06:32 AM "Grooms, Frederick W"  wrote:
>
> **
>
> Actually my Max Entries Returned By GetList = 5000
>
>
>
> I’m not sure where the 20k comes from as I did a grep on the server and
> couldn’t find any place where I have 20k
>
>
>
>
>
> *From:* Action Request System discussion list(ARSList) [
> mailto:arslist@ARSLIST.ORG ] *On Behalf Of *LJ
> LongWing
> *Sent:* Tuesday, October 20, 2015 10:46 AM
> *To:* arslist@ARSLIST.ORG
> *Subject:* Re: User tool and Newer AR server
>
>
>
> **
>
> Fred,
>
> Do you have your server properties set to return a maximum of 20K records?
>
>
>
> -Original Message-
>
> On Tue, Oct 20, 2015 at 9:00 AM, Grooms, Frederick W  wrote:
>
> We just found another place where a newer AR Server breaks using the User
> Tool.  (Yes I know, we are trying to get users to move off of it)
>
> AR Server   8.1.02 201408260235  (RedHat Linux)
> AR User  7.6.04 SP4  Sep , 6 2012
>
> We have a regular form to hold Zip codes.(42,000 + records)
> There is a search menu against that form to list the State values (Label
> Field "State", Value Field "State", Sort on Label, Qualification: 'Status'
> = "Active")
>
> When we were using the menu against a 7.6.04 server everything worked
> correctly.  Now that we have upgraded the server to 8.1.02 the User tool
> doesn't show the complete list anymore.
>
> I went and captured SQL logs.
> In User tool when opening a menu the selections are not complete.
>  /* Mon Oct 19 2015 16:45:15.6810 */+API call
>
>/* Mon Oct
> 19 2015 16:45:15.6803 */+EXPQRY ARExpandQueryMenu from Remedy User
> (protocol 18) at IP address 192.168.101.98  //
>
>/* Mon Oct
> 19 2015 16:45:15.6805 */SELECT  * FROM ( SELECT  T98.C1,C536870923 FROM T98
> WHERE (T98.C7 = 0) ORDER BY C536870923 ASC, 1 ASC ) WHERE ROWNUM <= 20001
>
>/* Mon Oct
> 19 2015 16:45:15.7677 */OK
>
>/* Mon Oct
> 19 2015 16:45:15.9169 */SELECT COUNT(*) FROM T98 WHERE (T98.C7 = 0)
>
>/* Mon Oct
> 19 2015 16:45:15.9393 */OK
>
>/* Mon Oct
> 19 2015 16:45:15.9584 */-EXPQRY   OK
>  /* Mon Oct 19 2015 16:45:15.9620 */-API call
>
> In Mid-Tier we get all the records.
>  /* Mon Oct 19 2015 16:37:37.260 */+HTTP call
>
>/* Mon Oct 19 2015 16:37:37.2815 */+EXPQRY ARExpandQueryMenu from
> Mid-tier (protocol 20) at IP address 192.168.107.150  //
>/* Mon Oct 19 2015 16:37:37.2817 */SELECT  * FROM ( SELECT DISTINCT
> 'no C1',C536870923 FROM T98 WHERE (T98.C7 = 0) ORDER BY C536870923 ASC, 1
> ASC ) WHERE ROWNUM <= 20001
>/* Mon Oct 19 2015 16:37:37.3187 */OK
>/* Mon Oct 19 2015 16:37:37.3202 */-EXPQRY   OK
>  (ARNOTE 8914)
>
>  /* Mon Oct 19 2015 16:37:37.277 */+MidTier
> ExpandMenu/20/ZIP:Valid_State_List//
>  /* Mon Oct 19 2015 16:37:37.281 */+API call, Procedure #55
>
>/* Mon Oct
> 19 2015 16:37:37.2815 */+EXPQRY ARExpandQueryMenu from Mid-tier (protocol
> 20) at IP address 192.168.107.150  //
>
>/* Mon Oct
> 19 2015 16:37:37.2817 */SELECT  * FROM ( SELECT DISTINCT 'no C1',C536870923
> FROM T98 WHERE (T98.C7 = 0) ORDER BY C536870923 ASC, 1 ASC ) WHERE ROWNUM
> <= 20001
>
>/* Mon Oct
> 19 2015 16:37:37.3187 */OK
>
>/* Mon Oct
> 19 2015 16:37:37.3202 */-EXPQRY   OK
>  /* Mon Oct 19 2015 16:37:37.320 */-API call, Procedure #55
>
> Fred
>
>
>
>
>
>
> _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: User tool and Newer AR server

2015-10-20 Thread Grooms, Frederick W

That is cause the Web log shows
  SELECT DISTINCT 'no C1',C536870923 FROM T98 WHERE (T98.C7 = 0) ORDER BY 
C536870923 ASC, 1 ASC
versus the User tool log showing
  SELECT  T98.C1,C536870923 FROM T98 WHERE (T98.C7 = 0) ORDER BY C536870923 
ASC, 1 ASC

The DISTINCT ‘no C1’ will only bring back from the database the 50 some records 
of the States (much more efficient than doing the distinct inside the AR Server 
process)

Fred

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing
Sent: Tuesday, October 20, 2015 1:47 PM
To: arslist@ARSLIST.ORG
Subject: Re: User tool and Newer AR server

**
hmmm...not sure how 20K is breaking downbut the interesting thing for me is 
that both the log for user and web both show 20k, but you say the web is 
working but user isn't

On Tue, Oct 20, 2015 at 11:54 AM, Grooms, Frederick W 
> wrote:
**
1000

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of LJ 
LongWing
Sent: Tuesday, October 20, 2015 11:31 AM
To: arslist@ARSLIST.ORG
Subject: Re: User tool and Newer AR server

**

I've seen that be the server side table chunk size too, what's that set to?

Sent with AquaMail for Android
http://www.aqua-mail.com
-Original Message-

On October 20, 2015 10:06:32 AM "Grooms, Frederick W"  wrote:
**
Actually my Max Entries Returned By GetList = 5000

I’m not sure where the 20k comes from as I did a grep on the server and 
couldn’t find any place where I have 20k


From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing
Sent: Tuesday, October 20, 2015 10:46 AM
To: arslist@ARSLIST.ORG
Subject: Re: User tool and Newer AR server

**
Fred,
Do you have your server properties set to return a maximum of 20K records?

-Original Message-
On Tue, Oct 20, 2015 at 9:00 AM, Grooms, Frederick W  wrote:
We just found another place where a newer AR Server breaks using the User Tool. 
 (Yes I know, we are trying to get users to move off of it)

AR Server   8.1.02 201408260235  (RedHat Linux)
AR User  7.6.04 SP4  Sep , 6 2012

We have a regular form to hold Zip codes.(42,000 + records)
There is a search menu against that form to list the State values (Label Field 
"State", Value Field "State", Sort on Label, Qualification: 'Status' = "Active")

When we were using the menu against a 7.6.04 server everything worked 
correctly.  Now that we have upgraded the server to 8.1.02 the User tool 
doesn't show the complete list anymore.

I went and captured SQL logs.
In User tool when opening a menu the selections are not complete.
 /* Mon Oct 19 2015 16:45:15.6810 */+API call
   /* Mon Oct 19 2015 
16:45:15.6803 */+EXPQRY ARExpandQueryMenu from Remedy User (protocol 18) at IP 
address 192.168.101.98  //
   /* Mon Oct 19 2015 
16:45:15.6805 */SELECT  * FROM ( SELECT  T98.C1,C536870923 FROM T98 WHERE 
(T98.C7 = 0) ORDER BY C536870923 ASC, 1 ASC ) WHERE ROWNUM <= 20001
   /* Mon Oct 19 2015 
16:45:15.7677 */OK
   /* Mon Oct 19 2015 
16:45:15.9169 */SELECT COUNT(*) FROM T98 WHERE (T98.C7 = 0)
   /* Mon Oct 19 2015 
16:45:15.9393 */OK
   /* Mon Oct 19 2015 
16:45:15.9584 */-EXPQRY   OK
 /* Mon Oct 19 2015 16:45:15.9620 */-API call

In Mid-Tier we get all the records.
 /* Mon Oct 19 2015 16:37:37.260 */+HTTP call

   /* Mon Oct 19 2015 16:37:37.2815 */+EXPQRY ARExpandQueryMenu from 
Mid-tier (protocol 20) at IP address 192.168.107.150  //
   /* Mon Oct 19 2015 16:37:37.2817 */SELECT  * FROM ( SELECT DISTINCT 'no 
C1',C536870923 FROM T98 WHERE (T98.C7 = 0) ORDER BY C536870923 ASC, 1 ASC ) 
WHERE ROWNUM <= 20001
   /* Mon Oct 19 2015 16:37:37.3187 */OK
   /* Mon Oct 19 2015 16:37:37.3202 */-EXPQRY   OK
 (ARNOTE 8914)

 /* Mon Oct 19 2015 16:37:37.277 */+MidTier 
ExpandMenu/20/ZIP:Valid_State_List//
 /* Mon Oct 19 2015 16:37:37.281 */+API call, Procedure #55
   /* Mon Oct 19 2015 
16:37:37.2815 */+EXPQRY ARExpandQueryMenu from Mid-tier (protocol 20) at IP 
address 192.168.107.150  //
   /* Mon Oct 19 2015 
16:37:37.2817 */SELECT  * FROM ( SELECT DISTINCT 'no C1',C536870923 FROM T98 
WHERE (T98.C7 = 0) ORDER BY C536870923 ASC, 1 ASC ) WHERE ROWNUM <= 20001
   /* Mon Oct 19 2015 
16:37:37.3187 */OK
   /* Mon Oct 19 2015 
16:37:37.3202 */-EXPQRY   OK
 /* Mon Oct 19 2015 16:37:37.320 */-API call, Procedure #55

Fred



_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: User tool and Newer AR server

2015-10-20 Thread Grooms, Frederick W

1000

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing
Sent: Tuesday, October 20, 2015 11:31 AM
To: arslist@ARSLIST.ORG
Subject: Re: User tool and Newer AR server

**

I've seen that be the server side table chunk size too, what's that set to?

Sent with AquaMail for Android
http://www.aqua-mail.com
-Original Message-

On October 20, 2015 10:06:32 AM "Grooms, Frederick W"  wrote:
**
Actually my Max Entries Returned By GetList = 5000

I’m not sure where the 20k comes from as I did a grep on the server and 
couldn’t find any place where I have 20k


From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing
Sent: Tuesday, October 20, 2015 10:46 AM
To: arslist@ARSLIST.ORG
Subject: Re: User tool and Newer AR server

**
Fred,
Do you have your server properties set to return a maximum of 20K records?

-Original Message-
On Tue, Oct 20, 2015 at 9:00 AM, Grooms, Frederick W  wrote:
We just found another place where a newer AR Server breaks using the User Tool. 
 (Yes I know, we are trying to get users to move off of it)

AR Server   8.1.02 201408260235  (RedHat Linux)
AR User  7.6.04 SP4  Sep , 6 2012

We have a regular form to hold Zip codes.(42,000 + records)
There is a search menu against that form to list the State values (Label Field 
"State", Value Field "State", Sort on Label, Qualification: 'Status' = "Active")

When we were using the menu against a 7.6.04 server everything worked 
correctly.  Now that we have upgraded the server to 8.1.02 the User tool 
doesn't show the complete list anymore.

I went and captured SQL logs.
In User tool when opening a menu the selections are not complete.
 /* Mon Oct 19 2015 16:45:15.6810 */+API call
   /* Mon Oct 19 2015 
16:45:15.6803 */+EXPQRY ARExpandQueryMenu from Remedy User (protocol 18) at IP 
address 192.168.101.98  //
   /* Mon Oct 19 2015 
16:45:15.6805 */SELECT  * FROM ( SELECT  T98.C1,C536870923 FROM T98 WHERE 
(T98.C7 = 0) ORDER BY C536870923 ASC, 1 ASC ) WHERE ROWNUM <= 20001
   /* Mon Oct 19 2015 
16:45:15.7677 */OK
   /* Mon Oct 19 2015 
16:45:15.9169 */SELECT COUNT(*) FROM T98 WHERE (T98.C7 = 0)
   /* Mon Oct 19 2015 
16:45:15.9393 */OK
   /* Mon Oct 19 2015 
16:45:15.9584 */-EXPQRY   OK
 /* Mon Oct 19 2015 16:45:15.9620 */-API call

In Mid-Tier we get all the records.
 /* Mon Oct 19 2015 16:37:37.260 */+HTTP call

   /* Mon Oct 19 2015 16:37:37.2815 */+EXPQRY ARExpandQueryMenu from 
Mid-tier (protocol 20) at IP address 192.168.107.150  //
   /* Mon Oct 19 2015 16:37:37.2817 */SELECT  * FROM ( SELECT DISTINCT 'no 
C1',C536870923 FROM T98 WHERE (T98.C7 = 0) ORDER BY C536870923 ASC, 1 ASC ) 
WHERE ROWNUM <= 20001
   /* Mon Oct 19 2015 16:37:37.3187 */OK
   /* Mon Oct 19 2015 16:37:37.3202 */-EXPQRY   OK
 (ARNOTE 8914)

 /* Mon Oct 19 2015 16:37:37.277 */+MidTier 
ExpandMenu/20/ZIP:Valid_State_List//
 /* Mon Oct 19 2015 16:37:37.281 */+API call, Procedure #55
   /* Mon Oct 19 2015 
16:37:37.2815 */+EXPQRY ARExpandQueryMenu from Mid-tier (protocol 20) at IP 
address 192.168.107.150  //
   /* Mon Oct 19 2015 
16:37:37.2817 */SELECT  * FROM ( SELECT DISTINCT 'no C1',C536870923 FROM T98 
WHERE (T98.C7 = 0) ORDER BY C536870923 ASC, 1 ASC ) WHERE ROWNUM <= 20001
   /* Mon Oct 19 2015 
16:37:37.3187 */OK
   /* Mon Oct 19 2015 
16:37:37.3202 */-EXPQRY   OK
 /* Mon Oct 19 2015 16:37:37.320 */-API call, Procedure #55

Fred




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

Re: User tool and Newer AR server

2015-10-20 Thread LJ LongWing

Fred,
Do you have your server properties set to return a maximum of 20K records?

On Tue, Oct 20, 2015 at 9:00 AM, Grooms, Frederick W <
frederick.w.gro...@xo.com> wrote:

> We just found another place where a newer AR Server breaks using the User
> Tool.  (Yes I know, we are trying to get users to move off of it)
>
> AR Server   8.1.02 201408260235
> AR User  7.6.04 SP4  Sep , 6 2012
>
> We have a regular form to hold Zip codes.(42,000 + records)
> There is a search menu against that form to list the State values (Label
> Field "State", Value Field "State", Sort on Label, Qualification: 'Status'
> = "Active")
>
> When we were using the menu against a 7.6.04 server everything worked
> correctly.  Now that we have upgraded the server to 8.1.02 the User tool
> doesn't show the complete list anymore.
>
> I went and captured SQL logs.
> In User tool when opening a menu the selections are not complete.
>  /* Mon Oct 19 2015 16:45:15.6810 */+API call
>
>/* Mon Oct
> 19 2015 16:45:15.6803 */+EXPQRY ARExpandQueryMenu from Remedy User
> (protocol 18) at IP address 192.168.101.98  //
>
>/* Mon Oct
> 19 2015 16:45:15.6805 */SELECT  * FROM ( SELECT  T98.C1,C536870923 FROM T98
> WHERE (T98.C7 = 0) ORDER BY C536870923 ASC, 1 ASC ) WHERE ROWNUM <= 20001
>
>/* Mon Oct
> 19 2015 16:45:15.7677 */OK
>
>/* Mon Oct
> 19 2015 16:45:15.9169 */SELECT COUNT(*) FROM T98 WHERE (T98.C7 = 0)
>
>/* Mon Oct
> 19 2015 16:45:15.9393 */OK
>
>/* Mon Oct
> 19 2015 16:45:15.9584 */-EXPQRY   OK
>  /* Mon Oct 19 2015 16:45:15.9620 */-API call
>
> In Mid-Tier we get all the records.
>  /* Mon Oct 19 2015 16:37:37.260 */+HTTP call
>
>/* Mon Oct 19 2015 16:37:37.2815 */+EXPQRY ARExpandQueryMenu from
> Mid-tier (protocol 20) at IP address 192.168.107.150  //
>/* Mon Oct 19 2015 16:37:37.2817 */SELECT  * FROM ( SELECT DISTINCT
> 'no C1',C536870923 FROM T98 WHERE (T98.C7 = 0) ORDER BY C536870923 ASC, 1
> ASC ) WHERE ROWNUM <= 20001
>/* Mon Oct 19 2015 16:37:37.3187 */OK
>/* Mon Oct 19 2015 16:37:37.3202 */-EXPQRY   OK
>  (ARNOTE 8914)
>
>  /* Mon Oct 19 2015 16:37:37.277 */+MidTier
> ExpandMenu/20/ZIP:Valid_State_List//
>  /* Mon Oct 19 2015 16:37:37.281 */+API call, Procedure #55
>
>/* Mon Oct
> 19 2015 16:37:37.2815 */+EXPQRY ARExpandQueryMenu from Mid-tier (protocol
> 20) at IP address 192.168.107.150  //
>
>/* Mon Oct
> 19 2015 16:37:37.2817 */SELECT  * FROM ( SELECT DISTINCT 'no C1',C536870923
> FROM T98 WHERE (T98.C7 = 0) ORDER BY C536870923 ASC, 1 ASC ) WHERE ROWNUM
> <= 20001
>
>/* Mon Oct
> 19 2015 16:37:37.3187 */OK
>
>/* Mon Oct
> 19 2015 16:37:37.3202 */-EXPQRY   OK
>  /* Mon Oct 19 2015 16:37:37.320 */-API call, Procedure #55
>
> Fred
>
>
>
> ___
> 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: User tool and Newer AR server

2015-10-20 Thread Grooms, Frederick W

Actually my Max Entries Returned By GetList = 5000

I’m not sure where the 20k comes from as I did a grep on the server and 
couldn’t find any place where I have 20k


From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing
Sent: Tuesday, October 20, 2015 10:46 AM
To: arslist@ARSLIST.ORG
Subject: Re: User tool and Newer AR server

**
Fred,
Do you have your server properties set to return a maximum of 20K records?

-Original Message-
On Tue, Oct 20, 2015 at 9:00 AM, Grooms, Frederick W  wrote:
We just found another place where a newer AR Server breaks using the User Tool. 
 (Yes I know, we are trying to get users to move off of it)

AR Server   8.1.02 201408260235  (RedHat Linux)
AR User  7.6.04 SP4  Sep , 6 2012

We have a regular form to hold Zip codes.(42,000 + records)
There is a search menu against that form to list the State values (Label Field 
"State", Value Field "State", Sort on Label, Qualification: 'Status' = "Active")

When we were using the menu against a 7.6.04 server everything worked 
correctly.  Now that we have upgraded the server to 8.1.02 the User tool 
doesn't show the complete list anymore.

I went and captured SQL logs.
In User tool when opening a menu the selections are not complete.
 /* Mon Oct 19 2015 16:45:15.6810 */+API call
   /* Mon Oct 19 2015 
16:45:15.6803 */+EXPQRY ARExpandQueryMenu from Remedy User (protocol 18) at IP 
address 192.168.101.98  //
   /* Mon Oct 19 2015 
16:45:15.6805 */SELECT  * FROM ( SELECT  T98.C1,C536870923 FROM T98 WHERE 
(T98.C7 = 0) ORDER BY C536870923 ASC, 1 ASC ) WHERE ROWNUM <= 20001
   /* Mon Oct 19 2015 
16:45:15.7677 */OK
   /* Mon Oct 19 2015 
16:45:15.9169 */SELECT COUNT(*) FROM T98 WHERE (T98.C7 = 0)
   /* Mon Oct 19 2015 
16:45:15.9393 */OK
   /* Mon Oct 19 2015 
16:45:15.9584 */-EXPQRY   OK
 /* Mon Oct 19 2015 16:45:15.9620 */-API call

In Mid-Tier we get all the records.
 /* Mon Oct 19 2015 16:37:37.260 */+HTTP call

   /* Mon Oct 19 2015 16:37:37.2815 */+EXPQRY ARExpandQueryMenu from 
Mid-tier (protocol 20) at IP address 192.168.107.150  //
   /* Mon Oct 19 2015 16:37:37.2817 */SELECT  * FROM ( SELECT DISTINCT 'no 
C1',C536870923 FROM T98 WHERE (T98.C7 = 0) ORDER BY C536870923 ASC, 1 ASC ) 
WHERE ROWNUM <= 20001
   /* Mon Oct 19 2015 16:37:37.3187 */OK
   /* Mon Oct 19 2015 16:37:37.3202 */-EXPQRY   OK
 (ARNOTE 8914)

 /* Mon Oct 19 2015 16:37:37.277 */+MidTier 
ExpandMenu/20/ZIP:Valid_State_List//
 /* Mon Oct 19 2015 16:37:37.281 */+API call, Procedure #55
   /* Mon Oct 19 2015 
16:37:37.2815 */+EXPQRY ARExpandQueryMenu from Mid-tier (protocol 20) at IP 
address 192.168.107.150  //
   /* Mon Oct 19 2015 
16:37:37.2817 */SELECT  * FROM ( SELECT DISTINCT 'no C1',C536870923 FROM T98 
WHERE (T98.C7 = 0) ORDER BY C536870923 ASC, 1 ASC ) WHERE ROWNUM <= 20001
   /* Mon Oct 19 2015 
16:37:37.3187 */OK
   /* Mon Oct 19 2015 
16:37:37.3202 */-EXPQRY   OK
 /* Mon Oct 19 2015 16:37:37.320 */-API call, Procedure #55

Fred



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

Re: Upgrade advice

2015-10-20 Thread Rafael Rodriguez

Hello Victoria,

There are several factors here that are unknown at the moment. For example,
if your customizations are tied to certain integrations or are they just
stand alone customizations within your environment. Or are some of your
customization tied to any of the OOTB ITSM apps?

Without getting into all the details what is your ARS platform version?
8.1.02? If you created all you custom objects using Dev stuidio "Best
Practice" then all you customizations will be available after upgrade to
9.0. That being said, it is highly recommended that you run the Pre-Checker
utility before each component and address any issues that it
discovers..ESPECIALLY fields ids created in reserve range.

HTH

Rafael

On Tue, Oct 20, 2015 at 8:15 AM, Williamson, Victoria (CIV) <
victoria.william...@usdoj.gov> wrote:

> **
>
> Good Morning Y’all!
>
>
>
> I will be upgrading a unique system where as the majority of the
> modifications are done as ARSystem and not in ITSM.  I have the
> documentation on the how to for the ITSM 8.2 => 9.*.  The question is
> what’s the best plan for the ‘other stuff’.  Because it’s built in ARSystem
> does it need to be upgraded too?  Or can we ‘reuse’ it after the ITSM
> upgrade? Any advice on this endeavor is very welcome.  Thank you.
>
>
>
> Very Respectfully,
>
>
>
> Victoria Williamson
>
> Remedy Development Manager
>
> 202-514-4759
>
>
> _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: User tool and Newer AR server

2015-10-20 Thread LJ LongWing


I've seen that be the server side table chunk size too, what's that set to?

Sent with AquaMail for Android
http://www.aqua-mail.com


On October 20, 2015 10:06:32 AM "Grooms, Frederick W" 
 wrote:


Actually my Max Entries Returned By GetList = 5000

I’m not sure where the 20k comes from as I did a grep on the server and 
couldn’t find any place where I have 20k



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

Sent: Tuesday, October 20, 2015 10:46 AM
To: arslist@ARSLIST.ORG
Subject: Re: User tool and Newer AR server

**
Fred,
Do you have your server properties set to return a maximum of 20K records?

-Original Message-
On Tue, Oct 20, 2015 at 9:00 AM, Grooms, Frederick W  wrote:
We just found another place where a newer AR Server breaks using the User 
Tool.  (Yes I know, we are trying to get users to move off of it)


AR Server   8.1.02 201408260235  (RedHat Linux)
AR User  7.6.04 SP4  Sep , 6 2012

We have a regular form to hold Zip codes.(42,000 + records)
There is a search menu against that form to list the State values (Label 
Field "State", Value Field "State", Sort on Label, Qualification: 'Status' 
= "Active")


When we were using the menu against a 7.6.04 server everything worked 
correctly.  Now that we have upgraded the server to 8.1.02 the User tool 
doesn't show the complete list anymore.


I went and captured SQL logs.
In User tool when opening a menu the selections are not complete.
 /* Mon Oct 19 2015 16:45:15.6810 */+API call

   /* Mon Oct 
19 2015 16:45:15.6803 */+EXPQRY ARExpandQueryMenu from Remedy User 
(protocol 18) at IP address 192.168.101.98  //

   /* Mon Oct 
19 2015 16:45:15.6805 */SELECT  * FROM ( SELECT  T98.C1,C536870923 FROM T98 
WHERE (T98.C7 = 0) ORDER BY C536870923 ASC, 1 ASC ) WHERE ROWNUM <= 20001

   /* Mon Oct 
19 2015 16:45:15.7677 */OK

   /* Mon Oct 
19 2015 16:45:15.9169 */SELECT COUNT(*) FROM T98 WHERE (T98.C7 = 0)

   /* Mon Oct 
19 2015 16:45:15.9393 */OK

   /* Mon Oct 
19 2015 16:45:15.9584 */-EXPQRY   OK

 /* Mon Oct 19 2015 16:45:15.9620 */-API call

In Mid-Tier we get all the records.
/* Mon Oct 19 2015 16:37:37.260 */+HTTP call

  /* Mon Oct 19 2015 16:37:37.2815 */+EXPQRY ARExpandQueryMenu from 
Mid-tier (protocol 20) at IP address 192.168.107.150  //
  /* Mon Oct 19 2015 16:37:37.2817 */SELECT  * FROM ( SELECT DISTINCT 
'no C1',C536870923 FROM T98 WHERE (T98.C7 = 0) ORDER BY C536870923 ASC, 1 
ASC ) WHERE ROWNUM <= 20001

  /* Mon Oct 19 2015 16:37:37.3187 */OK
  /* Mon Oct 19 2015 16:37:37.3202 */-EXPQRY   OK
(ARNOTE 8914)

 /* Mon Oct 19 2015 16:37:37.277 */+MidTier 
ExpandMenu/20/ZIP:Valid_State_List//

 /* Mon Oct 19 2015 16:37:37.281 */+API call, Procedure #55

   /* Mon Oct 
19 2015 16:37:37.2815 */+EXPQRY ARExpandQueryMenu from Mid-tier (protocol 
20) at IP address 192.168.107.150  //

   /* Mon Oct 
19 2015 16:37:37.2817 */SELECT  * FROM ( SELECT DISTINCT 'no C1',C536870923 
FROM T98 WHERE (T98.C7 = 0) ORDER BY C536870923 ASC, 1 ASC ) WHERE ROWNUM 
<= 20001

   /* Mon Oct 
19 2015 16:37:37.3187 */OK

   /* Mon Oct 
19 2015 16:37:37.3202 */-EXPQRY   OK

 /* Mon Oct 19 2015 16:37:37.320 */-API call, Procedure #55

Fred



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

User tool and Newer AR server

2015-10-20 Thread Grooms, Frederick W

We just found another place where a newer AR Server breaks using the User Tool. 
 (Yes I know, we are trying to get users to move off of it)

AR Server   8.1.02 201408260235   
AR User  7.6.04 SP4  Sep , 6 2012   

We have a regular form to hold Zip codes.(42,000 + records)   
There is a search menu against that form to list the State values (Label Field 
"State", Value Field "State", Sort on Label, Qualification: 'Status' = 
"Active")   

When we were using the menu against a 7.6.04 server everything worked 
correctly.  Now that we have upgraded the server to 8.1.02 the User tool 
doesn't show the complete list anymore.   

I went and captured SQL logs.   
In User tool when opening a menu the selections are not complete.   
 /* Mon Oct 19 2015 16:45:15.6810 */+API call   
   /* Mon Oct 19 2015 
16:45:15.6803 */+EXPQRY ARExpandQueryMenu from Remedy User (protocol 18) at IP 
address 192.168.101.98  //
   /* Mon Oct 19 2015 
16:45:15.6805 */SELECT  * FROM ( SELECT  T98.C1,C536870923 FROM T98 WHERE 
(T98.C7 = 0) ORDER BY C536870923 ASC, 1 ASC ) WHERE ROWNUM <= 20001   
   /* Mon Oct 19 2015 
16:45:15.7677 */OK   
   /* Mon Oct 19 2015 
16:45:15.9169 */SELECT COUNT(*) FROM T98 WHERE (T98.C7 = 0)   
   /* Mon Oct 19 2015 
16:45:15.9393 */OK   
   /* Mon Oct 19 2015 
16:45:15.9584 */-EXPQRY   OK   
 /* Mon Oct 19 2015 16:45:15.9620 */-API call   

In Mid-Tier we get all the records.   
 /* Mon Oct 19 2015 16:37:37.260 */+HTTP call   

   /* Mon Oct 19 2015 16:37:37.2815 */+EXPQRY ARExpandQueryMenu from 
Mid-tier (protocol 20) at IP address 192.168.107.150  //
   /* Mon Oct 19 2015 16:37:37.2817 */SELECT  * FROM ( SELECT DISTINCT 'no 
C1',C536870923 FROM T98 WHERE (T98.C7 = 0) ORDER BY C536870923 ASC, 1 ASC ) 
WHERE ROWNUM <= 20001   
   /* Mon Oct 19 2015 16:37:37.3187 */OK   
   /* Mon Oct 19 2015 16:37:37.3202 */-EXPQRY   OK   
 (ARNOTE 8914)

 /* Mon Oct 19 2015 16:37:37.277 */+MidTier 
ExpandMenu/20/ZIP:Valid_State_List//   
 /* Mon Oct 19 2015 16:37:37.281 */+API call, Procedure #55   
   /* Mon Oct 19 2015 
16:37:37.2815 */+EXPQRY ARExpandQueryMenu from Mid-tier (protocol 20) at IP 
address 192.168.107.150  //
   /* Mon Oct 19 2015 
16:37:37.2817 */SELECT  * FROM ( SELECT DISTINCT 'no C1',C536870923 FROM T98 
WHERE (T98.C7 = 0) ORDER BY C536870923 ASC, 1 ASC ) WHERE ROWNUM <= 20001   
   /* Mon Oct 19 2015 
16:37:37.3187 */OK   
   /* Mon Oct 19 2015 
16:37:37.3202 */-EXPQRY   OK   
 /* Mon Oct 19 2015 16:37:37.320 */-API call, Procedure #55   

Fred


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

Re: Upgrade advice

2015-10-20 Thread BradRemedy

Hi Williamson

Probably best to review what that modifications are doing. Do these
modifications integrate with ITSM at all or are they a totally separate
application?

Depending on what the modifications are doing will affect whether you can
simple bring them across untouched or whether you need to review the code
and amend where required.

Hope this makes sense

Cheers
Brad

On Tue, Oct 20, 2015 at 2:15 PM, Williamson, Victoria (CIV) <
victoria.william...@usdoj.gov> wrote:

> **
>
> Good Morning Y’all!
>
>
>
> I will be upgrading a unique system where as the majority of the
> modifications are done as ARSystem and not in ITSM.  I have the
> documentation on the how to for the ITSM 8.2 => 9.*.  The question is
> what’s the best plan for the ‘other stuff’.  Because it’s built in ARSystem
> does it need to be upgraded too?  Or can we ‘reuse’ it after the ITSM
> upgrade? Any advice on this endeavor is very welcome.  Thank you.
>
>
>
> Very Respectfully,
>
>
>
> Victoria Williamson
>
> Remedy Development Manager
>
> 202-514-4759
>
>
> _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: Upgrade advice

Remedy 9.0 SQL requirements

Re: Upgrade advice

Re: Upgrade advice

Re: Email Struggles

Upgrade advice

Re: Email Struggles

Re: User tool and Newer AR server

Re: User tool and Newer AR server

Re: User tool and Newer AR server

Re: User tool and Newer AR server

Re: User tool and Newer AR server

Re: Upgrade advice

Re: User tool and Newer AR server

User tool and Newer AR server

Re: Upgrade advice

16 matches

Site Navigation

Mail list logo

Footer information