Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0025006Openbravo ERP01. General setuppublic2013-10-24 07:372013-10-24 07:37
Reporterkarthick_karuppiya 
Assigned Todmiguelez 
PriorityurgentSeveritymajorReproducibilityalways
StatusnewResolutionopen 
PlatformOS30OS VersionProfessional Appliance
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0025006: Creating new client in OB failed in creating org setup
DescriptionTrying 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 ReproduceCreating new client in OB through java code base. The query which is builded is wrong in the OB.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-10-24 07:37karthick_karuppiyaNew Issue
2013-10-24 07:37karthick_karuppiyaAssigned To => dmiguelez
2013-10-24 07:37karthick_karuppiyaModules => Core
2013-10-24 07:37karthick_karuppiyaTriggers an Emergency Pack => No

There are no notes attached to this issue.