03-20-2025
John_Wick
Obsidian | Level 7
Member since
08-19-2022
- 42 Posts
- 6 Likes Given
- 9 Solutions
- 5 Likes Received
-
Latest posts by John_Wick
Subject Views Posted 343 03-14-2025 05:44 AM 578 11-28-2024 06:22 AM 1219 11-25-2024 01:43 PM 673 11-06-2024 02:22 PM 1037 11-06-2024 02:10 PM 1551 08-13-2024 12:34 PM 1540 07-19-2024 12:36 PM 942 07-16-2024 04:27 AM 1060 07-03-2024 04:24 AM 1122 07-02-2024 01:13 PM -
Activity Feed for John_Wick
- Posted Proc Infomaps log in exception on Administration and Deployment. 03-14-2025 05:44 AM
- Posted Re: Function sequence error (SAS Federation Server) on SAS Programming. 11-28-2024 06:22 AM
- Posted Function sequence error (SAS Federation Server) on SAS Programming. 11-25-2024 01:43 PM
- Posted Multiple user credentials in one library on Administration and Deployment. 11-06-2024 02:22 PM
- Posted Re: SAS CIS communication export to kafka topic on Administration and Deployment. 11-06-2024 02:10 PM
- 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
-
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
03-14-2025
05:44 AM
Hello, experts!
I have problem with running proc infomaps. When I run simple code like:
proc infomaps;
run;
Then I get error:
Top Exception:
[ com.sas.services.deployment.ServiceDeploymentException: A SAS foundation service failed to deploy. ]
[ com.sas.services.ServiceException: Unable to obtain service from factory class com.sas.services.user.UserServiceFactory. ]
[ java.lang.NoClassDefFoundError: com/sas/services/security/login/ExpiredCredentialException ] Root Exception: [ java.lang.ClassNotFoundException: com.sas.services.security.login.ExpiredCredentialException ] ERROR: The procedure was unable to log in the user.
Is there a way to understand why the error is happening and fix it?
... View more
11-28-2024
06:22 AM
I apologise, my mistake. The problem was that I used functions incorrectly. To make my code work, you need to add additional lines:
proc ds2;
data _NULL_;
method run();
dcl int output_var;
dcl package sqlstmt s('SELECT 1 FROM CDM.RTDMCDM1.CI_CAMPAIGN'); s.execute(); s.fetch();
output_var = s.getInt(1);
end;
enddata;
run;
quit;
... View more
11-25-2024
01:43 PM
Hello, experts
When I try to make a simple query select and put the result into a variable on Federation Server using DS2 code, I get the following error
EG log:
ERROR: Function sequence error
ERROR: GETINTEGER for column 1 failed on result set of SQL Statement: select 1 from CDM.RTDMCDM1.CI_CAMPAIGN
Federation server log:
2024-11-25T20:44:33,825 TRACE [00028094] App.Statement.Statement.GetDiagRecs 458:sasdmadm@saspw - IOM RETURN 0={compRef:7f0166c5e800}->Statement::GetDiagRecs(): sqlStates=[0…1] [0]=HY000 [1]=HY010 nativeerror=[0.1] [0]=-2038444017 [1]=-2130708356 message text=[0.1] [[0]=GETINTEGER for column 1 failed on result set of SQL statement: select 1 as output_var from CDM.RTDMCDM1.CI_CAMPAIGN [1]=Function sequence error status=[0…1] [0]=0 [1]=0
The code looks like this:
proc ds2;
data _NULL_;
method run();
dcl int output_var;
dcl package sqlstmt s('SELECT 1 FROM CDM.RTDMCDM1.CI_CAMPAIGN');
output_var = s.getInt(1);
end;
enddata;
run;
quit;
Can you tell me what this error might be related to?
This problem is observed with functions like getInt, getchar, etc.
... View more
11-06-2024
02:22 PM
Hello, experts!
Has anyone encountered the need to use one library for different users? Could you please advise if this can be realised using the regular Managemnet Console apparatus (not using autoexec custom, but using User manager)?
For example, there is a TEST library and two users: TEST_USER1 and TEST_USER2. Each user has a different set of permissions on objects at the database level. We want to have one library in the Management console, but depending on the current user (groups he/she is a member of) when using it on Stored Process Server, Pooled Workspace Server and Workspace server, the connection string to the library includes either credentials of TEST_USER1 or TEST_USER2.
... View more
11-06-2024
02:10 PM
Hello @Sajid01
Now we have stopped at the integration of Java+sas in order to connect the communication node with kafka in SAS CIStudio. Ideologically it looks as follows: 1. At the SAS level in the additional characteristics selects a bunch of json template of a certain format + Kafka topic for each communication channel (email, sms, push) from the table-dictionary. 2. In the communication node (maexp script) the selected segment is written to the integration table 3. The segment is fetched from the integration table with a certain interval by the java profile. 4. The profile pulls up the json template required by the topic and enriches it with data for each customer 5. Then using Kafka template the generated json is sent to the required topic
... View more
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