COGNOiSe.com - The IBM Cognos Community

Planning & Consolidation => COGNOS Planning => Topic started by: shananigins on 22 Jun 2009 03:26:56 PM

Title: Administration Links
Post by: shananigins on 22 Jun 2009 03:26:56 PM
Hi all,

I'm trying to transfer data from a file that was generated by a Framework Package directly into the CAC using an Admin Link.  The text file matches the target cube exactly except for and additional column for values (stats).  I realize that you can not leave Data (in this case 'value) unmatched with a target dimension but I'm wondering if I'm matching up the columns incorrectly.

I run a validate_links and it completes fine.  However, when I execute the link I get two errors:

Error Number: 1
Line Number: 390
Description: Unable to execute Job Item
Unable to run the Linkstep.

And

Error Number: -2147220566
Line Number: 220
Description: Unable to get Job Item
The Job management step failed.  An attempt has been made to mark the 'INTER_APP_LINKS' Job as CANCELLED.  Please rectify the problem and re-create a similar Job.

Any thoughts out there?  Anyone else love Cognos error messages as much as I do?

Title: Re: Administration Links
Post by: SomeClown on 23 Jun 2009 07:35:52 AM
Never seen that but couple of things I'd check:

All cognos services running under the same domain account
That domain account has full privileges
User account has needed privileges
Using sql accounts for all connections, not trusted (if SQL Server)

It's a permissions thing - any additional messages in the planningerrorlogs (check all 3 places, user's my docs, service acct my docs, and windows\temp)?
Title: Re: Administration Links
Post by: jan.herout on 23 Jun 2009 07:46:59 AM
Also, anything of interest in cogserver.log (under ROOT\logs, where ROOT is the location where you installed Cognos services)?
Title: Re: Administration Links
Post by: shananigins on 23 Jun 2009 08:28:42 AM
Thanks everyone!  I'll look into these potential causes and get back to you.
Title: Re: Administration Links
Post by: aa2288 on 01 Dec 2009 01:30:26 PM
Hi Shananigins

I am getting similar error as yours. Were you able to resolve the issue..?