[Logo] Jaikoz and SongKong Forums
  [Search] Search   [Recent Topics] Recent Topics   [Members]  Member Listing   [Groups] Back to home page 
[Register] Register / 
[Login] Login 
[solved] Windows 8: "Err:Table/ View 'RELEASEGROUP' does not exist.:ErrCode:20000:State:42X05"  XML
Forum Index -> Jaikoz Issues
Author Message
gigglesworth



Joined: 29/06/2007 11:15:40
Messages: 3
Offline

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.

Code:
 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
 

stefanco.com
[WWW]
paultaylor

Pro
[Avatar]

Joined: 21/08/2006 09:21:27
Messages: 7208
Offline

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.

thanks Paul (Administrator)
gigglesworth



Joined: 29/06/2007 11:15:40
Messages: 3
Offline

That worked! Thanks again Paul!

stefanco.com
[WWW]
 
Forum Index -> Jaikoz Issues
Go to:   
Powered by JForum 2.1.6 © JForum Team