arputh Contributor.
Contributor.
179 views

(KNTA-10127) error: CAT Unknown or out of sequence command:

Hi,

Hope someone can tell me where am I going wrong.

An error occurred during command parsing.
(KNTA-10127)
GUID=2F91E6D8-F70C-B11E-B31F-999A7E0811A8
Generated Time=2016/06/07-13:17:39.125 CAT Unknown or out of sequence command:
[kcs_store REQD.P.AGE_BUS_CLS_DURATION=[SQL_OUTPUT],[SQL_OUTPUT]]

The execution command is as follows:

ksc_itg_run_sql QUERY_STRING="select to_char(sysdate,'YYYY-MM-DD HH24:MI:SS') from dual"
ksc_store REQD.P.AGE_BUS_CLS_START_DATE=[SQL_OUTPUT],[SQL_OUTPUT]
ksc_itg_run_sql QUERY_STRING="select lookup_code from knta_lookups where lookup_type like 'AF - Business/IT List' and lookup_code = 'BUSINESS'"
ksc_set TEMP_P=[SQL_OUTPUT]
ksc_itg_run_sql QUERY_STRING="select meaning from knta_lookups where lookup_type like 'AF - Business/IT List' and lookup_code = 'BUSINESS'"
ksc_set TEMP_VP=[SQL_OUTPUT]
ksc_store REQD.P.AGE_BUS_IT=[TEMP_P],[TEMP_VP]
ksc_store REQD.P.AGE_DATE_IND="3","3"
ksc_itg_run_sql QUERY_STRING="SELECT NVL(TO_NUMBER('[REQD.P.AGE_BUS_CLS_DURATION]'),0) FROM DUAL"
kcs_store REQD.P.AGE_BUS_CLS_DURATION=[SQL_OUTPUT],[SQL_OUTPUT]

The error occur after adding the special commands marked in red.

The field is a numeric field with 2 decimals.

When the field is NULL then I want to make the field "0" or use the value or replace the value with the same value.

This was the alternative I used because I get the same error when using a condition on the command: '[REQD.P.AGE_BUS_CLS_DURATION]' IS NULL

Your assistance in this issue is greatly appreciated.

Regards,

Alfred

Alfred Puth
PPM Consultant
EOH Application Management
0 Likes
2 Replies
Natalia_R_PPM Absent Member.
Absent Member.

Re: (KNTA-10127) error: CAT Unknown or out of sequence command:

Hello Peter, 

Seems the issue is with syntax error in the command.

Can you use " " 

example:

ksc_itg_run_sql QUERY_STRING=""
ksc_store = "[SQL_OUTPUT]"

Regards, 

Natalia R

HP Support
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.
0 Likes
arputh Contributor.
Contributor.

Re: (KNTA-10127) error: CAT Unknown or out of sequence command:

Hi Natalia,

Same error:

An error occurred during command parsing.
(KNTA-10127)
GUID=2B8D51BA-B91B-2137-F627-F0791B957076
Generated Time=2016/06/09-09:36:45.019 CAT Unknown or out of sequence command:
[kcs_store REQD.P.AGE_BUS_CLS_DURATION="[SQL_OUTPUT]","[SQL_OUTPUT]"]

Failed

Alfred Puth
PPM Consultant
EOH Application Management
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.