Error - TSLV Record Not Found

[Charaka Wijerathne]

Hi All,

 

When I’m creating crystal reports through OR 5.0 systems, I’m getting below error.

 

 

This error happened suddenly.

I’m developing couples of systems (all OR 5.0 + Crystal Report 8.5 + ingres 9.2.1) and now all of them are giving this error.

 

Only 1 change done to pc before this error, uninstalled Kaspersky and installed ESET endpoint antivirus.

This can be the reason for this error ?

Greatly appreciate your advices / suggestions on this.

 

Thanks.

 

 

Best Regards,

Charaka Wijerathne

 

[Doug White]

Hi Charaka

I'd check the following if I was you, and report back to the list with more info if you don't identify the issue.

1) Open the report in crystal reports designer and see run preview, see if it throws the error.

2) Check quarantined files in your new antivirus, if ESET has quarantined or deleted core crystal files you might get this error.

3) Uninstall ESET and see if the report still fails

4) Reinstall the crystal reports runtime and see if the report fails

Best of luck

--
You received this message because you are subscribed to the Google Groups "OpenROAD Users Mailing List" group.
To unsubscribe from this group and stop receiving emails from it, send an email to openroad-user...@googlegroups.com.
To post to this group, send email to openroa...@googlegroups.com.
Visit this group at http://groups.google.com/group/openroad-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/openroad-users/PS1PR06MB11789BF64004DBEA2BC7BEEB920E0%40PS1PR06MB1178.apcprd06.prod.outlook.com.
For more options, visit https://groups.google.com/d/optout.

[Charaka Wijerathne]

Hi Doug,

Thanks for help.

I followed all the steps.
Can open and run reports through Crystal Report Designer application - no errors.

Then deleted, quarantined files, next un-installed ESET antivirus.

Then uninstalled and installed Crystal Report, but still getting same error.

To view this discussion on the web visit https://groups.google.com/d/msgid/openroad-users/CAEOWWi_tT9VQOorLU-bDbNNCT%2B0xoxE9AheeiCqWJPgHowNjsw%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.

--

Regards,

Charaka Wijerathne | Lead Programmer

[Bodo Bergmann]

The errors “Failed to export the report.” and “TSLV Record Not Found.” are definitely coming from Crystal Reports (i.e. its Export method) rather than from OpenROAD.

 

Check that you are testing with the same database connection (ODBC DSN).

Make sure when testing that you are using a 32-bit CR version (as OpenROAD 5.0 is also 32-bit it will use 32-bit COM components).

I would also recommend to search the web for those errors.

 

Bodo.

--

Bodo Bergmann

Senior Software Engineer

Actian | Engineering

Phone: +49.6103.3033.734

www.actian.com

 

GESELLSCHAFTSANGABEN: Geschäftsführer: Steven R. Springsteel, Stephen Mark Padgett, Markus Bockle

Sitz der Gesellschaft: Hamburg| Handelsregister: Amtsgericht Hamburg | HRB 135991| USt-IdNr: DE252449897

To view this discussion on the web visit https://groups.google.com/d/msgid/openroad-users/CAHajRQ7LPvV25HyjnsA5tpWYePPoFfhGZ-FeAqVz%2B19YfpdoPA%40mail.gmail.com.

[Doug White]

Hi Charaka,

We used to get this problem occasionally but I can't quiet remember the cause or resolution.

So I did some googling for you...

The most common cause of this error seems to be parameters getting screwed up on their way to crystal.

I would try the next steps to diagnose : 

1) Debug fm_crt_viewer or the report generation code block and isolate which parameters are being sent to crystal. Ensure these match the parameters you expect in the database.

2) Check your credentials, IIRC you guys populates user credentials from a setting, ensure these haven't changed (they count as parameters apparently)

3) Check your printer config, specifically check to make sure crystal isn't expecting a certain printer. (Another thing that can cause this error)

4) Do a full restart of windows to rule out drivers being fiddled with (sounds stupid but you know... Microsoft)

5) Check windows event log, I believe crystal outputs more detailed logs to windows event logs, see if you can find more details.

It's strange that all of sudden EVERY report is erroring out. This implies either your machine can't connect to somewhere, or your drivers are borked.

Hopefully one of these provides more insight.

Some links

https://www.google.com.au/search?q=crystal+reports+80020009&oq=crystal+reports+80020009&aqs=chrome..69i57.3517j0j7&sourceid=chrome&es_sm=91&ie=UTF-8

http://it.toolbox.com/wiki/index.php/Solve_the_%22Invalid_TLV_Record%22_error_in_running_Crystal_Report

http://www.orbis-software.com/knowledge-base/viewArticle.php?id=171

To view this discussion on the web visit https://groups.google.com/d/msgid/openroad-users/CAHajRQ7LPvV25HyjnsA5tpWYePPoFfhGZ-FeAqVz%2B19YfpdoPA%40mail.gmail.com.

[Charaka Wijerathne]

Hi Bodo, Doug,

 

Thanks for help.

I think I have identified the reason.

It was Windows Update (KB3102429)

 

 

One of my office colleague’s pc, all reports were working fine so, we check all the differences in our softwares.

Then we identified this Windows update.

I uninstalled it and now everything is working fine.

 

Greatly appreciate your support on this.

 

Thanks.

 

 

Best Regards,

Charaka Wijerathne

 

[Bodo Bergmann]

Yeah, others seem to have encountered the same problem, e.g.:
http://www.iris.co.uk/support/knowledgebase/kb/11478

 

Bodo.

[Darren Harvey]

Hi

We have also recently had this problem at several customers, and yes it does relate to recent updates to Fonts installed by Windows Updates.  We have used 'Times New Roman' and 'Arial' in most of our reports, and these are among about a dozen fonts that were updated.  We changed the font to 'Trebuchet MS' and the reports then worked successfully on PC's where they had started failing after the Windows Updates.  

Regards

Darren Harvey | Developer

FUSION5 | Business Application Professionals

M +61 400 398 188 | P+61 3 9922 5528 | F+61 3 9922 5523 | W www.fusion5.com.au
Level 16, 60 Albert Road, South Melbourne, Vic 3205, Australia

Click Herefor our latest Infusion Magazine

 

This email and any attachments are confidential and intended exclusively for the person to whom the email is addressed. If you are not the intended recipient, do not read, copy, disclose or use the contents in any way. Please notify us immediately by return email and destroy the email and all attachments. Fusion5 accepts no responsibility for any alterations made to this e-mail (or accompanying documents) after initial transmission. The opinions expressed are not necessarily those of Fusion5. 

 

P  Please consider the environment before printing this email

 

---

From: openroa...@googlegroups.com <openroa...@googlegroups.com> on behalf of Bodo Bergmann <Bodo.B...@actian.com>
Sent: Wednesday, December 2, 2015 9:13 PM
To: Charaka Wijerathne; douglas...@gmail.com
Cc: paul....@shift7solutions.com.au; Annie Rayen; openroa...@googlegroups.com; openroad-...@lists.ingres.com

To view this discussion on the web visit https://groups.google.com/d/msgid/openroad-users/CO1PR06MB31414B4339F60FBB44E8CA6930E0%40CO1PR06MB314.namprd06.prod.outlook.com.

[Charaka Wijerathne]

Hi Darren,

 

Thanks for details.

I’ll also follow and try this and I accept it is really important to do this because we can force customers to restrict windows updates.

 

Thanks.

 

 

Best Regards,

Charaka Wijerathne