SongKong Jaikoz

SongKong and Jaikoz Music Tagger Community Forum

[solved] Windows 8: "Err:Table/ View 'RELEASEGROUP' does not exist.:ErrCode:20000:State:42X05"

Hi there,

I have been a paid Jaikoz user for several years now. I normally use Jaikoz on Linux. I just installed Jaikoz on my Windows 8 box for the first time, but I am unable to use it. I just installed Jaikoz per the instructions at http://www.jthink.net/jaikoz/jsp/download/installjaikozwindows.jsp . I am not sure how to proceed.

When I click on the icon, I get an error dialog box which says something like “Err:Table/
View ‘RELEASEGROUP’ does not exist.”

When I attempt to start Jaikoz from the commandline, I get several errors, and then the program hangs and never appears on the screen.

C:\\Program Files\\Jthink\\Jaikoz>jaikoz.bat
Oct 11, 2013 12:17:32 PM com.jthink.jaikoz.settings.LAF setLAF
INFO: Now LAF subvals are1:JAVA_1_6:Metal
Oct 11, 2013 12:17:33 PM com.jthink.jaikoz.settings.LAF setLAF
INFO: LAF is:26
debuglogfile is:C:\\Users\\Stefan Lasiewski/Jaikoz/Logs/jaikozdebug%u-%g.log
11/10/2013 12.17.41:com.jthink.acoustid.query.AbstractAcoustidQuery:performBasic
SubmissionQuery:SEVERE: Posting to url:http://api.acoustid.org/v2//user/lookup?f
ormat=xml&client=8XaBELgH&user=gKxPh1Mo
Fri Oct 11 12:17:44 PDT 2013 Thread[main,5,main] java.io.FileNotFoundException:
derby.log (Access is denied)
----------------------------------------------------------------
Fri Oct 11 12:17:44 PDT 2013:
Booting Derby version The Apache Software Foundation - Apache Derby - 10.8.2.2 -
 (1181258): instance a816c00e-0141-a8f3-fbc3-0000091ed4a8
on database directory C:\\Users\\Stefan Lasiewski\\Jaikoz\\jaikozdb  with class load
er sun.misc.Launcher$AppClassLoader@1b3e02ed
Loaded from file:/C:/Program%20Files/Jthink/Jaikoz/lib/derby.jar
java.vendor=Oracle Corporation
java.runtime.version=1.7.0_10-b18
user.dir=C:\\Program Files\\Jthink\\Jaikoz
derby.system.home=null
Database Class Loader started - derby.database.classpath=''
11/10/2013 12.17.46:com.jthink.jaikoz.db.Db:printSQLException:SEVERE: Err:Table/
View 'RELEASEGROUP' does not exist.:ErrCode:20000:State:42X05
11/10/2013 12.17.46:com.jthink.jaikoz.db.Db:printSQLException:SEVERE: Err:Table/
View 'RELEASEGROUP' does not exist.:ErrCode:20000:State:42X05
11/10/2013 12.17.46:com.jthink.jaikoz.MainWindow:setupWindow:SEVERE: java.sql.Ba
tchUpdateException: Table/View 'RELEASEGROUP' does not exist.
java.lang.RuntimeException: java.sql.BatchUpdateException: Table/View 'RELEASEGR
OUP' does not exist.
        at com.jthink.jaikoz.db.Db.emptyCache(Db.java:646)
        at com.jthink.jaikoz.db.Db.emptyAndPruneCache(Db.java:560)
        at com.jthink.jaikoz.MainWindow.setupFirstTimeOrUpgrade(MainWindow.java:
450)
        at com.jthink.jaikoz.MainWindow.setupWindow(MainWindow.java:311)
        at com.jthink.jaikoz.Start.main(Start.java:117)
Caused by: java.sql.BatchUpdateException: Table/View 'RELEASEGROUP' does not exi
st.
        at org.apache.derby.impl.jdbc.EmbedStatement.executeBatch(Unknown Source
)
        at com.mchange.v2.c3p0.impl.NewProxyStatement.executeBatch(NewProxyState
ment.java:743)
        at com.jthink.jaikoz.db.Db.emptyCache(Db.java:639)
        ... 4 more
Caused by: java.sql.SQLSyntaxErrorException: Table/View 'RELEASEGROUP' does not
exist.
        at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unkn
own Source)
        at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source
)
        at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException
(Unknown Source)
        at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Un
known Source)
        at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown So
urce)
        at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown So
urce)
        at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedStatement.executeBatchElement(Unknown
 Source)
        ... 7 more
Caused by: java.sql.SQLException: Table/View 'RELEASEGROUP' does not exist.
        at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknow
n Source)
        at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransport
AcrossDRDA(Unknown Source)
        ... 15 more
Caused by: ERROR 42X05: Table/View 'RELEASEGROUP' does not exist.
        at org.apache.derby.iapi.error.StandardException.newException(Unknown So
urce)
        at org.apache.derby.impl.sql.compile.FromBaseTable.bindTableDescriptor(U
nknown Source)
        at org.apache.derby.impl.sql.compile.FromBaseTable.bindNonVTITables(Unkn
own Source)
        at org.apache.derby.impl.sql.compile.FromList.bindTables(Unknown Source)

        at org.apache.derby.impl.sql.compile.SelectNode.bindNonVTITables(Unknown
 Source)
        at org.apache.derby.impl.sql.compile.DMLStatementNode.bindTables(Unknown
 Source)
        at org.apache.derby.impl.sql.compile.DeleteNode.bindStatement(Unknown So
urce)
        at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)

        at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
        at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepa
reInternalStatement(Unknown Source)
        ... 9 more
java.lang.RuntimeException: java.sql.BatchUpdateException: Table/View 'RELEASEGR
OUP' does not exist.
        at com.jthink.jaikoz.db.Db.emptyCache(Db.java:646)
        at com.jthink.jaikoz.db.Db.emptyAndPruneCache(Db.java:560)
        at com.jthink.jaikoz.MainWindow.setupFirstTimeOrUpgrade(MainWindow.java:
450)
        at com.jthink.jaikoz.MainWindow.setupWindow(MainWindow.java:311)
        at com.jthink.jaikoz.Start.main(Start.java:117)
Caused by: java.sql.BatchUpdateException: Table/View 'RELEASEGROUP' does not exi
st.
        at org.apache.derby.impl.jdbc.EmbedStatement.executeBatch(Unknown Source
)
        at com.mchange.v2.c3p0.impl.NewProxyStatement.executeBatch(NewProxyState
ment.java:743)
        at com.jthink.jaikoz.db.Db.emptyCache(Db.java:639)
        ... 4 more
Caused by: java.sql.SQLSyntaxErrorException: Table/View 'RELEASEGROUP' does not
exist.
        at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unkn
own Source)
        at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source
)
        at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException
(Unknown Source)
        at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Un
known Source)
        at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown So
urce)
        at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown So
urce)
        at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedStatement.executeBatchElement(Unknown
 Source)
        ... 7 more
Caused by: java.sql.SQLException: Table/View 'RELEASEGROUP' does not exist.
        at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknow
n Source)
        at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransport
AcrossDRDA(Unknown Source)
        ... 15 more
Caused by: ERROR 42X05: Table/View 'RELEASEGROUP' does not exist.
        at org.apache.derby.iapi.error.StandardException.newException(Unknown So
urce)
        at org.apache.derby.impl.sql.compile.FromBaseTable.bindTableDescriptor(U
nknown Source)
        at org.apache.derby.impl.sql.compile.FromBaseTable.bindNonVTITables(Unkn
own Source)
        at org.apache.derby.impl.sql.compile.FromList.bindTables(Unknown Source)

        at org.apache.derby.impl.sql.compile.SelectNode.bindNonVTITables(Unknown
 Source)
        at org.apache.derby.impl.sql.compile.DMLStatementNode.bindTables(Unknown
 Source)
        at org.apache.derby.impl.sql.compile.DeleteNode.bindStatement(Unknown So
urce)
        at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)

        at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
        at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepa
reInternalStatement(Unknown Source)
        ... 9 more

Hi, please follow instructions for issue 1 of http://www.jthink.net/jaikozforum/posts/list/1246.page and that will fix this, strange that it happened on a new install though.

That worked! Thanks again Paul!