Highlighted
Outstanding Contributor.. Outstanding Contributor..
Outstanding Contributor..
187 views

Push Database Adapter ( Push Date)

I'm trying to push last access date to a external oracle database. My mapping is as follow

           <target_attribute name="ROOT_LASTACCESSTIME" datatype="DATE">
               <map type="direct" source_attribute="root_lastaccesstime"/>
           </target_attribute>

Instead of pushing date, the adapter is pushing Epoch value 

jvm 1    |         <field name="ROOT_LASTACCESSTIME" key="false" datatype="DATE" length="">1501543892</field>

So i get the following error

jvm 1    | <2017-09-13 14:12:19,037> 69095061 [ERROR] [AdHoc:AD_HOC_TASK_PATTERN_ID-1201-1505329934683] (?:?) - java.sql.SQLException: [mercury][Oracle JDBC Driver][Oracle]ORA-01861: literal does not match format string

Is this a bug? How can i get the adapter to push actual date value?

 

Thank you

0 Likes
2 Replies
Highlighted
Outstanding Contributor.. Outstanding Contributor..
Outstanding Contributor..

Re: Push Database Adapter ( Push Date)

Hello ,

Ctroung,

Please confirm the format of Date in both sites.

Regards,

Melissa Carranza Mejias
Customer Support Engineer

If you find that this or any other post resolves your issue, please be sure to mark it as an accepted solution.
If you are satisfied with anyone’s response please remember to give them a KUDOS by clicking on the STAR at the bottom left of the post and show your appreciation. “
0 Likes
Highlighted
Outstanding Contributor.. Outstanding Contributor..
Outstanding Contributor..

Re: Push Database Adapter ( Push Date)

The value is generate by the adapter pre-push, so it is reading the value from ucmdb as epoc value instead of actual date value. 

But the standard oracle date Data type is 

mm/dd/yyyy

 

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.