Skip to Content
author's profile photo Former Member
Former Member

Error in UJFS

Hi all.

When I try to download a file in UJFS transaction this don't work and displayed a message

"SAP BPC cannot find generated document content in DB table".

The file is in \ROOT\WEBFOLDERS\APSHELL\PLANNING\DATAMANAGER\TRANSFORMATIONFILES\EXAMPLES\IMPORT.XLS

How I can resolve the problem?

Marco

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Posted on Dec 17, 2010 at 03:48 PM

    Hi Marco,

    It sounds like you used the "Download as Data Manager document" option when you should have used the other (normal) download option in the context menu. Does that explain it?

    It's difficult to tell which type of file is which, so sometimes you just need to try both and see which one works 😊

    Ethan

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 15, 2014 at 06:37 AM

    Hello Everyone,

    I am also facing same error ie Cannot find generated document content in DB Table when I am running package to upload master data from flat file. I am automatically uploading master data flat file using following code in backend

    TYPES:BEGIN OF ty_data,

    text(125),

    END OF ty_data.

    DATA : hex(1) TYPE x VALUE '0A'. "Tab Space

    DATA: target TYPE char255

    ."VALUE '\ROOT\WEBFOLDERS\SIL\sales_planning_sil_2\DATAMANAGER\DATAFILES\EXAMPLES\ZCUST_LOC.CSV' .
    *\ROOT\WEBFOLDERS\SIL\SALES_PLANNING_SIL_2\DATAMANAGER\DATAFILES\gt_saknr.xls
    DATA: it_data TYPE STANDARD TABLE OF ty_data,
    wa_data TYPE ty_data,
    flag(1) .

    DATA: p_file TYPE string ," VALUE '/usr/sap/BID/DVEBMGS02/work/ZCUST_LOC.CSV',
    text(125) ,
    string TYPE string .

    CASE sy-slset.
    WHEN 'FILE_LOC' OR 'FILE_SG'.
    target = '\ROOT\WEBFOLDERS\SIL\SALES_PLANNING_SIL_2\DATAMANAGER\DATAFILES\MASTER DATA\' && p_target.
    WHEN 'FILE_SG1' OR 'FILE_SG2' OR 'FILE_SG3' OR 'FILE_SGC' .
    target = '\ROOT\WEBFOLDERS\SIL\SALES_PLANNING_SIL\DATAMANAGER\DATAFILES\EXAMPLES\CUSTOMER MASTER DATA\' && p_target.
    ENDCASE.


    ** if p_target = 'ZCUST_SG' OR p_target = 'ZCUST_LOC' .
    ** target = '\ROOT\WEBFOLDERS\SIL\SALES_PLANNING_SIL_2\DATAMANAGER\DATAFILES\MASTER DATA\' && p_target && '.CSV' .
    ** ELSE.
    ** target = '\ROOT\WEBFOLDERS\SIL\SALES_PLANNING_SIL\DATAMANAGER\DATAFILES\EXAMPLES\CUSTOMER MASTER DATA\' && p_target && '.CSV'.
    ** ENDIF .


    p_file = '/usr/sap/BIP/DVEBMGS02/work/' && p_source.
    * p_file = target .
    *START-OF-SELECTION.
    OPEN DATASET p_file FOR INPUT IN TEXT MODE ENCODING DEFAULT .
    IF sy-subrc = 0.
    DO .
    READ DATASET p_file INTO text .
    IF sy-subrc = 0.
    wa_data-text = text .
    APPEND wa_data TO it_data.
    ELSE.
    EXIT.
    ENDIF.
    ENDDO.
    ENDIF.


    CLOSE DATASET p_file .

    DATA: lv_content_string TYPE xstring.
    CALL FUNCTION 'SCMS_TEXT_TO_XSTRING'
    IMPORTING
    buffer = lv_content_string
    TABLES
    text_tab = it_data.
    DATA: p_docnam TYPE ujf_doc-docname.
    p_docnam = target.
    * TRY.
    lo_file_service_mgr->put_document(
    EXPORTING i_docname = p_docnam"lv_docname
    i_compression = abap_true
    i_splice_zip = ' '"lv_splice
    i_doc_content = lv_content_string ).

    If I am directly uploading flat file through excel then it is working fine.

    Kindly help me resolving the issue.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 16, 2015 at 08:03 AM

    Hi Experts

    I am also facing the same issue, When i validate the file it is throwing an error "Cannot find the

    generated document content in the DB Table"


    0.jpg (165.2 kB)
    1.jpg (158.7 kB)
    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.