I am W A V I N G

I have been invited to google wave from days thanks to Amr Gawish, I didn't do a lot of things in it yet, but I liked it. I like the way of collaboration using google wave. Currently I have 7 invitations if you need one just send to me.

I hope in the future no one is chatting, all of us gonna be waving :)

Expanding my blog topics

I am currently moving to a new company with new position, where I will be Senior Oracle Middleware Consultant. So that I will more topics in my blog, I will not only concentrate with ECM. I am intending to talk about Identity Management, SOA, and others.

Soon I will try to post things about integration between UCM and Oracle IDM solutions. Also integration between IDM and E-Business Suite, and UCM and E-Business Suite. But give me an excuse If I was late because I am currently in the process of handing-over my tasks with my old employer Egabi Solutions.

Lastly I want to mention that my new employer is Catalyst Solutions, it's an American Indian company and it's working mainly with oracle solutions, they have 6 branches in Africa, and we will be concentrating on African market. I wish I will be helpful for them in the area of MiddleWare solutions.

No Posting from days ...

I didn't post anything from days, because I am currently engaged in J2EE application for Vodafone Egypt with my current employer (Egabi Solutions) where we have lack of J2EE resources, and hopefully I will finish my tasks by the end of this month. For the first time I am coding using Hibernate and Struts, I was confused about them at the beginning but now I know how to work with them, and I like them especially hibernate.

Oracle Database RAC configuration with UCM

If want to configure Oracle Database RAC with Oracle UCM, you will need only to change database connection string inside UCM configuration file (/config/config.cfg), also you can change the connection string using System Properties utility if you want.

The new UCM configurations are:

JdbcDriver=oracle.jdbc.driver.OracleDriver
JdbcConnectionString=jdbc:oracle:thin:@(description=(address_list=(address=(host=your.host1.name)(protocol=tcp)(port=123))(address=(host=your.host2.name)(protocol=tcp)(port=123))(load_balance=yes)(failover=yes))(connect_data=(service_name=service.name)))

IRM Blog

I was searching for any available resources about IRM, and I discovered that there is an official Oracle blog for IRM http://blogs.oracle.com/irm/

Create a new webService based on an existing content sever service

In latest release of Oracle UCM (10gR3 release), WSDLGenerator component has became one of the system components, which means when we install UCM, we will have that component installed and enabled for us to be used. That component is very important, because it facilitates the integration with Oracle UCM, i.e. we got 8 WSDL files with this component that WSDL files give us the most required webservices like a webservice for checking in a content.

But sometimes, we want to have some other webservices based on an existing content server service that service may be created by you. Next I will show you how to create a webservice that can create a virtual folder, the new webserice name will be CreateFolder, where that webservice will be based on COLLECTION_ADD -content server service.

Note all WSDL files are saved under the following path [UCM_INSTALL_DIR]/weblayout/groups/secure/wsdl/custom/

Steps For How To Create "CreateFolder" Webservice
1- Login as sysadmin user
2- Under Administration menu, click on the menu item Soap Wsdls, then Wsdl List page will open

3- From Actions menu choose Add WSDL


4- Next add the Wsdl Name which will be Folders and add Wsdl Description

5- Then Click on Add button, then you will be directed to Wsdl Information Page
6- Inside Wsdl Information Page, from Actions menu choose Add Service


7- Next add the Webservice Name, which will be CreateFolder, and IdcService Name which will be Collection_ADD


8- Then click on Add button, then you will return to the Wsdl Information Page again, and you can see a new webservice has been added to Services list
9- Click on Edit for the webservice CreateFolder, you will be directed to the Service Information Page


10- From Actions Menu, choose Update Request Parameters, and add the following parameters
Note: The request (input) parameters for COLLECTION_ADD IdcService are divided to three parts, the first part is related to folder information (first five parameters), the second part is the default metadata fields for the folder where any content added to the folder will inherent the metadata values, we can add them one by one or we can use another predefined type (d:CommonDocMetaFields) that holds all of them, and the third part is the custom metadatafields, also we have a predefined type (propertylist:CustomDocMeta) that will define them to be taken dynamically with specific names (you can add them one by one but in that case they will be static so if you deleted any custom metadata field you need to remove it manually from the Wsdl file)

11- From Actions Menu, choose Update Response Parameters, and add the following parameter

12- Inside Service Information Page click on update
13- Inside Wsdl Information Page click on update
14- Now you are in Wsdl List Page, from Actions menu, choose Generate Wsdls

Next after creating the webservice, we need to test it, we can do this using a Webservice testing tool, I am using SoapUI.

Documentum

Today I attended a presentation for Documentum, it was my first time to see documentum, and documentum offerings. it was interesting, they are offering every thing, document management, federated search, workflow, business process, web content management, high availabilitiy, storage management, eForms, virtualization, capturing solution, and other things, and the interesting thing is that they have a unified repository.

Actually, I love Oracle UCM so much, but as I saw Documentum is better than Oracle UCM, mmmmmm no comparison. Anyway, after that presentation I wish I will work in a Documentum project soon.

START_SEARCH_INDEX

I've been asked a question from "Anirban Datta" from "Tata Consultancy Services" about separating indexing of content based on document types, which means during indexing we want to not index all documents, just some documents based on document types.

By default you cannot do this, but I think using customization we can do that, in UCM we have a service called "START_SEARCH_INDEX" that service is executing a java function called "buildSearchIndex", so If we redeveloped that function again for that service (using reverse engineering), we can make indexing based on document types.

I wish I was helpful for "Anirban Datta"

How to move Vault and Weblayout Directories???

Most of the time you want the vault and weblayout folders to exist in a storage server (for example on SAN storage). You can do that during installation of UCM, where you will be asked for the location of the Vault and Weblayout directories, but if you forgot to do that, no problem you can change the location of the two directories.

In the following lines, I will tell you how to change the location of the two directories:

First I will suppose that we have a shared directory on the file server in which we will move the vault and weblayout directories, let us suppose the shared directory named "\\stellent-share\"

1. Stop the content server
2. Stop the webserver
   
3. Move Vault and Weblayout directories to "\\stellent-share\"
4. Edit the following configuration files
   /bin/intradoc.cfg
   /admin/bin/intradoc.cfg
   and add the following entries
   VaultDir=d:/vault/
   WeblayoutDir=d:/weblayout/
   
5. In the currently used Web Server, change the location of the weblayout in the website settings
   
   Note: You need to create a mapped drive the new location of the weblayout directory (with win, use PUSHD command), which will be used with Web server settings
   
   If for example I mapped "//stellent-share/weblayout" to "Z:", in Apache the configurations will be
   
   
6. Restart the web server
7. Restart the content server

Don't forget you can do the

UCM Workshop in Nigeria

I am late in posting this photo for attendees of Oracle UCM Workshop in Nigeria and me, that is because I received it from a week and I was busy. I'd like to thank Rasaq Hanafi for sending that photo, he is not in this photo, but he was one of the attendees and I think he is one of the most active attendees in the workshop.

Site Studio 10gR4 tutorial

I am currently in the process of building Site Studio 10gR4 tutorial. I will try to help by giving you exact steps for building a complete website using most of Site Studio features. Actually I like the materials that I am using during my trainings for oracle partners which is based on Oracle University materials, and I will try to simulate them.

Obama In My University

Actually, from long time we heard that Obama will speak in an Islamic Nation, where he wants to send to Muslims around the world a message. I am Egyptian, and I was sure that it will be in Egypt, because Egypt is Islamic and Arab country, and we have one of the biggest Islamic organizations in the world Azhar, and may be the oldest one. Also Egypt is a very safe country.

But I don't care if Obama will give his speech in Egypt or Indonesia. The only thing that surprised me is that his speech will be in Cairo University (my university) and in the same place where Dr. Ahmed Zewail were giving a lecture in physics from about 5 years, and I was there. I am happy because I love my university :) and I wish it will return as a leader in education again.

That's what I love in trainings

Today, I got a strange bug with Site Studio 10gR4. I decided in the current workshop to use SS 10gR4, the attendees got a task to test how workflows will be used to modify and approve content before publishing it. The part of workflow approve and reject done with no problems.

But when they tried to use "check out and open" for a word document, and they failed, however the used content server user has both permission of the security group and the workflow step permission to edit. I tried to figure the problem, but I didn't succeed because I was thinking by the logical way (vertical thinking), where every thing is fine, nothing is wrong.

I logged into the content server and by the same previous user I checked out then checked in the same document, no problems I faced. I tried to use "sysadmin" user in the workflow by adding it to a step, and I discovered that sysadmin can use "check out and open" then I tried the same previous user again, and I succeeded to use "check out and open".

Ok I removed sysadmin from the workflow step, I discovered that the same previous user cannot use "check out and open".

I discovered the problem, I created users with no passwords and WebDAV doesn't accept them to use "check out and open" for a content in a workflow.

That is what I love in trainings "bugs"

"Open Source will allow Larry Ellison compete creatively with Microsoft, his favorite enemy"

I was reading a review from forbes which asks if oracle will kill mySQL or not. I think that's the first thing came to our minds when we heard that Oracle acquired Sun. I quote the title of this post from forbes' review.

Actually, I think Oracle is not that stupid organization to kill mySQL, they know what they are doing, and I think they are understanding the importance of Open Source and of course before buying SUN they understand that.

Egypt from WolframAlpha eyes

Actually I heard about WolframAlpha from my friend Amr Gawish from about month and he explained to me how it will be working, I also read different posts talking about it like Bex's and Billy's posts.

I know Wolfram Mathematica , where I was studying mathematics in faculty (Amr too), and I trust Wolfram because when mathematicians say that they can do something, they will do it :)

I searched for Egypt in WolframAlpha, and I got very good results, I think the best result that I can get, even - for me - better than Wikipedia because when I am searching for a country I want to get fast facts about it. But I think still it to be improved because I searched for other things and I didn't find them.

Well done, Keep on Wellfram.

"SS Link Form for the WebLogic VCR adaptor for UCM"

A new component has been released called " VCR/SPI for Site Studio 10gR4", this new component is only of interest to WebLogic customers using the VCR adaptor to connect to UCM as a repository. The link form allows content authors to add item links to the Site Studio data file in a way that the VCR will recognize.

Also I wish I will be to test it when I return to Egypt.

"JRockit with Content Server"

I was talking from days with some guys, and I was telling them about if we installed Oracle Content Server with JRockit, the content server will be faster, for example, we can create a lot of folders and check-in a lot of content in the same folder using WebDAV.

Today I was taking a look at Oracle Website if there are a new components has been added or modified, I discovered that there a new component has been added that will allow us to use JRockit with CS. Unfortunately internet connection in Nigeria is slow and I cannot download that component to test it.

Nigeria =

Someone: What is your opinion in Nigeria?
Me: Well, Nigeria = Rich Country + a lot of poor people

Someone: Why are you saying that?
Me: Because people there owns very good cars which are very expensive, and real state there is expensive

Someone: But it's the same in Egypt
Me: No because cars here are newer and better even car prices in Nigeria are higher than Egypt, and real estate in Nigeria much exepsive

Someone: mmmmmmmmmmmm

Someone: What's about the Oracle UCM workshop?
Me: The workshop is going well, people in Nigeria want to learn, and they are accepting ECM concepts but I wish they practice what they learn in real projects.

Accounts & Editing Workflow

Today during Oracle UCM workshop in Nigeria, I discovered something related to Accounts and workflows.

If in some step in a criteria workflow, and you chose the workflow step permission equals to "users can review and edit (replace) the current revision", then in the workflow process the user tried to modify "Account" metadata field value for the content in the same step, you will got an error, however the user has the write permission on the account and security group for that content.

The problem is with workflow step permission "users can review and edit (replace) the current revision", which will not allow you to modify the account while it is replacing the existing revision.

!!!!!!!!!!!!

New post from Nigeria

I am currently in Nigeria, where I am providing Oracle UCM implementation workshop. That country is very crowd, actually I didn't like it. They should learn more about civilization :)

I don't know what I say, may be in the next post I can say something :)

Philosophy of The Last Samurai

I like that movie because we can learn a lot about management, in the following lines I will write in brief what we can learn


- At the beginning of the movie when they tried to hire "Nathan Algren" in the Japanese army, they found him drunk however he was able to shoot by the gun perfectly


When you have the experience in some field, you can do any task related to that field easily and quickly


- When Nathan was learning how to fight like samurai, someone told him to concentrate

While we are working, we should concentrate on our work and we should forget anything else especially personal staff


- When he was learning how to fight like Samurai, the teacher was tough with him


The teacher was tough because he wants Nathan to be like him


- The Samurai leader was responsible for entertaining his community


Managers should not forget that there should be a time for giving a break to employees


- When the Samurai fighters decided to fight against an army with guns, they didn't choose to learn how to fight using guns


Because they are not perfect in using guns and they are perfect with swords, can kill more people.

The EARTH

I wish I can see that movie in Egyptian cinema :)

They make shit. Unbelievable, unremarkable shit.

I qoute these words from SwordFish movie

"They make shit. Unbelievable, unremarkable shit."

I like these words, and I can use the same words for microsoft products :) 

I am not enemy to microsoft products. But Microsoft's pyramids secret is how they can do that??? I think they do this by making their applications look and feel user-friendly. Also they concentrate on easiness of use and even of development.

What I want to say is 

How can we make shit undelievable?

Views & Resultsets

If you have a view and you want to use it within your code, I mean that you want to loop on the view data to display that data, - using IdocScript- you can get a resultset from that view, then loop on that resultset to display its data.

As an example for how to do that, let us assume that we have a view called view1

<$getViewValuesResultSet("view1", "", "")$>
<$loop SchemaData$>
<option><$dOption$></option>
<$endloop$>

PopUpCalendar component

I was creating a custom checkin page using IdocScript, and in that template I had a metadata field of type date. So I discovered that I need a pop-up calendar, where the user will not care about formating dates.

In Content Server, I found that there are a component called PopUpCalendar which adds pop-up calendars to checkin and search pages. So I said, I should use the same calendar object to give to my custom checkin page the same look and feel.

Note: This component is taken fromYahoo Developer Network, you can find there a lot of useful javascript objects, and part of the content server scripts are taken from there.

So to use that component in your template, do the following

1- If you will use it for custom checkin template, add the following include
<$include std_checkin_html_head_declarations$>

2- If you will use it for custom search template, add the following include
<$include std_query_html_head_declarations$>

3- Now I will assume that we have a metadata field called xPublishDate and we want to have a popup calendar for that field

<input id="xPublishDate" name="xPublishDate" size="20" maxlength="30" value="" type="text" READONLY>
<a href="javascript:pucToggleCalendar('xPublishDate')" style="vertical-align: middle;">
<img style="cursor: pointer; vertical-align: middle;" src="<$HttpWebRoot$>images/PopUpCalendar/calendar.png" border="0" width="20" height="19">
</a>
<script type="text/javascript">
pucCreateCalendar({ id: "xPublishDate", caption: "Publish Date"}, "xPublishDate");
</script>
<div id="puc_panel_xPublishDate_div" style="display: none;">
<div class="hd">Publish Date</div>
<div class="bd">
<div id="puc_calendar_xPublishDate_div"></div>
</div>
</div>

Avoid ExtranetLook Component

The first time I used ExtranetLook component, I liked it, because of the log-in screen, and log-out functionality. But later I discovered that this component is not compatible with other UCM components, as an example this component sometimes you will not be allowed you to log-into the Content Server using Site Studio designer, another example you will not be able to index scanned into the content server using Dynamic Converter.

I don't know why Oracle is releasing that component, and in general why they are releasing incomplete components???

I recommend anyone to not use ExtranetLook component.

World Without Nuclear Weapons

An initiative for removing nuclear weapons from our world. They are collection online signatures and I gave them mine, I wish you will give them yours (http://www.globalzero.org/)

I signed on the following words

”We, the undersigned, believe that to protect our children, our grandchildren and our civilization from the threat of nuclear catastrophe, we must eliminate all nuclear weapons globally. We therefore commit to working for a legally binding verifiable agreement, including all nations, to eliminate nuclear weapons by a date certain.”



But If we removed all the nuclear weapons, and some aliens came from the space with dangerous and fatal weapons, what can we do? :D no aliens are there, just we should remove those nuclear weapons from our world.

"Oracle Buying Sun" Wow

Oracle is acquiring Sun, It is a big surprise for me, and I don't know how Oracle will manage this.

Read this

and

Watch this

Creating Document Types in UCM

Document Types In Oracle Ucm

View more presentations from hishamgalal.

Document Types

From two months, I want to blog about document types, that's because of the importance of document types and some people misunderstand document types' uses.

In Oracle UCM, defining document types is very easy just add document type label and description, so some people are thinking that it's just a list of values for Document Type (dDocType) metadata field. That's a big mistake.

The first thing I will do when I am setting with the customer in requirements gathering sessions, I will ask him about business classification of documents in his organization, that classification is document types.

After that, I will verify the list, may be I can find some missing document types or extra document types, I mean I will normalize and optimize document types until I get the final complete list.

Then, for every document type I will get the associated metadata fields. Like if I have document type called "Invoice", I need the following metadata fields [Invoice Number, Invoice Total, Customer Name, Discount, Cashier Name, etc .....].

In the case of Oracle UCM I should not repeat the metadata fields that are associated with more than one document type. After creating the metdata fields in UCM, you should create content profiles and content rules, so that we will have entry, search, information screens for every document type (or for every group of document types).

In some other Document Management Solutions like Sharepoint & Documentum, document types are created in a tree, where for every document type you have different metdata fields and child document type can inherit metadata fields from the partent document type.

Which of the two approaches (flat-like document types or tree-like document types) is the best. In my opinion UCM (I didn't say UCM because I am UCM expert), where UCM offers you the flexibility in managing metadata fields and in creation of content profiles.

In next post I will post about documents types in Oracle UCM.

I cannot create a WebDAV Folder

I was trying to create a WebDAV folder where I have UCM installed and Desk-Top-Integration suite installed too. I didn't install UCM on that environment, just I installed DIS and some other components, suddenly discovered I cannot create a WebDAV folder.

I tried to find the problem, but I didn't find any where I checked folder_g component and it's working, DIS installed correctly, CS is working, and Folder configurations is absolutely correct. So I asked myself what's the problem, after thinking I said that the installation of CS is not done correctly, something is missing.

So I begun in taking a look at CS installation. I discovered that there are two web-filters in IIS and they are referring to the same ISAPI filter file. That is the problem WebDAV tries to use both on the filters.

Please install Oracle Content Server correctly or don't install it at all.

I am AIIM professional member

Twitter wolrd but we miss it in Egypt

Tiwtter is not well-known here in Egypt and in Middle East in general, but I know everything about twitter even I am member in twitter.com and I wish it will be popular here in Egypt too because I like it so much.

Take a look at that funny slides about twitter, you will like it

Funny Twitter Cartoons

View more presentations from guest91e6d3.

OnLive & Web 2.0

OnLive will change our way in playing games, it is a revolution in Games platforms where you can play any game online without installing it on your PC. I think it will dominate on Gaming market, and PlayStation will not be able to compete with OnLive.

OnLive will change our way in thinking in and dealing with internet, where we will play high resolution games online and that games will be hosted there. Also players will create virtual friendships and they will have profiles by which you can see what they are palying right now and also palyers can save scenes of their games. OnLive will be one of Web 2.0 applications that will change internet for ever.

Visit OnLive website.

We Should Kill IDIOTS

We Should Kill ALL IDIOTS

Rome Wasn't Built in a Day

Riyadh ECM Workshop

I'd like to thank all attendees in Riyadh ECM Workshop for their cooperation and their effort in learning UCM.

Records Manager overview

I created a presentation for Records Manager overview, that explains just Records Manager concepts

Records Manager Component

View more presentations from hishamgalal.

Lawrence Ellison

I was reading "The World's billionaires" list inside forbes and I discovered that Bill Gates becomes #1 in the list again, and I've been surprised when I saw Lawrence Ellison becomes #4 in the list. In some words that means IT giants are still standing and they are still making money.

I quote the following from forbes

Net Worth:$22.5 bil
Fortune:self made
Source:Oracle
Age:64
Country Of Citizenship:United States
Residence:Redwood City, California
Industry:Software
Education:University of Illinois, Drop Out,
Marital Status:married, 2 children

Database titan continues to engulf the competition; Oracle has racked up 49 acquisitions in the past 4 years. Bought BEA Systems for $8.5 billion last year. Still sitting on $7 billion in cash. Revenues up 11% to $10.9 billion in the six months ended November 30; profits also up 11% to $2.4 billion. Stock down 25% in past 12 months. Invested $125 million in Web software outfit Netsuite; took public in 2007, stock has fallen 80% since. His shares still worth $300 million. Chicago native studied physics at U. of Chicago, didn't graduate. Started Oracle in 1977. Public 1986, a day before Microsoft. Owns 453-foot Rising Sun; built a smaller leisure boat because superyacht is hard to park. Squabbling in court with Swiss boating billionaire Ernesto Bertarelli over terms of next America's Cup. Recently unveiled hulking 90-foot trimaran he intends to use to win it.

Inbound Refinery & OpenOffice on linux

I installed Inbound Refinery on Linux, and I want PDF conversion to be enabled, so I installed PDF Converter component and OpenOffice component. I did this using Inbound Refinery installation guide and PDF Converter installation guide. I did the installation successfully but I got an error during conversion.

The error says “The refinery's post converted queue stated that Content ID: 'TESTWORDDOC' converted successfully but the converted files could not be found”, I tried to find a solution and I reviewed the instllation guides, Intreadoc_User group, and Oracle MetaLink mutiple-times but I dind't find anything I did wrongly. After a lot of attempts I discovered that OpenOffice on linux should be strated using "Super User"

so I used that command to start OpenOffice

>sudo soffice "-accept=socket,port=8100;urp;"

Saudi ECM Workshop

I were in Saudi from 10 days where I was completing the Second part of ECM workshop which was for Site Studio. That was the forth workshop in which I was giving Site Studio and in two of the workshops I gave UCM administration too.



What I noticed in these workshops that attendees like Site Studio very much and I asked myself "why?", I think the answer not only because of Site Studio is very good, they liked it because in Site Studio they created a complete website in couple of days but in administration they are learning some administration tasks where in the workshop design we didn't have a complete business scenario. We created the workshops based on Oracle University materials, but I am willing to modify our company ECM trainings to be more powerful, this by concentrating how to apply what you learned in a real case scenarios.

But of course, in general the training is not sufficient to develop and have a successful implementation for UCM. Training just will accelerate your learning path, and will prevent you from getting lost.

In Saudi workshop, we were lucky because we saw Oracle E2.0 VP Andrew Gilboy. He told us that ECM is the most growing technology in Oracle, and I think especially in Middle East. Also I see a from Oracle lot of care about partners, Oracle is trying to help partners so much. I wish for all partners to have successful implementations for UCM.

Deleting and Adding menu items

Many people asked me about adding or deleting menu items in UCM, it is easy to do this with UCM.

The steps to customize menus
1- Create a custom component, or use an existing one
2- Add new resource file to the component that file type is "HTML Include"
3- Add new include with the following name "custom_finish_layout_init" where it is an existing include that creates menus and we want to customize it
3- Inside that include write the following

// First we will call the parent definition for menus
<$include super.custom_finish_layout_init$>

// If we want to delete "My Profile" link
navBuilder.deleteItem("MY_PROFILE");

// Now we will add new menu item and we will add one child link to that menu item
// Check if the menu has been added before
<$if not MyScreensMenu_included$>
// add a drop-down menu, or a tray to the UI, that new menu item will be called "My Screen"
navBuilder.addChildNodeTo('NAVTREE', 'collection', 'id==MyScreens', 'label==My Screens');
//Now check if we are using Top Menus layout
if (navBuilder.menuB)
navBuilder.menuB.addTopLevelNode("MyScreens");
//Or we are using Trays layout
else if (navBuilder.trayA)
navBuilder.trayA.addTopLevelNode("MyScreens");

// Flag that the new menu item has been added
<$MyScreensMenu_included = 1$>

//At last add the link to the menu item that link called "Link 1"
navBuilder.addChildNodeTo('MyScreens', 'item', 'id==link1', 'label==Link 1', 'url==http://www.google.com');
<$endif$>

The code in blue is javascript code and in red is idocscript, also notice the following idocscript variable "MyScreensMenu_included" only defined when we used it that is because idocscript language doesn't need you to define variable before using them (Unchecked types language)

Pilanesberg Park - South Africa

I visited last Saturday the Pilanesberg Park in South Africa, it was awesome to see animal in the natural life, and I want to send special thanks for Johan and his wife from South Africa because John arranged for that and he took to that beautiful park. I enjoyed my day there watching animals and natural life. I think it's worthy to visit South Africa again but as a tourist.

I was confused because of SecurityFilter component

I am in a workshop in South Africa, and before I begin in exploring WebDAV, I installed HowToComponents sample, then suddenly While I am exploring WebDAV administration I discovered WebDAV is not working. I tried to resolve the problem but I failed where I was thinking the problem may be from WebDAV configuration or from Folders component. So I returned to the last snapshot of my lab virtual machine.

The story not ended yet, I discovered on of the attendees is facing the same problem and of course I should resolve it - I can not escape :)-

I was sure that the problem is trivial one but when I discovered that problem is from SecurityFilter component (part of HowToComponents bundle), I wanted to kill myself because I face the same problem before from 1.5 years.

Don't use SecurityFilter sample component with WebDAV

South Africa

I visited today two parks in South Africa lions park and crocodile park, and I was lucky to watch lions eating and also crocodile but of course they are not in jungle and they are not hunting. But I was missing an important thing accompany, my family or my friends.

I took these pictures

From Dubai to Johannesburg

I got a long flight from Dubai to Johannesburg 8 hours with stops, the longest trip I had in my life. I finished Dubai UCM workshop, and I think it was successful in helping Oracle partners to know more about the product, and in giving them a push to work on the product.

Now I am in Johannesburg to give another workshop, of course repeating my words again :) and again. I wish I will give another successful workshop there. By the way until know all South African people are so nice with me, and Oracle South Africa is very beautiful and organized.

Finally Site Studio 10gR4

Finally I downloaded Oracle Site Studio 10gR4, the latest release. Every time I was trying to download it, it fails. But that's because of internet connection of course, where I am currently in Dubai and internet access from hotel is very expensive, so I access internet from any coffee shop.

Anyway I downloaded it and after I explore it, I will blog on it. I heard about that release from one month in Customer Update Webcast that is being held every three months by Oracle.

You should download it, and try it because of the many enhancements added to it.

Using File Store Provider to Store Content files in database

Using File Store Provider to Store Content files in database

Here are the steps for doing this

1. Open Content Server providers page


2. From the providers page edit “DefaultFileStore” provider, by opening “Info” link


3. Enable file store provider by clicking on “Upgrade” button


4. Restart content server

5. Repeat Sep 1 and 2, and then click on “Edit” button

6. By default, there is a Storage Rule created for you, and we will edit this rule (if you want, you can add new rule). In “Edit File Store Provider” page, click on “Edit Rule”


7. “Storage Rule” page, choose “JDBC Storage” option, and in “Renditions” list, don’t choose anything (not choosing any rendition option means, we will store both the original file and weblayout file in the database). Don’t change Path information.


8. Open “File Store Administration” page


9. Click on “Add Partition” button


10. On “Add Partition” page, add “Partition Name” field that you want, and in “Duplication Methods” choose link which means that if the original file has not been converted, a link to the original file will be used (instead of making a copy of the file, which is duplicating the content)

Note, choosing link in “Duplication Method”, will save space in the database, because large part the content will not be converted


11. Restart content server
    
12. We want to test what we did, so we will check-in a new file into the content server.
13. Query the database table “FileStorage”, you will find primary file and weblayout files added into two records and that two records identified by dID

I still have questions about File Store providers, and I wish some can help me

• How many partitions should I create?
• What about the old content that is already stored in file system?

BUG: DRG-10599: column is not indexed

I got this error message "DRG-10599: column is not indexed ", I tried to solve it using Content Server Zone Field Configuration but I failed. Where The problem was from dDocFulltext field in IdcColl1 & IdcColl2 tables.

I solved it by indexing that field directly on the database, using this query

CREATE INDEX idxDDOCFULLTEXT1 ON STELLENT.IDCCOLL1(DDOCFULLTEXT) INDEXTYPE IS CTXSYS.CONTEXT PARAMETERS ('SYNC (ON COMMIT)')

CREATE INDEX idxDDOCFULLTEXT2 ON STELLENT.IDCCOLL2(DDOCFULLTEXT) INDEXTYPE IS CTXSYS.CONTEXT PARAMETERS ('SYNC (ON COMMIT)')

If you have the same problem with dDocFullText use that query, but If you have it with other fields use Zone Field Configuration

ECM Workshop - Dubai

I am currently in Dubai, and I am giving first Oracle UCM workshop there for partners. It's my first visit to Dubai, and I liked it, where everything in Dubai is new and organized.

I finished my first week in the workshop, and I have some comments on the workshop. Before writing my comments, I want to say, this is my second UCM workshop and might be I don't have enough experience in teaching.

My comments are as following
- Workshop attendees are from different knowledge backgrounds, I have Business Analysts, I have coders (only, they need code), I have administrators, and I have technical consultants
- I have fuzzy agenda for the workshop
- I didn't get any support from Oracle guys in Dubai regarding partners Orientation
- Attendees are employees in Oracle Partners, and they need me to give them a complete real scenario for implementing UCM, and everyone has his own scenario
- They want me to compare between UCM and other compatitor products, however no one of them heard about ECM, and any related standards

I don't know if my comments are right or not, but I think partners need more orientation, and If they want to work on ECM market, they will need to learn about ECM concepts in general. Where those partners want to reply on tenders and they want to estimate costs, also they want to design a solution for the customer. I can not learn them everything because of the workshop time, and I am just covering administration , using, and Site Studio.

The problem of choosing workshop attendees, As I saw those partners are not willing to dedicate resources for UCM, but they are catching opportunities and allocating resources according to the opportunity but as an example, the problem if they are allocating developers for that opportunities, the developers will try to customize all the application or building another application using J2EE and making UCM as back-end, where developers have not enough UCM knowledge.

In general I am not satisfied with ECM market in Middle East and especially with UCM.

Cloud , Utility , and Grid Computing.

Like Web2.0, Cloud Computing is a fuzzy word, and everyone seems to have a different definition for it.

I like this definitions that I found in Wikipedia:

"It is a style of computing in which IT-related capabilities are provided “as a service”, allowing users to access technology-enabled services from the Internet ("in the cloud") without knowledge of, expertise with, or control over the technology infrastructure that supports them."

We can see from this definition the relation between cloud computing and SaaS (Software as a Service), where you provide software solutions as services on internet (it is stored on internet, and cached on your machine) like Google Calendar, GTalk, Google Docs applications offered by Google Apps.

In cloud computing, information and persistence data is permanently stored in servers and data centers on the internet and cached temporarily on clients

I am not sure about the difference between cloud computing and grid computing, but I think cloud computing is using and utilizing grid computing.

I am still confused about the difference between Cloud Computing, Utility Computing, and Grid Computing.