COGNOiSe.com - The IBM Cognos Community

Planning & Consolidation => COGNOS Planning => Topic started by: Dev1975 on 08 Mar 2016 12:17:07 PM

Title: Error executing J expression ExportToFile_ID
Post by: Dev1975 on 08 Mar 2016 12:17:07 PM
Hi Everyone,

Recently we had a Customer who was experiencing failures with a macro job. This was due to the transaction log of the relevant database growing to ridiculous sizes. These were truncated to free up space and the process would go to the final step, in this case a view publish, where it would fail. The PEL shows the following message:

Unable to execute Job Item~~~~Execution failed after 1 attempt(s).~~~~Error executing J expression : 'ACE2_rc ACE2_xids ' =: 182 ExportToFile_IDCubeExport_ FileName

I've checked online for any relevant docs but nothing has helped. Anyone else come across this issue/message before? The view publish also fails when done manually.

Cheers,
Dev
Title: Re: Error executing J expression ExportToFile_ID
Post by: Dev1975 on 15 Mar 2016 11:40:23 AM
Looks like the steps are now completing after more drive space was cleared on the SQL server. Guess that was the primary cause and nothing else. In case anyone else comes across this, check the drive space on your SQL server first.