AnsweredAssumed Answered

Dynamic Query nsql::NsqlLookupHandler::updateNsql() =>NSQL Syntax exception

Question asked by venkat1 on Jun 29, 2013
Latest reply on Jul 1, 2013 by Dave
Hi All,

I'm creating an dynamic query.I'm geeting an error ..


ERROR:ODF-0001: Unable to register dynamic query lookup: Could not retrieve or register the nsql::NsqlLookupHandler::updateNsql() =>NSQL Syntax exception: NSQL_SYNTAX_ERROR_DB_ERROR, Info: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00923: FROM keyword not found where expected SQL Text:


SELECT srm.UNIQUE_NAME AS [Employee ID],
srm.FULL_NAME AS [Full Name],
inv.CODE AS [Project ID],
inv.NAME AS [Project Name],
PRTIMEPERIOD.PRSTART [Period Start],
PRTIMEPERIOD.PRFINISH [Period Finish],
prtask.prname [task],
prt.prname [input type code],
datename(dw,p.slice_date) Day,
slice_date date,
p.slice slice_hours

FROM SRM_RESOURCES SRM
JOIN PRTIMESHEET ON PRTIMESHEET.PRRESOURCEID = SRM.ID AND PRTIMESHEET.PRSTATUS = 4
JOIN PRTIMEENTRY ON PRTIMEENTRY.PRTIMESHEETID = PRTIMESHEET.PRID
JOIN PRTIMEPERIOD ON PRTIMESHEET.PRTIMEPERIODID = PRTIMEPERIOD.PRID
JOIN PRASSIGNMENT ON PRASSIGNMENT.PRID = PRTIMEENTRY.PRASSIGNMENTID AND PRASSIGNMENT.PRRESOURCEID = SRM.ID
JOIN PRTASK ON PRTASK.PRID = PRASSIGNMENT.PRTASKID
JOIN INV_INVESTMENTS INV ON PRTASK.PRPROJECTID = INV.ID
JOIN prj_resources pres on srm.id = pres.prid
JOIN prtypecode prt on prt.prid=pres.prtypecodeid
Inner join prj_blb_slices p on p.prj_object_ID=PRASSIGNMENT.prid


WHERE

srm.id=''Resource_id'
and p.slice_request_id=2

ORDER BY [Employee ID], [Project ID] ,[Period Start],[slice_hours]

Outcomes