About jcawesome

jcawesome

Hi James, I would also assume that in order to make it 'highly available', you'll need to have separate instances of the agent placed in different midtier servers? if all placed in the same server, then it defeats the purpose. "Importantly the Metadata generation process (dm -gmd) is not supported when running multiple DM Agents." If the dm.sh -gmd is run in a midtier server with only one instance of the agent (given that the other instance of the agent is in a separate server), should this still be a problem? Regards, JC

jcawesome · ‎10-31-2023

If I stay with M7, how long will M7 be supported? UPDATED 23OCT2023: SAS 9.4M7 is in Standard Support until 01SEP2025. Please see this page for more details SAS 9.4 & Earlier Releases | SAS Support. I found this from this post: https://communities.sas.com/t5/Ask-the-Expert/Upgrading-to-the-Latest-Version-of-SAS-9-4-M8-Q-amp-A-Slides-and/ta-p/877920 Maybe just something to think about when upgrading. Another way I can think of is to perform a same server upgrade. It will require downtime on the server but it will be easier for 'migration'. If I remember correctly, you just need to republish and activate the objects. If your system doesn't allow for downtime then I would go for partial promotion to make sure that each components and RTDM flow is working as expected. It depends on the complexity of the system. Best if you can get help from a SAS I&C consultant and a SAS PSD consultant for efforts needed for such.

jcawesome · ‎10-31-2023

I'm also interested to know how this can be done 🙂

jcawesome · ‎03-07-2023

Hi All, I managed to export out the table by using a SAS program in SAS Studio. I first declared a PostgresDB Library. Then loaded the data from the CAS table (CASPG.SAMPLE_OUTPUT) into the postgres table (PGDB.SAMPLE_OUTPUT). My guess is that the CASPG library that I defined is a CAS library (loads data in-memory) hence the data doesn't really flow out to the DB. I repointed the TABLE node into the PGDB library. I truncated the data in the Postgres DB. Then I rerun the flow again. The data is now showing in the database. If anyone else has another solution or best practice for handling this node, please do share with the community. 🙂 Regards, JC

jcawesome · ‎03-07-2023

Hi Experts, I tried using the Execute Decisions Node in SAS Studio. The Flow is able to execute successfully. I can see the output result in this temp table in CAS. However, I don't see the data appended into the permanent CAS table I loaded (called 'SAMPLE_OUTPUT'). Questions: 1. Is it possible to load output results of the 'Execute Decision' node in SAS Studio into a table? After checking the SAS documentation, it doesn't show how to do this if it is possible. https://documentation.sas.com/doc/en/webeditorflows/v_001/p0h7s4r2t3uskpn0zh1x20gnze4p.htm#n0lja0dpdly6ujn1nnwgruh2flhz 2. If YES, how do I go about it? Are there any sample instructions online from SAS? 3. If NO, how does SAS expect the users to make use of the 'Execute Decision' node if results cannot be pulled out, processed and verified? Output Variables (Execute Decision Node) SAMPLE_OUTPUT table published columns. I matched the exact name with the Output of the Decision Flow. Note: I'm using Postgres DB. This DB has been configured already in SAS Viya. Thank you! Regards, Jan Carlo (JC)

jcawesome · ‎02-23-2023

Hi Olaf, I found something that might interest you (which you most probably know already) and the community. In Chrome, there's a setting under 'Privacy and Security' > 'Cookies and other site data' > 'Send a "Do Not Track" request with your browsing traffic' Originally this was turned ON in my Google Chrome browser. I think Google sets this as default (not sure). When this was turned ON, then I couldn't see the creative in the website. After turning it OFF as seen in the screenshot above, then the creative is appearing now in the browser. Note that in our CI360 Setting that "Honor the Do Not Track (DNT) setting if it is enabled" is selected. Maybe this is causing the non-delivery of the content. Please do correct me if I'm wrong. To test my theory: I changed the setting in CI 360 to ignore the DNT I turned ON the DNT in Google Chrome setting: I'm now able to see the content/creative in the Chrome browser even if DNT is ON. More details about DNT: Regards, JC

jcawesome · ‎02-23-2023

Hi Olaf, Thanks for the suggestion. I tried checking using inspector on what div class is showing up in both browsers. Screenshot below shows the div class for Firefox (note that it shows different content since CI 360 already replaced the content): Screenshot below shows the div class for Chrome: Another thing to take note: If I used Mozilla Firefox in 'Private Window' (similar to incognito in Chrome). It's showing the same behavior in Chrome (no creative is showing) which is strange. Here is how I defined the spot in CI360: div[id='comp-lef8bjmd'] > div.xPEAfP Note: I added the sas-ci360-hidden class as specified by another post here in SAS CI360 communities to take care of the 'flickering' issue in CI360. I'm going to try out a different spot if it makes any difference. Maybe use an 'image' object instead of a box container to see if it makes any difference. I'll share any new findings here if ever. Regards, JC

jcawesome · ‎02-23-2023

Hi Experts, I'm trying to see if the Default 'Creative' will show in the webpage when I load the page. I noticed that when I do it in Mozilla Firefox, the asset appears. But in Google Chrome, it doesn't appear. I investigated by Inspecting the 'Network'. Here are my findings: Both Firefox and Chrome shows that the tag is working as seen below with the files (ot-all.min.js and ot-min.js) Firefox shows the GET method for delivery-ci360.thakralonedemo.com. This contains the creative details (i.e. image source) Chrome doesn't contain the GET method for delivery-ci360.thakralonedemo.com. It does contain the GET method for the request URL to: https://execution-ci360.thakralonedemo.com. However, the asset is not getting delivered. Not sure if google is blocking it some way. How do I ensure the same behavior for both browsers? For your reference, I'm using the following browser versions: Firefox (v106.0.5) Google Chrome (Version 110.0.5481.178 (Official Build - latest version as of writing) Hoping you can give me an idea on one config to do. Thank you! Regards, JC

jcawesome · ‎04-22-2021

Hi @misko , I normally use this function - INTCK when comparing dates. For example, I have 2 dates: TODAY_calc and DATE_calc. I can subtract the DATE_calc from TODAY_calc and see if the difference is within 7 days or more than that. Check the value first using test mode to ensure your comparing the right values. intck('day', <<calculatedDataItems.TODAY_calc>>, <<calculatedDataItems.DATE_calc>>) Then use an IIF statement to add in your business logic. iif(intck('day', <<calculatedDataItems.TODAY_calc>>, <<calculatedDataItems.LEADACTIVITYDATE_calc>>) < 7, <<value if true>> ,<<value if false>>) I hope this can help you. 🙂

jcawesome · ‎02-07-2021

Hi @sTv , I think based on the logs the unknown option is "CHFBBY5XW3BGWNAC". You should place double dash "--" instead of one dash "-" /opt/config/Lev1/SASApp/MaLauncher/mabatch.sh -d camp -u sas_camp -g b405be418f549590da0eec4436c71647 -x "BC Residencial y Empresas" -v -- CHFBBY5XW3BGWNAC I haven't tried placing this in a log but I'm guessing it's as simple as adding ">" then "(log-location)/logname.log" /opt/config/Lev1/SASApp/MaLauncher/mabatch.sh -d camp -u sas_camp -g b405be418f549590da0eec4436c71647 -x "BC Residencial y Empresas" -v -- CHFBBY5XW3BGWNAC > /(log-location)/mabatch_exec.log Hope this helps. Regards, JC

jcawesome · ‎01-06-2021

Hi @ravindrrapaal , You must have crazy RTDM flows to have more than 150+ nodes in one diagram. Just curious on your work around for this kind of problem. Did you move some of the nodes into subdiagrams? Or just try consolidating some of the nodes into a SAS process node instead? Regards, JC

jcawesome · ‎01-06-2021

Hi @Shani_LS , I do think it's possible sine you can just pass the HTML code into the reply node as a 'string'. You can use SAS DS2 code to do any advanced manipulations you may need to create this HTML code and place it in a SAS Process node. I personally haven't tried this out myself. I've passed a string variable before with a paragraph of text with line breaks. Do you have any exact use case as to why you would want/need to pass HTML code? Maybe there's another solution that can be implemented. Regards, JC

jcawesome · ‎08-26-2020

Thanks @JamesAnderson . It's working now. The screenshots and the step by step approach helped me find what I was looking for. Regards, JC

jcawesome · ‎08-26-2020

Hi All, I figured out the solution to this problem in this SAS Communities Post: https://communities.sas.com/t5/Administration-and-Deployment/SAS-9-4M4-Proc-HTTP-Passing-Cookie-for-Web-Token-Authentication/td-p/427436 Once authentication is established the rest of the REST APIs to the SAS Decision Services Administration should be straightforward. Here's another reference for those who wants to use SAS code instead of Postman: https://support.sas.com/resources/papers/proceedings16/SAS6363-2016.pdf Regards, JC

jcawesome · ‎08-24-2020

Hi @rotemtav , But what field did you use in the SELECT node? I noticed that in your query that there's no WHERE statement meaning you're not doing any filtration. In MA, the select node filters out the customer base in order to select a small portion as the segment or sample size when running campaigns. Try using the same field in your filtration within MA and in the Information Map. Please share screenshots. Thank you! Regards, JC

Online Status	Offline
Date Last Visited	2 weeks ago

Re: How can we Make CI360 DM Agent Highly Available

Re: RTDM 6.5 to 6.6 migration to another server with same OS

Re: How can we Make CI360 DM Agent Highly Available

Re: How to load results from Execute Decision to OUTPUT table?

How to load results from Execute Decision to OUTPUT table?

Re: SAS CI360 not showing default creatives in Spot for Google Chrome....

Re: SAS CI360 not showing default creatives in Spot for Google Chrome....

SAS CI360 not showing default creatives in Spot for Google Chrome. But...

Re: Creating Calculated varible - compare response date with today

Re: mabatch.sh campaigns

Re: How can we Make CI360 DM Agent Highly Available

Re: Which SAS server to install CI360 Direct Agent

How can we Make CI360 DM Agent Highly Available

Creating model publishing destinations using the SAS Viya CLI

Re: SAS CI360 not showing default creatives in Spot for Google Chrome....

SAS CI360 not showing default creatives in Spot for Google Chrome. But...

Re: SAS CI360 not showing default creatives in Spot for Google Chrome....

Re: Accesing the SAS 9.4 M6 RTDM 6.5 SASDecisionServicesAdministration...

Accesing the SAS 9.4 M6 RTDM 6.5 SASDecisionServicesAdministration/res...

Re: RTDM API definition

Re: How can we Make CI360 DM Agent Highly Available

Re: RTDM 6.5 to 6.6 migration to another server with same OS

Re: How can we Make CI360 DM Agent Highly Available

Re: How to load results from Execute Decision to OUTPUT table?

How to load results from Execute Decision to OUTPUT table?

Re: SAS CI360 not showing default creatives in Spot for Google Chrome....

Re: SAS CI360 not showing default creatives in Spot for Google Chrome....

SAS CI360 not showing default creatives in Spot for Google Chrome. But...

Re: Creating Calculated varible - compare response date with today

Re: mabatch.sh campaigns

Re: Migration SAS CI Studio 6.5 to CI 6.6

Re: RTDM 6.6 SAS Version 9.4 M7 - transfer an HTML code in a reply nod...

Re: Accesing the SAS 9.4 M6 RTDM 6.5 SASDecisionServicesAdministration...

Re: Accesing the SAS 9.4 M6 RTDM 6.5 SASDecisionServicesAdministration...

Re: CI export issue

SUGA