I've got a big problem with the Analysis Services.
I have a SQL Server 2000 SP3 and the Analysis Services SP3 running. The SQL Server has no problems.
When I try to browse the Data of any cube, the following error message occurs:
"Provider cannot be found. It may not be properly installed." When I try to browse other cubes after this, the error message "unknown error" occurs.
The databases, on which the cubes are based are both Access2k and SQL Server 2k. The error even appears at the test cubes from Microsoft, so it cannot be simply a problem of the database.
Much thx for your answers.Try to restart the services on the machine.|||That would be an easy solution. I tried it at first. :-)
It didn't change anything.|||Are you trying to browse from WINXP? If so, you'll need to install sp3 for analysis services on the client.|||I could solve the problem. I had an error when installing sp3 for analysis services on the server. I didn't take notice of it. Later I checked the Version number and recognized, that sp3 was not installed. I installed sp3 again and then it works.
greets,
Stefan
Showing posts with label running. Show all posts
Showing posts with label running. Show all posts
Tuesday, March 27, 2012
Analysis Services
I have a MS SQL Server 2000 SP3 running under MS Server 2000 Standard Edit
SP4 (MDAC 2.8).
I just installed Analysis Services. How do I apply SP3 to this system?
Each time I try to reinstall SP3, I get the message:
"Setup was unable to validate the logged user. Press Retry to enter another
option, or Cancel to exit setup."
After I exit SP3, the SQLSERVER AGENT is stopped even though it was running
when I start the SP3.
Thank you...Ed
> I have a MS SQL Server 2000 SP3 running under MS Server 2000 Standard Edit
> SP4 (MDAC 2.8).
What? Can you explain this again?
> I just installed Analysis Services. How do I apply SP3 to this system?
If you review http://www.microsoft.com/sql/downloads/2000/sp3.asp, you'll
see that you need to download sql2kasp3.exe.
http://www.aspfaq.com/
(Reverse address to reply.)
SP4 (MDAC 2.8).
I just installed Analysis Services. How do I apply SP3 to this system?
Each time I try to reinstall SP3, I get the message:
"Setup was unable to validate the logged user. Press Retry to enter another
option, or Cancel to exit setup."
After I exit SP3, the SQLSERVER AGENT is stopped even though it was running
when I start the SP3.
Thank you...Ed
> I have a MS SQL Server 2000 SP3 running under MS Server 2000 Standard Edit
> SP4 (MDAC 2.8).
What? Can you explain this again?
> I just installed Analysis Services. How do I apply SP3 to this system?
If you review http://www.microsoft.com/sql/downloads/2000/sp3.asp, you'll
see that you need to download sql2kasp3.exe.
http://www.aspfaq.com/
(Reverse address to reply.)
Analysis Services
I have a MS SQL Server 2000 SP3 running under MS Server 2000 Standard Edit
SP4 (MDAC 2.8).
I just installed Analysis Services. How do I apply SP3 to this system?
Each time I try to reinstall SP3, I get the message:
"Setup was unable to validate the logged user. Press Retry to enter another
option, or Cancel to exit setup."
After I exit SP3, the SQLSERVER AGENT is stopped even though it was running
when I start the SP3.
Thank you...Ed> I have a MS SQL Server 2000 SP3 running under MS Server 2000 Standard Edit
> SP4 (MDAC 2.8).
What? Can you explain this again?
> I just installed Analysis Services. How do I apply SP3 to this system?
If you review http://www.microsoft.com/sql/downloads/2000/sp3.asp, you'll
see that you need to download sql2kasp3.exe.
--
http://www.aspfaq.com/
(Reverse address to reply.)
SP4 (MDAC 2.8).
I just installed Analysis Services. How do I apply SP3 to this system?
Each time I try to reinstall SP3, I get the message:
"Setup was unable to validate the logged user. Press Retry to enter another
option, or Cancel to exit setup."
After I exit SP3, the SQLSERVER AGENT is stopped even though it was running
when I start the SP3.
Thank you...Ed> I have a MS SQL Server 2000 SP3 running under MS Server 2000 Standard Edit
> SP4 (MDAC 2.8).
What? Can you explain this again?
> I just installed Analysis Services. How do I apply SP3 to this system?
If you review http://www.microsoft.com/sql/downloads/2000/sp3.asp, you'll
see that you need to download sql2kasp3.exe.
--
http://www.aspfaq.com/
(Reverse address to reply.)
Analysis Services
I am trying to work through the tutorial when you load SQL 2005. I am running the 64 bit version. I have deployed my cube and am trying to display data in the browser. I move over the sales amount into the data area I get the below message. What should I do to fix this issue?
The query could not be processed:
Memory error: While attempting to store a string, a string was found that was larger than the page size selected. The operation cannot be completed.
Sounds similar to the problem discussed in this thread:http://groups.google.com/group/microsoft.public.sqlserver.olap/msg/d2ca4c8981db915a
>>
Please read this thread - there is plenty of feedback from the product team.
It is a bug in CTP16 that is fixed in RTM. If you are TAP customer - you can
get CTP16 hotfix for it.
--
==================================================
Mosha Pasumansky - http://www.mosha.com/msolap
Analysis Services blog at http://www.sqljunkies.com/WebLog/mosha
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================
>>
Sunday, March 25, 2012
Analysis Service Manager
I give up, how do you start the Analysis Manager? SSAS is installed and running, but I just can't seem to find the button/shortcut/whatever to start the manager.
If you are using SSAS 2005, you should use SQL Server Management Studio and connect to Analysis Services to view server objects
For development, you will have to use BIDS (BI development studio - Visual studio 2005)
|||Thanks, but how do I get to a 2K database?|||If u r using AS 2000, then I guess it would be better to use Analysis Manager. It should be under Programs ==> Microsoft SQL Server.|||I have to support both 2000 (legacy) and 2005 AS. However, I can't have both Services installed at the same time, which is why I'm trying to use SSAS 2005.|||You can have both services installed at the same time.
You have to install AS2k as the default (unnamed instance) as it does not support named instances.
You then install AS2k5 as a named instance, on my machine I have it setup as localhost\SQL05. But you still need both sets of admin tools Analysis Manager for AS2k and Management Studio and BI Dev Studio for AS2k5. You cannot administer both versions from a single tool.
sqlThursday, March 22, 2012
Analysis Server
We are running Analysis Server on Windows 2000 and it's running under local system account,but most of the time we are getting the following error 'Error = -2147221455 (80040031) Error string: Unable to connect to the registry on the server ,or you are not a member of the OLAP Administrators group on this server.'This happens when we try to refresh the cube and the only thing that makes it work again is to go to the Services under the control panel and stop and restart the OLAP services.I wonder why??By refresh, do you mean re-process the cube?
Tuesday, March 20, 2012
Analisys Services OLAP Error
running sql server 2000 w/ analisys serv sp4 on w2k3 sp1. Yes, also we are running sql 2000 sp4.
I keep getting an event id 6034.
The mssqlserverolapservice service terminated unexpectedly. It has done this 134 times.
Now, i went ahead and installed the suggested rollup hotfix already, which is a post AS SP4 rollup hotfix that fixes this.
It didn't.
What next?
Mike,
This is just one of the possible options:
I have seen this happening with corrupted database. To fix this, you have to find corrupted database and remove it from data folder. I was doing this:
1. Stop Analysis Services service.
2. Go to analysis services data folder and copy folder for one database to another outside folder. Also copy related file from root data folder (I think something like DBName.odb, forgot extension)?
3. Try to start analysis services, if same problem, choose another database and do step 2.
If you'll find corrupted databases, copy all other ones back. Restore corrupted database from backup.
Vidas Matelis
sqlAn unexpected token "." was found following "". Expected tokens may include: "
I'm a little bit lost on this one. I use a SQL 2000 datbase and have been running a stored procedure for several years that hits a DB2 database. The DB2 server is linked. I need to make a small modification to the procedure that will pull in an additional date value to a temp table. What I thought would be very simple has me lost. The procedure is as follows and I've highlighted the area I added.
CREATE PROCEDURE sp_ivSqlAcquireCWMM_With_15K
@.claim_nbr varchar(30)
AS
/* Declare variables */
declare @.insert_sql varchar(1000)
declare @.openquery_sql varchar(1000)
declare @.fields_sql1 varchar(1000)
declare @.from_sql varchar(1000)
declare @.where_sql varchar(1000)
declare @.claim_nbr_2 char(30)
declare @.pri_con_type char(4)
--declare @.Where_Por Char(30)
CREATE TABLE #tCaseContact
(
CLAIM_NBR char(30),
CASE_NBR CHAR(11),
INJ_SSN CHAR(9),
INJ_FNAME CHAR(20),
INJ_MID_INIT CHAR(1),
INJ_LNAME char(30),
INJ_NME_SUF CHAR(3),
TPLOC_NAME CHAR(60),
TPLOC_POLICY_NBR CHAR(20),
DT_OF_INJ DATETIME,
CASE_STS CHAR(4),
TEAM_NBR CHAR(4),
USER_KEY char(16),
TPA_ID CHAR(9),
CON_TYPE char(4),
CON_ID int,
PRIMARY_IND char(1),
EMP_Tier char(1),
Non_UM char(1),
POR char(42) NULL,
Cont_Type char(4),
Thousand_Date datetime)
/* Assert Claim Number from @.claim_nbr parameter */
set @.claim_nbr_2 = cast(@.claim_nbr as char(30))
set @.insert_sql = 'INSERT INTO #tCaseContact '
set @.openquery_sql = ' ' +
' SELECT * FROM OPENQUERY( CWMM,''SELECT'
set @.fields_sql1 = ' ' +
'a.twccs_claim_nbr, ' +
'a.twccs_case_nbr, ' +
'a.twccs_inj_ssn, ' +
'a.twccs_inj_fname, ' +
'a.twccs_inj_mid_init, ' +
'a.twccs_inj_lname, ' +
'a.twccs_inj_nme_suf, ' +
'mcdb.polloc_cw.tploc_name, ' +
'mcdb.polloc_cw.tploc_policy_nbr, ' +
'a.twccs_dt_of_inj, ' +
'a.twccs_case_sts, ' +
'mcdb.polloc_cw.tploc_team_nbr, ' +
'c.tctyp_user_key, ' +
'a.twccs_tpa_id, ' +
'b.twcon_con_type, ' +
'b.twcon_con_id_pers, ' +
'b.twcon_primary_ind, ' +
'e.tpoli_prem_tier, ' +
'e.tpoli_non_um, ' +
'f.NAME, ' +
'b.twcon_con_type, ' +
'a.twccs_1000_lmt_dt'
set @.from_sql = '' +
'FROM ' +
'MCDB.WCCASE_CW AS a ' +
'INNER JOIN MCDB.WCCONTT AS b ON ' +
'(a.TWCCS_CASE_NBR = b.TWCON_CASE_NBR) ' +
'INNER JOIN MCDB.CONTYPT AS c ON ' +
'(b.TWCON_CON_ID_PERS = c.TCTYP_CON_ID) ' +
'INNER JOIN MCDB.POLLOC_CW AS d ON ' +
'(a.TWCCS_POLICY_NBR = d.TPLOC_POLICY_NBR) ' +
'INNER JOIN MCDB.POLICY_CW AS e ON ' +
'(d.TPLOC_POLICY_NBR = e.TPOLI_POLICY_NBR) ' +
'Left Outer JOIN PRODSYS.CWPV001_PROV_MASTER as f ON ' +
'(a.TWCCS_POR_NO = f.PROV_NO)'
SET @.where_sql = '' +
'WHERE ' +
'b.TWCON_CON_TYPE IN (''''MCS'''', ''''MCN'''', ''''RRS'''') ' +
'AND ' +
'c.TCTYP_CON_TYPE = ''''USER'''' ' +
'AND ' +
'b.TWCON_STS = ''''A'''' ' +
'AND ' +
'a.TWCCS_CLAIM_NBR = '' + @.claim_nbr_2 + ''' +
''')'
exec( @.insert_sql + @.openquery_sql + @.fields_sql1 +
@.from_sql + @.where_sql )
/*
SELECT * FROM #tCaseContact
*/
if (exists
(SELECT CLAIM_NBR
FROM #tCaseContact
WHERE CON_TYPE = 'MCN' AND PRIMARY_IND = '1'))
set @.pri_con_type = cast('MCN' as char(4))
if (exists
(SELECT CLAIM_NBR
FROM #tCaseContact
WHERE CON_TYPE = 'MCS' AND PRIMARY_IND = '2'))
set @.pri_con_type = cast('MCS' as char(4))
if (exists
(SELECT CLAIM_NBR
FROM #tCaseContact
WHERE CON_TYPE = 'MCS' AND CAST(PRIMARY_IND AS VARCHAR(4)) = '') AND
(exists
(SELECT CLAIM_NBR
FROM #tCaseContact
WHERE CON_TYPE = 'RRS' AND PRIMARY_IND = '4')))
set @.pri_con_type = cast('RRS' as char(4))
if @.pri_con_type is null set @.pri_con_type = cast('MCS' as char(4))
/*sets the MCS as the Primary Contact if the primary contact is returned as null*/
/* if (exists
(Select POR
FROM #tCaseContact set POR=f.
where POR is not null))
if Por='' or Por is null
Else set POR=null
*/
SELECT
TOP 1
a.CLAIM_NBR ,
a.CASE_NBR ,
a.INJ_SSN ,
a.INJ_FNAME ,
a.INJ_MID_INIT ,
a.INJ_LNAME ,
a.INJ_NME_SUF ,
a.TPLOC_NAME ,
a.TPLOC_POLICY_NBR ,
convert(varchar(10),a.DT_OF_INJ, 101) as TWCCS_DT_OF_INJ,
a.CASE_STS ,
a.TEAM_NBR ,
(
SELECT top 1 a1.USER_KEY FROM #tCaseContact AS a1 WHERE a1.CON_TYPE = @.pri_con_type
) as USER_KEY ,
a.TPA_ID,
a.EMP_TIER,
a.NON_UM,
a.POR,
(
SELECT top 1 a1.Con_Type FROM #tCaseContact AS a1 WHERE a1.CON_TYPE = @.pri_con_type
) as Cont_Type,
convert(varchar(10),a. Thousand_Date,101) as twccs_1000_lmt_dt
FROM
#tCaseContact AS a
GOdeclare @.openquery_sql varchar(1000)
Up the varchar limit to 2000 and give it a whirl. I think the variable is truncating.|||I still get the same error. Just out of curiousity, does SQL have a problem where the column name has numeric values in it? The reason I'm wondering is when I first added the Thousand_Date to the Temp table I called it K_1000 and SQL basically told me the it was an invalid value, when I chenged it a=it accepted it OK. The DB2 column is twccs_1000_lmt_dt in the @.fields_sql1 portion and I was wondering if that may have something to do with it.
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: [IBM][CLI Driver][DB2] SQL0104N An unexpected token "MCDB" was found following "". Expected tokens may include: ", FROM INTO". SQLSTATE=42601
]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IColumnsInfo::GetColumnsInfo returned 0x80004005: ].|||This looks like the DB2 server is having trouble with the query. Can you print out the select query that is being generated, and see if that runs via DB2's query tools?|||The only problem I have is my access to the DB2 database is limited to a view in a linked server. It's a remote database and they have it locked down. I don't have any DB2 utilities except for the OBDC conntection.|||Time to get to know someone with the tools, then.
You may not even have to go that far, though. Even if you spit out the query from all the dynamic string concat functions, you may see the problem right off.|||I'll see what I can do.|||Just a quick follow up in case anyone else runs into a similar situation. The problem turned out to be a problem with the DB2 date format. One of the other SQL Admins ran into it when he was creating our data warehouse. to resolve the problem the following code had to be inserted into the open query statement.
' CASE ' +
' WHEN CAST(TWCCS_1000_LMT_DT AS DATE) < ''''1753-01-01'' +
' THEN DATE(''''1753-01-01'''')' +
' ELSE CAST(TWCCS_1000_LMT_DT AS DATE)' +
' END ' +
' AS TWCCS_1000_LMT_DT '|||Just a quick follow up in case anyone else runs into a similar situation. The problem turned out to be a problem with the DB2 date format. One of the other SQL Admins ran into it when he was creating our data warehouse. to resolve the problem the following code had to be inserted into the open query statement.
' CASE ' +
' WHEN CAST(TWCCS_1000_LMT_DT AS DATE) < ''''1753-01-01'' +
' THEN DATE(''''1753-01-01'''')' +
' ELSE CAST(TWCCS_1000_LMT_DT AS DATE)' +
' END ' +
' AS TWCCS_1000_LMT_DT '
With that date is it a "Pilgrim Tracking System" ?
Happy turkey day.
CREATE PROCEDURE sp_ivSqlAcquireCWMM_With_15K
@.claim_nbr varchar(30)
AS
/* Declare variables */
declare @.insert_sql varchar(1000)
declare @.openquery_sql varchar(1000)
declare @.fields_sql1 varchar(1000)
declare @.from_sql varchar(1000)
declare @.where_sql varchar(1000)
declare @.claim_nbr_2 char(30)
declare @.pri_con_type char(4)
--declare @.Where_Por Char(30)
CREATE TABLE #tCaseContact
(
CLAIM_NBR char(30),
CASE_NBR CHAR(11),
INJ_SSN CHAR(9),
INJ_FNAME CHAR(20),
INJ_MID_INIT CHAR(1),
INJ_LNAME char(30),
INJ_NME_SUF CHAR(3),
TPLOC_NAME CHAR(60),
TPLOC_POLICY_NBR CHAR(20),
DT_OF_INJ DATETIME,
CASE_STS CHAR(4),
TEAM_NBR CHAR(4),
USER_KEY char(16),
TPA_ID CHAR(9),
CON_TYPE char(4),
CON_ID int,
PRIMARY_IND char(1),
EMP_Tier char(1),
Non_UM char(1),
POR char(42) NULL,
Cont_Type char(4),
Thousand_Date datetime)
/* Assert Claim Number from @.claim_nbr parameter */
set @.claim_nbr_2 = cast(@.claim_nbr as char(30))
set @.insert_sql = 'INSERT INTO #tCaseContact '
set @.openquery_sql = ' ' +
' SELECT * FROM OPENQUERY( CWMM,''SELECT'
set @.fields_sql1 = ' ' +
'a.twccs_claim_nbr, ' +
'a.twccs_case_nbr, ' +
'a.twccs_inj_ssn, ' +
'a.twccs_inj_fname, ' +
'a.twccs_inj_mid_init, ' +
'a.twccs_inj_lname, ' +
'a.twccs_inj_nme_suf, ' +
'mcdb.polloc_cw.tploc_name, ' +
'mcdb.polloc_cw.tploc_policy_nbr, ' +
'a.twccs_dt_of_inj, ' +
'a.twccs_case_sts, ' +
'mcdb.polloc_cw.tploc_team_nbr, ' +
'c.tctyp_user_key, ' +
'a.twccs_tpa_id, ' +
'b.twcon_con_type, ' +
'b.twcon_con_id_pers, ' +
'b.twcon_primary_ind, ' +
'e.tpoli_prem_tier, ' +
'e.tpoli_non_um, ' +
'f.NAME, ' +
'b.twcon_con_type, ' +
'a.twccs_1000_lmt_dt'
set @.from_sql = '' +
'FROM ' +
'MCDB.WCCASE_CW AS a ' +
'INNER JOIN MCDB.WCCONTT AS b ON ' +
'(a.TWCCS_CASE_NBR = b.TWCON_CASE_NBR) ' +
'INNER JOIN MCDB.CONTYPT AS c ON ' +
'(b.TWCON_CON_ID_PERS = c.TCTYP_CON_ID) ' +
'INNER JOIN MCDB.POLLOC_CW AS d ON ' +
'(a.TWCCS_POLICY_NBR = d.TPLOC_POLICY_NBR) ' +
'INNER JOIN MCDB.POLICY_CW AS e ON ' +
'(d.TPLOC_POLICY_NBR = e.TPOLI_POLICY_NBR) ' +
'Left Outer JOIN PRODSYS.CWPV001_PROV_MASTER as f ON ' +
'(a.TWCCS_POR_NO = f.PROV_NO)'
SET @.where_sql = '' +
'WHERE ' +
'b.TWCON_CON_TYPE IN (''''MCS'''', ''''MCN'''', ''''RRS'''') ' +
'AND ' +
'c.TCTYP_CON_TYPE = ''''USER'''' ' +
'AND ' +
'b.TWCON_STS = ''''A'''' ' +
'AND ' +
'a.TWCCS_CLAIM_NBR = '' + @.claim_nbr_2 + ''' +
''')'
exec( @.insert_sql + @.openquery_sql + @.fields_sql1 +
@.from_sql + @.where_sql )
/*
SELECT * FROM #tCaseContact
*/
if (exists
(SELECT CLAIM_NBR
FROM #tCaseContact
WHERE CON_TYPE = 'MCN' AND PRIMARY_IND = '1'))
set @.pri_con_type = cast('MCN' as char(4))
if (exists
(SELECT CLAIM_NBR
FROM #tCaseContact
WHERE CON_TYPE = 'MCS' AND PRIMARY_IND = '2'))
set @.pri_con_type = cast('MCS' as char(4))
if (exists
(SELECT CLAIM_NBR
FROM #tCaseContact
WHERE CON_TYPE = 'MCS' AND CAST(PRIMARY_IND AS VARCHAR(4)) = '') AND
(exists
(SELECT CLAIM_NBR
FROM #tCaseContact
WHERE CON_TYPE = 'RRS' AND PRIMARY_IND = '4')))
set @.pri_con_type = cast('RRS' as char(4))
if @.pri_con_type is null set @.pri_con_type = cast('MCS' as char(4))
/*sets the MCS as the Primary Contact if the primary contact is returned as null*/
/* if (exists
(Select POR
FROM #tCaseContact set POR=f.
where POR is not null))
if Por='' or Por is null
Else set POR=null
*/
SELECT
TOP 1
a.CLAIM_NBR ,
a.CASE_NBR ,
a.INJ_SSN ,
a.INJ_FNAME ,
a.INJ_MID_INIT ,
a.INJ_LNAME ,
a.INJ_NME_SUF ,
a.TPLOC_NAME ,
a.TPLOC_POLICY_NBR ,
convert(varchar(10),a.DT_OF_INJ, 101) as TWCCS_DT_OF_INJ,
a.CASE_STS ,
a.TEAM_NBR ,
(
SELECT top 1 a1.USER_KEY FROM #tCaseContact AS a1 WHERE a1.CON_TYPE = @.pri_con_type
) as USER_KEY ,
a.TPA_ID,
a.EMP_TIER,
a.NON_UM,
a.POR,
(
SELECT top 1 a1.Con_Type FROM #tCaseContact AS a1 WHERE a1.CON_TYPE = @.pri_con_type
) as Cont_Type,
convert(varchar(10),a. Thousand_Date,101) as twccs_1000_lmt_dt
FROM
#tCaseContact AS a
GOdeclare @.openquery_sql varchar(1000)
Up the varchar limit to 2000 and give it a whirl. I think the variable is truncating.|||I still get the same error. Just out of curiousity, does SQL have a problem where the column name has numeric values in it? The reason I'm wondering is when I first added the Thousand_Date to the Temp table I called it K_1000 and SQL basically told me the it was an invalid value, when I chenged it a=it accepted it OK. The DB2 column is twccs_1000_lmt_dt in the @.fields_sql1 portion and I was wondering if that may have something to do with it.
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: [IBM][CLI Driver][DB2] SQL0104N An unexpected token "MCDB" was found following "". Expected tokens may include: ", FROM INTO". SQLSTATE=42601
]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IColumnsInfo::GetColumnsInfo returned 0x80004005: ].|||This looks like the DB2 server is having trouble with the query. Can you print out the select query that is being generated, and see if that runs via DB2's query tools?|||The only problem I have is my access to the DB2 database is limited to a view in a linked server. It's a remote database and they have it locked down. I don't have any DB2 utilities except for the OBDC conntection.|||Time to get to know someone with the tools, then.
You may not even have to go that far, though. Even if you spit out the query from all the dynamic string concat functions, you may see the problem right off.|||I'll see what I can do.|||Just a quick follow up in case anyone else runs into a similar situation. The problem turned out to be a problem with the DB2 date format. One of the other SQL Admins ran into it when he was creating our data warehouse. to resolve the problem the following code had to be inserted into the open query statement.
' CASE ' +
' WHEN CAST(TWCCS_1000_LMT_DT AS DATE) < ''''1753-01-01'' +
' THEN DATE(''''1753-01-01'''')' +
' ELSE CAST(TWCCS_1000_LMT_DT AS DATE)' +
' END ' +
' AS TWCCS_1000_LMT_DT '|||Just a quick follow up in case anyone else runs into a similar situation. The problem turned out to be a problem with the DB2 date format. One of the other SQL Admins ran into it when he was creating our data warehouse. to resolve the problem the following code had to be inserted into the open query statement.
' CASE ' +
' WHEN CAST(TWCCS_1000_LMT_DT AS DATE) < ''''1753-01-01'' +
' THEN DATE(''''1753-01-01'''')' +
' ELSE CAST(TWCCS_1000_LMT_DT AS DATE)' +
' END ' +
' AS TWCCS_1000_LMT_DT '
With that date is it a "Pilgrim Tracking System" ?
Happy turkey day.
An unexpected error occurred while connecting to the report server.
I have a distributed environment with SQL Server 2005 SP2 (RTM) running on one server. This server holds the databases for SharePoint and Reporting Services. I then have SharePoint 3.0 (32-bit version) with the reporting services add-in installed on a second server. I installed the sharepoint object model (64-bit version) on the database server as suggested and have configured Reporting Services to use domain user accounts. The Reporting Services configuration tool is reporting that integration has been successfully set up but I am unable to access the "Set Server Defaults" page without an error. This is the error I receive:
An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode.
Please help.
Solaena,
I would suggest to take a look at the Report Server log files located on your Report Server machine in this location:
%Program Files%\Microsoft SQL Server\MSSQL.X\Reporting Services\LogFiles
Look for a log file whose name starts with ReportServerService and see what exception you find there.
Mihaela
This posting is provided "AS IS" with no warranties, and confers no rights.
|||
After some digging I found an error message that led me to this thread: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1282744&SiteID=1
I am now able to access the "Set Server Defaults" page but I am unable to open any reports and I can't add any reports to the web part. From what I can see I have two errors.
#1 - When adding a report to the web part I am denied access. Access is denied to my domain/user account. This account is a domain admin account.
#2 - NULL Reference exception at "...InternalFindObjectsNonRecursive."
Thanks,
Simone
|||Just thought I would updat that I have been working with Microsoft on this for a few weeks and I will post the outcome when it is resolved. Thanks to all for you insight.|||Just thought I would update everyone on this thread, we were finally able to get all of the integration working. To complete the process we needed to use Kerberos authentication and ensure that the browsers were all set up to enable windows authentication. With Kerberos it is important to be sure that SPNs are set up for the domain account used by the sharepoint and reporting service web services. When doing this, also make sure that duplicate SPNs are not inadvertently created. After two months of working to get this resolved I am thrilled to say we are up and running....
|||Hi Simone,
Did you have to create a SPN for just the MOSS site url or both the MOSS and reportserver url ?
Regards,
BC
|||both servers. also, there is one for just the server name and one for the fully qualified name.
Simone
An unexpected error occurred while connecting to the report server.
I have a distributed environment with SQL Server 2005 SP2 (RTM) running on one server. This server holds the databases for SharePoint and Reporting Services. I then have SharePoint 3.0 (32-bit version) with the reporting services add-in installed on a second server. I installed the sharepoint object model (64-bit version) on the database server as suggested and have configured Reporting Services to use domain user accounts. The Reporting Services configuration tool is reporting that integration has been successfully set up but I am unable to access the "Set Server Defaults" page without an error. This is the error I receive:
An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode.
Please help.
Solaena,
I would suggest to take a look at the Report Server log files located on your Report Server machine in this location:
%Program Files%\Microsoft SQL Server\MSSQL.X\Reporting Services\LogFiles
Look for a log file whose name starts with ReportServerService and see what exception you find there.
Mihaela
This posting is provided "AS IS" with no warranties, and confers no rights.
|||After some digging I found an error message that led me to this thread: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1282744&SiteID=1
I am now able to access the "Set Server Defaults" page but I am unable to open any reports and I can't add any reports to the web part. From what I can see I have two errors.
#1 - When adding a report to the web part I am denied access. Access is denied to my domain/user account. This account is a domain admin account.
#2 - NULL Reference exception at "...InternalFindObjectsNonRecursive."
Thanks,
Simone
|||Just thought I would updat that I have been working with Microsoft on this for a few weeks and I will post the outcome when it is resolved. Thanks to all for you insight.|||Just thought I would update everyone on this thread, we were finally able to get all of the integration working. To complete the process we needed to use Kerberos authentication and ensure that the browsers were all set up to enable windows authentication. With Kerberos it is important to be sure that SPNs are set up for the domain account used by the sharepoint and reporting service web services. When doing this, also make sure that duplicate SPNs are not inadvertently created. After two months of working to get this resolved I am thrilled to say we are up and running....|||Hi Simone,
Did you have to create a SPN for just the MOSS site url or both the MOSS and reportserver url ?
Regards,
BC
|||both servers. also, there is one for just the server name and one for the fully qualified name.
Simone
An unexpected error occurred while connecting to the report server.
I have a distributed environment with SQL Server 2005 SP2 (RTM) running on one server. This server holds the databases for SharePoint and Reporting Services. I then have SharePoint 3.0 (32-bit version) with the reporting services add-in installed on a second server. I installed the sharepoint object model (64-bit version) on the database server as suggested and have configured Reporting Services to use domain user accounts. The Reporting Services configuration tool is reporting that integration has been successfully set up but I am unable to access the "Set Server Defaults" page without an error. This is the error I receive:
An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode.
Please help.
Solaena,
I would suggest to take a look at the Report Server log files located on your Report Server machine in this location:
%Program Files%\Microsoft SQL Server\MSSQL.X\Reporting Services\LogFiles
Look for a log file whose name starts with ReportServerService and see what exception you find there.
Mihaela
This posting is provided "AS IS" with no warranties, and confers no rights.
|||After some digging I found an error message that led me to this thread: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1282744&SiteID=1
I am now able to access the "Set Server Defaults" page but I am unable to open any reports and I can't add any reports to the web part. From what I can see I have two errors.
#1 - When adding a report to the web part I am denied access. Access is denied to my domain/user account. This account is a domain admin account.
#2 - NULL Reference exception at "...InternalFindObjectsNonRecursive."
Thanks,
Simone
|||Just thought I would updat that I have been working with Microsoft on this for a few weeks and I will post the outcome when it is resolved. Thanks to all for you insight.|||Just thought I would update everyone on this thread, we were finally able to get all of the integration working. To complete the process we needed to use Kerberos authentication and ensure that the browsers were all set up to enable windows authentication. With Kerberos it is important to be sure that SPNs are set up for the domain account used by the sharepoint and reporting service web services. When doing this, also make sure that duplicate SPNs are not inadvertently created. After two months of working to get this resolved I am thrilled to say we are up and running....|||Hi Simone,
Did you have to create a SPN for just the MOSS site url or both the MOSS and reportserver url ?
Regards,
BC
|||both servers. also, there is one for just the server name and one for the fully qualified name.
Simone
An unexpected error occurred while connecting to the report server.
I have a distributed environment with SQL Server 2005 SP2 (RTM) running on one server. This server holds the databases for SharePoint and Reporting Services. I then have SharePoint 3.0 (32-bit version) with the reporting services add-in installed on a second server. I installed the sharepoint object model (64-bit version) on the database server as suggested and have configured Reporting Services to use domain user accounts. The Reporting Services configuration tool is reporting that integration has been successfully set up but I am unable to access the "Set Server Defaults" page without an error. This is the error I receive:
An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode.
Please help.
Solaena,
I would suggest to take a look at the Report Server log files located on your Report Server machine in this location:
%Program Files%\Microsoft SQL Server\MSSQL.X\Reporting Services\LogFiles
Look for a log file whose name starts with ReportServerService and see what exception you find there.
Mihaela
This posting is provided "AS IS" with no warranties, and confers no rights.
|||After some digging I found an error message that led me to this thread: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1282744&SiteID=1
I am now able to access the "Set Server Defaults" page but I am unable to open any reports and I can't add any reports to the web part. From what I can see I have two errors.
#1 - When adding a report to the web part I am denied access. Access is denied to my domain/user account. This account is a domain admin account.
#2 - NULL Reference exception at "...InternalFindObjectsNonRecursive."
Thanks,
Simone
|||Just thought I would updat that I have been working with Microsoft on this for a few weeks and I will post the outcome when it is resolved. Thanks to all for you insight.|||Just thought I would update everyone on this thread, we were finally able to get all of the integration working. To complete the process we needed to use Kerberos authentication and ensure that the browsers were all set up to enable windows authentication. With Kerberos it is important to be sure that SPNs are set up for the domain account used by the sharepoint and reporting service web services. When doing this, also make sure that duplicate SPNs are not inadvertently created. After two months of working to get this resolved I am thrilled to say we are up and running....|||Hi Simone,
Did you have to create a SPN for just the MOSS site url or both the MOSS and reportserver url ?
Regards,
BC
|||both servers. also, there is one for just the server name and one for the fully qualified name.
Simone
sqlAn unexpected error occurred while connecting to the report server.
I have a distributed environment with SQL Server 2005 SP2 (RTM) running on one server. This server holds the databases for SharePoint and Reporting Services. I then have SharePoint 3.0 (32-bit version) with the reporting services add-in installed on a second server. I installed the sharepoint object model (64-bit version) on the database server as suggested and have configured Reporting Services to use domain user accounts. The Reporting Services configuration tool is reporting that integration has been successfully set up but I am unable to access the "Set Server Defaults" page without an error. This is the error I receive:
An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode.
Please help.
Solaena,
I would suggest to take a look at the Report Server log files located on your Report Server machine in this location:
%Program Files%\Microsoft SQL Server\MSSQL.X\Reporting Services\LogFiles
Look for a log file whose name starts with ReportServerService and see what exception you find there.
Mihaela
This posting is provided "AS IS" with no warranties, and confers no rights.
|||After some digging I found an error message that led me to this thread: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1282744&SiteID=1
I am now able to access the "Set Server Defaults" page but I am unable to open any reports and I can't add any reports to the web part. From what I can see I have two errors.
#1 - When adding a report to the web part I am denied access. Access is denied to my domain/user account. This account is a domain admin account.
#2 - NULL Reference exception at "...InternalFindObjectsNonRecursive."
Thanks,
Simone
|||Just thought I would updat that I have been working with Microsoft on this for a few weeks and I will post the outcome when it is resolved. Thanks to all for you insight.|||Just thought I would update everyone on this thread, we were finally able to get all of the integration working. To complete the process we needed to use Kerberos authentication and ensure that the browsers were all set up to enable windows authentication. With Kerberos it is important to be sure that SPNs are set up for the domain account used by the sharepoint and reporting service web services. When doing this, also make sure that duplicate SPNs are not inadvertently created. After two months of working to get this resolved I am thrilled to say we are up and running....|||Hi Simone,
Did you have to create a SPN for just the MOSS site url or both the MOSS and reportserver url ?
Regards,
BC
|||both servers. also, there is one for just the server name and one for the fully qualified name.
Simone
Monday, March 19, 2012
An if...else task
Hi,
Im running a database query and I want to compare the value of a datetime field to see what I wanna do with my data.
Is there any easy way of doing this with something from the Toolbox or would you recommend using a Script Task?
Thank you.
What do you want to compare it to? Can you give more detail about what it is you are trying to do?
-Jamie
|||I have 100 rows of query data.
The rows contain a datetime field that I wanna check.
If the row happens before 10 o'clock:
- Do something
After 10 o'clock:
- Do something else
Thank you.
|||All depends on what Something and Something Else is.You could use a conditional split to send the rows to different places or add an additional column with the flag stating the change or use the script task if you want to change the value of a variable if the condition is found.|||
I would say that conditional split is almost certainly going to be what you are looking for.
in your example you would just set a single case wherein your example datetime column is compared to less than or equal to 10 o'clock and all other rows are sent to default (greater than 10 o'clock) ...
Sunday, March 11, 2012
An existing connection was forcibly closed by the remote host
Hi,
I'm running a website using MSSQL 2000. Sometimes (not always) I get this error message on the website:
A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)
I have also websites running with MySQL and those don't have this problem.
I searched google but I couldn't find usefull information on this problem.
Someone who knows what's going on here ?
All I've found untill now is that it has something to do with the server not responding within a certain time, and thus assuming the connection was closed.I can't find how I can just let it reconnect again in stead of giving me this error message?
An EXCEPTION_ACCESS_VIOLATION during a DELETE...
Our customers server uses SQLServer 7sp4. I don't know too much about the
hardware other than that they have 2gb RAM. Running the DELETE command
below yields an EXCEPTION_ACCESS_VIOLATION and the spid is terminated.
(SqlDumpExceptionHandler: Process 9 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.)
DELETE RSCONFIG WHERE ConfigType IN (1, 2, 3) AND SUBSTRING(ConfigKey,1,3)
IN ('265', '266')
We had them run a DBBC CHECKDB on this database, and eveything is fine. The
"ConfigType" is a smallint and the "ConfigKey" is a varchar(32).
What might this be? We know we have valid SQL and that it has run on many
many of our customers servers.
Any words or ideas will be greatly appreciated. Thanks in advance for your
time.
Sincerely,
James Hunter Ross
Senior Software Developer
O'Neil Software, Inc.This indicates an internal error in sql server. It also indicates it's time
to call PSS (i.e. MS support).
--
Carlos E. Rojas
SQL Server MVP
Co-Author SQL Server 2000 programming by Example
"James Hunter Ross" <james.ross@.oneilsoft.com> wrote in message
news:OG%23ko8f5DHA.2580@.TK2MSFTNGP11.phx.gbl...
The
your
hardware other than that they have 2gb RAM. Running the DELETE command
below yields an EXCEPTION_ACCESS_VIOLATION and the spid is terminated.
(SqlDumpExceptionHandler: Process 9 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.)
DELETE RSCONFIG WHERE ConfigType IN (1, 2, 3) AND SUBSTRING(ConfigKey,1,3)
IN ('265', '266')
We had them run a DBBC CHECKDB on this database, and eveything is fine. The
"ConfigType" is a smallint and the "ConfigKey" is a varchar(32).
What might this be? We know we have valid SQL and that it has run on many
many of our customers servers.
Any words or ideas will be greatly appreciated. Thanks in advance for your
time.
Sincerely,
James Hunter Ross
Senior Software Developer
O'Neil Software, Inc.This indicates an internal error in sql server. It also indicates it's time
to call PSS (i.e. MS support).
--
Carlos E. Rojas
SQL Server MVP
Co-Author SQL Server 2000 programming by Example
"James Hunter Ross" <james.ross@.oneilsoft.com> wrote in message
news:OG%23ko8f5DHA.2580@.TK2MSFTNGP11.phx.gbl...
quote:
> Our customers server uses SQLServer 7sp4. I don't know too much about the
> hardware other than that they have 2gb RAM. Running the DELETE command
> below yields an EXCEPTION_ACCESS_VIOLATION and the spid is terminated.
> (SqlDumpExceptionHandler: Process 9 generated fatal exception c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.)
> DELETE RSCONFIG WHERE ConfigType IN (1, 2, 3) AND SUBSTRING(ConfigKey,1,3)
> IN ('265', '266')
> We had them run a DBBC CHECKDB on this database, and eveything is fine.
The
quote:
> "ConfigType" is a smallint and the "ConfigKey" is a varchar(32).
> What might this be? We know we have valid SQL and that it has run on many
> many of our customers servers.
> Any words or ideas will be greatly appreciated. Thanks in advance for
your
quote:
> time.
> Sincerely,
> James Hunter Ross
> Senior Software Developer
> O'Neil Software, Inc.
>
An EXCEPTION_ACCESS_VIOLATION during a DELETE...
Our customers server uses SQLServer 7sp4. I don't know too much about the
hardware other than that they have 2gb RAM. Running the DELETE command
below yields an EXCEPTION_ACCESS_VIOLATION and the spid is terminated.
(SqlDumpExceptionHandler: Process 9 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.)
DELETE RSCONFIG WHERE ConfigType IN (1, 2, 3) AND SUBSTRING(ConfigKey,1,3)
IN ('265', '266')
We had them run a DBBC CHECKDB on this database, and eveything is fine. The
"ConfigType" is a smallint and the "ConfigKey" is a varchar(32).
What might this be? We know we have valid SQL and that it has run on many
many of our customers servers.
Any words or ideas will be greatly appreciated. Thanks in advance for your
time.
Sincerely,
James Hunter Ross
Senior Software Developer
O'Neil Software, Inc.This indicates an internal error in sql server. It also indicates it's time
to call PSS (i.e. MS support).
--
Carlos E. Rojas
SQL Server MVP
Co-Author SQL Server 2000 Programming by Example
"James Hunter Ross" <james.ross@.oneilsoft.com> wrote in message
news:OG%23ko8f5DHA.2580@.TK2MSFTNGP11.phx.gbl...
> Our customers server uses SQLServer 7sp4. I don't know too much about the
> hardware other than that they have 2gb RAM. Running the DELETE command
> below yields an EXCEPTION_ACCESS_VIOLATION and the spid is terminated.
> (SqlDumpExceptionHandler: Process 9 generated fatal exception c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.)
> DELETE RSCONFIG WHERE ConfigType IN (1, 2, 3) AND SUBSTRING(ConfigKey,1,3)
> IN ('265', '266')
> We had them run a DBBC CHECKDB on this database, and eveything is fine.
The
> "ConfigType" is a smallint and the "ConfigKey" is a varchar(32).
> What might this be? We know we have valid SQL and that it has run on many
> many of our customers servers.
> Any words or ideas will be greatly appreciated. Thanks in advance for
your
> time.
> Sincerely,
> James Hunter Ross
> Senior Software Developer
> O'Neil Software, Inc.
>
hardware other than that they have 2gb RAM. Running the DELETE command
below yields an EXCEPTION_ACCESS_VIOLATION and the spid is terminated.
(SqlDumpExceptionHandler: Process 9 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.)
DELETE RSCONFIG WHERE ConfigType IN (1, 2, 3) AND SUBSTRING(ConfigKey,1,3)
IN ('265', '266')
We had them run a DBBC CHECKDB on this database, and eveything is fine. The
"ConfigType" is a smallint and the "ConfigKey" is a varchar(32).
What might this be? We know we have valid SQL and that it has run on many
many of our customers servers.
Any words or ideas will be greatly appreciated. Thanks in advance for your
time.
Sincerely,
James Hunter Ross
Senior Software Developer
O'Neil Software, Inc.This indicates an internal error in sql server. It also indicates it's time
to call PSS (i.e. MS support).
--
Carlos E. Rojas
SQL Server MVP
Co-Author SQL Server 2000 Programming by Example
"James Hunter Ross" <james.ross@.oneilsoft.com> wrote in message
news:OG%23ko8f5DHA.2580@.TK2MSFTNGP11.phx.gbl...
> Our customers server uses SQLServer 7sp4. I don't know too much about the
> hardware other than that they have 2gb RAM. Running the DELETE command
> below yields an EXCEPTION_ACCESS_VIOLATION and the spid is terminated.
> (SqlDumpExceptionHandler: Process 9 generated fatal exception c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.)
> DELETE RSCONFIG WHERE ConfigType IN (1, 2, 3) AND SUBSTRING(ConfigKey,1,3)
> IN ('265', '266')
> We had them run a DBBC CHECKDB on this database, and eveything is fine.
The
> "ConfigType" is a smallint and the "ConfigKey" is a varchar(32).
> What might this be? We know we have valid SQL and that it has run on many
> many of our customers servers.
> Any words or ideas will be greatly appreciated. Thanks in advance for
your
> time.
> Sincerely,
> James Hunter Ross
> Senior Software Developer
> O'Neil Software, Inc.
>
An error occurred while performing this operation.
Hullo Team,
I kindly request for your help so that I could be able to start reporting services.
The main services are running but reporting services is not running.
It actually gives me the following error
TITLE: Microsoft SQL Server Management Studio
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
ADDITIONAL INFORMATION:
The Report Server Windows service 'ReportServer' is not running. The service must be running to use Report Server. (rsReportServerServiceUnavailable) (Report Services SOAP Proxy Source)
For help, click: http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsReportServerServiceUnavailable&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=9.00.1399.00
The Report Server Windows service 'ReportServer' is not running. The service must be running to use Report Server. (rsReportServerServiceUnavailable) (Microsoft.ReportingServices.Diagnostics)
For help, click: http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsReportServerServiceUnavailable&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=9.00.1399.00
BUTTONS:
OK
Any help will be highly appreciated.
Ronald
Hullo,
I have solved this problem. I had to change the local service account and reporting services restarted..
But when i try to access Reporting Services from MS SQL SEVER Management Studio, it prompt the following error message.
TITLE: Microsoft SQL Server Management Studio
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
ADDITIONAL INFORMATION:
The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) (rsRPCError) (Report Services SOAP Proxy Source)
For help, click: http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsRPCError&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=9.00.1399.00
The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) (rsRPCError) (Microsoft.ReportingServices.Diagnostics)
For help, click: http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsRPCError&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=9.00.1399.00
The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) ()
The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) ()
The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) ()
The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) ()
The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) ()
Bad Data. (Exception from HRESULT: 0x80090005) ()
BUTTONS:
OK
Could someone help me out.
|||Use the configuration tool to change windows service accounts. It will prompt you to backup and restore report server key.
Since you have already manually changed account, try one of the following:
1. Change back to the original account, then use the config tool.
2. Change the key from config tool.
Thursday, March 8, 2012
An error occurred during local report processing.
Occasionally when we are running reports in our web application we are
getting this error. It seems random and occurs even if a report has
just been run with the same criteria. Sometimes the error occurs a
couple of times in a row and then it will run after that fine.
An error occurred during local report processing.
An unexpected error occurred in Report Processing.
Object reference not set to an instance of an object.On Dec 6, 6:12 pm, lachlan.h...@.gmail.com wrote:
> Occasionally when we are running reports in our web application we are
> getting this error. It seems random and occurs even if a report has
> just been run with the same criteria. Sometimes the error occurs a
> couple of times in a row and then it will run after that fine.
> An error occurred during local report processing.
> An unexpected error occurred in Report Processing.
> Object reference not set to an instance of an object.
Sounds like on occasion there is an issue with the cached data for the
report. If you are caching the report data, I would suggest removing
the cache data setting. Also, you might want to delete the rdl.data
file in the interim. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||On Dec 7, 12:18 pm, EMartinez <emartinez...@.gmail.com> wrote:
> On Dec 6, 6:12 pm, lachlan.h...@.gmail.com wrote:
> > Occasionally when we are running reports in our web application we are
> > getting this error. It seems random and occurs even if a report has
> > just been run with the same criteria. Sometimes the error occurs a
> > couple of times in a row and then it will run after that fine.
> > An error occurred during local report processing.
> > An unexpected error occurred in Report Processing.
> > Object reference not set to an instance of an object.
> Sounds like on occasion there is an issue with the cached data for the
> report. If you are caching the report data, I would suggest removing
> the cache data setting. Also, you might want to delete the rdl.data
> file in the interim. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
Thanks Enrique. I was starting to suspect it was something to do with
caching. Do you know how I can remove the cache data setting? I did a
search for rdl.data files on the server and it couldn't find any.|||I've managed to fix it by stopping stopping the W3SVC (WWW Publisher
Service) and deleting all the files in
C:/Windows/Microsoft.NET/Framework/v2.0.50527/Temporary ASP.NET Files/|||On Dec 6, 7:56 pm, lachlan.h...@.gmail.com wrote:
> On Dec 7, 12:18 pm, EMartinez <emartinez...@.gmail.com> wrote:
>
> > On Dec 6, 6:12 pm, lachlan.h...@.gmail.com wrote:
> > > Occasionally when we are running reports in our web application we are
> > > getting this error. It seems random and occurs even if a report has
> > > just been run with the same criteria. Sometimes the error occurs a
> > > couple of times in a row and then it will run after that fine.
> > > An error occurred during local report processing.
> > > An unexpected error occurred in Report Processing.
> > > Object reference not set to an instance of an object.
> > Sounds like on occasion there is an issue with the cached data for the
> > report. If you are caching the report data, I would suggest removing
> > the cache data setting. Also, you might want to delete the rdl.data
> > file in the interim. Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
> Thanks Enrique. I was starting to suspect it was something to do with
> caching. Do you know how I can remove the cache data setting? I did a
> search for rdl.data files on the server and it couldn't find any.
You're welcome. Thanks for posting your resolution; that might help
someone in the future with a similar situation.
Regards,
Enrique Martinez
Sr. Software Consultant
getting this error. It seems random and occurs even if a report has
just been run with the same criteria. Sometimes the error occurs a
couple of times in a row and then it will run after that fine.
An error occurred during local report processing.
An unexpected error occurred in Report Processing.
Object reference not set to an instance of an object.On Dec 6, 6:12 pm, lachlan.h...@.gmail.com wrote:
> Occasionally when we are running reports in our web application we are
> getting this error. It seems random and occurs even if a report has
> just been run with the same criteria. Sometimes the error occurs a
> couple of times in a row and then it will run after that fine.
> An error occurred during local report processing.
> An unexpected error occurred in Report Processing.
> Object reference not set to an instance of an object.
Sounds like on occasion there is an issue with the cached data for the
report. If you are caching the report data, I would suggest removing
the cache data setting. Also, you might want to delete the rdl.data
file in the interim. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||On Dec 7, 12:18 pm, EMartinez <emartinez...@.gmail.com> wrote:
> On Dec 6, 6:12 pm, lachlan.h...@.gmail.com wrote:
> > Occasionally when we are running reports in our web application we are
> > getting this error. It seems random and occurs even if a report has
> > just been run with the same criteria. Sometimes the error occurs a
> > couple of times in a row and then it will run after that fine.
> > An error occurred during local report processing.
> > An unexpected error occurred in Report Processing.
> > Object reference not set to an instance of an object.
> Sounds like on occasion there is an issue with the cached data for the
> report. If you are caching the report data, I would suggest removing
> the cache data setting. Also, you might want to delete the rdl.data
> file in the interim. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
Thanks Enrique. I was starting to suspect it was something to do with
caching. Do you know how I can remove the cache data setting? I did a
search for rdl.data files on the server and it couldn't find any.|||I've managed to fix it by stopping stopping the W3SVC (WWW Publisher
Service) and deleting all the files in
C:/Windows/Microsoft.NET/Framework/v2.0.50527/Temporary ASP.NET Files/|||On Dec 6, 7:56 pm, lachlan.h...@.gmail.com wrote:
> On Dec 7, 12:18 pm, EMartinez <emartinez...@.gmail.com> wrote:
>
> > On Dec 6, 6:12 pm, lachlan.h...@.gmail.com wrote:
> > > Occasionally when we are running reports in our web application we are
> > > getting this error. It seems random and occurs even if a report has
> > > just been run with the same criteria. Sometimes the error occurs a
> > > couple of times in a row and then it will run after that fine.
> > > An error occurred during local report processing.
> > > An unexpected error occurred in Report Processing.
> > > Object reference not set to an instance of an object.
> > Sounds like on occasion there is an issue with the cached data for the
> > report. If you are caching the report data, I would suggest removing
> > the cache data setting. Also, you might want to delete the rdl.data
> > file in the interim. Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
> Thanks Enrique. I was starting to suspect it was something to do with
> caching. Do you know how I can remove the cache data setting? I did a
> search for rdl.data files on the server and it couldn't find any.
You're welcome. Thanks for posting your resolution; that might help
someone in the future with a similar situation.
Regards,
Enrique Martinez
Sr. Software Consultant
An error has occurred while establishing a connection to the server
Hi I have just reinstalled .Net and SqlServer2005. I am running my application from local machine and sqlserver is also install local machine. but when I run application. Get follwing Error Message
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
What was the application trying to do when you got this message? It may be that the connection string is not correct, it may be that the server is setup for only windows authentication.
|||Hi
From your description, it seems that you met error when you are trying to connect to your SQLServer,right?
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
For this kind of issue, we should use the following steps to diagnose the problem.
First, you also should make sure that if 1433 port has been enabled on your server, which is the default port for SQLServer remote connections.
Generally, you can try the following ways to handle your problem.
1. Enable remote connections for SQL Server 2005 Express or SQL Server 2005 Developer Edition
2. Enable the SQL Server Browser service
3. Create exceptions in Windows Firewall
4. Create an exception for SQL Server 2005 in Windows Firewall
5. Create an exception for the SQL Server Browser service in Windows Firewall
More details for each step, you may see the following link:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277
Thanks.
Subscribe to:
Posts (Atom)