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 <haeyoon....@gmail.com> 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 <rjing...@gmail.com> 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 <haeyoon....@gmail.com> 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 <hbr4...@gmail.com> 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 <haeyoon....@gmail.com> 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:rmisoluti...@verizon.net<sponsor%3armisoluti...@verizon.net> > <sponsor%3armisoluti...@verizon.net <sponsor%253armisoluti...@verizon.net> > > > > > <sponsor%3armisoluti...@verizon.net<sponsor%253armisoluti...@verizon.net>< > sponsor%253armisoluti...@verizon.net<sponsor%25253armisoluti...@verizon.net> > >>ARSlist: > > > "Where the Answers Are" > > > > > > -- > > > > Howard Richter > > > > Red Hat Certified Technician > > > > CompTIA Linux+ Certified > > > > ITIL Foundation Certified > > > > E-Mail = hbr4...@gmail.com > > > > LinkedIn Profile =http://www.linkedin.com/in/hbr4270 > > > > > > _______________________________________________________________________________ > > > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > > > > Platinum > > > > Sponsor:rmisoluti...@verizon.net<sponsor%3armisoluti...@verizon.net> > <sponsor%3armisoluti...@verizon.net > <sponsor%253armisoluti...@verizon.net>>ARSlist: > "Where the Answers Are" > > > > > > _______________________________________________________________________________ > > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > > > Platinum > > > Sponsor:rmisoluti...@verizon.net<sponsor%3armisoluti...@verizon.net> > <sponsor%3armisoluti...@verizon.net > <sponsor%253armisoluti...@verizon.net>>ARSlist: > "Where the Answers Are" > > > > > _______________________________________________________________________________ > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > > Platinum > > Sponsor:rmisoluti...@verizon.net<sponsor%3armisoluti...@verizon.net>ARSlist: > > "Where the Answers Are" > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum > Sponsor:rmisoluti...@verizon.net<sponsor%3armisoluti...@verizon.net>ARSlist: > "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"