cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
RTDM_User
‎01-20-2020
  • 8 Posts
  • 2 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Problem with converting DB table to RTDM TABLE with datetime colum...

by Fluorite | Level 6 in SAS Customer Intelligence
‎10-28-2019 09:27 AM
‎10-28-2019 09:27 AM
Thank you very much for the response,   where should i put it in my code? how do i insert this "converted" column to an RTDM Table as described above?   "newRow.columnDataSet(..." ?    OR    other way?   its a multiple row table with 20 columns. ... View more

Problem with converting DB table to RTDM TABLE with datetime column - ...

by Fluorite | Level 6 in SAS Customer Intelligence
‎09-24-2019 08:56 AM
‎09-24-2019 08:56 AM
Hi everybody,   I'm having problems get columns and data rows of datetime value from DB and make it a rtdm table (data grid),   something is wrong in the get...() function syntex,   trying to run the code: import org.apache.log4j.Logger import java.sql.Connection import java.sql.PreparedStatement import java.sql.ResultSet import java.sql.SQLException import org.apache.commons.logging.Log import org.apache.commons.logging.LogFactory import com.sas.analytics.ph.common.RTDMTable import com.sas.analytics.ph.common.RTDMTable.Row import com.sas.analytics.ph.common.exp.SymbolTable import com.sas.analytics.ph.common.jaxb.DataTypes import com.sas.rtdm.implementation.engine.EventInfo import javax.sql.DataSource   . . .   RTDMTable TABLE; TABLE = new RTDMTable(); TABLE.columnAdd("stringcol", DataTypes.STRING, Collections.emptyList()); TABLE.columnAdd("floatcol", DataTypes.FLOAT, Collections.emptyList()); TABLE.columnAdd("datecol", DataTypes.DATETIME, Collections.emptyList()); . . .   /*get rows and columns by query from DB stmt = conn.prepareStatement(queryToSubmit)   . . .   Row newRow = TABLE.rowAdd() newRow.columnDataSet("stringcol", rs.getString(1)) newRow.columnDataSet("floatcol", rs.getDouble(2)) newRow.columnDataSet("datecol", rs.getDateTime(3))   . . .   -------- ERROR: Caused by: groovy.lang.MissingMethodException: No signature of method: org.apache.commons.dbcp.DelegatingResultSet.getDateTime() is applicable for argument types: (java.lang.Integer) values: [3] Possible solutions: getDate(int), getTime(int), updateTime(int, java.sql.Time), getDate(java.lang.String), getDate(int, java.util.Calendar), getTime(java.lang.String)   HELP 🙂 ?   ... View more

Re: Groovy code error - Rest Post to API (RTDM SAS PROC)

by Fluorite | Level 6 in SAS Customer Intelligence
‎02-03-2019 09:45 AM
‎02-03-2019 09:45 AM
Hi james and thank you for answering, I don’t think that the use of RESTClient causing the error because before the current POST method I’ve tried and succeed with get method (called the api and got the json response). I assume that I don’t have the correct syntax for activating the POST method. Do you have an example of post rest via groovy? Tnx, Itay.     ... View more

Groovy code error - Rest Post to API (RTDM SAS PROC)

by Fluorite | Level 6 in SAS Customer Intelligence
‎01-30-2019 04:50 AM
‎01-30-2019 04:50 AM
HI,   HELP needed with java.lang.NullPointerException ERROR,   I’m trying to run the code below (i have imported all the necessary packages) -    def slurper = new groovy.json.JsonSlurper() def result = slurper.parseText('{"name":["itay","omer","shlomi","rotem"],"age":30}') def client = new RESTClient( 'http://localhost:3000' ) writeToFile("JSON REQ1") writeToFile(result) def resp = client.post( path : '/testrtdm', ContentType: JSON, body: result,   and getting error without any explanation –   com.sas.analytics.ph.RTDMException: Failure running user groovy activity at com.sas.analytics.crm.rtdm.activities.GroovyClassActivity.execute(GroovyClassActivity.java:279) at com.sas.rtdm.implementation.EventExecutor.execute(EventExecutor.java:243) at com.sas.rtdm.implementation.TestExecutor.execute(TestExecutor.java:209) at com.sas.rtdm.implementation.engine.ActivityNode._execute(ActivityNode.java:58) at com.sas.rtdm.implementation.engine.ActivityNode._execute(ActivityNode.java:18) at com.sas.rtdm.implementation.engine.SchedulableNode$1.call(SchedulableNode.java:89) at com.sas.rtdm.implementation.engine.SchedulableNode$1.call(SchedulableNode.java:82) at java.util.concurrent.FutureTask.run(FutureTask.java:266) 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: java.lang.NullPointerException at groovyx.net.http.HTTPBuilder$RequestConfigDelegate.setBody(HTTPBuilder.java:1200) at groovyx.net.http.HTTPBuilder$RequestConfigDelegate.setPropertiesFromMap(HTTPBuilder.java:1111) at groovyx.net.http.HTTPBuilder$RequestConfigDelegate.<init>(HTTPBuilder.java:946) at groovyx.net.http.RESTClient.post(RESTClient.java:140) at groovyx.net.http.RESTClient$post$0.call(Unknown Source) at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:47) at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:116) at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:128) at MyActivity.run(script1548768272512393757402.groovy:54) at com.sas.analytics.crm.rtdm.activities.GroovyClassActivity.execute(GroovyClassActivity.java:267) ... 10 more   ... View more

RTDM – approach to web service and get grid variable in Reply

by Fluorite | Level 6 in SAS Customer Intelligence
‎12-26-2018 08:39 AM
‎12-26-2018 08:39 AM
Hi, I need to approach a web service from rtdm campaign to Web Service and get in return few variables that one of them is in data grid structure. I guess it’s possible with OOTB Web Process or Groovy / DS2 code in sas process and then parse it in the suitable structure. What would be the better option and how to implement it?   TNX. ... View more

RTDM_Join_Func

by Fluorite | Level 6 in SAS Customer Intelligence
‎10-08-2017 03:56 AM
‎10-08-2017 03:56 AM
Hi Team,     1. how can i excute a left join between 2 tables (data grids) in the rtdm flow? (there isnt a custom func for it) 2. how can i excute join between 3 tables (data grids)? (without using 2 functions - just in one)   Thanks in advance, RTDM_User   ... View more

procedures in RTDM

by Fluorite | Level 6 in SAS Customer Intelligence
‎10-08-2017 03:50 AM
‎10-08-2017 03:50 AM
Hi Team,   I wanna excute a sql procedure using the RTDM,   Problem - so in order to do it i need to send a varibles from the flow to that procedure that was built in the DB (sql server) and get a varibles back to the flow,   is this possible ? if yes, what is the best solution for it?   Thanks in advance, RTDM_User ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎01-20-2020 01:35 PM
Likes given to
View All
Quick links