polubothusatish Posted September 30, 2013 Share Posted September 30, 2013 The server has encountered an error. Please excuse the inconvenience.Error MessageOrder cannot be resolved because of circular or non-existing dependencies.Error Tracecom.jaspersoft.jasperserver.api.JSException: Order cannot be resolved because of circular or non-existing dependencies. at com.jaspersoft.jasperserver.war.cascade.token.FilterCore.resolveCascadingOrder(FilterCore.java:370) at com.jaspersoft.jasperserver.war.cascade.GenericInputControlLogic.resolveCascadingOrder(GenericInputControlLogic.java:305) at com.jaspersoft.jasperserver.war.cascade.GenericInputControlLogic.getValuesForInputControlsFromRawData(GenericInputControlLogic.java:224) at com.jaspersoft.jasperserver.war.cascade.InputControlsLogicServiceImpl$4.callByContainer(InputControlsLogicServiceImpl.java:173) at com.jaspersoft.jasperserver.war.cascade.InputControlsLogicServiceImpl$4.callByContainer(InputControlsLogicServiceImpl.java:165) at com.jaspersoft.jasperserver.war.cascade.InputControlsLogicServiceImpl.callControlLogic(InputControlsLogicServiceImpl.java:221) at com.jaspersoft.jasperserver.war.cascade.InputControlsLogicServiceImpl.getValuesForInputControls(InputControlsLogicServiceImpl.java:165) at com.jaspersoft.jasperserver.war.action.ReportParametersAction.getReportParameterValuesFromRequest(ReportParametersAction.java:459) at com.jaspersoft.jasperserver.war.action.ViewReportAction.executeReport(ViewReportAction.java:462) at com.jaspersoft.jasperserver.war.action.ViewReportAction.runReport(ViewReportAction.java:395) at sun.reflect.GeneratedMethodAccessor1657.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.webflow.action.DispatchMethodInvoker.invoke(DispatchMethodInvoker.java:98) at org.springframework.webflow.action.MultiAction.doExecute(MultiAction.java:123) at Link to comment Share on other sites More sharing options...
Solution mgeise Posted September 30, 2013 Solution Share Posted September 30, 2013 This looks like you created an input control/filter that is expecting a value from some other filter. Either it does not exist or it is a circular dependency where they both depend on each other. Link to comment Share on other sites More sharing options...
polubothusatish Posted October 1, 2013 Author Share Posted October 1, 2013 For the input control setting the Parameter Values: Value Column: PA.GEO_KEY Visible Column: PA.GEO_KEY Desc Query I used: SELECT G.DESCRIPTION "Geo Name", GT.DESCRIPTION "Geo Type", PA.AMOUNT "Adjustment Amount", PA.WEIGHT "Adjustment Weight", PAT.DESCRIPTION "Adjustment Type", p.INTERNAL_NAME "Provider Name", p.IS_ADULT "Adult Flag", p.CODE "Provider Code" FROM UNU.PROVIDER_ADJUSTMENTS PA JOIN UNU.PROVIDER P on PA.PROVIDER_KEY=P.KEY JOIN UNU.ADJUSTMENT_TYPE PAT on PA.ADJUSTMENT_TYPE_KEY=PAT.KEY JOIN UNU.GEO G on PA.GEO_KEY=G.KEY JOIN UNU.GEO_TYPE GT on G.GEO_TYPE_KEY=GT.KEY WHERE PA.GEO_KEY= $P{GEOKEY} Order by P.INTERNAL_NAME,WEIGHT Link to comment Share on other sites More sharing options...
polubothusatish Posted October 1, 2013 Author Share Posted October 1, 2013 Edit Input Control: Type: Mult-select Query Mandatory and Visible Link to comment Share on other sites More sharing options...
polubothusatish Posted October 7, 2013 Author Share Posted October 7, 2013 How can I slove this issue? If I changed it to a single query Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now