t Transfer: 1220 : 12|08:19:37.5500|1QAa3r||OAuth: /api/logout?_dc=1655104777060 t Transfer: 1220 : 12|08:19:37.5510|1QAa3r||GetCurrentUser.. t Transfer: 1220 : 12|08:19:37.5510|1QAa3r|| OAuth authenticated t Verbose: 1220 : 12|08:19:37.5510|1QAa3r|| uid claim is missing.. t Information: 1220 : 12|08:19:37.5510|1QAa3r||OAuth. AutoLogin no Windows identity type WindowsIdentity t Transfer: 1220 : 12|08:19:38.1630|mU7C7p||GetAppInfo. DB: TMDDEMO. Install mode: . Auth types: Native, PublicApiKey t Verbose: 1220 : 12|08:19:38.7660|vk~3z7||imfx v3 API took 0.081s '/api/v3/visual-asset/group/null/2/image' t Verbose: 1220 : 12|08:19:40.5760|GHcY2y||Oauth validating.. t Verbose: 1220 : 12|08:19:40.5760|GHcY2y||GrantResourceOwnerCredentials. t Verbose: 1220 : 12|08:19:40.5760|GHcY2y||LoginUser. cjpowercast, login type OAuth, encrypt password True t Information: 1220 : 12|08:19:40.5760|GHcY2y||TryLoginUser. cjpowercast, login type OAuth, check password True, check hash False, encrypt password True, load user data False t Information: 1220 : 12|08:19:40.9780|GHcY2y|| oauth token 00000000-0000-0000-0000-000000000000 t Information: 1220 : 12|08:19:40.9780|GHcY2y||TryLoginUser. Logged in.. t Information: 1220 : 12|08:19:41.1790|GHcY2y||GetPasswordPolicy. WARNING: Policy not found for system Imediaflex. Validation disabled. t Verbose: 1220 : 12|08:19:41.1790|GHcY2y||LoginUser. Adding history. User Id 1165, result CJPOWERCAST, host 192.168.127.7 t Verbose: 1220 : 12|08:19:41.1790|GHcY2y||GrantResourceOwnerCredentials. Try login finished. Logged: True t Transfer: 1220 : 12|08:19:41.5810|qK~WRf|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=1655104781144 t Transfer: 1220 : 12|08:19:41.5810|qK~WRf|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:19:41.5810|qK~WRf|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:19:41.5810|qK~WRf|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|08:19:41.5810|qK~WRf|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|08:19:41.5810|qK~WRf|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:19:41.5810|qK~WRf|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:19:41.5810|qK~WRf|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|08:19:41.5821|qK~WRf|CJPOWERCAST|imfx v3 API took 0.044s '/api/user-group-preferences?keys=defaultSearchColumnsMedia,defaultSearchColumnsVersion,defaultSearchColumnsSimple,defaultSearchColumnsTitle,defaultSearchMisrDetailsMediaColumns,versionCreationSettings,associate.advanced_search.version.setups,associate.advanced_search.media.setups,associate.wfrise.setups,supplier_portal.advanced_search.version.setups,media_portal.del_history.advanced.search_criteria,supplier_portal.version_complete.setups,logoImage,uploadSettings,helpdeskUrl,customLabels,googleMapsApiSettings&globals=isDebugMode,htmlplayerhotkeys,versionCreationSettings,associate.advanced_search.version.setups,associate.advanced_search.media.setups,associate.wfrise.setups,supplier_portal.advanced_search.version.setups,media_portal.del_history.advanced.search_criteria,helpdeskUrl,customLabels&_dc=1655104781144' t Transfer: 1220 : 12|08:19:41.9840|31mu4o|CJPOWERCAST|OAuth: /api/user-preferences?keys=personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch;workflow_queues_actions;workflow_queues_settings&_dc=1655104781491 t Transfer: 1220 : 12|08:19:41.9840|31mu4o|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:19:41.9840|31mu4o|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:19:41.9840|31mu4o|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|08:19:41.9840|31mu4o|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|08:19:41.9840|31mu4o|CJPOWERCAST|GetUserDataByKeys: personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch;workflow_queues_actions;workflow_queues_settings t Transfer: 1220 : 12|08:19:41.9840|31mu4o|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:19:41.9840|31mu4o|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:19:41.9851|31mu4o|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|08:19:41.9851|31mu4o|CJPOWERCAST|imfx v3 API took 0.039s '/api/user-preferences?keys=personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch;workflow_queues_actions;workflow_queues_settings&_dc=1655104781491' t Information: 1220 : 12|08:19:42.1860|WG2jUs|CJPOWERCAST|GetUserProfile. Id: 0 t Transfer: 1220 : 12|08:19:42.1860|WG2jUs|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:19:42.1860|WG2jUs|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:19:42.1860|WG2jUs|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|08:19:42.5880|aZMiQi|CJPOWERCAST|OAuth: /api/settings/group/0?_dc=1655104782217 t Transfer: 1220 : 12|08:19:42.5880|aZMiQi|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:19:42.5880|aZMiQi|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:19:42.5880|aZMiQi|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|08:19:42.5880|aZMiQi|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|08:19:42.5890|QIN5U9|CJPOWERCAST|OAuth: /api/settings/user/uploadSettings?_dc=1655104782232 t Transfer: 1220 : 12|08:19:42.5890|QIN5U9|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:19:42.5890|QIN5U9|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:19:42.5890|QIN5U9|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|08:19:42.5890|QIN5U9|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|08:19:42.5890|6VODlj|CJPOWERCAST|OAuth: /api/settings/group/0?_dc=1655104782260 t Transfer: 1220 : 12|08:19:42.5890|6VODlj|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:19:42.5901|6VODlj|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:19:42.5901|6VODlj|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|08:19:42.5901|6VODlj|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|08:19:42.7910|QIN5U9|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:19:42.7910|QIN5U9|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:19:42.7910|QIN5U9|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|08:19:42.7910|rG2S86||GetCache. t Information: 1220 : 12|08:19:42.7910|rG2S86||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\201_0_Any_gO.png t Information: 1220 : 12|08:19:42.7910|rG2S86||GetCache. Data read: 0 t Verbose: 1220 : 12|08:19:42.7910|rG2S86||imfx v3 API took 0.140s '/api/v3/visual-asset/group/Any_gO/0/image' t Transfer: 1220 : 12|08:19:42.7910|20gCYj|CJPOWERCAST|OAuth: /api/lookups/MediaStatus?_dc=1655104782273 t Transfer: 1220 : 12|08:19:42.7910|20gCYj|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:19:42.7920|20gCYj|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:19:42.7920|20gCYj|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|08:19:42.7920|20gCYj|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 12|08:19:42.9930|QIN5U9|CJPOWERCAST|imfx v3 API took 0.186s '/api/settings/user/uploadSettings?_dc=1655104782232' t Verbose: 1220 : 12|08:19:42.9930|aZMiQi|CJPOWERCAST|imfx v3 API took 0.303s '/api/settings/group/0?_dc=1655104782217' t Verbose: 1220 : 12|08:19:42.9930|20gCYj|CJPOWERCAST|imfx v3 API took 0.041s '/api/lookups/MediaStatus?_dc=1655104782273' t Verbose: 1220 : 12|08:19:42.9930|6VODlj|CJPOWERCAST|imfx v3 API took 0.169s '/api/settings/group/0?_dc=1655104782260' t Transfer: 1220 : 12|08:19:43.1940|5YolyV|CJPOWERCAST|OAuth: /api/lookup/CustomVersionStatusTypes?_dc=1655104782276 t Transfer: 1220 : 12|08:19:43.1940|5YolyV|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:19:43.1940|5YolyV|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:19:43.1940|5YolyV|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|08:19:43.1940|5YolyV|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|08:19:43.1940|c8vI69|CJPOWERCAST|OAuth: /api/lookups/PgmStatus?_dc=1655104782274 t Transfer: 1220 : 12|08:19:43.1940|c8vI69|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:19:43.1940|c8vI69|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:19:43.1940|c8vI69|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|08:19:43.1950|c8vI69|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|08:19:43.1950|IzYcna|CJPOWERCAST|OAuth: /api/lookup/CustomMediaStatusTypes?_dc=1655104782275 t Transfer: 1220 : 12|08:19:43.1950|IzYcna|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:19:43.1950|IzYcna|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:19:43.1950|IzYcna|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|08:19:43.1950|IzYcna|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 12|08:19:43.1950|c8vI69|CJPOWERCAST|imfx v3 API took 0.000s '/api/lookups/PgmStatus?_dc=1655104782274' t Transfer: 1220 : 12|08:19:43.1950|RJWJtD|CJPOWERCAST|OAuth: /api/lookup/CustomTitleStatusTypes?_dc=1655104782277 t Transfer: 1220 : 12|08:19:43.1950|RJWJtD|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:19:43.1950|RJWJtD|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:19:43.1950|RJWJtD|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|08:19:43.1950|RJWJtD|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 12|08:19:43.1960|5YolyV|CJPOWERCAST|imfx v3 API took 0.023s '/api/lookup/CustomVersionStatusTypes?_dc=1655104782276' t Verbose: 1220 : 12|08:19:43.1960|RJWJtD|CJPOWERCAST|imfx v3 API took 0.021s '/api/lookup/CustomTitleStatusTypes?_dc=1655104782277' t Verbose: 1220 : 12|08:19:43.1960|IzYcna|CJPOWERCAST|imfx v3 API took 0.040s '/api/lookup/CustomMediaStatusTypes?_dc=1655104782275' t Transfer: 1220 : 12|08:19:43.1960|p8QFfQ|CJPOWERCAST|OAuth: /api/settings/user/defaultHomePage?_dc=1655104782278 t Transfer: 1220 : 12|08:19:43.1960|p8QFfQ|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:19:43.1960|p8QFfQ|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:19:43.1960|p8QFfQ|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|08:19:43.1960|p8QFfQ|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|08:19:43.3970|p8QFfQ|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:19:43.3970|p8QFfQ|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:19:43.3970|p8QFfQ|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|08:19:43.3970|p8QFfQ|CJPOWERCAST|imfx v3 API took 0.008s '/api/settings/user/defaultHomePage?_dc=1655104782278' t Information: 1220 : 12|08:19:43.5980|2Dke0x||GetCache. t Information: 1220 : 12|08:19:43.5980|2Dke0x||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\202_1_Any_gO.png t Information: 1220 : 12|08:19:43.5980|2Dke0x||GetCache. Data read: 0 t Verbose: 1220 : 12|08:19:43.5980|2Dke0x||imfx v3 API took 0.004s '/api/v3/visual-asset/group/Any_gO/1/image' t Transfer: 1220 : 12|08:19:44.6030|MMYtad|CJPOWERCAST|OAuth: /api/settings/user/defaultSearch?_dc=1655104784196 t Transfer: 1220 : 12|08:19:44.6030|MMYtad|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:19:44.6030|MMYtad|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:19:44.6030|MMYtad|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|08:19:44.6030|MMYtad|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|08:19:44.6030|pZ9uAA|CJPOWERCAST|OAuth: /api/settings/user/startSearch?_dc=1655104784196 t Transfer: 1220 : 12|08:19:44.6030|pZ9uAA|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:19:44.6030|pZ9uAA|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:19:44.6030|pZ9uAA|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|08:19:44.6030|pZ9uAA|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|08:19:44.6041|MMYtad|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:19:44.6041|MMYtad|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:19:44.6041|MMYtad|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|08:19:44.6041|pZ9uAA|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:19:44.6041|pZ9uAA|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:19:44.6041|pZ9uAA|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|08:19:44.6041|MMYtad|CJPOWERCAST|imfx v3 API took 0.009s '/api/settings/user/defaultSearch?_dc=1655104784196' t Verbose: 1220 : 12|08:19:44.6050|pZ9uAA|CJPOWERCAST|imfx v3 API took 0.014s '/api/settings/user/startSearch?_dc=1655104784196' t Transfer: 1220 : 12|08:19:44.8060|ZRE5mE|CJPOWERCAST|OAuth: /api/user-preferences?keys=consumer.recent.data&_dc=1655104784492 t Transfer: 1220 : 12|08:19:44.8060|ZRE5mE|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:19:44.8060|ZRE5mE|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:19:44.8060|ZRE5mE|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|08:19:44.8060|ZRE5mE|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|08:19:44.8060|ZRE5mE|CJPOWERCAST|GetUserDataByKeys: consumer.recent.data t Transfer: 1220 : 12|08:19:44.8060|ZRE5mE|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:19:44.8060|ZRE5mE|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:19:44.8060|ZRE5mE|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|08:19:45.0070|ZRE5mE|CJPOWERCAST|imfx v3 API took 0.004s '/api/user-preferences?keys=consumer.recent.data&_dc=1655104784492' t Transfer: 1220 : 12|08:19:45.0070|Dmeawp|CJPOWERCAST|OAuth: /api/user-preferences?keys=adv.recent.searches.consumer&_dc=1655104784501 t Transfer: 1220 : 12|08:19:45.0070|Dmeawp|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:19:45.0070|Dmeawp|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:19:45.0070|Dmeawp|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|08:19:45.0070|Dmeawp|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|08:19:45.0070|Dmeawp|CJPOWERCAST|GetUserDataByKeys: adv.recent.searches.consumer t Transfer: 1220 : 12|08:19:45.0070|Dmeawp|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:19:45.0070|Dmeawp|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:19:45.0081|Dmeawp|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|08:19:45.0081|Dmeawp|CJPOWERCAST|imfx v3 API took 0.006s '/api/user-preferences?keys=adv.recent.searches.consumer&_dc=1655104784501' t Information: 1220 : 12|08:19:45.0081|5NUVGu||GetCache. t Information: 1220 : 12|08:19:45.0081|5NUVGu||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\204_3_Any_gO.png t Information: 1220 : 12|08:19:45.0081|5NUVGu||GetCache. Data read: 5504 t Verbose: 1220 : 12|08:19:45.0081|5NUVGu||imfx v3 API took 0.004s '/api/v3/visual-asset/group/Any_gO/3/image' t Transfer: 1220 : 12|08:19:56.6660|PeybHS|CJPOWERCAST|OAuth: /api/settings/user/consumer?_dc=1655104796333 t Transfer: 1220 : 12|08:19:56.6660|PeybHS|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:19:56.6660|PeybHS|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:19:56.6660|PeybHS|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|08:19:56.6660|PeybHS|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|08:19:56.6660|PeybHS|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:19:56.6671|PeybHS|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:19:56.6671|PeybHS|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|08:19:56.8680|PeybHS|CJPOWERCAST|imfx v3 API took 0.009s '/api/settings/user/consumer?_dc=1655104796333' t Transfer: 1220 : 12|08:19:56.8680|3YitVL|CJPOWERCAST|OAuth: /api/unifiedsearch/?_dc=1655104796404 t Transfer: 1220 : 12|08:19:56.8680|3YitVL|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:19:56.8680|3YitVL|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:19:56.8680|3YitVL|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|08:19:56.8680|3YitVL|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|08:19:56.8680|4vyFgF|CJPOWERCAST|OAuth: /api/user-preferences?keys=consumer.recent.data&_dc=1655104796405 t Transfer: 1220 : 12|08:19:56.8680|4vyFgF|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:19:56.8680|4vyFgF|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:19:56.8690|4vyFgF|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|08:19:56.8690|4vyFgF|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|08:19:56.8690|4vyFgF|CJPOWERCAST|GetUserDataByKeys: consumer.recent.data t Transfer: 1220 : 12|08:19:56.8690|4vyFgF|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:19:56.8690|4vyFgF|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:19:56.8690|4vyFgF|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|08:19:56.8690|4vyFgF|CJPOWERCAST|imfx v3 API took 0.006s '/api/user-preferences?keys=consumer.recent.data&_dc=1655104796405' t Transfer: 1220 : 12|08:19:57.0700|3YitVL|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:19:57.0700|3YitVL|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:19:57.0700|3YitVL|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|08:19:57.0700|3YitVL|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:19:57.0700|3YitVL|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:19:57.0710|3YitVL|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|08:19:57.4730|3YitVL|CJPOWERCAST|Running solr search: [q, (((title:(*mh))^2 OR series:(*mh) OR (titleMergedNgram:*mh*)^10 OR versionid1:(*mh) OR progid1:(*mh)) AND deleted_flag:(0) AND (owners:((SFP2) OR (PSP) OR (PMS) OR (SFP1) OR (PMH) OR (PPL))))] t Information: 1220 : 12|08:19:57.4730|3YitVL|CJPOWERCAST|Solr query returned: 27 in 6ms t Information: 1220 : 12|08:19:57.4730|3YitVL|CJPOWERCAST|SearchVersion SQL: select * from (select a.*, rownum rnum from ( select m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE ,(select cast(substr(text_data_plain, 1,2000) as varchar2(2000)) from tm_txt_obj where type_id=5021083 and pgm_rl_id=m.id and rownum=1) SYNOPSIS ,(select m_ctnr_loc || '^' || m_ctnr_id from tm_mis mis join tm_cfg_media_file_types t on t.id=mis.m_ctnr_fmt_id and t.imfx_disable_playback<>1 where mis.pgm_parent_id=m.id /*and mis.m_ctnr_fmt_id in (2,4,54,52,98,57,62)*/ and mis.item_type>0 and mis.mi_deleted=0 and mis.media_type=100 and not mis.m_ctnr_id is null and mis.m_ctnr_loc is not null and rownum=1) PROXY_MEDIA, (select cvt.ID from TM_PORTAL_VERSION_CONFIG cvt where m.CUSTOM_VERSION_TYPE = cvt.CUSTOM_VERSION_TYPE AND cvt.CUSTOM_VERSION_TYPE IS NOT NULL ) MP_CONFIG_ID from tmddba.tm_pg_rl m left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id,(select /*+ cardinality(4) */ rownum rn, column_value id from table(:ids)) ids where item_type>0 and rl_deleted=0 and m.id = ids.id order by ids.rn ) a where rownum <= 10000) r where rnum >=1 order by rnum t Information: 1220 : 12|08:19:57.6740|3YitVL|CJPOWERCAST|Running version search. User: 1165 Simple Search: *MH Trying to use Solr Search... Solr completed in: 424ms. Returned lines: 27 Running Oracle search. Oracle version search timing: 206ms. SQL run: select * from (select a.*, rownum rnum from ( select m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE ,(select cast(substr(text_data_plain, 1,2000) as varchar2(2000)) from tm_txt_obj where type_id=5021083 and pgm_rl_id=m.id and rownum=1) SYNOPSIS ,(select m_ctnr_loc || '^' || m_ctnr_id from tm_mis mis join tm_cfg_media_file_types t on t.id=mis.m_ctnr_fmt_id and t.imfx_disable_playback<>1 where mis.pgm_parent_id=m.id /*and mis.m_ctnr_fmt_id in (2,4,54,52,98,57,62)*/ and mis.item_type>0 and mis.mi_deleted=0 and mis.media_type=100 and not mis.m_ctnr_id is null and mis.m_ctnr_loc is not null and rownum=1) PROXY_MEDIA, (select cvt.ID from TM_PORTAL_VERSION_CONFIG cvt where m.CUSTOM_VERSION_TYPE = cvt.CUSTOM_VERSION_TYPE AND cvt.CUSTOM_VERSION_TYPE IS NOT NULL ) MP_CONFIG_ID from tmddba.tm_pg_rl m left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id,(select /*+ cardinality(4) */ rownum rn, column_value id from table(:ids)) ids where item_type>0 and rl_deleted=0 and m.id = ids.id order by ids.rn ) a where rownum <= 10000) r where rnum >=1 order by rnum t Transfer: 1220 : 12|08:19:57.6740|3YitVL|CJPOWERCAST|GetUrl. Storage |PMH Isilon Import Folder| filename \\10.46.131.12\Test\NGAM\Folder7\Pedro_Segm_test001.mp4 subfolder t Transfer: 1220 : 12|08:19:57.6740|3YitVL|CJPOWERCAST|GetUrl. Storage |PMH Proxy| filename \\10.46.131.12\Test\NGAM\Folder5\Pedro_All_tech001_M0002177.mp4 subfolder t Transfer: 1220 : 12|08:19:57.6740|3YitVL|CJPOWERCAST|GetUrl. Storage |PMH Video| filename \\10.46.131.12\Test\NGAM\Folder3\Pedro_Segm_test005.mp4 subfolder t Transfer: 1220 : 12|08:19:57.6740|3YitVL|CJPOWERCAST|GetUrl. Storage |PMH Proxy| filename \\10.46.131.12\Test\NGAM\Folder5\Pedro_Segm_test007_M0002169.mp4 subfolder t Transfer: 1220 : 12|08:19:57.6740|3YitVL|CJPOWERCAST|GetUrl. Storage |PMH Proxy| filename \\10.46.131.12\Test\NGAM\Folder5\0154300FRHDP60_01MappedTest_M0002283.mp4 subfolder t Transfer: 1220 : 12|08:19:57.6740|3YitVL|CJPOWERCAST|GetUrl. Storage |PMH Images| filename \\10.46.131.12\Test\NGAM\Folder4\0154300NLM01.mp4 subfolder t Transfer: 1220 : 12|08:19:57.6740|3YitVL|CJPOWERCAST|GetUrl. Storage |PMH Video| filename \\10.46.131.12\Test\NGAM\Folder3\alpha7-1\C0002.MP4 subfolder t Transfer: 1220 : 12|08:19:57.6750|3YitVL|CJPOWERCAST|GetUrl. Storage |PMH Proxy| filename \\10.46.131.12\Test\NGAM\Folder5\295_2302_M0002105.mp4 subfolder t Transfer: 1220 : 12|08:19:57.6750|3YitVL|CJPOWERCAST|GetUrl. Storage |PMH Proxy| filename \\10.46.131.12\Test\NGAM\Folder5\GH018860_M0002145.mp4 subfolder t Transfer: 1220 : 12|08:19:57.6750|3YitVL|CJPOWERCAST|GetUrl. Storage |PMH Proxy| filename \\10.46.131.12\Test\NGAM\Folder5\0154300FRHDP60_01WorkflowTest2_M0002063.mp4 subfolder t Transfer: 1220 : 12|08:19:57.6750|3YitVL|CJPOWERCAST|GetUrl. Storage |PMH Proxy| filename \\10.46.131.12\Test\NGAM\Folder5\0154300NLHDP60_01_APIchangetest_M0002084.mp4 subfolder t Transfer: 1220 : 12|08:19:57.6750|3YitVL|CJPOWERCAST|GetUrl. Storage |PMH Proxy| filename \\10.46.131.12\Test\NGAM\Folder5\0154300FRHDP60_02_WorkflowTest_M0002062.mp4 subfolder t Verbose: 1220 : 12|08:19:57.6750|3YitVL|CJPOWERCAST|imfx v3 API took 0.672s '/api/unifiedsearch/?_dc=1655104796404' t Transfer: 1220 : 12|08:19:58.0770|CxRWRF|CJPOWERCAST|OAuth: /api/user-preferences?keys=adv.recent.searches.consumer&_dc=1655104797636 t Transfer: 1220 : 12|08:19:58.0770|CxRWRF|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:19:58.0770|CxRWRF|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:19:58.0770|CxRWRF|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|08:19:58.0770|CxRWRF|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|08:19:58.0770|CxRWRF|CJPOWERCAST|GetUserDataByKeys: adv.recent.searches.consumer t Transfer: 1220 : 12|08:19:58.0770|CxRWRF|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:19:58.0770|CxRWRF|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:19:58.0770|CxRWRF|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|08:19:58.0770|CxRWRF|CJPOWERCAST|imfx v3 API took 0.004s '/api/user-preferences?keys=adv.recent.searches.consumer&_dc=1655104797636' t Transfer: 1220 : 12|08:19:58.0780|ImQinE|CJPOWERCAST|OAuth: /api/user-preferences?_dc=1655104797745 t Transfer: 1220 : 12|08:19:58.0780|ImQinE|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:19:58.0780|ImQinE|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:19:58.0780|ImQinE|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|08:19:58.0780|ImQinE|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 12|08:19:58.0780|ImQinE|CJPOWERCAST|StoreUserDataByKeys.. t Transfer: 1220 : 12|08:19:58.0780|ImQinE|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:19:58.0780|ImQinE|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:19:58.0780|ImQinE|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|08:19:58.2791|ImQinE|CJPOWERCAST|imfx v3 API took 0.037s '/api/user-preferences?_dc=1655104797745' t Transfer: 1220 : 12|08:20:14.1581|Dy9m2E|CJPOWERCAST|OAuth: /api/user-preferences?keys=adv.recent.searches.media&_dc=1655104813756 t Transfer: 1220 : 12|08:20:14.1581|Dy9m2E|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:14.1581|Dy9m2E|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:14.1581|Dy9m2E|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|08:20:14.1581|Dy9m2E|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|08:20:14.1581|XLHKX1|CJPOWERCAST|OAuth: /api/lookups/SearchSupportedOperators?_dc=1655104813754 t Transfer: 1220 : 12|08:20:14.1591|XLHKX1|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:14.1591|XLHKX1|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:14.1591|XLHKX1|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|08:20:14.1591|XLHKX1|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|08:20:14.1591|Dy9m2E|CJPOWERCAST|GetUserDataByKeys: adv.recent.searches.media t Transfer: 1220 : 12|08:20:14.1591|Dy9m2E|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:14.1591|Dy9m2E|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:14.1600|Dy9m2E|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|08:20:14.1600|XLHKX1|CJPOWERCAST|imfx v3 API took 0.000s '/api/lookups/SearchSupportedOperators?_dc=1655104813754' t Transfer: 1220 : 12|08:20:14.1600|rrgFJK|CJPOWERCAST|OAuth: /api/view/searchinfo/Media?_dc=1655104813753 t Transfer: 1220 : 12|08:20:14.1600|rrgFJK|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:14.1600|rrgFJK|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:14.1600|rrgFJK|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|08:20:14.1600|rrgFJK|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 12|08:20:14.1600|Dy9m2E|CJPOWERCAST|imfx v3 API took 0.007s '/api/user-preferences?keys=adv.recent.searches.media&_dc=1655104813756' t Information: 1220 : 12|08:20:14.1610|rrgFJK|CJPOWERCAST|GetAdvSearchColumns. search type Media grid . t Verbose: 1220 : 12|08:20:14.1610|rrgFJK|CJPOWERCAST|imfx v3 API took 0.001s '/api/view/searchinfo/Media?_dc=1655104813753' t Transfer: 1220 : 12|08:20:14.1610|TtDiJV|CJPOWERCAST|OAuth: /api/view/searches/Media?_dc=1655104813813 t Transfer: 1220 : 12|08:20:14.1610|TtDiJV|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:14.1610|TtDiJV|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:14.1610|TtDiJV|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|08:20:14.1610|TtDiJV|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|08:20:14.1610|1MkUjA|CJPOWERCAST|OAuth: /api/view/info/MediaGrid?lang=en-GB&_dc=1655104813816 t Transfer: 1220 : 12|08:20:14.1610|1MkUjA|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:14.1610|1MkUjA|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:14.1610|1MkUjA|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|08:20:14.1610|1MkUjA|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|08:20:14.1610|2oQS1j|CJPOWERCAST|OAuth: /api/settings/user/searchLayoutConfig?_dc=1655104813817 t Transfer: 1220 : 12|08:20:14.1610|2oQS1j|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:14.1610|2oQS1j|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:14.1610|2oQS1j|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|08:20:14.1610|2oQS1j|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|08:20:14.1624|TtDiJV|CJPOWERCAST|GetSavedSearchNames. search type Media. t Transfer: 1220 : 12|08:20:14.1624|TtDiJV|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:14.1624|TtDiJV|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:14.1624|TtDiJV|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|08:20:14.1624|2oQS1j|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:14.1630|2oQS1j|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:14.1630|2oQS1j|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|08:20:14.1630|1MkUjA|CJPOWERCAST|GetGridViewBuilder. builder type MediaGrid. t Transfer: 1220 : 12|08:20:14.1630|1MkUjA|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:14.1630|1MkUjA|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:14.1630|1MkUjA|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|08:20:14.1630|2oQS1j|CJPOWERCAST|imfx v3 API took 0.009s '/api/settings/user/searchLayoutConfig?_dc=1655104813817' t Information: 1220 : 12|08:20:14.1640|1MkUjA|CJPOWERCAST|UserGridView. LoadView. ID -2, Name Default. t Transfer: 1220 : 12|08:20:14.1640|1MkUjA|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:14.1640|1MkUjA|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:14.1640|1MkUjA|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|08:20:14.3650|TtDiJV|CJPOWERCAST|imfx v3 API took 0.045s '/api/view/searches/Media?_dc=1655104813813' t Transfer: 1220 : 12|08:20:14.3650|1MkUjA|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:14.3650|1MkUjA|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:14.3650|1MkUjA|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|08:20:14.3650|1MkUjA|CJPOWERCAST|imfx v3 API took 0.075s '/api/view/info/MediaGrid?lang=en-GB&_dc=1655104813816' t Transfer: 1220 : 12|08:20:21.6010|5QvC~6|CJPOWERCAST|OAuth: /api/v3/search/Media?_dc=1655104821124 t Transfer: 1220 : 12|08:20:21.6010|5QvC~6|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:21.6010|5QvC~6|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:21.6010|5QvC~6|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|08:20:21.6010|5QvC~6|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|08:20:21.6010|5QvC~6|CJPOWERCAST|V3Api.SearchMedia t Information: 1220 : 12|08:20:21.6010|5QvC~6|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|08:20:21.6010|5QvC~6|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:21.6010|5QvC~6|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:21.6020|5QvC~6|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|08:20:21.6020|5QvC~6|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 : 12|08:20:21.8030|5QvC~6|CJPOWERCAST|Solr query returned: 332 in 80ms t Information: 1220 : 12|08:20:21.8030|5QvC~6|CJPOWERCAST|MediaSearch SQL: select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type in (1,110)),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , (SELECT SUBSTR( trim( replace (replace ( LISTAGG(trim(tt.tags || ' ' || tt.notes), ' ') WITHIN GROUP (ORDER BY trim(tt.tags || ' ' || tt.notes)), chr (13), ''), chr (10), ' ')), 1, 150) z FROM tm_media_tagging tt WHERE link_guid = DFILE_LINK_GUID and rownum=1) TAGS_TEXT , GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select a.*, rownum rnum from (select m.*, coalesce(m.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=m.pgm_parent_id)) primary_thumb_id2 from tmddba.tm_mis m ,(select /*+ cardinality(4) */ rownum rn, column_value id from table(:ids)) ids where m.id = ids.id order by ids.rn ) a where rownum <= 10000) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl where rnum >= 1 order by rnum t Information: 1220 : 12|08:20:22.0040|5QvC~6|CJPOWERCAST| timing: 00:00:00.4937237 t Verbose: 1220 : 12|08:20:22.0040|5QvC~6|CJPOWERCAST|imfx v3 API took 0.544s '/api/v3/search/Media?_dc=1655104821124' t Transfer: 1220 : 12|08:20:22.4060|5QvC~6|CJPOWERCAST|GetUrl. Storage |Video| filename I:\Video\L0640441.mp4 subfolder t Transfer: 1220 : 12|08:20:22.4060|5QvC~6|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/L0640441.mp4 t Transfer: 1220 : 12|08:20:22.4060|5QvC~6|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/L0640441.mp4 t Transfer: 1220 : 12|08:20:22.4060|5QvC~6|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:22.4060|5QvC~6|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:22.4060|5QvC~6|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|08:20:22.4060|5QvC~6|CJPOWERCAST|GetUrl. Storage |Video| filename I:\Video\L0640430.mp4 subfolder t Transfer: 1220 : 12|08:20:22.4060|5QvC~6|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/L0640430.mp4 t Transfer: 1220 : 12|08:20:22.4060|5QvC~6|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/L0640430.mp4 t Transfer: 1220 : 12|08:20:22.4070|5QvC~6|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:22.4070|5QvC~6|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:22.4070|5QvC~6|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|08:20:22.4070|5QvC~6|CJPOWERCAST|GetUrl. Storage |PMH Video| filename \\10.46.131.12\Test\NGAM\Folder3\alpha7-1\C0002.MP4 subfolder alpha7-1\ t Transfer: 1220 : 12|08:20:22.4070|5QvC~6|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:22.4070|5QvC~6|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:22.4070|5QvC~6|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|08:20:22.4070|5QvC~6|CJPOWERCAST|GetUrl. Storage |PMH Video| filename \\10.46.131.12\Test\NGAM\Folder3\alpha7-1\C0003.MP4 subfolder alpha7-1\ t Transfer: 1220 : 12|08:20:22.4070|5QvC~6|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:22.4070|5QvC~6|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:22.4070|5QvC~6|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|08:20:22.4070|5QvC~6|CJPOWERCAST|GetUrl. Storage |PMH Video| filename \\10.46.131.12\Test\NGAM\Folder3\alpha7-1\C0004.MP4 subfolder alpha7-1\ t Transfer: 1220 : 12|08:20:22.4080|5QvC~6|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:22.4080|5QvC~6|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:22.4080|5QvC~6|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|08:20:22.4080|5QvC~6|CJPOWERCAST|GetUrl. Storage |PMH Video| filename \\10.46.131.12\Test\NGAM\Folder3\alpha7-1\C0005.MP4 subfolder alpha7-1\ t Transfer: 1220 : 12|08:20:22.4080|5QvC~6|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:22.4080|5QvC~6|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:22.4080|5QvC~6|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|08:20:22.4080|5QvC~6|CJPOWERCAST|GetUrl. Storage |PMH Video| filename \\10.46.131.12\Test\NGAM\Folder3\alpha7-1\C0007.MP4 subfolder alpha7-1\ t Transfer: 1220 : 12|08:20:22.4080|5QvC~6|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:22.4080|5QvC~6|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:22.4080|5QvC~6|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|08:20:22.4090|5QvC~6|CJPOWERCAST|GetUrl. Storage |PMH Video| filename \\10.46.131.12\Test\NGAM\Folder3\32b60bce-ad82-46d9-9680-1bc508939215\GH018860.MP4 subfolder 32b60bce-ad82-46d9-9680-1bc508939215\ t Transfer: 1220 : 12|08:20:22.4090|5QvC~6|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:22.4090|5QvC~6|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:22.4090|5QvC~6|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|08:20:22.4090|5QvC~6|CJPOWERCAST|GetUrl. Storage |PMH Video| filename \\10.46.131.12\Test\NGAM\Folder3\aa6fb5ed-8e69-4268-b8fa-1184664437a0\GH018859.MP4 subfolder aa6fb5ed-8e69-4268-b8fa-1184664437a0\ t Transfer: 1220 : 12|08:20:22.4090|5QvC~6|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:22.4090|5QvC~6|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:22.4090|5QvC~6|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|08:20:22.4090|5QvC~6|CJPOWERCAST|GetUrl. Storage |PMH Video| filename \\10.46.131.12\Test\NGAM\Folder3\206cf38c-d40c-49e6-b8ed-476b7c369d2c\GH018861.MP4 subfolder 206cf38c-d40c-49e6-b8ed-476b7c369d2c\ t Transfer: 1220 : 12|08:20:22.4090|5QvC~6|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:22.4090|5QvC~6|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:22.4090|5QvC~6|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|08:20:22.4100|5QvC~6|CJPOWERCAST|GetUrl. Storage |PMH Proxy| filename \\10.46.131.12\Test\NGAM\Folder5\295_2302_M0002105.mp4 subfolder t Transfer: 1220 : 12|08:20:22.4100|5QvC~6|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:22.4100|5QvC~6|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:22.4100|5QvC~6|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|08:20:22.4100|5QvC~6|CJPOWERCAST|GetUrl. Storage |PMH Proxy| filename \\10.46.131.12\Test\NGAM\Folder5\N0002107.mp4 subfolder t Transfer: 1220 : 12|08:20:22.4100|5QvC~6|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:22.4100|5QvC~6|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:22.4100|5QvC~6|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|08:20:22.4100|5QvC~6|CJPOWERCAST|GetUrl. Storage |PMH Proxy| filename \\10.46.131.12\Test\NGAM\Folder5\N0002108.mp4 subfolder t Transfer: 1220 : 12|08:20:22.4100|5QvC~6|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:22.4100|5QvC~6|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:22.4100|5QvC~6|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|08:20:22.4110|5QvC~6|CJPOWERCAST|GetUrl. Storage |PMH Proxy| filename \\10.46.131.12\Test\NGAM\Folder5\GH018860_M0002145.mp4 subfolder t Transfer: 1220 : 12|08:20:22.4110|5QvC~6|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:22.4110|5QvC~6|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:22.4110|5QvC~6|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|08:20:22.4110|5QvC~6|CJPOWERCAST|GetUrl. Storage |PMH Proxy| filename \\10.46.131.12\Test\NGAM\Folder5\MAXD_1506_M0002267.mp4 subfolder t Transfer: 1220 : 12|08:20:22.4110|5QvC~6|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:22.4110|5QvC~6|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:22.4110|5QvC~6|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|08:20:22.4110|5QvC~6|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gots0ep4us.mpd subfolder t Transfer: 1220 : 12|08:20:22.4110|5QvC~6|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gots0ep4us.mpd t Transfer: 1220 : 12|08:20:22.4110|5QvC~6|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/gots0ep4us.mpd t Transfer: 1220 : 12|08:20:22.4120|5QvC~6|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:22.4120|5QvC~6|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:22.4120|5QvC~6|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|08:20:22.4120|5QvC~6|CJPOWERCAST|GetUrl. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\SPOC List.xlsx subfolder t Transfer: 1220 : 12|08:20:22.4120|5QvC~6|CJPOWERCAST| GetFileName result https://demo.tmd.tv/Temp Upload/SPOC%20List.xlsx t Transfer: 1220 : 12|08:20:22.4120|5QvC~6|CJPOWERCAST|GetUrl. result https://demo.tmd.tv/Temp Upload/SPOC%20List.xlsx t Transfer: 1220 : 12|08:20:22.4120|5QvC~6|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:22.4120|5QvC~6|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:22.4120|5QvC~6|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|08:20:22.4120|5QvC~6|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\snow-game-of-thrones-1200x600.jpg subfolder t Transfer: 1220 : 12|08:20:22.4120|5QvC~6|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/snow-game-of-thrones-1200x600.jpg t Transfer: 1220 : 12|08:20:22.4120|5QvC~6|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/snow-game-of-thrones-1200x600.jpg t Transfer: 1220 : 12|08:20:22.4130|5QvC~6|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:22.4130|5QvC~6|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:22.4130|5QvC~6|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|08:20:22.4130|5QvC~6|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\Game_of_Thrones_Still_4.jpg subfolder t Transfer: 1220 : 12|08:20:22.4130|5QvC~6|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/Game_of_Thrones_Still_4.jpg t Transfer: 1220 : 12|08:20:22.4130|5QvC~6|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/Game_of_Thrones_Still_4.jpg t Transfer: 1220 : 12|08:20:22.4130|5QvC~6|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:22.4130|5QvC~6|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:22.4130|5QvC~6|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|08:20:22.4130|5QvC~6|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\Game_of_Thrones_Still_4.png subfolder t Transfer: 1220 : 12|08:20:22.4130|5QvC~6|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/Game_of_Thrones_Still_4.png t Transfer: 1220 : 12|08:20:22.4140|5QvC~6|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/Game_of_Thrones_Still_4.png t Transfer: 1220 : 12|08:20:22.4140|5QvC~6|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:22.4140|5QvC~6|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:22.4140|5QvC~6|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|08:20:22.4140|5QvC~6|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\game-of-thrones-1349.jpg subfolder t Transfer: 1220 : 12|08:20:22.4140|5QvC~6|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/game-of-thrones-1349.jpg t Transfer: 1220 : 12|08:20:22.4140|5QvC~6|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/game-of-thrones-1349.jpg t Transfer: 1220 : 12|08:20:22.4140|5QvC~6|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:22.4140|5QvC~6|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:22.4140|5QvC~6|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|08:20:22.4140|5QvC~6|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\game-of-thrones-daenerys.jpg subfolder t Transfer: 1220 : 12|08:20:22.4140|5QvC~6|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/game-of-thrones-daenerys.jpg t Transfer: 1220 : 12|08:20:22.4150|5QvC~6|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/game-of-thrones-daenerys.jpg t Transfer: 1220 : 12|08:20:22.4150|5QvC~6|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:22.4150|5QvC~6|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:22.4150|5QvC~6|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|08:20:22.4150|5QvC~6|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\young cersei game of thrones helen sloan.jpeg.jpg subfolder t Transfer: 1220 : 12|08:20:22.4150|5QvC~6|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/young%20cersei%20game%20of%20thrones%20helen%20sloan.jpeg.jpg t Transfer: 1220 : 12|08:20:22.4150|5QvC~6|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/young%20cersei%20game%20of%20thrones%20helen%20sloan.jpeg.jpg t Transfer: 1220 : 12|08:20:22.4150|5QvC~6|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:22.4161|5QvC~6|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:22.4161|5QvC~6|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|08:20:22.4161|5QvC~6|CJPOWERCAST|GetUrl. Storage |VODPublish| filename \\192.168.120.254\DemoFS\Digital Assets\VODPublish\Temp\N0001344.dtd subfolder Temp\ t Transfer: 1220 : 12|08:20:22.4161|5QvC~6|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:22.4161|5QvC~6|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:22.4161|5QvC~6|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|08:20:22.4161|5QvC~6|CJPOWERCAST|GetUrl. Storage |VODPublish| filename \\192.168.120.254\DemoFS\Digital Assets\VODPublish\Temp\N0001345.xml subfolder Temp\ t Transfer: 1220 : 12|08:20:22.4161|5QvC~6|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:22.4170|5QvC~6|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:22.4170|5QvC~6|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|08:20:22.4170|5QvC~6|CJPOWERCAST|GetUrl. Storage |VODPublish| filename \\192.168.120.254\DemoFS\Digital Assets\VODPublish\Temp\N0001348.dtd subfolder Temp\ t Transfer: 1220 : 12|08:20:22.4170|5QvC~6|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:22.4170|5QvC~6|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:22.4170|5QvC~6|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|08:20:22.4170|5QvC~6|CJPOWERCAST|GetUrl. Storage |VODPublish| filename \\192.168.120.254\DemoFS\Digital Assets\VODPublish\Temp\N0001349.xml subfolder Temp\ t Transfer: 1220 : 12|08:20:22.4170|5QvC~6|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:22.4180|5QvC~6|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:22.4180|5QvC~6|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|08:20:22.4180|5QvC~6|CJPOWERCAST|GetUrl. Storage |Docs| filename I:\Docs\Mediaflex Supported Devices 2v03.pdf subfolder t Transfer: 1220 : 12|08:20:22.4180|5QvC~6|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/DocsServer/Mediaflex%20Supported%20Devices%202v03.pdf t Transfer: 1220 : 12|08:20:22.4180|5QvC~6|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/DocsServer/Mediaflex%20Supported%20Devices%202v03.pdf t Transfer: 1220 : 12|08:20:22.4180|5QvC~6|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:22.4180|5QvC~6|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:22.4190|5QvC~6|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|08:20:22.4190|5QvC~6|CJPOWERCAST|GetUrl. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\BBC_graymeta_metadata.json subfolder t Transfer: 1220 : 12|08:20:22.4190|5QvC~6|CJPOWERCAST| GetFileName result https://demo.tmd.tv/Temp Upload/BBC_graymeta_metadata.json t Transfer: 1220 : 12|08:20:22.4190|5QvC~6|CJPOWERCAST|GetUrl. result https://demo.tmd.tv/Temp Upload/BBC_graymeta_metadata.json t Transfer: 1220 : 12|08:20:22.4190|5QvC~6|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:22.4190|5QvC~6|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:22.4190|5QvC~6|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|08:20:22.4200|5QvC~6|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Game of Thrones - Blinkbox-HD.mp4 subfolder t Transfer: 1220 : 12|08:20:22.4200|5QvC~6|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Game%20of%20Thrones%20-%20Blinkbox-HD.mp4 t Transfer: 1220 : 12|08:20:22.4200|5QvC~6|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/Game%20of%20Thrones%20-%20Blinkbox-HD.mp4 t Transfer: 1220 : 12|08:20:22.4200|5QvC~6|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:22.4200|5QvC~6|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:22.4200|5QvC~6|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|08:20:22.4200|5QvC~6|CJPOWERCAST|GetUrl. Storage |VODPublish| filename \\192.168.120.254\DemoFS\Digital Assets\VODPublish\Temp\N0001343.mp4 subfolder Temp\ t Transfer: 1220 : 12|08:20:22.4200|5QvC~6|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:22.4210|5QvC~6|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:22.4210|5QvC~6|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|08:20:22.4210|5QvC~6|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gotspecialspromo20seccharacter.mp4 subfolder t Transfer: 1220 : 12|08:20:22.4210|5QvC~6|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gotspecialspromo20seccharacter.mp4 t Transfer: 1220 : 12|08:20:22.4210|5QvC~6|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/gotspecialspromo20seccharacter.mp4 t Transfer: 1220 : 12|08:20:22.4210|5QvC~6|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:22.4220|5QvC~6|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:22.4220|5QvC~6|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|08:20:22.4220|5QvC~6|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\gotspecialspromosimage.jpg subfolder t Transfer: 1220 : 12|08:20:22.4220|5QvC~6|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/gotspecialspromosimage.jpg t Transfer: 1220 : 12|08:20:22.4220|5QvC~6|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/gotspecialspromosimage.jpg t Transfer: 1220 : 12|08:20:22.4220|5QvC~6|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:22.4220|5QvC~6|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:22.4220|5QvC~6|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|08:20:22.4230|5QvC~6|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\Example 06052020.mp4 subfolder t Transfer: 1220 : 12|08:20:22.4230|5QvC~6|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/Example%2006052020.mp4 t Transfer: 1220 : 12|08:20:22.4230|5QvC~6|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/Example%2006052020.mp4 t Transfer: 1220 : 12|08:20:22.4230|5QvC~6|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:22.4230|5QvC~6|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:22.4230|5QvC~6|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|08:20:22.4230|5QvC~6|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gots0ep3us.mpd subfolder t Transfer: 1220 : 12|08:20:22.4240|5QvC~6|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gots0ep3us.mpd t Transfer: 1220 : 12|08:20:22.4240|5QvC~6|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/gots0ep3us.mpd t Transfer: 1220 : 12|08:20:22.4240|5QvC~6|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:22.4240|5QvC~6|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:22.4240|5QvC~6|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|08:20:22.4240|5QvC~6|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Example 06052020.mp4 subfolder t Transfer: 1220 : 12|08:20:22.4240|5QvC~6|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Example%2006052020.mp4 t Transfer: 1220 : 12|08:20:22.4250|5QvC~6|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/Example%2006052020.mp4 t Transfer: 1220 : 12|08:20:22.4250|5QvC~6|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:22.4250|5QvC~6|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:22.4250|5QvC~6|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|08:20:22.4250|5QvC~6|CJPOWERCAST|GetUrl. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\68add84afa7b\Animation Sample1.mp4 subfolder 68add84afa7b\ t Transfer: 1220 : 12|08:20:22.4250|5QvC~6|CJPOWERCAST| GetFileName result https://demo.tmd.tv/Temp Upload/Animation%20Sample1.mp4 t Transfer: 1220 : 12|08:20:22.4250|5QvC~6|CJPOWERCAST|GetUrl. result https://demo.tmd.tv/Temp Upload/Animation%20Sample1.mp4 t Transfer: 1220 : 12|08:20:22.4250|5QvC~6|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:22.4260|5QvC~6|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:22.4260|5QvC~6|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|08:20:22.4260|5QvC~6|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gotspecialspromo10secaction.mp4 subfolder t Transfer: 1220 : 12|08:20:22.4260|5QvC~6|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gotspecialspromo10secaction.mp4 t Transfer: 1220 : 12|08:20:22.4260|5QvC~6|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/gotspecialspromo10secaction.mp4 t Transfer: 1220 : 12|08:20:22.4260|5QvC~6|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:22.4260|5QvC~6|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:22.4270|5QvC~6|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|08:20:22.4270|5QvC~6|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gots0ep5us.mpd subfolder t Transfer: 1220 : 12|08:20:22.4270|5QvC~6|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gots0ep5us.mpd t Transfer: 1220 : 12|08:20:22.4270|5QvC~6|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/gots0ep5us.mpd t Transfer: 1220 : 12|08:20:22.4270|5QvC~6|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:22.4270|5QvC~6|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:22.4270|5QvC~6|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|08:20:22.4270|5QvC~6|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gots0ep2us.mpd subfolder t Transfer: 1220 : 12|08:20:22.4280|5QvC~6|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gots0ep2us.mpd t Transfer: 1220 : 12|08:20:22.4280|5QvC~6|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/gots0ep2us.mpd t Transfer: 1220 : 12|08:20:22.4280|5QvC~6|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:22.4280|5QvC~6|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:22.4280|5QvC~6|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|08:20:22.6290|5QvC~6|CJPOWERCAST|GetUrl. Storage |PMH Video| filename \\10.46.131.12\Test\NGAM\Folder3\0008971.mp4 subfolder t Transfer: 1220 : 12|08:20:22.6290|5QvC~6|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:22.6290|5QvC~6|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:22.6290|5QvC~6|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|08:20:22.6290|5QvC~6|CJPOWERCAST|GetUrl. Storage |PMH Proxy| filename \\10.46.131.12\Test\NGAM\Folder5\0154300FRM00_M0002176.mp4 subfolder t Transfer: 1220 : 12|08:20:22.6300|5QvC~6|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:22.6300|5QvC~6|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:22.6300|5QvC~6|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|08:20:23.2330|zzGPrx|CJPOWERCAST|OAuth: /api/user-preferences?_dc=1655104822884 t Transfer: 1220 : 12|08:20:23.2330|zzGPrx|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:23.2330|zzGPrx|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:23.2330|zzGPrx|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|08:20:23.2330|zzGPrx|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 12|08:20:23.2330|zzGPrx|CJPOWERCAST|StoreUserDataByKeys.. t Transfer: 1220 : 12|08:20:23.2330|zzGPrx|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:23.2330|zzGPrx|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:23.2330|zzGPrx|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|08:20:23.2330|zzGPrx|CJPOWERCAST|imfx v3 API took 0.021s '/api/user-preferences?_dc=1655104822884' t Transfer: 1220 : 12|08:20:23.8370|JWeflg|CJPOWERCAST|OAuth: /api/v3/search/Media?_dc=1655104823355 t Transfer: 1220 : 12|08:20:23.8370|JWeflg|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:23.8370|JWeflg|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:23.8370|JWeflg|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|08:20:23.8370|JWeflg|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|08:20:23.8380|Zv0zoc|CJPOWERCAST|OAuth: /api/lookups/FriendlyNames?_dc=1655104823353 t Transfer: 1220 : 12|08:20:23.8380|Zv0zoc|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:23.8380|Zv0zoc|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:23.8380|Zv0zoc|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|08:20:23.8380|Zv0zoc|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 12|08:20:23.8380|Zv0zoc|CJPOWERCAST|imfx v3 API took 0.000s '/api/lookups/FriendlyNames?_dc=1655104823353' t Information: 1220 : 12|08:20:23.8380|JWeflg|CJPOWERCAST|V3Api.SearchMedia t Information: 1220 : 12|08:20:23.8390|JWeflg|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|08:20:23.8390|JWeflg|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:23.8390|JWeflg|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:23.8390|JWeflg|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|08:20:23.8390|JWeflg|CJPOWERCAST|MediaSearch SQL: select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type in (1,110)),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , (select 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", GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select a.*, rownum rnum from (select m.*, coalesce(m.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=m.pgm_parent_id)) primary_thumb_id2 from tmddba.tm_mis m where media_type>0 and item_type>0 AND m.ID = :param_0 and m.mi_deleted=0 AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0) order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl where rnum >= 1 order by rnum t Transfer: 1220 : 12|08:20:23.8400|U2b6Ii|CJPOWERCAST|OAuth: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1655104823499 t Transfer: 1220 : 12|08:20:23.8400|U2b6Ii|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:23.8400|U2b6Ii|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:23.8400|U2b6Ii|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|08:20:23.8400|U2b6Ii|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|08:20:23.8400|U2b6Ii|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:23.8400|U2b6Ii|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:23.8410|U2b6Ii|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|08:20:23.8410|JWeflg|CJPOWERCAST|Alternative title fields query: select * from (select x.id,x.pgm_abs_id TitleId, x.pgm_parent_id VersionId from tm_mis x where id in (select /*+ cardinality(4) */ column_value id from table(:ids))) y,lateral (select dbms_lob.substr( o.text_data_plain, 1000, 1 ) Field_5799344 from tm_txt_obj o where (o.pgm_abs_id=y.TitleId or o.pgm_rl_id = y.VersionId) and o.type_id=:param_1 order by o.id desc fetch first 1 rows only)(+) t Verbose: 1220 : 12|08:20:23.8410|U2b6Ii|CJPOWERCAST|imfx v3 API took 0.008s '/api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1655104823499' t Information: 1220 : 12|08:20:24.0420|JWeflg|CJPOWERCAST| timing: 00:00:00.2063070 t Verbose: 1220 : 12|08:20:24.0420|JWeflg|CJPOWERCAST|imfx v3 API took 0.208s '/api/v3/search/Media?_dc=1655104823355' t Transfer: 1220 : 12|08:20:24.0420|JWeflg|CJPOWERCAST|GetUrl. Storage |Video| filename I:\Video\L0640441.mp4 subfolder t Transfer: 1220 : 12|08:20:24.0420|JWeflg|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/L0640441.mp4 t Transfer: 1220 : 12|08:20:24.0420|JWeflg|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/L0640441.mp4 t Transfer: 1220 : 12|08:20:24.0420|JWeflg|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:24.0430|JWeflg|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:24.0430|JWeflg|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|08:20:24.4450|PGu6kL|CJPOWERCAST|OAuth: /api/v3/detailsview/MediaDetails/5?lang=en-GB&_dc=1655104823994 t Transfer: 1220 : 12|08:20:24.4460|PGu6kL|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:24.4460|PGu6kL|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:24.4460|PGu6kL|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|08:20:24.4460|PGu6kL|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|08:20:24.4470|bPpy9u|CJPOWERCAST|OAuth: /api/v3/media-captions/291743?_dc=1655104823996 t Transfer: 1220 : 12|08:20:24.4470|bPpy9u|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:24.4470|bPpy9u|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:24.4480|bPpy9u|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|08:20:24.4480|bPpy9u|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|08:20:24.4480|EdVowo|CJPOWERCAST|V3Api.GetMediaTagging t Transfer: 1220 : 12|08:20:24.4480|A30o8W|CJPOWERCAST|OAuth: /api/lookups/FriendlyNames?_dc=1655104823995 t Transfer: 1220 : 12|08:20:24.4480|A30o8W|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:24.4480|A30o8W|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:24.4480|A30o8W|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|08:20:24.4490|A30o8W|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|08:20:24.4490|5QeEix|CJPOWERCAST|OAuth: /api/v3/mediavideo/291743?info=smudge&_dc=1655104824001 t Transfer: 1220 : 12|08:20:24.4490|5QeEix|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:24.4490|5QeEix|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:24.4490|5QeEix|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|08:20:24.4490|5QeEix|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|08:20:24.4490|PGu6kL|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:24.4490|PGu6kL|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:24.4500|PGu6kL|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|08:20:24.4500|A30o8W|CJPOWERCAST|imfx v3 API took 0.000s '/api/lookups/FriendlyNames?_dc=1655104823995' t Information: 1220 : 12|08:20:24.4500|PGu6kL|CJPOWERCAST|GetSystemPref. Pref: DetailsView, Type: -4013, subType: 5 t Information: 1220 : 12|08:20:24.4500|PGu6kL|CJPOWERCAST|GetSystemPref. Pref: DetailsView, Type: -4013, subType: 0 t Information: 1220 : 12|08:20:24.4500|PGu6kL|CJPOWERCAST|GetSystemPref. Pref: DetailsView, Type: -4013, subType: 5 t Information: 1220 : 12|08:20:24.4500|PGu6kL|CJPOWERCAST|GetSystemPref. Pref: DetailsView, Type: -4013, subType: 0 t Transfer: 1220 : 12|08:20:24.4500|5QeEix|CJPOWERCAST|GetUrl. Storage |Video| filename I:\Video\L0640441.mp4 subfolder t Transfer: 1220 : 12|08:20:24.4500|5QeEix|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/L0640441.mp4 t Transfer: 1220 : 12|08:20:24.4500|5QeEix|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/L0640441.mp4 t Transfer: 1220 : 12|08:20:24.4510|5QeEix|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:24.4510|5QeEix|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:24.4510|5QeEix|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|08:20:24.6520|PGu6kL|CJPOWERCAST|imfx v3 API took 0.214s '/api/v3/detailsview/MediaDetails/5?lang=en-GB&_dc=1655104823994' t Verbose: 1220 : 12|08:20:24.6520|bPpy9u|CJPOWERCAST|imfx v3 API took 0.241s '/api/v3/media-captions/291743?_dc=1655104823996' t Verbose: 1220 : 12|08:20:24.6520|5QeEix|CJPOWERCAST|imfx v3 API took 0.246s '/api/v3/mediavideo/291743?info=smudge&_dc=1655104824001' t Transfer: 1220 : 12|08:20:25.0540|VshZoS|CJPOWERCAST|OAuth: /api/v3/search/Media?_dc=1655104824564 t Transfer: 1220 : 12|08:20:25.0540|VshZoS|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:25.0540|VshZoS|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:25.0540|VshZoS|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|08:20:25.0540|VshZoS|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|08:20:25.0540|VshZoS|CJPOWERCAST|V3Api.SearchMedia t Information: 1220 : 12|08:20:25.0540|VshZoS|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|08:20:25.0540|VshZoS|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:25.0540|VshZoS|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:25.0550|VshZoS|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|08:20:25.0550|VshZoS|CJPOWERCAST|MediaSearch SQL: select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type in (1,110)),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , (select 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", GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select a.*, rownum rnum from (select m.*, coalesce(m.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=m.pgm_parent_id)) primary_thumb_id2 from tmddba.tm_mis m where media_type>0 and item_type>0 AND m.ID = :param_0 and m.mi_deleted=0 AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0) order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl where rnum >= 1 order by rnum t Verbose: 1220 : 12|08:20:25.0550|VshZoS|CJPOWERCAST|Alternative title fields query: select * from (select x.id,x.pgm_abs_id TitleId, x.pgm_parent_id VersionId from tm_mis x where id in (select /*+ cardinality(4) */ column_value id from table(:ids))) y,lateral (select dbms_lob.substr( o.text_data_plain, 1000, 1 ) Field_5799344 from tm_txt_obj o where (o.pgm_abs_id=y.TitleId or o.pgm_rl_id = y.VersionId) and o.type_id=:param_1 order by o.id desc fetch first 1 rows only)(+) t Information: 1220 : 12|08:20:25.0550|VshZoS|CJPOWERCAST| timing: 00:00:00.0160744 t Verbose: 1220 : 12|08:20:25.0550|VshZoS|CJPOWERCAST|imfx v3 API took 0.016s '/api/v3/search/Media?_dc=1655104824564' t Transfer: 1220 : 12|08:20:25.0550|VshZoS|CJPOWERCAST|GetUrl. Storage |Video| filename I:\Video\L0640441.mp4 subfolder t Transfer: 1220 : 12|08:20:25.0550|VshZoS|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/L0640441.mp4 t Transfer: 1220 : 12|08:20:25.0550|VshZoS|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/L0640441.mp4 t Transfer: 1220 : 12|08:20:25.0550|VshZoS|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:25.0550|VshZoS|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:25.0560|VshZoS|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|08:20:30.0810|7al6aY|CJPOWERCAST|OAuth: /api/v3/search/Media?_dc=1655104829627 t Transfer: 1220 : 12|08:20:30.0810|7al6aY|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:30.0810|7al6aY|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:30.0810|7al6aY|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|08:20:30.0810|7al6aY|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|08:20:30.0820|7al6aY|CJPOWERCAST|V3Api.SearchMedia t Information: 1220 : 12|08:20:30.0820|7al6aY|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|08:20:30.0820|7al6aY|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:30.0820|7al6aY|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:30.0820|7al6aY|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|08:20:30.0820|7al6aY|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 (((media_format:((77))))) AND deleted_flag:(0) AND (owners:((SFP2) OR (PSP) OR (PMS) OR (SFP1) OR (PMH) OR (PPL))))] t Information: 1220 : 12|08:20:30.0820|7al6aY|CJPOWERCAST|Solr query returned: 11 in 85ms t Information: 1220 : 12|08:20:30.0829|7al6aY|CJPOWERCAST|MediaSearch SQL: select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type in (1,110)),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , (SELECT SUBSTR( trim( replace (replace ( LISTAGG(trim(tt.tags || ' ' || tt.notes), ' ') WITHIN GROUP (ORDER BY trim(tt.tags || ' ' || tt.notes)), chr (13), ''), chr (10), ' ')), 1, 150) z FROM tm_media_tagging tt WHERE link_guid = DFILE_LINK_GUID and rownum=1) TAGS_TEXT , GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select a.*, rownum rnum from (select m.*, coalesce(m.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=m.pgm_parent_id)) primary_thumb_id2 from tmddba.tm_mis m ,(select /*+ cardinality(4) */ rownum rn, column_value id from table(:ids)) ids where m.id = ids.id order by ids.rn ) a where rownum <= 10000) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl where rnum >= 1 order by rnum t Information: 1220 : 12|08:20:30.0829|7al6aY|CJPOWERCAST| timing: 00:00:00.1318284 t Verbose: 1220 : 12|08:20:30.0829|7al6aY|CJPOWERCAST|imfx v3 API took 0.132s '/api/v3/search/Media?_dc=1655104829627' t Transfer: 1220 : 12|08:20:30.0829|7al6aY|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\Game_of_Thrones_Still_4.png subfolder t Transfer: 1220 : 12|08:20:30.0829|7al6aY|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/Game_of_Thrones_Still_4.png t Transfer: 1220 : 12|08:20:30.0829|7al6aY|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/Game_of_Thrones_Still_4.png t Transfer: 1220 : 12|08:20:30.0839|7al6aY|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:30.0839|7al6aY|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:30.0839|7al6aY|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|08:20:30.0839|7al6aY|CJPOWERCAST|GetUrl. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\a9abc460-6022-4997-9f9f-efeef62d30d9\MH26-002.png subfolder a9abc460-6022-4997-9f9f-efeef62d30d9\ t Transfer: 1220 : 12|08:20:30.0839|7al6aY|CJPOWERCAST| GetFileName result https://demo.tmd.tv/Temp Upload/MH26-002.png t Transfer: 1220 : 12|08:20:30.0839|7al6aY|CJPOWERCAST|GetUrl. result https://demo.tmd.tv/Temp Upload/MH26-002.png t Transfer: 1220 : 12|08:20:30.0839|7al6aY|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:30.0839|7al6aY|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:30.0849|7al6aY|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|08:20:30.0849|7al6aY|CJPOWERCAST|GetUrl. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\e91bafd5-5930-4583-b762-23637271c629\원본-자막기Export비교2.PNG subfolder e91bafd5-5930-4583-b762-23637271c629\ t Transfer: 1220 : 12|08:20:30.0849|7al6aY|CJPOWERCAST| GetFileName result https://demo.tmd.tv/Temp Upload/%EC%9B%90%EB%B3%B8-%EC%9E%90%EB%A7%89%EA%B8%B0Export%EB%B9%84%EA%B5%902.PNG t Transfer: 1220 : 12|08:20:30.0849|7al6aY|CJPOWERCAST|GetUrl. result https://demo.tmd.tv/Temp Upload/%EC%9B%90%EB%B3%B8-%EC%9E%90%EB%A7%89%EA%B8%B0Export%EB%B9%84%EA%B5%902.PNG t Transfer: 1220 : 12|08:20:30.0849|7al6aY|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:30.0849|7al6aY|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:30.0859|7al6aY|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|08:20:30.0859|7al6aY|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\원본-자막기Export비교2.PNG subfolder t Transfer: 1220 : 12|08:20:30.0859|7al6aY|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/%EC%9B%90%EB%B3%B8-%EC%9E%90%EB%A7%89%EA%B8%B0Export%EB%B9%84%EA%B5%902.PNG t Transfer: 1220 : 12|08:20:30.0859|7al6aY|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/%EC%9B%90%EB%B3%B8-%EC%9E%90%EB%A7%89%EA%B8%B0Export%EB%B9%84%EA%B5%902.PNG t Transfer: 1220 : 12|08:20:30.0859|7al6aY|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:30.0859|7al6aY|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:30.0859|7al6aY|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|08:20:30.0869|7al6aY|CJPOWERCAST|GetUrl. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\fc368516-1df7-4cee-8be7-8122acbd869e\원본-자막기Export비교1.PNG subfolder fc368516-1df7-4cee-8be7-8122acbd869e\ t Transfer: 1220 : 12|08:20:30.0869|7al6aY|CJPOWERCAST| GetFileName result https://demo.tmd.tv/Temp Upload/%EC%9B%90%EB%B3%B8-%EC%9E%90%EB%A7%89%EA%B8%B0Export%EB%B9%84%EA%B5%901.PNG t Transfer: 1220 : 12|08:20:30.0869|7al6aY|CJPOWERCAST|GetUrl. result https://demo.tmd.tv/Temp Upload/%EC%9B%90%EB%B3%B8-%EC%9E%90%EB%A7%89%EA%B8%B0Export%EB%B9%84%EA%B5%901.PNG t Transfer: 1220 : 12|08:20:30.0869|7al6aY|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:30.0869|7al6aY|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:30.0869|7al6aY|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|08:20:30.2879|7al6aY|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\원본-자막기Export비교1.PNG subfolder t Transfer: 1220 : 12|08:20:30.2879|7al6aY|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/%EC%9B%90%EB%B3%B8-%EC%9E%90%EB%A7%89%EA%B8%B0Export%EB%B9%84%EA%B5%901.PNG t Transfer: 1220 : 12|08:20:30.2890|7al6aY|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/%EC%9B%90%EB%B3%B8-%EC%9E%90%EB%A7%89%EA%B8%B0Export%EB%B9%84%EA%B5%901.PNG t Transfer: 1220 : 12|08:20:30.2890|7al6aY|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:30.2890|7al6aY|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:30.2890|7al6aY|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|08:20:30.2890|7al6aY|CJPOWERCAST|GetUrl. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\49ad8633-3f5e-4b34-886d-45603d50e05d\ECM-0298.png subfolder 49ad8633-3f5e-4b34-886d-45603d50e05d\ t Transfer: 1220 : 12|08:20:30.2890|7al6aY|CJPOWERCAST| GetFileName result https://demo.tmd.tv/Temp Upload/ECM-0298.png t Transfer: 1220 : 12|08:20:30.2890|7al6aY|CJPOWERCAST|GetUrl. result https://demo.tmd.tv/Temp Upload/ECM-0298.png t Transfer: 1220 : 12|08:20:30.2890|7al6aY|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:30.2890|7al6aY|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:30.2890|7al6aY|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|08:20:30.2890|7al6aY|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\MH26-002.png subfolder t Transfer: 1220 : 12|08:20:30.2900|7al6aY|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/MH26-002.png t Transfer: 1220 : 12|08:20:30.2900|7al6aY|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/MH26-002.png t Transfer: 1220 : 12|08:20:30.2900|7al6aY|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:30.2900|7al6aY|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:30.2900|7al6aY|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|08:20:30.2900|7al6aY|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\002.001_summer_palace_thumbnail_small_M0002041.png subfolder t Transfer: 1220 : 12|08:20:30.2900|7al6aY|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/002.001_summer_palace_thumbnail_small_M0002041.png t Transfer: 1220 : 12|08:20:30.2900|7al6aY|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/002.001_summer_palace_thumbnail_small_M0002041.png t Transfer: 1220 : 12|08:20:30.2900|7al6aY|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:30.2900|7al6aY|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:30.2900|7al6aY|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|08:20:30.2910|7al6aY|CJPOWERCAST|GetUrl. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\04a2988a-1155-45d8-a068-8dfa0b9a343a\캡처3.PNG subfolder 04a2988a-1155-45d8-a068-8dfa0b9a343a\ t Transfer: 1220 : 12|08:20:30.2910|7al6aY|CJPOWERCAST| GetFileName result https://demo.tmd.tv/Temp Upload/%EC%BA%A1%EC%B2%983.PNG t Transfer: 1220 : 12|08:20:30.2910|7al6aY|CJPOWERCAST|GetUrl. result https://demo.tmd.tv/Temp Upload/%EC%BA%A1%EC%B2%983.PNG t Transfer: 1220 : 12|08:20:30.2910|7al6aY|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:30.2910|7al6aY|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:30.2910|7al6aY|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|08:20:30.2910|7al6aY|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\캡처3.PNG subfolder t Transfer: 1220 : 12|08:20:30.2910|7al6aY|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/%EC%BA%A1%EC%B2%983.PNG t Transfer: 1220 : 12|08:20:30.2910|7al6aY|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/%EC%BA%A1%EC%B2%983.PNG t Transfer: 1220 : 12|08:20:30.2910|7al6aY|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:30.2910|7al6aY|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:30.2910|7al6aY|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|08:20:30.8949|iDmJS7|CJPOWERCAST|OAuth: /api/user-preferences?_dc=1655104830427 t Transfer: 1220 : 12|08:20:30.8949|iDmJS7|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:30.8949|iDmJS7|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:30.8949|iDmJS7|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|08:20:30.8949|iDmJS7|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 12|08:20:30.8949|iDmJS7|CJPOWERCAST|StoreUserDataByKeys.. t Transfer: 1220 : 12|08:20:30.8949|iDmJS7|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:30.8949|iDmJS7|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:30.8949|iDmJS7|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|08:20:30.8959|iDmJS7|CJPOWERCAST|imfx v3 API took 0.015s '/api/user-preferences?_dc=1655104830427' t Transfer: 1220 : 12|08:20:31.4989|Cg6oxE|CJPOWERCAST|OAuth: /api/v3/detailsview/MediaDetails/9?lang=en-GB&_dc=1655104831018 t Transfer: 1220 : 12|08:20:31.4989|Cg6oxE|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:31.4989|Cg6oxE|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:31.4989|Cg6oxE|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|08:20:31.4989|Cg6oxE|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|08:20:31.4989|Cg6oxE|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:31.4989|Cg6oxE|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:31.4989|Cg6oxE|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|08:20:31.4989|Cg6oxE|CJPOWERCAST|GetSystemPref. Pref: DetailsView, Type: -4013, subType: 9 t Information: 1220 : 12|08:20:31.5000|Cg6oxE|CJPOWERCAST|GetSystemPref. Pref: DetailsView, Type: -4013, subType: 0 t Information: 1220 : 12|08:20:31.5000|Cg6oxE|CJPOWERCAST|GetSystemPref. Pref: DetailsView, Type: -4013, subType: 9 t Information: 1220 : 12|08:20:31.5000|Cg6oxE|CJPOWERCAST|GetSystemPref. Pref: DetailsView, Type: -4013, subType: 0 t Verbose: 1220 : 12|08:20:31.5000|Cg6oxE|CJPOWERCAST|imfx v3 API took 0.033s '/api/v3/detailsview/MediaDetails/9?lang=en-GB&_dc=1655104831018' t Transfer: 1220 : 12|08:20:31.7009|inHJsk|CJPOWERCAST|OAuth: /api/v3/search/Media?_dc=1655104831341 t Transfer: 1220 : 12|08:20:31.7009|inHJsk|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:31.7009|inHJsk|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:31.7009|inHJsk|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|08:20:31.7009|inHJsk|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|08:20:31.7009|inHJsk|CJPOWERCAST|V3Api.SearchMedia t Information: 1220 : 12|08:20:31.7019|inHJsk|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|08:20:31.7019|inHJsk|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:31.7019|inHJsk|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:31.7019|inHJsk|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|08:20:31.7019|inHJsk|CJPOWERCAST|MediaSearch SQL: select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type in (1,110)),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , (select 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", GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select a.*, rownum rnum from (select m.*, coalesce(m.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=m.pgm_parent_id)) primary_thumb_id2 from tmddba.tm_mis m where media_type>0 and item_type>0 AND m.ID = :param_0 and m.mi_deleted=0 AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0) order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl where rnum >= 1 order by rnum t Verbose: 1220 : 12|08:20:31.7029|inHJsk|CJPOWERCAST|Alternative title fields query: select * from (select x.id,x.pgm_abs_id TitleId, x.pgm_parent_id VersionId from tm_mis x where id in (select /*+ cardinality(4) */ column_value id from table(:ids))) y,lateral (select dbms_lob.substr( o.text_data_plain, 1000, 1 ) Field_5799344 from tm_txt_obj o where (o.pgm_abs_id=y.TitleId or o.pgm_rl_id = y.VersionId) and o.type_id=:param_1 order by o.id desc fetch first 1 rows only)(+) t Information: 1220 : 12|08:20:31.7029|inHJsk|CJPOWERCAST| timing: 00:00:00.0207926 t Verbose: 1220 : 12|08:20:31.7029|inHJsk|CJPOWERCAST|imfx v3 API took 0.021s '/api/v3/search/Media?_dc=1655104831341' t Transfer: 1220 : 12|08:20:31.7029|inHJsk|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\Game_of_Thrones_Still_4.png subfolder t Transfer: 1220 : 12|08:20:31.7029|inHJsk|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/Game_of_Thrones_Still_4.png t Transfer: 1220 : 12|08:20:31.7029|inHJsk|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/Game_of_Thrones_Still_4.png t Transfer: 1220 : 12|08:20:31.7029|inHJsk|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:31.7039|inHJsk|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:31.7039|inHJsk|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|08:20:41.5589|GAYybs|CJPOWERCAST|OAuth: /api/v3/search/Media?_dc=1655104841194 t Transfer: 1220 : 12|08:20:41.5589|GAYybs|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:41.5589|GAYybs|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:41.5589|GAYybs|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|08:20:41.5589|GAYybs|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|08:20:41.5589|GAYybs|CJPOWERCAST|V3Api.SearchMedia t Information: 1220 : 12|08:20:41.5599|GAYybs|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|08:20:41.5599|GAYybs|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:41.5609|GAYybs|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:41.5619|GAYybs|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|08:20:41.5619|GAYybs|CJPOWERCAST|MediaSearch SQL: select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type in (1,110)),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , (select 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", GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select a.*, rownum rnum from (select m.*, coalesce(m.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=m.pgm_parent_id)) primary_thumb_id2 from tmddba.tm_mis m where media_type>0 and item_type>0 AND m.ID = :param_0 and m.mi_deleted=0 AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0) order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl where rnum >= 1 order by rnum t Verbose: 1220 : 12|08:20:41.5619|GAYybs|CJPOWERCAST|Alternative title fields query: select * from (select x.id,x.pgm_abs_id TitleId, x.pgm_parent_id VersionId from tm_mis x where id in (select /*+ cardinality(4) */ column_value id from table(:ids))) y,lateral (select dbms_lob.substr( o.text_data_plain, 1000, 1 ) Field_5799344 from tm_txt_obj o where (o.pgm_abs_id=y.TitleId or o.pgm_rl_id = y.VersionId) and o.type_id=:param_1 order by o.id desc fetch first 1 rows only)(+) t Information: 1220 : 12|08:20:41.5619|GAYybs|CJPOWERCAST| timing: 00:00:00.0309287 t Verbose: 1220 : 12|08:20:41.5629|GAYybs|CJPOWERCAST|imfx v3 API took 0.031s '/api/v3/search/Media?_dc=1655104841194' t Transfer: 1220 : 12|08:20:41.5629|GAYybs|CJPOWERCAST|GetUrl. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\e91bafd5-5930-4583-b762-23637271c629\원본-자막기Export비교2.PNG subfolder e91bafd5-5930-4583-b762-23637271c629\ t Transfer: 1220 : 12|08:20:41.5629|GAYybs|CJPOWERCAST| GetFileName result https://demo.tmd.tv/Temp Upload/%EC%9B%90%EB%B3%B8-%EC%9E%90%EB%A7%89%EA%B8%B0Export%EB%B9%84%EA%B5%902.PNG t Transfer: 1220 : 12|08:20:41.5629|GAYybs|CJPOWERCAST|GetUrl. result https://demo.tmd.tv/Temp Upload/%EC%9B%90%EB%B3%B8-%EC%9E%90%EB%A7%89%EA%B8%B0Export%EB%B9%84%EA%B5%902.PNG t Transfer: 1220 : 12|08:20:41.5629|GAYybs|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:41.5629|GAYybs|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:41.5629|GAYybs|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|08:20:44.9799|egq3gL|CJPOWERCAST|OAuth: /api/v3/search/Media?_dc=1655104844574 t Transfer: 1220 : 12|08:20:44.9799|egq3gL|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:44.9799|egq3gL|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:44.9799|egq3gL|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|08:20:44.9799|egq3gL|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|08:20:44.9799|egq3gL|CJPOWERCAST|V3Api.SearchMedia t Information: 1220 : 12|08:20:44.9799|egq3gL|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|08:20:44.9799|egq3gL|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:44.9809|egq3gL|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:44.9809|egq3gL|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|08:20:44.9809|egq3gL|CJPOWERCAST|MediaSearch SQL: select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type in (1,110)),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , (select 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", GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select a.*, rownum rnum from (select m.*, coalesce(m.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=m.pgm_parent_id)) primary_thumb_id2 from tmddba.tm_mis m where media_type>0 and item_type>0 AND m.ID = :param_0 and m.mi_deleted=0 AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0) order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl where rnum >= 1 order by rnum t Verbose: 1220 : 12|08:20:44.9809|egq3gL|CJPOWERCAST|Alternative title fields query: select * from (select x.id,x.pgm_abs_id TitleId, x.pgm_parent_id VersionId from tm_mis x where id in (select /*+ cardinality(4) */ column_value id from table(:ids))) y,lateral (select dbms_lob.substr( o.text_data_plain, 1000, 1 ) Field_5799344 from tm_txt_obj o where (o.pgm_abs_id=y.TitleId or o.pgm_rl_id = y.VersionId) and o.type_id=:param_1 order by o.id desc fetch first 1 rows only)(+) t Information: 1220 : 12|08:20:44.9809|egq3gL|CJPOWERCAST| timing: 00:00:00.0342985 t Verbose: 1220 : 12|08:20:44.9809|egq3gL|CJPOWERCAST|imfx v3 API took 0.034s '/api/v3/search/Media?_dc=1655104844574' t Transfer: 1220 : 12|08:20:44.9809|egq3gL|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\원본-자막기Export비교2.PNG subfolder t Transfer: 1220 : 12|08:20:44.9809|egq3gL|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/%EC%9B%90%EB%B3%B8-%EC%9E%90%EB%A7%89%EA%B8%B0Export%EB%B9%84%EA%B5%902.PNG t Transfer: 1220 : 12|08:20:44.9809|egq3gL|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/%EC%9B%90%EB%B3%B8-%EC%9E%90%EB%A7%89%EA%B8%B0Export%EB%B9%84%EA%B5%902.PNG t Transfer: 1220 : 12|08:20:44.9809|egq3gL|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:44.9809|egq3gL|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:44.9819|egq3gL|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|08:20:51.0119|23UT6w|CJPOWERCAST|OAuth: /api/v3/search/Media?_dc=1655104850692 t Transfer: 1220 : 12|08:20:51.0119|23UT6w|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:51.0119|23UT6w|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:51.0119|23UT6w|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|08:20:51.0119|23UT6w|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|08:20:51.0129|23UT6w|CJPOWERCAST|V3Api.SearchMedia t Information: 1220 : 12|08:20:51.0129|23UT6w|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|08:20:51.0129|23UT6w|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:51.0129|23UT6w|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:51.0129|23UT6w|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|08:20:51.0129|23UT6w|CJPOWERCAST|MediaSearch SQL: select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type in (1,110)),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , (select 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", GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select a.*, rownum rnum from (select m.*, coalesce(m.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=m.pgm_parent_id)) primary_thumb_id2 from tmddba.tm_mis m where media_type>0 and item_type>0 AND m.ID = :param_0 and m.mi_deleted=0 AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0) order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl where rnum >= 1 order by rnum t Verbose: 1220 : 12|08:20:51.2138|23UT6w|CJPOWERCAST|Alternative title fields query: select * from (select x.id,x.pgm_abs_id TitleId, x.pgm_parent_id VersionId from tm_mis x where id in (select /*+ cardinality(4) */ column_value id from table(:ids))) y,lateral (select dbms_lob.substr( o.text_data_plain, 1000, 1 ) Field_5799344 from tm_txt_obj o where (o.pgm_abs_id=y.TitleId or o.pgm_rl_id = y.VersionId) and o.type_id=:param_1 order by o.id desc fetch first 1 rows only)(+) t Information: 1220 : 12|08:20:51.2138|23UT6w|CJPOWERCAST| timing: 00:00:00.0213436 t Verbose: 1220 : 12|08:20:51.2138|23UT6w|CJPOWERCAST|imfx v3 API took 0.021s '/api/v3/search/Media?_dc=1655104850692' t Transfer: 1220 : 12|08:20:51.2138|23UT6w|CJPOWERCAST|GetUrl. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\e91bafd5-5930-4583-b762-23637271c629\원본-자막기Export비교2.PNG subfolder e91bafd5-5930-4583-b762-23637271c629\ t Transfer: 1220 : 12|08:20:51.2138|23UT6w|CJPOWERCAST| GetFileName result https://demo.tmd.tv/Temp Upload/%EC%9B%90%EB%B3%B8-%EC%9E%90%EB%A7%89%EA%B8%B0Export%EB%B9%84%EA%B5%902.PNG t Transfer: 1220 : 12|08:20:51.2138|23UT6w|CJPOWERCAST|GetUrl. result https://demo.tmd.tv/Temp Upload/%EC%9B%90%EB%B3%B8-%EC%9E%90%EB%A7%89%EA%B8%B0Export%EB%B9%84%EA%B5%902.PNG t Transfer: 1220 : 12|08:20:51.2138|23UT6w|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:51.2138|23UT6w|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:51.2138|23UT6w|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|08:20:54.2338|kmzX22|CJPOWERCAST|OAuth: /api/v3/search/Media?_dc=1655104853832 t Transfer: 1220 : 12|08:20:54.2338|kmzX22|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:54.2338|kmzX22|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:54.2338|kmzX22|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|08:20:54.2338|kmzX22|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|08:20:54.2338|kmzX22|CJPOWERCAST|V3Api.SearchMedia t Information: 1220 : 12|08:20:54.2338|kmzX22|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|08:20:54.2338|kmzX22|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:54.2338|kmzX22|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:54.2348|kmzX22|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|08:20:54.2348|kmzX22|CJPOWERCAST|MediaSearch SQL: select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type in (1,110)),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , (select 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", GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select a.*, rownum rnum from (select m.*, coalesce(m.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=m.pgm_parent_id)) primary_thumb_id2 from tmddba.tm_mis m where media_type>0 and item_type>0 AND m.ID = :param_0 and m.mi_deleted=0 AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0) order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl where rnum >= 1 order by rnum t Verbose: 1220 : 12|08:20:54.2348|kmzX22|CJPOWERCAST|Alternative title fields query: select * from (select x.id,x.pgm_abs_id TitleId, x.pgm_parent_id VersionId from tm_mis x where id in (select /*+ cardinality(4) */ column_value id from table(:ids))) y,lateral (select dbms_lob.substr( o.text_data_plain, 1000, 1 ) Field_5799344 from tm_txt_obj o where (o.pgm_abs_id=y.TitleId or o.pgm_rl_id = y.VersionId) and o.type_id=:param_1 order by o.id desc fetch first 1 rows only)(+) t Information: 1220 : 12|08:20:54.2348|kmzX22|CJPOWERCAST| timing: 00:00:00.0392313 t Verbose: 1220 : 12|08:20:54.2348|kmzX22|CJPOWERCAST|imfx v3 API took 0.039s '/api/v3/search/Media?_dc=1655104853832' t Transfer: 1220 : 12|08:20:54.2348|kmzX22|CJPOWERCAST|GetUrl. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\fc368516-1df7-4cee-8be7-8122acbd869e\원본-자막기Export비교1.PNG subfolder fc368516-1df7-4cee-8be7-8122acbd869e\ t Transfer: 1220 : 12|08:20:54.2348|kmzX22|CJPOWERCAST| GetFileName result https://demo.tmd.tv/Temp Upload/%EC%9B%90%EB%B3%B8-%EC%9E%90%EB%A7%89%EA%B8%B0Export%EB%B9%84%EA%B5%901.PNG t Transfer: 1220 : 12|08:20:54.2348|kmzX22|CJPOWERCAST|GetUrl. result https://demo.tmd.tv/Temp Upload/%EC%9B%90%EB%B3%B8-%EC%9E%90%EB%A7%89%EA%B8%B0Export%EB%B9%84%EA%B5%901.PNG t Transfer: 1220 : 12|08:20:54.2348|kmzX22|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:54.2348|kmzX22|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:54.2348|kmzX22|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|08:20:55.8528|qhvTq0|CJPOWERCAST|OAuth: /api/v3/search/Media?_dc=1655104855502 t Transfer: 1220 : 12|08:20:55.8528|qhvTq0|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:55.8538|qhvTq0|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:55.8538|qhvTq0|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|08:20:55.8538|qhvTq0|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|08:20:55.8538|qhvTq0|CJPOWERCAST|V3Api.SearchMedia t Information: 1220 : 12|08:20:55.8538|qhvTq0|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|08:20:55.8538|qhvTq0|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:55.8538|qhvTq0|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:55.8538|qhvTq0|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|08:20:55.8538|qhvTq0|CJPOWERCAST|MediaSearch SQL: select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type in (1,110)),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , (select 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", GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select a.*, rownum rnum from (select m.*, coalesce(m.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=m.pgm_parent_id)) primary_thumb_id2 from tmddba.tm_mis m where media_type>0 and item_type>0 AND m.ID = :param_0 and m.mi_deleted=0 AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0) order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl where rnum >= 1 order by rnum t Verbose: 1220 : 12|08:20:55.8548|qhvTq0|CJPOWERCAST|Alternative title fields query: select * from (select x.id,x.pgm_abs_id TitleId, x.pgm_parent_id VersionId from tm_mis x where id in (select /*+ cardinality(4) */ column_value id from table(:ids))) y,lateral (select dbms_lob.substr( o.text_data_plain, 1000, 1 ) Field_5799344 from tm_txt_obj o where (o.pgm_abs_id=y.TitleId or o.pgm_rl_id = y.VersionId) and o.type_id=:param_1 order by o.id desc fetch first 1 rows only)(+) t Information: 1220 : 12|08:20:55.8548|qhvTq0|CJPOWERCAST| timing: 00:00:00.0243035 t Verbose: 1220 : 12|08:20:55.8548|qhvTq0|CJPOWERCAST|imfx v3 API took 0.024s '/api/v3/search/Media?_dc=1655104855502' t Transfer: 1220 : 12|08:20:55.8548|qhvTq0|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\원본-자막기Export비교1.PNG subfolder t Transfer: 1220 : 12|08:20:55.8548|qhvTq0|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/%EC%9B%90%EB%B3%B8-%EC%9E%90%EB%A7%89%EA%B8%B0Export%EB%B9%84%EA%B5%901.PNG t Transfer: 1220 : 12|08:20:55.8558|qhvTq0|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/%EC%9B%90%EB%B3%B8-%EC%9E%90%EB%A7%89%EA%B8%B0Export%EB%B9%84%EA%B5%901.PNG t Transfer: 1220 : 12|08:20:55.8558|qhvTq0|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:20:55.8558|qhvTq0|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:20:55.8558|qhvTq0|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|08:21:00.4798|Boj1rQ|CJPOWERCAST|OAuth: /api/v3/search/Media?_dc=1655104860135 t Transfer: 1220 : 12|08:21:00.4798|Boj1rQ|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:21:00.4798|Boj1rQ|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:21:00.4808|Boj1rQ|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|08:21:00.4808|Boj1rQ|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|08:21:00.4808|Boj1rQ|CJPOWERCAST|V3Api.SearchMedia t Information: 1220 : 12|08:21:00.4808|Boj1rQ|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|08:21:00.4808|Boj1rQ|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:21:00.4808|Boj1rQ|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:21:00.4818|Boj1rQ|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|08:21:00.4818|Boj1rQ|CJPOWERCAST|MediaSearch SQL: select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type in (1,110)),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , (select 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", GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select a.*, rownum rnum from (select m.*, coalesce(m.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=m.pgm_parent_id)) primary_thumb_id2 from tmddba.tm_mis m where media_type>0 and item_type>0 AND m.ID = :param_0 and m.mi_deleted=0 AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0) order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl where rnum >= 1 order by rnum t Verbose: 1220 : 12|08:21:00.4818|Boj1rQ|CJPOWERCAST|Alternative title fields query: select * from (select x.id,x.pgm_abs_id TitleId, x.pgm_parent_id VersionId from tm_mis x where id in (select /*+ cardinality(4) */ column_value id from table(:ids))) y,lateral (select dbms_lob.substr( o.text_data_plain, 1000, 1 ) Field_5799344 from tm_txt_obj o where (o.pgm_abs_id=y.TitleId or o.pgm_rl_id = y.VersionId) and o.type_id=:param_1 order by o.id desc fetch first 1 rows only)(+) t Information: 1220 : 12|08:21:00.4818|Boj1rQ|CJPOWERCAST| timing: 00:00:00.0199280 t Verbose: 1220 : 12|08:21:00.4818|Boj1rQ|CJPOWERCAST|imfx v3 API took 0.020s '/api/v3/search/Media?_dc=1655104860135' t Transfer: 1220 : 12|08:21:00.4818|Boj1rQ|CJPOWERCAST|GetUrl. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\49ad8633-3f5e-4b34-886d-45603d50e05d\ECM-0298.png subfolder 49ad8633-3f5e-4b34-886d-45603d50e05d\ t Transfer: 1220 : 12|08:21:00.4818|Boj1rQ|CJPOWERCAST| GetFileName result https://demo.tmd.tv/Temp Upload/ECM-0298.png t Transfer: 1220 : 12|08:21:00.4828|Boj1rQ|CJPOWERCAST|GetUrl. result https://demo.tmd.tv/Temp Upload/ECM-0298.png t Transfer: 1220 : 12|08:21:00.4828|Boj1rQ|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:21:00.4828|Boj1rQ|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:21:00.4828|Boj1rQ|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|08:21:04.3018|0lbuel|CJPOWERCAST|OAuth: /api/v3/search/Media?_dc=1655104863889 t Transfer: 1220 : 12|08:21:04.3018|0lbuel|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:21:04.3018|0lbuel|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:21:04.3018|0lbuel|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|08:21:04.3018|0lbuel|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|08:21:04.3028|0lbuel|CJPOWERCAST|V3Api.SearchMedia t Information: 1220 : 12|08:21:04.3028|0lbuel|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|08:21:04.3028|0lbuel|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:21:04.3028|0lbuel|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:21:04.3028|0lbuel|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|08:21:04.3028|0lbuel|CJPOWERCAST|MediaSearch SQL: select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type in (1,110)),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , (select 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", GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select a.*, rownum rnum from (select m.*, coalesce(m.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=m.pgm_parent_id)) primary_thumb_id2 from tmddba.tm_mis m where media_type>0 and item_type>0 AND m.ID = :param_0 and m.mi_deleted=0 AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0) order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl where rnum >= 1 order by rnum t Verbose: 1220 : 12|08:21:04.3028|0lbuel|CJPOWERCAST|Alternative title fields query: select * from (select x.id,x.pgm_abs_id TitleId, x.pgm_parent_id VersionId from tm_mis x where id in (select /*+ cardinality(4) */ column_value id from table(:ids))) y,lateral (select dbms_lob.substr( o.text_data_plain, 1000, 1 ) Field_5799344 from tm_txt_obj o where (o.pgm_abs_id=y.TitleId or o.pgm_rl_id = y.VersionId) and o.type_id=:param_1 order by o.id desc fetch first 1 rows only)(+) t Information: 1220 : 12|08:21:04.3038|0lbuel|CJPOWERCAST| timing: 00:00:00.0225741 t Verbose: 1220 : 12|08:21:04.3038|0lbuel|CJPOWERCAST|imfx v3 API took 0.023s '/api/v3/search/Media?_dc=1655104863889' t Transfer: 1220 : 12|08:21:04.3038|0lbuel|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\MH26-002.png subfolder t Transfer: 1220 : 12|08:21:04.3038|0lbuel|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/MH26-002.png t Transfer: 1220 : 12|08:21:04.3038|0lbuel|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/MH26-002.png t Transfer: 1220 : 12|08:21:04.3038|0lbuel|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:21:04.3038|0lbuel|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:21:04.3048|0lbuel|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|08:21:07.5208|I80mlu|CJPOWERCAST|OAuth: /api/v3/search/Media?_dc=1655104867131 t Transfer: 1220 : 12|08:21:07.5208|I80mlu|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:21:07.5208|I80mlu|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:21:07.5208|I80mlu|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|08:21:07.5208|I80mlu|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|08:21:07.5208|I80mlu|CJPOWERCAST|V3Api.SearchMedia t Information: 1220 : 12|08:21:07.5208|I80mlu|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|08:21:07.5208|I80mlu|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:21:07.5208|I80mlu|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:21:07.5218|I80mlu|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|08:21:07.5218|I80mlu|CJPOWERCAST|MediaSearch SQL: select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type in (1,110)),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , (select 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", GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select a.*, rownum rnum from (select m.*, coalesce(m.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=m.pgm_parent_id)) primary_thumb_id2 from tmddba.tm_mis m where media_type>0 and item_type>0 AND m.ID = :param_0 and m.mi_deleted=0 AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0) order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl where rnum >= 1 order by rnum t Verbose: 1220 : 12|08:21:07.5218|I80mlu|CJPOWERCAST|Alternative title fields query: select * from (select x.id,x.pgm_abs_id TitleId, x.pgm_parent_id VersionId from tm_mis x where id in (select /*+ cardinality(4) */ column_value id from table(:ids))) y,lateral (select dbms_lob.substr( o.text_data_plain, 1000, 1 ) Field_5799344 from tm_txt_obj o where (o.pgm_abs_id=y.TitleId or o.pgm_rl_id = y.VersionId) and o.type_id=:param_1 order by o.id desc fetch first 1 rows only)(+) t Information: 1220 : 12|08:21:07.5218|I80mlu|CJPOWERCAST| timing: 00:00:00.0209736 t Verbose: 1220 : 12|08:21:07.5218|I80mlu|CJPOWERCAST|imfx v3 API took 0.021s '/api/v3/search/Media?_dc=1655104867131' t Transfer: 1220 : 12|08:21:07.5218|I80mlu|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\002.001_summer_palace_thumbnail_small_M0002041.png subfolder t Transfer: 1220 : 12|08:21:07.5218|I80mlu|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/002.001_summer_palace_thumbnail_small_M0002041.png t Transfer: 1220 : 12|08:21:07.5218|I80mlu|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/002.001_summer_palace_thumbnail_small_M0002041.png t Transfer: 1220 : 12|08:21:07.5218|I80mlu|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:21:07.5218|I80mlu|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:21:07.5218|I80mlu|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|08:21:12.3458|lGhL_6|CJPOWERCAST|OAuth: /api/v3/search/Media?_dc=1655104871910 t Transfer: 1220 : 12|08:21:12.3458|lGhL_6|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:21:12.3458|lGhL_6|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:21:12.3458|lGhL_6|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|08:21:12.3458|lGhL_6|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|08:21:12.3458|lGhL_6|CJPOWERCAST|V3Api.SearchMedia t Information: 1220 : 12|08:21:12.3458|lGhL_6|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|08:21:12.3458|lGhL_6|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:21:12.3458|lGhL_6|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:21:12.3468|lGhL_6|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|08:21:12.3468|lGhL_6|CJPOWERCAST|MediaSearch SQL: select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type in (1,110)),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , (select 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", GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select a.*, rownum rnum from (select m.*, coalesce(m.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=m.pgm_parent_id)) primary_thumb_id2 from tmddba.tm_mis m where media_type>0 and item_type>0 AND m.ID = :param_0 and m.mi_deleted=0 AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0) order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl where rnum >= 1 order by rnum t Verbose: 1220 : 12|08:21:12.3468|lGhL_6|CJPOWERCAST|Alternative title fields query: select * from (select x.id,x.pgm_abs_id TitleId, x.pgm_parent_id VersionId from tm_mis x where id in (select /*+ cardinality(4) */ column_value id from table(:ids))) y,lateral (select dbms_lob.substr( o.text_data_plain, 1000, 1 ) Field_5799344 from tm_txt_obj o where (o.pgm_abs_id=y.TitleId or o.pgm_rl_id = y.VersionId) and o.type_id=:param_1 order by o.id desc fetch first 1 rows only)(+) t Information: 1220 : 12|08:21:12.3468|lGhL_6|CJPOWERCAST| timing: 00:00:00.0200084 t Verbose: 1220 : 12|08:21:12.3468|lGhL_6|CJPOWERCAST|imfx v3 API took 0.020s '/api/v3/search/Media?_dc=1655104871910' t Transfer: 1220 : 12|08:21:12.3468|lGhL_6|CJPOWERCAST|GetUrl. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\04a2988a-1155-45d8-a068-8dfa0b9a343a\캡처3.PNG subfolder 04a2988a-1155-45d8-a068-8dfa0b9a343a\ t Transfer: 1220 : 12|08:21:12.3468|lGhL_6|CJPOWERCAST| GetFileName result https://demo.tmd.tv/Temp Upload/%EC%BA%A1%EC%B2%983.PNG t Transfer: 1220 : 12|08:21:12.3468|lGhL_6|CJPOWERCAST|GetUrl. result https://demo.tmd.tv/Temp Upload/%EC%BA%A1%EC%B2%983.PNG t Transfer: 1220 : 12|08:21:12.3468|lGhL_6|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:21:12.3468|lGhL_6|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:21:12.3478|lGhL_6|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|08:21:14.3578|mj8W7v|CJPOWERCAST|OAuth: /api/v3/search/Media?_dc=1655104873883 t Transfer: 1220 : 12|08:21:14.3578|mj8W7v|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:21:14.3578|mj8W7v|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:21:14.3578|mj8W7v|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|08:21:14.3578|mj8W7v|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|08:21:14.3578|mj8W7v|CJPOWERCAST|V3Api.SearchMedia t Information: 1220 : 12|08:21:14.3578|mj8W7v|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|08:21:14.3578|mj8W7v|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:21:14.3588|mj8W7v|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:21:14.3588|mj8W7v|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|08:21:14.3588|mj8W7v|CJPOWERCAST|MediaSearch SQL: select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type in (1,110)),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , (select 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", GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select a.*, rownum rnum from (select m.*, coalesce(m.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=m.pgm_parent_id)) primary_thumb_id2 from tmddba.tm_mis m where media_type>0 and item_type>0 AND m.ID = :param_0 and m.mi_deleted=0 AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0) order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl where rnum >= 1 order by rnum t Verbose: 1220 : 12|08:21:14.3588|mj8W7v|CJPOWERCAST|Alternative title fields query: select * from (select x.id,x.pgm_abs_id TitleId, x.pgm_parent_id VersionId from tm_mis x where id in (select /*+ cardinality(4) */ column_value id from table(:ids))) y,lateral (select dbms_lob.substr( o.text_data_plain, 1000, 1 ) Field_5799344 from tm_txt_obj o where (o.pgm_abs_id=y.TitleId or o.pgm_rl_id = y.VersionId) and o.type_id=:param_1 order by o.id desc fetch first 1 rows only)(+) t Information: 1220 : 12|08:21:14.3588|mj8W7v|CJPOWERCAST| timing: 00:00:00.0342410 t Verbose: 1220 : 12|08:21:14.3588|mj8W7v|CJPOWERCAST|imfx v3 API took 0.034s '/api/v3/search/Media?_dc=1655104873883' t Transfer: 1220 : 12|08:21:14.3588|mj8W7v|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\캡처3.PNG subfolder t Transfer: 1220 : 12|08:21:14.3588|mj8W7v|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/%EC%BA%A1%EC%B2%983.PNG t Transfer: 1220 : 12|08:21:14.3588|mj8W7v|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/%EC%BA%A1%EC%B2%983.PNG t Transfer: 1220 : 12|08:21:14.3588|mj8W7v|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|08:21:14.3588|mj8W7v|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|08:21:14.3598|mj8W7v|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|09:04:51.7206|lANIYO||OAuth: /api/user-preferences?keys=media.basket.data&_dc=1655107491617 t Transfer: 1220 : 12|09:04:51.7216|lANIYO||GetCurrentUser.. t Transfer: 1220 : 12|09:04:51.7216|lANIYO|| OAuth authenticated t Verbose: 1220 : 12|09:04:51.7216|lANIYO|| uid claim is missing.. t Information: 1220 : 12|09:04:51.7216|lANIYO||OAuth. AutoLogin no Windows identity type WindowsIdentity t Transfer: 1220 : 12|09:04:51.7216|RQqpHv||OAuth: /api/settings/user/defaultHomePage?_dc=1655107491623 t Transfer: 1220 : 12|09:04:51.7216|RQqpHv||GetCurrentUser.. t Transfer: 1220 : 12|09:04:51.7226|RQqpHv|| OAuth authenticated t Verbose: 1220 : 12|09:04:51.7226|RQqpHv|| uid claim is missing.. t Information: 1220 : 12|09:04:51.7226|RQqpHv||OAuth. AutoLogin no Windows identity type WindowsIdentity t Transfer: 1220 : 12|09:04:51.7226|XyCRdx||OAuth: /api/user-preferences?keys=color_schema&_dc=1655107491630 t Transfer: 1220 : 12|09:04:51.7226|XyCRdx||GetCurrentUser.. t Transfer: 1220 : 12|09:04:51.7226|XyCRdx|| OAuth authenticated t Verbose: 1220 : 12|09:04:51.7226|XyCRdx|| uid claim is missing.. t Information: 1220 : 12|09:04:51.7226|XyCRdx||OAuth. AutoLogin no Windows identity type WindowsIdentity t Transfer: 1220 : 12|09:04:51.7226|2j2959||OAuth: /api/settings/group/0?_dc=1655107491666 t Transfer: 1220 : 12|09:04:51.7226|2j2959||GetCurrentUser.. t Transfer: 1220 : 12|09:04:51.7226|2j2959|| OAuth authenticated t Verbose: 1220 : 12|09:04:51.7226|2j2959|| uid claim is missing.. t Information: 1220 : 12|09:04:51.7236|2j2959||OAuth. AutoLogin no Windows identity type WindowsIdentity t Transfer: 1220 : 12|09:04:51.7236|5e4fpQ||OAuth: /api/settings/user/uploadSettings?_dc=1655107491676 t Transfer: 1220 : 12|09:04:51.7236|5e4fpQ||GetCurrentUser.. t Transfer: 1220 : 12|09:04:51.7236|5e4fpQ|| OAuth authenticated t Verbose: 1220 : 12|09:04:51.7236|5e4fpQ|| uid claim is missing.. t Information: 1220 : 12|09:04:51.7236|5e4fpQ||OAuth. AutoLogin no Windows identity type WindowsIdentity t Transfer: 1220 : 12|09:04:51.7236|2JYKZ8||OAuth: /api/user-preferences?keys=media.basket.data&_dc=1655107491694 t Transfer: 1220 : 12|09:04:51.7236|2JYKZ8||GetCurrentUser.. t Transfer: 1220 : 12|09:04:51.7236|2JYKZ8|| OAuth authenticated t Verbose: 1220 : 12|09:04:51.7236|2JYKZ8|| uid claim is missing.. t Information: 1220 : 12|09:04:51.7236|2JYKZ8||OAuth. AutoLogin no Windows identity type WindowsIdentity t Transfer: 1220 : 12|09:04:51.9246|o3wmHs||OAuth: /api/settings/group/0?_dc=1655107491745 t Transfer: 1220 : 12|09:04:51.9246|o3wmHs||GetCurrentUser.. t Transfer: 1220 : 12|09:04:51.9246|o3wmHs|| OAuth authenticated t Verbose: 1220 : 12|09:04:51.9246|o3wmHs|| uid claim is missing.. t Information: 1220 : 12|09:04:51.9246|o3wmHs||OAuth. AutoLogin no Windows identity type WindowsIdentity t Transfer: 1220 : 12|09:04:51.9246|Q6YKEw||OAuth: /api/logout?_dc=1655107491869 t Transfer: 1220 : 12|09:04:51.9246|Q6YKEw||GetCurrentUser.. t Transfer: 1220 : 12|09:04:51.9246|Q6YKEw|| OAuth authenticated t Verbose: 1220 : 12|09:04:51.9256|Q6YKEw|| uid claim is missing.. t Information: 1220 : 12|09:04:51.9256|Q6YKEw||OAuth. AutoLogin no Windows identity type WindowsIdentity t Transfer: 1220 : 12|09:04:52.9306|EXufOW||GetAppInfo. DB: TMDDEMO. Install mode: . Auth types: Native, PublicApiKey t Verbose: 1220 : 12|09:04:53.1316|cb4DDt||imfx v3 API took 0.004s '/api/v3/visual-asset/group/null/2/image' t Transfer: 1220 : 12|10:33:10.7750|1U9fDQ||GetAppInfo. DB: TMDDEMO. Install mode: . Auth types: Native, PublicApiKey t Verbose: 1220 : 12|10:33:10.9770|d47s5L||imfx v3 API took 0.003s '/api/v3/visual-asset/group/null/2/image' t Transfer: 1220 : 12|10:40:13.1680|Y9qBfl|CJPOWERCAST|OAuth: /api/v3/search/Media?_dc=1655113211790 t Transfer: 1220 : 12|10:40:13.1680|Y9qBfl|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:40:13.1680|Y9qBfl|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:40:13.1680|Y9qBfl|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:40:13.1680|Y9qBfl|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|10:40:13.3690|Y9qBfl|CJPOWERCAST|V3Api.SearchMedia t Information: 1220 : 12|10:40:13.3690|Y9qBfl|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|10:40:13.3690|Y9qBfl|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:40:13.3690|Y9qBfl|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:40:13.3690|Y9qBfl|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|10:40:13.3690|Y9qBfl|CJPOWERCAST|MediaSearch SQL: select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type in (1,110)),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , (select 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", GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select a.*, rownum rnum from (select m.*, coalesce(m.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=m.pgm_parent_id)) primary_thumb_id2 from tmddba.tm_mis m where media_type>0 and item_type>0 AND m.ID = :param_0 and m.mi_deleted=0 AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0) order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl where rnum >= 1 order by rnum t Verbose: 1220 : 12|10:40:13.3690|Y9qBfl|CJPOWERCAST|Alternative title fields query: select * from (select x.id,x.pgm_abs_id TitleId, x.pgm_parent_id VersionId from tm_mis x where id in (select /*+ cardinality(4) */ column_value id from table(:ids))) y,lateral (select dbms_lob.substr( o.text_data_plain, 1000, 1 ) Field_5799344 from tm_txt_obj o where (o.pgm_abs_id=y.TitleId or o.pgm_rl_id = y.VersionId) and o.type_id=:param_1 order by o.id desc fetch first 1 rows only)(+) t Information: 1220 : 12|10:40:13.3690|Y9qBfl|CJPOWERCAST| timing: 00:00:00.0317349 t Verbose: 1220 : 12|10:40:13.3701|Y9qBfl|CJPOWERCAST|imfx v3 API took 0.032s '/api/v3/search/Media?_dc=1655113211790' t Transfer: 1220 : 12|10:40:13.3701|Y9qBfl|CJPOWERCAST|GetUrl. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\04a2988a-1155-45d8-a068-8dfa0b9a343a\캡처3.PNG subfolder 04a2988a-1155-45d8-a068-8dfa0b9a343a\ t Transfer: 1220 : 12|10:40:13.3701|Y9qBfl|CJPOWERCAST| GetFileName result https://demo.tmd.tv/Temp Upload/%EC%BA%A1%EC%B2%983.PNG t Transfer: 1220 : 12|10:40:13.3701|Y9qBfl|CJPOWERCAST|GetUrl. result https://demo.tmd.tv/Temp Upload/%EC%BA%A1%EC%B2%983.PNG t Transfer: 1220 : 12|10:40:13.3701|Y9qBfl|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:40:13.3701|Y9qBfl|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:40:13.3701|Y9qBfl|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|10:40:18.9980|96Jq9H|CJPOWERCAST|OAuth: /api/user-group-preferences?keys=googleMapsApiSettings&_dc=1655113218400 t Transfer: 1220 : 12|10:40:18.9980|96Jq9H|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:40:18.9980|96Jq9H|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:40:18.9980|96Jq9H|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:40:18.9980|96Jq9H|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|10:40:18.9980|96Jq9H|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:40:18.9980|96Jq9H|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:40:18.9980|96Jq9H|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:40:18.9980|96Jq9H|CJPOWERCAST|imfx v3 API took 0.011s '/api/user-group-preferences?keys=googleMapsApiSettings&_dc=1655113218400' t Transfer: 1220 : 12|10:40:18.9991|3Lh0sW|CJPOWERCAST|OAuth: /api/v3/title-details/299883?_dc=1655113218509 t Transfer: 1220 : 12|10:40:18.9991|3Lh0sW|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:40:18.9991|3Lh0sW|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:40:18.9991|3Lh0sW|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:40:18.9991|3Lh0sW|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 12|10:40:19.2000|3Lh0sW|CJPOWERCAST|imfx v3 API took 0.065s '/api/v3/title-details/299883?_dc=1655113218509' t Transfer: 1220 : 12|10:40:19.4011|wQB_xN|CJPOWERCAST|OAuth: /api/v3/detailsview/TitleDetails/0?lang=en-GB&_dc=1655113218923 t Transfer: 1220 : 12|10:40:19.4011|wQB_xN|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:40:19.4011|wQB_xN|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:40:19.4011|wQB_xN|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:40:19.4011|wQB_xN|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|10:40:19.4011|wQB_xN|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:40:19.4011|wQB_xN|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:40:19.4011|wQB_xN|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|10:40:19.4011|wQB_xN|CJPOWERCAST|GetSystemPref. Pref: DetailsView, Type: -4020, subType: 0 t Information: 1220 : 12|10:40:19.4021|wQB_xN|CJPOWERCAST|GetSystemPref. Pref: DetailsView, Type: -4020, subType: 0 t Verbose: 1220 : 12|10:40:19.4021|wQB_xN|CJPOWERCAST|imfx v3 API took 0.027s '/api/v3/detailsview/TitleDetails/0?lang=en-GB&_dc=1655113218923' t Transfer: 1220 : 12|10:40:19.8040|6dm96U|CJPOWERCAST|OAuth: /api/lookups/FriendlyNames?_dc=1655113219286 t Transfer: 1220 : 12|10:40:19.8040|6dm96U|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:40:19.8040|6dm96U|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:40:19.8040|6dm96U|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:40:19.8040|6dm96U|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 12|10:40:19.8040|6dm96U|CJPOWERCAST|imfx v3 API took 0.000s '/api/lookups/FriendlyNames?_dc=1655113219286' t Transfer: 1220 : 12|10:40:24.8290|Bmcm2X|CJPOWERCAST|OAuth: /api/v3/search/Media?_dc=1655113224336 t Transfer: 1220 : 12|10:40:24.8290|Bmcm2X|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:40:24.8290|Bmcm2X|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:40:24.8290|Bmcm2X|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:40:24.8290|Bmcm2X|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|10:40:24.8290|Bmcm2X|CJPOWERCAST|V3Api.SearchMedia t Information: 1220 : 12|10:40:24.8290|Bmcm2X|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|10:40:24.8290|Bmcm2X|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:40:24.8290|Bmcm2X|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:40:24.8290|Bmcm2X|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|10:40:24.8300|Bmcm2X|CJPOWERCAST|MediaSearch SQL: select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type in (1,110)),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , (SELECT SUBSTR( trim( replace (replace ( LISTAGG(trim(tt.tags || ' ' || tt.notes), ' ') WITHIN GROUP (ORDER BY trim(tt.tags || ' ' || tt.notes)), chr (13), ''), chr (10), ' ')), 1, 150) z FROM tm_media_tagging tt WHERE link_guid = DFILE_LINK_GUID and rownum=1) TAGS_TEXT , GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select a.*, rownum rnum from (select m.*, coalesce(m.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=m.pgm_parent_id)) primary_thumb_id2 from tmddba.tm_mis m where media_type>0 and item_type>0 AND m.ID = :param_0 and m.mi_deleted=0 AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0) order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl where rnum >= 1 order by rnum t Information: 1220 : 12|10:40:25.0310|Bmcm2X|CJPOWERCAST| timing: 00:00:00.0777843 t Verbose: 1220 : 12|10:40:25.0310|Bmcm2X|CJPOWERCAST|imfx v3 API took 0.078s '/api/v3/search/Media?_dc=1655113224336' t Transfer: 1220 : 12|10:40:25.0310|Bmcm2X|CJPOWERCAST|GetUrl. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\04a2988a-1155-45d8-a068-8dfa0b9a343a\캡처3.PNG subfolder 04a2988a-1155-45d8-a068-8dfa0b9a343a\ t Transfer: 1220 : 12|10:40:25.0310|Bmcm2X|CJPOWERCAST| GetFileName result https://demo.tmd.tv/Temp Upload/%EC%BA%A1%EC%B2%983.PNG t Transfer: 1220 : 12|10:40:25.0310|Bmcm2X|CJPOWERCAST|GetUrl. result https://demo.tmd.tv/Temp Upload/%EC%BA%A1%EC%B2%983.PNG t Transfer: 1220 : 12|10:40:25.0310|Bmcm2X|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:40:25.0310|Bmcm2X|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:40:25.0310|Bmcm2X|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|10:40:29.6540|uoJXSB|CJPOWERCAST|OAuth: /api/v3/search/Media?_dc=1655113229116 t Transfer: 1220 : 12|10:40:29.6540|uoJXSB|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:40:29.6540|uoJXSB|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:40:29.6540|uoJXSB|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:40:29.6540|uoJXSB|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|10:40:29.6540|uoJXSB|CJPOWERCAST|V3Api.SearchMedia t Information: 1220 : 12|10:40:29.6540|uoJXSB|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|10:40:29.6540|uoJXSB|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:40:29.6540|uoJXSB|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:40:29.6550|uoJXSB|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|10:40:29.6550|uoJXSB|CJPOWERCAST|MediaSearch SQL: select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type in (1,110)),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , (select 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", GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select a.*, rownum rnum from (select m.*, coalesce(m.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=m.pgm_parent_id)) primary_thumb_id2 from tmddba.tm_mis m where media_type>0 and item_type>0 AND m.ID = :param_0 and m.mi_deleted=0 AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0) order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl where rnum >= 1 order by rnum t Verbose: 1220 : 12|10:40:29.6550|uoJXSB|CJPOWERCAST|Alternative title fields query: select * from (select x.id,x.pgm_abs_id TitleId, x.pgm_parent_id VersionId from tm_mis x where id in (select /*+ cardinality(4) */ column_value id from table(:ids))) y,lateral (select dbms_lob.substr( o.text_data_plain, 1000, 1 ) Field_5799344 from tm_txt_obj o where (o.pgm_abs_id=y.TitleId or o.pgm_rl_id = y.VersionId) and o.type_id=:param_1 order by o.id desc fetch first 1 rows only)(+) t Information: 1220 : 12|10:40:29.6550|uoJXSB|CJPOWERCAST| timing: 00:00:00.0284211 t Verbose: 1220 : 12|10:40:29.6550|uoJXSB|CJPOWERCAST|imfx v3 API took 0.029s '/api/v3/search/Media?_dc=1655113229116' t Transfer: 1220 : 12|10:40:29.6550|uoJXSB|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\원본-자막기Export비교2.PNG subfolder t Transfer: 1220 : 12|10:40:29.6550|uoJXSB|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/%EC%9B%90%EB%B3%B8-%EC%9E%90%EB%A7%89%EA%B8%B0Export%EB%B9%84%EA%B5%902.PNG t Transfer: 1220 : 12|10:40:29.6550|uoJXSB|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/%EC%9B%90%EB%B3%B8-%EC%9E%90%EB%A7%89%EA%B8%B0Export%EB%B9%84%EA%B5%902.PNG t Transfer: 1220 : 12|10:40:29.6550|uoJXSB|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:40:29.6550|uoJXSB|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:40:29.6550|uoJXSB|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|10:40:58.7981|Hth3xx|CJPOWERCAST|OAuth: /api/v3/search/Media?_dc=1655113258233 t Transfer: 1220 : 12|10:40:58.7981|Hth3xx|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:40:58.7981|Hth3xx|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:40:58.7981|Hth3xx|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|10:40:58.7981|Hth3xx|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|10:40:58.7981|Hth3xx|CJPOWERCAST|V3Api.SearchMedia t Information: 1220 : 12|10:40:58.7981|Hth3xx|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|10:40:58.7981|Hth3xx|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:40:58.7981|Hth3xx|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:40:58.7991|Hth3xx|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|10:40:58.7991|Hth3xx|CJPOWERCAST|MediaSearch SQL: select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type in (1,110)),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , (select 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", GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select a.*, rownum rnum from (select m.*, coalesce(m.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=m.pgm_parent_id)) primary_thumb_id2 from tmddba.tm_mis m where media_type>0 and item_type>0 AND m.ID = :param_0 and m.mi_deleted=0 AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0) order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl where rnum >= 1 order by rnum t Verbose: 1220 : 12|10:40:58.7991|Hth3xx|CJPOWERCAST|Alternative title fields query: select * from (select x.id,x.pgm_abs_id TitleId, x.pgm_parent_id VersionId from tm_mis x where id in (select /*+ cardinality(4) */ column_value id from table(:ids))) y,lateral (select dbms_lob.substr( o.text_data_plain, 1000, 1 ) Field_5799344 from tm_txt_obj o where (o.pgm_abs_id=y.TitleId or o.pgm_rl_id = y.VersionId) and o.type_id=:param_1 order by o.id desc fetch first 1 rows only)(+) t Information: 1220 : 12|10:40:58.7991|Hth3xx|CJPOWERCAST| timing: 00:00:00.0296096 t Verbose: 1220 : 12|10:40:58.7991|Hth3xx|CJPOWERCAST|imfx v3 API took 0.030s '/api/v3/search/Media?_dc=1655113258233' t Transfer: 1220 : 12|10:40:58.7991|Hth3xx|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\원본-자막기Export비교1.PNG subfolder t Transfer: 1220 : 12|10:40:58.7991|Hth3xx|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/%EC%9B%90%EB%B3%B8-%EC%9E%90%EB%A7%89%EA%B8%B0Export%EB%B9%84%EA%B5%901.PNG t Transfer: 1220 : 12|10:40:58.7991|Hth3xx|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/%EC%9B%90%EB%B3%B8-%EC%9E%90%EB%A7%89%EA%B8%B0Export%EB%B9%84%EA%B5%901.PNG t Transfer: 1220 : 12|10:40:58.7991|Hth3xx|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|10:40:58.7991|Hth3xx|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|10:40:58.7991|Hth3xx|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|15:25:06.4081|x_IUh1||GetAppInfo. DB: TMDDEMO. Install mode: . Auth types: Native, PublicApiKey t Verbose: 1220 : 12|15:25:06.6091|bOPagD||imfx v3 API took 0.004s '/api/v3/visual-asset/group/null/2/image' t Transfer: 1220 : 12|21:35:45.1699|LpBkRd||GetAppInfo. DB: TMDDEMO. Install mode: . Auth types: Native, PublicApiKey t Verbose: 1220 : 12|21:35:45.3709|UGKmVQ||imfx v3 API took 0.004s '/api/v3/visual-asset/group/null/2/image' t Information: 1220 : 12|23:14:24.6076|||OrabitWatcherBasic. Disposing. t Information: 1220 : 12|23:14:24.6076|||OrabitWatcherBasic. Disposed. t Information: 1220 : 12|23:14:24.6086|||========================================================================== t Information: 1220 : 12|23:14:24.6086|||IMFX CORE SERVER APPLICATION END.