OrangeScape Developer Community

A community for Application Developers on OrangeScape's Platform-as-a-Service

May 2009 Blog Posts (7)

Hot fix for inbox search


If a model contains a string parameter for which save in database property is set to be false then inbox search won't work for those models. It will throw error like..

Unknown column 'Error_msg' in 'where clause' (for MySQL)"

ORA-00904: "Error_msg": invalid identifier (for Oracle)

Invalid column name 'Error_msg' (for SQLServer)

The above errors may vary depends upon the database which you are using.…


Added by Santhosh Ponnusamy on May 25, 2009 at 4:00pm — No Comments

To Capture User Log Information (Login Time, Logout Time, Viewed Models / Reports)

The following are the suggested ways to capture User Log Information:

* In change the following properties as mentioned as follows: location:(\\OrangeScape\Server\DimensionServer\server\default\deploy\A-dimension-portal.ear\portal-ejb.jar


log.user.paths=true (Approximate Line Number:…

Added by Santhosh Ponnusamy on May 21, 2009 at 9:30pm — No Comments

Patches for invoking kettle in Dimension 2.4


How to invoke kettle from Dimension2.4


To invoke kettle from Dimension 2.4, we need to add a patch named js.jar in

${install -drive}$\DimensionServer\server\default\deploy\A-dimension-portal.ear\lib\kettle the folder.

and include the following line in… Continue

Added by VM.Hanitha on May 21, 2009 at 10:47am — No Comments

Concatenate string column values for a given group into a comma (or any character) separated list of values in SQL Server 2005+

Sometimes we need to convert (concatenate) string column values for a given group into a comma (or any character) separated list of values.


We have a table as below:

We want an output as below:

here is one way of doing this in Ms-SQL 2005/2008 using FOR XML PATH(”)

Select NoteID, STUFF ((SELECT ',' + a.Comments

from Notes a where a.NoteID = b.NoteID… Continue

Added by Dwarakanath Cheyyur on May 20, 2009 at 9:09pm — 1 Comment

The Date picker option in the parameter window

In order to get date picker in the report parameter window, the following attached files has to be replaced in the following mentioned locations:

1. Replace the TextBoxParameterFragment.jsp in the following location:


Please find the replacement file here… Continue

Added by Santhosh Ponnusamy on May 15, 2009 at 2:09pm — 2 Comments

Speed up the startup of server when the network is slow

If your server is starting up too slow, due to the network being slow, and you are pulling out the network cable (disconnecting from the network) to make it start faster, then you can use any one of the following solutions to make it start faster without pulling out your network cable..


Solution 1:

Note: You need to be super user (administrator/root/sudo) to do this.


1. Start -> Run ->…


Added by Anbarasan on May 15, 2009 at 11:30am — 1 Comment

Integrating Dimension with CAS


CAS is a centralized authentication server for validating the user across webapplications using single sign-on mechanism.

Running Dimension as a CAS Server:

1.Create keystore by entering the commands in command prompt.

C:\Program Files\Java\jdk1.5.0_11\bin>

keytool -genkey -alias dimensionkeystore

-keypass dimensionkeystore -keyalg RSA

-keystore dimensionkeystore.keystore

Enter keystore password:… Continue

Added by Santhosh Ponnusamy on May 7, 2009 at 1:00pm — No Comments

Monthly Archives








© 2018   Created by OrangeScape Technologies.   Powered by

Badges  |  Report an Issue  |  Terms of Service