00017556: 2024-04-29T14:25:32 [AT_GLOBAL ]I: Task Server Log - PRD-LogStream (V2022.5.0.291 MSILGGNSD Microsoft Windows Server 2012 (build 9200) 64-bit, Revision:a82fb96beb16d0018595df2a09cbd912edbc4f05, PID: 13188) started at Mon Apr 29 14:25:32 2024 (at_logger.c:2693) 00017556: 2024-04-29T14:25:32 [AT_GLOBAL ]I: Licensed to Maruti Suzuki India Ltd, term license (61 days remaining), sources: (SQLServer,Oracle,AWSAuroraPostgreSQL), targets: (Kinesis,PostgreSQL,Redshift,S3,Oracle,PostgreSQL), all hosts (at_logger.c:2696) 00017556: 2024-04-29T14:25:32 [AT_GLOBAL ]I: Log file encryption base "xBk0Ox9L38iLSdFd/xk+ag==" (at_logger.c:2708) 00017556: 2024-04-29T14:25:32 [SERVER ]I: Client session (ID 1909479567) allocated (dispatcher.c:276) 00017556: 2024-04-29T14:25:32 [UTILITIES ]I: The state is restored from file 'E:\Attunity\data\tasks\PRD-LogStream/StateManager/ars_saved_state_000001.sts' saved at Mon, 29 Apr 2024 08:54:46 GMT (1714380886109709) (statemanager.c:1062) 00017556: 2024-04-29T14:25:32 [TASK_MANAGER ]I: Task 'PRD-LogStream' running CDC only in resume mode (replicationtask.c:1721) 00017556: 2024-04-29T14:25:32 [TASK_MANAGER ]I: Feature flags for process are: (ar_feature_flags.c:232) 00017556: 2024-04-29T14:25:32 [TASK_MANAGER ]I: Feature flags for endpoint 'DMS' are: (ar_feature_flags.c:241) 00017556: 2024-04-29T14:25:32 [TASK_MANAGER ]I: Feature flags for endpoint 'PRD LOGSTREAM' are: (ar_feature_flags.c:250) 00006372: 2024-04-29T14:25:32 [TASK_MANAGER ]I: Task Id: 3cc39a64-a7d2-0e40-ad08-0179a390e398 (replicationtask.c:3810) 00006372: 2024-04-29T14:25:32 [SERVER ]I: Failed to load OraXML library, XMLType will not be supported (oracle_endpoint.c:242) 00006372: 2024-04-29T14:25:32 [METADATA_MANAGE ]I: Truncate trailing binary zeros in char columns (oracle_endpoint_imp.c:788) 00006372: 2024-04-29T14:25:32 [METADATA_MANAGE ]I: Going to connect to Oracle server //10.58.102.17:1521/DMS with username replicate (oracle_endpoint_imp.c:1327) 00006372: 2024-04-29T14:25:33 [METADATA_MANAGE ]I: Source endpoint 'Oracle' is using provider syntax 'Oracle' (provider_syntax_manager.c:873) 00006372: 2024-04-29T14:25:33 [TASK_MANAGER ]I: Creating threads for all components (replicationtask.c:2354) 00006372: 2024-04-29T14:25:36 [TASK_MANAGER ]I: Threads for all components were created (replicationtask.c:2513) 00006372: 2024-04-29T14:25:36 [TASK_MANAGER ]I: Task initialization completed successfully (replicationtask.c:3867) 00015112: 2024-04-29T14:25:36 [SOURCE_CAPTURE ]I: Parallel ASM read using 8 threads (for minimum 1000 blocks) (oracle_endpoint_imp.c:932) 00015112: 2024-04-29T14:25:36 [SOURCE_CAPTURE ]I: Oracle Archived Redo logs Destination Id is 1 (oracle_endpoint_imp.c:970) 00015112: 2024-04-29T14:25:36 [SOURCE_CAPTURE ]I: Read '63' blocks backward (oracle_endpoint_imp.c:993) 00015112: 2024-04-29T14:25:36 [SOURCE_CAPTURE ]I: Oracle CDC uses Oracle File Access mode (oracle_endpoint_imp.c:1009) 00015112: 2024-04-29T14:25:36 [SOURCE_CAPTURE ]I: Wait '5' minutes for missing Archived Redo log (oracle_endpoint_imp.c:1168) 00015112: 2024-04-29T14:25:36 [SOURCE_CAPTURE ]I: retry timeout is '120' minutes (oracle_endpoint_imp.c:1183) 00015112: 2024-04-29T14:25:36 [SOURCE_CAPTURE ]I: Scale is set to 0 for NUMBER Datatype (oracle_endpoint_imp.c:1214) 00015112: 2024-04-29T14:25:36 [SOURCE_CAPTURE ]I: Retry interval is set to 5 (oracle_endpoint_imp.c:1228) 00015112: 2024-04-29T14:25:37 [SOURCE_CAPTURE ]I: Oracle source database version is 11.2.0.3.0 (oracle_endpoint_conn.c:611) 00015112: 2024-04-29T14:25:37 [SOURCE_CAPTURE ]I: Oracle Client version: 21.3.0.0.0 (oracle_endpoint_conn.c:624) 00015112: 2024-04-29T14:25:37 [SOURCE_CAPTURE ]I: Going to connect to ASM server: '//10.58.102.15:1521/+asm' username: 'asmuser' (oracle_endpoint_conn.c:211) 00015112: 2024-04-29T14:25:38 [SOURCE_CAPTURE ]I: Oracle compatibility version is 11.2.0.3.0 (oracle_endpoint_conn.c:87) 00015112: 2024-04-29T14:25:38 [SOURCE_CAPTURE ]I: Database role is 'PRIMARY' (oracle_endpoint_conn.c:133) 00015112: 2024-04-29T14:25:38 [SOURCE_CAPTURE ]I: Resetlog process is supported in Oracle Database (oracle_endpoint_imp.c:1409) 00008532: 2024-04-29T14:25:38 [STREAM_COMPONEN ]I: Target last committed record id from the previous run is '40398079149' (streamcomponent.c:1664) 00008532: 2024-04-29T14:25:38 [TARGET_APPLY ]I: Timeline is 20240212093732738560 (ar_cdc_channel.c:499) 00008532: 2024-04-29T14:25:38 [TARGET_APPLY ]I: Working in transactional apply mode (endpointshell.c:2025) 00008532: 2024-04-29T14:25:39 [SOURCE_CAPTURE ]I: Source endpoint 'Oracle' is using provider syntax 'Oracle' (provider_syntax_manager.c:873) 00006976: 2024-04-29T14:25:39 [SORTER ]I: Start the task using saved state. Start source from stream position 00000733.cf5216f8.00000001.0000.00.0000:3640630.416242.16 and id 26171957453. Confirmed target id is 40392410073, next target id is 40392438413, last source timestamp 1714373614000000 (sorter.c:529) 00006976: 2024-04-29T14:25:39 [SORTER_STORAGE ]I: Swap files were loaded. Next target id to be assigned is 40392438413. Next swap file id is 225603 (transaction_storage.c:583) 00006976: 2024-04-29T14:25:39 [SORTER ]I: 'Stop reading when memory limit reached' is set to false (sorter.c:648) 00006976: 2024-04-29T14:25:39 [STREAM_COMPONEN ]I: Going to connect to Oracle server //10.58.102.17:1521/DMS with username replicate (oracle_endpoint_imp.c:870) 00006372: 2024-04-29T14:25:40 [TASK_MANAGER ]I: All stream components were initialized (replicationtask.c:3640) 00015112: 2024-04-29T14:25:40 [SOURCE_CAPTURE ]I: Oracle capture start stream position '00000733.cf5216f8.00000001.0000.00.0000:3640630.416242.16' (oracle_endpoint_capture.c:584) 00006976: 2024-04-29T14:25:40 [SORTER ]I: Sorter saved record id confirmed by target (40392410073) is different from the target saved record Id (40398079149). Sorter confirmed target id is updated (sorter_transaction.c:3274) 00006976: 2024-04-29T14:25:40 [SORTER ]I: Sorter last run state: confirmed_record_id = 40398079149, confirmed_stream_position = '' (sorter_transaction.c:3278) 00015112: 2024-04-29T14:25:40 [SOURCE_CAPTURE ]I: Oracle capture start stream position '00000733.cf5216f8.00000001.0000.00.0000:3640630.416242.16' (oracle_endpoint_capture.c:590) 00015112: 2024-04-29T14:25:40 [SOURCE_CAPTURE ]I: Used difference between the Replicate machine UTC time and Oracle Local time is '-19800' seconds (oracle_endpoint_capture.c:349) 00015112: 2024-04-29T14:25:51 [SOURCE_CAPTURE ]I: Provided endianity is BIG ENDIAN (oradcdc_redoutil.c:1046) 00015112: 2024-04-29T14:25:51 [SOURCE_CAPTURE ]I: Platform AIX-Based Systems (64-bit): Big endian, REDO alignment is '4' (oradcdc_redoutil.c:1060) 00015112: 2024-04-29T14:25:51 [SOURCE_CAPTURE ]I: Start processing archived Redo log sequence 3640630 thread 1 name +DMSARC/dmsggn/archivelog/2024_04_29/thread_1_seq_3640630.6564.1167567839 (oradcdc_redo.c:902) 00015112: 2024-04-29T14:25:51 [SOURCE_CAPTURE ]I: Oracle Redo compatibility version 0b200300 (oradcdc_redo.c:904) 00015112: 2024-04-29T14:25:51 [SOURCE_CAPTURE ]I: Parallel ASM read started (oradcdc_io.c:1428) 00006976: 2024-04-29T14:25:54 [SORTER ]I: Correcting source database time by 0 microseconds (sorter_transaction.c:197) 00006976: 2024-04-29T14:25:54 [SORTER ]I: Transaction consistency reached (sorter_transaction.c:326) 00006372: 2024-04-29T14:25:54 [TASK_MANAGER ]I: Starting replication now (replicationtask.c:3330) 00015112: 2024-04-29T14:26:04 [SOURCE_CAPTURE ]I: Start processing archived Redo log sequence 3640631 thread 1 name +DMSARC/dmsggn/archivelog/2024_04_29/thread_1_seq_3640631.6565.1167567905 (oradcdc_redo.c:902) 00015112: 2024-04-29T14:26:24 [SOURCE_CAPTURE ]I: Start processing archived Redo log sequence 3640632 thread 1 name +DMSARC/dmsggn/archivelog/2024_04_29/thread_1_seq_3640632.6566.1167567969 (oradcdc_redo.c:902) 00015112: 2024-04-29T14:26:40 [SOURCE_CAPTURE ]I: Start processing archived Redo log sequence 3640633 thread 1 name +DMSARC/dmsggn/archivelog/2024_04_29/thread_1_seq_3640633.6567.1167568035 (oradcdc_redo.c:902) 00015112: 2024-04-29T14:27:00 [SOURCE_CAPTURE ]I: Start processing archived Redo log sequence 3640634 thread 1 name +DMSARC/dmsggn/archivelog/2024_04_29/thread_1_seq_3640634.6568.1167568095 (oradcdc_redo.c:902) 00015112: 2024-04-29T14:27:16 [SOURCE_CAPTURE ]I: Start processing archived Redo log sequence 3640635 thread 1 name +DMSARC/dmsggn/archivelog/2024_04_29/thread_1_seq_3640635.6569.1167568147 (oradcdc_redo.c:902) 00015112: 2024-04-29T14:27:29 [SOURCE_CAPTURE ]I: Start processing archived Redo log sequence 3640636 thread 1 name +DMSARC/dmsggn/archivelog/2024_04_29/thread_1_seq_3640636.6570.1167568201 (oradcdc_redo.c:902) 00015112: 2024-04-29T14:27:40 [SOURCE_CAPTURE ]I: Start processing archived Redo log sequence 3640637 thread 1 name +DMSARC/dmsggn/archivelog/2024_04_29/thread_1_seq_3640637.6571.1167568249 (oradcdc_redo.c:902) 00015112: 2024-04-29T14:27:51 [SOURCE_CAPTURE ]I: Start processing archived Redo log sequence 3640638 thread 1 name +DMSARC/dmsggn/archivelog/2024_04_29/thread_1_seq_3640638.6572.1167568293 (oradcdc_redo.c:902) 00015112: 2024-04-29T14:28:01 [SOURCE_CAPTURE ]I: Start processing archived Redo log sequence 3640639 thread 1 name +DMSARC/dmsggn/archivelog/2024_04_29/thread_1_seq_3640639.6573.1167568335 (oradcdc_redo.c:902) 00015112: 2024-04-29T14:28:13 [SOURCE_CAPTURE ]I: Start processing archived Redo log sequence 3640640 thread 1 name +DMSARC/dmsggn/archivelog/2024_04_29/thread_1_seq_3640640.6574.1167568381 (oradcdc_redo.c:902) 00015112: 2024-04-29T14:28:23 [SOURCE_CAPTURE ]I: Start processing archived Redo log sequence 3640641 thread 1 name +DMSARC/dmsggn/archivelog/2024_04_29/thread_1_seq_3640641.6575.1167568423 (oradcdc_redo.c:902) 00015112: 2024-04-29T14:28:27 [ASSERTION ]W: Cannot parse a Log Record: zero entry length (oradcdc_parse.c:4340) 00015112: 2024-04-29T14:28:27 [ASSERTION ]W: Cannot parse a Log Record, continuation. Problematic entry #3. Offset 748. Record data length 816 ~{AQAAAL8kXfiO0k4jdOXgjHo1YCcO4RLQcWWt3U6HCrtJMPCBs6tgB78vf0qHKgQ4FoZoPSXwEkQ0Rzx53X2T30XiGrIdTA0qqrQFjoe5nIJ/ayTcvl9DsSvnY3eojzOLCoiAqYOAiAMUvlb7jH+YKbMEqBe1f6x3xpt/nziT9VPoCE3SrnqN/r8/u95jRqaFpzjuMSJwheyX/j2QVBc8mtjTJv6BjiQf8P+ek8iyWr8Rt9sal0gqSf6Wb6vTM78LqWhqd1sNGCp/NgvK32SE1t9lUcV8eTnO5kwDbAOYn7vUYrdpJrnpUP57PCN1zkEDdDQmO8UhlSMQjjUlyNxUU22J/RIZFptKh0acn7+66+v68VEOVj+QjMZWdOWFGCu4IUICHpVJ0f024O5dsF7p7XWXSQrWDPpAoI6xgbs9Jq9q+4YJFDw4KOIJUHE/y8xBHcW1o88XqAYzB8skoa1zg43KkqN9yxb1Er9F1Bf++5FHy/MzPTpbD2vLlc33N7pLKZOuGTd/5iAW8SSlWjjbwfLUC8kHIALWe19hBN4IT8BMx+EAqHCIgPHfwpwhWNmR42/tZiMRgwhSDR6MIvnJ68puxAEh0uUYA/DAX3dz2tbmDflt+WrCcQ3HcGqt1gHKh1RlAcQLRoN9qMw1+VHvMmvvGE3TOFEFd0mV3OLc1hUTqAtaXrIyasDBVFHAfFuylkitam4CcAlu2hfup0x6JVqvI780C0X1BqsSKZl7cRFt8sCQXm2EuzBQN3vjZbcx0ZTwiX0ECFYYPPzzabQzd2aR53w/Wa8qqAD4B+oFP2RN671drwV0NoRcCp8xc4eVqbNDyKU1XuEG6OL5hA6X0Gf828omTSkgzwNjYok/0NvaE7mu/lPSLytahw8Oh6F6eihw12C0vk3DgUd+NyBhK4afjM/mVCzpXsBtV4I4t1VEW2rB6wqGEc5zxg6jNojXXFNFIJB9A7XFr5pFF9O+qNRq4U8/90zgN6IdlMzfocRdXf8WULAhEDMNhEEv8M0RGr+lDc2LfDe+DenHQxHdb4VBX3cQXkZUgN6mtNtHc5fPBywWMtwMdmHaF0nSMTeDqFgmdh0m6tchfFQF7X0GTY6MQsx3hmsrXmGfoyPslklYrUlg0mDwM5nY880dfD6NT2FsAkIjfJOpADOej85SiXqxYi5wK1JNkIDcW/vyFl+1j7Ss65jrpeeQQ06pmqWvD0XXfhSI6guVScw20aIxnPMm3S3WB5vjLoNS4OU1gr+LuxRdMETcTDO91CB+LH62y7dswudeCCgErlyS0PJbjGlYZVPBxoxKzAidNtlcCl7Vl5KoSaT6QsfTJ7YtMpSIs9BXK3+62nPKDGjKizOLUq7iZvFr15eY01+l8w1abiQHB1FhxE9uFzAR91H6uhIJvuA1Pc5Zn+zuxna0hRMvQyV4oLLAuoZn4pWuWsEnC5dwaQa6z+en1ZEneYAg+TzDDlFyuWtYwYoTqc49gSxIMI59kGt0QunjSc+PyLo/EpWgjY24DNMePPBjMh7PEouPNQ4xMilMT82Vztvgm0jWckUf3j0yT5HHc6dGwLav8zexhhea6MOF0VNHNSiaiN29sxZhhgmV4hiCWpVH40CsMJ5TZAU3HGxILZQs3CMvkL5Y8cKPmDLGJsOjc4gkI9+dprfwapQTudtiYChk4gwxs4kiyyRAoStUimiBWx74wQV5xUYIJG0hYl+etXTaBr4XDb2ilK3NQy4738ztYBcXQS5EdGT8RfEz8dY1V7O8WwjsJgj0sEkdbxP8nmsaEV9K+dKyacdbq9FYCKQxy0QJeTxphqoWexeUXmMuTMjKb4e5I2vMZ+3a3YZzYhOnwpI1c16MC8f6xfZuzi/X5JGQ6d9KJ/O5w3GId/l45o5rRomBimUXPNU/s3VPVnj8xabJ0xuPBZhGgKJCJ98Ca09elLpUqupJCsRGfBPaeHVpToGceUmwzMtgGnnf+aOrcdIAMon1eo7arKsoVg9P+M0MJ4JXfdFUaV6/9YO5nqmrLFZNm9dYezdPewTjI3QuWQKv7ROcjnh5R6GobdqgRvBWnvBz0vIJb3gJHA9FHQV6h0gyyQ8gW9I1NqqwGBF96J0fYzYmqCPPHCl4EIGplgf3HKuh8Bfnsx4UMxH4S+FB8O+rWiTObTmQ4gZyPTYKHIdI0/0eGlXi5eTDmp5TxK37sG3omA2iVp1Z97HXPauMyNZbd1doXFkI3H8+jvF+UywvDVd/ZsQdaLTaxX2CrAjvqlUUzsq6wL784uiv2bO6ZL/4adu1T9rtcI+51p/gR8Asas4JprQ5rMVGwLI/OLaSAGA5hWLwvD9FHbLIw2aLHybZ/NtiVLM1uvcsvNg2uSP6C0CjOOpmQruIeSvCsmG/RhpY4zq/5rQSbN4AK+KBlNz75UJdKD5PP4lnoOpELthzp8fAInrTdmTXxd+655gdHHRmazjsmzvNLb6T4shBGkPUY+w8Q/g6USZBivU9Hl8ASnQsZPtLOsPRgaVEoaSTZ8BxJdVzGnzfhHXgJhyRMQnmMSuHjAPGdq7bxuPcKTb46q+aEJ7zlry+DG4D6yZ8hjQA4hG4GZs9CFYZfLzdQ60As2nNmkSIkiNOvLuKkmJg9ShR9PlkktCG65qv34VSGGMPVOMm7HCATfE1q5FTV2VL961mKml16VZH6yiqivGA3YFLj57qj/lewdbmUhzOEbDq5UZLzZ6HhnccqUrwZhIpaWZK/Qq4lFaBGG3xf7uhT9vxSDjz3NX/9uMjl6IfTVE0HtuwalMclyJatN5K1PTl2wmGqNhlJ1iXD99Lx2XFXgfBcnfhugIjzlVnPauZeV0j7sXo05UfAPvVkmrusexD90k7KXlxTA8woW19jNynGCm7mv0oIbwOvK4ZyLsATxI1jZWJMmgJAIZ9dfyAquXc1zwyZbPZ81TkUTV4JH9Iqgz1Nlv/Q35Z430xVpw6vjA2/CDTW2kcNd9oznpS3u+S0k07FGZOhDVb74JEwnkL1t34cUiI5WGKbOYss5zV5izqvMdxPje6mV86MTZPfA32r92jWVDXZvupG1ieCh5BdXGjEQvRtOoPXZHiKv6HJj/RPdqxUTSgITn9HGzaC9Sek85L5Gu3/g1GcZG9stJOiIGRcow+unvo3JR00RvrpQNLSMGuCK+f0ZZ5KDzuYwIFcX589lE3hfo3QnFx080zpcn+jXQFtWkgA4sAaMHRrN6Cnb3OR4sgqnopARXtBRQPI3WFiqnBNq8mmng8mvAMSSq8qkQQvPfkO8tF21wgHc0Ctz0HFUN29qSOVyRbew9nM52neVo4lqZCCGzpQ4ojDsdlw60yknMqmY5DZre8+Tu00j9D/I9+8HrGZ8Rnth3acRZ8lrZJvxaQD9fjU01BxZf8O6vTeGipxQtw+X1FEMMQYmscW5v330Jy7dFI04XvEUdFLCuxsCqaKTurugUGC/QNf3Dahnm6B671tj85adHDM37RjZbcH0eTNTCHSsDtC1mnulGnjbiGlPGEr9gamQ4SK+yQceMu+UXrd55JDQI76zg03mYyjsEo20DR2sDmoFuHo7Sh0Ezc944WklhR/0C1ADdAisW8tfT+fiMaV0zZjYsCGgSHEo2Phf+oaGImdL+2gQNEKSvE2rg4QEmei+vuivwj+bXLImrssxTC2jH2X/cw2h0oDd5JMqx+fBBffn27l8NVY6ZiPEQ3Se5tkIbr9aEOCGKVR3CH+N/NhGh2+1TcOjtfsIrPE7owY0bQnTJknN4kBqZJAkoYMxEczo39iaIw7ne9lIIFgl5T1yWHLOfT7qcSecVde1yNPyXUzX9dBF+6ziqY/j5DGhvd2HBNF/tNwcM+DCevvKzRUG4A2X5qvKQZ91QdOOOpuLz22x/AI97jm0x1meimVOFBfaZYvmg6BkVk+XG7/uWRALV/voaangrmcVgunZwUHgZfRJP4/UzgkIxQa+R49AkS7y/hq0bIIpT7rZScvziTmzQby+6obq0oCvzg9WfrdVMW2H3FmRIaLbOvAD7LXkhkwVkqFBaZ9c82gj5sc7FHS0q2xTJ1eD8ZSFeBbxSfFsJ5mWZYACi3TVVwOC5HrucPGsD5RFpMhRhVkovpnsCtg3pgDLrDNzfFvgmVedg9TZIBUcM0lol43NwfnXxVdI+7RA7kOPIpRmWgfLbPnd8URNUrF12ql36As3M3RAWCVX4bpdWyvTmLuZH/EkLx8+pQJH76B4v/zqZIbsXDwK3NEiK0ALKczUBWSwqn9J/BLf9rIy/rgXqEEPP1KbTbvJSee2M44VrwJoCFiIQqTC/1q45monfw4dEMUMUbdbn0WWArM075RQ+yiew3nyS5XRH/TCbrjT7VZLwdX36tysjFbsLeM64E+F2vV/0vvb7In9Md5KRJM3Uljk0M+Rk0tqsVJdp8gGPJDiitCCIt5NcO8pvoL5I=}~ (oradcdc_parse.c:4395) 00015112: 2024-04-29T14:28:27 [ASSERTION ]W: Cannot parse a Log Record, continuation. The problematic entry ~{AgAAAABMzP9Il+c9AOVfMl9cLsqiJ5JGnASxL2XgWJTT8dOnsCGMdO9b41t5EbImC/qlHgVSAFST5cLbUNQ4NJdPV0BSY0Nd6+/RIiBQuprdezddreMz/XaM6jFBr+6W1Oe2xyT/d1dlKuKGcV9CRAERt/9NqBzwoCsB+uV8VMZEnXDAG9viJM8FYJRTrixZtIDsXMwrdNdH6mKGnqU20oKkZ+A1BsIo21n453+/2f76B9L9udWrQdl0h96Y4uOAa+fjPB2D4fr/ozEKJOqLv67uEGWhalW5YoT0qkdj5plPnYT+jra66jkBybXhWajrrGRtKiwGFLNW2G1RXGgxx/mptzrMaCaYL8+sOheSyuqj6Rm3bZQO14DT5dAMxbSrzN2L/JBw1N4+d0Ts+b9PDhHEkcbXauhmcy43M/cv6rxxxeF5Auhbhx8mhbtg0gg8Z3NphA==}~ (oradcdc_parse.c:4397)