index maintenance, how to get it to work?

[ivannavi]

Oracle Enterprise stage:
Load, Append
Index Mode = Maintenance

All indexes in the target table are local range partitioned indexes. Therefore index option maintenance can be used.

Fatal error:

main_program: Internal Error: (count <= numPartKeys): oraTable.C: 197
Traceback: Could not obtain stack trace; check that 'gdb' and 'sed' are installed and on your PATH

I have checked. gdb and sed are installed and the directories where they reside are in the PATH.

[ray.wurlod]

Have you checked for the user ID that runs DataStage jobs? Look in the second event in the job log ("environment variables").

[ivannavi]

USER=dsadm

Another user-like entry is DS_USERNO=-9657.

[chulett]

I have checked. gdb and sed are installed and the directories where they reside are in the PATH.

Just to be anal - they are in who's PATH? They would need to be in the path of the running job's environment, not you logging in as that same user checking from the command line. You can check the second log entry of any job for a dump of the job's environment variables - is the PATH correct there?

[ivannavi]

PATH= ... /usr/bin ... /opt/langtools/bin ...


I found these directories in log (Director, Environment variable settings)
gdb and sed are inside. So, yes the path is correct there.