Receiver JDBC Error

[Former Member]

Dear Experts,

I have a Proxy to Jdbc Scenario in Pi 7.0 . Target is Oracle 10g

  In sxmb_moni message status is successful.
   But in the RWB CC Monitoring Getting error like:

    Unable to execute statement for table or stored procedure. 'IT_SHIFT' (Structure 'Statement') due to java.sql.SQLException:                                                                                                                                                                                               ORA-01843: not a valid month
2013-11-12 17:33:53 Error        Exception caught by adapter framework: Error processing request in sax parser: Error     when   executing statement for table/stored proc. 'IT_SHIFT' (structure 'Statement'): java.sql.SQLException:                                                                                                             ORA-01843: not a valid month

Source XML:

<Records>
  <PERNR>00000924</PERNR>
  <DATE>20130301</DATE>
  <BEGUZ>000000</BEGUZ>
  <ENDUZ>000000</ENDUZ>
  <FLAG>1</FLAG>
  </Records>
 
Target XML:

  <access>
  <PERNR>00000924</PERNR>
  <BEGDA>01/03/2013</BEGDA>
  <SOBDA>01/03/2013 00:00:00</SOBDA>
  <SOEND>01/03/2013 00:00:00</SOEND>
  <FLAG>1</FLAG>
  <INSDT>12/11/2013</INSDT>
  </access>

Please suggest how to insert the records?

Regards

Anirban

[Former Member]

  Hi all,

Thanks everyone........

It is solved.........

Regards,

Anirban

[Former Member]

Hi Anirban,

Table might be accepting month in format MON, use to_date function as below:

to_date('01-03-2013', 'DD-MON-YYYY HH24:MI:SS'), concat field to get the format.

Regards,

Pranav

[Former Member]

HI Pranav,

  Thanks for your reply.

  as per suggestion how can i use the concat function with this format?

[former_member184720]

explained here.. you can find the screenshots

http://scn.sap.com/people/alessandro.berta/blog/2005/10/04/datetime-datatypes-and-oracle-database

[Former Member]

Hi Hareesh,

     Using that link i can successfuly update the Database Table field(DATE)

   But now i have to add that field(Date) to another field(Time data) and update target Table Field(DATE).

  Like:

  Field1-- 2013-12-12

  Field2-- 12:03:00                                                                  Target DB Field----  2013-12-12 12:03:00

How can i write the concat function in that case?

[gagandeep_batra]

Hi Aniraban,

It require spacial structure

Plz check below:

http://scn.sap.com/community/pi-and-soa-middleware/blog/2012/09/05/jdbc-receiver-best-practices-scen...

Regards

Gagan

[former_member184720]

check the expected date format on database

you can execute the below query to check "select * from nls_session_parameters"

Refer to Bhavesh's reply in the below thread and it should resolve your issue.

http://scn.sap.com/thread/148985