Product: TIBCO Spotfire®
Received Error Message from MySQL database - "Failed to execute query: Streaming result set com.mysql.jdbc.RowDataDynamic@401 is still active. No statements may be issued when any streaming result sets are open and in use on a given connection."
Information link created from Oracle MYSQL database is not executing and throwing the below error:-
-----------------------------------------------------------------
InformationModelException at Spotfire.Dxp.Data:
Failed to execute query: Streaming result set com.mysql.jdbc.RowDataDynamic@40103fc2 is still active. No statements may be issued when any streaming result sets are open and in use on a given connection. Ensure that you have called .close() on any active streaming result sets before attempting more queries. (HRESULT: 80131500)
Stack Trace:
at Spotfire.Dxp.Data.InformationModel.InternalInformationModelManager.DataStream.GetNextBlock()
at Spotfire.Dxp.Data.InformationModel.InternalInformationModelManager.DataStream.Read(Byte[] buffer, Int32 offset, Int32 count)
at Spotfire.Dxp.Internal.Utilities.SeekableStream.Read(Byte[] buffer, Int32 offset, Int32 count)
at System.IO.BinaryReader.FillBuffer(Int32 numBytes)
at System.IO.BinaryReader.ReadUInt16()
at Spotfire.Dxp.Data.Formats.Sbdf.SbdfSectionHeader.ReadMagicNumber(BinaryReader reader)
at Spotfire.Dxp.Data.Formats.Sbdf.SbdfSectionHeader.ReadSectionType(BinaryReader reader, SbdfSectionTypeId expectedType)
at Spotfire.Dxp.Data.Import.SbdfDataRowReader.DelayedInit()
at Spotfire.Dxp.Data.Import.InformationLinkDataSourceConnection.ExecuteQueryCore2()
at Spotfire.Dxp.Data.DataSourceConnection.ExecuteQuery2()
------------------------------------------------------------------
To resolve this issue, follow the below steps:
1) Login to your Spotfire Server machine and launch "TIBCO Spotfire Server Configuration Tool" (UIConfig).
2) Enter your bootstrap password and then click on the "Configuration" Tab.
3) Now click on the "Data Source Template" and take a backup of MySQL data source template.
4) From MySQL jdbc template remove:
com.spotfire.ws.im.ds.sql.mysql.MySQLDriverSQLRuntime
</sql-runtime>
5) Save the configuration and then open the Information Designer once again.
6) Then set "FETCH SIZE" in data source element(Information Designer) to 0 and save data source element. This tells driver to use it's own default value. https://bugs.mysql.com/bug.php?id=39156
Comments
0 comments
Article is closed for comments.