Whenever i try to submit a risk survey or view it, am getting errors and while submitting the survey. pdmweb.exe is getting downloaded. Am unable to find anything in logs. pls help to fix.
Sounds like the record with id = 410431 is already in the 'usp_risk_svy_answer' table. Run a SQL query to check if that record already exists?
Below logs in found in App server
sqlagt:upinde 12836 ERROR sqlclass.c 1010 SQL Execute failed: [Microsoft OLE DB Provider for SQL Server] [ SQL Code=3621 SQL State=01000] The statement has been terminated.; [Microsoft OLE DB Provider for SQL Server] [ SQL Code=2627 SQL State=23000] Violation of PRIMARY KEY constraint 'XPKusp_risk_svy_answer'. Cannot insert duplicate key in object 'dbo.usp_risk_svy_answer'. The duplicate key value is (410431).
06/17 10:04:00.62 SIXX2 sqlagt:upinde 12836 ERROR sqlclass.c 1011 Clause (INSERT INTO usp_risk_svy_answer ( del, last_mod_by, last_mod_dt, own_srvy_question, persid, selected, sequence, txt, weightage, id ) VALUES ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )) Input (<del:int>0|<last_mod_by:uuid>97276277FB57584D92DA9E1812D0094F|<last_mod_dt:time>06/17/2016 10:04:00|<own_srvy_question:int>401484|<persid:string>risk_svy_answer:410431|<selected:int>(NULL)|<sequence:int>1|<txt:string>1View|<weightage:int>50|<id:int>410431)
06/17 10:04:00.62 SIXX2 web:local 9760 ERROR freeaccess.spl 36705 Error checking in survey! NO AHD04116:A duplicate record was encountered. Insert or Update failed. @|domsrvr|rTY4BA|1465699113|1
please help to fix.
Hi rkalidh87 - Did Brian_Mathato 's response help answer your question? If so please mark as Correct Answer. Thanks!
Retrieving data ...