Error 8905

I am getting a lot of corruption reports in my database and the performance
is down dramatically. The MS support site says I can fix this this a
checkdb repair with data loss. I run the repair over and over and no
change.
CHECKALLOC found 951 allocation errors and 0 consistency errors in database
'envision'.
repair_allow_data_loss is the minimum repair level for the errors found by
DBCC CHECKALLOC (envision ).
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
We are on SQL 2000 service pack 4.
Any ideas'
Thanks!
RichardResolving Errors
If DBCC CHECKALLOC reports any errors, we recommend that you restore the
database from the database backup instead of running a repair. If a backup
does not exist, running a repair can correct the reported errors; however,
correcting the errors might require some pages, and therefore data, to be
deleted.
A repair can be performed in a user transaction. This allows for changes to
be rolled back. If changes are rolled back, the database will still contain
errors and must be restored from a backup. After the repairs finish, back up
the database.
Good luck!
I drank alot of beer and ended up in the police department database.
Drank more beer and learned SQL in the dark hours.
DELETE FROM offenders WHERE Title=''MrAA'' AND Year=2006;
I love SQL
"Richard Douglass" wrote:

> I am getting a lot of corruption reports in my database and the performanc
e
> is down dramatically. The MS support site says I can fix this this a
> checkdb repair with data loss. I run the repair over and over and no
> change.
> CHECKALLOC found 951 allocation errors and 0 consistency errors in databas
e
> 'envision'.
> repair_allow_data_loss is the minimum repair level for the errors found by
> DBCC CHECKALLOC (envision ).
> DBCC execution completed. If DBCC printed error messages, contact your
> system administrator.
> We are on SQL 2000 service pack 4.
> Any ideas'
> Thanks!
> Richard
>
>

Error 8905

I am getting a lot of corruption reports in my database and the performance
is down dramatically. The MS support site says I can fix this this a
checkdb repair with data loss. I run the repair over and over and no
change.
CHECKALLOC found 951 allocation errors and 0 consistency errors in database
'envision'.
repair_allow_data_loss is the minimum repair level for the errors found by
DBCC CHECKALLOC (envision ).
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
We are on SQL 2000 service pack 4.
Any ideas?
Thanks!
Richard
Resolving Errors
If DBCC CHECKALLOC reports any errors, we recommend that you restore the
database from the database backup instead of running a repair. If a backup
does not exist, running a repair can correct the reported errors; however,
correcting the errors might require some pages, and therefore data, to be
deleted.
A repair can be performed in a user transaction. This allows for changes to
be rolled back. If changes are rolled back, the database will still contain
errors and must be restored from a backup. After the repairs finish, back up
the database.
Good luck!
I drank alot of beer and ended up in the police department database.
Drank more beer and learned SQL in the dark hours.
DELETE FROM offenders WHERE Title=''MrAA'' AND Year=2006;
I love SQL
"Richard Douglass" wrote:

> I am getting a lot of corruption reports in my database and the performance
> is down dramatically. The MS support site says I can fix this this a
> checkdb repair with data loss. I run the repair over and over and no
> change.
> CHECKALLOC found 951 allocation errors and 0 consistency errors in database
> 'envision'.
> repair_allow_data_loss is the minimum repair level for the errors found by
> DBCC CHECKALLOC (envision ).
> DBCC execution completed. If DBCC printed error messages, contact your
> system administrator.
> We are on SQL 2000 service pack 4.
> Any ideas?
> Thanks!
> Richard
>
>

Error 500, Not Enough memory (Really Emergency)

hi everybody,

I am using delphi 7 and Crystal Reports 9. I am exporting some Crystal reports which connect to the Oracle DB, but for some reports i am getting this error (Error 500). In crystal report, this reports are running as well... but in delphi i couldn't do it. do you have an idea ?

PS: i searched for this error and found somethings but they dont help me...

thanks.isnt there anyone? thats really emergency for me :(|||Try to run in other pc with more memory to discard that is not really "Not Enough memory"|||There is enough memory... be sure :) i run this program on a server (3 GB memomry)|||Ok, i guess nobody knows this, is there anyone who knows how i could find some info about this?|||it is me again,

I found the reason of this problem :) the reason is OLE Objects. in this reports, one who create this report, used OLE Object (Microsoft Word)..

i deleted the ole object and Application runned very well :)

Error 500 and Error 692 trying to export

I am trying to export a report to PDF and HTML. I am currently using Crystal Reports 8.5, and I'm using the CRPE32 API. On my development machine, this works great. I get PDF files that I can view with Acrobat, and HTML files that come up fine in IE.

However, when I run the same code on a clean machine that doesn't have Crystal installed, I get error 500 returned after PEStartJob fails if I try to export to PDF, and I get error 692 when trying to export to HTML.

I did a search on the web, and there is an article that says error 692 if for unsupported export types, specifically HTML 3.0, which was stopped supporting as of Crystal 8. But, I am trying to export in HTML 4.0, which, like I said before, works fine on my dev box.

The error 500 means out of memory, but it's really just the catch all error code. Crystal sends back error 500 for many, many reasons.

So, it seems like maybe a DLL mismatch or missing DLL or something, but I can't track it down. Anyone have any ideas?You have to make sure you install all the necessary Export dlls on the new machine. Crystal reports 8.5 includes a file called runtime.hlp that lists all of the files needed. You're probably just missing a key dll or something.|||i've looked at the runtime.hlp file, and to the best of my knowledge, all the export dlls are there, with the same date/time stamps as the ones on my dev box|||Okay, I figured out the error 500 problem. I was missing the msvcp71.dll and msvcr71.dll.

But, I'm still having the error 692 problem...|||Look at this:

http://support.businessobjects.com/library/kbase/articles/c2006853.asp

Error 444 - Permission denied.

OK, I'm at a complete loss. Any advice on the following would be greatly
appreciated. What I've got is multiple reports that are heavy process
intensive(multiple datasets, multiple joins, etc). Reports usually take
between 25 and 35 minutes. All was fine until yesterday. Now the reports seem
to run forever. Then finally after an hour we get a 444 error and a
permission denied dialog box. These reports have been running for months
without issue. We've even gone so far as to switch to a new server and still
get the same errors.
Any suggestions?Can you launch SQL Profiler and run a trace and see what connection
credentials are being presented to the dataserver and what the
queries/sprocs are? After capturing the trace you should be able to open
the trace and replay it. My guess is that it is not a SQL issue but this
will help confirm that.
I tried to do some looking up on what error 444 means, is that from MS SQL,
or DB2? or from IIS? Also can you open the Add/Remove Programs, check the
'show updates' box and look for updates installed around the same time as
when the problem started occuring. I've been keeping our machines up to
date and haven't had issue, so not much help here, sorry.
Steve MunLeeuw
"dbutler" <dbutler@.discussions.microsoft.com> wrote in message
news:52C330E6-AEBE-4B59-91C6-99F4E8FD5574@.microsoft.com...
> OK, I'm at a complete loss. Any advice on the following would be greatly
> appreciated. What I've got is multiple reports that are heavy process
> intensive(multiple datasets, multiple joins, etc). Reports usually take
> between 25 and 35 minutes. All was fine until yesterday. Now the reports
> seem
> to run forever. Then finally after an hour we get a 444 error and a
> permission denied dialog box. These reports have been running for months
> without issue. We've even gone so far as to switch to a new server and
> still
> get the same errors.
> Any suggestions?|||I'd also use the RS 2005 Configuration tool to check what accounts are used,
and if they have had a password change or expire. Maybe it's a private key
backup issue...grasping at straws.
Steve MunLeeuw
"dbutler" <dbutler@.discussions.microsoft.com> wrote in message
news:52C330E6-AEBE-4B59-91C6-99F4E8FD5574@.microsoft.com...
> OK, I'm at a complete loss. Any advice on the following would be greatly
> appreciated. What I've got is multiple reports that are heavy process
> intensive(multiple datasets, multiple joins, etc). Reports usually take
> between 25 and 35 minutes. All was fine until yesterday. Now the reports
> seem
> to run forever. Then finally after an hour we get a 444 error and a
> permission denied dialog box. These reports have been running for months
> without issue. We've even gone so far as to switch to a new server and
> still
> get the same errors.
> Any suggestions?|||Thanks Steve. It ended up being exactly that. We switched to a new server,
but our network guy swapped one of the harddrives so it was still 'linked' to
the old server. Once we updated a few keys and played around with RS, we got
it back to working.
"Steve MunLeeuw" wrote:
> I'd also use the RS 2005 Configuration tool to check what accounts are used,
> and if they have had a password change or expire. Maybe it's a private key
> backup issue...grasping at straws.
> Steve MunLeeuw
> "dbutler" <dbutler@.discussions.microsoft.com> wrote in message
> news:52C330E6-AEBE-4B59-91C6-99F4E8FD5574@.microsoft.com...
> > OK, I'm at a complete loss. Any advice on the following would be greatly
> > appreciated. What I've got is multiple reports that are heavy process
> > intensive(multiple datasets, multiple joins, etc). Reports usually take
> > between 25 and 35 minutes. All was fine until yesterday. Now the reports
> > seem
> > to run forever. Then finally after an hour we get a 444 error and a
> > permission denied dialog box. These reports have been running for months
> > without issue. We've even gone so far as to switch to a new server and
> > still
> > get the same errors.
> >
> > Any suggestions?
>
>

Error 20534 "Error detected by database DLL"

hi,

I'm using Crystal reports 8.0 with VB 6.0 and SQL Server 2000..I am getting the error "Error detected by database DLL" We were using SQL server 7.0 earlier and have recently upgraded to SQL 2000.The error appeared after this upgradation.Could anyone please help me with this.I've found some threads related to this error but none of them could solve my problem..Any help would be highly appreciated.

Thanks & Regards,
Ekta Singh.how are you passing the values to the report ? And also, are you using tables or stored procedures in the report ?|||If you installed ur package some where and getting this error then just make a check for the list of DLLs mentioned below, if any of them is not present in ur package then manually add it.

' FOR VB 6.0
MSVBVM50.DLL
MSVBVM60.DLL
msvcp50.dll
msvcp60.dll

'For SQL connection
P2ssql.dll
P2lsql.dll

'For Crystal reports
craxddt.dll
craxdrt.dll
Crpaig80.dll
crviewer.dll
Crxlat32.dll
Implode.dll
itircl.dll
itss.dll
MSADODC.OCX
MSBIND.DLL
MSSTDFMT.DLL
MSVCRT.DLL
MSVCRT40.DLL
msvfw32.dll
OLEAUT32.DLL
OLEPRO32.DLL
P2smon.dll
p2sodbc.dll
p2soledb.dll
SHLWAPI.DLL
sscdlg.dll
sscrc.dll
sscsdk80.dll
STDOLE2.TLB
u252000.dll
u25dts.dll
u2dapp.dll
u2ddisk.dll
u2dmapi.dll
u2dnotes.dll
u2fhtml.dll
u2frtf.dll
u2ftext.dll
u2fwks.dll
u2fwordw.dll
u2fxls.dll
u2l2000.dll
URLMON.DLL

'Not necessary to include
msldbusr.dll
UXDDISK.DLL
UXFDOC.DLL
UXFWKS.DLL
UXFWORDW.DLL

Still if u r facing the same error, then either problem with the connection string or some table or field or SP or view missing.

Make sure and checkout.|||I'm using Crystal reports 8.0 with VB 6.0 and SQL Server 2005..I am getting the error "Error detected by database DLL" when i create a left outer join on the table .
plz answer.....|||I'm using Crystal reports 8.0 with VB 6.0 and SQL Server 2005..I am getting the error "Error detected by database DLL" when i create a left outer join on the table .
plz answer.....

it happens when query is wrong
review your query using query analyzer of SQL server.

error 20534

Hi Everyone,

I am trying to print crystal reports from my VB
program. I have this command in my VB program
CrystalReports1.Action=1. My program is breaking
right here. It is gving me error , Error Detected by
database DLL. Err Msg: 20534. I searched this error
> code in google and saw that I can bypass this errror
> by writing

#Const fDebug = true
Dim logon as integer

On Error GoTo traperror:

With CrystalReport1
.ReportFileName = <path to report file>
logon = .LogOnServer("pdsodbc.dll","<Your
DSN>","","","")
.Action = 1
End With

Traperror:

#If fDebug = true then
If Err.Number = 20534 Then
CrystalReport1.Action = 1
End If
#End If

My program goes in this statement but breaks again
at crystalreport1.action=1. It breaks inside the
trap error label. Please anyone let me know what can
I do to avoid this error.

Any help will be greatly appreciated.

Thanks.Can be caused by a number of things...like ODBC Text Driver in VB6 SP3, like using subreport in your report and not passing login info to subreport, like incorrectly formned parameters, etc.

Given previous experience, I'd bet on a subreport, an incorrectly formed statement passed to .LogonServer, or a dodgy ODBC driver.

You should be using PDB*.DLL for standard (non-SQL) databases, and PDS*.DLL for SQL/ODBC databases....

Dave