Re: Populating Table field with sql query result

[ITSM Support]

*Hi Victor,

*On search in doc, I found related doc for you.
To pull information from external tables, you can use the Set Fields 
action with the "Read Value for Field From"  set to "SQL". This allows 
you to send an SQL |SELECT| command to the database and assign the 
return values to AR System fields. Observe the following general rules 
for using SQL commands:


   * You need not use every value that is returned from the SQL
 command, but you must use at least one.
   * You can use the same value in more than one field.
   * You can issue only one SQL command per action. You cannot enter
 two commands separated by a semicolon and have both commands run.
 To run a set of commands, create separate actions, or create a
 stored procedure and run that. (Stored procedures do not return
 values.)
   * Turn on AR System server SQL logging to debug the SQL syntax if it
 returns unexpected values or results. A good debugging strategy is
 to start an SQL interpreter (for example, isql for Sybase,
 SQL*Plus for Oracle^® , Command Center for DB2, or Query Analyzer
 for SQL Server) and to enter the same SQL command directly into
 the database to verify its validity.
   * Because there is no error checking on the SQL statement, run the
 SQL statement directly against the database (as a test) before you
 enter it into the SQL Command field. You can then copy and paste
 the tested SQL command directly into the SQL Command field.
   * If the SQL operation fails, an AR System error message and the
 underlying database error message appear
   * For more information about Set Fields action with SQL, see the
 /Workflow Objects/ guide. 


Hope this helps...

Regards,

*Sandeep

Vyom Labs Pvt. Ltd.
An ISO 2 certified company.
Consulting | Outsourcing | Training || BMC Remedy BSM | ITIL
Web : www.vyomlabs.com


>*
Victor wrote:

Hello Listers,

It is possible to populate a table field with the result from an sql query?
Any idea how this could be done?

Victor 


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


  


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

No users can log in.

[Gary Opela (Corporate)]

Good morning. I came in this morning and tried to log in, and received an 
Authentication Failed message. I had some other people try, they all got the 
same. They have blank passwords, so it is authenticating them through their 
network login account.

I tried some test accounts I had created that had static passwords in the user 
form, they could not log in either!

I logged into my server and checked my database, and user_x is there, and I can 
query it and pull back all of my users too.

I cycled my database and arserver and was able to log in without issue.

Has anyone experienced this? Is there a way to fix it? I've only had my server 
online for a few weeks and it's already done this. I don't want to have to keep 
dealing with it again.

AR System 7.1 nopatch
MS SQL Server 2k5
MS Windows Server 2k3
MT 7.1
IE 7
Don't use the user client.

Thanks,

Gary Opela, Jr., RSP
Remedy Engineer
Leader Communications, Inc.
http://www.5pointleader.com
http://www.lcibest.com
Best Product, Best People, Best PriceTM
An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company


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

Re: CI Relationship Viewer - Works for Demo and not for other users. (UNCLASSIFIED)

[Joe Bucci]

Same issues - told to patch CMDB to 2.1, Midtier and thick client.
I am about to do this today.
HTH, JoeJoe Buccicell 703-608-4467> Date: Sun, 18 May 2008 11:13:29 -0400> 
From: [EMAIL PROTECTED]> Subject: Re: CI Relationship Viewer - Works for Demo 
and not for other users. (UNCLASSIFIED)> To: arslist@ARSLIST.ORG> > Sounds like 
it could also be a permissions issue where the User doesn't have> access to the 
CI.> > You might want to check that as well (don't know if that is what the bug 
is> about).> > > > ... Daniel> > > > _ > > From: Action Request System 
discussion list(ARSList)> [mailto:[EMAIL PROTECTED] On Behalf Of Mike Gould> 
Sent: May 16, 2008 3:28 PM> To: arslist@ARSLIST.ORG> Subject: Re: CI 
Relationship Viewer - Works for Demo and not for other> users. (UNCLASSIFIED)> 
> > > ** > > Hi Gordon,> > > > We are having the same issue on our ARS 7.0.01 
Patch 003, CMDB 2.0.01 Patch> 003, Solaris9/Oracle10g server. I've had a ticket 
open with BMC Support for> several months now. > > > > Applying Mid-Tier 7.1.00 
Patch 002 recently fixed the problem for us> accessing the CI Viewer via 
Internet Explorer but it still doesn't work with> AR User (any patch version of 
7.0.01 and 7.1.00). If you're only accessing> the CI Viewer from a browser, 
then applying the latest Mid-Tier patch will> fix the problem. > > > > We're 
still trying to work on a fix for the AR User client.> > > > Regards,> > 
Michael Gould> > U.S. House of Representatives> > On Fri, May 16, 2008 at 1:42 
PM, FRANK, GORDON CTR DISA JSSC> <[EMAIL PROTECTED]> wrote:> > Classification: 
UNCLASSIFIED> Caveats: NONE> > When I login as Demo I can open the CI 
Relationship Viewer and all works> fine.?> > If I login as another user, I get 
the error:> > "The CI Relationship Viewer could not open because the specified 
root CI> does not exist."> > Gordon M. Frank> Remedy Skilled Professional - 
7.x> ITIL V3 Foundation Certified> DISA\Verizon FNS> Classification: 
UNCLASSIFIED> Caveats: NONE> > 
> 
___> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org> 
 > Platinum Sponsor: www.rmsportal.com 
 ARSlist:> "Where the Answers Are"> > > __Platinum 
Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"> html___ > > > > > 
___>
 UNSUBSCRIBE or access ARSlist Archives at www.arslist.org> Platinum Sponsor: 
www.rmsportal.com ARSlist: "Where the Answers Are"
_
Keep your kids safer online with Windows Live Family Safety.
http://www.windowslive.com/family_safety/overview.html?ocid=TXT_TAGLM_WL_Refresh_family_safety_052008
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Access to Solution Database

[Viji.PK]

Hi All,
Is there options to access the Solution Database from any other screen,
apart from the Requester Console and Incident Management Console?
How easy is to add an entry point in the Home page for HPD:Incident Matching
screen and make it available for all User?
Please share your thoughts.
Thanks,
Viji

-- 
View this message in context: 
http://www.nabble.com/Access-to-Solution-Database-tp17316730p17316730.html
Sent from the ARS (Action Request System) mailing list archive at Nabble.com.

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

Job: Multiple Openings - Contract / Permanent - Kforce

[Kitchen, Joshua T]

Dear List,
 
I am compiling all of my open Remedy requirements at the present moment.
Any help is always appreciated.  Hope everyone had a great weekend!
 
Table of Contents:
1)  Remedy TTS Developer / US Citizen /  WPAFB - Dayton, OH / 4 Month
Contract / OnSite
2)  Remedy Developer / US Citizen /  Research Triangle Park - North
Carolina / 6 Month Contract / Onsite 
3)  Remedy Administrator / US Citizen or Green Card / Woodland Hills, CA
/ Permanent
 
Description of Opportunities:
1)  

Title:  Remedy TTS Programmer or SC06

Location:  Dayton, OH  

Rates:  40-60/HR All Inclusive (Cannot do Corp-to-Corp, but can
take a 1099 contractor) 

Telecommuting:  Not an Option

Authorization Status:  US Citizens (Will be processed for Secret
Clearance/Interim Secret will be issued within first 2 weeks) 

Duration:  4 Month Contract  

Type:  Straight Contract with possible extension

Requirements:

*   US Citizen 
*   1 to 5 years experience with Remedy Action Request
System (Releases 6 thru 7) and programming using the Remedy Language 
*   Experience with Remedy IT Service Management Suite
(ITSM) Release 7 
*   Database Experience Required (SQL/Oracle) 

2)  


Title:  Remedy  Developer 
Location:   North Carolina 
Duration:   6 Month Contract 
Rates:  85-118/HR C2C All Inclusive (Two Separate Labor
Categories)
Telecommuting:  Not an Option
Work Authorization:  US Citizens Only

Industry:   DoD 
About Client:One of the world's leading providers of systems
integration and other technology services, including application
development, data hosting, networking, and management consulting. It is
also a leading provider of business process outsourcing (BPO) services
in such areas as billing and payment processing, customer relationship
management (CRM), and human resources. A major government and defense
contractor. 
Description:  
**  Design, implementation, configuration, management, and
administration. Experience managing and participating in the design and
implementation of custom and OEM enterprise REMEDY solutions. 

**  Firm understanding of ITIL* framework and procedures 

** 3+ years of experience using BMC REMEDY IT Service Management
Suite tools;  

** Demonstrated the ability to design, implement, and maintain
an enterprise REMEDY IT Service Management Suite solution.  

** Demonstrated the ability to implement REMEDY Service Desk in
a distributed environment. 

 Technologies:  
Service Desk / ITSM / V  6.x, 7.x / ITIL 
 

3)  


Title:  Remedy Administrator
Location:  Woodland Hills, CA 
Duration:  Direct-Hire / Permanent 
Salary:   80K-105K 

Industry:  Insurance
About Client:  2.7 Billion dollar company provides Workers'
Compensation insurance.
Description:  Administration and development in a high
availability environment.  Develop workflows, active links,
customizations, escalations in version 6.x or 7.x. 
* Administer permissions, security, access, logins,
passwords in  Remedy 

* Administer and develop forms, fields, menus and
workflows in  Remedy 

* Build AR System filters and active links in order to
automate responses to user actions and enforce business rules

* Create Remedy training documentation in PowerPoint and
Word for Webinars with employees

* Troubleshoot complex issues regarding forms,
workflows, and log files in  Remedy 

Skills: BMC REMEDY (v7.x preferred, v6.x acceptable) products including
but not limited to Configuration Management DB (CMDB), IT Service
Management (ITSM) Suite including Analytics. Experience with Oracle
RDBMS, SQL.  
 
Respectfully,

Joshua Kitchen
Information Technology Recruiter
Kforce Professional Staffing 
Two Prestige Place (Suite 350)
937.449.1749 Office  
937.461.6888 Fax 
937.416.3456 Cell
Great People = Great Results
   
Please don't keep me a secret... a referral is the best compliment I can
receive. 

 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
<>

Re: No users can log in.

[Dwayne Martin]

Hi Gary,

This is a long shot.  Have you changed anything in the Server Configuration?  
We have "Authenticate Registered Users" and "Cross Reference Blank Passwords" 
checked.  That way people with blank passwords, which is just about everyone, 
must LDAP authenticate.  I once inadvertently unchecked "Cross Reference Blank 
Passwords" and nobody could log in.

Dwayne Martin
James Madison University

 Original message 
>Date: Mon, 19 May 2008 08:46:29 -0500
>From: "Gary Opela (Corporate)" <[EMAIL PROTECTED]>  
>Subject: No users can log in.  
>To: arslist@ARSLIST.ORG
>
>   ** 
>
>   Good morning. I came in this morning and tried to
>   log in, and received an Authentication Failed
>   message. I had some other people try, they all got
>   the same. They have blank passwords, so it is
>   authenticating them through their network login
>   account.
>
>
>
>   I tried some test accounts I had created that had
>   static passwords in the user form, they could not
>   log in either!
>
>
>
>   I logged into my server and checked my database, and
>   user_x is there, and I can query it and pull back
>   all of my users too.
>
>
>
>   I cycled my database and arserver and was able to
>   log in without issue.
>
>   Has anyone experienced this? Is there a way to fix
>   it? I've only had my server online for a few weeks
>   and it's already done this. I don't want to have to
>   keep dealing with it again.
>
>
>
>   AR System 7.1 nopatch
>
>   MS SQL Server 2k5
>
>   MS Windows Server 2k3
>
>   MT 7.1
>
>   IE 7
>
>   Don't use the user client.
>
>
>
>   Thanks,
>
>
>
>   Gary Opela, Jr., RSP
>
>   Remedy Engineer
>
>   Leader Communications, Inc.
>
>   http://www.5pointleader.com
>
>   http://www.lcibest.com
>
>   Best Product, Best People, Best PriceTM
>
>   An ISO 9001:2000 Certified, CMMI(R) Level 3 Rated
>   Company
>
>
>
>   __Platinum Sponsor: www.rmsportal.com ARSlist:
>   "Where the Answers Are" html___

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

Re: No users can log in.

[Gary Opela (Corporate)]

Dwayne, this was my first thought, but nothing changed on any part of our 
environment over the weekend. We didn't change anything on the remedy side, or 
elsewhere.

If it were this suggestion, then whenever I Cycled remedy and sql server, the 
issue would not have cleared up.

It was acting like maybe the cached user entries were messed up. I thought 
about running arreload to see if that cleared it up, but I just went in and 
cycled remedy and sql server and it worked.

Thanks,



Gary Opela, Jr., RSP

Remedy Engineer

Leader Communications, Inc.

http://www.5pointleader.com

http://www.lcibest.com

Best Product, Best People, Best PriceTM

An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company

-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Dwayne Martin
Sent: Monday, May 19, 2008 10:18 AM
To: arslist@ARSLIST.ORG
Subject: Re: No users can log in.

Hi Gary,

This is a long shot.  Have you changed anything in the Server Configuration?  
We have "Authenticate Registered Users" and "Cross Reference Blank Passwords" 
checked.  That way people with blank passwords, which is just about everyone, 
must LDAP authenticate.  I once inadvertently unchecked "Cross Reference Blank 
Passwords" and nobody could log in.

Dwayne Martin
James Madison University

 Original message 
>Date: Mon, 19 May 2008 08:46:29 -0500
>From: "Gary Opela (Corporate)" <[EMAIL PROTECTED]>
>Subject: No users can log in.
>To: arslist@ARSLIST.ORG
>
>   **
>
>   Good morning. I came in this morning and tried to
>   log in, and received an Authentication Failed
>   message. I had some other people try, they all got
>   the same. They have blank passwords, so it is
>   authenticating them through their network login
>   account.
>
>
>
>   I tried some test accounts I had created that had
>   static passwords in the user form, they could not
>   log in either!
>
>
>
>   I logged into my server and checked my database, and
>   user_x is there, and I can query it and pull back
>   all of my users too.
>
>
>
>   I cycled my database and arserver and was able to
>   log in without issue.
>
>   Has anyone experienced this? Is there a way to fix
>   it? I've only had my server online for a few weeks
>   and it's already done this. I don't want to have to
>   keep dealing with it again.
>
>
>
>   AR System 7.1 nopatch
>
>   MS SQL Server 2k5
>
>   MS Windows Server 2k3
>
>   MT 7.1
>
>   IE 7
>
>   Don't use the user client.
>
>
>
>   Thanks,
>
>
>
>   Gary Opela, Jr., RSP
>
>   Remedy Engineer
>
>   Leader Communications, Inc.
>
>   http://www.5pointleader.com
>
>   http://www.lcibest.com
>
>   Best Product, Best People, Best PriceTM
>
>   An ISO 9001:2000 Certified, CMMI(R) Level 3 Rated
>   Company
>
>
>
>   __Platinum Sponsor: www.rmsportal.com ARSlist:
>   "Where the Answers Are" html___

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

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

Re: No users can log in.

[Thad K Esser]

Gary,

The next time that happens, you might also try arsignal with a -g or -u. 
That might help avoid a server restart (doesn't solve the core issue of 
course).  Details of arsignal are in the configuration guide (page 301 of 
the 7.x copy I have).

Thad Esser
Remedy Developer
"Argue for your limitations, and sure enough, they're yours."-- Richard 
Bach



"Gary Opela (Corporate)" <[EMAIL PROTECTED]> 
Sent by: "Action Request System discussion list(ARSList)" 

05/19/2008 09:21 AM
Please respond to
arslist@ARSLIST.ORG


To
arslist@ARSLIST.ORG
cc

Subject
Re: No users can log in.






Dwayne, this was my first thought, but nothing changed on any part of our 
environment over the weekend. We didn't change anything on the remedy 
side, or elsewhere.

If it were this suggestion, then whenever I Cycled remedy and sql server, 
the issue would not have cleared up.

It was acting like maybe the cached user entries were messed up. I thought 
about running arreload to see if that cleared it up, but I just went in 
and cycled remedy and sql server and it worked.

Thanks,



Gary Opela, Jr., RSP

Remedy Engineer

Leader Communications, Inc.

http://www.5pointleader.com

http://www.lcibest.com

Best Product, Best People, Best PriceTM

An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin
Sent: Monday, May 19, 2008 10:18 AM
To: arslist@ARSLIST.ORG
Subject: Re: No users can log in.

Hi Gary,

This is a long shot.  Have you changed anything in the Server 
Configuration?  We have "Authenticate Registered Users" and "Cross 
Reference Blank Passwords" checked.  That way people with blank passwords, 
which is just about everyone, must LDAP authenticate.  I once 
inadvertently unchecked "Cross Reference Blank Passwords" and nobody could 
log in.

Dwayne Martin
James Madison University

 Original message 
>Date: Mon, 19 May 2008 08:46:29 -0500
>From: "Gary Opela (Corporate)" <[EMAIL PROTECTED]>
>Subject: No users can log in.
>To: arslist@ARSLIST.ORG
>
>   **
>
>   Good morning. I came in this morning and tried to
>   log in, and received an Authentication Failed
>   message. I had some other people try, they all got
>   the same. They have blank passwords, so it is
>   authenticating them through their network login
>   account.
>
>
>
>   I tried some test accounts I had created that had
>   static passwords in the user form, they could not
>   log in either!
>
>
>
>   I logged into my server and checked my database, and
>   user_x is there, and I can query it and pull back
>   all of my users too.
>
>
>
>   I cycled my database and arserver and was able to
>   log in without issue.
>
>   Has anyone experienced this? Is there a way to fix
>   it? I've only had my server online for a few weeks
>   and it's already done this. I don't want to have to
>   keep dealing with it again.
>
>
>
>   AR System 7.1 nopatch
>
>   MS SQL Server 2k5
>
>   MS Windows Server 2k3
>
>   MT 7.1
>
>   IE 7
>
>   Don't use the user client.
>
>
>
>   Thanks,
>
>
>
>   Gary Opela, Jr., RSP
>
>   Remedy Engineer
>
>   Leader Communications, Inc.
>
>   http://www.5pointleader.com
>
>   http://www.lcibest.com
>
>   Best Product, Best People, Best PriceTM
>
>   An ISO 9001:2000 Certified, CMMI(R) Level 3 Rated
>   Company
>
>
>
>   __Platinum Sponsor: www.rmsportal.com ARSlist:
>   "Where the Answers Are" html___

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

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


***IMPORTANT NOTICE: This communication, including any attachment, contains 
information that may be confidential or privileged, and is intended solely for 
the entity or individual to whom it is addressed.  If you are not the intended 
recipient, you should delete this message and are hereby notified that any 
disclosure, copying, or distribution of this message is strictly prohibited.  
Nothing in this email, including any attachment, is intended to be a legally 
binding signature.***

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

Re: Access to Solution Database

[Joe DeSouza]

Are you talking of Remedy RKM? Isn't there already an OTB link for RKM on your 
homepage?
Joe



- Original Message 
From: Viji.PK <[EMAIL PROTECTED]>
To: arslist@ARSLIST.ORG
Sent: Monday, May 19, 2008 10:15:35 AM
Subject: Access to Solution Database

Hi All,
Is there options to access the Solution Database from any other screen,
apart from the Requester Console and Incident Management Console?
How easy is to add an entry point in the Home page for HPD:Incident Matching
screen and make it available for all User?
Please share your thoughts.
Thanks,
Viji



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

Re: No users can log in.

[Garrison, Sean (Norcross)]

Did someone add a new group into the system?  Any new group added through ITSM 
causes the server to recache the Groups/Users in the system.  This in turn 
prevents users from logging in while the server is re-caching.  The only other 
thing I can think of is that you had a filter loop in your system that caused 
the server to just hang.  You won't know that unless you had logging turned on 
during the time that it happened.  If you had "Server Statistics" turned on it 
may help you know if it was a workflow/filter loop issue.

Sean




-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Gary Opela (Corporate)
Sent: Monday, May 19, 2008 12:22 PM
To: arslist@ARSLIST.ORG
Subject: Re: No users can log in.

Dwayne, this was my first thought, but nothing changed on any part of our 
environment over the weekend. We didn't change anything on the remedy side, or 
elsewhere.

If it were this suggestion, then whenever I Cycled remedy and sql server, the 
issue would not have cleared up.

It was acting like maybe the cached user entries were messed up. I thought 
about running arreload to see if that cleared it up, but I just went in and 
cycled remedy and sql server and it worked.

Thanks,



Gary Opela, Jr., RSP

Remedy Engineer

Leader Communications, Inc.

http://www.5pointleader.com

http://www.lcibest.com

Best Product, Best People, Best PriceTM

An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company

-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Dwayne Martin
Sent: Monday, May 19, 2008 10:18 AM
To: arslist@ARSLIST.ORG
Subject: Re: No users can log in.

Hi Gary,

This is a long shot.  Have you changed anything in the Server Configuration?  
We have "Authenticate Registered Users" and "Cross Reference Blank Passwords" 
checked.  That way people with blank passwords, which is just about everyone, 
must LDAP authenticate.  I once inadvertently unchecked "Cross Reference Blank 
Passwords" and nobody could log in.

Dwayne Martin
James Madison University

 Original message 
>Date: Mon, 19 May 2008 08:46:29 -0500
>From: "Gary Opela (Corporate)" <[EMAIL PROTECTED]>
>Subject: No users can log in.
>To: arslist@ARSLIST.ORG
>
>   **
>
>   Good morning. I came in this morning and tried to
>   log in, and received an Authentication Failed
>   message. I had some other people try, they all got
>   the same. They have blank passwords, so it is
>   authenticating them through their network login
>   account.
>
>
>
>   I tried some test accounts I had created that had
>   static passwords in the user form, they could not
>   log in either!
>
>
>
>   I logged into my server and checked my database, and
>   user_x is there, and I can query it and pull back
>   all of my users too.
>
>
>
>   I cycled my database and arserver and was able to
>   log in without issue.
>
>   Has anyone experienced this? Is there a way to fix
>   it? I've only had my server online for a few weeks
>   and it's already done this. I don't want to have to
>   keep dealing with it again.
>
>
>
>   AR System 7.1 nopatch
>
>   MS SQL Server 2k5
>
>   MS Windows Server 2k3
>
>   MT 7.1
>
>   IE 7
>
>   Don't use the user client.
>
>
>
>   Thanks,
>
>
>
>   Gary Opela, Jr., RSP
>
>   Remedy Engineer
>
>   Leader Communications, Inc.
>
>   http://www.5pointleader.com
>
>   http://www.lcibest.com
>
>   Best Product, Best People, Best PriceTM
>
>   An ISO 9001:2000 Certified, CMMI(R) Level 3 Rated
>   Company
>
>
>
>   __Platinum Sponsor: www.rmsportal.com ARSlist:
>   "Where the Answers Are" html___

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

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

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

Re: CI Relationship Viewer - Works for Demo and not for other users. (UNCLASSIFIED)

[FRANK, GORDON CTR DISA JSSC]

Classification:  UNCLASSIFIED 
Caveats: NONE

Thanks for all of your help! 

The combination of several feedbacks got me thinking and I actually
solved this problem. I don't know what is being carried my the account
"appadmin" but it is the key to the solution. "appadmin" carries ITSM
"something" that Demo does not. But Demo does bring up the CI Viewer
correctly.

Here are the steps which will work. 

1. Collect all information for the new account.
2. Go to the "Application Administration Console", People, View
3. Select "appadmin" Login ID
4. Perform a "Copy to New" (Ctrl-T or select from toolbar)
5. In the new copy, make all account changes (Login ID, Support Groups
(including Administrator), etc. etc.)
6. Save
7. Login to the new account and the CI Viewer will now work.

Like I said, I don't know what is being carried underneath, but
something is different on "appadmin". This procedure seems to work every
time.

Gordon M. Frank
Remedy Skilled Professional - 7.x
ITIL V3 Foundation Certified
DISA\Verizon FNS

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Joe Bucci
Sent: Monday, May 19, 2008 10:01 AM
To: arslist@ARSLIST.ORG
Subject: Re: CI Relationship Viewer - Works for Demo and not for other
users. (UNCLASSIFIED)

**
Same issues - told to patch CMDB to 2.1, Midtier and thick client.
I am about to do this today.
HTH, Joe

Joe Bucci
cell 703-608-4467

> Date: Sun, 18 May 2008 11:13:29 -0400
> From: [EMAIL PROTECTED]
> Subject: Re: CI Relationship Viewer - Works for Demo and not for other

> users. (UNCLASSIFIED)
> To: arslist@ARSLIST.ORG
> 
> Sounds like it could also be a permissions issue where the User 
> doesn't have access to the CI.
> 
> You might want to check that as well (don't know if that is what the 
> bug is about).
> 
> 
> 
> ... Daniel
> 
> 
> 
> _
> 
> From: Action Request System discussion list(ARSList) 
> [mailto:[EMAIL PROTECTED] On Behalf Of Mike Gould
> Sent: May 16, 2008 3:28 PM
> To: arslist@ARSLIST.ORG
> Subject: Re: CI Relationship Viewer - Works for Demo and not for other

> users. (UNCLASSIFIED)
> 
> 
> 
> **
> 
> Hi Gordon,
> 
> 
> 
> We are having the same issue on our ARS 7.0.01 Patch 003, CMDB 2.0.01 
> Patch 003, Solaris9/Oracle10g server. I've had a ticket open with BMC 
> Support for several months now.
> 
> 
> 
> Applying Mid-Tier 7.1.00 Patch 002 recently fixed the problem for us 
> accessing the CI Viewer via Internet Explorer but it still doesn't 
> work with AR User (any patch version of 7.0.01 and 7.1.00). If you're 
> only accessing the CI Viewer from a browser, then applying the latest 
> Mid-Tier patch will fix the problem.
> 
> 
> 
> We're still trying to work on a fix for the AR User client.
> 
> 
> 
> Regards,
> 
> Michael Gould
> 
> U.S. House of Representatives
> 
> On Fri, May 16, 2008 at 1:42 PM, FRANK, GORDON CTR DISA JSSC 
> <[EMAIL PROTECTED]> wrote:
> 
> Classification: UNCLASSIFIED
> Caveats: NONE
> 
> When I login as Demo I can open the CI Relationship Viewer and all 
> works fine.?
> 
> If I login as another user, I get the error:
> 
> "The CI Relationship Viewer could not open because the specified root 
> CI does not exist."
> 
> Gordon M. Frank
> Remedy Skilled Professional - 7.x
> ITIL V3 Foundation Certified
> DISA\Verizon FNS
> Classification: UNCLASSIFIED
> Caveats: NONE
> 
> __
> __
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org 
>  Platinum Sponsor: www.rmsportal.com 
>  ARSlist:
> "Where the Answers Are"
> 
> 
> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
> html___
> 
> 
> 
> 
> __
> _ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org 
> Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"





Keep your kids safer online with Windows Live Family Safety. Help
protect your kids.

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___ 
Classification:  UNCLASSIFIED 
Caveats: NONE

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

Re: No users can log in.

[Gary Opela (Corporate)]

No new users, and no filter loops.
This is really starting to look weird.

Thanks for all the suggestions!

Thanks,



Gary Opela, Jr., RSP

Remedy Engineer

Leader Communications, Inc.

http://www.5pointleader.com

http://www.lcibest.com

Best Product, Best People, Best PriceTM

An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company


-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Garrison, Sean (Norcross)
Sent: Monday, May 19, 2008 12:09 PM
To: arslist@ARSLIST.ORG
Subject: Re: No users can log in.

Did someone add a new group into the system?  Any new group added through ITSM 
causes the server to recache the Groups/Users in the system.  This in turn 
prevents users from logging in while the server is re-caching.  The only other 
thing I can think of is that you had a filter loop in your system that caused 
the server to just hang.  You won't know that unless you had logging turned on 
during the time that it happened.  If you had "Server Statistics" turned on it 
may help you know if it was a workflow/filter loop issue.

Sean




-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Gary Opela (Corporate)
Sent: Monday, May 19, 2008 12:22 PM
To: arslist@ARSLIST.ORG
Subject: Re: No users can log in.

Dwayne, this was my first thought, but nothing changed on any part of our 
environment over the weekend. We didn't change anything on the remedy side, or 
elsewhere.

If it were this suggestion, then whenever I Cycled remedy and sql server, the 
issue would not have cleared up.

It was acting like maybe the cached user entries were messed up. I thought 
about running arreload to see if that cleared it up, but I just went in and 
cycled remedy and sql server and it worked.

Thanks,



Gary Opela, Jr., RSP

Remedy Engineer

Leader Communications, Inc.

http://www.5pointleader.com

http://www.lcibest.com

Best Product, Best People, Best PriceTM

An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company

-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Dwayne Martin
Sent: Monday, May 19, 2008 10:18 AM
To: arslist@ARSLIST.ORG
Subject: Re: No users can log in.

Hi Gary,

This is a long shot.  Have you changed anything in the Server Configuration?  
We have "Authenticate Registered Users" and "Cross Reference Blank Passwords" 
checked.  That way people with blank passwords, which is just about everyone, 
must LDAP authenticate.  I once inadvertently unchecked "Cross Reference Blank 
Passwords" and nobody could log in.

Dwayne Martin
James Madison University

 Original message 
>Date: Mon, 19 May 2008 08:46:29 -0500
>From: "Gary Opela (Corporate)" <[EMAIL PROTECTED]>
>Subject: No users can log in.
>To: arslist@ARSLIST.ORG
>
>   **
>
>   Good morning. I came in this morning and tried to
>   log in, and received an Authentication Failed
>   message. I had some other people try, they all got
>   the same. They have blank passwords, so it is
>   authenticating them through their network login
>   account.
>
>
>
>   I tried some test accounts I had created that had
>   static passwords in the user form, they could not
>   log in either!
>
>
>
>   I logged into my server and checked my database, and
>   user_x is there, and I can query it and pull back
>   all of my users too.
>
>
>
>   I cycled my database and arserver and was able to
>   log in without issue.
>
>   Has anyone experienced this? Is there a way to fix
>   it? I've only had my server online for a few weeks
>   and it's already done this. I don't want to have to
>   keep dealing with it again.
>
>
>
>   AR System 7.1 nopatch
>
>   MS SQL Server 2k5
>
>   MS Windows Server 2k3
>
>   MT 7.1
>
>   IE 7
>
>   Don't use the user client.
>
>
>
>   Thanks,
>
>
>
>   Gary Opela, Jr., RSP
>
>   Remedy Engineer
>
>   Leader Communications, Inc.
>
>   http://www.5pointleader.com
>
>   http://www.lcibest.com
>
>   Best Product, Best People, Best PriceTM
>
>   An ISO 9001:2000 Certified, CMMI(R) Level 3 Rated
>   Company
>
>
>
>   __Platinum Sponsor: www.rmsportal.com ARSlist:
>   "Where the Answers Are" html___

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

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

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

___
UNSUBSCRIBE or access ARSlist Archives at www.arslis

Re: No users can log in.

[Eli Schilling]

Gary, are any of your servers running on VMWare? 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Gary Opela (Corporate)
Sent: Monday, May 19, 2008 12:03 PM
To: arslist@ARSLIST.ORG
Subject: Re: No users can log in.

No new users, and no filter loops.
This is really starting to look weird.

Thanks for all the suggestions!

Thanks,



Gary Opela, Jr., RSP

Remedy Engineer

Leader Communications, Inc.

http://www.5pointleader.com

http://www.lcibest.com

Best Product, Best People, Best PriceTM

An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Garrison, Sean (Norcross)
Sent: Monday, May 19, 2008 12:09 PM
To: arslist@ARSLIST.ORG
Subject: Re: No users can log in.

Did someone add a new group into the system?  Any new group added
through ITSM causes the server to recache the Groups/Users in the
system.  This in turn prevents users from logging in while the server is
re-caching.  The only other thing I can think of is that you had a
filter loop in your system that caused the server to just hang.  You
won't know that unless you had logging turned on during the time that it
happened.  If you had "Server Statistics" turned on it may help you know
if it was a workflow/filter loop issue.

Sean




-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Gary Opela (Corporate)
Sent: Monday, May 19, 2008 12:22 PM
To: arslist@ARSLIST.ORG
Subject: Re: No users can log in.

Dwayne, this was my first thought, but nothing changed on any part of
our environment over the weekend. We didn't change anything on the
remedy side, or elsewhere.

If it were this suggestion, then whenever I Cycled remedy and sql
server, the issue would not have cleared up.

It was acting like maybe the cached user entries were messed up. I
thought about running arreload to see if that cleared it up, but I just
went in and cycled remedy and sql server and it worked.

Thanks,



Gary Opela, Jr., RSP

Remedy Engineer

Leader Communications, Inc.

http://www.5pointleader.com

http://www.lcibest.com

Best Product, Best People, Best PriceTM

An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin
Sent: Monday, May 19, 2008 10:18 AM
To: arslist@ARSLIST.ORG
Subject: Re: No users can log in.

Hi Gary,

This is a long shot.  Have you changed anything in the Server
Configuration?  We have "Authenticate Registered Users" and "Cross
Reference Blank Passwords" checked.  That way people with blank
passwords, which is just about everyone, must LDAP authenticate.  I once
inadvertently unchecked "Cross Reference Blank Passwords" and nobody
could log in.

Dwayne Martin
James Madison University

 Original message 
>Date: Mon, 19 May 2008 08:46:29 -0500
>From: "Gary Opela (Corporate)" <[EMAIL PROTECTED]>
>Subject: No users can log in.
>To: arslist@ARSLIST.ORG
>
>   **
>
>   Good morning. I came in this morning and tried to
>   log in, and received an Authentication Failed
>   message. I had some other people try, they all got
>   the same. They have blank passwords, so it is
>   authenticating them through their network login
>   account.
>
>
>
>   I tried some test accounts I had created that had
>   static passwords in the user form, they could not
>   log in either!
>
>
>
>   I logged into my server and checked my database, and
>   user_x is there, and I can query it and pull back
>   all of my users too.
>
>
>
>   I cycled my database and arserver and was able to
>   log in without issue.
>
>   Has anyone experienced this? Is there a way to fix
>   it? I've only had my server online for a few weeks
>   and it's already done this. I don't want to have to
>   keep dealing with it again.
>
>
>
>   AR System 7.1 nopatch
>
>   MS SQL Server 2k5
>
>   MS Windows Server 2k3
>
>   MT 7.1
>
>   IE 7
>
>   Don't use the user client.
>
>
>
>   Thanks,
>
>
>
>   Gary Opela, Jr., RSP
>
>   Remedy Engineer
>
>   Leader Communications, Inc.
>
>   http://www.5pointleader.com
>
>   http://www.lcibest.com
>
>   Best Product, Best People, Best PriceTM
>
>   An ISO 9001:2000 Certified, CMMI(R) Level 3 Rated
>   Company
>
>
>
>   __Platinum Sponsor: www.rmsportal.com ARSlist:
>   "Where the Answers Are" html___


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


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

Re: No users can log in.

[Gary Opela (Corporate)]

No, sir.

Thanks,



Gary Opela, Jr., RSP

Remedy Engineer

Leader Communications, Inc.

http://www.5pointleader.com

http://www.lcibest.com

Best Product, Best People, Best PriceTM

An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company


-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Eli Schilling
Sent: Monday, May 19, 2008 2:02 PM
To: arslist@ARSLIST.ORG
Subject: Re: No users can log in.

Gary, are any of your servers running on VMWare?

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Gary Opela (Corporate)
Sent: Monday, May 19, 2008 12:03 PM
To: arslist@ARSLIST.ORG
Subject: Re: No users can log in.

No new users, and no filter loops.
This is really starting to look weird.

Thanks for all the suggestions!

Thanks,



Gary Opela, Jr., RSP

Remedy Engineer

Leader Communications, Inc.

http://www.5pointleader.com

http://www.lcibest.com

Best Product, Best People, Best PriceTM

An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Garrison, Sean (Norcross)
Sent: Monday, May 19, 2008 12:09 PM
To: arslist@ARSLIST.ORG
Subject: Re: No users can log in.

Did someone add a new group into the system?  Any new group added
through ITSM causes the server to recache the Groups/Users in the
system.  This in turn prevents users from logging in while the server is
re-caching.  The only other thing I can think of is that you had a
filter loop in your system that caused the server to just hang.  You
won't know that unless you had logging turned on during the time that it
happened.  If you had "Server Statistics" turned on it may help you know
if it was a workflow/filter loop issue.

Sean




-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Gary Opela (Corporate)
Sent: Monday, May 19, 2008 12:22 PM
To: arslist@ARSLIST.ORG
Subject: Re: No users can log in.

Dwayne, this was my first thought, but nothing changed on any part of
our environment over the weekend. We didn't change anything on the
remedy side, or elsewhere.

If it were this suggestion, then whenever I Cycled remedy and sql
server, the issue would not have cleared up.

It was acting like maybe the cached user entries were messed up. I
thought about running arreload to see if that cleared it up, but I just
went in and cycled remedy and sql server and it worked.

Thanks,



Gary Opela, Jr., RSP

Remedy Engineer

Leader Communications, Inc.

http://www.5pointleader.com

http://www.lcibest.com

Best Product, Best People, Best PriceTM

An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin
Sent: Monday, May 19, 2008 10:18 AM
To: arslist@ARSLIST.ORG
Subject: Re: No users can log in.

Hi Gary,

This is a long shot.  Have you changed anything in the Server
Configuration?  We have "Authenticate Registered Users" and "Cross
Reference Blank Passwords" checked.  That way people with blank
passwords, which is just about everyone, must LDAP authenticate.  I once
inadvertently unchecked "Cross Reference Blank Passwords" and nobody
could log in.

Dwayne Martin
James Madison University

 Original message 
>Date: Mon, 19 May 2008 08:46:29 -0500
>From: "Gary Opela (Corporate)" <[EMAIL PROTECTED]>
>Subject: No users can log in.
>To: arslist@ARSLIST.ORG
>
>   **
>
>   Good morning. I came in this morning and tried to
>   log in, and received an Authentication Failed
>   message. I had some other people try, they all got
>   the same. They have blank passwords, so it is
>   authenticating them through their network login
>   account.
>
>
>
>   I tried some test accounts I had created that had
>   static passwords in the user form, they could not
>   log in either!
>
>
>
>   I logged into my server and checked my database, and
>   user_x is there, and I can query it and pull back
>   all of my users too.
>
>
>
>   I cycled my database and arserver and was able to
>   log in without issue.
>
>   Has anyone experienced this? Is there a way to fix
>   it? I've only had my server online for a few weeks
>   and it's already done this. I don't want to have to
>   keep dealing with it again.
>
>
>
>   AR System 7.1 nopatch
>
>   MS SQL Server 2k5
>
>   MS Windows Server 2k3
>
>   MT 7.1
>
>   IE 7
>
>   Don't use the user client.
>
>
>
>   Thanks,
>
>
>
>   Gary Opela, Jr., RSP
>
>   Remedy Engineer
>
>   Leader Communications, Inc.
>
>   http://www.5pointleader.com
>
>   http://www.lcibest.com
>
>   Best Product, Best People, Best PriceTM
>
>   An ISO 9001:2000 Certified, CMMI(R) Level 3 Rated
>   Company
>
>
>
>   __Platinum Sponsor: www.rmsportal.com ARSlist:
>   "Where the Answers Are" html___

Re: No users can log in.

[William Rentfrow]

Have you tried turning on API and Plugin logging and looking at the
results?  You can do this manually by changing the ar.conf/ar.cfg file
(refer to the AR config manual on what to add). 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Garrison, Sean (Norcross)
Sent: Monday, May 19, 2008 12:09 PM
To: arslist@ARSLIST.ORG
Subject: Re: No users can log in.

Did someone add a new group into the system?  Any new group added
through ITSM causes the server to recache the Groups/Users in the
system.  This in turn prevents users from logging in while the server is
re-caching.  The only other thing I can think of is that you had a
filter loop in your system that caused the server to just hang.  You
won't know that unless you had logging turned on during the time that it
happened.  If you had "Server Statistics" turned on it may help you know
if it was a workflow/filter loop issue.

Sean




-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Gary Opela (Corporate)
Sent: Monday, May 19, 2008 12:22 PM
To: arslist@ARSLIST.ORG
Subject: Re: No users can log in.

Dwayne, this was my first thought, but nothing changed on any part of
our environment over the weekend. We didn't change anything on the
remedy side, or elsewhere.

If it were this suggestion, then whenever I Cycled remedy and sql
server, the issue would not have cleared up.

It was acting like maybe the cached user entries were messed up. I
thought about running arreload to see if that cleared it up, but I just
went in and cycled remedy and sql server and it worked.

Thanks,



Gary Opela, Jr., RSP

Remedy Engineer

Leader Communications, Inc.

http://www.5pointleader.com

http://www.lcibest.com

Best Product, Best People, Best PriceTM

An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin
Sent: Monday, May 19, 2008 10:18 AM
To: arslist@ARSLIST.ORG
Subject: Re: No users can log in.

Hi Gary,

This is a long shot.  Have you changed anything in the Server
Configuration?  We have "Authenticate Registered Users" and "Cross
Reference Blank Passwords" checked.  That way people with blank
passwords, which is just about everyone, must LDAP authenticate.  I once
inadvertently unchecked "Cross Reference Blank Passwords" and nobody
could log in.

Dwayne Martin
James Madison University

 Original message 
>Date: Mon, 19 May 2008 08:46:29 -0500
>From: "Gary Opela (Corporate)" <[EMAIL PROTECTED]>
>Subject: No users can log in.
>To: arslist@ARSLIST.ORG
>
>   **
>
>   Good morning. I came in this morning and tried to
>   log in, and received an Authentication Failed
>   message. I had some other people try, they all got
>   the same. They have blank passwords, so it is
>   authenticating them through their network login
>   account.
>
>
>
>   I tried some test accounts I had created that had
>   static passwords in the user form, they could not
>   log in either!
>
>
>
>   I logged into my server and checked my database, and
>   user_x is there, and I can query it and pull back
>   all of my users too.
>
>
>
>   I cycled my database and arserver and was able to
>   log in without issue.
>
>   Has anyone experienced this? Is there a way to fix
>   it? I've only had my server online for a few weeks
>   and it's already done this. I don't want to have to
>   keep dealing with it again.
>
>
>
>   AR System 7.1 nopatch
>
>   MS SQL Server 2k5
>
>   MS Windows Server 2k3
>
>   MT 7.1
>
>   IE 7
>
>   Don't use the user client.
>
>
>
>   Thanks,
>
>
>
>   Gary Opela, Jr., RSP
>
>   Remedy Engineer
>
>   Leader Communications, Inc.
>
>   http://www.5pointleader.com
>
>   http://www.lcibest.com
>
>   Best Product, Best People, Best PriceTM
>
>   An ISO 9001:2000 Certified, CMMI(R) Level 3 Rated
>   Company
>
>
>
>   __Platinum Sponsor: www.rmsportal.com ARSlist:
>   "Where the Answers Are" html___


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


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


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

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

Re: No users can log in.

[Gary Opela (Corporate)]

I will keep this in mind next time the issue occurs, if it happens again 
(hopefully not).

Thanks,



Gary Opela, Jr., RSP

Remedy Engineer

Leader Communications, Inc.

http://www.5pointleader.com

http://www.lcibest.com

Best Product, Best People, Best PriceTM

An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company


-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of William Rentfrow
Sent: Monday, May 19, 2008 2:02 PM
To: arslist@ARSLIST.ORG
Subject: Re: No users can log in.

Have you tried turning on API and Plugin logging and looking at the
results?  You can do this manually by changing the ar.conf/ar.cfg file
(refer to the AR config manual on what to add).

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Garrison, Sean (Norcross)
Sent: Monday, May 19, 2008 12:09 PM
To: arslist@ARSLIST.ORG
Subject: Re: No users can log in.

Did someone add a new group into the system?  Any new group added
through ITSM causes the server to recache the Groups/Users in the
system.  This in turn prevents users from logging in while the server is
re-caching.  The only other thing I can think of is that you had a
filter loop in your system that caused the server to just hang.  You
won't know that unless you had logging turned on during the time that it
happened.  If you had "Server Statistics" turned on it may help you know
if it was a workflow/filter loop issue.

Sean




-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Gary Opela (Corporate)
Sent: Monday, May 19, 2008 12:22 PM
To: arslist@ARSLIST.ORG
Subject: Re: No users can log in.

Dwayne, this was my first thought, but nothing changed on any part of
our environment over the weekend. We didn't change anything on the
remedy side, or elsewhere.

If it were this suggestion, then whenever I Cycled remedy and sql
server, the issue would not have cleared up.

It was acting like maybe the cached user entries were messed up. I
thought about running arreload to see if that cleared it up, but I just
went in and cycled remedy and sql server and it worked.

Thanks,



Gary Opela, Jr., RSP

Remedy Engineer

Leader Communications, Inc.

http://www.5pointleader.com

http://www.lcibest.com

Best Product, Best People, Best PriceTM

An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin
Sent: Monday, May 19, 2008 10:18 AM
To: arslist@ARSLIST.ORG
Subject: Re: No users can log in.

Hi Gary,

This is a long shot.  Have you changed anything in the Server
Configuration?  We have "Authenticate Registered Users" and "Cross
Reference Blank Passwords" checked.  That way people with blank
passwords, which is just about everyone, must LDAP authenticate.  I once
inadvertently unchecked "Cross Reference Blank Passwords" and nobody
could log in.

Dwayne Martin
James Madison University

 Original message 
>Date: Mon, 19 May 2008 08:46:29 -0500
>From: "Gary Opela (Corporate)" <[EMAIL PROTECTED]>
>Subject: No users can log in.
>To: arslist@ARSLIST.ORG
>
>   **
>
>   Good morning. I came in this morning and tried to
>   log in, and received an Authentication Failed
>   message. I had some other people try, they all got
>   the same. They have blank passwords, so it is
>   authenticating them through their network login
>   account.
>
>
>
>   I tried some test accounts I had created that had
>   static passwords in the user form, they could not
>   log in either!
>
>
>
>   I logged into my server and checked my database, and
>   user_x is there, and I can query it and pull back
>   all of my users too.
>
>
>
>   I cycled my database and arserver and was able to
>   log in without issue.
>
>   Has anyone experienced this? Is there a way to fix
>   it? I've only had my server online for a few weeks
>   and it's already done this. I don't want to have to
>   keep dealing with it again.
>
>
>
>   AR System 7.1 nopatch
>
>   MS SQL Server 2k5
>
>   MS Windows Server 2k3
>
>   MT 7.1
>
>   IE 7
>
>   Don't use the user client.
>
>
>
>   Thanks,
>
>
>
>   Gary Opela, Jr., RSP
>
>   Remedy Engineer
>
>   Leader Communications, Inc.
>
>   http://www.5pointleader.com
>
>   http://www.lcibest.com
>
>   Best Product, Best People, Best PriceTM
>
>   An ISO 9001:2000 Certified, CMMI(R) Level 3 Rated
>   Company
>
>
>
>   __Platinum Sponsor: www.rmsportal.com ARSlist:
>   "Where the Answers Are" html___


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


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum
Sponsor: www.r

Re: No users can log in.

[Eli Schilling]

Then the only logical conclusion is that your application server has
become infested with gremlins!

On a serious note though...I've only ever seen this on ESX server when
the VM running AR Server performs an active failover to another ESX
node.  No errors are generated and none of the services actually stop;
it just won't allow anyone to log on.

Happy Monday! 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Gary Opela (Corporate)
Sent: Monday, May 19, 2008 12:05 PM
To: arslist@ARSLIST.ORG
Subject: Re: No users can log in.

No, sir.

Thanks,



Gary Opela, Jr., RSP

Remedy Engineer

Leader Communications, Inc.

http://www.5pointleader.com

http://www.lcibest.com

Best Product, Best People, Best PriceTM

An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Eli Schilling
Sent: Monday, May 19, 2008 2:02 PM
To: arslist@ARSLIST.ORG
Subject: Re: No users can log in.

Gary, are any of your servers running on VMWare?

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Gary Opela (Corporate)
Sent: Monday, May 19, 2008 12:03 PM
To: arslist@ARSLIST.ORG
Subject: Re: No users can log in.

No new users, and no filter loops.
This is really starting to look weird.

Thanks for all the suggestions!

Thanks,



Gary Opela, Jr., RSP

Remedy Engineer

Leader Communications, Inc.

http://www.5pointleader.com

http://www.lcibest.com

Best Product, Best People, Best PriceTM

An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Garrison, Sean (Norcross)
Sent: Monday, May 19, 2008 12:09 PM
To: arslist@ARSLIST.ORG
Subject: Re: No users can log in.

Did someone add a new group into the system?  Any new group added
through ITSM causes the server to recache the Groups/Users in the
system.  This in turn prevents users from logging in while the server is
re-caching.  The only other thing I can think of is that you had a
filter loop in your system that caused the server to just hang.  You
won't know that unless you had logging turned on during the time that it
happened.  If you had "Server Statistics" turned on it may help you know
if it was a workflow/filter loop issue.

Sean




-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Gary Opela (Corporate)
Sent: Monday, May 19, 2008 12:22 PM
To: arslist@ARSLIST.ORG
Subject: Re: No users can log in.

Dwayne, this was my first thought, but nothing changed on any part of
our environment over the weekend. We didn't change anything on the
remedy side, or elsewhere.

If it were this suggestion, then whenever I Cycled remedy and sql
server, the issue would not have cleared up.

It was acting like maybe the cached user entries were messed up. I
thought about running arreload to see if that cleared it up, but I just
went in and cycled remedy and sql server and it worked.

Thanks,



Gary Opela, Jr., RSP

Remedy Engineer

Leader Communications, Inc.

http://www.5pointleader.com

http://www.lcibest.com

Best Product, Best People, Best PriceTM

An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin
Sent: Monday, May 19, 2008 10:18 AM
To: arslist@ARSLIST.ORG
Subject: Re: No users can log in.

Hi Gary,

This is a long shot.  Have you changed anything in the Server
Configuration?  We have "Authenticate Registered Users" and "Cross
Reference Blank Passwords" checked.  That way people with blank
passwords, which is just about everyone, must LDAP authenticate.  I once
inadvertently unchecked "Cross Reference Blank Passwords" and nobody
could log in.

Dwayne Martin
James Madison University

 Original message 
>Date: Mon, 19 May 2008 08:46:29 -0500
>From: "Gary Opela (Corporate)" <[EMAIL PROTECTED]>
>Subject: No users can log in.
>To: arslist@ARSLIST.ORG
>
>   **
>
>   Good morning. I came in this morning and tried to
>   log in, and received an Authentication Failed
>   message. I had some other people try, they all got
>   the same. They have blank passwords, so it is
>   authenticating them through their network login
>   account.
>
>
>
>   I tried some test accounts I had created that had
>   static passwords in the user form, they could not
>   log in either!
>
>
>
>   I logged into my server and checked my database, and
>   user_x is there, and I can query it and pull back
>   all of my users too.
>
>
>
>   I cycled my database and arserver and was able to
>   log in without issue.
>
>   Has anyone experienced this? Is there a way to fix
>   it? I've only had my server online for a few weeks
>   and it's alread

Re: No users can log in.

[Gidd]

Gary,

Are you attempting to login using the WUT and/or MT ?




Regards...Gidd 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Gary Opela (Corporate)
Sent: Monday, May 19, 2008 12:07 PM
To: arslist@ARSLIST.ORG
Subject: Re: No users can log in.

I will keep this in mind next time the issue occurs, if it happens again
(hopefully not).

Thanks,



Gary Opela, Jr., RSP

Remedy Engineer

Leader Communications, Inc.

http://www.5pointleader.com

http://www.lcibest.com

Best Product, Best People, Best PriceTM

An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of William Rentfrow
Sent: Monday, May 19, 2008 2:02 PM
To: arslist@ARSLIST.ORG
Subject: Re: No users can log in.

Have you tried turning on API and Plugin logging and looking at the results?
You can do this manually by changing the ar.conf/ar.cfg file (refer to the
AR config manual on what to add).

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Garrison, Sean (Norcross)
Sent: Monday, May 19, 2008 12:09 PM
To: arslist@ARSLIST.ORG
Subject: Re: No users can log in.

Did someone add a new group into the system?  Any new group added through
ITSM causes the server to recache the Groups/Users in the system.  This in
turn prevents users from logging in while the server is re-caching.  The
only other thing I can think of is that you had a filter loop in your system
that caused the server to just hang.  You won't know that unless you had
logging turned on during the time that it happened.  If you had "Server
Statistics" turned on it may help you know if it was a workflow/filter loop
issue.

Sean




-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Gary Opela (Corporate)
Sent: Monday, May 19, 2008 12:22 PM
To: arslist@ARSLIST.ORG
Subject: Re: No users can log in.

Dwayne, this was my first thought, but nothing changed on any part of our
environment over the weekend. We didn't change anything on the remedy side,
or elsewhere.

If it were this suggestion, then whenever I Cycled remedy and sql server,
the issue would not have cleared up.

It was acting like maybe the cached user entries were messed up. I thought
about running arreload to see if that cleared it up, but I just went in and
cycled remedy and sql server and it worked.

Thanks,



Gary Opela, Jr., RSP

Remedy Engineer

Leader Communications, Inc.

http://www.5pointleader.com

http://www.lcibest.com

Best Product, Best People, Best PriceTM

An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin
Sent: Monday, May 19, 2008 10:18 AM
To: arslist@ARSLIST.ORG
Subject: Re: No users can log in.

Hi Gary,

This is a long shot.  Have you changed anything in the Server Configuration?
We have "Authenticate Registered Users" and "Cross Reference Blank
Passwords" checked.  That way people with blank passwords, which is just
about everyone, must LDAP authenticate.  I once inadvertently unchecked
"Cross Reference Blank Passwords" and nobody could log in.

Dwayne Martin
James Madison University

 Original message 
>Date: Mon, 19 May 2008 08:46:29 -0500
>From: "Gary Opela (Corporate)" <[EMAIL PROTECTED]>
>Subject: No users can log in.
>To: arslist@ARSLIST.ORG
>
>   **
>
>   Good morning. I came in this morning and tried to
>   log in, and received an Authentication Failed
>   message. I had some other people try, they all got
>   the same. They have blank passwords, so it is
>   authenticating them through their network login
>   account.
>
>
>
>   I tried some test accounts I had created that had
>   static passwords in the user form, they could not
>   log in either!
>
>
>
>   I logged into my server and checked my database, and
>   user_x is there, and I can query it and pull back
>   all of my users too.
>
>
>
>   I cycled my database and arserver and was able to
>   log in without issue.
>
>   Has anyone experienced this? Is there a way to fix
>   it? I've only had my server online for a few weeks
>   and it's already done this. I don't want to have to
>   keep dealing with it again.
>
>
>
>   AR System 7.1 nopatch
>
>   MS SQL Server 2k5
>
>   MS Windows Server 2k3
>
>   MT 7.1
>
>   IE 7
>
>   Don't use the user client.
>
>
>
>   Thanks,
>
>
>
>   Gary Opela, Jr., RSP
>
>   Remedy Engineer
>
>   Leader Communications, Inc.
>
>   http://www.5pointleader.com
>
>   http://www.lcibest.com
>
>   Best Product, Best People, Best PriceTM
>
>   An ISO 9001:2000 Certified, CMMI(R) Level 3 Rated
>   Company
>
>
>
>   __Platinum Sponsor: www.rmsportal.com ARSlist:
>   "Where the Answers Are" html___

Re: No users can log in.

[Gary Opela (Corporate)]

I tried both the WUT and the MT.

Thanks,



Gary Opela, Jr., RSP

Remedy Engineer

Leader Communications, Inc.

http://www.5pointleader.com

http://www.lcibest.com

Best Product, Best People, Best PriceTM

An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company


-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Gidd
Sent: Monday, May 19, 2008 2:14 PM
To: arslist@ARSLIST.ORG
Subject: Re: No users can log in.

Gary,

Are you attempting to login using the WUT and/or MT ?




Regards...Gidd

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Gary Opela (Corporate)
Sent: Monday, May 19, 2008 12:07 PM
To: arslist@ARSLIST.ORG
Subject: Re: No users can log in.

I will keep this in mind next time the issue occurs, if it happens again
(hopefully not).

Thanks,



Gary Opela, Jr., RSP

Remedy Engineer

Leader Communications, Inc.

http://www.5pointleader.com

http://www.lcibest.com

Best Product, Best People, Best PriceTM

An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of William Rentfrow
Sent: Monday, May 19, 2008 2:02 PM
To: arslist@ARSLIST.ORG
Subject: Re: No users can log in.

Have you tried turning on API and Plugin logging and looking at the results?
You can do this manually by changing the ar.conf/ar.cfg file (refer to the
AR config manual on what to add).

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Garrison, Sean (Norcross)
Sent: Monday, May 19, 2008 12:09 PM
To: arslist@ARSLIST.ORG
Subject: Re: No users can log in.

Did someone add a new group into the system?  Any new group added through
ITSM causes the server to recache the Groups/Users in the system.  This in
turn prevents users from logging in while the server is re-caching.  The
only other thing I can think of is that you had a filter loop in your system
that caused the server to just hang.  You won't know that unless you had
logging turned on during the time that it happened.  If you had "Server
Statistics" turned on it may help you know if it was a workflow/filter loop
issue.

Sean




-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Gary Opela (Corporate)
Sent: Monday, May 19, 2008 12:22 PM
To: arslist@ARSLIST.ORG
Subject: Re: No users can log in.

Dwayne, this was my first thought, but nothing changed on any part of our
environment over the weekend. We didn't change anything on the remedy side,
or elsewhere.

If it were this suggestion, then whenever I Cycled remedy and sql server,
the issue would not have cleared up.

It was acting like maybe the cached user entries were messed up. I thought
about running arreload to see if that cleared it up, but I just went in and
cycled remedy and sql server and it worked.

Thanks,



Gary Opela, Jr., RSP

Remedy Engineer

Leader Communications, Inc.

http://www.5pointleader.com

http://www.lcibest.com

Best Product, Best People, Best PriceTM

An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin
Sent: Monday, May 19, 2008 10:18 AM
To: arslist@ARSLIST.ORG
Subject: Re: No users can log in.

Hi Gary,

This is a long shot.  Have you changed anything in the Server Configuration?
We have "Authenticate Registered Users" and "Cross Reference Blank
Passwords" checked.  That way people with blank passwords, which is just
about everyone, must LDAP authenticate.  I once inadvertently unchecked
"Cross Reference Blank Passwords" and nobody could log in.

Dwayne Martin
James Madison University

 Original message 
>Date: Mon, 19 May 2008 08:46:29 -0500
>From: "Gary Opela (Corporate)" <[EMAIL PROTECTED]>
>Subject: No users can log in.
>To: arslist@ARSLIST.ORG
>
>   **
>
>   Good morning. I came in this morning and tried to
>   log in, and received an Authentication Failed
>   message. I had some other people try, they all got
>   the same. They have blank passwords, so it is
>   authenticating them through their network login
>   account.
>
>
>
>   I tried some test accounts I had created that had
>   static passwords in the user form, they could not
>   log in either!
>
>
>
>   I logged into my server and checked my database, and
>   user_x is there, and I can query it and pull back
>   all of my users too.
>
>
>
>   I cycled my database and arserver and was able to
>   log in without issue.
>
>   Has anyone experienced this? Is there a way to fix
>   it? I've only had my server online for a few weeks
>   and it's already done this. I don't want to have to
>   keep dealing with it again.
>
>
>
>   AR System 7.1 nopatch
>
>   MS SQL Server 2k5
>
>   MS Windows Server 2k3
>
> 

Re: No users can log in.

[Gary Opela (Corporate)]

Let me re-iterate, cycling the DB and arserver addressed the issue. I am not 
down right now, but was looking if anyone has already been down this road.

It was acting just like it had lost the caching of all user accounts. I queries 
user_x and could see all users in the table.

Is there a different place/way to verify what remedy really has cached?

Thanks,



Gary Opela, Jr., RSP

Remedy Engineer

Leader Communications, Inc.

http://www.5pointleader.com

http://www.lcibest.com

Best Product, Best People, Best PriceTM

An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company


-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Gidd
Sent: Monday, May 19, 2008 2:14 PM
To: arslist@ARSLIST.ORG
Subject: Re: No users can log in.

Gary,

Are you attempting to login using the WUT and/or MT ?




Regards...Gidd

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Gary Opela (Corporate)
Sent: Monday, May 19, 2008 12:07 PM
To: arslist@ARSLIST.ORG
Subject: Re: No users can log in.

I will keep this in mind next time the issue occurs, if it happens again
(hopefully not).

Thanks,



Gary Opela, Jr., RSP

Remedy Engineer

Leader Communications, Inc.

http://www.5pointleader.com

http://www.lcibest.com

Best Product, Best People, Best PriceTM

An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of William Rentfrow
Sent: Monday, May 19, 2008 2:02 PM
To: arslist@ARSLIST.ORG
Subject: Re: No users can log in.

Have you tried turning on API and Plugin logging and looking at the results?
You can do this manually by changing the ar.conf/ar.cfg file (refer to the
AR config manual on what to add).

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Garrison, Sean (Norcross)
Sent: Monday, May 19, 2008 12:09 PM
To: arslist@ARSLIST.ORG
Subject: Re: No users can log in.

Did someone add a new group into the system?  Any new group added through
ITSM causes the server to recache the Groups/Users in the system.  This in
turn prevents users from logging in while the server is re-caching.  The
only other thing I can think of is that you had a filter loop in your system
that caused the server to just hang.  You won't know that unless you had
logging turned on during the time that it happened.  If you had "Server
Statistics" turned on it may help you know if it was a workflow/filter loop
issue.

Sean




-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Gary Opela (Corporate)
Sent: Monday, May 19, 2008 12:22 PM
To: arslist@ARSLIST.ORG
Subject: Re: No users can log in.

Dwayne, this was my first thought, but nothing changed on any part of our
environment over the weekend. We didn't change anything on the remedy side,
or elsewhere.

If it were this suggestion, then whenever I Cycled remedy and sql server,
the issue would not have cleared up.

It was acting like maybe the cached user entries were messed up. I thought
about running arreload to see if that cleared it up, but I just went in and
cycled remedy and sql server and it worked.

Thanks,



Gary Opela, Jr., RSP

Remedy Engineer

Leader Communications, Inc.

http://www.5pointleader.com

http://www.lcibest.com

Best Product, Best People, Best PriceTM

An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin
Sent: Monday, May 19, 2008 10:18 AM
To: arslist@ARSLIST.ORG
Subject: Re: No users can log in.

Hi Gary,

This is a long shot.  Have you changed anything in the Server Configuration?
We have "Authenticate Registered Users" and "Cross Reference Blank
Passwords" checked.  That way people with blank passwords, which is just
about everyone, must LDAP authenticate.  I once inadvertently unchecked
"Cross Reference Blank Passwords" and nobody could log in.

Dwayne Martin
James Madison University

 Original message 
>Date: Mon, 19 May 2008 08:46:29 -0500
>From: "Gary Opela (Corporate)" <[EMAIL PROTECTED]>
>Subject: No users can log in.
>To: arslist@ARSLIST.ORG
>
>   **
>
>   Good morning. I came in this morning and tried to
>   log in, and received an Authentication Failed
>   message. I had some other people try, they all got
>   the same. They have blank passwords, so it is
>   authenticating them through their network login
>   account.
>
>
>
>   I tried some test accounts I had created that had
>   static passwords in the user form, they could not
>   log in either!
>
>
>
>   I logged into my server and checked my database, and
>   user_x is there, and I can query it and pull back
>   all of my users too.
>
>
>
>   I cycled my database and arserver and was ab

Re: No users can log in.

[strauss]

I look in dbo.user_cache on the SQL Server, but I may be looking in the
wrong place.  We had issues on 7.1. with the group permissions differing
between user_cache and User, but it was probably from filter problems.

Christopher Strauss, Ph.D.
Call Tracking Administration Manager
University of North Texas Computing & IT Center
http://itsm.unt.edu/
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Gary Opela (Corporate)
Sent: Monday, May 19, 2008 2:27 PM
To: arslist@ARSLIST.ORG
Subject: Re: No users can log in.

Let me re-iterate, cycling the DB and arserver addressed the issue. I am
not down right now, but was looking if anyone has already been down this
road.

It was acting just like it had lost the caching of all user accounts. I
queries user_x and could see all users in the table.

Is there a different place/way to verify what remedy really has cached?

Thanks,



Gary Opela, Jr., RSP

Remedy Engineer

Leader Communications, Inc.

http://www.5pointleader.com

http://www.lcibest.com

Best Product, Best People, Best PriceTM

An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company

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

Job: Remedy Developers DC, MD, VA.

[Garth Farley]

Hello List---



We currently have multiple Full-time positions available for Mid to Senior
level Remedy Developers.  You will work with internal/external teams to
analyze complex problems, design and implement elegantly robust ITSM (7.x)
Solutions within "multi-flavor" technical environments (primarily in the DC,
VA, MD area).



We offer a competitive compensation package and excellent training within an
innovative - team focused environment.



It is tough to demonstrate the potential of these opportunities in words
alone – give me a call!



Garth Farley

 *Attiva**Soft*

[EMAIL PROTECTED] / www.attivasoft.com

443-283-0343 Office / 919-699-6038 Mobile





About us:

AttivaSoft is an IT Service Management Consultancy and Systems Integrator
that focuses on value, speed of delivery, and high performance technology
solutions headquartered in Columbia, MD. www.attivasoft.com  We are an Equal
Opportunity Employer.

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

Re: CI Relationship Viewer - Works for Demo and not for other users. (UNCLASSIFIED)

[Mike Gould]

Hi Gordon,

The reason that Demo brings up the CI Viewer in the AR User Tool and
appadmin doesn't is because Demo has Administrator group permissions and
appadmin only has ITSM Asset Management application role permissions
(out-of-the-box).  It looks like you just gave your new test appadmin
account Administrator permissions, which is why it's now working for you.

The problem with the CI Viewer is that it will only run for accounts with
Administrator rights and displays the "The CI Relationship Viewer could not
open because the specified root CI does not exist." error for all non-Admin
users.  I recommend you try your test again but this time don't give the
user Administrator rights and see if you can replicate the error.

I know a few have suggested looking at form permissions but unfortunately
that's not the issue in this instance as non-Admin users can run the CI
Viewer just fine through their browser once Midtier 7.1.00 Patch 002 is
applied but not when they try in the User Tool.  The problem seems to reside
somewhere in some faulty CI Viewer (at least in the 2.0.01 release) code
that the User Tool is having a hard time processing but was fixed on the
Mid-Tier side.

I'm still in the process of troubleshooting the problem, which has been on
going for several months now, with BMC and will let you know when/if a fix
is found.

Have a great afternoon,
Michael Gould
US House of Representatives

Solaris 9
Oracle 10g
AR Server 7.0.01 Patch 005
Mid-Tier 7.1.00 Patch 002
Atrium CMDB 2.0.01 Patch 003
ITSM 7.0.03 Patch 005





On Mon, May 19, 2008 at 1:43 PM, FRANK, GORDON CTR DISA JSSC <
[EMAIL PROTECTED]> wrote:

> Classification:  UNCLASSIFIED
> Caveats: NONE
>
> Thanks for all of your help!
>
> The combination of several feedbacks got me thinking and I actually
> solved this problem. I don't know what is being carried my the account
> "appadmin" but it is the key to the solution. "appadmin" carries ITSM
> "something" that Demo does not. But Demo does bring up the CI Viewer
> correctly.
>
> Here are the steps which will work.
>
> 1. Collect all information for the new account.
> 2. Go to the "Application Administration Console", People, View
> 3. Select "appadmin" Login ID
> 4. Perform a "Copy to New" (Ctrl-T or select from toolbar)
> 5. In the new copy, make all account changes (Login ID, Support Groups
> (including Administrator), etc. etc.)
> 6. Save
> 7. Login to the new account and the CI Viewer will now work.
>
> Like I said, I don't know what is being carried underneath, but
> something is different on "appadmin". This procedure seems to work every
> time.
>
> Gordon M. Frank
> Remedy Skilled Professional - 7.x
> ITIL V3 Foundation Certified
> DISA\Verizon FNS
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
>  [mailto:[EMAIL PROTECTED] On Behalf Of Joe Bucci
> Sent: Monday, May 19, 2008 10:01 AM
> To: arslist@ARSLIST.ORG
> Subject: Re: CI Relationship Viewer - Works for Demo and not for other
> users. (UNCLASSIFIED)
>
> **
> Same issues - told to patch CMDB to 2.1, Midtier and thick client.
> I am about to do this today.
> HTH, Joe
>
> Joe Bucci
> cell 703-608-4467
>
> > Date: Sun, 18 May 2008 11:13:29 -0400
> > From: [EMAIL PROTECTED]
> > Subject: Re: CI Relationship Viewer - Works for Demo and not for other
>
> > users. (UNCLASSIFIED)
> > To: arslist@ARSLIST.ORG
> >
> > Sounds like it could also be a permissions issue where the User
> > doesn't have access to the CI.
> >
> > You might want to check that as well (don't know if that is what the
> > bug is about).
> >
> >
> >
> > ... Daniel
> >
> >
> >
> > _
> >
> > From: Action Request System discussion list(ARSList)
> > [mailto:[EMAIL PROTECTED] On Behalf Of Mike Gould
> > Sent: May 16, 2008 3:28 PM
> > To: arslist@ARSLIST.ORG
> > Subject: Re: CI Relationship Viewer - Works for Demo and not for other
>
> > users. (UNCLASSIFIED)
> >
> >
> >
> > **
> >
> > Hi Gordon,
> >
> >
> >
> > We are having the same issue on our ARS 7.0.01 Patch 003, CMDB 2.0.01
> > Patch 003, Solaris9/Oracle10g server. I've had a ticket open with BMC
> > Support for several months now.
> >
> >
> >
> > Applying Mid-Tier 7.1.00 Patch 002 recently fixed the problem for us
> > accessing the CI Viewer via Internet Explorer but it still doesn't
> > work with AR User (any patch version of 7.0.01 and 7.1.00). If you're
> > only accessing the CI Viewer from a browser, then applying the latest
> > Mid-Tier patch will fix the problem.
> >
> >
> >
> > We're still trying to work on a fix for the AR User client.
> >
> >
> >
> > Regards,
> >
> > Michael Gould
> >
> > U.S. House of Representatives
> >
> > On Fri, May 16, 2008 at 1:42 PM, FRANK, GORDON CTR DISA JSSC
> > <[EMAIL PROTECTED]> wrote:
> >
> > Classification: UNCLASSIFIED
> > Caveats: NONE
> >
> > When I login as Demo I can open the CI Relationship Viewer and all
> > works fine.?
> >
> > If I login as another user, I get the error:
> >
> > "The CI Relationship Viewer could not open because th

AIE import unix timestamp in millisecond format

[googerb]

Has anyone been able to import a timestamp from an external database
using AIE data mappings, where the souce data is an a millisecond unix
timestamp format.

I can execute SQL statements directly in the source database to
maniuplate the data, but AIE will not import the data due to it being
in milliseconds.  Any syntax I've tried to divide the data by 1000 to
convert the data into seconds is rejected by AIE.

In every case, the AIE syntax ignores the "/ 1000" syntax and tries to
import the full timestamp in milliseconds and I recieve this error:
"*** ERROR ***  The conversion of the nvarchar value '1210689723000'
overflowed an int column. Maximum integer value exceeded. (SQL Server
248)"

Source data example:

E.g., "1210689723000" for Tue, 13 May 2008 14:42:03.

AIE data mapping syntax that works with a direct SQL statement but
does not work with AIE:

SQL|SELECT CAST('$LastScanDate$' / 1000 as int)

SQL|SELECT convert(datetime,DATEADD(s, ('$LastScanDate$' / 1000), '1
January 1970')

SQL|SELECT CAST (Dateadd(s, (CAST(LastScanDate / 1000 as int)), '1
January 1970') as datetime)

Can anyone help?  Thanks!

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

ARODBC Error

[Jase Brandon]

Hello All,

I have a user writing corporate reports using Excel/Remedy ARODBC to connect
to prod dbase. (I know, I laughed too) :)
All was fine until last week, when absolutely nothing changed (as far as I
know).

Using Excel and his Remedy ARODBC login, he is now unable to query
HPD:HelpDesk for
Status.History. If he queries on any other field, no problemo.
If he adds Status.History.New, etc.. to the query, it bombs and returns the
message.
"Cannot open catalog, message number = 94, servername"

Has anyone else seen this?
I get the same result when using my ARODBC as well.
I have verified running the exact same query through SQL Query Analyzer and
it works flawlessly.
I can query H1024 with no problem, T1024 also.
Please see his below excel query.

This one works:
 SELECT "HPD:Help-Desk"."Incident-Number"
FROM "HPD:Help-Desk" "HPD:Help-Desk"
WHERE ("HPD:Help-Desk"."Incident-Number" Is Not Null)

This one does not work:
SELECT "HPD:Help-Desk"."Incident-Number", "HPD:Help-Desk"."Status
History-New-TIME"
FROM "HPD:Help-Desk" "HPD:Help-Desk"
WHERE ("HPD:Help-Desk"."Incident-Number" Is Not Null)

**notice the only difference is the addition of Status History New TIME to
the query.

I believe this to be an issue with the ARODBC drivers, I even had him
reinstall the user.exe to make sure his driver wasn't corrupted, etc.
I hope someone else has seen this as I am perplexed.

Has anyone else had issues with 7.1  and Status.History?

Kind Regards,

Jase


ARS 7.1 Patch 002
Win2K5

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

Re: AIE import unix timestamp in millisecond format

[googerb]

As soon as I posted this, I discovered I could successfully use a
syntax like this:

SQL|SELECT CAST (LastScanDate / 1000 as int) FROM 

On May 19, 4:41 pm, googerb <[EMAIL PROTECTED]> wrote:
> Has anyone been able to import a timestamp from an external database
> using AIE data mappings, where the souce data is an a millisecond unix
> timestamp format.
>
> I can execute SQL statements directly in the source database to
> maniuplate the data, but AIE will not import the data due to it being
> in milliseconds.  Any syntax I've tried to divide the data by 1000 to
> convert the data into seconds is rejected by AIE.
>
> In every case, the AIE syntax ignores the "/ 1000" syntax and tries to
> import the full timestamp in milliseconds and I recieve this error:
> "*** ERROR ***  The conversion of the nvarchar value '1210689723000'
> overflowed an int column. Maximum integer value exceeded. (SQL Server
> 248)"
>
> Source data example:
>
> E.g., "1210689723000" for Tue, 13 May 2008 14:42:03.
>
> AIE data mapping syntax that works with a direct SQL statement but
> does not work with AIE:
>
> SQL|SELECT CAST('$LastScanDate$' / 1000 as int)
>
> SQL|SELECT convert(datetime,DATEADD(s, ('$LastScanDate$' / 1000), '1
> January 1970')
>
> SQL|SELECT CAST (Dateadd(s, (CAST(LastScanDate / 1000 as int)), '1
> January 1970') as datetime)
>
> Can anyone help?  Thanks!
>
> ___­
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> Platinum Sponsor:www.rmsportal.comARSlist: "Where the Answers Are"

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

Re: No users can log in.

[Grooms, Frederick W]

I think what you want to know is:

USER_X is the db view for the User form.  There is also a db table
called USER_CACHE that holds the cache info.

Fred

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Gary Opela (Corporate)
Sent: Monday, May 19, 2008 2:27 PM
To: arslist@ARSLIST.ORG
Subject: Re: No users can log in.

Let me re-iterate, cycling the DB and arserver addressed the issue. I am
not down right now, but was looking if anyone has already been down this
road.

It was acting just like it had lost the caching of all user accounts. I
queries user_x and could see all users in the table.

Is there a different place/way to verify what remedy really has cached?

Thanks,

Gary Opela, Jr., RSP
Remedy Engineer
Leader Communications, Inc.
http://www.5pointleader.com
http://www.lcibest.com
Best Product, Best People, Best PriceTM
An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Gidd
Sent: Monday, May 19, 2008 2:14 PM
To: arslist@ARSLIST.ORG
Subject: Re: No users can log in.

Gary,

Are you attempting to login using the WUT and/or MT ?

Regards...Gidd

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Gary Opela (Corporate)
Sent: Monday, May 19, 2008 12:07 PM
To: arslist@ARSLIST.ORG
Subject: Re: No users can log in.

I will keep this in mind next time the issue occurs, if it happens again
(hopefully not).

Thanks,

Gary Opela, Jr., RSP
Remedy Engineer
Leader Communications, Inc.
http://www.5pointleader.com
http://www.lcibest.com
Best Product, Best People, Best PriceTM
An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of William Rentfrow
Sent: Monday, May 19, 2008 2:02 PM
To: arslist@ARSLIST.ORG
Subject: Re: No users can log in.

Have you tried turning on API and Plugin logging and looking at the
results?
You can do this manually by changing the ar.conf/ar.cfg file (refer to
the AR config manual on what to add).

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Garrison, Sean (Norcross)
Sent: Monday, May 19, 2008 12:09 PM
To: arslist@ARSLIST.ORG
Subject: Re: No users can log in.

Did someone add a new group into the system?  Any new group added
through ITSM causes the server to recache the Groups/Users in the
system.  This in turn prevents users from logging in while the server is
re-caching.  The only other thing I can think of is that you had a
filter loop in your system that caused the server to just hang.  You
won't know that unless you had logging turned on during the time that it
happened.  If you had "Server Statistics" turned on it may help you know
if it was a workflow/filter loop issue.

Sean


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Gary Opela (Corporate)
Sent: Monday, May 19, 2008 12:22 PM
To: arslist@ARSLIST.ORG
Subject: Re: No users can log in.

Dwayne, this was my first thought, but nothing changed on any part of
our environment over the weekend. We didn't change anything on the
remedy side, or elsewhere.

If it were this suggestion, then whenever I Cycled remedy and sql
server, the issue would not have cleared up.

It was acting like maybe the cached user entries were messed up. I
thought about running arreload to see if that cleared it up, but I just
went in and cycled remedy and sql server and it worked.

Thanks,

Gary Opela, Jr., RSP
Remedy Engineer
Leader Communications, Inc.
http://www.5pointleader.com
http://www.lcibest.com
Best Product, Best People, Best PriceTM
An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin
Sent: Monday, May 19, 2008 10:18 AM
To: arslist@ARSLIST.ORG
Subject: Re: No users can log in.

Hi Gary,

This is a long shot.  Have you changed anything in the Server
Configuration?
We have "Authenticate Registered Users" and "Cross Reference Blank
Passwords" checked.  That way people with blank passwords, which is just
about everyone, must LDAP authenticate.  I once inadvertently unchecked
"Cross Reference Blank Passwords" and nobody could log in.

Dwayne Martin
James Madison University

 Original message 
>Date: Mon, 19 May 2008 08:46:29 -0500
>From: "Gary Opela (Corporate)" <[EMAIL PROTECTED]>
>Subject: No users can log in.
>To: arslist@ARSLIST.ORG
>
>   Good morning. I came in this morning and tried to
>   log in, and received an Authentication Failed
>   message. I had some other people try, they all got
>   the same. They have blank passwords, so it is
>   authenticating them through their network l

Symantic Endpoint Protection

[Mench, Ryan M (N-ISS)]

My customer wants to integrate Symantic EndPont Protection 11 on an ARS
5.1.2 server/Oracle 9i DB.  During testing we concluded that the AR
system license tool (a flashback for most of you I'm sure) will not
accept a new license even though the license is valid.  Classic error
that reads "Invalid license key. Please provide a valid license key -
[ARERR 8947].  I should note that we were able to add licenses after
removing Symantic EndPont Protection 11. 

 

Has anyone on the list experienced this on any other versions of ARS,
and is there a fix out there? Upgrading ARS is not an option at this
time. Thanks! 

 

Ryan M. Mench
Remedy Developer - AS3, AOC WSI
Lockheed Martin
9970 Federal Drive, MS 22C
Colorado Springs, CO. 80921
(719) 277-4541

[EMAIL PROTECTED] (WSI Email)

[EMAIL PROTECTED]  (ISS Email)

[EMAIL PROTECTED] 

 

 

__20060125___This posting was submitted with HTML in
it___

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

Re: Symantic Endpoint Protection

[Grooms, Frederick W]

Is this on a Windows server?
 
If you run the License tool with the Symantec product installed and
select New server license (you don't have to save) what does it give you
for the HostID?
 
Then run the license tool without the Symantec product and see if you
get the same HostID
 
My guess is that the Symantec tool is inserting itself between the
applications and the network card so that the HostID that Remedy is
seeing is being changed.
 
Fred




From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Mench, Ryan M (N-ISS)
Sent: Monday, May 19, 2008 4:53 PM
To: arslist@ARSLIST.ORG
Subject: Symantic Endpoint Protection


** 

My customer wants to integrate Symantic EndPont Protection 11 on an ARS
5.1.2 server/Oracle 9i DB.  During testing we concluded that the AR
system license tool (a flashback for most of you I'm sure) will not
accept a new license even though the license is valid.  Classic error
that reads "Invalid license key. Please provide a valid license key -
[ARERR 8947].  I should note that we were able to add licenses after
removing Symantic EndPont Protection 11. 

 

Has anyone on the list experienced this on any other versions of ARS,
and is there a fix out there? Upgrading ARS is not an option at this
time. Thanks! 

 

Ryan M. Mench
Remedy Developer - AS3, AOC WSI
Lockheed Martin
9970 Federal Drive, MS 22C
Colorado Springs, CO. 80921
(719) 277-4541

[EMAIL PROTECTED] (WSI Email)

[EMAIL PROTECTED]  (ISS Email)

[EMAIL PROTECTED] 

 

 

 
  

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