An index is out of bounds

Marley777 · Post by **Marley777** » Tue Nov 13, 2007 1:25 pm

What is this error trying to tell me? What might cause this error?

An index is out of bounds.

Thanks for our help!!!

richdhan · Post by **richdhan** » Tue Nov 13, 2007 1:34 pm

Hi RStone,

Where is this error coming from?

Giving additional info will help like specific Datastage version, flavor of unix and what stages you are using in your job.

Is it coming from a DB then what is your DB.

I have worked in VB before and "Item is out of bounds" is a very familiar error when trying to read an array element out of the array range.

Give more info so that we can track it down.

--Rich

Marley777 · Post by **Marley777** » Tue Nov 13, 2007 1:47 pm

Thanks for reading. Here is more information

Datastage PX 7.5.1
Unix 5.3

The error happens just after a funnel stage. The funnel stage is reading data from 5 files. One of the files are processed through a trasformer first before going into the funnel. DB2 tables are in the job, but the job aborts before it reaches the DB2 UDB stages.

ray.wurlod · Post by **ray.wurlod** » Tue Nov 13, 2007 4:45 pm

Can you post the exact error message in its entirety, so we can see the stage type that is generating it? Have you involved your support provider (since you may have uncovered a bug)? Are you using any routines?

Marley777 · Post by **Marley777** » Wed Nov 14, 2007 10:18 am

Here is the exact error message.

cs}}},1: Fatal Error: An index is out of bounds.

ray.wurlod · Post by **ray.wurlod** » Wed Nov 14, 2007 3:57 pm

In its entirety please. We need to see what's inside those curly braces. Obfuscate your data if you need to, but not anything produced by the framework. For example, I suspect that the "cs" is a "case sensitive" sub-option to a sort, but can not be sure without the remainder of the information.

Marley777 · Post by **Marley777** » Thu Nov 15, 2007 8:01 am

That is the entire error message, nothing has been removed or changed. I copied that straight out of the log and pasted it. The error message does not provide much detail.

cs}}},1: Fatal Error: An index is out of bounds.

ray.wurlod · Post by **ray.wurlod** » Thu Nov 15, 2007 4:44 pm

Yuk. It is clearly an incomplete error message. No information is available about whence it was generated, which makes diagnosis difficult. Are you using non-default partitioning? Is there anything in the Transformer code (in RT_SCnnn directory, where nnn is the job number) that suggests that an array is being (mis-)used?

Marley777 · Post by **Marley777** » Fri Nov 16, 2007 8:04 am

It is using all default partitioning. It seems the issue is related to a join in the job. If I change the join to a lookup I no longer get this message.