Skip to Content
2
Jan 22, 2020 at 07:57 AM

_SYS_RT Schema

226 Views

Hello Expert,

What is _SYS_RT schema used for?

We are trying to deploy our project but we are getting following error.

  Error: com.sap.hana.di.cds: CDS catalog update failed. Details: "" for statement: UPSERT _SYS_RT.CDS_STRUCTURE_COMPONENT ("schema", "name", "componentName", "modifiedUtc", "state", "extensionPackage", "componentIndex", "metaTableSelector", "target.schema", "target.name", "target.isNative", "isKey", "isNullable", "originalDefinition") VALUES ('SXCAC','C_SWIS_CAC.CAC_DB.PH.el.tabl::DT.IQVIA_DATA.RAW_LOAD','CHANNEL','2020-01-21 10:17:03.2040000','VALID','',3,'Artifact','SXCAC','C_SWIS_CAC.CAC_DB.PH.el.tabl::DT.IQVIA_DATA.RAW_LOAD.CHANNEL',0,0,0,null) WITH PRIMARY KEY
(9223372036854775749)[1579601823930] [APP/7-0/deploy] OUT UPSERT _SYS_RT.CDS_STRUCTURE_COMPONENT ("schema", "name", "componentName", "modifiedUtc", "state", "extensionPackage", "componentIndex", "metaTableSelector", "target.schema", "target.name", "target.isNative", "isKey", "isNullable", "originalDefinition") VALUES ('SXCAC','C_SWIS_CAC.CAC_DB.PH.el.tabl::DT.IQVIA_DATA.RAW_LOAD','PRODUCT','2020-01-21 10:17:03.2040000','VALID','',2,'Artifact','SXCAC','C_SWIS_CAC.CAC_DB.PH.el.tabl::DT.IQVIA_DATA.RAW_LOAD.PRODUCT',0,0,0,null) WITH PRIMARY KEY
(9223372036854775750)[1579601823930] [APP/7-0/deploy] OUT UPSERT _SYS_RT.CDS_STRUCTURE_COMPONENT ("schema", "name", "componentName", "modifiedUtc", "state", "extensionPackage", "componentIndex", "metaTableSelector", "target.schema", "target.name", "target.isNative", "isKey", "isNullable", "originalDefinition") VALUES ('SXCAC','C_SWIS_CAC.CAC_DB.PH.el.tabl::DT.IQVIA_DATA.RAW_LOAD','REGION','2020-01-21 10:17:03.2040000','VALID','',4,'Artifact','SXCAC','C_SWIS_CAC.CAC_DB.PH.el.tabl::DT.IQVIA_DATA.RAW_LOAD.REGION',0,0,0,null) WITH PRIMARY KEY
(9223372036854775751)[1579601823930] [APP/7-0/deploy] OUT UPSERT _SYS_RT.CDS_STRUCTURE_COMPONENT ("schema", "name", "componentName", "modifiedUtc", "state", "extensionPackage", "componentIndex", "metaTableSelector", "target.schema", "target.name", "target.isNative", "isKey", "isNullable", "originalDefinition") VALUES ('SXCAC','C_SWIS_CAC.CAC_DB.PH.el.tabl::DT.IQVIA_DATA.RAW_LOAD','TIME','2020-01-21 10:17:03.2040000','VALID','',1,'Artifact','SXCAC','C_SWIS_CAC.CAC_DB.PH.el.tabl::DT.IQVIA_DATA.RAW_LOAD.TIME',0,0,0,null) WITH PRIMARY KEY
(9223372036854775752)[1579601823930] [APP/7-0/deploy] OUT UPSERT _SYS_RT.CDS_STRUCTURE_COMPONENT ("schema", "name", "componentName", "modifiedUtc", "state", "extensionPackage", "componentIndex", "metaTableSelector", "target.schema", "target.name", "target.isNative", "isKey", "isNullable", "originalDefinition") VALUES ('SXCAC','C_SWIS_CAC.CAC_DB.PH.el.tabl::DT.IQVIA_DATA.TIME','LAST_DAY_OF_TIME_UNIT','2020-01-21 10:17:03.2040000','VALID','',4,'ScalarType','SXCAC','C_SWIS_CAC.CAC_DB.PH.el.tabl::DT.IQVIA_DATA.TIME.LAST_DAY_OF_TIME_UNIT',0,0,1,null) WITH PRIMARY KEY
(9223372036854775753)[1579601823930] [APP/7-0/deploy] OUT UPSERT _SYS_RT.CDS_STRUCTURE_COMPONENT ("schema", "name", "componentName", "modifiedUtc", "state", "extensionPackage", "componentIndex", "metaTableSelector", "target.schema", "target.name", "target.isNative", "isKey", "isNullable", "originalDefinition") VALUES ('SXCAC','C_SWIS_CAC.CAC_DB.PH.el.tabl::DT.IQVIA_DATA.TIME','NUMBER_OF_DAYS_IN_TIME_UNIT','2020-01-21 10:17:03.2040000','VALID','',5,'ScalarType','SXCAC','C_SWIS_CAC.CAC_DB.PH.el.tabl::DT.IQVIA_DATA.TIME.NUMBER_OF_DAYS_IN_TIME_UNIT',0,0,1,null) WITH PRIMARY KEY
(9223372036854775754)[1579601823930] [APP/7-0/deploy] OUT UPSERT _SYS_RT.CDS_STRUCTURE_COMPONENT ("schema", "name", "componentName", "modifiedUtc", "state", "extensionPackage", "componentIndex", "metaTableSelector", "target.schema", "target.name", "target.isNative", "isKey", "isNullable", "originalDefinition") VALUES ('SXCAC','C_SWIS_CAC.CAC_DB.PH.el.tabl::DT.IQVIA_DATA.TIME','TIMEKEY','2020-01-21 10:17:03.2040000','VALID','',1,'ScalarType','SXCAC','C_SWIS_CAC.CAC_DB.PH.el.tabl::DT.IQVIA_DATA.TIME.TIMEKEY',0,1,0,null) WITH PRIMARY KEY
(9223372036854775755)[1579601823930] [APP/7-0/deploy] OUT UPSERT _SYS_RT.CDS_STRUCTURE_COMPONENT ("schema", "name", "componentName", "modifiedUtc", "state", "extensionPackage", "componentIndex", "metaTableSelector", "target.schema", "target.name", "target.isNative", "isKey", "isNullable", "originalDefinition") VALUES ('SXCAC','C_SWIS_CAC.CAC_DB.PH.el.tabl::DT.IQVIA_DATA.TIME','TIME_LEVEL','2020-01-21 10:17:03.2040000','VALID','',2,'ScalarType','SXCAC','C_SWIS_CAC.CAC_DB.PH.el.tabl::DT.IQVIA_DATA.TIME.TIME_LEVEL',0,0,1,null) WITH PRIMARY KEY
(9223372036854775756)[1579601823930] [APP/7-0/deploy] OUT UPSERT _SYS_RT.CDS_STRUCTURE_COMPONENT ("schema", "name", "componentName", "modifiedUtc", "state", "extensionPackage", "componentIndex", "metaTableSelector", "target.schema", "target.name", "target.isNative", "isKey", "isNullable", "originalDefinition") VALUES ('SXCAC','C_SWIS_CAC.CAC_DB.PH.el.tabl::DT.IQVIA_DATA.TIME','TIME_PARENT','2020-01-21 10:17:03.2040000','VALID','',3,'ScalarType','SXCAC','C_SWIS_CAC.CAC_DB.PH.el.tabl::DT.IQVIA_DATA.TIME.TIME_PARENT',0,1,0,null) WITH PRIMARY KEY
(9223372036854775757)[1579601823930] [APP/7-0/deploy] OUT UPSERT _SYS_RT.CDS_STRUCTURE_COMPONENT ("schema", "name", "componentName", "modifiedUtc", "state", "extensionPackage", "componentIndex", "metaTableSelector", "target.schema", "target.name", "target.isNative", "isKey", "isNullable", "originalDefinition") VALUES ('SXCAC','C_SWIS_CAC.CAC_DB.PH.el.tabl::DT.IQVIA_DATA','CHANNEL','2020-01-21 10:17:03.2040000','VALID','',4,'Artifact','SXCAC','C_SWIS_CAC.CAC_DB.PH.el.tabl::DT.IQVIA_DATA.CHANNEL',0,0,0,null) WITH PRIMARY KEY
(9223372036854775758)[1579601823930] [APP/7-0/deploy] OUT UPSERT _SYS_RT.CDS [truncated] [1330012]
(9223372036854775759)[1579601823930] [APP/7-0/deploy] OUT      Error: com.sap.hana.di.cds: CDS catalog update failed. Details: "" for statement: UPSERT _SYS_RT.CDS_VIEW ("schema", "name", "modifiedUtc", "state", "extensionPackage", "definition") VALUES ('SXCAC','C_SWIS_CAC.CAC_DB.PH.el.tabl::DT.IQVIA.CHANNEL','2020-01-21 10:17:03.2040000','VALID','','SELECT FROM "C_SWIS_CAC.CAC_DB.PH.el.tabl"::"DT"."IQVIA_DATA"."CHANNEL" AS "CHANNEL" { "CHANNEL_KEY", "CHANNEL_TEXT", "CHANNEL_LEVEL", "APO", "DRO", "SD", "SPI", "LAST_DAY_OF_TIME_UNIT", "NUMBER_OF_DAYS_IN_TIME_UNIT", "PARENT_CHANNEL_KEY" }') WITH PRIMARY KEY
(9223372036854775760)[1579601823930] [APP/7-0/deploy] OUT UPSERT _SYS_RT.CDS_VIEW ("schema", "name", "modifiedUtc", "state", "extensionPackage", "definition") VALUES ('SXCAC','C_SWIS_CAC.CAC_DB.PH.el.tabl::DT.IQVIA.PRODUCT','2020-01-21 10:17:03.2040000','VALID','','SELECT FROM "C_SWIS_CAC.CAC_DB.PH.el.tabl"::"DT"."IQVIA_DATA"."PRODUCT" AS "PRODUCT" { "PRODUCT_KEY", "MARKET_SHARE_LEVEL", "PRODUCT_KEY_PARENT", "MARKET_SHARE_LEVEL_PARENT", "PRODUCT_TEXT_LONG", "PRODUCT_PARENT_TEXT_LONG", "PRODUCT_TEXT_MEDIUM", "PRODUCT_TEXT_SHORT" }') WITH PRIMARY KEY
(9223372036854775761)[1579601823930] [APP/7-0/deploy] OUT UPSERT _SYS_RT.CDS_VIEW ("schema", "name", "modifiedUtc", "state", "extensionPackage", "definition") VALUES ('SXCAC','C_SWIS_CAC.CAC_DB.PH.el.tabl::DT.IQVIA.TIME','2020-01-21 10:17:03.2040000','VALID','','SELECT FROM "C_SWIS_CAC.CAC_DB.PH.el.tabl"::"DT"."IQVIA_DATA"."TIME" AS "TIME" { "TIMEKEY", "TIME_LEVEL", "TIME_PARENT", "LAST_DAY_OF_TIME_UNIT", "NUMBER_OF_DAYS_IN_TIME_UNIT" } UNION SELECT FROM "C_SWIS_CAC.CAC_DB.PH.el.tabl"::"DT"."IQVIA_DATA"."RAW_LOAD"."TIME" AS "TIME" { RTRIM ( SUBSTR ( "RAW_LINE" , 0 , 6 )  )  AS "TIMEKEY", RTRIM ( LTRIM ( SUBSTR ( "RAW_LINE" , 7 , 10 )  )  )  AS "TIME_LEVEL", RTRIM ( LTRIM ( SUBSTR ( "RAW_LINE" , 18 , 10 )  )  )  AS "TIME_PARENT", SUBSTR ( "RAW_LINE" , 33 , 10 )  AS "LAST_DAY_OF_TIME_UNIT", SUBSTR ( "RAW_LINE" , 44 , 8 )  AS "NUMBER_OF_DAYS_IN_TIME_UNIT" }') WITH PRIMARY KEY
(9223372036854775762)[1579601823930] [APP/7-0/deploy] OUT  [1330012]

Please let me know if anybody could help me with this.

Thank You.
Best Regards,

Ajinkya Jadhav