Focal Point
Limitation on using DSTRUN

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/2951089372

February 29, 2008, 02:33 PM
Darin Lee
Limitation on using DSTRUN
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
February 29, 2008, 03:27 PM
Prarie
Darin,

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


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
February 29, 2008, 03:35 PM
Darin Lee
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
February 29, 2008, 03:48 PM
Prarie
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
February 29, 2008, 05:46 PM
Darin Lee
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
March 03, 2008, 03:47 AM
hammo1j
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
March 03, 2008, 10:28 AM
Darin Lee
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
March 03, 2008, 10:36 AM
Prarie
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
March 03, 2008, 10:48 AM
TexasStingray
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

March 03, 2008, 11:16 AM
Darin Lee
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
March 03, 2008, 11:41 AM
TexasStingray
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

March 03, 2008, 11:59 AM
Darin Lee
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
March 03, 2008, 01:41 PM
Prarie
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
March 03, 2008, 02:09 PM
Darin Lee
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
March 03, 2008, 03:22 PM
Prarie
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