Saturday, November 19, 2011

Note 1637633 - 730SP6:Cursor lost/Invalid cursor during MD update using DTP

Summary

Symptom


You encounter a error 'Cursor lost' or 'Invalid cursor' during master data update through DTP. This can cause inconsistencies in the master data tables because of abrupt termination of a certain datapackage of a DTP request. These inconsitencies can be only detected if RSRV tests for master data is carried out after such a termination has occured in the master data update for a particular Infoobject.

Other terms


Master data mass update
Temporary table
Mass SID update
Master data inconsistency,
RSRV

Reason and Prerequisites
Technical Background


BW 730 provides a feature of mass update of SIDS which is done through temporary tables. Due to some reason if the temporary tables are not present in the system the system tries to create these temporary tables. If the creation of a temporary table fails then the whole datapackage is terminated with a error message 'Cursor Lost' or 'Invalid Cursor' seen in DTP monitor. This causes inconsistencies in master data tables which can be detected by RSRV tests for master data if carried out after the termination.
With the application of the note the logic is changed such that this temporary table is never newly created in the system if already not available. Therefore if this temproary table is not found in the system the mass update of the SIDS is disabled for that datapackage and the old logic of SID update is adopted without any termination.

Programm error

Solution
  • SAP NetWeaver BW 7.30

    Import Support Package 06 for SAP NetWeaver BW 7.30 (SAPKW73006) into your BW system. The Support Package will be available as soon as note 1628054 with the short text "SAPBWNews NW7.30 BW ABAP SP06", which describes this Support Package in more detail, is released for customers.


In urgent cases you can use the correction instructions.

Beforehand, definitely check SAP Note 875986 for transaction SNOTE.

This note might already be available before the Support Package is released. In this case, however, the short text still contains the terms"preliminary version".

Header Data



Release Status:Released for Customer
Released on:01.11.2011 15:46:31
Master Language:English
Priority:HotNews
Category:Program error
Primary Component:BW-WHM-DBA-MD Master Data
Secondary Components:BW-BEX-OT OLAP Technology

BW-BEX-OT-DBIF Interface to Database

BW-WHM-DST-DTP Data Transfer Process

No comments:

Post a Comment