• RELEVANCY SCORE 4.42

    DB:4.42:Loading Data Into Ods And Then Infocube 9m






    What is the purpose of loading the data into InfoCube via ODS?

    DB:4.42:Loading Data Into Ods And Then Infocube 9m


    ODS is basically used for staging purpose....it contains data which is not grouped together and which is of detailed level...and once u get the detailed level data into the ods u need not refer to the data which is coming from the r/3 or any other source.

    i hope this answer is of some help...if yes then pls assign some points....thank you

  • RELEVANCY SCORE 4.28

    DB:4.28:Ods Activation Failure 73






    hi

    I am Working On Production support

    Daily I am Loading data into the ODS (ZGSD_O03 Sales Over view)

    Today data load into the ODS was Sucessful but while activation it is giving the error message "ODS object ZGSD_O03 was built incorrectly. Cannot update Request"

    Can anybody tell me how to resolve it

    ThanksRegards

    PRIYA

    DB:4.28:Ods Activation Failure 73


    Hi,

    it seems to be one of the previous request was deleted by some one, check for the particular request whether the request is with green status or not, if not reconstruct that (if it is deleted).

    Regards

    Siddhu

  • RELEVANCY SCORE 4.23

    DB:4.23:Error While Loading Data From Ods To Cube c3





    Hi,I am loading data from flat files to my ODS.While loading Data to ODS it is not giving any errorBut everytime i load data from ODS to Cube I get an error" Error occurred in the data selection ".though i have not specified any selections.

    DB:4.23:Error While Loading Data From Ods To Cube c3

    Hi Sachin,I think the flat file structure is not corresponding to your transfer structure. Check that. Also are you bale to preview the file in the infopackage.ByeDinesh

  • RELEVANCY SCORE 4.20

    DB:4.20:Short Dump While Loading Data Into The Gl Ods sf



    Hello Guyz

    I am getting a database error while loading the GL ODS in BW. I am performing an INIT load, and the error occurs during the activation stage:

    Database Error

  • RELEVANCY SCORE 4.20

    DB:4.20:How To Improve The Ods Query Performance ?????? 37



    Hi BW gurus,

    Most of our queries run on ODS and the performance is very very bad. We have daily loads into these ODS's. We want to improve it. BW implemented 3 years back. GL ODS has 100 millions, AR AP ODS has around 20 millions. What is the best strategy to improve the performance?

    1. Archiving the data

    2. Creating the MultiProvider by splitting the data into yearly based like 2004, 2005 2006

    3. Creating the InfoCubes and loading ODS data into these InfoCubes and reporting against InfoCubes.

    4. ???????????????

    What is your recommendations, please ?

    Thanks,

    Venkat.

    DB:4.20:How To Improve The Ods Query Performance ?????? 37


    If CUBE is not an option..

    You can split the existing ODS into multiple ODS based on FISCAL Year or excusively based on QUERY-Usage by user.

    This requires new quieries that get data from a targeted ODS rather from a global ODS.

    Any consolidated dat can be acheived by an MultiCube/Multiprovider.

    Carefull selection of Index( and order of infoobjects in Index) will improve the query performance.

  • RELEVANCY SCORE 4.12

    DB:4.12:Getting Sid For Ods Object Zofigl02 ac



    Data is loading through process chain. I am getting the error while getting sid for ODS.

    If I go on detail tab

    Getting Red mark. Below is the msg

    Activation of data records from ODS object ZOFIGL02 terminated

    DB:4.12:Getting Sid For Ods Object Zofigl02 ac


    HI

    Try to reactivate it manually.

    Regards,

    chandra.

  • RELEVANCY SCORE 4.09

    DB:4.09:Repair Ods: Data Iconsistency m9



    Hi all,

    We are facing a problem in loading data to an ODS. The error message is due to inconsistent data.

    We are in 3.1 system. We are not able to do any setting in RSRV.

    We want to repair ODS. Is there any other way except RSRV.

    Please suggest

    DB:4.09:Repair Ods: Data Iconsistency m9


    Hi,

    Goto RSRQ and give this request no, execute and make the total status manually to RED.

    and try the next load....

    --

    rgds,

  • RELEVANCY SCORE 4.05

    DB:4.05:Urgent Problem........ Ods To Cube Update 71



    Hi all,

    I am loading the data first into ODS then into Info Cubes both transational and basic cubes.

    while loading the data into Cubes I got an error message

    "kein Request Copy vom Basis- in den Transaktionalen Cube".

    Both Request up to the basic Cube are correctly updated, but not arrived in the Transactional Cube .

    All data was deleted in trans. Cube,before the data is udated from the ODS and from the basic Cube and from the import version.

    Any suggestions please.

    Cheers

    Sailekha

    DB:4.05:Urgent Problem........ Ods To Cube Update 71


    Transactional ODS/cubes don't allow loads with common ETL proceses, they should be loaded manually or with analisys tools (BPS, APD...).

    You should convert your transactional cube in basic cube before loading (in context menu for your infocube) and convert to transactional when load finished

  • RELEVANCY SCORE 4.05

    DB:4.05:Loading From Ods To Cube Fails ma



    I have a cube, which has data load from four ODS objects.

    When I tried to load the active data that is in the first ODS into a cube - it fails with the following error.

    err #1 )Data Package 1 : arrived in BW ; Processing : Error records written to application log

    err #2 ) Fiscal year variant C1 not expected

    First, Is there any order to follow when loading from multiple ODS's to one cube?

    Second, would appreciate any help in clearing up these errors.

    thanks,

    DB:4.05:Loading From Ods To Cube Fails ma


    Hi Esan:

    One last issue.

    Afer you are done loading, create a query and make sure the Dates are coming in the right format, etc. Its worth the time since its a new variant that you just created.

    Ram C.

  • RELEVANCY SCORE 4.03

    DB:4.03:System Error Occured Rfc Call While Loading fc


    Hi Guys,while loading the data to ODS i got below error message ,*System error occured RFC call*Task 0083 for parallel SID assignment terminated with errors *Activation of data records from ODS object 0RSL_DS01 terminated *Error getting SID for ODS object 0RSL_DS01 Can plz suggest wat to do?Rgds,mapras

    DB:4.03:System Error Occured Rfc Call While Loading fc

    Hi mapras,Can you repeat the activation process? Sometimes such issue can be corrected by simply repetition.Regards,Frank

  • RELEVANCY SCORE 4.00

    DB:4.00:Can We Execute The Reports On Particular Ods/Infocube In The Following Case sx



    Hi Friends,

    Can we execute the reports on particular ODS/InfoCube in the following cases

    1) When the data is loading into that ODS/Infocube.

    2) When we are Archiving the data from that ODS/Infocube

    Thanks Regards,

    Shaliny. M

    DB:4.00:Can We Execute The Reports On Particular Ods/Infocube In The Following Case sx


    Shaliny,

    We can execute the reports in both the cases. In the first case it will report only on data which is already there in the cube and not the data which is being loaded. Which means the data of the request being loaded is still not ready for reporting.

    Similarly, in the second case the data which is displayed will be not useful for analysis.

  • RELEVANCY SCORE 3.98

    DB:3.98:Ods Data Load Problem 9f



    DATA LOAD ERROR:

    WHILE LOADING DATA INTO ODS, THE PROCESS HANGS INDEFINITELY.

    Monitor screen shows YELLOW STAUS at EXTRACTION step. However, PSA

    shows that the data are extracted correctly with GREEN status for each row.

    The subsequent step (TRANSFER ) states MISSING MESSAGES or WARNINGS.

    The next step (PROCESSING ) shows GREEN STATUS with everything OK.

    Data gets into NEW DATA table of ODS, and request QM status shows GREEN.

    However data CANNOT be activated manually or automatically.

    YELLOW STATUS AT EXTRACTION PROCESS, STAYS INDEFINITELY.

    manohar

    DB:3.98:Ods Data Load Problem 9f


    I would go into the Archive log and see if there are any messages in there that can point you to the problem. I would suspect it to be a bad data or an invalid character in one of your records.

    To go to the Archive Log ... go to the pop-up screen when you archive a request (it's in the manage cube screen) and then click on the "Logs" button at the bottom of the screen. Choose the topmost "red" message and click on "activation log". Execute through "Analyse Application Log" Screen to get to the messages.

    I'm on 3.5.3, so if you are on a different version, these steps may be a little different.

    You can also look at ST22 for any short dumps and SM21 (system log) to see if there are any errors that didn't get caught in a short dump.

    Also, before you do any of this, check SM50 and make sure your process stopped. If it's still running, then leave it alone unless it's been running too long (possible endless loop like Nisha was suggesting).

    Good Luck!

  • RELEVANCY SCORE 3.97

    DB:3.97:Loading Master Data Into Ods 1f



    Hi,

    Can anyone tell me how to load the master data into the ODS?

    Thanks

    Yadav

    Edited by: yadav on Apr 12, 2008 8:04 PM

    DB:3.97:Loading Master Data Into Ods 1f


    Dear Yadav,

    Placing atleast one key figure like count means ,,,there should be atleast one key figure in ur ODS now,,,

    So COUNT is a dummy key figure which helps u in the creation of ur ODS..

    So creats an key figure info Object Zcount of type key figure..

    At the update rules of ur ODS,,when updating that COUNT info object...place with a constant with value 1 and in the report hide that count..

    Hope this helps u,,,

    Assign points if needful..

    Best Regards,

    VVenkat..

  • RELEVANCY SCORE 3.97

    DB:3.97:Ods Activation Overlapping Error pj



    Hi All,

    I am loading data into ODS 0FIAR_O03 using 3.x dataflow.

    First, I used IP " INIT without Data Transfer"

    Then I tried to load using Full Load.

    I am getting the error "Full 186 has overlapping selections with

    0000000185: No updates into 0FIAR_O03 "

    There is no record in my ODS except the 1 rec passed during init.

    Pls tell me the reason?

    Thanx,

    Gaurav

    DB:3.97:Ods Activation Overlapping Error pj


    Hi Gaurav,

    When you do full upload to ODS and then when you try to do delta intialisation it will always fails with message that ods cannot be activated only..

    To resolve this, convert the fullupload request into full repair request by executing the pgm RSSM_SET_REPAIR_FULL_FLAG in SE38.

    after converting the request into full repair and then try to do activate the ods, it will work..

    Hope it helps..

    Regards,

    Siva.

  • RELEVANCY SCORE 3.96

    DB:3.96:Delta Error In Ods fx



    hi experts,

    if delta load fails b/n ods infocube

    how to rectify that , for that what is the procedure

    when we are loading the data ods to infocube how to choose the

    keyfields?is it equal to dimensions

    thanks in advance

    venu

    DB:3.96:Delta Error In Ods fx


    Hi,

    It's the same procedure which we follow for the delta from R/3 to the Bw targets.

    The only thing is if you can correct it in the PSA then you can correct it there and then load it from there.

    Or you can delete the failed delta request from the cube and relaod the delta

    it will give you warning that you are repeating the delta.the new delta will bring the records from the failed delta as well as the records from the new delta if any.

    Th key fields of the ODS are not equivalent to dimension.

    Dimension are for the logical groupings of the objects and are decided in such a way that the size of dimension table should bve as small as possible.

    Where as the key fields of the ODS are like the keys of the table if you want to identify a particular value with respect to a char or combination of char.just imagine it as a table with keys.

    hope it clears

    Thanks

  • RELEVANCY SCORE 3.96

    DB:3.96:Dump Cx_Sy_No_Handler Uncaught_Exception Load Ods 1x


    Hi Gurus, loading the data into a ods by DTP (PSA at ods) is giving the following dump: "CX_SY_NO_HANDLER uncaught_exception". I've seen several posts in the sdn referring to the error, but none gives a concrete solution. Any idea why this error can give? or if there is any oss note that you can solve? Thanks in advance,

    DB:3.96:Dump Cx_Sy_No_Handler Uncaught_Exception Load Ods 1x

    Hi,Try this link.. Re: PSA to DSO using selected request via DTPEdited by: Melissa Wilcox on Nov 13, 2009 2:23 PM

  • RELEVANCY SCORE 3.95

    DB:3.95:Ods Activation Problem 8d



    Hi experts,

    How to delete in ODS New table data based on selection critera???

    When we are loading the data to ODS the data will be goes to New Table na after checking the data na, why invalid error showing when activation time. what process will happen when we are activating the ODS???

    Thanks

    Sudha

    DB:3.95:Ods Activation Problem 8d


    Hi,

    see in SM37 the status of job BI_PROCESS_ODSACTIVAT.

    If is in interrupted status, see the log that explains you the error occurred.

    Regards,

    Vito

  • RELEVANCY SCORE 3.89

    DB:3.89:Loading Bulk Data Into An Ods x7



    Hi,

    I've to extract big volume of data (millions of records) into an ODS. But the problem is, I cannot give selections in the infopackage as there are no fields in data selection tab.

    If I extract all the data, then ods activation would definately fail. Is there any of doing this?

    Many Thx.

    DB:3.89:Loading Bulk Data Into An Ods x7


    Hi,

    ok, that explains the issue. But anyway, do what we already suggested and maintain your datasource and set one or more of the fields to selection criterias and you will be able to limit the load.

    regards

    Siggi

  • RELEVANCY SCORE 3.89

    DB:3.89:Ods Not Activated sd



    Hi guys,

    I have uploaded the data into ODS it is coming to the ODS with green mark but with some warnings. The data comes upto the New table and when I activated the ODS the data is not moved to Active Table what may be the error

    Pls help brilliants rewarded with points

    Thanks Regards,

    K.N.Murthy

    DB:3.89:Ods Not Activated sd


    Hi aravind,

    I have activated it manually also by selecting the request also. But still the data in new table only. But the request status in green turned to yellow i dont know why. Hope do help me in this issue.

    Thanks,

    K.Narasimha Murthy

  • RELEVANCY SCORE 3.89

    DB:3.89:Message_Type_X Error While Activating The Ods Data 89


    Hi all, I am loading the data of 9000 records into ODS and the Status was Yellow in the monitor after 4 hours. When I clicked the 'Details' tab in Monitor and it asked whether to Activate ODS Data then I checked 'Yes'. This ODS Data Activation job was cancelled in SM37 and produced MESSAGE_TYPE_X Runtime Error. Then checked the 'Details' tab of Monitor again. Under Transfer (IDocs and TRFC): Errors occurred 'Data Package 1: arrived in BW; Processing : 2nd processing step not yet finished. Next, ODS -- Right click -- Activate ODS Data. I found my request and tried to Activate it. When checked it in SM37, it was with cancelled status. Changed the 'Total' light to RED in Status tab of Monitor from Yellow to reload the InfoPackage again. When I tried to open the InfoPackage, I started getting the MESSAGE_TYPE_X Error. It didn't allow me to open it. I successfully reconstructed this request (ODS -- Manage -- Reconstruction Tab). I tried to Activate ODS Data again (ODS -- Right Click -- Activate ODS Data) and failed with same MESSAGE_TYPE_X Error. Currently, the status light is with Red Green (Waiting for Data Activation ) for the load request in Monitor. What I suspect that it is not yet ready for the Data activation and it causing the MESSAGE_TYPE_X Error. I made some mistake in this whole process. How can I get ridoff this MESSAGE_TYPE_X error and activate the data in ODS, please ? If possible, I want to clean-up all these mess and load it again fresh. Thanks in advance.Regards.

    DB:3.89:Message_Type_X Error While Activating The Ods Data 89

    Hi Venkat,take a look into st22 short dump log, this type of error uses to cause a short dump, in order to get some information about your problem run the program in BW 'RSSM_OLTP_INIT_DELTA_UPDATE "go to se38 and run the following programRSSM_OLTP_INIT_DELTA_UPDATE enter the correct source system ID and the infosource ID.you will not get any message at the end of the program.try. opening the infopackage to confirm. Check the other links with similar issues;https://forums.sdn.sap.com/click.jspa?searchID=559364messageID=2146573https://forums.sdn.sap.com/click.jspa?searchID=559364messageID=1834605https://forums.sdn.sap.com/click.jspa?searchID=559364messageID=891949Please refer to OSS note 852443.****Assign Points If Helpful****Regards,Ravikanth

  • RELEVANCY SCORE 3.88

    DB:3.88:Loading The Data Into Ods Is Loading Forever s1



    Hi,

    Iam trying to load the data into ODS its running

    forever without having any error.Actually the no.of records are also less ie 900 records only.

    Can you please suggest what might be the cause?

    Thanks in advance

    Regards

    DB:3.88:Loading The Data Into Ods Is Loading Forever s1


    Govinda,

    Check the status in SM37, whether the job has been cancelled or not.

    If its not cancelled check the status in ODS(Contents),if the request still fine then check there might be failed request in the data target which is not deleted, delete that request.This is one case.

    Check ST22 and SM21 tcode for any kind of short dump.

    Otherwise check the details in Detail tab (RSMO), where the load has been stucked.

    And check wether there is any data come to your ods in ODS(Manage).

    Or else activate your ods in Manage.

    Thanks

    Ramu

  • RELEVANCY SCORE 3.87

    DB:3.87:Ods Active Data Error j8



    Hi,

    We have loading data into ODS table as new data, when we try to active the data into active data,

    every time a new job is created successfully and the job starts to work. But There is no data to be actived into

    active table.

    We try to create a process chain and then run it, it is said: Job BI_PROCESS_DTP_LOAD counld not be scheduled.

    Termination with returncode 8(Error when scheduling job(JOB_SUBMIT)).

    We have tried in two ODS ,but with the same error.

    DB:3.87:Ods Active Data Error j8


    Hi Shiqing,

    Please check out OSS note 511475 which talks about this problem and possible solution. I have used this earlier.

    Hope this helps...

  • RELEVANCY SCORE 3.87

    DB:3.87:Problem In Loading Data From Ods To Cube 8c



    hi all,

    i have a small problem.

    i have loaded some data to ODS using Delta Loading and the data is in the NEW DATA section. i have been asked to activate the data and then load it into Cube. While activating it starts the process and completes too

    [The QM status is green].

    but in the request tab of ODS-MANAGE.

    it does not shows any PSA request number generated .

    and so it is not alowing me to upadate the data in my infocube .

    When i goto the background job list, the job is cancelled and the log shows the following :

    --Error getting SID for ODS ODS NAME object

    --Activation of data records from ODS object ODS NAME terminated

    what sud i do.

    please help me.

    Regards,

    Parth

    DB:3.87:Problem In Loading Data From Ods To Cube 8c


    Hi Partho

    I think ur validating ur data against the master data. There is a check box against only update data target if master data exists in infopackage. So if this checkbox is ticked then while activating ODS, it checks weather the master data is available or not.So if the master data doestnt exist, it gives the SID error. So just check weather you are facing the same problem.

    This was discussed in another post by clyde by subject

    "ODS Activation error ". Just check the post. You might get the solution.

    Regards

    Sriram

  • RELEVANCY SCORE 3.86

    DB:3.86:Ods To Cube 71



    Hi

    I am loading my CUBE from ODS object, the request was success, but data is not available in Cube (Data available in ODS). Why?

    DB:3.86:Ods To Cube 71


    Hi Srinivas

    Pls go to ur ODSmanageSelct the Request Tab check out whether u have Data mart symbol nxt to the request ID,If No then select the Full Upload from the ODS rght click then select the Update into the data Target Then u get POP up window the select Full load.Then from the Nxt load select the Init run from the ODS.

  • RELEVANCY SCORE 3.85

    DB:3.85:Getting Error Message While Loading Data From One Ods To Another Ods 88


    Hello,We are getting error message "No active update rules exist for this infosource" while loading data from one ODS to another ODS.We have checked the update rule and it is active. Data is getting loaded upto PSA but not getting loaded into the targets ODS and we are getting above mentioned message.Please let me know if anyone has faced this problem.Regards,Sanjay

  • RELEVANCY SCORE 3.84

    DB:3.84:Activation Of Data Records From Ods af



    Hello Friends,

    I am loading data into ODS. I have selected Only PSA Processing and getting data in PSA but while transferring from PSA to ODS its giving the error.

    Activation of data records from ODS object PMNAID07 terminated

    Request REQU_4RQKUWK0CZKUL2EPJASF9E25L, data package 000001 contains errors with status 9 in

    table 'RSODSACTREQ' but this data package is missing in the return

    structure.

    Communication error (RFC call) occurred

    DB:3.84:Activation Of Data Records From Ods af


    Mauricio

    pl try to follow thie steps suggeted in this post, if not succeed, then let me know.

    Normally such problem come up because of trasformation involved, so please check them, if possible reach to the error record and try to rectify the problem by modifying the value in PSA maintenace, provided that u have enough authorisation and business knowledge.

  • RELEVANCY SCORE 3.84

    DB:3.84:Hexadecimal Error In Bw Side sz



    Hi ,

    I have a problem in loading data.The data must be loaded into ODS and then to CUBE.There are no issues in loading data into ODS.But while updating ODS data into CUBE I get INVALID HXADECIMAL CHARACTER message in RSMO.But there are no invalid characters in the data.

    Can anyone help me solve this.PLZ This is urgent.I promise to give reward points to the suggestions or solutions.

    DB:3.84:Hexadecimal Error In Bw Side sz


    Hi,

    Pls check whether "lowercase" is enabled for the info-objects. I have faced such an error and finally found it was due to case mismatch.

    REgards,

    R.Ravi

  • RELEVANCY SCORE 3.83

    DB:3.83:Process Chain Dtp Loading xx



    Dear All

    i create a process chain the first step is to load data from PSA into ODS

    As i check the log the process finish successfully without any error but autically it does nothing.

    'Process started' and 'Process complete' and then 'roll back' , i can't check out the error why it is not loaded into ODS

    Thanks for your time

    Kind Regards

    Terry Ni

    DB:3.83:Process Chain Dtp Loading xx


    Please load data from source to PSA (pack) and then run your chain .. the data should come thru .. if there is no data, DTp would say, process started and finished with no data.

  • RELEVANCY SCORE 3.82

    DB:3.82:Ods Error xj



    hi ,

    while loading to ODS iam getting a error "data record already exists in the active data table "

    ODS is not getting activted ...

    i have checked unique data records in the settings ..whats could be the prob..

    regards

    DB:3.82:Ods Error xj


    Hi Kalyan,

    When u r loading data from r/3 to ods if u face above error,

    1. check the data in the active data table

    2. compare data between active data table and new data

    if u have same problem with that delete the request and referesh the ods and try to repeat the delta. but uncheck the unique data records check box.

    Because if u get same data it will overwrite.

    Hope this will help,

    Regards,

    HARI GUPTA

  • RELEVANCY SCORE 3.82

    DB:3.82:No Data Is Loading To The Ods Although Transfered Records Are There jk



    Hi All,

    I have an issue.Am working in prod and we are loading delta records from 2 ODS to 3rd ODS...In the lower ODSs data is getting loaded but from one of these ODS data is transfered to the top ODS but no data is getting loaded into the top ODS. the status is also yellow and there is no job for this SM37 and SM50.

    i have manually activated this ODS but still it is showing data processing (from a long time)...How can this problem be solved?

    DB:3.82:No Data Is Loading To The Ods Although Transfered Records Are There jk


    DK,

    If you can confirm there is no corresponding work process running for this data load (you had checked that in SM50 SM37), then maybe its worthwhile checking in the following transactions for further information.

    Shortdumps - ST22 (a particular data package might have fallen over)

    BD87 - Issue with IDOC interface

    SM58 - Problem with transactional RFC

  • RELEVANCY SCORE 3.82

    DB:3.82:Loading Data Into An Excisting Excel Using Ods da



    Need some help in writing data into an Excel using ODS HTML( or anyother ODS like MSOFFICE, etc), where I would like to add current date to the excisting Excel file name. Any help would be highly appreciated. Thanks in advance.

    DB:3.82:Loading Data Into An Excisting Excel Using Ods da


    Why not just added the "make it XLSX" into the programs that create the XML with tagsets. As soon as XML is created run "make it XLSX" using INFILE PIPE and the program will not continue until the VBSCRIPT is done.

  • RELEVANCY SCORE 3.81

    DB:3.81:Timed Out Error a9



    Hi Friends

    I'm loading data into ODS and cube parelally.

    The load failed on BW QA into ods and it has start routine on update rules and the load successful on Cube.

    While updating into ods ,it's timed out.

    How can we overcome with this Timed out problem.

    Regards,

    Chama.

    DB:3.81:Timed Out Error a9


    Hi,

    Reduce the data packet size even further. I strongly recommend to check any code in the update rules for performance. That might be your problem area. Also try to drop indexes on the cube before loading the data to the cube and then recreate them after loading is over.

    Cheers,

    Kedar

  • RELEVANCY SCORE 3.81

    DB:3.81:Ods To Ods And Cube Help! xa



    Hi

    We have two ODS's (ODS A and B)loading from ECC and these ODS data is loading in to several cubes and other ODS's.

    We have some issues with ODS A load to cube so we deleted the cube data and reinitalized from ODS A. this ODS A is

    also loading to other ODS's (ODS B , then ODS B loads to ODS C) etc...All the ODS have the KF as overwrite option. Now I'm wondering when

    I reinitialized from ODS A to cube do I need to load that init req to ODS B aswell or not ? If not please let me know

    how can I make sure everything is getting correct. If yes, can I just go ahead load in to ODS B and then ODS B data to ODS C and cube B etc..?

    Please let me know asap.

    Thanks

    Sam

    DB:3.81:Ods To Ods And Cube Help! xa


    Do you have the flow from ODS B to Cube B ?

    if so run the delta load and then you need to delete Init req

    ODSB to CubeB

    ODSB to ODS C

    and do Init without data and then delta

  • RELEVANCY SCORE 3.81

    DB:3.81:Error Message While Loading Data 1a



    Hi,

    A request which loads data into ODS from an R/3 table failed and these are the Error Messages:

    1Error getting SID for ODS object ZM0004RSM1187

    2Error when assigning SID (details in long text)RSDRO303

    3Activation of data records from ODS object ZM0004 terminatedRSM1102

    4Value 'ALMA TREVIO ' (hex. '414C4D41205452455649D14F ') of characteristic ZAFNAM contains invalid characteBRAIN60

    Please help me to solve this error.

    Thanks

    DB:3.81:Error Message While Loading Data 1a


    Hi

    Source system is R/3.

    Every data will load automatically, to day it failed. Even after trying to reload in the foreground, it's giving the same error.

  • RELEVANCY SCORE 3.79

    DB:3.79:Error When Loading 2lis_11_Vakon dk



    Hello Gurus,

    When I load data into a custom ODS from infosource-2lis_11_vakon , i getr the foll error:

    The data object "I_S_OLDDATA" does not have a component called

    "CONDTYPE".

    actually i had this infoobject called 0condtype, then b'cas of some reason i had to create my own custom infoobject, zkschl. i deleted the ods,source system assignment, comm struc, recreated again...still the problem persistes.

    kindly guide. thanks in advance

    DB:3.79:Error When Loading 2lis_11_Vakon dk


    as mentioned above verify the maping in the transfer rules see the sapnote 847883 i solve the problem doing this procedure.

    regards

  • RELEVANCY SCORE 3.79

    DB:3.79:Error Loading Data Into Ods From Ods 7a



    I have a loading problem wen trying to load data fro an ODS to another which has a start routine in the Update rules.

    the errors are as follows.

    ERROE 7 when sending IDOC

    INCLUDE INCL_INSTALLATION ERROR

    INCLUDE INCL_INSTALLATION ERROR 7

    INCLUDE INCL_INSTALLATION ERROR 2

    INCLUDE INCL_INSTALLATION ERROR 5

    Connection Closed (no data) 4

    Connection Closed (no data)

    Connection Closed (no data) 6

    Error in Source System.

    But there are lot of data in the loading ODS

    Please help me

    DB:3.79:Error Loading Data Into Ods From Ods 7a


    Hi,

    Please check the following OSS notes.

    Note 610938 - Error 7 during transfer of an IDoc into BW

    Note 610246 - Error 7 when sending an IDoc

    Regards.

  • RELEVANCY SCORE 3.76

    DB:3.76:Error While Loading Data From One Ods To Anther Ods fj



    Hi all,

    while loading the data from one ODS to another ODS, we are getting error message - Error: No match found in target. No Space on ODS.

    I have done a runstat on these tables of the ODS.. but the issue repeated.

    Can anyone tell how do we solve this issue.

    DB:3.76:Error While Loading Data From One Ods To Anther Ods fj


    Check if you get any other Dump message in ST22 to see if it is due to some space availability in the DSO or underlying tables.

    Or Post in detail if any other errore message is available.

  • RELEVANCY SCORE 3.76

    DB:3.76:Error Occured While Loading From 1st Level Ods To 2nd Level Ods 9z



    Dear Friends,

    I have an issue that is when i try to load the data from 1st level ods to 2nd level ods i get error message as

    Request requ_4evs0l8j561xzy5mw121tkmzs(446,276) has not or not currently been updated.

    Activation of data records from ODS object ..... terminated

    Am running it as INIT without Data transfer but am getting same error.

    I have deleted the complete request and started loading from the scratch but still i am getting the same error.

    Can someone pls help me out in this as am facing his issue in PRD system.

    Thanks

    DB:3.76:Error Occured While Loading From 1st Level Ods To 2nd Level Ods 9z


    Do you already have a Full request in the DSO? What is the error message other than "Activation of data records from ODS object ..... terminated". Click on the log in the manage screen of the DSO for this failed request and let us know the error message.

    If you already have a Full request then Delta is not possible on it. You need to change it to a Repair Full before starting delta's. Check this thread. It gives you steps to change the update mode Flag:-

    Loading FULL and DELTA into a DSO

  • RELEVANCY SCORE 3.76

    DB:3.76:Error Occured During Data Selection x3


    Hi Community, I got "Error Occured During Data Selection" when loading data from ODS to Info Cube. This info cube already contained data before but first time I didnt get complete records (both in ODS and Info Cube) so I deleted the request and load the data in both ODS and Info cube. I got the records in ODS but when I am loading data from ODS to Info Cube then error displayed in Monitor display called "Error Occured During Data Selection" I am working on BI 7.0. Please help me RegdsRobbie.

    DB:3.76:Error Occured During Data Selection x3

    Hi Anil, I got the answer, just bcoz in infopackage it was default selecting PSA and Data Targets only, I changed that option. Thanks Anil for your help.....ThanksRobbie

  • RELEVANCY SCORE 3.75

    DB:3.75:Delta Missing While Loading From Ods To Cube. kc



    Hi all,

    While loading delta data from ODS to Cube, we got error.

    we have accidentally deleted the PSA request of the Cube(change log in the ODS) while trying to correct the error.

    Due to this now we have missed the delta data to the cube i.e, we are getting 0 records when running delta load to the cube even after deleting the data mart status in the ODS.

    bHow can we load that particular request into the cube from that ODS?/b

    Thanks in advance,

    Raj

    DB:3.75:Delta Missing While Loading From Ods To Cube. kc


    Hi Vishvesh,

    Ya I have done all that, But other than we have deleted the PSA request ( request in the change-log ) for the ODS . So thats the reason y we are getting 0 records even after we have reset the delta maintenance.

    So my question here is whether there is a way we could get that request in change log again so that the load to the cube picks the delta data again.

    And I am also thinking of the option of deleting the request from the ODS itself( by making the request RED) which gets data from R/3. bBut i was wondering if we will get 'Repeat delta of the previuos request' from R/3?/b

    Please help.

    Thanks Again.

  • RELEVANCY SCORE 3.75

    DB:3.75:Ods Vs Infocube zd



    Hi,

    ive one ods and one infocube when we load the data why should we prefer loading in infocube than ods since both contains the data?

    can we convert RKF into CKF IF POSSIBLE xplain by step -step procedure?

    ram.

    DB:3.75:Ods Vs Infocube zd


    Hi Ram,

    Loading data to ODS or Cube, the main purpose is reporting. Loading data to cube or ods or ods to cube, its all depends on the data modeling and business requirements. If you are loading data directly to the infocube, that means the data is pure. Data maintaince is costly in CUBE where are ods is cheaper.

    Cube is always the better option for reporting point of view as it has the greater flexibility to see the data. Data are stored in multidimension mode. Where are ODS is like a simple Table which contain Rows Columns only. You can not drill down the data in the hierarchical way.

    Hope this helps you.

    Sanjiv

  • RELEVANCY SCORE 3.74

    DB:3.74:Datasource Has To Be Replicated Error Message kx



    Hi,

    i am loading data from R/3-ODS-Cube. I got timestamp error at ODS level.

    I have replicated ODS, but i am not able to activate the transfer rules.

    the infosource is not in change mode.How to activate the transfer rules

    Please help me in solving this problem.

    Thanks

    DB:3.74:Datasource Has To Be Replicated Error Message kx


    Goto Info source tab and search for 8ODS NAME

    Right click on that and say replicate data source .

    Then activate the transfer rules 8ODS NAME with the pgm RS_TRANSTRU_ACTIVATE_ALL

    then load the data.

  • RELEVANCY SCORE 3.74

    DB:3.74:Activate Data In Ods k3



    Hi Gurus,

    Im loading data from ods to ods thru full update and after that I have to activate that ODS,

    Kindly let me know the steps for activating the ODS,

    right click on the ods and press activate data n ods

    or before i have to do Update ods in data target.

    Raj

    DB:3.74:Activate Data In Ods k3


    hi

    yes i have to load to cube also

    raj

  • RELEVANCY SCORE 3.73

    DB:3.73:Can We Execute The Reporting While The Data Is Loading Into That Ods/Cube. ka



    Hi Friends,

    Can we execute the reports on particular ODS/InfoCube in the following cases

    1) When the data is loading into that ODS/Infocube.

    2) When we are Archiving the data from that ODS/Infocube

    Thanks Regards,

    Shaliny. M

    DB:3.73:Can We Execute The Reporting While The Data Is Loading Into That Ods/Cube. ka


    Hi Shaliny,

    First of all you are in the wrong forum, in Business Intelligence Old Forum (Read Only Archive) you will find better support.

    In case you are loading data in an infocube you will be able to have report only until the request that has the icon ready for reporting filled. In case of an ODS object i don't think you will be able to have valid reporting since the ODS data firstly needs to be activated.

    Nevertheless please post your question in the above link.

    Kostas

  • RELEVANCY SCORE 3.73

    DB:3.73:Delete Request From Ods 19



    Hi Gurus,

    suppose some requests are loaded in ODS and from ODS those requests are loaded into INFOCUBE. Now can i delete the request from the ODS.

    suppose if requests can be deleted then will there be any problem for the data in infocube for next time loading?

    suppose if requests can be deleted then can we get back those requests to ods again.

    Thanks,

    Ram

    DB:3.73:Delete Request From Ods 19


    Hi,

    If you want to delete requests that have already been updated in connected data targets, you have to adjust the connected data targets manually.

    Procedure

    ...

    1. In the administration of the data target, choose the tab page Requests. For your request to be deleted, choose Data Mart Status for the Data Target. The following dialog box displays the request that was updated in additional data targets. Keep the description of this request in mind.

    2. Choose Monitor on this dialog box. You arrive at the monitor for this request.

    3. Choose Manage Data Targets. You arrive at the administration for the connected data targets.

    4. Delete the respective request.

    5. This takes you to the source ODS object administration screen.

    6. Reset the delta administration. To do this, choose Data Mart Status for the Data Target and from the subsequent dialog box, choose Reset Delta Administration.

    7. Now you can also delete the respective request from the source ODS object. You can now load data as full or data again.

    bsuppose if requests can be deleted then can we get back those requests to ods again/b

    u can use reconstruction tab of the ODS

    Hope its clear.

    shylaja.

  • RELEVANCY SCORE 3.73

    DB:3.73:Ods d8



    while uploading the data into info cube from ods which tabe is refers

    DB:3.73:Ods d8


    Delta - Changelog Table

    Full - Active Table

    Please search SDN for more information.

  • RELEVANCY SCORE 3.72

    DB:3.72:Ods Issue 9a



    Hi have created a New ODS

    Key items are - Business Unit and Article Number

    Data fields - 0plant , total capacity and soo onnn..

    after loading Data into ODS ... i am not able to see the object of Artical number in the Report nor in the Mannage screen of the ODS.

    Please help me if any how do i fix this problem

    Santosh

    DB:3.72:Ods Issue 9a


    Hi,

    Pleae check Article Number is checked for attribute only property.

    Thanks,

  • RELEVANCY SCORE 3.71

    DB:3.71:Ods Load 0date Error d1



    I am loading data into an ODS and i recieve the following error

    Value '1060301' of characteristic 0DATE is not a number with 000008 Spaces

    How do I solve this one?

    DB:3.71:Ods Load 0date Error d1


    Hi xcal,

    Where does your data come from? Do you think that is correct date format? If you generate it, I think you should modify them to 8 digitals like "YYYYMMDD" format. If you get them from other object, maybe should check your export format. That is definitely format error.

    hope it helps you. good luck

  • RELEVANCY SCORE 3.71

    DB:3.71:Error While Loading Data From Ods To Cube In 0material jp



    Hello Friends,

    I am getting a peculiar error while loading data from ODS to Cube in 0Material.

    The error description is as follows:-

    There is no structure with name 0Material for infoobject CHK.

    This needs to be resolved asap. So requiring ur valuable comments.

    Regards

    Rohit

    DB:3.71:Error While Loading Data From Ods To Cube In 0material jp


    Hello Friends,

    I am getting a peculiar error while loading data from ODS to Cube in 0Material.

    The error description is as follows:-

    There is no structure with name 0Material for infoobject CHK.

    This needs to be resolved asap. So requiring ur valuable comments.

    Regards

    Rohit

  • RELEVANCY SCORE 3.70

    DB:3.70:Error Uploadind Data Into Ods dj



    Hello there,

    i'm trying to load data into an ODS from R/3 DataSources. I plan the infoPackage to load data into the PSA and then into the ODS.

    The data is actually loaded into the PSA but the process fails (i think) when activating the ODS Data. I get the following error messages (several times):

    "Task 0001 for parallel SID assignment terminated with errors"

    "Error getting SID for ODS Object ODS_name"

    "System error occurred (RFC Call)"

    Do you know what can i do to fix this?

    Thanks a lot!

    Marta

    DB:3.70:Error Uploadind Data Into Ods dj


    Hi!

    It works. I did the load first and then manually activated the ODS data and it worked.

    Thanks a lot.

    i'm sorry, i know it's sad, but i'm trying to reward your answers and i can't find the way. i see the check-list buttons but, is there any button to commit the selection?

  • RELEVANCY SCORE 3.69

    DB:3.69:Ods Data Activation Problem 1p



    Dear all,

    I was loading data into an ODS. During data activation, an error appeared: "Value '# ' (hex. '0023 ') of characteristic 0ALLOC_NMBR contains invalid characters." I checked and found in source system this field has the value of '#'. What confused me was that this '#' could be loaded into PSA but could not pass the activation. I have set "ALL_CAPITAL" in RSKC. Please advise. Thanks.

    Jin Ming

    DB:3.69:Ods Data Activation Problem 1p


    Thank you very much. I decide to write a transfer rule at infoObject level to replace '#' to other valid values.

  • RELEVANCY SCORE 3.69

    DB:3.69:Error When Loading 0bpartner Data To Ods x7



    Hi,

    I am trying to load data into an ODS.

    0bpartner is one of the assigned infosources to that ods.

    After checking the ODS, i see that 0bpartner data wasn't loaded and instead it displays a "00000000" entry in the BPARTNER column.

    I went to check the master data for 0BPARTNER, and indeed BPARTNER is populated with data that's not showing in the ODS.

    Any ideas why?

    Many thanks,

    Xibi

    DB:3.69:Error When Loading 0bpartner Data To Ods x7


    Hi,

    if you goto the monitor for the request open the detail tab. Then open the datapackage entries and you will see steps like transfer-rules, update-rules.. . In there, you can see how many records are processed at each step and how many records come out of each step.

    regards

    Siggi

    PS: I am quite sure that there is something wrong with the update of the keyfields of your ods.

  • RELEVANCY SCORE 3.69

    DB:3.69:0calday To 0fiscyear Conversion Error While Loading Data xk



    Hello Experts,

    While loading data from PSA to ODS and further to InfoCube(Automatically loaded from ODS) I am getting error as "Time conversion from 0CALDAY to 0FISCPER (fiscal year ) failed with value 20070123". So how can I rectify the error.

    Can anyone guide me in this regard.

    Regards,

    Priya

    DB:3.69:0calday To 0fiscyear Conversion Error While Loading Data xk


    Hello,

    Sorry I posted 0FISCYEAR but the error is for 0FISCPER.

    Kindly guide me.

    Regards,

    Priya

  • RELEVANCY SCORE 3.68

    DB:3.68:Ods Activation Failure ma


    Hi,While loading data to ODS the data available in New data table.After Activating ODS manually , it throws error like this,"ODS Object Activation SID changed; from 0 to 27"Whats the meaning of this error? and How to slove this error?Thanks Regards,Arun.M.D

    DB:3.68:Ods Activation Failure ma

    Hi,SID error comes during activation of ODS because the related MD is not available for assigning SIDs.So as a first step ensure that the related master data is loaded and Attribute change run has been triggered.Or Load the MD and Activate the MD (Modeling InfoObject Search the Infoobject Right click Activate Master Data)Once you perform this you can retrigger the activation. It should work fine.Else as a workaround you can blank out these particular values and activate.There is also one more workaround wherein you can create the Master data entries directly in BW itself. But both the above step should be done after consulting Business and considering data volume that needs to be edited/created.In most case once you perform the loading and activation of MD your activation should work fine when repeated.There are cases where it failed again with the same error. In that case try this also (ensure that PSA is there).Delete the request in red.Go to monitorEdit Setting for further update Packet should be processed in the background.Edit Update Reversal Read everything manually YesBackground processing successfully scheduledThen you can see the Load running again.Once this is done perform activation again.Thanks,JituK

  • RELEVANCY SCORE 3.68

    DB:3.68:Ods Activation Errors a3



    BW Experts

    I get the following errors when Activating a ODS via a Process Chain although the Loading Packages is green in the ODS I still get the error - please advise on how to fix or possible checks that I can perform

    Request REQU_C0WBH5QZMWMQZ0V6UF3ZNE9RX in ODS ZMMINV51 must have QM status green before it is activated

    Activation of data records from ODS object ZMMINV51 terminated

    DB:3.68:Ods Activation Errors a3


    Hi,

    Can you explain us how it is sorted?

    Regards,

    anil

  • RELEVANCY SCORE 3.68

    DB:3.68:Extraction 78



    Dear Gurus,

    I am facing the problem while loading, i am getting the data in ODS from the datasource 2lis_13_vditm. i am geeting the data in ods

    and while i am loading into cube it is not loading and throwing an error that No corrected request has arrived in the ods/cube. will

    anybody throw light on my thread, i tried for other datasources loading into ods , it is geting loading upto ods while loading into

    it not getting, and in status tab it is showing no data in datapackets and no idocs has arrived in the source system

    _

    No corresponding requests were found for request REQU_4GY9FW9M32E9OKDC1NQ0SXQG4 in the ODS/Cube

    Message no. RSBM043

    Edited by: RADHA AGARWAL on Feb 24, 2010 7:55 AM

    Edited by: RADHA AGARWAL on Feb 24, 2010 8:00 AM

    DB:3.68:Extraction 78


    HI Radha,

    Check whether SAP NOTE 542872 is relevent for your problem.

    Also go thru the following link :

    No corresponding request s were found for request reqxxx in the ODS or cube

    Regards,

    Srikanth.

  • RELEVANCY SCORE 3.68

    DB:3.68:Delete Footer / Last Record From Csv File a9



    This is for loading data into ODS.

    I have a flat file with footer and want to Delete/ Remove it before loading data in ODS writing code in Transfer Routine. Footer looks like:

    ********END OF FILE****************

    How to remove this footer in the routine? Because of this I am getting error saying last record has bad data. Also how can I delete empty line?

    Thanks.

    DB:3.68:Delete Footer / Last Record From Csv File a9


    try to do that:

    data : lines type i.
    describe table datapak lines lines.

    Loop at datapak into l_datapak.
    Condense l_datapak-Field1.

    IF sy-tabix EQ lines.
    DELETE l_datapak FROM datapak.
    ENDIF.
    Endloop.

  • RELEVANCY SCORE 3.67

    DB:3.67:Reg: Init Loading To Ods p1


    Hi All,I have to load data into an ODS. The first time i have to load the data loading has to be Init. I know how to load data either Full or Delta but don't know about Init loading. Kindly suggest me how i can do it.Best Regards,

    DB:3.67:Reg: Init Loading To Ods p1

    hi bhaskar, u need to run intilialisation option in order to run delta,otherwise delta option will not be enablised.deltas r mailny usefull to upload any changes from the old record to new record.hope it helps!!!!!!

  • RELEVANCY SCORE 3.67

    DB:3.67:Regarding Loading Data From Ods To Infocube ax



    hai

    just tell me what is the advantages and disadvantages of

    "Scheduling the data from ODS to InfoCube by creating Infopackage or by using the context menu of 'update ODS data into datatarget' "...

    I got so many shortdumps by using the option of 'Update ODS data into datatarget' while loading from ODS to InfoCube .

    Then i created many Infopackages and loaded the data bparallely/b from ODS to InfoCube..

    SO please tell me

    i ll assing the points

    bye

    rizwan

    DB:3.67:Regarding Loading Data From Ods To Infocube ax


    Hi Rizwan,

    Also check this link:

    http://help.sap.com/saphelp_nw04/helpdata/en/2c/749bbb595511d4b2bc0050da4c74dc/frameset.htm

    Bye

    Dinesh

  • RELEVANCY SCORE 3.66

    DB:3.66:Error Loading The Data Into The Ods xp



    Hi,

    In BI development, I was trying to load data into the ODS. The data is getting loaded for the first time perfectly. But, from the next load onwards the same data is getting loaded again and again ( I tried to load different data the next time). I think, the data which got loaded into the PSA for the first time is getting loaded again and again. When i try a different load, the previous data which was present in PSA is not getting overlapped. How can i correct this...please help.

    Thanks,

    Vikki

    DB:3.66:Error Loading The Data Into The Ods xp


    For a flat file - jst do full infopack n Delta DTP assuming u hav overwrite set up...

  • RELEVANCY SCORE 3.66

    DB:3.66:Parallel Loading a1



    Hi all,

    One quick question. I am loading from cube to ODS. The data to be loaded are too much to put into one data package (processing overdue error). So I am loading it via 2 datapackages by selecting different Caldays.

    My question is if it is possible to load these 2 packages parallel? Thanks!

    Jenny

    DB:3.66:Parallel Loading a1


    The Calday is in the Key Field of ODS?

    If not,the error that might be if the 2 loads try to insert a record with the same key at the same time.

    Regards.

  • RELEVANCY SCORE 3.65

    DB:3.65:Escapechar Problem mk



    Hello.

    I am new to ODS and am having a problem with escapechar. The program below runs fine in placing a map into the document but the escapechar does not make the text change I specified. I received the SAS error message below about a missing parens, which is not clear to me. I run SAS 9.2. thanks.

    data senatearea;

    set sasdatap.senate_trial_unprj;

    if district in ('03','04','05');

    run;

    ods escapechar="^";

    ods listing close;

    ods pdf body="c:\metafilesfromsas\ods\january20.pdf";

    ods layout start columns=2 column_widths=(3.5in 3.5in);

    ods region height=3.0in;

    ods region height=3.0in;

    proc gmap map=senatearea data=senatearea;

    id district;

    choro district / nolegend;

    pattern1 v=solid c=red;

    run;

    quit;

    ods region height=3.0in;

    ods region height=3.0in;

    ods pdf text="^S={font_weight=bold_font font_size=16pt} District Map";

    ERROR 79-322: Expecting a (.

    ERROR 76-322: Syntax error, statement will be ignored.

    ods layout end;

    run;

    ods pdf close;

    run;

    DB:3.65:Escapechar Problem mk


    Hello.

    I am new to ODS and am having a problem with escapechar. The program below runs fine in placing a map into the document but the escapechar does not make the text change I specified. I received the SAS error message below about a missing parens, which is not clear to me. I run SAS 9.2. thanks.

    data senatearea;

    set sasdatap.senate_trial_unprj;

    if district in ('03','04','05');

    run;

    ods escapechar="^";

    ods listing close;

    ods pdf body="c:\metafilesfromsas\ods\january20.pdf";

    ods layout start columns=2 column_widths=(3.5in 3.5in);

    ods region height=3.0in;

    ods region height=3.0in;

    proc gmap map=senatearea data=senatearea;

    id district;

    choro district / nolegend;

    pattern1 v=solid c=red;

    run;

    quit;

    ods region height=3.0in;

    ods region height=3.0in;

    ods pdf text="^S={font_weight=bold_font font_size=16pt} District Map";

    ERROR 79-322: Expecting a (.

    ERROR 76-322: Syntax error, statement will be ignored.

    ods layout end;

    run;

    ods pdf close;

    run;

  • RELEVANCY SCORE 3.65

    DB:3.65:Activating Ods To Cube (Urgent) mj



    Hello Gurus,

    I'm running an process chains where it loads data to ODS and activating ODS and loading data from ODS to CUBE ....

    bwhere my problem is while doing further processing for ODS to CUBE i'm getting an error as follows/b

    1.Error 8 when starting the extraction program

    2.Error in source system

    3.Error occurred when updating data from ODS

    b

    Plz through some light/b iurgent/i

    Regards

    Sandy

    DB:3.65:Activating Ods To Cube (Urgent) mj


    Hi Sandy,

    1. Check if the data request is active in the ODS.

    Run the two tests for ODS from RSRV

    All Elementary Tests - ODS Objects - Foreign Key Relationship of Reporting-Relevant ODS Object and SID Table Characteristics

    All Elementary Tests - ODS Objects - Check How Up-To-Date the Generated Programs of an ODS Object Are

    2. generate export data source.

    3. Activate the communication structure and transfer rules.

    4. Activate update rule

    5. try loading.

    hope it helps.

    Regards.

  • RELEVANCY SCORE 3.65

    DB:3.65:Master Data Into Ods? 8f



    Hi everyone

    Is there any difference between loading transaction data and master data into ODS?

    How to load master data(attributes,text,hierarchy) into ODS from flat file?

    Let me know the step by step scenario

    If u have documentation on this please mail me at jangareddy_d@yahoo.co.in

    thanks and regards

    dj reddy.

    DB:3.65:Master Data Into Ods? 8f


    Jabgareddy

    If I understood correctly your problem you don't have to load Master data to ODS in order to activate this. While building the ODS Object just drag and drop some of the infoobjects in to Data fields and Key fields depends on your requirement and activate the ODS Object.

    Thnaks

    sat

  • RELEVANCY SCORE 3.65

    DB:3.65:Getting Short Dump At The Time Of Loading Data From R/3 To Ods zm



    Hi BW Grurus,

    I am trying to load data from R/3 to ODS, but after running for a few minutes it is getting into the short dump and displays the following run time error. So please give me solution how I can load data without getting short dump. I tried thrice but it is giving the same and failed.

    Run time error : TSV_TNEW_PAGE_ALLOC_FAILED

    DB:3.65:Getting Short Dump At The Time Of Loading Data From R/3 To Ods zm


    Hi,

    Check, is start routine or individual routine in present in update/transfer rule?

    May be read large amount data (select * from) another ODS and put into internal table cause these type of error.

    Regards,

    Saran

  • RELEVANCY SCORE 3.64

    DB:3.64:Problem With Deletion Of Request In Ods z1



    Hello frnds,

    We are loading a full load into a ods which update the delta into a cube ,

    As a mistake we have loaded a wrong file to the ODS and the delta is also processed ,

    now i want to delete the request in the ODS , but it s saying the error message like " DElta update in data target should be deactivated before deleting the reqst, Proceed further?"

    I am able the delete the reqst in cube , i have already set QM status of request in ods , still i getting the same message ,

    Any sygesstions on how to handle this ?

    Thanks,

    raky

    DB:3.64:Problem With Deletion Of Request In Ods z1


    If you have a full load to the ODS and a delta to Cube then it is a fairly sinmple issue.

    Just go to the ODS and do the selective deletion on the ODS change log table (Might as well do it for Active table). No need to delete the request. THe request will remain green but since you are doing selective deletion on the change log you do not have to remove the init option.

    Now delete the delta load from the cube.

    Load the ODS with correct data and run your delta to the Cube.

    you are all done

    Cheers

  • RELEVANCY SCORE 3.64

    DB:3.64:Regarding Data Load From Ods To Cube. 7z



    Hello Experts,

    Here is my scenario: I am loading data from ods which has transformation from PSA that is PSA - ODS in 7.0 and

    ODS - Cube in 3.x. Now when i load the data from ODS to cube it is give me an error : Deleteinit. request before running init. again with the same selection. I want to load to the data in init only How can i do that?

    Thanks

    DB:3.64:Regarding Data Load From Ods To Cube. 7z


    go to the infopackage (dso -- cube)

    goto menu 'scheduler' -- initialization options for source system

    and delete the existing initialization

    if you still encounter a problem you can use program RSSM_OLTP_INIT_DELTA_UPDATE to clean up old delta inits

    M.

  • RELEVANCY SCORE 3.63

    DB:3.63:Ods Error: "Extra Records Added While Updating" 1x



    Experts,

    I am loading PO_ITM records from an ODS(datawarehouse layer) to an ODS (Consolidated Layer).

    The scenario is I have individual ODS at datawarehouse layer which get the PO, ITM and SCL data respectively and then I upload from these 3 ODS into the consolidated ODS.

    The key fields in the cons ODS is 0DOC_NUM, 0DOC_ITEM, 0FISCVARNT, 0CALDAY mapped to 0DOC_DATE (From PO_ITM ODS) and 0PROCESSKEY.

    Issue:

    When I load from datawarehouse PO_ITM ODS to this Cons ODS, there is an extra record for a particular record. SAY I have PO 705000006, the no of this record in PO_ITM ODS is 3. When I load this into Cons ODS, I get 4 records.

    See the data below:

    PO_ITM ODS:

    PROCESSKEY DOC_NUM DOC_ITEMFISCVARNT DOC_DATEENTRY_DATE

    1 70500000610N111/05/200711/05/2007

    1 70500000620N111/05/200711/05/2007

    2 70500000610N111/05/200708/28/2008

    In Cons_ODS:

    DOC_NUM DOC_ITEM FISCVARNT CALDAY PROCESSKEY HDRPROCESS RECORDMODE

    0705000006 000010 N1 11/05/2007 001

    0705000006 000010 N1 11/05/2007 002

    0705000006 000010 N1 08/28/2008 002

    0705000006 000020 N1 11/05/2007 001

    Any ideas?

    Thanks,

    Jain

    DB:3.63:Ods Error: "Extra Records Added While Updating" 1x


    If the key fields combination will be new then ODS will add records otherwise it will be updated.

    Sarhan.

  • RELEVANCY SCORE 3.63

    DB:3.63:Error When Loading From Ods To Cube? 9c



    Hi ,

    I am loading data from ODS to cube.The load got failure .The data load from ODS to cube is FULL load.I checked in Error message tab(monitor) I could see three errors.

    Error list:

    1.Error 7 occurred when transferring an IDoc to the Business Information Warehouse.

    2.SQL error in the database when accessing a table. 1

    3.Errors in source system.

    Please help me to resovle this.

    DB:3.63:Error When Loading From Ods To Cube? 9c


    Try to check data through RSA3.

    regards,

    Mahendra

  • RELEVANCY SCORE 3.63

    DB:3.63:Loading Data From Bw3.5 Cube Into Bi7.0 Cube Issue am



    Dear all,

    we are trying to load data from bw3.5 system to bi7.0

    for loading the data from bw3.5 ods to bi 7.0 dso is loading all histrocial data with out issues

    where as loading the data from sap bw3.5 cueb to bi7.0 cube getting loading is error always...

    can any one tell me is there any notes are available for this issue?

    Regards

  • RELEVANCY SCORE 3.62

    DB:3.62:Delete Previous Request cc



    Hello Everyone,

    I have a custom ODS into which i do an init delta and then load delta data everynight. Before loading a new load, i want to delete the earlier request in the ODS.

    Since this is a custom ODS, i can't choose the 'Delete earlier content' option in the 'Data targets' tab of InfoPackage. How do i delete the earlier request for this custom ODS.

    Could someone help me.

    Thanks.

    DB:3.62:Delete Previous Request cc


    That code provided by ukasz Krys , might not work as we cannot compare system date with UTC Timestamp . First we need to convert that UTC Time stamp to a regular system timestamp and then get the date part out of it.

  • RELEVANCY SCORE 3.62

    DB:3.62:Regarding Ods Loading dx



    Master data is loaded into a ODS. I am trying to make two attributes as Navigational Attributes in the ODS it is giving the error like ''Please the check master data '' while I am trying to activate the ODS.

    Could you help me out regarding this?

    Regards,

    Jagadish N

    DB:3.62:Regarding Ods Loading dx


    Hi Jagadish,

    You have to delete master data in infoobjects and ODS. Only after that you'll be able to switch some attributes to navigational ones.

    Best regards,

    Eugene

  • RELEVANCY SCORE 3.62

    DB:3.62:Activation Error For Ods d8



    Hi,

    I am loading a flat file into ODS i.e full load.

    But i am getting an error during activation, Data is found in the New Data but during activation it turns to red.

    Please tell me how to overcome this error?

    Thanks,

    Vijaya

    DB:3.62:Activation Error For Ods d8


    Hi,

    I tried repairing ODS by RSRV transaction but still i am getting the same error.

    what might be the reason and how to solve this problem?

    Thanks,

    Vijaya.

  • RELEVANCY SCORE 3.61

    DB:3.61:Updating Ods jk



    Hello all,

    I need some help regarding updating ODS data.

    If I have a cube that gets data from ODS, from the context menu of the source ODS i select init delta and create a delta for loading IC. where will this infopackage be saved?

    Now do I have to create another package for loading delta data from ODS into cube? if I have to how do I do it?

    How can I delete the init request from the scheduling tab of INIT info package?

    please help me.

    Thanks

    Raj

    DB:3.61:Updating Ods jk


    hi,

    don't forget to come back and award points... =)

    ryan.

  • RELEVANCY SCORE 3.61

    DB:3.61:Ods Problem fx



    Hi Friends

    I have created an ODS and when i try to create a Package for loading its giving me an option Timedependent data

    due to that option the data is not moving into ODS.

    What are the possibilites to get that option in an Infopackage.Are there any specific points to check.

    Regards

    vijay

    DB:3.61:Ods Problem fx


    Hi Friends

    When i check the data Class as transaction and it should be master data.

    Where should i change that to master data.

    Regards

    vijay

  • RELEVANCY SCORE 3.61

    DB:3.61:Delta Update For Zwm_O03 Is Invalidated 17



    Hi guys,

    daily delta is loading from ODS to two data target (ODS, CUBE).

    today it has stuck up and it showing the error message that " delta upadate for the ODS and cube is invalidated.

    when I lokk into the procedure as it shows I must reinitialise the cube and ods.

    can any one give me an suggestion for this issue?

    Thanks

    Ram

    DB:3.61:Delta Update For Zwm_O03 Is Invalidated 17


    hi srini,

    I followed the same procedure ,since one of my colleague suggested what you have mentined, any have the problem was solved.

    Thanks for your valuable suggestion. and assigned full points.

    Thanks

    ram

  • RELEVANCY SCORE 3.60

    DB:3.60:Loading Data Into Infocube Without Loading In Ods While Using Data Mart fa



    Hi all,

    I loaded data from ODS to infocube, then i want to add some more records in infocube. normally when use datamart concept we don't creat any package for the destination target(infocube).

    my question is can i load records directly in Infocube without loading into ODS?

    good answeres are rewarded

    Regards

    Ram

    DB:3.60:Loading Data Into Infocube Without Loading In Ods While Using Data Mart fa


    Hi Sriram,

    It all depends on how many datasources you have ....so many paths of loading you can have.

    If you are in BI 7 . then the loading will be like

    DataSource1infopackage1PSA1Transformation +DTP 1-Target X

    DataSource2infopackage2PSA2Transformation+DTP 2Target X

    DSO--Transformation+DTP 3 --Target X

    So you can have multiple datasources for loading to Target............you will see different transformation folder under your target in RSA1....these contain ...the different DataSources/DSO etc for sending data to the target.

    In your case you will need to create a new datasource,transformation,infopackge, and DTP.

    and you can have any data you wish to add to the cube...in new request.

  • RELEVANCY SCORE 3.60

    DB:3.60:Data Load Into Ods Not Happening In 3.5 cp



    Hi All,

    I am actually trying to update data from flat file into ODS. In the transfer rule I am giving 0recordmode , i update method -- full . creating ODs and saving it . creating update rule for it .

    Now when I am loading, then data is getting loaded into PSA but not into ODS, . The data load is in yellow colour in RSM0 but in the "request" panel it is showing as green . but there is no data in ODS .

    Kindly help me please. I know this is a simple question but please help me , I am new in BW.

  • RELEVANCY SCORE 3.60

    DB:3.60:Activating Ods Data k1



    I am loading data in ODS using pocess chain, do PC will take care of activating the ODS also, or we have to do it manually?

    DB:3.60:Activating Ods Data k1


    SAP BI

    Yes, Process chain will take care of your ODS activation. Please add activation process to your process chain after loading the data.

    Hope this helps

    Thanks

    sat

  • RELEVANCY SCORE 3.60

    DB:3.60:Number Range Object mk



    Hi,

    I am loading data from 2lis_02_hdr into Customized cube aswell as Standard ODS(0pur_c02), while data loading it fails and shows the follwoing error message in monitor screen:bRecord 1 :Error calling number range object 0DOCTYPE for dimension D9 ( )/b

    Please help me out to solve this issue

    Thanks In Advance

    DB:3.60:Number Range Object mk


    hi,

    try transaction rsrv ? all elementry tests master data compare number range and maximum sid execute. press button 'correct error' if any error exists.

    also try all combined tests master data check master data for characteristics.

    hope this helps.

  • RELEVANCY SCORE 3.60

    DB:3.60:Sales Data Load Taking More Time z1



    Hi ,

    I am loading 1 year sales data from setiup tables but it is taking more than 3 years .

    One more thing is no ABAP routines only extraction from r/3 and loading it into ODS ....

    Is there any i can speed to load the data into ODS .

    Please any can help me

  • RELEVANCY SCORE 3.60

    DB:3.60:Data Load From Ods To ds



    A basic question, I am working on a BI7 system but using the 3.5 BC objects for loading purchasing data.

    data source 2LIS_02_ITM

    - Transfer rule

    - infosource

    - update rule

    - 0PUR_O01

    - update rule

    - 0PUR_O02

    from the info package when i schedule the load immidiately (init with data) the data is successfuly loaded into the first ODS 0PUR_O01 but dosen't load into the second ODS 0PUR_O02

    How to do this?

    DB:3.60:Data Load From Ods To ds


    1.yes i still use 3.5 update and trasnfer rules (we have proposed phased migration approach to use transformation etc)

    2.That is fine, just activate what is required, in this case it will be the rules correcponding to _itm

    3. I activated the rules from BC ("In Data Flow before" ).

    4.yes i am using LO Cockpit

  • RELEVANCY SCORE 3.60

    DB:3.60:Steps For Loading Data In Ods p7



    Hi

    I am working on BW 3.5, I need to load data from a table into an ODS. tables are in the BW system the Update rule is also active. Now I need to know what will be the steps to load data into ODS

    Thanks in advence

  • RELEVANCY SCORE 3.60

    DB:3.60:Ods Object cd


    Can any one tell what are the tables created internally when loading data in to ods object

    DB:3.60:Ods Object cd

    Hi,Actually the way of handling of ODS is changed from 3.0B.So then onwards we can see 4 important tables for any ODS.1) "New data" table: /BIC/AODS40Data comes to hear first of all at the data loading.2) "Active" Table: /BIC/AODS00Data will be available after activation. Query takes the data from here. And further Data targets.3) "Roll Back " Table : /BIC/AODS50This si used at the time of activation .4) "Change log" table: /BIC/B*This is used to store the changes and is used for further uploads.With rgds,Anil Kumar Sharma .P

  • RELEVANCY SCORE 3.59

    DB:3.59:Loading Data Directly To Ods Without Psa In Bi 7 jx



    Hi All ,

    I have a cube ODS in BW3.x and every day i am loading 3 million (Full Load) into ODS and Delta to Cube and the entire process is taking 1 Hr to complete .

    Now i have migrated the datasource , created DTP from PSA to ODS and one more DTP from ODS to Cube .

    My Question is :

    in BI7 i need to load data from source to PSA , PSA to ODS and ODS to Cube .

    From source to PSA it is taking 45 min and PSA to ODS it is taking 1 HR . because of this my loading time has increased

    drastically .

    Now i am trying to bypass the PSA load and trying to load direclty from source to ODS.When i tried to load from source to ODS by DTP i am getting this error

    'Message in Source System: E224(/SAPAPO/TSM) ...'

    Did anybody worked on the PSA by pass if so can give some inputs .

    Thanks

    santosh Utla

    DB:3.59:Loading Data Directly To Ods Without Psa In Bi 7 jx


    Hi,

    Go to DTP Select Extraction Mode Full, Increase the Package Size Up to the Records you are Getting On Daily Basis.

    Mean If You are getting 1Lakh Record Per day then Make it 1.25 Lakh. Check the Option " Do Not Select From PSA but Acess DataSource"

    Execute the same.

    Hope this wont give any error as i too have done this succeed.

    Regards,

    sandeep

  • RELEVANCY SCORE 3.59

    DB:3.59:Error While Loading Data To Ods In Bi7 s7



    Getting such following errors when loading data to ODS through DTP(Data Transfer Process) in BI7.

    Runtime error while executing rule - see long text RSTRAN

    Record filtered because records with the same key contain errorsRSM2

    and many so on...

    source system is ok no problem with the connection part.

    plz help.

    DB:3.59:Error While Loading Data To Ods In Bi7 s7


    uncheck the setting in your DSO for unique records.

    Your loads will not happen because the data is already there in the DSO for this customer and activity combination. Now when u try to reload the same customer and activity data,it would not allow as this data is not unique and is already present. Hence it cannot be overwritten. When u switch off the unique records property, you would still get your data in the DSO for this customer and activity combination, and your key figures would behave depending on the property set,overwrite or additive.

  • RELEVANCY SCORE 3.58

    DB:3.58:Urgent - Error When Loading Data Thru Data Mart aa



    I have a ODS which is loaded through a data mart. Now while loading the first 8 data packages are loaded correctly into the ODS, but on the ninth one we get a error. And after this the following data packages are uploaded correctly.

    The error shows that it has occured after the update rules. This same data package is loaded correctly into the PSA.

    There is no error mesaage ID and the short dump too doesn't say anything - just says MESSAGE_TYPE_X.

    Points assigned for helpful answers

    DB:3.58:Urgent - Error When Loading Data Thru Data Mart aa


    Hi,

    We had the same error but not sure how to proceed, can you please help, with a step by step approach.

    Thanks,

    Madhavi

  • RELEVANCY SCORE 3.58

    DB:3.58:Short Dump Loading Data To Ods cd



    Hi Gurus,

    Our BW system has just been upgaraded to BI7.

    Now for the first time we are loading the data into the ODS.

    While loading the data into ODS from flat file we are getting the short dump as MESSAGE_TYPE_X...

    I searched a lot on sdn regarding this but couldnot find the solution. Please help.....

    And when i am pushing the data from ODS to cube then, firstly it takes a long time to turn into red. It remains in yellow for very longer period.

    After that it shows the error in detail tab as :

    Data Package 1 : arrived in BW ; Processing : Data packet not yet processed

    Points will be assigned.

  • RELEVANCY SCORE 3.57

    DB:3.57:Error Handling In An Ods kx


    Our data load into our Billing conditions ODS failed last night in our bw production system. It failed because a bad date was entered in our R3 system and that data tried to load into our ODS. The bad date was entered for 0CALDAY and had a value of '00060828'. There are several records with this incorrect date. Our error handling options in the infopackage are limited because we are loading into an ODS. Any suggestions?Thanks!

    DB:3.57:Error Handling In An Ods kx

    We have had this same problem before. What we did to solve this issue is to check the date in the update rules. If the date is invalid or outside of the fiscal variant, then change it to a valid date (let's say sy-datum). In your R/3 system, you will eventually get the correct date. Some processes in R/3 allow the user to enter an invalid date then, later, the correct date can be updated.As part of our checking, when we make this change programatically, we send an email to our support group notifying them of the billing document number in which the date was "changed" by our update rules. This way, someone can go in later, correct the date and it will flow back to us with no problems!This way really works nicely as it allows your processes to continue as designed, but notifies support of possible inconsistancies in the data before users identify them..Let me know if you need any sample code./smw

  • RELEVANCY SCORE 3.57

    DB:3.57:Ods Data Activation am



    Hi experts,

    I'm loading data from a CSV flat file into a ODS object (BW 3.5 system).

    Yesterday it was working just fine, today I get the following error: Value '00000000' of characteristic 0DATE is not plausible

    Message no. BRAIN027 when activating the loaded data.

    Please help, I have exhausted all my ideas...

    Thanks,

    Andreea

    DB:3.57:Ods Data Activation am


    Hi Tom,

    I did something like this. I cannot modify the CSV file because it's on the application server but I did the change in the update rules and it works fine. I just didn't have time to place the answer on sdn.

    many thanks!

    Andreea

  • RELEVANCY SCORE 3.57

    DB:3.57:Ods Delta Daily Load And Cube 3 Tmes Per Week Load m7



    Hi ,

    I am loading delta goods movement data from R/3 into ODS on daily basis (DELTA) and loading from ODS into CUBE 3 times per week .

    My questions is :

    Ex: Tues delta load into ODS with request : REQ1

    Wednes day delta lado into ODS with REQUEST REQ2.

    Wednes day planning to delta load into CUBE (REQ1,REQ2).

    Will REQ1,REQ2(both the requests) load into cube on wednes day from ODS ?OR only latest request REQ2 from ODS load into cube ?.

    please can any body help me

  • RELEVANCY SCORE 3.57

    DB:3.57:Error :Ods Object Activation Sid Changed; From 37777 To 37779 kk



    Hi sdn,

    Please give me your valuable help sooooooon.

    I am trying to load masterdata to ods with new entries with new info package. After loading masterdata new entries into ods i have to load transaction data from R/3 to cube,

    But when i am loading new entries to ods through flat file i am getting an error message saying " ODS object activation SID changed; from 37777 to 37779" And when i click on execute changes request is coming with green light.

    Then i tried to load transaction data from R/3 to cube but the load got failed n at the same time masterdata ods request is also getting turned into red.

    But before changing the masterdata ods i am able load the transaction data successfully. But its very important to add the new entries to masterdata ods before loading transaction data.

    Please give me step by step procedure and full points will be assigned to the exact solution given.

    DB:3.57:Error :Ods Object Activation Sid Changed; From 37777 To 37779 kk


    Hi everybody,

    With all your previous discussions i was able to solve the issue.

    Thanks alot

  • RELEVANCY SCORE 3.57

    DB:3.57:Load Failed From Ods To Ods And Ods To Infocube mk



    Hi Friends,

    I am new to sdn.How to rectify when the load fails when loading data from ODS to ODS and ODS to Infocube and pls explain when it is Full load how can we rectify and when it is Delta load how can we rectify?

    Regards,

    Bhavani

    DB:3.57:Load Failed From Ods To Ods And Ods To Infocube mk


    Data mart deletions comes in to picture only for delta loads..with in BW system( It might be ODS to ODS or ODS to CUBE)....

    It depends on the failure reason... if u have PSA in between u can rectify the error in PSA itself and load it from PSA to target....

    You can find a lot of scenarios by searching forum

    Regards,

    B

  • RELEVANCY SCORE 3.57

    DB:3.57:Process Chain Error In Loading Ods ka



    i got a process chain error in ODS loading. I deleted the "not activated requests". but one of them was in green status. i set it to red status. then i triggerered the chain.

    but it was loading the data in delta mode after image.

    would there be a loss of data problem?

    DB:3.57:Process Chain Error In Loading Ods ka


    ithink there will not be any probelm beacuse u have deleted the old request and repeated the chain ,actually while loading the data from delta queue it will bring bothe new dlta and old repeat delta also ,

  • RELEVANCY SCORE 3.57

    DB:3.57:Ods To Cube kx



    hi

    what is the advantage of loading data into CUBE from ODS , instead of directly loading data to cube..

    I know the procedure.. that how to transfer the data from ODS to CUBE.. but i want the exact situation... where we are using both ODS and CUBE.. and why we need to transfer the data from ODS to CUBE..

    thanks in advance

    prakash

    DB:3.57:Ods To Cube kx


    Hi Prakash,

    You can directly load the data into infocube but It is always best practice to use ODS before infocube(In most scenarios).

    ODS is useful for detailed reporting (Data granularity).

    We can store all the consolidated and cleansed data in ODS level and update to cubes, if you have requirement of deleting data from infocube, then you can delete the data from infocube and reload the data from ODS without extracting data from source system.

    Some datasources (example: 0FI_GL_4, 0FI_AP_4, 0FI_AR_4 ) use an After Image delta so this delta method is not suitable for direct InfoCube update, in this scenario,ODS object is obligatory to determine the delta for InfoCube update

    There is a lot on EDW. Check here:

    https://www.sdn.sap.com/irj/sdn/docs?rid=/webcontent/uuid/e1859e4e-0a01-0010-c099-c247943aef37 [original link is broken]

    Hope it helps.

    Best Regards,

    VK.Siddu

  • RELEVANCY SCORE 3.56

    DB:3.56:Why Is Psa Ods Nessasary fa



    hello experts

    iam a fresher in BW.Why is PSA and ODS necessary for loading data into the cube.

    plz provide me the answer in simple words.

    thank u.

    vijay

    DB:3.56:Why Is Psa Ods Nessasary fa


    Hi Vijay,

    There is no compulsion that you need to load either the ODS or the PSA before loading the Cube. You can directly load a cube without using either of them.

    PSA - This is staging area which has the data in the same format as the source system with no data transformations. It is useful to correct the data, compare to check if all the data from the source system has come in and very useful to reconstruct the data in the Data Target. You cannot report on PSA data directly.

    ODS - It is a Data Target like the cube but it is not multi-dimensional like the cube. It stores data like a table - flat structure.

    Bye

    Dinesh

  • RELEVANCY SCORE 3.56

    DB:3.56:Error Message Whiled Loading Ods mf



    I am trying to load transaction data into an ODS. But at the package level itself i get this error...

    How do i make sense of this? Any help would be appreciated.

    Syntax error in GP_ERR_RSDRO_UPDATE, row 1.619 (- long text)

    Message no. RG102

    Diagnosis

    The data object "E_S_AFTER_CHG" does not have a component called "DOC_CURRCY".

    Thanks

    SAN

    DB:3.56:Error Message Whiled Loading Ods mf


    i have 0doc_currcy in my infosource. key figure zamount refers to 0doc_curcy. I get this error when i try to laod data from the standard DS 0CO_9 into ZODS.

    Thanks

  • RELEVANCY SCORE 3.56

    DB:3.56:Initialization Problem ps



    I am doing Initialization(w/o data transfer) into ods but when I try to activate the ods after loading I am getting the error "Full updates already available in ODS ZSD_O01; Cannot update init./delta" and there are full loads (marked as full repair) and delta loads in the manage screen.

    plz guide me.

    thanks

    Message was edited by:

    sudeer kumar

    DB:3.56:Initialization Problem ps


    I have this same problem. The wording in the note scares me - does the delta queue have to be empty to do this? Here is our situation (we are on 3.5):

    It is now 2008 at our client.

    We have completed a full load of all prior years and 2008 period 0 (from R/3 to an ODS). There are postings in period 1 2008, none of which have been extracted yet. Can I set the fulls to full repairs, run an init with no data and then have deltas bring in period 1 and anything that happens from then on?

  • RELEVANCY SCORE 3.56

    DB:3.56:Error While Loading Data From Ods To Ods 77



    Hi Experts,

    When i'm loading the data from ods to further ods, i'm facing an error while activating the data saying that 0ref_doc_no consists of invalid characters.Also it is saying that Error when assigning SID.

    I'm unable to see the long text for further information.

    Regards,

    Vijay

  • RELEVANCY SCORE 3.56

    DB:3.56:Error When I Am Loading Data From Psa To Ods ks



    hai Gurus

    Very good morning

    Actually i am loading data from PSA to ODS.

    But when i am loading data i am getting the error InfoObject/BIC/0REFER_DOC does not contain ALPHA -CONFORMING VALUE 0.

    Can anybody help me to solve the problem and reload the data

    Thanks Regards

    Jayavardhan

    DB:3.56:Error When I Am Loading Data From Psa To Ods ks


    Hi,

    Lacs of postings are there in this forum on this topic. Searching teh forum is the best option for u now.

    With rgds,

    Anil Kumar Sharma .P

  • RELEVANCY SCORE 3.56

    DB:3.56:Ods Error z1



    hi

    please can any body tell that i am loading the data for ods. till yasterday it was ok the problem is that till ods loading is ok but when the time of loading till ods to infocube it is giving an error i.e call_fuction_accept_failed and call_fuction_send_error

    please reply as soon as possible

    thanks

    gurkiran

    DB:3.56:Ods Error z1


    Are you loading using a DTP / Transformation or using an infopackage ??

    Arun

  • RELEVANCY SCORE 3.56

    DB:3.56:System Error Occured Rfc Call While Loading s8



    Hi Guys,

    while loading the data to ODS i got below error message ,

    *System error occured RFC call

    *Task 0083 for parallel SID assignment terminated with errors

    *Activation of data records from ODS object 0RSL_DS01 terminated

    *Error getting SID for ODS object 0RSL_DS01

    Can plz suggest wat to do?

    DB:3.56:System Error Occured Rfc Call While Loading s8


    Hi

    Just have a check if the RFC connectuion is fine...you can check it in this way -

    Go to RSA1 source systemright click on the source system form which you are extracting data.-- CHECK

    You will get a error if connection in not in place.. See the Reson of Connection failure.

    You may need to to contact Basis people to reestabilish the connection.

    Get back to me in case of any issues.

    Nandita.