t Information: 1220 : |Get Configuration Values: t Information: 1220 : 1|14:07:28.0837|| AdminPassEnc, default: , value: ffqjrn0leKv4Lj2YJHe2dw==. t Information: 1220 : 1|14:07:28.0837|| EncryptedPasswords, default: false, value: true. t Information: 1220 : 1|14:07:28.0847|| OraConnectionString, default: , value: Server=TECHM;User Id=imfx;Password=;Unicode=true;. t Information: 1220 : 1|14:07:28.0857|| SecondTimezone, default: , value: . t Information: 1220 : 1|14:07:28.0857|| UseActiveDirectoryAuth, default: false, value: false. t Information: 1220 : 1|14:07:28.0857|| ReportingServiceUrl, default: , value: http://localhost:92/ReportingService.svc. t Information: 1220 : 1|14:07:28.0869|| ReportsPath, default: , value: . t Information: 1220 : 1|14:07:28.0877|| ReportsURL, default: , value: . t Information: 1220 : 1|14:07:28.0877|| TapeServiceUrl, default: , value: . t Information: 1220 : 1|14:07:28.0877|| GatekeeperUrl, default: , value: . t Information: 1220 : 1|14:07:28.0877|| ValuationUrl, default: , value: . t Information: 1220 : 1|14:07:28.0877|| QueueManagerDelay, default: 30, value: 30. t Information: 1220 : 1|14:07:28.0877|| QueueManagerFullRefresh, default: 90, value: 90. t Information: 1220 : 1|14:07:28.0877|| AudioLoopDuration, default: 0, value: 150. t Information: 1220 : 1|14:07:28.0887|| AudioLoopsCount, default: 0, value: 0. t Information: 1220 : 1|14:07:28.0887|| PlayerFakeStep, default: 500, value: 500. t Information: 1220 : 1|14:07:28.0887|| PlayerForceRatio, default: 0, value: 1. t Information: 1220 : 1|14:07:28.0887|| CheckVersionsInProd, default: false, value: True. t Information: 1220 : 1|14:07:28.0887|| MaxResults, default: 3000, value: 10000. t Information: 1220 : 1|14:07:28.0887|| NetworkRestriction, default: false, value: True. t Information: 1220 : 1|14:07:28.0887|| TEReportID, default: 0, value: 0. t Information: 1220 : 1|14:07:28.0887|| ClosedCaptionsCache, default: , value: C:\inetpub\wwwroot\imfxcore\timedtextcache\. t Information: 1220 : 1|14:07:28.0887|| ClosedCaptionsStorage, default: , value: c:\Mediaflex\subs. t Information: 1220 : 1|14:07:28.0897|| TimeCodeFormat, default: , value: pal. t Information: 1220 : 1|14:07:28.0897|| RceMediaPath, default: , value: C:\edl\. t Information: 1220 : 1|14:07:28.0897|| RceMediaPath, default: , value: C:\edl\. t Information: 1220 : 1|14:07:28.0897|| RceCsmOutputPath, default: , value: C:\Inetpub\wwwroot\csm\. t Information: 1220 : 1|14:07:28.0897|| RceCsmUrl, default: , value: http://localhost/csm/. t Information: 1220 : 1|14:07:28.0897|| RceMediaSelection, default: , value: miLinkIdMatch. t Information: 1220 : 1|14:07:28.0897|| RequestBrowseJobPresetName, default: , value: . t Information: 1220 : 1|14:07:28.0907|| DontExtendDuration, default: false, value: False. t Information: 1220 : 1|14:07:28.0907|| V3ConfigUrl, default: , value: . t Information: 1220 : 1|14:07:28.0907|| ApiServer, default: , value: http://192.168.120.10:85. t Information: 1220 : 1|14:07:28.0907|| StopWords, default: , value: . t Information: 1220 : 1|14:07:28.0907|| MisrTxFormat, default: G, value: G. t Information: 1220 : 1|14:07:28.0907|| ThumbnailServer, default: , value: . t Information: 1220 : 1|14:07:28.0907|| LocationFilter, default: , value: . t Information: 1220 : 1|14:07:28.0907|| SvUtilServiceUrl, default: , value: . t Information: 1220 : 1|14:07:28.0917|| SolrConnection, default: , value: http://192.168.120.14:8983/solr. t Information: 1220 : 1|14:07:28.0917|| UseIndexServerSearch, default: false, value: True. t Information: 1220 : 1|14:07:28.0917|| SolrIndexVersion, default: 1, value: 6. t Information: 1220 : 1|14:07:28.0917|| SolrConnection, default: , value: http://192.168.120.14:8983/solr. t Information: 1220 : 1|14:07:28.0917|| FacetsGroups, default: , value: owners,season_id, series_id,version_key,item_type,media_type,media_format,episode_number. t Information: 1220 : 1|14:07:28.0917|| FacetsGroupsVersion, default: , value: owners,season_id, series_id,version_key,episode_number. t Information: 1220 : 1|14:07:28.0917|| FacetsGroupsChameleon, default: , value: season_id, series_id,genre,prod_year,version_key. t Information: 1220 : 1|14:07:28.0917|| PreviewPreset, default: , value: . t Information: 1220 : 1|14:07:28.0927|| DevMode, default: false, value: false. t Information: 1220 : 1|14:07:28.0927|| DisableSysMan, default: false, value: false. t Information: 1220 : 1|14:07:28.0927|| TimeCodeFormat, default: , value: pal. t Information: 1220 : 1|14:07:28.0927|| FileCatalystStorageDevice, default: , value: . t Information: 1220 : 1|14:07:28.0927|| UseResponsibilityTracking, default: true, value: True. t Information: 1220 : 1|14:07:28.0927|| SubtitleDeviceFilter, default: , value: . t Information: 1220 : 1|14:07:28.0927|| SystemMonitorNamedPipe, default: , value: . t Information: 1220 : 1|14:07:28.0927|| OracleMonitorEnable, default: false, value: False. t Information: 1220 : 1|14:07:28.0937|| ArcApiHost, default: , value: . t Information: 1220 : 1|14:07:28.0937|| RabbitMqUrl, default: , value: amqp://192.168.120.14:5672. t Information: 1220 : 1|14:07:28.0937|| SolrTimedTextSearch, default: false, value: false. t Information: 1220 : |GetStreamServers.. t Information: 1220 : 1|14:07:28.8547|| https://demo.tmd.tv/CBR Video/ |CBR Video| False t Information: 1220 : 1|14:07:28.8557|| https://demo.tmd.tv/CBR Images/ |CBR Images| False t Information: 1220 : 1|14:07:28.8557|| https://demo.tmd.tv/CBR Audio/ |CBR Audio| False t Information: 1220 : 1|14:07:28.8557|| https://demo.tmd.tv/Temp Upload/ |TEMP_UPLOAD| False t Information: 1220 : 1|14:07:28.8568|| http://localhost:82/images/ |IMAGES| False t Information: 1220 : 1|14:07:28.8568|| http://192.168.91.73/smoothcloud/ |SMOOTH_CLOUD| False t Information: 1220 : 1|14:07:28.8568|| http://192.168.91.73/cloudstore/ |CLOUD_STORE| False t Information: 1220 : 1|14:07:28.8568|| http://192.168.91.73/editsystemin/ |EDIT_SYSTEM_IN| False t Information: 1220 : 1|14:07:28.8568|| http://192.168.91.27:89/APPLEPROXY/ |APPLE_PROXY| False t Information: 1220 : 1|14:07:28.8568|| http://localhost:82/video/ |FILESTORE_VIDEO| False t Information: 1220 : 1|14:07:28.8568|| https://imfxv3tm.tmd.tv/streaming/ |Streaming| False t Information: 1220 : 1|14:07:28.8568|| https://imfxv3tm.tmd.tv/VideoServer/ |Video| False t Information: 1220 : 1|14:07:28.8577|| https://imfxv3tm.tmd.tv/AdobeIn/ |Adobe Premiere Pro In| False t Information: 1220 : 1|14:07:28.8577|| https://imfxv3tm.tmd.tv/AudioServer/ |Audio| False t Information: 1220 : 1|14:07:28.8577|| https://imfxv3tm.tmd.tv/ImageServer/ |Image| False t Information: 1220 : 1|14:07:28.8577|| https://imfxv3tm.tmd.tv/DocsServer/ |Docs| False t Information: 1220 : 1|14:07:28.8577|| https://imfxv3tm.tmd.tv/AmazonLabs/ |TEST HOUSE| False t Information: 1220 : 1|14:07:28.8577|| SolrConnectionUms, default: http://192.168.120.14:8983/solr, value: http://192.168.120.14:8983/solr. t Information: 1220 : 1|14:07:28.8587|| ApiLog, default: false, value: false. t Information: 1220 : 1|14:07:28.8587|| EmbeddedRceUrl, default: , value: . t Information: 1220 : 1|14:07:28.8587|| InstallMode, default: , value: . t Information: 1220 : 1|14:07:28.8587|| SamlRequestAddress, default: , value: . t Information: 1220 : 1|14:07:28.8587|| SamlTrustedIssuer, default: , value: . t Information: 1220 : 1|14:07:28.8587|| SamlLoginRedirect, default: , value: . t Information: 1220 : 1|14:07:28.8587|| NaturalLangSearch, default: false, value: True. t Information: 1220 : 1|14:07:28.8587|| OktaLoginField, default: , value: . t Information: 1220 : 1|14:07:28.8597|| AuthenticationTypes, default: , value: Native,PublicApiKey. t Information: 1220 : |OrabitWatcherBasic. Initialize. t Information: 1220 : |FillDictionaryCache. t Information: 1220 : |OrabitWatcherBasic trying to connect.. t Information: 1220 : |OrabitWatcherBasic connected. t Information: 1220 : 7|14:07:33.9107||OrabitWatcherBasic queue created tmd.cfg.in.53c352d3-5e26-4dd8-9f6d-09cd01e64301 t Information: 1220 : |GetSupportedOperators t Information: 1220 : |CacheTechReports. t Information: 1220 : 1|14:07:35.5827||& Cache update. Server (global) filled with timestamp 02:10:35.5817758. 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|14:07:35.6007||& Cache update. Server (global) filled with timestamp 02:10:35.5987539. types FriendlyNames, DatabaseSearchFieldData t Information: 1220 : |========================================================================== t Information: 1220 : |IMFX CORE SERVER APPLICATION START. t Information: 1220 : 1|14:07:36.2227||DLL VERSION: 2.5.0.2276. t Information: 1220 : 10|14:07:36.2247|| UmsDev, default: False, value: False. t Information: 1220 : 1|14:07:36.4067|| ApiLog, default: false, value: false. t Information: 1220 : |GetAppInfo t Information: 1220 : 12|14:07:52.4447|| db: TMDDEMO install mode: auth types: Native, PublicApiKey t Information: 1220 : |Oauth validating.. t Verbose: 1220 : |GrantResourceOwnerCredentials. t Verbose: 1220 : 12|14:07:54.3954||LoginUser. daniel, login type OAuth, encrypt password True t Information: 1220 : 12|14:07:54.3984||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 : 12|14:07:54.9034|| 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 : 12|14:07:54.9654||LoginUser. Adding history. User Id 342, result DANIEL, host t Verbose: 1220 : 12|14:07:54.9894||GrantResourceOwnerCredentials. Try login finished. Logged: True t Transfer: 1220 : 12|14:07:57.6264||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=1572271675190 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 12|14:07:57.6294|| user DANIEL. t Transfer: 1220 : 12|14:07:57.6294||api user: DANIEL t Information: 1220 : |V3Api.GetUserSettings t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 12|14:07:57.6704|| user DANIEL. t Transfer: 1220 : 12|14:07:59.2404||IsUserAuthenticated: /api/user-preferences?keys=personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch&_dc=1572271678961 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 12|14:07:59.2404|| user DANIEL. t Transfer: 1220 : 12|14:07:59.2404||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 : 12|14:07:59.2434|| user DANIEL. t Information: 1220 : |GetUserProfile. Id: 0 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 11|14:07:59.5144|| user DANIEL. t Transfer: 1220 : 21|14:08:04.2174||IsUserAuthenticated: /api/settings/user/startSearch?_dc=1572271683986 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 21|14:08:04.2174|| user DANIEL. t Transfer: 1220 : 21|14:08:04.2174||api user: DANIEL t Information: 1220 : |V3Api.GetUserSettings t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 21|14:08:04.2194|| user DANIEL. t Transfer: 1220 : 7|14:08:04.4264||IsUserAuthenticated: /api/settings/user/defaultSearch?_dc=1572271683981 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 7|14:08:04.4264|| user DANIEL. t Transfer: 1220 : 7|14:08:04.4264||api user: DANIEL t Information: 1220 : |V3Api.GetUserSettings t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 7|14:08:04.4264|| user DANIEL. t Transfer: 1220 : 21|14:08:04.8604||IsUserAuthenticated: /api/user-preferences?keys=consumer.recent.data&_dc=1572271684655 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 21|14:08:04.8614|| user DANIEL. t Transfer: 1220 : 21|14:08:04.8614||api user: DANIEL t Information: 1220 : |GetUserDataByKeys: consumer.recent.data t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 21|14:08:04.8614|| user DANIEL. t Transfer: 1220 : 20|14:08:04.9714||IsUserAuthenticated: /api/user-preferences?keys=adv.recent.searches.consumer&_dc=1572271684669 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 20|14:08:04.9714|| user DANIEL. t Transfer: 1220 : 20|14:08:04.9714||api user: DANIEL t Information: 1220 : |GetUserDataByKeys: adv.recent.searches.consumer t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 20|14:08:04.9714|| user DANIEL. t Transfer: 1220 : 11|14:08:08.0864||IsUserAuthenticated: /api/user-preferences?keys=color_schema&_dc=1572271687883 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 11|14:08:08.0864|| user DANIEL. t Transfer: 1220 : 11|14:08:08.0864||api user: DANIEL t Information: 1220 : |GetUserDataByKeys: color_schema t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 11|14:08:08.0874|| user DANIEL. t Transfer: 1220 : 11|14:08:08.1454||IsUserAuthenticated: /api/user-group-preferences?keys=logoImage&_dc=1572271687998 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 11|14:08:08.1454|| user DANIEL. t Transfer: 1220 : 11|14:08:08.1454||api user: DANIEL t Information: 1220 : |V3Api.GetUserSettings t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 11|14:08:08.1494|| user DANIEL. t Information: 1220 : |GetUserProfile. Id: 30000 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 12|14:08:08.3534|| user DANIEL. t Transfer: 1220 : 21|14:08:14.8304||IsUserAuthenticated: /api/user-preferences?keys=ums.default.route&_dc=1572271691981 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 21|14:08:14.8304|| user DANIEL. t Transfer: 1220 : 21|14:08:14.8304||api user: DANIEL t Information: 1220 : |GetUserDataByKeys: ums.default.route t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 21|14:08:14.8304|| user DANIEL. t Transfer: 1220 : 11|14:08:14.8344||IsUserAuthenticated: /api/user-preferences?keys=ums.default.route&_dc=1572271691985 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 11|14:08:14.8354|| user DANIEL. t Transfer: 1220 : 11|14:08:14.8354||api user: DANIEL t Information: 1220 : |GetUserDataByKeys: ums.default.route t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 11|14:08:14.8364|| user DANIEL. t Transfer: 1220 : 21|14:08:15.1819||IsUserAuthenticated: /api/user-preferences?keys=ums.default.route&_dc=1572271695046 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 21|14:08:15.1819|| user DANIEL. t Transfer: 1220 : 21|14:08:15.1819||api user: DANIEL t Information: 1220 : |GetUserDataByKeys: ums.default.route t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 21|14:08:15.1830|| user DANIEL. t Transfer: 1220 : 21|14:08:16.2993||IsUserAuthenticated: /api/user-preferences?keys=ums.accordion_states&_dc=1572271691987 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 21|14:08:16.2993|| user DANIEL. t Transfer: 1220 : 21|14:08:16.2993||api user: DANIEL t Information: 1220 : |GetUserDataByKeys: ums.accordion_states t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 21|14:08:16.3003|| user DANIEL. t Transfer: 1220 : 7|14:08:16.3033||IsUserAuthenticated: /api/user-preferences?keys=ums.splitter.dashboard.common&_dc=1572271691993 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 7|14:08:16.3033|| user DANIEL. t Transfer: 1220 : 7|14:08:16.3033||api user: DANIEL t Information: 1220 : |GetUserDataByKeys: ums.splitter.dashboard.common t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 7|14:08:16.3043|| user DANIEL. t Transfer: 1220 : 10|14:08:16.3173||IsUserAuthenticated: /api/user-preferences?_dc=1572271696231 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 10|14:08:16.3173|| user DANIEL. t Transfer: 1220 : 10|14:08:16.3173||api user: DANIEL t Verbose: 1220 : |StoreUserDataByKeys.. t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 10|14:08:16.4141|| user DANIEL. t Transfer: 1220 : 11|14:08:17.3076||IsUserAuthenticated: /api/user-preferences?keys=ums.splitter.dashboard.details&_dc=1572271697152 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 11|14:08:17.3086|| user DANIEL. t Transfer: 1220 : 11|14:08:17.3086||api user: DANIEL t Information: 1220 : |GetUserDataByKeys: ums.splitter.dashboard.details t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 11|14:08:17.3086|| user DANIEL. t Transfer: 1220 : 20|14:08:18.3936||IsUserAuthenticated: /api/user-preferences?_dc=1572271698338 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 20|14:08:18.3946|| user DANIEL. t Transfer: 1220 : 20|14:08:18.3946||api user: DANIEL t Verbose: 1220 : |StoreUserDataByKeys.. t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 20|14:08:18.3946|| user DANIEL. t Transfer: 1220 : 7|14:08:20.5601||IsUserAuthenticated: /api/user-preferences?_dc=1572271700517 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 7|14:08:20.5601|| user DANIEL. t Transfer: 1220 : 7|14:08:20.5611||api user: DANIEL t Verbose: 1220 : |StoreUserDataByKeys.. t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 7|14:08:20.5611|| user DANIEL. t Transfer: 1220 : 20|14:08:28.0512||IsUserAuthenticated: /api/settings/user/consumer?_dc=1572271707847 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 20|14:08:28.0512|| user DANIEL. t Transfer: 1220 : 20|14:08:28.0512||api user: DANIEL t Information: 1220 : |V3Api.GetUserSettings t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 20|14:08:28.0512|| user DANIEL. t Transfer: 1220 : 10|14:08:28.0522||IsUserAuthenticated: /api/user-preferences?keys=consumer.recent.data&_dc=1572271707892 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 10|14:08:28.0522|| user DANIEL. t Transfer: 1220 : 10|14:08:28.0522||api user: DANIEL t Information: 1220 : |GetUserDataByKeys: consumer.recent.data t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 10|14:08:28.0532|| user DANIEL. t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 21|14:08:28.1162|| user DANIEL. t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 21|14:08:28.1302|| user DANIEL. t Information: 1220 : 21|14:08:28.3012||SearchVersion SQL: select * from (select a.*, rownum rnum from ( select m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE ,(select UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(data2, 2000,1)) from tm_txt_obj where type_id=5021083 and pgm_rl_id=m.id and rownum=1) SYNOPSIS ,(select m_ctnr_loc || '^' || m_ctnr_id from tm_mis mis join tm_cfg_media_file_types t on t.id=mis.m_ctnr_fmt_id and t.imfx_disable_playback<>1 where mis.pgm_parent_id=m.id /*and mis.m_ctnr_fmt_id in (2,4,54,52,98,57,62)*/ and mis.item_type>0 and mis.mi_deleted=0 and mis.media_type=100 and not mis.m_ctnr_id is null and mis.m_ctnr_loc is not null and rownum=1) PROXY_MEDIA from tmddba.tm_pg_rl m left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id,(select /*+ cardinality(4) */ rownum rn, column_value id from table(:ids)) ids where item_type>0 and rl_deleted=0 and m.id = ids.id order by ids.rn ) a where rownum <= 10000) r where rnum >=1 order by rnum t Information: 1220 : |Running version search. User: 342 Simple Search: game of thrones Trying to use Solr Search... Solr completed in: 177ms. Returned lines: 56 Running Oracle search. Oracle version search timing: 250ms. SQL run: select * from (select a.*, rownum rnum from ( select m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE ,(select UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(data2, 2000,1)) from tm_txt_obj where type_id=5021083 and pgm_rl_id=m.id and rownum=1) SYNOPSIS ,(select m_ctnr_loc || '^' || m_ctnr_id from tm_mis mis join tm_cfg_media_file_types t on t.id=mis.m_ctnr_fmt_id and t.imfx_disable_playback<>1 where mis.pgm_parent_id=m.id /*and mis.m_ctnr_fmt_id in (2,4,54,52,98,57,62)*/ and mis.item_type>0 and mis.mi_deleted=0 and mis.media_type=100 and not mis.m_ctnr_id is null and mis.m_ctnr_loc is not null and rownum=1) PROXY_MEDIA from tmddba.tm_pg_rl m left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id,(select /*+ cardinality(4) */ rownum rn, column_value id from table(:ids)) ids where item_type>0 and rl_deleted=0 and m.id = ids.id order by ids.rn ) a where rownum <= 10000) r where rnum >=1 order by rnum t Verbose: 1220 : 21|14:08:28.5542||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Game of Thrones - Blinkbox-HD.mp4 subfolder t Verbose: 1220 : 21|14:08:28.5542|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Game of Thrones - Blinkbox-HD.mp4 t Verbose: 1220 : 21|14:08:28.5542||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Game of Thrones - Blinkbox-HD.mp4 t Verbose: 1220 : 21|14:08:28.5562||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gots0ep3us.mpd subfolder t Verbose: 1220 : 21|14:08:28.5562|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gots0ep3us.mpd t Verbose: 1220 : 21|14:08:28.5562||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/gots0ep3us.mpd t Verbose: 1220 : 21|14:08:28.5562||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gots0ep14us.mpd subfolder t Verbose: 1220 : 21|14:08:28.5562|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gots0ep14us.mpd t Verbose: 1220 : 21|14:08:28.5562||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/gots0ep14us.mpd t Verbose: 1220 : 21|14:08:28.5562||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gots2ep1.mpd subfolder t Verbose: 1220 : 21|14:08:28.5562|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gots2ep1.mpd t Verbose: 1220 : 21|14:08:28.5562||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/gots2ep1.mpd t Verbose: 1220 : 21|14:08:28.5572||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gots0ep2us.mpd subfolder t Verbose: 1220 : 21|14:08:28.5572|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gots0ep2us.mpd t Verbose: 1220 : 21|14:08:28.5572||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/gots0ep2us.mpd t Verbose: 1220 : 21|14:08:28.5572||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gotspecialspromo20seccharacter.mp4 subfolder t Verbose: 1220 : 21|14:08:28.5572|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gotspecialspromo20seccharacter.mp4 t Verbose: 1220 : 21|14:08:28.5572||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/gotspecialspromo20seccharacter.mp4 t Verbose: 1220 : 21|14:08:28.5572||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gots0ep4us.mpd subfolder t Verbose: 1220 : 21|14:08:28.5572|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gots0ep4us.mpd t Verbose: 1220 : 21|14:08:28.5572||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/gots0ep4us.mpd t Verbose: 1220 : 21|14:08:28.5572||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gots0ep5us.mpd subfolder t Verbose: 1220 : 21|14:08:28.5572|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gots0ep5us.mpd t Verbose: 1220 : 21|14:08:28.5572||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/gots0ep5us.mpd t Verbose: 1220 : 21|14:08:28.5582||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gots0ep6us.mpd subfolder t Verbose: 1220 : 21|14:08:28.5582|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gots0ep6us.mpd t Verbose: 1220 : 21|14:08:28.5582||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/gots0ep6us.mpd t Verbose: 1220 : 21|14:08:28.5582||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gots0ep7us.mpd subfolder t Verbose: 1220 : 21|14:08:28.5582|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gots0ep7us.mpd t Verbose: 1220 : 21|14:08:28.5582||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/gots0ep7us.mpd t Verbose: 1220 : 21|14:08:28.5582||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gots0ep8us.mpd subfolder t Verbose: 1220 : 21|14:08:28.5582|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gots0ep8us.mpd t Verbose: 1220 : 21|14:08:28.5582||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/gots0ep8us.mpd t Verbose: 1220 : 21|14:08:28.5582||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gots0ep9us.mpd subfolder t Verbose: 1220 : 21|14:08:28.5582|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gots0ep9us.mpd t Verbose: 1220 : 21|14:08:28.5582||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/gots0ep9us.mpd t Verbose: 1220 : 21|14:08:28.5582||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gots0ep10us.mpd subfolder t Verbose: 1220 : 21|14:08:28.5592|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gots0ep10us.mpd t Verbose: 1220 : 21|14:08:28.5592||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/gots0ep10us.mpd t Verbose: 1220 : 21|14:08:28.5592||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gots0ep11us.mpd subfolder t Verbose: 1220 : 21|14:08:28.5592|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gots0ep11us.mpd t Verbose: 1220 : 21|14:08:28.5592||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/gots0ep11us.mpd t Verbose: 1220 : 21|14:08:28.5592||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gots0ep12us.mpd subfolder t Verbose: 1220 : 21|14:08:28.5592|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gots0ep12us.mpd t Verbose: 1220 : 21|14:08:28.5592||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/gots0ep12us.mpd t Verbose: 1220 : 21|14:08:28.5592||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gots0ep13us.mpd subfolder t Verbose: 1220 : 21|14:08:28.5592|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gots0ep13us.mpd t Verbose: 1220 : 21|14:08:28.5592||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/gots0ep13us.mpd t Verbose: 1220 : 21|14:08:28.5592||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gots1ep1uk.mpd subfolder t Verbose: 1220 : 21|14:08:28.5592|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gots1ep1uk.mpd t Verbose: 1220 : 21|14:08:28.5592||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/gots1ep1uk.mpd t Verbose: 1220 : 21|14:08:28.5602||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gots1ep2us.mpd subfolder t Verbose: 1220 : 21|14:08:28.5602|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gots1ep2us.mpd t Verbose: 1220 : 21|14:08:28.5602||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/gots1ep2us.mpd t Verbose: 1220 : 21|14:08:28.5602||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gots1ep3us.mpd subfolder t Verbose: 1220 : 21|14:08:28.5602|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gots1ep3us.mpd t Verbose: 1220 : 21|14:08:28.5602||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/gots1ep3us.mpd t Verbose: 1220 : 21|14:08:28.5602||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gots1ep4us.mp4 subfolder t Verbose: 1220 : 21|14:08:28.5602|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gots1ep4us.mp4 t Verbose: 1220 : 21|14:08:28.5602||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/gots1ep4us.mp4 t Verbose: 1220 : 21|14:08:28.5602||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gots1ep5us.mp4 subfolder t Verbose: 1220 : 21|14:08:28.5602|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gots1ep5us.mp4 t Verbose: 1220 : 21|14:08:28.5602||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/gots1ep5us.mp4 t Verbose: 1220 : 21|14:08:28.5602||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gots1ep6us.mp4 subfolder t Verbose: 1220 : 21|14:08:28.5612|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gots1ep6us.mp4 t Verbose: 1220 : 21|14:08:28.5612||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/gots1ep6us.mp4 t Verbose: 1220 : 21|14:08:28.5612||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gots1ep7us.mp4 subfolder t Verbose: 1220 : 21|14:08:28.5612|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gots1ep7us.mp4 t Verbose: 1220 : 21|14:08:28.5612||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/gots1ep7us.mp4 t Verbose: 1220 : 21|14:08:28.5612||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gots1ep8us.mpd subfolder t Verbose: 1220 : 21|14:08:28.5612|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gots1ep8us.mpd t Verbose: 1220 : 21|14:08:28.5612||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/gots1ep8us.mpd t Verbose: 1220 : 21|14:08:28.5612||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gots1ep9us.mpd subfolder t Verbose: 1220 : 21|14:08:28.5612|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gots1ep9us.mpd t Verbose: 1220 : 21|14:08:28.5622||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/gots1ep9us.mpd t Transfer: 1220 : 20|14:08:28.7702||IsUserAuthenticated: /api/user-preferences?keys=adv.recent.searches.consumer&_dc=1572271708646 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 20|14:08:28.7702|| user DANIEL. t Transfer: 1220 : 20|14:08:28.7712||api user: DANIEL t Information: 1220 : |GetUserDataByKeys: adv.recent.searches.consumer t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 20|14:08:28.7712|| user DANIEL. t Transfer: 1220 : 29|14:08:29.5512||IsUserAuthenticated: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1572271709292 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 29|14:08:29.5512|| user DANIEL. t Transfer: 1220 : 29|14:08:29.5512||api user: DANIEL t Information: 1220 : |V3Api.GetUserSettings t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 29|14:08:29.5522|| user DANIEL. t Transfer: 1220 : 20|14:08:29.6032||IsUserAuthenticated: /api/versionvideo/278628?_dc=1572271709335 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 20|14:08:29.6032|| user DANIEL. t Transfer: 1220 : 20|14:08:29.6032||api user: DANIEL t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 20|14:08:29.6152|| user DANIEL. t Verbose: 1220 : 20|14:08:29.9770||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Game of Thrones - Blinkbox-HD.mp4 subfolder t Verbose: 1220 : 20|14:08:29.9770|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Game of Thrones - Blinkbox-HD.mp4 t Verbose: 1220 : 20|14:08:29.9770||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Game of Thrones - Blinkbox-HD.mp4 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 20|14:08:29.9770|| user DANIEL. t Transfer: 1220 : 25|14:08:32.3532||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1572271712098 t Transfer: 1220 : 28|14:08:32.3532||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1572271712122 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 28|14:08:32.3532|| user DANIEL. t Transfer: 1220 : 28|14:08:32.3542||api user: DANIEL t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 25|14:08:32.3542|| user DANIEL. t Transfer: 1220 : 25|14:08:32.3542||api user: DANIEL t Transfer: 1220 : 12|14:08:32.3562||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1572271712058 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 12|14:08:32.3562|| user DANIEL. t Transfer: 1220 : 12|14:08:32.3572||api user: DANIEL t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 28|14:08:32.3572|| user DANIEL. t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 12|14:08:32.3572|| user DANIEL. t Transfer: 1220 : 20|14:08:32.3632||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1572271712106 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 20|14:08:32.3632|| user DANIEL. t Transfer: 1220 : 20|14:08:32.3642||api user: DANIEL t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 20|14:08:32.3642|| user DANIEL. t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 25|14:08:32.3682|| user DANIEL. t Transfer: 1220 : 26|14:08:33.3662||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1572271712132 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 26|14:08:33.3662|| user DANIEL. t Transfer: 1220 : 26|14:08:33.3662||api user: DANIEL t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 26|14:08:33.3672|| user DANIEL. t Transfer: 1220 : 29|14:08:35.3662||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1572271712047 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 29|14:08:35.3672|| user DANIEL. t Transfer: 1220 : 29|14:08:35.3672||api user: DANIEL t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 29|14:08:35.3672|| user DANIEL. t Transfer: 1220 : 21|14:08:37.8662||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1572271712115 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 21|14:08:37.8672|| user DANIEL. t Transfer: 1220 : 21|14:08:37.8672||api user: DANIEL t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 21|14:08:37.8672|| user DANIEL. t Transfer: 1220 : 34|14:08:39.3912||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1572271712212 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 34|14:08:39.3912|| user DANIEL. t Transfer: 1220 : 34|14:08:39.3912||api user: DANIEL t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 34|14:08:39.3922|| user DANIEL. t Transfer: 1220 : 35|14:08:40.3932||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1572271712243 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 35|14:08:40.3932|| user DANIEL. t Transfer: 1220 : 35|14:08:40.3932||api user: DANIEL t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 35|14:08:40.3943|| user DANIEL. t Transfer: 1220 : 11|14:08:40.6452||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1572271712237 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 11|14:08:40.6452|| user DANIEL. t Transfer: 1220 : 11|14:08:40.6452||api user: DANIEL t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 11|14:08:40.6463|| user DANIEL. t Transfer: 1220 : 20|14:08:40.7532||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1572271712031 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 20|14:08:40.7532|| user DANIEL. t Transfer: 1220 : 20|14:08:40.7532||api user: DANIEL t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 20|14:08:40.7542|| user DANIEL. t Transfer: 1220 : 10|14:08:40.7612||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1572271712073 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 10|14:08:40.7622|| user DANIEL. t Transfer: 1220 : 10|14:08:40.7622||api user: DANIEL t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 10|14:08:40.7622|| user DANIEL. t Transfer: 1220 : 29|14:08:40.7812||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1572271712268 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 29|14:08:40.7812|| user DANIEL. t Transfer: 1220 : 29|14:08:40.7812||api user: DANIEL t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 29|14:08:40.7822|| user DANIEL. t Transfer: 1220 : 27|14:08:41.3773||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1572271712139 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 27|14:08:41.3773|| user DANIEL. t Transfer: 1220 : 27|14:08:41.3773||api user: DANIEL t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 27|14:08:41.3783|| user DANIEL. t Transfer: 1220 : 21|14:08:41.3792||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1572271712275 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 21|14:08:41.3792|| user DANIEL. t Transfer: 1220 : 21|14:08:41.3792||api user: DANIEL t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 21|14:08:41.3802|| user DANIEL. t Transfer: 1220 : 7|14:08:42.3763||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1572271712086 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 7|14:08:42.3772|| user DANIEL. t Transfer: 1220 : 7|14:08:42.3772||api user: DANIEL t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 7|14:08:42.3772|| user DANIEL. t Transfer: 1220 : 40|14:08:43.3732||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1572271712204 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 40|14:08:43.3732|| user DANIEL. t Transfer: 1220 : 40|14:08:43.3732||api user: DANIEL t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 40|14:08:43.3742|| user DANIEL. t Transfer: 1220 : 42|14:08:45.3792||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1572271712185 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 42|14:08:45.3792|| user DANIEL. t Transfer: 1220 : 42|14:08:45.3792||api user: DANIEL t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 42|14:08:45.3803|| user DANIEL. t Transfer: 1220 : 44|14:08:47.3679||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1572271712220 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 44|14:08:47.3679|| user DANIEL. t Transfer: 1220 : 44|14:08:47.3679||api user: DANIEL t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 44|14:08:47.3689|| user DANIEL. t Transfer: 1220 : 46|14:08:49.3719||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1572271712226 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 46|14:08:49.3719|| user DANIEL. t Transfer: 1220 : 46|14:08:49.3719||api user: DANIEL t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 46|14:08:49.3729|| user DANIEL. t Transfer: 1220 : 48|14:08:51.3719||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1572271712249 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 48|14:08:51.3719|| user DANIEL. t Transfer: 1220 : 48|14:08:51.3729||api user: DANIEL t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 48|14:08:51.3729|| user DANIEL. t Transfer: 1220 : 50|14:09:05.8728||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1572271712257 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 50|14:09:05.8728|| user DANIEL. t Transfer: 1220 : 50|14:09:05.8728||api user: DANIEL t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 50|14:09:05.8728|| user DANIEL. t Transfer: 1220 : 52|14:09:12.8728||IsUserAuthenticated: /api/versionvideo/278628?_dc=1572271713022 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 52|14:09:12.8739|| user DANIEL. t Transfer: 1220 : 52|14:09:12.8739||api user: DANIEL t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 52|14:09:12.8748|| user DANIEL. t Verbose: 1220 : 52|14:09:12.8948||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Game of Thrones - Blinkbox-HD.mp4 subfolder t Verbose: 1220 : 52|14:09:12.8948|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Game of Thrones - Blinkbox-HD.mp4 t Verbose: 1220 : 52|14:09:12.8948||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Game of Thrones - Blinkbox-HD.mp4 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 52|14:09:12.8958|| user DANIEL. t Transfer: 1220 : 12|14:09:12.9128||IsUserAuthenticated: /api/versionvideo/278632?_dc=1572271717108 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 12|14:09:12.9138|| user DANIEL. t Transfer: 1220 : 12|14:09:12.9138||api user: DANIEL t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 12|14:09:12.9149|| user DANIEL. t Verbose: 1220 : 12|14:09:13.0219||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gots0ep3us.mpd subfolder t Verbose: 1220 : 12|14:09:13.0219|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gots0ep3us.mpd t Verbose: 1220 : 12|14:09:13.0219||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/gots0ep3us.mpd t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 12|14:09:13.0229|| user DANIEL. t Transfer: 1220 : 10|14:09:13.0649||IsUserAuthenticated: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1572271717089 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 10|14:09:13.0649|| user DANIEL. t Transfer: 1220 : 10|14:09:13.0649||api user: DANIEL t Information: 1220 : |V3Api.GetUserSettings t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 10|14:09:13.0659|| user DANIEL. t Transfer: 1220 : 51|14:09:14.5836||IsUserAuthenticated: /api/versionvideo/278632?_dc=1572271754542 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 51|14:09:14.5836|| user DANIEL. t Transfer: 1220 : 51|14:09:14.5836||api user: DANIEL t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 51|14:09:14.5846|| user DANIEL. t Verbose: 1220 : 51|14:09:14.6155||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gots0ep3us.mpd subfolder t Verbose: 1220 : 51|14:09:14.6155|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gots0ep3us.mpd t Verbose: 1220 : 51|14:09:14.6155||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/gots0ep3us.mpd t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 51|14:09:14.6166|| user DANIEL. t Transfer: 1220 : 27|14:09:15.4036||IsUserAuthenticated: /api/versionvideo/278628?_dc=1572271755373 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 27|14:09:15.4046|| user DANIEL. t Transfer: 1220 : 27|14:09:15.4046||api user: DANIEL t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 27|14:09:15.4046|| user DANIEL. t Verbose: 1220 : 27|14:09:15.5146||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Game of Thrones - Blinkbox-HD.mp4 subfolder t Verbose: 1220 : 27|14:09:15.5156|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Game of Thrones - Blinkbox-HD.mp4 t Verbose: 1220 : 27|14:09:15.5156||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Game of Thrones - Blinkbox-HD.mp4 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 27|14:09:15.5156|| user DANIEL. t Transfer: 1220 : 46|14:09:16.3642||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1572271756330 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 46|14:09:16.3642|| user DANIEL. t Transfer: 1220 : 46|14:09:16.3642||api user: DANIEL t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 46|14:09:16.3652|| user DANIEL. t Transfer: 1220 : 34|14:09:16.3731||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1572271756338 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 34|14:09:16.3731|| user DANIEL. t Transfer: 1220 : 34|14:09:16.3731||api user: DANIEL t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 34|14:09:16.3742|| user DANIEL. t Transfer: 1220 : 12|14:09:16.3822||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1572271756356 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 12|14:09:16.3822|| user DANIEL. t Transfer: 1220 : 12|14:09:16.3832||api user: DANIEL t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 12|14:09:16.3832|| user DANIEL. t Transfer: 1220 : 29|14:09:16.3912||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1572271756344 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 29|14:09:16.3912|| user DANIEL. t Transfer: 1220 : 29|14:09:16.3912||api user: DANIEL t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 29|14:09:16.3922|| user DANIEL. t Transfer: 1220 : 25|14:09:16.4032||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1572271756368 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 25|14:09:16.4041|| user DANIEL. t Transfer: 1220 : 25|14:09:16.4041||api user: DANIEL t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 25|14:09:16.4041|| user DANIEL. t Transfer: 1220 : 10|14:09:16.4072||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1572271756360 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 10|14:09:16.4081|| user DANIEL. t Transfer: 1220 : 10|14:09:16.4081||api user: DANIEL t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 10|14:09:16.4081|| user DANIEL. t Transfer: 1220 : 39|14:09:16.4231||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1572271756376 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 39|14:09:16.4231|| user DANIEL. t Transfer: 1220 : 39|14:09:16.4231||api user: DANIEL t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 39|14:09:16.4231|| user DANIEL. t Transfer: 1220 : 28|14:09:16.4251||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1572271756382 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 28|14:09:16.4251|| user DANIEL. t Transfer: 1220 : 28|14:09:16.4251||api user: DANIEL t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 28|14:09:16.4251|| user DANIEL. t Transfer: 1220 : 38|14:09:16.4332||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1572271756389 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 38|14:09:16.4342|| user DANIEL. t Transfer: 1220 : 38|14:09:16.4342||api user: DANIEL t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 38|14:09:16.4342|| user DANIEL. t Transfer: 1220 : 43|14:09:16.4351||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1572271756397 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 43|14:09:16.4351|| user DANIEL. t Transfer: 1220 : 43|14:09:16.4361||api user: DANIEL t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 43|14:09:16.4361|| user DANIEL. t Transfer: 1220 : 47|14:09:16.5771||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1572271756348 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 47|14:09:16.5771|| user DANIEL. t Transfer: 1220 : 47|14:09:16.5771||api user: DANIEL t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 47|14:09:16.5782|| user DANIEL. t Transfer: 1220 : 7|14:09:18.5141||IsUserAuthenticated: /api/settings/group/0?_dc=1572271758440 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 7|14:09:18.5151|| user DANIEL. t Transfer: 1220 : 7|14:09:18.5151||api user: DANIEL t Information: 1220 : |V3Api.GetSettingsGroup t Transfer: 1220 : 42|14:09:18.9912||IsUserAuthenticated: /api/view/searches/Job?_dc=1572271758927 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 42|14:09:18.9912|| user DANIEL. t Transfer: 1220 : 42|14:09:18.9912||api user: DANIEL t Information: 1220 : |GetSavedSearchNames. search type Job. t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 42|14:09:18.9912|| user DANIEL. t Transfer: 1220 : 27|14:09:28.3136||IsUserAuthenticated: /api/v3/layout/default/3?_dc=1572271768107 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 27|14:09:28.3146|| user DANIEL. t Transfer: 1220 : 27|14:09:28.3146||api user: DANIEL t Information: 1220 : |LoadDefaultDashboard. t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 27|14:09:28.3186|| user DANIEL. t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 27|14:09:28.4006|| user DANIEL. t Transfer: 1220 : 10|14:09:47.9903||IsUserAuthenticated: /api/misr/chart?_dc=1572271787914 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 10|14:09:47.9903|| user DANIEL. t Transfer: 1220 : 10|14:09:47.9913||api user: DANIEL t Transfer: 1220 : 28|14:09:54.3757||IsUserAuthenticated: /api/misr/chart?_dc=1572271794292 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 28|14:09:54.3767|| user DANIEL. t Transfer: 1220 : 28|14:09:54.3767||api user: DANIEL t Transfer: 1220 : 10|14:10:30.0641||IsUserAuthenticated: /api/misr/chart?_dc=1572271829725 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 10|14:10:30.0641|| user DANIEL. t Transfer: 1220 : 10|14:10:30.0641||api user: DANIEL t Information: 1220 : |GetAppInfo t Information: 1220 : 32|14:13:00.8468|| db: TMDDEMO install mode: auth types: Native, PublicApiKey t Transfer: 1220 : 31|14:13:01.0548||IsUserAuthenticated: /api/search/workflow?_dc=1572271980836 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 31|14:13:01.0548|| user DANIEL. t Transfer: 1220 : 31|14:13:01.0548||api user: DANIEL t Information: 1220 : |V3Api.SearchWorkflows t Information: 1220 : |V3Api.SearchGeneric t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 31|14:13:01.1258|| user DANIEL. t Information: 1220 : 31|14:13:01.1538||SearchJob SQL: select * from (select a.*, rownum rnum from ( select /*+ INDEX(j JB_CMBST_IDX) */ j.* ,p.pname ,mi.tv_std ,mi.MIID1, mi.MIID2, mi.MIID3, mi.VERSIONID1, mi.VERSIONID2, mi.PROGID1, mi.PROGID2 ,txd.NEXT_TX_DATE FROM tm_mjob j left join tm_mjob_pset p on j.j_sched_indx=p.id left join (select j_id, TMD_str_agg(distinct miid1) MIID1, TMD_str_agg(distinct miid2) MIID2, TMD_str_agg(distinct miid3) MIID3, TMD_str_agg(distinct versionid1) VERSIONID1, TMD_str_agg(distinct versionid2) VERSIONID2, TMD_str_agg(distinct progid1) PROGID1, TMD_str_agg(distinct progid2) PROGID2, TMD_str_agg(distinct m.tv_std) TV_STD from tm_mis m, tm_mtsk_it i where m.id=i.mi_id and i.src_dest in (2,3) group by j_id) mi on mi.j_id=j.id LEFT JOIN ( SELECT it.j_id, min(sch.tx_tm_st) NEXT_TX_DATE FROM TM_MTSK_IT it, TM_MIS m, hr_sched sch WHERE m.id = it.MI_ID AND (sch.prod_num = m.PROGID2 OR sch.prod_num = (select rl.VERSIONID1 from TM_PG_RL rl where rl.ID = m.PGM_PARENT_ID)) AND sch.tx_tm_st > sysdate GROUP BY J_ID) txd ON txd.j_id = j.id where 1=1 and j.cmb_stat not in (15,18,23) AND j.J_CLI_CODE in ('ATP' , 'NAA' , 'SFP1' , 'SFP2' , 'TECHM' , 'TMD' , 'YLE TV1') order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Information: 1220 : 31|14:13:01.5081|| jobs returned 50, searched in 00:00:00.3634895 t Information: 1220 : 31|14:13:01.7111||TechReports is not found. ID: 1300. t Information: 1220 : 31|14:13:01.7111||TechReports is not found. ID: 17. t Information: 1220 : 31|14:13:01.7111||TechReports is not found. ID: 96. t Information: 1220 : 31|14:13:01.7111||TechReports is not found. ID: 41. t Information: 1220 : 31|14:13:01.7111||TechReports is not found. ID: 61. t Information: 1220 : 31|14:13:01.7111||TechReports is not found. ID: 27. t Information: 1220 : 31|14:13:01.7111||TechReports is not found. ID: 252. t Information: 1220 : 31|14:13:01.7111||TechReports is not found. ID: 116. t Information: 1220 : 31|14:13:01.7111||TechReports is not found. ID: 672. t Information: 1220 : 31|14:13:01.7111||TechReports is not found. ID: 1497. t Information: 1220 : 31|14:13:01.7111||TechReports is not found. ID: 0. t Information: 1220 : 31|14:13:01.7111||TechReports is not found. ID: 673. t Information: 1220 : 31|14:13:01.7111||TechReports is not found. ID: 1633. t Information: 1220 : 31|14:13:01.7111||TechReports is not found. ID: 552. t Information: 1220 : 31|14:13:01.7111||TechReports is not found. ID: 1301. t Information: 1220 : 31|14:13:01.7111|| tasks returned 50, searched in 00:00:00.2066364 t Information: 1220 : |Oauth validating.. t Verbose: 1220 : |GrantResourceOwnerCredentials. t Verbose: 1220 : 31|14:13:04.0794||LoginUser. consumer, login type OAuth, encrypt password True t Information: 1220 : 31|14:13:04.0794||TryLoginUser. consumer, login type OAuth, check password True, check hash False, encrypt password True, load user data True t Information: 1220 : |InitialiseLogin t Information: 1220 : 31|14:13:04.1054|| oauth token 00000000-0000-0000-0000-000000000000 t Information: 1220 : |TryLoginUser. Logged in.. t Verbose: 1220 : 31|14:13:04.1064||LoginUser. Adding history. User Id 402, result CONSUMER, host t Verbose: 1220 : 31|14:13:04.1144||GrantResourceOwnerCredentials. Try login finished. Logged: True t Transfer: 1220 : 31|14:13:04.1884||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=1572271984062 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 31|14:13:04.1884|| user CONSUMER. t Transfer: 1220 : 31|14:13:04.1884||api user: CONSUMER t Information: 1220 : |V3Api.GetUserSettings t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 31|14:13:04.1894|| user CONSUMER. t Transfer: 1220 : 40|14:13:04.7114||IsUserAuthenticated: /api/user-preferences?keys=personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch&_dc=1572271984170 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 40|14:13:04.7114|| user CONSUMER. t Transfer: 1220 : 40|14:13:04.7114||api user: CONSUMER 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 : 40|14:13:04.7114|| user CONSUMER. t Information: 1220 : |GetUserProfile. Id: 0 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 33|14:13:04.7895|| user CONSUMER. t Transfer: 1220 : 32|14:13:05.2125||IsUserAuthenticated: /api/settings/user/startSearch?_dc=1572271985110 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 32|14:13:05.2135|| user CONSUMER. t Transfer: 1220 : 32|14:13:05.2135||api user: CONSUMER t Information: 1220 : |V3Api.GetUserSettings t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 32|14:13:05.2135|| user CONSUMER. t Transfer: 1220 : 31|14:13:05.2185||IsUserAuthenticated: /api/settings/user/defaultSearch?_dc=1572271985109 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 31|14:13:05.2185|| user CONSUMER. t Transfer: 1220 : 31|14:13:05.2185||api user: CONSUMER t Information: 1220 : |V3Api.GetUserSettings t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 31|14:13:05.2195|| user CONSUMER. t Transfer: 1220 : 40|14:13:05.3575||IsUserAuthenticated: /api/user-preferences?keys=consumer.recent.data&_dc=1572271985251 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 40|14:13:05.3575|| user CONSUMER. t Transfer: 1220 : 40|14:13:05.3575||api user: CONSUMER t Information: 1220 : |GetUserDataByKeys: consumer.recent.data t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 40|14:13:05.3585|| user CONSUMER. t Transfer: 1220 : 40|14:13:05.5076||IsUserAuthenticated: /api/user-preferences?keys=adv.recent.searches.consumer&_dc=1572271985346 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 40|14:13:05.5076|| user CONSUMER. t Transfer: 1220 : 40|14:13:05.5076||api user: CONSUMER t Information: 1220 : |GetUserDataByKeys: adv.recent.searches.consumer t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 40|14:13:05.5076|| user CONSUMER. t Transfer: 1220 : 32|14:13:08.7736||IsUserAuthenticated: /api/v3/config/servicexml/types?_dc=1572271988661 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 32|14:13:08.7736|| user CONSUMER. t Transfer: 1220 : 32|14:13:08.7736||api user: CONSUMER t Transfer: 1220 : 33|14:13:08.9056||IsUserAuthenticated: /api/settings/groups/?_dc=1572271988788 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 33|14:13:08.9066|| user CONSUMER. t Transfer: 1220 : 33|14:13:08.9066||api user: CONSUMER t Information: 1220 : |V3Api.GetSettingsGroupsNames t Transfer: 1220 : 33|14:13:11.1820||IsUserAuthenticated: /api/settings/group/0?_dc=1572271991095 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 33|14:13:11.1820|| user CONSUMER. t Transfer: 1220 : 33|14:13:11.1820||api user: CONSUMER t Information: 1220 : |V3Api.GetSettingsGroup t Transfer: 1220 : 46|14:13:11.1977||IsUserAuthenticated: /api/settings/group/0?_dc=1572271991100 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 46|14:13:11.1977|| user CONSUMER. t Transfer: 1220 : 46|14:13:11.1977||api user: CONSUMER t Information: 1220 : |V3Api.GetSettingsGroup t Transfer: 1220 : 33|14:13:11.2133||IsUserAuthenticated: /api/settings/group/0?_dc=1572271991093 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 33|14:13:11.2133|| user CONSUMER. t Transfer: 1220 : 33|14:13:11.2133||api user: CONSUMER t Information: 1220 : |V3Api.GetSettingsGroup t Transfer: 1220 : 40|14:13:15.9325||IsUserAuthenticated: /api/search/workflow?_dc=1572271995841 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 40|14:13:15.9335|| user DANIEL. t Transfer: 1220 : 40|14:13:15.9335||api user: DANIEL t Information: 1220 : |V3Api.SearchWorkflows t Information: 1220 : |V3Api.SearchGeneric t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 40|14:13:15.9345|| user DANIEL. t Information: 1220 : 40|14:13:15.9395||SearchJob SQL: select * from (select a.*, rownum rnum from ( select /*+ INDEX(j JB_CMBST_IDX) */ j.* ,p.pname ,mi.tv_std ,mi.MIID1, mi.MIID2, mi.MIID3, mi.VERSIONID1, mi.VERSIONID2, mi.PROGID1, mi.PROGID2 ,txd.NEXT_TX_DATE FROM tm_mjob j left join tm_mjob_pset p on j.j_sched_indx=p.id left join (select j_id, TMD_str_agg(distinct miid1) MIID1, TMD_str_agg(distinct miid2) MIID2, TMD_str_agg(distinct miid3) MIID3, TMD_str_agg(distinct versionid1) VERSIONID1, TMD_str_agg(distinct versionid2) VERSIONID2, TMD_str_agg(distinct progid1) PROGID1, TMD_str_agg(distinct progid2) PROGID2, TMD_str_agg(distinct m.tv_std) TV_STD from tm_mis m, tm_mtsk_it i where m.id=i.mi_id and i.src_dest in (2,3) group by j_id) mi on mi.j_id=j.id LEFT JOIN ( SELECT it.j_id, min(sch.tx_tm_st) NEXT_TX_DATE FROM TM_MTSK_IT it, TM_MIS m, hr_sched sch WHERE m.id = it.MI_ID AND (sch.prod_num = m.PROGID2 OR sch.prod_num = (select rl.VERSIONID1 from TM_PG_RL rl where rl.ID = m.PGM_PARENT_ID)) AND sch.tx_tm_st > sysdate GROUP BY J_ID) txd ON txd.j_id = j.id where 1=1 and j.cmb_stat not in (15,18,23) AND j.J_CLI_CODE in ('ATP' , 'NAA' , 'SFP1' , 'SFP2' , 'TECHM' , 'TMD' , 'YLE TV1') order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Information: 1220 : 40|14:13:15.9926|| jobs returned 50, searched in 00:00:00.0527415 t Information: 1220 : 40|14:13:16.0735||TechReports is not found. ID: 1300. t Information: 1220 : 40|14:13:16.0735||TechReports is not found. ID: 17. t Information: 1220 : 40|14:13:16.0735||TechReports is not found. ID: 96. t Information: 1220 : 40|14:13:16.0735||TechReports is not found. ID: 41. t Information: 1220 : 40|14:13:16.0735||TechReports is not found. ID: 61. t Information: 1220 : 40|14:13:16.0735||TechReports is not found. ID: 27. t Information: 1220 : 40|14:13:16.0735||TechReports is not found. ID: 252. t Information: 1220 : 40|14:13:16.0735||TechReports is not found. ID: 116. t Information: 1220 : 40|14:13:16.0745||TechReports is not found. ID: 672. t Information: 1220 : 40|14:13:16.0745||TechReports is not found. ID: 1497. t Information: 1220 : 40|14:13:16.0745||TechReports is not found. ID: 0. t Information: 1220 : 40|14:13:16.0745||TechReports is not found. ID: 673. t Information: 1220 : 40|14:13:16.0745||TechReports is not found. ID: 1633. t Information: 1220 : 40|14:13:16.0745||TechReports is not found. ID: 552. t Information: 1220 : 40|14:13:16.0745||TechReports is not found. ID: 1301. t Information: 1220 : 40|14:13:16.0755|| tasks returned 50, searched in 00:00:00.0827861 t Information: 1220 : |GetAppInfo t Information: 1220 : 40|14:13:23.3457|| db: TMDDEMO install mode: auth types: Native, PublicApiKey t Transfer: 1220 : 21|14:13:24.4937||IsUserAuthenticated: /api/view/searches/Job?_dc=1572272004394 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 21|14:13:24.4937|| user CONSUMER. t Transfer: 1220 : 21|14:13:24.4937||api user: CONSUMER t Information: 1220 : |GetSavedSearchNames. search type Job. t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 21|14:13:24.4947|| user CONSUMER. t Transfer: 1220 : 46|14:13:26.5200||IsUserAuthenticated: /api/v3/layout/default/3?_dc=1572272006411 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 46|14:13:26.5200|| user CONSUMER. t Transfer: 1220 : 46|14:13:26.5200||api user: CONSUMER t Information: 1220 : |LoadDefaultDashboard. t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 46|14:13:26.5210|| user CONSUMER. t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 46|14:13:26.5450|| user CONSUMER. t Transfer: 1220 : 46|14:13:26.6915||IsUserAuthenticated: /api/view/search/Job/1293?_dc=1572272006545 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 46|14:13:26.6925|| user CONSUMER. t Transfer: 1220 : 46|14:13:26.6925||api user: CONSUMER t Information: 1220 : |GetSearchItem. search type Job id 1293. t Transfer: 1220 : 32|14:13:26.8955||IsUserAuthenticated: /api/search/workflow?_dc=1572272006707 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 32|14:13:26.8955|| user CONSUMER. t Transfer: 1220 : 32|14:13:26.8955||api user: CONSUMER t Information: 1220 : |V3Api.SearchWorkflows t Information: 1220 : |V3Api.SearchGeneric t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 32|14:13:26.9045|| user CONSUMER. t Information: 1220 : 32|14:13:26.9255||SearchJob SQL: select * from (select a.*, rownum rnum from ( select /*+ INDEX(j JB_CMBST_IDX) */ j.* ,p.pname ,mi.tv_std ,mi.MIID1, mi.MIID2, mi.MIID3, mi.VERSIONID1, mi.VERSIONID2, mi.PROGID1, mi.PROGID2 ,txd.NEXT_TX_DATE FROM tm_mjob j left join tm_mjob_pset p on j.j_sched_indx=p.id left join (select j_id, TMD_str_agg(distinct miid1) MIID1, TMD_str_agg(distinct miid2) MIID2, TMD_str_agg(distinct miid3) MIID3, TMD_str_agg(distinct versionid1) VERSIONID1, TMD_str_agg(distinct versionid2) VERSIONID2, TMD_str_agg(distinct progid1) PROGID1, TMD_str_agg(distinct progid2) PROGID2, TMD_str_agg(distinct m.tv_std) TV_STD from tm_mis m, tm_mtsk_it i where m.id=i.mi_id and i.src_dest in (2,3) group by j_id) mi on mi.j_id=j.id LEFT JOIN ( SELECT it.j_id, min(sch.tx_tm_st) NEXT_TX_DATE FROM TM_MTSK_IT it, TM_MIS m, hr_sched sch WHERE m.id = it.MI_ID AND (sch.prod_num = m.PROGID2 OR sch.prod_num = (select rl.VERSIONID1 from TM_PG_RL rl where rl.ID = m.PGM_PARENT_ID)) AND sch.tx_tm_st > sysdate GROUP BY J_ID) txd ON txd.j_id = j.id where 1=1 AND j.id in ( select t.j_id from tm_mtask t where t.tsk_type = 1 ) and j.cmb_stat not in (15,18,23) AND j.J_CLI_CODE in ('OSP' , 'TMD') order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Information: 1220 : 32|14:13:27.1824|| jobs returned 30, searched in 00:00:00.2568680 t Information: 1220 : 32|14:13:27.2284||TechReports is not found. ID: 673. t Information: 1220 : 32|14:13:27.2284||TechReports is not found. ID: 1633. t Information: 1220 : 32|14:13:27.2284||TechReports is not found. ID: 1300. t Information: 1220 : 32|14:13:27.2284||TechReports is not found. ID: 96. t Information: 1220 : 32|14:13:27.2284||TechReports is not found. ID: 41. t Information: 1220 : 32|14:13:27.2284||TechReports is not found. ID: 116. t Information: 1220 : 32|14:13:27.2284||TechReports is not found. ID: 672. t Information: 1220 : 32|14:13:27.2284||TechReports is not found. ID: 552. t Information: 1220 : 32|14:13:27.2284||TechReports is not found. ID: 1301. t Information: 1220 : 32|14:13:27.2284||TechReports is not found. ID: 1497. t Information: 1220 : 32|14:13:27.2284||TechReports is not found. ID: 16. t Information: 1220 : 32|14:13:27.2294||TechReports is not found. ID: 27. t Information: 1220 : 32|14:13:27.2294|| tasks returned 30, searched in 00:00:00.0471205 t Information: 1220 : |Oauth validating.. t Verbose: 1220 : |GrantResourceOwnerCredentials. t Verbose: 1220 : 40|14:13:30.7897||LoginUser. tmddba, login type OAuth, encrypt password True t Information: 1220 : 40|14:13:30.7897||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 : 40|14:13:30.8137|| oauth token 00000000-0000-0000-0000-000000000000 t Information: 1220 : |TryLoginUser. Logged in.. t Verbose: 1220 : 40|14:13:30.8137||LoginUser. Adding history. User Id 1, result TMDDBA, host t Verbose: 1220 : 40|14:13:30.8197||GrantResourceOwnerCredentials. Try login finished. Logged: True t Transfer: 1220 : 33|14:13:30.9397||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=1572272010850 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 33|14:13:30.9397|| user TMDDBA. t Transfer: 1220 : 33|14:13:30.9397||api user: TMDDBA t Information: 1220 : |V3Api.GetUserSettings t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 33|14:13:30.9397|| user TMDDBA. t Transfer: 1220 : 33|14:13:31.0097||IsUserAuthenticated: /api/user-preferences?keys=personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch&_dc=1572272010981 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 33|14:13:31.0107|| user TMDDBA. t Transfer: 1220 : 33|14:13:31.0107||api user: TMDDBA 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|14:13:31.0107|| user TMDDBA. t Information: 1220 : |GetUserProfile. Id: 0 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 32|14:13:31.1667|| user TMDDBA. t Transfer: 1220 : 40|14:13:31.3437||IsUserAuthenticated: /api/settings/group/0?_dc=1572272011276 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 40|14:13:31.3447|| user TMDDBA. t Transfer: 1220 : 40|14:13:31.3447||api user: TMDDBA t Information: 1220 : |V3Api.GetSettingsGroup t Transfer: 1220 : 31|14:13:31.4927||IsUserAuthenticated: /api/view/searches/Job?_dc=1572272011406 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 31|14:13:31.4927|| user TMDDBA. t Transfer: 1220 : 31|14:13:31.4927||api user: TMDDBA t Information: 1220 : |GetSavedSearchNames. search type Job. t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 31|14:13:31.4937|| user TMDDBA. t Transfer: 1220 : 40|14:13:33.0149||IsUserAuthenticated: /api/v3/layout/default/3?_dc=1572272012887 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 40|14:13:33.0159|| user TMDDBA. t Transfer: 1220 : 40|14:13:33.0159||api user: TMDDBA t Information: 1220 : |LoadDefaultDashboard. t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 40|14:13:33.0159|| user TMDDBA. t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 40|14:13:33.0409|| user TMDDBA. t Transfer: 1220 : 31|14:13:40.6958||IsUserAuthenticated: /api/search/workflow?_dc=1572272020449 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 31|14:13:40.6958|| user CONSUMER. t Transfer: 1220 : 31|14:13:40.6958||api user: CONSUMER t Information: 1220 : |V3Api.SearchWorkflows t Information: 1220 : |V3Api.SearchGeneric t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 31|14:13:40.6958|| user CONSUMER. t Information: 1220 : 31|14:13:40.6958||SearchJob SQL: select * from (select a.*, rownum rnum from ( select /*+ INDEX(j JB_CMBST_IDX) */ j.* ,p.pname ,mi.tv_std ,mi.MIID1, mi.MIID2, mi.MIID3, mi.VERSIONID1, mi.VERSIONID2, mi.PROGID1, mi.PROGID2 ,txd.NEXT_TX_DATE FROM tm_mjob j left join tm_mjob_pset p on j.j_sched_indx=p.id left join (select j_id, TMD_str_agg(distinct miid1) MIID1, TMD_str_agg(distinct miid2) MIID2, TMD_str_agg(distinct miid3) MIID3, TMD_str_agg(distinct versionid1) VERSIONID1, TMD_str_agg(distinct versionid2) VERSIONID2, TMD_str_agg(distinct progid1) PROGID1, TMD_str_agg(distinct progid2) PROGID2, TMD_str_agg(distinct m.tv_std) TV_STD from tm_mis m, tm_mtsk_it i where m.id=i.mi_id and i.src_dest in (2,3) group by j_id) mi on mi.j_id=j.id LEFT JOIN ( SELECT it.j_id, min(sch.tx_tm_st) NEXT_TX_DATE FROM TM_MTSK_IT it, TM_MIS m, hr_sched sch WHERE m.id = it.MI_ID AND (sch.prod_num = m.PROGID2 OR sch.prod_num = (select rl.VERSIONID1 from TM_PG_RL rl where rl.ID = m.PGM_PARENT_ID)) AND sch.tx_tm_st > sysdate GROUP BY J_ID) txd ON txd.j_id = j.id where 1=1 AND j.id in ( select t.j_id from tm_mtask t where t.tsk_type = 1 ) and j.cmb_stat not in (15,18,23) AND j.J_CLI_CODE in ('OSP' , 'TMD') order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Information: 1220 : 31|14:13:40.7270|| jobs returned 30, searched in 00:00:00.0272387 t Information: 1220 : 31|14:13:40.7427||TechReports is not found. ID: 673. t Information: 1220 : 31|14:13:40.7427||TechReports is not found. ID: 1633. t Information: 1220 : 31|14:13:40.7427||TechReports is not found. ID: 1300. t Information: 1220 : 31|14:13:40.7585||TechReports is not found. ID: 96. t Information: 1220 : 31|14:13:40.7585||TechReports is not found. ID: 41. t Information: 1220 : 31|14:13:40.7585||TechReports is not found. ID: 116. t Information: 1220 : 31|14:13:40.7585||TechReports is not found. ID: 672. t Information: 1220 : 31|14:13:40.7585||TechReports is not found. ID: 552. t Information: 1220 : 31|14:13:40.7585||TechReports is not found. ID: 1301. t Information: 1220 : 31|14:13:40.7585||TechReports is not found. ID: 1497. t Information: 1220 : 31|14:13:40.7593||TechReports is not found. ID: 16. t Information: 1220 : 31|14:13:40.7593||TechReports is not found. ID: 27. t Information: 1220 : 31|14:13:40.7593|| tasks returned 30, searched in 00:00:00.0286169 t Transfer: 1220 : 33|14:13:50.9919||IsUserAuthenticated: /api/settings/groups/?_dc=1572272030806 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 33|14:13:50.9929|| user CONSUMER. t Transfer: 1220 : 33|14:13:50.9929||api user: CONSUMER t Information: 1220 : |V3Api.GetSettingsGroupsNames t Transfer: 1220 : 31|14:13:50.9969||IsUserAuthenticated: /api/v3/config/servicexml/types?_dc=1572272030753 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 31|14:13:50.9969|| user CONSUMER. t Transfer: 1220 : 31|14:13:50.9969||api user: CONSUMER t Transfer: 1220 : 31|14:13:52.4451||IsUserAuthenticated: /api/settings/group/0?_dc=1572272032339 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 31|14:13:52.4451|| user CONSUMER. t Transfer: 1220 : 31|14:13:52.4451||api user: CONSUMER t Information: 1220 : |V3Api.GetSettingsGroup t Transfer: 1220 : 40|14:13:52.4451||IsUserAuthenticated: /api/settings/group/0?_dc=1572272032337 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 40|14:13:52.4451|| user CONSUMER. t Transfer: 1220 : 40|14:13:52.4451||api user: CONSUMER t Information: 1220 : |V3Api.GetSettingsGroup t Transfer: 1220 : 46|14:13:52.4608||IsUserAuthenticated: /api/settings/group/0?_dc=1572272032343 t Transfer: 1220 : |GetCurrentUser.. t Transfer: 1220 : | OAuth authenticated t Transfer: 1220 : 46|14:13:52.4608|| user CONSUMER. t Transfer: 1220 : 46|14:13:52.4608||api user: CONSUMER t Information: 1220 : |V3Api.GetSettingsGroup t Information: 1220 : |OrabitWatcherBasic. Disposing. t Information: 1220 : |OrabitWatcherBasic. Disposed. t Information: 1220 : |========================================================================== t Information: 1220 : |IMFX CORE SERVER APPLICATION END.