Bobj is undefined – Crystal Reports

March 19, 2012

Hello All,

If you have been working with Crystal Reports and I could bet at least once you might faced the issue “Bobj” is undefined . This is most common error in using crystal reports. Recently I have faced this issue when I try to solve another technical issue on the crystal report.

At least from my experience and users experience in internet, “bobj” is one of well-known problem with CR.  Crystal reports products naming convention is another pain. It is bit difficult to understand the CR products and features from their naming . Lets not worry about that now. Coming to the issue in hand, I am using Visual studio 2010, IIS7.0, Windows 2008 server and CR2008. I want to upgrade CR 2008 with latest SP5. So I have uninstalled the setup and rebooted the server and again installed the fresh version of SP5 full download. Here is link for all downloads of CR.

After un-installation of previous version, I forgot to delete all the CR folders , which caused lot of headache and I ran to “Bobj’ undefined issue and some of the folders are not accessible etc. So finally cleaned up again and deleted all the left over folders and rebooted. Installed SP5 again. The reports started working fine in the deployed link. I mean we have web application which is published in the machine and reports are working. Here I have faced one more issue, though not sure about the cause, when I generate a report, I got an error message “Unable to connect to Database…” ORA code ( I forgot the exact code) . In the .rpt files, I have used many database connections which is the concern. I have deleted all the unwanted connnections and reports are working fine from the same machine.

Now, real challenge started for me, when the application is accessed from outside, reports are showing “BobJ” is undefined error. I could not figure out the reason for this. I was under assumption that if reports accessed from IIS then it accessed from everywhere in the same network. But it was not the case. In order find the issue, I have gone through some of the forums .. here is main link . This really helped me in fixing the issue. This blog post is extensive enough to help to fix the issue. Let me write a solution which worked for my case.

Issue: Missing “crystalreportviewers12” folder in the C:\inetpub\wwwroot\aspnet_client\system_web\4_0_30319.

Fix : Copy the entire ‘crystalreportviewers12’ from crystal report installed path. “D:\Program Files\Common\4.0” to C:\inetpub\..

This is helps in resolving the issue of accessing the crystal reports from the web application outside the network.

Quick check list for this issue:

1. Check CR is installed correctly. Delete all CR folders after un-installation. Especially under IIS. (C:\inetpub\wwwroot)

2. Install complete version of CR’s.

3. Check whether CR web site is created under IIS.

4. Check for missing folder C:\inetpub\wwwroot\aspnet_client\system_web\4_0_30319

5. Under Application Pools – Enable 32 Bit applications to TRUE (if it is integrated mode)

Choosing right product is important SDK is very important for crystal reports. Here is link for choosing SDK.

Hope this information really helps to users on this specific case.

 

 

Advertisements

ArcGIS 10.1 – A quick look

February 25, 2012

Hi Folks,

I am just going through the ESRI and learning what are all new features available in ArcGIS 10.1.  This post talks about the important changes which I have noticed and interests on the new version. There are many more..

1. New look for ArcGIS. This looks really cool at least to me , I like different colors and new fonts.

1

2.  ArcGIS 10.1 no longer supports VBA environment. So folks be prepared move out of VBA tools. I  have seen lot of data development company uses VBA as primary language for their work. If so, its time to change.

3. ArcGIS 10.0 is the last release that the ArcObjects SDK for Microsoft .NET will support Visual Studio 2008.  ESRI constantly supports MS.

4. Major Change : 

ArcGIS Server 10.0 is the last release with support for 32‐bit operating systems.  The next
release of ArcGIS Server (10.1) will run natively as a 64‐bit application, requiring 64‐bit operating
systems. [Added 8/18/2011] This includes the ArcSDE technology component of ArcGIS Server
known as the ArcSDE application server.

We have faced enough problems with 32bit/64 bit platforms on ArcGIS server. Thanks ESRI 🙂

5.  ArcGIS server 10 is last release of using MXD. From 10.1 , all are MSD’s. This is an interesting change. Need to check how compatablity of MSD’s with Web API’s.

6.  Cool feature: Installation of ArcGIS server made easier – No SOM and SOC’s

With the new architecture of of ArcGIS Server 10.1 ,  accounts are no longer required for ArcSOM and ArcSOC processes. SOM and SOC’s are no longer used. Instead one account is used to run the ArcGIS Server process .  The rest of the configuration is done through the updated manager. This is very good stuff. One who installs and maintains Server know how to difficult with all these accounts .

7. ArcGIS Server 10.1 will be the last planned release for the ArcGIS Server Web ADFs, No DCOM support, web editing functionality of default Web ADF will no longer be supported.  Custom developed applications from business partners and users using fine grained ArcObjects through DCOM will not be supported. We are already started using Geoprocessing Framework and SOE;s

8. AUTOMATIC REST CACHE clearing . This is MUST required

Click here for more information

ArcGIS Server API for JavaScript – Training Material

February 24, 2012

Find below link which has training material for Javascriptt API

http://www.geospatialtraining.com/blog/?page_id=1862

Lakshmanan

Training Materials to Students

April 6, 2011

Hi All,

Nice to meet you after long time.  Hope everyone is doing good.

I have planned to conduct a workshop or a sort of training for 11 or 12th grade students to inspire and excite them on GIS.  I am looking for some training materials like videos/ppts or any suitable books or any nice ideas for practical demo of GIS which will help for students understand them about GIS .

If you have any such materials please send by email (laksh.gisprog@gmail.com) or pointers would be of great help.

Note, this is for students  of age 16 or 17, to inspire and excite the world of GIS. 

Thanks in advance,

Lakshmanan

2010 in review

January 2, 2011

Folks:

Below are the stats of my blog. First I would like to thank all friends, visitors for encouraging me. In the 2010, I have written 10 posts which is very less compared with 20008/09. I have not contributed much on technical side. As you aware every blogger will undergo lag phase like this.

To be honest, 2010 was really toughest year in my career. I was (still) working in one of the biggest GIS project and leading team of 15+ and still project is running. This is the longest project in GIS having more than 1.5 years of development phase and business is more than 1/2 million $.So completely occupied with the work.

Every day I work atleast 15 hrs per day is required and almost worked on 30+ week ends in office. Due to work schedule, traveling 35 km per day, lack of connectivity forced to keep out. OK. Though I have not written much, but still I have helped many folks on the carrer front through emails and calls. I have made some good friends and juniors. I try to help as much as I can. I have replied almost most of the mails, if at all I missed any, I am sorry for that.

In this new year 2011, I will try to share more on technical front which I learnt. I would request you give your feed back as comments on what sort of articles are required. Again, I profusely thank each and every one of you for supporting me. Wish you a very Happy New year 2011.

Regards

Lakshmanan

The stats helper monkeys at WordPress.com mulled over how this blog did in 2010, and here’s a high level summary of its overall blog health:

Healthy blog!

The Blog-Health-o-Meter™ reads Wow.

Crunchy numbers

Featured image

A helper monkey made this abstract painting, inspired by your stats.

Madison Square Garden can seat 20,000 people for a concert. This blog was viewed about 67,000 times in 2010. If it were a concert at Madison Square Garden, it would have performed about 3 times.

In 2010, there were 10 new posts, growing the total archive of this blog to 180 posts. There were 2 pictures uploaded, taking up a total of 31kb.

The busiest day of the year was September 28th with 552 views. The most popular post that day was GIS Courses in India.

Attractions in 2010

These are the posts and pages that got the most views in 2010.

1

GIS Courses in India September 2008
241 comments

2

GIS Interview Questions December 2008
71 comments

3

ESRI ArcGIS Server Flex API sites January 2009
6 comments

4

ArcObjects Tutorial I-Create Custom Command May 2008
10 comments

5

What is new in ArcGIS 9.3 February 2008
1 comment

Happy NewYear 2011

December 31, 2010

Dear Friends,

Wishing you all a Very Happy and Prosperous New Year 2011!.

May all your wishes comes true in this wonderful year.

Cheers

Lakshmanan

Happy Diwali

November 2, 2010

Dear Folks:

Wish you a all very Happy Diwali …..

Diwali is one of the grand festival celebrated in India. You can read more from http://en.wikipedia.org/wiki/Diwali

Have a great celebrations!

 

Cheers

Lakshmanan

 

 

 

ArcGIS 9.3 & 10 statistics

October 27, 2010

Hi All:

Asusual these days (month  or I should entire year) has been very busy with current project. So am not able to write much. Here is another statistical information from ESRI ArcGIS 10 when compared with 9.3.1. Already I have posted on 9.2 to 9.3 here is link.

Product

 

Enum

 

Struct

 

Interface

 

Coclass

 

Total 

ArcGIS 9.3

 

1195

 

51

 

5206

 

4050

 

10502

 

ArcGIS 10

 

1053

 

93

 

5555

 

4081

 

10782

 

Some useful tips from ESRI

August 16, 2010

Some useful tips which I have read from different blogs/ESRI Forums. All these items are in draft for quite some time, just publishing them today.

1) How to organize hundreds of feature classes in SDE? . This is one of the challenging job during the application design. Again it depends on the business requirement. I would say having 200+ feature class or using higher number of feature class/multiple dataset in web solution is not a correct practice. If it all required, we have to redesign data modelling for such specific requirement. Below are two ESRI Forum threads discussing  the same.

http://forums.esri.com/Thread.asp?c=2&f=59&t=221639&mc=8

http://forums.esri.com/Thread.asp?c=2&f=59&t=147917&mc=8#msgid430706

In general, it is a bad idea using FD to group FCs for two reasons (at least).

a). As you’ve already known, while accessing just one FC, the whole FD is locked. [What do they mean by FD will be locked, is that -A process accessing a feature class within a feature dataset locks all of the feature classes in the feature dataset?].

What for dataset is being used. This is an imaginary folder to store all your feature class .

  • A feature dataset is a collection of related feature classes that share a common coordinate system.
  • Their primary purpose is for organizing related feature classes into a common dataset for building a topology, a network dataset, a terrain dataset, or a geometric network.
  • All feature classes contained within a feature dataset have the same access privileges.
  • To organize feature classes for data sharing
  • Another design factor in organizing feature classes into common feature datasets is the requirement to use a spatial reference
  • Extent set for FD is same for all FC’s

b). When you use one layer in the FD, all the FCs in the FD will be cached, not just the layer you are using.

c). Don’t put any layer/feature class into a feature dataset unless you need it for geodatabase functionality (e.g. geometric network, topology, etc.)

2) How to connect to geodatabase. A quick help ESRI reference link for various type of connection. I always have this link in my favourites.

http://edndoc.esri.com/arcobjects/9.2/NET/c778d2bb-eb36-4793-9c89-20795811c5eb.htm

3) How to find windows operting system version (32/64 bit OS)

  • Click Start, and then click Run.
  • Type sysdm.cpl, and then click OK.
  • Click the General tab. The operating system is displayed as follows:
    • For a 64-bit version operating system: Windows Server 2003 Enterprise x64 Edition appears under System.
    • For a 32-bit version operating system: Windows Server 2003 Enterprise Edition appears under System.

4)  Spatial Analysis Book : A must read book for people doing research by using geographical tools

might find this geospatial analysis book extremely useful. Even if you work with the specific type of analysis by using a certain open source or a popular commercial GIS product (for example, using ESRI Geostatistical Analyst® for coverage analysis), you could get a deeper understanding of raster data properties and learn some more theory behind the interpolation methods you use.

Free online copy is avaiable @http://www.spatialanalysisonline.com/output/

Hope some of these items might be helpful to you.

Basic ArcSDE commands

August 16, 2010

Hi All,

Its been long time am writing a post on technical side. Yes, these days (actually months) were very busy with the current project.  Not enough time for personal work even. 😦 . OK. Let me share some basic ArcSDE commands that every developer should aware of.  As a GIS developer (or any developer/programmer) should know atleast one database. Though this is not a mandatory but in GIS context, knowing ArcSDE is very much essential. You cannot claim yourself a spatial developer (a.k.a ESRI Developer) if you are not knowing some basics of ArcSDE (in terms of ESRI).

I just wanted to write share the most useful and often used ArcSDE administration commands . Parameters embraced in <> are defined by user; so, if we have “<servicename>” that would result to “esri_sde”.

To show all SDE instances:

Sdeservice -o list

To show status of a specific sde instance including the number of accepting connections:

Sdemon -o status -i <servicename>

To show who is connected to an ArcSDE service:

Sdemon -o info -I users -i <servicename> -p <sdepassword>

To stop an sde service:

Sdemon -o shutdown -i <servicename> -p <sdepassword>

To start an sde service:

Sdemon -o start -i <servicename> -p <sdepassword>

To start an sde service remotely:

sdemon -o start -p <sdepassword> -s <servername> -i <servicename>

NOTE: ArcSDE administrator should be in the Windows admins group/power users group on the remote server.

To kill all connections to an sde service:

Sdemon -o kill -t all -i <servicename>

To kill a direct connect to an sde database:

Ths can be done either by restarting SQL Server database engine or by using SQL Server Activity Monitor, tracing the locked processes, and killing those processes. These things are being done on the SQL Server level, because direct connection has nothing to do with sde services – all users connect directly to the SQL Server database engine bypassing sde.

To shut down a stalled giomgr process (go to %sdehome%\tools and then run):

Killp <giomgr_process_ID>

NOTE: Process ID (PID) can be seen in the Windows Task Manager. Click Select Columns button on the Processes tab from the View menu. Then select properties you want to appear as column headings and then click OK.

To get list of layers and their properties from a specific sde service:

Sdelayer -o describe -i <servicename>

To get the list of current locks for a certain sde service:

sdemon -o info -I locks -i <servicename>

For further references : You can visit ESRI ArcSDE Manual  and many useful blogs like

http://bingluo.blogspot.com  [Spatial DBA] lot of useful tips and tracks.

Hope this helps you.