Question Don Martin · Jul 22 SQL Gateway getClob() errors in Redshift and Postgresql I'm trying to use the EnsLib.SQL.Operation.GenericOperation component in a production to read a column from a Redshift table that is set up as VARCHAR(65535) and am getting the following error. An error was received : ERROR #5023: Remote Gateway Error: JDBC Gateway getClob(0,1) errorRemote JDBC error: Cannot convert the column of type VARCHAR to requested type long.. #SQL #Health Connect #InterSystems IRIS for Health 1 5 0 95
Question Don Martin · Jan 31, 2022 IntegratedML SQL PREDICT/PROBABILITY Error I've been playing with IntegratedML and have created a model and trained the model. When I try to use PREDICT or PROBABILITY statements in an SQL query, I get the following error: [SQLCODE: <-400>:<Fatal error occurred>] [%msg: <PREDICT execution error: ERROR #5002: ObjectScript error: <OBJECT DISPATCH>%LoadModel+31^%ML.AutoML.TrainedModel.1 *<class 'AttributeError'>: 'str' object has no attribute 'decode' - >] Here's an example of the sequence of steps I've followed that lead to the error: #IntegratedML #InterSystems IRIS for Health 0 4 0 402