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.
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 RCSTRUNER DECODE FILE HAS UNBALANCED PARENS -* 000619 1352 MJB 36936 RBSTMEMER.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'); -ENDITThis message has been edited. Last edited by: <Kathryn Henning>,
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, 2006