Sitemap

Amicuk Programming Answers

Open Hub with Attributes and Texts

-0001-11-30   Views:1

Advertisement

Hi, I´d like to know if it´s possible to have one open hub (database table) with texts and attributes. There´s no problem when I create it or it´s transformations and DTP´s, but when I try to load texts, after attributes load, it always generates a d

Hi,
I´d like to know if it´s possible to have one open hub (database table) with texts and attributes.
There´s no problem when I create it or it´s transformations and DTP´s, but when I try to load texts, after attributes load, it always generates a dump: SAPSQL_ARRAY_INSERT_DUPREC.
I´d like to know a way without using a DSO, any suggestions?!
Kind Regards,
Tomas

The replay answer
Advertisement
Hi,
Pls chk SAP notes system, check SAP note 668466 for some help for this error.
*As according to SAP NOTE ;668466*
Summary
Symptom
You load master data attributes or texts for a characteristic. The loading terminates with runtime errors of the type SAPSQL_ARRAY_INSERT_DUPREC or with error message RSDMD 199. The termination point is in the DBFIRE method of the CL_RSDMD_UPDATE_MASTER_DATA class.
Other terms
Loading master data, attributes, texts, SAPSQL_ARRAY_INSERT_DUPREC, CL_RSDMD_UPDATE_MASTER_DATA, DBFIRE
Reason and Prerequisites
When you load attributes or texts, data records are usually inserted in the master data tables of the characteristic using an array insert statement (P, Q, X, Y, T tables). This results in a SAPSQL_ARRAY_INSERT_DUPREC runtime error if data records that are to be inserted and that relate to the unique primary key of the relevant database table already exist in this table. The following possible reasons are currently known for the occurrence of the SAPSQL_ARRAY_INSERT_DUPREC runtime error:
1. Data inconsistencies in the master data tables of the characteristic
SAPSQL_ARRAY_INSERT_DUPREC runtime errors or RSDMD 199 may occur if the data appears in an inconsistent status in the master data tables of the characteristic before you load attributes or texts. Notes 323140, 566044, 592757 and 599269 describe this (among other things) in more detail.
2. Parallel loading of nondisjunct data packages
If master data attributes are loaded over several dialog processes that are running in parallel, you must guarantee that the data packages of the relevant request are strictly disjunct concerning the characteristic value. This means that all data records that belong to a certain characteristic value may only be contained in a single data package. If data records of a certain characteristic value are distributed over several data packages, this may cause conflicts during the parallel loading of these packages when the master data tables are accessed and this may result in SAPSQL_ARRAY_INSERT_DUPREC runtime errors.
The same conditions that apply to loading attributes also apply to loading language-independent master data texts. If language-dependent texts are loaded in parallel, the data packages must be disjunct in relation to the combination of characteristic value and language indicator.
Note 566044 also describes the problematic nature of nondisjunct data packages or duplicate or overlapping data records.
3. Parallel loading of time-dependent attributes or texts
When you load time-dependent attributes or texts, a data record that is to be loaded is assigned to a characteristic value and also specifically to a time interval within which the contained attribute values or texts are valid. For this reason, requests for loading time-dependent attributes or texts typically contain several data records for each characteristic value. If data records of a certain characteristic value or the combination of characteristic value and language indicator are distributed over several data packages, this may (as already explained) cause conflicts when the master data tables are accessed and may result in SAPSQL_ARRAY_INSERT_DUPREC runtime errors or error message RSDMD 199.
4. Delta update of an ODS object in a characteristic
If you use a delta update from an ODS object to load master data attributes or texts, the activation of the ODS object determines the contents of the data packages that are used for loading the attributes or texts. If all of the ODS loading requests that are used as the data basis for the update into the characteristic are activated together in one step, this guarantees that the system sets up the data packages strictly disjunct in relation to the key fields of the ODS object. If the key fields of the ODS object are displayed one for one on the compounded characteristic value in the update rules, the data may be updated to the characteristic in parallel and by package.
However, if ODS loading requests that were activated at different times appear in the data basis for the update, data records of a certain ODS key or characteristic value may be distributed over several data packages. As already explained, this may cause conflicts when you access master data tables of the characteristic, and it may result in SAPSQL_ARRAY_INSERT_DUPREC runtime errors or error message RSDMD 199.
This problem is also described in Note 666213.
5. Simultaneous loading of attributes and transaction data
If, when loading attributes of a characteristic, you discover that there are still no entries in the master data tables (P, Q) for a specific characteristic value, the system prepares to insert corresponding data records into these database tables. You can load transaction data into an InfoCube or an ODS object, for example, with the option to create missing master data entries for characteristics that involved during the loading. If a request now creates entries for transaction data in the master data tables (P, Q) of the characteristic before the process has inserted corresponding data records into the master data tables (P, Q) for loading attributes for this characteristic, this may result in a SAPSQL_ARRAY_INSERT_DUPREC runtime error or error message RSDMD 199.
This problem may also occur if you load attributes simultaneously for a characteristic that contains the other characteristic as a navigation attribute or compounding part. If a characteristic is compounded to other characteristics or if it contains characteristics other than the navigation attributes, the system also creates SID values for these dependent characteristics when the attributes are loaded depending on the settings in the InfoPackage.
Solution
To repair a possible inconsistency in the data, implement the RSRV test for master data.
To avoid SAPSQL_ARRAY_INSERT_DUPREC runtime errors or error message RSDMD 199 when you load master data, carry out the following actions. The actions to be performed in each case depend on which of the above-mentioned reasons is responsible for the runtime error:
1. Data inconsistencies in the master data tables of the characteristic
If data inconsistencies are responsible for the runtime error, you can usually use the tests in transaction RSRV or the RSDMD_CHECKPRG_ALL program to solve this problem. Notes 323140, 566044, 592757 and 599269 describe these (among other things) in more detail. If you cannot implement an automatic correction in this way, you may have to use an ABAP program that is adjusted to the relevant situation to restore the data consistency.
2. Parallel loading of nondisjunct data packages
If the runtime error does not lead back to the parallel loading of nondisjunct data packages, you must identify the duplicate data records that cause the problem. As described in Note 566044, you can change the insertion into master data tables from one array insert to an individual insert statement. If you use a single record insert statement to insert data records, duplicate data records are logged in the monitor by error messages (RSDMD 196). If the data records of a failed request are still available in the PSA, you can also search for duplicate data records directly in the relevant PSA table.
You may also create duplicate data records if key values are changed in the transmission rules or update rules. If relevant rules are defined, you should check these to see if they can possibly create duplicate data records. If this is the case, you must correct the rules accordingly.
3. Parallel loading of time-dependent attributes or texts
The extractors used for loading time-dependent attributes or texts cannot guarantee that all data records assigned to a certain key value are contained together in only one data package. For this reason, to avoid SAPSQL_ARRAY_INSERT_DUPREC runtime errors or error message RSDMD 199, you should not load time-dependent attributes and texts in parallel. Data packages are processed serially if the 'PSA only' and 'Update Subsequently in Data Targets' settings under 'Processing' are used in the InfoPackage.
4. Delta update of an ODS object in a characteristic
To avoid SAPSQL_ARRAY_INSERT_DUPREC runtime errors or error message RSDMD 199 during the delta update from an ODS object to a characteristic, you must ensure that the data basis used for the update to the characteristic consists exclusively of ODS loading requests that were activated together in one step only. Note 666213 describes in detail how you can ensure this.
5. Simultaneous loading of attributes and transaction data
If the runtime error occurs because another load task creates SID values or master data for the same characteristic at the same time when attributes are loaded, you can only solve the problem by rescheduling. The load task in question must be scheduled in such a way that you can exclude simultaneous processing.
*pls assign points,if info is useful*
Regards
CSM reddy

Go to See the other 4 answers

Open Hub with Attributes and Texts

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I´d like to know if it´s possible to have one open hub (database table) with texts and attributes. There´s no problem when I create it or it´s transformations and DTP´s, but when I try to load texts, after attributes load, it always generates a d[More]

Error while loading Masterdat attributes and text in sap BI 7.0

Category:DefaultRelease time:2015-10-11Views:130

Hi Guys Any one help me....Plz I am new to sap BI, in this my first task and it  is loading master data attributes and text into datatargets,I did it in SAP BW 3.5, It is ok But i got error in BI 7.0 The error is  while loading master data attributes[More]

How are attribute and text master data tables linked in SAP R/3?

Category:DefaultRelease time:2015-10-11Views:130

Hello, how are attribute and text master data tables linked in SAP R/3? Most tables with attribute master data like T001 for company codes, have a text master data table T001T (add "T" to table name). When looking at the content of table T001 vi[More]

How to change general attribute of text element

Category:DefaultRelease time:-0001-11-30Views:130

hi who now how to change general attribute of text element on screen dinamically? I wish to change text value dinamically for example.Hi Denis, I am not too sure on what you want. If you require that the text value be different based on some conditio[More]

Master data loads for Attributes and texts failing

Category:DefaultRelease time:-0001-11-30Views:130

Hello Master data loads for Attributs and texts are failing. The error is 1. Lock Not set for Loading master data attributes 2.Table /BI0/YAccount does not exists (this error is for 0Account master data - attribute load) 3.Error  1 in the update. We[More]

Using one datasource for attributes and text?

Category:DefaultRelease time:-0001-11-30Views:130

I am currently loading master data from a flat file using a data source. The flat file contains master data attributes as well as master data text. Is there a disadvantage of using just one datasource (for attributes) to load attributes AND text or i[More]

How to save action attributes as text?

Category:DefaultRelease time:-0001-11-30Views:130

I'd like to save certain action attributes as text to archive along with adjustment files for archived image group adjustments. Anyone know how to copy this to clipboard as text? Thanks!I suppose I could do that, but I have a whole bunch of commonly[More]

Transformation d'attributs de texte sans style sur indesign

Category:DefaultRelease time:-0001-11-30Views:130

Bonjour, Alors voilà mon souci. Je réalise la mise en page d'actes de colloque, c'est donc un document de 600 pages avec une quarantaine de textes séparés à intégrer dans mon document. Ces textes ont été "chartés" pour avoir tous les mêmes attri[More]

Getting Keynote's "Defining Default Attributes of Text Boxes" to work

Category:DefaultRelease time:-0001-11-30Views:130

The following is from the iWorks09 Keynote "Help" for the topic "Defining Default Attributes of Text Boxes and Shapes": 4. Do one of the following: To make the text box the default for only the current master slide, choose Format >[More]

InfoProvider: infoObject (master data attribute and text)

Category:DefaultRelease time:-0001-11-30Views:130

I saw info Object of master data attribute and text in InfoProvider. are infoObject act like a table when we do query on them.Hi Refer to this as down Custome Infoobjects Tabels: /BIC/M -- View of Master data Tables /BIC/P -- Master data Table, Time[More]

How are attributes and texts for a master data linked and targeted to ...?

Category:DefaultRelease time:-0001-11-30Views:130

Our previous consultants used to load data to master data 0MATL_GROUP.  1. RSA1 -> InfoProvider -> Select 0MATL_GROUP or 0MATL_GROUP___T Check these above two and find the records loaded are both 1,216 for Language EN. We check the data flow of this[More]

Hot
I am thinking of writing an applet that would be useful to others, which I would provide for free. In return I would want a link from the pages that use the applet. It is important that the link is search engine friendly, a pure href html link that w [More]
I left my computer sitting while I was working on homework long enough for the screen saver to come on (I'm not sure exactly how long it was). Earlier in the day, I had to force quit safari and then later it unexpectedly quit several times. While my [More]
I can't turn my wifi on with the new iOS software. I've tried resetting the network settings, resetting all settings, and a hard reset.Read here: http://support.apple.com/kb/ts1559 If nothing works, make an appointment at any Apple store.Read other 4 [More]
Dear Guru, How to use Quick Viewer in HR ABAP, kindly give some sample materials for this . else provide some soluytion for this . Regards, Mathankumar.AI don't think there is any difference when comes to HR ABAP. so you can proceed the way you do in [More]
Hi I have to calculate No.Of Days Open for a Case. We have Created Date and Closed Date Characteristics. Calculation: Closed Date - Created Date (If Closed Date is not #) else Current Date - Created Date. I have created two Formula variables on Creat [More]
Hi, I am trying to install FIM Reporting Service in our environment. I have followed the technet guide for doing so. But my installation is encountering problems and it  fails and rolls back. After some troubleshooting , i found that the installation [More]
I'm intrested to know if theres an app out there for the iPad for salesman. Stuff like cataloging the customer by number, address, name ect', taging a quats for that customer, punching in an order i just made, and most importantly sync that informati [More]
all, here's my problem: if I try to open a swf file (published in Infoview) the dashboard cannot be loaded and the loading pop - up message stands for ages ... same error using the preview button on the xlf file. What the problem can be related to? X [More]
I just purchased Illustrator CS5, and can't get any of the .ai files to open. I've downloaded all of the necessary viewers.Can you postr a file to a remote server so we can download it and see? It sounds like the files are locked or you moved them fr [More]
Greetings. Does anyone know if there is a way to have the audio portion of a timeline display actual waveforms? In my timeline preferences, I check the Show Audio waveforms, but still no luck. Is this even possible? Thanks. JonathanWhere you have pro [More]