Hey guys:
 
I was looking at this bug with DongInn tonight and I think I have figured out what the problem is.
 
The error message show up because the entries that the error messages are referring to, are NULL.
 
/opt/oscar/packages/sis/scripts/post_clients: illegal or
non-understood where string <nics.driver_module = >
/opt/oscar/packages/sis/scripts/post_clients: INTERNAL
ODA ERROR - failing to convert where _expression_
 
Notice the space between the equal sign and the '>', it should really read = NULL.
 
Currently ODA tries to parse the where clause and figuring out whether it has 3 fields or not, for instance:
 
where x = y
 
If you split this with spaces, you will get 3 fields (excluding the equal sign)
 
For the clause in question:
 
where x =
 
If you do a split, you only 2 fields, and thus it is giving that error.
 
One fix is to modify the behaviour such that if whatever's following the equal sign is empty, change it to NULL.
 
This might work, but I'm not sure if it's going to break other stuff.
 
Comments...
 
Thanks,
 
Bernard

Reply via email to