fOpinionExplain2，fOpinionExplain3等一些字段都已经从概念里删除了，在本地运行正常；部署服务器（weblogic），申请打开也没问题，一旦流转下去，打开就报下面的错误？
本地、服务器缓存都已经删除了，已经确认不是缓存的问题
下面是报错信息
2018-10-11 07:44:00 excute stream action, params:{"accept":"application/json","a
ction":"queryBU_ProjectSetUpAction","actionFlag":"__action_0__","activity":"busi
nessActivity2","contentType":"json","executeContext":"","executor":"","parameter
s":{"columns":"BU_ProjectSetUp,fAssessmentReport,fBU,fBUCode,fBUFID,fBidWinningE
nterprise,fBidWinningPrice,fBizState,fBizStateName,fBuManagerVerdict,fBuMouldSub
sidies,fBuProjectManager,fBuProjectManagerID,fBudgetDecomposition,fCURRENCY,fCar
ModelID,fCarModelName,fCheckPriceEngineers,fCheckPriceEngineersId,fClauseforRate
ofExchange,fCompetitor,fCorReviewOpinion,fCorReviewResult,fCorReviewer,fCorRevie
werID,fCostOfManufacture,fCostTarget,fCreateDeptID,fCreateDeptName,fCreateOgnID,
fCreateOgnName,fCreatePosID,fCreatePosName,fCreatePsnFID,fCreatePsnFName,fCreate
PsnID,fCreatePsnName,fCreateTime,fCurrencyID,fCurrentActivities,fCurrentExecutor
s,fCusDevelopmentCost,fCusExemplar,fCusFeeExplain,fCusMouldPay,fCusReqQuotationD
ate,fCusTargetPrice,fCusTestingExpenses,fCustomerCode,fCustomerManager,fCustomer
ManagerID,fCustomerName,fCustomerPN,fCustomerTargetPrice,fCustomerType,fCustomer
TypeID,fCustomerTypeName,fDeliveryVolume,fDepReviewOpinion,fDepReviewResult,fDep
Reviewer,fDepReviewerID,fDesignValidateExemplar,fDevelopType,fDevelopTypeID,fDev
elopmentExpenses,fDrawing,fDrawingAttachment,fEffluentStandard,fEffluentStandard
ID,fEmissionStandard,fEnginParameter,fEngineType,fEvaluationPrice,fExchangeRateB
asePrice,fExpectedResults,fFilingsAttachment,fFinishTime,fFrockExemplar,fHardIns
tructions,fImputedPrice,fInsideFrockPay,fInsideModalPay,fInsideModalPay1,fInside
TestingExpenses,fInsideTestingExpenses1,fInvCode,fIsSetUp,fManagerVerdict,fMarke
tIncome,fMarketingDirector,fMarketingDirectorID,fMaterialStandard,fMaterialStand
ardAttachment,fMotherProjectID,fMotherProjectName,fMotherProjectNumber,fOfficial
Price,fOpinionExplain,fOpinionExplain1,fOpinionExplain1_att,fOpinionExplain2,fOp
inionExplain3,fOpinionExplain4,fOpinionExplain_att,fOpportunityAssessment,fOther
InputInstructions,fOutputMarketForecasting1,fOutputMarketForecasting2,fOutputMar
ketForecasting3,fOutputMarketForecasting4,fOutputMarketForecasting5,fPPAPTimePoi
nt,fPacking,fPackingEngineer,fPackingEngineerID,fPacking_att,fPricingProvisions,
fProcessEngineer,fProcessEngineerID,fProcessVerNum,fProducStandard,fProductEngin
eer,fProductEngineerID,fProductLM,fProductMix,fProductMixID,fProductMixNumber,fP
roductName,fProductStandardAttachment,fProductType,fProductTypeID,fProjectBackgr
_att,fProjectBackground,fProjectClass,fProjectName,fProjectNumber,fProjectPlan,f
ProjectTypeCode,fProjectTypeName,fProperty,fPropertyAttachment,fPurchasePrice,fP
urchasePrice_att,fPurchasingEngineer,fPurchasingEngineerID,fQuotationStatus,fRaw
MaterialBasePrice,fReducePercentMarkFor1,fReducePercentMarkFor2,fReducePercentMa
rkFor3,fReducePercentMarkFor4,fReducePercentMarkFor5,fReliabilityIndex,fReqChekP
riTime,fRiskAssessment,fSOPTimePoint,fSerialNumber,fStaGroMar,fStandardPrice,fSt
andardPriceAtt,fStandardPriceAttachment,fStandardPriceEstimate,fSugGroMar,fSugGr
oMar1,fSugGroMar2,fSugGroMar3,fSugGroMar4,fSuggestedPrice1,fSuggestedPrice2,fSug
gestedPrice3,fSuggestedPrice4,fSupObjectIns,fSupportingObject,fSupportingObjectI
D,fSupportingType,fSupportingTypeID,fTeamMembers,fTecMatDet,fTecMatDet_att,fTech
ChiefEngineer,fTechChiefEngineerID,fTechManager,fTechManagerID,fTechnicalIndicat
ors,fTechnologyAssessment,fTest,fTestEngineer,fTestEngineerID,fTestStandard,fTes
tStandardAttachment,fTest_att,fTheLosReaAna,fTheLosReaAna_att,fTheoreticalWeight
,fTimePoint,fTimePointDescription,fToolAmortCost,fTradeTerms,fTradeTermsID,fUpda
tePsnID,fUpdatePsnName,fUpdateTime,fVerifier1,fVerifier1ID,fVerifier2,fVerifier2
ID,fWages,fWages_att,fYearMarkeForecasting1,fYearMarkeForecasting2,fYearMarkeFor
ecasting3,fYearMarkeForecasting4,fYearMarkeForecasting5,fkeyTechnology,version",
"filter":"(BU_ProjectSetUp='218B304A323B426F8F6D642F496BCB53')","limit":20,"offs
et":0,"variables":{}},"process":"/BusinessCenter/projectManage/process/NewProSet
UpAndQuoteApply/newProSetUpAndQuoteApplyProcess","translateParameter":{"cellname
ByRelation":false,"dataType":"row-list","includeState":true,"rowsConfig":{"conce
pt":"BU_ProjectSetUp","sequence":"BU_ProjectSetUp,fAssessmentReport,fBU,fBUCode,
fBUFID,fBidWinningEnterprise,fBidWinningPrice,fBizState,fBizStateName,fBuManager
Verdict,fBuMouldSubsidies,fBuProjectManager,fBuProjectManagerID,fBudgetDecomposi
tion,fCURRENCY,fCarModelID,fCarModelName,fCheckPriceEngineers,fCheckPriceEnginee
rsId,fClauseforRateofExchange,fCompetitor,fCorReviewOpinion,fCorReviewResult,fCo
rReviewer,fCorReviewerID,fCostOfManufacture,fCostTarget,fCreateDeptID,fCreateDep
tName,fCreateOgnID,fCreateOgnName,fCreatePosID,fCreatePosName,fCreatePsnFID,fCre
atePsnFName,fCreatePsnID,fCreatePsnName,fCreateTime,fCurrencyID,fCurrentActiviti
es,fCurrentExecutors,fCusDevelopmentCost,fCusExemplar,fCusFeeExplain,fCusMouldPa
y,fCusReqQuotationDate,fCusTargetPrice,fCusTestingExpenses,fCustomerCode,fCustom
erManager,fCustomerManagerID,fCustomerName,fCustomerPN,fCustomerTargetPrice,fCus
tomerType,fCustomerTypeID,fCustomerTypeName,fDeliveryVolume,fDepReviewOpinion,fD
epReviewResult,fDepReviewer,fDepReviewerID,fDesignValidateExemplar,fDevelopType,
fDevelopTypeID,fDevelopmentExpenses,fDrawing,fDrawingAttachment,fEffluentStandar
d,fEffluentStandardID,fEmissionStandard,fEnginParameter,fEngineType,fEvaluationP
rice,fExchangeRateBasePrice,fExpectedResults,fFilingsAttachment,fFinishTime,fFro
ckExemplar,fHardInstructions,fImputedPrice,fInsideFrockPay,fInsideModalPay,fInsi
deModalPay1,fInsideTestingExpenses,fInsideTestingExpenses1,fInvCode,fIsSetUp,fMa
nagerVerdict,fMarketIncome,fMarketingDirector,fMarketingDirectorID,fMaterialStan
dard,fMaterialStandardAttachment,fMotherProjectID,fMotherProjectName,fMotherProj
ectNumber,fOfficialPrice,fOpinionExplain,fOpinionExplain1,fOpinionExplain1_att,f
OpinionExplain2,fOpinionExplain3,fOpinionExplain4,fOpinionExplain_att,fOpportuni
tyAssessment,fOtherInputInstructions,fOutputMarketForecasting1,fOutputMarketFore
casting2,fOutputMarketForecasting3,fOutputMarketForecasting4,fOutputMarketForeca
sting5,fPPAPTimePoint,fPacking,fPackingEngineer,fPackingEngineerID,fPacking_att,
fPricingProvisions,fProcessEngineer,fProcessEngineerID,fProcessVerNum,fProducSta
ndard,fProductEngineer,fProductEngineerID,fProductLM,fProductMix,fProductMixID,f
ProductMixNumber,fProductName,fProductStandardAttachment,fProductType,fProductTy
peID,fProjectBackgr_att,fProjectBackground,fProjectClass,fProjectName,fProjectNu
mber,fProjectPlan,fProjectTypeCode,fProjectTypeName,fProperty,fPropertyAttachmen
t,fPurchasePrice,fPurchasePrice_att,fPurchasingEngineer,fPurchasingEngineerID,fQ
uotationStatus,fRawMaterialBasePrice,fReducePercentMarkFor1,fReducePercentMarkFo
r2,fReducePercentMarkFor3,fReducePercentMarkFor4,fReducePercentMarkFor5,fReliabi
lityIndex,fReqChekPriTime,fRiskAssessment,fSOPTimePoint,fSerialNumber,fStaGroMar
,fStandardPrice,fStandardPriceAtt,fStandardPriceAttachment,fStandardPriceEstimat
e,fSugGroMar,fSugGroMar1,fSugGroMar2,fSugGroMar3,fSugGroMar4,fSuggestedPrice1,fS
uggestedPrice2,fSuggestedPrice3,fSuggestedPrice4,fSupObjectIns,fSupportingObject
,fSupportingObjectID,fSupportingType,fSupportingTypeID,fTeamMembers,fTecMatDet,f
TecMatDet_att,fTechChiefEngineer,fTechChiefEngineerID,fTechManager,fTechManagerI
D,fTechnicalIndicators,fTechnologyAssessment,fTest,fTestEngineer,fTestEngineerID
,fTestStandard,fTestStandardAttachment,fTest_att,fTheLosReaAna,fTheLosReaAna_att
,fTheoreticalWeight,fTimePoint,fTimePointDescription,fToolAmortCost,fTradeTerms,
fTradeTermsID,fUpdatePsnID,fUpdatePsnName,fUpdateTime,fVerifier1,fVerifier1ID,fV
erifier2,fVerifier2ID,fWages,fWages_att,fYearMarkeForecasting1,fYearMarkeForecas
ting2,fYearMarkeForecasting3,fYearMarkeForecasting4,fYearMarkeForecasting5,fkeyT
echnology,version"},"transformIdcolumn":true,"useNamespace":true}}
java.lang.reflect.InvocationTargetException
。。。。。。。。。。
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执
行KSQL出错, KSQL: SELECT BU_ProjectSetUp.* FROM BU_ProjectSetUp BU_ProjectSetUp
WHERE ((BU_ProjectSetUp='218B304A323B426F8F6D642F496BCB53')) LIMIT 0, 20
--> sql:
--> binds: []
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown So
urce)
at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown So
urce)
at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown So
urce)
at com.justep.system.data.BizData.query(Unknown Source)
at BizProcedure.query(BizProcedure.java:12)
... 27 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP154053; 提示: KSQ
L语法错误, columns中的列fOpinionExplain2必须包含在select查出列中
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.util.Utils.check(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.handleColumns(Unknown So
urce)
at com.justep.system.ksql.parser.AbstractParser.selectSentenceNode(Unkno
wn Source)
at com.justep.system.ksql.parser.QueryParser.start(Unknown Source)
at com.justep.system.ksql.parser.QueryParser.start(Unknown Source)
at com.justep.system.ksql.parser.AbstractParser.parse(Unknown Source)
... 32 more
|
IP卡
狗仔卡
发表于 2018-10-11 08:01:16
提升卡
置顶卡
沉默卡
喧嚣卡
变色卡
显身卡
发表于 2018-10-11 09:11:05
楼主