Re: XPlanner 0.7b7 throws SQLException during setup. Patch Scripts wont install

Hi,
  My issue is resolved after dropping and recreating xplanner database and some tweaks(anyway it was my first xplanner DB setup. I was trying various combinations after looking at the log. Atlast the database reinitialization worked. I had posted the detailed message but the mailing list bounces back saying the message content is larger than 60 KB. )
      Message body is too big: 131571 bytes with a limit of 60 KB
   
  I guess xplanner patch upgrade scripts have some problem applying patch to a partially setup database(due to tomcat deploy errors) 

  Answers to your questions:
  What database are your running? MySql 5.x(Oracle didn't work has issues with 10g Driver for Oracle 9i DB)
What version are you upgrading from or is it a brand new install?None,Brand New. The DB Scripts in XPlanner is written to setup the old schema and upgrade[I find it from Tomcat log]. 
What package are you trying to install? I was just letting the deployer setup the packages
Have you followed the steps in the README.txt in respect to setting xplanner-customer.properties properly? Yes. Could you dump it here?
  *********************** XPLANNER INFO ************************ Build: Version: 0.7b7 Build Date: 05/24/2006 Build Revision: 1149 Build Package: War Database: Dialect: com.technoetic.xplanner.db.hibernate.XPlannerMySQLDialect Driver: com.mysql.jdbc.Driver Driver Version: mysql-connector-java-3.1.12 ( $Date: 2005-11-17 15:53:48 +0100 (Thu, 17 Nov 2005) $, $Revision$ ) Database Vendor: MySQL Database Version: 5.0.24-community-nt Database Name: xplanner Database Url: jdbc:mysql://localhost/xplanner Database User Name: xplanner Database User Password: ****** Database Patch Level: 3 App Server: Application Server: Apache Tomcat/5.5.12 Servlet Version: 2.4 System: System Date: Aug 23, 2006 System Time: 3:11:54 PM Current directory: C:\apache-tomcat-5.5.12\bin Java Version: 1.5.0_04 Java Vendor: Sun Microsystems Inc. JVM Version: 1.0 JVM Vendor: Sun Microsystems Inc. JVM Implementation Version: 1.5.0_04-b05 Java Runtime: Java(TM) 2 Runtime Environment, Standard Edition Java VM:
 Java HotSpot(TM) Client VM User Name: spattabi User Timezone: America/Chicago Operating System: Windows XP 5.1 OS Architecture: x86 [ 12784] INFO - work.web.context.ContextLoader - Using context class [org.springframework.web.context.support.XmlWebApplicationContext] for root WebApplicationContext [ 12800] INFO - work.web.context.ContextLoader - Root WebApplicationContext: initialization completed in 12550 ms [ 14112] INFO - til.migration.MigrationProcess - Running migration task "patch0004_0-6-2_to_0-7b1_A.sql [com.tacitknowledge.util.migration.jdbc.SqlScriptMigrationTask]"... [ 15160] ERROR - on.jdbc.SqlScriptMigrationTask - patch0004_0-6-2_to_0-7b1_A.sql: Error running SQL "/* Purge unattached notes */ CREATE temporary table tempnote AS select n.id, n.attachment_id from note n left join project p on n.attachedTo_id = p.id left join iteration i on n.attachedTo_id = i.id left join story s on n.attachedTo_id = s.id left join task t on n.attachedTo_id = t.id where p.id is
 null and i.id is null and s.id is null and t.id is null" java.sql.SQLException: Unknown database 'xplanner' at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571

-Shankar .P
Jacques Morel <[email protected]> wrote:
  A little bit more information would be critical here to diagnose the problem.
Are you a developer yourself? Put yourself in my shoes and then ask yourself what information would you needed in order to troubleshoot your problem? 
THEN write the email to request support. That will save everybody some time!

Also a little bit of courtesy would be nice... A thank sometimes makes a world of difference when you do not pay for support.

So now back to business:
What database are your running?
What version are you upgrading from or is it a brand new install?
What package are you trying to install?
Have you followed the steps in the README.txt in respect to setting xplanner-customer.properties properly? Could you dump it here?

Jacques

  On 8/24/06, gyanapalam-email-/[email protected] <gyanapalam-email-/[email protected]> wrote:    [  16796]  ERROR - on.jdbc.SqlScriptMigrationTask - patch0004_0-6-2_to_0-7b1_A.sql: Error running SQL "SELECT @id:=next FROM identifier"                                  java.sql.SQLException: Unknown column 'next' in 'field list'                                 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)                        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)                             at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)                          at com.mysql.jdbc.Connection.execSQL(Connection.java :2988)                           at com.mysql.jdbc.Connection.execSQL(Connection.java:2917)                           at com.mysql.jdbc.Statement.execute(Statement.java:529)                              at com.tacitknowledge.util.migration.jdbc.SqlScriptMigrationTask.migrate(SqlScriptMigrationTask.java:124)                             
                                    at com.tacitknowledge.util.migration.MigrationProcess.doMigrations(MigrationProcess.java:162)                                                                             at com.tacitknowledge.util.migration.jdbc.JdbcMigrationLauncher.doMigrations(JdbcMigrationLauncher.java:288)                                                              at com.tacitknowledge.util.migration.jdbc.JdbcMigrationLauncher.doMigrations (JdbcMigrationLauncher.java:108)                                                      


    Shankar S. Pattabiraman,
  Sr.Software Engineer
  Applied Biosystems,Silicon Valley
  Address:
  3770 Flora Vista Ave,#903
  Santa Clara, USA.
  Res: 408-985-7131,
  Mobie: 408-623-7230



-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier 
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642

_______________________________________________
Xplanner-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/xplanner-devel

-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642

_______________________________________________
Xplanner-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/xplanner-devel