error handling flow: errors

Showing posts with label errors. Show all posts

Thursday, March 29, 2012

error loading the report in the designer

Hi all,
I'm working on rs2005, and i cannot load any server report in the
designer.
i get the following error:
"One or more errors encountered while loading the designer. The errors
are listed below.
Exception has been thrown by the target of an invocation "
I can load local reports, and i can load the server reports on other
computers.
It just suddenly stopped working in my laptop, and no reinstallation
helps (at least not the visual studio, framework, or the report server)
Does anyone hav an idea?
Thanks,
EyalWell, i found the solution eventually,
After getting a message "font verdana does not support style regular"
while trying to load a winforms into the designer, i deleted all my
fonts from my computer, and copied them from another computer.
both the winform problem and the reporting services problem has gone
forever.
it seems that a corrupted font has crashed the visual studio designer.
Eyal
Eyal =EB=FA=E1:
> Hi all,
> I'm working on rs2005, and i cannot load any server report in the
> designer.
> i get the following error:
> "One or more errors encountered while loading the designer. The errors
> are listed below.
> Exception has been thrown by the target of an invocation "
> I can load local reports, and i can load the server reports on other
> computers.
> It just suddenly stopped working in my laptop, and no reinstallation
> helps (at least not the visual studio, framework, or the report server)
> > Does anyone hav an idea?
> Thanks,
> Eyal

Error loading metadata....PLZZ HELP!!

My Analysis Service has this strange errors....

My Calculation tabs, KPI tabs, Action tabs....all showing this error message at it's Calculation Tools metadata tab....

"Error loading metadata: The cube could not be retrieved from the server. Verify that the server is running and that cube is processed."

previously i even had the problem of running the script organizer for the Calculation tabs.....after installing the SP2, it's fixed, but the metadata error still there.....

i tried on my friends PC and it works fine and deploy successfully whereas mine cannot at all with all kind of errors.....

Hello. I would recommend you to uninstall BIDS on you machine and reinstall it again with SP2.

Since you have a deployed cube you can always reverse engineer it to a project in BIDS when it is working.

Regards

Thomas Ivarsson

Error List, Sql Server 2005

Hello, I would like to know if there is an list of mistakes where appears all errors that you can find to interact with the SQL.

for example something similar like this:

Error number 2627 Means that exists a record with the same primary key

Error number 505 Means that ther is a row with doesn't accept nulls

Thanks, my email pac_mt@.hotmail.com .

Are you looking for the possible error messages? You can query master.dbo.sysmessages in older versions of SQL Server and sys.messages in SQL Server 2005. Older versions of Books Online also has the list of error numbers/messages.|||

The problem is that sysmessages doesn't contain all error numbers. For instance, I can't find the error 1326: An error has occurred while establishing a connection to the server...

Why are not all errors documented and is there any unofficial documentation where I can find the full list of errors?

Thanks

|||

1326 is not a SQL Server error message. It is raised by the client data access library. All the error messages raised by server should be present in the system table. But not all error messages may be documented in Books Online. If you find such errors and would like to see it documented then please use the feedback mechanism in Books Online to submit a work item. This is the best way to send feedback for documentation issues.

See below topic for SQL Server 2000 error messages:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/trblsql/tr_syserrors1_6m5z.asp

And btw, the latest update (July 2006) of SQL Server 2005 Books Online contains the error message topics too. See below links:

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

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

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

|||

Thanks.

I actually decompiled System.Data.SqlClient yesterday and noticed these connection errors come from dbnetlib.dll

These error messages, thrown by ado.net as SqlExceptions, are really hard to identify as there are dozens of different error numbers for the VERY same error description (like 5, 51, 121, 231, 1326) and sometimes they overlap the native SQL Server errors.

I'll also post this to a ADO.NET forum. Thanks again.

sql

Error Installing Workstation Components SQL 2005 Enterprise

Hello. I am trying to install only the Workstation Components portion of SQL Server 2005 and I get about halfway through and the installation errors out. The error is:

EventType: sql90setup

P1: installtoolsaction

P2: 0xc0000006

P3: 0x78158a35

P4: 0xc0000006

P5: setup_sqlactionenginelistener.cpp@.198

P6: setup.exe@.2005.90.1399.0

P7: none

This happens after the second disk of the installation is about halfway through installing and then it throws an error stating that "The wrong volume is in the drive. Please insert volume SQLSRVRS into drive D. Cancel, Try Again, Continue" I replace the disc with the first disc and if I pick "Continue" it will display the error above. If I pick "Try again" the installation finishes, but there are components missing from Visual Studio.

Here is the log file:

=== Verbose logging started: 3/16/2006 14:03:49 Build type: SHIP UNICODE 3.01.4000.2435 Calling process: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\setup.exe ===
MSI (c) (58:00) [14:03:49:483]: Resetting cached policy values
MSI (c) (58:00) [14:03:49:483]: Machine policy value 'Debug' is 0
MSI (c) (58:00) [14:03:49:483]: ******* RunEngine:
******* Product: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\Setup\SqlRun_Tools.msi
******* Action:
******* CommandLine: **********
MSI (c) (58:00) [14:03:49:483]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (58:00) [14:03:49:483]: Grabbed execution mutex.
MSI (c) (58:00) [14:03:49:483]: Cloaking enabled.
MSI (c) (58:00) [14:03:49:483]: Attempting to enable all disabled priveleges before calling Install on Server
MSI (c) (58:00) [14:03:49:483]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (D4:80) [14:03:49:499]: Grabbed execution mutex.
MSI (s) (D4:BC) [14:03:49:499]: Resetting cached policy values
MSI (s) (D4:BC) [14:03:49:499]: Machine policy value 'Debug' is 0
MSI (s) (D4:BC) [14:03:49:499]: ******* RunEngine:
******* Product: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\Setup\SqlRun_Tools.msi
******* Action:
******* CommandLine: **********
MSI (s) (D4:BC) [14:03:49:499]: Note: 1: 2203 2: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\Setup\SqlRun_Tools.msi 3: -2147287037
MSI (s) (D4:BC) [14:03:49:499]: MainEngineThread is returning 3
MSI (c) (58:00) [14:03:49:499]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (58:00) [14:03:49:499]: MainEngineThread is returning 3
=== Verbose logging stopped: 3/16/2006 14:03:49 ===

Thank you very much,

Did you get this solved? I don't think this is a known issue. Possibly it's a bad disk. If you're still blocked by this please either file a bug or post a link to your complete setup logs.

Thanks,

Paul

|||If you want to install only client components, start setup from disc 2. That should fix the problem. I saw this error message commented somewhere, it is even worse when you use unattended setup from CD1 for client components only.|||

I think there is a problem with the disc because I was able to install the Workstation Components from the Developer disc that came with VS .NET 2005 on the same machines. I guess we will need to send them back for new discs.

Thanks!

|||We also ran into this problem with our Visual Studio 2005 CDs. The statement that you can run the set-up from the second CD only doesn't resolve the problem either. I will have to contact Microsoft regarding this problem though. I haven't been able to prevent this from occurring as of yet.|||

I also got this error. This is how I was able to complete the installation.

I just restarted installation using disk 1 and selected only workstation components to install. It asked for disk 2 and the it completed the installation. At the end of the installation again I got that error popped up but it's ok the SQL Server installation is fine and complete.

cool - Ashok Ojha

|||I also got this problem and solved installing the Client Components from the second cd

Error Installing Workstation Components SQL 2005 Enterprise

Hello. I am trying to install only the Workstation Components portion of SQL Server 2005 and I get about halfway through and the installation errors out. The error is:

EventType: sql90setup

P1: installtoolsaction

P2: 0xc0000006

P3: 0x78158a35

P4: 0xc0000006

P5: setup_sqlactionenginelistener.cpp@.198

P6: setup.exe@.2005.90.1399.0

P7: none

Here is the log file:

Thank you very much,

Did you get this solved? I don't think this is a known issue. Possibly it's a bad disk. If you're still blocked by this please either file a bug or post a link to your complete setup logs.

Thanks,

Paul

Thanks!

I also got this error. This is how I was able to complete the installation.

cool - Ashok Ojha

|||I also got this problem and solved installing the Client Components from the second cd

Error Installing Workstation Components SQL 2005 Enterprise

Hello. I am trying to install only the Workstation Components portion of SQL Server 2005 and I get about halfway through and the installation errors out. The error is:

EventType: sql90setup

P1: installtoolsaction

P2: 0xc0000006

P3: 0x78158a35

P4: 0xc0000006

P5: setup_sqlactionenginelistener.cpp@.198

P6: setup.exe@.2005.90.1399.0

P7: none

Here is the log file:

Thank you very much,

Did you get this solved? I don't think this is a known issue. Possibly it's a bad disk. If you're still blocked by this please either file a bug or post a link to your complete setup logs.

Thanks,

Paul

Thanks!

I also got this error. This is how I was able to complete the installation.

cool - Ashok Ojha

|||I also got this problem and solved installing the Client Components from the second cd

Error Installing Workstation Components SQL 2005 Enterprise

Hello. I am trying to install only the Workstation Components portion of SQL Server 2005 and I get about halfway through and the installation errors out. The error is:

EventType: sql90setup

P1: installtoolsaction

P2: 0xc0000006

P3: 0x78158a35

P4: 0xc0000006

P5: setup_sqlactionenginelistener.cpp@.198

P6: setup.exe@.2005.90.1399.0

P7: none

Here is the log file:

Thank you very much,

Did you get this solved? I don't think this is a known issue. Possibly it's a bad disk. If you're still blocked by this please either file a bug or post a link to your complete setup logs.

Thanks,

Paul

Thanks!

I also got this error. This is how I was able to complete the installation.

cool - Ashok Ojha

|||I also got this problem and solved installing the Client Components from the second cdsql

Monday, March 19, 2012

Error in restoring SSAS database

Hi,

getting this error on restoring an ssas database .abf file with a different database name.
Backup and restore errors: Restore under different DatabaseId/DatabaseName can not be done for a database with partitions with specific location.
(Microsoft.AnalysisServices)

Program Location:

at Microsoft.AnalysisServices.AnalysisServicesClient.SendExecuteAndReadResponse(ImpactDetailCollection impacts, Boolean expectEmptyResults, Boolean throwIfError)

The db from which the backup was created had its partition data outside of the cube specific folder
....\Program Files\Microsoft SQL Server\MSSQL.1\OLAP\Data\XYZ.cub
That is the partition data was in the root folder ...\Data in the guid named folders.
Also tried changing the location for the partitions during the restore.

Is this an Analysis Services limitation?

Regards

That is correct.

The current limitation is: you cannot restore database with different name if you have partitions not in default location.

Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Sunday, March 11, 2012

Error in Processing Cube while ROLAP Storage

Hello,

When I process the Cube having ROLAP storage, it gives the error as below, any thoughts on this would be greatly appreciated.

Errors in the back-end database access module. ROLAP partition with the Name='Fact One' Id='Fact One' can not have aggregations at the (all, all, ... ) level. Aggregaion skipped. OLE DB error: OLE DB or ODBC error: Cannot create index on view "TESTROLAP.dbo.Agg_Fact One_0_1_1_1_1_1" because it references derived table "dbo_Fact_One" (defined by SELECT statement in FROM clause). Consider removing the reference to the derived table or not indexing the view.; 42000.

Thanks,
Nasir

Nasir wrote:

Hello,

When I process the Cube having ROLAP storage, it gives the error as below, any thoughts on this would be greatly appreciated.

Errors in the back-end database access module. ROLAP partition with the Name='Fact One' Id='Fact One' can not have aggregations at the (all, all, ... ) level. Aggregaion skipped. OLE DB error: OLE DB or ODBC error: Cannot create index on view "TESTROLAP.dbo.Agg_Fact One_0_1_1_1_1_1" because it references derived table "dbo_Fact_One" (defined by SELECT statement in FROM clause). Consider removing the reference to the derived table or not indexing the view.; 42000.

Thanks,
Nasir

Above Cube runs these two Queries while processing:

Query 1 succeeds and Query 2 fails, here are both of them:

Query 1

CREATE

VIEW [Agg_Fact One_0_1_1_1_1_1] ( [Amount_0],[_1],[TimeID_2], [COUNT_BIG_7673aff6-2445-4ef6-a4c9-7bf3d93bd42a] ) WITH SCHEMABINDING AS

(

SELECT SUM ( [dbo_Fact_One].[dbo_Fact_OneAmount0_0] )

AS [dbo_Fact_OneAmount0_0],

COUNT_BIG ( [dbo_Fact_One].[dbo_Fact_One0_1] )

AS [dbo_Fact_One0_1],[dbo_Fact_One].[dbo_Fact_OneTimeID0_2] AS [dbo_Fact_OneTimeID0_2], COUNT_BIG(*) AS [COUNT_BIG_7673aff6-2445-4ef6-a4c9-7bf3d93bd42a]

FROM

(

SELECT [Amount] AS [dbo_Fact_OneAmount0_0],1 AS [dbo_Fact_One0_1],[TimeID] AS [dbo_Fact_OneTimeID0_2]

FROM [dbo].[Fact_One]

)

AS [dbo_Fact_One]

GROUP BY [dbo_Fact_One].[dbo_Fact_OneTimeID0_2]

)

Query 2

CREATE

UNIQUE CLUSTERED INDEX [Agg_Fact One_0_1_1_1_1_1] ON [Agg_Fact One_0_1_1_1_1_1] ( [TimeID_2] )

Friday, March 9, 2012

Error In Log

Morning All,
Rececntly I have been getting quite a few errors on the resotre of my
databases, what happens is the files are downloaded from a remote server,
unziped and then I run some script to restore them.....this has been working
fine for quite some time with no problems whatsoever, until recently where
things have been crashing and my databases have been getting set to
Single-User mode which I do not want. I thought the failing of the restores
might have been a conflict in times of when things happen so I have made some
changes where this can not possibly be the issue, and I have now removed the
ALTER DATABASE .....SET SINGLE-USER WITH IMMEDIATE ROLLBACK script from my
restore process as a temp measure. After all this I am now getting a strange
error in the Log Files which I am not really sure what it means so I am
hoping someone can help, it says -:
BackupDiskFile::OpenMedia: Backup device
'C:\Download\Found' failed to open. Operating
syster error = 2(error not found).
Thanks for any help offered and I am currently using SQL Server 2000
Thanks PDPhil
When you say "some script to restore them.." , did you mean you was be able
to restore database? If so , do you have last backup of the database?
"Phil" <Phil@.discussions.microsoft.com> wrote in message
news:9E7F83F5-DC98-497D-ACE0-C781B7304B89@.microsoft.com...
> Morning All,
> Rececntly I have been getting quite a few errors on the resotre of my
> databases, what happens is the files are downloaded from a remote server,
> unziped and then I run some script to restore them.....this has been
> working
> fine for quite some time with no problems whatsoever, until recently where
> things have been crashing and my databases have been getting set to
> Single-User mode which I do not want. I thought the failing of the
> restores
> might have been a conflict in times of when things happen so I have made
> some
> changes where this can not possibly be the issue, and I have now removed
> the
> ALTER DATABASE .....SET SINGLE-USER WITH IMMEDIATE ROLLBACK script from
> my
> restore process as a temp measure. After all this I am now getting a
> strange
> error in the Log Files which I am not really sure what it means so I am
> hoping someone can help, it says -:
> BackupDiskFile::OpenMedia: Backup device
> 'C:\Download\Found' failed to open. Operating
> syster error = 2(error not found).
> Thanks for any help offered and I am currently using SQL Server 2000
> Thanks PD|||Hi,
Thanks for the quick reply, yes I do have the last backup of the database,
the databases are downloaded to a folder on the SQL Server and then Restored
from there! I can get them to restore but there seems to be problems with
the reliability at the moment! Thats why I thought the error message that I
posted here might have something to do with it
Thanks for you help, Phil
"Uri Dimant" wrote:
> Phil
> When you say "some script to restore them.." , did you mean you was be able
> to restore database? If so , do you have last backup of the database?
>
>
> "Phil" <Phil@.discussions.microsoft.com> wrote in message
> news:9E7F83F5-DC98-497D-ACE0-C781B7304B89@.microsoft.com...
> > Morning All,
> >
> > Rececntly I have been getting quite a few errors on the resotre of my
> > databases, what happens is the files are downloaded from a remote server,
> > unziped and then I run some script to restore them.....this has been
> > working
> > fine for quite some time with no problems whatsoever, until recently where
> > things have been crashing and my databases have been getting set to
> > Single-User mode which I do not want. I thought the failing of the
> > restores
> > might have been a conflict in times of when things happen so I have made
> > some
> > changes where this can not possibly be the issue, and I have now removed
> > the
> > ALTER DATABASE .....SET SINGLE-USER WITH IMMEDIATE ROLLBACK script from
> > my
> > restore process as a temp measure. After all this I am now getting a
> > strange
> > error in the Log Files which I am not really sure what it means so I am
> > hoping someone can help, it says -:
> >
> > BackupDiskFile::OpenMedia: Backup device
> > 'C:\Download\Found' failed to open. Operating
> > syster error = 2(error not found).
> >
> > Thanks for any help offered and I am currently using SQL Server 2000
> >
> > Thanks PD
>
>|||Phil
Don't you perform BACKUP LOG ...?
Have you ran RESTORE HEADERONLY ... before to perfom RESTORE command?
"Phil" <Phil@.discussions.microsoft.com> wrote in message
news:48B6E075-AE9E-4AB8-ADB5-9C958C0588A2@.microsoft.com...
> Hi,
> Thanks for the quick reply, yes I do have the last backup of the database,
> the databases are downloaded to a folder on the SQL Server and then
> Restored
> from there! I can get them to restore but there seems to be problems with
> the reliability at the moment! Thats why I thought the error message that
> I
> posted here might have something to do with it
>
> Thanks for you help, Phil
> "Uri Dimant" wrote:
>> Phil
>> When you say "some script to restore them.." , did you mean you was be
>> able
>> to restore database? If so , do you have last backup of the database?
>>
>>
>> "Phil" <Phil@.discussions.microsoft.com> wrote in message
>> news:9E7F83F5-DC98-497D-ACE0-C781B7304B89@.microsoft.com...
>> > Morning All,
>> >
>> > Rececntly I have been getting quite a few errors on the resotre of my
>> > databases, what happens is the files are downloaded from a remote
>> > server,
>> > unziped and then I run some script to restore them.....this has been
>> > working
>> > fine for quite some time with no problems whatsoever, until recently
>> > where
>> > things have been crashing and my databases have been getting set to
>> > Single-User mode which I do not want. I thought the failing of the
>> > restores
>> > might have been a conflict in times of when things happen so I have
>> > made
>> > some
>> > changes where this can not possibly be the issue, and I have now
>> > removed
>> > the
>> > ALTER DATABASE .....SET SINGLE-USER WITH IMMEDIATE ROLLBACK script
>> > from
>> > my
>> > restore process as a temp measure. After all this I am now getting a
>> > strange
>> > error in the Log Files which I am not really sure what it means so I am
>> > hoping someone can help, it says -:
>> >
>> > BackupDiskFile::OpenMedia: Backup device
>> > 'C:\Download\Found' failed to open. Operating
>> > syster error = 2(error not found).
>> >
>> > Thanks for any help offered and I am currently using SQL Server 2000
>> >
>> > Thanks PD
>>|||Windows Error codes are listed here:
http://www.support.tabs3.com/main/R10307.htm
Error code 2 means file not found.
Paul
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23xFWWtF6GHA.5068@.TK2MSFTNGP06.phx.gbl...
> Phil
> Don't you perform BACKUP LOG ...?
> Have you ran RESTORE HEADERONLY ... before to perfom RESTORE command?
>
> "Phil" <Phil@.discussions.microsoft.com> wrote in message
> news:48B6E075-AE9E-4AB8-ADB5-9C958C0588A2@.microsoft.com...
>> Hi,
>> Thanks for the quick reply, yes I do have the last backup of the
>> database,
>> the databases are downloaded to a folder on the SQL Server and then
>> Restored
>> from there! I can get them to restore but there seems to be problems
>> with
>> the reliability at the moment! Thats why I thought the error message
>> that I
>> posted here might have something to do with it
>>
>> Thanks for you help, Phil
>> "Uri Dimant" wrote:
>> Phil
>> When you say "some script to restore them.." , did you mean you was be
>> able
>> to restore database? If so , do you have last backup of the database?
>>
>>
>> "Phil" <Phil@.discussions.microsoft.com> wrote in message
>> news:9E7F83F5-DC98-497D-ACE0-C781B7304B89@.microsoft.com...
>> > Morning All,
>> >
>> > Rececntly I have been getting quite a few errors on the resotre of my
>> > databases, what happens is the files are downloaded from a remote
>> > server,
>> > unziped and then I run some script to restore them.....this has been
>> > working
>> > fine for quite some time with no problems whatsoever, until recently
>> > where
>> > things have been crashing and my databases have been getting set to
>> > Single-User mode which I do not want. I thought the failing of the
>> > restores
>> > might have been a conflict in times of when things happen so I have
>> > made
>> > some
>> > changes where this can not possibly be the issue, and I have now
>> > removed
>> > the
>> > ALTER DATABASE .....SET SINGLE-USER WITH IMMEDIATE ROLLBACK script
>> > from
>> > my
>> > restore process as a temp measure. After all this I am now getting a
>> > strange
>> > error in the Log Files which I am not really sure what it means so I
>> > am
>> > hoping someone can help, it says -:
>> >
>> > BackupDiskFile::OpenMedia: Backup device
>> > 'C:\Download\Found' failed to open. Operating
>> > syster error = 2(error not found).
>> >
>> > Thanks for any help offered and I am currently using SQL Server 2000
>> >
>> > Thanks PD
>>
>|||Hi Uri,
No I dont perform a BACKUP LOG, the database that I download comes from a
completely different company from the one that I work for and during the day
they perform (Complete Backups) and then we download them as zip files where
I then unpack them and restore over the top of the previous one. The script
that I have loads all the backups names into a table for a specific database
that I want to restore and lists them by date and picks the most recent
backup to restore!
Thanks Phil
"Uri Dimant" wrote:
> Phil
> Don't you perform BACKUP LOG ...?
> Have you ran RESTORE HEADERONLY ... before to perfom RESTORE command?
>
> "Phil" <Phil@.discussions.microsoft.com> wrote in message
> news:48B6E075-AE9E-4AB8-ADB5-9C958C0588A2@.microsoft.com...
> > Hi,
> >
> > Thanks for the quick reply, yes I do have the last backup of the database,
> > the databases are downloaded to a folder on the SQL Server and then
> > Restored
> > from there! I can get them to restore but there seems to be problems with
> > the reliability at the moment! Thats why I thought the error message that
> > I
> > posted here might have something to do with it
> >
> >
> > Thanks for you help, Phil
> >
> > "Uri Dimant" wrote:
> >
> >> Phil
> >> When you say "some script to restore them.." , did you mean you was be
> >> able
> >> to restore database? If so , do you have last backup of the database?
> >>
> >>
> >>
> >>
> >> "Phil" <Phil@.discussions.microsoft.com> wrote in message
> >> news:9E7F83F5-DC98-497D-ACE0-C781B7304B89@.microsoft.com...
> >> > Morning All,
> >> >
> >> > Rececntly I have been getting quite a few errors on the resotre of my
> >> > databases, what happens is the files are downloaded from a remote
> >> > server,
> >> > unziped and then I run some script to restore them.....this has been
> >> > working
> >> > fine for quite some time with no problems whatsoever, until recently
> >> > where
> >> > things have been crashing and my databases have been getting set to
> >> > Single-User mode which I do not want. I thought the failing of the
> >> > restores
> >> > might have been a conflict in times of when things happen so I have
> >> > made
> >> > some
> >> > changes where this can not possibly be the issue, and I have now
> >> > removed
> >> > the
> >> > ALTER DATABASE .....SET SINGLE-USER WITH IMMEDIATE ROLLBACK script
> >> > from
> >> > my
> >> > restore process as a temp measure. After all this I am now getting a
> >> > strange
> >> > error in the Log Files which I am not really sure what it means so I am
> >> > hoping someone can help, it says -:
> >> >
> >> > BackupDiskFile::OpenMedia: Backup device
> >> > 'C:\Download\Found' failed to open. Operating
> >> > syster error = 2(error not found).
> >> >
> >> > Thanks for any help offered and I am currently using SQL Server 2000
> >> >
> >> > Thanks PD
> >>
> >>
> >>
>
>

Error in loading RPT files

I need your help

Having these errors when my application is trying to load rpt files. On my workstation it works perfectly but after I create a setup and install it on another machine i get these errors.

VB6 + CR 9.2 + Visual studio Package and Deployment.

The instruction at "0x7c93426d" referenced memory at "0x00000000". The memory could not be "read".

The instruction at "0x3b48b401" referenced memory at "0x03d4b000". The memory could not be "written".

Dim Crapp As New CRAXDDRT.Application
Dim oReport As New CRAXDDRT.Report

Set Crapp = New CRAXDDRT.Application
Set oReport = New CRAXDDRT.Report

PFld = Trim(Text1.Text)

oReport.DiscardSavedData
oReport.EnableParameterPrompting = False

'Set oReport = crApp.OpenReport(App.Path & "\" & RptPath)
oReport.ParameterFields(1).AddCurrentValue PFld

oReport.ReadRecords

Me.MousePointer = vbHourglass
With Form2.CRViewer91

.ReportSource = oReport
.ViewReport
.Refresh
End With

set crapp = nothing
set oreport = nothing

Me.MousePointer = vbArrow
Unload Me
Form2.ShowAnyone Please I need your help.

Please.

Friday, February 24, 2012

Error in BOL after last windows update

Hello All,
I ran windows update last night and now anytime I go to SQL Server Books
Online it errors on loading HTML Help hh.exe. It will also take down
Enterprise manager or Query Analyzer if I attempt to launch BOL from those
tools.
Any thoughts.
My plan is to reinstall BOL this evening but has anyone else had this
behavior>
Thanks,
LPHi
The Windows Help component was updated with the Windows Security release
yesterday.
It might have become an issue, but I will test it later today.
Regards
Mike
"LP" wrote:
> Hello All,
> I ran windows update last night and now anytime I go to SQL Server Books
> Online it errors on loading HTML Help hh.exe. It will also take down
> Enterprise manager or Query Analyzer if I attempt to launch BOL from those
> tools.
> Any thoughts.
> My plan is to reinstall BOL this evening but has anyone else had this
> behavior>
> Thanks,
> LP|||Thanks,
I'd rather not have to reinstall BOL but I do use it often.
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> The Windows Help component was updated with the Windows Security release
> yesterday.
> It might have become an issue, but I will test it later today.
> Regards
> Mike
> "LP" wrote:
> > Hello All,
> >
> > I ran windows update last night and now anytime I go to SQL Server Books
> > Online it errors on loading HTML Help hh.exe. It will also take down
> > Enterprise manager or Query Analyzer if I attempt to launch BOL from those
> > tools.
> >
> > Any thoughts.
> >
> > My plan is to reinstall BOL this evening but has anyone else had this
> > behavior>
> >
> > Thanks,
> >
> > LP|||If you do end up reinstalling BOL, please make sure you get the latest
version at
http://www.microsoft.com/downloads/details.aspx?FamilyID=a6f79cb1-a420-445f-8a4b-bd77a7da194b&DisplayLang=en
--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
"LP" <LP@.discussions.microsoft.com> wrote in message
news:03353C12-95B1-4AFC-9D0A-B8057B791856@.microsoft.com...
> Thanks,
> I'd rather not have to reinstall BOL but I do use it often.
>
> "Mike Epprecht (SQL MVP)" wrote:
>> Hi
>> The Windows Help component was updated with the Windows Security release
>> yesterday.
>> It might have become an issue, but I will test it later today.
>> Regards
>> Mike
>> "LP" wrote:
>> > Hello All,
>> >
>> > I ran windows update last night and now anytime I go to SQL Server
>> > Books
>> > Online it errors on loading HTML Help hh.exe. It will also take down
>> > Enterprise manager or Query Analyzer if I attempt to launch BOL from
>> > those
>> > tools.
>> >
>> > Any thoughts.
>> >
>> > My plan is to reinstall BOL this evening but has anyone else had this
>> > behavior>
>> >
>> > Thanks,
>> >
>> > LP|||Hi
On the systems I have, from XP to Server 2003, I found no problem.
Install the latest BOL and see if it fixes your problem.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Gail Erickson [MS]" <gaile@.online.microsoft.com> wrote in message
news:uiowUTO#EHA.1524@.TK2MSFTNGP09.phx.gbl...
> If you do end up reinstalling BOL, please make sure you get the latest
> version at
>
http://www.microsoft.com/downloads/details.aspx?FamilyID=a6f79cb1-a420-445f-8a4b-bd77a7da194b&DisplayLang=en
> --
> Gail Erickson [MS]
> SQL Server Documentation Team
> This posting is provided "AS IS" with no warranties, and confers no rights
> "LP" <LP@.discussions.microsoft.com> wrote in message
> news:03353C12-95B1-4AFC-9D0A-B8057B791856@.microsoft.com...
> > Thanks,
> >
> > I'd rather not have to reinstall BOL but I do use it often.
> >
> >
> > "Mike Epprecht (SQL MVP)" wrote:
> >
> >> Hi
> >>
> >> The Windows Help component was updated with the Windows Security
release
> >> yesterday.
> >> It might have become an issue, but I will test it later today.
> >>
> >> Regards
> >> Mike
> >>
> >> "LP" wrote:
> >>
> >> > Hello All,
> >> >
> >> > I ran windows update last night and now anytime I go to SQL Server
> >> > Books
> >> > Online it errors on loading HTML Help hh.exe. It will also take down
> >> > Enterprise manager or Query Analyzer if I attempt to launch BOL from
> >> > those
> >> > tools.
> >> >
> >> > Any thoughts.
> >> >
> >> > My plan is to reinstall BOL this evening but has anyone else had this
> >> > behavior>
> >> >
> >> > Thanks,
> >> >
> >> > LP
>

Error in BOL after last windows update

Sunday, February 19, 2012

Error in Application log

Windows XP Pro and SQL Server Personal 2000 with sp3
I get three errors that are very similar
I would appreciate some guidance
Unprotection of auditable protected data.
Data Description: SQL Server Registration
Key Identifier: 96b4b79c-9197-4c12-a733-d773753fedd8
Protected Data Flags: 0x0
Protection Algorithms: 3DES-168 , SHA1-160
Failure Reason: 0x8009000B
For more information, see Help and Support Center atHi Mark,
The problem seems to be related to Protected Storage and password, OS
security feature. Have you performed an administrative password reset or
change password?
On Windows XP, Protected Storage uses the user's password exclusively to
encrypt user data, such as RSA private keys for current user key container.
Whenever the user password is changed, Protected Storage subsystem is
automatically notified of
this event, and is supplied with both the old and new passwords. This
allows Protected Storage to decrypt all of its master keys with the old
password, and re-encrypt them using the new password.
Prior to Windows XP, a machine secret was used by Protected Storage to
encrypt the master RSA keys rather than the user password exclusively.
Using a machine secret made Protected Storage more robust, but the user
data could be accessed by anyone with local administrative access to the
machine.
If you use the standard change password mechanism by entering the old and
new passwords, everything will work fine. If you performed an
administrative password reset, the old password is not available, and so
access to the master keys is lost. This is by design in Windows XP. In this
scenario, CryptAcquireContext() API will fail with NTE_BAD_KEYSET
(80090016), even if the key container already exists and the caller has
permissions to open the key container.
You will also get a "Failure Audit" 599 Event ID in the Security Log with
the following description
Unprotection of auditable protected data.
Data Description: Export Flag
Key Identifier: 38fb8fc8-7c1e-40bc-aa8f-00d94ef0056e
Protected Data Flags: 0x0
Protection Algorithms: 3DES-168 , SHA1-160
Failure Reason: 0x8009000B
It is best to post in Windows-specific newsgroups for accurate information.
I am providing the information based on my research.
1. One could use Password Recovery Disk as explained in Q290260, if the
customer already made one and if this is a Windows XP-based computer that
is member of a workgroup.
2. If the user puts their password back to what it was originally when the
key container/RSA key pair was initially created, then everything will work
fine thereafter.
290260 EFS, Credentials, and Private Keys from Certificates Are Unavailable
http://support.microsoft.com/?id=290260
Bill Cheng
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
--
| From: "Mark A Gregory" <mgregory@.gt.com.au>
| Subject: Error in Application log
| Date: Fri, 1 Aug 2003 22:13:48 +1000
| Lines: 23
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| Message-ID: <u8JveZCWDHA.1480@.tk2msftngp13.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: 203.34.248.5
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.server:299038
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| Windows XP Pro and SQL Server Personal 2000 with sp3
|
| I get three errors that are very similar
| I would appreciate some guidance
|
|
| Unprotection of auditable protected data.
|
| Data Description: SQL Server Registration
|
| Key Identifier: 96b4b79c-9197-4c12-a733-d773753fedd8
|
| Protected Data Flags: 0x0
|
| Protection Algorithms: 3DES-168 , SHA1-160
|
| Failure Reason: 0x8009000B
|
|
|
| For more information, see Help and Support Center at
|
|
||||Hi Mark,
The problem seems to be related to Protected Storage and password, OS
security feature. Have you performed an administrative password reset or
change password?
It is best to re-post this issue in Windows-specific newsgroups for
accurate information since this newsgroup focuses on SQL Server specific
issues only.
I've included some information for your reference based on my research.
1. One could use Password Recovery Disk as explained in Q290260, if the
customer already made one and if this is a Windows XP-based computer that
is member of a workgroup.
2. If the user puts their password back to what it was originally when the
key container/RSA key pair was initially created, then everything will work
fine thereafter.
290260 EFS, Credentials, and Private Keys from Certificates Are Unavailable
http://support.microsoft.com/?id=290260
If the information does not help, please re-post in the
microsoft.public.windowsxp.security_admin or
microsoft.public.windowsxp.general for a better response. The reason why we
recommend posting appropriately is you will get the most qualified pool of
respondents, and other customers who use the newsgroups regularly can
either share their knowledge or learn from your interaction with us.
On Windows XP, Protected Storage uses the user's password exclusively to
encrypt user data, such as RSA private keys for current user key container.
Whenever the user password is changed, Protected Storage subsystem is
automatically notified of this event, and is supplied with both the old and
new passwords. This allows Protected Storage to decrypt all of its master
keys with the old password, and re-encrypt them using the new password.
Prior to Windows XP, a machine secret was used by Protected Storage to
encrypt the master RSA keys rather than the user password exclusively.
Using a machine secret made Protected Storage more robust, but the user
data could be accessed by anyone with local administrative access to the
machine.
If you use the standard change password mechanism by entering the old and
new passwords, everything will work fine. If you performed an
administrative password reset, the old password is not available, and so
access to the master keys is lost. This is by design in Windows XP. In this
scenario, CryptAcquireContext() API will fail with NTE_BAD_KEYSET
(80090016), even if the key container already exists and the caller has
permissions to open the key container.
You will also get a "Failure Audit" 599 Event ID in the Security Log with
the following description
Unprotection of auditable protected data.
Data Description: Export Flag
Key Identifier: 38fb8fc8-7c1e-40bc-aa8f-00d94ef0056e
Protected Data Flags: 0x0
Protection Algorithms: 3DES-168 , SHA1-160
Failure Reason: 0x8009000B
Bill Cheng
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
--
| From: "Mark A Gregory" <mgregory@.gt.com.au>
| Subject: Error in Application log
| Date: Fri, 1 Aug 2003 22:13:48 +1000
| Lines: 23
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| Message-ID: <u8JveZCWDHA.1480@.tk2msftngp13.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: 203.34.248.5
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.server:299038
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| Windows XP Pro and SQL Server Personal 2000 with sp3
|
| I get three errors that are very similar
| I would appreciate some guidance
|
|
| Unprotection of auditable protected data.
|
| Data Description: SQL Server Registration
|
| Key Identifier: 96b4b79c-9197-4c12-a733-d773753fedd8
|
| Protected Data Flags: 0x0
|
| Protection Algorithms: 3DES-168 , SHA1-160
|
| Failure Reason: 0x8009000B
|
|
|
| For more information, see Help and Support Center at
|
|
|

Friday, February 17, 2012

Error help when deploying a cube

I'm getting an error message and i'm not sure what it's trying to tell me.

Errors

Warning 1 Errors in the OLAP storage engine: The attribute key cannot be found: Table: dbo_rpt_vr_flat_cmb_ih_so, Column: idcol, Value: 441183. 0 0

Warning 2 Errors in the OLAP storage engine: The record was skipped because the attribute key was not found. Attribute: Rpt Vr Flat Cmb Ih So of Dimension: Rpt Vr Flat Cmb Ih So from Database: sdw4, Cube: SDW, Measure Group: Rpt Vr Flat Cmb Ih So, Partition: Rpt Vr Flat Cmb Ih So, Record: 441183. 0 0

Error 3 Errors in the OLAP storage engine: The process operation ended because the number of errors encountered during processing reached the defined limit of allowable errors for the operation. 0 0

Error 4 Errors in the OLAP storage engine: An error occurred while processing the 'Rpt Vr Flat Cmb Ih So' partition of the 'Rpt Vr Flat Cmb Ih So' measure group for the 'SDW' cube from the sdw4 database. 0 0

Error 5 Errors in the OLAP storage engine: The process operation ended because the number of errors encountered during processing reached the defined limit of allowable errors for the operation. 0 0

-background-

My cube is just one flat table the only linking it has is to a time table. This table is put together over night for users to query off of, and when we built this table a primary key wasn't a option so we added a auto incermenting col just to give us a key and that is the key is called idcol which i think is telling me something is wrong with that record. but i'm not sure.

suggestions?

Hello! A guess is that you have a factrecord with a time key that is not in the time table/flat file.

HTH

Thomas Ivarsson

Error Handling with SQLDataSource

Hello to all

I am having a SQLDataSource on my web page to connect with database. Now If it generates any error then where to capture that errors ?? Means at which place(which event or any other place) should i write code for handeling errors ?

Which programming language (e.g. C#) do you use for your web page? In C#, you can use a 'try...catch' block to catch the exception when connect to SQLDataSource; you can perform the connection action in a 'button click' event or in page load event as you like.|||

Yes I know in C# I can use Try--catch. But on which event Do I use Try and Catct ?

If I use this on "selecting " it does not have any effect...

|||Yeah im also wondering how to do this.

The sql data source is loaded when the page loads and runs the select command, so it is not run when a button is pressed.|||You can handle the error on the Inserted, Deleted and Updated events. (They all have Exception properties, and if you handle it, you can set ExceptionHandled to true.)|||Hi,

I have a similar question : How do I handleconnection exceptions ?

mpswaim:
You can handle the error on the Inserted,Deleted and Updated events. (They all have Exception properties, and ifyou handle it, you can set ExceptionHandled to true.)

When the server is unavailable, the exception property of the selected event is null.

Thanks,

Loïc

error handling with linked servers

Hi,
Could someone please tell me how to correctly manage errors with
linked servers?
I make an insert in a linked server. When a foreign key is violated
the whole batch is
aborted so I could not manage the error as I do on a standard server.
I mean:
locally this works fine and I always see the print:
insert into MYDB.dbo.MYTABLE values (100,99)
if @.@.error <> 0
print 'an error happened!!!'
Msg 547, Level 16, State 0, Line 2
The INSERT statement conflicted with the FOREIGN KEY constraint
"FK_XXX". The conflict occurred in database "MYDB", table
"dbo.MYTABLE", column '_Id'.
The statement has been terminated.
an error happened!!!
on the contrary with a linked server the following code doesn't show
any print:
insert into LINKEDSRV.MYDB.dbo.MYTABLE values (100,99)
if @.@.error <> 0
print 'an error happened!!!'
The statement has been terminated.
Msg 547, Level 16, State 1, Line 1
The INSERT statement conflicted with the FOREIGN KEY constraint
"FK_XXX". The conflict occurred in database "MYDB", table
"dbo.MYTABLE", column '_Id'.
Thanks in advance for any kind suggestion,
Stefano
The batch is aborted with the linked server error due to the SET XACT_ABORT
ON setting, which is required here. If you are using SQL 2005, you can use
a TRY...CATCH block to trap the error in T-SQL. I believe the error must be
handled on the client side in SQL 2000.
Hope this helps.
Dan Guzman
SQL Server MVP
<stefano.figurelli@.gmail.com> wrote in message
news:36b3d389-0d49-428a-91fb-16814832b35d@.q39g2000hsf.googlegroups.com...
> Hi,
> Could someone please tell me how to correctly manage errors with
> linked servers?
> I make an insert in a linked server. When a foreign key is violated
> the whole batch is
> aborted so I could not manage the error as I do on a standard server.
> I mean:
>
> locally this works fine and I always see the print:
> insert into MYDB.dbo.MYTABLE values (100,99)
> if @.@.error <> 0
> print 'an error happened!!!'
> Msg 547, Level 16, State 0, Line 2
> The INSERT statement conflicted with the FOREIGN KEY constraint
> "FK_XXX". The conflict occurred in database "MYDB", table
> "dbo.MYTABLE", column '_Id'.
> The statement has been terminated.
> an error happened!!!
>
> on the contrary with a linked server the following code doesn't show
> any print:
> insert into LINKEDSRV.MYDB.dbo.MYTABLE values (100,99)
> if @.@.error <> 0
> print 'an error happened!!!'
>
> The statement has been terminated.
> Msg 547, Level 16, State 1, Line 1
> The INSERT statement conflicted with the FOREIGN KEY constraint
> "FK_XXX". The conflict occurred in database "MYDB", table
> "dbo.MYTABLE", column '_Id'.
>
> Thanks in advance for any kind suggestion,
> Stefano
|||Hi Dan,
thank you for your replay.
Now I understand: this is the correct behaviour with SET XACT_ABORT ON
which is implicitly
used by most OLD DB Providers.
Locally it works because SET XACT_ABORT is OFF by default.
Unfortunately I have to deal with SQL 2000 not 2005.
I could not (I think) handle this easly on the application because
this happens inside stored
procedures and I do not want to change a lot of code.
Since I have some possibility on the linked side I will create some
procedures on the target
database and call the remotely. These procedure on the remote side
will be able to handle
the violation.
I this this could be ok... do you agre?
Thanks again,
Stefano
|||> Since I have some possibility on the linked side I will create some
> procedures on the target
> database and call the remotely. These procedure on the remote side
> will be able to handle
> the violation.
> I this this could be ok... do you agre?
I have not done this myself but I think this approach might work. You'll
need to enable linked server rpc calls.
Hope this helps.
Dan Guzman
SQL Server MVP
<stefano.figurelli@.gmail.com> wrote in message
news:dfedf9ed-3d7d-41c4-a2b5-334cbb52cb47@.f47g2000hsd.googlegroups.com...
> Hi Dan,
> thank you for your replay.
> Now I understand: this is the correct behaviour with SET XACT_ABORT ON
> which is implicitly
> used by most OLD DB Providers.
> Locally it works because SET XACT_ABORT is OFF by default.
> Unfortunately I have to deal with SQL 2000 not 2005.
> I could not (I think) handle this easly on the application because
> this happens inside stored
> procedures and I do not want to change a lot of code.
> Since I have some possibility on the linked side I will create some
> procedures on the target
> database and call the remotely. These procedure on the remote side
> will be able to handle
> the violation.
> I this this could be ok... do you agre?
> Thanks again,
> Stefano
|||ok, thanks!

Thursday, March 29, 2012

error loading the report in the designer

Error loading metadata....PLZZ HELP!!

Error List, Sql Server 2005

Error Installing Workstation Components SQL 2005 Enterprise

Error Installing Workstation Components SQL 2005 Enterprise

Error Installing Workstation Components SQL 2005 Enterprise

Error Installing Workstation Components SQL 2005 Enterprise

Monday, March 19, 2012

Error in restoring SSAS database

Sunday, March 11, 2012

Error in Processing Cube while ROLAP Storage

Friday, March 9, 2012

Error In Log

Error In Log

Error In Log

Error in loading RPT files

Friday, February 24, 2012

Error in BOL after last windows update

Error in BOL after last windows update

Error in BOL after last windows update

Sunday, February 19, 2012

Error in Application log

Friday, February 17, 2012

Error help when deploying a cube

Error Handling with SQLDataSource

error handling with linked servers

error handling flow

Blog Archive

About Me