It's actually from a advanced interface form (custom) that is causing the issue.
But it seems that our SRM performance has slowed down after we added the Param Value (301386800) column manually. Any idea on how to get it back to normal? On Jun 11, 11:28 pm, Rosemary <[email protected]> wrote: > I just tested passing 300 chars of data through to Work Order and it's > working...SRM 2.2 Patch 2. > > Sorry I can't help with the SQL question though. Perhaps the error is > related to the CAI:EventParamsInterface form, which is an inner join of > CAI:EventParams.... > > > > > > On Fri, Jun 12, 2009 at 12:57 PM, lee <[email protected]> wrote: > > Those fields are all unlimited. > > I know some of them weren't but it seems to get stuck at the > > CAI:EventParams part. > > > But anyone know if creating the column in SQL 2005 is ok or do I have > > to do something else to bring that column back? > > For example, deleting the field and recreating it? > > Importing the form def (I tried before creating the column manually > > and it failed) > > > Does the caieventcmd need to be restarted to work properly? > > > On Jun 11, 10:46 pm, Rosemary <[email protected]> wrote: > > > I found the same issue when submitting Service Requests from Advanced > > > Interface Forms through to Work Order. However, modifying the fields on > > the > > > AIF to the appropriate data length and changing the SRM:Request SR Type > > > Fields to be unlimited worked fine, there was no need to touch the CAI > > > forms. > > > > On Fri, Jun 12, 2009 at 11:54 AM, lee <[email protected]> wrote: > > > > It seems that a few of our service request fields are greater than 254 > > > > characters but the workflow wouldn't use the unlimited value field. > > > > So these service requests were 'stuck'. > > > > Figured that allowing more than 254 would allow it through and it did. > > > > > On Jun 11, 9:16 pm, Howard Richter <[email protected]> wrote: > > > > > I have to ask the question, why would you need to modify that form? > > > > > > On Thu, Jun 11, 2009 at 7:09 PM, lee <[email protected]> wrote: > > > > > > Hi, > > > > > > > We had an issue with the CAI:EventParams form. > > > > > > The Params Value (301386800) input value was changed from 254 to > > 1500 > > > > > > as a workaround for an issue. > > > > > > The save took place and things were working fine for a while. > > > > > > Then we changed it to 255 and it caused an issue. > > > > > > > Our environment: > > > > > > Remedy 7.1 > > > > > > ITSM 7.0.3 patch 8 > > > > > > SQL 2005 > > > > > > DB replicating to another SQL server > > > > > > > The issue was that the column from CAI:EventParams in the table > > > > > > disappeared. > > > > > > After clicking save to the change in Administrator, it came up with > > an > > > > > > error after it tried to save. ARERR 552 C301386800 column view not > > > > > > found. or something like. > > > > > > Our dba checked and found that the column was missing from that > > > > > > table. But he couldn't understand why it would. Changing the > > input > > > > > > value shouldn't cause that. > > > > > > > Anyway we manually created the column with the same name. But a > > > > > > consultant said that might not be the best idea. It was suggested > > that > > > > > > Remedy dynamically creates these tables and we should get it do > > create > > > > > > it again. > > > > > > > We tried importing the def file of the form and remedy threw up an > > > > > > error about missing C301386800. > > > > > > We didn't delete the column on the form and readd though. > > > > > > > What implications is there for manually creating that column in the > > > > > > CAI:Event Params table? > > > > > > Also what would have caused that issue? It worked in our dev > > > > > > environment with no issue. > > > > > > > Thanks > > > _______________________________________________________________________________ > > > > > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > > > > > > Platinum > > > > > > Sponsor:[email protected]<sponsor%[email protected]> > > <sponsor%[email protected] <sponsor%[email protected]> > > > > > <sponsor%[email protected]<sponsor%[email protected]>< > > sponsor%[email protected]<sponsor%[email protected]> > > >>ARSlist: > > > > "Where the Answers Are" > > > > > > -- > > > > > Howard Richter > > > > > Red Hat Certified Technician > > > > > CompTIA Linux+ Certified > > > > > ITIL Foundation Certified > > > > > E-Mail = [email protected] > > > > > LinkedIn Profile =http://www.linkedin.com/in/hbr4270 > > > _______________________________________________________________________________ > > > > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > > > > > Platinum > > > > > Sponsor:[email protected]<sponsor%[email protected]> > > <sponsor%[email protected] > > <sponsor%[email protected]>>ARSlist: > > "Where the Answers Are" > > > _______________________________________________________________________________ > > > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > > > > Platinum > > > > Sponsor:[email protected]<sponsor%[email protected]> > > <sponsor%[email protected] > > <sponsor%[email protected]>>ARSlist: > > "Where the Answers Are" > > > _______________________________________________________________________________ > > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > > > Platinum > > > Sponsor:[email protected]<sponsor%[email protected]>ARSlist: > > > "Where the Answers Are" > > > _______________________________________________________________________________ > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > > Platinum > > Sponsor:[email protected]<sponsor%[email protected]>ARSlist: > > "Where the Answers Are" > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"- > Hide quoted text - > > - Show quoted text - _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
