Have you looked at the data types in the infomaker report? Could that be a small int somewhere as a data type? Just throwing ideas.
On Oct 10, 2017 18:28, Gawain Lavers wrote:
[cid:Tessitura_2D00_Network_2D00_logo_5F00_1500x421-png_2D00_150x42-png@tessituranetwork.com] Update from Tessitura Network
[cid:4TGCRL1SHNR9-jpg_2D00_70x70x2-jpg@tessituranetwork.com]
Gawain Lavers
Background: we have recently had our Test environment updated to v14. This means our SQL Server is now version 2016, and Infomaker is 12.6.
Since we were previously on SQL Server version 2008, I’ve been expecting some compatibility issues with our older custom code, particularly procedures backing old custom reports. I’d sorted through one issue, but now there’s a second with a very old, but unfortunately heavily used, custom report. For certain parameters, the report crashes with this error:
SQLSTATE = 22003
Microsoft OLE DB Provider for SQL Server
The floating point value '2.121995814680423E-314' is out of the range of computer representation (8 bytes).
I assumed this was another SQL incompatibility, although the number it was reporting really shouldn’t ever be getting generated.
The report is pretty ugly: about 10 procedures of poorly written SQL and about as many different Infomaker data windows to dig through. However, passing in duplicate parameters directly into the procedures produced no error messages. Passing the parameters into Infomaker did, so I started working my way through the datawindows to figure out where the error was bubbling up from. However, my trial died oddly in a datawindow that does not actually invoke and stored procedures: it’s rather the overall framing for a set of child datawindows, and simply passes the parameters down to them. The child datawindows do not generate the error on their own and the datawindow in question doesn’t seem to do any processing of any kind, not even any “expressions” (I’ve looked through all of the elements in the datawindow for anything like that).
I’m stumped: does any of this sound familiar to anyone?
View online
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
You received this notification because you subscribed to the forum. To stop receiving updates from only this thread, go here.
Flag this post as spam/abuse.
[https://community.tessituranetwork.com/notification/read?NotificationId=795cf40d-fed0-4cba-ab73-9a78a1860229]
Good thought: I've dug through it fairly carefully, but all the parameters are either String or Number.
I had found a number of cases where the parameter definition for a sub-report had a space in front of the name, but I've removed all of those, and it has made not difference.