devepos / abap-db-browser Goto Github PK

Hi,

I am facing below issue. am I missing any other dependencies

I'm getting an error when trying to load ZDBBR.
It says "The parameter "P_LANGUAGE" was not found".

It points to include ZCL_DBBR_OBJECT_BROWSER_TREE==CM00H, line 72, but this error didn't make sense to me.

I updated search tools and ui toolbox, but when I do another pull on abap db browser, git dumps with DBSQL_DUPLICATE_KEY_ERROR.

In the DELETE FROM seocompotx a class name is given, but in the insert it is empty.

But I don't know nothing about this...

System version is S/4HANA 2020 FP3, 755,03.

When trying to follow an association that is based on a CDS View with parameters the system is throwing and error:
"The parser produced the error: The parameter "<name of the first parameter " was not bound"

1. Start DB Browser, choose Browser Mode: "CDS View"
2. Enter a CDS view which contains associations based on CDS views with parameters
3. Execute the search
4. Open the context menu for one line of the result list and choose "Follow Association" for the association based on a CDS with parameters.

The system navigates to the next screen but the result list is empty and the above error message is displayed in the status bar

A part of the virtual element specific logic ( adjust_requested ) is executed even for CDS views which don't have any virtual elements at all.
This has to be prevented

When I try to open a database table on the main ZDBBR tree, it throws a dump.
When I tried to investigate the issue, I found the following syntax error:

Should'nt this be IS NOT NULL?

The loading of the selection screen for an entity with many fields can take quite a while.
The problem lies in determining the existence of text fields for each field of an entity:

https://github.com/stockbal/abap-db-browser/blob/16e4653f93be223772184da1c0fe441e2c1a8e63/src/ui/util/zcl_dbbr_selscreen_util.clas.abap#L733

For the following scenario the system is throwing a parsing error:

1. Start DB Browser, choose Browser Mode: "CDS View"
2. Enter a CDS view with parameter
3. Fill out the parameter(s) and execute the selection
4. Open the context menu for one line of the result list and choose "Follow Association"
5. Choose any association from the given list

The system displays the following error "The parser produced the error: The parameter "<name of the first parameter " was not bound."

I get this dump when starting transaction ZDBBR. Latest version of dependencies are installed.

Row freezing does not work correctly if the selected row index is greater than the number of visible rows.

Proposed solution

See class zcl_dbbr_output_grid

  METHOD change_fixed_rows.
    IF if_from_selection = abap_true.
      get_selected_rows( IMPORTING et_index_rows = DATA(lt_row) ).
      CHECK lt_row IS NOT INITIAL.
      get_first_visible_row( IMPORTING row = DATA(lv_first_visible_row) ).
      DATA(lv_selected_row) = CONV i( lt_row[ lines( lt_row ) ]-index ).
      set_fixed_rows( COND #(
        WHEN lv_first_visible_row = lv_selected_row OR lv_selected_row < lv_first_visible_row THEN
          lv_selected_row
        ELSE
          lv_selected_row - lv_first_visible_row ) ).
    ELSE.
      set_fixed_rows( iv_rows ).
    ENDIF.
  ENDMETHOD.

When following an association that is based on a table of a cds view with parameter the system is throwing and error:
"The parser produced the error: The parameter "<name of the first parameter " was not bound"

1. Start DB Browser
2. Choose Browser Mode: "CDS View"
3. Enter a CDS view with parameter(s) and association to a table
4. Execute the search
5. Open the context menu for one line of the result list and choose "Follow Association" for the association based on a table

The system navigates to the next screen but the result list is empty and the above error message is displayed in the status bar

When selecting data from a CDS View which contains virtual elements, the columns stay empty in the result table.

Execute the following steps to reproduce the issue

1. Start DB Browser
2. Choose Browser Mode: "CDS View"
3. Enter a CDS view with virtual elements
4. Execute the search

The result list contains the virtual element as a column, but it is always empty.

Hi,
Can you help adding a license?

https://docs.github.com/en/github/building-a-strong-community/adding-a-license-to-a-repository

Ref https://devepos.com/projects/abap-db-browser/installation.html#install-of-dependencies

Hi Ludwig,

I have done a detailed analysis of the installation errors and already made a few corrections to abapGit (for example, abapGit/abapGit#5998, abapGit/abapGit#5989, and various log improvements).

Today, I was able to identify the root cause. The mass DDIC activation fails because of two secondary indexes (zdbbr_tabf.tabl.xml and zdbbr_vardata.tabl.xml). The mass activation is not able to order the objects properly and tries to activate an index before the include used in the table index is available (see attached log). It looks like a bug in SAP.

If you remove the indexes or comment out the following lines, your repo installs without errors! 😃

I will try to create a small example for reproducing the issue which we can then use to create a ticket with SAP and hopefully get a fix.

Viele Gruesse,
Marc

PS: The new feature "Advanced > Activate Objects" is also quite handy. You can pull, activate, and pull again to install everything without workarounds.

activation_log.zip