What the error in the CAI Event form is telling you is that data that is being pushed to a certain field is too large for the field (for instance, pushing 101 characters to a 100 character length field). Most probably this is coming from a free text field on the Requester Console, that's why when the same categorization and summary are selected by two different people the error occurs for one and not the other.
Scott Parrish IT Prophets, LLC (770) 653-5203 www.itprophets.com -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mauricio M. Sent: Friday, June 20, 2008 9:15 PM To: [email protected] Subject: Request ID "In Process" .. again, SQL Error Dear All, I´d appreciate your help with this odd issue regarding incident generation from the Requester Console, thanks in advance for your help as always... When I push the New Request button, the Incident ID will not be created and the Incident will not be pushed to Helpdesk form. The ID gets stuck in status "In Process". It happens only to some users, some users don´t have any problem at all, even though both lucky and failing users use the same categorization, summary, etc., and I haven´t been able to find a pattern. A record is actually created in SRM:Request, but If I check the latest entry in CAI:Event, I will get the following information: SRM_OUT_CREATE_APP_REQUEST Form: HPD:IncidentInterface_Create Return Code:Error Error: ARCreateEntry - Failure during DB operation. The statement has been terminated.String or binary data would be truncated. (SQL Server 8152) I have checked the filter log, and I can detect one error, stopping filter processing, somewhere between filter SHR:SHR:UpdateGroupListAdd_100 and the filter that updates the HPD:Worklog, but there is no detail where the error is exactly ocurring. Please, shed some light, Thanks and best regards, -Mauricio ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
