Troubleshooting: Blank result is shown for transaction log

LINKS

General

Apex SQL Audit
Apex SQL Clean
Apex SQL Code
Apex SQL Diff
Apex SQL Diff Data
Apex SQL Doc
Apex SQL Edit
Apex SQL Enforce
Apex SQL Log
Apex SQL Recover
Apex SQL Report
Apex SQL Script

Troubleshooting Home

SITE FEED

Site Feed

Support Forum

The fastest and most effective to get answers to your questions quickly. Click Here for more info.

FAQs

Quick answers to common questions. Click Here for more info.

Troubleshooting

Known issues and basic troubleshooting techniques for problems or unexpected behaviors. Click Here for more info.

Knowledgebase

Technical tips, How-to articles, and other tutorials about ApexSQL Tools. Click Here for more info.

Online Documentation

All of our help files for download or convenient viewing online. Click Here for more info.

Videos

Watch product demos, training videos, or tutorials of our products' main features. We frequently upload new videos so check often for updates. Click Here for more info.

Troubleshooting

Troubleshooting and Known issues with Apex SQL Tools

Blank result is shown for transaction log

I am opening a log using AlexSQL Log application and it is not showing anything as if Tran. log backup file is empty.

SYMPTOMS
The following error symptoms are indicates that result will be empty:

Call to xproc xp_ApexSQLLog(1) failed: ExecQuery failed: ApexSqlServerHelper failed: OpenSCManager()failed: Access is denied. (error code = 5)
Application log contains the following records:
2007-07-27 19:49:36.115 5000 2224 INFO : Excluded <number> for selected tables

RESOLUTION
Here it is the steps to solve the problem with 'Access is denied' message:

The problem lies is what permissions has the user account running SQL Server service - this is independent of what user account is connected to the server. To work around this you will need to do the following:
- On the server, logged in as administrator, go to command line prompt.
- Change to SQL Server's Binn directory.
- Run the following statement:
  ApexSqlServerHelper /load
This should install and load the helper service. After that you should be able to connect normally to online transaction logs
Create new filter for your tables and perform analyze again.

LAST REVIEW
10 August 2007

Labels: ApexSQL Log

posted by David Dawson on Friday, August 10, 2007

1 Comments:

At December 18, 2007 1:20 PM,

Raj said...

I tried this approach but I still do not see any entries in the transaction log in Apex SQL Log.

When I tried this approach I got the error "CreateService(56) failed with 1073".

THe SQL Server runs under the domain admin account and I have also logged into the box with a domain admin account.

I restored a db (in full recovery mode), I then also backed up its tran log (from the original db) and added it to the Apex SQL Log program for analysis after connecting to the restored db, but I still do not see any rows. I made sure that there are no restrictions on the filter. The tran log backup is 40 mb in size so I know there is data in there.

I am using the trial version which I downloaded 10 days ago. This has worked for me last week but it is not working with another database today.

Your help is appreciated.