Sunday, February 26, 2012

Error1Dimension '...' : The following attribute(s) form loop(s):

Hello!

I have an error on a dimension, saying
"Error 1 Dimension 'Car Park Type' : The following attribute(s) form loop(s): [Car Park Type], [Car Park Key]. 0 0 "
but I do not have much idea of what it could mean.

This dimension is based on this request :
SELECT 'Inside' AS CarParkType, InsideCount AS CarParkCount, BuildingKey, OfferKey, TransactionKey, CarParkKey
FROM dimCarPark
WHERE (InsideCount > 0)
UNION
SELECT 'Outside' AS CarParkType, OutsideCount AS CarParkCount, BuildingKey, OfferKey, TransactionKey, CarParkKey + 100000 AS Expr1
FROM dimCarPark AS dimCarPark_3
WHERE (OutsideCount > 0)
UNION
SELECT 'Proximity' AS CarParkType, ProximityCount AS CarParkCount, BuildingKey, OfferKey, TransactionKey, CarParkKey + 200000 AS Expr1
FROM dimCarPark AS dimCarPark_2
WHERE (ProximityCount > 0)
UNION
SELECT 'Double' AS CarParkType, DoubleCount AS CarParkCount, BuildingKey, OfferKey, TransactionKey, CarParkKey + 300000 AS Expr1
FROM dimCarPark AS dimCarPark_1
WHERE (DoubleCount > 0)

Does anyone have any idea?

Thanks anyway.I have found. There was an error in the attributes of the dimension.

Bye!

error-1920.service mssqlserver failed

hi
i am trying to install a software package called arrayinformatics. this
comes along with msde as part of it.
when i run the setup for arrayinformatics, as admin, after sometime, the
status of the installshield wizard shows that...
generating script operations for action:......
and thats it..after that nothing happens and i get a dozen dll load
error...starting from...
REPLRES.RLL cannot load resource dll error..
run setup again to install this file...
after clicking ok for a dozen of such error...
the installshield wizard now says that...
error-1920. service mssqlserver failed to start. verify that you have
sufficient privileges to start system services...
and closes,without completing the installation.
i tried installing the msde separately..and it got installed.. and i was
even able to start and stop the services...
but the arrayinformatics doesnt install with a previously installed mssql
server...
so i am struck here...i tried to figure out this problem...searching the net
for the past 2 days and couldnt solve it...
kindly help me..to fix this problem
thanks
vijayaraj nagarajan
graduate student
the university of southern mississippi
MS - USA
hi,
vijayaraj nagarajan wrote:
> hi
> i am trying to install a software package called arrayinformatics.
> this comes along with msde as part of it.
> when i run the setup for arrayinformatics, as admin, after sometime,
> the status of the installshield wizard shows that...
> generating script operations for action:......
> and thats it..after that nothing happens and i get a dozen dll load
> error...starting from...
> REPLRES.RLL cannot load resource dll error..
> run setup again to install this file...
> after clicking ok for a dozen of such error...
> the installshield wizard now says that...
> error-1920. service mssqlserver failed to start. verify that you have
> sufficient privileges to start system services...
> and closes,without completing the installation.
> i tried installing the msde separately..and it got installed.. and i
> was even able to start and stop the services...
> but the arrayinformatics doesnt install with a previously installed
> mssql server...
> so i am struck here...i tried to figure out this problem...searching
> the net for the past 2 days and couldnt solve it...
if you separately succesfully installed MSDE with the official Microsoft
package, I think you have to check this issue with arrayinformatics
technicians... perhaps their installshield script is not correct...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

error18272

Hello guys, any help with this one. Am I the only one who have this problem?;-)
Try creating the directory that it's looking for as
indicated in the error message. In your case, it's looking
for the existence of the directory F:\MSDATA\backup
-Sue
On Wed, 12 May 2004 12:11:05 -0700, "dk"
<anonymous@.discussions.microsoft.com> wrote:

>Hello guys, any help with this one. Am I the only one who have this problem?;-)

error18272

Hello guys, any help with this one. Am I the only one who have this problem?
';-)Try creating the directory that it's looking for as
indicated in the error message. In your case, it's looking
for the existence of the directory F:\MSDATA\backup
-Sue
On Wed, 12 May 2004 12:11:05 -0700, "dk"
<anonymous@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Hello guys, any help with this one. Am I the only one who have this problem?;-)[/
vbcol]

Error18025:xp_test_mapi_profile failed with mail error0x80040111

Hi,

I configured the Sql server agent to start with local system and made a profile in intenet mail as SQLMail (Did not used Outlook or Excahnge Server used ar inbox on desktop (Windows messaging system) and internet mail, sendmail which we are having in house), When I tried to Configure SQL Mail for sql server and test , it is ginving the following error.

Error18025:xp_test_mail_profile failed with mail error 0x80040111

:mad:Hello,

i have the same Problemes, how you described it.

Did you start the mail Session?

Have a look on this:
USE master
EXEC xp_startmail

Please enter this brackets in Sql Query and start them.

My Problems already exists. I have problems in sending an e-mail if a error occurs by excuting jobs.

Bye
Harald Bothner|||Ok fellows...

There goes the answers to both of you.

1- Error18025:xp_test_mapi_profile failed with mail error0x80040111

The SQL Server relies in the MAPI libraries to send email messages. Unfortunately, it works at its best allied with Exchange, wich you seem to do not have. But it also works with a pop3 box, leaving the inconvenient need of requiring an Outlook open to get and send messages, and you would have to manage it manually.

Try to use Exchange. If you cant, try using CDONTS. Take a look at the link bellow:
http://support.microsoft.com/default.aspx?scid=kb;en-us;312839

2- mail problems by using sql server

It seems to me that you have not configured the SQL Mail Agent, wich is used by the SQL Server Agent to send notifications about alerts or job status etc.
Take a look at the properties of your SQL Server Agent and see if the email profile is set properly. If its not, just set it and then restart the SQL Server Agent and youre done.

Error-14262

I did rename my server and followed the steps.
sp_dropserver sp_addserver etc
But cannot make this server a target server
Error-14262 The specified msx does not exist 'any ideas
great people?.The other servers see the master server Ok
Thanks Michael>
> I did rename my server and followed the steps.
> sp_dropserver sp_addserver etc
> But cannot make this server a target server
> Error-14262 The specified msx does not exist 'any ideas
> great people?.The other servers see the master server Ok
>
> Thanks Michael
--
This could be a permissions problem. Start the SQL Server service on the
target server using a domain administrator account and see how you go.
Hope this helps,
Eric Crdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.|||"Eric Crdenas [MSFT]" <ecardena@.online.microsoft.com> wrote in message
news:ZFXu9dFTEHA.2160@.cpmsftngxa10.phx.gbl...
> --
> This could be a permissions problem. Start the SQL Server service on the
> target server using a domain administrator account and see how you go.
> Hope this helps,
> --
> Eric Crdenas
> Senior support professional
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>|||seen this issue before . Its because the originating_server field in the
msdb..sysjobs table stores the computername / instance of the server. So
when you renamed then it is now wrong
I would just update the column to reflect the new computername (After
backing up msdb)
cheers,
Andy Ball
"dimitris" <dantoniades@.mshf.com.au> wrote in message
news:OT9x3zFTEHA.2944@.tk2msftngp13.phx.gbl...
> "Eric Crdenas [MSFT]" <ecardena@.online.microsoft.com> wrote in messag
e
> news:ZFXu9dFTEHA.2160@.cpmsftngxa10.phx.gbl...
> rights.
>

Error-14262

I did rename my server and followed the steps.
sp_dropserver sp_addserver etc
But cannot make this server a target server
Error-14262 The specified msx does not exist 'any ideas
great people?.The other servers see the master server Ok
Thanks Michael>
> I did rename my server and followed the steps.
> sp_dropserver sp_addserver etc
> But cannot make this server a target server
> Error-14262 The specified msx does not exist 'any ideas
> great people?.The other servers see the master server Ok
>
> Thanks Michael
--
This could be a permissions problem. Start the SQL Server service on the
target server using a domain administrator account and see how you go.
Hope this helps,
--
Eric Cárdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.|||"Eric Cárdenas [MSFT]" <ecardena@.online.microsoft.com> wrote in message
news:ZFXu9dFTEHA.2160@.cpmsftngxa10.phx.gbl...
> >
> > I did rename my server and followed the steps.
> > sp_dropserver sp_addserver etc
> >
> > But cannot make this server a target server
> >
> > Error-14262 The specified msx does not exist 'any ideas
> > great people?.The other servers see the master server Ok
> >
> >
> > Thanks Michael
> --
> This could be a permissions problem. Start the SQL Server service on the
> target server using a domain administrator account and see how you go.
> Hope this helps,
> --
> Eric Cárdenas
> Senior support professional
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>|||seen this issue before . Its because the originating_server field in the
msdb..sysjobs table stores the computername / instance of the server. So
when you renamed then it is now wrong
I would just update the column to reflect the new computername (After
backing up msdb)
cheers,
Andy Ball
"dimitris" <dantoniades@.mshf.com.au> wrote in message
news:OT9x3zFTEHA.2944@.tk2msftngp13.phx.gbl...
> "Eric Cárdenas [MSFT]" <ecardena@.online.microsoft.com> wrote in message
> news:ZFXu9dFTEHA.2160@.cpmsftngxa10.phx.gbl...
> > >
> > > I did rename my server and followed the steps.
> > > sp_dropserver sp_addserver etc
> > >
> > > But cannot make this server a target server
> > >
> > > Error-14262 The specified msx does not exist 'any ideas
> > > great people?.The other servers see the master server Ok
> > >
> > >
> > > Thanks Michael
> > --
> > This could be a permissions problem. Start the SQL Server service on the
> > target server using a domain administrator account and see how you go.
> >
> > Hope this helps,
> >
> > --
> > Eric Cárdenas
> > Senior support professional
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
>

Error-14262

I did rename my server and followed the steps.
sp_dropserver sp_addserver etc
But cannot make this server a target server
Error-14262 The specified msx does not exist 'any ideas
great people?.The other servers see the master server Ok
Thanks Michael
>
> I did rename my server and followed the steps.
> sp_dropserver sp_addserver etc
> But cannot make this server a target server
> Error-14262 The specified msx does not exist 'any ideas
> great people?.The other servers see the master server Ok
>
> Thanks Michael
This could be a permissions problem. Start the SQL Server service on the
target server using a domain administrator account and see how you go.
Hope this helps,
Eric Crdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.
|||"Eric Crdenas [MSFT]" <ecardena@.online.microsoft.com> wrote in message
news:ZFXu9dFTEHA.2160@.cpmsftngxa10.phx.gbl...
> --
> This could be a permissions problem. Start the SQL Server service on the
> target server using a domain administrator account and see how you go.
> Hope this helps,
> --
> Eric Crdenas
> Senior support professional
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
|||seen this issue before . Its because the originating_server field in the
msdb..sysjobs table stores the computername / instance of the server. So
when you renamed then it is now wrong
I would just update the column to reflect the new computername (After
backing up msdb)
cheers,
Andy Ball
"dimitris" <dantoniades@.mshf.com.au> wrote in message
news:OT9x3zFTEHA.2944@.tk2msftngp13.phx.gbl...
> "Eric Crdenas [MSFT]" <ecardena@.online.microsoft.com> wrote in message
> news:ZFXu9dFTEHA.2160@.cpmsftngxa10.phx.gbl...
> rights.
>

Error-14010-remote server not defined as subscription server

Running SQL Server Personal Ed (Server A) on Tablet PC (publication and distribution setup here) trying to push data to SQL Server 2000 Enterprise Ed. (Server B). When I start sync I get two failures. First is 'remote server not defined as subscription server'. Second, subscription to publication xx not valid (error# -2147201019). The snapshot is succeeding fine. What do I need to setup on Server B? I have the same db on both servers.

Try with running sp_addsubscriber 'Server B' to see if it will be fixed.|||

I did run sp_add subscriber only to verify Server B already exists. A subscription shows up on server B; listed as never started.

I have not been able to succeed this task.

Server A db properties-replication tab-configure-subscribers tab-set agent connection to subscriber to impersonate-rerun PUSH suscription-response-login fail for anonymous logon.

How to setup both servers to accept anonymous logon?

|||

This issue has been resolved.

Security settings was the problem on both servers.

thx..bt

Error=cantconvertdata

Hi everyone!

When I try to process a cube via DTS or in a Terminal Server window I get the following error message:

DTSRun OnError: DTSStep_DTSOlapProcess.Task_1, Error = -2147221386 (80040076)
Error string: RECORD=1, _ERROR=CANTCONVERTDATA, COLUMN=30..

The cube runs on:
Win 2000 Advanced SP1 - MS SQL 2000 SP 1

We have found that it works when we keep a user with Admin privileges logged on locally on the server.
Well, it is the solution of the problem but it seems to be a bug anyway.

Has anyone got the same problem or maybe solved the problem another way?

Thanks for your replies

Jacek
:confused:Hello, Can you tell me please how I can solve this problem?? Because I have the same problem. THanks.
Yolanda

Hi everyone!

When I try to process a cube via DTS or in a Terminal Server window I get the following error message:

DTSRun OnError: DTSStep_DTSOlapProcess.Task_1, Error = -2147221386 (80040076)
Error string: RECORD=1, _ERROR=CANTCONVERTDATA, COLUMN=30..

The cube runs on:
Win 2000 Advanced SP1 - MS SQL 2000 SP 1

We have found that it works when we keep a user with Admin privileges logged on locally on the server.
Well, it is the solution of the problem but it seems to be a bug anyway.

Has anyone got the same problem or maybe solved the problem another way?

Thanks for your replies

Jacek
:confused:

Error{no row is was updated}

hey expert out ther..

i have encounter this error ..and i dont know what is the wrong with it..

the error goes:

No row was updated

Error source: .net SQLClient Data provider

Error Message:string or binary data would be trancated.

plz help me to slove this prob.

thanks in advance!!!!!!!

Could you please provide more information, code sample causing this error?

Thanks

|||

Ehm.......there was no code thats cause this error...

It was ok when i just add data in two rows...but once i input more than 2 rows..

this error will occur!!!!!

|||

Hi

I guess you mean, that you see this error, when you put in data in tht sql management programm to the opended database table.

I have the same errormessage. There are at about 8 tables and different relations, quite a small database. When I'm trying to change table properties and klick the save button the wizard shows me the other affected tables and tells me, that there could be errors with the rowguid column. And of course there are problems and changes to the table properties aren't able.

Besides I think, that also this rowguid column has something to do with the errormessage we get, because when entering a new row, no "uniqueidentifier" is generated in the specified column of rowguid.

I hope that now someone could help us.

best regards

Hannes

ERROR_STATE() Always = 0?

Below is the contents of a SPROC I have. I want to return the error
info in the catch block for it so I call RaiseError. But the
ERROR_STATE() always comes up as 0 which is ilegal since it must be
between 1-127 I guess. So I wrote a stupid if block to set it to 1 to
stop that error.

But I'd really rather not do this. Can anyone tell what's wrong? Why am
I not getting a correct return from ERROR_STATE()?

Thanx much:

BEGIN TRY
BEGIN TRANSACTION
DELETE FROM WebUser2Role WHERE WebUserID = @.WebUserID

INSERT INTO WebUser2Role
SELECT value, @.WebUserID FROM fIntList2Table(@.RoleIDList)
END TRY
BEGIN CATCH
DECLARE @.ErrorMessage NVARCHAR(4000)
DECLARE @.ErrorSeverity INT
DECLARE @.ErrorState INT

SELECT
@.ErrorMessage = ERROR_MESSAGE(),
@.ErrorSeverity = ERROR_SEVERITY(),
@.ErrorState = ERROR_STATE();

IF @.ErrorState = 0
BEGIN
SET @.ErrorState = 1
END

IF @.@.TRANCOUNT > 0
BEGIN
ROLLBACK TRANSACTION
END

RAISERROR (@.ErrorMessage, @.ErrorSeverity, @.ErrorState )

END CATCH

IF @.@.TRANCOUNT > 0
BEGIN
COMMIT TRANSACTION
ENDThe only thing I can think of which may help is that
Errors with a severity of 10 or lower are considered warnings or
informational messages, and are not handled by TRY.CATCH blocks.
therefore maybe it's not recognised as an error ?
--
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm

<wackyphill@.yahoo.com> wrote in message
news:1143771643.520517.319500@.e56g2000cwe.googlegr oups.com...
> Below is the contents of a SPROC I have. I want to return the error
> info in the catch block for it so I call RaiseError. But the
> ERROR_STATE() always comes up as 0 which is ilegal since it must be
> between 1-127 I guess. So I wrote a stupid if block to set it to 1 to
> stop that error.
> But I'd really rather not do this. Can anyone tell what's wrong? Why am
> I not getting a correct return from ERROR_STATE()?
> Thanx much:
>
>
> BEGIN TRY
> BEGIN TRANSACTION
> DELETE FROM WebUser2Role WHERE WebUserID = @.WebUserID
> INSERT INTO WebUser2Role
> SELECT value, @.WebUserID FROM fIntList2Table(@.RoleIDList)
> END TRY
> BEGIN CATCH
> DECLARE @.ErrorMessage NVARCHAR(4000)
> DECLARE @.ErrorSeverity INT
> DECLARE @.ErrorState INT
> SELECT
> @.ErrorMessage = ERROR_MESSAGE(),
> @.ErrorSeverity = ERROR_SEVERITY(),
> @.ErrorState = ERROR_STATE();
> IF @.ErrorState = 0
> BEGIN
> SET @.ErrorState = 1
> END
> IF @.@.TRANCOUNT > 0
> BEGIN
> ROLLBACK TRANSACTION
> END
> RAISERROR (@.ErrorMessage, @.ErrorSeverity, @.ErrorState )
> END CATCH
> IF @.@.TRANCOUNT > 0
> BEGIN
> COMMIT TRANSACTION
> END|||No it deffinately is going into the catch block.

But ERROR_STATE() in the catch block returns 0. This poses a problem
when I call RaiseError because 0 is not a valid state.

error_number() won't return error code

hi all,

i have sql statement in ExecuteSQLTask, connecting to AdventureWorks

BEGIN TRY
insert into person.contacts(contactid) values (1);
END TRY
BEGIN CATCH
SELECT ERROR_NUMBER() AS ErrorNumber;
END CATCH;

i purposely put a table that does not exist in the database to catch
the error. however, the error number that is 208 won't appear, instead
the whole error message will be displayed.

if i change the query in try block to
insert into person.contact(contactid) values (1);

it'll return the error number 544, which is correct.

what did i do wrong?
thanks!

You did nothing wrong.

Try/Catch doesn't catch all errors, specifically compile time errors (there are a few others). Try running the following, "more obvious" compile time error. This compile time error won't be caught either, since the execution of the statements never happens.

BEGIN TRY

PRINT 'Inside Try-Block'

'This is not sql'

END TRY

BEGIN CATCH

SELECT error_number() as 'Error In Try Block'

END CATCH

|||

thanks jaegd for your reply.. it didn't say in BOL that try/catch doesn't catch all errors or maybe i left that out.

anyhow, my problem is not solved. is there an alternative where i can catch any errors that occur?

|||See the following BOL reference for the constructs which Try/Catch does not trap.
http://msdn2.microsoft.com/en-us/library/ms175976.aspx

However, To catch almost every error (including compile time and deferred name resolution errors), you can use dynamic SQL in combination with sp_executesql.

BEGIN TRY
DECLARE @.not_sql NVARCHAR(100)
SET @.not_sql = 'This is not sql'
EXEC sp_executesql @.not_sql

END TRY
BEGIN CATCH
SELECT ERROR_NUMBER() AS ErrorNumber
END CATCH

Note that almost every error is caught with this method, because broken client connections are not

trapped, hopefully for relatively obvious reasons (you have no

connection).|||thanks a lot jaegd

error_line() not accurate?

Hello,

I'm just trying out this new try-catch stuff in sql server 2005....

Using the example from the help, "Using TRY... CATCH in Transact-SQL" , it shows how things are done in the adventure works database.. loggin the error to the errorlog table and all that... looks great.. but I notice that when I implement this code in my project.. and tested by putting in a line that causes a divide by zero error... that the line number reported by error_line is acutally not the line at which the divide by zero code resides....

Any suggestions as to what would put the error_line out of whack? I have comments and some string literals in the code..would they be throwing it?

Thanks

Try posting a sample here that others can recreate. That way we can address the issue specifically.

error_line() not accurate?

Hello,

I'm just trying out this new try-catch stuff in sql server 2005....

Using the example from the help, "Using TRY... CATCH in Transact-SQL" , it shows how things are done in the adventure works database.. loggin the error to the errorlog table and all that... looks great.. but I notice that when I implement this code in my project.. and tested by putting in a line that causes a divide by zero error... that the line number reported by error_line is acutally not the line at which the divide by zero code resides....

Any suggestions as to what would put the error_line out of whack? I have comments and some string literals in the code..would they be throwing it?

Thanks

Try posting a sample here that others can recreate. That way we can address the issue specifically.

ERROR_BROKER_CONVERSATIONS: practical example?

Hello,

I read that is there is this Database setting for service broker: ERROR_BROKER_CONVERSATIONS

I have not understood the how to use this setting in real scenario.

Could somebody provide me some practical example?

White papers are also ok! :-)

Thank you

Marina B.

The primary reason this option was introduced is for the scenarios when two databases that have conversations with each other and one of them has an incident and data loss occurs (it has to be restored back in time). Since the conversations between the two databases are now out of sync, the one that was restored back in time should ERROR_BROKER_CONVERSATIONS in order to error all existing conversations before enabling the broker. The application should be prepared to deal with the Error message anyway, and this is a quick way to send an Error message on all conversations. After this, the broker in the database is enabled and keeps the old broker instance (aka. service_broker_guid, thus all routes to it are still valid).

Error:User does not have permission to perfor this action.

I just installled the Visual web developer - express addition. When I try to add aSQL database to my project it gives the following error - "User does not have permission to perfor this action" . Can someone please help?

If this is a Visual Web Developer issue, then you should try posting on the following forums: http://forums.asp.net/.

Is there any other information provided besides the error message, like an error code? If you have no additional information, can you describe the steps that you followed before you encountered the error?

Thanks
Laurentiu

|||

This is what I am doing

I am adding a new item to my project by selecting <Add New Item>. I select the SQL Database. After clicking Ok for creating the database in <App_Data> folder, I get the above stated error.

I have a similar install on my home PC. I do not get any error. It seems that the permision on SQL express needs to be changed. I am nor sure how I mange the users on sql express? I have uninstalled and re-installed the Web Developer express version.

As you suggested I will try to post this issue on the asp.net forum.

Thanks for getting back to me.

|||

Here are some ideas on a what you might do to get more information on this:

- check whether you have access to the folder where you're attempting to create the database (also check that the account that SQL Server runs as has access)
- check the SQL Server errorlog to see if there are any errors logged there
- If you have SQL Server Profiler, connect it to the server, retry the operation and see if any errors appear in the trace

Unfortunately, it's not clear whether the message you receive is from Web Developer or SQL Server. SQL Server error messages are usually accompanied by an error number and an error state, but this information is not always shown by clients.

If you can isolate the issue as happening in SQL Server, let us know.

Thanks
Laurentiu

Error:Type Expected

I did create one simple program which is used to retrieve data from SQL Server Database into the DataGrid. Unfortunately,compilation stops at the position that 'Dim conn as SQLConnection'.The error is just same as the subject 'Type Expected'.

By the way, the default frameworkSDK from VS.NET version 1.0 lies different place from .NET1.1 I did install recently.If so, I wonder which FrameworkSDK will be used if I'm intending to compile ASP.NET Web Application.

Looking forward to your timely kind reply!At the top of your page with the code, are you importing the System.Data namespace?

Imports System.Data

Josh

Error:The type initializer for "Microsoft.ReportDesigner.Drawing.Language" threw an except

Hi,
I've been trying to get to the bottom of this error it prevents be
from loading the report in Design Mode. As of right now when opening
a report in design mode through the VS .Net 2003 IDE I get the
following:
Deserialization failed: The type initializer for
"Microsoft.ReportDesigner.Drawing.Language" threw an exception.
I've tried uninstall/reinstall, reporting services service pack 1 and
debuging the devenv.exe from another ide instance. Debug error is:
System.ComponentModel.Design.Serialization.CodeDomSerializerException:
Deserialization failed: The type initializer for
"Microsoft.ReportDesigner.Drawing.Language" threw an exception. -->
Microsoft.DataWarehouse.Serialization.XmlSerializationException:
Deserialization failed: The type initializer for
"Microsoft.ReportDesigner.Drawing.Language" threw an exception. -->
System.TypeInitializationException: The type initializer for
"Microsoft.ReportDesigner.Drawing.Language" threw an exception. -->
System.ArgumentException: Culture ID 31770 (0x7C1A) is not a supported
culture.
Parameter name: culture
at System.Globalization.CultureInfo..ctor(Int32 culture, Boolean
useUserOverride)
at System.Globalization.CultureTable.GetCultures(CultureTypes
types)
at Microsoft.ReportDesigner.Drawing.Language.GetStandardValues()
at Microsoft.ReportDesigner.Drawing.Language..cctor()
-- End of inner exception stack trace --
at Microsoft.ReportDesigner.Drawing.Language..ctor(String value)
at Microsoft.ReportDesigner.Drawing.LanguageConverter.CreateObject(String
value)
at Microsoft.ReportDesigner.Drawing.XmlStringListConverter.ConvertFrom(ITypeDescriptorContext
context, CultureInfo culture, Object value)
at System.ComponentModel.DefaultValueAttribute..ctor(Type type,
String value)
-- End of inner exception stack trace --
at Microsoft.ReportDesigner.Serialization.DesignXmlReader.ReadRoot(Type
type)
at Microsoft.ReportDesigner.Serialization.DesignXmlReader.DeserializeComponent(IDesignerSerializationManager
manager, XmlReader reader, Type root)
at Microsoft.ReportDesigner.Serialization.DesignXmlSerializer.DeserializeObject(IDesignerSerializationManager
manager, Object serializationStream)
at Microsoft.ReportDesigner.Serialization.DesignXmlSerializer.Deserialize(IDesignerSerializationManager
manager, Object serializationStream)
at Microsoft.DataWarehouse.VsIntegration.Designer.Serialization.DataWarehouseDesignerLoader.Deserialize()Hi, I got the same error here, if you already fixed this problem, please post
here waht is going on.
Thanks, Rafael
"Ricardo" wrote:
> Hi,
> I've been trying to get to the bottom of this error it prevents be
> from loading the report in Design Mode. As of right now when opening
> a report in design mode through the VS .Net 2003 IDE I get the
> following:
> Deserialization failed: The type initializer for
> "Microsoft.ReportDesigner.Drawing.Language" threw an exception.
> I've tried uninstall/reinstall, reporting services service pack 1 and
> debuging the devenv.exe from another ide instance. Debug error is:
> System.ComponentModel.Design.Serialization.CodeDomSerializerException:
> Deserialization failed: The type initializer for
> "Microsoft.ReportDesigner.Drawing.Language" threw an exception. -->
> Microsoft.DataWarehouse.Serialization.XmlSerializationException:
> Deserialization failed: The type initializer for
> "Microsoft.ReportDesigner.Drawing.Language" threw an exception. -->
> System.TypeInitializationException: The type initializer for
> "Microsoft.ReportDesigner.Drawing.Language" threw an exception. -->
> System.ArgumentException: Culture ID 31770 (0x7C1A) is not a supported
> culture.
> Parameter name: culture
> at System.Globalization.CultureInfo..ctor(Int32 culture, Boolean
> useUserOverride)
> at System.Globalization.CultureTable.GetCultures(CultureTypes
> types)
> at Microsoft.ReportDesigner.Drawing.Language.GetStandardValues()
> at Microsoft.ReportDesigner.Drawing.Language..cctor()
> -- End of inner exception stack trace --
> at Microsoft.ReportDesigner.Drawing.Language..ctor(String value)
> at Microsoft.ReportDesigner.Drawing.LanguageConverter.CreateObject(String
> value)
> at Microsoft.ReportDesigner.Drawing.XmlStringListConverter.ConvertFrom(ITypeDescriptorContext
> context, CultureInfo culture, Object value)
> at System.ComponentModel.DefaultValueAttribute..ctor(Type type,
> String value)
> -- End of inner exception stack trace --
> at Microsoft.ReportDesigner.Serialization.DesignXmlReader.ReadRoot(Type
> type)
> at Microsoft.ReportDesigner.Serialization.DesignXmlReader.DeserializeComponent(IDesignerSerializationManager
> manager, XmlReader reader, Type root)
> at Microsoft.ReportDesigner.Serialization.DesignXmlSerializer.DeserializeObject(IDesignerSerializationManager
> manager, Object serializationStream)
> at Microsoft.ReportDesigner.Serialization.DesignXmlSerializer.Deserialize(IDesignerSerializationManager
> manager, Object serializationStream)
> at Microsoft.DataWarehouse.VsIntegration.Designer.Serialization.DataWarehouseDesignerLoader.Deserialize()
>|||I have problem in Reporting Services 2005 with width of report - max. limit is probably 406,34921 cm. Is it possible to increase this limit to for exapmle 450 cm ?
From http://www.developmentnow.com/g/115_2004_11_0_0_453315/ErrorThe-type-initializer-for-Microsoft-ReportDesigner-Drawing-Language-threw-an-exception.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com

error:the string was not recognized as a valid DateTime.

hi all, i'm trying to insert the time/date a button was clicked on a gridview and it generates an error:the string was not recognized as a valid DateTime.There is an unknown word starting at index 0 i have changed the culture to en-US but it still doesn't work. i actually created the date/time column after some data had been entered into the table so the column allows nulls. this is my code:

InsertCommand="INSERT INTO test101(Surname,Names,Registration,Login Time)VALUES (@.Surname, @.Names, @.Registration,@.Login_Time)"

<Insert Parameters><asp:Parameter DefaultValue= DateTime.Now Type=DateTime Name="Login_Time" /></Insert Parameters
any suggestions?

When do you recieve that error? You mentioned button on a GridView, so I suppose that you're trying to update some values and, if that's the case, use this code:

protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
e.NewValues["Login_Time"] = DateTime.Now;
}

If, on the other hand, you're trying to insert some values in database, use this code (this is example for inserting values with DetailsView ):

protected void DetailsView1_ItemInserting(object sender, DetailsViewInsertEventArgs e)
{
e.Values["Login_Time"] = DateTime.Now;
}

|||

sorry, this message was supposed to be:

hi all, i'm trying to insert the time/date at the time a user clicks the submit button but it generates an error:the string was not recognized as a valid DateTime.There is an unknown word starting at index 0 i have changed the culture to en-US but it still doesn't work. this is my code:

InsertCommand="INSERT INTO test101(Surname,Names,Registration,Login Time)VALUES (@.Surname, @.Names, @.Registration,@.Login_Time)"

<Insert Parameters><asp:Parameter DefaultValue= DateTime.Now Type=DateTime Name="Login_Time" /></Insert Parameters
any suggestions?

|||

Where is that submit button (in DetailsView or in FormView)?

|||

it's on a login page. so i want the time the user logged on to be saved on a database

|||

Can you post your whole code?

|||

One way to achieve your goal is to change your InsertParameter into this:

<Insert Parameters><asp:Parameter Type="DateTime" Name="Login_Time" /></Insert Parameters>

and put this in Page_Load event:

SqlDataSource1.InsertParameters["Login_Time"].DefaultValue = DateTime.Now.ToString();

|||<asp:ButtonID="login1"runat="server"Text="Login"

Height="31px"OnClick="login1_Click"Width="65px"BackColor="#E0E0E0"Font-Size="Medium"/>

<asp:ButtonID="Reset1"runat="server"BackColor="#E0E0E0"Font-Size="Medium"

Height="32px"OnClick="Reset1_Click"Text="Reset"Width="63px"/>

<br/>

<br/>

<asp:SqlDataSourceID="SqlDataSource1"runat="server"

ConnectionString="<%$ ConnectionStrings:engineeringConnectionString %>"

InsertCommand="INSERT INTO test101(Surname,Names,Registration,[Course code],[Login Time]) VALUES (@.Surname,@.Names,@.Registration,@.Course_code,@.Login_Time)">

<InsertParameters>

<asp:ControlParameterControlID="TextBox1"DefaultValue="Textbox1.Text"Name="Surname"

PropertyName="Text"/>

<asp:ControlParameterControlID="TextBox2"DefaultValue="TextBox2.Text"Name="Names"

PropertyName="Text"/>

<asp:ControlParameterControlID="TextBox3"DefaultValue="TextBox3.Text"Name="Registration"

PropertyName="Text"/>

<asp:ControlParameterControlID="TextBox4"DefaultValue="TextBox4.Text"Name="Course_code"

PropertyName="Text"/>

<asp:Parameter Name="Login_Time" type=DateTime/>

</InsertParameters>

</asp:SqlDataSource>

<asp:GridViewID="GridView1"

runat="server"AutoGenerateColumns="False"AutoGenerateDeleteButton="True"DataKeyNames="ID"

AutoGenerateEditButton="True"AllowSorting="True"BackColor="LightGoldenrodYellow"BorderColor="Tan"BorderWidth="1px"CellPadding="2"ForeColor="Black"GridLines="None"PageSize="20"

Height="374px"EmptyDataText="null"DataSourceID=SqlDataSource1Visible="False"AllowPaging="True">

<Columns>

<asp:BoundFieldDataField="ID"HeaderText="ID"InsertVisible="False"ReadOnly="True"

SortExpression="ID"/>

<asp:BoundFieldDataField="Surname"HeaderText="Surname"SortExpression="Surname"/>

<asp:BoundFieldDataField="Names"HeaderText="Names"SortExpression="Names"/>

<asp:BoundFieldDataField="Registration"HeaderText="Registration"SortExpression="Registration"/>

<asp:BoundFieldDataField="Course code"HeaderText="Course code"SortExpression="Course code"/>

<asp:BoundFieldDataField="Grade"HeaderText="Grade"SortExpression="Grade"/>

<asp:BoundFieldDataField="login Time"HeaderText="Login Time"SortExpression="login Time"/>

</Columns>

</asp:GridView>

and this is the code behind:

protectedvoid Page_Load(object sender,EventArgs e)

{

SqlConnection conn =newSqlConnection("Data Source=(local);Initial Catalog=engineering; Integrated Security=True");

conn.Open();

GridView1.DataBind();

conn.Close();

}

publicvoid login1_Click(object sender,EventArgs e)

{

SqlDataSource1.Insert();

if (TextBox1.Text !="" && TextBox2.Text !="" && TextBox3.Text !="" && TextBox4.Text !="")

{

Response.Redirect("test1.aspx");

}

|||

Just add SqlDataSource1.InsertParameters["Login_Time"].DefaultValue = DateTime.Now.ToString(); in login1_Click event like this:

public void login1_Click(object sender, EventArgs e)
{
SqlDataSource1.InsertParameters["Login_Time"].DefaultValue = DateTime.Now.ToString();
SqlDataSource1.Insert();
if (TextBox1.Text != "" && TextBox2.Text != "" && TextBox3.Text != "" && TextBox4.Text !="")
{
Response.Redirect("test1.aspx");
}

And one question: Why are you opening connection in Page_Load event?:

SqlConnection conn = new SqlConnection("Data Source=(local);Initial Catalog=engineering; Integrated Security=True");
conn.Open();
GridView1.DataBind();
conn.Close();

If you're using SqlDataSource this is unnecessarily.

|||

THANK YOU SO MUCH!!!!!

Error:The precision must be between 1 and 38.

Hi All

I am trying to pull data from Oracle to SQL Server but if I use Oledb Source than I get this error

Error at Data Flow Task [DTS.Pipeline]: The "output column "CUST_ID" (590)" has a precision that is not valid. The precision must be between 1 and 38.


ADDITIONAL INFORMATION:

Exception from HRESULT: 0xC0204018 (Microsoft.SqlServer.DTSPipelineWrap)


The only solution I found is use DataReader Source,

But if I use DataReader Source everything works fine , I mean I am able to see the records and convert it desired data type (using Data Convertion component).

My question is what component should I use as Destination, coz if I use OLEDB Desination I get a red cross on the components although I can map all the columns.....

I believe you need to convert that column to have a precision of 1 or greater in the query that you use to get at the data. Search this forum for examples. You're not the first with this issue.|||

I fixed the error which I was getting with DataReader Source. Everthing is Ok at design time but I get this error at the source at runtime:

[DataReader Source [1]] Error: System.Data.OleDb.OleDbException: Oracle error occurred, but error message could not be retrieved from Oracle.
at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo,
DbConnectionPool pool, DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection

owningConnection, DbConnectionPoolGroup poolGroup) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.OleDb.OleDbConnection.Open() at Microsoft.SqlServer.Dts.Runtime.ManagedHelper.GetManagedConnection(String assemblyQualifiedName,
String connStr, Object transaction) at Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSConnectionManager90.AcquireConnection(Object pTransaction)
at Microsoft.SqlServer.Dts.Pipeline.DataReaderSourceAdapter.AcquireConnections(Object transaction)
at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostAcquireConnections(IDTSManagedComponentWrapper90 wrapper, Object transaction)

|||Try your query in SQL*Plus or some other Oracle client to see if it errors out there as well.|||

I've dealt a lot with this error. So far I've found two solutions:

1) Cast column to NUMBER(precision, scale) in Oracle select (eg. select CAST(columnName as NUMBER(10, 3)) as columName from ..

2) Cast to string in Oracle select (eg. select TO_CHAR(columnName) as columName from ..

For more info, check out this thread: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1432727&SiteID=1

Another common problem when selecting from Oracle is getting the error "accessor is not a parameter accessor", which you get when precision from a calculation in the select exceeds 38. For example when you divide two columns. ADO can not handle the same amount of precision that the Oracle select can handle. Anyway, to overcome this problem you cast the column (or expression (division)) to char (TO_CHAR(....)) and then you specify precision and scale (preferred) when you do the insert or substring the result to fit the target column.

Code (VB.NET): Dim para5 As New OleDb.OleDbParameter("myParamName", OleDb.OleDbType.Numeric)
para5.Value = myReader.Item("myColumn")
para5.Scale = CByte(10)
para5.Precision = CByte(22)

More about accessor is not a parameter accessor (only one google hit, and is cached):

http://www.google.com/search?q=cache:ZVTf6GErxyIJ:www.dotnetforums.com/archive/index.php/t-398.html+Conversion+failed+because+the+Decimal+data+value+overflowed+the+type+specified+for+the+Decimal+value+part+in+the+consumer's+buffer.&hl=sv&strip=1

|||

I don't know what's wrong , this is driving me crazy....this package was working fine till last week n now it is giving error

[Source-AP [1]] Error: The AcquireConnection method call to the connection manager "MS_OLEDB" failed with error code 0xC0202009.
[DTS.Pipeline] Error: component "Source-AP" (1) failed validation and returned error code 0xC020801C.

I am able to see the data preview and column mapping etc

Error:The precision must be between 1 and 38.

Hi All

I am trying to pull data from Oracle to SQL Server but if I use Oledb Source than I get this error

Error at Data Flow Task [DTS.Pipeline]: The "output column "CUST_ID" (590)" has a precision that is not valid. The precision must be between 1 and 38.


ADDITIONAL INFORMATION:

Exception from HRESULT: 0xC0204018 (Microsoft.SqlServer.DTSPipelineWrap)


The only solution I found is use DataReader Source,

But if I use DataReader Source everything works fine , I mean I am able to see the records and convert it desired data type (using Data Convertion component).

My question is what component should I use as Destination, coz if I use OLEDB Desination I get a red cross on the components although I can map all the columns.....

I believe you need to convert that column to have a precision of 1 or greater in the query that you use to get at the data. Search this forum for examples. You're not the first with this issue.|||

I fixed the error which I was getting with DataReader Source. Everthing is Ok at design time but I get this error at the source at runtime:

[DataReader Source [1]] Error: System.Data.OleDb.OleDbException: Oracle error occurred, but error message could not be retrieved from Oracle.
at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo,
DbConnectionPool pool, DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection

owningConnection, DbConnectionPoolGroup poolGroup) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.OleDb.OleDbConnection.Open() at Microsoft.SqlServer.Dts.Runtime.ManagedHelper.GetManagedConnection(String assemblyQualifiedName,
String connStr, Object transaction) at Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSConnectionManager90.AcquireConnection(Object pTransaction)
at Microsoft.SqlServer.Dts.Pipeline.DataReaderSourceAdapter.AcquireConnections(Object transaction)
at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostAcquireConnections(IDTSManagedComponentWrapper90 wrapper, Object transaction)

|||Try your query in SQL*Plus or some other Oracle client to see if it errors out there as well.|||

I've dealt a lot with this error. So far I've found two solutions:

1) Cast column to NUMBER(precision, scale) in Oracle select (eg. select CAST(columnName as NUMBER(10, 3)) as columName from ..

2) Cast to string in Oracle select (eg. select TO_CHAR(columnName) as columName from ..

For more info, check out this thread: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1432727&SiteID=1

Another common problem when selecting from Oracle is getting the error "accessor is not a parameter accessor", which you get when precision from a calculation in the select exceeds 38. For example when you divide two columns. ADO can not handle the same amount of precision that the Oracle select can handle. Anyway, to overcome this problem you cast the column (or expression (division)) to char (TO_CHAR(....)) and then you specify precision and scale (preferred) when you do the insert or substring the result to fit the target column.

Code (VB.NET): Dim para5 As New OleDb.OleDbParameter("myParamName", OleDb.OleDbType.Numeric)
para5.Value = myReader.Item("myColumn")
para5.Scale = CByte(10)
para5.Precision = CByte(22)

More about accessor is not a parameter accessor (only one google hit, and is cached):

http://www.google.com/search?q=cache:ZVTf6GErxyIJ:www.dotnetforums.com/archive/index.php/t-398.html+Conversion+failed+because+the+Decimal+data+value+overflowed+the+type+specified+for+the+Decimal+value+part+in+the+consumer's+buffer.&hl=sv&strip=1

|||

I don't know what's wrong , this is driving me crazy....this package was working fine till last week n now it is giving error

[Source-AP [1]] Error: The AcquireConnection method call to the connection manager "MS_OLEDB" failed with error code 0xC0202009.
[DTS.Pipeline] Error: component "Source-AP" (1) failed validation and returned error code 0xC020801C.

I am able to see the data preview and column mapping etc

Error:SqlConnection does not support parallel transactions"

This is my code in vb.net with Sql transaction
I am using insertcommand and update command for executing the sqlquery
in consecutive transactions as follows.
How can I achive parallel transactions in sql
------start of code-------
try
bID = Convert.ToInt32(Session("batchID"))
strSQL = ""
strSQL = "Insert into sessiondelayed (batchid,ActualEndDate) values (" & bID & ",'" & Format(d1, "MM/dd/yyyy") & "')"

sqlCon = New System.Data.SqlClient.SqlConnection(ConfigurationSettings.AppSettings("conString"))


Dim s1 As String = sqlCon.ConnectionString.ToString
sqlDaEndDate = New System.Data.SqlClient.SqlDataAdapter("Select * from sessiondelayed", sqlCon)
dsEndDate = New DataSet
sqlDaEndDate.Fill(dsEndDate)

dbcommandBuilder = New SqlClient.SqlCommandBuilder(sqlDaEndDate)

'sqlCon.BeginTransaction()
'sqlDaEndDate.InsertCommand.Transaction = tr
If sqlCon.State = ConnectionState.Closed Then
sqlCon.Open()
End If
sqlDaEndDate.InsertCommand = sqlCon.CreateCommand()
tr = sqlCon.BeginTransaction(IsolationLevel.ReadCommitted)
sqlDaEndDate.InsertCommand.Connection = sqlCon
sqlDaEndDate.InsertCommand.Transaction = tr
sqlDaEndDate.InsertCommand.CommandText = strSQL
sqlDaEndDate.InsertCommand.CommandType = CommandType.Text


sqlDaEndDate.InsertCommand.ExecuteNonQuery()
tr.Commit()
sqlDaEndDate.Update(dsEndDate)
sqlCon.Close()
End If
Catch es As Exception


Dim s2 As String = es.Message
If sqlCon.State = ConnectionState.Closed Then
sqlCon.Open()
End If
strSQL = " update SessionDelayed set ActualEndDate= '" & Format(d1, "MM/dd/yyyy") & "' where batchid=" & bID & ""
sqlDaEndDate.UpdateCommand = sqlCon.CreateCommand()
tr1 = sqlCon.BeginTransaction(IsolationLevel.ReadCommitted)
sqlDaEndDate.UpdateCommand.Connection = sqlCon
sqlDaEndDate.UpdateCommand.Transaction = tr1
sqlDaEndDate.UpdateCommand.CommandText = strSQL
sqlDaEndDate.UpdateCommand.CommandType = CommandType.Text
sqlDaEndDate.UpdateCommand.ExecuteNonQuery()
tr1.Commit()
sqlDaEndDate.Update(dsEndDate)
sqlCon.Close()

End Try

'----End------

You can't since connection is basically tied to a transaction and there can be one at a time.

You either:
- use the same connection and share the same transaction
- use separate connections and therefore separate transactions

If you use v2.0 TransactionScope class might help your task.

Error:sql mobile encountered problems when opening the database

I am trying to deploy my mobile app to treo 700wx, but when i test the app, the application gives me an error message:

sql mobile encountered problems when opening the database

It happens when I sync data.

However, when I sync data users and customer info, it doesn't give this message, But when I sync (third time) order info, this message comes out.

--when i run on my PPC (HP ra1950), there is no this error message.

I think it is a bug?

BTW, which cabs file should I install on the Treo phone? (.Net ce, sql ce mobile30 ?)

Please help me out. Thanks

James

This problem may be caused by not disposing the replication object. Make sure you always dispose all the data related objects.

These 2 forum entries refer to this problem:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=334604&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=478902&SiteID=1|||It may be caused by the System.Data.SqlServerCe versioning. if you are doing merge replication in using VS orcas you need to use the compact edition 3.5 instead of 9.0.242.0 Syatem.Data.SqlServerCe assembly. if you insist of using the 9.0242.0 then you need to add those compact 3.5 edition 7's .dlls in to your execution directory. The dlls are sqlceca30.dll, sqlcecompact30.dll, sqlceer30EN.dll, sqlceme30.dll, sqlceoledb30.dll, sqlceqp30.dll, sqlcese30.dll. Try to remove and add the assembly.

Error:sql mobile encountered problems when opening the database

I am trying to deploy my mobile app to treo 700wx, but when i test the app, the application gives me an error message:

sql mobile encountered problems when opening the database

It happens when I sync data.

However, when I sync data users and customer info, it doesn't give this message, But when I sync (third time) order info, this message comes out.

--when i run on my PPC (HP ra1950), there is no this error message.

I think it is a bug?

BTW, which cabs file should I install on the Treo phone? (.Net ce, sql ce mobile30 ?)

Please help me out. Thanks

James

This problem may be caused by not disposing the replication object. Make sure you always dispose all the data related objects.

These 2 forum entries refer to this problem:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=334604&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=478902&SiteID=1
|||It may be caused by the System.Data.SqlServerCe versioning. if you are doing merge replication in using VS orcas you need to use the compact edition 3.5 instead of 9.0.242.0 Syatem.Data.SqlServerCe assembly. if you insist of using the 9.0242.0 then you need to add those compact 3.5 edition 7's .dlls in to your execution directory. The dlls are sqlceca30.dll, sqlcecompact30.dll, sqlceer30EN.dll, sqlceme30.dll, sqlceoledb30.dll, sqlceqp30.dll, sqlcese30.dll. Try to remove and add the assembly.

Error:rsErrorReadingNextDataRow

An error has occurred during report processing. (rsProcessingAborted)
Cannot read the next data row for the data set PerfAnalysis. (rsErrorReadingNextDataRow)
Please Help!Thanks!Sorry, you need to let us know some more information.

Which version / build of Reporting Services are you using?
Which data source are you using?

If you right click on the error page and select View Source, you should be able to see the stack trace.|||Thank you all the same.
The problem is solved.
It is data source.|||

Hello Brian,

We are also facing the same problem. We are getting following two messages on the error page. We are using reporting services 2000.

An error has occurred during report processing. (rsProcessingAborted) Get Online Help http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsProcessingAborted&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00

Cannot read the next data row for the data set DsCheck. (rsErrorReadingNextDataRow) Get Online Help http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsErrorReadingNextDataRow&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00

When we executed the stored procedure from the Query Analyzer we get the proper output without any error. There is no clue as to why next row is not getting read.

Thanks for your help.

Atul

|||

Hi,

I have the same problem now, what is the solution ?

Regards.

Mario

|||

Did any one find the solution for this?. I have the same problem for one my report. other reports works fine. All uses the same datasource

Error:rsErrorReadingNextDataRow

An error has occurred during report processing. (rsProcessingAborted)
Cannot read the next data row for the data set PerfAnalysis. (rsErrorReadingNextDataRow)
Please Help!Thanks!Sorry, you need to let us know some more information.

Which version / build of Reporting Services are you using?
Which data source are you using?

If you right click on the error page and select View Source, you should be able to see the stack trace.|||Thank you all the same.
The problem is solved.
It is data source.|||

Hello Brian,

We are also facing the same problem. We are getting following two messages on the error page. We are using reporting services 2000.

An error has occurred during report processing. (rsProcessingAborted) Get Online Help http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsProcessingAborted&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00

Cannot read the next data row for the data set DsCheck. (rsErrorReadingNextDataRow) Get Online Help http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsErrorReadingNextDataRow&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00

When we executed the stored procedure from the Query Analyzer we get the proper output without any error. There is no clue as to why next row is not getting read.

Thanks for your help.

Atul

|||

Hi,

I have the same problem now, what is the solution ?

Regards.

Mario

|||

Did any one find the solution for this?. I have the same problem for one my report. other reports works fine. All uses the same datasource

Error:rsErrorReadingNextDataRow

An error has occurred during report processing. (rsProcessingAborted)
Cannot read the next data row for the data set PerfAnalysis. (rsErrorReadingNextDataRow)
Please Help!Thanks!Sorry, you need to let us know some more information.

Which version / build of Reporting Services are you using?
Which data source are you using?

If you right click on the error page and select View Source, you should be able to see the stack trace.|||Thank you all the same.
The problem is solved.
It is data source.|||

Hello Brian,

We are also facing the same problem. We are getting following two messages on the error page. We are using reporting services 2000.

An error has occurred during report processing. (rsProcessingAborted) Get Online Help http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsProcessingAborted&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00

Cannot read the next data row for the data set DsCheck. (rsErrorReadingNextDataRow) Get Online Help http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsErrorReadingNextDataRow&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00

When we executed the stored procedure from the Query Analyzer we get the proper output without any error. There is no clue as to why next row is not getting read.

Thanks for your help.

Atul

|||

Hi,

I have the same problem now, what is the solution ?

Regards.

Mario

|||

Did any one find the solution for this?. I have the same problem for one my report. other reports works fine. All uses the same datasource

|||

Even i m facing same problem at client place. Did any one find the solution for this?

I guess this error might be related one of the following two things

1 Connection.

I am able to reproduce this error only when i disconnected the network during report generation.

2 Permission

The stored procedure might not have sufficient permission. Perticularly when one of the dataset depending upon another dataset. For example when we use formula to hide columns in report based on value of another dataset.

Error:rsErrorReadingNextDataRow

An error has occurred during report processing. (rsProcessingAborted)
Cannot read the next data row for the data set PerfAnalysis. (rsErrorReadingNextDataRow)
Please Help!Thanks!Sorry, you need to let us know some more information.

Which version / build of Reporting Services are you using?
Which data source are you using?

If you right click on the error page and select View Source, you should be able to see the stack trace.|||Thank you all the same.
The problem is solved.
It is data source.|||

Hello Brian,

We are also facing the same problem. We are getting following two messages on the error page. We are using reporting services 2000.

An error has occurred during report processing. (rsProcessingAborted) Get Online Help http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsProcessingAborted&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00

Cannot read the next data row for the data set DsCheck. (rsErrorReadingNextDataRow) Get Online Help http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsErrorReadingNextDataRow&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00

When we executed the stored procedure from the Query Analyzer we get the proper output without any error. There is no clue as to why next row is not getting read.

Thanks for your help.

Atul

|||

Hi,

I have the same problem now, what is the solution ?

Regards.

Mario

|||

Did any one find the solution for this?. I have the same problem for one my report. other reports works fine. All uses the same datasource

|||

Even i m facing same problem at client place. Did any one find the solution for this?

I guess this error might be related one of the following two things

1 Connection.

I am able to reproduce this error only when i disconnected the network during report generation.

2 Permission

The stored procedure might not have sufficient permission. Perticularly when one of the dataset depending upon another dataset. For example when we use formula to hide columns in report based on value of another dataset.

Error:Procedure or function CatalogJSummary has too many arguments specified

hello, all

I am using a Stored procedure and calling this in my code in C#.

Here is my procedure:

CatalogJSummary

(

@.SeriesId INT

)

AS

SELECT Games.GameName, Games.Id AS GameId

FROM GameCodes INNER JOIN

Games ON GameCodes.GameId = Games.Id INNER JOIN

MobileSeries ON GameCodes.SeriesId = MobileSeries.Id INNER JOIN

Mobiles ON MobileSeries.Id = Mobiles.SeriesId

GROUP BY Games.GameName, Games.Id, MobileSeries.Id

HAVING (MobileSeries.Id = @.SeriesId)

RETURN

and here is the calling C# code::

public DataSet CatalogJSummary(int sid)

{

SqlConnection cnUnique=new SqlConnection();

cnUnique.ConnectionString=System.Configuration.ConfigurationSettings.AppSettings["jconnection"];

//con.ConnectionString=System.Configuration.ConfigurationSettings.AppSettings["jconnection"];

com.CommandText="CatalogJSummary";

com.CommandType=CommandType.StoredProcedure;

com.Parameters.Add("@.SeriesId",SqlDbType.Int);

com.Parameters["@.SeriesId"].Value=sid;

com.Connection=cnUnique;

// con.Open();

cnUnique.Open();

adp=new SqlDataAdapter();

adp.SelectCommand=com;

DataSet ds1=new DataSet();

adp.Fill(ds1);

cnUnique.Close();

return ds1;

}

but when this code execute,with the parameter passed to stored procedure using this code at runtime, i get the following error::

Procedure or function CatalogJSummary has too many arguments specified.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Procedure or function CatalogJSummary has too many arguments specified.

Source Error:

Line 243:adp.SelectCommand=com; Line 244:DataSet ds1=new DataSet(); Line 245:adp.Fill(ds1); Line 246:cnUnique.Close(); Line 247:return ds1;


Source File: c:\inetpub\wwwroot\mobmasti.catalog\classes\truetonescls.cs Line: 245

Anyone please help me to resolve this error

thanks in advance

There are many options you can try:

1. From SQL Server books online:
If the first three characters of the procedure name are sp_, SQL Server
searches the master database for the procedure. If no qualified procedure name is provided, SQL Server searches for the procedure as if the owner name is dbo. To resolve the stored procedure name as a user-defined stored procedure with the same name as a system stored procedure, provide the fully qualified procedure name.

2. Make sure the field names between your calls and the procedure are the same

3. Make sure you attached the database with the user it was intended to be used with. Otherwise you may not have sufficient rights and this message will show up.

error:no report server found on the specified machine while setting up reporting services config

Hello,

I have installed sql server 2005 along with reporting services... though i am able to design report using business intelligence studio... i am unable to access the report server.... while trying to start the reporting services configuration manager it says no report server found on the specified machine...Invalid Namespace... the installation is local ...

Due to this problem inspite of designing the entire report i am unable to deploy it on the web..since it is asking for a report server...

Can somebody please help me on this...

Thanks in advance...

Nirupa

Hello Nirupa,

Can you make sure you have IIS installed and running? If so, make sure you have /Reports and /ReportServer showing in IIS management.

Then, check to see if you have the following three folders in the C:\Program Files\Microsoft SQL Server\MSSQL.x\Reporting Services directory (where x is the component number for RS). LogFiles, ReportManager, & ReportServer

Hope this helps.

Jarret

|||

Hi Jarret,

Thanks for your suggestions first,

yes I installed IIS and it is running,

and

I couldn't find any folder C:\Program Files\Microsoft SQL Server\MSSQL.1\ Reporting Services directory

...LogFiles, ReportManager, & ReportServer

I could see only path C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\ Backup

'' \Bin

'' \Install

'' \LOG

'' \repldata

'' \TemplateData

can you suggest me what might had happen.... or what shall be done

Thanks

Nirupa

|||

Do you have a MSSQL.2, MSSQL.3, or MSSQL.4 folder? If so, look in each for the 3 folders I listed in my last post. If you don't have these folders, you probably should reinstall Reporting Services.

Jarret

|||

Hello Jarret

I do not have the folders that you have mentioned....As you have mentioned will probably need reinstallation

Thank you

Nirupa

|||

That is correct, if you don't have these folders, you don't have RS installed. Try to re-install and see if that fixes your problem.

Jarret

|||

Hi Jarret,

Thanks for your suggestions.As you mentioned, I reinstalled SQL reporting services and got the above mention folders(MSSQL.1,MSSQL.2,MSSQL.3) and also I successfully configured reporting services.While trying to deploy my reporting services application in to localhost , I got the below mentioned error : " The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.ReportingServices.Designer) "

can you please sugguest me work around for this issue.

Error:Initializing SQL Server Reconciler has failed.

My exploit environment:

VS.net 2003, SQL Server 2000 SP4, SQL Server CE 2.0 SP4

I write next codes:

Private cn As New SqlCeConnection("data source=\my documents\SQLCECF.sdf")

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

Try

If Not System.IO.File.Exists("\my documents\SQLCECF.sdf") Then

Dim en As New SqlCeEngine("data source=\my documents\SQLCECF.sdf")

en.CreateDatabase() 'create a blank database to subscribe

Synch()

End If

Catch err As SqlCeException

ShowErrors(err)

Catch err As Exception

MsgBox("There was an error:" & err.ToString())

End Try

End Sub

Sub Synch()

Try

Dim rep As SqlCeReplication = New SqlCeReplication

With rep

.Publisher = "192.168.0.222"

.PublisherDatabase = "CFLab"

.PublisherLogin = "sa"

.PublisherPassword = "sa"

.Publication = "CFLab"

.Subscriber = "SQLCENETCF"

.SubscriberConnectionString = "Provider=Microsoft.SQLServer.OLEDB.CE.2.0;Data Source=\My Documents\SQLCECF.sdf"

.InternetUrl = "http://192.168.0.222/SQLCE/sscesa20.dll"

' Create the Local SSCE Database subscription

rep.AddSubscription(AddOption.CreateDatabase)

rep.Synchronize() 'subscribe

End With

Catch err As SqlCeException

ShowErrors(err)

Finally

End Try

End Sub

Public Sub ShowErrors(ByRef e As SqlCeException)

Dim errorCollection As SqlCeErrorCollection = e.Errors

Dim bld As System.Text.StringBuilder = New System.Text.StringBuilder

Dim inner As Exception = e.InnerException

If Not inner Is Nothing Then

MessageBox.Show(("Inner Exception:" & inner.ToString()))

End If

For Each err As SqlCeError In errorCollection

bld.Append("/n Error Code: " + err.HResult.ToString("X", System.Globalization.CultureInfo.CurrentCulture))

bld.Append("/n Message : " + err.Message)

bld.Append("/n Minor Err.: " + err.NativeError.ToString())

bld.Append("/n Source : " + err.Source)

For Each numPar As Int32 In err.NumericErrorParameters

If 0 <> numPar Then

bld.Append("/n Num. Par. : " + numPar.ToString())

End If

Next

For Each errPar As String In err.ErrorParameters

If String.Empty <> errPar Then

bld.Append("/n Err. Par. : " + errPar)

End If

Next errPar

MessageBox.Show(bld.ToString())

bld.Remove(0, bld.Length)

Next err

End Sub

Private Sub btnShow_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnShow.Click

connect()

Dim query As String = "select * from FlightData"

Dim dap As New SqlCeDataAdapter(query, cn)

Dim dataset1 As New DataSet

dap.Fill(dataset1, "FlightData")

Disconnect()

End Sub

Sub connect()

Synch()

Try

cn.Open()

Catch err As SqlCeException

ShowErrors(err)

End Try

End Sub

Sub Disconnect()

Try

cn.Close()

Catch err As SqlCeException

ShowErrors(err)

End Try

End Sub

Private Sub dgdResults_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles dgdResults.Click

End Sub

End Class

I want to synchronize the data from a SQLCE SERVER 2000

When i run the code above, the errors show:

Error Code:80045058
Message:Initializing SQL Server Reconciler has failed.

Error Code:80045058
Message:The course can't load "SSCE" Merge Replication program。please check the module wether enroll correctly.(probable description)

I do not know what's going wrong..=(
Who can help me?!!! HELP~~~~~~~~~
thanks..

Move to Sql Server Compact Edition forum.

Thanks!

|||

Please provide the exact error message, see here for instructions on how to get all error information:

http://msdn2.microsoft.com/en-us/library/ms174079.aspx

|||

I already used the error objectsuse and listed the error information above :

Error Code:80045058
Message:Initializing SQL Server Reconciler has failed.

Error Code:80045058
Message:The course can't load "SSCE" Merge Replication program。please check the module wether enroll correctly.(probable description)

and I do not know what's going wrong

help!

|||

You should also get a native error number (5 digits), please list this, and the proper english text for this:

The course can't load "SSCE" Merge Replication program。please check the module wether enroll correctly.(probable description)

|||

I use the SQL CE of Chinese Edition, so I don't know the proper english text for that.

the text list above is which I translate into English.

thanks

|||I still do not see the native error and the error source (although it appears to be in your ShowErrors code)|||

hi, eric zhang, I met a same problem with. and NATIVE_ERROR: 29045
I'm a chinese too.So, If you have any solution, please let me share with you, thx

Error:Cannot resolve collation conflict for equal to operation.

Exception information:System.Data.SqlClient.SqlException: Cannot resolve collation conflict for equal to operation.
Who can tell me how to resolve this problem?
ThxIs this an error you've seen here on the ASP.NET Forums? (After all, you've posted this message in the forum dedicated to ASP.NET Forum bugs and discussions.)

Or, is this an error in your own application? If so, I will move this thread into theSQL Server and MSDE forum.|||Maybe I made a mistake.(I just met this error in my own server with asp.net environment)|||You've got mixed collations, this typically occurs when your underlying tables collation doesn't match the servers default collation. You need to specify the collation you want to use in the query. Look up COLLATE and DATABASE_DEFAULT.

It's also a common gotcha if you're using table vars, for the same reason, the same "COLLATE database_default" does the trick.

error:an item with the same key has already been added

hi.
i just moved to the april ctp beta 2 version of dts(i know it's already late to do that). i created a new project and moved the packages i did on beta 1 into it. after building it, and when i run the dtsintall.exe, it got this error : an item with the same key has already been added (mscorlib).
what i did is excluded all the packages from the project and ran it for one package it worked..gradually i added a package after the other and build it and it worked..then suddenly the error appeared again and i can't get rid of it even when i go back to my initial state of 2 packages.. i can't understand why it's giving it.

i'm sure someone must have faced this problem. please help!

Thanks
ChristinaHi Christina,

One of the problems could have been that the packages use XML configurations that have the same file name.

This has been addressed for CTP16.

regards,
ash|||Hi Ash. Thanks for your reply.
Is it the file name or the configuration name?
If i change the configuration type will it work?

Thanks
Christina

error:8646,severity:21,state:1

hi to all
Does any one here help me please in this error.By the way i've found this
error when i check the error log due to error in my replication monitor,all
subscriber cannot replicate due to this error.Im using sql 7.
complete error:
the index entry for row ID was not found in index Id 5,of table 362536425,
in Database 'Database Name'
Error:8646,Severity:21,State:1
Thank you in advance
Pheter R. Flores
This article applies to SQL2000, but I'd check to see if it apples to SQL7
anyway:
http://support.microsoft.com/default.aspx?scid=kb;en-us;822747
I'd also run DBB CHECKDB (even though the article says DBCC will not report
any errors described by the article), especially if the KB article doesn't
apply.
For a non-clustered index, often dropping and re-creating it may fix the
problem, though not the root cause.
Linchi
"MICS" wrote:

> hi to all
> Does any one here help me please in this error.By the way i've found this
> error when i check the error log due to error in my replication monitor,all
> subscriber cannot replicate due to this error.Im using sql 7.
> complete error:
> the index entry for row ID was not found in index Id 5,of table 362536425,
> in Database 'Database Name'
> Error:8646,Severity:21,State:1
> Thank you in advance
> Pheter R. Flores
|||I had already read that article before and it seems that the fix is only
applied on sql 2000.Is there any fix aside from the hotfix on that article?
Thank you so much
"Linchi Shea" wrote:
[vbcol=seagreen]
> This article applies to SQL2000, but I'd check to see if it apples to SQL7
> anyway:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;822747
> I'd also run DBB CHECKDB (even though the article says DBCC will not report
> any errors described by the article), especially if the KB article doesn't
> apply.
> For a non-clustered index, often dropping and re-creating it may fix the
> problem, though not the root cause.
> Linchi
> "MICS" wrote:
|||maybe your right,but the problem is i don't know what particular table should
i rebuild the index,because as you've notice the error message display only
the number of the table and not the name.Do you know hoe to locate the table
name given only the number?thanks
"Tibor Karaszi" wrote:

> Seems like a corruption problem. Possibly dropping that index (and then re-creating it) will clean
> it up. Also see http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "MICS" <MICS@.discussions.microsoft.com> wrote in message
> news:EA0291E2-D243-4896-A0F8-CCCD06923FF9@.microsoft.com...
>
|||i''ve found it on the sysobjects system table,and by the way i already solve
the problem by running dbcc.tnank you so much
"Tibor Karaszi" wrote:

> Check out the OBJECT_NAME() function. Or look it up in the sysobjects system table.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "MICS" <MICS@.discussions.microsoft.com> wrote in message
> news:46BA4D55-694E-4428-9A1D-F23813F4FC7A@.microsoft.com...
>

error:8646,severity:21,state:1

hi to all
Does any one here help me please in this error.By the way i've found this
error when i check the error log due to error in my replication monitor,all
subscriber cannot replicate due to this error.Im using sql 7.
complete error:
the index entry for row ID was not found in index Id 5,of table 362536425,
in Database 'Database Name'
Error:8646,Severity:21,State:1
Thank you in advance
Pheter R. FloresThis article applies to SQL2000, but I'd check to see if it apples to SQL7
anyway:
http://support.microsoft.com/default.aspx?scid=kb;en-us;822747
I'd also run DBB CHECKDB (even though the article says DBCC will not report
any errors described by the article), especially if the KB article doesn't
apply.
For a non-clustered index, often dropping and re-creating it may fix the
problem, though not the root cause.
Linchi
"MICS" wrote:
> hi to all
> Does any one here help me please in this error.By the way i've found this
> error when i check the error log due to error in my replication monitor,all
> subscriber cannot replicate due to this error.Im using sql 7.
> complete error:
> the index entry for row ID was not found in index Id 5,of table 362536425,
> in Database 'Database Name'
> Error:8646,Severity:21,State:1
> Thank you in advance
> Pheter R. Flores|||I had already read that article before and it seems that the fix is only
applied on sql 2000.Is there any fix aside from the hotfix on that article?
Thank you so much
"Linchi Shea" wrote:
> This article applies to SQL2000, but I'd check to see if it apples to SQL7
> anyway:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;822747
> I'd also run DBB CHECKDB (even though the article says DBCC will not report
> any errors described by the article), especially if the KB article doesn't
> apply.
> For a non-clustered index, often dropping and re-creating it may fix the
> problem, though not the root cause.
> Linchi
> "MICS" wrote:
> > hi to all
> > Does any one here help me please in this error.By the way i've found this
> > error when i check the error log due to error in my replication monitor,all
> > subscriber cannot replicate due to this error.Im using sql 7.
> >
> > complete error:
> >
> > the index entry for row ID was not found in index Id 5,of table 362536425,
> > in Database 'Database Name'
> >
> > Error:8646,Severity:21,State:1
> >
> > Thank you in advance
> >
> > Pheter R. Flores|||Seems like a corruption problem. Possibly dropping that index (and then re-creating it) will clean
it up. Also see http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"MICS" <MICS@.discussions.microsoft.com> wrote in message
news:EA0291E2-D243-4896-A0F8-CCCD06923FF9@.microsoft.com...
> hi to all
> Does any one here help me please in this error.By the way i've found this
> error when i check the error log due to error in my replication monitor,all
> subscriber cannot replicate due to this error.Im using sql 7.
> complete error:
> the index entry for row ID was not found in index Id 5,of table 362536425,
> in Database 'Database Name'
> Error:8646,Severity:21,State:1
> Thank you in advance
> Pheter R. Flores|||maybe your right,but the problem is i don't know what particular table should
i rebuild the index,because as you've notice the error message display only
the number of the table and not the name.Do you know hoe to locate the table
name given only the number?thanks
"Tibor Karaszi" wrote:
> Seems like a corruption problem. Possibly dropping that index (and then re-creating it) will clean
> it up. Also see http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "MICS" <MICS@.discussions.microsoft.com> wrote in message
> news:EA0291E2-D243-4896-A0F8-CCCD06923FF9@.microsoft.com...
> > hi to all
> > Does any one here help me please in this error.By the way i've found this
> > error when i check the error log due to error in my replication monitor,all
> > subscriber cannot replicate due to this error.Im using sql 7.
> >
> > complete error:
> >
> > the index entry for row ID was not found in index Id 5,of table 362536425,
> > in Database 'Database Name'
> >
> > Error:8646,Severity:21,State:1
> >
> > Thank you in advance
> >
> > Pheter R. Flores
>|||Check out the OBJECT_NAME() function. Or look it up in the sysobjects system table.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"MICS" <MICS@.discussions.microsoft.com> wrote in message
news:46BA4D55-694E-4428-9A1D-F23813F4FC7A@.microsoft.com...
> maybe your right,but the problem is i don't know what particular table should
> i rebuild the index,because as you've notice the error message display only
> the number of the table and not the name.Do you know hoe to locate the table
> name given only the number?thanks
> "Tibor Karaszi" wrote:
>> Seems like a corruption problem. Possibly dropping that index (and then re-creating it) will
>> clean
>> it up. Also see http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "MICS" <MICS@.discussions.microsoft.com> wrote in message
>> news:EA0291E2-D243-4896-A0F8-CCCD06923FF9@.microsoft.com...
>> > hi to all
>> > Does any one here help me please in this error.By the way i've found this
>> > error when i check the error log due to error in my replication monitor,all
>> > subscriber cannot replicate due to this error.Im using sql 7.
>> >
>> > complete error:
>> >
>> > the index entry for row ID was not found in index Id 5,of table 362536425,
>> > in Database 'Database Name'
>> >
>> > Error:8646,Severity:21,State:1
>> >
>> > Thank you in advance
>> >
>> > Pheter R. Flores|||i''ve found it on the sysobjects system table,and by the way i already solve
the problem by running dbcc.tnank you so much
"Tibor Karaszi" wrote:
> Check out the OBJECT_NAME() function. Or look it up in the sysobjects system table.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "MICS" <MICS@.discussions.microsoft.com> wrote in message
> news:46BA4D55-694E-4428-9A1D-F23813F4FC7A@.microsoft.com...
> > maybe your right,but the problem is i don't know what particular table should
> > i rebuild the index,because as you've notice the error message display only
> > the number of the table and not the name.Do you know hoe to locate the table
> > name given only the number?thanks
> >
> > "Tibor Karaszi" wrote:
> >
> >> Seems like a corruption problem. Possibly dropping that index (and then re-creating it) will
> >> clean
> >> it up. Also see http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://sqlblog.com/blogs/tibor_karaszi
> >>
> >>
> >> "MICS" <MICS@.discussions.microsoft.com> wrote in message
> >> news:EA0291E2-D243-4896-A0F8-CCCD06923FF9@.microsoft.com...
> >> > hi to all
> >> > Does any one here help me please in this error.By the way i've found this
> >> > error when i check the error log due to error in my replication monitor,all
> >> > subscriber cannot replicate due to this error.Im using sql 7.
> >> >
> >> > complete error:
> >> >
> >> > the index entry for row ID was not found in index Id 5,of table 362536425,
> >> > in Database 'Database Name'
> >> >
> >> > Error:8646,Severity:21,State:1
> >> >
> >> > Thank you in advance
> >> >
> >> > Pheter R. Flores
> >>
>