SAP Knowledge Base Article - Preview

2396002 - Unable to open sub infoareas in BW eclipse Modelling tools perspective in HANA Studio after BW support package update or upgrade

Symptom

  • It is not possible to open sub folders and see objects in BW Modelling tools perspective:

            Incident 366250  2016  Not possible to open Infoarea - HANA Studio - BWMT - BW7.5 SP05  SAP Delivered Suppor

SYMPTOM 1.

  • If you check the system log in SM21 transaction on the BW application server at this time you see the error message:

           invalid datatype: LOB type in distinct select clause:...

  • In the HANA Trace files you see an error message like the following:

           L_SQL_CODE   264
           L_SQL_MSG    invalid datatype: LOB type in distinct select clause: line 1 col 53 (at pos 52)

SYMPTOM 2.

  • Error: Unable to deploy view (TLOGO: DMOD, view name: PRIMARY)
  • "Either field TLOGO or TECHNAME is missing in result table"
  • System failure: "An exception has occurred that was not caught."
  • Invalidated view: system-local.bw.bwsearch.SAPHANADB.ELEM.METADATA::<View_Name>

SYMPTOM 3 (only in BW/4HANA 2.00)

  • SM21 shows the following error at the time of the access:
    > invalid column name: OBJNM: line 1 col 254 (at pos 253)

SYMPTOM 4.

  • Unable to open TRFN/DTPs in HANA Studio
    Error: com.sap.bw.connectivity.util.CommException


Read more...

Environment

  • SAP HANA Database
  • SAP NetWeaver 7.5
  • SAP BW/4HANA

Product

SAP BW/4HANA 1.0 ; SAP BW/4HANA 2.0 ; SAP HANA 1.0, platform edition ; SAP HANA studio 1.0 ; SAP HANA studio 1.5 ; SAP HANA, platform edition 2.0 ; SAP NetWeaver 7.4 ; SAP NetWeaver 7.5

Keywords

STRING; calculated column; transaction RSOSM; bwsearch, modelling tool, hana studio, sap, bw, netweaver, infoarea, hmod, com.sap.bw.connectivity.util.CommException, , KBA , rsos_search106 , rsos_search e 097 unable to deploy view , 97 , HAN-DB-ENG-BW , SAP HANA BW Engine , BW-MT , Modeling Tools (Eclipse) , BW4-ME-SRCH , BW Search , BW-WHM-MTD-SRCH , BI Search , BW-WHM-MTD-HMOD , HANA Model Generation in BW , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.