t Information: 1220 : 1|03:47:47.0241||Get Configuration Values: t Information: 1220 : 1|03:47:47.0241|| AdminPassEnc, default: , value: ffqjrn0leKv4Lj2YJHe2dw==. t Information: 1220 : 1|03:47:47.0241|| EncryptedPasswords, default: false, value: true. t Information: 1220 : 1|03:47:47.0241|| OraConnectionString, default: , value: Server=TECHM;User Id=imfx;Password=;Unicode=true;. t Information: 1220 : 1|03:47:47.0241|| SecondTimezone, default: , value: . t Information: 1220 : 1|03:47:47.0241|| UseActiveDirectoryAuth, default: false, value: false. t Information: 1220 : 1|03:47:47.0241|| ReportingServiceUrl, default: , value: http://localhost:92/ReportingService.svc. t Information: 1220 : 1|03:47:47.0241|| ReportsPath, default: , value: . t Information: 1220 : 1|03:47:47.0241|| ReportsURL, default: , value: . t Information: 1220 : 1|03:47:47.0241|| TapeServiceUrl, default: , value: . t Information: 1220 : 1|03:47:47.0241|| GatekeeperUrl, default: , value: . t Information: 1220 : 1|03:47:47.0241|| ValuationUrl, default: , value: . t Information: 1220 : 1|03:47:47.0241|| QueueManagerDelay, default: 30, value: 30. t Information: 1220 : 1|03:47:47.0241|| QueueManagerFullRefresh, default: 90, value: 90. t Information: 1220 : 1|03:47:47.0241|| AudioLoopDuration, default: 0, value: 150. t Information: 1220 : 1|03:47:47.0241|| AudioLoopsCount, default: 0, value: 0. t Information: 1220 : 1|03:47:47.0396|| PlayerFakeStep, default: 500, value: 500. t Information: 1220 : 1|03:47:47.0396|| PlayerForceRatio, default: 0, value: 1. t Information: 1220 : 1|03:47:47.0396|| CheckVersionsInProd, default: false, value: True. t Information: 1220 : 1|03:47:47.0396|| MaxResults, default: 3000, value: 10000. t Information: 1220 : 1|03:47:47.0396|| NetworkRestriction, default: false, value: True. t Information: 1220 : 1|03:47:47.0396|| TEReportID, default: 0, value: 0. t Information: 1220 : 1|03:47:47.0396|| ClosedCaptionsCache, default: , value: C:\inetpub\wwwroot\imfxcore\timedtextcache\. t Information: 1220 : 1|03:47:47.0396|| ClosedCaptionsStorage, default: , value: c:\Mediaflex\subs. t Information: 1220 : 1|03:47:47.0396|| TimeCodeFormat, default: , value: pal. t Information: 1220 : 1|03:47:47.0396|| RceMediaPath, default: , value: C:\edl\. t Information: 1220 : 1|03:47:47.0396|| RceMediaPath, default: , value: C:\edl\. t Information: 1220 : 1|03:47:47.0396|| RceCsmOutputPath, default: , value: C:\Inetpub\wwwroot\csm\. t Information: 1220 : 1|03:47:47.0396|| RceCsmUrl, default: , value: http://localhost/csm/. t Information: 1220 : 1|03:47:47.0396|| RceMediaSelection, default: , value: miLinkIdMatch. t Information: 1220 : 1|03:47:47.0396|| RequestBrowseJobPresetName, default: , value: . t Information: 1220 : 1|03:47:47.0396|| DontExtendDuration, default: false, value: False. t Information: 1220 : 1|03:47:47.0396|| V3ConfigUrl, default: , value: . t Information: 1220 : 1|03:47:47.0396|| ApiServer, default: , value: http://192.168.120.10:85. t Information: 1220 : 1|03:47:47.0396|| StopWords, default: , value: . t Information: 1220 : 1|03:47:47.0396|| MisrTxFormat, default: G, value: G. t Information: 1220 : 1|03:47:47.0396|| ThumbnailServer, default: , value: . t Information: 1220 : 1|03:47:47.0396|| LocationFilter, default: , value: . t Information: 1220 : 1|03:47:47.0396|| SvUtilServiceUrl, default: , value: . t Information: 1220 : 1|03:47:47.0396|| SolrConnection, default: , value: http://192.168.120.14:8983/solr. t Information: 1220 : 1|03:47:47.0396|| UseIndexServerSearch, default: false, value: True. t Information: 1220 : 1|03:47:47.0396|| SolrIndexVersion, default: 1, value: 6. t Information: 1220 : 1|03:47:47.0396|| SolrConnection, default: , value: http://192.168.120.14:8983/solr. t Information: 1220 : 1|03:47:47.0396|| FacetsGroups, default: , value: owners,season_id, series_id,version_key,item_type,media_type,media_format,episode_number. t Information: 1220 : 1|03:47:47.0396|| FacetsGroupsVersion, default: , value: owners,season_id, series_id,version_key,episode_number. t Information: 1220 : 1|03:47:47.0396|| FacetsGroupsChameleon, default: , value: season_id, series_id,genre,prod_year,version_key. t Information: 1220 : 1|03:47:47.0396|| PreviewPreset, default: , value: . t Information: 1220 : 1|03:47:47.0396|| DevMode, default: false, value: false. t Information: 1220 : 1|03:47:47.0396|| DisableSysMan, default: false, value: false. t Information: 1220 : 1|03:47:47.0396|| TimeCodeFormat, default: , value: pal. t Information: 1220 : 1|03:47:47.0396|| FileCatalystStorageDevice, default: , value: . t Information: 1220 : 1|03:47:47.0396|| UseResponsibilityTracking, default: true, value: True. t Information: 1220 : 1|03:47:47.0396|| SubtitleDeviceFilter, default: , value: . t Information: 1220 : 1|03:47:47.0396|| SystemMonitorNamedPipe, default: , value: . t Information: 1220 : 1|03:47:47.0396|| OracleMonitorEnable, default: false, value: False. t Information: 1220 : 1|03:47:47.0396|| ArcApiHost, default: , value: . t Information: 1220 : 1|03:47:47.0396|| RabbitMqUrl, default: , value: amqp://192.168.120.14:5672. t Information: 1220 : 1|03:47:47.0396|| SolrTimedTextSearch, default: false, value: false. t Information: 1220 : 1|03:47:47.0396|| ProductionDurationUsageID, default: 1, value: 1. t Information: 1220 : 1|03:47:47.3366||GetStreamServers.. t Information: 1220 : 1|03:47:47.9928|| https://demo.tmd.tv/CBR Video/ |CBR Video| False t Information: 1220 : 1|03:47:47.9928|| https://demo.tmd.tv/CBR Images/ |CBR Images| False t Information: 1220 : 1|03:47:47.9928|| https://demo.tmd.tv/CBR Audio/ |CBR Audio| False t Information: 1220 : 1|03:47:47.9928|| https://demo.tmd.tv/Temp Upload/ |TEMP_UPLOAD| False t Information: 1220 : 1|03:47:47.9928|| http://localhost:82/images/ |IMAGES| False t Information: 1220 : 1|03:47:47.9928|| http://192.168.91.73/smoothcloud/ |SMOOTH_CLOUD| False t Information: 1220 : 1|03:47:47.9928|| http://192.168.91.73/cloudstore/ |CLOUD_STORE| False t Information: 1220 : 1|03:47:47.9928|| http://192.168.91.73/editsystemin/ |EDIT_SYSTEM_IN| False t Information: 1220 : 1|03:47:47.9928|| http://192.168.91.27:89/APPLEPROXY/ |APPLE_PROXY| False t Information: 1220 : 1|03:47:47.9928|| http://localhost:82/video/ |FILESTORE_VIDEO| False t Information: 1220 : 1|03:47:47.9928|| https://imfxv3tm.tmd.tv/streaming/ |Streaming| False t Information: 1220 : 1|03:47:47.9928|| https://imfxv3tm.tmd.tv/VideoServer/ |Video| False t Information: 1220 : 1|03:47:47.9928|| https://imfxv3tm.tmd.tv/AdobeIn/ |Adobe Premiere Pro In| False t Information: 1220 : 1|03:47:47.9928|| https://imfxv3tm.tmd.tv/AudioServer/ |Audio| False t Information: 1220 : 1|03:47:47.9928|| https://imfxv3tm.tmd.tv/ImageServer/ |Image| False t Information: 1220 : 1|03:47:47.9928|| https://imfxv3tm.tmd.tv/DocsServer/ |Docs| False t Information: 1220 : 1|03:47:47.9928|| https://imfxv3tm.tmd.tv/AmazonLabs/ |TEST HOUSE| False t Information: 1220 : 1|03:47:47.9928|| SolrConnectionUms, default: http://192.168.120.14:8983/solr, value: http://192.168.120.14:8983/solr. t Information: 1220 : 1|03:47:47.9928|| ApiLog, default: false, value: false. t Information: 1220 : 1|03:47:47.9928|| EmbeddedRceUrl, default: , value: . t Information: 1220 : 1|03:47:47.9928|| InstallMode, default: , value: . t Information: 1220 : 1|03:47:47.9928|| SamlRequestAddress, default: , value: . t Information: 1220 : 1|03:47:47.9928|| SamlTrustedIssuer, default: , value: . t Information: 1220 : 1|03:47:47.9928|| SamlLoginRedirect, default: , value: . t Information: 1220 : 1|03:47:47.9928|| NaturalLangSearch, default: false, value: True. t Information: 1220 : 1|03:47:47.9928|| OktaLoginField, default: , value: . t Information: 1220 : 1|03:47:47.9928|| AuthenticationTypes, default: , value: Native,PublicApiKey. t Information: 1220 : 1|03:47:47.9928||OrabitWatcherBasic. Initialize. t Information: 1220 : 1|03:47:48.0865||FillDictionaryCache. t Information: 1220 : 1|03:47:51.4459||GetSupportedOperators t Information: 1220 : 10|03:47:51.8053||CacheTechReports. t Information: 1220 : 1|03:47:51.8990||& Cache update. Server (global) filled with timestamp 03:12:51.8834892. types null t Information: 1220 : 1|03:47:51.8990||InitializeFromDatabase. 'Server=TECHM;User Id=imfx;password=..;Unicode=true;' direct False, home , timeout 15 t Information: 1220 : 1|03:47:51.8990||FillDictionaryCache. t Information: 1220 : 1|03:47:51.9147||& Cache update. Server (global) filled with timestamp 03:12:51.9147118. types FriendlyNames, DatabaseSearchFieldData t Information: 1220 : 1|03:47:52.2584||========================================================================== t Information: 1220 : 1|03:47:52.2584||IMFX CORE SERVER APPLICATION START. t Information: 1220 : 1|03:47:52.2584||DLL VERSION: 2.5.0.2322. t Information: 1220 : 10|03:47:52.2584|| UmsDev, default: False, value: False. t Information: 1220 : 1|03:47:52.3365|| ApiLog, default: false, value: false. t Information: 1220 : 12|03:47:52.3990||Oauth validating.. t Verbose: 1220 : 12|03:47:52.4146||GrantResourceOwnerCredentials. t Verbose: 1220 : 12|03:47:52.4146||LoginUser. BB00567992, login type OAuth, encrypt password True t Information: 1220 : 12|03:47:52.4146||TryLoginUser. BB00567992, login type OAuth, check password True, check hash False, encrypt password True, load user data True t Information: 1220 : 12|03:47:52.7428||InitialiseLogin t Information: 1220 : 12|03:47:52.8678|| oauth token 00000000-0000-0000-0000-000000000000 t Information: 1220 : 12|03:47:52.8678||TryLoginUser. Logged in.. t Information: 1220 : 12|03:47:52.9303||GetPasswordPolicy. WARNING: Policy not found for system Imediaflex. Validation disabled. t Verbose: 1220 : 12|03:47:52.9303||LoginUser. Adding history. User Id 624, result BB00567992, host t Verbose: 1220 : 12|03:47:52.9771||GrantResourceOwnerCredentials. Try login finished. Logged: True t Information: 1220 : 11|03:47:53.0084||OrabitWatcherBasic trying to connect.. t Information: 1220 : 11|03:47:53.0865||OrabitWatcherBasic connected. t Information: 1220 : 11|03:47:53.1022||OrabitWatcherBasic queue created tmd.cfg.in.8d0a528d-8332-4e82-bfed-a657636d9139 t Transfer: 1220 : 11|03:47:55.2272||IsUserAuthenticated: /api/user-group-preferences?keys=defaultSearchColumnsMedia,defaultSearchColumnsVersion,defaultSearchColumnsSimple,defaultSearchMisrDetailsMediaColumns,versionCreationSettings,associate.advanced_search.version.setups,associate.advanced_search.media.setups,associate.wfrise.setups,supplier_portal.advanced_search.version.setups,logoImage&globals=isDebugMode,htmlplayerhotkeys,versionCreationSettings,associate.advanced_search.version.setups,associate.advanced_search.media.setups,associate.wfrise.setups,supplier_portal.advanced_search.version.setups&_dc=1576727273322 t Transfer: 1220 : 11|03:47:55.2272||GetCurrentUser.. t Transfer: 1220 : 11|03:47:55.2272|| OAuth authenticated t Transfer: 1220 : 11|03:47:55.2272|| user BB00567992. t Transfer: 1220 : 11|03:47:55.2272||api user: BB00567992 t Information: 1220 : 11|03:47:55.2897||V3Api.GetUserSettings t Transfer: 1220 : 11|03:47:55.2897||GetCurrentUser.. t Transfer: 1220 : 11|03:47:55.2897|| OAuth authenticated t Transfer: 1220 : 11|03:47:55.2897|| user BB00567992. t Transfer: 1220 : 10|03:47:56.4459||IsUserAuthenticated: /api/lookups/MediaStatus?_dc=1576727275661 t Transfer: 1220 : 10|03:47:56.4459||GetCurrentUser.. t Transfer: 1220 : 10|03:47:56.4459|| OAuth authenticated t Transfer: 1220 : 10|03:47:56.4459|| user BB00567992. t Transfer: 1220 : 10|03:47:56.4459||api user: BB00567992 t Transfer: 1220 : 20|03:47:56.4772||IsUserAuthenticated: /api/lookups/PgmStatus?_dc=1576727275664 t Transfer: 1220 : 20|03:47:56.4772||GetCurrentUser.. t Transfer: 1220 : 20|03:47:56.4772|| OAuth authenticated t Transfer: 1220 : 20|03:47:56.4772|| user BB00567992. t Transfer: 1220 : 20|03:47:56.4772||api user: BB00567992 t Transfer: 1220 : 11|03:47:56.4928||IsUserAuthenticated: /api/user-preferences?keys=personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch&_dc=1576727275659 t Transfer: 1220 : 11|03:47:56.4928||GetCurrentUser.. t Transfer: 1220 : 11|03:47:56.4928|| OAuth authenticated t Transfer: 1220 : 11|03:47:56.4928|| user BB00567992. t Transfer: 1220 : 11|03:47:56.4928||api user: BB00567992 t Information: 1220 : 11|03:47:56.4928||GetUserDataByKeys: personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch t Transfer: 1220 : 11|03:47:56.4928||GetCurrentUser.. t Transfer: 1220 : 11|03:47:56.4928|| OAuth authenticated t Transfer: 1220 : 11|03:47:56.4928|| user BB00567992. t Information: 1220 : 10|03:47:57.5709||GetUserProfile. Id: 0 t Transfer: 1220 : 10|03:47:57.5709||GetCurrentUser.. t Transfer: 1220 : 10|03:47:57.5709|| OAuth authenticated t Transfer: 1220 : 10|03:47:57.5709|| user BB00567992. t Transfer: 1220 : 20|03:47:58.4928||IsUserAuthenticated: /api/view/searchinfo/Media?_dc=1576727278274 t Transfer: 1220 : 20|03:47:58.4928||GetCurrentUser.. t Transfer: 1220 : 20|03:47:58.4928|| OAuth authenticated t Transfer: 1220 : 20|03:47:58.4928|| user BB00567992. t Transfer: 1220 : 20|03:47:58.4928||api user: BB00567992 t Information: 1220 : 20|03:47:58.4928||GetAdvSearchColumns. search type Media grid . t Transfer: 1220 : 11|03:47:58.8990||IsUserAuthenticated: /api/lookups/SearchSupportedOperators?_dc=1576727278275 t Transfer: 1220 : 11|03:47:58.8990||GetCurrentUser.. t Transfer: 1220 : 11|03:47:58.8990|| OAuth authenticated t Transfer: 1220 : 11|03:47:58.8990|| user BB00567992. t Transfer: 1220 : 11|03:47:58.8990||api user: BB00567992 t Transfer: 1220 : 10|03:47:58.8990||IsUserAuthenticated: /api/user-preferences?keys=adv.recent.searches.media&_dc=1576727278277 t Transfer: 1220 : 10|03:47:58.8990||GetCurrentUser.. t Transfer: 1220 : 10|03:47:58.8990|| OAuth authenticated t Transfer: 1220 : 10|03:47:58.8990|| user BB00567992. t Transfer: 1220 : 10|03:47:58.8990||api user: BB00567992 t Information: 1220 : 10|03:47:58.8990||GetUserDataByKeys: adv.recent.searches.media t Transfer: 1220 : 10|03:47:58.8990||GetCurrentUser.. t Transfer: 1220 : 10|03:47:58.8990|| OAuth authenticated t Transfer: 1220 : 10|03:47:58.8990|| user BB00567992. t Transfer: 1220 : 10|03:47:59.1021||IsUserAuthenticated: /api/view/info/MediaGrid?lang=en-US&_dc=1576727278307 t Transfer: 1220 : 10|03:47:59.1021||GetCurrentUser.. t Transfer: 1220 : 10|03:47:59.1021|| OAuth authenticated t Transfer: 1220 : 10|03:47:59.1021|| user BB00567992. t Transfer: 1220 : 10|03:47:59.1021||api user: BB00567992 t Information: 1220 : 10|03:47:59.1021||GetGridViewBuilder. builder type MediaGrid. t Transfer: 1220 : 10|03:47:59.1021||GetCurrentUser.. t Transfer: 1220 : 10|03:47:59.1021|| OAuth authenticated t Transfer: 1220 : 10|03:47:59.1021|| user BB00567992. t Information: 1220 : 10|03:47:59.1334||UserGridView. LoadView. ID 1581, Name Default. t Transfer: 1220 : 12|03:47:59.1334||IsUserAuthenticated: /api/view/searches/Media?_dc=1576727278324 t Transfer: 1220 : 12|03:47:59.1334||GetCurrentUser.. t Transfer: 1220 : 12|03:47:59.1334|| OAuth authenticated t Transfer: 1220 : 10|03:47:59.1334||GetCurrentUser.. t Transfer: 1220 : 12|03:47:59.1334|| user BB00567992. t Transfer: 1220 : 12|03:47:59.1334||api user: BB00567992 t Transfer: 1220 : 10|03:47:59.1334|| OAuth authenticated t Transfer: 1220 : 10|03:47:59.1334|| user BB00567992. t Transfer: 1220 : 11|03:47:59.1334||IsUserAuthenticated: /api/settings/user/searchLayoutConfig?_dc=1576727278281 t Transfer: 1220 : 11|03:47:59.1334||GetCurrentUser.. t Transfer: 1220 : 11|03:47:59.1334|| OAuth authenticated t Transfer: 1220 : 11|03:47:59.1334|| user BB00567992. t Transfer: 1220 : 11|03:47:59.1334||api user: BB00567992 t Information: 1220 : 11|03:47:59.1334||V3Api.GetUserSettings t Transfer: 1220 : 11|03:47:59.1334||GetCurrentUser.. t Transfer: 1220 : 11|03:47:59.1334|| OAuth authenticated t Transfer: 1220 : 11|03:47:59.1334|| user BB00567992. t Information: 1220 : 12|03:47:59.1490||GetSavedSearchNames. search type Media. t Transfer: 1220 : 12|03:47:59.1490||GetCurrentUser.. t Transfer: 1220 : 12|03:47:59.1490|| OAuth authenticated t Transfer: 1220 : 12|03:47:59.1490|| user BB00567992. t Transfer: 1220 : 10|03:47:59.1647||GetCurrentUser.. t Transfer: 1220 : 10|03:47:59.1647|| OAuth authenticated t Transfer: 1220 : 10|03:47:59.1647|| user BB00567992. t Transfer: 1220 : 20|03:48:18.9928||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1576727298792 t Transfer: 1220 : 20|03:48:18.9928||GetCurrentUser.. t Transfer: 1220 : 20|03:48:18.9928|| OAuth authenticated t Transfer: 1220 : 20|03:48:18.9928|| user BB00567992. t Transfer: 1220 : 20|03:48:18.9928||api user: BB00567992 t Transfer: 1220 : 20|03:48:19.0709||GetCurrentUser.. t Transfer: 1220 : 20|03:48:19.0709|| OAuth authenticated t Transfer: 1220 : 20|03:48:19.0709|| user BB00567992. t Transfer: 1220 : 12|03:48:19.5553||IsUserAuthenticated: /api/SearchSuggestion/?_dc=1576727298959 t Transfer: 1220 : 12|03:48:19.5553||GetCurrentUser.. t Transfer: 1220 : 12|03:48:19.5553|| OAuth authenticated t Transfer: 1220 : 12|03:48:19.5553|| user BB00567992. t Transfer: 1220 : 12|03:48:19.5553||api user: BB00567992 t Transfer: 1220 : 12|03:48:19.5553||GetCurrentUser.. t Transfer: 1220 : 12|03:48:19.5553|| OAuth authenticated t Transfer: 1220 : 12|03:48:19.5553|| user BB00567992. t Transfer: 1220 : 11|03:48:22.7740||IsUserAuthenticated: /api/search/Media?_dc=1576727302575 t Transfer: 1220 : 11|03:48:22.7740||GetCurrentUser.. t Transfer: 1220 : 11|03:48:22.7740|| OAuth authenticated t Transfer: 1220 : 11|03:48:22.7740|| user BB00567992. t Transfer: 1220 : 11|03:48:22.7740||api user: BB00567992 t Information: 1220 : 11|03:48:22.8678||V3Api.SearchMedia t Information: 1220 : 11|03:48:22.8678||V3Api.SearchGeneric t Transfer: 1220 : 11|03:48:22.9147||GetCurrentUser.. t Transfer: 1220 : 11|03:48:22.9147|| OAuth authenticated t Transfer: 1220 : 11|03:48:22.9147|| user BB00567992. t Information: 1220 : 11|03:48:23.0240||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 , GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION, nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME from (select a.*, rownum rnum from (select m.*, coalesce(m.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=m.pgm_parent_id)) primary_thumb_id2 from tmddba.tm_mis m ,(select /*+ cardinality(4) */ rownum rn, column_value id from table(:ids)) ids where media_type>0 and item_type>0 and m.id = ids.id order by ids.rn ) a where rownum <= 10000) r ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t ,lateral(select /*+ NO_DECORRELATE */ d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl where rnum >= 1 order by rnum t Information: 1220 : 11|03:48:23.4772|| timing: 00:00:00.5847504 t Verbose: 1220 : 11|03:48:23.6647||GetUrl. Enter. Storage |AmazonS3 EU WEST tmdvideo| filename https://tmdvideo.s3.amazonaws.com/spanish.wav subfolder t Transfer: 1220 : 11|03:48:23.6647||GetCurrentUser.. t Transfer: 1220 : 11|03:48:23.6647|| OAuth authenticated t Transfer: 1220 : 11|03:48:23.6647|| user BB00567992. t Verbose: 1220 : 11|03:48:23.7740||GetUrl. Enter. Storage |AmazonS3 EU WEST tmdvideo| filename https://tmdvideo.s3.amazonaws.com/gots1ep1us.mp4 subfolder t Transfer: 1220 : 11|03:48:23.7740||GetCurrentUser.. t Transfer: 1220 : 11|03:48:23.7740|| OAuth authenticated t Transfer: 1220 : 11|03:48:23.7740|| user BB00567992. t Verbose: 1220 : 11|03:48:23.7740||GetUrl. Enter. Storage |AmazonS3 EU WEST tmdvideo| filename https://tmdvideo.s3.amazonaws.com/package rundown.xml subfolder t Transfer: 1220 : 11|03:48:23.7740||GetCurrentUser.. t Transfer: 1220 : 11|03:48:23.7740|| OAuth authenticated t Transfer: 1220 : 11|03:48:23.7740|| user BB00567992. t Verbose: 1220 : 11|03:48:23.7740||GetUrl. Enter. Storage |AmazonS3 EU WEST tmdvideo| filename https://tmdvideo.s3.amazonaws.com/Data Model Description 4.pdf subfolder t Transfer: 1220 : 11|03:48:23.7740||GetCurrentUser.. t Transfer: 1220 : 11|03:48:23.7740|| OAuth authenticated t Transfer: 1220 : 11|03:48:23.7740|| user BB00567992. t Verbose: 1220 : 11|03:48:23.7740||GetUrl. Enter. Storage |AmazonS3 EU WEST tmdvideo| filename https://tmdvideo.s3.amazonaws.com/game_of_thrones_still_3.jpg subfolder t Transfer: 1220 : 11|03:48:23.7740||GetCurrentUser.. t Transfer: 1220 : 11|03:48:23.7740|| OAuth authenticated t Transfer: 1220 : 11|03:48:23.7740|| user BB00567992. t Verbose: 1220 : 11|03:48:23.7740||GetUrl. Enter. Storage |AmazonS3 EU WEST tmdvideo| filename https://tmdvideo.s3.amazonaws.com/Mediaflex Supported Devices 2v03_0.pdf subfolder t Transfer: 1220 : 11|03:48:23.7740||GetCurrentUser.. t Transfer: 1220 : 11|03:48:23.7740|| OAuth authenticated t Transfer: 1220 : 11|03:48:23.7740|| user BB00567992. t Verbose: 1220 : 11|03:48:23.7740||GetUrl. Enter. Storage |AmazonS3 EU WEST tmdvideo| filename https://tmdvideo.s3.amazonaws.com/portugese.wav subfolder t Transfer: 1220 : 11|03:48:23.7740||GetCurrentUser.. t Transfer: 1220 : 11|03:48:23.7740|| OAuth authenticated t Transfer: 1220 : 11|03:48:23.7740|| user BB00567992. t Verbose: 1220 : 11|03:48:23.7740||GetUrl. Enter. Storage |Audio| filename \\192.168.120.254\DemoFS\Digital Assets\Audio\spanish.wav subfolder t Verbose: 1220 : 11|03:48:23.7740|| GetFileName result https://imfxv3tm.tmd.tv/AudioServer/spanish.wav t Verbose: 1220 : 11|03:48:23.7740||GetUrl. Exit. result https://imfxv3tm.tmd.tv/AudioServer/spanish.wav t Transfer: 1220 : 11|03:48:23.7740||GetCurrentUser.. t Transfer: 1220 : 11|03:48:23.7740|| OAuth authenticated t Transfer: 1220 : 11|03:48:23.7740|| user BB00567992. t Verbose: 1220 : 11|03:48:23.7740||GetUrl. Enter. Storage |Audio| filename \\192.168.120.254\DemoFS\Digital Assets\Audio\portugese.wav subfolder t Verbose: 1220 : 11|03:48:23.7740|| GetFileName result https://imfxv3tm.tmd.tv/AudioServer/portugese.wav t Verbose: 1220 : 11|03:48:23.7740||GetUrl. Exit. result https://imfxv3tm.tmd.tv/AudioServer/portugese.wav t Transfer: 1220 : 11|03:48:23.7740||GetCurrentUser.. t Transfer: 1220 : 11|03:48:23.7740|| OAuth authenticated t Transfer: 1220 : 11|03:48:23.7740|| user BB00567992. t Verbose: 1220 : 11|03:48:23.7740||GetUrl. Enter. Storage |Docs| filename \\192.168.120.254\DemoFS\Digital Assets\Docs\package rundown.xml subfolder t Verbose: 1220 : 11|03:48:23.7740|| GetFileName result https://imfxv3tm.tmd.tv/DocsServer/package rundown.xml t Verbose: 1220 : 11|03:48:23.7740||GetUrl. Exit. result https://imfxv3tm.tmd.tv/DocsServer/package rundown.xml t Transfer: 1220 : 11|03:48:23.7740||GetCurrentUser.. t Transfer: 1220 : 11|03:48:23.7740|| OAuth authenticated t Transfer: 1220 : 11|03:48:23.7740|| user BB00567992. t Verbose: 1220 : 11|03:48:23.7740||GetUrl. Enter. Storage |Docs| filename \\192.168.120.254\DemoFS\Digital Assets\Docs\Data Model Description 4.pdf subfolder t Verbose: 1220 : 11|03:48:23.7740|| GetFileName result https://imfxv3tm.tmd.tv/DocsServer/Data Model Description 4.pdf t Verbose: 1220 : 11|03:48:23.7740||GetUrl. Exit. result https://imfxv3tm.tmd.tv/DocsServer/Data Model Description 4.pdf t Transfer: 1220 : 11|03:48:23.7740||GetCurrentUser.. t Transfer: 1220 : 11|03:48:23.7740|| OAuth authenticated t Transfer: 1220 : 11|03:48:23.7740|| user BB00567992. t Verbose: 1220 : 11|03:48:23.7740||GetUrl. Enter. Storage |Docs| filename \\192.168.120.254\DemoFS\Digital Assets\Docs\Mediaflex Supported Devices 2v03_0.pdf subfolder t Verbose: 1220 : 11|03:48:23.7740|| GetFileName result https://imfxv3tm.tmd.tv/DocsServer/Mediaflex Supported Devices 2v03_0.pdf t Verbose: 1220 : 11|03:48:23.7740||GetUrl. Exit. result https://imfxv3tm.tmd.tv/DocsServer/Mediaflex Supported Devices 2v03_0.pdf t Transfer: 1220 : 11|03:48:23.7740||GetCurrentUser.. t Transfer: 1220 : 11|03:48:23.7740|| OAuth authenticated t Transfer: 1220 : 11|03:48:23.7897|| user BB00567992. t Verbose: 1220 : 11|03:48:23.7897||GetUrl. Enter. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\game_of_thrones_still_3.jpg subfolder t Verbose: 1220 : 11|03:48:23.7897|| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/game_of_thrones_still_3.jpg t Verbose: 1220 : 11|03:48:23.7897||GetUrl. Exit. result https://imfxv3tm.tmd.tv/ImageServer/game_of_thrones_still_3.jpg t Transfer: 1220 : 11|03:48:23.7897||GetCurrentUser.. t Transfer: 1220 : 11|03:48:23.7897|| OAuth authenticated t Transfer: 1220 : 11|03:48:23.7897|| user BB00567992. t Verbose: 1220 : 11|03:48:23.7897||GetUrl. Enter. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\MediaCube_Intro.docx subfolder t Verbose: 1220 : 11|03:48:23.7897|| GetFileName result https://demo.tmd.tv/Temp Upload/MediaCube_Intro.docx t Verbose: 1220 : 11|03:48:23.7897||GetUrl. Exit. result https://demo.tmd.tv/Temp Upload/MediaCube_Intro.docx t Transfer: 1220 : 11|03:48:23.7897||GetCurrentUser.. t Transfer: 1220 : 11|03:48:23.7897|| OAuth authenticated t Transfer: 1220 : 11|03:48:23.7897|| user BB00567992. t Verbose: 1220 : 11|03:48:23.7897||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gots2ep1.mpd subfolder t Verbose: 1220 : 11|03:48:23.7897|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gots2ep1.mpd t Verbose: 1220 : 11|03:48:23.7897||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/gots2ep1.mpd t Transfer: 1220 : 11|03:48:23.7897||GetCurrentUser.. t Transfer: 1220 : 11|03:48:23.7897|| OAuth authenticated t Transfer: 1220 : 11|03:48:23.7897|| user BB00567992. t Verbose: 1220 : 11|03:48:23.7897||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gots1ep1us.mpd subfolder t Verbose: 1220 : 11|03:48:23.7897|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gots1ep1us.mpd t Verbose: 1220 : 11|03:48:23.7897||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/gots1ep1us.mpd t Transfer: 1220 : 11|03:48:23.7897||GetCurrentUser.. t Transfer: 1220 : 11|03:48:23.7897|| OAuth authenticated t Transfer: 1220 : 11|03:48:23.7897|| user BB00567992. t Verbose: 1220 : 11|03:48:23.7897||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gots1ep1us.mp4 subfolder t Verbose: 1220 : 11|03:48:23.7897|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gots1ep1us.mp4 t Verbose: 1220 : 11|03:48:23.7897||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/gots1ep1us.mp4 t Transfer: 1220 : 11|03:48:23.7897||GetCurrentUser.. t Transfer: 1220 : 11|03:48:23.7897|| OAuth authenticated t Transfer: 1220 : 11|03:48:23.7897|| user BB00567992. t Verbose: 1220 : 11|03:48:23.7897||GetUrl. Enter. Storage |VODPublish| filename \\192.168.120.254\DemoFS\Digital Assets\VODPublish\Temp\N0001344.dtd subfolder Temp\ t Transfer: 1220 : 11|03:48:23.7897||GetCurrentUser.. t Transfer: 1220 : 11|03:48:23.7897|| OAuth authenticated t Transfer: 1220 : 11|03:48:23.7897|| user BB00567992. t Verbose: 1220 : 11|03:48:23.7897||GetUrl. Enter. Storage |VODPublish| filename \\192.168.120.254\DemoFS\Digital Assets\VODPublish\Temp\N0001345.xml subfolder Temp\ t Transfer: 1220 : 11|03:48:23.7897||GetCurrentUser.. t Transfer: 1220 : 11|03:48:23.7897|| OAuth authenticated t Transfer: 1220 : 11|03:48:23.7897|| user BB00567992. t Verbose: 1220 : 11|03:48:23.7897||GetUrl. Enter. Storage |VODPublish| filename \\192.168.120.254\DemoFS\Digital Assets\VODPublish\Temp\N0001348.dtd subfolder Temp\ t Transfer: 1220 : 11|03:48:23.7897||GetCurrentUser.. t Transfer: 1220 : 11|03:48:23.7897|| OAuth authenticated t Transfer: 1220 : 11|03:48:23.7897|| user BB00567992. t Verbose: 1220 : 11|03:48:23.7897||GetUrl. Enter. Storage |VODPublish| filename \\192.168.120.254\DemoFS\Digital Assets\VODPublish\Temp\N0001349.xml subfolder Temp\ t Transfer: 1220 : 11|03:48:23.7897||GetCurrentUser.. t Transfer: 1220 : 11|03:48:23.7897|| OAuth authenticated t Transfer: 1220 : 11|03:48:23.7897|| user BB00567992. t Verbose: 1220 : 11|03:48:23.7897||GetUrl. Enter. Storage |Docs| filename I:\Docs\Mediaflex Supported Devices 2v03.pdf subfolder t Verbose: 1220 : 11|03:48:23.7897|| GetFileName result https://imfxv3tm.tmd.tv/DocsServer/Mediaflex Supported Devices 2v03.pdf t Verbose: 1220 : 11|03:48:23.7897||GetUrl. Exit. result https://imfxv3tm.tmd.tv/DocsServer/Mediaflex Supported Devices 2v03.pdf t Transfer: 1220 : 11|03:48:23.7897||GetCurrentUser.. t Transfer: 1220 : 11|03:48:23.7897|| OAuth authenticated t Transfer: 1220 : 11|03:48:23.7897|| user BB00567992. t Verbose: 1220 : 11|03:48:23.8053||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Game of Thrones - Blinkbox-HD.mp4 subfolder t Verbose: 1220 : 11|03:48:23.8053|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Game of Thrones - Blinkbox-HD.mp4 t Verbose: 1220 : 11|03:48:23.8053||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Game of Thrones - Blinkbox-HD.mp4 t Transfer: 1220 : 11|03:48:23.8053||GetCurrentUser.. t Transfer: 1220 : 11|03:48:23.8053|| OAuth authenticated t Transfer: 1220 : 11|03:48:23.8053|| user BB00567992. t Verbose: 1220 : 11|03:48:23.8053||GetUrl. Enter. Storage |VODPublish| filename \\192.168.120.254\DemoFS\Digital Assets\VODPublish\Temp\N0001343.mp4 subfolder Temp\ t Transfer: 1220 : 11|03:48:23.8053||GetCurrentUser.. t Transfer: 1220 : 11|03:48:23.8053|| OAuth authenticated t Transfer: 1220 : 11|03:48:23.8053|| user BB00567992. t Verbose: 1220 : 11|03:48:23.8053||GetUrl. Enter. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\snow-game-of-thrones-1200x600.jpg subfolder t Verbose: 1220 : 11|03:48:23.8053|| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/snow-game-of-thrones-1200x600.jpg t Verbose: 1220 : 11|03:48:23.8053||GetUrl. Exit. result https://imfxv3tm.tmd.tv/ImageServer/snow-game-of-thrones-1200x600.jpg t Transfer: 1220 : 11|03:48:23.8053||GetCurrentUser.. t Transfer: 1220 : 11|03:48:23.8053|| OAuth authenticated t Transfer: 1220 : 11|03:48:23.8053|| user BB00567992. t Verbose: 1220 : 11|03:48:23.8053||GetUrl. Enter. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\Game_of_Thrones_Still_4.jpg subfolder t Verbose: 1220 : 11|03:48:23.8053|| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/Game_of_Thrones_Still_4.jpg t Verbose: 1220 : 11|03:48:23.8053||GetUrl. Exit. result https://imfxv3tm.tmd.tv/ImageServer/Game_of_Thrones_Still_4.jpg t Transfer: 1220 : 11|03:48:23.8053||GetCurrentUser.. t Transfer: 1220 : 11|03:48:23.8053|| OAuth authenticated t Transfer: 1220 : 11|03:48:23.8053|| user BB00567992. t Verbose: 1220 : 11|03:48:23.8053||GetUrl. Enter. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\game-of-thrones-1349.jpg subfolder t Verbose: 1220 : 11|03:48:23.8053|| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/game-of-thrones-1349.jpg t Verbose: 1220 : 11|03:48:23.8053||GetUrl. Exit. result https://imfxv3tm.tmd.tv/ImageServer/game-of-thrones-1349.jpg t Transfer: 1220 : 11|03:48:23.8053||GetCurrentUser.. t Transfer: 1220 : 11|03:48:23.8053|| OAuth authenticated t Transfer: 1220 : 11|03:48:23.8053|| user BB00567992. t Verbose: 1220 : 11|03:48:23.8053||GetUrl. Enter. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\game-of-thrones-daenerys.jpg subfolder t Verbose: 1220 : 11|03:48:23.8053|| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/game-of-thrones-daenerys.jpg t Verbose: 1220 : 11|03:48:23.8053||GetUrl. Exit. result https://imfxv3tm.tmd.tv/ImageServer/game-of-thrones-daenerys.jpg t Transfer: 1220 : 11|03:48:23.8053||GetCurrentUser.. t Transfer: 1220 : 11|03:48:23.8053|| OAuth authenticated t Transfer: 1220 : 11|03:48:23.8053|| user BB00567992. t Verbose: 1220 : 11|03:48:23.8053||GetUrl. Enter. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\young cersei game of thrones helen sloan.jpeg.jpg subfolder t Verbose: 1220 : 11|03:48:23.8053|| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/young cersei game of thrones helen sloan.jpeg.jpg t Verbose: 1220 : 11|03:48:23.8053||GetUrl. Exit. result https://imfxv3tm.tmd.tv/ImageServer/young cersei game of thrones helen sloan.jpeg.jpg t Transfer: 1220 : 11|03:48:23.8053||GetCurrentUser.. t Transfer: 1220 : 11|03:48:23.8053|| OAuth authenticated t Transfer: 1220 : 11|03:48:23.8053|| user BB00567992. t Verbose: 1220 : 11|03:48:23.8053||GetUrl. Enter. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\BBC_graymeta_metadata.json subfolder t Verbose: 1220 : 11|03:48:23.8053|| GetFileName result https://demo.tmd.tv/Temp Upload/BBC_graymeta_metadata.json t Verbose: 1220 : 11|03:48:23.8053||GetUrl. Exit. result https://demo.tmd.tv/Temp Upload/BBC_graymeta_metadata.json t Transfer: 1220 : 11|03:48:23.8053||GetCurrentUser.. t Transfer: 1220 : 11|03:48:23.8053|| OAuth authenticated t Transfer: 1220 : 11|03:48:23.8053|| user BB00567992. t Verbose: 1220 : 11|03:48:23.8053||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gots0ep2us.mpd subfolder t Verbose: 1220 : 11|03:48:23.8053|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gots0ep2us.mpd t Verbose: 1220 : 11|03:48:23.8053||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/gots0ep2us.mpd t Transfer: 1220 : 11|03:48:23.8053||GetCurrentUser.. t Transfer: 1220 : 11|03:48:23.8053|| OAuth authenticated t Transfer: 1220 : 11|03:48:23.8053|| user BB00567992. t Verbose: 1220 : 11|03:48:23.8053||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gotspecialspromo20seccharacter.mp4 subfolder t Verbose: 1220 : 11|03:48:23.8053|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gotspecialspromo20seccharacter.mp4 t Verbose: 1220 : 11|03:48:23.8053||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/gotspecialspromo20seccharacter.mp4 t Transfer: 1220 : 11|03:48:23.8053||GetCurrentUser.. t Transfer: 1220 : 11|03:48:23.8053|| OAuth authenticated t Transfer: 1220 : 11|03:48:23.8053|| user BB00567992. t Verbose: 1220 : 11|03:48:23.8053||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gotspecialspromo10secaction.mp4 subfolder t Verbose: 1220 : 11|03:48:23.8053|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gotspecialspromo10secaction.mp4 t Verbose: 1220 : 11|03:48:23.8053||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/gotspecialspromo10secaction.mp4 t Transfer: 1220 : 11|03:48:23.8053||GetCurrentUser.. t Transfer: 1220 : 11|03:48:23.8053|| OAuth authenticated t Transfer: 1220 : 11|03:48:23.8053|| user BB00567992. t Verbose: 1220 : 11|03:48:23.8053||GetUrl. Enter. Storage |Audio| filename \\192.168.120.254\DemoFS\Digital Assets\Audio\gotspecialspromosaudio.wav subfolder t Verbose: 1220 : 11|03:48:23.8053|| GetFileName result https://imfxv3tm.tmd.tv/AudioServer/gotspecialspromosaudio.wav t Verbose: 1220 : 11|03:48:23.8053||GetUrl. Exit. result https://imfxv3tm.tmd.tv/AudioServer/gotspecialspromosaudio.wav t Transfer: 1220 : 11|03:48:23.8053||GetCurrentUser.. t Transfer: 1220 : 11|03:48:23.8053|| OAuth authenticated t Transfer: 1220 : 11|03:48:23.8053|| user BB00567992. t Verbose: 1220 : 11|03:48:23.8053||GetUrl. Enter. Storage |Image| filename \\192.168.120.254\DemoFS\Digital Assets\Image\gotspecialspromosimage.jpg subfolder t Verbose: 1220 : 11|03:48:23.8053|| GetFileName result https://imfxv3tm.tmd.tv/ImageServer/gotspecialspromosimage.jpg t Verbose: 1220 : 11|03:48:23.8053||GetUrl. Exit. result https://imfxv3tm.tmd.tv/ImageServer/gotspecialspromosimage.jpg t Transfer: 1220 : 11|03:48:23.8053||GetCurrentUser.. t Transfer: 1220 : 11|03:48:23.8053|| OAuth authenticated t Transfer: 1220 : 11|03:48:23.8053|| user BB00567992. t Verbose: 1220 : 11|03:48:23.8209||GetUrl. Enter. Storage |TEMP_UPLOAD| filename \\192.168.120.254\DemoFS\Digital Assets\TEMP_UPLOAD\68add84afa7b\Animation Sample1.mp4 subfolder 68add84afa7b\ t Verbose: 1220 : 11|03:48:23.8209|| GetFileName result https://demo.tmd.tv/Temp Upload/Animation Sample1.mp4 t Verbose: 1220 : 11|03:48:23.8209||GetUrl. Exit. result https://demo.tmd.tv/Temp Upload/Animation Sample1.mp4 t Transfer: 1220 : 11|03:48:23.8209||GetCurrentUser.. t Transfer: 1220 : 11|03:48:23.8209|| OAuth authenticated t Transfer: 1220 : 11|03:48:23.8209|| user BB00567992. t Transfer: 1220 : 11|03:48:25.3678||IsUserAuthenticated: /api/user-preferences?_dc=1576727305090 t Transfer: 1220 : 11|03:48:25.3678||GetCurrentUser.. t Transfer: 1220 : 11|03:48:25.3678|| OAuth authenticated t Transfer: 1220 : 11|03:48:25.3678|| user BB00567992. t Transfer: 1220 : 11|03:48:25.3678||api user: BB00567992 t Verbose: 1220 : 11|03:48:25.3834||StoreUserDataByKeys.. t Transfer: 1220 : 11|03:48:25.3834||GetCurrentUser.. t Transfer: 1220 : 11|03:48:25.3834|| OAuth authenticated t Transfer: 1220 : 11|03:48:25.3834|| user BB00567992. t Transfer: 1220 : 10|03:48:30.7897||IsUserAuthenticated: /api/settings/group/0?_dc=1576727309942 t Transfer: 1220 : 10|03:48:30.7897||GetCurrentUser.. t Transfer: 1220 : 10|03:48:30.7897|| OAuth authenticated t Transfer: 1220 : 10|03:48:30.7897|| user BB00567992. t Transfer: 1220 : 10|03:48:30.7897||api user: BB00567992 t Information: 1220 : 10|03:48:30.7897||V3Api.GetSettingsGroup t Transfer: 1220 : 20|03:48:31.4303||IsUserAuthenticated: /api/view/searches/Job?_dc=1576727311278 t Transfer: 1220 : 20|03:48:31.4303||GetCurrentUser.. t Transfer: 1220 : 20|03:48:31.4303|| OAuth authenticated t Transfer: 1220 : 20|03:48:31.4303|| user BB00567992. t Transfer: 1220 : 20|03:48:31.4303||api user: BB00567992 t Information: 1220 : 20|03:48:31.4303||GetSavedSearchNames. search type Job. t Transfer: 1220 : 20|03:48:31.4303||GetCurrentUser.. t Transfer: 1220 : 20|03:48:31.4303|| OAuth authenticated t Transfer: 1220 : 20|03:48:31.4303|| user BB00567992. t Transfer: 1220 : 12|03:48:32.0084||IsUserAuthenticated: /api/v3/layout/default/3?_dc=1576727311808 t Transfer: 1220 : 12|03:48:32.0084||GetCurrentUser.. t Transfer: 1220 : 12|03:48:32.0084|| OAuth authenticated t Transfer: 1220 : 12|03:48:32.0084|| user BB00567992. t Transfer: 1220 : 12|03:48:32.0084||api user: BB00567992 t Information: 1220 : 12|03:48:32.0084||LoadDefaultDashboard. t Transfer: 1220 : 12|03:48:32.0084||GetCurrentUser.. t Transfer: 1220 : 12|03:48:32.0084|| OAuth authenticated t Transfer: 1220 : 12|03:48:32.0084|| user BB00567992. t Transfer: 1220 : 10|03:48:35.9772||IsUserAuthenticated: /api/view/searchinfo/task?_dc=1576727315810 t Transfer: 1220 : 10|03:48:35.9772||GetCurrentUser.. t Transfer: 1220 : 10|03:48:35.9772|| OAuth authenticated t Transfer: 1220 : 10|03:48:35.9772|| user BB00567992. t Transfer: 1220 : 10|03:48:35.9772||api user: BB00567992 t Information: 1220 : 10|03:48:35.9772||GetAdvSearchColumns. search type Task grid . t Transfer: 1220 : 10|03:48:35.9928||IsUserAuthenticated: /api/view/info/TaskGrid?lang=en-US&_dc=1576727315826 t Transfer: 1220 : 10|03:48:35.9928||GetCurrentUser.. t Transfer: 1220 : 10|03:48:35.9928|| OAuth authenticated t Transfer: 1220 : 10|03:48:35.9928|| user BB00567992. t Transfer: 1220 : 10|03:48:35.9928||api user: BB00567992 t Information: 1220 : 10|03:48:36.0084||GetGridViewBuilder. builder type TaskGrid. t Transfer: 1220 : 10|03:48:36.0084||GetCurrentUser.. t Transfer: 1220 : 10|03:48:36.0084|| OAuth authenticated t Transfer: 1220 : 10|03:48:36.0084|| user BB00567992. t Transfer: 1220 : 12|03:48:36.0084||IsUserAuthenticated: /api/view/searches/task?_dc=1576727315839 t Transfer: 1220 : 12|03:48:36.0084||GetCurrentUser.. t Transfer: 1220 : 12|03:48:36.0084|| OAuth authenticated t Transfer: 1220 : 12|03:48:36.0084|| user BB00567992. t Transfer: 1220 : 12|03:48:36.0084||api user: BB00567992 t Information: 1220 : 12|03:48:36.0084||GetSavedSearchNames. search type Task. t Transfer: 1220 : 12|03:48:36.0084||GetCurrentUser.. t Transfer: 1220 : 12|03:48:36.0084|| OAuth authenticated t Transfer: 1220 : 12|03:48:36.0084|| user BB00567992. t Information: 1220 : 10|03:48:36.0084||UserGridView. LoadView. ID 1582, Name Default. t Transfer: 1220 : 10|03:48:36.0084||GetCurrentUser.. t Transfer: 1220 : 10|03:48:36.0084|| OAuth authenticated t Transfer: 1220 : 10|03:48:36.0084|| user BB00567992. t Transfer: 1220 : 10|03:48:36.0084||GetCurrentUser.. t Transfer: 1220 : 10|03:48:36.0084|| OAuth authenticated t Transfer: 1220 : 10|03:48:36.0084|| user BB00567992. t Transfer: 1220 : 20|03:48:36.0240||IsUserAuthenticated: /api/lookup/job-schedule-nodes/search/?_dc=1576727315871 t Transfer: 1220 : 20|03:48:36.0240||GetCurrentUser.. t Transfer: 1220 : 20|03:48:36.0240|| OAuth authenticated t Transfer: 1220 : 20|03:48:36.0240|| user BB00567992. t Transfer: 1220 : 20|03:48:36.0240||api user: BB00567992 t Transfer: 1220 : 20|03:48:36.5709||IsUserAuthenticated: /api/user-preferences?keys=adv.recent.searches.tasks&_dc=1576727315812 t Transfer: 1220 : 20|03:48:36.5709||GetCurrentUser.. t Transfer: 1220 : 20|03:48:36.5709|| OAuth authenticated t Transfer: 1220 : 20|03:48:36.5709|| user BB00567992. t Transfer: 1220 : 20|03:48:36.5709||api user: BB00567992 t Information: 1220 : 20|03:48:36.5709||GetUserDataByKeys: adv.recent.searches.tasks t Transfer: 1220 : 20|03:48:36.5709||GetCurrentUser.. t Transfer: 1220 : 20|03:48:36.5709|| OAuth authenticated t Transfer: 1220 : 20|03:48:36.5709|| user BB00567992. t Transfer: 1220 : 11|03:48:50.1334||IsUserAuthenticated: /api/search/task?_dc=1576727329889 t Transfer: 1220 : 11|03:48:50.1334||GetCurrentUser.. t Transfer: 1220 : 11|03:48:50.1334|| OAuth authenticated t Transfer: 1220 : 11|03:48:50.1334|| user BB00567992. t Transfer: 1220 : 11|03:48:50.1334||api user: BB00567992 t Information: 1220 : 11|03:48:50.1334||V3Api.SearchTask t Information: 1220 : 11|03:48:50.1334||V3Api.SearchGeneric t Transfer: 1220 : 11|03:48:50.1490||GetCurrentUser.. t Transfer: 1220 : 11|03:48:50.1490|| OAuth authenticated t Transfer: 1220 : 11|03:48:50.1490|| user BB00567992. t Transfer: 1220 : 12|03:48:50.6959||IsUserAuthenticated: /api/user-preferences?_dc=1576727330465 t Transfer: 1220 : 12|03:48:50.6959||GetCurrentUser.. t Transfer: 1220 : 12|03:48:50.6959|| OAuth authenticated t Transfer: 1220 : 12|03:48:50.6959|| user BB00567992. t Transfer: 1220 : 12|03:48:50.6959||api user: BB00567992 t Verbose: 1220 : 12|03:48:50.6959||StoreUserDataByKeys.. t Transfer: 1220 : 12|03:48:50.6959||GetCurrentUser.. t Transfer: 1220 : 12|03:48:50.6959|| OAuth authenticated t Transfer: 1220 : 12|03:48:50.6959|| user BB00567992. t Transfer: 1220 : 11|03:48:55.3209||IsUserAuthenticated: /api/search/task?_dc=1576727335093 t Transfer: 1220 : 11|03:48:55.3209||GetCurrentUser.. t Transfer: 1220 : 11|03:48:55.3209|| OAuth authenticated t Transfer: 1220 : 11|03:48:55.3209|| user BB00567992. t Transfer: 1220 : 11|03:48:55.3209||api user: BB00567992 t Information: 1220 : 11|03:48:55.3209||V3Api.SearchTask t Information: 1220 : 11|03:48:55.3209||V3Api.SearchGeneric t Transfer: 1220 : 11|03:48:55.3209||GetCurrentUser.. t Transfer: 1220 : 11|03:48:55.3209|| OAuth authenticated t Transfer: 1220 : 11|03:48:55.3209|| user BB00567992. t Transfer: 1220 : 12|03:48:55.7740||IsUserAuthenticated: /api/user-preferences?_dc=1576727335546 t Transfer: 1220 : 12|03:48:55.7740||GetCurrentUser.. t Transfer: 1220 : 12|03:48:55.7740|| OAuth authenticated t Transfer: 1220 : 12|03:48:55.7740|| user BB00567992. t Transfer: 1220 : 12|03:48:55.7740||api user: BB00567992 t Verbose: 1220 : 12|03:48:55.7740||StoreUserDataByKeys.. t Transfer: 1220 : 12|03:48:55.7740||GetCurrentUser.. t Transfer: 1220 : 12|03:48:55.7740|| OAuth authenticated t Transfer: 1220 : 12|03:48:55.7740|| user BB00567992. t Transfer: 1220 : 10|03:49:01.7115||IsUserAuthenticated: /api/search/task?_dc=1576727340925 t Transfer: 1220 : 10|03:49:01.7115||GetCurrentUser.. t Transfer: 1220 : 10|03:49:01.7115|| OAuth authenticated t Transfer: 1220 : 10|03:49:01.7115|| user BB00567992. t Transfer: 1220 : 10|03:49:01.7115||api user: BB00567992 t Information: 1220 : 10|03:49:01.7115||V3Api.SearchTask t Information: 1220 : 10|03:49:01.7115||V3Api.SearchGeneric t Transfer: 1220 : 10|03:49:01.7115||GetCurrentUser.. t Transfer: 1220 : 10|03:49:01.7115|| OAuth authenticated t Transfer: 1220 : 10|03:49:01.7115|| user BB00567992. t Information: 1220 : 10|03:49:01.7272||SearchTask SQL: select * from (select a.*, rownum rnum from ( select /*+ INDEX(j JB_CMBST_IDX) */ /*+ INDEX(j JB_CMBST_IDX) */ j.*, p.pname, mi.MIID1, mi.MIID2, mi.MIID3, mi.VERSIONID1, mi.VERSIONID2, mi.PROGID1, mi.PROGID2, mi.VERSION, u.USER_ID OP_NAME, nvl(i.rec_rpt, 0) TECH_REPORT_ID, case when tsk_type=57 then cast(i.DEV_DATA_FMT as varchar2(100)) else '' end TASK_MODE, jj.j_compl_by JOB_COMPL_BY FROM tm_mtask j join tm_mjob jj on jj.id = j.j_id left join tm_mjob_pset p on p.id = jj.j_sched_indx left outer join TM_USERS u on u.id = j.assn_opid left join (select tsk_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 version) VERSION from tm_mis m, tm_mtsk_it i where m.id = i.mi_id and i.src_dest in (2, 3) group by tsk_id) mi on mi.tsk_id = j.id left join tm_mtsk_it i on i.tsk_id = j.id and i.src_dest = 4 and i.item_idx = 1 where 1=1 AND J_FAILURE_RESOLVED = 0 and j.TSK_STATUS not in (15,18,23,19) AND j.TSK_CLIENT in ('TECHM') order by jj.j_compl_by, j.id , j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Information: 1220 : 10|03:49:02.3990||TechReports is not found. ID: 27. t Information: 1220 : 10|03:49:02.3990||TechReports is not found. ID: 1300. t Information: 1220 : 10|03:49:02.3990||TechReports is not found. ID: 41. t Information: 1220 : 10|03:49:02.3990||TechReports is not found. ID: 96. t Information: 1220 : 10|03:49:02.3990||TechReports is not found. ID: 41. t Information: 1220 : 10|03:49:02.3990||TechReports is not found. ID: 41. t Information: 1220 : 10|03:49:02.3990||TechReports is not found. ID: 41. t Information: 1220 : 10|03:49:02.3990||TechReports is not found. ID: 1300. t Information: 1220 : 10|03:49:02.3990||TechReports is not found. ID: 1300. t Information: 1220 : 10|03:49:02.3990||TechReports is not found. ID: 1300. t Information: 1220 : 10|03:49:02.3990||TechReports is not found. ID: 41. t Information: 1220 : 10|03:49:02.3990||TechReports is not found. ID: 96. t Information: 1220 : 10|03:49:02.3990||TechReports is not found. ID: 96. t Information: 1220 : 10|03:49:02.3990||TechReports is not found. ID: 96. t Information: 1220 : 10|03:49:02.3990||TechReports is not found. ID: 41. t Information: 1220 : 10|03:49:02.3990||TechReports is not found. ID: 41. t Information: 1220 : 10|03:49:02.3990||TechReports is not found. ID: 41. t Information: 1220 : 10|03:49:02.3990||TechReports is not found. ID: 96. t Information: 1220 : 10|03:49:02.3990||TechReports is not found. ID: 252. t Information: 1220 : 10|03:49:02.3990||TechReports is not found. ID: 96. t Information: 1220 : 10|03:49:02.3990||TechReports is not found. ID: 41. t Information: 1220 : 10|03:49:02.3990||TechReports is not found. ID: 116. t Information: 1220 : 10|03:49:02.3990||TechReports is not found. ID: 41. t Information: 1220 : 10|03:49:02.3990||TechReports is not found. ID: 672. t Information: 1220 : 10|03:49:02.3990||TechReports is not found. ID: 41. t Information: 1220 : 10|03:49:02.3990||TechReports is not found. ID: 41. t Information: 1220 : 10|03:49:02.3990||TechReports is not found. ID: 41. t Information: 1220 : 10|03:49:02.3990||TechReports is not found. ID: 41. t Information: 1220 : 10|03:49:02.3990||TechReports is not found. ID: 672. t Information: 1220 : 10|03:49:02.3990||TechReports is not found. ID: 27. t Information: 1220 : 10|03:49:02.3990||TechReports is not found. ID: 96. t Information: 1220 : 10|03:49:02.3990||TechReports is not found. ID: 41. t Information: 1220 : 10|03:49:02.3990||TechReports is not found. ID: 116. t Information: 1220 : 10|03:49:02.3990||TechReports is not found. ID: 41. t Information: 1220 : 10|03:49:02.3990||TechReports is not found. ID: 672. t Information: 1220 : 10|03:49:02.3990||TechReports is not found. ID: 41. t Information: 1220 : 10|03:49:02.3990||TechReports is not found. ID: 41. t Information: 1220 : 10|03:49:02.3990||TechReports is not found. ID: 41. t Information: 1220 : 10|03:49:02.3990||TechReports is not found. ID: 41. t Information: 1220 : 10|03:49:02.3990||TechReports is not found. ID: 672. t Information: 1220 : 10|03:49:02.3990||TechReports is not found. ID: 27. t Information: 1220 : 10|03:49:02.3990||TechReports is not found. ID: 672. t Information: 1220 : 10|03:49:02.3990||TechReports is not found. ID: 27. t Information: 1220 : 10|03:49:02.3990||TechReports is not found. ID: 96. t Transfer: 1220 : 10|03:49:03.5397||IsUserAuthenticated: /api/user-preferences?_dc=1576727343323 t Transfer: 1220 : 10|03:49:03.5397||GetCurrentUser.. t Transfer: 1220 : 10|03:49:03.5397|| OAuth authenticated t Transfer: 1220 : 10|03:49:03.5397|| user BB00567992. t Transfer: 1220 : 10|03:49:03.5397||api user: BB00567992 t Verbose: 1220 : 10|03:49:03.5397||StoreUserDataByKeys.. t Transfer: 1220 : 10|03:49:03.5397||GetCurrentUser.. t Transfer: 1220 : 10|03:49:03.5397|| OAuth authenticated t Transfer: 1220 : 10|03:49:03.5397|| user BB00567992. t Transfer: 1220 : 10|03:49:21.3522||IsUserAuthenticated: /api/view/TaskGrid/1481?_dc=1576727361184 t Transfer: 1220 : 10|03:49:21.3522||GetCurrentUser.. t Transfer: 1220 : 10|03:49:21.3522|| OAuth authenticated t Transfer: 1220 : 10|03:49:21.3522|| user BB00567992. t Transfer: 1220 : 10|03:49:21.3522||api user: BB00567992 t Information: 1220 : 10|03:49:21.3522||UserGridView. LoadView. ID 1481, Name . t Transfer: 1220 : 10|03:49:21.3522||GetCurrentUser.. t Transfer: 1220 : 10|03:49:21.3522|| OAuth authenticated t Transfer: 1220 : 10|03:49:21.3522|| user BB00567992. t Transfer: 1220 : 38|03:53:45.0397||IsUserAuthenticated: /api/view/TaskGrid/1203?_dc=1576727623848 t Transfer: 1220 : 38|03:53:45.0397||GetCurrentUser.. t Transfer: 1220 : 38|03:53:45.0397|| OAuth authenticated t Transfer: 1220 : 38|03:53:45.0397|| user BB00567992. t Transfer: 1220 : 38|03:53:45.0397||api user: BB00567992 t Information: 1220 : 38|03:53:45.0397||UserGridView. LoadView. ID 1203, Name . t Transfer: 1220 : 38|03:53:45.0397||GetCurrentUser.. t Transfer: 1220 : 38|03:53:45.0397|| OAuth authenticated t Transfer: 1220 : 38|03:53:45.0397|| user BB00567992. t Transfer: 1220 : 39|03:53:49.6178||IsUserAuthenticated: /api/search/task?_dc=1576727629052 t Transfer: 1220 : 39|03:53:49.6178||GetCurrentUser.. t Transfer: 1220 : 39|03:53:49.6178|| OAuth authenticated t Transfer: 1220 : 39|03:53:49.6178|| user BB00567992. t Transfer: 1220 : 39|03:53:49.6178||api user: BB00567992 t Information: 1220 : 39|03:53:49.6178||V3Api.SearchTask t Information: 1220 : 39|03:53:49.6178||V3Api.SearchGeneric t Transfer: 1220 : 39|03:53:49.6178||GetCurrentUser.. t Transfer: 1220 : 39|03:53:49.6178|| OAuth authenticated t Transfer: 1220 : 39|03:53:49.6178|| user BB00567992. t Information: 1220 : 39|03:53:49.6335||SearchTask SQL: select * from (select a.*, rownum rnum from ( select /*+ INDEX(j JB_CMBST_IDX) */ /*+ INDEX(j JB_CMBST_IDX) */ j.*, p.pname, mi.MIID1, mi.MIID2, mi.MIID3, mi.VERSIONID1, mi.VERSIONID2, mi.PROGID1, mi.PROGID2, mi.VERSION, u.USER_ID OP_NAME, nvl(i.rec_rpt, 0) TECH_REPORT_ID, case when tsk_type=57 then cast(i.DEV_DATA_FMT as varchar2(100)) else '' end TASK_MODE, jj.j_compl_by JOB_COMPL_BY FROM tm_mtask j join tm_mjob jj on jj.id = j.j_id left join tm_mjob_pset p on p.id = jj.j_sched_indx left outer join TM_USERS u on u.id = j.assn_opid left join (select tsk_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 version) VERSION from tm_mis m, tm_mtsk_it i where m.id = i.mi_id and i.src_dest in (2, 3) group by tsk_id) mi on mi.tsk_id = j.id left join tm_mtsk_it i on i.tsk_id = j.id and i.src_dest = 4 and i.item_idx = 1 where 1=1 AND J_FAILURE_RESOLVED = 0 and j.TSK_STATUS not in (15,18,23,19) AND j.TSK_CLIENT in ('TECHM') order by jj.j_compl_by, j.id , j.id ) a where rownum <= 100) where rnum >= 51 order by rnum t Information: 1220 : 39|03:53:50.1178||TechReports is not found. ID: 41. t Information: 1220 : 39|03:53:50.1178||TechReports is not found. ID: 116. t Information: 1220 : 39|03:53:50.1178||TechReports is not found. ID: 41. t Information: 1220 : 39|03:53:50.1178||TechReports is not found. ID: 672. t Information: 1220 : 39|03:53:50.1178||TechReports is not found. ID: 41. t Information: 1220 : 39|03:53:50.1178||TechReports is not found. ID: 41. t Information: 1220 : 39|03:53:50.1178||TechReports is not found. ID: 41. t Information: 1220 : 39|03:53:50.1178||TechReports is not found. ID: 41. t Information: 1220 : 39|03:53:50.1178||TechReports is not found. ID: 672. t Information: 1220 : 39|03:53:50.1178||TechReports is not found. ID: 27. t Information: 1220 : 39|03:53:50.1178||TechReports is not found. ID: 96. t Information: 1220 : 39|03:53:50.1178||TechReports is not found. ID: 41. t Information: 1220 : 39|03:53:50.1178||TechReports is not found. ID: 116. t Information: 1220 : 39|03:53:50.1334||TechReports is not found. ID: 41. t Information: 1220 : 39|03:53:50.1334||TechReports is not found. ID: 672. t Information: 1220 : 39|03:53:50.1334||TechReports is not found. ID: 41. t Information: 1220 : 39|03:53:50.1334||TechReports is not found. ID: 41. t Information: 1220 : 39|03:53:50.1334||TechReports is not found. ID: 41. t Information: 1220 : 39|03:53:50.1334||TechReports is not found. ID: 41. t Information: 1220 : 39|03:53:50.1334||TechReports is not found. ID: 672. t Information: 1220 : 39|03:53:50.1334||TechReports is not found. ID: 27. t Information: 1220 : 39|03:53:50.1334||TechReports is not found. ID: 27. t Information: 1220 : 39|03:53:50.1334||TechReports is not found. ID: 672. t Information: 1220 : 39|03:53:50.1334||TechReports is not found. ID: 27. t Information: 1220 : 39|03:53:50.1334||TechReports is not found. ID: 672. t Information: 1220 : 39|03:53:50.1334||TechReports is not found. ID: 27. t Information: 1220 : 39|03:53:50.1334||TechReports is not found. ID: 672. t Information: 1220 : 39|03:53:50.1334||TechReports is not found. ID: 27. t Information: 1220 : 39|03:53:50.1334||TechReports is not found. ID: 27. t Information: 1220 : 39|03:53:50.1334||TechReports is not found. ID: 96. t Information: 1220 : 39|03:53:50.1334||TechReports is not found. ID: 41. t Information: 1220 : 39|03:53:50.1334||TechReports is not found. ID: 116. t Information: 1220 : 39|03:53:50.1334||TechReports is not found. ID: 41. t Information: 1220 : 39|03:53:50.1334||TechReports is not found. ID: 672. t Information: 1220 : 39|03:53:50.1334||TechReports is not found. ID: 41. t Information: 1220 : 39|03:53:50.1334||TechReports is not found. ID: 41. t Information: 1220 : 39|03:53:50.1334||TechReports is not found. ID: 41. t Information: 1220 : 39|03:53:50.1334||TechReports is not found. ID: 41. t Transfer: 1220 : 39|03:53:51.6647||IsUserAuthenticated: /api/user-preferences?_dc=1576727631014 t Transfer: 1220 : 39|03:53:51.6647||GetCurrentUser.. t Transfer: 1220 : 39|03:53:51.6647|| OAuth authenticated t Transfer: 1220 : 39|03:53:51.6647|| user BB00567992. t Transfer: 1220 : 39|03:53:51.6647||api user: BB00567992 t Verbose: 1220 : 39|03:53:51.6647||StoreUserDataByKeys.. t Transfer: 1220 : 39|03:53:51.6647||GetCurrentUser.. t Transfer: 1220 : 39|03:53:51.6803|| OAuth authenticated t Transfer: 1220 : 39|03:53:51.6803|| user BB00567992. t Transfer: 1220 : 30|03:53:54.1335||IsUserAuthenticated: /api/search/task?_dc=1576727633542 t Transfer: 1220 : 30|03:53:54.1335||GetCurrentUser.. t Transfer: 1220 : 30|03:53:54.1335|| OAuth authenticated t Transfer: 1220 : 30|03:53:54.1335|| user BB00567992. t Transfer: 1220 : 30|03:53:54.1335||api user: BB00567992 t Information: 1220 : 30|03:53:54.1335||V3Api.SearchTask t Information: 1220 : 30|03:53:54.1335||V3Api.SearchGeneric t Transfer: 1220 : 30|03:53:54.1335||GetCurrentUser.. t Transfer: 1220 : 30|03:53:54.1335|| OAuth authenticated t Transfer: 1220 : 30|03:53:54.1335|| user BB00567992. t Information: 1220 : 30|03:53:54.1491||SearchTask SQL: select * from (select a.*, rownum rnum from ( select /*+ INDEX(j JB_CMBST_IDX) */ /*+ INDEX(j JB_CMBST_IDX) */ j.*, p.pname, mi.MIID1, mi.MIID2, mi.MIID3, mi.VERSIONID1, mi.VERSIONID2, mi.PROGID1, mi.PROGID2, mi.VERSION, u.USER_ID OP_NAME, nvl(i.rec_rpt, 0) TECH_REPORT_ID, case when tsk_type=57 then cast(i.DEV_DATA_FMT as varchar2(100)) else '' end TASK_MODE, jj.j_compl_by JOB_COMPL_BY FROM tm_mtask j join tm_mjob jj on jj.id = j.j_id left join tm_mjob_pset p on p.id = jj.j_sched_indx left outer join TM_USERS u on u.id = j.assn_opid left join (select tsk_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 version) VERSION from tm_mis m, tm_mtsk_it i where m.id = i.mi_id and i.src_dest in (2, 3) group by tsk_id) mi on mi.tsk_id = j.id left join tm_mtsk_it i on i.tsk_id = j.id and i.src_dest = 4 and i.item_idx = 1 where 1=1 AND J_FAILURE_RESOLVED = 0 and j.TSK_STATUS not in (15,18,23,19) AND j.TSK_CLIENT in ('TECHM') order by jj.j_compl_by, j.id , j.id ) a where rownum <= 150) where rnum >= 101 order by rnum t Information: 1220 : 30|03:53:54.6179||TechReports is not found. ID: 672. t Information: 1220 : 30|03:53:54.6179||TechReports is not found. ID: 27. t Information: 1220 : 30|03:53:54.6179||TechReports is not found. ID: 96. t Information: 1220 : 30|03:53:54.6179||TechReports is not found. ID: 116. t Information: 1220 : 30|03:53:54.6179||TechReports is not found. ID: 96. t Information: 1220 : 30|03:53:54.6179||TechReports is not found. ID: 96. t Information: 1220 : 30|03:53:54.6179||TechReports is not found. ID: 41. t Information: 1220 : 30|03:53:54.6179||TechReports is not found. ID: 116. t Information: 1220 : 30|03:53:54.6179||TechReports is not found. ID: 41. t Information: 1220 : 30|03:53:54.6179||TechReports is not found. ID: 672. t Information: 1220 : 30|03:53:54.6179||TechReports is not found. ID: 41. t Information: 1220 : 30|03:53:54.6179||TechReports is not found. ID: 41. t Information: 1220 : 30|03:53:54.6179||TechReports is not found. ID: 41. t Information: 1220 : 30|03:53:54.6179||TechReports is not found. ID: 41. t Information: 1220 : 30|03:53:54.6179||TechReports is not found. ID: 672. t Information: 1220 : 30|03:53:54.6179||TechReports is not found. ID: 27. t Information: 1220 : 30|03:53:54.6179||TechReports is not found. ID: 96. t Information: 1220 : 30|03:53:54.6179||TechReports is not found. ID: 41. t Information: 1220 : 30|03:53:54.6179||TechReports is not found. ID: 116. t Information: 1220 : 30|03:53:54.6179||TechReports is not found. ID: 41. t Information: 1220 : 30|03:53:54.6179||TechReports is not found. ID: 672. t Information: 1220 : 30|03:53:54.6179||TechReports is not found. ID: 41. t Information: 1220 : 30|03:53:54.6179||TechReports is not found. ID: 41. t Information: 1220 : 30|03:53:54.6179||TechReports is not found. ID: 41. t Information: 1220 : 30|03:53:54.6179||TechReports is not found. ID: 41. t Information: 1220 : 30|03:53:54.6179||TechReports is not found. ID: 672. t Information: 1220 : 30|03:53:54.6179||TechReports is not found. ID: 27. t Information: 1220 : 30|03:53:54.6179||TechReports is not found. ID: 672. t Information: 1220 : 30|03:53:54.6179||TechReports is not found. ID: 27. t Information: 1220 : 30|03:53:54.6179||TechReports is not found. ID: 27. t Information: 1220 : 30|03:53:54.6179||TechReports is not found. ID: 96. t Information: 1220 : 30|03:53:54.6179||TechReports is not found. ID: 41. t Information: 1220 : 30|03:53:54.6179||TechReports is not found. ID: 116. t Information: 1220 : 30|03:53:54.6179||TechReports is not found. ID: 41. t Information: 1220 : 30|03:53:54.6179||TechReports is not found. ID: 672. t Information: 1220 : 30|03:53:54.6179||TechReports is not found. ID: 41. t Information: 1220 : 30|03:53:54.6179||TechReports is not found. ID: 41. t Information: 1220 : 30|03:53:54.6179||TechReports is not found. ID: 41. t Information: 1220 : 30|03:53:54.6179||TechReports is not found. ID: 41. t Information: 1220 : 30|03:53:54.6179||TechReports is not found. ID: 672. t Transfer: 1220 : 39|03:53:55.7741||IsUserAuthenticated: /api/user-preferences?_dc=1576727635600 t Transfer: 1220 : 39|03:53:55.7741||GetCurrentUser.. t Transfer: 1220 : 39|03:53:55.7741|| OAuth authenticated t Transfer: 1220 : 39|03:53:55.7741|| user BB00567992. t Transfer: 1220 : 39|03:53:55.7741||api user: BB00567992 t Verbose: 1220 : 39|03:53:55.7741||StoreUserDataByKeys.. t Transfer: 1220 : 39|03:53:55.7741||GetCurrentUser.. t Transfer: 1220 : 39|03:53:55.7741|| OAuth authenticated t Transfer: 1220 : 39|03:53:55.7741|| user BB00567992. t Transfer: 1220 : 30|03:55:34.7116||IsUserAuthenticated: /api/search/task?_dc=1576727734111 t Transfer: 1220 : 30|03:55:34.7116||GetCurrentUser.. t Transfer: 1220 : 30|03:55:34.7116|| OAuth authenticated t Transfer: 1220 : 30|03:55:34.7116|| user BB00567992. t Transfer: 1220 : 30|03:55:34.7116||api user: BB00567992 t Information: 1220 : 30|03:55:34.7116||V3Api.SearchTask t Information: 1220 : 30|03:55:34.7116||V3Api.SearchGeneric t Transfer: 1220 : 30|03:55:34.7116||GetCurrentUser.. t Transfer: 1220 : 30|03:55:34.7116|| OAuth authenticated t Transfer: 1220 : 30|03:55:34.7116|| user BB00567992. t Information: 1220 : 30|03:55:34.7272||SearchTask SQL: select * from (select a.*, rownum rnum from ( select /*+ INDEX(j JB_CMBST_IDX) */ /*+ INDEX(j JB_CMBST_IDX) */ j.*, p.pname, mi.MIID1, mi.MIID2, mi.MIID3, mi.VERSIONID1, mi.VERSIONID2, mi.PROGID1, mi.PROGID2, mi.VERSION, u.USER_ID OP_NAME, nvl(i.rec_rpt, 0) TECH_REPORT_ID, case when tsk_type=57 then cast(i.DEV_DATA_FMT as varchar2(100)) else '' end TASK_MODE, jj.j_compl_by JOB_COMPL_BY FROM tm_mtask j join tm_mjob jj on jj.id = j.j_id left join tm_mjob_pset p on p.id = jj.j_sched_indx left outer join TM_USERS u on u.id = j.assn_opid left join (select tsk_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 version) VERSION from tm_mis m, tm_mtsk_it i where m.id = i.mi_id and i.src_dest in (2, 3) group by tsk_id) mi on mi.tsk_id = j.id left join tm_mtsk_it i on i.tsk_id = j.id and i.src_dest = 4 and i.item_idx = 1 where 1=1 AND J_FAILURE_RESOLVED = 0 and j.TSK_STATUS not in (15,18,23,19) AND j.TSK_CLIENT in ('TECHM') order by jj.j_compl_by, j.id , j.id ) a where rownum <= 200) where rnum >= 151 order by rnum t Information: 1220 : 30|03:55:35.0554||TechReports is not found. ID: 27. t Information: 1220 : 30|03:55:35.0554||TechReports is not found. ID: 96. t Information: 1220 : 30|03:55:35.0554||TechReports is not found. ID: 116. t Information: 1220 : 30|03:55:35.0554||TechReports is not found. ID: 96. t Information: 1220 : 30|03:55:35.0554||TechReports is not found. ID: 96. t Information: 1220 : 30|03:55:35.0554||TechReports is not found. ID: 116. t Information: 1220 : 30|03:55:35.0554||TechReports is not found. ID: 96. t Information: 1220 : 30|03:55:35.0554||TechReports is not found. ID: 96. t Information: 1220 : 30|03:55:35.0554||TechReports is not found. ID: 41. t Information: 1220 : 30|03:55:35.0554||TechReports is not found. ID: 116. t Information: 1220 : 30|03:55:35.0554||TechReports is not found. ID: 41. t Information: 1220 : 30|03:55:35.0554||TechReports is not found. ID: 672. t Information: 1220 : 30|03:55:35.0554||TechReports is not found. ID: 41. t Information: 1220 : 30|03:55:35.0554||TechReports is not found. ID: 41. t Information: 1220 : 30|03:55:35.0554||TechReports is not found. ID: 41. t Information: 1220 : 30|03:55:35.0554||TechReports is not found. ID: 41. t Information: 1220 : 30|03:55:35.0554||TechReports is not found. ID: 672. t Information: 1220 : 30|03:55:35.0554||TechReports is not found. ID: 27. t Information: 1220 : 30|03:55:35.0554||TechReports is not found. ID: 96. t Information: 1220 : 30|03:55:35.0554||TechReports is not found. ID: 116. t Information: 1220 : 30|03:55:35.0554||TechReports is not found. ID: 96. t Information: 1220 : 30|03:55:35.0554||TechReports is not found. ID: 96. t Information: 1220 : 30|03:55:35.0554||TechReports is not found. ID: 41. t Information: 1220 : 30|03:55:35.0554||TechReports is not found. ID: 116. t Information: 1220 : 30|03:55:35.0554||TechReports is not found. ID: 41. t Information: 1220 : 30|03:55:35.0554||TechReports is not found. ID: 672. t Information: 1220 : 30|03:55:35.0554||TechReports is not found. ID: 41. t Information: 1220 : 30|03:55:35.0554||TechReports is not found. ID: 41. t Information: 1220 : 30|03:55:35.0554||TechReports is not found. ID: 41. t Information: 1220 : 30|03:55:35.0554||TechReports is not found. ID: 41. t Information: 1220 : 30|03:55:35.0554||TechReports is not found. ID: 672. t Information: 1220 : 30|03:55:35.0554||TechReports is not found. ID: 27. t Information: 1220 : 30|03:55:35.0554||TechReports is not found. ID: 96. t Information: 1220 : 30|03:55:35.0554||TechReports is not found. ID: 41. t Information: 1220 : 30|03:55:35.0554||TechReports is not found. ID: 116. t Information: 1220 : 30|03:55:35.0554||TechReports is not found. ID: 41. t Information: 1220 : 30|03:55:35.0554||TechReports is not found. ID: 672. t Information: 1220 : 30|03:55:35.0554||TechReports is not found. ID: 41. t Information: 1220 : 30|03:55:35.0554||TechReports is not found. ID: 41. t Information: 1220 : 30|03:55:35.0554||TechReports is not found. ID: 41. t Information: 1220 : 30|03:55:35.0554||TechReports is not found. ID: 41. t Information: 1220 : 30|03:55:35.0554||TechReports is not found. ID: 672. t Transfer: 1220 : 46|03:55:36.6491||IsUserAuthenticated: /api/user-preferences?_dc=1576727736059 t Transfer: 1220 : 46|03:55:36.6491||GetCurrentUser.. t Transfer: 1220 : 46|03:55:36.6491|| OAuth authenticated t Transfer: 1220 : 46|03:55:36.6491|| user BB00567992. t Transfer: 1220 : 46|03:55:36.6491||api user: BB00567992 t Verbose: 1220 : 46|03:55:36.6491||StoreUserDataByKeys.. t Transfer: 1220 : 46|03:55:36.6491||GetCurrentUser.. t Transfer: 1220 : 46|03:55:36.6491|| OAuth authenticated t Transfer: 1220 : 46|03:55:36.6491|| user BB00567992. t Transfer: 1220 : 50|03:56:36.0553||IsUserAuthenticated: /api/search/task?_dc=1576727795478 t Transfer: 1220 : 50|03:56:36.0553||GetCurrentUser.. t Transfer: 1220 : 50|03:56:36.0553|| OAuth authenticated t Transfer: 1220 : 50|03:56:36.0553|| user BB00567992. t Transfer: 1220 : 50|03:56:36.0553||api user: BB00567992 t Information: 1220 : 50|03:56:36.0553||V3Api.SearchTask t Information: 1220 : 50|03:56:36.0553||V3Api.SearchGeneric t Transfer: 1220 : 50|03:56:36.0553||GetCurrentUser.. t Transfer: 1220 : 50|03:56:36.0553|| OAuth authenticated t Transfer: 1220 : 50|03:56:36.0553|| user BB00567992. t Information: 1220 : 50|03:56:36.0553||SearchTask SQL: select * from (select a.*, rownum rnum from ( select /*+ INDEX(j JB_CMBST_IDX) */ /*+ INDEX(j JB_CMBST_IDX) */ j.*, p.pname, mi.MIID1, mi.MIID2, mi.MIID3, mi.VERSIONID1, mi.VERSIONID2, mi.PROGID1, mi.PROGID2, mi.VERSION, u.USER_ID OP_NAME, nvl(i.rec_rpt, 0) TECH_REPORT_ID, case when tsk_type=57 then cast(i.DEV_DATA_FMT as varchar2(100)) else '' end TASK_MODE, jj.j_compl_by JOB_COMPL_BY FROM tm_mtask j join tm_mjob jj on jj.id = j.j_id left join tm_mjob_pset p on p.id = jj.j_sched_indx left outer join TM_USERS u on u.id = j.assn_opid left join (select tsk_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 version) VERSION from tm_mis m, tm_mtsk_it i where m.id = i.mi_id and i.src_dest in (2, 3) group by tsk_id) mi on mi.tsk_id = j.id left join tm_mtsk_it i on i.tsk_id = j.id and i.src_dest = 4 and i.item_idx = 1 where 1=1 AND J_FAILURE_RESOLVED = 0 and j.TSK_STATUS not in (15,18,23,19) AND j.TSK_CLIENT in ('TECHM') order by jj.j_compl_by, j.id , j.id ) a where rownum <= 250) where rnum >= 201 order by rnum t Information: 1220 : 50|03:56:36.3835||TechReports is not found. ID: 27. t Information: 1220 : 50|03:56:36.3835||TechReports is not found. ID: 96. t Information: 1220 : 50|03:56:36.3835||TechReports is not found. ID: 41. t Information: 1220 : 50|03:56:36.3835||TechReports is not found. ID: 116. t Information: 1220 : 50|03:56:36.3835||TechReports is not found. ID: 41. t Information: 1220 : 50|03:56:36.3835||TechReports is not found. ID: 672. t Information: 1220 : 50|03:56:36.3835||TechReports is not found. ID: 41. t Information: 1220 : 50|03:56:36.3835||TechReports is not found. ID: 41. t Information: 1220 : 50|03:56:36.3835||TechReports is not found. ID: 41. t Information: 1220 : 50|03:56:36.3835||TechReports is not found. ID: 41. t Information: 1220 : 50|03:56:36.3991||TechReports is not found. ID: 672. t Information: 1220 : 50|03:56:36.3991||TechReports is not found. ID: 27. t Information: 1220 : 50|03:56:36.3991||TechReports is not found. ID: 96. t Information: 1220 : 50|03:56:36.3991||TechReports is not found. ID: 41. t Information: 1220 : 50|03:56:36.3991||TechReports is not found. ID: 116. t Information: 1220 : 50|03:56:36.3991||TechReports is not found. ID: 41. t Information: 1220 : 50|03:56:36.3991||TechReports is not found. ID: 672. t Information: 1220 : 50|03:56:36.3991||TechReports is not found. ID: 41. t Information: 1220 : 50|03:56:36.3991||TechReports is not found. ID: 41. t Information: 1220 : 50|03:56:36.3991||TechReports is not found. ID: 41. t Information: 1220 : 50|03:56:36.3991||TechReports is not found. ID: 41. t Information: 1220 : 50|03:56:36.3991||TechReports is not found. ID: 672. t Information: 1220 : 50|03:56:36.3991||TechReports is not found. ID: 27. t Information: 1220 : 50|03:56:36.3991||TechReports is not found. ID: 96. t Information: 1220 : 50|03:56:36.3991||TechReports is not found. ID: 41. t Information: 1220 : 50|03:56:36.3991||TechReports is not found. ID: 116. t Information: 1220 : 50|03:56:36.3991||TechReports is not found. ID: 41. t Information: 1220 : 50|03:56:36.3991||TechReports is not found. ID: 672. t Information: 1220 : 50|03:56:36.3991||TechReports is not found. ID: 41. t Information: 1220 : 50|03:56:36.3991||TechReports is not found. ID: 41. t Information: 1220 : 50|03:56:36.3991||TechReports is not found. ID: 41. t Information: 1220 : 50|03:56:36.3991||TechReports is not found. ID: 41. t Information: 1220 : 50|03:56:36.3991||TechReports is not found. ID: 672. t Information: 1220 : 50|03:56:36.3991||TechReports is not found. ID: 27. t Information: 1220 : 50|03:56:36.3991||TechReports is not found. ID: 96. t Information: 1220 : 50|03:56:36.3991||TechReports is not found. ID: 41. t Information: 1220 : 50|03:56:36.3991||TechReports is not found. ID: 116. t Information: 1220 : 50|03:56:36.3991||TechReports is not found. ID: 41. t Information: 1220 : 50|03:56:36.3991||TechReports is not found. ID: 672. t Information: 1220 : 50|03:56:36.3991||TechReports is not found. ID: 41. t Information: 1220 : 50|03:56:36.3991||TechReports is not found. ID: 41. t Information: 1220 : 50|03:56:36.3991||TechReports is not found. ID: 41. t Information: 1220 : 50|03:56:36.3991||TechReports is not found. ID: 41. t Transfer: 1220 : 49|03:56:37.9303||IsUserAuthenticated: /api/user-preferences?_dc=1576727797302 t Transfer: 1220 : 49|03:56:37.9460||GetCurrentUser.. t Transfer: 1220 : 49|03:56:37.9460|| OAuth authenticated t Transfer: 1220 : 49|03:56:37.9460|| user BB00567992. t Transfer: 1220 : 49|03:56:37.9460||api user: BB00567992 t Verbose: 1220 : 49|03:56:37.9460||StoreUserDataByKeys.. t Transfer: 1220 : 49|03:56:37.9460||GetCurrentUser.. t Transfer: 1220 : 49|03:56:37.9460|| OAuth authenticated t Transfer: 1220 : 49|03:56:37.9460|| user BB00567992. t Transfer: 1220 : 48|03:57:23.3835||IsUserAuthenticated: /api/search/task?_dc=1576727842785 t Transfer: 1220 : 48|03:57:23.3835||GetCurrentUser.. t Transfer: 1220 : 48|03:57:23.3835|| OAuth authenticated t Transfer: 1220 : 48|03:57:23.3835|| user BB00567992. t Transfer: 1220 : 48|03:57:23.3835||api user: BB00567992 t Information: 1220 : 48|03:57:23.3835||V3Api.SearchTask t Information: 1220 : 48|03:57:23.3835||V3Api.SearchGeneric t Transfer: 1220 : 48|03:57:23.3835||GetCurrentUser.. t Transfer: 1220 : 48|03:57:23.3835|| OAuth authenticated t Transfer: 1220 : 48|03:57:23.3835|| user BB00567992. t Information: 1220 : 48|03:57:23.3835||SearchTask SQL: select * from (select a.*, rownum rnum from ( select /*+ INDEX(j JB_CMBST_IDX) */ /*+ INDEX(j JB_CMBST_IDX) */ j.*, p.pname, mi.MIID1, mi.MIID2, mi.MIID3, mi.VERSIONID1, mi.VERSIONID2, mi.PROGID1, mi.PROGID2, mi.VERSION, u.USER_ID OP_NAME, nvl(i.rec_rpt, 0) TECH_REPORT_ID, case when tsk_type=57 then cast(i.DEV_DATA_FMT as varchar2(100)) else '' end TASK_MODE, jj.j_compl_by JOB_COMPL_BY FROM tm_mtask j join tm_mjob jj on jj.id = j.j_id left join tm_mjob_pset p on p.id = jj.j_sched_indx left outer join TM_USERS u on u.id = j.assn_opid left join (select tsk_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 version) VERSION from tm_mis m, tm_mtsk_it i where m.id = i.mi_id and i.src_dest in (2, 3) group by tsk_id) mi on mi.tsk_id = j.id left join tm_mtsk_it i on i.tsk_id = j.id and i.src_dest = 4 and i.item_idx = 1 where 1=1 AND J_FAILURE_RESOLVED = 0 and j.TSK_STATUS not in (15,18,23,19) AND j.TSK_CLIENT in ('TECHM') order by jj.j_compl_by, j.id , j.id ) a where rownum <= 300) where rnum >= 251 order by rnum t Information: 1220 : 48|03:57:23.6960||TechReports is not found. ID: 672. t Information: 1220 : 48|03:57:23.6960||TechReports is not found. ID: 27. t Information: 1220 : 48|03:57:23.6960||TechReports is not found. ID: 96. t Information: 1220 : 48|03:57:23.6960||TechReports is not found. ID: 41. t Information: 1220 : 48|03:57:23.6960||TechReports is not found. ID: 116. t Information: 1220 : 48|03:57:23.6960||TechReports is not found. ID: 41. t Information: 1220 : 48|03:57:23.6960||TechReports is not found. ID: 672. t Information: 1220 : 48|03:57:23.6960||TechReports is not found. ID: 41. t Information: 1220 : 48|03:57:23.6960||TechReports is not found. ID: 41. t Information: 1220 : 48|03:57:23.6960||TechReports is not found. ID: 41. t Information: 1220 : 48|03:57:23.6960||TechReports is not found. ID: 41. t Information: 1220 : 48|03:57:23.6960||TechReports is not found. ID: 672. t Information: 1220 : 48|03:57:23.6960||TechReports is not found. ID: 27. t Information: 1220 : 48|03:57:23.6960||TechReports is not found. ID: 1300. t Information: 1220 : 48|03:57:23.6960||TechReports is not found. ID: 672. t Information: 1220 : 48|03:57:23.6960||TechReports is not found. ID: 27. t Information: 1220 : 48|03:57:23.6960||TechReports is not found. ID: 27. t Transfer: 1220 : 48|03:57:25.0866||IsUserAuthenticated: /api/user-preferences?_dc=1576727844513 t Transfer: 1220 : 48|03:57:25.0866||GetCurrentUser.. t Transfer: 1220 : 48|03:57:25.0866|| OAuth authenticated t Transfer: 1220 : 48|03:57:25.0866|| user BB00567992. t Transfer: 1220 : 48|03:57:25.0866||api user: BB00567992 t Verbose: 1220 : 48|03:57:25.0866||StoreUserDataByKeys.. t Transfer: 1220 : 48|03:57:25.0866||GetCurrentUser.. t Transfer: 1220 : 48|03:57:25.0866|| OAuth authenticated t Transfer: 1220 : 48|03:57:25.0866|| user BB00567992. t Transfer: 1220 : 38|03:58:33.0397||IsUserAuthenticated: /api/v3/layout/default/3?_dc=1576727911852 t Transfer: 1220 : 38|03:58:33.0397||GetCurrentUser.. t Transfer: 1220 : 38|03:58:33.0397|| OAuth authenticated t Transfer: 1220 : 38|03:58:33.0397|| user BB00567992. t Transfer: 1220 : 38|03:58:33.0397||api user: BB00567992 t Information: 1220 : 38|03:58:33.0397||LoadDefaultDashboard. t Transfer: 1220 : 38|03:58:33.0397||GetCurrentUser.. t Transfer: 1220 : 38|03:58:33.0397|| OAuth authenticated t Transfer: 1220 : 38|03:58:33.0397|| user BB00567992. t Transfer: 1220 : 51|03:58:38.3679||IsUserAuthenticated: /api/search/workflow?_dc=1576727917608 t Transfer: 1220 : 51|03:58:38.3679||GetCurrentUser.. t Transfer: 1220 : 51|03:58:38.3679|| OAuth authenticated t Transfer: 1220 : 51|03:58:38.3679|| user BB00567992. t Transfer: 1220 : 51|03:58:38.3679||api user: BB00567992 t Information: 1220 : 51|03:58:38.3679||V3Api.SearchWorkflows t Information: 1220 : 51|03:58:38.3679||V3Api.SearchGeneric t Transfer: 1220 : 51|03:58:38.3835||GetCurrentUser.. t Transfer: 1220 : 51|03:58:38.3835|| OAuth authenticated t Transfer: 1220 : 51|03:58:38.3835|| user BB00567992. t Information: 1220 : 51|03:58:38.3991||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 ('TECHM') order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Information: 1220 : 51|03:58:38.6960|| jobs returned 37, searched in 00:00:00.2967217 t Information: 1220 : 51|03:58:38.8366||TechReports is not found. ID: 27. t Information: 1220 : 51|03:58:38.8366||TechReports is not found. ID: 1300. t Information: 1220 : 51|03:58:38.8366||TechReports is not found. ID: 41. t Information: 1220 : 51|03:58:38.8366||TechReports is not found. ID: 96. t Information: 1220 : 51|03:58:38.8366||TechReports is not found. ID: 252. t Information: 1220 : 51|03:58:38.8366||TechReports is not found. ID: 116. t Information: 1220 : 51|03:58:38.8366||TechReports is not found. ID: 672. t Information: 1220 : 51|03:58:38.8366|| tasks returned 37, searched in 00:00:00.1344995 t Transfer: 1220 : 51|03:58:41.6960||IsUserAuthenticated: /api/search/workflow?_dc=1576727920952 t Transfer: 1220 : 51|03:58:41.6960||GetCurrentUser.. t Transfer: 1220 : 51|03:58:41.6960|| OAuth authenticated t Transfer: 1220 : 51|03:58:41.6960|| user BB00567992. t Transfer: 1220 : 51|03:58:41.6960||api user: BB00567992 t Information: 1220 : 51|03:58:41.6960||V3Api.SearchWorkflows t Information: 1220 : 51|03:58:41.6960||V3Api.SearchGeneric t Transfer: 1220 : 51|03:58:41.6960||GetCurrentUser.. t Transfer: 1220 : 51|03:58:41.6960|| OAuth authenticated t Transfer: 1220 : 51|03:58:41.7116|| user BB00567992. t Information: 1220 : 51|03:58:41.7116||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 ('TECHM') order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Information: 1220 : 51|03:58:41.8991|| jobs returned 37, searched in 00:00:00.1897321 t Information: 1220 : 51|03:58:42.0710||TechReports is not found. ID: 27. t Information: 1220 : 51|03:58:42.0710||TechReports is not found. ID: 1300. t Information: 1220 : 51|03:58:42.0710||TechReports is not found. ID: 41. t Information: 1220 : 51|03:58:42.0710||TechReports is not found. ID: 96. t Information: 1220 : 51|03:58:42.0710||TechReports is not found. ID: 252. t Information: 1220 : 51|03:58:42.0710||TechReports is not found. ID: 116. t Information: 1220 : 51|03:58:42.0710||TechReports is not found. ID: 672. t Information: 1220 : 51|03:58:42.0710|| tasks returned 37, searched in 00:00:00.1706843 t Transfer: 1220 : 51|03:58:56.1804||IsUserAuthenticated: /api/search/workflow?_dc=1576727935963 t Transfer: 1220 : 51|03:58:56.1804||GetCurrentUser.. t Transfer: 1220 : 51|03:58:56.1804|| OAuth authenticated t Transfer: 1220 : 51|03:58:56.1804|| user BB00567992. t Transfer: 1220 : 51|03:58:56.1804||api user: BB00567992 t Information: 1220 : 51|03:58:56.1804||V3Api.SearchWorkflows t Information: 1220 : 51|03:58:56.1804||V3Api.SearchGeneric t Transfer: 1220 : 51|03:58:56.1804||GetCurrentUser.. t Transfer: 1220 : 51|03:58:56.1804|| OAuth authenticated t Transfer: 1220 : 51|03:58:56.1804|| user BB00567992. t Information: 1220 : 51|03:58:56.1804||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 ('TECHM') order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Information: 1220 : 51|03:58:56.2116|| jobs returned 37, searched in 00:00:00.0289227 t Information: 1220 : 51|03:58:56.3366||TechReports is not found. ID: 27. t Information: 1220 : 51|03:58:56.3366||TechReports is not found. ID: 1300. t Information: 1220 : 51|03:58:56.3366||TechReports is not found. ID: 41. t Information: 1220 : 51|03:58:56.3366||TechReports is not found. ID: 96. t Information: 1220 : 51|03:58:56.3366||TechReports is not found. ID: 252. t Information: 1220 : 51|03:58:56.3366||TechReports is not found. ID: 116. t Information: 1220 : 51|03:58:56.3366||TechReports is not found. ID: 672. t Information: 1220 : 51|03:58:56.3366|| tasks returned 37, searched in 00:00:00.1217358 t Transfer: 1220 : 48|03:59:11.2116||IsUserAuthenticated: /api/search/workflow?_dc=1576727950963 t Transfer: 1220 : 48|03:59:11.2116||GetCurrentUser.. t Transfer: 1220 : 48|03:59:11.2116|| OAuth authenticated t Transfer: 1220 : 48|03:59:11.2116|| user BB00567992. t Transfer: 1220 : 48|03:59:11.2116||api user: BB00567992 t Information: 1220 : 48|03:59:11.2116||V3Api.SearchWorkflows t Information: 1220 : 48|03:59:11.2116||V3Api.SearchGeneric t Transfer: 1220 : 48|03:59:11.2116||GetCurrentUser.. t Transfer: 1220 : 48|03:59:11.2116|| OAuth authenticated t Transfer: 1220 : 48|03:59:11.2116|| user BB00567992. t Information: 1220 : 48|03:59:11.2116||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 ('TECHM') order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Information: 1220 : 48|03:59:11.2429|| jobs returned 37, searched in 00:00:00.0283586 t Information: 1220 : 48|03:59:11.3366||TechReports is not found. ID: 27. t Information: 1220 : 48|03:59:11.3366||TechReports is not found. ID: 1300. t Information: 1220 : 48|03:59:11.3366||TechReports is not found. ID: 41. t Information: 1220 : 48|03:59:11.3366||TechReports is not found. ID: 96. t Information: 1220 : 48|03:59:11.3366||TechReports is not found. ID: 252. t Information: 1220 : 48|03:59:11.3366||TechReports is not found. ID: 116. t Information: 1220 : 48|03:59:11.3366||TechReports is not found. ID: 672. t Information: 1220 : 48|03:59:11.3366|| tasks returned 37, searched in 00:00:00.0953528 t Transfer: 1220 : 38|03:59:26.1178||IsUserAuthenticated: /api/search/workflow?_dc=1576727965958 t Transfer: 1220 : 38|03:59:26.1178||GetCurrentUser.. t Transfer: 1220 : 38|03:59:26.1178|| OAuth authenticated t Transfer: 1220 : 38|03:59:26.1178|| user BB00567992. t Transfer: 1220 : 38|03:59:26.1178||api user: BB00567992 t Information: 1220 : 38|03:59:26.1178||V3Api.SearchWorkflows t Information: 1220 : 38|03:59:26.1178||V3Api.SearchGeneric t Transfer: 1220 : 38|03:59:26.1178||GetCurrentUser.. t Transfer: 1220 : 38|03:59:26.1178|| OAuth authenticated t Transfer: 1220 : 38|03:59:26.1178|| user BB00567992. t Information: 1220 : 38|03:59:26.1334||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 ('TECHM') order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Information: 1220 : 38|03:59:26.1490|| jobs returned 37, searched in 00:00:00.0279190 t Information: 1220 : 38|03:59:26.3834||TechReports is not found. ID: 27. t Information: 1220 : 38|03:59:26.3834||TechReports is not found. ID: 1300. t Information: 1220 : 38|03:59:26.3834||TechReports is not found. ID: 41. t Information: 1220 : 38|03:59:26.3834||TechReports is not found. ID: 96. t Information: 1220 : 38|03:59:26.3834||TechReports is not found. ID: 252. t Information: 1220 : 38|03:59:26.3834||TechReports is not found. ID: 116. t Information: 1220 : 38|03:59:26.3834||TechReports is not found. ID: 672. t Information: 1220 : 38|03:59:26.3834|| tasks returned 37, searched in 00:00:00.2217875 t Transfer: 1220 : 36|03:59:41.1646||IsUserAuthenticated: /api/search/workflow?_dc=1576727980954 t Transfer: 1220 : 36|03:59:41.1646||GetCurrentUser.. t Transfer: 1220 : 36|03:59:41.1646|| OAuth authenticated t Transfer: 1220 : 36|03:59:41.1646|| user BB00567992. t Transfer: 1220 : 36|03:59:41.1646||api user: BB00567992 t Information: 1220 : 36|03:59:41.1646||V3Api.SearchWorkflows t Information: 1220 : 36|03:59:41.1646||V3Api.SearchGeneric t Transfer: 1220 : 36|03:59:41.1646||GetCurrentUser.. t Transfer: 1220 : 36|03:59:41.1646|| OAuth authenticated t Transfer: 1220 : 36|03:59:41.1646|| user BB00567992. t Information: 1220 : 36|03:59:41.1646||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 ('TECHM') order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Information: 1220 : 36|03:59:41.1959|| jobs returned 37, searched in 00:00:00.0276934 t Information: 1220 : 36|03:59:41.3209||TechReports is not found. ID: 27. t Information: 1220 : 36|03:59:41.3209||TechReports is not found. ID: 1300. t Information: 1220 : 36|03:59:41.3209||TechReports is not found. ID: 41. t Information: 1220 : 36|03:59:41.3209||TechReports is not found. ID: 96. t Information: 1220 : 36|03:59:41.3209||TechReports is not found. ID: 252. t Information: 1220 : 36|03:59:41.3209||TechReports is not found. ID: 116. t Information: 1220 : 36|03:59:41.3209||TechReports is not found. ID: 672. t Information: 1220 : 36|03:59:41.3209|| tasks returned 37, searched in 00:00:00.1277881 t Transfer: 1220 : 38|03:59:56.7584||IsUserAuthenticated: /api/search/workflow?_dc=1576727995964 t Transfer: 1220 : 38|03:59:56.7584||GetCurrentUser.. t Transfer: 1220 : 38|03:59:56.7584|| OAuth authenticated t Transfer: 1220 : 38|03:59:56.7584|| user BB00567992. t Transfer: 1220 : 38|03:59:56.7584||api user: BB00567992 t Information: 1220 : 38|03:59:56.7584||V3Api.SearchWorkflows t Information: 1220 : 38|03:59:56.7584||V3Api.SearchGeneric t Transfer: 1220 : 38|03:59:56.7584||GetCurrentUser.. t Transfer: 1220 : 38|03:59:56.7584|| OAuth authenticated t Transfer: 1220 : 38|03:59:56.7584|| user BB00567992. t Information: 1220 : 38|03:59:56.7584||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 ('TECHM') order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Information: 1220 : 38|03:59:56.7896|| jobs returned 37, searched in 00:00:00.0281186 t Information: 1220 : 38|03:59:56.8834||TechReports is not found. ID: 27. t Information: 1220 : 38|03:59:56.8834||TechReports is not found. ID: 1300. t Information: 1220 : 38|03:59:56.8834||TechReports is not found. ID: 41. t Information: 1220 : 38|03:59:56.8834||TechReports is not found. ID: 96. t Information: 1220 : 38|03:59:56.8834||TechReports is not found. ID: 252. t Information: 1220 : 38|03:59:56.8834||TechReports is not found. ID: 116. t Information: 1220 : 38|03:59:56.8834||TechReports is not found. ID: 672. t Information: 1220 : 38|03:59:56.8834|| tasks returned 37, searched in 00:00:00.0965845 t Transfer: 1220 : 50|04:00:11.8053||IsUserAuthenticated: /api/search/workflow?_dc=1576728010966 t Transfer: 1220 : 50|04:00:11.8053||GetCurrentUser.. t Transfer: 1220 : 50|04:00:11.8053|| OAuth authenticated t Transfer: 1220 : 50|04:00:11.8053|| user BB00567992. t Transfer: 1220 : 50|04:00:11.8053||api user: BB00567992 t Information: 1220 : 50|04:00:11.8053||V3Api.SearchWorkflows t Information: 1220 : 50|04:00:11.8053||V3Api.SearchGeneric t Transfer: 1220 : 50|04:00:11.8053||GetCurrentUser.. t Transfer: 1220 : 50|04:00:11.8053|| OAuth authenticated t Transfer: 1220 : 50|04:00:11.8053|| user BB00567992. t Information: 1220 : 50|04:00:11.8209||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 ('TECHM') order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Information: 1220 : 50|04:00:11.8365|| jobs returned 37, searched in 00:00:00.0286688 t Information: 1220 : 50|04:00:12.0553||TechReports is not found. ID: 27. t Information: 1220 : 50|04:00:12.0553||TechReports is not found. ID: 1300. t Information: 1220 : 50|04:00:12.0553||TechReports is not found. ID: 41. t Information: 1220 : 50|04:00:12.0553||TechReports is not found. ID: 96. t Information: 1220 : 50|04:00:12.0553||TechReports is not found. ID: 252. t Information: 1220 : 50|04:00:12.0553||TechReports is not found. ID: 116. t Information: 1220 : 50|04:00:12.0553||TechReports is not found. ID: 672. t Information: 1220 : 50|04:00:12.0553|| tasks returned 37, searched in 00:00:00.2112529 t Transfer: 1220 : 48|04:00:26.1490||IsUserAuthenticated: /api/search/workflow?_dc=1576728025964 t Transfer: 1220 : 48|04:00:26.1490||GetCurrentUser.. t Transfer: 1220 : 48|04:00:26.1490|| OAuth authenticated t Transfer: 1220 : 48|04:00:26.1490|| user BB00567992. t Transfer: 1220 : 48|04:00:26.1490||api user: BB00567992 t Information: 1220 : 48|04:00:26.1490||V3Api.SearchWorkflows t Information: 1220 : 48|04:00:26.1490||V3Api.SearchGeneric t Transfer: 1220 : 48|04:00:26.1490||GetCurrentUser.. t Transfer: 1220 : 48|04:00:26.1490|| OAuth authenticated t Transfer: 1220 : 48|04:00:26.1490|| user BB00567992. t Information: 1220 : 48|04:00:26.1646||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 ('TECHM') order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Information: 1220 : 48|04:00:26.1959|| jobs returned 37, searched in 00:00:00.0328186 t Information: 1220 : 48|04:00:26.3365||TechReports is not found. ID: 27. t Information: 1220 : 48|04:00:26.3365||TechReports is not found. ID: 1300. t Information: 1220 : 48|04:00:26.3365||TechReports is not found. ID: 41. t Information: 1220 : 48|04:00:26.3365||TechReports is not found. ID: 96. t Information: 1220 : 48|04:00:26.3365||TechReports is not found. ID: 252. t Information: 1220 : 48|04:00:26.3365||TechReports is not found. ID: 116. t Information: 1220 : 48|04:00:26.3365||TechReports is not found. ID: 672. t Information: 1220 : 48|04:00:26.3365|| tasks returned 37, searched in 00:00:00.1496476 t Transfer: 1220 : 43|04:00:41.7584||IsUserAuthenticated: /api/search/workflow?_dc=1576728040968 t Transfer: 1220 : 43|04:00:41.7584||GetCurrentUser.. t Transfer: 1220 : 43|04:00:41.7584|| OAuth authenticated t Transfer: 1220 : 43|04:00:41.7584|| user BB00567992. t Transfer: 1220 : 43|04:00:41.7584||api user: BB00567992 t Information: 1220 : 43|04:00:41.7584||V3Api.SearchWorkflows t Information: 1220 : 43|04:00:41.7584||V3Api.SearchGeneric t Transfer: 1220 : 43|04:00:41.7584||GetCurrentUser.. t Transfer: 1220 : 43|04:00:41.7584|| OAuth authenticated t Transfer: 1220 : 43|04:00:41.7584|| user BB00567992. t Information: 1220 : 43|04:00:41.7584||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 ('TECHM') order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Information: 1220 : 43|04:00:41.8052|| jobs returned 37, searched in 00:00:00.0423242 t Information: 1220 : 43|04:00:41.8990||TechReports is not found. ID: 27. t Information: 1220 : 43|04:00:41.8990||TechReports is not found. ID: 1300. t Information: 1220 : 43|04:00:41.8990||TechReports is not found. ID: 41. t Information: 1220 : 43|04:00:41.8990||TechReports is not found. ID: 96. t Information: 1220 : 43|04:00:41.8990||TechReports is not found. ID: 252. t Information: 1220 : 43|04:00:41.8990||TechReports is not found. ID: 116. t Information: 1220 : 43|04:00:41.8990||TechReports is not found. ID: 672. t Information: 1220 : 43|04:00:41.8990|| tasks returned 37, searched in 00:00:00.1004916 t Transfer: 1220 : 45|04:00:56.7427||IsUserAuthenticated: /api/search/workflow?_dc=1576728055967 t Transfer: 1220 : 45|04:00:56.7427||GetCurrentUser.. t Transfer: 1220 : 45|04:00:56.7427|| OAuth authenticated t Transfer: 1220 : 45|04:00:56.7427|| user BB00567992. t Transfer: 1220 : 45|04:00:56.7427||api user: BB00567992 t Information: 1220 : 45|04:00:56.7427||V3Api.SearchWorkflows t Information: 1220 : 45|04:00:56.7427||V3Api.SearchGeneric t Transfer: 1220 : 45|04:00:56.7427||GetCurrentUser.. t Transfer: 1220 : 45|04:00:56.7427|| OAuth authenticated t Transfer: 1220 : 45|04:00:56.7427|| user BB00567992. t Information: 1220 : 45|04:00:56.7584||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 ('TECHM') order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Information: 1220 : 45|04:00:56.7740|| jobs returned 37, searched in 00:00:00.0269907 t Information: 1220 : 45|04:00:56.8834||TechReports is not found. ID: 27. t Information: 1220 : 45|04:00:56.8834||TechReports is not found. ID: 1300. t Information: 1220 : 45|04:00:56.8834||TechReports is not found. ID: 41. t Information: 1220 : 45|04:00:56.8834||TechReports is not found. ID: 96. t Information: 1220 : 45|04:00:56.8834||TechReports is not found. ID: 252. t Information: 1220 : 45|04:00:56.8834||TechReports is not found. ID: 116. t Information: 1220 : 45|04:00:56.8834||TechReports is not found. ID: 672. t Information: 1220 : 45|04:00:56.8834|| tasks returned 37, searched in 00:00:00.1042613 t Transfer: 1220 : 47|04:01:11.1646||IsUserAuthenticated: /api/search/workflow?_dc=1576728070968 t Transfer: 1220 : 47|04:01:11.1646||GetCurrentUser.. t Transfer: 1220 : 47|04:01:11.1646|| OAuth authenticated t Transfer: 1220 : 47|04:01:11.1646|| user BB00567992. t Transfer: 1220 : 47|04:01:11.1646||api user: BB00567992 t Information: 1220 : 47|04:01:11.1646||V3Api.SearchWorkflows t Information: 1220 : 47|04:01:11.1646||V3Api.SearchGeneric t Transfer: 1220 : 47|04:01:11.1646||GetCurrentUser.. t Transfer: 1220 : 47|04:01:11.1646|| OAuth authenticated t Transfer: 1220 : 47|04:01:11.1646|| user BB00567992. t Information: 1220 : 47|04:01:11.1646||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 ('TECHM') order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Information: 1220 : 47|04:01:11.2115|| jobs returned 37, searched in 00:00:00.0459908 t Information: 1220 : 47|04:01:11.3365||TechReports is not found. ID: 27. t Information: 1220 : 47|04:01:11.3365||TechReports is not found. ID: 1300. t Information: 1220 : 47|04:01:11.3365||TechReports is not found. ID: 41. t Information: 1220 : 47|04:01:11.3365||TechReports is not found. ID: 96. t Information: 1220 : 47|04:01:11.3365||TechReports is not found. ID: 252. t Information: 1220 : 47|04:01:11.3365||TechReports is not found. ID: 116. t Information: 1220 : 47|04:01:11.3365||TechReports is not found. ID: 672. t Information: 1220 : 47|04:01:11.3365|| tasks returned 37, searched in 00:00:00.1168797 t Transfer: 1220 : 45|04:01:26.1959||IsUserAuthenticated: /api/search/workflow?_dc=1576728085958 t Transfer: 1220 : 45|04:01:26.1959||GetCurrentUser.. t Transfer: 1220 : 45|04:01:26.1959|| OAuth authenticated t Transfer: 1220 : 45|04:01:26.1959|| user BB00567992. t Transfer: 1220 : 45|04:01:26.1959||api user: BB00567992 t Information: 1220 : 45|04:01:26.1959||V3Api.SearchWorkflows t Information: 1220 : 45|04:01:26.1959||V3Api.SearchGeneric t Transfer: 1220 : 45|04:01:26.1959||GetCurrentUser.. t Transfer: 1220 : 45|04:01:26.1959|| OAuth authenticated t Transfer: 1220 : 45|04:01:26.1959|| user BB00567992. t Information: 1220 : 45|04:01:26.1959||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 ('TECHM') order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Information: 1220 : 45|04:01:26.2271|| jobs returned 37, searched in 00:00:00.0306171 t Information: 1220 : 45|04:01:26.3678||TechReports is not found. ID: 27. t Information: 1220 : 45|04:01:26.3834||TechReports is not found. ID: 1300. t Information: 1220 : 45|04:01:26.3834||TechReports is not found. ID: 41. t Information: 1220 : 45|04:01:26.3834||TechReports is not found. ID: 96. t Information: 1220 : 45|04:01:26.3834||TechReports is not found. ID: 252. t Information: 1220 : 45|04:01:26.3834||TechReports is not found. ID: 116. t Information: 1220 : 45|04:01:26.3834||TechReports is not found. ID: 672. t Information: 1220 : 45|04:01:26.3834|| tasks returned 37, searched in 00:00:00.1452189 t Transfer: 1220 : 45|04:01:41.1177||IsUserAuthenticated: /api/search/workflow?_dc=1576728100960 t Transfer: 1220 : 45|04:01:41.1177||GetCurrentUser.. t Transfer: 1220 : 45|04:01:41.1177|| OAuth authenticated t Transfer: 1220 : 45|04:01:41.1177|| user BB00567992. t Transfer: 1220 : 45|04:01:41.1177||api user: BB00567992 t Information: 1220 : 45|04:01:41.1177||V3Api.SearchWorkflows t Information: 1220 : 45|04:01:41.1177||V3Api.SearchGeneric t Transfer: 1220 : 45|04:01:41.1177||GetCurrentUser.. t Transfer: 1220 : 45|04:01:41.1177|| OAuth authenticated t Transfer: 1220 : 45|04:01:41.1177|| user BB00567992. t Information: 1220 : 45|04:01:41.1334||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 ('TECHM') order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Information: 1220 : 45|04:01:41.1646|| jobs returned 37, searched in 00:00:00.0396396 t Information: 1220 : 45|04:01:41.2740||TechReports is not found. ID: 27. t Information: 1220 : 45|04:01:41.2740||TechReports is not found. ID: 1300. t Information: 1220 : 45|04:01:41.2740||TechReports is not found. ID: 41. t Information: 1220 : 45|04:01:41.2740||TechReports is not found. ID: 96. t Information: 1220 : 45|04:01:41.2740||TechReports is not found. ID: 252. t Information: 1220 : 45|04:01:41.2740||TechReports is not found. ID: 116. t Information: 1220 : 45|04:01:41.2740||TechReports is not found. ID: 672. t Information: 1220 : 45|04:01:41.2740|| tasks returned 37, searched in 00:00:00.1124975 t Transfer: 1220 : 50|04:01:56.1490||IsUserAuthenticated: /api/search/workflow?_dc=1576728115958 t Transfer: 1220 : 50|04:01:56.1490||GetCurrentUser.. t Transfer: 1220 : 50|04:01:56.1490|| OAuth authenticated t Transfer: 1220 : 50|04:01:56.1490|| user BB00567992. t Transfer: 1220 : 50|04:01:56.1490||api user: BB00567992 t Information: 1220 : 50|04:01:56.1490||V3Api.SearchWorkflows t Information: 1220 : 50|04:01:56.1490||V3Api.SearchGeneric t Transfer: 1220 : 50|04:01:56.1490||GetCurrentUser.. t Transfer: 1220 : 50|04:01:56.1490|| OAuth authenticated t Transfer: 1220 : 50|04:01:56.1490|| user BB00567992. t Information: 1220 : 50|04:01:56.1490||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 ('TECHM') order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Information: 1220 : 50|04:01:56.1803|| jobs returned 37, searched in 00:00:00.0304774 t Information: 1220 : 50|04:01:56.3521||TechReports is not found. ID: 27. t Information: 1220 : 50|04:01:56.3521||TechReports is not found. ID: 1300. t Information: 1220 : 50|04:01:56.3521||TechReports is not found. ID: 41. t Information: 1220 : 50|04:01:56.3521||TechReports is not found. ID: 96. t Information: 1220 : 50|04:01:56.3521||TechReports is not found. ID: 252. t Information: 1220 : 50|04:01:56.3521||TechReports is not found. ID: 116. t Information: 1220 : 50|04:01:56.3521||TechReports is not found. ID: 672. t Information: 1220 : 50|04:01:56.3521|| tasks returned 37, searched in 00:00:00.1594834 t Transfer: 1220 : 38|04:02:11.2115||IsUserAuthenticated: /api/search/workflow?_dc=1576728130968 t Transfer: 1220 : 38|04:02:11.2115||GetCurrentUser.. t Transfer: 1220 : 38|04:02:11.2115|| OAuth authenticated t Transfer: 1220 : 38|04:02:11.2115|| user BB00567992. t Transfer: 1220 : 38|04:02:11.2115||api user: BB00567992 t Information: 1220 : 38|04:02:11.2115||V3Api.SearchWorkflows t Information: 1220 : 38|04:02:11.2115||V3Api.SearchGeneric t Transfer: 1220 : 38|04:02:11.2115||GetCurrentUser.. t Transfer: 1220 : 38|04:02:11.2115|| OAuth authenticated t Transfer: 1220 : 38|04:02:11.2115|| user BB00567992. t Information: 1220 : 38|04:02:11.2115||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 ('TECHM') order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Information: 1220 : 38|04:02:11.2584|| jobs returned 37, searched in 00:00:00.0386416 t Information: 1220 : 38|04:02:11.3365||TechReports is not found. ID: 27. t Information: 1220 : 38|04:02:11.3365||TechReports is not found. ID: 1300. t Information: 1220 : 38|04:02:11.3365||TechReports is not found. ID: 41. t Information: 1220 : 38|04:02:11.3365||TechReports is not found. ID: 96. t Information: 1220 : 38|04:02:11.3365||TechReports is not found. ID: 252. t Information: 1220 : 38|04:02:11.3365||TechReports is not found. ID: 116. t Information: 1220 : 38|04:02:11.3365||TechReports is not found. ID: 672. t Information: 1220 : 38|04:02:11.3365|| tasks returned 37, searched in 00:00:00.0847937 t Transfer: 1220 : 46|04:02:26.1334||IsUserAuthenticated: /api/search/workflow?_dc=1576728145955 t Transfer: 1220 : 46|04:02:26.1334||GetCurrentUser.. t Transfer: 1220 : 46|04:02:26.1334|| OAuth authenticated t Transfer: 1220 : 46|04:02:26.1334|| user BB00567992. t Transfer: 1220 : 46|04:02:26.1334||api user: BB00567992 t Information: 1220 : 46|04:02:26.1334||V3Api.SearchWorkflows t Information: 1220 : 46|04:02:26.1334||V3Api.SearchGeneric t Transfer: 1220 : 46|04:02:26.1334||GetCurrentUser.. t Transfer: 1220 : 46|04:02:26.1334|| OAuth authenticated t Transfer: 1220 : 46|04:02:26.1334|| user BB00567992. t Information: 1220 : 46|04:02:26.1334||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 ('TECHM') order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Information: 1220 : 46|04:02:26.1647|| jobs returned 37, searched in 00:00:00.0265986 t Information: 1220 : 46|04:02:26.3522||TechReports is not found. ID: 27. t Information: 1220 : 46|04:02:26.3522||TechReports is not found. ID: 1300. t Information: 1220 : 46|04:02:26.3522||TechReports is not found. ID: 41. t Information: 1220 : 46|04:02:26.3522||TechReports is not found. ID: 96. t Information: 1220 : 46|04:02:26.3522||TechReports is not found. ID: 252. t Information: 1220 : 46|04:02:26.3522||TechReports is not found. ID: 116. t Information: 1220 : 46|04:02:26.3522||TechReports is not found. ID: 672. t Information: 1220 : 46|04:02:26.3522|| tasks returned 37, searched in 00:00:00.1944157 t Transfer: 1220 : 51|04:02:41.7740||IsUserAuthenticated: /api/search/workflow?_dc=1576728160972 t Transfer: 1220 : 51|04:02:41.7740||GetCurrentUser.. t Transfer: 1220 : 51|04:02:41.7740|| OAuth authenticated t Transfer: 1220 : 51|04:02:41.7740|| user BB00567992. t Transfer: 1220 : 51|04:02:41.7740||api user: BB00567992 t Information: 1220 : 51|04:02:41.7740||V3Api.SearchWorkflows t Information: 1220 : 51|04:02:41.7740||V3Api.SearchGeneric t Transfer: 1220 : 51|04:02:41.7740||GetCurrentUser.. t Transfer: 1220 : 51|04:02:41.7740|| OAuth authenticated t Transfer: 1220 : 51|04:02:41.7740|| user BB00567992. t Information: 1220 : 51|04:02:41.7896||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 ('TECHM') order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Information: 1220 : 51|04:02:41.8209|| jobs returned 37, searched in 00:00:00.0307551 t Information: 1220 : 51|04:02:41.8990||TechReports is not found. ID: 27. t Information: 1220 : 51|04:02:41.8990||TechReports is not found. ID: 1300. t Information: 1220 : 51|04:02:41.8990||TechReports is not found. ID: 41. t Information: 1220 : 51|04:02:41.8990||TechReports is not found. ID: 96. t Information: 1220 : 51|04:02:41.8990||TechReports is not found. ID: 252. t Information: 1220 : 51|04:02:41.8990||TechReports is not found. ID: 116. t Information: 1220 : 51|04:02:41.8990||TechReports is not found. ID: 672. t Information: 1220 : 51|04:02:41.8990|| tasks returned 37, searched in 00:00:00.0854660 t Transfer: 1220 : 36|04:02:56.6334||IsUserAuthenticated: /api/search/workflow?_dc=1576728175968 t Transfer: 1220 : 36|04:02:56.6334||GetCurrentUser.. t Transfer: 1220 : 36|04:02:56.6334|| OAuth authenticated t Transfer: 1220 : 36|04:02:56.6334|| user BB00567992. t Transfer: 1220 : 36|04:02:56.6334||api user: BB00567992 t Information: 1220 : 36|04:02:56.6334||V3Api.SearchWorkflows t Information: 1220 : 36|04:02:56.6334||V3Api.SearchGeneric t Transfer: 1220 : 36|04:02:56.6334||GetCurrentUser.. t Transfer: 1220 : 36|04:02:56.6334|| OAuth authenticated t Transfer: 1220 : 36|04:02:56.6334|| user BB00567992. t Information: 1220 : 36|04:02:56.6334||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 ('TECHM') order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Information: 1220 : 36|04:02:56.6647|| jobs returned 37, searched in 00:00:00.0313336 t Information: 1220 : 36|04:02:56.8678||TechReports is not found. ID: 27. t Information: 1220 : 36|04:02:56.8678||TechReports is not found. ID: 1300. t Information: 1220 : 36|04:02:56.8678||TechReports is not found. ID: 41. t Information: 1220 : 36|04:02:56.8678||TechReports is not found. ID: 96. t Information: 1220 : 36|04:02:56.8678||TechReports is not found. ID: 252. t Information: 1220 : 36|04:02:56.8678||TechReports is not found. ID: 116. t Information: 1220 : 36|04:02:56.8678||TechReports is not found. ID: 672. t Information: 1220 : 36|04:02:56.8678|| tasks returned 37, searched in 00:00:00.1969680 t Transfer: 1220 : 35|04:03:11.1334||IsUserAuthenticated: /api/search/workflow?_dc=1576728190967 t Transfer: 1220 : 35|04:03:11.1334||GetCurrentUser.. t Transfer: 1220 : 35|04:03:11.1334|| OAuth authenticated t Transfer: 1220 : 35|04:03:11.1334|| user BB00567992. t Transfer: 1220 : 35|04:03:11.1334||api user: BB00567992 t Information: 1220 : 35|04:03:11.1334||V3Api.SearchWorkflows t Information: 1220 : 35|04:03:11.1334||V3Api.SearchGeneric t Transfer: 1220 : 35|04:03:11.1334||GetCurrentUser.. t Transfer: 1220 : 35|04:03:11.1334|| OAuth authenticated t Transfer: 1220 : 35|04:03:11.1334|| user BB00567992. t Information: 1220 : 35|04:03:11.1334||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 ('TECHM') order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Information: 1220 : 35|04:03:11.1647|| jobs returned 37, searched in 00:00:00.0321328 t Information: 1220 : 35|04:03:11.2897||TechReports is not found. ID: 27. t Information: 1220 : 35|04:03:11.2897||TechReports is not found. ID: 1300. t Information: 1220 : 35|04:03:11.2897||TechReports is not found. ID: 41. t Information: 1220 : 35|04:03:11.3053||TechReports is not found. ID: 96. t Information: 1220 : 35|04:03:11.3053||TechReports is not found. ID: 252. t Information: 1220 : 35|04:03:11.3053||TechReports is not found. ID: 116. t Information: 1220 : 35|04:03:11.3053||TechReports is not found. ID: 672. t Information: 1220 : 35|04:03:11.3053|| tasks returned 37, searched in 00:00:00.1282261 t Transfer: 1220 : 35|04:03:26.5396||IsUserAuthenticated: /api/search/workflow?_dc=1576728205970 t Transfer: 1220 : 35|04:03:26.5396||GetCurrentUser.. t Transfer: 1220 : 35|04:03:26.5396|| OAuth authenticated t Transfer: 1220 : 35|04:03:26.5396|| user BB00567992. t Transfer: 1220 : 35|04:03:26.5396||api user: BB00567992 t Information: 1220 : 35|04:03:26.5396||V3Api.SearchWorkflows t Information: 1220 : 35|04:03:26.5396||V3Api.SearchGeneric t Transfer: 1220 : 35|04:03:26.5396||GetCurrentUser.. t Transfer: 1220 : 35|04:03:26.5396|| OAuth authenticated t Transfer: 1220 : 35|04:03:26.5396|| user BB00567992. t Information: 1220 : 35|04:03:26.5396||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 ('TECHM') order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Information: 1220 : 35|04:03:26.5709|| jobs returned 37, searched in 00:00:00.0284745 t Information: 1220 : 35|04:03:26.6490||TechReports is not found. ID: 27. t Information: 1220 : 35|04:03:26.6490||TechReports is not found. ID: 1300. t Information: 1220 : 35|04:03:26.6490||TechReports is not found. ID: 41. t Information: 1220 : 35|04:03:26.6490||TechReports is not found. ID: 96. t Information: 1220 : 35|04:03:26.6490||TechReports is not found. ID: 252. t Information: 1220 : 35|04:03:26.6490||TechReports is not found. ID: 116. t Information: 1220 : 35|04:03:26.6490||TechReports is not found. ID: 672. t Information: 1220 : 35|04:03:26.6490|| tasks returned 37, searched in 00:00:00.0781121 t Transfer: 1220 : 35|04:03:41.1959||IsUserAuthenticated: /api/search/workflow?_dc=1576728220972 t Transfer: 1220 : 35|04:03:41.1959||GetCurrentUser.. t Transfer: 1220 : 35|04:03:41.1959|| OAuth authenticated t Transfer: 1220 : 35|04:03:41.1959|| user BB00567992. t Transfer: 1220 : 35|04:03:41.1959||api user: BB00567992 t Information: 1220 : 35|04:03:41.1959||V3Api.SearchWorkflows t Information: 1220 : 35|04:03:41.1959||V3Api.SearchGeneric t Transfer: 1220 : 35|04:03:41.1959||GetCurrentUser.. t Transfer: 1220 : 35|04:03:41.1959|| OAuth authenticated t Transfer: 1220 : 35|04:03:41.1959|| user BB00567992. t Information: 1220 : 35|04:03:41.2115||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 ('TECHM') order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Information: 1220 : 35|04:03:41.2271|| jobs returned 37, searched in 00:00:00.0278416 t Information: 1220 : 35|04:03:41.4459||TechReports is not found. ID: 27. t Information: 1220 : 35|04:03:41.4459||TechReports is not found. ID: 1300. t Information: 1220 : 35|04:03:41.4459||TechReports is not found. ID: 41. t Information: 1220 : 35|04:03:41.4459||TechReports is not found. ID: 96. t Information: 1220 : 35|04:03:41.4459||TechReports is not found. ID: 252. t Information: 1220 : 35|04:03:41.4459||TechReports is not found. ID: 116. t Information: 1220 : 35|04:03:41.4459||TechReports is not found. ID: 672. t Information: 1220 : 35|04:03:41.4459|| tasks returned 37, searched in 00:00:00.2136595 t Transfer: 1220 : 51|04:03:56.1334||IsUserAuthenticated: /api/search/workflow?_dc=1576728235973 t Transfer: 1220 : 51|04:03:56.1334||GetCurrentUser.. t Transfer: 1220 : 51|04:03:56.1334|| OAuth authenticated t Transfer: 1220 : 51|04:03:56.1334|| user BB00567992. t Transfer: 1220 : 51|04:03:56.1334||api user: BB00567992 t Information: 1220 : 51|04:03:56.1334||V3Api.SearchWorkflows t Information: 1220 : 51|04:03:56.1334||V3Api.SearchGeneric t Transfer: 1220 : 51|04:03:56.1334||GetCurrentUser.. t Transfer: 1220 : 51|04:03:56.1334|| OAuth authenticated t Transfer: 1220 : 51|04:03:56.1334|| user BB00567992. t Information: 1220 : 51|04:03:56.1334||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 ('TECHM') order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Information: 1220 : 51|04:03:56.1646|| jobs returned 37, searched in 00:00:00.0277831 t Information: 1220 : 51|04:03:56.2271||TechReports is not found. ID: 27. t Information: 1220 : 51|04:03:56.2271||TechReports is not found. ID: 1300. t Information: 1220 : 51|04:03:56.2271||TechReports is not found. ID: 41. t Information: 1220 : 51|04:03:56.2271||TechReports is not found. ID: 96. t Information: 1220 : 51|04:03:56.2271||TechReports is not found. ID: 252. t Information: 1220 : 51|04:03:56.2271||TechReports is not found. ID: 116. t Information: 1220 : 51|04:03:56.2271||TechReports is not found. ID: 672. t Information: 1220 : 51|04:03:56.2428|| tasks returned 37, searched in 00:00:00.0754330 t Transfer: 1220 : 51|04:04:11.1490||IsUserAuthenticated: /api/search/workflow?_dc=1576728250975 t Transfer: 1220 : 51|04:04:11.1490||GetCurrentUser.. t Transfer: 1220 : 51|04:04:11.1490|| OAuth authenticated t Transfer: 1220 : 51|04:04:11.1490|| user BB00567992. t Transfer: 1220 : 51|04:04:11.1490||api user: BB00567992 t Information: 1220 : 51|04:04:11.1490||V3Api.SearchWorkflows t Information: 1220 : 51|04:04:11.1490||V3Api.SearchGeneric t Transfer: 1220 : 51|04:04:11.1490||GetCurrentUser.. t Transfer: 1220 : 51|04:04:11.1490|| OAuth authenticated t Transfer: 1220 : 51|04:04:11.1490|| user BB00567992. t Information: 1220 : 51|04:04:11.1647||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 ('TECHM') order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Information: 1220 : 51|04:04:11.1959|| jobs returned 37, searched in 00:00:00.0272776 t Information: 1220 : 51|04:04:11.3990||TechReports is not found. ID: 27. t Information: 1220 : 51|04:04:11.3990||TechReports is not found. ID: 1300. t Information: 1220 : 51|04:04:11.3990||TechReports is not found. ID: 41. t Information: 1220 : 51|04:04:11.3990||TechReports is not found. ID: 96. t Information: 1220 : 51|04:04:11.3990||TechReports is not found. ID: 252. t Information: 1220 : 51|04:04:11.3990||TechReports is not found. ID: 116. t Information: 1220 : 51|04:04:11.3990||TechReports is not found. ID: 672. t Information: 1220 : 51|04:04:11.3990|| tasks returned 37, searched in 00:00:00.2039801 t Transfer: 1220 : 36|04:04:26.1803||IsUserAuthenticated: /api/search/workflow?_dc=1576728265970 t Transfer: 1220 : 36|04:04:26.1803||GetCurrentUser.. t Transfer: 1220 : 36|04:04:26.1959|| OAuth authenticated t Transfer: 1220 : 36|04:04:26.1959|| user BB00567992. t Transfer: 1220 : 36|04:04:26.1959||api user: BB00567992 t Information: 1220 : 36|04:04:26.1959||V3Api.SearchWorkflows t Information: 1220 : 36|04:04:26.1959||V3Api.SearchGeneric t Transfer: 1220 : 36|04:04:26.1959||GetCurrentUser.. t Transfer: 1220 : 36|04:04:26.1959|| OAuth authenticated t Transfer: 1220 : 36|04:04:26.1959|| user BB00567992. t Information: 1220 : 36|04:04:26.1959||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 ('TECHM') order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Information: 1220 : 36|04:04:26.2272|| jobs returned 37, searched in 00:00:00.0277536 t Information: 1220 : 36|04:04:26.3053||TechReports is not found. ID: 27. t Information: 1220 : 36|04:04:26.3053||TechReports is not found. ID: 1300. t Information: 1220 : 36|04:04:26.3053||TechReports is not found. ID: 41. t Information: 1220 : 36|04:04:26.3053||TechReports is not found. ID: 96. t Information: 1220 : 36|04:04:26.3053||TechReports is not found. ID: 252. t Information: 1220 : 36|04:04:26.3053||TechReports is not found. ID: 116. t Information: 1220 : 36|04:04:26.3053||TechReports is not found. ID: 672. t Information: 1220 : 36|04:04:26.3053|| tasks returned 37, searched in 00:00:00.0838376 t Transfer: 1220 : 45|04:04:41.1178||IsUserAuthenticated: /api/search/workflow?_dc=1576728280966 t Transfer: 1220 : 45|04:04:41.1178||GetCurrentUser.. t Transfer: 1220 : 45|04:04:41.1178|| OAuth authenticated t Transfer: 1220 : 45|04:04:41.1178|| user BB00567992. t Transfer: 1220 : 45|04:04:41.1178||api user: BB00567992 t Information: 1220 : 45|04:04:41.1178||V3Api.SearchWorkflows t Information: 1220 : 45|04:04:41.1178||V3Api.SearchGeneric t Transfer: 1220 : 45|04:04:41.1178||GetCurrentUser.. t Transfer: 1220 : 45|04:04:41.1178|| OAuth authenticated t Transfer: 1220 : 45|04:04:41.1178|| user BB00567992. t Information: 1220 : 45|04:04:41.1334||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 ('TECHM') order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Information: 1220 : 45|04:04:41.1490|| jobs returned 37, searched in 00:00:00.0266765 t Information: 1220 : 45|04:04:41.3365||TechReports is not found. ID: 27. t Information: 1220 : 45|04:04:41.3365||TechReports is not found. ID: 1300. t Information: 1220 : 45|04:04:41.3365||TechReports is not found. ID: 41. t Information: 1220 : 45|04:04:41.3365||TechReports is not found. ID: 96. t Information: 1220 : 45|04:04:41.3365||TechReports is not found. ID: 252. t Information: 1220 : 45|04:04:41.3365||TechReports is not found. ID: 116. t Information: 1220 : 45|04:04:41.3365||TechReports is not found. ID: 672. t Information: 1220 : 45|04:04:41.3365|| tasks returned 37, searched in 00:00:00.1798080 t Transfer: 1220 : 50|04:04:56.1647||IsUserAuthenticated: /api/search/workflow?_dc=1576728295965 t Transfer: 1220 : 50|04:04:56.1647||GetCurrentUser.. t Transfer: 1220 : 50|04:04:56.1647|| OAuth authenticated t Transfer: 1220 : 50|04:04:56.1647|| user BB00567992. t Transfer: 1220 : 50|04:04:56.1647||api user: BB00567992 t Information: 1220 : 50|04:04:56.1647||V3Api.SearchWorkflows t Information: 1220 : 50|04:04:56.1647||V3Api.SearchGeneric t Transfer: 1220 : 50|04:04:56.1647||GetCurrentUser.. t Transfer: 1220 : 50|04:04:56.1647|| OAuth authenticated t Transfer: 1220 : 50|04:04:56.1647|| user BB00567992. t Information: 1220 : 50|04:04:56.1647||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 ('TECHM') order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Information: 1220 : 50|04:04:56.1959|| jobs returned 37, searched in 00:00:00.0320900 t Information: 1220 : 50|04:04:56.3209||TechReports is not found. ID: 27. t Information: 1220 : 50|04:04:56.3209||TechReports is not found. ID: 1300. t Information: 1220 : 50|04:04:56.3209||TechReports is not found. ID: 41. t Information: 1220 : 50|04:04:56.3209||TechReports is not found. ID: 96. t Information: 1220 : 50|04:04:56.3209||TechReports is not found. ID: 252. t Information: 1220 : 50|04:04:56.3209||TechReports is not found. ID: 116. t Information: 1220 : 50|04:04:56.3209||TechReports is not found. ID: 672. t Information: 1220 : 50|04:04:56.3209|| tasks returned 37, searched in 00:00:00.1258058 t Transfer: 1220 : 49|04:05:11.1959||IsUserAuthenticated: /api/search/workflow?_dc=1576728310977 t Transfer: 1220 : 49|04:05:11.1959||GetCurrentUser.. t Transfer: 1220 : 49|04:05:11.1959|| OAuth authenticated t Transfer: 1220 : 49|04:05:11.1959|| user BB00567992. t Transfer: 1220 : 49|04:05:11.1959||api user: BB00567992 t Information: 1220 : 49|04:05:11.2116||V3Api.SearchWorkflows t Information: 1220 : 49|04:05:11.2116||V3Api.SearchGeneric t Transfer: 1220 : 49|04:05:11.2116||GetCurrentUser.. t Transfer: 1220 : 49|04:05:11.2116|| OAuth authenticated t Transfer: 1220 : 49|04:05:11.2116|| user BB00567992. t Information: 1220 : 49|04:05:11.2116||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 ('TECHM') order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Information: 1220 : 49|04:05:11.2428|| jobs returned 37, searched in 00:00:00.0264506 t Information: 1220 : 49|04:05:11.3834||TechReports is not found. ID: 27. t Information: 1220 : 49|04:05:11.3834||TechReports is not found. ID: 1300. t Information: 1220 : 49|04:05:11.3834||TechReports is not found. ID: 41. t Information: 1220 : 49|04:05:11.3834||TechReports is not found. ID: 96. t Information: 1220 : 49|04:05:11.3834||TechReports is not found. ID: 252. t Information: 1220 : 49|04:05:11.3834||TechReports is not found. ID: 116. t Information: 1220 : 49|04:05:11.3834||TechReports is not found. ID: 672. t Information: 1220 : 49|04:05:11.3834|| tasks returned 37, searched in 00:00:00.1441602 t Transfer: 1220 : 43|04:05:26.5553||IsUserAuthenticated: /api/search/workflow?_dc=1576728325978 t Transfer: 1220 : 43|04:05:26.5553||GetCurrentUser.. t Transfer: 1220 : 43|04:05:26.5553|| OAuth authenticated t Transfer: 1220 : 43|04:05:26.5553|| user BB00567992. t Transfer: 1220 : 43|04:05:26.5553||api user: BB00567992 t Information: 1220 : 43|04:05:26.5553||V3Api.SearchWorkflows t Information: 1220 : 43|04:05:26.5553||V3Api.SearchGeneric t Transfer: 1220 : 43|04:05:26.5553||GetCurrentUser.. t Transfer: 1220 : 43|04:05:26.5553|| OAuth authenticated t Transfer: 1220 : 43|04:05:26.5553|| user BB00567992. t Information: 1220 : 43|04:05:26.5553||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 ('TECHM') order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Information: 1220 : 43|04:05:26.5865|| jobs returned 37, searched in 00:00:00.0279781 t Information: 1220 : 43|04:05:26.6647||TechReports is not found. ID: 27. t Information: 1220 : 43|04:05:26.6647||TechReports is not found. ID: 1300. t Information: 1220 : 43|04:05:26.6647||TechReports is not found. ID: 41. t Information: 1220 : 43|04:05:26.6647||TechReports is not found. ID: 96. t Information: 1220 : 43|04:05:26.6647||TechReports is not found. ID: 252. t Information: 1220 : 43|04:05:26.6647||TechReports is not found. ID: 116. t Information: 1220 : 43|04:05:26.6647||TechReports is not found. ID: 672. t Information: 1220 : 43|04:05:26.6647|| tasks returned 37, searched in 00:00:00.0757205 t Transfer: 1220 : 34|04:05:41.1490||IsUserAuthenticated: /api/search/workflow?_dc=1576728340979 t Transfer: 1220 : 34|04:05:41.1490||GetCurrentUser.. t Transfer: 1220 : 34|04:05:41.1490|| OAuth authenticated t Transfer: 1220 : 34|04:05:41.1490|| user BB00567992. t Transfer: 1220 : 34|04:05:41.1490||api user: BB00567992 t Information: 1220 : 34|04:05:41.1490||V3Api.SearchWorkflows t Information: 1220 : 34|04:05:41.1490||V3Api.SearchGeneric t Transfer: 1220 : 34|04:05:41.1490||GetCurrentUser.. t Transfer: 1220 : 34|04:05:41.1490|| OAuth authenticated t Transfer: 1220 : 34|04:05:41.1490|| user BB00567992. t Information: 1220 : 34|04:05:41.1647||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 ('TECHM') order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Information: 1220 : 34|04:05:41.2897|| jobs returned 37, searched in 00:00:00.1310406 t Information: 1220 : 34|04:05:41.3990||TechReports is not found. ID: 27. t Information: 1220 : 34|04:05:41.3990||TechReports is not found. ID: 1300. t Information: 1220 : 34|04:05:41.3990||TechReports is not found. ID: 41. t Information: 1220 : 34|04:05:41.3990||TechReports is not found. ID: 96. t Information: 1220 : 34|04:05:41.3990||TechReports is not found. ID: 252. t Information: 1220 : 34|04:05:41.3990||TechReports is not found. ID: 116. t Information: 1220 : 34|04:05:41.3990||TechReports is not found. ID: 672. t Information: 1220 : 34|04:05:41.3990|| tasks returned 37, searched in 00:00:00.1029673 t Transfer: 1220 : 36|04:05:56.2115||IsUserAuthenticated: /api/search/workflow?_dc=1576728355963 t Transfer: 1220 : 36|04:05:56.2115||GetCurrentUser.. t Transfer: 1220 : 36|04:05:56.2115|| OAuth authenticated t Transfer: 1220 : 36|04:05:56.2115|| user BB00567992. t Transfer: 1220 : 36|04:05:56.2115||api user: BB00567992 t Information: 1220 : 36|04:05:56.2115||V3Api.SearchWorkflows t Information: 1220 : 36|04:05:56.2115||V3Api.SearchGeneric t Transfer: 1220 : 36|04:05:56.2115||GetCurrentUser.. t Transfer: 1220 : 36|04:05:56.2115|| OAuth authenticated t Transfer: 1220 : 36|04:05:56.2115|| user BB00567992. t Information: 1220 : 36|04:05:56.2115||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 ('TECHM') order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Information: 1220 : 36|04:05:56.2428|| jobs returned 37, searched in 00:00:00.0272036 t Information: 1220 : 36|04:05:56.3053||TechReports is not found. ID: 27. t Information: 1220 : 36|04:05:56.3053||TechReports is not found. ID: 1300. t Information: 1220 : 36|04:05:56.3053||TechReports is not found. ID: 41. t Information: 1220 : 36|04:05:56.3053||TechReports is not found. ID: 96. t Information: 1220 : 36|04:05:56.3053||TechReports is not found. ID: 252. t Information: 1220 : 36|04:05:56.3053||TechReports is not found. ID: 116. t Information: 1220 : 36|04:05:56.3053||TechReports is not found. ID: 672. t Information: 1220 : 36|04:05:56.3053|| tasks returned 37, searched in 00:00:00.0754617 t Transfer: 1220 : 42|04:06:11.1334||IsUserAuthenticated: /api/search/workflow?_dc=1576728370969 t Transfer: 1220 : 42|04:06:11.1334||GetCurrentUser.. t Transfer: 1220 : 42|04:06:11.1334|| OAuth authenticated t Transfer: 1220 : 42|04:06:11.1334|| user BB00567992. t Transfer: 1220 : 42|04:06:11.1334||api user: BB00567992 t Information: 1220 : 42|04:06:11.1334||V3Api.SearchWorkflows t Information: 1220 : 42|04:06:11.1334||V3Api.SearchGeneric t Transfer: 1220 : 42|04:06:11.1334||GetCurrentUser.. t Transfer: 1220 : 42|04:06:11.1334|| OAuth authenticated t Transfer: 1220 : 42|04:06:11.1334|| user BB00567992. t Information: 1220 : 42|04:06:11.1334||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 ('TECHM') order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Information: 1220 : 42|04:06:11.1647|| jobs returned 37, searched in 00:00:00.0276045 t Information: 1220 : 42|04:06:11.3834||TechReports is not found. ID: 27. t Information: 1220 : 42|04:06:11.3834||TechReports is not found. ID: 1300. t Information: 1220 : 42|04:06:11.3834||TechReports is not found. ID: 41. t Information: 1220 : 42|04:06:11.3834||TechReports is not found. ID: 96. t Information: 1220 : 42|04:06:11.3834||TechReports is not found. ID: 252. t Information: 1220 : 42|04:06:11.3834||TechReports is not found. ID: 116. t Information: 1220 : 42|04:06:11.3834||TechReports is not found. ID: 672. t Information: 1220 : 42|04:06:11.3834|| tasks returned 37, searched in 00:00:00.2115704 t Transfer: 1220 : 12|04:06:17.0709||IsUserAuthenticated: /api/v3/job/81371?_dc=1576728376533 t Transfer: 1220 : 12|04:06:17.0709||GetCurrentUser.. t Transfer: 1220 : 12|04:06:17.0709|| OAuth authenticated t Transfer: 1220 : 12|04:06:17.0709|| user BB00567992. t Transfer: 1220 : 12|04:06:17.0709||api user: BB00567992 t Information: 1220 : 12|04:06:17.1803||TechReports is not found. ID: 96. t Information: 1220 : 12|04:06:17.1803||TechReports is not found. ID: 41. t Information: 1220 : 12|04:06:17.1803||TechReports is not found. ID: 116. t Information: 1220 : 12|04:06:17.1803||TechReports is not found. ID: 41. t Information: 1220 : 12|04:06:17.1803||TechReports is not found. ID: 672. t Information: 1220 : 12|04:06:17.1803||TechReports is not found. ID: 41. t Information: 1220 : 12|04:06:17.1803||TechReports is not found. ID: 41. t Information: 1220 : 12|04:06:17.1803||TechReports is not found. ID: 41. t Information: 1220 : 12|04:06:17.1803||TechReports is not found. ID: 41. t Information: 1220 : 12|04:06:17.1803||TechReports is not found. ID: 672. t Information: 1220 : 12|04:06:17.1803||TechReports is not found. ID: 27. t Verbose: 1220 : 12|04:06:18.1803||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Makers Nov.mov subfolder t Verbose: 1220 : 12|04:06:18.1803|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Makers Nov.mov t Verbose: 1220 : 12|04:06:18.1803||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Makers Nov.mov t Transfer: 1220 : 12|04:06:18.1803||GetCurrentUser.. t Transfer: 1220 : 12|04:06:18.1803|| OAuth authenticated t Transfer: 1220 : 12|04:06:18.1803|| user BB00567992. t Transfer: 1220 : 51|04:06:26.3522||IsUserAuthenticated: /api/v3/task/81399/history?_dc=1576728386161 t Transfer: 1220 : 51|04:06:26.3522||GetCurrentUser.. t Transfer: 1220 : 51|04:06:26.3522|| OAuth authenticated t Transfer: 1220 : 51|04:06:26.3522|| user BB00567992. t Transfer: 1220 : 51|04:06:26.3522||api user: BB00567992 t Information: 1220 : 51|04:06:26.3522||V3Api. GetTaskStatusHistory. t Transfer: 1220 : 35|04:06:26.6803||IsUserAuthenticated: /api/v3/task/81399/history?_dc=1576728385959 t Transfer: 1220 : 35|04:06:26.6803||GetCurrentUser.. t Transfer: 1220 : 35|04:06:26.6803|| OAuth authenticated t Transfer: 1220 : 35|04:06:26.6803|| user BB00567992. t Transfer: 1220 : 35|04:06:26.6803||api user: BB00567992 t Information: 1220 : 35|04:06:26.6803||V3Api. GetTaskStatusHistory. t Transfer: 1220 : 43|04:06:28.7428||IsUserAuthenticated: /api/v3/task/assess/81399?_dc=1576728388487 t Transfer: 1220 : 43|04:06:28.7428||GetCurrentUser.. t Transfer: 1220 : 43|04:06:28.7428|| OAuth authenticated t Transfer: 1220 : 43|04:06:28.7428|| user BB00567992. t Transfer: 1220 : 43|04:06:28.7428||api user: BB00567992 t Transfer: 1220 : 48|04:06:28.7584||IsUserAuthenticated: /api/lookups/FriendlyNames?_dc=1576728388488 t Transfer: 1220 : 48|04:06:28.7584||GetCurrentUser.. t Transfer: 1220 : 48|04:06:28.7584|| OAuth authenticated t Transfer: 1220 : 48|04:06:28.7584|| user BB00567992. t Transfer: 1220 : 48|04:06:28.7584||api user: BB00567992 t Information: 1220 : 43|04:06:29.3522||TM_MIS. LoadSubtitles for ID: 293652. t Information: 1220 : 43|04:06:29.3522||TM_MIS. LoadSubtitles for ID: 293652. SQL: 'select id, m_ctnr_id, m_ctnr_loc, modified_dt, tv_std, m_ctnr_fmt_id, nvl((select max(l.language) from tm_audio l where l.miid=m.id),aud_language_id) aud_language_id from tm_mis m where mi_deleted=0 and item_type>0 and media_type=101 and PGM_PARENT_ID=293634' t Information: 1220 : 43|04:06:29.3678||TM_MIS. LoadSubtitles for ID: 293652 found no subtitles. t Verbose: 1220 : 43|04:06:29.7740||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001402.mp4 subfolder t Verbose: 1220 : 43|04:06:29.7740|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001402.mp4 t Verbose: 1220 : 43|04:06:29.7740||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/N0001402.mp4 t Transfer: 1220 : 43|04:06:29.7740||GetCurrentUser.. t Transfer: 1220 : 43|04:06:29.7740|| OAuth authenticated t Transfer: 1220 : 43|04:06:29.7740|| user BB00567992. t Transfer: 1220 : 36|04:06:30.1959||IsUserAuthenticated: /api/v3/detailsview/Job/0?lang=en-US&_dc=1576728390003 t Transfer: 1220 : 36|04:06:30.1959||GetCurrentUser.. t Transfer: 1220 : 36|04:06:30.1959|| OAuth authenticated t Transfer: 1220 : 36|04:06:30.1959|| user BB00567992. t Transfer: 1220 : 36|04:06:30.1959||api user: BB00567992 t Transfer: 1220 : 46|04:06:30.7584||IsUserAuthenticated: /api/v3/detailsview/MediaDetails/5?lang=en-US&_dc=1576728390493 t Transfer: 1220 : 46|04:06:30.7584||GetCurrentUser.. t Transfer: 1220 : 46|04:06:30.7584|| OAuth authenticated t Transfer: 1220 : 46|04:06:30.7584|| user BB00567992. t Transfer: 1220 : 46|04:06:30.7740||api user: BB00567992 t Transfer: 1220 : 45|04:06:31.1178||IsUserAuthenticated: /api/v3/layout/default/5?_dc=1576728390970 t Transfer: 1220 : 45|04:06:31.1178||GetCurrentUser.. t Transfer: 1220 : 45|04:06:31.1178|| OAuth authenticated t Transfer: 1220 : 45|04:06:31.1178|| user BB00567992. t Transfer: 1220 : 45|04:06:31.1178||api user: BB00567992 t Information: 1220 : 45|04:06:31.1178||LoadDefaultDashboard. t Transfer: 1220 : 45|04:06:31.1178||GetCurrentUser.. t Transfer: 1220 : 45|04:06:31.1178|| OAuth authenticated t Transfer: 1220 : 45|04:06:31.1178|| user BB00567992. t Transfer: 1220 : 45|04:06:31.1803||GetCurrentUser.. t Transfer: 1220 : 45|04:06:31.1803|| OAuth authenticated t Transfer: 1220 : 45|04:06:31.1803|| user BB00567992. t Transfer: 1220 : 12|04:06:31.8990||IsUserAuthenticated: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1576728391670 t Transfer: 1220 : 12|04:06:31.8990||GetCurrentUser.. t Transfer: 1220 : 12|04:06:31.8990|| OAuth authenticated t Transfer: 1220 : 12|04:06:31.8990|| user BB00567992. t Transfer: 1220 : 12|04:06:31.8990||api user: BB00567992 t Information: 1220 : 12|04:06:31.8990||V3Api.GetUserSettings t Transfer: 1220 : 12|04:06:31.8990||GetCurrentUser.. t Transfer: 1220 : 12|04:06:31.8990|| OAuth authenticated t Transfer: 1220 : 12|04:06:31.8990|| user BB00567992. t Information: 1220 : 43|04:06:32.0865||V3Api.GetMediaTagging t Transfer: 1220 : 35|04:06:32.4459||IsUserAuthenticated: /api/mediavideo/293652?info=smudge&_dc=1576728391891 t Transfer: 1220 : 35|04:06:32.4459||GetCurrentUser.. t Transfer: 1220 : 35|04:06:32.4459|| OAuth authenticated t Transfer: 1220 : 35|04:06:32.4459|| user BB00567992. t Transfer: 1220 : 35|04:06:32.4459||api user: BB00567992 t Verbose: 1220 : 35|04:06:32.4772||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001402.mp4 subfolder t Verbose: 1220 : 35|04:06:32.4772|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001402.mp4 t Verbose: 1220 : 35|04:06:32.4772||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/N0001402.mp4 t Transfer: 1220 : 35|04:06:32.4772||GetCurrentUser.. t Transfer: 1220 : 35|04:06:32.4772|| OAuth authenticated t Transfer: 1220 : 35|04:06:32.4772|| user BB00567992. t Transfer: 1220 : 38|04:06:41.9459||IsUserAuthenticated: /api/settings/user/defaultSearch?_dc=1576728401729 t Transfer: 1220 : 38|04:06:41.9459||GetCurrentUser.. t Transfer: 1220 : 38|04:06:41.9459|| OAuth authenticated t Transfer: 1220 : 38|04:06:41.9459|| user BB00567992. t Transfer: 1220 : 38|04:06:41.9459||api user: BB00567992 t Information: 1220 : 38|04:06:41.9459||V3Api.GetUserSettings t Transfer: 1220 : 38|04:06:41.9459||GetCurrentUser.. t Transfer: 1220 : 38|04:06:41.9459|| OAuth authenticated t Transfer: 1220 : 38|04:06:41.9459|| user BB00567992. t Transfer: 1220 : 44|04:06:41.9459||IsUserAuthenticated: /api/settings/user/startSearch?_dc=1576728401730 t Transfer: 1220 : 44|04:06:41.9459||GetCurrentUser.. t Transfer: 1220 : 44|04:06:41.9459|| OAuth authenticated t Transfer: 1220 : 44|04:06:41.9459|| user BB00567992. t Transfer: 1220 : 44|04:06:41.9459||api user: BB00567992 t Information: 1220 : 44|04:06:41.9459||V3Api.GetUserSettings t Transfer: 1220 : 44|04:06:41.9459||GetCurrentUser.. t Transfer: 1220 : 44|04:06:41.9459|| OAuth authenticated t Transfer: 1220 : 44|04:06:41.9459|| user BB00567992. t Transfer: 1220 : 12|04:06:42.3990||IsUserAuthenticated: /api/user-preferences?keys=consumer.recent.data&_dc=1576728402211 t Transfer: 1220 : 12|04:06:42.3990||GetCurrentUser.. t Transfer: 1220 : 12|04:06:42.3990|| OAuth authenticated t Transfer: 1220 : 12|04:06:42.3990|| user BB00567992. t Transfer: 1220 : 12|04:06:42.3990||api user: BB00567992 t Information: 1220 : 12|04:06:42.3990||GetUserDataByKeys: consumer.recent.data t Transfer: 1220 : 12|04:06:42.3990||GetCurrentUser.. t Transfer: 1220 : 12|04:06:42.3990|| OAuth authenticated t Transfer: 1220 : 12|04:06:42.3990|| user BB00567992. t Transfer: 1220 : 45|04:06:42.3990||IsUserAuthenticated: /api/user-preferences?keys=adv.recent.searches.consumer&_dc=1576728402251 t Transfer: 1220 : 45|04:06:42.3990||GetCurrentUser.. t Transfer: 1220 : 45|04:06:42.3990|| OAuth authenticated t Transfer: 1220 : 45|04:06:42.3990|| user BB00567992. t Transfer: 1220 : 45|04:06:42.3990||api user: BB00567992 t Information: 1220 : 45|04:06:42.3990||GetUserDataByKeys: adv.recent.searches.consumer t Transfer: 1220 : 45|04:06:42.3990||GetCurrentUser.. t Transfer: 1220 : 45|04:06:42.3990|| OAuth authenticated t Transfer: 1220 : 45|04:06:42.3990|| user BB00567992. t Transfer: 1220 : 34|04:06:47.7741||IsUserAuthenticated: /api/search/task?_dc=1576728406991 t Transfer: 1220 : 34|04:06:47.7741||GetCurrentUser.. t Transfer: 1220 : 34|04:06:47.7741|| OAuth authenticated t Transfer: 1220 : 34|04:06:47.7741|| user BB00567992. t Transfer: 1220 : 34|04:06:47.7741||api user: BB00567992 t Information: 1220 : 34|04:06:47.7741||V3Api.SearchTask t Information: 1220 : 34|04:06:47.7741||V3Api.SearchGeneric t Transfer: 1220 : 34|04:06:47.7741||GetCurrentUser.. t Transfer: 1220 : 34|04:06:47.7741|| OAuth authenticated t Transfer: 1220 : 34|04:06:47.7741|| user BB00567992. t Information: 1220 : 34|04:06:47.7897||SearchTask SQL: select * from (select a.*, rownum rnum from ( select /*+ INDEX(j JB_CMBST_IDX) */ /*+ INDEX(j JB_CMBST_IDX) */ j.*, p.pname, mi.MIID1, mi.MIID2, mi.MIID3, mi.VERSIONID1, mi.VERSIONID2, mi.PROGID1, mi.PROGID2, mi.VERSION, u.USER_ID OP_NAME, nvl(i.rec_rpt, 0) TECH_REPORT_ID, case when tsk_type=57 then cast(i.DEV_DATA_FMT as varchar2(100)) else '' end TASK_MODE, jj.j_compl_by JOB_COMPL_BY FROM tm_mtask j join tm_mjob jj on jj.id = j.j_id left join tm_mjob_pset p on p.id = jj.j_sched_indx left outer join TM_USERS u on u.id = j.assn_opid left join (select tsk_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 version) VERSION from tm_mis m, tm_mtsk_it i where m.id = i.mi_id and i.src_dest in (2, 3) group by tsk_id) mi on mi.tsk_id = j.id left join tm_mtsk_it i on i.tsk_id = j.id and i.src_dest = 4 and i.item_idx = 1 where 1=1 AND j.ID=97614 AND j.TSK_CLIENT in ('TECHM') order by jj.j_compl_by, j.id , j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Information: 1220 : 34|04:06:47.9303||TechReports is not found. ID: 672. t Transfer: 1220 : 42|04:07:05.9459||IsUserAuthenticated: /api/user-preferences?keys=adv.recent.searches.workflow&_dc=1576728425719 t Transfer: 1220 : 42|04:07:05.9459||GetCurrentUser.. t Transfer: 1220 : 42|04:07:05.9459|| OAuth authenticated t Transfer: 1220 : 42|04:07:05.9459|| user BB00567992. t Transfer: 1220 : 42|04:07:05.9459||api user: BB00567992 t Information: 1220 : 42|04:07:05.9459||GetUserDataByKeys: adv.recent.searches.workflow t Transfer: 1220 : 42|04:07:05.9459||GetCurrentUser.. t Transfer: 1220 : 42|04:07:05.9459|| OAuth authenticated t Transfer: 1220 : 42|04:07:05.9459|| user BB00567992. t Transfer: 1220 : 46|04:07:05.9459||IsUserAuthenticated: /api/view/info/Job?lang=en-US&_dc=1576728425734 t Transfer: 1220 : 46|04:07:05.9459||GetCurrentUser.. t Transfer: 1220 : 46|04:07:05.9459|| OAuth authenticated t Transfer: 1220 : 46|04:07:05.9459|| user BB00567992. t Transfer: 1220 : 46|04:07:05.9459||api user: BB00567992 t Information: 1220 : 46|04:07:05.9459||GetGridViewBuilder. builder type Job. t Transfer: 1220 : 46|04:07:05.9459||GetCurrentUser.. t Transfer: 1220 : 46|04:07:05.9459|| OAuth authenticated t Transfer: 1220 : 46|04:07:05.9459|| user BB00567992. t Information: 1220 : 46|04:07:05.9615||UserGridView. LoadView. ID 1482, Name Default. t Transfer: 1220 : 46|04:07:05.9615||GetCurrentUser.. t Transfer: 1220 : 46|04:07:05.9615|| OAuth authenticated t Transfer: 1220 : 46|04:07:05.9615|| user BB00567992. t Transfer: 1220 : 46|04:07:05.9615||GetCurrentUser.. t Transfer: 1220 : 46|04:07:05.9615|| OAuth authenticated t Transfer: 1220 : 46|04:07:05.9615|| user BB00567992. t Transfer: 1220 : 43|04:07:06.4928||IsUserAuthenticated: /api/view/searchinfo/Job?_dc=1576728425717 t Transfer: 1220 : 43|04:07:06.4928||GetCurrentUser.. t Transfer: 1220 : 43|04:07:06.4928|| OAuth authenticated t Transfer: 1220 : 43|04:07:06.4928|| user BB00567992. t Transfer: 1220 : 43|04:07:06.4928||api user: BB00567992 t Information: 1220 : 43|04:07:06.4928||GetAdvSearchColumns. search type Job grid . t Transfer: 1220 : 12|04:07:08.9772||IsUserAuthenticated: /api/search/task?_dc=1576728428803 t Transfer: 1220 : 12|04:07:08.9772||GetCurrentUser.. t Transfer: 1220 : 12|04:07:08.9772|| OAuth authenticated t Transfer: 1220 : 12|04:07:08.9772|| user BB00567992. t Transfer: 1220 : 12|04:07:08.9772||api user: BB00567992 t Information: 1220 : 12|04:07:08.9772||V3Api.SearchTask t Information: 1220 : 12|04:07:08.9772||V3Api.SearchGeneric t Transfer: 1220 : 12|04:07:08.9772||GetCurrentUser.. t Transfer: 1220 : 12|04:07:08.9772|| OAuth authenticated t Transfer: 1220 : 12|04:07:08.9772|| user BB00567992. t Information: 1220 : 12|04:07:08.9772||SearchTask SQL: select * from (select a.*, rownum rnum from ( select /*+ INDEX(j JB_CMBST_IDX) */ /*+ INDEX(j JB_CMBST_IDX) */ j.*, p.pname, mi.MIID1, mi.MIID2, mi.MIID3, mi.VERSIONID1, mi.VERSIONID2, mi.PROGID1, mi.PROGID2, mi.VERSION, u.USER_ID OP_NAME, nvl(i.rec_rpt, 0) TECH_REPORT_ID, case when tsk_type=57 then cast(i.DEV_DATA_FMT as varchar2(100)) else '' end TASK_MODE, jj.j_compl_by JOB_COMPL_BY FROM tm_mtask j join tm_mjob jj on jj.id = j.j_id left join tm_mjob_pset p on p.id = jj.j_sched_indx left outer join TM_USERS u on u.id = j.assn_opid left join (select tsk_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 version) VERSION from tm_mis m, tm_mtsk_it i where m.id = i.mi_id and i.src_dest in (2, 3) group by tsk_id) mi on mi.tsk_id = j.id left join tm_mtsk_it i on i.tsk_id = j.id and i.src_dest = 4 and i.item_idx = 1 where 1=1 AND j.ID=97632 AND j.TSK_CLIENT in ('TECHM') order by jj.j_compl_by, j.id , j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Information: 1220 : 12|04:07:09.1178||TechReports is not found. ID: 116. t Transfer: 1220 : 47|04:07:23.8990||IsUserAuthenticated: /api/v3/layout/default/3?_dc=1576728443664 t Transfer: 1220 : 47|04:07:23.8990||GetCurrentUser.. t Transfer: 1220 : 47|04:07:23.8990|| OAuth authenticated t Transfer: 1220 : 47|04:07:23.8990|| user BB00567992. t Transfer: 1220 : 47|04:07:23.8990||api user: BB00567992 t Information: 1220 : 47|04:07:23.8990||LoadDefaultDashboard. t Transfer: 1220 : 47|04:07:23.8990||GetCurrentUser.. t Transfer: 1220 : 47|04:07:23.8990|| OAuth authenticated t Transfer: 1220 : 47|04:07:23.8990|| user BB00567992. t Transfer: 1220 : 51|04:07:28.8209||IsUserAuthenticated: /api/search/workflow?_dc=1576728448198 t Transfer: 1220 : 51|04:07:28.8209||GetCurrentUser.. t Transfer: 1220 : 51|04:07:28.8209|| OAuth authenticated t Transfer: 1220 : 51|04:07:28.8209|| user BB00567992. t Transfer: 1220 : 51|04:07:28.8209||api user: BB00567992 t Information: 1220 : 51|04:07:28.8209||V3Api.SearchWorkflows t Information: 1220 : 51|04:07:28.8209||V3Api.SearchGeneric t Transfer: 1220 : 51|04:07:28.8209||GetCurrentUser.. t Transfer: 1220 : 51|04:07:28.8209|| OAuth authenticated t Transfer: 1220 : 51|04:07:28.8209|| user BB00567992. t Information: 1220 : 51|04:07:28.8209||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 ('TECHM') order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Information: 1220 : 51|04:07:28.8679|| jobs returned 37, searched in 00:00:00.0395684 t Information: 1220 : 51|04:07:28.9772||TechReports is not found. ID: 27. t Information: 1220 : 51|04:07:28.9772||TechReports is not found. ID: 1300. t Information: 1220 : 51|04:07:28.9772||TechReports is not found. ID: 41. t Information: 1220 : 51|04:07:28.9772||TechReports is not found. ID: 96. t Information: 1220 : 51|04:07:28.9772||TechReports is not found. ID: 252. t Information: 1220 : 51|04:07:28.9772||TechReports is not found. ID: 116. t Information: 1220 : 51|04:07:28.9772||TechReports is not found. ID: 672. t Information: 1220 : 51|04:07:28.9772|| tasks returned 37, searched in 00:00:00.1053448 t Transfer: 1220 : 42|04:07:30.9928||IsUserAuthenticated: /api/search/workflow?_dc=1576728450790 t Transfer: 1220 : 42|04:07:30.9928||GetCurrentUser.. t Transfer: 1220 : 42|04:07:30.9928|| OAuth authenticated t Transfer: 1220 : 42|04:07:30.9928|| user BB00567992. t Transfer: 1220 : 42|04:07:30.9928||api user: BB00567992 t Information: 1220 : 42|04:07:30.9928||V3Api.SearchWorkflows t Information: 1220 : 42|04:07:30.9928||V3Api.SearchGeneric t Transfer: 1220 : 42|04:07:30.9928||GetCurrentUser.. t Transfer: 1220 : 42|04:07:30.9928|| OAuth authenticated t Transfer: 1220 : 42|04:07:30.9928|| user BB00567992. t Information: 1220 : 42|04:07:30.9928||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 ('TECHM') order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Information: 1220 : 42|04:07:31.0240|| jobs returned 37, searched in 00:00:00.0284124 t Information: 1220 : 42|04:07:31.1334||TechReports is not found. ID: 27. t Information: 1220 : 42|04:07:31.1334||TechReports is not found. ID: 1300. t Information: 1220 : 42|04:07:31.1334||TechReports is not found. ID: 41. t Information: 1220 : 42|04:07:31.1334||TechReports is not found. ID: 96. t Information: 1220 : 42|04:07:31.1334||TechReports is not found. ID: 252. t Information: 1220 : 42|04:07:31.1334||TechReports is not found. ID: 116. t Information: 1220 : 42|04:07:31.1334||TechReports is not found. ID: 672. t Information: 1220 : 42|04:07:31.1334|| tasks returned 37, searched in 00:00:00.1093056 t Transfer: 1220 : 45|04:07:33.2428||IsUserAuthenticated: /api/v3/job/81620?_dc=1576728453012 t Transfer: 1220 : 45|04:07:33.2428||GetCurrentUser.. t Transfer: 1220 : 45|04:07:33.2428|| OAuth authenticated t Transfer: 1220 : 45|04:07:33.2428|| user BB00567992. t Transfer: 1220 : 45|04:07:33.2428||api user: BB00567992 t Information: 1220 : 45|04:07:33.2428||TechReports is not found. ID: 96. t Information: 1220 : 45|04:07:33.2428||TechReports is not found. ID: 41. t Information: 1220 : 45|04:07:33.2428||TechReports is not found. ID: 116. t Information: 1220 : 45|04:07:33.2428||TechReports is not found. ID: 41. t Information: 1220 : 45|04:07:33.2428||TechReports is not found. ID: 672. t Information: 1220 : 45|04:07:33.2428||TechReports is not found. ID: 41. t Information: 1220 : 45|04:07:33.2428||TechReports is not found. ID: 41. t Information: 1220 : 45|04:07:33.2428||TechReports is not found. ID: 41. t Information: 1220 : 45|04:07:33.2428||TechReports is not found. ID: 41. t Information: 1220 : 45|04:07:33.2428||TechReports is not found. ID: 672. t Information: 1220 : 45|04:07:33.2428||TechReports is not found. ID: 27. t Verbose: 1220 : 45|04:07:33.9772||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Game of Thrones - Blinkbox-HD.mp4 subfolder t Verbose: 1220 : 45|04:07:33.9772|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Game of Thrones - Blinkbox-HD.mp4 t Verbose: 1220 : 45|04:07:33.9772||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Game of Thrones - Blinkbox-HD.mp4 t Transfer: 1220 : 45|04:07:33.9772||GetCurrentUser.. t Transfer: 1220 : 45|04:07:33.9772|| OAuth authenticated t Transfer: 1220 : 45|04:07:33.9772|| user BB00567992. t Transfer: 1220 : 49|04:07:40.7741||IsUserAuthenticated: /api/v3/task/81648/history?_dc=1576728460533 t Transfer: 1220 : 49|04:07:40.7741||GetCurrentUser.. t Transfer: 1220 : 49|04:07:40.7741|| OAuth authenticated t Transfer: 1220 : 49|04:07:40.7741|| user BB00567992. t Transfer: 1220 : 49|04:07:40.7741||api user: BB00567992 t Information: 1220 : 49|04:07:40.7741||V3Api. GetTaskStatusHistory. t Transfer: 1220 : 44|04:07:40.8991||IsUserAuthenticated: /api/v3/task/81648/history?_dc=1576728460739 t Transfer: 1220 : 44|04:07:40.8991||GetCurrentUser.. t Transfer: 1220 : 44|04:07:40.8991|| OAuth authenticated t Transfer: 1220 : 44|04:07:40.8991|| user BB00567992. t Transfer: 1220 : 44|04:07:40.8991||api user: BB00567992 t Information: 1220 : 44|04:07:40.8991||V3Api. GetTaskStatusHistory. t Transfer: 1220 : 34|04:07:40.9303||IsUserAuthenticated: /api/v3/task/assess/81648?_dc=1576728460760 t Transfer: 1220 : 34|04:07:40.9303||GetCurrentUser.. t Transfer: 1220 : 34|04:07:40.9303|| OAuth authenticated t Transfer: 1220 : 34|04:07:40.9303|| user BB00567992. t Transfer: 1220 : 34|04:07:40.9303||api user: BB00567992 t Transfer: 1220 : 49|04:07:41.4303||IsUserAuthenticated: /api/v3/detailsview/Job/0?lang=en-US&_dc=1576728461176 t Transfer: 1220 : 49|04:07:41.4303||GetCurrentUser.. t Transfer: 1220 : 49|04:07:41.4303|| OAuth authenticated t Transfer: 1220 : 49|04:07:41.4303|| user BB00567992. t Transfer: 1220 : 49|04:07:41.4303||api user: BB00567992 t Transfer: 1220 : 46|04:07:41.8834||IsUserAuthenticated: /api/v3/detailsview/MediaDetails/5?lang=en-US&_dc=1576728461690 t Transfer: 1220 : 46|04:07:41.8834||GetCurrentUser.. t Transfer: 1220 : 46|04:07:41.8834|| OAuth authenticated t Transfer: 1220 : 46|04:07:41.8834|| user BB00567992. t Transfer: 1220 : 46|04:07:41.8834||api user: BB00567992 t Transfer: 1220 : 34|04:07:42.3365||IsUserAuthenticated: /api/v3/layout/default/5?_dc=1576728462160 t Transfer: 1220 : 34|04:07:42.3365||GetCurrentUser.. t Transfer: 1220 : 34|04:07:42.3365|| OAuth authenticated t Transfer: 1220 : 34|04:07:42.3522|| user BB00567992. t Transfer: 1220 : 34|04:07:42.3522||api user: BB00567992 t Information: 1220 : 34|04:07:42.3522||LoadDefaultDashboard. t Transfer: 1220 : 34|04:07:42.3522||GetCurrentUser.. t Transfer: 1220 : 34|04:07:42.3522|| OAuth authenticated t Transfer: 1220 : 34|04:07:42.3522|| user BB00567992. t Transfer: 1220 : 34|04:07:42.3678||GetCurrentUser.. t Transfer: 1220 : 34|04:07:42.3678|| OAuth authenticated t Transfer: 1220 : 34|04:07:42.3678|| user BB00567992. t Transfer: 1220 : 48|04:07:51.9772||IsUserAuthenticated: /api/v3/job/81620?_dc=1576728471360 t Transfer: 1220 : 48|04:07:51.9772||GetCurrentUser.. t Transfer: 1220 : 48|04:07:51.9772|| OAuth authenticated t Transfer: 1220 : 48|04:07:51.9772|| user BB00567992. t Transfer: 1220 : 48|04:07:51.9772||api user: BB00567992 t Information: 1220 : 48|04:07:51.9772||TechReports is not found. ID: 96. t Information: 1220 : 48|04:07:51.9772||TechReports is not found. ID: 41. t Information: 1220 : 48|04:07:51.9772||TechReports is not found. ID: 116. t Information: 1220 : 48|04:07:51.9772||TechReports is not found. ID: 41. t Information: 1220 : 48|04:07:51.9772||TechReports is not found. ID: 672. t Information: 1220 : 48|04:07:51.9772||TechReports is not found. ID: 41. t Information: 1220 : 48|04:07:51.9772||TechReports is not found. ID: 41. t Information: 1220 : 48|04:07:51.9772||TechReports is not found. ID: 41. t Information: 1220 : 48|04:07:51.9772||TechReports is not found. ID: 41. t Information: 1220 : 48|04:07:51.9772||TechReports is not found. ID: 672. t Information: 1220 : 48|04:07:51.9772||TechReports is not found. ID: 27. t Verbose: 1220 : 48|04:07:52.6959||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Game of Thrones - Blinkbox-HD.mp4 subfolder t Verbose: 1220 : 48|04:07:52.6959|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Game of Thrones - Blinkbox-HD.mp4 t Verbose: 1220 : 48|04:07:52.6959||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Game of Thrones - Blinkbox-HD.mp4 t Transfer: 1220 : 48|04:07:52.6959||GetCurrentUser.. t Transfer: 1220 : 48|04:07:52.6959|| OAuth authenticated t Transfer: 1220 : 48|04:07:52.6959|| user BB00567992. t Transfer: 1220 : 51|04:08:00.0865||IsUserAuthenticated: /api/search/task?_dc=1576728479952 t Transfer: 1220 : 51|04:08:00.0865||GetCurrentUser.. t Transfer: 1220 : 51|04:08:00.0865|| OAuth authenticated t Transfer: 1220 : 51|04:08:00.0865|| user BB00567992. t Transfer: 1220 : 51|04:08:00.0865||api user: BB00567992 t Information: 1220 : 51|04:08:00.0865||V3Api.SearchTask t Information: 1220 : 51|04:08:00.0865||V3Api.SearchGeneric t Transfer: 1220 : 51|04:08:00.0865||GetCurrentUser.. t Transfer: 1220 : 51|04:08:00.0865|| OAuth authenticated t Transfer: 1220 : 51|04:08:00.0865|| user BB00567992. t Information: 1220 : 51|04:08:00.1022||SearchTask SQL: select * from (select a.*, rownum rnum from ( select /*+ INDEX(j JB_CMBST_IDX) */ /*+ INDEX(j JB_CMBST_IDX) */ j.*, p.pname, mi.MIID1, mi.MIID2, mi.MIID3, mi.VERSIONID1, mi.VERSIONID2, mi.PROGID1, mi.PROGID2, mi.VERSION, u.USER_ID OP_NAME, nvl(i.rec_rpt, 0) TECH_REPORT_ID, case when tsk_type=57 then cast(i.DEV_DATA_FMT as varchar2(100)) else '' end TASK_MODE, jj.j_compl_by JOB_COMPL_BY FROM tm_mtask j join tm_mjob jj on jj.id = j.j_id left join tm_mjob_pset p on p.id = jj.j_sched_indx left outer join TM_USERS u on u.id = j.assn_opid left join (select tsk_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 version) VERSION from tm_mis m, tm_mtsk_it i where m.id = i.mi_id and i.src_dest in (2, 3) group by tsk_id) mi on mi.tsk_id = j.id left join tm_mtsk_it i on i.tsk_id = j.id and i.src_dest = 4 and i.item_idx = 1 where 1=1 AND j.ID=97617 AND j.TSK_CLIENT in ('TECHM') order by jj.j_compl_by, j.id , j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Transfer: 1220 : 47|04:08:18.1334||IsUserAuthenticated: /api/v3/layout/default/3?_dc=1576728497933 t Transfer: 1220 : 47|04:08:18.1334||GetCurrentUser.. t Transfer: 1220 : 47|04:08:18.1334|| OAuth authenticated t Transfer: 1220 : 47|04:08:18.1334|| user BB00567992. t Transfer: 1220 : 47|04:08:18.1334||api user: BB00567992 t Information: 1220 : 47|04:08:18.1334||LoadDefaultDashboard. t Transfer: 1220 : 47|04:08:18.1334||GetCurrentUser.. t Transfer: 1220 : 47|04:08:18.1334|| OAuth authenticated t Transfer: 1220 : 47|04:08:18.1334|| user BB00567992. t Transfer: 1220 : 34|04:08:20.9459||IsUserAuthenticated: /api/search/workflow?_dc=1576728500769 t Transfer: 1220 : 34|04:08:20.9459||GetCurrentUser.. t Transfer: 1220 : 34|04:08:20.9459|| OAuth authenticated t Transfer: 1220 : 34|04:08:20.9459|| user BB00567992. t Transfer: 1220 : 34|04:08:20.9459||api user: BB00567992 t Information: 1220 : 34|04:08:20.9459||V3Api.SearchWorkflows t Information: 1220 : 34|04:08:20.9459||V3Api.SearchGeneric t Transfer: 1220 : 34|04:08:20.9459||GetCurrentUser.. t Transfer: 1220 : 34|04:08:20.9459|| OAuth authenticated t Transfer: 1220 : 34|04:08:20.9459|| user BB00567992. t Information: 1220 : 34|04:08:20.9459||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 ('TECHM') order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Information: 1220 : 34|04:08:20.9772|| jobs returned 37, searched in 00:00:00.0267703 t Information: 1220 : 34|04:08:21.1334||TechReports is not found. ID: 27. t Information: 1220 : 34|04:08:21.1334||TechReports is not found. ID: 1300. t Information: 1220 : 34|04:08:21.1334||TechReports is not found. ID: 41. t Information: 1220 : 34|04:08:21.1334||TechReports is not found. ID: 96. t Information: 1220 : 34|04:08:21.1334||TechReports is not found. ID: 252. t Information: 1220 : 34|04:08:21.1334||TechReports is not found. ID: 116. t Information: 1220 : 34|04:08:21.1334||TechReports is not found. ID: 672. t Information: 1220 : 34|04:08:21.1334|| tasks returned 37, searched in 00:00:00.1525991 t Transfer: 1220 : 46|04:08:23.4147||IsUserAuthenticated: /api/search/workflow?_dc=1576728503257 t Transfer: 1220 : 46|04:08:23.4147||GetCurrentUser.. t Transfer: 1220 : 46|04:08:23.4147|| OAuth authenticated t Transfer: 1220 : 46|04:08:23.4147|| user BB00567992. t Transfer: 1220 : 46|04:08:23.4147||api user: BB00567992 t Information: 1220 : 46|04:08:23.4147||V3Api.SearchWorkflows t Information: 1220 : 46|04:08:23.4147||V3Api.SearchGeneric t Transfer: 1220 : 46|04:08:23.4147||GetCurrentUser.. t Transfer: 1220 : 46|04:08:23.4147|| OAuth authenticated t Transfer: 1220 : 46|04:08:23.4147|| user BB00567992. t Information: 1220 : 46|04:08:23.4303||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 ('TECHM') order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Information: 1220 : 46|04:08:23.4616|| jobs returned 37, searched in 00:00:00.0371322 t Information: 1220 : 46|04:08:23.5710||TechReports is not found. ID: 27. t Information: 1220 : 46|04:08:23.5710||TechReports is not found. ID: 1300. t Information: 1220 : 46|04:08:23.5710||TechReports is not found. ID: 41. t Information: 1220 : 46|04:08:23.5710||TechReports is not found. ID: 96. t Information: 1220 : 46|04:08:23.5710||TechReports is not found. ID: 252. t Information: 1220 : 46|04:08:23.5710||TechReports is not found. ID: 116. t Information: 1220 : 46|04:08:23.5710||TechReports is not found. ID: 672. t Information: 1220 : 46|04:08:23.5710|| tasks returned 37, searched in 00:00:00.1104737 t Transfer: 1220 : 44|04:08:29.2740||IsUserAuthenticated: /api/v3/job/91519?_dc=1576728509023 t Transfer: 1220 : 44|04:08:29.2740||GetCurrentUser.. t Transfer: 1220 : 44|04:08:29.2740|| OAuth authenticated t Transfer: 1220 : 44|04:08:29.2740|| user BB00567992. t Transfer: 1220 : 44|04:08:29.2740||api user: BB00567992 t Information: 1220 : 44|04:08:29.2897||TechReports is not found. ID: 96. t Information: 1220 : 44|04:08:29.2897||TechReports is not found. ID: 41. t Information: 1220 : 44|04:08:29.2897||TechReports is not found. ID: 116. t Information: 1220 : 44|04:08:29.2897||TechReports is not found. ID: 41. t Information: 1220 : 44|04:08:29.2897||TechReports is not found. ID: 672. t Information: 1220 : 44|04:08:29.2897||TechReports is not found. ID: 41. t Information: 1220 : 44|04:08:29.2897||TechReports is not found. ID: 41. t Information: 1220 : 44|04:08:29.2897||TechReports is not found. ID: 41. t Information: 1220 : 44|04:08:29.2897||TechReports is not found. ID: 41. t Information: 1220 : 44|04:08:29.2897||TechReports is not found. ID: 672. t Information: 1220 : 44|04:08:29.2897||TechReports is not found. ID: 27. t Verbose: 1220 : 44|04:08:29.9928||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\BIG_BROTHER.mov subfolder t Verbose: 1220 : 44|04:08:29.9928|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/BIG_BROTHER.mov t Verbose: 1220 : 44|04:08:29.9928||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/BIG_BROTHER.mov t Transfer: 1220 : 44|04:08:29.9928||GetCurrentUser.. t Transfer: 1220 : 44|04:08:29.9928|| OAuth authenticated t Transfer: 1220 : 44|04:08:29.9928|| user BB00567992. t Transfer: 1220 : 51|04:08:34.8678||IsUserAuthenticated: /api/v3/task/91547/history?_dc=1576728514621 t Transfer: 1220 : 51|04:08:34.8678||GetCurrentUser.. t Transfer: 1220 : 51|04:08:34.8678|| OAuth authenticated t Transfer: 1220 : 51|04:08:34.8678|| user BB00567992. t Transfer: 1220 : 51|04:08:34.8678||api user: BB00567992 t Information: 1220 : 51|04:08:34.8678||V3Api. GetTaskStatusHistory. t Transfer: 1220 : 48|04:08:35.0084||IsUserAuthenticated: /api/v3/task/assess/91547?_dc=1576728514850 t Transfer: 1220 : 48|04:08:35.0084||GetCurrentUser.. t Transfer: 1220 : 48|04:08:35.0084|| OAuth authenticated t Transfer: 1220 : 48|04:08:35.0084|| user BB00567992. t Transfer: 1220 : 48|04:08:35.0084||api user: BB00567992 t Transfer: 1220 : 42|04:08:35.0084||IsUserAuthenticated: /api/v3/task/91547/history?_dc=1576728514826 t Transfer: 1220 : 42|04:08:35.0084||GetCurrentUser.. t Transfer: 1220 : 42|04:08:35.0084|| OAuth authenticated t Transfer: 1220 : 42|04:08:35.0084|| user BB00567992. t Transfer: 1220 : 42|04:08:35.0084||api user: BB00567992 t Information: 1220 : 42|04:08:35.0084||V3Api. GetTaskStatusHistory. t Information: 1220 : 48|04:08:35.5709||TM_MIS. LoadSubtitles for ID: 297790. t Information: 1220 : 48|04:08:35.5709||TM_MIS. LoadSubtitles for ID: 297790. SQL: 'select id, m_ctnr_id, m_ctnr_loc, modified_dt, tv_std, m_ctnr_fmt_id, nvl((select max(l.language) from tm_audio l where l.miid=m.id),aud_language_id) aud_language_id from tm_mis m where mi_deleted=0 and item_type>0 and media_type=101 and PGM_PARENT_ID=293634' t Information: 1220 : 48|04:08:35.5709||TM_MIS. LoadSubtitles for ID: 297790 found no subtitles. t Verbose: 1220 : 48|04:08:35.6491||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001583.mp4 subfolder t Verbose: 1220 : 48|04:08:35.6491|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001583.mp4 t Verbose: 1220 : 48|04:08:35.6491||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/N0001583.mp4 t Transfer: 1220 : 48|04:08:35.6491||GetCurrentUser.. t Transfer: 1220 : 48|04:08:35.6491|| OAuth authenticated t Transfer: 1220 : 48|04:08:35.6491|| user BB00567992. t Transfer: 1220 : 34|04:08:36.6647||IsUserAuthenticated: /api/v3/detailsview/Job/0?lang=en-US&_dc=1576728515888 t Transfer: 1220 : 34|04:08:36.6647||GetCurrentUser.. t Transfer: 1220 : 34|04:08:36.6647|| OAuth authenticated t Transfer: 1220 : 34|04:08:36.6647|| user BB00567992. t Transfer: 1220 : 34|04:08:36.6647||api user: BB00567992 t Transfer: 1220 : 42|04:08:37.0709||IsUserAuthenticated: /api/v3/detailsview/MediaDetails/5?lang=en-US&_dc=1576728516904 t Transfer: 1220 : 42|04:08:37.0709||GetCurrentUser.. t Transfer: 1220 : 42|04:08:37.0709|| OAuth authenticated t Transfer: 1220 : 42|04:08:37.0709|| user BB00567992. t Transfer: 1220 : 42|04:08:37.0709||api user: BB00567992 t Transfer: 1220 : 46|04:08:37.6491||IsUserAuthenticated: /api/v3/layout/default/5?_dc=1576728517370 t Transfer: 1220 : 46|04:08:37.6491||GetCurrentUser.. t Transfer: 1220 : 46|04:08:37.6491|| OAuth authenticated t Transfer: 1220 : 46|04:08:37.6491|| user BB00567992. t Transfer: 1220 : 46|04:08:37.6491||api user: BB00567992 t Information: 1220 : 46|04:08:37.6491||LoadDefaultDashboard. t Transfer: 1220 : 46|04:08:37.6491||GetCurrentUser.. t Transfer: 1220 : 46|04:08:37.6491|| OAuth authenticated t Transfer: 1220 : 46|04:08:37.6491|| user BB00567992. t Transfer: 1220 : 46|04:08:37.6803||GetCurrentUser.. t Transfer: 1220 : 46|04:08:37.6803|| OAuth authenticated t Transfer: 1220 : 46|04:08:37.6803|| user BB00567992. t Transfer: 1220 : 34|04:08:38.2272||IsUserAuthenticated: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1576728518085 t Transfer: 1220 : 34|04:08:38.2272||GetCurrentUser.. t Transfer: 1220 : 34|04:08:38.2272|| OAuth authenticated t Transfer: 1220 : 34|04:08:38.2272|| user BB00567992. t Transfer: 1220 : 34|04:08:38.2272||api user: BB00567992 t Information: 1220 : 34|04:08:38.2272||V3Api.GetUserSettings t Transfer: 1220 : 34|04:08:38.2272||GetCurrentUser.. t Transfer: 1220 : 34|04:08:38.2272|| OAuth authenticated t Transfer: 1220 : 34|04:08:38.2272|| user BB00567992. t Information: 1220 : 49|04:08:38.2272||V3Api.GetMediaTagging t Transfer: 1220 : 44|04:08:38.3365||IsUserAuthenticated: /api/mediavideo/297790?info=smudge&_dc=1576728518172 t Transfer: 1220 : 44|04:08:38.3365||GetCurrentUser.. t Transfer: 1220 : 44|04:08:38.3365|| OAuth authenticated t Transfer: 1220 : 44|04:08:38.3365|| user BB00567992. t Transfer: 1220 : 44|04:08:38.3365||api user: BB00567992 t Verbose: 1220 : 44|04:08:38.3522||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001583.mp4 subfolder t Verbose: 1220 : 44|04:08:38.3522|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001583.mp4 t Verbose: 1220 : 44|04:08:38.3522||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/N0001583.mp4 t Transfer: 1220 : 44|04:08:38.3522||GetCurrentUser.. t Transfer: 1220 : 44|04:08:38.3522|| OAuth authenticated t Transfer: 1220 : 44|04:08:38.3522|| user BB00567992. t Transfer: 1220 : 46|04:08:58.5865||IsUserAuthenticated: /api/media-tagging/C461F54B09844CB09481AAA0BFC5649F?_dc=1576728538346 t Transfer: 1220 : 46|04:08:58.5865||GetCurrentUser.. t Transfer: 1220 : 46|04:08:58.5865|| OAuth authenticated t Transfer: 1220 : 46|04:08:58.5865|| user BB00567992. t Transfer: 1220 : 46|04:08:58.5865||api user: BB00567992 t Information: 1220 : 46|04:08:58.6022||V3Api.SaveMediaTagging t Transfer: 1220 : 46|04:08:58.6022||GetCurrentUser.. t Transfer: 1220 : 46|04:08:58.6022|| OAuth authenticated t Transfer: 1220 : 46|04:08:58.6022|| user BB00567992. t Transfer: 1220 : 46|04:08:58.6178||GetCurrentUser.. t Transfer: 1220 : 46|04:08:58.6178|| OAuth authenticated t Transfer: 1220 : 46|04:08:58.6178|| user BB00567992. t Transfer: 1220 : 46|04:08:58.6178||GetCurrentUser.. t Transfer: 1220 : 46|04:08:58.6178|| OAuth authenticated t Transfer: 1220 : 46|04:08:58.6335|| user BB00567992. t Transfer: 1220 : 46|04:08:58.6335||GetCurrentUser.. t Transfer: 1220 : 46|04:08:58.6335|| OAuth authenticated t Transfer: 1220 : 46|04:08:58.6335|| user BB00567992. t Transfer: 1220 : 46|04:08:58.6335||GetCurrentUser.. t Transfer: 1220 : 46|04:08:58.6335|| OAuth authenticated t Transfer: 1220 : 46|04:08:58.6335|| user BB00567992. t Transfer: 1220 : 46|04:08:58.6335||GetCurrentUser.. t Transfer: 1220 : 46|04:08:58.6335|| OAuth authenticated t Transfer: 1220 : 46|04:08:58.6335|| user BB00567992. t Transfer: 1220 : 46|04:08:58.6335||GetCurrentUser.. t Transfer: 1220 : 46|04:08:58.6335|| OAuth authenticated t Transfer: 1220 : 46|04:08:58.6335|| user BB00567992. t Transfer: 1220 : 46|04:08:58.6335||GetCurrentUser.. t Transfer: 1220 : 46|04:08:58.6335|| OAuth authenticated t Transfer: 1220 : 46|04:08:58.6335|| user BB00567992. t Transfer: 1220 : 43|04:08:59.1959||IsUserAuthenticated: /api/v3/task/assess/?_dc=1576728538351 t Transfer: 1220 : 43|04:08:59.1959||GetCurrentUser.. t Transfer: 1220 : 43|04:08:59.1959|| OAuth authenticated t Transfer: 1220 : 43|04:08:59.1959|| user BB00567992. t Transfer: 1220 : 43|04:08:59.1959||api user: BB00567992 t Verbose: 1220 : 43|04:08:59.3365||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001583.mp4 subfolder t Verbose: 1220 : 43|04:08:59.3365|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001583.mp4 t Verbose: 1220 : 43|04:08:59.3365||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/N0001583.mp4 t Transfer: 1220 : 43|04:08:59.3365||GetCurrentUser.. t Transfer: 1220 : 43|04:08:59.3365|| OAuth authenticated t Transfer: 1220 : 43|04:08:59.3365|| user BB00567992. t Transfer: 1220 : 43|04:08:59.3678||GetCurrentUser.. t Transfer: 1220 : 43|04:08:59.3678|| OAuth authenticated t Transfer: 1220 : 43|04:08:59.3678|| user BB00567992. t Transfer: 1220 : 48|04:09:00.1803||IsUserAuthenticated: /api/v3/task/status/91547/PAUSED?_dc=1576728539934 t Transfer: 1220 : 48|04:09:00.1803||GetCurrentUser.. t Transfer: 1220 : 48|04:09:00.1803|| OAuth authenticated t Transfer: 1220 : 48|04:09:00.1803|| user BB00567992. t Transfer: 1220 : 48|04:09:00.1803||api user: BB00567992 t Information: 1220 : 48|04:09:00.1803||V3Api. SetTaskStatus: 91547, PAUSED, . t Transfer: 1220 : 48|04:09:00.1803||GetCurrentUser.. t Transfer: 1220 : 48|04:09:00.1959|| OAuth authenticated t Transfer: 1220 : 48|04:09:00.1959|| user BB00567992. t Transfer: 1220 : 48|04:09:00.1959||GetCurrentUser.. t Transfer: 1220 : 48|04:09:00.1959|| OAuth authenticated t Transfer: 1220 : 48|04:09:00.1959|| user BB00567992. t Information: 1220 : 48|04:09:00.1959||SerialApiCall. Msg: TaskControl. User: BB00567992. Check Rights: False. Data: ' 91547 13 BB00567992 '. t Information: 1220 : 48|04:09:00.3366||SerialApiCall. Out: ' 13 '. t Transfer: 1220 : 45|04:09:13.2741||IsUserAuthenticated: /api/v3/layout/default/3?_dc=1576728553078 t Transfer: 1220 : 45|04:09:13.2741||GetCurrentUser.. t Transfer: 1220 : 45|04:09:13.2741|| OAuth authenticated t Transfer: 1220 : 45|04:09:13.2741|| user BB00567992. t Transfer: 1220 : 45|04:09:13.2741||api user: BB00567992 t Information: 1220 : 45|04:09:13.2741||LoadDefaultDashboard. t Transfer: 1220 : 45|04:09:13.2741||GetCurrentUser.. t Transfer: 1220 : 45|04:09:13.2741|| OAuth authenticated t Transfer: 1220 : 45|04:09:13.2741|| user BB00567992. t Transfer: 1220 : 12|04:09:17.8678||IsUserAuthenticated: /api/search/workflow?_dc=1576728557709 t Transfer: 1220 : 12|04:09:17.8678||GetCurrentUser.. t Transfer: 1220 : 12|04:09:17.8678|| OAuth authenticated t Transfer: 1220 : 12|04:09:17.8678|| user BB00567992. t Transfer: 1220 : 12|04:09:17.8678||api user: BB00567992 t Information: 1220 : 12|04:09:17.8678||V3Api.SearchWorkflows t Information: 1220 : 12|04:09:17.8678||V3Api.SearchGeneric t Transfer: 1220 : 12|04:09:17.8678||GetCurrentUser.. t Transfer: 1220 : 12|04:09:17.8678|| OAuth authenticated t Transfer: 1220 : 12|04:09:17.8678|| user BB00567992. t Information: 1220 : 12|04:09:17.8835||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 ('TECHM') order by j.J_COMPL_BY, j.id desc, j.id ) a where rownum <= 50) where rnum >= 1 order by rnum t Information: 1220 : 12|04:09:17.9147|| jobs returned 37, searched in 00:00:00.0353506 t Information: 1220 : 12|04:09:18.0084||TechReports is not found. ID: 27. t Information: 1220 : 12|04:09:18.0084||TechReports is not found. ID: 1300. t Information: 1220 : 12|04:09:18.0084||TechReports is not found. ID: 41. t Information: 1220 : 12|04:09:18.0084||TechReports is not found. ID: 96. t Information: 1220 : 12|04:09:18.0084||TechReports is not found. ID: 252. t Information: 1220 : 12|04:09:18.0084||TechReports is not found. ID: 116. t Information: 1220 : 12|04:09:18.0084||TechReports is not found. ID: 672. t Information: 1220 : 12|04:09:18.0084|| tasks returned 37, searched in 00:00:00.0938356 t Transfer: 1220 : 42|04:09:23.1334||IsUserAuthenticated: /api/v3/job/93159?_dc=1576728562594 t Transfer: 1220 : 42|04:09:23.1334||GetCurrentUser.. t Transfer: 1220 : 42|04:09:23.1334|| OAuth authenticated t Transfer: 1220 : 42|04:09:23.1334|| user BB00567992. t Transfer: 1220 : 42|04:09:23.1334||api user: BB00567992 t Verbose: 1220 : 42|04:09:23.2428||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Game of Thrones - Blinkbox-HD.mp4 subfolder t Verbose: 1220 : 42|04:09:23.2428|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Game of Thrones - Blinkbox-HD.mp4 t Verbose: 1220 : 42|04:09:23.2428||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Game of Thrones - Blinkbox-HD.mp4 t Transfer: 1220 : 42|04:09:23.2428||GetCurrentUser.. t Transfer: 1220 : 42|04:09:23.2428|| OAuth authenticated t Transfer: 1220 : 42|04:09:23.2428|| user BB00567992. t Verbose: 1220 : 42|04:09:23.2428||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gots0ep2us.mpd subfolder t Verbose: 1220 : 42|04:09:23.2428|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gots0ep2us.mpd t Verbose: 1220 : 42|04:09:23.2428||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/gots0ep2us.mpd t Transfer: 1220 : 42|04:09:23.2428||GetCurrentUser.. t Transfer: 1220 : 42|04:09:23.2428|| OAuth authenticated t Transfer: 1220 : 42|04:09:23.2428|| user BB00567992. t Transfer: 1220 : 50|04:09:25.3053||IsUserAuthenticated: /api/v3/task/93160/history?_dc=1576728565100 t Transfer: 1220 : 50|04:09:25.3053||GetCurrentUser.. t Transfer: 1220 : 50|04:09:25.3053|| OAuth authenticated t Transfer: 1220 : 50|04:09:25.3053|| user BB00567992. t Transfer: 1220 : 50|04:09:25.3053||api user: BB00567992 t Information: 1220 : 50|04:09:25.3053||V3Api. GetTaskStatusHistory. t Transfer: 1220 : 34|04:09:25.9303||IsUserAuthenticated: /api/v3/task/assess/93160?_dc=1576728565358 t Transfer: 1220 : 34|04:09:25.9303||GetCurrentUser.. t Transfer: 1220 : 34|04:09:25.9303|| OAuth authenticated t Transfer: 1220 : 34|04:09:25.9303|| user BB00567992. t Transfer: 1220 : 34|04:09:25.9303||api user: BB00567992 t Information: 1220 : 34|04:09:25.9459||TM_MIS. LoadSubtitles for ID: 291883. t Information: 1220 : 34|04:09:25.9459||TM_MIS. LoadSubtitles for ID: 291883. SQL: 'select id, m_ctnr_id, m_ctnr_loc, modified_dt, tv_std, m_ctnr_fmt_id, nvl((select max(l.language) from tm_audio l where l.miid=m.id),aud_language_id) aud_language_id from tm_mis m where mi_deleted=0 and item_type>0 and media_type=101 and PGM_PARENT_ID=278628' t Transfer: 1220 : 45|04:09:25.9615||IsUserAuthenticated: /api/v3/task/93160/history?_dc=1576728565335 t Transfer: 1220 : 45|04:09:25.9615||GetCurrentUser.. t Transfer: 1220 : 45|04:09:25.9615|| OAuth authenticated t Transfer: 1220 : 45|04:09:25.9615|| user BB00567992. t Transfer: 1220 : 45|04:09:25.9615||api user: BB00567992 t Information: 1220 : 45|04:09:25.9615||V3Api. GetTaskStatusHistory. t Information: 1220 : 34|04:09:25.9615|| Subtitles added for ID: 291883, 291723 English : 'https://imfxv3tm.tmd.tv/getcaptions.aspx?f=inside game of thrones.stl&som=00:00:00:00&storage=TimedText&modified=637078563280000000&tcf=0&id=291723&tmp=0'. t Information: 1220 : 34|04:09:26.0553||TM_MIS. LoadSubtitles for ID: 291884. t Information: 1220 : 34|04:09:26.0553||TM_MIS. LoadSubtitles for ID: 291884. SQL: 'select id, m_ctnr_id, m_ctnr_loc, modified_dt, tv_std, m_ctnr_fmt_id, nvl((select max(l.language) from tm_audio l where l.miid=m.id),aud_language_id) aud_language_id from tm_mis m where mi_deleted=0 and item_type>0 and media_type=101 and PGM_PARENT_ID=278630' t Information: 1220 : 34|04:09:26.0553||TM_MIS. LoadSubtitles for ID: 291884 found no subtitles. t Verbose: 1220 : 34|04:09:26.0866||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Game of Thrones - Blinkbox-HD.mp4 subfolder t Verbose: 1220 : 34|04:09:26.0866|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Game of Thrones - Blinkbox-HD.mp4 t Verbose: 1220 : 34|04:09:26.0866||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Game of Thrones - Blinkbox-HD.mp4 t Transfer: 1220 : 34|04:09:26.0866||GetCurrentUser.. t Transfer: 1220 : 34|04:09:26.0866|| OAuth authenticated t Transfer: 1220 : 34|04:09:26.0866|| user BB00567992. t Verbose: 1220 : 34|04:09:26.1022||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\gots0ep2us.mpd subfolder t Verbose: 1220 : 34|04:09:26.1022|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/gots0ep2us.mpd t Verbose: 1220 : 34|04:09:26.1022||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/gots0ep2us.mpd t Transfer: 1220 : 34|04:09:26.1022||GetCurrentUser.. t Transfer: 1220 : 34|04:09:26.1022|| OAuth authenticated t Transfer: 1220 : 34|04:09:26.1022|| user BB00567992. t Transfer: 1220 : 49|04:09:26.7897||IsUserAuthenticated: /api/v3/detailsview/Job/0?lang=en-US&_dc=1576728566543 t Transfer: 1220 : 49|04:09:26.7897||GetCurrentUser.. t Transfer: 1220 : 49|04:09:26.7897|| OAuth authenticated t Transfer: 1220 : 49|04:09:26.7897|| user BB00567992. t Transfer: 1220 : 49|04:09:26.7897||api user: BB00567992 t Transfer: 1220 : 48|04:09:27.2584||IsUserAuthenticated: /api/v3/detailsview/MediaDetails/5?lang=en-US&_dc=1576728567006 t Transfer: 1220 : 48|04:09:27.2584||GetCurrentUser.. t Transfer: 1220 : 48|04:09:27.2584|| OAuth authenticated t Transfer: 1220 : 48|04:09:27.2584|| user BB00567992. t Transfer: 1220 : 48|04:09:27.2584||api user: BB00567992 t Transfer: 1220 : 34|04:09:27.7115||IsUserAuthenticated: /api/v3/layout/default/5?_dc=1576728567522 t Transfer: 1220 : 34|04:09:27.7115||GetCurrentUser.. t Transfer: 1220 : 34|04:09:27.7115|| OAuth authenticated t Transfer: 1220 : 34|04:09:27.7115|| user BB00567992. t Transfer: 1220 : 34|04:09:27.7115||api user: BB00567992 t Information: 1220 : 34|04:09:27.7115||LoadDefaultDashboard. t Transfer: 1220 : 34|04:09:27.7115||GetCurrentUser.. t Transfer: 1220 : 34|04:09:27.7115|| OAuth authenticated t Transfer: 1220 : 34|04:09:27.7115|| user BB00567992. t Transfer: 1220 : 34|04:09:27.7428||GetCurrentUser.. t Transfer: 1220 : 34|04:09:27.7428|| OAuth authenticated t Transfer: 1220 : 34|04:09:27.7428|| user BB00567992. t Information: 1220 : 44|04:09:28.1803||V3Api.GetMediaTagging t Transfer: 1220 : 47|04:09:28.3053||IsUserAuthenticated: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1576728568119 t Transfer: 1220 : 47|04:09:28.3053||GetCurrentUser.. t Transfer: 1220 : 47|04:09:28.3053|| OAuth authenticated t Transfer: 1220 : 47|04:09:28.3053|| user BB00567992. t Transfer: 1220 : 47|04:09:28.3053||api user: BB00567992 t Information: 1220 : 47|04:09:28.3053||V3Api.GetUserSettings t Transfer: 1220 : 47|04:09:28.3053||GetCurrentUser.. t Transfer: 1220 : 47|04:09:28.3053|| OAuth authenticated t Transfer: 1220 : 47|04:09:28.3053|| user BB00567992. t Transfer: 1220 : 35|04:09:28.3991||IsUserAuthenticated: /api/mediavideo/291883?info=smudge&_dc=1576728568199 t Transfer: 1220 : 35|04:09:28.3991||GetCurrentUser.. t Transfer: 1220 : 35|04:09:28.3991|| OAuth authenticated t Transfer: 1220 : 35|04:09:28.3991|| user BB00567992. t Transfer: 1220 : 35|04:09:28.3991||api user: BB00567992 t Verbose: 1220 : 35|04:09:28.3991||GetUrl. Enter. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\Game of Thrones - Blinkbox-HD.mp4 subfolder t Verbose: 1220 : 35|04:09:28.3991|| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/Game of Thrones - Blinkbox-HD.mp4 t Verbose: 1220 : 35|04:09:28.3991||GetUrl. Exit. result https://imfxv3tm.tmd.tv/VideoServer/Game of Thrones - Blinkbox-HD.mp4 t Transfer: 1220 : 35|04:09:28.3991||GetCurrentUser.. t Transfer: 1220 : 35|04:09:28.3991|| OAuth authenticated t Transfer: 1220 : 35|04:09:28.3991|| user BB00567992. t Information: 1220 : 51|04:09:28.8991||GetCaptionsForWeb. Filename: inside game of thrones.stl. Device TimedText. Format WebVTT. Timecode format Pal. Media ID 291723. Last Modified 10/28/2019 10:45:28 AM t Information: 1220 : 51|04:09:28.8991||GetCaptions. Start. Filename: inside game of thrones.stl. Cache path C:\inetpub\wwwroot\imfxcore\timedtextcache\. Storage path \\192.168.120.254\DemoFS\Digital Assets\TimedText. Last Modified 10/28/2019 10:45:28 AM t Information: 1220 : 51|04:09:28.9772||GetCaptions. No refresh needed. Filename: C:\inetpub\wwwroot\imfxcore\timedtextcache\inside game of thrones.stl_pal_291723.vtt t Information: 1220 : 51|04:09:28.9772||GetCaptions. In cache. Filename: C:\inetpub\wwwroot\imfxcore\timedtextcache\inside game of thrones.stl_pal_291723.vtt t Transfer: 1220 : 34|04:10:10.0865||IsUserAuthenticated: /api/v3/task/unlock/93160?_dc=1576728609930 t Transfer: 1220 : 34|04:10:10.0865||GetCurrentUser.. t Transfer: 1220 : 34|04:10:10.0865|| OAuth authenticated t Transfer: 1220 : 34|04:10:10.1022|| user BB00567992. t Transfer: 1220 : 34|04:10:10.1022||api user: BB00567992 t Information: 1220 : 34|04:10:10.1022||V3Api. UnlockTask. t Transfer: 1220 : 34|04:10:10.1334||GetCurrentUser.. t Transfer: 1220 : 34|04:10:10.1334|| OAuth authenticated t Transfer: 1220 : 34|04:10:10.1334|| user BB00567992. t Transfer: 1220 : 34|04:10:10.1334||GetCurrentUser.. t Transfer: 1220 : 34|04:10:10.1334|| OAuth authenticated t Transfer: 1220 : 34|04:10:10.1334|| user BB00567992. t Information: 1220 : 34|04:10:10.1334||SerialApiCall. Msg: TaskControl. User: BB00567992. Check Rights: False. Data: ' 93160 22 BB00567992 '. t Information: 1220 : 34|04:10:10.1803||SerialApiCall. Out: ' 22 '. t Information: 1220 : 77|04:30:47.3360||OrabitWatcherBasic. Disposing. t Information: 1220 : 77|04:30:47.3360||OrabitWatcherBasic. Disposed. t Information: 1220 : 77|04:30:47.3360||========================================================================== t Information: 1220 : 77|04:30:47.3360||IMFX CORE SERVER APPLICATION END.