嗨,我在SAP HANA中执行程序时遇到问题

2020-09-26 14:09发布

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

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


错误:

"无法执行'CALL" _SYS_BIC"。" EVALUADOR_LOCAL/EVAL_PROMOS_L2"'在806毫秒15微秒内。SAP DBTech JDBC:[9]:索引超出范围:" _SYS_BIC"。" EVALUADOR_LOCAL/EVAL_PROMOS_L2":第21行 第2列(在pos 828处):[9](范围3):索引超出范围:参数索引超出了参数大小0,但为1"

代码:

 BEGIN DECLARE COTA1,COTA2日期;  DECLARE EXIST_TABLE INTEGER; 从" EVALUADOR_LOCAL"中选择MIN(PER_START_DT)放入COTA1。" PERIODOS"; 从" EVALUADOR_LOCAL"中选择MAX(PER_END_DT)放入COTA2。" PERIODOS";  EXIST_TABLE = 0; 从schemasname ='EVALUADOR_LOCAL'和table_name ='KPI_PERIODOS'的表中选择count(*)到EXIST_TABLE; 如果(EXIST_TABLE> 0)然后删除表EVALUADOR_LOCAL.KPI_PERIODOS; 万一; 创建列表EVALUADOR_LOCAL.KPI_PERIODOS AS(选择PER.CADENA,PER.LOCATION_ID,PER.N_PROMO,PER.PERIODO,SUM(DI.MONTO_NETO)作为VENTA_NETA,COUNT(DISTINCT(在DI.PARTY_ID时为!='-2'THEN  DI.PARTY_ID END))作为CLIENTES_FID,SUM(DI.ITEM_QTY_UMB)作为UNIDADES,COUNT(DISTINCT(DI.LOCATION_ID || DI.POS_REGISTER_ID || DI.TRAN_START_DT || DI.TRAN_START_TM || DI.TRAN_NUM))AS TRX,  SUM(DI.MARCA_TMAS ='1'时的情况,然后DI.MONTO_NETO ELSE 0 END)* 1.0 AS VENTA_NETA_TC,CASE WHEN(SUM(DI.MONTO_NETO))!= 0则然后(SUM(CASE WHEN DI.MARCA_TMAS ='1'  THEN DI.MONTO_NETO ELSE 0 END)* 1.0)* 1.0/(SUM(DI.MONTO_NETO))END AS PART_VENTA_TC,SUM(DI.WEIGHTED_AVERAGE_COST_AMT)AS COSTO,COUNT(DISTINCT(在DI.CHAIN_CD IN('JU',  'JS')AND SVJ.SEGMENT_VALUE_CD ='P'然后当DI.CHAIN_CD IN('SA')和SVS.SEGMENT_VALUE_CD ='P'THEN DI.PARTY_ID END))AS CLIENTES_FID_PREF从CL_SUPER_DIM.DIM_DIA_ID_ITE_ITE 像PER.CADENA ||''%'和DI.LOC一样,在DI.LOCATION_ID上按" EVALUADOR_LOCAL"。" PERIODOS"  ATION_ID = PER.LOCATION_ID和DI.TRAN_START_DT在PER.PER_START_DT和PER.PER_END_DT之间加入" EVALUADOR_LOCAL"。" cpintom_SMK_PROMOS_SKU",作为SKU在PER.N_PROMO = SKU.N_PROMO和PER.CADENA = SKU.CADENA  '000000000000000000'|| SKU.SKU,18)联接" EVALUADOR_LOCAL"。" IQPROD_JPCORDOVA_MESES" AS M ON DI.CODMES = M.CODMES左联接CL_SUPER_DIM.SEG_CRM_MONTHLY_SEGMENT_VALUE_JUMBO AS SVJ联接DI.PARTY_ID =  .M_1左联接CL_SUPER_DIM.SEG_CRM_MONTHLY_SEGMENT_VALUE_SISA作为DI上的SVS.PARTY_ID = SVS.PARTY_ID和SVS.CODMES = M.M_1 DI.TRAN_START_DT在COTA1和COTA2之间以及DI.LOCATION_IDID内(在LOCALATION_IDID内) 不在(从EVALUADOR_LOCAL.SMK_LOCALES_NEGRA中选择LOCATION_ID)按PER.CADENA,PER.LOCATION_ID,PER.N_PROMO,PER.PERIODO分组;  END; 

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

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


错误:

"无法执行'CALL" _SYS_BIC"。" EVALUADOR_LOCAL/EVAL_PROMOS_L2"'在806毫秒15微秒内。SAP DBTech JDBC:[9]:索引超出范围:" _SYS_BIC"。" EVALUADOR_LOCAL/EVAL_PROMOS_L2":第21行 第2列(在pos 828处):[9](范围3):索引超出范围:参数索引超出了参数大小0,但为1"

代码:

 BEGIN DECLARE COTA1,COTA2日期;  DECLARE EXIST_TABLE INTEGER; 从" EVALUADOR_LOCAL"中选择MIN(PER_START_DT)放入COTA1。" PERIODOS"; 从" EVALUADOR_LOCAL"中选择MAX(PER_END_DT)放入COTA2。" PERIODOS";  EXIST_TABLE = 0; 从schemasname ='EVALUADOR_LOCAL'和table_name ='KPI_PERIODOS'的表中选择count(*)到EXIST_TABLE; 如果(EXIST_TABLE> 0)然后删除表EVALUADOR_LOCAL.KPI_PERIODOS; 万一; 创建列表EVALUADOR_LOCAL.KPI_PERIODOS AS(选择PER.CADENA,PER.LOCATION_ID,PER.N_PROMO,PER.PERIODO,SUM(DI.MONTO_NETO)作为VENTA_NETA,COUNT(DISTINCT(在DI.PARTY_ID时为!='-2'THEN  DI.PARTY_ID END))作为CLIENTES_FID,SUM(DI.ITEM_QTY_UMB)作为UNIDADES,COUNT(DISTINCT(DI.LOCATION_ID || DI.POS_REGISTER_ID || DI.TRAN_START_DT || DI.TRAN_START_TM || DI.TRAN_NUM))AS TRX,  SUM(DI.MARCA_TMAS ='1'时的情况,然后DI.MONTO_NETO ELSE 0 END)* 1.0 AS VENTA_NETA_TC,CASE WHEN(SUM(DI.MONTO_NETO))!= 0则然后(SUM(CASE WHEN DI.MARCA_TMAS ='1'  THEN DI.MONTO_NETO ELSE 0 END)* 1.0)* 1.0/(SUM(DI.MONTO_NETO))END AS PART_VENTA_TC,SUM(DI.WEIGHTED_AVERAGE_COST_AMT)AS COSTO,COUNT(DISTINCT(在DI.CHAIN_CD IN('JU',  'JS')AND SVJ.SEGMENT_VALUE_CD ='P'然后当DI.CHAIN_CD IN('SA')和SVS.SEGMENT_VALUE_CD ='P'THEN DI.PARTY_ID END))AS CLIENTES_FID_PREF从CL_SUPER_DIM.DIM_DIA_ID_ITE_ITE 像PER.CADENA ||''%'和DI.LOC一样,在DI.LOCATION_ID上按" EVALUADOR_LOCAL"。" PERIODOS"  ATION_ID = PER.LOCATION_ID和DI.TRAN_START_DT在PER.PER_START_DT和PER.PER_END_DT之间加入" EVALUADOR_LOCAL"。" cpintom_SMK_PROMOS_SKU",作为SKU在PER.N_PROMO = SKU.N_PROMO和PER.CADENA = SKU.CADENA  '000000000000000000'|| SKU.SKU,18)联接" EVALUADOR_LOCAL"。" IQPROD_JPCORDOVA_MESES" AS M ON DI.CODMES = M.CODMES左联接CL_SUPER_DIM.SEG_CRM_MONTHLY_SEGMENT_VALUE_JUMBO AS SVJ联接DI.PARTY_ID =  .M_1左联接CL_SUPER_DIM.SEG_CRM_MONTHLY_SEGMENT_VALUE_SISA作为DI上的SVS.PARTY_ID = SVS.PARTY_ID和SVS.CODMES = M.M_1 DI.TRAN_START_DT在COTA1和COTA2之间以及DI.LOCATION_IDID内(在LOCALATION_IDID内) 不在(从EVALUADOR_LOCAL.SMK_LOCALES_NEGRA中选择LOCATION_ID)按PER.CADENA,PER.LOCATION_ID,PER.N_PROMO,PER.PERIODO分组;  END; 
付费偷看设置
发送
1条回答
N-Moskvin
1楼-- · 2020-09-26 14:45

是否可以从indexserver.trc文件(而不是警报文件)粘贴更详细的跟踪。

一周热门 更多>