AnsweredAssumed Answered

Error Running Custom Actuate Report From Portlet

Question asked by Owen_R on Mar 20, 2012
Latest reply on Mar 22, 2012 by Owen_R
I have a custom portlet which has an image column with an underlying link to a custom report (the link being chosen from the automatically available links for the query, rather than any kind of URL redirection).

The link should run a report which returns details of a single custom object instance, with the internal object instance ID being passed from the portlet to the report.

When I click the image in the portlet I get "System Error" in Clarity and the following entry in the NSA:
SQL error code: 515
Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]Cannot insert the value NULL into column 'JOB_DEFINITION_ID', 
table 'niku.niku.CMN_SCH_JOBS'; 
column does not allow nulls. INSERT fails.
The URL that is generated in the portlet appears to be OK
http://clarity-dev/niku/app?action=reporting.executeAndView&reportName=custom%20reports/project_snapshot.rox&p_snapshot_id=5002030
The report is active and I can run it OK via Reports and Jobs.

There was an old post on here with the same issue but there was never any resolution. Can't find anything in Support either.

Do I need to do something in the definition of the report to make sure there is Job Definition ID?

Any ideas gratefully received.

Owen

Outcomes