How to solve when server has encountered an Error Message?

0

 

The server has encountered an error. Please excuse the inconvenience.

Error Message

Order cannot be resolved because of circular or non-existing dependencies.

Error Trace

com.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 

polubothusatish's picture
Joined: Jul 23 2013 - 6:10am
Last seen: 5 years 4 months ago

2 Answers:

0

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.

mgeise's picture
17476
Joined: Mar 5 2007 - 6:18am
Last seen: 3 weeks 1 day ago

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

polubothusatish - 5 years 9 months ago

Edit Input Control:
Type: Mult-select Query
Mandatory and Visible

polubothusatish - 5 years 9 months ago
0

How can I slove this issue? If I changed it to a single query

polubothusatish's picture
Joined: Jul 23 2013 - 6:10am
Last seen: 5 years 4 months ago
Feedback
randomness