Getting Error while using sub query in information link

[gurusai sankar]

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.

[Seema Krishnani]

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.