OrangeScape Developer Community

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

March 2009 Blog Posts (9)

Error in formula fields (com.orangescape.hce.customformula...)

Problem:

We will get the error like "=com.orangescape.hce.customformula.getObjectIndex()" in almost all the formula fields like objectindex(),currentuser()...

Cause :

The above error occur when we copy or move the studio from one location to another.For eg from drive c: to d: or when JAVA_HOME has been set to jre instead to jdk

Solution:

Set JAVA_HOME pointing to JDK

Added by Santhosh Mahizhan on March 30, 2009 at 6:08pm — No Comments

Installation of DimensioN server for SQL Server 2008

In Database configuration Screen we need to select MSSQL.

Use the following values for url and driver .

For URL : jdbc:sqlserver://localhost:1433;DatabaseName=dimension;currentSchema=dbo;

For Driver : com.microsoft.sqlserver.jdbc.SQLServerDriver

Rest of the steps are same as you do for normal installation.

Note : You can use the existing driver support MS SQL 2005

Added by Santhosh Mahizhan on March 30, 2009 at 6:07pm — 1 Comment

Hot fix for Portlet preferences issue

Problem

Inbox preference is not displayed in the preference page.

Cause

Root template name different from model name.



Solution

• Download the editPreferences.jsp file from the following link http://groups.google.com/group/orangescape/files and extract the zip file

• Replace the extracted file in the following path DimensionStudio\eclipse\plugins\com.orangescape.dimension… Continue

Added by Santhosh Ponnusamy on March 30, 2009 at 2:20pm — No Comments

HOT FIX _ FETCH.JSP

PROBLEMS



1 While you were using Special characters "ö" like this in a public cell as a text field, it will get saved and also will get deployed from DimensioN Studio without any error. When it was Instantiated and saved in the portlet, then you will not be able to view your inbox. The following is the message that will be get displayed in the inbox.



" XML Parsing Error: An invalid character was found in text… Continue

Added by Santhosh Ponnusamy on March 20, 2009 at 3:00pm — No Comments

How to avoid TableLock in mssql

You can use of the NOLOCK option in select statement allows you to get a result set without having to deal with the locking and blocking issues. ex. SELECT * FROM testTable with (nolock) Go through below url for more information. Remove some SQL Server blocking issues with the NOLOCK hint http://www.mssqltips.com/tip.asp?tip=1232 Executing SELECT statements in SQL Server without locking processes http://www.mssqltips.com/tip.asp?tip=1646

Added by Inder on March 20, 2009 at 2:28pm — No Comments

Reusing a report in application

Sometimes we would like to reuse a report for another report where we need to do minimal changes.In such cases we may copy,paste and rename it. Instead we can use the option "Register template for new report".

In report design view go to navigator right click on the report you want to reuse, you can see an option at the last saying "Register Template with New report wizard".Once you click on this a small window will pop up and ask you for display name, give a relevant name also give… Continue

Added by Jothi on March 4, 2009 at 6:08pm — No Comments

Model to capture Report Parameter - instead of report parameter pop up

In DimensioN 2.4 we can make use of a model instead of report parameter pop up to get parameters.



If we use Model to get parameter we can validate the values provided by the user.For e.g. we can check for invalid date range.



These are the steps you need to follow to implement that :



1. Create a model with fields similar to report parameter fields for a report and deploy it.



2. Go to report preferences in the browser you can see two options in report… Continue

Added by Jothi on March 4, 2009 at 5:49pm — 3 Comments

Installing DimensioN server for SQL Server 2005 database

Installation of DimensioN server for SQL Server 2005 is not the same as you do for other databases



In Database configuration Screen we need to select MSSQL not MSSQL 2005 .Use the following values for url and driver .



For Enter URL : jdbc:sqlserver://localhost:1433;DatabaseName=dimension;currentSchema=dbo;



For Enter Driver : com.microsoft.sqlserver.jdbc.SQLServerDriver



Rest of the steps are same as you do for normal… Continue

Added by Jothi on March 4, 2009 at 12:00pm — 1 Comment

Custom Editor not working in Internet Explorer 8

While you are using Internet Explorer 8.X versions, by default you will not be able to work in Custom Editor.From IE8 if you make click on Custom Editor from edit preferences, a blank window will pop up as below and the controls such as Text boxes or Labels will not be get displayed.





In order to avoid this issue, we need to do the following steps:



(1) If you need the current page alone must be compatible for view, just… Continue

Added by Santhosh Ponnusamy on March 2, 2009 at 7:05pm — No Comments

Monthly Archives

2013

2012

2011

2010

2009

2008

2007

© 2017   Created by OrangeScape Technologies.   Powered by

Badges  |  Report an Issue  |  Terms of Service