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:

CREATE MODEL MyModel PREDICTING (IsError BOOLEAN) FROM Example3.ModelTable

TRAIN MODEL MyModel AS MyModelTrained

SELECT PREDICT(MyModel) IsErrorPrediction,* FROM Example3.TestSet

 

Is there something I'm missing?

Thanks,

Don Martin

Product version: IRIS 2021.1
$ZV: IRIS for UNIX (Ubuntu Server LTS for x86-64 Containers) 2021.1 (Build 215.3U) Wed Oct 27 2021 17:38:26 EDT [Health:3.3.0]
0
0 310
Discussion (4)2
Log in or sign up to continue

Sorry to hear you ran into this. The issue was also detected during recent internal testing and we're in the process of fixing it. 

Just wondering if this issue has been fixed in a new community edition release?

I've tried running a couple of newer containers to see if the issue was fixed in newer versions of the community edition, however, I'm not able to get the containers started.  

containers.intersystems.com/intersystems/irishealth-ml-community:2021.2.0.651.0

containers.intersystems.com/intersystems/irishealth-ml-community:2022.1.0.209.0

I get the following in the /store/iconfig/mgr/messages.log file when trying to start either instance.

07/07/22-20:58:55:213 (412) 0 [Utility.Event] ISC_DATA_DIRECTORY=/store/iconfig/
07/07/22-20:58:55:224 (412) 0 [Utility.Event] Executing /usr/irissys/bin/iris qlist
07/07/22-20:58:55:329 (412) 0 [Utility.Event] Versions are different
07/07/22-20:58:55:329 (412) 0 [Utility.Event] Source /usr/irissys/: 2021.2.0.651.0com
07/07/22-20:58:55:329 (412) 0 [Utility.Event] Destination /store/iconfig/: 2021.1.0.215.3com
07/07/22-20:58:55:351 (412) 0 [Utility.Event] Executing /usr/irissys/bin/iris version
07/07/22-20:58:55:354 (412) 0 [Utility.Event] Performing upgrade of /store/iconfig/ from /usr/irissys/
07/07/22-20:58:55:354 (412) 0 [Utility.Event] Upgrading from version 2021.1.0.215.3com to 2021.2.0.651.0com
07/07/22-20:58:55:354 (412) 0 [Utility.Event] Executing /usr/irissys/bin/iris qlist
07/07/22-20:58:55:380 (412) 0 [Utility.Event] Executing /usr/irissys/bin/irisdb -s/store/iconfig/mgr/ -cd
07/07/22-20:58:55:470 (412) 0 [Utility.Event] Executing rm -f shuttest.txt
07/07/22-20:58:55:540 (412) 3 [Utility.Event] Error during Upgrade,ERROR #5001: Instance IRIS was not shut down correctly, may have been forced