SYBASE IQ 16

general discussion
1

Hello,

We have an extract, running daily, from one SYBASE ASE to SYBASE IQ 16.

It immediatly fails, due to an overuse of swap. This is due , regarding the explanation of system engineer, to a huge amount of line in the query : 6000000.
In fact the extract from ASE looks like working.
A temporary table is created in IQ, filled by the lines coming from ASE, and then a query is done on this temporary table and at this point the extract fails.

I dont understand why the swap is not freed.

Did you experienced that and how did you solve it ?

Regards

Jérôme

We get the following message
JZ00L : java.sql.SQLException: JZ00L: Echec de la connexion. Examinez les SQLWarnings associées à cette exception pour la ou les raisons suivantes :0 : JZ006 : java.sql.SQLWarning: JZ006: IOException détectée : java.io.IOException: JZ0EM: Fin des données.13665 : 01W01 : java.sql.SQLWarning: SQL Anywhere Error -301: Internal database error *** ERROR *** Assertion failed: 101413 (16.0.0.1359)
Unable to allocate a multi-page block of memory – transaction rolled back0 : JZ006 : java.sql.SQLWarning: JZ006: IOException détectée : java.io.IOException: JZ0EM: Fin des données.13665 : 01W01 : java.sql.SQLWarning: SQL Anywhere Error -301: Internal database error *** ERROR *** Assertion failed: 101413 (16.0.0.1359)
Unable to allocate a multi-pageblock of memory – transaction rolled back
java.sql.SQLException: JZ00L: Echec de la connexion. Examinez les SQLWarnings associées à cette exception pour la ou les raisons suivantes :
at com.sybase.jdbc3.jdbc.ErrorMessage.raiseError(Unknown Source)
at com.sybase.jdbc3.tds.Tds.processLoginAckToken(Unknown Source)
at com.sybase.jdbc3.tds.Tds.doLogin(Unknown Source)
at com.sybase.jdbc3.tds.Tds.login(Unknown Source)
at com.sybase.jdbc3.jdbc.SybConnection.tryLogin(Unknown Source)
at com.sybase.jdbc3.jdbc.SybConnection.handleHAFailover(Unknown Source)
at com.sybase.jdbc3.jdbc.SybConnection.(Unknown Source)
at com.sybase.jdbc3.jdbc.SybConnection.(Unknown Source)
at com.sybase.jdbc3.jdbc.SybDriver.connect(Unknown Source)
at com.sunopsis.sql.SnpsConnection.u(Unknown Source)
at com.sunopsis.sql.SnpsConnection.c(Unknown Source)
at com.sunopsis.sql.i.run(Unknown Source)

grodeg (BOB member since 2013-02-22)

2

Is this post related to a Business Objects product?

Nick Daniels :uk: (BOB member since 2002-08-15)

3

It probably is now since SAP includes Sybase IQ (they now call it SAP IQ) in some of it’s packages. Unfortunately I do not know enough about Sybase IQ to speculate what might be the issue.

kevlray :us: (BOB member since 2010-06-23)

4

Not enough memory - committing in smaller sizes would probably help.