• State Suggested Answer
  • Replies 1 reply
  • Answers 1 answer
  • Subscribers 9 subscribers
  • Views 1809 views
  • Users 0 members are here
Options
Related

Issue when Apex Log - Reading SQL Tran log Backup Copy

vmandapati
over 3 years ago

Dear Team,

Need your expert guidance/suggestions on below issue.

  1. We are maintaining Apex Log software in a dedicated VM.
  2. Also, we have configured server side components on DB node successfully.
  3. Now, we have logged in Apex SQL from dedicated VM.. and using Apex Log software we have connected to DB (where we have installed server side components).
  4. We have restored SQL server Tran log backup copies on to VM using CommVault backup utility (Where we take log backups using CommVault).
  5. Under selected data source section we have used a one of the Transaction log backup copy (Which we have restored from CommVault backup utility) which is around 2MB size. 
  6. Selected Before-After report and the selected extract to SQL script file option. 
  7. Then Navigated through final screen.. but at that stage 3rd screen is closing automatically.
  8. Below are Log Details from Apex Log.

Log Details:

2020-10-17 05:48:33.845 9380 12200 INFO : Checking backup file: M:\Mountpoints\Tranlogs\TBOS_1_Log_Fri_Oct_16_04_57_47_2020.bak
2020-10-17 05:51:55.754 9380 4732 INFO : ----- Internal statistics (3) -----
2020-10-17 05:51:55.754 9380 4732 INFO : Executed 60 queries in 5.186 s; Average: 0.0864333 s; Longest: 2.578 s
2020-10-17 05:51:55.754 9380 4732 INFO : Available physical memory: 124162 MB of 131070 MB (95 %)
2020-10-17 05:51:55.754 9380 4732 INFO : Process memory usage (peak): 256 MB (269 MB)
2020-10-17 05:51:55.754 9380 4732 INFO : I/O Reads: 1 MB (4,089); Writes: 4 MB (35,528)
2020-10-17 05:52:34.778 9380 12200 INFO : Connecting to server: wvuatgtbossdb01
2020-10-17 05:52:34.778 9380 12200 INFO : Database: TBOS
2020-10-17 05:52:34.778 9380 12200 INFO : Integrated authentication
2020-10-17 05:52:34.794 9380 12200 INFO : Connected to server with following version information:
2020-10-17 05:52:34.794 9380 12200 INFO : ProductVersion 14.0.3335.7
2020-10-17 05:52:34.794 9380 12200 INFO : Language English (United States)
2020-10-17 05:52:34.794 9380 12200 INFO : Platform NT x64
2020-10-17 05:52:34.794 9380 12200 INFO : FileVersion 2017.0140.3335.07 ((SQL17_RTM_QFE-CU).200613-0316)
2020-10-17 05:52:34.794 9380 12200 INFO : WindowsVersion 6.3 (14393)
2020-10-17 05:52:34.794 9380 12200 INFO : ProcessorCount 24
2020-10-17 05:52:34.794 9380 12200 INFO : PhysicalMemory 262143 (274876792832)
2020-10-17 05:52:34.794 9380 12200 INFO : Database compatibility level is 140
2020-10-17 05:52:34.794 9380 12200 INFO : Database recovery mode: Full
2020-10-17 05:52:38.702 9380 11660 INFO : Checking backup file: M:\Mountpoints\Tranlogs\TBOS_1_Log_Fri_Oct_16_04_57_47_2020.bak
2020-10-17 05:52:38.702 9380 11660 INFO : ----- Start auditing -----
2020-10-17 05:52:38.702 9380 11660 INFO : Update reconstruction: Exhaustive
2020-10-17 05:52:38.702 9380 11660 INFO : Reading hint: ForwardDirection, PrepareInsertedBlobFields, PrepareBeforeUpdateBlobFields, PrepareDeletedBlobFields, PrepareChangedAfterUpdateBlobFields
2020-10-17 05:52:38.702 9380 11660 INFO : Operations: Dml
2020-10-17 05:52:38.718 9380 11660 INFO : Filter information
2020-10-17 05:52:38.718 9380 11660 INFO : Last 24 hours
2020-10-17 05:52:38.718 9380 11660 INFO : Transaction states:
2020-10-17 05:52:38.718 9380 11660 INFO : Committed
2020-10-17 05:52:38.718 9380 11660 INFO : Running
2020-10-17 05:52:38.718 9380 11660 INFO : Unknown
2020-10-17 05:52:38.718 9380 11660 INFO : Pass all DML operations.
2020-10-17 05:52:38.718 9380 11660 INFO : Pass no DDL operations.
2020-10-17 05:52:38.718 9380 11660 INFO : Pass unknown tables: True
2020-10-17 05:52:38.718 9380 11660 INFO : Pass system tables: False
2020-10-17 05:52:38.718 9380 11660 INFO : Pass user tables: True
2020-10-17 05:52:38.718 9380 11660 INFO : Table Ids to Pass:
2020-10-17 05:52:38.718 9380 11660 INFO : 1998994548
2020-10-17 05:52:38.718 9380 11660 INFO : Pass unknown users: True
2020-10-17 05:52:38.718 9380 11660 INFO : Pass all users.
2020-10-17 05:52:38.718 9380 11660 INFO : Pass all transaction descriptions.
2020-10-17 05:52:38.718 9380 11660 INFO : Pass all Spids.
2020-10-17 05:52:40.688 9380 11940 ERROR : WCF Communication error: The socket connection was aborted. This could be caused by an error processing your message or a receive timeout being exceeded by the remote host, or an underlying network resource issue. Local socket timeout was '00:01:00'.
2020-10-17 05:52:42.814 9380 11660 INFO : Opening database backup data source: M:\Mountpoints\Tranlogs\TBOS_1_Log_Fri_Oct_16_04_57_47_2020.bak
2020-10-17 05:52:42.830 9380 11660 INFO : Opening transaction log backup source: M:\Mountpoints\Tranlogs\TBOS_1_Log_Fri_Oct_16_04_57_47_2020.bak (1)
2020-10-17 05:52:42.830 9380 11660 INFO : Opening 'M:\Mountpoints\Tranlogs\TBOS_1_Log_Fri_Oct_16_04_57_47_2020.bak(1)' log source. Its size is: 983,040
2020-10-17 05:52:42.830 9380 8696 WARN : Variable data size 11580 is too large.
2020-10-17 05:52:42.830 9380 8696 WARN : Variable data size 11580 is too large.
2020-10-17 05:52:42.830 9380 8696 WARN : Variable data size 11580 is too large.
2020-10-17 05:52:42.830 9380 8696 WARN : Variable data size 11580 is too large.
2020-10-17 05:52:42.830 9380 8696 WARN : Variable data size 11580 is too large.
2020-10-17 05:52:42.830 9380 8696 WARN : Variable data size 11580 is too large.
2020-10-17 05:52:42.830 9380 8696 WARN : Variable data size 11580 is too large.
2020-10-17 05:52:42.830 9380 8696 WARN : Variable data size 11580 is too large.
2020-10-17 05:52:42.830 9380 8696 WARN : Variable data size 11580 is too large.
2020-10-17 05:52:42.830 9380 8696 WARN : Variable data size 11580 is too large.
2020-10-17 05:52:42.830 9380 8696 WARN : Variable data size 11580 is too large.
2020-10-17 05:52:42.845 9380 8696 WARN : Variable data size 11580 is too large.
2020-10-17 05:52:42.845 9380 8696 WARN : Variable data size 11580 is too large.
2020-10-17 05:52:42.845 9380 8696 WARN : Variable data size 11580 is too large.
2020-10-17 05:52:42.845 9380 8696 WARN : Variable data size 11580 is too large.
2020-10-17 05:52:42.845 9380 8696 WARN : Variable data size 11580 is too large.
2020-10-17 05:52:42.845 9380 8696 WARN : Variable data size 11580 is too large.
2020-10-17 05:52:42.845 9380 8696 WARN : Variable data size 11580 is too large.
2020-10-17 05:52:42.845 9380 8696 WARN : Variable data size 11580 is too large.
2020-10-17 05:52:42.845 9380 8696 WARN : Variable data size 11580 is too large.
2020-10-17 05:52:42.845 9380 8696 WARN : Variable data size 11580 is too large.
2020-10-17 05:52:42.845 9380 8696 WARN : Variable data size 11580 is too large.
2020-10-17 05:52:42.845 9380 8696 WARN : Variable data size 11580 is too large.
2020-10-17 05:52:42.845 9380 8696 WARN : Variable data size 11580 is too large.
2020-10-17 05:52:42.845 9380 8696 WARN : Variable data size 11580 is too large.
2020-10-17 05:52:42.845 9380 8696 WARN : Variable data size 11580 is too large.
2020-10-17 05:52:42.845 9380 8696 WARN : Variable data size 11580 is too large.
2020-10-17 05:52:42.845 9380 8696 WARN : Variable data size 11580 is too large.
2020-10-17 05:52:42.845 9380 8696 WARN : Variable data size 11580 is too large.
2020-10-17 05:52:42.845 9380 8696 WARN : Variable data size 11580 is too large.
2020-10-17 05:52:42.845 9380 8696 WARN : Variable data size 11580 is too large.
2020-10-17 05:52:42.845 9380 8696 WARN : Variable data size 11580 is too large.
2020-10-17 05:52:42.845 9380 8696 WARN : Variable data size 11580 is too large.
2020-10-17 05:52:42.845 9380 8696 WARN : Variable data size 11580 is too large.
2020-10-17 05:52:42.845 9380 8696 WARN : Variable data size 11580 is too large.
2020-10-17 05:52:42.845 9380 8696 WARN : Variable data size 11580 is too large.
2020-10-17 05:52:42.861 9380 8696 WARN : Variable data size 11580 is too large.
2020-10-17 05:52:42.861 9380 8696 WARN : Variable data size 11580 is too large.
2020-10-17 05:52:42.861 9380 8696 WARN : Variable data size 11580 is too large.
2020-10-17 05:52:42.861 9380 8696 WARN : Variable data size 11580 is too large.
2020-10-17 05:52:42.861 9380 8696 WARN : Variable data size 11580 is too large.
2020-10-17 05:52:42.861 9380 8696 WARN : Variable data size 11580 is too large.
2020-10-17 05:52:42.861 9380 8696 WARN : Variable data size 11580 is too large.
2020-10-17 05:52:42.861 9380 8696 WARN : Variable data size 11580 is too large.
2020-10-17 05:52:42.861 9380 8696 WARN : Variable data size 11580 is too large.
2020-10-17 05:52:42.861 9380 8696 WARN : Variable data size 11580 is too large.
2020-10-17 05:52:42.861 9380 8696 WARN : Variable data size 11580 is too large.
2020-10-17 05:52:42.861 9380 8696 WARN : Variable data size 11580 is too large.
2020-10-17 05:52:42.861 9380 8696 WARN : Variable data size 11580 is too large.
2020-10-17 05:52:42.861 9380 8696 WARN : Variable data size 11580 is too large.
2020-10-17 05:52:42.861 9380 8696 ERROR : Unknown exception happend in background thread.

Regards,
Sreedhar

  • 0 over 3 years ago

    Hello Sreedhar,

    Hope you're good today

    How large is TBOS_1_Log_Fri_Oct_16_04_57_47_2020.bak?

    I suggest opening a case with Quest Support in order to take a deeper look at this as it looks like the BK is too large (Per 2020-10-17 05:52:42.830 9380 8696 WARN : Variable data size 11580 is too large.) and it's causing the application to crash.

    Thanks in advance.

    Have a good one.