Hi James, In our data Some of the products have more than 16 values. I have tried Jython to read cdm data(Postgres). Below is the sample code to fetch the data using sample sql into RTDM using process node. import os print(os.system("hostname")) import psycopg2 productlist =[] data = [] pg_conn = psycopg2.connect(database="postgres", user="xxxxxx", password="xxxxxxxxx", host="postgresdb", port=5432) pg_cur = pg_conn.cursor() pg_cur.execute("SELECT productid FROM cdm.table limit 10") data = pg_cur.fetchall() Above code is working fine when I submit the same in Mid tier server (cli). When I execute the campaign I am getting the below error ImportError: No module named _psycopg Added the _pyscopg package in jython jar file as well and tried the below code to install _psycopg package. import os print(os.system("hostname")) import subprocess import sys def install(package): subprocess.call([sys.executable, "-m", "pip", "install", psycopg2]) print("Done Install") /* code is executing till this point*/ import psycopg2 /* throwing error */ print("Imported Package Install") Couldn't find a detailed logs in sasserver6_1,sasserver7_1. It is writing print statements in catalina logs. Please suggest ? Thanks Bhanu
... View more
