Session parameter not getting retained in scheduled reports (background task)

[kommireddy]

Hi All,

We have CSP (custom security provider) as security source and we pass session parameter (org_id) at package level to secure data. Reports are working as expected when run interactively, but scheduled reports throwing sqlprepare errors, and complaining about syntax. It appears that org_id is not getting retained when report runs in background. Please let me know if you anyone faced similar issue with scheduled reports.

[Rahul Ganguli]

Hi,

Is it a multi-page report?
While running the report interactively are you browsing through all the pages?
sometimes it happens that query associated with later pages may error out.

Regards,
Rahul

[kommireddy]

Hi Rahul,

Thanks for the response. We made a bit progress on this issue, looks like CSP is not passing org_id session parameter to cognos, when application launched directly, but passing it when launching through company portal. We are working with CSP team to make the change and test it out. I will post the update when issue gets resolved.