#5 Error with NVARCHAR field

[stefano sonzogni]

SQL server 2019, I have problem with NVARCHAT field.

Message ID . . . . . . : SQ30000 Severity . . . . . . . : 30
Message type . . . . . : Information

Message . . . . : Distributed Relational Database Architecture (DRDA)
protocol error.
Cause . . . . . : Command or SQL statement failed due to a distributed
protocol error that will not affect subsequent commands or SQL statements.
The protocol error is X'220E' with a location code of X'01'.
The location codes are:
-- '01'X -- The error was detected at the application requester.
-- '02'X -- The error was detected at the application server.
A possible list of protocol errors is:
-- '121C'X -- Not authorized to command.
-- '1245'X -- Conversation protocol error. The error code is X'00'.
-- '124C'X -- Data stream syntax error. The error code is X'00'.
-- '1254'X -- Unexpected error condition. The error code is X'00'.
-- '125F'X -- Application server does not support function requested.
-- '2202'X -- Cursor not open.
-- '2204'X -- Relational database not connected.
-- '2207'X -- Relational database already connected.
-- '220A'X -- Data descriptor not valid. The error code is X'00'.
-- '220E'X -- Data descriptor did not match data.
-- '220F'X -- Cursor already open.
-- '221D'X -- Command not valid for conversation type.
If the protocol error does not appear in the list, refer to the DDM
Architecture Reference for DDM code point X'220E'.
Recovery . . . : If the protocol error is '121C'X, then obtain the
authorization required to use this command or SQL statement at the
application server. If the protocol error is not '121C'X, then report the

[Dieter Bender]

first of all; did you have a look to the examples?

To see whats going on, I
would need more info. Please follow these instructions:
- change log4j.properties, its located in directory conf of your
installation. uncomment following line by removing the # as the beginning of
following line

log4j.logger.de.bender_dv.ardgate=DEBUG

delete the logfiles in directory log to force a new log to minimize
information for me
restart the server by killing the STRJVAGATE job and start it again
reproduce your problem from a newly started session
send me the logfile and a description what exactly you where trying

D*B

[stefano sonzogni]

did you get my email?

[stefano sonzogni]

[stefano sonzogni]

From STRSQL I try this:

connect to vpsfarma
Il collegamento corrente è al database relazionale VPSFARMA.
select * from [test_opbg].[dbo].[TABLE_2]
Errore di protocollo DRDA (Distributed Relational Database Architect

[Dieter Bender]

... use the recent version (replace ArdGate.jar with the newest one and restart the serber) and retry.

PS: it's more easy to me to contact me via my well known eMail adress)

[stefano sonzogni]

I am using this version:

AppServer4RPG2017-12-24.ZIP