Tracing an ODBC Login to AS400 DB400 Database

[former_member861954]

Hi all,

Recently i've been having issue with a connectivity issue that renders the database id on the AS400 DB2/400 database to be disabled. Once disabled, the dba would have to renable the id again and report works fines for a few months and this problem repeats itself. This is issue is quite intermittent and it has been getting more frequent recently. We have checked the the DBA and it says that the userid is disabled because of invalid password that was supplied

The version of CR Runtime that we are using is SP33 and the database connection we are using is the i Series Access ODBC Driver.

I was wondering is there any tracing utility that i can use to track this and anyone encountered such problems in the past.

Cheers,

Ivan

[DellSC]

I assume that you're using a single, common database logon for the reports in your application. Is the password on that account changed on a regular basis? How do you provide the database credentials for the report to your application?

I don't know of any end-to-end tracing available for this. You would have to do logging in your application to identify when report logons are failing.

-Dell

[DonWilliams · Accepted solution]

Simplest way to find info is to use Google and search for it:

https://userapps.support.sap.com/sap/support/knowledge/en/1470978

How to enable/disable crpe logging for the Crystal Reports ....

How to turn on/off crpe logging for the Crystal Reports .NET SDK? ... trace tracing , KBA , BI-DEV-NET , BI Software Development Kits (SDKs) - .

For your error though I doubt you'll find a CR issue, all the logs are going to do is confirm it's failing to log in.

It's a DB2 Client issue, possibly due to Open Connections, most Client use Connection Caching, CR doesn't use them, it requires a new connection each time.

I would suggest enabling DB Logging, it's likely the best place to start and look for reasons.

Don

[former_member861954]

Dell,

Yes, we are using a single login for all the reports and the password doesn't change/expire.

Don,

Thank you for your suggestion, do you have any reference for tracing the crystal report runtime engine too?

Cheers

Ivan

[DonWilliams]

You can enable CRLogger, Crystal Reports database logging component:

https://userapps.support.sap.com/sap/support/knowledge/en/1603398

How to trace data source connections in Crystal Reports and ...

How to use crlogger to generate a log when using Crystal Reports? Environment. SAP Crystal Reports 2013; SAP Crystal Reports 2016; SAP Crystal Reports 2020; Sap ...

https://userapps.support.sap.com/sap/support/knowledge/en/1701312

1701312 - How to analyze CR Logger trace logs - SAP Support ...

How to analyze CR Logger trace logs How to identify a performance bottleneck How to troubleshoot a performance issue with Crystal Report Viewer on ...

It won't tell you much more than you already know though.

As Dell noted it's likely something Server/Client side causing the problem.