IB - Developer Center    Forums  Hop To Forum Categories  FOCUS/WebFOCUS    [WORKAROUND] Execute batch file in fex (map to UNIX directory)
Go
New
Search
Notify
Tools
Reply
  
-star Rating Rate It!  Login/Join 
Member
Posted
Hello,

Tried searching but couldn't find anything.

I am attempting to execute a batch file using a focexec. The batch file and fex both reside on the Reporting server in Windows. The batch file simply maps to a drive on a UNIX server. I have been able to execute the batch file from a DOS window, but have had no luck calling the batch file from a .fex.

-*********
MYBATCH.bat
net use J: \\server\folder gomapit /USER:wfuser

-*********
MYFEX.fex
DOS E:\ibi\apps\IMPORT\MYBATCH.bat
-RUN

-*********
I get the error:

E:\ibi\srv76\wfs\edatemp\ts000066>net use J: \\server\folder gomapit /USER:wfuser
System error 1312 has occurred.
A specified logon session does not exist. It may already have been terminated.

Any suggestions?

This message has been edited. Last edited by: klongid,


WF Production Version: 7.64
WF Test Version: 7.64
Platform: Windows
Output: HTML, EXL2K, PDF
 
Posts: 4 | Registered: November 14, 2005Reply With QuoteEdit or Delete MessageReport This Post
Virtuoso
Posted Hide Post
Is wfuser a valid user on the Unix box? If you log onto Unix and check the file permissions, are there execute permissions on the bat file?


Ginny
---------------------------------
Prod: WF 7.6.5 with 7.6.6 WFRS; AIX 5.2; WebSphere 6.1.0.15
Dev: WF 7.6.5 with 7.6.6 WFRS; AIX 5.3; WebSphere 6.1.0.15
Primarily self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable
 
Posts: 1534 | Location: BNSF: Fort Worth, TX | Registered: April 05, 2006Reply With QuoteEdit or Delete MessageReport This Post
JG
Master
Posted Hide Post
Is the tscom session that is running the request using a userid that has authority to logon to the server.

If it has not then you will not be able run it.

On Windows the account you use must have 'Logon Locally' as a security setting.
 
Posts: 930 | Registered: February 24, 2005Reply With QuoteEdit or Delete MessageReport This Post
Member
Posted Hide Post
Thanks to all who replied...

We were able to solve this by doing these 2 things:

1. Modified the Logon tab within the WebFOCUS 76 Services to logon as the userid that was given access to the UNIX server.
2. Added a profile to the Stored User Names and Passwords via Control Panel. We added the userid and password that was given read/write access to the UNIX directory.

We are no longer using a batch file to map to the drive prior to writing to the directory.


WF Production Version: 7.64
WF Test Version: 7.64
Platform: Windows
Output: HTML, EXL2K, PDF
 
Posts: 4 | Registered: November 14, 2005Reply With QuoteEdit or Delete MessageReport This Post
 Previous Topic | Next Topic powered by eve community  
 

IB - Developer Center    Forums  Hop To Forum Categories  FOCUS/WebFOCUS    [WORKAROUND] Execute batch file in fex (map to UNIX directory)

Copyright © 1996-2008 Information Builders, leaders in enterprise business intelligence.