I have TI Process with Execute command to copy a file from one server to other server it ran perfect in Dev and Uat when i moved the same process to Production
i am facing the issue , Even though TI process shows confirmation message that TI process executed sucessfully but nothing happens
when i tried access batch file manually i was able to copy the file from one server to other
i tred changing security like giving access to domain user to all file folders in the path
below is the command i am running
EXECUTECOMMAND ( '\\Servername\G$\TM1\Data Files\BatFiles\Copy.bat' ,1);
Is there any thing that i need to look for please help me
i am using TM1 10.1 version on windows 2008 R2
EXECUTE PROCESS UNABLE TO KICK BATCH FILE FROM TI
- Michel Zijlema
- Site Admin
- Posts: 713
- Joined: Wed May 14, 2008 5:22 am
- OLAP Product: TM1, PALO
- Version: both 2.5 and higher
- Excel Version: 2003-2007-2010
- Location: Netherlands
- Contact:
Re: EXECUTE PROCESS UNABLE TO KICK BATCH FILE FROM TI
Is the user the TM1 Production server service is running on a different user than the user the DEV/UAT services are running on?
If so, does this user have sufficient privileges to copy the file from the source to the destination location?
Michel
If so, does this user have sufficient privileges to copy the file from the source to the destination location?
Michel
-
- Posts: 62
- Joined: Tue Mar 13, 2012 4:34 am
- OLAP Product: TM1
- Version: 9.5.2 10.1 10.2
- Excel Version: 2007 2010 SP1
Re: EXECUTE PROCESS UNABLE TO KICK BATCH FILE FROM TI
Micheal,
Thanks for the response yes both Dev/Uat and Prod has different Domain Account user
i manually gave Prod Domain Account user access to batch file path by right clicking on the folder>Properties>Security>Edit>Add full access
is there any thing that i am missing
Thanks for the response yes both Dev/Uat and Prod has different Domain Account user
i manually gave Prod Domain Account user access to batch file path by right clicking on the folder>Properties>Security>Edit>Add full access
is there any thing that i am missing
-
- Posts: 30
- Joined: Mon Jun 15, 2009 6:13 am
- OLAP Product: Cognos Express and TM1
- Version: 9.4 to 10.2
- Excel Version: Excel 02 to 10
- Location: Sydney
Re: EXECUTE PROCESS UNABLE TO KICK BATCH FILE FROM TI
Sounds like a security issue with your production domain account user.
had a similar issue on a 2008 enterprise server and the access for a service account. Security access fixed it.
had a similar issue on a 2008 enterprise server and the access for a service account. Security access fixed it.
-
- Regular Participant
- Posts: 164
- Joined: Tue May 04, 2010 10:49 am
- OLAP Product: Cognos TM1
- Version: 9.4.1 - 10.1
- Excel Version: 2003 and 2007
Re: EXECUTE PROCESS UNABLE TO KICK BATCH FILE FROM TI
As suggested, security might be an issue.
Also, (as I thought someone else had pointed out), I assume you know that \\Servername\G$\TM1\Data Files\BatFiles\Copy.bat is refers to the g: on server "Servername"? If it is a local file you might be better off using g: or a relative path.
As well as having rights to execute the script, the user needs to have sufficient rights to execute the commands in the script itself. Have you tried running the script manually as the user the TM1 service is running as?Jodha wrote:i manually gave Prod Domain Account user access to batch file path by right clicking on the folder>Properties>Security>Edit>Add full access
is there any thing that i am missing
Also, (as I thought someone else had pointed out), I assume you know that \\Servername\G$\TM1\Data Files\BatFiles\Copy.bat is refers to the g: on server "Servername"? If it is a local file you might be better off using g: or a relative path.
-
- Posts: 62
- Joined: Tue Mar 13, 2012 4:34 am
- OLAP Product: TM1
- Version: 9.5.2 10.1 10.2
- Excel Version: 2007 2010 SP1
Re: EXECUTE PROCESS UNABLE TO KICK BATCH FILE FROM TI
MICHEAL,VANEAGE,ALEX,
Thanks for your replays as all we expected it was an access issue by adding TM1 domain user to Admin group on all servers solved my Problem
Thanks for your replays as all we expected it was an access issue by adding TM1 domain user to Admin group on all servers solved my Problem

-
- Posts: 73
- Joined: Wed Jan 25, 2012 9:08 am
- OLAP Product: IBM Cognos TM1
- Version: 10.2
- Excel Version: 2013
Re: EXECUTE PROCESS UNABLE TO KICK BATCH FILE FROM TI
Hi,
I am also facing the same issue and tried this in three different machines, DEV/QA and Mock environment. The same logic works in all environment except DEV. All my developments progress in DEV.
I have tried all the solutions given in the Forum and nothing works out in DEV. After all tries, I understand that the problem is with the Security access. We are using a separate network account for running the TM1 service. and i have checked this TM1 service is in admin group.
Please let me know what kind of access is required the process to run a batch file in command prompt.
Thanks in advance
kkmk
I am also facing the same issue and tried this in three different machines, DEV/QA and Mock environment. The same logic works in all environment except DEV. All my developments progress in DEV.
I have tried all the solutions given in the Forum and nothing works out in DEV. After all tries, I understand that the problem is with the Security access. We are using a separate network account for running the TM1 service. and i have checked this TM1 service is in admin group.
Please let me know what kind of access is required the process to run a batch file in command prompt.
Thanks in advance
kkmk
- jim wood
- Site Admin
- Posts: 3961
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: EXECUTE PROCESS UNABLE TO KICK BATCH FILE FROM TI
Normally the user used to start the TM1 service needs full control of the TM1 data directory. I would suggest for any script directory the user would need read, write and execute as a minimum but again full control might be a safer bet,
JIm.
JIm.
Struggling through the quagmire of life to reach the other side of who knows where.
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
- Posts: 62
- Joined: Tue Mar 13, 2012 4:34 am
- OLAP Product: TM1
- Version: 9.5.2 10.1 10.2
- Excel Version: 2007 2010 SP1
Re: EXECUTE PROCESS UNABLE TO KICK BATCH FILE FROM TI
KKMK try comparing access rights of domain user acccount in DEV with domain user account in Mock & QA environments some times this can be issue. Try to replicate exact access in all 3 environments.