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]>>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]>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" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
