|
执行代码:
Table busiAcctDataTable = KSQL.select("SELECT " + busiAcctConcept + ".* FROM " + busiAcctConcept + " " + busiAcctConcept + " WHERE 1=2",
null, busiAcctDataModel, null);
Iterator<Row> rows = itemTable.iterator();
while (rows.hasNext()) {
Row row = rows.next();
Row newbusiAcctDataRow = busiAcctDataTable.appendRow();
newbusiAcctDataRow.setInteger("version", 0);
newbusiAcctDataRow.setString("gProcessCode", gProcessCode);
newbusiAcctDataRow.setString("gProcessName", gProcessName);
newbusiAcctDataRow.setString("gDirection", direction);
newbusiAcctDataRow.setString("yDocCode", row.getString("yDocCode"));
newbusiAcctDataRow.setDate("yDocDate", row.getDate("yDocDate"));
newbusiAcctDataRow.setString("yRowID", row.getString("yRowID"));
newbusiAcctDataRow.setString("yPeriodID", DateUtils.dateToStr(row.getDate("yDocDate")).substring(0, 7));
newbusiAcctDataRow.setDateTime("yTimeStamp", CommonUtils.getCurrentDateTime());
newbusiAcctDataRow.setInteger("fDigit", row.getInteger(relationNum));
for (Map.Entry<String, String> rm : relationsMap.entrySet()){
newbusiAcctDataRow.setString(rm.getKey(), row.getString(rm.getValue()));
}
}
BizDataUtils.save(busiAcctDataTable, busiAcctConcept, null, null, null, null, null, busiAcctDataModel, null);
到了这一行,BizDataUtils.save(busiAcctDataTable, busiAcctConcept, null, null, null, null, null, busiAcctDataModel, null);继续执行报错:
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: INSERT INTO BA_StorageDetailAcct BA_StorageDetailAcct(BA_StorageDetailAcct, BA_StorageDetailAcct.version, BA_StorageDetailAcct.gProcessCode, BA_StorageDetailAcct.gProcessName, BA_StorageDetailAcct.gDirection, BA_StorageDetailAcct.yDocCode, BA_StorageDetailAcct.yDocDate, BA_StorageDetailAcct.fCompanyID, BA_StorageDetailAcct.fCompanyCode, BA_StorageDetailAcct.fMatID, BA_StorageDetailAcct.fMatCode, BA_StorageDetailAcct.fStID, BA_StorageDetailAcct.fStCode, BA_StorageDetailAcct.yBatchCode, BA_StorageDetailAcct.fDigit, BA_StorageDetailAcct.yPeriodID, BA_StorageDetailAcct.yTimeStamp) VALUES (:BA_StorageDetailAcct, :version, :gProcessCode, :gProcessName, :gDirection, :yDocCode, :yDocDate, :fCompanyID, :fCompanyCode, :fMatID, :fMatCode, :fStID, :fStCode, :yBatchCode, :fDigit, :yPeriodID, :yTimeStamp)
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.system.data.impl.TableUtilsImplement.ksqlInsert(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.impl.TableImpl.insert(Unknown Source)
at com.justep.system.data.impl.TableImpl.save(Unknown Source)
at com.justep.system.data.impl.TableImpl.save(Unknown Source)
at com.justep.system.data.BizData.save(Unknown Source)
at com.wujx.system.data.BizDataUtils.save(BizDataUtils.java:53)
at com.wujx.business.acct.BusiAcctUtils.exeDetailBusiAcct(BusiAcctUtils.java:259)
at com.wujx.business.acct.BusiAcctUtils.exeBusiAcct(BusiAcctUtils.java:131)
at com.wujx.business.acct.BusiAcctUtils.exeBusiAcctInterface(BusiAcctUtils.java:74)
at com.wujx.business.utils.PostDocUtils.exePostDoc(PostDocUtils.java:37)
at PurchaseInStorageProcess.purchaseInStorageProcessAfterSaveCL_PurchaseInStorageHdAction(PurchaseInStorageProcess.java:42)
... 26 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150119; 提示: "AC9CAB8A87534DBEA7ED7E5DA2A4AB53:"解码出错, 类型"[String, String]"不匹配
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.util.Utils.check(Unknown Source)
at com.justep.model.ModelUtils.decode(Unknown Source)
at com.justep.system.ksql.visitor.SQLVisitor.normalizeDim(Unknown Source)
at com.justep.system.ksql.visitor.InsertVisitor.visit(Unknown Source)
at com.justep.system.ksql.node.InsertSentence.accept(Unknown Source)
... 40 more
AC9CAB8A87534DBEA7ED7E5DA2A4AB53 这个值是yRowID的值。这个是String类型的,没错哦。但不知道为什么报错
|
|