Creating CSR raises error Unable to insert into CSR

Creating CSR raises error Unable to insert into CSR_MASTER TABLE (4327498)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Creating CSR raises error Unable to insert into CSR_MASTER TABLE
Description

Trying creating a new CSR the following error is raised:
Error: Unable to insert into CSR_MASTER TABLE
Resolution

Solution:
1. Go to Maintenance | General | Service Domains
2. Highlight the proper Service Domain, scroll to the right, and locate the column 'Last CSR #'. Write this number down.
3. Go to Tools | Table Dump Utility and run this query:
select max(csr_id) from csr_master_tbl where sd_cd='<SD_CD>'
4. The largest CSR_ID in the CSR_MASTER_TBL table for this particular service domain should match the 'Last CSR #' at point #2 above. If not, you will get this pop up message. If the number in the back end table is larger, then modify the 'Last CSR #' value to match the largest number retireved by the query above.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Creating CSR raises error Unable to insert into CSR_MASTER TABLE (4327498)