2016-03-03 10:01:20,257 DEBUG [localhost-startStop-2] [] [] .crm.spring.client.SASEnvironmentFactory - Using service registry http://vmsasappdev.intra.local:8180/SASWIPServices/remote/com.sas.svcs.registry.client.ServiceRegistryInterface 2016-03-03 10:01:26,528 DEBUG [localhost-startStop-2] [] [] .crm.spring.client.SASEnvironmentFactory - ServiceURL DAO not set. Not running in mid-tier. 2016-03-03 10:01:26,596 DEBUG [localhost-startStop-2] [] [] .crm.spring.client.SASEnvironmentFactory - Using service registry defaultValue 2016-03-03 10:01:26,814 INFO [localhost-startStop-2] [] [] nalytics.crm.security.ejb.MASessionCache - Proxy (privileged) user: sastrust 2016-03-03 10:01:33,468 INFO [Thread-65] [] [] nalytics.crm.security.ejb.MASessionCache - Creating session for loginId=sascisvc@!*(generatedpassworddomain)*!, authDomain=DefaultAuth 2016-03-03 10:01:33,919 INFO [Thread-65] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-641b] [sascisvc] ics.crm.security.ejb.SecurityManagerBean - 2016-03-03 10:01:34,893 INFO [Thread-65] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-641b] [sascisvc] ics.crm.security.ejb.SecurityManagerBean - Setting log level from System Environment Data to 9 2016-03-03 10:01:37,044 WARN [Thread-65] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-641b] [sascisvc] vices.common.config.ConfigurationService - The Product PRODNUM533 is not licensed. 2016-03-03 10:01:37,986 WARN [Thread-65] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-641b] [sascisvc] vices.common.config.ConfigurationService - The Product PRODNUM152 is not licensed. 2016-03-03 10:01:37,987 DEBUG [Thread-65] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-641b] [sascisvc] nalytics.crm.security.ejb.MASessionCache - Session counter incremented for session ID: cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-641b - 0 -> 1 2016-03-03 10:01:38,017 INFO [Thread-65] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-641b] [sascisvc] ics.crm.security.ejb.SecurityManagerBean - user (sascisvc) logged in as sascisvc@!*(generatedpassworddomain)*!, from Internal Services 2016-03-03 10:01:38,059 DEBUG [Thread-65] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-641b] [sascisvc] nagers.AggregateObjectPersistenceManager - call to allClassesGetAllLocksConcise 2016-03-03 10:01:39,603 DEBUG [Thread-65] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-641b] [sascisvc] nagers.AggregateObjectPersistenceManager - returning from allClassesGetAllLocksConciseBySession 2016-03-03 10:01:39,603 DEBUG [Thread-65] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-641b] [sascisvc] alytics.crm.webservices.ReleaseLocksTask - Logout server user Customer Intelligence Services User 2016-03-03 10:01:39,612 INFO [Thread-65] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-641b] [sascisvc] ics.crm.security.ejb.SecurityManagerBean - user (sascisvc) logged out: sascisvc@!*(generatedpassworddomain)*! 2016-03-03 10:01:39,612 DEBUG [Thread-65] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-641b] [sascisvc] nalytics.crm.security.ejb.MASessionCache - Decremented session counter for session ID: cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-641b - 1 -> 0 2016-03-03 10:01:39,670 DEBUG [CIAsyncExec-1] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-641b] [sascisvc] nalytics.crm.security.ejb.MASessionCache - freed 0 objects for user (sascisvc) 2016-03-03 10:01:39,671 DEBUG [CIAsyncExec-1] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-641b] [sascisvc] nagers.AggregateObjectPersistenceManager - calling to allClassesReleaseDataObjectsForSession 2016-03-03 10:01:39,672 DEBUG [CIAsyncExec-1] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-641b] [sascisvc] nagers.AggregateObjectPersistenceManager - releasing data objects for class com.sas.analytics.crm.persistencemanagers.CustomMANodePersistenceManager 2016-03-03 10:01:39,891 DEBUG [CIAsyncExec-1] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-641b] [sascisvc] nagers.AggregateObjectPersistenceManager - releasing data objects for class com.sas.analytics.crm.persistencemanagers.FieldInfoTagPersistenceManager 2016-03-03 10:01:40,107 DEBUG [CIAsyncExec-1] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-641b] [sascisvc] nagers.AggregateObjectPersistenceManager - releasing data objects for class com.sas.analytics.crm.persistencemanagers.NewIdentifierPersistenceManager 2016-03-03 10:01:40,327 DEBUG [CIAsyncExec-1] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-641b] [sascisvc] nagers.AggregateObjectPersistenceManager - releasing data objects for class com.sas.analytics.crm.persistencemanagers.DefaultMANodePersistenceManager 2016-03-03 10:01:40,550 DEBUG [CIAsyncExec-1] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-641b] [sascisvc] nagers.AggregateObjectPersistenceManager - releasing data objects for class com.sas.analytics.crm.persistencemanagers.CustomIBNodePersistenceManager 2016-03-03 10:01:40,769 DEBUG [CIAsyncExec-1] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-641b] [sascisvc] nagers.AggregateObjectPersistenceManager - releasing data objects for class com.sas.analytics.crm.persistencemanagers.DefaultIBNodePersistenceManager 2016-03-03 10:01:40,987 DEBUG [CIAsyncExec-1] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-641b] [sascisvc] nagers.AggregateObjectPersistenceManager - releasing data objects for class com.sas.analytics.crm.persistencemanagers.NewChannelDefinitionPersistenceManager 2016-03-03 10:01:41,205 DEBUG [CIAsyncExec-1] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-641b] [sascisvc] nagers.AggregateObjectPersistenceManager - returning from allClassesReleaseDataObjectsForSession 2016-03-03 10:01:41,207 INFO [CIAsyncExec-1] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-641b] [sascisvc] nalytics.crm.security.ejb.MASessionCache - Releasing session for user sascisvc, loginId=sascisvc@!*(generatedpassworddomain)*!, authDomain=DefaultAuth 2016-03-03 10:01:41,219 DEBUG [CIAsyncExec-1] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-641b] [sascisvc] om.sas.analytics.crm.ma.ejb.MAConfigBean - Releasing all Flows associated with session cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-641b 2016-03-03 10:01:41,219 DEBUG [CIAsyncExec-1] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-641b] [sascisvc] om.sas.analytics.crm.ma.ejb.MAConfigBean - Releasing FlowBeanState for List of FlowStateIDs: 2016-03-03 10:01:41,220 DEBUG [CIAsyncExec-1] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-641b] [sascisvc] nalytics.crm.security.ejb.MASessionCache - All sessions (0): 2016-03-03 10:04:23,627 DEBUG [tomcat-http--8] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-62e0] [lasradm] com.sas.analytics.crm.ejb.CMFlexPlugin - CMSession created 2016-03-03 10:04:44,833 DEBUG [tomcat-http--23] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6242] [lasradm] com.sas.analytics.crm.ejb.CMFlexPlugin - MA Core logoff complete for lasradm. 2016-03-03 10:06:51,977 DEBUG [tomcat-http--39] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.ejb.CMFlexPlugin - CMSession created 2016-03-03 10:06:56,001 DEBUG [tomcat-http--1] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.ejb.CMFlexPlugin - Retrieving capabilities 2016-03-03 10:06:56,002 DEBUG [tomcat-http--1] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] ics.crm.security.ejb.SecurityManagerBean - Attempting to login user in domain from SAS Customer Intelligence Studio 2016-03-03 10:06:56,002 INFO [tomcat-http--1] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] nalytics.crm.security.ejb.MASessionCache - Creating session for loginId=, authDomain=DefaultAuth 2016-03-03 10:06:56,020 DEBUG [tomcat-http--1] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] nalytics.crm.security.ejb.MASessionCache - All sessions (1): user=Marouen Krifa, client=SAS Customer Intelligence Studio, loginId=marouen.krifa.ext@intra, authDomain=DefaultAuth, sessionId=cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209 2016-03-03 10:06:56,056 INFO [tomcat-http--1] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] ics.crm.security.ejb.SecurityManagerBean - marouen.krifa.ext@intra 2016-03-03 10:06:56,060 DEBUG [tomcat-http--1] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] ics.crm.security.ejb.SecurityManagerBean - Verifying WebDAV connection 2016-03-03 10:06:56,185 DEBUG [tomcat-http--1] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] ics.crm.security.ejb.SecurityManagerBean - Connection to WebDAV server successful 2016-03-03 10:06:56,190 INFO [tomcat-http--1] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] ics.crm.security.ejb.SecurityManagerBean - Setting log level from System Environment Data to 9 2016-03-03 10:06:57,211 DEBUG [tomcat-http--1] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] nalytics.crm.security.ejb.MASessionCache - Session counter incremented for session ID: cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209 - 0 -> 1 2016-03-03 10:06:57,221 INFO [tomcat-http--1] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] ics.crm.security.ejb.SecurityManagerBean - user (Marouen Krifa) logged in as marouen.krifa.ext@intra, from SAS Customer Intelligence Studio 2016-03-03 10:06:58,802 INFO [tomcat-http--9] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] ics.crm.security.ejb.SecurityManagerBean - user (Marouen Krifa) who is logged in as marouen.krifa.ext@intra, switched to Business Context: BC_Tunisiana (user preference changed: true) 2016-03-03 10:07:00,104 INFO [tomcat-http--15] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] rm.custdata.datapattern.MAInformationMap - loadDataPatterns()-----Start to load data patterns. 2016-03-03 10:07:01,930 DEBUG [tomcat-http--15] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] .custdata.datapattern.InformationMapPool - Acquired new infoMap: 62fa962b 2016-03-03 10:07:02,470 INFO [tomcat-http--15] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] rm.custdata.datapattern.MAInformationMap - Time to create Map XML:0,537 seconds (+0,537 seconds) 2016-03-03 10:07:02,521 INFO [tomcat-http--15] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] rm.custdata.datapattern.MAInformationMap - Time to cache information map XML: 0,588 seconds 2016-03-03 10:07:02,521 INFO [tomcat-http--15] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] rm.custdata.datapattern.MAInformationMap - Time for getting infoMap SBIP://METASERVER/Ooredoo/InfoMaps/Exploitation/mainfomapooredoo_v_1_4(BriefInformationMap) : 2,415 seconds 2016-03-03 10:07:02,523 DEBUG [tomcat-http--15] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] rm.custdata.datapattern.MAInformationMap - /home/sas/.maQuery does not exist. 2016-03-03 10:07:05,550 INFO [tomcat-http--15] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] rm.custdata.datapattern.MAInformationMap - -----Logical Server : SASApp - Logical Pooled Workspace Server - server A5P2RPHT.AS000002 2016-03-03 10:07:05,752 INFO [tomcat-http--15] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] rm.custdata.datapattern.MAInformationMap - Time for parsing extended attributes and resynchronizing: 3,226 seconds 2016-03-03 10:07:05,752 INFO [tomcat-http--15] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] rm.custdata.datapattern.MAInformationMap - loadDataPatterns()-----Done with loading data patterns. 2016-03-03 10:07:05,752 DEBUG [tomcat-http--15] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] .custdata.datapattern.InformationMapPool - Releasing infoMap used 1 times: 62fa962b 2016-03-03 10:07:05,779 DEBUG [tomcat-http--16] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] managers.DefaultMANodePersistenceManager - starting call to refreshingCache for object for file All-DefaultMANodePersistenceManager with parameter null 2016-03-03 10:07:05,779 DEBUG [tomcat-http--16] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] managers.DefaultMANodePersistenceManager - getMapo from All-DefaultMANodePersistenceManager for bc 2016-03-03 10:07:05,924 DEBUG [tomcat-http--16] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] managers.DefaultMANodePersistenceManager - for file All-DefaultMANodePersistenceManager set cache timestamp to Fri Dec 18 15:38:45 CET 2015 2016-03-03 10:07:05,925 DEBUG [tomcat-http--16] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] managers.DefaultMANodePersistenceManager - objects in DAV: 17 2016-03-03 10:07:05,925 DEBUG [tomcat-http--16] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] managers.DefaultMANodePersistenceManager - verifying required data objects exist in cache 2016-03-03 10:07:05,951 DEBUG [tomcat-http--16] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] managers.DefaultMANodePersistenceManager - completed call to refreshingCache for object for file All-DefaultMANodePersistenceManager with parameter null 2016-03-03 10:07:05,957 DEBUG [tomcat-http--16] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] managers.DefaultIBNodePersistenceManager - starting call to refreshingCache for object for file All-DefaultIBNodePersistenceManager with parameter null 2016-03-03 10:07:05,957 DEBUG [tomcat-http--16] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] managers.DefaultIBNodePersistenceManager - getMapo from All-DefaultIBNodePersistenceManager for bc 2016-03-03 10:07:06,055 DEBUG [tomcat-http--16] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] managers.DefaultIBNodePersistenceManager - for file All-DefaultIBNodePersistenceManager set cache timestamp to Wed Jun 17 13:02:33 CET 2015 2016-03-03 10:07:06,055 DEBUG [tomcat-http--16] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] managers.DefaultIBNodePersistenceManager - objects in DAV: 15 2016-03-03 10:07:06,055 DEBUG [tomcat-http--16] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] managers.DefaultIBNodePersistenceManager - verifying required data objects exist in cache 2016-03-03 10:07:06,055 DEBUG [tomcat-http--16] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] managers.DefaultIBNodePersistenceManager - completed call to refreshingCache for object for file All-DefaultIBNodePersistenceManager with parameter null 2016-03-03 10:07:06,060 DEBUG [tomcat-http--16] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] emanagers.CustomMANodePersistenceManager - starting call to refreshingCache for object for file BCCFNAGXZVB3SCWV-CustomMANodePersistenceManager with parameter null 2016-03-03 10:07:06,060 DEBUG [tomcat-http--16] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] emanagers.CustomMANodePersistenceManager - getMapo from BCCFNAGXZVB3SCWV-CustomMANodePersistenceManager for bc BC_Tunisiana 2016-03-03 10:07:06,158 DEBUG [tomcat-http--16] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] emanagers.CustomMANodePersistenceManager - for file BCCFNAGXZVB3SCWV-CustomMANodePersistenceManager set cache timestamp to Mon Feb 22 16:55:39 CET 2016 2016-03-03 10:07:06,158 DEBUG [tomcat-http--16] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] emanagers.CustomMANodePersistenceManager - objects in DAV: 2 2016-03-03 10:07:06,158 DEBUG [tomcat-http--16] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] emanagers.CustomMANodePersistenceManager - verifying required data objects exist in cache 2016-03-03 10:07:06,158 DEBUG [tomcat-http--16] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] emanagers.CustomMANodePersistenceManager - no required data objects 2016-03-03 10:07:06,158 DEBUG [tomcat-http--16] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] emanagers.CustomMANodePersistenceManager - completed call to refreshingCache for object for file BCCFNAGXZVB3SCWV-CustomMANodePersistenceManager with parameter null 2016-03-03 10:07:06,163 DEBUG [tomcat-http--16] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] emanagers.CustomIBNodePersistenceManager - starting call to refreshingCache for object for file BCCFNAGXZVB3SCWV-CustomIBNodePersistenceManager with parameter null 2016-03-03 10:07:06,163 DEBUG [tomcat-http--16] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] emanagers.CustomIBNodePersistenceManager - getMapo from BCCFNAGXZVB3SCWV-CustomIBNodePersistenceManager for bc BC_Tunisiana 2016-03-03 10:07:06,250 DEBUG [tomcat-http--16] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] emanagers.CustomIBNodePersistenceManager - no content found 2016-03-03 10:07:06,251 DEBUG [tomcat-http--16] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] emanagers.CustomIBNodePersistenceManager - verifying required data objects exist in cache 2016-03-03 10:07:06,251 DEBUG [tomcat-http--16] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] emanagers.CustomIBNodePersistenceManager - no required data objects 2016-03-03 10:07:06,251 DEBUG [tomcat-http--16] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] emanagers.CustomIBNodePersistenceManager - completed call to refreshingCache for object for file BCCFNAGXZVB3SCWV-CustomIBNodePersistenceManager with parameter null 2016-03-03 10:07:06,257 DEBUG [tomcat-http--16] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] om.sas.analytics.crm.ma.ejb.MAConfigBean - getValidNodeDefinitions with parameters nullfalsetruetrue took 0,484 seconds 2016-03-03 10:07:08,254 DEBUG [tomcat-http--23] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] om.sas.analytics.crm.ma.ejb.MAConfigBean - Getting all node definitions with parameters falsetruetruefalse took 0,006 seconds 2016-03-03 10:07:08,392 DEBUG [tomcat-http--22] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] tics.crm.cm.ejb.CampaignManagerProxyImpl - Q> getCampaignsConciseHierarchy 2016-03-03 10:07:08,392 DEBUG [tomcat-http--22] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] nalytics.crm.security.ejb.MASessionCache - Session counter incremented for session ID: cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209 - 1 -> 2 2016-03-03 10:07:08,393 DEBUG [CIAsyncExec-2] [] [] tics.crm.cm.ejb.CampaignManagerProxyImpl - -> getCampaignsConciseHierarchy 2016-03-03 10:07:09,890 INFO [CIAsyncExec-2] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] analytics.crm.cm.ejb.CampaignManagerBean - Returned list of campaigns in folder in 1,481 seconds 2016-03-03 10:07:09,972 DEBUG [CIAsyncExec-2] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] tics.crm.cm.ejb.CampaignManagerProxyImpl - <- getCampaignsConciseHierarchy 2016-03-03 10:07:09,973 DEBUG [CIAsyncExec-2] [] [] nalytics.crm.security.ejb.MASessionCache - Decremented session counter for session ID: cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209 - 2 -> 1 2016-03-03 10:07:10,071 DEBUG [tomcat-http--29] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] s.analytics.crm.ma.ejb.MAConfigProxyImpl - loadCampaign 2016-03-03 10:07:15,851 DEBUG [tomcat-http--28] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] nalytics.crm.security.ejb.MASessionCache - Session counter incremented for session ID: cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209 - 1 -> 2 2016-03-03 10:07:15,852 DEBUG [CIAsyncExec-3] [] [] tics.crm.cm.ejb.CampaignManagerProxyImpl - -> loadCampaign 2016-03-03 10:07:15,891 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.ejb.FlowBean - Starting to load campaign with ID EEEFB31FYJCSVYJ2 for SID cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209 from folder null, readOnly: false, loadDiagram: true, cleanupTablesOnExit: true, executing: false 2016-03-03 10:07:16,589 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] tencemanagers.CampaignPersistenceManager - In MAPersistenceManager:checkOut(MAUser user, String objId). CheckOut by user marouen.krifa.ext@intra of EEEFB31FYJCSVYJ2 for edit was successful. Usage count = 1 2016-03-03 10:07:16,595 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.cm.Campaign - construct Campaign EEEFB31FYJCSVYJ2 2016-03-03 10:07:16,595 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.cm.Campaign - setCampaignData to CampaignDescriptionDO: EEEFB31FYJCSVYJ2 name = Action ciblee Samma3ni code = CAMP571 description = owner = sasadm 2016-03-03 10:07:16,731 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] om.sas.analytics.crm.ma.ejb.MAConfigBean - Getting all node definitions with parameters falsetruetruefalse took 0,005 seconds 2016-03-03 10:07:16,733 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MAFlow - Time creating nodesToInstantiate: 0:00:00.002 2016-03-03 10:07:16,736 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MAFlow - Time sorting nodesToInstantiate: 0:00:00.005 2016-03-03 10:07:16,754 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MANodeFactory - Created new MARootNode in 0,014 seconds 2016-03-03 10:07:16,779 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MANodeFactory - Created new MAMultiSelectNode in 0,025 seconds 2016-03-03 10:07:16,784 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MANodeFactory - Created new MAMultiSelectNode in 0,005 seconds 2016-03-03 10:07:16,789 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MANodeFactory - Created new MAMultiSelectNode in 0,005 seconds 2016-03-03 10:07:16,794 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MANodeFactory - Created new MAMultiSelectNode in 0,005 seconds 2016-03-03 10:07:16,799 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MANodeFactory - Created new MAMultiSelectNode in 0,005 seconds 2016-03-03 10:07:16,804 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MANodeFactory - Created new MAMultiSelectNode in 0,005 seconds 2016-03-03 10:07:16,809 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MANodeFactory - Created new MAMultiSelectNode in 0,005 seconds 2016-03-03 10:07:16,815 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MANodeFactory - Created new MAMultiSelectNode in 0,006 seconds 2016-03-03 10:07:16,821 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MANodeFactory - Created new MAMultiSelectNode in 0,006 seconds 2016-03-03 10:07:16,826 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MANodeFactory - Created new MAMultiSelectNode in 0,005 seconds 2016-03-03 10:07:16,831 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MANodeFactory - Created new MAMultiSelectNode in 0,005 seconds 2016-03-03 10:07:16,839 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MANodeFactory - Created new MALimitNode in 0,007 seconds 2016-03-03 10:07:16,844 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MANodeFactory - Created new MALimitNode in 0,005 seconds 2016-03-03 10:07:16,849 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MANodeFactory - Created new MAMultiSelectNode in 0,005 seconds 2016-03-03 10:07:16,856 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MANodeFactory - Created new MACellNode in 0,007 seconds 2016-03-03 10:07:16,861 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MANodeFactory - Created new MACellNode in 0,005 seconds 2016-03-03 10:07:16,866 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MANodeFactory - Created new MAMultiSelectNode in 0,005 seconds 2016-03-03 10:07:16,897 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MANodeFactory - Created new MACommunicationNode in 0,031 seconds 2016-03-03 10:07:16,903 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MANodeFactory - Created new MACommunicationNode in 0,006 seconds 2016-03-03 10:07:16,908 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MANodeFactory - Created new MALimitNode in 0,005 seconds 2016-03-03 10:07:16,913 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MANodeFactory - Created new MACellNode in 0,005 seconds 2016-03-03 10:07:16,919 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MANodeFactory - Created new MACommunicationNode in 0,006 seconds 2016-03-03 10:07:16,919 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MAFlow - Time creating nodes: 0:00:00.188 2016-03-03 10:07:16,957 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] .crm.notification.ejb.NotificationHelper - NotificationHelper :: Constructor :: Campaign Studio URL = http://vmsasappdev.intra.local:7980/SASCIStudio 2016-03-03 10:07:16,966 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] .custdata.datapattern.InformationMapPool - Using cached infoMap: 62fa962b 2016-03-03 10:07:16,976 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] .custdata.datapattern.InformationMapPool - Releasing infoMap used 2 times: 62fa962b 2016-03-03 10:07:16,977 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] .custdata.datapattern.InformationMapPool - Using cached infoMap: 62fa962b 2016-03-03 10:07:16,999 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] .custdata.datapattern.InformationMapPool - Releasing infoMap used 3 times: 62fa962b 2016-03-03 10:07:16,999 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] .custdata.datapattern.InformationMapPool - Using cached infoMap: 62fa962b 2016-03-03 10:07:17,007 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] .custdata.datapattern.InformationMapPool - Releasing infoMap used 4 times: 62fa962b 2016-03-03 10:07:17,009 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] .custdata.datapattern.InformationMapPool - Using cached infoMap: 62fa962b 2016-03-03 10:07:17,017 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] .custdata.datapattern.InformationMapPool - Releasing infoMap used 5 times: 62fa962b 2016-03-03 10:07:17,017 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] .custdata.datapattern.InformationMapPool - Using cached infoMap: 62fa962b 2016-03-03 10:07:17,024 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] .custdata.datapattern.InformationMapPool - Releasing infoMap used 6 times: 62fa962b 2016-03-03 10:07:17,025 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] .custdata.datapattern.InformationMapPool - Using cached infoMap: 62fa962b 2016-03-03 10:07:17,033 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] .custdata.datapattern.InformationMapPool - Releasing infoMap used 7 times: 62fa962b 2016-03-03 10:07:17,262 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] om.sas.analytics.crm.ma.ejb.MAConfigBean - Got users and groups in 0,225 seconds 2016-03-03 10:07:17,263 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] .custdata.datapattern.InformationMapPool - Using cached infoMap: 62fa962b 2016-03-03 10:07:17,714 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] .custdata.datapattern.InformationMapPool - Acquired new infoMap: 73627d90 2016-03-03 10:07:17,719 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] rm.custdata.datapattern.MAInformationMap - MAIM1:Time taken to getCalculatedItems: 0,005 seconds (+0,005 seconds) 2016-03-03 10:07:17,721 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] rm.custdata.datapattern.MAInformationMap - MAIM1:Time taken to getCloneVarMap: 0,006 seconds (+0,001 seconds) 2016-03-03 10:07:17,721 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] rm.custdata.datapattern.MAInformationMap - MAIM1:Time to store 0 StoredCalculatedItems: 0,007 seconds (+0,001 seconds) 2016-03-03 10:07:17,721 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] rm.custdata.datapattern.MAInformationMap - CITEM: time to setupScoreVariables: 0 seconds (+0 seconds) 2016-03-03 10:07:17,721 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] rm.custdata.datapattern.MAInformationMap - MAIM1:Time to syncUpCalculatedItems on map 73627d90: 0,007 seconds (+0 seconds) 2016-03-03 10:07:17,844 INFO [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] rm.custdata.datapattern.MAInformationMap - Time taken reading Calculated Items from Persistence: 0,121 seconds 2016-03-03 10:07:18,125 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] .custdata.datapattern.InformationMapPool - Releasing infoMap used 1 times: 73627d90 2016-03-03 10:07:18,136 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] rm.custdata.datapattern.MAInformationMap - MAIM1:Time taken to getCalculatedItems: 0,873 seconds (+0,873 seconds) 2016-03-03 10:07:18,136 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] rm.custdata.datapattern.MAInformationMap - MAIM1:Time taken to getCloneVarMap: 0,873 seconds (+0 seconds) 2016-03-03 10:07:18,137 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] rm.custdata.datapattern.MAInformationMap - MAIM1:Time to store 61 StoredCalculatedItems: 0,874 seconds (+0,001 seconds) 2016-03-03 10:07:18,138 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] rm.custdata.datapattern.MAInformationMap - CITEM: time to setupScoreVariables: 0 seconds (+0,001 seconds) 2016-03-03 10:07:18,138 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] rm.custdata.datapattern.MAInformationMap - Time to tryRemove: 0,001 seconds (+0 seconds) 2016-03-03 10:07:18,241 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] rm.custdata.datapattern.MAInformationMap - Time to createLoop: 0,104 seconds (+0,103 seconds) 2016-03-03 10:07:18,241 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] rm.custdata.datapattern.MAInformationMap - MAIM1:Time to syncUpCalculatedItems on map 62fa962b: 0,978 seconds (+0,104 seconds) 2016-03-03 10:07:18,388 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] .custdata.datapattern.InformationMapPool - Releasing infoMap used 8 times: 62fa962b 2016-03-03 10:07:18,399 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.TableFactory - Diagram Action ciblee Samma3ni: Updating cache from: 2016-03-03 10:07:18,400 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.TableFactory - Diagram Action ciblee Samma3ni: Updated table cache: 2016-03-03 10:07:18,400 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MAFlow - Retrieving all cell node IDs for flow (DCAAIX3DJFDRWNLE): Action ciblee Samma3ni : [CFECVYJQB3HNQM2B, ECFGP21UZNDBQFN4, DDDFN4AGV3EHQNFV] 2016-03-03 10:07:18,416 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MAFlow - Time taken sorting 23 nodes: 0:00:00.001 2016-03-03 10:07:18,453 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] ta.ejb.VerifySASObjectsStoredProcessData - VOC: verifying directories [/SAS/sasdata/sasma/maexport/CampagneTunisianaCallCenter, /SAS/sasdata/sasma/maexport/CampagneTunisianaCallCenter, /SAS/sasdata/sasma/maexport/CampagneTunisianaCallCenter] library names [] tables [] 2016-03-03 10:07:18,535 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] vices.storedprocess.ProcessRunnerFactory - Searching for the Stored Process::MA_Verify_Tables in path::/System/Applications/SAS Customer Intelligence/Campaign Management/Application SAS Code/MA_Verify_Tables 2016-03-03 10:07:18,786 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] crm.custdata.storedprocess.StoredProcess - Start executing MA_Verify_Tables stored process 2016-03-03 10:07:19,126 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] ta.ejb.VerifySASObjectsStoredProcessData - fillStream called with streamName vermeta 2016-03-03 10:07:19,181 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] ta.ejb.VerifySASObjectsStoredProcessData - abcabcabc123abc123/SAS/sasdata/sasma/maexport/CampagneTunisianaCallCenter0/SAS/sasdata/sasma/maexport/CampagneTunisianaCallCenter1/SAS/sasdata/sasma/maexport/CampagneTunisianaCallCenter2abc123
2016-03-03 10:07:21,144 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] ustdata.ejb.MAResultDataVerifySASObjects - 1 The SAS System 10:03 Thursday, March 3, 2016 NOTE: Copyright (c) 2002-2012 by SAS Institute Inc., Cary, NC, USA. NOTE: SAS (r) Proprietary Software 9.4 (TS1M2 MBCS3170) Licensed to TUNISIANA PRODUCTION 9.4, Site 70116406. NOTE: This session is executing on the Linux 2.6.32-504.8.1.el6.x86_64 (LIN X64) platform. NOTE: Updated analytical products: SAS/STAT 13.2 SAS/ETS 13.2 NOTE: Additional host information: Linux LIN X64 2.6.32-504.8.1.el6.x86_64 #1 SMP Fri Dec 19 12:09:25 EST 2014 x86_64 Red Hat Enterprise Linux Server release 6.6 (Santiago) You are running SAS 9. Some SAS 8 files will be automatically converted by the V9 engine; others are incompatible. Please see http://support.sas.com/rnd/migration/planning/platform/64bit.html PROC MIGRATE will preserve current SAS file attributes and is recommended for converting all your SAS libraries from any SAS 8 release to SAS 9. For details and examples, please see http://support.sas.com/rnd/migration/index.html This message is contained in the SAS news file, and is presented upon initialization. Edit the file "news" in the "misc/base" directory to display site-specific news and information in the program log. The command line option "-nonews" will prevent this display. NOTE: SAS Initialization used (Total process time): real time 0.00 seconds cpu time 0.01 seconds NOTE: The autoexec file, /SAS/sasconfig/Compute/Lev1/SASApp/StoredProcessServer/autoexec.sas, was executed at server initialization. >>> SAS Macro Variables: CI_SYS_NZA_PG_LOCKS=1 MADEBUG=Y MATABLES=libname MATables list; MAVERSION=6.4 MAX_CONCUR_PROCS=1 MP_FLG=N SYSDBMSG= SYSDBRC=0 SYS_SQL_IP_SPEEDO=YES _APSLIST=matables,max_concur_procs,mp_flg,maversion,madebug,_result,_archive_path,_metaperson,_metauser,_program,_metafolder,_client,_USERNAME,_SECUREUSERNAME _ARCHIVE_PATH=TEMPFILE _CLIENT=StoredProcessService 9.4; JVM 1.7.0_51; Linux (amd64) 2.6.32-358.el6.x86_64 _METAFOLDER=/System/Applications/SAS Customer Intelligence/Campaign Management/Application SAS Code/ _METAPERSON=Marouen Krifa _METAUSER=marouen.krifa.ext@intra _PROGRAM=/System/Applications/SAS Customer Intelligence/Campaign Management/Application SAS Code/MA_Verify_Tables _REPLAY="&_URL?_sessionid=7866E912-8E38-5F4C-9445-900451A97BFE&_program=replay&_entry=&_TMPCAT.." _RESULT=PACKAGE_TO_ARCHIVE _SECUREUSERNAME=marouen.krifa.ext _TMPCAT=APSWORK.TCAT0006 _USERNAME=marouen.krifa.ext NOTE: %INCLUDE (level 1) file /SAS/sasinst/SASFoundation/9.4/sasstp/ma/ma_verify_tables.sas is file /SAS/sasinst/SASFoundation/9.4/sasstp/ma/ma_verify_tables.sas. 3 +/*****************************************************************/ 4 +/* Copyright (c) 2007 - 2013 by SAS Institute Inc., Cary, NC, */ 5 +/* USA. */ 6 +/* All Rights Reserved. */ 7 +/* This software is protected by copyright laws and */ 8 +/* international treaties */ 9 +/* */ 10 +/* U.S. Government Restricted Rights */ 11 +/* Use, duplication, or disclosure of this software and related */ 12 +/* documentation by the U.S. government is subject to the */ 13 +/* Agreement with SAS Institute and the restrictions set forth */ 14 +/* in FAR 52.227-19, Commercial Computer Software - */ 15 +/* Restricted Rights ( June 1987 ) */ 16 +/* */ 17 +/*****************************************************************/ 18 +/* NAME: ma_verify_tables */ 19 +/* VERSION: 6.1 */ 20 +/* DESCRIPTION: MA verify existence of tables SP */ 21 +/* */ 22 +/* PRODUCT: MA */ 23 +/* USAGE: %ma_verify_tables( ); */ 24 +/* */ 25 +/*****************************************************************/ 26 +/*****************************************************************************/ 27 +/* PRISM VERSION: $Revision: 1.1.4.2.2.2.6.3.4.3 $ ; 28 +/* Revision Date: $Date: 2013/02/18 23:12:17 $ ; 29 +/*****************************************************************************/ 30 +/*****************************************************************************/ 31 +/* HISTORY: */ 32 +/* DATE Defect No Comments/updated by */ 33 +/* --------- --------- --------------------------------------------------- */ 34 +/* 23APR2013 GA */ 35 +/*****************************************************************************/ 36 + 37 +/* Check Table Existence and return those that do not exist */ 38 +%global tblLibrary; 39 + Le Système SAS 40 +filename temp temp; 41 +%let _ODSOPTIONS=%str(body=temp); 42 +options mprint; 43 +*ProcessBody; 44 + 45 +%stpbegin; MPRINT(STPBEGIN): options nonotes; MPRINT(STPBEGIN): ods listing close; MPRINT(STPBEGIN): proc display c=sashelp.stputil.tempdir1.scl; MPRINT(STPBEGIN): run; MPRINT(STPBEGIN): ods HTML nogtitle nogfootnote path="/SAS/sasdata/saswork/SAS_work2E760001B596_etl3.intra.local/SAS_work47960001B596_etl3.intra.local/6a7de07f-a440-0c42-a562-0d76d7e9629a/" (URL=NONE) body=temp; MPRINT(STPBEGIN): options device=javaimg; MPRINT(STPBEGIN): options NOTES; 46 +%maspinit(xmlstream=vermeta); MPRINT(MASPINIT): option mprint source source2 stimer notes; MPRINT(MASPINIT): option nofmterr novnferr nobyerr nodsnferr; MPRINT(MASPINIT): option no$syntaxcheck; MPRINT(MASPINIT): libname MATables list; NOTE: Libref= MATABLES Scope= Object Server Moteur= BASE Nom physique= /SAS/sasdata/AppData/SASCustomerIntelligence/CampaignManagement/data/MATables Nom du fichier= /SAS/sasdata/AppData/SASCustomerIntelligence/CampaignManagement/data/MATables Numéro Inode= 268437080 Autorisation d'accès= rwxrwx--- Nom du propriétaire= sas Taille de fichier (octets)= 73728 MPRINT(MASPINIT): ; MPRINT(MASPINIT): libname vermeta xml; NOTE: Libref VERMETA was successfully assigned as follows: Engine: XML Physical Name: VERMETA MPRINT(MASPINIT): proc copy in=vermeta out=work; MPRINT(MASPINIT): run; MPRINT(MASPINIT): _CLASSES_ FROM _SYSTABLES_ IN FILE ''; NOTE: Copying VERMETA.DIRECTORY_NAMES to WORK.DIRECTORY_NAMES (memtype=DATA). Le Système SAS MPRINT(MASPINIT): * FROM DIRECTORY_NAMES IN FILE ''; NOTE: BUFSIZE is not cloned when copying across different engines. System Option for BUFSIZE was used. INFO : Le bloc E/S ne peut être utilisé car : INFO : - Les tables utilisent différents moteurs, ont différentes variables ou ont des attributs pouvant différer. NOTE: There were 4 observations read from the data set VERMETA.DIRECTORY_NAMES. NOTE: The data set WORK.DIRECTORY_NAMES has 4 observations and 2 variables. NOTE: Copying VERMETA.INVOKE_LIBRARIES to WORK.INVOKE_LIBRARIES (memtype=DATA). MPRINT(MASPINIT): * FROM INVOKE_LIBRARIES IN FILE ''; NOTE: BUFSIZE is not cloned when copying across different engines. System Option for BUFSIZE was used. INFO : Le bloc E/S ne peut être utilisé car : INFO : - Les tables utilisent différents moteurs, ont différentes variables ou ont des attributs pouvant différer. NOTE: There were 1 observations read from the data set VERMETA.INVOKE_LIBRARIES. NOTE: The data set WORK.INVOKE_LIBRARIES has 1 observations and 2 variables. NOTE: Copying VERMETA.LIBRARY_NAMES to WORK.LIBRARY_NAMES (memtype=DATA). MPRINT(MASPINIT): * FROM LIBRARY_NAMES IN FILE ''; NOTE: BUFSIZE is not cloned when copying across different engines. System Option for BUFSIZE was used. INFO : Le bloc E/S ne peut être utilisé car : INFO : - Les tables utilisent différents moteurs, ont différentes variables ou ont des attributs pouvant différer. NOTE: There were 1 observations read from the data set VERMETA.LIBRARY_NAMES. NOTE: The data set WORK.LIBRARY_NAMES has 1 observations and 2 variables. NOTE: Copying VERMETA.TABLE_NAMES to WORK.TABLE_NAMES (memtype=DATA). MPRINT(MASPINIT): * FROM TABLE_NAMES IN FILE ''; NOTE: BUFSIZE is not cloned when copying across different engines. System Option for BUFSIZE was used. INFO : Le bloc E/S ne peut être utilisé car : INFO : - Les tables utilisent différents moteurs, ont différentes variables ou ont des attributs pouvant différer. NOTE: There were 1 observations read from the data set VERMETA.TABLE_NAMES. NOTE: The data set WORK.TABLE_NAMES has 1 observations and 2 variables. NOTE: PROCEDURE COPY used (Total process time): real time 0.13 secondes cpu time 0.01 secondes 47 + 48 +/* Inline macro to execute macro and catch errors. */ 49 +%macro exec_macro; 50 + %matblxst(WORK.INVOKE_LIBRARIES, WORK.TABLE_NAMES, WORK.DIRECTORY_NAMES, WORK.LIBRARY_NAMES, &_stpwork); 51 +%mend; 52 +%exec_macro; Le Système SAS LibnameTable=WORK.INVOKE_LIBRARIES TableNamesTable=WORK.TABLE_NAMES DirectoriesTable=WORK.DIRECTORY_NAMES LibrariesTable=WORK.LIBRARY_NAMES outputPrefix=/SAS/sasdata/saswork/SAS_work2E760001B596_etl3.intra.local/SAS_work47960001B596_etl3.intra.local/6a7de07f-a440-0c42-a562-0d76d7e9629a/ MPRINT(MATBLXST): filename libs temp lrecl=32767; MPRINT(MATBLXST): data _null_; MPRINT(MATBLXST): file libs; MPRINT(MATBLXST): set WORK.INVOKE_LIBRARIES(firstobs=2); WARNING: Option FIRSTOBS > nombre d'observations dans WORK.INVOKE_LIBRARIES. MPRINT(MATBLXST): put libstmt; MPRINT(MATBLXST): run; NOTE: The file LIBS is: Nom du fichier=/SAS/sasdata/saswork/SAS_work2E760001B596_etl3.intra.local/#LN00120, Nom du propriétaire=sassrv, Nom du groupe=sasgrp, Autorisation d'accès=-rw-------, Modifié(e) le=03 mars 2016 10 h 03 NOTE: 0 records were written to the file LIBS. NOTE: There were 0 observations read from the data set WORK.INVOKE_LIBRARIES. NOTE: DATA statement used (Total process time): real time 0.01 secondes cpu time 0.00 secondes NOTE: %INCLUDE (level 2) file LIBS is file /SAS/sasdata/saswork/SAS_work2E760001B596_etl3.intra.local/#LN00120. NOTE: %INCLUDE (level 2) ending. NOTE: %INCLUDE (level 1) resuming. MPRINT(MATBLXST): filename libs clear; NOTE: Fileref LIBS has been deassigned. MPRINT(MATBLXST): filename tout "/SAS/sasdata/saswork/SAS_work2E760001B596_etl3.intra.local/SAS_work47960001B596_etl3.intra.local/6a7de07f-a440-0c42-a562-0d76d7e9629a/badTables.txt"; MPRINT(MATBLXST): data _null_; MPRINT(MATBLXST): file tout; MPRINT(MATBLXST): set WORK.TABLE_NAMES(firstobs=2); WARNING: Option FIRSTOBS > nombre d'observations dans WORK.TABLE_NAMES. MPRINT(MATBLXST): if (exist(name))=0 then put idx; Le Système SAS MPRINT(MATBLXST): run; NOTE: The file TOUT is: Nom du fichier=/SAS/sasdata/saswork/SAS_work2E760001B596_etl3.intra.local/SAS_work47960001B596_etl3.intra.local/6a7de07f-a440-0c42-a562-0d76d7e9629a/badTables.txt, Nom du propriétaire=sassrv, Nom du groupe=sasgrp, Autorisation d'accès=-rw-------, Modifié(e) le=03 mars 2016 10 h 03 NOTE: 0 records were written to the file TOUT. NOTE: There were 0 observations read from the data set WORK.TABLE_NAMES. NOTE: DATA statement used (Total process time): real time 0.00 secondes cpu time 0.00 secondes MPRINT(MATBLXST): filename tout clear; NOTE: Fileref TOUT has been deassigned. MPRINT(MATBLXST): filename tout "/SAS/sasdata/saswork/SAS_work2E760001B596_etl3.intra.local/SAS_work47960001B596_etl3.intra.local/6a7de07f-a440-0c42-a562-0d76d7e9629a/badDirectories.txt"; MPRINT(MATBLXST): data _null_; MPRINT(MATBLXST): file tout; MPRINT(MATBLXST): set WORK.DIRECTORY_NAMES(firstobs=2); MPRINT(MATBLXST): if (fileexist(name))=0 then put idx; MPRINT(MATBLXST): run; NOTE: The file TOUT is: Nom du fichier=/SAS/sasdata/saswork/SAS_work2E760001B596_etl3.intra.local/SAS_work47960001B596_etl3.intra.local/6a7de07f-a440-0c42-a562-0d76d7e9629a/badDirectories.txt, Nom du propriétaire=sassrv, Nom du groupe=sasgrp, Autorisation d'accès=-rw-------, Modifié(e) le=03 mars 2016 10 h 03 NOTE: 0 records were written to the file TOUT. NOTE: There were 3 observations read from the data set WORK.DIRECTORY_NAMES. NOTE: DATA statement used (Total process time): real time 0.00 secondes cpu time 0.00 secondes Le Système SAS MPRINT(MATBLXST): filename tout clear; NOTE: Fileref TOUT has been deassigned. MPRINT(MATBLXST): filename tout "/SAS/sasdata/saswork/SAS_work2E760001B596_etl3.intra.local/SAS_work47960001B596_etl3.intra.local/6a7de07f-a440-0c42-a562-0d76d7e9629a/badLibraries.txt"; MPRINT(MATBLXST): filename tempinc temp lrecl=32767; MPRINT(MATBLXST): data _null_; MPRINT(MATBLXST): length c $ 32767; MPRINT(MATBLXST): file tempinc; MPRINT(MATBLXST): set WORK.LIBRARY_NAMES(firstobs=2); WARNING: Option FIRSTOBS > nombre d'observations dans WORK.LIBRARY_NAMES. MPRINT(MATBLXST): c='%'||'mausrexp('||trim(name)||',Execute);'; MPRINT(MATBLXST): put c; MPRINT(MATBLXST): c='data _null_; file tout mod;'; MPRINT(MATBLXST): put c; MPRINT(MATBLXST): c='if libref("'||trim(name)||'") then put "'||trim(idx)||'";'; MPRINT(MATBLXST): put c; MPRINT(MATBLXST): c='run;'; MPRINT(MATBLXST): put c; MPRINT(MATBLXST): c='%'||'mausrexp('||trim(name)||',Clear);'; MPRINT(MATBLXST): put c; MPRINT(MATBLXST): run; NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 52:108 NOTE: The file TEMPINC is: Nom du fichier=/SAS/sasdata/saswork/SAS_work2E760001B596_etl3.intra.local/#LN00124, Nom du propriétaire=sassrv, Nom du groupe=sasgrp, Autorisation d'accès=-rw-------, Modifié(e) le=03 mars 2016 10 h 03 NOTE: 0 records were written to the file TEMPINC. NOTE: There were 0 observations read from the data set WORK.LIBRARY_NAMES. NOTE: DATA statement used (Total process time): real time 0.00 secondes cpu time 0.00 secondes Le Système SAS NOTE: %INCLUDE (level 2) file TEMPINC is file /SAS/sasdata/saswork/SAS_work2E760001B596_etl3.intra.local/#LN00124. NOTE: %INCLUDE (level 2) ending. NOTE: %INCLUDE (level 1) resuming. MPRINT(MATBLXST): filename tempinc clear; NOTE: Fileref TEMPINC has been deassigned. MPRINT(MATBLXST): filename tout clear; NOTE: Fileref TOUT has been deassigned. MPRINT(EXEC_MACRO): ; 53 + 54 +%mastatus( &_stpwork.results.txt ); Return Status in process 112022: SYSCC=0 MAError= MAMsg= MPRINT(MASTATUS): data _null_; MPRINT(MASTATUS): length msg $ 5000; MPRINT(MASTATUS): file "/SAS/sasdata/saswork/SAS_work2E760001B596_etl3.intra.local/SAS_work47960001B596_etl3.intra.local/6a7de07f-a440-0c42-a562-0d76d7e9629a/results.txt" mod lrecl=32767; /SAS/sasdata/saswork/SAS_work2E760001B596_etl3.intra.local/SAS_work47960001B596_etl3.intra.local/6a7de07f-a440-0c42-a562-0d76d7e9629a/results.txt MPRINT(MASTATUS): rc=symgetn('SYSCC'); MPRINT(MASTATUS): if rc<2 or rc=4 then put 'OK'; MPRINT(MASTATUS): put "SYSCC=" rc; MPRINT(MASTATUS): if symexist('MAError') then do; MPRINT(MASTATUS): code = symgetc('MAError'); MPRINT(MASTATUS): if missing(code) then; MPRINT(MASTATUS): else put 'MAError=' code; MPRINT(MASTATUS): end; MPRINT(MASTATUS): if symexist('MAMsg') then do; MPRINT(MASTATUS): msg = symgetc('MAMsg'); MPRINT(MASTATUS): if missing(msg) then; MPRINT(MASTATUS): else put 'MAMsg=' msg; MPRINT(MASTATUS): end; MPRINT(MASTATUS): if symexist('MANodeName') then do; MPRINT(MASTATUS): msg = symgetc('MANodeName'); MPRINT(MASTATUS): if missing(msg) then; MPRINT(MASTATUS): else put 'MANodeName=' msg; MPRINT(MASTATUS): end; MPRINT(MASTATUS): if symexist('MATableName') then do; MPRINT(MASTATUS): msg = symgetc('MATableName'); Le Système SAS MPRINT(MASTATUS): if missing(msg) then; MPRINT(MASTATUS): else put 'MATableName=' msg; MPRINT(MASTATUS): end; MPRINT(MASTATUS): if symexist('MAColumnName') then do; MPRINT(MASTATUS): msg = symgetc('MAColumnName'); MPRINT(MASTATUS): if missing(msg) then; MPRINT(MASTATUS): else put 'MAColumnName=' msg; MPRINT(MASTATUS): end; MPRINT(MASTATUS): put ' '; MPRINT(MASTATUS): run; INFO : Les variables caractères ont par défaut une longueur de 200 aux emplacements définis par : (Ligne):(Colonne). Risque de troncature. 54:159 code NOTE: The file "/SAS/sasdata/saswork/SAS_work2E760001B596_etl3.intra.local/SAS_work47960001B596_etl3.intra.local/6a7de07f-a440-0c42-a562-0d76d7e9629a/results.txt" is: Nom du fichier=/SAS/sasdata/saswork/SAS_work2E760001B596_etl3.intra.local/SAS_work47960001B596_etl3.intra.local/6a7de07f-a440-0c42-a562-0d76d7e9629a/results.txt, Nom du propriétaire=sassrv, Nom du groupe=sasgrp, Autorisation d'accès=-rw-------, Modifié(e) le=03 mars 2016 10 h 03, Taille de fichier (octets)=0 NOTE: 3 records were written to the file "/SAS/sasdata/saswork/SAS_work2E760001B596_etl3.intra.local/SAS_work47960001B596_etl3.intra.local/6a7de07f-a440-0c42-a562-0d76d7e9629a/results.txt". The minimum record length was 2. The maximum record length was 7. NOTE: DATA statement used (Total process time): real time 0.00 secondes cpu time 0.01 secondes 55 +libname _all_ clear; NOTE: Libref VERMETA has been deassigned. 56 + 57 +%stpend; MPRINT(STPEND): options nonotes; MPRINT(STPEND): ods _ALL_ close; MPRINT(STPEND): proc display c=sashelp.stputil.package1.scl; MPRINT(STPEND): run; 58 data _null_; Le Système SAS MPRINT(STPEND): data _null_; 59 length intRc 8 archiveFullPath $4096; MPRINT(STPEND): length intRc 8 archiveFullPath $4096; 60 ; MPRINT(STPEND): ; 61 call package_publish(1, 'TO_ARCHIVE', intRc, "ARCHIVE_PATH, ARCHIVE_FULLPATH", "TEMPFILE", archiveFullPath); MPRINT(STPEND): call package_publish(1, 'TO_ARCHIVE', intRc, "ARCHIVE_PATH, ARCHIVE_FULLPATH", "TEMPFILE", archiveFullPath); 62 call symput('_STPERRMSG', sysmsg()); MPRINT(STPEND): call symput('_STPERRMSG', sysmsg()); 63 call symput('_STPERROR', compress(put(intRc, best12.))); MPRINT(STPEND): call symput('_STPERROR', compress(put(intRc, best12.))); 64 call symput('_ARCHIVE_FULLPATH', strip(archiveFullPath)); MPRINT(STPEND): call symput('_ARCHIVE_FULLPATH', strip(archiveFullPath)); 65 ; MPRINT(STPEND): ; 66 run; MPRINT(STPEND): run; MPRINT(STPEND): options NOTES; 67 + 68 +filename temp clear; NOTE: Fileref TEMP has been deassigned. NOTE: %INCLUDE (level 1) ending. 2016-03-03 10:07:21,157 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] s.analytics.crm.task.ejb.TaskManagerBean - -- Not Firing MALogEvent event, type: 600, for log: MA_Verify_Tables 2016-03-03 10:07:21,214 INFO [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] crm.custdata.storedprocess.StoredProcess - Time taken executing MA_Verify_Tables stored process : 2,427 seconds 2016-03-03 10:07:21,215 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] ta.ejb.VerifySASObjectsStoredProcessData - Time to verify all tables: 2,786 seconds 2016-03-03 10:07:21,217 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MAFlow - Time taken updating calculated item references: 0:00:00.001 2016-03-03 10:07:21,221 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.ejb.IdTracker - For SEED_LISTS on node SASServer6_1_vmsasappdev.intra.local for SID cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209 : putBaseObjectsInUse ref BHCDYMUCTJETQJVS base [] 2016-03-03 10:07:21,222 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.ejb.IdTracker - For SEED_LISTS on node SASServer6_1_vmsasappdev.intra.local for SID cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209 : removeObjects refs [BHCDYMUCTJETQJVS] 2016-03-03 10:07:21,223 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.ejb.IdTracker - For SEED_LISTS on node SASServer6_1_vmsasappdev.intra.local for SID cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209 : putBaseObjectsInUse ref CEFDMEH0B3E2SCZ3 base [] 2016-03-03 10:07:21,224 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.ejb.IdTracker - For SEED_LISTS on node SASServer6_1_vmsasappdev.intra.local for SID cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209 : removeObjects refs [CEFDMEH0B3E2SCZ3] 2016-03-03 10:07:21,225 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.ejb.IdTracker - For SEED_LISTS on node SASServer6_1_vmsasappdev.intra.local for SID cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209 : putBaseObjectsInUse ref HFBC3KJBOBGLRF3Q base [] 2016-03-03 10:07:21,225 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.ejb.IdTracker - For SEED_LISTS on node SASServer6_1_vmsasappdev.intra.local for SID cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209 : removeObjects refs [HFBC3KJBOBGLRF3Q] 2016-03-03 10:07:21,226 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MAFlow - Node ID/Name Map for Campaign Action ciblee Samma3ni / Diagram Action ciblee Samma3ni: 2016-03-03 10:07:21,226 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MAFlow - Node GAAGX1ECXVFKVUD1 : Actifs 2016-03-03 10:07:21,226 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MAFlow - Node EGAGEKWYHRF3UKVR : ARPU M-1 > 35 DT. 2016-03-03 10:07:21,226 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MAFlow - Node BAHAWXRQ33D4QOO2 : Non contacte les 2derniers mois 2016-03-03 10:07:21,226 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MAFlow - Node GHFAPIQVQFHIVZAA : Non inscrit samma3n les 3 derniers mois(2) 2016-03-03 10:07:21,226 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MAFlow - Node CFECVYJQB3HNQM2B : Population(3) 2016-03-03 10:07:21,226 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MAFlow - Node BBBCQAPGLBHHVGU0 : Awal post 2016-03-03 10:07:21,226 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MAFlow - Node ECFGP21UZNDBQFN4 : Population 2016-03-03 10:07:21,226 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MAFlow - Node DDDFN4AGV3EHQNFV : Population(2) 2016-03-03 10:07:21,226 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MAFlow - Node HCHACWP11JESVITN : Type Client 2016-03-03 10:07:21,226 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MAFlow - Node BHCDYMUCTJETQJVS : Action Ciblee SAMMA3NI FBR 2016-03-03 10:07:21,226 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MAFlow - Node FBEB3QBSTBDXQLDV : Limiter(3) 2016-03-03 10:07:21,227 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MAFlow - Node HFEGSIQZQFE1TDLC : Pre 2016-03-03 10:07:21,227 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MAFlow - Node ACBDIYW0ARFASXT0 : ARPU M-1 > 20 DT 2016-03-03 10:07:21,227 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MAFlow - Node AHFC341RRFAWWNPZ : Segment Du Mois 2016-03-03 10:07:21,227 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MAFlow - Node AHDD1OMV2RB5QUS4 : Prepaye et CC et Non CC 2016-03-03 10:07:21,227 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MAFlow - Node HGBFXLHBFJDQU2DD : Segment Du Mois -1 2016-03-03 10:07:21,227 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MAFlow - Node AGGHMLPWSNFCSM43 : Root 2016-03-03 10:07:21,227 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MAFlow - Node DBFC0TFIVZHOR4S4 : Segment Du Mois -2 2016-03-03 10:07:21,227 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MAFlow - Node FDAFIZEP2RHJQLOT : Limiter 2016-03-03 10:07:21,227 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MAFlow - Node CEFDMEH0B3E2SCZ3 : Action Ciblee SAMMA3NI Pre 2016-03-03 10:07:21,227 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MAFlow - Node CCEEQGHRMNFDSJLW : Limiter(2) 2016-03-03 10:07:21,227 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MAFlow - Node HFBC3KJBOBGLRF3Q : Action Ciblee SAMMA3NI Post 2016-03-03 10:07:21,227 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MAFlow - Node EFCHDO4IIZC5Q0QF : FBR 2016-03-03 10:07:21,584 INFO [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] analytics.crm.cm.ejb.CampaignManagerBean - Loaded CampaignConciseInfoDO EEEFB31FYJCSVYJ20,008 seconds 2016-03-03 10:07:21,589 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.cm.Campaign - created campaign(EEEFB31FYJCSVYJ2): Action ciblee Samma3ni 2016-03-03 10:07:21,626 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] s.analytics.crm.task.ejb.TaskManagerBean - Sent flow event message (Flow Modified Changed) to flow with id DCAAIX3DJFDRWNLE 2016-03-03 10:07:21,633 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.cm.Campaign - Dumping surrogate keys for Campaign Action ciblee Samma3ni Campaign SK: 571, Campaign Code: CAMP571 2016-03-03 10:07:21,636 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.cm.Campaign - campBean: updating campaign (EEEFB31FYJCSVYJ2): Action ciblee Samma3ni 2016-03-03 10:07:21,662 INFO [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.ejb.FlowBean - Campaign Action ciblee Samma3ni (EEEFB31FYJCSVYJ2) loaded in 5,779 seconds 2016-03-03 10:07:21,697 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] s.analytics.crm.task.ejb.TaskManagerBean - Sent paste status "MAPFDPasteDisabled" to SID cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209 2016-03-03 10:07:21,697 DEBUG [CIAsyncExec-3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] tics.crm.cm.ejb.CampaignManagerProxyImpl - <- loadCampaign 2016-03-03 10:07:21,697 DEBUG [CIAsyncExec-3] [] [] nalytics.crm.security.ejb.MASessionCache - Decremented session counter for session ID: cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209 - 2 -> 1 2016-03-03 10:07:21,830 DEBUG [tomcat-http--37] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] s.analytics.crm.cm.ejb.CampaignProxyImpl - Q> getCampaignDetails 2016-03-03 10:07:21,830 DEBUG [tomcat-http--37] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] nalytics.crm.security.ejb.MASessionCache - Session counter incremented for session ID: cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209 - 1 -> 2 2016-03-03 10:07:21,830 DEBUG [CIAsyncExec-4] [] [] s.analytics.crm.cm.ejb.CampaignProxyImpl - -> getCampaignDetails 2016-03-03 10:07:21,864 DEBUG [CIAsyncExec-4] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] s.analytics.crm.cm.ejb.CampaignProxyImpl - <- getCampaignDetails 2016-03-03 10:07:21,864 DEBUG [CIAsyncExec-4] [] [] nalytics.crm.security.ejb.MASessionCache - Decremented session counter for session ID: cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209 - 2 -> 1 2016-03-03 10:07:21,987 DEBUG [tomcat-http--38] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] s.analytics.crm.ma.ejb.MAConfigProxyImpl - 1 2016-03-03 10:07:26,567 INFO [CILCSI-7a414812-1] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-5ebb] [sascisvc] ics.crm.security.ejb.SecurityManagerBean - user (sascisvc) logged in as sascisvc@!*(generatedpassworddomain)*!, from Internal Services 2016-03-03 10:07:26,567 INFO [CILCSI-7a414812-1] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-5ebb] [sascisvc] und.assets.DecisionServicesAssetProvider - SAS Decision Services setinit not available. Cancelling SAS CI RDM DS asset installation. 2016-03-03 10:07:26,577 INFO [CILCSI-7a414812-1] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-5ebb] [sascisvc] ics.crm.security.ejb.SecurityManagerBean - user (sascisvc) logged out: sascisvc@!*(generatedpassworddomain)*! 2016-03-03 10:07:26,577 DEBUG [CILCSI-7a414812-1] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-5ebb] [sascisvc] nalytics.crm.security.ejb.MASessionCache - Decremented session counter for session ID: cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-5ebb - 1 -> 0 2016-03-03 10:07:26,614 DEBUG [CIAsyncExec-5] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-5ebb] [sascisvc] nalytics.crm.security.ejb.MASessionCache - freed 0 objects for user (sascisvc) 2016-03-03 10:07:26,615 DEBUG [CIAsyncExec-5] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-5ebb] [sascisvc] nagers.AggregateObjectPersistenceManager - calling to allClassesReleaseDataObjectsForSession 2016-03-03 10:07:26,615 DEBUG [CIAsyncExec-5] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-5ebb] [sascisvc] nagers.AggregateObjectPersistenceManager - releasing data objects for class com.sas.analytics.crm.persistencemanagers.CustomMANodePersistenceManager 2016-03-03 10:07:27,148 DEBUG [CIAsyncExec-5] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-5ebb] [sascisvc] nagers.AggregateObjectPersistenceManager - releasing data objects for class com.sas.analytics.crm.persistencemanagers.FieldInfoTagPersistenceManager 2016-03-03 10:07:27,694 WARN [tomcat-http--47] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] vices.common.config.ConfigurationService - The Product PRODNUM168 is not licensed. 2016-03-03 10:07:27,700 DEBUG [CIAsyncExec-5] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-5ebb] [sascisvc] nagers.AggregateObjectPersistenceManager - releasing data objects for class com.sas.analytics.crm.persistencemanagers.NewIdentifierPersistenceManager 2016-03-03 10:07:27,962 DEBUG [CIAsyncExec-5] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-5ebb] [sascisvc] nagers.AggregateObjectPersistenceManager - releasing data objects for class com.sas.analytics.crm.persistencemanagers.DefaultMANodePersistenceManager 2016-03-03 10:07:28,223 DEBUG [CIAsyncExec-5] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-5ebb] [sascisvc] nagers.AggregateObjectPersistenceManager - releasing data objects for class com.sas.analytics.crm.persistencemanagers.CustomIBNodePersistenceManager 2016-03-03 10:07:28,486 DEBUG [CIAsyncExec-5] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-5ebb] [sascisvc] nagers.AggregateObjectPersistenceManager - releasing data objects for class com.sas.analytics.crm.persistencemanagers.DefaultIBNodePersistenceManager 2016-03-03 10:07:28,752 DEBUG [CIAsyncExec-5] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-5ebb] [sascisvc] nagers.AggregateObjectPersistenceManager - releasing data objects for class com.sas.analytics.crm.persistencemanagers.NewChannelDefinitionPersistenceManager 2016-03-03 10:07:29,015 DEBUG [CIAsyncExec-5] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-5ebb] [sascisvc] nagers.AggregateObjectPersistenceManager - returning from allClassesReleaseDataObjectsForSession 2016-03-03 10:07:29,015 INFO [CIAsyncExec-5] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-5ebb] [sascisvc] nalytics.crm.security.ejb.MASessionCache - Releasing session for user sascisvc, loginId=sascisvc@!*(generatedpassworddomain)*!, authDomain=DefaultAuth 2016-03-03 10:07:29,020 DEBUG [CIAsyncExec-5] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-5ebb] [sascisvc] om.sas.analytics.crm.ma.ejb.MAConfigBean - Releasing all Flows associated with session cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-5ebb 2016-03-03 10:07:29,021 DEBUG [CIAsyncExec-5] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-5ebb] [sascisvc] om.sas.analytics.crm.ma.ejb.MAConfigBean - Releasing FlowBeanState for List of FlowStateIDs: 2016-03-03 10:07:29,021 DEBUG [CIAsyncExec-5] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-5ebb] [sascisvc] nalytics.crm.security.ejb.MASessionCache - All sessions (1): user=Marouen Krifa, client=SAS Customer Intelligence Studio, loginId=marouen.krifa.ext@intra, authDomain=DefaultAuth, sessionId=cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209 2016-03-03 10:07:35,138 DEBUG [tomcat-http--49] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] stdata.datapattern.VerboseInformationMap - InformationMap : MAInfoMapOoredoo_V_1_4 [MAMeta = Libname MAMeta "/SAS/sasdata/AppData/SASCustomerIntelligence/CampaignManagement/data/MAMeta";] [Subject_Default = Subject_ID_Abonne] [Subject_ID_Abonne = Abonne] [MetadataTable_Prefix_Subject_ID_Abonne = Abonne] [Subject_ID_Client = Client] [MetadataTable_Prefix_Subject_ID_Client = Client] [From_Subject_ID_Client_To_Subject_ID_Abonne = OneToMany] [From_Subject_ID_Abonne_To_Subject_ID_Client = OneToOne] [Verbose = False] [Subject_ID_Gerant = Gerant] [MetadataTable_Prefix_Subject_ID_Gerant = Gerant] [From_Subject_ID_Client_To_Subject_ID_Gerant = OneToOne] [From_Subject_ID_Gerant_To_Subject_ID_Client = OneToMany] [Subject_ID_Case = Case] [MetadataTable_Prefix_Subject_ID_Case = Case] [From_Subject_ID_Case_To_Subject_ID_Abonne = ManyToOne] [From_Subject_ID_Abonne_To_Subject_ID_Case = OneToOne] [Subject_Code_Subject_ID_Abonne = 01] [Subject_Code_Subject_ID_Client = 02] [Subject_Code_Subject_ID_Gerant = 03] [Subject_Code_Subject_ID_Case = 04] Abonne [Subject_ID_1 = Subject_ID_Client] [Subject_ID_2 = Subject_ID_Abonne] Informations Client [Subject_ID_1 = Subject_ID_Client] [Subject_ID_2 = Subject_ID_Abonne] [Subject_ID_3 = Subject_ID_Gerant] Caracteristiques Personnelles [Subject_ID_1 = Subject_ID_Client] [Subject_ID_2 = Subject_ID_Abonne] [Subject_ID_3 = Subject_ID_Gerant] SegmentActuel [Level = Interval] [AllowBlankValue = True] [Metadata = Values] LibelleSegmentActuelClient [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] SegmentPrecedent [Level = Nominal] [Metadata = Values] [AllowBlankValue = True] LibelleSegmentPrecedentClient [Level = Nominal] [AllowBlankValue = True] [Metadata = None] DateNaissance [Level = Interval] [AllowBlankValue = True] [Metadata = None] NiveauEducation [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Age [Level = Interval] [AllowBlankValue = True] [Metadata = None] Sexe [Level = Nominal] [AllowBlankValue = True] [Metadata = None] PaysResidence [Level = Nominal] [AllowBlankValue = True] [Metadata = None] SituationFamilial [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Emploi [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Nationnalite [Level = Nominal] [AllowBlankValue = True] [Metadata = None] NumeroTelephonne [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Cin [Level = Nominal] [AllowBlankValue = True] [Metadata = None] ResidentTunisie [Level = Nominal] [Metadata = None] [AllowBlankValue = True] Ville [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Adresse 1 [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Adresse 2 [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Menage [Level = Nominal] [Metadata = None] [AllowBlankValue = True] TypeClient [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] NomClient [Level = Nominal] [AllowBlankValue = True] [Metadata = None] PrenomClient [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Numero Client [Level = Nominal] [Metadata = None] [AllowBlankValue = True] Contrat et Statut [Subject_ID_1 = Subject_ID_Client] [Subject_ID_2 = Subject_ID_Abonne] DateFinValidite [Level = Interval] [AllowBlankValue = True] [Metadata = None] PremiereDateActivation [Level = Interval] [AllowBlankValue = True] [Metadata = None] DerniereDateActivation [Level = Interval] [AllowBlankValue = True] [Metadata = None] TotalNombreLignes [Level = Interval] [AllowBlankValue = True] [Metadata = None] NombreLignesValide (actif et grace) [Level = Interval] [AllowBlankValue = True] [Metadata = None] Valeur Client [Subject_ID_1 = Subject_ID_Client] [Subject_ID_2 = Subject_ID_Abonne] Secteuractivite [Level = Nominal] [AllowBlankValue = True] [Metadata = None] SousSecteurActivite [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Chiffreaffaire [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nombreemploye [Level = Interval] [AllowBlankValue = True] [Metadata = None] NumeroClient [Level = Id] [UseInSubjectId = Subject_ID_Client] Arpu Client [Level = Interval] [Metadata = None] [AllowBlankValue = True] Code Charge Compte [Level = Nominal] [Metadata = None] [AllowBlankValue = True] Charge Compte [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] Contrat et Statut [Subject_ID_1 = Subject_ID_Client] [Subject_ID_2 = Subject_ID_Abonne] SVA [Subject_ID_1 = Subject_ID_Client] [Subject_ID_2 = Subject_ID_Abonne] NombreTotalDeServicesActives [Level = Interval] [Metadata = None] [AllowBlankValue = True] StatutServiceRoamingOui/non [Level = Nominal] [AllowBlankValue = True] [Metadata = None] ServiceRbtActif [Level = Nominal] [AllowBlankValue = True] [Metadata = None] ServiceInternetMobileActif [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Service Edition Detail Facture Actif [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Service My Tunisiana Actif [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Service Paiement Internet Actif [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Service Conférence Actif [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Service Voice Mail Actif [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Service Fax Actif [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Service Extra Time Montant Accordé [Level = Nominal] [AllowBlankValue = False] [Metadata = Values] Suivi Churn [Subject_ID_1 = Subject_ID_Client] [Subject_ID_2 = Subject_ID_Abonne] Nombre De Fois Entree En Preservation(depuis Activation) [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nombre De Jours De La Dernière Entrée En Préservation [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nombre De Jours De L Avant Dernière Entrée En Préservation [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nombre De Jours De L Avant Avant Dernière Entrée En Préservation Suivi D Une Réactivation [Level = Interval] [AllowBlankValue = True] [Metadata = None] DATE_ENTRE_PRES_DERN [Level = Interval] [Metadata = None] [AllowBlankValue = True] Date De L Avant Dernière Entrée En Préservation [Level = Interval] [AllowBlankValue = True] [Metadata = None] Date De L Avant Avant Dernière Entrée En Préservation [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nombre De Fois Entree En Grace (depuis Activation) [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nombre De Jours De La Dernière Entrée En Grace [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nombre De Jours De L Avant Dernière Entrée En Grace [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nombre De Jours De L Avant Avant Dernière Entrée En Grace [Level = Interval] [AllowBlankValue = True] [Metadata = None] Date Derniere Entree En Grace [Level = Interval] [Metadata = None] [AllowBlankValue = True] Date De L Avant Dernière Entrée En Grace [Level = Interval] [AllowBlankValue = True] [Metadata = None] Date De L Avant Avant Dernière Entrée En Grace [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nombre De Fois Entree En Churn (depuis Activation) [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nombre De Jours De La Dernière Entrée En Churn [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nombre De Jours De L Avant Dernière Entrée En Churn [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nombre De Jours De L Avant Avant Dernière Entrée En Churn [Level = Interval] [AllowBlankValue = True] [Metadata = None] Date De La Derniere Entree En Churn [Level = Interval] [AllowBlankValue = True] [Metadata = None] Date De L Avant Dernière Entrée En Churn [Level = Interval] [AllowBlankValue = True] [Metadata = None] Date De L Avant Avant Dernière Entrée En Churn [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nombre De Reactivation Grace (depuis Activation) [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nombre De Reactivation Preservation (depuis Activation) [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nombre De Reactivation Churn (depuis Activation) [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nombre De Jours De La Dernière Entrée En Grace Suivi D Une Réactivation [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nombre De Jours De L Avant Dernière Entrée En Grace Suivi D Une Réactivation [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nombre De Jours De L Avant Avant Dernière Entrée En Grace Suivi D Une Réactivation [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nombre De Jours Moyen En Grace Suivi D Une Réactivation [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nombre De Jours De La Dernière Entrée En Préservation Suivi D Une Réactivation [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nombre De Jours De L Avant Dernière Entrée En Préservation Suivi D Une Réactivation [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Nombre De Jours De L Avant Avant Dernière Entrée En Préservation Suivi D Une Réactivation1 [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nombre De Jours Moyen En Preservation Suivi D Une Réactivation [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nombre De Jours Moyen En Churn Suivi D Une Réactivation [Level = Interval] [AllowBlankValue = True] [Metadata = None] Lifetime [Level = Interval] [AllowBlankValue = True] [Metadata = None] CycleDeVie [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] Date cycle de vie [Level = Interval] [Metadata = None] [AllowBlankValue = True] DateActivationLigne [Level = Interval] [AllowBlankValue = True] [Metadata = None] DateMigrationOffreActuel [Level = Interval] [AllowBlankValue = True] [Metadata = None] Date De Suspension [Level = Interval] [AllowBlankValue = True] [Metadata = None] Date De Fin De Validite [Level = Interval] [Metadata = None] [AllowBlankValue = True] Raison De Suspension [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Raison De Deconnexion [Level = Nominal] [AllowBlankValue = True] [Metadata = None] OffreActuelle [Level = Nominal] [AllowBlankValue = True] [Metadata = None] LibelleOffreActuelle [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] CodeDuTypeOffre [Level = Nominal] [AllowBlankValue = True] [Metadata = None] LibelleTypeOffre [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] DateDernierContact [Level = Interval] [AllowBlankValue = True] [Metadata = None] Statut Dormant1 [Level = Nominal] [Metadata = None] [AllowBlankValue = True] Statut Dormant2 [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Statut Dormant3 [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Suspension Totale [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Type abonnement [Level = Nominal] [AllowBlankValue = True] [Metadata = None] StatutSilent [Level = Nominal] [AllowBlankValue = True] [Metadata = None] StatutSilentMoisPrecedent [Level = Nominal] [Metadata = None] [AllowBlankValue = True] StatutSilentMoisAvantPrecedent [Level = Nominal] [AllowBlankValue = True] [Metadata = None] IVRlanguePrefere [Level = Nominal] [AllowBlankValue = True] [Metadata = None] MsisdnSans216 [Level = Nominal] [Metadata = None] [AllowBlankValue = True] Co Id [Level = Nominal] [Metadata = None] [AllowBlankValue = True] Status de la ligne [Level = Nominal] [Metadata = None] [AllowBlankValue = False] Canal de Contact [Subject_ID_1 = Subject_ID_Client] [Subject_ID_2 = Subject_ID_Abonne] Preferences Contact [Subject_ID_1 = Subject_ID_Client] [Subject_ID_2 = Subject_ID_Abonne] Contacter Le Client Par Courier [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] Contacter Le Client Par Telephonne [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] Contacter Le Client Par Sms [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] Reponses Clients [Subject_ID_1 = Subject_ID_Client] [Subject_ID_2 = Subject_ID_Abonne] Nombre De Reponses Reçues Le Dernier Mois Suite Aux Campagnes De Marketing [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nombre De Reponses Reçues Le Dernier 3 Mois Suite Aux Campagnes De Marketing [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nombre De Reponses Reçues Le Dernier 6 Mois Suite Aux Campagnes De Marketing [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nbr Sms Bulk Recus Le Mois Dernier [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nbr Sms Bulk Reçus Les 6 Derneris Mois [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nbr Sms Bulk Reçus Les 3 Derneris Mois [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nbr De Contacts Call Center Le Dernier Mois [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nbr De Contacts Call Center Les 3 Derniers Mois [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nbr De Contacts Call Center Les 6 Derniers Mois [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nombre De Jours Depuis le DernierContact [Level = Interval] [Metadata = None] [AllowBlankValue = True] Données Terminal [Subject_ID_1 = Subject_ID_Client] [Subject_ID_2 = Subject_ID_Abonne] Identité Internationale Équipement Mobile(IMEI) [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Date de détéction de terminal [Level = Interval] [Metadata = None] [AllowBlankValue = False] Type de terminal détecté [Level = Nominal] [Metadata = Values] [AllowBlankValue = False] Terminal compatible Double Sim (Y/N) [Level = Nominal] [Metadata = Values] [AllowBlankValue = False] Terminal compatibe Edge (Y/N) [Level = Nominal] [Metadata = Values] [AllowBlankValue = False] Terminal compatibe Gprs (Y/N) [Level = Nominal] [Metadata = Values] [AllowBlankValue = False] Terminal compatibe Hsdpa (Y/N) [Level = Nominal] [Metadata = Values] [AllowBlankValue = False] Terminal compatible Hsupa (Y/N) [Level = Nominal] [Metadata = Values] [AllowBlankValue = False] Terminal compatible Java (Y/N) [Level = Nominal] [Metadata = Values] [AllowBlankValue = False] Modéle de terminal [Level = Nominal] [Metadata = Values] [AllowBlankValue = False] Systeme d'exploitation de terminal [Level = Nominal] [Metadata = Values] [AllowBlankValue = False] Smartphone (Y/N) [Level = Nominal] [Metadata = Values] [AllowBlankValue = False] Terminal compatible Umts (Y/N) [Level = Nominal] [Metadata = Values] [AllowBlankValue = False] Fabricant de terminal [Level = Nominal] [Metadata = Values] [AllowBlankValue = False] Suivi Offres [Subject_ID_1 = Subject_ID_Client] [Subject_ID_2 = Subject_ID_Abonne] OffreInitiale [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Derniere Offre [Level = Nominal] [Metadata = None] [AllowBlankValue = True] Date migration derniere Offre [Level = Interval] [Metadata = None] [AllowBlankValue = True] Migration [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] Offre N-1 [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Offre N-2 [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Offre N-3 [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Date Migration Offre N-1 [Level = Interval] [AllowBlankValue = True] [Metadata = None] Date Migration Offre N-2 [Level = Interval] [AllowBlankValue = True] [Metadata = None] Date Migration Offre N-3 [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nombre Total De Migration Depuis Activation [Level = Interval] [AllowBlankValue = True] [Metadata = None] Duree De Vie/ Offre N-1 [Level = Interval] [AllowBlankValue = True] [Metadata = None] Duree De Vie/ Offre N-2 [Level = Interval] [AllowBlankValue = True] [Metadata = None] Duree De Vie/ Offre N-3 [Level = Interval] [AllowBlankValue = True] [Metadata = None] Point de vente [Subject_ID_1 = Subject_ID_Client] [Subject_ID_2 = Subject_ID_Abonne] Code Type Point De Vente [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Libelle Point De Vente [Level = Nominal] [Metadata = Values] [AllowBlankValue = True] Code Type Secteur Du Point De Vente [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Libelle Secteur De Vente [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] Code Postale Du Point De Vente [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Rentabilité Client [Subject_ID_1 = Subject_ID_Client] [Subject_ID_2 = Subject_ID_Abonne] ARPU Du Dernier Mois [Level = Interval] [AllowBlankValue = True] [Metadata = None] Arpu Du Mois M-1 [Level = Interval] [AllowBlankValue = True] [Metadata = None] Arpu Du Mois M-2 [Level = Interval] [AllowBlankValue = True] [Metadata = None] Moyenne ARPU Des 6 Derniers Mois [Level = Interval] [AllowBlankValue = True] [Metadata = None] Revenu Total Du Dernier Mois [Level = Interval] [Metadata = None] [AllowBlankValue = True] Revenu Total Du Mois M-1 [Level = Interval] [AllowBlankValue = True] [Metadata = None] Revenu Total Du Mois M-2 [Level = Interval] [AllowBlankValue = True] [Metadata = None] Montant Incomming [Level = Interval] [AllowBlankValue = True] [Metadata = None] Montant Incommig Du Mois M-1 [Level = Interval] [AllowBlankValue = True] [Metadata = None] Montant Incommig Du Mois M-2 [Level = Interval] [AllowBlankValue = True] [Metadata = None] Montant Conso [Level = Interval] [AllowBlankValue = True] [Metadata = None] Montant Conso Du Mois M-1 [Level = Interval] [AllowBlankValue = True] [Metadata = None] Montant Conso Du Mois M-2 [Level = Interval] [AllowBlankValue = True] [Metadata = None] Moyenne ARPU Out Hors Bonus Des 6 Dérniers Mois [Level = Interval] [AllowBlankValue = True] [Metadata = None] Informations Contact [Subject_ID_1 = Subject_ID_Client] [Subject_ID_2 = Subject_ID_Abonne] Nom [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Prenom [Level = Nominal] [Metadata = None] [AllowBlankValue = True] Adresse 1 [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Adresse 2 [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Ville [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Pays [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Code Postale [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Titre [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Code De La Region [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Nom Du Departement [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Adresse Email [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Fax [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Telephone Du Domicile [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Telephone Mobile [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Suffixe [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Informations Prepaye (Recharges et Validites) [Subject_ID_1 = Subject_ID_Client] [Subject_ID_2 = Subject_ID_Abonne] PeriodePrePayed [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Date Fin De La Periode De Grace [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nbr De Jours Moyens Entre Les Recharges [Level = Interval] [AllowBlankValue = True] [Metadata = None] Date De Fin De Validite Du Credit [Level = Interval] [AllowBlankValue = True] [Metadata = None] Date De Fin De Validite Du Bonus Sur Recharge [Level = Interval] [AllowBlankValue = True] [Metadata = None] Type De La Derniere Recharge [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Methode De Recharge Preferee [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Montant De La Derniere Recharge [Level = Interval] [AllowBlankValue = True] [Metadata = None] Total Du Montant De Recharge Sur Les 6 Derniers Mois [Level = Interval] [AllowBlankValue = True] [Metadata = None] Total Du Nombre De Recharge Sur Les 6 Derniers Mois [Level = Interval] [AllowBlankValue = True] [Metadata = None] Informations Postpaye [Subject_ID_1 = Subject_ID_Client] [Subject_ID_2 = Subject_ID_Abonne] Periode [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Date De La Derniere Facture [Level = Interval] [AllowBlankValue = True] [Metadata = None] Montant Total De La Facture Du Dernier Mois [Level = Interval] [AllowBlankValue = True] [Metadata = None] Montant Total De La Facture Des 3 Derniers Mois [Level = Interval] [AllowBlankValue = True] [Metadata = None] Montant Total De La Facture Des 6 Derniers Mois [Level = Interval] [AllowBlankValue = True] [Metadata = None] Service [Subject_ID_1 = Subject_ID_Client] [Subject_ID_2 = Subject_ID_Abonne] Statut [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] NumeroService [Level = Nominal] [AllowBlankValue = True] [Metadata = None] LibelleService [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] ServicePayant [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Date Status Du Service [Level = Interval] [AllowBlankValue = True] [Metadata = None] Segment et Score [Subject_ID_1 = Subject_ID_Client] [Subject_ID_2 = Subject_ID_Abonne] Score Churn Du Mois [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] Score Churn Du Mois -1 [Level = Nominal] [Metadata = Values] [AllowBlankValue = True] Score Churn Du Mois -2 [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] Score Churn Du Mois -3 [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] Score Churn Du Mois -4 [Level = Nominal] [Metadata = None] [AllowBlankValue = True] Score Churn Du Mois -5 [Level = Nominal] [NoMetadata = True] [AllowBlankValue = True] Score Churn Du Mois -6 [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Score Churn Du Mois -7 [Level = Nominal] [Metadata = None] [AllowBlankValue = True] Score Churn Du Mois -8 [Level = Nominal] [Metadata = None] [AllowBlankValue = True] Score Churn Du Mois -9 [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Score Churn Du Mois -10 [Level = Nominal] [NoMetadata = True] [AllowBlankValue = True] Score Churn Du Mois -11 [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Segment Du Mois [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] Segment Du Mois -1 [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] Segment Du Mois -2 [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] Segment Du Mois -3 [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] Segment Du Mois -4 [Level = Nominal] [Metadata = None] [AllowBlankValue = True] Segment Du Mois -5 [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Segment Du Mois -6 [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Segment Du Mois -7 [Level = Nominal] [Metadata = None] [AllowBlankValue = True] Segment Du Mois -8 [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Segment Du Mois -9 [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Segment Du Mois -10 [Level = Nominal] [AllowBlankValue = True] [NoMetadata = True] Segment Du Mois -11 [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Score Dual Sim Du Mois [Level = Nominal] [Metadata = Values] [AllowBlankValue = True] Score Dual Sim Du Mois -1 [Level = Nominal] [Metadata = Values] [AllowBlankValue = True] Detail Segment Du Mois [Level = Nominal] [Metadata = Values] [AllowBlankValue = True] Detail Segment Du Mois -1 [Level = Nominal] [Metadata = Values] [AllowBlankValue = True] Detail Segment Du Mois -2 [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] Segment Postpaye Residentiel Unified Du Mois [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] Segment Postpaye Residentiel Unified Du Mois -1 [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] Segment Postpaye Residentiel Unified Du Mois -2 [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] Bonus [Subject_ID_1 = Subject_ID_Client] [Subject_ID_2 = Subject_ID_Abonne] Bonus Sur Recharge Consommé Du Mois M-2 [Level = Interval] [AllowBlankValue = True] [Metadata = None] Montant Du Bonus Sur Consommation Utilisé Du Mois M-2 [Level = Interval] [AllowBlankValue = True] [Metadata = None] Bonus Sur Recharge Consommé Du Mois M-1 [Level = Interval] [AllowBlankValue = True] [Metadata = None] Montant Du Bonus Sur Consommation Utilisé Du Mois M-1 [Level = Interval] [AllowBlankValue = True] [Metadata = None] Montant Du Bonus Sur Consommation Utilisé [Level = Interval] [AllowBlankValue = True] [Metadata = None] Bonus Sur Recharge Consommé [Level = Interval] [AllowBlankValue = True] [Metadata = None] Recharges [Subject_ID_1 = Subject_ID_Client] [Subject_ID_2 = Subject_ID_Abonne] Montant First Recharge Sup5 [Level = Interval] [AllowBlankValue = True] [Metadata = None] Date First Recharge Sup5 [Level = Interval] [AllowBlankValue = True] [Metadata = None] Montant First Recharge [Level = Interval] [AllowBlankValue = True] [Metadata = None] Date First Recharge [Level = Interval] [AllowBlankValue = True] [Metadata = None] Chargement [Subject_ID_1 = Subject_ID_Client] [Subject_ID_2 = Subject_ID_Abonne] Client [Subject_ID_1 = Subject_ID_Client] [Subject_ID_2 = Subject_ID_Abonne] Code Campagne [Level = Nominal] [Metadata = None] [AllowBlankValue = True] Date Chargement [Level = Interval] [Metadata = None] [AllowBlankValue = True] Nom Campagne [Level = Nominal] [Metadata = None] [AllowBlankValue = True] Numero Client [Level = Nominal] [Metadata = None] [AllowBlankValue = True] Cibles RC [Subject_ID_1 = Subject_ID_Client] [Subject_ID_2 = Subject_ID_Abonne] Code Produit [Level = Nominal] [AllowBlankValue = False] [Metadata = None] Code Audience [Level = Nominal] [AllowBlankValue = False] [Metadata = None] Code Campagne [Level = Nominal] [Metadata = None] [AllowBlankValue = True] Nom Campagne [Level = Nominal] [Metadata = None] [AllowBlankValue = True] Date Chargement [Level = Interval] [Metadata = None] [AllowBlankValue = True] FANDF [Subject_ID_1 = Subject_ID_Client] [Subject_ID_2 = Subject_ID_Abonne] Souscription Freindsfamily 0/1 [Level = Nominal] [Metadata = Values] [AllowBlankValue = True] Dur Minutes Friends Family [Level = Interval] [Metadata = None] [AllowBlankValue = True] Nbr Souscriptions Freindsfamily [Level = Interval] [Metadata = None] [AllowBlankValue = True] Cellule [Subject_ID_1 = Subject_ID_Client] [Subject_ID_2 = Subject_ID_Abonne] Cell Id [Level = Nominal] [Metadata = None] [AllowBlankValue = True] Delegation [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] Gouvernorat [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] MSC [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] Reverse Belling [Subject_ID_1 = Subject_ID_Client] [Subject_ID_2 = Subject_ID_Abonne] Date Inscr Rb [Level = Interval] [Metadata = None] [AllowBlankValue = True] Nbr Rb Actif [Level = Interval] [Metadata = None] [AllowBlankValue = True] Link Analytics [Subject_ID_1 = Subject_ID_Abonne] [Subject_ID_2 = Subject_ID_Client] SNA Role [Subject_ID_1 = Subject_ID_Abonne] [Subject_ID_2 = Subject_ID_Client] Mois [Level = Nominal] [Metadata = Values] [AllowBlankValue = False] Periode [Level = Nominal] [Metadata = None] [AllowBlankValue = False] SNA Role [Level = Nominal] [Metadata = Values] [AllowBlankValue = False] Flag Dual [Level = Nominal] [Metadata = Values] [AllowBlankValue = False] Derniere Recharge Montant De La Dernière Recharge [Level = Interval] [Metadata = None] [AllowBlankValue = False] Date De La Dernière Recharge [Level = Interval] [Metadata = None] [AllowBlankValue = False] Type De La Dernière Recharge [Level = Nominal] [Metadata = Values] [AllowBlankValue = False] Nombre De Jours Depuis La Derniere Recharge [Level = Nominal] [Metadata = None] [AllowBlankValue = False] Nb Jour Inactiv : Pas Emis [Level = Interval] [Metadata = None] [AllowBlankValue = True] Nb Jour Inactiv : Pas Recu [Level = Interval] [Metadata = None] [AllowBlankValue = True] Nombre De Jours D'inactivité Data [Level = Interval] [Metadata = None] [AllowBlankValue = True] Nombre De Jours D'inactivité Sortant Voix Sms Et Data [Level = Interval] [Metadata = None] [AllowBlankValue = True] Flag Entre Grace (Y / N) [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] MsisdnSujet [Level = Id] [UseInSubjectId = Subject_ID_Abonne] CodeSegmentActuel [Level = Interval] [AllowBlankValue = True] [Metadata = Values] LibelleSegmentActuel [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] PeviuosCodeSegment [Level = Nominal] [AllowBlankValue = True] [Metadata = None] PreviousLibelleSegment [Level = Nominal] [AllowBlankValue = True] [Metadata = None] DateActivation [Level = Id] [UseInSubjectId = Subject_ID_Abonne] MsisdnExport [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Type Client [Level = Nominal] [Metadata = Values] [AllowBlankValue = True] Profil Gold [Level = Nominal] [Metadata = Values] [AllowBlankValue = True] Expiry Date [Level = Interval] [Metadata = None] [AllowBlankValue = True] Date Dernier Appel Emis [Level = Interval] [Metadata = None] [AllowBlankValue = True] Date Dernier Appel Recu [Level = Interval] [Metadata = None] [AllowBlankValue = True] MSISDN_No_INDIC [Level = Nominal] [AllowBlankValue = False] [Metadata = None] CRM [Subject_ID_1 = Subject_ID_Abonne] [Subject_ID_2 = Subject_ID_Case] Enquette [Subject_ID_1 = Subject_ID_Client] [Subject_ID_2 = Subject_ID_Abonne] QuestionId [Level = Nominal] [Metadata = None] [AllowBlankValue = True] CodeAudience [Level = Nominal] [AllowBlankValue = True] [Metadata = None] AnswerId [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Texte De La Reponse [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Texte De La Question [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Description Enquete [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Date Enquete [Level = Interval] [AllowBlankValue = True] [Metadata = None] NomEnquete [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Cas [Subject_ID_1 = Subject_ID_Client] [Subject_ID_2 = Subject_ID_Abonne] [Subject_ID_3 = Subject_ID_Case] Identifiant Evenement [Level = Id] [UseInSubjectId = Subject_ID_Case] Categorie [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] Type Specialite [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] CodeTypeevenement [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] DateEvenement [Level = Interval] [AllowBlankValue = True] [Metadata = None] Derniere Date MAJ Evenement [Level = Interval] [AllowBlankValue = True] [Metadata = None] Texte Evenement [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Revenue Evenement [Level = Interval] [AllowBlankValue = True] [Metadata = None] Statut Evenement [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] Date Expiration Evenement [Level = Interval] [AllowBlankValue = True] [Metadata = None] Date De Cloture Evenement [Level = Interval] [AllowBlankValue = True] [Metadata = None] Detail Category [Level = Nominal] [Metadata = Values] [AllowBlankValue = True] Groupe Prestataire [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Id Conseiller Createur [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Matricule Conseiller [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Nom Conseiller Createur [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] Libelle Site Createur [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] Appel Sortant [Subject_ID_1 = Subject_ID_Client] [Subject_ID_2 = Subject_ID_Abonne] Periode AS [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Id Campagne [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Id Audience [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Date Creation [Level = Interval] [AllowBlankValue = True] [Metadata = None] Date Contact [Level = Interval] [AllowBlankValue = True] [Metadata = None] Id Decision Utilisateur [Level = Nominal] [Metadata = None] [AllowBlankValue = True] Decision Utilisateur [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] Id Resultat Appel [Level = Nominal] [Metadata = None] [AllowBlankValue = True] Id Type Decision [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] Motif [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] Id Motif [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Nom Client [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Prenom Client [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Resultat Appel [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] Type Decision [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] LP [Subject_ID_1 = Subject_ID_Client] [Subject_ID_2 = Subject_ID_Abonne] Periode [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Mois [Level = Nominal] [Metadata = Values] [AllowBlankValue = True] Nature Du Programme LP (Business - Residential) [Level = Nominal] [AllowBlankValue = False] [Metadata = Values] Flag Responsable Du Compte LP (Y / N) [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] Statut LP Inscrit (I) Non Inscrit (Vide) [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] Dernière Date Inscription Lp [Level = Interval] [AllowBlankValue = True] [Metadata = None] Solde Point Lp [Level = Interval] [AllowBlankValue = True] [Metadata = None] Points Accordes Grace Aux Recharges [Level = Interval] [AllowBlankValue = True] [Metadata = None] Points Accordes Grace A L Incomming [Level = Interval] [AllowBlankValue = True] [Metadata = None] Points Accordes Suite Atteinte Palier [Level = Interval] [AllowBlankValue = True] [Metadata = None] Autre Bonus Accordes [Level = Interval] [AllowBlankValue = True] [Metadata = None] Points Accordes Suite Payement Facture [Level = Interval] [AllowBlankValue = True] [Metadata = None] Points Transformes En Handset [Level = Interval] [AllowBlankValue = True] [Metadata = None] Point Transformes En Voix Et Sms [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nombre De Transformation Handset [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nombre De Transformations En Voix Et Sms [Level = Interval] [AllowBlankValue = True] [Metadata = None] Date Derniere Transformation En Voix [Level = Interval] [AllowBlankValue = True] [Metadata = None] Date Derniere-2 Transformation En Voix [Level = Interval] [AllowBlankValue = True] [Metadata = None] Date Derniere-3 Transformation En Voix [Level = Interval] [AllowBlankValue = True] [Metadata = None] Date Derniere-4 Transformation En Voix [Level = Interval] [AllowBlankValue = True] [Metadata = None] Points Transformes Lors De La Derniere Transformation En Voix [Level = Interval] [AllowBlankValue = True] [Metadata = None] Points Transformes Lors De La Derniere-2 Transformation En Voix [Level = Interval] [AllowBlankValue = True] [Metadata = None] Points Transformes Lors De La Derniere-3 Transformation En Voix [Level = Interval] [AllowBlankValue = True] [Metadata = None] Points Transformes Lors De La Derniere-4 Transformation En Voix [Level = Interval] [AllowBlankValue = True] [Metadata = None] Date Derniere Transformation En Handset [Level = Interval] [AllowBlankValue = True] [Metadata = None] Points Transformes Lors De La Derniere Transformation En Handset [Level = Interval] [AllowBlankValue = True] [Metadata = None] Description Handset Lors De La Derniere Transformation [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] LP Journalier [Subject_ID_1 = Subject_ID_Client] [Subject_ID_2 = Subject_ID_Abonne] Nature Du Programme LP (Business - Residential) [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] Flag Responsable Du Compte LP (Y / N) [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Nature Offre Commerciale (PRE - POST - MIXT (c&c)) [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] Statut Lp Inscrit Ou Désinscrit (I / D) [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] Date Derniere Souscription Lp [Level = Interval] [AllowBlankValue = True] [Metadata = None] Date Derniere Desinscription [Level = Interval] [AllowBlankValue = True] [Metadata = None] Solde Point Lp [Level = Interval] [AllowBlankValue = True] [Metadata = None] Flag (y / N) Effectue Au Moins Une Transformation [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] Usage [Subject_ID_1 = Subject_ID_Client] [Subject_ID_2 = Subject_ID_Abonne] DATA [Subject_ID_1 = Subject_ID_Client] [Subject_ID_2 = Subject_ID_Abonne] Revenu Des Usages Data [Level = Interval] [AllowBlankValue = True] [Metadata = None] Revenu Des Usages Data Les 2 Derniers Mois [Level = Interval] [AllowBlankValue = True] [Metadata = None] Revenu Des Usages Data Les 3 Derniers Mois [Level = Interval] [AllowBlankValue = True] [Metadata = None] Revenu Des Usages Data Les 6 Derniers Mois [Level = Interval] [AllowBlankValue = True] [Metadata = None] MMS [Subject_ID_1 = Subject_ID_Client] [Subject_ID_2 = Subject_ID_Abonne] Nbr Mms Sortant [Level = Interval] [AllowBlankValue = True] [Metadata = None] Revenu Des Mms [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nbr De Mms Sortant Sur Les 2 Derniers Mois [Level = Interval] [AllowBlankValue = True] [Metadata = None] Revenu Des Mms Sur Les 2 Derniers Mois [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nbr de Mms Sortant Sur Les 3 Derniers Mois [Level = Interval] [AllowBlankValue = True] [Metadata = None] Revenu Des Mms Sur Les 3 Derniers Mois [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nbr D'Mms Sortant Sur Les 6 Derniers Mois [Level = Interval] [AllowBlankValue = True] [Metadata = None] Revenu Des MMS Les 6 Derniers Mois [Level = Interval] [AllowBlankValue = True] [Metadata = None] Revenu Des Mms Sortants En Periode De Peak [Level = Interval] [AllowBlankValue = True] [Metadata = None] Revenu Des Mms Sortants En Periode Off Peak [Level = Interval] [AllowBlankValue = True] [Metadata = None] SMS [Subject_ID_1 = Subject_ID_Client] [Subject_ID_2 = Subject_ID_Abonne] Nbr De Sms Sortant [Level = Interval] [AllowBlankValue = True] [Metadata = None] Revenu Des Sms Sortants [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nbr De Sms Sortant Sur Les 2 Derniers Mois [Level = Interval] [AllowBlankValue = True] [Metadata = None] Revenu Des Sms Sur Les 2 Derniers Mois [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nbr De Sms Sortant Sur Les 3 Derniers Mois [Level = Interval] [AllowBlankValue = True] [Metadata = None] Revenu Des Sms Sur Les 3 Derniers Mois [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nbr De Sms Sortant Sur Les 6 Derniers Mois [Level = Interval] [AllowBlankValue = True] [Metadata = None] Revenu Des Sms Sur Les 6 Derniers Mois [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nbr de Sms Sortant Vers Ott En Periode Peak [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nbr de Sms Sortant Vers Tt En Periode Peak [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nbr de Sms Sortant Vers International En Periode Peak [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nbr de Sms Sortant Vers Autres Destination En Periode Peak [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nbr de Sms Sortant Vers Ott En Periode Offpeak [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nbr de Sms Sortant Vers Tt En Periode Offpeak [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nbr de Sms Sortant Vers International En Periode Offpeak [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nbr de Sms Sortant Vers Autres Destination En Periode Offpeak [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nbr Des Sms Entrant En Periode Peak [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nbr Des Sms Entrant En Periode Offpeak [Level = Interval] [AllowBlankValue = True] [Metadata = None] Revenu Des Sms Entrants Peak [Level = Interval] [AllowBlankValue = True] [Metadata = None] Revenu Des Sms Entrants Offpeak [Level = Interval] [Metadata = None] [AllowBlankValue = True] Revenu Des Sms Sortants Vers Ott En Periode Peak [Level = Interval] [AllowBlankValue = True] [Metadata = None] Revenu Des Sms Sortants Vers Ott En Période Offpeak [Level = Interval] [Metadata = None] [AllowBlankValue = True] Voice [Subject_ID_1 = Subject_ID_Client] [Subject_ID_2 = Subject_ID_Abonne] In going Call [Subject_ID_1 = Subject_ID_Client] [Subject_ID_2 = Subject_ID_Abonne] Revenu Des Appels Entrants Voix En Provenance De Ott En Periode Peak [Level = Interval] [AllowBlankValue = True] [Metadata = None] Revenu Des Appels Entrants Voix En Provenance De Tt En Periode Peak [Level = Interval] [AllowBlankValue = True] [Metadata = None] Revenu Des Appels Entrants Voix En Provenance Du Fixe En Periode Peak [Level = Interval] [AllowBlankValue = True] [Metadata = None] Revenu Des Appels Entrants Voix En Provenance De L'International En Periode Peak [Level = Interval] [AllowBlankValue = True] [Metadata = None] Revenu Des Appels Entrants Voix En Provenance Des Autres Destinations En Periode Peak [Level = Interval] [AllowBlankValue = True] [NoMetadata = True] Revenu Des Appels Entrants Voix En Provenance De Ott En Periode Offpeak [Level = Interval] [AllowBlankValue = True] [Metadata = None] Revenu Des Appels Entrants Voix En Provenance De Tt En Periode Offpeak [Level = Interval] [AllowBlankValue = True] [Metadata = None] Revenu Des Appels Entrants Voix En Provenance Du Fixe En Periode Offpeak [Level = Interval] [AllowBlankValue = True] [Metadata = None] Revenu Des Appels Entrants Voix En Provenance De L'International En Periode Offpeak [Level = Interval] [AllowBlankValue = True] [Metadata = None] Revenu Des Appels Entrants Voix En Provenance Des Autres Destinations En Periode Offpeak [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nombre Des Appels Entrant En Periode Peak [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nombre Des Appels Entrant En Periode Offpeak [Level = Interval] [AllowBlankValue = True] [Metadata = None] Out going Call [Subject_ID_1 = Subject_ID_Client] [Subject_ID_2 = Subject_ID_Abonne] Nbr D'Appels Sortant Sur Le Dernier Mois [Level = Interval] [AllowBlankValue = True] [Metadata = None] Duree Des Appels Sortants Voix [Level = Interval] [AllowBlankValue = True] [Metadata = None] Revenu Des Appels Sortants Voix [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nbr Appels Sortant Sur Les 2 Derniers Mois [Level = Interval] [AllowBlankValue = True] [Metadata = None] Duree Des Appels Sortants Voix Sur Les 2 Derniers Mois [Level = Interval] [AllowBlankValue = True] [Metadata = None] Revenu Des Appels Sur Les 2 Derniers Mois [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nbr D'Appels Sortant Sur Les 3 Derniers Mois [Level = Interval] [AllowBlankValue = True] [Metadata = None] Duree Des Appels Sortants Voix Sur Les 3 Derniers Mois [Level = Interval] [AllowBlankValue = True] [Metadata = None] Revenu Des Appels Sur Les 3 Derniers Mois [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nbr D'Appels Sortant Sur Les 6 Derniers Mois [Level = Interval] [AllowBlankValue = True] [Metadata = None] Duree Des Appels Sortants Voix Sur Les 6 Derniers Mois [Level = Interval] [AllowBlankValue = True] [Metadata = None] Revenu Des Appels Sur Les 6 Derniers Mois [Level = Interval] [AllowBlankValue = True] [Metadata = None] Revenu Des Appels Sortants Voix Vers Ott En Periode Peak [Level = Interval] [AllowBlankValue = True] [Metadata = None] Revenu Des Appels Sortants Voix Vers Tt En Periode Peak [Level = Interval] [AllowBlankValue = True] [Metadata = None] Revenu Des Appels Sortants Voix Vers International En Periode Peak [Level = Interval] [AllowBlankValue = True] [Metadata = None] Revenu Des Appels Sortants Voix Vers Autres Destination En Periode Peak [Level = Interval] [AllowBlankValue = True] [Metadata = None] Revenu Des Appels Sortants Voix Vers Ott En Periode Offpeak [Level = Interval] [AllowBlankValue = True] [Metadata = None] Revenu Des Appels Sortants Voix Vers Tt En Periode Offpeak [Level = Interval] [AllowBlankValue = True] [Metadata = None] Revenu Des Appels Sortants Voix Vers International En Periode Offpeak [Level = Interval] [AllowBlankValue = True] [Metadata = None] Revenu Des Appels Sortants Voix Vers Autres Destination En Periode Offpeak [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nbr D'Appel Sortant Voix Vers Ott En Periode Peak [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nbr D'Appel Sortant Voix Vers Tt En Periode Peak [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nbr D'Appel Sortant Voix Vers Fixe En Periode Peak [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nbr D'Appel Sortant Voix Vers International En Periode Peak [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nbr D'Appel Sortant Voix Vers Autres Destination En Periode Peak [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nbr D'Appel Sortant Voix Vers Ott En Periode Offpeak [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nbr D'Appel Sortant Voix Vers Tt En Periode Offpeak [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nbr D'Appel Sortant Voix Vers Fixe En Periode Offpeak [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nbr D'Appel Sortant Voix Vers International En Periode Offpeak [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nbr D'Appel Sortant Voix Vers Autres Destination En Periode Offpeak [Level = Interval] [AllowBlankValue = True] [Metadata = None] Revenu Des Sms Sortants Vers Ott En Periode Peak [Level = Interval] [AllowBlankValue = True] [Metadata = None] Revenu Des Sms Sortants Vers Tt En Periode Peak [Level = Interval] [AllowBlankValue = True] [Metadata = None] Revenu Des Sms Sortants Vers International En Periode Peak [Level = Interval] [AllowBlankValue = True] [Metadata = None] Revenu Des Sms Sortants Vers Autres Destination En Periode Peak [Level = Interval] [AllowBlankValue = True] [Metadata = None] Revenu Des Sms Sortants vers Ott En Periode Offpeak [Level = Interval] [AllowBlankValue = True] [Metadata = None] Revenu Des Sms Sortants Vers International En Periode Offpeak [Level = Interval] [AllowBlankValue = True] [Metadata = None] Revenu Des Sms Sortants Vers Tt En Periode Offpeak [Level = Interval] [AllowBlankValue = True] [Metadata = None] Revenu Des Sms Sortants Vers Autres Destination En Periode Offpeak [Level = Interval] [AllowBlankValue = True] [Metadata = None] Dur Appel Sort Voix Vers Ott [Level = Interval] [Metadata = None] [AllowBlankValue = True] Dur Appel Sort Voix Vers Ott 3 Derniers Mois [Level = Interval] [Metadata = None] [AllowBlankValue = True] Dur Appel Sort Voix Vers International [Level = Interval] [Metadata = None] [AllowBlankValue = True] Dur Appel Sort Voix Vers International 3 Derniers Mois [Level = Interval] [Metadata = None] [AllowBlankValue = True] Dur Appel Sort Voix Vers Tt [Level = Interval] [Metadata = None] [AllowBlankValue = True] Dur Appel Sort Voix Vers Tt 3 Derniers Mois [Level = Interval] [NoMetadata = True] [AllowBlankValue = True] Dur Appel Sort Voix Vers Fixe [Level = Interval] [Metadata = None] [AllowBlankValue = True] Dur Appel Sort Voix Vers Fixe 3 Derniers Mois [Level = Interval] [Metadata = None] [AllowBlankValue = True] Dur Appel Sort Voix Vers Autres Destination [Level = Interval] [Metadata = None] [AllowBlankValue = True] Dur Appel Sort Voix Vers Autres Destination 3 Derniers Mois [Level = Interval] [Metadata = None] [AllowBlankValue = True] Dur Appel Ent Voix De Ott [Level = Interval] [Metadata = None] [AllowBlankValue = True] Dur Appel Ent Voix De Ott 3 Derniers Mois [Level = Interval] [AllowBlankValue = True] [Metadata = None] Dur Appel Ent Voix De L'international [Level = Interval] [AllowBlankValue = True] [Metadata = None] Dur Appel Ent Voix De L'international 3 Derniers Mois [Level = Interval] [Metadata = None] [AllowBlankValue = True] Dur Appel Ent Voix De Tt [Level = Interval] [Metadata = None] [AllowBlankValue = True] Dur Appel Ent Voix De Tt 3 Derniers Mois [Level = Interval] [AllowBlankValue = True] [Metadata = None] Dur Appel Ent Voix Du Fixe 3 Derniers Mois [Level = Interval] [AllowBlankValue = True] [Metadata = None] Dur Appel Ent Voix Du Fixe 6 Derniers Mois [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Dur Appel Ent Voix De Autres Destination [Level = Interval] [AllowBlankValue = True] [Metadata = None] Dur Appel Ent Voix De Autres Destination 3 Derniers Mois [Level = Interval] [Metadata = None] [AllowBlankValue = True] Roaming [Subject_ID_1 = Subject_ID_Client] [Subject_ID_2 = Subject_ID_Abonne] Revenu Des Appels Sortants Voix En Roaming Vers La Tunisie [Level = Interval] [AllowBlankValue = True] [Metadata = None] Revenu Des Appels Entrants Voix En Roaming En Provenance La Tunisie [Level = Interval] [AllowBlankValue = True] [Metadata = None] Revenu Des Sms Sortants En Roaming Vers La Tunisie [Level = Interval] [AllowBlankValue = True] [Metadata = None] Revenu Des Sms Entrants En Roaming En Provenance La Tunisie [Level = Interval] [AllowBlankValue = True] [Metadata = None] Revenu Des Mms Sortants En Roaming Vers La Tunisie [Level = Interval] [AllowBlankValue = True] [Metadata = None] Revenu Des Usages En Roaming [Level = Interval] [AllowBlankValue = True] [Metadata = None] Revenu Des Sms Sortants En Roaming [Level = Interval] [AllowBlankValue = True] [Metadata = None] Revenu Des Mms Sortants En Roaming [Level = Interval] [AllowBlankValue = True] [Metadata = None] Recharge [Subject_ID_1 = Subject_ID_Client] [Subject_ID_2 = Subject_ID_Abonne] Montant Total De Recharge [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nbr Total De Recharge [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nbr De Recharge De 1 Dinars [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nbr De Recharge De 2 Dinars [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nbr De Recharge De 3 Dinars [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nbr De Recharge De 4 Dinars [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nbr De Recharge De 5 Dinars [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nbr De Recharge De 6 A 9 Dinars [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nbr De Recharge De 10 Dinars [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nbr De Recharge De 11 À 24 Dinars [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nbr De Recharge De 25 Dinars [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nbr De Recharge De 26 A 49 Dinars [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nbr De Recharge De 50 Dinars [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nbr De Recharge De Plus De 50 Dinars [Level = Interval] [AllowBlankValue = True] [Metadata = None] Montant Recharge Pour Reactivation [Level = Interval] [AllowBlankValue = True] [Metadata = None] Montant Du Bonus Recharge Utilise [Level = Interval] [AllowBlankValue = True] [Metadata = None] Montant Du Bonus Recharge Accorde [Level = Interval] [AllowBlankValue = True] [Metadata = None] Montant Total Des Recharges Ussd [Level = Interval] [Metadata = None] [AllowBlankValue = True] Montant Total Des Recharges Evoucher [Level = Interval] [AllowBlankValue = True] [Metadata = None] Montant Total Des Recharges Scrach Card [Level = Interval] [AllowBlankValue = True] [Metadata = None] Montant Total Des Recharges DAB [Level = Interval] [AllowBlankValue = True] [Metadata = None] Montant Total Des Recharges Tre [Level = Interval] [Metadata = None] [AllowBlankValue = True] Montant Total Des Recharges Postpre [Level = Interval] [Metadata = None] [AllowBlankValue = True] Montant Total Des Recharges Other [Level = Interval] [Metadata = None] [AllowBlankValue = True] Montant Total Des Recharges Franchise [Level = Interval] [Metadata = None] [AllowBlankValue = True] Montant Total Des Recharges Cds [Level = Interval] [AllowBlankValue = True] [Metadata = None] Amigos [Subject_ID_1 = Subject_ID_Client] [Subject_ID_2 = Subject_ID_Abonne] Revenu Service Etudiant [Level = Interval] [AllowBlankValue = True] [Metadata = None] Revenu Amigos 2 Dernier Mois [Level = Interval] [Metadata = None] [AllowBlankValue = True] Revenu Amigos 3 Dernier Mois [Level = Interval] [Metadata = None] [AllowBlankValue = True] Revenu Inscription Amigos [Level = Interval] [Metadata = None] [AllowBlankValue = True] Revenu Inscri Amigos 2 Dernier Mois [Level = Interval] [Metadata = None] [AllowBlankValue = True] Revenu Inscri Amigos 3 Dernier Mois [Level = Interval] [Metadata = None] [AllowBlankValue = True] Duree Amigos [Level = Interval] [Metadata = None] [AllowBlankValue = True] Duree Amigos 2 Dernier Mois [Level = Interval] [Metadata = None] [AllowBlankValue = True] Duree Amigos 3 Dernier Mois [Level = Interval] [AllowBlankValue = True] [Metadata = None] SMS Voice a7kili [Subject_ID_1 = Subject_ID_Client] [Subject_ID_2 = Subject_ID_Abonne] Revenu Des Sms Voice [Level = Interval] [AllowBlankValue = True] [Metadata = None] Revenu Des Sms Voice 2 Dernier Mois [Level = Interval] [AllowBlankValue = True] [Metadata = None] Revenu Des Sms Voice 3 Dernier Mois [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nbr D'sms Voice Sortant [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nbr Sms Voice 2 Dernier Mois [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nbr Sms Voice 3 Dernier Mois [Level = Interval] [Metadata = None] [AllowBlankValue = True] Samma3ni [Subject_ID_1 = Subject_ID_Client] [Subject_ID_2 = Subject_ID_Abonne] Revenu Du Service Rbt [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Rev Rbt Inscrip [Level = Interval] [AllowBlankValue = True] [Metadata = None] Rev Rbt Ivr [Level = Interval] [Metadata = None] [AllowBlankValue = True] Rev Rbt So [Level = Interval] [Metadata = None] [AllowBlankValue = True] WAP [Subject_ID_1 = Subject_ID_Client] [Subject_ID_2 = Subject_ID_Abonne] Revenu Forfait Wap [Level = Interval] [Metadata = None] [AllowBlankValue = True] Revenu Telechargement Wap [Level = Interval] [Metadata = None] [AllowBlankValue = True] Revenu Total Wap [Level = Interval] [Metadata = None] [AllowBlankValue = True] Periode [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Mois [Level = Nominal] [Metadata = Values] [AllowBlankValue = True] Revenu Total Des Usages Subscriber [Level = Interval] [AllowBlankValue = True] [Metadata = None] Revenu Total Des Usages Customer [Level = Interval] [AllowBlankValue = True] [Metadata = None] Revenu Des Usages En Roaming [Level = Interval] [AllowBlankValue = True] [Metadata = None] Revenu De Usage Internet Mobile [Level = Interval] [AllowBlankValue = True] [Metadata = None] Revenu De Usage Push Mail [Level = Interval] [AllowBlankValue = True] [Metadata = None] Revenu Des Usages Fax [Level = Interval] [AllowBlankValue = True] [Metadata = None] Montant Des Transferts Émis [Level = Interval] [AllowBlankValue = True] [Metadata = None] Montant Des Transferts Recus [Level = Interval] [AllowBlankValue = True] [Metadata = None] Nombre Transfert recu [Level = Interval] [Metadata = None] [AllowBlankValue = True] Nombre Transfert Emis [Level = Interval] [Metadata = None] [AllowBlankValue = True] Transfer Out Flg [Level = Nominal] [Metadata = Values] [AllowBlankValue = True] Transfer In Flg [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] Durée Des Usages Ivr [Level = Interval] [AllowBlankValue = True] [Metadata = None] Contactes Entreprise [Subject_ID_1 = Subject_ID_Client] [Subject_ID_2 = Subject_ID_Abonne] Custcode_reduit [Level = Nominal] [Metadata = None] [AllowBlankValue = True] Type Contacte [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] Rel Type Id [Level = Nominal] [Metadata = None] [AllowBlankValue = True] Telephone entreprise [Level = Nominal] [NoMetadata = True] [Metadata = None] Num Telephone export [Level = Nominal] [Metadata = None] [AllowBlankValue = True] Activites Journalieres [Subject_ID_1 = Subject_ID_Client] [Subject_ID_2 = Subject_ID_Abonne] Tickets Appels [Subject_ID_1 = Subject_ID_Client] [Subject_ID_2 = Subject_ID_Abonne] Code Destination [Level = Nominal] [Metadata = None] [AllowBlankValue = True] Libelle Destination [Level = Nominal] [Metadata = Values] [AllowBlankValue = True] Libelle Destination Principale [Level = Nominal] [Metadata = Values] [AllowBlankValue = True] Libelle Type Destination [Level = Nominal] [Metadata = Values] [AllowBlankValue = True] Libelle Type Appel [Level = Nominal] [Metadata = Values] [AllowBlankValue = True] Date Appel [Level = Interval] [Metadata = None] [AllowBlankValue = True] Duree Des Appels [Level = Interval] [Metadata = None] [AllowBlankValue = True] Duree Appels Facturee [Level = Interval] [Metadata = None] [AllowBlankValue = True] Nombre Appels [Level = Interval] [Metadata = None] [AllowBlankValue = True] Revenu Appels [Level = Interval] [Metadata = None] [AllowBlankValue = True] Montant Facture [Level = Interval] [Metadata = None] [AllowBlankValue = True] Montant Sur Bonus [Level = Interval] [Metadata = None] [AllowBlankValue = True] Prix Unitaire [Level = Interval] [Metadata = None] [AllowBlankValue = True] Appel Gratuits [Level = Nominal] [Metadata = None] [AllowBlankValue = True] Pays Réseau Opérateur [Level = Nominal] [Metadata = Values] [AllowBlankValue = False] Code Réseau Opérateur [Level = Nominal] [Metadata = None] [AllowBlankValue = False] Nom Réseau Opérateur [Level = Nominal] [Metadata = Values] [AllowBlankValue = False] Forfaits Internet et Packs [Subject_ID_1 = Subject_ID_Client] [Subject_ID_2 = Subject_ID_Abonne] Forfait Ou Pack [Level = Nominal] [Metadata = Values] [AllowBlankValue = False] Pack ou Forfait Id [Level = Nominal] [Metadata = None] [AllowBlankValue = True] Libelle Forfait ou Pack [Level = Nominal] [Metadata = Values] [AllowBlankValue = True] Date Achat [Level = Interval] [Metadata = None] [AllowBlankValue = True] Date Accisition [Level = Interval] [Metadata = None] [AllowBlankValue = True] Status Forfait Internet [Level = Nominal] [Metadata = None] [AllowBlankValue = True] Nombre De Pack ou Forfait [Level = Interval] [Metadata = None] [AllowBlankValue = True] Migrations [Subject_ID_1 = Subject_ID_Client] [Subject_ID_2 = Subject_ID_Abonne] Date Migration [Level = Interval] [Metadata = None] [AllowBlankValue = True] Old Tmcode [Level = Nominal] [Metadata = None] [AllowBlankValue = True] Libelle Old Offre [Level = Nominal] [Metadata = Values] [AllowBlankValue = True] New Tmcode [Level = Nominal] [Metadata = None] [AllowBlankValue = True] Libelle New Offre [Level = Nominal] [Metadata = Values] [AllowBlankValue = True] Type Migration [Level = Nominal] [Metadata = Values] [AllowBlankValue = True] Recharges [Subject_ID_1 = Subject_ID_Client] [Subject_ID_2 = Subject_ID_Abonne] Date Recharge [Level = Interval] [Metadata = None] [AllowBlankValue = True] Montant Recharge [Level = Interval] [Metadata = None] [AllowBlankValue = True] Type Recharge [Level = Nominal] [Metadata = None] [AllowBlankValue = True] Services [Subject_ID_1 = Subject_ID_Client] [Subject_ID_2 = Subject_ID_Abonne] Date Status [Level = Interval] [Metadata = None] [AllowBlankValue = True] Numéro Service [Level = Nominal] [Metadata = None] [AllowBlankValue = True] Libelle Du Service [Level = Nominal] [Metadata = Values] [AllowBlankValue = True] Status [Level = Nominal] [Metadata = Values] [AllowBlankValue = True] Gerant Compte [Subject_ID_1 = Subject_ID_Gerant] [Subject_ID_2 = Subject_ID_Client] Service [Subject_ID_1 = Subject_ID_Gerant] Libelle Service [Level = Nominal] [Metadata = Values] [AllowBlankValue = True] Sncode [Level = Nominal] [Metadata = Values] [AllowBlankValue = True] Montant [Level = Interval] [Metadata = None] [AllowBlankValue = True] Revenu [Subject_ID_1 = Subject_ID_Gerant] Rev Voix Z1 [Level = Interval] [Metadata = None] [AllowBlankValue = True] Rev Voix Z2a [Level = Interval] [Metadata = None] [AllowBlankValue = True] Rev Voix Z2b [Level = Interval] [Metadata = None] [AllowBlankValue = True] Rev Voix Z3 [Level = Interval] [Metadata = None] [AllowBlankValue = True] Rev Voix Z4 [Level = Interval] [AllowBlankValue = True] [Metadata = None] Rev Voix Z5 [Level = Interval] [AllowBlankValue = True] [Metadata = None] Rev Voix Z6 [Level = Interval] [Metadata = None] [AllowBlankValue = True] Rev Voix Z7 [Level = Interval] [AllowBlankValue = True] [Metadata = None] Rev Voix Z9 [Level = Interval] [Metadata = None] [AllowBlankValue = True] Rev Voix OFFNET [Level = Interval] [Metadata = None] [AllowBlankValue = True] Rev Voix Onnet [Level = Interval] [AllowBlankValue = True] [Metadata = None] Rev Voix Fix [Level = Interval] [Metadata = None] [AllowBlankValue = True] Rev Voix Roam IN [Level = Interval] [Metadata = None] [AllowBlankValue = True] Rev Voix Roam Out [Level = Interval] [Metadata = None] [AllowBlankValue = True] Segment [Subject_ID_1 = Subject_ID_Gerant] Segment En Valeur M-1 [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] Segment En Valeur M-2 [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] Segment En Valeur M-3 [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] Segment En Valeur M-4 [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] Segment En Valeur M-5 [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] Segment En Valeur M-6 [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] Segment En Valeur M-7 [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] Segment En Valeur M-8 [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] Segment En Valeur M-9 [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] Segment En Valeur M-10 [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] Segment En Valeur M-11 [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] Segment En Valeur M-12 [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] Segment En Ligne M-1 [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] Segment En Ligne M-2 [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] Segment En Ligne M-3 [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] Segment En Ligne M-4 [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] Segment En Ligne M-5 [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] Segment En Ligne M-6 [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] Segment En Ligne M-7 [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] Segment En Ligne M-8 [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] Segment En Ligne M-9 [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] Segment En Ligne M-10 [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] Segment En Ligne M-11 [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] Segment En Ligne M-12 [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] Customer Id Gerant [Level = Id] [UseInSubjectId = Subject_ID_Gerant] Numero Client Gearnt [Level = Nominal] [Metadata = None] [AllowBlankValue = True] Nom Gearnt [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Prenom Gerant [Level = Nominal] [Metadata = None] [AllowBlankValue = True] Operateur Gerant [Level = Nominal] [Metadata = Values] [AllowBlankValue = True] Numero a contacter [Level = Interval] [Metadata = None] [AllowBlankValue = True] Msisdn Export [Level = Interval] [Metadata = None] [AllowBlankValue = True] Max Date Activ [Level = Interval] [AllowBlankValue = True] [Metadata = None] Min Date Activ [Level = Interval] [Metadata = None] [AllowBlankValue = True] Type Client [Level = Nominal] [Metadata = Values] [AllowBlankValue = True] Nbr Lign B1 [Level = Interval] [Metadata = None] [AllowBlankValue = True] Nbr Lign Churn [Level = Interval] [Metadata = None] [AllowBlankValue = True] Nbr Lign Preserved [Level = Interval] [Metadata = None] [AllowBlankValue = True] Nbr Lign Busnetw [Level = Interval] [Metadata = None] [AllowBlankValue = True] Montant Facture Du Mois [Level = Interval] [AllowBlankValue = True] [Metadata = None] Montant Recharge [Level = Interval] [Metadata = None] [AllowBlankValue = True] Rev Service All [Level = Interval] [Metadata = None] [AllowBlankValue = True] Rev Tot [Level = Interval] [Metadata = None] [AllowBlankValue = True] Montant Facture Du Mois -1 [Level = Interval] [AllowBlankValue = True] [Metadata = None] Montant Facture Du Mois -2 [Level = Interval] [AllowBlankValue = True] [Metadata = None] Montant Facture Du Mois -3 [Level = Interval] [AllowBlankValue = True] [Metadata = None] Montant Facture Du Mois -4 [Level = Interval] [AllowBlankValue = True] [Metadata = None] Montant Facture Du Mois -5 [Level = Interval] [Metadata = None] [AllowBlankValue = True] Plan Relationnel Post [Subject_ID_1 = Subject_ID_Abonne] [Subject_ID_2 = Subject_ID_Client] Mois [Level = Nominal] [AllowBlankValue = False] [Metadata = Values] Periode [Level = Nominal] [AllowBlankValue = False] [Metadata = None] Flag Familia [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Flag Happyzone Post [Level = Nominal] [AllowBlankValue = True] [Metadata = None] Mois In Offre [Level = Interval] [AllowBlankValue = True] [Metadata = None] Régularité Internet Sur 6 Mois [Level = Interval] [AllowBlankValue = True] [Metadata = None] Régularité Roaming Out Sur 6 Mois [Level = Interval] [AllowBlankValue = True] [Metadata = None] Segment Croisé [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] Segmentation Revenu Roaming [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] Segmentation Internet [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] Tenure Post [Level = Nominal] [AllowBlankValue = True] [Metadata = Values] Historique des contacts [Subject_ID_1 = Subject_ID_Abonne] [Subject_ID_2 = Subject_ID_Client] Historique des contacts Abonné [Subject_ID_1 = Subject_ID_Abonne] Msisdn [Contact_History = Subject_ID_Abonne] [Level = Id] Date Activation [Contact_History = Subject_ID_Abonne] [Level = Id] Historique des contacts Client [Subject_ID_1 = Subject_ID_Client] Numero Client [Contact_History = Subject_ID_Client] [Level = Id] Code Campagne [Level = Nominal] [AllowBlankValue = False] [Metadata = None] Nom Campagne [Level = Nominal] [AllowBlankValue = False] [Metadata = Values] Code Communication [Level = Nominal] [AllowBlankValue = False] [Metadata = None] Nom Communication [Level = Nominal] [AllowBlankValue = False] [Metadata = Values] IVR [Subject_ID_1 = Subject_ID_Abonne] Appels Sortants [Subject_ID_1 = Subject_ID_Abonne] Call Date [Level = Interval] [AllowBlankValue = True] [Metadata = None] Dsec Call Result [Level = Nominal] [Metadata = Values] Case Id [Level = Nominal] [AllowBlankValue = True] Langue [Level = Nominal] [Metadata = Values] Nom Campagne [Level = Nominal] [AllowBlankValue = True] R1 [Level = Interval] [AllowBlankValue = True] R2 [Level = Interval] [AllowBlankValue = True] R3 [Level = Interval] [AllowBlankValue = True] R4 [Level = Interval] [AllowBlankValue = True] R5 [Level = Interval] [AllowBlankValue = True] R6 [Level = Interval] [AllowBlankValue = True] R7 [Level = Interval] [AllowBlankValue = True] R8 [Level = Interval] [AllowBlankValue = True] R9 [Level = Interval] [AllowBlankValue = True] R10 [Level = Interval] [AllowBlankValue = True] 2016-03-03 10:07:35,936 DEBUG [tomcat-http--49] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] om.sas.analytics.crm.ma.ejb.MAConfigBean - Listing of available libraries took: 0,027 seconds 2016-03-03 10:08:19,450 DEBUG [tomcat-http--5] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.ejb.CMFlexPlugin - Retrieving list of locked objects 2016-03-03 10:08:19,500 DEBUG [tomcat-http--5] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] nagers.AggregateObjectPersistenceManager - call to allClassesGetAllLocksConcise 2016-03-03 10:08:20,600 DEBUG [tomcat-http--5] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] nagers.AggregateObjectPersistenceManager - returning from allClassesGetAllLocksConciseBySession 2016-03-03 10:08:20,605 DEBUG [tomcat-http--5] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.ejb.CMFlexPlugin - Found 1 locked objects 2016-03-03 10:08:22,192 DEBUG [tomcat-http--17] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.ejb.CMFlexPlugin - Retrieving list of locked objects 2016-03-03 10:08:22,244 DEBUG [tomcat-http--17] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] nagers.AggregateObjectPersistenceManager - call to allClassesGetAllLocksConcise 2016-03-03 10:08:23,343 DEBUG [tomcat-http--17] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] nagers.AggregateObjectPersistenceManager - returning from allClassesGetAllLocksConciseBySession 2016-03-03 10:08:23,349 DEBUG [tomcat-http--17] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.ejb.CMFlexPlugin - Found 1 locked objects 2016-03-03 10:08:26,403 DEBUG [tomcat-http--24] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] om.sas.analytics.crm.ma.ejb.MAConfigBean - Getting list of campaign concise definitions took 0,049 seconds 2016-03-03 10:08:29,931 DEBUG [tomcat-http--22] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] om.sas.analytics.crm.ma.ejb.MAConfigBean - Got response list in 0,039 seconds 2016-03-03 10:08:34,208 DEBUG [tomcat-http--29] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] .custdata.datapattern.InformationMapPool - Using cached infoMap: 62fa962b 2016-03-03 10:08:34,218 DEBUG [tomcat-http--29] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] rm.custdata.datapattern.MAInformationMap - MAIM1:Time taken to getCalculatedItems: 0,009 seconds (+0,009 seconds) 2016-03-03 10:08:34,218 DEBUG [tomcat-http--29] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] rm.custdata.datapattern.MAInformationMap - MAIM1:Time taken to getCloneVarMap: 0,009 seconds (+0 seconds) 2016-03-03 10:08:34,219 DEBUG [tomcat-http--29] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] rm.custdata.datapattern.MAInformationMap - MAIM1:Time to store 61 StoredCalculatedItems: 0,009 seconds (+0 seconds) 2016-03-03 10:08:34,219 DEBUG [tomcat-http--29] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] rm.custdata.datapattern.MAInformationMap - CITEM: time to setupScoreVariables: 0 seconds (+0 seconds) 2016-03-03 10:08:34,220 DEBUG [tomcat-http--29] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] rm.custdata.datapattern.MAInformationMap - Time to tryRemove: 0,001 seconds (+0,001 seconds) 2016-03-03 10:08:34,265 DEBUG [tomcat-http--29] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] rm.custdata.datapattern.MAInformationMap - Time to createLoop: 0,045 seconds (+0,044 seconds) 2016-03-03 10:08:34,265 DEBUG [tomcat-http--29] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] rm.custdata.datapattern.MAInformationMap - MAIM1:Time to syncUpCalculatedItems on map 62fa962b: 0,056 seconds (+0,047 seconds) 2016-03-03 10:08:34,305 DEBUG [tomcat-http--29] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] .custdata.datapattern.InformationMapPool - Releasing infoMap used 9 times: 62fa962b 2016-03-03 10:08:34,310 DEBUG [tomcat-http--29] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] .crm.custdata.ejb.DataPatternManagerBean - -----Done with getDataPatterns( SID: cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209 )----- 2016-03-03 10:08:35,690 DEBUG [tomcat-http--33] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] om.sas.analytics.crm.ma.ejb.MAConfigBean - Getting all node definitions with parameters falsefalsetruefalse took 0,005 seconds 2016-03-03 10:08:42,398 DEBUG [tomcat-http--28] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] lytics.crm.cm.ejb.CampaignGroupProxyImpl - Q> getHierarchy 2016-03-03 10:08:42,398 DEBUG [tomcat-http--28] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] nalytics.crm.security.ejb.MASessionCache - Session counter incremented for session ID: cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209 - 1 -> 2 2016-03-03 10:08:42,399 DEBUG [CIAsyncExec-6] [] [] lytics.crm.cm.ejb.CampaignGroupProxyImpl - -> getHierarchy 2016-03-03 10:08:42,548 DEBUG [CIAsyncExec-6] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] lytics.crm.cm.ejb.CampaignGroupProxyImpl - <- getHierarchy 2016-03-03 10:08:42,549 DEBUG [CIAsyncExec-6] [] [] nalytics.crm.security.ejb.MASessionCache - Decremented session counter for session ID: cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209 - 2 -> 1 2016-03-03 10:08:42,656 DEBUG [tomcat-http--25] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] s.analytics.crm.ma.ejb.MAConfigProxyImpl - getSchedules 2016-03-03 10:09:27,492 DEBUG [tomcat-http--41] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] nalytics.crm.security.ejb.MASessionCache - Session counter incremented for session ID: cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209 - 1 -> 2 2016-03-03 10:09:27,493 DEBUG [CIAsyncExec-7] [] [] s.analytics.crm.cm.ejb.CampaignProxyImpl - -> getSchedules 2016-03-03 10:09:27,496 DEBUG [CIAsyncExec-7] [] [] com.sas.analytics.crm.cm.Campaign - Checking ScheduleManager for campaign schedule took: 0 seconds 2016-03-03 10:09:27,506 DEBUG [CIAsyncExec-7] [] [] s.analytics.crm.cm.ejb.CampaignProxyImpl - <- getSchedules 2016-03-03 10:09:27,506 DEBUG [CIAsyncExec-7] [] [] nalytics.crm.security.ejb.MASessionCache - Decremented session counter for session ID: cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209 - 2 -> 1 2016-03-03 10:09:27,569 DEBUG [tomcat-http--43] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] s.analytics.crm.ma.ejb.MAConfigProxyImpl - getActualAndPlannedExecutions 2016-03-03 10:09:27,664 DEBUG [tomcat-http--45] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] nalytics.crm.security.ejb.MASessionCache - Session counter incremented for session ID: cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209 - 1 -> 2 2016-03-03 10:09:27,664 DEBUG [CIAsyncExec-8] [] [] s.analytics.crm.cm.ejb.CampaignProxyImpl - -> getActualAndPlannedExecutions 2016-03-03 10:09:27,692 DEBUG [CIAsyncExec-8] [] [] s.analytics.crm.cm.ejb.CampaignProxyImpl - <- getActualAndPlannedExecutions 2016-03-03 10:09:27,692 DEBUG [CIAsyncExec-8] [] [] nalytics.crm.security.ejb.MASessionCache - Decremented session counter for session ID: cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209 - 2 -> 1 2016-03-03 10:09:27,769 DEBUG [tomcat-http--46] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] s.analytics.crm.ma.ejb.MAConfigProxyImpl - getExecutionHistory 2016-03-03 10:09:27,980 DEBUG [tomcat-http--2] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] nalytics.crm.security.ejb.MASessionCache - Session counter incremented for session ID: cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209 - 1 -> 2 2016-03-03 10:09:27,980 DEBUG [CIAsyncExec-9] [] [] s.analytics.crm.cm.ejb.CampaignProxyImpl - -> getExecutionHistory 2016-03-03 10:09:27,992 DEBUG [CIAsyncExec-9] [] [] s.analytics.crm.cm.ejb.CampaignProxyImpl - <- getExecutionHistory 2016-03-03 10:09:27,992 DEBUG [CIAsyncExec-9] [] [] nalytics.crm.security.ejb.MASessionCache - Decremented session counter for session ID: cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209 - 2 -> 1 2016-03-03 10:09:33,794 DEBUG [tomcat-http--6] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] s.analytics.crm.cm.ejb.CampaignProxyImpl - Q> sendSchedules 2016-03-03 10:09:33,794 DEBUG [tomcat-http--6] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] nalytics.crm.security.ejb.MASessionCache - Session counter incremented for session ID: cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209 - 1 -> 2 2016-03-03 10:09:33,794 DEBUG [CIAsyncExec-10] [] [] s.analytics.crm.cm.ejb.CampaignProxyImpl - -> sendSchedules 2016-03-03 10:09:33,817 WARN [CIAsyncExec-10] [] [] com.sas.analytics.crm.cm.Campaign - Rejecting attempt to submit schedule because campaign Action ciblee Samma3ni has a start date in the past in its schedule 2016-03-03 10:09:33,833 WARN [CIAsyncExec-10] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] s.analytics.crm.cm.ejb.CampaignProxyImpl - Encountered client exception:null, problemReport 2016-03-03 10:09:33,861 DEBUG [CIAsyncExec-10] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] s.analytics.crm.cm.ejb.CampaignProxyImpl - <- sendSchedules 2016-03-03 10:09:33,861 DEBUG [CIAsyncExec-10] [] [] nalytics.crm.security.ejb.MASessionCache - Decremented session counter for session ID: cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209 - 2 -> 1 2016-03-03 10:09:33,986 DEBUG [tomcat-http--5] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] s.analytics.crm.ma.ejb.MAConfigProxyImpl - markCampaignModified 2016-03-03 10:09:53,936 DEBUG [tomcat-http--13] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] nalytics.crm.security.ejb.MASessionCache - Session counter incremented for session ID: cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209 - 1 -> 2 2016-03-03 10:09:53,937 DEBUG [CIAsyncExec-10] [] [] s.analytics.crm.cm.ejb.CampaignProxyImpl - -> markCampaignModified 2016-03-03 10:09:53,948 DEBUG [CIAsyncExec-10] [] [] s.analytics.crm.cm.ejb.CampaignProxyImpl - <- markCampaignModified 2016-03-03 10:09:53,948 DEBUG [CIAsyncExec-10] [] [] nalytics.crm.security.ejb.MASessionCache - Decremented session counter for session ID: cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209 - 2 -> 1 2016-03-03 10:09:53,970 DEBUG [tomcat-http--14] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] s.analytics.crm.cm.ejb.CampaignProxyImpl - Q> updateSchedules 2016-03-03 10:09:53,971 DEBUG [tomcat-http--14] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] nalytics.crm.security.ejb.MASessionCache - Session counter incremented for session ID: cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209 - 1 -> 2 2016-03-03 10:09:53,971 DEBUG [CIAsyncExec-10] [] [] s.analytics.crm.cm.ejb.CampaignProxyImpl - -> updateSchedules 2016-03-03 10:09:53,984 DEBUG [CIAsyncExec-10] [] [] s.analytics.crm.cm.ejb.CampaignProxyImpl - <- updateSchedules 2016-03-03 10:09:53,984 DEBUG [CIAsyncExec-10] [] [] nalytics.crm.security.ejb.MASessionCache - Decremented session counter for session ID: cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209 - 2 -> 1 2016-03-03 10:09:54,111 DEBUG [tomcat-http--11] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] s.analytics.crm.cm.ejb.CampaignProxyImpl - Q> getSchedules 2016-03-03 10:09:54,111 DEBUG [tomcat-http--11] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] nalytics.crm.security.ejb.MASessionCache - Session counter incremented for session ID: cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209 - 1 -> 2 2016-03-03 10:09:54,111 DEBUG [CIAsyncExec-10] [] [] s.analytics.crm.cm.ejb.CampaignProxyImpl - -> getSchedules 2016-03-03 10:09:54,112 DEBUG [CIAsyncExec-10] [] [] com.sas.analytics.crm.cm.Campaign - Checking ScheduleManager for campaign schedule took: 0 seconds 2016-03-03 10:09:54,122 DEBUG [CIAsyncExec-10] [] [] s.analytics.crm.cm.ejb.CampaignProxyImpl - <- getSchedules 2016-03-03 10:09:54,122 DEBUG [CIAsyncExec-10] [] [] nalytics.crm.security.ejb.MASessionCache - Decremented session counter for session ID: cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209 - 2 -> 1 2016-03-03 10:09:54,238 DEBUG [tomcat-http--18] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] s.analytics.crm.ma.ejb.MAConfigProxyImpl - getActualAndPlannedExecutions 2016-03-03 10:09:54,280 DEBUG [tomcat-http--21] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] nalytics.crm.security.ejb.MASessionCache - Session counter incremented for session ID: cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209 - 1 -> 2 2016-03-03 10:09:54,280 DEBUG [CIAsyncExec-10] [] [] s.analytics.crm.cm.ejb.CampaignProxyImpl - -> getActualAndPlannedExecutions 2016-03-03 10:09:54,295 DEBUG [CIAsyncExec-10] [] [] s.analytics.crm.cm.ejb.CampaignProxyImpl - <- getActualAndPlannedExecutions 2016-03-03 10:09:54,295 DEBUG [CIAsyncExec-10] [] [] nalytics.crm.security.ejb.MASessionCache - Decremented session counter for session ID: cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209 - 2 -> 1 2016-03-03 10:09:54,355 DEBUG [tomcat-http--26] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] s.analytics.crm.ma.ejb.MAConfigProxyImpl - getExecutionHistory 2016-03-03 10:09:54,505 DEBUG [tomcat-http--29] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] nalytics.crm.security.ejb.MASessionCache - Session counter incremented for session ID: cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209 - 1 -> 2 2016-03-03 10:09:54,505 DEBUG [CIAsyncExec-10] [] [] s.analytics.crm.cm.ejb.CampaignProxyImpl - -> getExecutionHistory 2016-03-03 10:09:54,515 DEBUG [CIAsyncExec-10] [] [] s.analytics.crm.cm.ejb.CampaignProxyImpl - <- getExecutionHistory 2016-03-03 10:09:54,516 DEBUG [CIAsyncExec-10] [] [] nalytics.crm.security.ejb.MASessionCache - Decremented session counter for session ID: cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209 - 2 -> 1 2016-03-03 10:10:12,257 DEBUG [tomcat-http--31] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] s.analytics.crm.cm.ejb.CampaignProxyImpl - Q> updateSchedules 2016-03-03 10:10:12,258 DEBUG [tomcat-http--31] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] nalytics.crm.security.ejb.MASessionCache - Session counter incremented for session ID: cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209 - 1 -> 2 2016-03-03 10:10:12,259 DEBUG [CIAsyncExec-10] [] [] s.analytics.crm.cm.ejb.CampaignProxyImpl - -> updateSchedules 2016-03-03 10:10:12,299 DEBUG [CIAsyncExec-10] [] [] s.analytics.crm.cm.ejb.CampaignProxyImpl - <- updateSchedules 2016-03-03 10:10:12,299 DEBUG [CIAsyncExec-10] [] [] nalytics.crm.security.ejb.MASessionCache - Decremented session counter for session ID: cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209 - 2 -> 1 2016-03-03 10:10:12,386 DEBUG [tomcat-http--25] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] s.analytics.crm.cm.ejb.CampaignProxyImpl - Q> getSchedules 2016-03-03 10:10:12,386 DEBUG [tomcat-http--25] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] nalytics.crm.security.ejb.MASessionCache - Session counter incremented for session ID: cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209 - 1 -> 2 2016-03-03 10:10:12,389 DEBUG [CIAsyncExec-10] [] [] s.analytics.crm.cm.ejb.CampaignProxyImpl - -> getSchedules 2016-03-03 10:10:12,389 DEBUG [CIAsyncExec-10] [] [] com.sas.analytics.crm.cm.Campaign - Checking ScheduleManager for campaign schedule took: 0 seconds 2016-03-03 10:10:12,427 DEBUG [CIAsyncExec-10] [] [] s.analytics.crm.cm.ejb.CampaignProxyImpl - <- getSchedules 2016-03-03 10:10:12,427 DEBUG [CIAsyncExec-10] [] [] nalytics.crm.security.ejb.MASessionCache - Decremented session counter for session ID: cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209 - 2 -> 1 2016-03-03 10:10:12,587 DEBUG [tomcat-http--34] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] s.analytics.crm.ma.ejb.MAConfigProxyImpl - getActualAndPlannedExecutions 2016-03-03 10:10:12,680 DEBUG [tomcat-http--39] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] nalytics.crm.security.ejb.MASessionCache - Session counter incremented for session ID: cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209 - 1 -> 2 2016-03-03 10:10:12,680 DEBUG [CIAsyncExec-10] [] [] s.analytics.crm.cm.ejb.CampaignProxyImpl - -> getActualAndPlannedExecutions 2016-03-03 10:10:12,717 DEBUG [CIAsyncExec-10] [] [] s.analytics.crm.cm.ejb.CampaignProxyImpl - <- getActualAndPlannedExecutions 2016-03-03 10:10:12,717 DEBUG [CIAsyncExec-10] [] [] nalytics.crm.security.ejb.MASessionCache - Decremented session counter for session ID: cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209 - 2 -> 1 2016-03-03 10:10:12,866 DEBUG [tomcat-http--36] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] s.analytics.crm.ma.ejb.MAConfigProxyImpl - getExecutionHistory 2016-03-03 10:10:13,185 DEBUG [tomcat-http--44] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] nalytics.crm.security.ejb.MASessionCache - Session counter incremented for session ID: cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209 - 1 -> 2 2016-03-03 10:10:13,186 DEBUG [CIAsyncExec-10] [] [] s.analytics.crm.cm.ejb.CampaignProxyImpl - -> getExecutionHistory 2016-03-03 10:10:13,220 DEBUG [CIAsyncExec-10] [] [] s.analytics.crm.cm.ejb.CampaignProxyImpl - <- getExecutionHistory 2016-03-03 10:10:13,220 DEBUG [CIAsyncExec-10] [] [] nalytics.crm.security.ejb.MASessionCache - Decremented session counter for session ID: cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209 - 2 -> 1 2016-03-03 10:10:16,436 DEBUG [tomcat-http--42] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] s.analytics.crm.cm.ejb.CampaignProxyImpl - Q> save 2016-03-03 10:10:16,437 DEBUG [tomcat-http--42] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] nalytics.crm.security.ejb.MASessionCache - Session counter incremented for session ID: cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209 - 1 -> 2 2016-03-03 10:10:16,437 DEBUG [CIAsyncExec-10] [] [] s.analytics.crm.cm.ejb.CampaignProxyImpl - -> save 2016-03-03 10:10:16,450 DEBUG [CIAsyncExec-10] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.cm.Campaign - campBean: saving campaign (EEEFB31FYJCSVYJ2): Action ciblee Samma3ni, campId=null, newName=null, folder=null 2016-03-03 10:10:16,504 DEBUG [CIAsyncExec-10] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] om.sas.analytics.crm.ma.ejb.MAConfigBean - Got response list in 0,046 seconds 2016-03-03 10:10:16,835 DEBUG [CIAsyncExec-10] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.cm.Campaign - Campaign preparation finished in 0,384 seconds (+0,384 seconds) 2016-03-03 10:10:16,835 DEBUG [CIAsyncExec-10] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.cm.Campaign - Campaign (not the diagram) saved in 0,385 seconds (+0,001 seconds) 2016-03-03 10:10:17,025 DEBUG [CIAsyncExec-10] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MAFlow - Time taken updating calculated item references: 0:00:00.002 2016-03-03 10:10:17,025 DEBUG [CIAsyncExec-10] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MAFlow - Call pre-save prep method for each node 2016-03-03 10:10:17,025 DEBUG [CIAsyncExec-10] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MAFlow - save node group and nodecount maps 2016-03-03 10:10:17,026 INFO [CIAsyncExec-10] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MAFlow - Saving diagram Action ciblee Samma3ni in folder Action ciblée Samma3ni 2016-03-03 10:10:17,026 DEBUG [CIAsyncExec-10] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MAFlow - Save preparation running time 0:00:00.191 2016-03-03 10:10:17,026 DEBUG [CIAsyncExec-10] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MAFlow - The following users have read or edit access: 2016-03-03 10:10:17,026 DEBUG [CIAsyncExec-10] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MAFlow - User: CHEHAYDER Hela, read: true, edit: true 2016-03-03 10:10:17,026 DEBUG [CIAsyncExec-10] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MAFlow - User: SGHAIER Walid, read: true, edit: true 2016-03-03 10:10:17,026 DEBUG [CIAsyncExec-10] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MAFlow - User: Groupe DSI, read: true, edit: true 2016-03-03 10:10:17,053 DEBUG [CIAsyncExec-10] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] s.analytics.crm.task.ejb.TaskManagerBean - Sent flow event message (Flow Modified Changed) to flow with id DCAAIX3DJFDRWNLE 2016-03-03 10:10:17,053 DEBUG [CIAsyncExec-10] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MAFlow - PERSISTENCE : Node Actifs (GAAGX1ECXVFKVUD1) has been resaved. 2016-03-03 10:10:17,053 DEBUG [CIAsyncExec-10] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MAFlow - PERSISTENCE : Node ARPU M-1 > 35 DT. (EGAGEKWYHRF3UKVR) has been resaved. 2016-03-03 10:10:17,053 DEBUG [CIAsyncExec-10] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MAFlow - PERSISTENCE : Node Non contacte les 2derniers mois (BAHAWXRQ33D4QOO2) has been resaved. 2016-03-03 10:10:17,053 DEBUG [CIAsyncExec-10] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MAFlow - PERSISTENCE : Node Non inscrit samma3n les 3 derniers mois(2) (GHFAPIQVQFHIVZAA) has been resaved. 2016-03-03 10:10:17,053 DEBUG [CIAsyncExec-10] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MAFlow - PERSISTENCE : Node Population(3) (CFECVYJQB3HNQM2B) has been resaved. 2016-03-03 10:10:17,054 DEBUG [CIAsyncExec-10] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MAFlow - PERSISTENCE : Node Awal post (BBBCQAPGLBHHVGU0) has been resaved. 2016-03-03 10:10:17,054 DEBUG [CIAsyncExec-10] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MAFlow - PERSISTENCE : Node Population (ECFGP21UZNDBQFN4) has been resaved. 2016-03-03 10:10:17,054 DEBUG [CIAsyncExec-10] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MAFlow - PERSISTENCE : Node Population(2) (DDDFN4AGV3EHQNFV) has been resaved. 2016-03-03 10:10:17,054 DEBUG [CIAsyncExec-10] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MAFlow - PERSISTENCE : Node Type Client (HCHACWP11JESVITN) has been resaved. 2016-03-03 10:10:17,054 DEBUG [CIAsyncExec-10] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MAFlow - PERSISTENCE : Node Action Ciblee SAMMA3NI FBR (BHCDYMUCTJETQJVS) has been resaved. 2016-03-03 10:10:17,054 DEBUG [CIAsyncExec-10] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MAFlow - PERSISTENCE : Node Limiter(3) (FBEB3QBSTBDXQLDV) has been resaved. 2016-03-03 10:10:17,054 DEBUG [CIAsyncExec-10] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MAFlow - PERSISTENCE : Node Pre (HFEGSIQZQFE1TDLC) has been resaved. 2016-03-03 10:10:17,054 DEBUG [CIAsyncExec-10] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MAFlow - PERSISTENCE : Node ARPU M-1 > 20 DT (ACBDIYW0ARFASXT0) has been resaved. 2016-03-03 10:10:17,054 DEBUG [CIAsyncExec-10] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MAFlow - PERSISTENCE : Node Segment Du Mois (AHFC341RRFAWWNPZ) has been resaved. 2016-03-03 10:10:17,055 DEBUG [CIAsyncExec-10] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MAFlow - PERSISTENCE : Node Prepaye et CC et Non CC (AHDD1OMV2RB5QUS4) has been resaved. 2016-03-03 10:10:17,055 DEBUG [CIAsyncExec-10] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MAFlow - PERSISTENCE : Node Segment Du Mois -1 (HGBFXLHBFJDQU2DD) has been resaved. 2016-03-03 10:10:17,055 DEBUG [CIAsyncExec-10] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MAFlow - PERSISTENCE : Node Root (AGGHMLPWSNFCSM43) has been resaved. 2016-03-03 10:10:17,055 DEBUG [CIAsyncExec-10] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MAFlow - PERSISTENCE : Node Segment Du Mois -2 (DBFC0TFIVZHOR4S4) has been resaved. 2016-03-03 10:10:17,055 DEBUG [CIAsyncExec-10] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MAFlow - PERSISTENCE : Node Limiter (FDAFIZEP2RHJQLOT) has been resaved. 2016-03-03 10:10:17,055 DEBUG [CIAsyncExec-10] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MAFlow - PERSISTENCE : Node Action Ciblee SAMMA3NI Pre (CEFDMEH0B3E2SCZ3) has been resaved. 2016-03-03 10:10:17,055 DEBUG [CIAsyncExec-10] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MAFlow - PERSISTENCE : Node Limiter(2) (CCEEQGHRMNFDSJLW) has been resaved. 2016-03-03 10:10:17,055 DEBUG [CIAsyncExec-10] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MAFlow - PERSISTENCE : Node Action Ciblee SAMMA3NI Post (HFBC3KJBOBGLRF3Q) has been resaved. 2016-03-03 10:10:17,055 DEBUG [CIAsyncExec-10] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MAFlow - PERSISTENCE : Node FBR (EFCHDO4IIZC5Q0QF) has been resaved. 2016-03-03 10:10:17,056 DEBUG [CIAsyncExec-10] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.TableFactory - Diagram Action ciblee Samma3ni: Updating cache from: 2016-03-03 10:10:17,056 DEBUG [CIAsyncExec-10] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.TableFactory - Diagram Action ciblee Samma3ni: Updated table cache: 2016-03-03 10:10:17,056 INFO [CIAsyncExec-10] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.flow.MAFlow - Flow DOs save complete in 0:00:00.221 2016-03-03 10:10:20,999 DEBUG [CIAsyncExec-10] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.cm.Campaign - Diagram saved in 4,549 seconds (+4,164 seconds) 2016-03-03 10:10:21,001 DEBUG [CIAsyncExec-10] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.cm.Campaign - committing attachments for DCAAIX3DJFDRWNLE 2016-03-03 10:10:21,017 INFO [CIAsyncExec-10] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.cm.Campaign - Total time to save campaign: 4,566 seconds 2016-03-03 10:10:21,051 DEBUG [CIAsyncExec-10] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] s.analytics.crm.cm.ejb.CampaignProxyImpl - <- save 2016-03-03 10:10:21,055 DEBUG [CIAsyncExec-10] [] [] nalytics.crm.security.ejb.MASessionCache - Decremented session counter for session ID: cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209 - 2 -> 1 2016-03-03 10:10:21,154 DEBUG [tomcat-http--3] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] s.analytics.crm.ma.ejb.MAConfigProxyImpl - markCampaignModified 2016-03-03 10:10:21,296 DEBUG [tomcat-http--6] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] nalytics.crm.security.ejb.MASessionCache - Session counter incremented for session ID: cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209 - 1 -> 2 2016-03-03 10:10:21,296 DEBUG [CIAsyncExec-10] [] [] s.analytics.crm.cm.ejb.CampaignProxyImpl - -> markCampaignModified 2016-03-03 10:10:21,317 DEBUG [CIAsyncExec-10] [] [] s.analytics.crm.cm.ejb.CampaignProxyImpl - <- markCampaignModified 2016-03-03 10:10:21,317 DEBUG [CIAsyncExec-10] [] [] nalytics.crm.security.ejb.MASessionCache - Decremented session counter for session ID: cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209 - 2 -> 1 2016-03-03 10:10:21,339 DEBUG [tomcat-http--50] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] tics.crm.cm.ejb.CampaignManagerProxyImpl - Q> getCampaignsConciseHierarchy 2016-03-03 10:10:21,340 DEBUG [tomcat-http--50] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] nalytics.crm.security.ejb.MASessionCache - Session counter incremented for session ID: cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209 - 1 -> 2 2016-03-03 10:10:21,340 DEBUG [CIAsyncExec-10] [] [] tics.crm.cm.ejb.CampaignManagerProxyImpl - -> getCampaignsConciseHierarchy 2016-03-03 10:10:22,914 INFO [CIAsyncExec-10] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] analytics.crm.cm.ejb.CampaignManagerBean - Returned list of campaigns in folder in 1,559 seconds 2016-03-03 10:10:22,958 DEBUG [CIAsyncExec-10] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] tics.crm.cm.ejb.CampaignManagerProxyImpl - <- getCampaignsConciseHierarchy 2016-03-03 10:10:22,958 DEBUG [CIAsyncExec-10] [] [] nalytics.crm.security.ejb.MASessionCache - Decremented session counter for session ID: cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209 - 2 -> 1 2016-03-03 10:10:23,069 DEBUG [tomcat-http--10] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] s.analytics.crm.ma.ejb.MAConfigProxyImpl - sendSchedules 2016-03-03 10:10:28,414 DEBUG [tomcat-http--14] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] nalytics.crm.security.ejb.MASessionCache - Session counter incremented for session ID: cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209 - 1 -> 2 2016-03-03 10:10:28,414 DEBUG [CIAsyncExec-10] [] [] s.analytics.crm.cm.ejb.CampaignProxyImpl - -> sendSchedules 2016-03-03 10:10:28,416 DEBUG [CIAsyncExec-10] [] [] com.sas.analytics.crm.flow.MAFlow - campBean: retrieving communication BHCDYMUCTJETQJVS for campaign (EEEFB31FYJCSVYJ2): Action ciblee Samma3ni 2016-03-03 10:10:28,419 DEBUG [CIAsyncExec-10] [] [] com.sas.analytics.crm.cm.Campaign - Validated that User Marouen Krifa hass capability MAScheduleCampaign in order to perform this action on campaign/communication/diagram/group Action Ciblee SAMMA3NI FBR 2016-03-03 10:10:28,419 DEBUG [CIAsyncExec-10] [] [] com.sas.analytics.crm.cm.Campaign - Validated that User Marouen Krifa hass capability MAExecuteCampaign in order to perform this action on campaign/communication/diagram/group Action Ciblee SAMMA3NI FBR 2016-03-03 10:10:28,449 DEBUG [CIAsyncExec-10] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.cm.Campaign - temp params on comm sch side 2016-03-03 10:10:28,449 DEBUG [CIAsyncExec-10] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] com.sas.analytics.crm.cm.Campaign - temp params for camp sub: Param1:DAEERJZ5SVD3TJ5C,Param2:EEEFB31FYJCSVYJ2,Param3:marouen.krifa.ext@intra,Param4:f08157f724aaf16343388314a0f1a5ee 2016-03-03 10:10:28,934 ERROR [CIAsyncExec-10] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] .persistence.IOScheduleRepositoryManager - Connection to scheduling server could not be made : null scheduler, schedulerID or schedulerPW 2016-03-03 10:10:28,942 WARN [CIAsyncExec-10] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] s.analytics.crm.cm.ejb.CampaignProxyImpl - Encountered client exception:No connection to scheduling server, noConnectionToSchedulingServer 2016-03-03 10:10:28,983 DEBUG [CIAsyncExec-10] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] s.analytics.crm.cm.ejb.CampaignProxyImpl - <- sendSchedules 2016-03-03 10:10:28,983 DEBUG [CIAsyncExec-10] [] [] nalytics.crm.security.ejb.MASessionCache - Decremented session counter for session ID: cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209 - 2 -> 1 2016-03-03 10:10:29,084 DEBUG [tomcat-http--11] [cfe6aeca1fdc414e:-7a78c641:1533bb54b96:-6209] [Marouen Krifa] s.analytics.crm.ma.ejb.MAConfigProxyImpl -