起步软件技术论坛
搜索
 找回密码
 注册

QQ登录

只需一步,快速开始

查看: 2871|回复: 3

[结贴] 列表中的最大表达式数为 1000

[复制链接]

15

主题

39

帖子

159

积分

初级会员

Rank: 2

积分
159
QQ
发表于 2018-11-26 10:27:15 | 显示全部楼层 |阅读模式
打开业务模块报错,求解,下面为完整报错信息:
编码: JUSTEP150039; 提示: 执行sql: SELECT SA_Task.sParentID AS sParent, SA_Task.SNAME AS sName, SA_Task.SCONTENT AS sContent, SA_Task.SREMARK AS sRemark, SA_Task.SFLOWID AS sFlowID, SA_Task.SSOURCEID AS sSourceID, SA_Task.SFRONTID AS sFrontID, SA_Task.SCATALOGID AS sCatalogID, SA_Task.SKINDID AS sKindID, SA_Task.SRESPONSIBLE AS sResponsible, SA_Task.SEXECUTEMODE2 AS sExecuteMode2, SA_Task.SEXECUTEMODE AS sExecuteMode, SA_Task.SPREEMPTMODE AS sPreemptMode, SA_Task.SREMINDMODE AS sRemindMode, SA_Task.STYPEID AS sTypeID, SA_Task.STYPENAME AS sTypeName, SA_Task.SIMPORTANCEID AS sImportanceID, SA_Task.SIMPORTANCENAME AS sImportanceName, SA_Task.SEMERGENCYID AS sEmergencyID, SA_Task.SEMERGENCYNAME AS sEmergencyName, SA_Task.SCURL AS sCURL, SA_Task.SEURL AS sEURL, SA_Task.SDISTRIBUTETIME AS sDistributeTime, SA_Task.SCREATETIME AS sCreateTime, SA_Task.SLASTMODIFYTIME AS sLastModifyTime, SA_Task.SLIMITTIME AS sLimitTime, SA_Task.SWARNINGTIME AS sWarningTime, SA_Task.SEXECUTETIME AS sExecuteTime, SA_Task.SEXPECTSTARTTIME AS sExpectStartTime, SA_Task.SEXPECTFINISHTIME AS sExpectFinishTime, SA_Task.SACTUALSTARTTIME AS sActualStartTime, SA_Task.SACTUALFINISHTIME AS sActualFinishTime, SA_Task.SCREATORFID AS sCreatorFID, SA_Task.SCREATORFNAME AS sCreatorFName, SA_Task.SEXECUTORFID AS sExecutorFID, SA_Task.SEXECUTORFNAME AS sExecutorFName, SA_Task.SCREATORPERSONID AS sCreatorPersonID, SA_Task.SCREATORPERSONNAME AS sCreatorPersonName, SA_Task.SCREATORPOSID AS sCreatorPosID, SA_Task.SCREATORPOSNAME AS sCreatorPosName, SA_Task.SCREATORDEPTID AS sCreatorDeptID, SA_Task.SCREATORDEPTNAME AS sCreatorDeptName, SA_Task.SCREATOROGNID AS sCreatorOgnID, SA_Task.SCREATOROGNNAME AS sCreatorOgnName, SA_Task.SEXECUTORPERSONID AS sExecutorPersonID, SA_Task.SEXECUTORPERSONNAME AS sExecutorPersonName, SA_Task.SEXECUTORPOSID AS sExecutorPosID, SA_Task.SEXECUTORPOSNAME AS sExecutorPosName, SA_Task.SEXECUTORDEPTID AS sExecutorDeptID, SA_Task.SEXECUTORDEPTNAME AS sExecutorDeptName, SA_Task.SEXECUTOROGNID AS sExecutorOgnID, SA_Task.SEXECUTOROGNNAME AS sExecutorOgnName, SA_Task.SEXECUTORNAMES AS sExecutorNames, SA_Task.SCUSTOMERID AS sCustomerID, SA_Task.SCUSTOMERNAME AS sCustomerName, SA_Task.SPROJECTID AS sProjectID, SA_Task.SPROJECTNAME AS sProjectName, SA_Task.SPLANID AS sPlanID, SA_Task.SPLANNAME AS sPlanName, SA_Task.SDATA1 AS sData1, SA_Task.SDATA2 AS sData2, SA_Task.SDATA3 AS sData3, SA_Task.SDATA4 AS sData4, SA_Task.SVARIABLE AS sVariable, SA_Task.SACTIVE AS sActive, SA_Task.SSTATUSID AS sStatusID, SA_Task.SSTATUSNAME AS sStatusName, SA_Task.SAIACTIVE AS sAIActive, SA_Task.SAIID AS sAIID, SA_Task.SAISTATUSID AS sAIStatusID, SA_Task.SAISTATUSNAME AS sAIStatusName, SA_Task.SSEQUENCE AS sSequence, SA_Task.SLOCK AS sLock, SA_Task.SHINTS AS sHints, SA_Task.SSHORTCUT AS sShortcut, SA_Task.SPROCESS AS sProcess, SA_Task.SACTIVITY AS sActivity, SA_Task.SPROCESSNAME AS sProcessName, SA_Task.SACTIVITYNAME AS sActivityName, SA_Task.VERSION AS version, SA_Task.SPROCESSTEMPLATEID AS sProcessTemplateID, SA_Task.SPROCESSTEMPLATEITEMSEQUENCE AS sProcessTemplateItemSequence, SA_Task.STEMPPERMISSIONID AS sTempPermissionID, SA_Task.SESFIELD01 AS sESField01, SA_Task.SESFIELD02 AS sESField02, SA_Task.SESFIELD03 AS sESField03, SA_Task.SESFIELD04 AS sESField04, SA_Task.SESFIELD05 AS sESField05, SA_Task.SESFIELD06 AS sESField06, SA_Task.SESFIELD07 AS sESField07, SA_Task.SESFIELD08 AS sESField08, SA_Task.SEDFIELD21 AS sEDField21, SA_Task.SEDFIELD22 AS sEDField22, SA_Task.SEDFIELD23 AS sEDField23, SA_Task.SEDFIELD24 AS sEDField24, SA_Task.SETFIELD31 AS sETField31, SA_Task.SETFIELD32 AS sETField32, SA_Task.SETFIELD33 AS sETField33, SA_Task.SETFIELD34 AS sETField34, SA_Task.SEIFIELD41 AS sEIField41, SA_Task.SEIFIELD42 AS sEIField42, SA_Task.SEIFIELD43 AS sEIField43, SA_Task.SEIFIELD44 AS sEIField44, SA_Task.SEBFIELD51 AS sEBField51, SA_Task.SEBFIELD52 AS sEBField52, SA_Task.SEBFIELD53 AS sEBField53, SA_Task.SEBFIELD54 AS sEBField54, SA_Task.SENFIELD11 AS sENField11, SA_Task.SENFIELD12 AS sENField12, SA_Task.SENFIELD13 AS sENField13, SA_Task.SENFIELD14 AS sENField14, SA_Task.SSUMMARY AS sSummary, SA_Task.SACTIVITYNAMES AS sActivityNames, SA_Task.SCODE AS sCode, SA_Task.SWITHDRAW AS sWithdraw, SA_Task.SPROCESSTEMPLATEID2 AS sProcessTemplateID2, SA_Task.SACTIVITYINTEMPLATE AS sActivityInTemplate, SA_Task.sID AS SA_Task FROM SA_Task SA_Task WHERE ( SA_Task.SDATA1 IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,?, ?, ?, ?, ?) ) AND ( (SA_Task.SSTATUSID = ?) OR (SA_Task.SSTATUSID = ?) ) AND (SA_Task.SEXECUTORPERSONID = ?) ORDER BY sCreateTime DESC, binds: [646AF5E0A6064BD09B1C5626BFDBD1A8, 648AE2E4828840F7A50E67486A6661F3, 653CCE185DE24710AA6DEBEC230CA7A0, 655075D593004E27962519CA6184DE37, 6570E69EB58041D8AA86DD2E560C39EB, 6599E9E739FE4E05A4821C550B2E0C3D, 65C2010E22B749E6A728DDEAEA9F9B75, 65C773AEE192414686433E5EDA7955C0, 660217A9C3B24D5199E21A888540375C, 661A3832310F474CBC26B014811677F1, 66402E3D49C0479291FABC35608EBBFD, 668BEECD22D24BFCBC3CCA6FD1C9C71A, 66DBF14EF39C47159B809F2EDEEDEDC7, 6774312F01CC4A01BD48D85549E626A7, 6794949581F4486CA84C9F399A33064E, 67A0A009265F44588D9F69A13B757338, 682D6CF0E04E4ADB9A7A8609C0EDF209, 683E290A5A0B4EE6B68DE304152A8D83, 68E354DC49C8484CA6F5C7CA967BDC3E, 68E792FEB6F440F8A6F029E3A6E93D59, 6953E30B61E542E1A79ACE5493FEA716, 69F521F6791D492498E5DF8FD2162838, 6A2062B6929B486C9879390BF8BC56B9, 6A513C7C414C4C79B0254314D36C2957, 6A5F60544B6E477DAAD305A72B34AAC6, 6AA9C1795810418D8B4C5C55EDCDF884, 6AD24FE08F784D8895085CEF4C37A513, 6AD90CB2AC1747B6B649C3FC45C75737, 6B18A076E2F94177AFA90C2A3C4C3E0E, 6B98F372BB2444FE994E4FA9A8B75530, 6C33C9EAB9AA4AEC87BA742C3DC42170, 6C70027726024BAABA800D5038AE0392, 6C75235155CE4FF69F9D3AB87467CB6D, 6CFC75FB033747C9B41ABA979ED2C8EF, 6D3FB6868CAB49AC8A5FEE3E74CC48E4, 6D6557E558BE45AE8B4A6B975815638A, 6DAD04C5E296430F912A3E5B9A485C3C, 6DDA8E5F92244C0C964FE0A603AE5942, 6DEC432B77344D4F9EB7A8457E4B4981, 6DFD4A8F80174A3983A42DCB657D25E2, 6E42C2DA21D348B29FE42079F642B31F, 6E51D428E7004EFA91865F3FFB6A1ADC, 6E5FF1CCC17042ACA2F1D24E00363017, 6EC17606BBBB4D6A9AE7D15C24DE69D5, 6FDB40D12E934B71A940A829984B0DC0, 70038D1108554F41B5B5B32BB80BEA4A, 705BB09F40FC4FF4BC21403E06C26B6B, 70742A114CB54FE0965402BC43CC5244, 70B09A899E544E94ADAD0C710DF34D71, 70F27E3EF8F04DA4BF0FA77B0F336E50, 7110B531CC274E7CA15A264206E31DCC, 71767424ED68499697A60EB6DECE1ACE, 71803817F54D4512AA0D754879ED3B4A, 7196E717235A4A8899D5657C225C156C, 7242D6C1BC274261B6464AAFFD0DD34D, 725B89FAAB124140AEF260FF635AF874, 72946F5535DF4370AF65AE5A4D225726, 72B088542928453E885320506C0E497D, 72B4A319FC6B40B2AF0096DA19C94CC8, 72D12C05F8944BE7BF57BF843D1909E1, 730164B0440C4844B762977B61C79129, 7308 5C2762AE27D24949A4CE72E89C369026, 5C3C2211D4E0419983FF16821AFC6A70, 5C67A7F53D6F48A4B07C176E59CA16BE, 5CA942EFF2A8459ABB5BC0DF76579528, tesReady, tesPaused, 0902F9D704544932B335155932426EA4]出错
ORA-01795: 列表中的最大表达式数为 1000




15

主题

39

帖子

159

积分

初级会员

Rank: 2

积分
159
QQ
 楼主| 发表于 2018-11-26 10:28:01 | 显示全部楼层
由于字数限制,将?和binds删除了一部分
回复 支持 反对

使用道具 举报

91

主题

13万

帖子

3万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
36069
发表于 2018-11-26 10:52:23 | 显示全部楼层
ORA-01795: 列表中的最大表达式数为 1000这个是oracle数据库的标准的错误信息,可以到网上查找解决方案
http://www.cnblogs.com/acme6/p/9139907.html
远程的联系方法QQ1392416607,添加好友时,需在备注里注明其论坛名字及ID,公司等信息
发远程时同时也发一下帖子地址,方便了解要解决的问题  WeX5教程  WeX5下载



如按照该方法解决,请及时跟帖,便于版主结贴
回复 支持 反对

使用道具 举报

15

主题

39

帖子

159

积分

初级会员

Rank: 2

积分
159
QQ
 楼主| 发表于 2018-11-26 16:40:14 | 显示全部楼层
jishuang 发表于 2018-11-26 10:52
ORA-01795: 列表中的最大表达式数为 1000这个是oracle数据库的标准的错误信息,可以到网上查找解决方案
htt ...

可以结贴了,原因是js文件中调用的action过滤条件有问题
回复 支持 反对

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

本版积分规则

小黑屋|手机版|X3技术论坛|Justep Inc.    

GMT+8, 2024-11-25 17:41 , Processed in 0.052886 second(s), 23 queries .

Powered by Discuz! X3.4

© 2001-2013 Comsenz Inc.

快速回复 返回顶部 返回列表