t Transfer: 1220 : 10|09:44:13.4892|cFJYZH||OAuth: /api/logout?_dc=1689756253173 t Transfer: 1220 : 10|09:44:13.4892|cFJYZH||GetCurrentUser.. t Transfer: 1220 : 10|09:44:13.4892|cFJYZH|| OAuth authenticated t Verbose: 1220 : 10|09:44:13.4892|cFJYZH|| uid claim is missing.. t Information: 1220 : 10|09:44:13.4892|cFJYZH||OAuth. AutoLogin no Windows identity type WindowsIdentity t Transfer: 1220 : 10|09:44:13.8912|W2o6fq||GetAppInfo. DB: TMDDEMO. Install mode: . Auth types: Native, PublicApiKey t Information: 1220 : 10|09:44:14.2932|LQ2w8q||GetCache. t Information: 1220 : 10|09:44:14.2932|LQ2w8q||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\108_2_PnqJC_.png t Information: 1220 : 10|09:44:14.2942|LQ2w8q||GetCache. Data read: 154944 t Verbose: 1220 : 10|09:44:14.2942|LQ2w8q||imfx v3 API took 0.068s '/api/v3/visual-asset/group/PnqJC_/2/image' t Verbose: 1220 : 10|09:44:16.1022|lG34~0||Oauth validating.. t Verbose: 1220 : 10|09:44:16.1022|lG34~0||GrantResourceOwnerCredentials. t Verbose: 1220 : 10|09:44:16.3032|lG34~0||LoginUser. cjpowercast, login type OAuth, encrypt password True t Information: 1220 : 10|09:44:16.3032|lG34~0||TryLoginUser. cjpowercast, login type OAuth, check password True, check hash False, encrypt password True, load user data False t Information: 1220 : 10|09:44:16.9062|lG34~0|| oauth token 00000000-0000-0000-0000-000000000000 t Information: 1220 : 10|09:44:16.9062|lG34~0||TryLoginUser. Logged in.. t Information: 1220 : 10|09:44:16.9062|lG34~0||GetPasswordPolicy. WARNING: Policy not found for system Imediaflex. Validation disabled. t Verbose: 1220 : 10|09:44:16.9062|lG34~0||LoginUser. Adding history. User Id 1165, result CJPOWERCAST, host 192.168.127.6 t Verbose: 1220 : 10|09:44:16.9062|lG34~0||GrantResourceOwnerCredentials. Try login finished. Logged: True t Transfer: 1220 : 10|09:44:17.5092|xevXUJ|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=1689756257251 t Transfer: 1220 : 10|09:44:17.5092|xevXUJ|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:17.5092|xevXUJ|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:17.5092|xevXUJ|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:44:17.5092|xevXUJ|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|09:44:17.5092|xevXUJ|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:17.5092|xevXUJ|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:17.5102|xevXUJ|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:44:17.5102|xevXUJ|CJPOWERCAST|imfx v3 API took 0.053s '/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=1689756257251' t Transfer: 1220 : 10|09:44:17.9122|6eKq25|CJPOWERCAST|OAuth: /api/user-preferences?keys=personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch;workflow_queues_actions;workflow_queues_settings&_dc=1689756257614 t Transfer: 1220 : 10|09:44:17.9122|6eKq25|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:17.9122|6eKq25|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:17.9122|6eKq25|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:44:17.9122|6eKq25|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|09:44:17.9122|6eKq25|CJPOWERCAST|GetUserDataByKeys: personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch;workflow_queues_actions;workflow_queues_settings t Transfer: 1220 : 10|09:44:17.9132|6eKq25|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:17.9132|6eKq25|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:17.9132|6eKq25|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:44:17.9132|6eKq25|CJPOWERCAST|imfx v3 API took 0.052s '/api/user-preferences?keys=personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch;workflow_queues_actions;workflow_queues_settings&_dc=1689756257614' t Information: 1220 : 10|09:44:18.3152|LkKocm|CJPOWERCAST|GetUserProfile. Id: 0 t Transfer: 1220 : 10|09:44:18.3152|LkKocm|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:18.3152|LkKocm|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:18.3152|LkKocm|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:44:18.7172|2LhuRl|CJPOWERCAST|OAuth: /api/settings/user/mainMenuSettings?_dc=1689756258374 t Transfer: 1220 : 10|09:44:18.7172|2LhuRl|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:18.7172|2LhuRl|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:18.7172|2LhuRl|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:44:18.7172|2LhuRl|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|09:44:18.7172|2LhuRl|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:18.7182|2LhuRl|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:18.7182|2LhuRl|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:44:18.7182|cWe9sj|CJPOWERCAST|OAuth: /api/settings/group/0?_dc=1689756258374 t Transfer: 1220 : 10|09:44:18.7182|cWe9sj|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:18.7182|cWe9sj|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:18.7182|cWe9sj|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:44:18.7182|cWe9sj|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 10|09:44:18.7182|2LhuRl|CJPOWERCAST|imfx v3 API took 0.007s '/api/settings/user/mainMenuSettings?_dc=1689756258374' t Transfer: 1220 : 10|09:44:18.7182|jYGIbu|CJPOWERCAST|OAuth: /api/settings/user/uploadSettings?_dc=1689756258379 t Transfer: 1220 : 10|09:44:18.7192|jYGIbu|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:18.7192|jYGIbu|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:18.7192|jYGIbu|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:44:18.7192|jYGIbu|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|09:44:18.7192|N~_W01|CJPOWERCAST|OAuth: /api/settings/user/mainMenuSettings?_dc=1689756258388 t Transfer: 1220 : 10|09:44:18.7192|N~_W01|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:18.7202|N~_W01|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:18.7202|N~_W01|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:44:18.7202|N~_W01|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|09:44:18.7202|XWOyaO|CJPOWERCAST|OAuth: /api/settings/group/0?_dc=1689756258388 t Transfer: 1220 : 10|09:44:18.7202|XWOyaO|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:18.7202|XWOyaO|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:18.7202|XWOyaO|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:44:18.7212|XWOyaO|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|09:44:18.7212|jYGIbu|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:18.7212|jYGIbu|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:18.7212|jYGIbu|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:44:18.7212|N~_W01|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:18.7212|N~_W01|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:18.7212|N~_W01|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:44:18.9222|jYGIbu|CJPOWERCAST|imfx v3 API took 0.091s '/api/settings/user/uploadSettings?_dc=1689756258379' t Verbose: 1220 : 10|09:44:18.9222|N~_W01|CJPOWERCAST|imfx v3 API took 0.078s '/api/settings/user/mainMenuSettings?_dc=1689756258388' t Information: 1220 : 10|09:44:19.1232|WxeH2e||GetCache. t Information: 1220 : 10|09:44:19.1232|WxeH2e||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\201_0_Any_gO.png t Information: 1220 : 10|09:44:19.1232|WxeH2e||GetCache. Data read: 0 t Verbose: 1220 : 10|09:44:19.1232|WxeH2e||imfx v3 API took 0.008s '/api/v3/visual-asset/group/Any_gO/0/image' t Transfer: 1220 : 10|09:44:19.1242|K2EAuy|CJPOWERCAST|OAuth: /api/lookups/MediaStatus?_dc=1689756258393 t Transfer: 1220 : 10|09:44:19.1242|K2EAuy|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:19.1242|K2EAuy|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:19.1242|K2EAuy|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:44:19.1242|K2EAuy|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 10|09:44:19.1242|K2EAuy|CJPOWERCAST|imfx v3 API took 0.031s '/api/lookups/MediaStatus?_dc=1689756258393' t Transfer: 1220 : 10|09:44:19.1252|exma6V|CJPOWERCAST|OAuth: /api/lookups/PgmStatus?_dc=1689756258393 t Transfer: 1220 : 10|09:44:19.1252|exma6V|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:19.1252|exma6V|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:19.1252|exma6V|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:44:19.1252|exma6V|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 10|09:44:19.1252|exma6V|CJPOWERCAST|imfx v3 API took 0.000s '/api/lookups/PgmStatus?_dc=1689756258393' t Verbose: 1220 : 10|09:44:19.1252|XWOyaO|CJPOWERCAST|imfx v3 API took 0.375s '/api/settings/group/0?_dc=1689756258388' t Verbose: 1220 : 10|09:44:19.1262|cWe9sj|CJPOWERCAST|imfx v3 API took 0.453s '/api/settings/group/0?_dc=1689756258374' t Transfer: 1220 : 10|09:44:19.3272|q29QSd|CJPOWERCAST|OAuth: /api/lookup/CustomMediaStatusTypes?_dc=1689756258394 t Transfer: 1220 : 10|09:44:19.3272|q29QSd|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:19.3272|q29QSd|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:19.3272|q29QSd|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:44:19.3272|q29QSd|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 10|09:44:19.3272|q29QSd|CJPOWERCAST|imfx v3 API took 0.053s '/api/lookup/CustomMediaStatusTypes?_dc=1689756258394' t Transfer: 1220 : 10|09:44:19.3282|DXLfOw|CJPOWERCAST|OAuth: /api/lookup/CustomVersionStatusTypes?_dc=1689756258394 t Transfer: 1220 : 10|09:44:19.3282|DXLfOw|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:19.3282|DXLfOw|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:19.3282|DXLfOw|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:44:19.3282|DXLfOw|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 10|09:44:19.5292|DXLfOw|CJPOWERCAST|imfx v3 API took 0.043s '/api/lookup/CustomVersionStatusTypes?_dc=1689756258394' t Transfer: 1220 : 10|09:44:19.5292|OevHdv|CJPOWERCAST|OAuth: /api/lookup/CustomTitleStatusTypes?_dc=1689756258394 t Transfer: 1220 : 10|09:44:19.5292|OevHdv|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:19.5292|OevHdv|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:19.5292|OevHdv|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:44:19.5292|OevHdv|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|09:44:19.5292|5TWbz_|CJPOWERCAST|OAuth: /api/settings/user/defaultHomePage?_dc=1689756258395 t Transfer: 1220 : 10|09:44:19.5302|5TWbz_|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:19.5302|5TWbz_|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:19.5302|5TWbz_|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:44:19.5302|5TWbz_|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 10|09:44:19.5302|OevHdv|CJPOWERCAST|imfx v3 API took 0.010s '/api/lookup/CustomTitleStatusTypes?_dc=1689756258394' t Transfer: 1220 : 10|09:44:19.5302|5TWbz_|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:19.5302|5TWbz_|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:19.5302|5TWbz_|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:44:19.5302|5TWbz_|CJPOWERCAST|imfx v3 API took 0.008s '/api/settings/user/defaultHomePage?_dc=1689756258395' t Information: 1220 : 10|09:44:19.5302|gC5cs3||GetCache. t Information: 1220 : 10|09:44:19.5312|gC5cs3||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\202_1_Any_gO.png t Information: 1220 : 10|09:44:19.5312|gC5cs3||GetCache. Data read: 0 t Verbose: 1220 : 10|09:44:19.5312|gC5cs3||imfx v3 API took 0.005s '/api/v3/visual-asset/group/Any_gO/1/image' t Transfer: 1220 : 10|09:44:21.3402|FwPt8Z|CJPOWERCAST|OAuth: /api/settings/user/defaultSearch?_dc=1689756260970 t Transfer: 1220 : 10|09:44:21.3402|FwPt8Z|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:21.3402|FwPt8Z|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:21.3402|FwPt8Z|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:44:21.3402|FwPt8Z|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|09:44:21.3402|FwPt8Z|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:21.3412|FwPt8Z|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:21.3412|FwPt8Z|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:44:21.3412|E6W13W|CJPOWERCAST|OAuth: /api/settings/user/startSearch?_dc=1689756260971 t Transfer: 1220 : 10|09:44:21.3412|E6W13W|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:21.3412|E6W13W|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:21.3412|E6W13W|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:44:21.3412|E6W13W|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|09:44:21.3412|E6W13W|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:21.3422|E6W13W|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:21.3422|E6W13W|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:44:21.3422|FwPt8Z|CJPOWERCAST|imfx v3 API took 0.010s '/api/settings/user/defaultSearch?_dc=1689756260970' t Verbose: 1220 : 10|09:44:21.3422|E6W13W|CJPOWERCAST|imfx v3 API took 0.012s '/api/settings/user/startSearch?_dc=1689756260971' t Transfer: 1220 : 10|09:44:21.5432|KeeJnF|CJPOWERCAST|OAuth: /api/user-preferences?keys=adv.recent.searches.consumer&_dc=1689756261285 t Transfer: 1220 : 10|09:44:21.5432|KeeJnF|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:21.5432|KeeJnF|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:21.5432|KeeJnF|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:44:21.5432|KeeJnF|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|09:44:21.5432|KeeJnF|CJPOWERCAST|GetUserDataByKeys: adv.recent.searches.consumer t Transfer: 1220 : 10|09:44:21.5442|KeeJnF|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:21.5442|KeeJnF|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:21.5442|KeeJnF|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:44:21.5442|2OJsVd|CJPOWERCAST|OAuth: /api/user-preferences?keys=consumer.recent.data&_dc=1689756261278 t Transfer: 1220 : 10|09:44:21.5442|2OJsVd|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:21.5442|2OJsVd|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:21.5442|2OJsVd|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:44:21.5442|2OJsVd|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|09:44:21.5452|2OJsVd|CJPOWERCAST|GetUserDataByKeys: consumer.recent.data t Transfer: 1220 : 10|09:44:21.5452|2OJsVd|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:21.5452|2OJsVd|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:21.5452|2OJsVd|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:44:21.5452|KeeJnF|CJPOWERCAST|imfx v3 API took 0.009s '/api/user-preferences?keys=adv.recent.searches.consumer&_dc=1689756261285' t Information: 1220 : 10|09:44:21.5452|~E4akF||GetCache. t Information: 1220 : 10|09:44:21.5452|~E4akF||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\204_3_Any_gO.png t Information: 1220 : 10|09:44:21.5452|~E4akF||GetCache. Data read: 5504 t Verbose: 1220 : 10|09:44:21.5452|~E4akF||imfx v3 API took 0.004s '/api/v3/visual-asset/group/Any_gO/3/image' t Verbose: 1220 : 10|09:44:21.5452|2OJsVd|CJPOWERCAST|imfx v3 API took 0.014s '/api/user-preferences?keys=consumer.recent.data&_dc=1689756261278' t Transfer: 1220 : 10|09:44:26.9712|YbfHQT|CJPOWERCAST|OAuth: /api/view/searchinfo/TitleSearch?_dc=1689756266738 t Transfer: 1220 : 10|09:44:26.9712|YbfHQT|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:26.9712|YbfHQT|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:26.9712|YbfHQT|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:44:26.9712|YbfHQT|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|09:44:26.9712|P4P~HK|CJPOWERCAST|OAuth: /api/lookups/SearchSupportedOperators?_dc=1689756266738 t Transfer: 1220 : 10|09:44:26.9712|P4P~HK|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:26.9712|P4P~HK|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:26.9722|P4P~HK|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:44:26.9722|P4P~HK|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|09:44:26.9722|XVXN2Y|CJPOWERCAST|OAuth: /api/user-preferences?keys=adv.recent.searches.titles&_dc=1689756266739 t Transfer: 1220 : 10|09:44:26.9722|XVXN2Y|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:26.9722|XVXN2Y|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:26.9722|XVXN2Y|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:44:26.9722|XVXN2Y|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|09:44:26.9722|XVXN2Y|CJPOWERCAST|GetUserDataByKeys: adv.recent.searches.titles t Transfer: 1220 : 10|09:44:26.9722|XVXN2Y|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:26.9722|XVXN2Y|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:26.9732|XVXN2Y|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:44:26.9732|P4P~HK|CJPOWERCAST|imfx v3 API took 0.000s '/api/lookups/SearchSupportedOperators?_dc=1689756266738' t Information: 1220 : 10|09:44:26.9732|YbfHQT|CJPOWERCAST|GetAdvSearchColumns. search type TitleSearch grid . t Verbose: 1220 : 10|09:44:26.9732|YbfHQT|CJPOWERCAST|imfx v3 API took 0.002s '/api/view/searchinfo/TitleSearch?_dc=1689756266738' t Verbose: 1220 : 10|09:44:26.9732|XVXN2Y|CJPOWERCAST|imfx v3 API took 0.010s '/api/user-preferences?keys=adv.recent.searches.titles&_dc=1689756266739' t Transfer: 1220 : 10|09:44:26.9732|vOQq_U|CJPOWERCAST|OAuth: /api/view/searches/TitleSearch?_dc=1689756266762 t Transfer: 1220 : 10|09:44:26.9732|vOQq_U|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:26.9742|vOQq_U|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:26.9742|vOQq_U|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:44:26.9742|vOQq_U|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|09:44:26.9742|vOQq_U|CJPOWERCAST|GetSavedSearchNames. search type TitleSearch. t Transfer: 1220 : 10|09:44:26.9742|vOQq_U|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:26.9742|vOQq_U|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:26.9742|vOQq_U|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:44:27.1762|vOQq_U|CJPOWERCAST|imfx v3 API took 0.041s '/api/view/searches/TitleSearch?_dc=1689756266762' t Transfer: 1220 : 10|09:44:27.3772|kORltu|CJPOWERCAST|OAuth: /api/view/info/VersionGrid?lang=en-GB&_dc=1689756266770 t Transfer: 1220 : 10|09:44:27.3772|kORltu|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:27.3772|kORltu|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:27.3772|kORltu|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:44:27.3772|kORltu|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|09:44:27.3772|kORltu|CJPOWERCAST|GetGridViewBuilder. builder type VersionGrid. t Transfer: 1220 : 10|09:44:27.3782|kORltu|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:27.3782|kORltu|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:27.3782|kORltu|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|09:44:27.3782|kORltu|CJPOWERCAST|UserGridView. LoadView. ID -2, Name Default. t Transfer: 1220 : 10|09:44:27.3782|kORltu|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:27.3782|kORltu|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:27.3782|kORltu|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:44:27.3782|kORltu|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:27.3782|kORltu|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:27.3782|kORltu|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:44:27.3792|kORltu|CJPOWERCAST|imfx v3 API took 0.107s '/api/view/info/VersionGrid?lang=en-GB&_dc=1689756266770' t Transfer: 1220 : 10|09:44:27.5802|VdMGUT|CJPOWERCAST|OAuth: /api/view/info/MediaGrid?lang=en-GB&_dc=1689756266807 t Transfer: 1220 : 10|09:44:27.5802|VdMGUT|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:27.5802|VdMGUT|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:27.5802|VdMGUT|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:44:27.5802|VdMGUT|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|09:44:27.5802|VdMGUT|CJPOWERCAST|GetGridViewBuilder. builder type MediaGrid. t Transfer: 1220 : 10|09:44:27.5802|VdMGUT|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:27.5802|VdMGUT|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:27.5812|VdMGUT|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|09:44:27.5812|VdMGUT|CJPOWERCAST|UserGridView. LoadView. ID -2, Name Default. t Transfer: 1220 : 10|09:44:27.5812|VdMGUT|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:27.5812|VdMGUT|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:27.5812|VdMGUT|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:44:27.5812|q3EBmI|CJPOWERCAST|OAuth: /api/view/info/DigitalCarriers?lang=en-GB&_dc=1689756266823 t Transfer: 1220 : 10|09:44:27.5812|q3EBmI|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:27.5812|q3EBmI|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:27.5812|q3EBmI|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:44:27.5812|q3EBmI|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|09:44:27.5822|VdMGUT|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:27.5822|VdMGUT|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:27.5822|VdMGUT|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|09:44:27.5822|q3EBmI|CJPOWERCAST|GetGridViewBuilder. builder type DigitalCarriers. t Transfer: 1220 : 10|09:44:27.5822|q3EBmI|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:27.5822|q3EBmI|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:27.5822|q3EBmI|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|09:44:27.5822|q3EBmI|CJPOWERCAST|UserGridView. LoadView. ID -2, Name Default. t Transfer: 1220 : 10|09:44:27.5822|q3EBmI|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:27.5832|q3EBmI|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:27.5832|q3EBmI|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:44:27.5832|VdMGUT|CJPOWERCAST|imfx v3 API took 0.010s '/api/view/info/MediaGrid?lang=en-GB&_dc=1689756266807' t Transfer: 1220 : 10|09:44:27.5832|q3EBmI|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:27.5832|q3EBmI|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:27.5832|q3EBmI|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:44:27.5832|q3EBmI|CJPOWERCAST|imfx v3 API took 0.006s '/api/view/info/DigitalCarriers?lang=en-GB&_dc=1689756266823' t Transfer: 1220 : 10|09:44:27.5832|jfLmTQ|CJPOWERCAST|OAuth: /api/view/info/TitleTree?lang=en-GB&_dc=1689756266838 t Transfer: 1220 : 10|09:44:27.5832|jfLmTQ|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:27.5842|jfLmTQ|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:27.5842|jfLmTQ|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:44:27.5842|jfLmTQ|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|09:44:27.5842|jfLmTQ|CJPOWERCAST|GetGridViewBuilder. builder type TitleTree. t Transfer: 1220 : 10|09:44:27.5842|jfLmTQ|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:27.5842|jfLmTQ|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:27.5842|jfLmTQ|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|09:44:27.5842|jfLmTQ|CJPOWERCAST|UserGridView. LoadView. ID -2, Name Default. t Transfer: 1220 : 10|09:44:27.5842|jfLmTQ|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:27.5842|jfLmTQ|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:27.5852|jfLmTQ|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:44:27.5852|jfLmTQ|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:27.5852|jfLmTQ|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:27.5852|jfLmTQ|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:44:27.5852|jfLmTQ|CJPOWERCAST|imfx v3 API took 0.006s '/api/view/info/TitleTree?lang=en-GB&_dc=1689756266838' t Transfer: 1220 : 10|09:44:32.0072|F~ykfM|CJPOWERCAST|OAuth: /api/v3/search/title?_dc=1689756271740 t Transfer: 1220 : 10|09:44:32.0072|F~ykfM|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:32.0072|F~ykfM|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:32.0072|F~ykfM|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:44:32.0082|F~ykfM|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|09:44:32.2092|F~ykfM|CJPOWERCAST|V3Api.SearchTitles t Information: 1220 : 10|09:44:32.2092|F~ykfM|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 10|09:44:32.2092|F~ykfM|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:32.2092|F~ykfM|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:32.2092|F~ykfM|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|09:44:32.2092|F~ykfM|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 (id in ( (select tobj.pgm_abs_id from TMDDBA.TM_TXT_OBJ tobj join TMDDBA.TM_TXT_TYP ttyp on (ttyp.id = tobj.TYPE_ID) where contains(tobj.ctx_text_col, :param_0 || ' WITHIN TEXT_DATA_PLAIN') > 0 and ttyp.is_alt_title = 1) union (select id from tmddba.tm_pg_abs where contains(ctx_ids_col, :param_0||' WITHIN PROGID1')>0) union (select id from tmddba.tm_pg_abs where contains(ctx_text_col, :param_0||' WITHIN TITLE OR '||:param_0||' WITHIN SER_TITLE')>0))) AND ROWNUM < 25000 ) ) ,v_missing_parent_ids as ( select xparent_id from v minus select id from v ) ,v_missing_parents as ( SELECT distinct a.* ,(select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = a.net_grp_id) CHANNEL_GROUP ,decode(ITEM_TYPE, 1010,SER_ABS_ID, 1020,CASE WHEN SER_ABS2_ID > 0 THEN SER_ABS2_ID ELSE SER_ABS_ID END ) xparent_id FROM TMDDBA.TM_PG_ABS a START WITH ID IN (select xparent_id from v_missing_parent_ids) CONNECT BY CASE PRIOR ITEM_TYPE WHEN 1010 THEN PRIOR SER_ABS_ID WHEN 1020 THEN CASE WHEN NVL(PRIOR SER_ABS2_ID, 0) > 0 THEN PRIOR SER_ABS2_ID ELSE PRIOR SER_ABS_ID END END = ID ) ,v_all as ( select x.*, count(*) over() RowCount from ( select * from v_missing_parents union select * from v ) x ) ,v_top as ( select id from (select id, row_number()over(order by upper(ser_title),upper(title),ser_num,ser_ep_num, SER_EP_SQ_NUM ) rnk -- sort roots from v_all where xparent_id is null) where rnk between (:page_number-1)*50+1 and :page_number*50 ) ,v_tree as ( select level "TreeLevel", a.*from v_all a start with id in (select id from v_top) connect by xparent_id = prior ID order siblings by upper(ser_title),ser_num,ser_ep_num, SER_EP_SQ_NUM,upper(title) -- sort children ) select * from v_tree --where rnk <= 50 t Verbose: 1220 : 10|09:44:33.4152|F~ykfM|CJPOWERCAST|imfx v3 API took 1.164s '/api/v3/search/title?_dc=1689756271740' t Transfer: 1220 : 10|09:44:33.8172|qh1BX2|CJPOWERCAST|OAuth: /api/user-preferences?_dc=1689756273439 t Transfer: 1220 : 10|09:44:33.8172|qh1BX2|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:33.8172|qh1BX2|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:33.8172|qh1BX2|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:44:33.8172|qh1BX2|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 10|09:44:33.8172|qh1BX2|CJPOWERCAST|StoreUserDataByKeys.. t Transfer: 1220 : 10|09:44:33.8172|qh1BX2|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:33.8182|qh1BX2|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:33.8182|qh1BX2|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:44:33.8182|qh1BX2|CJPOWERCAST|imfx v3 API took 0.019s '/api/user-preferences?_dc=1689756273439' t Transfer: 1220 : 10|09:44:42.6602|1lbdtP|CJPOWERCAST|OAuth: /api/v3/search/title?_dc=1689756282448 t Transfer: 1220 : 10|09:44:42.6602|1lbdtP|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:42.6602|1lbdtP|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:42.6602|1lbdtP|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:44:42.6602|1lbdtP|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|09:44:42.6602|1lbdtP|CJPOWERCAST|V3Api.SearchTitles t Information: 1220 : 10|09:44:42.6602|1lbdtP|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 10|09:44:42.6612|1lbdtP|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:42.6612|1lbdtP|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:42.6612|1lbdtP|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|09:44:42.6612|1lbdtP|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 (id in ( (select tobj.pgm_abs_id from TMDDBA.TM_TXT_OBJ tobj join TMDDBA.TM_TXT_TYP ttyp on (ttyp.id = tobj.TYPE_ID) where contains(tobj.ctx_text_col, :param_0 || ' WITHIN TEXT_DATA_PLAIN') > 0 and ttyp.is_alt_title = 1) union (select id from tmddba.tm_pg_abs where contains(ctx_ids_col, :param_0||' WITHIN PROGID1')>0) union (select id from tmddba.tm_pg_abs where contains(ctx_text_col, :param_0||' WITHIN TITLE OR '||:param_0||' WITHIN SER_TITLE')>0))) AND ROWNUM < 25000 ) ) ,v_missing_parent_ids as ( select xparent_id from v minus select id from v ) ,v_missing_parents as ( SELECT distinct a.* ,(select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = a.net_grp_id) CHANNEL_GROUP ,decode(ITEM_TYPE, 1010,SER_ABS_ID, 1020,CASE WHEN SER_ABS2_ID > 0 THEN SER_ABS2_ID ELSE SER_ABS_ID END ) xparent_id FROM TMDDBA.TM_PG_ABS a START WITH ID IN (select xparent_id from v_missing_parent_ids) CONNECT BY CASE PRIOR ITEM_TYPE WHEN 1010 THEN PRIOR SER_ABS_ID WHEN 1020 THEN CASE WHEN NVL(PRIOR SER_ABS2_ID, 0) > 0 THEN PRIOR SER_ABS2_ID ELSE PRIOR SER_ABS_ID END END = ID ) ,v_all as ( select x.*, count(*) over() RowCount from ( select * from v_missing_parents union select * from v ) x ) ,v_top as ( select id from (select id, row_number()over(order by upper(ser_title),upper(title),ser_num,ser_ep_num, SER_EP_SQ_NUM ) rnk -- sort roots from v_all where xparent_id is null) where rnk between (:page_number-1)*50+1 and :page_number*50 ) ,v_tree as ( select level "TreeLevel", a.*from v_all a start with id in (select id from v_top) connect by xparent_id = prior ID order siblings by upper(ser_title),ser_num,ser_ep_num, SER_EP_SQ_NUM,upper(title) -- sort children ) select * from v_tree --where rnk <= 50 t Verbose: 1220 : 10|09:44:42.6612|1lbdtP|CJPOWERCAST|imfx v3 API took 0.023s '/api/v3/search/title?_dc=1689756282448' t Transfer: 1220 : 10|09:44:43.0632|B9bwAD|CJPOWERCAST|OAuth: /api/user-preferences?_dc=1689756282785 t Transfer: 1220 : 10|09:44:43.0632|B9bwAD|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:43.0632|B9bwAD|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:43.0632|B9bwAD|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:44:43.0632|B9bwAD|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 10|09:44:43.0632|B9bwAD|CJPOWERCAST|StoreUserDataByKeys.. t Transfer: 1220 : 10|09:44:43.0632|B9bwAD|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:43.0632|B9bwAD|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:43.0642|B9bwAD|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:44:43.0642|B9bwAD|CJPOWERCAST|imfx v3 API took 0.008s '/api/user-preferences?_dc=1689756282785' t Transfer: 1220 : 10|09:44:46.8831|6jc77u|CJPOWERCAST|OAuth: /api/v3/search/title?_dc=1689756286592 t Transfer: 1220 : 10|09:44:46.8831|6jc77u|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:46.8831|6jc77u|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:46.8831|6jc77u|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:44:46.8831|6jc77u|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|09:44:46.8831|6jc77u|CJPOWERCAST|V3Api.SearchTitles t Information: 1220 : 10|09:44:46.8831|6jc77u|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 10|09:44:46.8842|6jc77u|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:46.8842|6jc77u|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:46.8842|6jc77u|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|09:44:46.8842|6jc77u|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 (id in ( (select tobj.pgm_abs_id from TMDDBA.TM_TXT_OBJ tobj join TMDDBA.TM_TXT_TYP ttyp on (ttyp.id = tobj.TYPE_ID) where contains(tobj.ctx_text_col, :param_0 || ' WITHIN TEXT_DATA_PLAIN') > 0 and ttyp.is_alt_title = 1) union (select id from tmddba.tm_pg_abs where contains(ctx_ids_col, :param_0||' WITHIN PROGID1')>0) union (select id from tmddba.tm_pg_abs where contains(ctx_text_col, :param_0||' WITHIN TITLE OR '||:param_0||' WITHIN SER_TITLE')>0))) AND ROWNUM < 25000 ) ) ,v_missing_parent_ids as ( select xparent_id from v minus select id from v ) ,v_missing_parents as ( SELECT distinct a.* ,(select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = a.net_grp_id) CHANNEL_GROUP ,decode(ITEM_TYPE, 1010,SER_ABS_ID, 1020,CASE WHEN SER_ABS2_ID > 0 THEN SER_ABS2_ID ELSE SER_ABS_ID END ) xparent_id FROM TMDDBA.TM_PG_ABS a START WITH ID IN (select xparent_id from v_missing_parent_ids) CONNECT BY CASE PRIOR ITEM_TYPE WHEN 1010 THEN PRIOR SER_ABS_ID WHEN 1020 THEN CASE WHEN NVL(PRIOR SER_ABS2_ID, 0) > 0 THEN PRIOR SER_ABS2_ID ELSE PRIOR SER_ABS_ID END END = ID ) ,v_all as ( select x.*, count(*) over() RowCount from ( select * from v_missing_parents union select * from v ) x ) ,v_top as ( select id from (select id, row_number()over(order by upper(ser_title),upper(title),ser_num,ser_ep_num, SER_EP_SQ_NUM ) rnk -- sort roots from v_all where xparent_id is null) where rnk between (:page_number-1)*50+1 and :page_number*50 ) ,v_tree as ( select level "TreeLevel", a.*from v_all a start with id in (select id from v_top) connect by xparent_id = prior ID order siblings by upper(ser_title),ser_num,ser_ep_num, SER_EP_SQ_NUM,upper(title) -- sort children ) select * from v_tree --where rnk <= 50 t Verbose: 1220 : 10|09:44:47.0851|6jc77u|CJPOWERCAST|imfx v3 API took 0.259s '/api/v3/search/title?_dc=1689756286592' t Transfer: 1220 : 10|09:44:47.4871|8zv1Xu|CJPOWERCAST|OAuth: /api/user-preferences?_dc=1689756287197 t Transfer: 1220 : 10|09:44:47.4871|8zv1Xu|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:47.4871|8zv1Xu|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:47.4871|8zv1Xu|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:44:47.4871|8zv1Xu|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 10|09:44:47.4871|8zv1Xu|CJPOWERCAST|StoreUserDataByKeys.. t Transfer: 1220 : 10|09:44:47.4871|8zv1Xu|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:47.4871|8zv1Xu|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:47.4871|8zv1Xu|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:44:47.4882|wky~Rm|CJPOWERCAST|OAuth: /api/v3/title/299390/versions?_dc=1689756287195 t Transfer: 1220 : 10|09:44:47.4882|wky~Rm|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:47.4882|wky~Rm|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:47.4882|wky~Rm|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:44:47.4882|wky~Rm|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|09:44:47.4882|wky~Rm|CJPOWERCAST|V3Api.SearchGeneric t Verbose: 1220 : 10|09:44:47.4882|8zv1Xu|CJPOWERCAST|imfx v3 API took 0.009s '/api/user-preferences?_dc=1689756287197' t Transfer: 1220 : 10|09:44:47.4882|wky~Rm|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:47.4882|wky~Rm|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:47.4882|wky~Rm|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:44:47.4892|wky~Rm|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:47.4892|wky~Rm|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:47.4892|wky~Rm|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:44:47.4892|wky~Rm|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:47.4892|wky~Rm|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:47.4892|wky~Rm|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|09:44:47.4892|wky~Rm|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 : 10|09:44:47.4892|wky~Rm|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:47.4892|wky~Rm|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:47.4902|wky~Rm|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|09:44:47.4902|wky~Rm|CJPOWERCAST|Running version search. User: 1165 Simple Search: Running Oracle search. Running Oracle search for COUNT Oracle count completed in: 27ms. Returned lines: 0 t Verbose: 1220 : 10|09:44:47.4902|wky~Rm|CJPOWERCAST|imfx v3 API took 0.059s '/api/v3/title/299390/versions?_dc=1689756287195' t Transfer: 1220 : 10|09:44:59.5492|ReXCA0|CJPOWERCAST|OAuth: /api/user-preferences?keys=adv.recent.searches.media&_dc=1689756299099 t Transfer: 1220 : 10|09:44:59.5492|ReXCA0|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:59.5492|ReXCA0|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:59.5492|ReXCA0|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:44:59.5492|ReXCA0|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|09:44:59.5492|g5nxaK|CJPOWERCAST|OAuth: /api/settings/user/searchLayoutConfig?_dc=1689756299126 t Transfer: 1220 : 10|09:44:59.5492|g5nxaK|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:59.5492|g5nxaK|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:59.5501|g5nxaK|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:44:59.5501|g5nxaK|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|09:44:59.5501|pJqkex|CJPOWERCAST|OAuth: /api/view/searches/Media?_dc=1689756299115 t Transfer: 1220 : 10|09:44:59.5501|pJqkex|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:59.5501|pJqkex|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:59.5501|pJqkex|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:44:59.5501|pJqkex|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|09:44:59.5501|kia82Z|CJPOWERCAST|OAuth: /api/view/searchinfo/Media?_dc=1689756299098 t Transfer: 1220 : 10|09:44:59.5501|kia82Z|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:59.5501|kia82Z|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:59.5511|kia82Z|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:44:59.5511|kia82Z|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|09:44:59.5511|g5nxaK|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:59.5511|g5nxaK|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:59.5511|g5nxaK|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|09:44:59.5511|kia82Z|CJPOWERCAST|GetAdvSearchColumns. search type Media grid . t Verbose: 1220 : 10|09:44:59.5511|kia82Z|CJPOWERCAST|imfx v3 API took 0.000s '/api/view/searchinfo/Media?_dc=1689756299098' t Information: 1220 : 10|09:44:59.5511|pJqkex|CJPOWERCAST|GetSavedSearchNames. search type Media. t Transfer: 1220 : 10|09:44:59.5511|pJqkex|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:59.5511|pJqkex|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:59.5511|pJqkex|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:44:59.5521|pJqkex|CJPOWERCAST|imfx v3 API took 0.005s '/api/view/searches/Media?_dc=1689756299115' t Information: 1220 : 10|09:44:59.5521|ReXCA0|CJPOWERCAST|GetUserDataByKeys: adv.recent.searches.media t Transfer: 1220 : 10|09:44:59.5521|ReXCA0|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:44:59.5521|ReXCA0|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:44:59.5521|ReXCA0|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:44:59.5521|g5nxaK|CJPOWERCAST|imfx v3 API took 0.022s '/api/settings/user/searchLayoutConfig?_dc=1689756299126' t Verbose: 1220 : 10|09:44:59.5521|ReXCA0|CJPOWERCAST|imfx v3 API took 0.008s '/api/user-preferences?keys=adv.recent.searches.media&_dc=1689756299099' t Transfer: 1220 : 10|09:45:01.3611|70Fih8|CJPOWERCAST|OAuth: /api/v3/search/Media?_dc=1689756301042 t Transfer: 1220 : 10|09:45:01.3611|70Fih8|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:45:01.3611|70Fih8|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:45:01.3611|70Fih8|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:45:01.3611|70Fih8|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|09:45:01.3611|70Fih8|CJPOWERCAST|V3Api.SearchMedia t Information: 1220 : 10|09:45:01.3622|70Fih8|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 10|09:45:01.3622|70Fih8|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:45:01.3622|70Fih8|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:45:01.3622|70Fih8|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|09:45:01.7641|70Fih8|CJPOWERCAST|Running solr search: [q, (((title:(*))^2 OR series:(*) OR ((filename:(*) OR filename:(*.*)) OR filename:"*") OR (titleMergedNgram:**)^10 OR miid1:(*) OR miid2:(*) OR versionid1:(*) OR progid1:(*)) AND deleted_flag:(0) AND (owners:((SFP2) OR (PSP) OR (PMS) OR (SFP1) OR (PMH) OR (PPL))))] t Information: 1220 : 10|09:45:01.7641|70Fih8|CJPOWERCAST|Solr query returned: 372 in 103ms t Information: 1220 : 10|09:45:01.9651|70Fih8|CJPOWERCAST|MediaSearch SQL: --sqlFromPaging select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type in (1,110)),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , (SELECT min(status.ACCESS_STATUS_NAME) FROM TMDDBA.TM_ACCESS_STATUS statusLnx, TM_CFG_ACCESS_STATUS status WHERE statusLnx.Media_Id = r.id and statusLnx.Status_Id = status.id) ACCESS_STATUS , (select min(acq.ext_ref) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) CONSIGNMENT_NUMBER , (select min(acq.alt_id1) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) TRANSFER_NUMBER , (select min(crs.series_number) from tm_series_data crs where crs.id = r.GROUP_SERIES_ID) CRS_SERIES , (select min(DISPOSAL_NAME) from TM_ACQ_DISPOSAL status, tm_disposal_records records where status.id = records.disposal_status_id and records.miid = r.id) DISPOSAL_STATUS , (select min(class.class_number) from TM_ACQ_DISPOSAL status, tm_disposal_records records, tm_disposal_classes class where status.id = records.disposal_status_id and records.miid = r.id and class.id = records.disposal_class_id) DISPOSAL_CLASS, (select min(names.concat_search_name) from tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names where r.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY, (select min(c.u_id_ext1) from tmddba.tm_mi_tpi_lnx lnx, tm_ctnrs c where c.u_id = lnx.tpiid and lnx.miid = r.id) U_ID_EXT1 , (select t.name from TM_CFG_MI_FMT_TYP t where t.id = r.mi_fmt_type) ITEM_FORMAT_TEXT, CASE WHEN BITAND(r.COMPIL, 2) = 2 THEN 'SUPPLIED' WHEN BITAND(r.COMPIL, 4) = 4 THEN 'MADE' WHEN BITAND(r.COMPIL, 134217728) = 134217728 THEN 'IMPORTED' ELSE '' END AS ORIGIN, CASE WHEN BITAND(r.COMPIL, 512) = 512 THEN 'Attached' WHEN BITAND(r.COMPIL, 1024) = 1024 THEN 'Un-Attached' ELSE '' END AS FLAGS, (select min(lang.full_name) from TM_PG_RL_LANG_LNX lnx, TM_LANG_DATA lang where lnx.tm_pg_rl_id = r.pgm_parent_id and lnx.lang_id = lang.id) AS PROD_LANGUAGE , (select min(ctx.ITFC_CODE) from tm_mis mis, tm_mi_tpi_lnx links, tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names where mis.id = r.id and links.miid = mis.id and mis.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY_NUMBER, (select min(status.description) from TM_CFG_PGM_STATUS status where r.status = status.id) PGM_STATUS_TEXT, (select min(ver.DUR) from TM_PG_RL ver where r.pgm_PARENT_ID = ver.id) AS VERSION_DUR , (select tmd_str_agg_pipe(cms.status_type_id ||',' ||cms.status_id) from tm_mi_cust_med_stat_lnx cms where cms.media_id=r.id) "CustomStatusesRaw", (select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = r.net_grp_id) CHANNEL_GROUP, (SELECT SUBSTR( trim( replace (replace ( LISTAGG(trim(tt.tags || ' ' || tt.notes), ' ') WITHIN GROUP (ORDER BY trim(tt.tags || ' ' || tt.notes)), chr (13), ''), chr (10), ' ')), 1, 150) z FROM tm_media_tagging tt WHERE link_guid = DFILE_LINK_GUID and rownum=1) TAGS_TEXT , GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select t.*, coalesce(t.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=t.pgm_parent_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.pgm_abs_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs2_id) ) primary_thumb_id2 from ( --sqlSubSelect select s.* from (select a.*, rownum rnum from (select --sqlFrom m.* from tmddba.tm_mis m ,(select /*+ cardinality(4) */ rownum rn, column_value id from table(:ids)) ids --sqlWhere where m.id = ids.id order by ids.rn ) a where rownum <= 10000) s where rnum >= 1) t ) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl order by rnum t Verbose: 1220 : 10|09:45:02.7681|70Fih8|CJPOWERCAST|Alternative title fields query: select * from (select x.id,x.pgm_abs_id TitleId, x.pgm_parent_id VersionId from tm_mis x where id in (select /*+ cardinality(4) */ column_value id from table(:ids))) y,lateral (select dbms_lob.substr( o.text_data_plain, 1000, 1 ) Field_5799344 from tm_txt_obj o where (o.pgm_abs_id=y.TitleId or o.pgm_rl_id = y.VersionId) and o.type_id=:param_1 order by o.id desc fetch first 1 rows only)(+) t Information: 1220 : 10|09:45:02.7681|70Fih8|CJPOWERCAST| timing: 00:00:01.4266429 t Verbose: 1220 : 10|09:45:02.7692|70Fih8|CJPOWERCAST|imfx v3 API took 1.478s '/api/v3/search/Media?_dc=1689756301042' t Transfer: 1220 : 10|09:45:02.9702|70Fih8|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Dinosaur 1c.mp4 subfolder t Transfer: 1220 : 10|09:45:02.9702|70Fih8|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Dinosaur%201c.mp4 t Transfer: 1220 : 10|09:45:02.9702|70Fih8|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/Dinosaur%201c.mp4 t Transfer: 1220 : 10|09:45:02.9702|70Fih8|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:45:02.9702|70Fih8|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:45:02.9702|70Fih8|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:45:03.1711|70Fih8|CJPOWERCAST|GetUrl. Storage |Video| filename I:\Video\L0640441.mp4 subfolder t Transfer: 1220 : 10|09:45:03.1711|70Fih8|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/L0640441.mp4 t Transfer: 1220 : 10|09:45:03.1711|70Fih8|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/L0640441.mp4 t Transfer: 1220 : 10|09:45:03.1711|70Fih8|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:45:03.1711|70Fih8|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:45:03.1711|70Fih8|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:45:03.1711|70Fih8|CJPOWERCAST|GetUrl. Storage |Video| filename I:\Video\L0640430.mp4 subfolder t Transfer: 1220 : 10|09:45:03.1711|70Fih8|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/L0640430.mp4 t Transfer: 1220 : 10|09:45:03.1721|70Fih8|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/L0640430.mp4 t Transfer: 1220 : 10|09:45:03.1721|70Fih8|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:45:03.1721|70Fih8|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:45:03.1721|70Fih8|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:45:03.1721|70Fih8|CJPOWERCAST|GetUrl. Storage |PMH Video| filename \\10.46.131.12\Test\NGAM\Folder3\alpha7-1\C0002.MP4 subfolder alpha7-1\ t Transfer: 1220 : 10|09:45:03.1721|70Fih8|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:45:03.1721|70Fih8|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:45:03.1721|70Fih8|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:45:03.1721|70Fih8|CJPOWERCAST|GetUrl. Storage |PMH Video| filename \\10.46.131.12\Test\NGAM\Folder3\alpha7-1\C0003.MP4 subfolder alpha7-1\ t Transfer: 1220 : 10|09:45:03.1721|70Fih8|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:45:03.1731|70Fih8|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:45:03.1731|70Fih8|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:45:03.1731|70Fih8|CJPOWERCAST|GetUrl. Storage |PMH Video| filename \\10.46.131.12\Test\NGAM\Folder3\alpha7-1\C0004.MP4 subfolder alpha7-1\ t Transfer: 1220 : 10|09:45:03.1731|70Fih8|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:45:03.1731|70Fih8|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:45:03.1731|70Fih8|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:45:03.1731|70Fih8|CJPOWERCAST|GetUrl. Storage |PMH Video| filename \\10.46.131.12\Test\NGAM\Folder3\alpha7-1\C0005.MP4 subfolder alpha7-1\ t Transfer: 1220 : 10|09:45:03.1731|70Fih8|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:45:03.1731|70Fih8|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:45:03.1731|70Fih8|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:45:03.1741|70Fih8|CJPOWERCAST|GetUrl. Storage |PMH Video| filename \\10.46.131.12\Test\NGAM\Folder3\alpha7-1\C0007.MP4 subfolder alpha7-1\ t Transfer: 1220 : 10|09:45:03.1741|70Fih8|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:45:03.1741|70Fih8|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:45:03.1741|70Fih8|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:45:03.1741|70Fih8|CJPOWERCAST|GetUrl. Storage |PMH Video| filename \\10.46.131.12\Test\NGAM\Folder3\32b60bce-ad82-46d9-9680-1bc508939215\GH018860.MP4 subfolder 32b60bce-ad82-46d9-9680-1bc508939215\ t Transfer: 1220 : 10|09:45:03.1741|70Fih8|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:45:03.1741|70Fih8|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:45:03.1741|70Fih8|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:45:03.1741|70Fih8|CJPOWERCAST|GetUrl. Storage |PMH Video| filename \\10.46.131.12\Test\NGAM\Folder3\aa6fb5ed-8e69-4268-b8fa-1184664437a0\GH018859.MP4 subfolder aa6fb5ed-8e69-4268-b8fa-1184664437a0\ t Transfer: 1220 : 10|09:45:03.1741|70Fih8|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:45:03.1751|70Fih8|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:45:03.1751|70Fih8|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:45:03.1751|70Fih8|CJPOWERCAST|GetUrl. Storage |PMH Video| filename \\10.46.131.12\Test\NGAM\Folder3\206cf38c-d40c-49e6-b8ed-476b7c369d2c\GH018861.MP4 subfolder 206cf38c-d40c-49e6-b8ed-476b7c369d2c\ t Transfer: 1220 : 10|09:45:03.1751|70Fih8|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:45:03.1751|70Fih8|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:45:03.1751|70Fih8|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:45:03.1751|70Fih8|CJPOWERCAST|GetUrl. Storage |PMH Proxy| filename \\10.46.131.12\Test\NGAM\Folder5\295_2302_M0002105.mp4 subfolder t Transfer: 1220 : 10|09:45:03.1751|70Fih8|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:45:03.1751|70Fih8|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:45:03.1751|70Fih8|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:45:03.1751|70Fih8|CJPOWERCAST|GetUrl. Storage |PMH Proxy| filename \\10.46.131.12\Test\NGAM\Folder5\N0002107.mp4 subfolder t Transfer: 1220 : 10|09:45:03.1761|70Fih8|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:45:03.1761|70Fih8|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:45:03.1761|70Fih8|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:45:03.1761|70Fih8|CJPOWERCAST|GetUrl. Storage |PMH Proxy| filename \\10.46.131.12\Test\NGAM\Folder5\N0002108.mp4 subfolder t Transfer: 1220 : 10|09:45:03.1761|70Fih8|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:45:03.1761|70Fih8|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:45:03.1761|70Fih8|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:45:03.1761|70Fih8|CJPOWERCAST|GetUrl. Storage |PMH Proxy| filename \\10.46.131.12\Test\NGAM\Folder5\GH018860_M0002145.mp4 subfolder t Transfer: 1220 : 10|09:45:03.1761|70Fih8|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:45:03.1761|70Fih8|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:45:03.1771|70Fih8|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:45:03.1771|70Fih8|CJPOWERCAST|GetUrl. Storage |PMH Proxy| filename \\10.46.131.12\Test\NGAM\Folder5\MAXD_1506_M0002267.mp4 subfolder t Transfer: 1220 : 10|09:45:03.1771|70Fih8|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:45:03.1771|70Fih8|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:45:03.1771|70Fih8|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:45:03.1771|70Fih8|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\8DCM000222_OMN0118203335_M0002381.mp4 subfolder t Transfer: 1220 : 10|09:45:03.1771|70Fih8|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/8DCM000222_OMN0118203335_M0002381.mp4 t Transfer: 1220 : 10|09:45:03.1771|70Fih8|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/8DCM000222_OMN0118203335_M0002381.mp4 t Transfer: 1220 : 10|09:45:03.1771|70Fih8|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:45:03.1771|70Fih8|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:45:03.1781|70Fih8|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:45:03.1781|70Fih8|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gots0ep4us.mpd subfolder t Transfer: 1220 : 10|09:45:03.1781|70Fih8|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gots0ep4us.mpd t Transfer: 1220 : 10|09:45:03.1781|70Fih8|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/gots0ep4us.mpd t Transfer: 1220 : 10|09:45:03.1781|70Fih8|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:45:03.1781|70Fih8|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:45:03.1781|70Fih8|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:45:03.1781|70Fih8|CJPOWERCAST|GetUrl. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\SPOC List.xlsx subfolder t Transfer: 1220 : 10|09:45:03.1781|70Fih8|CJPOWERCAST| GetFileName result https://demo.tmd.tv/Temp Upload/SPOC%20List.xlsx t Transfer: 1220 : 10|09:45:03.1791|70Fih8|CJPOWERCAST|GetUrl. result https://demo.tmd.tv/Temp Upload/SPOC%20List.xlsx t Transfer: 1220 : 10|09:45:03.1791|70Fih8|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:45:03.1791|70Fih8|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:45:03.1791|70Fih8|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:45:03.1791|70Fih8|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\snow-game-of-thrones-1200x600.jpg subfolder t Transfer: 1220 : 10|09:45:03.1791|70Fih8|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/snow-game-of-thrones-1200x600.jpg t Transfer: 1220 : 10|09:45:03.1791|70Fih8|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/snow-game-of-thrones-1200x600.jpg t Transfer: 1220 : 10|09:45:03.1791|70Fih8|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:45:03.1791|70Fih8|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:45:03.1791|70Fih8|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:45:03.1801|70Fih8|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\Game_of_Thrones_Still_4.jpg subfolder t Transfer: 1220 : 10|09:45:03.1801|70Fih8|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/Game_of_Thrones_Still_4.jpg t Transfer: 1220 : 10|09:45:03.1801|70Fih8|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/Game_of_Thrones_Still_4.jpg t Transfer: 1220 : 10|09:45:03.1801|70Fih8|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:45:03.1801|70Fih8|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:45:03.1801|70Fih8|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:45:03.1801|70Fih8|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\Game_of_Thrones_Still_4.png subfolder t Transfer: 1220 : 10|09:45:03.1801|70Fih8|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/Game_of_Thrones_Still_4.png t Transfer: 1220 : 10|09:45:03.1801|70Fih8|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/Game_of_Thrones_Still_4.png t Transfer: 1220 : 10|09:45:03.1801|70Fih8|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:45:03.1811|70Fih8|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:45:03.1811|70Fih8|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:45:03.1811|70Fih8|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\game-of-thrones-1349.jpg subfolder t Transfer: 1220 : 10|09:45:03.1811|70Fih8|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/game-of-thrones-1349.jpg t Transfer: 1220 : 10|09:45:03.1811|70Fih8|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/game-of-thrones-1349.jpg t Transfer: 1220 : 10|09:45:03.1811|70Fih8|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:45:03.1811|70Fih8|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:45:03.1811|70Fih8|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:45:03.1811|70Fih8|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\game-of-thrones-daenerys.jpg subfolder t Transfer: 1220 : 10|09:45:03.1811|70Fih8|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/game-of-thrones-daenerys.jpg t Transfer: 1220 : 10|09:45:03.1821|70Fih8|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/game-of-thrones-daenerys.jpg t Transfer: 1220 : 10|09:45:03.1821|70Fih8|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:45:03.1821|70Fih8|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:45:03.1821|70Fih8|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:45:03.1821|70Fih8|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\young cersei game of thrones helen sloan.jpeg.jpg subfolder t Transfer: 1220 : 10|09:45:03.1821|70Fih8|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/young%20cersei%20game%20of%20thrones%20helen%20sloan.jpeg.jpg t Transfer: 1220 : 10|09:45:03.1821|70Fih8|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/young%20cersei%20game%20of%20thrones%20helen%20sloan.jpeg.jpg t Transfer: 1220 : 10|09:45:03.1821|70Fih8|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:45:03.1821|70Fih8|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:45:03.1821|70Fih8|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:45:03.1831|70Fih8|CJPOWERCAST|GetUrl. Storage |VODPublish| filename \\192.168.120.254\DemoFS\Digital Assets\VODPublish\Temp\N0001344.dtd subfolder Temp\ t Transfer: 1220 : 10|09:45:03.1831|70Fih8|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:45:03.1831|70Fih8|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:45:03.1831|70Fih8|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:45:03.1831|70Fih8|CJPOWERCAST|GetUrl. Storage |VODPublish| filename \\192.168.120.254\DemoFS\Digital Assets\VODPublish\Temp\N0001345.xml subfolder Temp\ t Transfer: 1220 : 10|09:45:03.1831|70Fih8|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:45:03.1831|70Fih8|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:45:03.1831|70Fih8|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:45:03.1831|70Fih8|CJPOWERCAST|GetUrl. Storage |VODPublish| filename \\192.168.120.254\DemoFS\Digital Assets\VODPublish\Temp\N0001348.dtd subfolder Temp\ t Transfer: 1220 : 10|09:45:03.1831|70Fih8|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:45:03.1831|70Fih8|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:45:03.1841|70Fih8|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:45:03.1841|70Fih8|CJPOWERCAST|GetUrl. Storage |VODPublish| filename \\192.168.120.254\DemoFS\Digital Assets\VODPublish\Temp\N0001349.xml subfolder Temp\ t Transfer: 1220 : 10|09:45:03.1841|70Fih8|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:45:03.1841|70Fih8|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:45:03.1841|70Fih8|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:45:03.1841|70Fih8|CJPOWERCAST|GetUrl. Storage |Docs| filename I:\Docs\Mediaflex Supported Devices 2v03.pdf subfolder t Transfer: 1220 : 10|09:45:03.1841|70Fih8|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/DocsServer/Mediaflex%20Supported%20Devices%202v03.pdf t Transfer: 1220 : 10|09:45:03.1841|70Fih8|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/DocsServer/Mediaflex%20Supported%20Devices%202v03.pdf t Transfer: 1220 : 10|09:45:03.1841|70Fih8|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:45:03.1841|70Fih8|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:45:03.1851|70Fih8|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:45:03.1851|70Fih8|CJPOWERCAST|GetUrl. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\BBC_graymeta_metadata.json subfolder t Transfer: 1220 : 10|09:45:03.1851|70Fih8|CJPOWERCAST| GetFileName result https://demo.tmd.tv/Temp Upload/BBC_graymeta_metadata.json t Transfer: 1220 : 10|09:45:03.1851|70Fih8|CJPOWERCAST|GetUrl. result https://demo.tmd.tv/Temp Upload/BBC_graymeta_metadata.json t Transfer: 1220 : 10|09:45:03.1851|70Fih8|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:45:03.1851|70Fih8|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:45:03.1851|70Fih8|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:45:03.1851|70Fih8|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Game of Thrones - Blinkbox-HD.mp4 subfolder t Transfer: 1220 : 10|09:45:03.1851|70Fih8|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Game%20of%20Thrones%20-%20Blinkbox-HD.mp4 t Transfer: 1220 : 10|09:45:03.1851|70Fih8|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/Game%20of%20Thrones%20-%20Blinkbox-HD.mp4 t Transfer: 1220 : 10|09:45:03.1861|70Fih8|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:45:03.1861|70Fih8|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:45:03.1861|70Fih8|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:45:03.1861|70Fih8|CJPOWERCAST|GetUrl. Storage |VODPublish| filename \\192.168.120.254\DemoFS\Digital Assets\VODPublish\Temp\N0001343.mp4 subfolder Temp\ t Transfer: 1220 : 10|09:45:03.1861|70Fih8|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:45:03.1861|70Fih8|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:45:03.1861|70Fih8|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:45:03.1861|70Fih8|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gotspecialspromo20seccharacter.mp4 subfolder t Transfer: 1220 : 10|09:45:03.1861|70Fih8|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gotspecialspromo20seccharacter.mp4 t Transfer: 1220 : 10|09:45:03.1861|70Fih8|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/gotspecialspromo20seccharacter.mp4 t Transfer: 1220 : 10|09:45:03.1871|70Fih8|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:45:03.1871|70Fih8|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:45:03.1871|70Fih8|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:45:03.1871|70Fih8|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\gotspecialspromosimage.jpg subfolder t Transfer: 1220 : 10|09:45:03.1871|70Fih8|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/gotspecialspromosimage.jpg t Transfer: 1220 : 10|09:45:03.1871|70Fih8|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/gotspecialspromosimage.jpg t Transfer: 1220 : 10|09:45:03.1871|70Fih8|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:45:03.1871|70Fih8|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:45:03.1871|70Fih8|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:45:03.1871|70Fih8|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\Example 06052020.mp4 subfolder t Transfer: 1220 : 10|09:45:03.1881|70Fih8|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/Example%2006052020.mp4 t Transfer: 1220 : 10|09:45:03.1881|70Fih8|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/Example%2006052020.mp4 t Transfer: 1220 : 10|09:45:03.1881|70Fih8|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:45:03.1881|70Fih8|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:45:03.1881|70Fih8|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:45:03.1881|70Fih8|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gots0ep3us.mpd subfolder t Transfer: 1220 : 10|09:45:03.1881|70Fih8|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gots0ep3us.mpd t Transfer: 1220 : 10|09:45:03.1881|70Fih8|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/gots0ep3us.mpd t Transfer: 1220 : 10|09:45:03.1881|70Fih8|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:45:03.1881|70Fih8|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:45:03.1881|70Fih8|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:45:03.1891|70Fih8|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Example 06052020.mp4 subfolder t Transfer: 1220 : 10|09:45:03.1891|70Fih8|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Example%2006052020.mp4 t Transfer: 1220 : 10|09:45:03.1891|70Fih8|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/Example%2006052020.mp4 t Transfer: 1220 : 10|09:45:03.1891|70Fih8|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:45:03.1891|70Fih8|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:45:03.1891|70Fih8|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:45:03.1891|70Fih8|CJPOWERCAST|GetUrl. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\68add84afa7b\Animation Sample1.mp4 subfolder 68add84afa7b\ t Transfer: 1220 : 10|09:45:03.1891|70Fih8|CJPOWERCAST| GetFileName result https://demo.tmd.tv/Temp Upload/Animation%20Sample1.mp4 t Transfer: 1220 : 10|09:45:03.1891|70Fih8|CJPOWERCAST|GetUrl. result https://demo.tmd.tv/Temp Upload/Animation%20Sample1.mp4 t Transfer: 1220 : 10|09:45:03.1891|70Fih8|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:45:03.1901|70Fih8|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:45:03.1901|70Fih8|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:45:03.1901|70Fih8|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gotspecialspromo10secaction.mp4 subfolder t Transfer: 1220 : 10|09:45:03.1901|70Fih8|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gotspecialspromo10secaction.mp4 t Transfer: 1220 : 10|09:45:03.1901|70Fih8|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/gotspecialspromo10secaction.mp4 t Transfer: 1220 : 10|09:45:03.1901|70Fih8|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:45:03.1901|70Fih8|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:45:03.1901|70Fih8|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:45:03.1901|70Fih8|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gots0ep5us.mpd subfolder t Transfer: 1220 : 10|09:45:03.1901|70Fih8|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gots0ep5us.mpd t Transfer: 1220 : 10|09:45:03.1911|70Fih8|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/gots0ep5us.mpd t Transfer: 1220 : 10|09:45:03.1911|70Fih8|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:45:03.1911|70Fih8|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:45:03.1911|70Fih8|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:45:03.1911|70Fih8|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gots0ep2us.mpd subfolder t Transfer: 1220 : 10|09:45:03.1911|70Fih8|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gots0ep2us.mpd t Transfer: 1220 : 10|09:45:03.1911|70Fih8|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/gots0ep2us.mpd t Transfer: 1220 : 10|09:45:03.1911|70Fih8|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:45:03.1911|70Fih8|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:45:03.1911|70Fih8|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:45:03.1921|70Fih8|CJPOWERCAST|GetUrl. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\cd16270b-696e-4e0b-9a0e-02a00f6c3c8d\2022년_통합인제스트_6월 근무표.xlsx subfolder cd16270b-696e-4e0b-9a0e-02a00f6c3c8d\ t Transfer: 1220 : 10|09:45:03.1921|70Fih8|CJPOWERCAST| GetFileName result https://demo.tmd.tv/Temp Upload/2022%EB%85%84_%ED%86%B5%ED%95%A9%EC%9D%B8%EC%A0%9C%EC%8A%A4%ED%8A%B8_6%EC%9B%94%20%EA%B7%BC%EB%AC%B4%ED%91%9C.xlsx t Transfer: 1220 : 10|09:45:03.1921|70Fih8|CJPOWERCAST|GetUrl. result https://demo.tmd.tv/Temp Upload/2022%EB%85%84_%ED%86%B5%ED%95%A9%EC%9D%B8%EC%A0%9C%EC%8A%A4%ED%8A%B8_6%EC%9B%94%20%EA%B7%BC%EB%AC%B4%ED%91%9C.xlsx t Transfer: 1220 : 10|09:45:03.1921|70Fih8|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:45:03.1921|70Fih8|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:45:03.1921|70Fih8|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:45:03.1921|70Fih8|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Nov Example (16).mp4 subfolder t Transfer: 1220 : 10|09:45:03.1921|70Fih8|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Nov%20Example%20(16).mp4 t Transfer: 1220 : 10|09:45:03.1921|70Fih8|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/Nov%20Example%20(16).mp4 t Transfer: 1220 : 10|09:45:03.1921|70Fih8|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:45:03.1931|70Fih8|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:45:03.1931|70Fih8|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:45:03.1931|70Fih8|CJPOWERCAST|GetUrl. Storage |PMH Video| filename \\10.46.131.12\Test\NGAM\Folder3\0008971.mp4 subfolder t Transfer: 1220 : 10|09:45:03.1931|70Fih8|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:45:03.1931|70Fih8|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:45:03.1931|70Fih8|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|09:45:03.7961|RBjpWW|CJPOWERCAST|OAuth: /api/user-preferences?_dc=1689756303596 t Transfer: 1220 : 10|09:45:03.7961|RBjpWW|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:45:03.7961|RBjpWW|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:45:03.7961|RBjpWW|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:45:03.7961|RBjpWW|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 10|09:45:03.7961|RBjpWW|CJPOWERCAST|StoreUserDataByKeys.. t Transfer: 1220 : 10|09:45:03.7961|RBjpWW|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|09:45:03.7961|RBjpWW|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|09:45:03.7971|RBjpWW|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|09:45:03.7971|RBjpWW|CJPOWERCAST|imfx v3 API took 0.006s '/api/user-preferences?_dc=1689756303596' t Information: 1220 : 10|16:45:28.8370|||OrabitWatcherBasic. Disposing. t Information: 1220 : 10|16:45:28.8370|||OrabitWatcherBasic. Disposed. t Information: 1220 : 10|16:45:28.8370|||========================================================================== t Information: 1220 : 10|16:45:28.8370|||IMFX CORE SERVER APPLICATION END.