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)
The values I put in the Input Control:
Page 1:
Edit Input Control:
Type: Mult-select Query
Mandatory and Visible
For the input control setting the Parameter Values:
Value Column: PA.GEO_KEY
Visible Column: GEOKEY
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
