yes, but the documentation is not clear to me and hence i am looking for examples. How values can be passed in the method and in the cpf file.
- Log in to post comments
yes, but the documentation is not clear to me and hence i am looking for examples. How values can be passed in the method and in the cpf file.
Is there anyway if i can export the abcroutine.obj in a readable format from database?
Yes, i was talking about -d only. Can you please share the new wheel please.
get-content -path "C:\abc.log" | out-file "C:\abc-ansi.txt" -encoding ascii ---- solved the issue.
Thaks and i will try and revert.
How can set the characterset to windows at the prompt rather than go to edit menu and select. the chage should effect till the terminal window is open. Once terminal window closed the default UTF8 should come back.
I have downloaded this below wheel from GitHub. IF this not the latest wheel, please can you share new link please -
"irisnative-1.0.0-cp34.cp35.cp36.cp37.cp38.cp39-none-win_amd64.whl"
Thanks David. I did not try IRISDB method but wrote scr file to send the user name and password.
Hi Jon,
Can you please share the link for the updated wheel file please
Thanks jon. Actually i used sql query to fetch the status. So i got some alternative. Thanks for all the guidance.
Hi John,
Actually i tried combinations like "d", "ck", "cdk" but nothing worked. Actually while importing the task at termainal using "do" did not worked for me. Then i used "obj=##class" then it worked.
When i import the same file from TaskManager in Management Portal it is perfectly working and no errors. I need some solution to this problem. i got stuck due to this error.
This is the error i am getting
imptask = dbnative.classMethodValue('%SYS.Task','ImportTasks',"F:\\ZBackup\\LISBackupTask.xml","ck")
RuntimeError: server error 1217 <THROW> [ERROR_GENERAL_SERVER]
imptask = dbnative.classMethodValue('%SYS.Task','ImportTasks',"F:\Zbackup\LISBackupTask.xml","ck")
RuntimeError: server error 1217 <THROW> [ERROR_GENERAL_SERVER]
imptask = dbnative.classMethodValue('%SYS.Task','ImportTasks',"F\:\\Zbackup\\LISBackupTask\.xml","ck")
RuntimeError: * [ERROR_SHARED_CON_ERROR]
I am using IRIS Version as below -
IRIS for Windows (x86-64) 2023.1.2 (Build 450_0_23065U) Thu Dec 28 2023 14:31:25 EST [Health:5.1.0-1.m1]
and Native driver - i have downloaded the whl file "irisnative-1.0.0-cp34.cp35.cp36.cp37.cp38.cp39-none-win_amd64.whl" from GitHub
Hi Enrico,
print("Importing LIS Backup Task")
imptask = dbnative.classMethodValue('%SYS.Task','ImportTasks(FileName = "F:\ZBackup\LISBackupTask.xml",qspec = "d")')
print("After Import LIS Backup Task: ",imptask)
The Python iterpreter is not executing the print statement after ImportTasks statement. MEans, the execution is not moving further and program is just coming out. Could be some method usage might be wrong. Plese let me know if i am doing any mistake or any other way i should provide the task details.
Hi Enrico, Yes, through SQL i am getting but i am not finding suitable class/method for getting the task status. My task is just a backup task and i just want to see the task schedule status.
Hi Jon, I am using IRIS Version as below -
IRIS for Windows (x86-64) 2023.1.2 (Build 450_0_23065U) Thu Dec 28 2023 14:31:25 EST [Health:5.1.0-1.m1]
and Native driver - i have downloaded the whl file "irisnative-1.0.0-cp34.cp35.cp36.cp37.cp38.cp39-none-win_amd64.whl"
Hi,
I tried updating the python script like below -
import irisnative
hostname = "127.0.0.1"
port = 1972
namespace = "%SYS" #change the namespace based on situation
username = "_SYSTEM"
password = "xxxxxxxx"
connection = irisnative.createConnection(hostname, port, namespace, username, password)
dbnative = irisnative.createIris(connection)
cfg=dbnative.classMethodValue('Config.config', 'Open')
print(cfg.get('gmheap'))
connection.close()
and i am getting the below error when i attempting to run python -
print(cfg.get('gmheap'))
AttributeError: 'str' object has no attribute 'get'
i tried methog gmheapGet() for the property gmheap but i am not getting any output. This Config.config is persistent class and SQL table. is that is the reason 'classmethovalue' not working? the same code worked for getting %system.config.sharedmemoryheap.recommendedsize.
Hi David,
thanks for this message. I did go to the page. I still see the examples does use the terminal interaction. Am I looking at correct place? Any other ways of automating these functions.
Thanks Robert. This helps. Accepting username and password through script file is working. Probably i need to work out this procedure to embed in PowerShell for secured/easy management of Username and Password. Is there any way we can send username and password as arguments to iristerm.
Thanks a lot Robert. This helps a lot. Also, the ODBC Driver also worked for me.
Thanks Robert. I have downloaded the x64 driver and to configure ODBC. On a side note, just want to understand where do we get all the tables in the IRIS/Healthshare application.