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.
Hi all I am trying to update WF User status using below REST Web Services metadata. but i got (FOC42229) ENTITY 'nbsp' IS UNDEFINED error. Could any one guide me how to update WF User details from webfocus.
TABLE FILE LOGON
PRINT
ENTRY.VALUE
RETURNCODE NOPRINT
RETURNDESC NOPRINT
IF USERNAME EQ 'admin'
IF PASSWORD EQ 'admin'
IF ENTRY.KEY EQ 'IBI_CSRF_Token_Value'
ON TABLE HOLD AS CSRFTOKEN
END
-RUN
-READ CSRFTOKEN &&CSRFTOKEN.A100.
-TYPE &&CSRFTOKEN
TABLE FILE UPDATE_WFUSER
PRINT
RETURNCODE
RETURNDESC
IF CSRF_TOKEN EQ '&&CSRFTOKEN'
WHERE IBFS_NAME EQ 'test_login'
WHERE IBFS_EMAIL EQ 'Test_login@wls.com'
WHERE IBFS_DESCRIPTION EQ 'Test_login'
WHERE IBFS_STATUS EQ 'INACTIVE'
ON TABLE HOLD AS DELUSER FORMAT ALPHA
END
-RUN
This message has been edited. Last edited by: FP Mod Chuck,
Thanks WAZ, We are geting value for &&CSRFTOKEN from hold file and it's an alphanumeric value.After using in UPDATE_WFUSER table flowing Error occurs.
TABLE FILE LOGON
PRINT
ENTRY.VALUE
RETURNCODE NOPRINT
RETURNDESC NOPRINT
IF USERNAME EQ 'admin'
IF PASSWORD EQ 'admin'
IF ENTRY.KEY EQ 'IBI_CSRF_Token_Value'
ON TABLE HOLD AS CSRFTOKEN
END
-RUN
0 NUMBER OF RECORDS IN TABLE= 1 LINES= 1
-READ CSRFTOKEN &&CSRFTOKEN.A100.
-SET &&CSRFTOKEN = TRUNCATE(d6e4c76ea3ca48b622a52aa0bb399dbd );
-TYPE d6e4c76ea3ca48b622a52aa0bb399dbd
d6e4c76ea3ca48b622a52aa0bb399dbd
TABLE FILE UPDATE_WFUSER
PRINT RETURNCODE RETURNDESC
IF CSRF_TOKEN EQ 'd6e4c76ea3ca48b622a52aa0bb399dbd'
WHERE DESCRIPTION EQ 'test_login'
WHERE EMAIL EQ 'Test_login@test.com'
WHERE NAME EQ 'INACTIVE'
ON TABLE HOLD AS DELUSER FORMAT ALPHA
END
-RUN
(FOC42229) ENTITY 'nbsp' IS UNDEFINED
0 NUMBER OF RECORDS IN TABLE= 0 LINES= 0
First of all welcome to Focal Point! I reached out to the product manager about this post and he recommended you open a case with techsupport. He suspects this is a bug.
Thanks
Thank you for using Focal Point!
Chuck Wolff - Focal Point Moderator WebFOCUS 7x and 8x, Windows, Linux All output Formats
Posts: 2127 | Location: Customer Support | Registered: April 12, 2005
updateuser.fex: TABLE FILE LOGON PRINT ENTRY.VALUE RETURNCODE NOPRINT RETURNDESC NOPRINT IF USERNAME EQ 'admin' IF PASSWORD EQ 'admin' IF ENTRY.KEY EQ 'IBI_CSRF_Token_Value' ON TABLE HOLD AS CSRFTOKEN END -RUN
TABLE FILE ADDUSER PRINT ADDUSER.RESPONSE.RETURNCODE AS 'Return Code' ADDUSER.RESPONSE.RETURNDESC AS 'Return Description' HEADING "Update a User" WHERE IBIRS_PATH EQ '/SSYS/USERS/test_login' WHERE DESCRIPTION EQ 'test_login' WHERE EMAIL EQ 'Test_login@wls.com' WHERE NAME EQ 'INACTIVE' WHERE IBIRS_REPLACE EQ 'true' WHERE CSRF_TOKEN EQ '&&CSRFTOKEN' ON TABLE SET PAGE-NUM NOLEAD ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT HTML ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * INCLUDE = endeflt, $ ENDSTYLE
Posts: 229 | Location: New York | Registered: July 27, 2004
Thanks Efrem, It's working good. Thanks for your help. Cloud you please share Master file for change password and guide us how to update the password for a wf user.