Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Limitation on using DSTRUN

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Limitation on using DSTRUN
 Login/Join
 
Virtuoso
posted
After spending several hours trying to get my fex contains DSTRUN to work, I went back to the manual for some additional info. According to the documentation, there seems to be a limitation on the use of DSTRUN to kick off a scheduled job in ReportCaster - it will only work for schedules of server-based procedures. Well, wouldn't you know I need it to work for an MRE schedule as well.
1. Anyone know what would be the reason for this limitation?
2. Has anyone found a way around it and been able to successfully use DSTRUN for MRE procedures?

I'm in desparate need of a solution on this one. Any ideas?


Regards,

Darin



In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Report This Post
Virtuoso
posted Hide Post
Darin,

Have you tried one? I don't think it matters..


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Report This Post
Virtuoso
posted Hide Post
yes. I've tried it and it does matter. Makes no sense to me why it won't work but server jobs work and MRe jobs don't.


Regards,

Darin



In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Report This Post
Virtuoso
posted Hide Post
Well we were doing it here...and then changed to a different method...and some overzealous person deleted all the info. Here is one job that I was able to find ...and this was definatly a MRE job. We had it kicked off from a .bat file

-SET &SUBERR = DSTRUN(
- 'sax167',6,
- ' ',0,
- 'WEBFSAHQ01',10,
- 'S10lcj6k9i07',12,
- ' ',0,
- 5,
- 'ljrq9f',6,
- ' ',0,
- ' ',0,
- 0,
- 'I4');


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Report This Post
Virtuoso
posted Hide Post
I'm on a different version, but I don't think that matters. When you get a minute can you test this again and see if it works in your environment? It does not in mine. I have a simple car fex name darin, output pdf, email, as the scheduled job. My run fex contains:
-SET &SUBERR = DSTRUN(
- 'uname01',7,
- 'upass01',7,
- 'IBIREPOR',8,
- ' ',0,
- 'darin',5,
- 5,
- 'admin',5,
- ' ',0,
- 'PROCESS=PRT,OUTPUT=PDF',22,
- 0,
- 'I4');

If darin.fex is a server procedure, everything works. If I put that fex into MRE and schedule it, nothing happens.

My objective is to run this as a post-processing procedure to immediately re-run a scheduled job if additional records remain for processing, as opposed to having to wait another minute for the job to run on it's regular schedule. Any ideas on that?


Regards,

Darin



In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Report This Post
Master
posted Hide Post
Darin

It might be something as simple as MRE renaming your proc ie making it up to a minimum of 8 chars. Do properties in mre part of dev studio to find out what the new name is.

Regards

John



Server: WF 7.6.2 ( BID/Rcaster) Platform: W2003Server/IIS6/Tomcat/SQL Server repository Adapters: SQL Server 2000/Oracle 9.2
Desktop: Dev Studio 765/XP/Office 2003 Applications: IFS/Jobscope/Maximo
 
Posts: 888 | Location: Airstrip One | Registered: October 06, 2006Report This Post
Virtuoso
posted Hide Post
good thought but no dice. In any case, you have to select the procedure name from the MRE list (can't just type it in) in Report Caster task scheduler so it automatically get's the name of the procedure correct. Also tried changing to the scheduleID instead of the job description but htat didn't work either. Grrrrr


Regards,

Darin



In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Report This Post
Virtuoso
posted Hide Post
Darin,

As you will notice in my example above...all of the fields are not neccessary to populate. Try eliminating them. I don't know if that will help....worth a try.


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Report This Post
Master
posted Hide Post
Darin,

Are you just trying to run an existing schedule or are you trying to change any setting or parameters and then run the schedule. The reason is that I have created a jsp page that uses the API and I pass it a schedule id and it then reterives that schedule and sets it to run now. not sure is that is what you are trying to do.




Scott

 
Posts: 865 | Registered: May 24, 2004Report This Post
Virtuoso
posted Hide Post
DSTRUN is a ReportCaster API function that immediately executes the indicated existing schedule. In my original case, I am not trying to change any values - just run. I already use this quite a bit but not for MRE jobs. No need for any API programming, changing parameters, schedules, etc. In my test above, i am changing parm values "on the fly", but it didn't make a difference whether I include parameter values or not.


Regards,

Darin



In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Report This Post
Master
posted Hide Post
Ok, you know that if the manual states it will not work with MRE jobs and if for some reason it works in one release and not in another then the only other option is to use the API.




Scott

 
Posts: 865 | Registered: May 24, 2004Report This Post
Virtuoso
posted Hide Post
Just trying to check all my options before having to learn something new. Smiler

Prarie says it works (worked?) for her so I wanted to follow that one through. We have done nothing with API programming except the using the API functions available in Caster.


Regards,

Darin



In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Report This Post
Virtuoso
posted Hide Post
Sorry Darin...I have not had a chance to put something together to test. I'll try today and let you know. I did find out it was 5.3 we were doing this


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Report This Post
Virtuoso
posted Hide Post
Much appreciated. Made the flat spot on my forehead feel better. Smiler


Regards,

Darin



In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Report This Post
Virtuoso
posted Hide Post
Well it might get flatter now. I'm told we no longer have the security set up to run .bat files for DSTRUN...so I can't test it. Frowner

I can tell you that I had 15 of them set up to run over a year ago...cause I found them in a test area...and I'd almost swear I tested them all. Now why it would work in 5.3...and not 7.1.6...???

Sorry I couldn't be of more help.


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Limitation on using DSTRUN

Copyright © 1996-2020 Information Builders