topic Selecting table in RTDM Data Node in SAS Customer Intelligence

Selecting table in RTDM Data Node

sivaram_veerabagu — Wed, 18 Jan 2017 15:49:30 GMT

There is no tables are getting listed in the RTDM Data Node definitions. I am not sure what may be the cause for this issue?

Re: Selecting table in RTDM Data Node

shill — Wed, 18 Jan 2017 19:56:52 GMT

Make sure you have a Library System Resource in your Design repository that has the exact same name as your library in metadata.

Re: Selecting table in RTDM Data Node

sivaram_veerabagu — Mon, 23 Jan 2017 10:15:00 GMT

Hi Shill,

Thanks for your reply.

I am trying to use BASE SAS library. I have used the same name of the BASE SAS library in Design repository but still, the table is not listed in the Data process node.

I have used $SAS_Activity_Resource as a Connection Resource and it contains the following parameters.

Driver Class : com.sas.tkts.TKTSDriver

Server URL : jdbc:sastkts://host-name:24141/

Connection Option : DRIVER=TSSQL;CONOPTS=(DSN=BASE)

Username : sasdm

Password : ******

Also I have added the BASE SAS Library Schema in SAS Federation Server Manager.

Please let me have your view?

Regards,

Siva

Re: Selecting table in RTDM Data Node

shill — Mon, 23 Jan 2017 21:00:03 GMT

If your Activity Resource is using "BASE" and not "DSFederatedDSN" then I'm going go guess you're using an older version, probably 5.41? If you're using 6.X and that's how your environment is configured, you'll probably want to make some adjustments to meet best practices. (Also, beware of using SAS datasets because of the I/O time required to read from disk in a real-time application! You may not find it meets your performance requirements.)

But that's not directly related to why it's not showing up for you. The primary requirements are:

1. You have a metadata library with the table registered and metadata updated so you can see this list of columns and their data types in SMC.

2. You have a library system resource in your Design repository with the exact same name as the metadata library in #1 above. (Note: If you are in fact using an older version, you will actually need a 2nd library system resource in your Design repository with the exact same name as the LIBREF of the metadata library in #1 above in order for queries to execute successfully in test cases or in the engine execution.)

The UI part of choosing a table never actually goes as far as the Fed Server connection, it simply looks for all the Library System Resources in the Design Repository and then looks for Metadata Libraries with the same name. If both of those things are true in your environment, you'll probably need to open a track with SAS Technical Support.

Good luck!

Re: Selecting table in RTDM Data Node

sivaram_veerabagu — Tue, 24 Jan 2017 14:04:14 GMT

Thanks Shil,

I have managed to get the table listed in Data Process Node. There was a name mismatch between the Metadata library and the library in Decision Repository. I am using RTDM 6.3 version.

I have created a flow with the Data process node by passing the data grid variable as an input variable. When I tried to test the flow I got the below error in the log file.

"2017-01-24 10:14:30,462 INFO com.sas.rtdm.implementation.resource.JDBCConnectionPool - Resource $SAS_Activity_Resource Server URL jdbc:sastkts://host-name :24141/ is out of service

com.sas.analytics.ph.RTDMException: JDBC Connection Pool is not initialized and cannot be used.
at com.sas.rtdm.implementation.resource.JDBCConnectionPool.getConnectionPools(JDBCConnectionPool.java:378)"

Please let me have your inputs?

Regards,

Siva

Re: Selecting table in RTDM Data Node

shill — Tue, 24 Jan 2017 14:23:48 GMT

That means your JDBC system resource definition isn't matching up with your environment (host name, port, or credentials), or the Fed Server isn't running.

But now we're venturing into technical support's domain, so I recommend you open a ticket on this now that there's a specific error message involved.

Re: Selecting table in RTDM Data Node

malikehsan — Wed, 03 Jan 2018 20:36:30 GMT

Hi,
Wondering if you were able to solve this issue. I'm having the same issue with RTDM. I get the 24141 is out of service message in my log. Would you be able to recommend a solution?