Skip to main content
Solved

running qscript on Linux Commserve host


Forum|alt.badge.img+6

Hello,

 

I’m trying to run a qscript on my linux Commserve in 11.34.3 and i get this error :

[root@redhatcs01 Base]# ./qoperation execscript -sn GetClient_Info.sql
execscript: Error 0x13b: Qscript execution failed.
QScript[GetClient_Info] CS[commrhelcs01] DB[CommServ]

Qscript Output:

Failed at RunStringQuery_QS! Error: [Failed to execute SQL Script!].
 

if anyone have information about using qscript on Linux Commserve ?

Kind regards,

Christophe 

 

PS : Happy new year 2024 !!🥂

Best answer by ChrisCC

Hello,

i have found why i can’t run script in my linux CS (11.34.3 in a test lab with NFR license).

I have installed the sqlcmd tools to manage sql but they have changed some paths in sql server.

Fortunately i have taked a snapshot on my VM before installing the sqlcmd tools.

once i revert from the snapshot the qscript work fine.

regards,

View original
Did this answer your question?

3 replies

Scott Moseman
Vaulter
Forum|alt.badge.img+18

I was able to run the script successfully against a Linux CS.

[root@cv-client-1 Base]# ./qlogin
Enter User Name : admin
Password :
User logged in successfully.

[root@cv-client-1 Base]# ./qoperation execscript -sn GetClient_Info.sql
QScript[GetClient_Info] CS[cv-commserve-1] DB[CommServ]
Qscript Output:
Name    Host Name       OS      ACTIVE
----    ---------       --      ------
cv-commserve-1  cv-commserve-1  Linux   YES
cv-client-1     cv-client-1     Linux   YES
Qscript Execution Succeeded!

Thanks,
Scott
 


Forum|alt.badge.img+6
  • Author
  • 19 replies
  • January 3, 2024

Hello Scott,

thank you for your feedback.

My commserve was hardened with selinux enable, do you use an hardened CS ?

regards,


Forum|alt.badge.img+6
  • Author
  • 19 replies
  • Answer
  • January 3, 2024

Hello,

i have found why i can’t run script in my linux CS (11.34.3 in a test lab with NFR license).

I have installed the sqlcmd tools to manage sql but they have changed some paths in sql server.

Fortunately i have taked a snapshot on my VM before installing the sqlcmd tools.

once i revert from the snapshot the qscript work fine.

regards,


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings