Analysis Services 2000 Tutorial

Has anyone tried the Quick Start tutorial?
I went through each of the steps and when I went to browse the data in the
Sales cube, I got the following error message:
Unable to browse the cube 'Sales'.
Unspecified error.
Has anyone else had this problem?
TIA
Try to apply service pack for Analysis Services. That works for me.
"Nimi" wrote:

> Has anyone tried the Quick Start tutorial?
> I went through each of the steps and when I went to browse the data in the
> Sales cube, I got the following error message:
> Unable to browse the cube 'Sales'.
> Unspecified error.
> Has anyone else had this problem?
> TIA

Analysis Services 2000 Tutorial

Has anyone tried the Quick Start tutorial?
I went through each of the steps and when I went to browse the data in the
Sales cube, I got the following error message:
Unable to browse the cube 'Sales'.
Unspecified error.
Has anyone else had this problem?
TIATry to apply service pack for Analysis Services. That works for me.
"Nimi" wrote:
> Has anyone tried the Quick Start tutorial?
> I went through each of the steps and when I went to browse the data in the
> Sales cube, I got the following error message:
> Unable to browse the cube 'Sales'.
> Unspecified error.
> Has anyone else had this problem?
> TIA

Analysis Services 2000 Tutorial

Has anyone tried the Quick Start tutorial?
I went through each of the steps and when I went to browse the data in the
Sales cube, I got the following error message:
Unable to browse the cube 'Sales'.
Unspecified error.
Has anyone else had this problem?
TIATry to apply service pack for Analysis Services. That works for me.
"Nimi" wrote:

> Has anyone tried the Quick Start tutorial?
> I went through each of the steps and when I went to browse the data in the
> Sales cube, I got the following error message:
> Unable to browse the cube 'Sales'.
> Unspecified error.
> Has anyone else had this problem?
> TIAsql

Analysis Services 2000 Error - OlapObjects

Good day

I'm having trouble registering an AS 2000 server. The following is the error I receive:

"The cube 'OlapObjects' does not exist, or it is not processed"

Both servers have Service Pack 4 installed.

What does this mean? Google is not much help either.

You might need to post the exact step you are performing. Registering a server in Analysis Manager does not try to access any cubes so this error does not make sense. And OlapObjects is the name of the table in the OLAP repository for AS2000, but you should NEVER access that directly.

Analysis Service is slowing down the server

Hi,

I am facing the following problem on SQL2K.

When I start the service the server slows down and users start complaining that generation of reports based on system (i.e. databases) that are hosted on the same server have REALLY slowed down... and thus I have to stop the service...

Can some please guide me regarding how to solve this problem and how I can be able to use the Analysis service.

Many thanks in advance for you kind help.Howdy

It would make sense to :

(1) Ensure the tables Analysis Services are querying have good indexes on them - use profiler & Index Tuner wizrd to check

(2) RUn the queries after hours to reduce competion on resources

(3) Check perfmon and see if the box is under powered for what you are trying to do

(4) Maybe find another server and copy the database to it & run analysis services on that - that way no-one will ever complain and it may be quicker for oyu.

Cheers,

SG.

analysis server

I am getting following deployment fail error when I try to deploy the
cube on the server:
"Error 1 The project could not be deployed to the
'myserver_2005'
server because of the following connectivity problems : A connection
cannot be made to redirector. Ensure that 'SQL Browser' service is
running. To verify or update the name of the target server, right-
click on the project in Solution Explorer, select Project Properties,
click on the Deployment tab, and then enter the name of the
server. 0
0 "
How do I start the analysis server so that I can deploy the cube? I
have already manually started the analysis server and browser is
running. How do I connect to the analysis server using SSMS? I am
getting an error when I use SSMS to connect to analysis server 'a
connection can not be made to the redirector. Make sure that 'sql
browser service' is running'. I made sure. Any ideas?On Sep 18, 10:54 am, SB <othell...@.yahoo.com> wrote:
> I am getting following deployment fail error when I try to deploy the
> cube on the server:
> "Error 1 The project could not be deployed to the
> 'myserver_2005'
> server because of the following connectivity problems : A connection
> cannot be made to redirector. Ensure that 'SQL Browser' service is
> running. To verify or update the name of the target server, right-
> click on the project in Solution Explorer, select Project Properties,
> click on the Deployment tab, and then enter the name of the
> server. 0
> 0 "
> How do I start the analysis server so that I can deploy the cube? I
> have already manually started the analysis server and browser is
> running. How do I connect to the analysis server using SSMS? I am
> getting an error when I use SSMS to connect to analysis server 'a
> connection can not be made to the redirector. Make sure that 'sql
> browser service' is running'. I made sure. Any ideas?
Okay this may be a bug. Can anyone please point me to a link how do I
fix this? I have already installed sp2.|||Why are you starting a new thread with a question you've already asked?
Look at my response to your original post.
ML
--
Matija Lah, SQL Server MVP
http://milambda.blogspot.com/

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?

Analysis Manager: Cannot connect to repository. Analysis Server: <server name>.

While trying to connect to a remote Analysis Server using Analysis Manager, I get the following error in a pop up window:

=================================================

Analysis Manager:

Cannot connect to repository.

Analysis Server: <server name>.

Error:

Provider cannot be found. It may not be properly installed.

=================================================

Can somebody help?

Thanks,

John T

Please try this:

- with Analysis Manager, right click on the server item (or the server name) and use "Edit Repository Connection String"

- there are 2 connection strings there: the local one (for the client running on the AS2000 server machine) and the remote one; from the error message, it seems that the remote one is improperly set

Adrian.

|||

Adrian, I checked th connection string. It matches the connection string on my other machine from which I can connect without any issues. Any thoughts?

John T

|||my problem was that i was using jet 3.5 not 4.0 there is a solution for creating a connection string here:
http://support.microsoft.com/?kbid=330244|||

Pete, A coworker of mine helped me figure this. I knew there was somethign wrong with the Jet engine on my machine but repeated attempts to fix the Jet did not seem to help. Finally we used Microsoft Access Driver (shown below) instead of the OLEDB JET

Driver={Microsoft Access Driver (*.mdb)};Dbq=\\<servername>\MsOLAPRepository$\msmdrep.mdb

Thank you for you help.

John T

Analysis Manager: Cannot connect to repository. Analysis Server: <server name>.

While trying to connect to a remote Analysis Server using Analysis Manager, I get the following error in a pop up window:

=================================================

Analysis Manager:

Cannot connect to repository.

Analysis Server: <server name>.

Error:

Provider cannot be found. It may not be properly installed.

=================================================

Can somebody help?

Thanks,

John T

Please try this:

- with Analysis Manager, right click on the server item (or the server name) and use "Edit Repository Connection String"

- there are 2 connection strings there: the local one (for the client running on the AS2000 server machine) and the remote one; from the error message, it seems that the remote one is improperly set

Adrian.

|||

Adrian, I checked th connection string. It matches the connection string on my other machine from which I can connect without any issues. Any thoughts?

John T

|||my problem was that i was using jet 3.5 not 4.0 there is a solution for creating a connection string here:
http://support.microsoft.com/?kbid=330244|||

Pete, A coworker of mine helped me figure this. I knew there was somethign wrong with the Jet engine on my machine but repeated attempts to fix the Jet did not seem to help. Finally we used Microsoft Access Driver (shown below) instead of the OLEDB JET

Driver={Microsoft Access Driver (*.mdb)};Dbq=\\<servername>\MsOLAPRepository$\msmdrep.mdb

Thank you for you help.

John T

Analysis Manager Error

I've been getting the following error message whenever I
try to connect to my remote server to work on some cubes.
"Cannot open connection to Analysis server 'WRPBI'
Error in data [possible data corruption]"
How can I fix it? I've reinstalled Analysis Manager but
it didn't help.
Thanks
Hi sacred,
You should apply SP3 for Analysis Services to the Analysis Services server.
If you are unable to upgrade the Analysis Services server to SP3, you can
also restore connectivity to the Analysis Server by replacing the
MSOLAP80.DLL,
MSOLAP80.RLL, MSMDGD80.DLL and MSMDCB80.DLL files on the client machine
with a
version equal to or less than the build number of your MSMDSRV.EXE
<><><><><><><><><><><><><><><><><><><><><><><><>
| Content-Class: urn:content-classes:message
| From: "sacred" <sacred21@.airpost.net>
| Sender: "sacred" <sacred21@.airpost.net>
| Subject: Analysis Manager Error
| Date: Wed, 29 Dec 2004 18:07:15 -0800
| Lines: 12
| Message-ID: <05dc01c4ee14$4852d080$a401280a@.phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Thread-Index: AcTuFEhSQNjxLD0AQgyujxk4ZUZu2w==
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Newsgroups: microsoft.public.sqlserver.clients
| Path: cpmsftngxa10.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.clients:29328
| NNTP-Posting-Host: tk2msftngxa12.phx.gbl 10.40.1.164
| X-Tomcat-NG: microsoft.public.sqlserver.clients
|
| I've been getting the following error message whenever I
| try to connect to my remote server to work on some cubes.
|
| "Cannot open connection to Analysis server 'WRPBI'
| Error in data [possible data corruption]"
|
| How can I fix it? I've reinstalled Analysis Manager but
| it didn't help.
|
| Thanks
|
|
|
<><><><><><><><><><><><><><><><><><><><><><><><>
Yasemin Gunduz
Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.

An 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.

An internal error occurred. [ ID = 3639 ] on delete query

Hi,

When I am trying to execute a delete query i'm getting the following error An internal error occurred. [ ID = 3639 ]. This is happening for some specific rows only. Other rows are getting deleted without any issues. Some 7 rows are there which i'm not able to delete. I am able to run update query on that rows. but not delete query

Pls help

Thanks

Nebu

This error does not look like a SQL CE error. Are you using SQL CE or SQL Server ?

Also, could you show us the statement and describe your environment, then others may be able to help you.

|||I'm using SQL CE.

delete from tabl1 where ID=1

We are using SLQ ce as a databse for a windows application. We use C# . Some times there will be insert and delete statements of more than 10000. I executed this statement for more than 10000 records, in that apart from 7 records every thing else got deleted. I'm not able to delete it even from SQL server management studio expresss.

tahnks

Nebu

|||Sounds like your sdf file has become corrupted. Try to run a Compact/Repair on the db. You can also try to send the sdf file to me, and I will have a look at it with SSMS.

|||

Hi Erik,

Thanks for the reply. I will not able to send you the sdf bcos of confidentiality. Can you please tell me how to run a reapir?

Thanks

Nebu

|||

Repair can be done from SSMS(E), right click the database, select Properties and the Shrink/Repair tab.

Also, the SqlCeEngine object has a Repair method.

|||Thanks Eirk.. It worked.. Do you have any idea why did it happen? Is it

because of the no of transactions?

Thanks

Nebu

An internal error occurred on the report server. See the error log for more details. (rsInternal

I've been sufferring from the following error for weeks:

An internal error occurred on the report server. See the error log for more details. (rsInternalError)

I'm accessing the reports through QueryString. Sometimes the reports work and sometimes not.

The content of the Reporting Services' log files are listed bellow:

(SQLDUMPER_ERRORLOG.log)

08/25/06 14:22:49, ERROR , SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () failed (00000514)
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 4012
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x14DB9AF4
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x00000000
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x00000000
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL>
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used
08/25/06 14:22:51, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
08/25/06 14:22:51, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:\Program Files\Microsoft SQL Server\MSSQL.6\Reporting Services\LogFiles\SQLDmpr0119.mdmp
08/25/06 14:22:51, ACTION, w3wp.exe, Watson Invoke: No

(SQLDmpr0118.log)

w3wp!library!8!8/25/2006-14:14:27:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., un-named assertion fired for component processing;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
w3wp!library!8!8/25/2006-14:14:59:: i INFO: Exception dumped to: C:\Program Files\Microsoft SQL Server\MSSQL.6\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
w3wp!library!9!8/25/2006-14:15:00:: i INFO: Call to RenderFirst( '/Reports/Report3' )
w3wp!processing!9!8/25/2006-14:15:00:: w WARN: The grouping expression for a category grouping returned a null value.
w3wp!library!1!8/25/2006-14:16:35:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!9!8/25/2006-14:16:35:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!5!25/8/2006-14:21:32:: i INFO: Call to RenderFirst( '/Reports/Report3' )
w3wp!processing!5!8/25/2006-14:21:32:: w WARN: The grouping expression for a category grouping returned a null value.
w3wp!processing!5!25/8/2006-14:21:32:: a ASSERT: Assertion failed! Call stack:
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.UpdateTimingInformation(RunningJobContext jobContext, Int64 totalDurationMs, Int64 reportDataRetrievalDurationMs, Int64 reportRenderingDurationMs)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(IRenderingExtension renderer, DateTime executionTimeStamp, GetReportChunk getCompiledDefinitionCallback, ProcessingContext pc, RenderingContext rc, CreateReportChunk cacheDataCallback, Boolean& dataCached)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(DateTime executionTimeStamp, GetReportChunk getCompiledDefinitionCallback, ProcessingContext pc, RenderingContext rc)
Microsoft.ReportingServices.Library.RSService.RenderAsLive(CatalogItemContext reportContext, ItemProperties properties, ParameterInfoCollection effectiveParameters, Guid reportId, ClientRequest session, String description, ReportSnapshot intermediateSnapshot, DataSourceInfoCollection thisReportDataSources, Boolean cachingRequested, Boolean isLinkedReport, Warning[]& warnings, ReportSnapshot& resultSnapshotData, DateTime& executionDateTime, RuntimeDataSourceInfoCollection& alldataSources, UserProfileState& usedUserProfile)
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters)
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService rs, CatalogItemContext reportContext, ClientRequest session, JobType type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
Microsoft.ReportingServices.Library.RenderReportAction.Render(String format, String deviceInfo)
Microsoft.ReportingServices.WebServer.ReportExecutionService.InternalRender(String Format, String DeviceInfo, Stream& Result, String& Extension, String& MimeType, String& Encoding, Warning[]& Warnings, String[]& StreamIds)
Microsoft.Reporting.WebForms.ServerReport.InternalRender(String format, String deviceInfo, String& extension, String& mimeType, String& encoding, String[]& streams, Warning[]& warnings)
Microsoft.Reporting.WebForms.ServerReport.Render(String format, String deviceInfo, NameValueCollection additionalParams, String& mimeType, String& extension)
Microsoft.Reporting.WebForms.ServerReportControlSource.RenderReport(String format, String deviceInfo, NameValueCollection additionalParams, String& mimeType, String& fileExtension)
Microsoft.Reporting.WebForms.ReportControlSource.RenderReportHTML4(String deviceInfo)
Microsoft.Reporting.WebForms.ReportControl.RenderReport(ReportControlSource controlSource, String instanceIdentifier, String navigationID, ZoomMode zoomMode, Int32 zoomPercent, Int32 pageNumber, String prefix, String searchText, String linkTarget, String replacementRoot, String alertMessage, Boolean enableFindNext, Boolean sizeToContent)
Microsoft.Reporting.WebForms.ReportAreaPage.OnPreRender(EventArgs e)
System.Web.UI.Control.PreRenderRecursiveInternal()
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
System.Web.UI.Page.ProcessRequest()
System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
System.Web.UI.Page.ProcessRequest(HttpContext context)
System.Web.HttpServerUtility.ExecuteInternal(IHttpHandler handler, TextWriter writer, Boolean preserveForm, Boolean setPreviousPage, VirtualPath path, VirtualPath filePath, String physPath, Exception error, String queryStringOverride)
System.Web.HttpServerUtility.Transfer(IHttpHandler handler, Boolean preserveForm)
Microsoft.Reporting.WebForms.ReportAreaPageOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response)
Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context)
System.Web.HttpApplication+CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
System.Web.HttpApplication.ResumeSteps(Exception error)
System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr)
System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)

w3wp!library!5!25/8/2006-14:21:32:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., un-named assertion fired for component processing;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.

I've reinstalled the SQL Server 2005 and the SP1 trying to solve this problem but it didn't work.

Is there anyone who can help me?

Thanks since now

Jo?o Talles Dantas Batista
jtdbf@.hotmail.com

Did you ever get a solution? We're seeing the same error re: "AdjustTokenPrivileges"|||

Not yet.
I've installed the SP1 and the HotFix2153. Even after this, I still have the same error.
It's very strange because the Microsoft's support asked me to do it, but it didn't work.
Have you tried anything different?

Jo?o Talles Dantas Batista

An internal error occurred on the report server. See the error log for more details. (rsInte

I've been sufferring from the following error for weeks:

An internal error occurred on the report server. See the error log for more details. (rsInternalError)

I'm accessing the reports through QueryString. Sometimes the reports work and sometimes not.

The content of the Reporting Services' log files are listed bellow:

(SQLDUMPER_ERRORLOG.log)

08/25/06 14:22:49, ERROR , SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () failed (00000514)
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 4012
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x14DB9AF4
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x00000000
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x00000000
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL>
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used
08/25/06 14:22:51, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
08/25/06 14:22:51, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:\Program Files\Microsoft SQL Server\MSSQL.6\Reporting Services\LogFiles\SQLDmpr0119.mdmp
08/25/06 14:22:51, ACTION, w3wp.exe, Watson Invoke: No

(SQLDmpr0118.log)

w3wp!library!8!8/25/2006-14:14:27:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., un-named assertion fired for component processing;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
w3wp!library!8!8/25/2006-14:14:59:: i INFO: Exception dumped to: C:\Program Files\Microsoft SQL Server\MSSQL.6\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
w3wp!library!9!8/25/2006-14:15:00:: i INFO: Call to RenderFirst( '/Reports/Report3' )
w3wp!processing!9!8/25/2006-14:15:00:: w WARN: The grouping expression for a category grouping returned a null value.
w3wp!library!1!8/25/2006-14:16:35:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!9!8/25/2006-14:16:35:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!5!25/8/2006-14:21:32:: i INFO: Call to RenderFirst( '/Reports/Report3' )
w3wp!processing!5!8/25/2006-14:21:32:: w WARN: The grouping expression for a category grouping returned a null value.
w3wp!processing!5!25/8/2006-14:21:32:: a ASSERT: Assertion failed! Call stack:
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.UpdateTimingInformation(RunningJobContext jobContext, Int64 totalDurationMs, Int64 reportDataRetrievalDurationMs, Int64 reportRenderingDurationMs)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(IRenderingExtension renderer, DateTime executionTimeStamp, GetReportChunk getCompiledDefinitionCallback, ProcessingContext pc, RenderingContext rc, CreateReportChunk cacheDataCallback, Boolean& dataCached)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(DateTime executionTimeStamp, GetReportChunk getCompiledDefinitionCallback, ProcessingContext pc, RenderingContext rc)
Microsoft.ReportingServices.Library.RSService.RenderAsLive(CatalogItemContext reportContext, ItemProperties properties, ParameterInfoCollection effectiveParameters, Guid reportId, ClientRequest session, String description, ReportSnapshot intermediateSnapshot, DataSourceInfoCollection thisReportDataSources, Boolean cachingRequested, Boolean isLinkedReport, Warning[]& warnings, ReportSnapshot& resultSnapshotData, DateTime& executionDateTime, RuntimeDataSourceInfoCollection& alldataSources, UserProfileState& usedUserProfile)
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters)
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService rs, CatalogItemContext reportContext, ClientRequest session, JobType type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
Microsoft.ReportingServices.Library.RenderReportAction.Render(String format, String deviceInfo)
Microsoft.ReportingServices.WebServer.ReportExecutionService.InternalRender(String Format, String DeviceInfo, Stream& Result, String& Extension, String& MimeType, String& Encoding, Warning[]& Warnings, String[]& StreamIds)
Microsoft.Reporting.WebForms.ServerReport.InternalRender(String format, String deviceInfo, String& extension, String& mimeType, String& encoding, String[]& streams, Warning[]& warnings)
Microsoft.Reporting.WebForms.ServerReport.Render(String format, String deviceInfo, NameValueCollection additionalParams, String& mimeType, String& extension)
Microsoft.Reporting.WebForms.ServerReportControlSource.RenderReport(String format, String deviceInfo, NameValueCollection additionalParams, String& mimeType, String& fileExtension)
Microsoft.Reporting.WebForms.ReportControlSource.RenderReportHTML4(String deviceInfo)
Microsoft.Reporting.WebForms.ReportControl.RenderReport(ReportControlSource controlSource, String instanceIdentifier, String navigationID, ZoomMode zoomMode, Int32 zoomPercent, Int32 pageNumber, String prefix, String searchText, String linkTarget, String replacementRoot, String alertMessage, Boolean enableFindNext, Boolean sizeToContent)
Microsoft.Reporting.WebForms.ReportAreaPage.OnPreRender(EventArgs e)
System.Web.UI.Control.PreRenderRecursiveInternal()
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
System.Web.UI.Page.ProcessRequest()
System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
System.Web.UI.Page.ProcessRequest(HttpContext context)
System.Web.HttpServerUtility.ExecuteInternal(IHttpHandler handler, TextWriter writer, Boolean preserveForm, Boolean setPreviousPage, VirtualPath path, VirtualPath filePath, String physPath, Exception error, String queryStringOverride)
System.Web.HttpServerUtility.Transfer(IHttpHandler handler, Boolean preserveForm)
Microsoft.Reporting.WebForms.ReportAreaPageOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response)
Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context)
System.Web.HttpApplication+CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
System.Web.HttpApplication.ResumeSteps(Exception error)
System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr)
System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)

w3wp!library!5!25/8/2006-14:21:32:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., un-named assertion fired for component processing;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.

I've reinstalled the SQL Server 2005 and the SP1 trying to solve this problem but it didn't work.

Is there anyone who can help me?

Thanks since now

Jo?o Talles Dantas Batista
jtdbf@.hotmail.com

Did you ever get a solution? We're seeing the same error re: "AdjustTokenPrivileges"|||

Not yet.
I've installed the SP1 and the HotFix2153. Even after this, I still have the same error.
It's very strange because the Microsoft's support asked me to do it, but it didn't work.
Have you tried anything different?

Jo?o Talles Dantas Batista

An interesting Qn

Hi,
My table has the following structure
create table CompanyRights (
CompanyID int, RightID int )
Insert into CompanyRights select 1,1
Insert into CompanyRights select 1,2
Insert into CompanyRights select 1,3
Insert into CompanyRights select 2,1
Insert into CompanyRights select 2,1
and i want to choose all the companies having rights 1 and 2
select * from CompanyRights where CompanyID = 1 And RightID = 1 AND RightID
= 2
but this didn't work
Regards
LaraIs it possible without a join
With Join I have the answer
SELECT t1.CompanyID,T1.RightID
FROM CompanyRights t1
INNER join CompanyRights t2
ON t1.CompanyID =t2.CompanyID
WHERE t1.RightID = 1 AND t2.RightID = 2
regards Lara|||select * from CompanyRights where CompanyID = 1 And RightID = 1 AND RightID
= 2
The key RightID cant be 1 AND 2 at the same time, this must be
select * from CompanyRights where CompanyID = 1 And (RightID = 1 OR RightID
= 2)
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Lara" <aneeshattingal@.hotpop.com> schrieb im Newsbeitrag
news:O$6pQLaSFHA.248@.TK2MSFTNGP15.phx.gbl...
> Is it possible without a join
> With Join I have the answer
> SELECT t1.CompanyID,T1.RightID
> FROM CompanyRights t1
> INNER join CompanyRights t2
> ON t1.CompanyID =t2.CompanyID
> WHERE t1.RightID = 1 AND t2.RightID = 2
> regards Lara
>
>|||Sure,
Select * From CompanyRights
Where RightID In (1,2)
-- which is same as
Select * From CompanyRights
Where RightID = 1 Or RightID = 2
"Lara" wrote:

> Is it possible without a join
> With Join I have the answer
> SELECT t1.CompanyID,T1.RightID
> FROM CompanyRights t1
> INNER join CompanyRights t2
> ON t1.CompanyID =t2.CompanyID
> WHERE t1.RightID = 1 AND t2.RightID = 2
> regards Lara
>
>|||Try,
SELECT
CompanyID
FROM
CompanyRights
WHERE
RightID = 1
or RightID = 2
group by
CompanyID
having
count(distinct RightID) = 2;
Relational Division
http://www.dbazine.com/ofinterest/o...br />
division
AMB
"Lara" wrote:

> Is it possible without a join
> With Join I have the answer
> SELECT t1.CompanyID,T1.RightID
> FROM CompanyRights t1
> INNER join CompanyRights t2
> ON t1.CompanyID =t2.CompanyID
> WHERE t1.RightID = 1 AND t2.RightID = 2
> regards Lara
>
>|||Select Distinct CompanyID
From CompanyRights R
Where Exists
(Select * From CompanyRights
Where CompanyID = R.CompanyID
And RightID = 1)
And Exists
(Select * From CompanyRights
Where CompanyID = R.CompanyID
And RightID = 2)
"Lara" wrote:

> Hi,
> My table has the following structure
> create table CompanyRights (
> CompanyID int, RightID int )
> Insert into CompanyRights select 1,1
> Insert into CompanyRights select 1,2
> Insert into CompanyRights select 1,3
> Insert into CompanyRights select 2,1
> Insert into CompanyRights select 2,1
> and i want to choose all the companies having rights 1 and 2
> select * from CompanyRights where CompanyID = 1 And RightID = 1 AND Right
ID
> = 2
> but this didn't work
> Regards
> Lara
>
>

An instance of the SQL Server Reconciler error object cannot be created

I've got the following server configuration.

Database Server

- Windows 2003 Standard

- MSSQL 2000 sp4

Web Server

- Windows 2003 Standard

- SQL 2000 sp4 replication components

- SQL Mobile 2005 Server tools

The database server published out the snapshot to a share on the web server. This bit is working file, I can see the snapshot contents etc. When I connect from my own pc using SQL Management Studio and attempt to set up a subscription to a Mobile database, I get the following error.

TITLE: Microsoft SQL Server Management Studio

An instance of the SQL Server Reconciler error object cannot be created. Try reinstalling the replication components.
HRESULT 0x8007007E (28010)

BUTTONS:

OK

I've also accessed the Url using diagnostics and get the following output:

 SQL Server Mobile Server Agent Diagnostics

 2006/01/13 10:09:10

*General Information*Item Value
Server Name bundy
URL /services/taskmobileserversync/sqlcesa30.dll
Authentication Type Anonymous
Server Port 80
HTTPS off
Server Software Microsoft-IIS/6.0
Replication Allowed
RDA Allowed
Logging Level 1

*Impersonation and Access Tests* Action Status ErrorCode
Impersonate User SUCCESS 0x0
ReadWriteDeleteMessageFile SUCCESS 0x0

*SQL Server Mobile Modules Test*Module Status ErrorCode Version
SQLCERP30.DLL SUCCESS 0x0 3.0.5206.0
SQLCESA30.DLL SUCCESS 0x0 3.0.5206.0

*Reconciler Test* Reconciler Status ErrorCode
9.0 Database Reconciler FAILURE 0x80040154
8.0 Database Reconciler FAILURE 0x8007007E

*SQL Server Module Versions* Module Version
sqloledb.dll 2000.85.1022.0
8.0 replrec.dll 2000.80.2038.0
8.0 replprov.dll 2000.80.2038.0
8.0 msgprox.dll 2000.80.2038.0

Any suggestions? I've reinstalled the various components on the Web Server quite a few times by now...

thanks

// charlie

Search for REPLERRX.DLL and register using regsvr32. And then try. If the registration fails for this DLL, just check whether you have all the dependant DLLs. There are tools to find out the dependant DLLs of a particular binary. Most probably you may need to have MSVCR71.DLL and MSVCP71.DLL. However these two DLLs are already packaged in the 'SQL Server 2000 SP4 Replication Components' setup package. There is some problem in the installation I believe. If you could register REPLERRX.DLL, then you should be able to sync.

Thanks,

Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation

|||To fix this, I installed the SQL Server 2000 client tools. This resolved the problem.|||

Thanks for letting us know the information.

Thanks,

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation

an insert

Hello,

I need to realize an insert something like the following:

Exec GetMyID @.tName, @.MyId OUTPUT

INSERT INTO MyTable2 (MyId,MyName)

SELECT @.MyId,MyName

FROM MyTable1

Here I am getting MyID from a stored procedure and I need to insert this to MyTable2, however I need to get a new MyID for each row in MyTable1. How can I do that?

I think you will have to do a loop here and do the EXEC for each loop.|||

You could try wrapping the stored procedure in a user defined function, then referencing it in your insert. So if the function was fn_NewKey, it'd be something like

Insert into MyTable2(MyID, MyName)

select fn_NewKey() as fred, MyName

from MyTable1

Incidentall, why don't you just use an identity column for MyID? It would be a lot easier.

|||I think you will have to do a loop here and do the EXEC for each loop.|||aaaaaaaaaaaa

an insert

Hello,

I need to realize an insert something like the following:

Exec GetMyID @.tName, @.MyId OUTPUT

INSERT INTOMyTable2 (MyId,MyName)

SELECT@.MyId,MyName

FROMMyTable1

Here I am getting MyID from a stored procedure and I need to insert this to MyTable2, however I need to get a new MyID for each row in MyTable1. How can I do that?

you could write a view which uses a cursor to step through all the names and inserts the names and the result of that proc into a table, and then insert that.

What does the proc do ? Where does the ID come from that you need to use the proc ?

|||Please don't go the route of using cursors or writing procedural code. SQL is a set-based language and you will get the best performance if you utilize it. What does the SP GetMyID do? Why can't you use IDENTITY column on the table to generate automatic sequential numbers? This is a much more efficient mechanism. You can get the multiple ids generated by SQL Server using OUTPUT clause in SQL Server 2005 or via a trigger that dumps the rows from inserted table in SQL Server 2000 or requery base-table using the alternate key values from the rows that you inserted.|||

I would concur that a cursor is a last resort, but I was assuming there was a reason that the proc needs to be called on a line by line basis ( hence my questions about the nature of hte proc also ).

I was also assuming he needs to do a single insert, not that this code is going to be run regularly. b/c if the insert needs to happen on an ongoing basis, it should happen as each record is created.

|||

GetMyID Return an Id which is unique. This is SQL 2000, can you give me an example of trigger. I am just trying to get a new id for each row in my table.

|||

It generates an ID ? Ideally, I would have an identity column in the first table, and just insert the ID from the first table into the second ( so the string is only in your database once, and you can change it there to see it change throughout the database ).

A trigger is a proc that is fired when you perform a specific action such as an insert into a specific table. The help has lots of info on how they work.

|||

Hi cgraus,

That is true it is an id, however it is not identity, the way that the system is designed it creates a specific id. Is there any trigger example you can give me to accomplish to call the stored procedure for each row inserted into MyTable2 meaning accomplishes the following for each row.

Exec GetMyID @.tName, @.MyId OUTPUT

INSERT INTO MyTable2 (MyId,MyName)

SELECT @.MyId,MyName

FROM MyTable1

|||

I guess you could do a trigger that runs when you insert a name in to MyTable2 ( I assume these names are contrived ), which calls the proc to generate the ID.

If an ID exists, why don't you store it in the table and use it throughout the system, regardless of where it comes from ?

http://www.codeproject.com/database/SquaredRomis.asp

Basically, the syntax is

CREATE TRIGGER invUpdate ON [Table2]
FOR INSERT

AS

...

Inside an insert trigger, the 'inserted' table will give you access to the items that were inserted. I am not sure if it's called once per line. If not, then a bulk insert leaves you with the same problem, but just within the trigger.

An inconsistency was detected during an internal operation

I am getting the following error:

Msg 5242, Level 22, State 1, Line 1

An inconsistency was detected during an internal operation in database 'Finance'(ID:5) on page (1:361249). Please contact technical support. Reference number 3.

It is caused by the following simple query:

"SELECT DISTINCT GainStd FROM vPriceParamStdDiscrete WHERE GainStd IS NOT NULL ORDER BY GainStd"

Could anyone offer any tip for fixing this problem?

Thanks in advance!

hz

DIdi you try to run DBCC CHECKDB for the appropiate database ?

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Thanks, Jens.

I should have done it, but I was so frustrated that I backed up the database, uninstalled and reinstalled the server (I need to do this anyway because my evaluation copy was expiring and I reinstalled a standard edition). Now, everything is fine.

hz

|||

That worked for me.

Weird. All of the sudden it started happening.

Aah!!! It is after all a Microsoft product. What else can you expect?

Thanks

Narayanan

|||When I use DBCC CHECKDB to check or repair (with REPAIR_REBUILD), I got An inconsistency was detected during an internal operation in database 'tempdb'

I can't set tempdb database as single user mode, so I can't repair it. What can I do?

An inconsistency was detected during an internal operation

I am getting the following error:

Msg 5242, Level 22, State 1, Line 1

An inconsistency was detected during an internal operation in database 'Finance'(ID:5) on page (1:361249). Please contact technical support. Reference number 3.

It is caused by the following simple query:

"SELECT DISTINCT GainStd FROM vPriceParamStdDiscrete WHERE GainStd IS NOT NULL ORDER BY GainStd"

Could anyone offer any tip for fixing this problem?

Thanks in advance!

hz

DIdi you try to run DBCC CHECKDB for the appropiate database ?

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Thanks, Jens.

I should have done it, but I was so frustrated that I backed up the database, uninstalled and reinstalled the server (I need to do this anyway because my evaluation copy was expiring and I reinstalled a standard edition). Now, everything is fine.

hz

|||

That worked for me.

Weird. All of the sudden it started happening.

Aah!!! It is after all a Microsoft product. What else can you expect?

Thanks

Narayanan

|||When I use DBCC CHECKDB to check or repair (with REPAIR_REBUILD), I got An inconsistency was detected during an internal operation in database 'tempdb'

I can't set tempdb database as single user mode, so I can't repair it. What can I do?