Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||||||
| ID | ||||||||||||
| 0025006 | ||||||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||||||
| defect | [Openbravo ERP] 01. General setup | major | always | 2013-10-24 07:37 | 2013-10-24 07:37 | |||||||
| Reporter | karthick_karuppiya | View Status | public | |||||||||
| Assigned To | dmiguelez | |||||||||||
| Priority | urgent | Resolution | open | Fixed in Version | ||||||||
| Status | new | Fix in branch | Fixed in SCM revision | |||||||||
| Projection | none | ETA | none | Target Version | ||||||||
| OS | Linux 64 bit | Database | PostgreSQL | Java version | 1.6.0_18 | |||||||
| OS Version | Professional Appliance | Database version | 8.3.9 | Ant version | 1.7.1 | |||||||
| Product Version | SCM revision | |||||||||||
| Review Assigned To | ||||||||||||
| Web browser | ||||||||||||
| Modules | Core | |||||||||||
| Regression level | ||||||||||||
| Regression date | ||||||||||||
| Regression introduced in release | ||||||||||||
| Regression introduced by commit | ||||||||||||
| Triggers an Emergency Pack | No | |||||||||||
| Summary | 0025006: Creating new client in OB failed in creating org setup | |||||||||||
| Description | Trying to create client. But am getting exception while creating organization setup through java code. Pasting below the exception thread. [error] o.h.hql.PARSER - line 1:72: unexpected token: 35843D [warn] o.h.h.a.HqlParser - processEqualityExpression() : No expression to process! [error] c.k.o.InitialOrgSetup - createReferenceData() - Exception ocurred while inserting reference data [error] c.k.o.InitialOrgSetup - Exception org.openbravo.base.exception.OBException: Exception when creating query select module from ADModule as module where ( module.id in (075015E3F35843D1821A084FFE2F632D) and module.hasReferenceData = 'Y' and module.hasChartOfAccounts = 'N') and module.organization.id in ('0', '753AFB22CCEF4DBB86F30D6ADE787C01') and module.client.id in ('9ADCA3A0513D4684A01AA0DDF8759CCC', '0') and module.active='Y' at org.openbravo.dal.service.OBQuery.createQuery(OBQuery.java:243) ~[openbravo.jar:na] at org.openbravo.dal.service.OBQuery.list(OBQuery.java:115) ~[openbravo.jar:na] at org.openbravo.erpCommon.businessUtility.InitialSetupUtility.getRDModules(InitialSetupUtility.java:1781) ~[openbravo.jar:na] at com.kachyng.openbravo.InitialOrgSetup.createReferenceData(InitialOrgSetup.java:273) [classes/:na] at com.kachyng.openbravo.InitialOrgSetup.createOrganization(InitialOrgSetup.java:221) [classes/:na] at com.kachyng.openbravo.ClientSetupProcess.createClientOrg(ClientSetupProcess.java:226) [classes/:na] Caused by: org.hibernate.hql.ast.QuerySyntaxException: unexpected token: 35843D near line 1, column 72 [select module from ADModule as module where ( module.id in (075015E3F35843D1821A084FFE2F632D) and module.hasReferenceData = 'Y' and module.hasChartOfAccounts = 'N') and module.organization.id in ('0', '753AFB22CCEF4DBB86F30D6ADE787C01') and module.client.id in ('9ADCA3A0513D4684A01AA0DDF8759CCC', '0') and module.active='Y' ] at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:54) ~[hibernate3.jar:3.6.3.Final] at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:47) ~[hibernate3.jar:3.6.3.Final] at org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:82) ~[hibernate3.jar:3.6.3.Final] at org.hibernate.hql.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:284) ~[hibernate3.jar:3.6.3.Final] at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:182) ~[hibernate3.jar:3.6.3.Final] at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:136) ~[hibernate3.jar:3.6.3.Final] [error] c.k.i.OBContextAction - Error while Creating Client Organization : @CreateReferenceDataFailed@ java.lang.Exception: Error while Creating Client Organization : @CreateReferenceDataFailed@ at com.kachyng.openbravo.ClientSetupProcess.createClient(ClientSetupProcess.java:170) ~[classes/:na] at com.kachyng.openbravo.ClientSetupProcess.processSetup(ClientSetupProcess.java:105) ~[classes/:na] at controllers.buy.BuyController.index(BuyController.java:43) ~[classes/:na] at Routes$$anonfun$routes$1$$anonfun$applyOrElse$103$$anonfun$apply$103.apply(routes_routing.scala:1629) ~[classes/:na] at Routes$$anonfun$routes$1$$anonfun$applyOrElse$103$$anonfun$apply$103.apply(routes_routing.scala:1629) ~[classes/:na] at play.core.Router$HandlerInvoker$$anon$6$$anon$2.invocation(Router.scala:193) ~[play_2.10.jar:2.1.4] [error] application - ! @6g3ga7j0p - Internal server error, for (GET) [/buy/home] -> play.api.Application$$anon$1: Execution exception[[OBException: Exception thrown java.lang.Exception: Error while Creating Client Organization : @CreateReferenceDataFailed@]] at play.api.Application$class.handleError(Application.scala:287) ~[play_2.10.jar:2.1.4] at play.api.DefaultApplication.handleError(Application.scala:381) [play_2.10.jar:2.1.4] at play.core.server.netty.PlayDefaultUpstreamHandler$$anonfun$play$core$server$netty$PlayDefaultUpstreamHandler$$handle$1$1.apply(PlayDefaultUpstreamHandler.scala:143) [play_2.10.jar:2.1.4] at play.core.server.netty.PlayDefaultUpstreamHandler$$anonfun$play$core$server$netty$PlayDefaultUpstreamHandler$$handle$1$1.apply(PlayDefaultUpstreamHandler.scala:139) [play_2.10.jar:2.1.4] at play.api.libs.concurrent.PlayPromise$$anonfun$extend1$1.apply(Promise.scala:113) [play_2.10.jar:2.1.4] at play.api.libs.concurrent.PlayPromise$$anonfun$extend1$1.apply(Promise.scala:113) [play_2.10.jar:2.1.4] org.openbravo.base.exception.OBException: Exception thrown java.lang.Exception: Error while Creating Client Organization : @CreateReferenceDataFailed@ at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:63) ~[openbravo.jar:na] at com.kachyng.interceptor.OBContextInterceptor$OBContextInterceptorAction.call(OBContextInterceptor.java:67) ~[na:na] at play.core.j.JavaAction$$anon$2.apply(JavaAction.scala:80) ~[play_2.10.jar:2.1.4] at play.core.j.JavaAction$$anon$2.apply(JavaAction.scala:79) ~[play_2.10.jar:2.1.4] at play.libs.F$Promise$PromiseActor.onReceive(F.java:425) ~[play_2.10.jar:2.1.4] at akka.actor.UntypedActor$$anonfun$receive$1.applyOrElse(UntypedActor.scala:159) ~[akka-actor_2.10.jar:na] Caused by: java.lang.Exception: java.lang.Exception: Error while Creating Client Organization : @CreateReferenceDataFailed@ at com.kachyng.interceptor.OBContextInterceptor$OBContextInterceptorAction$1.doAction(OBContextInterceptor.java:55) ~[na:na] at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:46) ~[openbravo.jar:na] at com.kachyng.interceptor.OBContextInterceptor$OBContextInterceptorAction.call(OBContextInterceptor.java:67) ~[na:na] at play.core.j.JavaAction$$anon$2.apply(JavaAction.scala:80) ~[play_2.10.jar:2.1.4] at play.core.j.JavaAction$$anon$2.apply(JavaAction.scala:79) ~[play_2.10.jar:2.1.4] at play.libs.F$Promise$PromiseActor.onReceive(F.java:425) ~[play_2.10.jar:2.1.4] Caused by: java.lang.Exception: Error while Creating Client Organization : @CreateReferenceDataFailed@ at com.kachyng.openbravo.ClientSetupProcess.createClient(ClientSetupProcess.java:170) ~[na:na] at com.kachyng.openbravo.ClientSetupProcess.processSetup(ClientSetupProcess.java:105) ~[na:na] at controllers.buy.BuyController.index(BuyController.java:43) ~[na:na] at Routes$$anonfun$routes$1$$anonfun$applyOrElse$103$$anonfun$apply$103.apply(routes_routing.scala:1629) ~[na:na] at Routes$$anonfun$routes$1$$anonfun$applyOrElse$103$$anonfun$apply$103.apply(routes_routing.scala:1629) ~[na:na] at play.core.Router$HandlerInvoker$$anon$6$$anon$2.invocation(Router.scala:193) ~[play_2.10.jar:2.1.4] | |||||||||||
| Steps To Reproduce | Creating new client in OB through java code base. The query which is builded is wrong in the OB. | |||||||||||
| Tags | No tags attached. | |||||||||||
| Attached Files | ||||||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
| There are no notes attached to this issue. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2013-10-24 07:37 | karthick_karuppiya | New Issue | |
| 2013-10-24 07:37 | karthick_karuppiya | Assigned To | => dmiguelez |
| 2013-10-24 07:37 | karthick_karuppiya | Modules | => Core |
| 2013-10-24 07:37 | karthick_karuppiya | Triggers an Emergency Pack | => No |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |