[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

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

You are trying to perform an INSERT to a table but you have a CONSTRAINST on
the table to only allow certain data. Since the error is "UNIQUE", that
means that you have an INDEX on that field (or group of fields) and you
cannot have duplicates.

Nick Moscaritolo 
Sr. Systems Consultant 
North America - East Region 
Brio Software(tm) 
(508) 309-3099
nickmosc@brio.com
www.brio.com


 

Celebrate the Brains Behind Business Intelligence at Brio 2002: 
The Business Performance Summit.
November 7-9, 2002 in San Diego, California.
www.brio.com/company/brio2002/
 

-----Original Message-----
From: Lindquist, Maria [mailto:mlindqui@uwc.edu] 
Sent: Thursday, October 24, 2002 10:57 AM
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