Test database performance tool does not run

[serge calderara]

Dear all,

We would like to run a db test performance on our jira instance by following the given document below :
Test Db performance 

When executing the command strictly as define in this document for our SQL server db it does not output anything in the file

Command :
java -cp ./atlassian-log-analysis-0.1.1.jar:/opt/atlassian/jira/lib/mssql-jdbc-9.2.1.jre8.jar \
com.atlassian.util.benchmark.JIRASQLPerformance \
user password \
'<url entry of the dbconfig file>' \

<driver name> \
> db-perf-test.txt

When test start to execute we get an exception error as below and output file is 0kb

Exception in thread "main" com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'jiraissue'.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:262)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1632)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:602)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:524)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7418)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:3272)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:247)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:222)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:446)
at com.atlassian.util.benchmark.JIRASQLPerformance.getTests(JIRASQLPerformance.java:92)
at com.atlassian.util.benchmark.JIRASQLPerformance.call(JIRASQLPerformance.java:80)
at com.atlassian.util.benchmark.JIRASQLPerformance.main(JIRASQLPerformance.java:61)

Any of you met the same issue ?

Note that jira db structure use jiraschema and not dbo, I am wondering if the test tool is working with schema other than dbo

regards

[serge calderara · Accepted solution]

This tool is not working with schema other than DBO