Environment: Single-server deployment (All P8 components are collocated)
Operating System: Windows Server 2008 R2 Datacenter SP1
Database: Microsoft SQL Server 2008 R2 SP2 64-bit
JDBC Driver: Microsoft JDBC Driver 3.0
Application Server: WebSphere Application Server 18.104.22.168
Content Engine version: 22.214.171.124
Case Foundation version: 126.96.36.199
JRE version: 1.6
When verifying Content Engine installation, the Content Engine Startup Context (Ping Page) returns an empty table.
There are many causes of this issue. I happen to confirm one reason.
I unzipped SQL JDBC in C:\jars. I pasted both sqljdbc.jar and sqljdbc4.jar in C:\jars (because I was not sure then what to use) so I will just enter C:\jars in MICROSOFT JDBC DRIVER PATH in WebSphere variables. When I deployed Content Platform Engine and checked the Ping Page, it did not return any value. I inspected SystemErr.log and it said, “Java Runtime Environment (JRE) version 1.6 is not supported by this driver”. What I did next was, I tried to delete sqljdbc.jar. I was right! It is being used by another process so I could not delete it. I stopped WAS, deleted sqljdbc.jar (that leaves sqljdbc4.jar), and started WAS. The Ping Page returned the desired information. FileNet then used sqljdbc4.jar that supports JRE 1.6.
If you know any more confirmed causes, please feel free to comment on this post! 🙂