SQL Server 2008 Connection Reset issue (JDBC Driver)

Jan 22, 2013   //   by Paul Burman   //   Other  //  No Comments

You cannot connect to SQL Server by using JDBC Driver for SQL Server after you upgrade to JRE 6 update 29 or a later version

Are you confused as to why your SQL Server 2008 Enterprise RDBMS won’t accept a connection from the DekhoConnectionPropertiesEditor.jar application? (or any other client database connection for that matter that tries to connect via JDBC)

Dekho Error ConnReset

Does this error haunt you?

This link helps to explain the issue that was introduced at JRE 6 Update 29, http://support.microsoft.com/kb/2653857.


How to create a custom disclaimer form

Jan 8, 2013   //   by Simon J   //   Other  //  9 Comments

A number of clients have incorporated custom disclaimer pages before allowing their users access into Dekho.  The Dekho site over at the Western Australian Planning Commission  is a good example of this.   If end-users agree to the terms, they get into Dekho.  If they don’t, they get redirected onto another link.

If you have some basic HTML/Javascript/CSS skills (or know someone who does) this is a fairly straightforward task to achieve with Dekho.  There is nothing stopping you from taking a peek at how they did it over at WAPC.  More specifically, look at the two buttons on the page (lines 519-529) and how when you click disagree, it redirects you to another page, and if you click agree, it fires a new function within Dekho.jsp called agree (lines 418-432).

I spent some time today creating a simpler disclaimer for new visitors to Dekho.

  • This presents the users with a choice to accept/refuse the terms of use.
  • If they accept, they get access to Dekho (which loads up in the background)
  • If they refuse, they get re-directed to another URL.
  • If they click ‘Do not ask again’, they won’t be prompted again, assuming that they chose accept.

We have provided the tool on the downloads gallery, along with some notes on how to set it up.

The tool is not covered under the scope of support (as with any Javascript/HTML/CSS customisations) but we do welcome you to post questions/issues on Dekho Answers.

Perhaps if you don’t need a disclaimer, it might still be a good idea to let new users know a little more about your Dekho implementation with the help of an alert bar and a custom help page/video.


Proxy Authentication / Access Secure WMS

Jan 3, 2013   //   by Simon J   //   Security  //  No Comments

When you attempt to publish a Dekho Configuration MXD that contains a service that is either:

1. Behind a proxy that requires authentication to communicate with an external service (such as MDS or ArcGIS Online)

2. The service itself requires a username/password to get access to the service (such as a secure WMS service)

…the Dekho ArcObjects Server Manager (DASM) has not been supplied with either the proxy or service credentials to gain access to the service.  Depending on the version of Dekho you are running, this will either cause a timeout in the publishing process, or these layers will not be visible in the Dekho Map Client.

We are currently working on bringing support for secure WMS and proxy authentication into the core product, but hopefully this tool will provide an interim solution for those that are having issues with Dekho and either of the points above.

The tool (including the source code) is available on our Downloads Gallery.  As this is an unsupported tool, please use Dekho Answers for any problems with the tool.

Support for Tomcat 7.0.27

Dec 12, 2012   //   by Simon J   //   Other  //  No Comments

As of v4 of Dekho, we have added support for Apache Tomcat 7.  Amongst a number of improvements over v6, the installer makes it a lot easier for allocating port numbers, installing multiple Tomcats on the same machine and applying memory settings.

At the time of writing, the latest build is Tomcat 7.0.32

However, at this current time, we only support builds of Tomcat prior (and including) Tomcat 7.0.27.

  • This version can be downloaded from the Apache archives. (apache-tomcat-7.0.27.exe)
  • Do not use any version above this for v4, unless stated otherwise in the requirements page (for future versions of Dekho)

The reason for this, is that something in the .28+ builds has caused an issue with BlazeDS communication over the default streaming channel.  Our developers are investigating the issue and working with the Apache Tomcat community to come up with a resolution.

Quick re-cap on streaming/polling:

The Dekho Map Client (Flex) communicates with the Dekho Server (Java) using BlazeDS.

This channel of communication can be either configured to streaming (default) or polling (Dekho Settings - amf.channel.type)

  • Streaming is a constant open connection between Dekho Map Client and Dekho Server.
  • Polling pulses the communications through at set intervals.

Streaming uses less bandwidth and have a lower latency, but in some environments, proxies & firewalls do not like the open connections, and can chunk the requests (stop them).  For these environments, polling can be utilised to behave accordingly with the proxies & firewalls.  The performance overhead is negligible when compared to streaming.


Dekho 4.0.2

Dec 3, 2012   //   by Bryce S   //   News & Events, Other  //  No Comments

Dekho 4.0.2 maintenance release has just been packaged and will shortly be available for download.  You’ll receive an email with details on where you can download the release later in the week.


What’s in Dekho 4.0.2

Key updates incorporated in the release include:

  • Optimised Web Map Service (WMS) performance
  • Enriched query capability, enabling additional special characters to be utilised in search strings
  • Improved ArcFM tracing
  • Resolution of duplication issues relating to Flex Sessions with Polling Channels


The full list of reported issues resolved in Dekho 4.0.2 is available in the Dekho Release Notes.

Earthmine in Dekho

Nov 30, 2012   //   by Simon J   //   Other  //  No Comments

We now have an Earthmine tool available on our downloads gallery.

This brings some exciting new functionality to enhance the user experience for your Dekho users.

  • You can measure distances within the Earthmine window and these will be drawn as redlines on the Dekho Map.
  • Earthmine Window can be toggled to full screen and is resizeable.
  • Dynamic field of vision cone on the Dekho Map, that moves as you move around within the Earthmine window.
  •  You can identify features within the Earthmine window, and this will identify the corresponding features from your layers in your Dekho map.
  •  You can overlay the coverage map of Earthmine to see where you can drag the field of vision cone to.

For more information on how you can make use of Earthmine within your organisation, please get in touch with our friends over at Map Data Services.

Flash error while loading Dekho 4

Nov 28, 2012   //   by Shivani K   //   Other  //  No Comments

If you recently saw this error while loading Dekho in firefox and you use flash debugging, this post might be useful for you:

Property http://www.adobe.com/2006/flex/mx/internal::topMostIndex not found on _Main_mx_managers_SystemManager and there is no default value.

Please note that a different error might be displayed for earlier versions of Dekho but the cause could be same.

Dekho_server.properties file at v4 and onwards

Oct 22, 2012   //   by Shivani K   //   Other  //  2 Comments

If you are aware of and use the server.properties file at the path : C:\Program Files\Apache Software Foundation\Tomcat\webapps\Dekho\WEB-INF\classes\resources, you would have been experiencing the issue of this file being overwritten when you install a newer version of Dekho.

The answer to the above problem is Dekho_server.properties which you can create in C:\Program Files\Apache Software Foundation\Tomcat\webapps directory. The naming convention is same as the Dekho connection properties file i.e. DekhoWarFileName_server.properties. e.g. If the Dekho war file is named as DekhoProd, the file should be named as DekhoProd_server.prperties. The settings which you wish to modify can be copied from server.properties file into this file. Dekho will then read the modified settings from this file and rest of the settings from the server.properties file. This file is not overwritten when a newer version of Dekho is installed.

Please note that: When the Dekho_server.properties file does not exist, a warning message is displayed in the dekho.log file.

WARN  au.com.esriau.dekho.config.ServerPropertyManager  – Server properties file C:\Program Files\Apache Software Foundation\Tomcat 7.0\webapps\Dekho\..\Dekho_server.properties does not exist or unable to load. Cannot locate configuration source Dekho_server.properties

This does not cause any problems in the Dekho. You can simply ignore it or create a blank Dekho_server.properties file in  C:\Program Files\Apache Software Foundation\Tomcat\webapps directory.

Dekho at APUC

Oct 10, 2012   //   by admin   //   News & Events  //  No Comments

This year’s Asia Pacific User Conference  is hosted by Eagle Technology Group Ltd, Esri’s official distributor for New Zealand. The event will be held from 5 – 7 November 2012, at the Skycity Auckland Convention Centre in Auckland, New Zealand.

We are having a Dekho User Group on the 5th (Monday), from 3pm to 4pm, so those attending please sign up!  We will be discussing the new functionality in v4, and have some user presentations from Marlborough City Council and Dunedin City Council to see how they are using Dekho within their organisations.

We will also have a booth at the conference, so do come say hello and have a chat.

Dekho 4.0.1

Sep 14, 2012   //   by Bryce S   //   News & Events, Other  //  4 Comments

We’ve just finished packaging Dekho 4.0.1 maintenance release and it will shortly be available for download. You’ll receive an email with details on where you can download the patches from shortly (today or Monday).

What’s in Dekho 4.0.1

  • Addressed a memory leak in AoServer
  • Update to the 10.1 build of AoServer to be x64
  • Increased font size in Maps and Legend Panels to enhance readability
  • For other items, check the release notes for the COMO’s we have addressed.


Whats new in v4?

Sep 12, 2012   //   by Simon J   //   Other  //  1 Comment

We had a user group session at Ozri 2012, where we presented the below slidedeck on whats new in v4.

Thanks to those that attended the workshop, and special thanks to Wollongong City Council, Hobart City Council and the Office of Environment and Heritage for their presentations and being involved in our panel discussion.

You can bump the video to full screen and you might want to plug in some earphones.