Encountered an Error Message?

[polubothusatish]

 

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

 

[polubothusatish]

Hi everyone,

 

Solution: In the Input Control select single-value and chose number: and value: PA.GEO_KEY

It works properly, main important point is to use single value in the input control.