RE: [sqr-users] ORA-00001: unique constraint (SYSADM.PS_VENDOR_SF_TBL) violated

[Bruce Young <b.young@cqu.edu.au>]

The problem as I see it is there is an insert into this table 
SYSADM.PS_VENDOR_SF_TBL which violates the unique index.

I have that index as SETID, VENDOR_ID,BUSINESS_UNIT,REFUND_NBR_CREATION_DT.

If you can display the values for the insert being attempted that sould help in 
your resolution of the problem.

BTW that index is as per HS Higher ED 7.6 ANZ so your unique index may be a 
little diferent.  Your DBA will be able to help you out on that.

Hope this helps,

Bruce

-----Original Message-----
From: Lindquist, Maria [mailto:mlindqui@uwc.edu]
Sent: Friday, 25 October 2002 00:57
To: sqr-users@sqrug.org
Subject: [sqr-users] ORA-00001: unique constraint
(SYSADM.PS_VENDOR_SF_TBL) violated


I keep getting the following error when trying to run a process and I
just can't seem to figure out where the problem is. I have looked at the
place where they say the problem is and I just don't know what the
problem is. Any ideas?


 Error on table insert 
 Program stop on request
 $Sql-Failed in GET-NEXT-SEQ-NUM
sql error: ORA-00001: unique constraint (SYSADM.PS_VENDOR_SF_TBL)
violated
Voucher ID: 00000258
Vendor ID:  0000000041

Error on line 1834:
   (SQR 3301) Program stopped by user request.


*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~
Maria K Lindquist
mlindqui@uwc.edu <mailto:mlindqui@uwc.edu> 
Information Systems Programmer/Analyst
University of Wisconsin Colleges
780 Regent St, PO Box 8680, Madison, WI  53708-8680
Phone: 608.265.2677 / Fax: 608.265.5770
*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*  


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users