Ticket # 25

This ticket is open
Severity: Critical
Entered by: sudhagar k 1/16/2008, 7:06 AM
Last modified: sudhagar k 1/16/2008, 7:06 AM

Description

i downloaded the latest source from https://svn.centricsuite.com/webapp/branches/branch-50-community/
i completed the ant build and deploy.copy successfully.But
I found many errors with the build.xml,when i ran the
ant installdb. The build.xml file has mismatch of the src/sql/mssql/sql queries.

I could not able to find
1. New_emails_account. sql
2. New_graph.sql

Files from the src/sql/mssql source folder.
And the error is

install.database:
[echo] Building database
[sql] Executing resource: D:\HiQCRM latest 5.0\src\sql\mssql\new_cdb.sql
[sql] Executing resource: D:\HiQCRM latest 5.0\src\sql\mssql\new_opportunity.sql
[sql] Executing resource: D:\HiQCRM latest 5.0\src\sql\mssql\new_project.sql
[sql] Executing resource: D:\HiQCRM latest 5.0\src\sql\mssql\new_product.sql
[sql] Executing resource: D:\HiQCRM latest 5.0\src\sql\mssql\new_service_contract.sql
[sql] Executing resource: D:\HiQCRM latest 5.0\src\sql\mssql\new_tms.sql
[sql] Executing resource: D:\HiQCRM latest 5.0\src\sql\mssql\new_quote.sql
[sql] Executing resource: D:\HiQCRM latest 5.0\src\sql\mssql\new_order.sql
[sql] Executing resource: D:\HiQCRM latest 5.0\src\sql\mssql\new_custom_field.sql
[sql] Executing resource: D:\HiQCRM latest 5.0\src\sql\mssql\new_campaign.sql
[sql] Executing resource: D:\HiQCRM latest 5.0\src\sql\mssql\new_help.sql
[sql] Executing resource: D:\HiQCRM latest 5.0\src\sql\mssql\new_sync.sql
[sql] Executing resource: D:\HiQCRM latest 5.0\src\sql\mssql\new_autoguide.sql
[sql] Executing resource: D:\HiQCRM latest 5.0\src\sql\mssql\new_email_account.sql

BUILD FAILED

D:\HiQCRM latest 5.0\build.xml:1463: java.io.FileNotFoundException: D:\HiQCRM latest 5.0\src\sql\mssql\new_email_account.sql (The system cannot find the file specified)
at org.apache.tools.ant.taskdefs.SQLExec.execute(SQLExec.java:451)
at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:105)
at org.apache.tools.ant.Task.perform(Task.java:348)
at org.apache.tools.ant.Target.execute(Target.java:357)
at org.apache.tools.ant.Target.performTasks(Target.java:385)
at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1329)
at org.apache.tools.ant.Project.executeTarget(Project.java:1298)
at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
at org.apache.tools.ant.Project.executeTargets(Project.java:1181)
at org.apache.tools.ant.Main.runBuild(Main.java:698)
at org.apache.tools.ant.Main.startAnt(Main.java:199)
at org.apache.tools.ant.launch.Launcher.run(Launcher.java:257)
at org.apache.tools.ant.launch.Launcher.main(Launcher.java:104)
Caused by: java.io.FileNotFoundException: D:\HiQCRM latest 5.0\src\sql\mssql\new_email_account.sql (The system cannot find the file specified)
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.<init>(FileInputStream.java:106)
at org.apache.tools.ant.types.resources.FileResource.getInputStream(FileResource.java:185)
at org.apache.tools.ant.taskdefs.SQLExec$Transaction.runTransaction(SQLExec.java:777)
at org.apache.tools.ant.taskdefs.SQLExec$Transaction.access$000(SQLExec.java:707)
at org.apache.tools.ant.taskdefs.SQLExec.execute(SQLExec.java:438)
... 16 more
--- Nested Exception ---
java.io.FileNotFoundException: D:\HiQCRM latest 5.0\src\sql\mssql\new_email_account.sql (The system cannot find the file specified)
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.<init>(FileInputStream.java:106)
at org.apache.tools.ant.types.resources.FileResource.getInputStream(FileResource.java:185)
at org.apache.tools.ant.taskdefs.SQLExec$Transaction.runTransaction(SQLExec.java:777)
at org.apache.tools.ant.taskdefs.SQLExec$Transaction.access$000(SQLExec.java:707)
at org.apache.tools.ant.taskdefs.SQLExec.execute(SQLExec.java:438)
at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:105)
at org.apache.tools.ant.Task.perform(Task.java:348)
at org.apache.tools.ant.Target.execute(Target.java:357)
at org.apache.tools.ant.Target.performTasks(Target.java:385)
at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1329)
at org.apache.tools.ant.Project.executeTarget(Project.java:1298)
at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
at org.apache.tools.ant.Project.executeTargets(Project.java:1181)
at org.apache.tools.ant.Main.runBuild(Main.java:698)
at org.apache.tools.ant.Main.startAnt(Main.java:199)
at org.apache.tools.ant.launch.Launcher.run(Launcher.java:257)
at org.apache.tools.ant.launch.Launcher.main(Launcher.java:104)

Solution

A solution hasn't been entered

File Attachments

There are no file attachments

Ticket Activity

Date	Event
sudhagar k 1/16/2008, 7:06 AM	[ Ticket Opened ]
sudhagar k 1/16/2008, 7:06 AM	[ Ticket is unassigned ]
sudhagar k 1/16/2008, 7:06 AM	[ Severity set to Critical ]

Distribution List
sudhagar k., Mauricio C., Ricardo M.