SAP Knowledge Base Article - Preview

3080515 - Subqueries are not supported in XS Classic

Symptom

A Delivery Unit containing CDS Views are imported into a target HANA system running on XS Classic (XSC).

The following is observed under the Job summary report following the delivery unit import and subsequent activation in the eclipse logs : /..../workspace/com.sap.ndb.studio.bi.logs/'ABC_ImportSeverModels_job_ID'

Job ID : ABC_ImportSeverModels_IBMBASIS_1621561431286
Job Type : Import Delivery Unit
System : ABC:LOCALHOST:02:1A2B3C-ONBOARDINGDB:IBMBASIS
Start Time : Fri May 21 07:13:51 IST 2021
End Time : Fri May 21 07:14:03 IST 2021
Elapsed Time : 11.864 Seconds

Summary Report :

Name            Type                               Package                              Status                 Description
DU_Name.tgz  Import Delivery Unit         -                                      Success 
ABC_DDIC     hdbdd                        ABC_ONBOARDING.TABLES     Error

• Delivery Unit Import
• Selected File:C:\Users\User\Documents\12345\DU_Name.tgz
• Overwrite inactive versions:true
• Activate Objects:true
• Bypass validation:true
Activation
       ABC_DDIC.hdbdd
       Subqueries are not supported in XS Classic
       Subqueries are not supported in XS Classic

- Runtime 'Procedure Runtime' finished activation of 52 object(s) in 1510ms
- Runtime 'CDS runtime' finished activation of 1 object(s) in 190ms
- Runtime 'sqlproc-runtime' finished activation of 52 object(s) in 1510ms
- Runtime 'JavaScript-serverside-runtime' finished activation of 18 object(s) in 76ms
- Runtime 'XSJob-runtime' finished activation of 1 object(s) in 24ms
- Runtime 'XSApp-runtime' finished activation of 2 object(s) in 16ms
- Runtime 'XSAccess-runtime' finished activation of 7 object(s) in 9ms
- Runtime 'XSPrivileges-runtime' finished activation of 7 object(s) in 13ms
- Runtime 'XSHttpDestinations' finished activation of 5 object(s) in 36ms
- Activation is performed with activation mode import.
- Runtime 'TableImportRuntime' finished activation of 1 object(s) in 364ms
- Runtime 'OData service runtime' finished activation of 4 object(s) in 1191ms
- Finished activation phase. Starting regeneration phase now.


Read more...

Environment

  • SAP HANA PLATFORM EDITION 1.0
  • SAP HANA PLATFORM EDITION 1.0
  • SAP HANA XS Classic

Product

SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0

Keywords

KBA , HAN-AS-XS , SAP HANA Extended Application Services , 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.