Solutions

Install Roles & Features without media (2)

Sometimes you may be required to add Windows Roles and Features but you do not have the media. Try this. I have found it works about 50% of the time. Success depends on the Windows Updates options selected on the server. (Or see the script on the Scripts page)

Change regkey: HKLM\SOFTWARE\Policies\Microsoft\Windows\WindowsUpdate\AU\UseWUServer to 0. Restart the Windows Update service and then try to install it using an alternate source path: c:\Windows\WinSxS. After installation, change the key back to 1 and restart Windows Update service again.

If doesn't work try setting WUOptions to 3

Configuring Excel for XLOne

1) Ensure Excel has been successfully installed, including the Office Shared Features and Office Tools .

2) Login to DP as the DP service account and launch Excel. Respond to prompts.

3) Set Macro Setting and enable Trust access to the VBA project object model.

4) Create Desktop folder in C:\Windows\SysWOW64\config\systemprofile directory. Grant permission to DP service account.

5) Created the following path and ensure DP service account have permission on the folder. C:\Windows\SysWOW64\config\systemprofile\AppData\Local\Microsoft\Windows\Temporary Internet Files.

6) Created the following path and ensure DP service account have permission on the folder. C:\Windows\SysWOW64\config\systemprofile\AppData\Local\Microsoft\Windows\InetCache.

7) If Excel version is 64-bit perform steps 4 to 6 replacing SysWOW64 with System32.

8) Run DCOMCNFG > DCOM Config > Microsoft Excel Application . Add the DP service account as the identity user in the DCOM properties.

9) COM addins need to be disabled as they do not interact well with XLOne.

(In Office 2013) Open MS Excel > File > Options > Add-ins, at the bottom of the screen select COM addins, disable any that are active.

Changing T1 Default Suite

1) Update DefaultSuite parameter in file Techone\Install\Settings\Environments\t1environmentsconfiguration.xml and change from CES to ECM

2) Update Suite Id parameter in file Techone\Env\Test\software\default\C2\Web\WebTier.C2Config and change the Default="true" from the CES entry to the ECM entry.

3) Update Suite Id parameter in file Techone\Env\Test\software\default\C2\DP\WebTier.C2Config and change the Default="true" from the CES entry to the ECM entry.

After this you need to perform a full redeploy of software from the CiAnywhere > servers area of the Enterprise App Store client.

Ensure the below file on your CiAnywhere server(s) is updated after the redeploy.

If not then please delete it and perform a second redeploy.

<drive>:\T1Target\Test\CiAnywhere\Web\WebTier.C2Config

Following these changes you need to perform a database refresh from Production to Non Production.