How to do a NuGet package restore after your compile fails. (more…)
How to install a .vsix extension in Visual Studio Code. (more…)
I recently had to change the passwords of the email user for a Xerox uStore installation due to a possible hack in the system. This needs to be done in two places for the emails to be sent without problems. (more…)
A great way to start a Monday morning is to find all of the text in Microsoft Edge to be pixelated. Here is how you can fix this. (more…)
I really enjoy errors in software that occur randomly for no reason. 🙂 One that recently occurred was an installed Adobe application (InDesign) that suddenly failed to start. Reinstalling the software didn’t help. Starting the application would run Adobe Creative Cloud instead where it tried to endlessly validate a software license.
This was fixed by deleting 4 folders:
- C:\Program Files (x86)\Common Files\Adobe\Adobe PCD
- C:\Program Files (x86)\Common Files\Adobe\caps
- C:\Users\[User Name]\AppData\Local\Adobe\OOBE
Once deleted, InDesign was able to run again after I logged into Adobe with my credentials.
When you have hundreds of stores in uStore, making updates on all of them takes a very long time. This doesn’t matter if your paid by the hour, but if your in a hurry and need everything updated quickly, the manual method is not the best solution. For your information, this method is described below. The procedure can take a few minutes to complete. Multiply that by hundreds of stores and you’ll see the problem.
In the uStore admin site,
- Take store offline.
- Open Store Setting -> Set Up Store
- In the Advanced tab, select the Security Option
- Press Save & Place Online
The change can easily be made by modifying a table in the uStore database. This method isn’t recommended by Xerox and I wouldn’t recommend it either to novice database administrators. For experienced users, make a backup of the database before you make any changes. MSSQL doesn’t ask “Are you sure you want to make this change?” when you run SQL queries.
In the uStore database, you will need to modify the Store table. Each store here has an SslOption field which defaults to 0 value (see table below):
|2||Secure Critical Points|
Select which SSL option that you want and run the following SQL command:
UPDATE Store SET SslOption=@SslOption WHERE StatusID=1
UPDATE Store SET SslOption=2 WHERE StatusID=1
This updates all active stores to SSL option: Secure Critical Points
After the SQL query is run, you need to force a cache refresh. The page for this is on your your uStore at (use the IP of your server):
In Cache update, press the Refresh Localization Cache button, Refresh ACL Cache button, and Refresh General Cache button. Not sure if all of these are needed, but I’ve done this and the stores were fine afterwards. If you don’t do a manual cache refresh, this will eventually occur in uStore, but if someone opens a store in the admin site and makes a modification, you may lose the changes your SQL query made.
And that’s it. Again, if your not an experience database administrator, don’t attempt this.