on 11-07-2007 4:30 PM
Abap: S:RSSDK: 400 field is empty
Java trace: "IllegalArgumentException: field is empty"
Evironment:
NW07, BI, BI-JAVA, running on AIX, DB2
Objective:
Extract data from external MS-SQL database via UD connect type JDBC
Connector setup:
Created UD connector JDBC (to MSSQL server) as per SAP guide: "How to
Configure UD Connect on the J2EE Server for JDBC Access to External
Databases".
Created JDBC Source System
Created UD Connect BI source system against above JDBC config
Test Tools:
I can successfully test (read database, table contents) the JDBC setup
with this URL:
http://<my-BI-servername>:50000/TestJDBC_Web/TestJDBCPage.jsp
Additionally, the JDBC Source System I created - the monitor shows the
green line, which means it is connected.
Error condition:
In the BI system, the datasource for the assigned UD JDBC source system
sees the database, the table in question, as well as all the
fields.
But when the analyst attempts to extract the data from that
table, the error is
S:RSSDK: 400 field is empty. In the java default trace file I also see
"IllegalArgumentException: field is empty"
The trace on the MS-SQL database indicates only connection details, such as:
set quoted_identifier on
set implicit_transactions off
...etc
but no table/view/slecet entries are found
Any feedback would be greatky appreciated.
~~Christo
We had this problem once. Check if the MSSQL database is unicode or non-unicode and then adjust your RFC connector in SM59.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.