t Transfer: 1220 : 10|05:04:28.0650|2aTC7N||GetAppInfo. DB: TMDDEMO. Install mode: . Auth types: Native, PublicApiKey t Information: 1220 : 10|05:04:28.4670|Pwg82y||GetCache. t Information: 1220 : 10|05:04:28.4670|Pwg82y||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\108_2_PnqJC_.png t Information: 1220 : 10|05:04:28.4670|Pwg82y||GetCache. Data read: 154944 t Verbose: 1220 : 10|05:04:28.4670|Pwg82y||imfx v3 API took 0.063s '/api/v3/visual-asset/group/PnqJC_/2/image' t Transfer: 1220 : 10|07:58:35.6449|C4o4tz||GetAppInfo. DB: TMDDEMO. Install mode: . Auth types: Native, PublicApiKey t Information: 1220 : 10|07:58:35.8469|MMLNMs||GetCache. t Information: 1220 : 10|07:58:35.8469|MMLNMs||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\108_2_PnqJC_.png t Information: 1220 : 10|07:58:35.8469|MMLNMs||GetCache. Data read: 154944 t Verbose: 1220 : 10|07:58:35.8469|MMLNMs||imfx v3 API took 0.005s '/api/v3/visual-asset/group/PnqJC_/2/image' t Transfer: 1220 : 10|09:17:35.0317|4DFFZg||OAuth: /api/logout?_dc=1672046264398 t Transfer: 1220 : 10|09:17:35.0317|4DFFZg||GetCurrentUser.. t Transfer: 1220 : 10|09:17:35.0317|4DFFZg|| OAuth authenticated t Verbose: 1220 : 10|09:17:35.0317|4DFFZg|| uid claim is missing.. t Information: 1220 : 10|09:17:35.0317|4DFFZg||OAuth. AutoLogin no Windows identity type WindowsIdentity t Transfer: 1220 : 10|09:17:35.4337|y0KARo||GetAppInfo. DB: TMDDEMO. Install mode: . Auth types: Native, PublicApiKey t Information: 1220 : 10|09:17:35.8357|xN69cc||GetCache. t Information: 1220 : 10|09:17:35.8357|xN69cc||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\108_2_PnqJC_.png t Information: 1220 : 10|09:17:35.8357|xN69cc||GetCache. Data read: 154944 t Verbose: 1220 : 10|09:17:35.8357|xN69cc||imfx v3 API took 0.006s '/api/v3/visual-asset/group/PnqJC_/2/image' t Verbose: 1220 : 10|09:17:47.0918|SmaEbT||Oauth validating.. t Verbose: 1220 : 10|09:17:47.0918|SmaEbT||GrantResourceOwnerCredentials. t Verbose: 1220 : 10|09:17:47.0918|SmaEbT||LoginUser. cjpowercast, login type OAuth, encrypt password True t Information: 1220 : 10|09:17:47.0918|SmaEbT||TryLoginUser. cjpowercast, login type OAuth, check password True, check hash False, encrypt password True, load user data False t Information: 1220 : 10|09:17:47.4937|SmaEbT|| oauth token 00000000-0000-0000-0000-000000000000 t Information: 1220 : 10|09:17:47.4937|SmaEbT||TryLoginUser. Logged in.. t Information: 1220 : 10|09:17:47.4937|SmaEbT||GetPasswordPolicy. WARNING: Policy not found for system Imediaflex. Validation disabled. t Verbose: 1220 : 10|09:17:47.4937|SmaEbT||LoginUser. Adding history. User Id 1165, result CJPOWERCAST, host 192.168.127.6 t Verbose: 1220 : 10|09:17:47.4937|SmaEbT||GrantResourceOwnerCredentials. Try login finished. Logged: True t Transfer: 1220 : 10|09:17:47.8957|cYb~ep|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=1672046277270 t Transfer: 1220 : 10|09:17:47.8957|cYb~ep|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:17:47.8957|cYb~ep|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:17:47.8957|cYb~ep|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:17:47.8957|cYb~ep|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|09:17:47.8957|cYb~ep|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:17:47.8957|cYb~ep|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:17:47.8957|cYb~ep|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:17:47.8968|cYb~ep|CJPOWERCAST|imfx v3 API took 0.043s '/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=1672046277270' t Transfer: 1220 : 10|09:17:48.2987|BOfrni|CJPOWERCAST|OAuth: /api/user-preferences?keys=personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch;workflow_queues_actions;workflow_queues_settings&_dc=1672046277621 t Transfer: 1220 : 10|09:17:48.2987|BOfrni|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:17:48.2987|BOfrni|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:17:48.2987|BOfrni|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:17:48.2987|BOfrni|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|09:17:48.2987|BOfrni|CJPOWERCAST|GetUserDataByKeys: personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch;workflow_queues_actions;workflow_queues_settings t Transfer: 1220 : 10|09:17:48.2987|BOfrni|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:17:48.2987|BOfrni|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:17:48.2987|BOfrni|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:17:48.2987|BOfrni|CJPOWERCAST|imfx v3 API took 0.040s '/api/user-preferences?keys=personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch;workflow_queues_actions;workflow_queues_settings&_dc=1672046277621' t Information: 1220 : 10|09:17:48.5008|vQcqau|CJPOWERCAST|GetUserProfile. Id: 0 t Transfer: 1220 : 10|09:17:48.5008|vQcqau|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:17:48.5008|vQcqau|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:17:48.5008|vQcqau|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:17:48.9027|xAVvZs|CJPOWERCAST|OAuth: /api/settings/group/0?_dc=1672046278341 t Transfer: 1220 : 10|09:17:48.9027|xAVvZs|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:17:48.9027|xAVvZs|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:17:48.9027|xAVvZs|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:17:48.9027|xAVvZs|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|09:17:48.9027|4cjJhz|CJPOWERCAST|OAuth: /api/settings/user/uploadSettings?_dc=1672046278353 t Transfer: 1220 : 10|09:17:48.9027|4cjJhz|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:17:48.9027|4cjJhz|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:17:48.9027|4cjJhz|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:17:48.9027|4cjJhz|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|09:17:48.9038|4cjJhz|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:17:48.9038|4cjJhz|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:17:48.9038|4cjJhz|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:17:48.9038|4cjJhz|CJPOWERCAST|imfx v3 API took 0.010s '/api/settings/user/uploadSettings?_dc=1672046278353' t Transfer: 1220 : 10|09:17:48.9038|Gqcnc1|CJPOWERCAST|OAuth: /api/settings/group/0?_dc=1672046278383 t Transfer: 1220 : 10|09:17:48.9038|Gqcnc1|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:17:48.9038|Gqcnc1|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:17:48.9038|Gqcnc1|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:17:48.9038|Gqcnc1|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|09:17:49.1047|4yMW~3|CJPOWERCAST|OAuth: /api/lookups/MediaStatus?_dc=1672046278398 t Transfer: 1220 : 10|09:17:49.1047|4yMW~3|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:17:49.1047|4yMW~3|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:17:49.1047|4yMW~3|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:17:49.1047|4yMW~3|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|09:17:49.1047|85aPEC||GetCache. t Information: 1220 : 10|09:17:49.1047|85aPEC||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\201_0_Any_gO.png t Information: 1220 : 10|09:17:49.1047|85aPEC||GetCache. Data read: 0 t Verbose: 1220 : 10|09:17:49.1047|85aPEC||imfx v3 API took 0.112s '/api/v3/visual-asset/group/Any_gO/0/image' t Verbose: 1220 : 10|09:17:49.1047|4yMW~3|CJPOWERCAST|imfx v3 API took 0.038s '/api/lookups/MediaStatus?_dc=1672046278398' t Transfer: 1220 : 10|09:17:49.3067|0bCgHR|CJPOWERCAST|OAuth: /api/lookups/PgmStatus?_dc=1672046278399 t Transfer: 1220 : 10|09:17:49.3067|0bCgHR|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:17:49.3067|0bCgHR|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:17:49.3067|0bCgHR|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:17:49.3067|0bCgHR|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 10|09:17:49.3067|0bCgHR|CJPOWERCAST|imfx v3 API took 0.000s '/api/lookups/PgmStatus?_dc=1672046278399' t Verbose: 1220 : 10|09:17:49.3067|Gqcnc1|CJPOWERCAST|imfx v3 API took 0.272s '/api/settings/group/0?_dc=1672046278383' t Verbose: 1220 : 10|09:17:49.3067|xAVvZs|CJPOWERCAST|imfx v3 API took 0.397s '/api/settings/group/0?_dc=1672046278341' t Transfer: 1220 : 10|09:17:49.5077|yi~kw1|CJPOWERCAST|OAuth: /api/lookup/CustomMediaStatusTypes?_dc=1672046278400 t Transfer: 1220 : 10|09:17:49.5077|yi~kw1|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:17:49.5077|yi~kw1|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:17:49.5077|yi~kw1|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:17:49.5077|yi~kw1|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 10|09:17:49.5077|yi~kw1|CJPOWERCAST|imfx v3 API took 0.013s '/api/lookup/CustomMediaStatusTypes?_dc=1672046278400' t Transfer: 1220 : 10|09:17:49.5077|5thhbx|CJPOWERCAST|OAuth: /api/lookup/CustomVersionStatusTypes?_dc=1672046278401 t Transfer: 1220 : 10|09:17:49.5077|5thhbx|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:17:49.5077|5thhbx|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:17:49.5077|5thhbx|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:17:49.5087|5thhbx|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 10|09:17:49.5087|5thhbx|CJPOWERCAST|imfx v3 API took 0.009s '/api/lookup/CustomVersionStatusTypes?_dc=1672046278401' t Transfer: 1220 : 10|09:17:49.5087|58oamd|CJPOWERCAST|OAuth: /api/lookup/CustomTitleStatusTypes?_dc=1672046278402 t Transfer: 1220 : 10|09:17:49.5087|58oamd|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:17:49.5087|58oamd|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:17:49.5087|58oamd|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:17:49.5087|58oamd|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 10|09:17:49.5087|58oamd|CJPOWERCAST|imfx v3 API took 0.007s '/api/lookup/CustomTitleStatusTypes?_dc=1672046278402' t Transfer: 1220 : 10|09:17:49.5087|ZRBSmT|CJPOWERCAST|OAuth: /api/settings/user/defaultHomePage?_dc=1672046278404 t Transfer: 1220 : 10|09:17:49.5087|ZRBSmT|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:17:49.5087|ZRBSmT|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:17:49.5087|ZRBSmT|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:17:49.5097|ZRBSmT|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|09:17:49.5097|ZRBSmT|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:17:49.5097|ZRBSmT|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:17:49.5097|ZRBSmT|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:17:49.5097|ZRBSmT|CJPOWERCAST|imfx v3 API took 0.015s '/api/settings/user/defaultHomePage?_dc=1672046278404' t Information: 1220 : 10|09:17:49.7107|HgPYI5||GetCache. t Information: 1220 : 10|09:17:49.7107|HgPYI5||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\202_1_Any_gO.png t Information: 1220 : 10|09:17:49.7107|HgPYI5||GetCache. Data read: 0 t Verbose: 1220 : 10|09:17:49.7107|HgPYI5||imfx v3 API took 0.004s '/api/v3/visual-asset/group/Any_gO/1/image' t Transfer: 1220 : 10|09:17:51.5197|n__Cpu|CJPOWERCAST|OAuth: /api/settings/user/startSearch?_dc=1672046280836 t Transfer: 1220 : 10|09:17:51.5197|n__Cpu|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:17:51.5197|n__Cpu|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:17:51.5197|n__Cpu|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:17:51.5197|n__Cpu|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|09:17:51.5197|2K2LQ7|CJPOWERCAST|OAuth: /api/settings/user/defaultSearch?_dc=1672046280836 t Transfer: 1220 : 10|09:17:51.5197|2K2LQ7|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:17:51.5197|2K2LQ7|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:17:51.5197|2K2LQ7|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:17:51.5207|2K2LQ7|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|09:17:51.5207|n__Cpu|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:17:51.5207|n__Cpu|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:17:51.5207|n__Cpu|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:17:51.5207|2K2LQ7|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:17:51.5207|2K2LQ7|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:17:51.5207|2K2LQ7|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:17:51.5207|n__Cpu|CJPOWERCAST|imfx v3 API took 0.009s '/api/settings/user/startSearch?_dc=1672046280836' t Verbose: 1220 : 10|09:17:51.5207|2K2LQ7|CJPOWERCAST|imfx v3 API took 0.009s '/api/settings/user/defaultSearch?_dc=1672046280836' t Information: 1220 : 10|09:17:51.7217|NSUeJ5||GetCache. t Information: 1220 : 10|09:17:51.7217|NSUeJ5||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\204_3_Any_gO.png t Information: 1220 : 10|09:17:51.7217|NSUeJ5||GetCache. Data read: 5504 t Verbose: 1220 : 10|09:17:51.7217|NSUeJ5||imfx v3 API took 0.004s '/api/v3/visual-asset/group/Any_gO/3/image' t Transfer: 1220 : 10|09:17:51.7217|PQqZ8r|CJPOWERCAST|OAuth: /api/user-preferences?keys=consumer.recent.data&_dc=1672046281177 t Transfer: 1220 : 10|09:17:51.7217|PQqZ8r|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:17:51.7217|PQqZ8r|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:17:51.7217|PQqZ8r|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:17:51.7217|PQqZ8r|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|09:17:51.7217|PQqZ8r|CJPOWERCAST|GetUserDataByKeys: consumer.recent.data t Transfer: 1220 : 10|09:17:51.7227|PQqZ8r|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:17:51.7227|PQqZ8r|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:17:51.7227|PQqZ8r|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:17:51.7227|GXxXTF|CJPOWERCAST|OAuth: /api/user-preferences?keys=adv.recent.searches.consumer&_dc=1672046281190 t Transfer: 1220 : 10|09:17:51.7227|GXxXTF|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:17:51.7227|GXxXTF|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:17:51.7227|GXxXTF|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:17:51.7227|GXxXTF|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|09:17:51.7227|GXxXTF|CJPOWERCAST|GetUserDataByKeys: adv.recent.searches.consumer t Transfer: 1220 : 10|09:17:51.7227|GXxXTF|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:17:51.7227|GXxXTF|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:17:51.7237|GXxXTF|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:17:51.9247|PQqZ8r|CJPOWERCAST|imfx v3 API took 0.013s '/api/user-preferences?keys=consumer.recent.data&_dc=1672046281177' t Verbose: 1220 : 10|09:17:51.9247|GXxXTF|CJPOWERCAST|imfx v3 API took 0.009s '/api/user-preferences?keys=adv.recent.searches.consumer&_dc=1672046281190' t Transfer: 1220 : 10|09:18:01.7737|cZabv1|CJPOWERCAST|OAuth: /api/lookups/SearchSupportedOperators?_dc=1672046291209 t Transfer: 1220 : 10|09:18:01.7737|cZabv1|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:18:01.7737|cZabv1|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:18:01.7737|cZabv1|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:18:01.7737|cZabv1|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|09:18:01.7737|OuKuZS|CJPOWERCAST|OAuth: /api/view/searchinfo/TitleSearch?_dc=1672046291206 t Transfer: 1220 : 10|09:18:01.7737|OuKuZS|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:18:01.7737|OuKuZS|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:18:01.7737|OuKuZS|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:18:01.7747|OuKuZS|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 10|09:18:01.7747|cZabv1|CJPOWERCAST|imfx v3 API took 0.000s '/api/lookups/SearchSupportedOperators?_dc=1672046291209' t Transfer: 1220 : 10|09:18:01.7747|bD135L|CJPOWERCAST|OAuth: /api/user-preferences?keys=adv.recent.searches.titles&_dc=1672046291215 t Transfer: 1220 : 10|09:18:01.7747|bD135L|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:18:01.7747|bD135L|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:18:01.7747|bD135L|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:18:01.7747|bD135L|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|09:18:01.7747|bD135L|CJPOWERCAST|GetUserDataByKeys: adv.recent.searches.titles t Transfer: 1220 : 10|09:18:01.7747|bD135L|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:18:01.7747|bD135L|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:18:01.7747|bD135L|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|09:18:01.7747|OuKuZS|CJPOWERCAST|GetAdvSearchColumns. search type TitleSearch grid . t Verbose: 1220 : 10|09:18:01.7757|OuKuZS|CJPOWERCAST|imfx v3 API took 0.002s '/api/view/searchinfo/TitleSearch?_dc=1672046291206' t Verbose: 1220 : 10|09:18:01.7757|bD135L|CJPOWERCAST|imfx v3 API took 0.005s '/api/user-preferences?keys=adv.recent.searches.titles&_dc=1672046291215' t Transfer: 1220 : 10|09:18:01.9767|zdOK8s|CJPOWERCAST|OAuth: /api/view/searches/TitleSearch?_dc=1672046291358 t Transfer: 1220 : 10|09:18:01.9767|zdOK8s|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:18:01.9767|zdOK8s|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:18:01.9767|zdOK8s|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:18:01.9767|zdOK8s|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|09:18:01.9767|zdOK8s|CJPOWERCAST|GetSavedSearchNames. search type TitleSearch. t Transfer: 1220 : 10|09:18:01.9767|zdOK8s|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:18:01.9767|zdOK8s|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:18:01.9767|zdOK8s|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:18:01.9777|zdOK8s|CJPOWERCAST|imfx v3 API took 0.038s '/api/view/searches/TitleSearch?_dc=1672046291358' t Transfer: 1220 : 10|09:18:02.1787|GESjwJ|CJPOWERCAST|OAuth: /api/view/info/VersionGrid?lang=hr-CRO&_dc=1672046291394 t Transfer: 1220 : 10|09:18:02.1787|GESjwJ|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:18:02.1787|GESjwJ|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:18:02.1787|GESjwJ|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:18:02.1787|GESjwJ|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|09:18:02.1787|GESjwJ|CJPOWERCAST|GetGridViewBuilder. builder type VersionGrid. t Transfer: 1220 : 10|09:18:02.1787|GESjwJ|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:18:02.1787|GESjwJ|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:18:02.1787|GESjwJ|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|09:18:02.1797|GESjwJ|CJPOWERCAST|UserGridView. LoadView. ID -2, Name Default. t Transfer: 1220 : 10|09:18:02.1797|GESjwJ|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:18:02.1797|GESjwJ|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:18:02.1797|GESjwJ|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:18:02.1797|GESjwJ|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:18:02.1797|GESjwJ|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:18:02.1797|GESjwJ|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:18:02.1797|GESjwJ|CJPOWERCAST|imfx v3 API took 0.117s '/api/view/info/VersionGrid?lang=hr-CRO&_dc=1672046291394' t Transfer: 1220 : 10|09:18:02.3807|yWsnis|CJPOWERCAST|OAuth: /api/view/info/MediaGrid?lang=hr-CRO&_dc=1672046291497 t Transfer: 1220 : 10|09:18:02.3807|yWsnis|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:18:02.3807|yWsnis|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:18:02.3807|yWsnis|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:18:02.3807|yWsnis|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|09:18:02.3807|yWsnis|CJPOWERCAST|GetGridViewBuilder. builder type MediaGrid. t Transfer: 1220 : 10|09:18:02.3807|yWsnis|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:18:02.3807|yWsnis|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:18:02.3807|yWsnis|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|09:18:02.3807|yWsnis|CJPOWERCAST|UserGridView. LoadView. ID -2, Name Default. t Transfer: 1220 : 10|09:18:02.3817|yWsnis|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:18:02.3817|yWsnis|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:18:02.3817|yWsnis|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:18:02.3817|yWsnis|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:18:02.3817|yWsnis|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:18:02.3817|yWsnis|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:18:02.3817|yWsnis|CJPOWERCAST|imfx v3 API took 0.007s '/api/view/info/MediaGrid?lang=hr-CRO&_dc=1672046291497' t Transfer: 1220 : 10|09:18:02.3817|YlXTGQ|CJPOWERCAST|OAuth: /api/view/info/DigitalCarriers?lang=hr-CRO&_dc=1672046291564 t Transfer: 1220 : 10|09:18:02.3817|YlXTGQ|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:18:02.3817|YlXTGQ|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:18:02.3817|YlXTGQ|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:18:02.3817|YlXTGQ|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|09:18:02.3827|YlXTGQ|CJPOWERCAST|GetGridViewBuilder. builder type DigitalCarriers. t Transfer: 1220 : 10|09:18:02.3827|YlXTGQ|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:18:02.3827|YlXTGQ|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:18:02.3827|YlXTGQ|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:18:02.3827|mWsOxv|CJPOWERCAST|OAuth: /api/view/info/TitleTree?lang=hr-CRO&_dc=1672046291621 t Transfer: 1220 : 10|09:18:02.3827|mWsOxv|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:18:02.3827|mWsOxv|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:18:02.3827|mWsOxv|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:18:02.3827|mWsOxv|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|09:18:02.3827|YlXTGQ|CJPOWERCAST|UserGridView. LoadView. ID -2, Name Default. t Transfer: 1220 : 10|09:18:02.3827|YlXTGQ|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:18:02.3827|YlXTGQ|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:18:02.3837|YlXTGQ|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|09:18:02.3837|mWsOxv|CJPOWERCAST|GetGridViewBuilder. builder type TitleTree. t Transfer: 1220 : 10|09:18:02.3837|mWsOxv|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:18:02.3837|mWsOxv|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:18:02.3837|mWsOxv|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:18:02.3837|YlXTGQ|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:18:02.3837|YlXTGQ|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:18:02.3837|YlXTGQ|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|09:18:02.3837|mWsOxv|CJPOWERCAST|UserGridView. LoadView. ID -2, Name Default. t Transfer: 1220 : 10|09:18:02.3837|mWsOxv|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:18:02.3837|mWsOxv|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:18:02.3837|mWsOxv|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:18:02.3837|YlXTGQ|CJPOWERCAST|imfx v3 API took 0.007s '/api/view/info/DigitalCarriers?lang=hr-CRO&_dc=1672046291564' t Transfer: 1220 : 10|09:18:02.3847|mWsOxv|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:18:02.3847|mWsOxv|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:18:02.3847|mWsOxv|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:18:02.3847|mWsOxv|CJPOWERCAST|imfx v3 API took 0.007s '/api/view/info/TitleTree?lang=hr-CRO&_dc=1672046291621' t Transfer: 1220 : 10|09:18:16.0527|pCSbYp|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1672046305417 t Transfer: 1220 : 10|09:18:16.0527|pCSbYp|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:18:16.0527|pCSbYp|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:18:16.0527|pCSbYp|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:18:16.0527|pCSbYp|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|09:18:16.0527|pCSbYp|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:18:16.0537|pCSbYp|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:18:16.0537|pCSbYp|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:18:16.0537|rJQiMg|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1672046305520 t Transfer: 1220 : 10|09:18:16.0537|rJQiMg|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:18:16.0537|rJQiMg|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:18:16.0537|rJQiMg|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:18:16.0537|rJQiMg|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|09:18:16.0547|rJQiMg|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:18:16.0547|rJQiMg|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:18:16.0547|rJQiMg|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:18:16.2577|afy1w3|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1672046305597 t Transfer: 1220 : 10|09:18:16.2577|afy1w3|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:18:16.2577|afy1w3|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:18:16.2577|afy1w3|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:18:16.2587|afy1w3|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|09:18:16.2587|afy1w3|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:18:16.2587|afy1w3|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:18:16.2587|afy1w3|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:18:16.8647|rJQiMg|CJPOWERCAST|imfx v3 API took 0.638s '/api/v3/search-suggestion/?_dc=1672046305520' t Verbose: 1220 : 10|09:18:16.8647|afy1w3|CJPOWERCAST|imfx v3 API took 0.528s '/api/v3/search-suggestion/?_dc=1672046305597' t Verbose: 1220 : 10|09:18:16.8647|pCSbYp|CJPOWERCAST|imfx v3 API took 0.667s '/api/v3/search-suggestion/?_dc=1672046305417' t Transfer: 1220 : 10|09:18:18.8747|aoW9XK|CJPOWERCAST|OAuth: /api/v3/search/title?_dc=1672046308235 t Transfer: 1220 : 10|09:18:18.8747|aoW9XK|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:18:18.8747|aoW9XK|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:18:18.8747|aoW9XK|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:18:18.8747|aoW9XK|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|09:18:18.8747|aoW9XK|CJPOWERCAST|V3Api.SearchTitles t Information: 1220 : 10|09:18:18.8747|aoW9XK|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 10|09:18:19.0757|aoW9XK|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:18:19.0757|aoW9XK|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:18:19.0757|aoW9XK|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|09:18:19.0757|aoW9XK|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 : 10|09:18:19.2767|aoW9XK|CJPOWERCAST|imfx v3 API took 0.216s '/api/v3/search/title?_dc=1672046308235' t Transfer: 1220 : 10|09:18:19.6787|oXNzYd|CJPOWERCAST|OAuth: /api/v3/title/299390/versions?_dc=1672046308986 t Transfer: 1220 : 10|09:18:19.6787|oXNzYd|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:18:19.6787|oXNzYd|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:18:19.6787|oXNzYd|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:18:19.6787|oXNzYd|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|09:18:19.6787|0sIXuk|CJPOWERCAST|OAuth: /api/user-preferences?_dc=1672046308993 t Transfer: 1220 : 10|09:18:19.6787|0sIXuk|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:18:19.6787|0sIXuk|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:18:19.6797|0sIXuk|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:18:19.6797|0sIXuk|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|09:18:19.6797|oXNzYd|CJPOWERCAST|V3Api.SearchGeneric t Verbose: 1220 : 10|09:18:19.6797|0sIXuk|CJPOWERCAST|StoreUserDataByKeys.. t Transfer: 1220 : 10|09:18:19.6797|0sIXuk|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:18:19.6797|0sIXuk|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:18:19.6797|0sIXuk|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:18:19.6797|oXNzYd|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:18:19.6797|oXNzYd|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:18:19.6797|oXNzYd|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:18:19.6797|oXNzYd|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:18:19.6797|oXNzYd|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:18:19.6797|oXNzYd|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:18:19.6807|oXNzYd|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:18:19.6807|oXNzYd|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:18:19.6807|oXNzYd|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|09:18:19.6807|oXNzYd|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 tmddba.tm_pg_rl 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_id --sqlIdSearchJoin where v.item_type>0 and v.rl_deleted=0 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 : 10|09:18:19.6807|oXNzYd|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:18:19.6807|oXNzYd|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:18:19.6807|oXNzYd|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:18:19.6807|0sIXuk|CJPOWERCAST|imfx v3 API took 0.030s '/api/user-preferences?_dc=1672046308993' t Information: 1220 : 10|09:18:19.6807|oXNzYd|CJPOWERCAST|Running version search. User: 1165 Simple Search: Running Oracle search. Running Oracle search for COUNT Oracle count completed in: 34ms. Returned lines: 0 t Verbose: 1220 : 10|09:18:19.6807|oXNzYd|CJPOWERCAST|imfx v3 API took 0.069s '/api/v3/title/299390/versions?_dc=1672046308986' t Transfer: 1220 : 10|09:18:21.4897|rMz2xP|CJPOWERCAST|OAuth: /api/v3/title/299562/versions?_dc=1672046310803 t Transfer: 1220 : 10|09:18:21.4897|rMz2xP|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:18:21.4897|rMz2xP|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:18:21.4897|rMz2xP|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:18:21.4897|rMz2xP|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|09:18:21.4897|rMz2xP|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 10|09:18:21.4897|rMz2xP|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:18:21.4897|rMz2xP|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:18:21.4897|rMz2xP|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:18:21.4897|rMz2xP|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:18:21.4907|rMz2xP|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:18:21.4907|rMz2xP|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:18:21.4907|rMz2xP|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:18:21.4907|rMz2xP|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:18:21.4907|rMz2xP|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|09:18:21.4907|rMz2xP|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 tmddba.tm_pg_rl 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_id --sqlIdSearchJoin where v.item_type>0 and v.rl_deleted=0 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 : 10|09:18:21.4907|rMz2xP|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:18:21.4907|rMz2xP|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:18:21.4907|rMz2xP|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|09:18:21.6917|rMz2xP|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: 160ms. 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 tmddba.tm_pg_rl 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_id --sqlIdSearchJoin where v.item_type>0 and v.rl_deleted=0 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 : 10|09:18:21.6917|rMz2xP|CJPOWERCAST|imfx v3 API took 0.173s '/api/v3/title/299562/versions?_dc=1672046310803' t Transfer: 1220 : 10|09:18:22.0937|TpPrtb|CJPOWERCAST|OAuth: /api/v3/version/299563/media?_dc=1672046311468 t Transfer: 1220 : 10|09:18:22.0937|TpPrtb|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:18:22.0937|TpPrtb|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:18:22.0937|TpPrtb|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:18:22.0937|TpPrtb|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|09:18:22.0937|TpPrtb|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 10|09:18:22.0937|Tk_oo9|CJPOWERCAST|OAuth: /api/v3/version/299563/media?_dc=1672046311494 t Transfer: 1220 : 10|09:18:22.0937|Tk_oo9|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:18:22.0937|Tk_oo9|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:18:22.0948|Tk_oo9|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:18:22.0948|Tk_oo9|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|09:18:22.0948|Tk_oo9|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 10|09:18:22.0948|Tk_oo9|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:18:22.0948|Tk_oo9|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:18:22.0948|Tk_oo9|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:18:22.0948|TpPrtb|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:18:22.0948|TpPrtb|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:18:22.0948|TpPrtb|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|09:18:22.0948|Tk_oo9|CJPOWERCAST|MediaSearch SQL: 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 a.*, rownum rnum from (select m.*, coalesce(m.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=m.pgm_parent_id)) primary_thumb_id2 from tmddba.tm_mis m 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) 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 where rnum >= 1 order by rnum t Information: 1220 : 10|09:18:22.0958|TpPrtb|CJPOWERCAST|MediaSearch SQL: 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 a.*, rownum rnum from (select m.*, coalesce(m.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=m.pgm_parent_id)) primary_thumb_id2 from tmddba.tm_mis m 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) 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 where rnum >= 1 order by rnum t Verbose: 1220 : 10|09:18:22.8997|Tk_oo9|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 : 10|09:18:22.8997|TpPrtb|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 : 10|09:18:22.8997|TpPrtb|CJPOWERCAST| timing: 00:00:00.8139016 t Information: 1220 : 10|09:18:22.8997|Tk_oo9|CJPOWERCAST| timing: 00:00:00.8007383 t Verbose: 1220 : 10|09:18:22.8997|TpPrtb|CJPOWERCAST|imfx v3 API took 0.824s '/api/v3/version/299563/media?_dc=1672046311468' t Verbose: 1220 : 10|09:18:22.9007|Tk_oo9|CJPOWERCAST|imfx v3 API took 0.801s '/api/v3/version/299563/media?_dc=1672046311494' t Transfer: 1220 : 10|09:18:23.1017|Tk_oo9|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0013.mp4 subfolder t Transfer: 1220 : 10|09:18:23.1017|TpPrtb|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0013.mp4 subfolder t Transfer: 1220 : 10|09:18:23.1017|Tk_oo9|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0013.mp4 t Transfer: 1220 : 10|09:18:23.1017|Tk_oo9|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0013.mp4 t Transfer: 1220 : 10|09:18:23.1017|Tk_oo9|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:18:23.1017|Tk_oo9|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:18:23.1017|Tk_oo9|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:18:23.1027|TpPrtb|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0013.mp4 t Transfer: 1220 : 10|09:18:23.1027|TpPrtb|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0013.mp4 t Transfer: 1220 : 10|09:18:23.1027|TpPrtb|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:18:23.1027|TpPrtb|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:18:23.1027|TpPrtb|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:18:23.3037|Tk_oo9|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001993.mp4 subfolder t Transfer: 1220 : 10|09:18:23.3037|Tk_oo9|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001993.mp4 t Transfer: 1220 : 10|09:18:23.3037|Tk_oo9|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001993.mp4 t Transfer: 1220 : 10|09:18:23.3037|Tk_oo9|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:18:23.3037|Tk_oo9|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:18:23.3037|Tk_oo9|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:18:23.3037|TpPrtb|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001993.mp4 subfolder t Transfer: 1220 : 10|09:18:23.3037|TpPrtb|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001993.mp4 t Transfer: 1220 : 10|09:18:23.3037|TpPrtb|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001993.mp4 t Transfer: 1220 : 10|09:18:23.3037|TpPrtb|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:18:23.3047|TpPrtb|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:18:23.3047|TpPrtb|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:18:23.3047|Tk_oo9|CJPOWERCAST|GetUrl. Storage |Temp Storage| filename C:\TEMP\GOPR0013.mp4 subfolder t Transfer: 1220 : 10|09:18:23.3047|Tk_oo9|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:18:23.3047|Tk_oo9|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:18:23.3047|Tk_oo9|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:18:23.3047|TpPrtb|CJPOWERCAST|GetUrl. Storage |Temp Storage| filename C:\TEMP\GOPR0013.mp4 subfolder t Transfer: 1220 : 10|09:18:23.3047|TpPrtb|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:18:23.3047|TpPrtb|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:18:23.3047|TpPrtb|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:18:23.3047|Tk_oo9|CJPOWERCAST|GetUrl. Storage |Temp Storage| filename C:\TEMP\N0001993.mp4 subfolder t Transfer: 1220 : 10|09:18:23.3047|Tk_oo9|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:18:23.3047|Tk_oo9|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:18:23.3057|Tk_oo9|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:18:23.3057|TpPrtb|CJPOWERCAST|GetUrl. Storage |Temp Storage| filename C:\TEMP\N0001993.mp4 subfolder t Transfer: 1220 : 10|09:18:23.3057|TpPrtb|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:18:23.3057|TpPrtb|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:18:23.3057|TpPrtb|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:18:23.5067|StlnhV|CJPOWERCAST|OAuth: /api/v3/media/299528/carriers/digital?_dc=1672046312913 t Transfer: 1220 : 10|09:18:23.5067|StlnhV|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:18:23.5067|StlnhV|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:18:23.5067|StlnhV|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:18:23.5067|StlnhV|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|09:18:23.5067|StlnhV|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 10|09:18:23.5067|StlnhV|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:18:23.5067|StlnhV|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:18:23.5077|StlnhV|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:18:23.5077|StlnhV|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:18:23.5077|StlnhV|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:18:23.5077|StlnhV|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|09:18:23.7087|StlnhV|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 Transfer: 1220 : 10|09:18:23.9147|P3mEAa|CJPOWERCAST|OAuth: /api/v3/media/299528/carriers/digital?_dc=1672046313242 t Transfer: 1220 : 10|09:18:23.9147|P3mEAa|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:18:23.9147|P3mEAa|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:18:23.9147|P3mEAa|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:18:23.9147|P3mEAa|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|09:18:23.9147|P3mEAa|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 10|09:18:23.9157|P3mEAa|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:18:23.9157|P3mEAa|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:18:23.9157|P3mEAa|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:18:23.9157|P3mEAa|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:18:23.9157|P3mEAa|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:18:23.9157|P3mEAa|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|09:18:23.9157|P3mEAa|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 : 10|09:18:23.9157|P3mEAa|CJPOWERCAST|imfx v3 API took 0.097s '/api/v3/media/299528/carriers/digital?_dc=1672046313242' t Verbose: 1220 : 10|09:18:23.9157|StlnhV|CJPOWERCAST|imfx v3 API took 0.430s '/api/v3/media/299528/carriers/digital?_dc=1672046312913' t Transfer: 1220 : 10|09:18:57.4827|5Ys6hi|CJPOWERCAST|OAuth: /api/settings/user/startSearch?_dc=1672046346867 t Transfer: 1220 : 10|09:18:57.4827|5Ys6hi|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:18:57.4827|5Ys6hi|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:18:57.4827|5Ys6hi|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:18:57.4827|5Ys6hi|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|09:18:57.4827|wxemXo|CJPOWERCAST|OAuth: /api/settings/user/defaultSearch?_dc=1672046346866 t Transfer: 1220 : 10|09:18:57.4827|wxemXo|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:18:57.4827|wxemXo|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:18:57.4827|wxemXo|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:18:57.4827|wxemXo|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|09:18:57.4837|5Ys6hi|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:18:57.4837|5Ys6hi|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:18:57.4837|5Ys6hi|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:18:57.4837|wxemXo|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:18:57.4837|wxemXo|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:18:57.4837|wxemXo|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:18:57.4837|wxemXo|CJPOWERCAST|imfx v3 API took 0.004s '/api/settings/user/defaultSearch?_dc=1672046346866' t Verbose: 1220 : 10|09:18:57.4837|5Ys6hi|CJPOWERCAST|imfx v3 API took 0.005s '/api/settings/user/startSearch?_dc=1672046346867' t Transfer: 1220 : 10|09:18:57.8857|4kYya3|CJPOWERCAST|OAuth: /api/user-preferences?keys=consumer.recent.data&_dc=1672046347202 t Transfer: 1220 : 10|09:18:57.8857|4kYya3|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:18:57.8857|4kYya3|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:18:57.8857|4kYya3|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:18:57.8857|4kYya3|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 10|09:18:57.8857|4C387D||imfx v3 API took 0.004s '/api/v3/visual-asset/group/Any_gO/3/image' t Information: 1220 : 10|09:18:57.8857|4kYya3|CJPOWERCAST|GetUserDataByKeys: consumer.recent.data t Transfer: 1220 : 10|09:18:57.8857|4kYya3|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:18:57.8857|4kYya3|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:18:57.8857|4kYya3|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:18:57.8867|4kYya3|CJPOWERCAST|imfx v3 API took 0.006s '/api/user-preferences?keys=consumer.recent.data&_dc=1672046347202' t Transfer: 1220 : 10|09:18:57.8867|ef7vSq|CJPOWERCAST|OAuth: /api/user-preferences?keys=adv.recent.searches.consumer&_dc=1672046347204 t Transfer: 1220 : 10|09:18:57.8867|ef7vSq|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:18:57.8867|ef7vSq|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:18:57.8867|ef7vSq|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:18:57.8867|ef7vSq|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|09:18:57.8867|ef7vSq|CJPOWERCAST|GetUserDataByKeys: adv.recent.searches.consumer t Transfer: 1220 : 10|09:18:57.8867|ef7vSq|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:18:57.8867|ef7vSq|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:18:57.8867|ef7vSq|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:18:57.8867|ef7vSq|CJPOWERCAST|imfx v3 API took 0.006s '/api/user-preferences?keys=adv.recent.searches.consumer&_dc=1672046347204'