t Transfer: 1220 :     15|09:23:30.9795|de0BZL||OAuth: /api/logout?_dc=1687163020556
t Transfer: 1220 :     15|09:23:30.9805|de0BZL||GetCurrentUser..
t Transfer: 1220 :     15|09:23:30.9805|de0BZL||  OAuth authenticated
t Verbose: 1220 :      15|09:23:30.9805|de0BZL||    uid claim is missing..
t Information: 1220 :  15|09:23:30.9815|de0BZL||OAuth. AutoLogin no Windows identity  type WindowsIdentity
t Transfer: 1220 :     15|09:23:31.3835|q2j9T6||GetAppInfo. DB: TMDDEMO. Install mode: . Auth types: Native, PublicApiKey
t Verbose: 1220 :      15|09:23:31.7855|JdEJRb||imfx v3 API took 0.081s '/api/v3/visual-asset/group/PnqJC_/2/image'
t Verbose: 1220 :      15|09:23:33.1935|H0eXYw||Oauth validating..
t Verbose: 1220 :      15|09:23:33.1935|H0eXYw||GrantResourceOwnerCredentials.
t Verbose: 1220 :      15|09:23:33.3945|H0eXYw||LoginUser. cjpowercast, login type OAuth, encrypt password True
t Information: 1220 :  15|09:23:33.3945|H0eXYw||TryLoginUser. cjpowercast, login type OAuth, check password True, check hash False, encrypt password True, load user data False
t Information: 1220 :  15|09:23:33.7965|H0eXYw||  oauth token 00000000-0000-0000-0000-000000000000
t Information: 1220 :  15|09:23:33.7965|H0eXYw||TryLoginUser. Logged in..
t Information: 1220 :  15|09:23:33.7965|H0eXYw||GetPasswordPolicy. WARNING: Policy not found for system Imediaflex. Validation disabled.
t Verbose: 1220 :      15|09:23:33.7965|H0eXYw||LoginUser. Adding history. User Id 1165, result CJPOWERCAST, host 192.168.127.6
t Verbose: 1220 :      15|09:23:33.7965|H0eXYw||GrantResourceOwnerCredentials. Try login finished. Logged: True
t Transfer: 1220 :     15|09:23:34.3995|wpOe0D|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=1687163023991
t Transfer: 1220 :     15|09:23:34.3995|wpOe0D|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:34.3995|wpOe0D|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:34.3995|wpOe0D|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:23:34.3995|wpOe0D|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     15|09:23:34.3995|wpOe0D|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:34.3995|wpOe0D|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:34.3995|wpOe0D|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:23:34.4005|wpOe0D|CJPOWERCAST|imfx v3 API took 0.057s '/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=1687163023991'
t Transfer: 1220 :     15|09:23:34.6015|kJV_Ud|CJPOWERCAST|OAuth: /api/user-preferences?keys=personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch;workflow_queues_actions;workflow_queues_settings&_dc=1687163024362
t Transfer: 1220 :     15|09:23:34.6015|kJV_Ud|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:34.6015|kJV_Ud|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:34.6015|kJV_Ud|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:23:34.6015|kJV_Ud|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  15|09:23:34.6025|kJV_Ud|CJPOWERCAST|GetUserDataByKeys: personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch;workflow_queues_actions;workflow_queues_settings
t Transfer: 1220 :     15|09:23:34.6025|kJV_Ud|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:34.6025|kJV_Ud|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:34.6025|kJV_Ud|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:23:34.8035|kJV_Ud|CJPOWERCAST|imfx v3 API took 0.053s '/api/user-preferences?keys=personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch;workflow_queues_actions;workflow_queues_settings&_dc=1687163024362'
t Information: 1220 :  15|09:23:35.0045|i_608s|CJPOWERCAST|GetUserProfile. Id: 0
t Transfer: 1220 :     15|09:23:35.0045|i_608s|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:35.0045|i_608s|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:35.0045|i_608s|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     15|09:23:35.4065|3VTWP~|CJPOWERCAST|OAuth: /api/settings/user/mainMenuSettings?_dc=1687163025132
t Transfer: 1220 :     15|09:23:35.4065|3VTWP~|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:35.4065|3VTWP~|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:35.4065|3VTWP~|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:23:35.4065|3VTWP~|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     15|09:23:35.4065|mFU60X|CJPOWERCAST|OAuth: /api/settings/group/0?_dc=1687163025131
t Transfer: 1220 :     15|09:23:35.4075|mFU60X|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:35.4075|mFU60X|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:35.4075|mFU60X|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:23:35.4075|mFU60X|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     15|09:23:35.4075|3VTWP~|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:35.4075|3VTWP~|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:35.4075|3VTWP~|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:23:35.6085|3VTWP~|CJPOWERCAST|imfx v3 API took 0.095s '/api/settings/user/mainMenuSettings?_dc=1687163025132'
t Verbose: 1220 :      15|09:23:35.8095|mFU60X|CJPOWERCAST|imfx v3 API took 0.330s '/api/settings/group/0?_dc=1687163025131'
t Transfer: 1220 :     15|09:23:35.8095|B764Gj|CJPOWERCAST|OAuth: /api/settings/user/uploadSettings?_dc=1687163025144
t Transfer: 1220 :     15|09:23:35.8095|B764Gj|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:35.8095|B764Gj|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:35.8095|B764Gj|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:23:35.8095|B764Gj|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     15|09:23:35.8095|B764Gj|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:35.8095|B764Gj|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:35.8105|B764Gj|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:23:35.8105|B764Gj|CJPOWERCAST|imfx v3 API took 0.007s '/api/settings/user/uploadSettings?_dc=1687163025144'
t Transfer: 1220 :     15|09:23:36.0115|xB1XPA|CJPOWERCAST|OAuth: /api/settings/group/0?_dc=1687163025174
t Transfer: 1220 :     15|09:23:36.0115|xB1XPA|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:36.0115|xB1XPA|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:36.0115|xB1XPA|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:23:36.0115|xB1XPA|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     15|09:23:36.0115|bk9bbr|CJPOWERCAST|OAuth: /api/settings/user/mainMenuSettings?_dc=1687163025175
t Transfer: 1220 :     15|09:23:36.0115|bk9bbr|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:36.0125|bk9bbr|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:36.0125|bk9bbr|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:23:36.0125|bk9bbr|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     15|09:23:36.0125|bk9bbr|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:36.0125|bk9bbr|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:36.0125|bk9bbr|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:23:36.0125|bk9bbr|CJPOWERCAST|imfx v3 API took 0.003s '/api/settings/user/mainMenuSettings?_dc=1687163025175'
t Transfer: 1220 :     15|09:23:36.0125|VGsmT3|CJPOWERCAST|OAuth: /api/lookups/MediaStatus?_dc=1687163025189
t Transfer: 1220 :     15|09:23:36.0125|VGsmT3|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:36.0135|VGsmT3|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:36.0135|VGsmT3|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:23:36.0135|VGsmT3|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Verbose: 1220 :      15|09:23:36.0135|URRPtl||imfx v3 API took 0.006s '/api/v3/visual-asset/group/Any_gO/0/image'
t Verbose: 1220 :      15|09:23:36.0135|xB1XPA|CJPOWERCAST|imfx v3 API took 0.081s '/api/settings/group/0?_dc=1687163025174'
t Verbose: 1220 :      15|09:23:36.2145|VGsmT3|CJPOWERCAST|imfx v3 API took 0.035s '/api/lookups/MediaStatus?_dc=1687163025189'
t Transfer: 1220 :     15|09:23:36.2145|keJzOM|CJPOWERCAST|OAuth: /api/lookups/PgmStatus?_dc=1687163025190
t Transfer: 1220 :     15|09:23:36.2145|keJzOM|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:36.2145|keJzOM|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:36.2145|keJzOM|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:23:36.2145|keJzOM|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Verbose: 1220 :      15|09:23:36.2145|keJzOM|CJPOWERCAST|imfx v3 API took 0.000s '/api/lookups/PgmStatus?_dc=1687163025190'
t Transfer: 1220 :     15|09:23:36.4155|XeKO4x|CJPOWERCAST|OAuth: /api/lookup/CustomMediaStatusTypes?_dc=1687163025191
t Transfer: 1220 :     15|09:23:36.4155|XeKO4x|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:36.4155|XeKO4x|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:36.4155|XeKO4x|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:23:36.4155|XeKO4x|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     15|09:23:36.4155|qY6Iuf|CJPOWERCAST|OAuth: /api/lookup/CustomVersionStatusTypes?_dc=1687163025193
t Transfer: 1220 :     15|09:23:36.4165|qY6Iuf|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:36.4165|qY6Iuf|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:36.4165|qY6Iuf|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:23:36.4165|qY6Iuf|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Verbose: 1220 :      15|09:23:36.4165|qY6Iuf|CJPOWERCAST|imfx v3 API took 0.015s '/api/lookup/CustomVersionStatusTypes?_dc=1687163025193'
t Verbose: 1220 :      15|09:23:36.4165|XeKO4x|CJPOWERCAST|imfx v3 API took 0.047s '/api/lookup/CustomMediaStatusTypes?_dc=1687163025191'
t Transfer: 1220 :     15|09:23:36.4165|qBecck|CJPOWERCAST|OAuth: /api/lookup/CustomTitleStatusTypes?_dc=1687163025194
t Transfer: 1220 :     15|09:23:36.4165|qBecck|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:36.4165|qBecck|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:36.4165|qBecck|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:23:36.4165|qBecck|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     15|09:23:36.4175|ePe3ap|CJPOWERCAST|OAuth: /api/settings/user/defaultHomePage?_dc=1687163025195
t Transfer: 1220 :     15|09:23:36.4175|ePe3ap|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:36.4175|ePe3ap|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:36.4175|ePe3ap|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:23:36.4175|ePe3ap|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     15|09:23:36.4175|ePe3ap|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:36.4175|ePe3ap|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:36.4175|ePe3ap|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:23:36.4175|ePe3ap|CJPOWERCAST|imfx v3 API took 0.008s '/api/settings/user/defaultHomePage?_dc=1687163025195'
t Verbose: 1220 :      15|09:23:36.4175|qBecck|CJPOWERCAST|imfx v3 API took 0.022s '/api/lookup/CustomTitleStatusTypes?_dc=1687163025194'
t Verbose: 1220 :      15|09:23:36.6195|IZJHnl||imfx v3 API took 0.004s '/api/v3/visual-asset/group/Any_gO/1/image'
t Transfer: 1220 :     15|09:23:37.0215|Y7Cwww|CJPOWERCAST|OAuth: /api/settings/user/startSearch?_dc=1687163026680
t Transfer: 1220 :     15|09:23:37.0215|sdMo4x|CJPOWERCAST|OAuth: /api/settings/user/defaultSearch?_dc=1687163026678
t Transfer: 1220 :     15|09:23:37.0215|Y7Cwww|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:37.0215|sdMo4x|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:37.0215|Y7Cwww|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:37.0215|sdMo4x|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:37.0215|sdMo4x|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     15|09:23:37.0215|Y7Cwww|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:23:37.0225|sdMo4x|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Verbose: 1220 :      15|09:23:37.0225|Y7Cwww|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     15|09:23:37.0225|sdMo4x|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:37.0225|sdMo4x|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:37.0225|sdMo4x|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     15|09:23:37.0225|Y7Cwww|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:37.0225|Y7Cwww|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:37.0225|Y7Cwww|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:23:37.0225|Y7Cwww|CJPOWERCAST|imfx v3 API took 0.009s '/api/settings/user/startSearch?_dc=1687163026680'
t Verbose: 1220 :      15|09:23:37.0235|sdMo4x|CJPOWERCAST|imfx v3 API took 0.009s '/api/settings/user/defaultSearch?_dc=1687163026678'
t Verbose: 1220 :      15|09:23:37.2245|yBXmZh||imfx v3 API took 0.004s '/api/v3/visual-asset/group/Any_gO/3/image'
t Transfer: 1220 :     15|09:23:37.4255|771ZLz|CJPOWERCAST|OAuth: /api/user-preferences?keys=consumer.recent.data&_dc=1687163027001
t Transfer: 1220 :     15|09:23:37.4255|771ZLz|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:37.4255|771ZLz|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:37.4255|771ZLz|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:23:37.4255|771ZLz|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  15|09:23:37.4255|771ZLz|CJPOWERCAST|GetUserDataByKeys: consumer.recent.data
t Transfer: 1220 :     15|09:23:37.4255|771ZLz|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:37.4255|771ZLz|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:37.4265|771ZLz|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     15|09:23:37.4265|iT3V5W|CJPOWERCAST|OAuth: /api/user-preferences?keys=adv.recent.searches.consumer&_dc=1687163027011
t Transfer: 1220 :     15|09:23:37.4265|iT3V5W|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:37.4265|iT3V5W|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:37.4265|iT3V5W|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:23:37.4265|iT3V5W|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Verbose: 1220 :      15|09:23:37.4265|771ZLz|CJPOWERCAST|imfx v3 API took 0.006s '/api/user-preferences?keys=consumer.recent.data&_dc=1687163027001'
t Information: 1220 :  15|09:23:37.4265|iT3V5W|CJPOWERCAST|GetUserDataByKeys: adv.recent.searches.consumer
t Transfer: 1220 :     15|09:23:37.4265|iT3V5W|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:37.4265|iT3V5W|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:37.4275|iT3V5W|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:23:37.4275|iT3V5W|CJPOWERCAST|imfx v3 API took 0.005s '/api/user-preferences?keys=adv.recent.searches.consumer&_dc=1687163027011'
t Transfer: 1220 :     15|09:23:48.0795|d_lLRH|CJPOWERCAST|OAuth: /api/lookups/SearchSupportedOperators?_dc=1687163037659
t Transfer: 1220 :     15|09:23:48.0795|d_lLRH|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:48.0795|d_lLRH|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:48.0795|d_lLRH|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:23:48.0795|d_lLRH|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     15|09:23:48.0795|J26h4V|CJPOWERCAST|OAuth: /api/view/searchinfo/TitleSearch?_dc=1687163037657
t Transfer: 1220 :     15|09:23:48.0795|J26h4V|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:48.0795|J26h4V|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:48.0805|J26h4V|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:23:48.0805|J26h4V|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     15|09:23:48.0805|YjUj6P|CJPOWERCAST|OAuth: /api/user-preferences?keys=adv.recent.searches.titles&_dc=1687163037661
t Transfer: 1220 :     15|09:23:48.0805|YjUj6P|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:48.0805|YjUj6P|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:48.0805|YjUj6P|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:23:48.0805|YjUj6P|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Verbose: 1220 :      15|09:23:48.0805|d_lLRH|CJPOWERCAST|imfx v3 API took 0.000s '/api/lookups/SearchSupportedOperators?_dc=1687163037659'
t Information: 1220 :  15|09:23:48.0805|YjUj6P|CJPOWERCAST|GetUserDataByKeys: adv.recent.searches.titles
t Transfer: 1220 :     15|09:23:48.0805|YjUj6P|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:48.0815|YjUj6P|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:48.0815|YjUj6P|CJPOWERCAST|    user CJPOWERCAST.
t Information: 1220 :  15|09:23:48.0815|J26h4V|CJPOWERCAST|GetAdvSearchColumns. search type TitleSearch grid .
t Verbose: 1220 :      15|09:23:48.0815|J26h4V|CJPOWERCAST|imfx v3 API took 0.002s '/api/view/searchinfo/TitleSearch?_dc=1687163037657'
t Verbose: 1220 :      15|09:23:48.0815|YjUj6P|CJPOWERCAST|imfx v3 API took 0.006s '/api/user-preferences?keys=adv.recent.searches.titles&_dc=1687163037661'
t Transfer: 1220 :     15|09:23:48.0815|JX0bAf|CJPOWERCAST|OAuth: /api/view/searches/TitleSearch?_dc=1687163037736
t Transfer: 1220 :     15|09:23:48.0815|JX0bAf|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:48.0815|JX0bAf|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:48.0825|JX0bAf|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:23:48.0825|JX0bAf|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  15|09:23:48.0825|JX0bAf|CJPOWERCAST|GetSavedSearchNames. search type TitleSearch.
t Transfer: 1220 :     15|09:23:48.0825|JX0bAf|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:48.0825|JX0bAf|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:48.0825|JX0bAf|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     15|09:23:48.0825|jJIN5b|CJPOWERCAST|OAuth: /api/view/info/VersionGrid?lang=en-GB&_dc=1687163037765
t Transfer: 1220 :     15|09:23:48.0825|jJIN5b|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:48.0825|jJIN5b|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:48.0825|jJIN5b|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:23:48.0835|jJIN5b|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  15|09:23:48.0835|jJIN5b|CJPOWERCAST|GetGridViewBuilder. builder type VersionGrid.
t Transfer: 1220 :     15|09:23:48.0835|jJIN5b|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:48.0835|jJIN5b|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:48.0835|jJIN5b|CJPOWERCAST|    user CJPOWERCAST.
t Information: 1220 :  15|09:23:48.0835|jJIN5b|CJPOWERCAST|UserGridView. LoadView. ID -2, Name Default.
t Transfer: 1220 :     15|09:23:48.0835|jJIN5b|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:48.0835|jJIN5b|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:48.0835|jJIN5b|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:23:48.0835|JX0bAf|CJPOWERCAST|imfx v3 API took 0.042s '/api/view/searches/TitleSearch?_dc=1687163037736'
t Transfer: 1220 :     15|09:23:48.0845|jJIN5b|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:48.0845|jJIN5b|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:48.0845|jJIN5b|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:23:48.0845|jJIN5b|CJPOWERCAST|imfx v3 API took 0.068s '/api/view/info/VersionGrid?lang=en-GB&_dc=1687163037765'
t Transfer: 1220 :     15|09:23:48.2855|u32gIM|CJPOWERCAST|OAuth: /api/view/info/MediaGrid?lang=en-GB&_dc=1687163037875
t Transfer: 1220 :     15|09:23:48.2855|u32gIM|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:48.2855|u32gIM|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:48.2855|u32gIM|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:23:48.2855|u32gIM|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  15|09:23:48.2855|u32gIM|CJPOWERCAST|GetGridViewBuilder. builder type MediaGrid.
t Transfer: 1220 :     15|09:23:48.2855|u32gIM|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:48.2855|u32gIM|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:48.2865|u32gIM|CJPOWERCAST|    user CJPOWERCAST.
t Information: 1220 :  15|09:23:48.2865|u32gIM|CJPOWERCAST|UserGridView. LoadView. ID -2, Name Default.
t Transfer: 1220 :     15|09:23:48.2865|u32gIM|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:48.2865|u32gIM|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:48.2865|u32gIM|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     15|09:23:48.2865|u32gIM|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:48.2865|u32gIM|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:48.2865|u32gIM|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:23:48.2865|u32gIM|CJPOWERCAST|imfx v3 API took 0.007s '/api/view/info/MediaGrid?lang=en-GB&_dc=1687163037875'
t Transfer: 1220 :     15|09:23:48.2865|BclGTW|CJPOWERCAST|OAuth: /api/view/info/DigitalCarriers?lang=en-GB&_dc=1687163037932
t Transfer: 1220 :     15|09:23:48.2874|BclGTW|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:48.2874|BclGTW|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:48.2874|BclGTW|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:23:48.2874|BclGTW|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  15|09:23:48.2874|BclGTW|CJPOWERCAST|GetGridViewBuilder. builder type DigitalCarriers.
t Transfer: 1220 :     15|09:23:48.2874|BclGTW|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:48.2874|BclGTW|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:48.2874|BclGTW|CJPOWERCAST|    user CJPOWERCAST.
t Information: 1220 :  15|09:23:48.2874|BclGTW|CJPOWERCAST|UserGridView. LoadView. ID -2, Name Default.
t Transfer: 1220 :     15|09:23:48.2874|BclGTW|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:48.2884|BclGTW|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:48.2884|BclGTW|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     15|09:23:48.2884|BclGTW|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:48.2884|BclGTW|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:48.2884|BclGTW|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:23:48.2884|BclGTW|CJPOWERCAST|imfx v3 API took 0.006s '/api/view/info/DigitalCarriers?lang=en-GB&_dc=1687163037932'
t Transfer: 1220 :     15|09:23:48.2884|bQ3Y0c|CJPOWERCAST|OAuth: /api/view/info/TitleTree?lang=en-GB&_dc=1687163037992
t Transfer: 1220 :     15|09:23:48.2884|bQ3Y0c|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:48.2884|bQ3Y0c|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:48.2884|bQ3Y0c|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:23:48.2894|bQ3Y0c|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  15|09:23:48.2894|bQ3Y0c|CJPOWERCAST|GetGridViewBuilder. builder type TitleTree.
t Transfer: 1220 :     15|09:23:48.2894|bQ3Y0c|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:48.2894|bQ3Y0c|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:48.2894|bQ3Y0c|CJPOWERCAST|    user CJPOWERCAST.
t Information: 1220 :  15|09:23:48.2894|bQ3Y0c|CJPOWERCAST|UserGridView. LoadView. ID -2, Name Default.
t Transfer: 1220 :     15|09:23:48.2894|bQ3Y0c|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:48.2894|bQ3Y0c|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:48.2894|bQ3Y0c|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     15|09:23:48.2894|bQ3Y0c|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:48.2904|bQ3Y0c|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:48.2904|bQ3Y0c|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:23:48.2904|bQ3Y0c|CJPOWERCAST|imfx v3 API took 0.006s '/api/view/info/TitleTree?lang=en-GB&_dc=1687163037992'
t Transfer: 1220 :     15|09:23:53.5165|W~NeB_|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1687163043157
t Transfer: 1220 :     15|09:23:53.5165|W~NeB_|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:53.5165|W~NeB_|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:53.5165|W~NeB_|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:23:53.5165|W~NeB_|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     15|09:23:53.5165|W~NeB_|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:53.5175|W~NeB_|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:53.5175|W~NeB_|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     15|09:23:53.5175|W1Q5c7|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1687163043290
t Transfer: 1220 :     15|09:23:53.5175|W1Q5c7|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:53.5175|W1Q5c7|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:53.5175|W1Q5c7|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:23:53.5175|W1Q5c7|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     15|09:23:53.5175|W1Q5c7|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:53.5185|W1Q5c7|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:53.5185|W1Q5c7|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     15|09:23:54.3225|zxyVo1|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1687163043929
t Transfer: 1220 :     15|09:23:54.3225|zxyVo1|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:54.3225|zxyVo1|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:54.3225|zxyVo1|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:23:54.3225|zxyVo1|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     15|09:23:54.3225|zxyVo1|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:54.3225|zxyVo1|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:54.3225|zxyVo1|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:23:54.3225|zxyVo1|CJPOWERCAST|imfx v3 API took 0.156s '/api/v3/search-suggestion/?_dc=1687163043929'
t Verbose: 1220 :      15|09:23:54.3234|W~NeB_|CJPOWERCAST|imfx v3 API took 0.852s '/api/v3/search-suggestion/?_dc=1687163043157'
t Verbose: 1220 :      15|09:23:54.3234|W1Q5c7|CJPOWERCAST|imfx v3 API took 0.797s '/api/v3/search-suggestion/?_dc=1687163043290'
t Transfer: 1220 :     15|09:23:54.7255|SsR7YV|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1687163044304
t Transfer: 1220 :     15|09:23:54.7255|SsR7YV|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:54.7255|SsR7YV|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:54.7255|SsR7YV|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:23:54.7255|SsR7YV|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     15|09:23:54.7255|SsR7YV|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:54.7255|SsR7YV|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:54.7255|SsR7YV|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:23:54.7265|SsR7YV|CJPOWERCAST|imfx v3 API took 0.014s '/api/v3/search-suggestion/?_dc=1687163044304'
t Transfer: 1220 :     15|09:23:56.9374|e23V0k|CJPOWERCAST|OAuth: /api/v3/search/title?_dc=1687163046698
t Transfer: 1220 :     15|09:23:56.9374|e23V0k|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:56.9374|e23V0k|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:56.9374|e23V0k|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:23:56.9374|e23V0k|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  15|09:23:57.1385|e23V0k|CJPOWERCAST|V3Api.SearchTitles
t Information: 1220 :  15|09:23:57.1385|e23V0k|CJPOWERCAST|V3Api.SearchGeneric
t Transfer: 1220 :     15|09:23:57.1385|e23V0k|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:57.1385|e23V0k|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:57.1385|e23V0k|CJPOWERCAST|    user CJPOWERCAST.
t Information: 1220 :  15|09:23:57.1385|e23V0k|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 :      15|09:23:57.3405|e23V0k|CJPOWERCAST|imfx v3 API took 0.224s '/api/v3/search/title?_dc=1687163046698'
t Transfer: 1220 :     15|09:23:57.7424|cBIgr6|CJPOWERCAST|OAuth: /api/v3/title/299390/versions?_dc=1687163047395
t Transfer: 1220 :     15|09:23:57.7424|cBIgr6|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:57.7424|cBIgr6|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:57.7424|cBIgr6|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:23:57.7424|cBIgr6|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  15|09:23:57.7424|cBIgr6|CJPOWERCAST|V3Api.SearchGeneric
t Transfer: 1220 :     15|09:23:57.7424|FGsUBG|CJPOWERCAST|OAuth: /api/user-preferences?_dc=1687163047398
t Transfer: 1220 :     15|09:23:57.7424|FGsUBG|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:57.7434|FGsUBG|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:57.7434|FGsUBG|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:23:57.7434|FGsUBG|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Verbose: 1220 :      15|09:23:57.7434|FGsUBG|CJPOWERCAST|StoreUserDataByKeys..
t Transfer: 1220 :     15|09:23:57.7434|FGsUBG|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:57.7434|FGsUBG|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:57.7434|FGsUBG|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     15|09:23:57.7434|cBIgr6|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:57.7434|cBIgr6|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:57.7434|cBIgr6|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     15|09:23:57.7434|cBIgr6|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:57.7444|cBIgr6|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:57.7444|cBIgr6|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     15|09:23:57.7444|cBIgr6|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:57.7444|cBIgr6|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:57.7444|cBIgr6|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:23:57.7444|FGsUBG|CJPOWERCAST|imfx v3 API took 0.020s '/api/user-preferences?_dc=1687163047398'
t Information: 1220 :  15|09:23:57.7444|cBIgr6|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 :     15|09:23:57.7444|cBIgr6|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:57.7444|cBIgr6|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:57.7444|cBIgr6|CJPOWERCAST|    user CJPOWERCAST.
t Information: 1220 :  15|09:23:57.7454|cBIgr6|CJPOWERCAST|Running version search. User: 1165    Simple Search: 
Running Oracle search.
Running Oracle search for COUNT
Oracle count completed in: 28ms.  Returned lines: 0

t Verbose: 1220 :      15|09:23:57.7454|cBIgr6|CJPOWERCAST|imfx v3 API took 0.064s '/api/v3/title/299390/versions?_dc=1687163047395'
t Transfer: 1220 :     15|09:23:58.7504|w50dHX|CJPOWERCAST|OAuth: /api/v3/title/299542/versions?_dc=1687163048430
t Transfer: 1220 :     15|09:23:58.7504|w50dHX|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:58.7504|w50dHX|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:58.7504|w50dHX|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:23:58.7504|w50dHX|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  15|09:23:58.7504|w50dHX|CJPOWERCAST|V3Api.SearchGeneric
t Transfer: 1220 :     15|09:23:58.7504|w50dHX|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:58.7504|w50dHX|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:58.7515|w50dHX|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     15|09:23:58.7515|w50dHX|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:58.7515|w50dHX|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:58.7515|w50dHX|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     15|09:23:58.7515|w50dHX|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:58.7515|w50dHX|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:58.7515|w50dHX|CJPOWERCAST|    user CJPOWERCAST.
t Information: 1220 :  15|09:23:58.7515|w50dHX|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 :     15|09:23:58.7515|w50dHX|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:58.7515|w50dHX|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:58.7525|w50dHX|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     15|09:23:59.3555|Z6c159|CJPOWERCAST|OAuth: /api/v3/title/299544/versions?_dc=1687163049049
t Transfer: 1220 :     15|09:23:59.3555|Z6c159|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:59.3555|Z6c159|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:59.3555|Z6c159|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:23:59.3555|Z6c159|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  15|09:23:59.3555|Z6c159|CJPOWERCAST|V3Api.SearchGeneric
t Transfer: 1220 :     15|09:23:59.3555|Z6c159|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:59.3555|Z6c159|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:59.3564|Z6c159|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     15|09:23:59.3564|Z6c159|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:59.3564|Z6c159|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:59.3564|Z6c159|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     15|09:23:59.3564|Z6c159|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:59.3564|Z6c159|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:59.3564|Z6c159|CJPOWERCAST|    user CJPOWERCAST.
t Information: 1220 :  15|09:23:59.3564|Z6c159|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 :     15|09:23:59.3564|Z6c159|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:23:59.3564|Z6c159|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:23:59.3574|Z6c159|CJPOWERCAST|    user CJPOWERCAST.
t Information: 1220 :  15|09:23:59.5584|w50dHX|CJPOWERCAST|Running version search. User: 1165    Simple Search: 
Running Oracle search.
Running Oracle search for COUNT
Oracle count completed in: 5ms.  Returned lines: 3
Oracle version search timing: 879ms.
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 :      15|09:23:59.5584|w50dHX|CJPOWERCAST|imfx v3 API took 0.893s '/api/v3/title/299542/versions?_dc=1687163048430'
t Information: 1220 :  15|09:23:59.9604|Z6c159|CJPOWERCAST|Running version search. User: 1165    Simple Search: 
Running Oracle search.
Running Oracle search for COUNT
Oracle count completed in: 6ms.  Returned lines: 1
Oracle version search timing: 604ms.
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 :      15|09:23:59.9604|Z6c159|CJPOWERCAST|imfx v3 API took 0.619s '/api/v3/title/299544/versions?_dc=1687163049049'
t Transfer: 1220 :     15|09:24:00.1614|BPSs~9|CJPOWERCAST|OAuth: /api/v3/version/299543/media?_dc=1687163049805
t Transfer: 1220 :     15|09:24:00.1614|BPSs~9|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:24:00.1614|BPSs~9|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:24:00.1614|BPSs~9|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:24:00.1614|BPSs~9|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  15|09:24:00.1614|BPSs~9|CJPOWERCAST|V3Api.SearchGeneric
t Transfer: 1220 :     15|09:24:00.1614|W01gUR|CJPOWERCAST|OAuth: /api/v3/version/299543/media?_dc=1687163049826
t Transfer: 1220 :     15|09:24:00.1614|W01gUR|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:24:00.1625|W01gUR|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:24:00.1625|W01gUR|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:24:00.1625|W01gUR|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  15|09:24:00.1625|W01gUR|CJPOWERCAST|V3Api.SearchGeneric
t Transfer: 1220 :     15|09:24:00.1625|BPSs~9|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:24:00.1625|W01gUR|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:24:00.1625|W01gUR|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:24:00.1625|BPSs~9|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:24:00.1625|BPSs~9|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     15|09:24:00.1625|W01gUR|CJPOWERCAST|    user CJPOWERCAST.
t Information: 1220 :  15|09:24:00.1635|BPSs~9|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 :  15|09:24:00.1635|W01gUR|CJPOWERCAST|MediaSearch SQL:
--sqlFromPaging
select r.*,
    nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type in (1,110)),'') BARCODE,
    nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat,
    nvl(t.text_data_path,'') THUMBSERVER, 
    nvl(t.text_data_filename,'') THUMBFILE,
    nvl(t.text_id,-1) THUMBID , 
    (SELECT min(status.ACCESS_STATUS_NAME) FROM TMDDBA.TM_ACCESS_STATUS statusLnx, TM_CFG_ACCESS_STATUS status 
        WHERE statusLnx.Media_Id = r.id and statusLnx.Status_Id = status.id) ACCESS_STATUS , (select min(acq.ext_ref) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) CONSIGNMENT_NUMBER , 
    (select min(acq.alt_id1) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) TRANSFER_NUMBER , 
    (select min(crs.series_number) from tm_series_data crs where crs.id = r.GROUP_SERIES_ID) CRS_SERIES , 
    (select min(DISPOSAL_NAME) from TM_ACQ_DISPOSAL status, tm_disposal_records records
            where status.id = records.disposal_status_id and records.miid = r.id) DISPOSAL_STATUS , 
    (select min(class.class_number) from TM_ACQ_DISPOSAL status, tm_disposal_records records, tm_disposal_classes class
        where status.id = records.disposal_status_id and records.miid = r.id and class.id = records.disposal_class_id) DISPOSAL_CLASS, 
    (select min(names.concat_search_name) from tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names
        where r.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY, 
    (select min(c.u_id_ext1) from tmddba.tm_mi_tpi_lnx lnx, tm_ctnrs c where c.u_id = lnx.tpiid and lnx.miid = r.id) U_ID_EXT1 , 
    (select t.name from TM_CFG_MI_FMT_TYP t where t.id = r.mi_fmt_type) ITEM_FORMAT_TEXT, 
    CASE
        WHEN BITAND(r.COMPIL, 2) = 2 THEN 'SUPPLIED'
        WHEN BITAND(r.COMPIL, 4) = 4 THEN 'MADE'
        WHEN BITAND(r.COMPIL, 134217728) = 134217728 THEN 'IMPORTED'
        ELSE ''
    END AS ORIGIN, 
    CASE
        WHEN BITAND(r.COMPIL, 512) = 512 THEN 'Attached'
        WHEN BITAND(r.COMPIL, 1024) = 1024 THEN 'Un-Attached'
        ELSE ''
    END AS FLAGS, 
    (select min(lang.full_name) from TM_PG_RL_LANG_LNX lnx, TM_LANG_DATA lang 
        where lnx.tm_pg_rl_id = r.pgm_parent_id and lnx.lang_id = lang.id) AS PROD_LANGUAGE , 
    (select min(ctx.ITFC_CODE) from tm_mis mis, tm_mi_tpi_lnx links, tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names
        where mis.id = r.id and links.miid = mis.id and mis.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id
          and ctx.preferred_name = names.id) AGENCY_NUMBER, 
    (select min(status.description) from TM_CFG_PGM_STATUS status where r.status = status.id) PGM_STATUS_TEXT, 
    (select min(ver.DUR) from TM_PG_RL ver where r.pgm_PARENT_ID = ver.id) AS VERSION_DUR , (select tmd_str_agg_pipe(cms.status_type_id ||',' ||cms.status_id) from tm_mi_cust_med_stat_lnx cms where cms.media_id=r.id) "CustomStatusesRaw", (select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = r.net_grp_id) CHANNEL_GROUP, 
    (SELECT SUBSTR( trim( replace (replace (
          LISTAGG(trim(tt.tags || ' ' || tt.notes), ' ') WITHIN GROUP (ORDER BY trim(tt.tags || ' ' || tt.notes)), chr (13), ''), chr (10), ' ')), 1, 150) z
            FROM tm_media_tagging tt
              WHERE link_guid = DFILE_LINK_GUID and rownum=1) TAGS_TEXT , 
    GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION,
    nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME 

    from (select t.*,
     coalesce(t.primary_thumb_id, 
             (select v.primary_thumb_id from tm_pg_rl v where v.id=t.pgm_parent_id), 
             (select a.primary_thumb_id from tm_pg_abs a where a.id=t.pgm_abs_id), 
             (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs_id), 
             (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs2_id)
) primary_thumb_id2
    from (
                 --sqlSubSelect   
                 select s.*  from
                (select a.*, rownum rnum from
                    (select  --sqlFrom
m.*
      from tmddba.tm_mis m 

--sqlWhere
where  media_type>0 and item_type>0  AND  PGM_PARENT_ID=:param_0  and m.mi_deleted=0   AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0)
 order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) s 
     where rnum >= 1) t ) r
    
    ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat  from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk 
    ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t
    ,lateral(select /*+ NO_DECORRELATE */  d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename
        FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl 
    
     order by r.rnum

t Transfer: 1220 :     15|09:24:00.3645|AzgBBS|CJPOWERCAST|OAuth: /api/v3/version/299545/media?_dc=1687163049997
t Transfer: 1220 :     15|09:24:00.3645|AzgBBS|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:24:00.3645|AzgBBS|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:24:00.3645|AzgBBS|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:24:00.3645|AzgBBS|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  15|09:24:00.3645|AzgBBS|CJPOWERCAST|V3Api.SearchGeneric
t Transfer: 1220 :     15|09:24:00.3645|AzgBBS|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:24:00.3645|AzgBBS|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:24:00.3655|AzgBBS|CJPOWERCAST|    user CJPOWERCAST.
t Information: 1220 :  15|09:24:00.3655|AzgBBS|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 :      15|09:24:00.9685|AzgBBS|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 :      15|09:24:00.9685|BPSs~9|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 :      15|09:24:00.9685|W01gUR|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 :  15|09:24:01.1695|AzgBBS|CJPOWERCAST|    timing: 00:00:00.7480829
t Information: 1220 :  15|09:24:01.1695|BPSs~9|CJPOWERCAST|    timing: 00:00:00.9357955
t Verbose: 1220 :      15|09:24:01.1695|AzgBBS|CJPOWERCAST|imfx v3 API took 0.748s '/api/v3/version/299545/media?_dc=1687163049997'
t Verbose: 1220 :      15|09:24:01.1705|BPSs~9|CJPOWERCAST|imfx v3 API took 0.948s '/api/v3/version/299543/media?_dc=1687163049805'
t Information: 1220 :  15|09:24:01.1705|W01gUR|CJPOWERCAST|    timing: 00:00:00.9381464
t Verbose: 1220 :      15|09:24:01.1715|W01gUR|CJPOWERCAST|imfx v3 API took 0.938s '/api/v3/version/299543/media?_dc=1687163049826'
t Transfer: 1220 :     15|09:24:01.1715|V0mXxu|CJPOWERCAST|OAuth: /api/v3/version/299545/media?_dc=1687163050014
t Transfer: 1220 :     15|09:24:01.1715|V0mXxu|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:24:01.1725|V0mXxu|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:24:01.1735|V0mXxu|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:24:01.1745|V0mXxu|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  15|09:24:01.1745|V0mXxu|CJPOWERCAST|V3Api.SearchGeneric
t Transfer: 1220 :     15|09:24:01.1745|V0mXxu|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:24:01.1745|V0mXxu|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:24:01.1895|V0mXxu|CJPOWERCAST|    user CJPOWERCAST.
t Information: 1220 :  15|09:24:01.1895|V0mXxu|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 :      15|09:24:01.3904|V0mXxu|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 :  15|09:24:01.3904|V0mXxu|CJPOWERCAST|    timing: 00:00:00.0441592
t Verbose: 1220 :      15|09:24:01.3904|V0mXxu|CJPOWERCAST|imfx v3 API took 0.044s '/api/v3/version/299545/media?_dc=1687163050014'
t Transfer: 1220 :     15|09:24:01.3904|AzgBBS|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0178.mp4 subfolder 
t Transfer: 1220 :     15|09:24:01.3904|W01gUR|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0156.mp4 subfolder 
t Transfer: 1220 :     15|09:24:01.3904|V0mXxu|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0178.mp4 subfolder 
t Transfer: 1220 :     15|09:24:01.3904|BPSs~9|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0156.mp4 subfolder 
t Transfer: 1220 :     15|09:24:01.3904|AzgBBS|CJPOWERCAST|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0178.mp4
t Transfer: 1220 :     15|09:24:01.3914|AzgBBS|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0178.mp4
t Transfer: 1220 :     15|09:24:01.3914|AzgBBS|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:24:01.3914|AzgBBS|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:24:01.3914|AzgBBS|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     15|09:24:01.3914|V0mXxu|CJPOWERCAST|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0178.mp4
t Transfer: 1220 :     15|09:24:01.3914|W01gUR|CJPOWERCAST|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156.mp4
t Transfer: 1220 :     15|09:24:01.3914|V0mXxu|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0178.mp4
t Transfer: 1220 :     15|09:24:01.3914|BPSs~9|CJPOWERCAST|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156.mp4
t Transfer: 1220 :     15|09:24:01.3914|W01gUR|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156.mp4
t Transfer: 1220 :     15|09:24:01.3914|BPSs~9|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156.mp4
t Transfer: 1220 :     15|09:24:01.3914|BPSs~9|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:24:01.3924|BPSs~9|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:24:01.3924|W01gUR|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:24:01.3924|V0mXxu|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:24:01.3924|BPSs~9|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     15|09:24:01.3924|V0mXxu|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:24:01.3924|W01gUR|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:24:01.3924|V0mXxu|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     15|09:24:01.3924|W01gUR|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     15|09:24:01.3924|W01gUR|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0156M0002021.mp4 subfolder 
t Transfer: 1220 :     15|09:24:01.3924|W01gUR|CJPOWERCAST|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156M0002021.mp4
t Transfer: 1220 :     15|09:24:01.3924|W01gUR|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156M0002021.mp4
t Transfer: 1220 :     15|09:24:01.3934|W01gUR|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:24:01.3934|W01gUR|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:24:01.3934|W01gUR|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     15|09:24:01.3934|V0mXxu|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001992.mp4 subfolder 
t Transfer: 1220 :     15|09:24:01.3934|V0mXxu|CJPOWERCAST|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001992.mp4
t Transfer: 1220 :     15|09:24:01.3934|V0mXxu|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001992.mp4
t Transfer: 1220 :     15|09:24:01.3934|V0mXxu|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:24:01.3934|V0mXxu|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:24:01.3934|V0mXxu|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     15|09:24:01.3944|BPSs~9|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0156M0002021.mp4 subfolder 
t Transfer: 1220 :     15|09:24:01.3944|BPSs~9|CJPOWERCAST|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156M0002021.mp4
t Transfer: 1220 :     15|09:24:01.3944|BPSs~9|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156M0002021.mp4
t Transfer: 1220 :     15|09:24:01.3944|BPSs~9|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:24:01.3944|BPSs~9|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:24:01.3944|BPSs~9|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     15|09:24:01.3944|AzgBBS|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001992.mp4 subfolder 
t Transfer: 1220 :     15|09:24:01.3944|AzgBBS|CJPOWERCAST|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001992.mp4
t Transfer: 1220 :     15|09:24:01.3944|AzgBBS|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001992.mp4
t Transfer: 1220 :     15|09:24:01.3944|AzgBBS|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:24:01.3954|AzgBBS|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:24:01.3954|AzgBBS|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     15|09:24:01.3954|V0mXxu|CJPOWERCAST|GetUrl. Storage |Temp Storage| filename C:\TEMP\N0001992.mp4 subfolder 
t Transfer: 1220 :     15|09:24:01.3954|V0mXxu|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:24:01.3954|V0mXxu|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:24:01.3954|V0mXxu|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     15|09:24:01.3954|AzgBBS|CJPOWERCAST|GetUrl. Storage |Temp Storage| filename C:\TEMP\N0001992.mp4 subfolder 
t Transfer: 1220 :     15|09:24:01.3954|AzgBBS|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:24:01.3954|AzgBBS|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:24:01.3954|AzgBBS|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     15|09:24:01.3954|W01gUR|CJPOWERCAST|GetUrl. Storage |Audio| filename \\192.168.120.254\DemoFS\Digital Assets\Audio\gotspecialspromosaudio.wav subfolder 
t Transfer: 1220 :     15|09:24:01.3964|W01gUR|CJPOWERCAST|  GetFileName result https://imfxv3tm.tmd.tv/AudioServer/gotspecialspromosaudio.wav
t Transfer: 1220 :     15|09:24:01.3964|W01gUR|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/AudioServer/gotspecialspromosaudio.wav
t Transfer: 1220 :     15|09:24:01.3964|W01gUR|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:24:01.3964|W01gUR|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:24:01.3964|W01gUR|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     15|09:24:01.3964|BPSs~9|CJPOWERCAST|GetUrl. Storage |Audio| filename \\192.168.120.254\DemoFS\Digital Assets\Audio\gotspecialspromosaudio.wav subfolder 
t Transfer: 1220 :     15|09:24:01.3964|BPSs~9|CJPOWERCAST|  GetFileName result https://imfxv3tm.tmd.tv/AudioServer/gotspecialspromosaudio.wav
t Transfer: 1220 :     15|09:24:01.3964|BPSs~9|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/AudioServer/gotspecialspromosaudio.wav
t Transfer: 1220 :     15|09:24:01.3964|BPSs~9|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:24:01.3964|BPSs~9|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:24:01.3964|BPSs~9|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     15|09:24:01.3974|V0mXxu|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0178.xml subfolder 
t Transfer: 1220 :     15|09:24:01.3974|V0mXxu|CJPOWERCAST|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0178.xml
t Transfer: 1220 :     15|09:24:01.3974|V0mXxu|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0178.xml
t Transfer: 1220 :     15|09:24:01.3974|V0mXxu|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:24:01.3974|V0mXxu|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:24:01.3974|V0mXxu|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     15|09:24:01.3974|W01gUR|CJPOWERCAST|GetUrl. Storage |Audio| filename \\192.168.120.254\DemoFS\Digital Assets\Audio\PMH_portugese - Copy.wav subfolder 
t Transfer: 1220 :     15|09:24:01.3974|W01gUR|CJPOWERCAST|  GetFileName result https://imfxv3tm.tmd.tv/AudioServer/PMH_portugese%20-%20Copy.wav
t Transfer: 1220 :     15|09:24:01.3974|W01gUR|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/AudioServer/PMH_portugese%20-%20Copy.wav
t Transfer: 1220 :     15|09:24:01.3974|W01gUR|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:24:01.3984|W01gUR|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:24:01.3984|W01gUR|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     15|09:24:01.3984|BPSs~9|CJPOWERCAST|GetUrl. Storage |Audio| filename \\192.168.120.254\DemoFS\Digital Assets\Audio\PMH_portugese - Copy.wav subfolder 
t Transfer: 1220 :     15|09:24:01.3984|BPSs~9|CJPOWERCAST|  GetFileName result https://imfxv3tm.tmd.tv/AudioServer/PMH_portugese%20-%20Copy.wav
t Transfer: 1220 :     15|09:24:01.3984|BPSs~9|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/AudioServer/PMH_portugese%20-%20Copy.wav
t Transfer: 1220 :     15|09:24:01.3984|BPSs~9|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:24:01.3984|BPSs~9|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:24:01.3984|BPSs~9|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     15|09:24:01.3984|AzgBBS|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0178.xml subfolder 
t Transfer: 1220 :     15|09:24:01.3984|AzgBBS|CJPOWERCAST|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0178.xml
t Transfer: 1220 :     15|09:24:01.3984|AzgBBS|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0178.xml
t Transfer: 1220 :     15|09:24:01.3994|AzgBBS|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:24:01.3994|AzgBBS|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:24:01.3994|AzgBBS|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     15|09:24:01.8015|fNGjyA|CJPOWERCAST|OAuth: /api/v3/media/299534/carriers/digital?_dc=1687163051412
t Transfer: 1220 :     15|09:24:01.8015|fNGjyA|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:24:01.8015|fNGjyA|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:24:01.8015|fNGjyA|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:24:01.8015|fNGjyA|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  15|09:24:01.8015|fNGjyA|CJPOWERCAST|V3Api.SearchGeneric
t Transfer: 1220 :     15|09:24:01.8015|fNGjyA|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:24:01.8025|fNGjyA|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:24:01.8025|fNGjyA|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     15|09:24:01.8025|fNGjyA|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:24:01.8025|fNGjyA|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:24:01.8025|fNGjyA|CJPOWERCAST|    user CJPOWERCAST.
t Information: 1220 :  15|09:24:01.8025|fNGjyA|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 :     15|09:24:02.0034|EGc_oz|CJPOWERCAST|OAuth: /api/v3/media/299534/carriers/digital?_dc=1687163051666
t Transfer: 1220 :     15|09:24:02.0034|EGc_oz|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:24:02.0034|EGc_oz|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:24:02.0034|EGc_oz|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:24:02.0034|EGc_oz|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  15|09:24:02.0034|EGc_oz|CJPOWERCAST|V3Api.SearchGeneric
t Transfer: 1220 :     15|09:24:02.0034|EGc_oz|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:24:02.0034|EGc_oz|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:24:02.0034|EGc_oz|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     15|09:24:02.0045|EGc_oz|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:24:02.0045|EGc_oz|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:24:02.0045|EGc_oz|CJPOWERCAST|    user CJPOWERCAST.
t Information: 1220 :  15|09:24:02.0045|EGc_oz|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 :      15|09:24:02.0045|EGc_oz|CJPOWERCAST|imfx v3 API took 0.087s '/api/v3/media/299534/carriers/digital?_dc=1687163051666'
t Verbose: 1220 :      15|09:24:02.0045|fNGjyA|CJPOWERCAST|imfx v3 API took 0.335s '/api/v3/media/299534/carriers/digital?_dc=1687163051412'
t Transfer: 1220 :     15|09:24:02.2054|Sir4s7|CJPOWERCAST|OAuth: /api/view/info/TapeGrid?lang=en-GB&_dc=1687163051891
t Transfer: 1220 :     15|09:24:02.2054|Sir4s7|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:24:02.2054|Sir4s7|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:24:02.2054|Sir4s7|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:24:02.2054|Sir4s7|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  15|09:24:02.2054|Sir4s7|CJPOWERCAST|GetGridViewBuilder. builder type TapeGrid.
t Transfer: 1220 :     15|09:24:02.2054|Sir4s7|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:24:02.2054|Sir4s7|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:24:02.2065|Sir4s7|CJPOWERCAST|    user CJPOWERCAST.
t Information: 1220 :  15|09:24:02.2065|Sir4s7|CJPOWERCAST|UserGridView. LoadView. ID -2, Name Default.
t Transfer: 1220 :     15|09:24:02.2065|Sir4s7|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:24:02.2065|Sir4s7|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:24:02.2065|Sir4s7|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     15|09:24:02.2065|Sir4s7|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:24:02.2065|Sir4s7|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:24:02.2065|Sir4s7|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:24:02.2065|Sir4s7|CJPOWERCAST|imfx v3 API took 0.011s '/api/view/info/TapeGrid?lang=en-GB&_dc=1687163051891'
t Transfer: 1220 :     15|09:24:02.4074|T~D~O~|CJPOWERCAST|OAuth: /api/v3/media/299739/carriers/physical?_dc=1687163052159
t Transfer: 1220 :     15|09:24:02.4074|T~D~O~|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:24:02.4074|T~D~O~|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:24:02.4074|T~D~O~|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:24:02.4074|T~D~O~|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  15|09:24:02.4074|T~D~O~|CJPOWERCAST|V3Api.SearchGeneric
t Transfer: 1220 :     15|09:24:02.4074|T~D~O~|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:24:02.4074|T~D~O~|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:24:02.4074|T~D~O~|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     15|09:24:02.4085|T~D~O~|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:24:02.4085|T~D~O~|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:24:02.4085|T~D~O~|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:24:02.6095|T~D~O~|CJPOWERCAST|imfx v3 API took 0.061s '/api/v3/media/299739/carriers/physical?_dc=1687163052159'
t Transfer: 1220 :     15|09:24:03.0115|N~47Yt|CJPOWERCAST|OAuth: /api/v3/media/299739/carriers/physical?_dc=1687163052612
t Transfer: 1220 :     15|09:24:03.0115|N~47Yt|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:24:03.0115|N~47Yt|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:24:03.0115|N~47Yt|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:24:03.0115|N~47Yt|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  15|09:24:03.0115|N~47Yt|CJPOWERCAST|V3Api.SearchGeneric
t Transfer: 1220 :     15|09:24:03.0115|N~47Yt|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:24:03.0115|N~47Yt|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:24:03.0124|N~47Yt|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     15|09:24:03.0124|N~47Yt|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:24:03.0124|N~47Yt|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:24:03.0124|N~47Yt|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:24:03.0124|N~47Yt|CJPOWERCAST|imfx v3 API took 0.009s '/api/v3/media/299739/carriers/physical?_dc=1687163052612'
t Transfer: 1220 :     15|09:25:05.9234|LhncCt|CJPOWERCAST|OAuth: /api/v3/media/299536/carriers/digital?_dc=1687163115622
t Transfer: 1220 :     15|09:25:05.9234|LhncCt|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:25:05.9234|LhncCt|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:25:05.9234|LhncCt|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:25:05.9234|LhncCt|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  15|09:25:05.9234|LhncCt|CJPOWERCAST|V3Api.SearchGeneric
t Transfer: 1220 :     15|09:25:05.9234|LhncCt|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:25:05.9244|LhncCt|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:25:05.9244|LhncCt|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     15|09:25:05.9244|LhncCt|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:25:05.9244|LhncCt|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:25:05.9244|LhncCt|CJPOWERCAST|    user CJPOWERCAST.
t Information: 1220 :  15|09:25:05.9244|LhncCt|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 :      15|09:25:05.9244|LhncCt|CJPOWERCAST|imfx v3 API took 0.017s '/api/v3/media/299536/carriers/digital?_dc=1687163115622'
t Transfer: 1220 :     15|09:26:45.8188|IR1Xxw|CJPOWERCAST|OAuth: /api/v3/media/291723/carriers/digital?_dc=1687163215463
t Transfer: 1220 :     15|09:26:45.8188|IR1Xxw|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:26:45.8188|IR1Xxw|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:26:45.8188|IR1Xxw|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:26:45.8198|IR1Xxw|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  15|09:26:45.8198|IR1Xxw|CJPOWERCAST|V3Api.SearchGeneric
t Transfer: 1220 :     15|09:26:45.8198|IR1Xxw|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:26:45.8198|IR1Xxw|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:26:45.8198|IR1Xxw|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     15|09:26:45.8198|IR1Xxw|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:26:45.8208|IR1Xxw|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:26:45.8208|IR1Xxw|CJPOWERCAST|    user CJPOWERCAST.
t Information: 1220 :  15|09:26:45.8208|IR1Xxw|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 :      15|09:26:45.8208|IR1Xxw|CJPOWERCAST|imfx v3 API took 0.018s '/api/v3/media/291723/carriers/digital?_dc=1687163215463'
t Transfer: 1220 :     15|09:26:47.6307|qvDn4F|CJPOWERCAST|OAuth: /api/v3/media/299536/carriers/digital?_dc=1687163217216
t Transfer: 1220 :     15|09:26:47.6307|qvDn4F|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:26:47.6307|qvDn4F|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:26:47.6307|qvDn4F|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:26:47.6307|qvDn4F|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  15|09:26:47.6307|qvDn4F|CJPOWERCAST|V3Api.SearchGeneric
t Transfer: 1220 :     15|09:26:47.6307|qvDn4F|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:26:47.6307|qvDn4F|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:26:47.6317|qvDn4F|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     15|09:26:47.6317|qvDn4F|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:26:47.6317|qvDn4F|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:26:47.6317|qvDn4F|CJPOWERCAST|    user CJPOWERCAST.
t Information: 1220 :  15|09:26:47.6317|qvDn4F|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 :      15|09:26:47.6317|qvDn4F|CJPOWERCAST|imfx v3 API took 0.012s '/api/v3/media/299536/carriers/digital?_dc=1687163217216'
t Transfer: 1220 :     15|09:26:48.4357|23jzgW|CJPOWERCAST|OAuth: /api/v3/media/299549/carriers/digital?_dc=1687163218080
t Transfer: 1220 :     15|09:26:48.4357|23jzgW|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:26:48.4357|23jzgW|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:26:48.4357|23jzgW|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:26:48.4357|23jzgW|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  15|09:26:48.4357|23jzgW|CJPOWERCAST|V3Api.SearchGeneric
t Transfer: 1220 :     15|09:26:48.4357|23jzgW|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:26:48.4357|23jzgW|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:26:48.4357|23jzgW|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     15|09:26:48.4367|23jzgW|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:26:48.4367|23jzgW|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:26:48.4367|23jzgW|CJPOWERCAST|    user CJPOWERCAST.
t Information: 1220 :  15|09:26:48.4367|23jzgW|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 :      15|09:26:48.4367|23jzgW|CJPOWERCAST|imfx v3 API took 0.013s '/api/v3/media/299549/carriers/digital?_dc=1687163218080'
t Transfer: 1220 :     15|09:26:49.0397|GfzHMz|CJPOWERCAST|OAuth: /api/v3/media/299890/carriers/digital?_dc=1687163218653
t Transfer: 1220 :     15|09:26:49.0397|GfzHMz|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:26:49.0397|GfzHMz|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:26:49.0397|GfzHMz|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:26:49.0397|GfzHMz|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  15|09:26:49.0397|GfzHMz|CJPOWERCAST|V3Api.SearchGeneric
t Transfer: 1220 :     15|09:26:49.0397|GfzHMz|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:26:49.0397|GfzHMz|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:26:49.0407|GfzHMz|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     15|09:26:49.0407|GfzHMz|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:26:49.0407|GfzHMz|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:26:49.0407|GfzHMz|CJPOWERCAST|    user CJPOWERCAST.
t Information: 1220 :  15|09:26:49.0407|GfzHMz|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 :      15|09:26:49.0407|GfzHMz|CJPOWERCAST|imfx v3 API took 0.012s '/api/v3/media/299890/carriers/digital?_dc=1687163218653'
t Transfer: 1220 :     15|09:26:49.4427|67ijF7|CJPOWERCAST|OAuth: /api/v3/media/291723/carriers/digital?_dc=1687163219114
t Transfer: 1220 :     15|09:26:49.4427|67ijF7|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:26:49.4427|67ijF7|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:26:49.4427|67ijF7|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:26:49.4427|67ijF7|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  15|09:26:49.4427|67ijF7|CJPOWERCAST|V3Api.SearchGeneric
t Transfer: 1220 :     15|09:26:49.4427|67ijF7|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:26:49.4427|67ijF7|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:26:49.4437|67ijF7|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     15|09:26:49.4437|67ijF7|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:26:49.4437|67ijF7|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:26:49.4437|67ijF7|CJPOWERCAST|    user CJPOWERCAST.
t Information: 1220 :  15|09:26:49.4437|67ijF7|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 :      15|09:26:49.4437|67ijF7|CJPOWERCAST|imfx v3 API took 0.013s '/api/v3/media/291723/carriers/digital?_dc=1687163219114'
t Transfer: 1220 :     15|09:26:49.8457|CqXznR|CJPOWERCAST|OAuth: /api/v3/media/293748/carriers/digital?_dc=1687163219497
t Transfer: 1220 :     15|09:26:49.8457|CqXznR|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:26:49.8457|CqXznR|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:26:49.8457|CqXznR|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:26:49.8457|CqXznR|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  15|09:26:49.8457|CqXznR|CJPOWERCAST|V3Api.SearchGeneric
t Transfer: 1220 :     15|09:26:49.8457|CqXznR|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:26:49.8457|CqXznR|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:26:49.8467|CqXznR|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     15|09:26:49.8467|CqXznR|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:26:49.8467|CqXznR|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:26:49.8467|CqXznR|CJPOWERCAST|    user CJPOWERCAST.
t Information: 1220 :  15|09:26:49.8467|CqXznR|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 :      15|09:26:49.8467|CqXznR|CJPOWERCAST|imfx v3 API took 0.013s '/api/v3/media/293748/carriers/digital?_dc=1687163219497'
t Transfer: 1220 :     15|09:26:50.2487|5x3IAU|CJPOWERCAST|OAuth: /api/v3/media/298938/carriers/digital?_dc=1687163219886
t Transfer: 1220 :     15|09:26:50.2487|5x3IAU|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:26:50.2487|5x3IAU|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:26:50.2487|5x3IAU|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:26:50.2487|5x3IAU|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  15|09:26:50.2497|5x3IAU|CJPOWERCAST|V3Api.SearchGeneric
t Transfer: 1220 :     15|09:26:50.2497|5x3IAU|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:26:50.2497|5x3IAU|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:26:50.2497|5x3IAU|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     15|09:26:50.2497|5x3IAU|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:26:50.2497|5x3IAU|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:26:50.2497|5x3IAU|CJPOWERCAST|    user CJPOWERCAST.
t Information: 1220 :  15|09:26:50.2507|5x3IAU|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 :      15|09:26:50.2507|5x3IAU|CJPOWERCAST|imfx v3 API took 0.012s '/api/v3/media/298938/carriers/digital?_dc=1687163219886'
t Transfer: 1220 :     15|09:27:04.1186|u053Qq|CJPOWERCAST|OAuth: /api/v3/media/299739/carriers/physical?_dc=1687163233788
t Transfer: 1220 :     15|09:27:04.1186|u053Qq|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:27:04.1186|u053Qq|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:27:04.1186|u053Qq|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:27:04.1186|u053Qq|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  15|09:27:04.1196|u053Qq|CJPOWERCAST|V3Api.SearchGeneric
t Transfer: 1220 :     15|09:27:04.1196|u053Qq|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:27:04.1196|u053Qq|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:27:04.1196|u053Qq|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     15|09:27:04.1196|u053Qq|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:27:04.1196|u053Qq|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:27:04.1196|u053Qq|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:27:04.1196|u053Qq|CJPOWERCAST|imfx v3 API took 0.010s '/api/v3/media/299739/carriers/physical?_dc=1687163233788'
t Transfer: 1220 :     15|09:27:05.1246|D7g6bF|CJPOWERCAST|OAuth: /api/v3/media/299536/carriers/digital?_dc=1687163234863
t Transfer: 1220 :     15|09:27:05.1246|D7g6bF|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:27:05.1246|D7g6bF|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:27:05.1246|D7g6bF|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:27:05.1246|D7g6bF|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  15|09:27:05.1246|D7g6bF|CJPOWERCAST|V3Api.SearchGeneric
t Transfer: 1220 :     15|09:27:05.1246|D7g6bF|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:27:05.1246|D7g6bF|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:27:05.1256|D7g6bF|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     15|09:27:05.1256|D7g6bF|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:27:05.1256|D7g6bF|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:27:05.1256|D7g6bF|CJPOWERCAST|    user CJPOWERCAST.
t Information: 1220 :  15|09:27:05.1256|D7g6bF|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 :      15|09:27:05.1256|D7g6bF|CJPOWERCAST|imfx v3 API took 0.012s '/api/v3/media/299536/carriers/digital?_dc=1687163234863'
t Transfer: 1220 :     15|09:27:06.1306|j4HJtj|CJPOWERCAST|OAuth: /api/v3/media/299549/carriers/digital?_dc=1687163235736
t Transfer: 1220 :     15|09:27:06.1306|j4HJtj|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:27:06.1306|j4HJtj|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:27:06.1306|j4HJtj|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:27:06.1306|j4HJtj|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  15|09:27:06.1306|j4HJtj|CJPOWERCAST|V3Api.SearchGeneric
t Transfer: 1220 :     15|09:27:06.1306|j4HJtj|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:27:06.1316|j4HJtj|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:27:06.1316|j4HJtj|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     15|09:27:06.1316|j4HJtj|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:27:06.1316|j4HJtj|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:27:06.1316|j4HJtj|CJPOWERCAST|    user CJPOWERCAST.
t Information: 1220 :  15|09:27:06.1316|j4HJtj|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 :      15|09:27:06.1316|j4HJtj|CJPOWERCAST|imfx v3 API took 0.018s '/api/v3/media/299549/carriers/digital?_dc=1687163235736'
t Transfer: 1220 :     15|09:27:07.3366|SzWWVm|CJPOWERCAST|OAuth: /api/v3/media/299890/carriers/digital?_dc=1687163237088
t Transfer: 1220 :     15|09:27:07.3366|SzWWVm|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:27:07.3366|SzWWVm|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:27:07.3366|SzWWVm|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:27:07.3366|SzWWVm|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  15|09:27:07.3366|SzWWVm|CJPOWERCAST|V3Api.SearchGeneric
t Transfer: 1220 :     15|09:27:07.3376|SzWWVm|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:27:07.3376|SzWWVm|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:27:07.3376|SzWWVm|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     15|09:27:07.3376|SzWWVm|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:27:07.3376|SzWWVm|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:27:07.3376|SzWWVm|CJPOWERCAST|    user CJPOWERCAST.
t Information: 1220 :  15|09:27:07.3376|SzWWVm|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 :      15|09:27:07.3376|SzWWVm|CJPOWERCAST|imfx v3 API took 0.011s '/api/v3/media/299890/carriers/digital?_dc=1687163237088'
t Transfer: 1220 :     15|09:27:08.1416|3H2EZt|CJPOWERCAST|OAuth: /api/v3/media/291723/carriers/digital?_dc=1687163237902
t Transfer: 1220 :     15|09:27:08.1416|3H2EZt|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:27:08.1416|3H2EZt|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:27:08.1416|3H2EZt|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:27:08.1416|3H2EZt|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  15|09:27:08.1416|3H2EZt|CJPOWERCAST|V3Api.SearchGeneric
t Transfer: 1220 :     15|09:27:08.1416|3H2EZt|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:27:08.1416|3H2EZt|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:27:08.1426|3H2EZt|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     15|09:27:08.1426|3H2EZt|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:27:08.1426|3H2EZt|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:27:08.1426|3H2EZt|CJPOWERCAST|    user CJPOWERCAST.
t Information: 1220 :  15|09:27:08.3436|3H2EZt|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 :      15|09:27:08.3436|3H2EZt|CJPOWERCAST|imfx v3 API took 0.011s '/api/v3/media/291723/carriers/digital?_dc=1687163237902'
t Transfer: 1220 :     15|09:27:08.9466|5uU~4m|CJPOWERCAST|OAuth: /api/v3/media/293748/carriers/digital?_dc=1687163238685
t Transfer: 1220 :     15|09:27:08.9466|5uU~4m|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:27:08.9466|5uU~4m|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:27:08.9466|5uU~4m|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:27:08.9466|5uU~4m|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  15|09:27:08.9466|5uU~4m|CJPOWERCAST|V3Api.SearchGeneric
t Transfer: 1220 :     15|09:27:08.9466|5uU~4m|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:27:08.9466|5uU~4m|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:27:08.9476|5uU~4m|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     15|09:27:08.9476|5uU~4m|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:27:08.9476|5uU~4m|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:27:08.9476|5uU~4m|CJPOWERCAST|    user CJPOWERCAST.
t Information: 1220 :  15|09:27:08.9476|5uU~4m|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 :      15|09:27:08.9476|5uU~4m|CJPOWERCAST|imfx v3 API took 0.012s '/api/v3/media/293748/carriers/digital?_dc=1687163238685'
t Transfer: 1220 :     15|09:27:09.5495|L2XE52|CJPOWERCAST|OAuth: /api/v3/media/298938/carriers/digital?_dc=1687163239307
t Transfer: 1220 :     15|09:27:09.5495|L2XE52|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:27:09.5495|L2XE52|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:27:09.5495|L2XE52|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      15|09:27:09.5495|L2XE52|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  15|09:27:09.5495|L2XE52|CJPOWERCAST|V3Api.SearchGeneric
t Transfer: 1220 :     15|09:27:09.5495|L2XE52|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:27:09.5495|L2XE52|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:27:09.5506|L2XE52|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     15|09:27:09.5506|L2XE52|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     15|09:27:09.5506|L2XE52|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     15|09:27:09.5506|L2XE52|CJPOWERCAST|    user CJPOWERCAST.
t Information: 1220 :  15|09:27:09.7515|L2XE52|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 :      15|09:27:09.7515|L2XE52|CJPOWERCAST|imfx v3 API took 0.012s '/api/v3/media/298938/carriers/digital?_dc=1687163239307'
t Information: 1220 :  15|11:43:02.3669|||OrabitWatcherBasic. Disposing.
t Information: 1220 :  15|11:43:02.3669|||OrabitWatcherBasic. Disposed.
t Information: 1220 :  15|11:43:02.3669|||==========================================================================
t Information: 1220 :  15|11:43:02.3679|||IMFX CORE SERVER APPLICATION END.