t Transfer: 1220 : 12|09:58:36.3319|68JlZu||OAuth: /api/logout?_dc=1686819521350 t Transfer: 1220 : 12|09:58:36.3319|68JlZu||GetCurrentUser.. t Transfer: 1220 : 12|09:58:36.3319|68JlZu|| OAuth authenticated t Verbose: 1220 : 12|09:58:36.3319|68JlZu|| uid claim is missing.. t Information: 1220 : 12|09:58:36.3329|68JlZu||OAuth. AutoLogin no Windows identity type WindowsIdentity t Transfer: 1220 : 12|09:58:37.3379|HlldNG||GetAppInfo. DB: TMDDEMO. Install mode: . Auth types: Native, PublicApiKey t Information: 1220 : 12|09:58:37.5389|UEYP6k||GetCache. t Information: 1220 : 12|09:58:37.5389|UEYP6k||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\108_2_PnqJC_.png t Information: 1220 : 12|09:58:37.5399|UEYP6k||GetCache. Data read: 154944 t Verbose: 1220 : 12|09:58:37.5399|UEYP6k||imfx v3 API took 0.006s '/api/v3/visual-asset/group/PnqJC_/2/image' t Verbose: 1220 : 12|09:58:39.3489|8NextK||Oauth validating.. t Verbose: 1220 : 12|09:58:39.3489|8NextK||GrantResourceOwnerCredentials. t Verbose: 1220 : 12|09:58:39.3489|8NextK||LoginUser. cjpowercast, login type OAuth, encrypt password True t Information: 1220 : 12|09:58:39.3489|8NextK||TryLoginUser. cjpowercast, login type OAuth, check password True, check hash False, encrypt password True, load user data False t Information: 1220 : 12|09:58:39.5499|8NextK|| oauth token 00000000-0000-0000-0000-000000000000 t Information: 1220 : 12|09:58:39.5499|8NextK||TryLoginUser. Logged in.. t Information: 1220 : 12|09:58:39.5499|8NextK||GetPasswordPolicy. WARNING: Policy not found for system Imediaflex. Validation disabled. t Verbose: 1220 : 12|09:58:39.5499|8NextK||LoginUser. Adding history. User Id 1165, result CJPOWERCAST, host 192.168.127.6 t Verbose: 1220 : 12|09:58:39.5499|8NextK||GrantResourceOwnerCredentials. Try login finished. Logged: True t Transfer: 1220 : 12|09:58:39.9519|7Cb61_|CJPOWERCAST|OAuth: /api/user-group-preferences?keys=defaultSearchColumnsMedia,defaultSearchColumnsVersion,defaultSearchColumnsSimple,defaultSearchColumnsTitle,defaultSearchMisrDetailsMediaColumns,versionCreationSettings,associate.advanced_search.version.setups,associate.advanced_search.media.setups,associate.wfrise.setups,supplier_portal.advanced_search.version.setups,media_portal.del_history.advanced.search_criteria,supplier_portal.version_complete.setups,logoImage,uploadSettings,helpdeskUrl,customLabels,googleMapsApiSettings&globals=isDebugMode,htmlplayerhotkeys,versionCreationSettings,associate.advanced_search.version.setups,associate.advanced_search.media.setups,associate.wfrise.setups,supplier_portal.advanced_search.version.setups,media_portal.del_history.advanced.search_criteria,helpdeskUrl,customLabels&_dc=1686819525138 t Transfer: 1220 : 12|09:58:39.9519|7Cb61_|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:58:39.9519|7Cb61_|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:58:39.9519|7Cb61_|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:58:39.9519|7Cb61_|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|09:58:39.9519|7Cb61_|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:58:39.9519|7Cb61_|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:58:39.9529|7Cb61_|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:58:39.9529|7Cb61_|CJPOWERCAST|imfx v3 API took 0.039s '/api/user-group-preferences?keys=defaultSearchColumnsMedia,defaultSearchColumnsVersion,defaultSearchColumnsSimple,defaultSearchColumnsTitle,defaultSearchMisrDetailsMediaColumns,versionCreationSettings,associate.advanced_search.version.setups,associate.advanced_search.media.setups,associate.wfrise.setups,supplier_portal.advanced_search.version.setups,media_portal.del_history.advanced.search_criteria,supplier_portal.version_complete.setups,logoImage,uploadSettings,helpdeskUrl,customLabels,googleMapsApiSettings&globals=isDebugMode,htmlplayerhotkeys,versionCreationSettings,associate.advanced_search.version.setups,associate.advanced_search.media.setups,associate.wfrise.setups,supplier_portal.advanced_search.version.setups,media_portal.del_history.advanced.search_criteria,helpdeskUrl,customLabels&_dc=1686819525138' t Transfer: 1220 : 12|09:58:40.3549|YXHXAD|CJPOWERCAST|OAuth: /api/user-preferences?keys=personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch;workflow_queues_actions;workflow_queues_settings&_dc=1686819525485 t Transfer: 1220 : 12|09:58:40.3549|YXHXAD|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:58:40.3549|YXHXAD|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:58:40.3549|YXHXAD|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:58:40.3549|YXHXAD|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|09:58:40.3549|YXHXAD|CJPOWERCAST|GetUserDataByKeys: personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch;workflow_queues_actions;workflow_queues_settings t Transfer: 1220 : 12|09:58:40.3549|YXHXAD|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:58:40.3549|YXHXAD|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:58:40.3559|YXHXAD|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:58:40.3559|YXHXAD|CJPOWERCAST|imfx v3 API took 0.032s '/api/user-preferences?keys=personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch;workflow_queues_actions;workflow_queues_settings&_dc=1686819525485' t Information: 1220 : 12|09:58:40.7579|8WAfEL|CJPOWERCAST|GetUserProfile. Id: 0 t Transfer: 1220 : 12|09:58:40.7579|8WAfEL|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:58:40.7579|8WAfEL|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:58:40.7579|8WAfEL|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|09:58:40.9589|85uz4z|CJPOWERCAST|OAuth: /api/settings/group/0?_dc=1686819526159 t Transfer: 1220 : 12|09:58:40.9589|85uz4z|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:58:40.9589|85uz4z|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:58:40.9589|85uz4z|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:58:40.9589|85uz4z|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|09:58:40.9589|Mmar2M|CJPOWERCAST|OAuth: /api/settings/user/mainMenuSettings?_dc=1686819526161 t Transfer: 1220 : 12|09:58:40.9589|Mmar2M|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:58:40.9589|Mmar2M|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:58:40.9599|Mmar2M|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:58:40.9599|Mmar2M|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|09:58:40.9599|z9G~eN|CJPOWERCAST|OAuth: /api/settings/user/uploadSettings?_dc=1686819526176 t Transfer: 1220 : 12|09:58:40.9599|z9G~eN|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:58:40.9599|z9G~eN|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:58:40.9599|z9G~eN|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:58:40.9599|z9G~eN|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|09:58:40.9599|IBjC5r|CJPOWERCAST|OAuth: /api/settings/group/0?_dc=1686819526203 t Transfer: 1220 : 12|09:58:40.9599|IBjC5r|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:58:40.9599|IBjC5r|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:58:40.9609|IBjC5r|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:58:40.9609|IBjC5r|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|09:58:41.1619|Mmar2M|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:58:41.1619|Mmar2M|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:58:41.1619|Mmar2M|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|09:58:41.1619|z9G~eN|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:58:41.1619|z9G~eN|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:58:41.1619|z9G~eN|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:58:41.1629|z9G~eN|CJPOWERCAST|imfx v3 API took 0.085s '/api/settings/user/uploadSettings?_dc=1686819526176' t Verbose: 1220 : 12|09:58:41.1629|Mmar2M|CJPOWERCAST|imfx v3 API took 0.172s '/api/settings/user/mainMenuSettings?_dc=1686819526161' t Verbose: 1220 : 12|09:58:41.3639|85uz4z|CJPOWERCAST|imfx v3 API took 0.335s '/api/settings/group/0?_dc=1686819526159' t Verbose: 1220 : 12|09:58:41.3639|IBjC5r|CJPOWERCAST|imfx v3 API took 0.185s '/api/settings/group/0?_dc=1686819526203' t Transfer: 1220 : 12|09:58:41.5649|~x3LHa|CJPOWERCAST|OAuth: /api/lookups/MediaStatus?_dc=1686819526217 t Transfer: 1220 : 12|09:58:41.5649|~x3LHa|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:58:41.5649|~x3LHa|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:58:41.5649|~x3LHa|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:58:41.5649|~x3LHa|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|09:58:41.5649|_U9Kpn||GetCache. t Information: 1220 : 12|09:58:41.5649|_U9Kpn||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\201_0_Any_gO.png t Information: 1220 : 12|09:58:41.5649|_U9Kpn||GetCache. Data read: 0 t Verbose: 1220 : 12|09:58:41.5659|_U9Kpn||imfx v3 API took 0.004s '/api/v3/visual-asset/group/Any_gO/0/image' t Transfer: 1220 : 12|09:58:41.5659|R87dkG|CJPOWERCAST|OAuth: /api/settings/user/mainMenuSettings?_dc=1686819526204 t Transfer: 1220 : 12|09:58:41.5659|R87dkG|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:58:41.5659|R87dkG|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:58:41.5659|R87dkG|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:58:41.5659|R87dkG|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|09:58:41.5659|R87dkG|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:58:41.5659|R87dkG|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:58:41.5659|R87dkG|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:58:41.5659|R87dkG|CJPOWERCAST|imfx v3 API took 0.002s '/api/settings/user/mainMenuSettings?_dc=1686819526204' t Verbose: 1220 : 12|09:58:41.5669|~x3LHa|CJPOWERCAST|imfx v3 API took 0.032s '/api/lookups/MediaStatus?_dc=1686819526217' t Transfer: 1220 : 12|09:58:41.7679|zhVvZ1|CJPOWERCAST|OAuth: /api/lookups/PgmStatus?_dc=1686819526217 t Transfer: 1220 : 12|09:58:41.7679|zhVvZ1|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:58:41.7679|zhVvZ1|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:58:41.7679|zhVvZ1|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:58:41.7679|zhVvZ1|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 12|09:58:41.7679|zhVvZ1|CJPOWERCAST|imfx v3 API took 0.000s '/api/lookups/PgmStatus?_dc=1686819526217' t Transfer: 1220 : 12|09:58:41.7679|x9snN2|CJPOWERCAST|OAuth: /api/lookup/CustomMediaStatusTypes?_dc=1686819526223 t Transfer: 1220 : 12|09:58:41.7679|x9snN2|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:58:41.7689|x9snN2|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:58:41.7689|x9snN2|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:58:41.7689|x9snN2|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 12|09:58:41.7689|x9snN2|CJPOWERCAST|imfx v3 API took 0.009s '/api/lookup/CustomMediaStatusTypes?_dc=1686819526223' t Transfer: 1220 : 12|09:58:41.9699|bx03~8|CJPOWERCAST|OAuth: /api/lookup/CustomVersionStatusTypes?_dc=1686819526224 t Transfer: 1220 : 12|09:58:41.9699|bx03~8|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:58:41.9699|bx03~8|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:58:41.9699|bx03~8|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:58:41.9699|bx03~8|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 12|09:58:41.9699|bx03~8|CJPOWERCAST|imfx v3 API took 0.005s '/api/lookup/CustomVersionStatusTypes?_dc=1686819526224' t Transfer: 1220 : 12|09:58:41.9699|v1V0HZ|CJPOWERCAST|OAuth: /api/lookup/CustomTitleStatusTypes?_dc=1686819526225 t Transfer: 1220 : 12|09:58:41.9699|v1V0HZ|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:58:41.9709|v1V0HZ|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:58:41.9709|v1V0HZ|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:58:41.9709|v1V0HZ|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 12|09:58:41.9709|v1V0HZ|CJPOWERCAST|imfx v3 API took 0.004s '/api/lookup/CustomTitleStatusTypes?_dc=1686819526225' t Transfer: 1220 : 12|09:58:41.9709|DeLTZW|CJPOWERCAST|OAuth: /api/settings/user/defaultHomePage?_dc=1686819526226 t Transfer: 1220 : 12|09:58:41.9709|DeLTZW|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:58:41.9709|DeLTZW|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:58:41.9709|DeLTZW|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:58:41.9709|DeLTZW|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|09:58:41.9709|DeLTZW|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:58:41.9719|DeLTZW|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:58:41.9719|DeLTZW|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:58:41.9719|DeLTZW|CJPOWERCAST|imfx v3 API took 0.004s '/api/settings/user/defaultHomePage?_dc=1686819526226' t Information: 1220 : 12|09:58:41.9719|GeRUEP||GetCache. t Information: 1220 : 12|09:58:41.9719|GeRUEP||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\202_1_Any_gO.png t Information: 1220 : 12|09:58:41.9719|GeRUEP||GetCache. Data read: 0 t Verbose: 1220 : 12|09:58:41.9719|GeRUEP||imfx v3 API took 0.004s '/api/v3/visual-asset/group/Any_gO/1/image' t Transfer: 1220 : 12|09:58:43.1779|nN9zji|CJPOWERCAST|OAuth: /api/settings/user/defaultSearch?_dc=1686819528404 t Transfer: 1220 : 12|09:58:43.1779|nN9zji|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:58:43.1779|nN9zji|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:58:43.1779|jm66is|CJPOWERCAST|OAuth: /api/settings/user/startSearch?_dc=1686819528406 t Transfer: 1220 : 12|09:58:43.1779|nN9zji|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|09:58:43.1779|jm66is|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:58:43.1779|jm66is|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:58:43.1789|jm66is|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:58:43.1789|jm66is|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 12|09:58:43.1789|nN9zji|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|09:58:43.1789|nN9zji|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:58:43.1789|nN9zji|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:58:43.1789|nN9zji|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|09:58:43.1789|jm66is|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:58:43.1789|jm66is|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:58:43.1789|jm66is|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:58:43.3809|jm66is|CJPOWERCAST|imfx v3 API took 0.005s '/api/settings/user/startSearch?_dc=1686819528406' t Verbose: 1220 : 12|09:58:43.3809|nN9zji|CJPOWERCAST|imfx v3 API took 0.005s '/api/settings/user/defaultSearch?_dc=1686819528404' t Transfer: 1220 : 12|09:58:43.5819|lzRwhu|CJPOWERCAST|OAuth: /api/user-preferences?keys=consumer.recent.data&_dc=1686819528727 t Transfer: 1220 : 12|09:58:43.5819|lzRwhu|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:58:43.5819|lzRwhu|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:58:43.5819|lzRwhu|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:58:43.5819|lzRwhu|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|09:58:43.5819|lzRwhu|CJPOWERCAST|GetUserDataByKeys: consumer.recent.data t Transfer: 1220 : 12|09:58:43.5819|lzRwhu|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:58:43.5819|lzRwhu|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:58:43.5829|lzRwhu|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|09:58:43.5829|gUaNYi|CJPOWERCAST|OAuth: /api/user-preferences?keys=adv.recent.searches.consumer&_dc=1686819528741 t Transfer: 1220 : 12|09:58:43.5829|gUaNYi|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:58:43.5829|gUaNYi|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:58:43.5829|gUaNYi|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:58:43.5829|gUaNYi|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|09:58:43.5829|gUaNYi|CJPOWERCAST|GetUserDataByKeys: adv.recent.searches.consumer t Transfer: 1220 : 12|09:58:43.5829|gUaNYi|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:58:43.5829|gUaNYi|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:58:43.5839|gUaNYi|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:58:43.5839|lzRwhu|CJPOWERCAST|imfx v3 API took 0.007s '/api/user-preferences?keys=consumer.recent.data&_dc=1686819528727' t Verbose: 1220 : 12|09:58:43.5839|gUaNYi|CJPOWERCAST|imfx v3 API took 0.007s '/api/user-preferences?keys=adv.recent.searches.consumer&_dc=1686819528741' t Information: 1220 : 12|09:58:43.5839|c7ichv||GetCache. t Information: 1220 : 12|09:58:43.5839|c7ichv||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\204_3_Any_gO.png t Information: 1220 : 12|09:58:43.5839|c7ichv||GetCache. Data read: 5504 t Verbose: 1220 : 12|09:58:43.5839|c7ichv||imfx v3 API took 0.004s '/api/v3/visual-asset/group/Any_gO/3/image' t Transfer: 1220 : 12|09:59:02.8799|lsdOHV|CJPOWERCAST|OAuth: /api/lookups/SearchSupportedOperators?_dc=1686819548100 t Transfer: 1220 : 12|09:59:02.8799|lsdOHV|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:02.8799|lsdOHV|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:02.8799|lsdOHV|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:59:02.8799|lsdOHV|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|09:59:02.8799|T6xTgC|CJPOWERCAST|OAuth: /api/view/searchinfo/Version?_dc=1686819548086 t Transfer: 1220 : 12|09:59:02.8799|T6xTgC|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:02.8809|T6xTgC|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:02.8809|T6xTgC|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:59:02.8809|T6xTgC|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 12|09:59:02.8809|lsdOHV|CJPOWERCAST|imfx v3 API took 0.000s '/api/lookups/SearchSupportedOperators?_dc=1686819548100' t Information: 1220 : 12|09:59:02.8809|T6xTgC|CJPOWERCAST|GetAdvSearchColumns. search type Version grid . t Verbose: 1220 : 12|09:59:02.8809|T6xTgC|CJPOWERCAST|imfx v3 API took 0.001s '/api/view/searchinfo/Version?_dc=1686819548086' t Transfer: 1220 : 12|09:59:03.0819|MHwijG|CJPOWERCAST|OAuth: /api/user-preferences?keys=adv.recent.searches.versions&_dc=1686819548103 t Transfer: 1220 : 12|09:59:03.0819|MHwijG|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:03.0819|MHwijG|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:03.0819|MHwijG|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:59:03.0819|MHwijG|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|09:59:03.0819|MHwijG|CJPOWERCAST|GetUserDataByKeys: adv.recent.searches.versions t Transfer: 1220 : 12|09:59:03.0819|MHwijG|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:03.0819|MHwijG|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:03.0829|MHwijG|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:59:03.0829|MHwijG|CJPOWERCAST|imfx v3 API took 0.007s '/api/user-preferences?keys=adv.recent.searches.versions&_dc=1686819548103' t Transfer: 1220 : 12|09:59:03.0829|yROUNu|CJPOWERCAST|OAuth: /api/view/searches/Version?_dc=1686819548209 t Transfer: 1220 : 12|09:59:03.0829|yROUNu|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:03.0829|yROUNu|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:03.0829|yROUNu|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:59:03.0829|yROUNu|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|09:59:03.0829|yROUNu|CJPOWERCAST|GetSavedSearchNames. search type Version. t Transfer: 1220 : 12|09:59:03.0829|yROUNu|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:03.0829|yROUNu|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:03.0839|yROUNu|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|09:59:03.0839|XNEOVa|CJPOWERCAST|OAuth: /api/settings/user/searchLayoutConfig?_dc=1686819548219 t Transfer: 1220 : 12|09:59:03.0839|XNEOVa|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:03.0839|XNEOVa|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:03.0839|XNEOVa|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:59:03.0839|XNEOVa|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|09:59:03.0839|ABgFEr|CJPOWERCAST|OAuth: /api/view/info/VersionGrid?lang=en-GB&_dc=1686819548217 t Transfer: 1220 : 12|09:59:03.0839|ABgFEr|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:03.0839|ABgFEr|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:03.0849|ABgFEr|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:59:03.0849|ABgFEr|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|09:59:03.0849|XNEOVa|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:03.0849|XNEOVa|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:03.0849|XNEOVa|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:59:03.0849|XNEOVa|CJPOWERCAST|imfx v3 API took 0.004s '/api/settings/user/searchLayoutConfig?_dc=1686819548219' t Information: 1220 : 12|09:59:03.0849|ABgFEr|CJPOWERCAST|GetGridViewBuilder. builder type VersionGrid. t Transfer: 1220 : 12|09:59:03.0849|ABgFEr|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:03.0849|ABgFEr|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:03.0859|ABgFEr|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|09:59:03.0859|ABgFEr|CJPOWERCAST|UserGridView. LoadView. ID -2, Name Default. t Transfer: 1220 : 12|09:59:03.0859|ABgFEr|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:03.0859|ABgFEr|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:03.0859|ABgFEr|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|09:59:03.0859|ABgFEr|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:03.0859|ABgFEr|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:03.0859|ABgFEr|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:59:03.0859|yROUNu|CJPOWERCAST|imfx v3 API took 0.030s '/api/view/searches/Version?_dc=1686819548209' t Verbose: 1220 : 12|09:59:03.0859|ABgFEr|CJPOWERCAST|imfx v3 API took 0.040s '/api/view/info/VersionGrid?lang=en-GB&_dc=1686819548217' t Transfer: 1220 : 12|09:59:08.3129|5NhwUa|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1686819553452 t Transfer: 1220 : 12|09:59:08.3129|5NhwUa|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:08.3129|5NhwUa|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:08.3129|5NhwUa|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:59:08.3129|5NhwUa|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|09:59:08.3129|5NhwUa|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:08.3129|5NhwUa|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:08.3129|5NhwUa|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|09:59:08.5149|yDoP0H|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1686819553689 t Transfer: 1220 : 12|09:59:08.5149|yDoP0H|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:08.5149|yDoP0H|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:08.5149|yDoP0H|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:59:08.5149|yDoP0H|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|09:59:08.5149|yDoP0H|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:08.5159|yDoP0H|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:08.5159|yDoP0H|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|09:59:08.7169|nuPTeH|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1686819553937 t Transfer: 1220 : 12|09:59:08.7169|nuPTeH|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:08.7169|nuPTeH|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:08.7169|nuPTeH|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:59:08.7169|nuPTeH|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|09:59:08.7169|nuPTeH|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:08.7169|nuPTeH|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:08.7169|nuPTeH|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:59:08.7179|5NhwUa|CJPOWERCAST|imfx v3 API took 0.420s '/api/v3/search-suggestion/?_dc=1686819553452' t Verbose: 1220 : 12|09:59:08.9189|nuPTeH|CJPOWERCAST|imfx v3 API took 0.085s '/api/v3/search-suggestion/?_dc=1686819553937' t Verbose: 1220 : 12|09:59:08.9189|yDoP0H|CJPOWERCAST|imfx v3 API took 0.333s '/api/v3/search-suggestion/?_dc=1686819553689' t Transfer: 1220 : 12|09:59:10.7279|YHWkrv|CJPOWERCAST|OAuth: /api/v3/search/versions?_dc=1686819555841 t Transfer: 1220 : 12|09:59:10.7279|YHWkrv|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:10.7279|YHWkrv|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:10.7279|YHWkrv|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:59:10.7279|YHWkrv|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|09:59:10.7279|YHWkrv|CJPOWERCAST|V3Api.SearchVersions t Information: 1220 : 12|09:59:10.7279|YHWkrv|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|09:59:10.7279|YHWkrv|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:10.7289|YHWkrv|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:10.7289|YHWkrv|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|09:59:10.7289|YHWkrv|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:10.7289|YHWkrv|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:10.7289|YHWkrv|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|09:59:10.7289|YHWkrv|CJPOWERCAST|Running solr search: [q, (((series_id:299390)) AND deleted_flag:(0) AND (owners:((SFP2) OR (PSP) OR (PMS) OR (SFP1) OR (PMH) OR (PPL))))] t Information: 1220 : 12|09:59:10.9299|YHWkrv|CJPOWERCAST|Solr query returned: 7 in 4ms t Information: 1220 : 12|09:59:10.9299|YHWkrv|CJPOWERCAST|SearchVersion SQL: select * from (select a.*, rownum rnum from ( select m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE , (select min(name) from TM_CFG_AUDIO_CONTENT_MS_TYPES audio where m.audio_type = audio.id ) SOUND ,(select min(from_date_time) from TM_PG_RL_PROD_DATE prodDate where prodDate.Tm_Pg_Rl_Id = m.id ) PROD_FROM_DATE ,(select min(to_date_time) from TM_PG_RL_PROD_DATE prodDate where prodDate.Tm_Pg_Rl_Id = m.id ) PROD_TO_DATE ,(select min(full_name) from tm_lang_data lang, TM_PG_RL_LANG_LNX link where lang.id = link.lang_id and link.tm_pg_rl_id = m.id) PROD_LANGUAGE ,(SELECT min(COLOUR_NAME) FROM tm_cfg_colour_list list, tm_pg_rl ver where ver.col_mono = list.id and ver.id = m.id) PROD_COLOUR_TEXT ,(SELECT min(cfg.prod_date_type_name) FROM TM_PG_RL_PROD_DATE pg_rl, tm_cfg_prod_date_type cfg where cfg.id = pg_rl.PROD_DATE_TYPE_ID and TM_PG_RL_ID = m.id ) PROD_DATE_TYPE ,(select min(status.description) from TM_CFG_PGM_STATUS status where m.ITEM_STATUS_ID = status.id) PGM_STATUS_TEXT ,(select submed.sub_medium_name from TM_CFG_SUB_MEDIUM submed where m.SUB_MEDIUM_ID = submed.id) SUB_MEDIUM_TEXT, (select cvt.ID from TM_PORTAL_VERSION_CONFIG cvt where m.CUSTOM_VERSION_TYPE = cvt.CUSTOM_VERSION_TYPE AND cvt.CUSTOM_VERSION_TYPE IS NOT NULL ) MP_CONFIG_ID from (select v.*, coalesce(v.primary_thumb_id, (select x.primary_thumb_id from tm_pg_rl x where x.id=v.parent_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.pgm_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs2_id) ) primary_thumb_id2 from tmddba.tm_pg_rl v) m left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id2,(select /*+ cardinality(4) */ rownum rn, column_value id from table(:ids)) ids where item_type>0 and rl_deleted=0 and m.id = ids.id order by ids.rn ) a where rownum <= 10000) r where rnum >=1 order by rnum t Information: 1220 : 12|09:59:12.1359|YHWkrv|CJPOWERCAST|Running version search. User: 1165 Simple Search: Trying to use Solr Search... Solr completed in: 137ms. Returned lines: 7 Running Oracle search. Oracle version search timing: 1161ms. SQL run: select * from (select a.*, rownum rnum from ( select m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE , (select min(name) from TM_CFG_AUDIO_CONTENT_MS_TYPES audio where m.audio_type = audio.id ) SOUND ,(select min(from_date_time) from TM_PG_RL_PROD_DATE prodDate where prodDate.Tm_Pg_Rl_Id = m.id ) PROD_FROM_DATE ,(select min(to_date_time) from TM_PG_RL_PROD_DATE prodDate where prodDate.Tm_Pg_Rl_Id = m.id ) PROD_TO_DATE ,(select min(full_name) from tm_lang_data lang, TM_PG_RL_LANG_LNX link where lang.id = link.lang_id and link.tm_pg_rl_id = m.id) PROD_LANGUAGE ,(SELECT min(COLOUR_NAME) FROM tm_cfg_colour_list list, tm_pg_rl ver where ver.col_mono = list.id and ver.id = m.id) PROD_COLOUR_TEXT ,(SELECT min(cfg.prod_date_type_name) FROM TM_PG_RL_PROD_DATE pg_rl, tm_cfg_prod_date_type cfg where cfg.id = pg_rl.PROD_DATE_TYPE_ID and TM_PG_RL_ID = m.id ) PROD_DATE_TYPE ,(select min(status.description) from TM_CFG_PGM_STATUS status where m.ITEM_STATUS_ID = status.id) PGM_STATUS_TEXT ,(select submed.sub_medium_name from TM_CFG_SUB_MEDIUM submed where m.SUB_MEDIUM_ID = submed.id) SUB_MEDIUM_TEXT, (select cvt.ID from TM_PORTAL_VERSION_CONFIG cvt where m.CUSTOM_VERSION_TYPE = cvt.CUSTOM_VERSION_TYPE AND cvt.CUSTOM_VERSION_TYPE IS NOT NULL ) MP_CONFIG_ID from (select v.*, coalesce(v.primary_thumb_id, (select x.primary_thumb_id from tm_pg_rl x where x.id=v.parent_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.pgm_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs2_id) ) primary_thumb_id2 from tmddba.tm_pg_rl v) m left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id2,(select /*+ cardinality(4) */ rownum rn, column_value id from table(:ids)) ids where item_type>0 and rl_deleted=0 and m.id = ids.id order by ids.rn ) a where rownum <= 10000) r where rnum >=1 order by rnum t Verbose: 1220 : 12|09:59:12.1359|YHWkrv|CJPOWERCAST|imfx v3 API took 1.334s '/api/v3/search/versions?_dc=1686819555841' t Transfer: 1220 : 12|09:59:12.5379|H4cMJV|CJPOWERCAST|OAuth: /api/user-preferences?_dc=1686819557775 t Transfer: 1220 : 12|09:59:12.5379|H4cMJV|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:12.5379|H4cMJV|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:12.5379|H4cMJV|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:59:12.5379|H4cMJV|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 12|09:59:12.5379|H4cMJV|CJPOWERCAST|StoreUserDataByKeys.. t Transfer: 1220 : 12|09:59:12.5389|H4cMJV|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:12.5389|H4cMJV|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:12.5389|H4cMJV|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:59:12.5389|H4cMJV|CJPOWERCAST|imfx v3 API took 0.010s '/api/user-preferences?_dc=1686819557775' t Transfer: 1220 : 12|09:59:19.3719|zbuJtu|CJPOWERCAST|OAuth: /api/view/searches/TitleSearch?_dc=1686819564362 t Transfer: 1220 : 12|09:59:19.3719|zbuJtu|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:19.3719|zbuJtu|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:19.3719|zbuJtu|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:59:19.3719|zbuJtu|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|09:59:19.3719|LLXnfP|CJPOWERCAST|OAuth: /api/user-preferences?keys=adv.recent.searches.titles&_dc=1686819564301 t Transfer: 1220 : 12|09:59:19.3719|LLXnfP|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:19.3729|LLXnfP|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:19.3729|LLXnfP|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:59:19.3729|LLXnfP|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|09:59:19.3729|FiG2vc|CJPOWERCAST|OAuth: /api/view/info/MediaGrid?lang=en-GB&_dc=1686819564502 t Transfer: 1220 : 12|09:59:19.3729|FiG2vc|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:19.3729|FiG2vc|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:19.3729|FiG2vc|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:59:19.3729|FiG2vc|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|09:59:19.3729|KklMei|CJPOWERCAST|OAuth: /api/view/searchinfo/TitleSearch?_dc=1686819564297 t Transfer: 1220 : 12|09:59:19.3729|KklMei|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:19.3729|KklMei|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:19.3739|KklMei|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:59:19.3739|KklMei|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|09:59:19.3739|LLXnfP|CJPOWERCAST|GetUserDataByKeys: adv.recent.searches.titles t Transfer: 1220 : 12|09:59:19.3739|LLXnfP|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:19.3739|LLXnfP|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:19.3739|LLXnfP|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|09:59:19.3739|zbuJtu|CJPOWERCAST|GetSavedSearchNames. search type TitleSearch. t Transfer: 1220 : 12|09:59:19.3749|zbuJtu|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:19.3749|zbuJtu|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:19.3749|zbuJtu|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|09:59:19.3749|FiG2vc|CJPOWERCAST|GetGridViewBuilder. builder type MediaGrid. t Transfer: 1220 : 12|09:59:19.3749|FiG2vc|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:19.3749|FiG2vc|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:19.3749|FiG2vc|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|09:59:19.3749|KklMei|CJPOWERCAST|GetAdvSearchColumns. search type TitleSearch grid . t Verbose: 1220 : 12|09:59:19.3749|KklMei|CJPOWERCAST|imfx v3 API took 0.000s '/api/view/searchinfo/TitleSearch?_dc=1686819564297' t Information: 1220 : 12|09:59:19.3749|FiG2vc|CJPOWERCAST|UserGridView. LoadView. ID -2, Name Default. t Transfer: 1220 : 12|09:59:19.3759|FiG2vc|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:19.3759|FiG2vc|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:19.3759|FiG2vc|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:59:19.3759|zbuJtu|CJPOWERCAST|imfx v3 API took 0.006s '/api/view/searches/TitleSearch?_dc=1686819564362' t Verbose: 1220 : 12|09:59:19.3759|LLXnfP|CJPOWERCAST|imfx v3 API took 0.008s '/api/user-preferences?keys=adv.recent.searches.titles&_dc=1686819564301' t Transfer: 1220 : 12|09:59:19.3759|FiG2vc|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:19.3759|FiG2vc|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:19.3759|FiG2vc|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:59:19.3759|FiG2vc|CJPOWERCAST|imfx v3 API took 0.009s '/api/view/info/MediaGrid?lang=en-GB&_dc=1686819564502' t Transfer: 1220 : 12|09:59:19.3759|ZKU1Ac|CJPOWERCAST|OAuth: /api/view/info/DigitalCarriers?lang=en-GB&_dc=1686819564608 t Transfer: 1220 : 12|09:59:19.3769|ZKU1Ac|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:19.3769|ZKU1Ac|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:19.3769|ZKU1Ac|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:59:19.3769|ZKU1Ac|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|09:59:19.3769|ZKU1Ac|CJPOWERCAST|GetGridViewBuilder. builder type DigitalCarriers. t Transfer: 1220 : 12|09:59:19.3769|ZKU1Ac|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:19.3769|ZKU1Ac|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:19.3769|ZKU1Ac|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|09:59:19.3769|ZKU1Ac|CJPOWERCAST|UserGridView. LoadView. ID -2, Name Default. t Transfer: 1220 : 12|09:59:19.3769|ZKU1Ac|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:19.3779|ZKU1Ac|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:19.3779|ZKU1Ac|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|09:59:19.3779|ZKU1Ac|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:19.3779|ZKU1Ac|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:19.3779|ZKU1Ac|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:59:19.3779|ZKU1Ac|CJPOWERCAST|imfx v3 API took 0.007s '/api/view/info/DigitalCarriers?lang=en-GB&_dc=1686819564608' t Transfer: 1220 : 12|09:59:19.7799|y7Q5kI|CJPOWERCAST|OAuth: /api/view/info/TitleTree?lang=en-GB&_dc=1686819564688 t Transfer: 1220 : 12|09:59:19.7799|y7Q5kI|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:19.7799|y7Q5kI|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:19.7799|y7Q5kI|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:59:19.7799|y7Q5kI|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|09:59:19.7799|y7Q5kI|CJPOWERCAST|GetGridViewBuilder. builder type TitleTree. t Transfer: 1220 : 12|09:59:19.7799|y7Q5kI|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:19.7799|y7Q5kI|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:19.7809|y7Q5kI|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|09:59:19.7809|y7Q5kI|CJPOWERCAST|UserGridView. LoadView. ID -2, Name Default. t Transfer: 1220 : 12|09:59:19.7809|y7Q5kI|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:19.7809|y7Q5kI|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:19.7809|y7Q5kI|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|09:59:19.7809|y7Q5kI|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:19.7809|y7Q5kI|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:19.7809|y7Q5kI|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:59:19.7809|y7Q5kI|CJPOWERCAST|imfx v3 API took 0.007s '/api/view/info/TitleTree?lang=en-GB&_dc=1686819564688' t Transfer: 1220 : 12|09:59:24.0019|pmNZpv|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1686819569121 t Transfer: 1220 : 12|09:59:24.0019|pmNZpv|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:24.0019|pmNZpv|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:24.0019|pmNZpv|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:59:24.0019|pmNZpv|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|09:59:24.0019|pmNZpv|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:24.0019|pmNZpv|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:24.0019|pmNZpv|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:59:24.0029|pmNZpv|CJPOWERCAST|imfx v3 API took 0.006s '/api/v3/search-suggestion/?_dc=1686819569121' t Transfer: 1220 : 12|09:59:24.2039|GnGTit|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1686819569323 t Transfer: 1220 : 12|09:59:24.2039|GnGTit|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:24.2039|GnGTit|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:24.2039|GnGTit|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:59:24.2039|GnGTit|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|09:59:24.2039|GnGTit|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:24.2049|GnGTit|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:24.2049|GnGTit|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:59:24.2049|GnGTit|CJPOWERCAST|imfx v3 API took 0.008s '/api/v3/search-suggestion/?_dc=1686819569323' t Transfer: 1220 : 12|09:59:26.6149|M9mv5y|CJPOWERCAST|OAuth: /api/v3/search/title?_dc=1686819571743 t Transfer: 1220 : 12|09:59:26.6149|M9mv5y|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:26.6149|M9mv5y|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:26.6149|M9mv5y|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:59:26.6149|M9mv5y|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|09:59:26.6159|M9mv5y|CJPOWERCAST|V3Api.SearchTitles t Information: 1220 : 12|09:59:26.6159|M9mv5y|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|09:59:26.6159|M9mv5y|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:26.6159|M9mv5y|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:26.6159|M9mv5y|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|09:59:26.6159|M9mv5y|CJPOWERCAST|SearchTitle SQL: with v as ( SELECT abs.* ,(select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = abs.net_grp_id) CHANNEL_GROUP ,decode(ITEM_TYPE, 1010,SER_ABS_ID, 1020,CASE WHEN SER_ABS2_ID > 0 THEN SER_ABS2_ID ELSE SER_ABS_ID END ) xparent_id FROM TMDDBA.TM_PG_ABS abs WHERE abs.id in ( select a.id FROM TMDDBA.TM_PG_ABS a where ABS_DELETED = 0 AND (INSTR(OWNERS,'|SFP2|')>0 OR INSTR(OWNERS,'|PSP|')>0 OR INSTR(OWNERS,'|PMS|')>0 OR INSTR(OWNERS,'|SFP1|')>0 OR INSTR(OWNERS,'|PMH|')>0 OR INSTR(OWNERS,'|PPL|')>0 ) AND a.ser_abs_id=:param_0 AND ROWNUM < 25000 ) ) ,v_missing_parent_ids as ( select xparent_id from v minus select id from v ) ,v_missing_parents as ( SELECT distinct a.* ,(select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = a.net_grp_id) CHANNEL_GROUP ,decode(ITEM_TYPE, 1010,SER_ABS_ID, 1020,CASE WHEN SER_ABS2_ID > 0 THEN SER_ABS2_ID ELSE SER_ABS_ID END ) xparent_id FROM TMDDBA.TM_PG_ABS a START WITH ID IN (select xparent_id from v_missing_parent_ids) CONNECT BY CASE PRIOR ITEM_TYPE WHEN 1010 THEN PRIOR SER_ABS_ID WHEN 1020 THEN CASE WHEN NVL(PRIOR SER_ABS2_ID, 0) > 0 THEN PRIOR SER_ABS2_ID ELSE PRIOR SER_ABS_ID END END = ID ) ,v_all as ( select x.*, count(*) over() RowCount from ( select * from v_missing_parents union select * from v ) x ) ,v_top as ( select id from (select id, row_number()over(order by upper(ser_title),upper(title),ser_num,ser_ep_num, SER_EP_SQ_NUM ) rnk -- sort roots from v_all where xparent_id is null) where rnk between (:page_number-1)*50+1 and :page_number*50 ) ,v_tree as ( select level "TreeLevel", a.*from v_all a start with id in (select id from v_top) connect by xparent_id = prior ID order siblings by upper(ser_title),ser_num,ser_ep_num, SER_EP_SQ_NUM,upper(title) -- sort children ) select * from v_tree --where rnk <= 50 t Verbose: 1220 : 12|09:59:27.0179|M9mv5y|CJPOWERCAST|imfx v3 API took 0.363s '/api/v3/search/title?_dc=1686819571743' t Transfer: 1220 : 12|09:59:27.4199|C~hoEL|CJPOWERCAST|OAuth: /api/user-preferences?_dc=1686819572524 t Transfer: 1220 : 12|09:59:27.4199|C~hoEL|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:27.4199|C~hoEL|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:27.4199|C~hoEL|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:59:27.4199|C~hoEL|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|09:59:27.4199|wySHLm|CJPOWERCAST|OAuth: /api/v3/title/299390/versions?_dc=1686819572522 t Transfer: 1220 : 12|09:59:27.4199|wySHLm|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:27.4199|wySHLm|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:27.4209|wySHLm|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:59:27.4209|wySHLm|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 12|09:59:27.4209|C~hoEL|CJPOWERCAST|StoreUserDataByKeys.. t Transfer: 1220 : 12|09:59:27.4209|C~hoEL|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:27.4209|C~hoEL|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:27.4209|C~hoEL|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|09:59:27.4209|wySHLm|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|09:59:27.4209|wySHLm|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:27.4209|wySHLm|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:27.4209|wySHLm|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|09:59:27.4219|wySHLm|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:27.4219|wySHLm|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:27.4219|wySHLm|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|09:59:27.4219|wySHLm|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:27.4219|wySHLm|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:27.4219|wySHLm|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|09:59:27.4219|wySHLm|CJPOWERCAST|SearchVersion SQL: select v.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE , (select min(name) from TM_CFG_AUDIO_CONTENT_MS_TYPES audio where v.audio_type = audio.id ) SOUND ,(select min(from_date_time) from TM_PG_RL_PROD_DATE prodDate where prodDate.Tm_Pg_Rl_Id = v.id ) PROD_FROM_DATE ,(select min(to_date_time) from TM_PG_RL_PROD_DATE prodDate where prodDate.Tm_Pg_Rl_Id = v.id ) PROD_TO_DATE ,(select min(full_name) from tm_lang_data lang, TM_PG_RL_LANG_LNX link where lang.id = link.lang_id and link.tm_pg_rl_id = v.id) PROD_LANGUAGE ,(SELECT min(COLOUR_NAME) FROM tm_cfg_colour_list list, tm_pg_rl ver where ver.col_mono = list.id and ver.id = v.id) PROD_COLOUR_TEXT ,(SELECT min(cfg.prod_date_type_name) FROM TM_PG_RL_PROD_DATE pg_rl, tm_cfg_prod_date_type cfg where cfg.id = pg_rl.PROD_DATE_TYPE_ID and TM_PG_RL_ID = v.id ) PROD_DATE_TYPE ,(select min(status.description) from TM_CFG_PGM_STATUS status where v.ITEM_STATUS_ID = status.id) PGM_STATUS_TEXT ,(select submed.sub_medium_name from TM_CFG_SUB_MEDIUM submed where v.SUB_MEDIUM_ID = submed.id) SUB_MEDIUM_TEXT, (select cvt.ID from TM_PORTAL_VERSION_CONFIG cvt where v.CUSTOM_VERSION_TYPE = cvt.CUSTOM_VERSION_TYPE AND cvt.CUSTOM_VERSION_TYPE IS NOT NULL ) MP_CONFIG_ID from (select v.*, coalesce(v.primary_thumb_id, (select x.primary_thumb_id from tm_pg_rl x where x.id=v.parent_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.pgm_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs2_id) ) primary_thumb_id2 from tmddba.tm_pg_rl v where v.item_type > 0 and v.rl_deleted = 0) v left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = v.primary_thumb_id2 --sqlIdSearchJoin where 1=1 AND (INSTR(v.OWNERS,'|SFP2|')>0 OR INSTR(v.OWNERS,'|PSP|')>0 OR INSTR(v.OWNERS,'|PMS|')>0 OR INSTR(v.OWNERS,'|SFP1|')>0 OR INSTR(v.OWNERS,'|PMH|')>0 OR INSTR(v.OWNERS,'|PPL|')>0) and v.id in (select x.id from tmddba.tm_pg_rl x start with x.id in ( select a.id from (select m.id, rownum rnum from tmddba.tm_pg_rl m where item_type>0 and rl_deleted=0 and m.PGM_ABS_ID=:param_0 AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0) ) A WHERE rnum>=1 and rnum <= 9999 ) connect by nocycle prior x.parent_id=x.id) t Transfer: 1220 : 12|09:59:27.4219|wySHLm|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:27.4229|wySHLm|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:27.4229|wySHLm|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:59:27.4229|C~hoEL|CJPOWERCAST|imfx v3 API took 0.016s '/api/user-preferences?_dc=1686819572524' t Information: 1220 : 12|09:59:27.4229|wySHLm|CJPOWERCAST|Running version search. User: 1165 Simple Search: Running Oracle search. Running Oracle search for COUNT Oracle count completed in: 7ms. Returned lines: 0 t Verbose: 1220 : 12|09:59:27.4229|wySHLm|CJPOWERCAST|imfx v3 API took 0.019s '/api/v3/title/299390/versions?_dc=1686819572522' t Transfer: 1220 : 12|09:59:28.6289|V9zyE9|CJPOWERCAST|OAuth: /api/v3/title/299562/versions?_dc=1686819573875 t Transfer: 1220 : 12|09:59:28.6289|V9zyE9|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:28.6289|V9zyE9|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:28.6289|V9zyE9|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:59:28.6289|V9zyE9|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|09:59:28.6289|V9zyE9|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|09:59:28.6289|V9zyE9|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:28.6289|V9zyE9|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:28.6299|V9zyE9|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|09:59:28.6299|V9zyE9|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:28.6299|V9zyE9|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:28.6299|V9zyE9|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|09:59:28.6299|V9zyE9|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:28.6299|V9zyE9|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:28.6299|V9zyE9|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|09:59:28.8309|V9zyE9|CJPOWERCAST|SearchVersion SQL: select v.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE , (select min(name) from TM_CFG_AUDIO_CONTENT_MS_TYPES audio where v.audio_type = audio.id ) SOUND ,(select min(from_date_time) from TM_PG_RL_PROD_DATE prodDate where prodDate.Tm_Pg_Rl_Id = v.id ) PROD_FROM_DATE ,(select min(to_date_time) from TM_PG_RL_PROD_DATE prodDate where prodDate.Tm_Pg_Rl_Id = v.id ) PROD_TO_DATE ,(select min(full_name) from tm_lang_data lang, TM_PG_RL_LANG_LNX link where lang.id = link.lang_id and link.tm_pg_rl_id = v.id) PROD_LANGUAGE ,(SELECT min(COLOUR_NAME) FROM tm_cfg_colour_list list, tm_pg_rl ver where ver.col_mono = list.id and ver.id = v.id) PROD_COLOUR_TEXT ,(SELECT min(cfg.prod_date_type_name) FROM TM_PG_RL_PROD_DATE pg_rl, tm_cfg_prod_date_type cfg where cfg.id = pg_rl.PROD_DATE_TYPE_ID and TM_PG_RL_ID = v.id ) PROD_DATE_TYPE ,(select min(status.description) from TM_CFG_PGM_STATUS status where v.ITEM_STATUS_ID = status.id) PGM_STATUS_TEXT ,(select submed.sub_medium_name from TM_CFG_SUB_MEDIUM submed where v.SUB_MEDIUM_ID = submed.id) SUB_MEDIUM_TEXT, (select cvt.ID from TM_PORTAL_VERSION_CONFIG cvt where v.CUSTOM_VERSION_TYPE = cvt.CUSTOM_VERSION_TYPE AND cvt.CUSTOM_VERSION_TYPE IS NOT NULL ) MP_CONFIG_ID from (select v.*, coalesce(v.primary_thumb_id, (select x.primary_thumb_id from tm_pg_rl x where x.id=v.parent_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.pgm_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs2_id) ) primary_thumb_id2 from tmddba.tm_pg_rl v where v.item_type > 0 and v.rl_deleted = 0) v left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = v.primary_thumb_id2 --sqlIdSearchJoin where 1=1 AND (INSTR(v.OWNERS,'|SFP2|')>0 OR INSTR(v.OWNERS,'|PSP|')>0 OR INSTR(v.OWNERS,'|PMS|')>0 OR INSTR(v.OWNERS,'|SFP1|')>0 OR INSTR(v.OWNERS,'|PMH|')>0 OR INSTR(v.OWNERS,'|PPL|')>0) and v.id in (select x.id from tmddba.tm_pg_rl x start with x.id in ( select a.id from (select m.id, rownum rnum from tmddba.tm_pg_rl m where item_type>0 and rl_deleted=0 and m.PGM_ABS_ID=:param_0 AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0) ) A WHERE rnum>=1 and rnum <= 9999 ) connect by nocycle prior x.parent_id=x.id) t Transfer: 1220 : 12|09:59:28.8309|V9zyE9|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:28.8309|V9zyE9|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:28.8309|V9zyE9|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|09:59:29.2329|V9zyE9|CJPOWERCAST|Running version search. User: 1165 Simple Search: Running Oracle search. Running Oracle search for COUNT Oracle count completed in: 5ms. Returned lines: 1 Oracle version search timing: 395ms. SQL run: select v.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE , (select min(name) from TM_CFG_AUDIO_CONTENT_MS_TYPES audio where v.audio_type = audio.id ) SOUND ,(select min(from_date_time) from TM_PG_RL_PROD_DATE prodDate where prodDate.Tm_Pg_Rl_Id = v.id ) PROD_FROM_DATE ,(select min(to_date_time) from TM_PG_RL_PROD_DATE prodDate where prodDate.Tm_Pg_Rl_Id = v.id ) PROD_TO_DATE ,(select min(full_name) from tm_lang_data lang, TM_PG_RL_LANG_LNX link where lang.id = link.lang_id and link.tm_pg_rl_id = v.id) PROD_LANGUAGE ,(SELECT min(COLOUR_NAME) FROM tm_cfg_colour_list list, tm_pg_rl ver where ver.col_mono = list.id and ver.id = v.id) PROD_COLOUR_TEXT ,(SELECT min(cfg.prod_date_type_name) FROM TM_PG_RL_PROD_DATE pg_rl, tm_cfg_prod_date_type cfg where cfg.id = pg_rl.PROD_DATE_TYPE_ID and TM_PG_RL_ID = v.id ) PROD_DATE_TYPE ,(select min(status.description) from TM_CFG_PGM_STATUS status where v.ITEM_STATUS_ID = status.id) PGM_STATUS_TEXT ,(select submed.sub_medium_name from TM_CFG_SUB_MEDIUM submed where v.SUB_MEDIUM_ID = submed.id) SUB_MEDIUM_TEXT, (select cvt.ID from TM_PORTAL_VERSION_CONFIG cvt where v.CUSTOM_VERSION_TYPE = cvt.CUSTOM_VERSION_TYPE AND cvt.CUSTOM_VERSION_TYPE IS NOT NULL ) MP_CONFIG_ID from (select v.*, coalesce(v.primary_thumb_id, (select x.primary_thumb_id from tm_pg_rl x where x.id=v.parent_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.pgm_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs2_id) ) primary_thumb_id2 from tmddba.tm_pg_rl v where v.item_type > 0 and v.rl_deleted = 0) v left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = v.primary_thumb_id2 --sqlIdSearchJoin where 1=1 AND (INSTR(v.OWNERS,'|SFP2|')>0 OR INSTR(v.OWNERS,'|PSP|')>0 OR INSTR(v.OWNERS,'|PMS|')>0 OR INSTR(v.OWNERS,'|SFP1|')>0 OR INSTR(v.OWNERS,'|PMH|')>0 OR INSTR(v.OWNERS,'|PPL|')>0) and v.id in (select x.id from tmddba.tm_pg_rl x start with x.id in ( select a.id from (select m.id, rownum rnum from tmddba.tm_pg_rl m where item_type>0 and rl_deleted=0 and m.PGM_ABS_ID=:param_0 AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0) ) A WHERE rnum>=1 and rnum <= 9999 ) connect by nocycle prior x.parent_id=x.id) t Verbose: 1220 : 12|09:59:29.2329|V9zyE9|CJPOWERCAST|imfx v3 API took 0.412s '/api/v3/title/299562/versions?_dc=1686819573875' t Transfer: 1220 : 12|09:59:29.4339|Flwr5r|CJPOWERCAST|OAuth: /api/v3/version/299563/media?_dc=1686819574602 t Transfer: 1220 : 12|09:59:29.4339|Flwr5r|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:29.4339|Flwr5r|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:29.4339|Flwr5r|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:59:29.4339|Flwr5r|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|09:59:29.4349|Flwr5r|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|09:59:29.4349|T6baf0|CJPOWERCAST|OAuth: /api/v3/version/299563/media?_dc=1686819574623 t Transfer: 1220 : 12|09:59:29.4349|T6baf0|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:29.4349|T6baf0|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:29.4349|T6baf0|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:59:29.4349|T6baf0|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|09:59:29.4349|T6baf0|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|09:59:29.4349|Flwr5r|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:29.4359|Flwr5r|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:29.4359|Flwr5r|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|09:59:29.4359|T6baf0|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:29.4359|T6baf0|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:29.4359|T6baf0|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|09:59:29.4359|Flwr5r|CJPOWERCAST|MediaSearch SQL: --sqlFromPaging select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type in (1,110)),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , (SELECT min(status.ACCESS_STATUS_NAME) FROM TMDDBA.TM_ACCESS_STATUS statusLnx, TM_CFG_ACCESS_STATUS status WHERE statusLnx.Media_Id = r.id and statusLnx.Status_Id = status.id) ACCESS_STATUS , (select min(acq.ext_ref) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) CONSIGNMENT_NUMBER , (select min(acq.alt_id1) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) TRANSFER_NUMBER , (select min(crs.series_number) from tm_series_data crs where crs.id = r.GROUP_SERIES_ID) CRS_SERIES , (select min(DISPOSAL_NAME) from TM_ACQ_DISPOSAL status, tm_disposal_records records where status.id = records.disposal_status_id and records.miid = r.id) DISPOSAL_STATUS , (select min(class.class_number) from TM_ACQ_DISPOSAL status, tm_disposal_records records, tm_disposal_classes class where status.id = records.disposal_status_id and records.miid = r.id and class.id = records.disposal_class_id) DISPOSAL_CLASS, (select min(names.concat_search_name) from tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names where r.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY, (select min(c.u_id_ext1) from tmddba.tm_mi_tpi_lnx lnx, tm_ctnrs c where c.u_id = lnx.tpiid and lnx.miid = r.id) U_ID_EXT1 , (select t.name from TM_CFG_MI_FMT_TYP t where t.id = r.mi_fmt_type) ITEM_FORMAT_TEXT, CASE WHEN BITAND(r.COMPIL, 2) = 2 THEN 'SUPPLIED' WHEN BITAND(r.COMPIL, 4) = 4 THEN 'MADE' WHEN BITAND(r.COMPIL, 134217728) = 134217728 THEN 'IMPORTED' ELSE '' END AS ORIGIN, CASE WHEN BITAND(r.COMPIL, 512) = 512 THEN 'Attached' WHEN BITAND(r.COMPIL, 1024) = 1024 THEN 'Un-Attached' ELSE '' END AS FLAGS, (select min(lang.full_name) from TM_PG_RL_LANG_LNX lnx, TM_LANG_DATA lang where lnx.tm_pg_rl_id = r.pgm_parent_id and lnx.lang_id = lang.id) AS PROD_LANGUAGE , (select min(ctx.ITFC_CODE) from tm_mis mis, tm_mi_tpi_lnx links, tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names where mis.id = r.id and links.miid = mis.id and mis.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY_NUMBER, (select min(status.description) from TM_CFG_PGM_STATUS status where r.status = status.id) PGM_STATUS_TEXT, (select min(ver.DUR) from TM_PG_RL ver where r.pgm_PARENT_ID = ver.id) AS VERSION_DUR , (select tmd_str_agg_pipe(cms.status_type_id ||',' ||cms.status_id) from tm_mi_cust_med_stat_lnx cms where cms.media_id=r.id) "CustomStatusesRaw", (select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = r.net_grp_id) CHANNEL_GROUP, (SELECT SUBSTR( trim( replace (replace ( LISTAGG(trim(tt.tags || ' ' || tt.notes), ' ') WITHIN GROUP (ORDER BY trim(tt.tags || ' ' || tt.notes)), chr (13), ''), chr (10), ' ')), 1, 150) z FROM tm_media_tagging tt WHERE link_guid = DFILE_LINK_GUID and rownum=1) TAGS_TEXT , GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select t.*, coalesce(t.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=t.pgm_parent_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.pgm_abs_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs2_id) ) primary_thumb_id2 from ( --sqlSubSelect select s.* from (select a.*, rownum rnum from (select --sqlFrom m.* from tmddba.tm_mis m --sqlWhere where media_type>0 and item_type>0 AND PGM_PARENT_ID=:param_0 and m.mi_deleted=0 AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0) order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) s where rnum >= 1) t ) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl order by r.rnum t Information: 1220 : 12|09:59:29.4369|T6baf0|CJPOWERCAST|MediaSearch SQL: --sqlFromPaging select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type in (1,110)),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , (SELECT min(status.ACCESS_STATUS_NAME) FROM TMDDBA.TM_ACCESS_STATUS statusLnx, TM_CFG_ACCESS_STATUS status WHERE statusLnx.Media_Id = r.id and statusLnx.Status_Id = status.id) ACCESS_STATUS , (select min(acq.ext_ref) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) CONSIGNMENT_NUMBER , (select min(acq.alt_id1) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) TRANSFER_NUMBER , (select min(crs.series_number) from tm_series_data crs where crs.id = r.GROUP_SERIES_ID) CRS_SERIES , (select min(DISPOSAL_NAME) from TM_ACQ_DISPOSAL status, tm_disposal_records records where status.id = records.disposal_status_id and records.miid = r.id) DISPOSAL_STATUS , (select min(class.class_number) from TM_ACQ_DISPOSAL status, tm_disposal_records records, tm_disposal_classes class where status.id = records.disposal_status_id and records.miid = r.id and class.id = records.disposal_class_id) DISPOSAL_CLASS, (select min(names.concat_search_name) from tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names where r.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY, (select min(c.u_id_ext1) from tmddba.tm_mi_tpi_lnx lnx, tm_ctnrs c where c.u_id = lnx.tpiid and lnx.miid = r.id) U_ID_EXT1 , (select t.name from TM_CFG_MI_FMT_TYP t where t.id = r.mi_fmt_type) ITEM_FORMAT_TEXT, CASE WHEN BITAND(r.COMPIL, 2) = 2 THEN 'SUPPLIED' WHEN BITAND(r.COMPIL, 4) = 4 THEN 'MADE' WHEN BITAND(r.COMPIL, 134217728) = 134217728 THEN 'IMPORTED' ELSE '' END AS ORIGIN, CASE WHEN BITAND(r.COMPIL, 512) = 512 THEN 'Attached' WHEN BITAND(r.COMPIL, 1024) = 1024 THEN 'Un-Attached' ELSE '' END AS FLAGS, (select min(lang.full_name) from TM_PG_RL_LANG_LNX lnx, TM_LANG_DATA lang where lnx.tm_pg_rl_id = r.pgm_parent_id and lnx.lang_id = lang.id) AS PROD_LANGUAGE , (select min(ctx.ITFC_CODE) from tm_mis mis, tm_mi_tpi_lnx links, tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names where mis.id = r.id and links.miid = mis.id and mis.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY_NUMBER, (select min(status.description) from TM_CFG_PGM_STATUS status where r.status = status.id) PGM_STATUS_TEXT, (select min(ver.DUR) from TM_PG_RL ver where r.pgm_PARENT_ID = ver.id) AS VERSION_DUR , (select tmd_str_agg_pipe(cms.status_type_id ||',' ||cms.status_id) from tm_mi_cust_med_stat_lnx cms where cms.media_id=r.id) "CustomStatusesRaw", (select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = r.net_grp_id) CHANNEL_GROUP, (SELECT SUBSTR( trim( replace (replace ( LISTAGG(trim(tt.tags || ' ' || tt.notes), ' ') WITHIN GROUP (ORDER BY trim(tt.tags || ' ' || tt.notes)), chr (13), ''), chr (10), ' ')), 1, 150) z FROM tm_media_tagging tt WHERE link_guid = DFILE_LINK_GUID and rownum=1) TAGS_TEXT , GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select t.*, coalesce(t.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=t.pgm_parent_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.pgm_abs_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs2_id) ) primary_thumb_id2 from ( --sqlSubSelect select s.* from (select a.*, rownum rnum from (select --sqlFrom m.* from tmddba.tm_mis m --sqlWhere where media_type>0 and item_type>0 AND PGM_PARENT_ID=:param_0 and m.mi_deleted=0 AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0) order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) s where rnum >= 1) t ) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl order by r.rnum t Verbose: 1220 : 12|09:59:29.6379|Flwr5r|CJPOWERCAST|Alternative title fields query: select * from (select x.id,x.pgm_abs_id TitleId, x.pgm_parent_id VersionId from tm_mis x where id in (select /*+ cardinality(4) */ column_value id from table(:ids))) y,lateral (select dbms_lob.substr( o.text_data_plain, 1000, 1 ) Field_5799344 from tm_txt_obj o where (o.pgm_abs_id=y.TitleId or o.pgm_rl_id = y.VersionId) and o.type_id=:param_1 order by o.id desc fetch first 1 rows only)(+) t Verbose: 1220 : 12|09:59:29.6379|T6baf0|CJPOWERCAST|Alternative title fields query: select * from (select x.id,x.pgm_abs_id TitleId, x.pgm_parent_id VersionId from tm_mis x where id in (select /*+ cardinality(4) */ column_value id from table(:ids))) y,lateral (select dbms_lob.substr( o.text_data_plain, 1000, 1 ) Field_5799344 from tm_txt_obj o where (o.pgm_abs_id=y.TitleId or o.pgm_rl_id = y.VersionId) and o.type_id=:param_1 order by o.id desc fetch first 1 rows only)(+) t Information: 1220 : 12|09:59:29.6379|T6baf0|CJPOWERCAST| timing: 00:00:00.1096100 t Verbose: 1220 : 12|09:59:29.6379|T6baf0|CJPOWERCAST|imfx v3 API took 0.110s '/api/v3/version/299563/media?_dc=1686819574623' t Information: 1220 : 12|09:59:29.6379|Flwr5r|CJPOWERCAST| timing: 00:00:00.1227146 t Verbose: 1220 : 12|09:59:29.6379|Flwr5r|CJPOWERCAST|imfx v3 API took 0.134s '/api/v3/version/299563/media?_dc=1686819574602' t Transfer: 1220 : 12|09:59:29.8389|Flwr5r|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0013.mp4 subfolder t Transfer: 1220 : 12|09:59:29.8389|T6baf0|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0013.mp4 subfolder t Transfer: 1220 : 12|09:59:29.8389|T6baf0|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0013.mp4 t Transfer: 1220 : 12|09:59:29.8389|T6baf0|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0013.mp4 t Transfer: 1220 : 12|09:59:29.8389|T6baf0|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:29.8389|T6baf0|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:29.8389|T6baf0|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|09:59:29.8399|Flwr5r|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0013.mp4 t Transfer: 1220 : 12|09:59:29.8399|Flwr5r|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0013.mp4 t Transfer: 1220 : 12|09:59:29.8399|Flwr5r|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:29.8399|Flwr5r|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:29.8399|Flwr5r|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|09:59:29.8399|T6baf0|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001993.mp4 subfolder t Transfer: 1220 : 12|09:59:29.8399|T6baf0|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001993.mp4 t Transfer: 1220 : 12|09:59:29.8399|T6baf0|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001993.mp4 t Transfer: 1220 : 12|09:59:29.8399|T6baf0|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:29.8399|T6baf0|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:29.8409|T6baf0|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|09:59:29.8409|Flwr5r|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001993.mp4 subfolder t Transfer: 1220 : 12|09:59:29.8409|Flwr5r|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001993.mp4 t Transfer: 1220 : 12|09:59:29.8409|Flwr5r|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001993.mp4 t Transfer: 1220 : 12|09:59:29.8409|Flwr5r|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:29.8409|Flwr5r|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:29.8409|Flwr5r|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|09:59:29.8409|T6baf0|CJPOWERCAST|GetUrl. Storage |Temp Storage| filename C:\TEMP\GOPR0013.mp4 subfolder t Transfer: 1220 : 12|09:59:29.8409|T6baf0|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:29.8409|T6baf0|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:29.8419|T6baf0|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|09:59:29.8419|Flwr5r|CJPOWERCAST|GetUrl. Storage |Temp Storage| filename C:\TEMP\GOPR0013.mp4 subfolder t Transfer: 1220 : 12|09:59:29.8419|Flwr5r|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:29.8419|Flwr5r|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:29.8419|Flwr5r|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|09:59:29.8419|T6baf0|CJPOWERCAST|GetUrl. Storage |Temp Storage| filename C:\TEMP\N0001993.mp4 subfolder t Transfer: 1220 : 12|09:59:29.8419|T6baf0|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:29.8419|T6baf0|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:29.8419|T6baf0|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|09:59:29.8419|Flwr5r|CJPOWERCAST|GetUrl. Storage |Temp Storage| filename C:\TEMP\N0001993.mp4 subfolder t Transfer: 1220 : 12|09:59:29.8429|Flwr5r|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:29.8429|Flwr5r|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:29.8429|Flwr5r|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|09:59:30.2449|r31Suk|CJPOWERCAST|OAuth: /api/v3/media/299528/carriers/digital?_dc=1686819575342 t Transfer: 1220 : 12|09:59:30.2449|r31Suk|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:30.2449|r31Suk|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:30.2449|r31Suk|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:59:30.2449|r31Suk|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|09:59:30.2449|r31Suk|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|09:59:30.2449|r31Suk|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:30.2449|r31Suk|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:30.2459|r31Suk|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|09:59:30.2459|r31Suk|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:30.2459|r31Suk|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:30.2459|r31Suk|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|09:59:30.2459|r31Suk|CJPOWERCAST|SearchDigitalCarriersAdv SQL: select r.*, l.dv_nam SRVER_ID_TEXT from ( select a.*, rownum rnum from ( select m.* from tmddba.tm_dfile m where m.id in (select l.dfile_id as ID from TMDDBA.tm_mi_dfile_lnx l join TMDDBA.TM_MIS mi on (l.mi_id = mi.id) where (INSTR(mi.OWNERS,'|SFP2|')>0 OR INSTR(mi.OWNERS,'|PSP|')>0 OR INSTR(mi.OWNERS,'|PMS|')>0 OR INSTR(mi.OWNERS,'|SFP1|')>0 OR INSTR(mi.OWNERS,'|PMH|')>0 OR INSTR(mi.OWNERS,'|PPL|')>0)and mi.MI_DELETED = 0 and mi.ITEM_TYPE > 0) and m.id in (select l.dfile_id as ID from TMDDBA.tm_mi_dfile_lnx l join TMDDBA.TM_MIS mi on (l.mi_id = mi.id) where mi.id = :param_0 AND (INSTR(mi.OWNERS,'|SFP2|')>0 OR INSTR(mi.OWNERS,'|PSP|')>0 OR INSTR(mi.OWNERS,'|PMS|')>0 OR INSTR(mi.OWNERS,'|SFP1|')>0 OR INSTR(mi.OWNERS,'|PMH|')>0 OR INSTR(mi.OWNERS,'|PPL|')>0)and mi.MI_DELETED = 0 and mi.ITEM_TYPE > 0) order by m.OS_FNAME, m.id ) a where rownum <= 50) r left join tm_device_lst l on (r.srver_id = l.id) where rnum >= 1 order by rnum t Verbose: 1220 : 12|09:59:30.2459|r31Suk|CJPOWERCAST|imfx v3 API took 0.032s '/api/v3/media/299528/carriers/digital?_dc=1686819575342' t Transfer: 1220 : 12|09:59:30.4469|b0Y1cr|CJPOWERCAST|OAuth: /api/v3/media/299528/carriers/digital?_dc=1686819575605 t Transfer: 1220 : 12|09:59:30.4469|b0Y1cr|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:30.4469|b0Y1cr|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:30.4469|b0Y1cr|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:59:30.4469|b0Y1cr|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|09:59:30.4469|b0Y1cr|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|09:59:30.4469|b0Y1cr|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:30.4469|b0Y1cr|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:30.4479|b0Y1cr|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|09:59:30.4479|b0Y1cr|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:30.4479|b0Y1cr|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:30.4479|b0Y1cr|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|09:59:30.4479|b0Y1cr|CJPOWERCAST|SearchDigitalCarriersAdv SQL: select r.*, l.dv_nam SRVER_ID_TEXT from ( select a.*, rownum rnum from ( select m.* from tmddba.tm_dfile m where m.id in (select l.dfile_id as ID from TMDDBA.tm_mi_dfile_lnx l join TMDDBA.TM_MIS mi on (l.mi_id = mi.id) where (INSTR(mi.OWNERS,'|SFP2|')>0 OR INSTR(mi.OWNERS,'|PSP|')>0 OR INSTR(mi.OWNERS,'|PMS|')>0 OR INSTR(mi.OWNERS,'|SFP1|')>0 OR INSTR(mi.OWNERS,'|PMH|')>0 OR INSTR(mi.OWNERS,'|PPL|')>0)and mi.MI_DELETED = 0 and mi.ITEM_TYPE > 0) and m.id in (select l.dfile_id as ID from TMDDBA.tm_mi_dfile_lnx l join TMDDBA.TM_MIS mi on (l.mi_id = mi.id) where mi.id = :param_0 AND (INSTR(mi.OWNERS,'|SFP2|')>0 OR INSTR(mi.OWNERS,'|PSP|')>0 OR INSTR(mi.OWNERS,'|PMS|')>0 OR INSTR(mi.OWNERS,'|SFP1|')>0 OR INSTR(mi.OWNERS,'|PMH|')>0 OR INSTR(mi.OWNERS,'|PPL|')>0)and mi.MI_DELETED = 0 and mi.ITEM_TYPE > 0) order by m.OS_FNAME, m.id ) a where rownum <= 50) r left join tm_device_lst l on (r.srver_id = l.id) where rnum >= 1 order by rnum t Verbose: 1220 : 12|09:59:30.4479|b0Y1cr|CJPOWERCAST|imfx v3 API took 0.012s '/api/v3/media/299528/carriers/digital?_dc=1686819575605' t Transfer: 1220 : 12|09:59:32.0559|TzSUy_|CJPOWERCAST|OAuth: /api/v3/version/299563/media?_dc=1686819577296 t Transfer: 1220 : 12|09:59:32.0559|TzSUy_|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:32.0559|TzSUy_|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:32.0559|TzSUy_|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:59:32.0559|TzSUy_|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|09:59:32.0559|TzSUy_|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|09:59:32.0569|TzSUy_|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:32.0569|TzSUy_|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:32.0569|TzSUy_|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|09:59:32.0569|TzSUy_|CJPOWERCAST|MediaSearch SQL: --sqlFromPaging select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type in (1,110)),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , (SELECT min(status.ACCESS_STATUS_NAME) FROM TMDDBA.TM_ACCESS_STATUS statusLnx, TM_CFG_ACCESS_STATUS status WHERE statusLnx.Media_Id = r.id and statusLnx.Status_Id = status.id) ACCESS_STATUS , (select min(acq.ext_ref) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) CONSIGNMENT_NUMBER , (select min(acq.alt_id1) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) TRANSFER_NUMBER , (select min(crs.series_number) from tm_series_data crs where crs.id = r.GROUP_SERIES_ID) CRS_SERIES , (select min(DISPOSAL_NAME) from TM_ACQ_DISPOSAL status, tm_disposal_records records where status.id = records.disposal_status_id and records.miid = r.id) DISPOSAL_STATUS , (select min(class.class_number) from TM_ACQ_DISPOSAL status, tm_disposal_records records, tm_disposal_classes class where status.id = records.disposal_status_id and records.miid = r.id and class.id = records.disposal_class_id) DISPOSAL_CLASS, (select min(names.concat_search_name) from tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names where r.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY, (select min(c.u_id_ext1) from tmddba.tm_mi_tpi_lnx lnx, tm_ctnrs c where c.u_id = lnx.tpiid and lnx.miid = r.id) U_ID_EXT1 , (select t.name from TM_CFG_MI_FMT_TYP t where t.id = r.mi_fmt_type) ITEM_FORMAT_TEXT, CASE WHEN BITAND(r.COMPIL, 2) = 2 THEN 'SUPPLIED' WHEN BITAND(r.COMPIL, 4) = 4 THEN 'MADE' WHEN BITAND(r.COMPIL, 134217728) = 134217728 THEN 'IMPORTED' ELSE '' END AS ORIGIN, CASE WHEN BITAND(r.COMPIL, 512) = 512 THEN 'Attached' WHEN BITAND(r.COMPIL, 1024) = 1024 THEN 'Un-Attached' ELSE '' END AS FLAGS, (select min(lang.full_name) from TM_PG_RL_LANG_LNX lnx, TM_LANG_DATA lang where lnx.tm_pg_rl_id = r.pgm_parent_id and lnx.lang_id = lang.id) AS PROD_LANGUAGE , (select min(ctx.ITFC_CODE) from tm_mis mis, tm_mi_tpi_lnx links, tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names where mis.id = r.id and links.miid = mis.id and mis.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY_NUMBER, (select min(status.description) from TM_CFG_PGM_STATUS status where r.status = status.id) PGM_STATUS_TEXT, (select min(ver.DUR) from TM_PG_RL ver where r.pgm_PARENT_ID = ver.id) AS VERSION_DUR , (select tmd_str_agg_pipe(cms.status_type_id ||',' ||cms.status_id) from tm_mi_cust_med_stat_lnx cms where cms.media_id=r.id) "CustomStatusesRaw", (select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = r.net_grp_id) CHANNEL_GROUP, (SELECT SUBSTR( trim( replace (replace ( LISTAGG(trim(tt.tags || ' ' || tt.notes), ' ') WITHIN GROUP (ORDER BY trim(tt.tags || ' ' || tt.notes)), chr (13), ''), chr (10), ' ')), 1, 150) z FROM tm_media_tagging tt WHERE link_guid = DFILE_LINK_GUID and rownum=1) TAGS_TEXT , GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select t.*, coalesce(t.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=t.pgm_parent_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.pgm_abs_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs2_id) ) primary_thumb_id2 from ( --sqlSubSelect select s.* from (select a.*, rownum rnum from (select --sqlFrom m.* from tmddba.tm_mis m --sqlWhere where media_type>0 and item_type>0 AND PGM_PARENT_ID=:param_0 and m.mi_deleted=0 AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0) order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) s where rnum >= 1) t ) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl order by r.rnum t Verbose: 1220 : 12|09:59:32.2579|TzSUy_|CJPOWERCAST|Alternative title fields query: select * from (select x.id,x.pgm_abs_id TitleId, x.pgm_parent_id VersionId from tm_mis x where id in (select /*+ cardinality(4) */ column_value id from table(:ids))) y,lateral (select dbms_lob.substr( o.text_data_plain, 1000, 1 ) Field_5799344 from tm_txt_obj o where (o.pgm_abs_id=y.TitleId or o.pgm_rl_id = y.VersionId) and o.type_id=:param_1 order by o.id desc fetch first 1 rows only)(+) t Information: 1220 : 12|09:59:32.2579|TzSUy_|CJPOWERCAST| timing: 00:00:00.0256832 t Verbose: 1220 : 12|09:59:32.2579|TzSUy_|CJPOWERCAST|imfx v3 API took 0.026s '/api/v3/version/299563/media?_dc=1686819577296' t Transfer: 1220 : 12|09:59:32.2579|TzSUy_|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0013.mp4 subfolder t Transfer: 1220 : 12|09:59:32.2579|TzSUy_|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0013.mp4 t Transfer: 1220 : 12|09:59:32.2579|TzSUy_|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0013.mp4 t Transfer: 1220 : 12|09:59:32.2579|TzSUy_|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:32.2589|TzSUy_|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:32.2589|TzSUy_|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|09:59:32.2589|TzSUy_|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001993.mp4 subfolder t Transfer: 1220 : 12|09:59:32.2589|TzSUy_|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001993.mp4 t Transfer: 1220 : 12|09:59:32.2589|TzSUy_|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001993.mp4 t Transfer: 1220 : 12|09:59:32.2589|TzSUy_|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:32.2589|TzSUy_|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:32.2589|TzSUy_|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|09:59:32.2589|TzSUy_|CJPOWERCAST|GetUrl. Storage |Temp Storage| filename C:\TEMP\GOPR0013.mp4 subfolder t Transfer: 1220 : 12|09:59:32.2589|TzSUy_|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:32.2589|TzSUy_|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:32.2599|TzSUy_|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|09:59:32.2599|TzSUy_|CJPOWERCAST|GetUrl. Storage |Temp Storage| filename C:\TEMP\N0001993.mp4 subfolder t Transfer: 1220 : 12|09:59:32.2599|TzSUy_|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:32.2599|TzSUy_|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:32.2599|TzSUy_|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|09:59:34.6719|vPwdgK|CJPOWERCAST|OAuth: /api/settings/user/uploadSettings?_dc=1686819579755 t Transfer: 1220 : 12|09:59:34.6719|vPwdgK|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:34.6719|vPwdgK|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:34.6719|vPwdgK|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:59:34.6729|vPwdgK|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|09:59:34.6729|vPwdgK|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:34.6729|vPwdgK|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:34.6729|vPwdgK|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:59:34.6729|vPwdgK|CJPOWERCAST|imfx v3 API took 0.004s '/api/settings/user/uploadSettings?_dc=1686819579755' t Transfer: 1220 : 12|09:59:34.8739|1LvrM7|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:34.8739|1LvrM7|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:34.8739|1LvrM7|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|09:59:34.8739|kMISRI|CJPOWERCAST|OAuth: /api/lookups/Channels?_dc=1686819579936 t Transfer: 1220 : 12|09:59:34.8739|kMISRI|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:34.8739|kMISRI|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:34.8739|kMISRI|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:59:34.8739|kMISRI|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|09:59:34.8749|kMISRI|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:34.8749|kMISRI|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:34.8749|kMISRI|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|09:59:34.8749|l2FEND|CJPOWERCAST|OAuth: /api/lookups/MediaFileTypes?_dc=1686819579945 t Transfer: 1220 : 12|09:59:34.8749|l2FEND|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:34.8749|l2FEND|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:34.8749|l2FEND|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:59:34.8749|l2FEND|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 12|09:59:34.8749|l2FEND|CJPOWERCAST|imfx v3 API took 0.000s '/api/lookups/MediaFileTypes?_dc=1686819579945' t Transfer: 1220 : 12|09:59:34.8759|bD94P6|CJPOWERCAST|OAuth: /api/lookups/UsageTypes?_dc=1686819579951 t Transfer: 1220 : 12|09:59:34.8759|bD94P6|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:34.8759|bD94P6|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:34.8759|bD94P6|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:59:34.8759|bD94P6|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 12|09:59:34.8759|bD94P6|CJPOWERCAST|imfx v3 API took 0.000s '/api/lookups/UsageTypes?_dc=1686819579951' t Transfer: 1220 : 12|09:59:34.8759|Q~81fH|CJPOWERCAST|OAuth: /api/lookups/ItemTypes?_dc=1686819579959 t Transfer: 1220 : 12|09:59:34.8759|Q~81fH|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:34.8759|Q~81fH|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:34.8759|Q~81fH|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:59:34.8759|Q~81fH|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 12|09:59:34.8769|Q~81fH|CJPOWERCAST|imfx v3 API took 0.000s '/api/lookups/ItemTypes?_dc=1686819579959' t Verbose: 1220 : 12|09:59:34.8769|kMISRI|CJPOWERCAST|imfx v3 API took 0.068s '/api/lookups/Channels?_dc=1686819579936' t Transfer: 1220 : 12|09:59:34.8769|5DNhR_|CJPOWERCAST|OAuth: /api/lookups/TvStandards?_dc=1686819579967 t Transfer: 1220 : 12|09:59:34.8769|5DNhR_|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:34.8769|5DNhR_|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:34.8769|5DNhR_|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:59:34.8769|5DNhR_|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 12|09:59:34.8769|5DNhR_|CJPOWERCAST|imfx v3 API took 0.000s '/api/lookups/TvStandards?_dc=1686819579967' t Transfer: 1220 : 12|09:59:35.0779|qkfQIH|CJPOWERCAST|OAuth: /api/lookups/AspectRatioTypes?_dc=1686819579978 t Transfer: 1220 : 12|09:59:35.0779|qkfQIH|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:35.0779|qkfQIH|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:35.0779|qkfQIH|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:59:35.0779|qkfQIH|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 12|09:59:35.0789|qkfQIH|CJPOWERCAST|imfx v3 API took 0.000s '/api/lookups/AspectRatioTypes?_dc=1686819579978' t Transfer: 1220 : 12|09:59:35.0789|_1Y9jw|CJPOWERCAST|OAuth: /api/lookups/AfdTypes?_dc=1686819579997 t Transfer: 1220 : 12|09:59:35.0789|_1Y9jw|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|09:59:35.0789|_1Y9jw|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|09:59:35.0789|_1Y9jw|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|09:59:35.0789|_1Y9jw|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 12|09:59:35.0789|_1Y9jw|CJPOWERCAST|imfx v3 API took 0.000s '/api/lookups/AfdTypes?_dc=1686819579997' t Transfer: 1220 : 12|10:00:36.5859|Kg2j1U|CJPOWERCAST|OAuth: /api/v3/checkFilesExist?_dc=1686819641653 t Transfer: 1220 : 12|10:00:36.5859|Kg2j1U|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:00:36.5859|Kg2j1U|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:00:36.5859|Kg2j1U|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:00:36.5859|Kg2j1U|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 12|10:00:36.5859|Kg2j1U|CJPOWERCAST|imfx v3 API took 0.073s '/api/v3/checkFilesExist?_dc=1686819641653' t Transfer: 1220 : 12|10:01:14.9758|BxxoRN|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:01:14.9758|BxxoRN|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:01:14.9758|BxxoRN|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|10:01:41.1058|zig0MD|CJPOWERCAST|OAuth: /api/user-preferences?keys=media.basket.data&_dc=1686819706334 t Transfer: 1220 : 12|10:01:41.1058|zig0MD|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:01:41.1058|zig0MD|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:01:41.1058|zig0MD|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:01:41.1058|zig0MD|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|10:01:41.1058|zig0MD|CJPOWERCAST|GetUserDataByKeys: media.basket.data t Transfer: 1220 : 12|10:01:41.1058|zig0MD|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:01:41.1068|zig0MD|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:01:41.1068|zig0MD|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:01:41.1068|zig0MD|CJPOWERCAST|imfx v3 API took 0.005s '/api/user-preferences?keys=media.basket.data&_dc=1686819706334' t Transfer: 1220 : 12|10:01:41.5088|w3cgPc|CJPOWERCAST|OAuth: /api/settings/user/defaultHomePage?_dc=1686819706339 t Transfer: 1220 : 12|10:01:41.5088|w3cgPc|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:01:41.5088|w3cgPc|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:01:41.5088|w3cgPc|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:01:41.5088|w3cgPc|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|10:01:41.5088|w3cgPc|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:01:41.5088|w3cgPc|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:01:41.5088|w3cgPc|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:01:41.5098|w3cgPc|CJPOWERCAST|imfx v3 API took 0.003s '/api/settings/user/defaultHomePage?_dc=1686819706339' t Transfer: 1220 : 12|10:01:41.7108|YCvsWN|CJPOWERCAST|OAuth: /api/user-preferences?keys=color_schema&_dc=1686819706344 t Transfer: 1220 : 12|10:01:41.7108|YCvsWN|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:01:41.7108|YCvsWN|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:01:41.7108|YCvsWN|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:01:41.7108|YCvsWN|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|10:01:41.7108|YCvsWN|CJPOWERCAST|GetUserDataByKeys: color_schema t Transfer: 1220 : 12|10:01:41.7108|YCvsWN|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:01:41.7108|YCvsWN|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:01:41.7118|YCvsWN|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:01:41.7118|YCvsWN|CJPOWERCAST|imfx v3 API took 0.004s '/api/user-preferences?keys=color_schema&_dc=1686819706344' t Transfer: 1220 : 12|10:01:41.7118|_GGDi~|CJPOWERCAST|OAuth: /api/settings/user/mainMenuSettings?_dc=1686819706384 t Transfer: 1220 : 12|10:01:41.7118|_GGDi~|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:01:41.7118|_GGDi~|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:01:41.7118|_GGDi~|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:01:41.7118|_GGDi~|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|10:01:41.7118|_GGDi~|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:01:41.7118|_GGDi~|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:01:41.7128|_GGDi~|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:01:41.7128|_GGDi~|CJPOWERCAST|imfx v3 API took 0.002s '/api/settings/user/mainMenuSettings?_dc=1686819706384' t Transfer: 1220 : 12|10:01:41.7128|FMCuXU|CJPOWERCAST|OAuth: /api/settings/group/0?_dc=1686819706382 t Transfer: 1220 : 12|10:01:41.7128|FMCuXU|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:01:41.7128|FMCuXU|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:01:41.7128|FMCuXU|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:01:41.7128|FMCuXU|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|10:01:41.7128|d2KJR_|CJPOWERCAST|OAuth: /api/settings/user/uploadSettings?_dc=1686819706399 t Transfer: 1220 : 12|10:01:41.7128|d2KJR_|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:01:41.7128|d2KJR_|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:01:41.7138|d2KJR_|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:01:41.7138|d2KJR_|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|10:01:41.7138|b_fKEg|CJPOWERCAST|OAuth: /api/user-preferences?keys=media.basket.data&_dc=1686819706412 t Transfer: 1220 : 12|10:01:41.7138|b_fKEg|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:01:41.7138|b_fKEg|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:01:41.7138|b_fKEg|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:01:41.7138|b_fKEg|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|10:01:41.9148|JeIQBq|CJPOWERCAST|OAuth: /api/settings/group/0?_dc=1686819706430 t Transfer: 1220 : 12|10:01:41.9148|JeIQBq|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:01:41.9148|JeIQBq|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:01:41.9148|JeIQBq|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:01:41.9148|JeIQBq|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 12|10:01:41.9158|FMCuXU|CJPOWERCAST|imfx v3 API took 0.108s '/api/settings/group/0?_dc=1686819706382' t Information: 1220 : 12|10:01:41.9158|b_fKEg|CJPOWERCAST|GetUserDataByKeys: media.basket.data t Transfer: 1220 : 12|10:01:41.9158|b_fKEg|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:01:41.9158|b_fKEg|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:01:41.9158|b_fKEg|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|10:01:41.9158|d2KJR_|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:01:41.9158|d2KJR_|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:01:41.9158|d2KJR_|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:01:41.9168|d2KJR_|CJPOWERCAST|imfx v3 API took 0.075s '/api/settings/user/uploadSettings?_dc=1686819706399' t Verbose: 1220 : 12|10:01:41.9168|b_fKEg|CJPOWERCAST|imfx v3 API took 0.079s '/api/user-preferences?keys=media.basket.data&_dc=1686819706412' t Transfer: 1220 : 12|10:01:42.1178|ZKS_EA|CJPOWERCAST|OAuth: /api/settings/user/mainMenuSettings?_dc=1686819706431 t Transfer: 1220 : 12|10:01:42.1178|ZKS_EA|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:01:42.1178|ZKS_EA|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:01:42.1178|ZKS_EA|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:01:42.1178|ZKS_EA|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|10:01:42.1178|ZKS_EA|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:01:42.1178|ZKS_EA|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:01:42.1178|ZKS_EA|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:01:42.1188|ZKS_EA|CJPOWERCAST|imfx v3 API took 0.003s '/api/settings/user/mainMenuSettings?_dc=1686819706431' t Verbose: 1220 : 12|10:01:42.1188|6m0gl0||imfx v3 API took 0.005s '/api/v3/visual-asset/group/Any_gO/0/image' t Verbose: 1220 : 12|10:01:42.1188|JeIQBq|CJPOWERCAST|imfx v3 API took 0.079s '/api/settings/group/0?_dc=1686819706430' t Information: 1220 : 12|10:01:42.3198|JElMGw|CJPOWERCAST|GetUserProfile. Id: 0 t Transfer: 1220 : 12|10:01:42.3198|JElMGw|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:01:42.3198|JElMGw|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:01:42.3198|JElMGw|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|10:01:42.7258|iF2au3|CJPOWERCAST|OAuth: /api/user-preferences?keys=personal_settings&_dc=1686819707842 t Transfer: 1220 : 12|10:01:42.7258|iF2au3|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:01:42.7258|iF2au3|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:01:42.7258|iF2au3|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:01:42.7258|iF2au3|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|10:01:42.7268|iF2au3|CJPOWERCAST|GetUserDataByKeys: personal_settings t Transfer: 1220 : 12|10:01:42.7268|iF2au3|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:01:42.7268|iF2au3|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:01:42.7268|iF2au3|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:01:42.7268|iF2au3|CJPOWERCAST|imfx v3 API took 0.005s '/api/user-preferences?keys=personal_settings&_dc=1686819707842' t Transfer: 1220 : 12|10:01:42.9279|ipBNMC|CJPOWERCAST|OAuth: /api/lookups/MediaStatus?_dc=1686819708149 t Transfer: 1220 : 12|10:01:42.9279|ipBNMC|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:01:42.9279|ipBNMC|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:01:42.9279|ipBNMC|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:01:42.9289|ipBNMC|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 12|10:01:42.9289|ipBNMC|CJPOWERCAST|imfx v3 API took 0.000s '/api/lookups/MediaStatus?_dc=1686819708149' t Transfer: 1220 : 12|10:01:42.9289|14o9Df|CJPOWERCAST|OAuth: /api/lookups/PgmStatus?_dc=1686819708150 t Transfer: 1220 : 12|10:01:42.9289|14o9Df|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:01:42.9289|14o9Df|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:01:42.9299|14o9Df|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:01:42.9299|14o9Df|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 12|10:01:42.9299|14o9Df|CJPOWERCAST|imfx v3 API took 0.000s '/api/lookups/PgmStatus?_dc=1686819708150' t Transfer: 1220 : 12|10:01:42.9299|_vofJC|CJPOWERCAST|OAuth: /api/lookup/CustomVersionStatusTypes?_dc=1686819708152 t Transfer: 1220 : 12|10:01:42.9299|_vofJC|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:01:42.9309|_vofJC|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:01:42.9309|_vofJC|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:01:42.9309|_vofJC|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|10:01:42.9309|8Abv7x|CJPOWERCAST|OAuth: /api/lookup/CustomTitleStatusTypes?_dc=1686819708153 t Transfer: 1220 : 12|10:01:42.9309|8Abv7x|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:01:42.9319|8Abv7x|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:01:42.9319|8Abv7x|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:01:42.9319|8Abv7x|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 12|10:01:42.9319|_vofJC|CJPOWERCAST|imfx v3 API took 0.004s '/api/lookup/CustomVersionStatusTypes?_dc=1686819708152' t Transfer: 1220 : 12|10:01:42.9319|4C3Wr~|CJPOWERCAST|OAuth: /api/lookup/CustomMediaStatusTypes?_dc=1686819708151 t Transfer: 1220 : 12|10:01:42.9329|4C3Wr~|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:01:42.9329|4C3Wr~|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:01:42.9329|4C3Wr~|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:01:42.9329|4C3Wr~|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 12|10:01:42.9339|8Abv7x|CJPOWERCAST|imfx v3 API took 0.003s '/api/lookup/CustomTitleStatusTypes?_dc=1686819708153' t Verbose: 1220 : 12|10:01:42.9339|4C3Wr~|CJPOWERCAST|imfx v3 API took 0.003s '/api/lookup/CustomMediaStatusTypes?_dc=1686819708151' t Verbose: 1220 : 12|10:01:43.1349|8Xsxzx||imfx v3 API took 0.003s '/api/v3/visual-asset/group/Any_gO/1/image' t Transfer: 1220 : 12|10:01:43.3358|pefL7~|CJPOWERCAST|OAuth: /api/settings/user/defaultSearch?_dc=1686819708446 t Transfer: 1220 : 12|10:01:43.3358|pefL7~|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:01:43.3358|pefL7~|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:01:43.3358|pefL7~|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:01:43.3368|pefL7~|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|10:01:43.3368|Z915mL|CJPOWERCAST|OAuth: /api/settings/user/startSearch?_dc=1686819708447 t Transfer: 1220 : 12|10:01:43.3368|Z915mL|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:01:43.3368|Z915mL|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:01:43.3368|Z915mL|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:01:43.3368|Z915mL|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|10:01:43.3368|pefL7~|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:01:43.3378|Z915mL|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:01:43.3378|Z915mL|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:01:43.3378|pefL7~|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:01:43.3378|Z915mL|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|10:01:43.3378|pefL7~|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:01:43.3378|Z915mL|CJPOWERCAST|imfx v3 API took 0.004s '/api/settings/user/startSearch?_dc=1686819708447' t Verbose: 1220 : 12|10:01:43.3378|pefL7~|CJPOWERCAST|imfx v3 API took 0.004s '/api/settings/user/defaultSearch?_dc=1686819708446' t Transfer: 1220 : 12|10:01:43.5399|83wqSk|CJPOWERCAST|OAuth: /api/user-preferences?keys=consumer.recent.data&_dc=1686819708739 t Transfer: 1220 : 12|10:01:43.5399|83wqSk|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:01:43.5399|83wqSk|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:01:43.5399|83wqSk|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:01:43.5409|83wqSk|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|10:01:43.5409|83wqSk|CJPOWERCAST|GetUserDataByKeys: consumer.recent.data t Transfer: 1220 : 12|10:01:43.5409|83wqSk|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:01:43.5409|83wqSk|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:01:43.5409|83wqSk|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:01:43.5409|83wqSk|CJPOWERCAST|imfx v3 API took 0.005s '/api/user-preferences?keys=consumer.recent.data&_dc=1686819708739' t Transfer: 1220 : 12|10:01:43.5419|TnhEI9|CJPOWERCAST|OAuth: /api/user-preferences?keys=adv.recent.searches.consumer&_dc=1686819708754 t Transfer: 1220 : 12|10:01:43.5419|TnhEI9|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:01:43.5419|TnhEI9|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:01:43.5419|TnhEI9|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:01:43.5419|TnhEI9|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|10:01:43.5419|TnhEI9|CJPOWERCAST|GetUserDataByKeys: adv.recent.searches.consumer t Transfer: 1220 : 12|10:01:43.5419|TnhEI9|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:01:43.5419|TnhEI9|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:01:43.5429|TnhEI9|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:01:43.5429|TnhEI9|CJPOWERCAST|imfx v3 API took 0.007s '/api/user-preferences?keys=adv.recent.searches.consumer&_dc=1686819708754' t Verbose: 1220 : 12|10:01:43.7438|8WDo0h||imfx v3 API took 0.003s '/api/v3/visual-asset/group/Any_gO/3/image' t Transfer: 1220 : 12|10:01:48.9698|ncxsqe|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:01:48.9698|ncxsqe|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:01:48.9698|ncxsqe|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|10:01:48.9698|Xo3cMy|CJPOWERCAST|OAuth: /api/lookups/Channels?_dc=1686819714208 t Transfer: 1220 : 12|10:01:48.9698|Xo3cMy|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:01:48.9698|Xo3cMy|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:01:48.9698|Xo3cMy|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:01:48.9698|Xo3cMy|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|10:01:48.9708|Xo3cMy|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:01:48.9708|Xo3cMy|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:01:48.9708|Xo3cMy|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|10:01:48.9708|w~QjOo|CJPOWERCAST|OAuth: /api/lookups/MediaFileTypes?_dc=1686819714216 t Transfer: 1220 : 12|10:01:48.9708|w~QjOo|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:01:48.9708|w~QjOo|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:01:48.9708|w~QjOo|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:01:48.9708|w~QjOo|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 12|10:01:48.9708|Xo3cMy|CJPOWERCAST|imfx v3 API took 0.006s '/api/lookups/Channels?_dc=1686819714208' t Verbose: 1220 : 12|10:01:48.9708|w~QjOo|CJPOWERCAST|imfx v3 API took 0.000s '/api/lookups/MediaFileTypes?_dc=1686819714216' t Transfer: 1220 : 12|10:01:49.1718|4I48VC|CJPOWERCAST|OAuth: /api/lookups/UsageTypes?_dc=1686819714222 t Transfer: 1220 : 12|10:01:49.1718|4I48VC|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:01:49.1718|4I48VC|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:01:49.1718|4I48VC|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:01:49.1718|4I48VC|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 12|10:01:49.1718|4I48VC|CJPOWERCAST|imfx v3 API took 0.000s '/api/lookups/UsageTypes?_dc=1686819714222' t Transfer: 1220 : 12|10:01:49.1718|FbNXDc|CJPOWERCAST|OAuth: /api/lookups/ItemTypes?_dc=1686819714227 t Transfer: 1220 : 12|10:01:49.1718|FbNXDc|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:01:49.1728|FbNXDc|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:01:49.1728|FbNXDc|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:01:49.1728|FbNXDc|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|10:01:49.1728|ml9LIA|CJPOWERCAST|OAuth: /api/lookups/TvStandards?_dc=1686819714233 t Transfer: 1220 : 12|10:01:49.1728|ml9LIA|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:01:49.1728|ml9LIA|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:01:49.1728|ml9LIA|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:01:49.1728|ml9LIA|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 12|10:01:49.1728|FbNXDc|CJPOWERCAST|imfx v3 API took 0.000s '/api/lookups/ItemTypes?_dc=1686819714227' t Verbose: 1220 : 12|10:01:49.1728|ml9LIA|CJPOWERCAST|imfx v3 API took 0.000s '/api/lookups/TvStandards?_dc=1686819714233' t Transfer: 1220 : 12|10:01:49.3738|PHDHJe|CJPOWERCAST|OAuth: /api/lookups/AfdTypes?_dc=1686819714245 t Transfer: 1220 : 12|10:01:49.3738|PHDHJe|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:01:49.3738|PHDHJe|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:01:49.3738|PHDHJe|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:01:49.3738|PHDHJe|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|10:01:49.3738|grRkJJ|CJPOWERCAST|OAuth: /api/lookups/AspectRatioTypes?_dc=1686819714239 t Transfer: 1220 : 12|10:01:49.3738|grRkJJ|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:01:49.3738|grRkJJ|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:01:49.3748|grRkJJ|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:01:49.3748|grRkJJ|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|10:01:49.3748|jQ7Qki|CJPOWERCAST|OAuth: /api/view/info/VersionGrid?lang=en-GB&_dc=1686819714251 t Transfer: 1220 : 12|10:01:49.3748|jQ7Qki|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:01:49.3748|jQ7Qki|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:01:49.3748|jQ7Qki|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:01:49.3748|jQ7Qki|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 12|10:01:49.3748|PHDHJe|CJPOWERCAST|imfx v3 API took 0.000s '/api/lookups/AfdTypes?_dc=1686819714245' t Information: 1220 : 12|10:01:49.3748|jQ7Qki|CJPOWERCAST|GetGridViewBuilder. builder type VersionGrid. t Transfer: 1220 : 12|10:01:49.3748|jQ7Qki|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:01:49.3748|jQ7Qki|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:01:49.3758|jQ7Qki|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:01:49.3758|grRkJJ|CJPOWERCAST|imfx v3 API took 0.000s '/api/lookups/AspectRatioTypes?_dc=1686819714239' t Information: 1220 : 12|10:01:49.3758|jQ7Qki|CJPOWERCAST|UserGridView. LoadView. ID -2, Name Default. t Transfer: 1220 : 12|10:01:49.3758|jQ7Qki|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:01:49.3758|jQ7Qki|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:01:49.3758|jQ7Qki|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|10:01:49.3758|jQ7Qki|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:01:49.3758|jQ7Qki|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:01:49.3758|jQ7Qki|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:01:49.3758|jQ7Qki|CJPOWERCAST|imfx v3 API took 0.008s '/api/view/info/VersionGrid?lang=en-GB&_dc=1686819714251' t Transfer: 1220 : 12|10:01:52.7928|cf7ldF|CJPOWERCAST|OAuth: /api/view/info/TitleTree?lang=en-GB&_dc=1686819717866 t Transfer: 1220 : 12|10:01:52.7928|cf7ldF|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:01:52.7928|cf7ldF|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:01:52.7928|cf7ldF|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:01:52.7928|cf7ldF|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|10:01:52.7928|cf7ldF|CJPOWERCAST|GetGridViewBuilder. builder type TitleTree. t Transfer: 1220 : 12|10:01:52.7928|cf7ldF|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:01:52.7939|cf7ldF|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:01:52.7939|cf7ldF|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|10:01:52.7939|cf7ldF|CJPOWERCAST|UserGridView. LoadView. ID -2, Name Default. t Transfer: 1220 : 12|10:01:52.7939|cf7ldF|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:01:52.7939|cf7ldF|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:01:52.7939|cf7ldF|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|10:01:52.7939|cf7ldF|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:01:52.7939|cf7ldF|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:01:52.7939|cf7ldF|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:01:52.7939|cf7ldF|CJPOWERCAST|imfx v3 API took 0.007s '/api/view/info/TitleTree?lang=en-GB&_dc=1686819717866' t Transfer: 1220 : 12|10:01:56.2109|anzQSe|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1686819721314 t Transfer: 1220 : 12|10:01:56.2109|anzQSe|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:01:56.2109|anzQSe|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:01:56.2109|anzQSe|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:01:56.2109|anzQSe|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|10:01:56.2118|anzQSe|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:01:56.2118|anzQSe|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:01:56.2118|anzQSe|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:01:56.2118|anzQSe|CJPOWERCAST|imfx v3 API took 0.013s '/api/v3/search-suggestion/?_dc=1686819721314' t Transfer: 1220 : 12|10:01:56.4128|lWI4nn|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1686819721483 t Transfer: 1220 : 12|10:01:56.4128|lWI4nn|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:01:56.4128|lWI4nn|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:01:56.4128|lWI4nn|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:01:56.4128|lWI4nn|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|10:01:56.4128|lWI4nn|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:01:56.4128|lWI4nn|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:01:56.4128|lWI4nn|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:01:56.4138|lWI4nn|CJPOWERCAST|imfx v3 API took 0.012s '/api/v3/search-suggestion/?_dc=1686819721483' t Transfer: 1220 : 12|10:01:56.8158|VN0Rid|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1686819721880 t Transfer: 1220 : 12|10:01:56.8158|VN0Rid|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:01:56.8158|VN0Rid|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:01:56.8158|VN0Rid|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:01:56.8158|VN0Rid|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|10:01:56.8158|VN0Rid|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:01:56.8158|VN0Rid|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:01:56.8158|VN0Rid|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:01:56.8168|VN0Rid|CJPOWERCAST|imfx v3 API took 0.007s '/api/v3/search-suggestion/?_dc=1686819721880' t Transfer: 1220 : 12|10:01:59.2288|3dez~J|CJPOWERCAST|OAuth: /api/user-group-preferences?keys=defaultSearchColumnsTitle&_dc=1686819724304 t Transfer: 1220 : 12|10:01:59.2288|3G0pvi|CJPOWERCAST|OAuth: /api/user-group-preferences?keys=defaultSearchColumnsTitle&_dc=1686819724306 t Transfer: 1220 : 12|10:01:59.2288|3G0pvi|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:01:59.2288|3dez~J|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:01:59.2288|3G0pvi|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:01:59.2288|3dez~J|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:01:59.2288|3G0pvi|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|10:01:59.2298|3dez~J|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:01:59.2298|3G0pvi|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 12|10:01:59.2298|3dez~J|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|10:01:59.2298|bU50py|CJPOWERCAST|OAuth: /api/v3/search/title?_dc=1686819724307 t Transfer: 1220 : 12|10:01:59.2298|bU50py|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:01:59.2298|bU50py|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:01:59.2298|bU50py|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:01:59.2298|bU50py|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|10:01:59.2298|3G0pvi|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:01:59.2298|3G0pvi|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:01:59.2308|3G0pvi|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|10:01:59.2308|3dez~J|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:01:59.2308|3dez~J|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:01:59.2308|3dez~J|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|10:01:59.2308|bU50py|CJPOWERCAST|V3Api.SearchTitles t Information: 1220 : 12|10:01:59.2308|bU50py|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|10:01:59.2308|bU50py|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:01:59.2308|bU50py|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:01:59.2308|bU50py|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|10:01:59.2318|bU50py|CJPOWERCAST|SearchTitle SQL: with v as ( SELECT abs.* ,(select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = abs.net_grp_id) CHANNEL_GROUP ,decode(ITEM_TYPE, 1010,SER_ABS_ID, 1020,CASE WHEN SER_ABS2_ID > 0 THEN SER_ABS2_ID ELSE SER_ABS_ID END ) xparent_id FROM TMDDBA.TM_PG_ABS abs WHERE abs.id in ( select a.id FROM TMDDBA.TM_PG_ABS a where ABS_DELETED = 0 AND (INSTR(OWNERS,'|SFP2|')>0 OR INSTR(OWNERS,'|PSP|')>0 OR INSTR(OWNERS,'|PMS|')>0 OR INSTR(OWNERS,'|SFP1|')>0 OR INSTR(OWNERS,'|PMH|')>0 OR INSTR(OWNERS,'|PPL|')>0 ) AND a.ser_abs_id=:param_0 AND ROWNUM < 25000 ) ) ,v_missing_parent_ids as ( select xparent_id from v minus select id from v ) ,v_missing_parents as ( SELECT distinct a.* ,(select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = a.net_grp_id) CHANNEL_GROUP ,decode(ITEM_TYPE, 1010,SER_ABS_ID, 1020,CASE WHEN SER_ABS2_ID > 0 THEN SER_ABS2_ID ELSE SER_ABS_ID END ) xparent_id FROM TMDDBA.TM_PG_ABS a START WITH ID IN (select xparent_id from v_missing_parent_ids) CONNECT BY CASE PRIOR ITEM_TYPE WHEN 1010 THEN PRIOR SER_ABS_ID WHEN 1020 THEN CASE WHEN NVL(PRIOR SER_ABS2_ID, 0) > 0 THEN PRIOR SER_ABS2_ID ELSE PRIOR SER_ABS_ID END END = ID ) ,v_all as ( select x.*, count(*) over() RowCount from ( select * from v_missing_parents union select * from v ) x ) ,v_top as ( select id from (select id, row_number()over(order by upper(ser_title),upper(title),ser_num,ser_ep_num, SER_EP_SQ_NUM ) rnk -- sort roots from v_all where xparent_id is null) where rnk between (:page_number-1)*50+1 and :page_number*50 ) ,v_tree as ( select level "TreeLevel", a.*from v_all a start with id in (select id from v_top) connect by xparent_id = prior ID order siblings by upper(ser_title),ser_num,ser_ep_num, SER_EP_SQ_NUM,upper(title) -- sort children ) select * from v_tree --where rnk <= 50 t Verbose: 1220 : 12|10:01:59.2318|bU50py|CJPOWERCAST|imfx v3 API took 0.030s '/api/v3/search/title?_dc=1686819724307' t Verbose: 1220 : 12|10:01:59.2318|3dez~J|CJPOWERCAST|imfx v3 API took 0.064s '/api/user-group-preferences?keys=defaultSearchColumnsTitle&_dc=1686819724304' t Verbose: 1220 : 12|10:01:59.2318|3G0pvi|CJPOWERCAST|imfx v3 API took 0.065s '/api/user-group-preferences?keys=defaultSearchColumnsTitle&_dc=1686819724306' t Transfer: 1220 : 12|10:01:59.4328|jCDU~7|CJPOWERCAST|OAuth: /api/user-group-preferences?keys=defaultSearchColumnsTitle&_dc=1686819724306 t Transfer: 1220 : 12|10:01:59.4328|jCDU~7|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:01:59.4328|jCDU~7|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:01:59.4328|jCDU~7|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:01:59.4328|jCDU~7|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|10:01:59.4328|jCDU~7|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:01:59.4328|jCDU~7|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:01:59.4328|jCDU~7|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:01:59.4338|jCDU~7|CJPOWERCAST|imfx v3 API took 0.003s '/api/user-group-preferences?keys=defaultSearchColumnsTitle&_dc=1686819724306' t Transfer: 1220 : 12|10:01:59.8358|xDEoxU|CJPOWERCAST|OAuth: /api/v3/title/299390/versions?_dc=1686819724893 t Transfer: 1220 : 12|10:01:59.8358|xDEoxU|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:01:59.8358|xDEoxU|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:01:59.8358|xDEoxU|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:01:59.8358|xDEoxU|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|10:01:59.8358|xDEoxU|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|10:01:59.8358|xDEoxU|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:01:59.8358|xDEoxU|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:01:59.8368|xDEoxU|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|10:01:59.8368|xDEoxU|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:01:59.8368|xDEoxU|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:01:59.8368|xDEoxU|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|10:01:59.8368|xDEoxU|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:01:59.8368|xDEoxU|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:01:59.8368|xDEoxU|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|10:01:59.8368|xDEoxU|CJPOWERCAST|SearchVersion SQL: select v.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE , (select min(name) from TM_CFG_AUDIO_CONTENT_MS_TYPES audio where v.audio_type = audio.id ) SOUND ,(select min(from_date_time) from TM_PG_RL_PROD_DATE prodDate where prodDate.Tm_Pg_Rl_Id = v.id ) PROD_FROM_DATE ,(select min(to_date_time) from TM_PG_RL_PROD_DATE prodDate where prodDate.Tm_Pg_Rl_Id = v.id ) PROD_TO_DATE ,(select min(full_name) from tm_lang_data lang, TM_PG_RL_LANG_LNX link where lang.id = link.lang_id and link.tm_pg_rl_id = v.id) PROD_LANGUAGE ,(SELECT min(COLOUR_NAME) FROM tm_cfg_colour_list list, tm_pg_rl ver where ver.col_mono = list.id and ver.id = v.id) PROD_COLOUR_TEXT ,(SELECT min(cfg.prod_date_type_name) FROM TM_PG_RL_PROD_DATE pg_rl, tm_cfg_prod_date_type cfg where cfg.id = pg_rl.PROD_DATE_TYPE_ID and TM_PG_RL_ID = v.id ) PROD_DATE_TYPE ,(select min(status.description) from TM_CFG_PGM_STATUS status where v.ITEM_STATUS_ID = status.id) PGM_STATUS_TEXT ,(select submed.sub_medium_name from TM_CFG_SUB_MEDIUM submed where v.SUB_MEDIUM_ID = submed.id) SUB_MEDIUM_TEXT, (select cvt.ID from TM_PORTAL_VERSION_CONFIG cvt where v.CUSTOM_VERSION_TYPE = cvt.CUSTOM_VERSION_TYPE AND cvt.CUSTOM_VERSION_TYPE IS NOT NULL ) MP_CONFIG_ID from (select v.*, coalesce(v.primary_thumb_id, (select x.primary_thumb_id from tm_pg_rl x where x.id=v.parent_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.pgm_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs2_id) ) primary_thumb_id2 from tmddba.tm_pg_rl v where v.item_type > 0 and v.rl_deleted = 0) v left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = v.primary_thumb_id2 --sqlIdSearchJoin where 1=1 AND (INSTR(v.OWNERS,'|SFP2|')>0 OR INSTR(v.OWNERS,'|PSP|')>0 OR INSTR(v.OWNERS,'|PMS|')>0 OR INSTR(v.OWNERS,'|SFP1|')>0 OR INSTR(v.OWNERS,'|PMH|')>0 OR INSTR(v.OWNERS,'|PPL|')>0) and v.id in (select x.id from tmddba.tm_pg_rl x start with x.id in ( select a.id from (select m.id, rownum rnum from tmddba.tm_pg_rl m where item_type>0 and rl_deleted=0 and m.PGM_ABS_ID=:param_0 AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0) ) A WHERE rnum>=1 and rnum <= 9999 ) connect by nocycle prior x.parent_id=x.id) t Transfer: 1220 : 12|10:01:59.8378|xDEoxU|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:01:59.8378|xDEoxU|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:01:59.8378|xDEoxU|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|10:01:59.8378|xDEoxU|CJPOWERCAST|Running version search. User: 1165 Simple Search: Running Oracle search. Running Oracle search for COUNT Oracle count completed in: 5ms. Returned lines: 0 t Verbose: 1220 : 12|10:01:59.8378|xDEoxU|CJPOWERCAST|imfx v3 API took 0.016s '/api/v3/title/299390/versions?_dc=1686819724893' t Transfer: 1220 : 12|10:02:04.4608|aPs4Dg|CJPOWERCAST|OAuth: /api/v3/title/299544/versions?_dc=1686819729596 t Transfer: 1220 : 12|10:02:04.4608|aPs4Dg|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:02:04.4608|aPs4Dg|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:02:04.4608|aPs4Dg|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:02:04.4608|aPs4Dg|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|10:02:04.4608|aPs4Dg|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|10:02:04.4608|aPs4Dg|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:02:04.4608|aPs4Dg|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:02:04.4618|aPs4Dg|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|10:02:04.4618|aPs4Dg|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:02:04.4618|aPs4Dg|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:02:04.4618|aPs4Dg|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|10:02:04.4618|aPs4Dg|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:02:04.4618|aPs4Dg|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:02:04.4618|aPs4Dg|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|10:02:04.4618|aPs4Dg|CJPOWERCAST|SearchVersion SQL: select v.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE , (select min(name) from TM_CFG_AUDIO_CONTENT_MS_TYPES audio where v.audio_type = audio.id ) SOUND ,(select min(from_date_time) from TM_PG_RL_PROD_DATE prodDate where prodDate.Tm_Pg_Rl_Id = v.id ) PROD_FROM_DATE ,(select min(to_date_time) from TM_PG_RL_PROD_DATE prodDate where prodDate.Tm_Pg_Rl_Id = v.id ) PROD_TO_DATE ,(select min(full_name) from tm_lang_data lang, TM_PG_RL_LANG_LNX link where lang.id = link.lang_id and link.tm_pg_rl_id = v.id) PROD_LANGUAGE ,(SELECT min(COLOUR_NAME) FROM tm_cfg_colour_list list, tm_pg_rl ver where ver.col_mono = list.id and ver.id = v.id) PROD_COLOUR_TEXT ,(SELECT min(cfg.prod_date_type_name) FROM TM_PG_RL_PROD_DATE pg_rl, tm_cfg_prod_date_type cfg where cfg.id = pg_rl.PROD_DATE_TYPE_ID and TM_PG_RL_ID = v.id ) PROD_DATE_TYPE ,(select min(status.description) from TM_CFG_PGM_STATUS status where v.ITEM_STATUS_ID = status.id) PGM_STATUS_TEXT ,(select submed.sub_medium_name from TM_CFG_SUB_MEDIUM submed where v.SUB_MEDIUM_ID = submed.id) SUB_MEDIUM_TEXT, (select cvt.ID from TM_PORTAL_VERSION_CONFIG cvt where v.CUSTOM_VERSION_TYPE = cvt.CUSTOM_VERSION_TYPE AND cvt.CUSTOM_VERSION_TYPE IS NOT NULL ) MP_CONFIG_ID from (select v.*, coalesce(v.primary_thumb_id, (select x.primary_thumb_id from tm_pg_rl x where x.id=v.parent_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.pgm_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs2_id) ) primary_thumb_id2 from tmddba.tm_pg_rl v where v.item_type > 0 and v.rl_deleted = 0) v left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = v.primary_thumb_id2 --sqlIdSearchJoin where 1=1 AND (INSTR(v.OWNERS,'|SFP2|')>0 OR INSTR(v.OWNERS,'|PSP|')>0 OR INSTR(v.OWNERS,'|PMS|')>0 OR INSTR(v.OWNERS,'|SFP1|')>0 OR INSTR(v.OWNERS,'|PMH|')>0 OR INSTR(v.OWNERS,'|PPL|')>0) and v.id in (select x.id from tmddba.tm_pg_rl x start with x.id in ( select a.id from (select m.id, rownum rnum from tmddba.tm_pg_rl m where item_type>0 and rl_deleted=0 and m.PGM_ABS_ID=:param_0 AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0) ) A WHERE rnum>=1 and rnum <= 9999 ) connect by nocycle prior x.parent_id=x.id) t Transfer: 1220 : 12|10:02:04.4618|aPs4Dg|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:02:04.4618|aPs4Dg|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:02:04.4628|aPs4Dg|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|10:02:05.0658|aPs4Dg|CJPOWERCAST|Running version search. User: 1165 Simple Search: Running Oracle search. Running Oracle search for COUNT Oracle count completed in: 5ms. Returned lines: 1 Oracle version search timing: 550ms. SQL run: select v.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE , (select min(name) from TM_CFG_AUDIO_CONTENT_MS_TYPES audio where v.audio_type = audio.id ) SOUND ,(select min(from_date_time) from TM_PG_RL_PROD_DATE prodDate where prodDate.Tm_Pg_Rl_Id = v.id ) PROD_FROM_DATE ,(select min(to_date_time) from TM_PG_RL_PROD_DATE prodDate where prodDate.Tm_Pg_Rl_Id = v.id ) PROD_TO_DATE ,(select min(full_name) from tm_lang_data lang, TM_PG_RL_LANG_LNX link where lang.id = link.lang_id and link.tm_pg_rl_id = v.id) PROD_LANGUAGE ,(SELECT min(COLOUR_NAME) FROM tm_cfg_colour_list list, tm_pg_rl ver where ver.col_mono = list.id and ver.id = v.id) PROD_COLOUR_TEXT ,(SELECT min(cfg.prod_date_type_name) FROM TM_PG_RL_PROD_DATE pg_rl, tm_cfg_prod_date_type cfg where cfg.id = pg_rl.PROD_DATE_TYPE_ID and TM_PG_RL_ID = v.id ) PROD_DATE_TYPE ,(select min(status.description) from TM_CFG_PGM_STATUS status where v.ITEM_STATUS_ID = status.id) PGM_STATUS_TEXT ,(select submed.sub_medium_name from TM_CFG_SUB_MEDIUM submed where v.SUB_MEDIUM_ID = submed.id) SUB_MEDIUM_TEXT, (select cvt.ID from TM_PORTAL_VERSION_CONFIG cvt where v.CUSTOM_VERSION_TYPE = cvt.CUSTOM_VERSION_TYPE AND cvt.CUSTOM_VERSION_TYPE IS NOT NULL ) MP_CONFIG_ID from (select v.*, coalesce(v.primary_thumb_id, (select x.primary_thumb_id from tm_pg_rl x where x.id=v.parent_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.pgm_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs2_id) ) primary_thumb_id2 from tmddba.tm_pg_rl v where v.item_type > 0 and v.rl_deleted = 0) v left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = v.primary_thumb_id2 --sqlIdSearchJoin where 1=1 AND (INSTR(v.OWNERS,'|SFP2|')>0 OR INSTR(v.OWNERS,'|PSP|')>0 OR INSTR(v.OWNERS,'|PMS|')>0 OR INSTR(v.OWNERS,'|SFP1|')>0 OR INSTR(v.OWNERS,'|PMH|')>0 OR INSTR(v.OWNERS,'|PPL|')>0) and v.id in (select x.id from tmddba.tm_pg_rl x start with x.id in ( select a.id from (select m.id, rownum rnum from tmddba.tm_pg_rl m where item_type>0 and rl_deleted=0 and m.PGM_ABS_ID=:param_0 AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0) ) A WHERE rnum>=1 and rnum <= 9999 ) connect by nocycle prior x.parent_id=x.id) t Verbose: 1220 : 12|10:02:05.0658|aPs4Dg|CJPOWERCAST|imfx v3 API took 0.563s '/api/v3/title/299544/versions?_dc=1686819729596' t Transfer: 1220 : 12|10:02:08.8848|ewa_TK|CJPOWERCAST|OAuth: /api/settings/user/uploadSettings?_dc=1686819734112 t Transfer: 1220 : 12|10:02:08.8848|ewa_TK|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:02:08.8848|ewa_TK|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:02:08.8848|ewa_TK|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:02:08.8848|ewa_TK|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|10:02:08.8848|ewa_TK|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:02:08.8848|ewa_TK|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:02:08.8858|ewa_TK|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:02:08.8858|ewa_TK|CJPOWERCAST|imfx v3 API took 0.004s '/api/settings/user/uploadSettings?_dc=1686819734112' t Transfer: 1220 : 12|10:02:39.0348|iUY3hW|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:02:39.0348|iUY3hW|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:02:39.0348|iUY3hW|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|10:02:44.0598|Q_eX1n|CJPOWERCAST|OAuth: /api/v3/checkFilesExist?_dc=1686819769248 t Transfer: 1220 : 12|10:02:44.0598|Q_eX1n|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:02:44.0598|Q_eX1n|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:02:44.0598|Q_eX1n|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:02:44.0598|Q_eX1n|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 12|10:02:44.0598|Q_eX1n|CJPOWERCAST|imfx v3 API took 0.006s '/api/v3/checkFilesExist?_dc=1686819769248' t Transfer: 1220 : 12|10:02:53.5058|4GJYFX|CJPOWERCAST|OAuth: /api/v3/checkFilesExist?_dc=1686819778661 t Transfer: 1220 : 12|10:02:53.5058|4GJYFX|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:02:53.5058|4GJYFX|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:02:53.5058|4GJYFX|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:02:53.5058|4GJYFX|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 12|10:02:53.7068|4GJYFX|CJPOWERCAST|imfx v3 API took 0.057s '/api/v3/checkFilesExist?_dc=1686819778661' t Transfer: 1220 : 12|10:03:14.4098|qYHPYD|CJPOWERCAST|OAuth: /api/view/searchinfo/TitleSearch?_dc=1686819799457 t Transfer: 1220 : 12|10:03:14.4098|qYHPYD|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:03:14.4098|qYHPYD|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:03:14.4098|qYHPYD|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:03:14.4098|qYHPYD|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|10:03:14.4098|A3q1q4|CJPOWERCAST|OAuth: /api/lookups/SearchSupportedOperators?_dc=1686819799458 t Transfer: 1220 : 12|10:03:14.4098|A3q1q4|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:03:14.4098|A3q1q4|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:03:14.4108|A3q1q4|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:03:14.4108|A3q1q4|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|10:03:14.4108|YNkv5U|CJPOWERCAST|OAuth: /api/user-preferences?keys=adv.recent.searches.titles&_dc=1686819799459 t Transfer: 1220 : 12|10:03:14.4108|YNkv5U|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:03:14.4108|YNkv5U|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:03:14.4108|YNkv5U|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:03:14.4108|YNkv5U|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 12|10:03:14.4108|A3q1q4|CJPOWERCAST|imfx v3 API took 0.000s '/api/lookups/SearchSupportedOperators?_dc=1686819799458' t Information: 1220 : 12|10:03:14.4108|qYHPYD|CJPOWERCAST|GetAdvSearchColumns. search type TitleSearch grid . t Verbose: 1220 : 12|10:03:14.4108|qYHPYD|CJPOWERCAST|imfx v3 API took 0.000s '/api/view/searchinfo/TitleSearch?_dc=1686819799457' t Transfer: 1220 : 12|10:03:14.4118|wXhNed|CJPOWERCAST|OAuth: /api/view/searches/TitleSearch?_dc=1686819799494 t Transfer: 1220 : 12|10:03:14.4118|wXhNed|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:03:14.4118|wXhNed|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:03:14.4118|wXhNed|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:03:14.4118|wXhNed|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|10:03:14.4118|wXhNed|CJPOWERCAST|GetSavedSearchNames. search type TitleSearch. t Transfer: 1220 : 12|10:03:14.4118|wXhNed|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:03:14.4118|wXhNed|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:03:14.4118|wXhNed|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|10:03:14.4118|YNkv5U|CJPOWERCAST|GetUserDataByKeys: adv.recent.searches.titles t Transfer: 1220 : 12|10:03:14.4128|YNkv5U|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:03:14.4128|YNkv5U|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:03:14.4128|YNkv5U|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:03:14.4128|wXhNed|CJPOWERCAST|imfx v3 API took 0.006s '/api/view/searches/TitleSearch?_dc=1686819799494' t Verbose: 1220 : 12|10:03:14.4128|YNkv5U|CJPOWERCAST|imfx v3 API took 0.006s '/api/user-preferences?keys=adv.recent.searches.titles&_dc=1686819799459' t Transfer: 1220 : 12|10:03:14.4128|2ya0b6|CJPOWERCAST|OAuth: /api/view/info/MediaGrid?lang=en-GB&_dc=1686819799590 t Transfer: 1220 : 12|10:03:14.4128|2ya0b6|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:03:14.4128|2ya0b6|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:03:14.4128|2ya0b6|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:03:14.4128|2ya0b6|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|10:03:14.4128|2ya0b6|CJPOWERCAST|GetGridViewBuilder. builder type MediaGrid. t Transfer: 1220 : 12|10:03:14.4138|2ya0b6|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:03:14.4138|2ya0b6|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:03:14.4138|2ya0b6|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|10:03:14.4138|2ya0b6|CJPOWERCAST|UserGridView. LoadView. ID -2, Name Default. t Transfer: 1220 : 12|10:03:14.4138|2ya0b6|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:03:14.4138|2ya0b6|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:03:14.4138|2ya0b6|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|10:03:14.4138|2ya0b6|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:03:14.4138|2ya0b6|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:03:14.4148|2ya0b6|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:03:14.4148|2ya0b6|CJPOWERCAST|imfx v3 API took 0.007s '/api/view/info/MediaGrid?lang=en-GB&_dc=1686819799590' t Transfer: 1220 : 12|10:03:14.6158|u6h4jw|CJPOWERCAST|OAuth: /api/view/info/DigitalCarriers?lang=en-GB&_dc=1686819799664 t Transfer: 1220 : 12|10:03:14.6158|u6h4jw|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:03:14.6158|u6h4jw|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:03:14.6158|u6h4jw|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:03:14.6158|u6h4jw|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|10:03:14.6158|u6h4jw|CJPOWERCAST|GetGridViewBuilder. builder type DigitalCarriers. t Transfer: 1220 : 12|10:03:14.6158|u6h4jw|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:03:14.6158|u6h4jw|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:03:14.6168|u6h4jw|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|10:03:14.6168|u6h4jw|CJPOWERCAST|UserGridView. LoadView. ID -2, Name Default. t Transfer: 1220 : 12|10:03:14.6168|u6h4jw|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:03:14.6168|u6h4jw|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:03:14.6168|u6h4jw|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|10:03:14.6168|u6h4jw|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:03:14.6168|u6h4jw|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:03:14.6168|u6h4jw|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:03:14.6168|u6h4jw|CJPOWERCAST|imfx v3 API took 0.007s '/api/view/info/DigitalCarriers?lang=en-GB&_dc=1686819799664' t Transfer: 1220 : 12|10:03:26.2738|2JxLue|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1686819811337 t Transfer: 1220 : 12|10:03:26.2738|2JxLue|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:03:26.2738|2JxLue|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:03:26.2738|2JxLue|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:03:26.2738|2JxLue|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|10:03:26.2738|2JxLue|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:03:26.2748|2JxLue|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:03:26.2748|2JxLue|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:03:26.2748|2JxLue|CJPOWERCAST|imfx v3 API took 0.012s '/api/v3/search-suggestion/?_dc=1686819811337' t Transfer: 1220 : 12|10:03:26.2748|gPk_ze|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1686819811441 t Transfer: 1220 : 12|10:03:26.2748|gPk_ze|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:03:26.2748|gPk_ze|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:03:26.2748|gPk_ze|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:03:26.2748|gPk_ze|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|10:03:26.2748|gPk_ze|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:03:26.2748|gPk_ze|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:03:26.2758|gPk_ze|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:03:26.2758|gPk_ze|CJPOWERCAST|imfx v3 API took 0.011s '/api/v3/search-suggestion/?_dc=1686819811441' t Transfer: 1220 : 12|10:03:28.2858|2AApbi|CJPOWERCAST|OAuth: /api/v3/search/title?_dc=1686819813401 t Transfer: 1220 : 12|10:03:28.2858|2AApbi|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:03:28.2858|2AApbi|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:03:28.2858|2AApbi|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:03:28.2858|2AApbi|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|10:03:28.2858|2AApbi|CJPOWERCAST|V3Api.SearchTitles t Information: 1220 : 12|10:03:28.2858|2AApbi|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|10:03:28.2858|2AApbi|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:03:28.2868|2AApbi|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:03:28.2868|2AApbi|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|10:03:28.2868|2AApbi|CJPOWERCAST|SearchTitle SQL: with v as ( SELECT abs.* ,(select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = abs.net_grp_id) CHANNEL_GROUP ,decode(ITEM_TYPE, 1010,SER_ABS_ID, 1020,CASE WHEN SER_ABS2_ID > 0 THEN SER_ABS2_ID ELSE SER_ABS_ID END ) xparent_id FROM TMDDBA.TM_PG_ABS abs WHERE abs.id in ( select a.id FROM TMDDBA.TM_PG_ABS a where ABS_DELETED = 0 AND (INSTR(OWNERS,'|SFP2|')>0 OR INSTR(OWNERS,'|PSP|')>0 OR INSTR(OWNERS,'|PMS|')>0 OR INSTR(OWNERS,'|SFP1|')>0 OR INSTR(OWNERS,'|PMH|')>0 OR INSTR(OWNERS,'|PPL|')>0 ) AND a.ser_abs_id=:param_0 AND ROWNUM < 25000 ) ) ,v_missing_parent_ids as ( select xparent_id from v minus select id from v ) ,v_missing_parents as ( SELECT distinct a.* ,(select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = a.net_grp_id) CHANNEL_GROUP ,decode(ITEM_TYPE, 1010,SER_ABS_ID, 1020,CASE WHEN SER_ABS2_ID > 0 THEN SER_ABS2_ID ELSE SER_ABS_ID END ) xparent_id FROM TMDDBA.TM_PG_ABS a START WITH ID IN (select xparent_id from v_missing_parent_ids) CONNECT BY CASE PRIOR ITEM_TYPE WHEN 1010 THEN PRIOR SER_ABS_ID WHEN 1020 THEN CASE WHEN NVL(PRIOR SER_ABS2_ID, 0) > 0 THEN PRIOR SER_ABS2_ID ELSE PRIOR SER_ABS_ID END END = ID ) ,v_all as ( select x.*, count(*) over() RowCount from ( select * from v_missing_parents union select * from v ) x ) ,v_top as ( select id from (select id, row_number()over(order by upper(ser_title),upper(title),ser_num,ser_ep_num, SER_EP_SQ_NUM ) rnk -- sort roots from v_all where xparent_id is null) where rnk between (:page_number-1)*50+1 and :page_number*50 ) ,v_tree as ( select level "TreeLevel", a.*from v_all a start with id in (select id from v_top) connect by xparent_id = prior ID order siblings by upper(ser_title),ser_num,ser_ep_num, SER_EP_SQ_NUM,upper(title) -- sort children ) select * from v_tree --where rnk <= 50 t Verbose: 1220 : 12|10:03:28.4878|2AApbi|CJPOWERCAST|imfx v3 API took 0.159s '/api/v3/search/title?_dc=1686819813401' t Transfer: 1220 : 12|10:03:28.6888|pUtdMa|CJPOWERCAST|OAuth: /api/v3/title/299390/versions?_dc=1686819813896 t Transfer: 1220 : 12|10:03:28.6888|pUtdMa|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:03:28.6888|pUtdMa|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:03:28.6888|pUtdMa|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:03:28.6888|pUtdMa|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|10:03:28.6888|cASj8j|CJPOWERCAST|OAuth: /api/user-preferences?_dc=1686819813899 t Transfer: 1220 : 12|10:03:28.6898|cASj8j|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:03:28.6898|cASj8j|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:03:28.6898|cASj8j|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:03:28.6898|cASj8j|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|10:03:28.6898|pUtdMa|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|10:03:28.6898|pUtdMa|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:03:28.6898|pUtdMa|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:03:28.6898|pUtdMa|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|10:03:28.6898|pUtdMa|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:03:28.6898|pUtdMa|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:03:28.6898|pUtdMa|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:03:28.6908|cASj8j|CJPOWERCAST|StoreUserDataByKeys.. t Transfer: 1220 : 12|10:03:28.6908|cASj8j|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:03:28.6908|cASj8j|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:03:28.6908|cASj8j|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|10:03:28.6908|pUtdMa|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:03:28.6908|pUtdMa|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:03:28.6908|pUtdMa|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|10:03:28.6908|pUtdMa|CJPOWERCAST|SearchVersion SQL: select v.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE , (select min(name) from TM_CFG_AUDIO_CONTENT_MS_TYPES audio where v.audio_type = audio.id ) SOUND ,(select min(from_date_time) from TM_PG_RL_PROD_DATE prodDate where prodDate.Tm_Pg_Rl_Id = v.id ) PROD_FROM_DATE ,(select min(to_date_time) from TM_PG_RL_PROD_DATE prodDate where prodDate.Tm_Pg_Rl_Id = v.id ) PROD_TO_DATE ,(select min(full_name) from tm_lang_data lang, TM_PG_RL_LANG_LNX link where lang.id = link.lang_id and link.tm_pg_rl_id = v.id) PROD_LANGUAGE ,(SELECT min(COLOUR_NAME) FROM tm_cfg_colour_list list, tm_pg_rl ver where ver.col_mono = list.id and ver.id = v.id) PROD_COLOUR_TEXT ,(SELECT min(cfg.prod_date_type_name) FROM TM_PG_RL_PROD_DATE pg_rl, tm_cfg_prod_date_type cfg where cfg.id = pg_rl.PROD_DATE_TYPE_ID and TM_PG_RL_ID = v.id ) PROD_DATE_TYPE ,(select min(status.description) from TM_CFG_PGM_STATUS status where v.ITEM_STATUS_ID = status.id) PGM_STATUS_TEXT ,(select submed.sub_medium_name from TM_CFG_SUB_MEDIUM submed where v.SUB_MEDIUM_ID = submed.id) SUB_MEDIUM_TEXT, (select cvt.ID from TM_PORTAL_VERSION_CONFIG cvt where v.CUSTOM_VERSION_TYPE = cvt.CUSTOM_VERSION_TYPE AND cvt.CUSTOM_VERSION_TYPE IS NOT NULL ) MP_CONFIG_ID from (select v.*, coalesce(v.primary_thumb_id, (select x.primary_thumb_id from tm_pg_rl x where x.id=v.parent_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.pgm_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs2_id) ) primary_thumb_id2 from tmddba.tm_pg_rl v where v.item_type > 0 and v.rl_deleted = 0) v left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = v.primary_thumb_id2 --sqlIdSearchJoin where 1=1 AND (INSTR(v.OWNERS,'|SFP2|')>0 OR INSTR(v.OWNERS,'|PSP|')>0 OR INSTR(v.OWNERS,'|PMS|')>0 OR INSTR(v.OWNERS,'|SFP1|')>0 OR INSTR(v.OWNERS,'|PMH|')>0 OR INSTR(v.OWNERS,'|PPL|')>0) and v.id in (select x.id from tmddba.tm_pg_rl x start with x.id in ( select a.id from (select m.id, rownum rnum from tmddba.tm_pg_rl m where item_type>0 and rl_deleted=0 and m.PGM_ABS_ID=:param_0 AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0) ) A WHERE rnum>=1 and rnum <= 9999 ) connect by nocycle prior x.parent_id=x.id) t Transfer: 1220 : 12|10:03:28.6908|pUtdMa|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:03:28.6908|pUtdMa|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:03:28.6918|pUtdMa|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|10:03:28.6918|pUtdMa|CJPOWERCAST|Running version search. User: 1165 Simple Search: Running Oracle search. Running Oracle search for COUNT Oracle count completed in: 5ms. Returned lines: 0 t Verbose: 1220 : 12|10:03:28.6918|pUtdMa|CJPOWERCAST|imfx v3 API took 0.013s '/api/v3/title/299390/versions?_dc=1686819813896' t Verbose: 1220 : 12|10:03:28.6918|cASj8j|CJPOWERCAST|imfx v3 API took 0.014s '/api/user-preferences?_dc=1686819813899' t Transfer: 1220 : 12|10:03:29.8978|OTdpsn|CJPOWERCAST|OAuth: /api/v3/title/299562/versions?_dc=1686819815089 t Transfer: 1220 : 12|10:03:29.8978|OTdpsn|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:03:29.8978|OTdpsn|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:03:29.8978|OTdpsn|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:03:29.8978|OTdpsn|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|10:03:29.8978|OTdpsn|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|10:03:29.8978|OTdpsn|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:03:29.8988|OTdpsn|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:03:29.8988|OTdpsn|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|10:03:29.8988|OTdpsn|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:03:29.8988|OTdpsn|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:03:29.8988|OTdpsn|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|10:03:29.8988|OTdpsn|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:03:29.8988|OTdpsn|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:03:29.8988|OTdpsn|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|10:03:29.8988|OTdpsn|CJPOWERCAST|SearchVersion SQL: select v.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE , (select min(name) from TM_CFG_AUDIO_CONTENT_MS_TYPES audio where v.audio_type = audio.id ) SOUND ,(select min(from_date_time) from TM_PG_RL_PROD_DATE prodDate where prodDate.Tm_Pg_Rl_Id = v.id ) PROD_FROM_DATE ,(select min(to_date_time) from TM_PG_RL_PROD_DATE prodDate where prodDate.Tm_Pg_Rl_Id = v.id ) PROD_TO_DATE ,(select min(full_name) from tm_lang_data lang, TM_PG_RL_LANG_LNX link where lang.id = link.lang_id and link.tm_pg_rl_id = v.id) PROD_LANGUAGE ,(SELECT min(COLOUR_NAME) FROM tm_cfg_colour_list list, tm_pg_rl ver where ver.col_mono = list.id and ver.id = v.id) PROD_COLOUR_TEXT ,(SELECT min(cfg.prod_date_type_name) FROM TM_PG_RL_PROD_DATE pg_rl, tm_cfg_prod_date_type cfg where cfg.id = pg_rl.PROD_DATE_TYPE_ID and TM_PG_RL_ID = v.id ) PROD_DATE_TYPE ,(select min(status.description) from TM_CFG_PGM_STATUS status where v.ITEM_STATUS_ID = status.id) PGM_STATUS_TEXT ,(select submed.sub_medium_name from TM_CFG_SUB_MEDIUM submed where v.SUB_MEDIUM_ID = submed.id) SUB_MEDIUM_TEXT, (select cvt.ID from TM_PORTAL_VERSION_CONFIG cvt where v.CUSTOM_VERSION_TYPE = cvt.CUSTOM_VERSION_TYPE AND cvt.CUSTOM_VERSION_TYPE IS NOT NULL ) MP_CONFIG_ID from (select v.*, coalesce(v.primary_thumb_id, (select x.primary_thumb_id from tm_pg_rl x where x.id=v.parent_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.pgm_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs2_id) ) primary_thumb_id2 from tmddba.tm_pg_rl v where v.item_type > 0 and v.rl_deleted = 0) v left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = v.primary_thumb_id2 --sqlIdSearchJoin where 1=1 AND (INSTR(v.OWNERS,'|SFP2|')>0 OR INSTR(v.OWNERS,'|PSP|')>0 OR INSTR(v.OWNERS,'|PMS|')>0 OR INSTR(v.OWNERS,'|SFP1|')>0 OR INSTR(v.OWNERS,'|PMH|')>0 OR INSTR(v.OWNERS,'|PPL|')>0) and v.id in (select x.id from tmddba.tm_pg_rl x start with x.id in ( select a.id from (select m.id, rownum rnum from tmddba.tm_pg_rl m where item_type>0 and rl_deleted=0 and m.PGM_ABS_ID=:param_0 AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0) ) A WHERE rnum>=1 and rnum <= 9999 ) connect by nocycle prior x.parent_id=x.id) t Transfer: 1220 : 12|10:03:29.8988|OTdpsn|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:03:29.8998|OTdpsn|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:03:29.8998|OTdpsn|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|10:03:30.5028|OTdpsn|CJPOWERCAST|Running version search. User: 1165 Simple Search: Running Oracle search. Running Oracle search for COUNT Oracle count completed in: 4ms. Returned lines: 1 Oracle version search timing: 449ms. SQL run: select v.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE , (select min(name) from TM_CFG_AUDIO_CONTENT_MS_TYPES audio where v.audio_type = audio.id ) SOUND ,(select min(from_date_time) from TM_PG_RL_PROD_DATE prodDate where prodDate.Tm_Pg_Rl_Id = v.id ) PROD_FROM_DATE ,(select min(to_date_time) from TM_PG_RL_PROD_DATE prodDate where prodDate.Tm_Pg_Rl_Id = v.id ) PROD_TO_DATE ,(select min(full_name) from tm_lang_data lang, TM_PG_RL_LANG_LNX link where lang.id = link.lang_id and link.tm_pg_rl_id = v.id) PROD_LANGUAGE ,(SELECT min(COLOUR_NAME) FROM tm_cfg_colour_list list, tm_pg_rl ver where ver.col_mono = list.id and ver.id = v.id) PROD_COLOUR_TEXT ,(SELECT min(cfg.prod_date_type_name) FROM TM_PG_RL_PROD_DATE pg_rl, tm_cfg_prod_date_type cfg where cfg.id = pg_rl.PROD_DATE_TYPE_ID and TM_PG_RL_ID = v.id ) PROD_DATE_TYPE ,(select min(status.description) from TM_CFG_PGM_STATUS status where v.ITEM_STATUS_ID = status.id) PGM_STATUS_TEXT ,(select submed.sub_medium_name from TM_CFG_SUB_MEDIUM submed where v.SUB_MEDIUM_ID = submed.id) SUB_MEDIUM_TEXT, (select cvt.ID from TM_PORTAL_VERSION_CONFIG cvt where v.CUSTOM_VERSION_TYPE = cvt.CUSTOM_VERSION_TYPE AND cvt.CUSTOM_VERSION_TYPE IS NOT NULL ) MP_CONFIG_ID from (select v.*, coalesce(v.primary_thumb_id, (select x.primary_thumb_id from tm_pg_rl x where x.id=v.parent_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.pgm_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs2_id) ) primary_thumb_id2 from tmddba.tm_pg_rl v where v.item_type > 0 and v.rl_deleted = 0) v left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = v.primary_thumb_id2 --sqlIdSearchJoin where 1=1 AND (INSTR(v.OWNERS,'|SFP2|')>0 OR INSTR(v.OWNERS,'|PSP|')>0 OR INSTR(v.OWNERS,'|PMS|')>0 OR INSTR(v.OWNERS,'|SFP1|')>0 OR INSTR(v.OWNERS,'|PMH|')>0 OR INSTR(v.OWNERS,'|PPL|')>0) and v.id in (select x.id from tmddba.tm_pg_rl x start with x.id in ( select a.id from (select m.id, rownum rnum from tmddba.tm_pg_rl m where item_type>0 and rl_deleted=0 and m.PGM_ABS_ID=:param_0 AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0) ) A WHERE rnum>=1 and rnum <= 9999 ) connect by nocycle prior x.parent_id=x.id) t Verbose: 1220 : 12|10:03:30.5028|OTdpsn|CJPOWERCAST|imfx v3 API took 0.462s '/api/v3/title/299562/versions?_dc=1686819815089' t Transfer: 1220 : 12|10:03:30.7038|Ybd3hG|CJPOWERCAST|OAuth: /api/user-group-preferences?keys=defaultSearchColumnsMedia&_dc=1686819815876 t Transfer: 1220 : 12|10:03:30.7038|Ybd3hG|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:03:30.7038|Ybd3hG|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:03:30.7038|Ybd3hG|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:03:30.7038|Ybd3hG|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|10:03:30.7038|Ybd3hG|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:03:30.7048|Ybd3hG|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:03:30.7048|Ybd3hG|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|10:03:30.7048|tUzwyR|CJPOWERCAST|OAuth: /api/user-group-preferences?keys=defaultSearchColumnsMedia&_dc=1686819815874 t Transfer: 1220 : 12|10:03:30.7048|tUzwyR|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:03:30.7048|tUzwyR|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:03:30.7048|tUzwyR|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:03:30.7048|tUzwyR|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|10:03:30.7058|x4WzGG|CJPOWERCAST|OAuth: /api/v3/version/299563/media?_dc=1686819815877 t Transfer: 1220 : 12|10:03:30.7058|x4WzGG|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:03:30.7058|x4WzGG|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:03:30.7058|x4WzGG|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:03:30.7058|x4WzGG|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|10:03:30.7058|tUzwyR|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:03:30.7058|tUzwyR|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:03:30.7058|tUzwyR|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|10:03:30.7068|x4WzGG|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|10:03:30.7068|x4WzGG|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:03:30.7068|x4WzGG|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:03:30.7068|x4WzGG|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:03:30.7068|tUzwyR|CJPOWERCAST|imfx v3 API took 0.007s '/api/user-group-preferences?keys=defaultSearchColumnsMedia&_dc=1686819815874' t Information: 1220 : 12|10:03:30.7068|x4WzGG|CJPOWERCAST|MediaSearch SQL: --sqlFromPaging select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type in (1,110)),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , (SELECT min(status.ACCESS_STATUS_NAME) FROM TMDDBA.TM_ACCESS_STATUS statusLnx, TM_CFG_ACCESS_STATUS status WHERE statusLnx.Media_Id = r.id and statusLnx.Status_Id = status.id) ACCESS_STATUS , (select min(acq.ext_ref) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) CONSIGNMENT_NUMBER , (select min(acq.alt_id1) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) TRANSFER_NUMBER , (select min(crs.series_number) from tm_series_data crs where crs.id = r.GROUP_SERIES_ID) CRS_SERIES , (select min(DISPOSAL_NAME) from TM_ACQ_DISPOSAL status, tm_disposal_records records where status.id = records.disposal_status_id and records.miid = r.id) DISPOSAL_STATUS , (select min(class.class_number) from TM_ACQ_DISPOSAL status, tm_disposal_records records, tm_disposal_classes class where status.id = records.disposal_status_id and records.miid = r.id and class.id = records.disposal_class_id) DISPOSAL_CLASS, (select min(names.concat_search_name) from tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names where r.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY, (select min(c.u_id_ext1) from tmddba.tm_mi_tpi_lnx lnx, tm_ctnrs c where c.u_id = lnx.tpiid and lnx.miid = r.id) U_ID_EXT1 , (select t.name from TM_CFG_MI_FMT_TYP t where t.id = r.mi_fmt_type) ITEM_FORMAT_TEXT, CASE WHEN BITAND(r.COMPIL, 2) = 2 THEN 'SUPPLIED' WHEN BITAND(r.COMPIL, 4) = 4 THEN 'MADE' WHEN BITAND(r.COMPIL, 134217728) = 134217728 THEN 'IMPORTED' ELSE '' END AS ORIGIN, CASE WHEN BITAND(r.COMPIL, 512) = 512 THEN 'Attached' WHEN BITAND(r.COMPIL, 1024) = 1024 THEN 'Un-Attached' ELSE '' END AS FLAGS, (select min(lang.full_name) from TM_PG_RL_LANG_LNX lnx, TM_LANG_DATA lang where lnx.tm_pg_rl_id = r.pgm_parent_id and lnx.lang_id = lang.id) AS PROD_LANGUAGE , (select min(ctx.ITFC_CODE) from tm_mis mis, tm_mi_tpi_lnx links, tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names where mis.id = r.id and links.miid = mis.id and mis.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY_NUMBER, (select min(status.description) from TM_CFG_PGM_STATUS status where r.status = status.id) PGM_STATUS_TEXT, (select min(ver.DUR) from TM_PG_RL ver where r.pgm_PARENT_ID = ver.id) AS VERSION_DUR , (select tmd_str_agg_pipe(cms.status_type_id ||',' ||cms.status_id) from tm_mi_cust_med_stat_lnx cms where cms.media_id=r.id) "CustomStatusesRaw", (select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = r.net_grp_id) CHANNEL_GROUP, (SELECT SUBSTR( trim( replace (replace ( LISTAGG(trim(tt.tags || ' ' || tt.notes), ' ') WITHIN GROUP (ORDER BY trim(tt.tags || ' ' || tt.notes)), chr (13), ''), chr (10), ' ')), 1, 150) z FROM tm_media_tagging tt WHERE link_guid = DFILE_LINK_GUID and rownum=1) TAGS_TEXT , GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select t.*, coalesce(t.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=t.pgm_parent_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.pgm_abs_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs2_id) ) primary_thumb_id2 from ( --sqlSubSelect select s.* from (select a.*, rownum rnum from (select --sqlFrom m.* from tmddba.tm_mis m --sqlWhere where media_type>0 and item_type>0 AND PGM_PARENT_ID=:param_0 and m.mi_deleted=0 AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0) order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) s where rnum >= 1) t ) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl order by r.rnum t Verbose: 1220 : 12|10:03:30.7078|Ybd3hG|CJPOWERCAST|imfx v3 API took 0.014s '/api/user-group-preferences?keys=defaultSearchColumnsMedia&_dc=1686819815876' t Transfer: 1220 : 12|10:03:30.7078|2QyMjj|CJPOWERCAST|OAuth: /api/v3/version/299563/media?_dc=1686819815898 t Transfer: 1220 : 12|10:03:30.7078|2QyMjj|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:03:30.7078|2QyMjj|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:03:30.7078|2QyMjj|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:03:30.7078|2QyMjj|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|10:03:30.7088|CxG1CX|CJPOWERCAST|OAuth: /api/user-group-preferences?keys=defaultSearchColumnsMedia&_dc=1686819815896 t Transfer: 1220 : 12|10:03:30.7088|CxG1CX|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:03:30.7088|CxG1CX|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:03:30.7088|CxG1CX|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:03:30.7088|CxG1CX|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|10:03:30.7088|1EJOI0|CJPOWERCAST|OAuth: /api/user-group-preferences?keys=defaultSearchColumnsMedia&_dc=1686819815897 t Transfer: 1220 : 12|10:03:30.7088|1EJOI0|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:03:30.7088|1EJOI0|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:03:30.7088|1EJOI0|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:03:30.7098|1EJOI0|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|10:03:30.7098|CxG1CX|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:03:30.7098|CxG1CX|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:03:30.7098|CxG1CX|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|10:03:30.7098|2QyMjj|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|10:03:30.7098|2QyMjj|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:03:30.7098|2QyMjj|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:03:30.7098|2QyMjj|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:03:30.7108|x4WzGG|CJPOWERCAST|Alternative title fields query: select * from (select x.id,x.pgm_abs_id TitleId, x.pgm_parent_id VersionId from tm_mis x where id in (select /*+ cardinality(4) */ column_value id from table(:ids))) y,lateral (select dbms_lob.substr( o.text_data_plain, 1000, 1 ) Field_5799344 from tm_txt_obj o where (o.pgm_abs_id=y.TitleId or o.pgm_rl_id = y.VersionId) and o.type_id=:param_1 order by o.id desc fetch first 1 rows only)(+) t Information: 1220 : 12|10:03:30.9118|2QyMjj|CJPOWERCAST|MediaSearch SQL: --sqlFromPaging select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type in (1,110)),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , (SELECT min(status.ACCESS_STATUS_NAME) FROM TMDDBA.TM_ACCESS_STATUS statusLnx, TM_CFG_ACCESS_STATUS status WHERE statusLnx.Media_Id = r.id and statusLnx.Status_Id = status.id) ACCESS_STATUS , (select min(acq.ext_ref) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) CONSIGNMENT_NUMBER , (select min(acq.alt_id1) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) TRANSFER_NUMBER , (select min(crs.series_number) from tm_series_data crs where crs.id = r.GROUP_SERIES_ID) CRS_SERIES , (select min(DISPOSAL_NAME) from TM_ACQ_DISPOSAL status, tm_disposal_records records where status.id = records.disposal_status_id and records.miid = r.id) DISPOSAL_STATUS , (select min(class.class_number) from TM_ACQ_DISPOSAL status, tm_disposal_records records, tm_disposal_classes class where status.id = records.disposal_status_id and records.miid = r.id and class.id = records.disposal_class_id) DISPOSAL_CLASS, (select min(names.concat_search_name) from tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names where r.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY, (select min(c.u_id_ext1) from tmddba.tm_mi_tpi_lnx lnx, tm_ctnrs c where c.u_id = lnx.tpiid and lnx.miid = r.id) U_ID_EXT1 , (select t.name from TM_CFG_MI_FMT_TYP t where t.id = r.mi_fmt_type) ITEM_FORMAT_TEXT, CASE WHEN BITAND(r.COMPIL, 2) = 2 THEN 'SUPPLIED' WHEN BITAND(r.COMPIL, 4) = 4 THEN 'MADE' WHEN BITAND(r.COMPIL, 134217728) = 134217728 THEN 'IMPORTED' ELSE '' END AS ORIGIN, CASE WHEN BITAND(r.COMPIL, 512) = 512 THEN 'Attached' WHEN BITAND(r.COMPIL, 1024) = 1024 THEN 'Un-Attached' ELSE '' END AS FLAGS, (select min(lang.full_name) from TM_PG_RL_LANG_LNX lnx, TM_LANG_DATA lang where lnx.tm_pg_rl_id = r.pgm_parent_id and lnx.lang_id = lang.id) AS PROD_LANGUAGE , (select min(ctx.ITFC_CODE) from tm_mis mis, tm_mi_tpi_lnx links, tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names where mis.id = r.id and links.miid = mis.id and mis.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY_NUMBER, (select min(status.description) from TM_CFG_PGM_STATUS status where r.status = status.id) PGM_STATUS_TEXT, (select min(ver.DUR) from TM_PG_RL ver where r.pgm_PARENT_ID = ver.id) AS VERSION_DUR , (select tmd_str_agg_pipe(cms.status_type_id ||',' ||cms.status_id) from tm_mi_cust_med_stat_lnx cms where cms.media_id=r.id) "CustomStatusesRaw", (select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = r.net_grp_id) CHANNEL_GROUP, (SELECT SUBSTR( trim( replace (replace ( LISTAGG(trim(tt.tags || ' ' || tt.notes), ' ') WITHIN GROUP (ORDER BY trim(tt.tags || ' ' || tt.notes)), chr (13), ''), chr (10), ' ')), 1, 150) z FROM tm_media_tagging tt WHERE link_guid = DFILE_LINK_GUID and rownum=1) TAGS_TEXT , GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select t.*, coalesce(t.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=t.pgm_parent_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.pgm_abs_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs2_id) ) primary_thumb_id2 from ( --sqlSubSelect select s.* from (select a.*, rownum rnum from (select --sqlFrom m.* from tmddba.tm_mis m --sqlWhere where media_type>0 and item_type>0 AND PGM_PARENT_ID=:param_0 and m.mi_deleted=0 AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0) order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) s where rnum >= 1) t ) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl order by r.rnum t Transfer: 1220 : 12|10:03:30.9118|1EJOI0|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:03:30.9118|1EJOI0|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:03:30.9118|1EJOI0|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:03:30.9118|1EJOI0|CJPOWERCAST|imfx v3 API took 0.006s '/api/user-group-preferences?keys=defaultSearchColumnsMedia&_dc=1686819815897' t Verbose: 1220 : 12|10:03:30.9118|CxG1CX|CJPOWERCAST|imfx v3 API took 0.089s '/api/user-group-preferences?keys=defaultSearchColumnsMedia&_dc=1686819815896' t Information: 1220 : 12|10:03:30.9128|x4WzGG|CJPOWERCAST| timing: 00:00:00.0999432 t Verbose: 1220 : 12|10:03:30.9128|x4WzGG|CJPOWERCAST|imfx v3 API took 0.100s '/api/v3/version/299563/media?_dc=1686819815877' t Transfer: 1220 : 12|10:03:30.9128|x4WzGG|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0013.mp4 subfolder t Transfer: 1220 : 12|10:03:30.9128|x4WzGG|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0013.mp4 t Transfer: 1220 : 12|10:03:30.9128|x4WzGG|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0013.mp4 t Transfer: 1220 : 12|10:03:30.9128|x4WzGG|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:03:30.9128|x4WzGG|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:03:30.9128|x4WzGG|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|10:03:30.9128|x4WzGG|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001993.mp4 subfolder t Transfer: 1220 : 12|10:03:30.9128|x4WzGG|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001993.mp4 t Transfer: 1220 : 12|10:03:30.9138|x4WzGG|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001993.mp4 t Transfer: 1220 : 12|10:03:30.9138|x4WzGG|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:03:30.9138|x4WzGG|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:03:30.9138|x4WzGG|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|10:03:30.9138|x4WzGG|CJPOWERCAST|GetUrl. Storage |Temp Storage| filename C:\TEMP\GOPR0013.mp4 subfolder t Transfer: 1220 : 12|10:03:30.9138|x4WzGG|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:03:30.9138|x4WzGG|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:03:30.9138|x4WzGG|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|10:03:30.9138|x4WzGG|CJPOWERCAST|GetUrl. Storage |Temp Storage| filename C:\TEMP\N0001993.mp4 subfolder t Transfer: 1220 : 12|10:03:30.9138|x4WzGG|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:03:30.9138|x4WzGG|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:03:30.9148|x4WzGG|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:03:30.9148|2QyMjj|CJPOWERCAST|Alternative title fields query: select * from (select x.id,x.pgm_abs_id TitleId, x.pgm_parent_id VersionId from tm_mis x where id in (select /*+ cardinality(4) */ column_value id from table(:ids))) y,lateral (select dbms_lob.substr( o.text_data_plain, 1000, 1 ) Field_5799344 from tm_txt_obj o where (o.pgm_abs_id=y.TitleId or o.pgm_rl_id = y.VersionId) and o.type_id=:param_1 order by o.id desc fetch first 1 rows only)(+) t Information: 1220 : 12|10:03:30.9148|2QyMjj|CJPOWERCAST| timing: 00:00:00.1126822 t Verbose: 1220 : 12|10:03:30.9148|2QyMjj|CJPOWERCAST|imfx v3 API took 0.113s '/api/v3/version/299563/media?_dc=1686819815898' t Transfer: 1220 : 12|10:03:30.9148|2QyMjj|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0013.mp4 subfolder t Transfer: 1220 : 12|10:03:30.9148|2QyMjj|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0013.mp4 t Transfer: 1220 : 12|10:03:30.9148|2QyMjj|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0013.mp4 t Transfer: 1220 : 12|10:03:30.9148|2QyMjj|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:03:30.9148|2QyMjj|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:03:30.9148|2QyMjj|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|10:03:30.9158|2QyMjj|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001993.mp4 subfolder t Transfer: 1220 : 12|10:03:30.9158|2QyMjj|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001993.mp4 t Transfer: 1220 : 12|10:03:30.9158|2QyMjj|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001993.mp4 t Transfer: 1220 : 12|10:03:30.9158|2QyMjj|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:03:30.9158|2QyMjj|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:03:30.9158|2QyMjj|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|10:03:30.9158|2QyMjj|CJPOWERCAST|GetUrl. Storage |Temp Storage| filename C:\TEMP\GOPR0013.mp4 subfolder t Transfer: 1220 : 12|10:03:30.9158|2QyMjj|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:03:30.9158|2QyMjj|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:03:30.9158|2QyMjj|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|10:03:30.9168|2QyMjj|CJPOWERCAST|GetUrl. Storage |Temp Storage| filename C:\TEMP\N0001993.mp4 subfolder t Transfer: 1220 : 12|10:03:30.9168|2QyMjj|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:03:30.9168|2QyMjj|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:03:30.9168|2QyMjj|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|10:03:31.1178|bgD0n3|CJPOWERCAST|OAuth: /api/v3/media/299528/carriers/digital?_dc=1686819816312 t Transfer: 1220 : 12|10:03:31.1178|bgD0n3|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:03:31.1178|bgD0n3|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:03:31.1178|bgD0n3|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:03:31.1178|bgD0n3|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|10:03:31.1178|bgD0n3|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|10:03:31.1178|bgD0n3|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:03:31.1178|bgD0n3|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:03:31.1178|bgD0n3|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|10:03:31.1188|bgD0n3|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:03:31.1188|bgD0n3|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:03:31.1188|bgD0n3|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|10:03:31.1188|bgD0n3|CJPOWERCAST|SearchDigitalCarriersAdv SQL: select r.*, l.dv_nam SRVER_ID_TEXT from ( select a.*, rownum rnum from ( select m.* from tmddba.tm_dfile m where m.id in (select l.dfile_id as ID from TMDDBA.tm_mi_dfile_lnx l join TMDDBA.TM_MIS mi on (l.mi_id = mi.id) where (INSTR(mi.OWNERS,'|SFP2|')>0 OR INSTR(mi.OWNERS,'|PSP|')>0 OR INSTR(mi.OWNERS,'|PMS|')>0 OR INSTR(mi.OWNERS,'|SFP1|')>0 OR INSTR(mi.OWNERS,'|PMH|')>0 OR INSTR(mi.OWNERS,'|PPL|')>0)and mi.MI_DELETED = 0 and mi.ITEM_TYPE > 0) and m.id in (select l.dfile_id as ID from TMDDBA.tm_mi_dfile_lnx l join TMDDBA.TM_MIS mi on (l.mi_id = mi.id) where mi.id = :param_0 AND (INSTR(mi.OWNERS,'|SFP2|')>0 OR INSTR(mi.OWNERS,'|PSP|')>0 OR INSTR(mi.OWNERS,'|PMS|')>0 OR INSTR(mi.OWNERS,'|SFP1|')>0 OR INSTR(mi.OWNERS,'|PMH|')>0 OR INSTR(mi.OWNERS,'|PPL|')>0)and mi.MI_DELETED = 0 and mi.ITEM_TYPE > 0) order by m.OS_FNAME, m.id ) a where rownum <= 50) r left join tm_device_lst l on (r.srver_id = l.id) where rnum >= 1 order by rnum t Verbose: 1220 : 12|10:03:31.1188|bgD0n3|CJPOWERCAST|imfx v3 API took 0.013s '/api/v3/media/299528/carriers/digital?_dc=1686819816312' t Transfer: 1220 : 12|10:03:31.5208|DPDOmT|CJPOWERCAST|OAuth: /api/v3/media/299528/carriers/digital?_dc=1686819816667 t Transfer: 1220 : 12|10:03:31.5208|DPDOmT|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:03:31.5208|DPDOmT|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:03:31.5208|DPDOmT|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:03:31.5208|DPDOmT|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|10:03:31.5208|DPDOmT|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|10:03:31.5208|DPDOmT|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:03:31.5208|DPDOmT|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:03:31.5218|DPDOmT|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|10:03:31.5218|DPDOmT|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:03:31.5218|DPDOmT|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:03:31.5218|DPDOmT|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|10:03:31.5218|DPDOmT|CJPOWERCAST|SearchDigitalCarriersAdv SQL: select r.*, l.dv_nam SRVER_ID_TEXT from ( select a.*, rownum rnum from ( select m.* from tmddba.tm_dfile m where m.id in (select l.dfile_id as ID from TMDDBA.tm_mi_dfile_lnx l join TMDDBA.TM_MIS mi on (l.mi_id = mi.id) where (INSTR(mi.OWNERS,'|SFP2|')>0 OR INSTR(mi.OWNERS,'|PSP|')>0 OR INSTR(mi.OWNERS,'|PMS|')>0 OR INSTR(mi.OWNERS,'|SFP1|')>0 OR INSTR(mi.OWNERS,'|PMH|')>0 OR INSTR(mi.OWNERS,'|PPL|')>0)and mi.MI_DELETED = 0 and mi.ITEM_TYPE > 0) and m.id in (select l.dfile_id as ID from TMDDBA.tm_mi_dfile_lnx l join TMDDBA.TM_MIS mi on (l.mi_id = mi.id) where mi.id = :param_0 AND (INSTR(mi.OWNERS,'|SFP2|')>0 OR INSTR(mi.OWNERS,'|PSP|')>0 OR INSTR(mi.OWNERS,'|PMS|')>0 OR INSTR(mi.OWNERS,'|SFP1|')>0 OR INSTR(mi.OWNERS,'|PMH|')>0 OR INSTR(mi.OWNERS,'|PPL|')>0)and mi.MI_DELETED = 0 and mi.ITEM_TYPE > 0) order by m.OS_FNAME, m.id ) a where rownum <= 50) r left join tm_device_lst l on (r.srver_id = l.id) where rnum >= 1 order by rnum t Verbose: 1220 : 12|10:03:31.5218|DPDOmT|CJPOWERCAST|imfx v3 API took 0.014s '/api/v3/media/299528/carriers/digital?_dc=1686819816667' t Transfer: 1220 : 12|10:03:45.3908|pBturk|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:03:45.3908|pBturk|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:03:45.3908|pBturk|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|10:04:27.4000|~rHTvk|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:04:27.4000|~rHTvk|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:04:27.4000|~rHTvk|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|10:04:33.8320|8_mVvV|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1686819878973 t Transfer: 1220 : 12|10:04:33.8320|8_mVvV|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:04:33.8320|8_mVvV|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:04:33.8320|8_mVvV|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:04:33.8320|8_mVvV|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|10:04:33.8320|8_mVvV|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:04:33.8330|8_mVvV|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:04:33.8330|8_mVvV|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:04:33.8330|8_mVvV|CJPOWERCAST|imfx v3 API took 0.008s '/api/v3/search-suggestion/?_dc=1686819878973' t Transfer: 1220 : 12|10:04:35.2400|TQe5l2|CJPOWERCAST|OAuth: /api/v3/search/title?_dc=1686819880368 t Transfer: 1220 : 12|10:04:35.2400|TQe5l2|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:04:35.2400|TQe5l2|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:04:35.2400|TQe5l2|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:04:35.2400|TQe5l2|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|10:04:35.2400|TQe5l2|CJPOWERCAST|V3Api.SearchTitles t Information: 1220 : 12|10:04:35.2400|TQe5l2|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|10:04:35.2410|TQe5l2|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:04:35.2410|TQe5l2|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:04:35.2410|TQe5l2|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|10:04:35.2410|TQe5l2|CJPOWERCAST|SearchTitle SQL: with v as ( SELECT abs.* ,(select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = abs.net_grp_id) CHANNEL_GROUP ,decode(ITEM_TYPE, 1010,SER_ABS_ID, 1020,CASE WHEN SER_ABS2_ID > 0 THEN SER_ABS2_ID ELSE SER_ABS_ID END ) xparent_id FROM TMDDBA.TM_PG_ABS abs WHERE abs.id in ( select a.id FROM TMDDBA.TM_PG_ABS a where ABS_DELETED = 0 AND (INSTR(OWNERS,'|SFP2|')>0 OR INSTR(OWNERS,'|PSP|')>0 OR INSTR(OWNERS,'|PMS|')>0 OR INSTR(OWNERS,'|SFP1|')>0 OR INSTR(OWNERS,'|PMH|')>0 OR INSTR(OWNERS,'|PPL|')>0 ) AND a.ser_abs_id=:param_0 AND ROWNUM < 25000 ) ) ,v_missing_parent_ids as ( select xparent_id from v minus select id from v ) ,v_missing_parents as ( SELECT distinct a.* ,(select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = a.net_grp_id) CHANNEL_GROUP ,decode(ITEM_TYPE, 1010,SER_ABS_ID, 1020,CASE WHEN SER_ABS2_ID > 0 THEN SER_ABS2_ID ELSE SER_ABS_ID END ) xparent_id FROM TMDDBA.TM_PG_ABS a START WITH ID IN (select xparent_id from v_missing_parent_ids) CONNECT BY CASE PRIOR ITEM_TYPE WHEN 1010 THEN PRIOR SER_ABS_ID WHEN 1020 THEN CASE WHEN NVL(PRIOR SER_ABS2_ID, 0) > 0 THEN PRIOR SER_ABS2_ID ELSE PRIOR SER_ABS_ID END END = ID ) ,v_all as ( select x.*, count(*) over() RowCount from ( select * from v_missing_parents union select * from v ) x ) ,v_top as ( select id from (select id, row_number()over(order by upper(ser_title),upper(title),ser_num,ser_ep_num, SER_EP_SQ_NUM ) rnk -- sort roots from v_all where xparent_id is null) where rnk between (:page_number-1)*50+1 and :page_number*50 ) ,v_tree as ( select level "TreeLevel", a.*from v_all a start with id in (select id from v_top) connect by xparent_id = prior ID order siblings by upper(ser_title),ser_num,ser_ep_num, SER_EP_SQ_NUM,upper(title) -- sort children ) select * from v_tree --where rnk <= 50 t Verbose: 1220 : 12|10:04:35.2410|TQe5l2|CJPOWERCAST|imfx v3 API took 0.015s '/api/v3/search/title?_dc=1686819880368' t Transfer: 1220 : 12|10:04:35.4420|XCADpo|CJPOWERCAST|OAuth: /api/v3/title/299390/versions?_dc=1686819880672 t Transfer: 1220 : 12|10:04:35.4420|XCADpo|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:04:35.4420|XCADpo|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:04:35.4420|XCADpo|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:04:35.4420|XCADpo|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|10:04:35.4420|XCADpo|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|10:04:35.4420|XCADpo|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:04:35.4420|XCADpo|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:04:35.4430|XCADpo|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|10:04:35.4430|XCADpo|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:04:35.4430|XCADpo|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:04:35.4430|XCADpo|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|10:04:35.4430|XCADpo|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:04:35.4430|XCADpo|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:04:35.4430|XCADpo|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|10:04:35.4430|XCADpo|CJPOWERCAST|SearchVersion SQL: select v.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE , (select min(name) from TM_CFG_AUDIO_CONTENT_MS_TYPES audio where v.audio_type = audio.id ) SOUND ,(select min(from_date_time) from TM_PG_RL_PROD_DATE prodDate where prodDate.Tm_Pg_Rl_Id = v.id ) PROD_FROM_DATE ,(select min(to_date_time) from TM_PG_RL_PROD_DATE prodDate where prodDate.Tm_Pg_Rl_Id = v.id ) PROD_TO_DATE ,(select min(full_name) from tm_lang_data lang, TM_PG_RL_LANG_LNX link where lang.id = link.lang_id and link.tm_pg_rl_id = v.id) PROD_LANGUAGE ,(SELECT min(COLOUR_NAME) FROM tm_cfg_colour_list list, tm_pg_rl ver where ver.col_mono = list.id and ver.id = v.id) PROD_COLOUR_TEXT ,(SELECT min(cfg.prod_date_type_name) FROM TM_PG_RL_PROD_DATE pg_rl, tm_cfg_prod_date_type cfg where cfg.id = pg_rl.PROD_DATE_TYPE_ID and TM_PG_RL_ID = v.id ) PROD_DATE_TYPE ,(select min(status.description) from TM_CFG_PGM_STATUS status where v.ITEM_STATUS_ID = status.id) PGM_STATUS_TEXT ,(select submed.sub_medium_name from TM_CFG_SUB_MEDIUM submed where v.SUB_MEDIUM_ID = submed.id) SUB_MEDIUM_TEXT, (select cvt.ID from TM_PORTAL_VERSION_CONFIG cvt where v.CUSTOM_VERSION_TYPE = cvt.CUSTOM_VERSION_TYPE AND cvt.CUSTOM_VERSION_TYPE IS NOT NULL ) MP_CONFIG_ID from (select v.*, coalesce(v.primary_thumb_id, (select x.primary_thumb_id from tm_pg_rl x where x.id=v.parent_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.pgm_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs2_id) ) primary_thumb_id2 from tmddba.tm_pg_rl v where v.item_type > 0 and v.rl_deleted = 0) v left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = v.primary_thumb_id2 --sqlIdSearchJoin where 1=1 AND (INSTR(v.OWNERS,'|SFP2|')>0 OR INSTR(v.OWNERS,'|PSP|')>0 OR INSTR(v.OWNERS,'|PMS|')>0 OR INSTR(v.OWNERS,'|SFP1|')>0 OR INSTR(v.OWNERS,'|PMH|')>0 OR INSTR(v.OWNERS,'|PPL|')>0) and v.id in (select x.id from tmddba.tm_pg_rl x start with x.id in ( select a.id from (select m.id, rownum rnum from tmddba.tm_pg_rl m where item_type>0 and rl_deleted=0 and m.PGM_ABS_ID=:param_0 AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0) ) A WHERE rnum>=1 and rnum <= 9999 ) connect by nocycle prior x.parent_id=x.id) t Transfer: 1220 : 12|10:04:35.4430|XCADpo|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:04:35.4430|XCADpo|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:04:35.4440|XCADpo|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|10:04:35.4440|XCADpo|CJPOWERCAST|Running version search. User: 1165 Simple Search: Running Oracle search. Running Oracle search for COUNT Oracle count completed in: 5ms. Returned lines: 0 t Verbose: 1220 : 12|10:04:35.4440|XCADpo|CJPOWERCAST|imfx v3 API took 0.013s '/api/v3/title/299390/versions?_dc=1686819880672' t Transfer: 1220 : 12|10:04:37.2530|JdSrZ7|CJPOWERCAST|OAuth: /api/v3/title/299562/versions?_dc=1686819882390 t Transfer: 1220 : 12|10:04:37.2530|JdSrZ7|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:04:37.2530|JdSrZ7|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:04:37.2530|JdSrZ7|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:04:37.2530|JdSrZ7|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|10:04:37.2530|JdSrZ7|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|10:04:37.2530|JdSrZ7|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:04:37.2530|JdSrZ7|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:04:37.2540|JdSrZ7|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|10:04:37.2540|JdSrZ7|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:04:37.2540|JdSrZ7|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:04:37.2540|JdSrZ7|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|10:04:37.2540|JdSrZ7|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:04:37.2540|JdSrZ7|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:04:37.2540|JdSrZ7|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|10:04:37.2540|JdSrZ7|CJPOWERCAST|SearchVersion SQL: select v.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE , (select min(name) from TM_CFG_AUDIO_CONTENT_MS_TYPES audio where v.audio_type = audio.id ) SOUND ,(select min(from_date_time) from TM_PG_RL_PROD_DATE prodDate where prodDate.Tm_Pg_Rl_Id = v.id ) PROD_FROM_DATE ,(select min(to_date_time) from TM_PG_RL_PROD_DATE prodDate where prodDate.Tm_Pg_Rl_Id = v.id ) PROD_TO_DATE ,(select min(full_name) from tm_lang_data lang, TM_PG_RL_LANG_LNX link where lang.id = link.lang_id and link.tm_pg_rl_id = v.id) PROD_LANGUAGE ,(SELECT min(COLOUR_NAME) FROM tm_cfg_colour_list list, tm_pg_rl ver where ver.col_mono = list.id and ver.id = v.id) PROD_COLOUR_TEXT ,(SELECT min(cfg.prod_date_type_name) FROM TM_PG_RL_PROD_DATE pg_rl, tm_cfg_prod_date_type cfg where cfg.id = pg_rl.PROD_DATE_TYPE_ID and TM_PG_RL_ID = v.id ) PROD_DATE_TYPE ,(select min(status.description) from TM_CFG_PGM_STATUS status where v.ITEM_STATUS_ID = status.id) PGM_STATUS_TEXT ,(select submed.sub_medium_name from TM_CFG_SUB_MEDIUM submed where v.SUB_MEDIUM_ID = submed.id) SUB_MEDIUM_TEXT, (select cvt.ID from TM_PORTAL_VERSION_CONFIG cvt where v.CUSTOM_VERSION_TYPE = cvt.CUSTOM_VERSION_TYPE AND cvt.CUSTOM_VERSION_TYPE IS NOT NULL ) MP_CONFIG_ID from (select v.*, coalesce(v.primary_thumb_id, (select x.primary_thumb_id from tm_pg_rl x where x.id=v.parent_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.pgm_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs2_id) ) primary_thumb_id2 from tmddba.tm_pg_rl v where v.item_type > 0 and v.rl_deleted = 0) v left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = v.primary_thumb_id2 --sqlIdSearchJoin where 1=1 AND (INSTR(v.OWNERS,'|SFP2|')>0 OR INSTR(v.OWNERS,'|PSP|')>0 OR INSTR(v.OWNERS,'|PMS|')>0 OR INSTR(v.OWNERS,'|SFP1|')>0 OR INSTR(v.OWNERS,'|PMH|')>0 OR INSTR(v.OWNERS,'|PPL|')>0) and v.id in (select x.id from tmddba.tm_pg_rl x start with x.id in ( select a.id from (select m.id, rownum rnum from tmddba.tm_pg_rl m where item_type>0 and rl_deleted=0 and m.PGM_ABS_ID=:param_0 AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0) ) A WHERE rnum>=1 and rnum <= 9999 ) connect by nocycle prior x.parent_id=x.id) t Transfer: 1220 : 12|10:04:37.2540|JdSrZ7|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:04:37.2550|JdSrZ7|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:04:37.2550|JdSrZ7|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|10:04:37.6570|JdSrZ7|CJPOWERCAST|Running version search. User: 1165 Simple Search: Running Oracle search. Running Oracle search for COUNT Oracle count completed in: 4ms. Returned lines: 1 Oracle version search timing: 446ms. SQL run: select v.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE , (select min(name) from TM_CFG_AUDIO_CONTENT_MS_TYPES audio where v.audio_type = audio.id ) SOUND ,(select min(from_date_time) from TM_PG_RL_PROD_DATE prodDate where prodDate.Tm_Pg_Rl_Id = v.id ) PROD_FROM_DATE ,(select min(to_date_time) from TM_PG_RL_PROD_DATE prodDate where prodDate.Tm_Pg_Rl_Id = v.id ) PROD_TO_DATE ,(select min(full_name) from tm_lang_data lang, TM_PG_RL_LANG_LNX link where lang.id = link.lang_id and link.tm_pg_rl_id = v.id) PROD_LANGUAGE ,(SELECT min(COLOUR_NAME) FROM tm_cfg_colour_list list, tm_pg_rl ver where ver.col_mono = list.id and ver.id = v.id) PROD_COLOUR_TEXT ,(SELECT min(cfg.prod_date_type_name) FROM TM_PG_RL_PROD_DATE pg_rl, tm_cfg_prod_date_type cfg where cfg.id = pg_rl.PROD_DATE_TYPE_ID and TM_PG_RL_ID = v.id ) PROD_DATE_TYPE ,(select min(status.description) from TM_CFG_PGM_STATUS status where v.ITEM_STATUS_ID = status.id) PGM_STATUS_TEXT ,(select submed.sub_medium_name from TM_CFG_SUB_MEDIUM submed where v.SUB_MEDIUM_ID = submed.id) SUB_MEDIUM_TEXT, (select cvt.ID from TM_PORTAL_VERSION_CONFIG cvt where v.CUSTOM_VERSION_TYPE = cvt.CUSTOM_VERSION_TYPE AND cvt.CUSTOM_VERSION_TYPE IS NOT NULL ) MP_CONFIG_ID from (select v.*, coalesce(v.primary_thumb_id, (select x.primary_thumb_id from tm_pg_rl x where x.id=v.parent_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.pgm_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs2_id) ) primary_thumb_id2 from tmddba.tm_pg_rl v where v.item_type > 0 and v.rl_deleted = 0) v left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = v.primary_thumb_id2 --sqlIdSearchJoin where 1=1 AND (INSTR(v.OWNERS,'|SFP2|')>0 OR INSTR(v.OWNERS,'|PSP|')>0 OR INSTR(v.OWNERS,'|PMS|')>0 OR INSTR(v.OWNERS,'|SFP1|')>0 OR INSTR(v.OWNERS,'|PMH|')>0 OR INSTR(v.OWNERS,'|PPL|')>0) and v.id in (select x.id from tmddba.tm_pg_rl x start with x.id in ( select a.id from (select m.id, rownum rnum from tmddba.tm_pg_rl m where item_type>0 and rl_deleted=0 and m.PGM_ABS_ID=:param_0 AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0) ) A WHERE rnum>=1 and rnum <= 9999 ) connect by nocycle prior x.parent_id=x.id) t Verbose: 1220 : 12|10:04:37.6570|JdSrZ7|CJPOWERCAST|imfx v3 API took 0.459s '/api/v3/title/299562/versions?_dc=1686819882390' t Transfer: 1220 : 12|10:05:23.8849|8Au2du|CJPOWERCAST|OAuth: /api/settings/user/uploadSettings?_dc=1686819929109 t Transfer: 1220 : 12|10:05:23.8849|8Au2du|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:05:23.8849|8Au2du|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:05:23.8849|8Au2du|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:05:23.8849|8Au2du|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|10:05:23.8849|8Au2du|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:05:23.8849|8Au2du|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:05:23.8859|8Au2du|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:05:23.8859|8Au2du|CJPOWERCAST|imfx v3 API took 0.004s '/api/settings/user/uploadSettings?_dc=1686819929109' t Transfer: 1220 : 12|10:05:28.1299|b9lUsE|CJPOWERCAST|OAuth: /api/v3/version/299563/media?_dc=1686819933299 t Transfer: 1220 : 12|10:05:28.1299|b9lUsE|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:05:28.1299|b9lUsE|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:05:28.1299|b9lUsE|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:05:28.1299|b9lUsE|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|10:05:28.1310|b9lUsE|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|10:05:28.1310|b9lUsE|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:05:28.1310|b9lUsE|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:05:28.1310|b9lUsE|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|10:05:28.1310|b9lUsE|CJPOWERCAST|MediaSearch SQL: --sqlFromPaging select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type in (1,110)),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , (SELECT min(status.ACCESS_STATUS_NAME) FROM TMDDBA.TM_ACCESS_STATUS statusLnx, TM_CFG_ACCESS_STATUS status WHERE statusLnx.Media_Id = r.id and statusLnx.Status_Id = status.id) ACCESS_STATUS , (select min(acq.ext_ref) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) CONSIGNMENT_NUMBER , (select min(acq.alt_id1) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) TRANSFER_NUMBER , (select min(crs.series_number) from tm_series_data crs where crs.id = r.GROUP_SERIES_ID) CRS_SERIES , (select min(DISPOSAL_NAME) from TM_ACQ_DISPOSAL status, tm_disposal_records records where status.id = records.disposal_status_id and records.miid = r.id) DISPOSAL_STATUS , (select min(class.class_number) from TM_ACQ_DISPOSAL status, tm_disposal_records records, tm_disposal_classes class where status.id = records.disposal_status_id and records.miid = r.id and class.id = records.disposal_class_id) DISPOSAL_CLASS, (select min(names.concat_search_name) from tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names where r.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY, (select min(c.u_id_ext1) from tmddba.tm_mi_tpi_lnx lnx, tm_ctnrs c where c.u_id = lnx.tpiid and lnx.miid = r.id) U_ID_EXT1 , (select t.name from TM_CFG_MI_FMT_TYP t where t.id = r.mi_fmt_type) ITEM_FORMAT_TEXT, CASE WHEN BITAND(r.COMPIL, 2) = 2 THEN 'SUPPLIED' WHEN BITAND(r.COMPIL, 4) = 4 THEN 'MADE' WHEN BITAND(r.COMPIL, 134217728) = 134217728 THEN 'IMPORTED' ELSE '' END AS ORIGIN, CASE WHEN BITAND(r.COMPIL, 512) = 512 THEN 'Attached' WHEN BITAND(r.COMPIL, 1024) = 1024 THEN 'Un-Attached' ELSE '' END AS FLAGS, (select min(lang.full_name) from TM_PG_RL_LANG_LNX lnx, TM_LANG_DATA lang where lnx.tm_pg_rl_id = r.pgm_parent_id and lnx.lang_id = lang.id) AS PROD_LANGUAGE , (select min(ctx.ITFC_CODE) from tm_mis mis, tm_mi_tpi_lnx links, tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names where mis.id = r.id and links.miid = mis.id and mis.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY_NUMBER, (select min(status.description) from TM_CFG_PGM_STATUS status where r.status = status.id) PGM_STATUS_TEXT, (select min(ver.DUR) from TM_PG_RL ver where r.pgm_PARENT_ID = ver.id) AS VERSION_DUR , (select tmd_str_agg_pipe(cms.status_type_id ||',' ||cms.status_id) from tm_mi_cust_med_stat_lnx cms where cms.media_id=r.id) "CustomStatusesRaw", (select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = r.net_grp_id) CHANNEL_GROUP, (SELECT SUBSTR( trim( replace (replace ( LISTAGG(trim(tt.tags || ' ' || tt.notes), ' ') WITHIN GROUP (ORDER BY trim(tt.tags || ' ' || tt.notes)), chr (13), ''), chr (10), ' ')), 1, 150) z FROM tm_media_tagging tt WHERE link_guid = DFILE_LINK_GUID and rownum=1) TAGS_TEXT , GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select t.*, coalesce(t.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=t.pgm_parent_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.pgm_abs_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs2_id) ) primary_thumb_id2 from ( --sqlSubSelect select s.* from (select a.*, rownum rnum from (select --sqlFrom m.* from tmddba.tm_mis m --sqlWhere where media_type>0 and item_type>0 AND PGM_PARENT_ID=:param_0 and m.mi_deleted=0 AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0) order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) s where rnum >= 1) t ) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl order by r.rnum t Verbose: 1220 : 12|10:05:28.1310|b9lUsE|CJPOWERCAST|Alternative title fields query: select * from (select x.id,x.pgm_abs_id TitleId, x.pgm_parent_id VersionId from tm_mis x where id in (select /*+ cardinality(4) */ column_value id from table(:ids))) y,lateral (select dbms_lob.substr( o.text_data_plain, 1000, 1 ) Field_5799344 from tm_txt_obj o where (o.pgm_abs_id=y.TitleId or o.pgm_rl_id = y.VersionId) and o.type_id=:param_1 order by o.id desc fetch first 1 rows only)(+) t Information: 1220 : 12|10:05:28.1310|b9lUsE|CJPOWERCAST| timing: 00:00:00.0266710 t Verbose: 1220 : 12|10:05:28.1310|b9lUsE|CJPOWERCAST|imfx v3 API took 0.027s '/api/v3/version/299563/media?_dc=1686819933299' t Transfer: 1220 : 12|10:05:28.1320|b9lUsE|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0013.mp4 subfolder t Transfer: 1220 : 12|10:05:28.1320|b9lUsE|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0013.mp4 t Transfer: 1220 : 12|10:05:28.1320|b9lUsE|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0013.mp4 t Transfer: 1220 : 12|10:05:28.1320|b9lUsE|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:05:28.1320|b9lUsE|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:05:28.1320|b9lUsE|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|10:05:28.1320|b9lUsE|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001993.mp4 subfolder t Transfer: 1220 : 12|10:05:28.1320|b9lUsE|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001993.mp4 t Transfer: 1220 : 12|10:05:28.1320|b9lUsE|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001993.mp4 t Transfer: 1220 : 12|10:05:28.1320|b9lUsE|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:05:28.1320|b9lUsE|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:05:28.1330|b9lUsE|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|10:05:28.1330|b9lUsE|CJPOWERCAST|GetUrl. Storage |Temp Storage| filename C:\TEMP\GOPR0013.mp4 subfolder t Transfer: 1220 : 12|10:05:28.1330|b9lUsE|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:05:28.1330|b9lUsE|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:05:28.1330|b9lUsE|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|10:05:28.1330|b9lUsE|CJPOWERCAST|GetUrl. Storage |Temp Storage| filename C:\TEMP\N0001993.mp4 subfolder t Transfer: 1220 : 12|10:05:28.1330|b9lUsE|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:05:28.1330|b9lUsE|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:05:28.1330|b9lUsE|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|10:05:29.5399|IiVivM|CJPOWERCAST|OAuth: /api/settings/user/uploadSettings?_dc=1686819934734 t Transfer: 1220 : 12|10:05:29.5399|IiVivM|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:05:29.5399|IiVivM|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:05:29.5399|IiVivM|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:05:29.5399|IiVivM|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|10:05:29.5399|IiVivM|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:05:29.5399|IiVivM|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:05:29.5399|IiVivM|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:05:29.5409|IiVivM|CJPOWERCAST|imfx v3 API took 0.003s '/api/settings/user/uploadSettings?_dc=1686819934734' t Transfer: 1220 : 12|10:05:29.5409|okRqOf|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:05:29.5409|okRqOf|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:05:29.5409|okRqOf|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|10:05:55.0719|an2U9I|CJPOWERCAST|OAuth: /api/v3/checkFilesExist?_dc=1686819960292 t Transfer: 1220 : 12|10:05:55.0719|an2U9I|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:05:55.0719|an2U9I|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:05:55.0719|an2U9I|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:05:55.0719|an2U9I|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 12|10:05:55.0719|an2U9I|CJPOWERCAST|imfx v3 API took 0.005s '/api/v3/checkFilesExist?_dc=1686819960292' t Information: 1220 : 12|20:42:44.9844|||OrabitWatcherBasic. Disposing. t Information: 1220 : 12|20:42:44.9844|||OrabitWatcherBasic. Disposed. t Information: 1220 : 12|20:42:44.9844|||========================================================================== t Information: 1220 : 12|20:42:44.9844|||IMFX CORE SERVER APPLICATION END.