后台插入数据时，报KSQL更新失败, KSQL语句非法

zhxiecheng

请教高手：根据视频“基本建模过程”做了一个采购入库的单据，在最后流程结束后往库存表插入数据时报错，查了半天也没发现错在哪里，帮看看，谢谢！
public static void purchaseStorageProcessAfterFinish() {
  String MasterID=ProcessUtils.getProcessData1();
  Map<String,Object>params=new HashMap<String,Object>();
  params.put("MasterID", MasterID);
  String ksql="insrt into S6_StockPile a (a,a.version,a.fProductID,a.fQty)(select guid(),0,b.fProductID,b.fQty from S6_PN_TF b where b.fPO_ID=:MasterID)";
  KSQL.executeUpdate(ksql, params, "/S6/ProcurementManagement/data", null);
}

执行报错：
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150209; 提示: KSQL更新失败, KSQL语句非法, insrt into S6_StockPile a (a,a.version,a.fProductID,a.fQty)(select guid(),0,b.fProductID,b.fQty from S6_PN_TF b where b.fPO_ID=:MasterID)
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.system.data.impl.TableUtilsImplement.ksqlExecuteUpdate(Unknown Source)
at com.justep.system.data.KSQL.executeUpdate(Unknown Source)
at com.justep.system.data.KSQL.executeUpdate(Unknown Source)
at com.justep.system.data.KSQL.executeUpdate(Unknown Source)
at PurchaseStorageProcess.purchaseStorageProcessAfterFinish(PurchaseStorageProcess.java:24)
... 50 more

fengwei

参考 ksql语句  INSERT INTO SA_OPPerson p (p, p.sName, p.sCode) (SELECT :newid , p1.sName, p1.sCode FROM SA_OPPerson p1 WHERE p1.sName = 'ZHANGSAN')

song_ning_ning

ksql写错了 insert  into  而不是  insrt into

zhxiecheng

郁闷啊，insert都写错，太丢人了，还查了半天，感谢楼上两位，已解决，谢谢！