t Transfer: 1220 : 12|02:48:22.8611|Cw1mCg||GetAppInfo. DB: TMDDEMO. Install mode: . Auth types: Native, PublicApiKey
t Verbose: 1220 : 12|02:48:23.2631|_Px5dd||imfx v3 API took 0.004s '/api/v3/visual-asset/group/null/2/image'
t Verbose: 1220 : 12|02:48:36.5291|g7CVsb||Oauth validating..
t Verbose: 1220 : 12|02:48:36.5291|g7CVsb||GrantResourceOwnerCredentials.
t Verbose: 1220 : 12|02:48:36.5291|g7CVsb||LoginUser. cjpowercast, login type OAuth, encrypt password True
t Information: 1220 : 12|02:48:36.5301|g7CVsb||TryLoginUser. cjpowercast, login type OAuth, check password True, check hash False, encrypt password True, load user data False
t Information: 1220 : 12|02:48:36.5311|g7CVsb|| oauth token 00000000-0000-0000-0000-000000000000
t Information: 1220 : 12|02:48:36.5311|g7CVsb||TryLoginUser. Logged in..
t Verbose: 1220 : 12|02:48:36.5311|g7CVsb||LoginUser. Adding history. User Id 1165, result CJPOWERCAST, host 192.168.127.6
t Verbose: 1220 : 12|02:48:36.5311|g7CVsb||GrantResourceOwnerCredentials. Try login finished. Logged: True
t Transfer: 1220 : 12|02:48:36.9331|eYRHba|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=1663292909806
t Transfer: 1220 : 12|02:48:36.9331|eYRHba|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:48:36.9331|eYRHba|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:48:36.9331|eYRHba|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:48:36.9331|eYRHba|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 : 12|02:48:36.9331|eYRHba|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:48:36.9331|eYRHba|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:48:36.9331|eYRHba|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:48:36.9331|eYRHba|CJPOWERCAST|imfx v3 API took 0.041s '/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=1663292909806'
t Transfer: 1220 : 12|02:48:37.3361|Nmf74N|CJPOWERCAST|OAuth: /api/user-preferences?keys=personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch;workflow_queues_actions;workflow_queues_settings&_dc=1663292910132
t Transfer: 1220 : 12|02:48:37.3361|Nmf74N|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:48:37.3361|Nmf74N|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:48:37.3361|Nmf74N|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:48:37.3361|Nmf74N|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 : 12|02:48:37.3361|Nmf74N|CJPOWERCAST|GetUserDataByKeys: personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch;workflow_queues_actions;workflow_queues_settings
t Transfer: 1220 : 12|02:48:37.3361|Nmf74N|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:48:37.3361|Nmf74N|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:48:37.3371|Nmf74N|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:48:37.3371|Nmf74N|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=1663292910132'
t Information: 1220 : 12|02:48:37.5381|TFBaX_|CJPOWERCAST|GetUserProfile. Id: 0
t Transfer: 1220 : 12|02:48:37.5381|TFBaX_|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:48:37.5381|TFBaX_|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:48:37.5381|TFBaX_|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:48:37.9401|SMe61k|CJPOWERCAST|OAuth: /api/settings/group/0?_dc=1663292910844
t Transfer: 1220 : 12|02:48:37.9401|SMe61k|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:48:37.9401|SMe61k|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:48:37.9401|SMe61k|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:48:37.9411|SMe61k|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 : 12|02:48:37.9411|Tf1x0M|CJPOWERCAST|OAuth: /api/settings/user/uploadSettings?_dc=1663292910857
t Transfer: 1220 : 12|02:48:37.9411|Tf1x0M|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:48:37.9411|Tf1x0M|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:48:37.9411|Tf1x0M|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:48:37.9411|Tf1x0M|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 : 12|02:48:37.9411|RVVcn3|CJPOWERCAST|OAuth: /api/settings/group/0?_dc=1663292910884
t Transfer: 1220 : 12|02:48:37.9411|RVVcn3|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:48:37.9421|RVVcn3|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:48:37.9421|RVVcn3|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:48:37.9421|RVVcn3|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 : 12|02:48:37.9421|1TK_cP|CJPOWERCAST|OAuth: /api/lookups/MediaStatus?_dc=1663292910891
t Transfer: 1220 : 12|02:48:37.9421|1TK_cP|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:48:37.9431|1TK_cP|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:48:37.9431|1TK_cP|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:48:37.9431|1TK_cP|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Verbose: 1220 : 12|02:48:38.1441|SMe61k|CJPOWERCAST|imfx v3 API took 0.092s '/api/settings/group/0?_dc=1663292910844'
t Transfer: 1220 : 12|02:48:38.1441|Tf1x0M|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:48:38.1441|Tf1x0M|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:48:38.1441|Tf1x0M|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:48:38.1441|1TK_cP|CJPOWERCAST|imfx v3 API took 0.000s '/api/lookups/MediaStatus?_dc=1663292910891'
t Information: 1220 : 12|02:48:38.1441|ivLSPR||GetCache.
t Information: 1220 : 12|02:48:38.1441|ivLSPR||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\201_0_Any_gO.png
t Information: 1220 : 12|02:48:38.1441|ivLSPR||GetCache. Data read: 0
t Verbose: 1220 : 12|02:48:38.1441|ivLSPR||imfx v3 API took 0.172s '/api/v3/visual-asset/group/Any_gO/0/image'
t Verbose: 1220 : 12|02:48:38.1452|Tf1x0M|CJPOWERCAST|imfx v3 API took 0.080s '/api/settings/user/uploadSettings?_dc=1663292910857'
t Transfer: 1220 : 12|02:48:38.3461|S5bc3W|CJPOWERCAST|OAuth: /api/lookups/PgmStatus?_dc=1663292910892
t Transfer: 1220 : 12|02:48:38.3461|S5bc3W|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:48:38.3461|S5bc3W|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:48:38.3461|S5bc3W|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:48:38.3461|S5bc3W|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Verbose: 1220 : 12|02:48:38.3461|S5bc3W|CJPOWERCAST|imfx v3 API took 0.000s '/api/lookups/PgmStatus?_dc=1663292910892'
t Verbose: 1220 : 12|02:48:38.3461|RVVcn3|CJPOWERCAST|imfx v3 API took 0.311s '/api/settings/group/0?_dc=1663292910884'
t Transfer: 1220 : 12|02:48:38.5471|xZXhox|CJPOWERCAST|OAuth: /api/lookup/CustomMediaStatusTypes?_dc=1663292910893
t Transfer: 1220 : 12|02:48:38.5471|xZXhox|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:48:38.5471|xZXhox|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:48:38.5471|xZXhox|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:48:38.5471|xZXhox|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 : 12|02:48:38.5481|ZQlJha|CJPOWERCAST|OAuth: /api/lookup/CustomVersionStatusTypes?_dc=1663292910893
t Transfer: 1220 : 12|02:48:38.5481|ZQlJha|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:48:38.5481|ZQlJha|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:48:38.5481|ZQlJha|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:48:38.5481|ZQlJha|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 : 12|02:48:38.5481|tqS7sc|CJPOWERCAST|OAuth: /api/lookup/CustomTitleStatusTypes?_dc=1663292910894
t Transfer: 1220 : 12|02:48:38.5481|tqS7sc|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:48:38.5492|tqS7sc|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:48:38.5492|tqS7sc|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:48:38.5492|tqS7sc|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Verbose: 1220 : 12|02:48:38.5492|xZXhox|CJPOWERCAST|imfx v3 API took 0.027s '/api/lookup/CustomMediaStatusTypes?_dc=1663292910893'
t Verbose: 1220 : 12|02:48:38.5492|ZQlJha|CJPOWERCAST|imfx v3 API took 0.047s '/api/lookup/CustomVersionStatusTypes?_dc=1663292910893'
t Verbose: 1220 : 12|02:48:38.5492|tqS7sc|CJPOWERCAST|imfx v3 API took 0.041s '/api/lookup/CustomTitleStatusTypes?_dc=1663292910894'
t Transfer: 1220 : 12|02:48:38.5501|F~yE5Z|CJPOWERCAST|OAuth: /api/settings/user/defaultHomePage?_dc=1663292910895
t Transfer: 1220 : 12|02:48:38.5501|F~yE5Z|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:48:38.5501|F~yE5Z|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:48:38.5501|F~yE5Z|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:48:38.5512|F~yE5Z|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 : 12|02:48:38.5512|F~yE5Z|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:48:38.5512|F~yE5Z|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:48:38.5512|F~yE5Z|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:48:38.5512|F~yE5Z|CJPOWERCAST|imfx v3 API took 0.013s '/api/settings/user/defaultHomePage?_dc=1663292910895'
t Information: 1220 : 12|02:48:38.5512|Qu3cVv||GetCache.
t Information: 1220 : 12|02:48:38.5512|Qu3cVv||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\202_1_Any_gO.png
t Information: 1220 : 12|02:48:38.5512|Qu3cVv||GetCache. Data read: 0
t Verbose: 1220 : 12|02:48:38.5512|Qu3cVv||imfx v3 API took 0.004s '/api/v3/visual-asset/group/Any_gO/1/image'
t Transfer: 1220 : 12|02:48:40.3601|loR~gE|CJPOWERCAST|OAuth: /api/settings/user/defaultSearch?_dc=1663292913247
t Transfer: 1220 : 12|02:48:40.3601|loR~gE|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:48:40.3601|loR~gE|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:48:40.3601|loR~gE|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:48:40.3601|loR~gE|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 : 12|02:48:40.3611|Y16Otz|CJPOWERCAST|OAuth: /api/settings/user/startSearch?_dc=1663292913248
t Transfer: 1220 : 12|02:48:40.3611|Y16Otz|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:48:40.3611|Y16Otz|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:48:40.3611|Y16Otz|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:48:40.3611|Y16Otz|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 : 12|02:48:40.3611|loR~gE|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:48:40.3611|loR~gE|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:48:40.3621|loR~gE|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:48:40.3621|Y16Otz|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:48:40.3621|Y16Otz|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:48:40.3621|Y16Otz|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:48:40.3621|loR~gE|CJPOWERCAST|imfx v3 API took 0.009s '/api/settings/user/defaultSearch?_dc=1663292913247'
t Verbose: 1220 : 12|02:48:40.3621|Y16Otz|CJPOWERCAST|imfx v3 API took 0.011s '/api/settings/user/startSearch?_dc=1663292913248'
t Transfer: 1220 : 12|02:48:40.7641|fimkhm|CJPOWERCAST|OAuth: /api/user-preferences?keys=consumer.recent.data&_dc=1663292913540
t Transfer: 1220 : 12|02:48:40.7641|fimkhm|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:48:40.7641|fimkhm|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:48:40.7641|fimkhm|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:48:40.7641|fimkhm|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 : 12|02:48:40.7641|fimkhm|CJPOWERCAST|GetUserDataByKeys: consumer.recent.data
t Transfer: 1220 : 12|02:48:40.7641|fimkhm|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:48:40.7641|fimkhm|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:48:40.7641|fimkhm|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:48:40.7651|xKE~N3|CJPOWERCAST|OAuth: /api/user-preferences?keys=adv.recent.searches.consumer&_dc=1663292913546
t Transfer: 1220 : 12|02:48:40.7651|xKE~N3|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:48:40.7651|xKE~N3|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:48:40.7651|xKE~N3|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:48:40.7651|xKE~N3|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 : 12|02:48:40.7651|xKE~N3|CJPOWERCAST|GetUserDataByKeys: adv.recent.searches.consumer
t Transfer: 1220 : 12|02:48:40.7651|xKE~N3|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:48:40.7651|xKE~N3|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:48:40.7651|xKE~N3|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:48:40.7661|fimkhm|CJPOWERCAST|imfx v3 API took 0.007s '/api/user-preferences?keys=consumer.recent.data&_dc=1663292913540'
t Verbose: 1220 : 12|02:48:40.7661|xKE~N3|CJPOWERCAST|imfx v3 API took 0.006s '/api/user-preferences?keys=adv.recent.searches.consumer&_dc=1663292913546'
t Information: 1220 : 12|02:48:40.7661|ZjUyHv||GetCache.
t Information: 1220 : 12|02:48:40.7661|ZjUyHv||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\204_3_Any_gO.png
t Information: 1220 : 12|02:48:40.7661|ZjUyHv||GetCache. Data read: 5504
t Verbose: 1220 : 12|02:48:40.7661|ZjUyHv||imfx v3 API took 0.004s '/api/v3/visual-asset/group/Any_gO/3/image'
t Transfer: 1220 : 12|02:48:50.6151|9uAEar|CJPOWERCAST|OAuth: /api/user-preferences?keys=adv.recent.searches.media&_dc=1663292923566
t Transfer: 1220 : 12|02:48:50.6151|9uAEar|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:48:50.6151|9uAEar|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:48:50.6151|9uAEar|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:48:50.6161|9uAEar|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 : 12|02:48:50.6161|uwvrZt|CJPOWERCAST|OAuth: /api/view/searchinfo/Media?_dc=1663292923564
t Transfer: 1220 : 12|02:48:50.6161|uwvrZt|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:48:50.6161|uwvrZt|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:48:50.6161|uwvrZt|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:48:50.6171|uwvrZt|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 : 12|02:48:50.6171|Wr6z_N|CJPOWERCAST|OAuth: /api/lookups/SearchSupportedOperators?_dc=1663292923565
t Transfer: 1220 : 12|02:48:50.6171|Wr6z_N|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:48:50.6171|Wr6z_N|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:48:50.6171|Wr6z_N|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:48:50.6171|Wr6z_N|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 : 12|02:48:50.6171|9uAEar|CJPOWERCAST|GetUserDataByKeys: adv.recent.searches.media
t Transfer: 1220 : 12|02:48:50.6181|9uAEar|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:48:50.6181|9uAEar|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:48:50.6181|9uAEar|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:48:50.6181|Wr6z_N|CJPOWERCAST|imfx v3 API took 0.001s '/api/lookups/SearchSupportedOperators?_dc=1663292923565'
t Information: 1220 : 12|02:48:50.6191|uwvrZt|CJPOWERCAST|GetAdvSearchColumns. search type Media grid .
t Verbose: 1220 : 12|02:48:50.6191|uwvrZt|CJPOWERCAST|imfx v3 API took 0.002s '/api/view/searchinfo/Media?_dc=1663292923564'
t Verbose: 1220 : 12|02:48:50.6191|9uAEar|CJPOWERCAST|imfx v3 API took 0.008s '/api/user-preferences?keys=adv.recent.searches.media&_dc=1663292923566'
t Transfer: 1220 : 12|02:48:50.8201|nfDHfB|CJPOWERCAST|OAuth: /api/view/searches/Media?_dc=1663292923592
t Transfer: 1220 : 12|02:48:50.8201|nfDHfB|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:48:50.8201|nfDHfB|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:48:50.8201|nfDHfB|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:48:50.8201|nfDHfB|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 : 12|02:48:50.8201|hlSNRy|CJPOWERCAST|OAuth: /api/settings/user/searchLayoutConfig?_dc=1663292923595
t Transfer: 1220 : 12|02:48:50.8201|hlSNRy|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:48:50.8212|hlSNRy|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:48:50.8212|hlSNRy|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:48:50.8212|hlSNRy|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 : 12|02:48:50.8212|l_kCVy|CJPOWERCAST|OAuth: /api/view/info/MediaGrid?lang=en-GB&_dc=1663292923595
t Transfer: 1220 : 12|02:48:50.8212|l_kCVy|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:48:50.8212|l_kCVy|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:48:50.8212|l_kCVy|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:48:50.8212|l_kCVy|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 : 12|02:48:50.8212|hlSNRy|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:48:50.8212|hlSNRy|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:48:50.8221|hlSNRy|CJPOWERCAST| user CJPOWERCAST.
t Information: 1220 : 12|02:48:50.8221|nfDHfB|CJPOWERCAST|GetSavedSearchNames. search type Media.
t Transfer: 1220 : 12|02:48:50.8221|nfDHfB|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:48:50.8221|nfDHfB|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:48:50.8221|nfDHfB|CJPOWERCAST| user CJPOWERCAST.
t Information: 1220 : 12|02:48:50.8221|l_kCVy|CJPOWERCAST|GetGridViewBuilder. builder type MediaGrid.
t Transfer: 1220 : 12|02:48:50.8221|l_kCVy|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:48:50.8221|l_kCVy|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:48:50.8221|l_kCVy|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:48:50.8221|hlSNRy|CJPOWERCAST|imfx v3 API took 0.007s '/api/settings/user/searchLayoutConfig?_dc=1663292923595'
t Information: 1220 : 12|02:48:50.8231|l_kCVy|CJPOWERCAST|UserGridView. LoadView. ID -2, Name Default.
t Transfer: 1220 : 12|02:48:50.8231|l_kCVy|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:48:50.8231|l_kCVy|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:48:50.8231|l_kCVy|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:48:50.8231|l_kCVy|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:48:50.8231|l_kCVy|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:48:50.8231|l_kCVy|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:48:50.8231|nfDHfB|CJPOWERCAST|imfx v3 API took 0.084s '/api/view/searches/Media?_dc=1663292923592'
t Verbose: 1220 : 12|02:48:50.8242|l_kCVy|CJPOWERCAST|imfx v3 API took 0.088s '/api/view/info/MediaGrid?lang=en-GB&_dc=1663292923595'
t Transfer: 1220 : 12|02:48:52.6321|bjkOUW|CJPOWERCAST|OAuth: /api/settings/user/defaultSearch?_dc=1663292925400
t Transfer: 1220 : 12|02:48:52.6321|bjkOUW|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:48:52.6321|bjkOUW|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:48:52.6321|bjkOUW|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:48:52.6321|bjkOUW|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 : 12|02:48:52.6321|3oAtbn|CJPOWERCAST|OAuth: /api/settings/user/startSearch?_dc=1663292925401
t Transfer: 1220 : 12|02:48:52.6321|3oAtbn|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:48:52.6321|3oAtbn|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:48:52.6321|3oAtbn|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:48:52.6331|3oAtbn|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 : 12|02:48:52.6331|bjkOUW|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:48:52.6331|bjkOUW|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:48:52.6331|bjkOUW|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:48:52.6331|3oAtbn|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:48:52.6331|3oAtbn|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:48:52.6331|3oAtbn|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:48:52.6331|bjkOUW|CJPOWERCAST|imfx v3 API took 0.006s '/api/settings/user/defaultSearch?_dc=1663292925400'
t Verbose: 1220 : 12|02:48:52.6331|3oAtbn|CJPOWERCAST|imfx v3 API took 0.006s '/api/settings/user/startSearch?_dc=1663292925401'
t Transfer: 1220 : 12|02:48:52.8341|y_96Bc|CJPOWERCAST|OAuth: /api/user-preferences?keys=adv.recent.searches.consumer&_dc=1663292925691
t Transfer: 1220 : 12|02:48:52.8341|y_96Bc|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:48:52.8341|y_96Bc|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:48:52.8341|y_96Bc|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:48:52.8341|y_96Bc|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 : 12|02:48:52.8351|icGkAn|CJPOWERCAST|OAuth: /api/user-preferences?keys=consumer.recent.data&_dc=1663292925689
t Transfer: 1220 : 12|02:48:52.8351|icGkAn|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:48:52.8351|icGkAn|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:48:52.8351|icGkAn|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:48:52.8351|icGkAn|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 : 12|02:48:52.8351|icGkAn|CJPOWERCAST|GetUserDataByKeys: consumer.recent.data
t Transfer: 1220 : 12|02:48:52.8351|icGkAn|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:48:52.8351|icGkAn|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:48:52.8351|icGkAn|CJPOWERCAST| user CJPOWERCAST.
t Information: 1220 : 12|02:48:52.8351|y_96Bc|CJPOWERCAST|GetUserDataByKeys: adv.recent.searches.consumer
t Transfer: 1220 : 12|02:48:52.8351|y_96Bc|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:48:52.8361|y_96Bc|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:48:52.8361|y_96Bc|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:48:52.8361|icGkAn|CJPOWERCAST|imfx v3 API took 0.005s '/api/user-preferences?keys=consumer.recent.data&_dc=1663292925689'
t Verbose: 1220 : 12|02:48:52.8361|y_96Bc|CJPOWERCAST|imfx v3 API took 0.007s '/api/user-preferences?keys=adv.recent.searches.consumer&_dc=1663292925691'
t Transfer: 1220 : 12|02:49:04.4941|SmTDT1|CJPOWERCAST|OAuth: /api/settings/user/defaultSearch?_dc=1663292937283
t Transfer: 1220 : 12|02:49:04.4941|SmTDT1|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:49:04.4941|SmTDT1|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:49:04.4941|SmTDT1|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:49:04.4941|SmTDT1|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 : 12|02:49:04.4951|6KN9vl|CJPOWERCAST|OAuth: /api/settings/user/startSearch?_dc=1663292937284
t Transfer: 1220 : 12|02:49:04.4951|6KN9vl|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:49:04.4951|6KN9vl|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:49:04.4951|6KN9vl|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:49:04.4951|6KN9vl|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 : 12|02:49:04.4951|SmTDT1|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:49:04.4951|SmTDT1|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:49:04.4961|SmTDT1|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:49:04.4961|6KN9vl|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:49:04.4961|6KN9vl|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:49:04.4961|6KN9vl|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:49:04.4961|SmTDT1|CJPOWERCAST|imfx v3 API took 0.004s '/api/settings/user/defaultSearch?_dc=1663292937283'
t Verbose: 1220 : 12|02:49:04.4961|6KN9vl|CJPOWERCAST|imfx v3 API took 0.004s '/api/settings/user/startSearch?_dc=1663292937284'
t Transfer: 1220 : 12|02:49:04.6971|Dv3Qfx|CJPOWERCAST|OAuth: /api/user-preferences?keys=adv.recent.searches.consumer&_dc=1663292937568
t Transfer: 1220 : 12|02:49:04.6971|Dv3Qfx|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:49:04.6971|Dv3Qfx|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:49:04.6971|Dv3Qfx|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:49:04.6971|Dv3Qfx|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 : 12|02:49:04.6971|RKHwQr|CJPOWERCAST|OAuth: /api/user-preferences?keys=consumer.recent.data&_dc=1663292937567
t Transfer: 1220 : 12|02:49:04.6971|RKHwQr|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:49:04.6971|RKHwQr|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:49:04.6971|RKHwQr|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:49:04.6971|RKHwQr|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 : 12|02:49:04.6982|Dv3Qfx|CJPOWERCAST|GetUserDataByKeys: adv.recent.searches.consumer
t Transfer: 1220 : 12|02:49:04.6982|Dv3Qfx|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:49:04.6982|Dv3Qfx|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:49:04.6982|Dv3Qfx|CJPOWERCAST| user CJPOWERCAST.
t Information: 1220 : 12|02:49:04.6982|RKHwQr|CJPOWERCAST|GetUserDataByKeys: consumer.recent.data
t Transfer: 1220 : 12|02:49:04.6982|RKHwQr|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:49:04.6982|RKHwQr|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:49:04.6982|RKHwQr|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:49:04.6982|Dv3Qfx|CJPOWERCAST|imfx v3 API took 0.011s '/api/user-preferences?keys=adv.recent.searches.consumer&_dc=1663292937568'
t Verbose: 1220 : 12|02:49:04.6982|RKHwQr|CJPOWERCAST|imfx v3 API took 0.005s '/api/user-preferences?keys=consumer.recent.data&_dc=1663292937567'
t Transfer: 1220 : 12|02:49:08.3182|hKeNSp|CJPOWERCAST|OAuth: /api/lookups/Channels?_dc=1663292941108
t Transfer: 1220 : 12|02:49:08.3182|hKeNSp|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:49:08.3182|hKeNSp|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:49:08.3182|hKeNSp|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:49:08.3182|hKeNSp|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 : 12|02:49:08.3191|ofP8Ut|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:49:08.3191|ofP8Ut|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:49:08.3191|ofP8Ut|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:49:08.3191|hKeNSp|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:49:08.3191|hKeNSp|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:49:08.3191|hKeNSp|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:49:08.3191|LPHiHA|CJPOWERCAST|OAuth: /api/lookups/MediaFileTypes?_dc=1663292941114
t Transfer: 1220 : 12|02:49:08.3201|LPHiHA|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:49:08.3201|LPHiHA|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:49:08.3201|LPHiHA|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:49:08.3201|LPHiHA|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Verbose: 1220 : 12|02:49:08.3201|LPHiHA|CJPOWERCAST|imfx v3 API took 0.000s '/api/lookups/MediaFileTypes?_dc=1663292941114'
t Transfer: 1220 : 12|02:49:08.3201|9ofOtH|CJPOWERCAST|OAuth: /api/lookups/UsageTypes?_dc=1663292941119
t Transfer: 1220 : 12|02:49:08.3201|9ofOtH|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:49:08.3211|9ofOtH|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:49:08.3211|9ofOtH|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:49:08.3211|9ofOtH|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 : 12|02:49:08.3211|ZJyKJr|CJPOWERCAST|OAuth: /api/lookups/ItemTypes?_dc=1663292941124
t Transfer: 1220 : 12|02:49:08.3211|ZJyKJr|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:49:08.3211|ZJyKJr|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:49:08.3211|ZJyKJr|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:49:08.3221|ZJyKJr|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Verbose: 1220 : 12|02:49:08.3221|ZJyKJr|CJPOWERCAST|imfx v3 API took 0.000s '/api/lookups/ItemTypes?_dc=1663292941124'
t Verbose: 1220 : 12|02:49:08.3221|9ofOtH|CJPOWERCAST|imfx v3 API took 0.000s '/api/lookups/UsageTypes?_dc=1663292941119'
t Transfer: 1220 : 12|02:49:08.3221|WWNbQn|CJPOWERCAST|OAuth: /api/lookups/TvStandards?_dc=1663292941128
t Transfer: 1220 : 12|02:49:08.3221|WWNbQn|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:49:08.3221|WWNbQn|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:49:08.3221|WWNbQn|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:49:08.3231|WWNbQn|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Verbose: 1220 : 12|02:49:08.3231|WWNbQn|CJPOWERCAST|imfx v3 API took 0.000s '/api/lookups/TvStandards?_dc=1663292941128'
t Verbose: 1220 : 12|02:49:08.3231|hKeNSp|CJPOWERCAST|imfx v3 API took 0.090s '/api/lookups/Channels?_dc=1663292941108'
t Transfer: 1220 : 12|02:49:08.5241|dzqVSb|CJPOWERCAST|OAuth: /api/lookups/AfdTypes?_dc=1663292941135
t Transfer: 1220 : 12|02:49:08.5241|dzqVSb|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:49:08.5241|dzqVSb|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:49:08.5241|dzqVSb|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:49:08.5241|dzqVSb|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Verbose: 1220 : 12|02:49:08.5241|dzqVSb|CJPOWERCAST|imfx v3 API took 0.000s '/api/lookups/AfdTypes?_dc=1663292941135'
t Transfer: 1220 : 12|02:49:08.5241|7rTE4H|CJPOWERCAST|OAuth: /api/lookups/AspectRatioTypes?_dc=1663292941131
t Transfer: 1220 : 12|02:49:08.5241|7rTE4H|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:49:08.5241|7rTE4H|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:49:08.5241|7rTE4H|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:49:08.5251|7rTE4H|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 : 12|02:49:08.5251|fj27mc|CJPOWERCAST|OAuth: /api/view/info/VersionGrid?lang=en-GB&_dc=1663292941139
t Transfer: 1220 : 12|02:49:08.5251|fj27mc|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:49:08.5251|fj27mc|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:49:08.5251|fj27mc|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:49:08.5251|fj27mc|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Verbose: 1220 : 12|02:49:08.5251|7rTE4H|CJPOWERCAST|imfx v3 API took 0.000s '/api/lookups/AspectRatioTypes?_dc=1663292941131'
t Information: 1220 : 12|02:49:08.5251|fj27mc|CJPOWERCAST|GetGridViewBuilder. builder type VersionGrid.
t Transfer: 1220 : 12|02:49:08.5251|fj27mc|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:49:08.5251|fj27mc|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:49:08.5261|fj27mc|CJPOWERCAST| user CJPOWERCAST.
t Information: 1220 : 12|02:49:08.5261|fj27mc|CJPOWERCAST|UserGridView. LoadView. ID -2, Name Default.
t Transfer: 1220 : 12|02:49:08.5261|fj27mc|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:49:08.5261|fj27mc|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:49:08.5261|fj27mc|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:49:08.5261|fj27mc|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:49:08.5261|fj27mc|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:49:08.5261|fj27mc|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:49:08.5261|fj27mc|CJPOWERCAST|imfx v3 API took 0.007s '/api/view/info/VersionGrid?lang=en-GB&_dc=1663292941139'
t Transfer: 1220 : 12|02:49:15.7621|CQn8_B|CJPOWERCAST|OAuth: /api/view/info/TitleTree?lang=en-GB&_dc=1663292948671
t Transfer: 1220 : 12|02:49:15.7621|CQn8_B|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:49:15.7621|CQn8_B|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:49:15.7621|CQn8_B|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:49:15.7621|CQn8_B|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 : 12|02:49:15.7621|CQn8_B|CJPOWERCAST|GetGridViewBuilder. builder type TitleTree.
t Transfer: 1220 : 12|02:49:15.7621|CQn8_B|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:49:15.7621|CQn8_B|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:49:15.7621|CQn8_B|CJPOWERCAST| user CJPOWERCAST.
t Information: 1220 : 12|02:49:15.7631|CQn8_B|CJPOWERCAST|UserGridView. LoadView. ID -2, Name Default.
t Transfer: 1220 : 12|02:49:15.7631|CQn8_B|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:49:15.7631|CQn8_B|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:49:15.7631|CQn8_B|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:49:15.7631|CQn8_B|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:49:15.7631|CQn8_B|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:49:15.7631|CQn8_B|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:49:15.7631|CQn8_B|CJPOWERCAST|imfx v3 API took 0.007s '/api/view/info/TitleTree?lang=en-GB&_dc=1663292948671'
t Transfer: 1220 : 12|02:49:18.5771|vO0orw|CJPOWERCAST|OAuth: /api/v3/search/title?_dc=1663292951528
t Transfer: 1220 : 12|02:49:18.5771|vO0orw|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:49:18.5771|vO0orw|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:49:18.5771|vO0orw|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:49:18.5771|vO0orw|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 : 12|02:49:18.7781|vO0orw|CJPOWERCAST|V3Api.SearchTitles
t Information: 1220 : 12|02:49:18.7781|vO0orw|CJPOWERCAST|V3Api.SearchGeneric
t Transfer: 1220 : 12|02:49:18.7781|vO0orw|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:49:18.7781|vO0orw|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:49:18.7781|vO0orw|CJPOWERCAST| user CJPOWERCAST.
t Information: 1220 : 12|02:49:18.7781|vO0orw|CJPOWERCAST|SearchTitle SQL:
with
v as (
SELECT
abs.*
,(select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = abs.net_grp_id) CHANNEL_GROUP
,decode(ITEM_TYPE,
1010,SER_ABS_ID,
1020,CASE WHEN SER_ABS2_ID > 0 THEN SER_ABS2_ID ELSE SER_ABS_ID END
) xparent_id
FROM TMDDBA.TM_PG_ABS abs
WHERE abs.id in (
select a.id
FROM TMDDBA.TM_PG_ABS a
where ABS_DELETED = 0 AND (INSTR(OWNERS,'|SFP2|')>0 OR INSTR(OWNERS,'|PSP|')>0 OR INSTR(OWNERS,'|PMS|')>0 OR INSTR(OWNERS,'|SFP1|')>0 OR INSTR(OWNERS,'|PMH|')>0 OR INSTR(OWNERS,'|PPL|')>0 ) AND ROWNUM < 25000 )
)
,v_missing_parent_ids as (
select xparent_id from v
minus
select id from v
)
,v_missing_parents as (
SELECT
distinct a.*
,(select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = a.net_grp_id) CHANNEL_GROUP
,decode(ITEM_TYPE,
1010,SER_ABS_ID,
1020,CASE WHEN SER_ABS2_ID > 0 THEN SER_ABS2_ID ELSE SER_ABS_ID END
) xparent_id
FROM TMDDBA.TM_PG_ABS a
START WITH ID IN (select xparent_id from v_missing_parent_ids)
CONNECT BY
CASE PRIOR ITEM_TYPE
WHEN 1010 THEN PRIOR SER_ABS_ID
WHEN 1020 THEN
CASE WHEN NVL(PRIOR SER_ABS2_ID, 0) > 0 THEN PRIOR SER_ABS2_ID ELSE PRIOR SER_ABS_ID END
END = ID
)
,v_all as (
select x.*, count(*) over() RowCount
from (
select * from v_missing_parents
union
select * from v
) x
)
,v_top as (
select id
from (select id, row_number()over(order by upper(ser_title),upper(title),ser_num,ser_ep_num, SER_EP_SQ_NUM ) rnk -- sort roots
from v_all
where xparent_id is null)
where rnk between (:page_number-1)*50+1 and :page_number*50
)
,v_tree as (
select level "TreeLevel", a.*from v_all a
start with id in (select id from v_top)
connect by xparent_id = prior ID
order siblings by upper(ser_title),ser_num,ser_ep_num, SER_EP_SQ_NUM,upper(title) -- sort children
)
select *
from v_tree
--where rnk <= 50
t Verbose: 1220 : 12|02:49:19.1801|vO0orw|CJPOWERCAST|imfx v3 API took 0.442s '/api/v3/search/title?_dc=1663292951528'
t Transfer: 1220 : 12|02:49:19.7831|TjzU5J|CJPOWERCAST|OAuth: /api/v3/title/299390/versions?_dc=1663292952563
t Transfer: 1220 : 12|02:49:19.7831|TjzU5J|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:49:19.7831|TjzU5J|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:49:19.7831|TjzU5J|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:49:19.7831|TjzU5J|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 : 12|02:49:19.7831|TjzU5J|CJPOWERCAST|V3Api.SearchGeneric
t Transfer: 1220 : 12|02:49:19.7831|TjzU5J|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:49:19.7831|TjzU5J|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:49:19.7831|TjzU5J|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:49:19.7841|TjzU5J|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:49:19.7841|TjzU5J|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:49:19.7841|TjzU5J|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:49:19.7841|TjzU5J|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:49:19.7841|TjzU5J|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:49:19.7841|TjzU5J|CJPOWERCAST| user CJPOWERCAST.
t Information: 1220 : 12|02:49:19.7841|TjzU5J|CJPOWERCAST|SearchVersion SQL:
select v.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE , (select min(name)
from TM_CFG_AUDIO_CONTENT_MS_TYPES audio
where v.audio_type = audio.id
) SOUND ,(select min(from_date_time)
from TM_PG_RL_PROD_DATE prodDate
where prodDate.Tm_Pg_Rl_Id = v.id
) PROD_FROM_DATE ,(select min(to_date_time)
from TM_PG_RL_PROD_DATE prodDate
where prodDate.Tm_Pg_Rl_Id = v.id
) PROD_TO_DATE ,(select min(full_name)
from tm_lang_data lang, TM_PG_RL_LANG_LNX link
where lang.id = link.lang_id
and link.tm_pg_rl_id = v.id) PROD_LANGUAGE ,(SELECT min(COLOUR_NAME)
FROM tm_cfg_colour_list list, tm_pg_rl ver
where ver.col_mono = list.id
and ver.id = v.id) PROD_COLOUR_TEXT ,(SELECT min(cfg.prod_date_type_name)
FROM TM_PG_RL_PROD_DATE pg_rl, tm_cfg_prod_date_type cfg
where cfg.id = pg_rl.PROD_DATE_TYPE_ID and TM_PG_RL_ID = v.id ) PROD_DATE_TYPE ,(select min(status.description)
from TM_CFG_PGM_STATUS status
where v.ITEM_STATUS_ID = status.id) PGM_STATUS_TEXT ,(select submed.sub_medium_name
from TM_CFG_SUB_MEDIUM submed
where v.SUB_MEDIUM_ID = submed.id) SUB_MEDIUM_TEXT, (select cvt.ID
from TM_PORTAL_VERSION_CONFIG cvt
where v.CUSTOM_VERSION_TYPE = cvt.CUSTOM_VERSION_TYPE AND cvt.CUSTOM_VERSION_TYPE IS NOT NULL
) MP_CONFIG_ID from tmddba.tm_pg_rl v
left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = v.primary_thumb_id
--sqlIdSearchJoin
where v.item_type>0 and v.rl_deleted=0
AND (INSTR(v.OWNERS,'|SFP2|')>0 OR INSTR(v.OWNERS,'|PSP|')>0 OR INSTR(v.OWNERS,'|PMS|')>0 OR INSTR(v.OWNERS,'|SFP1|')>0 OR INSTR(v.OWNERS,'|PMH|')>0 OR INSTR(v.OWNERS,'|PPL|')>0)
and v.id in
(select x.id from tmddba.tm_pg_rl x
start with x.id in (
select a.id from (select m.id, rownum rnum from tmddba.tm_pg_rl m
where item_type>0 and rl_deleted=0 and m.PGM_ABS_ID=:param_0 AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0)
) A WHERE rnum>=1 and rnum <= 9999
) connect by nocycle prior x.parent_id=x.id)
t Transfer: 1220 : 12|02:49:19.7841|TjzU5J|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:49:19.7841|TjzU5J|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:49:19.7851|TjzU5J|CJPOWERCAST| user CJPOWERCAST.
t Information: 1220 : 12|02:49:19.7851|TjzU5J|CJPOWERCAST|Running version search. User: 1165 Simple Search:
Running Oracle search.
Running Oracle search for COUNT
Oracle count completed in: 26ms. Returned lines: 0
t Verbose: 1220 : 12|02:49:19.7851|TjzU5J|CJPOWERCAST|imfx v3 API took 0.065s '/api/v3/title/299390/versions?_dc=1663292952563'
t Transfer: 1220 : 12|02:49:24.4081|LfM4H1|CJPOWERCAST|OAuth: /api/v3/title/299542/versions?_dc=1663292957342
t Transfer: 1220 : 12|02:49:24.4081|LfM4H1|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:49:24.4081|LfM4H1|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:49:24.4081|LfM4H1|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:49:24.4091|LfM4H1|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 : 12|02:49:24.4091|LfM4H1|CJPOWERCAST|V3Api.SearchGeneric
t Transfer: 1220 : 12|02:49:24.4091|LfM4H1|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:49:24.4091|LfM4H1|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:49:24.4091|LfM4H1|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:49:24.4091|LfM4H1|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:49:24.4091|LfM4H1|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:49:24.4091|LfM4H1|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:49:24.4101|LfM4H1|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:49:24.4101|LfM4H1|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:49:24.4101|LfM4H1|CJPOWERCAST| user CJPOWERCAST.
t Information: 1220 : 12|02:49:24.4101|LfM4H1|CJPOWERCAST|SearchVersion SQL:
select v.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE , (select min(name)
from TM_CFG_AUDIO_CONTENT_MS_TYPES audio
where v.audio_type = audio.id
) SOUND ,(select min(from_date_time)
from TM_PG_RL_PROD_DATE prodDate
where prodDate.Tm_Pg_Rl_Id = v.id
) PROD_FROM_DATE ,(select min(to_date_time)
from TM_PG_RL_PROD_DATE prodDate
where prodDate.Tm_Pg_Rl_Id = v.id
) PROD_TO_DATE ,(select min(full_name)
from tm_lang_data lang, TM_PG_RL_LANG_LNX link
where lang.id = link.lang_id
and link.tm_pg_rl_id = v.id) PROD_LANGUAGE ,(SELECT min(COLOUR_NAME)
FROM tm_cfg_colour_list list, tm_pg_rl ver
where ver.col_mono = list.id
and ver.id = v.id) PROD_COLOUR_TEXT ,(SELECT min(cfg.prod_date_type_name)
FROM TM_PG_RL_PROD_DATE pg_rl, tm_cfg_prod_date_type cfg
where cfg.id = pg_rl.PROD_DATE_TYPE_ID and TM_PG_RL_ID = v.id ) PROD_DATE_TYPE ,(select min(status.description)
from TM_CFG_PGM_STATUS status
where v.ITEM_STATUS_ID = status.id) PGM_STATUS_TEXT ,(select submed.sub_medium_name
from TM_CFG_SUB_MEDIUM submed
where v.SUB_MEDIUM_ID = submed.id) SUB_MEDIUM_TEXT, (select cvt.ID
from TM_PORTAL_VERSION_CONFIG cvt
where v.CUSTOM_VERSION_TYPE = cvt.CUSTOM_VERSION_TYPE AND cvt.CUSTOM_VERSION_TYPE IS NOT NULL
) MP_CONFIG_ID from tmddba.tm_pg_rl v
left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = v.primary_thumb_id
--sqlIdSearchJoin
where v.item_type>0 and v.rl_deleted=0
AND (INSTR(v.OWNERS,'|SFP2|')>0 OR INSTR(v.OWNERS,'|PSP|')>0 OR INSTR(v.OWNERS,'|PMS|')>0 OR INSTR(v.OWNERS,'|SFP1|')>0 OR INSTR(v.OWNERS,'|PMH|')>0 OR INSTR(v.OWNERS,'|PPL|')>0)
and v.id in
(select x.id from tmddba.tm_pg_rl x
start with x.id in (
select a.id from (select m.id, rownum rnum from tmddba.tm_pg_rl m
where item_type>0 and rl_deleted=0 and m.PGM_ABS_ID=:param_0 AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0)
) A WHERE rnum>=1 and rnum <= 9999
) connect by nocycle prior x.parent_id=x.id)
t Transfer: 1220 : 12|02:49:24.4101|LfM4H1|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:49:24.4101|LfM4H1|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:49:24.4111|LfM4H1|CJPOWERCAST| user CJPOWERCAST.
t Information: 1220 : 12|02:49:24.6161|LfM4H1|CJPOWERCAST|Running version search. User: 1165 Simple Search:
Running Oracle search.
Running Oracle search for COUNT
Oracle count completed in: 5ms. Returned lines: 2
Oracle version search timing: 175ms.
SQL run:
select v.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE , (select min(name)
from TM_CFG_AUDIO_CONTENT_MS_TYPES audio
where v.audio_type = audio.id
) SOUND ,(select min(from_date_time)
from TM_PG_RL_PROD_DATE prodDate
where prodDate.Tm_Pg_Rl_Id = v.id
) PROD_FROM_DATE ,(select min(to_date_time)
from TM_PG_RL_PROD_DATE prodDate
where prodDate.Tm_Pg_Rl_Id = v.id
) PROD_TO_DATE ,(select min(full_name)
from tm_lang_data lang, TM_PG_RL_LANG_LNX link
where lang.id = link.lang_id
and link.tm_pg_rl_id = v.id) PROD_LANGUAGE ,(SELECT min(COLOUR_NAME)
FROM tm_cfg_colour_list list, tm_pg_rl ver
where ver.col_mono = list.id
and ver.id = v.id) PROD_COLOUR_TEXT ,(SELECT min(cfg.prod_date_type_name)
FROM TM_PG_RL_PROD_DATE pg_rl, tm_cfg_prod_date_type cfg
where cfg.id = pg_rl.PROD_DATE_TYPE_ID and TM_PG_RL_ID = v.id ) PROD_DATE_TYPE ,(select min(status.description)
from TM_CFG_PGM_STATUS status
where v.ITEM_STATUS_ID = status.id) PGM_STATUS_TEXT ,(select submed.sub_medium_name
from TM_CFG_SUB_MEDIUM submed
where v.SUB_MEDIUM_ID = submed.id) SUB_MEDIUM_TEXT, (select cvt.ID
from TM_PORTAL_VERSION_CONFIG cvt
where v.CUSTOM_VERSION_TYPE = cvt.CUSTOM_VERSION_TYPE AND cvt.CUSTOM_VERSION_TYPE IS NOT NULL
) MP_CONFIG_ID from tmddba.tm_pg_rl v
left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = v.primary_thumb_id
--sqlIdSearchJoin
where v.item_type>0 and v.rl_deleted=0
AND (INSTR(v.OWNERS,'|SFP2|')>0 OR INSTR(v.OWNERS,'|PSP|')>0 OR INSTR(v.OWNERS,'|PMS|')>0 OR INSTR(v.OWNERS,'|SFP1|')>0 OR INSTR(v.OWNERS,'|PMH|')>0 OR INSTR(v.OWNERS,'|PPL|')>0)
and v.id in
(select x.id from tmddba.tm_pg_rl x
start with x.id in (
select a.id from (select m.id, rownum rnum from tmddba.tm_pg_rl m
where item_type>0 and rl_deleted=0 and m.PGM_ABS_ID=:param_0 AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0)
) A WHERE rnum>=1 and rnum <= 9999
) connect by nocycle prior x.parent_id=x.id)
t Verbose: 1220 : 12|02:49:24.6161|LfM4H1|CJPOWERCAST|imfx v3 API took 0.190s '/api/v3/title/299542/versions?_dc=1663292957342'
t Transfer: 1220 : 12|02:50:31.7491|oPkkQ~|CJPOWERCAST|OAuth: /api/v3/checkFilesExist?_dc=1663293024679
t Transfer: 1220 : 12|02:50:31.7491|oPkkQ~|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:50:31.7491|oPkkQ~|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:50:31.7491|oPkkQ~|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:50:31.7491|oPkkQ~|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Verbose: 1220 : 12|02:50:31.9501|oPkkQ~|CJPOWERCAST|imfx v3 API took 0.128s '/api/v3/checkFilesExist?_dc=1663293024679'
t Transfer: 1220 : 12|02:51:24.0271|0WPe_4|CJPOWERCAST|OAuth: /api/v3/upload/multi-part?_dc=1663293076977
t Transfer: 1220 : 12|02:51:24.0271|0WPe_4|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:24.0271|0WPe_4|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:24.0281|0WPe_4|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:51:24.0281|0WPe_4|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 : 12|02:51:24.2291|0WPe_4|CJPOWERCAST|Initialising upload for filename: 8DCM000222_OMN0118203335.mxf
t Information: 1220 : 12|02:51:24.4301|0WPe_4|CJPOWERCAST| created directory with upload id: ec347b4e-cc07-45a9-9d2d-7910b2aaa340
t Transfer: 1220 : 12|02:51:24.4301|0WPe_4|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:24.4301|0WPe_4|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:24.4301|0WPe_4|CJPOWERCAST| user CJPOWERCAST.
t Information: 1220 : 12|02:51:24.6311|0WPe_4|CJPOWERCAST| upload id saved to db
t Verbose: 1220 : 12|02:51:24.6311|0WPe_4|CJPOWERCAST|imfx v3 API took 0.553s '/api/v3/upload/multi-part?_dc=1663293076977'
t Transfer: 1220 : 12|02:51:26.6421|aK~YlL|CJPOWERCAST|OAuth: /api/v3/upload/multi-part/ec347b4e-cc07-45a9-9d2d-7910b2aaa340/part/0/63ad571c0666fb7bb2fe8762d85979d97cda5f2393ebdc04d919b75be3bca3f5
t Transfer: 1220 : 12|02:51:26.6421|aK~YlL|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:26.6421|aK~YlL|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:26.6421|aK~YlL|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:51:26.6421|aK~YlL|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 : 12|02:51:27.2461|ICekn6|CJPOWERCAST|OAuth: /api/v3/upload/multi-part/ec347b4e-cc07-45a9-9d2d-7910b2aaa340/part/1/25d0e6b71da7ed276bf7fc29817460ec201a5fa273339f0c95911934f291a3a8
t Transfer: 1220 : 12|02:51:27.2461|ICekn6|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:27.2471|ICekn6|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:27.2471|ICekn6|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:51:27.2471|ICekn6|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 : 12|02:51:28.4531|G79lKF|CJPOWERCAST|OAuth: /api/v3/upload/multi-part/ec347b4e-cc07-45a9-9d2d-7910b2aaa340/part/2/3ba2bafc2ced9f70e8904ba9c773b89fcd42e1b097cbd977a6a7cdc41a02dcaf
t Transfer: 1220 : 12|02:51:28.4531|G79lKF|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:28.4531|G79lKF|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:28.4531|G79lKF|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:51:28.4531|G79lKF|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 : 12|02:51:28.8551|yEjQ~T|CJPOWERCAST|OAuth: /api/v3/upload/multi-part/ec347b4e-cc07-45a9-9d2d-7910b2aaa340/part/3/b5256eab645051f17a8e51eeffd1d293388074855a6190f7919a3bbf3f1e66ae
t Transfer: 1220 : 12|02:51:28.8551|yEjQ~T|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:28.8551|yEjQ~T|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:28.8551|yEjQ~T|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:51:28.8551|yEjQ~T|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 : 12|02:51:29.2871|aK~YlL|CJPOWERCAST|Uploading part for upload id: ec347b4e-cc07-45a9-9d2d-7910b2aaa340 part id: 0
t Transfer: 1220 : 12|02:51:29.2871|CiK~T_|CJPOWERCAST|OAuth: /api/v3/upload/multi-part/ec347b4e-cc07-45a9-9d2d-7910b2aaa340/part/4/8db6f14c1bf29d38410a95caac5c0b27f31a6d07f8c68da072838ca2ff5d192a
t Transfer: 1220 : 12|02:51:29.2871|CiK~T_|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:29.2871|CiK~T_|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:29.2871|CiK~T_|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:51:29.2881|CiK~T_|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 : 12|02:51:29.4891|aK~YlL|CJPOWERCAST| hash verified: 63AD571C0666FB7BB2FE8762D85979D97CDA5F2393EBDC04D919B75BE3BCA3F5
t Information: 1220 : 12|02:51:29.4891|aK~YlL|CJPOWERCAST| saving for upload 10485760 bytes
t Information: 1220 : 12|02:51:29.8911|aK~YlL|CJPOWERCAST| part saved to file
t Information: 1220 : 12|02:51:29.8911|aK~YlL|CJPOWERCAST| part saved to db
t Verbose: 1220 : 12|02:51:29.8911|aK~YlL|CJPOWERCAST|imfx v3 API took 3.229s '/api/v3/upload/multi-part/ec347b4e-cc07-45a9-9d2d-7910b2aaa340/part/0/63ad571c0666fb7bb2fe8762d85979d97cda5f2393ebdc04d919b75be3bca3f5'
t Transfer: 1220 : 12|02:51:30.2931|ug6IUx|CJPOWERCAST|OAuth: /api/v3/upload/multi-part/ec347b4e-cc07-45a9-9d2d-7910b2aaa340/part/5/ea5545d644c3b01a19b797c9865779111696044ec21e8fd3ef47b2c419829534
t Transfer: 1220 : 12|02:51:30.2931|ug6IUx|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:30.2931|ug6IUx|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:30.2931|ug6IUx|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:51:30.2931|ug6IUx|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 : 12|02:51:33.1071|2HZtPS|CJPOWERCAST|OAuth: /api/view/searchinfo/Job?_dc=1663293086070
t Transfer: 1220 : 12|02:51:33.1071|2HZtPS|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:33.1071|2HZtPS|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:33.1071|2HZtPS|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:51:33.1081|2HZtPS|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 : 12|02:51:33.3091|2HZtPS|CJPOWERCAST|GetAdvSearchColumns. search type Job grid .
t Verbose: 1220 : 12|02:51:33.3091|2HZtPS|CJPOWERCAST|imfx v3 API took 0.000s '/api/view/searchinfo/Job?_dc=1663293086070'
t Transfer: 1220 : 12|02:51:33.5101|x4cdVI|CJPOWERCAST|OAuth: /api/user-preferences?keys=adv.recent.searches.workflow&_dc=1663293086071
t Transfer: 1220 : 12|02:51:33.5101|x4cdVI|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:33.5101|x4cdVI|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:33.5101|x4cdVI|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:51:33.5101|x4cdVI|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 : 12|02:51:33.5111|x4cdVI|CJPOWERCAST|GetUserDataByKeys: adv.recent.searches.workflow
t Transfer: 1220 : 12|02:51:33.5111|x4cdVI|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:33.5111|x4cdVI|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:33.5111|x4cdVI|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:51:33.5111|x4cdVI|CJPOWERCAST|imfx v3 API took 0.006s '/api/user-preferences?keys=adv.recent.searches.workflow&_dc=1663293086071'
t Transfer: 1220 : 12|02:51:33.7121|qFBAhL|CJPOWERCAST|OAuth: /api/view/searches/Job?_dc=1663293086087
t Transfer: 1220 : 12|02:51:33.7121|qFBAhL|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:33.7121|qFBAhL|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:33.7121|qFBAhL|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:51:33.7121|qFBAhL|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 : 12|02:51:33.7131|qFBAhL|CJPOWERCAST|GetSavedSearchNames. search type Job.
t Transfer: 1220 : 12|02:51:33.7131|qFBAhL|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:33.7131|qFBAhL|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:33.7131|qFBAhL|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:51:33.7131|qFBAhL|CJPOWERCAST|imfx v3 API took 0.006s '/api/view/searches/Job?_dc=1663293086087'
t Information: 1220 : 12|02:51:34.1631|ICekn6|CJPOWERCAST|Uploading part for upload id: ec347b4e-cc07-45a9-9d2d-7910b2aaa340 part id: 1
t Information: 1220 : 12|02:51:34.1641|ICekn6|CJPOWERCAST| hash verified: 25D0E6B71DA7ED276BF7FC29817460EC201A5FA273339F0C95911934F291A3A8
t Information: 1220 : 12|02:51:34.1641|ICekn6|CJPOWERCAST| saving for upload 10485760 bytes
t Transfer: 1220 : 12|02:51:34.4891|LAKXM3|CJPOWERCAST|OAuth: /api/view/info/Job?lang=en-GB&_dc=1663293086093
t Transfer: 1220 : 12|02:51:34.4891|LAKXM3|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:34.4891|LAKXM3|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:34.4891|LAKXM3|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:51:34.4901|LAKXM3|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 : 12|02:51:34.4901|LAKXM3|CJPOWERCAST|GetGridViewBuilder. builder type Job.
t Transfer: 1220 : 12|02:51:34.4901|LAKXM3|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:34.4901|LAKXM3|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:34.4901|LAKXM3|CJPOWERCAST| user CJPOWERCAST.
t Information: 1220 : 12|02:51:34.4901|LAKXM3|CJPOWERCAST|UserGridView. LoadView. ID -2, Name Default.
t Transfer: 1220 : 12|02:51:34.4901|LAKXM3|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:34.4911|LAKXM3|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:34.4911|LAKXM3|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:34.4911|LAKXM3|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:34.4911|LAKXM3|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:34.4911|LAKXM3|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:51:34.4911|LAKXM3|CJPOWERCAST|imfx v3 API took 0.008s '/api/view/info/Job?lang=en-GB&_dc=1663293086093'
t Information: 1220 : 12|02:51:34.4911|ICekn6|CJPOWERCAST| part saved to file
t Information: 1220 : 12|02:51:34.4921|ICekn6|CJPOWERCAST| part saved to db
t Verbose: 1220 : 12|02:51:34.4921|ICekn6|CJPOWERCAST|imfx v3 API took 7.309s '/api/v3/upload/multi-part/ec347b4e-cc07-45a9-9d2d-7910b2aaa340/part/1/25d0e6b71da7ed276bf7fc29817460ec201a5fa273339f0c95911934f291a3a8'
t Transfer: 1220 : 12|02:51:34.7751|1Ij4q6|CJPOWERCAST|OAuth: /api/lookup/job-schedule-nodes/search/?_dc=1663293086116
t Transfer: 1220 : 12|02:51:34.7751|1Ij4q6|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:34.7761|1Ij4q6|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:34.7761|1Ij4q6|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:51:34.7761|1Ij4q6|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 : 12|02:51:34.7761|1Ij4q6|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:34.7761|1Ij4q6|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:34.7761|1Ij4q6|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:51:34.7761|1Ij4q6|CJPOWERCAST|imfx v3 API took 0.050s '/api/lookup/job-schedule-nodes/search/?_dc=1663293086116'
t Transfer: 1220 : 12|02:51:34.9771|0yeCj3|CJPOWERCAST|OAuth: /api/v3/upload/multi-part/ec347b4e-cc07-45a9-9d2d-7910b2aaa340/part/6/706d8110804402461c24b31afa8bded46115168dce829051d2b78fa3cd068579
t Transfer: 1220 : 12|02:51:34.9771|0yeCj3|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:34.9771|0yeCj3|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:34.9771|0yeCj3|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:51:34.9771|0yeCj3|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 : 12|02:51:34.9771|g4qHUw|CJPOWERCAST|OAuth: /api/v3/search/workflow?_dc=1663293087867
t Transfer: 1220 : 12|02:51:34.9781|g4qHUw|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:34.9781|g4qHUw|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:34.9781|g4qHUw|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:51:34.9781|g4qHUw|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 : 12|02:51:34.9781|g4qHUw|CJPOWERCAST|V3Api.SearchWorkflows
t Information: 1220 : 12|02:51:34.9781|g4qHUw|CJPOWERCAST|V3Api.SearchGeneric
t Transfer: 1220 : 12|02:51:34.9781|g4qHUw|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:34.9791|g4qHUw|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:34.9791|g4qHUw|CJPOWERCAST| user CJPOWERCAST.
t Information: 1220 : 12|02:51:35.1801|g4qHUw|CJPOWERCAST|SearchJob SQL:
select * from (select a.*, rownum rnum from ( select /*+ INDEX(j JB_CMBST_IDX) */ j.*
,p.pname
,mi.tv_std
,mi.MIID1, mi.MIID2, mi.MIID3, mi.VERSIONID1, mi.VERSIONID2, mi.PROGID1, mi.PROGID2
,txd.NEXT_TX_DATE
FROM tm_mjob j
left join tm_mjob_pset p on j.j_sched_indx=p.id
,lateral(select j_id, TMD_str_agg(distinct miid1) MIID1,
TMD_str_agg(distinct miid2) MIID2,
TMD_str_agg(distinct miid3) MIID3,
TMD_str_agg(distinct versionid1) VERSIONID1,
TMD_str_agg(distinct versionid2) VERSIONID2,
TMD_str_agg(distinct progid1) PROGID1,
TMD_str_agg(distinct progid2) PROGID2,
TMD_str_agg(distinct m.tv_std) TV_STD,
TMD_str_agg(distinct m.title) TITLE from tm_mis m, tm_mtsk_it i
where i.j_id=j.id and m.id=i.mi_id and i.src_dest in (2,3) group by j_id)(+) mi
,lateral (
SELECT it.j_id, min(sch.tx_tm_st) NEXT_TX_DATE FROM TM_MTSK_IT it, TM_MIS m, hr_sched sch
WHERE it.j_id=j.id and m.id = it.MI_ID AND (sch.prod_num = m.PROGID2 OR sch.prod_num = (select rl.VERSIONID1 from TM_PG_RL rl where rl.ID = m.PGM_PARENT_ID)) AND sch.tx_tm_st > sysdate
GROUP BY it.J_ID)(+) txd
where 1=1 AND not ( j.CMB_STAT = 19 and j.J_FAILURE_RESOLVED > 0 ) and j.cmb_stat not in (15,18,23) AND (INSTR(j.J_CLIENTS, '|SFP2|') > 0 OR INSTR(j.J_CLIENTS, '|PSP|') > 0 OR INSTR(j.J_CLIENTS, '|PMS|') > 0 OR INSTR(j.J_CLIENTS, '|SFP1|') > 0 OR INSTR(j.J_CLIENTS, '|PMH|') > 0 OR INSTR(j.J_CLIENTS, '|PPL|') > 0) order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum
t Information: 1220 : 12|02:51:35.1801|G79lKF|CJPOWERCAST|Uploading part for upload id: ec347b4e-cc07-45a9-9d2d-7910b2aaa340 part id: 2
t Information: 1220 : 12|02:51:35.3821|g4qHUw|CJPOWERCAST| jobs returned 34, searched in 00:00:00.2825692
t Information: 1220 : 12|02:51:35.3821|G79lKF|CJPOWERCAST| hash verified: 3BA2BAFC2CED9F70E8904BA9C773B89FCD42E1B097CBD977A6A7CDC41A02DCAF
t Information: 1220 : 12|02:51:35.3821|G79lKF|CJPOWERCAST| saving for upload 10485760 bytes
t Information: 1220 : 12|02:51:35.5862|g4qHUw|CJPOWERCAST| tasks returned 34, searched in 00:00:00.1851829
t Verbose: 1220 : 12|02:51:35.5862|g4qHUw|CJPOWERCAST|imfx v3 API took 0.520s '/api/v3/search/workflow?_dc=1663293087867'
t Information: 1220 : 12|02:51:35.7871|G79lKF|CJPOWERCAST| part saved to file
t Information: 1220 : 12|02:51:35.7871|G79lKF|CJPOWERCAST| part saved to db
t Verbose: 1220 : 12|02:51:35.7871|G79lKF|CJPOWERCAST|imfx v3 API took 7.415s '/api/v3/upload/multi-part/ec347b4e-cc07-45a9-9d2d-7910b2aaa340/part/2/3ba2bafc2ced9f70e8904ba9c773b89fcd42e1b097cbd977a6a7cdc41a02dcaf'
t Transfer: 1220 : 12|02:51:35.9881|rZE19D|CJPOWERCAST|OAuth: /api/v3/search/workflow?_dc=1663293088225
t Transfer: 1220 : 12|02:51:35.9881|rZE19D|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:35.9881|rZE19D|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:35.9891|rZE19D|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:51:35.9891|rZE19D|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 : 12|02:51:36.1911|rZE19D|CJPOWERCAST|V3Api.SearchWorkflows
t Information: 1220 : 12|02:51:36.1911|rZE19D|CJPOWERCAST|V3Api.SearchGeneric
t Transfer: 1220 : 12|02:51:36.1921|rZE19D|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:36.1951|rZE19D|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:36.1951|rZE19D|CJPOWERCAST| user CJPOWERCAST.
t Information: 1220 : 12|02:51:36.1951|rZE19D|CJPOWERCAST|SearchJob SQL:
select * from (select a.*, rownum rnum from ( select /*+ INDEX(j JB_CMBST_IDX) */ j.*
,p.pname
,mi.tv_std
,mi.MIID1, mi.MIID2, mi.MIID3, mi.VERSIONID1, mi.VERSIONID2, mi.PROGID1, mi.PROGID2
,txd.NEXT_TX_DATE
FROM tm_mjob j
left join tm_mjob_pset p on j.j_sched_indx=p.id
,lateral(select j_id, TMD_str_agg(distinct miid1) MIID1,
TMD_str_agg(distinct miid2) MIID2,
TMD_str_agg(distinct miid3) MIID3,
TMD_str_agg(distinct versionid1) VERSIONID1,
TMD_str_agg(distinct versionid2) VERSIONID2,
TMD_str_agg(distinct progid1) PROGID1,
TMD_str_agg(distinct progid2) PROGID2,
TMD_str_agg(distinct m.tv_std) TV_STD,
TMD_str_agg(distinct m.title) TITLE from tm_mis m, tm_mtsk_it i
where i.j_id=j.id and m.id=i.mi_id and i.src_dest in (2,3) group by j_id)(+) mi
,lateral (
SELECT it.j_id, min(sch.tx_tm_st) NEXT_TX_DATE FROM TM_MTSK_IT it, TM_MIS m, hr_sched sch
WHERE it.j_id=j.id and m.id = it.MI_ID AND (sch.prod_num = m.PROGID2 OR sch.prod_num = (select rl.VERSIONID1 from TM_PG_RL rl where rl.ID = m.PGM_PARENT_ID)) AND sch.tx_tm_st > sysdate
GROUP BY it.J_ID)(+) txd
where 1=1 AND not ( j.CMB_STAT = 19 and j.J_FAILURE_RESOLVED > 0 ) and j.cmb_stat not in (15,18,23) AND (INSTR(j.J_CLIENTS, '|SFP2|') > 0 OR INSTR(j.J_CLIENTS, '|PSP|') > 0 OR INSTR(j.J_CLIENTS, '|PMS|') > 0 OR INSTR(j.J_CLIENTS, '|SFP1|') > 0 OR INSTR(j.J_CLIENTS, '|PMH|') > 0 OR INSTR(j.J_CLIENTS, '|PPL|') > 0) order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum
t Information: 1220 : 12|02:51:36.1961|ug6IUx|CJPOWERCAST|Uploading part for upload id: ec347b4e-cc07-45a9-9d2d-7910b2aaa340 part id: 5
t Information: 1220 : 12|02:51:36.1961|rZE19D|CJPOWERCAST| jobs returned 34, searched in 00:00:00.1785256
t Information: 1220 : 12|02:51:36.4241|rZE19D|CJPOWERCAST| tasks returned 34, searched in 00:00:00.2234525
t Verbose: 1220 : 12|02:51:36.4241|rZE19D|CJPOWERCAST|imfx v3 API took 0.408s '/api/v3/search/workflow?_dc=1663293088225'
t Transfer: 1220 : 12|02:51:36.6261|Pk~myJ|CJPOWERCAST|OAuth: /api/v3/upload/multi-part/ec347b4e-cc07-45a9-9d2d-7910b2aaa340/part/7/0e630d7118e050c7c69e9152de4285b4c7d46fa1cd5cd2f74a6f4a52ca08b03f
t Transfer: 1220 : 12|02:51:36.6261|Pk~myJ|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:36.6261|Pk~myJ|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:36.6261|Pk~myJ|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:51:36.6261|Pk~myJ|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 : 12|02:51:36.6271|ug6IUx|CJPOWERCAST| hash verified: EA5545D644C3B01A19B797C9865779111696044EC21E8FD3EF47B2C419829534
t Information: 1220 : 12|02:51:36.6271|ug6IUx|CJPOWERCAST| saving for upload 10485760 bytes
t Information: 1220 : 12|02:51:36.8281|ug6IUx|CJPOWERCAST| part saved to file
t Information: 1220 : 12|02:51:36.8281|ug6IUx|CJPOWERCAST| part saved to db
t Verbose: 1220 : 12|02:51:36.8281|ug6IUx|CJPOWERCAST|imfx v3 API took 6.573s '/api/v3/upload/multi-part/ec347b4e-cc07-45a9-9d2d-7910b2aaa340/part/5/ea5545d644c3b01a19b797c9865779111696044ec21e8fd3ef47b2c419829534'
t Transfer: 1220 : 12|02:51:37.2301|dWwWs6|CJPOWERCAST|OAuth: /api/v3/upload/multi-part/ec347b4e-cc07-45a9-9d2d-7910b2aaa340/part/8/a2489a5c637d63a3389761e8c14393e02522f4f4ffa3bdb3dac8061d26a6b0d8
t Transfer: 1220 : 12|02:51:37.2301|dWwWs6|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:37.2301|dWwWs6|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:37.2301|dWwWs6|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:51:37.2301|dWwWs6|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 : 12|02:51:39.0391|isEWdY|CJPOWERCAST|OAuth: /api/user-preferences?_dc=1663293091839
t Transfer: 1220 : 12|02:51:39.0391|isEWdY|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:39.0391|isEWdY|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:39.0391|isEWdY|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:51:39.0401|isEWdY|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Verbose: 1220 : 12|02:51:39.2411|isEWdY|CJPOWERCAST|StoreUserDataByKeys..
t Transfer: 1220 : 12|02:51:39.2411|isEWdY|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:39.2411|isEWdY|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:39.2411|isEWdY|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:51:39.4501|isEWdY|CJPOWERCAST|imfx v3 API took 0.014s '/api/user-preferences?_dc=1663293091839'
t Information: 1220 : 12|02:51:40.6571|dWwWs6|CJPOWERCAST|Uploading part for upload id: ec347b4e-cc07-45a9-9d2d-7910b2aaa340 part id: 8
t Information: 1220 : 12|02:51:40.8581|dWwWs6|CJPOWERCAST| hash verified: A2489A5C637D63A3389761E8C14393E02522F4F4FFA3BDB3DAC8061D26A6B0D8
t Information: 1220 : 12|02:51:40.8581|dWwWs6|CJPOWERCAST| saving for upload 10485760 bytes
t Information: 1220 : 12|02:51:41.0591|0yeCj3|CJPOWERCAST|Uploading part for upload id: ec347b4e-cc07-45a9-9d2d-7910b2aaa340 part id: 6
t Information: 1220 : 12|02:51:41.2611|dWwWs6|CJPOWERCAST| part saved to file
t Information: 1220 : 12|02:51:41.2611|dWwWs6|CJPOWERCAST| part saved to db
t Verbose: 1220 : 12|02:51:41.2621|dWwWs6|CJPOWERCAST|imfx v3 API took 3.951s '/api/v3/upload/multi-part/ec347b4e-cc07-45a9-9d2d-7910b2aaa340/part/8/a2489a5c637d63a3389761e8c14393e02522f4f4ffa3bdb3dac8061d26a6b0d8'
t Information: 1220 : 12|02:51:41.2621|0yeCj3|CJPOWERCAST| hash verified: 706D8110804402461C24B31AFA8BDED46115168DCE829051D2B78FA3CD068579
t Information: 1220 : 12|02:51:41.2621|0yeCj3|CJPOWERCAST| saving for upload 10485760 bytes
t Information: 1220 : 12|02:51:41.6641|0yeCj3|CJPOWERCAST| part saved to file
t Information: 1220 : 12|02:51:41.6641|0yeCj3|CJPOWERCAST| part saved to db
t Verbose: 1220 : 12|02:51:41.6641|0yeCj3|CJPOWERCAST|imfx v3 API took 6.666s '/api/v3/upload/multi-part/ec347b4e-cc07-45a9-9d2d-7910b2aaa340/part/6/706d8110804402461c24b31afa8bded46115168dce829051d2b78fa3cd068579'
t Transfer: 1220 : 12|02:51:41.8651|edX8Uc|CJPOWERCAST|OAuth: /api/v3/upload/multi-part/ec347b4e-cc07-45a9-9d2d-7910b2aaa340/part/9/c2e9aeb32465de1df1177687b1a586aec80c345d7af101bbf6126522295f4d62
t Transfer: 1220 : 12|02:51:41.8651|edX8Uc|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:41.8651|edX8Uc|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:41.8651|edX8Uc|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:51:41.8651|edX8Uc|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 : 12|02:51:42.4681|W3hPgn|CJPOWERCAST|OAuth: /api/v3/upload/multi-part/ec347b4e-cc07-45a9-9d2d-7910b2aaa340/part/10/d5b695c7f578235f146879fe64a227d5afd3258d3e97a187ee7bcb4a7d546335
t Transfer: 1220 : 12|02:51:42.4681|W3hPgn|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:42.4681|W3hPgn|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:42.4681|W3hPgn|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:51:42.4681|W3hPgn|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 : 12|02:51:43.6741|yEjQ~T|CJPOWERCAST|Uploading part for upload id: ec347b4e-cc07-45a9-9d2d-7910b2aaa340 part id: 3
t Information: 1220 : 12|02:51:43.8751|yEjQ~T|CJPOWERCAST| hash verified: B5256EAB645051F17A8E51EEFFD1D293388074855A6190F7919A3BBF3F1E66AE
t Information: 1220 : 12|02:51:43.8751|yEjQ~T|CJPOWERCAST| saving for upload 10485760 bytes
t Information: 1220 : 12|02:51:44.0871|Pk~myJ|CJPOWERCAST|Uploading part for upload id: ec347b4e-cc07-45a9-9d2d-7910b2aaa340 part id: 7
t Information: 1220 : 12|02:51:44.2881|yEjQ~T|CJPOWERCAST| part saved to file
t Information: 1220 : 12|02:51:44.2881|yEjQ~T|CJPOWERCAST| part saved to db
t Verbose: 1220 : 12|02:51:44.2881|yEjQ~T|CJPOWERCAST|imfx v3 API took 15.400s '/api/v3/upload/multi-part/ec347b4e-cc07-45a9-9d2d-7910b2aaa340/part/3/b5256eab645051f17a8e51eeffd1d293388074855a6190f7919a3bbf3f1e66ae'
t Information: 1220 : 12|02:51:44.4891|Pk~myJ|CJPOWERCAST| hash verified: 0E630D7118E050C7C69E9152DE4285B4C7D46FA1CD5CD2F74A6F4A52CA08B03F
t Information: 1220 : 12|02:51:44.4891|Pk~myJ|CJPOWERCAST| saving for upload 10485760 bytes
t Information: 1220 : 12|02:51:44.6901|Pk~myJ|CJPOWERCAST| part saved to file
t Information: 1220 : 12|02:51:44.6901|Pk~myJ|CJPOWERCAST| part saved to db
t Verbose: 1220 : 12|02:51:44.6901|Pk~myJ|CJPOWERCAST|imfx v3 API took 8.111s '/api/v3/upload/multi-part/ec347b4e-cc07-45a9-9d2d-7910b2aaa340/part/7/0e630d7118e050c7c69e9152de4285b4c7d46fa1cd5cd2f74a6f4a52ca08b03f'
t Information: 1220 : 12|02:51:45.7071|W3hPgn|CJPOWERCAST|Uploading part for upload id: ec347b4e-cc07-45a9-9d2d-7910b2aaa340 part id: 10
t Transfer: 1220 : 12|02:51:45.7071|p~9Xg6|CJPOWERCAST|OAuth: /api/v3/job/124616?_dc=1663293098633
t Transfer: 1220 : 12|02:51:45.7071|p~9Xg6|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:45.7071|p~9Xg6|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:45.7071|p~9Xg6|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:51:45.7071|p~9Xg6|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 : 12|02:51:45.9091|W3hPgn|CJPOWERCAST| hash verified: D5B695C7F578235F146879FE64A227D5AFD3258D3E97A187EE7BCB4A7D546335
t Information: 1220 : 12|02:51:45.9101|W3hPgn|CJPOWERCAST| saving for upload 7437384 bytes
t Information: 1220 : 12|02:51:46.1111|W3hPgn|CJPOWERCAST| part saved to file
t Information: 1220 : 12|02:51:46.3121|W3hPgn|CJPOWERCAST| part saved to db
t Verbose: 1220 : 12|02:51:46.3121|W3hPgn|CJPOWERCAST|imfx v3 API took 3.878s '/api/v3/upload/multi-part/ec347b4e-cc07-45a9-9d2d-7910b2aaa340/part/10/d5b695c7f578235f146879fe64a227d5afd3258d3e97a187ee7bcb4a7d546335'
t Verbose: 1220 : 12|02:51:47.3181|p~9Xg6|CJPOWERCAST|imfx v3 API took 1.454s '/api/v3/job/124616?_dc=1663293098633'
t Information: 1220 : 12|02:51:48.3271|edX8Uc|CJPOWERCAST|Uploading part for upload id: ec347b4e-cc07-45a9-9d2d-7910b2aaa340 part id: 9
t Information: 1220 : 12|02:51:48.5281|edX8Uc|CJPOWERCAST| hash verified: C2E9AEB32465DE1DF1177687B1A586AEC80C345D7AF101BBF6126522295F4D62
t Information: 1220 : 12|02:51:48.5281|edX8Uc|CJPOWERCAST| saving for upload 10485760 bytes
t Information: 1220 : 12|02:51:48.9301|edX8Uc|CJPOWERCAST| part saved to file
t Information: 1220 : 12|02:51:48.9301|edX8Uc|CJPOWERCAST| part saved to db
t Verbose: 1220 : 12|02:51:48.9301|edX8Uc|CJPOWERCAST|imfx v3 API took 6.897s '/api/v3/upload/multi-part/ec347b4e-cc07-45a9-9d2d-7910b2aaa340/part/9/c2e9aeb32465de1df1177687b1a586aec80c345d7af101bbf6126522295f4d62'
t Transfer: 1220 : 12|02:51:50.1371|7F0L_D|CJPOWERCAST|OAuth: /api/v3/search/Media?_dc=1663293102955
t Transfer: 1220 : 12|02:51:50.1371|7F0L_D|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:50.1371|7F0L_D|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:50.1371|7F0L_D|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:51:50.1371|7F0L_D|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 : 12|02:51:50.1381|7F0L_D|CJPOWERCAST|V3Api.SearchMedia
t Information: 1220 : 12|02:51:50.1381|7F0L_D|CJPOWERCAST|V3Api.SearchGeneric
t Transfer: 1220 : 12|02:51:50.1381|7F0L_D|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:50.1381|7F0L_D|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:50.1381|7F0L_D|CJPOWERCAST| user CJPOWERCAST.
t Information: 1220 : 12|02:51:50.5401|7F0L_D|CJPOWERCAST|Running solr search: [q, (deleted_flag:(0) AND (owners:((SFP2) OR (PSP) OR (PMS) OR (SFP1) OR (PMH) OR (PPL))))]
t Information: 1220 : 12|02:51:50.5401|7F0L_D|CJPOWERCAST|Solr query returned: 347 in 11ms
t Information: 1220 : 12|02:51:50.7411|7F0L_D|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 min(status.ACCESS_STATUS_NAME) FROM TMDDBA.TM_ACCESS_STATUS statusLnx, TM_CFG_ACCESS_STATUS status
WHERE statusLnx.Media_Id = r.id and statusLnx.Status_Id = status.id) ACCESS_STATUS , (select min(acq.ext_ref) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) CONSIGNMENT_NUMBER ,
(select min(acq.alt_id1) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) TRANSFER_NUMBER ,
(select min(crs.series_number) from tm_series_data crs where crs.id = r.GROUP_SERIES_ID) CRS_SERIES ,
(select min(DISPOSAL_NAME) from TM_ACQ_DISPOSAL status, tm_disposal_records records
where status.id = records.disposal_status_id and records.miid = r.id) DISPOSAL_STATUS ,
(select min(class.class_number) from TM_ACQ_DISPOSAL status, tm_disposal_records records, tm_disposal_classes class
where status.id = records.disposal_status_id and records.miid = r.id and class.id = records.disposal_class_id) DISPOSAL_CLASS,
(select min(names.concat_search_name) from tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names
where r.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY,
(select min(c.u_id_ext1) from tmddba.tm_mi_tpi_lnx lnx, tm_ctnrs c where c.u_id = lnx.tpiid and lnx.miid = r.id) U_ID_EXT1 ,
(select t.name from TM_CFG_MI_FMT_TYP t where t.id = r.mi_fmt_type) ITEM_FORMAT_TEXT,
CASE
WHEN BITAND(r.COMPIL, 2) = 2 THEN 'SUPPLIED'
WHEN BITAND(r.COMPIL, 4) = 4 THEN 'MADE'
WHEN BITAND(r.COMPIL, 134217728) = 134217728 THEN 'IMPORTED'
ELSE ''
END AS ORIGIN,
CASE
WHEN BITAND(r.COMPIL, 512) = 512 THEN 'Attached'
WHEN BITAND(r.COMPIL, 1024) = 1024 THEN 'Un-Attached'
ELSE ''
END AS FLAGS,
(select min(lang.full_name) from TM_PG_RL_LANG_LNX lnx, TM_LANG_DATA lang
where lnx.tm_pg_rl_id = r.pgm_parent_id and lnx.lang_id = lang.id) AS PROD_LANGUAGE ,
(select min(ctx.ITFC_CODE) from tm_mis mis, tm_mi_tpi_lnx links, tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names
where mis.id = r.id and links.miid = mis.id and mis.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id
and ctx.preferred_name = names.id) AGENCY_NUMBER,
(select min(status.description) from TM_CFG_PGM_STATUS status where r.status = status.id) PGM_STATUS_TEXT,
(select min(ver.DUR) from TM_PG_RL ver where r.pgm_PARENT_ID = ver.id) AS VERSION_DUR , (select tmd_str_agg_pipe(cms.status_type_id ||',' ||cms.status_id) from tm_mi_cust_med_stat_lnx cms where cms.media_id=r.id) "CustomStatusesRaw", (select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = r.net_grp_id) CHANNEL_GROUP,
(SELECT SUBSTR( trim( replace (replace (
LISTAGG(trim(tt.tags || ' ' || tt.notes), ' ') WITHIN GROUP (ORDER BY trim(tt.tags || ' ' || tt.notes)), chr (13), ''), chr (10), ' ')), 1, 150) z
FROM tm_media_tagging tt
WHERE link_guid = DFILE_LINK_GUID and rownum=1) TAGS_TEXT ,
GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION,
nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME
from (select 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 Verbose: 1220 : 12|02:51:51.1431|7F0L_D|CJPOWERCAST|Alternative title fields query: select * from (select x.id,x.pgm_abs_id TitleId, x.pgm_parent_id VersionId from tm_mis x where id in (select /*+ cardinality(4) */ column_value id from table(:ids))) y,lateral (select dbms_lob.substr( o.text_data_plain, 1000, 1 ) Field_5799344 from tm_txt_obj o
where (o.pgm_abs_id=y.TitleId or o.pgm_rl_id = y.VersionId) and o.type_id=:param_1
order by o.id desc fetch first 1 rows only)(+)
t Information: 1220 : 12|02:51:51.1431|7F0L_D|CJPOWERCAST| timing: 00:00:01.0003050
t Verbose: 1220 : 12|02:51:51.1431|7F0L_D|CJPOWERCAST|imfx v3 API took 1.014s '/api/v3/search/Media?_dc=1663293102955'
t Transfer: 1220 : 12|02:51:51.1431|7F0L_D|CJPOWERCAST|GetUrl. Storage |Video| filename I:\Video\L0640441.mp4 subfolder
t Transfer: 1220 : 12|02:51:51.1431|7F0L_D|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/L0640441.mp4
t Transfer: 1220 : 12|02:51:51.1431|7F0L_D|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/L0640441.mp4
t Transfer: 1220 : 12|02:51:51.1441|7F0L_D|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:51.1441|7F0L_D|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:51.1441|7F0L_D|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:51.1791|7F0L_D|CJPOWERCAST|GetUrl. Storage |Video| filename I:\Video\L0640430.mp4 subfolder
t Transfer: 1220 : 12|02:51:51.1891|7F0L_D|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/L0640430.mp4
t Transfer: 1220 : 12|02:51:51.1901|7F0L_D|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/L0640430.mp4
t Transfer: 1220 : 12|02:51:51.1901|7F0L_D|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:51.1901|7F0L_D|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:51.1901|7F0L_D|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:51.1911|7F0L_D|CJPOWERCAST|GetUrl. Storage |PMH Video| filename \\10.46.131.12\Test\NGAM\Folder3\alpha7-1\C0002.MP4 subfolder alpha7-1\
t Transfer: 1220 : 12|02:51:51.1911|7F0L_D|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:51.1911|7F0L_D|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:51.1911|7F0L_D|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:51.1911|7F0L_D|CJPOWERCAST|GetUrl. Storage |PMH Video| filename \\10.46.131.12\Test\NGAM\Folder3\alpha7-1\C0003.MP4 subfolder alpha7-1\
t Transfer: 1220 : 12|02:51:51.1911|7F0L_D|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:51.1911|7F0L_D|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:51.1921|7F0L_D|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:51.1921|7F0L_D|CJPOWERCAST|GetUrl. Storage |PMH Video| filename \\10.46.131.12\Test\NGAM\Folder3\alpha7-1\C0004.MP4 subfolder alpha7-1\
t Transfer: 1220 : 12|02:51:51.1921|7F0L_D|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:51.1921|7F0L_D|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:51.1921|7F0L_D|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:51.1921|7F0L_D|CJPOWERCAST|GetUrl. Storage |PMH Video| filename \\10.46.131.12\Test\NGAM\Folder3\alpha7-1\C0005.MP4 subfolder alpha7-1\
t Transfer: 1220 : 12|02:51:51.1921|7F0L_D|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:51.1931|7F0L_D|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:51.1931|7F0L_D|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:51.1931|7F0L_D|CJPOWERCAST|GetUrl. Storage |PMH Video| filename \\10.46.131.12\Test\NGAM\Folder3\alpha7-1\C0007.MP4 subfolder alpha7-1\
t Transfer: 1220 : 12|02:51:51.1931|7F0L_D|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:51.1931|7F0L_D|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:51.1931|7F0L_D|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:51.1941|7F0L_D|CJPOWERCAST|GetUrl. Storage |PMH Video| filename \\10.46.131.12\Test\NGAM\Folder3\32b60bce-ad82-46d9-9680-1bc508939215\GH018860.MP4 subfolder 32b60bce-ad82-46d9-9680-1bc508939215\
t Transfer: 1220 : 12|02:51:51.1941|7F0L_D|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:51.1941|7F0L_D|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:51.1941|7F0L_D|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:51.1941|7F0L_D|CJPOWERCAST|GetUrl. Storage |PMH Video| filename \\10.46.131.12\Test\NGAM\Folder3\aa6fb5ed-8e69-4268-b8fa-1184664437a0\GH018859.MP4 subfolder aa6fb5ed-8e69-4268-b8fa-1184664437a0\
t Transfer: 1220 : 12|02:51:51.1941|7F0L_D|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:51.1941|7F0L_D|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:51.1951|7F0L_D|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:51.1951|7F0L_D|CJPOWERCAST|GetUrl. Storage |PMH Video| filename \\10.46.131.12\Test\NGAM\Folder3\206cf38c-d40c-49e6-b8ed-476b7c369d2c\GH018861.MP4 subfolder 206cf38c-d40c-49e6-b8ed-476b7c369d2c\
t Transfer: 1220 : 12|02:51:51.1951|7F0L_D|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:51.1951|7F0L_D|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:51.1951|7F0L_D|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:51.1951|7F0L_D|CJPOWERCAST|GetUrl. Storage |PMH Proxy| filename \\10.46.131.12\Test\NGAM\Folder5\295_2302_M0002105.mp4 subfolder
t Transfer: 1220 : 12|02:51:51.1961|7F0L_D|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:51.1961|7F0L_D|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:51.1961|7F0L_D|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:51.1961|7F0L_D|CJPOWERCAST|GetUrl. Storage |PMH Proxy| filename \\10.46.131.12\Test\NGAM\Folder5\N0002107.mp4 subfolder
t Transfer: 1220 : 12|02:51:51.1961|7F0L_D|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:51.1961|7F0L_D|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:51.1961|7F0L_D|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:51.1971|7F0L_D|CJPOWERCAST|GetUrl. Storage |PMH Proxy| filename \\10.46.131.12\Test\NGAM\Folder5\N0002108.mp4 subfolder
t Transfer: 1220 : 12|02:51:51.1971|7F0L_D|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:51.1971|7F0L_D|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:51.1971|7F0L_D|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:51.1971|7F0L_D|CJPOWERCAST|GetUrl. Storage |PMH Proxy| filename \\10.46.131.12\Test\NGAM\Folder5\GH018860_M0002145.mp4 subfolder
t Transfer: 1220 : 12|02:51:51.1971|7F0L_D|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:51.1971|7F0L_D|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:51.1981|7F0L_D|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:51.1981|7F0L_D|CJPOWERCAST|GetUrl. Storage |PMH Proxy| filename \\10.46.131.12\Test\NGAM\Folder5\MAXD_1506_M0002267.mp4 subfolder
t Transfer: 1220 : 12|02:51:51.1981|7F0L_D|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:51.1981|7F0L_D|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:51.1981|7F0L_D|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:51.1981|7F0L_D|CJPOWERCAST|GetUrl. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\cd16270b-696e-4e0b-9a0e-02a00f6c3c8d\2022년_통합인제스트_6월 근무표.xlsx subfolder cd16270b-696e-4e0b-9a0e-02a00f6c3c8d\
t Transfer: 1220 : 12|02:51:51.1981|7F0L_D|CJPOWERCAST| GetFileName result https://demo.tmd.tv/Temp Upload/2022%EB%85%84_%ED%86%B5%ED%95%A9%EC%9D%B8%EC%A0%9C%EC%8A%A4%ED%8A%B8_6%EC%9B%94%20%EA%B7%BC%EB%AC%B4%ED%91%9C.xlsx
t Transfer: 1220 : 12|02:51:51.1991|7F0L_D|CJPOWERCAST|GetUrl. result https://demo.tmd.tv/Temp Upload/2022%EB%85%84_%ED%86%B5%ED%95%A9%EC%9D%B8%EC%A0%9C%EC%8A%A4%ED%8A%B8_6%EC%9B%94%20%EA%B7%BC%EB%AC%B4%ED%91%9C.xlsx
t Transfer: 1220 : 12|02:51:51.4001|7F0L_D|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:51.4001|7F0L_D|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:51.4001|7F0L_D|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:51.4001|7F0L_D|CJPOWERCAST|GetUrl. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\ecb10dd3-349c-49d2-8131-9de1fb854cb8\월간구독지 현황.txt subfolder ecb10dd3-349c-49d2-8131-9de1fb854cb8\
t Transfer: 1220 : 12|02:51:51.4001|7F0L_D|CJPOWERCAST| GetFileName result https://demo.tmd.tv/Temp Upload/%EC%9B%94%EA%B0%84%EA%B5%AC%EB%8F%85%EC%A7%80%20%ED%98%84%ED%99%A9.txt
t Transfer: 1220 : 12|02:51:51.4011|7F0L_D|CJPOWERCAST|GetUrl. result https://demo.tmd.tv/Temp Upload/%EC%9B%94%EA%B0%84%EA%B5%AC%EB%8F%85%EC%A7%80%20%ED%98%84%ED%99%A9.txt
t Transfer: 1220 : 12|02:51:51.4011|7F0L_D|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:51.4011|7F0L_D|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:51.4011|7F0L_D|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:51.4011|7F0L_D|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gots0ep4us.mpd subfolder
t Transfer: 1220 : 12|02:51:51.4011|7F0L_D|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gots0ep4us.mpd
t Transfer: 1220 : 12|02:51:51.4011|7F0L_D|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/gots0ep4us.mpd
t Transfer: 1220 : 12|02:51:51.4021|7F0L_D|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:51.4021|7F0L_D|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:51.4021|7F0L_D|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:51.4021|7F0L_D|CJPOWERCAST|GetUrl. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\SPOC List.xlsx subfolder
t Transfer: 1220 : 12|02:51:51.4021|7F0L_D|CJPOWERCAST| GetFileName result https://demo.tmd.tv/Temp Upload/SPOC%20List.xlsx
t Transfer: 1220 : 12|02:51:51.4021|7F0L_D|CJPOWERCAST|GetUrl. result https://demo.tmd.tv/Temp Upload/SPOC%20List.xlsx
t Transfer: 1220 : 12|02:51:51.4021|7F0L_D|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:51.4031|7F0L_D|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:51.4031|7F0L_D|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:51.4031|7F0L_D|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\snow-game-of-thrones-1200x600.jpg subfolder
t Transfer: 1220 : 12|02:51:51.4031|7F0L_D|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/snow-game-of-thrones-1200x600.jpg
t Transfer: 1220 : 12|02:51:51.4031|7F0L_D|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/snow-game-of-thrones-1200x600.jpg
t Transfer: 1220 : 12|02:51:51.4031|7F0L_D|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:51.4031|7F0L_D|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:51.4031|7F0L_D|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:51.4041|7F0L_D|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\Game_of_Thrones_Still_4.jpg subfolder
t Transfer: 1220 : 12|02:51:51.4041|7F0L_D|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/Game_of_Thrones_Still_4.jpg
t Transfer: 1220 : 12|02:51:51.4041|7F0L_D|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/Game_of_Thrones_Still_4.jpg
t Transfer: 1220 : 12|02:51:51.4041|7F0L_D|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:51.4041|7F0L_D|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:51.4041|7F0L_D|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:51.4041|7F0L_D|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\Game_of_Thrones_Still_4.png subfolder
t Transfer: 1220 : 12|02:51:51.4041|7F0L_D|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/Game_of_Thrones_Still_4.png
t Transfer: 1220 : 12|02:51:51.4051|7F0L_D|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/Game_of_Thrones_Still_4.png
t Transfer: 1220 : 12|02:51:51.4051|7F0L_D|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:51.4051|7F0L_D|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:51.4051|7F0L_D|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:51.4051|7F0L_D|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\game-of-thrones-1349.jpg subfolder
t Transfer: 1220 : 12|02:51:51.4051|7F0L_D|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/game-of-thrones-1349.jpg
t Transfer: 1220 : 12|02:51:51.4051|7F0L_D|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/game-of-thrones-1349.jpg
t Transfer: 1220 : 12|02:51:51.4051|7F0L_D|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:51.4061|7F0L_D|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:51.4061|7F0L_D|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:51.4061|7F0L_D|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\game-of-thrones-daenerys.jpg subfolder
t Transfer: 1220 : 12|02:51:51.4061|7F0L_D|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/game-of-thrones-daenerys.jpg
t Transfer: 1220 : 12|02:51:51.4061|7F0L_D|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/game-of-thrones-daenerys.jpg
t Transfer: 1220 : 12|02:51:51.4061|7F0L_D|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:51.4061|7F0L_D|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:51.4071|7F0L_D|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:51.4071|7F0L_D|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\young cersei game of thrones helen sloan.jpeg.jpg subfolder
t Transfer: 1220 : 12|02:51:51.4071|7F0L_D|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/young%20cersei%20game%20of%20thrones%20helen%20sloan.jpeg.jpg
t Transfer: 1220 : 12|02:51:51.4071|7F0L_D|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/young%20cersei%20game%20of%20thrones%20helen%20sloan.jpeg.jpg
t Transfer: 1220 : 12|02:51:51.4071|7F0L_D|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:51.4071|7F0L_D|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:51.4071|7F0L_D|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:51.4071|7F0L_D|CJPOWERCAST|GetUrl. Storage |VODPublish| filename \\192.168.120.254\DemoFS\Digital Assets\VODPublish\Temp\N0001344.dtd subfolder Temp\
t Transfer: 1220 : 12|02:51:51.4081|7F0L_D|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:51.4081|7F0L_D|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:51.4081|7F0L_D|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:51.4081|7F0L_D|CJPOWERCAST|GetUrl. Storage |VODPublish| filename \\192.168.120.254\DemoFS\Digital Assets\VODPublish\Temp\N0001345.xml subfolder Temp\
t Transfer: 1220 : 12|02:51:51.4081|7F0L_D|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:51.4081|7F0L_D|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:51.4081|7F0L_D|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:51.4081|7F0L_D|CJPOWERCAST|GetUrl. Storage |VODPublish| filename \\192.168.120.254\DemoFS\Digital Assets\VODPublish\Temp\N0001348.dtd subfolder Temp\
t Transfer: 1220 : 12|02:51:51.4091|7F0L_D|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:51.4091|7F0L_D|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:51.4091|7F0L_D|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:51.4091|7F0L_D|CJPOWERCAST|GetUrl. Storage |VODPublish| filename \\192.168.120.254\DemoFS\Digital Assets\VODPublish\Temp\N0001349.xml subfolder Temp\
t Transfer: 1220 : 12|02:51:51.4091|7F0L_D|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:51.4091|7F0L_D|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:51.4091|7F0L_D|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:51.4091|7F0L_D|CJPOWERCAST|GetUrl. Storage |Docs| filename I:\Docs\Mediaflex Supported Devices 2v03.pdf subfolder
t Transfer: 1220 : 12|02:51:51.4101|7F0L_D|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/DocsServer/Mediaflex%20Supported%20Devices%202v03.pdf
t Transfer: 1220 : 12|02:51:51.4101|7F0L_D|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/DocsServer/Mediaflex%20Supported%20Devices%202v03.pdf
t Transfer: 1220 : 12|02:51:51.4101|7F0L_D|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:51.4101|7F0L_D|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:51.4101|7F0L_D|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:51.4101|7F0L_D|CJPOWERCAST|GetUrl. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\BBC_graymeta_metadata.json subfolder
t Transfer: 1220 : 12|02:51:51.4101|7F0L_D|CJPOWERCAST| GetFileName result https://demo.tmd.tv/Temp Upload/BBC_graymeta_metadata.json
t Transfer: 1220 : 12|02:51:51.4101|7F0L_D|CJPOWERCAST|GetUrl. result https://demo.tmd.tv/Temp Upload/BBC_graymeta_metadata.json
t Transfer: 1220 : 12|02:51:51.4111|7F0L_D|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:51.4111|7F0L_D|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:51.4111|7F0L_D|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:51.4111|7F0L_D|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Game of Thrones - Blinkbox-HD.mp4 subfolder
t Transfer: 1220 : 12|02:51:51.4111|7F0L_D|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Game%20of%20Thrones%20-%20Blinkbox-HD.mp4
t Transfer: 1220 : 12|02:51:51.4111|7F0L_D|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/Game%20of%20Thrones%20-%20Blinkbox-HD.mp4
t Transfer: 1220 : 12|02:51:51.4111|7F0L_D|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:51.4121|7F0L_D|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:51.4121|7F0L_D|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:51.4121|7F0L_D|CJPOWERCAST|GetUrl. Storage |VODPublish| filename \\192.168.120.254\DemoFS\Digital Assets\VODPublish\Temp\N0001343.mp4 subfolder Temp\
t Transfer: 1220 : 12|02:51:51.4121|7F0L_D|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:51.4121|7F0L_D|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:51.4121|7F0L_D|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:51.4121|7F0L_D|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gotspecialspromo20seccharacter.mp4 subfolder
t Transfer: 1220 : 12|02:51:51.4121|7F0L_D|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gotspecialspromo20seccharacter.mp4
t Transfer: 1220 : 12|02:51:51.4131|7F0L_D|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/gotspecialspromo20seccharacter.mp4
t Transfer: 1220 : 12|02:51:51.4131|7F0L_D|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:51.4131|7F0L_D|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:51.4131|7F0L_D|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:51.4131|7F0L_D|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\gotspecialspromosimage.jpg subfolder
t Transfer: 1220 : 12|02:51:51.4131|7F0L_D|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/gotspecialspromosimage.jpg
t Transfer: 1220 : 12|02:51:51.4131|7F0L_D|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/gotspecialspromosimage.jpg
t Transfer: 1220 : 12|02:51:51.4141|7F0L_D|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:51.4141|7F0L_D|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:51.4141|7F0L_D|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:51.4141|7F0L_D|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\Example 06052020.mp4 subfolder
t Transfer: 1220 : 12|02:51:51.4141|7F0L_D|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/Example%2006052020.mp4
t Transfer: 1220 : 12|02:51:51.4141|7F0L_D|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/Example%2006052020.mp4
t Transfer: 1220 : 12|02:51:51.4141|7F0L_D|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:51.4141|7F0L_D|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:51.4151|7F0L_D|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:51.4151|7F0L_D|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gots0ep3us.mpd subfolder
t Transfer: 1220 : 12|02:51:51.4151|7F0L_D|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gots0ep3us.mpd
t Transfer: 1220 : 12|02:51:51.4151|7F0L_D|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/gots0ep3us.mpd
t Transfer: 1220 : 12|02:51:51.4151|7F0L_D|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:51.4151|7F0L_D|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:51.4151|7F0L_D|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:51.4151|7F0L_D|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Example 06052020.mp4 subfolder
t Transfer: 1220 : 12|02:51:51.4161|7F0L_D|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Example%2006052020.mp4
t Transfer: 1220 : 12|02:51:51.4161|7F0L_D|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/Example%2006052020.mp4
t Transfer: 1220 : 12|02:51:51.4161|7F0L_D|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:51.4161|7F0L_D|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:51.4161|7F0L_D|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:51.4161|7F0L_D|CJPOWERCAST|GetUrl. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\68add84afa7b\Animation Sample1.mp4 subfolder 68add84afa7b\
t Transfer: 1220 : 12|02:51:51.4161|7F0L_D|CJPOWERCAST| GetFileName result https://demo.tmd.tv/Temp Upload/Animation%20Sample1.mp4
t Transfer: 1220 : 12|02:51:51.4161|7F0L_D|CJPOWERCAST|GetUrl. result https://demo.tmd.tv/Temp Upload/Animation%20Sample1.mp4
t Transfer: 1220 : 12|02:51:51.4171|7F0L_D|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:51.4171|7F0L_D|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:51.4171|7F0L_D|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:51.4171|7F0L_D|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gotspecialspromo10secaction.mp4 subfolder
t Transfer: 1220 : 12|02:51:51.4171|7F0L_D|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gotspecialspromo10secaction.mp4
t Transfer: 1220 : 12|02:51:51.4171|7F0L_D|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/gotspecialspromo10secaction.mp4
t Transfer: 1220 : 12|02:51:51.4171|7F0L_D|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:51.4171|7F0L_D|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:51.4181|7F0L_D|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:51.4181|7F0L_D|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gots0ep5us.mpd subfolder
t Transfer: 1220 : 12|02:51:51.4181|7F0L_D|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gots0ep5us.mpd
t Transfer: 1220 : 12|02:51:51.4181|7F0L_D|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/gots0ep5us.mpd
t Transfer: 1220 : 12|02:51:51.4181|7F0L_D|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:51.4181|7F0L_D|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:51.4181|7F0L_D|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:51.4181|7F0L_D|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gots0ep2us.mpd subfolder
t Transfer: 1220 : 12|02:51:51.4191|7F0L_D|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gots0ep2us.mpd
t Transfer: 1220 : 12|02:51:51.4191|7F0L_D|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/gots0ep2us.mpd
t Transfer: 1220 : 12|02:51:51.4191|7F0L_D|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:51.4191|7F0L_D|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:51.4191|7F0L_D|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:51.4191|7F0L_D|CJPOWERCAST|GetUrl. Storage |PMH File Ingest| filename \\10.46.131.12\Test\NGAM\Folder1\2f4e55ff-aadf-429e-bae6-b2278b526a3f\XTN_191213_SCARLET_SWEATER_TENT_VERT_FR_04.mp4 subfolder 2f4e55ff-aadf-429e-bae6-b2278b526a3f\
t Transfer: 1220 : 12|02:51:51.4191|7F0L_D|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:51.4201|7F0L_D|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:51.4201|7F0L_D|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:51.4201|7F0L_D|CJPOWERCAST|GetUrl. Storage |PMH Video| filename \\10.46.131.12\Test\NGAM\Folder3\aa_pgomez_manual.mp4 subfolder
t Transfer: 1220 : 12|02:51:51.4201|7F0L_D|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:51.4201|7F0L_D|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:51.4201|7F0L_D|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:51.4201|7F0L_D|CJPOWERCAST|GetUrl. Storage |PMH Video| filename \\10.46.131.12\Test\NGAM\Folder3\0008971.mp4 subfolder
t Transfer: 1220 : 12|02:51:51.4201|7F0L_D|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:51.4211|7F0L_D|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:51.4211|7F0L_D|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:51.4211|7F0L_D|CJPOWERCAST|GetUrl. Storage |PMH Proxy| filename \\10.46.131.12\Test\NGAM\Folder5\VERT_PICKXAPP_VIDEO_YT_JOGA_Fr.mp4 subfolder
t Transfer: 1220 : 12|02:51:51.4211|7F0L_D|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:51.4211|7F0L_D|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:51.4221|7F0L_D|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:51.4231|7F0L_D|CJPOWERCAST|GetUrl. Storage |PMH Proxy| filename \\10.46.131.12\Test\NGAM\Folder5\SCARLET_SWEATER_CAR_VERT_FR_SUB - Copy.mp4 subfolder
t Transfer: 1220 : 12|02:51:51.4231|7F0L_D|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:51.4231|7F0L_D|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:51.4231|7F0L_D|CJPOWERCAST| user CJPOWERCAST.
t Information: 1220 : 12|02:51:51.8251|CiK~T_|CJPOWERCAST|Uploading part for upload id: ec347b4e-cc07-45a9-9d2d-7910b2aaa340 part id: 4
t Information: 1220 : 12|02:51:52.0261|CiK~T_|CJPOWERCAST| hash verified: 8DB6F14C1BF29D38410A95CAAC5C0B27F31A6D07F8C68DA072838CA2FF5D192A
t Information: 1220 : 12|02:51:52.0261|CiK~T_|CJPOWERCAST| saving for upload 10485760 bytes
t Information: 1220 : 12|02:51:52.4281|CiK~T_|CJPOWERCAST| part saved to file
t Information: 1220 : 12|02:51:52.4281|CiK~T_|CJPOWERCAST| part saved to db
t Verbose: 1220 : 12|02:51:52.4281|CiK~T_|CJPOWERCAST|imfx v3 API took 23.011s '/api/v3/upload/multi-part/ec347b4e-cc07-45a9-9d2d-7910b2aaa340/part/4/8db6f14c1bf29d38410a95caac5c0b27f31a6d07f8c68da072838ca2ff5d192a'
t Transfer: 1220 : 12|02:51:52.6291|8ADj_b|CJPOWERCAST|OAuth: /api/v3/upload/multi-part/ec347b4e-cc07-45a9-9d2d-7910b2aaa340/0e976798c78c60169c634034424859606bf80d03ac068246cd053dfdf4731fa7?_dc=1663293105537
t Transfer: 1220 : 12|02:51:52.6291|8ADj_b|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:52.6291|8ADj_b|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:52.6301|8ADj_b|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:51:52.6301|8ADj_b|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 : 12|02:51:52.6301|8ADj_b|CJPOWERCAST|Completing upload id: ec347b4e-cc07-45a9-9d2d-7910b2aaa340
t Transfer: 1220 : 12|02:51:52.6301|8ADj_b|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:52.6301|8ADj_b|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:52.6301|8ADj_b|CJPOWERCAST| user CJPOWERCAST.
t Information: 1220 : 12|02:51:52.8311|8ADj_b|CJPOWERCAST| parsing parts data
t Information: 1220 : 12|02:51:52.8311|8ADj_b|CJPOWERCAST| treehash verified: 0E976798C78C60169C634034424859606BF80D03AC068246CD053DFDF4731FA7
t Information: 1220 : 12|02:51:52.8311|8ADj_b|CJPOWERCAST| opening file to write: \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\ec347b4e-cc07-45a9-9d2d-7910b2aaa340\8DCM000222_OMN0118203335.mxf
t Information: 1220 : 12|02:51:52.8311|8ADj_b|CJPOWERCAST| part copied: 0
t Information: 1220 : 12|02:51:53.0321|8ADj_b|CJPOWERCAST| part copied: 1
t Information: 1220 : 12|02:51:53.0321|8ADj_b|CJPOWERCAST| part copied: 2
t Information: 1220 : 12|02:51:53.2331|8ADj_b|CJPOWERCAST| part copied: 3
t Information: 1220 : 12|02:51:53.2331|8ADj_b|CJPOWERCAST| part copied: 4
t Information: 1220 : 12|02:51:53.4361|8ADj_b|CJPOWERCAST| part copied: 5
t Information: 1220 : 12|02:51:53.4372|8ADj_b|CJPOWERCAST| part copied: 6
t Information: 1220 : 12|02:51:53.6381|8ADj_b|CJPOWERCAST| part copied: 7
t Information: 1220 : 12|02:51:53.6381|8ADj_b|CJPOWERCAST| part copied: 8
t Information: 1220 : 12|02:51:53.8391|8ADj_b|CJPOWERCAST| part copied: 9
t Information: 1220 : 12|02:51:53.8391|8ADj_b|CJPOWERCAST| part copied: 10
t Information: 1220 : 12|02:51:55.8491|8ADj_b|CJPOWERCAST| file created from 11 parts in 00:00:03.0195017
t Information: 1220 : 12|02:51:56.0501|8ADj_b|CJPOWERCAST| preparing xml
t Information: 1220 : 12|02:51:56.0501|8ADj_b|CJPOWERCAST| preparing segments
t Information: 1220 : 12|02:51:56.0501|8ADj_b|CJPOWERCAST| preparing audio
t Information: 1220 : 12|02:51:56.0501|8ADj_b|CJPOWERCAST| calling createMedia api
t Transfer: 1220 : 12|02:51:56.0501|8ADj_b|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:56.0501|8ADj_b|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:56.0501|8ADj_b|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:56.0501|8ADj_b|CJPOWERCAST| semaphore enter at: 9/16/2022 2:51:55 AM count: 9 thread: 67
t Information: 1220 : 12|02:51:56.0501|8ADj_b|CJPOWERCAST|CallApi. In. Trace-id: iLwhOW Msg: createMedia. User: CJPOWERCAST. Rights: False.
t Information: 1220 : 12|02:51:56.0501|8ADj_b|CJPOWERCAST|8DCM000222_OMN0118203335falsedigitalServerALSFP1DMWM8DCM000222_OMN0118203335.mxfTEMP_UPLOADec347b4e-cc07-45a9-9d2d-7910b2aaa340MXF112294984
t Transfer: 1220 : 12|02:51:56.6541|hGGNGu|CJPOWERCAST|OAuth: /api/v3/search/Media?_dc=1663293109453
t Transfer: 1220 : 12|02:51:56.6541|hGGNGu|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:56.6541|hGGNGu|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:56.6541|hGGNGu|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:51:56.6541|hGGNGu|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 : 12|02:51:56.6551|hGGNGu|CJPOWERCAST|V3Api.SearchMedia
t Information: 1220 : 12|02:51:56.6551|hGGNGu|CJPOWERCAST|V3Api.SearchGeneric
t Transfer: 1220 : 12|02:51:56.6551|hGGNGu|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:56.6551|hGGNGu|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:56.6551|hGGNGu|CJPOWERCAST| user CJPOWERCAST.
t Information: 1220 : 12|02:51:56.6551|hGGNGu|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|02:51:56.6551|hGGNGu|CJPOWERCAST|Solr query returned: 347 in 2ms
t Information: 1220 : 12|02:51:56.6551|hGGNGu|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 min(status.ACCESS_STATUS_NAME) FROM TMDDBA.TM_ACCESS_STATUS statusLnx, TM_CFG_ACCESS_STATUS status
WHERE statusLnx.Media_Id = r.id and statusLnx.Status_Id = status.id) ACCESS_STATUS , (select min(acq.ext_ref) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) CONSIGNMENT_NUMBER ,
(select min(acq.alt_id1) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) TRANSFER_NUMBER ,
(select min(crs.series_number) from tm_series_data crs where crs.id = r.GROUP_SERIES_ID) CRS_SERIES ,
(select min(DISPOSAL_NAME) from TM_ACQ_DISPOSAL status, tm_disposal_records records
where status.id = records.disposal_status_id and records.miid = r.id) DISPOSAL_STATUS ,
(select min(class.class_number) from TM_ACQ_DISPOSAL status, tm_disposal_records records, tm_disposal_classes class
where status.id = records.disposal_status_id and records.miid = r.id and class.id = records.disposal_class_id) DISPOSAL_CLASS,
(select min(names.concat_search_name) from tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names
where r.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY,
(select min(c.u_id_ext1) from tmddba.tm_mi_tpi_lnx lnx, tm_ctnrs c where c.u_id = lnx.tpiid and lnx.miid = r.id) U_ID_EXT1 ,
(select t.name from TM_CFG_MI_FMT_TYP t where t.id = r.mi_fmt_type) ITEM_FORMAT_TEXT,
CASE
WHEN BITAND(r.COMPIL, 2) = 2 THEN 'SUPPLIED'
WHEN BITAND(r.COMPIL, 4) = 4 THEN 'MADE'
WHEN BITAND(r.COMPIL, 134217728) = 134217728 THEN 'IMPORTED'
ELSE ''
END AS ORIGIN,
CASE
WHEN BITAND(r.COMPIL, 512) = 512 THEN 'Attached'
WHEN BITAND(r.COMPIL, 1024) = 1024 THEN 'Un-Attached'
ELSE ''
END AS FLAGS,
(select min(lang.full_name) from TM_PG_RL_LANG_LNX lnx, TM_LANG_DATA lang
where lnx.tm_pg_rl_id = r.pgm_parent_id and lnx.lang_id = lang.id) AS PROD_LANGUAGE ,
(select min(ctx.ITFC_CODE) from tm_mis mis, tm_mi_tpi_lnx links, tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names
where mis.id = r.id and links.miid = mis.id and mis.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id
and ctx.preferred_name = names.id) AGENCY_NUMBER,
(select min(status.description) from TM_CFG_PGM_STATUS status where r.status = status.id) PGM_STATUS_TEXT,
(select min(ver.DUR) from TM_PG_RL ver where r.pgm_PARENT_ID = ver.id) AS VERSION_DUR , (select tmd_str_agg_pipe(cms.status_type_id ||',' ||cms.status_id) from tm_mi_cust_med_stat_lnx cms where cms.media_id=r.id) "CustomStatusesRaw", (select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = r.net_grp_id) CHANNEL_GROUP,
(SELECT SUBSTR( trim( replace (replace (
LISTAGG(trim(tt.tags || ' ' || tt.notes), ' ') WITHIN GROUP (ORDER BY trim(tt.tags || ' ' || tt.notes)), chr (13), ''), chr (10), ' ')), 1, 150) z
FROM tm_media_tagging tt
WHERE link_guid = DFILE_LINK_GUID and rownum=1) TAGS_TEXT ,
GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION,
nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME
from (select 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|02:51:56.6561|8ADj_b|CJPOWERCAST|CallApi. Out. Trace-id: iLwhOW 719.5ms.
t Information: 1220 : 12|02:51:56.6561|8ADj_b|CJPOWERCAST|
1200
t Transfer: 1220 : 12|02:51:56.6561|8ADj_b|CJPOWERCAST| semaphore release at: 9/16/2022 2:51:56 AM count: 9 thread: 67
t Information: 1220 : 12|02:51:57.0581|8ADj_b|CJPOWERCAST| got media 361779
t Information: 1220 : 12|02:51:57.0581|8ADj_b|CJPOWERCAST| media created: 361779
t Information: 1220 : 12|02:51:57.0581|8ADj_b|CJPOWERCAST| status changed to completed for upload id: ec347b4e-cc07-45a9-9d2d-7910b2aaa340
t Information: 1220 : 12|02:51:57.0581|8ADj_b|CJPOWERCAST| part files cleared for upload id: ec347b4e-cc07-45a9-9d2d-7910b2aaa340
t Verbose: 1220 : 12|02:51:57.0581|8ADj_b|CJPOWERCAST|imfx v3 API took 4.364s '/api/v3/upload/multi-part/ec347b4e-cc07-45a9-9d2d-7910b2aaa340/0e976798c78c60169c634034424859606bf80d03ac068246cd053dfdf4731fa7?_dc=1663293105537'
t Verbose: 1220 : 12|02:51:57.2591|hGGNGu|CJPOWERCAST|Alternative title fields query: select * from (select x.id,x.pgm_abs_id TitleId, x.pgm_parent_id VersionId from tm_mis x where id in (select /*+ cardinality(4) */ column_value id from table(:ids))) y,lateral (select dbms_lob.substr( o.text_data_plain, 1000, 1 ) Field_5799344 from tm_txt_obj o
where (o.pgm_abs_id=y.TitleId or o.pgm_rl_id = y.VersionId) and o.type_id=:param_1
order by o.id desc fetch first 1 rows only)(+)
t Information: 1220 : 12|02:51:57.2591|hGGNGu|CJPOWERCAST| timing: 00:00:00.5761348
t Verbose: 1220 : 12|02:51:57.2591|hGGNGu|CJPOWERCAST|imfx v3 API took 0.637s '/api/v3/search/Media?_dc=1663293109453'
t Transfer: 1220 : 12|02:51:57.2591|hGGNGu|CJPOWERCAST|GetUrl. Storage |Video| filename I:\Video\L0640441.mp4 subfolder
t Transfer: 1220 : 12|02:51:57.2591|hGGNGu|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/L0640441.mp4
t Transfer: 1220 : 12|02:51:57.2601|hGGNGu|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/L0640441.mp4
t Transfer: 1220 : 12|02:51:57.2601|hGGNGu|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:57.2601|hGGNGu|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:57.2601|hGGNGu|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:57.2601|hGGNGu|CJPOWERCAST|GetUrl. Storage |Video| filename I:\Video\L0640430.mp4 subfolder
t Transfer: 1220 : 12|02:51:57.2601|hGGNGu|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/L0640430.mp4
t Transfer: 1220 : 12|02:51:57.2601|hGGNGu|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/L0640430.mp4
t Transfer: 1220 : 12|02:51:57.2601|hGGNGu|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:57.2611|hGGNGu|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:57.2611|hGGNGu|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:57.2611|hGGNGu|CJPOWERCAST|GetUrl. Storage |PMH Video| filename \\10.46.131.12\Test\NGAM\Folder3\alpha7-1\C0002.MP4 subfolder alpha7-1\
t Transfer: 1220 : 12|02:51:57.2611|hGGNGu|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:57.2611|hGGNGu|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:57.2611|hGGNGu|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:57.2611|hGGNGu|CJPOWERCAST|GetUrl. Storage |PMH Video| filename \\10.46.131.12\Test\NGAM\Folder3\alpha7-1\C0003.MP4 subfolder alpha7-1\
t Transfer: 1220 : 12|02:51:57.2611|hGGNGu|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:57.2621|hGGNGu|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:57.2621|hGGNGu|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:57.2621|hGGNGu|CJPOWERCAST|GetUrl. Storage |PMH Video| filename \\10.46.131.12\Test\NGAM\Folder3\alpha7-1\C0004.MP4 subfolder alpha7-1\
t Transfer: 1220 : 12|02:51:57.2621|hGGNGu|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:57.2621|hGGNGu|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:57.2621|hGGNGu|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:57.2621|hGGNGu|CJPOWERCAST|GetUrl. Storage |PMH Video| filename \\10.46.131.12\Test\NGAM\Folder3\alpha7-1\C0005.MP4 subfolder alpha7-1\
t Transfer: 1220 : 12|02:51:57.2631|hGGNGu|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:57.2631|hGGNGu|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:57.2631|hGGNGu|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:57.2631|hGGNGu|CJPOWERCAST|GetUrl. Storage |PMH Video| filename \\10.46.131.12\Test\NGAM\Folder3\alpha7-1\C0007.MP4 subfolder alpha7-1\
t Transfer: 1220 : 12|02:51:57.2631|hGGNGu|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:57.2631|hGGNGu|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:57.2631|hGGNGu|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:57.2641|hGGNGu|CJPOWERCAST|GetUrl. Storage |PMH Video| filename \\10.46.131.12\Test\NGAM\Folder3\32b60bce-ad82-46d9-9680-1bc508939215\GH018860.MP4 subfolder 32b60bce-ad82-46d9-9680-1bc508939215\
t Transfer: 1220 : 12|02:51:57.2641|hGGNGu|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:57.2641|hGGNGu|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:57.2641|hGGNGu|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:57.2641|hGGNGu|CJPOWERCAST|GetUrl. Storage |PMH Video| filename \\10.46.131.12\Test\NGAM\Folder3\aa6fb5ed-8e69-4268-b8fa-1184664437a0\GH018859.MP4 subfolder aa6fb5ed-8e69-4268-b8fa-1184664437a0\
t Transfer: 1220 : 12|02:51:57.2641|hGGNGu|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:57.2651|hGGNGu|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:57.2651|hGGNGu|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:57.2651|hGGNGu|CJPOWERCAST|GetUrl. Storage |PMH Video| filename \\10.46.131.12\Test\NGAM\Folder3\206cf38c-d40c-49e6-b8ed-476b7c369d2c\GH018861.MP4 subfolder 206cf38c-d40c-49e6-b8ed-476b7c369d2c\
t Transfer: 1220 : 12|02:51:57.2651|hGGNGu|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:57.2651|hGGNGu|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:57.2651|hGGNGu|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:57.2661|hGGNGu|CJPOWERCAST|GetUrl. Storage |PMH Proxy| filename \\10.46.131.12\Test\NGAM\Folder5\295_2302_M0002105.mp4 subfolder
t Transfer: 1220 : 12|02:51:57.2661|hGGNGu|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:57.2661|hGGNGu|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:57.2661|hGGNGu|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:57.2661|hGGNGu|CJPOWERCAST|GetUrl. Storage |PMH Proxy| filename \\10.46.131.12\Test\NGAM\Folder5\N0002107.mp4 subfolder
t Transfer: 1220 : 12|02:51:57.2661|hGGNGu|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:57.2661|hGGNGu|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:57.2671|hGGNGu|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:57.2671|hGGNGu|CJPOWERCAST|GetUrl. Storage |PMH Proxy| filename \\10.46.131.12\Test\NGAM\Folder5\N0002108.mp4 subfolder
t Transfer: 1220 : 12|02:51:57.2671|hGGNGu|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:57.2671|hGGNGu|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:57.2671|hGGNGu|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:57.2671|hGGNGu|CJPOWERCAST|GetUrl. Storage |PMH Proxy| filename \\10.46.131.12\Test\NGAM\Folder5\GH018860_M0002145.mp4 subfolder
t Transfer: 1220 : 12|02:51:57.2671|hGGNGu|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:57.2681|hGGNGu|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:57.2681|hGGNGu|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:57.2681|hGGNGu|CJPOWERCAST|GetUrl. Storage |PMH Proxy| filename \\10.46.131.12\Test\NGAM\Folder5\MAXD_1506_M0002267.mp4 subfolder
t Transfer: 1220 : 12|02:51:57.2681|hGGNGu|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:57.2681|hGGNGu|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:57.2681|hGGNGu|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:57.2681|hGGNGu|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gots0ep4us.mpd subfolder
t Transfer: 1220 : 12|02:51:57.2691|hGGNGu|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gots0ep4us.mpd
t Transfer: 1220 : 12|02:51:57.2691|hGGNGu|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/gots0ep4us.mpd
t Transfer: 1220 : 12|02:51:57.2691|hGGNGu|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:57.2691|hGGNGu|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:57.2691|hGGNGu|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:57.2691|hGGNGu|CJPOWERCAST|GetUrl. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\SPOC List.xlsx subfolder
t Transfer: 1220 : 12|02:51:57.2691|hGGNGu|CJPOWERCAST| GetFileName result https://demo.tmd.tv/Temp Upload/SPOC%20List.xlsx
t Transfer: 1220 : 12|02:51:57.2701|hGGNGu|CJPOWERCAST|GetUrl. result https://demo.tmd.tv/Temp Upload/SPOC%20List.xlsx
t Transfer: 1220 : 12|02:51:57.2701|hGGNGu|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:57.2701|hGGNGu|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:57.2701|hGGNGu|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:57.2701|hGGNGu|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\snow-game-of-thrones-1200x600.jpg subfolder
t Transfer: 1220 : 12|02:51:57.2711|hGGNGu|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/snow-game-of-thrones-1200x600.jpg
t Transfer: 1220 : 12|02:51:57.2711|hGGNGu|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/snow-game-of-thrones-1200x600.jpg
t Transfer: 1220 : 12|02:51:57.2711|hGGNGu|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:57.2711|hGGNGu|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:57.2711|hGGNGu|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:57.2711|hGGNGu|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\Game_of_Thrones_Still_4.jpg subfolder
t Transfer: 1220 : 12|02:51:57.2711|hGGNGu|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/Game_of_Thrones_Still_4.jpg
t Transfer: 1220 : 12|02:51:57.2721|hGGNGu|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/Game_of_Thrones_Still_4.jpg
t Transfer: 1220 : 12|02:51:57.2721|hGGNGu|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:57.2721|hGGNGu|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:57.2721|hGGNGu|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:57.2721|hGGNGu|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\Game_of_Thrones_Still_4.png subfolder
t Transfer: 1220 : 12|02:51:57.2721|hGGNGu|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/Game_of_Thrones_Still_4.png
t Transfer: 1220 : 12|02:51:57.2731|hGGNGu|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/Game_of_Thrones_Still_4.png
t Transfer: 1220 : 12|02:51:57.2731|hGGNGu|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:57.2731|hGGNGu|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:57.2731|hGGNGu|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:57.2731|hGGNGu|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\game-of-thrones-1349.jpg subfolder
t Transfer: 1220 : 12|02:51:57.2741|hGGNGu|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/game-of-thrones-1349.jpg
t Transfer: 1220 : 12|02:51:57.2741|hGGNGu|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/game-of-thrones-1349.jpg
t Transfer: 1220 : 12|02:51:57.2741|hGGNGu|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:57.2741|hGGNGu|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:57.2741|hGGNGu|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:57.2741|hGGNGu|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\game-of-thrones-daenerys.jpg subfolder
t Transfer: 1220 : 12|02:51:57.2751|hGGNGu|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/game-of-thrones-daenerys.jpg
t Transfer: 1220 : 12|02:51:57.2751|hGGNGu|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/game-of-thrones-daenerys.jpg
t Transfer: 1220 : 12|02:51:57.2751|hGGNGu|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:57.2751|hGGNGu|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:57.2751|hGGNGu|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:57.2751|hGGNGu|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\young cersei game of thrones helen sloan.jpeg.jpg subfolder
t Transfer: 1220 : 12|02:51:57.2751|hGGNGu|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/young%20cersei%20game%20of%20thrones%20helen%20sloan.jpeg.jpg
t Transfer: 1220 : 12|02:51:57.2751|hGGNGu|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/young%20cersei%20game%20of%20thrones%20helen%20sloan.jpeg.jpg
t Transfer: 1220 : 12|02:51:57.2761|hGGNGu|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:57.2761|hGGNGu|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:57.2761|hGGNGu|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:57.2761|hGGNGu|CJPOWERCAST|GetUrl. Storage |VODPublish| filename \\192.168.120.254\DemoFS\Digital Assets\VODPublish\Temp\N0001344.dtd subfolder Temp\
t Transfer: 1220 : 12|02:51:57.2761|hGGNGu|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:57.2761|hGGNGu|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:57.2761|hGGNGu|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:57.2771|hGGNGu|CJPOWERCAST|GetUrl. Storage |VODPublish| filename \\192.168.120.254\DemoFS\Digital Assets\VODPublish\Temp\N0001345.xml subfolder Temp\
t Transfer: 1220 : 12|02:51:57.2771|hGGNGu|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:57.2771|hGGNGu|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:57.2771|hGGNGu|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:57.2771|hGGNGu|CJPOWERCAST|GetUrl. Storage |VODPublish| filename \\192.168.120.254\DemoFS\Digital Assets\VODPublish\Temp\N0001348.dtd subfolder Temp\
t Transfer: 1220 : 12|02:51:57.2771|hGGNGu|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:57.2771|hGGNGu|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:57.2771|hGGNGu|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:57.2771|hGGNGu|CJPOWERCAST|GetUrl. Storage |VODPublish| filename \\192.168.120.254\DemoFS\Digital Assets\VODPublish\Temp\N0001349.xml subfolder Temp\
t Transfer: 1220 : 12|02:51:57.2781|hGGNGu|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:57.2781|hGGNGu|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:57.2781|hGGNGu|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:57.2781|hGGNGu|CJPOWERCAST|GetUrl. Storage |Docs| filename I:\Docs\Mediaflex Supported Devices 2v03.pdf subfolder
t Transfer: 1220 : 12|02:51:57.2781|hGGNGu|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/DocsServer/Mediaflex%20Supported%20Devices%202v03.pdf
t Transfer: 1220 : 12|02:51:57.2781|hGGNGu|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/DocsServer/Mediaflex%20Supported%20Devices%202v03.pdf
t Transfer: 1220 : 12|02:51:57.2781|hGGNGu|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:57.2781|hGGNGu|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:57.2781|hGGNGu|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:57.2781|hGGNGu|CJPOWERCAST|GetUrl. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\BBC_graymeta_metadata.json subfolder
t Transfer: 1220 : 12|02:51:57.2781|hGGNGu|CJPOWERCAST| GetFileName result https://demo.tmd.tv/Temp Upload/BBC_graymeta_metadata.json
t Transfer: 1220 : 12|02:51:57.2791|hGGNGu|CJPOWERCAST|GetUrl. result https://demo.tmd.tv/Temp Upload/BBC_graymeta_metadata.json
t Transfer: 1220 : 12|02:51:57.2791|hGGNGu|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:57.2791|hGGNGu|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:57.2791|hGGNGu|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:57.2791|hGGNGu|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Game of Thrones - Blinkbox-HD.mp4 subfolder
t Transfer: 1220 : 12|02:51:57.2791|hGGNGu|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Game%20of%20Thrones%20-%20Blinkbox-HD.mp4
t Transfer: 1220 : 12|02:51:57.2791|hGGNGu|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/Game%20of%20Thrones%20-%20Blinkbox-HD.mp4
t Transfer: 1220 : 12|02:51:57.2791|hGGNGu|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:57.2801|hGGNGu|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:57.2801|hGGNGu|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:57.2801|hGGNGu|CJPOWERCAST|GetUrl. Storage |VODPublish| filename \\192.168.120.254\DemoFS\Digital Assets\VODPublish\Temp\N0001343.mp4 subfolder Temp\
t Transfer: 1220 : 12|02:51:57.2801|hGGNGu|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:57.2801|hGGNGu|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:57.2801|hGGNGu|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:57.2801|hGGNGu|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gotspecialspromo20seccharacter.mp4 subfolder
t Transfer: 1220 : 12|02:51:57.2801|hGGNGu|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gotspecialspromo20seccharacter.mp4
t Transfer: 1220 : 12|02:51:57.2811|hGGNGu|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/gotspecialspromo20seccharacter.mp4
t Transfer: 1220 : 12|02:51:57.2811|hGGNGu|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:57.2811|hGGNGu|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:57.2811|hGGNGu|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:57.2811|hGGNGu|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\gotspecialspromosimage.jpg subfolder
t Transfer: 1220 : 12|02:51:57.2811|hGGNGu|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/gotspecialspromosimage.jpg
t Transfer: 1220 : 12|02:51:57.2811|hGGNGu|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/gotspecialspromosimage.jpg
t Transfer: 1220 : 12|02:51:57.2811|hGGNGu|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:57.2821|hGGNGu|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:57.2821|hGGNGu|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:57.2821|hGGNGu|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\Example 06052020.mp4 subfolder
t Transfer: 1220 : 12|02:51:57.2821|hGGNGu|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/Example%2006052020.mp4
t Transfer: 1220 : 12|02:51:57.2821|hGGNGu|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/Example%2006052020.mp4
t Transfer: 1220 : 12|02:51:57.2821|hGGNGu|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:57.2821|hGGNGu|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:57.2821|hGGNGu|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:57.2831|hGGNGu|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gots0ep3us.mpd subfolder
t Transfer: 1220 : 12|02:51:57.2831|hGGNGu|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gots0ep3us.mpd
t Transfer: 1220 : 12|02:51:57.2831|hGGNGu|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/gots0ep3us.mpd
t Transfer: 1220 : 12|02:51:57.2831|hGGNGu|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:57.2831|hGGNGu|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:57.2831|hGGNGu|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:57.2831|hGGNGu|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Example 06052020.mp4 subfolder
t Transfer: 1220 : 12|02:51:57.2841|hGGNGu|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Example%2006052020.mp4
t Transfer: 1220 : 12|02:51:57.2841|hGGNGu|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/Example%2006052020.mp4
t Transfer: 1220 : 12|02:51:57.2841|hGGNGu|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:57.2841|hGGNGu|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:57.2841|hGGNGu|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:57.2841|hGGNGu|CJPOWERCAST|GetUrl. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\68add84afa7b\Animation Sample1.mp4 subfolder 68add84afa7b\
t Transfer: 1220 : 12|02:51:57.2841|hGGNGu|CJPOWERCAST| GetFileName result https://demo.tmd.tv/Temp Upload/Animation%20Sample1.mp4
t Transfer: 1220 : 12|02:51:57.2841|hGGNGu|CJPOWERCAST|GetUrl. result https://demo.tmd.tv/Temp Upload/Animation%20Sample1.mp4
t Transfer: 1220 : 12|02:51:57.2841|hGGNGu|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:57.2851|hGGNGu|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:57.2851|hGGNGu|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:57.2851|hGGNGu|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gotspecialspromo10secaction.mp4 subfolder
t Transfer: 1220 : 12|02:51:57.2851|hGGNGu|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gotspecialspromo10secaction.mp4
t Transfer: 1220 : 12|02:51:57.2851|hGGNGu|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/gotspecialspromo10secaction.mp4
t Transfer: 1220 : 12|02:51:57.2851|hGGNGu|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:57.2851|hGGNGu|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:57.2851|hGGNGu|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:57.2861|hGGNGu|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gots0ep5us.mpd subfolder
t Transfer: 1220 : 12|02:51:57.2861|hGGNGu|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gots0ep5us.mpd
t Transfer: 1220 : 12|02:51:57.2861|hGGNGu|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/gots0ep5us.mpd
t Transfer: 1220 : 12|02:51:57.2861|hGGNGu|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:57.2861|hGGNGu|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:57.2861|hGGNGu|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:57.2871|hGGNGu|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gots0ep2us.mpd subfolder
t Transfer: 1220 : 12|02:51:57.2871|hGGNGu|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gots0ep2us.mpd
t Transfer: 1220 : 12|02:51:57.2871|hGGNGu|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/gots0ep2us.mpd
t Transfer: 1220 : 12|02:51:57.2871|hGGNGu|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:57.2871|hGGNGu|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:57.2871|hGGNGu|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:57.2871|hGGNGu|CJPOWERCAST|GetUrl. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\cd16270b-696e-4e0b-9a0e-02a00f6c3c8d\2022년_통합인제스트_6월 근무표.xlsx subfolder cd16270b-696e-4e0b-9a0e-02a00f6c3c8d\
t Transfer: 1220 : 12|02:51:57.2871|hGGNGu|CJPOWERCAST| GetFileName result https://demo.tmd.tv/Temp Upload/2022%EB%85%84_%ED%86%B5%ED%95%A9%EC%9D%B8%EC%A0%9C%EC%8A%A4%ED%8A%B8_6%EC%9B%94%20%EA%B7%BC%EB%AC%B4%ED%91%9C.xlsx
t Transfer: 1220 : 12|02:51:57.2881|hGGNGu|CJPOWERCAST|GetUrl. result https://demo.tmd.tv/Temp Upload/2022%EB%85%84_%ED%86%B5%ED%95%A9%EC%9D%B8%EC%A0%9C%EC%8A%A4%ED%8A%B8_6%EC%9B%94%20%EA%B7%BC%EB%AC%B4%ED%91%9C.xlsx
t Transfer: 1220 : 12|02:51:57.2881|hGGNGu|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:57.2881|hGGNGu|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:57.2881|hGGNGu|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:57.2881|hGGNGu|CJPOWERCAST|GetUrl. Storage |PMH Video| filename \\10.46.131.12\Test\NGAM\Folder3\0008971.mp4 subfolder
t Transfer: 1220 : 12|02:51:57.2881|hGGNGu|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:57.2881|hGGNGu|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:57.2891|hGGNGu|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:57.2891|hGGNGu|CJPOWERCAST|GetUrl. Storage |PMH Proxy| filename \\10.46.131.12\Test\NGAM\Folder5\0154300FRM00_M0002176.mp4 subfolder
t Transfer: 1220 : 12|02:51:57.2891|hGGNGu|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:57.2891|hGGNGu|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:57.2891|hGGNGu|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:51:57.2891|cFp8ht|CJPOWERCAST|OAuth: /api/v3/mediaorder?_dc=1663293110235
t Transfer: 1220 : 12|02:51:57.2891|cFp8ht|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:57.2901|cFp8ht|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:57.2901|cFp8ht|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:51:57.2901|cFp8ht|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 : 12|02:51:57.4911|cFp8ht|CJPOWERCAST| semaphore enter at: 9/16/2022 2:51:57 AM count: 9 thread: 46
t Transfer: 1220 : 12|02:51:57.4911|cFp8ht|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:57.4911|cFp8ht|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:57.4911|cFp8ht|CJPOWERCAST| user CJPOWERCAST.
t Information: 1220 : 12|02:51:57.4911|cFp8ht|CJPOWERCAST|CallApi. In. Trace-id: yCC7PP Msg: createworkflow. User: CJPOWERCAST. Rights: False.
t Information: 1220 : 12|02:51:57.4911|cFp8ht|CJPOWERCAST|2510media/361779
t Transfer: 1220 : 12|02:51:57.8931|XJ4K0K|CJPOWERCAST|OAuth: /api/user-preferences?_dc=1663293110777
t Transfer: 1220 : 12|02:51:57.8931|XJ4K0K|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:57.8931|XJ4K0K|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:57.8931|XJ4K0K|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:51:57.8931|XJ4K0K|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Verbose: 1220 : 12|02:51:57.8931|XJ4K0K|CJPOWERCAST|StoreUserDataByKeys..
t Transfer: 1220 : 12|02:51:57.8931|XJ4K0K|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:51:57.8931|XJ4K0K|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:51:57.8931|XJ4K0K|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:51:57.8941|XJ4K0K|CJPOWERCAST|imfx v3 API took 0.009s '/api/user-preferences?_dc=1663293110777'
t Information: 1220 : 12|02:51:58.6861|cFp8ht|CJPOWERCAST|CallApi. Out. Trace-id: yCC7PP 1033.3ms.
t Information: 1220 : 12|02:51:58.6871|cFp8ht|CJPOWERCAST|
job/1680791680792510OnBoard & Publish DemoSFP1Queued122022-09-16T01:36:192022-09-16T02:51:58task/168080job/168079168080Data Move1Queued122022-09-16T02:51:58task/168083job/168079168083Digital ToolsMetadata Extract2Task Dependent4task/168086job/168079168086Workflow Decisions3Task Dependent4task/168091job/168079168091Transcode4Task Dependent4task/168094job/168079168094Assisted QC5Task Dependent4task/168097job/168079168097Workflow DecisionsAudio Count6Task Dependent4task/168100job/168079168100Digital ToolsBlack Detection7Task Dependent4task/168103job/168079168103Assess8Task Dependent4task/168106job/168079168106Transcode9Task Dependent4
t Transfer: 1220 : 12|02:51:58.7221|cFp8ht|CJPOWERCAST| semaphore release at: 9/16/2022 2:51:58 AM count: 9 thread: 46
t Verbose: 1220 : 12|02:51:58.7231|cFp8ht|CJPOWERCAST|imfx v3 API took 1.151s '/api/v3/mediaorder?_dc=1663293110235'
t Transfer: 1220 : 12|02:52:12.7931|QawYA4|CJPOWERCAST|OAuth: /api/user-group-preferences?keys=googleMapsApiSettings&_dc=1663293125724
t Transfer: 1220 : 12|02:52:12.7931|QawYA4|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:52:12.7931|QawYA4|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:52:12.7931|QawYA4|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:52:12.7931|QawYA4|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 : 12|02:52:12.7941|QawYA4|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:52:12.7941|QawYA4|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:52:12.7941|QawYA4|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:52:12.7941|QawYA4|CJPOWERCAST|imfx v3 API took 0.008s '/api/user-group-preferences?keys=googleMapsApiSettings&_dc=1663293125724'
t Transfer: 1220 : 12|02:52:12.9951|SOGwzV|CJPOWERCAST|OAuth: /api/v3/media-details/291743?_dc=1663293125957
t Transfer: 1220 : 12|02:52:12.9951|SOGwzV|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:52:12.9951|SOGwzV|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:52:12.9951|SOGwzV|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:52:12.9951|SOGwzV|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 : 12|02:52:13.1971|SOGwzV|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:52:13.1971|SOGwzV|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:52:13.1971|SOGwzV|CJPOWERCAST| user CJPOWERCAST.
t Information: 1220 : 12|02:52:13.5991|||TM_MIS. LoadSubtitles for ID: 291743
t Information: 1220 : 12|02:52:13.5991|||TM_MIS. LoadSubtitles for ID: 291743. SQL: 'select id, m_ctnr_id, m_ctnr_loc, modified_dt, tv_std, m_ctnr_fmt_id,
nvl((select max(l.language) from tm_audio l where l.miid=m.id),aud_language_id) aud_language_id
from tm_mis m where mi_deleted=0 and item_type>0 and media_type=101 and PGM_PARENT_ID=291740'
t Information: 1220 : 12|02:52:13.5991|||TM_MIS. LoadSubtitles for ID: 291743 found no subtitles.
t Verbose: 1220 : 12|02:52:13.5991|SOGwzV|CJPOWERCAST|imfx v3 API took 0.598s '/api/v3/media-details/291743?_dc=1663293125957'
t Transfer: 1220 : 12|02:52:13.8001|SOGwzV|CJPOWERCAST|GetUrl. Storage |Video| filename I:\Video\L0640441.mp4 subfolder
t Transfer: 1220 : 12|02:52:13.8001|SOGwzV|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/L0640441.mp4
t Transfer: 1220 : 12|02:52:13.8001|SOGwzV|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/L0640441.mp4
t Transfer: 1220 : 12|02:52:13.8001|SOGwzV|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:52:13.8001|SOGwzV|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:52:13.8001|SOGwzV|CJPOWERCAST| user CJPOWERCAST.
t Transfer: 1220 : 12|02:52:14.0021|QXZTGZ|CJPOWERCAST|OAuth: /api/v3/detailsview/MediaDetails/5?lang=en-GB&_dc=1663293126887
t Transfer: 1220 : 12|02:52:14.0021|QXZTGZ|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:52:14.0021|QXZTGZ|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:52:14.0021|QXZTGZ|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:52:14.0031|QXZTGZ|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 : 12|02:52:14.0031|QXZTGZ|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:52:14.0031|QXZTGZ|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:52:14.0031|QXZTGZ|CJPOWERCAST| user CJPOWERCAST.
t Information: 1220 : 12|02:52:14.0031|QXZTGZ|CJPOWERCAST|GetSystemPref. Pref: DetailsView, Type: -4013, subType: 5
t Information: 1220 : 12|02:52:14.0031|QXZTGZ|CJPOWERCAST|GetSystemPref. Pref: DetailsView, Type: -4013, subType: 0
t Information: 1220 : 12|02:52:14.0031|QXZTGZ|CJPOWERCAST|GetSystemPref. Pref: DetailsView, Type: -4013, subType: 5
t Information: 1220 : 12|02:52:14.0041|QXZTGZ|CJPOWERCAST|GetSystemPref. Pref: DetailsView, Type: -4013, subType: 0
t Verbose: 1220 : 12|02:52:14.2051|QXZTGZ|CJPOWERCAST|imfx v3 API took 0.098s '/api/v3/detailsview/MediaDetails/5?lang=en-GB&_dc=1663293126887'
t Transfer: 1220 : 12|02:52:14.4061|HJNmHe|CJPOWERCAST|OAuth: /api/v3/media-captions/291743?_dc=1663293127290
t Transfer: 1220 : 12|02:52:14.4061|HJNmHe|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:52:14.4061|HJNmHe|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:52:14.4061|HJNmHe|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:52:14.4061|HJNmHe|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Verbose: 1220 : 12|02:52:14.4061|HJNmHe|CJPOWERCAST|imfx v3 API took 0.058s '/api/v3/media-captions/291743?_dc=1663293127290'
t Transfer: 1220 : 12|02:52:14.4071|QQajw0|CJPOWERCAST|OAuth: /api/user-group-preferences?keys=googleMapsApiSettings&_dc=1663293127369
t Transfer: 1220 : 12|02:52:14.4071|QQajw0|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:52:14.4071|QQajw0|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:52:14.4071|QQajw0|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:52:14.4071|QQajw0|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 : 12|02:52:14.6081|q408g6|CJPOWERCAST|OAuth: /api/v3/mediavideo/291743?info=smudge,scene,audiovolume&_dc=1663293127366
t Transfer: 1220 : 12|02:52:14.6081|q408g6|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:52:14.6081|q408g6|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:52:14.6081|q408g6|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:52:14.6091|q408g6|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 : 12|02:52:14.6091|QQajw0|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:52:14.6091|QQajw0|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:52:14.6091|QQajw0|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:52:14.6091|QQajw0|CJPOWERCAST|imfx v3 API took 0.004s '/api/user-group-preferences?keys=googleMapsApiSettings&_dc=1663293127369'
t Transfer: 1220 : 12|02:52:14.6091|q408g6|CJPOWERCAST|GetUrl. Storage |Video| filename I:\Video\L0640441.mp4 subfolder
t Transfer: 1220 : 12|02:52:14.6091|q408g6|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/L0640441.mp4
t Transfer: 1220 : 12|02:52:14.6091|q408g6|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/L0640441.mp4
t Transfer: 1220 : 12|02:52:14.6091|q408g6|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:52:14.6091|q408g6|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:52:14.6101|q408g6|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:52:14.6101|q408g6|CJPOWERCAST|imfx v3 API took 0.121s '/api/v3/mediavideo/291743?info=smudge,scene,audiovolume&_dc=1663293127366'
t Transfer: 1220 : 12|02:52:14.8111|QLyYCS|CJPOWERCAST|OAuth: /api/lookups/FriendlyNames?_dc=1663293127584
t Transfer: 1220 : 12|02:52:14.8111|QLyYCS|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:52:14.8111|QLyYCS|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:52:14.8111|QLyYCS|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:52:14.8111|QLyYCS|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Verbose: 1220 : 12|02:52:14.8111|QLyYCS|CJPOWERCAST|imfx v3 API took 0.000s '/api/lookups/FriendlyNames?_dc=1663293127584'
t Transfer: 1220 : 12|02:52:14.8111|AvmVhC|CJPOWERCAST|OAuth: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1663293127670
t Transfer: 1220 : 12|02:52:14.8111|AvmVhC|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:52:14.8111|AvmVhC|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:52:14.8111|AvmVhC|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:52:14.8121|AvmVhC|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 : 12|02:52:14.8121|AvmVhC|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:52:14.8121|AvmVhC|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:52:14.8121|AvmVhC|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:52:14.8121|AvmVhC|CJPOWERCAST|imfx v3 API took 0.007s '/api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1663293127670'
t Transfer: 1220 : 12|02:52:15.2141|nwkv4T|CJPOWERCAST|OAuth: /api/v3/ai-tags/291743?_dc=1663293128019
t Transfer: 1220 : 12|02:52:15.2141|nwkv4T|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:52:15.2141|nwkv4T|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:52:15.2141|nwkv4T|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:52:15.2141|nwkv4T|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 : 12|02:52:15.2141|~dJI7l|CJPOWERCAST|OAuth: /api/v3/mediavideo/291743?info=smudge&_dc=1663293128022
t Transfer: 1220 : 12|02:52:15.2141|~dJI7l|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:52:15.2141|~dJI7l|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:52:15.2141|~dJI7l|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:52:15.2151|~dJI7l|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 : 12|02:52:15.2151|nwkv4T|CJPOWERCAST|V3Api.GetMediaAiTags
t Transfer: 1220 : 12|02:52:15.2151|~dJI7l|CJPOWERCAST|GetUrl. Storage |Video| filename I:\Video\L0640441.mp4 subfolder
t Transfer: 1220 : 12|02:52:15.2151|~dJI7l|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/L0640441.mp4
t Transfer: 1220 : 12|02:52:15.2151|~dJI7l|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/L0640441.mp4
t Transfer: 1220 : 12|02:52:15.2151|~dJI7l|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:52:15.2151|~dJI7l|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:52:15.2151|~dJI7l|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:52:15.2151|nwkv4T|CJPOWERCAST|imfx v3 API took 0.023s '/api/v3/ai-tags/291743?_dc=1663293128019'
t Verbose: 1220 : 12|02:52:15.2151|~dJI7l|CJPOWERCAST|imfx v3 API took 0.022s '/api/v3/mediavideo/291743?info=smudge&_dc=1663293128022'
t Transfer: 1220 : 12|02:52:15.2151|VjSF5u|CJPOWERCAST|OAuth: /api/metadata/4000/291743?_dc=1663293128061
t Transfer: 1220 : 12|02:52:15.2151|VjSF5u|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:52:15.2161|VjSF5u|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:52:15.2161|VjSF5u|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:52:15.2161|VjSF5u|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Verbose: 1220 : 12|02:52:15.2161|VjSF5u|CJPOWERCAST|imfx v3 API took 0.045s '/api/metadata/4000/291743?_dc=1663293128061'
t Transfer: 1220 : 12|02:52:22.6531|twiOw~|CJPOWERCAST|OAuth: /api/view/searchinfo/AutomatedTask?_dc=1663293135459
t Transfer: 1220 : 12|02:52:22.6531|twiOw~|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:52:22.6531|twiOw~|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:52:22.6531|twiOw~|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:52:22.6531|twiOw~|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 : 12|02:52:22.6531|Hw~Y93|CJPOWERCAST|OAuth: /api/user-group-preferences?keys=googleMapsApiSettings&_dc=1663293135322
t Transfer: 1220 : 12|02:52:22.6531|Hw~Y93|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:52:22.6531|Hw~Y93|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:52:22.6531|Hw~Y93|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:52:22.6531|Hw~Y93|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 : 12|02:52:22.6541|o8ED2U|CJPOWERCAST|OAuth: /api/user-preferences?keys=adv.recent.searches.queue&_dc=1663293135460
t Transfer: 1220 : 12|02:52:22.6541|o8ED2U|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:52:22.6541|o8ED2U|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:52:22.6541|o8ED2U|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:52:22.6541|o8ED2U|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 : 12|02:52:22.6541|twiOw~|CJPOWERCAST|GetAdvSearchColumns. search type AutomatedTask grid .
t Verbose: 1220 : 12|02:52:22.6541|twiOw~|CJPOWERCAST|imfx v3 API took 0.000s '/api/view/searchinfo/AutomatedTask?_dc=1663293135459'
t Transfer: 1220 : 12|02:52:22.6541|Hw~Y93|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:52:22.6541|Hw~Y93|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:52:22.6541|Hw~Y93|CJPOWERCAST| user CJPOWERCAST.
t Information: 1220 : 12|02:52:22.6541|o8ED2U|CJPOWERCAST|GetUserDataByKeys: adv.recent.searches.queue
t Transfer: 1220 : 12|02:52:22.6541|o8ED2U|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:52:22.6551|o8ED2U|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:52:22.6551|o8ED2U|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:52:22.6551|o8ED2U|CJPOWERCAST|imfx v3 API took 0.005s '/api/user-preferences?keys=adv.recent.searches.queue&_dc=1663293135460'
t Verbose: 1220 : 12|02:52:22.6551|Hw~Y93|CJPOWERCAST|imfx v3 API took 0.005s '/api/user-group-preferences?keys=googleMapsApiSettings&_dc=1663293135322'
t Transfer: 1220 : 12|02:52:22.6551|~vps0R|CJPOWERCAST|OAuth: /api/view/searches/AutomatedTask?_dc=1663293135477
t Transfer: 1220 : 12|02:52:22.6551|~vps0R|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:52:22.6551|~vps0R|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:52:22.6551|~vps0R|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:52:22.6551|~vps0R|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 : 12|02:52:22.6551|NMtoLL|CJPOWERCAST|OAuth: /api/view/info/AutomatedTask?lang=en-GB&_dc=1663293135479
t Transfer: 1220 : 12|02:52:22.6551|NMtoLL|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:52:22.6551|NMtoLL|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:52:22.6561|NMtoLL|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:52:22.6561|NMtoLL|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 : 12|02:52:22.6561|~vps0R|CJPOWERCAST|GetSavedSearchNames. search type AutomatedTask.
t Transfer: 1220 : 12|02:52:22.6561|~vps0R|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:52:22.6561|~vps0R|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:52:22.6561|~vps0R|CJPOWERCAST| user CJPOWERCAST.
t Information: 1220 : 12|02:52:22.6561|NMtoLL|CJPOWERCAST|GetGridViewBuilder. builder type AutomatedTask.
t Transfer: 1220 : 12|02:52:22.6561|NMtoLL|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:52:22.6561|NMtoLL|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:52:22.6561|NMtoLL|CJPOWERCAST| user CJPOWERCAST.
t Information: 1220 : 12|02:52:22.6561|NMtoLL|CJPOWERCAST|UserGridView. LoadView. ID -2, Name Default.
t Transfer: 1220 : 12|02:52:22.6561|NMtoLL|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:52:22.6561|NMtoLL|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:52:22.6571|NMtoLL|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:52:22.6571|~vps0R|CJPOWERCAST|imfx v3 API took 0.005s '/api/view/searches/AutomatedTask?_dc=1663293135477'
t Transfer: 1220 : 12|02:52:22.6571|NMtoLL|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:52:22.6571|NMtoLL|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:52:22.6571|NMtoLL|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:52:22.6571|NMtoLL|CJPOWERCAST|imfx v3 API took 0.007s '/api/view/info/AutomatedTask?lang=en-GB&_dc=1663293135479'
t Transfer: 1220 : 12|02:52:22.8581|M40wPB|CJPOWERCAST|OAuth: /api/lookup/AutomatedTasksTypes?_dc=1663293135585
t Transfer: 1220 : 12|02:52:22.8581|M40wPB|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:52:22.8581|M40wPB|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:52:22.8581|M40wPB|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:52:22.8581|M40wPB|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Verbose: 1220 : 12|02:52:22.8581|M40wPB|CJPOWERCAST|imfx v3 API took 0.004s '/api/lookup/AutomatedTasksTypes?_dc=1663293135585'
t Transfer: 1220 : 12|02:52:24.6671|26nTzA|CJPOWERCAST|OAuth: /api/v3/search/queue?_dc=1663293137562
t Transfer: 1220 : 12|02:52:24.6671|26nTzA|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:52:24.6671|26nTzA|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:52:24.6671|26nTzA|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:52:24.6671|26nTzA|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 : 12|02:52:24.6671|26nTzA|CJPOWERCAST|V3Api.SearchQueue
t Information: 1220 : 12|02:52:24.6671|26nTzA|CJPOWERCAST|V3Api.SearchGeneric
t Information: 1220 : 12|02:52:24.7851|26nTzA|CJPOWERCAST|V3Api.SearchGeneric exception: System.ArgumentNullException: Select at least one action
Parameter name: ACTION
at xMfxDataLogic.ServiceLogic.SearchImplementation.SearchAutomatedTasksAdvancedContext(List`1 searchCriteria, String SearchQuery, Int32 page, SearchSortOrder SortOrder, List`1 SearchColumns, List`1 extendedColumns, Int32& totalRows) in C:\TeamCity\buildAgent\work\405c64e443a47d83\Server\xMfxDataLogic\Logic\ServiceLogic\Search\SearchQManager.cs:line 113
at xMfxDataLogic.ServiceLogic.SearchImplementation.SearchAdvanced(SearchType searchType, List`1 searchCriteria, String searchQuery, Int32 page, List`1 sortOrderColumns, List`1 searchColumns, List`1 extendedColumns, Int32 pageSize, Int32& totalRows, SearchFacets& facets, SearchOptions searchOptions, Nullable`1 fullTree, List`1 facetFieldsOverride) in C:\TeamCity\buildAgent\work\405c64e443a47d83\Server\xMfxDataLogic\Logic\ServiceLogic\Search\AdvancedSearch.cs:line 150
at iMfxServerCore.Api.v3.SearchController.SearchGeneric(SearchRequest search, SearchType searchType, Int32 pageSize, Boolean forceOracleSearch, Nullable`1 fullTree) in C:\TeamCity\buildAgent\work\405c64e443a47d83\Server\iMfxServerCore\api\controllers\v3\SearchController.cs:line 452
at iMfxServerCore.Api.v3.SearchController.SearchQueue(SearchRequest search) in C:\TeamCity\buildAgent\work\405c64e443a47d83\Server\iMfxServerCore\api\controllers\v3\SearchController.cs:line 211
at lambda_method(Closure , Object , Object[] )
at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass6_2.b__2(Object instance, Object[] methodParameters)
at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.Execute(Object instance, Object[] arguments)
at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ExecuteAsync(HttpControllerContext controllerContext, IDictionary`2 arguments, CancellationToken cancellationToken)
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.Http.Controllers.ApiControllerActionInvoker.d__1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.Http.Filters.ActionFilterAttribute.d__6.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Web.Http.Filters.ActionFilterAttribute.d__6.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.Http.Filters.ActionFilterAttribute.d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.Http.Filters.ActionFilterAttribute.d__6.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Web.Http.Filters.ActionFilterAttribute.d__6.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.Http.Filters.ActionFilterAttribute.d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.Http.Controllers.ActionFilterResult.d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.Http.Filters.AuthorizationFilterAttribute.d__3.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.Http.Controllers.ExceptionFilterResult.d__6.MoveNext()
t Verbose: 1220 : 12|02:52:24.7851|26nTzA|CJPOWERCAST|imfx v3 API took 0.014s '/api/v3/search/queue?_dc=1663293137562'
t Information: 1220 : 12|02:52:24.7851|26nTzA|CJPOWERCAST|V3 Api exception handler: System.ArgumentNullException: Select at least one action
Parameter name: ACTION
at xMfxDataLogic.ServiceLogic.SearchImplementation.SearchAutomatedTasksAdvancedContext(List`1 searchCriteria, String SearchQuery, Int32 page, SearchSortOrder SortOrder, List`1 SearchColumns, List`1 extendedColumns, Int32& totalRows) in C:\TeamCity\buildAgent\work\405c64e443a47d83\Server\xMfxDataLogic\Logic\ServiceLogic\Search\SearchQManager.cs:line 113
at xMfxDataLogic.ServiceLogic.SearchImplementation.SearchAdvanced(SearchType searchType, List`1 searchCriteria, String searchQuery, Int32 page, List`1 sortOrderColumns, List`1 searchColumns, List`1 extendedColumns, Int32 pageSize, Int32& totalRows, SearchFacets& facets, SearchOptions searchOptions, Nullable`1 fullTree, List`1 facetFieldsOverride) in C:\TeamCity\buildAgent\work\405c64e443a47d83\Server\xMfxDataLogic\Logic\ServiceLogic\Search\AdvancedSearch.cs:line 150
at iMfxServerCore.Api.v3.SearchController.SearchGeneric(SearchRequest search, SearchType searchType, Int32 pageSize, Boolean forceOracleSearch, Nullable`1 fullTree) in C:\TeamCity\buildAgent\work\405c64e443a47d83\Server\iMfxServerCore\api\controllers\v3\SearchController.cs:line 452
at iMfxServerCore.Api.v3.SearchController.SearchQueue(SearchRequest search) in C:\TeamCity\buildAgent\work\405c64e443a47d83\Server\iMfxServerCore\api\controllers\v3\SearchController.cs:line 211
at lambda_method(Closure , Object , Object[] )
at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass6_2.b__2(Object instance, Object[] methodParameters)
at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.Execute(Object instance, Object[] arguments)
at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ExecuteAsync(HttpControllerContext controllerContext, IDictionary`2 arguments, CancellationToken cancellationToken)
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.Http.Controllers.ApiControllerActionInvoker.d__1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.Http.Filters.ActionFilterAttribute.d__6.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Web.Http.Filters.ActionFilterAttribute.d__6.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.Http.Filters.ActionFilterAttribute.d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.Http.Filters.ActionFilterAttribute.d__6.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Web.Http.Filters.ActionFilterAttribute.d__6.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.Http.Filters.ActionFilterAttribute.d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.Http.Controllers.ActionFilterResult.d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.Http.Filters.AuthorizationFilterAttribute.d__3.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.Http.Controllers.ExceptionFilterResult.d__6.MoveNext()
[POST] https://imfxv3tm.tmd.tv/api/v3/search/queue?_dc=1663293137562
System.Web.Http.Routing.HttpRoute
t Transfer: 1220 : 12|02:52:28.0021|uw8ndv|CJPOWERCAST|OAuth: /api/v3/search/workflow?_dc=1663293140891
t Transfer: 1220 : 12|02:52:28.0021|uw8ndv|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:52:28.0021|uw8ndv|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:52:28.0021|uw8ndv|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:52:28.0021|uw8ndv|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 : 12|02:52:28.0021|uw8ndv|CJPOWERCAST|V3Api.SearchWorkflows
t Information: 1220 : 12|02:52:28.0021|uw8ndv|CJPOWERCAST|V3Api.SearchGeneric
t Transfer: 1220 : 12|02:52:28.0021|uw8ndv|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:52:28.0021|uw8ndv|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:52:28.0031|uw8ndv|CJPOWERCAST| user CJPOWERCAST.
t Information: 1220 : 12|02:52:28.0031|uw8ndv|CJPOWERCAST|SearchJob SQL:
select * from (select a.*, rownum rnum from ( select /*+ INDEX(j JB_CMBST_IDX) */ j.*
,p.pname
,mi.tv_std
,mi.MIID1, mi.MIID2, mi.MIID3, mi.VERSIONID1, mi.VERSIONID2, mi.PROGID1, mi.PROGID2
,txd.NEXT_TX_DATE
FROM tm_mjob j
left join tm_mjob_pset p on j.j_sched_indx=p.id
,lateral(select j_id, TMD_str_agg(distinct miid1) MIID1,
TMD_str_agg(distinct miid2) MIID2,
TMD_str_agg(distinct miid3) MIID3,
TMD_str_agg(distinct versionid1) VERSIONID1,
TMD_str_agg(distinct versionid2) VERSIONID2,
TMD_str_agg(distinct progid1) PROGID1,
TMD_str_agg(distinct progid2) PROGID2,
TMD_str_agg(distinct m.tv_std) TV_STD,
TMD_str_agg(distinct m.title) TITLE from tm_mis m, tm_mtsk_it i
where i.j_id=j.id and m.id=i.mi_id and i.src_dest in (2,3) group by j_id)(+) mi
,lateral (
SELECT it.j_id, min(sch.tx_tm_st) NEXT_TX_DATE FROM TM_MTSK_IT it, TM_MIS m, hr_sched sch
WHERE it.j_id=j.id and m.id = it.MI_ID AND (sch.prod_num = m.PROGID2 OR sch.prod_num = (select rl.VERSIONID1 from TM_PG_RL rl where rl.ID = m.PGM_PARENT_ID)) AND sch.tx_tm_st > sysdate
GROUP BY it.J_ID)(+) txd
where 1=1 AND j.ID = :param_0 AND (INSTR(j.J_CLIENTS, '|SFP2|') > 0 OR INSTR(j.J_CLIENTS, '|PSP|') > 0 OR INSTR(j.J_CLIENTS, '|PMS|') > 0 OR INSTR(j.J_CLIENTS, '|SFP1|') > 0 OR INSTR(j.J_CLIENTS, '|PMH|') > 0 OR INSTR(j.J_CLIENTS, '|PPL|') > 0) order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum
t Information: 1220 : 12|02:52:28.2041|uw8ndv|CJPOWERCAST| jobs returned 1, searched in 00:00:00.1516385
t Information: 1220 : 12|02:52:28.2041|uw8ndv|CJPOWERCAST| tasks returned 1, searched in 00:00:00.0332636
t Verbose: 1220 : 12|02:52:28.2041|uw8ndv|CJPOWERCAST|imfx v3 API took 0.209s '/api/v3/search/workflow?_dc=1663293140891'
t Transfer: 1220 : 12|02:52:30.8241|hNhdwh|CJPOWERCAST|OAuth: /api/v3/search/workflow?_dc=1663293143701
t Transfer: 1220 : 12|02:52:30.8241|hNhdwh|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:52:30.8241|hNhdwh|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:52:30.8381|hNhdwh|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:52:30.8391|hNhdwh|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 : 12|02:52:30.8391|hNhdwh|CJPOWERCAST|V3Api.SearchWorkflows
t Information: 1220 : 12|02:52:30.8391|hNhdwh|CJPOWERCAST|V3Api.SearchGeneric
t Transfer: 1220 : 12|02:52:30.8391|hNhdwh|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:52:30.8391|hNhdwh|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:52:30.8391|hNhdwh|CJPOWERCAST| user CJPOWERCAST.
t Information: 1220 : 12|02:52:30.8391|hNhdwh|CJPOWERCAST|SearchJob SQL:
select * from (select a.*, rownum rnum from ( select /*+ INDEX(j JB_CMBST_IDX) */ j.*
,p.pname
,mi.tv_std
,mi.MIID1, mi.MIID2, mi.MIID3, mi.VERSIONID1, mi.VERSIONID2, mi.PROGID1, mi.PROGID2
,txd.NEXT_TX_DATE
FROM tm_mjob j
left join tm_mjob_pset p on j.j_sched_indx=p.id
,lateral(select j_id, TMD_str_agg(distinct miid1) MIID1,
TMD_str_agg(distinct miid2) MIID2,
TMD_str_agg(distinct miid3) MIID3,
TMD_str_agg(distinct versionid1) VERSIONID1,
TMD_str_agg(distinct versionid2) VERSIONID2,
TMD_str_agg(distinct progid1) PROGID1,
TMD_str_agg(distinct progid2) PROGID2,
TMD_str_agg(distinct m.tv_std) TV_STD,
TMD_str_agg(distinct m.title) TITLE from tm_mis m, tm_mtsk_it i
where i.j_id=j.id and m.id=i.mi_id and i.src_dest in (2,3) group by j_id)(+) mi
,lateral (
SELECT it.j_id, min(sch.tx_tm_st) NEXT_TX_DATE FROM TM_MTSK_IT it, TM_MIS m, hr_sched sch
WHERE it.j_id=j.id and m.id = it.MI_ID AND (sch.prod_num = m.PROGID2 OR sch.prod_num = (select rl.VERSIONID1 from TM_PG_RL rl where rl.ID = m.PGM_PARENT_ID)) AND sch.tx_tm_st > sysdate
GROUP BY it.J_ID)(+) txd
where 1=1 AND not ( j.CMB_STAT = 19 and j.J_FAILURE_RESOLVED > 0 ) and j.cmb_stat not in (15,18,23) AND (INSTR(j.J_CLIENTS, '|SFP2|') > 0 OR INSTR(j.J_CLIENTS, '|PSP|') > 0 OR INSTR(j.J_CLIENTS, '|PMS|') > 0 OR INSTR(j.J_CLIENTS, '|SFP1|') > 0 OR INSTR(j.J_CLIENTS, '|PMH|') > 0 OR INSTR(j.J_CLIENTS, '|PPL|') > 0) order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum
t Information: 1220 : 12|02:52:30.8401|hNhdwh|CJPOWERCAST| jobs returned 35, searched in 00:00:00.0399665
t Information: 1220 : 12|02:52:31.0411|hNhdwh|CJPOWERCAST| tasks returned 35, searched in 00:00:00.1507098
t Verbose: 1220 : 12|02:52:31.0411|hNhdwh|CJPOWERCAST|imfx v3 API took 0.198s '/api/v3/search/workflow?_dc=1663293143701'
t Transfer: 1220 : 12|02:52:32.2471|Z0wI1a|CJPOWERCAST|OAuth: /api/user-preferences?_dc=1663293145119
t Transfer: 1220 : 12|02:52:32.2471|Z0wI1a|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:52:32.2471|Z0wI1a|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:52:32.2471|Z0wI1a|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:52:32.2471|Z0wI1a|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Verbose: 1220 : 12|02:52:32.2481|Z0wI1a|CJPOWERCAST|StoreUserDataByKeys..
t Transfer: 1220 : 12|02:52:32.2481|Z0wI1a|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:52:32.2481|Z0wI1a|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:52:32.2481|Z0wI1a|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:52:32.2481|Z0wI1a|CJPOWERCAST|imfx v3 API took 0.007s '/api/user-preferences?_dc=1663293145119'
t Transfer: 1220 : 12|02:52:34.4591|7TbfC4|CJPOWERCAST|OAuth: /api/v3/search/workflow?_dc=1663293147353
t Transfer: 1220 : 12|02:52:34.4591|7TbfC4|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:52:34.4591|7TbfC4|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:52:34.4591|7TbfC4|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:52:34.4591|7TbfC4|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 : 12|02:52:34.4601|7TbfC4|CJPOWERCAST|V3Api.SearchWorkflows
t Information: 1220 : 12|02:52:34.4601|7TbfC4|CJPOWERCAST|V3Api.SearchGeneric
t Transfer: 1220 : 12|02:52:34.4601|7TbfC4|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:52:34.4601|7TbfC4|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:52:34.4601|7TbfC4|CJPOWERCAST| user CJPOWERCAST.
t Information: 1220 : 12|02:52:34.4601|7TbfC4|CJPOWERCAST|SearchJob SQL:
select * from (select a.*, rownum rnum from ( select /*+ INDEX(j JB_CMBST_IDX) */ j.*
,p.pname
,mi.tv_std
,mi.MIID1, mi.MIID2, mi.MIID3, mi.VERSIONID1, mi.VERSIONID2, mi.PROGID1, mi.PROGID2
,txd.NEXT_TX_DATE
FROM tm_mjob j
left join tm_mjob_pset p on j.j_sched_indx=p.id
,lateral(select j_id, TMD_str_agg(distinct miid1) MIID1,
TMD_str_agg(distinct miid2) MIID2,
TMD_str_agg(distinct miid3) MIID3,
TMD_str_agg(distinct versionid1) VERSIONID1,
TMD_str_agg(distinct versionid2) VERSIONID2,
TMD_str_agg(distinct progid1) PROGID1,
TMD_str_agg(distinct progid2) PROGID2,
TMD_str_agg(distinct m.tv_std) TV_STD,
TMD_str_agg(distinct m.title) TITLE from tm_mis m, tm_mtsk_it i
where i.j_id=j.id and m.id=i.mi_id and i.src_dest in (2,3) group by j_id)(+) mi
,lateral (
SELECT it.j_id, min(sch.tx_tm_st) NEXT_TX_DATE FROM TM_MTSK_IT it, TM_MIS m, hr_sched sch
WHERE it.j_id=j.id and m.id = it.MI_ID AND (sch.prod_num = m.PROGID2 OR sch.prod_num = (select rl.VERSIONID1 from TM_PG_RL rl where rl.ID = m.PGM_PARENT_ID)) AND sch.tx_tm_st > sysdate
GROUP BY it.J_ID)(+) txd
where 1=1 AND not ( j.CMB_STAT = 19 and j.J_FAILURE_RESOLVED > 0 ) and j.cmb_stat not in (15,18,23) AND (INSTR(j.J_CLIENTS, '|SFP2|') > 0 OR INSTR(j.J_CLIENTS, '|PSP|') > 0 OR INSTR(j.J_CLIENTS, '|PMS|') > 0 OR INSTR(j.J_CLIENTS, '|SFP1|') > 0 OR INSTR(j.J_CLIENTS, '|PMH|') > 0 OR INSTR(j.J_CLIENTS, '|PPL|') > 0) order by j.J_CREATED, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum
t Information: 1220 : 12|02:52:34.6611|7TbfC4|CJPOWERCAST| jobs returned 35, searched in 00:00:00.1860589
t Information: 1220 : 12|02:52:34.8621|7TbfC4|CJPOWERCAST| tasks returned 35, searched in 00:00:00.1252488
t Verbose: 1220 : 12|02:52:34.8621|7TbfC4|CJPOWERCAST|imfx v3 API took 0.319s '/api/v3/search/workflow?_dc=1663293147353'
t Transfer: 1220 : 12|02:52:35.4651|2sj2Bx|CJPOWERCAST|OAuth: /api/user-preferences?_dc=1663293148269
t Transfer: 1220 : 12|02:52:35.4651|2sj2Bx|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:52:35.4651|2sj2Bx|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:52:35.4651|2sj2Bx|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:52:35.4651|2sj2Bx|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Verbose: 1220 : 12|02:52:35.4651|2sj2Bx|CJPOWERCAST|StoreUserDataByKeys..
t Transfer: 1220 : 12|02:52:35.4651|2sj2Bx|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:52:35.4651|2sj2Bx|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:52:35.4661|2sj2Bx|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:52:35.4661|2sj2Bx|CJPOWERCAST|imfx v3 API took 0.008s '/api/user-preferences?_dc=1663293148269'
t Transfer: 1220 : 12|02:52:36.0691|hYxey4|CJPOWERCAST|OAuth: /api/v3/search/workflow?_dc=1663293148868
t Transfer: 1220 : 12|02:52:36.0691|hYxey4|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:52:36.0691|hYxey4|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:52:36.0691|hYxey4|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:52:36.0691|hYxey4|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 : 12|02:52:36.0691|hYxey4|CJPOWERCAST|V3Api.SearchWorkflows
t Information: 1220 : 12|02:52:36.0691|hYxey4|CJPOWERCAST|V3Api.SearchGeneric
t Transfer: 1220 : 12|02:52:36.0691|hYxey4|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:52:36.0701|hYxey4|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:52:36.0701|hYxey4|CJPOWERCAST| user CJPOWERCAST.
t Information: 1220 : 12|02:52:36.0701|hYxey4|CJPOWERCAST|SearchJob SQL:
select * from (select a.*, rownum rnum from ( select /*+ INDEX(j JB_CMBST_IDX) */ j.*
,p.pname
,mi.tv_std
,mi.MIID1, mi.MIID2, mi.MIID3, mi.VERSIONID1, mi.VERSIONID2, mi.PROGID1, mi.PROGID2
,txd.NEXT_TX_DATE
FROM tm_mjob j
left join tm_mjob_pset p on j.j_sched_indx=p.id
,lateral(select j_id, TMD_str_agg(distinct miid1) MIID1,
TMD_str_agg(distinct miid2) MIID2,
TMD_str_agg(distinct miid3) MIID3,
TMD_str_agg(distinct versionid1) VERSIONID1,
TMD_str_agg(distinct versionid2) VERSIONID2,
TMD_str_agg(distinct progid1) PROGID1,
TMD_str_agg(distinct progid2) PROGID2,
TMD_str_agg(distinct m.tv_std) TV_STD,
TMD_str_agg(distinct m.title) TITLE from tm_mis m, tm_mtsk_it i
where i.j_id=j.id and m.id=i.mi_id and i.src_dest in (2,3) group by j_id)(+) mi
,lateral (
SELECT it.j_id, min(sch.tx_tm_st) NEXT_TX_DATE FROM TM_MTSK_IT it, TM_MIS m, hr_sched sch
WHERE it.j_id=j.id and m.id = it.MI_ID AND (sch.prod_num = m.PROGID2 OR sch.prod_num = (select rl.VERSIONID1 from TM_PG_RL rl where rl.ID = m.PGM_PARENT_ID)) AND sch.tx_tm_st > sysdate
GROUP BY it.J_ID)(+) txd
where 1=1 AND not ( j.CMB_STAT = 19 and j.J_FAILURE_RESOLVED > 0 ) and j.cmb_stat not in (15,18,23) AND (INSTR(j.J_CLIENTS, '|SFP2|') > 0 OR INSTR(j.J_CLIENTS, '|PSP|') > 0 OR INSTR(j.J_CLIENTS, '|PMS|') > 0 OR INSTR(j.J_CLIENTS, '|SFP1|') > 0 OR INSTR(j.J_CLIENTS, '|PMH|') > 0 OR INSTR(j.J_CLIENTS, '|PPL|') > 0) order by j.J_CREATED DESC , j.id ) a where rownum <= 50) where rnum >= 1 order by rnum
t Information: 1220 : 12|02:52:36.2711|hYxey4|CJPOWERCAST| jobs returned 35, searched in 00:00:00.1903971
t Information: 1220 : 12|02:52:36.2711|hYxey4|CJPOWERCAST| tasks returned 35, searched in 00:00:00.0987858
t Verbose: 1220 : 12|02:52:36.2711|hYxey4|CJPOWERCAST|imfx v3 API took 0.296s '/api/v3/search/workflow?_dc=1663293148868'
t Transfer: 1220 : 12|02:52:36.8741|I_iz6y|CJPOWERCAST|OAuth: /api/user-preferences?_dc=1663293149755
t Transfer: 1220 : 12|02:52:36.8741|I_iz6y|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:52:36.8741|I_iz6y|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:52:36.8741|I_iz6y|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:52:36.8741|I_iz6y|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Verbose: 1220 : 12|02:52:36.8741|I_iz6y|CJPOWERCAST|StoreUserDataByKeys..
t Transfer: 1220 : 12|02:52:36.8741|I_iz6y|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:52:36.8751|I_iz6y|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:52:36.8751|I_iz6y|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:52:36.8751|I_iz6y|CJPOWERCAST|imfx v3 API took 0.006s '/api/user-preferences?_dc=1663293149755'
t Transfer: 1220 : 12|02:52:55.7691|di9JOP|CJPOWERCAST|OAuth: /api/v3/job/164952?_dc=1663293168547
t Transfer: 1220 : 12|02:52:55.7691|di9JOP|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:52:55.7691|di9JOP|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:52:55.7691|di9JOP|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:52:55.7701|di9JOP|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Verbose: 1220 : 12|02:52:56.7751|di9JOP|CJPOWERCAST|imfx v3 API took 1.026s '/api/v3/job/164952?_dc=1663293168547'
t Transfer: 1220 : 12|02:53:07.0261|_Fk3km|CJPOWERCAST|OAuth: /api/v3/job/164952/basic?_dc=1663293179947
t Transfer: 1220 : 12|02:53:07.0261|_Fk3km|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:53:07.0261|_Fk3km|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:53:07.0261|_Fk3km|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:53:07.0271|_Fk3km|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Verbose: 1220 : 12|02:53:07.0271|_Fk3km|CJPOWERCAST|imfx v3 API took 0.013s '/api/v3/job/164952/basic?_dc=1663293179947'
t Transfer: 1220 : 12|02:53:17.6801|BfClxO|CJPOWERCAST|OAuth: /api/v3/search/workflow?_dc=1663293190590
t Transfer: 1220 : 12|02:53:17.6801|BfClxO|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:53:17.6801|BfClxO|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:53:17.6801|BfClxO|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:53:17.6801|BfClxO|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 : 12|02:53:17.6801|BfClxO|CJPOWERCAST|V3Api.SearchWorkflows
t Information: 1220 : 12|02:53:17.6801|BfClxO|CJPOWERCAST|V3Api.SearchGeneric
t Transfer: 1220 : 12|02:53:17.6801|BfClxO|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:53:17.6811|BfClxO|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:53:17.6811|BfClxO|CJPOWERCAST| user CJPOWERCAST.
t Information: 1220 : 12|02:53:17.6811|BfClxO|CJPOWERCAST|SearchJob SQL:
select * from (select a.*, rownum rnum from ( select /*+ INDEX(j JB_CMBST_IDX) */ j.*
,p.pname
,mi.tv_std
,mi.MIID1, mi.MIID2, mi.MIID3, mi.VERSIONID1, mi.VERSIONID2, mi.PROGID1, mi.PROGID2
,txd.NEXT_TX_DATE
FROM tm_mjob j
left join tm_mjob_pset p on j.j_sched_indx=p.id
,lateral(select j_id, TMD_str_agg(distinct miid1) MIID1,
TMD_str_agg(distinct miid2) MIID2,
TMD_str_agg(distinct miid3) MIID3,
TMD_str_agg(distinct versionid1) VERSIONID1,
TMD_str_agg(distinct versionid2) VERSIONID2,
TMD_str_agg(distinct progid1) PROGID1,
TMD_str_agg(distinct progid2) PROGID2,
TMD_str_agg(distinct m.tv_std) TV_STD,
TMD_str_agg(distinct m.title) TITLE from tm_mis m, tm_mtsk_it i
where i.j_id=j.id and m.id=i.mi_id and i.src_dest in (2,3) group by j_id)(+) mi
,lateral (
SELECT it.j_id, min(sch.tx_tm_st) NEXT_TX_DATE FROM TM_MTSK_IT it, TM_MIS m, hr_sched sch
WHERE it.j_id=j.id and m.id = it.MI_ID AND (sch.prod_num = m.PROGID2 OR sch.prod_num = (select rl.VERSIONID1 from TM_PG_RL rl where rl.ID = m.PGM_PARENT_ID)) AND sch.tx_tm_st > sysdate
GROUP BY it.J_ID)(+) txd
where 1=1 AND j.ID = :param_0 AND (INSTR(j.J_CLIENTS, '|SFP2|') > 0 OR INSTR(j.J_CLIENTS, '|PSP|') > 0 OR INSTR(j.J_CLIENTS, '|PMS|') > 0 OR INSTR(j.J_CLIENTS, '|SFP1|') > 0 OR INSTR(j.J_CLIENTS, '|PMH|') > 0 OR INSTR(j.J_CLIENTS, '|PPL|') > 0) order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum
t Information: 1220 : 12|02:53:17.8821|BfClxO|CJPOWERCAST| jobs returned 1, searched in 00:00:00.1541191
t Information: 1220 : 12|02:53:17.8821|BfClxO|CJPOWERCAST| tasks returned 1, searched in 00:00:00.0273133
t Verbose: 1220 : 12|02:53:17.8821|BfClxO|CJPOWERCAST|imfx v3 API took 0.188s '/api/v3/search/workflow?_dc=1663293190590'
t Transfer: 1220 : 12|02:53:19.6911|lu2r~S|CJPOWERCAST|OAuth: /api/v3/job/168079?_dc=1663293192607
t Transfer: 1220 : 12|02:53:19.6911|lu2r~S|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:53:19.6911|lu2r~S|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:53:19.6911|lu2r~S|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:53:19.6911|lu2r~S|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Verbose: 1220 : 12|02:53:19.8921|lu2r~S|CJPOWERCAST|imfx v3 API took 0.148s '/api/v3/job/168079?_dc=1663293192607'
t Transfer: 1220 : 12|02:53:30.3431|s9Md2U|CJPOWERCAST|OAuth: /api/v3/job/168079/basic?_dc=1663293203148
t Transfer: 1220 : 12|02:53:30.3431|s9Md2U|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:53:30.3431|s9Md2U|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:53:30.3431|s9Md2U|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:53:30.3441|s9Md2U|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Verbose: 1220 : 12|02:53:30.3441|s9Md2U|CJPOWERCAST|imfx v3 API took 0.004s '/api/v3/job/168079/basic?_dc=1663293203148'
t Transfer: 1220 : 12|02:53:36.1731|wkVLmR|CJPOWERCAST|OAuth: /api/v3/search/Media?_dc=1663293209095
t Transfer: 1220 : 12|02:53:36.1731|wkVLmR|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:53:36.1731|wkVLmR|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:53:36.1731|wkVLmR|CJPOWERCAST| user CJPOWERCAST.
t Verbose: 1220 : 12|02:53:36.1731|wkVLmR|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 : 12|02:53:36.1731|wkVLmR|CJPOWERCAST|V3Api.SearchMedia
t Information: 1220 : 12|02:53:36.1731|wkVLmR|CJPOWERCAST|V3Api.SearchGeneric
t Transfer: 1220 : 12|02:53:36.1731|wkVLmR|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:53:36.1731|wkVLmR|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:53:36.1731|wkVLmR|CJPOWERCAST| user CJPOWERCAST.
t Information: 1220 : 12|02:53:36.1741|wkVLmR|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 min(status.ACCESS_STATUS_NAME) FROM TMDDBA.TM_ACCESS_STATUS statusLnx, TM_CFG_ACCESS_STATUS status
WHERE statusLnx.Media_Id = r.id and statusLnx.Status_Id = status.id) ACCESS_STATUS , (select min(acq.ext_ref) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) CONSIGNMENT_NUMBER ,
(select min(acq.alt_id1) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) TRANSFER_NUMBER ,
(select min(crs.series_number) from tm_series_data crs where crs.id = r.GROUP_SERIES_ID) CRS_SERIES ,
(select min(DISPOSAL_NAME) from TM_ACQ_DISPOSAL status, tm_disposal_records records
where status.id = records.disposal_status_id and records.miid = r.id) DISPOSAL_STATUS ,
(select min(class.class_number) from TM_ACQ_DISPOSAL status, tm_disposal_records records, tm_disposal_classes class
where status.id = records.disposal_status_id and records.miid = r.id and class.id = records.disposal_class_id) DISPOSAL_CLASS,
(select min(names.concat_search_name) from tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names
where r.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY,
(select min(c.u_id_ext1) from tmddba.tm_mi_tpi_lnx lnx, tm_ctnrs c where c.u_id = lnx.tpiid and lnx.miid = r.id) U_ID_EXT1 ,
(select t.name from TM_CFG_MI_FMT_TYP t where t.id = r.mi_fmt_type) ITEM_FORMAT_TEXT,
CASE
WHEN BITAND(r.COMPIL, 2) = 2 THEN 'SUPPLIED'
WHEN BITAND(r.COMPIL, 4) = 4 THEN 'MADE'
WHEN BITAND(r.COMPIL, 134217728) = 134217728 THEN 'IMPORTED'
ELSE ''
END AS ORIGIN,
CASE
WHEN BITAND(r.COMPIL, 512) = 512 THEN 'Attached'
WHEN BITAND(r.COMPIL, 1024) = 1024 THEN 'Un-Attached'
ELSE ''
END AS FLAGS,
(select min(lang.full_name) from TM_PG_RL_LANG_LNX lnx, TM_LANG_DATA lang
where lnx.tm_pg_rl_id = r.pgm_parent_id and lnx.lang_id = lang.id) AS PROD_LANGUAGE ,
(select min(ctx.ITFC_CODE) from tm_mis mis, tm_mi_tpi_lnx links, tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names
where mis.id = r.id and links.miid = mis.id and mis.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id
and ctx.preferred_name = names.id) AGENCY_NUMBER,
(select min(status.description) from TM_CFG_PGM_STATUS status where r.status = status.id) PGM_STATUS_TEXT,
(select min(ver.DUR) from TM_PG_RL ver where r.pgm_PARENT_ID = ver.id) AS VERSION_DUR , (select tmd_str_agg_pipe(cms.status_type_id ||',' ||cms.status_id) from tm_mi_cust_med_stat_lnx cms where cms.media_id=r.id) "CustomStatusesRaw", (select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = r.net_grp_id) CHANNEL_GROUP,
(SELECT SUBSTR( trim( replace (replace (
LISTAGG(trim(tt.tags || ' ' || tt.notes), ' ') WITHIN GROUP (ORDER BY trim(tt.tags || ' ' || tt.notes)), chr (13), ''), chr (10), ' ')), 1, 150) z
FROM tm_media_tagging tt
WHERE link_guid = DFILE_LINK_GUID and rownum=1) TAGS_TEXT ,
GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION,
nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME
from (select 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|02:53:36.7771|wkVLmR|CJPOWERCAST|Alternative title fields query: select * from (select x.id,x.pgm_abs_id TitleId, x.pgm_parent_id VersionId from tm_mis x where id in (select /*+ cardinality(4) */ column_value id from table(:ids))) y,lateral (select dbms_lob.substr( o.text_data_plain, 1000, 1 ) Field_5799344 from tm_txt_obj o
where (o.pgm_abs_id=y.TitleId or o.pgm_rl_id = y.VersionId) and o.type_id=:param_1
order by o.id desc fetch first 1 rows only)(+)
t Information: 1220 : 12|02:53:36.7771|wkVLmR|CJPOWERCAST| timing: 00:00:00.4966695
t Verbose: 1220 : 12|02:53:36.7771|wkVLmR|CJPOWERCAST|imfx v3 API took 0.497s '/api/v3/search/Media?_dc=1663293209095'
t Transfer: 1220 : 12|02:53:36.7771|wkVLmR|CJPOWERCAST|GetUrl. Storage |Video| filename I:\Video\L0640441.mp4 subfolder
t Transfer: 1220 : 12|02:53:36.7771|wkVLmR|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/L0640441.mp4
t Transfer: 1220 : 12|02:53:36.7781|wkVLmR|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/L0640441.mp4
t Transfer: 1220 : 12|02:53:36.7781|wkVLmR|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 : 12|02:53:36.7781|wkVLmR|CJPOWERCAST| OAuth authenticated
t Transfer: 1220 : 12|02:53:36.7781|wkVLmR|CJPOWERCAST| user CJPOWERCAST.
t Information: 1220 : 12|05:35:48.5106|||OrabitWatcherBasic. Disposing.
t Information: 1220 : 12|05:35:48.5106|||OrabitWatcherBasic. Disposed.
t Information: 1220 : 12|05:35:48.5116|||==========================================================================
t Information: 1220 : 12|05:35:48.5116|||IMFX CORE SERVER APPLICATION END.