Request is running yellow with 0 records

hi insource i have 14 records, i am running infopackge load to psa? i loaded immediately, its showing yellopw with 0-0 records. i deleted request and run again i am facing same problem what could be the reason

Hi Suneel..........
U hav checked the extraction job?................it is in released state..................right......
Hav u checked the RFC connection(SM59).............is it ok........
If still it is released state..............as already mentioned.................load at this time in ur system is huge................due to this there are no free work process...............u can try to change the server and then run the load....................Go to SM66...........there check which servers are showing in Waiting state............that means loads are not much in those servers..................then go to SM51.............double click on the desired server...............then in the top where we write tcode.........there write /n........................a new session will open...................now u r in the new server..........here again execute the load.....................it may progress here............but be careful.............since already one job is in schedule state.............after some time it may become active...........at that time u hav to cancel the job.................otherwise load will fail due to lock issue................
Regards,
Debjani.........

Similar Messages

Hi,
In monotoring screen select 0 From 0 and in the main menu Enivironment--> Job overview --> In the source system then It will go to ECC side there check ur job status in R/3. If the job is continuing then check SM58 in R/3 is there any IDOC's strucked.
Regards,
Sharma. IVN

Hello, After some problems with update queues in R/3, we have some update records in yellow status "Error in collective run" in sm13 t-code. If we run collective run, new records are pushed into rsa7, but this yellow status records won't move, and we actually need them. Does anyone know how to process this errors?

Hi,
There is no problem with background process, the new update records are being processed with no problem.
These update records remain in yellow status since yesterday, but new records are being processed.

I just installed CRM 7.0 on Windows with MaxDB 7.7.04 build 28. After the installation I was able to logon and begin applying support packs. In the middle of doing this, the system hung and I noticed the disp+work went yellow with the message "Running but dialog queue standstill". I shut down the system, rebooted the machine and started up again. The same error is occuring. Here are some log files: adatmp: Error! Connection failed to node sitaserv23 for database CRE: -24700,ERR_DBMSRV_NOSTART: Could not start DBM server. -24832,ERR_SHMNOTAVAILABLE: Shared memory not available -24827,ERR_SHMALLOCFAILED: ID C:\sapdb\data\wrk\CRE.dbm.shi, requested size 2600 stderr1: C:\usr\sap\CRE\DVEBMGS02\work>set DBNAME=CRE C:\usr\sap\CRE\DVEBMGS02\work>set DBNAME=CRE C:\usr\sap\CRE\DVEBMGS02\work>if "" == "" (set DB_USERKEY="c" ) else (set DB_USERKEY="c_J2EE" ) C:\usr\sap\CRE\DVEBMGS02\work>dbmcli -U "c" db_state 1>adatmp C:\usr\sap\CRE\DVEBMGS02\work>findstr "ONLINE" adatmp C:\usr\sap\CRE\DVEBMGS02\work>dbmcli -U "c" dbm_version VERSION 1>adatmp C:\usr\sap\CRE\DVEBMGS02\work>findstr "7\.2" adatmp C:\usr\sap\CRE\DVEBMGS02\work>findstr "7\.3" adatmp C:\usr\sap\CRE\DVEBMGS02\work>findstr "7\.4" adatmp C:\usr\sap\CRE\DVEBMGS02\work>findstr "7\.5" adatmp C:\usr\sap\CRE\DVEBMGS02\work>findstr "7\.6" adatmp C:\usr\sap\CRE\DVEBMGS02\work>findstr "7\.7" adatmp Error: Database CRE NOT started ! I tried applying note 1041650 but this seems to be for UNIX. I don't know how to clear memory in Windows 2003 server. I updated the kernel to 117 with disp+work at 130. Still the same. Please help. Thanks, Peggy

Here is the result
db_state
OK
ONLINE
x_cons <SID> sh ac
SERVERDB: CRE
ID UKT Win TASK APPL Current Timeout Region Wait
tid type pid state priority cnt try item
T113 8 0x8F0 User 956 LOG FULL (246) ! 0 0 11514(s)
So I can see that it is full. What can I do to increase the size and/or turn off logging?
Thanks!

I just installed CRM 7.0 on Windows with MaxDB 7.7.04 build 28. After the installation I was able to logon and begin applying support packs. In the middle of doing this, the system hung and I noticed the disp+work went yellow with the message "Running but dialog queue standstill". I shut down the system, rebooted the machine and started up again. The same error is occuring. Here are some log files: adatmp: Error! Connection failed to node sitaserv23 for database CRE: -24700,ERR_DBMSRV_NOSTART: Could not start DBM server. -24832,ERR_SHMNOTAVAILABLE: Shared memory not available -24827,ERR_SHMALLOCFAILED: ID C:\sapdb\data\wrk\CRE.dbm.shi, requested size 2600 stderr1: C:\usr\sap\CRE\DVEBMGS02\work>set DBNAME=CRE C:\usr\sap\CRE\DVEBMGS02\work>set DBNAME=CRE C:\usr\sap\CRE\DVEBMGS02\work>if "" == "" (set DB_USERKEY="c" ) else (set DB_USERKEY="c_J2EE" ) C:\usr\sap\CRE\DVEBMGS02\work>dbmcli -U "c" db_state 1>adatmp C:\usr\sap\CRE\DVEBMGS02\work>findstr "ONLINE" adatmp C:\usr\sap\CRE\DVEBMGS02\work>dbmcli -U "c" dbm_version VERSION 1>adatmp C:\usr\sap\CRE\DVEBMGS02\work>findstr "7\.2" adatmp C:\usr\sap\CRE\DVEBMGS02\work>findstr "7\.3" adatmp C:\usr\sap\CRE\DVEBMGS02\work>findstr "7\.4" adatmp C:\usr\sap\CRE\DVEBMGS02\work>findstr "7\.5" adatmp C:\usr\sap\CRE\DVEBMGS02\work>findstr "7\.6" adatmp C:\usr\sap\CRE\DVEBMGS02\work>findstr "7\.7" adatmp Error: Database CRE NOT started ! I tried applying note 1041650 but this seems to be for UNIX. I don't know how to clear memory in Windows 2003 server. I updated the kernel to 117 with disp+work at 130. Still the same. Please help. Thanks, Peggy

Hi,
Its better to put log archive in over write mode while installation to avoid these issues.
Regards,
Sahil Garg

Hi Experts, I'm working on EHP1[BI 7.01] and trying to load the data from R/3 system with generic data source. The records are updated in PSA[data source] and which is showing "12:25:21 ( 15 From 0 Records ) " and with yellow status with the below information. Request still running Diagnosis No errors found. The current process has probably not finished yet. System Response The ALE inbox of BI is identical to the ALE outbox of the source system or the maximum wait time for this request has not yet been exceeded or the background job has not yet finished in the source system. Current status No Idocs arrived from the source system. I checked different threads relating to this issue with different solutions like checking WE20, BD87, tRFC etc., but still i'm unable to resolve this. This is very urgent issue could anyone please help me in resolving this issue.. Thanks & Regards, Amarnath

I mean.. Once u press Source system.. it will ask u for the ID and PWD.. once u give that.. it will ask for the data range .. by default it will be todays date as ur has started today only.... and then execute...
it will take u to SM58 screen.. there u just see the status of the different IDOC entries... if u can see the Executed as status then u can press F6 to push it to BW..
If u see the status as Executing then u need to wait as the operation is still running....
.. In practive if u feel that this load is taking long time compared to the actual.. then u can go ahead with the the repeat of the load by killing the present load in the source system.. and removing the bad req from the ur target..
thanks
Hope this helps.

Hi We got the problem when loading the 2LIS_03_BF data into cube. We have around 4 cubes and 2 ods. The data got loaded into all the cubes and ods except on Cube. There was a problem of table space and now it is solved. Now the request is in yellow status in PSA. It cube it shows no of records added and transferred but the status is in red color. How can i upload the delta data into the cube from PSA when PSA request is in yellow color. I feel strange that when the request is in yellow color how come the data is loaded into all other cubes. REgards Annie

You should be able to load request from PSA to data target using the option available in PSA. When you manage on Datasource, you see all requests. You can select that PSA request and use Scheduler option in that screen to update that particular request. It will run infopackage as usual. It will execute all the routines if there are any in update rules.
When you say you have some programs running in process chain, they must be after this failed load right?
If that is the case, all you need to do is push process chain further. Below are steps to push process chain further if you any step is stuck in yellow or if mually carry out any red step in process chain. In you case, load that failed step manually using scheduler form PSA manage tab and then push PC further using these steps. That will continue PC further and run any programs that run after load.
Execute in SE38 -> RSPC_PROCESS_FINISH
Fill the following parameters on screen and rest all can be left blank.
1. LOGID - you will find this when you do monitor of your process chain. Every time you run process chain, unique LOGID is created.
2. TYPE - If step is ODS activation then TYPE wud be ODSACTIVAT and if it is infopak loading TYPE wud be LOADING and if it is DTP Load TYPE wud be LOAD. In your case it will be LOADING.
3. VARIANT - In the process chain monitor mode, right click on step which you executed manually -> Display Messages. Go to chain tab and there you will find VARIANT
4. INSTANCE - In the process chain monitor mode, right click on step which you executed manually -> Display Messages. Go to chain tab and there you will find INSTANCE
5. STATE - Value wud be G
After entering above parameters, click execute. It will be done in fraction of second and wont give any popup. Now when you will check process chain monitor, you will see that step 4 is green and next step has started executing.
Abhijit

While extracting the data from r/3 to bi, of payroll data source by filtering months in infopackage, the records are coming but the request is in yellow. the error message is 1. No assignment of payroll data to BW month for country grouping Message no. HR_BW_PY99026 so i did Choose: R/3 Customizing Implementation Guide -> Integration with Other SAP Components -> Business Information Warehouse -> Settings for Application-Specific DataSources -> Human Resources -> Assigning Payroll Data to a BW Month. according to the message error aolution and forums , i havent got solution plz advice me........ thank you

hi
Thank you,
from the functional team, Country grouping is only for 40 not for others. if i enter other country groups which were displayed in application log which are not there in payroll data to bw month. then it displays and shows remaining logs which are already present but i forget to mention in the post. they are
*DataSource 0HR_PY_1 does not support CE results (employee 00100920) *
OR
if i make it green , still the logs will present . is there any problem in future?

Hi Expert, I did extract data for SAP HR Recruitment from source system (SAP R/3) to Cube in BW 7.0, when I ran the InfoPackage, the message always with status "Request still running" (detail message --> missing message: Number of send message) until few hours, no data extracted to PSA. But the problem only in 0APPLICANT (text and attributes) datasource, no problem found in the others Recruitment datasources. I've to DataSource replication, delete/re-create infopackage, re-arrange transformation. And I've check source system using RSA3 and Applicant data available in the source system. I've check using SM50, the process always running but never finish (status always Yellow). Is there any solution for this problem ? Regards, Tri Wicaksono

Hi....
Have you checked the extraction job in the Source System ...........copy the request number ......go to the source system...........SM37......put *REQXXXXXXX........check whether the Job got completed or not.....
Also , In the IP Monitor screen....in the Menu Bar ---> Settings --> Evaluation of requests (Traffic Lights) --> For the option " If no data is available in the system the request "......you should select "Status Successful".....by default it will be "Status Successful" only...until and unless someone change it manually....
Also check for short dump and TRFC..........in both source system and data ware house.........in the Menu Bar --> Environment.......there you will get all the options....
To check the Short Dumps.........you have search for the Request Number.....if it is there it means load went to short dump........
If TRFCs are stucj press F6 to push it........
After that also if it doesn't progress....it means it went to dump.....then change the stsus to red manually and repeat the load......
Regards,
Debjani.....

Dear all, I am working on BI 7.0 and I need to load data from a Real-Time Cube (in planning mode) to a Standard Cube. I am using a Process Chain with a program which calls function module RSAPO_CLOSE_TRANS_REQUEST providing the technical name of the Real-Time cube to this function module. I see that this function module works in general, because afterwards I see the number of data records transferred and added appearing in the data request. However, the status of the data request is still yellow. In order to load the data from this cube to another it has to be in green. It is not acceptable to do this manually, it has to be automated. Data entry on the Planning Cube is via a BI-IP Query. The data arrives correctly in the cube, when checking the InfoCube content the data appears to be fine. I have used this function module in many projects without such a problem. Does anyone have an idea why the data request is not set in green status? I have also tried to use the function modules RSAPO_SWITCH_TRANS_TO_BATCH and RSAPO_SWITCH_BATCH_TO_TRANS to convert from Planning mode to normal mode and then back from normal to planning mode. The result is the same, data request remains yellow. Many thanks for your help Claas

Thanks Rishi,
I have tried this with the standard Process Chain steps to switch the mode, but the issue remains. It first switches the Cube to Load-Mode, I see data records in the request being added to the cube, the next step tries to switch the cube back into Planning mode, This step now gives an error because the data request is in yellow status, so the cube cannot be switched back to planning.
Error Message:
Request APO_R4EX2HO4TYDLBCNQPQY82K8ZOJ(0000020181) is yellow or red in InfoCube DRI_P301; cannot switch to planning
Message no. RSM068
The Problem is that after the Cube was switched to Load-mode the request is still yellow.
I do not understand why data records get added to the cube but the request does not get turned into green status. Any more ideas?
Cheers
Claas
Edited by: Claas Bartels on Aug 29, 2009 10:29 PM

Subject: VSTS loadtest error while running Loadtest with Runsettings as No of test iterations , ERROR is : could not read result repository: unknown transaction id in results: Hello All, I am facing the following error while running a loadtest (when i choose the scenario to be executed for No of test iterations). But the same loadtest with the Run duration for X minutes is running fine without any issues. Any suggestions on the issue i am facing error is : could not read result repository: unknown transaction id in results: or could not read result repository: unknown request id in results: Thanks Satish

Hi Kotapati,
>>Subject: VSTS loadtest error while running Loadtest with Runsettings as No of test iterations , ERROR is : could not read result repository: unknown transaction
id in results:
According to your description, you mean that when you run your load test using the Test Iterations way and then get the error message, am I right?
If yes, please you try to close the VS, and then open this VS again. Then clean your load test project/solution and then re-build it, run your load test again check this issue again.
In addition, I suggest you could try to create a new load test and then run it using Test Iterations way check if you get the issue for the specified load test or all load tests.
If possible, I suggest you could share me simple load test for us so that we will further help you.
You could upload your load test to OneDrive and then copy link here.
Best Regards,
We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click
HERE to participate the survey.

Hi all, In My Solution Manager system, In the MMC, the dispatcher stays yellow, with the status 'Dialog Queue Info unavailable'. However, the system continues to run. Can you please help on this. Thanks suman

Post Author: Ann2 CA Forum: Formula Here is the data sample: ID period code date 1 00 I 01/01/1999 1 00 Z 01/02/1999 1 00 G 12/05/1999 1 00 M 01/01/2000 There are many students with many periods and many codes. I need to save a date when code = 'G' and count separateley records per student/period 2 times - before and equal that date and after that date, so in the end for period 00 I will have 2 values: 3 (before) and 1(after). There are periods from 00 to 08. I am counting students abscencies before and after warning letter was sent (code G). The result data should look : 00 01 02 03 04 05 06 07 08 00 01 02 03 04 05 06 07 08 Total 3 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 4 Please help me. Thank you. Ann2

Post Author: Ann2
CA Forum: Formula
Thank you for your answer, but I do care about the date the 'G' happened, because I need to reset count.
The logic behind is this:if a student absent for more than 8 times per period - the letter will be sent out to the parents , that will be code 'G' with period '-1' (it may happen that there will never be code 'G' , but I need to track all absencies). Once the letter is sent, the count starts over (the count starts over the next day after code 'G'). The absencies which happened before or the date the letter sent should count toward 'previous' abscenices, all other - absenices after the letter.
So basically I need total per period and total per period before or the day with code 'G'. Running total with reset with formula code = 'G' does not work.
I created a formula field which has global date (when code 'G' happenned) and it says if globaldate >= periodDate then date (1900,01,01) else (2100,01,01) and that formula is ok, but I can not use it in running total or can not create group on it and insert total.
Please help me with this. Thank you.
Ann2

Hi all, I'm trying to take voltage/current/resistance measurements from a Keithely sourcemeter and plot them on charts. There's also the option to record the measurements upon pressing the "record" button, which then would prompt the user for a path name. After the 'record' button is pressed again, the file is saved and closed. During the entire process of openning file, recording, and closing the file, the measurements should be plotted onto the charts uninterrupted. I've used a state machine pattern, with the value of the 'record' button as input to decide the state transitions, used in a "select" gate. However, when I run the VI, the state transitions never happens, pausing the execution and probing the value of the button yields that its output stays the same regardless of the state of the button. I've set the operation of the button to "switch when pressed". I know this is a common task, but I'm pretty stumped about how to fix this. The VI file is attached, any pointer is appreciated. Thanks Solved! Go to Solution. Attachments: read_current_save.vi ‏36 KB

The typedef enum will solve the problem of the names. Once all sources (controls or constants) connected to the state wire in every case and outside the loop are all copies of the same typedef, the names will return.
What happened was that you changed one of the enums or created a new one. It had a different data type. Yes, it was still an enum and still produced a U16 integer, but because the items in it were different, it was considered a different data type. When two different data types are connected to the wire going to the selector terminal, the case structure attempts to find the common "denominator", in this case a U16 integer, but not the enum.
I converted the enum constant you had with "record" and other values to a type def and copied it several times. When I replaced all the other state enums with that type def enum, the names came back.
Lynn

hi all, i am encountering a strange issue. i m trying to post transaction FBRA (Reset cleared items). when i run the transaction normally, supplying the doc. no. , comp code and fiscal year...i click on save and a popup message comes up which asks to either only reset the documents or to reverse them as well...no issues so far... the issue however comes when i try and record this transaction....there is no pop up at all...?? why so?? although i went in the code and found out the screen no. and okcode value to code my bdc but i would like to know why such sort of a thing would occur....as per my knowledge...this cannot be a limitation with recorder...or is it? any knowledge sharing will be appreciated...

Is this popup to get some kind of Profile?
I'm thinking that this is your problem, I did a search in that program for SY-BINPT , this is a system value which is set to "X" when in Batch Input or BDC mode. I think that this is why you are not getting your popup.
IF NOT ls_message IS INITIAL
<b>AND SY-BINPT = SPACE</b>.
CALL FUNCTION 'BAL_DSP_PROFILE_POPUP_GET'
IMPORTING
e_s_display_profile = ls_display_profile.
ls_display_profile-use_grid = 'X'.
CALL FUNCTION 'BAL_DSP_LOG_DISPLAY'
EXPORTING
i_s_display_profile = ls_display_profile
EXCEPTIONS
profile_inconsistent = 1
internal_error = 2
no_data_available = 3
no_authority = 4
OTHERS = 5
IF sy-subrc <> 0.
MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno
WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.
ENDIF.
CALL FUNCTION 'BAL_LOG_REFRESH'
EXPORTING
i_log_handle = ls_handle.
ENDIF.
Regards,
Rich Heilman

I am so angry at messages because when i am trying to sign in, they want my email adress. when i put my email adress it says unable to verify adress. an email with a verification link has been sent to the above email adress. I did that like over a bi

When I connect my iPod touch to any computer I get a pop up bubble saying USB device not recognized. I have uninstalled my drivers and re-installed them. I have reset my iPod at least 7 times and I have also erased everything and reset it to factory

Everytime I go to work with the music folder, within the itunes folder, it causes the spinning colorwheel to come up and I need to force quit to get out of the program. When this happens a noise starts within the computer as well, sort of like a sque