Solved

ADD_PARTITION_FAILED

Posted on 2004-07-31
3
1,268 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
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Messaging apps are amazing tools with the power to do a lot of good, but the truth is the process of collaborating with coworkers requires relationships established through meaningful communication - the kind of communication that only happens face-…
Get to know the ins and outs of building a web-based ERP system for your enterprise. Development timeline, technology, and costs outlined.
This video discusses moving either the default database or any database to a new volume.
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

744 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now