Re: Issue in SRD Question menu loading

[vikram betholi@friends]

Hi Carl. Thanks for your reply.
 If the issue is with permission or qualification it should not display
even the 6 CO records on the menu. Also as i said if i put some of the
existing 6 records to Inactive state, then it shows another 6 records which
were shown earlier.
This behaviour is shown in the Questions of yhe normal SRD...not on any
display only form.

On Friday, April 28, 2017, Carl Wilson  wrote:

> **
>
> Hi,
>
> It sounds like you have an issue with either the qualification you are
> using to query the underlying form, or a permissions issue on the data in
> the form (if using a Display to an underlying form, check permissions, etc).
>
> Many people forget that the field permission access to the Query form need
> to be "Public" for normal SRM users to see the data.  If you are an Admin
> user testing, you bypass the restrictions.
>
>
>
> Simplify and troubleshoot by accessing the underlying form that holds the
> data directly for the first menu option to eliminate any issues with your
> display field.
>
>
>
> --
>
>
>
> Kind Regards,
>
>
>
> *Carl Wilson*
>
>
>
>
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> arslist@ARSLIST.ORG ]
> *On Behalf Of *vikram betholi@friends
> *Sent:* 27 April 2017 19:46
> *To:* arslist@ARSLIST.ORG
> 
> *Subject:* Re: Issue in SRD Question menu loading
>
>
>
> ** Hi Tauf,
>
>
>
> As i said earlier, it shows only 6 CO records instead of 22 records. If i
> put any of the 6 CO records in Inactive state, it furthur shows the next CO
> records that were not displayed earlier.
>
>
>
>
>
>
> On Friday, April 28, 2017, Tauf Chowdhury  > wrote:
>
> Try throwing a: AND 'status' != $NULL$ in the qual
>
> Sent from my iPhone
>
> > On Apr 27, 2017, at 2:11 PM, Vikram_Betholi 
> wrote:
> >
> > Hi,
> >
> > I have created an normal SRD, where in I have added 3 Questions and made
> them as menus.. like
> >
> > CO--> Menu
> > RO--> Menu
> > Branch-->Menu.
> >
> > End user for submitting the SR, he should select the CO menu, based on
> which RO menu values and Based on the CO and RO menu values, Branch values
> will be populated, which user needs to select.
> >
> > I have created a form where in CO, RO and Branch values are stored. Here
> I have nearly 6000 Records.
> > CO column has 22 records.
> > But in the SR shown to the end user, in the CO Question menu it shows
> only 6 CO records. Qualification given in the Qualification builder is
> "Status = Active" itself. Even then it does not show 22 records. But if we
> select the available CO value in the CO Question menu, it shows all the RO
> records related to the CO value selected.
> >
> > Thinking there may be some issue in the data, i have created a Search
> Menu on the CO, RO and Branch stored form and attached it to a field in a
> dispaly only form. Here it shows all the 22 CO records.
> >
> > Could anyone please let me know how to get rid off this issue?
> >
> > With regards,
> > BVSR.
> >
> > 
> ___
> > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> > "Where the Answers Are, and have been for 20 years"
>
> 
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> "Where the Answers Are, and have been for 20 years"
>
> _ARSlist: "Where the Answers Are" and have been for 20 years_
>
>
> 
>  Virus-free.
> www.avast.com
> 
> <#m_6713886856570290015_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
> _ARSlist: "Where the Answers Are" and have been for 20 years_

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

Re: Issue in SRD Question menu loading

[Carl Wilson]

Hi,

It sounds like you have an issue with either the qualification you are using to 
query the underlying form, or a permissions issue on the data in the form (if 
using a Display to an underlying form, check permissions, etc).

Many people forget that the field permission access to the Query form need to 
be "Public" for normal SRM users to see the data.  If you are an Admin user 
testing, you bypass the restrictions.



Simplify and troubleshoot by accessing the underlying form that holds the data 
directly for the first menu option to eliminate any issues with your display 
field.



--



Kind Regards,



Carl Wilson





From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of vikram betholi@friends
Sent: 27 April 2017 19:46
To: arslist@ARSLIST.ORG
Subject: Re: Issue in SRD Question menu loading



** Hi Tauf,



As i said earlier, it shows only 6 CO records instead of 22 records. If i put 
any of the 6 CO records in Inactive state, it furthur shows the next CO records 
that were not displayed earlier.






On Friday, April 28, 2017, Tauf Chowdhury  > wrote:

Try throwing a: AND 'status' != $NULL$ in the qual

Sent from my iPhone

> On Apr 27, 2017, at 2:11 PM, Vikram_Betholi   > wrote:
>
> Hi,
>
> I have created an normal SRD, where in I have added 3 Questions and made them 
> as menus.. like
>
> CO--> Menu
> RO--> Menu
> Branch-->Menu.
>
> End user for submitting the SR, he should select the CO menu, based on which 
> RO menu values and Based on the CO and RO menu values, Branch values will be 
> populated, which user needs to select.
>
> I have created a form where in CO, RO and Branch values are stored. Here I 
> have nearly 6000 Records.
> CO column has 22 records.
> But in the SR shown to the end user, in the CO Question menu it shows only 6 
> CO records. Qualification given in the Qualification builder is  "Status = 
> Active" itself. Even then it does not show 22 records. But if we select the 
> available CO value in the CO Question menu, it shows all the RO records 
> related to the CO value selected.
>
> Thinking there may be some issue in the data, i have created a Search Menu on 
> the CO, RO and Branch stored form and attached it to a field in a dispaly 
> only form. Here it shows all the 22 CO records.
>
> Could anyone please let me know how to get rid off this issue?
>
> With regards,
> BVSR.
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org 
> 
> "Where the Answers Are, and have been for 20 years"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org 

"Where the Answers Are, and have been for 20 years"

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



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

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

Re: Issue in SRD Question menu loading

[vikram betholi@friends]

Hi Tauf,

As i said earlier, it shows only 6 CO records instead of 22 records. If i
put any of the 6 CO records in Inactive state, it furthur shows the next CO
records that were not displayed earlier.



On Friday, April 28, 2017, Tauf Chowdhury  wrote:

> Try throwing a: AND 'status' != $NULL$ in the qual
>
> Sent from my iPhone
>
> > On Apr 27, 2017, at 2:11 PM, Vikram_Betholi  > wrote:
> >
> > Hi,
> >
> > I have created an normal SRD, where in I have added 3 Questions and made
> them as menus.. like
> >
> > CO--> Menu
> > RO--> Menu
> > Branch-->Menu.
> >
> > End user for submitting the SR, he should select the CO menu, based on
> which RO menu values and Based on the CO and RO menu values, Branch values
> will be populated, which user needs to select.
> >
> > I have created a form where in CO, RO and Branch values are stored. Here
> I have nearly 6000 Records.
> > CO column has 22 records.
> > But in the SR shown to the end user, in the CO Question menu it shows
> only 6 CO records. Qualification given in the Qualification builder is
> "Status = Active" itself. Even then it does not show 22 records. But if we
> select the available CO value in the CO Question menu, it shows all the RO
> records related to the CO value selected.
> >
> > Thinking there may be some issue in the data, i have created a Search
> Menu on the CO, RO and Branch stored form and attached it to a field in a
> dispaly only form. Here it shows all the 22 CO records.
> >
> > Could anyone please let me know how to get rid off this issue?
> >
> > With regards,
> > BVSR.
> >
> > 
> ___
> > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> > "Where the Answers Are, and have been for 20 years"
>
> 
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> "Where the Answers Are, and have been for 20 years"
>

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

Re: Issue in SRD Question menu loading

[Tauf Chowdhury]

Try throwing a: AND 'status' != $NULL$ in the qual

Sent from my iPhone

> On Apr 27, 2017, at 2:11 PM, Vikram_Betholi  wrote:
> 
> Hi,
> 
> I have created an normal SRD, where in I have added 3 Questions and made them 
> as menus.. like 
> 
> CO--> Menu
> RO--> Menu
> Branch-->Menu.
> 
> End user for submitting the SR, he should select the CO menu, based on which 
> RO menu values and Based on the CO and RO menu values, Branch values will be 
> populated, which user needs to select.
> 
> I have created a form where in CO, RO and Branch values are stored. Here I 
> have nearly 6000 Records.
> CO column has 22 records.
> But in the SR shown to the end user, in the CO Question menu it shows only 6 
> CO records. Qualification given in the Qualification builder is  "Status = 
> Active" itself. Even then it does not show 22 records. But if we select the 
> available CO value in the CO Question menu, it shows all the RO records 
> related to the CO value selected.
> 
> Thinking there may be some issue in the data, i have created a Search Menu on 
> the CO, RO and Branch stored form and attached it to a field in a dispaly 
> only form. Here it shows all the 22 CO records.
> 
> Could anyone please let me know how to get rid off this issue?
> 
> With regards,
> BVSR.
> 
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> "Where the Answers Are, and have been for 20 years"

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

Issue in SRD Question menu loading

[Vikram_Betholi]

Hi,

I have created an normal SRD, where in I have added 3 Questions and made them 
as menus.. like 

CO--> Menu
RO--> Menu
Branch-->Menu.

End user for submitting the SR, he should select the CO menu, based on which RO 
menu values and Based on the CO and RO menu values, Branch values will be 
populated, which user needs to select.

I have created a form where in CO, RO and Branch values are stored. Here I have 
nearly 6000 Records.
CO column has 22 records.
But in the SR shown to the end user, in the CO Question menu it shows only 6 CO 
records. Qualification given in the Qualification builder is  "Status = Active" 
itself. Even then it does not show 22 records. But if we select the available 
CO value in the CO Question menu, it shows all the RO records related to the CO 
value selected.

Thinking there may be some issue in the data, i have created a Search Menu on 
the CO, RO and Branch stored form and attached it to a field in a dispaly only 
form. Here it shows all the 22 CO records.

Could anyone please let me know how to get rid off this issue?

With regards,
BVSR.

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

Re: archgid utility doesn't reflect new ids in workflow

[Mueller, Doug]

Nilesh,

Some things in your message concern me

You mention that response became very slow.  This seems to indicate to me that 
you had the server up and live and processing responses while you were running 
archgid.  Is this the case?

Remember, archgid is like performing open heart surgery.  Your patient -- the 
server -- cannot be up and active and performing work while you are performing 
surgery.   You have to have an outage.   It is making direct SQL changes to the 
DB. It forces server recaching several times.  It produces internal 
inconsistencies in the middle of its processing and corrects them later in the 
process.

Archgid does fix the ids in workflow and it has done that reliably over the 
years.  I am not sure what may be happening in your environment where you see 
the IDs not changing.  The only thing I can assume is that there are errors 
occurring while trying to change the data due to the system being up and that 
is causing archgid not to finish its work completely.

Doug

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Nilesh Uddhavrao Janjire
Sent: Wednesday, April 26, 2017 5:25 AM
To: arslist@ARSLIST.ORG
Subject: archgid utility doesn't reflect new ids in workflow

Hello Team,
 
Greetings! Hope you guys are doing great!
 
I was just changing few custom field ids to bmc recommended ids using 
utility/command  "archgid" and found below issues:
1. AR Server become very slow to respond though i was changing id for single 
field.
2. New field is wasn't reflected into Filter(any other workflows) PFA snapshot 
This is not first time i faced these issues, I was doing same on 2 different 
environments and faced same both times.
 
I have used below command, please let me know if I am missing something.
archgid -c 2 -s form name -f field name -i newfieldID -u userID -p password -x 
servername -t port
 
Could someone let me know why its not changing new ids into workflows. Then 
what is use of this command/utility.
 
Regards,
Nilesh Janjire

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

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