01-23-2017 05:15 AM
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?
01-23-2017 04:00 PM
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.
01-24-2017 05:40 AM - edited 01-24-2017 09:04 AM
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.
Please let me have your inputs?
01-24-2017 09:23 AM
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.