18 January 2026:
Sahi Pro is an enterprise grade test automation platform which can automate web, mobile, API, windows and java based applications and SAP.
This forum is now archived and is in read-only mode. Please continue discussions on our improved new Sahi Pro Community forum.
Sahi Pro is an enterprise grade test automation platform which can automate web, mobile, API, windows and java based applications and SAP.
Question about SUITEREPORTID and SCRIPTREPORTID duplicated
khoa_nguyen
Members
Hi,
I've implemented a java program which contains 2 threads calling TestRunner class to execute the Sahi suite file. when I run my program, 2 threads run the same suite file at the same time, it seems to be the suite report ids and script report ids are sometime duplicately generated. Is there any way to config the SUITEREPORTID and SCRIPTREPORTID to avoid this situation? because It causes the following error when I try to view the db log:
WARNING: commandClass = >in.co.sahi.command.DBReports< commandMethod = >scriptRe
port<
Jun 17, 2014 2:33:28 PM net.sf.sahi.command.CommandExecuter execute
WARNING: java.lang.reflect.InvocationTargetException
at sun.reflect.GeneratedMethodAccessor3028.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at net.sf.sahi.command.CommandExecuter.execute(CommandExecuter.java:41)
at net.sf.sahi.LocalRequestProcessor.handleDyn(LocalRequestProcessor.jav
a:82)
at net.sf.sahi.LocalRequestProcessor.getLocalResponse(LocalRequestProces
sor.java:27)
at net.sf.sahi.ProxyProcessor.processLocally(ProxyProcessor.java:199)
at net.sf.sahi.ProxyProcessor.run(ProxyProcessor.java:68)
at java.lang.Thread.run(Unknown Source)
Caused by: org.h2.jdbc.JdbcSQLException: Scalar subquery contains more than one
row; SQL statement:
select * from SUITEREPORTS where SUITEREPORTID=(SELECT SUITEREPORTID from SCRIPT
REPORTS where SCRIPTREPORTID='db_ie__17Jun2014__14_10_33_557') [90053-159]
Thanks in advance,
Khoa
I've implemented a java program which contains 2 threads calling TestRunner class to execute the Sahi suite file. when I run my program, 2 threads run the same suite file at the same time, it seems to be the suite report ids and script report ids are sometime duplicately generated. Is there any way to config the SUITEREPORTID and SCRIPTREPORTID to avoid this situation? because It causes the following error when I try to view the db log:
WARNING: commandClass = >in.co.sahi.command.DBReports< commandMethod = >scriptRe
port<
Jun 17, 2014 2:33:28 PM net.sf.sahi.command.CommandExecuter execute
WARNING: java.lang.reflect.InvocationTargetException
at sun.reflect.GeneratedMethodAccessor3028.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at net.sf.sahi.command.CommandExecuter.execute(CommandExecuter.java:41)
at net.sf.sahi.LocalRequestProcessor.handleDyn(LocalRequestProcessor.jav
a:82)
at net.sf.sahi.LocalRequestProcessor.getLocalResponse(LocalRequestProces
sor.java:27)
at net.sf.sahi.ProxyProcessor.processLocally(ProxyProcessor.java:199)
at net.sf.sahi.ProxyProcessor.run(ProxyProcessor.java:68)
at java.lang.Thread.run(Unknown Source)
Caused by: org.h2.jdbc.JdbcSQLException: Scalar subquery contains more than one
row; SQL statement:
select * from SUITEREPORTS where SUITEREPORTID=(SELECT SUITEREPORTID from SCRIPT
REPORTS where SCRIPTREPORTID='db_ie__17Jun2014__14_10_33_557') [90053-159]
Thanks in advance,
Khoa