Tecnomatix Quality Management DPV: Wish to repoint ETL to different DPVETLENT database

Customer is attempting to prepare a Business Continuity environment (disaster recovery environment) with ETL DPV_ETL_12_2_0_6.zip.




The idea is to install DPV_ETL_12_2_0_6.zip on a designated disaster recovery 2016 Wintel server. The install occurs against a test SQL server such that the DPVETLENT database is created on this test SQL server. Then, the intent is to repoint the ETL to use the production DPVETLENT database which is an AlwaysOn database. The disaster recovery ETL server is then shutdown.




Here are the steps sequentially to clarify:

1. Install DPV_ETL_12_2_0_6.zip on designated disaster recovery 2016 Wintel server
2. The installation will occur against a test SQL server such that the DPVETLENT database is created on this test SQL server
3. Re-point the ETL to the production DPVETLENT database listener which exists on a production SQL server with AlwaysOn. The repoint is done by modifying the <DBServerName> entry to the desired SQL server. This entry is found in the DbConfig.xml file.
4. Delete the DPVETLENT database that was initially created on the test SQL server.

After step 3 above, able to flow data via the production DPVETLENT SQL database on the production listener.


However after step 4, two issues occur:


1. Could no longer access the DPV ETL Configuration Explorer. Receive the following error:


"Sorry! You are not authorized to access this pager or your user access control setting are preventing the login. Try running browser with higher privileges."


2. Attempted dataflow would appear in the production DPVETLENT database but would be stuck with warehseXferStatus1=0


Since the ETL is already repointed to the production DPVETLENT database, why would deleting the originally installed DPVETLENT database on the test SQL server prevent access to the DPV ETL Configuration Explorer?




Why would dataflow via the production DPVETLENT SQL database be stuck in a warehseXferStatus1=0 state and never fully upload to Teamcenter?


Is there some kind of other configuration parameter that must be updated other than DbConfig.xml ?

Solution

The web service has the server and login configuration. These values must be changed, but they are in an encrypted state.

Use these commands to update the web.config file in the "/ETLConfigExplorer" folder.

DECRYPT

 cd C:\Windows\Microsoft.NET\Framework\v2.0.50727 OR C:\Windows\Microsoft.NET\Framework\v4.0.30319 

$ aspnet_regiis.exe -pd "connectionStrings" -app "/ETLConfigExplorer" 

It will DECRYPT the password and you can open the file to verify.

Change the server values in the unencrypted string in the web.config file.

You can encrypt this back later:
$ aspnet_regiis -pe "connectionStrings" -app "/ETLConfigExplorer" -prov "DataProtectionConfigurationProvider"

Notes and References

Hardware/Software Configuration

Platform: na
OS: all
OS Version: n/a
Product: TECNOMATIX
Application: QUALITY
Version: V12.2.0.6
Function: DPV

Ref: 001-9965673