PAL错误:表(类型)""不存在

2020-09-08 04:43发布

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

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


我的PAL版本是1.0SP12,正在尝试为BPNN预测建立过程。 我在SAP帮助Porta中复制了完全相同的编码( https://help.sap.com/viewer/2cfbc5cf2bc14f028cfbe2a2bba60a50/1.0.12/en-US/ddd236d66f394dea885f61cf5fdf8897.html 在我的HANA工作室中遇到了错误...下面是我的编码:

当我执行CALL SYS.AFLLANG_WRAPPER_PROCEDURE_CREATE('AFLPAL','PREDICTWITHBPNN','DM_PAL','PAL_NN_PREDICT',PAL_NN_PDATA_TBL)

它显示错误

 SET SCHEMA DM_PAL;
 -预测部分
 删除类型PAL_PREDICT_NN_DATA_T;
 创建类型PAL_PREDICT_NN_DATA_T AS TABLE(
 " ID"整数,
 " V000"整数,
 " V001"双,
 " V002" VARCHAR(10),
 " V003"整数
 );
 删除类型PAL_PREDICT_NN_RESULT_T;
 创建类型PAL_PREDICT_NN_RESULT_T AS TABLE(
 " ID"整数,
 " LABEL" VARCHAR(2)
 );
 删除类型PAL_PREDICT_NN_SOFTMAX_T;
 创建类型PAL_PREDICT_NN_SOFTMAX_T AS TABLE(
 " ID"整数,
 " LABEL" VARCHAR(2),
 " SOFTMAX"双
 );
 DROP TYPE PAL_NN_MODEL_T;
 创建类型PAL_NN_MODEL_T AS TABLE(
 " NAME" VARCHAR(100),
 "模型" CLOB
 );
 DROP TYPE PAL_CONTROL_T;
 创建类型PAL_CONTROL_T AS TABLE(
 " NAME" VARCHAR(100),
 " INTARGS"整数,
 " DOUBLEARGS" DOUBLE,
 " STRINGARGS" VARCHAR(100)
 );
 -创建程序
 删除表PAL_NN_PDATA_TBL;
 创建列表PAL_NN_PDATA_TBL(
 " POSITION" INT,
 " SCHEMA_NAME" NVARCHAR(256),
 " TYPE_NAME" NVARCHAR(256),
 " PARAMETER_TYPE" VARCHAR(7)
 );
 从PAL_NN_PDATA_TBL删除;
 INSERT INTO PAL_NN_PDATA_TBL VALUES(1,'DM_PAL','PAL_PREDICT_NN_DATA_T','IN');
 INSERT INTO PAL_NN_PDATA_TBL VALUES(2,'DM_PAL','PAL_NN_MODEL_T','IN');
 INSERT INTO PAL_NN_PDATA_TBL VALUES(3,'DM_PAL','PAL_CONTROL_T','IN');
 INSERT INTO PAL_NN_PDATA_TBL VALUES(4,'DM_PAL','PAL_PREDICT_NN_RESULT_T','OUT');
 INSERT INTO PAL_NN_PDATA_TBL VALUES(5,'DM_PAL','PAL_PREDICT_NN_SOFTMAX_T','OUT');
 致电SYS.AFLLANG_WRAPPER_PROCEDURE_DROP('DM_PAL','PAL_NN_PREDICT');
 调用SYS.AFLLANG_WRAPPER_PROCEDURE_CREATE('AFLPAL','PREDICTWITHBPNN','DM_PAL','PAL_NN_PREDICT',PAL_NN_PDATA_TBL);
 

(11.9 kB)

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

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


我的PAL版本是1.0SP12,正在尝试为BPNN预测建立过程。 我在SAP帮助Porta中复制了完全相同的编码( https://help.sap.com/viewer/2cfbc5cf2bc14f028cfbe2a2bba60a50/1.0.12/en-US/ddd236d66f394dea885f61cf5fdf8897.html 在我的HANA工作室中遇到了错误...下面是我的编码:

当我执行CALL SYS.AFLLANG_WRAPPER_PROCEDURE_CREATE('AFLPAL','PREDICTWITHBPNN','DM_PAL','PAL_NN_PREDICT',PAL_NN_PDATA_TBL)

它显示错误

 SET SCHEMA DM_PAL;
 -预测部分
 删除类型PAL_PREDICT_NN_DATA_T;
 创建类型PAL_PREDICT_NN_DATA_T AS TABLE(
 " ID"整数,
 " V000"整数,
 " V001"双,
 " V002" VARCHAR(10),
 " V003"整数
 );
 删除类型PAL_PREDICT_NN_RESULT_T;
 创建类型PAL_PREDICT_NN_RESULT_T AS TABLE(
 " ID"整数,
 " LABEL" VARCHAR(2)
 );
 删除类型PAL_PREDICT_NN_SOFTMAX_T;
 创建类型PAL_PREDICT_NN_SOFTMAX_T AS TABLE(
 " ID"整数,
 " LABEL" VARCHAR(2),
 " SOFTMAX"双
 );
 DROP TYPE PAL_NN_MODEL_T;
 创建类型PAL_NN_MODEL_T AS TABLE(
 " NAME" VARCHAR(100),
 "模型" CLOB
 );
 DROP TYPE PAL_CONTROL_T;
 创建类型PAL_CONTROL_T AS TABLE(
 " NAME" VARCHAR(100),
 " INTARGS"整数,
 " DOUBLEARGS" DOUBLE,
 " STRINGARGS" VARCHAR(100)
 );
 -创建程序
 删除表PAL_NN_PDATA_TBL;
 创建列表PAL_NN_PDATA_TBL(
 " POSITION" INT,
 " SCHEMA_NAME" NVARCHAR(256),
 " TYPE_NAME" NVARCHAR(256),
 " PARAMETER_TYPE" VARCHAR(7)
 );
 从PAL_NN_PDATA_TBL删除;
 INSERT INTO PAL_NN_PDATA_TBL VALUES(1,'DM_PAL','PAL_PREDICT_NN_DATA_T','IN');
 INSERT INTO PAL_NN_PDATA_TBL VALUES(2,'DM_PAL','PAL_NN_MODEL_T','IN');
 INSERT INTO PAL_NN_PDATA_TBL VALUES(3,'DM_PAL','PAL_CONTROL_T','IN');
 INSERT INTO PAL_NN_PDATA_TBL VALUES(4,'DM_PAL','PAL_PREDICT_NN_RESULT_T','OUT');
 INSERT INTO PAL_NN_PDATA_TBL VALUES(5,'DM_PAL','PAL_PREDICT_NN_SOFTMAX_T','OUT');
 致电SYS.AFLLANG_WRAPPER_PROCEDURE_DROP('DM_PAL','PAL_NN_PREDICT');
 调用SYS.AFLLANG_WRAPPER_PROCEDURE_CREATE('AFLPAL','PREDICTWITHBPNN','DM_PAL','PAL_NN_PREDICT',PAL_NN_PDATA_TBL);
 

(11.9 kB)
3条回答
软件心理学工程师
1楼-- · 2020-09-08 05:45

您好,该标签的主要标签应为" SAP HANA",因为它与SAP Predictive Analytics没有直接关系。 谢谢&亲切的问候Antoine

compass1988
2楼-- · 2020-09-08 05:28

您是否已确保模式DM_PAL中存在PAL_PREDICT_NN_DATA_T类型(例如,创建时执行了无错误语句,...)?

Climb_Ma
3楼-- · 2020-09-08 05:42

我面临着同样的问题,您能够解决吗? :)

一周热门 更多>