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     [SOLVED] DSTRUN Subroutine Error in Webfocus 7.7.3

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] DSTRUN Subroutine Error in Webfocus 7.7.3
 Login/Join
 
Silver Member
posted
Hi,

We have migrated the Webfocus from 7.1.6 to 7.7.3 and we use the below DSTRUN subrouting to trigger any schedules from the Report caster with passing schedule ID as the parameter.
------------------------------------------------
-*THIS PROCEDURE WILL CALL REPORT CASTER
-SET &ECHO=ALL;
-RUN
-SET &SUBERR=DSTRUN(
- 'rparikka',8,
- 'rakesh',6,
- 'ftwdsdbg2g31.aig.com:45460/ibi_apps:ibi_apps',44,
- 'S17m1h195302',12,
- ' ',0,
- 3,
- 'admin',5,
- ' ',0,
- ' ',0,
- 'I4');
-TYPE suberr &SUBERR
-IF &SUBERR EQ 0 GOTO ENDIT;
-INCLUDE DSTRUNER
-ENDIT
---------------------------------------------

I am getting the below error after executing the above- Please help me on this/

-TYPE suberr 112
suberr 112
-IF 112 EQ 0 GOTO ENDIT;
-INCLUDE DSTRUNER
-*-------------------------------------------------------------------
-* Copyright (c) 2000 Information Builders, Inc. All rights reserved.
-*
-* _Name_ ===> DSTRUNER FOCEXEC _Opsys_ ===> CMS
-* _Release_ ===> 72 _Product_ ===> FOC
-* _Description_ ===>
-* ===>
-* _Notes_ ===>
-*
-* _History_:
-* Date Time Who Proj Project Title
-* ====== ==== === ===== ==============================================
-* 070411 1707 ofv 79983 RC761: Subroutine: Insufficient error handling and doc.
-* 070329 1708 gts 79709 RCAPI: Subroutine return codes missing from DSTRUNER fe
-* 070327 1752 gts 79709 RCAPI: Subroutine return codes missing from DSTRUNER fe
-* 060619 0834 bas 73336 Caster Tests
-* 060616 1644 bas 73336 Caster Tests
-* 020408 1231 MJB 45343 RptCaster -Upd error messages in DSTRUNER,DSTMEMER,DSTB
-* 010924 1137 MJB 42623 RC:Change 'EDA' to 'WebFOCUS Server' in fuselib error m
-* 010227 1516 MJB 40045 RCBig GrinSTRUNER DECODE FILE HAS UNBALANCED PARENS
-* 000619 1352 MJB 36936 RBBig GrinSTMEMER.FEX 'ODD NUMBER OF DECODE LIST ELEMENTS'
-* 000419 0950 MJB 36135 ADDING DECODE ERROR MESSAGES FOR BROKER FUSELIB ROUTINE
-*
-* END %&$
-*---------------------------------------------------------------------
-SET &ERRMSG=DECODE 112(
- 0 ' '
- 1 '1 - This is not a valid host'
- 2 '2 - The userid is not valid'
- 3 '3 - The password is not valid'
- 4 '4 - VXLOAD error'
- 5 '5 - TCPH CRT error'
- 6 '6 - HTTP CRT error'
- 7 '7 - HTTP open error'
- 8 '8 - HTTP post error'
- 9 '9 - HTTP read error'
- 10 '10 - Argument Error'
- 11 '11 - Servlet Execution Error'
- 12 '12 - Job Description or Schedule Id should be specified'
- 13 '13 - Job priority level is invalid'
- 14 '14 - Function is invalid'
- 15 '15 - Distribution method is invalid'
- 16 '16 - tcpip level is invalid'
- 17 '17 - Invalid Credentials'
- 18 '18 - Host name Format Error'
- 19 '19 - File name or Copy name should be specified'
- 20 '20 - Copy name can not be specified if File name was supplied'
- 21 '21 - Execution Id length is incorrectly specified'
- 22 '22 - Execution Id password length is incorrectly specified'
- 23 '23 - Host name length is incorrectly specified'
- 24 '24 - Schedule Id length is incorrectly specified'
- 25 '25 - Job Description length is incorrectly specified'
- 26 '26 - Owner Id length is incorrectly specified'
- 27 '27 - Parameters length is incorrectly specified'
- 28 '28 - Web Server User Id length is incorrectly specified'
- 29 '29 - Distribution List Name length is incorrectly specified'
- 30 '30 - Function length is incorrectly specified'
- 31 '31 - Field value length is incorrectly specified'
- 32 '32 - Destination length is incorrectly specified'
- 33 '33 - Method length is incorrectly specified'
- 34 '34 - File Name length is incorrectly specified'
- 35 '35 - Copy Name length is incorrectly specified'
- 36 '36 - Host length is incorrect'
- 37 '37 - Port length is incorrect'
- 38 '38 - WebFOCUS application name length is incorrect'
- 39 '39 - Report Caster application name length is incorrect'
- 40 '40 - Execution Id (provided in Owner Id) length is incorrect'
- 41 '41 - Web Server User Id password length is incorrect'
- 101 '101 - Failed to connect to the Distribution Server.'
- 102 '102 - No WebFOCUS user is logged on'
- 103 '103 - The schedule ID is missing.'
- 104 '104 - A Priority has not been specified.'
- 105 '105 - Configuration error.'
- 106 '106 - Unknown action.'
- 107 '107 - Necessary field(s) not defined.'
- 108 '108 - The Distribution Server is unavailable.'
- 109 '109 - Unable to connect to the database.'
- 110 '110 - There are no pending Job(s).'
- 111 '111 - System error.'
- 112 '112 - Specify either Job Description or Schedule Id -not both'
- 113 '113 - IBIB priority must be a number between 1-5. '
- 114 '114 - Error sending run immediate request to scheduler'
- 116 '116 - Job scheduled for execution.'
- 117 '117 - Unable to queue job for execution.'
- 118 '118 - You must log in to the remote console.'
- 119 '119 - The schedule ID is not in the Queue.'
- 120 '120 - The schedule ID must be entered.'
- 121 '121 - The schedule priority must be entered.'
- 122 '122 - Priority is not correct. Select a number between 1 and 5.'
- 123 '123 - The requested action is unrecognized.'
- 124 '124 - No output from remote console. Is Dist.Server active?'
- 125 '125 - The field has an error.'
- 126 '126 - Internal Error.'
- 127 '127 - No Query Parameter.'
- 128 '128 - User not authorized for query. No cookie information.'
- 129 '129 - Distribution list not specified.'
- 130 '130 - Value is missing.'
- 131 '131 - IBI_user is missing.'
- 132 '132 - Destination is missing.'
- 133 '133 - Function undefined.'
- 134 '134 - Sql method error.'
- 135 '135 - Userid undefined.'
- 136 '136 - Unable to update the database.'
- 137 '137 - Insufficient privileges.'
- 138 '138 - Address already exists in the target list.'
- 139 '139 - Address does not exist in the target list.'
- 140 '140 - Distribution list owner not defined.'
- 141 '141 - Distribution list not specified.'
- 142 '142 - Distribution method undefined.'
- 143 '143 - Function not specified.'
- 144 '144 - Access (public/private) not defined.'
- 145 '145 - List of recipients not provided.'
- 146 '146 - Enter either file or recipient information (not both)'
- 147 '147 - File does not exist or the data is incorrect.'
- 148 '148 - Distribution data error.'
- 149 '149 - No data in the file.'
- 150 '150 - The distribution list is not in the database.'
- 151 '151 - Sql method error.'
- 152 '152 - Userid undefined.'
- 153 '153 - IBIB_user must be specified.'
- 154 '154 - Failed to read the config file ibidir.wfs from WebFOCUS.'
- 155 '155 - Failed to read host name of Dist. Server from WebFOCUS.'
- 156 '156 - Failed to read port number of Dist. Server from WebFOCUS.'
- 157 '157 - Failed to test JDBC and WebFOCUS Server connections.'
- 158 '158 - Failed to read the resource files from WebFOCUS.'
- 159 '159 - Failed during Job Description verification.'
- 160 '160 - Unable to save schedule. Job Description already exists.'
- 161 '161 - Unable to update schedule. Another user has deleted it.'
- 162 '162 - Unable to update address book.Another user has deleted it.'
- 163 '163 - User specified is not in the database.'
- 164 '164 - Unable to update log report. Another user has deleted it.'
- 165 '165 - Unable to delete schedule. Another user has deleted it.'
- 166 '166 - Unable to delete address book.Another user has deleted it.'
- 167 '167 - Unable to delete user. The user is not in the database.'
- 168 '168 - Unable to delete log report. Another user has deleted it.'
- 169 '169 - Unable to save schedule. Another user has created it.'
- 170 '170 - Unable to save address book. Another user has created it.'
- 171 '171 - The user already exists in the database.'
- 172 '172 - Unable to save log report. Another user has created it.'
- 173 '173 - Unable to open schedule. Another user has deleted it.'
- 174 '174 - Unable to open address book. Another user has deleted it.'
- 175 '175 - Unable to open user. Another user has deleted it.'
- 176 '176 - Unable to open log report. Another user has deleted it.'
- 177 '177 - Field limits and character limits are violated.'
- 178 '178 - Invalid Start Date.'
- 179 '179 - Invalid Start Time.'
- 180 '180 - Invalid End Date.'
- 181 '181 - Invalid End Time.'
- 182 '182 - Schedule id must be entered.'
- 183 '183 - The schedule does not exist for the specified user.'
- 184 '184 - Unable to connect to ReportCaster Repository Server.'
- 185 '185 - Unable to connect to WebFOCUS Reporting Server.'
- 186 '186 - Record has already been added.'
- 187 '187 - Record has already been deleted.'
- 188 '188 - Record has already been updated. Resubmit transaction.'
- 189 '189 - Authentication error. Does srv_userid have caster priv in MRE?'
- 195 '195 - Distribution list to be created already exists.'
- 196 '196 - Distribution list to be deleted does not exist.'
- 197 '197 - Distribution list to be copied does not exist.'
- ELSE 'Unknown error');
-ENDIT

This message has been edited. Last edited by: <Kathryn Henning>,


Webfocus 7.1.6, Webfocus 7.7, Webfocus 8
 
Posts: 33 | Registered: August 16, 2012Report This Post
Expert
posted Hide Post
Hi Rakesh,

If you have an update from the case, please kindly let us know, thank you in advance for sharing with all.

Cheers,

Kerry


Kerry Zhan
Focal Point Moderator
Information Builders, Inc.
 
Posts: 1948 | Location: New York | Registered: November 16, 2004Report This Post
Silver Member
posted Hide Post
No. I am still having issues with DSTRUN. It is not working in Webfocus77


Webfocus 7.1.6, Webfocus 7.7, Webfocus 8
 
Posts: 33 | Registered: August 16, 2012Report This Post
Master
posted Hide Post
Same with me. Still having issues.

Tried all options mentioned in the forum. Getting RC-9 error.


WFConsultant

WF 8105M on Win7/Tomcat
 
Posts: 780 | Location: Florida | Registered: January 09, 2005Report This Post
Silver Member
posted Hide Post
please post your runcast code


Webfocus 7.1.6, Webfocus 7.7, Webfocus 8
 
Posts: 33 | Registered: August 16, 2012Report This Post
Master
posted Hide Post
My issue is because of our security setup.

DSTRUN won't work with Trusted Authentication.


WFConsultant

WF 8105M on Win7/Tomcat
 
Posts: 780 | Location: Florida | Registered: January 09, 2005Report This Post
Master
posted Hide Post
"DSTRUN won't work with Trusted Authentication."

I am assuming you are referring to Windows Trusted Authentication. We used DSTRUN for years with Trusted Authentication until we went to Linux clients.


In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.
 
Posts: 975 | Location: Oklahoma City | Registered: October 27, 2006Report This Post
Master
posted Hide Post
Yes Jgelona.


WFConsultant

WF 8105M on Win7/Tomcat
 
Posts: 780 | Location: Florida | Registered: January 09, 2005Report This Post
Master
posted Hide Post
I suggest opening a problem report with IBI.

I'm curious, who told you DSTRUN won't work with Trusted Authentication?

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


In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.
 
Posts: 975 | Location: Oklahoma City | Registered: October 27, 2006Report 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     [SOLVED] DSTRUN Subroutine Error in Webfocus 7.7.3

Copyright © 1996-2020 Information Builders