找文章 / 找答案
精选问答 更多内容

麻烦看一下添加RESTful数据集报错

陈玉奇青铜一 显示全部楼层 发表于 2024-7-22 16:14:25 |阅读模式 打印 上一主题 下一主题
1
未解决

麻烦看一下添加RESTful数据集报错

297 8
报错:
<results>    <result>
        <level>6</level>
        <message>Fail to update col view, because not find col from query by col id:fuzhibiao</message>
    </result>
</results>
请求:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<info>
    <cols>
        <col>
            <alias>cnt计数就诊编号</alias>
            <name>cnt_VISIT_SN_f</name>
        </col>
        <col>
            <alias>年</alias>
            <name>YEAR</name>
        </col>
        <col>
            <alias>cnt计数患者编号_患者编号</alias>
            <name>cnt_PATIENT_SN_PATIENT_SN_f</name>
        </col>
        <col>
            <alias>日</alias>
            <name>DAY</name>
        </col>
        <col>
            <alias>ucnt去重计数患者编号_患者编号</alias>
            <name>ucnt_PATIENT_SN_PATIENT_SN_f</name>
        </col>
        <col>
            <alias>科室名称</alias>
            <name>DEPT_NAME</name>
        </col>
        <col>
            <alias>复合指标</alias>
            <name>fuzhibiao</name>
        </col>
    </cols>
    <dbsource>Gennlife</dbsource>
    <forbidDownload>false</forbidDownload>
    <fullData>false</fullData>
    <json>$.data</json>
    <material>false</material>
    <path>应用域1/多表数据集</path>
    <reqBody>{"code":"duobiao","filterMap":{},"groupList":["YEAR","DAY","DEPT_NAME"],"orderBy":"","pageNum":1,"pageSize":100}</reqBody>
</info>


微信图片_20240722161341.jpg
回复

使用道具 举报

精彩评论8

yhdata_lyaa 显示全部楼层 发表于 2024-7-22 16:32:19
cols-col-name(必填): 列名(不区分大小写)
有fuzhibiao 吗
https://www.yonghongtech.com/rea ... i_restfulquery.html
回复

使用道具 举报

陈玉奇青铜一 显示全部楼层 发表于 2024-7-22 16:59:20
这是调用时的参数。
第一次调成功,第二次再调用就报这个错误了。
微信图片_20240722165851.png
回复

使用道具 举报

陈玉奇青铜一 显示全部楼层 发表于 2024-7-23 11:12:09
yhdata_lyaa 发表于 2024-7-22 16:32
cols-col-name(必填): 列名(不区分大小写)
有fuzhibiao 吗
https://www.yonghongtech.com/real-help/Z ...
  1. [2024-07-23 10:59:14.265] |-[INFO] |-[d4ee10accc97472eaf497513a8f347b8] |-[admin] |-[g5.sv.AjaxReq.processIns(AjaxReq.java:136)] |-[OTHER:   LogReq--->bi.log]
  2. [2024-07-23 10:59:16.127] |-[INFO] |-[3ec7642c44a14efcbb35bce6e92b3ea9] |-[SYSTEM] |-[g5.qry.driver.ConnectionProvider.getConn(ConnectionProvider.java:108)] |-[SCHEDULER: [01420240723105700_2687_454721][__sys_warning_jobs__/014]  Succeed to get connection, conn: g5.qry.sql.SQLConn@2918e952, url: jdbc:derby:/yhuser/YH10/Yonghong/derby/defAuditDb, cost 0 ms, classloader count: 1, counter: 0, classloader: Def Class loader.]
  3. [2024-07-23 10:59:18.352] |-[INFO] |-[d752d5256f844989b8535352d33a9e19] |-[SYSTEM] |-[g5.mem.CalcMemManager$Reporter.run0(CalcMemManager.java:355)] |-[OTHER:   Memory information, max jvm mem: 1024M, used jvm mem: 541M, free jvm mem: 482M
  4. --GRLink Report, link count: 3, total link mem: 512M, used mem: 0M, total objs: 6 of registered: 6
  5. --HRLink Report, link count: 1, total link mem: 85M, used mem: 0M, total objs: 0 of registered: 0
  6. --GSLink not used.
  7. --Image  Report, link count: 1, total link mem: 85M, used mem: 0M, total objs: 1
  8. --Direct memory report, max: 1024M, used: 0M]
  9. [2024-07-23 10:59:19.262] |-[ERROR] |-[a6fc49de440f4489ae4e6595a4bab481] |-[admin] |-[g5.sv.httpapi.YonghongWebApi.execute(YonghongWebApi.java:146)] |-[ERROR: [ErrCode: 0]  文件夹“应用域1”已存在。]
  10. java.lang.Exception: 文件夹“应用域1”已存在。
  11.         at g5.rep.AbstractRep.addFolder(AbstractRep.java:480) ~[product-20231121.jar:?]
  12.         at g5.sv.httpapi.apiproc.ApiQueryProc.addQueryFolder(ApiQueryProc.java:736) ~[product-20231121.jar:?]
  13.         at g5.sv.httpapi.apiproc.ApiQueryProc.process(ApiQueryProc.java:108) ~[product-20231121.jar:?]
  14.         at g5.sv.httpapi.ApiService.service(ApiService.java:92) ~[product-20231121.jar:?]
  15.         at g5.sv.httpapi.YonghongWebApi.execute(YonghongWebApi.java:139) ~[product-20231121.jar:?]
  16.         at g5.sv.httpapi.YonghongWebApi.doPost(YonghongWebApi.java:76) ~[product-20231121.jar:?]
  17.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:555) ~[servlet-api.jar:4.0.FR]
  18.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:623) ~[servlet-api.jar:4.0.FR]
  19.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:209) ~[catalina.jar:9.0.82]
  20.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) ~[catalina.jar:9.0.82]
  21.         at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51) ~[tomcat-websocket.jar:9.0.82]
  22.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) ~[catalina.jar:9.0.82]
  23.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) ~[catalina.jar:9.0.82]
  24.         at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168) ~[catalina.jar:9.0.82]
  25.         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) ~[catalina.jar:9.0.82]
  26.         at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481) ~[catalina.jar:9.0.82]
  27.         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130) ~[catalina.jar:9.0.82]
  28.         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) ~[catalina.jar:9.0.82]
  29.         at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:670) ~[catalina.jar:9.0.82]
  30.         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) ~[catalina.jar:9.0.82]
  31.         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342) ~[catalina.jar:9.0.82]
  32.         at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:390) ~[tomcat-coyote.jar:9.0.82]
  33.         at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) ~[tomcat-coyote.jar:9.0.82]
  34.         at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:928) ~[tomcat-coyote.jar:9.0.82]
  35.         at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1794) ~[tomcat-coyote.jar:9.0.82]
  36.         at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) ~[tomcat-coyote.jar:9.0.82]
  37.         at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) ~[tomcat-util.jar:9.0.82]
  38.         at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) ~[tomcat-util.jar:9.0.82]
  39.         at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) ~[tomcat-util.jar:9.0.82]
  40.         at java.lang.Thread.run(Thread.java:834) ~[?:?]
  41. [2024-07-23 10:59:19.315] |-[INFO] |-[42ef702441ed4553af43af0f10b609e2] |-[admin] |-[g5.sv.Req.process(Req.java:84)] |-[OTHER:   [Audit Actions],admin,打开数据集"应用域1/多表数据集.rfqry"。]
  42. [2024-07-23 10:59:19.357] |-[INFO] |-[42ef702441ed4553af43af0f10b609e2] |-[admin] |-[g5.qry.util.http.HttpClientUtils.parseResponse(HttpClientUtils.java:112)] |-[OTHER:   Start Receive data type: application/json;, total bytes: -1.]
  43. [2024-07-23 10:59:19.359] |-[ERROR] |-[42ef702441ed4553af43af0f10b609e2] |-[admin] |-[g5.sv.httpapi.apiproc.ApiQueryProc.process(ApiQueryProc.java:203)] |-[ERROR: [ErrCode: 8192]  Fail to update col view, because not find col from query by col id:fuzhibiao]
  44. g5.util.GRTException: Fail to update col view, because not find col from query by col id:fuzhibiao
  45.         at g5.sv.qry.impl.QueryServiceImpl.updateQueryAlias(QueryServiceImpl.java:333) ~[product-20231121.jar:?]
  46.         at g5.sv.httpapi.XmlUtil.updateCol(XmlUtil.java:4103) ~[product-20231121.jar:?]
  47.         at g5.sv.httpapi.XmlUtil.createSaveRESTfulQryReq(XmlUtil.java:3617) ~[product-20231121.jar:?]
  48.         at g5.sv.httpapi.XmlUtil.saveRESTfulQuery(XmlUtil.java:3387) ~[product-20231121.jar:?]
  49.         at g5.sv.httpapi.apiproc.ApiQueryProc.process(ApiQueryProc.java:198) ~[product-20231121.jar:?]
  50.         at g5.sv.httpapi.ApiService.service(ApiService.java:92) ~[product-20231121.jar:?]
  51.         at g5.sv.httpapi.YonghongWebApi.execute(YonghongWebApi.java:139) ~[product-20231121.jar:?]
  52.         at g5.sv.httpapi.YonghongWebApi.doPost(YonghongWebApi.java:76) ~[product-20231121.jar:?]
  53.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:555) ~[servlet-api.jar:4.0.FR]
  54.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:623) ~[servlet-api.jar:4.0.FR]
  55.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:209) ~[catalina.jar:9.0.82]
  56.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) ~[catalina.jar:9.0.82]
  57.         at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51) ~[tomcat-websocket.jar:9.0.82]
  58.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) ~[catalina.jar:9.0.82]
  59.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) ~[catalina.jar:9.0.82]
  60.         at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168) ~[catalina.jar:9.0.82]
  61.         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) ~[catalina.jar:9.0.82]
  62.         at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481) ~[catalina.jar:9.0.82]
  63.         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130) ~[catalina.jar:9.0.82]
  64.         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) ~[catalina.jar:9.0.82]
  65.         at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:670) ~[catalina.jar:9.0.82]
  66.         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) ~[catalina.jar:9.0.82]
  67.         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342) ~[catalina.jar:9.0.82]
  68.         at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:390) ~[tomcat-coyote.jar:9.0.82]
  69.         at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) ~[tomcat-coyote.jar:9.0.82]
  70.         at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:928) ~[tomcat-coyote.jar:9.0.82]
  71.         at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1794) ~[tomcat-coyote.jar:9.0.82]
  72.         at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) ~[tomcat-coyote.jar:9.0.82]
  73.         at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) ~[tomcat-util.jar:9.0.82]
  74.         at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) ~[tomcat-util.jar:9.0.82]
  75.         at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) ~[tomcat-util.jar:9.0.82]
  76.         at java.lang.Thread.run(Thread.java:834) ~[?:?]
复制代码
回复

使用道具 举报

yhdata_lyaa 显示全部楼层 发表于 2024-7-23 11:21:45
path(必填):数据集的全路径。如果该路径不存在RESTful数据集,则创建RESTful数据集,否则修改该路径的数据集。
回复

使用道具 举报

陈玉奇青铜一 显示全部楼层 发表于 2024-7-23 11:38:32
yhdata_lyaa 发表于 2024-7-23 11:21
path(必填):数据集的全路径。如果该路径不存在RESTful数据集,则创建RESTful数据集,否则修改该路径的数 ...

上面填了<path>应用域1/多表数据集</path>
回复

使用道具 举报

陈玉奇青铜一 显示全部楼层 发表于 2024-7-23 11:39:59
查看一下
回复

使用道具 举报

陈玉奇青铜一 显示全部楼层 发表于 2024-7-23 11:41:02
yhdata_lyaa 发表于 2024-7-23 11:21
path(必填):数据集的全路径。如果该路径不存在RESTful数据集,则创建RESTful数据集,否则修改该路径的数 ...

日志
2.jpg
回复

使用道具 举报

yhdata_lyaa 显示全部楼层 发表于 2024-7-23 11:41:39

提工单看看吧,或者你在内部问一下呢
回复

使用道具 举报

高级模式
您需要登录后才可以回帖 登录 | 免费注册

  • 官方微信

    欢迎关注永洪服务号!收费为0,价值无限

    扫码关注
  • 新浪微博

    让每位用户轻松挖掘数据价值!

    访问新浪微博
  • 智能客服
50W

会员等你来哦

Copyright   ©2012-2024  北京永洪商智科技有限公司  (京ICP备12050607) 京公网安备110110802011451号 |《永洪社区协议》
返回顶部