Re: Is there a way to Copy/Replicate tasks in XPlanner. How about an import?
<gyanapalam-email-/[email protected]> Fri, 29 Sep 2006 19:29:35 -0700 (PDT)
| Newsgroups | gmane.comp.java.xplanner.devel |
|---|---|
| Message-ID | <[email protected]> |
Thank you Jaques for your reply. Jacques Morel <[email protected]> wrote: Shankar, Sorry for responding so late. There is no way to copy tasks. Direct SQL will have to take care of incrementing the identifier table. Good luck Jacques On 8/28/06, gyanapalam-email-/[email protected] <gyanapalam-email-/[email protected]> wrote: Hi There, I have a certain known tasks that are common to certain developer/acceptor groups. Is there a way to copy tasks in XPlanner. I know, I can do it by doing a SQL data import to task table. Will the IDs and timestamp generated will maintain integrity? It is a planned or unplanned feature. I don't see this common feature available. Is there a way to import tasks like user stories? Regards, (Shankar .P) xplanner-devel-request-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org wrote: Send Xplanner-devel mailing list submissions to [email protected] To subscribe or unsubscribe via the World Wide Web, visit https://lists.sourceforge.net/lists/listinfo/xplanner-devel or, via email, send a message with subject or body 'help' to xplanner-devel-request-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org You can reach the person managing the list at xplanner-devel-owner-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org When replying, please edit your Subject line so it is more specific than "Re: Contents of Xplanner-devel digest..." Today's Topics: 1. Re: XPlanner 0.7b7 throws SQLException during setup. Patch Scripts wont install (Jacques Morel) 2. Re: XPlanner 0.7b7 throws SQLException during setup. Patch Scripts wont install (gyanapalam-email-/[email protected] ) ---------------------------------------------------------------------- Message: 1 Date: Fri, 25 Aug 2006 03:37:34 -0500 From: "Jacques Morel" Subject: Re: [Xplanner-devel] XPlanner 0.7b7 throws SQLException during setup. Patch Scripts wont install To: gyanapalam-email-/[email protected] , [email protected] Message-ID: <2ae5715c0608250137p7e2003d1ra07fc4ff1397bc48-JsoAwUIsXosN+BqQ9rBEUg@public.gmane.org> Content-Type: text/plain; charset="iso-8859-1" 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] 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 > > > -------------- next part -------------- An HTML attachment was scrubbed... URL: http://sourceforge.net/mailarchive/forum.php?forum=xplanner-devel/attachments/20060825/2c698392/attachment.html ------------------------------ Message: 2 Date: Fri, 25 Aug 2006 07:08:17 -0700 (PDT) From: Subject: Re: [Xplanner-devel] XPlanner 0.7b7 throws SQLException during setup. Patch Scripts wont install To: Jacques Morel , [email protected] Message-ID: <20060825140817.58210.qmail-Mz9BxYqd2bKvuULXzWHTWIglqE1Y4D90QQ4Iyu8u01E@public.gmane.org > Content-Type: text/plain; charset="iso-8859-1" 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 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] 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 -------------- next part -------------- An HTML attachment was scrubbed... URL: http://sourceforge.net/mailarchive/forum.php?forum=xplanner-devel/attachments/20060825/a200e746/attachment.html ------------------------------ ------------------------------------------------------------------------- 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 End of Xplanner-devel Digest, Vol 3, Issue 9 ******************************************** ------------------------------------------------------------------------- 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 ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys -- and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Xplanner-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/xplanner-devel