Tuesday, May 15, 2012

Troubleshooting and Installation of WebCenter Sites 11gr1


David Parry & Tom Smith from Perficient teamed up with me to work through an installation of Oracle's first branded release of WebCenter Sites.

There are a number of key new features, but we don't go over any in this walkthrough. Perhaps we, or others, can join together to work through sample scenarios? I believe working like this is a great way to jumpstart the open community that Oracle embraces.

I've created a Vimeo Group for WebCenter Sites videos. Feel free to contribute!

Here's the official release notification from Oracle:

http://www.oracle.com/technetwork/middleware/webcenter/sites/overview/webcenter-sites-
111160-whatsnew-1610697.pdf

We really focus on everything before that point. After all, what good is knowing the product if you can't install it :)

Here's the video, no marketing, no company pitches, just teamwork:

http://vimeo.com/user11725852/wcsitestroubleshootingandinstallation

Keep in mind that this was a remote screen capture via google hangout. The quality isn't 100% (or 90%), but the key points are made. Next time, extra steps will be taken to improve capture quality.

Here's to collaboration!
-ryan

Monday, May 14, 2012

WCContent: Adding WebCenter Content to IE Quick Search


1. Go to the Admin Server

2. Open the Advanced Component Manager

3. Update the installed & enabled DesktopIntegrationSuite Component


4. Check the box for "Enable web browser search plug-in"


5. Click Update

6. Restart Content Server

7. Log into Content Server

8. Navigate to "My Content Server" --> "My Downloads"

9. Click on "Add browser search"
                a. pick the version of your running browser


10. Verify that the search provider was added correctly


11. Test!
            a. Notice that the search provider updates the quick search text field as well!






Enjoy!
-ryan

WebCenter Sites 11gr1 Jumpstart kit -- Available!


Hey all,

The WebCenter Sites 11gr1 Jumpstart Kit is available!

You can find it under Patch number 14060594

-ryan

WebTier 11.1.1.6 PS5 -- Now a full installer!


Quick update everyone,

FYI, the 11.1.1.6 WebTier binary is a full installer.

The previous few patch releases required 11.1.1.2 as a base installation, then an upgrade to the current release.

No longer the case!

Enjoy.

-ryan

Wednesday, April 25, 2012

WebCenter Content 11g - Manually Enabling/Disabling Components


It was always helpful in 10g to be able to manually enable or disable a component by using the components.hda file, but things have changed in 11g which makes it much more helpful.

The component wizard can always be used to do this, but sometimes the easiest way is to hit the configurations directly. NOTE: this is only a trick for people that know the implications of these changes. Randomly changing hda files will have negative consequences!

One of the key changes is that the WCContent Admin Server & Content Server both run within the same managed server. In 10g, there were two separate jvms that were controlled separately. Meaning,  the content server might not have started correctly, but the admin server never was down. That means that the component control was never out of reach.

But, as of 11g, the Admin Server & Content Server both run together within the same Managed Server. That is, they are closely coupled and therefore more reliant on the stability of each other.

If a sketchy component is installed and botches the startup, you might not have the ease of access to flip off the component in order to restart the Managed Server.

Here's where and how that's done in 11g:

Find the following file:

<domain>/ucm/cs/data/components/idccs_components.hda

Note the definition is as follows:

16
name
location
status
classpath
libpath
installID
featureExtensions
classpathorder
libpathorder
Launchers
LaunchersOrder
componentsToDisable
componentTags
componentType
useType
version

The "status" is what we're after. It's values are "Enabled" and "Disabled"

example of a disabled component:

BrowserUrlPath
components/BrowserUrlPath/BrowserUrlPath.hda
Disabled
$COMPONENT_DIR/classes.jar



1




idc,integration,system,home
home

2010_03_19 (build 16)


You can see that a number of values are empty, which is fine. Make sure you don't alter any other values!

After disabling your custom component, you will be able to re-start your content server without any related complications!

Hope this helps out!
-ryan

Thursday, April 19, 2012

Searching Like a Native

A user in the Yahoo! Intradoc Users forum asked a really interesting question.
He was looking for a way to conduct database specific searches from the user interface in such a way that the database’s native functionality could be leveraged.

Well, let's put on our thinking caps, shall we?...  hmmm...

- I need a way to conduct searches in a more native fashion in UCM.
- I'm not really wanting to bust up my Content Server, because this will be a gnarly change.

The answer is (a drum roll please...) - a Content Server profile.

You might ask, "Have you lost your mind?"  Well, not totally. I've done this type of thing before.

Let me explain. Content Server has basically given you options to conduct queries in lots of ways. You just have to know and use the right flags. Keep in mind that the Content Server search works off a beast called a datasource, which is a partial query that mostly looks for a WHERE clause to execute.

- So your steps (assuming here that the Content Server is configured for full text searching - you'll need the full text box later.):

1. Create a new profile and one profile rule in Configuration Manager. For kicks, make the profile rule a search only profile, on request.




2. In the profile side effects set the following as shown:

<$SearchEngineName="DATABASE"$>
<$SearchQueryFormat="Native"$>




3. Save the rule, and add it to your new profile. Close the admin applet, and go to your newly created profiled search page.

4. Go down into the fulltext box and enter "FREETEXT(dDocTitle, 'weather floodcar')", or the appropriate "native" SQL WHERE clause for the situation and applicable to your database – minus the WHERE keyword.   (I used an IN statement for the example below.)



5. Click “Search”. Voila (or wah-wah-wah), depending on your query.

Your mileage definitely may vary, but it's a neat way to get at some of the more interesting functionality of the underlying database.

ODC: Oracle Document Capture - 10.1.3.5.1 Patch 3

Hey everyone,

Just a quick note to say that the Oracle Document Capture 10.1.3.5.1 Patch #3 has been released this week.

It's available via support patch number 12977125.

Here's the list of enhancements:

ID: Description:


8930677  SSL support has been added to the Import Server Email Provider via the SSL EasyMail plug-in.


12394097  The Import Server Email provider can now recognize .TIF files attached to email messages.


12966982  The Import Server email provider can now use TLS protocol when connecting to an email server with TLS enabled.


12989098  Users can now change the port that Import Server uses to communicate via IMAP.


13498323  Administrators can now define a file prefix in the commit-to-text profile settings.


Here is a list of the bugs addressed:

ID: Description:


7266098  An issue in Scan for ISIS and Scan for Adrenaline in which pressing CTRL+P or CTRL+N sometimes moved 2 previous or 2 next pages instead of 1 has been resolved.


7266950  For ease in managing Capture pick-list values, the cursor now returns to the Commit Value field after you add a pick-list value.


7320912  A Batch Manager issue in which unexpected results occurred after pressing Shift-F10 with no batches selected has been resolved.


7394408  An indexing issue in which a date field's value is cleared when there are hidden auto-populate fields has been resolved.


7519747  An issue in which the Commit Text File driver created output containing double backslash characters (\\) instead of single (\) has been resolved.


7666729 An issue where Recognition Server patch code information was not saved to page information when no bar codes were detected has been resolved.


8294869  An Oracle WebCenter Capture indexing issue related to double key entry was discovered: when completing the last index field on the last page of a document, the double key entry required three entries. This issue has been resolved.


8304735  An issue was resolved in which no error was returned when the text file commit driver failed to create a PDF Image Only file after a field used to create the file name was removed.


9024718  An issue in which committing a document to Searchable PDF left a 0 byte file in the local user's temp folder has been resolved.


9280060 An issue with Import, Recognition, and Commit Servers not always reconnecting to the SQL Server database upon reboot has been resolved.


9323204  An issue in which a batch containing only separator sheets was not deleted by Commit Server has been resolved.


9395850  An issue in which copying and pasting an indexed batch within the same file cabinet in Batch Manager dropped index values has been resolved.


9438508  An issue with non-English characters in Capture profiles incorrectly exporting and importing into Capture has been resolved.


9564044  A Scan for ISIS error that occurred when importing a TIF file and setting a 0 degree rotation has been resolved.


9581403 When a partial commit occurs to Oracle I/PM Context, the Oracle I/PM 10g commit driver now rolls back the document that was partially created.


9669389  An issue in which committing a document containing more than 50 color JPG images to PDF Image Only or PDF/A failed to generate the PDF has been resolved.


9768548  A Scan for ISIS issue in which 'e' and 'o' characters were removed from documents when the Remove Punch Holes option was selected has been resolved.


10046399  Several East Asian languages (Chinese, Japanese & Korean) erroneously included in the list of supported OCR languages have been removed.


10251997 An issue with Import, Recognition, and Commit Servers not reconnecting after the connection to an Oracle database is lost has been resolved.


10255065  A Scan for ISIS issue in which a configured blank page byte threshold was not working correctly has been resolved.


10273974 An issue in which Import Server fails to import an Excel spreadsheet containing a blank sheet has been resolved. 


10390831 An issue in which Recognition Server running on a virtual machine reports an error that a valid NIC was not found has been resolved.


10415394 An issue in which Import Server imported only the first page of a multi-page Tif file (with no errors returned) has been resolved.


10628866 Redundant calls to refresh file cabinets have been eliminated for the Import Server.


11069325 An Oracle I/PM 10g commit driver error that occurred when committing color images to a network batch path containing a period has been resolved.


11657420 An issue in which commit settings to generate PDF/A documents resulted in PDF Image Only documents that were not PDF/A compliant has been resolved.


11668775  An issue in which Import Server failed to import a document when a TIFF Packbits option was selected for its non-image output format has been resolved.


11769464 A log entry reported each time Import Server discovered an empty folder noting an invalid or empty path has been suppressed. 


11887036  A runtime error that occurred when copying and pasting more than 75 pages in the Indexing component has been resolved.


11902313  An issue in which Recognition Server was unable to read barcode 128 if other barcodes were also selected for recognition has been resolved. 


12347340  A connection error that occurred with multiple Commit Servers accessing the same Oracle WebCenter Capture database has been resolved.


12398608  An Index issue in which dragging thumbnails during indexing sometimes resulted in a runtime error has been resolved. 


12582875  An issue in which an Import Server IMAP SSL connection was lost when an email took more than 60 seconds to process has been resolved.


12638517  An issue in which an Oracle WebCenter Capture upgrade did not overwrite older manifest files has been resolved.


12766813  An issue with converting color PDF images to grayscale has been resolved.


12779080  An issue with patch 12540290 failing install when the Import Server is not installed has been resolved. 


12791457  An issue in which the commit prompt did not appear after completing batch indexing has been resolved. 


12801652  A runtime error 13 (type mismatch) that displayed when reviewing batches in Scan for ISIS has been resolved.


12842168  An Oracle UCM 10g commit issue in which an error stopped commit processing when error handling options were set to <NONE> has been resolved.


12883668  An Oracle I/PM 10g commit issue in which a commit profile configured for process integration failed to save has been resolved.


12903101  An issue in which grayscale LZW tiff images are read in as completely black images has been resolved.


12940014  A Type MisMatch error (13) that occurred when reviewing batches in Scan for Adrenaline has been resolved.


12972280  An error in which Batch Manager did not automatically refresh the batch list after a batch was copied and pasted to the same file cabinet has been resolved


13005265  An issue in which Scan for ISIS reserves the scanner defined for the first profile listed even when another scan profile is selected has been resolved.


13020071  An issue in which Recognition Server did not read certain barcodes in version 10.1.3.5.1 has been resolved.


13036553  A Failure to Persist Batch error that occurred when the scanner was unplugged and an OFR scan macro was in use has been resolved.


13067986  An issue in which the autopopulate value was limited to less than the maximum index field length has been resolved.


13397102  An Import Server issue in which fields on the Folder/List File Provider tab were not displayed When using the UseOITToImport registry setting has been resolved.


13436667  An issue in which batch status in Recognition server changed, regardless of pages remaining, has been resolved.


13442165  An issue in which converting PDF files with text to TIF through Import Server (using Oracle Inside Out Technology) resulted in garbled text on TIF images has been resolved.


13578094  An issue has been resolved in which administrators could not manually add users in Capture Administration, when Domain security was used and the domain list was not populated.


13576855  An issue in which committing from Commit Server to Oracle IPM 11g in certain cases resulted in multiple javaw.exe instances has been resolved.


13631083  A Java issue encountered when running Recognition Server as a service was resolved by replacing RecognitionService.exe and CommitService.exe with ImportService.exe.


11896646  An issue with Oracle IPM commit driver configuration after applying the patch has been resolved.