| T O P I C R E V I E W |
| ken.lam@mobigator.com |
Posted - 14/12/2011 : 19:23:44
Dear all,
If you want to use the latest CMS3X source code + Grails 1.3.5. Please go through the following steps.
1. Modify grails 1.3.5 package
Edit ${GRAILS_HOME}/scripts/_GrailsClasspath.groovy
Add the following codes inside the commonClasspath closure:
// ********* START
resolveResources("file:${basedir}/src/groovy").each{
pathelement(location: it.file.absolutePath)
}
resolveResources("file:${basedir}/src/java").each{
pathelement(location: it.file.absolutePath)
}
// ********* END
2. Remove ".grails" folder in your Windows user profile location (C:\Documents and Settings\<username>\.grails for XP or C:\Users\.....
for Vista or 7 or 2008).
If you need any help, please feel free to contact us.
CMS Support Team
Mobigator Technology Group
cms-support@mobigator.com
http://www.mobigator.com |
| 4 L A T E S T R E P L I E S (Newest First) |
| wael.tanoukhi@me-iss.com |
Posted - 20/12/2011 : 04:44:27
Dear David,
by running, grails clean, then twice grails run-app, it is working now the server is running, however the client cannot connect to the server giving the following error:
------------------- LOG BEGIN ---------------------------
Server running. Browse to http://localhost:8080/CMS3
2011-12-20 00:33:36,609 [http-8080-1] ERROR errors.GrailsExceptionResolver - Error executing tag <jawr:script>: Cannot invoke method getConfig() on n
ull object at C:/CMS3.10937.1/grails-app/views/layouts/main_login.gsp:8
org.codehaus.groovy.grails.web.taglib.exceptions.GrailsTagException: Error executing tag <jawr:script>: Cannot invoke method getConfig() on null objec
t at C:/CMS3.10937.1/grails-app/views/layouts/main_login.gsp:8
at C__CMS3_10937_1_grails_app_views_layouts_main_login_gsp$_run_closure1.doCall(C__CMS3_10937_1_grails_app_views_layouts_main_login_gsp:28)
at C__CMS3_10937_1_grails_app_views_layouts_main_login_gsp$_run_closure1.doCall(C__CMS3_10937_1_grails_app_views_layouts_main_login_gsp)
at C__CMS3_10937_1_grails_app_views_layouts_main_login_gsp.run(C__CMS3_10937_1_grails_app_views_layouts_main_login_gsp:35)
at org.jsecurity.web.servlet.JSecurityFilter.doFilterInternal(JSecurityFilter.java:382)
at org.jsecurity.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:180)
at java.lang.Thread.run(Thread.java:662)
Caused by: java.lang.NullPointerException: Cannot invoke method getConfig() on null object
at JawrTagLib$_closure1.doCall(JawrTagLib.groovy:34)
... 6 more
------------------------ END of LOG ----------------------
The client is configured correctly using the port 8080 and localhost.
looking forward to hear back from you ..
Regards,
Ihab
|
| david.chow@mobigator.com |
Posted - 15/12/2011 : 14:21:12
Hi,
In our testing, you need to run "grails run-app" two times after "grails clean". So, I suggest you to do the following
1. Use the clean CMS3X database which you can find in the installer ({installer_path}\mysql\cms3.sql)
2. type "grails clean" in your CMS3X app. folder
3. grails run-app
i.e. you should get the following error after run the command
org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; SQL [select count(*) as y0_ from user this_]; nested excepti
on is org.hibernate.exception.SQLGrammarException: could not execute query
4. grails run-app
Please let us know if you have any problem
|
| wael.tanoukhi@me-iss.com |
Posted - 15/12/2011 : 12:40:57
If we make the changes as follow:
********************************** START *********************************
commonClasspath = {
def grailsDir = resolveResources("file:${basedir}/grails-app/*")
for (d in grailsDir) {
pathelement(location: "${d.file.absolutePath}")
resolveResources("file:${basedir}/src/groovy").each{
pathelement(location: it.file.absolutePath)
}
resolveResources("file:${basedir}/src/java").each{
pathelement(location: it.file.absolutePath)
}
}
def pluginLibDirs = pluginSettings.pluginLibDirectories.findAll { it.exists() }
for (pluginLib in pluginLibDirs) {
fileset(dir: pluginLib.file.absolutePath)
}
}
*********************************************** END ***************************************
Then the error log is the following
**************** ERROR LOG ****************
[groovyc] Compiling 208 source files to C:\Documents and Settings\dev\.grails\1.3.5\projects\CMS3.10937.1\classes
Note: C:\CMS3.10937.1\src\java\ZipFramework\DOSDateTime.java uses or overrides a deprecated API.
Note: Recompile with -Xlint:deprecation for details.
Unable to load specified config location classpath:datasource.properties : class path resource [datasource.properties] cannot be opened because it does not exist
Unable to load specified config location classpath:config.properties : class path resource [config.properties] cannot be opened because it does not exist
[mkdir] Created dir: C:\CMS3.10937.1\resources\grails-app\i18n
[native2ascii] Converting 5 files from C:\CMS3.10937.1\grails-app\i18n to C:\CMS3.10937.1\resources\grails-app\i18n
[mkdir] Created dir: C:\CMS3.10937.1\resources\plugins\hkma-ih-service-ehs-1.0\grails-app\i18n
[mkdir] Created dir: C:\CMS3.10937.1\resources\plugins\jasper-0.9\grails-app\i18n
[mkdir] Created dir: C:\CMS3.10937.1\resources\plugins\crypto-1.0.1\grails-app\i18n
[native2ascii] Converting 2 files from C:\CMS3.10937.1\plugins\jasper-0.9\grails-app\i18n to C:\CMS3.10937.1\resources\plugins\jasper-0.9\grails-app\i18n
[native2ascii] Converting 1 file from C:\CMS3.10937.1\plugins\crypto-1.0.1\grails-app\i18n to C:\CMS3.10937.1\resources\plugins\crypto-1.0.1\grails-app\i18n
[mkdir] Created dir: C:\CMS3.10937.1\resources\plugins\hkma-ih-service-1.0\grails-app\i18n
[mkdir] Created dir: C:\CMS3.10937.1\resources\plugins\hkma-ih-service-ceno-1.0\grails-app\i18n
[mkdir] Created dir: C:\CMS3.10937.1\resources\plugins\image-tools-1.0.2\grails-app\i18n
[native2ascii] Converting 1 file from C:\CMS3.10937.1\plugins\image-tools-1.0.2\grails-app\i18n to C:\CMS3.10937.1\resources\plugins\image-tools-1.0.2\grails-app\i18n
[mkdir] Created dir: C:\CMS3.10937.1\resources\plugins\quartz-0.4.1-SNAPSHOT\grails-app\i18n
[mkdir] Created dir: C:\CMS3.10937.1\resources\plugins\jsecurity-0.3\grails-app\i18n
[native2ascii] Converting 1 file from C:\CMS3.10937.1\plugins\quartz-0.4.1-SNAPSHOT\grails-app\i18n to C:\CMS3.10937.1\resources\plugins\quartz-0.4.1-SNAPSHOT\grails-app\i18n
[native2ascii] Converting 1 file from C:\CMS3.10937.1\plugins\jsecurity-0.3\grails-app\i18n to C:\CMS3.10937.1\resources\plugins\jsecurity-0.3\grails-app\i18n
[mkdir] Created dir: C:\CMS3.10937.1\resources\plugins\searchable-0.5\grails-app\i18n
[native2ascii] Converting 1 file from C:\CMS3.10937.1\plugins\searchable-0.5\grails-app\i18n to C:\CMS3.10937.1\resources\plugins\searchable-0.5\grails-app\i18n
[copy] Copying 1 file to C:\Documents and Settings\dev\.grails\1.3.5\projects\CMS3.10937.1\classes
[copy] Copying 6 files to C:\CMS3.10937.1\resources
[copy] Copied 2 empty directories to 2 empty directories under C:\CMS3.10937.1\resources
[copy] Copying 1 file to C:\CMS3.10937.1\resources
[copy] Copied 1 empty directory to 1 empty directory under C:\CMS3.10937.1\resources
[copy] Copying 1 file to C:\Documents and Settings\dev\.grails\1.3.5\projects\CMS3.10937.1
Running Grails application..
2011-12-15 08:58:53,312 [quartzScheduler_Worker-1] ERROR listeners.ExceptionPrinterJobListener - Sanitizing stacktrace:
- Exception occured in job: GRAILS_JOBS.CleanWaitingQueueJob
org.quartz.JobExecutionException: could not execute query [See nested exception: org.hibernate.exception.SQLGrammarException: could not execute query]
at org.codehaus.groovy.grails.plugins.quartz.GrailsJobFactory$GrailsTaskClassJob.execute(GrailsJobFactory.java:80)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.loader.Loader.doList(Loader.java:2231)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2125)
at org.hibernate.loader.Loader.list(Loader.java:2120)
at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:118)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1596)
at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:306)
at grails.orm.HibernateCriteriaBuilder.invokeMethod(HibernateCriteriaBuilder.java:1163)
at groovy.lang.GroovyObject$invokeMethod$0.call(Unknown Source)
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:40)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:116)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:128)
at org.codehaus.groovy.grails.plugins.orm.hibernate.HibernatePluginSupport$_addQueryMethods_closure53.doCall(HibernatePluginSupport.groovy:692)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:88)
at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:233)
at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1058)
at groovy.lang.ExpandoMetaClass.invokeMethod(ExpandoMetaClass.java:1070)
at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:886)
at groovy.lang.Closure.call(Closure.java:276)
at org.codehaus.groovy.runtime.metaclass.ClosureStaticMetaMethod.invoke(ClosureStaticMetaMethod.java:59)
at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:233)
at groovy.lang.MetaClassImpl.invokeStaticMethod(MetaClassImpl.java:1302)
at groovy.lang.ExpandoMetaClass.invokeStaticMethod(ExpandoMetaClass.java:1082)
at groovy.lang.MetaObjectProtocol$invokeStaticMethod.call(Unknown Source)
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:40)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:116)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:132)
at org.codehaus.groovy.grails.plugins.orm.hibernate.HibernatePluginSupport$_enhanceSessionFactory_closure14.doCall(HibernatePluginSupport.groovy:382)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:88)
at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:233)
at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1058)
at groovy.lang.ExpandoMetaClass.invokeMethod(ExpandoMetaClass.java:1070)
at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:886)
at groovy.lang.Closure.call(Closure.java:276)
at org.codehaus.groovy.runtime.metaclass.ClosureStaticMetaMethod.invoke(ClosureStaticMetaMethod.java:59)
at groovy.lang.MetaClassImpl.invokeStaticMissingMethod(MetaClassImpl.java:1355)
at groovy.lang.MetaClassImpl.invokeStaticMethod(MetaClassImpl.java:1343)
at groovy.lang.ExpandoMetaClass.invokeStaticMethod(ExpandoMetaClass.java:1082)
at org.codehaus.groovy.runtime.callsite.StaticMetaClassSite.call(StaticMetaClassSite.java:50)
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:40)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:116)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:124)
at WaitingQueue$__clinit__closure9.doCall(WaitingQueue.groovy:123)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.codehaus.groovy.runtime.callsite.PogoMetaMethodSite$PogoCachedMethodSite.invoke(PogoMetaMethodSite.java:225)
at org.codehaus.groovy.runtime.callsite.PogoMetaMethodSite.callCurrent(PogoMetaMethodSite.java:51)
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallCurrent(CallSiteArray.java:44)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(AbstractCallSite.java:141)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(AbstractCallSite.java:149)
at WaitingQueue$__clinit__closure9.doCall(WaitingQueue.groovy)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:88)
at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:233)
at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1058)
at groovy.lang.ExpandoMetaClass.invokeMethod(ExpandoMetaClass.java:1070)
at groovy.lang.MetaClassImpl.invokeStaticClosureProperty(MetaClassImpl.java:1349)
at groovy.lang.MetaClassImpl.invokeStaticMethod(MetaClassImpl.java:1312)
at groovy.lang.ExpandoMetaClass.invokeStaticMethod(ExpandoMetaClass.java:1082)
at org.codehaus.groovy.runtime.callsite.StaticMetaClassSite.call(StaticMetaClassSite.java:50)
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:40)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:116)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:120)
at CleanWaitingQueueJob.execute(CleanWaitingQueueJob.groovy:28)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:186)
at org.springframework.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:171)
at org.codehaus.groovy.grails.plugins.quartz.GrailsJobFactory$GrailsTaskClassJob.execute(GrailsJobFactory.java:76)
... 2 more
Caused by: java.sql.SQLException: Table not found in statement [select this_.id as id67_1_, this_.version as version67_1_, this_.arrive_time as arrive
3_67_1_, this_.book_end_time as book4_67_1_, this_.book_time as book5_67_1_, this_.called_back as called6_67_1_, this_.doctor_id as doctor7_67_1_, thi
s_.encounter_id as encounter8_67_1_, this_.group_id as group9_67_1_, this_.last_updated as last10_67_1_, this_.patient_id as patient11_67_1_, this_.pr
iority_id as priority12_67_1_, this_.remarks as remarks67_1_, this_.status_id as status14_67_1_, status_ali1_.id as id71_0_, status_ali1_.version as v
ersion71_0_, status_ali1_.label as label71_0_ from waiting_queue this_ left outer join queue_status_enum status_ali1_ on this_.status_id=status_ali1_.
id where (status_ali1_.label=?) and this_.book_time<?]
at org.hsqldb.jdbc.Util.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy$TransactionAwareInvocationHandler.invoke(TransactionAwareDataSourceProxy.java:229)
at $Proxy11.prepareStatement(Unknown Source)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452)
at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1573)
at org.hibernate.loader.Loader.doQuery(Loader.java:696)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
at org.hibernate.loader.Loader.doList(Loader.java:2228)
... 84 more
2011-12-15 08:58:53,359 [main] ERROR context.GrailsContextLoader - Error executing bootstraps: could not execute query; SQL [select count(*) as y0_ f
rom user this_]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query
org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; SQL [select count(*) as y0_ from user this_]; nested excepti
on is org.hibernate.exception.SQLGrammarException: could not execute query
at BootStrap$_closure1.doCall(BootStrap.groovy:27)
at grails.util.Environment.evaluateEnvironmentSpecificBlock(Environment.java:251)
at grails.util.Environment.executeForEnvironment(Environment.java:244)
at grails.util.Environment.executeForCurrentEnvironment(Environment.java:220)
at org.grails.tomcat.TomcatServer.start(TomcatServer.groovy:212)
at grails.web.container.EmbeddableServer$start.call(Unknown Source)
at RunApp$_run_closure5_closure12.doCall(RunApp:158)
at RunApp$_run_closure5_closure12.doCall(RunApp)
at RunApp$_run_closure10.doCall(RunApp:280)
at RunApp$_run_closure10.call(RunApp)
at RunApp$_run_closure5.doCall(RunApp:149)
at RunApp$_run_closure5.call(RunApp)
at RunApp.runInline(RunApp:116)
at RunApp.this$4$runInline(RunApp)
at RunApp$_run_closure1.doCall(RunApp:59)
at RunApp$_run_closure1.doCall(RunApp.groovy:33)
at gant.Gant$_dispatch_closure5.doCall(Gant.groovy:381)
at gant.Gant$_dispatch_closure7.doCall(Gant.groovy:415)
at gant.Gant$_dispatch_closure7.doCall(Gant.groovy)
at gant.Gant.withBuildListeners(Gant.groovy:427)
at gant.Gant.this$2$withBuildListeners(Gant.groovy)
at gant.Gant$this$2$withBuildListeners.callCurrent(Unknown Source)
at gant.Gant.dispatch(Gant.groovy:415)
at gant.Gant.this$2$dispatch(Gant.groovy)
at gant.Gant.invokeMethod(Gant.groovy)
at gant.Gant.executeTargets(Gant.groovy:590)
at gant.Gant.executeTargets(Gant.groovy:589)
Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
at $Proxy13.doInHibernate(Unknown Source)
... 27 more
Caused by: java.sql.SQLException: Table not found in statement [select count(*) as y0_ from user this_]
at org.hsqldb.jdbc.Util.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
at $Proxy11.prepareStatement(Unknown Source)
... 28 more
Application context shutting down...
Application context shutdown.
C:\CMS3.10937.1>
************************ ERROR LOG *********************************************** |
| wael.tanoukhi@me-iss.com |
Posted - 15/12/2011 : 12:13:07
Dear Support,
After doing the above mentioned modification, modifying the file "GrailsClasspath.groovy" as follows:
*************** GrailsClasspath.groovy modification ***********
commonClasspath = {
def grailsDir=resolveResources("file:${basedir}/src/groovy").each{
pathelement(location: it.file.absolutePath)
}
resolveResources("file:${basedir}/src/java").each{
pathelement(location: it.file.absolutePath)
}
def pluginLibDirs = pluginSettings.pluginLibDirectories.findAll { it.exists() }
for (pluginLib in pluginLibDirs) {
fileset(dir: pluginLib.file.absolutePath)
}
}
********************GrailsClasspath.groovy *****************
We are getting the following error now:
*************** ERROR LOG START ****************
C:\CMS3.10937.2>Grails app run
Welcome to Grails 1.3.5 - http://grails.org/
Licensed under Apache Standard License 2.0
Grails home is set to: C:\Grails\grails-1.3.5
Base Directory: C:\CMS3.10937.2
Resolving dependencies...
Dependencies resolved in 1063ms.
Running pre-compiled script
Script 'App' not found, did you mean:
1) RunApp
2) TestApp
3) CreateApp_
4) Bootstrap
5) CreateLdapRealm
Please make a selection or enter Q to quit: 1
Environment set to null
[groovyc] Compiling 1 source file to C:\Documents and Settings\dev\.grails\1.3.5\projects\CMS3.10937.2\classes
[copy] Copying 1 file to C:\Documents and Settings\dev\.grails\1.3.5\projects\CMS3.10937.2
[delete] Deleting directory C:\Documents and Settings\dev\.grails\1.3.5\projects\CMS3.10937.2\tomcat
Running Grails application..
Dec 15, 2011 8:21:04 AM groovy.sql.Sql execute
WARNING: Failed to execute: Create View mtg_bill_detail_view as select `bill_detail`.`billed_amount` AS `billed_amount`,cast(`encounter`.`date_created
` as date) AS `date_created`,year(`encounter`.`date_created`) AS `yy`,month(`encounter`.`date_created`) AS `mm`,`month_mapping`.`eng` AS `eng`,dayofmo
nth(`encounter`.`date_created`) AS `dd`,`encounter`.`bill_id` AS `bill_id`,`bill`.`encounter_id` AS `encounter_id`,`encounter`.`doctor_id` AS `doctor_
id`,`encounter`.`patient_id` AS `patient_id`,CONCAT_WS(' ', patient.patient_no, patient.sur_name, patient.given_name) AS patient_name, `bill_detail`.`
charge_item_id` AS `charge_item_id` from ((((`encounter` join `bill` on((`encounter`.`bill_id` = `bill`.`id`))) join `bill_detail` on((`bill`.`id` = `
bill_detail`.`bill_id`))) join `waiting_queue` on((`encounter`.`id` = `waiting_queue`.`encounter_id`))) join `month_mapping` on((month(`encounter`.`da
te_created`) = `month_mapping`.`id`))) join patient on `encounter`.`patient_id` = `patient`.`id` where (`waiting_queue`.`status_id` = 6); because: Unk
nown column 'bill.encounter_id' in 'field list'
2011-12-15 08:21:04,250 [main] ERROR context.GrailsContextLoader - Error executing bootstraps: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorExcept
ion: Unknown column 'bill.encounter_id' in 'field list'
org.codehaus.groovy.runtime.InvokerInvocationException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'bill.encounter_id'
in 'field list'
at grails.util.Environment.evaluateEnvironmentSpecificBlock(Environment.java:251)
at grails.util.Environment.executeForEnvironment(Environment.java:244)
at grails.util.Environment.executeForCurrentEnvironment(Environment.java:220)
at org.grails.tomcat.TomcatServer.start(TomcatServer.groovy:212)
at grails.web.container.EmbeddableServer$start.call(Unknown Source)
at _GrailsRun$_run_closure5_closure12.doCall(_GrailsRun.groovy:158)
at _GrailsRun$_run_closure5_closure12.doCall(_GrailsRun.groovy)
at _GrailsSettings$_run_closure10.doCall(_GrailsSettings.groovy:280)
at _GrailsSettings$_run_closure10.call(_GrailsSettings.groovy)
at _GrailsRun$_run_closure5.doCall(_GrailsRun.groovy:149)
at _GrailsRun$_run_closure5.call(_GrailsRun.groovy)
at _GrailsRun.runInline(_GrailsRun.groovy:116)
at _GrailsRun.this$4$runInline(_GrailsRun.groovy)
at _GrailsRun$_run_closure1.doCall(_GrailsRun.groovy:59)
at RunApp$_run_closure1.doCall(RunApp.groovy:33)
at gant.Gant$_dispatch_closure5.doCall(Gant.groovy:381)
at gant.Gant$_dispatch_closure7.doCall(Gant.groovy:415)
at gant.Gant$_dispatch_closure7.doCall(Gant.groovy)
at gant.Gant.withBuildListeners(Gant.groovy:427)
at gant.Gant.this$2$withBuildListeners(Gant.groovy)
at gant.Gant$this$2$withBuildListeners.callCurrent(Unknown Source)
at gant.Gant.dispatch(Gant.groovy:415)
at gant.Gant.this$2$dispatch(Gant.groovy)
at gant.Gant.invokeMethod(Gant.groovy)
at gant.Gant.executeTargets(Gant.groovy:590)
at gant.Gant.executeTargets(Gant.groovy:589)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'bill.encounter_id' in 'field list'
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2536)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:734)
at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
at BootStrap$_closure31.doCall(BootStrap.groovy:754)
at BootStrap.invokeMethod(BootStrap.groovy)
at BootStrap$_closure30.doCall(BootStrap.groovy:678)
at BootStrap$_closure30.doCall(BootStrap.groovy)
at BootStrap.invokeMethod(BootStrap.groovy)
at BootStrap$_closure1.doCall(BootStrap.groovy:95)
... 26 more
Application context shutting down...
Application context shutdown.
C:\CMS3.10937.2>
**************** ERROR LOG END ******************
|
|
|
