What to do if a SAP BI Runtime error 'SAPSQL_ARRAY_INSERT_DUPREC' occured?

Manesh Ravindran — Mon, 12 Mar 2012 07:02:19 GMT

When i got this error?

This popped up when dataload failed while loading from a DSO to an Infocube.

Various other reasons due to which this error occurs

Data load from datasource to an Infocube/ DSO.

Data load from DSO to IC and lookup of values from an another Infoobject.

While looping through an internal table and simultaneously looking up in another Infoproviders.

Loading data from the PSA into the cube using DTP.

Main reason this error shows is due to the lookups used in the routines. Main area to check in the routines are the select statement codes.

What is this error?

The SQL statement generated from the SAP Open SQL statement violates a restriction imposed by

The underlying database system of the ABAP system.

The maximum size of an SQL statement was exceeded.

The statement contains too many input variables.

The input data requires more space than is available.

What triggered it ?

Below are the various factors which makes this error to be triggered

An SQL exception occurred
An Open SQL exception occurred
An exception occurred when accessing the database
An error occurred when converting a database field to the target field
The range of the statement to be passed to the database is too wide
The maximum length of a STRING or RAWSTRING field was exceeded
The system tried to insert a data record, even though a data record with the same primary key already exists
A primary key was not completely specified
The database cursor is invalid
The database returned a value containing an error
There are no more records in the database
There are no records in the database matching these selection criteria
There are no more resources available for creating another database connection

How to solve this?

From the BI perspective a check had to be made in the routines if any of the codes come under the "What triggered it?" section.

Another way is to implement OSS Notes. Around 65 OSS notes are found for this run-time exception.

The below ones were used in my project

SAP NOTE 1606565 - Deadlock:DBIF_RSQL_SQL_ERROR on table trfcqout or arfcsstate

SAP NOTE 22115 - SAPSQL_ARRAY_INSERT_DUPREC in prg.SAPLBSVU.

SAP NOTE : 873596 xception CX_SY_OPEN_SQL_DB occurs due to too many single values at selection.

Other OSS notes are : 805880 , 721808 , 745324 , 649259

Will this be repeated?

After implemention OSS notes, the runtime error would be solved.

Well rest of this run time error will not come, unless the routines used for look up are working against the topic section 'What triggered it?'.

Android Applications for SAP Consultants

Manesh Ravindran — Fri, 09 Mar 2012 07:09:24 GMT

SAP Note Viewer

SAP Support Note Viewer for Android allows you to have easy access to SAP support notes from your mobile phone.

It provides the following functionality:

View note based on note number
Store a reference to favorite notes
Store SAP Service Username and password so you do not have to login

It requires that you have an SAP Service User (S-user). If you do not have this user, there is no point of downloading the application.

SAP Searcher

"SAP ERP transaction code searcher" can easily find those pesky SAP ERP transaction codes by searching on name or description in this database.

SAP Tables

Common SAP Tables organised by Module. Swipe through the Screens to View the Tables.

SAP Financial Fact Sheet

With the SAP Customer Financial Fact Sheet mobile app for Android, sales representatives or account executives can check the financial status of their customers anywhere and anytime. You can display all relevant financial data for a customer, with the option of drilling down to the level of a single invoice.

Key features of SAP Customer Financial Fact Sheet for Android

•Display a list of all customers assigned to you, of customers classified as critical, and of customers recently accessed
•Display the financial details for a selected customer (total amounts of outstanding or overdue invoices, credit limit, credit limit utilization, and credit risk class)
•Call up an original invoice or last dunning note in PDF format, and send it to the customer using e mail
•Display the average payment arrears of the customer for the last 12 months
•Display a list of payments made by the customer

SAP Store

The SAP Store mobile app for Android allows customers to search, browse, and download mobile solutions. Customers can access SAP Store from their Android devices to quickly and easily find the right mobile solution for their unique business needs. SAP Store allows users to search by keywords and solution providers, as well as view solutions featured by SAP and our partners. The SAP Store mobile app also allows users to filter by categories such as business area, industry, and release date.

SAP Transport Notification and Status

SAP Transport Notification and Status for Android is a new mobile app for supply chain management. It allows truck drivers to see a list of assigned and open freight orders, access details of an order like the freight units and planned stops, and check the route on a map. The app provides users with map and navigation functions via Google Maps and the smartphone’s GPS capability. In addition, truck drivers can confirm an order, input departure and arrival information for each stop, and report delays along the route. The notifications are sent from the app to the backend transportation application, giving suppliers and manufacturers transparency into the movement of goods.

Mobility for SAP

• Mobility for SAP is a joint product from SAP and ISEC7
• Direct access to SAP without any middleware components
• Mobile Access to data within your SAP ERP, CRM oder workflows
• Caching of data for offline access
• Enhance the application and add all data you need just by editing ABAP coding in the SAP backend
• Works with Single-Sign-On and X.509 certificates!
• Native Java Application - easy to use and deploy in your enterprise

SAP Guest Logon

Lets you logon to SAP office locations in a secure way. The application can be configured to remember the credentials.

SAP HANA Oncolyzer

As the first version was developed for iOS, the need to expand from a proprietary platform into the open Android world was a logical next step. Here a small team at Intel worked together with SAP to port the existing app to a completely new ecosystem. Together we managed to recreate the user experience and functionality on a new platform in a very short time, using what makes Android such a great platform: open source. Co-developed by SAP, Berlin Charité Hospital and the Hasso Plattner Institute, the SAP HANA Oncolyzer is a mobile data analysis application that allows cancer researchers to instantly browse through vast amounts of structured and unstructured data such as anonymous patient data and decades of therapy histories. Powered by a SAP HANA in-memory backend system, the SAP HANA Oncolyzer allows researchers and medical personnel to identify within seconds groups of patients that might benefit from new therapies — a process that previously took several workdays.

SAP SCN

SAP forum for SAPiens.

SCN Blogs

Keeps you up-to-date with latest SCN blogs.

myHelp for SAP Professionals

Helps you search help.sap.com and obtain information while you are away from a PC. Very handy application when you want to look up information while you are in a meeting or transit.

manesh.ravindran2