t Information: 1220 : 12|00:54:06.6943|||Get Configuration Values: t Information: 1220 : 12|00:54:06.6943||| AdminPassEnc, default: , value: ffqjrn0leKv4Lj2YJHe2dw==. t Information: 1220 : 12|00:54:06.6943||| EncryptedPasswords, default: true, value: true. t Information: 1220 : 12|00:54:06.6943||| OraConnectionString, default: , value: Server=TECHM;User Id=imfx;Password=xxxxx;Unicode=true;. t Information: 1220 : 12|00:54:06.6943||| SecondTimezone, default: , value: . t Information: 1220 : 12|00:54:06.6943||| UseActiveDirectoryAuth, default: false, value: false. t Information: 1220 : 12|00:54:06.6943||| ReportingServiceUrl, default: , value: http://localhost:92/ReportingService.svc. t Information: 1220 : 12|00:54:06.6943||| ReportsPath, default: , value: . t Information: 1220 : 12|00:54:06.6943||| ReportsURL, default: , value: . t Information: 1220 : 12|00:54:06.6943||| TapeServiceUrl, default: , value: . t Information: 1220 : 12|00:54:06.6943||| GatekeeperUrl, default: , value: . t Information: 1220 : 12|00:54:06.6943||| ValuationUrl, default: , value: . t Information: 1220 : 12|00:54:06.6943||| QueueManagerDelay, default: 30, value: 30. t Information: 1220 : 12|00:54:06.6943||| QueueManagerFullRefresh, default: 90, value: 90. t Information: 1220 : 12|00:54:06.6943||| AudioLoopDuration, default: 0, value: 150. t Information: 1220 : 12|00:54:06.6943||| AudioLoopsCount, default: 0, value: 0. t Information: 1220 : 12|00:54:06.6943||| PlayerFakeStep, default: 500, value: 500. t Information: 1220 : 12|00:54:06.6943||| PlayerForceRatio, default: 0, value: 1. t Information: 1220 : 12|00:54:06.6943||| CheckVersionsInProd, default: false, value: True. t Information: 1220 : 12|00:54:06.6943||| MaxResults, default: 3000, value: 10000. t Information: 1220 : 12|00:54:06.6943||| TEReportID, default: 0, value: 0. t Information: 1220 : 12|00:54:06.6943||| ClosedCaptionsCache, default: , value: C:\inetpub\wwwroot\imfxcore\timedtextcache\. t Information: 1220 : 12|00:54:06.6943||| ClosedCaptionsStorage, default: , value: c:\Mediaflex\subs. t Information: 1220 : 12|00:54:06.6943||| TimeCodeFormat, default: , value: pal. t Information: 1220 : 12|00:54:06.6943||| RceMediaPath, default: , value: C:\edl\. t Information: 1220 : 12|00:54:06.6943||| RceMediaPath, default: , value: C:\edl\. t Information: 1220 : 12|00:54:06.6943||| RceCsmOutputPath, default: , value: C:\Inetpub\wwwroot\csm\. t Information: 1220 : 12|00:54:06.6943||| RceCsmUrl, default: , value: http://localhost/csm/. t Information: 1220 : 12|00:54:06.6943||| RceMediaSelection, default: , value: miLinkIdMatch. t Information: 1220 : 12|00:54:06.6943||| RequestBrowseJobPresetName, default: , value: . t Information: 1220 : 12|00:54:06.6943||| DontExtendDuration, default: false, value: False. t Information: 1220 : 12|00:54:06.6943||| V3ConfigUrl, default: , value: . t Information: 1220 : 12|00:54:06.6943||| StopWords, default: , value: . t Information: 1220 : 12|00:54:06.6943||| MisrTxFormat, default: G, value: G. t Information: 1220 : 12|00:54:06.6943||| ApiServer, default: , value: http://192.168.120.10:85. t Information: 1220 : 12|00:54:06.6943||| ApiTimeout, default: 120, value: 120. t Information: 1220 : 12|00:54:06.6943||| ApiWorkers, default: 10, value: 10. t Information: 1220 : 12|00:54:06.6943||| UsePerfCounters, default: false, value: false. t Information: 1220 : 12|00:54:06.6943||| LogGetCurrentUser, default: true, value: true. t Information: 1220 : 12|00:54:06.6943||| LogInternalApi, default: true, value: true. t Information: 1220 : 12|00:54:06.6943||| LivePlayApiUrl, default: , value: . t Information: 1220 : 12|00:54:06.6943||| LivePlayApiTimeout, default: 120, value: 120. t Information: 1220 : 12|00:54:06.6943||| ThumbnailServer, default: , value: . t Information: 1220 : 12|00:54:06.6943||| PasswordResetEmailTemplateId, default: 0, value: 0. t Information: 1220 : 12|00:54:06.6943||| PasswordResetEmailTemplateId_MediaPortal, default: 0, value: 0. t Information: 1220 : 12|00:54:06.6943||| imfxBaseUrl, default: , value: . t Information: 1220 : 12|00:54:06.6943||| imfxBaseUrl_MediaPortal, default: , value: . t Information: 1220 : 12|00:54:06.6943||| imfxBaseUrl_VideoBrowser, default: , value: . t Information: 1220 : 12|00:54:06.6943||| ShowDetailedErrors, default: false, value: false. t Information: 1220 : 12|00:54:06.6943||| AllowXmlRequests, default: false, value: false. t Information: 1220 : 12|00:54:06.6943||| MaxLoginAttempts, default: 3, value: 3. t Information: 1220 : 12|00:54:06.6943||| MaxLoginAttemptsPeriod, default: 15, value: 15. t Information: 1220 : 12|00:54:06.6943||| AllowRaisePreviewInMiSR, default: false, value: false. t Information: 1220 : 12|00:54:06.6943||| LocationFilter, default: , value: . t Information: 1220 : 12|00:54:06.6943||| SvUtilServiceUrl, default: , value: . t Information: 1220 : 12|00:54:06.6943||| SolrConnection, default: , value: http://192.168.120.14:8983/solr. t Information: 1220 : 12|00:54:06.6943||| UseIndexServerSearch, default: false, value: True. t Information: 1220 : 12|00:54:06.6943||| SolrIndexVersion, default: 1, value: 6. t Information: 1220 : 12|00:54:06.6943||| SolrConnection, default: , value: http://192.168.120.14:8983/solr. t Information: 1220 : 12|00:54:06.6943||| FacetsGroups, default: , value: owners,season_id, series_id,version_key,item_type,media_type,media_format,episode_number. t Information: 1220 : 12|00:54:06.6943||| FacetsGroupsVersion, default: , value: owners,season_id, series_id,version_key,episode_number. t Information: 1220 : 12|00:54:06.6943||| FacetsGroupsChameleon, default: , value: season_id, series_id,genre,prod_year,version_key. t Information: 1220 : 12|00:54:06.6943||| PreviewPreset, default: , value: . t Information: 1220 : 12|00:54:06.6943||| DevMode, default: false, value: false. t Information: 1220 : 12|00:54:06.6943||| DisableSysMan, default: false, value: false. t Information: 1220 : 12|00:54:06.6943||| TimeCodeFormat, default: , value: pal. t Information: 1220 : 12|00:54:06.7099||| FileCatalystStorageDevice, default: , value: . t Information: 1220 : 12|00:54:06.7099||| UseResponsibilityTracking, default: true, value: True. t Information: 1220 : 12|00:54:06.7099||| SubtitleDeviceFilter, default: , value: . t Information: 1220 : 12|00:54:06.7099||| SystemMonitorNamedPipe, default: , value: . t Information: 1220 : 12|00:54:06.7099||| OracleMonitorEnable, default: false, value: False. t Information: 1220 : 12|00:54:06.7099||| ArcApiHost, default: , value: . t Information: 1220 : 12|00:54:06.7099||| SolrTimedTextSearch, default: false, value: false. t Information: 1220 : 12|00:54:06.7099||| ProductionDurationUsageID, default: 1, value: 1. t Information: 1220 : 12|00:54:06.7099||| MediaFacetOrder, default: ResultCountAsc, value: ResultCountAsc. t Information: 1220 : 12|00:54:06.7099||| VersionFacetOrder, default: ResultCountAsc, value: ResultCountAsc. t Information: 1220 : 12|00:54:07.1237|||GetStreamServers.. t Information: 1220 : 12|00:54:07.7522||| https://demo.tmd.tv/CBR Video/ |CBR Video| False t Information: 1220 : 12|00:54:07.7522||| https://demo.tmd.tv/CBR Images/ |CBR Images| False t Information: 1220 : 12|00:54:07.7522||| https://demo.tmd.tv/CBR Audio/ |CBR Audio| False t Information: 1220 : 12|00:54:07.7522||| https://demo.tmd.tv/Temp Upload/ |TEMP_UPLOAD| False t Information: 1220 : 12|00:54:07.7522||| http://localhost:82/images/ |IMAGES| False t Information: 1220 : 12|00:54:07.7522||| http://192.168.91.73/smoothcloud/ |SMOOTH_CLOUD| False t Information: 1220 : 12|00:54:07.7522||| http://192.168.91.73/cloudstore/ |CLOUD_STORE| False t Information: 1220 : 12|00:54:07.7522||| http://192.168.91.73/editsystemin/ |EDIT_SYSTEM_IN| False t Information: 1220 : 12|00:54:07.7522||| http://192.168.91.27:89/APPLEPROXY/ |APPLE_PROXY| False t Information: 1220 : 12|00:54:07.7522||| http://localhost:82/video/ |FILESTORE_VIDEO| False t Information: 1220 : 12|00:54:07.7522||| https://imfxv3tm.tmd.tv/streaming/ |Streaming| False t Information: 1220 : 12|00:54:07.7522||| https://imfxv3tm.tmd.tv/VideoServer/ |Video| False t Information: 1220 : 12|00:54:07.7522||| https://imfxv3tm.tmd.tv/Proxy/ |Proxy| False t Information: 1220 : 12|00:54:07.7522||| https://imfxv3tm.tmd.tv/AdobeIn/ |Adobe Premiere Pro In| False t Information: 1220 : 12|00:54:07.7522||| https://imfxv3tm.tmd.tv/AudioServer/ |Audio| False t Information: 1220 : 12|00:54:07.7522||| https://imfxv3tm.tmd.tv/ImageServer/ |Image| False t Information: 1220 : 12|00:54:07.7522||| https://imfxv3tm.tmd.tv/DocsServer/ |Docs| False t Information: 1220 : 12|00:54:07.7522||| https://imfxv3tm.tmd.tv/AmazonLabs/ |TEST HOUSE| False t Information: 1220 : 12|00:54:07.7522||| SolrConnectionUms, default: http://192.168.120.14:8983/solr, value: http://192.168.120.14:8983/solr. t Information: 1220 : 12|00:54:07.7522||| LogWebApi, default: false, value: false. t Information: 1220 : 12|00:54:07.7522||| EmbeddedRceUrl, default: , value: . t Information: 1220 : 12|00:54:07.7522||| InstallMode, default: , value: . t Information: 1220 : 12|00:54:07.7522||| SamlRequestAddress, default: , value: . t Information: 1220 : 12|00:54:07.7522||| SamlTrustedIssuer, default: , value: . t Information: 1220 : 12|00:54:07.7522||| SamlLoginRedirect, default: , value: . t Information: 1220 : 12|00:54:07.7522||| NaturalLangSearch, default: false, value: True. t Information: 1220 : 12|00:54:07.7522||| LocalUploadExpirationHours, default: 0, value: 0. t Information: 1220 : 12|00:54:07.7522||| LocalUploadDeviceId, default: 0, value: 0. t Information: 1220 : 12|00:54:07.7522||| VideosFileFormatIds, default: , value: . t Information: 1220 : 12|00:54:07.7522||| VideosStorageIds, default: , value: . t Information: 1220 : 12|00:54:07.7522||| OktaLoginField, default: , value: . t Information: 1220 : 12|00:54:07.7522||| AuthenticationTypes, default: , value: Native,PublicApiKey. t Information: 1220 : 12|00:54:07.7522|||OrabitWatcherBasic. Initialize. t Information: 1220 : 12|00:54:07.7522|||FillDictionaryCache. t Information: 1220 : 12|00:54:12.7993|||OrabitWatcherBasic trying to connect.. t Information: 1220 : 12|00:54:12.7993|||OrabitWatcherBasic connected. t Information: 1220 : 12|00:54:12.7993|||OrabitWatcherBasic queue created tmd.cfg.in.286bce68-d429-4886-84c6-8841cfdd9a3d t Information: 1220 : 12|00:54:13.2212|||GetSupportedOperators t Information: 1220 : 12|00:54:13.6274|||CacheTechReports. t Information: 1220 : 12|00:54:14.1118|||& Cache update. Server (global) filled with timestamp 12:09:13.8305713. types null t Information: 1220 : 12|00:54:14.1118|||InitializeFromDatabase. 'Server=TECHM;User Id=imfx;password=..;Unicode=true;' direct False, home , timeout 15 t Information: 1220 : 12|00:54:14.1118|||FillDictionaryCache. t Information: 1220 : 12|00:54:14.1118|||& Cache update. Server (global) filled with timestamp 12:09:13.8774493. types FriendlyNames, DatabaseSearchFieldData t Information: 1220 : 12|00:54:14.6430|||========================================================================== t Information: 1220 : 12|00:54:14.6430|||IMFX CORE SERVER APPLICATION START. t Information: 1220 : 12|00:54:14.6430|||DLL VERSION: 3.0.0.1034. t Information: 1220 : 12|00:54:14.6430|||IS TIMER HIGH RESOLUTION : True. t Information: 1220 : 12|00:54:14.6430||| UmsDev, default: False, value: False. t Transfer: 1220 : 12|05:33:13.1893|Bx1D8b||OAuth: /api/logout?_dc=1693974814550 t Transfer: 1220 : 12|05:33:13.1893|Bx1D8b||GetCurrentUser.. t Transfer: 1220 : 12|05:33:13.1893|Bx1D8b|| OAuth authenticated t Verbose: 1220 : 12|05:33:13.1893|Bx1D8b|| uid claim is missing.. t Information: 1220 : 12|05:33:13.1893|Bx1D8b||OAuth. AutoLogin no Windows identity type WindowsIdentity t Transfer: 1220 : 12|05:33:13.5956|c~FVKT||GetAppInfo. DB: TMDDEMO. Install mode: . Auth types: Native, PublicApiKey t Information: 1220 : 12|05:33:14.2050|koEWr4||GetCache. t Information: 1220 : 12|05:33:14.2050|koEWr4||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\108_2_PnqJC_.png t Information: 1220 : 12|05:33:14.2050|koEWr4||GetCache. Data read: 154944 t Verbose: 1220 : 12|05:33:14.2050|koEWr4||imfx v3 API took 0.205s '/api/v3/visual-asset/group/PnqJC_/2/image' t Verbose: 1220 : 12|05:33:15.6282|njFVr_||Oauth validating.. t Verbose: 1220 : 12|05:33:15.6282|njFVr_||GrantResourceOwnerCredentials. t Verbose: 1220 : 12|05:33:15.6282|njFVr_||LoginUser. cjpowercast, login type OAuth, encrypt password True t Information: 1220 : 12|05:33:15.6282|njFVr_||TryLoginUser. cjpowercast, login type OAuth, check password True, check hash False, encrypt password True, load user data False t Information: 1220 : 12|05:33:16.0327|njFVr_|| oauth token 00000000-0000-0000-0000-000000000000 t Information: 1220 : 12|05:33:16.0327|njFVr_||TryLoginUser. Logged in.. t Information: 1220 : 12|05:33:16.0327|njFVr_||GetPasswordPolicy. WARNING: Policy not found for system Imediaflex. Validation disabled. t Verbose: 1220 : 12|05:33:16.0327|njFVr_||LoginUser. Adding history. User Id 1165, result CJPOWERCAST, host 192.168.127.6 t Verbose: 1220 : 12|05:33:16.0327|njFVr_||GrantResourceOwnerCredentials. Try login finished. Logged: True t Transfer: 1220 : 12|05:33:16.4412|Eyvpnt|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=1693974817907 t Transfer: 1220 : 12|05:33:16.4412|Eyvpnt|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:16.4412|Eyvpnt|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:16.4412|Eyvpnt|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:33:16.4412|Eyvpnt|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|05:33:16.4412|Eyvpnt|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:16.4412|Eyvpnt|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:16.4412|Eyvpnt|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:33:16.4412|Eyvpnt|CJPOWERCAST|imfx v3 API took 0.046s '/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=1693974817907' t Transfer: 1220 : 12|05:33:16.8475|jgz3NY|CJPOWERCAST|OAuth: /api/user-preferences?keys=personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch;workflow_queues_actions;workflow_queues_settings&_dc=1693974818256 t Transfer: 1220 : 12|05:33:16.8475|jgz3NY|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:16.8475|jgz3NY|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:16.8475|jgz3NY|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:33:16.8475|jgz3NY|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|05:33:16.8475|jgz3NY|CJPOWERCAST|GetUserDataByKeys: personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch;workflow_queues_actions;workflow_queues_settings t Transfer: 1220 : 12|05:33:16.8475|jgz3NY|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:16.8475|jgz3NY|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:16.8475|jgz3NY|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:33:16.8475|jgz3NY|CJPOWERCAST|imfx v3 API took 0.041s '/api/user-preferences?keys=personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch;workflow_queues_actions;workflow_queues_settings&_dc=1693974818256' t Information: 1220 : 12|05:33:17.0560|VkmtLX|CJPOWERCAST|GetUserProfile. Id: 0 t Transfer: 1220 : 12|05:33:17.0560|VkmtLX|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:17.0560|VkmtLX|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:17.0560|VkmtLX|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:17.4622|I3d7Id|CJPOWERCAST|OAuth: /api/settings/user/mainMenuSettings?_dc=1693974818969 t Transfer: 1220 : 12|05:33:17.4622|I3d7Id|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:17.4622|I3d7Id|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:17.4622|I3d7Id|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:33:17.4622|I3d7Id|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|05:33:17.4622|I3d7Id|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:17.4622|I3d7Id|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:17.4622|I3d7Id|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:17.4622|GgL5UY|CJPOWERCAST|OAuth: /api/settings/group/0?_dc=1693974818968 t Transfer: 1220 : 12|05:33:17.4622|GgL5UY|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:17.4622|GgL5UY|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:17.4622|GgL5UY|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:33:17.4622|GgL5UY|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 12|05:33:17.4622|I3d7Id|CJPOWERCAST|imfx v3 API took 0.007s '/api/settings/user/mainMenuSettings?_dc=1693974818969' t Transfer: 1220 : 12|05:33:17.4622|Qh6S~B|CJPOWERCAST|OAuth: /api/settings/user/uploadSettings?_dc=1693974818981 t Transfer: 1220 : 12|05:33:17.4622|Qh6S~B|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:17.4622|Qh6S~B|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:17.4622|Qh6S~B|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:33:17.4622|Qh6S~B|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|05:33:17.4622|hoDMmd|CJPOWERCAST|OAuth: /api/settings/group/0?_dc=1693974819003 t Transfer: 1220 : 12|05:33:17.4622|hoDMmd|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:17.4622|hoDMmd|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:17.4622|hoDMmd|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:33:17.4622|hoDMmd|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|05:33:17.4622|UgSh06|CJPOWERCAST|OAuth: /api/settings/user/mainMenuSettings?_dc=1693974819004 t Transfer: 1220 : 12|05:33:17.4622|UgSh06|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:17.4622|UgSh06|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:17.4622|UgSh06|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:33:17.4622|UgSh06|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|05:33:17.4622|Qh6S~B|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:17.4622|Qh6S~B|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:17.4622|Qh6S~B|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:17.6823|UgSh06|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:17.6823|UgSh06|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:17.6823|UgSh06|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:33:17.6823|Qh6S~B|CJPOWERCAST|imfx v3 API took 0.084s '/api/settings/user/uploadSettings?_dc=1693974818981' t Verbose: 1220 : 12|05:33:17.6823|UgSh06|CJPOWERCAST|imfx v3 API took 0.077s '/api/settings/user/mainMenuSettings?_dc=1693974819004' t Information: 1220 : 12|05:33:17.6823|IuOjDn||GetCache. t Information: 1220 : 12|05:33:17.6823|IuOjDn||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\201_0_Any_gO.png t Information: 1220 : 12|05:33:17.6823|IuOjDn||GetCache. Data read: 0 t Verbose: 1220 : 12|05:33:17.6823|IuOjDn||imfx v3 API took 0.005s '/api/v3/visual-asset/group/Any_gO/0/image' t Transfer: 1220 : 12|05:33:17.8854|x7gH_7|CJPOWERCAST|OAuth: /api/lookups/MediaStatus?_dc=1693974819024 t Transfer: 1220 : 12|05:33:17.8854|x7gH_7|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:17.8854|x7gH_7|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:17.8854|x7gH_7|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:33:17.8854|x7gH_7|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 12|05:33:17.8854|x7gH_7|CJPOWERCAST|imfx v3 API took 0.032s '/api/lookups/MediaStatus?_dc=1693974819024' t Transfer: 1220 : 12|05:33:17.8854|ZeDReg|CJPOWERCAST|OAuth: /api/lookups/PgmStatus?_dc=1693974819025 t Transfer: 1220 : 12|05:33:17.8854|ZeDReg|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:17.8854|ZeDReg|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:17.8854|ZeDReg|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:33:17.8854|ZeDReg|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 12|05:33:18.0885|ZeDReg|CJPOWERCAST|imfx v3 API took 0.000s '/api/lookups/PgmStatus?_dc=1693974819025' t Verbose: 1220 : 12|05:33:18.0885|GgL5UY|CJPOWERCAST|imfx v3 API took 0.455s '/api/settings/group/0?_dc=1693974818968' t Verbose: 1220 : 12|05:33:18.0885|hoDMmd|CJPOWERCAST|imfx v3 API took 0.382s '/api/settings/group/0?_dc=1693974819003' t Transfer: 1220 : 12|05:33:18.0885|R3lbCY|CJPOWERCAST|OAuth: /api/lookup/CustomMediaStatusTypes?_dc=1693974819026 t Transfer: 1220 : 12|05:33:18.0885|R3lbCY|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:18.0885|R3lbCY|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:18.0885|R3lbCY|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:33:18.0885|R3lbCY|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 12|05:33:18.0885|R3lbCY|CJPOWERCAST|imfx v3 API took 0.019s '/api/lookup/CustomMediaStatusTypes?_dc=1693974819026' t Transfer: 1220 : 12|05:33:18.0885|JwH~db|CJPOWERCAST|OAuth: /api/lookup/CustomVersionStatusTypes?_dc=1693974819027 t Transfer: 1220 : 12|05:33:18.0885|JwH~db|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:18.0885|JwH~db|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:18.0885|JwH~db|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:33:18.0885|JwH~db|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 12|05:33:18.0885|JwH~db|CJPOWERCAST|imfx v3 API took 0.008s '/api/lookup/CustomVersionStatusTypes?_dc=1693974819027' t Transfer: 1220 : 12|05:33:18.2975|CZfEn_|CJPOWERCAST|OAuth: /api/lookup/CustomTitleStatusTypes?_dc=1693974819028 t Transfer: 1220 : 12|05:33:18.2975|CZfEn_|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:18.2975|CZfEn_|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:18.2975|CZfEn_|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:33:18.2975|CZfEn_|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 12|05:33:18.2975|CZfEn_|CJPOWERCAST|imfx v3 API took 0.009s '/api/lookup/CustomTitleStatusTypes?_dc=1693974819028' t Transfer: 1220 : 12|05:33:18.2975|9hUKWt|CJPOWERCAST|OAuth: /api/settings/user/defaultHomePage?_dc=1693974819029 t Transfer: 1220 : 12|05:33:18.2975|9hUKWt|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:18.2975|9hUKWt|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:18.2975|9hUKWt|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:33:18.2975|9hUKWt|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|05:33:18.2975|9hUKWt|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:18.2975|9hUKWt|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:18.2975|9hUKWt|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:33:18.2975|9hUKWt|CJPOWERCAST|imfx v3 API took 0.009s '/api/settings/user/defaultHomePage?_dc=1693974819029' t Information: 1220 : 12|05:33:18.2975|VRE6o8||GetCache. t Information: 1220 : 12|05:33:18.2975|VRE6o8||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\202_1_Any_gO.png t Information: 1220 : 12|05:33:18.2975|VRE6o8||GetCache. Data read: 0 t Verbose: 1220 : 12|05:33:18.2975|VRE6o8||imfx v3 API took 0.007s '/api/v3/visual-asset/group/Any_gO/1/image' t Transfer: 1220 : 12|05:33:19.3132|R31lGy|CJPOWERCAST|OAuth: /api/settings/user/defaultSearch?_dc=1693974820816 t Transfer: 1220 : 12|05:33:19.3132|R31lGy|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:19.3132|R31lGy|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:19.3132|R31lGy|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:33:19.3132|R31lGy|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|05:33:19.3132|R31lGy|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:19.3132|R31lGy|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:19.3132|R31lGy|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:19.3132|LgirQH|CJPOWERCAST|OAuth: /api/settings/user/startSearch?_dc=1693974820817 t Transfer: 1220 : 12|05:33:19.3132|LgirQH|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:19.3132|LgirQH|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:19.3132|LgirQH|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:33:19.3132|LgirQH|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|05:33:19.3132|LgirQH|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:19.3132|LgirQH|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:19.3132|LgirQH|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:33:19.3132|R31lGy|CJPOWERCAST|imfx v3 API took 0.012s '/api/settings/user/defaultSearch?_dc=1693974820816' t Verbose: 1220 : 12|05:33:19.3132|LgirQH|CJPOWERCAST|imfx v3 API took 0.015s '/api/settings/user/startSearch?_dc=1693974820817' t Transfer: 1220 : 12|05:33:19.7194|WxV440|CJPOWERCAST|OAuth: /api/user-preferences?keys=consumer.recent.data&_dc=1693974821168 t Transfer: 1220 : 12|05:33:19.7194|WxV440|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:19.7194|WxV440|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:19.7194|WxV440|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:33:19.7194|WxV440|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|05:33:19.7194|WxV440|CJPOWERCAST|GetUserDataByKeys: consumer.recent.data t Transfer: 1220 : 12|05:33:19.7194|WxV440|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:19.7194|WxV440|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:19.7194|WxV440|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:19.7194|SKrdIy|CJPOWERCAST|OAuth: /api/user-preferences?keys=adv.recent.searches.consumer&_dc=1693974821182 t Transfer: 1220 : 12|05:33:19.7194|SKrdIy|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:19.7194|SKrdIy|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:19.7194|SKrdIy|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:33:19.7194|SKrdIy|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|05:33:19.7194|SKrdIy|CJPOWERCAST|GetUserDataByKeys: adv.recent.searches.consumer t Transfer: 1220 : 12|05:33:19.7194|SKrdIy|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:19.7194|SKrdIy|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:19.7194|SKrdIy|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:33:19.7194|WxV440|CJPOWERCAST|imfx v3 API took 0.008s '/api/user-preferences?keys=consumer.recent.data&_dc=1693974821168' t Verbose: 1220 : 12|05:33:19.7194|SKrdIy|CJPOWERCAST|imfx v3 API took 0.010s '/api/user-preferences?keys=adv.recent.searches.consumer&_dc=1693974821182' t Information: 1220 : 12|05:33:19.7194|C7Yt7l||GetCache. t Information: 1220 : 12|05:33:19.7194|C7Yt7l||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\204_3_Any_gO.png t Information: 1220 : 12|05:33:19.7194|C7Yt7l||GetCache. Data read: 5504 t Verbose: 1220 : 12|05:33:19.7194|C7Yt7l||imfx v3 API took 0.006s '/api/v3/visual-asset/group/Any_gO/3/image' t Transfer: 1220 : 12|05:33:28.3258|JD89Za|CJPOWERCAST|OAuth: /api/lookups/SearchSupportedOperators?_dc=1693974829813 t Transfer: 1220 : 12|05:33:28.3258|JD89Za|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:28.3258|JD89Za|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:28.3258|JD89Za|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:33:28.3258|JD89Za|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 12|05:33:28.3258|JD89Za|CJPOWERCAST|imfx v3 API took 0.000s '/api/lookups/SearchSupportedOperators?_dc=1693974829813' t Transfer: 1220 : 12|05:33:28.3258|_RJhu6|CJPOWERCAST|OAuth: /api/view/searchinfo/Media?_dc=1693974829811 t Transfer: 1220 : 12|05:33:28.3258|_RJhu6|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:28.3258|_RJhu6|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:28.3258|_RJhu6|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:33:28.3258|_RJhu6|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|05:33:28.3258|sJHDo_|CJPOWERCAST|OAuth: /api/user-preferences?keys=adv.recent.searches.media&_dc=1693974829815 t Transfer: 1220 : 12|05:33:28.3258|sJHDo_|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:28.3258|sJHDo_|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:28.3258|sJHDo_|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:33:28.3258|sJHDo_|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|05:33:28.3258|_RJhu6|CJPOWERCAST|GetAdvSearchColumns. search type Media grid . t Verbose: 1220 : 12|05:33:28.3258|_RJhu6|CJPOWERCAST|imfx v3 API took 0.001s '/api/view/searchinfo/Media?_dc=1693974829811' t Information: 1220 : 12|05:33:28.3258|sJHDo_|CJPOWERCAST|GetUserDataByKeys: adv.recent.searches.media t Transfer: 1220 : 12|05:33:28.3258|sJHDo_|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:28.3258|sJHDo_|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:28.3258|sJHDo_|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:33:28.3258|sJHDo_|CJPOWERCAST|imfx v3 API took 0.010s '/api/user-preferences?keys=adv.recent.searches.media&_dc=1693974829815' t Transfer: 1220 : 12|05:33:28.3258|OQMDeV|CJPOWERCAST|OAuth: /api/view/info/MediaGrid?lang=en-GB&_dc=1693974829875 t Transfer: 1220 : 12|05:33:28.3258|OQMDeV|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:28.3258|OQMDeV|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:28.3258|OQMDeV|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:33:28.3258|OQMDeV|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|05:33:28.3258|Hol4_8|CJPOWERCAST|OAuth: /api/view/searches/Media?_dc=1693974829870 t Transfer: 1220 : 12|05:33:28.3258|Hol4_8|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:28.3258|Hol4_8|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:28.3258|Hol4_8|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:33:28.3258|Hol4_8|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|05:33:28.3258|OQMDeV|CJPOWERCAST|GetGridViewBuilder. builder type MediaGrid. t Transfer: 1220 : 12|05:33:28.3258|RT_yYC|CJPOWERCAST|OAuth: /api/settings/user/searchLayoutConfig?_dc=1693974829876 t Transfer: 1220 : 12|05:33:28.3258|RT_yYC|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:28.3258|RT_yYC|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:28.3258|RT_yYC|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:33:28.3258|RT_yYC|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|05:33:28.3258|OQMDeV|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:28.3258|OQMDeV|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:28.3258|OQMDeV|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:28.3258|RT_yYC|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:28.3258|RT_yYC|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:28.3258|RT_yYC|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|05:33:28.3258|Hol4_8|CJPOWERCAST|GetSavedSearchNames. search type Media. t Transfer: 1220 : 12|05:33:28.3258|Hol4_8|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:28.3258|Hol4_8|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:28.3258|Hol4_8|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:33:28.3258|RT_yYC|CJPOWERCAST|imfx v3 API took 0.009s '/api/settings/user/searchLayoutConfig?_dc=1693974829876' t Information: 1220 : 12|05:33:28.3258|OQMDeV|CJPOWERCAST|UserGridView. LoadView. ID -2, Name Default. t Transfer: 1220 : 12|05:33:28.3258|OQMDeV|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:28.3258|OQMDeV|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:28.3258|OQMDeV|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:28.5446|OQMDeV|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:28.5446|OQMDeV|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:28.5446|OQMDeV|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:33:28.5446|Hol4_8|CJPOWERCAST|imfx v3 API took 0.129s '/api/view/searches/Media?_dc=1693974829870' t Verbose: 1220 : 12|05:33:28.5446|OQMDeV|CJPOWERCAST|imfx v3 API took 0.157s '/api/view/info/MediaGrid?lang=en-GB&_dc=1693974829875' t Transfer: 1220 : 12|05:33:31.3940|9NOvWd|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1693974832867 t Transfer: 1220 : 12|05:33:31.3940|9NOvWd|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:31.3940|9NOvWd|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:31.3940|9NOvWd|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:33:31.3940|9NOvWd|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|05:33:31.3940|9NOvWd|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:31.3940|9NOvWd|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:31.3940|9NOvWd|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:33:31.8041|9NOvWd|CJPOWERCAST|imfx v3 API took 0.463s '/api/v3/search-suggestion/?_dc=1693974832867' t Transfer: 1220 : 12|05:33:32.0073|ikRlmz|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1693974833479 t Transfer: 1220 : 12|05:33:32.0073|ikRlmz|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:32.0073|ikRlmz|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:32.0073|ikRlmz|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:33:32.0073|ikRlmz|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|05:33:32.0073|ikRlmz|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:32.0073|ikRlmz|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:32.0073|ikRlmz|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:33:32.0073|ikRlmz|CJPOWERCAST|imfx v3 API took 0.005s '/api/v3/search-suggestion/?_dc=1693974833479' t Transfer: 1220 : 12|05:33:32.2104|P5Zesl|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1693974833712 t Transfer: 1220 : 12|05:33:32.2104|P5Zesl|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:32.2104|P5Zesl|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:32.2104|P5Zesl|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:33:32.2104|P5Zesl|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|05:33:32.2104|P5Zesl|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:32.2104|P5Zesl|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:32.2104|P5Zesl|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:33:32.2104|P5Zesl|CJPOWERCAST|imfx v3 API took 0.005s '/api/v3/search-suggestion/?_dc=1693974833712' t Transfer: 1220 : 12|05:33:32.4135|pWsAHR|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1693974833887 t Transfer: 1220 : 12|05:33:32.4135|pWsAHR|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:32.4135|pWsAHR|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:32.4135|pWsAHR|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:33:32.4135|pWsAHR|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|05:33:32.4135|pWsAHR|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:32.4135|Xul54S|CJPOWERCAST|OAuth: /api/v3/search/Media?_dc=1693974833890 t Transfer: 1220 : 12|05:33:32.4135|pWsAHR|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:32.4135|pWsAHR|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:32.4135|Xul54S|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:32.4135|Xul54S|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:32.4135|Xul54S|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:33:32.4135|Xul54S|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 12|05:33:32.4135|pWsAHR|CJPOWERCAST|imfx v3 API took 0.004s '/api/v3/search-suggestion/?_dc=1693974833887' t Information: 1220 : 12|05:33:32.4135|Xul54S|CJPOWERCAST|V3Api.SearchMedia t Information: 1220 : 12|05:33:32.4135|Xul54S|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|05:33:32.6167|Xul54S|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:32.6167|Xul54S|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:32.6167|Xul54S|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|05:33:32.6167|Xul54S|CJPOWERCAST|Running solr search: [q, (((title:(*))^2 OR series:(*) OR ((filename:(*.ㅔㅜㅎ) OR filename:(*.ㅔㅜㅎ.*)) OR filename:"*.ㅔㅜㅎ") OR (titleMergedNgram:**)^10 OR miid1:(*.ㅔㅜㅎ) OR miid2:(*.ㅔㅜㅎ) OR versionid1:(*.ㅔㅜㅎ) OR progid1:(*.ㅔㅜㅎ)) AND deleted_flag:(0) AND (owners:((SFP2) OR (PSP) OR (PMS) OR (SFP1) OR (PMH) OR (PPL))))] t Information: 1220 : 12|05:33:32.8198|Xul54S|CJPOWERCAST|Solr query returned: 368 in 139ms t Information: 1220 : 12|05:33:32.8198|Xul54S|CJPOWERCAST|MediaSearch SQL: --sqlFromPaging select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type in (1,110)),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , (SELECT min(status.ACCESS_STATUS_NAME) FROM TMDDBA.TM_ACCESS_STATUS statusLnx, TM_CFG_ACCESS_STATUS status WHERE statusLnx.Media_Id = r.id and statusLnx.Status_Id = status.id) ACCESS_STATUS , (select min(acq.ext_ref) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) CONSIGNMENT_NUMBER , (select min(acq.alt_id1) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) TRANSFER_NUMBER , (select min(crs.series_number) from tm_series_data crs where crs.id = r.GROUP_SERIES_ID) CRS_SERIES , (select min(DISPOSAL_NAME) from TM_ACQ_DISPOSAL status, tm_disposal_records records where status.id = records.disposal_status_id and records.miid = r.id) DISPOSAL_STATUS , (select min(class.class_number) from TM_ACQ_DISPOSAL status, tm_disposal_records records, tm_disposal_classes class where status.id = records.disposal_status_id and records.miid = r.id and class.id = records.disposal_class_id) DISPOSAL_CLASS, (select min(names.concat_search_name) from tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names where r.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY, (select min(c.u_id_ext1) from tmddba.tm_mi_tpi_lnx lnx, tm_ctnrs c where c.u_id = lnx.tpiid and lnx.miid = r.id) U_ID_EXT1 , (select t.name from TM_CFG_MI_FMT_TYP t where t.id = r.mi_fmt_type) ITEM_FORMAT_TEXT, CASE WHEN BITAND(r.COMPIL, 2) = 2 THEN 'SUPPLIED' WHEN BITAND(r.COMPIL, 4) = 4 THEN 'MADE' WHEN BITAND(r.COMPIL, 134217728) = 134217728 THEN 'IMPORTED' ELSE '' END AS ORIGIN, CASE WHEN BITAND(r.COMPIL, 512) = 512 THEN 'Attached' WHEN BITAND(r.COMPIL, 1024) = 1024 THEN 'Un-Attached' ELSE '' END AS FLAGS, (select min(lang.full_name) from TM_PG_RL_LANG_LNX lnx, TM_LANG_DATA lang where lnx.tm_pg_rl_id = r.pgm_parent_id and lnx.lang_id = lang.id) AS PROD_LANGUAGE , (select min(ctx.ITFC_CODE) from tm_mis mis, tm_mi_tpi_lnx links, tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names where mis.id = r.id and links.miid = mis.id and mis.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY_NUMBER, (select min(status.description) from TM_CFG_PGM_STATUS status where r.status = status.id) PGM_STATUS_TEXT, (select min(ver.DUR) from TM_PG_RL ver where r.pgm_PARENT_ID = ver.id) AS VERSION_DUR , (select tmd_str_agg_pipe(cms.status_type_id ||',' ||cms.status_id) from tm_mi_cust_med_stat_lnx cms where cms.media_id=r.id) "CustomStatusesRaw", (select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = r.net_grp_id) CHANNEL_GROUP, (SELECT SUBSTR( trim( replace (replace ( LISTAGG(trim(tt.tags || ' ' || tt.notes), ' ') WITHIN GROUP (ORDER BY trim(tt.tags || ' ' || tt.notes)), chr (13), ''), chr (10), ' ')), 1, 150) z FROM tm_media_tagging tt WHERE link_guid = DFILE_LINK_GUID and rownum=1) TAGS_TEXT , GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select t.*, coalesce(t.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=t.pgm_parent_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.pgm_abs_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs2_id) ) primary_thumb_id2 from ( --sqlSubSelect select s.* from (select a.*, rownum rnum from (select --sqlFrom m.* from tmddba.tm_mis m ,(select /*+ cardinality(4) */ rownum rn, column_value id from table(:ids)) ids --sqlWhere where m.id = ids.id order by ids.rn ) a where rownum <= 10000) s where rnum >= 1) t ) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl order by rnum t Transfer: 1220 : 12|05:33:33.2263|BUvjWu|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1693974834797 t Transfer: 1220 : 12|05:33:33.2263|BUvjWu|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:33.2263|BUvjWu|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:33.2263|BUvjWu|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:33:33.2263|BUvjWu|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|05:33:33.2263|BUvjWu|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:33.2263|BUvjWu|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:33.2263|BUvjWu|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:33:33.2263|BUvjWu|CJPOWERCAST|imfx v3 API took 0.005s '/api/v3/search-suggestion/?_dc=1693974834797' t Transfer: 1220 : 12|05:33:33.4294|3X2mPa|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1693974835022 t Transfer: 1220 : 12|05:33:33.4294|3X2mPa|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:33.4294|3X2mPa|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:33.4294|3X2mPa|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:33:33.4294|3X2mPa|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|05:33:33.4294|3X2mPa|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:33.4294|3X2mPa|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:33.4294|3X2mPa|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:33:33.4294|3X2mPa|CJPOWERCAST|imfx v3 API took 0.005s '/api/v3/search-suggestion/?_dc=1693974835022' t Verbose: 1220 : 12|05:33:33.6325|Xul54S|CJPOWERCAST|Alternative title fields query: select * from (select x.id,x.pgm_abs_id TitleId, x.pgm_parent_id VersionId from tm_mis x where id in (select /*+ cardinality(4) */ column_value id from table(:ids))) y,lateral (select dbms_lob.substr( o.text_data_plain, 1000, 1 ) Field_5799344 from tm_txt_obj o where (o.pgm_abs_id=y.TitleId or o.pgm_rl_id = y.VersionId) and o.type_id=:param_1 order by o.id desc fetch first 1 rows only)(+) t Information: 1220 : 12|05:33:33.8356|Xul54S|CJPOWERCAST| timing: 00:00:01.2489063 t Verbose: 1220 : 12|05:33:33.8356|Xul54S|CJPOWERCAST|imfx v3 API took 1.279s '/api/v3/search/Media?_dc=1693974833890' t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Dinosaur 1c.mp4 subfolder t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Dinosaur%201c.mp4 t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/Dinosaur%201c.mp4 t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetUrl. Storage |Video| filename I:\Video\L0640441.mp4 subfolder t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/L0640441.mp4 t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/L0640441.mp4 t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetUrl. Storage |Video| filename I:\Video\L0640430.mp4 subfolder t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/L0640430.mp4 t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/L0640430.mp4 t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetUrl. Storage |PMH Video| filename \\10.46.131.12\Test\NGAM\Folder3\alpha7-1\C0002.MP4 subfolder alpha7-1\ t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetUrl. Storage |PMH Video| filename \\10.46.131.12\Test\NGAM\Folder3\alpha7-1\C0003.MP4 subfolder alpha7-1\ t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetUrl. Storage |PMH Video| filename \\10.46.131.12\Test\NGAM\Folder3\alpha7-1\C0004.MP4 subfolder alpha7-1\ t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetUrl. Storage |PMH Video| filename \\10.46.131.12\Test\NGAM\Folder3\alpha7-1\C0005.MP4 subfolder alpha7-1\ t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetUrl. Storage |PMH Video| filename \\10.46.131.12\Test\NGAM\Folder3\alpha7-1\C0007.MP4 subfolder alpha7-1\ t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetUrl. Storage |PMH Video| filename \\10.46.131.12\Test\NGAM\Folder3\32b60bce-ad82-46d9-9680-1bc508939215\GH018860.MP4 subfolder 32b60bce-ad82-46d9-9680-1bc508939215\ t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetUrl. Storage |PMH Video| filename \\10.46.131.12\Test\NGAM\Folder3\aa6fb5ed-8e69-4268-b8fa-1184664437a0\GH018859.MP4 subfolder aa6fb5ed-8e69-4268-b8fa-1184664437a0\ t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetUrl. Storage |PMH Video| filename \\10.46.131.12\Test\NGAM\Folder3\206cf38c-d40c-49e6-b8ed-476b7c369d2c\GH018861.MP4 subfolder 206cf38c-d40c-49e6-b8ed-476b7c369d2c\ t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetUrl. Storage |PMH Proxy| filename \\10.46.131.12\Test\NGAM\Folder5\295_2302_M0002105.mp4 subfolder t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetUrl. Storage |PMH Proxy| filename \\10.46.131.12\Test\NGAM\Folder5\N0002107.mp4 subfolder t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetUrl. Storage |PMH Proxy| filename \\10.46.131.12\Test\NGAM\Folder5\N0002108.mp4 subfolder t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetUrl. Storage |PMH Proxy| filename \\10.46.131.12\Test\NGAM\Folder5\GH018860_M0002145.mp4 subfolder t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetUrl. Storage |PMH Proxy| filename \\10.46.131.12\Test\NGAM\Folder5\MAXD_1506_M0002267.mp4 subfolder t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\8DCM000222_OMN0118203335_M0002381.mp4 subfolder t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/8DCM000222_OMN0118203335_M0002381.mp4 t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/8DCM000222_OMN0118203335_M0002381.mp4 t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gots0ep4us.mpd subfolder t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gots0ep4us.mpd t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/gots0ep4us.mpd t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetUrl. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\SPOC List.xlsx subfolder t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| GetFileName result https://demo.tmd.tv/Temp Upload/SPOC%20List.xlsx t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetUrl. result https://demo.tmd.tv/Temp Upload/SPOC%20List.xlsx t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\snow-game-of-thrones-1200x600.jpg subfolder t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/snow-game-of-thrones-1200x600.jpg t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/snow-game-of-thrones-1200x600.jpg t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\Game_of_Thrones_Still_4.jpg subfolder t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/Game_of_Thrones_Still_4.jpg t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/Game_of_Thrones_Still_4.jpg t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\Game_of_Thrones_Still_4.png subfolder t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/Game_of_Thrones_Still_4.png t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/Game_of_Thrones_Still_4.png t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\game-of-thrones-1349.jpg subfolder t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/game-of-thrones-1349.jpg t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/game-of-thrones-1349.jpg t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\game-of-thrones-daenerys.jpg subfolder t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/game-of-thrones-daenerys.jpg t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/game-of-thrones-daenerys.jpg t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\young cersei game of thrones helen sloan.jpeg.jpg subfolder t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/young%20cersei%20game%20of%20thrones%20helen%20sloan.jpeg.jpg t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/young%20cersei%20game%20of%20thrones%20helen%20sloan.jpeg.jpg t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetUrl. Storage |VODPublish| filename \\192.168.120.254\DemoFS\Digital Assets\VODPublish\Temp\N0001344.dtd subfolder Temp\ t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetUrl. Storage |VODPublish| filename \\192.168.120.254\DemoFS\Digital Assets\VODPublish\Temp\N0001345.xml subfolder Temp\ t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetUrl. Storage |VODPublish| filename \\192.168.120.254\DemoFS\Digital Assets\VODPublish\Temp\N0001348.dtd subfolder Temp\ t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetUrl. Storage |VODPublish| filename \\192.168.120.254\DemoFS\Digital Assets\VODPublish\Temp\N0001349.xml subfolder Temp\ t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetUrl. Storage |Docs| filename I:\Docs\Mediaflex Supported Devices 2v03.pdf subfolder t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/DocsServer/Mediaflex%20Supported%20Devices%202v03.pdf t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/DocsServer/Mediaflex%20Supported%20Devices%202v03.pdf t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetUrl. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\BBC_graymeta_metadata.json subfolder t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| GetFileName result https://demo.tmd.tv/Temp Upload/BBC_graymeta_metadata.json t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetUrl. result https://demo.tmd.tv/Temp Upload/BBC_graymeta_metadata.json t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Game of Thrones - Blinkbox-HD.mp4 subfolder t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Game%20of%20Thrones%20-%20Blinkbox-HD.mp4 t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/Game%20of%20Thrones%20-%20Blinkbox-HD.mp4 t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetUrl. Storage |VODPublish| filename \\192.168.120.254\DemoFS\Digital Assets\VODPublish\Temp\N0001343.mp4 subfolder Temp\ t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:34.0388|Xul54S|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gotspecialspromo20seccharacter.mp4 subfolder t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gotspecialspromo20seccharacter.mp4 t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/gotspecialspromo20seccharacter.mp4 t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\gotspecialspromosimage.jpg subfolder t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/gotspecialspromosimage.jpg t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/gotspecialspromosimage.jpg t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\Example 06052020.mp4 subfolder t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/Example%2006052020.mp4 t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/Example%2006052020.mp4 t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gots0ep3us.mpd subfolder t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gots0ep3us.mpd t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/gots0ep3us.mpd t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Example 06052020.mp4 subfolder t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Example%2006052020.mp4 t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/Example%2006052020.mp4 t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST|GetUrl. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\68add84afa7b\Animation Sample1.mp4 subfolder 68add84afa7b\ t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST| GetFileName result https://demo.tmd.tv/Temp Upload/Animation%20Sample1.mp4 t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST|GetUrl. result https://demo.tmd.tv/Temp Upload/Animation%20Sample1.mp4 t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gotspecialspromo10secaction.mp4 subfolder t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gotspecialspromo10secaction.mp4 t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/gotspecialspromo10secaction.mp4 t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gots0ep5us.mpd subfolder t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gots0ep5us.mpd t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/gots0ep5us.mpd t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gots0ep2us.mpd subfolder t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gots0ep2us.mpd t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/gots0ep2us.mpd t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST|GetUrl. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\cd16270b-696e-4e0b-9a0e-02a00f6c3c8d\2022년_통합인제스트_6월 근무표.xlsx subfolder cd16270b-696e-4e0b-9a0e-02a00f6c3c8d\ t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST| GetFileName result https://demo.tmd.tv/Temp Upload/2022%EB%85%84_%ED%86%B5%ED%95%A9%EC%9D%B8%EC%A0%9C%EC%8A%A4%ED%8A%B8_6%EC%9B%94%20%EA%B7%BC%EB%AC%B4%ED%91%9C.xlsx t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST|GetUrl. result https://demo.tmd.tv/Temp Upload/2022%EB%85%84_%ED%86%B5%ED%95%A9%EC%9D%B8%EC%A0%9C%EC%8A%A4%ED%8A%B8_6%EC%9B%94%20%EA%B7%BC%EB%AC%B4%ED%91%9C.xlsx t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Nov Example (16).mp4 subfolder t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Nov%20Example%20(16).mp4 t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/Nov%20Example%20(16).mp4 t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST|GetUrl. Storage |PMH Video| filename \\10.46.131.12\Test\NGAM\Folder3\0008971.mp4 subfolder t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:34.0543|Xul54S|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:35.0856|pSzsZS|CJPOWERCAST|OAuth: /api/user-preferences?_dc=1693974836506 t Transfer: 1220 : 12|05:33:35.0856|pSzsZS|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:35.0856|pSzsZS|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:35.0856|pSzsZS|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:33:35.0856|pSzsZS|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 12|05:33:35.0856|pSzsZS|CJPOWERCAST|StoreUserDataByKeys.. t Transfer: 1220 : 12|05:33:35.0856|pSzsZS|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:35.0856|pSzsZS|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:35.0856|pSzsZS|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:33:35.0856|pSzsZS|CJPOWERCAST|imfx v3 API took 0.019s '/api/user-preferences?_dc=1693974836506' t Transfer: 1220 : 12|05:33:35.6964|dVVd5~|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1693974837194 t Transfer: 1220 : 12|05:33:35.6964|dVVd5~|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:35.6964|dVVd5~|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:35.6964|dVVd5~|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:33:35.6964|dVVd5~|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|05:33:35.6964|dVVd5~|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:35.6964|dVVd5~|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:35.6964|dVVd5~|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:33:35.6964|dVVd5~|CJPOWERCAST|imfx v3 API took 0.014s '/api/v3/search-suggestion/?_dc=1693974837194' t Transfer: 1220 : 12|05:33:36.3286|Ebvto0|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1693974837735 t Transfer: 1220 : 12|05:33:36.3286|Ebvto0|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:36.3286|Ebvto0|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:36.3286|Ebvto0|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:33:36.3286|Ebvto0|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|05:33:36.3286|Ebvto0|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:36.3286|Ebvto0|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:36.3286|Ebvto0|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:33:36.3286|Ebvto0|CJPOWERCAST|imfx v3 API took 0.015s '/api/v3/search-suggestion/?_dc=1693974837735' t Transfer: 1220 : 12|05:33:36.7464|ngaeaL|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1693974838219 t Transfer: 1220 : 12|05:33:36.7464|ngaeaL|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:36.7464|ngaeaL|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:36.7464|ngaeaL|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:33:36.7464|ngaeaL|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|05:33:36.7464|ngaeaL|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:36.7464|ngaeaL|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:36.7464|ngaeaL|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:33:36.7464|ngaeaL|CJPOWERCAST|imfx v3 API took 0.005s '/api/v3/search-suggestion/?_dc=1693974838219' t Transfer: 1220 : 12|05:33:36.7464|i27IMp|CJPOWERCAST|OAuth: /api/v3/search/Media?_dc=1693974838268 t Transfer: 1220 : 12|05:33:36.7464|i27IMp|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:36.7464|i27IMp|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:36.7464|i27IMp|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:33:36.7464|i27IMp|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|05:33:36.7464|i27IMp|CJPOWERCAST|V3Api.SearchMedia t Information: 1220 : 12|05:33:36.7464|i27IMp|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|05:33:36.7464|i27IMp|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:36.7464|i27IMp|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:36.7464|i27IMp|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|05:33:36.7464|i27IMp|CJPOWERCAST|Running solr search: [q, (((title:(* && png))^2 OR series:(* && png) OR ((filename:(*.png) OR filename:(*.png.*)) OR filename:"*.png") OR (titleMergedNgram:*png*)^10 OR miid1:(*.png) OR miid2:(*.png) OR versionid1:(*.png) OR progid1:(*.png)) AND deleted_flag:(0) AND (owners:((SFP2) OR (PSP) OR (PMS) OR (SFP1) OR (PMH) OR (PPL))))] t Information: 1220 : 12|05:33:36.7464|i27IMp|CJPOWERCAST|Solr query returned: 19 in 66ms t Information: 1220 : 12|05:33:36.9495|i27IMp|CJPOWERCAST|MediaSearch SQL: --sqlFromPaging select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type in (1,110)),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , (SELECT min(status.ACCESS_STATUS_NAME) FROM TMDDBA.TM_ACCESS_STATUS statusLnx, TM_CFG_ACCESS_STATUS status WHERE statusLnx.Media_Id = r.id and statusLnx.Status_Id = status.id) ACCESS_STATUS , (select min(acq.ext_ref) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) CONSIGNMENT_NUMBER , (select min(acq.alt_id1) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) TRANSFER_NUMBER , (select min(crs.series_number) from tm_series_data crs where crs.id = r.GROUP_SERIES_ID) CRS_SERIES , (select min(DISPOSAL_NAME) from TM_ACQ_DISPOSAL status, tm_disposal_records records where status.id = records.disposal_status_id and records.miid = r.id) DISPOSAL_STATUS , (select min(class.class_number) from TM_ACQ_DISPOSAL status, tm_disposal_records records, tm_disposal_classes class where status.id = records.disposal_status_id and records.miid = r.id and class.id = records.disposal_class_id) DISPOSAL_CLASS, (select min(names.concat_search_name) from tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names where r.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY, (select min(c.u_id_ext1) from tmddba.tm_mi_tpi_lnx lnx, tm_ctnrs c where c.u_id = lnx.tpiid and lnx.miid = r.id) U_ID_EXT1 , (select t.name from TM_CFG_MI_FMT_TYP t where t.id = r.mi_fmt_type) ITEM_FORMAT_TEXT, CASE WHEN BITAND(r.COMPIL, 2) = 2 THEN 'SUPPLIED' WHEN BITAND(r.COMPIL, 4) = 4 THEN 'MADE' WHEN BITAND(r.COMPIL, 134217728) = 134217728 THEN 'IMPORTED' ELSE '' END AS ORIGIN, CASE WHEN BITAND(r.COMPIL, 512) = 512 THEN 'Attached' WHEN BITAND(r.COMPIL, 1024) = 1024 THEN 'Un-Attached' ELSE '' END AS FLAGS, (select min(lang.full_name) from TM_PG_RL_LANG_LNX lnx, TM_LANG_DATA lang where lnx.tm_pg_rl_id = r.pgm_parent_id and lnx.lang_id = lang.id) AS PROD_LANGUAGE , (select min(ctx.ITFC_CODE) from tm_mis mis, tm_mi_tpi_lnx links, tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names where mis.id = r.id and links.miid = mis.id and mis.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY_NUMBER, (select min(status.description) from TM_CFG_PGM_STATUS status where r.status = status.id) PGM_STATUS_TEXT, (select min(ver.DUR) from TM_PG_RL ver where r.pgm_PARENT_ID = ver.id) AS VERSION_DUR , (select tmd_str_agg_pipe(cms.status_type_id ||',' ||cms.status_id) from tm_mi_cust_med_stat_lnx cms where cms.media_id=r.id) "CustomStatusesRaw", (select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = r.net_grp_id) CHANNEL_GROUP, (SELECT SUBSTR( trim( replace (replace ( LISTAGG(trim(tt.tags || ' ' || tt.notes), ' ') WITHIN GROUP (ORDER BY trim(tt.tags || ' ' || tt.notes)), chr (13), ''), chr (10), ' ')), 1, 150) z FROM tm_media_tagging tt WHERE link_guid = DFILE_LINK_GUID and rownum=1) TAGS_TEXT , GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select t.*, coalesce(t.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=t.pgm_parent_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.pgm_abs_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs2_id) ) primary_thumb_id2 from ( --sqlSubSelect select s.* from (select a.*, rownum rnum from (select --sqlFrom m.* from tmddba.tm_mis m ,(select /*+ cardinality(4) */ rownum rn, column_value id from table(:ids)) ids --sqlWhere where m.id = ids.id order by ids.rn ) a where rownum <= 10000) s where rnum >= 1) t ) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl order by rnum t Verbose: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST|Alternative title fields query: select * from (select x.id,x.pgm_abs_id TitleId, x.pgm_parent_id VersionId from tm_mis x where id in (select /*+ cardinality(4) */ column_value id from table(:ids))) y,lateral (select dbms_lob.substr( o.text_data_plain, 1000, 1 ) Field_5799344 from tm_txt_obj o where (o.pgm_abs_id=y.TitleId or o.pgm_rl_id = y.VersionId) and o.type_id=:param_1 order by o.id desc fetch first 1 rows only)(+) t Information: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST| timing: 00:00:00.5604700 t Verbose: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST|imfx v3 API took 0.561s '/api/v3/search/Media?_dc=1693974838268' t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST|GetUrl. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\fc368516-1df7-4cee-8be7-8122acbd869e\원본-자막기Export비교1.PNG subfolder fc368516-1df7-4cee-8be7-8122acbd869e\ t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST| GetFileName result https://demo.tmd.tv/Temp Upload/%EC%9B%90%EB%B3%B8-%EC%9E%90%EB%A7%89%EA%B8%B0Export%EB%B9%84%EA%B5%901.PNG t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST|GetUrl. result https://demo.tmd.tv/Temp Upload/%EC%9B%90%EB%B3%B8-%EC%9E%90%EB%A7%89%EA%B8%B0Export%EB%B9%84%EA%B5%901.PNG t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\원본-자막기Export비교1.PNG subfolder t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/%EC%9B%90%EB%B3%B8-%EC%9E%90%EB%A7%89%EA%B8%B0Export%EB%B9%84%EA%B5%901.PNG t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/%EC%9B%90%EB%B3%B8-%EC%9E%90%EB%A7%89%EA%B8%B0Export%EB%B9%84%EA%B5%901.PNG t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\Game_of_Thrones_Still_4.png subfolder t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/Game_of_Thrones_Still_4.png t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/Game_of_Thrones_Still_4.png t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST|GetUrl. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\a9abc460-6022-4997-9f9f-efeef62d30d9\MH26-002.png subfolder a9abc460-6022-4997-9f9f-efeef62d30d9\ t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST| GetFileName result https://demo.tmd.tv/Temp Upload/MH26-002.png t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST|GetUrl. result https://demo.tmd.tv/Temp Upload/MH26-002.png t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST|GetUrl. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\e91bafd5-5930-4583-b762-23637271c629\원본-자막기Export비교2.PNG subfolder e91bafd5-5930-4583-b762-23637271c629\ t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST| GetFileName result https://demo.tmd.tv/Temp Upload/%EC%9B%90%EB%B3%B8-%EC%9E%90%EB%A7%89%EA%B8%B0Export%EB%B9%84%EA%B5%902.PNG t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST|GetUrl. result https://demo.tmd.tv/Temp Upload/%EC%9B%90%EB%B3%B8-%EC%9E%90%EB%A7%89%EA%B8%B0Export%EB%B9%84%EA%B5%902.PNG t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\원본-자막기Export비교2.PNG subfolder t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/%EC%9B%90%EB%B3%B8-%EC%9E%90%EB%A7%89%EA%B8%B0Export%EB%B9%84%EA%B5%902.PNG t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/%EC%9B%90%EB%B3%B8-%EC%9E%90%EB%A7%89%EA%B8%B0Export%EB%B9%84%EA%B5%902.PNG t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST|GetUrl. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\04a2988a-1155-45d8-a068-8dfa0b9a343a\캡처3.PNG subfolder 04a2988a-1155-45d8-a068-8dfa0b9a343a\ t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST| GetFileName result https://demo.tmd.tv/Temp Upload/%EC%BA%A1%EC%B2%983.PNG t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST|GetUrl. result https://demo.tmd.tv/Temp Upload/%EC%BA%A1%EC%B2%983.PNG t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\캡처3.PNG subfolder t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/%EC%BA%A1%EC%B2%983.PNG t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/%EC%BA%A1%EC%B2%983.PNG t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST|GetUrl. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\49ad8633-3f5e-4b34-886d-45603d50e05d\ECM-0298.png subfolder 49ad8633-3f5e-4b34-886d-45603d50e05d\ t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST| GetFileName result https://demo.tmd.tv/Temp Upload/ECM-0298.png t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST|GetUrl. result https://demo.tmd.tv/Temp Upload/ECM-0298.png t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\MH26-002.png subfolder t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/MH26-002.png t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/MH26-002.png t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST|GetUrl. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\7870eb10-4e7e-4d9e-994d-28c36de9ef0e\SA550004_030.png subfolder 7870eb10-4e7e-4d9e-994d-28c36de9ef0e\ t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST| GetFileName result https://demo.tmd.tv/Temp Upload/SA550004_030.png t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST|GetUrl. result https://demo.tmd.tv/Temp Upload/SA550004_030.png t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\SA550004_030.png subfolder t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/SA550004_030.png t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/SA550004_030.png t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST|GetUrl. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\2ef7cea0-3de8-4009-b761-480f193f5057\222.PNG subfolder 2ef7cea0-3de8-4009-b761-480f193f5057\ t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST| GetFileName result https://demo.tmd.tv/Temp Upload/222.PNG t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST|GetUrl. result https://demo.tmd.tv/Temp Upload/222.PNG t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\222.PNG subfolder t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/222.PNG t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/222.PNG t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST|GetUrl. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\e1cf266c-2637-4467-9b74-28d2adf78b07\disguise 구성도.PNG subfolder e1cf266c-2637-4467-9b74-28d2adf78b07\ t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST| GetFileName result https://demo.tmd.tv/Temp Upload/disguise%20%EA%B5%AC%EC%84%B1%EB%8F%84.PNG t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST|GetUrl. result https://demo.tmd.tv/Temp Upload/disguise%20%EA%B5%AC%EC%84%B1%EB%8F%84.PNG t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST|GetUrl. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\8c5776ff-f79d-4cb2-b20b-2f575dab6576\dd.png subfolder 8c5776ff-f79d-4cb2-b20b-2f575dab6576\ t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST| GetFileName result https://demo.tmd.tv/Temp Upload/dd.png t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST|GetUrl. result https://demo.tmd.tv/Temp Upload/dd.png t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\002.001_summer_palace_thumbnail_small_M0002041.png subfolder t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/002.001_summer_palace_thumbnail_small_M0002041.png t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/002.001_summer_palace_thumbnail_small_M0002041.png t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:37.3620|i27IMp|CJPOWERCAST|GetUrl. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\90dc2dfc-8225-426e-89d4-5008319c2a79\SA550004_108.png subfolder 90dc2dfc-8225-426e-89d4-5008319c2a79\ t Transfer: 1220 : 12|05:33:37.3776|i27IMp|CJPOWERCAST| GetFileName result https://demo.tmd.tv/Temp Upload/SA550004_108.png t Transfer: 1220 : 12|05:33:37.3776|i27IMp|CJPOWERCAST|GetUrl. result https://demo.tmd.tv/Temp Upload/SA550004_108.png t Transfer: 1220 : 12|05:33:37.3776|i27IMp|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:37.3776|i27IMp|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:37.3776|i27IMp|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:37.3776|i27IMp|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\SA550004_108.png subfolder t Transfer: 1220 : 12|05:33:37.3776|i27IMp|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/SA550004_108.png t Transfer: 1220 : 12|05:33:37.3776|i27IMp|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/SA550004_108.png t Transfer: 1220 : 12|05:33:37.3776|i27IMp|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:37.3776|i27IMp|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:37.3776|i27IMp|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:37.9870|TfMKS_|CJPOWERCAST|OAuth: /api/user-preferences?_dc=1693974839454 t Transfer: 1220 : 12|05:33:37.9870|TfMKS_|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:37.9870|TfMKS_|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:37.9870|TfMKS_|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:33:37.9870|TfMKS_|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 12|05:33:37.9870|TfMKS_|CJPOWERCAST|StoreUserDataByKeys.. t Transfer: 1220 : 12|05:33:37.9870|TfMKS_|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:37.9870|TfMKS_|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:37.9870|TfMKS_|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:33:37.9870|TfMKS_|CJPOWERCAST|imfx v3 API took 0.011s '/api/user-preferences?_dc=1693974839454' t Transfer: 1220 : 12|05:33:55.7151|xYOvyy|CJPOWERCAST|OAuth: /api/user-group-preferences?keys=googleMapsApiSettings&_dc=1693974857193 t Transfer: 1220 : 12|05:33:55.7151|xYOvyy|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:55.7151|xYOvyy|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:55.7151|xYOvyy|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:33:55.7151|xYOvyy|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|05:33:55.7151|xYOvyy|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:55.7151|xYOvyy|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:55.7151|xYOvyy|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:33:55.7151|xYOvyy|CJPOWERCAST|imfx v3 API took 0.008s '/api/user-group-preferences?keys=googleMapsApiSettings&_dc=1693974857193' t Transfer: 1220 : 12|05:33:55.9195|R4JBZn|CJPOWERCAST|OAuth: /api/v3/media-details/361520?_dc=1693974857432 t Transfer: 1220 : 12|05:33:55.9195|R4JBZn|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:55.9195|R4JBZn|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:55.9195|R4JBZn|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:33:55.9195|R4JBZn|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|05:33:55.9195|R4JBZn|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:55.9195|R4JBZn|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:55.9195|R4JBZn|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|05:33:56.5280|||TM_MIS. LoadSubtitles for ID: 361520 t Information: 1220 : 12|05:33:56.5280|||TM_MIS. LoadSubtitles for ID: 361520. SQL: 'select m.id, m.m_ctnr_id, m.m_ctnr_loc, m.modified_dt, m.tv_std, m.m_ctnr_fmt_id, d.sub_folder, nvl((select max(l.language) from tm_audio l where l.miid=m.id),aud_language_id) aud_language_id from tm_mis m left join tm_dfile d on (m.externally_owned_id=d.id) where m.mi_deleted=0 and m.item_type>0 and m.media_type=101 and m.miid1='MX361519'' t Information: 1220 : 12|05:33:56.5280|||TM_MIS. LoadSubtitles for ID: 361520 found no subtitles. t Verbose: 1220 : 12|05:33:56.7311|R4JBZn|CJPOWERCAST|imfx v3 API took 0.702s '/api/v3/media-details/361520?_dc=1693974857432' t Transfer: 1220 : 12|05:33:56.7311|R4JBZn|CJPOWERCAST|GetUrl. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\a9abc460-6022-4997-9f9f-efeef62d30d9\MH26-002.png subfolder a9abc460-6022-4997-9f9f-efeef62d30d9\ t Transfer: 1220 : 12|05:33:56.7311|R4JBZn|CJPOWERCAST| GetFileName result https://demo.tmd.tv/Temp Upload/MH26-002.png t Transfer: 1220 : 12|05:33:56.7311|R4JBZn|CJPOWERCAST|GetUrl. result https://demo.tmd.tv/Temp Upload/MH26-002.png t Transfer: 1220 : 12|05:33:56.7311|R4JBZn|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:56.7311|R4JBZn|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:56.7311|R4JBZn|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:33:56.9360|fxey4s|CJPOWERCAST|OAuth: /api/v3/detailsview/MediaDetails/9?lang=en-GB&_dc=1693974858472 t Transfer: 1220 : 12|05:33:56.9360|fxey4s|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:56.9360|fxey4s|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:56.9360|fxey4s|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:33:56.9360|fxey4s|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|05:33:56.9360|fxey4s|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:56.9360|fxey4s|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:56.9360|fxey4s|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|05:33:56.9360|fxey4s|CJPOWERCAST|GetSystemPref. Pref: DetailsView, Type: -4013, subType: 9 t Information: 1220 : 12|05:33:56.9360|fxey4s|CJPOWERCAST|GetSystemPref. Pref: DetailsView, Type: -4013, subType: 0 t Information: 1220 : 12|05:33:56.9360|fxey4s|CJPOWERCAST|GetSystemPref. Pref: DetailsView, Type: -4013, subType: 9 t Information: 1220 : 12|05:33:56.9360|fxey4s|CJPOWERCAST|GetSystemPref. Pref: DetailsView, Type: -4013, subType: 0 t Verbose: 1220 : 12|05:33:57.1419|fxey4s|CJPOWERCAST|imfx v3 API took 0.080s '/api/v3/detailsview/MediaDetails/9?lang=en-GB&_dc=1693974858472' t Transfer: 1220 : 12|05:33:57.5495|rzv9w3|CJPOWERCAST|OAuth: /api/lookups/FriendlyNames?_dc=1693974858969 t Transfer: 1220 : 12|05:33:57.5495|rzv9w3|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:57.5495|rzv9w3|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:57.5495|rzv9w3|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:33:57.5495|rzv9w3|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 12|05:33:57.5495|rzv9w3|CJPOWERCAST|imfx v3 API took 0.000s '/api/lookups/FriendlyNames?_dc=1693974858969' t Transfer: 1220 : 12|05:33:57.5495|tUDeYZ|CJPOWERCAST|OAuth: /api/metadata/4000/361520?_dc=1693974859074 t Transfer: 1220 : 12|05:33:57.5495|tUDeYZ|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:33:57.5495|tUDeYZ|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:33:57.5495|tUDeYZ|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:33:57.5495|tUDeYZ|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 12|05:33:57.7527|tUDeYZ|CJPOWERCAST|imfx v3 API took 0.076s '/api/metadata/4000/361520?_dc=1693974859074' t Transfer: 1220 : 12|05:34:06.3509|2YUKdP|CJPOWERCAST|OAuth: /api/v3/search/Media?_dc=1693974867860 t Transfer: 1220 : 12|05:34:06.3509|2YUKdP|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:34:06.3509|2YUKdP|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:34:06.3509|2YUKdP|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:34:06.3509|2YUKdP|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|05:34:06.3509|2YUKdP|CJPOWERCAST|V3Api.SearchMedia t Information: 1220 : 12|05:34:06.3509|2YUKdP|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|05:34:06.3509|2YUKdP|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:34:06.3509|2YUKdP|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:34:06.3509|2YUKdP|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|05:34:06.3509|2YUKdP|CJPOWERCAST|MediaSearch SQL: --sqlFromPaging select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type in (1,110)),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , (SELECT min(status.ACCESS_STATUS_NAME) FROM TMDDBA.TM_ACCESS_STATUS statusLnx, TM_CFG_ACCESS_STATUS status WHERE statusLnx.Media_Id = r.id and statusLnx.Status_Id = status.id) ACCESS_STATUS , (select min(acq.ext_ref) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) CONSIGNMENT_NUMBER , (select min(acq.alt_id1) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) TRANSFER_NUMBER , (select min(crs.series_number) from tm_series_data crs where crs.id = r.GROUP_SERIES_ID) CRS_SERIES , (select min(DISPOSAL_NAME) from TM_ACQ_DISPOSAL status, tm_disposal_records records where status.id = records.disposal_status_id and records.miid = r.id) DISPOSAL_STATUS , (select min(class.class_number) from TM_ACQ_DISPOSAL status, tm_disposal_records records, tm_disposal_classes class where status.id = records.disposal_status_id and records.miid = r.id and class.id = records.disposal_class_id) DISPOSAL_CLASS, (select min(names.concat_search_name) from tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names where r.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY, (select min(c.u_id_ext1) from tmddba.tm_mi_tpi_lnx lnx, tm_ctnrs c where c.u_id = lnx.tpiid and lnx.miid = r.id) U_ID_EXT1 , (select t.name from TM_CFG_MI_FMT_TYP t where t.id = r.mi_fmt_type) ITEM_FORMAT_TEXT, CASE WHEN BITAND(r.COMPIL, 2) = 2 THEN 'SUPPLIED' WHEN BITAND(r.COMPIL, 4) = 4 THEN 'MADE' WHEN BITAND(r.COMPIL, 134217728) = 134217728 THEN 'IMPORTED' ELSE '' END AS ORIGIN, CASE WHEN BITAND(r.COMPIL, 512) = 512 THEN 'Attached' WHEN BITAND(r.COMPIL, 1024) = 1024 THEN 'Un-Attached' ELSE '' END AS FLAGS, (select min(lang.full_name) from TM_PG_RL_LANG_LNX lnx, TM_LANG_DATA lang where lnx.tm_pg_rl_id = r.pgm_parent_id and lnx.lang_id = lang.id) AS PROD_LANGUAGE , (select min(ctx.ITFC_CODE) from tm_mis mis, tm_mi_tpi_lnx links, tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names where mis.id = r.id and links.miid = mis.id and mis.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY_NUMBER, (select min(status.description) from TM_CFG_PGM_STATUS status where r.status = status.id) PGM_STATUS_TEXT, (select min(ver.DUR) from TM_PG_RL ver where r.pgm_PARENT_ID = ver.id) AS VERSION_DUR , (select tmd_str_agg_pipe(cms.status_type_id ||',' ||cms.status_id) from tm_mi_cust_med_stat_lnx cms where cms.media_id=r.id) "CustomStatusesRaw", (select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = r.net_grp_id) CHANNEL_GROUP, (SELECT SUBSTR( trim( replace (replace ( LISTAGG(trim(tt.tags || ' ' || tt.notes), ' ') WITHIN GROUP (ORDER BY trim(tt.tags || ' ' || tt.notes)), chr (13), ''), chr (10), ' ')), 1, 150) z FROM tm_media_tagging tt WHERE link_guid = DFILE_LINK_GUID and rownum=1) TAGS_TEXT , GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select t.*, coalesce(t.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=t.pgm_parent_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.pgm_abs_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs2_id) ) primary_thumb_id2 from ( --sqlSubSelect select s.* from (select a.*, rownum rnum from (select --sqlFrom m.* from tmddba.tm_mis m --sqlWhere where media_type>0 and item_type>0 AND m.ID = :param_0 and m.mi_deleted=0 AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0) order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) s where rnum >= 1) t ) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl order by r.rnum t Verbose: 1220 : 12|05:34:06.9617|2YUKdP|CJPOWERCAST|Alternative title fields query: select * from (select x.id,x.pgm_abs_id TitleId, x.pgm_parent_id VersionId from tm_mis x where id in (select /*+ cardinality(4) */ column_value id from table(:ids))) y,lateral (select dbms_lob.substr( o.text_data_plain, 1000, 1 ) Field_5799344 from tm_txt_obj o where (o.pgm_abs_id=y.TitleId or o.pgm_rl_id = y.VersionId) and o.type_id=:param_1 order by o.id desc fetch first 1 rows only)(+) t Information: 1220 : 12|05:34:06.9617|2YUKdP|CJPOWERCAST| timing: 00:00:00.5721184 t Verbose: 1220 : 12|05:34:06.9617|2YUKdP|CJPOWERCAST|imfx v3 API took 0.573s '/api/v3/search/Media?_dc=1693974867860' t Transfer: 1220 : 12|05:34:06.9617|2YUKdP|CJPOWERCAST|GetUrl. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\a9abc460-6022-4997-9f9f-efeef62d30d9\MH26-002.png subfolder a9abc460-6022-4997-9f9f-efeef62d30d9\ t Transfer: 1220 : 12|05:34:06.9617|2YUKdP|CJPOWERCAST| GetFileName result https://demo.tmd.tv/Temp Upload/MH26-002.png t Transfer: 1220 : 12|05:34:06.9617|2YUKdP|CJPOWERCAST|GetUrl. result https://demo.tmd.tv/Temp Upload/MH26-002.png t Transfer: 1220 : 12|05:34:06.9617|2YUKdP|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:34:06.9617|2YUKdP|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:34:06.9617|2YUKdP|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:34:11.0397|BVaUTT|CJPOWERCAST|OAuth: /api/v3/media-details/361588?_dc=1693974872596 t Transfer: 1220 : 12|05:34:11.0397|BVaUTT|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:34:11.0397|BVaUTT|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:34:11.0397|BVaUTT|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:34:11.0397|BVaUTT|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|05:34:11.0397|BVaUTT|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:34:11.0397|BVaUTT|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:34:11.0397|BVaUTT|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|05:34:11.0397|||TM_MIS. LoadSubtitles for ID: 361588 t Information: 1220 : 12|05:34:11.0397|||TM_MIS. LoadSubtitles for ID: 361588. SQL: 'select m.id, m.m_ctnr_id, m.m_ctnr_loc, m.modified_dt, m.tv_std, m.m_ctnr_fmt_id, d.sub_folder, nvl((select max(l.language) from tm_audio l where l.miid=m.id),aud_language_id) aud_language_id from tm_mis m left join tm_dfile d on (m.externally_owned_id=d.id) where m.mi_deleted=0 and m.item_type>0 and m.media_type=101 and m.miid1='MX361588'' t Information: 1220 : 12|05:34:11.2584|||TM_MIS. LoadSubtitles for ID: 361588 found no subtitles. t Verbose: 1220 : 12|05:34:11.2584|BVaUTT|CJPOWERCAST|imfx v3 API took 0.117s '/api/v3/media-details/361588?_dc=1693974872596' t Transfer: 1220 : 12|05:34:11.2584|BVaUTT|CJPOWERCAST|GetUrl. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\49ad8633-3f5e-4b34-886d-45603d50e05d\ECM-0298.png subfolder 49ad8633-3f5e-4b34-886d-45603d50e05d\ t Transfer: 1220 : 12|05:34:11.2584|BVaUTT|CJPOWERCAST| GetFileName result https://demo.tmd.tv/Temp Upload/ECM-0298.png t Transfer: 1220 : 12|05:34:11.2584|BVaUTT|CJPOWERCAST|GetUrl. result https://demo.tmd.tv/Temp Upload/ECM-0298.png t Transfer: 1220 : 12|05:34:11.2584|BVaUTT|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:34:11.2584|BVaUTT|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:34:11.2584|BVaUTT|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:34:11.6647|eocK1U|CJPOWERCAST|OAuth: /api/metadata/4000/361588?_dc=1693974873164 t Transfer: 1220 : 12|05:34:11.6647|eocK1U|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:34:11.6647|eocK1U|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:34:11.6647|eocK1U|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:34:11.6647|eocK1U|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 12|05:34:11.6647|eocK1U|CJPOWERCAST|imfx v3 API took 0.003s '/api/metadata/4000/361588?_dc=1693974873164' t Transfer: 1220 : 12|05:34:14.1181|lnYkff|CJPOWERCAST|OAuth: /api/v3/search/Media?_dc=1693974875578 t Transfer: 1220 : 12|05:34:14.1181|lnYkff|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:34:14.1181|lnYkff|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:34:14.1181|lnYkff|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:34:14.1181|lnYkff|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|05:34:14.1181|lnYkff|CJPOWERCAST|V3Api.SearchMedia t Information: 1220 : 12|05:34:14.1181|lnYkff|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|05:34:14.1181|lnYkff|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:34:14.1181|lnYkff|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:34:14.1181|lnYkff|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|05:34:14.1181|lnYkff|CJPOWERCAST|MediaSearch SQL: --sqlFromPaging select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type in (1,110)),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , (SELECT min(status.ACCESS_STATUS_NAME) FROM TMDDBA.TM_ACCESS_STATUS statusLnx, TM_CFG_ACCESS_STATUS status WHERE statusLnx.Media_Id = r.id and statusLnx.Status_Id = status.id) ACCESS_STATUS , (select min(acq.ext_ref) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) CONSIGNMENT_NUMBER , (select min(acq.alt_id1) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) TRANSFER_NUMBER , (select min(crs.series_number) from tm_series_data crs where crs.id = r.GROUP_SERIES_ID) CRS_SERIES , (select min(DISPOSAL_NAME) from TM_ACQ_DISPOSAL status, tm_disposal_records records where status.id = records.disposal_status_id and records.miid = r.id) DISPOSAL_STATUS , (select min(class.class_number) from TM_ACQ_DISPOSAL status, tm_disposal_records records, tm_disposal_classes class where status.id = records.disposal_status_id and records.miid = r.id and class.id = records.disposal_class_id) DISPOSAL_CLASS, (select min(names.concat_search_name) from tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names where r.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY, (select min(c.u_id_ext1) from tmddba.tm_mi_tpi_lnx lnx, tm_ctnrs c where c.u_id = lnx.tpiid and lnx.miid = r.id) U_ID_EXT1 , (select t.name from TM_CFG_MI_FMT_TYP t where t.id = r.mi_fmt_type) ITEM_FORMAT_TEXT, CASE WHEN BITAND(r.COMPIL, 2) = 2 THEN 'SUPPLIED' WHEN BITAND(r.COMPIL, 4) = 4 THEN 'MADE' WHEN BITAND(r.COMPIL, 134217728) = 134217728 THEN 'IMPORTED' ELSE '' END AS ORIGIN, CASE WHEN BITAND(r.COMPIL, 512) = 512 THEN 'Attached' WHEN BITAND(r.COMPIL, 1024) = 1024 THEN 'Un-Attached' ELSE '' END AS FLAGS, (select min(lang.full_name) from TM_PG_RL_LANG_LNX lnx, TM_LANG_DATA lang where lnx.tm_pg_rl_id = r.pgm_parent_id and lnx.lang_id = lang.id) AS PROD_LANGUAGE , (select min(ctx.ITFC_CODE) from tm_mis mis, tm_mi_tpi_lnx links, tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names where mis.id = r.id and links.miid = mis.id and mis.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY_NUMBER, (select min(status.description) from TM_CFG_PGM_STATUS status where r.status = status.id) PGM_STATUS_TEXT, (select min(ver.DUR) from TM_PG_RL ver where r.pgm_PARENT_ID = ver.id) AS VERSION_DUR , (select tmd_str_agg_pipe(cms.status_type_id ||',' ||cms.status_id) from tm_mi_cust_med_stat_lnx cms where cms.media_id=r.id) "CustomStatusesRaw", (select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = r.net_grp_id) CHANNEL_GROUP, (SELECT SUBSTR( trim( replace (replace ( LISTAGG(trim(tt.tags || ' ' || tt.notes), ' ') WITHIN GROUP (ORDER BY trim(tt.tags || ' ' || tt.notes)), chr (13), ''), chr (10), ' ')), 1, 150) z FROM tm_media_tagging tt WHERE link_guid = DFILE_LINK_GUID and rownum=1) TAGS_TEXT , GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select t.*, coalesce(t.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=t.pgm_parent_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.pgm_abs_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs2_id) ) primary_thumb_id2 from ( --sqlSubSelect select s.* from (select a.*, rownum rnum from (select --sqlFrom m.* from tmddba.tm_mis m --sqlWhere where media_type>0 and item_type>0 AND m.ID = :param_0 and m.mi_deleted=0 AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0) order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) s where rnum >= 1) t ) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl order by r.rnum t Verbose: 1220 : 12|05:34:14.1181|lnYkff|CJPOWERCAST|Alternative title fields query: select * from (select x.id,x.pgm_abs_id TitleId, x.pgm_parent_id VersionId from tm_mis x where id in (select /*+ cardinality(4) */ column_value id from table(:ids))) y,lateral (select dbms_lob.substr( o.text_data_plain, 1000, 1 ) Field_5799344 from tm_txt_obj o where (o.pgm_abs_id=y.TitleId or o.pgm_rl_id = y.VersionId) and o.type_id=:param_1 order by o.id desc fetch first 1 rows only)(+) t Information: 1220 : 12|05:34:14.1181|lnYkff|CJPOWERCAST| timing: 00:00:00.0206579 t Verbose: 1220 : 12|05:34:14.1181|lnYkff|CJPOWERCAST|imfx v3 API took 0.021s '/api/v3/search/Media?_dc=1693974875578' t Transfer: 1220 : 12|05:34:14.1181|lnYkff|CJPOWERCAST|GetUrl. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\49ad8633-3f5e-4b34-886d-45603d50e05d\ECM-0298.png subfolder 49ad8633-3f5e-4b34-886d-45603d50e05d\ t Transfer: 1220 : 12|05:34:14.1181|lnYkff|CJPOWERCAST| GetFileName result https://demo.tmd.tv/Temp Upload/ECM-0298.png t Transfer: 1220 : 12|05:34:14.1181|lnYkff|CJPOWERCAST|GetUrl. result https://demo.tmd.tv/Temp Upload/ECM-0298.png t Transfer: 1220 : 12|05:34:14.1181|lnYkff|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:34:14.1181|lnYkff|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:34:14.1181|lnYkff|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:34:19.4192|dK1OLC|CJPOWERCAST|OAuth: /api/v3/media-details/361522?_dc=1693974880851 t Transfer: 1220 : 12|05:34:19.4192|dK1OLC|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:34:19.4192|dK1OLC|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:34:19.4192|dK1OLC|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:34:19.4192|dK1OLC|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|05:34:19.4192|dK1OLC|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:34:19.4192|dK1OLC|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:34:19.4192|dK1OLC|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|05:34:19.4192|||TM_MIS. LoadSubtitles for ID: 361522 t Information: 1220 : 12|05:34:19.4192|||TM_MIS. LoadSubtitles for ID: 361522. SQL: 'select m.id, m.m_ctnr_id, m.m_ctnr_loc, m.modified_dt, m.tv_std, m.m_ctnr_fmt_id, d.sub_folder, nvl((select max(l.language) from tm_audio l where l.miid=m.id),aud_language_id) aud_language_id from tm_mis m left join tm_dfile d on (m.externally_owned_id=d.id) where m.mi_deleted=0 and m.item_type>0 and m.media_type=101 and m.miid1='MX361519'' t Information: 1220 : 12|05:34:19.4192|||TM_MIS. LoadSubtitles for ID: 361522 found no subtitles. t Verbose: 1220 : 12|05:34:19.4192|dK1OLC|CJPOWERCAST|imfx v3 API took 0.024s '/api/v3/media-details/361522?_dc=1693974880851' t Transfer: 1220 : 12|05:34:19.4192|dK1OLC|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\MH26-002.png subfolder t Transfer: 1220 : 12|05:34:19.4192|dK1OLC|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/MH26-002.png t Transfer: 1220 : 12|05:34:19.4192|dK1OLC|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/MH26-002.png t Transfer: 1220 : 12|05:34:19.4192|dK1OLC|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:34:19.4192|dK1OLC|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:34:19.4192|dK1OLC|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:34:19.8255|9ElP7P|CJPOWERCAST|OAuth: /api/metadata/4000/361522?_dc=1693974881404 t Transfer: 1220 : 12|05:34:19.8255|9ElP7P|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:34:19.8255|9ElP7P|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:34:19.8255|9ElP7P|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:34:19.8255|9ElP7P|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 12|05:34:19.8255|9ElP7P|CJPOWERCAST|imfx v3 API took 0.003s '/api/metadata/4000/361522?_dc=1693974881404' t Transfer: 1220 : 12|05:34:27.9883|a_qoU2|CJPOWERCAST|OAuth: /api/v3/search/Media?_dc=1693974889507 t Transfer: 1220 : 12|05:34:27.9883|a_qoU2|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:34:27.9883|a_qoU2|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:34:27.9883|a_qoU2|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:34:27.9883|a_qoU2|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|05:34:27.9883|a_qoU2|CJPOWERCAST|V3Api.SearchMedia t Information: 1220 : 12|05:34:27.9883|a_qoU2|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|05:34:27.9883|a_qoU2|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:34:27.9883|a_qoU2|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:34:27.9883|a_qoU2|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|05:34:27.9883|a_qoU2|CJPOWERCAST|MediaSearch SQL: --sqlFromPaging select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type in (1,110)),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , (SELECT min(status.ACCESS_STATUS_NAME) FROM TMDDBA.TM_ACCESS_STATUS statusLnx, TM_CFG_ACCESS_STATUS status WHERE statusLnx.Media_Id = r.id and statusLnx.Status_Id = status.id) ACCESS_STATUS , (select min(acq.ext_ref) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) CONSIGNMENT_NUMBER , (select min(acq.alt_id1) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) TRANSFER_NUMBER , (select min(crs.series_number) from tm_series_data crs where crs.id = r.GROUP_SERIES_ID) CRS_SERIES , (select min(DISPOSAL_NAME) from TM_ACQ_DISPOSAL status, tm_disposal_records records where status.id = records.disposal_status_id and records.miid = r.id) DISPOSAL_STATUS , (select min(class.class_number) from TM_ACQ_DISPOSAL status, tm_disposal_records records, tm_disposal_classes class where status.id = records.disposal_status_id and records.miid = r.id and class.id = records.disposal_class_id) DISPOSAL_CLASS, (select min(names.concat_search_name) from tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names where r.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY, (select min(c.u_id_ext1) from tmddba.tm_mi_tpi_lnx lnx, tm_ctnrs c where c.u_id = lnx.tpiid and lnx.miid = r.id) U_ID_EXT1 , (select t.name from TM_CFG_MI_FMT_TYP t where t.id = r.mi_fmt_type) ITEM_FORMAT_TEXT, CASE WHEN BITAND(r.COMPIL, 2) = 2 THEN 'SUPPLIED' WHEN BITAND(r.COMPIL, 4) = 4 THEN 'MADE' WHEN BITAND(r.COMPIL, 134217728) = 134217728 THEN 'IMPORTED' ELSE '' END AS ORIGIN, CASE WHEN BITAND(r.COMPIL, 512) = 512 THEN 'Attached' WHEN BITAND(r.COMPIL, 1024) = 1024 THEN 'Un-Attached' ELSE '' END AS FLAGS, (select min(lang.full_name) from TM_PG_RL_LANG_LNX lnx, TM_LANG_DATA lang where lnx.tm_pg_rl_id = r.pgm_parent_id and lnx.lang_id = lang.id) AS PROD_LANGUAGE , (select min(ctx.ITFC_CODE) from tm_mis mis, tm_mi_tpi_lnx links, tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names where mis.id = r.id and links.miid = mis.id and mis.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY_NUMBER, (select min(status.description) from TM_CFG_PGM_STATUS status where r.status = status.id) PGM_STATUS_TEXT, (select min(ver.DUR) from TM_PG_RL ver where r.pgm_PARENT_ID = ver.id) AS VERSION_DUR , (select tmd_str_agg_pipe(cms.status_type_id ||',' ||cms.status_id) from tm_mi_cust_med_stat_lnx cms where cms.media_id=r.id) "CustomStatusesRaw", (select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = r.net_grp_id) CHANNEL_GROUP, (SELECT SUBSTR( trim( replace (replace ( LISTAGG(trim(tt.tags || ' ' || tt.notes), ' ') WITHIN GROUP (ORDER BY trim(tt.tags || ' ' || tt.notes)), chr (13), ''), chr (10), ' ')), 1, 150) z FROM tm_media_tagging tt WHERE link_guid = DFILE_LINK_GUID and rownum=1) TAGS_TEXT , GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select t.*, coalesce(t.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=t.pgm_parent_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.pgm_abs_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs2_id) ) primary_thumb_id2 from ( --sqlSubSelect select s.* from (select a.*, rownum rnum from (select --sqlFrom m.* from tmddba.tm_mis m --sqlWhere where media_type>0 and item_type>0 AND m.ID = :param_0 and m.mi_deleted=0 AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0) order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) s where rnum >= 1) t ) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl order by r.rnum t Verbose: 1220 : 12|05:34:27.9883|a_qoU2|CJPOWERCAST|Alternative title fields query: select * from (select x.id,x.pgm_abs_id TitleId, x.pgm_parent_id VersionId from tm_mis x where id in (select /*+ cardinality(4) */ column_value id from table(:ids))) y,lateral (select dbms_lob.substr( o.text_data_plain, 1000, 1 ) Field_5799344 from tm_txt_obj o where (o.pgm_abs_id=y.TitleId or o.pgm_rl_id = y.VersionId) and o.type_id=:param_1 order by o.id desc fetch first 1 rows only)(+) t Information: 1220 : 12|05:34:27.9883|a_qoU2|CJPOWERCAST| timing: 00:00:00.0260131 t Verbose: 1220 : 12|05:34:27.9883|a_qoU2|CJPOWERCAST|imfx v3 API took 0.026s '/api/v3/search/Media?_dc=1693974889507' t Transfer: 1220 : 12|05:34:27.9883|a_qoU2|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\MH26-002.png subfolder t Transfer: 1220 : 12|05:34:27.9883|a_qoU2|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/MH26-002.png t Transfer: 1220 : 12|05:34:27.9883|a_qoU2|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/MH26-002.png t Transfer: 1220 : 12|05:34:27.9883|a_qoU2|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:34:27.9883|a_qoU2|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:34:27.9883|a_qoU2|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:34:30.2295|z1Shh7|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1693974891800 t Transfer: 1220 : 12|05:34:30.2295|z1Shh7|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:34:30.2295|z1Shh7|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:34:30.2295|z1Shh7|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:34:30.2295|z1Shh7|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|05:34:30.2295|z1Shh7|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:34:30.2295|z1Shh7|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:34:30.2295|z1Shh7|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:34:30.2295|z1Shh7|CJPOWERCAST|imfx v3 API took 0.002s '/api/v3/search-suggestion/?_dc=1693974891800' t Transfer: 1220 : 12|05:34:30.6358|eIrFsR|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1693974892147 t Transfer: 1220 : 12|05:34:30.6358|eIrFsR|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:34:30.6358|eIrFsR|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:34:30.6358|eIrFsR|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:34:30.6358|eIrFsR|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|05:34:30.6358|eIrFsR|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:34:30.6358|eIrFsR|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:34:30.6358|eIrFsR|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:34:30.6358|eIrFsR|CJPOWERCAST|imfx v3 API took 0.004s '/api/v3/search-suggestion/?_dc=1693974892147' t Transfer: 1220 : 12|05:34:31.6514|~IsphK|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1693974893144 t Transfer: 1220 : 12|05:34:31.6514|~IsphK|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:34:31.6514|~IsphK|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:34:31.6514|~IsphK|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:34:31.6514|~IsphK|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|05:34:31.6514|~IsphK|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:34:31.6514|~IsphK|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:34:31.6514|~IsphK|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:34:31.6514|~IsphK|CJPOWERCAST|imfx v3 API took 0.005s '/api/v3/search-suggestion/?_dc=1693974893144' t Transfer: 1220 : 12|05:34:31.8545|OnAOLE|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1693974893330 t Transfer: 1220 : 12|05:34:31.8545|OnAOLE|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:34:31.8545|OnAOLE|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:34:31.8545|OnAOLE|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:34:31.8545|OnAOLE|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|05:34:31.8545|OnAOLE|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:34:31.8545|OnAOLE|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:34:31.8545|OnAOLE|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:34:31.8545|OnAOLE|CJPOWERCAST|imfx v3 API took 0.005s '/api/v3/search-suggestion/?_dc=1693974893330' t Transfer: 1220 : 12|05:34:32.4655|hGhDkT|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1693974893910 t Transfer: 1220 : 12|05:34:32.4655|hGhDkT|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:34:32.4655|hGhDkT|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:34:32.4655|hGhDkT|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:34:32.4655|hGhDkT|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|05:34:32.4655|hGhDkT|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:34:32.4655|hGhDkT|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:34:32.4655|hGhDkT|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:34:32.4655|hGhDkT|CJPOWERCAST|imfx v3 API took 0.005s '/api/v3/search-suggestion/?_dc=1693974893910' t Transfer: 1220 : 12|05:34:32.4655|dxKVme|CJPOWERCAST|OAuth: /api/v3/search/Media?_dc=1693974894066 t Transfer: 1220 : 12|05:34:32.4655|dxKVme|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:34:32.4655|dxKVme|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:34:32.4655|dxKVme|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:34:32.4655|dxKVme|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|05:34:32.4655|dxKVme|CJPOWERCAST|V3Api.SearchMedia t Information: 1220 : 12|05:34:32.4655|dxKVme|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|05:34:32.4655|dxKVme|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:34:32.4655|dxKVme|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:34:32.4655|dxKVme|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|05:34:32.4655|dxKVme|CJPOWERCAST|Running solr search: [q, (((title:(* && jpg))^2 OR series:(* && jpg) OR ((filename:(*.jpg) OR filename:(*.jpg.*)) OR filename:"*.jpg") OR (titleMergedNgram:*jpg*)^10 OR miid1:(*.jpg) OR miid2:(*.jpg) OR versionid1:(*.jpg) OR progid1:(*.jpg)) AND deleted_flag:(0) AND (owners:((SFP2) OR (PSP) OR (PMS) OR (SFP1) OR (PMH) OR (PPL))))] t Information: 1220 : 12|05:34:32.6687|dxKVme|CJPOWERCAST|Solr query returned: 13 in 67ms t Information: 1220 : 12|05:34:32.6687|dxKVme|CJPOWERCAST|MediaSearch SQL: --sqlFromPaging select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type in (1,110)),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , (SELECT min(status.ACCESS_STATUS_NAME) FROM TMDDBA.TM_ACCESS_STATUS statusLnx, TM_CFG_ACCESS_STATUS status WHERE statusLnx.Media_Id = r.id and statusLnx.Status_Id = status.id) ACCESS_STATUS , (select min(acq.ext_ref) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) CONSIGNMENT_NUMBER , (select min(acq.alt_id1) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) TRANSFER_NUMBER , (select min(crs.series_number) from tm_series_data crs where crs.id = r.GROUP_SERIES_ID) CRS_SERIES , (select min(DISPOSAL_NAME) from TM_ACQ_DISPOSAL status, tm_disposal_records records where status.id = records.disposal_status_id and records.miid = r.id) DISPOSAL_STATUS , (select min(class.class_number) from TM_ACQ_DISPOSAL status, tm_disposal_records records, tm_disposal_classes class where status.id = records.disposal_status_id and records.miid = r.id and class.id = records.disposal_class_id) DISPOSAL_CLASS, (select min(names.concat_search_name) from tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names where r.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY, (select min(c.u_id_ext1) from tmddba.tm_mi_tpi_lnx lnx, tm_ctnrs c where c.u_id = lnx.tpiid and lnx.miid = r.id) U_ID_EXT1 , (select t.name from TM_CFG_MI_FMT_TYP t where t.id = r.mi_fmt_type) ITEM_FORMAT_TEXT, CASE WHEN BITAND(r.COMPIL, 2) = 2 THEN 'SUPPLIED' WHEN BITAND(r.COMPIL, 4) = 4 THEN 'MADE' WHEN BITAND(r.COMPIL, 134217728) = 134217728 THEN 'IMPORTED' ELSE '' END AS ORIGIN, CASE WHEN BITAND(r.COMPIL, 512) = 512 THEN 'Attached' WHEN BITAND(r.COMPIL, 1024) = 1024 THEN 'Un-Attached' ELSE '' END AS FLAGS, (select min(lang.full_name) from TM_PG_RL_LANG_LNX lnx, TM_LANG_DATA lang where lnx.tm_pg_rl_id = r.pgm_parent_id and lnx.lang_id = lang.id) AS PROD_LANGUAGE , (select min(ctx.ITFC_CODE) from tm_mis mis, tm_mi_tpi_lnx links, tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names where mis.id = r.id and links.miid = mis.id and mis.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY_NUMBER, (select min(status.description) from TM_CFG_PGM_STATUS status where r.status = status.id) PGM_STATUS_TEXT, (select min(ver.DUR) from TM_PG_RL ver where r.pgm_PARENT_ID = ver.id) AS VERSION_DUR , (select tmd_str_agg_pipe(cms.status_type_id ||',' ||cms.status_id) from tm_mi_cust_med_stat_lnx cms where cms.media_id=r.id) "CustomStatusesRaw", (select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = r.net_grp_id) CHANNEL_GROUP, (SELECT SUBSTR( trim( replace (replace ( LISTAGG(trim(tt.tags || ' ' || tt.notes), ' ') WITHIN GROUP (ORDER BY trim(tt.tags || ' ' || tt.notes)), chr (13), ''), chr (10), ' ')), 1, 150) z FROM tm_media_tagging tt WHERE link_guid = DFILE_LINK_GUID and rownum=1) TAGS_TEXT , GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select t.*, coalesce(t.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=t.pgm_parent_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.pgm_abs_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs2_id) ) primary_thumb_id2 from ( --sqlSubSelect select s.* from (select a.*, rownum rnum from (select --sqlFrom m.* from tmddba.tm_mis m ,(select /*+ cardinality(4) */ rownum rn, column_value id from table(:ids)) ids --sqlWhere where m.id = ids.id order by ids.rn ) a where rownum <= 10000) s where rnum >= 1) t ) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl order by rnum t Verbose: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST|Alternative title fields query: select * from (select x.id,x.pgm_abs_id TitleId, x.pgm_parent_id VersionId from tm_mis x where id in (select /*+ cardinality(4) */ column_value id from table(:ids))) y,lateral (select dbms_lob.substr( o.text_data_plain, 1000, 1 ) Field_5799344 from tm_txt_obj o where (o.pgm_abs_id=y.TitleId or o.pgm_rl_id = y.VersionId) and o.type_id=:param_1 order by o.id desc fetch first 1 rows only)(+) t Information: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST| timing: 00:00:00.3862148 t Verbose: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST|imfx v3 API took 0.386s '/api/v3/search/Media?_dc=1693974894066' t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\Outernet_NOW__Exterior_Aquarium.jpg subfolder t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/Outernet_NOW__Exterior_Aquarium.jpg t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/Outernet_NOW__Exterior_Aquarium.jpg t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\snow-game-of-thrones-1200x600.jpg subfolder t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/snow-game-of-thrones-1200x600.jpg t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/snow-game-of-thrones-1200x600.jpg t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\Game_of_Thrones_Still_4.jpg subfolder t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/Game_of_Thrones_Still_4.jpg t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/Game_of_Thrones_Still_4.jpg t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\game-of-thrones-1349.jpg subfolder t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/game-of-thrones-1349.jpg t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/game-of-thrones-1349.jpg t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\game-of-thrones-daenerys.jpg subfolder t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/game-of-thrones-daenerys.jpg t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/game-of-thrones-daenerys.jpg t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\young cersei game of thrones helen sloan.jpeg.jpg subfolder t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/young%20cersei%20game%20of%20thrones%20helen%20sloan.jpeg.jpg t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/young%20cersei%20game%20of%20thrones%20helen%20sloan.jpeg.jpg t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\gotspecialspromosimage.jpg subfolder t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/gotspecialspromosimage.jpg t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/gotspecialspromosimage.jpg t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST|GetUrl. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\92b123c1-1fb2-469f-861a-b25bf59aea80\뚝딱이의 역습_가이드.jpg subfolder 92b123c1-1fb2-469f-861a-b25bf59aea80\ t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST| GetFileName result https://demo.tmd.tv/Temp Upload/%EB%9A%9D%EB%94%B1%EC%9D%B4%EC%9D%98%20%EC%97%AD%EC%8A%B5_%EA%B0%80%EC%9D%B4%EB%93%9C.jpg t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST|GetUrl. result https://demo.tmd.tv/Temp Upload/%EB%9A%9D%EB%94%B1%EC%9D%B4%EC%9D%98%20%EC%97%AD%EC%8A%B5_%EA%B0%80%EC%9D%B4%EB%93%9C.jpg t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\뚝딱이의 역습_가이드.jpg subfolder t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/%EB%9A%9D%EB%94%B1%EC%9D%B4%EC%9D%98%20%EC%97%AD%EC%8A%B5_%EA%B0%80%EC%9D%B4%EB%93%9C.jpg t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/%EB%9A%9D%EB%94%B1%EC%9D%B4%EC%9D%98%20%EC%97%AD%EC%8A%B5_%EA%B0%80%EC%9D%B4%EB%93%9C.jpg t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\뚝딱이의 역습.jpg subfolder t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/%EB%9A%9D%EB%94%B1%EC%9D%B4%EC%9D%98%20%EC%97%AD%EC%8A%B5.jpg t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/%EB%9A%9D%EB%94%B1%EC%9D%B4%EC%9D%98%20%EC%97%AD%EC%8A%B5.jpg t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST|GetUrl. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\4da107c0-40d0-4f0b-b037-ca5ff917348d\0527_퍼즐오브Z 시보_폰트가이드.jpg subfolder 4da107c0-40d0-4f0b-b037-ca5ff917348d\ t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST| GetFileName result https://demo.tmd.tv/Temp Upload/0527_%ED%8D%BC%EC%A6%90%EC%98%A4%EB%B8%8CZ%20%EC%8B%9C%EB%B3%B4_%ED%8F%B0%ED%8A%B8%EA%B0%80%EC%9D%B4%EB%93%9C.jpg t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST|GetUrl. result https://demo.tmd.tv/Temp Upload/0527_%ED%8D%BC%EC%A6%90%EC%98%A4%EB%B8%8CZ%20%EC%8B%9C%EB%B3%B4_%ED%8F%B0%ED%8A%B8%EA%B0%80%EC%9D%B4%EB%93%9C.jpg t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\002.001_summer_palace_thumbnail_small.jpg subfolder t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/002.001_summer_palace_thumbnail_small.jpg t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/002.001_summer_palace_thumbnail_small.jpg t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\P1040405.JPG subfolder t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/P1040405.JPG t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/P1040405.JPG t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:34:32.8718|dxKVme|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:34:33.4953|Dwcuj3|CJPOWERCAST|OAuth: /api/user-preferences?_dc=1693974894950 t Transfer: 1220 : 12|05:34:33.4953|Dwcuj3|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:34:33.4953|Dwcuj3|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:34:33.4953|Dwcuj3|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:34:33.4953|Dwcuj3|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 12|05:34:33.4953|Dwcuj3|CJPOWERCAST|StoreUserDataByKeys.. t Transfer: 1220 : 12|05:34:33.4953|Dwcuj3|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:34:33.4953|Dwcuj3|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:34:33.4953|Dwcuj3|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:34:33.4953|Dwcuj3|CJPOWERCAST|imfx v3 API took 0.006s '/api/user-preferences?_dc=1693974894950' t Transfer: 1220 : 12|05:34:43.0856|MuMLQp|CJPOWERCAST|OAuth: /api/v3/media-details/292196?_dc=1693974904489 t Transfer: 1220 : 12|05:34:43.0856|MuMLQp|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:34:43.0856|MuMLQp|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:34:43.0856|MuMLQp|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:34:43.0856|MuMLQp|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|05:34:43.0856|MuMLQp|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:34:43.0856|MuMLQp|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:34:43.0856|MuMLQp|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|05:34:43.0856|||TM_MIS. LoadSubtitles for ID: 292196 t Information: 1220 : 12|05:34:43.0856|||TM_MIS. LoadSubtitles for ID: 292196. SQL: 'select m.id, m.m_ctnr_id, m.m_ctnr_loc, m.modified_dt, m.tv_std, m.m_ctnr_fmt_id, d.sub_folder, nvl((select max(l.language) from tm_audio l where l.miid=m.id),aud_language_id) aud_language_id from tm_mis m left join tm_dfile d on (m.externally_owned_id=d.id) where m.mi_deleted=0 and m.item_type>0 and m.media_type=101 and m.PGM_PARENT_ID=278630' t Information: 1220 : 12|05:34:43.0856|||TM_MIS. LoadSubtitles for ID: 292196 found no subtitles. t Verbose: 1220 : 12|05:34:43.0856|MuMLQp|CJPOWERCAST|imfx v3 API took 0.036s '/api/v3/media-details/292196?_dc=1693974904489' t Transfer: 1220 : 12|05:34:43.0856|MuMLQp|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\snow-game-of-thrones-1200x600.jpg subfolder t Transfer: 1220 : 12|05:34:43.0856|MuMLQp|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/snow-game-of-thrones-1200x600.jpg t Transfer: 1220 : 12|05:34:43.0856|MuMLQp|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/snow-game-of-thrones-1200x600.jpg t Transfer: 1220 : 12|05:34:43.0856|MuMLQp|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:34:43.0856|MuMLQp|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:34:43.0856|MuMLQp|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:34:43.4920|YmsXQg|CJPOWERCAST|OAuth: /api/metadata/4000/292196?_dc=1693974905052 t Transfer: 1220 : 12|05:34:43.4920|YmsXQg|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:34:43.4920|YmsXQg|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:34:43.4920|YmsXQg|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:34:43.4920|YmsXQg|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 12|05:34:43.4920|YmsXQg|CJPOWERCAST|imfx v3 API took 0.006s '/api/metadata/4000/292196?_dc=1693974905052' t Transfer: 1220 : 12|05:34:49.6135|sagD0R|CJPOWERCAST|OAuth: /api/v3/search/Media?_dc=1693974911194 t Transfer: 1220 : 12|05:34:49.6135|sagD0R|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:34:49.6135|sagD0R|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:34:49.6135|sagD0R|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:34:49.6135|sagD0R|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|05:34:49.6135|sagD0R|CJPOWERCAST|V3Api.SearchMedia t Information: 1220 : 12|05:34:49.6135|sagD0R|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|05:34:49.6135|sagD0R|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:34:49.6135|sagD0R|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:34:49.6135|sagD0R|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|05:34:49.6135|sagD0R|CJPOWERCAST|MediaSearch SQL: --sqlFromPaging select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type in (1,110)),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , (SELECT min(status.ACCESS_STATUS_NAME) FROM TMDDBA.TM_ACCESS_STATUS statusLnx, TM_CFG_ACCESS_STATUS status WHERE statusLnx.Media_Id = r.id and statusLnx.Status_Id = status.id) ACCESS_STATUS , (select min(acq.ext_ref) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) CONSIGNMENT_NUMBER , (select min(acq.alt_id1) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) TRANSFER_NUMBER , (select min(crs.series_number) from tm_series_data crs where crs.id = r.GROUP_SERIES_ID) CRS_SERIES , (select min(DISPOSAL_NAME) from TM_ACQ_DISPOSAL status, tm_disposal_records records where status.id = records.disposal_status_id and records.miid = r.id) DISPOSAL_STATUS , (select min(class.class_number) from TM_ACQ_DISPOSAL status, tm_disposal_records records, tm_disposal_classes class where status.id = records.disposal_status_id and records.miid = r.id and class.id = records.disposal_class_id) DISPOSAL_CLASS, (select min(names.concat_search_name) from tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names where r.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY, (select min(c.u_id_ext1) from tmddba.tm_mi_tpi_lnx lnx, tm_ctnrs c where c.u_id = lnx.tpiid and lnx.miid = r.id) U_ID_EXT1 , (select t.name from TM_CFG_MI_FMT_TYP t where t.id = r.mi_fmt_type) ITEM_FORMAT_TEXT, CASE WHEN BITAND(r.COMPIL, 2) = 2 THEN 'SUPPLIED' WHEN BITAND(r.COMPIL, 4) = 4 THEN 'MADE' WHEN BITAND(r.COMPIL, 134217728) = 134217728 THEN 'IMPORTED' ELSE '' END AS ORIGIN, CASE WHEN BITAND(r.COMPIL, 512) = 512 THEN 'Attached' WHEN BITAND(r.COMPIL, 1024) = 1024 THEN 'Un-Attached' ELSE '' END AS FLAGS, (select min(lang.full_name) from TM_PG_RL_LANG_LNX lnx, TM_LANG_DATA lang where lnx.tm_pg_rl_id = r.pgm_parent_id and lnx.lang_id = lang.id) AS PROD_LANGUAGE , (select min(ctx.ITFC_CODE) from tm_mis mis, tm_mi_tpi_lnx links, tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names where mis.id = r.id and links.miid = mis.id and mis.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY_NUMBER, (select min(status.description) from TM_CFG_PGM_STATUS status where r.status = status.id) PGM_STATUS_TEXT, (select min(ver.DUR) from TM_PG_RL ver where r.pgm_PARENT_ID = ver.id) AS VERSION_DUR , (select tmd_str_agg_pipe(cms.status_type_id ||',' ||cms.status_id) from tm_mi_cust_med_stat_lnx cms where cms.media_id=r.id) "CustomStatusesRaw", (select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = r.net_grp_id) CHANNEL_GROUP, (SELECT SUBSTR( trim( replace (replace ( LISTAGG(trim(tt.tags || ' ' || tt.notes), ' ') WITHIN GROUP (ORDER BY trim(tt.tags || ' ' || tt.notes)), chr (13), ''), chr (10), ' ')), 1, 150) z FROM tm_media_tagging tt WHERE link_guid = DFILE_LINK_GUID and rownum=1) TAGS_TEXT , GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select t.*, coalesce(t.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=t.pgm_parent_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.pgm_abs_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs2_id) ) primary_thumb_id2 from ( --sqlSubSelect select s.* from (select a.*, rownum rnum from (select --sqlFrom m.* from tmddba.tm_mis m --sqlWhere where media_type>0 and item_type>0 AND m.ID = :param_0 and m.mi_deleted=0 AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0) order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) s where rnum >= 1) t ) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl order by r.rnum t Verbose: 1220 : 12|05:34:49.6135|sagD0R|CJPOWERCAST|Alternative title fields query: select * from (select x.id,x.pgm_abs_id TitleId, x.pgm_parent_id VersionId from tm_mis x where id in (select /*+ cardinality(4) */ column_value id from table(:ids))) y,lateral (select dbms_lob.substr( o.text_data_plain, 1000, 1 ) Field_5799344 from tm_txt_obj o where (o.pgm_abs_id=y.TitleId or o.pgm_rl_id = y.VersionId) and o.type_id=:param_1 order by o.id desc fetch first 1 rows only)(+) t Information: 1220 : 12|05:34:49.8166|sagD0R|CJPOWERCAST| timing: 00:00:00.0238358 t Verbose: 1220 : 12|05:34:49.8166|sagD0R|CJPOWERCAST|imfx v3 API took 0.024s '/api/v3/search/Media?_dc=1693974911194' t Transfer: 1220 : 12|05:34:49.8166|sagD0R|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\snow-game-of-thrones-1200x600.jpg subfolder t Transfer: 1220 : 12|05:34:49.8166|sagD0R|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/snow-game-of-thrones-1200x600.jpg t Transfer: 1220 : 12|05:34:49.8166|sagD0R|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/snow-game-of-thrones-1200x600.jpg t Transfer: 1220 : 12|05:34:49.8166|sagD0R|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:34:49.8166|sagD0R|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:34:49.8166|sagD0R|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:34:53.2700|RSZObv|CJPOWERCAST|OAuth: /api/v3/media-details/299526?_dc=1693974914647 t Transfer: 1220 : 12|05:34:53.2700|RSZObv|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:34:53.2700|RSZObv|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:34:53.2700|RSZObv|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:34:53.2700|RSZObv|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|05:34:53.2700|RSZObv|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:34:53.2700|RSZObv|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:34:53.2700|RSZObv|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|05:34:53.2700|||TM_MIS. LoadSubtitles for ID: 299526 t Information: 1220 : 12|05:34:53.2700|||TM_MIS. LoadSubtitles for ID: 299526. SQL: 'select m.id, m.m_ctnr_id, m.m_ctnr_loc, m.modified_dt, m.tv_std, m.m_ctnr_fmt_id, d.sub_folder, nvl((select max(l.language) from tm_audio l where l.miid=m.id),aud_language_id) aud_language_id from tm_mis m left join tm_dfile d on (m.externally_owned_id=d.id) where m.mi_deleted=0 and m.item_type>0 and m.media_type=101 and m.PGM_PARENT_ID=299568' t Information: 1220 : 12|05:34:53.2700|||TM_MIS. LoadSubtitles for ID: 299526 found no subtitles. t Verbose: 1220 : 12|05:34:53.2700|RSZObv|CJPOWERCAST|imfx v3 API took 0.044s '/api/v3/media-details/299526?_dc=1693974914647' t Transfer: 1220 : 12|05:34:53.2700|RSZObv|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\P1040405.JPG subfolder t Transfer: 1220 : 12|05:34:53.2700|RSZObv|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/P1040405.JPG t Transfer: 1220 : 12|05:34:53.2700|RSZObv|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/P1040405.JPG t Transfer: 1220 : 12|05:34:53.2700|RSZObv|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:34:53.2700|RSZObv|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:34:53.2700|RSZObv|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:34:53.6792|7VWDbl|CJPOWERCAST|OAuth: /api/metadata/4000/299526?_dc=1693974915135 t Transfer: 1220 : 12|05:34:53.6792|7VWDbl|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:34:53.6792|7VWDbl|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:34:53.6792|7VWDbl|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:34:53.6792|7VWDbl|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 12|05:34:53.6792|7VWDbl|CJPOWERCAST|imfx v3 API took 0.003s '/api/metadata/4000/299526?_dc=1693974915135' t Transfer: 1220 : 12|05:34:58.5873|hV472S|CJPOWERCAST|OAuth: /api/v3/search/Media?_dc=1693974920150 t Transfer: 1220 : 12|05:34:58.5873|hV472S|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:34:58.5873|hV472S|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:34:58.5873|hV472S|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:34:58.5873|hV472S|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|05:34:58.5873|hV472S|CJPOWERCAST|V3Api.SearchMedia t Information: 1220 : 12|05:34:58.5873|hV472S|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|05:34:58.5873|hV472S|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:34:58.5873|hV472S|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:34:58.5873|hV472S|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|05:34:58.5873|hV472S|CJPOWERCAST|MediaSearch SQL: --sqlFromPaging select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type in (1,110)),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , (SELECT min(status.ACCESS_STATUS_NAME) FROM TMDDBA.TM_ACCESS_STATUS statusLnx, TM_CFG_ACCESS_STATUS status WHERE statusLnx.Media_Id = r.id and statusLnx.Status_Id = status.id) ACCESS_STATUS , (select min(acq.ext_ref) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) CONSIGNMENT_NUMBER , (select min(acq.alt_id1) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) TRANSFER_NUMBER , (select min(crs.series_number) from tm_series_data crs where crs.id = r.GROUP_SERIES_ID) CRS_SERIES , (select min(DISPOSAL_NAME) from TM_ACQ_DISPOSAL status, tm_disposal_records records where status.id = records.disposal_status_id and records.miid = r.id) DISPOSAL_STATUS , (select min(class.class_number) from TM_ACQ_DISPOSAL status, tm_disposal_records records, tm_disposal_classes class where status.id = records.disposal_status_id and records.miid = r.id and class.id = records.disposal_class_id) DISPOSAL_CLASS, (select min(names.concat_search_name) from tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names where r.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY, (select min(c.u_id_ext1) from tmddba.tm_mi_tpi_lnx lnx, tm_ctnrs c where c.u_id = lnx.tpiid and lnx.miid = r.id) U_ID_EXT1 , (select t.name from TM_CFG_MI_FMT_TYP t where t.id = r.mi_fmt_type) ITEM_FORMAT_TEXT, CASE WHEN BITAND(r.COMPIL, 2) = 2 THEN 'SUPPLIED' WHEN BITAND(r.COMPIL, 4) = 4 THEN 'MADE' WHEN BITAND(r.COMPIL, 134217728) = 134217728 THEN 'IMPORTED' ELSE '' END AS ORIGIN, CASE WHEN BITAND(r.COMPIL, 512) = 512 THEN 'Attached' WHEN BITAND(r.COMPIL, 1024) = 1024 THEN 'Un-Attached' ELSE '' END AS FLAGS, (select min(lang.full_name) from TM_PG_RL_LANG_LNX lnx, TM_LANG_DATA lang where lnx.tm_pg_rl_id = r.pgm_parent_id and lnx.lang_id = lang.id) AS PROD_LANGUAGE , (select min(ctx.ITFC_CODE) from tm_mis mis, tm_mi_tpi_lnx links, tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names where mis.id = r.id and links.miid = mis.id and mis.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY_NUMBER, (select min(status.description) from TM_CFG_PGM_STATUS status where r.status = status.id) PGM_STATUS_TEXT, (select min(ver.DUR) from TM_PG_RL ver where r.pgm_PARENT_ID = ver.id) AS VERSION_DUR , (select tmd_str_agg_pipe(cms.status_type_id ||',' ||cms.status_id) from tm_mi_cust_med_stat_lnx cms where cms.media_id=r.id) "CustomStatusesRaw", (select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = r.net_grp_id) CHANNEL_GROUP, (SELECT SUBSTR( trim( replace (replace ( LISTAGG(trim(tt.tags || ' ' || tt.notes), ' ') WITHIN GROUP (ORDER BY trim(tt.tags || ' ' || tt.notes)), chr (13), ''), chr (10), ' ')), 1, 150) z FROM tm_media_tagging tt WHERE link_guid = DFILE_LINK_GUID and rownum=1) TAGS_TEXT , GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select t.*, coalesce(t.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=t.pgm_parent_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.pgm_abs_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs2_id) ) primary_thumb_id2 from ( --sqlSubSelect select s.* from (select a.*, rownum rnum from (select --sqlFrom m.* from tmddba.tm_mis m --sqlWhere where media_type>0 and item_type>0 AND m.ID = :param_0 and m.mi_deleted=0 AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0) order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) s where rnum >= 1) t ) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl order by r.rnum t Verbose: 1220 : 12|05:34:58.5873|hV472S|CJPOWERCAST|Alternative title fields query: select * from (select x.id,x.pgm_abs_id TitleId, x.pgm_parent_id VersionId from tm_mis x where id in (select /*+ cardinality(4) */ column_value id from table(:ids))) y,lateral (select dbms_lob.substr( o.text_data_plain, 1000, 1 ) Field_5799344 from tm_txt_obj o where (o.pgm_abs_id=y.TitleId or o.pgm_rl_id = y.VersionId) and o.type_id=:param_1 order by o.id desc fetch first 1 rows only)(+) t Information: 1220 : 12|05:34:58.5873|hV472S|CJPOWERCAST| timing: 00:00:00.0272548 t Verbose: 1220 : 12|05:34:58.5873|hV472S|CJPOWERCAST|imfx v3 API took 0.027s '/api/v3/search/Media?_dc=1693974920150' t Transfer: 1220 : 12|05:34:58.5873|hV472S|CJPOWERCAST|GetUrl. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\P1040405.JPG subfolder t Transfer: 1220 : 12|05:34:58.5873|hV472S|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/P1040405.JPG t Transfer: 1220 : 12|05:34:58.5873|hV472S|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/ImageServer/P1040405.JPG t Transfer: 1220 : 12|05:34:58.5873|hV472S|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:34:58.5873|hV472S|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:34:58.5873|hV472S|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:35:04.7121|tNrsgy|CJPOWERCAST|OAuth: /api/v3/media-details/361603?_dc=1693974926276 t Transfer: 1220 : 12|05:35:04.7121|tNrsgy|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:35:04.7121|tNrsgy|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:35:04.7121|tNrsgy|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:35:04.7121|tNrsgy|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|05:35:04.7121|tNrsgy|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:35:04.7121|tNrsgy|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:35:04.7121|tNrsgy|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|05:35:04.7121|||TM_MIS. LoadSubtitles for ID: 361603 t Information: 1220 : 12|05:35:04.7121|||TM_MIS. LoadSubtitles for ID: 361603. SQL: 'select m.id, m.m_ctnr_id, m.m_ctnr_loc, m.modified_dt, m.tv_std, m.m_ctnr_fmt_id, d.sub_folder, nvl((select max(l.language) from tm_audio l where l.miid=m.id),aud_language_id) aud_language_id from tm_mis m left join tm_dfile d on (m.externally_owned_id=d.id) where m.mi_deleted=0 and m.item_type>0 and m.media_type=101 and m.miid1='MX361601'' t Information: 1220 : 12|05:35:04.9152|||TM_MIS. LoadSubtitles for ID: 361603 found no subtitles. t Verbose: 1220 : 12|05:35:04.9152|tNrsgy|CJPOWERCAST|imfx v3 API took 0.033s '/api/v3/media-details/361603?_dc=1693974926276' t Transfer: 1220 : 12|05:35:04.9152|tNrsgy|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\뚝딱이의 역습_가이드.jpg subfolder t Transfer: 1220 : 12|05:35:04.9152|tNrsgy|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/%EB%9A%9D%EB%94%B1%EC%9D%B4%EC%9D%98%20%EC%97%AD%EC%8A%B5_%EA%B0%80%EC%9D%B4%EB%93%9C.jpg t Transfer: 1220 : 12|05:35:04.9152|tNrsgy|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/%EB%9A%9D%EB%94%B1%EC%9D%B4%EC%9D%98%20%EC%97%AD%EC%8A%B5_%EA%B0%80%EC%9D%B4%EB%93%9C.jpg t Transfer: 1220 : 12|05:35:04.9152|tNrsgy|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:35:04.9152|tNrsgy|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:35:04.9152|tNrsgy|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:35:05.3215|a7YddC|CJPOWERCAST|OAuth: /api/metadata/4000/361603?_dc=1693974926749 t Transfer: 1220 : 12|05:35:05.3215|a7YddC|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:35:05.3215|a7YddC|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:35:05.3215|a7YddC|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:35:05.3215|a7YddC|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 12|05:35:05.3215|a7YddC|CJPOWERCAST|imfx v3 API took 0.002s '/api/metadata/4000/361603?_dc=1693974926749' t Transfer: 1220 : 12|05:35:15.2970|y0vBTI|CJPOWERCAST|OAuth: /api/v3/search/Media?_dc=1693974936889 t Transfer: 1220 : 12|05:35:15.2970|y0vBTI|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:35:15.2970|y0vBTI|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:35:15.2970|y0vBTI|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:35:15.2970|y0vBTI|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|05:35:15.2970|y0vBTI|CJPOWERCAST|V3Api.SearchMedia t Information: 1220 : 12|05:35:15.2970|y0vBTI|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|05:35:15.2981|y0vBTI|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:35:15.2981|y0vBTI|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:35:15.2981|y0vBTI|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|05:35:15.2981|y0vBTI|CJPOWERCAST|MediaSearch SQL: --sqlFromPaging select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type in (1,110)),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , (SELECT min(status.ACCESS_STATUS_NAME) FROM TMDDBA.TM_ACCESS_STATUS statusLnx, TM_CFG_ACCESS_STATUS status WHERE statusLnx.Media_Id = r.id and statusLnx.Status_Id = status.id) ACCESS_STATUS , (select min(acq.ext_ref) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) CONSIGNMENT_NUMBER , (select min(acq.alt_id1) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) TRANSFER_NUMBER , (select min(crs.series_number) from tm_series_data crs where crs.id = r.GROUP_SERIES_ID) CRS_SERIES , (select min(DISPOSAL_NAME) from TM_ACQ_DISPOSAL status, tm_disposal_records records where status.id = records.disposal_status_id and records.miid = r.id) DISPOSAL_STATUS , (select min(class.class_number) from TM_ACQ_DISPOSAL status, tm_disposal_records records, tm_disposal_classes class where status.id = records.disposal_status_id and records.miid = r.id and class.id = records.disposal_class_id) DISPOSAL_CLASS, (select min(names.concat_search_name) from tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names where r.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY, (select min(c.u_id_ext1) from tmddba.tm_mi_tpi_lnx lnx, tm_ctnrs c where c.u_id = lnx.tpiid and lnx.miid = r.id) U_ID_EXT1 , (select t.name from TM_CFG_MI_FMT_TYP t where t.id = r.mi_fmt_type) ITEM_FORMAT_TEXT, CASE WHEN BITAND(r.COMPIL, 2) = 2 THEN 'SUPPLIED' WHEN BITAND(r.COMPIL, 4) = 4 THEN 'MADE' WHEN BITAND(r.COMPIL, 134217728) = 134217728 THEN 'IMPORTED' ELSE '' END AS ORIGIN, CASE WHEN BITAND(r.COMPIL, 512) = 512 THEN 'Attached' WHEN BITAND(r.COMPIL, 1024) = 1024 THEN 'Un-Attached' ELSE '' END AS FLAGS, (select min(lang.full_name) from TM_PG_RL_LANG_LNX lnx, TM_LANG_DATA lang where lnx.tm_pg_rl_id = r.pgm_parent_id and lnx.lang_id = lang.id) AS PROD_LANGUAGE , (select min(ctx.ITFC_CODE) from tm_mis mis, tm_mi_tpi_lnx links, tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names where mis.id = r.id and links.miid = mis.id and mis.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY_NUMBER, (select min(status.description) from TM_CFG_PGM_STATUS status where r.status = status.id) PGM_STATUS_TEXT, (select min(ver.DUR) from TM_PG_RL ver where r.pgm_PARENT_ID = ver.id) AS VERSION_DUR , (select tmd_str_agg_pipe(cms.status_type_id ||',' ||cms.status_id) from tm_mi_cust_med_stat_lnx cms where cms.media_id=r.id) "CustomStatusesRaw", (select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = r.net_grp_id) CHANNEL_GROUP, (SELECT SUBSTR( trim( replace (replace ( LISTAGG(trim(tt.tags || ' ' || tt.notes), ' ') WITHIN GROUP (ORDER BY trim(tt.tags || ' ' || tt.notes)), chr (13), ''), chr (10), ' ')), 1, 150) z FROM tm_media_tagging tt WHERE link_guid = DFILE_LINK_GUID and rownum=1) TAGS_TEXT , GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select t.*, coalesce(t.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=t.pgm_parent_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.pgm_abs_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs2_id) ) primary_thumb_id2 from ( --sqlSubSelect select s.* from (select a.*, rownum rnum from (select --sqlFrom m.* from tmddba.tm_mis m --sqlWhere where media_type>0 and item_type>0 AND m.ID = :param_0 and m.mi_deleted=0 AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0) order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) s where rnum >= 1) t ) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl order by r.rnum t Verbose: 1220 : 12|05:35:15.5035|y0vBTI|CJPOWERCAST|Alternative title fields query: select * from (select x.id,x.pgm_abs_id TitleId, x.pgm_parent_id VersionId from tm_mis x where id in (select /*+ cardinality(4) */ column_value id from table(:ids))) y,lateral (select dbms_lob.substr( o.text_data_plain, 1000, 1 ) Field_5799344 from tm_txt_obj o where (o.pgm_abs_id=y.TitleId or o.pgm_rl_id = y.VersionId) and o.type_id=:param_1 order by o.id desc fetch first 1 rows only)(+) t Information: 1220 : 12|05:35:15.5035|y0vBTI|CJPOWERCAST| timing: 00:00:00.0211878 t Verbose: 1220 : 12|05:35:15.5035|y0vBTI|CJPOWERCAST|imfx v3 API took 0.021s '/api/v3/search/Media?_dc=1693974936889' t Transfer: 1220 : 12|05:35:15.5035|y0vBTI|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\뚝딱이의 역습_가이드.jpg subfolder t Transfer: 1220 : 12|05:35:15.5035|y0vBTI|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/%EB%9A%9D%EB%94%B1%EC%9D%B4%EC%9D%98%20%EC%97%AD%EC%8A%B5_%EA%B0%80%EC%9D%B4%EB%93%9C.jpg t Transfer: 1220 : 12|05:35:15.5035|y0vBTI|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/%EB%9A%9D%EB%94%B1%EC%9D%B4%EC%9D%98%20%EC%97%AD%EC%8A%B5_%EA%B0%80%EC%9D%B4%EB%93%9C.jpg t Transfer: 1220 : 12|05:35:15.5035|y0vBTI|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:35:15.5035|y0vBTI|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:35:15.5035|y0vBTI|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:35:18.9818|VyJRDv|CJPOWERCAST|OAuth: /api/v3/media-details/361603?_dc=1693974940504 t Transfer: 1220 : 12|05:35:18.9818|VyJRDv|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:35:18.9818|VyJRDv|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:35:18.9818|VyJRDv|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:35:18.9818|VyJRDv|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 12|05:35:18.9818|VyJRDv|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:35:18.9818|VyJRDv|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:35:18.9818|VyJRDv|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|05:35:18.9818|||TM_MIS. LoadSubtitles for ID: 361603 t Information: 1220 : 12|05:35:18.9818|||TM_MIS. LoadSubtitles for ID: 361603. SQL: 'select m.id, m.m_ctnr_id, m.m_ctnr_loc, m.modified_dt, m.tv_std, m.m_ctnr_fmt_id, d.sub_folder, nvl((select max(l.language) from tm_audio l where l.miid=m.id),aud_language_id) aud_language_id from tm_mis m left join tm_dfile d on (m.externally_owned_id=d.id) where m.mi_deleted=0 and m.item_type>0 and m.media_type=101 and m.miid1='MX361601'' t Information: 1220 : 12|05:35:18.9818|||TM_MIS. LoadSubtitles for ID: 361603 found no subtitles. t Verbose: 1220 : 12|05:35:18.9818|VyJRDv|CJPOWERCAST|imfx v3 API took 0.036s '/api/v3/media-details/361603?_dc=1693974940504' t Transfer: 1220 : 12|05:35:18.9818|VyJRDv|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\뚝딱이의 역습_가이드.jpg subfolder t Transfer: 1220 : 12|05:35:18.9818|VyJRDv|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/%EB%9A%9D%EB%94%B1%EC%9D%B4%EC%9D%98%20%EC%97%AD%EC%8A%B5_%EA%B0%80%EC%9D%B4%EB%93%9C.jpg t Transfer: 1220 : 12|05:35:18.9818|VyJRDv|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/%EB%9A%9D%EB%94%B1%EC%9D%B4%EC%9D%98%20%EC%97%AD%EC%8A%B5_%EA%B0%80%EC%9D%B4%EB%93%9C.jpg t Transfer: 1220 : 12|05:35:18.9818|VyJRDv|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:35:18.9818|VyJRDv|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:35:18.9818|VyJRDv|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:35:19.4037|JKB7qw|CJPOWERCAST|OAuth: /api/metadata/4000/361603?_dc=1693974940960 t Transfer: 1220 : 12|05:35:19.4037|JKB7qw|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:35:19.4037|JKB7qw|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:35:19.4037|JKB7qw|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:35:19.4037|JKB7qw|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 12|05:35:19.4037|JKB7qw|CJPOWERCAST|imfx v3 API took 0.002s '/api/metadata/4000/361603?_dc=1693974940960' t Transfer: 1220 : 12|05:35:24.0787|clYFLe|CJPOWERCAST|OAuth: /api/v3/search/Media?_dc=1693974945653 t Transfer: 1220 : 12|05:35:24.0787|clYFLe|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:35:24.0787|clYFLe|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:35:24.0787|clYFLe|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:35:24.0787|clYFLe|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 12|05:35:24.0787|clYFLe|CJPOWERCAST|V3Api.SearchMedia t Information: 1220 : 12|05:35:24.0787|clYFLe|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 12|05:35:24.0787|clYFLe|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:35:24.0787|clYFLe|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:35:24.0787|clYFLe|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 12|05:35:24.0787|clYFLe|CJPOWERCAST|MediaSearch SQL: --sqlFromPaging select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type in (1,110)),'') BARCODE, nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID , (SELECT min(status.ACCESS_STATUS_NAME) FROM TMDDBA.TM_ACCESS_STATUS statusLnx, TM_CFG_ACCESS_STATUS status WHERE statusLnx.Media_Id = r.id and statusLnx.Status_Id = status.id) ACCESS_STATUS , (select min(acq.ext_ref) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) CONSIGNMENT_NUMBER , (select min(acq.alt_id1) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) TRANSFER_NUMBER , (select min(crs.series_number) from tm_series_data crs where crs.id = r.GROUP_SERIES_ID) CRS_SERIES , (select min(DISPOSAL_NAME) from TM_ACQ_DISPOSAL status, tm_disposal_records records where status.id = records.disposal_status_id and records.miid = r.id) DISPOSAL_STATUS , (select min(class.class_number) from TM_ACQ_DISPOSAL status, tm_disposal_records records, tm_disposal_classes class where status.id = records.disposal_status_id and records.miid = r.id and class.id = records.disposal_class_id) DISPOSAL_CLASS, (select min(names.concat_search_name) from tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names where r.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY, (select min(c.u_id_ext1) from tmddba.tm_mi_tpi_lnx lnx, tm_ctnrs c where c.u_id = lnx.tpiid and lnx.miid = r.id) U_ID_EXT1 , (select t.name from TM_CFG_MI_FMT_TYP t where t.id = r.mi_fmt_type) ITEM_FORMAT_TEXT, CASE WHEN BITAND(r.COMPIL, 2) = 2 THEN 'SUPPLIED' WHEN BITAND(r.COMPIL, 4) = 4 THEN 'MADE' WHEN BITAND(r.COMPIL, 134217728) = 134217728 THEN 'IMPORTED' ELSE '' END AS ORIGIN, CASE WHEN BITAND(r.COMPIL, 512) = 512 THEN 'Attached' WHEN BITAND(r.COMPIL, 1024) = 1024 THEN 'Un-Attached' ELSE '' END AS FLAGS, (select min(lang.full_name) from TM_PG_RL_LANG_LNX lnx, TM_LANG_DATA lang where lnx.tm_pg_rl_id = r.pgm_parent_id and lnx.lang_id = lang.id) AS PROD_LANGUAGE , (select min(ctx.ITFC_CODE) from tm_mis mis, tm_mi_tpi_lnx links, tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names where mis.id = r.id and links.miid = mis.id and mis.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY_NUMBER, (select min(status.description) from TM_CFG_PGM_STATUS status where r.status = status.id) PGM_STATUS_TEXT, (select min(ver.DUR) from TM_PG_RL ver where r.pgm_PARENT_ID = ver.id) AS VERSION_DUR , (select tmd_str_agg_pipe(cms.status_type_id ||',' ||cms.status_id) from tm_mi_cust_med_stat_lnx cms where cms.media_id=r.id) "CustomStatusesRaw", (select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = r.net_grp_id) CHANNEL_GROUP, (SELECT SUBSTR( trim( replace (replace ( LISTAGG(trim(tt.tags || ' ' || tt.notes), ' ') WITHIN GROUP (ORDER BY trim(tt.tags || ' ' || tt.notes)), chr (13), ''), chr (10), ' ')), 1, 150) z FROM tm_media_tagging tt WHERE link_guid = DFILE_LINK_GUID and rownum=1) TAGS_TEXT , GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select t.*, coalesce(t.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=t.pgm_parent_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.pgm_abs_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs_id), (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs2_id) ) primary_thumb_id2 from ( --sqlSubSelect select s.* from (select a.*, rownum rnum from (select --sqlFrom m.* from tmddba.tm_mis m --sqlWhere where media_type>0 and item_type>0 AND m.ID = :param_0 and m.mi_deleted=0 AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0) order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) s where rnum >= 1) t ) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl order by r.rnum t Verbose: 1220 : 12|05:35:24.0787|clYFLe|CJPOWERCAST|Alternative title fields query: select * from (select x.id,x.pgm_abs_id TitleId, x.pgm_parent_id VersionId from tm_mis x where id in (select /*+ cardinality(4) */ column_value id from table(:ids))) y,lateral (select dbms_lob.substr( o.text_data_plain, 1000, 1 ) Field_5799344 from tm_txt_obj o where (o.pgm_abs_id=y.TitleId or o.pgm_rl_id = y.VersionId) and o.type_id=:param_1 order by o.id desc fetch first 1 rows only)(+) t Information: 1220 : 12|05:35:24.0787|clYFLe|CJPOWERCAST| timing: 00:00:00.0237296 t Verbose: 1220 : 12|05:35:24.0787|clYFLe|CJPOWERCAST|imfx v3 API took 0.024s '/api/v3/search/Media?_dc=1693974945653' t Transfer: 1220 : 12|05:35:24.0787|clYFLe|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\뚝딱이의 역습_가이드.jpg subfolder t Transfer: 1220 : 12|05:35:24.0787|clYFLe|CJPOWERCAST| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/%EB%9A%9D%EB%94%B1%EC%9D%B4%EC%9D%98%20%EC%97%AD%EC%8A%B5_%EA%B0%80%EC%9D%B4%EB%93%9C.jpg t Transfer: 1220 : 12|05:35:24.0787|clYFLe|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/%EB%9A%9D%EB%94%B1%EC%9D%B4%EC%9D%98%20%EC%97%AD%EC%8A%B5_%EA%B0%80%EC%9D%B4%EB%93%9C.jpg t Transfer: 1220 : 12|05:35:24.0787|clYFLe|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:35:24.0787|clYFLe|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:35:24.0787|clYFLe|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 12|05:36:33.0562|a_lanV|CJPOWERCAST|OAuth: /api/xml-schemas/?_dc=1693975014474 t Transfer: 1220 : 12|05:36:33.0562|a_lanV|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 12|05:36:33.0562|a_lanV|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 12|05:36:33.0562|a_lanV|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 12|05:36:33.0562|a_lanV|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 12|05:36:33.0562|a_lanV|CJPOWERCAST|imfx v3 API took 0.057s '/api/xml-schemas/?_dc=1693975014474'