_SYS_RT模式

2020-08-25 04:29发布

         点击此处--->   EasySAP.com群内免费提供SAP练习系统(在群公告中)

加入QQ群:457200227(SAP S4 HANA技术交流) 群内免费提供SAP练习系统(在群公告中)


您好专家

_SYS_RT模式用于什么?

我们正在尝试部署我们的项目,但遇到以下错误。

错误:com.sap.hana.di.cds:CDS目录更新失败。 详细信息:""为语句:UPSERT _SYS_RT.CDS_STRUCTURE_COMPONENT("模式","名称"," componentName"," modifiedUtc","状态"," 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)与主键
 (9223372036854775749)[1579601823930] [APP/7-0/deploy] OUT UPSERT _SYS_RT.CDS_STRUCTURE_COMPONENT("模式","名称"," componentName"," modifiedUtc","状态"," extensionPackage"," componentIndex","  metaTableSelector"," target.schema"," target.name"," target.isNative"," isKey"," isNullable"," originalDefinition")值(" 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)与主键
 (9223372036854775750)[1579601823930] [APP/7-0/deploy] OUT UPSERT _SYS_RT.CDS_STRUCTURE_COMPONENT("模式","名称"," componentName"," modifiedUtc","状态"," extensionPackage"," componentIndex","  metaTableSelector"," target.schema"," target.name"," target.isNative"," isKey"," isNullable"," originalDefinition")值(" 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)与主键
 (9223372036854775751)[1579601823930] [APP/7-0/deploy] OUT UPSERT _SYS_RT.CDS_STRUCTURE_COMPONENT("模式","名称"," componentName"," modifiedUtc","状态"," extensionPackage"," componentIndex","  metaTableSelector"," target.schema"," target.name"," target.isNative"," isKey"," isNullable"," originalDefinition")值(" 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)与主键
 (9223372036854775752)[1579601823930] [APP/7-0/deploy] OUT UPSERT _SYS_RT.CDS_STRUCTURE_COMPONENT("模式","名称"," componentName"," modifiedUtc","状态"," extensionPackage"," componentIndex","  metaTableSelector"," target.schema"," target.name"," target.isNative"," isKey"," isNullable"," originalDefinition")值(" 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)与主键
 (9223372036854775753)[1579601823930] [APP/7-0/deploy] OUT UPSERT _SYS_RT.CDS_STRUCTURE_COMPONENT("模式","名称"," componentName"," modifiedUtc","状态"," extensionPackage"," componentIndex","  metaTableSelector"," target.schema"," target.name"," target.isNative"," isKey"," isNullable"," originalDefinition")值(" 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)与主键
 (9223372036854775754)[1579601823930] [APP/7-0/deploy] OUT UPSERT _SYS_RT.CDS_STRUCTURE_COMPONENT("模式","名称"," componentName"," modifiedUtc","状态"," extensionPackage"," componentIndex","  metaTableSelector"," target.schema"," target.name"," target.isNative"," isKey"," isNullable"," originalDefinition")值(" 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)与主键
 (9223372036854775755)[1579601823930] [APP/7-0/deploy] OUT UPSERT _SYS_RT.CDS_STRUCTURE_COMPONENT("模式","名称"," componentName"," modifiedUtc","状态"," extensionPackage"," componentIndex","  metaTableSelector"," target.schema"," target.name"," target.isNative"," isKey"," isNullable"," originalDefinition")值(" 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)与主键
 (9223372036854775756)[1579601823930] [APP/7-0/deploy] OUT UPSERT _SYS_RT.CDS_STRUCTURE_COMPONENT("模式","名称"," componentName"," modifiedUtc","状态"," extensionPackage"," componentIndex","  metaTableSelector"," target.schema"," target.name"," target.isNative"," isKey"," isNullable"," originalDefinition")值(" 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)与主键
 (9223372036854775757)[1579601823930] [APP/7-0/deploy] OUT UPSERT _SYS_RT.CDS_STRUCTURE_COMPONENT("模式","名称"," componentName"," modifiedUtc","状态"," extensionPackage"," componentIndex","  metaTableSelector"," target.schema"," target.name"," target.isNative"," isKey"," isNullable"," originalDefinition")值(" 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)
 (9223372036854775758)[1579601823930] [APP/7-0/部署] OUT UPSERT _SYS_RT.CDS [已截断] [1330012]
 (9223372036854775759)[1579601823930] [APP/7-0/deploy] OUT错误:com.sap.hana.di.cds:CDS目录更新失败。 详细信息:""为语句:UPSERT _SYS_RT.CDS_VIEW("模式","名称"," modifiedUtc","状态"," extensionPackage","定义")值(" 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",如" 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"}')与主键
 (9223372036854775760)[1579601823930] [APP/7-0/deploy] OUT UPSERT _SYS_RT.CDS_VIEW("模式","名称"," modifiedUtc","状态"," extensionPackage","定义")值("'SXCAC'  ,'C_SWIS_CAC.CAC_DB.PH.el.tabl :: DT.IQVIA.PRODUCT','2020-01-21 10:17:03.2040000','VALID','','从" 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_MED  " PRODUCT_TEXT_SHORT"}')与主键
 (9223372036854775761)[1579601823930] [APP/7-0/deploy] OUT UPSERT _SYS_RT.CDS_VIEW("模式","名称"," modifiedUtc","状态"," extensionPackage","定义")值(" SXCAC"  ,'C_SWIS_CAC.CAC_DB.PH.el.tabl :: DT.IQVIA.TIME','2020-01-21 10:17:03.2040000','VALID','','从" 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"}从" 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)为" NUMBER_OF_DAYS_IN_TIME_UNIT"}'),带有主键
 (9223372036854775762)[1579601823930] [APP/7-0/deploy]输出[1330012]
 

请让我知道是否有人可以帮助我。

谢谢。
最好的问候

Ajinkya Jadhav

         点击此处--->   EasySAP.com群内免费提供SAP练习系统(在群公告中)

加入QQ群:457200227(SAP S4 HANA技术交流) 群内免费提供SAP练习系统(在群公告中)


您好专家

_SYS_RT模式用于什么?

我们正在尝试部署我们的项目,但遇到以下错误。

错误:com.sap.hana.di.cds:CDS目录更新失败。 详细信息:""为语句:UPSERT _SYS_RT.CDS_STRUCTURE_COMPONENT("模式","名称"," componentName"," modifiedUtc","状态"," 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)与主键
 (9223372036854775749)[1579601823930] [APP/7-0/deploy] OUT UPSERT _SYS_RT.CDS_STRUCTURE_COMPONENT("模式","名称"," componentName"," modifiedUtc","状态"," extensionPackage"," componentIndex","  metaTableSelector"," target.schema"," target.name"," target.isNative"," isKey"," isNullable"," originalDefinition")值(" 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)与主键
 (9223372036854775750)[1579601823930] [APP/7-0/deploy] OUT UPSERT _SYS_RT.CDS_STRUCTURE_COMPONENT("模式","名称"," componentName"," modifiedUtc","状态"," extensionPackage"," componentIndex","  metaTableSelector"," target.schema"," target.name"," target.isNative"," isKey"," isNullable"," originalDefinition")值(" 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)与主键
 (9223372036854775751)[1579601823930] [APP/7-0/deploy] OUT UPSERT _SYS_RT.CDS_STRUCTURE_COMPONENT("模式","名称"," componentName"," modifiedUtc","状态"," extensionPackage"," componentIndex","  metaTableSelector"," target.schema"," target.name"," target.isNative"," isKey"," isNullable"," originalDefinition")值(" 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)与主键
 (9223372036854775752)[1579601823930] [APP/7-0/deploy] OUT UPSERT _SYS_RT.CDS_STRUCTURE_COMPONENT("模式","名称"," componentName"," modifiedUtc","状态"," extensionPackage"," componentIndex","  metaTableSelector"," target.schema"," target.name"," target.isNative"," isKey"," isNullable"," originalDefinition")值(" 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)与主键
 (9223372036854775753)[1579601823930] [APP/7-0/deploy] OUT UPSERT _SYS_RT.CDS_STRUCTURE_COMPONENT("模式","名称"," componentName"," modifiedUtc","状态"," extensionPackage"," componentIndex","  metaTableSelector"," target.schema"," target.name"," target.isNative"," isKey"," isNullable"," originalDefinition")值(" 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)与主键
 (9223372036854775754)[1579601823930] [APP/7-0/deploy] OUT UPSERT _SYS_RT.CDS_STRUCTURE_COMPONENT("模式","名称"," componentName"," modifiedUtc","状态"," extensionPackage"," componentIndex","  metaTableSelector"," target.schema"," target.name"," target.isNative"," isKey"," isNullable"," originalDefinition")值(" 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)与主键
 (9223372036854775755)[1579601823930] [APP/7-0/deploy] OUT UPSERT _SYS_RT.CDS_STRUCTURE_COMPONENT("模式","名称"," componentName"," modifiedUtc","状态"," extensionPackage"," componentIndex","  metaTableSelector"," target.schema"," target.name"," target.isNative"," isKey"," isNullable"," originalDefinition")值(" 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)与主键
 (9223372036854775756)[1579601823930] [APP/7-0/deploy] OUT UPSERT _SYS_RT.CDS_STRUCTURE_COMPONENT("模式","名称"," componentName"," modifiedUtc","状态"," extensionPackage"," componentIndex","  metaTableSelector"," target.schema"," target.name"," target.isNative"," isKey"," isNullable"," originalDefinition")值(" 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)与主键
 (9223372036854775757)[1579601823930] [APP/7-0/deploy] OUT UPSERT _SYS_RT.CDS_STRUCTURE_COMPONENT("模式","名称"," componentName"," modifiedUtc","状态"," extensionPackage"," componentIndex","  metaTableSelector"," target.schema"," target.name"," target.isNative"," isKey"," isNullable"," originalDefinition")值(" 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)
 (9223372036854775758)[1579601823930] [APP/7-0/部署] OUT UPSERT _SYS_RT.CDS [已截断] [1330012]
 (9223372036854775759)[1579601823930] [APP/7-0/deploy] OUT错误:com.sap.hana.di.cds:CDS目录更新失败。 详细信息:""为语句:UPSERT _SYS_RT.CDS_VIEW("模式","名称"," modifiedUtc","状态"," extensionPackage","定义")值(" 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",如" 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"}')与主键
 (9223372036854775760)[1579601823930] [APP/7-0/deploy] OUT UPSERT _SYS_RT.CDS_VIEW("模式","名称"," modifiedUtc","状态"," extensionPackage","定义")值("'SXCAC'  ,'C_SWIS_CAC.CAC_DB.PH.el.tabl :: DT.IQVIA.PRODUCT','2020-01-21 10:17:03.2040000','VALID','','从" 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_MED  " PRODUCT_TEXT_SHORT"}')与主键
 (9223372036854775761)[1579601823930] [APP/7-0/deploy] OUT UPSERT _SYS_RT.CDS_VIEW("模式","名称"," modifiedUtc","状态"," extensionPackage","定义")值(" SXCAC"  ,'C_SWIS_CAC.CAC_DB.PH.el.tabl :: DT.IQVIA.TIME','2020-01-21 10:17:03.2040000','VALID','','从" 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"}从" 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)为" NUMBER_OF_DAYS_IN_TIME_UNIT"}'),带有主键
 (9223372036854775762)[1579601823930] [APP/7-0/deploy]输出[1330012]
 

请让我知道是否有人可以帮助我。

谢谢。
最好的问候

Ajinkya Jadhav

付费偷看设置
发送
1条回答
ZJXianG
1楼-- · 2020-08-25 05:10

嗨Ajinkya,

通常您可以在KBA中找到此类信息(假设您有权访问SAP ONE支持启动板)

这是_SYS_REPO下的架构,_SYS_REPO是与SAP HANA XS经典模型相关的SAP HANA存储库对象的所有者。 它没有在外部记录,但与存储库运行时(RT)插件有关。 请注意,自SAP HANA 2.0 SPS 02(2017)起,该存储库已被弃用,并将在以后的版本中删除。

另请参见

一周热门 更多>