Skip to Content
0
Former Member
Jan 06, 2012 at 12:59 PM

PI 7.3 + JDBC-Adapter -> Invalid column name (apostophes missing)

238 Views

Hello,

we're about to migrate our XI to PI 7.3. In the old XI we have some fine working IDoc to JDBC szenarios. The IDoc reaches the XI and there the IDoc gets mapped to the XML-Structure of the JDBC-Adapter. After the mapping the JDBC Adapter writes the data into a MS SQL Server. Like I said - this used to work fine.

Now with 7.3 there are some funny errors while writing into the table. The table to write is very simple:

CREATE TABLE [dbo].[ekko](
	[EBELN] [nchar](10) NOT NULL,
	[LIFNR] [nchar](10) NULL,
	[BUKRS] [varchar](4) NULL,
	[BETRG] [decimal](18, 2) NULL,
	[WAERS] [varchar](5) NULL,
	[VERKZ] [nchar](1) NULL,
	[VERDT] [varchar](20) NULL,
 CONSTRAINT [PK_ekko] PRIMARY KEY CLUSTERED 
(
	[EBELN] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

The PI creates the following update-stamement:

UPDATE dbo.ekko SET EBELN=4700002087, LIFNR=0000020922, BUKRS=0001, BETRG= 92.86, WAERS=EUR, VERKZ=U, VERDT=20120106103300 WHERE (EBELN=4700002087)

This doesn't look wrong so far. But when executing this query, the following error occurs in the audit protocoll of the communication channel:

Error processing request in sax parser: Error when executing statement for table/stored proc. 'dbo.ekko' (structure 'STATEMENTNAME'): com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'U'.

I tried to execute the generated query inside the MS SQL Server Management Studio and the problem is, that the values in the fields WAERS and VERKZ are not enclodes with apostrophes (WAERS = 'EUR'). The old XI with the appropiate Adapter/JDBC-Driver was working well. I hope that this problem is because of an option in the Adapter or JDBC-Driver. Does anybody have a good idea for me to get the values of WAERS and VERKZ into apostophed?

Regards

Torsten