Problem with INSERT statement

[Former Member]

Hello,

I have scenario from RFC to Oracle database.

I try to write this statement:

INSERT INTO PRICING_MATERIAL_MASTER (MATNR, MATDESC, MG, MGDESC, PG, PGDESC, STATUS) VALUES (000000090200001100, 'PI-500 -MDPE-SK', 70-005, 'RM RESIN HDPE', 90200, 'MDPE-EX', NULL)

And I received the error message:

MP: exception caught with cause com.sap.aii.af.ra.ms.api.RecoverableException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'PRICING_MATERIAL_MASTER' (structure 'STATEMENTNAME'): java.sql.SQLException: ORA-00917: missing comma

When I copy the statement from RWB to the "SQL Developer studio" the statement work OK

Elad

[Former Member]

Hi.

Aparently the SQL Stament is ok..

Please check the SAP Note 723149 about the error Missing comma also check

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/frameset.htm

[Former Member]

Did you try to have the value 70-005 also in ' '?

Which PI version do you use? 3.0, 7.0, 7.1? Patch level?

[Former Member]

Hi,

In Jdbc adapter in ID ....

Try Changing the Maximum concurreny to 10000...

And In advanced tab of JDBC adapter

logSQLStatement =True

You will get the exact query and the details as where actually this is failing in Adut Log of RWB.

Regards,

Sainath

[Former Member]

Hello,

I'm not found the:

"Maximum concurreny"

Elad

[Former Member]

It's in the processing tab of the JDBC Adapter...

[Former Member]

Where in JDBC adapter is "processing tab"

[Former Member]

Hello,

I tried all the recommendation without any result,

I'll be happy for more ideas.

Elad

[Former Member]

Hi.,

In your mapping check that if you have mapped the table name of receiver structure with constant value consisists of table name.sometimes we used to overlook.

Thanks

Hamja

Edited by: Hamja Hussain on Jul 9, 2009 12:06 PM

[Former Member]

Hi

Check in u r IR Interface for u r Receiver Interface Data type == DB Datatype

See if u find in u r DB Datatype as vchar == Declare it as "String" in XI

Num == Integer

check once with datatype.

Even nothg works then , give all elements in the interface as "String" and run

lemme know

rgds

srini

[Former Member]

Is the same name,

If I runed this statment from the SQL developer is work OK

[Former Member]

Hello Sirini,

This is the table In oracle

MATNR VARCHAR2(18 BYTE)

MATDESC NVARCHAR2(100 CHAR)

MG VARCHAR2(9 BYTE)

MGDESC NVARCHAR2(100 CHAR)

PG VARCHAR2(6 BYTE)

PGDESC NVARCHAR2(100 CHAR)

STATUS CHAR(2 BYTE)

DELETION_DATE DATE

In XI all type is STRING

I'm not mapping the date field

Elad

[Former Member]

Hi

Well

in interface for DATE assign to Data type as "date" type instead of "String"

Then check in the db IF DATE field is decalred as "NOT NULL" type

if it is not null try to map to source if u r sending date , r use Function current date

srini

[Former Member]

Srini,

The date is not a problem, Is not mandatory and i'm not send to this field nothing.

Elad

[Former Member]

Hi

then try to send data without "-" i see some data has "PC-ID-HH" send as "PCIDHH"

that wonot be problem in String but still , this the way u can debug when u work with XI

narrow down and see the possiblities.

No other seetings to make this problem supress , u need to narrow down the elememt and find it's root

Srini

[Former Member]

Srini,

I'm don't think this is the problem and I need this "-" in my database.

Do you have more ideas?

Elad

[Former Member]

Hi,

There must be problem with your receiver structure..Please check it one more time..chk this link how to create receiver JDBC strucutre.. http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/frameset.htm. still if problem persists pls provide your receiver structure and your database table fields, hopefully your problem can be solved.

Thanks

Hamja

[Former Member]

Did you at least try your scenario with very simple data without any - or + or anything else... just simple strings?

[Former Member]

Hello Hamja,

Thank you for your answer.

I know this link and is not help me.

The table and receiver structure is un the thread

Elad

[Former Member]

Hello,

Thank you for all your help.

I found 2 problems:

1. The tables names in IR needs to write small laters.

2. XI not support NVarchar only Varchar.

Elad

[agasthuri_doss]

Elad,

Check whether you create the structure accordingly Receiver format.

http://help.sap.com/erp2005_ehp_04/helpdata/EN/ae/d03341771b4c0de10000000a1550b0/frameset.htm

Cheers

Agasthuri

[Former Member]

The structure is OK.

When I run the structure from the RWB in SQL devloper studio the statment work OK