t Transfer: 1220 : 10|02:30:18.2863|4W~wgO||OAuth: /api/logout?_dc=1692754229507 t Transfer: 1220 : 10|02:30:18.2863|4W~wgO||GetCurrentUser.. t Transfer: 1220 : 10|02:30:18.2863|4W~wgO|| OAuth authenticated t Verbose: 1220 : 10|02:30:18.2863|4W~wgO|| uid claim is missing.. t Information: 1220 : 10|02:30:18.2863|4W~wgO||OAuth. AutoLogin no Windows identity type WindowsIdentity t Transfer: 1220 : 10|02:30:18.9113|kwgUlO||GetAppInfo. DB: TMDDEMO. Install mode: . Auth types: Native, PublicApiKey t Information: 1220 : 10|02:30:19.5207|sqxgCx||GetCache. t Information: 1220 : 10|02:30:19.5207|sqxgCx||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\108_2_PnqJC_.png t Information: 1220 : 10|02:30:19.5207|sqxgCx||GetCache. Data read: 154944 t Verbose: 1220 : 10|02:30:19.5207|sqxgCx||imfx v3 API took 0.093s '/api/v3/visual-asset/group/PnqJC_/2/image' t Verbose: 1220 : 10|02:30:21.3562|WNQv88||Oauth validating.. t Verbose: 1220 : 10|02:30:21.3562|WNQv88||GrantResourceOwnerCredentials. t Verbose: 1220 : 10|02:30:21.5594|WNQv88||LoginUser. cjpowercast, login type OAuth, encrypt password True t Information: 1220 : 10|02:30:21.5594|WNQv88||TryLoginUser. cjpowercast, login type OAuth, check password True, check hash False, encrypt password True, load user data False t Information: 1220 : 10|02:30:21.9671|WNQv88|| oauth token 00000000-0000-0000-0000-000000000000 t Information: 1220 : 10|02:30:21.9671|WNQv88||TryLoginUser. Logged in.. t Information: 1220 : 10|02:30:22.1701|WNQv88||GetPasswordPolicy. WARNING: Policy not found for system Imediaflex. Validation disabled. t Verbose: 1220 : 10|02:30:22.1701|WNQv88||LoginUser. Adding history. User Id 1165, result CJPOWERCAST, host 192.168.127.6 t Verbose: 1220 : 10|02:30:22.1701|WNQv88||GrantResourceOwnerCredentials. Try login finished. Logged: True t Transfer: 1220 : 10|02:30:22.5764|yuh7ig|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=1692754233857 t Transfer: 1220 : 10|02:30:22.5764|yuh7ig|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:22.5764|yuh7ig|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:22.5764|yuh7ig|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:30:22.5764|yuh7ig|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|02:30:22.5764|yuh7ig|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:22.5764|yuh7ig|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:22.5764|yuh7ig|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:30:22.5764|yuh7ig|CJPOWERCAST|imfx v3 API took 0.044s '/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=1692754233857' t Transfer: 1220 : 10|02:30:22.9826|2KfPIT|CJPOWERCAST|OAuth: /api/user-preferences?keys=personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch;workflow_queues_actions;workflow_queues_settings&_dc=1692754234207 t Transfer: 1220 : 10|02:30:22.9826|2KfPIT|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:22.9826|2KfPIT|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:22.9826|2KfPIT|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:30:22.9826|2KfPIT|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|02:30:22.9826|2KfPIT|CJPOWERCAST|GetUserDataByKeys: personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch;workflow_queues_actions;workflow_queues_settings t Transfer: 1220 : 10|02:30:22.9826|2KfPIT|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:22.9826|2KfPIT|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:22.9826|2KfPIT|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:30:22.9826|2KfPIT|CJPOWERCAST|imfx v3 API took 0.047s '/api/user-preferences?keys=personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch;workflow_queues_actions;workflow_queues_settings&_dc=1692754234207' t Information: 1220 : 10|02:30:23.1858|y5hMyp|CJPOWERCAST|GetUserProfile. Id: 0 t Transfer: 1220 : 10|02:30:23.1858|y5hMyp|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:23.1858|y5hMyp|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:23.1858|y5hMyp|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|02:30:23.5920|nFkger|CJPOWERCAST|OAuth: /api/settings/group/0?_dc=1692754234946 t Transfer: 1220 : 10|02:30:23.5920|nFkger|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:23.5920|nFkger|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:23.5920|nFkger|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:30:23.5920|nFkger|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|02:30:23.5920|DQZE1i|CJPOWERCAST|OAuth: /api/settings/user/mainMenuSettings?_dc=1692754234947 t Transfer: 1220 : 10|02:30:23.5920|DQZE1i|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:23.5920|DQZE1i|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:23.5920|DQZE1i|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:30:23.5920|DQZE1i|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|02:30:23.7952|DQZE1i|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:23.7952|DQZE1i|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:23.7952|DQZE1i|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:30:23.7952|DQZE1i|CJPOWERCAST|imfx v3 API took 0.008s '/api/settings/user/mainMenuSettings?_dc=1692754234947' t Transfer: 1220 : 10|02:30:23.7952|lANszn|CJPOWERCAST|OAuth: /api/settings/user/uploadSettings?_dc=1692754234963 t Transfer: 1220 : 10|02:30:23.7952|lANszn|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:23.7952|lANszn|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:23.7952|lANszn|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:30:23.7952|lANszn|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|02:30:23.7952|gcE~RS|CJPOWERCAST|OAuth: /api/settings/group/0?_dc=1692754234988 t Transfer: 1220 : 10|02:30:23.7952|gcE~RS|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:23.7952|gcE~RS|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:23.7952|gcE~RS|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:30:23.7952|gcE~RS|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|02:30:23.7952|iUZUi7|CJPOWERCAST|OAuth: /api/settings/user/mainMenuSettings?_dc=1692754234989 t Transfer: 1220 : 10|02:30:23.7952|iUZUi7|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:23.7952|iUZUi7|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:23.7952|iUZUi7|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:30:23.7952|iUZUi7|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|02:30:23.7952|lANszn|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:23.7952|lANszn|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:23.7952|lANszn|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|02:30:23.7952|iUZUi7|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:23.7952|iUZUi7|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:23.7952|iUZUi7|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:30:23.9983|iUZUi7|CJPOWERCAST|imfx v3 API took 0.095s '/api/settings/user/mainMenuSettings?_dc=1692754234989' t Verbose: 1220 : 10|02:30:23.9983|lANszn|CJPOWERCAST|imfx v3 API took 0.179s '/api/settings/user/uploadSettings?_dc=1692754234963' t Information: 1220 : 10|02:30:23.9983|FAPa7u||GetCache. t Information: 1220 : 10|02:30:23.9983|FAPa7u||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\201_0_Any_gO.png t Information: 1220 : 10|02:30:23.9983|FAPa7u||GetCache. Data read: 0 t Verbose: 1220 : 10|02:30:23.9983|FAPa7u||imfx v3 API took 0.007s '/api/v3/visual-asset/group/Any_gO/0/image' t Verbose: 1220 : 10|02:30:23.9983|nFkger|CJPOWERCAST|imfx v3 API took 0.315s '/api/settings/group/0?_dc=1692754234946' t Verbose: 1220 : 10|02:30:23.9983|gcE~RS|CJPOWERCAST|imfx v3 API took 0.186s '/api/settings/group/0?_dc=1692754234988' t Transfer: 1220 : 10|02:30:24.2014|OHGrvI|CJPOWERCAST|OAuth: /api/lookups/MediaStatus?_dc=1692754235005 t Transfer: 1220 : 10|02:30:24.2014|OHGrvI|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:24.2014|OHGrvI|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:24.2014|OHGrvI|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:30:24.2014|OHGrvI|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|02:30:24.2014|7oIye7|CJPOWERCAST|OAuth: /api/lookups/PgmStatus?_dc=1692754235006 t Transfer: 1220 : 10|02:30:24.2014|7oIye7|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:24.2014|7oIye7|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:24.2014|7oIye7|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:30:24.2014|7oIye7|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|02:30:24.2014|667vfL|CJPOWERCAST|OAuth: /api/lookup/CustomMediaStatusTypes?_dc=1692754235007 t Transfer: 1220 : 10|02:30:24.2014|667vfL|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:24.2014|667vfL|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:24.2014|667vfL|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:30:24.2014|667vfL|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 10|02:30:24.2014|7oIye7|CJPOWERCAST|imfx v3 API took 0.040s '/api/lookups/PgmStatus?_dc=1692754235006' t Verbose: 1220 : 10|02:30:24.2014|OHGrvI|CJPOWERCAST|imfx v3 API took 0.041s '/api/lookups/MediaStatus?_dc=1692754235005' t Transfer: 1220 : 10|02:30:24.4202|bnoJzB|CJPOWERCAST|OAuth: /api/lookup/CustomVersionStatusTypes?_dc=1692754235008 t Transfer: 1220 : 10|02:30:24.4202|bnoJzB|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:24.4202|bnoJzB|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:24.4202|bnoJzB|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:30:24.4202|bnoJzB|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|02:30:24.4202|JkhR~s|CJPOWERCAST|OAuth: /api/lookup/CustomTitleStatusTypes?_dc=1692754235009 t Transfer: 1220 : 10|02:30:24.4202|JkhR~s|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:24.4202|JkhR~s|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:24.4202|JkhR~s|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:30:24.4202|JkhR~s|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|02:30:24.4202|JA3TUi|CJPOWERCAST|OAuth: /api/settings/user/defaultHomePage?_dc=1692754235011 t Transfer: 1220 : 10|02:30:24.4202|JA3TUi|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:24.4202|JA3TUi|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:24.4202|JA3TUi|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:30:24.4202|JA3TUi|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|02:30:24.4202|JA3TUi|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:24.4202|JA3TUi|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:24.4202|JA3TUi|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:30:24.4202|JA3TUi|CJPOWERCAST|imfx v3 API took 0.016s '/api/settings/user/defaultHomePage?_dc=1692754235011' t Verbose: 1220 : 10|02:30:24.4202|JkhR~s|CJPOWERCAST|imfx v3 API took 0.030s '/api/lookup/CustomTitleStatusTypes?_dc=1692754235009' t Verbose: 1220 : 10|02:30:24.4202|667vfL|CJPOWERCAST|imfx v3 API took 0.115s '/api/lookup/CustomMediaStatusTypes?_dc=1692754235007' t Verbose: 1220 : 10|02:30:24.4202|bnoJzB|CJPOWERCAST|imfx v3 API took 0.078s '/api/lookup/CustomVersionStatusTypes?_dc=1692754235008' t Information: 1220 : 10|02:30:24.6389|Yqiwtd||GetCache. t Information: 1220 : 10|02:30:24.6389|Yqiwtd||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\202_1_Any_gO.png t Information: 1220 : 10|02:30:24.6389|Yqiwtd||GetCache. Data read: 0 t Verbose: 1220 : 10|02:30:24.6389|Yqiwtd||imfx v3 API took 0.005s '/api/v3/visual-asset/group/Any_gO/1/image' t Transfer: 1220 : 10|02:30:26.2742|AlpROc|CJPOWERCAST|OAuth: /api/settings/user/defaultSearch?_dc=1692754237463 t Transfer: 1220 : 10|02:30:26.2742|AlpROc|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:26.2742|AlpROc|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:26.2742|AlpROc|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:30:26.2742|AlpROc|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|02:30:26.2742|0KV4~K|CJPOWERCAST|OAuth: /api/settings/user/startSearch?_dc=1692754237464 t Transfer: 1220 : 10|02:30:26.2742|0KV4~K|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:26.2742|0KV4~K|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:26.2742|0KV4~K|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:30:26.2742|0KV4~K|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|02:30:26.2742|AlpROc|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:26.2742|AlpROc|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:26.2742|AlpROc|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|02:30:26.2742|0KV4~K|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:26.2742|0KV4~K|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:26.2742|0KV4~K|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:30:26.2742|AlpROc|CJPOWERCAST|imfx v3 API took 0.011s '/api/settings/user/defaultSearch?_dc=1692754237463' t Verbose: 1220 : 10|02:30:26.2742|0KV4~K|CJPOWERCAST|imfx v3 API took 0.010s '/api/settings/user/startSearch?_dc=1692754237464' t Transfer: 1220 : 10|02:30:26.4867|65I4ZB|CJPOWERCAST|OAuth: /api/user-preferences?keys=consumer.recent.data&_dc=1692754237774 t Transfer: 1220 : 10|02:30:26.4867|65I4ZB|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:26.4867|65I4ZB|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:26.4867|65I4ZB|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:30:26.4867|65I4ZB|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|02:30:26.4867|65I4ZB|CJPOWERCAST|GetUserDataByKeys: consumer.recent.data t Transfer: 1220 : 10|02:30:26.4867|65I4ZB|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:26.4867|65I4ZB|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:26.4867|65I4ZB|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|02:30:26.4867|bgpQeU|CJPOWERCAST|OAuth: /api/user-preferences?keys=adv.recent.searches.consumer&_dc=1692754237783 t Transfer: 1220 : 10|02:30:26.4867|bgpQeU|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:26.4867|bgpQeU|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:26.4867|bgpQeU|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:30:26.4867|bgpQeU|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|02:30:26.4867|bgpQeU|CJPOWERCAST|GetUserDataByKeys: adv.recent.searches.consumer t Transfer: 1220 : 10|02:30:26.4867|bgpQeU|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:26.4867|bgpQeU|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:26.4867|bgpQeU|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:30:26.4867|65I4ZB|CJPOWERCAST|imfx v3 API took 0.008s '/api/user-preferences?keys=consumer.recent.data&_dc=1692754237774' t Verbose: 1220 : 10|02:30:26.4867|bgpQeU|CJPOWERCAST|imfx v3 API took 0.005s '/api/user-preferences?keys=adv.recent.searches.consumer&_dc=1692754237783' t Information: 1220 : 10|02:30:26.4867|4dcQOq||GetCache. t Information: 1220 : 10|02:30:26.4867|4dcQOq||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\204_3_Any_gO.png t Information: 1220 : 10|02:30:26.4867|4dcQOq||GetCache. Data read: 5504 t Verbose: 1220 : 10|02:30:26.4867|4dcQOq||imfx v3 API took 0.006s '/api/v3/visual-asset/group/Any_gO/3/image' t Transfer: 1220 : 10|02:30:30.7650|MsM5Rf|CJPOWERCAST|OAuth: /api/lookups/SearchSupportedOperators?_dc=1692754241984 t Transfer: 1220 : 10|02:30:30.7650|MsM5Rf|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:30.7650|MsM5Rf|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:30.7650|MsM5Rf|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:30:30.7650|MsM5Rf|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|02:30:30.7650|dfvB9D|CJPOWERCAST|OAuth: /api/view/searchinfo/TitleSearch?_dc=1692754241982 t Transfer: 1220 : 10|02:30:30.7650|dfvB9D|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:30.7650|dfvB9D|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:30.7650|dfvB9D|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:30:30.7650|dfvB9D|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 10|02:30:30.7650|MsM5Rf|CJPOWERCAST|imfx v3 API took 0.000s '/api/lookups/SearchSupportedOperators?_dc=1692754241984' t Transfer: 1220 : 10|02:30:30.7650|OFBjNP|CJPOWERCAST|OAuth: /api/user-preferences?keys=adv.recent.searches.titles&_dc=1692754241987 t Transfer: 1220 : 10|02:30:30.7650|OFBjNP|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:30.7650|OFBjNP|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:30.7650|OFBjNP|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:30:30.7650|OFBjNP|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|02:30:30.7650|OFBjNP|CJPOWERCAST|GetUserDataByKeys: adv.recent.searches.titles t Transfer: 1220 : 10|02:30:30.7650|OFBjNP|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:30.7650|OFBjNP|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:30.7650|OFBjNP|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|02:30:30.7650|dfvB9D|CJPOWERCAST|GetAdvSearchColumns. search type TitleSearch grid . t Verbose: 1220 : 10|02:30:30.7650|dfvB9D|CJPOWERCAST|imfx v3 API took 0.001s '/api/view/searchinfo/TitleSearch?_dc=1692754241982' t Verbose: 1220 : 10|02:30:30.7650|OFBjNP|CJPOWERCAST|imfx v3 API took 0.009s '/api/user-preferences?keys=adv.recent.searches.titles&_dc=1692754241987' t Transfer: 1220 : 10|02:30:30.7650|QTIYLC|CJPOWERCAST|OAuth: /api/view/searches/TitleSearch?_dc=1692754242051 t Transfer: 1220 : 10|02:30:30.7650|QTIYLC|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:30.7650|QTIYLC|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:30.7650|QTIYLC|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:30:30.7650|QTIYLC|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|02:30:30.7650|QTIYLC|CJPOWERCAST|GetSavedSearchNames. search type TitleSearch. t Transfer: 1220 : 10|02:30:30.7650|QTIYLC|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:30.7650|QTIYLC|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:30.7650|QTIYLC|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:30:30.7650|QTIYLC|CJPOWERCAST|imfx v3 API took 0.039s '/api/view/searches/TitleSearch?_dc=1692754242051' t Transfer: 1220 : 10|02:30:30.9838|ok7LMk|CJPOWERCAST|OAuth: /api/view/info/VersionGrid?lang=en-GB&_dc=1692754242068 t Transfer: 1220 : 10|02:30:30.9838|ok7LMk|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:30.9838|ok7LMk|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:30.9838|ok7LMk|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:30:30.9838|ok7LMk|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|02:30:30.9838|ok7LMk|CJPOWERCAST|GetGridViewBuilder. builder type VersionGrid. t Transfer: 1220 : 10|02:30:30.9838|ok7LMk|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:30.9838|ok7LMk|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:30.9838|ok7LMk|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|02:30:30.9838|ok7LMk|CJPOWERCAST|UserGridView. LoadView. ID -2, Name Default. t Transfer: 1220 : 10|02:30:30.9838|ok7LMk|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:30.9838|ok7LMk|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:30.9838|ok7LMk|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|02:30:31.1869|ok7LMk|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:31.1869|ok7LMk|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:31.1869|ok7LMk|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:30:31.1869|ok7LMk|CJPOWERCAST|imfx v3 API took 0.111s '/api/view/info/VersionGrid?lang=en-GB&_dc=1692754242068' t Transfer: 1220 : 10|02:30:31.3900|~axfRK|CJPOWERCAST|OAuth: /api/view/info/MediaGrid?lang=en-GB&_dc=1692754242149 t Transfer: 1220 : 10|02:30:31.3900|~axfRK|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:31.3900|~axfRK|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:31.3900|~axfRK|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:30:31.3900|~axfRK|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|02:30:31.3900|Pvx5jg|CJPOWERCAST|OAuth: /api/view/info/DigitalCarriers?lang=en-GB&_dc=1692754242191 t Transfer: 1220 : 10|02:30:31.3900|Pvx5jg|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:31.3900|Pvx5jg|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:31.3900|Pvx5jg|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:30:31.3900|Pvx5jg|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|02:30:31.3900|~axfRK|CJPOWERCAST|GetGridViewBuilder. builder type MediaGrid. t Transfer: 1220 : 10|02:30:31.3900|~axfRK|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:31.3900|~axfRK|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:31.3900|~axfRK|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|02:30:31.3900|Pvx5jg|CJPOWERCAST|GetGridViewBuilder. builder type DigitalCarriers. t Transfer: 1220 : 10|02:30:31.3900|Pvx5jg|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:31.3900|Pvx5jg|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:31.3900|Pvx5jg|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|02:30:31.3900|~axfRK|CJPOWERCAST|UserGridView. LoadView. ID -2, Name Default. t Transfer: 1220 : 10|02:30:31.3900|~axfRK|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:31.3900|~axfRK|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:31.3900|~axfRK|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|02:30:31.3900|Pvx5jg|CJPOWERCAST|UserGridView. LoadView. ID -2, Name Default. t Transfer: 1220 : 10|02:30:31.3900|Pvx5jg|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:31.3900|Pvx5jg|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:31.3900|Pvx5jg|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|02:30:31.3900|~axfRK|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:31.3900|~axfRK|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:31.3900|~axfRK|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|02:30:31.3900|Pvx5jg|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:31.3900|Pvx5jg|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:31.3900|Pvx5jg|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:30:31.3900|Pvx5jg|CJPOWERCAST|imfx v3 API took 0.013s '/api/view/info/DigitalCarriers?lang=en-GB&_dc=1692754242191' t Verbose: 1220 : 10|02:30:31.3900|~axfRK|CJPOWERCAST|imfx v3 API took 0.014s '/api/view/info/MediaGrid?lang=en-GB&_dc=1692754242149' t Transfer: 1220 : 10|02:30:31.3900|pWG92P|CJPOWERCAST|OAuth: /api/view/info/TitleTree?lang=en-GB&_dc=1692754242241 t Transfer: 1220 : 10|02:30:31.3900|pWG92P|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:31.3900|pWG92P|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:31.3900|pWG92P|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:30:31.3900|pWG92P|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|02:30:31.3900|pWG92P|CJPOWERCAST|GetGridViewBuilder. builder type TitleTree. t Transfer: 1220 : 10|02:30:31.3900|pWG92P|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:31.3900|pWG92P|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:31.3900|pWG92P|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|02:30:31.3900|pWG92P|CJPOWERCAST|UserGridView. LoadView. ID -2, Name Default. t Transfer: 1220 : 10|02:30:31.3900|pWG92P|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:31.3900|pWG92P|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:31.3900|pWG92P|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|02:30:31.3900|pWG92P|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:31.3900|pWG92P|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:31.3900|pWG92P|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:30:31.3900|pWG92P|CJPOWERCAST|imfx v3 API took 0.007s '/api/view/info/TitleTree?lang=en-GB&_dc=1692754242241' t Transfer: 1220 : 10|02:30:35.2765|JMHE~w|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1692754246462 t Transfer: 1220 : 10|02:30:35.2765|JMHE~w|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:35.2765|JMHE~w|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:35.2765|JMHE~w|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:30:35.2765|JMHE~w|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|02:30:35.2765|JMHE~w|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:35.2765|JMHE~w|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:35.2765|JMHE~w|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|02:30:35.2765|Z5LjNP|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1692754246614 t Transfer: 1220 : 10|02:30:35.2765|Z5LjNP|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:35.2765|Z5LjNP|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:35.2765|Z5LjNP|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:30:35.2765|Z5LjNP|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|02:30:35.2765|Z5LjNP|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:35.2765|Z5LjNP|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:35.2765|Z5LjNP|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:30:36.5344|Z5LjNP|CJPOWERCAST|imfx v3 API took 1.127s '/api/v3/search-suggestion/?_dc=1692754246614' t Verbose: 1220 : 10|02:30:36.5344|JMHE~w|CJPOWERCAST|imfx v3 API took 1.210s '/api/v3/search-suggestion/?_dc=1692754246462' t Transfer: 1220 : 10|02:30:37.9624|61Wc5q|CJPOWERCAST|OAuth: /api/v3/search/title?_dc=1692754249271 t Transfer: 1220 : 10|02:30:37.9624|61Wc5q|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:37.9624|61Wc5q|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:37.9624|61Wc5q|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:30:37.9624|61Wc5q|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|02:30:38.1655|61Wc5q|CJPOWERCAST|V3Api.SearchTitles t Information: 1220 : 10|02:30:38.1655|61Wc5q|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 10|02:30:38.1655|61Wc5q|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:38.1655|61Wc5q|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:38.1655|61Wc5q|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|02:30:38.1655|61Wc5q|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|02:30:38.3687|61Wc5q|CJPOWERCAST|Alternative title fields query: select * from (select x.id,x.id TitleId from TM_PG_ABS 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) and o.type_id=:param_1 order by o.id desc fetch first 1 rows only)(+) t Verbose: 1220 : 10|02:30:38.3687|61Wc5q|CJPOWERCAST|imfx v3 API took 0.363s '/api/v3/search/title?_dc=1692754249271' t Transfer: 1220 : 10|02:30:38.7749|ijosKS|CJPOWERCAST|OAuth: /api/v3/title/299390/versions?_dc=1692754250134 t Transfer: 1220 : 10|02:30:38.7749|ijosKS|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:38.7749|ijosKS|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:38.7749|ijosKS|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:30:38.7749|ijosKS|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|02:30:38.9936|TLkbjp|CJPOWERCAST|OAuth: /api/user-preferences?_dc=1692754250138 t Transfer: 1220 : 10|02:30:38.9936|TLkbjp|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:38.9936|TLkbjp|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:38.9936|TLkbjp|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:30:38.9936|TLkbjp|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|02:30:38.9936|ijosKS|CJPOWERCAST|V3Api.SearchGeneric t Verbose: 1220 : 10|02:30:38.9936|TLkbjp|CJPOWERCAST|StoreUserDataByKeys.. t Transfer: 1220 : 10|02:30:38.9936|TLkbjp|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:38.9936|TLkbjp|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:38.9936|TLkbjp|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|02:30:38.9936|ijosKS|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:38.9936|ijosKS|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:38.9936|ijosKS|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:30:38.9936|TLkbjp|CJPOWERCAST|imfx v3 API took 0.017s '/api/user-preferences?_dc=1692754250138' t Transfer: 1220 : 10|02:30:38.9936|ijosKS|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:38.9936|ijosKS|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:38.9936|ijosKS|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|02:30:38.9936|ijosKS|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:38.9936|ijosKS|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:38.9936|ijosKS|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|02:30:38.9936|ijosKS|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 med.medium_name from TM_CFG_MEDIUM med, TM_PG_ABS pgabs where pgabs.id=v.PGM_ABS_ID and pgabs.MEDIUM_ID = med.id) MEDIUM_TEXT ,(select replace(tmd_str_agg_pipe(cf.form_name),'|',' / ') from TM_PG_FORM_LNX fl join TM_CFG_FORM cf on (cf.id=fl.form_id) where fl.tm_pg_id = v.ID) FORM_TEXT ,(select replace(tmd_str_agg_pipe(dvb.item_name),'|',' / ') from TM_PG_ABS_GENRE_LNX gl join TM_DVB dvb on (dvb.id=gl.genre_id) where gl.tm_pg_abs_id = v.PGM_ABS_ID) GENRE_TEXT, (select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = v.net_grp_id) CHANNEL_GROUP, (select count(id) from tm_mis where item_type>0 and pgm_parent_id=v.id) MEDIA_COUNT, (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 : 10|02:30:38.9936|ijosKS|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:38.9936|ijosKS|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:38.9936|ijosKS|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|02:30:38.9936|ijosKS|CJPOWERCAST|Running version search. User: 1165 Simple Search: Running Oracle search. Running Oracle search for COUNT Oracle count completed in: 50ms. Returned lines: 0 t Verbose: 1220 : 10|02:30:38.9936|ijosKS|CJPOWERCAST|imfx v3 API took 0.085s '/api/v3/title/299390/versions?_dc=1692754250134' t Transfer: 1220 : 10|02:30:40.6287|wehi20|CJPOWERCAST|OAuth: /api/v3/title/299542/versions?_dc=1692754251806 t Transfer: 1220 : 10|02:30:40.6287|wehi20|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:40.6287|wehi20|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:40.6287|wehi20|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:30:40.6287|wehi20|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|02:30:40.6287|wehi20|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 10|02:30:40.6287|wehi20|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:40.6287|wehi20|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:40.6287|wehi20|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|02:30:40.6287|wehi20|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:40.6287|wehi20|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:40.6287|wehi20|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|02:30:40.6287|wehi20|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:40.6287|wehi20|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:40.6287|wehi20|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|02:30:40.6287|wehi20|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 med.medium_name from TM_CFG_MEDIUM med, TM_PG_ABS pgabs where pgabs.id=v.PGM_ABS_ID and pgabs.MEDIUM_ID = med.id) MEDIUM_TEXT ,(select replace(tmd_str_agg_pipe(cf.form_name),'|',' / ') from TM_PG_FORM_LNX fl join TM_CFG_FORM cf on (cf.id=fl.form_id) where fl.tm_pg_id = v.ID) FORM_TEXT ,(select replace(tmd_str_agg_pipe(dvb.item_name),'|',' / ') from TM_PG_ABS_GENRE_LNX gl join TM_DVB dvb on (dvb.id=gl.genre_id) where gl.tm_pg_abs_id = v.PGM_ABS_ID) GENRE_TEXT, (select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = v.net_grp_id) CHANNEL_GROUP, (select count(id) from tm_mis where item_type>0 and pgm_parent_id=v.id) MEDIA_COUNT, (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 : 10|02:30:40.6287|wehi20|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:40.6287|wehi20|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:40.6287|wehi20|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|02:30:41.6421|wehi20|CJPOWERCAST|Running version search. User: 1165 Simple Search: Running Oracle search. Running Oracle search for COUNT Oracle count completed in: 6ms. Returned lines: 1 Oracle version search timing: 1020ms. 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 med.medium_name from TM_CFG_MEDIUM med, TM_PG_ABS pgabs where pgabs.id=v.PGM_ABS_ID and pgabs.MEDIUM_ID = med.id) MEDIUM_TEXT ,(select replace(tmd_str_agg_pipe(cf.form_name),'|',' / ') from TM_PG_FORM_LNX fl join TM_CFG_FORM cf on (cf.id=fl.form_id) where fl.tm_pg_id = v.ID) FORM_TEXT ,(select replace(tmd_str_agg_pipe(dvb.item_name),'|',' / ') from TM_PG_ABS_GENRE_LNX gl join TM_DVB dvb on (dvb.id=gl.genre_id) where gl.tm_pg_abs_id = v.PGM_ABS_ID) GENRE_TEXT, (select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = v.net_grp_id) CHANNEL_GROUP, (select count(id) from tm_mis where item_type>0 and pgm_parent_id=v.id) MEDIA_COUNT, (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 : 10|02:30:41.6421|wehi20|CJPOWERCAST|Alternative title fields query: select * from (select x.id,x.pgm_abs_id TitleId, x.id VersionId from TM_PG_RL 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|02:30:41.6421|wehi20|CJPOWERCAST|imfx v3 API took 1.056s '/api/v3/title/299542/versions?_dc=1692754251806' t Transfer: 1220 : 10|02:30:42.0483|Tma16M|CJPOWERCAST|OAuth: /api/v3/version/299543/media?_dc=1692754253350 t Transfer: 1220 : 10|02:30:42.0483|Tma16M|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:42.0483|Tma16M|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:42.0483|Tma16M|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:30:42.0483|Tma16M|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|02:30:42.0483|Tma16M|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 10|02:30:42.0483|~fZYzh|CJPOWERCAST|OAuth: /api/v3/version/299543/media?_dc=1692754253369 t Transfer: 1220 : 10|02:30:42.0483|~fZYzh|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:42.0483|~fZYzh|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:42.0483|~fZYzh|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:30:42.0483|~fZYzh|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|02:30:42.0483|~fZYzh|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 10|02:30:42.0483|Tma16M|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:42.0483|Tma16M|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:42.0483|Tma16M|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|02:30:42.0483|~fZYzh|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:42.0483|~fZYzh|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:42.0483|~fZYzh|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|02:30:42.0483|Tma16M|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 : 10|02:30:42.0483|~fZYzh|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 : 10|02:30:43.0644|Tma16M|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|02:30:43.0644|~fZYzh|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|02:30:43.0644|Tma16M|CJPOWERCAST| timing: 00:00:00.8749463 t Verbose: 1220 : 10|02:30:43.0644|Tma16M|CJPOWERCAST|imfx v3 API took 0.887s '/api/v3/version/299543/media?_dc=1692754253350' t Information: 1220 : 10|02:30:43.0644|~fZYzh|CJPOWERCAST| timing: 00:00:00.8734882 t Verbose: 1220 : 10|02:30:43.0644|~fZYzh|CJPOWERCAST|imfx v3 API took 0.874s '/api/v3/version/299543/media?_dc=1692754253369' t Transfer: 1220 : 10|02:30:43.2677|Tma16M|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0156.mp4 subfolder t Transfer: 1220 : 10|02:30:43.2677|~fZYzh|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0156.mp4 subfolder t Transfer: 1220 : 10|02:30:43.2677|Tma16M|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156.mp4 t Transfer: 1220 : 10|02:30:43.2677|Tma16M|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156.mp4 t Transfer: 1220 : 10|02:30:43.2677|Tma16M|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:43.2677|Tma16M|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:43.2677|Tma16M|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|02:30:43.2677|~fZYzh|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156.mp4 t Transfer: 1220 : 10|02:30:43.2677|~fZYzh|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156.mp4 t Transfer: 1220 : 10|02:30:43.2677|~fZYzh|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:43.2677|~fZYzh|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:43.2677|~fZYzh|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|02:30:43.4708|~fZYzh|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0156M0002021.mp4 subfolder t Transfer: 1220 : 10|02:30:43.4708|~fZYzh|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156M0002021.mp4 t Transfer: 1220 : 10|02:30:43.4708|~fZYzh|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156M0002021.mp4 t Transfer: 1220 : 10|02:30:43.4708|~fZYzh|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:43.4708|~fZYzh|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:43.4708|~fZYzh|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|02:30:43.4708|Tma16M|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0156M0002021.mp4 subfolder t Transfer: 1220 : 10|02:30:43.4708|Tma16M|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156M0002021.mp4 t Transfer: 1220 : 10|02:30:43.4708|Tma16M|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156M0002021.mp4 t Transfer: 1220 : 10|02:30:43.4708|Tma16M|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:43.4708|Tma16M|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:43.4708|Tma16M|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|02:30:43.4708|Tma16M|CJPOWERCAST|GetUrl. Storage |Audio| filename \\192.168.120.254\DemoFS\Digital Assets\Audio\gotspecialspromosaudio.wav subfolder t Transfer: 1220 : 10|02:30:43.4708|Tma16M|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/AudioServer/gotspecialspromosaudio.wav t Transfer: 1220 : 10|02:30:43.4708|Tma16M|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/AudioServer/gotspecialspromosaudio.wav t Transfer: 1220 : 10|02:30:43.4708|Tma16M|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:43.4708|Tma16M|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:43.4708|Tma16M|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|02:30:43.4708|~fZYzh|CJPOWERCAST|GetUrl. Storage |Audio| filename \\192.168.120.254\DemoFS\Digital Assets\Audio\gotspecialspromosaudio.wav subfolder t Transfer: 1220 : 10|02:30:43.4708|~fZYzh|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/AudioServer/gotspecialspromosaudio.wav t Transfer: 1220 : 10|02:30:43.4708|~fZYzh|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/AudioServer/gotspecialspromosaudio.wav t Transfer: 1220 : 10|02:30:43.4708|~fZYzh|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:43.4708|~fZYzh|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:43.4708|~fZYzh|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|02:30:43.4708|Tma16M|CJPOWERCAST|GetUrl. Storage |Audio| filename \\192.168.120.254\DemoFS\Digital Assets\Audio\PMH_portugese - Copy.wav subfolder t Transfer: 1220 : 10|02:30:43.4708|Tma16M|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/AudioServer/PMH_portugese%20-%20Copy.wav t Transfer: 1220 : 10|02:30:43.4708|Tma16M|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/AudioServer/PMH_portugese%20-%20Copy.wav t Transfer: 1220 : 10|02:30:43.4708|Tma16M|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:43.4708|Tma16M|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:43.4708|Tma16M|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|02:30:43.4708|~fZYzh|CJPOWERCAST|GetUrl. Storage |Audio| filename \\192.168.120.254\DemoFS\Digital Assets\Audio\PMH_portugese - Copy.wav subfolder t Transfer: 1220 : 10|02:30:43.4708|~fZYzh|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/AudioServer/PMH_portugese%20-%20Copy.wav t Transfer: 1220 : 10|02:30:43.4708|~fZYzh|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/AudioServer/PMH_portugese%20-%20Copy.wav t Transfer: 1220 : 10|02:30:43.4708|~fZYzh|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:43.4708|~fZYzh|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:43.4708|~fZYzh|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|02:30:43.6896|aS1qlf|CJPOWERCAST|OAuth: /api/view/info/TapeGrid?lang=en-GB&_dc=1692754254953 t Transfer: 1220 : 10|02:30:43.6896|aS1qlf|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:43.6896|aS1qlf|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:43.6896|aS1qlf|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:30:43.6896|aS1qlf|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|02:30:43.6896|aS1qlf|CJPOWERCAST|GetGridViewBuilder. builder type TapeGrid. t Transfer: 1220 : 10|02:30:43.6896|aS1qlf|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:43.6896|aS1qlf|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:43.6896|aS1qlf|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|02:30:43.6896|aS1qlf|CJPOWERCAST|UserGridView. LoadView. ID -2, Name Default. t Transfer: 1220 : 10|02:30:43.6896|aS1qlf|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:43.6896|aS1qlf|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:43.6896|aS1qlf|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|02:30:43.6896|aS1qlf|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:43.6896|aS1qlf|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:43.6896|aS1qlf|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:30:43.6896|aS1qlf|CJPOWERCAST|imfx v3 API took 0.007s '/api/view/info/TapeGrid?lang=en-GB&_dc=1692754254953' t Transfer: 1220 : 10|02:30:44.0958|CxNWni|CJPOWERCAST|OAuth: /api/v3/media/299739/carriers/physical?_dc=1692754255287 t Transfer: 1220 : 10|02:30:44.0958|CxNWni|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:44.0958|CxNWni|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:44.0958|CxNWni|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:30:44.0958|CxNWni|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|02:30:44.0958|CxNWni|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 10|02:30:44.0958|CxNWni|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:44.0958|CxNWni|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:44.0958|CxNWni|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|02:30:44.0958|CxNWni|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:44.0958|CxNWni|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:44.0958|CxNWni|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:30:44.0958|CxNWni|CJPOWERCAST|imfx v3 API took 0.068s '/api/v3/media/299739/carriers/physical?_dc=1692754255287' t Transfer: 1220 : 10|02:30:44.5021|iOzV9K|CJPOWERCAST|OAuth: /api/v3/media/299739/carriers/physical?_dc=1692754255713 t Transfer: 1220 : 10|02:30:44.5021|iOzV9K|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:44.5021|iOzV9K|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:44.5021|iOzV9K|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:30:44.5021|iOzV9K|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|02:30:44.5021|iOzV9K|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 10|02:30:44.5021|iOzV9K|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:44.5021|iOzV9K|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:44.5021|iOzV9K|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|02:30:44.5021|iOzV9K|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:30:44.5021|iOzV9K|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:30:44.5021|iOzV9K|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:30:44.5021|iOzV9K|CJPOWERCAST|imfx v3 API took 0.009s '/api/v3/media/299739/carriers/physical?_dc=1692754255713' t Transfer: 1220 : 10|02:31:02.8682|FhcTsf|CJPOWERCAST|OAuth: /api/v3/version/299543/media?_dc=1692754274120 t Transfer: 1220 : 10|02:31:02.8682|FhcTsf|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:31:02.8682|FhcTsf|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:31:02.8682|FhcTsf|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:31:02.8682|FhcTsf|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|02:31:02.8682|FhcTsf|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 10|02:31:02.8682|FhcTsf|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:31:02.8682|FhcTsf|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:31:02.8682|FhcTsf|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|02:31:02.8682|FhcTsf|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 : 10|02:31:02.8682|FhcTsf|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|02:31:02.8682|FhcTsf|CJPOWERCAST| timing: 00:00:00.0527891 t Verbose: 1220 : 10|02:31:02.8682|FhcTsf|CJPOWERCAST|imfx v3 API took 0.053s '/api/v3/version/299543/media?_dc=1692754274120' t Transfer: 1220 : 10|02:31:02.8682|FhcTsf|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0156.mp4 subfolder t Transfer: 1220 : 10|02:31:02.8682|FhcTsf|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156.mp4 t Transfer: 1220 : 10|02:31:02.8682|FhcTsf|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156.mp4 t Transfer: 1220 : 10|02:31:02.8682|FhcTsf|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:31:02.8682|FhcTsf|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:31:02.8682|FhcTsf|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|02:31:02.8682|FhcTsf|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0156M0002021.mp4 subfolder t Transfer: 1220 : 10|02:31:02.8682|FhcTsf|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156M0002021.mp4 t Transfer: 1220 : 10|02:31:02.8682|FhcTsf|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156M0002021.mp4 t Transfer: 1220 : 10|02:31:02.8682|FhcTsf|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:31:02.8682|FhcTsf|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:31:02.8682|FhcTsf|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|02:31:02.8682|FhcTsf|CJPOWERCAST|GetUrl. Storage |Audio| filename \\192.168.120.254\DemoFS\Digital Assets\Audio\gotspecialspromosaudio.wav subfolder t Transfer: 1220 : 10|02:31:02.8682|FhcTsf|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/AudioServer/gotspecialspromosaudio.wav t Transfer: 1220 : 10|02:31:02.8682|FhcTsf|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/AudioServer/gotspecialspromosaudio.wav t Transfer: 1220 : 10|02:31:02.8682|FhcTsf|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:31:02.8682|FhcTsf|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:31:02.8682|FhcTsf|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|02:31:02.8682|FhcTsf|CJPOWERCAST|GetUrl. Storage |Audio| filename \\192.168.120.254\DemoFS\Digital Assets\Audio\PMH_portugese - Copy.wav subfolder t Transfer: 1220 : 10|02:31:02.8682|FhcTsf|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/AudioServer/PMH_portugese%20-%20Copy.wav t Transfer: 1220 : 10|02:31:02.8682|FhcTsf|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/AudioServer/PMH_portugese%20-%20Copy.wav t Transfer: 1220 : 10|02:31:02.8682|FhcTsf|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:31:02.8682|FhcTsf|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:31:02.8682|FhcTsf|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|02:31:38.3896|uwM2RX|CJPOWERCAST|OAuth: /api/v3/version/299543/media?_dc=1692754309715 t Transfer: 1220 : 10|02:31:38.3896|uwM2RX|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:31:38.3896|uwM2RX|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:31:38.3896|uwM2RX|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:31:38.3896|uwM2RX|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|02:31:38.3896|uwM2RX|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 10|02:31:38.3896|uwM2RX|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:31:38.3896|uwM2RX|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:31:38.3896|uwM2RX|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|02:31:38.3896|uwM2RX|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 : 10|02:31:38.5927|uwM2RX|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|02:31:38.5927|uwM2RX|CJPOWERCAST| timing: 00:00:00.0385211 t Verbose: 1220 : 10|02:31:38.5927|uwM2RX|CJPOWERCAST|imfx v3 API took 0.039s '/api/v3/version/299543/media?_dc=1692754309715' t Transfer: 1220 : 10|02:31:38.5927|uwM2RX|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0156.mp4 subfolder t Transfer: 1220 : 10|02:31:38.5927|uwM2RX|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156.mp4 t Transfer: 1220 : 10|02:31:38.5927|uwM2RX|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156.mp4 t Transfer: 1220 : 10|02:31:38.5927|uwM2RX|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:31:38.5927|uwM2RX|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:31:38.5927|uwM2RX|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|02:31:38.5927|uwM2RX|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0156M0002021.mp4 subfolder t Transfer: 1220 : 10|02:31:38.5927|uwM2RX|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156M0002021.mp4 t Transfer: 1220 : 10|02:31:38.5927|uwM2RX|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156M0002021.mp4 t Transfer: 1220 : 10|02:31:38.5927|uwM2RX|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:31:38.5927|uwM2RX|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:31:38.5927|uwM2RX|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|02:31:38.5927|uwM2RX|CJPOWERCAST|GetUrl. Storage |Audio| filename \\192.168.120.254\DemoFS\Digital Assets\Audio\gotspecialspromosaudio.wav subfolder t Transfer: 1220 : 10|02:31:38.5927|uwM2RX|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/AudioServer/gotspecialspromosaudio.wav t Transfer: 1220 : 10|02:31:38.5927|uwM2RX|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/AudioServer/gotspecialspromosaudio.wav t Transfer: 1220 : 10|02:31:38.5927|uwM2RX|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:31:38.5927|uwM2RX|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:31:38.5927|uwM2RX|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|02:31:38.5927|uwM2RX|CJPOWERCAST|GetUrl. Storage |Audio| filename \\192.168.120.254\DemoFS\Digital Assets\Audio\PMH_portugese - Copy.wav subfolder t Transfer: 1220 : 10|02:31:38.5927|uwM2RX|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/AudioServer/PMH_portugese%20-%20Copy.wav t Transfer: 1220 : 10|02:31:38.5927|uwM2RX|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/AudioServer/PMH_portugese%20-%20Copy.wav t Transfer: 1220 : 10|02:31:38.5927|uwM2RX|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:31:38.5927|uwM2RX|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:31:38.5927|uwM2RX|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|02:31:42.4613|PXDN8b|CJPOWERCAST|OAuth: /api/v3/version/299543/media?_dc=1692754313764 t Transfer: 1220 : 10|02:31:42.4613|PXDN8b|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:31:42.4613|PXDN8b|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:31:42.4613|PXDN8b|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:31:42.4613|PXDN8b|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|02:31:42.4613|PXDN8b|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 10|02:31:42.4613|PXDN8b|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:31:42.4613|PXDN8b|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:31:42.4613|PXDN8b|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|02:31:42.4613|PXDN8b|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 : 10|02:31:42.4613|PXDN8b|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|02:31:42.4613|PXDN8b|CJPOWERCAST| timing: 00:00:00.0339836 t Verbose: 1220 : 10|02:31:42.4613|PXDN8b|CJPOWERCAST|imfx v3 API took 0.034s '/api/v3/version/299543/media?_dc=1692754313764' t Transfer: 1220 : 10|02:31:42.4613|PXDN8b|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0156.mp4 subfolder t Transfer: 1220 : 10|02:31:42.4613|PXDN8b|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156.mp4 t Transfer: 1220 : 10|02:31:42.4613|PXDN8b|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156.mp4 t Transfer: 1220 : 10|02:31:42.4613|PXDN8b|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:31:42.4613|PXDN8b|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:31:42.4613|PXDN8b|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|02:31:42.4613|PXDN8b|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0156M0002021.mp4 subfolder t Transfer: 1220 : 10|02:31:42.4613|PXDN8b|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156M0002021.mp4 t Transfer: 1220 : 10|02:31:42.4613|PXDN8b|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156M0002021.mp4 t Transfer: 1220 : 10|02:31:42.4613|PXDN8b|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:31:42.4613|PXDN8b|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:31:42.4613|PXDN8b|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|02:31:42.4613|PXDN8b|CJPOWERCAST|GetUrl. Storage |Audio| filename \\192.168.120.254\DemoFS\Digital Assets\Audio\gotspecialspromosaudio.wav subfolder t Transfer: 1220 : 10|02:31:42.4613|PXDN8b|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/AudioServer/gotspecialspromosaudio.wav t Transfer: 1220 : 10|02:31:42.4613|PXDN8b|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/AudioServer/gotspecialspromosaudio.wav t Transfer: 1220 : 10|02:31:42.4613|PXDN8b|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:31:42.4613|PXDN8b|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:31:42.4613|PXDN8b|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|02:31:42.4613|PXDN8b|CJPOWERCAST|GetUrl. Storage |Audio| filename \\192.168.120.254\DemoFS\Digital Assets\Audio\PMH_portugese - Copy.wav subfolder t Transfer: 1220 : 10|02:31:42.4613|PXDN8b|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/AudioServer/PMH_portugese%20-%20Copy.wav t Transfer: 1220 : 10|02:31:42.4613|PXDN8b|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/AudioServer/PMH_portugese%20-%20Copy.wav t Transfer: 1220 : 10|02:31:42.4613|PXDN8b|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:31:42.4613|PXDN8b|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:31:42.4613|PXDN8b|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|02:31:58.0037|~d1wp9|CJPOWERCAST|OAuth: /api/v3/version/299543/media?_dc=1692754329209 t Transfer: 1220 : 10|02:31:58.0037|~d1wp9|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:31:58.0037|~d1wp9|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:31:58.0037|~d1wp9|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:31:58.0037|~d1wp9|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|02:31:58.0037|~d1wp9|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 10|02:31:58.0037|~d1wp9|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:31:58.0037|~d1wp9|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:31:58.0037|~d1wp9|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|02:31:58.0037|~d1wp9|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 : 10|02:31:58.0037|~d1wp9|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|02:31:58.0037|~d1wp9|CJPOWERCAST| timing: 00:00:00.0275705 t Verbose: 1220 : 10|02:31:58.0037|~d1wp9|CJPOWERCAST|imfx v3 API took 0.028s '/api/v3/version/299543/media?_dc=1692754329209' t Transfer: 1220 : 10|02:31:58.0037|~d1wp9|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0156.mp4 subfolder t Transfer: 1220 : 10|02:31:58.0037|~d1wp9|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156.mp4 t Transfer: 1220 : 10|02:31:58.0037|~d1wp9|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156.mp4 t Transfer: 1220 : 10|02:31:58.0037|~d1wp9|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:31:58.0037|~d1wp9|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:31:58.0037|~d1wp9|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|02:31:58.0037|~d1wp9|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0156M0002021.mp4 subfolder t Transfer: 1220 : 10|02:31:58.0037|~d1wp9|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156M0002021.mp4 t Transfer: 1220 : 10|02:31:58.0037|~d1wp9|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156M0002021.mp4 t Transfer: 1220 : 10|02:31:58.0037|~d1wp9|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:31:58.0037|~d1wp9|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:31:58.0037|~d1wp9|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|02:31:58.0037|~d1wp9|CJPOWERCAST|GetUrl. Storage |Audio| filename \\192.168.120.254\DemoFS\Digital Assets\Audio\gotspecialspromosaudio.wav subfolder t Transfer: 1220 : 10|02:31:58.0037|~d1wp9|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/AudioServer/gotspecialspromosaudio.wav t Transfer: 1220 : 10|02:31:58.0037|~d1wp9|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/AudioServer/gotspecialspromosaudio.wav t Transfer: 1220 : 10|02:31:58.0037|~d1wp9|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:31:58.0037|~d1wp9|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:31:58.0037|~d1wp9|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|02:31:58.0037|~d1wp9|CJPOWERCAST|GetUrl. Storage |Audio| filename \\192.168.120.254\DemoFS\Digital Assets\Audio\PMH_portugese - Copy.wav subfolder t Transfer: 1220 : 10|02:31:58.0037|~d1wp9|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/AudioServer/PMH_portugese%20-%20Copy.wav t Transfer: 1220 : 10|02:31:58.0037|~d1wp9|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/AudioServer/PMH_portugese%20-%20Copy.wav t Transfer: 1220 : 10|02:31:58.0037|~d1wp9|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:31:58.0037|~d1wp9|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:31:58.0037|~d1wp9|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|02:31:58.0037|zUsqpb|CJPOWERCAST|OAuth: /api/v3/version/299543/media?_dc=1692754329349 t Transfer: 1220 : 10|02:31:58.0037|zUsqpb|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:31:58.0037|zUsqpb|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:31:58.0037|zUsqpb|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:31:58.0037|zUsqpb|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|02:31:58.0037|zUsqpb|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 10|02:31:58.0037|zUsqpb|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:31:58.0037|zUsqpb|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:31:58.0037|zUsqpb|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|02:31:58.0037|zUsqpb|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 : 10|02:31:58.2224|zUsqpb|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|02:31:58.2224|zUsqpb|CJPOWERCAST| timing: 00:00:00.0321544 t Verbose: 1220 : 10|02:31:58.2224|zUsqpb|CJPOWERCAST|imfx v3 API took 0.032s '/api/v3/version/299543/media?_dc=1692754329349' t Transfer: 1220 : 10|02:31:58.2224|zUsqpb|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0156.mp4 subfolder t Transfer: 1220 : 10|02:31:58.2224|zUsqpb|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156.mp4 t Transfer: 1220 : 10|02:31:58.2224|zUsqpb|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156.mp4 t Transfer: 1220 : 10|02:31:58.2224|zUsqpb|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:31:58.2224|zUsqpb|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:31:58.2224|zUsqpb|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|02:31:58.2224|zUsqpb|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0156M0002021.mp4 subfolder t Transfer: 1220 : 10|02:31:58.2224|zUsqpb|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156M0002021.mp4 t Transfer: 1220 : 10|02:31:58.2224|zUsqpb|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156M0002021.mp4 t Transfer: 1220 : 10|02:31:58.2224|zUsqpb|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:31:58.2224|zUsqpb|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:31:58.2224|zUsqpb|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|02:31:58.2224|zUsqpb|CJPOWERCAST|GetUrl. Storage |Audio| filename \\192.168.120.254\DemoFS\Digital Assets\Audio\gotspecialspromosaudio.wav subfolder t Transfer: 1220 : 10|02:31:58.2224|zUsqpb|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/AudioServer/gotspecialspromosaudio.wav t Transfer: 1220 : 10|02:31:58.2224|zUsqpb|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/AudioServer/gotspecialspromosaudio.wav t Transfer: 1220 : 10|02:31:58.2224|zUsqpb|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:31:58.2224|zUsqpb|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:31:58.2224|zUsqpb|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|02:31:58.2224|zUsqpb|CJPOWERCAST|GetUrl. Storage |Audio| filename \\192.168.120.254\DemoFS\Digital Assets\Audio\PMH_portugese - Copy.wav subfolder t Transfer: 1220 : 10|02:31:58.2224|zUsqpb|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/AudioServer/PMH_portugese%20-%20Copy.wav t Transfer: 1220 : 10|02:31:58.2224|zUsqpb|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/AudioServer/PMH_portugese%20-%20Copy.wav t Transfer: 1220 : 10|02:31:58.2224|zUsqpb|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:31:58.2224|zUsqpb|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:31:58.2224|zUsqpb|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|02:31:58.6287|ig36Ak|CJPOWERCAST|OAuth: /api/v3/media/299739/carriers/physical?_dc=1692754329825 t Transfer: 1220 : 10|02:31:58.6287|ig36Ak|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:31:58.6287|ig36Ak|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:31:58.6287|ig36Ak|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:31:58.6287|ig36Ak|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|02:31:58.6287|ig36Ak|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 10|02:31:58.6287|ig36Ak|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:31:58.6287|ig36Ak|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:31:58.6287|ig36Ak|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|02:31:58.6287|ig36Ak|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:31:58.6287|ig36Ak|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:31:58.6287|ig36Ak|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:31:58.6287|ig36Ak|CJPOWERCAST|imfx v3 API took 0.009s '/api/v3/media/299739/carriers/physical?_dc=1692754329825' t Transfer: 1220 : 10|02:32:00.4778|i7_Mxp|CJPOWERCAST|OAuth: /api/user-group-preferences?keys=googleMapsApiSettings&_dc=1692754331673 t Transfer: 1220 : 10|02:32:00.4778|i7_Mxp|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:32:00.4778|i7_Mxp|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:32:00.4778|i7_Mxp|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:32:00.4778|i7_Mxp|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|02:32:00.4778|i7_Mxp|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:32:00.4778|i7_Mxp|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:32:00.4778|i7_Mxp|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:32:00.4778|i7_Mxp|CJPOWERCAST|imfx v3 API took 0.009s '/api/user-group-preferences?keys=googleMapsApiSettings&_dc=1692754331673' t Transfer: 1220 : 10|02:32:00.6809|KAXr6H|CJPOWERCAST|OAuth: /api/v3/detailsview/VersionDetails/0?lang=en-GB&_dc=1692754331889 t Transfer: 1220 : 10|02:32:00.6809|KAXr6H|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:32:00.6809|KAXr6H|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:32:00.6809|KAXr6H|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:32:00.6809|KAXr6H|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|02:32:00.6809|KAXr6H|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:32:00.6809|KAXr6H|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:32:00.6809|KAXr6H|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|02:32:00.6809|KAXr6H|CJPOWERCAST|GetSystemPref. Pref: DetailsView, Type: -4014, subType: 0 t Information: 1220 : 10|02:32:00.6809|KAXr6H|CJPOWERCAST|GetSystemPref. Pref: DetailsView, Type: -4014, subType: 0 t Verbose: 1220 : 10|02:32:00.6809|KAXr6H|CJPOWERCAST|imfx v3 API took 0.069s '/api/v3/detailsview/VersionDetails/0?lang=en-GB&_dc=1692754331889' t Transfer: 1220 : 10|02:32:01.0871|VMGOVX|CJPOWERCAST|OAuth: /api/v3/version-details/299543?_dc=1692754332345 t Transfer: 1220 : 10|02:32:01.0871|VMGOVX|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:32:01.0871|VMGOVX|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:32:01.0871|VMGOVX|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:32:01.0871|VMGOVX|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|02:32:01.0871|VMGOVX|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:32:01.0871|VMGOVX|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:32:01.0871|VMGOVX|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|02:32:01.0871|VMGOVX|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:32:01.0871|VMGOVX|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:32:01.0871|VMGOVX|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|02:32:01.0871|VMGOVX|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 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 where item_type>0 and rl_deleted=0 and m.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) order by m.title,m.id) a where rownum <= 50) r where rnum >=1 order by rnum t Information: 1220 : 10|02:32:01.0871|VMGOVX|CJPOWERCAST|Running version search. User: 1165 Simple Search: Running Oracle search. Running Oracle search for COUNT Oracle count completed in: 8ms. Returned lines: 1 Oracle version search timing: 55ms. 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 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 where item_type>0 and rl_deleted=0 and m.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) order by m.title,m.id) a where rownum <= 50) r where rnum >=1 order by rnum t Verbose: 1220 : 10|02:32:01.2903|VMGOVX|CJPOWERCAST|imfx v3 API took 0.120s '/api/v3/version-details/299543?_dc=1692754332345' t Transfer: 1220 : 10|02:32:01.6965|IKtTVP|CJPOWERCAST|OAuth: /api/lookups/FriendlyNames?_dc=1692754332918 t Transfer: 1220 : 10|02:32:01.6965|IKtTVP|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:32:01.6965|IKtTVP|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:32:01.6965|IKtTVP|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:32:01.6965|IKtTVP|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 10|02:32:01.6965|IKtTVP|CJPOWERCAST|imfx v3 API took 0.000s '/api/lookups/FriendlyNames?_dc=1692754332918' t Transfer: 1220 : 10|02:32:01.6965|n37lKk|CJPOWERCAST|OAuth: /api/v3/imf/299543?_dc=1692754332995 t Transfer: 1220 : 10|02:32:01.6965|n37lKk|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:32:01.6965|n37lKk|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:32:01.6965|n37lKk|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:32:01.6965|n37lKk|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 10|02:32:01.6965|n37lKk|CJPOWERCAST|imfx v3 API took 0.021s '/api/v3/imf/299543?_dc=1692754332995' t Transfer: 1220 : 10|02:32:01.9010|UINUf0|CJPOWERCAST|OAuth: /api/metadata/1040/299543?_dc=1692754333258 t Transfer: 1220 : 10|02:32:01.9010|UINUf0|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:32:01.9010|UINUf0|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:32:01.9010|UINUf0|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:32:01.9010|UINUf0|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 10|02:32:02.1022|UINUf0|CJPOWERCAST|imfx v3 API took 0.049s '/api/metadata/1040/299543?_dc=1692754333258' t Transfer: 1220 : 10|02:32:06.7923|2dgCcf|CJPOWERCAST|OAuth: /api/v3/search/Media?_dc=1692754337982 t Transfer: 1220 : 10|02:32:06.7923|2dgCcf|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:32:06.7923|2dgCcf|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:32:06.7923|2dgCcf|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:32:06.7923|2dgCcf|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|02:32:06.7923|c8NbMU|CJPOWERCAST|OAuth: /api/v3/search/versions?_dc=1692754337980 t Transfer: 1220 : 10|02:32:06.7923|c8NbMU|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:32:06.7923|c8NbMU|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:32:06.7923|c8NbMU|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:32:06.7923|c8NbMU|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|02:32:06.7923|2dgCcf|CJPOWERCAST|V3Api.SearchMedia t Information: 1220 : 10|02:32:06.7923|2dgCcf|CJPOWERCAST|V3Api.SearchGeneric t Information: 1220 : 10|02:32:06.7923|c8NbMU|CJPOWERCAST|V3Api.SearchVersions t Information: 1220 : 10|02:32:06.7923|c8NbMU|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 10|02:32:06.7923|c8NbMU|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:32:06.7923|c8NbMU|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:32:06.7923|c8NbMU|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|02:32:06.7923|c8NbMU|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:32:06.7923|c8NbMU|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:32:06.7923|c8NbMU|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|02:32:06.7923|2dgCcf|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:32:06.7923|2dgCcf|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:32:06.7923|2dgCcf|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|02:32:06.7923|c8NbMU|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 med.medium_name from TM_CFG_MEDIUM med, TM_PG_ABS pgabs where pgabs.id=m.PGM_ABS_ID and pgabs.MEDIUM_ID = med.id) MEDIUM_TEXT ,(select replace(tmd_str_agg_pipe(cf.form_name),'|',' / ') from TM_PG_FORM_LNX fl join TM_CFG_FORM cf on (cf.id=fl.form_id) where fl.tm_pg_id = m.ID) FORM_TEXT ,(select replace(tmd_str_agg_pipe(dvb.item_name),'|',' / ') from TM_PG_ABS_GENRE_LNX gl join TM_DVB dvb on (dvb.id=gl.genre_id) where gl.tm_pg_abs_id = m.PGM_ABS_ID) GENRE_TEXT, (select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = m.net_grp_id) CHANNEL_GROUP, (select count(id) from tm_mis where item_type>0 and pgm_parent_id=m.id) MEDIA_COUNT, (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 where item_type>0 and rl_deleted=0 and m.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) order by m.title,m.id) a where rownum <= 50) r where rnum >=1 order by rnum t Information: 1220 : 10|02:32:06.7923|2dgCcf|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 m.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 : 10|02:32:07.4063|c8NbMU|CJPOWERCAST|Running version search. User: 1165 Simple Search: Running Oracle search. Running Oracle search for COUNT Oracle count completed in: 1ms. Returned lines: 1 Oracle version search timing: 657ms. 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 med.medium_name from TM_CFG_MEDIUM med, TM_PG_ABS pgabs where pgabs.id=m.PGM_ABS_ID and pgabs.MEDIUM_ID = med.id) MEDIUM_TEXT ,(select replace(tmd_str_agg_pipe(cf.form_name),'|',' / ') from TM_PG_FORM_LNX fl join TM_CFG_FORM cf on (cf.id=fl.form_id) where fl.tm_pg_id = m.ID) FORM_TEXT ,(select replace(tmd_str_agg_pipe(dvb.item_name),'|',' / ') from TM_PG_ABS_GENRE_LNX gl join TM_DVB dvb on (dvb.id=gl.genre_id) where gl.tm_pg_abs_id = m.PGM_ABS_ID) GENRE_TEXT, (select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = m.net_grp_id) CHANNEL_GROUP, (select count(id) from tm_mis where item_type>0 and pgm_parent_id=m.id) MEDIA_COUNT, (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 where item_type>0 and rl_deleted=0 and m.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) order by m.title,m.id) a where rownum <= 50) r where rnum >=1 order by rnum t Verbose: 1220 : 10|02:32:07.4063|c8NbMU|CJPOWERCAST|Alternative title fields query: select * from (select x.id,x.pgm_abs_id TitleId, x.id VersionId from TM_PG_RL 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|02:32:07.4063|c8NbMU|CJPOWERCAST|imfx v3 API took 0.667s '/api/v3/search/versions?_dc=1692754337980' t Verbose: 1220 : 10|02:32:07.6094|2dgCcf|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|02:32:07.6094|2dgCcf|CJPOWERCAST| timing: 00:00:00.8749691 t Verbose: 1220 : 10|02:32:07.6094|2dgCcf|CJPOWERCAST|imfx v3 API took 0.877s '/api/v3/search/Media?_dc=1692754337982' t Transfer: 1220 : 10|02:32:10.2549|MLBXpq|CJPOWERCAST|OAuth: /api/v3/media/299549/carriers/digital?_dc=1692754341577 t Transfer: 1220 : 10|02:32:10.2549|MLBXpq|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:32:10.2549|MLBXpq|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:32:10.2549|MLBXpq|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:32:10.2549|MLBXpq|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|02:32:10.2549|MLBXpq|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 10|02:32:10.2549|MLBXpq|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:32:10.2549|MLBXpq|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:32:10.2549|MLBXpq|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|02:32:10.2549|MLBXpq|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:32:10.2549|MLBXpq|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:32:10.2549|MLBXpq|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|02:32:10.4593|MLBXpq|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|02:32:10.6625|MLBXpq|CJPOWERCAST|imfx v3 API took 0.324s '/api/v3/media/299549/carriers/digital?_dc=1692754341577' t Transfer: 1220 : 10|02:32:40.0103|sFdA_t|CJPOWERCAST|OAuth: /api/user-group-preferences?keys=googleMapsApiSettings&_dc=1692754371354 t Transfer: 1220 : 10|02:32:40.0103|sFdA_t|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:32:40.0103|sFdA_t|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:32:40.0103|sFdA_t|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:32:40.0103|sFdA_t|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|02:32:40.0103|sFdA_t|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:32:40.0103|sFdA_t|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:32:40.0103|sFdA_t|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:32:40.0103|sFdA_t|CJPOWERCAST|imfx v3 API took 0.004s '/api/user-group-preferences?keys=googleMapsApiSettings&_dc=1692754371354' t Transfer: 1220 : 10|02:32:40.2188|iZqnNp|CJPOWERCAST|OAuth: /api/v3/media-details/299549?_dc=1692754371379 t Transfer: 1220 : 10|02:32:40.2188|iZqnNp|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:32:40.2188|iZqnNp|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:32:40.2188|iZqnNp|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:32:40.2188|iZqnNp|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|02:32:40.2188|iZqnNp|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:32:40.2188|iZqnNp|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:32:40.2188|iZqnNp|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|02:32:40.6276|||TM_MIS. LoadSubtitles for ID: 299549 t Information: 1220 : 10|02:32:40.6276|||TM_MIS. LoadSubtitles for ID: 299549. SQL: 'select m.id, m.m_ctnr_id, m.m_ctnr_loc, m.modified_dt, m.tv_std, m.m_ctnr_fmt_id, d.sub_folder, nvl((select max(l.language) from tm_audio l where l.miid=m.id),aud_language_id) aud_language_id from tm_mis m left join tm_dfile d on (m.externally_owned_id=d.id) where m.mi_deleted=0 and m.item_type>0 and m.media_type=101 and m.PGM_PARENT_ID=299543' t Information: 1220 : 10|02:32:40.8308||| Subtitles added for ID: 299549, 291723 English : 'https://imfxv3tm.tmd.tv/getcaptions.aspx?f=inside game of thrones.stl&sf=&som=07:30:05:13&storage=TimedText&modified=637469339590000000&tcf=0&id=291723&tmp=0&format=WebVTT'. t Verbose: 1220 : 10|02:32:40.8308|iZqnNp|CJPOWERCAST|imfx v3 API took 0.722s '/api/v3/media-details/299549?_dc=1692754371379' t Transfer: 1220 : 10|02:32:40.8308|iZqnNp|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0156.mp4 subfolder t Transfer: 1220 : 10|02:32:40.8308|iZqnNp|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156.mp4 t Transfer: 1220 : 10|02:32:40.8308|iZqnNp|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156.mp4 t Transfer: 1220 : 10|02:32:40.8308|iZqnNp|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:32:40.8308|iZqnNp|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:32:40.8308|iZqnNp|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|02:32:41.2395|u0gFMs|CJPOWERCAST|OAuth: /api/v3/detailsview/MediaDetails/5?lang=en-GB&_dc=1692754372464 t Transfer: 1220 : 10|02:32:41.2395|u0gFMs|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:32:41.2395|u0gFMs|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:32:41.2395|u0gFMs|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:32:41.2395|u0gFMs|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|02:32:41.2395|u0gFMs|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:32:41.2395|u0gFMs|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:32:41.2395|u0gFMs|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|02:32:41.2395|u0gFMs|CJPOWERCAST|GetSystemPref. Pref: DetailsView, Type: -4013, subType: 5 t Information: 1220 : 10|02:32:41.2395|u0gFMs|CJPOWERCAST|GetSystemPref. Pref: DetailsView, Type: -4013, subType: 0 t Information: 1220 : 10|02:32:41.2395|u0gFMs|CJPOWERCAST|GetSystemPref. Pref: DetailsView, Type: -4013, subType: 5 t Information: 1220 : 10|02:32:41.2395|u0gFMs|CJPOWERCAST|GetSystemPref. Pref: DetailsView, Type: -4013, subType: 0 t Verbose: 1220 : 10|02:32:41.2395|u0gFMs|CJPOWERCAST|imfx v3 API took 0.029s '/api/v3/detailsview/MediaDetails/5?lang=en-GB&_dc=1692754372464' t Transfer: 1220 : 10|02:32:41.4426|q6iDqN|CJPOWERCAST|OAuth: /api/v3/media-captions/299549?_dc=1692754372780 t Transfer: 1220 : 10|02:32:41.4426|q6iDqN|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:32:41.4426|q6iDqN|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:32:41.4426|q6iDqN|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:32:41.4426|q6iDqN|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|02:32:41.6457|1BidP~|CJPOWERCAST|OAuth: /api/v3/mediavideo/299549?info=smudge,scene,audiovolume&_dc=1692754372842 t Transfer: 1220 : 10|02:32:41.6457|1BidP~|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:32:41.6457|1BidP~|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:32:41.6457|1BidP~|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:32:41.6457|1BidP~|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|02:32:41.6457|_xUXcQ|CJPOWERCAST|OAuth: /api/user-group-preferences?keys=googleMapsApiSettings&_dc=1692754372846 t Transfer: 1220 : 10|02:32:41.6457|_xUXcQ|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:32:41.6457|_xUXcQ|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:32:41.6457|_xUXcQ|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:32:41.6457|_xUXcQ|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|02:32:41.6457|_xUXcQ|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:32:41.6457|_xUXcQ|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:32:41.6457|_xUXcQ|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:32:41.6457|_xUXcQ|CJPOWERCAST|imfx v3 API took 0.007s '/api/user-group-preferences?keys=googleMapsApiSettings&_dc=1692754372846' t Transfer: 1220 : 10|02:32:41.6457|1BidP~|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0156.mp4 subfolder t Transfer: 1220 : 10|02:32:41.6457|1BidP~|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156.mp4 t Transfer: 1220 : 10|02:32:41.6457|1BidP~|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156.mp4 t Transfer: 1220 : 10|02:32:41.6457|1BidP~|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:32:41.6457|1BidP~|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:32:41.6457|1BidP~|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:32:41.6457|q6iDqN|CJPOWERCAST|imfx v3 API took 0.113s '/api/v3/media-captions/299549?_dc=1692754372780' t Verbose: 1220 : 10|02:32:41.6457|1BidP~|CJPOWERCAST|imfx v3 API took 0.131s '/api/v3/mediavideo/299549?info=smudge,scene,audiovolume&_dc=1692754372842' t Transfer: 1220 : 10|02:32:41.8501|Os4oV3|CJPOWERCAST|OAuth: /api/lookups/FriendlyNames?_dc=1692754373086 t Transfer: 1220 : 10|02:32:41.8501|Os4oV3|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:32:41.8501|Os4oV3|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:32:41.8501|Os4oV3|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:32:41.8501|Os4oV3|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 10|02:32:41.8501|Os4oV3|CJPOWERCAST|imfx v3 API took 0.000s '/api/lookups/FriendlyNames?_dc=1692754373086' t Transfer: 1220 : 10|02:32:42.0566|pqlZhL|CJPOWERCAST|OAuth: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1692754373250 t Transfer: 1220 : 10|02:32:42.0566|pqlZhL|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:32:42.0566|pqlZhL|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:32:42.0566|pqlZhL|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:32:42.0566|pqlZhL|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|02:32:42.0566|pqlZhL|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:32:42.0566|pqlZhL|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:32:42.0566|pqlZhL|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|02:32:42.0566|n6zKgj|CJPOWERCAST|OAuth: /api/settings/user/videoPlayerSettings?_dc=1692754373258 t Transfer: 1220 : 10|02:32:42.0566|n6zKgj|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:32:42.0566|n6zKgj|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:32:42.0566|n6zKgj|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:32:42.0566|n6zKgj|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|02:32:42.0566|n6zKgj|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:32:42.0566|n6zKgj|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:32:42.0566|n6zKgj|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:32:42.0566|pqlZhL|CJPOWERCAST|imfx v3 API took 0.009s '/api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1692754373250' t Verbose: 1220 : 10|02:32:42.0566|n6zKgj|CJPOWERCAST|imfx v3 API took 0.005s '/api/settings/user/videoPlayerSettings?_dc=1692754373258' t Transfer: 1220 : 10|02:32:42.2665|8eQH9P|CJPOWERCAST|OAuth: /api/v3/subtitles/291723?sf=&f=inside%20game%20of%20thrones.stl&tcf=0&storage=TimedText&modified=637469339590000000&_dc=1692754373476 t Transfer: 1220 : 10|02:32:42.2665|8eQH9P|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:32:42.2665|8eQH9P|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:32:42.2665|8eQH9P|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:32:42.2665|8eQH9P|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|02:32:42.2665|8eQH9P|CJPOWERCAST|LoadSubtitlesById. filename inside game of thrones.stl device TimedText frame rate Pal t Information: 1220 : 10|02:32:42.2665|8eQH9P|CJPOWERCAST|LoadSubtitlesById. Filename: inside game of thrones.stl. Device TimedText. Timecode format Pal. Media ID 291723. t Information: 1220 : 10|02:32:42.2665|8eQH9P|CJPOWERCAST|GetCaptions. Start. Filename: inside game of thrones.stl. SubFolder: . Cache path C:\inetpub\wwwroot\imfxcore\timedtextcache\. Storage path \\192.168.120.254\DemoFS\Digital Assets\TimedText. Last Modified 1/22/2021 5:39:19 PM. Convert to Real Time False t Information: 1220 : 10|02:32:42.2665|8eQH9P|CJPOWERCAST|GetCaptions. Convert required. Som 00:00:00. From: \\192.168.120.254\DemoFS\Digital Assets\TimedText\inside game of thrones.stl to: C:\inetpub\wwwroot\imfxcore\timedtextcache\inside game of thrones.stl_pal_291723.xml t Information: 1220 : 10|02:32:42.2665|8eQH9P|CJPOWERCAST|GetCaptions. Convertor lock acquired. t Transfer: 1220 : 10|02:32:42.2665|B49rDR|CJPOWERCAST|OAuth: /api/v3/ai-tags/299549?_dc=1692754373513 t Transfer: 1220 : 10|02:32:42.2665|B49rDR|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:32:42.2665|B49rDR|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:32:42.2665|B49rDR|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:32:42.2665|B49rDR|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|02:32:42.2665|B49rDR|CJPOWERCAST|V3Api.GetMediaAiTags t Transfer: 1220 : 10|02:32:42.2665|LOPHsV|CJPOWERCAST|OAuth: /api/v3/mediavideo/299549?info=smudge&_dc=1692754373520 t Transfer: 1220 : 10|02:32:42.2665|LOPHsV|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:32:42.2665|LOPHsV|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:32:42.2665|LOPHsV|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:32:42.2665|LOPHsV|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|02:32:42.2665|LOPHsV|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0156.mp4 subfolder t Transfer: 1220 : 10|02:32:42.2665|LOPHsV|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156.mp4 t Transfer: 1220 : 10|02:32:42.2665|LOPHsV|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156.mp4 t Transfer: 1220 : 10|02:32:42.2665|LOPHsV|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|02:32:42.2665|LOPHsV|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|02:32:42.2665|LOPHsV|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|02:32:42.2665|B49rDR|CJPOWERCAST|imfx v3 API took 0.027s '/api/v3/ai-tags/299549?_dc=1692754373513' t Verbose: 1220 : 10|02:32:42.2665|LOPHsV|CJPOWERCAST|imfx v3 API took 0.022s '/api/v3/mediavideo/299549?info=smudge&_dc=1692754373520' t Information: 1220 : 10|02:32:42.7197|8eQH9P|CJPOWERCAST|GetCaptions. File converted: \\192.168.120.254\DemoFS\Digital Assets\TimedText\inside game of thrones.stl. Result: True t Information: 1220 : 10|02:32:42.7197|8eQH9P|CJPOWERCAST|GetCaptions. In cache. Filename: C:\inetpub\wwwroot\imfxcore\timedtextcache\inside game of thrones.stl_pal_291723.xml t Information: 1220 : 10|02:32:42.7197|8eQH9P|CJPOWERCAST|LoadSubtitlesById. Convertor lock acquired. t Information: 1220 : 10|02:32:42.9385|8eQH9P|CJPOWERCAST|LoadSubtitlesById got 43 lines. t Verbose: 1220 : 10|02:32:42.9385|8eQH9P|CJPOWERCAST|imfx v3 API took 0.691s '/api/v3/subtitles/291723?sf=&f=inside%20game%20of%20thrones.stl&tcf=0&storage=TimedText&modified=637469339590000000&_dc=1692754373476' t Information: 1220 : 10|02:32:43.1415|0FHlPz||GetCaptionsForWeb. Filename: inside game of thrones.stl. SubFolder . Device TimedText. Format WebVTT. Timecode format Pal. Media ID 291723. Last Modified 1/22/2021 5:39:19 PM t Information: 1220 : 10|02:32:43.1415|0FHlPz||GetCaptions. Start. Filename: inside game of thrones.stl. SubFolder: . Cache path C:\inetpub\wwwroot\imfxcore\timedtextcache\. Storage path \\192.168.120.254\DemoFS\Digital Assets\TimedText. Last Modified 1/22/2021 5:39:19 PM. Convert to Real Time True t Information: 1220 : 10|02:32:43.1415|0FHlPz||GetCaptions. Convert required. Som 07:30:05.5200000. From: \\192.168.120.254\DemoFS\Digital Assets\TimedText\inside game of thrones.stl to: C:\inetpub\wwwroot\imfxcore\timedtextcache\inside game of thrones.stl_pal_291723_rt.vtt t Information: 1220 : 10|02:32:43.1415|0FHlPz||GetCaptions. Convertor lock acquired. t Information: 1220 : 10|02:32:43.1415|0FHlPz||GetCaptions. File converted: \\192.168.120.254\DemoFS\Digital Assets\TimedText\inside game of thrones.stl. Result: True t Information: 1220 : 10|02:32:43.1415|0FHlPz||GetCaptions. In cache. Filename: C:\inetpub\wwwroot\imfxcore\timedtextcache\inside game of thrones.stl_pal_291723_rt.vtt t Transfer: 1220 : 10|09:07:29.2836|6Q4k9y|CJPOWERCAST|OAuth: /api/logout?_dc=1692778060103 t Transfer: 1220 : 10|09:07:29.2836|6Q4k9y|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:07:29.2836|6Q4k9y|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:07:29.2836|6Q4k9y|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:07:29.2836|6Q4k9y|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|09:07:29.2836|6Q4k9y|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:07:29.2836|6Q4k9y|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:07:29.2836|6Q4k9y|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|09:07:29.2836|6Q4k9y|CJPOWERCAST|LogoutUser. Logging out user 'CJPOWERCAST' t Verbose: 1220 : 10|09:07:29.2836|6Q4k9y|CJPOWERCAST|imfx v3 API took 0.011s '/api/logout?_dc=1692778060103' t Transfer: 1220 : 10|09:07:29.6946|yDiJv5||GetAppInfo. DB: TMDDEMO. Install mode: . Auth types: Native, PublicApiKey t Verbose: 1220 : 10|09:07:29.8978|eJ6x5z||imfx v3 API took 0.005s '/api/v3/visual-asset/group/PnqJC_/2/image' t Transfer: 1220 : 10|12:21:16.2546|~nq5Fj||GetAppInfo. DB: TMDDEMO. Install mode: . Auth types: Native, PublicApiKey t Information: 1220 : 10|12:21:16.4633|YNp3qt||GetCache. t Information: 1220 : 10|12:21:16.4633|YNp3qt||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\108_2_PnqJC_.png t Information: 1220 : 10|12:21:16.4633|YNp3qt||GetCache. Data read: 154944 t Verbose: 1220 : 10|12:21:16.4633|YNp3qt||imfx v3 API took 0.004s '/api/v3/visual-asset/group/PnqJC_/2/image' t Transfer: 1220 : 10|15:11:57.9840|4IohIw||GetAppInfo. DB: TMDDEMO. Install mode: . Auth types: Native, PublicApiKey t Verbose: 1220 : 10|15:11:57.9840|h8psqb||imfx v3 API took 0.004s '/api/v3/visual-asset/group/PnqJC_/2/image' t Information: 1220 : 10|17:48:19.6969|||OrabitWatcherBasic. Disposing. t Information: 1220 : 10|17:48:19.6969|||OrabitWatcherBasic. Disposed. t Information: 1220 : 10|17:48:19.6969|||========================================================================== t Information: 1220 : 10|17:48:19.6969|||IMFX CORE SERVER APPLICATION END.