Building side-by-side extensions on SAP BTP - Manual Deployed Fiori app not working

[dvvelzen]

Hi,

During the learning I've deployed the risk-management app to my trial.

https://learning.sap.com/learning-journeys/build-side-by-side-extensions-on-sap-btp/exercise-perform... 

However when I try to "Go" get the data I get this error.

The srv part crashes, it relates to this part of the code:

Running it locally in BAS works fine.

I noticed the difference between the BTP trial deployment and the BAS local run is in the req.query.SELECT.columns that is constructed. The deployed Cloud (HANA) version has a link to the virtual columns and a limit, where the BAS run against sqlite doesn't have this:

{
  "BTP_req.query.SELECT": {
    "from": {
      "ref": [
        "RiskService.Risks"
      ]
    },
    "orderBy": [
      {
        "ref": [
          "ID"
        ],
        "sort": "asc"
      }
    ],
    "columns": [
      {
        "ref": [
          "ID"
        ]
      },
      {
        "as": "PrioCriticality",
        "cast": {
          "type": "cds.Integer"
        },
        "val": null
      },
      {
        "as": "criticality",
        "cast": {
          "type": "cds.Integer"
        },
        "val": null
      },
      {
        "ref": [
          "impact"
        ]
      },
      {
        "ref": [
          "owner"
        ]
      },
      {
        "ref": [
          "prio_code"
        ]
      },
      {
        "ref": [
          "title"
        ]
      },
      {
        "ref": [
          "prio"
        ],
        "expand": [
          {
            "ref": [
              "code"
            ]
          },
          {
            "ref": [
              "descr"
            ]
          }
        ]
      },
      {
        "ref": [
          "miti"
        ],
        "expand": [
          {
            "ref": [
              "ID"
            ]
          },
          {
            "ref": [
              "descr"
            ]
          }
        ]
      }
    ],
    "limit": {
      "rows": {
        "val": 30
      },
      "offset": {
        "val": 0
      }
    }
  },
  "BAS_req.query.SELECT": {
    "from": {
      "ref": [
        "RiskService.Risks"
      ]
    },
    "orderBy": [
      {
        "ref": [
          "ID"
        ],
        "sort": "asc"
      }
    ],
    "columns": [
      {
        "ref": [
          "ID"
        ]
      },
      {
        "ref": [
          "PrioCriticality"
        ]
      },
      {
        "ref": [
          "criticality"
        ]
      },
      {
        "ref": [
          "impact"
        ]
      },
      {
        "ref": [
          "owner"
        ]
      },
      {
        "ref": [
          "prio_code"
        ]
      },
      {
        "ref": [
          "title"
        ]
      },
      {
        "ref": [
          "prio"
        ],
        "expand": [
          {
            "ref": [
              "code"
            ]
          },
          {
            "ref": [
              "descr"
            ]
          }
        ]
      },
      {
        "ref": [
          "miti"
        ],
        "expand": [
          {
            "ref": [
              "ID"
            ]
          },
          {
            "ref": [
              "descr"
            ]
          }
        ]
      }
    ]
  }
}

Can anyone explain why this difference is there?

[markushaug · Accepted solution]

Hi, 

thanks for reaching out. This is a temporary issue that we currently face. Once we have fixed this, we will come back to you.

We apologise for the inconvenience.

BR,

Markus