Macro not validating in Enterprise Planning

[jburchill]

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

[SomeClown]

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? 

[jburchill]

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. 

[SomeClown]

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.

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.