Deborah Odom 4.Apr.08 08:50 AM a Web browser LEI LEI - 6.5 Windows
On a regular, daily, basis now I am getting this error:
04/03/2008 03:48:48 PM Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert duplicate key row in object 'dbo.PS_RI_JOB_REVIEWER' with unique index 'PS_RI_JOB_REVIEWER'., Connector 'PS_RI_JOB_REVIEWER', Method -Insert- (2601)
04/03/2008 03:48:48 PM Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated., Connector 'PS_RI_JOB_REVIEWER', Method -Insert- (3621)
04/03/2008 03:48:48 PM Current record key values at the time of the replication error --
In my databases I have purged the views, and also turned on the "Output SQL statements to log" option in the LEI connection.
I am not a SQL person, and have to ask pointed, specific questions to my SQL admin, or it gets thrown back at me that it is a LEI issue.
Can anyone point me in the right direction with this error?
Also, in the last 4-5 weeks, LEI is taking a lot longer to complete. Activities that had been taking 19 -20 minutes are now taking over an hour.