Have an idea?

Visit Sawtooth Software Feedback to share your ideas on how we can improve our products.

Database error Lighthouse studio

Hello,

We have a live survey running and suddenly we're getting loads of the below error.  And we have lost many data ...

Can anyone help us please?

Error #274 - Database error. Cannot insert history row.
8 Jun 2016 - 12:10:56 EST
Server Error: DBD::ODBC::st execute failed: [Microsoft][ODBC SQL Server Driver][SQL Server]Violation de la contrainte PRIMARY KEY 髠PK__US_histo__D24437DA65B08608 ». Impossible d'insrer une cl en double dans l'objet 驫ꃛo.US_history ». Valeur de cl duplique驠: (8, 2142). (SQL-23000) [state was 23000 now 01000] [Microsoft][ODBC SQL Server Driver][SQL Server]L'instruction a t arr驪te. (SQL-01000) at C:/www/aplusainteractif.com/EI/E9266/USA/cgi-bin/authlib9_0_1.pl line 17, <GEN2> line 20.
SSIWebVersion= 9_0_1 params= P17b_date=>09/07/2012, hid_backup=>US,8,68056095,32,1, hid_checksum=>68056095, hid_destination=>P17b, hid_javascript=>1, hid_list_P17b1=>1, hid_loops=>LoopPatient,1, hid_page_vars=>hid_loops, hid_pagenum=>32, hid_pagetime=>1465405719, hid_prev_P17b.1=>2077,P17b.1,32,a922a07697b7a4516825a9fb2f24c627, hid_prev_P17b1.1=>2078,P17b1.1,32,0f23ae4379d44dbd68997d3302250e60, hid_previous=>0, hid_q_P17b=>P17b, hid_q_P17b1=>P17b1, hid_respnum=>8, hid_s=>Af8AAErleXP0FHF4bxgWxdIqRgMhAAAAeslPS8QhR0hWLTr24BlxL3vRT0bAJERPXiE6_f4bala1GoaMC-uOh5Dn6Tot1blQ, hid_studyname=>US, sys_next_button=>Next, IP= 170.223.207.74 , client= Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.102 Safari/537.36


Error #274 - Database error. Cannot insert history row.
8 Jun 2016 - 12:10:56 EST
Server Error: DBD::ODBC::st execute failed: [Microsoft][ODBC SQL Server Driver][SQL Server]Violation de la contrainte PRIMARY KEY 髠PK__US_histo__D24437DA65B08608 ». Impossible d'insrer une cl en double dans l'objet 驫ꃛo.US_history ». Valeur de cl duplique驠: (8, 2142). (SQL-23000) [state was 23000 now 01000] [Microsoft][ODBC SQL Server Driver][SQL Server]L'instruction a t arr驪te. (SQL-01000) at C:/www/aplusainteractif.com/EI/E9266/USA/cgi-bin/authlib9_0_1.pl line 17, <GEN2> line 12.
SSIWebVersion= 9_0_1 params= P17b_date=>09/07/2012, hid_backup=>US,8,68056095,32,1, hid_checksum=>68056095, hid_destination=>P17b, hid_javascript=>1, hid_list_P17b1=>1, hid_loops=>LoopPatient,1, hid_page_vars=>hid_loops, hid_pagenum=>32, hid_pagetime=>1465405719, hid_previous=>1, hid_q_P17b=>P17b, hid_q_P17b1=>P17b1, hid_respnum=>8, hid_s=>Af8AAErleXP0FHF4bxgWxdIqRgMhAAAAeslPS8QhR0hWLTr24BlxL3vRT0bAJERPXiE6_f4bala1GoaMC-uOh5Dn6Tot1blQ, hid_studyname=>US, sys_previous_button=>Back, IP= 170.223.207.74 , client= Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.102 Safari/537.36
asked Jun 9, 2016 by Virginie

1 Answer

0 votes
Please email me at justin@sawtoothsoftware.com and I'll look into this.
answered Jun 9, 2016 by Justin Luster Silver Sawtooth Software, Inc. (7,375 points)
...