Hi,
If things get out of sync, which I have experienced, is that you manually make
them synchronized.
Either by adding a missing index in the db, or by deleting a surplus index.
When you are done you can, if applicable, delete the index via Dev Studio. Save
the form. Recreate the index in Dev Studio and Save again.
Turn on API/SQL logging if you do not know the exact db object naming. You can
also use the logs to see the exact syntax of adding/deleting indexes.
Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13)
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs
Find these products, and many free tools and utilities, at http://rrr.se
March 10, 2017 8:40 PM, "Grooms, Frederick W" <[email protected]> wrote:
> You must create indexes thru Dev Studio so ARS will know about them.
>
> The only thing I can think of why your developer studio stopped responding
> was that the db had not
> completed building the index
>
> Fred
>
> -----Original Message-----
> From: Action Request System discussion list(ARSList)
> [mailto:[email protected]] On Behalf Of Kaur
> Sent: Friday, March 10, 2017 12:29 PM
> To: [email protected]
> Subject: Problem with creating/modifying form indexes
>
> Hello All,
>
> I created an index on customized form from developer studio. Form stopped
> responding when I saved
> it.
> I had to force close dev studio and restart ARS service.
> Once the service was back up, I opened the form again from developer studio
> and my changes were in
> place but the db went out of sync.
> New index was not in database.
> I then deleted the index from dev studio and saved the form.
> Changes were saved pretty fast.
> I manually created index from db query. Query was successful and I was able
> to see the new table
> index from db but now dev studio isnt showing that index on the form.
> I reopened it several times. Even restarted ARS service.
>
> What could have went wrong?
> Please suggest.
>
> Thanks!
> Kaur
>
> _______________________________________________________________________________
> 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"
