Sabri EKER

New Address

2009-12-07T18:57:00.000+02:00

Hello everyone,

I will continue to write at my new place Sabri Eker . This blog will not be deleted, but new entries can be found at this address.

Thanks everybody.

At the End Of Third Month

2009-11-17T16:13:00.000+02:00

This blog is not being written to get millions of readers everyday. It aims to share Business Objects SDK information with everybody over the world. And it is nice to see that lots of people are reading or entering to the site over the world at the end of the third month.
After a while, I checked out the visitors country I saw different countries like Vietnam, New Caledonia,Sweeden,Israel and lots of in the country list and it makes me smile because it means that I achieve my first goal which is sharing knowledge over the world at the end of third month of this blog.It is still kind of starting. Because for a blog I don't believe third month is not enough time to get results that blogger wants. But for starting it is nice because this blog has been written over 3 months and it is nice to reach lots of people all around the world. (At this point I want to say sorry because of English but I hope this blog helps you to find something usefull for your problems).
I am not writer or blogger , I just want to share my information and experiences with you. And blogging started to get a place in my life beside reading :) . At the end of the third month I think make a list for this blog's goals. I may work on it tonight.
Again I am saying that if you want help related Business Objects SDK, I gladly help you. Because I believe that sharing information makes me more experienced. ( Again sorry for my english )

ValueFromLov Has Different Approach

2009-11-17T15:50:00.001+02:00

Yes ValueFromLov object has a different approach to values you insert to it. But to figure out the problem reason is more complicated than it is being. And here is the solution with a small tip. I hope it helps you.
In my last project I have faced a problem because of ValueFromLov object and its values which involves "_" character. It is interesting. Because if you use this object like this;

   ValueFromLov tmpValueFromLovObj = new ValueFromLov("BO_USER");

You get a tmpValueFromLovObj object which has a value "USER" not "BO_USER". Because in the constructor of the ValueFromLov class "_" character is tokenizer character to tokenize your values. If you look at objects methods for above tmpValueFromLovObj you can see that

   tmpValueFromLovObj.getValue() method returns "USER" String and
   tmpValueFromLovObj.getRowIndex() method returns "BO" String

It can give you headaches to resolve, because with eclipse you can not get any tips about object constructor or in api you can not see anything related this.

Here is the certain solution for this kind of problem is ;

   ValueFromLov tmpValueFromLovObj = new ValueFromLov("", "BO_USER");
   tmpValueFromLov.getValue() returns "BO_USER"

and happy ending at least for me. :)

And why Business Objects make ValueFromLov this kind of use. I think this is because of using this object when getting data from warehouse. Value structure is bit more complicated than relational database value structure. Keep it mind.

Using Blogs to Find Something New

2009-11-17T14:21:00.000+02:00

I am a software engineer that I am. I develop projects which are based on requirement lists. It is an awesome job for me, to coding. But sometimes it becomes boring or annoying and at that point I want to read , see new technologies, new ideas which inspire me or give me a breath.
It may be late for me but to figure out or trying to figure out Google applications is a break point for me to follow technologies, blogs or what ever it is. My favorite one is Google Reader. I have lots of sites that I read or look up everyday. In time it becomes hard to enter each site and may be boring or sites can be forgotten. At this point Google Reader is an awesome application for me. (Maybe IGoogle is more popular but it is too complex to find something.) And Reader is fine and simple for me. Because, as a developer if you develop something you should develop it for dummiest users and simpliest way. May be you can present new technologies that is not ever used but you should present it with simpliest way for people to own it. And reader is simple and usefull for me to track my rss feeds. I advice it everyone around me.

After figure out process of Google Reader, blogs take an important place in my mind. May be everything is not true or fit for me which is written in blogs but it is awesome to read lots of different ideas. It is an interesting thing for me to combine different ideas which are taken from different blogs different unrelated entries.

Sorting Webi Documents LOV

2009-11-13T13:10:00.000+02:00

In web intelligence documents for sorting prompts I am using;

if(strDocumentKind.equalsIgnoreCase("Webi"))
tmpPrompt.getLOV().setSortType(SortType.NONE);
else
tmpPrompt.getLOV().setSortType(SortType.ASCENDING);

For web intelligence documents I am setting sortType as None, Web Intelligence report builder automatically sorts the LOV. But in desktop intelligence documents it must be done by you.

Blogging and Me

2009-11-12T23:46:00.001+02:00

I have started to write to this blog for a reference who want to develop something or solve problems for Business Objects SDK. I started to develop something with BO Sdk over a year ago. I was having problems for finding a reference for sdk. After a year I have developed or been development team and I faced lots of problems. End of the august I want to share my problems and solutions for bo.It is exiciting to see that someone coming and reading my posts. But I am not sure that you are getting benefits from my entries. I just want to say , I am open to help anybody for anything which I know or I can help. You can leave comment or send email via sabrieker@gmail.com

Besides this, blogging is not a suitable thing for me to, because of this( and my projects) I am writing or commiting rarely.Blogging is an amazing to do, I hope in a time I will love to blogging. If somebody gives me advices about blogging or comments me for my simple blog to improve it may be nice too.

Notes: Someone is coming my site via searching with me , it is more exciting for me besides what your goal is :)

Viewing Reports Without OpenDocument Cont.

2009-11-04T13:17:00.001+02:00

Hello everybody,

Today I am gonna try to explain how you can use BO InfoView application to show your reports. You will put this code peace in a jsp file and copy that file to [TOMCAT_PATH]\webapps\AnalyticalReporting\viewers\cdz_adv path. You must submit parameters to this jsp;
strDocID : Document Id
docKind : Document Kind , webi or FullClient
token : To login you to EnterpriseSession
PROMPT_k : k is a range starts with 0 to prompts count

And the code, before code part I want to say that if you use this piece of code to customize your InfoView application BO does not support it for any exception or problem.You are all on your way.

And here is my code piece.

import="com.crystaldecisions.sdk.framework.*,com.businessobjects.infoview.common.*,com.businessobjects.rebean.wi.*,java.net.*,java.util.*,java.io.*,java.text.DateFormat,java.text.SimpleDateFormat,com.dcat.jimet.ServiceLogger"

String strDocID = request.getParameter("strDocID");

try{
String docKind = request.getParameter("docKind");
String strToken = request.getParameter("token");
String strServerName = request.getServerName();
String strServerPort = String.valueOf(request.getServerPort());

//taking Enterprise Session Objet
IEnterpriseSession entSession = (IEnterpriseSession)session.getAttribute ("CE_ENTERPRISESESSION");
if (session.getAttribute ("CE_ENTERPRISESESSION") == null)
{
try{
entSession = CrystalEnterprise.getSessionMgr().logonWithToken(strToken);
session.setAttribute("CE_ENTERPRISESESSION",entSession);
}
catch(Exception ex)
{
out.println(" : could not retreive enterprise session -> " + ex.toString());
return;
}
}else{
System.out.println("strDocID "+strDocID+" entSession.. " + entSession);
}
String userName = entSession.getUserInfo().getUserName();

String strViewerID = session.getAttribute("CDZ.InstanceManager")!=null?"1":"";

//Take user responsile ReportEngines not from session
ReportEngines reportEngines = (ReportEngines)entSession.getService("ReportEngines");
session.setAttribute("ReportEngines",reportEngines);
if (reportEngines == null)
{
reportEngines = (ReportEngines)entSession.getService("ReportEngines");
session.setAttribute("ReportEngines",reportEngines);
}
//take Report Engine for document Kind
ReportEngine objReportEngine = null;
if(docKind.equalsIgnoreCase("FullClient")){
objReportEngine = reportEngines.getService(ReportEngines.ReportEngineType.FC_REPORT_ENGINE);
}else{
objReportEngine = reportEngines.getService(ReportEngines.ReportEngineType.WI_REPORT_ENGINE);
}

//Open document
OpenDocumentParameters odp = new OpenDocumentParameters(-1,true,false);
DocumentInstance webiDocument = objReportEngine.openDocument(Integer.parseInt(strDocID), odp);
//refresh document because of saved things
webiDocument.refresh();

Prompts webiPrompts = webiDocument.getPrompts();
for (int k=0 ; k
{
Prompt tmpPrompt = webiPrompts.getItem( k );
String strValues = request.getParameter("PROMPT_"+k) ;

SimpleDateFormat webiFormatLocale = new SimpleDateFormat(tmpPrompt.getInputFormat());

StringTokenizer tokenizer = new StringTokenizer(strValues,";");
Vector tempValVect = new Vector();

String strRowIndex = "";
while (tokenizer.hasMoreElements())
{
strRowIndex = (String)tokenizer.nextElement();

strRowIndex = strRowIndex ;
if(strRowIndex.indexOf('%')>0){
strRowIndex = strRowIndex.replaceAll("%", URLEncoder.encode("%","ISO-8859-9"));
}
if( !(tmpPrompt.getObjectType() == ObjectType.DATE && docKind.equalsIgnoreCase("webi") ) ){
StringTokenizer tokForDelimiters = new StringTokenizer(strRowIndex,";");
while(tokForDelimiters.hasMoreElements()){
String prmptVal = tokForDelimiters.nextToken();
tempValVect.add(new ValueFromLov(prmptVal));
}
}
}
if(tmpPrompt.getObjectType() == ObjectType.DATE && docKind.equalsIgnoreCase("webi") ){
if(strRowIndex.indexOf("/") > 0)
strRowIndex = strRowIndex.replaceAll("/",".");
SimpleDateFormat promptFormat = new SimpleDateFormat("dd.MM.yyyy");
Date parsedDate = promptFormat.parse(strRowIndex);
tempValVect.add(new ValueFromLov(new String(webiFormatLocale.format(parsedDate))));
}
if(tempValVect.size()==0){
tempValVect.add(new ValueFromLov(""));
}else if(tempValVect.size()==1){
if(tempValVect.get(0)==null)
tempValVect.add(new ValueFromLov(""));
}
ValueFromLov[] promptValues = new ValueFromLov[tempValVect.size()];// tmpPromptValuesCnt];
for(int v = 0 ; v
promptValues[v] = (ValueFromLov) tempValVect.get(v);
}
webiPrompts.getItem( k ).enterValues(promptValues);
}
String strEntry = "";
try{
webiDocument.setPrompts();
}catch(CommunicationException commExp){
session.setAttribute("dcatViewerException",commExp.getLocalizedMessage());
throw commExp;
}catch(ServerException servExp){
session.setAttribute("dcatViewerException",servExp.getLocalizedMessage());
throw servExp;
}catch(Exception exp){
session.setAttribute("dcatViewerException",exp.getLocalizedMessage());
throw exp;
}

strEntry = webiDocument.getStorageToken();

session.setAttribute("isSessionAlive","true");

String strURL = "viewDocument.jsp"+
"?sEntry=" + strEntry +
"&kind="+docKind+
"&lang=en"+
"&viewType=I"+
"&forceViewType=I"+
"&id="+strDocID+
"&iViewerID="+strViewerID+
"&customPrompt=true" +
"&sRefresh=n";
response.sendRedirect(strURL);
return;
}catch(Exception ex){
out.println("An exception occurred");

}

I hope it helps you for your need.

Date Type Problem in Webi Reports Solved

2009-10-21T21:15:00.002+03:00

In a long time I have been faced with date type problem in Business Objects SDK in DocumentInstance class's setPrompts method. Now I am proud to tell you the exact solution. But it will be the duplicate of the my early post.

Here;
//Get DocumentInstance Object and in a loop take your prompt
Prompt tmpPrompt = webIntelligenceDocumentPrompts.getItem( k );
//With this line , learn the format of prompt which must be given
SimpleDateFormat webIDatePromptFormatLocale = new SimpleDateFormat(tmpPrompt.getInputFormat());
//My control for date type objects

if(tmpPrompt.getObjectType() == ObjectType.DATE){
   //I take dd.MM.yyyy format value from user, when I have a value
SimpleDateFormat promptFormat = new SimpleDateFormat("dd.MM.yyyy");
   //It parsed to Date object
Date parsedDate = promptFormat.parse(strRowIndex);
   // parsedDate object formatted via prompt date format and created a String object and it is put into a vector
   tempValVect.add(new ValueFromLov(new String(webiFormatLocale.format(parsedDate))));
}
// after all values for prompt put into the vector and then this values taken from vector and entered to ValueFromLov kind array then , array entered to prompt
webIntelligenceDocumentPrompts.getItem( k ).enterValues(promptValues);

But in this code you must to be sure at ReportEngines object. All the solution is based on it. You must use same ReportEngines object which you have open the Document. I am solved it today over 3 hour. If you set prompts with above code piece and send it to different ReportEngines object it may show DocumentInstance last saved data.Be sure to use same ReportEngines object.

This solution is tested and after tomorrow it will be used by over 8k BO end users.
And an addition to this post , a irrelevant note; be sure to close ReportEngines object after your work done with it.
Have a nice days.

Certain Solution Prompt Solution For Datetime

2009-10-15T11:37:00.001+03:00

For a while I have been encoutered Date format problem with Web Intelligence Reports in BO 3.1. I have a find a temporary solution but sometimes it does not work. Anyway a response from BO for this kind of solution is like this:

//Get DocumentInstance Object and in a loop take your prompt
Prompt tmpPrompt = webIntelligenceDocumentPrompts.getItem( k );
//With this line , learn the format of prompt which must be given
SimpleDateFormat webIDatePromptFormatLocale = new SimpleDateFormat(tmpPrompt.getInputFormat());
//My control for date type objects

if(tmpPrompt.getObjectType() == ObjectType.DATE){
   //I take dd.MM.yyyy format value from user, when I have a value
SimpleDateFormat promptFormat = new SimpleDateFormat("dd.MM.yyyy");
   //It parsed to Date object
Date parsedDate = promptFormat.parse(strRowIndex);
   // parsedDate object formatted via prompt date format and created a String object and it is put into a vector
   tempValVect.add(new ValueFromLov(new String(webiFormatLocale.format(parsedDate))));
}
// after all values for prompt put into the vector and then this values taken from vector and entered to ValueFromLov kind array then , array entered to prompt
webIntelligenceDocumentPrompts.getItem( k ).enterValues(promptValues);

It seems like a best solution for date format problems during the DocumentInstance setPrompts method.
I test it and verified :) have a nice coding days

Important Edit
Again it does not work in customer server. I could not understand the problem , it is working without any exception in test platform on my server. I am suspicious about customer db relation , because I am getting lots of exception because of db connections.But still I could not find any reason to get an exception

Viewing Reports Without OpenDocument

2009-10-06T22:22:00.000+03:00

hello everyone,

I realized that most of visits to my site is because of finding a solution to view Business Objects reports,Web or Desktop does not matter.Nowadays I will try to prepare an entry for viewing documents with a different way, no opendocument. (I have never use that method :) )
For this you should know Java , jsp and a bit javascript. I hope to write entry in this weekend. But I am not sure about restrictions because of law related sharing something about customization on codes which are coded by Business Objects.
I will try to show you that you can use AnalyticalReporting context which can be find under Business Objects Tomcat webapps. Under AnalyticalReporting viewDocument.jsp and viewer.js will be our entrance points.
If you make comments something that I know I will try to answer which I know or you can mail me.Feel free to write and comment about anything.

Realization of Social Network In Turkey

2009-10-04T00:27:00.000+03:00

over 6 months I realized the power of the social network with twitter, blogging, linkedin etc. And in the last 2 or 3 months I have been trying to use it with all abilities ; bloggin, twitting, social networks, google reader for rss feeds for over a hundred feed.
With this timeline I am trying and wondering who is following, from which country people visiting my site google analysis. This combination of internet oppurtunities giving me new vision. Making new lists for my career plan.
But last weeks I realized the power of the social network I got a phone call for job offer via linkedin.com. It was nice to realize that your works are valuable for somebody and it makes you happy, at least me :) .
I was reading lots of entries about power of social networks but it sounds new thing for Turkey job process or any other process. But this job offer make me wrong :) and I was glad.

A Long Break Of The Year

2009-10-04T00:16:00.000+03:00

First of all I want to apologize from everyone who visits my blog for looking something new about Business Objects. Because of a small vacation and problems of multi-working on several projects.
But I want to inform you that I will be in a while with same synchronization about wonderfull Business Objects problems and solutions.
As I mentioned about solutions about Business Objects , I am still working on a product which is named Business Objects Bulk Object Manager with simple abilities.I hope it will be ready in 2 or 3 weeks. Maybe I will be published some screenshots in this timeline.
Ps: I missed blogging :)

A Simple Difference in Web Intelligence Reports

2009-09-11T23:10:00.000+03:00

In my last Business Objects 3.1 Java SDK based portal aplication I faced with a simple problem at Webi prompts.
Where the problem is some multiple or mono constrained prompts have "*TÜMÜ" value, a turkish word implies All , and when I set setSortType(SortType.Ascending) in the LOV of the prompt, it sorts prompt values which have "*TÜMÜ" as a word which begins with "T" and coming at somewhere at the end of the list. But customer uses this value which can be seen at the top of the prompt values so the client can select it easily.
But when I set sorttype for same webi report twin Desktop Intelligence report, it sorts values and "*TÜMÜ" value coming at the top of the list because of "*" value.
It is interesting I didn't set any sortType for webi kind reports and prompt values listed as I wanted.Prompt values list starts with "*TÜMÜ". But I must set sort type for desktop intelligence reports.

bir ankara güncesi

2009-09-04T20:24:00.000+03:00

bunu yazmak istemiyordum ama otobüstede yapacak bişey yok, saat de erken yatmak için bari bişeyler karalayım.
Ankara bildim bileli sevilecek bir şehir değil, 3 yada 4 kere bulundum doğru düzgün gezinmedim bile, peki böyle bir yorumu neye dayanarak yapıyorum. Ya kardeşim bir insanın içi daha otogarda inince de sıkılmaz ki yav. havasından mıdır suyundandır bilmiyorum ama yok kardeşim olmuyor. İçim ısınmıyor bu şehre istanbul iyi, hem de çok iyi. :) ankara olmamış.

Notlar:

Bunun yanı sıra giderken varan ile gittim bişeyi farkettim, varanın şöförü olsa da türk şöförü aynı, arabesk dinliyor ve en ön sıradakilere de dinletiyor. :)
Oruç tutacağım diye varanın on numara kahvaltısını kaçırdım ya bişey diyemiyorum, ağzım varmıyor.
Otobüste internet olayı süper ötesi bişey ya, bayıldım. bi de müzik listeleri doğru düzgün olsa daha iyi olabilir.
"ya paramız olsa da hep otelde yaşasak" şeklinde bir yaşam akımı yada ne biliyim grup yada ne varsa dahil olabilirim.
otelin odasından enteresan bir not : banyo ile yataklar arasında sadece bir cam var, nasıl bir dizayn neye hizmet yorum sizin :)
maliye bakanlığına gittim, yanındaki bina tbmmymiş bişeye de benzemiyordu
kızılay meydanı, sakarya caddesi (atmıyorsam :p) "eh işte" puanı veriyorum
kızılay meydanındaki otobüs ve dolmuş durakları on numara :D insanlarla iç içe, insanlar eziliyormuş orada , bana öyle dediler
acaip bir trafik var , "bu ne bea, istanbul'da bile bu kadar trafik yok" yorumunu yaptım, taksi şöförüne, "öyle abi, ben de anlamadım, bir kaç seneye istanbulu geçeriz" dedi.
büyükşehir sanırım her yere metroyu birden götürmeye çalışıyor yada yer altında ne yapıyorsa hepsini birden yapmak istiyor anlaşılan, çünkü bütün her yer inşaat alanı gibi ya
kamu çalışanları çok enteresan tipler :) örnek: girin bir kamu dairesine anlarsınız :)
işimi hallettim en güzel yanı oydu, ama gecede çalıştığım için gece çıkamadım, bir daha ki sefere inşallah
koçsistemde çalışanların anlattığına göre cennette çalışıyorum farkında değilim, patrona teşekkürler sevgiler saygılar okuyorsa hehehe

Sonuç olarak ne çıkarabilirim kendime, ankara gezilecek bir yer değil otelde de kalsan. mecburi değilsen boş ver ankarayı izmir iyi seçenek. :)

Bypassing InfoView Logon Page, It was easy than I hope

2009-09-04T19:52:00.000+03:00

Hello,
After a lot of search in internet with nothing, last night I slept late. In the morning with a twit from creibl, run me to search again with different keywords in http://www.forumtopics.com/busobj/ forum. With my luck I found the my solution in the first result. :)

Here is my solution, that may help you in somewhere:
IEnterpriseSession entSession = null;
ISessionMgr sessionMgr = CrystalEnterprise.getSessionMgr();
ITrustedPrincipal principal = sessionMgr.createTrustedPrincipal(userId,cmsName,key);

entSession = sessionMgr.logon(principal);
// Store Enterprise session in HttpSession
session.setAttribute("MyEnterpriseSession", entSession);
// Construct URL
// ivsEntSessionVar is the reference to the HttpSession variable.
String url = "http://"+request.getServerName()+":8090/InfoViewApp/logon/start.do?&ivsEntSessionVar=MyEnterpriseSession";
//store a value that define entsession is coming from mine logon application
session.setAttribute("dcatSmartLogin","true");
response.sendRedirect(url);

That is it, all my problem is solved with url. But it become too hard to find it.Anyway,I solved my problem, I hope it helps you in somewhere.

Bypassing InfoView Logon Page

2009-09-03T22:37:00.000+03:00

hello everyone,

I am working on bypassing logon page in InfoView application for Business Objects 3.1 but I could not figure out a solution.
I have googled ( http://bit.ly/mYEaJ ) and look at several solutions. (http://bit.ly/3ssBt ) is the most usefull seem to me but it has a problem that I could not figure out why. It worked for one time and showed me home page direct passing the logon page, but when I clicked Document button it log me off. And give me "Logon denied: Your session is not valid or has expired" exception. I could not solve the issue .
But I must find a solution tonight. Integration will be made tomorrow and application will be get alive.

If somebody give me hand , I will be really appreciated.

Business Objects Bulk Object Manager

2009-08-29T23:29:00.001+03:00

Today, I started to coding for Object Manager application that is a inspiration from a migration project and apos applications. Application is being based on the Business Objects XI 3.1 Java sdk.

I am trying to build something because with Business Object Cmc application we, Business Objects Administrator Users, can only assign security levels and rights for a object for once time. If we want to assign security rights/levels, we have two options. First one is the putting same kind objects(means reports) in same folder . second one is preparing groups those handle our principals. But if our objects must be in different folders because of business needs and preparing a group for each principal creates lots of groups again because of business needs.

At this point I am preparing a matrix table occurance of groups/users and objects(folders,reports,etc.). In the intersection of the user/group and object shows you a drop down list. In the list you will be able to see "Full Control","Inherit","No Access","Schedule","View","View On Demand" and "Advanced". At this point when you select "Advanced" option box will be opened and show you advanced security rights/levels assigned for object/user combination.Through this box you will be able to assign levels/rights.

Today,for begginning, I prepared selecting user/group and object pages. Prepared demo page, for static object and user/group , which can show rights and levels. And at the end I figure out a way to entegration my application with Cmc Application of the Business Objects XI 3.1 .

Now at the begginning of the my project a few days I will be concentrated on the api for security levels and rights. And I will prepare classes for helping me through the flow.

For now I think it will be a nice plug-in for Cmc application. This is enough for day one. (:

New Business Objects XI 3.x Based Application Plan

2009-08-26T02:23:00.004+03:00

Inspiration from apos application Object Manager, I think a web based bulk object manager plug-in can be done for Cmc application for Business Objects XI 3.x versions.

I started to plan main requirements for security and preparation of users/groups and objects combination. I will start new application at this weekend in my free time.

But I didn't check have I can put a shortcut in to the Cmc application. Because I thougt that this plug-in will be must be added application in to Cmc for big enterprises. I saw that BO Administrators and consultans are spending their time ,like one or two weeks for a migration, for checking users and groups securities.

Apos Technology made this (http://www.apos.com/ObjectManager/Default.aspx) very cleverly but I think it is a simple application and can be done from web browsers.

Ps: I have been working on Business Objects SDK over a year, I liked it. And I started to produce something new for me and useable, at least I think.

Extra Note: I didn't search Business Objects web site for this kind of application , may be there is a solution they did. I made a simple search over the official site but I couldn't find something related with my opinion, I will look again deeply late.

Something is Logging to stdout.log, But who

2009-08-25T12:07:00.005+03:00

Hello everyone,

I have deployed an application on to the Tomcat 5.50 Application server that is used to show Business Objects applications and it is under Business Objects path. Anyway. My application is logging with log4j utility. InfoView application was not logging anything to stdout.log file,it was disabled with web.xml attributes. But when I deployed my context,my application to Tomcat (under webapps path) it started to log something,may be related with InfoView but I don't think so. I could not understand the reason.

And you can see a sample log here :

778908187 [ContainerBackgroundProcessor[StandardEngine[Catalina]]] DEBUG org.apache.catalina.session.ManagerBase - End expire sessions StandardManager processingTime 0 expired sessions: 0

778968281 [ContainerBackgroundProcessor[StandardEngine[Catalina]]] DEBUG org.apache.catalina.session.ManagerBase - Start expire sessions StandardManager at 1250152454252 sessioncount 0

778968281 [ContainerBackgroundProcessor[StandardEngine[Catalina]]] DEBUG org.apache.catalina.session.ManagerBase - End expire sessions StandardManager processingTime 0 expired sessions: 0

779028374 [ContainerBackgroundProcessor[StandardEngine[Catalina]]] DEBUG org.apache.catalina.session.ManagerBase - Start expire sessions StandardManager at 1250152514345 sessioncount 0

779028374 [ContainerBackgroundProcessor[StandardEngine[Catalina]]] DEBUG org.apache.catalina.session.ManagerBase - End expire sessions StandardManager processingTime 0 expired sessions: 0

779088467 [ContainerBackgroundProcessor[StandardEngine[Catalina]]] DEBUG org.apache.catalina.session.ManagerBase - Start expire sessions StandardManager at 1250152574438 sessioncount 0

779088467 [ContainerBackgroundProcessor[StandardEngine[Catalina]]] DEBUG org.apache.catalina.session.ManagerBase - End expire sessions StandardManager processingTime 0 expired sessions: 0

If you have any ideas, tell me :)

DATE Type Problem Cont

2009-08-14T23:33:00.007+03:00

Hello again,

I have faced an exception with a few days ago. I could not figure out reason. But I choose a solution for temporary,at least I think. But I couldn't understand the reason. But what I tried to find problem;
First I thought that the main problem is my problem because of prompt value passing between jsp pages so I set the prompt value with a standart date value for DATE type prompt objects like 12/01/2009. And it worked but in InfoView app 12.01.2009 value is working and 12/01/2009 value throws an exception. But in the second try 12/01/2009 value is not working.I controlled regional settings, report at InfoView application.

I could not understand. Because my application is working for fine for Desktop Intelligence reports. In the second phase of the project I made some changes for Web Intelligence reports. At the second phase for DATE type prompts, application throwed exception as I mentioned.

Edit : After reading this entry look at it ( Last Update Of Code Piece )

I am adding my code below ;

String docKind = request.getParameter("docKind");
String strToken = request.getParameter("dcatToken");
String strDocID = request.getParameter("strDocID");
String strServerName = request.getServerName();
String strServerPort = String.valueOf(request.getServerPort());

IEnterpriseSession entSession = (IEnterpriseSession)session.getAttribute ("CE_ENTERPRISESESSION");
if (session.getAttribute ("CE_ENTERPRISESESSION") == null)
{
//Logging cms with token come from another context
try{
entSession = CrystalEnterprise.getSessionMgr().logonWithToken(strToken);
session.setAttribute("CE_ENTERPRISESESSION",entSession);
}
catch(Exception ex)
{
//Expcetion handleing
out.println("dcatCustomPromptViewer.jsp : could not retreive enterprise session -> " + ex.toString());
return;
}
}else{
//It means exception
}

// trying to look for viewer id used in viewDocument.jsp, but last working one it is not passing to viewDocument.jsp
String strViewerID = session.getAttribute("CDZ.InstanceManager")!=null?"1":"";

ReportEngines reportEngines = (ReportEngines)session.getAttribute("ReportEngines");
if (reportEngines == null)
{
reportEngines = (ReportEngines)entSession.getService("ReportEngines");
session.setAttribute("ReportEngines",reportEngines);
}
ReportEngine objReportEngine = null;
if(docKind.equalsIgnoreCase("FullClient")){
objReportEngine = reportEngines.getService(ReportEngines.ReportEngineType.FC_REPORT_ENGINE);
}else{
objReportEngine = reportEngines.getService(ReportEngines.ReportEngineType.WI_REPORT_ENGINE);
}

OpenDocumentParameters odp = new OpenDocumentParameters(-1,true,false);
DocumentInstance webiDocument = objReportEngine.openDocument(Integer.parseInt(strDocID), odp);
webiDocument.refresh();

//Set all prompts of document instance

Prompts webiPrompts = webiDocument.getPrompts();
for (int k=0 ; k0){
strRowIndex = strRowIndex.replaceAll("%", URLEncoder.encode("%","ISO-8859-9"));
}
//Here I print the prompt values which are DATE Type
if(tmpPrompt.getObjectType() == ObjectType.DATE)
System.out.println("dcatCustomPromptViewer.jsp strRowIndex"+strRowIndex);
promptValues[tmpIx] = new ValueFromLov(strRowIndex);
tmpIx++;
}

if(promptValues[0] == null)
promptValues[tmpIx] = new ValueFromLov("");
//Setting values for prompt
webiPrompts.getItem( k ).enterValues(promptValues);
}
//After entering values for prompts, this setPrompts() method throwing exception

System.out.println("dcatCustomPromptViewer.jsp : setPrompts ");
webiDocument.setPrompts();
System.out.println("dcatCustomPromptViewer.jsp : setPrompts ended");

String strEntry = webiDocument.getStorageToken();
//After succesfully setting prompts getting document instance token

session.setAttribute("isSessionAlive","true");
String strURL = "viewDocument.jsp";

DATE Type Problem

2009-08-04T16:46:00.005+03:00

Hello everyone,

I am working on getting prompts of webi , setting them and viewing the report.

It is working for brilliant for Desktop documents for DATE type prompts values like 12.01.2009.
It is nice if I work with InfoView for web documents with 12.01.2009 value.

But an exception is raising when I set 12.01.2009 value to prompt with my application.
I start again and set prompt as 12/01/2009 it works fine. but when I refresh again page, in the second shot 12.01.2009 value works fine.

I didn't understand any reason. only exception is raised during setPrompts() method like something "x named prompt Date value is not true".

can anybody help me?

Edit: is anybody have a solution? I think it is because of Internet explorer 7's abilities.

Second Edit: It is not related thing with IE. today I tried to setPrompts method twice. because, when I get exception because of setting date, I tried to change date value to dd/mm/yyyy and make setPrompts() method again. After that I got exception new one. com.businessobjects.rebean.wi.ServerException: An internal error occured while calling 'answerPrompts' API. (Error: ERR_WIS_30270)
I didn't understand anything.

I want to learn during the prompt value setting. Must we set Date type prompts with a skilled class or is string enough.

Document Modified Alert

2009-08-02T22:54:00.003+03:00

if you don't want to see or customizing your InfoView application because of your needs and dont want to see Document Modified alert in the InfoView application this hint will help you, i hope.

At the Business Objects server under Business Objects path ; Tomcat55\webapps\AnalyticalReporting\viewers\cdz_adv\language\en\scripts at this path you will find viewer.js file which works for script works at the InfoView page for working on BO based report documents.

In the viewer.js search for isDocModified function , this function that you need which handles modification alert. If you dont want to see you can delete or comment inside of this function.

Another hints this js file is called from ;

Tomcat55\webapps\AnalyticalReporting\viewers\cdz_adv\viewDocument.jsp .

You can make some customizations in this jsp file, cos i do.

Prompt All Values Differ Between Desktop Intelligence and Web Intelligence

2009-07-10T10:02:00.007+03:00

yesterday i was redesigning my last projects codes, which is developed for Desktop Intelligence Reports of SAP Business Objects, for Web Intelligence Reports. I was getting session is invalid exception. It is unusual i didnt realize the core problem but i figure out the problem. in desktop intelligence documents i was opening document in a jsp and preparing required objects and storing them at session after that i was redirecting the page next page to show the prompt values. but i could not do same thing at web intelligence documents. i changed code with getting prompt all values at same page which i open the document. it is weird but i could not understand core problem, if someone reads and writes something, i will be indebted.

note: i have solved the problem. i make this;
1.open the document and get the document storage token
2.in the second page or where you want to get prompts, open document again with document storage token.
with this solution i can take prompt values in anywhere where i want for web intelligence documents.
but i could not understand the difference between desktop intelligence document and web intelligence document!

ps: dont forget to refresh document instance object after you open it.

Change Windows AD Authentication Values

2009-07-02T12:16:00.006+03:00

Hello again,

Today I want to share with you a simple code for Business Objects XI 3.1 SDK for Windows AD authentication. With this code sample you can change your windos domain name and password.

/*
Query for WindosAD object
*/

String strQuery ="SELECT TOP 1 * FROM CI_SYSTEMOBJECTS WHERE SI_NAME='secWinAD'";

/*
You have to login BO before run this code take infostore after login process
*/

IInfoObjects auths = infoStore.query (strQuery);
if ( auths.getResultSize()==0 ){
System.out.println("Did you define Windows AD authentication, we could not find it");
}
/*
BO has only one windows AD authentication and we take it from first index of the defined auths(IInfoObjects object)
*/

IInfoObject obj = (IInfoObject) auths.get(0);

//Conver IInfoObject object to IsecWinAD object for special methods we need

IsecWinAD winAuth = (IsecWinAD) obj;
winAuth.setAdminName("YourDomain/Name");
winAuth.setAdminPassword("YourPassword");
infoStore.commit(auths);
System.out.println("Congratulations, you have changed it.");

Surround code with try/catch statements because if the BO can not set admin name or password it throws exception at the commit method.

I hope it helps you, because I look to much for it.
And here Business Objects Official Page For Windows AD Authentication.

One Year Work Overview

2009-06-19T22:29:00.002+03:00

Today my manager wanted me to send updated Cv to him for a project proposal and I started to update my Cv. And I saw that over the year(14months) I didnt look or write anything to my Cv. After update of Cv it seemed to me different because of last 14 months I have been participated in over 7 projects at more than 8 customers. In some projects I was part of development team, but last ones I am responsible of the projects. It has been seemed different to me because of the counts of the projects. I think I started to work now. I should think about this, on my own .

First Project with BO Env

2009-05-08T09:30:00.005+03:00

Hello again,

Until April 15 I was working on Business Objects SDK related project for a customer in my company. Projects every detail, not general libraries, is developed by me. It was a big project and a nice job for me. Because project's responsible was on me. And it is finished. I feel like new born baby today.

Project has two parts , first part is synchronization with customer user informations from database with BO users. This part was more easy than second part.

Second part is , viewing reports from customers portal via jsp based web site. Users select the report , submit prompt values and view the report independent from BO default InfoView application.

Second part is more time consuming because of customers need. Like lots of Ajax requests. I love Ajax but it is more difficult to develop a static site(: but it worked and I did nice things for visualisation.

I like it and did it well at least I think.

And today I start a new project for my company internal need. And new project again will be on mu responsible.

See ya (:

Welcome

2009-02-23T12:27:00.000+02:00

Welcome to my personal Web Blog. I recently put this together realizing that I had a website with nothing on it! How professional is that? Well I would to let you know that you can feel free to browse throughout my personal website.

The site is till currently under construction but I will be adding things slowly. Throughout the site I will have information about me, contact information and many other upcoming things.