Page 1 of 1

index maintenance, how to get it to work?

Posted: Wed Jul 18, 2007 9:57 am
by 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.

Posted: Wed Jul 18, 2007 3:01 pm
by ray.wurlod
Have you checked for the user ID that runs DataStage jobs? Look in the second event in the job log ("environment variables").

Posted: Thu Jul 19, 2007 3:59 am
by ivannavi
USER=dsadm

Another user-like entry is DS_USERNO=-9657.

Re: index maintenance, how to get it to work?

Posted: Thu Jul 19, 2007 6:40 am
by chulett
ivannavi wrote: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?

Posted: Fri Jul 20, 2007 3:34 am
by 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.