t Transfer: 1220 : 10|05:42:01.3215|kwZU~3||GetAppInfo. DB: TMDDEMO. Install mode: . Auth types: Native, PublicApiKey t Verbose: 1220 : 10|05:42:01.5286|0GDxci||imfx v3 API took 0.004s '/api/v3/visual-asset/group/PnqJC_/2/image' t Verbose: 1220 : 10|05:42:07.2526|yAEJL2||Oauth validating.. t Verbose: 1220 : 10|05:42:07.2526|yAEJL2||GrantResourceOwnerCredentials. t Verbose: 1220 : 10|05:42:07.2526|yAEJL2||LoginUser. cjpowercast, login type OAuth, encrypt password True t Information: 1220 : 10|05:42:07.2526|yAEJL2||TryLoginUser. cjpowercast, login type OAuth, check password True, check hash False, encrypt password True, load user data False t Information: 1220 : 10|05:42:07.2526|yAEJL2|| oauth token 00000000-0000-0000-0000-000000000000 t Information: 1220 : 10|05:42:07.2526|yAEJL2||TryLoginUser. Logged in.. t Verbose: 1220 : 10|05:42:07.2526|yAEJL2||LoginUser. Adding history. User Id 1165, result CJPOWERCAST, host 192.168.127.6 t Verbose: 1220 : 10|05:42:07.2526|yAEJL2||GrantResourceOwnerCredentials. Try login finished. Logged: True t Transfer: 1220 : 10|05:42:07.8620|oJxRRm|CJPOWERCAST|OAuth: /api/user-group-preferences?keys=defaultSearchColumnsMedia,defaultSearchColumnsVersion,defaultSearchColumnsSimple,defaultSearchColumnsTitle,defaultSearchMisrDetailsMediaColumns,versionCreationSettings,associate.advanced_search.version.setups,associate.advanced_search.media.setups,associate.wfrise.setups,supplier_portal.advanced_search.version.setups,media_portal.del_history.advanced.search_criteria,supplier_portal.version_complete.setups,logoImage,uploadSettings,helpdeskUrl,customLabels,googleMapsApiSettings&globals=isDebugMode,htmlplayerhotkeys,versionCreationSettings,associate.advanced_search.version.setups,associate.advanced_search.media.setups,associate.wfrise.setups,supplier_portal.advanced_search.version.setups,media_portal.del_history.advanced.search_criteria,helpdeskUrl,customLabels&_dc=1691556127556 t Transfer: 1220 : 10|05:42:07.8620|oJxRRm|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:07.8620|oJxRRm|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:07.8620|oJxRRm|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|05:42:07.8620|oJxRRm|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|05:42:07.8620|oJxRRm|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:07.8620|oJxRRm|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:07.8620|oJxRRm|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|05:42:07.8620|oJxRRm|CJPOWERCAST|imfx v3 API took 0.040s '/api/user-group-preferences?keys=defaultSearchColumnsMedia,defaultSearchColumnsVersion,defaultSearchColumnsSimple,defaultSearchColumnsTitle,defaultSearchMisrDetailsMediaColumns,versionCreationSettings,associate.advanced_search.version.setups,associate.advanced_search.media.setups,associate.wfrise.setups,supplier_portal.advanced_search.version.setups,media_portal.del_history.advanced.search_criteria,supplier_portal.version_complete.setups,logoImage,uploadSettings,helpdeskUrl,customLabels,googleMapsApiSettings&globals=isDebugMode,htmlplayerhotkeys,versionCreationSettings,associate.advanced_search.version.setups,associate.advanced_search.media.setups,associate.wfrise.setups,supplier_portal.advanced_search.version.setups,media_portal.del_history.advanced.search_criteria,helpdeskUrl,customLabels&_dc=1691556127556' t Transfer: 1220 : 10|05:42:08.0665|0gAS~2|CJPOWERCAST|OAuth: /api/user-preferences?keys=personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch;workflow_queues_actions;workflow_queues_settings&_dc=1691556127884 t Transfer: 1220 : 10|05:42:08.0665|0gAS~2|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:08.0665|0gAS~2|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:08.0665|0gAS~2|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|05:42:08.0665|0gAS~2|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|05:42:08.0665|0gAS~2|CJPOWERCAST|GetUserDataByKeys: personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch;workflow_queues_actions;workflow_queues_settings t Transfer: 1220 : 10|05:42:08.0665|0gAS~2|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:08.0665|0gAS~2|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:08.0665|0gAS~2|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|05:42:08.0665|0gAS~2|CJPOWERCAST|imfx v3 API took 0.025s '/api/user-preferences?keys=personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch;workflow_queues_actions;workflow_queues_settings&_dc=1691556127884' t Information: 1220 : 10|05:42:08.4727|D_9coI|CJPOWERCAST|GetUserProfile. Id: 0 t Transfer: 1220 : 10|05:42:08.4727|D_9coI|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:08.4727|D_9coI|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:08.4727|D_9coI|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|05:42:08.8790|yqef_R|CJPOWERCAST|OAuth: /api/settings/user/mainMenuSettings?_dc=1691556128615 t Transfer: 1220 : 10|05:42:08.8790|yqef_R|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:08.8790|yqef_R|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:08.8790|yqef_R|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|05:42:08.8790|yqef_R|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|05:42:08.8790|wKeNxl|CJPOWERCAST|OAuth: /api/settings/group/0?_dc=1691556128614 t Transfer: 1220 : 10|05:42:08.8790|wKeNxl|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:08.8790|wKeNxl|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:08.8790|wKeNxl|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|05:42:08.8790|wKeNxl|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|05:42:08.8790|yqef_R|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:08.8790|yqef_R|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:08.8790|yqef_R|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|05:42:08.8790|yqef_R|CJPOWERCAST|imfx v3 API took 0.090s '/api/settings/user/mainMenuSettings?_dc=1691556128615' t Verbose: 1220 : 10|05:42:09.0836|wKeNxl|CJPOWERCAST|imfx v3 API took 0.079s '/api/settings/group/0?_dc=1691556128614' t Transfer: 1220 : 10|05:42:09.2867|606FZU|CJPOWERCAST|OAuth: /api/settings/user/uploadSettings?_dc=1691556128620 t Transfer: 1220 : 10|05:42:09.2867|606FZU|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:09.2867|606FZU|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:09.2867|606FZU|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|05:42:09.2867|606FZU|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|05:42:09.2867|606FZU|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:09.2867|606FZU|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:09.2867|606FZU|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|05:42:09.2867|606FZU|CJPOWERCAST|imfx v3 API took 0.004s '/api/settings/user/uploadSettings?_dc=1691556128620' t Transfer: 1220 : 10|05:42:09.4899|TKWmTJ|CJPOWERCAST|OAuth: /api/lookups/PgmStatus?_dc=1691556128636 t Transfer: 1220 : 10|05:42:09.4899|TKWmTJ|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:09.4899|TKWmTJ|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:09.4899|TKWmTJ|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|05:42:09.4899|TKWmTJ|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 10|05:42:09.4899|TKWmTJ|CJPOWERCAST|imfx v3 API took 0.000s '/api/lookups/PgmStatus?_dc=1691556128636' t Transfer: 1220 : 10|05:42:09.4899|t_GBj3|CJPOWERCAST|OAuth: /api/settings/group/0?_dc=1691556128629 t Transfer: 1220 : 10|05:42:09.4899|t_GBj3|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:09.4899|t_GBj3|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:09.4899|t_GBj3|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|05:42:09.4899|t_GBj3|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|05:42:09.4899|P8jWW7|CJPOWERCAST|OAuth: /api/lookups/MediaStatus?_dc=1691556128636 t Transfer: 1220 : 10|05:42:09.4899|P8jWW7|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:09.4899|P8jWW7|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:09.4899|P8jWW7|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|05:42:09.4899|P8jWW7|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|05:42:09.4899|8dkPL~|CJPOWERCAST|OAuth: /api/settings/user/mainMenuSettings?_dc=1691556128630 t Transfer: 1220 : 10|05:42:09.4899|8dkPL~|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:09.4899|8dkPL~|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:09.4899|8dkPL~|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|05:42:09.4899|8dkPL~|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 10|05:42:09.4899|_MMxLW||imfx v3 API took 0.004s '/api/v3/visual-asset/group/Any_gO/0/image' t Transfer: 1220 : 10|05:42:09.4899|wz1fAV|CJPOWERCAST|OAuth: /api/lookup/CustomMediaStatusTypes?_dc=1691556128637 t Transfer: 1220 : 10|05:42:09.4899|wz1fAV|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:09.4899|wz1fAV|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:09.4899|wz1fAV|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|05:42:09.4899|wz1fAV|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 10|05:42:09.6930|t_GBj3|CJPOWERCAST|imfx v3 API took 0.107s '/api/settings/group/0?_dc=1691556128629' t Transfer: 1220 : 10|05:42:09.6930|8dkPL~|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:09.6930|8dkPL~|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:09.6930|8dkPL~|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|05:42:09.6930|P8jWW7|CJPOWERCAST|imfx v3 API took 0.000s '/api/lookups/MediaStatus?_dc=1691556128636' t Verbose: 1220 : 10|05:42:09.6930|8dkPL~|CJPOWERCAST|imfx v3 API took 0.003s '/api/settings/user/mainMenuSettings?_dc=1691556128630' t Verbose: 1220 : 10|05:42:09.6930|wz1fAV|CJPOWERCAST|imfx v3 API took 0.004s '/api/lookup/CustomMediaStatusTypes?_dc=1691556128637' t Transfer: 1220 : 10|05:42:09.8961|nBNLn0|CJPOWERCAST|OAuth: /api/lookup/CustomVersionStatusTypes?_dc=1691556128637 t Transfer: 1220 : 10|05:42:09.8961|nBNLn0|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:09.8961|nBNLn0|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:09.8961|nBNLn0|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|05:42:09.8961|nBNLn0|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 10|05:42:09.8961|nBNLn0|CJPOWERCAST|imfx v3 API took 0.003s '/api/lookup/CustomVersionStatusTypes?_dc=1691556128637' t Transfer: 1220 : 10|05:42:09.8961|Bkbboa|CJPOWERCAST|OAuth: /api/lookup/CustomTitleStatusTypes?_dc=1691556128638 t Transfer: 1220 : 10|05:42:09.8961|Bkbboa|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:09.8961|Bkbboa|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:09.8961|Bkbboa|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|05:42:09.8961|Bkbboa|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 10|05:42:09.8961|Bkbboa|CJPOWERCAST|imfx v3 API took 0.003s '/api/lookup/CustomTitleStatusTypes?_dc=1691556128638' t Transfer: 1220 : 10|05:42:09.8961|QAfbrQ|CJPOWERCAST|OAuth: /api/settings/user/defaultHomePage?_dc=1691556128638 t Transfer: 1220 : 10|05:42:09.8961|QAfbrQ|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:09.8961|QAfbrQ|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:09.8961|QAfbrQ|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|05:42:09.8961|QAfbrQ|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|05:42:09.8961|QAfbrQ|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:09.8961|QAfbrQ|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:09.8961|QAfbrQ|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|05:42:09.8961|QAfbrQ|CJPOWERCAST|imfx v3 API took 0.004s '/api/settings/user/defaultHomePage?_dc=1691556128638' t Verbose: 1220 : 10|05:42:09.8961|kxoOeq||imfx v3 API took 0.003s '/api/v3/visual-asset/group/Any_gO/1/image' t Transfer: 1220 : 10|05:42:10.5068|_UEHFk|CJPOWERCAST|OAuth: /api/settings/user/startSearch?_dc=1691556130154 t Transfer: 1220 : 10|05:42:10.5068|_UEHFk|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:10.5068|_UEHFk|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:10.5068|_UEHFk|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|05:42:10.5068|_UEHFk|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|05:42:10.5068|_UEHFk|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:10.5068|_UEHFk|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:10.5068|_UEHFk|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|05:42:10.5068|2uCrA9|CJPOWERCAST|OAuth: /api/settings/user/defaultSearch?_dc=1691556130154 t Transfer: 1220 : 10|05:42:10.5068|2uCrA9|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:10.5068|2uCrA9|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:10.5068|2uCrA9|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|05:42:10.5068|2uCrA9|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 10|05:42:10.5068|_UEHFk|CJPOWERCAST|imfx v3 API took 0.004s '/api/settings/user/startSearch?_dc=1691556130154' t Transfer: 1220 : 10|05:42:10.5068|2uCrA9|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:10.5068|2uCrA9|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:10.5068|2uCrA9|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|05:42:10.5068|2uCrA9|CJPOWERCAST|imfx v3 API took 0.003s '/api/settings/user/defaultSearch?_dc=1691556130154' t Verbose: 1220 : 10|05:42:10.7099|93MjLl||imfx v3 API took 0.004s '/api/v3/visual-asset/group/Any_gO/3/image' t Transfer: 1220 : 10|05:42:10.7099|KL8bwD|CJPOWERCAST|OAuth: /api/user-preferences?keys=consumer.recent.data&_dc=1691556130489 t Transfer: 1220 : 10|05:42:10.7099|XXp9~A|CJPOWERCAST|OAuth: /api/user-preferences?keys=adv.recent.searches.consumer&_dc=1691556130494 t Transfer: 1220 : 10|05:42:10.7099|XXp9~A|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:10.7099|KL8bwD|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:10.7099|KL8bwD|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:10.7099|XXp9~A|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:10.7099|XXp9~A|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|05:42:10.7099|XXp9~A|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|05:42:10.7099|KL8bwD|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|05:42:10.7099|KL8bwD|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|05:42:10.7099|KL8bwD|CJPOWERCAST|GetUserDataByKeys: consumer.recent.data t Transfer: 1220 : 10|05:42:10.7099|KL8bwD|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:10.7099|KL8bwD|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:10.7099|KL8bwD|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|05:42:10.7099|XXp9~A|CJPOWERCAST|GetUserDataByKeys: adv.recent.searches.consumer t Transfer: 1220 : 10|05:42:10.7099|XXp9~A|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:10.7099|XXp9~A|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:10.7099|XXp9~A|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|05:42:10.7099|KL8bwD|CJPOWERCAST|imfx v3 API took 0.007s '/api/user-preferences?keys=consumer.recent.data&_dc=1691556130489' t Verbose: 1220 : 10|05:42:10.7099|XXp9~A|CJPOWERCAST|imfx v3 API took 0.009s '/api/user-preferences?keys=adv.recent.searches.consumer&_dc=1691556130494' t Transfer: 1220 : 10|05:42:14.8166|hPYYmJ|CJPOWERCAST|OAuth: /api/user-preferences?keys=adv.recent.searches.titles&_dc=1691556134527 t Transfer: 1220 : 10|05:42:14.8166|mvWr_v|CJPOWERCAST|OAuth: /api/lookups/SearchSupportedOperators?_dc=1691556134525 t Transfer: 1220 : 10|05:42:14.8166|mvWr_v|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:14.8166|hPYYmJ|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:14.8166|mvWr_v|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:14.8166|hPYYmJ|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:14.8166|mvWr_v|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|05:42:14.8166|hPYYmJ|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|05:42:14.8166|hPYYmJ|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 10|05:42:14.8166|mvWr_v|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|05:42:14.8166|PZ~XTn|CJPOWERCAST|OAuth: /api/view/searchinfo/TitleSearch?_dc=1691556134525 t Transfer: 1220 : 10|05:42:14.8166|PZ~XTn|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:14.8166|PZ~XTn|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:14.8166|PZ~XTn|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|05:42:14.8166|PZ~XTn|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Verbose: 1220 : 10|05:42:14.8166|mvWr_v|CJPOWERCAST|imfx v3 API took 0.000s '/api/lookups/SearchSupportedOperators?_dc=1691556134525' t Information: 1220 : 10|05:42:14.8166|hPYYmJ|CJPOWERCAST|GetUserDataByKeys: adv.recent.searches.titles t Transfer: 1220 : 10|05:42:14.8166|hPYYmJ|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:14.8166|hPYYmJ|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:14.8166|hPYYmJ|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|05:42:14.8166|PZ~XTn|CJPOWERCAST|GetAdvSearchColumns. search type TitleSearch grid . t Verbose: 1220 : 10|05:42:14.8166|PZ~XTn|CJPOWERCAST|imfx v3 API took 0.000s '/api/view/searchinfo/TitleSearch?_dc=1691556134525' t Verbose: 1220 : 10|05:42:14.8166|hPYYmJ|CJPOWERCAST|imfx v3 API took 0.011s '/api/user-preferences?keys=adv.recent.searches.titles&_dc=1691556134527' t Transfer: 1220 : 10|05:42:14.8166|31c2r7|CJPOWERCAST|OAuth: /api/view/searches/TitleSearch?_dc=1691556134553 t Transfer: 1220 : 10|05:42:14.8166|31c2r7|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:14.8166|31c2r7|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:14.8166|31c2r7|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|05:42:14.8166|31c2r7|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|05:42:14.8166|31c2r7|CJPOWERCAST|GetSavedSearchNames. search type TitleSearch. t Transfer: 1220 : 10|05:42:14.8166|31c2r7|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:14.8166|31c2r7|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:14.8166|31c2r7|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|05:42:14.8166|31c2r7|CJPOWERCAST|imfx v3 API took 0.006s '/api/view/searches/TitleSearch?_dc=1691556134553' t Transfer: 1220 : 10|05:42:14.8166|0QV4xv|CJPOWERCAST|OAuth: /api/view/info/VersionGrid?lang=en-GB&_dc=1691556134562 t Transfer: 1220 : 10|05:42:14.8166|0QV4xv|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:14.8166|0QV4xv|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:14.8166|0QV4xv|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|05:42:14.8166|0QV4xv|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|05:42:14.8166|0QV4xv|CJPOWERCAST|GetGridViewBuilder. builder type VersionGrid. t Transfer: 1220 : 10|05:42:14.8166|0QV4xv|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:14.8166|0QV4xv|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:14.8166|0QV4xv|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|05:42:14.8166|0QV4xv|CJPOWERCAST|UserGridView. LoadView. ID -2, Name Default. t Transfer: 1220 : 10|05:42:14.8166|0QV4xv|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:14.8166|0QV4xv|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:14.8166|0QV4xv|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|05:42:14.8166|0QV4xv|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:14.8166|0QV4xv|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:14.8166|0QV4xv|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|05:42:14.8166|0QV4xv|CJPOWERCAST|imfx v3 API took 0.011s '/api/view/info/VersionGrid?lang=en-GB&_dc=1691556134562' t Transfer: 1220 : 10|05:42:14.8166|bRyzAl|CJPOWERCAST|OAuth: /api/view/info/MediaGrid?lang=en-GB&_dc=1691556134603 t Transfer: 1220 : 10|05:42:14.8166|bRyzAl|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:14.8166|bRyzAl|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:14.8166|bRyzAl|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|05:42:14.8166|bRyzAl|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|05:42:14.8166|bRyzAl|CJPOWERCAST|GetGridViewBuilder. builder type MediaGrid. t Transfer: 1220 : 10|05:42:14.8166|bRyzAl|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:14.8166|bRyzAl|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:14.8166|bRyzAl|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|05:42:14.8166|bRyzAl|CJPOWERCAST|UserGridView. LoadView. ID -2, Name Default. t Transfer: 1220 : 10|05:42:14.8166|bRyzAl|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:14.8166|bRyzAl|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:14.8166|bRyzAl|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|05:42:14.8166|bRyzAl|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:14.8166|bRyzAl|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:14.8166|bRyzAl|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|05:42:14.8166|bRyzAl|CJPOWERCAST|imfx v3 API took 0.009s '/api/view/info/MediaGrid?lang=en-GB&_dc=1691556134603' t Transfer: 1220 : 10|05:42:15.0353|cbI3xR|CJPOWERCAST|OAuth: /api/view/info/DigitalCarriers?lang=en-GB&_dc=1691556134630 t Transfer: 1220 : 10|05:42:15.0353|cbI3xR|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:15.0353|cbI3xR|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:15.0353|cbI3xR|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|05:42:15.0353|cbI3xR|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|05:42:15.0353|cbI3xR|CJPOWERCAST|GetGridViewBuilder. builder type DigitalCarriers. t Transfer: 1220 : 10|05:42:15.0353|cbI3xR|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:15.0353|cbI3xR|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:15.0353|cbI3xR|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|05:42:15.0353|cbI3xR|CJPOWERCAST|UserGridView. LoadView. ID -2, Name Default. t Transfer: 1220 : 10|05:42:15.0353|cbI3xR|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:15.0353|cbI3xR|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:15.0353|cbI3xR|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|05:42:15.0353|cbI3xR|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:15.0353|cbI3xR|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:15.0353|cbI3xR|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|05:42:15.0353|cbI3xR|CJPOWERCAST|imfx v3 API took 0.008s '/api/view/info/DigitalCarriers?lang=en-GB&_dc=1691556134630' t Transfer: 1220 : 10|05:42:15.0353|GfyukS|CJPOWERCAST|OAuth: /api/view/info/TitleTree?lang=en-GB&_dc=1691556134655 t Transfer: 1220 : 10|05:42:15.0353|GfyukS|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:15.0353|GfyukS|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:15.0353|GfyukS|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|05:42:15.0353|GfyukS|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|05:42:15.0353|GfyukS|CJPOWERCAST|GetGridViewBuilder. builder type TitleTree. t Transfer: 1220 : 10|05:42:15.0353|GfyukS|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:15.0353|GfyukS|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:15.0353|GfyukS|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|05:42:15.0353|GfyukS|CJPOWERCAST|UserGridView. LoadView. ID -2, Name Default. t Transfer: 1220 : 10|05:42:15.0353|GfyukS|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:15.0353|GfyukS|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:15.0353|GfyukS|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|05:42:15.0353|GfyukS|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:15.0353|GfyukS|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:15.0353|GfyukS|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|05:42:15.0353|GfyukS|CJPOWERCAST|imfx v3 API took 0.007s '/api/view/info/TitleTree?lang=en-GB&_dc=1691556134655' t Transfer: 1220 : 10|05:42:17.0722|AosMYv|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1691556136782 t Transfer: 1220 : 10|05:42:17.0722|AosMYv|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:17.0722|AosMYv|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:17.0722|AosMYv|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|05:42:17.0722|AosMYv|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|05:42:17.0722|AosMYv|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:17.0722|AosMYv|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:17.0722|AosMYv|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|05:42:17.0722|beZQXM|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1691556136898 t Transfer: 1220 : 10|05:42:17.0722|beZQXM|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:17.0722|beZQXM|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:17.0722|beZQXM|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|05:42:17.0722|beZQXM|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|05:42:17.0722|beZQXM|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:17.0722|beZQXM|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:17.0722|beZQXM|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|05:42:17.2753|AosMYv|CJPOWERCAST|imfx v3 API took 0.299s '/api/v3/search-suggestion/?_dc=1691556136782' t Verbose: 1220 : 10|05:42:17.2753|beZQXM|CJPOWERCAST|imfx v3 API took 0.207s '/api/v3/search-suggestion/?_dc=1691556136898' t Transfer: 1220 : 10|05:42:18.9016|piyaG8|CJPOWERCAST|OAuth: /api/v3/search/title?_dc=1691556138563 t Transfer: 1220 : 10|05:42:18.9016|piyaG8|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:18.9016|piyaG8|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:18.9016|piyaG8|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|05:42:18.9016|piyaG8|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|05:42:18.9016|piyaG8|CJPOWERCAST|V3Api.SearchTitles t Information: 1220 : 10|05:42:18.9016|piyaG8|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 10|05:42:18.9016|piyaG8|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:18.9016|piyaG8|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:18.9016|piyaG8|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|05:42:18.9016|piyaG8|CJPOWERCAST|SearchTitle SQL: with v as ( SELECT abs.* ,(select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = abs.net_grp_id) CHANNEL_GROUP ,decode(ITEM_TYPE, 1010,SER_ABS_ID, 1020,CASE WHEN SER_ABS2_ID > 0 THEN SER_ABS2_ID ELSE SER_ABS_ID END ) xparent_id FROM TMDDBA.TM_PG_ABS abs WHERE abs.id in ( select a.id FROM TMDDBA.TM_PG_ABS a where ABS_DELETED = 0 AND (INSTR(OWNERS,'|SFP2|')>0 OR INSTR(OWNERS,'|PSP|')>0 OR INSTR(OWNERS,'|PMS|')>0 OR INSTR(OWNERS,'|SFP1|')>0 OR INSTR(OWNERS,'|PMH|')>0 OR INSTR(OWNERS,'|PPL|')>0 ) AND a.ser_abs_id=:param_0 AND ROWNUM < 25000 ) ) ,v_missing_parent_ids as ( select xparent_id from v minus select id from v ) ,v_missing_parents as ( SELECT distinct a.* ,(select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = a.net_grp_id) CHANNEL_GROUP ,decode(ITEM_TYPE, 1010,SER_ABS_ID, 1020,CASE WHEN SER_ABS2_ID > 0 THEN SER_ABS2_ID ELSE SER_ABS_ID END ) xparent_id FROM TMDDBA.TM_PG_ABS a START WITH ID IN (select xparent_id from v_missing_parent_ids) CONNECT BY CASE PRIOR ITEM_TYPE WHEN 1010 THEN PRIOR SER_ABS_ID WHEN 1020 THEN CASE WHEN NVL(PRIOR SER_ABS2_ID, 0) > 0 THEN PRIOR SER_ABS2_ID ELSE PRIOR SER_ABS_ID END END = ID ) ,v_all as ( select x.*, count(*) over() RowCount from ( select * from v_missing_parents union select * from v ) x ) ,v_top as ( select id from (select id, row_number()over(order by upper(ser_title),upper(title),ser_num,ser_ep_num, SER_EP_SQ_NUM ) rnk -- sort roots from v_all where xparent_id is null) where rnk between (:page_number-1)*50+1 and :page_number*50 ) ,v_tree as ( select level "TreeLevel", a.*from v_all a start with id in (select id from v_top) connect by xparent_id = prior ID order siblings by upper(ser_title),ser_num,ser_ep_num, SER_EP_SQ_NUM,upper(title) -- sort children ) select * from v_tree --where rnk <= 50 t Verbose: 1220 : 10|05:42:19.1060|piyaG8|CJPOWERCAST|Alternative title fields query: select * from (select x.id,x.id TitleId from TM_PG_ABS x where id in (select /*+ cardinality(4) */ column_value id from table(:ids))) y,lateral (select dbms_lob.substr( o.text_data_plain, 1000, 1 ) Field_5799344 from tm_txt_obj o where (o.pgm_abs_id=y.TitleId) and o.type_id=:param_1 order by o.id desc fetch first 1 rows only)(+) t Verbose: 1220 : 10|05:42:19.1060|piyaG8|CJPOWERCAST|imfx v3 API took 0.248s '/api/v3/search/title?_dc=1691556138563' t Transfer: 1220 : 10|05:42:19.7154|yROFur|CJPOWERCAST|OAuth: /api/v3/title/299390/versions?_dc=1691556139392 t Transfer: 1220 : 10|05:42:19.7154|yROFur|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:19.7154|yROFur|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:19.7154|yROFur|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|05:42:19.7154|yROFur|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|05:42:19.7154|W04BnC|CJPOWERCAST|OAuth: /api/user-preferences?_dc=1691556139394 t Transfer: 1220 : 10|05:42:19.7154|W04BnC|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:19.7154|W04BnC|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:19.7154|W04BnC|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|05:42:19.7154|W04BnC|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Information: 1220 : 10|05:42:19.7154|yROFur|CJPOWERCAST|V3Api.SearchGeneric t Transfer: 1220 : 10|05:42:19.7154|yROFur|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:19.7154|yROFur|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:19.7154|yROFur|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|05:42:19.7154|yROFur|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:19.7154|yROFur|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:19.7154|yROFur|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|05:42:19.7154|W04BnC|CJPOWERCAST|StoreUserDataByKeys.. t Transfer: 1220 : 10|05:42:19.7154|W04BnC|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:19.7154|W04BnC|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:19.7154|W04BnC|CJPOWERCAST| user CJPOWERCAST. t Transfer: 1220 : 10|05:42:19.7154|yROFur|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:19.7154|yROFur|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:19.7154|yROFur|CJPOWERCAST| user CJPOWERCAST. t Information: 1220 : 10|05:42:19.7154|yROFur|CJPOWERCAST|SearchVersion SQL: select v.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE , (select min(name) from TM_CFG_AUDIO_CONTENT_MS_TYPES audio where v.audio_type = audio.id ) SOUND ,(select min(from_date_time) from TM_PG_RL_PROD_DATE prodDate where prodDate.Tm_Pg_Rl_Id = v.id ) PROD_FROM_DATE ,(select min(to_date_time) from TM_PG_RL_PROD_DATE prodDate where prodDate.Tm_Pg_Rl_Id = v.id ) PROD_TO_DATE ,(select min(full_name) from tm_lang_data lang, TM_PG_RL_LANG_LNX link where lang.id = link.lang_id and link.tm_pg_rl_id = v.id) PROD_LANGUAGE ,(SELECT min(COLOUR_NAME) FROM tm_cfg_colour_list list, tm_pg_rl ver where ver.col_mono = list.id and ver.id = v.id) PROD_COLOUR_TEXT ,(SELECT min(cfg.prod_date_type_name) FROM TM_PG_RL_PROD_DATE pg_rl, tm_cfg_prod_date_type cfg where cfg.id = pg_rl.PROD_DATE_TYPE_ID and TM_PG_RL_ID = v.id ) PROD_DATE_TYPE ,(select min(status.description) from TM_CFG_PGM_STATUS status where v.ITEM_STATUS_ID = status.id) PGM_STATUS_TEXT ,(select submed.sub_medium_name from TM_CFG_SUB_MEDIUM submed where v.SUB_MEDIUM_ID = submed.id) SUB_MEDIUM_TEXT ,(select med.medium_name from TM_CFG_MEDIUM med, TM_PG_ABS pgabs where pgabs.id=v.PGM_ABS_ID and pgabs.MEDIUM_ID = med.id) MEDIUM_TEXT ,(select replace(tmd_str_agg_pipe(cf.form_name),'|',' / ') from TM_PG_FORM_LNX fl join TM_CFG_FORM cf on (cf.id=fl.form_id) where fl.tm_pg_id = v.ID) FORM_TEXT ,(select replace(tmd_str_agg_pipe(dvb.item_name),'|',' / ') from TM_PG_ABS_GENRE_LNX gl join TM_DVB dvb on (dvb.id=gl.genre_id) where gl.tm_pg_abs_id = v.PGM_ABS_ID) GENRE_TEXT, (select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = v.net_grp_id) CHANNEL_GROUP, (select count(id) from tm_mis where item_type>0 and pgm_parent_id=v.id) MEDIA_COUNT, (select cvt.ID from TM_PORTAL_VERSION_CONFIG cvt where v.CUSTOM_VERSION_TYPE = cvt.CUSTOM_VERSION_TYPE AND cvt.CUSTOM_VERSION_TYPE IS NOT NULL ) MP_CONFIG_ID from (select v.*, coalesce(v.primary_thumb_id, (select x.primary_thumb_id from tm_pg_rl x where x.id=v.parent_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.pgm_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs2_id) ) primary_thumb_id2 from tmddba.tm_pg_rl v where v.item_type > 0 and v.rl_deleted = 0) v left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = v.primary_thumb_id2 --sqlIdSearchJoin where 1=1 AND (INSTR(v.OWNERS,'|SFP2|')>0 OR INSTR(v.OWNERS,'|PSP|')>0 OR INSTR(v.OWNERS,'|PMS|')>0 OR INSTR(v.OWNERS,'|SFP1|')>0 OR INSTR(v.OWNERS,'|PMH|')>0 OR INSTR(v.OWNERS,'|PPL|')>0) and v.id in (select x.id from tmddba.tm_pg_rl x start with x.id in ( select a.id from (select m.id, rownum rnum from tmddba.tm_pg_rl m where item_type>0 and rl_deleted=0 and m.PGM_ABS_ID=:param_0 AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0) ) A WHERE rnum>=1 and rnum <= 9999 ) connect by nocycle prior x.parent_id=x.id) t Transfer: 1220 : 10|05:42:19.7154|yROFur|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:19.7154|yROFur|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:19.7154|yROFur|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|05:42:19.7154|W04BnC|CJPOWERCAST|imfx v3 API took 0.010s '/api/user-preferences?_dc=1691556139394' t Information: 1220 : 10|05:42:19.7154|yROFur|CJPOWERCAST|Running version search. User: 1165 Simple Search: Running Oracle search. Running Oracle search for COUNT Oracle count completed in: 5ms. Returned lines: 0 t Verbose: 1220 : 10|05:42:19.7154|yROFur|CJPOWERCAST|imfx v3 API took 0.014s '/api/v3/title/299390/versions?_dc=1691556139392' t Transfer: 1220 : 10|05:42:23.4253|A6g3u8|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1691556143192 t Transfer: 1220 : 10|05:42:23.4253|A6g3u8|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:23.4253|A6g3u8|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:23.4253|A6g3u8|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|05:42:23.4253|A6g3u8|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|05:42:23.4253|A6g3u8|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:23.4253|A6g3u8|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:23.4253|A6g3u8|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|05:42:23.4253|A6g3u8|CJPOWERCAST|imfx v3 API took 0.010s '/api/v3/search-suggestion/?_dc=1691556143192' t Transfer: 1220 : 10|05:42:23.8316|2Gt3OX|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1691556143668 t Transfer: 1220 : 10|05:42:23.8316|2Gt3OX|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:23.8316|2Gt3OX|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:23.8316|2Gt3OX|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|05:42:23.8316|2Gt3OX|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|05:42:23.8316|2Gt3OX|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:23.8316|2Gt3OX|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:23.8316|2Gt3OX|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|05:42:23.8316|2Gt3OX|CJPOWERCAST|imfx v3 API took 0.005s '/api/v3/search-suggestion/?_dc=1691556143668' t Transfer: 1220 : 10|05:42:25.8722|DC4wFE|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1691556145535 t Transfer: 1220 : 10|05:42:25.8722|DC4wFE|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:25.8722|DC4wFE|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:25.8722|DC4wFE|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|05:42:25.8722|DC4wFE|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|05:42:25.8722|DC4wFE|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:25.8722|DC4wFE|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:25.8722|DC4wFE|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|05:42:25.8722|DC4wFE|CJPOWERCAST|imfx v3 API took 0.006s '/api/v3/search-suggestion/?_dc=1691556145535' t Transfer: 1220 : 10|05:42:26.0753|TgQpxK|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1691556145777 t Transfer: 1220 : 10|05:42:26.0753|TgQpxK|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:26.0753|TgQpxK|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:26.0753|TgQpxK|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|05:42:26.0753|TgQpxK|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|05:42:26.0753|TgQpxK|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:26.0753|TgQpxK|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:26.0753|TgQpxK|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|05:42:26.0753|TgQpxK|CJPOWERCAST|imfx v3 API took 0.006s '/api/v3/search-suggestion/?_dc=1691556145777' t Transfer: 1220 : 10|05:42:26.4816|3wu1qY|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1691556146153 t Transfer: 1220 : 10|05:42:26.4816|3wu1qY|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:26.4816|3wu1qY|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:26.4816|3wu1qY|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|05:42:26.4816|3wu1qY|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|05:42:26.4816|3wu1qY|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:26.4816|3wu1qY|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:26.4816|3wu1qY|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|05:42:26.4816|3wu1qY|CJPOWERCAST|imfx v3 API took 0.005s '/api/v3/search-suggestion/?_dc=1691556146153' t Transfer: 1220 : 10|05:42:26.4816|qQsNGR|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1691556146306 t Transfer: 1220 : 10|05:42:26.4816|qQsNGR|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:26.4816|qQsNGR|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:26.4816|qQsNGR|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|05:42:26.4816|qQsNGR|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|05:42:26.4816|qQsNGR|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:26.4816|qQsNGR|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:26.4816|qQsNGR|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|05:42:26.4816|qQsNGR|CJPOWERCAST|imfx v3 API took 0.005s '/api/v3/search-suggestion/?_dc=1691556146306' t Transfer: 1220 : 10|05:42:26.6974|glpqY~|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1691556146373 t Transfer: 1220 : 10|05:42:26.6974|glpqY~|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:26.6974|glpqY~|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:26.6974|glpqY~|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|05:42:26.6974|glpqY~|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST t Transfer: 1220 : 10|05:42:26.6974|glpqY~|CJPOWERCAST|GetCurrentUser.. t Transfer: 1220 : 10|05:42:26.6974|glpqY~|CJPOWERCAST| OAuth authenticated t Transfer: 1220 : 10|05:42:26.6974|glpqY~|CJPOWERCAST| user CJPOWERCAST. t Verbose: 1220 : 10|05:42:26.6974|glpqY~|CJPOWERCAST|imfx v3 API took 0.004s '/api/v3/search-suggestion/?_dc=1691556146373' t Information: 1220 : 10|05:47:08.5340|||OrabitWatcherBasic. Disposing. t Information: 1220 : 10|05:47:08.5340|||OrabitWatcherBasic. Disposed. t Information: 1220 : 10|05:47:08.5340|||========================================================================== t Information: 1220 : 10|05:47:08.5340|||IMFX CORE SERVER APPLICATION END.