COGNOiSe.com - The IBM Cognos Community

Planning & Consolidation => COGNOS Planning => Topic started by: jburchill on 20 Dec 2012 02:02:19 PM

Title: Macro not validating in Enterprise Planning
Post by: jburchill on 20 Dec 2012 02:02:19 PM
Hello everyone, we are testing our cognos 10, an upgrade from 8.3 and I am trying to run a macro but I am getting some errors.  The macro is an export/import from 8.3.  Everything looks set up correctly but the macro steps are set to incomplete because it fails at its validation.  The issue is it doesn't recognize the path of the file I want to upload.  I have tested out the path and I am able to get to that file on all the servers through RUN.  Also I put the file on the desktop and pointed it to the file and it still fails to find it. 

Are there any configurations I need to set in order to get this thing to find the file? 

Thank you
Title: Re: Macro not validating in Enterprise Planning
Post by: SomeClown on 21 Dec 2012 04:49:57 AM
Sounds like the service acccount does not have access to those locations.  Are you logged in as the service account when you run your tests? 
Title: Re: Macro not validating in Enterprise Planning
Post by: jburchill on 21 Dec 2012 08:33:08 AM
I looked at all my services and they are all running under the same service account.  I log in with my own user credentials when I do my testing.  I don't know the password for our service account user.  Our IT dept. is in charge of that. 
Title: Re: Macro not validating in Enterprise Planning
Post by: SomeClown on 22 Dec 2012 04:59:23 AM
QuoteI have tested out the path and I am able to get to that file on all the servers through RUN.  Also I put the file on the desktop and pointed it to the file and it still fails to find it.

Looks to be an issue with the services account not having access - your tests only validated your access, not access by the service account.  Depending on how you did it, the desktop location may point to a different location (different user).  I'd suggest finding a different file location like  D:\Data\Files  folder for a location on the server, assuming it's a single server implementation.  If it's a multiple server, use a UNC location and have IT verify the service account has access to that location.