Empty or blank Ping Page in Content Engine

My Environment:

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 8.5.5.0

Content Engine version:  5.2.0.1

Case Foundation version: 5.2.0.1

JRE version: 1.6

 

Problem:

When verifying Content Engine installation, the Content Engine Startup Context (Ping Page) returns an empty table.

Cause:

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! 🙂

Advertisements

One thought on “Empty or blank Ping Page in Content Engine

  1. Do not have sqljdbc.jar and sqljdbc4.jar in C:\jars.

    Delete sqljdbc.jar from c:\jars that will resolve the issue.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s