ORA-01400: cannot insert NULL

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

DSRajesh
Premium Member
Premium Member
Posts: 297
Joined: Mon Feb 05, 2007 10:37 pm

Post by DSRajesh »

Hi ray,

The Operating systems,Database configurations,authentications everything is same.

Moreoover the same is running fine more than 1 year in production
RD
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

What has changed between when it was running successfully and when it is not running successfully? I can not accept "nothing" - you have to find what has changed, even if it's the data.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

When I see something like this, it is usually data related. Something has come along in production that you haven't seen or tested for in your other environments. If you are certain about 'everything else' being the same and no changes have been made recently in production, that is sure what I would scrutinize with an intense scrute.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply