=== INFO RequestContext - URL: '/lms/lms/sc/IDACall', User-Agent: 'Mozilla/5.0 (Windows NT 6.2; WOW64; rv:26.0) Gecko/20100101 Firefox/26.0': Moz (Gecko) with Accept-Encoding header === DEBUG XML - Parsed XML from (in memory stream): 4ms === DEBUG RPCManager - Processing 1 requests. === DEBUG DSRequest - Caching instance 116 of DS T_LEAD from DSRequest.getDataSource() === DEBUG RPCManager - Request #1 (DSRequest) payload: { criteria:{ ID:6 }, values:{ MODIFIED_AT:new Date(1392309596000), CREATED_BY:"1012", POTREV_RESELLER:2123, CREATED_AT:new Date(1392123469000), CAMPAIGN_ID:12, CAMPAIGN_TENANT_ID:0, LEADTEMPERATURE_TENANT_ID:0, CAMPAIGN_NAME:"Cebit Stand (R1)", LEADTEMPERATURE_ID:1, ID:6, LEADTEMPERATURE_NAME:"Hot Lead", MODIFIED_BY:"1012", TENANT_ID:0 }, operationConfig:{ dataSource:"T_LEAD", operationType:"update", textMatchStyle:"exact" }, componentId:"isc_AddEditLeadMasterdata_1_1", appID:"builtinApplication", operation:"T_LEAD_update", oldValues:{ MODIFIED_AT:new Date(1392309596000), CREATED_BY:"1012", POTREV_RESELLER:1123, CREATED_AT:new Date(1392123469000), CAMPAIGN_ID:12, CAMPAIGN_TENANT_ID:0, LEADTEMPERATURE_TENANT_ID:0, CAMPAIGN_NAME:"Cebit Stand (R1)", LEADTEMPERATURE_ID:1, ID:6, LEADTEMPERATURE_NAME:"Hot Lead", MODIFIED_BY:"1012", TENANT_ID:0 } } === DEBUG Relation - Caching instance of toDS 'T_CAMPAIGN' in the DSRequest map === DEBUG Relation - Caching instance of toDS 'T_LEADTEMPERATURE' in the DSRequest map === DEBUG DeclarativeSecurity - Processing security checks for DataSource null, field null === DEBUG DeclarativeSecurity - DataSource T_LEAD is not in the pre-checked list, processing... === DEBUG DSRequest - Caching instance 288 of DS V_LEAD_CURRENT_STATUS from DSRequest.getDataSource() === DEBUG DeclarativeSecurity - Processing security checks for DataSource null, field null === DEBUG AppBase - [builtinApplication.null] No userTypes defined, allowing anyone access to all operations for this application === DEBUG AppBase - [builtinApplication.null] No public zero-argument method named '_null' found, performing generic datasource operation === INFO SQLDataSource - [builtinApplication.null] Performing fetch operation with criteria: {criteria:[{value:6,fieldName:"LEAD_ID",operator:"equals"},{value:0,fieldName:"TENANT_ID",operator:"equals"}],operator:"and",_constructor:"AdvancedCriteria"} values: {criteria:[{value:6,fieldName:"LEAD_ID",operator:"equals"},{value:0,fieldName:"TENANT_ID",operator:"equals"}],operator:"and",_constructor:"AdvancedCriteria"} === INFO SQLDataSource - [builtinApplication.null] derived query: SELECT $defaultSelectClause FROM $defaultTableClause WHERE $defaultWhereClause === INFO SQLDataSource - [builtinApplication.null] 288: Executing SQL query on 'Oracle': SELECT V_LEAD_CURRENT_STATUS.CREATED_BY, V_LEAD_CURRENT_STATUS.CREATED_BY_COMPANY_ID, V_LEAD_CURRENT_STATUS.CREATED_BY_DISTRIBUTOR_ID, V_LEAD_CURRENT_STATUS.CREATED_BY_RESELLER_ID, V_LEAD_CURRENT_STATUS.LEAD_ID, V_LEAD_CURRENT_STATUS.STATUS_ID, V_LEAD_CURRENT_STATUS.STATUS_POTREV_COMPANY, V_LEAD_CURRENT_STATUS.STATUS_POTREV_PROJECT, V_LEAD_CURRENT_STATUS.STATUS_RESELLER_ID, V_LEAD_CURRENT_STATUS.STATUS_SHORTNAME, V_LEAD_CURRENT_STATUS.STATUS_STATUSCOMMENT, V_LEAD_CURRENT_STATUS.STATUS_STATUSDATE, V_LEAD_CURRENT_STATUS.STATUS_USER_ID, V_LEAD_CURRENT_STATUS.STATUS_WONLOST_ID, V_LEAD_CURRENT_STATUS.TENANT_ID FROM V_LEAD_CURRENT_STATUS WHERE ((V_LEAD_CURRENT_STATUS.LEAD_ID = 6 AND V_LEAD_CURRENT_STATUS.LEAD_ID IS NOT NULL) AND (V_LEAD_CURRENT_STATUS.TENANT_ID = 0 AND V_LEAD_CURRENT_STATUS.TENANT_ID IS NOT NULL)) === DEBUG PoolableSQLConnectionFactory - [builtinApplication.null] Executing pingTest 'select 1 from dual' on connection 88920788 === DEBUG SQLConnectionManager - [builtinApplication.null] Borrowed connection '88920788' === DEBUG SQLTransaction - [builtinApplication.null] Started new Oracle transaction "88920788" === DEBUG SQLDriver - [builtinApplication.null] About to execute SQL query in 'Oracle' using connection '88920788' === INFO SQLDriver - [builtinApplication.null] Executing SQL query on 'Oracle': SELECT V_LEAD_CURRENT_STATUS.CREATED_BY, V_LEAD_CURRENT_STATUS.CREATED_BY_COMPANY_ID, V_LEAD_CURRENT_STATUS.CREATED_BY_DISTRIBUTOR_ID, V_LEAD_CURRENT_STATUS.CREATED_BY_RESELLER_ID, V_LEAD_CURRENT_STATUS.LEAD_ID, V_LEAD_CURRENT_STATUS.STATUS_ID, V_LEAD_CURRENT_STATUS.STATUS_POTREV_COMPANY, V_LEAD_CURRENT_STATUS.STATUS_POTREV_PROJECT, V_LEAD_CURRENT_STATUS.STATUS_RESELLER_ID, V_LEAD_CURRENT_STATUS.STATUS_SHORTNAME, V_LEAD_CURRENT_STATUS.STATUS_STATUSCOMMENT, V_LEAD_CURRENT_STATUS.STATUS_STATUSDATE, V_LEAD_CURRENT_STATUS.STATUS_USER_ID, V_LEAD_CURRENT_STATUS.STATUS_WONLOST_ID, V_LEAD_CURRENT_STATUS.TENANT_ID FROM V_LEAD_CURRENT_STATUS WHERE ((V_LEAD_CURRENT_STATUS.LEAD_ID = 6 AND V_LEAD_CURRENT_STATUS.LEAD_ID IS NOT NULL) AND (V_LEAD_CURRENT_STATUS.TENANT_ID = 0 AND V_LEAD_CURRENT_STATUS.TENANT_ID IS NOT NULL)) === INFO DSResponse - [builtinApplication.null] DSResponse: List with 1 items === DEBUG DeclarativeSecurity - Processing security checks for DataSource null, field null === DEBUG DeclarativeSecurity - DataSource T_LEAD is not in the pre-checked list, processing... === DEBUG AppBase - [builtinApplication.T_LEAD_update] No userTypes defined, allowing anyone access to all operations for this application === DEBUG AppBase - [builtinApplication.T_LEAD_update] No public zero-argument method named '_T_LEAD_update' found, performing generic datasource operation === INFO SQLDataSource - [builtinApplication.T_LEAD_update] Performing update operation with criteria: {ID:6,TENANT_ID:0} values: {MODIFIED_AT:new Date(1392309735385),POTREV_RESELLER:2123,CAMPAIGN_ID:12,CAMPAIGN_TENANT_ID:0,LEADTEMPERATURE_TENANT_ID:0,CAMPAIGN_NAME:"Cebit Stand (R1)",LEADTEMPERATURE_ID:1,ID:6,LEADTEMPERATURE_NAME:"Hot Lead",MODIFIED_BY:"1012",TENANT_ID:0} === INFO SQLValuesClause - [builtinApplication.T_LEAD_update] Ignored data for non-existent or included columns: [CAMPAIGN_TENANT_ID, LEADTEMPERATURE_TENANT_ID, CAMPAIGN_NAME, LEADTEMPERATURE_NAME] === DEBUG SQLDriver - [builtinApplication.T_LEAD_update] About to execute SQL update in 'Oracle' using connection'88920788' === INFO SQLDriver - [builtinApplication.T_LEAD_update] Executing SQL update on 'Oracle': UPDATE T_LEAD SET CAMPAIGN_ID=12, LEADTEMPERATURE_ID=1, MODIFIED_AT=TO_DATE('D HH24:MI:SS'), MODIFIED_BY='1012', POTREV_RESELLER=2123, TENANT_ID=0 WHERE (T_LEAD.ID=6 AND T_LEAD.TENANT_ID=0) === DEBUG SQLDataSource - [builtinApplication.T_LEAD_update] update operation affected 1 rows === INFO SQLDataSource - [builtinApplication.T_LEAD_update] primaryKeys: {ID=6} === DEBUG DeclarativeSecurity - [builtinApplication.T_LEAD_update] Processing security checks for DataSource null, field null === DEBUG DeclarativeSecurity - [builtinApplication.T_LEAD_update] DataSource T_LEAD is not in the pre-checked list, processing... === DEBUG DeclarativeSecurity - [builtinApplication.T_LEAD_update] Processing security checks for DataSource T_CAMPAIGN, field ID === DEBUG DeclarativeSecurity - [builtinApplication.T_LEAD_update] DataSource T_CAMPAIGN is not in the pre-checked list, processing... === DEBUG DeclarativeSecurity - [builtinApplication.T_LEAD_update] Processing security checks for DataSource T_CAMPAIGN, field NAME === DEBUG DeclarativeSecurity - [builtinApplication.T_LEAD_update] DataSource T_CAMPAIGN is not in the pre-checked list, processing... === DEBUG DeclarativeSecurity - [builtinApplication.T_LEAD_update] Processing security checks for DataSource T_LEADTEMPERATURE, field ID === DEBUG DeclarativeSecurity - [builtinApplication.T_LEAD_update] DataSource T_LEADTEMPERATURE is not in the pre-checked list, processing... === DEBUG DeclarativeSecurity - [builtinApplication.T_LEAD_update] Processing security checks for DataSource T_LEADTEMPERATURE, field NAME === DEBUG DeclarativeSecurity - [builtinApplication.T_LEAD_update] DataSource T_LEADTEMPERATURE is not in the pre-checked list, processing... === DEBUG DeclarativeSecurity - [builtinApplication.T_LEAD_update] Processing security checks for DataSource T_LEADTEMPERATURE, field ID === DEBUG DeclarativeSecurity - [builtinApplication.T_LEAD_update] Processing security checks for DataSource T_LEADTEMPERATURE, field TENANT_ID === DEBUG DeclarativeSecurity - [builtinApplication.T_LEAD_update] Processing security checks for DataSource T_CAMPAIGN, field ID === DEBUG DeclarativeSecurity - [builtinApplication.T_LEAD_update] Processing security checks for DataSource T_CAMPAIGN, field TENANT_ID === DEBUG ServerObject - [builtinApplication.T_LEAD_update] Couldn't find a public method named: fetch on class: com.lmscompany.lms.server.worker.T_LEAD === DEBUG DataSourceDMI - [builtinApplication.T_LEAD_update] DataSourceDMI: no public method name: fetch available on class: com.lmscompany.lms.server.worker.T_LEAD - defaulting to builtin operations. === DEBUG AppBase - [builtinApplication.T_LEAD_update, builtinApplication.null] No userTypes defined, allowing anyone access to all operations for this application === DEBUG AppBase - [builtinApplication.T_LEAD_update, builtinApplication.null] No public zero-argument method named '_null' found, performing generic datasource operation === INFO SQLDataSource - [builtinApplication.T_LEAD_update, builtinApplication.null] Performing fetch operation with criteria: {criteria:[{value:6,fieldName:"ID",operator:"equals"},{value:0,fieldName:"TENANT_ID",operator:"equals"},{value:0,fieldName:"LEADTEMPERATURE_TENANT_ID",operator:"equals"},{value:0,fieldName:"CAMPAIGN_TENANT_ID",operator:"equals"}],operator:"and",_constructor:"AdvancedCriteria"} values: {criteria:[{value:6,fieldName:"ID",operator:"equals"},{value:0,fieldName:"TENANT_ID",operator:"equals"},{value:0,fieldName:"LEADTEMPERATURE_TENANT_ID",operator:"equals"},{value:0,fieldName:"CAMPAIGN_TENANT_ID",operator:"equals"}],operator:"and",_constructor:"AdvancedCriteria"} === INFO SQLDataSource - [builtinApplication.T_LEAD_update, builtinApplication.null] derived query: SELECT $defaultSelectClause FROM $defaultTableClause$defaultAnsiJoinClause WHERE $defaultWhereClause === INFO SQLDataSource - [builtinApplication.T_LEAD_update, builtinApplication.null] 116: Executing SQL query on 'Oracle': SELECT T_LEAD.CAMPAIGN_ID, T_LEAD.CREATED_AT, T_LEAD.CREATED_BY, T_LEAD.EARLIEST_START, T_LEAD.ID, T_LEAD.LATEST_END, T_LEAD.LEADTEMPERATURE_ID, T_LEAD.MODIFIED_AT, T_LEAD.MODIFIED_BY, T_LEAD.POTREV_RESELLER, T_LEAD.TENANT_ID, T_CAMPAIGN.NAME AS CAMPAIGN_NAME, T_LEADTEMPERATURE.NAME AS LEADTEMPERATURE_NAME, T_LEADTEMPERATURE.TENANT_ID AS LEADTEMPERATURE_TENANT_ID, T_CAMPAIGN.TENANT_ID AS CAMPAIGN_TENANT_ID FROM T_LEAD JOIN T_CAMPAIGN ON T_LEAD.CAMPAIGN_ID = T_CAMPAIGN.ID JOIN T_LEADTEMPERATURE ON T_LEAD.LEADTEMPERATURE_ID = T_LEADTEMPERATURE.ID WHERE ((T_LEAD.ID = 6 AND T_LEAD.ID IS NOT NULL) AND (T_LEAD.TENANT_ID = 0 AND T_LEAD.TENANT_ID IS NOT NULL) AND (T_LEADTEMPERATURE.TENANT_ID = 0 AND T_LEADTEMPERATURE.TENANT_ID IS NOT NULL) AND (T_CAMPAIGN.TENANT_ID = 0 AND T_CAMPAIGN.TENANT_ID IS NOT NULL)) === DEBUG SQLDriver - [builtinApplication.T_LEAD_update, builtinApplication.null] About to execute SQL query in 'Oracle' using connection '88920788' === INFO SQLDriver - [builtinApplication.T_LEAD_update, builtinApplication.null] Executing SQL query on 'Oracle': SELECT T_LEAD.CAMPAIGN_ID, T_LEAD.CREATED_AT, T_LEAD.CREATED_BY, T_LEAD.EARLIEST_START, T_LEAD.ID, T_LEAD.LATEST_END, T_LEAD.LEADTEMPERATURE_ID, T_LEAD.MODIFIED_AT, T_LEAD.MODIFIED_BY, T_LEAD.POTREV_RESELLER, T_LEAD.TENANT_ID, T_CAMPAIGN.NAME AS CAMPAIGN_NAME, T_LEADTEMPERATURE.NAME AS LEADTEMPERATURE_NAME, T_LEADTEMPERATURE.TENANT_ID AS LEADTEMPERATURE_TENANT_ID, T_CAMPAIGN.TENANT_ID AS CAMPAIGN_TENANT_ID FROM T_LEAD JOIN T_CAMPAIGN ON T_LEAD.CAMPAIGN_ID = T_CAMPAIGN.ID JOIN T_LEADTEMPERATURE ON T_LEAD.LEADTEMPERATURE_ID = T_LEADTEMPERATURE.ID WHERE ((T_LEAD.ID = 6 AND T_LEAD.ID IS NOT NULL) AND (T_LEAD.TENANT_ID = 0 AND T_LEAD.TENANT_ID IS NOT NULL) AND (T_LEADTEMPERATURE.TENANT_ID = 0 AND T_LEADTEMPERATURE.TENANT_ID IS NOT NULL) AND (T_CAMPAIGN.TENANT_ID = 0 AND T_CAMPAIGN.TENANT_ID IS NOT NULL)) === INFO DSResponse - [builtinApplication.T_LEAD_update, builtinApplication.null] DSResponse: List with 1 items === INFO DSResponse - [builtinApplication.T_LEAD_update] DSResponse: List with 1 items === DEBUG DSRequest - Caching instance 378 of DS V_LEAD_INCREATION from DSRequest.getDataSource() === DEBUG Relation - Caching instance of toDS 'V_USER_CREATED_BY' in the DSRequest map === DEBUG Relation - Caching instance of toDS 'V_USER_MODIFIED_BY' in the DSRequest map === DEBUG DeclarativeSecurity - Processing security checks for DataSource null, field null === DEBUG DeclarativeSecurity - Processing security checks for DataSource null, field null === DEBUG AppBase - [builtinApplication.null] No userTypes defined, allowing anyone access to all operations for this application === DEBUG AppBase - [builtinApplication.null] No public zero-argument method named '_null' found, performing generic datasource operation === INFO SQLDataSource - [builtinApplication.null] Performing fetch operation with criteria: {criteria:[{value:6,fieldName:"LEAD_ID",operator:"equals"},{value:1012,fieldName:"CREATED_BY",operator:"equals"},{value:0,fieldName:"TENANT_ID",operator:"equals"},{value:0,fieldName:"CREATED_BY_TENANT_ID",operator:"equals"},{value:0,fieldName:"MODIFIED_BY_TENANT_ID",operator:"equals"},{value:0,fieldName:"LEADTEMPERATURE_TENANT_ID",operator:"equals"},{value:0,fieldName:"CAMPAIGN_TENANT_ID",operator:"equals"}],operator:"and",_constructor:"AdvancedCriteria"} values: {criteria:[{value:6,fieldName:"LEAD_ID",operator:"equals"},{value:1012,fieldName:"CREATED_BY",operator:"equals"},{value:0,fieldName:"TENANT_ID",operator:"equals"},{value:0,fieldName:"CREATED_BY_TENANT_ID",operator:"equals"},{value:0,fieldName:"MODIFIED_BY_TENANT_ID",operator:"equals"},{value:0,fieldName:"LEADTEMPERATURE_TENANT_ID",operator:"equals"},{value:0,fieldName:"CAMPAIGN_TENANT_ID",operator:"equals"}],operator:"and",_constructor:"AdvancedCriteria"} === INFO SQLDataSource - [builtinApplication.null] derived query: SELECT $defaultSelectClause FROM $defaultTableClause$defaultAnsiJoinClause WHERE $defaultWhereClause === INFO SQLDataSource - [builtinApplication.null] 378: Executing SQL query on 'Oracle': SELECT V_LEAD_INCREATION.ADDRESS_ID, V_LEAD_INCREATION.CAMPAIGN_ID, V_LEAD_INCREATION.CREATED_AT, V_LEAD_INCREATION.CREATED_BY, V_LEAD_INCREATION.CREATED_BY_COMPANY_ID, V_LEAD_INCREATION.CREATED_BY_DISTRIBUTOR_ID, V_LEAD_INCREATION.CREATED_BY_RESELLER_ID, V_LEAD_INCREATION.CUST_NAME_CONTACTPERSFULLNAME, V_LEAD_INCREATION.EARLIEST_START, V_LEAD_INCREATION.LATEST_END, V_LEAD_INCREATION.LEADTEMPERATURE_ID, V_LEAD_INCREATION.LEAD_CURRENT_ID, V_LEAD_INCREATION.LEAD_ID, V_LEAD_INCREATION.MODIFIED_AT, V_LEAD_INCREATION.MODIFIED_BY, V_LEAD_INCREATION.POTREV_RESELLER, V_LEAD_INCREATION.STATUS, V_LEAD_INCREATION.TENANT_ID, V_USER_CREATED_BY.FULLNAME_INITIALS_GIVENNAME AS CREATED_BY_NAME, V_USER_CREATED_BY.FULLNAME_COMPANYNAME AS CREATED_BY_NAME_TOOLTIP, V_USER_MODIFIED_BY.FULLNAME_INITIALS_GIVENNAME AS MODIFIED_BY_NAME, V_USER_MODIFIED_BY.FULLNAME_COMPANYNAME AS MODIFIED_BY_NAME_TOOLTIP, T_LEADTEMPERATURE.NAME AS LEADTEMPERATURE_NAME, T_LEADTEMPERATURE.POSITION AS LEADTEMPERATURE_POSITION, T_CAMPAIGN.NAME AS CAMPAIGN_NAME, V_USER_CREATED_BY.TENANT_ID AS CREATED_BY_TENANT_ID, V_USER_MODIFIED_BY.TENANT_ID AS MODIFIED_BY_TENANT_ID, T_LEADTEMPERATURE.TENANT_ID AS LEADTEMPERATURE_TENANT_ID, T_CAMPAIGN.TENANT_ID AS CAMPAIGN_TENANT_ID FROM V_LEAD_INCREATION JOIN V_USER_CREATED_BY ON V_LEAD_INCREATION.CREATED_BY = V_USER_CREATED_BY.ID JOIN V_USER_MODIFIED_BY ON V_LEAD_INCREATION.MODIFIED_BY = V_USER_MODIFIED_BY.ID JOIN T_LEADTEMPERATURE ON V_LEAD_INCREATION.LEADTEMPERATURE_ID = T_LEADTEMPERATURE.ID JOIN T_CAMPAIGN ON V_LEAD_INCREATION.CAMPAIGN_ID = T_CAMPAIGN.ID WHERE ((V_LEAD_INCREATION.LEAD_ID = 6 AND V_LEAD_INCREATION.LEAD_ID IS NOT NULL) AND (V_LEAD_INCREATION.CREATED_BY = 1012 AND V_LEAD_INCREATION.CREATED_BY IS NOT NULL) AND (V_LEAD_INCREATION.TENANT_ID = 0 AND V_LEAD_INCREATION.TENANT_ID IS NOT NULL) AND (V_USER_CREATED_BY.TENANT_ID = 0 AND V_USER_CREATED_BY.TENANT_ID IS NOT NULL) AND (V_USER_MODIFIED_BY.TENANT_ID = 0 AND V_USER_MODIFIED_BY.TENANT_ID IS NOT NULL) AND (T_LEADTEMPERATURE.TENANT_ID = 0 AND T_LEADTEMPERATURE.TENANT_ID IS NOT NULL) AND (T_CAMPAIGN.TENANT_ID = 0 AND T_CAMPAIGN.TENANT_ID IS NOT NULL)) === DEBUG SQLDriver - [builtinApplication.null] About to execute SQL query in 'Oracle' using connection '88920788' === INFO SQLDriver - [builtinApplication.null] Executing SQL query on 'Oracle': SELECT V_LEAD_INCREATION.ADDRESS_ID, V_LEAD_INCREATION.CAMPAIGN_ID, V_LEAD_INCREATION.CREATED_AT, V_LEAD_INCREATION.CREATED_BY, V_LEAD_INCREATION.CREATED_BY_COMPANY_ID, V_LEAD_INCREATION.CREATED_BY_DISTRIBUTOR_ID, V_LEAD_INCREATION.CREATED_BY_RESELLER_ID, V_LEAD_INCREATION.CUST_NAME_CONTACTPERSFULLNAME, V_LEAD_INCREATION.EARLIEST_START, V_LEAD_INCREATION.LATEST_END, V_LEAD_INCREATION.LEADTEMPERATURE_ID, V_LEAD_INCREATION.LEAD_CURRENT_ID, V_LEAD_INCREATION.LEAD_ID, V_LEAD_INCREATION.MODIFIED_AT, V_LEAD_INCREATION.MODIFIED_BY, V_LEAD_INCREATION.POTREV_RESELLER, V_LEAD_INCREATION.STATUS, V_LEAD_INCREATION.TENANT_ID, V_USER_CREATED_BY.FULLNAME_INITIALS_GIVENNAME AS CREATED_BY_NAME, V_USER_CREATED_BY.FULLNAME_COMPANYNAME AS CREATED_BY_NAME_TOOLTIP, V_USER_MODIFIED_BY.FULLNAME_INITIALS_GIVENNAME AS MODIFIED_BY_NAME, V_USER_MODIFIED_BY.FULLNAME_COMPANYNAME AS MODIFIED_BY_NAME_TOOLTIP, T_LEADTEMPERATURE.NAME AS LEADTEMPERATURE_NAME, T_LEADTEMPERATURE.POSITION AS LEADTEMPERATURE_POSITION, T_CAMPAIGN.NAME AS CAMPAIGN_NAME, V_USER_CREATED_BY.TENANT_ID AS CREATED_BY_TENANT_ID, V_USER_MODIFIED_BY.TENANT_ID AS MODIFIED_BY_TENANT_ID, T_LEADTEMPERATURE.TENANT_ID AS LEADTEMPERATURE_TENANT_ID, T_CAMPAIGN.TENANT_ID AS CAMPAIGN_TENANT_ID FROM V_LEAD_INCREATION JOIN V_USER_CREATED_BY ON V_LEAD_INCREATION.CREATED_BY = V_USER_CREATED_BY.ID JOIN V_USER_MODIFIED_BY ON V_LEAD_INCREATION.MODIFIED_BY = V_USER_MODIFIED_BY.ID JOIN T_LEADTEMPERATURE ON V_LEAD_INCREATION.LEADTEMPERATURE_ID = T_LEADTEMPERATURE.ID JOIN T_CAMPAIGN ON V_LEAD_INCREATION.CAMPAIGN_ID = T_CAMPAIGN.ID WHERE ((V_LEAD_INCREATION.LEAD_ID = 6 AND V_LEAD_INCREATION.LEAD_ID IS NOT NULL) AND (V_LEAD_INCREATION.CREATED_BY = 1012 AND V_LEAD_INCREATION.CREATED_BY IS NOT NULL) AND (V_LEAD_INCREATION.TENANT_ID = 0 AND V_LEAD_INCREATION.TENANT_ID IS NOT NULL) AND (V_USER_CREATED_BY.TENANT_ID = 0 AND V_USER_CREATED_BY.TENANT_ID IS NOT NULL) AND (V_USER_MODIFIED_BY.TENANT_ID = 0 AND V_USER_MODIFIED_BY.TENANT_ID IS NOT NULL) AND (T_LEADTEMPERATURE.TENANT_ID = 0 AND T_LEADTEMPERATURE.TENANT_ID IS NOT NULL) AND (T_CAMPAIGN.TENANT_ID = 0 AND T_CAMPAIGN.TENANT_ID IS NOT NULL)) === INFO DSResponse - [builtinApplication.null] DSResponse: List with 1 items === DEBUG DSRequest - Caching instance 332 of DS V_LEAD_PICKLIST from DSRequest.getDataSource() === DEBUG DeclarativeSecurity - Processing security checks for DataSource null, field null === DEBUG DeclarativeSecurity - Processing security checks for DataSource null, field null === DEBUG AppBase - [builtinApplication.null] No userTypes defined, allowing anyone access to all operations for this application === DEBUG AppBase - [builtinApplication.null] No public zero-argument method named '_null' found, performing generic datasource operation === INFO SQLDataSource - [builtinApplication.null] Performing fetch operation with criteria: {criteria:[{value:6,fieldName:"LEAD_ID",operator:"equals"},{value:1012,fieldName:"CREATED_BY",operator:"equals"},{value:0,fieldName:"TENANT_ID",operator:"equals"},{value:0,fieldName:"CREATED_BY_TENANT_ID",operator:"equals"},{value:0,fieldName:"MODIFIED_BY_TENANT_ID",operator:"equals"},{value:0,fieldName:"LEADTEMPERATURE_TENANT_ID",operator:"equals"},{value:0,fieldName:"CAMPAIGN_TENANT_ID",operator:"equals"}],operator:"and",_constructor:"AdvancedCriteria"} values: {criteria:[{value:6,fieldName:"LEAD_ID",operator:"equals"},{value:1012,fieldName:"CREATED_BY",operator:"equals"},{value:0,fieldName:"TENANT_ID",operator:"equals"},{value:0,fieldName:"CREATED_BY_TENANT_ID",operator:"equals"},{value:0,fieldName:"MODIFIED_BY_TENANT_ID",operator:"equals"},{value:0,fieldName:"LEADTEMPERATURE_TENANT_ID",operator:"equals"},{value:0,fieldName:"CAMPAIGN_TENANT_ID",operator:"equals"}],operator:"and",_constructor:"AdvancedCriteria"} === INFO SQLDataSource - [builtinApplication.null] derived query: SELECT $defaultSelectClause FROM $defaultTableClause$defaultAnsiJoinClause WHERE $defaultWhereClause === INFO SQLDataSource - [builtinApplication.null] 332: Executing SQL query on 'Oracle': SELECT V_LEAD_PICKLIST.ADDRESS_ID, V_LEAD_PICKLIST.CAMPAIGN_ID, V_LEAD_PICKLIST.CREATED_AT, V_LEAD_PICKLIST.CREATED_BY, V_LEAD_PICKLIST.CREATED_BY_COMPANY_ID, V_LEAD_PICKLIST.CREATED_BY_DISTRIBUTOR_ID, V_LEAD_PICKLIST.CREATED_BY_RESELLER_ID, V_LEAD_PICKLIST.CUST_NAME_CONTACTPERSFULLNAME, V_LEAD_PICKLIST.EARLIEST_START, V_LEAD_PICKLIST.LATEST_END, V_LEAD_PICKLIST.LEADTEMPERATURE_ID, V_LEAD_PICKLIST.LEAD_CURRENT_ID, V_LEAD_PICKLIST.LEAD_ID, V_LEAD_PICKLIST.MODIFIED_AT, V_LEAD_PICKLIST.MODIFIED_BY, V_LEAD_PICKLIST.POTREV_RESELLER, V_LEAD_PICKLIST.TENANT_ID, V_USER_CREATED_BY.FULLNAME_INITIALS_GIVENNAME AS CREATED_BY_NAME, V_USER_CREATED_BY.FULLNAME_COMPANYNAME AS CREATED_BY_NAME_TOOLTIP, V_USER_MODIFIED_BY.FULLNAME_INITIALS_GIVENNAME AS MODIFIED_BY_NAME, V_USER_MODIFIED_BY.FULLNAME_COMPANYNAME AS MODIFIED_BY_NAME_TOOLTIP, T_LEADTEMPERATURE.NAME AS LEADTEMPERATURE_NAME, T_LEADTEMPERATURE.POSITION AS LEADTEMPERATURE_POSITION, T_CAMPAIGN.NAME AS CAMPAIGN_NAME, V_USER_CREATED_BY.TENANT_ID AS CREATED_BY_TENANT_ID, V_USER_MODIFIED_BY.TENANT_ID AS MODIFIED_BY_TENANT_ID, T_LEADTEMPERATURE.TENANT_ID AS LEADTEMPERATURE_TENANT_ID, T_CAMPAIGN.TENANT_ID AS CAMPAIGN_TENANT_ID FROM V_LEAD_PICKLIST JOIN V_USER_CREATED_BY ON V_LEAD_PICKLIST.CREATED_BY = V_USER_CREATED_BY.ID JOIN V_USER_MODIFIED_BY ON V_LEAD_PICKLIST.MODIFIED_BY = V_USER_MODIFIED_BY.ID JOIN T_LEADTEMPERATURE ON V_LEAD_PICKLIST.LEADTEMPERATURE_ID = T_LEADTEMPERATURE.ID JOIN T_CAMPAIGN ON V_LEAD_PICKLIST.CAMPAIGN_ID = T_CAMPAIGN.ID WHERE ((V_LEAD_PICKLIST.LEAD_ID = 6 AND V_LEAD_PICKLIST.LEAD_ID IS NOT NULL) AND (V_LEAD_PICKLIST.CREATED_BY = 1012 AND V_LEAD_PICKLIST.CREATED_BY IS NOT NULL) AND (V_LEAD_PICKLIST.TENANT_ID = 0 AND V_LEAD_PICKLIST.TENANT_ID IS NOT NULL) AND (V_USER_CREATED_BY.TENANT_ID = 0 AND V_USER_CREATED_BY.TENANT_ID IS NOT NULL) AND (V_USER_MODIFIED_BY.TENANT_ID = 0 AND V_USER_MODIFIED_BY.TENANT_ID IS NOT NULL) AND (T_LEADTEMPERATURE.TENANT_ID = 0 AND T_LEADTEMPERATURE.TENANT_ID IS NOT NULL) AND (T_CAMPAIGN.TENANT_ID = 0 AND T_CAMPAIGN.TENANT_ID IS NOT NULL)) === DEBUG SQLDriver - [builtinApplication.null] About to execute SQL query in 'Oracle' using connection '88920788' === INFO SQLDriver - [builtinApplication.null] Executing SQL query on 'Oracle': SELECT V_LEAD_PICKLIST.ADDRESS_ID, V_LEAD_PICKLIST.CAMPAIGN_ID, V_LEAD_PICKLIST.CREATED_AT, V_LEAD_PICKLIST.CREATED_BY, V_LEAD_PICKLIST.CREATED_BY_COMPANY_ID, V_LEAD_PICKLIST.CREATED_BY_DISTRIBUTOR_ID, V_LEAD_PICKLIST.CREATED_BY_RESELLER_ID, V_LEAD_PICKLIST.CUST_NAME_CONTACTPERSFULLNAME, V_LEAD_PICKLIST.EARLIEST_START, V_LEAD_PICKLIST.LATEST_END, V_LEAD_PICKLIST.LEADTEMPERATURE_ID, V_LEAD_PICKLIST.LEAD_CURRENT_ID, V_LEAD_PICKLIST.LEAD_ID, V_LEAD_PICKLIST.MODIFIED_AT, V_LEAD_PICKLIST.MODIFIED_BY, V_LEAD_PICKLIST.POTREV_RESELLER, V_LEAD_PICKLIST.TENANT_ID, V_USER_CREATED_BY.FULLNAME_INITIALS_GIVENNAME AS CREATED_BY_NAME, V_USER_CREATED_BY.FULLNAME_COMPANYNAME AS CREATED_BY_NAME_TOOLTIP, V_USER_MODIFIED_BY.FULLNAME_INITIALS_GIVENNAME AS MODIFIED_BY_NAME, V_USER_MODIFIED_BY.FULLNAME_COMPANYNAME AS MODIFIED_BY_NAME_TOOLTIP, T_LEADTEMPERATURE.NAME AS LEADTEMPERATURE_NAME, T_LEADTEMPERATURE.POSITION AS LEADTEMPERATURE_POSITION, T_CAMPAIGN.NAME AS CAMPAIGN_NAME, V_USER_CREATED_BY.TENANT_ID AS CREATED_BY_TENANT_ID, V_USER_MODIFIED_BY.TENANT_ID AS MODIFIED_BY_TENANT_ID, T_LEADTEMPERATURE.TENANT_ID AS LEADTEMPERATURE_TENANT_ID, T_CAMPAIGN.TENANT_ID AS CAMPAIGN_TENANT_ID FROM V_LEAD_PICKLIST JOIN V_USER_CREATED_BY ON V_LEAD_PICKLIST.CREATED_BY = V_USER_CREATED_BY.ID JOIN V_USER_MODIFIED_BY ON V_LEAD_PICKLIST.MODIFIED_BY = V_USER_MODIFIED_BY.ID JOIN T_LEADTEMPERATURE ON V_LEAD_PICKLIST.LEADTEMPERATURE_ID = T_LEADTEMPERATURE.ID JOIN T_CAMPAIGN ON V_LEAD_PICKLIST.CAMPAIGN_ID = T_CAMPAIGN.ID WHERE ((V_LEAD_PICKLIST.LEAD_ID = 6 AND V_LEAD_PICKLIST.LEAD_ID IS NOT NULL) AND (V_LEAD_PICKLIST.CREATED_BY = 1012 AND V_LEAD_PICKLIST.CREATED_BY IS NOT NULL) AND (V_LEAD_PICKLIST.TENANT_ID = 0 AND V_LEAD_PICKLIST.TENANT_ID IS NOT NULL) AND (V_USER_CREATED_BY.TENANT_ID = 0 AND V_USER_CREATED_BY.TENANT_ID IS NOT NULL) AND (V_USER_MODIFIED_BY.TENANT_ID = 0 AND V_USER_MODIFIED_BY.TENANT_ID IS NOT NULL) AND (T_LEADTEMPERATURE.TENANT_ID = 0 AND T_LEADTEMPERATURE.TENANT_ID IS NOT NULL) AND (T_CAMPAIGN.TENANT_ID = 0 AND T_CAMPAIGN.TENANT_ID IS NOT NULL)) === INFO DSResponse - [builtinApplication.null] DSResponse: List with 0 items === INFO DSResponse - DSResponse: List with 1 items === DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8 === DEBUG SQLTransaction - Committing Oracle transaction "88920788" === DEBUG RPCManager - DMI response, dropExtraFields: true === DEBUG SQLTransaction - getConnection() found transactional connection for Oracle with hashcode "88920788" === DEBUG SQLTransaction - Ending Oracle transaction "88920788" === DEBUG SQLConnectionManager - About to close PoolableConnection with hashcode "88920788" === DEBUG PoolableSQLConnectionFactory - Executing pingTest 'select 1 from dual' on connection 88920788 === DEBUG SQLTransaction - getConnection() found transactional connection for Oracle (connection is null) === DEBUG SQLTransaction - getConnection() found transactional connection for Oracle (connection is null) === DEBUG SQLTransaction - getConnection() found transactional connection for Oracle (connection is null) === INFO Compression - /lms/lms/sc/IDACall: 1459 -> 577 bytes