Hi,
I'm unloading tables into a dataset.My job is working fine for all the tables except one table "VW_AGMNT".The job is getting aborted showing error as:-
"orastagingdba,0: Operator terminated abnormally, received signal SIGSEGV".
But after sometimes if we run the job again the job is running successfully for "VW_AGMNT" table.
I search on the forum but i didn't find any related posts to it.
Could anyone please tell me why this error occurs?And how do i solve this?
Any help will be greatly appreciated..
SIGSEGV error in job..
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Is the extraction doing anything that might consume memory, such as sorting? Are there any nullable columns in the Oracle table that you are trying to load into non-nullable columns in the Data Set? Are you undertaking any transformation of the data as they flow through? Are you trying to load character strings into target fields that are not large enough to accommodate them? Any of these things (and others) might lead to an segmentation violation (which is what a SIGSEGV signal signals).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
The extraction has a "where" clause, i'm filtering records based on a date, but i'm not sorting the records.It's a direct mapping from source to target without any change in metadata.
I've used a used defined SQL for extraction:-
"select * from schema.VW_AGMNT where R_DATE='27-MAR-2009' ".
Regards
Datisaq
I've used a used defined SQL for extraction:-
"select * from schema.VW_AGMNT where R_DATE='27-MAR-2009' ".
Regards
Datisaq
RK Raju
Actually my job is a generic job and i'm paasing the table name as a job invocation id to the query as
"select * from schema.DSJobInvocationId".And i enabled the RCP and Multiple instance propery in the job.So, the job will unload all the tables irrepective of the metadata.
The job is working perfectly for all the tables except "VW_AGMNT".
Please let me know how do i solve this problem?
"select * from schema.DSJobInvocationId".And i enabled the RCP and Multiple instance propery in the job.So, the job will unload all the tables irrepective of the metadata.
The job is working perfectly for all the tables except "VW_AGMNT".
Please let me know how do i solve this problem?
RK Raju
Are any of these other "tables" really views as well and other views work fine, just not this one? Or is this the only view with an issue? In order words, is this a generic "view problem" where it doesn't work for any of them or is it a problem specific to this view? ![Confused :?](./images/smilies/icon_confused.gif)
![Confused :?](./images/smilies/icon_confused.gif)
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers