Solved

ADD_PARTITION_FAILED

Posted on 2004-07-31
3
1,304 Views
Last Modified: 2013-12-08
HI EVERY ONE,
    I WANT SOME HELP FROM U.IT IS VERY IMPORTANT FOR ME.WHILE LOADING DATA FROM FLAT FILE USING SOME RECORDS IN BW.IN INFO PACKAGE, BEFORE GOING TO START THE SCHEDULING , IAM GETTING THE DATA IN PREVIEW MODE.BUT WHEN I START THE SCHEDULING, IT IS DISPLAYING ERROR  EXCEPTION RAISED 'ADD_PARTITION_FAILED'.HERE BELOW , IAM ATTACHING THE SHORT DUMP.PLS IF U HAVE ANY SUGGESTIONS, PLS PASS TO ME TO VENKAT_88877@YAHOO.COM

VENKAT.






Runtime errors         RAISE_EXCEPTION                                                
       Occurred on     03.07.2004 at 20:24:43                                          
                                                                                       
                                                                                       
Exception condition "ADD_PARTITION_FAILED" raised.                                    
                                                                                       
                                                                                       
What happened?                                                                        
                                                                                       
                                                                                       
The current ABAP/4 program encountered an unexpected                                  
situation.                                                                            
                                                                                       
                                                                                       
What can you do?                                                                      
                                                                                       
                                                                                       
Print out the error message (using the "Print" function)                              
and make a note of the actions and input that caused the                              
error.                                                                                
                                                                                       
To resolve the problem, contact your SAP system administrator.                        
You can use transaction ST22 (ABAP Dump Analysis) to view and administer              
 termination messages, especially those beyond their normal deletion                  
date.                                                                                  
                                                                                       
is especially useful if you want to keep a particular message.                        
                                                                                       
                                                                                       
Error analysis                                                                        
                                                                                       
                                                                                       
A RAISE statement in the program "SAPLRSDU_PART " raised the exception                
condition "ADD_PARTITION_FAILED".                                                      
Since the exception was not intercepted by a superior program                          
in the hierarchy, processing was terminated.                                          
                                                                                       
Short description of exception condition:                                              
                                                                                       
                                                                                       
For detailed documentation of the exception condition, use                            
Transaction SE37 (Function Library). You can take the called                          
function module from the display of active calls.                                      
-                                                                                      
                                                                                       
                                                                                       
How to correct the error                                                              
                                                                                       
                                                                                       
                                                                                       
You may able to find an interim solution to the problem                                
in the SAP note system. If you have access to the note system yourself,                
use the following search criteria:                                                    
                                                                                       
                                                                                       
0
Comment
Question by:ragvind
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 2

Accepted Solution

by:
okionka earned 125 total points
ID: 11763440
Hi VENKAT,
take a look at OSS-Note 539757 :

Symptom
The process of loading transaction data fails because a new partition cannot be added to the F fact table.The loading process terminates with a short dump.

Other terms
RSDU_TABLE_ADD_PARTITION_ORA, RSDU_TABLE_ADD_PARTITION_FAILED, TABART_INCONSITENCY, TSORA, TAORA , CATALOG

Reason and Prerequisites
The possible causes are:

SQL errors when creating the partition
Inconsistencies in the Data Dictionary control tables TAORA and TSORA

Solution
BW 3.0A & BW 3.0B
            In the case of SQL errors:Analyze the SQL code in the system log or short dump and if
            possible, eliminate the cause. The cause is often a disk space problem or lock situations
            on the database catalog or, less frequently: the partitioning option in the ORACLE database
            is not installed.

            The most common cause of the problem is inconsistencies in the TAORA and TSORA tables.
            As of Support Package 14 for BW 3.0B/Support Package 8 for BW 3.1C, the
            TABART_INCONSITENCY exception is issued in this case. The reason is almost always missing
            entries in TSORA for the tablespaces of the DDIM, DFACT and DODS data classes.

            The TAORA table contains the assignment of data classes to data tablespaces and their
            attributes, for example:

           Tablespace   Data class

           --------  ----------

           DDIM         PSAPDIMD ........

           DFACT         PSAPFACTD ........

           DODS         PSAPODSD .......

           For each data tablespace, the TSORA table must contain an entry for the corresponding index
           tablespace, for example:

           TABSPACE                        INDSPACE

           --------                        --------

           PSAPDIMD                        PSAPDIMD

           PSAPFACTD                        PSAPFACTD

           PSAPODSD                        PSAPODSD

           

           In most cases, these entries are missing and have to be added.
           See also notes 502989 and 46272.
0

Featured Post

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Note: You must have administrative privileges in order to create/edit Sharing Rules. Salesforce.com (http://www.salesforce.com) (SFDC) is a cloud-based customer relationship management (CRM) system. It is a database most commonly used by sales an…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

615 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question