Jump to content
We've recently updated our Privacy Statement, available here. ×

Getting Error while using sub query in information link


gurusai sankar

Recommended Posts

Hi All,

I am getting error while executing below query in information link. but it is working fine in SQL.

Getting error:InformationModelException at Spotfire.Dxp.Data:

An Internal Error has occurred. com.spotfire.ws.dat.OperatorException: unexpected exception (HRESULT: 80131500)

 

SELECT

F1."PROP_REQUEST_ID" AS "PROPREQUESTID",

F1."COST" AS "COST",

(select forecast_cost from ppm_fin_proj_forect_summary_v where project_id=F1.PROJ_REQ_ID

and period_id=F1.PERIOD_ID

and code=F1.TYPE_OF_COST)Forecast_cost,

F1."PERIOD_ID" AS "PERIODID",

F1."PERIOD_NAME" AS "PERIODNAME",

F1."COST_CATEGORY" AS "COSTCATEGORY",

F1."CUMULATIVE_CATEGORY" AS "CUMULATIVECATEGORY",

F1."TYPE_OF_COST" AS "TYPEOFCOST",

F1."ASSET_CLASS" AS "ASSETCLASS",

F1."PROGRAM_ID" AS "PROGRAMID",

F1."IT_TOWER_NAME" AS "ITTOWERNAME",

F1."BSL_NAME" AS "BSLNAME",

F1."BU_NAME" AS "BUNAME",

F1."PROG_NAME" AS "PROGNAME",

F1."PROG_MGR_NAME" AS "PROGMGRNAME",

F1."IT_LEAD_NAME" AS "ITLEADNAME",

F1."PROJ_HEALTH" AS "PROJHEALTH",

F1."PROJ_PROGRESS" AS "PROJPROGRESS",

F1."PROJ_STATUS" AS "PROJSTATUS",

F1."P_NAME" AS "PNAME",

F1."PROJ_REQ_ID" AS "PROJREQID",

F1."BUSINESS_OBJECTIVE" AS "BUSINESSOBJECTIVE"

FROM

"PPM_USR"."FIN_SUMMARY_DATA" F1 where F1.PERIOD_ID >= '31472'

i have added all the elements whatever used (query & Sub query), datatype also the same.

kindly let me now if we want to make any changes in the code else let me know how should i add sub query in the info link

 

Regards,

Guru Sankar

 

please let me know if there is anything wrong in sql code.

Link to comment
Share on other sites

You mentioned that you have all the elements added to the Information Link. Make sure that the no of items returned are exactly the same as the no of items in the original Information link.

Also please check if the datatype is correct.

Maybe just try and test only with one column and see if that works

Please check the sql sent to the database in the tomcatlogssql.log file and try to run the same sql using the third party tool like DBvisualizer etc.

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