t Information: 1220 : 16|08:08:01.5475|G6gYOQ||GetCaptionsForWeb. Filename: . SubFolder . Device . Format . Timecode format Pal. Media ID 0. Last Modified 1/1/0001 12:00:00 AM t Information: 1220 : 16|08:08:01.5631|G6gYOQ||GetCaptionsForWeb. Exception: System.ApplicationException: Storage device is missing: at iMfxServerCommon.WebCaptions.GetCaptionsForWeb(String& outPath) t Transfer: 1220 : 16|08:38:30.8637|mcI5JL||GetAppInfo. DB: TMDDEMO. Install mode: . Auth types: Native, PublicApiKey t Verbose: 1220 : 16|08:38:31.6762|NA_0z_||imfx v3 API took 0.135s '/api/v3/visual-asset/group/PnqJC_/2/image' t Verbose: 1220 : 16|08:38:32.8948|lkkJaB||Oauth validating.. t Verbose: 1220 : 16|08:38:32.8948|lkkJaB||GrantResourceOwnerCredentials. t Verbose: 1220 : 16|08:38:32.8948|lkkJaB||LoginUser. cjpowercast, login type OAuth, encrypt password True t Information: 1220 : 16|08:38:32.8948|lkkJaB||TryLoginUser. cjpowercast, login type OAuth, check password True, check hash False, encrypt password True, load user data False t Information: 1220 : 16|08:38:33.5041|lkkJaB|| oauth token 00000000-0000-0000-0000-000000000000 t Information: 1220 : 16|08:38:33.5041|lkkJaB||TryLoginUser. Logged in.. t Information: 1220 : 16|08:38:33.7073|lkkJaB||GetPasswordPolicy. WARNING: Policy not found for system Imediaflex. Validation disabled. t Verbose: 1220 : 16|08:38:33.7073|lkkJaB||LoginUser. Adding history. User Id 1165, result CJPOWERCAST, host 192.168.127.6 t Verbose: 1220 : 16|08:38:33.7073|lkkJaB||GrantResourceOwnerCredentials. Try login finished. Logged: True t Transfer: 1220 : 16|08:38:34.1168|p3Orra|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=1693208330370 t Transfer: 1220 : 16|08:38:34.1168|p3Orra|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:34.1168|p3Orra|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:34.1168|p3Orra|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:38:34.1168|p3Orra|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 16|08:38:34.1168|p3Orra|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:34.1168|p3Orra|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:34.1168|p3Orra|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:38:34.1168|p3Orra|CJPOWERCAST|imfx v3 API took 0.043s '/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=1693208330370' t Transfer: 1220 : 16|08:38:34.5230|ng2WV3|CJPOWERCAST|OAuth: /api/user-preferences?keys=personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch;workflow_queues_actions;workflow_queues_settings&_dc=1693208330740 t Transfer: 1220 : 16|08:38:34.5230|ng2WV3|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:34.5230|ng2WV3|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:34.5230|ng2WV3|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:38:34.5230|ng2WV3|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 16|08:38:34.5230|ng2WV3|CJPOWERCAST|GetUserDataByKeys: personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch;workflow_queues_actions;workflow_queues_settings t Transfer: 1220 : 16|08:38:34.5230|ng2WV3|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:34.5230|ng2WV3|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:34.5230|ng2WV3|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:38:34.5230|ng2WV3|CJPOWERCAST|imfx v3 API took 0.049s '/api/user-preferences?keys=personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch;workflow_queues_actions;workflow_queues_settings&_dc=1693208330740' t Information: 1220 : 16|08:38:34.7262|WG7Fcj|CJPOWERCAST|GetUserProfile. Id: 0 t Transfer: 1220 : 16|08:38:34.7262|WG7Fcj|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:34.7262|WG7Fcj|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:34.7262|WG7Fcj|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 16|08:38:35.1324|FqMdyZ|CJPOWERCAST|OAuth: /api/settings/group/0?_dc=1693208331476 t Transfer: 1220 : 16|08:38:35.1324|FqMdyZ|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:35.1324|FqMdyZ|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:35.1324|FqMdyZ|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:38:35.1324|FqMdyZ|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 16|08:38:35.1324|7i~2pn|CJPOWERCAST|OAuth: /api/settings/user/mainMenuSettings?_dc=1693208331477 t Transfer: 1220 : 16|08:38:35.1324|7i~2pn|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:35.1324|7i~2pn|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:35.1324|7i~2pn|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:38:35.1324|7i~2pn|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 16|08:38:35.3356|7i~2pn|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:35.3356|7i~2pn|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:35.3356|7i~2pn|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:38:35.3356|7i~2pn|CJPOWERCAST|imfx v3 API took 0.009s '/api/settings/user/mainMenuSettings?_dc=1693208331477' t Verbose: 1220 : 16|08:38:35.5387|FqMdyZ|CJPOWERCAST|imfx v3 API took 0.314s '/api/settings/group/0?_dc=1693208331476' t Transfer: 1220 : 16|08:38:35.5387|TILUjK|CJPOWERCAST|OAuth: /api/settings/user/uploadSettings?_dc=1693208331488 t Transfer: 1220 : 16|08:38:35.5387|TILUjK|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:35.5387|TILUjK|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:35.5387|TILUjK|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:38:35.5387|TILUjK|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 16|08:38:35.5387|TILUjK|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:35.5387|TILUjK|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:35.5387|TILUjK|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:38:35.5387|TILUjK|CJPOWERCAST|imfx v3 API took 0.007s '/api/settings/user/uploadSettings?_dc=1693208331488' t Transfer: 1220 : 16|08:38:35.7418|VvmiJc|CJPOWERCAST|OAuth: /api/settings/group/0?_dc=1693208331512 t Transfer: 1220 : 16|08:38:35.7418|VvmiJc|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:35.7418|VvmiJc|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:35.7418|VvmiJc|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:38:35.7418|VvmiJc|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 16|08:38:35.7418|IsfXVj|CJPOWERCAST|OAuth: /api/settings/user/mainMenuSettings?_dc=1693208331513 t Transfer: 1220 : 16|08:38:35.7418|IsfXVj|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:35.7418|IsfXVj|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:35.7418|IsfXVj|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:38:35.7418|IsfXVj|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 16|08:38:35.7418|IsfXVj|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:35.7418|IsfXVj|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:35.7418|IsfXVj|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:38:35.7418|IsfXVj|CJPOWERCAST|imfx v3 API took 0.003s '/api/settings/user/mainMenuSettings?_dc=1693208331513' t Transfer: 1220 : 16|08:38:35.9449|pC5pj8|CJPOWERCAST|OAuth: /api/lookups/MediaStatus?_dc=1693208331527 t Transfer: 1220 : 16|08:38:35.9449|pC5pj8|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:35.9449|pC5pj8|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:35.9449|pC5pj8|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:38:35.9449|pC5pj8|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 16|08:38:35.9449|SX713l||GetCache. t Information: 1220 : 16|08:38:35.9449|SX713l||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\201_0_Any_gO.png t Information: 1220 : 16|08:38:35.9449|SX713l||GetCache. Data read: 0 t Verbose: 1220 : 16|08:38:35.9449|SX713l||imfx v3 API took 0.012s '/api/v3/visual-asset/group/Any_gO/0/image' t Verbose: 1220 : 16|08:38:35.9449|VvmiJc|CJPOWERCAST|imfx v3 API took 0.091s '/api/settings/group/0?_dc=1693208331512' t Transfer: 1220 : 16|08:38:35.9449|aksG2D|CJPOWERCAST|OAuth: /api/lookups/PgmStatus?_dc=1693208331527 t Transfer: 1220 : 16|08:38:35.9449|aksG2D|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:35.9449|aksG2D|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:35.9449|aksG2D|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:38:35.9449|aksG2D|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 16|08:38:35.9449|pC5pj8|CJPOWERCAST|imfx v3 API took 0.030s '/api/lookups/MediaStatus?_dc=1693208331527' t Verbose: 1220 : 16|08:38:35.9449|aksG2D|CJPOWERCAST|imfx v3 API took 0.031s '/api/lookups/PgmStatus?_dc=1693208331527' t Transfer: 1220 : 16|08:38:36.1490|i1Yokh|CJPOWERCAST|OAuth: /api/lookup/CustomMediaStatusTypes?_dc=1693208331528 t Transfer: 1220 : 16|08:38:36.1490|i1Yokh|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:36.1490|i1Yokh|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:36.1490|i1Yokh|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:38:36.1490|i1Yokh|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 16|08:38:36.1490|yYYjL6|CJPOWERCAST|OAuth: /api/lookup/CustomVersionStatusTypes?_dc=1693208331529 t Transfer: 1220 : 16|08:38:36.1490|yYYjL6|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:36.1490|yYYjL6|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:36.1490|yYYjL6|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:38:36.1490|yYYjL6|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 16|08:38:36.1490|yYYjL6|CJPOWERCAST|imfx v3 API took 0.015s '/api/lookup/CustomVersionStatusTypes?_dc=1693208331529' t Verbose: 1220 : 16|08:38:36.1490|i1Yokh|CJPOWERCAST|imfx v3 API took 0.069s '/api/lookup/CustomMediaStatusTypes?_dc=1693208331528' t Transfer: 1220 : 16|08:38:36.3521|ubDHaI|CJPOWERCAST|OAuth: /api/lookup/CustomTitleStatusTypes?_dc=1693208331530 t Transfer: 1220 : 16|08:38:36.3521|ubDHaI|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:36.3521|ubDHaI|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:36.3521|ubDHaI|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:38:36.3521|ubDHaI|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 16|08:38:36.3521|fSEafX|CJPOWERCAST|OAuth: /api/settings/user/defaultHomePage?_dc=1693208331533 t Transfer: 1220 : 16|08:38:36.3521|fSEafX|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:36.3521|fSEafX|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:36.3521|fSEafX|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:38:36.3521|fSEafX|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 16|08:38:36.3521|fSEafX|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:36.3521|fSEafX|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:36.3521|fSEafX|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:38:36.3521|ubDHaI|CJPOWERCAST|imfx v3 API took 0.014s '/api/lookup/CustomTitleStatusTypes?_dc=1693208331530' t Verbose: 1220 : 16|08:38:36.3521|fSEafX|CJPOWERCAST|imfx v3 API took 0.014s '/api/settings/user/defaultHomePage?_dc=1693208331533' t Information: 1220 : 16|08:38:36.3521|FfBd7Z||GetCache. t Information: 1220 : 16|08:38:36.3521|FfBd7Z||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\202_1_Any_gO.png t Information: 1220 : 16|08:38:36.3521|FfBd7Z||GetCache. Data read: 0 t Verbose: 1220 : 16|08:38:36.3521|FfBd7Z||imfx v3 API took 0.004s '/api/v3/visual-asset/group/Any_gO/1/image' t Transfer: 1220 : 16|08:38:38.1963|l1pToU|CJPOWERCAST|OAuth: /api/settings/user/startSearch?_dc=1693208334389 t Transfer: 1220 : 16|08:38:38.1963|l1pToU|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:38.1963|l1pToU|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:38.1963|l1pToU|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:38:38.1963|l1pToU|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 16|08:38:38.1963|l1pToU|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:38.1963|l1pToU|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:38.1963|l1pToU|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 16|08:38:38.1963|BemR4X|CJPOWERCAST|OAuth: /api/settings/user/defaultSearch?_dc=1693208334388 t Transfer: 1220 : 16|08:38:38.1963|BemR4X|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:38.1963|BemR4X|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:38.1963|BemR4X|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:38:38.1963|BemR4X|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 16|08:38:38.1963|BemR4X|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:38.1963|BemR4X|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:38.1963|BemR4X|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:38:38.1963|l1pToU|CJPOWERCAST|imfx v3 API took 0.009s '/api/settings/user/startSearch?_dc=1693208334389' t Verbose: 1220 : 16|08:38:38.1963|BemR4X|CJPOWERCAST|imfx v3 API took 0.012s '/api/settings/user/defaultSearch?_dc=1693208334388' t Transfer: 1220 : 16|08:38:38.3994|D5rzw8|CJPOWERCAST|OAuth: /api/user-preferences?keys=consumer.recent.data&_dc=1693208334716 t Transfer: 1220 : 16|08:38:38.3994|D5rzw8|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:38.3994|D5rzw8|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:38.3994|D5rzw8|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:38:38.3994|D5rzw8|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 16|08:38:38.3994|D5rzw8|CJPOWERCAST|GetUserDataByKeys: consumer.recent.data t Transfer: 1220 : 16|08:38:38.3994|D5rzw8|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:38.3994|D5rzw8|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:38.3994|D5rzw8|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 16|08:38:38.3994|vKAabb||GetCache. t Information: 1220 : 16|08:38:38.3994|vKAabb||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\204_3_Any_gO.png t Information: 1220 : 16|08:38:38.3994|vKAabb||GetCache. Data read: 5504 t Verbose: 1220 : 16|08:38:38.3994|vKAabb||imfx v3 API took 0.005s '/api/v3/visual-asset/group/Any_gO/3/image' t Transfer: 1220 : 16|08:38:38.3994|z7N0_5|CJPOWERCAST|OAuth: /api/user-preferences?keys=adv.recent.searches.consumer&_dc=1693208334726 t Transfer: 1220 : 16|08:38:38.3994|z7N0_5|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:38.3994|z7N0_5|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:38.3994|z7N0_5|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:38:38.3994|z7N0_5|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 16|08:38:38.3994|z7N0_5|CJPOWERCAST|GetUserDataByKeys: adv.recent.searches.consumer t Transfer: 1220 : 16|08:38:38.3994|z7N0_5|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:38.3994|z7N0_5|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:38.3994|z7N0_5|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:38:38.3994|D5rzw8|CJPOWERCAST|imfx v3 API took 0.009s '/api/user-preferences?keys=consumer.recent.data&_dc=1693208334716' t Verbose: 1220 : 16|08:38:38.3994|z7N0_5|CJPOWERCAST|imfx v3 API took 0.008s '/api/user-preferences?keys=adv.recent.searches.consumer&_dc=1693208334726' t Transfer: 1220 : 16|08:38:42.9023|WENhO_|CJPOWERCAST|OAuth: /api/user-preferences?keys=adv.recent.searches.titles&_dc=1693208339139 t Transfer: 1220 : 16|08:38:42.9023|WENhO_|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:42.9023|WENhO_|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:42.9023|WENhO_|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:38:42.9023|WENhO_|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 16|08:38:42.9023|gGj3jn|CJPOWERCAST|OAuth: /api/lookups/SearchSupportedOperators?_dc=1693208339137 t Transfer: 1220 : 16|08:38:42.9023|gGj3jn|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:42.9023|gGj3jn|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:42.9023|gGj3jn|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:38:42.9023|gGj3jn|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 16|08:38:42.9023|gGj3jn|CJPOWERCAST|imfx v3 API took 0.000s '/api/lookups/SearchSupportedOperators?_dc=1693208339137' t Information: 1220 : 16|08:38:42.9023|WENhO_|CJPOWERCAST|GetUserDataByKeys: adv.recent.searches.titles t Transfer: 1220 : 16|08:38:42.9023|WENhO_|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:42.9023|WENhO_|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:42.9023|WENhO_|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 16|08:38:42.9023|PARDVg|CJPOWERCAST|OAuth: /api/view/searchinfo/TitleSearch?_dc=1693208339135 t Transfer: 1220 : 16|08:38:42.9023|PARDVg|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:42.9023|PARDVg|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:42.9023|PARDVg|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:38:42.9023|PARDVg|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 16|08:38:42.9023|PARDVg|CJPOWERCAST|GetAdvSearchColumns. search type TitleSearch grid . t Verbose: 1220 : 16|08:38:42.9023|PARDVg|CJPOWERCAST|imfx v3 API took 0.001s '/api/view/searchinfo/TitleSearch?_dc=1693208339135' t Verbose: 1220 : 16|08:38:42.9023|WENhO_|CJPOWERCAST|imfx v3 API took 0.010s '/api/user-preferences?keys=adv.recent.searches.titles&_dc=1693208339139' t Transfer: 1220 : 16|08:38:42.9023|6B5hvl|CJPOWERCAST|OAuth: /api/view/searches/TitleSearch?_dc=1693208339201 t Transfer: 1220 : 16|08:38:42.9023|6B5hvl|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:42.9023|6B5hvl|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:42.9023|6B5hvl|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:38:42.9023|6B5hvl|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 16|08:38:42.9023|6B5hvl|CJPOWERCAST|GetSavedSearchNames. search type TitleSearch. t Transfer: 1220 : 16|08:38:42.9023|6B5hvl|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:42.9023|6B5hvl|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:42.9023|6B5hvl|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:38:42.9023|6B5hvl|CJPOWERCAST|imfx v3 API took 0.039s '/api/view/searches/TitleSearch?_dc=1693208339201' t Transfer: 1220 : 16|08:38:43.1210|6E7YhW|CJPOWERCAST|OAuth: /api/view/info/VersionGrid?lang=en-GB&_dc=1693208339224 t Transfer: 1220 : 16|08:38:43.1210|6E7YhW|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:43.1210|6E7YhW|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:43.1210|6E7YhW|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:38:43.1210|6E7YhW|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 16|08:38:43.1210|6E7YhW|CJPOWERCAST|GetGridViewBuilder. builder type VersionGrid. t Transfer: 1220 : 16|08:38:43.1210|6E7YhW|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:43.1210|6E7YhW|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:43.1210|6E7YhW|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 16|08:38:43.1210|6E7YhW|CJPOWERCAST|UserGridView. LoadView. ID -2, Name Default. t Transfer: 1220 : 16|08:38:43.1210|6E7YhW|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:43.1210|6E7YhW|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:43.1210|6E7YhW|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 16|08:38:43.1210|6E7YhW|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:43.1210|6E7YhW|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:43.1210|6E7YhW|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:38:43.3242|6E7YhW|CJPOWERCAST|imfx v3 API took 0.060s '/api/view/info/VersionGrid?lang=en-GB&_dc=1693208339224' t Transfer: 1220 : 16|08:38:43.5273|LAEE4N|CJPOWERCAST|OAuth: /api/view/info/MediaGrid?lang=en-GB&_dc=1693208339313 t Transfer: 1220 : 16|08:38:43.5273|LAEE4N|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:43.5273|LAEE4N|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:43.5273|LAEE4N|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:38:43.5273|LAEE4N|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 16|08:38:43.5273|LAEE4N|CJPOWERCAST|GetGridViewBuilder. builder type MediaGrid. t Transfer: 1220 : 16|08:38:43.5273|LAEE4N|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:43.5273|LAEE4N|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:43.5273|LAEE4N|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 16|08:38:43.5273|LAEE4N|CJPOWERCAST|UserGridView. LoadView. ID -2, Name Default. t Transfer: 1220 : 16|08:38:43.5273|LAEE4N|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:43.5273|LAEE4N|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:43.5273|LAEE4N|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 16|08:38:43.5273|LAEE4N|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:43.5273|LAEE4N|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:43.5273|LAEE4N|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:38:43.5273|LAEE4N|CJPOWERCAST|imfx v3 API took 0.008s '/api/view/info/MediaGrid?lang=en-GB&_dc=1693208339313' t Transfer: 1220 : 16|08:38:43.5273|EHknLJ|CJPOWERCAST|OAuth: /api/view/info/DigitalCarriers?lang=en-GB&_dc=1693208339361 t Transfer: 1220 : 16|08:38:43.5273|EHknLJ|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:43.5273|EHknLJ|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:43.5273|EHknLJ|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:38:43.5273|EHknLJ|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 16|08:38:43.5273|EHknLJ|CJPOWERCAST|GetGridViewBuilder. builder type DigitalCarriers. t Transfer: 1220 : 16|08:38:43.5273|EHknLJ|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:43.5273|EHknLJ|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:43.5273|EHknLJ|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 16|08:38:43.5273|EHknLJ|CJPOWERCAST|UserGridView. LoadView. ID -2, Name Default. t Transfer: 1220 : 16|08:38:43.5273|EHknLJ|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:43.5273|EHknLJ|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:43.5273|EHknLJ|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 16|08:38:43.5273|EHknLJ|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:43.5273|EHknLJ|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:43.5273|EHknLJ|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:38:43.5273|EHknLJ|CJPOWERCAST|imfx v3 API took 0.007s '/api/view/info/DigitalCarriers?lang=en-GB&_dc=1693208339361' t Transfer: 1220 : 16|08:38:43.5273|MTadap|CJPOWERCAST|OAuth: /api/view/info/TitleTree?lang=en-GB&_dc=1693208339408 t Transfer: 1220 : 16|08:38:43.5273|MTadap|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:43.5273|MTadap|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:43.5273|MTadap|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:38:43.5273|MTadap|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 16|08:38:43.5273|MTadap|CJPOWERCAST|GetGridViewBuilder. builder type TitleTree. t Transfer: 1220 : 16|08:38:43.5273|MTadap|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:43.5273|MTadap|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:43.5273|MTadap|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 16|08:38:43.5273|MTadap|CJPOWERCAST|UserGridView. LoadView. ID -2, Name Default. t Transfer: 1220 : 16|08:38:43.5273|MTadap|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:43.5273|MTadap|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:43.5273|MTadap|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 16|08:38:43.5273|MTadap|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:43.5273|MTadap|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:43.5273|MTadap|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:38:43.5273|MTadap|CJPOWERCAST|imfx v3 API took 0.006s '/api/view/info/TitleTree?lang=en-GB&_dc=1693208339408' t Transfer: 1220 : 16|08:38:48.6640|t4x6dv|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1693208344921 t Transfer: 1220 : 16|08:38:48.6640|t4x6dv|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:48.6640|t4x6dv|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:48.6640|t4x6dv|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:38:48.6640|t4x6dv|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 16|08:38:48.6640|t4x6dv|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:48.6640|t4x6dv|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:48.6640|t4x6dv|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:38:49.8958|t4x6dv|CJPOWERCAST|imfx v3 API took 1.111s '/api/v3/search-suggestion/?_dc=1693208344921' t Transfer: 1220 : 16|08:38:51.1160|roJcbA|CJPOWERCAST|OAuth: /api/v3/search/title?_dc=1693208347371 t Transfer: 1220 : 16|08:38:51.1160|roJcbA|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:51.1160|roJcbA|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:51.1160|roJcbA|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:38:51.1160|roJcbA|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 16|08:38:51.1160|roJcbA|CJPOWERCAST|V3Api.SearchTitles t Information: 1220 : 16|08:38:51.1160|roJcbA|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 16|08:38:51.1160|roJcbA|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:51.1160|roJcbA|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:51.1160|roJcbA|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 16|08:38:51.1160|roJcbA|CJPOWERCAST|SearchTitle SQL: with v as ( SELECT abs.* ,(select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = abs.net_grp_id) CHANNEL_GROUP ,decode(ITEM_TYPE, 1010,SER_ABS_ID, 1020,CASE WHEN SER_ABS2_ID > 0 THEN SER_ABS2_ID ELSE SER_ABS_ID END ) xparent_id FROM TMDDBA.TM_PG_ABS abs WHERE abs.id in ( select a.id FROM TMDDBA.TM_PG_ABS a where ABS_DELETED = 0 AND (INSTR(OWNERS,'|SFP2|')>0 OR INSTR(OWNERS,'|PSP|')>0 OR INSTR(OWNERS,'|PMS|')>0 OR INSTR(OWNERS,'|SFP1|')>0 OR INSTR(OWNERS,'|PMH|')>0 OR INSTR(OWNERS,'|PPL|')>0 ) AND a.ser_abs_id=:param_0 AND ROWNUM < 25000 ) ) ,v_missing_parent_ids as ( select xparent_id from v minus select id from v ) ,v_missing_parents as ( SELECT distinct a.* ,(select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = a.net_grp_id) CHANNEL_GROUP ,decode(ITEM_TYPE, 1010,SER_ABS_ID, 1020,CASE WHEN SER_ABS2_ID > 0 THEN SER_ABS2_ID ELSE SER_ABS_ID END ) xparent_id FROM TMDDBA.TM_PG_ABS a START WITH ID IN (select xparent_id from v_missing_parent_ids) CONNECT BY CASE PRIOR ITEM_TYPE WHEN 1010 THEN PRIOR SER_ABS_ID WHEN 1020 THEN CASE WHEN NVL(PRIOR SER_ABS2_ID, 0) > 0 THEN PRIOR SER_ABS2_ID ELSE PRIOR SER_ABS_ID END END = ID ) ,v_all as ( select x.*, count(*) over() RowCount from ( select * from v_missing_parents union select * from v ) x ) ,v_top as ( select id from (select id, row_number()over(order by upper(ser_title),upper(title),ser_num,ser_ep_num, SER_EP_SQ_NUM ) rnk -- sort roots from v_all where xparent_id is null) where rnk between (:page_number-1)*50+1 and :page_number*50 ) ,v_tree as ( select level "TreeLevel", a.*from v_all a start with id in (select id from v_top) connect by xparent_id = prior ID order siblings by upper(ser_title),ser_num,ser_ep_num, SER_EP_SQ_NUM,upper(title) -- sort children ) select * from v_tree --where rnk <= 50 t Verbose: 1220 : 16|08:38:51.5222|roJcbA|CJPOWERCAST|Alternative title fields query: select * from (select x.id,x.id TitleId from TM_PG_ABS 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) and o.type_id=:param_1 order by o.id desc fetch first 1 rows only)(+) t Verbose: 1220 : 16|08:38:51.5222|roJcbA|CJPOWERCAST|imfx v3 API took 0.362s '/api/v3/search/title?_dc=1693208347371' t Transfer: 1220 : 16|08:38:51.9285|T9_EiZ|CJPOWERCAST|OAuth: /api/v3/title/299390/versions?_dc=1693208348223 t Transfer: 1220 : 16|08:38:51.9285|T9_EiZ|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:51.9285|T9_EiZ|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:51.9285|T9_EiZ|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:38:51.9285|T9_EiZ|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 16|08:38:51.9285|T9_EiZ|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 16|08:38:51.9285|_B53zD|CJPOWERCAST|OAuth: /api/user-preferences?_dc=1693208348228 t Transfer: 1220 : 16|08:38:51.9285|_B53zD|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:51.9285|_B53zD|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:51.9285|_B53zD|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:38:51.9285|_B53zD|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 16|08:38:51.9285|_B53zD|CJPOWERCAST|StoreUserDataByKeys.. t Transfer: 1220 : 16|08:38:51.9285|_B53zD|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:51.9285|_B53zD|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:51.9285|_B53zD|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 16|08:38:51.9285|T9_EiZ|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:51.9285|T9_EiZ|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:51.9285|T9_EiZ|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 16|08:38:51.9285|T9_EiZ|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:51.9285|T9_EiZ|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:51.9285|T9_EiZ|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:38:51.9285|_B53zD|CJPOWERCAST|imfx v3 API took 0.019s '/api/user-preferences?_dc=1693208348228' t Transfer: 1220 : 16|08:38:51.9285|T9_EiZ|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:51.9285|T9_EiZ|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:51.9285|T9_EiZ|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 16|08:38:51.9285|T9_EiZ|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 med.medium_name from TM_CFG_MEDIUM med, TM_PG_ABS pgabs where pgabs.id=v.PGM_ABS_ID and pgabs.MEDIUM_ID = med.id) MEDIUM_TEXT ,(select replace(tmd_str_agg_pipe(cf.form_name),'|',' / ') from TM_PG_FORM_LNX fl join TM_CFG_FORM cf on (cf.id=fl.form_id) where fl.tm_pg_id = v.ID) FORM_TEXT ,(select replace(tmd_str_agg_pipe(dvb.item_name),'|',' / ') from TM_PG_ABS_GENRE_LNX gl join TM_DVB dvb on (dvb.id=gl.genre_id) where gl.tm_pg_abs_id = v.PGM_ABS_ID) GENRE_TEXT, (select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = v.net_grp_id) CHANNEL_GROUP, (select count(id) from tm_mis where item_type>0 and pgm_parent_id=v.id) MEDIA_COUNT, (select cvt.ID from TM_PORTAL_VERSION_CONFIG cvt where v.CUSTOM_VERSION_TYPE = cvt.CUSTOM_VERSION_TYPE AND cvt.CUSTOM_VERSION_TYPE IS NOT NULL ) MP_CONFIG_ID from (select v.*, coalesce(v.primary_thumb_id, (select x.primary_thumb_id from tm_pg_rl x where x.id=v.parent_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.pgm_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs2_id) ) primary_thumb_id2 from tmddba.tm_pg_rl v where v.item_type > 0 and v.rl_deleted = 0) v left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = v.primary_thumb_id2 --sqlIdSearchJoin where 1=1 AND (INSTR(v.OWNERS,'|SFP2|')>0 OR INSTR(v.OWNERS,'|PSP|')>0 OR INSTR(v.OWNERS,'|PMS|')>0 OR INSTR(v.OWNERS,'|SFP1|')>0 OR INSTR(v.OWNERS,'|PMH|')>0 OR INSTR(v.OWNERS,'|PPL|')>0) and v.id in (select x.id from tmddba.tm_pg_rl x start with x.id in ( select a.id from (select m.id, rownum rnum from tmddba.tm_pg_rl m where item_type>0 and rl_deleted=0 and m.PGM_ABS_ID=:param_0 AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0) ) A WHERE rnum>=1 and rnum <= 9999 ) connect by nocycle prior x.parent_id=x.id) t Transfer: 1220 : 16|08:38:51.9285|T9_EiZ|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:51.9285|T9_EiZ|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:51.9285|T9_EiZ|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 16|08:38:52.1472|T9_EiZ|CJPOWERCAST|Running version search. User: 1165 Simple Search: Running Oracle search. Running Oracle search for COUNT Oracle count completed in: 33ms. Returned lines: 0 t Verbose: 1220 : 16|08:38:52.1472|T9_EiZ|CJPOWERCAST|imfx v3 API took 0.067s '/api/v3/title/299390/versions?_dc=1693208348223' t Transfer: 1220 : 16|08:38:53.1630|xKrmMT|CJPOWERCAST|OAuth: /api/v3/title/299542/versions?_dc=1693208349493 t Transfer: 1220 : 16|08:38:53.1630|xKrmMT|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:53.1630|xKrmMT|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:53.1630|xKrmMT|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:38:53.1630|xKrmMT|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 16|08:38:53.1630|xKrmMT|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 16|08:38:53.1630|xKrmMT|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:53.1630|xKrmMT|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:53.1630|xKrmMT|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 16|08:38:53.1630|xKrmMT|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:53.1630|xKrmMT|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:53.1630|xKrmMT|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 16|08:38:53.1630|xKrmMT|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:53.1630|xKrmMT|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:53.1630|xKrmMT|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 16|08:38:53.1630|xKrmMT|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 med.medium_name from TM_CFG_MEDIUM med, TM_PG_ABS pgabs where pgabs.id=v.PGM_ABS_ID and pgabs.MEDIUM_ID = med.id) MEDIUM_TEXT ,(select replace(tmd_str_agg_pipe(cf.form_name),'|',' / ') from TM_PG_FORM_LNX fl join TM_CFG_FORM cf on (cf.id=fl.form_id) where fl.tm_pg_id = v.ID) FORM_TEXT ,(select replace(tmd_str_agg_pipe(dvb.item_name),'|',' / ') from TM_PG_ABS_GENRE_LNX gl join TM_DVB dvb on (dvb.id=gl.genre_id) where gl.tm_pg_abs_id = v.PGM_ABS_ID) GENRE_TEXT, (select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = v.net_grp_id) CHANNEL_GROUP, (select count(id) from tm_mis where item_type>0 and pgm_parent_id=v.id) MEDIA_COUNT, (select cvt.ID from TM_PORTAL_VERSION_CONFIG cvt where v.CUSTOM_VERSION_TYPE = cvt.CUSTOM_VERSION_TYPE AND cvt.CUSTOM_VERSION_TYPE IS NOT NULL ) MP_CONFIG_ID from (select v.*, coalesce(v.primary_thumb_id, (select x.primary_thumb_id from tm_pg_rl x where x.id=v.parent_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.pgm_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs2_id) ) primary_thumb_id2 from tmddba.tm_pg_rl v where v.item_type > 0 and v.rl_deleted = 0) v left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = v.primary_thumb_id2 --sqlIdSearchJoin where 1=1 AND (INSTR(v.OWNERS,'|SFP2|')>0 OR INSTR(v.OWNERS,'|PSP|')>0 OR INSTR(v.OWNERS,'|PMS|')>0 OR INSTR(v.OWNERS,'|SFP1|')>0 OR INSTR(v.OWNERS,'|PMH|')>0 OR INSTR(v.OWNERS,'|PPL|')>0) and v.id in (select x.id from tmddba.tm_pg_rl x start with x.id in ( select a.id from (select m.id, rownum rnum from tmddba.tm_pg_rl m where item_type>0 and rl_deleted=0 and m.PGM_ABS_ID=:param_0 AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0) ) A WHERE rnum>=1 and rnum <= 9999 ) connect by nocycle prior x.parent_id=x.id) t Transfer: 1220 : 16|08:38:53.1630|xKrmMT|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:53.1630|xKrmMT|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:53.1630|xKrmMT|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 16|08:38:54.1800|xKrmMT|CJPOWERCAST|Running version search. User: 1165 Simple Search: Running Oracle search. Running Oracle search for COUNT Oracle count completed in: 5ms. Returned lines: 1 Oracle version search timing: 1019ms. 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 med.medium_name from TM_CFG_MEDIUM med, TM_PG_ABS pgabs where pgabs.id=v.PGM_ABS_ID and pgabs.MEDIUM_ID = med.id) MEDIUM_TEXT ,(select replace(tmd_str_agg_pipe(cf.form_name),'|',' / ') from TM_PG_FORM_LNX fl join TM_CFG_FORM cf on (cf.id=fl.form_id) where fl.tm_pg_id = v.ID) FORM_TEXT ,(select replace(tmd_str_agg_pipe(dvb.item_name),'|',' / ') from TM_PG_ABS_GENRE_LNX gl join TM_DVB dvb on (dvb.id=gl.genre_id) where gl.tm_pg_abs_id = v.PGM_ABS_ID) GENRE_TEXT, (select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = v.net_grp_id) CHANNEL_GROUP, (select count(id) from tm_mis where item_type>0 and pgm_parent_id=v.id) MEDIA_COUNT, (select cvt.ID from TM_PORTAL_VERSION_CONFIG cvt where v.CUSTOM_VERSION_TYPE = cvt.CUSTOM_VERSION_TYPE AND cvt.CUSTOM_VERSION_TYPE IS NOT NULL ) MP_CONFIG_ID from (select v.*, coalesce(v.primary_thumb_id, (select x.primary_thumb_id from tm_pg_rl x where x.id=v.parent_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.pgm_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs2_id) ) primary_thumb_id2 from tmddba.tm_pg_rl v where v.item_type > 0 and v.rl_deleted = 0) v left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = v.primary_thumb_id2 --sqlIdSearchJoin where 1=1 AND (INSTR(v.OWNERS,'|SFP2|')>0 OR INSTR(v.OWNERS,'|PSP|')>0 OR INSTR(v.OWNERS,'|PMS|')>0 OR INSTR(v.OWNERS,'|SFP1|')>0 OR INSTR(v.OWNERS,'|PMH|')>0 OR INSTR(v.OWNERS,'|PPL|')>0) and v.id in (select x.id from tmddba.tm_pg_rl x start with x.id in ( select a.id from (select m.id, rownum rnum from tmddba.tm_pg_rl m where item_type>0 and rl_deleted=0 and m.PGM_ABS_ID=:param_0 AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0) ) A WHERE rnum>=1 and rnum <= 9999 ) connect by nocycle prior x.parent_id=x.id) t Verbose: 1220 : 16|08:38:54.1800|xKrmMT|CJPOWERCAST|Alternative title fields query: select * from (select x.id,x.pgm_abs_id TitleId, x.id VersionId from TM_PG_RL x where id in (select /*+ cardinality(4) */ column_value id from table(:ids))) y,lateral (select dbms_lob.substr( o.text_data_plain, 1000, 1 ) Field_5799344 from tm_txt_obj o where (o.pgm_abs_id=y.TitleId or o.pgm_rl_id = y.VersionId) and o.type_id=:param_1 order by o.id desc fetch first 1 rows only)(+) t Verbose: 1220 : 16|08:38:54.3987|xKrmMT|CJPOWERCAST|imfx v3 API took 1.060s '/api/v3/title/299542/versions?_dc=1693208349493' t Transfer: 1220 : 16|08:38:54.8050|AUdIec|CJPOWERCAST|OAuth: /api/v3/version/299543/media?_dc=1693208351031 t Transfer: 1220 : 16|08:38:54.8050|AUdIec|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:54.8050|AUdIec|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:54.8050|AUdIec|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:38:54.8050|AUdIec|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 16|08:38:54.8050|AUdIec|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 16|08:38:54.8050|_EXKNH|CJPOWERCAST|OAuth: /api/v3/version/299543/media?_dc=1693208351052 t Transfer: 1220 : 16|08:38:54.8050|_EXKNH|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:54.8050|_EXKNH|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:54.8050|_EXKNH|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:38:54.8050|_EXKNH|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 16|08:38:54.8050|_EXKNH|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 16|08:38:54.8050|AUdIec|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:54.8050|AUdIec|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:54.8050|AUdIec|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 16|08:38:54.8050|_EXKNH|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:54.8050|_EXKNH|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:54.8050|_EXKNH|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 16|08:38:54.8050|_EXKNH|CJPOWERCAST|MediaSearch SQL: --sqlFromPaging select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type in (1,110)),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , (SELECT min(status.ACCESS_STATUS_NAME) FROM TMDDBA.TM_ACCESS_STATUS statusLnx, TM_CFG_ACCESS_STATUS status WHERE statusLnx.Media_Id = r.id and statusLnx.Status_Id = status.id) ACCESS_STATUS , (select min(acq.ext_ref) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) CONSIGNMENT_NUMBER , (select min(acq.alt_id1) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) TRANSFER_NUMBER , (select min(crs.series_number) from tm_series_data crs where crs.id = r.GROUP_SERIES_ID) CRS_SERIES , (select min(DISPOSAL_NAME) from TM_ACQ_DISPOSAL status, tm_disposal_records records where status.id = records.disposal_status_id and records.miid = r.id) DISPOSAL_STATUS , (select min(class.class_number) from TM_ACQ_DISPOSAL status, tm_disposal_records records, tm_disposal_classes class where status.id = records.disposal_status_id and records.miid = r.id and class.id = records.disposal_class_id) DISPOSAL_CLASS, (select min(names.concat_search_name) from tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names where r.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY, (select min(c.u_id_ext1) from tmddba.tm_mi_tpi_lnx lnx, tm_ctnrs c where c.u_id = lnx.tpiid and lnx.miid = r.id) U_ID_EXT1 , (select t.name from TM_CFG_MI_FMT_TYP t where t.id = r.mi_fmt_type) ITEM_FORMAT_TEXT, CASE WHEN BITAND(r.COMPIL, 2) = 2 THEN 'SUPPLIED' WHEN BITAND(r.COMPIL, 4) = 4 THEN 'MADE' WHEN BITAND(r.COMPIL, 134217728) = 134217728 THEN 'IMPORTED' ELSE '' END AS ORIGIN, CASE WHEN BITAND(r.COMPIL, 512) = 512 THEN 'Attached' WHEN BITAND(r.COMPIL, 1024) = 1024 THEN 'Un-Attached' ELSE '' END AS FLAGS, (select min(lang.full_name) from TM_PG_RL_LANG_LNX lnx, TM_LANG_DATA lang where lnx.tm_pg_rl_id = r.pgm_parent_id and lnx.lang_id = lang.id) AS PROD_LANGUAGE , (select min(ctx.ITFC_CODE) from tm_mis mis, tm_mi_tpi_lnx links, tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names where mis.id = r.id and links.miid = mis.id and mis.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY_NUMBER, (select min(status.description) from TM_CFG_PGM_STATUS status where r.status = status.id) PGM_STATUS_TEXT, (select min(ver.DUR) from TM_PG_RL ver where r.pgm_PARENT_ID = ver.id) AS VERSION_DUR , (select tmd_str_agg_pipe(cms.status_type_id ||',' ||cms.status_id) from tm_mi_cust_med_stat_lnx cms where cms.media_id=r.id) "CustomStatusesRaw", (select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = r.net_grp_id) CHANNEL_GROUP, (SELECT SUBSTR( trim( replace (replace ( LISTAGG(trim(tt.tags || ' ' || tt.notes), ' ') WITHIN GROUP (ORDER BY trim(tt.tags || ' ' || tt.notes)), chr (13), ''), chr (10), ' ')), 1, 150) z FROM tm_media_tagging tt WHERE link_guid = DFILE_LINK_GUID and rownum=1) TAGS_TEXT , GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select t.*, coalesce(t.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=t.pgm_parent_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.pgm_abs_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs2_id) ) primary_thumb_id2 from ( --sqlSubSelect select s.* from (select a.*, rownum rnum from (select --sqlFrom m.* from tmddba.tm_mis m --sqlWhere where media_type>0 and item_type>0 AND PGM_PARENT_ID=:param_0 and m.mi_deleted=0 AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0) order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) s where rnum >= 1) t ) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl order by r.rnum t Information: 1220 : 16|08:38:54.8050|AUdIec|CJPOWERCAST|MediaSearch SQL: --sqlFromPaging select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type in (1,110)),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , (SELECT min(status.ACCESS_STATUS_NAME) FROM TMDDBA.TM_ACCESS_STATUS statusLnx, TM_CFG_ACCESS_STATUS status WHERE statusLnx.Media_Id = r.id and statusLnx.Status_Id = status.id) ACCESS_STATUS , (select min(acq.ext_ref) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) CONSIGNMENT_NUMBER , (select min(acq.alt_id1) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) TRANSFER_NUMBER , (select min(crs.series_number) from tm_series_data crs where crs.id = r.GROUP_SERIES_ID) CRS_SERIES , (select min(DISPOSAL_NAME) from TM_ACQ_DISPOSAL status, tm_disposal_records records where status.id = records.disposal_status_id and records.miid = r.id) DISPOSAL_STATUS , (select min(class.class_number) from TM_ACQ_DISPOSAL status, tm_disposal_records records, tm_disposal_classes class where status.id = records.disposal_status_id and records.miid = r.id and class.id = records.disposal_class_id) DISPOSAL_CLASS, (select min(names.concat_search_name) from tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names where r.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY, (select min(c.u_id_ext1) from tmddba.tm_mi_tpi_lnx lnx, tm_ctnrs c where c.u_id = lnx.tpiid and lnx.miid = r.id) U_ID_EXT1 , (select t.name from TM_CFG_MI_FMT_TYP t where t.id = r.mi_fmt_type) ITEM_FORMAT_TEXT, CASE WHEN BITAND(r.COMPIL, 2) = 2 THEN 'SUPPLIED' WHEN BITAND(r.COMPIL, 4) = 4 THEN 'MADE' WHEN BITAND(r.COMPIL, 134217728) = 134217728 THEN 'IMPORTED' ELSE '' END AS ORIGIN, CASE WHEN BITAND(r.COMPIL, 512) = 512 THEN 'Attached' WHEN BITAND(r.COMPIL, 1024) = 1024 THEN 'Un-Attached' ELSE '' END AS FLAGS, (select min(lang.full_name) from TM_PG_RL_LANG_LNX lnx, TM_LANG_DATA lang where lnx.tm_pg_rl_id = r.pgm_parent_id and lnx.lang_id = lang.id) AS PROD_LANGUAGE , (select min(ctx.ITFC_CODE) from tm_mis mis, tm_mi_tpi_lnx links, tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names where mis.id = r.id and links.miid = mis.id and mis.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY_NUMBER, (select min(status.description) from TM_CFG_PGM_STATUS status where r.status = status.id) PGM_STATUS_TEXT, (select min(ver.DUR) from TM_PG_RL ver where r.pgm_PARENT_ID = ver.id) AS VERSION_DUR , (select tmd_str_agg_pipe(cms.status_type_id ||',' ||cms.status_id) from tm_mi_cust_med_stat_lnx cms where cms.media_id=r.id) "CustomStatusesRaw", (select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = r.net_grp_id) CHANNEL_GROUP, (SELECT SUBSTR( trim( replace (replace ( LISTAGG(trim(tt.tags || ' ' || tt.notes), ' ') WITHIN GROUP (ORDER BY trim(tt.tags || ' ' || tt.notes)), chr (13), ''), chr (10), ' ')), 1, 150) z FROM tm_media_tagging tt WHERE link_guid = DFILE_LINK_GUID and rownum=1) TAGS_TEXT , GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select t.*, coalesce(t.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=t.pgm_parent_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.pgm_abs_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs2_id) ) primary_thumb_id2 from ( --sqlSubSelect select s.* from (select a.*, rownum rnum from (select --sqlFrom m.* from tmddba.tm_mis m --sqlWhere where media_type>0 and item_type>0 AND PGM_PARENT_ID=:param_0 and m.mi_deleted=0 AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0) order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) s where rnum >= 1) t ) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl order by r.rnum t Verbose: 1220 : 16|08:38:55.8206|_EXKNH|CJPOWERCAST|Alternative title fields query: select * from (select x.id,x.pgm_abs_id TitleId, x.pgm_parent_id VersionId from tm_mis x where id in (select /*+ cardinality(4) */ column_value id from table(:ids))) y,lateral (select dbms_lob.substr( o.text_data_plain, 1000, 1 ) Field_5799344 from tm_txt_obj o where (o.pgm_abs_id=y.TitleId or o.pgm_rl_id = y.VersionId) and o.type_id=:param_1 order by o.id desc fetch first 1 rows only)(+) t Verbose: 1220 : 16|08:38:55.8206|AUdIec|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 : 16|08:38:55.8206|AUdIec|CJPOWERCAST| timing: 00:00:01.0036214 t Verbose: 1220 : 16|08:38:55.8206|AUdIec|CJPOWERCAST|imfx v3 API took 1.015s '/api/v3/version/299543/media?_dc=1693208351031' t Information: 1220 : 16|08:38:55.8206|_EXKNH|CJPOWERCAST| timing: 00:00:00.9932282 t Verbose: 1220 : 16|08:38:55.8206|_EXKNH|CJPOWERCAST|imfx v3 API took 0.993s '/api/v3/version/299543/media?_dc=1693208351052' t Transfer: 1220 : 16|08:38:56.0352|_EXKNH|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0156.mp4 subfolder t Transfer: 1220 : 16|08:38:56.0352|AUdIec|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0156.mp4 subfolder t Transfer: 1220 : 16|08:38:56.0352|_EXKNH|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156.mp4 t Transfer: 1220 : 16|08:38:56.0352|_EXKNH|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156.mp4 t Transfer: 1220 : 16|08:38:56.0352|_EXKNH|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:56.0352|_EXKNH|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:56.0352|_EXKNH|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 16|08:38:56.0352|AUdIec|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156.mp4 t Transfer: 1220 : 16|08:38:56.0352|AUdIec|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156.mp4 t Transfer: 1220 : 16|08:38:56.0352|AUdIec|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:56.0352|AUdIec|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:56.0352|AUdIec|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 16|08:38:56.0352|_EXKNH|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0156M0002021.mp4 subfolder t Transfer: 1220 : 16|08:38:56.0352|_EXKNH|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156M0002021.mp4 t Transfer: 1220 : 16|08:38:56.0352|_EXKNH|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156M0002021.mp4 t Transfer: 1220 : 16|08:38:56.0352|_EXKNH|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:56.0352|_EXKNH|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:56.0352|_EXKNH|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 16|08:38:56.0352|AUdIec|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0156M0002021.mp4 subfolder t Transfer: 1220 : 16|08:38:56.0352|AUdIec|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156M0002021.mp4 t Transfer: 1220 : 16|08:38:56.0352|AUdIec|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156M0002021.mp4 t Transfer: 1220 : 16|08:38:56.0352|AUdIec|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:56.0352|AUdIec|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:56.0352|AUdIec|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 16|08:38:56.0352|_EXKNH|CJPOWERCAST|GetUrl. Storage |Audio| filename \\192.168.120.254\DemoFS\Digital Assets\Audio\gotspecialspromosaudio.wav subfolder t Transfer: 1220 : 16|08:38:56.0352|_EXKNH|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/AudioServer/gotspecialspromosaudio.wav t Transfer: 1220 : 16|08:38:56.0352|_EXKNH|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/AudioServer/gotspecialspromosaudio.wav t Transfer: 1220 : 16|08:38:56.0352|_EXKNH|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:56.0352|_EXKNH|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:56.0352|_EXKNH|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 16|08:38:56.0352|AUdIec|CJPOWERCAST|GetUrl. Storage |Audio| filename \\192.168.120.254\DemoFS\Digital Assets\Audio\gotspecialspromosaudio.wav subfolder t Transfer: 1220 : 16|08:38:56.0352|AUdIec|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/AudioServer/gotspecialspromosaudio.wav t Transfer: 1220 : 16|08:38:56.0352|AUdIec|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/AudioServer/gotspecialspromosaudio.wav t Transfer: 1220 : 16|08:38:56.0352|AUdIec|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:56.0352|AUdIec|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:56.0352|AUdIec|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 16|08:38:56.0352|_EXKNH|CJPOWERCAST|GetUrl. Storage |Audio| filename \\192.168.120.254\DemoFS\Digital Assets\Audio\PMH_portugese - Copy.wav subfolder t Transfer: 1220 : 16|08:38:56.0352|_EXKNH|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/AudioServer/PMH_portugese%20-%20Copy.wav t Transfer: 1220 : 16|08:38:56.0352|_EXKNH|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/AudioServer/PMH_portugese%20-%20Copy.wav t Transfer: 1220 : 16|08:38:56.0352|_EXKNH|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:56.0352|_EXKNH|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:56.0352|_EXKNH|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 16|08:38:56.0352|AUdIec|CJPOWERCAST|GetUrl. Storage |Audio| filename \\192.168.120.254\DemoFS\Digital Assets\Audio\PMH_portugese - Copy.wav subfolder t Transfer: 1220 : 16|08:38:56.0352|AUdIec|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/AudioServer/PMH_portugese%20-%20Copy.wav t Transfer: 1220 : 16|08:38:56.0352|AUdIec|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/AudioServer/PMH_portugese%20-%20Copy.wav t Transfer: 1220 : 16|08:38:56.0352|AUdIec|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:56.0352|AUdIec|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:56.0352|AUdIec|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 16|08:38:56.4572|k7k14Q|CJPOWERCAST|OAuth: /api/view/info/TapeGrid?lang=en-GB&_dc=1693208352662 t Transfer: 1220 : 16|08:38:56.4572|k7k14Q|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:56.4572|k7k14Q|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:56.4572|k7k14Q|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:38:56.4572|k7k14Q|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 16|08:38:56.4572|k7k14Q|CJPOWERCAST|GetGridViewBuilder. builder type TapeGrid. t Transfer: 1220 : 16|08:38:56.4572|k7k14Q|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:56.4572|k7k14Q|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:56.4572|k7k14Q|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 16|08:38:56.4572|k7k14Q|CJPOWERCAST|UserGridView. LoadView. ID -2, Name Default. t Transfer: 1220 : 16|08:38:56.4572|k7k14Q|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:56.4572|k7k14Q|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:56.4572|k7k14Q|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 16|08:38:56.4572|k7k14Q|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:56.4572|k7k14Q|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:56.4572|k7k14Q|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:38:56.4572|k7k14Q|CJPOWERCAST|imfx v3 API took 0.007s '/api/view/info/TapeGrid?lang=en-GB&_dc=1693208352662' t Transfer: 1220 : 16|08:38:56.6602|jp5jAK|CJPOWERCAST|OAuth: /api/v3/media/299739/carriers/physical?_dc=1693208352976 t Transfer: 1220 : 16|08:38:56.6602|jp5jAK|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:56.6602|jp5jAK|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:56.6602|jp5jAK|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:38:56.6602|jp5jAK|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 16|08:38:56.6602|jp5jAK|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 16|08:38:56.6602|jp5jAK|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:56.6602|jp5jAK|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:56.6602|jp5jAK|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 16|08:38:56.6602|jp5jAK|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:56.6602|jp5jAK|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:56.6602|jp5jAK|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:38:56.8634|jp5jAK|CJPOWERCAST|imfx v3 API took 0.067s '/api/v3/media/299739/carriers/physical?_dc=1693208352976' t Transfer: 1220 : 16|08:38:57.0739|45SrT7|CJPOWERCAST|OAuth: /api/v3/media/299739/carriers/physical?_dc=1693208353404 t Transfer: 1220 : 16|08:38:57.0739|45SrT7|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:57.0739|45SrT7|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:57.0739|45SrT7|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:38:57.0739|45SrT7|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 16|08:38:57.0739|45SrT7|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 16|08:38:57.0739|45SrT7|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:57.0739|45SrT7|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:57.0739|45SrT7|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 16|08:38:57.0739|45SrT7|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:57.0739|45SrT7|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:57.0739|45SrT7|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:38:57.0739|45SrT7|CJPOWERCAST|imfx v3 API took 0.013s '/api/v3/media/299739/carriers/physical?_dc=1693208353404' t Transfer: 1220 : 16|08:38:58.9121|YAWxfU|CJPOWERCAST|OAuth: /api/v3/media/299549/carriers/digital?_dc=1693208355149 t Transfer: 1220 : 16|08:38:58.9121|YAWxfU|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:58.9121|YAWxfU|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:58.9121|YAWxfU|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:38:58.9121|YAWxfU|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 16|08:38:58.9121|YAWxfU|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 16|08:38:58.9121|YAWxfU|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:58.9121|YAWxfU|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:58.9121|YAWxfU|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 16|08:38:58.9121|YAWxfU|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:38:58.9121|YAWxfU|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:38:58.9121|YAWxfU|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 16|08:38:59.1153|YAWxfU|CJPOWERCAST|SearchDigitalCarriersAdv SQL: select r.*, l.dv_nam SRVER_ID_TEXT from ( select a.*, rownum rnum from ( select m.* from tmddba.tm_dfile m where m.id in (select l.dfile_id as ID from TMDDBA.tm_mi_dfile_lnx l join TMDDBA.TM_MIS mi on (l.mi_id = mi.id) where (INSTR(mi.OWNERS,'|SFP2|')>0 OR INSTR(mi.OWNERS,'|PSP|')>0 OR INSTR(mi.OWNERS,'|PMS|')>0 OR INSTR(mi.OWNERS,'|SFP1|')>0 OR INSTR(mi.OWNERS,'|PMH|')>0 OR INSTR(mi.OWNERS,'|PPL|')>0)and mi.MI_DELETED = 0 and mi.ITEM_TYPE > 0) and m.id in (select l.dfile_id as ID from TMDDBA.tm_mi_dfile_lnx l join TMDDBA.TM_MIS mi on (l.mi_id = mi.id) where mi.id = :param_0 AND (INSTR(mi.OWNERS,'|SFP2|')>0 OR INSTR(mi.OWNERS,'|PSP|')>0 OR INSTR(mi.OWNERS,'|PMS|')>0 OR INSTR(mi.OWNERS,'|SFP1|')>0 OR INSTR(mi.OWNERS,'|PMH|')>0 OR INSTR(mi.OWNERS,'|PPL|')>0)and mi.MI_DELETED = 0 and mi.ITEM_TYPE > 0) order by m.OS_FNAME, m.id ) a where rownum <= 50) r left join tm_device_lst l on (r.srver_id = l.id) where rnum >= 1 order by rnum t Verbose: 1220 : 16|08:38:59.3183|YAWxfU|CJPOWERCAST|imfx v3 API took 0.365s '/api/v3/media/299549/carriers/digital?_dc=1693208355149' t Transfer: 1220 : 16|08:39:03.3936|2Fop0N|CJPOWERCAST|OAuth: /api/user-group-preferences?keys=googleMapsApiSettings&_dc=1693208359623 t Transfer: 1220 : 16|08:39:03.3936|2Fop0N|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:39:03.3936|2Fop0N|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:39:03.3936|2Fop0N|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:39:03.3936|2Fop0N|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 16|08:39:03.3936|2Fop0N|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:39:03.3936|2Fop0N|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:39:03.3936|2Fop0N|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:39:03.3936|2Fop0N|CJPOWERCAST|imfx v3 API took 0.007s '/api/user-group-preferences?keys=googleMapsApiSettings&_dc=1693208359623' t Transfer: 1220 : 16|08:39:03.5968|YNzf2F|CJPOWERCAST|OAuth: /api/v3/media-details/299549?_dc=1693208359870 t Transfer: 1220 : 16|08:39:03.5968|YNzf2F|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:39:03.5968|YNzf2F|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:39:03.5968|YNzf2F|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:39:03.5968|YNzf2F|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 16|08:39:03.5968|YNzf2F|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:39:03.5968|YNzf2F|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:39:03.5968|YNzf2F|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 16|08:39:04.2075|||TM_MIS. LoadSubtitles for ID: 299549 t Information: 1220 : 16|08:39:04.2075|||TM_MIS. LoadSubtitles for ID: 299549. SQL: 'select m.id, m.m_ctnr_id, m.m_ctnr_loc, m.modified_dt, m.tv_std, m.m_ctnr_fmt_id, d.sub_folder, nvl((select max(l.language) from tm_audio l where l.miid=m.id),aud_language_id) aud_language_id from tm_mis m left join tm_dfile d on (m.externally_owned_id=d.id) where m.mi_deleted=0 and m.item_type>0 and m.media_type=101 and m.PGM_PARENT_ID=299543' t Information: 1220 : 16|08:39:04.2075||| Subtitles added for ID: 299549, 291723 English : 'https://imfxv3tm.tmd.tv/getcaptions.aspx?f=inside game of thrones.stl&sf=&som=07:30:05:13&storage=TimedText&modified=637469339590000000&tcf=0&id=291723&tmp=0'. t Verbose: 1220 : 16|08:39:04.4106|YNzf2F|CJPOWERCAST|imfx v3 API took 0.716s '/api/v3/media-details/299549?_dc=1693208359870' t Transfer: 1220 : 16|08:39:04.4106|YNzf2F|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0156.mp4 subfolder t Transfer: 1220 : 16|08:39:04.4106|YNzf2F|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156.mp4 t Transfer: 1220 : 16|08:39:04.4106|YNzf2F|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156.mp4 t Transfer: 1220 : 16|08:39:04.4106|YNzf2F|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:39:04.4106|YNzf2F|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:39:04.4106|YNzf2F|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 16|08:39:04.6137|i9QD_p|CJPOWERCAST|OAuth: /api/v3/detailsview/MediaDetails/5?lang=en-GB&_dc=1693208360923 t Transfer: 1220 : 16|08:39:04.6137|i9QD_p|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:39:04.6137|i9QD_p|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:39:04.6137|i9QD_p|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:39:04.6137|i9QD_p|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 16|08:39:04.6137|i9QD_p|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:39:04.6137|i9QD_p|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:39:04.6137|i9QD_p|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 16|08:39:04.6137|i9QD_p|CJPOWERCAST|GetSystemPref. Pref: DetailsView, Type: -4013, subType: 5 t Information: 1220 : 16|08:39:04.8168|i9QD_p|CJPOWERCAST|GetSystemPref. Pref: DetailsView, Type: -4013, subType: 0 t Information: 1220 : 16|08:39:04.8168|i9QD_p|CJPOWERCAST|GetSystemPref. Pref: DetailsView, Type: -4013, subType: 5 t Information: 1220 : 16|08:39:04.8168|i9QD_p|CJPOWERCAST|GetSystemPref. Pref: DetailsView, Type: -4013, subType: 0 t Verbose: 1220 : 16|08:39:04.8168|i9QD_p|CJPOWERCAST|imfx v3 API took 0.081s '/api/v3/detailsview/MediaDetails/5?lang=en-GB&_dc=1693208360923' t Transfer: 1220 : 16|08:39:05.0200|Xq4CFI|CJPOWERCAST|OAuth: /api/v3/media-captions/299549?_dc=1693208361298 t Transfer: 1220 : 16|08:39:05.0200|Xq4CFI|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:39:05.0200|Xq4CFI|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:39:05.0200|Xq4CFI|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:39:05.0200|Xq4CFI|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 16|08:39:05.0200|Xq4CFI|CJPOWERCAST|imfx v3 API took 0.047s '/api/v3/media-captions/299549?_dc=1693208361298' t Transfer: 1220 : 16|08:39:05.2231|pDAZ2A|CJPOWERCAST|OAuth: /api/v3/mediavideo/299549?info=smudge,scene,audiovolume&_dc=1693208361410 t Transfer: 1220 : 16|08:39:05.2231|pDAZ2A|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:39:05.2231|pDAZ2A|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:39:05.2231|pDAZ2A|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:39:05.2231|pDAZ2A|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 16|08:39:05.2231|gnSH~p|CJPOWERCAST|OAuth: /api/user-group-preferences?keys=googleMapsApiSettings&_dc=1693208361415 t Transfer: 1220 : 16|08:39:05.2231|gnSH~p|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:39:05.2231|gnSH~p|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:39:05.2231|gnSH~p|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:39:05.2231|gnSH~p|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 16|08:39:05.2231|gnSH~p|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:39:05.2231|gnSH~p|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:39:05.2231|gnSH~p|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:39:05.2231|gnSH~p|CJPOWERCAST|imfx v3 API took 0.004s '/api/user-group-preferences?keys=googleMapsApiSettings&_dc=1693208361415' t Transfer: 1220 : 16|08:39:05.2231|pDAZ2A|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0156.mp4 subfolder t Transfer: 1220 : 16|08:39:05.2231|pDAZ2A|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156.mp4 t Transfer: 1220 : 16|08:39:05.2231|pDAZ2A|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156.mp4 t Transfer: 1220 : 16|08:39:05.2231|pDAZ2A|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:39:05.2231|pDAZ2A|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:39:05.2231|pDAZ2A|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:39:05.2231|pDAZ2A|CJPOWERCAST|imfx v3 API took 0.162s '/api/v3/mediavideo/299549?info=smudge,scene,audiovolume&_dc=1693208361410' t Transfer: 1220 : 16|08:39:05.4262|bupjCn|CJPOWERCAST|OAuth: /api/lookups/FriendlyNames?_dc=1693208361645 t Transfer: 1220 : 16|08:39:05.4262|bupjCn|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:39:05.4262|bupjCn|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:39:05.4262|bupjCn|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:39:05.4262|bupjCn|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 16|08:39:05.4262|bupjCn|CJPOWERCAST|imfx v3 API took 0.000s '/api/lookups/FriendlyNames?_dc=1693208361645' t Transfer: 1220 : 16|08:39:05.4262|MQ3D8K|CJPOWERCAST|OAuth: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1693208361767 t Transfer: 1220 : 16|08:39:05.4262|MQ3D8K|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:39:05.4262|MQ3D8K|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:39:05.4262|MQ3D8K|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:39:05.4262|MQ3D8K|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 16|08:39:05.4262|MQ3D8K|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:39:05.4262|MQ3D8K|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:39:05.4262|MQ3D8K|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 16|08:39:05.4262|iKagRp|CJPOWERCAST|OAuth: /api/settings/user/videoPlayerSettings?_dc=1693208361775 t Transfer: 1220 : 16|08:39:05.4262|iKagRp|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:39:05.4262|iKagRp|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:39:05.4262|iKagRp|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:39:05.4262|iKagRp|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 16|08:39:05.4262|MQ3D8K|CJPOWERCAST|imfx v3 API took 0.010s '/api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1693208361767' t Transfer: 1220 : 16|08:39:05.4262|iKagRp|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:39:05.4262|iKagRp|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:39:05.4262|iKagRp|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:39:05.6294|iKagRp|CJPOWERCAST|imfx v3 API took 0.008s '/api/settings/user/videoPlayerSettings?_dc=1693208361775' t Transfer: 1220 : 16|08:39:05.8326|Pq0X0o|CJPOWERCAST|OAuth: /api/v3/subtitles/291723?sf=&f=inside%20game%20of%20thrones.stl&tcf=0&storage=TimedText&modified=637469339590000000&_dc=1693208362045 t Transfer: 1220 : 16|08:39:05.8326|Pq0X0o|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:39:05.8326|Pq0X0o|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:39:05.8326|Pq0X0o|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:39:05.8326|Pq0X0o|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 16|08:39:05.8326|Pq0X0o|CJPOWERCAST|LoadSubtitlesById. filename inside game of thrones.stl device TimedText frame rate Pal t Information: 1220 : 16|08:39:05.8326|Pq0X0o|CJPOWERCAST|LoadSubtitlesById. Filename: inside game of thrones.stl. Device TimedText. Timecode format Pal. Media ID 291723. t Information: 1220 : 16|08:39:05.8326|Pq0X0o|CJPOWERCAST|GetCaptions. Start. Filename: inside game of thrones.stl. SubFolder: . Cache path C:\inetpub\wwwroot\imfxcore\timedtextcache\. Storage path \\192.168.120.254\DemoFS\Digital Assets\TimedText. Last Modified 1/22/2021 5:39:19 PM. Convert to Real Time False t Transfer: 1220 : 16|08:39:05.8326|DzKp~F|CJPOWERCAST|OAuth: /api/v3/ai-tags/299549?_dc=1693208362072 t Transfer: 1220 : 16|08:39:05.8326|DzKp~F|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:39:05.8326|DzKp~F|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:39:05.8326|DzKp~F|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:39:05.8326|DzKp~F|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 16|08:39:05.8326|DzKp~F|CJPOWERCAST|V3Api.GetMediaAiTags t Transfer: 1220 : 16|08:39:05.8326|nS9bbg|CJPOWERCAST|OAuth: /api/v3/mediavideo/299549?info=smudge&_dc=1693208362078 t Transfer: 1220 : 16|08:39:05.8326|nS9bbg|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:39:05.8326|nS9bbg|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:39:05.8326|nS9bbg|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:39:05.8326|nS9bbg|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 16|08:39:05.8326|Pq0X0o|CJPOWERCAST|GetCaptions. Convert required. Som 00:00:00. From: \\192.168.120.254\DemoFS\Digital Assets\TimedText\inside game of thrones.stl to: C:\inetpub\wwwroot\imfxcore\timedtextcache\inside game of thrones.stl_pal_291723.xml t Information: 1220 : 16|08:39:05.8326|Pq0X0o|CJPOWERCAST|GetCaptions. Convertor lock acquired. t Transfer: 1220 : 16|08:39:05.8326|nS9bbg|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0156.mp4 subfolder t Transfer: 1220 : 16|08:39:05.8326|nS9bbg|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156.mp4 t Transfer: 1220 : 16|08:39:05.8326|nS9bbg|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156.mp4 t Transfer: 1220 : 16|08:39:05.8326|nS9bbg|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:39:05.8326|nS9bbg|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:39:05.8326|nS9bbg|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:39:05.8326|DzKp~F|CJPOWERCAST|imfx v3 API took 0.027s '/api/v3/ai-tags/299549?_dc=1693208362072' t Verbose: 1220 : 16|08:39:05.8326|nS9bbg|CJPOWERCAST|imfx v3 API took 0.024s '/api/v3/mediavideo/299549?info=smudge&_dc=1693208362078' t Information: 1220 : 16|08:39:06.4445|Pq0X0o|CJPOWERCAST|GetCaptions. File converted: \\192.168.120.254\DemoFS\Digital Assets\TimedText\inside game of thrones.stl. Result: True t Information: 1220 : 16|08:39:06.4445|Pq0X0o|CJPOWERCAST|GetCaptions. In cache. Filename: C:\inetpub\wwwroot\imfxcore\timedtextcache\inside game of thrones.stl_pal_291723.xml t Information: 1220 : 16|08:39:06.4445|Pq0X0o|CJPOWERCAST|LoadSubtitlesById. Convertor lock acquired. t Information: 1220 : 16|08:39:06.4445|Pq0X0o|CJPOWERCAST|LoadSubtitlesById got 43 lines. t Verbose: 1220 : 16|08:39:06.4445|Pq0X0o|CJPOWERCAST|imfx v3 API took 0.660s '/api/v3/subtitles/291723?sf=&f=inside%20game%20of%20thrones.stl&tcf=0&storage=TimedText&modified=637469339590000000&_dc=1693208362045' t Information: 1220 : 16|08:39:06.6477|_~NdsA||GetCaptionsForWeb. Filename: inside game of thrones.stl. SubFolder . Device TimedText. Format WebVTT. Timecode format Pal. Media ID 291723. Last Modified 1/22/2021 5:39:19 PM t Information: 1220 : 16|08:39:06.6477|_~NdsA||GetCaptions. Start. Filename: inside game of thrones.stl. SubFolder: . Cache path C:\inetpub\wwwroot\imfxcore\timedtextcache\. Storage path \\192.168.120.254\DemoFS\Digital Assets\TimedText. Last Modified 1/22/2021 5:39:19 PM. Convert to Real Time True t Information: 1220 : 16|08:39:06.6477|_~NdsA||GetCaptions. Convert required. Som 07:30:05.5200000. From: \\192.168.120.254\DemoFS\Digital Assets\TimedText\inside game of thrones.stl to: C:\inetpub\wwwroot\imfxcore\timedtextcache\inside game of thrones.stl_pal_291723_rt.vtt t Information: 1220 : 16|08:39:06.6477|_~NdsA||GetCaptions. Convertor lock acquired. t Information: 1220 : 16|08:39:06.6477|_~NdsA||GetCaptions. File converted: \\192.168.120.254\DemoFS\Digital Assets\TimedText\inside game of thrones.stl. Result: True t Information: 1220 : 16|08:39:06.6477|_~NdsA||GetCaptions. In cache. Filename: C:\inetpub\wwwroot\imfxcore\timedtextcache\inside game of thrones.stl_pal_291723_rt.vtt t Transfer: 1220 : 16|08:39:10.3211|p5u1WD|CJPOWERCAST|OAuth: /api/metadata/4000/299549?_dc=1693208366509 t Transfer: 1220 : 16|08:39:10.3211|p5u1WD|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:39:10.3211|p5u1WD|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:39:10.3211|p5u1WD|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:39:10.3211|p5u1WD|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 16|08:39:10.3211|p5u1WD|CJPOWERCAST|imfx v3 API took 0.065s '/api/metadata/4000/299549?_dc=1693208366509' t Transfer: 1220 : 16|08:39:44.3397|UYRoQh|CJPOWERCAST|OAuth: /api/v3/search/Media?_dc=1693208400634 t Transfer: 1220 : 16|08:39:44.3397|UYRoQh|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:39:44.3397|UYRoQh|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:39:44.3397|UYRoQh|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:39:44.3397|UYRoQh|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 16|08:39:44.3397|A7jvhc|CJPOWERCAST|OAuth: /api/v3/search/versions?_dc=1693208400631 t Transfer: 1220 : 16|08:39:44.3397|A7jvhc|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:39:44.3397|A7jvhc|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:39:44.3397|A7jvhc|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:39:44.3397|A7jvhc|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 16|08:39:44.3397|UYRoQh|CJPOWERCAST|V3Api.SearchMedia t Information: 1220 : 16|08:39:44.3397|UYRoQh|CJPOWERCAST|V3Api.SearchGeneric t Information: 1220 : 16|08:39:44.3397|A7jvhc|CJPOWERCAST|V3Api.SearchVersions t Information: 1220 : 16|08:39:44.3397|A7jvhc|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 16|08:39:44.3397|A7jvhc|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:39:44.3397|A7jvhc|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:39:44.3397|A7jvhc|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 16|08:39:44.3397|UYRoQh|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:39:44.3397|UYRoQh|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:39:44.3397|UYRoQh|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 16|08:39:44.3397|A7jvhc|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:39:44.3397|A7jvhc|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:39:44.3397|A7jvhc|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 16|08:39:44.3397|A7jvhc|CJPOWERCAST|SearchVersion SQL: select * from (select a.*, rownum rnum from ( select m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE , (select min(name) from TM_CFG_AUDIO_CONTENT_MS_TYPES audio where m.audio_type = audio.id ) SOUND ,(select min(from_date_time) from TM_PG_RL_PROD_DATE prodDate where prodDate.Tm_Pg_Rl_Id = m.id ) PROD_FROM_DATE ,(select min(to_date_time) from TM_PG_RL_PROD_DATE prodDate where prodDate.Tm_Pg_Rl_Id = m.id ) PROD_TO_DATE ,(select min(full_name) from tm_lang_data lang, TM_PG_RL_LANG_LNX link where lang.id = link.lang_id and link.tm_pg_rl_id = m.id) PROD_LANGUAGE ,(SELECT min(COLOUR_NAME) FROM tm_cfg_colour_list list, tm_pg_rl ver where ver.col_mono = list.id and ver.id = m.id) PROD_COLOUR_TEXT ,(SELECT min(cfg.prod_date_type_name) FROM TM_PG_RL_PROD_DATE pg_rl, tm_cfg_prod_date_type cfg where cfg.id = pg_rl.PROD_DATE_TYPE_ID and TM_PG_RL_ID = m.id ) PROD_DATE_TYPE ,(select min(status.description) from TM_CFG_PGM_STATUS status where m.ITEM_STATUS_ID = status.id) PGM_STATUS_TEXT ,(select submed.sub_medium_name from TM_CFG_SUB_MEDIUM submed where m.SUB_MEDIUM_ID = submed.id) SUB_MEDIUM_TEXT ,(select med.medium_name from TM_CFG_MEDIUM med, TM_PG_ABS pgabs where pgabs.id=m.PGM_ABS_ID and pgabs.MEDIUM_ID = med.id) MEDIUM_TEXT ,(select replace(tmd_str_agg_pipe(cf.form_name),'|',' / ') from TM_PG_FORM_LNX fl join TM_CFG_FORM cf on (cf.id=fl.form_id) where fl.tm_pg_id = m.ID) FORM_TEXT ,(select replace(tmd_str_agg_pipe(dvb.item_name),'|',' / ') from TM_PG_ABS_GENRE_LNX gl join TM_DVB dvb on (dvb.id=gl.genre_id) where gl.tm_pg_abs_id = m.PGM_ABS_ID) GENRE_TEXT, (select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = m.net_grp_id) CHANNEL_GROUP, (select count(id) from tm_mis where item_type>0 and pgm_parent_id=m.id) MEDIA_COUNT, (select cvt.ID from TM_PORTAL_VERSION_CONFIG cvt where m.CUSTOM_VERSION_TYPE = cvt.CUSTOM_VERSION_TYPE AND cvt.CUSTOM_VERSION_TYPE IS NOT NULL ) MP_CONFIG_ID from (select v.*, coalesce(v.primary_thumb_id, (select x.primary_thumb_id from tm_pg_rl x where x.id=v.parent_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.pgm_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs2_id) ) primary_thumb_id2 from tmddba.tm_pg_rl v) m left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id2 where item_type>0 and rl_deleted=0 and m.ID = :param_0 AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0) order by m.title,m.id) a where rownum <= 50) r where rnum >=1 order by rnum t Information: 1220 : 16|08:39:44.3397|UYRoQh|CJPOWERCAST|MediaSearch SQL: --sqlFromPaging select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type in (1,110)),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , (SELECT min(status.ACCESS_STATUS_NAME) FROM TMDDBA.TM_ACCESS_STATUS statusLnx, TM_CFG_ACCESS_STATUS status WHERE statusLnx.Media_Id = r.id and statusLnx.Status_Id = status.id) ACCESS_STATUS , (select min(acq.ext_ref) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) CONSIGNMENT_NUMBER , (select min(acq.alt_id1) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) TRANSFER_NUMBER , (select min(crs.series_number) from tm_series_data crs where crs.id = r.GROUP_SERIES_ID) CRS_SERIES , (select min(DISPOSAL_NAME) from TM_ACQ_DISPOSAL status, tm_disposal_records records where status.id = records.disposal_status_id and records.miid = r.id) DISPOSAL_STATUS , (select min(class.class_number) from TM_ACQ_DISPOSAL status, tm_disposal_records records, tm_disposal_classes class where status.id = records.disposal_status_id and records.miid = r.id and class.id = records.disposal_class_id) DISPOSAL_CLASS, (select min(names.concat_search_name) from tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names where r.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY, (select min(c.u_id_ext1) from tmddba.tm_mi_tpi_lnx lnx, tm_ctnrs c where c.u_id = lnx.tpiid and lnx.miid = r.id) U_ID_EXT1 , (select t.name from TM_CFG_MI_FMT_TYP t where t.id = r.mi_fmt_type) ITEM_FORMAT_TEXT, CASE WHEN BITAND(r.COMPIL, 2) = 2 THEN 'SUPPLIED' WHEN BITAND(r.COMPIL, 4) = 4 THEN 'MADE' WHEN BITAND(r.COMPIL, 134217728) = 134217728 THEN 'IMPORTED' ELSE '' END AS ORIGIN, CASE WHEN BITAND(r.COMPIL, 512) = 512 THEN 'Attached' WHEN BITAND(r.COMPIL, 1024) = 1024 THEN 'Un-Attached' ELSE '' END AS FLAGS, (select min(lang.full_name) from TM_PG_RL_LANG_LNX lnx, TM_LANG_DATA lang where lnx.tm_pg_rl_id = r.pgm_parent_id and lnx.lang_id = lang.id) AS PROD_LANGUAGE , (select min(ctx.ITFC_CODE) from tm_mis mis, tm_mi_tpi_lnx links, tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names where mis.id = r.id and links.miid = mis.id and mis.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY_NUMBER, (select min(status.description) from TM_CFG_PGM_STATUS status where r.status = status.id) PGM_STATUS_TEXT, (select min(ver.DUR) from TM_PG_RL ver where r.pgm_PARENT_ID = ver.id) AS VERSION_DUR , (select tmd_str_agg_pipe(cms.status_type_id ||',' ||cms.status_id) from tm_mi_cust_med_stat_lnx cms where cms.media_id=r.id) "CustomStatusesRaw", (select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = r.net_grp_id) CHANNEL_GROUP, (SELECT SUBSTR( trim( replace (replace ( LISTAGG(trim(tt.tags || ' ' || tt.notes), ' ') WITHIN GROUP (ORDER BY trim(tt.tags || ' ' || tt.notes)), chr (13), ''), chr (10), ' ')), 1, 150) z FROM tm_media_tagging tt WHERE link_guid = DFILE_LINK_GUID and rownum=1) TAGS_TEXT , GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select t.*, coalesce(t.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=t.pgm_parent_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.pgm_abs_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs2_id) ) primary_thumb_id2 from ( --sqlSubSelect select s.* from (select a.*, rownum rnum from (select --sqlFrom m.* from tmddba.tm_mis m --sqlWhere where media_type>0 and item_type>0 AND m.ID = :param_0 and m.mi_deleted=0 AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0) order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) s where rnum >= 1) t ) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl order by r.rnum t Information: 1220 : 16|08:39:44.9803|A7jvhc|CJPOWERCAST|Running version search. User: 1165 Simple Search: Running Oracle search. Running Oracle search for COUNT Oracle count completed in: 9ms. Returned lines: 1 Oracle version search timing: 616ms. SQL run: select * from (select a.*, rownum rnum from ( select m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE , (select min(name) from TM_CFG_AUDIO_CONTENT_MS_TYPES audio where m.audio_type = audio.id ) SOUND ,(select min(from_date_time) from TM_PG_RL_PROD_DATE prodDate where prodDate.Tm_Pg_Rl_Id = m.id ) PROD_FROM_DATE ,(select min(to_date_time) from TM_PG_RL_PROD_DATE prodDate where prodDate.Tm_Pg_Rl_Id = m.id ) PROD_TO_DATE ,(select min(full_name) from tm_lang_data lang, TM_PG_RL_LANG_LNX link where lang.id = link.lang_id and link.tm_pg_rl_id = m.id) PROD_LANGUAGE ,(SELECT min(COLOUR_NAME) FROM tm_cfg_colour_list list, tm_pg_rl ver where ver.col_mono = list.id and ver.id = m.id) PROD_COLOUR_TEXT ,(SELECT min(cfg.prod_date_type_name) FROM TM_PG_RL_PROD_DATE pg_rl, tm_cfg_prod_date_type cfg where cfg.id = pg_rl.PROD_DATE_TYPE_ID and TM_PG_RL_ID = m.id ) PROD_DATE_TYPE ,(select min(status.description) from TM_CFG_PGM_STATUS status where m.ITEM_STATUS_ID = status.id) PGM_STATUS_TEXT ,(select submed.sub_medium_name from TM_CFG_SUB_MEDIUM submed where m.SUB_MEDIUM_ID = submed.id) SUB_MEDIUM_TEXT ,(select med.medium_name from TM_CFG_MEDIUM med, TM_PG_ABS pgabs where pgabs.id=m.PGM_ABS_ID and pgabs.MEDIUM_ID = med.id) MEDIUM_TEXT ,(select replace(tmd_str_agg_pipe(cf.form_name),'|',' / ') from TM_PG_FORM_LNX fl join TM_CFG_FORM cf on (cf.id=fl.form_id) where fl.tm_pg_id = m.ID) FORM_TEXT ,(select replace(tmd_str_agg_pipe(dvb.item_name),'|',' / ') from TM_PG_ABS_GENRE_LNX gl join TM_DVB dvb on (dvb.id=gl.genre_id) where gl.tm_pg_abs_id = m.PGM_ABS_ID) GENRE_TEXT, (select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = m.net_grp_id) CHANNEL_GROUP, (select count(id) from tm_mis where item_type>0 and pgm_parent_id=m.id) MEDIA_COUNT, (select cvt.ID from TM_PORTAL_VERSION_CONFIG cvt where m.CUSTOM_VERSION_TYPE = cvt.CUSTOM_VERSION_TYPE AND cvt.CUSTOM_VERSION_TYPE IS NOT NULL ) MP_CONFIG_ID from (select v.*, coalesce(v.primary_thumb_id, (select x.primary_thumb_id from tm_pg_rl x where x.id=v.parent_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.pgm_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs2_id) ) primary_thumb_id2 from tmddba.tm_pg_rl v) m left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id2 where item_type>0 and rl_deleted=0 and m.ID = :param_0 AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0) order by m.title,m.id) a where rownum <= 50) r where rnum >=1 order by rnum t Verbose: 1220 : 16|08:39:44.9803|A7jvhc|CJPOWERCAST|Alternative title fields query: select * from (select x.id,x.pgm_abs_id TitleId, x.id VersionId from TM_PG_RL x where id in (select /*+ cardinality(4) */ column_value id from table(:ids))) y,lateral (select dbms_lob.substr( o.text_data_plain, 1000, 1 ) Field_5799344 from tm_txt_obj o where (o.pgm_abs_id=y.TitleId or o.pgm_rl_id = y.VersionId) and o.type_id=:param_1 order by o.id desc fetch first 1 rows only)(+) t Verbose: 1220 : 16|08:39:44.9803|A7jvhc|CJPOWERCAST|imfx v3 API took 0.642s '/api/v3/search/versions?_dc=1693208400631' t Verbose: 1220 : 16|08:39:45.1990|UYRoQh|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 : 16|08:39:45.1990|UYRoQh|CJPOWERCAST| timing: 00:00:00.7880261 t Verbose: 1220 : 16|08:39:45.1990|UYRoQh|CJPOWERCAST|imfx v3 API took 0.789s '/api/v3/search/Media?_dc=1693208400634' t Transfer: 1220 : 16|08:39:45.1990|UYRoQh|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0156.mp4 subfolder t Transfer: 1220 : 16|08:39:45.1990|UYRoQh|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156.mp4 t Transfer: 1220 : 16|08:39:45.1990|UYRoQh|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156.mp4 t Transfer: 1220 : 16|08:39:45.1990|UYRoQh|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:39:45.1990|UYRoQh|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:39:45.1990|UYRoQh|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 16|08:39:45.8084|B8zAHP|CJPOWERCAST|OAuth: /api/v3/version/299543/media?_dc=1693208401972 t Transfer: 1220 : 16|08:39:45.8084|B8zAHP|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:39:45.8084|B8zAHP|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:39:45.8084|B8zAHP|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:39:45.8084|B8zAHP|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 16|08:39:45.8084|B8zAHP|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 16|08:39:45.8084|B8zAHP|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:39:45.8084|B8zAHP|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:39:45.8084|B8zAHP|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 16|08:39:45.8084|B8zAHP|CJPOWERCAST|MediaSearch SQL: --sqlFromPaging select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type in (1,110)),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , (SELECT min(status.ACCESS_STATUS_NAME) FROM TMDDBA.TM_ACCESS_STATUS statusLnx, TM_CFG_ACCESS_STATUS status WHERE statusLnx.Media_Id = r.id and statusLnx.Status_Id = status.id) ACCESS_STATUS , (select min(acq.ext_ref) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) CONSIGNMENT_NUMBER , (select min(acq.alt_id1) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) TRANSFER_NUMBER , (select min(crs.series_number) from tm_series_data crs where crs.id = r.GROUP_SERIES_ID) CRS_SERIES , (select min(DISPOSAL_NAME) from TM_ACQ_DISPOSAL status, tm_disposal_records records where status.id = records.disposal_status_id and records.miid = r.id) DISPOSAL_STATUS , (select min(class.class_number) from TM_ACQ_DISPOSAL status, tm_disposal_records records, tm_disposal_classes class where status.id = records.disposal_status_id and records.miid = r.id and class.id = records.disposal_class_id) DISPOSAL_CLASS, (select min(names.concat_search_name) from tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names where r.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY, (select min(c.u_id_ext1) from tmddba.tm_mi_tpi_lnx lnx, tm_ctnrs c where c.u_id = lnx.tpiid and lnx.miid = r.id) U_ID_EXT1 , (select t.name from TM_CFG_MI_FMT_TYP t where t.id = r.mi_fmt_type) ITEM_FORMAT_TEXT, CASE WHEN BITAND(r.COMPIL, 2) = 2 THEN 'SUPPLIED' WHEN BITAND(r.COMPIL, 4) = 4 THEN 'MADE' WHEN BITAND(r.COMPIL, 134217728) = 134217728 THEN 'IMPORTED' ELSE '' END AS ORIGIN, CASE WHEN BITAND(r.COMPIL, 512) = 512 THEN 'Attached' WHEN BITAND(r.COMPIL, 1024) = 1024 THEN 'Un-Attached' ELSE '' END AS FLAGS, (select min(lang.full_name) from TM_PG_RL_LANG_LNX lnx, TM_LANG_DATA lang where lnx.tm_pg_rl_id = r.pgm_parent_id and lnx.lang_id = lang.id) AS PROD_LANGUAGE , (select min(ctx.ITFC_CODE) from tm_mis mis, tm_mi_tpi_lnx links, tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names where mis.id = r.id and links.miid = mis.id and mis.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY_NUMBER, (select min(status.description) from TM_CFG_PGM_STATUS status where r.status = status.id) PGM_STATUS_TEXT, (select min(ver.DUR) from TM_PG_RL ver where r.pgm_PARENT_ID = ver.id) AS VERSION_DUR , (select tmd_str_agg_pipe(cms.status_type_id ||',' ||cms.status_id) from tm_mi_cust_med_stat_lnx cms where cms.media_id=r.id) "CustomStatusesRaw", (select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = r.net_grp_id) CHANNEL_GROUP, (SELECT SUBSTR( trim( replace (replace ( LISTAGG(trim(tt.tags || ' ' || tt.notes), ' ') WITHIN GROUP (ORDER BY trim(tt.tags || ' ' || tt.notes)), chr (13), ''), chr (10), ' ')), 1, 150) z FROM tm_media_tagging tt WHERE link_guid = DFILE_LINK_GUID and rownum=1) TAGS_TEXT , GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select t.*, coalesce(t.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=t.pgm_parent_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.pgm_abs_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs2_id) ) primary_thumb_id2 from ( --sqlSubSelect select s.* from (select a.*, rownum rnum from (select --sqlFrom m.* from tmddba.tm_mis m --sqlWhere where media_type>0 and item_type>0 AND PGM_PARENT_ID=:param_0 and m.mi_deleted=0 AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0) order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) s where rnum >= 1) t ) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl order by r.rnum t Verbose: 1220 : 16|08:39:45.8084|B8zAHP|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 : 16|08:39:45.8084|B8zAHP|CJPOWERCAST| timing: 00:00:00.0310856 t Verbose: 1220 : 16|08:39:45.8084|B8zAHP|CJPOWERCAST|imfx v3 API took 0.031s '/api/v3/version/299543/media?_dc=1693208401972' t Transfer: 1220 : 16|08:39:45.8084|B8zAHP|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0156.mp4 subfolder t Transfer: 1220 : 16|08:39:45.8084|B8zAHP|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156.mp4 t Transfer: 1220 : 16|08:39:45.8084|B8zAHP|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156.mp4 t Transfer: 1220 : 16|08:39:45.8084|B8zAHP|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:39:45.8084|B8zAHP|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:39:45.8084|B8zAHP|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 16|08:39:45.8084|B8zAHP|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0156M0002021.mp4 subfolder t Transfer: 1220 : 16|08:39:45.8084|B8zAHP|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156M0002021.mp4 t Transfer: 1220 : 16|08:39:45.8084|B8zAHP|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156M0002021.mp4 t Transfer: 1220 : 16|08:39:45.8084|B8zAHP|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:39:45.8084|B8zAHP|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:39:45.8084|B8zAHP|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 16|08:39:45.8084|B8zAHP|CJPOWERCAST|GetUrl. Storage |Audio| filename \\192.168.120.254\DemoFS\Digital Assets\Audio\gotspecialspromosaudio.wav subfolder t Transfer: 1220 : 16|08:39:45.8084|B8zAHP|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/AudioServer/gotspecialspromosaudio.wav t Transfer: 1220 : 16|08:39:45.8084|B8zAHP|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/AudioServer/gotspecialspromosaudio.wav t Transfer: 1220 : 16|08:39:45.8084|B8zAHP|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:39:45.8084|B8zAHP|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:39:45.8084|B8zAHP|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 16|08:39:45.8084|B8zAHP|CJPOWERCAST|GetUrl. Storage |Audio| filename \\192.168.120.254\DemoFS\Digital Assets\Audio\PMH_portugese - Copy.wav subfolder t Transfer: 1220 : 16|08:39:45.8084|B8zAHP|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/AudioServer/PMH_portugese%20-%20Copy.wav t Transfer: 1220 : 16|08:39:45.8084|B8zAHP|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/AudioServer/PMH_portugese%20-%20Copy.wav t Transfer: 1220 : 16|08:39:45.8084|B8zAHP|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:39:45.8084|B8zAHP|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:39:45.8084|B8zAHP|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 16|08:39:49.2935|jN8bF~|CJPOWERCAST|OAuth: /api/v3/version/299543/media?_dc=1693208405534 t Transfer: 1220 : 16|08:39:49.2935|jN8bF~|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:39:49.2935|jN8bF~|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:39:49.2935|jN8bF~|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:39:49.2935|jN8bF~|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 16|08:39:49.2935|jN8bF~|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 16|08:39:49.2935|jN8bF~|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:39:49.2935|jN8bF~|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:39:49.2935|jN8bF~|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 16|08:39:49.2935|jN8bF~|CJPOWERCAST|MediaSearch SQL: --sqlFromPaging select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type in (1,110)),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , (SELECT min(status.ACCESS_STATUS_NAME) FROM TMDDBA.TM_ACCESS_STATUS statusLnx, TM_CFG_ACCESS_STATUS status WHERE statusLnx.Media_Id = r.id and statusLnx.Status_Id = status.id) ACCESS_STATUS , (select min(acq.ext_ref) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) CONSIGNMENT_NUMBER , (select min(acq.alt_id1) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) TRANSFER_NUMBER , (select min(crs.series_number) from tm_series_data crs where crs.id = r.GROUP_SERIES_ID) CRS_SERIES , (select min(DISPOSAL_NAME) from TM_ACQ_DISPOSAL status, tm_disposal_records records where status.id = records.disposal_status_id and records.miid = r.id) DISPOSAL_STATUS , (select min(class.class_number) from TM_ACQ_DISPOSAL status, tm_disposal_records records, tm_disposal_classes class where status.id = records.disposal_status_id and records.miid = r.id and class.id = records.disposal_class_id) DISPOSAL_CLASS, (select min(names.concat_search_name) from tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names where r.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY, (select min(c.u_id_ext1) from tmddba.tm_mi_tpi_lnx lnx, tm_ctnrs c where c.u_id = lnx.tpiid and lnx.miid = r.id) U_ID_EXT1 , (select t.name from TM_CFG_MI_FMT_TYP t where t.id = r.mi_fmt_type) ITEM_FORMAT_TEXT, CASE WHEN BITAND(r.COMPIL, 2) = 2 THEN 'SUPPLIED' WHEN BITAND(r.COMPIL, 4) = 4 THEN 'MADE' WHEN BITAND(r.COMPIL, 134217728) = 134217728 THEN 'IMPORTED' ELSE '' END AS ORIGIN, CASE WHEN BITAND(r.COMPIL, 512) = 512 THEN 'Attached' WHEN BITAND(r.COMPIL, 1024) = 1024 THEN 'Un-Attached' ELSE '' END AS FLAGS, (select min(lang.full_name) from TM_PG_RL_LANG_LNX lnx, TM_LANG_DATA lang where lnx.tm_pg_rl_id = r.pgm_parent_id and lnx.lang_id = lang.id) AS PROD_LANGUAGE , (select min(ctx.ITFC_CODE) from tm_mis mis, tm_mi_tpi_lnx links, tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names where mis.id = r.id and links.miid = mis.id and mis.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY_NUMBER, (select min(status.description) from TM_CFG_PGM_STATUS status where r.status = status.id) PGM_STATUS_TEXT, (select min(ver.DUR) from TM_PG_RL ver where r.pgm_PARENT_ID = ver.id) AS VERSION_DUR , (select tmd_str_agg_pipe(cms.status_type_id ||',' ||cms.status_id) from tm_mi_cust_med_stat_lnx cms where cms.media_id=r.id) "CustomStatusesRaw", (select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = r.net_grp_id) CHANNEL_GROUP, (SELECT SUBSTR( trim( replace (replace ( LISTAGG(trim(tt.tags || ' ' || tt.notes), ' ') WITHIN GROUP (ORDER BY trim(tt.tags || ' ' || tt.notes)), chr (13), ''), chr (10), ' ')), 1, 150) z FROM tm_media_tagging tt WHERE link_guid = DFILE_LINK_GUID and rownum=1) TAGS_TEXT , GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select t.*, coalesce(t.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=t.pgm_parent_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.pgm_abs_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs2_id) ) primary_thumb_id2 from ( --sqlSubSelect select s.* from (select a.*, rownum rnum from (select --sqlFrom m.* from tmddba.tm_mis m --sqlWhere where media_type>0 and item_type>0 AND PGM_PARENT_ID=:param_0 and m.mi_deleted=0 AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0) order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) s where rnum >= 1) t ) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl order by r.rnum t Verbose: 1220 : 16|08:39:49.2935|jN8bF~|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 : 16|08:39:49.2935|jN8bF~|CJPOWERCAST| timing: 00:00:00.0319155 t Verbose: 1220 : 16|08:39:49.2935|jN8bF~|CJPOWERCAST|imfx v3 API took 0.032s '/api/v3/version/299543/media?_dc=1693208405534' t Transfer: 1220 : 16|08:39:49.2935|jN8bF~|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0156.mp4 subfolder t Transfer: 1220 : 16|08:39:49.2935|jN8bF~|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156.mp4 t Transfer: 1220 : 16|08:39:49.2935|jN8bF~|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156.mp4 t Transfer: 1220 : 16|08:39:49.2935|jN8bF~|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:39:49.2935|jN8bF~|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:39:49.2935|jN8bF~|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 16|08:39:49.2935|jN8bF~|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0156M0002021.mp4 subfolder t Transfer: 1220 : 16|08:39:49.2935|jN8bF~|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156M0002021.mp4 t Transfer: 1220 : 16|08:39:49.2935|jN8bF~|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156M0002021.mp4 t Transfer: 1220 : 16|08:39:49.2935|jN8bF~|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:39:49.2935|jN8bF~|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:39:49.2935|jN8bF~|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 16|08:39:49.2935|jN8bF~|CJPOWERCAST|GetUrl. Storage |Audio| filename \\192.168.120.254\DemoFS\Digital Assets\Audio\gotspecialspromosaudio.wav subfolder t Transfer: 1220 : 16|08:39:49.2935|jN8bF~|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/AudioServer/gotspecialspromosaudio.wav t Transfer: 1220 : 16|08:39:49.2935|jN8bF~|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/AudioServer/gotspecialspromosaudio.wav t Transfer: 1220 : 16|08:39:49.2935|jN8bF~|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:39:49.2935|jN8bF~|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:39:49.2935|jN8bF~|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 16|08:39:49.2935|jN8bF~|CJPOWERCAST|GetUrl. Storage |Audio| filename \\192.168.120.254\DemoFS\Digital Assets\Audio\PMH_portugese - Copy.wav subfolder t Transfer: 1220 : 16|08:39:49.2935|jN8bF~|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/AudioServer/PMH_portugese%20-%20Copy.wav t Transfer: 1220 : 16|08:39:49.2935|jN8bF~|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/AudioServer/PMH_portugese%20-%20Copy.wav t Transfer: 1220 : 16|08:39:49.2935|jN8bF~|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:39:49.2935|jN8bF~|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:39:49.2935|jN8bF~|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 16|08:39:55.6237|tA_~nW|CJPOWERCAST|OAuth: /api/v3/version/299543/media?_dc=1693208411792 t Transfer: 1220 : 16|08:39:55.6237|tA_~nW|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:39:55.6237|tA_~nW|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:39:55.6237|tA_~nW|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 16|08:39:55.6237|tA_~nW|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 16|08:39:55.6237|tA_~nW|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 16|08:39:55.6237|tA_~nW|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:39:55.6237|tA_~nW|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:39:55.6237|tA_~nW|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 16|08:39:55.6237|tA_~nW|CJPOWERCAST|MediaSearch SQL: --sqlFromPaging select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type in (1,110)),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , (SELECT min(status.ACCESS_STATUS_NAME) FROM TMDDBA.TM_ACCESS_STATUS statusLnx, TM_CFG_ACCESS_STATUS status WHERE statusLnx.Media_Id = r.id and statusLnx.Status_Id = status.id) ACCESS_STATUS , (select min(acq.ext_ref) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) CONSIGNMENT_NUMBER , (select min(acq.alt_id1) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) TRANSFER_NUMBER , (select min(crs.series_number) from tm_series_data crs where crs.id = r.GROUP_SERIES_ID) CRS_SERIES , (select min(DISPOSAL_NAME) from TM_ACQ_DISPOSAL status, tm_disposal_records records where status.id = records.disposal_status_id and records.miid = r.id) DISPOSAL_STATUS , (select min(class.class_number) from TM_ACQ_DISPOSAL status, tm_disposal_records records, tm_disposal_classes class where status.id = records.disposal_status_id and records.miid = r.id and class.id = records.disposal_class_id) DISPOSAL_CLASS, (select min(names.concat_search_name) from tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names where r.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY, (select min(c.u_id_ext1) from tmddba.tm_mi_tpi_lnx lnx, tm_ctnrs c where c.u_id = lnx.tpiid and lnx.miid = r.id) U_ID_EXT1 , (select t.name from TM_CFG_MI_FMT_TYP t where t.id = r.mi_fmt_type) ITEM_FORMAT_TEXT, CASE WHEN BITAND(r.COMPIL, 2) = 2 THEN 'SUPPLIED' WHEN BITAND(r.COMPIL, 4) = 4 THEN 'MADE' WHEN BITAND(r.COMPIL, 134217728) = 134217728 THEN 'IMPORTED' ELSE '' END AS ORIGIN, CASE WHEN BITAND(r.COMPIL, 512) = 512 THEN 'Attached' WHEN BITAND(r.COMPIL, 1024) = 1024 THEN 'Un-Attached' ELSE '' END AS FLAGS, (select min(lang.full_name) from TM_PG_RL_LANG_LNX lnx, TM_LANG_DATA lang where lnx.tm_pg_rl_id = r.pgm_parent_id and lnx.lang_id = lang.id) AS PROD_LANGUAGE , (select min(ctx.ITFC_CODE) from tm_mis mis, tm_mi_tpi_lnx links, tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names where mis.id = r.id and links.miid = mis.id and mis.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY_NUMBER, (select min(status.description) from TM_CFG_PGM_STATUS status where r.status = status.id) PGM_STATUS_TEXT, (select min(ver.DUR) from TM_PG_RL ver where r.pgm_PARENT_ID = ver.id) AS VERSION_DUR , (select tmd_str_agg_pipe(cms.status_type_id ||',' ||cms.status_id) from tm_mi_cust_med_stat_lnx cms where cms.media_id=r.id) "CustomStatusesRaw", (select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = r.net_grp_id) CHANNEL_GROUP, (SELECT SUBSTR( trim( replace (replace ( LISTAGG(trim(tt.tags || ' ' || tt.notes), ' ') WITHIN GROUP (ORDER BY trim(tt.tags || ' ' || tt.notes)), chr (13), ''), chr (10), ' ')), 1, 150) z FROM tm_media_tagging tt WHERE link_guid = DFILE_LINK_GUID and rownum=1) TAGS_TEXT , GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select t.*, coalesce(t.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=t.pgm_parent_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.pgm_abs_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs2_id) ) primary_thumb_id2 from ( --sqlSubSelect select s.* from (select a.*, rownum rnum from (select --sqlFrom m.* from tmddba.tm_mis m --sqlWhere where media_type>0 and item_type>0 AND PGM_PARENT_ID=:param_0 and m.mi_deleted=0 AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0) order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) s where rnum >= 1) t ) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl order by r.rnum t Verbose: 1220 : 16|08:39:55.6237|tA_~nW|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 : 16|08:39:55.6237|tA_~nW|CJPOWERCAST| timing: 00:00:00.0341278 t Verbose: 1220 : 16|08:39:55.6237|tA_~nW|CJPOWERCAST|imfx v3 API took 0.034s '/api/v3/version/299543/media?_dc=1693208411792' t Transfer: 1220 : 16|08:39:55.6237|tA_~nW|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0156.mp4 subfolder t Transfer: 1220 : 16|08:39:55.6237|tA_~nW|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156.mp4 t Transfer: 1220 : 16|08:39:55.6237|tA_~nW|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156.mp4 t Transfer: 1220 : 16|08:39:55.6237|tA_~nW|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:39:55.6237|tA_~nW|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:39:55.6237|tA_~nW|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 16|08:39:55.6237|tA_~nW|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0156M0002021.mp4 subfolder t Transfer: 1220 : 16|08:39:55.6237|tA_~nW|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156M0002021.mp4 t Transfer: 1220 : 16|08:39:55.6237|tA_~nW|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156M0002021.mp4 t Transfer: 1220 : 16|08:39:55.6237|tA_~nW|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:39:55.6237|tA_~nW|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:39:55.6237|tA_~nW|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 16|08:39:55.6237|tA_~nW|CJPOWERCAST|GetUrl. Storage |Audio| filename \\192.168.120.254\DemoFS\Digital Assets\Audio\gotspecialspromosaudio.wav subfolder t Transfer: 1220 : 16|08:39:55.6237|tA_~nW|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/AudioServer/gotspecialspromosaudio.wav t Transfer: 1220 : 16|08:39:55.6237|tA_~nW|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/AudioServer/gotspecialspromosaudio.wav t Transfer: 1220 : 16|08:39:55.6237|tA_~nW|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:39:55.6237|tA_~nW|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:39:55.6237|tA_~nW|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 16|08:39:55.6237|tA_~nW|CJPOWERCAST|GetUrl. Storage |Audio| filename \\192.168.120.254\DemoFS\Digital Assets\Audio\PMH_portugese - Copy.wav subfolder t Transfer: 1220 : 16|08:39:55.6237|tA_~nW|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/AudioServer/PMH_portugese%20-%20Copy.wav t Transfer: 1220 : 16|08:39:55.6237|tA_~nW|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/AudioServer/PMH_portugese%20-%20Copy.wav t Transfer: 1220 : 16|08:39:55.6237|tA_~nW|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 16|08:39:55.6237|tA_~nW|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 16|08:39:55.6237|tA_~nW|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 16|13:48:43.1879|||OrabitWatcherBasic. Disposing. t Information: 1220 : 16|13:48:43.1879|||OrabitWatcherBasic. Disposed. t Information: 1220 : 16|13:48:43.1879|||========================================================================== t Information: 1220 : 16|13:48:43.1879|||IMFX CORE SERVER APPLICATION END.