t Transfer: 1220 : 12|02:36:08.3446|xiSiR5||OAuth: /api/logout?_dc=1688002568356 t Transfer: 1220 : 12|02:36:08.3456|xiSiR5||GetCurrentUser.. t Transfer: 1220 : 12|02:36:08.3456|xiSiR5|| OAuth authenticated t Verbose: 1220 : 12|02:36:08.3456|xiSiR5|| uid claim is missing.. t Information: 1220 : 12|02:36:08.3456|xiSiR5||OAuth. AutoLogin no Windows identity type WindowsIdentity t Transfer: 1220 : 12|02:36:08.7476|1Cj4s2||GetAppInfo. DB: TMDDEMO. Install mode: . Auth types: Native, PublicApiKey t Verbose: 1220 : 12|02:36:09.3506|~N9fVs||imfx v3 API took 0.108s '/api/v3/visual-asset/group/PnqJC_/2/image' t Verbose: 1220 : 12|02:36:10.3566|GYzgVU||Oauth validating.. t Verbose: 1220 : 12|02:36:10.3566|GYzgVU||GrantResourceOwnerCredentials. t Verbose: 1220 : 12|02:36:10.3566|GYzgVU||LoginUser. cjpowercast, login type OAuth, encrypt password True t Information: 1220 : 12|02:36:10.3566|GYzgVU||TryLoginUser. cjpowercast, login type OAuth, check password True, check hash False, encrypt password True, load user data False t Information: 1220 : 12|02:36:10.7586|GYzgVU|| oauth token 00000000-0000-0000-0000-000000000000 t Information: 1220 : 12|02:36:10.7586|GYzgVU||TryLoginUser. Logged in.. t Information: 1220 : 12|02:36:10.9596|GYzgVU||GetPasswordPolicy. WARNING: Policy not found for system Imediaflex. Validation disabled. t Verbose: 1220 : 12|02:36:10.9596|GYzgVU||LoginUser. Adding history. User Id 1165, result CJPOWERCAST, host 192.168.127.6 t Verbose: 1220 : 12|02:36:10.9596|GYzgVU||GrantResourceOwnerCredentials. Try login finished. Logged: True t Transfer: 1220 : 12|02:36:11.5626|ssxd3w|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=1688002572443 t Transfer: 1220 : 12|02:36:11.5626|ssxd3w|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:36:11.5626|ssxd3w|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:36:11.5626|ssxd3w|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|02:36:11.5626|ssxd3w|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|02:36:11.5626|ssxd3w|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:36:11.5626|ssxd3w|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:36:11.5636|ssxd3w|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|02:36:11.5636|ssxd3w|CJPOWERCAST|imfx v3 API took 0.055s '/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=1688002572443' t Transfer: 1220 : 12|02:36:11.7646|vof2lO|CJPOWERCAST|OAuth: /api/user-preferences?keys=personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch;workflow_queues_actions;workflow_queues_settings&_dc=1688002572808 t Transfer: 1220 : 12|02:36:11.7646|vof2lO|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:36:11.7646|vof2lO|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:36:11.7646|vof2lO|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|02:36:11.7646|vof2lO|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|02:36:11.7646|vof2lO|CJPOWERCAST|GetUserDataByKeys: personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch;workflow_queues_actions;workflow_queues_settings t Transfer: 1220 : 12|02:36:11.7646|vof2lO|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:36:11.7656|vof2lO|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:36:11.7656|vof2lO|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|02:36:11.9666|vof2lO|CJPOWERCAST|imfx v3 API took 0.051s '/api/user-preferences?keys=personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch;workflow_queues_actions;workflow_queues_settings&_dc=1688002572808' t Information: 1220 : 12|02:36:12.1676|WpBWlR|CJPOWERCAST|GetUserProfile. Id: 0 t Transfer: 1220 : 12|02:36:12.1676|WpBWlR|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:36:12.1676|WpBWlR|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:36:12.1676|WpBWlR|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|02:36:12.5696|83e3XF|CJPOWERCAST|OAuth: /api/settings/user/mainMenuSettings?_dc=1688002573568 t Transfer: 1220 : 12|02:36:12.5696|83e3XF|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:36:12.5696|83e3XF|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:36:12.5696|83e3XF|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|02:36:12.5696|83e3XF|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|02:36:12.5706|zDUhd4|CJPOWERCAST|OAuth: /api/settings/group/0?_dc=1688002573567 t Transfer: 1220 : 12|02:36:12.5706|zDUhd4|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:36:12.5706|zDUhd4|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:36:12.5706|zDUhd4|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|02:36:12.5706|zDUhd4|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|02:36:12.5706|83e3XF|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:36:12.5706|83e3XF|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:36:12.5706|83e3XF|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|02:36:12.5706|XHEyr_|CJPOWERCAST|OAuth: /api/settings/user/uploadSettings?_dc=1688002573573 t Transfer: 1220 : 12|02:36:12.5706|XHEyr_|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:36:12.5706|XHEyr_|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:36:12.5716|XHEyr_|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|02:36:12.5716|XHEyr_|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|02:36:12.5716|9O9nA4|CJPOWERCAST|OAuth: /api/settings/group/0?_dc=1688002573588 t Transfer: 1220 : 12|02:36:12.5716|9O9nA4|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:36:12.5716|9O9nA4|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:36:12.5716|9O9nA4|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|02:36:12.5716|9O9nA4|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 12|02:36:12.7726|83e3XF|CJPOWERCAST|imfx v3 API took 0.092s '/api/settings/user/mainMenuSettings?_dc=1688002573568' t Transfer: 1220 : 12|02:36:12.7726|XHEyr_|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:36:12.7726|XHEyr_|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:36:12.7726|XHEyr_|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|02:36:12.7726|XHEyr_|CJPOWERCAST|imfx v3 API took 0.009s '/api/settings/user/uploadSettings?_dc=1688002573573' t Transfer: 1220 : 12|02:36:12.9736|Nxcl9f|CJPOWERCAST|OAuth: /api/settings/user/mainMenuSettings?_dc=1688002573588 t Transfer: 1220 : 12|02:36:12.9736|Nxcl9f|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:36:12.9736|Nxcl9f|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:36:12.9736|Nxcl9f|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|02:36:12.9736|Nxcl9f|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|02:36:12.9736|Nxcl9f|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:36:12.9736|Nxcl9f|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:36:12.9746|Nxcl9f|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|02:36:12.9746|Nxcl9f|CJPOWERCAST|imfx v3 API took 0.004s '/api/settings/user/mainMenuSettings?_dc=1688002573588' t Verbose: 1220 : 12|02:36:12.9746|9O9nA4|CJPOWERCAST|imfx v3 API took 0.289s '/api/settings/group/0?_dc=1688002573588' t Verbose: 1220 : 12|02:36:12.9746|zDUhd4|CJPOWERCAST|imfx v3 API took 0.375s '/api/settings/group/0?_dc=1688002573567' t Verbose: 1220 : 12|02:36:12.9746|hkmYZR||imfx v3 API took 0.004s '/api/v3/visual-asset/group/Any_gO/0/image' t Transfer: 1220 : 12|02:36:13.1756|qpLhfq|CJPOWERCAST|OAuth: /api/lookups/MediaStatus?_dc=1688002573596 t Transfer: 1220 : 12|02:36:13.1756|qpLhfq|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:36:13.1756|qpLhfq|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:36:13.1756|qpLhfq|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|02:36:13.1756|qpLhfq|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|02:36:13.1756|TDAbXV|CJPOWERCAST|OAuth: /api/lookups/PgmStatus?_dc=1688002573597 t Transfer: 1220 : 12|02:36:13.1756|TDAbXV|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:36:13.1756|TDAbXV|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:36:13.1766|TDAbXV|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|02:36:13.1766|TDAbXV|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|02:36:13.1766|AZzcMO|CJPOWERCAST|OAuth: /api/lookup/CustomMediaStatusTypes?_dc=1688002573598 t Transfer: 1220 : 12|02:36:13.1766|AZzcMO|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:36:13.1766|AZzcMO|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:36:13.1766|AZzcMO|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|02:36:13.1766|AZzcMO|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 12|02:36:13.1766|qpLhfq|CJPOWERCAST|imfx v3 API took 0.033s '/api/lookups/MediaStatus?_dc=1688002573596' t Verbose: 1220 : 12|02:36:13.1766|TDAbXV|CJPOWERCAST|imfx v3 API took 0.033s '/api/lookups/PgmStatus?_dc=1688002573597' t Verbose: 1220 : 12|02:36:13.3776|AZzcMO|CJPOWERCAST|imfx v3 API took 0.048s '/api/lookup/CustomMediaStatusTypes?_dc=1688002573598' t Transfer: 1220 : 12|02:36:13.3776|ILuaga|CJPOWERCAST|OAuth: /api/lookup/CustomVersionStatusTypes?_dc=1688002573598 t Transfer: 1220 : 12|02:36:13.3776|ILuaga|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:36:13.3776|ILuaga|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:36:13.3776|ILuaga|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|02:36:13.3776|ILuaga|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 12|02:36:13.3776|ILuaga|CJPOWERCAST|imfx v3 API took 0.036s '/api/lookup/CustomVersionStatusTypes?_dc=1688002573598' t Transfer: 1220 : 12|02:36:13.5795|dD3o0t|CJPOWERCAST|OAuth: /api/lookup/CustomTitleStatusTypes?_dc=1688002573599 t Transfer: 1220 : 12|02:36:13.5795|dD3o0t|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:36:13.5795|dD3o0t|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:36:13.5795|dD3o0t|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|02:36:13.5795|dD3o0t|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|02:36:13.5795|Izjn82|CJPOWERCAST|OAuth: /api/settings/user/defaultHomePage?_dc=1688002573600 t Transfer: 1220 : 12|02:36:13.5795|Izjn82|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:36:13.5806|Izjn82|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:36:13.5806|Izjn82|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|02:36:13.5806|Izjn82|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|02:36:13.5806|Izjn82|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:36:13.5806|Izjn82|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:36:13.5806|Izjn82|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|02:36:13.5806|Izjn82|CJPOWERCAST|imfx v3 API took 0.009s '/api/settings/user/defaultHomePage?_dc=1688002573600' t Verbose: 1220 : 12|02:36:13.5806|dD3o0t|CJPOWERCAST|imfx v3 API took 0.011s '/api/lookup/CustomTitleStatusTypes?_dc=1688002573599' t Verbose: 1220 : 12|02:36:13.5806|ETjJLx||imfx v3 API took 0.003s '/api/v3/visual-asset/group/Any_gO/1/image' t Transfer: 1220 : 12|02:36:14.3845|h4OPGD|CJPOWERCAST|OAuth: /api/lookups/SearchSupportedOperators?_dc=1688002575274 t Transfer: 1220 : 12|02:36:14.3845|h4OPGD|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:36:14.3845|umR7bb|CJPOWERCAST|OAuth: /api/user-preferences?keys=adv.recent.searches.titles&_dc=1688002575276 t Transfer: 1220 : 12|02:36:14.3845|h4OPGD|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:36:14.3845|umR7bb|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:36:14.3845|umR7bb|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:36:14.3845|h4OPGD|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|02:36:14.3845|h4OPGD|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|02:36:14.3855|umR7bb|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|02:36:14.3855|umR7bb|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|02:36:14.3855|umR7bb|CJPOWERCAST|GetUserDataByKeys: adv.recent.searches.titles t Transfer: 1220 : 12|02:36:14.3855|umR7bb|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:36:14.3855|umR7bb|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:36:14.3855|umR7bb|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|02:36:14.3855|h4OPGD|CJPOWERCAST|imfx v3 API took 0.000s '/api/lookups/SearchSupportedOperators?_dc=1688002575274' t Transfer: 1220 : 12|02:36:14.3855|YF8l4S|CJPOWERCAST|OAuth: /api/view/searchinfo/TitleSearch?_dc=1688002575273 t Transfer: 1220 : 12|02:36:14.3855|YF8l4S|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:36:14.3855|YF8l4S|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:36:14.3865|YF8l4S|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|02:36:14.3865|YF8l4S|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 12|02:36:14.3865|umR7bb|CJPOWERCAST|imfx v3 API took 0.007s '/api/user-preferences?keys=adv.recent.searches.titles&_dc=1688002575276' t Information: 1220 : 12|02:36:14.3865|YF8l4S|CJPOWERCAST|GetAdvSearchColumns. search type TitleSearch grid . t Verbose: 1220 : 12|02:36:14.3865|YF8l4S|CJPOWERCAST|imfx v3 API took 0.001s '/api/view/searchinfo/TitleSearch?_dc=1688002575273' t Transfer: 1220 : 12|02:36:14.3865|neDIKY|CJPOWERCAST|OAuth: /api/view/searches/TitleSearch?_dc=1688002575317 t Transfer: 1220 : 12|02:36:14.3865|neDIKY|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:36:14.3865|neDIKY|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:36:14.3865|neDIKY|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|02:36:14.3865|neDIKY|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|02:36:14.3875|neDIKY|CJPOWERCAST|GetSavedSearchNames. search type TitleSearch. t Transfer: 1220 : 12|02:36:14.3875|neDIKY|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:36:14.3875|neDIKY|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:36:14.3875|neDIKY|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|02:36:14.3875|mNRwOu|CJPOWERCAST|OAuth: /api/view/info/VersionGrid?lang=en-GB&_dc=1688002575329 t Transfer: 1220 : 12|02:36:14.3875|mNRwOu|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:36:14.3875|mNRwOu|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:36:14.3875|mNRwOu|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|02:36:14.3875|mNRwOu|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|02:36:14.3875|mNRwOu|CJPOWERCAST|GetGridViewBuilder. builder type VersionGrid. t Transfer: 1220 : 12|02:36:14.3885|mNRwOu|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:36:14.3885|mNRwOu|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:36:14.3885|mNRwOu|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|02:36:14.3885|mNRwOu|CJPOWERCAST|UserGridView. LoadView. ID -2, Name Default. t Transfer: 1220 : 12|02:36:14.3885|mNRwOu|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:36:14.3885|mNRwOu|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:36:14.3885|mNRwOu|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|02:36:14.3885|neDIKY|CJPOWERCAST|imfx v3 API took 0.043s '/api/view/searches/TitleSearch?_dc=1688002575317' t Transfer: 1220 : 12|02:36:14.3885|mNRwOu|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:36:14.3885|mNRwOu|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:36:14.3895|mNRwOu|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|02:36:14.3895|e~0xgv|CJPOWERCAST|OAuth: /api/view/info/MediaGrid?lang=en-GB&_dc=1688002575384 t Transfer: 1220 : 12|02:36:14.3895|e~0xgv|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:36:14.3895|e~0xgv|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:36:14.3895|e~0xgv|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|02:36:14.3895|e~0xgv|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|02:36:14.3895|e~0xgv|CJPOWERCAST|GetGridViewBuilder. builder type MediaGrid. t Transfer: 1220 : 12|02:36:14.3895|e~0xgv|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:36:14.3895|e~0xgv|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:36:14.3895|e~0xgv|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|02:36:14.3905|e~0xgv|CJPOWERCAST|UserGridView. LoadView. ID -2, Name Default. t Transfer: 1220 : 12|02:36:14.3905|e~0xgv|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:36:14.3905|e~0xgv|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:36:14.3905|e~0xgv|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|02:36:14.3905|e~0xgv|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:36:14.3905|e~0xgv|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:36:14.3905|e~0xgv|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|02:36:14.3905|e~0xgv|CJPOWERCAST|imfx v3 API took 0.010s '/api/view/info/MediaGrid?lang=en-GB&_dc=1688002575384' t Verbose: 1220 : 12|02:36:14.3905|mNRwOu|CJPOWERCAST|imfx v3 API took 0.068s '/api/view/info/VersionGrid?lang=en-GB&_dc=1688002575329' t Transfer: 1220 : 12|02:36:14.5915|9WcT6w|CJPOWERCAST|OAuth: /api/view/info/DigitalCarriers?lang=en-GB&_dc=1688002575415 t Transfer: 1220 : 12|02:36:14.5915|9WcT6w|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:36:14.5915|9WcT6w|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:36:14.5915|9WcT6w|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|02:36:14.5915|9WcT6w|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|02:36:14.5915|9WcT6w|CJPOWERCAST|GetGridViewBuilder. builder type DigitalCarriers. t Transfer: 1220 : 12|02:36:14.5915|9WcT6w|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:36:14.5926|9WcT6w|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:36:14.5926|9WcT6w|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|02:36:14.5926|VtjWFt|CJPOWERCAST|OAuth: /api/view/info/TitleTree?lang=en-GB&_dc=1688002575442 t Transfer: 1220 : 12|02:36:14.5926|VtjWFt|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:36:14.5926|VtjWFt|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:36:14.5926|VtjWFt|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|02:36:14.5926|VtjWFt|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|02:36:14.5926|9WcT6w|CJPOWERCAST|UserGridView. LoadView. ID -2, Name Default. t Transfer: 1220 : 12|02:36:14.5926|9WcT6w|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:36:14.5926|9WcT6w|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:36:14.5936|9WcT6w|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|02:36:14.5936|VtjWFt|CJPOWERCAST|GetGridViewBuilder. builder type TitleTree. t Transfer: 1220 : 12|02:36:14.5936|VtjWFt|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:36:14.5936|VtjWFt|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:36:14.5936|VtjWFt|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|02:36:14.5936|9WcT6w|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:36:14.5936|9WcT6w|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:36:14.5936|9WcT6w|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|02:36:14.5936|VtjWFt|CJPOWERCAST|UserGridView. LoadView. ID -2, Name Default. t Transfer: 1220 : 12|02:36:14.5936|VtjWFt|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:36:14.5946|VtjWFt|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:36:14.5946|VtjWFt|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|02:36:14.5946|9WcT6w|CJPOWERCAST|imfx v3 API took 0.008s '/api/view/info/DigitalCarriers?lang=en-GB&_dc=1688002575415' t Transfer: 1220 : 12|02:36:14.5946|VtjWFt|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:36:14.5946|VtjWFt|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:36:14.5946|VtjWFt|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|02:36:14.5946|VtjWFt|CJPOWERCAST|imfx v3 API took 0.008s '/api/view/info/TitleTree?lang=en-GB&_dc=1688002575442' t Transfer: 1220 : 12|02:36:18.0106|uUOIXg|CJPOWERCAST|OAuth: /api/settings/user/startSearch?_dc=1688002578795 t Transfer: 1220 : 12|02:36:18.0106|uUOIXg|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:36:18.0106|uUOIXg|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:36:18.0106|uUOIXg|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|02:36:18.0106|uUOIXg|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|02:36:18.0106|uUOIXg|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:36:18.0116|uUOIXg|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:36:18.0116|uUOIXg|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|02:36:18.0116|jcStME|CJPOWERCAST|OAuth: /api/settings/user/defaultSearch?_dc=1688002578794 t Transfer: 1220 : 12|02:36:18.0116|jcStME|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:36:18.0116|jcStME|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:36:18.0116|jcStME|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|02:36:18.0116|jcStME|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|02:36:18.0116|jcStME|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:36:18.0116|jcStME|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:36:18.0116|jcStME|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|02:36:18.0125|uUOIXg|CJPOWERCAST|imfx v3 API took 0.009s '/api/settings/user/startSearch?_dc=1688002578795' t Verbose: 1220 : 12|02:36:18.0125|jcStME|CJPOWERCAST|imfx v3 API took 0.009s '/api/settings/user/defaultSearch?_dc=1688002578794' t Transfer: 1220 : 12|02:36:18.2136|BlgVlH|CJPOWERCAST|OAuth: /api/user-preferences?keys=consumer.recent.data&_dc=1688002579205 t Transfer: 1220 : 12|02:36:18.2136|BlgVlH|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:36:18.2136|BlgVlH|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:36:18.2136|BlgVlH|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|02:36:18.2136|BlgVlH|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|02:36:18.2136|Ca_EbZ|CJPOWERCAST|OAuth: /api/user-preferences?keys=adv.recent.searches.consumer&_dc=1688002579206 t Transfer: 1220 : 12|02:36:18.2146|Ca_EbZ|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:36:18.2146|Ca_EbZ|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:36:18.2146|Ca_EbZ|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|02:36:18.2146|Ca_EbZ|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|02:36:18.2146|BlgVlH|CJPOWERCAST|GetUserDataByKeys: consumer.recent.data t Transfer: 1220 : 12|02:36:18.2146|BlgVlH|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:36:18.2146|BlgVlH|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:36:18.2146|BlgVlH|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|02:36:18.2146|Ca_EbZ|CJPOWERCAST|GetUserDataByKeys: adv.recent.searches.consumer t Transfer: 1220 : 12|02:36:18.2146|Ca_EbZ|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:36:18.2156|Ca_EbZ|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:36:18.2156|Ca_EbZ|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|02:36:18.2156|qKZInR||imfx v3 API took 0.004s '/api/v3/visual-asset/group/Any_gO/3/image' t Verbose: 1220 : 12|02:36:18.2156|Ca_EbZ|CJPOWERCAST|imfx v3 API took 0.008s '/api/user-preferences?keys=adv.recent.searches.consumer&_dc=1688002579206' t Verbose: 1220 : 12|02:36:18.2156|BlgVlH|CJPOWERCAST|imfx v3 API took 0.013s '/api/user-preferences?keys=consumer.recent.data&_dc=1688002579205' t Transfer: 1220 : 12|02:58:40.3646|2gvHDm|CJPOWERCAST|OAuth: /api/v3/search/versions?_dc=1688003920363 t Transfer: 1220 : 12|02:58:40.3646|2gvHDm|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:40.3646|2gvHDm|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:40.3646|2gvHDm|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|02:58:40.3646|2gvHDm|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|02:58:40.3657|FRC3Ie|CJPOWERCAST|OAuth: /api/v3/search/Media?_dc=1688003920364 t Transfer: 1220 : 12|02:58:40.3657|FRC3Ie|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:40.3657|FRC3Ie|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:40.3657|FRC3Ie|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|02:58:40.3657|FRC3Ie|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|02:58:40.7676|2gvHDm|CJPOWERCAST|V3Api.SearchVersions t Information: 1220 : 12|02:58:40.7676|FRC3Ie|CJPOWERCAST|V3Api.SearchMedia t Information: 1220 : 12|02:58:40.7676|2gvHDm|CJPOWERCAST|V3Api.SearchGeneric t Information: 1220 : 12|02:58:40.7676|FRC3Ie|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|02:58:40.7676|2gvHDm|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:40.7687|2gvHDm|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:40.7687|2gvHDm|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|02:58:40.7687|2gvHDm|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:40.7687|2gvHDm|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:40.7687|2gvHDm|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|02:58:40.7687|FRC3Ie|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:40.7687|FRC3Ie|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:40.7687|FRC3Ie|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|02:58:41.1837|2gvHDm|CJPOWERCAST|Running solr search: [q, (deleted_flag:(0) AND (owners:((SFP2) OR (PSP) OR (PMS) OR (SFP1) OR (PMH) OR (PPL))))] t Information: 1220 : 12|02:58:41.1837|FRC3Ie|CJPOWERCAST|Running solr search: [q, (deleted_flag:(0) AND (owners:((SFP2) OR (PSP) OR (PMS) OR (SFP1) OR (PMH) OR (PPL))))] t Information: 1220 : 12|02:58:41.1837|FRC3Ie|CJPOWERCAST|Solr query returned: 372 in 30ms t Information: 1220 : 12|02:58:41.1837|2gvHDm|CJPOWERCAST|Solr query returned: 86 in 8ms t Information: 1220 : 12|02:58:41.1847|2gvHDm|CJPOWERCAST|SearchVersion SQL: select * from (select a.*, rownum rnum from ( select m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE , (select min(name) from TM_CFG_AUDIO_CONTENT_MS_TYPES audio where m.audio_type = audio.id ) SOUND ,(select min(from_date_time) from TM_PG_RL_PROD_DATE prodDate where prodDate.Tm_Pg_Rl_Id = m.id ) PROD_FROM_DATE ,(select min(to_date_time) from TM_PG_RL_PROD_DATE prodDate where prodDate.Tm_Pg_Rl_Id = m.id ) PROD_TO_DATE ,(select min(full_name) from tm_lang_data lang, TM_PG_RL_LANG_LNX link where lang.id = link.lang_id and link.tm_pg_rl_id = m.id) PROD_LANGUAGE ,(SELECT min(COLOUR_NAME) FROM tm_cfg_colour_list list, tm_pg_rl ver where ver.col_mono = list.id and ver.id = m.id) PROD_COLOUR_TEXT ,(SELECT min(cfg.prod_date_type_name) FROM TM_PG_RL_PROD_DATE pg_rl, tm_cfg_prod_date_type cfg where cfg.id = pg_rl.PROD_DATE_TYPE_ID and TM_PG_RL_ID = m.id ) PROD_DATE_TYPE ,(select min(status.description) from TM_CFG_PGM_STATUS status where m.ITEM_STATUS_ID = status.id) PGM_STATUS_TEXT ,(select submed.sub_medium_name from TM_CFG_SUB_MEDIUM submed where m.SUB_MEDIUM_ID = submed.id) SUB_MEDIUM_TEXT, (select cvt.ID from TM_PORTAL_VERSION_CONFIG cvt where m.CUSTOM_VERSION_TYPE = cvt.CUSTOM_VERSION_TYPE AND cvt.CUSTOM_VERSION_TYPE IS NOT NULL ) MP_CONFIG_ID from (select v.*, coalesce(v.primary_thumb_id, (select x.primary_thumb_id from tm_pg_rl x where x.id=v.parent_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.pgm_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs2_id) ) primary_thumb_id2 from tmddba.tm_pg_rl v) m left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id2,(select /*+ cardinality(4) */ rownum rn, column_value id from table(:ids)) ids where item_type>0 and rl_deleted=0 and m.id = ids.id order by ids.rn ) a where rownum <= 10000) r where rnum >=1 order by rnum t Information: 1220 : 12|02:58:41.3857|FRC3Ie|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 ,(select /*+ cardinality(4) */ rownum rn, column_value id from table(:ids)) ids --sqlWhere where m.id = ids.id order by ids.rn ) a where rownum <= 10000) 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 rnum t Verbose: 1220 : 12|02:58:42.5917|FRC3Ie|CJPOWERCAST|Alternative title fields query: select * from (select x.id,x.pgm_abs_id TitleId, x.pgm_parent_id VersionId from tm_mis x where id in (select /*+ cardinality(4) */ column_value id from table(:ids))) y,lateral (select dbms_lob.substr( o.text_data_plain, 1000, 1 ) Field_5799344 from tm_txt_obj o where (o.pgm_abs_id=y.TitleId or o.pgm_rl_id = y.VersionId) and o.type_id=:param_1 order by o.id desc fetch first 1 rows only)(+) t Information: 1220 : 12|02:58:42.7926|FRC3Ie|CJPOWERCAST| timing: 00:00:01.9807480 t Verbose: 1220 : 12|02:58:42.7926|FRC3Ie|CJPOWERCAST|imfx v3 API took 2.002s '/api/v3/search/Media?_dc=1688003920364' t Transfer: 1220 : 12|02:58:42.9936|FRC3Ie|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Dinosaur 1c.mp4 subfolder t Transfer: 1220 : 12|02:58:42.9936|FRC3Ie|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Dinosaur%201c.mp4 t Transfer: 1220 : 12|02:58:42.9936|FRC3Ie|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/Dinosaur%201c.mp4 t Transfer: 1220 : 12|02:58:42.9936|FRC3Ie|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:42.9936|FRC3Ie|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:42.9947|FRC3Ie|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|02:58:42.9947|FRC3Ie|CJPOWERCAST|GetUrl. Storage |PMH Video| filename \\10.46.131.12\Test\NGAM\Folder3\alpha7-1\C0002.MP4 subfolder alpha7-1\ t Transfer: 1220 : 12|02:58:42.9947|FRC3Ie|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:42.9947|FRC3Ie|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:42.9947|FRC3Ie|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|02:58:42.9957|FRC3Ie|CJPOWERCAST|GetUrl. Storage |PMH Video| filename \\10.46.131.12\Test\NGAM\Folder3\alpha7-1\C0003.MP4 subfolder alpha7-1\ t Transfer: 1220 : 12|02:58:42.9957|FRC3Ie|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:42.9957|FRC3Ie|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:42.9957|FRC3Ie|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|02:58:42.9957|FRC3Ie|CJPOWERCAST|GetUrl. Storage |PMH Video| filename \\10.46.131.12\Test\NGAM\Folder3\alpha7-1\C0004.MP4 subfolder alpha7-1\ t Transfer: 1220 : 12|02:58:42.9967|FRC3Ie|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:42.9967|FRC3Ie|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:42.9967|FRC3Ie|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|02:58:42.9967|FRC3Ie|CJPOWERCAST|GetUrl. Storage |PMH Video| filename \\10.46.131.12\Test\NGAM\Folder3\alpha7-1\C0005.MP4 subfolder alpha7-1\ t Transfer: 1220 : 12|02:58:42.9967|FRC3Ie|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:42.9967|FRC3Ie|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:42.9967|FRC3Ie|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|02:58:42.9977|FRC3Ie|CJPOWERCAST|GetUrl. Storage |PMH Video| filename \\10.46.131.12\Test\NGAM\Folder3\alpha7-1\C0007.MP4 subfolder alpha7-1\ t Transfer: 1220 : 12|02:58:42.9977|FRC3Ie|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:42.9977|FRC3Ie|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:42.9977|FRC3Ie|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|02:58:42.9977|FRC3Ie|CJPOWERCAST|GetUrl. Storage |PMH Video| filename \\10.46.131.12\Test\NGAM\Folder3\32b60bce-ad82-46d9-9680-1bc508939215\GH018860.MP4 subfolder 32b60bce-ad82-46d9-9680-1bc508939215\ t Transfer: 1220 : 12|02:58:42.9977|FRC3Ie|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:42.9987|FRC3Ie|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:42.9987|FRC3Ie|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|02:58:42.9987|FRC3Ie|CJPOWERCAST|GetUrl. Storage |PMH Video| filename \\10.46.131.12\Test\NGAM\Folder3\aa6fb5ed-8e69-4268-b8fa-1184664437a0\GH018859.MP4 subfolder aa6fb5ed-8e69-4268-b8fa-1184664437a0\ t Transfer: 1220 : 12|02:58:42.9987|FRC3Ie|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:42.9987|FRC3Ie|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:42.9987|FRC3Ie|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|02:58:42.9987|FRC3Ie|CJPOWERCAST|GetUrl. Storage |PMH Video| filename \\10.46.131.12\Test\NGAM\Folder3\206cf38c-d40c-49e6-b8ed-476b7c369d2c\GH018861.MP4 subfolder 206cf38c-d40c-49e6-b8ed-476b7c369d2c\ t Transfer: 1220 : 12|02:58:42.9997|FRC3Ie|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:42.9997|FRC3Ie|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:42.9997|FRC3Ie|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|02:58:42.9997|FRC3Ie|CJPOWERCAST|GetUrl. Storage |PMH Proxy| filename \\10.46.131.12\Test\NGAM\Folder5\295_2302_M0002105.mp4 subfolder t Transfer: 1220 : 12|02:58:42.9997|FRC3Ie|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:42.9997|FRC3Ie|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:43.0007|FRC3Ie|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|02:58:43.0007|FRC3Ie|CJPOWERCAST|GetUrl. Storage |PMH Proxy| filename \\10.46.131.12\Test\NGAM\Folder5\N0002107.mp4 subfolder t Transfer: 1220 : 12|02:58:43.0007|FRC3Ie|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:43.0007|FRC3Ie|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:43.0007|FRC3Ie|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|02:58:43.0007|FRC3Ie|CJPOWERCAST|GetUrl. Storage |PMH Proxy| filename \\10.46.131.12\Test\NGAM\Folder5\N0002108.mp4 subfolder t Transfer: 1220 : 12|02:58:43.0017|FRC3Ie|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:43.0017|FRC3Ie|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:43.0017|FRC3Ie|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|02:58:43.0017|FRC3Ie|CJPOWERCAST|GetUrl. Storage |PMH Proxy| filename \\10.46.131.12\Test\NGAM\Folder5\GH018860_M0002145.mp4 subfolder t Transfer: 1220 : 12|02:58:43.0017|FRC3Ie|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:43.0017|FRC3Ie|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:43.0027|FRC3Ie|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|02:58:43.2036|FRC3Ie|CJPOWERCAST|GetUrl. Storage |PMH Proxy| filename \\10.46.131.12\Test\NGAM\Folder5\MAXD_1506_M0002267.mp4 subfolder t Transfer: 1220 : 12|02:58:43.2036|FRC3Ie|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:43.2036|FRC3Ie|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:43.2036|FRC3Ie|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|02:58:43.2036|FRC3Ie|CJPOWERCAST|GetUrl. Storage |Video| filename I:\Video\L0640441.mp4 subfolder t Transfer: 1220 : 12|02:58:43.2046|FRC3Ie|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/L0640441.mp4 t Transfer: 1220 : 12|02:58:43.2046|FRC3Ie|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/L0640441.mp4 t Transfer: 1220 : 12|02:58:43.2046|FRC3Ie|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:43.2046|FRC3Ie|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:43.2046|FRC3Ie|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|02:58:43.2046|FRC3Ie|CJPOWERCAST|GetUrl. Storage |Video| filename I:\Video\L0640430.mp4 subfolder t Transfer: 1220 : 12|02:58:43.2056|FRC3Ie|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/L0640430.mp4 t Transfer: 1220 : 12|02:58:43.2056|FRC3Ie|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/L0640430.mp4 t Transfer: 1220 : 12|02:58:43.2056|FRC3Ie|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:43.2056|FRC3Ie|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:43.2056|FRC3Ie|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|02:58:43.2056|FRC3Ie|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\8DCM000222_OMN0118203335_M0002381.mp4 subfolder t Transfer: 1220 : 12|02:58:43.2066|FRC3Ie|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/8DCM000222_OMN0118203335_M0002381.mp4 t Transfer: 1220 : 12|02:58:43.2066|FRC3Ie|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/8DCM000222_OMN0118203335_M0002381.mp4 t Transfer: 1220 : 12|02:58:43.2066|FRC3Ie|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:43.2066|FRC3Ie|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:43.2066|FRC3Ie|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|02:58:43.2066|FRC3Ie|CJPOWERCAST|GetUrl. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\cd16270b-696e-4e0b-9a0e-02a00f6c3c8d\2022년_통합인제스트_6월 근무표.xlsx subfolder cd16270b-696e-4e0b-9a0e-02a00f6c3c8d\ t Transfer: 1220 : 12|02:58:43.2076|FRC3Ie|CJPOWERCAST| GetFileName result https://demo.tmd.tv/Temp Upload/2022%EB%85%84_%ED%86%B5%ED%95%A9%EC%9D%B8%EC%A0%9C%EC%8A%A4%ED%8A%B8_6%EC%9B%94%20%EA%B7%BC%EB%AC%B4%ED%91%9C.xlsx t Transfer: 1220 : 12|02:58:43.2076|FRC3Ie|CJPOWERCAST|GetUrl. result https://demo.tmd.tv/Temp Upload/2022%EB%85%84_%ED%86%B5%ED%95%A9%EC%9D%B8%EC%A0%9C%EC%8A%A4%ED%8A%B8_6%EC%9B%94%20%EA%B7%BC%EB%AC%B4%ED%91%9C.xlsx t Transfer: 1220 : 12|02:58:43.2076|FRC3Ie|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:43.2076|FRC3Ie|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:43.2076|FRC3Ie|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|02:58:43.2087|FRC3Ie|CJPOWERCAST|GetUrl. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\ecb10dd3-349c-49d2-8131-9de1fb854cb8\월간구독지 현황.txt subfolder ecb10dd3-349c-49d2-8131-9de1fb854cb8\ t Transfer: 1220 : 12|02:58:43.2087|FRC3Ie|CJPOWERCAST| GetFileName result https://demo.tmd.tv/Temp Upload/%EC%9B%94%EA%B0%84%EA%B5%AC%EB%8F%85%EC%A7%80%20%ED%98%84%ED%99%A9.txt t Transfer: 1220 : 12|02:58:43.2087|FRC3Ie|CJPOWERCAST|GetUrl. result https://demo.tmd.tv/Temp Upload/%EC%9B%94%EA%B0%84%EA%B5%AC%EB%8F%85%EC%A7%80%20%ED%98%84%ED%99%A9.txt t Transfer: 1220 : 12|02:58:43.2087|FRC3Ie|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:43.2087|FRC3Ie|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:43.2087|FRC3Ie|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|02:58:43.2097|FRC3Ie|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Nov Example (16).mp4 subfolder t Transfer: 1220 : 12|02:58:43.2097|FRC3Ie|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Nov%20Example%20(16).mp4 t Transfer: 1220 : 12|02:58:43.2097|FRC3Ie|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/Nov%20Example%20(16).mp4 t Transfer: 1220 : 12|02:58:43.2097|FRC3Ie|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:43.2097|FRC3Ie|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:43.2097|FRC3Ie|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|02:58:43.2106|FRC3Ie|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gots0ep4us.mpd subfolder t Transfer: 1220 : 12|02:58:43.2106|FRC3Ie|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gots0ep4us.mpd t Transfer: 1220 : 12|02:58:43.2106|FRC3Ie|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/gots0ep4us.mpd t Transfer: 1220 : 12|02:58:43.2106|FRC3Ie|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:43.2106|FRC3Ie|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:43.2106|FRC3Ie|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|02:58:43.2116|FRC3Ie|CJPOWERCAST|GetUrl. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\SPOC List.xlsx subfolder t Transfer: 1220 : 12|02:58:43.2116|FRC3Ie|CJPOWERCAST| GetFileName result https://demo.tmd.tv/Temp Upload/SPOC%20List.xlsx t Transfer: 1220 : 12|02:58:43.2116|FRC3Ie|CJPOWERCAST|GetUrl. result https://demo.tmd.tv/Temp Upload/SPOC%20List.xlsx t Transfer: 1220 : 12|02:58:43.2116|FRC3Ie|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:43.2116|FRC3Ie|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:43.2116|FRC3Ie|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|02:58:43.2126|FRC3Ie|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\snow-game-of-thrones-1200x600.jpg subfolder t Transfer: 1220 : 12|02:58:43.2126|FRC3Ie|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/snow-game-of-thrones-1200x600.jpg t Transfer: 1220 : 12|02:58:43.2126|FRC3Ie|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/snow-game-of-thrones-1200x600.jpg t Transfer: 1220 : 12|02:58:43.2126|FRC3Ie|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:43.2126|FRC3Ie|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:43.2126|FRC3Ie|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|02:58:43.2126|FRC3Ie|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\Game_of_Thrones_Still_4.jpg subfolder t Transfer: 1220 : 12|02:58:43.2137|FRC3Ie|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/Game_of_Thrones_Still_4.jpg t Transfer: 1220 : 12|02:58:43.2137|FRC3Ie|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/Game_of_Thrones_Still_4.jpg t Transfer: 1220 : 12|02:58:43.2137|FRC3Ie|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:43.2137|FRC3Ie|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:43.2137|FRC3Ie|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|02:58:43.2137|FRC3Ie|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\Game_of_Thrones_Still_4.png subfolder t Transfer: 1220 : 12|02:58:43.2147|FRC3Ie|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/Game_of_Thrones_Still_4.png t Transfer: 1220 : 12|02:58:43.2147|FRC3Ie|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/Game_of_Thrones_Still_4.png t Transfer: 1220 : 12|02:58:43.2147|FRC3Ie|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:43.2147|FRC3Ie|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:43.2147|FRC3Ie|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|02:58:43.2147|FRC3Ie|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\game-of-thrones-1349.jpg subfolder t Transfer: 1220 : 12|02:58:43.2157|FRC3Ie|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/game-of-thrones-1349.jpg t Transfer: 1220 : 12|02:58:43.2157|FRC3Ie|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/game-of-thrones-1349.jpg t Transfer: 1220 : 12|02:58:43.2157|FRC3Ie|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:43.2157|FRC3Ie|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:43.2157|FRC3Ie|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|02:58:43.2157|FRC3Ie|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\game-of-thrones-daenerys.jpg subfolder t Transfer: 1220 : 12|02:58:43.2167|FRC3Ie|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/game-of-thrones-daenerys.jpg t Transfer: 1220 : 12|02:58:43.2167|FRC3Ie|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/game-of-thrones-daenerys.jpg t Transfer: 1220 : 12|02:58:43.2167|FRC3Ie|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:43.2167|FRC3Ie|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:43.2167|FRC3Ie|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|02:58:43.2177|FRC3Ie|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\young cersei game of thrones helen sloan.jpeg.jpg subfolder t Transfer: 1220 : 12|02:58:43.2177|FRC3Ie|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/young%20cersei%20game%20of%20thrones%20helen%20sloan.jpeg.jpg t Transfer: 1220 : 12|02:58:43.2177|FRC3Ie|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/young%20cersei%20game%20of%20thrones%20helen%20sloan.jpeg.jpg t Transfer: 1220 : 12|02:58:43.2177|FRC3Ie|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:43.2177|FRC3Ie|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:43.2177|FRC3Ie|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|02:58:43.2177|FRC3Ie|CJPOWERCAST|GetUrl. Storage |VODPublish| filename \\192.168.120.254\DemoFS\Digital Assets\VODPublish\Temp\N0001344.dtd subfolder Temp\ t Transfer: 1220 : 12|02:58:43.2187|FRC3Ie|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:43.2187|FRC3Ie|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:43.2187|FRC3Ie|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|02:58:43.2187|FRC3Ie|CJPOWERCAST|GetUrl. Storage |VODPublish| filename \\192.168.120.254\DemoFS\Digital Assets\VODPublish\Temp\N0001345.xml subfolder Temp\ t Transfer: 1220 : 12|02:58:43.2187|FRC3Ie|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:43.2187|FRC3Ie|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:43.2197|FRC3Ie|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|02:58:43.2197|FRC3Ie|CJPOWERCAST|GetUrl. Storage |VODPublish| filename \\192.168.120.254\DemoFS\Digital Assets\VODPublish\Temp\N0001348.dtd subfolder Temp\ t Transfer: 1220 : 12|02:58:43.2197|FRC3Ie|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:43.2197|FRC3Ie|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:43.2197|FRC3Ie|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|02:58:43.2197|FRC3Ie|CJPOWERCAST|GetUrl. Storage |VODPublish| filename \\192.168.120.254\DemoFS\Digital Assets\VODPublish\Temp\N0001349.xml subfolder Temp\ t Transfer: 1220 : 12|02:58:43.2197|FRC3Ie|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:43.2207|FRC3Ie|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:43.2207|FRC3Ie|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|02:58:43.2207|FRC3Ie|CJPOWERCAST|GetUrl. Storage |Docs| filename I:\Docs\Mediaflex Supported Devices 2v03.pdf subfolder t Transfer: 1220 : 12|02:58:43.2207|FRC3Ie|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/DocsServer/Mediaflex%20Supported%20Devices%202v03.pdf t Transfer: 1220 : 12|02:58:43.2207|FRC3Ie|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/DocsServer/Mediaflex%20Supported%20Devices%202v03.pdf t Transfer: 1220 : 12|02:58:43.2207|FRC3Ie|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:43.2207|FRC3Ie|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:43.2217|FRC3Ie|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|02:58:43.2217|FRC3Ie|CJPOWERCAST|GetUrl. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\BBC_graymeta_metadata.json subfolder t Transfer: 1220 : 12|02:58:43.2217|FRC3Ie|CJPOWERCAST| GetFileName result https://demo.tmd.tv/Temp Upload/BBC_graymeta_metadata.json t Transfer: 1220 : 12|02:58:43.2217|FRC3Ie|CJPOWERCAST|GetUrl. result https://demo.tmd.tv/Temp Upload/BBC_graymeta_metadata.json t Transfer: 1220 : 12|02:58:43.2217|FRC3Ie|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:43.2217|FRC3Ie|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:43.2227|FRC3Ie|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|02:58:43.2227|FRC3Ie|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Game of Thrones - Blinkbox-HD.mp4 subfolder t Transfer: 1220 : 12|02:58:43.2227|FRC3Ie|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Game%20of%20Thrones%20-%20Blinkbox-HD.mp4 t Transfer: 1220 : 12|02:58:43.2227|FRC3Ie|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/Game%20of%20Thrones%20-%20Blinkbox-HD.mp4 t Transfer: 1220 : 12|02:58:43.2227|FRC3Ie|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:43.2227|FRC3Ie|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:43.2227|FRC3Ie|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|02:58:43.2237|FRC3Ie|CJPOWERCAST|GetUrl. Storage |VODPublish| filename \\192.168.120.254\DemoFS\Digital Assets\VODPublish\Temp\N0001343.mp4 subfolder Temp\ t Transfer: 1220 : 12|02:58:43.2237|FRC3Ie|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:43.2237|FRC3Ie|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:43.2237|FRC3Ie|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|02:58:43.2247|FRC3Ie|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gotspecialspromo20seccharacter.mp4 subfolder t Transfer: 1220 : 12|02:58:43.2247|FRC3Ie|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gotspecialspromo20seccharacter.mp4 t Transfer: 1220 : 12|02:58:43.2247|FRC3Ie|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/gotspecialspromo20seccharacter.mp4 t Transfer: 1220 : 12|02:58:43.2247|FRC3Ie|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:43.2247|FRC3Ie|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:43.2247|FRC3Ie|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|02:58:43.2247|FRC3Ie|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\gotspecialspromosimage.jpg subfolder t Transfer: 1220 : 12|02:58:43.2257|FRC3Ie|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/gotspecialspromosimage.jpg t Transfer: 1220 : 12|02:58:43.2257|FRC3Ie|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/gotspecialspromosimage.jpg t Transfer: 1220 : 12|02:58:43.2257|FRC3Ie|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:43.2257|FRC3Ie|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:43.2257|FRC3Ie|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|02:58:43.2257|FRC3Ie|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\Example 06052020.mp4 subfolder t Transfer: 1220 : 12|02:58:43.2266|FRC3Ie|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/Example%2006052020.mp4 t Transfer: 1220 : 12|02:58:43.2266|FRC3Ie|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/Example%2006052020.mp4 t Transfer: 1220 : 12|02:58:43.2266|FRC3Ie|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:43.2266|FRC3Ie|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:43.2266|FRC3Ie|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|02:58:43.2266|FRC3Ie|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gots0ep3us.mpd subfolder t Transfer: 1220 : 12|02:58:43.2266|FRC3Ie|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gots0ep3us.mpd t Transfer: 1220 : 12|02:58:43.2276|FRC3Ie|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/gots0ep3us.mpd t Transfer: 1220 : 12|02:58:43.2276|FRC3Ie|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:43.2276|FRC3Ie|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:43.2276|FRC3Ie|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|02:58:43.2276|FRC3Ie|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Example 06052020.mp4 subfolder t Transfer: 1220 : 12|02:58:43.2276|FRC3Ie|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Example%2006052020.mp4 t Transfer: 1220 : 12|02:58:43.2287|FRC3Ie|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/Example%2006052020.mp4 t Transfer: 1220 : 12|02:58:43.2287|FRC3Ie|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:43.2287|FRC3Ie|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:43.2287|FRC3Ie|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|02:58:43.2287|FRC3Ie|CJPOWERCAST|GetUrl. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\68add84afa7b\Animation Sample1.mp4 subfolder 68add84afa7b\ t Transfer: 1220 : 12|02:58:43.2287|FRC3Ie|CJPOWERCAST| GetFileName result https://demo.tmd.tv/Temp Upload/Animation%20Sample1.mp4 t Transfer: 1220 : 12|02:58:43.2297|FRC3Ie|CJPOWERCAST|GetUrl. result https://demo.tmd.tv/Temp Upload/Animation%20Sample1.mp4 t Transfer: 1220 : 12|02:58:43.2297|FRC3Ie|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:43.2297|FRC3Ie|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:43.2297|FRC3Ie|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|02:58:43.2297|FRC3Ie|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gotspecialspromo10secaction.mp4 subfolder t Transfer: 1220 : 12|02:58:43.2297|FRC3Ie|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gotspecialspromo10secaction.mp4 t Transfer: 1220 : 12|02:58:43.2297|FRC3Ie|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/gotspecialspromo10secaction.mp4 t Transfer: 1220 : 12|02:58:43.2307|FRC3Ie|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:43.2307|FRC3Ie|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:43.2307|FRC3Ie|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|02:58:43.2307|FRC3Ie|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gots0ep5us.mpd subfolder t Transfer: 1220 : 12|02:58:43.2307|FRC3Ie|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gots0ep5us.mpd t Transfer: 1220 : 12|02:58:43.2307|FRC3Ie|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/gots0ep5us.mpd t Transfer: 1220 : 12|02:58:43.2317|FRC3Ie|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:43.2317|FRC3Ie|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:43.2317|FRC3Ie|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|02:58:43.2317|FRC3Ie|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gots0ep2us.mpd subfolder t Transfer: 1220 : 12|02:58:43.2317|FRC3Ie|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gots0ep2us.mpd t Transfer: 1220 : 12|02:58:43.2317|FRC3Ie|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/gots0ep2us.mpd t Transfer: 1220 : 12|02:58:43.2317|FRC3Ie|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:43.2327|FRC3Ie|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:43.2327|FRC3Ie|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|02:58:43.2327|2gvHDm|CJPOWERCAST|Running version search. User: 1165 Simple Search: Trying to use Solr Search... Solr completed in: 511ms. Returned lines: 86 Running Oracle search. Oracle version search timing: 1939ms. SQL run: select * from (select a.*, rownum rnum from ( select m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE , (select min(name) from TM_CFG_AUDIO_CONTENT_MS_TYPES audio where m.audio_type = audio.id ) SOUND ,(select min(from_date_time) from TM_PG_RL_PROD_DATE prodDate where prodDate.Tm_Pg_Rl_Id = m.id ) PROD_FROM_DATE ,(select min(to_date_time) from TM_PG_RL_PROD_DATE prodDate where prodDate.Tm_Pg_Rl_Id = m.id ) PROD_TO_DATE ,(select min(full_name) from tm_lang_data lang, TM_PG_RL_LANG_LNX link where lang.id = link.lang_id and link.tm_pg_rl_id = m.id) PROD_LANGUAGE ,(SELECT min(COLOUR_NAME) FROM tm_cfg_colour_list list, tm_pg_rl ver where ver.col_mono = list.id and ver.id = m.id) PROD_COLOUR_TEXT ,(SELECT min(cfg.prod_date_type_name) FROM TM_PG_RL_PROD_DATE pg_rl, tm_cfg_prod_date_type cfg where cfg.id = pg_rl.PROD_DATE_TYPE_ID and TM_PG_RL_ID = m.id ) PROD_DATE_TYPE ,(select min(status.description) from TM_CFG_PGM_STATUS status where m.ITEM_STATUS_ID = status.id) PGM_STATUS_TEXT ,(select submed.sub_medium_name from TM_CFG_SUB_MEDIUM submed where m.SUB_MEDIUM_ID = submed.id) SUB_MEDIUM_TEXT, (select cvt.ID from TM_PORTAL_VERSION_CONFIG cvt where m.CUSTOM_VERSION_TYPE = cvt.CUSTOM_VERSION_TYPE AND cvt.CUSTOM_VERSION_TYPE IS NOT NULL ) MP_CONFIG_ID from (select v.*, coalesce(v.primary_thumb_id, (select x.primary_thumb_id from tm_pg_rl x where x.id=v.parent_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.pgm_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs2_id) ) primary_thumb_id2 from tmddba.tm_pg_rl v) m left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id2,(select /*+ cardinality(4) */ rownum rn, column_value id from table(:ids)) ids where item_type>0 and rl_deleted=0 and m.id = ids.id order by ids.rn ) a where rownum <= 10000) r where rnum >=1 order by rnum t Verbose: 1220 : 12|02:58:43.2327|2gvHDm|CJPOWERCAST|imfx v3 API took 2.494s '/api/v3/search/versions?_dc=1688003920363' t Transfer: 1220 : 12|02:58:44.0367|cT2kfS|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1688003924998 t Transfer: 1220 : 12|02:58:44.0367|cT2kfS|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:44.0367|cT2kfS|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:44.0367|cT2kfS|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|02:58:44.0377|cT2kfS|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|02:58:44.0377|cT2kfS|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:44.0377|cT2kfS|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:44.0377|cT2kfS|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|02:58:44.8416|cT2kfS|CJPOWERCAST|imfx v3 API took 0.750s '/api/v3/search-suggestion/?_dc=1688003924998' t Transfer: 1220 : 12|02:58:46.0477|IpvXR~|CJPOWERCAST|OAuth: /api/v3/search/title?_dc=1688003926986 t Transfer: 1220 : 12|02:58:46.0477|IpvXR~|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:46.0477|IpvXR~|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:46.0477|IpvXR~|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|02:58:46.0477|IpvXR~|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|02:58:46.0477|IpvXR~|CJPOWERCAST|V3Api.SearchTitles t Information: 1220 : 12|02:58:46.0477|IpvXR~|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|02:58:46.0477|IpvXR~|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:46.0487|IpvXR~|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:46.0487|IpvXR~|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|02:58:46.0487|IpvXR~|CJPOWERCAST|SearchTitle SQL: with v as ( SELECT abs.* ,(select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = abs.net_grp_id) CHANNEL_GROUP ,decode(ITEM_TYPE, 1010,SER_ABS_ID, 1020,CASE WHEN SER_ABS2_ID > 0 THEN SER_ABS2_ID ELSE SER_ABS_ID END ) xparent_id FROM TMDDBA.TM_PG_ABS abs WHERE abs.id in ( select a.id FROM TMDDBA.TM_PG_ABS a where ABS_DELETED = 0 AND (INSTR(OWNERS,'|SFP2|')>0 OR INSTR(OWNERS,'|PSP|')>0 OR INSTR(OWNERS,'|PMS|')>0 OR INSTR(OWNERS,'|SFP1|')>0 OR INSTR(OWNERS,'|PMH|')>0 OR INSTR(OWNERS,'|PPL|')>0 ) AND a.ser_abs_id=:param_0 AND ROWNUM < 25000 ) ) ,v_missing_parent_ids as ( select xparent_id from v minus select id from v ) ,v_missing_parents as ( SELECT distinct a.* ,(select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = a.net_grp_id) CHANNEL_GROUP ,decode(ITEM_TYPE, 1010,SER_ABS_ID, 1020,CASE WHEN SER_ABS2_ID > 0 THEN SER_ABS2_ID ELSE SER_ABS_ID END ) xparent_id FROM TMDDBA.TM_PG_ABS a START WITH ID IN (select xparent_id from v_missing_parent_ids) CONNECT BY CASE PRIOR ITEM_TYPE WHEN 1010 THEN PRIOR SER_ABS_ID WHEN 1020 THEN CASE WHEN NVL(PRIOR SER_ABS2_ID, 0) > 0 THEN PRIOR SER_ABS2_ID ELSE PRIOR SER_ABS_ID END END = ID ) ,v_all as ( select x.*, count(*) over() RowCount from ( select * from v_missing_parents union select * from v ) x ) ,v_top as ( select id from (select id, row_number()over(order by upper(ser_title),upper(title),ser_num,ser_ep_num, SER_EP_SQ_NUM ) rnk -- sort roots from v_all where xparent_id is null) where rnk between (:page_number-1)*50+1 and :page_number*50 ) ,v_tree as ( select level "TreeLevel", a.*from v_all a start with id in (select id from v_top) connect by xparent_id = prior ID order siblings by upper(ser_title),ser_num,ser_ep_num, SER_EP_SQ_NUM,upper(title) -- sort children ) select * from v_tree --where rnk <= 50 t Verbose: 1220 : 12|02:58:46.2497|IpvXR~|CJPOWERCAST|imfx v3 API took 0.216s '/api/v3/search/title?_dc=1688003926986' t Transfer: 1220 : 12|02:58:47.0537|9vP3ji|CJPOWERCAST|OAuth: /api/v3/title/299390/versions?_dc=1688003927925 t Transfer: 1220 : 12|02:58:47.0537|9vP3ji|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:47.0537|9vP3ji|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:47.0537|9vP3ji|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|02:58:47.0537|9vP3ji|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|02:58:47.0537|9vP3ji|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|02:58:47.0537|9vP3ji|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:47.0537|9vP3ji|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:47.0546|9vP3ji|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|02:58:47.0546|9vP3ji|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:47.0546|9vP3ji|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:47.0546|9vP3ji|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|02:58:47.0546|AdQMkI|CJPOWERCAST|OAuth: /api/user-preferences?_dc=1688003927929 t Transfer: 1220 : 12|02:58:47.0546|AdQMkI|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:47.0546|AdQMkI|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:47.0546|AdQMkI|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|02:58:47.0546|AdQMkI|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|02:58:47.0546|9vP3ji|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:47.0546|9vP3ji|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:47.0556|9vP3ji|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|02:58:47.0556|9vP3ji|CJPOWERCAST|SearchVersion SQL: select v.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE , (select min(name) from TM_CFG_AUDIO_CONTENT_MS_TYPES audio where v.audio_type = audio.id ) SOUND ,(select min(from_date_time) from TM_PG_RL_PROD_DATE prodDate where prodDate.Tm_Pg_Rl_Id = v.id ) PROD_FROM_DATE ,(select min(to_date_time) from TM_PG_RL_PROD_DATE prodDate where prodDate.Tm_Pg_Rl_Id = v.id ) PROD_TO_DATE ,(select min(full_name) from tm_lang_data lang, TM_PG_RL_LANG_LNX link where lang.id = link.lang_id and link.tm_pg_rl_id = v.id) PROD_LANGUAGE ,(SELECT min(COLOUR_NAME) FROM tm_cfg_colour_list list, tm_pg_rl ver where ver.col_mono = list.id and ver.id = v.id) PROD_COLOUR_TEXT ,(SELECT min(cfg.prod_date_type_name) FROM TM_PG_RL_PROD_DATE pg_rl, tm_cfg_prod_date_type cfg where cfg.id = pg_rl.PROD_DATE_TYPE_ID and TM_PG_RL_ID = v.id ) PROD_DATE_TYPE ,(select min(status.description) from TM_CFG_PGM_STATUS status where v.ITEM_STATUS_ID = status.id) PGM_STATUS_TEXT ,(select submed.sub_medium_name from TM_CFG_SUB_MEDIUM submed where v.SUB_MEDIUM_ID = submed.id) SUB_MEDIUM_TEXT, (select cvt.ID from TM_PORTAL_VERSION_CONFIG cvt where v.CUSTOM_VERSION_TYPE = cvt.CUSTOM_VERSION_TYPE AND cvt.CUSTOM_VERSION_TYPE IS NOT NULL ) MP_CONFIG_ID from (select v.*, coalesce(v.primary_thumb_id, (select x.primary_thumb_id from tm_pg_rl x where x.id=v.parent_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.pgm_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs2_id) ) primary_thumb_id2 from tmddba.tm_pg_rl v where v.item_type > 0 and v.rl_deleted = 0) v left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = v.primary_thumb_id2 --sqlIdSearchJoin where 1=1 AND (INSTR(v.OWNERS,'|SFP2|')>0 OR INSTR(v.OWNERS,'|PSP|')>0 OR INSTR(v.OWNERS,'|PMS|')>0 OR INSTR(v.OWNERS,'|SFP1|')>0 OR INSTR(v.OWNERS,'|PMH|')>0 OR INSTR(v.OWNERS,'|PPL|')>0) and v.id in (select x.id from tmddba.tm_pg_rl x start with x.id in ( select a.id from (select m.id, rownum rnum from tmddba.tm_pg_rl m where item_type>0 and rl_deleted=0 and m.PGM_ABS_ID=:param_0 AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0) ) A WHERE rnum>=1 and rnum <= 9999 ) connect by nocycle prior x.parent_id=x.id) t Transfer: 1220 : 12|02:58:47.0556|9vP3ji|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:47.0556|9vP3ji|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:47.0556|9vP3ji|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|02:58:47.0556|AdQMkI|CJPOWERCAST|StoreUserDataByKeys.. t Transfer: 1220 : 12|02:58:47.0556|AdQMkI|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:47.0556|AdQMkI|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:47.0556|AdQMkI|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|02:58:47.0566|9vP3ji|CJPOWERCAST|Running version search. User: 1165 Simple Search: Running Oracle search. Running Oracle search for COUNT Oracle count completed in: 18ms. Returned lines: 0 t Verbose: 1220 : 12|02:58:47.0566|9vP3ji|CJPOWERCAST|imfx v3 API took 0.028s '/api/v3/title/299390/versions?_dc=1688003927925' t Verbose: 1220 : 12|02:58:47.0566|AdQMkI|CJPOWERCAST|imfx v3 API took 0.029s '/api/user-preferences?_dc=1688003927929' t Transfer: 1220 : 12|02:58:47.8597|UXfbGK|CJPOWERCAST|OAuth: /api/v3/title/299544/versions?_dc=1688003928805 t Transfer: 1220 : 12|02:58:47.8597|UXfbGK|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:47.8597|UXfbGK|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:47.8597|UXfbGK|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|02:58:47.8597|UXfbGK|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|02:58:47.8597|UXfbGK|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|02:58:47.8597|UXfbGK|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:47.8597|UXfbGK|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:47.8607|UXfbGK|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|02:58:47.8607|UXfbGK|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:47.8607|UXfbGK|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:47.8607|UXfbGK|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|02:58:47.8607|UXfbGK|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:47.8607|UXfbGK|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:47.8607|UXfbGK|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|02:58:47.8607|UXfbGK|CJPOWERCAST|SearchVersion SQL: select v.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE , (select min(name) from TM_CFG_AUDIO_CONTENT_MS_TYPES audio where v.audio_type = audio.id ) SOUND ,(select min(from_date_time) from TM_PG_RL_PROD_DATE prodDate where prodDate.Tm_Pg_Rl_Id = v.id ) PROD_FROM_DATE ,(select min(to_date_time) from TM_PG_RL_PROD_DATE prodDate where prodDate.Tm_Pg_Rl_Id = v.id ) PROD_TO_DATE ,(select min(full_name) from tm_lang_data lang, TM_PG_RL_LANG_LNX link where lang.id = link.lang_id and link.tm_pg_rl_id = v.id) PROD_LANGUAGE ,(SELECT min(COLOUR_NAME) FROM tm_cfg_colour_list list, tm_pg_rl ver where ver.col_mono = list.id and ver.id = v.id) PROD_COLOUR_TEXT ,(SELECT min(cfg.prod_date_type_name) FROM TM_PG_RL_PROD_DATE pg_rl, tm_cfg_prod_date_type cfg where cfg.id = pg_rl.PROD_DATE_TYPE_ID and TM_PG_RL_ID = v.id ) PROD_DATE_TYPE ,(select min(status.description) from TM_CFG_PGM_STATUS status where v.ITEM_STATUS_ID = status.id) PGM_STATUS_TEXT ,(select submed.sub_medium_name from TM_CFG_SUB_MEDIUM submed where v.SUB_MEDIUM_ID = submed.id) SUB_MEDIUM_TEXT, (select cvt.ID from TM_PORTAL_VERSION_CONFIG cvt where v.CUSTOM_VERSION_TYPE = cvt.CUSTOM_VERSION_TYPE AND cvt.CUSTOM_VERSION_TYPE IS NOT NULL ) MP_CONFIG_ID from (select v.*, coalesce(v.primary_thumb_id, (select x.primary_thumb_id from tm_pg_rl x where x.id=v.parent_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.pgm_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs2_id) ) primary_thumb_id2 from tmddba.tm_pg_rl v where v.item_type > 0 and v.rl_deleted = 0) v left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = v.primary_thumb_id2 --sqlIdSearchJoin where 1=1 AND (INSTR(v.OWNERS,'|SFP2|')>0 OR INSTR(v.OWNERS,'|PSP|')>0 OR INSTR(v.OWNERS,'|PMS|')>0 OR INSTR(v.OWNERS,'|SFP1|')>0 OR INSTR(v.OWNERS,'|PMH|')>0 OR INSTR(v.OWNERS,'|PPL|')>0) and v.id in (select x.id from tmddba.tm_pg_rl x start with x.id in ( select a.id from (select m.id, rownum rnum from tmddba.tm_pg_rl m where item_type>0 and rl_deleted=0 and m.PGM_ABS_ID=:param_0 AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0) ) A WHERE rnum>=1 and rnum <= 9999 ) connect by nocycle prior x.parent_id=x.id) t Transfer: 1220 : 12|02:58:47.8607|UXfbGK|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:47.8616|UXfbGK|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:47.8616|UXfbGK|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|02:58:48.4647|UXfbGK|CJPOWERCAST|Running version search. User: 1165 Simple Search: Running Oracle search. Running Oracle search for COUNT Oracle count completed in: 4ms. Returned lines: 1 Oracle version search timing: 619ms. SQL run: select v.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE , (select min(name) from TM_CFG_AUDIO_CONTENT_MS_TYPES audio where v.audio_type = audio.id ) SOUND ,(select min(from_date_time) from TM_PG_RL_PROD_DATE prodDate where prodDate.Tm_Pg_Rl_Id = v.id ) PROD_FROM_DATE ,(select min(to_date_time) from TM_PG_RL_PROD_DATE prodDate where prodDate.Tm_Pg_Rl_Id = v.id ) PROD_TO_DATE ,(select min(full_name) from tm_lang_data lang, TM_PG_RL_LANG_LNX link where lang.id = link.lang_id and link.tm_pg_rl_id = v.id) PROD_LANGUAGE ,(SELECT min(COLOUR_NAME) FROM tm_cfg_colour_list list, tm_pg_rl ver where ver.col_mono = list.id and ver.id = v.id) PROD_COLOUR_TEXT ,(SELECT min(cfg.prod_date_type_name) FROM TM_PG_RL_PROD_DATE pg_rl, tm_cfg_prod_date_type cfg where cfg.id = pg_rl.PROD_DATE_TYPE_ID and TM_PG_RL_ID = v.id ) PROD_DATE_TYPE ,(select min(status.description) from TM_CFG_PGM_STATUS status where v.ITEM_STATUS_ID = status.id) PGM_STATUS_TEXT ,(select submed.sub_medium_name from TM_CFG_SUB_MEDIUM submed where v.SUB_MEDIUM_ID = submed.id) SUB_MEDIUM_TEXT, (select cvt.ID from TM_PORTAL_VERSION_CONFIG cvt where v.CUSTOM_VERSION_TYPE = cvt.CUSTOM_VERSION_TYPE AND cvt.CUSTOM_VERSION_TYPE IS NOT NULL ) MP_CONFIG_ID from (select v.*, coalesce(v.primary_thumb_id, (select x.primary_thumb_id from tm_pg_rl x where x.id=v.parent_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.pgm_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs2_id) ) primary_thumb_id2 from tmddba.tm_pg_rl v where v.item_type > 0 and v.rl_deleted = 0) v left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = v.primary_thumb_id2 --sqlIdSearchJoin where 1=1 AND (INSTR(v.OWNERS,'|SFP2|')>0 OR INSTR(v.OWNERS,'|PSP|')>0 OR INSTR(v.OWNERS,'|PMS|')>0 OR INSTR(v.OWNERS,'|SFP1|')>0 OR INSTR(v.OWNERS,'|PMH|')>0 OR INSTR(v.OWNERS,'|PPL|')>0) and v.id in (select x.id from tmddba.tm_pg_rl x start with x.id in ( select a.id from (select m.id, rownum rnum from tmddba.tm_pg_rl m where item_type>0 and rl_deleted=0 and m.PGM_ABS_ID=:param_0 AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0) ) A WHERE rnum>=1 and rnum <= 9999 ) connect by nocycle prior x.parent_id=x.id) t Verbose: 1220 : 12|02:58:48.4647|UXfbGK|CJPOWERCAST|imfx v3 API took 0.632s '/api/v3/title/299544/versions?_dc=1688003928805' t Transfer: 1220 : 12|02:58:48.8666|9MAPb_|CJPOWERCAST|OAuth: /api/v3/version/299545/media?_dc=1688003929753 t Transfer: 1220 : 12|02:58:48.8666|9MAPb_|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:48.8666|9MAPb_|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:48.8666|9MAPb_|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|02:58:48.8666|9MAPb_|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|02:58:48.8666|9MAPb_|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|02:58:48.8666|kZhWBP|CJPOWERCAST|OAuth: /api/v3/version/299545/media?_dc=1688003929768 t Transfer: 1220 : 12|02:58:48.8666|kZhWBP|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:48.8676|kZhWBP|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:48.8676|kZhWBP|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|02:58:48.8676|kZhWBP|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|02:58:48.8676|kZhWBP|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|02:58:48.8676|9MAPb_|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:48.8676|9MAPb_|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:48.8676|9MAPb_|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|02:58:48.8676|kZhWBP|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:48.8676|kZhWBP|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:48.8676|kZhWBP|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|02:58:48.8686|9MAPb_|CJPOWERCAST|MediaSearch SQL: --sqlFromPaging select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type in (1,110)),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , (SELECT min(status.ACCESS_STATUS_NAME) FROM TMDDBA.TM_ACCESS_STATUS statusLnx, TM_CFG_ACCESS_STATUS status WHERE statusLnx.Media_Id = r.id and statusLnx.Status_Id = status.id) ACCESS_STATUS , (select min(acq.ext_ref) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) CONSIGNMENT_NUMBER , (select min(acq.alt_id1) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) TRANSFER_NUMBER , (select min(crs.series_number) from tm_series_data crs where crs.id = r.GROUP_SERIES_ID) CRS_SERIES , (select min(DISPOSAL_NAME) from TM_ACQ_DISPOSAL status, tm_disposal_records records where status.id = records.disposal_status_id and records.miid = r.id) DISPOSAL_STATUS , (select min(class.class_number) from TM_ACQ_DISPOSAL status, tm_disposal_records records, tm_disposal_classes class where status.id = records.disposal_status_id and records.miid = r.id and class.id = records.disposal_class_id) DISPOSAL_CLASS, (select min(names.concat_search_name) from tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names where r.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY, (select min(c.u_id_ext1) from tmddba.tm_mi_tpi_lnx lnx, tm_ctnrs c where c.u_id = lnx.tpiid and lnx.miid = r.id) U_ID_EXT1 , (select t.name from TM_CFG_MI_FMT_TYP t where t.id = r.mi_fmt_type) ITEM_FORMAT_TEXT, CASE WHEN BITAND(r.COMPIL, 2) = 2 THEN 'SUPPLIED' WHEN BITAND(r.COMPIL, 4) = 4 THEN 'MADE' WHEN BITAND(r.COMPIL, 134217728) = 134217728 THEN 'IMPORTED' ELSE '' END AS ORIGIN, CASE WHEN BITAND(r.COMPIL, 512) = 512 THEN 'Attached' WHEN BITAND(r.COMPIL, 1024) = 1024 THEN 'Un-Attached' ELSE '' END AS FLAGS, (select min(lang.full_name) from TM_PG_RL_LANG_LNX lnx, TM_LANG_DATA lang where lnx.tm_pg_rl_id = r.pgm_parent_id and lnx.lang_id = lang.id) AS PROD_LANGUAGE , (select min(ctx.ITFC_CODE) from tm_mis mis, tm_mi_tpi_lnx links, tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names where mis.id = r.id and links.miid = mis.id and mis.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY_NUMBER, (select min(status.description) from TM_CFG_PGM_STATUS status where r.status = status.id) PGM_STATUS_TEXT, (select min(ver.DUR) from TM_PG_RL ver where r.pgm_PARENT_ID = ver.id) AS VERSION_DUR , (select tmd_str_agg_pipe(cms.status_type_id ||',' ||cms.status_id) from tm_mi_cust_med_stat_lnx cms where cms.media_id=r.id) "CustomStatusesRaw", (select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = r.net_grp_id) CHANNEL_GROUP, (SELECT SUBSTR( trim( replace (replace ( LISTAGG(trim(tt.tags || ' ' || tt.notes), ' ') WITHIN GROUP (ORDER BY trim(tt.tags || ' ' || tt.notes)), chr (13), ''), chr (10), ' ')), 1, 150) z FROM tm_media_tagging tt WHERE link_guid = DFILE_LINK_GUID and rownum=1) TAGS_TEXT , GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select t.*, coalesce(t.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=t.pgm_parent_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.pgm_abs_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs2_id) ) primary_thumb_id2 from ( --sqlSubSelect select s.* from (select a.*, rownum rnum from (select --sqlFrom m.* from tmddba.tm_mis m --sqlWhere where media_type>0 and item_type>0 AND PGM_PARENT_ID=:param_0 and m.mi_deleted=0 AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0) order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) s where rnum >= 1) t ) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl order by r.rnum t Information: 1220 : 12|02:58:48.8686|kZhWBP|CJPOWERCAST|MediaSearch SQL: --sqlFromPaging select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type in (1,110)),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , (SELECT min(status.ACCESS_STATUS_NAME) FROM TMDDBA.TM_ACCESS_STATUS statusLnx, TM_CFG_ACCESS_STATUS status WHERE statusLnx.Media_Id = r.id and statusLnx.Status_Id = status.id) ACCESS_STATUS , (select min(acq.ext_ref) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) CONSIGNMENT_NUMBER , (select min(acq.alt_id1) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) TRANSFER_NUMBER , (select min(crs.series_number) from tm_series_data crs where crs.id = r.GROUP_SERIES_ID) CRS_SERIES , (select min(DISPOSAL_NAME) from TM_ACQ_DISPOSAL status, tm_disposal_records records where status.id = records.disposal_status_id and records.miid = r.id) DISPOSAL_STATUS , (select min(class.class_number) from TM_ACQ_DISPOSAL status, tm_disposal_records records, tm_disposal_classes class where status.id = records.disposal_status_id and records.miid = r.id and class.id = records.disposal_class_id) DISPOSAL_CLASS, (select min(names.concat_search_name) from tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names where r.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY, (select min(c.u_id_ext1) from tmddba.tm_mi_tpi_lnx lnx, tm_ctnrs c where c.u_id = lnx.tpiid and lnx.miid = r.id) U_ID_EXT1 , (select t.name from TM_CFG_MI_FMT_TYP t where t.id = r.mi_fmt_type) ITEM_FORMAT_TEXT, CASE WHEN BITAND(r.COMPIL, 2) = 2 THEN 'SUPPLIED' WHEN BITAND(r.COMPIL, 4) = 4 THEN 'MADE' WHEN BITAND(r.COMPIL, 134217728) = 134217728 THEN 'IMPORTED' ELSE '' END AS ORIGIN, CASE WHEN BITAND(r.COMPIL, 512) = 512 THEN 'Attached' WHEN BITAND(r.COMPIL, 1024) = 1024 THEN 'Un-Attached' ELSE '' END AS FLAGS, (select min(lang.full_name) from TM_PG_RL_LANG_LNX lnx, TM_LANG_DATA lang where lnx.tm_pg_rl_id = r.pgm_parent_id and lnx.lang_id = lang.id) AS PROD_LANGUAGE , (select min(ctx.ITFC_CODE) from tm_mis mis, tm_mi_tpi_lnx links, tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names where mis.id = r.id and links.miid = mis.id and mis.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY_NUMBER, (select min(status.description) from TM_CFG_PGM_STATUS status where r.status = status.id) PGM_STATUS_TEXT, (select min(ver.DUR) from TM_PG_RL ver where r.pgm_PARENT_ID = ver.id) AS VERSION_DUR , (select tmd_str_agg_pipe(cms.status_type_id ||',' ||cms.status_id) from tm_mi_cust_med_stat_lnx cms where cms.media_id=r.id) "CustomStatusesRaw", (select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = r.net_grp_id) CHANNEL_GROUP, (SELECT SUBSTR( trim( replace (replace ( LISTAGG(trim(tt.tags || ' ' || tt.notes), ' ') WITHIN GROUP (ORDER BY trim(tt.tags || ' ' || tt.notes)), chr (13), ''), chr (10), ' ')), 1, 150) z FROM tm_media_tagging tt WHERE link_guid = DFILE_LINK_GUID and rownum=1) TAGS_TEXT , GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select t.*, coalesce(t.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=t.pgm_parent_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.pgm_abs_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs2_id) ) primary_thumb_id2 from ( --sqlSubSelect select s.* from (select a.*, rownum rnum from (select --sqlFrom m.* from tmddba.tm_mis m --sqlWhere where media_type>0 and item_type>0 AND PGM_PARENT_ID=:param_0 and m.mi_deleted=0 AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0) order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) s where rnum >= 1) t ) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl order by r.rnum t Verbose: 1220 : 12|02:58:49.4716|kZhWBP|CJPOWERCAST|Alternative title fields query: select * from (select x.id,x.pgm_abs_id TitleId, x.pgm_parent_id VersionId from tm_mis x where id in (select /*+ cardinality(4) */ column_value id from table(:ids))) y,lateral (select dbms_lob.substr( o.text_data_plain, 1000, 1 ) Field_5799344 from tm_txt_obj o where (o.pgm_abs_id=y.TitleId or o.pgm_rl_id = y.VersionId) and o.type_id=:param_1 order by o.id desc fetch first 1 rows only)(+) t Verbose: 1220 : 12|02:58:49.4716|9MAPb_|CJPOWERCAST|Alternative title fields query: select * from (select x.id,x.pgm_abs_id TitleId, x.pgm_parent_id VersionId from tm_mis x where id in (select /*+ cardinality(4) */ column_value id from table(:ids))) y,lateral (select dbms_lob.substr( o.text_data_plain, 1000, 1 ) Field_5799344 from tm_txt_obj o where (o.pgm_abs_id=y.TitleId or o.pgm_rl_id = y.VersionId) and o.type_id=:param_1 order by o.id desc fetch first 1 rows only)(+) t Information: 1220 : 12|02:58:49.4716|9MAPb_|CJPOWERCAST| timing: 00:00:00.6050691 t Verbose: 1220 : 12|02:58:49.4716|9MAPb_|CJPOWERCAST|imfx v3 API took 0.607s '/api/v3/version/299545/media?_dc=1688003929753' t Transfer: 1220 : 12|02:58:49.4716|9MAPb_|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0178.mp4 subfolder t Transfer: 1220 : 12|02:58:49.4716|9MAPb_|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0178.mp4 t Transfer: 1220 : 12|02:58:49.4716|9MAPb_|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0178.mp4 t Transfer: 1220 : 12|02:58:49.4726|9MAPb_|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:49.4726|9MAPb_|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:49.4726|9MAPb_|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|02:58:49.4726|9MAPb_|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001992.mp4 subfolder t Transfer: 1220 : 12|02:58:49.4726|9MAPb_|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001992.mp4 t Transfer: 1220 : 12|02:58:49.4726|9MAPb_|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001992.mp4 t Transfer: 1220 : 12|02:58:49.4726|9MAPb_|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:49.4726|9MAPb_|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:49.4726|9MAPb_|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|02:58:49.4726|9MAPb_|CJPOWERCAST|GetUrl. Storage |Temp Storage| filename C:\TEMP\N0001992.mp4 subfolder t Transfer: 1220 : 12|02:58:49.4736|9MAPb_|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:49.4736|9MAPb_|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:49.4736|9MAPb_|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|02:58:49.4736|kZhWBP|CJPOWERCAST| timing: 00:00:00.6033887 t Verbose: 1220 : 12|02:58:49.4736|kZhWBP|CJPOWERCAST|imfx v3 API took 0.603s '/api/v3/version/299545/media?_dc=1688003929768' t Transfer: 1220 : 12|02:58:49.4736|9MAPb_|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0178.xml subfolder t Transfer: 1220 : 12|02:58:49.4736|9MAPb_|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0178.xml t Transfer: 1220 : 12|02:58:49.4736|9MAPb_|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0178.xml t Transfer: 1220 : 12|02:58:49.4736|9MAPb_|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:49.4736|9MAPb_|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:49.4746|9MAPb_|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|02:58:49.4746|kZhWBP|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0178.mp4 subfolder t Transfer: 1220 : 12|02:58:49.4746|kZhWBP|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0178.mp4 t Transfer: 1220 : 12|02:58:49.4746|kZhWBP|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0178.mp4 t Transfer: 1220 : 12|02:58:49.4746|kZhWBP|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:49.4746|kZhWBP|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:49.4746|kZhWBP|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|02:58:49.4746|kZhWBP|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001992.mp4 subfolder t Transfer: 1220 : 12|02:58:49.4746|kZhWBP|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001992.mp4 t Transfer: 1220 : 12|02:58:49.4746|kZhWBP|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001992.mp4 t Transfer: 1220 : 12|02:58:49.4746|kZhWBP|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:49.4756|kZhWBP|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:49.4756|kZhWBP|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|02:58:49.4756|kZhWBP|CJPOWERCAST|GetUrl. Storage |Temp Storage| filename C:\TEMP\N0001992.mp4 subfolder t Transfer: 1220 : 12|02:58:49.4756|kZhWBP|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:49.4756|kZhWBP|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:49.4767|kZhWBP|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|02:58:49.4767|kZhWBP|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0178.xml subfolder t Transfer: 1220 : 12|02:58:49.4767|kZhWBP|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0178.xml t Transfer: 1220 : 12|02:58:49.4767|kZhWBP|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0178.xml t Transfer: 1220 : 12|02:58:49.4767|kZhWBP|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:49.4767|kZhWBP|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:49.4767|kZhWBP|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|02:58:49.6777|OCiUte|CJPOWERCAST|OAuth: /api/v3/media/299534/carriers/digital?_dc=1688003930681 t Transfer: 1220 : 12|02:58:49.6777|OCiUte|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:49.6777|OCiUte|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:49.6777|OCiUte|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|02:58:49.6777|OCiUte|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|02:58:49.6777|OCiUte|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|02:58:49.6787|OCiUte|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:49.6787|OCiUte|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:49.6787|OCiUte|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|02:58:49.6787|OCiUte|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:49.6787|OCiUte|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:49.6787|OCiUte|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|02:58:49.8796|OCiUte|CJPOWERCAST|SearchDigitalCarriersAdv SQL: select r.*, l.dv_nam SRVER_ID_TEXT from ( select a.*, rownum rnum from ( select m.* from tmddba.tm_dfile m where m.id in (select l.dfile_id as ID from TMDDBA.tm_mi_dfile_lnx l join TMDDBA.TM_MIS mi on (l.mi_id = mi.id) where (INSTR(mi.OWNERS,'|SFP2|')>0 OR INSTR(mi.OWNERS,'|PSP|')>0 OR INSTR(mi.OWNERS,'|PMS|')>0 OR INSTR(mi.OWNERS,'|SFP1|')>0 OR INSTR(mi.OWNERS,'|PMH|')>0 OR INSTR(mi.OWNERS,'|PPL|')>0)and mi.MI_DELETED = 0 and mi.ITEM_TYPE > 0) and m.id in (select l.dfile_id as ID from TMDDBA.tm_mi_dfile_lnx l join TMDDBA.TM_MIS mi on (l.mi_id = mi.id) where mi.id = :param_0 AND (INSTR(mi.OWNERS,'|SFP2|')>0 OR INSTR(mi.OWNERS,'|PSP|')>0 OR INSTR(mi.OWNERS,'|PMS|')>0 OR INSTR(mi.OWNERS,'|SFP1|')>0 OR INSTR(mi.OWNERS,'|PMH|')>0 OR INSTR(mi.OWNERS,'|PPL|')>0)and mi.MI_DELETED = 0 and mi.ITEM_TYPE > 0) order by m.OS_FNAME, m.id ) a where rownum <= 50) r left join tm_device_lst l on (r.srver_id = l.id) where rnum >= 1 order by rnum t Transfer: 1220 : 12|02:58:50.0806|EGjkH8|CJPOWERCAST|OAuth: /api/v3/media/299534/carriers/digital?_dc=1688003930970 t Transfer: 1220 : 12|02:58:50.0806|EGjkH8|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:50.0806|EGjkH8|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:50.0806|EGjkH8|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|02:58:50.0806|EGjkH8|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|02:58:50.0806|EGjkH8|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|02:58:50.0806|EGjkH8|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:50.0806|EGjkH8|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:50.0817|EGjkH8|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|02:58:50.0817|EGjkH8|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:50.0817|EGjkH8|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:50.0817|EGjkH8|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|02:58:50.0817|EGjkH8|CJPOWERCAST|SearchDigitalCarriersAdv SQL: select r.*, l.dv_nam SRVER_ID_TEXT from ( select a.*, rownum rnum from ( select m.* from tmddba.tm_dfile m where m.id in (select l.dfile_id as ID from TMDDBA.tm_mi_dfile_lnx l join TMDDBA.TM_MIS mi on (l.mi_id = mi.id) where (INSTR(mi.OWNERS,'|SFP2|')>0 OR INSTR(mi.OWNERS,'|PSP|')>0 OR INSTR(mi.OWNERS,'|PMS|')>0 OR INSTR(mi.OWNERS,'|SFP1|')>0 OR INSTR(mi.OWNERS,'|PMH|')>0 OR INSTR(mi.OWNERS,'|PPL|')>0)and mi.MI_DELETED = 0 and mi.ITEM_TYPE > 0) and m.id in (select l.dfile_id as ID from TMDDBA.tm_mi_dfile_lnx l join TMDDBA.TM_MIS mi on (l.mi_id = mi.id) where mi.id = :param_0 AND (INSTR(mi.OWNERS,'|SFP2|')>0 OR INSTR(mi.OWNERS,'|PSP|')>0 OR INSTR(mi.OWNERS,'|PMS|')>0 OR INSTR(mi.OWNERS,'|SFP1|')>0 OR INSTR(mi.OWNERS,'|PMH|')>0 OR INSTR(mi.OWNERS,'|PPL|')>0)and mi.MI_DELETED = 0 and mi.ITEM_TYPE > 0) order by m.OS_FNAME, m.id ) a where rownum <= 50) r left join tm_device_lst l on (r.srver_id = l.id) where rnum >= 1 order by rnum t Verbose: 1220 : 12|02:58:50.0817|OCiUte|CJPOWERCAST|imfx v3 API took 0.317s '/api/v3/media/299534/carriers/digital?_dc=1688003930681' t Verbose: 1220 : 12|02:58:50.0817|EGjkH8|CJPOWERCAST|imfx v3 API took 0.033s '/api/v3/media/299534/carriers/digital?_dc=1688003930970' t Transfer: 1220 : 12|02:58:50.6847|nh_aO5|CJPOWERCAST|OAuth: /api/v3/media/299691/carriers/digital?_dc=1688003931647 t Transfer: 1220 : 12|02:58:50.6847|nh_aO5|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:50.6847|nh_aO5|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:50.6847|nh_aO5|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|02:58:50.6847|nh_aO5|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|02:58:50.6847|nh_aO5|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|02:58:50.6857|nh_aO5|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:50.6857|nh_aO5|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:50.6857|nh_aO5|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|02:58:50.6857|nh_aO5|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|02:58:50.6857|nh_aO5|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|02:58:50.6857|nh_aO5|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|02:58:50.6857|nh_aO5|CJPOWERCAST|SearchDigitalCarriersAdv SQL: select r.*, l.dv_nam SRVER_ID_TEXT from ( select a.*, rownum rnum from ( select m.* from tmddba.tm_dfile m where m.id in (select l.dfile_id as ID from TMDDBA.tm_mi_dfile_lnx l join TMDDBA.TM_MIS mi on (l.mi_id = mi.id) where (INSTR(mi.OWNERS,'|SFP2|')>0 OR INSTR(mi.OWNERS,'|PSP|')>0 OR INSTR(mi.OWNERS,'|PMS|')>0 OR INSTR(mi.OWNERS,'|SFP1|')>0 OR INSTR(mi.OWNERS,'|PMH|')>0 OR INSTR(mi.OWNERS,'|PPL|')>0)and mi.MI_DELETED = 0 and mi.ITEM_TYPE > 0) and m.id in (select l.dfile_id as ID from TMDDBA.tm_mi_dfile_lnx l join TMDDBA.TM_MIS mi on (l.mi_id = mi.id) where mi.id = :param_0 AND (INSTR(mi.OWNERS,'|SFP2|')>0 OR INSTR(mi.OWNERS,'|PSP|')>0 OR INSTR(mi.OWNERS,'|PMS|')>0 OR INSTR(mi.OWNERS,'|SFP1|')>0 OR INSTR(mi.OWNERS,'|PMH|')>0 OR INSTR(mi.OWNERS,'|PPL|')>0)and mi.MI_DELETED = 0 and mi.ITEM_TYPE > 0) order by m.OS_FNAME, m.id ) a where rownum <= 50) r left join tm_device_lst l on (r.srver_id = l.id) where rnum >= 1 order by rnum t Verbose: 1220 : 12|02:58:50.6857|nh_aO5|CJPOWERCAST|imfx v3 API took 0.012s '/api/v3/media/299691/carriers/digital?_dc=1688003931647' t Transfer: 1220 : 12|03:01:34.5085|0fT0uE|CJPOWERCAST|OAuth: /api/v3/version/299545/media?_dc=1688004094776 t Transfer: 1220 : 12|03:01:34.5085|0fT0uE|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|03:01:34.5085|0fT0uE|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|03:01:34.5085|0fT0uE|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|03:01:34.5085|0fT0uE|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|03:01:34.5095|3ZQME3|CJPOWERCAST|OAuth: /api/v3/version/299545/media?_dc=1688004094870 t Transfer: 1220 : 12|03:01:34.5095|3ZQME3|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|03:01:34.5095|3ZQME3|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|03:01:34.5095|3ZQME3|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|03:01:34.5095|3ZQME3|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|03:01:34.5095|0fT0uE|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|03:01:34.5095|0fT0uE|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|03:01:34.5105|0fT0uE|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|03:01:34.5105|0fT0uE|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|03:01:34.5105|0fT0uE|CJPOWERCAST|MediaSearch SQL: --sqlFromPaging select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type in (1,110)),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , (SELECT min(status.ACCESS_STATUS_NAME) FROM TMDDBA.TM_ACCESS_STATUS statusLnx, TM_CFG_ACCESS_STATUS status WHERE statusLnx.Media_Id = r.id and statusLnx.Status_Id = status.id) ACCESS_STATUS , (select min(acq.ext_ref) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) CONSIGNMENT_NUMBER , (select min(acq.alt_id1) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) TRANSFER_NUMBER , (select min(crs.series_number) from tm_series_data crs where crs.id = r.GROUP_SERIES_ID) CRS_SERIES , (select min(DISPOSAL_NAME) from TM_ACQ_DISPOSAL status, tm_disposal_records records where status.id = records.disposal_status_id and records.miid = r.id) DISPOSAL_STATUS , (select min(class.class_number) from TM_ACQ_DISPOSAL status, tm_disposal_records records, tm_disposal_classes class where status.id = records.disposal_status_id and records.miid = r.id and class.id = records.disposal_class_id) DISPOSAL_CLASS, (select min(names.concat_search_name) from tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names where r.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY, (select min(c.u_id_ext1) from tmddba.tm_mi_tpi_lnx lnx, tm_ctnrs c where c.u_id = lnx.tpiid and lnx.miid = r.id) U_ID_EXT1 , (select t.name from TM_CFG_MI_FMT_TYP t where t.id = r.mi_fmt_type) ITEM_FORMAT_TEXT, CASE WHEN BITAND(r.COMPIL, 2) = 2 THEN 'SUPPLIED' WHEN BITAND(r.COMPIL, 4) = 4 THEN 'MADE' WHEN BITAND(r.COMPIL, 134217728) = 134217728 THEN 'IMPORTED' ELSE '' END AS ORIGIN, CASE WHEN BITAND(r.COMPIL, 512) = 512 THEN 'Attached' WHEN BITAND(r.COMPIL, 1024) = 1024 THEN 'Un-Attached' ELSE '' END AS FLAGS, (select min(lang.full_name) from TM_PG_RL_LANG_LNX lnx, TM_LANG_DATA lang where lnx.tm_pg_rl_id = r.pgm_parent_id and lnx.lang_id = lang.id) AS PROD_LANGUAGE , (select min(ctx.ITFC_CODE) from tm_mis mis, tm_mi_tpi_lnx links, tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names where mis.id = r.id and links.miid = mis.id and mis.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY_NUMBER, (select min(status.description) from TM_CFG_PGM_STATUS status where r.status = status.id) PGM_STATUS_TEXT, (select min(ver.DUR) from TM_PG_RL ver where r.pgm_PARENT_ID = ver.id) AS VERSION_DUR , (select tmd_str_agg_pipe(cms.status_type_id ||',' ||cms.status_id) from tm_mi_cust_med_stat_lnx cms where cms.media_id=r.id) "CustomStatusesRaw", (select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = r.net_grp_id) CHANNEL_GROUP, (SELECT SUBSTR( trim( replace (replace ( LISTAGG(trim(tt.tags || ' ' || tt.notes), ' ') WITHIN GROUP (ORDER BY trim(tt.tags || ' ' || tt.notes)), chr (13), ''), chr (10), ' ')), 1, 150) z FROM tm_media_tagging tt WHERE link_guid = DFILE_LINK_GUID and rownum=1) TAGS_TEXT , GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select t.*, coalesce(t.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=t.pgm_parent_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.pgm_abs_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs2_id) ) primary_thumb_id2 from ( --sqlSubSelect select s.* from (select a.*, rownum rnum from (select --sqlFrom m.* from tmddba.tm_mis m --sqlWhere where media_type>0 and item_type>0 AND PGM_PARENT_ID=:param_0 and m.mi_deleted=0 AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0) order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) s where rnum >= 1) t ) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl order by r.rnum t Information: 1220 : 12|03:01:34.5105|3ZQME3|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|03:01:34.5105|3ZQME3|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|03:01:34.5105|3ZQME3|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|03:01:34.5116|3ZQME3|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|03:01:34.5116|3ZQME3|CJPOWERCAST|MediaSearch SQL: --sqlFromPaging select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type in (1,110)),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , (SELECT min(status.ACCESS_STATUS_NAME) FROM TMDDBA.TM_ACCESS_STATUS statusLnx, TM_CFG_ACCESS_STATUS status WHERE statusLnx.Media_Id = r.id and statusLnx.Status_Id = status.id) ACCESS_STATUS , (select min(acq.ext_ref) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) CONSIGNMENT_NUMBER , (select min(acq.alt_id1) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) TRANSFER_NUMBER , (select min(crs.series_number) from tm_series_data crs where crs.id = r.GROUP_SERIES_ID) CRS_SERIES , (select min(DISPOSAL_NAME) from TM_ACQ_DISPOSAL status, tm_disposal_records records where status.id = records.disposal_status_id and records.miid = r.id) DISPOSAL_STATUS , (select min(class.class_number) from TM_ACQ_DISPOSAL status, tm_disposal_records records, tm_disposal_classes class where status.id = records.disposal_status_id and records.miid = r.id and class.id = records.disposal_class_id) DISPOSAL_CLASS, (select min(names.concat_search_name) from tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names where r.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY, (select min(c.u_id_ext1) from tmddba.tm_mi_tpi_lnx lnx, tm_ctnrs c where c.u_id = lnx.tpiid and lnx.miid = r.id) U_ID_EXT1 , (select t.name from TM_CFG_MI_FMT_TYP t where t.id = r.mi_fmt_type) ITEM_FORMAT_TEXT, CASE WHEN BITAND(r.COMPIL, 2) = 2 THEN 'SUPPLIED' WHEN BITAND(r.COMPIL, 4) = 4 THEN 'MADE' WHEN BITAND(r.COMPIL, 134217728) = 134217728 THEN 'IMPORTED' ELSE '' END AS ORIGIN, CASE WHEN BITAND(r.COMPIL, 512) = 512 THEN 'Attached' WHEN BITAND(r.COMPIL, 1024) = 1024 THEN 'Un-Attached' ELSE '' END AS FLAGS, (select min(lang.full_name) from TM_PG_RL_LANG_LNX lnx, TM_LANG_DATA lang where lnx.tm_pg_rl_id = r.pgm_parent_id and lnx.lang_id = lang.id) AS PROD_LANGUAGE , (select min(ctx.ITFC_CODE) from tm_mis mis, tm_mi_tpi_lnx links, tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names where mis.id = r.id and links.miid = mis.id and mis.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY_NUMBER, (select min(status.description) from TM_CFG_PGM_STATUS status where r.status = status.id) PGM_STATUS_TEXT, (select min(ver.DUR) from TM_PG_RL ver where r.pgm_PARENT_ID = ver.id) AS VERSION_DUR , (select tmd_str_agg_pipe(cms.status_type_id ||',' ||cms.status_id) from tm_mi_cust_med_stat_lnx cms where cms.media_id=r.id) "CustomStatusesRaw", (select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = r.net_grp_id) CHANNEL_GROUP, (SELECT SUBSTR( trim( replace (replace ( LISTAGG(trim(tt.tags || ' ' || tt.notes), ' ') WITHIN GROUP (ORDER BY trim(tt.tags || ' ' || tt.notes)), chr (13), ''), chr (10), ' ')), 1, 150) z FROM tm_media_tagging tt WHERE link_guid = DFILE_LINK_GUID and rownum=1) TAGS_TEXT , GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select t.*, coalesce(t.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=t.pgm_parent_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.pgm_abs_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs2_id) ) primary_thumb_id2 from ( --sqlSubSelect select s.* from (select a.*, rownum rnum from (select --sqlFrom m.* from tmddba.tm_mis m --sqlWhere where media_type>0 and item_type>0 AND PGM_PARENT_ID=:param_0 and m.mi_deleted=0 AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0) order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) s where rnum >= 1) t ) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl order by r.rnum t Verbose: 1220 : 12|03:01:34.7125|3ZQME3|CJPOWERCAST|Alternative title fields query: select * from (select x.id,x.pgm_abs_id TitleId, x.pgm_parent_id VersionId from tm_mis x where id in (select /*+ cardinality(4) */ column_value id from table(:ids))) y,lateral (select dbms_lob.substr( o.text_data_plain, 1000, 1 ) Field_5799344 from tm_txt_obj o where (o.pgm_abs_id=y.TitleId or o.pgm_rl_id = y.VersionId) and o.type_id=:param_1 order by o.id desc fetch first 1 rows only)(+) t Verbose: 1220 : 12|03:01:34.7125|0fT0uE|CJPOWERCAST|Alternative title fields query: select * from (select x.id,x.pgm_abs_id TitleId, x.pgm_parent_id VersionId from tm_mis x where id in (select /*+ cardinality(4) */ column_value id from table(:ids))) y,lateral (select dbms_lob.substr( o.text_data_plain, 1000, 1 ) Field_5799344 from tm_txt_obj o where (o.pgm_abs_id=y.TitleId or o.pgm_rl_id = y.VersionId) and o.type_id=:param_1 order by o.id desc fetch first 1 rows only)(+) t Information: 1220 : 12|03:01:34.7125|3ZQME3|CJPOWERCAST| timing: 00:00:00.0305372 t Verbose: 1220 : 12|03:01:34.7125|3ZQME3|CJPOWERCAST|imfx v3 API took 0.031s '/api/v3/version/299545/media?_dc=1688004094870' t Transfer: 1220 : 12|03:01:34.7125|3ZQME3|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0178.mp4 subfolder t Transfer: 1220 : 12|03:01:34.7125|3ZQME3|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0178.mp4 t Transfer: 1220 : 12|03:01:34.7125|3ZQME3|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0178.mp4 t Transfer: 1220 : 12|03:01:34.7135|3ZQME3|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|03:01:34.7135|3ZQME3|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|03:01:34.7135|3ZQME3|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|03:01:34.7135|3ZQME3|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001992.mp4 subfolder t Transfer: 1220 : 12|03:01:34.7135|3ZQME3|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001992.mp4 t Transfer: 1220 : 12|03:01:34.7135|3ZQME3|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001992.mp4 t Transfer: 1220 : 12|03:01:34.7135|3ZQME3|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|03:01:34.7135|3ZQME3|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|03:01:34.7135|3ZQME3|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|03:01:34.7135|3ZQME3|CJPOWERCAST|GetUrl. Storage |Temp Storage| filename C:\TEMP\N0001992.mp4 subfolder t Transfer: 1220 : 12|03:01:34.7135|3ZQME3|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|03:01:34.7145|3ZQME3|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|03:01:34.7145|3ZQME3|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|03:01:34.7145|3ZQME3|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0178.xml subfolder t Transfer: 1220 : 12|03:01:34.7145|3ZQME3|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0178.xml t Transfer: 1220 : 12|03:01:34.7145|3ZQME3|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0178.xml t Transfer: 1220 : 12|03:01:34.7145|3ZQME3|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|03:01:34.7145|3ZQME3|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|03:01:34.7145|3ZQME3|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|03:01:34.7145|0fT0uE|CJPOWERCAST| timing: 00:00:00.1474101 t Verbose: 1220 : 12|03:01:34.7155|0fT0uE|CJPOWERCAST|imfx v3 API took 0.148s '/api/v3/version/299545/media?_dc=1688004094776' t Transfer: 1220 : 12|03:01:34.7155|0fT0uE|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0178.mp4 subfolder t Transfer: 1220 : 12|03:01:34.7155|0fT0uE|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0178.mp4 t Transfer: 1220 : 12|03:01:34.7155|0fT0uE|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0178.mp4 t Transfer: 1220 : 12|03:01:34.7155|0fT0uE|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|03:01:34.7155|0fT0uE|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|03:01:34.7155|0fT0uE|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|03:01:34.7155|0fT0uE|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001992.mp4 subfolder t Transfer: 1220 : 12|03:01:34.7155|0fT0uE|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001992.mp4 t Transfer: 1220 : 12|03:01:34.7155|0fT0uE|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001992.mp4 t Transfer: 1220 : 12|03:01:34.7155|0fT0uE|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|03:01:34.7165|0fT0uE|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|03:01:34.7165|0fT0uE|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|03:01:34.7165|0fT0uE|CJPOWERCAST|GetUrl. Storage |Temp Storage| filename C:\TEMP\N0001992.mp4 subfolder t Transfer: 1220 : 12|03:01:34.7165|0fT0uE|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|03:01:34.7165|0fT0uE|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|03:01:34.7165|0fT0uE|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|03:01:34.7165|0fT0uE|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0178.xml subfolder t Transfer: 1220 : 12|03:01:34.7165|0fT0uE|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0178.xml t Transfer: 1220 : 12|03:01:34.7165|0fT0uE|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0178.xml t Transfer: 1220 : 12|03:01:34.7165|0fT0uE|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|03:01:34.7175|0fT0uE|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|03:01:34.7175|0fT0uE|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|03:01:35.5215|cgTXAL|CJPOWERCAST|OAuth: /api/v3/media/299534/carriers/digital?_dc=1688004096561 t Transfer: 1220 : 12|03:01:35.5215|cgTXAL|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|03:01:35.5215|cgTXAL|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|03:01:35.5215|cgTXAL|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|03:01:35.5215|cgTXAL|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|03:01:35.5225|cgTXAL|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|03:01:35.5225|cgTXAL|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|03:01:35.5225|cgTXAL|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|03:01:35.5225|cgTXAL|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|03:01:35.5225|cgTXAL|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|03:01:35.5225|cgTXAL|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|03:01:35.5225|cgTXAL|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|03:01:35.5235|cgTXAL|CJPOWERCAST|SearchDigitalCarriersAdv SQL: select r.*, l.dv_nam SRVER_ID_TEXT from ( select a.*, rownum rnum from ( select m.* from tmddba.tm_dfile m where m.id in (select l.dfile_id as ID from TMDDBA.tm_mi_dfile_lnx l join TMDDBA.TM_MIS mi on (l.mi_id = mi.id) where (INSTR(mi.OWNERS,'|SFP2|')>0 OR INSTR(mi.OWNERS,'|PSP|')>0 OR INSTR(mi.OWNERS,'|PMS|')>0 OR INSTR(mi.OWNERS,'|SFP1|')>0 OR INSTR(mi.OWNERS,'|PMH|')>0 OR INSTR(mi.OWNERS,'|PPL|')>0)and mi.MI_DELETED = 0 and mi.ITEM_TYPE > 0) and m.id in (select l.dfile_id as ID from TMDDBA.tm_mi_dfile_lnx l join TMDDBA.TM_MIS mi on (l.mi_id = mi.id) where mi.id = :param_0 AND (INSTR(mi.OWNERS,'|SFP2|')>0 OR INSTR(mi.OWNERS,'|PSP|')>0 OR INSTR(mi.OWNERS,'|PMS|')>0 OR INSTR(mi.OWNERS,'|SFP1|')>0 OR INSTR(mi.OWNERS,'|PMH|')>0 OR INSTR(mi.OWNERS,'|PPL|')>0)and mi.MI_DELETED = 0 and mi.ITEM_TYPE > 0) order by m.OS_FNAME, m.id ) a where rownum <= 50) r left join tm_device_lst l on (r.srver_id = l.id) where rnum >= 1 order by rnum t Verbose: 1220 : 12|03:01:35.7245|cgTXAL|CJPOWERCAST|imfx v3 API took 0.015s '/api/v3/media/299534/carriers/digital?_dc=1688004096561' t Transfer: 1220 : 12|03:01:37.5335|r~H_iU|CJPOWERCAST|OAuth: /api/user-group-preferences?keys=googleMapsApiSettings&_dc=1688004098487 t Transfer: 1220 : 12|03:01:37.5335|r~H_iU|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|03:01:37.5335|r~H_iU|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|03:01:37.5335|r~H_iU|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|03:01:37.5345|r~H_iU|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|03:01:37.5345|r~H_iU|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|03:01:37.5345|r~H_iU|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|03:01:37.5345|r~H_iU|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|03:01:37.5345|r~H_iU|CJPOWERCAST|imfx v3 API took 0.012s '/api/user-group-preferences?keys=googleMapsApiSettings&_dc=1688004098487' t Transfer: 1220 : 12|03:01:37.5345|qs8A6N|CJPOWERCAST|OAuth: /api/v3/detailsview/VersionDetails/0?lang=en-GB&_dc=1688004098556 t Transfer: 1220 : 12|03:01:37.5345|qs8A6N|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|03:01:37.5355|qs8A6N|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|03:01:37.5355|qs8A6N|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|03:01:37.5355|qs8A6N|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|03:01:37.5355|qs8A6N|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|03:01:37.5355|qs8A6N|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|03:01:37.5355|qs8A6N|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|03:01:37.5365|qs8A6N|CJPOWERCAST|GetSystemPref. Pref: DetailsView, Type: -4014, subType: 0 t Information: 1220 : 12|03:01:37.7375|qs8A6N|CJPOWERCAST|GetSystemPref. Pref: DetailsView, Type: -4014, subType: 0 t Verbose: 1220 : 12|03:01:37.7375|qs8A6N|CJPOWERCAST|imfx v3 API took 0.105s '/api/v3/detailsview/VersionDetails/0?lang=en-GB&_dc=1688004098556' t Transfer: 1220 : 12|03:01:37.9385|~ZsXTE|CJPOWERCAST|OAuth: /api/v3/version-details/299545?_dc=1688004098967 t Transfer: 1220 : 12|03:01:37.9385|~ZsXTE|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|03:01:37.9385|~ZsXTE|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|03:01:37.9385|~ZsXTE|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|03:01:37.9385|~ZsXTE|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|03:01:37.9385|~ZsXTE|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|03:01:37.9385|~ZsXTE|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|03:01:37.9385|~ZsXTE|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|03:01:37.9395|~ZsXTE|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|03:01:37.9395|~ZsXTE|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|03:01:37.9395|~ZsXTE|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|03:01:37.9395|~ZsXTE|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 : 12|03:01:38.1405|~ZsXTE|CJPOWERCAST|Running version search. User: 1165 Simple Search: Running Oracle search. Running Oracle search for COUNT Oracle count completed in: 7ms. Returned lines: 1 Oracle version search timing: 58ms. 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 : 12|03:01:38.1405|~ZsXTE|CJPOWERCAST|imfx v3 API took 0.126s '/api/v3/version-details/299545?_dc=1688004098967' t Transfer: 1220 : 12|03:01:38.7435|BEMVhj|CJPOWERCAST|OAuth: /api/lookups/FriendlyNames?_dc=1688004099606 t Transfer: 1220 : 12|03:01:38.7435|BEMVhj|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|03:01:38.7435|BEMVhj|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|03:01:38.7435|BEMVhj|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|03:01:38.7435|BEMVhj|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 12|03:01:38.7435|BEMVhj|CJPOWERCAST|imfx v3 API took 0.000s '/api/lookups/FriendlyNames?_dc=1688004099606' t Transfer: 1220 : 12|03:01:38.7435|jRUWyh|CJPOWERCAST|OAuth: /api/v3/imf/299545?_dc=1688004099653 t Transfer: 1220 : 12|03:01:38.7435|jRUWyh|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|03:01:38.7445|jRUWyh|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|03:01:38.7445|jRUWyh|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|03:01:38.7445|jRUWyh|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 12|03:01:38.7445|jRUWyh|CJPOWERCAST|imfx v3 API took 0.024s '/api/v3/imf/299545?_dc=1688004099653' t Transfer: 1220 : 12|03:01:38.7445|cJayzL|CJPOWERCAST|OAuth: /api/metadata/1040/299545?_dc=1688004099768 t Transfer: 1220 : 12|03:01:38.7445|cJayzL|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|03:01:38.7445|cJayzL|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|03:01:38.7445|cJayzL|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|03:01:38.7445|cJayzL|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 12|03:01:38.9455|cJayzL|CJPOWERCAST|imfx v3 API took 0.047s '/api/metadata/1040/299545?_dc=1688004099768' t Transfer: 1220 : 12|03:01:41.9605|vSxzA2|CJPOWERCAST|OAuth: /api/v3/search/Media?_dc=1688004102987 t Transfer: 1220 : 12|03:01:41.9605|vSxzA2|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|03:01:41.9605|vSxzA2|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|03:01:41.9605|vSxzA2|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|03:01:41.9605|vSxzA2|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|03:01:41.9605|6tT2Nf|CJPOWERCAST|OAuth: /api/v3/search/versions?_dc=1688004102984 t Transfer: 1220 : 12|03:01:41.9605|6tT2Nf|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|03:01:41.9605|6tT2Nf|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|03:01:41.9615|6tT2Nf|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|03:01:41.9615|6tT2Nf|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|03:01:41.9615|vSxzA2|CJPOWERCAST|V3Api.SearchMedia t Information: 1220 : 12|03:01:41.9615|vSxzA2|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|03:01:41.9615|vSxzA2|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|03:01:41.9615|vSxzA2|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|03:01:41.9615|vSxzA2|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|03:01:41.9615|6tT2Nf|CJPOWERCAST|V3Api.SearchVersions t Information: 1220 : 12|03:01:41.9625|6tT2Nf|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|03:01:41.9625|6tT2Nf|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|03:01:41.9625|6tT2Nf|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|03:01:41.9625|6tT2Nf|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|03:01:41.9625|6tT2Nf|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|03:01:41.9625|6tT2Nf|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|03:01:41.9625|6tT2Nf|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|03:01:41.9625|vSxzA2|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 : 12|03:01:41.9635|6tT2Nf|CJPOWERCAST|SearchVersion SQL: select * from (select a.*, rownum rnum from ( select m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE , (select min(name) from TM_CFG_AUDIO_CONTENT_MS_TYPES audio where m.audio_type = audio.id ) SOUND ,(select min(from_date_time) from TM_PG_RL_PROD_DATE prodDate where prodDate.Tm_Pg_Rl_Id = m.id ) PROD_FROM_DATE ,(select min(to_date_time) from TM_PG_RL_PROD_DATE prodDate where prodDate.Tm_Pg_Rl_Id = m.id ) PROD_TO_DATE ,(select min(full_name) from tm_lang_data lang, TM_PG_RL_LANG_LNX link where lang.id = link.lang_id and link.tm_pg_rl_id = m.id) PROD_LANGUAGE ,(SELECT min(COLOUR_NAME) FROM tm_cfg_colour_list list, tm_pg_rl ver where ver.col_mono = list.id and ver.id = m.id) PROD_COLOUR_TEXT ,(SELECT min(cfg.prod_date_type_name) FROM TM_PG_RL_PROD_DATE pg_rl, tm_cfg_prod_date_type cfg where cfg.id = pg_rl.PROD_DATE_TYPE_ID and TM_PG_RL_ID = m.id ) PROD_DATE_TYPE ,(select min(status.description) from TM_CFG_PGM_STATUS status where m.ITEM_STATUS_ID = status.id) PGM_STATUS_TEXT ,(select submed.sub_medium_name from TM_CFG_SUB_MEDIUM submed where m.SUB_MEDIUM_ID = submed.id) SUB_MEDIUM_TEXT, (select cvt.ID from TM_PORTAL_VERSION_CONFIG cvt where m.CUSTOM_VERSION_TYPE = cvt.CUSTOM_VERSION_TYPE AND cvt.CUSTOM_VERSION_TYPE IS NOT NULL ) MP_CONFIG_ID from (select v.*, coalesce(v.primary_thumb_id, (select x.primary_thumb_id from tm_pg_rl x where x.id=v.parent_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.pgm_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs2_id) ) primary_thumb_id2 from tmddba.tm_pg_rl v) m left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id2 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 : 12|03:01:42.5665|6tT2Nf|CJPOWERCAST|Running version search. User: 1165 Simple Search: Running Oracle search. Running Oracle search for COUNT Oracle count completed in: 2ms. Returned lines: 1 Oracle version search timing: 482ms. SQL run: select * from (select a.*, rownum rnum from ( select m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE , (select min(name) from TM_CFG_AUDIO_CONTENT_MS_TYPES audio where m.audio_type = audio.id ) SOUND ,(select min(from_date_time) from TM_PG_RL_PROD_DATE prodDate where prodDate.Tm_Pg_Rl_Id = m.id ) PROD_FROM_DATE ,(select min(to_date_time) from TM_PG_RL_PROD_DATE prodDate where prodDate.Tm_Pg_Rl_Id = m.id ) PROD_TO_DATE ,(select min(full_name) from tm_lang_data lang, TM_PG_RL_LANG_LNX link where lang.id = link.lang_id and link.tm_pg_rl_id = m.id) PROD_LANGUAGE ,(SELECT min(COLOUR_NAME) FROM tm_cfg_colour_list list, tm_pg_rl ver where ver.col_mono = list.id and ver.id = m.id) PROD_COLOUR_TEXT ,(SELECT min(cfg.prod_date_type_name) FROM TM_PG_RL_PROD_DATE pg_rl, tm_cfg_prod_date_type cfg where cfg.id = pg_rl.PROD_DATE_TYPE_ID and TM_PG_RL_ID = m.id ) PROD_DATE_TYPE ,(select min(status.description) from TM_CFG_PGM_STATUS status where m.ITEM_STATUS_ID = status.id) PGM_STATUS_TEXT ,(select submed.sub_medium_name from TM_CFG_SUB_MEDIUM submed where m.SUB_MEDIUM_ID = submed.id) SUB_MEDIUM_TEXT, (select cvt.ID from TM_PORTAL_VERSION_CONFIG cvt where m.CUSTOM_VERSION_TYPE = cvt.CUSTOM_VERSION_TYPE AND cvt.CUSTOM_VERSION_TYPE IS NOT NULL ) MP_CONFIG_ID from (select v.*, coalesce(v.primary_thumb_id, (select x.primary_thumb_id from tm_pg_rl x where x.id=v.parent_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.pgm_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs2_id) ) primary_thumb_id2 from tmddba.tm_pg_rl v) m left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id2 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 : 12|03:01:42.5665|6tT2Nf|CJPOWERCAST|imfx v3 API took 0.489s '/api/v3/search/versions?_dc=1688004102984' t Verbose: 1220 : 12|03:01:42.7675|vSxzA2|CJPOWERCAST|Alternative title fields query: select * from (select x.id,x.pgm_abs_id TitleId, x.pgm_parent_id VersionId from tm_mis x where id in (select /*+ cardinality(4) */ column_value id from table(:ids))) y,lateral (select dbms_lob.substr( o.text_data_plain, 1000, 1 ) Field_5799344 from tm_txt_obj o where (o.pgm_abs_id=y.TitleId or o.pgm_rl_id = y.VersionId) and o.type_id=:param_1 order by o.id desc fetch first 1 rows only)(+) t Information: 1220 : 12|03:01:42.7675|vSxzA2|CJPOWERCAST| timing: 00:00:00.6795876 t Verbose: 1220 : 12|03:01:42.7675|vSxzA2|CJPOWERCAST|imfx v3 API took 0.680s '/api/v3/search/Media?_dc=1688004102987' t Transfer: 1220 : 12|03:01:45.3815|C6DELx|CJPOWERCAST|OAuth: /api/user-group-preferences?keys=googleMapsApiSettings&_dc=1688004106249 t Transfer: 1220 : 12|03:01:45.3815|C6DELx|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|03:01:45.3815|C6DELx|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|03:01:45.3815|C6DELx|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|03:01:45.3815|C6DELx|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|03:01:45.3815|C6DELx|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|03:01:45.3815|C6DELx|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|03:01:45.3815|C6DELx|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|03:01:45.3825|C6DELx|CJPOWERCAST|imfx v3 API took 0.006s '/api/user-group-preferences?keys=googleMapsApiSettings&_dc=1688004106249' t Transfer: 1220 : 12|03:01:45.3825|~MIYrI|CJPOWERCAST|OAuth: /api/v3/title-details/299544?_dc=1688004106258 t Transfer: 1220 : 12|03:01:45.3825|~MIYrI|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|03:01:45.3825|~MIYrI|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|03:01:45.3825|~MIYrI|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|03:01:45.3825|~MIYrI|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 12|03:01:45.3825|~MIYrI|CJPOWERCAST|imfx v3 API took 0.015s '/api/v3/title-details/299544?_dc=1688004106258' t Transfer: 1220 : 12|03:01:45.5835|0LuRYn|CJPOWERCAST|OAuth: /api/v3/detailsview/TitleDetails/0?lang=en-GB&_dc=1688004106576 t Transfer: 1220 : 12|03:01:45.5835|0LuRYn|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|03:01:45.5845|0LuRYn|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|03:01:45.5845|0LuRYn|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|03:01:45.5845|0LuRYn|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|03:01:45.5845|0LuRYn|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|03:01:45.5845|0LuRYn|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|03:01:45.5845|0LuRYn|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|03:01:45.5855|0LuRYn|CJPOWERCAST|GetSystemPref. Pref: DetailsView, Type: -4020, subType: 0 t Information: 1220 : 12|03:01:45.5855|0LuRYn|CJPOWERCAST|GetSystemPref. Pref: DetailsView, Type: -4020, subType: 0 t Verbose: 1220 : 12|03:01:45.5855|0LuRYn|CJPOWERCAST|imfx v3 API took 0.021s '/api/v3/detailsview/TitleDetails/0?lang=en-GB&_dc=1688004106576' t Transfer: 1220 : 12|03:01:45.9875|n1aYc1|CJPOWERCAST|OAuth: /api/lookups/FriendlyNames?_dc=1688004106928 t Transfer: 1220 : 12|03:01:45.9875|n1aYc1|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|03:01:45.9875|n1aYc1|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|03:01:45.9875|n1aYc1|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|03:01:45.9875|n1aYc1|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 12|03:01:45.9875|n1aYc1|CJPOWERCAST|imfx v3 API took 0.000s '/api/lookups/FriendlyNames?_dc=1688004106928' t Transfer: 1220 : 12|03:01:47.7965|ID4KPo|CJPOWERCAST|OAuth: /api/v3/search/Media?_dc=1688004108840 t Transfer: 1220 : 12|03:01:47.7975|ID4KPo|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|03:01:47.7975|ID4KPo|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|03:01:47.7975|ID4KPo|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|03:01:47.7975|ID4KPo|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|03:01:47.7975|Hg3oKs|CJPOWERCAST|OAuth: /api/v3/search/versions?_dc=1688004108839 t Transfer: 1220 : 12|03:01:47.7975|Hg3oKs|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|03:01:47.7995|Hg3oKs|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|03:01:47.7995|Hg3oKs|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|03:01:47.7995|Hg3oKs|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|03:01:47.7995|ID4KPo|CJPOWERCAST|V3Api.SearchMedia t Information: 1220 : 12|03:01:47.7995|ID4KPo|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|03:01:47.8005|ID4KPo|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|03:01:47.8005|ID4KPo|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|03:01:47.8005|ID4KPo|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|03:01:47.8005|Hg3oKs|CJPOWERCAST|V3Api.SearchVersions t Information: 1220 : 12|03:01:47.8005|Hg3oKs|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|03:01:47.8005|Hg3oKs|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|03:01:47.8015|Hg3oKs|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|03:01:47.8015|Hg3oKs|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|03:01:47.8015|Hg3oKs|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|03:01:47.8015|Hg3oKs|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|03:01:47.8025|Hg3oKs|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|03:01:47.8025|ID4KPo|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 : 12|03:01:47.8025|Hg3oKs|CJPOWERCAST|SearchVersion SQL: select * from (select a.*, rownum rnum from ( select m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE , (select min(name) from TM_CFG_AUDIO_CONTENT_MS_TYPES audio where m.audio_type = audio.id ) SOUND ,(select min(from_date_time) from TM_PG_RL_PROD_DATE prodDate where prodDate.Tm_Pg_Rl_Id = m.id ) PROD_FROM_DATE ,(select min(to_date_time) from TM_PG_RL_PROD_DATE prodDate where prodDate.Tm_Pg_Rl_Id = m.id ) PROD_TO_DATE ,(select min(full_name) from tm_lang_data lang, TM_PG_RL_LANG_LNX link where lang.id = link.lang_id and link.tm_pg_rl_id = m.id) PROD_LANGUAGE ,(SELECT min(COLOUR_NAME) FROM tm_cfg_colour_list list, tm_pg_rl ver where ver.col_mono = list.id and ver.id = m.id) PROD_COLOUR_TEXT ,(SELECT min(cfg.prod_date_type_name) FROM TM_PG_RL_PROD_DATE pg_rl, tm_cfg_prod_date_type cfg where cfg.id = pg_rl.PROD_DATE_TYPE_ID and TM_PG_RL_ID = m.id ) PROD_DATE_TYPE ,(select min(status.description) from TM_CFG_PGM_STATUS status where m.ITEM_STATUS_ID = status.id) PGM_STATUS_TEXT ,(select submed.sub_medium_name from TM_CFG_SUB_MEDIUM submed where m.SUB_MEDIUM_ID = submed.id) SUB_MEDIUM_TEXT, (select cvt.ID from TM_PORTAL_VERSION_CONFIG cvt where m.CUSTOM_VERSION_TYPE = cvt.CUSTOM_VERSION_TYPE AND cvt.CUSTOM_VERSION_TYPE IS NOT NULL ) MP_CONFIG_ID from (select v.*, coalesce(v.primary_thumb_id, (select x.primary_thumb_id from tm_pg_rl x where x.id=v.parent_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.pgm_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs2_id) ) primary_thumb_id2 from tmddba.tm_pg_rl v) m left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id2 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 : 12|03:01:48.0035|Hg3oKs|CJPOWERCAST|Running version search. User: 1165 Simple Search: Running Oracle search. Running Oracle search for COUNT Oracle count completed in: 2ms. Returned lines: 1 Oracle version search timing: 8ms. SQL run: select * from (select a.*, rownum rnum from ( select m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE , (select min(name) from TM_CFG_AUDIO_CONTENT_MS_TYPES audio where m.audio_type = audio.id ) SOUND ,(select min(from_date_time) from TM_PG_RL_PROD_DATE prodDate where prodDate.Tm_Pg_Rl_Id = m.id ) PROD_FROM_DATE ,(select min(to_date_time) from TM_PG_RL_PROD_DATE prodDate where prodDate.Tm_Pg_Rl_Id = m.id ) PROD_TO_DATE ,(select min(full_name) from tm_lang_data lang, TM_PG_RL_LANG_LNX link where lang.id = link.lang_id and link.tm_pg_rl_id = m.id) PROD_LANGUAGE ,(SELECT min(COLOUR_NAME) FROM tm_cfg_colour_list list, tm_pg_rl ver where ver.col_mono = list.id and ver.id = m.id) PROD_COLOUR_TEXT ,(SELECT min(cfg.prod_date_type_name) FROM TM_PG_RL_PROD_DATE pg_rl, tm_cfg_prod_date_type cfg where cfg.id = pg_rl.PROD_DATE_TYPE_ID and TM_PG_RL_ID = m.id ) PROD_DATE_TYPE ,(select min(status.description) from TM_CFG_PGM_STATUS status where m.ITEM_STATUS_ID = status.id) PGM_STATUS_TEXT ,(select submed.sub_medium_name from TM_CFG_SUB_MEDIUM submed where m.SUB_MEDIUM_ID = submed.id) SUB_MEDIUM_TEXT, (select cvt.ID from TM_PORTAL_VERSION_CONFIG cvt where m.CUSTOM_VERSION_TYPE = cvt.CUSTOM_VERSION_TYPE AND cvt.CUSTOM_VERSION_TYPE IS NOT NULL ) MP_CONFIG_ID from (select v.*, coalesce(v.primary_thumb_id, (select x.primary_thumb_id from tm_pg_rl x where x.id=v.parent_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.pgm_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs2_id) ) primary_thumb_id2 from tmddba.tm_pg_rl v) m left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id2 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 : 12|03:01:48.0035|Hg3oKs|CJPOWERCAST|imfx v3 API took 0.017s '/api/v3/search/versions?_dc=1688004108839' t Verbose: 1220 : 12|03:01:48.0035|ID4KPo|CJPOWERCAST|Alternative title fields query: select * from (select x.id,x.pgm_abs_id TitleId, x.pgm_parent_id VersionId from tm_mis x where id in (select /*+ cardinality(4) */ column_value id from table(:ids))) y,lateral (select dbms_lob.substr( o.text_data_plain, 1000, 1 ) Field_5799344 from tm_txt_obj o where (o.pgm_abs_id=y.TitleId or o.pgm_rl_id = y.VersionId) and o.type_id=:param_1 order by o.id desc fetch first 1 rows only)(+) t Information: 1220 : 12|03:01:48.0045|ID4KPo|CJPOWERCAST| timing: 00:00:00.0226869 t Verbose: 1220 : 12|03:01:48.0045|ID4KPo|CJPOWERCAST|imfx v3 API took 0.023s '/api/v3/search/Media?_dc=1688004108840' t Transfer: 1220 : 12|03:02:49.7285|8gMfGL|CJPOWERCAST|OAuth: /api/v3/media/299552/carriers/digital?_dc=1688004170779 t Transfer: 1220 : 12|03:02:49.7285|8gMfGL|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|03:02:49.7285|8gMfGL|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|03:02:49.7285|8gMfGL|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|03:02:49.7295|8gMfGL|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|03:02:49.7295|8gMfGL|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|03:02:49.7295|8gMfGL|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|03:02:49.7295|8gMfGL|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|03:02:49.7295|8gMfGL|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|03:02:49.9305|8gMfGL|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|03:02:49.9305|8gMfGL|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|03:02:49.9305|8gMfGL|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|03:02:49.9305|8gMfGL|CJPOWERCAST|SearchDigitalCarriersAdv SQL: select r.*, l.dv_nam SRVER_ID_TEXT from ( select a.*, rownum rnum from ( select m.* from tmddba.tm_dfile m where m.id in (select l.dfile_id as ID from TMDDBA.tm_mi_dfile_lnx l join TMDDBA.TM_MIS mi on (l.mi_id = mi.id) where (INSTR(mi.OWNERS,'|SFP2|')>0 OR INSTR(mi.OWNERS,'|PSP|')>0 OR INSTR(mi.OWNERS,'|PMS|')>0 OR INSTR(mi.OWNERS,'|SFP1|')>0 OR INSTR(mi.OWNERS,'|PMH|')>0 OR INSTR(mi.OWNERS,'|PPL|')>0)and mi.MI_DELETED = 0 and mi.ITEM_TYPE > 0) and m.id in (select l.dfile_id as ID from TMDDBA.tm_mi_dfile_lnx l join TMDDBA.TM_MIS mi on (l.mi_id = mi.id) where mi.id = :param_0 AND (INSTR(mi.OWNERS,'|SFP2|')>0 OR INSTR(mi.OWNERS,'|PSP|')>0 OR INSTR(mi.OWNERS,'|PMS|')>0 OR INSTR(mi.OWNERS,'|SFP1|')>0 OR INSTR(mi.OWNERS,'|PMH|')>0 OR INSTR(mi.OWNERS,'|PPL|')>0)and mi.MI_DELETED = 0 and mi.ITEM_TYPE > 0) order by m.OS_FNAME, m.id ) a where rownum <= 50) r left join tm_device_lst l on (r.srver_id = l.id) where rnum >= 1 order by rnum t Verbose: 1220 : 12|03:02:49.9305|8gMfGL|CJPOWERCAST|imfx v3 API took 0.014s '/api/v3/media/299552/carriers/digital?_dc=1688004170779' t Transfer: 1220 : 12|03:02:53.9505|5eVBx8|CJPOWERCAST|OAuth: /api/v3/media/299534/carriers/digital?_dc=1688004174974 t Transfer: 1220 : 12|03:02:53.9505|5eVBx8|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|03:02:53.9505|5eVBx8|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|03:02:53.9515|5eVBx8|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|03:02:53.9515|5eVBx8|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|03:02:53.9515|5eVBx8|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|03:02:53.9515|5eVBx8|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|03:02:53.9515|5eVBx8|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|03:02:53.9525|5eVBx8|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|03:02:53.9525|5eVBx8|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|03:02:53.9525|5eVBx8|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|03:02:53.9525|5eVBx8|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|03:02:53.9525|5eVBx8|CJPOWERCAST|SearchDigitalCarriersAdv SQL: select r.*, l.dv_nam SRVER_ID_TEXT from ( select a.*, rownum rnum from ( select m.* from tmddba.tm_dfile m where m.id in (select l.dfile_id as ID from TMDDBA.tm_mi_dfile_lnx l join TMDDBA.TM_MIS mi on (l.mi_id = mi.id) where (INSTR(mi.OWNERS,'|SFP2|')>0 OR INSTR(mi.OWNERS,'|PSP|')>0 OR INSTR(mi.OWNERS,'|PMS|')>0 OR INSTR(mi.OWNERS,'|SFP1|')>0 OR INSTR(mi.OWNERS,'|PMH|')>0 OR INSTR(mi.OWNERS,'|PPL|')>0)and mi.MI_DELETED = 0 and mi.ITEM_TYPE > 0) and m.id in (select l.dfile_id as ID from TMDDBA.tm_mi_dfile_lnx l join TMDDBA.TM_MIS mi on (l.mi_id = mi.id) where mi.id = :param_0 AND (INSTR(mi.OWNERS,'|SFP2|')>0 OR INSTR(mi.OWNERS,'|PSP|')>0 OR INSTR(mi.OWNERS,'|PMS|')>0 OR INSTR(mi.OWNERS,'|SFP1|')>0 OR INSTR(mi.OWNERS,'|PMH|')>0 OR INSTR(mi.OWNERS,'|PPL|')>0)and mi.MI_DELETED = 0 and mi.ITEM_TYPE > 0) order by m.OS_FNAME, m.id ) a where rownum <= 50) r left join tm_device_lst l on (r.srver_id = l.id) where rnum >= 1 order by rnum t Verbose: 1220 : 12|03:02:53.9535|5eVBx8|CJPOWERCAST|imfx v3 API took 0.015s '/api/v3/media/299534/carriers/digital?_dc=1688004174974' t Transfer: 1220 : 12|03:03:48.4214|sgyUGA|CJPOWERCAST|OAuth: /api/v3/media/299552/carriers/digital?_dc=1688004229356 t Transfer: 1220 : 12|03:03:48.4214|sgyUGA|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|03:03:48.4214|sgyUGA|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|03:03:48.4214|sgyUGA|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|03:03:48.4214|sgyUGA|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|03:03:48.4214|sgyUGA|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|03:03:48.4214|sgyUGA|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|03:03:48.4224|sgyUGA|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|03:03:48.4224|sgyUGA|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|03:03:48.4224|sgyUGA|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|03:03:48.4224|sgyUGA|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|03:03:48.4224|sgyUGA|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|03:03:48.4224|sgyUGA|CJPOWERCAST|SearchDigitalCarriersAdv SQL: select r.*, l.dv_nam SRVER_ID_TEXT from ( select a.*, rownum rnum from ( select m.* from tmddba.tm_dfile m where m.id in (select l.dfile_id as ID from TMDDBA.tm_mi_dfile_lnx l join TMDDBA.TM_MIS mi on (l.mi_id = mi.id) where (INSTR(mi.OWNERS,'|SFP2|')>0 OR INSTR(mi.OWNERS,'|PSP|')>0 OR INSTR(mi.OWNERS,'|PMS|')>0 OR INSTR(mi.OWNERS,'|SFP1|')>0 OR INSTR(mi.OWNERS,'|PMH|')>0 OR INSTR(mi.OWNERS,'|PPL|')>0)and mi.MI_DELETED = 0 and mi.ITEM_TYPE > 0) and m.id in (select l.dfile_id as ID from TMDDBA.tm_mi_dfile_lnx l join TMDDBA.TM_MIS mi on (l.mi_id = mi.id) where mi.id = :param_0 AND (INSTR(mi.OWNERS,'|SFP2|')>0 OR INSTR(mi.OWNERS,'|PSP|')>0 OR INSTR(mi.OWNERS,'|PMS|')>0 OR INSTR(mi.OWNERS,'|SFP1|')>0 OR INSTR(mi.OWNERS,'|PMH|')>0 OR INSTR(mi.OWNERS,'|PPL|')>0)and mi.MI_DELETED = 0 and mi.ITEM_TYPE > 0) order by m.OS_FNAME, m.id ) a where rownum <= 50) r left join tm_device_lst l on (r.srver_id = l.id) where rnum >= 1 order by rnum t Verbose: 1220 : 12|03:03:48.4224|sgyUGA|CJPOWERCAST|imfx v3 API took 0.012s '/api/v3/media/299552/carriers/digital?_dc=1688004229356' t Information: 1220 : 12|03:43:49.4004|||OrabitWatcherBasic. Disposing. t Information: 1220 : 12|03:43:49.4004|||OrabitWatcherBasic. Disposed. t Information: 1220 : 12|03:43:49.4014|||========================================================================== t Information: 1220 : 12|03:43:49.4014|||IMFX CORE SERVER APPLICATION END.