R024---UiPath之Execute Query的TimeOut属性设置引起的程序错误及解决

最新推荐文章于 2024-06-20 11:16:49 发布
原创 最新推荐文章于 2024-06-20 11:16:49 发布 · 2.2k 阅读 · 2 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
文章标签：

#流程自动化机器人 #RPA #UiPath

当Execute Query活动在RPA流程中运行超过默认30秒时，会导致程序错误。通过设置Timeout属性为500000毫秒，确保活动有足够时间执行，避免因超时引发的中断。

​一、缘起

昨天遇到一个关于Execute Query的奇怪问题，今天解决了，做个记录，供参考。

二、问题

程序执行到Execute Query这一步时（其实这一步是循环中的一个步骤，已经跑了11次，跑第12次时报错），报错信息：字典引用的key不存在。

Execute Query的SQL语句的拼接中，确实用到字典变量。

于是，在这一步前增加Write Line，把Execute Query中拼接SQL语句的语句，通过Write Line输出，结果发现这个SQL语句拼接正常，没有因为用到字段变量而报错，那为什么执行到Execute Query就报上面的关于字典的错误？

三、解决

3.1 新建流程文件，将Execute Query这一步单独复制出来执行，报错：

实际上我并没有主动取消该流程。

3.2 在navicat中执行该SQL语句，结果正常，用时72秒。

      猜想：是不是因为运行时间太长超时导致。

      于是找到Execute Query的Timeout属性，属性提示：Specifies the amount of time (in milliseconds) to wait for the activity to run before an error is thrown. The defau

最低0.47元/天 解锁文章
大数据常见错误及解决方案
lv_hulk的博客
02-16 9757
大数据常见错误及解决方案（转载） 1、用./bin/spark-shell启动spark时遇到异常：java.net.BindException: Can’t assign requested address: Service ‘sparkDriver’ failed after 16 retries! 解决方法：add export SPARK_LOCAL_IP=“127.0.0.1” to spark-env.sh 2、java Kafka producer error:ERROR kafka.util
Windows PC上创建大数据职业技能竞赛实验环境之五--hadoop、hive和spark编程
liu9ang的博客
04-14 1080
前述，我们在Windows WSL上，通过Docker容器技术实现了Hadoop集群环境，现在看看利用现有集群环境进行编程开发。 1 设置容器开启时自运行SSH服务 参照docker中安装Ubuntu无法在启动时运行ssh服务的解决方案 - llCoding - 博客园 (cnblogs.com)，在我们的hadoop-spark集群镜像中添加如下内容： vim /root/startup_run.sh chmod +x /root/startup_run.sh 编写startup_run.sh
UIPATH Timeout reached
谁的博客来着？
09-18 1198
Timeout Reached这个问题在我们接手的项目上发生了很多次 下面这种情况我最难以理解，官网关于timeout reached的troubleshoot有一个解决方案正是我如下所写的情况，在操作元素之前首先判断元素是否存在，便于得知机器人是否检测到元素 在我的理解下就是，元素存在即可以操作 但是今天跟网友讨论的时候他说元素存在不等于可以操作，element exist只判断元素是否存在，不判断是否加载完成 官网上的描述是： Returns a boolean variable that st
macaca pc java_Macaca Java 版本 execute 报 TimeOut
weixin_27010489的博客
02-28 211
通过 java 执行 execute 一段 Js 代码，server 日志记录 timeout代码和日志如下String js2="return 5";driver.execute(js2);日志：responseHandler.js:11:12 [master] pid:6676 Recieve HTTP Request from Client: method: POST url: /wd/hu...
UiPath查询数据库
liutao261311的博客
08-23 1758
以MySql数据库为例，通过UiPath配置数据库连接实现数据库查询操作。 1、使用Execute Query组件（可用> App Integration > Database > Execute Query）配置数据库查询 点击“Configure Connection…”配置数据库连接，具体详见https://www.rpazj.com/boke/1545 点击“Edit Query“配置需要查询的表SQL，例如："SELECT * FROM person"...
为线程执行设置timeout
minword的专栏
03-06 2070
转自 http://623deyingxiong.iteye.com/blog/1753975 Java代码   package com.test.threads;      import java.util.concurrent.ExecutionException;   import java.util.concurrent.ExecutorService;   imp
# influxd --help WARN[0000]log.go:228 gosnowflake.(*defaultLogger).Warn DBUS_SESSION_BUS_ADDRESS envvar looks to be not set, this can lead to runaway dbus-daemon processes. To avoid this, set envvar DBUS_SESSION_BUS_ADDRESS=$XDG_RUNTIME_DIR/bus (if it exists) or DBUS_SESSION_BUS_ADDRESS=/dev/null. Start up the daemon configured with flags/env vars/config file. The order of precedence for config options are as follows (1 highest, 3 lowest): 1. flags 2. env vars 3. config file A config file can be provided via the INFLUXD_CONFIG_PATH env var. If a file is not provided via an env var, influxd will look in the current directory for a config.{json|toml|yaml|yml} file. If one does not exist, then it will continue unchanged. Usage: influxd [flags] influxd [command] Available Commands: downgrade Downgrade metadata schema used by influxd to match the expectations of an older release help Help about any command inspect Commands for inspecting on-disk database data recovery Commands used to recover / regenerate operator access to the DB run Start the influxd server upgrade Upgrade a 1.x version of InfluxDB version Print the influxd server version Flags: --assets-path string override default assets by serving from a specific directory (developer mode) --bolt-path string path to boltdb database (default "/root/.influxdbv2/influxd.bolt") --e2e-testing add /debug/flush endpoint to clear stores; used for end-to-end tests --engine-path string path to persistent engine files (default "/root/.influxdbv2/engine") --feature-flags stringToString feature flag overrides (default []) --flux-log-enabled enables detailed logging for flux queries --hardening-enabled enable hardening options (disallow private IPs within flux and templates HTTP requests; disable file URLs in templates) -h, --help help for influxd --http-bind-address string bind address for the REST HTTP API (default ":8086") --http-idle-timeout duration max duration the server should keep established connections alive while waiting for new requests. Set to 0 for no timeout (default 3m0s) --http-read-header-timeout duration max duration the server should spend trying to read HTTP headers for new requests. Set to 0 for no timeout (default 10s) --http-read-timeout duration max duration the server should spend trying to read the entirety of new requests. Set to 0 for no timeout --http-write-timeout duration max duration the server should spend on processing+responding to requests. Set to 0 for no timeout --influxql-max-select-buckets int The maximum number of group by time bucket a SELECT can create. A value of zero will max the maximum number of buckets unlimited. --influxql-max-select-point int The maximum number of points a SELECT can process. A value of 0 will make the maximum point count unlimited. This will only be checked every second so queries will not be aborted immediately when hitting the limit. --influxql-max-select-series int The maximum number of series a SELECT can run. A value of 0 will make the maximum series count unlimited. --instance-id string add an instance id for replications to prevent collisions and allow querying by edge node --log-level Log-Level supported log levels are debug, info, and error (default info) --metrics-disabled Don't expose metrics over HTTP at /metrics --no-tasks disables the task scheduler --overwrite-pid-file overwrite PID file if it already exists instead of exiting --pid-file string write process ID to a file --pprof-disabled Don't expose debugging information over HTTP at /debug/pprof --query-concurrency int32 the number of queries that are allowed to execute concurrently. Set to 0 to allow an unlimited number of concurrent queries (default 1024) --query-initial-memory-bytes int the initial number of bytes allocated for a query when it is started. If this is unset, then query-memory-bytes will be used --query-max-memory-bytes int the maximum amount of memory used for queries. Can only be set when query-concurrency is limited. If this is unset, then this number is query-concurrency * query-memory-bytes --query-memory-bytes int maximum number of bytes a query is allowed to use at any given time. This must be greater or equal to query-initial-memory-bytes --query-queue-size int32 the number of queries that are allowed to be awaiting execution before new queries are rejected. Must be > 0 if query-concurrency is not unlimited (default 1024) --reporting-disabled disable sending telemetry data to https://telemetry.influxdata.com every 8 hours --secret-store string data store for secrets (bolt or vault) (default "bolt") --session-length int ttl in minutes for newly created sessions (default 60) --session-renew-disabled disables automatically extending session ttl on request --sqlite-path string path to sqlite database. if not set, sqlite database will be stored in the bolt-path directory as "influxd.sqlite". --storage-cache-max-memory-size Size The maximum size a shard's cache can reach before it starts rejecting writes. (default 1.0 GiB) --storage-cache-snapshot-memory-size Size The size at which the engine will snapshot the cache and write it to a TSM file, freeing up memory. (default 25 MiB) --storage-cache-snapshot-write-cold-duration Duration The length of time at which the engine will snapshot the cache and write it to a new TSM file if the shard hasn't received writes or deletes. (default 10m0s) --storage-compact-full-write-cold-duration Duration The duration at which the engine will compact all TSM files in a shard if it hasn't received a write or delete. (default 4h0m0s) --storage-compact-throughput-burst Size The rate limit in bytes per second that we will allow TSM compactions to write to disk. (default 48 MiB) --storage-max-concurrent-compactions int The maximum number of concurrent full and level compactions that can run at one time. A value of 0 results in 50% of runtime.GOMAXPROCS(0) used at runtime. Any number greater than 0 limits compactions to that value. This setting does not apply to cache snapshotting. --storage-max-index-log-file-size Size The threshold, in bytes, when an index write-ahead log file will compact into an index file. Lower sizes will cause log files to be compacted more quickly and result in lower heap usage at the expense of write throughput. (default 1.0 MiB) --storage-no-validate-field-size Skip field-size validation on incoming writes. --storage-retention-check-interval Duration The interval of time when retention policy enforcement checks run. (default 30m0s) --storage-series-file-max-concurrent-snapshot-compactions int The maximum number of concurrent snapshot compactions that can be running at one time across all series partitions in a database. --storage-series-id-set-cache-size int The size of the internal cache used in the TSI index to store previously calculated series results. --storage-shard-precreator-advance-period Duration The default period ahead of the endtime of a shard group that its successor group is created. (default 30m0s) --storage-shard-precreator-check-interval Duration The interval of time when the check to pre-create new shards runs. (default 10m0s) --storage-tsm-use-madv-willneed Controls whether we hint to the kernel that we intend to page in mmap'd sections of TSM files. --storage-validate-keys Validates incoming writes to ensure keys only have valid unicode characters. --storage-wal-flush-on-shutdown Flushes and clears the WAL on shutdown --storage-wal-fsync-delay Duration The amount of time that a write will wait before fsyncing. A duration greater than 0 can be used to batch up multiple fsync calls. This is useful for slower disks or when WAL write contention is seen. (default 0s) --storage-wal-max-concurrent-writes int The max number of writes that will attempt to write to the WAL at a time. (default <nprocs> * 2) --storage-wal-max-write-delay storage-wal-max-concurrent-writes The max amount of time a write will wait when the WAL already has storage-wal-max-concurrent-writes active writes. Set to 0 to disable the timeout. (default 10m0s) --storage-write-timeout duration The max amount of time the engine will spend completing a write request before cancelling with a timeout. (default 10s) --store string backing store for REST resources (disk or memory) (default "disk") --strong-passwords enable password strength enforcement --template-file-urls-disabled disable template file URLs --testing-always-allow-setup ensures the /api/v2/setup endpoint always returns true to allow onboarding --tls-cert string TLS certificate for HTTPs --tls-key string TLS key for HTTPs --tls-min-version string Minimum accepted TLS version (default "1.2") --tls-strict-ciphers Restrict accept ciphers to: ECDHE_ECDSA_WITH_AES_128_GCM_SHA256, ECDHE_RSA_WITH_AES_128_GCM_SHA256, ECDHE_ECDSA_WITH_AES_256_GCM_SHA384, ECDHE_RSA_WITH_AES_256_GCM_SHA384, ECDHE_ECDSA_WITH_CHACHA20_POLY1305, ECDHE_RSA_WITH_CHACHA20_POLY1305 --tracing-type string supported tracing types are log, jaeger --ui-disabled Disable the InfluxDB UI --vault-addr string address of the Vault server expressed as a URL and port, for example: https://127.0.0.1:8200/. --vault-cacert string path to a PEM-encoded CA certificate file on the local disk. This file is used to verify the Vault server's SSL certificate. This environment variable takes precedence over VAULT_CAPATH. --vault-capath string path to a directory of PEM-encoded CA certificate files on the local disk. These certificates are used to verify the Vault server's SSL certificate. --vault-client-cert string path to a PEM-encoded client certificate on the local disk. This file is used for TLS communication with the Vault server. --vault-client-key string path to an unencrypted, PEM-encoded private key on disk which corresponds to the matching client certificate. --vault-client-timeout duration timeout variable. The default value is 60s. --vault-max-retries int maximum number of retries when a 5xx error code is encountered. The default is 2, for three total attempts. Set this to 0 or less to disable retrying. --vault-skip-verify do not verify Vault's presented certificate before communicating with it. Setting this variable is not recommended and voids Vault's security model. --vault-tls-server-name string name to use as the SNI host when connecting via TLS. --vault-token string vault authentication token Use "influxd [command] --help" for more information about a command. 翻译并解析
最新发布
11-12
2. 若修改了 `--engine-path` 或 `--bolt-path`，需确保目录可读写。 3. 不同版本之间升级/降级需谨慎操作，建议先备份。 4. 生产环境务必关闭 `--e2e-testing`、`--pprof-disabled=false` 等调试功能。 ---
jdbc连接mysql数据库 几个时候后 空指针异常_jdbc连接数据库 Statement的executeQuery方法报空指针异常?...
weixin_34227128的博客
02-03 808
Connection conn = null;Statement stmt = null;ResultSet rs = null;String membertype = "";//登录用户类型try {StringBuffer sb = new StringBuffer();sb.append(" select membertype from m_b_broker where brokerid='...
uipath连接mysql数据库进行SQL语句
hotkoko的博客
05-14 2474
1、说明 有一些项目中可能会需要我们连接数据库去自动导入一些数据，或者定期从数据库插入、查询一些数据，这些也是可以通过UIpath实现的，UIpath提供了连接数据库的活动组件，若单纯的连接数据库，可以通过Connect活动组件，若要连接数据库之后执行SQL语句，可以直接使用Execute Non Query活动组件，以下内容将直接介绍Execute Non Query组件使用方法，因为已包含了连接数据库的内容 2、UIpath下载活动包UiPath.Datebase.Activities 3、在
Uipath 如何连接SQLite数据进行操作
xueying900的博客
06-20 752
在RPA流程设计中，处理数据来源时，一般都是通过把这些数据存储在根据一定规则命名的Excel或则CSV文件中，之后再根据文件名使用不同规则对这些文件中的数据做调整或者逻辑运算。如果使用SQLite来集中式的管理这些数据，只需要在前期设计好数据库，后期对数据的管理、使用都是比较便捷的。概念：SQLite是一种嵌入式关系型数据库管理系统，它以库的形式提供了一个完整的、无服务器的、零配置的、事务性的SQL数据库引擎。分类：SQLite属于关系型数据库管理系统（RDBMS）的一种，它支持标准的SQL查询语言。
JDBC中execute(), executeQuery()和executeUpdate()方法之间有什么区别？
allway2的博客
10-08 8737
和是JDBC API的接口的方法，用于执行SQL语句。
statement.executeQuery(sql)出错的一种排查方法
热门推荐
pinklatte的博客
05-28 1万+
在IDE里调试程序总是在执行SQL语句时报错（ps:如何定位错误？）,这是一件很头疼的事。 一种比较有效的方法是： （1）调用printf等输出函数，得到SQL语句 eg: String sql = "select * from suser where name='"+name+"' and password='"+psd+"';"; System.out.println(sql);//...
UiPath 管理参数
weixin_40498360的博客
10-23 818
参数用于将一个项目中的数据传递到另一个项目。在全局意义上，它们类似于变量，因为它们动态地存储和传递数据。变量在活动之间传递数据，而参数在自动化之间传递数据。因此，您可借助这些参数反复重用某些项目。 Studio 支持众多参数类型，这些参数类型均与变量类型一致。因此，您可以创建泛型值、字符串、布尔值、对象、数组或数据表参数，还可以浏览 .NET 类型，正如创建变量时一样。 此外，参数有特定方向（输入、输出、输入/输出、属性），这些方向告知应用程序其中存储的信息应前往何处。**** 请注意，如果您使用 I
mysql execute query_MySQL驱动阅读------executeQuery查询的过程，基于JDBC-----5.1.26
weixin_34732602的博客
01-19 723
Statement statement = connection.createStatement();final ResultSet resultSet = statement.executeQuery(String sql);上面两句是普通的查询过程，下面分析下驱动程序是如何进行查询和数据返回的，说明一下，本质上就是驱动程序通过Connection建立的TCP连接，将sql语句发送到MySQL服...
记录 UiPath 学习中遇到的一些问题以及解决办法
u011187194的专栏
05-27 1万+
记录学习UiPath遇到的一些问题以及解决办法
MySQL中限制查询超时时间
weixin_42124960的博客
02-13 3645
2 对单个的sql进行限制，select后面添加 /*+ MAX_EXECUTION_TIME(5000) (单位毫秒) 这种注解的方式，限制查询超时自动熔断。1、设置max_execution_time，当前系统的max_execution_time 值为0，表示不做任何限制，可以根据实际的情况设置合理的最大执行时间。某个复杂查询虽然前端QL的窗口关闭了，但实际SQL已经下发到数据库层去执行了，这种任然会对MySQL造成过大的压力。控制慢查询带来的性能开销,从而消除影响高峰期的服务质量的隐患.
[ERROR] Result: { execute timeout }异常解决
weixin_34342207的博客
12-21 882
阿里云ToolKit插件使用异常记录 ToolKit插件配置如下 RUN运行返回异常结果： [ERROR] Target Deploy ECS: { 172.18.*.* / 47.107.*.* } [ERROR] Command: { sh /home/service.sh service-* } [ERROR] Result: { execute...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值