IQ Error SQL-308:HY000

[former_member246062]

Hello All,

While running a report through UI5 , the attached error is getting logged.

C dbdssyb: DBSL99 SQL-308
C [IQ Error SQL-308:HY000][Sybase IQ]Connection was terminated
B ***LOG BY2=> sql error -308 performing OPC [dbds 437]
B ***LOG BY0=> [IQ Error SQL-308:HY000][Sybase IQ]Connection was terminated [dbds 437]
C ERROR: -1 in function DbSlCommit (COMMIT_TX) [line 6684]
C (-308) [08S01] [Sybase][ODBC Driver][Sybase IQ]Connection was terminated
B Reconnect state is entered by connection:
B 1: name = MSTD_MPX_READ_0, con_id = 038000235, state = ACTIVE , tx = YES, bc = NO , oc = 001, hc = NO , perm = NO , reco = Y
B hdl_error_on_commit_rollback: COMMIT/ROLLBACK failed without RECONNECT error code
B hdl_error_on_commit_rollback: marking CONNECTION as closed
B hdl_error_on_commit_rollback: Connection details:
B 1: name = MSTD_MPX_READ_0, con_id = 038000235, state = ACTIVE , tx = YES, bc = NO , oc = 001, hc = NO , perm = NO , reco = Y
B ***LOG BY2=> sql error -308 performing COM [dbcon 4411]
B ***LOG BY0=> [IQ Error SQL-308:08S01][Sybase IQ]Connection was terminated [dbcon 4411]
B ***LOG BYJ=> database function COMMIT for connection MSTD_MPX_READ_0 failed [dbcon 4422]
M ***LOG R38=> ThICommit, db_commit98 ( 001024) [thDatabase.c 385]
M ***LOG R18=> ThCPIC, ThICommit () [thxxcpic.c 2587]
M in_ThErrHandle: 1

Any suggestions pls....

Thanks,

Yuvaraj Subramani

[Gisung]

Hi,

Here is a KBA for connection issue in IQ.

2173714 - How to get debugging information for connection issues - SAP IQ
https://launchpad.support.sap.com/#/notes/2173714

You can see more detail information in srvlog file if you specify the -z, -zr parameter in cfg file.

Best Regards,
Gi-Sung Jang