Web Viewer 12.1 Database Connection Cannot Be Established Websphere

book

Article ID: 129438

calendar_today

Updated On:

Products

CA Output Management Document Viewer CA Output Management Web Viewer

Issue/Introduction

We are moving from SQL 2008 on Windows 2008 R2 Datacenter X64 Edition to SQL 2016 on Windows Server 2016 Datacenter Edition. We are getting 'Database connection cannot be established' error. Your supportability matrix lists Windows Server 2016 Standard as compatible with R12.1 with build 179. We have build 181 so that shouldn't be an issue. . We aren't getting to the new SQL server. TLSV1.2 only is set up in the registry

Environment

MS Windows 2016 Datacenter
MS SQL Server 2016
Websphere 8.5.5.13.
TLSv1.2
Java 1.8
Web Viewer 12.1 Build 181

Resolution

Here is what resolved the problem: 
1) Upgrade to Java 1.8   (Java 1.7 does not work no matter how it is configured)
 
2) Specify Argument: 
In WebSphere Servers->Application servers->[ServerName]->Process Definition->Java Virtual Machine 
...under "Generic JVM arguments: 
-Dsun.lang.ClassLoader.allowArraySyntax=true -Dcom.ibm.jsse2.overrideDefaultTLS=true -Dcom.ibm.jsse2.overrideDefaultProtocol=TLSv12 
 
NOTE: This formats in a non-consistent manner in the edit box, it needs to be a contiguous string formatted with spaces only between the end of the -<argument> and the next one. 
 
3) Specify "Custom properties" (Websphere) as: 
 
Name 
com.ibm.websphere.persistence.ApplicationsExcludedFromJpaProcessing 
Value 
CAOMWebViewer12.ear