on 02-25-2008 10:46 AM
Hi XI Guru,
I have problem in JDBC Receiver. My error is
" Message processing failed. Cause: com.sap.aii.af.ra.ms.api.RecoverableException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'ps_gl_active_acct_' (structure 'Statement'): java.sql.SQLException: ORA-01843: not a valid month "
Currently I am using TransformDate function in graphical mapping.
Source Format : yyyy-mm-dd Type xsd:date
Target format : dd/mm/yyyy. Type xsd:date
I have tried mm/dd/yyyy
Please give me some advise and tips to solve my problem.
Regards,
use this function
TO_DATE('<originalDate>','YYYY/MM/DD') : You have to form this string using the concate function in the graphical mapping.
Use the above function in graphical mapping to map the exact date in ORACLE.
You will have to use 'hasquot' attribute and set it to "NO" of the Date field. It will be solved then..
follow this link: /people/alessandro.berta/blog/2005/10/04/datetime-datatypes-and-oracle-database
Regards.
Jeet
Edited by: Jeet Jeswani on Feb 25, 2008 12:44 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
In source give yyyy-MM-dd (change the mm to capital MM)
Target format : dd/MM/yyyy
And test the mapping in message mapping using the XML pay load which u have got while executing the scenario,if it done work update the thread.
Regards,
Phani
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI,
CHECK WHETHER U HAVE GIVEN THE CONNECTION AND JDBC DRIVER FOR ORACLE DATABASE PROPERLY.EVEN I HAVE GOT MANY A TIMES THESE PROBLEM WHILE USING ORACLE DATABASE.
CAN U PLZ TELL ME CONNECTION AND DRIVER UR USING
PLZ REWARDS POINTS
VIKAS
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.