Jump to content
Changes to the Jaspersoft community edition download ×

How to solve when server has encountered an Error Message?


polubothusatish
Go to solution Solved by mgeise,

Recommended Posts

 

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 

Link to comment
Share on other sites

  • Replies 4
  • Created
  • Last Reply

Top Posters In This Topic

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...