Listers, I'm not entirely sure if this is an ARS issue or a SQL issue but we're having problems with one of our stored procedures. Back before any of us had any idea what we were doing in Remedy, one of our guys created a stored procedure to handle archiving. Basically just a select > insert > then drop. He also created an unarchive stored procedure in case anyone wanted to get an incident out of the archive form. One of my analysts tried to unarchive a ticket today and encountered the following error: "ARERR [552] Failure during SQL operation to the database : Insert Error: Column name or number of supplied values does not match table definition. (SQL Server 213)"
I opened enterprise manager and generated a SQL script for the archive_incident and incident forms to make sure they matched up (my normal course of action when one of these operations fails) and everything appeared to match up, but at the bottom of the scripts, this is what I saw. On the incident script: [C536870918] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL On the Archive_Incident script: [C536870918Z] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL I'm at a total loss where that Z came from. This stored procedure has worked on several occasions with the only issue being a need for reordering of the columns if someone made a change to one form but not the other. I've never seen the name of a column change however. When I log into the administrator tool, and click on the field in question, the Database ID matches on both forms. I tried googling for help, but apparently my googlefu is weak. Anyone encountered something like this before or have an idea of how to fix it? Thanks much, Michael A. McManus, SSgt, USAF _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"