http post maximum size

[Former Member]

There is a maximum post size for SQL Anywhere 16 ?

test_file01.rar is 2495 Kb length

test_file02.rar is 2999 Kb length

When I run on CLIENT_SERVER dba.f_send_test_file('AAA','c:\test\test_file_01.rar')

at CLIENT_SERVER the Result is : TEST FILE LENGTH: 2495621

When I run on CLIENT_SERVER dba.f_send_test_file('AAA','c:\test\test_file_02.rar')

at CLIENT_SERVER the Result is :

There was an error reading the results of the SQL statement.

The displayed results may be incorrect or incomplete.

Connection Timeout

SQLCODE=-982, ODBC 3 State="HY000"

and at WEB_SERVICES_SERVER There is an Internal Error crash !!!

Below are the coding scripts

/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

WEB_SERVICES_SERVER param:

SQL Anywhere Network Server Version 16.0.0.1324 Workgroup Edition

-xs "HTTP(PORT=8080;MaxRequestSize=200000000;TO=600;KTO=600)"

/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

ALTER FUNCTION "dba"."f_rec_test_file"( IN as_version CHAR(8), IN alb_file_data LONG BINARY )

RETURNS LONG VARCHAR

NOT DETERMINISTIC

BEGIN

  DECLARE llb_file_data LONG BINARY;

  RETURN 'TEST FILE LENGTH: ' + STRING(LENGTH(alb_file_data)) ;  

END

/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

CREATE SERVICE "ws_rec_test_file"

    TYPE 'RAW' AUTHORIZATION OFF SECURE OFF URL PATH OFF USER "dba"  AS

select "f_rec_test_file"(:version,:file_data)

/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

WEB_SERVICES_SERVER error:

Internal Error

VERSION=16.0.0.1324

FILENAME=C:\ProgramData\SQL Anywhere 16\diagnostics\SA16_20160528_025259_9792.crash_log

OS=Windows 8 Build 9200

PROCESSOR=X86_64

EXEC_ARCH=X86_64

EXEC_PATH=C:\Program Files\SQL Anywhere 16\Bin64\dbsrv16.exe

MODULE_PATH=C:\Program Files\SQL Anywhere 16\Bin64\dbserv16.dll

/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

CLIENT_SERVER param:

SQL Anywhere Network Server Version 16.0.0.1324 Workgroup Edition

-xs "HTTP(PORT=8080;MaxRequestSize=200000000;TO=600;KTO=600)"

/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

ALTER FUNCTION "dba"."f_send_test_file_ws"( in "version" char(8),in "file_data" long binary )

returns long nvarchar

url 'http://192.168.1.82:8080/test/ws_rec_test_file'

set 'HTTP(CHUNK=ON)'

type 'HTTP:POST'

/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

ALTER FUNCTION "dba"."f_send_test_file"( in version char(8) , IN file_name LONG VARCHAR ) 

RETURNS LONG VARCHAR  

NOT DETERMINISTIC  

BEGIN  

  DECLARE llb_file_data LONG BINARY;  

    SET llb_file_data = xp_read_file(file_name) ; 

    RETURN f_send_test_file_ws(version,llb_file_data) ;   

END

/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

CLIENT_SERVER error:

There was an error reading the results of the SQL statement.

The displayed results may be incorrect or incomplete.

Connection Timeout

SQLCODE=-982, ODBC 3 State="HY000"

/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

[Former Member]

Hi Jose;

  Since this has nothing to do with PowerBuilder (if I interpret this correctly), I would suggest posting this question in the SqlAnyWhere support forum ... SAP SQL Anywhere Forum

HTH

Regards .... Chris