Solved

ADD_PARTITION_FAILED

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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Visual FoxPro Ver 9. What is UDDATA.PRG? 30 894
CRM & Email Software 6 134
configuration management 2 122
What ERP development platform 4 56
If you have problems displaying reports in CRM after a new installation, review the following steps: Check that SQL Server Reporting Services is working On the server that has SQL Server Reporting Services (SQL SRS) installed, check that the S…
In our personal lives, we have well-designed consumer apps to delight us and make even the most complex transactions simple. Many enterprise applications, however, are a bit behind the times. For an enterprise app to be successful in today's tech wo…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

713 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