Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
- Home
- /
- About John_Wick
08-29-2024
John_Wick
Obsidian | Level 7
Member since
08-19-2022
- 37 Posts
- 6 Likes Given
- 7 Solutions
- 5 Likes Received
-
Latest posts by John_Wick
Subject Views Posted 412 08-13-2024 12:34 PM 720 07-19-2024 12:36 PM 406 07-16-2024 04:27 AM 524 07-03-2024 04:24 AM 586 07-02-2024 01:13 PM 899 07-01-2024 05:58 AM 359 04-10-2024 08:54 AM 468 04-07-2024 01:37 PM 473 03-19-2024 06:07 AM 824 01-25-2024 09:40 AM -
Activity Feed for John_Wick
- Posted SAS CIS communication export to kafka topic on Administration and Deployment. 08-13-2024 12:34 PM
- Posted SAS RTDM Datetime variable for read from Data Process on SAS Customer Intelligence. 07-19-2024 12:36 PM
- Posted Re: SAS Customer Intelligence Studio erros after the successful closing of the first session campaig on Administration and Deployment. 07-16-2024 04:27 AM
- Posted Re: SAS Customer Intelligence Studio erros after the successful closing of the first session campaig on Administration and Deployment. 07-03-2024 04:24 AM
- Posted SAS Customer Intelligence Studio erros after the successful closing of the first session campaign on Administration and Deployment. 07-02-2024 01:13 PM
- Posted Change host of Compute tier for SAS Marketing Automation on Administration and Deployment. 07-01-2024 05:58 AM
- Posted Re: Problem with SASMerchIntelGridSvr5.41 on Administration and Deployment. 04-10-2024 08:54 AM
- Posted Problem with SASMerchIntelGridSvr5.41 on Administration and Deployment. 04-07-2024 01:37 PM
- Posted "Naming Conventions" error when trying to select data from oracle database on SAS Enterprise Guide. 03-19-2024 06:07 AM
- Posted SAS Server 6 stops returning information to the scheduler about completed companies on Administration and Deployment. 01-25-2024 09:40 AM
- Got a Like for Re: Setting logging of BatchServer to real-time. 11-27-2023 01:46 PM
- Posted Re: Setting logging of BatchServer to real-time on Administration and Deployment. 11-27-2023 05:02 AM
- Liked Re: Setting logging of BatchServer to real-time for SASKiwi. 11-27-2023 04:52 AM
- Posted Setting logging of BatchServer to real-time on Administration and Deployment. 11-23-2023 08:20 AM
- Got a Like for Re: Recursive Segmentation Violations - system exiting error while executing sas command from LSF. 10-27-2023 10:09 AM
- Posted Re: Recursive Segmentation Violations - system exiting error while executing sas command from LSF on Administration and Deployment. 10-27-2023 08:47 AM
- Posted Re: Recursive Segmentation Violations - system exiting error while executing sas command from LSF on Administration and Deployment. 10-26-2023 11:44 AM
- Posted Re: Recursive Segmentation Violations - system exiting error while executing sas command from LSF on Administration and Deployment. 10-26-2023 09:50 AM
- Posted Recursive Segmentation Violations - system exiting error while executing sas command from LSF on Administration and Deployment. 10-26-2023 06:29 AM
- Posted Up the performance of deploying RTDM diagrams on Administration and Deployment. 06-19-2023 10:49 AM
-
Posts I Liked
Subject Likes Author Latest Post 1 2 2 1 2 -
My Liked Posts
Subject Likes Posted 1 11-27-2023 05:02 AM 2 10-27-2023 08:47 AM 2 06-02-2023 11:16 AM
08-13-2024
12:34 PM
Hello, experts!
Challenge: A customer has a request with the request to send customer segments from CIS directly to Kafka topic.
Question: has anyone had experience in integrating SAS and kafka via a communication node? Perhaps someone can share ready-made solutions or suggest how it can be done in the best possible way with minimum number of steps.
So far we see a couple of options: - export to json and console producer - csv connector - java profile with Kafka Producer
... View more
07-19-2024
12:36 PM
Hello experts!
We using SAS RTDM data process cell for select row from library. And in test-case using Asia/Almaty timezone.
If we enter the date manually or through a calendar in the data processing node, when we run the test case, the date will be set to UTC and ignore the time zone specified in the test case.
Part of log:
------------------
2024-07-16 20:51:54,281 TRACE sasadm SASDSDesignRepository Test Case 1 com.sas.rtdm.implementation.resource.d bcp.DSPoolingConnection - Create Statement completed :302705 nanos. 2024-07-16 20:51:54,331 TRACE sasadm SASDSDesignRepository Test Case 1 com.sas.rtdm.implementation.TableCache JDBCLoader TableCacheJDBCLoader.select() times (nanos) [Prepare: 943235 Execute: 49175167 SQL: SELECT MONTH, DAY, NPS_SURVEY_DAY FROM EXP_USER.NPS_CALENDAR WHERE DAY = ? Where Clause Values: {java.util.GregorianCalenda r[time=1720983600000, areFieldsSet=true, areAllFieldsSet-false, lenient=false, zone-sun.util.calendar.ZoneInfo[id -"UTC", offset-0, dstSavings-0, useDaylight-false, transitions-0, lastRule-null], firstDayOfWeek-1, minimalDaysInFir stWeek=1, ERA=1,YEAR=2024, MONTH=6,WEEK_OF_YEAR=29,WEEK_OF_MONTH=3, DAY_OF_MONTH=14,DAY_OF_YEAR=196, DAY_OF_WEEK= 1, DAY OF WEEK IN MONTH=2,AM PM=1, HOUR=7, HOUR OF DAY=19, MINUTE=0, SECOND=0,MILLISECOND=0, ZONE OFFSET=0,DST OFFS ET=0]} Results: RTDMTable Start
------------------
However, if you pass the date as a calculated variable, such as the campaign start date, the timezone specified in the test case will apply.
Part of log:
------------------
2024-07-19 21:02:40,815 TRACE sasadm SASDSDesignRepository Test Case 1 com.sas.rtdm. implementa tion. TableCacheJDBCLoader - TableCacheJDBCLoader. select () times (nanos) [Prepare: 95685063 Execu te: 48901484 SQL: SELECT MONTH, DAY, NPS SURVEY DAY FROM EXP USER. NPS CALENDAR WHERE DAY = ? W here Clause Values: {java.util.GregorianCalendar[time=1720983600000, areFieldsSet=true, areAllFi eldsSet=true, lenient=false, zone=sun.util.calendar. ZoneInfo[id="Asia/Almaty",offset=18000000,ds tSavings=0, useDaylight=false, transitions=54, lastRule=null], firstDayOfWeek=1, minimalDaysInFirst Week=1, ERA=1, YEAR=2024, MONTH=6,WEEK OF YEAR=29,WEEK OF MONTH=3, DAY OF MONTH=15, DAY OF YEAR=197 ,DAY OF WEEK=2, DAY OF WEEK IN MONTH=3, AM PM=0, HOUR=0, HOUR OF DAY=0, MINUTE=0, SECOND=0, MILLISECO ND=0,ZONE OFFSET=18000000, DST OFFSET=0]} Results: RTDMTable Start
------------------
How can we enter the date manually with correct datatime from test-case or server timezone?
Maybe this is how it should work. That any date entered manually or through a calendar would always be in UTC. However, it is strange that this is not the case for calculated variables, as it can lead to unexpected results.
We will be grateful for any useful information and any thoughts on this matter!
... View more
07-16-2024
04:27 AM
The problem is isolated, no such problem was observed with newly created or old users.
The problem was fixed by randomly adding the user to the "superuser" group (Customer Intelligence: Usage, Metadata Server: Unrestricted) and trying to reproduce the problem. The problem was not reproduced. Then we removed the superuser rights and the problem did not reproduce and stopped reproducing at all.
The consensus was that it was a system bug. Perhaps it could help:
restarting the metadata server
Analyze/Repair metadata
but since the server is productive and runs for 24 hours, it was not possible to stop the metadata server because of one user.
... View more
07-03-2024
04:24 AM
MetadataServer.log 2024-06-27T16:48:22,319 INFO [139627676] 4673922:user@saspw - DoRequest return code=807fe85d… 2024-06-27T16:48:22,319 ERROR [139627676] 4673922:user@saspw - The user does not have permission to perform this action.
... View more
07-02-2024
01:13 PM
Hello, experts! I created a new user with native rights for SAS (let his name be user). The user successfully logs into SAS CIS. Then user opens any campaign and then successfully closes it. After that, any of the following actions result in errors: 1. Error when re-reading the same campaign or any other campaign
SASCustIntelCore.log.
2024-06-27 13:28:05,390 DEBUG [tomcat-http--33] [12255056afb9240e:-6a2c9f6a:190592b1105:-9c6] [user] tics.crm.cm.ejb.CampaignManagerProxyImpl - Q> loadCampaign 2024-06-27 13:28:05,391 DEBUG [tomcat-http--33] [12255056afb9240e:-6a2c9f6a:190592b1105:-9c6] [user] nalytics.crm.security.ejb.MASessionCache - Session counter incremented for session ID: 12255056afb9240e:-6a2c9f6a:190592b1105:-9c6 - 1 -> 2 2024-06-27 13:28:05,391 DEBUG [CIAsyncExec-1007] [12255056afb9240e:-6a2c9f6a:190592b1105:-9c6] [user] tics.crm.cm.ejb.CampaignManagerProxyImpl - -> loadCampaign 2024-06-27 13:28:05,398 DEBUG [CIAsyncExec-1007] [12255056afb9240e:-6a2c9f6a:190592b1105:-9c6] [user] com.sas.analytics.crm.flow.ejb.FlowBean - Starting to load campaign with ID GCDH0MRUXNDIWLKG for SID 12255056afb9240e:-6a2c9f6a:190592b1105:-9c6 from folder null, readOnly: false, loadDiagram: true, cleanupTablesOnExit: true, executing: false 2024-06-27 13:28:06,323 DEBUG [CIAsyncExec-1007] [12255056afb9240e:-6a2c9f6a:190592b1105:-9c6] [user] tencemanagers.CampaignPersistenceManager - In MAPersistenceManager:checkOut(MAUser user, String objId). CheckOut by user user GCDH0MRUXNDIWLKG for edit 2024-06-27 13:28:06,323 ERROR [CIAsyncExec-1007] [12255056afb9240e:-6a2c9f6a:190592b1105:-9c6] [user] analytics.crm.cm.ejb.CampaignManagerBean - Error loading campaign. com.sas.analytics.crm.error.client.ApplicationException at com.sas.analytics.crm.persistence.metadata.MASmartObjectIO.lockObject(MASmartObjectIO.java:377) at com.sas.analytics.crm.persistencemanagers.MAPersistenceManager.checkOut(MAPersistenceManager.java:1492) at com.sas.analytics.crm.persistencemanagers.MAPersistenceManager.loadObjectByMI(MAPersistenceManager.java:1123) at com.sas.analytics.crm.persistencemanagers.CampaignPersistenceManager.loadObjectByMI(CampaignPersistenceManager.java:155) at com.sas.analytics.crm.persistencemanagers.MAPersistenceManager.loadObjectByID(MAPersistenceManager.java:224) at com.sas.analytics.crm.cm.Campaign.<init>(Campaign.java:766) at com.sas.analytics.crm.flow.ejb.FlowBean.initCampaign(FlowBean.java:411) at com.sas.analytics.crm.cm.ejb.CampaignManagerBean.loadCampaign(CampaignManagerBean.java:255) at com.sas.analytics.crm.cm.ejb.CampaignManagerBean.loadCampaign(CampaignManagerBean.java:226) at com.sas.analytics.crm.cm.ejb.CampaignManagerProxyImpl$9.call(CampaignManagerProxyImpl.java:571) at com.sas.analytics.crm.cm.ejb.CampaignManagerProxyImpl$9.call(CampaignManagerProxyImpl.java:541) at com.sas.analytics.crm.cm.ejb.util.CallableAdapter.call(CallableAdapter.java:9) at com.sas.analytics.crm.cm.ejb.util.WrappedRunnable.run(WrappedRunnable.java:83) at com.sas.ci.services.common.services.asynchronous.SessionCountingRunnableQueue$QueueHandler.run(SessionCountingRunnableQueue.java:88) at com.sas.analytics.crm.task.ejb.ClearedThreadLocalRunnable.run(ClearedThreadLocalRunnable.java:24) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) Caused by: com.sas.services.ServiceException: Exception occurred updating the SAS Metadata Repository. [ com.sas.metadata.remote.MdException: The user does not have permission to perform this action. [ com.sas.iom.SASIOMDefs.GenericError: The user does not have permission to perform this action. ] ] at com.sas.services.information.OMIServer.flush(OMIServer.java:6513) at com.sas.services.information.metadata.Metadata.update(Metadata.java:1038) at com.sas.analytics.crm.persistence.metadata.MASmartObjectIO.lockObject(MASmartObjectIO.java:373) ... 17 more Caused by: com.sas.metadata.remote.MdException: The user does not have permission to perform this action. at com.sas.metadata.remote.MdOMIWrapperImpl.DoRequest(MdOMIWrapperImpl.java:791) at com.sas.metadata.remote.MdOMIUtilImpl.DoRequestNoReturn(MdOMIUtilImpl.java:2639) at com.sas.metadata.remote.impl.MdObjectBaseXMLImpl.updateMetadataAll(MdObjectBaseXMLImpl.java:535) at com.sas.metadata.remote.MdObjectStoreImpl.updatedMetadataAll(MdObjectStoreImpl.java:332) at com.sas.services.information.OMIServer.flush(OMIServer.java:6501) ... 19 more Caused by: com.sas.iom.SASIOMDefs.GenericError: The user does not have permission to perform this action. at com.sas.iom.SASIOMDefs.GenericErrorHelper.read(GenericErrorHelper.java:22) at com.sas.iom.SASIOMDefs.GenericErrorHelper.extract(GenericErrorHelper.java:47) at com.sas.meta.SASOMI._portable_stub_IOMI.DoRequest(_portable_stub_IOMI.java:581) at com.sas.metadata.remote.MdOMIWrapperImpl.DoRequest(MdOMIWrapperImpl.java:742) ... 23 more
SASCustIntelStudio.log.
2024-06-27 13:28:06,574 TRACE [tomcat-http--76] [12255056afb9240e:-6a2c9f6a:190592b1105:-9b3] [user] springframework.web.method.HandlerMethod - Invoking [CampaignController.closeCampaign] method with arguments [{"campaignId":"GCDHOMRUXNDIWLKG"}] 2024-06-27 13:28:06,575 DebuG [tomcat-http--76] [12255056afb9240e:-6а2c9f6а:190592b1105:-9b3] [user] .registry.impl.SharedServiceRegistryImpl - Created Registered Service: /Campaign[Url=https://*****:8343/ci66/remote/Campaign, secured=true, type=Java, id=null, serviceInterface=com.sas.analytics.crm.cm.client.CampaignProxy, namespace=null, version=0.0.0, keywords=[], properties=[IsSecured:true, IsGenerated:false, ServiceType:Java], dependencies=[]] with RRU: https://******:8343/ci6 2024-06-27 13:28:06,575 DEBUG [tomcat-http--76] [12255056afb9240e:-6a2c9f6a:190592b1105:-9b3] [user] emoting.CIServicesInvokerRequestExecutor - tomcat-http--76: dokxecuteRequest on f858a00 451b6372 8cd351a 2024-06-27 13:28:06,576 DeBUG [tomcat-http--76] [12255056afb9240e:-6a2c9f6a:190592b1105:-9b3] [user] .common.remoting.CookieSnipingHttpClient - 8CD351A: Parameter HASH: hc=0/me=2EFF21F9/st=0 2024-06-27 13:28:06,576 DEBuG [tomcat-http--76] [12255056afb9240e:-6а2c9f6а:190592b1105:-9b3] [user] .common.remoting.CookieSnipingHttpClient - 8CD351A: Setting cookie on state[4113522A]: Cookie: e736f2c2c50b189b0961df92a55f4114 Cluster6;/;* **;nul1;5dFEDF9DD0D212842F6283575859c70c.e736f2c2c50b189b0961df92a55f4114_SASSc ver6 1 2024-06-27 13:28:06,576 DEBUG [tomcat-http--76] [12255056afb9240e:-6a2c9f6a:190592b1105:-9b3] [user] .common.remoting.CookieSnipingHttpClient - 8CD351A: Setting cookie on state[4113522A]: Cookie: e736f2c2c50b189b0961df92a55f4114Cluster6;/;*******;null;3411763C7F5F70243BA4FCADEA0A2922.e736f2c2c50b189b0961df92a55f4114_SASSe ver6 1 2024-06-27 13:28:06,576 DeBuG [tomcat-http--76] [12255056afb9240e:-6a2c9f6a:190592b1105:-9b3] [user] .common.remoting.CookieSnipingHttpClient - Invoking https://******:8343/ci66/remote/Campaign 2024-06-27 13:28:06,618 TRACE [tomcat-http--76] [12255056afb9240e:-6a2c9f6a:190592b1105:-9b3] [user] springframework.web.method.HandlerMethod - Invoking [CampaignController.handleCIException] method with arguments [com.sas.ci.services.common.error.cTException: The requested object no longer exists.] 2024-06-27 13:28:06,618 TRACE [tomcat-http--76] [12255056afb9240e:-6a2c9f6a:190592b1105:-9b3] [user] springframework.web.method.HandlerMethod - Method [handleCIException] returned [<400 Bad Request, com.sas.commons.rest.util.Error07b20c206[version=1,status=400,err=0,message=The requested object no longer exists.,detail=[], remediation=, links=[]],{}>]
2. An error when going to the "Administration -> Lockouts" tab
SASCustIntelCore.log.
2024-06-27 16:48:22,359 DEBUG [CIAsyncExec-1267] [12255056afb9240e:-6a2c9f6a:19059ed1413:-6008] [user] s.analytics.crm.cm.ejb.CampaignProxyImpl - <- closeCampaign 2024-06-27 16:48:22,359 DEBUG [CIAsyncExec-1267] [] [] nalytics.crm.security.ejb.MASessionCache - Decremented session counter for session ID: 12255056afb9240e:-6a2c9f6a:19059ed1413:-6008 - 2 -> 1 2024-06-27 16:48:29,166 DEBUG [tomcat-http--60] [12255056afb9240e:-6a2c9f6a:19059ed1413:-6008] [user] com.sas.analytics.crm.ejb.CMFlexPlugin - Retrieving list of locked objects 2024-06-27 16:48:29,838 ERROR [tomcat-http--60] [12255056afb9240e:-6a2c9f6a:19059ed1413:-6008] [user] com.sas.analytics.crm.ejb.CMFlexPlugin - Unable to retrieve list of locked objects. com.sas.analytics.crm.error.client.ApplicationException at com.sas.analytics.crm.security.ejb.SecurityManagerBean.getLocks(SecurityManagerBean.java:1340) at com.sas.analytics.crm.ejb.CMFlexPlugin.getLockedObjects(CMFlexPlugin.java:247) at sun.reflect.GeneratedMethodAccessor2926.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) at org.springframework.remoting.support.RemoteInvocationTraceInterceptor.invoke(RemoteInvocationTraceInterceptor.java:77) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at com.sun.proxy.$Proxy623.getLockedObjects(Unknown Source) at sun.reflect.GeneratedMethodAccessor2925.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.springframework.remoting.support.RemoteInvocation.invoke(RemoteInvocation.java:205) at org.springframework.remoting.support.DefaultRemoteInvocationExecutor.invoke(DefaultRemoteInvocationExecutor.java:38) at sun.reflect.GeneratedMethodAccessor279.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) at com.sas.svcs.remoting.aspects.RemoteInvocationInterceptor.invoke(RemoteInvocationInterceptor.java:77) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:91) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at com.sun.proxy.$Proxy596.invoke(Unknown Source) at org.springframework.remoting.support.RemoteInvocationBasedExporter.invoke(RemoteInvocationBasedExporter.java:78) at org.springframework.remoting.support.RemoteInvocationBasedExporter.invokeAndCreateResult(RemoteInvocationBasedExporter.java:114) at org.springframework.remoting.httpinvoker.HttpInvokerServiceExporter.handleRequest(HttpInvokerServiceExporter.java:90) at org.springframework.web.servlet.mvc.HttpRequestHandlerAdapter.handle(HttpRequestHandlerAdapter.java:49) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:933) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:867) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:951) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:853) at javax.servlet.http.HttpServlet.service(HttpServlet.java:660) at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:827) at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:311) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:311) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:116) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at com.sas.svcs.webapp.servlet.filters.SecurityFilter.onDoFilter(SecurityFilter.java:80) at com.sas.framework.webapp.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:82) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at com.sas.svcs.security.authentication.web.filters.TgtKeepAliveFilter.doFilterInternal(TgtKeepAliveFilter.java:59) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:106) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at com.sas.svcs.security.authentication.web.filters.SessionIdentifierFilter.doFilterInternal(SessionIdentifierFilter.java:38) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:106) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:182) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at com.sas.svcs.security.authentication.session.jasig.SingleSignOutFilter.doFilterInternal(SingleSignOutFilter.java:60) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:106) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at com.sas.svcs.security.authentication.web.filters.RevokableTokenLogoutFilter.doFilter(RevokableTokenLogoutFilter.java:38) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at com.sas.svcs.security.authentication.web.csrf.CsrfSynchronizerTokenFilter.doFilterInternal(CsrfSynchronizerTokenFilter.java:178) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:106) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at com.sas.svcs.security.authentication.web.filters.CsrfRefererCheckerFilter.doFilterInternal(CsrfRefererCheckerFilter.java:909) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:106) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at com.sas.framework.webapp.servlet.ApplicationNameFilter.onDoFilter(ApplicationNameFilter.java:55) at com.sas.framework.webapp.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:82) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:173) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at com.sas.ci.services.common.spring.filters.SecurityContextCleanupFilter.onDoFilter(SecurityContextCleanupFilter.java:34) at com.sas.framework.webapp.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:82) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:173) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:543) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:690) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:747) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:615) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:818) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1627) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:748) Caused by: java.lang.NullPointerException at com.sas.analytics.crm.persistence.metadata.MAOMRQueries.getAllLocksConciseBySession(MAOMRQueries.java:1993) at com.sas.analytics.crm.security.ejb.SecurityManagerBean.getLocks(SecurityManagerBean.java:1320) ... 114 more 2024-06-27 16:48:29,839 ERROR [tomcat-http--60] [12255056afb9240e:-6a2c9f6a:19059ed1413:-6008] [user] com.sas.analytics.crm.ejb.CMFlexPlugin - Encountered client exception:null com.sas.analytics.crm.error.client.ApplicationException at com.sas.analytics.crm.security.ejb.SecurityManagerBean.getLocks(SecurityManagerBean.java:1340) at com.sas.analytics.crm.ejb.CMFlexPlugin.getLockedObjects(CMFlexPlugin.java:247) at sun.reflect.GeneratedMethodAccessor2926.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) at org.springframework.remoting.support.RemoteInvocationTraceInterceptor.invoke(RemoteInvocationTraceInterceptor.java:77) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at com.sun.proxy.$Proxy623.getLockedObjects(Unknown Source) at sun.reflect.GeneratedMethodAccessor2925.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.springframework.remoting.support.RemoteInvocation.invoke(RemoteInvocation.java:205) at org.springframework.remoting.support.DefaultRemoteInvocationExecutor.invoke(DefaultRemoteInvocationExecutor.java:38) at sun.reflect.GeneratedMethodAccessor279.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) at com.sas.svcs.remoting.aspects.RemoteInvocationInterceptor.invoke(RemoteInvocationInterceptor.java:77) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:91) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at com.sun.proxy.$Proxy596.invoke(Unknown Source) at org.springframework.remoting.support.RemoteInvocationBasedExporter.invoke(RemoteInvocationBasedExporter.java:78) at org.springframework.remoting.support.RemoteInvocationBasedExporter.invokeAndCreateResult(RemoteInvocationBasedExporter.java:114) at org.springframework.remoting.httpinvoker.HttpInvokerServiceExporter.handleRequest(HttpInvokerServiceExporter.java:90) at org.springframework.web.servlet.mvc.HttpRequestHandlerAdapter.handle(HttpRequestHandlerAdapter.java:49) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:933) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:867) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:951) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:853) at javax.servlet.http.HttpServlet.service(HttpServlet.java:660) at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:827) at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:311) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:311) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:116) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at com.sas.svcs.webapp.servlet.filters.SecurityFilter.onDoFilter(SecurityFilter.java:80) at com.sas.framework.webapp.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:82) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at com.sas.svcs.security.authentication.web.filters.TgtKeepAliveFilter.doFilterInternal(TgtKeepAliveFilter.java:59) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:106) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at com.sas.svcs.security.authentication.web.filters.SessionIdentifierFilter.doFilterInternal(SessionIdentifierFilter.java:38) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:106) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:182) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at com.sas.svcs.security.authentication.session.jasig.SingleSignOutFilter.doFilterInternal(SingleSignOutFilter.java:60) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:106) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at com.sas.svcs.security.authentication.web.filters.RevokableTokenLogoutFilter.doFilter(RevokableTokenLogoutFilter.java:38) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at com.sas.svcs.security.authentication.web.csrf.CsrfSynchronizerTokenFilter.doFilterInternal(CsrfSynchronizerTokenFilter.java:178) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:106) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at com.sas.svcs.security.authentication.web.filters.CsrfRefererCheckerFilter.doFilterInternal(CsrfRefererCheckerFilter.java:909) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:106) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at com.sas.framework.webapp.servlet.ApplicationNameFilter.onDoFilter(ApplicationNameFilter.java:55) at com.sas.framework.webapp.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:82) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:173) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at com.sas.ci.services.common.spring.filters.SecurityContextCleanupFilter.onDoFilter(SecurityContextCleanupFilter.java:34) at com.sas.framework.webapp.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:82) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323) at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:173) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:543) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:690) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:747) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:615) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:818) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1627) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:748) Caused by: java.lang.NullPointerException at com.sas.analytics.crm.persistence.metadata.MAOMRQueries.getAllLocksConciseBySession(MAOMRQueries.java:1993) at com.sas.analytics.crm.security.ejb.SecurityManagerBean.getLocks(SecurityManagerBean.java:1320)
SASCustIntelStudio.log
2024-06-27 16:48:28,945 TRACE [tomcat-http--84] [12255056afb9240e:-6a2c9f6a:19059ed1413:-5ff9] [user] springframework.web.method.HandlerMethod - Invoking [AdminController.getLockedObjects] method with arguments [] 2024-06-27 16:48:29,142 INFO [tomcat-http--84] [12255056afb9240e:-6a2c9f6a:19059ed1413:-5ff9] [user] vices.common.permissions.PermissionsBean - Capabilities retrieved 2024-06-27 16:48:29,142 DEBUG [tomcat-http--84] [12255056afb9240e:-6a2c9f6a:19059ed1413:-5ff9] [user] vices.common.permissions.PermissionsBean - List of capabilities for Customer Intelligence Studio 6.6: [CIUseBusinessContextsPlugin, CIUseUserSessionsPlugin, CIUseLocksPlugin, CIUseEnvironmentSettingsPlugin] 2024-06-27 16:48:29,142 DEBUG [tomcat-http--84] [12255056afb9240e:-6a2c9f6a:19059ed1413:-5ff9] [user] ..ci.services.common.admin.AdminProxyImpl - hasCapability(): Check if user has capability: CIUseLocksPlugin=true 2024-06-27 16:48:29,144 DEBUG [tomcat-http--84] [12255056afb9240e:-6a2c9f6a:19059ed1413:-5ff9] [user] .registry.impl.SharedServiceRegistryImpl - Created Registered Service: /Plugin[Url=https://*******:8343/ci66/remote/Plugin, secured=true, type=Java, id=null, serviceInterface=com.sas.analytics.crm.ejb.client.CMFlexPluginInterface, namespace=null, version=0.0.0, keywords=[], properties=[IsSecured:true, IsGenerated:false, ServiceType: Java], dependencies=[1] with URL: https://*******:8343/ci66 2024-06-27 16:48:29,145 DEBUG [tomcat-http--84] [12255056afb9240e:-6a2c9f6a:19059ed1413:-5ff9] [user] emoting.CIServicesInvokerRequestExecutor - tomcat-http--84: doExecuteRequest on 6e778f13 3397cea5 775dcec4 2024-06-27 16:48:29,145 debuG [tomcat-http--84] [12255056afb9240e:-6a2c9f6a:19059ed1413:-5ff9] [user] .common.remoting.CookieSnipingHttpClient - 775DCEC4: Parameter HASH: hc=0/me=B5B0A73/st=0 2024-06-27 16:48:29,145 DEBUG [tomcat-http--84] [12255056afb9240e:-6a2c9f6a:19059ed1413:-5ff9] [user] .common.remoting. CookieSnipinglittpClient - 775DCEC4: Setting cookie on state[7A3FCIED]: Cookie: e736f2c2c50b189b0961df92a55f4114 Cluster6;/;*******;null;68AF24581C91878B608B7EFF4A8B24C1.e736f2c2c50b189b0961df92a55f4114 SASServer6 2024-06-27 16:48:29,145 DEBuG [tomcat-http--84] [12255056afb9240e:-6a2c9f6a:19059ed1413:-5L[9] [user] .common.remoting.CookieSnipingHttpClient - 775DCEC4: Setting cookie on state[7A3FClED]: Cookie: e736f2c2c50b189b0961df92a55f4114 Cluster6;/;*******;null;3411763C7F5F70243BA4FCADEA0A2922.e736f2c2c50b189b0961df92a55f4114 SASServer6 1 2024-06-27 16:48:29,145 dEBuG [tomcat-http--84] [12255056afb9240e:-6a2c9f6a:19059ed1413:-5ff9] [user] .common.remoting.CookieSnipingHttpClient - Invoking https://*******:8343/ci66/remote/Plugin 2024-06-27 16:48:29,863 ERROR [tomcat-http--841 [12255056afb9240e:-6a2c9f6a:19059ed1413:-5ff9] [user] .ci.services.common.admin.AdminProxyImpl - An error has occurred. See the log files for details. com.sas.ci.services.common.error.CIException: An error has occurred. See the log files for details. at com.sas.analytics.crm.ejb.BaseProxyImpl.handleException(BaseProxyImpl.java: 651) at com.sas.analytics.crm.ejb.CMFlexPlugin.getLockedObjects (CMFlexPlugin.java:319)
Only restarting the session helps. At the same time, the error is reproduced again after successful closing of any campaign What attempts were made to resolve the problem:
1. Completely recreated both LDAP and Internal account - didn't help
2. log in both LDAP and Internal account - didn't help.
3. Used SASManagementConsole server client to create a user - didn't help Identical users with the same rights do not see any errors. Can you tell me what else I can check? Perhaps someone has encountered such a problem. Can this problem relay to Browser settings?
... View more
07-01-2024
05:58 AM
Hello there!
I have two compute tiers (two object spawners).
One for running SAS MA campaigns in real time and another one for scheduling SAS MA campaigns.
It's easy to change the scheduling server, but I don't know how to change the default compute tier.
For example, when I press the run campaign button in the SAS MA web interface, how to change the executing server?
I need to set the pooled workspace server in the second compute tier as default.
... View more
04-10-2024
08:54 AM
It was the problem with value RPO_PLAN_MEMBER_SK in the table DI_DM.RPO_PLAN_MEMBER.
Id has become more than MAX_VALUE of int in the C language.
So it was an overflow problem.
... View more
04-07-2024
01:37 PM
Hi all!
I'm facing a problem with SASMerchIntelGridSvr5.41. If you run plan optimization in Regular Price Plans in SAS Merchandise Intelligence, an error appears in the interface: ERROR: A fatal error was encountered while processing the STP request.
An error appears in the SASMerchIntelGridSvr5.41 log:
2024-04-05 18:54:53,131 [http-bio-5191-exec-8-0509] DEBUG com.sas.solutions.di.server.invoke - <- com.sun.proxy.$Proxy13.getRequestStatus took 3 ms. 2024-04-05 18:55:00,994 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - TKMI LOG: sk-sas-grid: rpo_optimize.2.log (LOCAL) 2024-04-05 18:55:00,994 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - 2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - <U+FEFF>20240405:18.54.45.93: running command: run='rpo_optimize' 2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - 20240405:18.54.45.97: Loading Dim for partition_id=1 gps=0 sk=244810 2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - 20240405:18.54.57.34: Completed Loading Dim for partition_id=1 gps=0 sk=244810 in 11 second s (dim -> 162 MB/s, io adapter -> ~0.0 MB/s) 2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - 20240405:18.54.58.70: ERROR: consumer thread 'c_(null)' encountered a fatal error 2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - 20240405:18.54.58.70: 2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - ERROR: TKTException code = 10 (Domain exception) 2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - from /sas/SASHome/SASFoundation/9.4/sasexe/tkmi.so 2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - #4 0x00007fede1e00c46 in tkmi_exception_handler () 2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - from /sas/SASHome/SASFoundation/9.4/sasexe/tkmi.so 2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - #5 0x00007fedf000d3f2 in bktExcept () 2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - from /sas/SASHome/SASFoundation/9.4/sasexe/tkmk.so 2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - #6 0x00007fedf0011d0d in bkt_fpe () 2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - from /sas/SASHome/SASFoundation/9.4/sasexe/tkmk.so 2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - #7 0x00007fedf000da44 in bkt_signal_handler () 2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - from /sas/SASHome/SASFoundation/9.4/sasexe/tkmk.so 2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - #8 <signal handler called> 2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - #9 0x00007fede1dfc153 in io_get_int () 2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - from /sas/SASHome/SASFoundation/9.4/sasexe/tkmi.so 2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - #10 0x00007fede20a538e in rpo_plan_member_cb () 2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - from /sas/SASHome/SASFoundation/9.4/sasexe/tkmi.so 2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - #11 0x00007fede1df7834 in process_rows () 2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - from /sas/SASHome/SASFoundation/9.4/sasexe/tkmi.so 2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - #12 0x00007fedf000b494 in sktMain () 2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - from /sas/SASHome/SASFoundation/9.4/sasexe/tkmk.so 2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - #13 0x00007fedf000d231 in bktMain () 2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - from /sas/SASHome/SASFoundation/9.4/sasexe/tkmk.so 2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - #14 0x00007fedf1418ea5 in 2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - 20240405:18.54.58.70: start_thread () from /lib64/libpthread.so.0 2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - #15 0x00007fedf0a04b0d in clone () from /lib64/libc.so.6 2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - 2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - 2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - 2
2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - 2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - 20240405:18.54.58.70: ERROR: Assertion failed: ! this->pc_error, file /sas/wky/mva-m1ro541/di/src/input_adapter.c, line 726 2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - 20240405:18.54.58.70: Error while reading table '(null)' (see previous error message(s)) 2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - 2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - 20240405:18.54.59.83: 2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - ERROR: TKTException code = 6 (Access violation) 2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - from /sas/SASHome/SASFoundation/9.4/sasexe/tkmi.so 2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - #4 0x00007fede1e00c46 in tkmi_exception_handler () 2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - from /sas/SASHome/SASFoundation/9.4/sasexe/tkmi.so 2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - #5 0x00007fedf000d3f2 in bktExcept () 2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - from /sas/SASHome/SASFoundation/9.4/sasexe/tkmk.so 2024-04-05 18:55:00,995 [RequestThread-359077] DEBUG com.sas.solutions.di.tkmiserver.dispatcher.TKMI - #6 0x00007fedf000da44 in bkt_signal_handler () 2024-
... View more
03-19-2024
06:07 AM
Hello, experts!
We have two SAS clusters that are deployed on different servers. Let it be SERVER 1 and SERVER 2.
We have a problem with selecting data from oracle database table on SEVER 1. Part of log with query and error looks like this:
------------------SERVER 1 LOG---------------------------
LIBNAME DWH_R ORACLE PRESERVE_COL_NAMES=YES
PRESERVE_TAB_NAMES=YES DBMAX_TEXT=32767 READBUFF=7500 INSERTBUFF=7500 PATH=*** SCHEMA=*** USER=***
PASSWORD=***
NOTE: Libref DWH_R was successfully assigned as follows:
Engine: ORACLE Physical Name: *** options validvarname=any; options sastrace=',,,ds' sastraceloc=saslog nostsuffix sql_ip_trace=(note, source) msglevel=i fullstimer;
proc sql dquote=ansi; select * from dwh_r.'S0208$KBS_CHAT_BOT_SUGGEST'n;
ORACLE_4: Prepared: on connection 21 SELECT * FROM "DWH_STAGE2"."S0208$KBS_CHAT BOT_SUGGEST"
Summary Statistics for ORACLE are: Total SQL prepare seconds were: 0.000822 Total seconds used by the ORACLE ACCESS engine were 0.002057
ERROR: This DBMS table or view cannot be accessed by the SAS System because it contains column names that are normalized (uppercased) compare is performed. See "Naming Conventions" in the SAS/ACCESS documentation. not unique
------------------SERVER 1 LOG---------------------------
We think, that the problem is due to certain long names of table fields, which after being cut off (SAS accepts field names of no more than 30 characters) become the same like this two fields with long labels:
But in SAS, there is a special VALIDVARNAME option, which in any case will change the name to a unique one by adding an index to the end of the name, as shown in "Name" field in the picture above. This is what happens on our SERVER 2 (part of log with query):
------------------SERVER 2 LOG---------------------------
LIBNAME DWH_R ORACLE PRESERVE_COL_NAMES=YES
PRESERVE_TAB_NAMES=YES DBMAX_TEXT=32767 READBUFF=7500 INSERTBUFF=7500 PATH=*** SCHEMA=*** USER=***
PASSWORD=***
NOTE: Libref DWH_R was successfully assigned as follows:
Engine: ORACLE Physical Name: *** options validvarname=any; options sastrace=',,,ds' sastraceloc=saslog nostsuffix sql_ip_trace=(note, source) msglevel=i fullstimer;
proc sql dquote=ansi outobs=10; select * from dwh_r.'S0208$KBS_CHAT_BOT_SUGGEST'n;
ORACLE_5: Prepared: on connection 6 SELECT * FROM "DWH_R"."S0208$KBS_CHAT BOT_SUGGEST"
SQL_IP_TRACE: None of the SQL was directly passed to the DBMS.
ORACLE_6: Executed: on connection 6
SELECT statement ORACLE_5
WARNING: Statement terminated early due to OUTOBS=10 option.
Summary Statistics for ORACLE are: Total row fetch seconds were: 0.336985 Total SQL execution seconds were: 0.031686 Total SQL prepare seconds were: 0.001000 Total seconds used by the ORACLE ACCESS engine were 1.934726
NOTE: Procedure SQL used (Total process time):
------------------SERVER 2 LOG---------------------------
What points have been checked already?
different combination of validvarname and validmemname options (this did not help)
output comparison of proc options command on both workspace server's (this did not help)
Attempt to reproduce the error on SERVER 2 (this step was unsuccessful)
Both servers use SAS 9.4:
SERVER 1 - 9.4 (TS1M3)
SERVER 2 - 9.4 (TS1M7)
There is a feeling that SAS on SERVER 1 does not respond to the VALIDVARNAME option. Can version of SAS affect this?
We also found SAS note for this error - 16835 - An error occurs when DBMS tables do not have unique column names and you try to reference a specific table in SAS® code. It suggests creating a VIEW of this table, but we want to avoid this, because on SERVER 2, select to the table works perfectly without creating a VIEW.
I will be grateful for any useful information and any thoughts on this matter!
... View more
01-25-2024
09:40 AM
Hello, experts!
Periodically, we encounter a problem when a queue of unfulfilled campaigns that have been scheduled begins to accumulate in the LSF scheduler. At the same time, in the SASCICore logs of the 6th server, we see that the campaigns have been completed, but for some reason SASServer6 does not send a response about the execution to the scheduler. There are no errors in the logs. Restarting SASServer6 solves this problem and everything returns to normal. We believe that the reason is caused by an overflow of HEAP memory on the 6th server, since we saw peak values in the Garbage Collector logs and at this point a problem could occur. Has anyone else encountered a similar problem? Are there any ways to solve it?
... View more
11-27-2023
05:02 AM
1 Like
Thanks you! Need to change in Scheduler manager a param in execute command of job from -logparm "rollover=session" to -logparm "rollover=session write=IMMEDIATE"
... View more
11-23-2023
08:20 AM
Hello there!
I noticed StoredProcessServer writes a log real-time. If I turn on tracing of db requests:
OPTIONS SASTRACE=',,,ds' sastraceloc=saslog nostsuffix sql_ip_trace=(note,source) msglevel=i fullstimer;
I see what StoredProcessServer do right now.
But BatchServer uses another way. It writes information only when data step have done fully.
How to configure BatchServer for logging information in real-time?
... View more
10-27-2023
08:47 AM
2 Likes
The cause of this error could not be found. But we managed to use the following workaround:
Using bhist -all, determine the error status in LSF with which the jobs are falling (in our case Exit code=102. Also with SIGSEGV, Exit code=139 is possible)
Define the queue in which the jobs are executed (in our case QUEUEUE_NAME=normal. The queue name is also specified when using bhist -all)
In the file <LSF-root-directory>/conf/lsbatch/sas_cluster/configdir/lsb.queues Add the REQUEUE_EXIT_VALUES and MAX_JOB_REQUEUE parameters: ... Begin Queue QUEUEUE_NAME=normal ... REQUEUE_EXIT_VALUES=139 102 MAX_JOB_REQUEUE=3 ... End Queue ...
Save the changes
This will allow LSF to restart jobs in case of errors 139 and 102. The number of restarts is adjusted in MAX_JOB_REQUEUE. In our case it is 3 times.
... View more
10-26-2023
11:44 AM
The problem is that the error occurs at the stage of running the command itself, which I specified in the problem description.
... View more
10-26-2023
09:50 AM
1) Yes, we have multiple machines. SEGVs happen on a specific machine 2) This happens for user "lsfadmin", because the scheduled job is running under that user 3) No, it may happen for different sas programs 4) It most often occurs in a specific time frame that is fairly spread out over a period of time
... View more
