jdbc error: missing comma

[sahana_ps]

hi all,

i am trying to insert an entry into database table this is my receiver structure.

table has only this 3 fields ...

and i can see in communication channel the insert query generated as below:

INSERT INTO PSMRT.LOC_EQUIPMENT_LOCALE (EQUIPMENT_NO,CULTURE,EQUIPMENT_DESC) VALUES (92, 'enUS', 'testing' )

but i am getting an error missing comma in receiver JDBC channel

when i run the same query in TOAD its working fine there,but not in PI

thanks,

sahana

[sahana_ps]

thanks all i solved this issue

[arijit_mukherjee2]

Hi Sahan,

Can you please advise what change you made to resolve this issue? I am facing the same problem.

Appreciate your help!!

Thanks

Arijit

[iaki_vila]

Hi Arjit,

If you share your jdcb XML payload, we can check if the problem is in its structure or if you are using any special character that it needs to be escaped.

Regards.

[arijit_mukherjee2]

Hi Inaki,

I am sure that the problem is not with the structure as the same is getting processed while I run that using XI landscape. Basically I am working on a XI to PO migration. Same structure/connection works from XI but getting the error in PO. I compared the structure/mapping and they are exactly same.

Any other thoughts!!

Thanks

Arijit

[Former Member]

Hi Sahana,

What's the datatype of "Equipment_No" in the database and also in the insert statement there are commas after and before the values, try to insert data without these commas.

INSERT INTO PSMRT.LOC_EQUIPMENT_LOCALE (EQUIPMENT_NO,CULTURE,EQUIPMENT_DESC) VALUES (92, 'enUS', 'testing' )

[sahana_ps]

equipment_no is number(38)

how can i try to insert values without commas .this statement is generated in pi based on the structure i have created ....i am not passing commas

[former_member188885]

Hi Sahana,

What is the sender service?

[sahana_ps]

Its JDBC Channel...

[Former Member]

sorry my bad.. what I meant was quotation mark (') .. Are you concatenating quotes with source values in your mapping ?

[Former Member]

Check note 723149

[Former Member]

Dear Suhana

Could you please let me know the exact error code?

Regards

Monika

[sahana_ps]

its ORA-00917:missing comma

[sahana_ps]

I refered all this threads and made changes accordingly...but still my issue is not solved

[Former Member]

Dear Sahana

In your mapping check that if you have mapped the table name of receiver structure with constant value consisting of the table name.

Regards

Monika

[sahana_ps]

hi monika,

yes i have mapped the table nameof receiver structure with constant value consisting of the table name.

[sahana_ps]

hi monika,

yes i have mapped the table nameof receiver structure with constant value consisting of the table name.

[Former Member]

Hi,

Check below threads where same topic is discussed and answered-

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

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

-Amol

[Former Member]

refer below threads might be it's helpful :

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

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