Computer crashing on reporting (need immediate help)

Mr Paul

Delphi Developer

Sun, 28 Sep 2003 18:24:22 GMT

Computer crashing on reporting (need immediate help)

I'm in the process of upgrading a customer site to the newest version of my
company's software. They originally had IB 4.2, upgraded to 5.5 a while back
and now it's time to get them up to 6.0.

I did a DB backup in 5.5, restored in 6.0 and things seemed to be ok. i used
IB Pump to move the old data into the new data file.

I ran our program, and things seemed to be fine until I ran a report. It
caused an AV and was forced to close. So no time that the Quick Report
components are used does it work. the weird thing is that on *any other
computer* the reports have no problem

Also, I'm getting a "DPB Constant(0) is unknown" when attempting to connect
through IB Console. that error, as stated in this newsgroup, will most
likely go away once i get them on the newest version of IB Console. but the
question remains... how come it would only happen on their machine? and the
more crucial question, why is the program crashing when Quick Reports
components are used, and only on that one machine... all other machines will
run the code fine.

This is a major issue that I'm unsure how to resolve and is holding up
production... any help would be *greatly* appreciated.

paul

Douglas Tos

Delphi Developer

Sun, 28 Sep 2003 20:17:28 GMT

Re:Computer crashing on reporting (need immediate help)

Quote

Mr Paul wrote:
> I ran our program, and things seemed to be fine until I ran a report. It
> caused an AV and was forced to close. So no time that the Quick Report
> components are used does it work. the weird thing is that on *any other
> computer* the reports have no problem

Please, give us more information.
What OS, database connectivity components, printer driver ... ?

dog

--
___________________________________________
IMPROART
Rua Emiliano Perneta, 297 - 6 And - Cj. 63
CEP 80050-010 - Curitiba-PR - Brasil
Tel/fax.: 55-41-323-7558

Robert Schiec

Delphi Developer

Sun, 28 Sep 2003 16:45:52 GMT

Re:Computer crashing on reporting (need immediate help)

Quote

In article <3ad43914_2@dnews>, Mr Paul wrote:
> Also, I'm getting a "DPB Constant(0) is unknown" when attempting to connect
> through IB Console. that error, as stated in this newsgroup, will most
> likely go away once i get them on the newest version of IB Console. but the
> question remains... how come it would only happen on their machine? and the
> more crucial question, why is the program crashing when Quick Reports
> components are used, and only on that one machine... all other machines will
> run the code fine.

If you are having the DBP Constant (0) then you have a really old version of
IB 6.x. You should go to http://mers.com to pick up the nightly build or go to
http://www.borland.com/devsupport/interbase/opensource to pick up the January
10th release from Borland.

Robert Schieck (TeamB)
MER Systems Inc.
Inprise/Borland/InterBase Search Engine http://www.mers.com/searchsite.html

Mr Pau

Delphi Developer

Sun, 28 Sep 2003 21:23:35 GMT

Re:Computer crashing on reporting (need immediate help)

i am going to update them to the newest IB today... since it's ODS10, i
won't need to do a backup/restore, correct?

Quote

"Robert Schieck" <rschi...@mers.com> wrote in message

news:VA.0000009a.0daab129@mers.com...

Quote

> In article <3ad43914_2@dnews>, Mr Paul wrote:
> > Also, I'm getting a "DPB Constant(0) is unknown" when attempting to
connect
> > through IB Console. that error, as stated in this newsgroup, will most
> > likely go away once i get them on the newest version of IB Console. but
the
> > question remains... how come it would only happen on their machine? and
the
> > more crucial question, why is the program crashing when Quick Reports
> > components are used, and only on that one machine... all other machines
will
> > run the code fine.

> If you are having the DBP Constant (0) then you have a really old version
of
> IB 6.x. You should go to http://mers.com to pick up the nightly build or
go to
> http://www.borland.com/devsupport/interbase/opensource to pick up the
January
> 10th release from Borland.

> Robert Schieck (TeamB)
> MER Systems Inc.
> Inprise/Borland/InterBase Search Engine

http://www.mers.com/searchsite.html

- Show quoted text -

Quote

Mr Pau

Delphi Developer

Sun, 28 Sep 2003 21:20:22 GMT

Re:Computer crashing on reporting (need immediate help)

OS: Win98SE
BDE 5.11 to access Interbase, using TTables and TQueries.
As for the printer driver, I don't currently have access to that information
but can get it the next time I connect to their machine. However, the older
version of my company's software that i am replacing also has the
QuickReport components (older versions obviously). I connect to their
computer using PCAnywhere and an installer was at the location as well. I
had the newest IB server on a CD that the installer had, however the
computer is in a highly-polluted industrial area and the CD-ROM would not
read because of all the soot in the machine. I transferred the other option
I had which was an older IB setup version (6.0.0.627) and installed from
that. I don't expect that would be causing the current problems since I'd
used that older version before. The older version of our software with QR
works. The current version of our software with QR works on other machines.

Is it likely that it is related to the fact that there were all those older
versions installed? or does anyone know if QR has problems when memory runs
out (the machine is unfortunately old. 64 ram, 233 processor).

thanks for the response.

Quote

> > I ran our program, and things seemed to be fine until I ran a report. It
> > caused an AV and was forced to close. So no time that the Quick Report
> > components are used does it work. the weird thing is that on *any other
> > computer* the reports have no problem

> Please, give us more information.
> What OS, database connectivity components, printer driver ... ?

> dog

Robert Schiec

Delphi Developer

Sun, 28 Sep 2003 18:15:22 GMT

Re:Computer crashing on reporting (need immediate help)

Quote

In article <3ad45a2f$1_1@dnews>, Mr Paul wrote:
> i am going to update them to the newest IB today... since it's ODS10, i
> won't need to do a backup/restore, correct?

Always backup on the old verison, install the new version and then
restore. Don't forget to backup your isc4.gdb database as well.

Robert Schieck (TeamB)
MER Systems Inc.
Inprise/Borland/InterBase Search Engine
http://www.mers.com/searchsite.html

Douglas Tos

Delphi Developer

Sun, 28 Sep 2003 23:12:42 GMT

Re:Computer crashing on reporting (need immediate help)

Quote

Mr Paul wrote:
> OS: Win98SE
> BDE 5.11 to access Interbase, using TTables and TQueries.
> As for the printer driver, I don't currently have access to that information
> but can get it the next time I connect to their machine.
> ...

Seems like a QR problem to me. It is sooo good that if you, for instance, try to
preview a report on a machine with no printer installed, you get an AV.
I'm using it a lot (although I don't like it) on slow machines with no problems
(even 16MB 486s!), so the problem is probably related to OS config and other
installed software, not the hardware itself.

Sorry if this is not of much help.

regards,

dog
___________________________________________
IMPROART
Rua Emiliano Perneta, 297 - 6 And - Cj. 63
CEP 80050-010 - Curitiba-PR - Brasil
Tel/fax.: 55-41-323-7558

Mr Pau

Delphi Developer

Sun, 28 Sep 2003 22:45:22 GMT

Re:Computer crashing on reporting (need immediate help)

Quote

> > i am going to update them to the newest IB today... since it's ODS10, i
> > won't need to do a backup/restore, correct?

> Always backup on the old verison, install the new version and then
> restore. Don't forget to backup your isc4.gdb database as well.

even when it's still 6.0? just now 6.01? i should still do a backup,restore?
(the db is huge and the computer is slow so i'd like to avoid if not needed)

Robert Schiec

Delphi Developer

Sun, 28 Sep 2003 20:35:44 GMT

Re:Computer crashing on reporting (need immediate help)

Quote

In article <3ad46d60_1@dnews>, Mr Paul wrote:
> even when it's still 6.0? just now 6.01? i should still do a backup,restore?
> (the db is huge and the computer is slow so i'd like to avoid if not needed)

I would back it up just to be safe. I cannot remember if there was an ODS
change between the original 6.0 and the latest.... So than answer is yes and
no. Yes you can get by without backing up and restoring but you might run into
problems...

hth

Robert Schieck (TeamB)
MER Systems Inc.
Inprise/Borland/InterBase Search Engine http://www.mers.com/searchsite.html

Other Threads

1. Need immediate help with design time crash!!!

2. Immediate help needed!!!!

3. Fw: need immediate help compiling programs

4. need immediate help compiling programs

5. Help, I'm loosing Paradox-records after a computer-crash

6. Delphi 3.0 crashes on my new computer ... help :(((

7. Need help with running programs on a fast computer

8. Grade 11 Computer science student needs HELP!!!

9. help needed with a computer studies project.

10. Need help with stack crash!