t Information: 1220 : |Get Configuration Values: t Information: 1220 : 1|12:12:58.4280|| AdminPassEnc, default: , value: ffqjrn0leKv4Lj2YJHe2dw==. t Information: 1220 : 1|12:12:58.4291|| EncryptedPasswords, default: false, value: true. t Information: 1220 : 1|12:12:58.4301|| OraConnectionString, default: , value: Server=TECHM;User Id=imfx;Password=;Unicode=true;. t Information: 1220 : 1|12:12:58.4321|| SecondTimezone, default: , value: . t Information: 1220 : 1|12:12:58.4321|| UseActiveDirectoryAuth, default: false, value: false. t Information: 1220 : 1|12:12:58.4321|| ReportingServiceUrl, default: , value: http://localhost:92/ReportingService.svc. t Information: 1220 : 1|12:12:58.4330|| ReportsPath, default: , value: . t Information: 1220 : 1|12:12:58.4330|| ReportsURL, default: , value: . t Information: 1220 : 1|12:12:58.4330|| TapeServiceUrl, default: , value: . t Information: 1220 : 1|12:12:58.4330|| GatekeeperUrl, default: , value: . t Information: 1220 : 1|12:12:58.4330|| ValuationUrl, default: , value: . t Information: 1220 : 1|12:12:58.4330|| QueueManagerDelay, default: 30, value: 30. t Information: 1220 : 1|12:12:58.4330|| QueueManagerFullRefresh, default: 90, value: 90. t Information: 1220 : 1|12:12:58.4340|| AudioLoopDuration, default: 0, value: 150. t Information: 1220 : 1|12:12:58.4340|| AudioLoopsCount, default: 0, value: 0. t Information: 1220 : 1|12:12:58.4340|| PlayerFakeStep, default: 500, value: 500. t Information: 1220 : 1|12:12:58.4340|| PlayerForceRatio, default: 0, value: 1. t Information: 1220 : 1|12:12:58.4340|| CheckVersionsInProd, default: false, value: True. t Information: 1220 : 1|12:12:58.4340|| MaxResults, default: 3000, value: 10000. t Information: 1220 : 1|12:12:58.4340|| NetworkRestriction, default: false, value: True. t Information: 1220 : 1|12:12:58.4340|| TEReportID, default: 0, value: 0. t Information: 1220 : 1|12:12:58.4340|| ClosedCaptionsCache, default: , value: C:\inetpub\wwwroot\imfxcore\timedtextcache\. t Information: 1220 : 1|12:12:58.4340|| ClosedCaptionsStorage, default: , value: c:\Mediaflex\subs. t Information: 1220 : 1|12:12:58.4340|| TimeCodeFormat, default: , value: pal. t Information: 1220 : 1|12:12:58.4340|| RceMediaPath, default: , value: C:\edl\. t Information: 1220 : 1|12:12:58.4350|| RceMediaPath, default: , value: C:\edl\. t Information: 1220 : 1|12:12:58.4350|| RceCsmOutputPath, default: , value: C:\Inetpub\wwwroot\csm\. t Information: 1220 : 1|12:12:58.4350|| RceCsmUrl, default: , value: http://localhost/csm/. t Information: 1220 : 1|12:12:58.4350|| RceMediaSelection, default: , value: miLinkIdMatch. t Information: 1220 : 1|12:12:58.4350|| RequestBrowseJobPresetName, default: , value: . t Information: 1220 : 1|12:12:58.4350|| DontExtendDuration, default: false, value: False. t Information: 1220 : 1|12:12:58.4350|| V3ConfigUrl, default: , value: . t Information: 1220 : 1|12:12:58.4350|| ApiServer, default: , value: http://192.168.120.10:85. t Information: 1220 : 1|12:12:58.4350|| StopWords, default: , value: . t Information: 1220 : 1|12:12:58.4350|| MisrTxFormat, default: G, value: G. t Information: 1220 : 1|12:12:58.4350|| ThumbnailServer, default: , value: . t Information: 1220 : 1|12:12:58.4350|| LocationFilter, default: , value: . t Information: 1220 : 1|12:12:58.4350|| SvUtilServiceUrl, default: , value: . t Information: 1220 : 1|12:12:58.4360|| SolrConnection, default: , value: http://192.168.120.14:8983/solr. t Information: 1220 : 1|12:12:58.4360|| UseIndexServerSearch, default: false, value: True. t Information: 1220 : 1|12:12:58.4360|| SolrIndexVersion, default: 1, value: 6. t Information: 1220 : 1|12:12:58.4360|| SolrConnection, default: , value: http://192.168.120.14:8983/solr. t Information: 1220 : 1|12:12:58.4360|| FacetsGroups, default: , value: owners,season_id, series_id,version_key,item_type,media_type,media_format,episode_number. t Information: 1220 : 1|12:12:58.4360|| FacetsGroupsVersion, default: , value: owners,season_id, series_id,version_key,episode_number. t Information: 1220 : 1|12:12:58.4360|| FacetsGroupsChameleon, default: , value: season_id, series_id,genre,prod_year,version_key. t Information: 1220 : 1|12:12:58.4360|| PreviewPreset, default: , value: . t Information: 1220 : 1|12:12:58.4360|| DevMode, default: false, value: false. t Information: 1220 : 1|12:12:58.4360|| DisableSysMan, default: false, value: false. t Information: 1220 : 1|12:12:58.4371|| TimeCodeFormat, default: , value: pal. t Information: 1220 : 1|12:12:58.4371|| FileCatalystStorageDevice, default: , value: . t Information: 1220 : 1|12:12:58.4371|| UseResponsibilityTracking, default: true, value: True. t Information: 1220 : 1|12:12:58.4371|| SubtitleDeviceFilter, default: , value: . t Information: 1220 : 1|12:12:58.4371|| SystemMonitorNamedPipe, default: , value: . t Information: 1220 : 1|12:12:58.4371|| OracleMonitorEnable, default: false, value: False. t Information: 1220 : 1|12:12:58.4371|| ArcApiHost, default: , value: . t Information: 1220 : 1|12:12:58.4371|| RabbitMqUrl, default: , value: amqp://192.168.120.14:5672. t Information: 1220 : 1|12:12:58.4371|| SolrTimedTextSearch, default: false, value: false. t Information: 1220 : |GetStreamServers.. t Information: 1220 : 1|12:12:59.0371|| https://demo.tmd.tv/CBR Video/ |CBR Video| False t Information: 1220 : 1|12:12:59.0371|| https://demo.tmd.tv/CBR Images/ |CBR Images| False t Information: 1220 : 1|12:12:59.0380|| https://demo.tmd.tv/CBR Audio/ |CBR Audio| False t Information: 1220 : 1|12:12:59.0380|| https://demo.tmd.tv/Temp Upload/ |TEMP_UPLOAD| False t Information: 1220 : 1|12:12:59.0380|| http://localhost:82/images/ |IMAGES| False t Information: 1220 : 1|12:12:59.0380|| http://192.168.91.73/smoothcloud/ |SMOOTH_CLOUD| False t Information: 1220 : 1|12:12:59.0380|| http://192.168.91.73/cloudstore/ |CLOUD_STORE| False t Information: 1220 : 1|12:12:59.0380|| http://192.168.91.73/editsystemin/ |EDIT_SYSTEM_IN| False t Information: 1220 : 1|12:12:59.0380|| http://192.168.91.27:89/APPLEPROXY/ |APPLE_PROXY| False t Information: 1220 : 1|12:12:59.0380|| http://localhost:82/video/ |FILESTORE_VIDEO| False t Information: 1220 : 1|12:12:59.0390|| https://imfxv3tm.tmd.tv/streaming/ |Streaming| False t Information: 1220 : 1|12:12:59.0390|| https://imfxv3tm.tmd.tv/VideoServer/ |Video| False t Information: 1220 : 1|12:12:59.0390|| https://imfxv3tm.tmd.tv/AdobeIn/ |Adobe Premiere Pro In| False t Information: 1220 : 1|12:12:59.0390|| https://imfxv3tm.tmd.tv/AudioServer/ |Audio| False t Information: 1220 : 1|12:12:59.0390|| https://imfxv3tm.tmd.tv/ImageServer/ |Image| False t Information: 1220 : 1|12:12:59.0401|| https://imfxv3tm.tmd.tv/DocsServer/ |Docs| False t Information: 1220 : 1|12:12:59.0401|| https://imfxv3tm.tmd.tv/AmazonLabs/ |TEST HOUSE| False t Information: 1220 : 1|12:12:59.0401|| SolrConnectionUms, default: http://192.168.120.14:8983/solr, value: http://192.168.120.14:8983/solr. t Information: 1220 : 1|12:12:59.0401|| ApiLog, default: false, value: false. t Information: 1220 : 1|12:12:59.0411|| EmbeddedRceUrl, default: , value: . t Information: 1220 : 1|12:12:59.0411|| InstallMode, default: , value: . t Information: 1220 : 1|12:12:59.0411|| SamlRequestAddress, default: , value: . t Information: 1220 : 1|12:12:59.0411|| SamlTrustedIssuer, default: , value: . t Information: 1220 : 1|12:12:59.0411|| SamlLoginRedirect, default: , value: . t Information: 1220 : 1|12:12:59.0411|| NaturalLangSearch, default: false, value: True. t Information: 1220 : 1|12:12:59.0411|| OktaLoginField, default: , value: . t Information: 1220 : 1|12:12:59.0421|| AuthenticationTypes, default: , value: Native,PublicApiKey. t Information: 1220 : |OrabitWatcherBasic. Initialize. t Information: 1220 : |FillDictionaryCache. t Information: 1220 : |GetSupportedOperators t Information: 1220 : |CacheTechReports. t Information: 1220 : 1|12:13:03.7261||& Cache update. Server (global) filled with timestamp 12:11:03.7181066. types null t Information: 1220 : |InitializeFromDatabase. 'Server=TECHM;User Id=imfx;password=..;Unicode=true;' direct False, home , timeout 15 t Information: 1220 : |FillDictionaryCache. t Information: 1220 : 1|12:13:03.7731||& Cache update. Server (global) filled with timestamp 12:11:03.7701020. types FriendlyNames, DatabaseSearchFieldData t Information: 1220 : |OrabitWatcherBasic trying to connect.. t Information: 1220 : |========================================================================== t Information: 1220 : |IMFX CORE SERVER APPLICATION START. t Information: 1220 : 1|12:13:04.1220||DLL VERSION: 2.5.0.2276. t Information: 1220 : 17|12:13:04.1271|| UmsDev, default: False, value: False. t Information: 1220 : |OrabitWatcherBasic connected. t Information: 1220 : 11|12:13:04.2051||OrabitWatcherBasic queue created tmd.cfg.in.57f93229-784c-48ee-b4c0-381c1a386f9a t Information: 1220 : 1|12:13:04.2390|| ApiLog, default: false, value: false. t Transfer: 1220 : 11|12:13:07.6701||IsUserAuthenticated: /api/user-group-preferences?keys=logoImage&_dc=1573474387559 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : 12|12:13:07.6711||IsUserAuthenticated: /api/user-preferences?keys=color_schema&_dc=1573474387487 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : | OAuth authenticated t Verbose: 1220 : | uid claim is missing.. t Verbose: 1220 : | uid claim is missing.. t Verbose: 1220 : 12|12:13:07.6720||AutoLogin not possible identity type WindowsIdentity t Verbose: 1220 : 11|12:13:07.6720||AutoLogin not possible identity type WindowsIdentity t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Verbose: 1220 : | uid claim is missing.. t Transfer: 1220 : 11|12:13:08.5241||IsUserAuthenticated: /api/user-preferences?keys=ums.accordion_states&_dc=1573474388492 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Verbose: 1220 : | uid claim is missing.. t Verbose: 1220 : 11|12:13:08.5241||AutoLogin not possible identity type WindowsIdentity t Transfer: 1220 : 10|12:13:08.5250||IsUserAuthenticated: /api/user-preferences?keys=ums.default.route&_dc=1573474388491 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Verbose: 1220 : | uid claim is missing.. t Verbose: 1220 : 10|12:13:08.5250||AutoLogin not possible identity type WindowsIdentity t Transfer: 1220 : 10|12:13:08.5271||IsUserAuthenticated: /api/user-preferences?keys=ums.default.route&_dc=1573474388488 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Verbose: 1220 : | uid claim is missing.. t Verbose: 1220 : 10|12:13:08.5271||AutoLogin not possible identity type WindowsIdentity t Transfer: 1220 : 12|12:13:08.5311||IsUserAuthenticated: /api/user-preferences?keys=ums.splitter.dashboard.common&_dc=1573474388497 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Verbose: 1220 : | uid claim is missing.. t Verbose: 1220 : 12|12:13:08.5311||AutoLogin not possible identity type WindowsIdentity t Information: 1220 : |GetAppInfo t Information: 1220 : 25|12:13:08.5741|| db: TMDDEMO install mode: auth types: Native, PublicApiKey t Information: 1220 : |Oauth validating.. t Verbose: 1220 : |GrantResourceOwnerCredentials. t Verbose: 1220 : 17|12:13:11.6407||LoginUser. tmddba, login type OAuth, encrypt password True t Information: 1220 : 17|12:13:11.6447||TryLoginUser. tmddba, login type OAuth, check password True, check hash False, encrypt password True, load user data True t Information: 1220 : |InitialiseLogin t Information: 1220 : 17|12:13:11.8687|| oauth token 00000000-0000-0000-0000-000000000000 t Information: 1220 : |TryLoginUser. Logged in.. t Information: 1220 : |GetPasswordPolicy. WARNING: Policy not found for system Imediaflex. Validation disabled. t Verbose: 1220 : 17|12:13:11.9117||LoginUser. Adding history. User Id 1, result TMDDBA, host t Verbose: 1220 : 17|12:13:11.9197||GrantResourceOwnerCredentials. Try login finished. Logged: True t Transfer: 1220 : 17|12:13:12.0008||IsUserAuthenticated: /api/user-group-preferences?keys=logoImage&_dc=1573474391970 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 17|12:13:12.0008|| user TMDDBA. t Transfer: 1220 : 17|12:13:12.0008||api user: TMDDBA t Information: 1220 : |V3Api.GetUserSettings t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 17|12:13:12.0047|| user TMDDBA. t Transfer: 1220 : 17|12:13:12.0767||IsUserAuthenticated: /api/user-preferences?keys=personal_settings;ums.default_page;color_schema&_dc=1573474392045 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 17|12:13:12.0767|| user TMDDBA. t Transfer: 1220 : 17|12:13:12.0767||api user: TMDDBA t Information: 1220 : |GetUserDataByKeys: personal_settings;ums.default_page;color_schema t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 17|12:13:12.0787|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 0 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 17|12:13:12.1877|| user TMDDBA. t Transfer: 1220 : 10|12:13:12.2628||IsUserAuthenticated: /api/user-group-preferences?keys=logoImage&_dc=1573474392228 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 10|12:13:12.2628|| user TMDDBA. t Transfer: 1220 : 10|12:13:12.2628||api user: TMDDBA t Information: 1220 : |V3Api.GetUserSettings t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 10|12:13:12.2638|| user TMDDBA. t Transfer: 1220 : 11|12:13:12.2927||IsUserAuthenticated: /api/user-preferences?keys=ums.accordion_states&_dc=1573474392246 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 12|12:13:12.2937||IsUserAuthenticated: /api/user-preferences?keys=ums.default.route&_dc=1573474392239 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 12|12:13:12.2937|| user TMDDBA. t Transfer: 1220 : 12|12:13:12.2937||api user: TMDDBA t Information: 1220 : |GetUserDataByKeys: ums.default.route t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 12|12:13:12.2937|| user TMDDBA. t Transfer: 1220 : 11|12:13:12.2947|| user TMDDBA. t Transfer: 1220 : 11|12:13:12.2947||api user: TMDDBA t Information: 1220 : |GetUserDataByKeys: ums.accordion_states t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 11|12:13:12.2957|| user TMDDBA. t Transfer: 1220 : 10|12:13:12.2957||IsUserAuthenticated: /api/user-preferences?keys=ums.default.route&_dc=1573474392241 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 10|12:13:12.2968|| user TMDDBA. t Transfer: 1220 : 10|12:13:12.2968||api user: TMDDBA t Information: 1220 : |GetUserDataByKeys: ums.default.route t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 10|12:13:12.2968|| user TMDDBA. t Transfer: 1220 : 11|12:13:12.3497||IsUserAuthenticated: /api/user-preferences?keys=ums.splitter.dashboard.common&_dc=1573474392252 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 11|12:13:12.3507|| user TMDDBA. t Transfer: 1220 : 11|12:13:12.3527||api user: TMDDBA t Information: 1220 : |GetUserDataByKeys: ums.splitter.dashboard.common t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 11|12:13:12.3527|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 10|12:13:12.3917|| user TMDDBA. t Transfer: 1220 : 11|12:13:19.2574||IsUserAuthenticated: /api/user-preferences?keys=ums.splitter.dashboard.details&_dc=1573474399215 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 11|12:13:19.2574|| user TMDDBA. t Transfer: 1220 : 11|12:13:19.2574||api user: TMDDBA t Information: 1220 : |GetUserDataByKeys: ums.splitter.dashboard.details t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 11|12:13:19.2584|| user TMDDBA. t Transfer: 1220 : 12|12:13:19.7454||IsUserAuthenticated: /api/user-preferences?_dc=1573474399698 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 12|12:13:19.7454|| user TMDDBA. t Transfer: 1220 : 12|12:13:19.7454||api user: TMDDBA t Verbose: 1220 : |StoreUserDataByKeys.. t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 12|12:13:19.8234|| user TMDDBA. t Transfer: 1220 : 12|12:13:44.9993||IsUserAuthenticated: /api/user-preferences?_dc=1573474424973 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 12|12:13:45.0003|| user TMDDBA. t Transfer: 1220 : 12|12:13:45.0003||api user: TMDDBA t Verbose: 1220 : |StoreUserDataByKeys.. t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 12|12:13:45.0013|| user TMDDBA. t Transfer: 1220 : 10|12:13:55.3318||IsUserAuthenticated: /api/user-preferences?keys=ums.splitter.dashboard.details&_dc=1573474435295 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 10|12:13:55.3328|| user TMDDBA. t Transfer: 1220 : 10|12:13:55.3328||api user: TMDDBA t Information: 1220 : |GetUserDataByKeys: ums.splitter.dashboard.details t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 10|12:13:55.3328|| user TMDDBA. t Transfer: 1220 : 11|12:13:55.5658||IsUserAuthenticated: /api/settings/group/0?_dc=1573474435532 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 11|12:13:55.5668|| user TMDDBA. t Transfer: 1220 : 11|12:13:55.5668||api user: TMDDBA t Information: 1220 : |V3Api.GetSettingsGroup t Transfer: 1220 : 12|12:13:55.5708||IsUserAuthenticated: /api/settings/group/0?_dc=1573474435533 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 12|12:13:55.5708|| user TMDDBA. t Transfer: 1220 : 12|12:13:55.5718||api user: TMDDBA t Information: 1220 : |V3Api.GetSettingsGroup t Transfer: 1220 : 11|12:14:12.0902||IsUserAuthenticated: /api/ums/service/config/aecb886f-1a78-4e61-952a-25d3711d70df?_dc=1573474452053 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 11|12:14:12.0912|| user TMDDBA. t Transfer: 1220 : 11|12:14:12.0912||api user: TMDDBA t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 11|12:14:12.3702|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 23|12:15:12.3843|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 25|12:16:12.3699|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 26|12:17:12.3847|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 29|12:18:22.4603|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 30|12:18:43.9291|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 18|12:19:12.4164|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 36|12:20:12.3997|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 37|12:21:12.3840|| user TMDDBA. t Information: 1220 : |Oauth validating.. t Verbose: 1220 : |GrantResourceOwnerCredentials. t Verbose: 1220 : 46|12:22:09.8371||LoginUser. daniel, login type OAuth, encrypt password True t Information: 1220 : 46|12:22:09.8371||TryLoginUser. daniel, login type OAuth, check password True, check hash False, encrypt password True, load user data True t Information: 1220 : |InitialiseLogin t Information: 1220 : 46|12:22:09.8684|| oauth token 00000000-0000-0000-0000-000000000000 t Information: 1220 : |TryLoginUser. Logged in.. t Verbose: 1220 : 46|12:22:09.8684||LoginUser. Adding history. User Id 342, result DANIEL, host t Verbose: 1220 : 46|12:22:09.8840||GrantResourceOwnerCredentials. Try login finished. Logged: True t Transfer: 1220 : 36|12:22:09.9621||IsUserAuthenticated: /api/user-group-preferences?keys=defaultSearchColumnsMedia,defaultSearchColumnsVersion,defaultSearchColumnsSimple,defaultSearchMisrDetailsMediaColumns,versionCreationSettings,associate.advanced_search.setups,associate.wfrise.setups,logoImage&globals=isDebugMode,htmlplayerhotkeys,versionCreationSettings,associate.advanced_search.setups,associate.wfrise.setups&_dc=1573474929914 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 36|12:22:09.9621|| user DANIEL. t Transfer: 1220 : 36|12:22:09.9621||api user: DANIEL t Information: 1220 : |V3Api.GetUserSettings t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 36|12:22:09.9621|| user DANIEL. t Transfer: 1220 : 33|12:22:10.0559||IsUserAuthenticated: /api/user-preferences?keys=personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch&_dc=1573474930003 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 33|12:22:10.0559|| user DANIEL. t Transfer: 1220 : 33|12:22:10.0559||api user: DANIEL t Information: 1220 : |GetUserDataByKeys: personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 33|12:22:10.0559|| user DANIEL. t Transfer: 1220 : 42|12:22:11.3840||IsUserAuthenticated: /api/settings/user/consumer?_dc=1573474931337 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 42|12:22:11.3997|| user DANIEL. t Transfer: 1220 : 42|12:22:11.3997||api user: DANIEL t Information: 1220 : |V3Api.GetUserSettings t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 42|12:22:11.3997|| user DANIEL. t Transfer: 1220 : 46|12:22:11.6809||IsUserAuthenticated: /api/user-preferences?keys=consumer.recent.data&_dc=1573474931636 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 46|12:22:11.6809|| user DANIEL. t Transfer: 1220 : 46|12:22:11.6809||api user: DANIEL t Information: 1220 : |GetUserDataByKeys: consumer.recent.data t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 46|12:22:11.6809|| user DANIEL. t Transfer: 1220 : 40|12:22:11.9309||IsUserAuthenticated: /api/settings/user/startSearch?_dc=1573474931905 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 40|12:22:11.9309|| user DANIEL. t Transfer: 1220 : 40|12:22:11.9309||api user: DANIEL t Information: 1220 : |V3Api.GetUserSettings t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 40|12:22:11.9309|| user DANIEL. t Transfer: 1220 : 45|12:22:11.9309||IsUserAuthenticated: /api/settings/user/defaultSearch?_dc=1573474931902 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 45|12:22:11.9309|| user DANIEL. t Transfer: 1220 : 45|12:22:11.9309||api user: DANIEL t Information: 1220 : |V3Api.GetUserSettings t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 45|12:22:11.9309|| user DANIEL. t Transfer: 1220 : 38|12:22:12.0246||IsUserAuthenticated: /api/user-preferences?keys=consumer.recent.data&_dc=1573474932008 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 38|12:22:12.0246|| user DANIEL. t Transfer: 1220 : 38|12:22:12.0246||api user: DANIEL t Information: 1220 : |GetUserDataByKeys: consumer.recent.data t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 38|12:22:12.0246|| user DANIEL. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 46|12:22:12.4152|| user TMDDBA. t Transfer: 1220 : 38|12:22:12.5871||IsUserAuthenticated: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1573474932559 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 38|12:22:12.5871|| user DANIEL. t Transfer: 1220 : 38|12:22:12.5871||api user: DANIEL t Information: 1220 : |V3Api.GetUserSettings t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 38|12:22:12.5871|| user DANIEL. t Transfer: 1220 : 35|12:22:12.6496||IsUserAuthenticated: /api/mediavideo/278628?_dc=1573474932628 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 35|12:22:12.6496|| user DANIEL. t Transfer: 1220 : 35|12:22:12.6496||api user: DANIEL t Transfer: 1220 : 38|12:22:12.8996||IsUserAuthenticated: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1573474932827 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 38|12:22:12.8996|| user DANIEL. t Transfer: 1220 : 38|12:22:12.8996||api user: DANIEL t Information: 1220 : |V3Api.GetUserSettings t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 38|12:22:12.8996|| user DANIEL. t Transfer: 1220 : 40|12:22:12.8996||IsUserAuthenticated: /api/mediavideo/278663?_dc=1573474932847 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 40|12:22:12.8996|| user DANIEL. t Transfer: 1220 : 40|12:22:12.8996||api user: DANIEL t Transfer: 1220 : 38|12:22:16.1496||IsUserAuthenticated: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1573474936119 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 38|12:22:16.1496|| user DANIEL. t Transfer: 1220 : 38|12:22:16.1496||api user: DANIEL t Information: 1220 : |V3Api.GetUserSettings t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 38|12:22:16.1496|| user DANIEL. t Transfer: 1220 : 35|12:22:16.1965||IsUserAuthenticated: /api/mediavideo/278661?_dc=1573474936160 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 35|12:22:16.1965|| user DANIEL. t Transfer: 1220 : 35|12:22:16.1965||api user: DANIEL t Transfer: 1220 : 40|12:22:25.5715||IsUserAuthenticated: /api/lookups/SearchSupportedOperators?_dc=1573474945545 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 40|12:22:25.5715|| user DANIEL. t Transfer: 1220 : 35|12:22:25.5715||IsUserAuthenticated: /api/view/searchinfo/TitleSearch?_dc=1573474945542 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 35|12:22:25.5715|| user DANIEL. t Transfer: 1220 : 35|12:22:25.5715||api user: DANIEL t Transfer: 1220 : 40|12:22:25.5715||api user: DANIEL t Information: 1220 : |GetAdvSearchColumns. search type TitleSearch grid . t Transfer: 1220 : 46|12:22:25.5715||IsUserAuthenticated: /api/user-preferences?keys=adv.recent.searches.titles&_dc=1573474945554 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 46|12:22:25.5715|| user DANIEL. t Transfer: 1220 : 46|12:22:25.5715||api user: DANIEL t Information: 1220 : |GetUserDataByKeys: adv.recent.searches.titles t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 46|12:22:25.5715|| user DANIEL. t Transfer: 1220 : 40|12:22:25.6496||IsUserAuthenticated: /api/view/info/TitleTree?lang=en-GB&_dc=1573474945620 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 40|12:22:25.6496|| user DANIEL. t Transfer: 1220 : 40|12:22:25.6496||api user: DANIEL t Information: 1220 : |GetGridViewBuilder. builder type TitleTree. t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 40|12:22:25.6496|| user DANIEL. t Information: 1220 : |UserGridView. LoadView. ID 1301, Name Default. t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 40|12:22:25.6496|| user DANIEL. t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 40|12:22:25.6653|| user DANIEL. t Transfer: 1220 : 42|12:22:25.7121||IsUserAuthenticated: /api/view/searches/TitleSearch?_dc=1573474945687 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 42|12:22:25.7121|| user DANIEL. t Transfer: 1220 : 42|12:22:25.7121||api user: DANIEL t Information: 1220 : |GetSavedSearchNames. search type TitleSearch. t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 42|12:22:25.7278|| user DANIEL. t Transfer: 1220 : 7|12:22:25.7434||IsUserAuthenticated: /api/view/info/VersionGrid?lang=en-GB&_dc=1573474945719 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 7|12:22:25.7434|| user DANIEL. t Transfer: 1220 : 7|12:22:25.7434||api user: DANIEL t Information: 1220 : |GetGridViewBuilder. builder type VersionGrid. t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 7|12:22:25.7590|| user DANIEL. t Information: 1220 : |UserGridView. LoadView. ID 899, Name Default. t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 7|12:22:25.7590|| user DANIEL. t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 7|12:22:25.7747|| user DANIEL. t Transfer: 1220 : 36|12:22:25.8996||IsUserAuthenticated: /api/view/info/MediaGrid?lang=en-GB&_dc=1573474945872 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 36|12:22:25.8996|| user DANIEL. t Transfer: 1220 : 36|12:22:25.8996||api user: DANIEL t Information: 1220 : |GetGridViewBuilder. builder type MediaGrid. t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 36|12:22:25.8996|| user DANIEL. t Information: 1220 : |UserGridView. LoadView. ID 760, Name Default. t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 36|12:22:25.8996|| user DANIEL. t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 36|12:22:25.8996|| user DANIEL. t Transfer: 1220 : 46|12:22:27.2902||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1573474947267 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 46|12:22:27.2902|| user DANIEL. t Transfer: 1220 : 46|12:22:27.2902||api user: DANIEL t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 46|12:22:27.3059|| user DANIEL. t Transfer: 1220 : 38|12:22:27.3840||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1573474947305 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 38|12:22:27.3840|| user DANIEL. t Transfer: 1220 : 38|12:22:27.3840||api user: DANIEL t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 38|12:22:27.3840|| user DANIEL. t Transfer: 1220 : 33|12:22:29.6496||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1573474949626 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 33|12:22:29.6496|| user DANIEL. t Transfer: 1220 : 33|12:22:29.6496||api user: DANIEL t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 33|12:22:29.6496|| user DANIEL. t Transfer: 1220 : 38|12:22:29.8215||IsUserAuthenticated: /api/search/title?_dc=1573474949806 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 38|12:22:29.8215|| user DANIEL. t Transfer: 1220 : 38|12:22:29.8215||api user: DANIEL t Information: 1220 : |V3Api.SearchTitles t Information: 1220 : |V3Api.SearchGeneric t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 38|12:22:29.8997|| user DANIEL. t Information: 1220 : 38|12:22:29.8997||SearchTitle SQL: with v as ( SELECT abs.* ,decode(ITEM_TYPE, 1010,SER_ABS_ID, 1020,CASE WHEN SER_ABS2_ID > 0 THEN SER_ABS2_ID ELSE SER_ABS_ID END ) xparent_id FROM TMDDBA.TM_PG_ABS abs WHERE abs.id in ( select a.id FROM TMDDBA.TM_PG_ABS a where ABS_DELETED = 0 AND (INSTR(OWNERS,'|ATP|')>0 OR INSTR(OWNERS,'|NAA|')>0 OR INSTR(OWNERS,'|SFP1|')>0 OR INSTR(OWNERS,'|SFP2|')>0 OR INSTR(OWNERS,'|TECHM|')>0 OR INSTR(OWNERS,'|TMD|')>0 OR INSTR(OWNERS,'|YLE TV1|')>0 ) AND (CONTAINS(CTX_TEXT_COL,'Inspector Gadget') > 0 OR CONTAINS(CTX_IDS_COL,'Inspector Gadget') > 0 ) AND ROWNUM < 25000 ) ) ,v_missing_parent_ids as ( select xparent_id from v minus select id from v ) ,v_missing_parents as ( SELECT distinct a.* ,decode(ITEM_TYPE, 1010,SER_ABS_ID, 1020,CASE WHEN SER_ABS2_ID > 0 THEN SER_ABS2_ID ELSE SER_ABS_ID END ) xparent_id FROM TMDDBA.TM_PG_ABS a START WITH ID IN (select xparent_id from v_missing_parent_ids) CONNECT BY CASE PRIOR ITEM_TYPE WHEN 1010 THEN PRIOR SER_ABS_ID WHEN 1020 THEN CASE WHEN NVL(PRIOR SER_ABS2_ID, 0) > 0 THEN PRIOR SER_ABS2_ID ELSE PRIOR SER_ABS_ID END END = ID ) ,v_all as ( select x.*, count(*) over() RowCount from ( select * from v_missing_parents union all select * from v ) x ) ,v_top as ( select id from (select id, row_number()over(order by upper(ser_title),upper(title),ser_num,ser_ep_num, SER_EP_SQ_NUM ) rnk -- sort roots from v_all where xparent_id is null) where rnk between (:page_number-1)*50+1 and :page_number*50 ) ,v_tree as ( select level lvl, a.* from v_all a start with id in (select id from v_top) connect by xparent_id = prior ID order siblings by upper(ser_title),ser_num,ser_ep_num, SER_EP_SQ_NUM,upper(title) -- sort children ) select * from v_tree --where rnk <= 50 t Transfer: 1220 : 40|12:22:30.3840||IsUserAuthenticated: /api/int/title/297799/versions?_dc=1573474950352 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 40|12:22:30.3840|| user DANIEL. t Transfer: 1220 : 40|12:22:30.3840||api user: DANIEL t Information: 1220 : |V3Api.GetVersionsByTitleIdAdv t Information: 1220 : |V3Api.SearchGeneric t Transfer: 1220 : 42|12:22:30.3840||IsUserAuthenticated: /api/user-preferences?_dc=1573474950363 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 42|12:22:30.3840|| user DANIEL. t Transfer: 1220 : 42|12:22:30.3840||api user: DANIEL t Verbose: 1220 : |StoreUserDataByKeys.. t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 42|12:22:30.3840|| user DANIEL. t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 40|12:22:30.3997|| user DANIEL. t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 40|12:22:30.3997|| user DANIEL. t Information: 1220 : 40|12:22:30.4152||SearchVersion SQL: select * from (select a.*, rownum rnum from ( select m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE from tmddba.tm_pg_rl m left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id where item_type>0 and rl_deleted=0 and m.PGM_ABS_ID=297799 AND (INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|NAA|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|TECHM|')>0 OR INSTR(m.OWNERS,'|TMD|')>0 OR INSTR(m.OWNERS,'|YLE TV1|')>0) order by m.title, m.id ) a where rownum <= 9999) r where rnum >=1 order by rnum t Information: 1220 : |Running version search. User: 342 Simple Search: Running Oracle search for COUNT Oracle count completed in: 22ms. Returned lines: 0 Running Oracle search. Oracle version search timing: 51ms. SQL run: select * from (select a.*, rownum rnum from ( select m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE from tmddba.tm_pg_rl m left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id where item_type>0 and rl_deleted=0 and m.PGM_ABS_ID=297799 AND (INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|NAA|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|TECHM|')>0 OR INSTR(m.OWNERS,'|TMD|')>0 OR INSTR(m.OWNERS,'|YLE TV1|')>0) order by m.title, m.id ) a where rownum <= 9999) r where rnum >=1 order by rnum t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 46|12:23:12.6187|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 38|12:24:12.3843|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 12|12:25:12.4624|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 17|12:26:12.3843|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 28|12:27:12.4000|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 32|12:28:12.3730|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 31|12:29:12.4006|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 32|12:30:12.3849|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 57|12:31:12.4006|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 52|12:32:12.4006|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 47|12:33:12.4176|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 27|12:34:12.4020|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 51|12:35:12.4020|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 26|12:36:12.3708|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 42|12:37:12.4333|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 42|12:38:12.4021|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 42|12:39:12.4021|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 33|12:40:12.4333|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 49|12:41:12.4177|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 53|12:42:12.4021|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 55|12:43:12.4177|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 48|12:44:12.4644|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 55|12:45:12.3860|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 38|12:46:12.3616|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 19|12:47:12.6272|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 17|12:48:12.3772|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 17|12:49:12.3616|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 39|12:50:12.3616|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 25|12:51:12.3578|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 53|12:52:12.3891|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 6|12:53:12.3735|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 53|12:54:12.3578|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 47|12:55:12.3734|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 62|12:56:12.4672|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 18|12:57:12.4360|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 64|12:58:12.4828|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 54|12:59:12.4671|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 51|13:00:12.4478|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 30|13:01:12.4009|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 52|13:02:12.5022|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 59|13:03:12.3772|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 39|13:04:12.3772|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 52|13:05:12.3928|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 11|13:06:12.3928|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 6|13:07:12.3616|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 56|13:08:12.3928|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 43|13:09:12.4241|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 43|13:10:12.4154|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 6|13:11:12.4466|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 47|13:12:12.3685|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 25|13:13:12.3684|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 52|13:14:12.3687|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 63|13:15:12.3843|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 17|13:16:12.4476|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 39|13:17:12.3696|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 39|13:18:12.3695|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 54|13:19:12.5570|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 19|13:20:12.5258|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 59|13:21:12.4164|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 30|13:22:12.4320|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 54|13:23:12.4164|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 12|13:24:12.4008|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 59|13:25:12.4164|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 53|13:26:12.3879|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 53|13:27:12.3723|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 37|13:28:12.6780|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 6|13:29:12.4280|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 45|13:30:12.3896|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 33|13:31:12.4365|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 59|13:32:12.4053|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 19|13:33:12.4053|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 8|13:34:22.4365|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 11|13:35:12.3896|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 59|13:36:12.3584|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 59|13:37:12.3740|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 59|13:38:12.3740|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 48|13:39:12.3584|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 49|13:40:12.3740|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 59|13:41:12.3740|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 31|13:42:12.3584|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 6|13:43:12.3740|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 53|13:44:12.4053|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 23|13:45:12.3740|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 6|13:46:12.3740|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 37|13:47:12.4862|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 10|13:48:12.4238|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 54|13:49:12.4238|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 12|13:50:12.4238|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 37|13:51:12.4550|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 37|13:52:12.4238|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 12|13:53:12.4082|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 38|13:54:12.3602|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 52|13:55:12.4227|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 51|13:56:12.4071|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 52|13:57:12.4071|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 53|13:58:12.4227|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 49|13:59:16.8755|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 37|14:00:12.4223|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 12|14:01:12.4223|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 11|14:02:12.4066|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 8|14:03:12.4066|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 42|14:04:12.4066|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 42|14:05:12.4222|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 42|14:06:12.4222|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 42|14:07:12.4066|| user TMDDBA. t Transfer: 1220 : 19|14:07:53.4222||IsUserAuthenticated: /api/user-preferences?keys=adv.recent.searches.consumer&_dc=1573481273133 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 19|14:07:53.4222|| user DANIEL. t Transfer: 1220 : 19|14:07:53.4222||api user: DANIEL t Information: 1220 : |GetUserDataByKeys: adv.recent.searches.consumer t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 19|14:07:53.4222|| user DANIEL. t Transfer: 1220 : 42|14:08:03.8285||IsUserAuthenticated: /api/view/searchinfo/TitleSearch?_dc=1573481283780 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 42|14:08:03.8285|| user DANIEL. t Transfer: 1220 : 42|14:08:03.8285||api user: DANIEL t Information: 1220 : |GetAdvSearchColumns. search type TitleSearch grid . t Transfer: 1220 : 23|14:08:03.8285||IsUserAuthenticated: /api/user-preferences?keys=adv.recent.searches.titles&_dc=1573481283790 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 23|14:08:03.8285|| user DANIEL. t Transfer: 1220 : 23|14:08:03.8285||api user: DANIEL t Information: 1220 : |GetUserDataByKeys: adv.recent.searches.titles t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 23|14:08:03.8285|| user DANIEL. t Transfer: 1220 : 26|14:08:03.8753||IsUserAuthenticated: /api/view/info/TitleTree?lang=en-GB&_dc=1573481283839 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 26|14:08:03.8753|| user DANIEL. t Transfer: 1220 : 26|14:08:03.8753||api user: DANIEL t Information: 1220 : |GetGridViewBuilder. builder type TitleTree. t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 26|14:08:03.8753|| user DANIEL. t Information: 1220 : |UserGridView. LoadView. ID 1301, Name Default. t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 26|14:08:03.8753|| user DANIEL. t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 26|14:08:03.8910|| user DANIEL. t Transfer: 1220 : 19|14:08:03.9222||IsUserAuthenticated: /api/view/searches/TitleSearch?_dc=1573481283882 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 19|14:08:03.9222|| user DANIEL. t Transfer: 1220 : 19|14:08:03.9222||api user: DANIEL t Information: 1220 : |GetSavedSearchNames. search type TitleSearch. t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 19|14:08:03.9222|| user DANIEL. t Transfer: 1220 : 50|14:08:03.9378||IsUserAuthenticated: /api/view/info/VersionGrid?lang=en-GB&_dc=1573481283913 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 50|14:08:03.9378|| user DANIEL. t Transfer: 1220 : 50|14:08:03.9378||api user: DANIEL t Information: 1220 : |GetGridViewBuilder. builder type VersionGrid. t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 50|14:08:03.9378|| user DANIEL. t Information: 1220 : |UserGridView. LoadView. ID 899, Name Default. t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 50|14:08:03.9378|| user DANIEL. t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 50|14:08:03.9691|| user DANIEL. t Transfer: 1220 : 42|14:08:04.0628||IsUserAuthenticated: /api/view/info/MediaGrid?lang=en-GB&_dc=1573481284028 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 42|14:08:04.0628|| user DANIEL. t Transfer: 1220 : 42|14:08:04.0628||api user: DANIEL t Information: 1220 : |GetGridViewBuilder. builder type MediaGrid. t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 42|14:08:04.0628|| user DANIEL. t Information: 1220 : |UserGridView. LoadView. ID 760, Name Default. t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 42|14:08:04.0628|| user DANIEL. t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 42|14:08:04.0785|| user DANIEL. t Transfer: 1220 : 50|14:08:10.9066||IsUserAuthenticated: /api/search/title?_dc=1573481290864 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 50|14:08:10.9066|| user DANIEL. t Transfer: 1220 : 50|14:08:10.9066||api user: DANIEL t Information: 1220 : |V3Api.SearchTitles t Information: 1220 : |V3Api.SearchGeneric t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 50|14:08:10.9066|| user DANIEL. t Information: 1220 : 50|14:08:10.9066||SearchTitle SQL: with v as ( SELECT abs.* ,decode(ITEM_TYPE, 1010,SER_ABS_ID, 1020,CASE WHEN SER_ABS2_ID > 0 THEN SER_ABS2_ID ELSE SER_ABS_ID END ) xparent_id FROM TMDDBA.TM_PG_ABS abs WHERE abs.id in ( select a.id FROM TMDDBA.TM_PG_ABS a where ABS_DELETED = 0 AND (INSTR(OWNERS,'|ATP|')>0 OR INSTR(OWNERS,'|NAA|')>0 OR INSTR(OWNERS,'|SFP1|')>0 OR INSTR(OWNERS,'|SFP2|')>0 OR INSTR(OWNERS,'|TECHM|')>0 OR INSTR(OWNERS,'|TMD|')>0 OR INSTR(OWNERS,'|YLE TV1|')>0 ) AND (CONTAINS(CTX_TEXT_COL,'mr') > 0 OR CONTAINS(CTX_IDS_COL,'mr') > 0 ) AND ROWNUM < 25000 ) ) ,v_missing_parent_ids as ( select xparent_id from v minus select id from v ) ,v_missing_parents as ( SELECT distinct a.* ,decode(ITEM_TYPE, 1010,SER_ABS_ID, 1020,CASE WHEN SER_ABS2_ID > 0 THEN SER_ABS2_ID ELSE SER_ABS_ID END ) xparent_id FROM TMDDBA.TM_PG_ABS a START WITH ID IN (select xparent_id from v_missing_parent_ids) CONNECT BY CASE PRIOR ITEM_TYPE WHEN 1010 THEN PRIOR SER_ABS_ID WHEN 1020 THEN CASE WHEN NVL(PRIOR SER_ABS2_ID, 0) > 0 THEN PRIOR SER_ABS2_ID ELSE PRIOR SER_ABS_ID END END = ID ) ,v_all as ( select x.*, count(*) over() RowCount from ( select * from v_missing_parents union all select * from v ) x ) ,v_top as ( select id from (select id, row_number()over(order by upper(ser_title),upper(title),ser_num,ser_ep_num, SER_EP_SQ_NUM ) rnk -- sort roots from v_all where xparent_id is null) where rnk between (:page_number-1)*50+1 and :page_number*50 ) ,v_tree as ( select level lvl, a.* from v_all a start with id in (select id from v_top) connect by xparent_id = prior ID order siblings by upper(ser_title),ser_num,ser_ep_num, SER_EP_SQ_NUM,upper(title) -- sort children ) select * from v_tree --where rnk <= 50 t Transfer: 1220 : 42|14:08:11.2191||IsUserAuthenticated: /api/int/title/293961/versions?_dc=1573481291190 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 42|14:08:11.2191|| user DANIEL. t Transfer: 1220 : 42|14:08:11.2191||api user: DANIEL t Information: 1220 : |V3Api.GetVersionsByTitleIdAdv t Information: 1220 : |V3Api.SearchGeneric t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 42|14:08:11.2191|| user DANIEL. t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 42|14:08:11.2191|| user DANIEL. t Transfer: 1220 : 19|14:08:11.2347||IsUserAuthenticated: /api/user-preferences?_dc=1573481291198 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 19|14:08:11.2347|| user DANIEL. t Transfer: 1220 : 19|14:08:11.2347||api user: DANIEL t Verbose: 1220 : |StoreUserDataByKeys.. t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 19|14:08:11.2347|| user DANIEL. t Information: 1220 : 42|14:08:11.2347||SearchVersion SQL: select * from (select a.*, rownum rnum from ( select m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE from tmddba.tm_pg_rl m left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id where item_type>0 and rl_deleted=0 and m.PGM_ABS_ID=293961 AND (INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|NAA|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|TECHM|')>0 OR INSTR(m.OWNERS,'|TMD|')>0 OR INSTR(m.OWNERS,'|YLE TV1|')>0) order by m.title, m.id ) a where rownum <= 9999) r where rnum >=1 order by rnum t Information: 1220 : |Running version search. User: 342 Simple Search: Running Oracle search for COUNT Oracle count completed in: 7ms. Returned lines: 0 Running Oracle search. Oracle version search timing: 112ms. SQL run: select * from (select a.*, rownum rnum from ( select m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE from tmddba.tm_pg_rl m left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id where item_type>0 and rl_deleted=0 and m.PGM_ABS_ID=293961 AND (INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|NAA|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|TECHM|')>0 OR INSTR(m.OWNERS,'|TMD|')>0 OR INSTR(m.OWNERS,'|YLE TV1|')>0) order by m.title, m.id ) a where rownum <= 9999) r where rnum >=1 order by rnum t Transfer: 1220 : 50|14:08:13.0472||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1573481293025 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 50|14:08:13.0472|| user DANIEL. t Transfer: 1220 : 50|14:08:13.0472||api user: DANIEL t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 50|14:08:13.0472|| user DANIEL. t Transfer: 1220 : 42|14:08:13.5628||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1573481293536 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 42|14:08:13.5628|| user DANIEL. t Transfer: 1220 : 42|14:08:13.5628||api user: DANIEL t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 42|14:08:13.5628|| user DANIEL. t Transfer: 1220 : 42|14:08:13.6566||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1573481293632 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 42|14:08:13.6566|| user DANIEL. t Transfer: 1220 : 42|14:08:13.6566||api user: DANIEL t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 42|14:08:13.6566|| user DANIEL. t Transfer: 1220 : 50|14:08:13.8910||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1573481293855 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 50|14:08:13.8910|| user DANIEL. t Transfer: 1220 : 50|14:08:13.8910||api user: DANIEL t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 50|14:08:13.8910|| user DANIEL. t Transfer: 1220 : 19|14:08:16.7659||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1573481296722 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 19|14:08:16.7659|| user DANIEL. t Transfer: 1220 : 19|14:08:16.7659||api user: DANIEL t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 19|14:08:16.7659|| user DANIEL. t Transfer: 1220 : 50|14:08:16.8284||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1573481296799 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 50|14:08:16.8284|| user DANIEL. t Transfer: 1220 : 50|14:08:16.8284||api user: DANIEL t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 50|14:08:16.8284|| user DANIEL. t Transfer: 1220 : 51|14:08:17.5628||IsUserAuthenticated: /api/search/title?_dc=1573481297521 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 51|14:08:17.5628|| user DANIEL. t Transfer: 1220 : 51|14:08:17.5628||api user: DANIEL t Information: 1220 : |V3Api.SearchTitles t Information: 1220 : |V3Api.SearchGeneric t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 51|14:08:17.5628|| user DANIEL. t Information: 1220 : 51|14:08:17.5628||SearchTitle SQL: with v as ( SELECT abs.* ,decode(ITEM_TYPE, 1010,SER_ABS_ID, 1020,CASE WHEN SER_ABS2_ID > 0 THEN SER_ABS2_ID ELSE SER_ABS_ID END ) xparent_id FROM TMDDBA.TM_PG_ABS abs WHERE abs.id in ( select a.id FROM TMDDBA.TM_PG_ABS a where ABS_DELETED = 0 AND (INSTR(OWNERS,'|ATP|')>0 OR INSTR(OWNERS,'|NAA|')>0 OR INSTR(OWNERS,'|SFP1|')>0 OR INSTR(OWNERS,'|SFP2|')>0 OR INSTR(OWNERS,'|TECHM|')>0 OR INSTR(OWNERS,'|TMD|')>0 OR INSTR(OWNERS,'|YLE TV1|')>0 ) AND (CONTAINS(CTX_TEXT_COL,'mr robot') > 0 OR CONTAINS(CTX_IDS_COL,'mr robot') > 0 ) AND ROWNUM < 25000 ) ) ,v_missing_parent_ids as ( select xparent_id from v minus select id from v ) ,v_missing_parents as ( SELECT distinct a.* ,decode(ITEM_TYPE, 1010,SER_ABS_ID, 1020,CASE WHEN SER_ABS2_ID > 0 THEN SER_ABS2_ID ELSE SER_ABS_ID END ) xparent_id FROM TMDDBA.TM_PG_ABS a START WITH ID IN (select xparent_id from v_missing_parent_ids) CONNECT BY CASE PRIOR ITEM_TYPE WHEN 1010 THEN PRIOR SER_ABS_ID WHEN 1020 THEN CASE WHEN NVL(PRIOR SER_ABS2_ID, 0) > 0 THEN PRIOR SER_ABS2_ID ELSE PRIOR SER_ABS_ID END END = ID ) ,v_all as ( select x.*, count(*) over() RowCount from ( select * from v_missing_parents union all select * from v ) x ) ,v_top as ( select id from (select id, row_number()over(order by upper(ser_title),upper(title),ser_num,ser_ep_num, SER_EP_SQ_NUM ) rnk -- sort roots from v_all where xparent_id is null) where rnk between (:page_number-1)*50+1 and :page_number*50 ) ,v_tree as ( select level lvl, a.* from v_all a start with id in (select id from v_top) connect by xparent_id = prior ID order siblings by upper(ser_title),ser_num,ser_ep_num, SER_EP_SQ_NUM,upper(title) -- sort children ) select * from v_tree --where rnk <= 50 t Transfer: 1220 : 26|14:08:17.7503||IsUserAuthenticated: /api/int/title/281968/versions?_dc=1573481297725 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 26|14:08:17.7503|| user DANIEL. t Transfer: 1220 : 26|14:08:17.7503||api user: DANIEL t Information: 1220 : |V3Api.GetVersionsByTitleIdAdv t Information: 1220 : |V3Api.SearchGeneric t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 26|14:08:17.7503|| user DANIEL. t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 26|14:08:17.7503|| user DANIEL. t Information: 1220 : 26|14:08:17.7660||SearchVersion SQL: select * from (select a.*, rownum rnum from ( select m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE from tmddba.tm_pg_rl m left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id where item_type>0 and rl_deleted=0 and m.PGM_ABS_ID=281968 AND (INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|NAA|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|TECHM|')>0 OR INSTR(m.OWNERS,'|TMD|')>0 OR INSTR(m.OWNERS,'|YLE TV1|')>0) order by m.title, m.id ) a where rownum <= 9999) r where rnum >=1 order by rnum t Transfer: 1220 : 51|14:08:17.7660||IsUserAuthenticated: /api/user-preferences?_dc=1573481297727 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 51|14:08:17.7660|| user DANIEL. t Transfer: 1220 : 51|14:08:17.7660||api user: DANIEL t Verbose: 1220 : |StoreUserDataByKeys.. t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 51|14:08:17.7660|| user DANIEL. t Information: 1220 : |Running version search. User: 342 Simple Search: Running Oracle search for COUNT Oracle count completed in: 8ms. Returned lines: 0 Running Oracle search. Oracle version search timing: 35ms. SQL run: select * from (select a.*, rownum rnum from ( select m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE from tmddba.tm_pg_rl m left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id where item_type>0 and rl_deleted=0 and m.PGM_ABS_ID=281968 AND (INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|NAA|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|TECHM|')>0 OR INSTR(m.OWNERS,'|TMD|')>0 OR INSTR(m.OWNERS,'|YLE TV1|')>0) order by m.title, m.id ) a where rownum <= 9999) r where rnum >=1 order by rnum t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 26|14:08:20.0628|| user TMDDBA. t Transfer: 1220 : 42|14:08:36.1410||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1573481316111 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 42|14:08:36.1410|| user DANIEL. t Transfer: 1220 : 42|14:08:36.1410||api user: DANIEL t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 42|14:08:36.1410|| user DANIEL. t Transfer: 1220 : 23|14:08:36.3128||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1573481316280 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 23|14:08:36.3128|| user DANIEL. t Transfer: 1220 : 23|14:08:36.3128||api user: DANIEL t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 23|14:08:36.3128|| user DANIEL. t Transfer: 1220 : 19|14:08:36.5003||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1573481316455 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 19|14:08:36.5003|| user DANIEL. t Transfer: 1220 : 19|14:08:36.5003||api user: DANIEL t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 19|14:08:36.5003|| user DANIEL. t Transfer: 1220 : 50|14:08:39.1409||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1573481319119 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 50|14:08:39.1409|| user DANIEL. t Transfer: 1220 : 50|14:08:39.1409||api user: DANIEL t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 50|14:08:39.1409|| user DANIEL. t Transfer: 1220 : 42|14:08:39.8284||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1573481319799 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 42|14:08:39.8284|| user DANIEL. t Transfer: 1220 : 42|14:08:39.8284||api user: DANIEL t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 42|14:08:39.8284|| user DANIEL. t Transfer: 1220 : 19|14:08:40.0004||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1573481319968 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 19|14:08:40.0004|| user DANIEL. t Transfer: 1220 : 19|14:08:40.0004||api user: DANIEL t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 19|14:08:40.0004|| user DANIEL. t Transfer: 1220 : 17|14:08:55.6409||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1573481335607 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 17|14:08:55.6409|| user DANIEL. t Transfer: 1220 : 17|14:08:55.6409||api user: DANIEL t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 17|14:08:55.6409|| user DANIEL. t Transfer: 1220 : 26|14:08:55.7972||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1573481335776 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 26|14:08:55.7972|| user DANIEL. t Transfer: 1220 : 26|14:08:55.7972||api user: DANIEL t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 26|14:08:55.7972|| user DANIEL. t Transfer: 1220 : 26|14:08:57.3910||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1573481337371 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 26|14:08:57.3910|| user DANIEL. t Transfer: 1220 : 26|14:08:57.3910||api user: DANIEL t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 26|14:08:57.3910|| user DANIEL. t Transfer: 1220 : 32|14:08:57.8753||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1573481337847 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 32|14:08:57.8753|| user DANIEL. t Transfer: 1220 : 32|14:08:57.8753||api user: DANIEL t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 32|14:08:57.8753|| user DANIEL. t Transfer: 1220 : 23|14:08:57.9847||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1573481337960 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 23|14:08:58.0004|| user DANIEL. t Transfer: 1220 : 23|14:08:58.0004||api user: DANIEL t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 23|14:08:58.0004|| user DANIEL. t Transfer: 1220 : 50|14:08:58.7659||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1573481338735 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 50|14:08:58.7659|| user DANIEL. t Transfer: 1220 : 50|14:08:58.7659||api user: DANIEL t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 50|14:08:58.7659|| user DANIEL. t Transfer: 1220 : 23|14:08:59.4535||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1573481339423 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 23|14:08:59.4535|| user DANIEL. t Transfer: 1220 : 23|14:08:59.4535||api user: DANIEL t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 23|14:08:59.4535|| user DANIEL. t Transfer: 1220 : 32|14:09:04.7972||IsUserAuthenticated: /api/search/title?_dc=1573481344757 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 32|14:09:04.7972|| user DANIEL. t Transfer: 1220 : 32|14:09:04.7972||api user: DANIEL t Information: 1220 : |V3Api.SearchTitles t Information: 1220 : |V3Api.SearchGeneric t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 32|14:09:04.7972|| user DANIEL. t Information: 1220 : 32|14:09:04.7972||SearchTitle SQL: with v as ( SELECT abs.* ,decode(ITEM_TYPE, 1010,SER_ABS_ID, 1020,CASE WHEN SER_ABS2_ID > 0 THEN SER_ABS2_ID ELSE SER_ABS_ID END ) xparent_id FROM TMDDBA.TM_PG_ABS abs WHERE abs.id in ( select a.id FROM TMDDBA.TM_PG_ABS a where ABS_DELETED = 0 AND (INSTR(OWNERS,'|ATP|')>0 OR INSTR(OWNERS,'|NAA|')>0 OR INSTR(OWNERS,'|SFP1|')>0 OR INSTR(OWNERS,'|SFP2|')>0 OR INSTR(OWNERS,'|TECHM|')>0 OR INSTR(OWNERS,'|TMD|')>0 OR INSTR(OWNERS,'|YLE TV1|')>0 ) AND a.ser_abs_id=281968 AND ROWNUM < 25000 ) ) ,v_missing_parent_ids as ( select xparent_id from v minus select id from v ) ,v_missing_parents as ( SELECT distinct a.* ,decode(ITEM_TYPE, 1010,SER_ABS_ID, 1020,CASE WHEN SER_ABS2_ID > 0 THEN SER_ABS2_ID ELSE SER_ABS_ID END ) xparent_id FROM TMDDBA.TM_PG_ABS a START WITH ID IN (select xparent_id from v_missing_parent_ids) CONNECT BY CASE PRIOR ITEM_TYPE WHEN 1010 THEN PRIOR SER_ABS_ID WHEN 1020 THEN CASE WHEN NVL(PRIOR SER_ABS2_ID, 0) > 0 THEN PRIOR SER_ABS2_ID ELSE PRIOR SER_ABS_ID END END = ID ) ,v_all as ( select x.*, count(*) over() RowCount from ( select * from v_missing_parents union all select * from v ) x ) ,v_top as ( select id from (select id, row_number()over(order by upper(ser_title),upper(title),ser_num,ser_ep_num, SER_EP_SQ_NUM ) rnk -- sort roots from v_all where xparent_id is null) where rnk between (:page_number-1)*50+1 and :page_number*50 ) ,v_tree as ( select level lvl, a.* from v_all a start with id in (select id from v_top) connect by xparent_id = prior ID order siblings by upper(ser_title),ser_num,ser_ep_num, SER_EP_SQ_NUM,upper(title) -- sort children ) select * from v_tree --where rnk <= 50 t Transfer: 1220 : 50|14:09:04.9691||IsUserAuthenticated: /api/user-preferences?_dc=1573481344941 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 50|14:09:04.9691|| user DANIEL. t Transfer: 1220 : 50|14:09:04.9691||api user: DANIEL t Verbose: 1220 : |StoreUserDataByKeys.. t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 50|14:09:04.9691|| user DANIEL. t Transfer: 1220 : 6|14:09:04.9847||IsUserAuthenticated: /api/int/title/281968/versions?_dc=1573481344938 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 6|14:09:04.9847|| user DANIEL. t Transfer: 1220 : 6|14:09:04.9847||api user: DANIEL t Information: 1220 : |V3Api.GetVersionsByTitleIdAdv t Information: 1220 : |V3Api.SearchGeneric t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 6|14:09:04.9847|| user DANIEL. t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 6|14:09:04.9847|| user DANIEL. t Information: 1220 : 6|14:09:04.9847||SearchVersion SQL: select * from (select a.*, rownum rnum from ( select m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE from tmddba.tm_pg_rl m left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id where item_type>0 and rl_deleted=0 and m.PGM_ABS_ID=281968 AND (INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|NAA|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|TECHM|')>0 OR INSTR(m.OWNERS,'|TMD|')>0 OR INSTR(m.OWNERS,'|YLE TV1|')>0) order by m.title, m.id ) a where rownum <= 9999) r where rnum >=1 order by rnum t Information: 1220 : |Running version search. User: 342 Simple Search: Running Oracle search for COUNT Oracle count completed in: 1ms. Returned lines: 0 Running Oracle search. Oracle version search timing: 3ms. SQL run: select * from (select a.*, rownum rnum from ( select m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE from tmddba.tm_pg_rl m left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id where item_type>0 and rl_deleted=0 and m.PGM_ABS_ID=281968 AND (INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|NAA|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|TECHM|')>0 OR INSTR(m.OWNERS,'|TMD|')>0 OR INSTR(m.OWNERS,'|YLE TV1|')>0) order by m.title, m.id ) a where rownum <= 9999) r where rnum >=1 order by rnum t Transfer: 1220 : 19|14:09:10.9378||IsUserAuthenticated: /api/int/title/281969/versions?_dc=1573481350906 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 19|14:09:10.9378|| user DANIEL. t Transfer: 1220 : 19|14:09:10.9378||api user: DANIEL t Information: 1220 : |V3Api.GetVersionsByTitleIdAdv t Information: 1220 : |V3Api.SearchGeneric t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 19|14:09:10.9378|| user DANIEL. t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 19|14:09:10.9378|| user DANIEL. t Information: 1220 : 19|14:09:10.9535||SearchVersion SQL: select * from (select a.*, rownum rnum from ( select m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE from tmddba.tm_pg_rl m left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id where item_type>0 and rl_deleted=0 and m.PGM_ABS_ID=281969 AND (INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|NAA|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|TECHM|')>0 OR INSTR(m.OWNERS,'|TMD|')>0 OR INSTR(m.OWNERS,'|YLE TV1|')>0) order by m.title, m.id ) a where rownum <= 9999) r where rnum >=1 order by rnum t Information: 1220 : |Running version search. User: 342 Simple Search: Running Oracle search for COUNT Oracle count completed in: 8ms. Returned lines: 0 Running Oracle search. Oracle version search timing: 34ms. SQL run: select * from (select a.*, rownum rnum from ( select m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE from tmddba.tm_pg_rl m left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id where item_type>0 and rl_deleted=0 and m.PGM_ABS_ID=281969 AND (INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|NAA|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|TECHM|')>0 OR INSTR(m.OWNERS,'|TMD|')>0 OR INSTR(m.OWNERS,'|YLE TV1|')>0) order by m.title, m.id ) a where rownum <= 9999) r where rnum >=1 order by rnum t Transfer: 1220 : 17|14:09:11.5628||IsUserAuthenticated: /api/int/title/281970/versions?_dc=1573481351535 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 17|14:09:11.5628|| user DANIEL. t Transfer: 1220 : 17|14:09:11.5628||api user: DANIEL t Information: 1220 : |V3Api.GetVersionsByTitleIdAdv t Information: 1220 : |V3Api.SearchGeneric t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 17|14:09:11.5628|| user DANIEL. t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 17|14:09:11.5628|| user DANIEL. t Information: 1220 : 17|14:09:11.5785||SearchVersion SQL: select * from (select a.*, rownum rnum from ( select m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE from tmddba.tm_pg_rl m left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id where item_type>0 and rl_deleted=0 and m.PGM_ABS_ID=281970 AND (INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|NAA|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|TECHM|')>0 OR INSTR(m.OWNERS,'|TMD|')>0 OR INSTR(m.OWNERS,'|YLE TV1|')>0) order by m.title, m.id ) a where rownum <= 9999) r where rnum >=1 order by rnum t Information: 1220 : |Running version search. User: 342 Simple Search: Running Oracle search for COUNT Oracle count completed in: 6ms. Returned lines: 1 Running Oracle search. Oracle version search timing: 73ms. SQL run: select * from (select a.*, rownum rnum from ( select m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE from tmddba.tm_pg_rl m left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id where item_type>0 and rl_deleted=0 and m.PGM_ABS_ID=281970 AND (INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|NAA|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|TECHM|')>0 OR INSTR(m.OWNERS,'|TMD|')>0 OR INSTR(m.OWNERS,'|YLE TV1|')>0) order by m.title, m.id ) a where rownum <= 9999) r where rnum >=1 order by rnum t Transfer: 1220 : 19|14:09:11.7659||IsUserAuthenticated: /api/int/version/281971/media?_dc=1573481351736 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 19|14:09:11.7659|| user DANIEL. t Transfer: 1220 : 19|14:09:11.7659||api user: DANIEL t Information: 1220 : |V3Api.GetMediaByVersionIdAdv t Information: 1220 : |V3Api.SearchGeneric t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 19|14:09:11.7972|| user DANIEL. t Information: 1220 : 19|14:09:11.7972||MediaSearch SQL: select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type=1),'') 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 t.name from TM_CFG_MI_FMT_TYP t where t.id = r.mi_fmt_type) ITEM_FORMAT_TEXT, GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select a.*, rownum rnum from (select m.*, coalesce(m.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=m.pgm_parent_id)) primary_thumb_id2 from tmddba.tm_mis m where media_type>0 and item_type>0 AND PGM_PARENT_ID=281971 and m.mi_deleted=0 AND (INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|NAA|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|TECHM|')>0 OR INSTR(m.OWNERS,'|TMD|')>0 OR INSTR(m.OWNERS,'|YLE TV1|')>0) order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl where rnum >= 1 order by rnum t Information: 1220 : | count returned 0 t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 17|14:09:12.5160|| user TMDDBA. t Transfer: 1220 : 42|14:09:15.2191||IsUserAuthenticated: /api/int/title/281972/versions?_dc=1573481355192 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 42|14:09:15.2191|| user DANIEL. t Transfer: 1220 : 42|14:09:15.2191||api user: DANIEL t Information: 1220 : |V3Api.GetVersionsByTitleIdAdv t Information: 1220 : |V3Api.SearchGeneric t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 42|14:09:15.2191|| user DANIEL. t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 42|14:09:15.2191|| user DANIEL. t Information: 1220 : 42|14:09:15.2347||SearchVersion SQL: select * from (select a.*, rownum rnum from ( select m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE from tmddba.tm_pg_rl m left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id where item_type>0 and rl_deleted=0 and m.PGM_ABS_ID=281972 AND (INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|NAA|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|TECHM|')>0 OR INSTR(m.OWNERS,'|TMD|')>0 OR INSTR(m.OWNERS,'|YLE TV1|')>0) order by m.title, m.id ) a where rownum <= 9999) r where rnum >=1 order by rnum t Information: 1220 : |Running version search. User: 342 Simple Search: Running Oracle search for COUNT Oracle count completed in: 7ms. Returned lines: 1 Running Oracle search. Oracle version search timing: 30ms. SQL run: select * from (select a.*, rownum rnum from ( select m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE from tmddba.tm_pg_rl m left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id where item_type>0 and rl_deleted=0 and m.PGM_ABS_ID=281972 AND (INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|NAA|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|TECHM|')>0 OR INSTR(m.OWNERS,'|TMD|')>0 OR INSTR(m.OWNERS,'|YLE TV1|')>0) order by m.title, m.id ) a where rownum <= 9999) r where rnum >=1 order by rnum t Transfer: 1220 : 10|14:09:15.3128||IsUserAuthenticated: /api/int/version/281973/media?_dc=1573481355283 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 10|14:09:15.3128|| user DANIEL. t Transfer: 1220 : 10|14:09:15.3128||api user: DANIEL t Information: 1220 : |V3Api.GetMediaByVersionIdAdv t Information: 1220 : |V3Api.SearchGeneric t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 10|14:09:15.3128|| user DANIEL. t Information: 1220 : 10|14:09:15.3128||MediaSearch SQL: select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type=1),'') 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 t.name from TM_CFG_MI_FMT_TYP t where t.id = r.mi_fmt_type) ITEM_FORMAT_TEXT, GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select a.*, rownum rnum from (select m.*, coalesce(m.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=m.pgm_parent_id)) primary_thumb_id2 from tmddba.tm_mis m where media_type>0 and item_type>0 AND PGM_PARENT_ID=281973 and m.mi_deleted=0 AND (INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|NAA|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|TECHM|')>0 OR INSTR(m.OWNERS,'|TMD|')>0 OR INSTR(m.OWNERS,'|YLE TV1|')>0) order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl where rnum >= 1 order by rnum t Information: 1220 : | count returned 0 t Transfer: 1220 : 19|14:09:17.1722||IsUserAuthenticated: /api/int/title/281974/versions?_dc=1573481357137 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 19|14:09:17.1722|| user DANIEL. t Transfer: 1220 : 19|14:09:17.1722||api user: DANIEL t Information: 1220 : |V3Api.GetVersionsByTitleIdAdv t Information: 1220 : |V3Api.SearchGeneric t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 19|14:09:17.1722|| user DANIEL. t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 19|14:09:17.1722|| user DANIEL. t Information: 1220 : 19|14:09:17.1722||SearchVersion SQL: select * from (select a.*, rownum rnum from ( select m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE from tmddba.tm_pg_rl m left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id where item_type>0 and rl_deleted=0 and m.PGM_ABS_ID=281974 AND (INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|NAA|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|TECHM|')>0 OR INSTR(m.OWNERS,'|TMD|')>0 OR INSTR(m.OWNERS,'|YLE TV1|')>0) order by m.title, m.id ) a where rownum <= 9999) r where rnum >=1 order by rnum t Information: 1220 : |Running version search. User: 342 Simple Search: Running Oracle search for COUNT Oracle count completed in: 5ms. Returned lines: 1 Running Oracle search. Oracle version search timing: 38ms. SQL run: select * from (select a.*, rownum rnum from ( select m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE from tmddba.tm_pg_rl m left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id where item_type>0 and rl_deleted=0 and m.PGM_ABS_ID=281974 AND (INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|NAA|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|TECHM|')>0 OR INSTR(m.OWNERS,'|TMD|')>0 OR INSTR(m.OWNERS,'|YLE TV1|')>0) order by m.title, m.id ) a where rownum <= 9999) r where rnum >=1 order by rnum t Transfer: 1220 : 10|14:09:17.2660||IsUserAuthenticated: /api/int/version/281975/media?_dc=1573481357238 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 10|14:09:17.2660|| user DANIEL. t Transfer: 1220 : 10|14:09:17.2660||api user: DANIEL t Information: 1220 : |V3Api.GetMediaByVersionIdAdv t Information: 1220 : |V3Api.SearchGeneric t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 10|14:09:17.2660|| user DANIEL. t Information: 1220 : 10|14:09:17.2660||MediaSearch SQL: select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type=1),'') 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 t.name from TM_CFG_MI_FMT_TYP t where t.id = r.mi_fmt_type) ITEM_FORMAT_TEXT, GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select a.*, rownum rnum from (select m.*, coalesce(m.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=m.pgm_parent_id)) primary_thumb_id2 from tmddba.tm_mis m where media_type>0 and item_type>0 AND PGM_PARENT_ID=281975 and m.mi_deleted=0 AND (INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|NAA|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|TECHM|')>0 OR INSTR(m.OWNERS,'|TMD|')>0 OR INSTR(m.OWNERS,'|YLE TV1|')>0) order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl where rnum >= 1 order by rnum t Information: 1220 : | count returned 0 t Transfer: 1220 : 18|14:09:19.3441||IsUserAuthenticated: /api/int/title/281976/versions?_dc=1573481359324 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 18|14:09:19.3441|| user DANIEL. t Transfer: 1220 : 18|14:09:19.3441||api user: DANIEL t Information: 1220 : |V3Api.GetVersionsByTitleIdAdv t Information: 1220 : |V3Api.SearchGeneric t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 18|14:09:19.3597|| user DANIEL. t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 18|14:09:19.3597|| user DANIEL. t Information: 1220 : 18|14:09:19.3597||SearchVersion SQL: select * from (select a.*, rownum rnum from ( select m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE from tmddba.tm_pg_rl m left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id where item_type>0 and rl_deleted=0 and m.PGM_ABS_ID=281976 AND (INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|NAA|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|TECHM|')>0 OR INSTR(m.OWNERS,'|TMD|')>0 OR INSTR(m.OWNERS,'|YLE TV1|')>0) order by m.title, m.id ) a where rownum <= 9999) r where rnum >=1 order by rnum t Information: 1220 : |Running version search. User: 342 Simple Search: Running Oracle search for COUNT Oracle count completed in: 5ms. Returned lines: 1 Running Oracle search. Oracle version search timing: 40ms. SQL run: select * from (select a.*, rownum rnum from ( select m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE from tmddba.tm_pg_rl m left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id where item_type>0 and rl_deleted=0 and m.PGM_ABS_ID=281976 AND (INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|NAA|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|TECHM|')>0 OR INSTR(m.OWNERS,'|TMD|')>0 OR INSTR(m.OWNERS,'|YLE TV1|')>0) order by m.title, m.id ) a where rownum <= 9999) r where rnum >=1 order by rnum t Transfer: 1220 : 33|14:09:19.4535||IsUserAuthenticated: /api/int/version/281977/media?_dc=1573481359418 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 33|14:09:19.4535|| user DANIEL. t Transfer: 1220 : 33|14:09:19.4535||api user: DANIEL t Information: 1220 : |V3Api.GetMediaByVersionIdAdv t Information: 1220 : |V3Api.SearchGeneric t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 33|14:09:19.4535|| user DANIEL. t Information: 1220 : 33|14:09:19.4535||MediaSearch SQL: select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type=1),'') 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 t.name from TM_CFG_MI_FMT_TYP t where t.id = r.mi_fmt_type) ITEM_FORMAT_TEXT, GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select a.*, rownum rnum from (select m.*, coalesce(m.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=m.pgm_parent_id)) primary_thumb_id2 from tmddba.tm_mis m where media_type>0 and item_type>0 AND PGM_PARENT_ID=281977 and m.mi_deleted=0 AND (INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|NAA|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|TECHM|')>0 OR INSTR(m.OWNERS,'|TMD|')>0 OR INSTR(m.OWNERS,'|YLE TV1|')>0) order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl where rnum >= 1 order by rnum t Information: 1220 : | count returned 0 t Transfer: 1220 : 6|14:09:20.3284||IsUserAuthenticated: /api/int/title/281978/versions?_dc=1573481360303 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 6|14:09:20.3284|| user DANIEL. t Transfer: 1220 : 6|14:09:20.3284||api user: DANIEL t Information: 1220 : |V3Api.GetVersionsByTitleIdAdv t Information: 1220 : |V3Api.SearchGeneric t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 6|14:09:20.3284|| user DANIEL. t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 6|14:09:20.3284|| user DANIEL. t Information: 1220 : 6|14:09:20.3441||SearchVersion SQL: select * from (select a.*, rownum rnum from ( select m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE from tmddba.tm_pg_rl m left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id where item_type>0 and rl_deleted=0 and m.PGM_ABS_ID=281978 AND (INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|NAA|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|TECHM|')>0 OR INSTR(m.OWNERS,'|TMD|')>0 OR INSTR(m.OWNERS,'|YLE TV1|')>0) order by m.title, m.id ) a where rownum <= 9999) r where rnum >=1 order by rnum t Information: 1220 : |Running version search. User: 342 Simple Search: Running Oracle search for COUNT Oracle count completed in: 5ms. Returned lines: 1 Running Oracle search. Oracle version search timing: 33ms. SQL run: select * from (select a.*, rownum rnum from ( select m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE from tmddba.tm_pg_rl m left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id where item_type>0 and rl_deleted=0 and m.PGM_ABS_ID=281978 AND (INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|NAA|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|TECHM|')>0 OR INSTR(m.OWNERS,'|TMD|')>0 OR INSTR(m.OWNERS,'|YLE TV1|')>0) order by m.title, m.id ) a where rownum <= 9999) r where rnum >=1 order by rnum t Transfer: 1220 : 30|14:09:20.4222||IsUserAuthenticated: /api/int/version/281979/media?_dc=1573481360394 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 30|14:09:20.4222|| user DANIEL. t Transfer: 1220 : 30|14:09:20.4222||api user: DANIEL t Information: 1220 : |V3Api.GetMediaByVersionIdAdv t Information: 1220 : |V3Api.SearchGeneric t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 30|14:09:20.4222|| user DANIEL. t Information: 1220 : 30|14:09:20.4222||MediaSearch SQL: select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type=1),'') 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 t.name from TM_CFG_MI_FMT_TYP t where t.id = r.mi_fmt_type) ITEM_FORMAT_TEXT, GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select a.*, rownum rnum from (select m.*, coalesce(m.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=m.pgm_parent_id)) primary_thumb_id2 from tmddba.tm_mis m where media_type>0 and item_type>0 AND PGM_PARENT_ID=281979 and m.mi_deleted=0 AND (INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|NAA|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|TECHM|')>0 OR INSTR(m.OWNERS,'|TMD|')>0 OR INSTR(m.OWNERS,'|YLE TV1|')>0) order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl where rnum >= 1 order by rnum t Information: 1220 : | count returned 0 t Transfer: 1220 : 23|14:09:21.7503||IsUserAuthenticated: /api/int/title/281980/versions?_dc=1573481361718 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 23|14:09:21.7503|| user DANIEL. t Transfer: 1220 : 23|14:09:21.7503||api user: DANIEL t Information: 1220 : |V3Api.GetVersionsByTitleIdAdv t Information: 1220 : |V3Api.SearchGeneric t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 23|14:09:21.7503|| user DANIEL. t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 23|14:09:21.7503|| user DANIEL. t Information: 1220 : 23|14:09:21.7660||SearchVersion SQL: select * from (select a.*, rownum rnum from ( select m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE from tmddba.tm_pg_rl m left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id where item_type>0 and rl_deleted=0 and m.PGM_ABS_ID=281980 AND (INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|NAA|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|TECHM|')>0 OR INSTR(m.OWNERS,'|TMD|')>0 OR INSTR(m.OWNERS,'|YLE TV1|')>0) order by m.title, m.id ) a where rownum <= 9999) r where rnum >=1 order by rnum t Information: 1220 : |Running version search. User: 342 Simple Search: Running Oracle search for COUNT Oracle count completed in: 5ms. Returned lines: 1 Running Oracle search. Oracle version search timing: 33ms. SQL run: select * from (select a.*, rownum rnum from ( select m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE from tmddba.tm_pg_rl m left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id where item_type>0 and rl_deleted=0 and m.PGM_ABS_ID=281980 AND (INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|NAA|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|TECHM|')>0 OR INSTR(m.OWNERS,'|TMD|')>0 OR INSTR(m.OWNERS,'|YLE TV1|')>0) order by m.title, m.id ) a where rownum <= 9999) r where rnum >=1 order by rnum t Transfer: 1220 : 10|14:09:21.8597||IsUserAuthenticated: /api/int/version/281981/media?_dc=1573481361825 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 10|14:09:21.8597|| user DANIEL. t Transfer: 1220 : 10|14:09:21.8597||api user: DANIEL t Information: 1220 : |V3Api.GetMediaByVersionIdAdv t Information: 1220 : |V3Api.SearchGeneric t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 10|14:09:21.8597|| user DANIEL. t Information: 1220 : 10|14:09:21.8597||MediaSearch SQL: select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type=1),'') 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 t.name from TM_CFG_MI_FMT_TYP t where t.id = r.mi_fmt_type) ITEM_FORMAT_TEXT, GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select a.*, rownum rnum from (select m.*, coalesce(m.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=m.pgm_parent_id)) primary_thumb_id2 from tmddba.tm_mis m where media_type>0 and item_type>0 AND PGM_PARENT_ID=281981 and m.mi_deleted=0 AND (INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|NAA|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|TECHM|')>0 OR INSTR(m.OWNERS,'|TMD|')>0 OR INSTR(m.OWNERS,'|YLE TV1|')>0) order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl where rnum >= 1 order by rnum t Information: 1220 : | count returned 0 t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 18|14:10:12.4066|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 33|14:11:12.4378|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 33|14:12:12.3909|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 11|14:13:12.3819|| user TMDDBA. t Transfer: 1220 : 11|14:13:33.7569||IsUserAuthenticated: /api/int/title/281978/versions?_dc=1573481613675 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 11|14:13:33.7569|| user DANIEL. t Transfer: 1220 : 11|14:13:33.7569||api user: DANIEL t Information: 1220 : |V3Api.GetVersionsByTitleIdAdv t Information: 1220 : |V3Api.SearchGeneric t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 11|14:13:33.7569|| user DANIEL. t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 11|14:13:33.7569|| user DANIEL. t Information: 1220 : 11|14:13:33.7569||SearchVersion SQL: select * from (select a.*, rownum rnum from ( select m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE from tmddba.tm_pg_rl m left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id where item_type>0 and rl_deleted=0 and m.PGM_ABS_ID=281978 AND (INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|NAA|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|TECHM|')>0 OR INSTR(m.OWNERS,'|TMD|')>0 OR INSTR(m.OWNERS,'|YLE TV1|')>0) order by m.title, m.id ) a where rownum <= 9999) r where rnum >=1 order by rnum t Information: 1220 : |Running version search. User: 342 Simple Search: Running Oracle search for COUNT Oracle count completed in: 1ms. Returned lines: 1 Running Oracle search. Oracle version search timing: 4ms. SQL run: select * from (select a.*, rownum rnum from ( select m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE from tmddba.tm_pg_rl m left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id where item_type>0 and rl_deleted=0 and m.PGM_ABS_ID=281978 AND (INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|NAA|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|TECHM|')>0 OR INSTR(m.OWNERS,'|TMD|')>0 OR INSTR(m.OWNERS,'|YLE TV1|')>0) order by m.title, m.id ) a where rownum <= 9999) r where rnum >=1 order by rnum t Transfer: 1220 : 12|14:13:33.8819||IsUserAuthenticated: /api/int/version/281979/media?_dc=1573481613823 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 12|14:13:33.8976|| user DANIEL. t Transfer: 1220 : 12|14:13:33.8976||api user: DANIEL t Information: 1220 : |V3Api.GetMediaByVersionIdAdv t Information: 1220 : |V3Api.SearchGeneric t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 12|14:13:33.8976|| user DANIEL. t Information: 1220 : 12|14:13:33.8976||MediaSearch SQL: select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type=1),'') 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 t.name from TM_CFG_MI_FMT_TYP t where t.id = r.mi_fmt_type) ITEM_FORMAT_TEXT, GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select a.*, rownum rnum from (select m.*, coalesce(m.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=m.pgm_parent_id)) primary_thumb_id2 from tmddba.tm_mis m where media_type>0 and item_type>0 AND PGM_PARENT_ID=281979 and m.mi_deleted=0 AND (INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|NAA|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|TECHM|')>0 OR INSTR(m.OWNERS,'|TMD|')>0 OR INSTR(m.OWNERS,'|YLE TV1|')>0) order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl where rnum >= 1 order by rnum t Information: 1220 : | count returned 0 t Transfer: 1220 : 26|14:13:35.2256||IsUserAuthenticated: /api/int/title/281980/versions?_dc=1573481615119 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 26|14:13:35.2256|| user DANIEL. t Transfer: 1220 : 26|14:13:35.2256||api user: DANIEL t Information: 1220 : |V3Api.GetVersionsByTitleIdAdv t Information: 1220 : |V3Api.SearchGeneric t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 26|14:13:35.2256|| user DANIEL. t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 26|14:13:35.2256|| user DANIEL. t Information: 1220 : 26|14:13:35.2256||SearchVersion SQL: select * from (select a.*, rownum rnum from ( select m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE from tmddba.tm_pg_rl m left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id where item_type>0 and rl_deleted=0 and m.PGM_ABS_ID=281980 AND (INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|NAA|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|TECHM|')>0 OR INSTR(m.OWNERS,'|TMD|')>0 OR INSTR(m.OWNERS,'|YLE TV1|')>0) order by m.title, m.id ) a where rownum <= 9999) r where rnum >=1 order by rnum t Information: 1220 : |Running version search. User: 342 Simple Search: Running Oracle search for COUNT Oracle count completed in: 1ms. Returned lines: 1 Running Oracle search. Oracle version search timing: 9ms. SQL run: select * from (select a.*, rownum rnum from ( select m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE from tmddba.tm_pg_rl m left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id where item_type>0 and rl_deleted=0 and m.PGM_ABS_ID=281980 AND (INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|NAA|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|TECHM|')>0 OR INSTR(m.OWNERS,'|TMD|')>0 OR INSTR(m.OWNERS,'|YLE TV1|')>0) order by m.title, m.id ) a where rownum <= 9999) r where rnum >=1 order by rnum t Transfer: 1220 : 12|14:13:35.3194||IsUserAuthenticated: /api/int/version/281981/media?_dc=1573481615259 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 12|14:13:35.3194|| user DANIEL. t Transfer: 1220 : 12|14:13:35.3194||api user: DANIEL t Information: 1220 : |V3Api.GetMediaByVersionIdAdv t Information: 1220 : |V3Api.SearchGeneric t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 12|14:13:35.3194|| user DANIEL. t Information: 1220 : 12|14:13:35.3194||MediaSearch SQL: select r.*, nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type=1),'') 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 t.name from TM_CFG_MI_FMT_TYP t where t.id = r.mi_fmt_type) ITEM_FORMAT_TEXT, GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select a.*, rownum rnum from (select m.*, coalesce(m.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=m.pgm_parent_id)) primary_thumb_id2 from tmddba.tm_mis m where media_type>0 and item_type>0 AND PGM_PARENT_ID=281981 and m.mi_deleted=0 AND (INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|NAA|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|TECHM|')>0 OR INSTR(m.OWNERS,'|TMD|')>0 OR INSTR(m.OWNERS,'|YLE TV1|')>0) order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl where rnum >= 1 order by rnum t Information: 1220 : | count returned 0 t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 8|14:14:12.4288|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 17|14:15:12.4288|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 17|14:16:12.4288|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 37|14:17:12.3860|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 54|14:18:12.4798|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 49|14:19:12.3860|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 33|14:20:12.4172|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 41|14:21:12.4329|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 49|14:22:12.3860|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 36|14:23:12.4328|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 25|14:24:12.3704|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 35|14:25:12.4485|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 50|14:26:12.4485|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 30|14:27:12.4641|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 38|14:28:12.4485|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 37|14:29:12.3859|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 49|14:30:12.4484|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 42|14:31:12.4328|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 8|14:32:12.4328|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 10|14:33:12.4229|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 50|14:34:20.4073|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 41|14:35:12.4229|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 7|14:36:12.4229|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 12|14:37:12.4229|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 38|14:38:12.4072|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 7|14:39:12.3760|| user TMDDBA. t Information: 1220 : |OrabitWatcherBasic. Disposing. t Information: 1220 : |OrabitWatcherBasic. Disposed. t Information: 1220 : |========================================================================== t Information: 1220 : |IMFX CORE SERVER APPLICATION END. t Information: 1220 : 20|14:40:34.6666||OrabitWatcherBasic connection shutdown. reason Unexpected Exception.