Backend BW table for reject counts in datamanager packages

[Former Member]

Hello Team,

I am not able to find the backend BW table for the logs of the data manager package which can tell about the rejected records count or sucessful records count.

I got all other information about the datamanager package form the table UJD_STATUS except records counts.

So can anyone please help me out to find the rejected records/sucessful records count in the backend BW table

I got 1 tableUJF_DOC but it is also not giving me the information which i want.

Thanks & Regards

Ronit Kumar

[former_member186338 · Accepted solution]

Hi Rohit,

No tables but log files in UJFS... in the main log you will find the link to the rejected records log.

Vadim

[former_member186338 · Accepted solution]

Something like:

In UJD_STATUS for some record in the field LOG_FILE you will have:

Clear20150209150549_DJEGACHWJI3FV62YUSBQ7LLVS.LOG

with

USER_ID: V.KALININ

APPSET_ID: SIM

APPLICATION_ID: INFILE

In UJFS:

\root\webfolders\sim\infile\privatepublications\v.kalinin\tempfiles\

we can see the file: Clear20150209150549_DJEGACHWJI3FV62YUSBQ7LLVS.LOG

In this file:

<RESULT><PROMPT><![CDATA[%SELECTION%    /SIM/INFILE/PRIVATEPUBLICATIONS/V.KALININ/TempFiles/FROM.TMP@@@SAVE@@@@@@EXPAND@@@|DIMENSION:BE||DIMENSION:PERIODS|

%SELECTION_KEYDATE%    ]]></PROMPT><STATUS_STEP><![CDATA[/CPMB/MODIFY completed in 0 seconds

/CPMB/CLEAR_COMMENTS_FOR_CLEAR completed in 2 seconds

/CPMB/CLEAR_CUBE completed in 663 seconds

/CPMB/CLEAR completed in 0 seconds]]></STATUS_STEP><REJECTRECORD><![CDATA[Clearreject_record20150209150549_DJEGACHWJI3FV62YUSBQ7LLVS.txt]]></REJECTRECORD><REJECTFILE><![CDATA[Clearreject_data20150209150549_DJEGACHWJI3FV62YUSBQ7LLVS.txt]]></REJECTFILE><MESSAGE><![CDATA[Task name CLEAR CUBE DATA:

Submit count: 1831713

Reject count: 2

model: INFILE. Package status: WARNING]]></MESSAGE></RESULT>

Vadim

[Former Member · Accepted solution]

Hi,

Thanks for the info. I got there. But I am unable to read these .LOG file or .TXT file that is there in UJFS -> ROOT\WEBFOLDERS\Environment name\model name\PRIVATEPUBLICATIONS\user id\TEMPFILES.

Rgds..

Ronit

[dinesh_veluru · Accepted solution]

Hi Ronit,

Please do right click on the respective file or folder then "Download the Document" to your desktop.

please note you will not be able to open the log files directly in the UJFS.

Thanks,

Dinesh.V

[former_member186338 · Accepted solution]

If you want to read log files in ABAP - just look on the code of UJFS transaction - very simple. For manual reading - look on Dinesh download proposal.

Vadim

[Former Member · Accepted solution]

Hi Kalinin,

I downloaded the log file and then i saw the counts,  but is there any way to see the rejected counts in the sap system only in ABAP ?

actually my plan is to store those information in a table and then show that table whenever needed, but to store the information i couldn't find any way how to proceed.

Thanks & Regards

Ronit Kumar

[former_member186338 · Accepted solution]

"is there any way to see the rejected counts in the sap system only in ABAP" - no way, there is no table to store rejected records, this info is stored ONLY in log files!

For many DM packages the concept of rejected records is not applicable...

Some packages (with RUNLOGIC_PH badi) can generate multiple rejected records lists... in different models. There is no simple solution!

Try to explain the business idea!

Vadim

[Former Member · Accepted solution]

Hello Vadim,

The business idea is to create a tool to show the status & the other information regarding the datamanagers packages in one screen.

The main thing is if we log into the EPM & then see the status of the data managers then we can only see the details of the datamanagers of that model only not for other models in the BPC system.

So the perpose of the tool is to show the details of all the datamanager package which executed in that BPC system & display via a program.

I found everything in UJD_Status except the counts & the need is to show that counts as well in the tool.

Thanks & Regards

Ronit Kumar

[former_member186338 · Accepted solution]

Sorry, Ronit...

Looks like you don't understand the concept. You have the main package log that can be retrieved from UJFS based on info in UJD_STATUS. Then you have to work with this main log to find the location of additional logs... There are no special tables with rejected count etc!

Not all DM packages can even generate rejected records at all.

Vadim

[Former Member · Accepted solution]

Hi Ronit Kumar,

What would be the key of the table where you want to store number of rejected records?

Gersh

[Former Member]

Hi Ronit Kumar,

You came very close to the right place. From UJF_DOC you can link to UJF_DOCTREE.

Regards,

Gersh

[dinesh_veluru]

Hi Ronit,

Data manager logs are avaliable in Tcode---UJFS

\ROOT\WEBFOLDERS\Environment name\model name\PRIVATEPUBLICATIONS\user id\TEMPFILES

search for the package name and the time

Thanks,

Dinesh.V