Length or start position is out of range for the string operation.

[sivanathp]

Message ID . . . . . . : RNX0100 Severity . . . . . . . : 50
Message type . . . . . : Escape
Date sent . . . . . . : 01/12/24 Time sent . . . . . . : 09:53:54

Message . . . . : Length or start position is out of range for the string
operation.
Cause . . . . . : One of the following has occurred in RPG procedure
PRFETCHCAL in program QLIKUDTF/QLIKRJE01:
- A numeric length or start position is less than 1 or too large for the
string operation.
- The search-argument parameter of the %SCAN built-in function has zero
length or is longer than the source-string parameter.
- The maximum-length parameter of the %STR built-in function is not a value
between 1 and the maximum size of a character field.
Recovery . . . : Contact the person responsible for program maintenance to
determine the cause of the problem.

[DesmondWOO]

Hi @sivanathp ,

Thank you for reaching out to the Qlik Community.

Please try the following steps to see if it helps:

1. Click "Advanced" tab in your DB2 iSeries endpoint
2. Click "Internal Parameters"
3. In the Search parameter text field, type udtfCaptureCT
4. Uncheck the box.
   

Regards,
Desmond

[SushilKumar]

Hello team,

If our response has been helpful, please consider clicking "Accept as Solution". This will assist other users in easily finding the answer.

Regards,

Sushil Kumar

[sivanathp]

This issue is intermittent. we are not seeing this issue now. if it comes again then i will try with the solution you suggested.  could you please let me know what causes this issue

[DesmondWOO · Accepted solution]

Hi @sivanathp ,

From my understanding, this parameter is to capture the ‘Create Table’ event of a new table. Above error may occur on this checking "CT" query. If your task is defined to capture explicit tables only, you can uncheck this parameter to disable this query.

To determine the root cause, I would suggest to submit a new support ticket.

Regards,
Desmond

[sivanathp]

Thank you @DesmondWOO