1金币
{"@timestamp":"2023-02-10T10:09:46.2548887Z","@m":"@I","LogType":"ServerCommandLog","RequestId":"72be9ebd-16a0-47e1-a595-575e3dedd381","Log":"18:09 执行'updateProcessMonitor'命令, 请求方式OST, 用户:4e39355230d7cf6f0926f57fd60c0dc4\n参数:\nfrrptURL = \"https://report.dahuahome.com:8444/WebReport/decision/view/report?viewlet=TZCal/JueCe/version_tz_ej.cpt&op=write&rojectID=19958389-532c-448e-a365-3ec247c92aeb&Version=19958389-532c-448e-a365-3ec247c92aeb\"\ncreateTime = \"2023-02-10\"\nuserId = \"2364\"\nprojectId = \"19958389-532c-448e-a365-3ec247c92aeb\"\nrequetId = \"2848850\"\nstatus = \"0\"\n设置变量命令 : cod 用时:0毫秒。e\n 创建变量 code = 200\n设置变量命令 : messag 用时:0毫秒。e\n 创建变量 message = null\n异常捕获命 用时:82毫秒。令\n 开始执行Try中的命令。\n 条 用时:82毫秒。件\n 判断: (=requetId 等于 %Null% 或者 =status 等于 %Null%) 结果为 False\n 条 用时:55毫秒。件\n 判断: =status 等于 0 结果为 True\n 执行SQL命 用时:54毫秒。令\n SQL语句: select count(1) from FR_OA_PROCESS_MONITOR where SUBSTR (FRRPTURL, LENGTH(FRRPTURL) - 35, 36) =:projectId\n 创建变量 ExceptionCode = 500\n 创建变量 ExceptionMessage = SQL logic error\\nno such table: FR_OA_PROCESS_MONITOR\n 开始执行Catch中的命令。\n 设置变量命令 : cod 用时:0毫秒。e\n 设置变量 code = 500\n 设置变量命令 : messag 用时:0毫秒。e\n 设置变量 message = SQL logic error\\nno such table: FR_OA_PROCESS_MONITOR\n返回命 用时:0毫秒。令\n错误码: 0\ncode: \"500\"\nmessage: \"SQL logic error\\nno such table: FR_OA_PROCESS_MONITOR\"\n'updateProcessMonitor'命令执行结束, 用时:83毫秒。\n","ErrCode":0,"StartTime":"2023-02-10T18:09:46.1718893+08:00","CommandName":"updateProcessMonitor","UserName":"4e39355230d7cf6f0926f57fd60c0dc4"}
|
最佳答案
查看完整内容
表是存在的,Oracle 函数问题 SUBSTR (FRRPTURL, LENGTH(FRRPTURL) - 35, 36)
|