Skip to main content

Reset WCS Admin Password

We can reset by using the below query's.

Cloudscape/DB2 :

update userreg set logonpassword = '74434f61354f51593862415655304d5
268424e54723865685653356151374a2b353163506c4261363730633d20202020202
02020202020202020202020202020202020202020202020202020202020202020202
02020202020202020202020202020202020202020202020202020202020202020202
020202020202020202020' where logonid='wcsadmin';

update userreg set salt = 'hsdbacehyoyn' where logonid='wcsadmin';

update userreg set status = 1 where logonid='wcsadmin';

update userreg set passwordexpired = 0 where logonid='wcsadmin';

Oracle :

update userreg set logonpassword = '74434f61354f51593862415655304d52
68424e54723865685653356151374a2b353163506c4261363730633d202020202020
20202020202020202020202020202020202020202020202020202020202020202020
20202020202020202020202020202020202020202020202020202020202020202020
20202020202020202020' where logonid='wcsadmin';

update userreg set salt = 'hsdbacehyoyn' where logonid='wcsadmin';

update userreg set status = 1 where logonid='wcsadmin';

update userreg set passwordexpired = 0 where logonid='wcsadmin';

commit;

Once the above querys executed, the username and password will be reset to wcsadmin/wcsadmin

Reference : http://pic.dhe.ibm.com/infocenter/wchelp/v6r0m0/index.jsp?
topic=%2Fcom.ibm.commerce.admin.doc%2Ftasks%2Ftseresetwcsadminaccount.htm 


Labels:

Comments

Post a Comment

Popular posts from this blog

Dataload Utility

Data can be loaded into WCS tables using data load utility. WCS Data Load utility performs the following functions in a single operation: 1.                Reads the data from the input source file. 2.                Transforms the source data to Web Sphere Commerce business objects. 3.                Allocates and resolves Web Sphere Commerce business objects to physical data. 4.                Loads the physical data into the database. There are three configurations files and a input source file required to complete the data loader setup. WCS supports only CSV File Reader for other input source you have to write your own Reader Class. This means that if you are using OOB CSV Reader then your input file must be...
Post a Comment
Read more

Issues While Starting WAS Server

This happens when there is other application which is also using the same port 8880. To resolve the issue, we need to find which application is using the port 8880 through 'netstat' command in command prompt or update our WAS server to not use 8880. We can update the WAS server through these steps: 1) Stop  WAS. 2) Browse to or search for the serverIndex.xml, for example, at "C:\WAS\AppServer\config\yourNode\nodes\yourNode\serverindex.xml" 3) Open the file and locate the following lines:               endPointName="SOAP_CONNECTOR_ADDRESS"> 4) Change "port 8880" to an available port 5) Save the serverindex.xml and restart WAS
Post a Comment
Read more

IBM Announces version 9 of WebSphere Commerce!

What’s new in Version 9 includes information about new functionality and changes in existing functionality from previous WebSphere Commerce Version to the modernized WebSphere Commerce Version 9 release: Micro services architecture , with lightweight, self-contained, distributed servers, supports horizontal scaling, parallel development, and utilization of modern, open source tools. Docker containers deliver key benefits for DevOps , including deployment automation, delivery acceleration, and application portability. Flexible deployment options for  Docker containers  gives IT organizations more infrastructure choices for e-commerce workloads, including all cloud options: private, public, or hybrid deployment. Evolution of the technology stacks  makes customization of the brand and business user experience more efficient and cost effective. Key changes include adoption of lightweight IBM WebSphere Liberty, replacement of Enterprise JavaBeans™ (EJBs) with Java™ Pers...
Post a Comment
Read more