[#3207] - Encounted error message on JasperServer

Category:
Bug report
Priority:
Low
Status:
New
Project: Severity:
Minor
Resolution:
Open
Component: Reproducibility:
Not Attempted
Assigned to:

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

AttachmentSize
Package icon issueDetails.zip1.01 KB
polubothusatish's picture
Joined: Jul 23 2013 - 6:10am
Last seen: 9 years 1 month ago
Feedback
randomness