Skip to Content
0
Former Member
Nov 07, 2007 at 04:30 PM

extract error: u0093S:RSSDK: 400 field is emptyu0094

23 Views

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