Skip to main content

We recently upgraded both Form and Flow to 2023.1 after we ran some workspace from form and flow we encountered that they were failing on the writer part with the following error message: "Too many values to bind. Found '127' when expecting a max of '100' ".

It seems that FME is not able to write the data to an Oracle Spatial DB if the amount of attributes is greater than 100. When we reduce the amount of attributes to lower then 100 there is no such message and the writing is succesful.

The problem is that I cannot reduce the amount of columns below 100 (the DB design is debatable I know 😉 ). Is this supposed to work like this or is it a bug in the writer?

 

Hi @mbulkmans​ this is a known issue with FME 2023.1. The fix will be available in FME 2023.2. Is this affecting your current workflow or are you able to use an older version of FME 2023.x? That would be the current workaround.


Hi @danminneyatsaf​ ,

 

thanks for the answer. For the moment we have removed the attributes that at this moment are always empty and we managed to get the total below 100. We will wait with the upgrade until 2023.2 is out of beta.


Hi @danminneyatsaf - 

Have there been any additional patches or fixes made available for FMEFLow 2023.1 to resolve this issue? Upgrading beyond that version is not an option for us at this time.

 


Hi @jambrogi, there are no plans to backport the fix to FME 2023.1. The fix was made available in FME 2023.2 (Build 23701) and newer.

If you cannot upgrade to FME 2023.2, then you could use the SQLCreator/SQLExecutor to write to the table. I’ve attached a workspace which demonstrates the workaround to this reply.

 

Hope this helps!


Reply