UCM 11g Fails to Start due to csDbFailedToGetNonEmptyTableList Error

After WebCenter 11.1.1.7.0 (PS6) installation with MS. SQL Server 2008 R2, I created one domain includes WebCenter Portal and WebCenter Content components, everything went good. When I tried to start UCM server, it fails to start with following exceptions:-

 <31/05/2013 12:16:48 PM NZST> <Error> <ServletContext-> <BEA-000000> <Could not start server of type 'server' at default relative web root URL 'cs'.javax.servlet.ServletException: Could not start up IDC server deployment.Caused By: java.io.IOException: UCM Server failed to initialize inside its servlet environment.Caused By: intradoc.data.DataException: !csDbFailedToGetNonEmtpyTableList,WebCenter,DEV_OCSS

Cause

I have configured case-sensitive database for WebCenter. In the Weblogic CSDS data source configured for MS. SQL Server, the database name case doesn't match the case on the database on SQL Server.

Such as like the database name in the data source is all lower case but the actual database name in SQL server is all upper-case even i have given same upper-case during RCU schema creation and domain creation time.

Its looking me the bug with SQL Server installation with WebCenter Content. 

Solution

In the CSDS data source, set the database name so that it exactly matches the database name in SQL Server:

1. Go to WLS Admin console, in the Domain Structure pane, expand Services

2. Select Data Sources

3. In the Summary of JDBC Data Sources pane select the CSDS link

4. In the Settings for CSDS pane select the Connection Pool tab

5. In the Properties field change the databaseName to match the case of the database on SQL Sever

Example:

Change:

databaseName=WebCenter (in my case, its change in this way)

To:

databaseName=WEBCENTER

6. Click the Save button8. Restart the Admin Server and the UCM Managed Server.

Note: As a best practice, do this steps for all data-sources configured for MS. SQL Server.

WebCenter PS6 (11.1.1.7) and future releases

Version PS6 (11.1.1.7) of WebCenter has been released on 1st of April, 2013. PS6 includes many bug fixes in addition to enhancements to the WebCenter Content Application Extension Framework (AXF) supporting integrations with E-Business Suite and PeopleSoft.

There will be one major version 11.1.1.8.0 (PS7) of WebCenter by end of 2013. In this release, following are some highlights I learned from Oracle:-

1. there is no more two solutions (Spaces & Portal) for WebCenter. Spaces will be the part of WebCenter Framework. Only one concept that is PORTAL.

2. We can create multiple portal from Web Interface.

3. You can import/export portal archive (PAR exactly like JAR/WAR/MAR) from/to Web to/from JDeveloper for complex customization.

4. All types of popup windows will be eliminated from portal.

5. You can drag and drop Web 2.0 components and taskflows on to the page from resource catalogue.

6. Migration among different environments is easy due to PAR.


You will see WebCenter 12C in somewhere in 2014. 12C will be based on PS7 features but utilizing & certifying Weblogic 12C and other components of FMW 12C.

Top Five Clustering Guidelines for ADF

I found following five guidelines very useful as per my experience:-

1. All the beans stored in session scope, page flow scope, and view scope need to be serialized. We can serialize backingBean scope as well if any value is changing from the UI.

2. All the referenced member objects in the serialized class should implement Serializable interface.

3. It is strongly recommended that all serializable classes explicitly generate default serialVersionUID value from the JDeveloper.

4. Do not use any non-serializable (for example XMLGregorianCalendar) data type in the serialize class.

5. If any object (UI components) is not serializable then it must be marked Transient. 

How to add a favicon Image to the browser tab/URL in WebCenter?

Prerequisites:

1. WebCenter is installed 
2. OHS is installed and configured for WebCenter as a frontend HTTP Server

Steps

 To add the favicon image in your WebCenter application, follow the following steps:-
 
1. Go to following directory of Oracle HTTP Server (OHS)  
/oracle/middleware/Oracle_WT1/instances/instance1/config/OHS/ohs1/htdocs/

2. Add favicon.icon image (size : most commonly 16×16 pixels) in above folder 
3. Restart the OHS 

It will show in the browser tabs/URL when you browse to WebCenter.

For favicon support and limitation in different browser, see http://en.wikipedia.org/wiki/Favicon

How to resolve 8dot3 semantics issue when adding content from Desktop Integration Suite (DIS) or UCM console into Content Server

 On Content server browser window, you will get following alert:-

"The weblayout directory is on a filesystem with 8dot3 semantics. Legacy 16-bit 8dot3 filenames conflict with revision labels and will cause file loss. Disable 8dot3 semantics by running Installer DisableNtfs8dot3 and then restarting Windows."

When you try to add contents to DIS window or trying adding contents from UCM taskflows of WebCenter Spaces , you will get following error in case of DIS:-

And you will get following error in case of UCM taskflows (like document explorer, folder viewer etc) from WebCenter Spaces:-

You cannot upload document. Permission denied.

Quick Solution

 And you will not able to add contents. To resolve this issue, go to following registry location:-

HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Control/FileSystem

 

Then, change the value  of the NtfsDisable8dot3NameCreation key to 1. You must restart Windows for the new setting to take effect.

Please note that the solution has been tested on Windows7 only.

How to increase maximum uploading size for UCM taskflows from WebCenter Spaces?

When try to upload file more than 2MB from UCM taskflows into WebCenter Spaces, you will get following error:-

The file could not be uploaded because it is too large. Enter the file name and location. Files must be less than 2 GB

According to PS3/PS4 documentation, its limit is 2MB not 2GB as error message misleading you.

How to increase the upload limit

1.     Export webcenter-config.xml file using following command:-

wls:/wc_domain/serverConfig> exportMetadata(application='webcenter', server='WC_

Spaces', toLocation='/tmp/', docs='/oracle/webcenter/webcenterapp/metadata/webce

nter-config.xml')

Executing operation: exportMetadata.

Operation "exportMetadata" completed. Summary of "exportMetadata" operation is:

List of documents successfully transferred:

/oracle/webcenter/webcenterapp/metadata/mdssys/cust/site/webcenter/webcenter-con

fig.xml.xml

/oracle/webcenter/webcenterapp/metadata/webcenter-config.xml

2 documents successfully transferred.

2. Open the webcenter-config.xml file in text editor in order to modify file upload size:-.
<webcenter:uploadedFileMaxDiskSpace>2097152</webcenter:uploadedFileMaxDiskSpace>

Please note that the size is in bytes.

3. Once updated, run the following import command:-

wls:/wc_domain/serverConfig> importMetadata(application='webcenter', server='WC_

Spaces', fromLocation='/tmp/', docs='/oracle/webcenter/webcenterapp/metadata/web

center-config.xml')

Executing operation: importMetadata.

Operation "importMetadata" completed. Summary of "importMetadata" operation is:

List of documents successfully transferred:

/oracle/webcenter/webcenterapp/metadata/mdssys/cust/site/webcenter/webcenter-con

fig.xml.xml

/oracle/webcenter/webcenterapp/metadata/webcenter-config.xml

2 documents successfully transferred.

It works without restarting any Managed Server.