Sometimes we want to recreate an existing error class, for example, taking one from production into a new UAT environment. It is not really possible to do this but we can work out the modified error codes in the user defined error class and then manually recreate the class. Run the SQL, in the RSSD, below and pipe the output into 2 files
First file
==========
select ds_errorid, action=v.name
from rs_erroractions e, rs_classes c, rs_tvalues v
where e.errorclassid=c.classid
and e.action=v.value
and v.type=’ERR’
and c.classname=’rs_sqlserver_error_class’
order by 1
go
Second File
===========
select ds_errorid, action=v.name
from rs_erroractions e, rs_classes c, rs_tvalues v
where e.errorclassid=c.classid
and e.action=v.value
and v.type=’ERR’
and c.classname=’ASEallowdupsErrorClass’
order by 1
go
Now do a ‘diff’ against these files and any different codes will be displayed. To find out what the codes are, in RSSD
rs_helperror 2601, ‘v’
You can then build your error class using the knowledge gained above.