The multi-part identifier could not be bound.

Error:
Msg 4104, Level 16, State 1, Line 28
The multi-part identifier "idd.key" could not be bound.

Reason:
This Error Comes because the alias you are using in query is invalid/ Wrongly text type/ or not define.

Solution:
Check that alias you are using in projection and selection is available or not.

select e.ename, d.dname
from emp e
join
dept dd
on e.deptno = d.deptno

From above example you can see that the in Projection/Selection we are using "d" alias, where as on other hand we have defined the "dd" alias of table "dept".
 

SQLSERVER Pass Variable in Dynamic SQL

create procedure dummy_ins
(
@vid nvarchar(30),
@vname nvarchar(30)
)
as
set nocount on
declare @temp_sql nvarchar(1000)
declare @symmtric_key AS [uniqueidentifier]
set @symmtric_key = KEY_GUID('Symmetric_Key1')
set @temp_sql = 'insert into dummy values (' + @vid  +','+ 'ENCRYPTBYKEY(@symmtric_key,''' + @vname+ '''))'
print @temp_sql
exec sp_executeSQL @temp_sql

exec dummy_ins '3','sdf'

ERROR:
Msg 137, Level 15, State 2, Line 1
Must declare the scalar variable "@symmtric_key".

PROBLEM:
print of command - insert into dummy values (3,ENCRYPTBYKEY(@symmtric_key,'sdf'))
when sp_executeSQL execute the sql query, it found "@symmtric_key" on the way so why it is throwing error.

That mean we have enclosed the variable with single quote in sql, so the variable define is unable to pass the value.

SOLUTION:
Remove the single quotes around @symmtric_key like 'ENCRYPTBYKEY(KEY_GUID('''+ cast(@symmtric_key as nvarchar(30)) +'''),'''

see below example:
create procedure dummy_ins
(
@vid nvarchar(30),
@vname nvarchar(30)
)
as
set nocount on
declare @temp_sql nvarchar(1000)
declare @symmtric_key AS [uniqueidentifier]
set @symmtric_key = KEY_GUID('Symmetric_Key1')
set @temp_sql = 'insert into dummy values (' + @vid  +','+ 'ENCRYPTBYKEY(KEY_GUID('''+ @symmtric_key +'''),''' + @vname+ '''))'
print @temp_sql
exec sp_executeSQL @temp_sql,'@p as uniqueidentifier', @p = @symmtric_key

exec dummy_ins '14','sdf'
ERROR:
cast( guid as varchar)
Msg 402, Level 16, State 1, Procedure dummy_ins, Line 11
The data types nvarchar and uniqueidentifier are incompatible in the add operator.

From above error i feel that it will not pass key is not acceptable in this way.

SOLUTION:
correct way is here to pass variable :
see below post
SqlServer Procedure expects parameter '@' of type 'ntext/nchar/nvarchar' 

or
click on below link
http://j4info.blogspot.in/2015/06/sqlserver-procedure-expects-parameter.html

SqlServer Procedure expects parameter '@' of type 'ntext/nchar/nvarchar'

create procedure dummy_ins
(
@vid nvarchar(30),
@vname nvarchar(30)
)
as
set nocount on
declare @temp_sql nvarchar(1000)
declare @p as nvarchar(30)
set @p = 'Symmetric_Key1'
set @temp_sql = 'insert into dummy values (' + @vid  +','+ 'ENCRYPTBYKEY(KEY_GUID('''+ cast(@p as nvarchar(30)) +'''),''' + @vname+ '''))'
print @temp_sql
exec sp_executeSQL @temp_sql,'@p nvarchar(30)', @p = @p

exec dummy_ins '14','sdf'

error :
Msg 214, Level 16, State 3, Procedure sp_executesql, Line 1
Procedure expects parameter '@parameters' of type 'ntext/nchar/nvarchar'.

Problem:
Parameter value for procedure "sp_exectesql" should be in nvarchar, parameter is '@p nvarchar(30)'
and missing prefix N

solution:
create procedure dummy_ins
(
@vid nvarchar(30),
@vname nvarchar(30)
)
as
set nocount on
declare @temp_sql nvarchar(1000)
declare @p as nvarchar(30)
set @p = 'Symmetric_Key1'
set @temp_sql = 'insert into dummy values (' + @vid  +','+ 'ENCRYPTBYKEY(KEY_GUID('''+ cast(@p as nvarchar(30)) +'''),''' + @vname+ '''))'
print @temp_sql
exec sp_executeSQL @temp_sql,N'@p nvarchar(30)', @p = @p


Related POSt
SQL server encrypt data at column level
http://j4info.blogspot.in/2015/06/sql-server-encrypt-data-at-column-level.html

SQL server error : Could not find stored procedure

Error:
Msg 2812, Level 16, State 62, Procedure dummy_ins, Line 13
Could not find stored procedure 'insert into dummy values (1,ENCRYPTBYKEY(key_guid(@symmtric_key),'sdf')'.

Reason:
I created stored procedure and was executing dynamic sql query in SP

set @temp_sql = 'insert into dummy values (' + @vid +','+ 'ENCRYPTBYKEY(key_guid(@symmtric_key),''' + @vname+ ''')'
print @temp_sql
exec  @temp_sql
Here i am using "exec @temp_sql", for sqlserver it is equivalent to call procedure, so why it is giving above error.

Solution:
use keyword "sp_executeSQL" as see below:
exec sp_executeSQL @temp_sql

sqlserver Cannot specify a column width on data type int

error:
Msg 2716, Level 16, State 1, Procedure dummy_ins, Line 2
Column, parameter, or variable #1: Cannot specify a column width on data type int.

Problem :
i have created a stored procedure in sqlserver and accidently i have define size of int

create procedure dummy_ins
(
@vid int(30),

Solution:
Remove the size of int datatype or use nvarchar type.
Error of the Level 16 are caused by the user and can be fixed by the SQL Server user.

SQL server encrypt data at column level

1. SQL server master key is the root of SQL server encryption hierarchy. Check it exists or not.

SELECT * FROM sys.symmetric_keys
WHERE name = '##MS_ServiceMasterKey##';

2. Create master key - "encrypt by password" argument, it defines the password used to encrypt the key. The DMK does not directly encrypt data, but provides the ability to create keys that are used for data encryption. keep the encryption password at safe place or you can take the backup of same.

CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'PA55w04D!';
GO


CREATE CERTIFICATE encrypt_certificate
WITH SUBJECT = 'Encrypt Data';
GO


3. Create Symmetric Key it is used for both encryption and decryption.
CREATE SYMMETRIC KEY Symmetric_Key1 WITH ALGORITHM = AES_128 ENCRYPTION BY CERTIFICATE encrypt_certificate;
GO


create table dummy (id int , name varbinary(2000));

We need to open symmetric key before use:
OPEN SYMMETRIC KEY Symmetric_Key1 DECRYPTION BY CERTIFICATE encrypt_certificate;

insert into dummy values (1, EncryptByKey(Key_GUID('Symmetric_Key1'),'data'));

select * from dummy;

we we can decrypt the data in table?
SELECT CONVERT(varchar, DecryptByKey(name)) AS 'Decrypted name'

Window server service failed to start

Error:
Windows could not start the SQL Server (MSSQLSERVER) service on Local Computer.
Error 1069: The service did not start due to a logon failure.

Problem:
Windows login credential fail to start service of tool.

Solution:
- Open control panel - Services
- look for sqlserver service
- Right click PROPERTIES
- Goto LOGON tab
- Add your updated credential
- press ok and start service

SP14 Create Birt report and pass parameter in dataset define in SpagoBI server

Lets create a BIRT report using spagobi studio and main task is for me to pass parameter that is define in SpagoBI server

Follow the below steps to follow up:

• Start spagoBi server and Studio
• Create or define parameter using "Profile Attribute management"
• I added "deptname" see below image for ur reference

• Open spagoBi studio using spagoBI perspective only
• create "New Birt report"

• Switch your spagoBi studio to Report design perspective. You can see this option on very right top hand side of window.

• Create JDBC datasource connection. I created the connection with oracle server with scott user.

• Create parameter which needs to pass into query. Right click on "report parameter" and create new parameter. see below image.

• Create new data-set which contains the query pull data from database . In below image i have written simple query without any parameter pass.
• but you can replace the 'SALES' with "?", so that you can pass your parameter in query.
• After replace it with ?, 
• assign value to parameter 

• go to "parameter" on left hand side (see below image)

• Design the BIRT report layout, drop your dimension and measure from left hand side onto LAYOUT.

• Test your report on studio side by clicking on "preview" tab. after it will ask for enter parameter value popup. Enter value and press ok.

• Switch spagoBI studio to "SpagoBi" perspective.
• Deploy your report 

• Create LOV for deptname

• Test your LOV and check radio button and checkbox. (see below image)

• Create "Analytical driver" for LOV "deptname"

• Move to Folder to execute your report, that u had deployed recently.
• First we have to define "DOCUMENT ANALYTICAL DRIVER DETAILS" for your document.
• Click on properties icon on your document

• Save and Execute report.
• Quite easy SpagoBi, Nothing difficult . ENJOY

Dell laptop M1530 xps wifi issue

laptop wifi is behaving odd?
is it connect or disconnect automatically?
wifi connection drop atomatically?

I was facing these problem with my laptop. i search on google alot and finally found a solution.

Install Dell QickSet
If you dont have setup just download from dell downloads

it works for me, really!!!!

SP13 SEVERE: Unable to open connection.

Jun 03, 2015 2:03:11 PM org.eclipse.birt.data.engine.odaconsumer.ConnectionManager openConnection
SEVERE: Unable to open connection.
org.eclipse.datatools.connectivity.oda.OdaException ;
    java.lang.IllegalStateException: Unable to determine the default workspace location.  Check your OSGi-less platform configuration of the plugin or datatools workspace path.
at org.eclipse.birt.report.data.oda.jdbc.dbprofile.impl.Connection.open(Connection.java:116)
at org.eclipse.birt.report.data.oda.jdbc.dbprofile.impl.Connection.open(Connection.java:62)
at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaConnection.open(OdaConnection.java:250)
at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.openConnection(ConnectionManager.java:165)
at org.eclipse.birt.data.engine.executor.DataSource.newConnection(DataSource.java:224)
at org.eclipse.birt.data.engine.executor.DataSource.open(DataSource.java:212)
at org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiDataSource(DataSourceRuntime.java:217)
at org.eclipse.birt.data.engine.impl.QueryExecutor.openDataSource(QueryExecutor.java:435)
at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:322)
at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:455)
at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.produceQueryResults(PreparedDataSourceQuery.java:190)
at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:178)
at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute(PreparedOdaDSQuery.java:153)
at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:634)
at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:152)
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:267)
at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1941)
at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:80)
at org.eclipse.birt.report.engine.executor.DataItemExecutor.execute(DataItemExecutor.java:75)
at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43)
at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46)
at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:34)
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65)
at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:92)
at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:100)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:181)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:77)
at it.eng.spagobi.engines.birt.BirtReportServlet.runReport(BirtReportServlet.java:690)
at it.eng.spagobi.engines.birt.BirtReportServlet.service(BirtReportServlet.java:159)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at it.eng.spagobi.utilities.filters.SpagoBIAccessFilter.doFilter(SpagoBIAccessFilter.java:194)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:240)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:164)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:462)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:563)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:399)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:317)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:204)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:311)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.IllegalStateException: Unable to determine the default workspace location.  Check your OSGi-less platform configuration of the plugin or datatools workspace path.
at org.eclipse.datatools.connectivity.internal.ConnectivityPlugin.getDefaultStateLocation(ConnectivityPlugin.java:155)
at org.eclipse.datatools.connectivity.internal.ConnectivityPlugin.getWorkspaceFilePath(ConnectivityPlugin.java:178)
at org.eclipse.datatools.connectivity.drivers.DriverManager.wereDefaultDriversCreated(DriverManager.java:549)
at org.eclipse.datatools.connectivity.drivers.DriverManager.resetDefaultInstances(DriverManager.java:840)
at org.eclipse.datatools.connectivity.drivers.DriverManager.(DriverManager.java:125)
at org.eclipse.datatools.connectivity.drivers.DriverManager.getInstance(DriverManager.java:67)
at org.eclipse.datatools.connectivity.DriverConnectionBase.getDriverDefinition(DriverConnectionBase.java:136)
at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.createConnection(JDBCConnection.java:177)
at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.internalCreateConnection(JDBCConnection.java:141)
at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.open(JDBCConnection.java:97)
at org.eclipse.datatools.enablement.internal.oracle.JDBCOracleConnectionFactory.createConnection(JDBCOracleConnectionFactory.java:27)
at org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:83)
at org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:359)
at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionInfoImpl.initializeJDBCConnection(ConnectionInfoImpl.java:705)
at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionInfoImpl.(ConnectionInfoImpl.java:690)
at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionFactory.createConnection(ConnectionFactory.java:38)
at org.eclipse.datatools.connectivity.sqm.core.SQMConnectionFactory.createConnection(SQMConnectionFactory.java:45)
at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionFactory.createConnection(ConnectionFactory.java:59)
at org.eclipse.datatools.connectivity.internal.ConnectionFactoryAdapterProvider.createConnection(ConnectionFactoryAdapterProvider.java:114)
at org.eclipse.datatools.connectivity.internal.ManagedConnection.createConnection(ManagedConnection.java:163)
at org.eclipse.datatools.connectivity.internal.CreateConnectionJob.run(CreateConnectionJob.java:56)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:53)




Problem - Wrong selection of jdbc driver on spagoBI-studio side

Solution -
create datasource with correct driver

In my case
1. i create datasource with option selection ""JDBC database connection with query builder""
2. Deployed BIRT report from studio to server
3. when execute report from server side
it throws above error
4. i deleted the data source created in step 1
5. recreate data-source with option "JDBC Data Source"
6. need to recreate dataset
7. deploy it again

SP12 SpagoBi wrong parameter pass in query

Click on below post , for solution to related error

"http://j4info.blogspot.in/2015/06/sp14-create-birt-report-and-pass.html"

A BIRT exception occurred.
  Plug-in Provider:Eclipse BIRT Project
  Plug-in Name:BIRT Data Engine
  Plug-in ID:org.eclipse.birt.data
  Version:4.2.1.v201209121213
  Error Code:odaconsumer.CannotGetResultSetMetaData
  Error Message:Cannot get the result set metadata.
    org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does not return a ResultSet object.
SQL error #1:The statement did not return a result set.
 ;
    com.microsoft.sqlserver.jdbc.SQLServerException: The statement did not return a result set.




java.util.HashMap
Entry key [org.eclipse.datatools.connectivity.oda.util_consumerResourceIds], value [org.eclipse.datatools.connectivity.oda.util.ResourceIdentifiers@50a85714]
Entry key [OdaConsumerId], value [org.eclipse.datatools.connectivity.oda.profile.connectionPropertyService]
Entry key [org.eclipse.birt.data.cache.memory], value [0]
Driver: end setAppContext
Entering isBirtRuntimeContext
NOT runtime

Jun 01, 2015 1:11:35 PM org.eclipse.birt.data.engine.odaconsumer.Connection prepareOdaQuery
SEVERE: Failed to prepare the following query for the data set type (spagobi.birt.oda.dataSet).

org.eclipse.datatools.connectivity.oda.OdaException: Impossible to prepare query [select ${}] ;
    java.lang.RuntimeException: Impssible to find on server a dataset named [select ${}]
        at it.eng.spagobi.studio.oda.impl.Query.prepare(Query.java:145)
        at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQuery.doPrepare(OdaQuery.java:229)
        at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQuery.prepare(OdaQuery.java:186)
        at org.eclipse.birt.data.engine.odaconsumer.Connection.prepareOdaQuery(Connection.java:290)
        at org.eclipse.birt.data.engine.odaconsumer.Connection.prepareStatement(Connection.java:197)
        at org.eclipse.birt.data.engine.executor.DataSource.prepareStatement(DataSource.java:302)
        at org.eclipse.birt.data.engine.executor.DataSourceQuery.prepare(DataSourceQuery.java:281)
        at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQueryExecutor.prepareOdiQuery(PreparedOdaDSQuery.java:442)
        at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:341)
        at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:455)
        at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.produceQueryResults(PreparedDataSourceQuery.java:190)
        at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:178)
        at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute(PreparedOdaDSQuery.java:145)
        at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:159)
        at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:142)
        at org.eclipse.birt.report.data.adapter.impl.QueryExecutionHelper.executeQuery(QueryExecutionHelper.java:136)
        at org.eclipse.birt.report.data.adapter.impl.QueryExecutionHelper.executeQuery(QueryExecutionHelper.java:118)
        at org.eclipse.birt.report.data.adapter.impl.QueryExecutionHelper.executeQuery(QueryExecutionHelper.java:102)
        at org.eclipse.birt.report.data.adapter.impl.DataSetMetaDataHelper.getRuntimeMetaData(DataSetMetaDataHelper.java:194)
        at org.eclipse.birt.report.data.adapter.impl.DataSetMetaDataHelper.getRealMetaData(DataSetMetaDataHelper.java:153)
        at org.eclipse.birt.report.data.adapter.impl.DataSetMetaDataHelper.getDataSetMetaData(DataSetMetaDataHelper.java:115)
        at org.eclipse.birt.report.data.adapter.impl.DataSetMetaDataHelper.refreshMetaData(DataSetMetaDataHelper.java:382)
        at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.refreshMetaData(DataRequestSessionImpl.java:415)
        at org.eclipse.birt.report.designer.data.ui.dataset.ExternalUIUtil.updateColumnCache(ExternalUIUtil.java:108)
        at org.eclipse.birt.report.designer.data.ui.providers.DefaultDataServiceProvider.updateColumnCache(DefaultDataServiceProvider.java:114)
        at org.eclipse.birt.report.designer.internal.ui.data.DataService.updateColumnCache(DataService.java:140)
        at org.eclipse.birt.report.designer.data.ui.dataset.DataSetUIUtil.updateColumnCache(DataSetUIUtil.java:98)
        at org.eclipse.birt.report.designer.data.ui.dataset.DataSetUIUtil.getCachedMetaDataHandle(DataSetUIUtil.java:181)
        at org.eclipse.birt.report.designer.internal.ui.views.data.providers.DataSetNodeProvider.getChildren(DataSetNodeProvider.java:91)
        at org.eclipse.birt.report.designer.internal.ui.views.ViewsTreeProvider.getChildren(ViewsTreeProvider.java:41)
        at org.eclipse.birt.report.designer.internal.ui.util.UIUtil.containElement(UIUtil.java:982)
        at org.eclipse.birt.report.designer.internal.ui.util.UIUtil.containElement(UIUtil.java:985)
        at org.eclipse.birt.report.designer.internal.ui.util.UIUtil.containElement(UIUtil.java:985)
        at org.eclipse.birt.report.designer.internal.ui.util.UIUtil.containElement(UIUtil.java:956)
        at org.eclipse.birt.report.designer.internal.ui.views.NonGEFSynchronizerWithTreeView.handleSelectionChange(NonGEFSynchronizerWithTreeView.java:232)
        at org.eclipse.birt.report.designer.internal.ui.views.NonGEFSynchronizerWithTreeView.performRequest(NonGEFSynchronizerWithTreeView.java:183)
        at org.eclipse.birt.report.designer.core.util.mediator.ReportMediator.notifyRequest(ReportMediator.java:125)
        at org.eclipse.birt.report.designer.ui.preview.editors.ReportPreviewFormPage.refresh(ReportPreviewFormPage.java:190)
        at org.eclipse.birt.report.designer.ui.preview.editors.ReportPreviewFormPage.onBroughtToTop(ReportPreviewFormPage.java:109)
        at org.eclipse.birt.report.designer.ui.editors.MultiPageReportEditor.prePageChanges(MultiPageReportEditor.java:923)
        at org.eclipse.birt.report.designer.ui.editors.IDEMultiPageReportEditor.prePageChanges(IDEMultiPageReportEditor.java:525)
        at org.eclipse.birt.report.designer.ui.editors.MultiPageReportEditor.pageChange(MultiPageReportEditor.java:847)
        at org.eclipse.ui.part.MultiPageEditorPart$2.widgetSelected(MultiPageEditorPart.java:290)
        at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:234)
        at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
        at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1053)
        at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1077)
        at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1062)
        at org.eclipse.swt.widgets.Widget.notifyListeners(Widget.java:774)
        at org.eclipse.swt.custom.CTabFolder.setSelection(CTabFolder.java:2743)
        at org.eclipse.swt.custom.CTabFolder.onMouse(CTabFolder.java:1429)
        at org.eclipse.swt.custom.CTabFolder$1.handleEvent(CTabFolder.java:257)
        at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
        at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1053)
        at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4066)
        at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3657)
        at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2640)
        at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2604)
        at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2438)
        at org.eclipse.ui.internal.Workbench$7.run(Workbench.java:671)
        at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
        at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:664)
        at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
        at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:115)
        at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
        at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
        at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
        at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:369)
        at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:620)
        at org.eclipse.equinox.launcher.Main.basicRun(Main.java:575)
        at org.eclipse.equinox.launcher.Main.run(Main.java:1408)
        at org.eclipse.equinox.launcher.Main.main(Main.java:1384)
Caused by: java.lang.RuntimeException: Impssible to find on server a dataset named [select ${userid}]
        at it.eng.spagobi.studio.oda.impl.Query.prepare(Query.java:118)
        ... 76 more


Jun 01, 2015 1:11:36 PM org.eclipse.birt.data.engine.odaconsumer.PreparedStatement doSetString( int, String )
SEVERE: Cannot set the string value ( ) to parameter 1.
org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot set preparedStatement parameter string value.
SQL error #1:The index 1 is out of range.
 ;
    com.microsoft.sqlserver.jdbc.SQLServerException: The index 1 is out of range.
        at org.eclipse.birt.report.data.oda.jdbc.Statement.setString(Statement.java:654)
        at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQuery.setString(OdaQuery.java:738)
        at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.doSetString(PreparedStatement.java:4310)
        at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.setString(PreparedStatement.java:3919)
        at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.setParameterValue(PreparedStatement.java:3134)
        at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.setParameterValue(PreparedStatement.java:3070)
        at org.eclipse.birt.data.engine.executor.DataSourceQuery.setInputParameterBinding(DataSourceQuery.java:1161)
        at org.eclipse.birt.data.engine.executor.DataSourceQuery.addParameterDefns(DataSourceQuery.java:595)
        at org.eclipse.birt.data.engine.executor.DataSourceQuery.prepare(DataSourceQuery.java:290)
        at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQueryExecutor.prepareOdiQuery(PreparedOdaDSQuery.java:442)
        at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:341)
        at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:455)
        at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.produceQueryResults(PreparedDataSourceQuery.java:190)
        at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:178)
        at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute(PreparedOdaDSQuery.java:145)
        at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:624)
        at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:152)
        at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:267)
        at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1939)
        at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:80)
        at org.eclipse.birt.report.engine.executor.DataItemExecutor.execute(DataItemExecutor.java:75)
        at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43)
        at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46)
        at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:34)
        at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65)
        at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:92)
        at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:100)
        at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:180)
        at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:77)
        at org.eclipse.birt.report.service.ReportEngineService.runAndRenderReport(ReportEngineService.java:937)
        at org.eclipse.birt.report.service.BirtViewerReportService.runAndRenderReport(BirtViewerReportService.java:973)
        at org.eclipse.birt.report.service.actionhandler.BirtGetPageAllActionHandler.__execute(BirtGetPageAllActionHandler.java:131)
        at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(AbstractBaseActionHandler.java:90)
        at org.eclipse.birt.report.soapengine.processor.AbstractBaseDocumentProcessor.__executeAction(AbstractBaseDocumentProcessor.java:47)
        at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.executeAction(AbstractBaseComponentProcessor.java:143)
        at org.eclipse.birt.report.soapengine.processor.BirtDocumentProcessor.handleGetPageAll(BirtDocumentProcessor.java:183)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.process(AbstractBaseComponentProcessor.java:112)
        at org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingImpl.getUpdatedObjects(BirtSoapBindingImpl.java:66)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397)
        at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186)
        at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323)
        at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)
        at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)
        at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
        at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:454)
        at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281)
        at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699)
        at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doPost(BirtSoapMessageDispatcherServlet.java:265)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
        at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
        at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122)
        at org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrapper.service(ServletManager.java:180)
        at org.eclipse.equinox.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:61)
        at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:126)
        at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:60)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
        at org.eclipse.equinox.http.jetty.internal.HttpServerManager$InternalHttpServiceServlet.service(HttpServerManager.java:318)
        at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511)
        at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:390)
        at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182)
        at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)
        at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
        at org.mortbay.jetty.Server.handle(Server.java:322)
        at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542)
        at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:939)
        at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:756)
        at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212)
        at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
        at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:409)
        at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The index 1 is out of range.
        at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:171)
        at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.setterGetParam(SQLServerPreparedStatement.java:700)
        at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.setValue(SQLServerPreparedStatement.java:709)
        at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.setString(SQLServerPreparedStatement.java:1034)
        at org.eclipse.birt.report.data.oda.jdbc.Statement.setString(Statement.java:649)
        ... 78 more

Jun 01, 2015 1:11:36 PM org.eclipse.birt.data.engine.odaconsumer.PreparedStatement getOdaDriverParamMetaData
SEVERE: Cannot get ODA driver parameter metadata.
org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot retrieve the parameter metadata.
SQL error #1:com.microsoft.sqlserver.jdbc.SQLServerException: Unable to identify the table  for the metadata.
 ;
    com.microsoft.sqlserver.jdbc.SQLServerException: com.microsoft.sqlserver.jdbc.SQLServerException: Unable to identify the table  for the metadata.
        at org.eclipse.birt.report.data.oda.jdbc.Statement.getParameterMetaData(Statement.java:897)
        at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQuery.getParameterMetaData(OdaQuery.java:1324)
        at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.getOdaDriverParamMetaData(PreparedStatement.java:1602)
        at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.getParameterMetaData(PreparedStatement.java:1513)
        at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.getParameterMetaData(PreparedStatement.java:1539)
        at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.getParameterType(PreparedStatement.java:798)
        at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.retrySetParameterValue(PreparedStatement.java:3211)
        at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.setParameterValue(PreparedStatement.java:3188)
        at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.setParameterValue(PreparedStatement.java:3070)
        at org.eclipse.birt.data.engine.executor.DataSourceQuery.setInputParameterBinding(DataSourceQuery.java:1161)
        at org.eclipse.birt.data.engine.executor.DataSourceQuery.addParameterDefns(DataSourceQuery.java:595)
        at org.eclipse.birt.data.engine.executor.DataSourceQuery.prepare(DataSourceQuery.java:290)
        at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQueryExecutor.prepareOdiQuery(PreparedOdaDSQuery.java:442)
        at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:341)
        at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:455)
        at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.produceQueryResults(PreparedDataSourceQuery.java:190)
        at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:178)
        at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute(PreparedOdaDSQuery.java:145)
        at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:624)
        at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:152)
        at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:267)
        at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1939)
        at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:80)
        at org.eclipse.birt.report.engine.executor.DataItemExecutor.execute(DataItemExecutor.java:75)
        at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43)
        at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46)
        at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:34)
        at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65)
        at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:92)
        at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:100)
        at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:180)
        at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:77)
        at org.eclipse.birt.report.service.ReportEngineService.runAndRenderReport(ReportEngineService.java:937)
        at org.eclipse.birt.report.service.BirtViewerReportService.runAndRenderReport(BirtViewerReportService.java:973)
        at org.eclipse.birt.report.service.actionhandler.BirtGetPageAllActionHandler.__execute(BirtGetPageAllActionHandler.java:131)
        at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(AbstractBaseActionHandler.java:90)
        at org.eclipse.birt.report.soapengine.processor.AbstractBaseDocumentProcessor.__executeAction(AbstractBaseDocumentProcessor.java:47)
        at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.executeAction(AbstractBaseComponentProcessor.java:143)
        at org.eclipse.birt.report.soapengine.processor.BirtDocumentProcessor.handleGetPageAll(BirtDocumentProcessor.java:183)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.process(AbstractBaseComponentProcessor.java:112)
        at org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingImpl.getUpdatedObjects(BirtSoapBindingImpl.java:66)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397)
        at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186)
        at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323)
        at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)
        at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)
        at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
        at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:454)
        at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281)
        at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699)
        at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doPost(BirtSoapMessageDispatcherServlet.java:265)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
        at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
        at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122)
        at org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrapper.service(ServletManager.java:180)
        at org.eclipse.equinox.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:61)
        at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:126)
        at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:60)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
        at org.eclipse.equinox.http.jetty.internal.HttpServerManager$InternalHttpServiceServlet.service(HttpServerManager.java:318)
        at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511)
        at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:390)
        at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182)
        at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)
        at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
        at org.mortbay.jetty.Server.handle(Server.java:322)
        at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542)
        at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:939)
        at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:756)
        at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212)
        at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
        at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:409)
        at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: com.microsoft.sqlserver.jdbc.SQLServerException: Unable to identify the table  for the metadata.
        at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:171)
        at com.microsoft.sqlserver.jdbc.SQLServerParameterMetaData.(SQLServerParameterMetaData.java:426)
        at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.getParameterMetaData(SQLServerPreparedStatement.java:1510)
        at org.eclipse.birt.report.data.oda.jdbc.Statement.getParameterMetaData(Statement.java:893)
        ... 81 more

13:11:37.128 [477956236@qtp-1169973526-3 - /viewer/run?__report=E%3A%5CBI%5CSpagoBIStudio_5.1.0_win64%5Cworkspace%5CDemoTest%5CBusiness+Analysis%5CBirtreportTest.rptdesign&__format=html&__svg=false&__locale=en_US&__timezone=Asia%2FCalcutta&__masterpage=true&__rtl=false&__maxrows=500&__cubememsize=10&__resourceFolder=E%3A%5CBI%5CSpagoBIStudio_5.1.0_win64%5Cworkspace%5CDemoTest&__dpi=96&1359970670&__sessionId=20150601_131135_570] DEBUG org.mortbay.log - RESPONSE /viewer/run  200
13:12:42.139 [1600735362@qtp-1169973526-4] DEBUG org.mortbay.log - EXCEPTION
java.io.IOException: An existing connection was forcibly closed by the remote host
        at sun.nio.ch.SocketDispatcher.read0(Native Method) ~[na:1.7.0_65]
        at sun.nio.ch.SocketDispatcher.read(Unknown Source) ~[na:1.7.0_65]
        at sun.nio.ch.IOUtil.readIntoNativeBuffer(Unknown Source) ~[na:1.7.0_65]
        at sun.nio.ch.IOUtil.read(Unknown Source) ~[na:1.7.0_65]
        at sun.nio.ch.SocketChannelImpl.read(Unknown Source) ~[na:1.7.0_65]
        at org.mortbay.io.nio.ChannelEndPoint.fill(ChannelEndPoint.java:131) ~[na:na]
        at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:290) ~[na:na]
        at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212) ~[na:na]
        at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404) ~[na:na]
        at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:409) ~[na:na]
        at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582) ~[na:na]
13:12:42.139 [477956236@qtp-1169973526-3] DEBUG org.mortbay.log - EXCEPTION
java.io.IOException: An existing connection was forcibly closed by the remote host
        at sun.nio.ch.SocketDispatcher.read0(Native Method) ~[na:1.7.0_65]
        at sun.nio.ch.SocketDispatcher.read(Unknown Source) ~[na:1.7.0_65]
        at sun.nio.ch.IOUtil.readIntoNativeBuffer(Unknown Source) ~[na:1.7.0_65]
        at sun.nio.ch.IOUtil.read(Unknown Source) ~[na:1.7.0_65]
        at sun.nio.ch.SocketChannelImpl.read(Unknown Source) ~[na:1.7.0_65]
        at org.mortbay.io.nio.ChannelEndPoint.fill(ChannelEndPoint.java:131) ~[na:na]
        at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:290) ~[na:na]
        at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212) ~[na:na]
        at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404) ~[na:na]
        at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:409) ~[na:na]
        at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582) ~[na:na]
13:12:42.145 [1600735362@qtp-1169973526-4] DEBUG org.mortbay.log - EOF
13:12:42.197 [477956236@qtp-1169973526-3] DEBUG org.mortbay.log - EOF

Click on below post , for solution to related error

"http://j4info.blogspot.in/2015/06/sp14-create-birt-report-and-pass.html"

SP11 The index 1 is out of range.

SpagoBI error
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The index 1 is out of range.
        at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:171)
        at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.setterGetParam(SQLServerPreparedStatement.java:700)
        at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.setValue(SQLServerPreparedStatement.java:709)
        at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.setString(SQLServerPreparedStatement.java:1034)
        at org.eclipse.birt.report.data.oda.jdbc.Statement.setString(Statement.java:649)
        ... 78 more


Problem :
i was using count(*)  in selection of query in dataset.

Solution:
Use count(field_name) in query , instead of *

This error generally came because of use of * in database query.

SP10 Change the spago BI main page image

1. Chose your *.png file. [with null background color]
2. Move above file to path

"\apache-tomcat-7.0.59\webapps\SpagoBI\themes\sbi_default\img\wapp"

3. After successfull replacement of image rename ur image to "background_login.png"
4. Move to path
"apache-tomcat-7.0.59\webapps\SpagoBI\themes\sbi_default\jsp\"

5. open file "login.jsp"
6. Edit the file
- Need to update the pixel (width height) equivalent to your new image
- Add the image name (if u are using ""background_login"" then no need to change the name)

6. edit the required field
7. Refresh "http:\\localhost:8080\SpagoBI" page

SP09 Change the spago BI Home screen

1. Chose your *.png file.
2. Move above file to path

"\apache-tomcat-7.0.59\webapps\SpagoBI\themes\sbi_default\img"

3. After successfull replacement of image rename ur image to "welcome.png"
4. Move to path
"\apache-tomcat-7.0.59\webapps\SpagoBI\themes\sbi_default\html\technicalUserIntro.html"

5. open file "technicalUserIntro.html"
6. edit the required field
7. Refresh "http:\\localhost:8080\SpagoBI
" page

Error while Oracle installation on Windows 7

The request to start the service OracleMTSRecoveryService has timed out.

I was installing oracle on windows machine and in between i got the above error.

Problem: Windows was busy in restart process.

Solution: If you have popup of restart of computer then cancel that popup and click on "retry" button of error popup window