Oracle Datetime issue when creating a MBO in v9 SR2 (and possibly before SR2)

Gary Korman

Hello All,

 

I have been attempting to do some work with a Metastorm BPM v9 SR2 in and Oracle 10g environment.  Recently, I received an error when I created a query based MBO (I didn't try a table).  An error was reported by the designer about the date format of the an Oracle datetime field.  This is based on the fact that the field was created in the MBO as a datetime and Oracle stores datetime differently than .NET expects in a datetime value.  I was able to work around this by having Oracle return the date as a formatted string (to_char(MyDatetimeField,'mm/dd/yyy') as MyDatetimeField_str).  I than can convert the field to a date when I want to you it in my code.  It obviously would be easier to not have to do this conversion, but at least there's a relatively simple work around.

 

I hope this helps anyone that hits this issue.

 

Thanks,

 

GK

Jerome_Pearce

That does not bode well for oracle and v9. We would not be able, reasonably, to manually edit every BO in our system.

 

Thanks for the heads up, and if anyone from Metastorm can confirm this is a knoen issueand when a fix may be due we would be grateful, as this would be a show-stopper for one v9 conversion we have planned.