topic Re: Error SAPSQL_ARRAY_INSERT_DUPREC in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/error-sapsql-array-insert-duprec/m-p/4535495#M1071740 <HTML><HEAD></HEAD><BODY><P>hai,</P><P> waiting for ur reply.</P><P></P><P></P><P>shan.</P><P></P><P>Edited by: shan palani on Sep 24, 2008 10:04 AM</P></BODY></HTML> Wed, 24 Sep 2008 04:33:31 GMT Former Member 2008-09-24T04:33:31Z Error SAPSQL_ARRAY_INSERT_DUPREC https://community.sap.com/t5/application-development-and-automation-discussions/error-sapsql-array-insert-duprec/m-p/4535486#M1071731 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Hi am writing some code in an exit. During execution after the execution of the exit, I am getting dump issue at the line like this:</P><P></P><P>INSERT afru FROM TABLE afru_i.</P><P>and dump showing as SAPSQL_ARRAY_INSERT_DUPREC.</P><P></P><P>How this can be avoided.</P><P></P><P>Regards,</P><P>Jeetu</P></BODY></HTML> Tue, 23 Sep 2008 06:41:07 GMT https://community.sap.com/t5/application-development-and-automation-discussions/error-sapsql-array-insert-duprec/m-p/4535486#M1071731 Former Member 2008-09-23T06:41:07Z Re: Error SAPSQL_ARRAY_INSERT_DUPREC https://community.sap.com/t5/application-development-and-automation-discussions/error-sapsql-array-insert-duprec/m-p/4535487#M1071732 <HTML><HEAD></HEAD><BODY><P>use modify instead of Insert.</P></BODY></HTML> Tue, 23 Sep 2008 06:43:01 GMT https://community.sap.com/t5/application-development-and-automation-discussions/error-sapsql-array-insert-duprec/m-p/4535487#M1071732 Former Member 2008-09-23T06:43:01Z Re: Error SAPSQL_ARRAY_INSERT_DUPREC https://community.sap.com/t5/application-development-and-automation-discussions/error-sapsql-array-insert-duprec/m-p/4535488#M1071733 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>are you appending records to internal table afru_i in the USER EXIT</P><P>Regards</P><P>MD</P></BODY></HTML> Tue, 23 Sep 2008 06:44:06 GMT https://community.sap.com/t5/application-development-and-automation-discussions/error-sapsql-array-insert-duprec/m-p/4535488#M1071733 Former Member 2008-09-23T06:44:06Z Re: Error SAPSQL_ARRAY_INSERT_DUPREC https://community.sap.com/t5/application-development-and-automation-discussions/error-sapsql-array-insert-duprec/m-p/4535489#M1071734 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>This error means that ayou are attempting to commit </P><P>information to the database that would result in a duplicate entry in a table with primary key.</P><P></P><P>Regards,</P><P>Surinder</P></BODY></HTML> Tue, 23 Sep 2008 06:44:27 GMT https://community.sap.com/t5/application-development-and-automation-discussions/error-sapsql-array-insert-duprec/m-p/4535489#M1071734 Former Member 2008-09-23T06:44:27Z Re: Error SAPSQL_ARRAY_INSERT_DUPREC https://community.sap.com/t5/application-development-and-automation-discussions/error-sapsql-array-insert-duprec/m-p/4535490#M1071735 <HTML><HEAD></HEAD><BODY><P>No I am not appending to the table.</P></BODY></HTML> Tue, 23 Sep 2008 06:53:22 GMT https://community.sap.com/t5/application-development-and-automation-discussions/error-sapsql-array-insert-duprec/m-p/4535490#M1071735 Former Member 2008-09-23T06:53:22Z Re: Error SAPSQL_ARRAY_INSERT_DUPREC https://community.sap.com/t5/application-development-and-automation-discussions/error-sapsql-array-insert-duprec/m-p/4535491#M1071736 <HTML><HEAD></HEAD><BODY><P>Insert code by the system not custonized code.</P></BODY></HTML> Tue, 23 Sep 2008 06:53:48 GMT https://community.sap.com/t5/application-development-and-automation-discussions/error-sapsql-array-insert-duprec/m-p/4535491#M1071736 Former Member 2008-09-23T06:53:48Z Re: Error SAPSQL_ARRAY_INSERT_DUPREC https://community.sap.com/t5/application-development-and-automation-discussions/error-sapsql-array-insert-duprec/m-p/4535492#M1071737 <HTML><HEAD></HEAD><BODY><P>Jeetu,</P><P>You are trying to insert a record with duplicate entry. Either modify the existing entry if your key fields are right. Or change the key fields so that insertion is not duplicate while considering the key fields</P><P></P><P>Regards</P><P>Farzan</P></BODY></HTML> Tue, 23 Sep 2008 13:48:17 GMT https://community.sap.com/t5/application-development-and-automation-discussions/error-sapsql-array-insert-duprec/m-p/4535492#M1071737 former_member137336 2008-09-23T13:48:17Z Re: Error SAPSQL_ARRAY_INSERT_DUPREC https://community.sap.com/t5/application-development-and-automation-discussions/error-sapsql-array-insert-duprec/m-p/4535493#M1071738 <HTML><HEAD></HEAD><BODY><P>Inserting records to a standard SAP table is very dangerous. There could well be data integrity and synchronization issues.</P><P></P><P>Rob</P></BODY></HTML> Tue, 23 Sep 2008 13:54:21 GMT https://community.sap.com/t5/application-development-and-automation-discussions/error-sapsql-array-insert-duprec/m-p/4535493#M1071738 Former Member 2008-09-23T13:54:21Z Re: Error SAPSQL_ARRAY_INSERT_DUPREC https://community.sap.com/t5/application-development-and-automation-discussions/error-sapsql-array-insert-duprec/m-p/4535494#M1071739 <HTML><HEAD></HEAD><BODY><P>hai,</P><P> check the internal table, </P><P> ---it should be like that of database table </P><P> ---check weather it is having any duplicate entries, if duplicate entries is there then use addition statement ACCEPTING DUPLICATE KEYS should be provided.</P></BODY></HTML> Wed, 24 Sep 2008 04:00:19 GMT https://community.sap.com/t5/application-development-and-automation-discussions/error-sapsql-array-insert-duprec/m-p/4535494#M1071739 Former Member 2008-09-24T04:00:19Z Re: Error SAPSQL_ARRAY_INSERT_DUPREC https://community.sap.com/t5/application-development-and-automation-discussions/error-sapsql-array-insert-duprec/m-p/4535495#M1071740 <HTML><HEAD></HEAD><BODY><P>hai,</P><P> waiting for ur reply.</P><P></P><P></P><P>shan.</P><P></P><P>Edited by: shan palani on Sep 24, 2008 10:04 AM</P></BODY></HTML> Wed, 24 Sep 2008 04:33:31 GMT https://community.sap.com/t5/application-development-and-automation-discussions/error-sapsql-array-insert-duprec/m-p/4535495#M1071740 Former Member 2008-09-24T04:33:31Z