on 08-29-2006 1:03 AM
Hi All,
We have installed SAP on OS/400.
My scenario is IDOC XI JDBC.
We have created a File JDBCTEST , member JDBCTEST and Field JDBCTEST.
These are created under a lib QLGP.
Then I did a message mapping between the IDOC and JDBCTEST by concatenation function.
<b>IN THE JDBC ADAPTER CONFIGURATION I am getting the error
Value missing for mandatory configuration attribute table EOColumnName Ts</b>
In the EO JDBC ADAPTER Configuration, the DATABASE parameters:
DBTABLE:JDBCTEST
KEY COLUMN NAME:JDBCTEST
Is there anything wrong I am doing?
Any help is appreciated.
Thank you.
Mili,
<i>In the EO JDBC ADAPTER Configuration, the DATABASE parameters:
DBTABLE:JDBCTEST
KEY COLUMN NAME:JDBCTEST</i>
I guess you have made the option for DATABASE persititence as DATABASE. It should be LOCAL. Make it LOCAL and test.
Regards,
Bhavesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Bhavesh,
My XML structure after testing the mapping is as follows:
<?xml version="1.0" encoding="UTF-8"?>
<ns0:Messages xmlns:ns0="http://sap.com/xi/XI/SplitAndMerge"><ns0:Message1><ns1:TEST_MT xmlns:ns1="http://mri.com/xi/IDOC2JDBC"><STATEMENTNAME><JDBCTEST action="INSERT"><access><JDBCTEST>567,23,2345,MRI</JDBCTEST></access></JDBCTEST></STATEMENTNAME></ns1:TEST_MT></ns0:Message1>
I have tested by giving the PERSISTENCE as LOCAL,then intially there was no error but now I am getting the Transformation error.
TransformException error in xml processor class: Error processing request in sax parser: Error when executing statement for table/stored proc. 'JDBCTEST' (structure 'STATEMENTNAME'): java.sql.SQLException: [SQL0104] Token MOTOR was not valid. Valid tokens: ) ,.
Am I doing anything wrong in the JDBC Adapter Configuration or Message Mapping?
Please help me out with this issue.
Thank you in advance.
Mili,
Some thoughts.
<?xml version="1.0" encoding="UTF-8"?>
<ns0:Messages xmlns:ns0="http://sap.com/xi/XI/SplitAndMerge"><ns0:Message1><ns1:TEST_MT xmlns:ns1="http://mri.com/xi/IDOC2JDBC"><STATEMENTNAME><JDBCTEST action="INSERT<b>"><access><JDBCTEST>567,23,2345,MRI</JDBCTEST></access></JDBCTEST></b></STATEMENTNAME></ns1:TEST_MT></ns0:Message1>
<access> tag must end after <JDBCTEST>.
Configuration.
What are the values you have given for JDBC driver and Connection in commn. channel?
It should look like
Driver : com.ibm.as400.access.AS400JDBCDriver
Connection : jdbc:as400://172.xx.xx.xx
User Name : <Library Name>
Try this & let us know.
Regards,
Jai Shankar.
Hello Jai Shankar,
The JDBCTEST is the name of the Column as well the Table Name.
The USER ID and passwords is SAPINTF.
The Connection parameters are:
jdbc:as400://10.175.40.18/QGPL;user=sapintf;
password=sapintf.
The name of the Library is given in the Connection parameters.
Any help is appreciated.
Thank you.
Hi Mili,
<i>The JDBCTEST is the name of the Column as well the Table Name.</i> --> Dint notice that.
I am not much aware of AS400 structure. But we have connected to AS400 database with the driver and connection details as I have mentioned above.
The AS400 team says the value given in User field is the library name. We have not given the library name in connection details.
To make sure your database is accessed, try giving some dummy update SQL and check it in the database.
Check in RWB the status of JDBC adapter.
Regards,
Jai Shankar.
<i>We wrote a simple java Program to update the SQL and worked fine.</i>--> what do you mean by that?
Try giving
driver : com.ibm.as400.access.AS400JDBCDriver
Connection : jdbc:as400://172.xx.xx.xx;translate binary=true
User : userid
password : ****
Querry SQL statement : Select * from <library name>.<<file name>
Regards,
Jai Shankar
Hi All,
I have changed the action to SQL_DML instead of INSERT and my XML Looks like this:
<ns1:TEST_MT xmlns:ns1="http://mri.com/xi/IDOC2JDBC">
- <STATEMENTNAME>
- <JDBCTEST action="SQL_DML">
- <access>
<JDBCTEST>0000000022,1020,Ford Motor Company,100</JDBCTEST>
</access>
</JDBCTEST>
</STATEMENTNAME>
</ns1:TEST_MT>
And I am getting this error in the RWB Adapter monitoring,JDBC adapter.
Error: TransformException error in xml processor class: Error processing request in sax parser: Error when executing statement for table/stored proc. 'JDBCTEST' (structure 'STATEMENTNAME'): java.sql.SQLException: A string parameter value with zero length was detected.
Any help is appreciated.
Thank you.
HI,
If you are doing SQL_DML , then please verify your structure with this part of SAP help-
<i> <StatementName6>
<anyName action= SQL_QUERY | SQL_DML>
<access>SQL-String with optional placeholder(s)</access>
<key>
<placeholder1>value1</placeholder1>
<placeholder2>value2<placeholder2>
</key>
</anyName >
</StatementName6>
</root></i>
Also look into comments of this-almost last part
http://help.sap.com/saphelp_nw2004s/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm
Regards,
Moorthy
Hi Moorthy,
Thank you and I appreciate for the quick response.
I have gone through the above document.
I don't have any key tags in my legacy datatype.Do I need to create them?
If so,then the place holders will be the Fields in the Table..........then in my case it is only one field that is JDBCTEST.
If I am wrong please correct me.
Can you explain me how to map the IDOC with "access" in the target structure?
Thank you.
Hi Moorthy,
Yes, this is the error in RWB Adapter monitoring.
I have tested the Message mapping with Debugging mode and the XML looks good......and the test is executed successfully.
Is this error due to the wrong creation of Files in the AS/400 Library?
Any help is appreciated.
Thank you.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Is this error is runtime error in the adapter monitoring ?
If so check your xml message structure after mapping.
Check the document format exactly like this-
http://help.sap.com/saphelp_nw2004s/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm
Regards,
Moorthy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
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.