t Information: 1220 : 10|06:04:55.5648|||Get Configuration Values: t Information: 1220 : 10|06:04:55.5658||| AdminPassEnc, default: , value: ffqjrn0leKv4Lj2YJHe2dw==. t Information: 1220 : 10|06:04:55.5658||| EncryptedPasswords, default: false, value: true. t Information: 1220 : 10|06:04:55.5658||| OraConnectionString, default: , value: Server=TECHM;User Id=imfx;Password=xxxxx;Unicode=true;. t Information: 1220 : 10|06:04:55.5658||| SecondTimezone, default: , value: . t Information: 1220 : 10|06:04:55.5667||| UseActiveDirectoryAuth, default: false, value: false. t Information: 1220 : 10|06:04:55.5667||| ReportingServiceUrl, default: , value: http://localhost:92/ReportingService.svc. t Information: 1220 : 10|06:04:55.5677||| ReportsPath, default: , value: . t Information: 1220 : 10|06:04:55.5677||| ReportsURL, default: , value: . t Information: 1220 : 10|06:04:55.5677||| TapeServiceUrl, default: , value: . t Information: 1220 : 10|06:04:55.5677||| GatekeeperUrl, default: , value: . t Information: 1220 : 10|06:04:55.5688||| ValuationUrl, default: , value: . t Information: 1220 : 10|06:04:55.5688||| QueueManagerDelay, default: 30, value: 30. t Information: 1220 : 10|06:04:55.5688||| QueueManagerFullRefresh, default: 90, value: 90. t Information: 1220 : 10|06:04:55.5688||| AudioLoopDuration, default: 0, value: 150. t Information: 1220 : 10|06:04:55.5688||| AudioLoopsCount, default: 0, value: 0. t Information: 1220 : 10|06:04:55.5688||| PlayerFakeStep, default: 500, value: 500. t Information: 1220 : 10|06:04:55.5688||| PlayerForceRatio, default: 0, value: 1. t Information: 1220 : 10|06:04:55.5688||| CheckVersionsInProd, default: false, value: True. t Information: 1220 : 10|06:04:55.5698||| MaxResults, default: 3000, value: 10000. t Information: 1220 : 10|06:04:55.5698||| TEReportID, default: 0, value: 0. t Information: 1220 : 10|06:04:55.5698||| ClosedCaptionsCache, default: , value: C:\inetpub\wwwroot\imfxcore\timedtextcache\. t Information: 1220 : 10|06:04:55.5698||| ClosedCaptionsStorage, default: , value: c:\Mediaflex\subs. t Information: 1220 : 10|06:04:55.5698||| TimeCodeFormat, default: , value: pal. t Information: 1220 : 10|06:04:55.5698||| RceMediaPath, default: , value: C:\edl\. t Information: 1220 : 10|06:04:55.5698||| RceMediaPath, default: , value: C:\edl\. t Information: 1220 : 10|06:04:55.5708||| RceCsmOutputPath, default: , value: C:\Inetpub\wwwroot\csm\. t Information: 1220 : 10|06:04:55.5708||| RceCsmUrl, default: , value: http://localhost/csm/. t Information: 1220 : 10|06:04:55.5708||| RceMediaSelection, default: , value: miLinkIdMatch. t Information: 1220 : 10|06:04:55.5708||| RequestBrowseJobPresetName, default: , value: . t Information: 1220 : 10|06:04:55.5708||| DontExtendDuration, default: false, value: False. t Information: 1220 : 10|06:04:55.5708||| V3ConfigUrl, default: , value: . t Information: 1220 : 10|06:04:55.5708||| StopWords, default: , value: . t Information: 1220 : 10|06:04:55.5708||| MisrTxFormat, default: G, value: G. t Information: 1220 : 10|06:04:55.5718||| ApiServer, default: , value: http://192.168.120.10:85. t Information: 1220 : 10|06:04:55.5718||| ApiTimeout, default: 120, value: 120. t Information: 1220 : 10|06:04:55.5718||| ApiWorkers, default: 10, value: 10. t Information: 1220 : 10|06:04:55.5718||| UsePerfCounters, default: false, value: false. t Information: 1220 : 10|06:04:55.5718||| LogGetCurrentUser, default: true, value: true. t Information: 1220 : 10|06:04:55.5718||| LogInternalApi, default: true, value: true. t Information: 1220 : 10|06:04:55.5718||| LivePlayApiUrl, default: , value: . t Information: 1220 : 10|06:04:55.5728||| LivePlayApiTimeout, default: 120, value: 120. t Information: 1220 : 10|06:04:55.5728||| ThumbnailServer, default: , value: . t Information: 1220 : 10|06:04:55.5728||| PasswordResetEmailTemplateId, default: 0, value: 0. t Information: 1220 : 10|06:04:55.5728||| PasswordResetEmailTemplateId_MediaPortal, default: 0, value: 0. t Information: 1220 : 10|06:04:55.5728||| imfxBaseUrl, default: , value: . t Information: 1220 : 10|06:04:55.5728||| imfxBaseUrl_MediaPortal, default: , value: . t Information: 1220 : 10|06:04:55.5738||| imfxBaseUrl_VideoBrowser, default: , value: . t Information: 1220 : 10|06:04:55.5738||| ShowDetailedErrors, default: false, value: false. t Information: 1220 : 10|06:04:55.5738||| AllowXmlRequests, default: false, value: false. t Information: 1220 : 10|06:04:55.5738||| MaxLoginAttempts, default: 3, value: 3. t Information: 1220 : 10|06:04:55.5738||| MaxLoginAttemptsPeriod, default: 15, value: 15. t Information: 1220 : 10|06:04:55.5738||| LocationFilter, default: , value: . t Information: 1220 : 10|06:04:55.5748||| SvUtilServiceUrl, default: , value: . t Information: 1220 : 10|06:04:55.5748||| SolrConnection, default: , value: http://192.168.120.14:8983/solr. t Information: 1220 : 10|06:04:55.5758||| UseIndexServerSearch, default: false, value: True. t Information: 1220 : 10|06:04:55.5758||| SolrIndexVersion, default: 1, value: 6. t Information: 1220 : 10|06:04:55.5758||| SolrConnection, default: , value: http://192.168.120.14:8983/solr. t Information: 1220 : 10|06:04:55.5758||| FacetsGroups, default: , value: owners,season_id, series_id,version_key,item_type,media_type,media_format,episode_number. t Information: 1220 : 10|06:04:55.5758||| FacetsGroupsVersion, default: , value: owners,season_id, series_id,version_key,episode_number. t Information: 1220 : 10|06:04:55.5758||| FacetsGroupsChameleon, default: , value: season_id, series_id,genre,prod_year,version_key. t Information: 1220 : 10|06:04:55.5768||| PreviewPreset, default: , value: . t Information: 1220 : 10|06:04:55.5768||| DevMode, default: false, value: false. t Information: 1220 : 10|06:04:55.5768||| DisableSysMan, default: false, value: false. t Information: 1220 : 10|06:04:55.5768||| TimeCodeFormat, default: , value: pal. t Information: 1220 : 10|06:04:55.5768||| FileCatalystStorageDevice, default: , value: . t Information: 1220 : 10|06:04:55.5768||| UseResponsibilityTracking, default: true, value: True. t Information: 1220 : 10|06:04:55.5768||| SubtitleDeviceFilter, default: , value: . t Information: 1220 : 10|06:04:55.5778||| SystemMonitorNamedPipe, default: , value: . t Information: 1220 : 10|06:04:55.5778||| OracleMonitorEnable, default: false, value: False. t Information: 1220 : 10|06:04:55.5778||| ArcApiHost, default: , value: . t Information: 1220 : 10|06:04:55.5778||| SolrTimedTextSearch, default: false, value: false. t Information: 1220 : 10|06:04:55.5778||| ProductionDurationUsageID, default: 1, value: 1. t Information: 1220 : 10|06:04:55.5778||| MediaFacetOrder, default: ResultCountAsc, value: ResultCountAsc. t Information: 1220 : 10|06:04:55.5918||| VersionFacetOrder, default: ResultCountAsc, value: ResultCountAsc. t Information: 1220 : 10|06:04:55.9937|||GetStreamServers.. t Information: 1220 : 10|06:04:56.3957||| https://demo.tmd.tv/CBR Video/ |CBR Video| False t Information: 1220 : 10|06:04:56.3957||| https://demo.tmd.tv/CBR Images/ |CBR Images| False t Information: 1220 : 10|06:04:56.3957||| https://demo.tmd.tv/CBR Audio/ |CBR Audio| False t Information: 1220 : 10|06:04:56.3968||| https://demo.tmd.tv/Temp Upload/ |TEMP_UPLOAD| False t Information: 1220 : 10|06:04:56.3968||| http://localhost:82/images/ |IMAGES| False t Information: 1220 : 10|06:04:56.3968||| http://192.168.91.73/smoothcloud/ |SMOOTH_CLOUD| False t Information: 1220 : 10|06:04:56.3968||| http://192.168.91.73/cloudstore/ |CLOUD_STORE| False t Information: 1220 : 10|06:04:56.3968||| http://192.168.91.73/editsystemin/ |EDIT_SYSTEM_IN| False t Information: 1220 : 10|06:04:56.3968||| http://192.168.91.27:89/APPLEPROXY/ |APPLE_PROXY| False t Information: 1220 : 10|06:04:56.3978||| http://localhost:82/video/ |FILESTORE_VIDEO| False t Information: 1220 : 10|06:04:56.3978||| https://imfxv3tm.tmd.tv/streaming/ |Streaming| False t Information: 1220 : 10|06:04:56.3978||| https://imfxv3tm.tmd.tv/VideoServer/ |Video| False t Information: 1220 : 10|06:04:56.3978||| https://imfxv3tm.tmd.tv/Proxy/ |Proxy| False t Information: 1220 : 10|06:04:56.3978||| https://imfxv3tm.tmd.tv/AdobeIn/ |Adobe Premiere Pro In| False t Information: 1220 : 10|06:04:56.3978||| https://imfxv3tm.tmd.tv/AudioServer/ |Audio| False t Information: 1220 : 10|06:04:56.3978||| https://imfxv3tm.tmd.tv/ImageServer/ |Image| False t Information: 1220 : 10|06:04:56.3978||| https://imfxv3tm.tmd.tv/DocsServer/ |Docs| False t Information: 1220 : 10|06:04:56.3978||| https://imfxv3tm.tmd.tv/AmazonLabs/ |TEST HOUSE| False t Information: 1220 : 10|06:04:56.3978||| SolrConnectionUms, default: http://192.168.120.14:8983/solr, value: http://192.168.120.14:8983/solr. t Information: 1220 : 10|06:04:56.3988||| LogWebApi, default: false, value: false. t Information: 1220 : 10|06:04:56.3988||| EmbeddedRceUrl, default: , value: . t Information: 1220 : 10|06:04:56.3988||| InstallMode, default: , value: . t Information: 1220 : 10|06:04:56.3988||| SamlRequestAddress, default: , value: . t Information: 1220 : 10|06:04:56.3988||| SamlTrustedIssuer, default: , value: . t Information: 1220 : 10|06:04:56.3988||| SamlLoginRedirect, default: , value: . t Information: 1220 : 10|06:04:56.3988||| NaturalLangSearch, default: false, value: True. t Information: 1220 : 10|06:04:56.3988||| LocalUploadExpirationHours, default: 0, value: 0. t Information: 1220 : 10|06:04:56.3988||| LocalUploadDeviceId, default: 0, value: 0. t Information: 1220 : 10|06:04:56.3988||| VideosFileFormatIds, default: , value: . t Information: 1220 : 10|06:04:56.3988||| VideosStorageIds, default: , value: . t Information: 1220 : 10|06:04:56.3998||| OktaLoginField, default: , value: . t Information: 1220 : 10|06:04:56.3998||| AuthenticationTypes, default: , value: Native,PublicApiKey. t Information: 1220 : 10|06:04:56.3998|||OrabitWatcherBasic. Initialize. t Information: 1220 : 10|06:04:56.6008|||FillDictionaryCache. t Information: 1220 : 10|06:05:00.6208|||GetSupportedOperators t Information: 1220 : 10|06:05:01.0227|||CacheTechReports. t Information: 1220 : 10|06:05:01.2237|||& Cache update. Server (global) filled with timestamp 06:11:01.1458003. types null t Information: 1220 : 10|06:05:01.4498|||InitializeFromDatabase. 'Server=TECHM;User Id=imfx;password=..;Unicode=true;' direct False, home , timeout 15 t Information: 1220 : 10|06:05:01.4498|||FillDictionaryCache. t Information: 1220 : 10|06:05:01.4498|||& Cache update. Server (global) filled with timestamp 06:11:01.2737951. types FriendlyNames, DatabaseSearchFieldData t Information: 1220 : 10|06:05:01.4498|||OrabitWatcherBasic trying to connect.. t Information: 1220 : 10|06:05:01.6508|||OrabitWatcherBasic connected. t Information: 1220 : 10|06:05:01.6508|||OrabitWatcherBasic queue created tmd.cfg.in.1524ce62-c0c8-4472-b8e7-2e848d2e59f6 t Information: 1220 : 10|06:05:01.8518|||========================================================================== t Information: 1220 : 10|06:05:01.8518|||IMFX CORE SERVER APPLICATION START. t Information: 1220 : 10|06:05:01.8518|||DLL VERSION: 3.0.0.970. t Information: 1220 : 10|06:05:01.8518|||IS TIMER HIGH RESOLUTION : True. t Information: 1220 : 10|06:05:01.8527||| UmsDev, default: False, value: False. t Transfer: 1220 : 10|08:02:59.3837|t8Q_ot||GetAppInfo. DB: TMDDEMO. Install mode: . Auth types: Native, PublicApiKey t Information: 1220 : 10|08:02:59.9867|HP_GBQ||GetCache. t Information: 1220 : 10|08:02:59.9867|HP_GBQ||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\108_2_PnqJC_.png t Information: 1220 : 10|08:02:59.9867|HP_GBQ||GetCache. Data read: 154944 t Verbose: 1220 : 10|08:02:59.9867|HP_GBQ||imfx v3 API took 0.072s '/api/v3/visual-asset/group/PnqJC_/2/image' t Verbose: 1220 : 10|08:03:15.4637|6Lw55P||Oauth validating.. t Verbose: 1220 : 10|08:03:15.4637|6Lw55P||GrantResourceOwnerCredentials. t Verbose: 1220 : 10|08:03:15.4637|6Lw55P||LoginUser. cjpowercast, login type OAuth, encrypt password True t Information: 1220 : 10|08:03:15.4637|6Lw55P||TryLoginUser. cjpowercast, login type OAuth, check password True, check hash False, encrypt password True, load user data False t Information: 1220 : 10|08:03:15.8657|6Lw55P|| oauth token 00000000-0000-0000-0000-000000000000 t Information: 1220 : 10|08:03:15.8657|6Lw55P||TryLoginUser. Logged in.. t Information: 1220 : 10|08:03:15.8657|6Lw55P||GetPasswordPolicy. WARNING: Policy not found for system Imediaflex. Validation disabled. t Verbose: 1220 : 10|08:03:15.8657|6Lw55P||LoginUser. Adding history. User Id 1165, result CJPOWERCAST, host 192.168.127.6 t Verbose: 1220 : 10|08:03:15.8657|6Lw55P||GrantResourceOwnerCredentials. Try login finished. Logged: True t Transfer: 1220 : 10|08:03:16.4687|mwx4iu|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=1669190594678 t Transfer: 1220 : 10|08:03:16.4687|mwx4iu|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:16.4687|mwx4iu|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:16.4687|mwx4iu|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:03:16.4687|mwx4iu|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|08:03:16.4687|mwx4iu|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:16.4687|mwx4iu|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:16.4687|mwx4iu|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:03:16.4697|mwx4iu|CJPOWERCAST|imfx v3 API took 0.047s '/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=1669190594678' t Transfer: 1220 : 10|08:03:16.6707|MvPGow|CJPOWERCAST|OAuth: /api/user-preferences?keys=personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch;workflow_queues_actions;workflow_queues_settings&_dc=1669190595046 t Transfer: 1220 : 10|08:03:16.6707|MvPGow|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:16.6707|MvPGow|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:16.6707|MvPGow|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:03:16.6707|MvPGow|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|08:03:16.6707|MvPGow|CJPOWERCAST|GetUserDataByKeys: personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch;workflow_queues_actions;workflow_queues_settings t Transfer: 1220 : 10|08:03:16.6707|MvPGow|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:16.6707|MvPGow|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:16.6707|MvPGow|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:03:16.8727|MvPGow|CJPOWERCAST|imfx v3 API took 0.048s '/api/user-preferences?keys=personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch;workflow_queues_actions;workflow_queues_settings&_dc=1669190595046' t Information: 1220 : 10|08:03:17.0737|PGSyMj|CJPOWERCAST|GetUserProfile. Id: 0 t Transfer: 1220 : 10|08:03:17.0737|PGSyMj|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:17.0737|PGSyMj|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:17.0737|PGSyMj|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:03:17.4757|htACFV|CJPOWERCAST|OAuth: /api/settings/group/0?_dc=1669190595760 t Transfer: 1220 : 10|08:03:17.4757|htACFV|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:17.4767|htACFV|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:17.4767|htACFV|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:03:17.4767|htACFV|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|08:03:17.4767|w6PkSP|CJPOWERCAST|OAuth: /api/settings/user/uploadSettings?_dc=1669190595766 t Transfer: 1220 : 10|08:03:17.4777|w6PkSP|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:17.4777|w6PkSP|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:17.4777|w6PkSP|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:03:17.4777|w6PkSP|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|08:03:17.4777|w6PkSP|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:17.4777|w6PkSP|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:17.4777|w6PkSP|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:03:17.4787|yOn2VR|CJPOWERCAST|OAuth: /api/settings/group/0?_dc=1669190595781 t Transfer: 1220 : 10|08:03:17.4787|yOn2VR|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:17.4787|yOn2VR|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:17.4787|yOn2VR|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:03:17.4787|yOn2VR|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|08:03:17.4787|5pQXDu|CJPOWERCAST|OAuth: /api/lookups/MediaStatus?_dc=1669190595787 t Transfer: 1220 : 10|08:03:17.4787|5pQXDu|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:17.4797|5pQXDu|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:17.4797|5pQXDu|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:03:17.4797|5pQXDu|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 10|08:03:17.4797|w6PkSP|CJPOWERCAST|imfx v3 API took 0.086s '/api/settings/user/uploadSettings?_dc=1669190595766' t Verbose: 1220 : 10|08:03:17.6807|5pQXDu|CJPOWERCAST|imfx v3 API took 0.045s '/api/lookups/MediaStatus?_dc=1669190595787' t Information: 1220 : 10|08:03:17.6807|U0adrv||GetCache. t Information: 1220 : 10|08:03:17.6807|U0adrv||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\201_0_Any_gO.png t Information: 1220 : 10|08:03:17.6807|U0adrv||GetCache. Data read: 0 t Verbose: 1220 : 10|08:03:17.6807|U0adrv||imfx v3 API took 0.151s '/api/v3/visual-asset/group/Any_gO/0/image' t Verbose: 1220 : 10|08:03:17.8817|htACFV|CJPOWERCAST|imfx v3 API took 0.395s '/api/settings/group/0?_dc=1669190595760' t Verbose: 1220 : 10|08:03:17.8817|yOn2VR|CJPOWERCAST|imfx v3 API took 0.226s '/api/settings/group/0?_dc=1669190595781' t Transfer: 1220 : 10|08:03:17.8817|y8zCOC|CJPOWERCAST|OAuth: /api/lookups/PgmStatus?_dc=1669190595788 t Transfer: 1220 : 10|08:03:17.8817|y8zCOC|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:17.8817|y8zCOC|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:17.8817|y8zCOC|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:03:17.8817|y8zCOC|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|08:03:17.8817|EahS8c|CJPOWERCAST|OAuth: /api/lookup/CustomMediaStatusTypes?_dc=1669190595789 t Transfer: 1220 : 10|08:03:17.8817|EahS8c|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:17.8817|EahS8c|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:17.8827|EahS8c|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:03:17.8827|EahS8c|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 10|08:03:17.8827|y8zCOC|CJPOWERCAST|imfx v3 API took 0.000s '/api/lookups/PgmStatus?_dc=1669190595788' t Transfer: 1220 : 10|08:03:17.8827|VbT~IR|CJPOWERCAST|OAuth: /api/lookup/CustomVersionStatusTypes?_dc=1669190595789 t Transfer: 1220 : 10|08:03:17.8827|VbT~IR|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:17.8827|VbT~IR|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:17.8827|VbT~IR|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:03:17.8827|VbT~IR|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 10|08:03:18.0837|EahS8c|CJPOWERCAST|imfx v3 API took 0.013s '/api/lookup/CustomMediaStatusTypes?_dc=1669190595789' t Verbose: 1220 : 10|08:03:18.0837|VbT~IR|CJPOWERCAST|imfx v3 API took 0.009s '/api/lookup/CustomVersionStatusTypes?_dc=1669190595789' t Transfer: 1220 : 10|08:03:18.0837|9Mm0tY|CJPOWERCAST|OAuth: /api/lookup/CustomTitleStatusTypes?_dc=1669190595790 t Transfer: 1220 : 10|08:03:18.0837|9Mm0tY|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:18.0837|9Mm0tY|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:18.0837|9Mm0tY|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:03:18.0837|9Mm0tY|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 10|08:03:18.0837|9Mm0tY|CJPOWERCAST|imfx v3 API took 0.008s '/api/lookup/CustomTitleStatusTypes?_dc=1669190595790' t Transfer: 1220 : 10|08:03:18.2847|KBgHiE|CJPOWERCAST|OAuth: /api/settings/user/defaultHomePage?_dc=1669190595790 t Transfer: 1220 : 10|08:03:18.2847|KBgHiE|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:18.2847|KBgHiE|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:18.2847|KBgHiE|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:03:18.2847|KBgHiE|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|08:03:18.2847|KBgHiE|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:18.2847|KBgHiE|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:18.2847|KBgHiE|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|08:03:18.2847|vIFUnJ||GetCache. t Information: 1220 : 10|08:03:18.2847|vIFUnJ||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\202_1_Any_gO.png t Information: 1220 : 10|08:03:18.2858|vIFUnJ||GetCache. Data read: 0 t Verbose: 1220 : 10|08:03:18.2858|vIFUnJ||imfx v3 API took 0.005s '/api/v3/visual-asset/group/Any_gO/1/image' t Verbose: 1220 : 10|08:03:18.2858|KBgHiE|CJPOWERCAST|imfx v3 API took 0.012s '/api/settings/user/defaultHomePage?_dc=1669190595790' t Transfer: 1220 : 10|08:03:20.0948|Ql~aou|CJPOWERCAST|OAuth: /api/settings/user/startSearch?_dc=1669190598328 t Transfer: 1220 : 10|08:03:20.0948|jego2b|CJPOWERCAST|OAuth: /api/settings/user/defaultSearch?_dc=1669190598327 t Transfer: 1220 : 10|08:03:20.0948|Ql~aou|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:20.0948|jego2b|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:20.0948|Ql~aou|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:20.0948|jego2b|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:20.0948|jego2b|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:03:20.0948|Ql~aou|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:03:20.0957|Ql~aou|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 10|08:03:20.0957|jego2b|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|08:03:20.0957|jego2b|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:20.0957|jego2b|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:20.0957|jego2b|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:03:20.0957|Ql~aou|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:20.0957|Ql~aou|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:20.0957|Ql~aou|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:03:20.0957|Ql~aou|CJPOWERCAST|imfx v3 API took 0.015s '/api/settings/user/startSearch?_dc=1669190598328' t Verbose: 1220 : 10|08:03:20.0957|jego2b|CJPOWERCAST|imfx v3 API took 0.018s '/api/settings/user/defaultSearch?_dc=1669190598327' t Information: 1220 : 10|08:03:20.2967|RUiAVW||GetCache. t Information: 1220 : 10|08:03:20.2967|RUiAVW||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\204_3_Any_gO.png t Information: 1220 : 10|08:03:20.2967|RUiAVW||GetCache. Data read: 5504 t Verbose: 1220 : 10|08:03:20.2967|RUiAVW||imfx v3 API took 0.006s '/api/v3/visual-asset/group/Any_gO/3/image' t Transfer: 1220 : 10|08:03:20.2967|9xGStD|CJPOWERCAST|OAuth: /api/user-preferences?keys=consumer.recent.data&_dc=1669190598631 t Transfer: 1220 : 10|08:03:20.2967|9xGStD|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:20.2967|9xGStD|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:20.2967|9xGStD|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:03:20.2967|9xGStD|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|08:03:20.2967|9xGStD|CJPOWERCAST|GetUserDataByKeys: consumer.recent.data t Transfer: 1220 : 10|08:03:20.2977|9xGStD|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:20.2977|9xGStD|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:20.2977|9xGStD|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:03:20.2977|XysUYr|CJPOWERCAST|OAuth: /api/user-preferences?keys=adv.recent.searches.consumer&_dc=1669190598636 t Transfer: 1220 : 10|08:03:20.2977|XysUYr|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:20.2977|XysUYr|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:20.2977|XysUYr|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:03:20.2977|XysUYr|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 10|08:03:20.2977|9xGStD|CJPOWERCAST|imfx v3 API took 0.007s '/api/user-preferences?keys=consumer.recent.data&_dc=1669190598631' t Information: 1220 : 10|08:03:20.2977|XysUYr|CJPOWERCAST|GetUserDataByKeys: adv.recent.searches.consumer t Transfer: 1220 : 10|08:03:20.2977|XysUYr|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:20.2977|XysUYr|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:20.2987|XysUYr|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:03:20.2987|XysUYr|CJPOWERCAST|imfx v3 API took 0.007s '/api/user-preferences?keys=adv.recent.searches.consumer&_dc=1669190598636' t Transfer: 1220 : 10|08:03:24.5197|N0p9_Y|CJPOWERCAST|OAuth: /api/lookups/SearchSupportedOperators?_dc=1669190602778 t Transfer: 1220 : 10|08:03:24.5197|N0p9_Y|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:24.5197|N0p9_Y|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:24.5197|N0p9_Y|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:03:24.5197|N0p9_Y|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|08:03:24.5197|rW94qF|CJPOWERCAST|OAuth: /api/user-preferences?keys=adv.recent.searches.media&_dc=1669190602779 t Transfer: 1220 : 10|08:03:24.5197|rW94qF|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:24.5197|rW94qF|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:24.5197|rW94qF|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:03:24.5207|rW94qF|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|08:03:24.5207|RZYsHE|CJPOWERCAST|OAuth: /api/view/searchinfo/Media?_dc=1669190602776 t Transfer: 1220 : 10|08:03:24.5207|RZYsHE|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:24.5207|RZYsHE|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:24.5207|RZYsHE|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:03:24.5207|RZYsHE|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|08:03:24.5207|rW94qF|CJPOWERCAST|GetUserDataByKeys: adv.recent.searches.media t Transfer: 1220 : 10|08:03:24.5207|rW94qF|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:24.5207|rW94qF|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:24.5207|rW94qF|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:03:24.5207|N0p9_Y|CJPOWERCAST|imfx v3 API took 0.000s '/api/lookups/SearchSupportedOperators?_dc=1669190602778' t Information: 1220 : 10|08:03:24.5217|RZYsHE|CJPOWERCAST|GetAdvSearchColumns. search type Media grid . t Verbose: 1220 : 10|08:03:24.5217|RZYsHE|CJPOWERCAST|imfx v3 API took 0.001s '/api/view/searchinfo/Media?_dc=1669190602776' t Verbose: 1220 : 10|08:03:24.5217|rW94qF|CJPOWERCAST|imfx v3 API took 0.007s '/api/user-preferences?keys=adv.recent.searches.media&_dc=1669190602779' t Transfer: 1220 : 10|08:03:24.5217|WlokLq|CJPOWERCAST|OAuth: /api/view/searches/Media?_dc=1669190602837 t Transfer: 1220 : 10|08:03:24.5217|WlokLq|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:24.5217|WlokLq|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:24.5217|WlokLq|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:03:24.5217|WlokLq|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|08:03:24.5217|3ztn4r|CJPOWERCAST|OAuth: /api/view/info/MediaGrid?lang=en-GB&_dc=1669190602842 t Transfer: 1220 : 10|08:03:24.5217|3ztn4r|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:24.5217|3ztn4r|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:24.5217|3ztn4r|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:03:24.5227|3ztn4r|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|08:03:24.5227|WlokLq|CJPOWERCAST|GetSavedSearchNames. search type Media. t Transfer: 1220 : 10|08:03:24.5227|WlokLq|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:24.5227|WlokLq|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:24.5227|WlokLq|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:03:24.5227|2G6qR1|CJPOWERCAST|OAuth: /api/settings/user/searchLayoutConfig?_dc=1669190602843 t Transfer: 1220 : 10|08:03:24.5227|2G6qR1|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:24.5227|2G6qR1|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:24.5227|2G6qR1|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:03:24.5227|2G6qR1|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|08:03:24.5227|3ztn4r|CJPOWERCAST|GetGridViewBuilder. builder type MediaGrid. t Transfer: 1220 : 10|08:03:24.5237|2G6qR1|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:24.5237|2G6qR1|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:24.5237|2G6qR1|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:03:24.5237|3ztn4r|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:24.5237|3ztn4r|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:24.5237|3ztn4r|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:03:24.5237|2G6qR1|CJPOWERCAST|imfx v3 API took 0.008s '/api/settings/user/searchLayoutConfig?_dc=1669190602843' t Information: 1220 : 10|08:03:24.5247|3ztn4r|CJPOWERCAST|UserGridView. LoadView. ID -2, Name Default. t Transfer: 1220 : 10|08:03:24.5247|3ztn4r|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:24.5247|3ztn4r|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:24.5247|3ztn4r|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:03:24.5247|WlokLq|CJPOWERCAST|imfx v3 API took 0.060s '/api/view/searches/Media?_dc=1669190602837' t Transfer: 1220 : 10|08:03:24.5247|3ztn4r|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:24.5247|3ztn4r|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:24.5257|3ztn4r|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:03:24.7267|3ztn4r|CJPOWERCAST|imfx v3 API took 0.100s '/api/view/info/MediaGrid?lang=en-GB&_dc=1669190602842' t Transfer: 1220 : 10|08:03:29.1488|nHuBjx|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1669190607523 t Transfer: 1220 : 10|08:03:29.1488|nHuBjx|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:29.1488|nHuBjx|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:29.1488|nHuBjx|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:03:29.1488|nHuBjx|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|08:03:29.3497|nHuBjx|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:29.3497|nHuBjx|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:29.3497|nHuBjx|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:03:29.3497|yIg1bO|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1669190607649 t Transfer: 1220 : 10|08:03:29.3497|yIg1bO|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:29.3497|yIg1bO|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:29.3507|yIg1bO|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:03:29.3507|yIg1bO|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|08:03:29.3507|yIg1bO|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:29.3507|yIg1bO|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:29.3507|yIg1bO|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:03:29.7528|4T7dzn|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1669190607981 t Transfer: 1220 : 10|08:03:29.7528|4T7dzn|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:29.7528|4T7dzn|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:29.7528|4T7dzn|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:03:29.7528|4T7dzn|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|08:03:29.7528|4T7dzn|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:29.7528|4T7dzn|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:29.7528|4T7dzn|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:03:29.7528|yIg1bO|CJPOWERCAST|imfx v3 API took 0.396s '/api/v3/search-suggestion/?_dc=1669190607649' t Verbose: 1220 : 10|08:03:29.7537|4T7dzn|CJPOWERCAST|imfx v3 API took 0.097s '/api/v3/search-suggestion/?_dc=1669190607981' t Verbose: 1220 : 10|08:03:29.7537|nHuBjx|CJPOWERCAST|imfx v3 API took 0.481s '/api/v3/search-suggestion/?_dc=1669190607523' t Transfer: 1220 : 10|08:03:31.9647|2dg~6b|CJPOWERCAST|OAuth: /api/v3/search/Media?_dc=1669190610363 t Transfer: 1220 : 10|08:03:31.9647|2dg~6b|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:31.9647|2dg~6b|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:31.9647|2dg~6b|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:03:31.9647|2dg~6b|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|08:03:32.1657|2dg~6b|CJPOWERCAST|V3Api.SearchMedia t Information: 1220 : 10|08:03:32.1657|2dg~6b|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 10|08:03:32.1657|2dg~6b|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:32.1657|2dg~6b|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:32.1657|2dg~6b|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|08:03:32.3667|2dg~6b|CJPOWERCAST|Running solr search: [q, (((title:(*))^2 OR series:(*) OR ((filename:(*) OR filename:(*.*)) OR filename:"*") OR (titleMergedNgram:**)^10 OR miid1:(*) OR miid2:(*) OR versionid1:(*) OR progid1:(*)) AND deleted_flag:(0) AND (owners:((SFP2) OR (PSP) OR (PMS) OR (SFP1) OR (PMH) OR (PPL))))] t Information: 1220 : 10|08:03:32.3667|2dg~6b|CJPOWERCAST|Solr query returned: 351 in 85ms t Information: 1220 : 10|08:03:32.3667|2dg~6b|CJPOWERCAST|MediaSearch SQL: select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type in (1,110)),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , (SELECT min(status.ACCESS_STATUS_NAME) FROM TMDDBA.TM_ACCESS_STATUS statusLnx, TM_CFG_ACCESS_STATUS status WHERE statusLnx.Media_Id = r.id and statusLnx.Status_Id = status.id) ACCESS_STATUS , (select min(acq.ext_ref) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) CONSIGNMENT_NUMBER , (select min(acq.alt_id1) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) TRANSFER_NUMBER , (select min(crs.series_number) from tm_series_data crs where crs.id = r.GROUP_SERIES_ID) CRS_SERIES , (select min(DISPOSAL_NAME) from TM_ACQ_DISPOSAL status, tm_disposal_records records where status.id = records.disposal_status_id and records.miid = r.id) DISPOSAL_STATUS , (select min(class.class_number) from TM_ACQ_DISPOSAL status, tm_disposal_records records, tm_disposal_classes class where status.id = records.disposal_status_id and records.miid = r.id and class.id = records.disposal_class_id) DISPOSAL_CLASS, (select min(names.concat_search_name) from tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names where r.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY, (select min(c.u_id_ext1) from tmddba.tm_mi_tpi_lnx lnx, tm_ctnrs c where c.u_id = lnx.tpiid and lnx.miid = r.id) U_ID_EXT1 , (select t.name from TM_CFG_MI_FMT_TYP t where t.id = r.mi_fmt_type) ITEM_FORMAT_TEXT, CASE WHEN BITAND(r.COMPIL, 2) = 2 THEN 'SUPPLIED' WHEN BITAND(r.COMPIL, 4) = 4 THEN 'MADE' WHEN BITAND(r.COMPIL, 134217728) = 134217728 THEN 'IMPORTED' ELSE '' END AS ORIGIN, CASE WHEN BITAND(r.COMPIL, 512) = 512 THEN 'Attached' WHEN BITAND(r.COMPIL, 1024) = 1024 THEN 'Un-Attached' ELSE '' END AS FLAGS, (select min(lang.full_name) from TM_PG_RL_LANG_LNX lnx, TM_LANG_DATA lang where lnx.tm_pg_rl_id = r.pgm_parent_id and lnx.lang_id = lang.id) AS PROD_LANGUAGE , (select min(ctx.ITFC_CODE) from tm_mis mis, tm_mi_tpi_lnx links, tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names where mis.id = r.id and links.miid = mis.id and mis.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY_NUMBER, (select min(status.description) from TM_CFG_PGM_STATUS status where r.status = status.id) PGM_STATUS_TEXT, (select min(ver.DUR) from TM_PG_RL ver where r.pgm_PARENT_ID = ver.id) AS VERSION_DUR , (select tmd_str_agg_pipe(cms.status_type_id ||',' ||cms.status_id) from tm_mi_cust_med_stat_lnx cms where cms.media_id=r.id) "CustomStatusesRaw", (select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = r.net_grp_id) CHANNEL_GROUP, (SELECT SUBSTR( trim( replace (replace ( LISTAGG(trim(tt.tags || ' ' || tt.notes), ' ') WITHIN GROUP (ORDER BY trim(tt.tags || ' ' || tt.notes)), chr (13), ''), chr (10), ' ')), 1, 150) z FROM tm_media_tagging tt WHERE link_guid = DFILE_LINK_GUID and rownum=1) TAGS_TEXT , GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select a.*, rownum rnum from (select m.*, coalesce(m.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=m.pgm_parent_id)) primary_thumb_id2 from tmddba.tm_mis m ,(select /*+ cardinality(4) */ rownum rn, column_value id from table(:ids)) ids where m.id = ids.id order by ids.rn ) a where rownum <= 10000) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl where rnum >= 1 order by rnum t Verbose: 1220 : 10|08:03:33.1707|2dg~6b|CJPOWERCAST|Alternative title fields query: select * from (select x.id,x.pgm_abs_id TitleId, x.pgm_parent_id VersionId from tm_mis x where id in (select /*+ cardinality(4) */ column_value id from table(:ids))) y,lateral (select dbms_lob.substr( o.text_data_plain, 1000, 1 ) Field_5799344 from tm_txt_obj o where (o.pgm_abs_id=y.TitleId or o.pgm_rl_id = y.VersionId) and o.type_id=:param_1 order by o.id desc fetch first 1 rows only)(+) t Information: 1220 : 10|08:03:33.1707|2dg~6b|CJPOWERCAST| timing: 00:00:00.9857216 t Verbose: 1220 : 10|08:03:33.1707|2dg~6b|CJPOWERCAST|imfx v3 API took 1.041s '/api/v3/search/Media?_dc=1669190610363' t Transfer: 1220 : 10|08:03:33.3717|2dg~6b|CJPOWERCAST|GetUrl. Storage |Video| filename I:\Video\L0640441.mp4 subfolder t Transfer: 1220 : 10|08:03:33.3717|2dg~6b|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/L0640441.mp4 t Transfer: 1220 : 10|08:03:33.3717|2dg~6b|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/L0640441.mp4 t Transfer: 1220 : 10|08:03:33.3717|2dg~6b|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:33.3717|2dg~6b|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:33.3717|2dg~6b|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:03:33.5727|2dg~6b|CJPOWERCAST|GetUrl. Storage |Video| filename I:\Video\L0640430.mp4 subfolder t Transfer: 1220 : 10|08:03:33.5727|2dg~6b|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/L0640430.mp4 t Transfer: 1220 : 10|08:03:33.5727|2dg~6b|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/L0640430.mp4 t Transfer: 1220 : 10|08:03:33.5727|2dg~6b|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:33.5727|2dg~6b|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:33.5727|2dg~6b|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:03:33.5727|2dg~6b|CJPOWERCAST|GetUrl. Storage |PMH Video| filename \\10.46.131.12\Test\NGAM\Folder3\alpha7-1\C0002.MP4 subfolder alpha7-1\ t Transfer: 1220 : 10|08:03:33.5727|2dg~6b|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:33.5737|2dg~6b|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:33.5737|2dg~6b|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:03:33.5737|2dg~6b|CJPOWERCAST|GetUrl. Storage |PMH Video| filename \\10.46.131.12\Test\NGAM\Folder3\alpha7-1\C0003.MP4 subfolder alpha7-1\ t Transfer: 1220 : 10|08:03:33.5737|2dg~6b|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:33.5737|2dg~6b|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:33.5737|2dg~6b|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:03:33.5737|2dg~6b|CJPOWERCAST|GetUrl. Storage |PMH Video| filename \\10.46.131.12\Test\NGAM\Folder3\alpha7-1\C0004.MP4 subfolder alpha7-1\ t Transfer: 1220 : 10|08:03:33.5737|2dg~6b|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:33.5737|2dg~6b|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:33.5737|2dg~6b|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:03:33.5737|2dg~6b|CJPOWERCAST|GetUrl. Storage |PMH Video| filename \\10.46.131.12\Test\NGAM\Folder3\alpha7-1\C0005.MP4 subfolder alpha7-1\ t Transfer: 1220 : 10|08:03:33.5747|2dg~6b|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:33.5747|2dg~6b|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:33.5747|2dg~6b|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:03:33.5747|2dg~6b|CJPOWERCAST|GetUrl. Storage |PMH Video| filename \\10.46.131.12\Test\NGAM\Folder3\alpha7-1\C0007.MP4 subfolder alpha7-1\ t Transfer: 1220 : 10|08:03:33.5747|2dg~6b|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:33.5747|2dg~6b|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:33.5747|2dg~6b|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:03:33.5747|2dg~6b|CJPOWERCAST|GetUrl. Storage |PMH Video| filename \\10.46.131.12\Test\NGAM\Folder3\32b60bce-ad82-46d9-9680-1bc508939215\GH018860.MP4 subfolder 32b60bce-ad82-46d9-9680-1bc508939215\ t Transfer: 1220 : 10|08:03:33.5747|2dg~6b|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:33.5747|2dg~6b|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:33.5747|2dg~6b|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:03:33.5747|2dg~6b|CJPOWERCAST|GetUrl. Storage |PMH Video| filename \\10.46.131.12\Test\NGAM\Folder3\aa6fb5ed-8e69-4268-b8fa-1184664437a0\GH018859.MP4 subfolder aa6fb5ed-8e69-4268-b8fa-1184664437a0\ t Transfer: 1220 : 10|08:03:33.5757|2dg~6b|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:33.5757|2dg~6b|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:33.5757|2dg~6b|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:03:33.5757|2dg~6b|CJPOWERCAST|GetUrl. Storage |PMH Video| filename \\10.46.131.12\Test\NGAM\Folder3\206cf38c-d40c-49e6-b8ed-476b7c369d2c\GH018861.MP4 subfolder 206cf38c-d40c-49e6-b8ed-476b7c369d2c\ t Transfer: 1220 : 10|08:03:33.5757|2dg~6b|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:33.5757|2dg~6b|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:33.5757|2dg~6b|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:03:33.5757|2dg~6b|CJPOWERCAST|GetUrl. Storage |PMH Proxy| filename \\10.46.131.12\Test\NGAM\Folder5\295_2302_M0002105.mp4 subfolder t Transfer: 1220 : 10|08:03:33.5757|2dg~6b|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:33.5757|2dg~6b|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:33.5757|2dg~6b|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:03:33.5757|2dg~6b|CJPOWERCAST|GetUrl. Storage |PMH Proxy| filename \\10.46.131.12\Test\NGAM\Folder5\N0002107.mp4 subfolder t Transfer: 1220 : 10|08:03:33.5767|2dg~6b|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:33.5767|2dg~6b|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:33.5767|2dg~6b|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:03:33.5767|2dg~6b|CJPOWERCAST|GetUrl. Storage |PMH Proxy| filename \\10.46.131.12\Test\NGAM\Folder5\N0002108.mp4 subfolder t Transfer: 1220 : 10|08:03:33.5767|2dg~6b|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:33.5767|2dg~6b|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:33.5767|2dg~6b|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:03:33.5767|2dg~6b|CJPOWERCAST|GetUrl. Storage |PMH Proxy| filename \\10.46.131.12\Test\NGAM\Folder5\GH018860_M0002145.mp4 subfolder t Transfer: 1220 : 10|08:03:33.5767|2dg~6b|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:33.5767|2dg~6b|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:33.5767|2dg~6b|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:03:33.5777|2dg~6b|CJPOWERCAST|GetUrl. Storage |PMH Proxy| filename \\10.46.131.12\Test\NGAM\Folder5\MAXD_1506_M0002267.mp4 subfolder t Transfer: 1220 : 10|08:03:33.5777|2dg~6b|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:33.5777|2dg~6b|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:33.5777|2dg~6b|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:03:33.5777|2dg~6b|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\8DCM000222_OMN0118203335_M0002381.mp4 subfolder t Transfer: 1220 : 10|08:03:33.5777|2dg~6b|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/8DCM000222_OMN0118203335_M0002381.mp4 t Transfer: 1220 : 10|08:03:33.5777|2dg~6b|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/8DCM000222_OMN0118203335_M0002381.mp4 t Transfer: 1220 : 10|08:03:33.5777|2dg~6b|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:33.5777|2dg~6b|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:33.5777|2dg~6b|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:03:33.5777|2dg~6b|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gots0ep4us.mpd subfolder t Transfer: 1220 : 10|08:03:33.5777|2dg~6b|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gots0ep4us.mpd t Transfer: 1220 : 10|08:03:33.5787|2dg~6b|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/gots0ep4us.mpd t Transfer: 1220 : 10|08:03:33.5787|2dg~6b|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:33.5787|2dg~6b|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:33.5787|2dg~6b|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:03:33.5787|2dg~6b|CJPOWERCAST|GetUrl. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\SPOC List.xlsx subfolder t Transfer: 1220 : 10|08:03:33.5787|2dg~6b|CJPOWERCAST| GetFileName result https://demo.tmd.tv/Temp Upload/SPOC%20List.xlsx t Transfer: 1220 : 10|08:03:33.5787|2dg~6b|CJPOWERCAST|GetUrl. result https://demo.tmd.tv/Temp Upload/SPOC%20List.xlsx t Transfer: 1220 : 10|08:03:33.5787|2dg~6b|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:33.5787|2dg~6b|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:33.5787|2dg~6b|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:03:33.5787|2dg~6b|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\snow-game-of-thrones-1200x600.jpg subfolder t Transfer: 1220 : 10|08:03:33.5787|2dg~6b|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/snow-game-of-thrones-1200x600.jpg t Transfer: 1220 : 10|08:03:33.5797|2dg~6b|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/snow-game-of-thrones-1200x600.jpg t Transfer: 1220 : 10|08:03:33.5797|2dg~6b|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:33.5797|2dg~6b|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:33.5797|2dg~6b|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:03:33.5797|2dg~6b|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\Game_of_Thrones_Still_4.jpg subfolder t Transfer: 1220 : 10|08:03:33.5797|2dg~6b|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/Game_of_Thrones_Still_4.jpg t Transfer: 1220 : 10|08:03:33.5797|2dg~6b|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/Game_of_Thrones_Still_4.jpg t Transfer: 1220 : 10|08:03:33.5797|2dg~6b|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:33.5797|2dg~6b|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:33.5797|2dg~6b|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:03:33.5797|2dg~6b|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\Game_of_Thrones_Still_4.png subfolder t Transfer: 1220 : 10|08:03:33.5807|2dg~6b|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/Game_of_Thrones_Still_4.png t Transfer: 1220 : 10|08:03:33.5807|2dg~6b|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/Game_of_Thrones_Still_4.png t Transfer: 1220 : 10|08:03:33.5807|2dg~6b|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:33.5807|2dg~6b|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:33.5807|2dg~6b|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:03:33.5807|2dg~6b|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\game-of-thrones-1349.jpg subfolder t Transfer: 1220 : 10|08:03:33.5807|2dg~6b|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/game-of-thrones-1349.jpg t Transfer: 1220 : 10|08:03:33.5807|2dg~6b|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/game-of-thrones-1349.jpg t Transfer: 1220 : 10|08:03:33.5807|2dg~6b|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:33.5807|2dg~6b|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:33.5807|2dg~6b|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:03:33.5817|2dg~6b|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\game-of-thrones-daenerys.jpg subfolder t Transfer: 1220 : 10|08:03:33.5817|2dg~6b|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/game-of-thrones-daenerys.jpg t Transfer: 1220 : 10|08:03:33.5817|2dg~6b|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/game-of-thrones-daenerys.jpg t Transfer: 1220 : 10|08:03:33.5817|2dg~6b|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:33.5817|2dg~6b|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:33.5817|2dg~6b|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:03:33.5817|2dg~6b|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\young cersei game of thrones helen sloan.jpeg.jpg subfolder t Transfer: 1220 : 10|08:03:33.5817|2dg~6b|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/young%20cersei%20game%20of%20thrones%20helen%20sloan.jpeg.jpg t Transfer: 1220 : 10|08:03:33.5817|2dg~6b|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/young%20cersei%20game%20of%20thrones%20helen%20sloan.jpeg.jpg t Transfer: 1220 : 10|08:03:33.5817|2dg~6b|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:33.5817|2dg~6b|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:33.5817|2dg~6b|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:03:33.5827|2dg~6b|CJPOWERCAST|GetUrl. Storage |VODPublish| filename \\192.168.120.254\DemoFS\Digital Assets\VODPublish\Temp\N0001344.dtd subfolder Temp\ t Transfer: 1220 : 10|08:03:33.5827|2dg~6b|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:33.5827|2dg~6b|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:33.5827|2dg~6b|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:03:33.5827|2dg~6b|CJPOWERCAST|GetUrl. Storage |VODPublish| filename \\192.168.120.254\DemoFS\Digital Assets\VODPublish\Temp\N0001345.xml subfolder Temp\ t Transfer: 1220 : 10|08:03:33.5827|2dg~6b|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:33.5827|2dg~6b|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:33.5827|2dg~6b|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:03:33.5827|2dg~6b|CJPOWERCAST|GetUrl. Storage |VODPublish| filename \\192.168.120.254\DemoFS\Digital Assets\VODPublish\Temp\N0001348.dtd subfolder Temp\ t Transfer: 1220 : 10|08:03:33.5827|2dg~6b|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:33.5827|2dg~6b|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:33.5827|2dg~6b|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:03:33.5837|2dg~6b|CJPOWERCAST|GetUrl. Storage |VODPublish| filename \\192.168.120.254\DemoFS\Digital Assets\VODPublish\Temp\N0001349.xml subfolder Temp\ t Transfer: 1220 : 10|08:03:33.5837|2dg~6b|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:33.5837|2dg~6b|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:33.5837|2dg~6b|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:03:33.5837|2dg~6b|CJPOWERCAST|GetUrl. Storage |Docs| filename I:\Docs\Mediaflex Supported Devices 2v03.pdf subfolder t Transfer: 1220 : 10|08:03:33.5837|2dg~6b|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/DocsServer/Mediaflex%20Supported%20Devices%202v03.pdf t Transfer: 1220 : 10|08:03:33.5837|2dg~6b|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/DocsServer/Mediaflex%20Supported%20Devices%202v03.pdf t Transfer: 1220 : 10|08:03:33.5837|2dg~6b|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:33.5837|2dg~6b|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:33.5837|2dg~6b|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:03:33.5837|2dg~6b|CJPOWERCAST|GetUrl. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\BBC_graymeta_metadata.json subfolder t Transfer: 1220 : 10|08:03:33.5837|2dg~6b|CJPOWERCAST| GetFileName result https://demo.tmd.tv/Temp Upload/BBC_graymeta_metadata.json t Transfer: 1220 : 10|08:03:33.5847|2dg~6b|CJPOWERCAST|GetUrl. result https://demo.tmd.tv/Temp Upload/BBC_graymeta_metadata.json t Transfer: 1220 : 10|08:03:33.5847|2dg~6b|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:33.5847|2dg~6b|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:33.5847|2dg~6b|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:03:33.5847|2dg~6b|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Game of Thrones - Blinkbox-HD.mp4 subfolder t Transfer: 1220 : 10|08:03:33.5847|2dg~6b|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Game%20of%20Thrones%20-%20Blinkbox-HD.mp4 t Transfer: 1220 : 10|08:03:33.5847|2dg~6b|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/Game%20of%20Thrones%20-%20Blinkbox-HD.mp4 t Transfer: 1220 : 10|08:03:33.5847|2dg~6b|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:33.5847|2dg~6b|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:33.5847|2dg~6b|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:03:33.5847|2dg~6b|CJPOWERCAST|GetUrl. Storage |VODPublish| filename \\192.168.120.254\DemoFS\Digital Assets\VODPublish\Temp\N0001343.mp4 subfolder Temp\ t Transfer: 1220 : 10|08:03:33.5857|2dg~6b|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:33.5857|2dg~6b|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:33.5857|2dg~6b|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:03:33.5857|2dg~6b|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gotspecialspromo20seccharacter.mp4 subfolder t Transfer: 1220 : 10|08:03:33.5857|2dg~6b|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gotspecialspromo20seccharacter.mp4 t Transfer: 1220 : 10|08:03:33.5857|2dg~6b|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/gotspecialspromo20seccharacter.mp4 t Transfer: 1220 : 10|08:03:33.5857|2dg~6b|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:33.5857|2dg~6b|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:33.5857|2dg~6b|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:03:33.5857|2dg~6b|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\gotspecialspromosimage.jpg subfolder t Transfer: 1220 : 10|08:03:33.5857|2dg~6b|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/gotspecialspromosimage.jpg t Transfer: 1220 : 10|08:03:33.5857|2dg~6b|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/gotspecialspromosimage.jpg t Transfer: 1220 : 10|08:03:33.5867|2dg~6b|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:33.5867|2dg~6b|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:33.5867|2dg~6b|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:03:33.5867|2dg~6b|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\Example 06052020.mp4 subfolder t Transfer: 1220 : 10|08:03:33.5867|2dg~6b|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/Example%2006052020.mp4 t Transfer: 1220 : 10|08:03:33.5867|2dg~6b|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/Example%2006052020.mp4 t Transfer: 1220 : 10|08:03:33.5867|2dg~6b|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:33.5867|2dg~6b|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:33.5867|2dg~6b|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:03:33.5877|2dg~6b|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gots0ep3us.mpd subfolder t Transfer: 1220 : 10|08:03:33.5877|2dg~6b|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gots0ep3us.mpd t Transfer: 1220 : 10|08:03:33.5877|2dg~6b|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/gots0ep3us.mpd t Transfer: 1220 : 10|08:03:33.5877|2dg~6b|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:33.5877|2dg~6b|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:33.5877|2dg~6b|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:03:33.5877|2dg~6b|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Example 06052020.mp4 subfolder t Transfer: 1220 : 10|08:03:33.5877|2dg~6b|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Example%2006052020.mp4 t Transfer: 1220 : 10|08:03:33.5877|2dg~6b|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/Example%2006052020.mp4 t Transfer: 1220 : 10|08:03:33.5877|2dg~6b|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:33.5877|2dg~6b|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:33.5877|2dg~6b|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:03:33.5877|2dg~6b|CJPOWERCAST|GetUrl. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\68add84afa7b\Animation Sample1.mp4 subfolder 68add84afa7b\ t Transfer: 1220 : 10|08:03:33.5887|2dg~6b|CJPOWERCAST| GetFileName result https://demo.tmd.tv/Temp Upload/Animation%20Sample1.mp4 t Transfer: 1220 : 10|08:03:33.5887|2dg~6b|CJPOWERCAST|GetUrl. result https://demo.tmd.tv/Temp Upload/Animation%20Sample1.mp4 t Transfer: 1220 : 10|08:03:33.5887|2dg~6b|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:33.5887|2dg~6b|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:33.5887|2dg~6b|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:03:33.5887|2dg~6b|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gotspecialspromo10secaction.mp4 subfolder t Transfer: 1220 : 10|08:03:33.5887|2dg~6b|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gotspecialspromo10secaction.mp4 t Transfer: 1220 : 10|08:03:33.5887|2dg~6b|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/gotspecialspromo10secaction.mp4 t Transfer: 1220 : 10|08:03:33.5887|2dg~6b|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:33.5887|2dg~6b|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:33.5887|2dg~6b|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:03:33.5887|2dg~6b|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gots0ep5us.mpd subfolder t Transfer: 1220 : 10|08:03:33.5897|2dg~6b|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gots0ep5us.mpd t Transfer: 1220 : 10|08:03:33.5897|2dg~6b|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/gots0ep5us.mpd t Transfer: 1220 : 10|08:03:33.5897|2dg~6b|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:33.5897|2dg~6b|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:33.5897|2dg~6b|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:03:33.5897|2dg~6b|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gots0ep2us.mpd subfolder t Transfer: 1220 : 10|08:03:33.5897|2dg~6b|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gots0ep2us.mpd t Transfer: 1220 : 10|08:03:33.5897|2dg~6b|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/gots0ep2us.mpd t Transfer: 1220 : 10|08:03:33.5897|2dg~6b|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:33.5897|2dg~6b|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:33.5897|2dg~6b|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:03:33.5907|2dg~6b|CJPOWERCAST|GetUrl. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\cd16270b-696e-4e0b-9a0e-02a00f6c3c8d\2022년_통합인제스트_6월 근무표.xlsx subfolder cd16270b-696e-4e0b-9a0e-02a00f6c3c8d\ t Transfer: 1220 : 10|08:03:33.5907|2dg~6b|CJPOWERCAST| GetFileName result https://demo.tmd.tv/Temp Upload/2022%EB%85%84_%ED%86%B5%ED%95%A9%EC%9D%B8%EC%A0%9C%EC%8A%A4%ED%8A%B8_6%EC%9B%94%20%EA%B7%BC%EB%AC%B4%ED%91%9C.xlsx t Transfer: 1220 : 10|08:03:33.5907|2dg~6b|CJPOWERCAST|GetUrl. result https://demo.tmd.tv/Temp Upload/2022%EB%85%84_%ED%86%B5%ED%95%A9%EC%9D%B8%EC%A0%9C%EC%8A%A4%ED%8A%B8_6%EC%9B%94%20%EA%B7%BC%EB%AC%B4%ED%91%9C.xlsx t Transfer: 1220 : 10|08:03:33.5907|2dg~6b|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:33.5907|2dg~6b|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:33.5907|2dg~6b|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:03:33.5907|2dg~6b|CJPOWERCAST|GetUrl. Storage |PMH Video| filename \\10.46.131.12\Test\NGAM\Folder3\0008971.mp4 subfolder t Transfer: 1220 : 10|08:03:33.5907|2dg~6b|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:33.5907|2dg~6b|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:33.5907|2dg~6b|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:03:33.5907|2dg~6b|CJPOWERCAST|GetUrl. Storage |PMH Proxy| filename \\10.46.131.12\Test\NGAM\Folder5\0154300FRM00_M0002176.mp4 subfolder t Transfer: 1220 : 10|08:03:33.5907|2dg~6b|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:33.5917|2dg~6b|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:33.5917|2dg~6b|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:03:34.3957|fdVhp1|CJPOWERCAST|OAuth: /api/user-preferences?_dc=1669190612710 t Transfer: 1220 : 10|08:03:34.3957|fdVhp1|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:34.3957|fdVhp1|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:34.3957|fdVhp1|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:03:34.3957|fdVhp1|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 10|08:03:34.3957|fdVhp1|CJPOWERCAST|StoreUserDataByKeys.. t Transfer: 1220 : 10|08:03:34.3957|fdVhp1|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:34.3957|fdVhp1|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:34.3957|fdVhp1|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:03:34.3967|fdVhp1|CJPOWERCAST|imfx v3 API took 0.016s '/api/user-preferences?_dc=1669190612710' t Transfer: 1220 : 10|08:03:39.8237|8057IZ|CJPOWERCAST|OAuth: /api/user-group-preferences?keys=googleMapsApiSettings&_dc=1669190618069 t Transfer: 1220 : 10|08:03:39.8237|8057IZ|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:39.8237|8057IZ|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:39.8237|8057IZ|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:03:39.8237|8057IZ|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|08:03:39.8247|8057IZ|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:39.8247|8057IZ|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:39.8247|8057IZ|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:03:39.8247|8057IZ|CJPOWERCAST|imfx v3 API took 0.007s '/api/user-group-preferences?keys=googleMapsApiSettings&_dc=1669190618069' t Transfer: 1220 : 10|08:03:40.0257|LK1rn2|CJPOWERCAST|OAuth: /api/v3/media-details/291742?_dc=1669190618231 t Transfer: 1220 : 10|08:03:40.0257|LK1rn2|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:40.0257|LK1rn2|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:40.0257|LK1rn2|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:03:40.0257|LK1rn2|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|08:03:40.0257|LK1rn2|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:40.0257|LK1rn2|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:40.0257|LK1rn2|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|08:03:40.4277|||TM_MIS. LoadSubtitles for ID: 291742 t Information: 1220 : 10|08:03:40.4277|||TM_MIS. LoadSubtitles for ID: 291742. SQL: 'select id, m_ctnr_id, m_ctnr_loc, modified_dt, tv_std, m_ctnr_fmt_id, nvl((select max(l.language) from tm_audio l where l.miid=m.id),aud_language_id) aud_language_id from tm_mis m where mi_deleted=0 and item_type>0 and media_type=101 and PGM_PARENT_ID=291740' t Information: 1220 : 10|08:03:40.4277|||TM_MIS. LoadSubtitles for ID: 291742 found no subtitles. t Verbose: 1220 : 10|08:03:40.4277|LK1rn2|CJPOWERCAST|imfx v3 API took 0.582s '/api/v3/media-details/291742?_dc=1669190618231' t Transfer: 1220 : 10|08:03:40.6287|LK1rn2|CJPOWERCAST|GetUrl. Storage |Video| filename I:\Video\L0640430.mp4 subfolder t Transfer: 1220 : 10|08:03:40.6287|LK1rn2|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/L0640430.mp4 t Transfer: 1220 : 10|08:03:40.6287|LK1rn2|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/L0640430.mp4 t Transfer: 1220 : 10|08:03:40.6287|LK1rn2|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:40.6287|LK1rn2|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:40.6287|LK1rn2|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:03:40.8297|A1NWic|CJPOWERCAST|OAuth: /api/v3/detailsview/MediaDetails/5?lang=en-GB&_dc=1669190619132 t Transfer: 1220 : 10|08:03:40.8297|A1NWic|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:40.8297|A1NWic|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:40.8297|A1NWic|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:03:40.8297|A1NWic|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|08:03:40.8297|A1NWic|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:40.8307|A1NWic|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:40.8307|A1NWic|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|08:03:40.8307|A1NWic|CJPOWERCAST|GetSystemPref. Pref: DetailsView, Type: -4013, subType: 5 t Information: 1220 : 10|08:03:40.8307|A1NWic|CJPOWERCAST|GetSystemPref. Pref: DetailsView, Type: -4013, subType: 0 t Information: 1220 : 10|08:03:40.8307|A1NWic|CJPOWERCAST|GetSystemPref. Pref: DetailsView, Type: -4013, subType: 5 t Information: 1220 : 10|08:03:40.8307|A1NWic|CJPOWERCAST|GetSystemPref. Pref: DetailsView, Type: -4013, subType: 0 t Verbose: 1220 : 10|08:03:41.0317|A1NWic|CJPOWERCAST|imfx v3 API took 0.111s '/api/v3/detailsview/MediaDetails/5?lang=en-GB&_dc=1669190619132' t Transfer: 1220 : 10|08:03:41.2327|jQHKno|CJPOWERCAST|OAuth: /api/v3/media-captions/291742?_dc=1669190619537 t Transfer: 1220 : 10|08:03:41.2327|jQHKno|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:41.2327|jQHKno|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:41.2327|jQHKno|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:03:41.2327|jQHKno|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 10|08:03:41.2327|jQHKno|CJPOWERCAST|imfx v3 API took 0.031s '/api/v3/media-captions/291742?_dc=1669190619537' t Transfer: 1220 : 10|08:03:41.2327|MnBIX5|CJPOWERCAST|OAuth: /api/v3/mediavideo/291742?info=smudge,scene,audiovolume&_dc=1669190619595 t Transfer: 1220 : 10|08:03:41.2327|MnBIX5|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:41.2327|MnBIX5|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:41.2327|MnBIX5|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:03:41.2337|MnBIX5|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|08:03:41.2337|TGTeua|CJPOWERCAST|OAuth: /api/user-group-preferences?keys=googleMapsApiSettings&_dc=1669190619598 t Transfer: 1220 : 10|08:03:41.2337|TGTeua|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:41.2337|TGTeua|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:41.2337|TGTeua|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:03:41.2337|TGTeua|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|08:03:41.2337|TGTeua|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:41.2337|TGTeua|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:41.2337|TGTeua|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:03:41.2337|TGTeua|CJPOWERCAST|imfx v3 API took 0.005s '/api/user-group-preferences?keys=googleMapsApiSettings&_dc=1669190619598' t Transfer: 1220 : 10|08:03:41.2337|MnBIX5|CJPOWERCAST|GetUrl. Storage |Video| filename I:\Video\L0640430.mp4 subfolder t Transfer: 1220 : 10|08:03:41.2337|MnBIX5|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/L0640430.mp4 t Transfer: 1220 : 10|08:03:41.2347|MnBIX5|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/L0640430.mp4 t Transfer: 1220 : 10|08:03:41.2347|MnBIX5|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:41.2347|MnBIX5|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:41.2347|MnBIX5|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:03:41.4357|MnBIX5|CJPOWERCAST|imfx v3 API took 0.118s '/api/v3/mediavideo/291742?info=smudge,scene,audiovolume&_dc=1669190619595' t Transfer: 1220 : 10|08:03:41.4357|IyAZIf|CJPOWERCAST|OAuth: /api/lookups/FriendlyNames?_dc=1669190619738 t Transfer: 1220 : 10|08:03:41.4357|IyAZIf|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:41.4357|IyAZIf|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:41.4357|IyAZIf|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:03:41.4357|IyAZIf|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 10|08:03:41.4357|IyAZIf|CJPOWERCAST|imfx v3 API took 0.000s '/api/lookups/FriendlyNames?_dc=1669190619738' t Transfer: 1220 : 10|08:03:41.4357|lCrdq5|CJPOWERCAST|OAuth: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1669190619804 t Transfer: 1220 : 10|08:03:41.4357|lCrdq5|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:41.4357|lCrdq5|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:41.4367|lCrdq5|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:03:41.4367|lCrdq5|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|08:03:41.4367|lCrdq5|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:41.4367|lCrdq5|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:41.4367|lCrdq5|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:03:41.4367|lCrdq5|CJPOWERCAST|imfx v3 API took 0.007s '/api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1669190619804' t Transfer: 1220 : 10|08:03:41.8387|E9wsyQ|CJPOWERCAST|OAuth: /api/v3/ai-tags/291742?_dc=1669190620099 t Transfer: 1220 : 10|08:03:41.8387|E9wsyQ|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:41.8387|E9wsyQ|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:41.8387|E9wsyQ|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:03:41.8387|E9wsyQ|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|08:03:41.8387|loEIlV|CJPOWERCAST|OAuth: /api/v3/mediavideo/291742?info=smudge&_dc=1669190620102 t Transfer: 1220 : 10|08:03:41.8387|loEIlV|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:41.8387|loEIlV|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:41.8397|loEIlV|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:03:41.8397|loEIlV|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|08:03:41.8397|E9wsyQ|CJPOWERCAST|V3Api.GetMediaAiTags t Transfer: 1220 : 10|08:03:41.8397|loEIlV|CJPOWERCAST|GetUrl. Storage |Video| filename I:\Video\L0640430.mp4 subfolder t Transfer: 1220 : 10|08:03:41.8397|loEIlV|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/L0640430.mp4 t Transfer: 1220 : 10|08:03:41.8397|loEIlV|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/L0640430.mp4 t Transfer: 1220 : 10|08:03:41.8397|loEIlV|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:41.8397|loEIlV|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:41.8407|loEIlV|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:03:41.8407|loEIlV|CJPOWERCAST|imfx v3 API took 0.021s '/api/v3/mediavideo/291742?info=smudge&_dc=1669190620102' t Transfer: 1220 : 10|08:03:41.8407|O2nwPX|CJPOWERCAST|OAuth: /api/metadata/4000/291742?_dc=1669190620128 t Transfer: 1220 : 10|08:03:41.8407|O2nwPX|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:41.8407|O2nwPX|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:41.8407|O2nwPX|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:03:41.8407|O2nwPX|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 10|08:03:42.0417|O2nwPX|CJPOWERCAST|imfx v3 API took 0.220s '/api/metadata/4000/291742?_dc=1669190620128' t Verbose: 1220 : 10|08:03:43.0468|E9wsyQ|CJPOWERCAST|imfx v3 API took 1.260s '/api/v3/ai-tags/291742?_dc=1669190620099' t Transfer: 1220 : 10|08:03:49.6797|xjy54N|CJPOWERCAST|OAuth: /api/user-preferences?keys=adv.recent.searches.versions&_dc=1669190627914 t Transfer: 1220 : 10|08:03:49.6797|xjy54N|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:49.6797|xjy54N|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:49.6797|xjy54N|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:03:49.6797|xjy54N|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|08:03:49.6797|AaJ3u5|CJPOWERCAST|OAuth: /api/view/searchinfo/Version?_dc=1669190627912 t Transfer: 1220 : 10|08:03:49.6797|AaJ3u5|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:49.6797|AaJ3u5|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:49.6797|AaJ3u5|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:03:49.6807|AaJ3u5|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|08:03:49.6807|xjy54N|CJPOWERCAST|GetUserDataByKeys: adv.recent.searches.versions t Transfer: 1220 : 10|08:03:49.6807|xjy54N|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:49.6807|xjy54N|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:49.6807|xjy54N|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|08:03:49.6807|AaJ3u5|CJPOWERCAST|GetAdvSearchColumns. search type Version grid . t Verbose: 1220 : 10|08:03:49.6807|AaJ3u5|CJPOWERCAST|imfx v3 API took 0.000s '/api/view/searchinfo/Version?_dc=1669190627912' t Verbose: 1220 : 10|08:03:49.6807|xjy54N|CJPOWERCAST|imfx v3 API took 0.006s '/api/user-preferences?keys=adv.recent.searches.versions&_dc=1669190627914' t Transfer: 1220 : 10|08:03:49.6807|N0CgBG|CJPOWERCAST|OAuth: /api/view/searches/Version?_dc=1669190627949 t Transfer: 1220 : 10|08:03:49.6807|N0CgBG|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:49.6807|N0CgBG|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:49.6807|N0CgBG|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:03:49.6817|N0CgBG|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|08:03:49.6817|N0CgBG|CJPOWERCAST|GetSavedSearchNames. search type Version. t Transfer: 1220 : 10|08:03:49.6817|N0CgBG|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:49.6817|N0CgBG|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:49.6817|N0CgBG|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:03:49.6817|sqnL3K|CJPOWERCAST|OAuth: /api/settings/user/searchLayoutConfig?_dc=1669190627952 t Transfer: 1220 : 10|08:03:49.6817|sqnL3K|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:49.6817|sqnL3K|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:49.6817|sqnL3K|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:03:49.6817|sqnL3K|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|08:03:49.6817|ySxARn|CJPOWERCAST|OAuth: /api/view/info/VersionGrid?lang=en-GB&_dc=1669190627951 t Transfer: 1220 : 10|08:03:49.6817|ySxARn|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:49.6827|ySxARn|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:49.6827|ySxARn|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:03:49.6827|ySxARn|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|08:03:49.6827|sqnL3K|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:49.6827|sqnL3K|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:49.6827|sqnL3K|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:03:49.6827|N0CgBG|CJPOWERCAST|imfx v3 API took 0.006s '/api/view/searches/Version?_dc=1669190627949' t Information: 1220 : 10|08:03:49.6827|ySxARn|CJPOWERCAST|GetGridViewBuilder. builder type VersionGrid. t Transfer: 1220 : 10|08:03:49.6827|ySxARn|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:49.6827|ySxARn|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:49.6827|ySxARn|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:03:49.6827|sqnL3K|CJPOWERCAST|imfx v3 API took 0.004s '/api/settings/user/searchLayoutConfig?_dc=1669190627952' t Information: 1220 : 10|08:03:49.6837|ySxARn|CJPOWERCAST|UserGridView. LoadView. ID -2, Name Default. t Transfer: 1220 : 10|08:03:49.6837|ySxARn|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:49.6837|ySxARn|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:49.6837|ySxARn|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:03:49.6837|ySxARn|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:49.6837|ySxARn|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:49.6837|ySxARn|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:03:49.6837|ySxARn|CJPOWERCAST|imfx v3 API took 0.012s '/api/view/info/VersionGrid?lang=en-GB&_dc=1669190627951' t Transfer: 1220 : 10|08:03:53.7037|I8GcL2|CJPOWERCAST|OAuth: /api/v3/search/versions?_dc=1669190632042 t Transfer: 1220 : 10|08:03:53.7037|I8GcL2|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:53.7037|I8GcL2|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:53.7037|I8GcL2|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:03:53.7037|I8GcL2|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|08:03:53.7037|I8GcL2|CJPOWERCAST|V3Api.SearchVersions t Information: 1220 : 10|08:03:53.7037|I8GcL2|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 10|08:03:53.7037|I8GcL2|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:53.7037|I8GcL2|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:53.7047|I8GcL2|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:03:53.7047|I8GcL2|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:53.7047|I8GcL2|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:53.7047|I8GcL2|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|08:03:53.7047|I8GcL2|CJPOWERCAST|Running solr search: [q, (((title:(*))^2 OR series:(*) OR (titleMergedNgram:**)^10 OR (alternativetitles_lcm:(*))^10 OR versionid1:(*) OR progid1:(*)) AND deleted_flag:(0) AND (owners:((SFP2) OR (PSP) OR (PMS) OR (SFP1) OR (PMH) OR (PPL))))] t Information: 1220 : 10|08:03:54.1067|I8GcL2|CJPOWERCAST|Solr query returned: 81 in 371ms t Information: 1220 : 10|08:03:54.1067|I8GcL2|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 cvt.ID from TM_PORTAL_VERSION_CONFIG cvt where m.CUSTOM_VERSION_TYPE = cvt.CUSTOM_VERSION_TYPE AND cvt.CUSTOM_VERSION_TYPE IS NOT NULL ) MP_CONFIG_ID from tmddba.tm_pg_rl m left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id,(select /*+ cardinality(4) */ rownum rn, column_value id from table(:ids)) ids where item_type>0 and rl_deleted=0 and m.id = ids.id order by ids.rn ) a where rownum <= 10000) r where rnum >=1 order by rnum t Information: 1220 : 10|08:03:54.3077|I8GcL2|CJPOWERCAST|Running version search. User: 1165 Simple Search: * Trying to use Solr Search... Solr completed in: 409ms. Returned lines: 81 Running Oracle search. Oracle version search timing: 180ms. 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 cvt.ID from TM_PORTAL_VERSION_CONFIG cvt where m.CUSTOM_VERSION_TYPE = cvt.CUSTOM_VERSION_TYPE AND cvt.CUSTOM_VERSION_TYPE IS NOT NULL ) MP_CONFIG_ID from tmddba.tm_pg_rl m left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id,(select /*+ cardinality(4) */ rownum rn, column_value id from table(:ids)) ids where item_type>0 and rl_deleted=0 and m.id = ids.id order by ids.rn ) a where rownum <= 10000) r where rnum >=1 order by rnum t Verbose: 1220 : 10|08:03:54.3077|I8GcL2|CJPOWERCAST|imfx v3 API took 0.612s '/api/v3/search/versions?_dc=1669190632042' t Transfer: 1220 : 10|08:03:55.3127|YIzQlp|CJPOWERCAST|OAuth: /api/user-preferences?_dc=1669190633521 t Transfer: 1220 : 10|08:03:55.3127|YIzQlp|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:55.3127|YIzQlp|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:55.3127|YIzQlp|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:03:55.3127|YIzQlp|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 10|08:03:55.3127|YIzQlp|CJPOWERCAST|StoreUserDataByKeys.. t Transfer: 1220 : 10|08:03:55.3127|YIzQlp|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:03:55.3127|YIzQlp|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:03:55.3127|YIzQlp|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:03:55.3137|YIzQlp|CJPOWERCAST|imfx v3 API took 0.006s '/api/user-preferences?_dc=1669190633521' t Transfer: 1220 : 10|08:04:00.1377|qkgA8t|CJPOWERCAST|OAuth: /api/user-group-preferences?keys=googleMapsApiSettings&_dc=1669190638477 t Transfer: 1220 : 10|08:04:00.1377|qkgA8t|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:04:00.1377|qkgA8t|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:04:00.1377|qkgA8t|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:04:00.1377|qkgA8t|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|08:04:00.1377|qkgA8t|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:04:00.1377|qkgA8t|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:04:00.1377|qkgA8t|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:04:00.1377|HT5z6Y|CJPOWERCAST|OAuth: /api/v3/version-details/300744?_dc=1669190638490 t Transfer: 1220 : 10|08:04:00.1377|HT5z6Y|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:04:00.1387|HT5z6Y|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:04:00.1387|HT5z6Y|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:04:00.1387|HT5z6Y|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 10|08:04:00.1387|qkgA8t|CJPOWERCAST|imfx v3 API took 0.004s '/api/user-group-preferences?keys=googleMapsApiSettings&_dc=1669190638477' t Transfer: 1220 : 10|08:04:00.1387|HT5z6Y|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:04:00.1387|HT5z6Y|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:04:00.1387|HT5z6Y|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:04:00.3397|HT5z6Y|CJPOWERCAST|imfx v3 API took 0.143s '/api/v3/version-details/300744?_dc=1669190638490' t Transfer: 1220 : 10|08:04:00.5407|ix0lae|CJPOWERCAST|OAuth: /api/v3/detailsview/VersionDetails/0?lang=en-GB&_dc=1669190638910 t Transfer: 1220 : 10|08:04:00.5407|ix0lae|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:04:00.5407|ix0lae|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:04:00.5407|ix0lae|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:04:00.5407|ix0lae|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|08:04:00.5407|ix0lae|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:04:00.5407|ix0lae|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:04:00.5407|ix0lae|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|08:04:00.5407|ix0lae|CJPOWERCAST|GetSystemPref. Pref: DetailsView, Type: -4014, subType: 0 t Information: 1220 : 10|08:04:00.5407|ix0lae|CJPOWERCAST|GetSystemPref. Pref: DetailsView, Type: -4014, subType: 0 t Verbose: 1220 : 10|08:04:00.5417|ix0lae|CJPOWERCAST|imfx v3 API took 0.019s '/api/v3/detailsview/VersionDetails/0?lang=en-GB&_dc=1669190638910' t Transfer: 1220 : 10|08:04:00.9437|nQPXoi|CJPOWERCAST|OAuth: /api/lookups/FriendlyNames?_dc=1669190639252 t Transfer: 1220 : 10|08:04:00.9437|nQPXoi|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:04:00.9437|nQPXoi|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:04:00.9437|nQPXoi|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:04:00.9437|nQPXoi|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 10|08:04:00.9437|nQPXoi|CJPOWERCAST|imfx v3 API took 0.000s '/api/lookups/FriendlyNames?_dc=1669190639252' t Transfer: 1220 : 10|08:04:00.9437|NvAM~k|CJPOWERCAST|OAuth: /api/v3/imf/300744?_dc=1669190639315 t Transfer: 1220 : 10|08:04:00.9437|NvAM~k|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:04:00.9437|NvAM~k|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:04:00.9437|NvAM~k|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:04:00.9447|NvAM~k|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|08:04:00.9447|eilsBg|CJPOWERCAST|OAuth: /api/view/info/TitleTree?lang=en-GB&_dc=1669190639319 t Transfer: 1220 : 10|08:04:00.9447|eilsBg|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:04:00.9447|eilsBg|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:04:00.9447|eilsBg|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:04:00.9447|eilsBg|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|08:04:00.9447|eilsBg|CJPOWERCAST|GetGridViewBuilder. builder type TitleTree. t Transfer: 1220 : 10|08:04:00.9447|eilsBg|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:04:00.9447|eilsBg|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:04:00.9447|eilsBg|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|08:04:00.9447|eilsBg|CJPOWERCAST|UserGridView. LoadView. ID -2, Name Default. t Transfer: 1220 : 10|08:04:00.9447|eilsBg|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:04:00.9447|eilsBg|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:04:00.9457|eilsBg|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:04:00.9457|eilsBg|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:04:00.9457|eilsBg|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:04:00.9457|eilsBg|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:04:00.9457|eilsBg|CJPOWERCAST|imfx v3 API took 0.009s '/api/view/info/TitleTree?lang=en-GB&_dc=1669190639319' t Verbose: 1220 : 10|08:04:00.9457|NvAM~k|CJPOWERCAST|imfx v3 API took 0.020s '/api/v3/imf/300744?_dc=1669190639315' t Transfer: 1220 : 10|08:04:01.1467|XQd7aI|CJPOWERCAST|OAuth: /api/metadata/3020/300744?_dc=1669190639494 t Transfer: 1220 : 10|08:04:01.1467|XQd7aI|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:04:01.1467|XQd7aI|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:04:01.1467|XQd7aI|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:04:01.1467|XQd7aI|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 10|08:04:01.1467|XQd7aI|CJPOWERCAST|imfx v3 API took 0.024s '/api/metadata/3020/300744?_dc=1669190639494' t Transfer: 1220 : 10|08:04:05.7697|dqW8vB|CJPOWERCAST|OAuth: /api/view/searchinfo/TitleSearch?_dc=1669190644145 t Transfer: 1220 : 10|08:04:05.7697|dqW8vB|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:04:05.7697|dqW8vB|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:04:05.7697|dqW8vB|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:04:05.7697|dqW8vB|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|08:04:05.7697|cfRWiL|CJPOWERCAST|OAuth: /api/user-preferences?keys=adv.recent.searches.titles&_dc=1669190644146 t Transfer: 1220 : 10|08:04:05.7697|cfRWiL|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:04:05.7697|cfRWiL|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:04:05.7697|cfRWiL|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:04:05.7707|cfRWiL|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|08:04:05.7707|dqW8vB|CJPOWERCAST|GetAdvSearchColumns. search type TitleSearch grid . t Verbose: 1220 : 10|08:04:05.7707|dqW8vB|CJPOWERCAST|imfx v3 API took 0.000s '/api/view/searchinfo/TitleSearch?_dc=1669190644145' t Information: 1220 : 10|08:04:05.7707|cfRWiL|CJPOWERCAST|GetUserDataByKeys: adv.recent.searches.titles t Transfer: 1220 : 10|08:04:05.7707|cfRWiL|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:04:05.7707|cfRWiL|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:04:05.7707|cfRWiL|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:04:05.7707|cfRWiL|CJPOWERCAST|imfx v3 API took 0.006s '/api/user-preferences?keys=adv.recent.searches.titles&_dc=1669190644146' t Transfer: 1220 : 10|08:04:05.7717|NJxynE|CJPOWERCAST|OAuth: /api/view/searches/TitleSearch?_dc=1669190644173 t Transfer: 1220 : 10|08:04:05.7717|NJxynE|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:04:05.7717|NJxynE|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:04:05.7717|NJxynE|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:04:05.7717|NJxynE|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|08:04:05.7717|NJxynE|CJPOWERCAST|GetSavedSearchNames. search type TitleSearch. t Transfer: 1220 : 10|08:04:05.7717|NJxynE|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:04:05.7717|NJxynE|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:04:05.7717|NJxynE|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:04:05.7717|NJxynE|CJPOWERCAST|imfx v3 API took 0.004s '/api/view/searches/TitleSearch?_dc=1669190644173' t Transfer: 1220 : 10|08:04:05.9727|iwTLKP|CJPOWERCAST|OAuth: /api/view/info/DigitalCarriers?lang=en-GB&_dc=1669190644247 t Transfer: 1220 : 10|08:04:05.9727|iwTLKP|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:04:05.9727|iwTLKP|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:04:05.9727|iwTLKP|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:04:05.9727|iwTLKP|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|08:04:05.9727|iwTLKP|CJPOWERCAST|GetGridViewBuilder. builder type DigitalCarriers. t Transfer: 1220 : 10|08:04:05.9727|iwTLKP|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:04:05.9727|iwTLKP|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:04:05.9727|iwTLKP|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|08:04:05.9727|iwTLKP|CJPOWERCAST|UserGridView. LoadView. ID -2, Name Default. t Transfer: 1220 : 10|08:04:05.9737|iwTLKP|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:04:05.9737|iwTLKP|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:04:05.9737|iwTLKP|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:04:05.9737|iwTLKP|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:04:05.9737|iwTLKP|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:04:05.9737|iwTLKP|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:04:05.9737|iwTLKP|CJPOWERCAST|imfx v3 API took 0.007s '/api/view/info/DigitalCarriers?lang=en-GB&_dc=1669190644247' t Transfer: 1220 : 10|08:04:10.1937|mrlLEB|CJPOWERCAST|OAuth: /api/v3/search/title?_dc=1669190648472 t Transfer: 1220 : 10|08:04:10.1937|mrlLEB|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:04:10.1937|mrlLEB|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:04:10.1937|mrlLEB|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:04:10.1937|mrlLEB|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|08:04:10.1937|mrlLEB|CJPOWERCAST|V3Api.SearchTitles t Information: 1220 : 10|08:04:10.1937|mrlLEB|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 10|08:04:10.1937|mrlLEB|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:04:10.1937|mrlLEB|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:04:10.1947|mrlLEB|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|08:04:10.1947|mrlLEB|CJPOWERCAST|SearchTitle SQL: with v as ( SELECT abs.* ,(select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = abs.net_grp_id) CHANNEL_GROUP ,decode(ITEM_TYPE, 1010,SER_ABS_ID, 1020,CASE WHEN SER_ABS2_ID > 0 THEN SER_ABS2_ID ELSE SER_ABS_ID END ) xparent_id FROM TMDDBA.TM_PG_ABS abs WHERE abs.id in ( select a.id FROM TMDDBA.TM_PG_ABS a where ABS_DELETED = 0 AND (INSTR(OWNERS,'|SFP2|')>0 OR INSTR(OWNERS,'|PSP|')>0 OR INSTR(OWNERS,'|PMS|')>0 OR INSTR(OWNERS,'|SFP1|')>0 OR INSTR(OWNERS,'|PMH|')>0 OR INSTR(OWNERS,'|PPL|')>0 ) and (id in ( (select tobj.pgm_abs_id from TMDDBA.TM_TXT_OBJ tobj join TMDDBA.TM_TXT_TYP ttyp on (ttyp.id = tobj.TYPE_ID) where contains(tobj.ctx_text_col, :param_0 || ' WITHIN TEXT_DATA_PLAIN') > 0 and ttyp.is_alt_title = 1) union (select id from tmddba.tm_pg_abs where contains(ctx_ids_col, :param_0||' WITHIN PROGID1')>0) union (select id from tmddba.tm_pg_abs where contains(ctx_text_col, :param_0||' WITHIN TITLE OR '||:param_0||' WITHIN SER_TITLE')>0))) AND ROWNUM < 25000 ) ) ,v_missing_parent_ids as ( select xparent_id from v minus select id from v ) ,v_missing_parents as ( SELECT distinct a.* ,(select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = a.net_grp_id) CHANNEL_GROUP ,decode(ITEM_TYPE, 1010,SER_ABS_ID, 1020,CASE WHEN SER_ABS2_ID > 0 THEN SER_ABS2_ID ELSE SER_ABS_ID END ) xparent_id FROM TMDDBA.TM_PG_ABS a START WITH ID IN (select xparent_id from v_missing_parent_ids) CONNECT BY CASE PRIOR ITEM_TYPE WHEN 1010 THEN PRIOR SER_ABS_ID WHEN 1020 THEN CASE WHEN NVL(PRIOR SER_ABS2_ID, 0) > 0 THEN PRIOR SER_ABS2_ID ELSE PRIOR SER_ABS_ID END END = ID ) ,v_all as ( select x.*, count(*) over() RowCount from ( select * from v_missing_parents union select * from v ) x ) ,v_top as ( select id from (select id, row_number()over(order by upper(ser_title),upper(title),ser_num,ser_ep_num, SER_EP_SQ_NUM ) rnk -- sort roots from v_all where xparent_id is null) where rnk between (:page_number-1)*50+1 and :page_number*50 ) ,v_tree as ( select level "TreeLevel", a.*from v_all a start with id in (select id from v_top) connect by xparent_id = prior ID order siblings by upper(ser_title),ser_num,ser_ep_num, SER_EP_SQ_NUM,upper(title) -- sort children ) select * from v_tree --where rnk <= 50 t Verbose: 1220 : 10|08:04:10.7977|mrlLEB|CJPOWERCAST|imfx v3 API took 0.651s '/api/v3/search/title?_dc=1669190648472' t Transfer: 1220 : 10|08:04:11.1997|1gq6uz|CJPOWERCAST|OAuth: /api/user-preferences?_dc=1669190649487 t Transfer: 1220 : 10|08:04:11.1997|1gq6uz|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:04:11.1997|1gq6uz|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:04:11.1997|1gq6uz|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:04:11.1997|1gq6uz|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 10|08:04:11.1997|1gq6uz|CJPOWERCAST|StoreUserDataByKeys.. t Transfer: 1220 : 10|08:04:11.1997|1gq6uz|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:04:11.1997|1gq6uz|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:04:11.1997|1gq6uz|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:04:11.1997|1gq6uz|CJPOWERCAST|imfx v3 API took 0.008s '/api/user-preferences?_dc=1669190649487' t Transfer: 1220 : 10|08:04:15.2197|DF~zkK|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1669190653588 t Transfer: 1220 : 10|08:04:15.2197|DF~zkK|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:04:15.2197|DF~zkK|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:04:15.2197|DF~zkK|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:04:15.2197|DF~zkK|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|08:04:15.2197|DF~zkK|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:04:15.2197|DF~zkK|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:04:15.2197|DF~zkK|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:04:15.4207|DF~zkK|CJPOWERCAST|imfx v3 API took 0.097s '/api/v3/search-suggestion/?_dc=1669190653588' t Transfer: 1220 : 10|08:04:15.4207|K90QVs|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1669190653789 t Transfer: 1220 : 10|08:04:15.4207|K90QVs|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:04:15.4207|K90QVs|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:04:15.4207|K90QVs|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:04:15.4207|K90QVs|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|08:04:15.4207|K90QVs|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:04:15.4207|K90QVs|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:04:15.4207|K90QVs|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:04:15.4207|K90QVs|CJPOWERCAST|imfx v3 API took 0.021s '/api/v3/search-suggestion/?_dc=1669190653789' t Transfer: 1220 : 10|08:04:17.2307|k_cPPf|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1669190655619 t Transfer: 1220 : 10|08:04:17.2307|k_cPPf|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:04:17.2307|k_cPPf|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:04:17.2307|k_cPPf|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:04:17.2307|k_cPPf|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|08:04:17.2307|k_cPPf|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:04:17.2307|k_cPPf|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:04:17.2307|k_cPPf|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:04:17.2307|k_cPPf|CJPOWERCAST|imfx v3 API took 0.007s '/api/v3/search-suggestion/?_dc=1669190655619' t Transfer: 1220 : 10|08:04:19.2407|qJW7M4|CJPOWERCAST|OAuth: /api/v3/search/title?_dc=1669190657507 t Transfer: 1220 : 10|08:04:19.2407|qJW7M4|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:04:19.2407|qJW7M4|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:04:19.2407|qJW7M4|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:04:19.2407|qJW7M4|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|08:04:19.2407|qJW7M4|CJPOWERCAST|V3Api.SearchTitles t Information: 1220 : 10|08:04:19.2407|qJW7M4|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 10|08:04:19.2407|qJW7M4|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:04:19.2407|qJW7M4|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:04:19.2407|qJW7M4|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|08:04:19.2417|qJW7M4|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 : 10|08:04:19.4427|qJW7M4|CJPOWERCAST|imfx v3 API took 0.165s '/api/v3/search/title?_dc=1669190657507' t Transfer: 1220 : 10|08:04:19.6437|RHSGU1|CJPOWERCAST|OAuth: /api/v3/title/299390/versions?_dc=1669190658006 t Transfer: 1220 : 10|08:04:19.6437|RHSGU1|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:04:19.6437|RHSGU1|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:04:19.6437|RHSGU1|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:04:19.6437|RHSGU1|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|08:04:19.6437|WHQykY|CJPOWERCAST|OAuth: /api/user-preferences?_dc=1669190658007 t Transfer: 1220 : 10|08:04:19.6437|WHQykY|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:04:19.6437|WHQykY|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:04:19.6437|WHQykY|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:04:19.6447|WHQykY|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 10|08:04:19.6447|WHQykY|CJPOWERCAST|StoreUserDataByKeys.. t Transfer: 1220 : 10|08:04:19.6447|WHQykY|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:04:19.6447|WHQykY|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:04:19.6447|WHQykY|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|08:04:19.6447|RHSGU1|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 10|08:04:19.6447|RHSGU1|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:04:19.6447|RHSGU1|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:04:19.6447|RHSGU1|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:04:19.6447|RHSGU1|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:04:19.6447|RHSGU1|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:04:19.6447|RHSGU1|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:04:19.6447|RHSGU1|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:04:19.6457|RHSGU1|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:04:19.6457|RHSGU1|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:04:19.6457|WHQykY|CJPOWERCAST|imfx v3 API took 0.007s '/api/user-preferences?_dc=1669190658007' t Information: 1220 : 10|08:04:19.6457|RHSGU1|CJPOWERCAST|SearchVersion SQL: select v.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE , (select min(name) from TM_CFG_AUDIO_CONTENT_MS_TYPES audio where v.audio_type = audio.id ) SOUND ,(select min(from_date_time) from TM_PG_RL_PROD_DATE prodDate where prodDate.Tm_Pg_Rl_Id = v.id ) PROD_FROM_DATE ,(select min(to_date_time) from TM_PG_RL_PROD_DATE prodDate where prodDate.Tm_Pg_Rl_Id = v.id ) PROD_TO_DATE ,(select min(full_name) from tm_lang_data lang, TM_PG_RL_LANG_LNX link where lang.id = link.lang_id and link.tm_pg_rl_id = v.id) PROD_LANGUAGE ,(SELECT min(COLOUR_NAME) FROM tm_cfg_colour_list list, tm_pg_rl ver where ver.col_mono = list.id and ver.id = v.id) PROD_COLOUR_TEXT ,(SELECT min(cfg.prod_date_type_name) FROM TM_PG_RL_PROD_DATE pg_rl, tm_cfg_prod_date_type cfg where cfg.id = pg_rl.PROD_DATE_TYPE_ID and TM_PG_RL_ID = v.id ) PROD_DATE_TYPE ,(select min(status.description) from TM_CFG_PGM_STATUS status where v.ITEM_STATUS_ID = status.id) PGM_STATUS_TEXT ,(select submed.sub_medium_name from TM_CFG_SUB_MEDIUM submed where v.SUB_MEDIUM_ID = submed.id) SUB_MEDIUM_TEXT, (select cvt.ID from TM_PORTAL_VERSION_CONFIG cvt where v.CUSTOM_VERSION_TYPE = cvt.CUSTOM_VERSION_TYPE AND cvt.CUSTOM_VERSION_TYPE IS NOT NULL ) MP_CONFIG_ID from tmddba.tm_pg_rl v left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = v.primary_thumb_id --sqlIdSearchJoin where v.item_type>0 and v.rl_deleted=0 AND (INSTR(v.OWNERS,'|SFP2|')>0 OR INSTR(v.OWNERS,'|PSP|')>0 OR INSTR(v.OWNERS,'|PMS|')>0 OR INSTR(v.OWNERS,'|SFP1|')>0 OR INSTR(v.OWNERS,'|PMH|')>0 OR INSTR(v.OWNERS,'|PPL|')>0) and v.id in (select x.id from tmddba.tm_pg_rl x start with x.id in ( select a.id from (select m.id, rownum rnum from tmddba.tm_pg_rl m where item_type>0 and rl_deleted=0 and m.PGM_ABS_ID=:param_0 AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0) ) A WHERE rnum>=1 and rnum <= 9999 ) connect by nocycle prior x.parent_id=x.id) t Transfer: 1220 : 10|08:04:19.6457|RHSGU1|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:04:19.6457|RHSGU1|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:04:19.6457|RHSGU1|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|08:04:19.6457|RHSGU1|CJPOWERCAST|Running version search. User: 1165 Simple Search: Running Oracle search. Running Oracle search for COUNT Oracle count completed in: 12ms. Returned lines: 0 t Verbose: 1220 : 10|08:04:19.6457|RHSGU1|CJPOWERCAST|imfx v3 API took 0.021s '/api/v3/title/299390/versions?_dc=1669190658006' t Transfer: 1220 : 10|08:04:22.6607|FjC81B|CJPOWERCAST|OAuth: /api/v3/title/299541/versions?_dc=1669190660960 t Transfer: 1220 : 10|08:04:22.6607|FjC81B|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:04:22.6607|FjC81B|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:04:22.6607|FjC81B|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:04:22.6607|FjC81B|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|08:04:22.6607|FjC81B|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 10|08:04:22.6607|FjC81B|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:04:22.6607|FjC81B|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:04:22.6607|FjC81B|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:04:22.6607|FjC81B|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:04:22.6617|FjC81B|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:04:22.6617|FjC81B|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:04:22.6617|FjC81B|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:04:22.6617|FjC81B|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:04:22.6617|FjC81B|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|08:04:22.6617|FjC81B|CJPOWERCAST|SearchVersion SQL: select v.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE , (select min(name) from TM_CFG_AUDIO_CONTENT_MS_TYPES audio where v.audio_type = audio.id ) SOUND ,(select min(from_date_time) from TM_PG_RL_PROD_DATE prodDate where prodDate.Tm_Pg_Rl_Id = v.id ) PROD_FROM_DATE ,(select min(to_date_time) from TM_PG_RL_PROD_DATE prodDate where prodDate.Tm_Pg_Rl_Id = v.id ) PROD_TO_DATE ,(select min(full_name) from tm_lang_data lang, TM_PG_RL_LANG_LNX link where lang.id = link.lang_id and link.tm_pg_rl_id = v.id) PROD_LANGUAGE ,(SELECT min(COLOUR_NAME) FROM tm_cfg_colour_list list, tm_pg_rl ver where ver.col_mono = list.id and ver.id = v.id) PROD_COLOUR_TEXT ,(SELECT min(cfg.prod_date_type_name) FROM TM_PG_RL_PROD_DATE pg_rl, tm_cfg_prod_date_type cfg where cfg.id = pg_rl.PROD_DATE_TYPE_ID and TM_PG_RL_ID = v.id ) PROD_DATE_TYPE ,(select min(status.description) from TM_CFG_PGM_STATUS status where v.ITEM_STATUS_ID = status.id) PGM_STATUS_TEXT ,(select submed.sub_medium_name from TM_CFG_SUB_MEDIUM submed where v.SUB_MEDIUM_ID = submed.id) SUB_MEDIUM_TEXT, (select cvt.ID from TM_PORTAL_VERSION_CONFIG cvt where v.CUSTOM_VERSION_TYPE = cvt.CUSTOM_VERSION_TYPE AND cvt.CUSTOM_VERSION_TYPE IS NOT NULL ) MP_CONFIG_ID from tmddba.tm_pg_rl v left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = v.primary_thumb_id --sqlIdSearchJoin where v.item_type>0 and v.rl_deleted=0 AND (INSTR(v.OWNERS,'|SFP2|')>0 OR INSTR(v.OWNERS,'|PSP|')>0 OR INSTR(v.OWNERS,'|PMS|')>0 OR INSTR(v.OWNERS,'|SFP1|')>0 OR INSTR(v.OWNERS,'|PMH|')>0 OR INSTR(v.OWNERS,'|PPL|')>0) and v.id in (select x.id from tmddba.tm_pg_rl x start with x.id in ( select a.id from (select m.id, rownum rnum from tmddba.tm_pg_rl m where item_type>0 and rl_deleted=0 and m.PGM_ABS_ID=:param_0 AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0) ) A WHERE rnum>=1 and rnum <= 9999 ) connect by nocycle prior x.parent_id=x.id) t Transfer: 1220 : 10|08:04:22.6617|FjC81B|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:04:22.6617|FjC81B|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:04:22.6617|FjC81B|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|08:04:22.6617|FjC81B|CJPOWERCAST|Running version search. User: 1165 Simple Search: Running Oracle search. Running Oracle search for COUNT Oracle count completed in: 4ms. Returned lines: 0 t Verbose: 1220 : 10|08:04:22.6617|FjC81B|CJPOWERCAST|imfx v3 API took 0.012s '/api/v3/title/299541/versions?_dc=1669190660960' t Transfer: 1220 : 10|08:04:23.4657|ONMtaf|CJPOWERCAST|OAuth: /api/v3/title/299544/versions?_dc=1669190661701 t Transfer: 1220 : 10|08:04:23.4657|ONMtaf|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:04:23.4657|ONMtaf|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:04:23.4657|ONMtaf|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:04:23.4657|ONMtaf|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|08:04:23.4657|ONMtaf|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 10|08:04:23.4657|ONMtaf|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:04:23.4657|ONMtaf|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:04:23.4657|ONMtaf|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:04:23.4657|ONMtaf|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:04:23.4667|ONMtaf|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:04:23.4667|ONMtaf|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:04:23.4667|ONMtaf|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:04:23.4667|ONMtaf|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:04:23.4667|ONMtaf|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|08:04:23.4667|ONMtaf|CJPOWERCAST|SearchVersion SQL: select v.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE , (select min(name) from TM_CFG_AUDIO_CONTENT_MS_TYPES audio where v.audio_type = audio.id ) SOUND ,(select min(from_date_time) from TM_PG_RL_PROD_DATE prodDate where prodDate.Tm_Pg_Rl_Id = v.id ) PROD_FROM_DATE ,(select min(to_date_time) from TM_PG_RL_PROD_DATE prodDate where prodDate.Tm_Pg_Rl_Id = v.id ) PROD_TO_DATE ,(select min(full_name) from tm_lang_data lang, TM_PG_RL_LANG_LNX link where lang.id = link.lang_id and link.tm_pg_rl_id = v.id) PROD_LANGUAGE ,(SELECT min(COLOUR_NAME) FROM tm_cfg_colour_list list, tm_pg_rl ver where ver.col_mono = list.id and ver.id = v.id) PROD_COLOUR_TEXT ,(SELECT min(cfg.prod_date_type_name) FROM TM_PG_RL_PROD_DATE pg_rl, tm_cfg_prod_date_type cfg where cfg.id = pg_rl.PROD_DATE_TYPE_ID and TM_PG_RL_ID = v.id ) PROD_DATE_TYPE ,(select min(status.description) from TM_CFG_PGM_STATUS status where v.ITEM_STATUS_ID = status.id) PGM_STATUS_TEXT ,(select submed.sub_medium_name from TM_CFG_SUB_MEDIUM submed where v.SUB_MEDIUM_ID = submed.id) SUB_MEDIUM_TEXT, (select cvt.ID from TM_PORTAL_VERSION_CONFIG cvt where v.CUSTOM_VERSION_TYPE = cvt.CUSTOM_VERSION_TYPE AND cvt.CUSTOM_VERSION_TYPE IS NOT NULL ) MP_CONFIG_ID from tmddba.tm_pg_rl v left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = v.primary_thumb_id --sqlIdSearchJoin where v.item_type>0 and v.rl_deleted=0 AND (INSTR(v.OWNERS,'|SFP2|')>0 OR INSTR(v.OWNERS,'|PSP|')>0 OR INSTR(v.OWNERS,'|PMS|')>0 OR INSTR(v.OWNERS,'|SFP1|')>0 OR INSTR(v.OWNERS,'|PMH|')>0 OR INSTR(v.OWNERS,'|PPL|')>0) and v.id in (select x.id from tmddba.tm_pg_rl x start with x.id in ( select a.id from (select m.id, rownum rnum from tmddba.tm_pg_rl m where item_type>0 and rl_deleted=0 and m.PGM_ABS_ID=:param_0 AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0) ) A WHERE rnum>=1 and rnum <= 9999 ) connect by nocycle prior x.parent_id=x.id) t Transfer: 1220 : 10|08:04:23.4667|ONMtaf|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:04:23.4667|ONMtaf|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:04:23.4667|ONMtaf|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|08:04:23.4667|ONMtaf|CJPOWERCAST|Running version search. User: 1165 Simple Search: Running Oracle search. Running Oracle search for COUNT Oracle count completed in: 4ms. Returned lines: 1 Oracle version search timing: 80ms. SQL run: select v.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE , (select min(name) from TM_CFG_AUDIO_CONTENT_MS_TYPES audio where v.audio_type = audio.id ) SOUND ,(select min(from_date_time) from TM_PG_RL_PROD_DATE prodDate where prodDate.Tm_Pg_Rl_Id = v.id ) PROD_FROM_DATE ,(select min(to_date_time) from TM_PG_RL_PROD_DATE prodDate where prodDate.Tm_Pg_Rl_Id = v.id ) PROD_TO_DATE ,(select min(full_name) from tm_lang_data lang, TM_PG_RL_LANG_LNX link where lang.id = link.lang_id and link.tm_pg_rl_id = v.id) PROD_LANGUAGE ,(SELECT min(COLOUR_NAME) FROM tm_cfg_colour_list list, tm_pg_rl ver where ver.col_mono = list.id and ver.id = v.id) PROD_COLOUR_TEXT ,(SELECT min(cfg.prod_date_type_name) FROM TM_PG_RL_PROD_DATE pg_rl, tm_cfg_prod_date_type cfg where cfg.id = pg_rl.PROD_DATE_TYPE_ID and TM_PG_RL_ID = v.id ) PROD_DATE_TYPE ,(select min(status.description) from TM_CFG_PGM_STATUS status where v.ITEM_STATUS_ID = status.id) PGM_STATUS_TEXT ,(select submed.sub_medium_name from TM_CFG_SUB_MEDIUM submed where v.SUB_MEDIUM_ID = submed.id) SUB_MEDIUM_TEXT, (select cvt.ID from TM_PORTAL_VERSION_CONFIG cvt where v.CUSTOM_VERSION_TYPE = cvt.CUSTOM_VERSION_TYPE AND cvt.CUSTOM_VERSION_TYPE IS NOT NULL ) MP_CONFIG_ID from tmddba.tm_pg_rl v left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = v.primary_thumb_id --sqlIdSearchJoin where v.item_type>0 and v.rl_deleted=0 AND (INSTR(v.OWNERS,'|SFP2|')>0 OR INSTR(v.OWNERS,'|PSP|')>0 OR INSTR(v.OWNERS,'|PMS|')>0 OR INSTR(v.OWNERS,'|SFP1|')>0 OR INSTR(v.OWNERS,'|PMH|')>0 OR INSTR(v.OWNERS,'|PPL|')>0) and v.id in (select x.id from tmddba.tm_pg_rl x start with x.id in ( select a.id from (select m.id, rownum rnum from tmddba.tm_pg_rl m where item_type>0 and rl_deleted=0 and m.PGM_ABS_ID=:param_0 AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0) ) A WHERE rnum>=1 and rnum <= 9999 ) connect by nocycle prior x.parent_id=x.id) t Verbose: 1220 : 10|08:04:23.4667|ONMtaf|CJPOWERCAST|imfx v3 API took 0.094s '/api/v3/title/299544/versions?_dc=1669190661701' t Transfer: 1220 : 10|08:04:23.8697|ZcIBHa|CJPOWERCAST|OAuth: /api/v3/version/299545/media?_dc=1669190662119 t Transfer: 1220 : 10|08:04:23.8697|ZcIBHa|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:04:23.8697|ZcIBHa|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:04:23.8697|ZcIBHa|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:04:23.8697|ZcIBHa|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|08:04:23.8697|ZcIBHa|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 10|08:04:23.8707|T5uvZT|CJPOWERCAST|OAuth: /api/v3/version/299545/media?_dc=1669190662137 t Transfer: 1220 : 10|08:04:23.8707|T5uvZT|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:04:23.8707|T5uvZT|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:04:23.8707|T5uvZT|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:04:23.8707|T5uvZT|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|08:04:23.8707|T5uvZT|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 10|08:04:23.8707|ZcIBHa|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:04:23.8707|ZcIBHa|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:04:23.8707|ZcIBHa|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:04:23.8717|T5uvZT|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:04:23.8717|T5uvZT|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:04:23.8717|T5uvZT|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|08:04:23.8717|ZcIBHa|CJPOWERCAST|MediaSearch SQL: select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type in (1,110)),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , (SELECT min(status.ACCESS_STATUS_NAME) FROM TMDDBA.TM_ACCESS_STATUS statusLnx, TM_CFG_ACCESS_STATUS status WHERE statusLnx.Media_Id = r.id and statusLnx.Status_Id = status.id) ACCESS_STATUS , (select min(acq.ext_ref) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) CONSIGNMENT_NUMBER , (select min(acq.alt_id1) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) TRANSFER_NUMBER , (select min(crs.series_number) from tm_series_data crs where crs.id = r.GROUP_SERIES_ID) CRS_SERIES , (select min(DISPOSAL_NAME) from TM_ACQ_DISPOSAL status, tm_disposal_records records where status.id = records.disposal_status_id and records.miid = r.id) DISPOSAL_STATUS , (select min(class.class_number) from TM_ACQ_DISPOSAL status, tm_disposal_records records, tm_disposal_classes class where status.id = records.disposal_status_id and records.miid = r.id and class.id = records.disposal_class_id) DISPOSAL_CLASS, (select min(names.concat_search_name) from tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names where r.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY, (select min(c.u_id_ext1) from tmddba.tm_mi_tpi_lnx lnx, tm_ctnrs c where c.u_id = lnx.tpiid and lnx.miid = r.id) U_ID_EXT1 , (select t.name from TM_CFG_MI_FMT_TYP t where t.id = r.mi_fmt_type) ITEM_FORMAT_TEXT, CASE WHEN BITAND(r.COMPIL, 2) = 2 THEN 'SUPPLIED' WHEN BITAND(r.COMPIL, 4) = 4 THEN 'MADE' WHEN BITAND(r.COMPIL, 134217728) = 134217728 THEN 'IMPORTED' ELSE '' END AS ORIGIN, CASE WHEN BITAND(r.COMPIL, 512) = 512 THEN 'Attached' WHEN BITAND(r.COMPIL, 1024) = 1024 THEN 'Un-Attached' ELSE '' END AS FLAGS, (select min(lang.full_name) from TM_PG_RL_LANG_LNX lnx, TM_LANG_DATA lang where lnx.tm_pg_rl_id = r.pgm_parent_id and lnx.lang_id = lang.id) AS PROD_LANGUAGE , (select min(ctx.ITFC_CODE) from tm_mis mis, tm_mi_tpi_lnx links, tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names where mis.id = r.id and links.miid = mis.id and mis.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY_NUMBER, (select min(status.description) from TM_CFG_PGM_STATUS status where r.status = status.id) PGM_STATUS_TEXT, (select min(ver.DUR) from TM_PG_RL ver where r.pgm_PARENT_ID = ver.id) AS VERSION_DUR , (select tmd_str_agg_pipe(cms.status_type_id ||',' ||cms.status_id) from tm_mi_cust_med_stat_lnx cms where cms.media_id=r.id) "CustomStatusesRaw", (select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = r.net_grp_id) CHANNEL_GROUP, (SELECT SUBSTR( trim( replace (replace ( LISTAGG(trim(tt.tags || ' ' || tt.notes), ' ') WITHIN GROUP (ORDER BY trim(tt.tags || ' ' || tt.notes)), chr (13), ''), chr (10), ' ')), 1, 150) z FROM tm_media_tagging tt WHERE link_guid = DFILE_LINK_GUID and rownum=1) TAGS_TEXT , GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select a.*, rownum rnum from (select m.*, coalesce(m.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=m.pgm_parent_id)) primary_thumb_id2 from tmddba.tm_mis m where media_type>0 and item_type>0 AND 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) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl where rnum >= 1 order by rnum t Information: 1220 : 10|08:04:23.8727|T5uvZT|CJPOWERCAST|MediaSearch SQL: select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type in (1,110)),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , (SELECT min(status.ACCESS_STATUS_NAME) FROM TMDDBA.TM_ACCESS_STATUS statusLnx, TM_CFG_ACCESS_STATUS status WHERE statusLnx.Media_Id = r.id and statusLnx.Status_Id = status.id) ACCESS_STATUS , (select min(acq.ext_ref) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) CONSIGNMENT_NUMBER , (select min(acq.alt_id1) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) TRANSFER_NUMBER , (select min(crs.series_number) from tm_series_data crs where crs.id = r.GROUP_SERIES_ID) CRS_SERIES , (select min(DISPOSAL_NAME) from TM_ACQ_DISPOSAL status, tm_disposal_records records where status.id = records.disposal_status_id and records.miid = r.id) DISPOSAL_STATUS , (select min(class.class_number) from TM_ACQ_DISPOSAL status, tm_disposal_records records, tm_disposal_classes class where status.id = records.disposal_status_id and records.miid = r.id and class.id = records.disposal_class_id) DISPOSAL_CLASS, (select min(names.concat_search_name) from tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names where r.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY, (select min(c.u_id_ext1) from tmddba.tm_mi_tpi_lnx lnx, tm_ctnrs c where c.u_id = lnx.tpiid and lnx.miid = r.id) U_ID_EXT1 , (select t.name from TM_CFG_MI_FMT_TYP t where t.id = r.mi_fmt_type) ITEM_FORMAT_TEXT, CASE WHEN BITAND(r.COMPIL, 2) = 2 THEN 'SUPPLIED' WHEN BITAND(r.COMPIL, 4) = 4 THEN 'MADE' WHEN BITAND(r.COMPIL, 134217728) = 134217728 THEN 'IMPORTED' ELSE '' END AS ORIGIN, CASE WHEN BITAND(r.COMPIL, 512) = 512 THEN 'Attached' WHEN BITAND(r.COMPIL, 1024) = 1024 THEN 'Un-Attached' ELSE '' END AS FLAGS, (select min(lang.full_name) from TM_PG_RL_LANG_LNX lnx, TM_LANG_DATA lang where lnx.tm_pg_rl_id = r.pgm_parent_id and lnx.lang_id = lang.id) AS PROD_LANGUAGE , (select min(ctx.ITFC_CODE) from tm_mis mis, tm_mi_tpi_lnx links, tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names where mis.id = r.id and links.miid = mis.id and mis.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY_NUMBER, (select min(status.description) from TM_CFG_PGM_STATUS status where r.status = status.id) PGM_STATUS_TEXT, (select min(ver.DUR) from TM_PG_RL ver where r.pgm_PARENT_ID = ver.id) AS VERSION_DUR , (select tmd_str_agg_pipe(cms.status_type_id ||',' ||cms.status_id) from tm_mi_cust_med_stat_lnx cms where cms.media_id=r.id) "CustomStatusesRaw", (select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = r.net_grp_id) CHANNEL_GROUP, (SELECT SUBSTR( trim( replace (replace ( LISTAGG(trim(tt.tags || ' ' || tt.notes), ' ') WITHIN GROUP (ORDER BY trim(tt.tags || ' ' || tt.notes)), chr (13), ''), chr (10), ' ')), 1, 150) z FROM tm_media_tagging tt WHERE link_guid = DFILE_LINK_GUID and rownum=1) TAGS_TEXT , GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select a.*, rownum rnum from (select m.*, coalesce(m.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=m.pgm_parent_id)) primary_thumb_id2 from tmddba.tm_mis m where media_type>0 and item_type>0 AND 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) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl where rnum >= 1 order by rnum t Verbose: 1220 : 10|08:04:24.2747|ZcIBHa|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 : 10|08:04:24.2747|T5uvZT|CJPOWERCAST|Alternative title fields query: select * from (select x.id,x.pgm_abs_id TitleId, x.pgm_parent_id VersionId from tm_mis x where id in (select /*+ cardinality(4) */ column_value id from table(:ids))) y,lateral (select dbms_lob.substr( o.text_data_plain, 1000, 1 ) Field_5799344 from tm_txt_obj o where (o.pgm_abs_id=y.TitleId or o.pgm_rl_id = y.VersionId) and o.type_id=:param_1 order by o.id desc fetch first 1 rows only)(+) t Information: 1220 : 10|08:04:24.2747|ZcIBHa|CJPOWERCAST| timing: 00:00:00.5359322 t Verbose: 1220 : 10|08:04:24.2747|ZcIBHa|CJPOWERCAST|imfx v3 API took 0.537s '/api/v3/version/299545/media?_dc=1669190662119' t Information: 1220 : 10|08:04:24.2747|T5uvZT|CJPOWERCAST| timing: 00:00:00.5205341 t Verbose: 1220 : 10|08:04:24.2747|T5uvZT|CJPOWERCAST|imfx v3 API took 0.521s '/api/v3/version/299545/media?_dc=1669190662137' t Transfer: 1220 : 10|08:04:24.2747|ZcIBHa|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0178.mp4 subfolder t Transfer: 1220 : 10|08:04:24.2747|ZcIBHa|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0178.mp4 t Transfer: 1220 : 10|08:04:24.2747|ZcIBHa|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0178.mp4 t Transfer: 1220 : 10|08:04:24.2757|ZcIBHa|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:04:24.2757|ZcIBHa|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:04:24.2757|ZcIBHa|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:04:24.2757|T5uvZT|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0178.mp4 subfolder t Transfer: 1220 : 10|08:04:24.2757|T5uvZT|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0178.mp4 t Transfer: 1220 : 10|08:04:24.2757|T5uvZT|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0178.mp4 t Transfer: 1220 : 10|08:04:24.2757|T5uvZT|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:04:24.2757|T5uvZT|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:04:24.2757|T5uvZT|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:04:24.2757|ZcIBHa|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001992.mp4 subfolder t Transfer: 1220 : 10|08:04:24.2757|ZcIBHa|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001992.mp4 t Transfer: 1220 : 10|08:04:24.2757|ZcIBHa|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001992.mp4 t Transfer: 1220 : 10|08:04:24.2767|ZcIBHa|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:04:24.2767|ZcIBHa|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:04:24.2767|ZcIBHa|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:04:24.2767|T5uvZT|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001992.mp4 subfolder t Transfer: 1220 : 10|08:04:24.2767|T5uvZT|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001992.mp4 t Transfer: 1220 : 10|08:04:24.2767|T5uvZT|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001992.mp4 t Transfer: 1220 : 10|08:04:24.2767|T5uvZT|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:04:24.2767|T5uvZT|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:04:24.2767|T5uvZT|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:04:24.2767|ZcIBHa|CJPOWERCAST|GetUrl. Storage |Temp Storage| filename C:\TEMP\N0001992.mp4 subfolder t Transfer: 1220 : 10|08:04:24.2767|ZcIBHa|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:04:24.2767|ZcIBHa|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:04:24.2777|ZcIBHa|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:04:24.2777|T5uvZT|CJPOWERCAST|GetUrl. Storage |Temp Storage| filename C:\TEMP\N0001992.mp4 subfolder t Transfer: 1220 : 10|08:04:24.2777|T5uvZT|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:04:24.2777|T5uvZT|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:04:24.2777|T5uvZT|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:04:24.2777|ZcIBHa|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0178.xml subfolder t Transfer: 1220 : 10|08:04:24.2777|ZcIBHa|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0178.xml t Transfer: 1220 : 10|08:04:24.2777|ZcIBHa|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0178.xml t Transfer: 1220 : 10|08:04:24.2777|ZcIBHa|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:04:24.2777|ZcIBHa|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:04:24.2777|ZcIBHa|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:04:24.2777|T5uvZT|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0178.xml subfolder t Transfer: 1220 : 10|08:04:24.2777|T5uvZT|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0178.xml t Transfer: 1220 : 10|08:04:24.2787|T5uvZT|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0178.xml t Transfer: 1220 : 10|08:04:24.2787|T5uvZT|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:04:24.2787|T5uvZT|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:04:24.2787|T5uvZT|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:04:24.6807|t4fzuE|CJPOWERCAST|OAuth: /api/v3/media/299534/carriers/digital?_dc=1669190662961 t Transfer: 1220 : 10|08:04:24.6807|t4fzuE|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:04:24.6807|t4fzuE|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:04:24.6807|t4fzuE|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:04:24.6807|t4fzuE|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|08:04:24.6807|t4fzuE|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 10|08:04:24.6807|t4fzuE|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:04:24.6807|t4fzuE|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:04:24.6807|t4fzuE|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:04:24.6807|t4fzuE|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:04:24.6817|t4fzuE|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:04:24.6817|t4fzuE|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:04:24.6817|Smp5Af|CJPOWERCAST|OAuth: /api/v3/media/299534/carriers/digital?_dc=1669190663028 t Transfer: 1220 : 10|08:04:24.6817|Smp5Af|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:04:24.6817|Smp5Af|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:04:24.6817|Smp5Af|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|08:04:24.6817|Smp5Af|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|08:04:24.6817|Smp5Af|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 10|08:04:24.6817|Smp5Af|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:04:24.6817|Smp5Af|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:04:24.6817|Smp5Af|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|08:04:24.6817|Smp5Af|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|08:04:24.6827|Smp5Af|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|08:04:24.6827|Smp5Af|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|08:04:24.8837|t4fzuE|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 Information: 1220 : 10|08:04:24.8837|Smp5Af|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 : 10|08:04:25.0847|t4fzuE|CJPOWERCAST|imfx v3 API took 0.334s '/api/v3/media/299534/carriers/digital?_dc=1669190662961' t Verbose: 1220 : 10|08:04:25.0847|Smp5Af|CJPOWERCAST|imfx v3 API took 0.277s '/api/v3/media/299534/carriers/digital?_dc=1669190663028' t Transfer: 1220 : 10|14:19:10.0330|7xHEv1||GetAppInfo. DB: TMDDEMO. Install mode: . Auth types: Native, PublicApiKey t Information: 1220 : 10|14:19:10.2340|Rt7lUK||GetCache. t Information: 1220 : 10|14:19:10.2340|Rt7lUK||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\108_2_PnqJC_.png t Information: 1220 : 10|14:19:10.2340|Rt7lUK||GetCache. Data read: 154944 t Verbose: 1220 : 10|14:19:10.2340|Rt7lUK||imfx v3 API took 0.006s '/api/v3/visual-asset/group/PnqJC_/2/image' t Transfer: 1220 : 10|19:27:33.5419|qRXrOC||GetAppInfo. DB: TMDDEMO. Install mode: . Auth types: Native, PublicApiKey t Information: 1220 : 10|19:27:33.7430|EYoTWb||GetCache. t Information: 1220 : 10|19:27:33.7430|EYoTWb||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\108_2_PnqJC_.png t Information: 1220 : 10|19:27:33.7430|EYoTWb||GetCache. Data read: 154944 t Verbose: 1220 : 10|19:27:33.7430|EYoTWb||imfx v3 API took 0.016s '/api/v3/visual-asset/group/PnqJC_/2/image'