t Transfer: 1220 :     11|08:19:33.4137|k1kQMr||OAuth: /api/logout?_dc=1692170378267
t Transfer: 1220 :     11|08:19:33.4137|k1kQMr||GetCurrentUser..
t Transfer: 1220 :     11|08:19:33.4137|k1kQMr||  OAuth authenticated
t Verbose: 1220 :      11|08:19:33.4137|k1kQMr||    uid claim is missing..
t Information: 1220 :  11|08:19:33.4137|k1kQMr||OAuth. AutoLogin no Windows identity  type WindowsIdentity
t Transfer: 1220 :     11|08:19:33.8356|q8q0Ek||GetAppInfo. DB: TMDDEMO. Install mode: . Auth types: Native, PublicApiKey
t Information: 1220 :  11|08:19:34.4417|DWljXq||GetCache.
t Information: 1220 :  11|08:19:34.4417|DWljXq||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\108_2_PnqJC_.png
t Information: 1220 :  11|08:19:34.4417|DWljXq||GetCache. Data read: 154944
t Verbose: 1220 :      11|08:19:34.4417|DWljXq||imfx v3 API took 0.096s '/api/v3/visual-asset/group/PnqJC_/2/image'
t Verbose: 1220 :      11|08:19:36.0657|52PRpV||Oauth validating..
t Verbose: 1220 :      11|08:19:36.0657|52PRpV||GrantResourceOwnerCredentials.
t Verbose: 1220 :      11|08:19:36.0657|52PRpV||LoginUser. cjpowercast, login type OAuth, encrypt password True
t Information: 1220 :  11|08:19:36.0657|52PRpV||TryLoginUser. cjpowercast, login type OAuth, check password True, check hash False, encrypt password True, load user data False
t Information: 1220 :  11|08:19:36.4734|52PRpV||  oauth token 00000000-0000-0000-0000-000000000000
t Information: 1220 :  11|08:19:36.4734|52PRpV||TryLoginUser. Logged in..
t Information: 1220 :  11|08:19:36.6765|52PRpV||GetPasswordPolicy. WARNING: Policy not found for system Imediaflex. Validation disabled.
t Verbose: 1220 :      11|08:19:36.6765|52PRpV||LoginUser. Adding history. User Id 1165, result CJPOWERCAST, host 192.168.127.6
t Verbose: 1220 :      11|08:19:36.6765|52PRpV||GrantResourceOwnerCredentials. Try login finished. Logged: True
t Transfer: 1220 :     11|08:19:37.0828|4POGUg|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=1692170382205
t Transfer: 1220 :     11|08:19:37.0828|4POGUg|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|08:19:37.0828|4POGUg|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|08:19:37.0828|4POGUg|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|08:19:37.0828|4POGUg|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|08:19:37.0828|4POGUg|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|08:19:37.0828|4POGUg|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|08:19:37.0828|4POGUg|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|08:19:37.2859|4POGUg|CJPOWERCAST|imfx v3 API took 0.049s '/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=1692170382205'
t Transfer: 1220 :     11|08:19:37.4891|xD3x3Y|CJPOWERCAST|OAuth: /api/user-preferences?keys=personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch;workflow_queues_actions;workflow_queues_settings&_dc=1692170382571
t Transfer: 1220 :     11|08:19:37.4891|xD3x3Y|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|08:19:37.4891|xD3x3Y|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|08:19:37.4891|xD3x3Y|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|08:19:37.4891|xD3x3Y|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  11|08:19:37.4891|xD3x3Y|CJPOWERCAST|GetUserDataByKeys: personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch;workflow_queues_actions;workflow_queues_settings
t Transfer: 1220 :     11|08:19:37.4891|xD3x3Y|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|08:19:37.4891|xD3x3Y|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|08:19:37.4891|xD3x3Y|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|08:19:37.4891|xD3x3Y|CJPOWERCAST|imfx v3 API took 0.052s '/api/user-preferences?keys=personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch;workflow_queues_actions;workflow_queues_settings&_dc=1692170382571'
t Information: 1220 :  11|08:19:37.8952|J_f2vE|CJPOWERCAST|GetUserProfile. Id: 0
t Transfer: 1220 :     11|08:19:37.8952|J_f2vE|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|08:19:37.8952|J_f2vE|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|08:19:37.8952|J_f2vE|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|08:19:38.3015|3UQNVu|CJPOWERCAST|OAuth: /api/settings/group/0?_dc=1692170383351
t Transfer: 1220 :     11|08:19:38.3015|3UQNVu|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|08:19:38.3015|3UQNVu|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|08:19:38.3015|3UQNVu|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|08:19:38.3015|3UQNVu|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|08:19:38.3015|hYRZc~|CJPOWERCAST|OAuth: /api/settings/user/mainMenuSettings?_dc=1692170383352
t Transfer: 1220 :     11|08:19:38.3015|hYRZc~|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|08:19:38.3015|hYRZc~|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|08:19:38.3015|hYRZc~|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|08:19:38.3015|hYRZc~|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|08:19:38.3015|qJDGMx|CJPOWERCAST|OAuth: /api/settings/user/uploadSettings?_dc=1692170383364
t Transfer: 1220 :     11|08:19:38.3015|qJDGMx|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|08:19:38.3015|qJDGMx|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|08:19:38.3015|qJDGMx|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|08:19:38.3015|qJDGMx|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|08:19:38.3015|TaeA31|CJPOWERCAST|OAuth: /api/settings/group/0?_dc=1692170383390
t Transfer: 1220 :     11|08:19:38.3015|TaeA31|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|08:19:38.3015|TaeA31|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|08:19:38.3015|TaeA31|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|08:19:38.3015|TaeA31|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|08:19:38.3015|hHSERx|CJPOWERCAST|OAuth: /api/settings/user/mainMenuSettings?_dc=1692170383392
t Transfer: 1220 :     11|08:19:38.3015|hHSERx|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|08:19:38.3015|hHSERx|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|08:19:38.3015|hHSERx|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|08:19:38.3015|hHSERx|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|08:19:38.3015|hYRZc~|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|08:19:38.3015|hYRZc~|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|08:19:38.3015|hYRZc~|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|08:19:38.3015|qJDGMx|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|08:19:38.3015|qJDGMx|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|08:19:38.3015|qJDGMx|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|08:19:38.5203|hHSERx|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|08:19:38.5203|hHSERx|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|08:19:38.5203|hHSERx|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|08:19:38.5203|qJDGMx|CJPOWERCAST|imfx v3 API took 0.163s '/api/settings/user/uploadSettings?_dc=1692170383364'
t Verbose: 1220 :      11|08:19:38.5203|hHSERx|CJPOWERCAST|imfx v3 API took 0.091s '/api/settings/user/mainMenuSettings?_dc=1692170383392'
t Verbose: 1220 :      11|08:19:38.5203|hYRZc~|CJPOWERCAST|imfx v3 API took 0.164s '/api/settings/user/mainMenuSettings?_dc=1692170383352'
t Verbose: 1220 :      11|08:19:38.7234|3UQNVu|CJPOWERCAST|imfx v3 API took 0.421s '/api/settings/group/0?_dc=1692170383351'
t Verbose: 1220 :      11|08:19:38.7234|TaeA31|CJPOWERCAST|imfx v3 API took 0.289s '/api/settings/group/0?_dc=1692170383390'
t Transfer: 1220 :     11|08:19:38.7234|4hvU_x|CJPOWERCAST|OAuth: /api/lookups/MediaStatus?_dc=1692170383406
t Transfer: 1220 :     11|08:19:38.7234|4hvU_x|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|08:19:38.7234|4hvU_x|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|08:19:38.7234|4hvU_x|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|08:19:38.7234|4hvU_x|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|08:19:38.7234|GPa46l|CJPOWERCAST|OAuth: /api/lookups/PgmStatus?_dc=1692170383407
t Transfer: 1220 :     11|08:19:38.7234|GPa46l|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|08:19:38.7234|GPa46l|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|08:19:38.7234|GPa46l|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|08:19:38.7234|GPa46l|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  11|08:19:38.7234|B37BNL||GetCache.
t Information: 1220 :  11|08:19:38.7234|B37BNL||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\201_0_Any_gO.png
t Information: 1220 :  11|08:19:38.7234|B37BNL||GetCache. Data read: 0
t Verbose: 1220 :      11|08:19:38.7234|B37BNL||imfx v3 API took 0.006s '/api/v3/visual-asset/group/Any_gO/0/image'
t Verbose: 1220 :      11|08:19:38.9265|4hvU_x|CJPOWERCAST|imfx v3 API took 0.029s '/api/lookups/MediaStatus?_dc=1692170383406'
t Verbose: 1220 :      11|08:19:38.9265|GPa46l|CJPOWERCAST|imfx v3 API took 0.027s '/api/lookups/PgmStatus?_dc=1692170383407'
t Transfer: 1220 :     11|08:19:38.9265|L3Di_L|CJPOWERCAST|OAuth: /api/lookup/CustomMediaStatusTypes?_dc=1692170383408
t Transfer: 1220 :     11|08:19:38.9265|L3Di_L|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|08:19:38.9265|L3Di_L|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|08:19:38.9265|L3Di_L|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|08:19:38.9265|L3Di_L|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Verbose: 1220 :      11|08:19:38.9265|L3Di_L|CJPOWERCAST|imfx v3 API took 0.033s '/api/lookup/CustomMediaStatusTypes?_dc=1692170383408'
t Transfer: 1220 :     11|08:19:39.1419|auQOgD|CJPOWERCAST|OAuth: /api/lookup/CustomTitleStatusTypes?_dc=1692170383410
t Transfer: 1220 :     11|08:19:39.1419|auQOgD|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|08:19:39.1419|auQOgD|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|08:19:39.1419|auQOgD|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|08:19:39.1419|auQOgD|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|08:19:39.1419|TU6UO_|CJPOWERCAST|OAuth: /api/lookup/CustomVersionStatusTypes?_dc=1692170383409
t Transfer: 1220 :     11|08:19:39.1419|TU6UO_|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|08:19:39.1419|TU6UO_|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|08:19:39.1419|TU6UO_|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|08:19:39.1419|TU6UO_|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Verbose: 1220 :      11|08:19:39.1419|TU6UO_|CJPOWERCAST|imfx v3 API took 0.020s '/api/lookup/CustomVersionStatusTypes?_dc=1692170383409'
t Verbose: 1220 :      11|08:19:39.1419|auQOgD|CJPOWERCAST|imfx v3 API took 0.028s '/api/lookup/CustomTitleStatusTypes?_dc=1692170383410'
t Transfer: 1220 :     11|08:19:39.1419|sfwsBf|CJPOWERCAST|OAuth: /api/settings/user/defaultHomePage?_dc=1692170383412
t Transfer: 1220 :     11|08:19:39.1419|sfwsBf|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|08:19:39.1419|sfwsBf|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|08:19:39.1419|sfwsBf|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|08:19:39.1419|sfwsBf|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|08:19:39.1419|sfwsBf|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|08:19:39.1419|sfwsBf|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|08:19:39.1419|sfwsBf|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|08:19:39.1419|sfwsBf|CJPOWERCAST|imfx v3 API took 0.009s '/api/settings/user/defaultHomePage?_dc=1692170383412'
t Information: 1220 :  11|08:19:39.1419|2~1hvf||GetCache.
t Information: 1220 :  11|08:19:39.1419|2~1hvf||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\202_1_Any_gO.png
t Information: 1220 :  11|08:19:39.1419|2~1hvf||GetCache. Data read: 0
t Verbose: 1220 :      11|08:19:39.1419|2~1hvf||imfx v3 API took 0.005s '/api/v3/visual-asset/group/Any_gO/1/image'
t Transfer: 1220 :     11|08:19:40.9765|RdBhtO|CJPOWERCAST|OAuth: /api/settings/user/defaultSearch?_dc=1692170385974
t Transfer: 1220 :     11|08:19:40.9765|RdBhtO|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|08:19:40.9765|RdBhtO|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|08:19:40.9765|RdBhtO|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|08:19:40.9765|RdBhtO|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|08:19:40.9765|jTUmaU|CJPOWERCAST|OAuth: /api/settings/user/startSearch?_dc=1692170385976
t Transfer: 1220 :     11|08:19:40.9765|jTUmaU|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|08:19:40.9765|jTUmaU|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|08:19:40.9765|jTUmaU|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|08:19:40.9765|jTUmaU|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|08:19:40.9765|RdBhtO|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|08:19:40.9765|RdBhtO|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|08:19:40.9765|RdBhtO|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|08:19:40.9765|jTUmaU|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|08:19:40.9765|jTUmaU|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|08:19:40.9765|jTUmaU|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|08:19:40.9765|RdBhtO|CJPOWERCAST|imfx v3 API took 0.014s '/api/settings/user/defaultSearch?_dc=1692170385974'
t Verbose: 1220 :      11|08:19:40.9765|jTUmaU|CJPOWERCAST|imfx v3 API took 0.010s '/api/settings/user/startSearch?_dc=1692170385976'
t Transfer: 1220 :     11|08:19:41.1796|wh0h05|CJPOWERCAST|OAuth: /api/user-preferences?keys=consumer.recent.data&_dc=1692170386311
t Transfer: 1220 :     11|08:19:41.1796|wh0h05|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|08:19:41.1796|wh0h05|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|08:19:41.1796|wh0h05|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|08:19:41.1796|wh0h05|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  11|08:19:41.1796|wh0h05|CJPOWERCAST|GetUserDataByKeys: consumer.recent.data
t Transfer: 1220 :     11|08:19:41.1796|wh0h05|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|08:19:41.1796|wh0h05|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|08:19:41.1796|wh0h05|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|08:19:41.1796|qm11CR|CJPOWERCAST|OAuth: /api/user-preferences?keys=adv.recent.searches.consumer&_dc=1692170386322
t Transfer: 1220 :     11|08:19:41.1796|qm11CR|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|08:19:41.1796|qm11CR|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|08:19:41.1796|qm11CR|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|08:19:41.1796|qm11CR|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Verbose: 1220 :      11|08:19:41.1796|wh0h05|CJPOWERCAST|imfx v3 API took 0.008s '/api/user-preferences?keys=consumer.recent.data&_dc=1692170386311'
t Information: 1220 :  11|08:19:41.1796|qm11CR|CJPOWERCAST|GetUserDataByKeys: adv.recent.searches.consumer
t Transfer: 1220 :     11|08:19:41.1796|qm11CR|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|08:19:41.1796|qm11CR|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|08:19:41.1796|qm11CR|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|08:19:41.1796|qm11CR|CJPOWERCAST|imfx v3 API took 0.007s '/api/user-preferences?keys=adv.recent.searches.consumer&_dc=1692170386322'
t Information: 1220 :  11|08:19:41.3996|pUsYga||GetCache.
t Information: 1220 :  11|08:19:41.3996|pUsYga||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\204_3_Any_gO.png
t Information: 1220 :  11|08:19:41.3996|pUsYga||GetCache. Data read: 5504
t Verbose: 1220 :      11|08:19:41.3996|pUsYga||imfx v3 API took 0.006s '/api/v3/visual-asset/group/Any_gO/3/image'
t Transfer: 1220 :     11|08:19:57.5272|2majkv|CJPOWERCAST|OAuth: /api/lookups/SearchSupportedOperators?_dc=1692170402672
t Transfer: 1220 :     11|08:19:57.5272|2majkv|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|08:19:57.5272|2majkv|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|08:19:57.5272|2majkv|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|08:19:57.5272|2majkv|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|08:19:57.5272|Kt~ly3|CJPOWERCAST|OAuth: /api/user-preferences?keys=adv.recent.searches.versions&_dc=1692170402674
t Transfer: 1220 :     11|08:19:57.5272|Kt~ly3|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|08:19:57.5272|Kt~ly3|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|08:19:57.5272|Kt~ly3|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|08:19:57.5272|Kt~ly3|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|08:19:57.5272|654TwV|CJPOWERCAST|OAuth: /api/view/searchinfo/Version?_dc=1692170402671
t Transfer: 1220 :     11|08:19:57.5272|654TwV|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|08:19:57.5272|654TwV|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|08:19:57.5272|654TwV|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|08:19:57.5272|654TwV|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  11|08:19:57.5272|Kt~ly3|CJPOWERCAST|GetUserDataByKeys: adv.recent.searches.versions
t Transfer: 1220 :     11|08:19:57.5272|Kt~ly3|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|08:19:57.5272|Kt~ly3|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|08:19:57.5272|Kt~ly3|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|08:19:57.5272|2majkv|CJPOWERCAST|imfx v3 API took 0.000s '/api/lookups/SearchSupportedOperators?_dc=1692170402672'
t Information: 1220 :  11|08:19:57.5272|654TwV|CJPOWERCAST|GetAdvSearchColumns. search type Version grid .
t Verbose: 1220 :      11|08:19:57.5272|654TwV|CJPOWERCAST|imfx v3 API took 0.001s '/api/view/searchinfo/Version?_dc=1692170402671'
t Verbose: 1220 :      11|08:19:57.5272|Kt~ly3|CJPOWERCAST|imfx v3 API took 0.006s '/api/user-preferences?keys=adv.recent.searches.versions&_dc=1692170402674'
t Transfer: 1220 :     11|08:19:57.7303|eLzws8|CJPOWERCAST|OAuth: /api/view/searches/Version?_dc=1692170402733
t Transfer: 1220 :     11|08:19:57.7303|eLzws8|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|08:19:57.7303|eLzws8|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|08:19:57.7303|eLzws8|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|08:19:57.7303|eLzws8|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|08:19:57.7303|dQRktQ|CJPOWERCAST|OAuth: /api/view/info/VersionGrid?lang=en-GB&_dc=1692170402740
t Transfer: 1220 :     11|08:19:57.7303|dQRktQ|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|08:19:57.7303|dQRktQ|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|08:19:57.7303|dQRktQ|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|08:19:57.7303|dQRktQ|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  11|08:19:57.7303|eLzws8|CJPOWERCAST|GetSavedSearchNames. search type Version.
t Transfer: 1220 :     11|08:19:57.7303|eLzws8|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|08:19:57.7303|eLzws8|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|08:19:57.7303|eLzws8|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|08:19:57.7303|WBntTi|CJPOWERCAST|OAuth: /api/settings/user/searchLayoutConfig?_dc=1692170402742
t Transfer: 1220 :     11|08:19:57.7303|WBntTi|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|08:19:57.7303|WBntTi|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|08:19:57.7303|WBntTi|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|08:19:57.7303|WBntTi|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|08:19:57.7303|WBntTi|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|08:19:57.7303|WBntTi|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|08:19:57.7303|WBntTi|CJPOWERCAST|    user CJPOWERCAST.
t Information: 1220 :  11|08:19:57.7303|dQRktQ|CJPOWERCAST|GetGridViewBuilder. builder type VersionGrid.
t Transfer: 1220 :     11|08:19:57.7303|dQRktQ|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|08:19:57.7303|dQRktQ|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|08:19:57.7303|dQRktQ|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|08:19:57.7303|WBntTi|CJPOWERCAST|imfx v3 API took 0.007s '/api/settings/user/searchLayoutConfig?_dc=1692170402742'
t Verbose: 1220 :      11|08:19:57.7303|eLzws8|CJPOWERCAST|imfx v3 API took 0.046s '/api/view/searches/Version?_dc=1692170402733'
t Information: 1220 :  11|08:19:57.7303|dQRktQ|CJPOWERCAST|UserGridView. LoadView. ID -2, Name Default.
t Transfer: 1220 :     11|08:19:57.7303|dQRktQ|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|08:19:57.7303|dQRktQ|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|08:19:57.7303|dQRktQ|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|08:19:57.7303|dQRktQ|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|08:19:57.7303|dQRktQ|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|08:19:57.7303|dQRktQ|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|08:19:57.7303|dQRktQ|CJPOWERCAST|imfx v3 API took 0.157s '/api/view/info/VersionGrid?lang=en-GB&_dc=1692170402740'
t Transfer: 1220 :     11|08:20:05.5075|VAkyeF|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1692170410554
t Transfer: 1220 :     11|08:20:05.5075|VAkyeF|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|08:20:05.5075|VAkyeF|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|08:20:05.5075|VAkyeF|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|08:20:05.5075|VAkyeF|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|08:20:05.5075|VAkyeF|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|08:20:05.5075|VAkyeF|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|08:20:05.5075|VAkyeF|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|08:20:05.5075|W716v6|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1692170410655
t Transfer: 1220 :     11|08:20:05.5075|NMYOuL|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1692170410654
t Transfer: 1220 :     11|08:20:05.5075|NMYOuL|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|08:20:05.5075|NMYOuL|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|08:20:05.5075|NMYOuL|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|08:20:05.5075|NMYOuL|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|08:20:05.5075|W716v6|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|08:20:05.5075|W716v6|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|08:20:05.5075|W716v6|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|08:20:05.5075|W716v6|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|08:20:05.5075|NMYOuL|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|08:20:05.5075|NMYOuL|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|08:20:05.5075|NMYOuL|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|08:20:05.5075|W716v6|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|08:20:05.5075|W716v6|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|08:20:05.5075|W716v6|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|08:20:06.7431|NMYOuL|CJPOWERCAST|imfx v3 API took 1.164s '/api/v3/search-suggestion/?_dc=1692170410654'
t Verbose: 1220 :      11|08:20:06.7431|W716v6|CJPOWERCAST|imfx v3 API took 1.164s '/api/v3/search-suggestion/?_dc=1692170410655'
t Verbose: 1220 :      11|08:20:06.7431|VAkyeF|CJPOWERCAST|imfx v3 API took 1.194s '/api/v3/search-suggestion/?_dc=1692170410554'
t Transfer: 1220 :     11|08:20:07.1494|cP1r7Y|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1692170412287
t Transfer: 1220 :     11|08:20:07.1494|cP1r7Y|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|08:20:07.1494|cP1r7Y|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|08:20:07.1494|cP1r7Y|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|08:20:07.1494|cP1r7Y|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|08:20:07.1494|cP1r7Y|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|08:20:07.1494|cP1r7Y|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|08:20:07.1494|cP1r7Y|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|08:20:07.3525|cP1r7Y|CJPOWERCAST|imfx v3 API took 0.048s '/api/v3/search-suggestion/?_dc=1692170412287'
t Transfer: 1220 :     11|08:20:07.3525|8DdNzm|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1692170412411
t Transfer: 1220 :     11|08:20:07.3525|8DdNzm|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|08:20:07.3525|8DdNzm|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|08:20:07.3525|8DdNzm|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|08:20:07.3525|8DdNzm|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|08:20:07.3525|8DdNzm|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|08:20:07.3525|8DdNzm|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|08:20:07.3525|8DdNzm|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|08:20:07.3525|8DdNzm|CJPOWERCAST|imfx v3 API took 0.015s '/api/v3/search-suggestion/?_dc=1692170412411'
t Transfer: 1220 :     11|08:20:07.3525|kghjQk|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1692170412510
t Transfer: 1220 :     11|08:20:07.3525|kghjQk|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|08:20:07.3525|kghjQk|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|08:20:07.3525|kghjQk|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|08:20:07.3525|kghjQk|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|08:20:07.3525|kghjQk|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|08:20:07.3525|kghjQk|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|08:20:07.3525|kghjQk|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|08:20:07.3525|kghjQk|CJPOWERCAST|imfx v3 API took 0.006s '/api/v3/search-suggestion/?_dc=1692170412510'
t Transfer: 1220 :     11|08:20:10.2132|7YVKNX|CJPOWERCAST|OAuth: /api/v3/search/versions?_dc=1692170415236
t Transfer: 1220 :     11|08:20:10.2132|7YVKNX|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|08:20:10.2132|7YVKNX|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|08:20:10.2132|7YVKNX|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|08:20:10.2132|7YVKNX|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  11|08:20:10.2132|7YVKNX|CJPOWERCAST|V3Api.SearchVersions
t Information: 1220 :  11|08:20:10.2132|7YVKNX|CJPOWERCAST|V3Api.SearchGeneric
t Transfer: 1220 :     11|08:20:10.2132|7YVKNX|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|08:20:10.2132|7YVKNX|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|08:20:10.2132|7YVKNX|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|08:20:10.2132|7YVKNX|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|08:20:10.2132|7YVKNX|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|08:20:10.2132|7YVKNX|CJPOWERCAST|    user CJPOWERCAST.
t Information: 1220 :  11|08:20:10.4224|7YVKNX|CJPOWERCAST|Running solr search: [q, (((series_id:299390)) AND deleted_flag:(0) AND (owners:((SFP2) OR (PSP) OR (PMS) OR (SFP1) OR (PMH) OR (PPL))))]
t Information: 1220 :  11|08:20:10.4224|7YVKNX|CJPOWERCAST|Solr query returned:  7 in 3ms
t Information: 1220 :  11|08:20:10.4224|7YVKNX|CJPOWERCAST|SearchVersion SQL:
 select * from (select a.*, rownum rnum  from ( select  m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE,  nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE , (select min(name)
    from TM_CFG_AUDIO_CONTENT_MS_TYPES audio
    where m.audio_type = audio.id   
    ) SOUND  ,(select min(from_date_time)
  from TM_PG_RL_PROD_DATE prodDate
 where prodDate.Tm_Pg_Rl_Id = m.id 
   ) PROD_FROM_DATE  ,(select min(to_date_time)
  from TM_PG_RL_PROD_DATE prodDate
 where prodDate.Tm_Pg_Rl_Id = m.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 = m.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 = m.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 = m.id ) PROD_DATE_TYPE  ,(select min(status.description)
  from TM_CFG_PGM_STATUS status
 where m.ITEM_STATUS_ID = status.id) PGM_STATUS_TEXT ,(select submed.sub_medium_name
  from TM_CFG_SUB_MEDIUM submed
 where m.SUB_MEDIUM_ID = submed.id) SUB_MEDIUM_TEXT ,(select med.medium_name
  from TM_CFG_MEDIUM med, TM_PG_ABS pgabs
 where pgabs.id=m.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 = m.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 = m.PGM_ABS_ID) GENRE_TEXT, (select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = m.net_grp_id) CHANNEL_GROUP, (select count(id) from tm_mis where item_type>0 and pgm_parent_id=m.id) MEDIA_COUNT, (select cvt.ID 
    from TM_PORTAL_VERSION_CONFIG cvt
    where m.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) m 
        left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id2,(select /*+ cardinality(4) */ rownum rn, column_value id from table(:ids)) ids 
 where item_type>0 and rl_deleted=0  and  m.id = ids.id 
 order by ids.rn ) a where rownum <= 10000) r where rnum >=1 order by rnum
t Information: 1220 :  11|08:20:11.8456|7YVKNX|CJPOWERCAST|Running version search. User: 1165    Simple Search: 
Trying to use Solr Search...
Solr completed in: 128ms.  Returned lines: 7
Running Oracle search.
Oracle version search timing: 1526ms.
SQL run:
 select * from (select a.*, rownum rnum  from ( select  m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE,  nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE , (select min(name)
    from TM_CFG_AUDIO_CONTENT_MS_TYPES audio
    where m.audio_type = audio.id   
    ) SOUND  ,(select min(from_date_time)
  from TM_PG_RL_PROD_DATE prodDate
 where prodDate.Tm_Pg_Rl_Id = m.id 
   ) PROD_FROM_DATE  ,(select min(to_date_time)
  from TM_PG_RL_PROD_DATE prodDate
 where prodDate.Tm_Pg_Rl_Id = m.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 = m.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 = m.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 = m.id ) PROD_DATE_TYPE  ,(select min(status.description)
  from TM_CFG_PGM_STATUS status
 where m.ITEM_STATUS_ID = status.id) PGM_STATUS_TEXT ,(select submed.sub_medium_name
  from TM_CFG_SUB_MEDIUM submed
 where m.SUB_MEDIUM_ID = submed.id) SUB_MEDIUM_TEXT ,(select med.medium_name
  from TM_CFG_MEDIUM med, TM_PG_ABS pgabs
 where pgabs.id=m.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 = m.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 = m.PGM_ABS_ID) GENRE_TEXT, (select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = m.net_grp_id) CHANNEL_GROUP, (select count(id) from tm_mis where item_type>0 and pgm_parent_id=m.id) MEDIA_COUNT, (select cvt.ID 
    from TM_PORTAL_VERSION_CONFIG cvt
    where m.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) m 
        left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id2,(select /*+ cardinality(4) */ rownum rn, column_value id from table(:ids)) ids 
 where item_type>0 and rl_deleted=0  and  m.id = ids.id 
 order by ids.rn ) a where rownum <= 10000) r where rnum >=1 order by rnum

t Verbose: 1220 :      11|08:20:11.8456|7YVKNX|CJPOWERCAST|Alternative title fields query: select * from (select x.id,x.pgm_abs_id TitleId, x.id VersionId from TM_PG_RL x where id in (select /*+ cardinality(4) */ column_value id from table(:ids))) y,lateral (select dbms_lob.substr( o.text_data_plain, 1000, 1 ) Field_5799344 from tm_txt_obj o 
                    where (o.pgm_abs_id=y.TitleId or o.pgm_rl_id = y.VersionId) and o.type_id=:param_1 
                    order by o.id desc fetch first 1 rows only)(+)
t Verbose: 1220 :      11|08:20:12.0487|7YVKNX|CJPOWERCAST|imfx v3 API took 1.764s '/api/v3/search/versions?_dc=1692170415236'
t Transfer: 1220 :     11|08:20:12.6581|t7ITH3|CJPOWERCAST|OAuth: /api/user-preferences?_dc=1692170417646
t Transfer: 1220 :     11|08:20:12.6581|t7ITH3|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|08:20:12.6581|t7ITH3|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|08:20:12.6581|t7ITH3|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|08:20:12.6581|t7ITH3|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Verbose: 1220 :      11|08:20:12.6581|t7ITH3|CJPOWERCAST|StoreUserDataByKeys..
t Transfer: 1220 :     11|08:20:12.6581|t7ITH3|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|08:20:12.6581|t7ITH3|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|08:20:12.6581|t7ITH3|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|08:20:12.6581|t7ITH3|CJPOWERCAST|imfx v3 API took 0.021s '/api/user-preferences?_dc=1692170417646'
t Information: 1220 :  11|11:47:43.5478|||OrabitWatcherBasic. Disposing.
t Information: 1220 :  11|11:47:43.5478|||OrabitWatcherBasic. Disposed.
t Information: 1220 :  11|11:47:43.5478|||==========================================================================
t Information: 1220 :  11|11:47:43.5478|||IMFX CORE SERVER APPLICATION END.