topic Using Parameters in Model causes Error; Solutions or Alternatives? in ModelBuilder Questions

Using Parameters in Model causes Error; Solutions or Alternatives?

StefanieSteinbach — Wed, 23 Jul 2014 13:23:43 GMT

Dear all,

I have set up a workflow in model builder, with several variables set as parameters.

Thus, for example the cell size of my initial raster (a parameter) is used for further calculations in SQL commands. Executing the model with the actual cell size put into the calculations manually by me works fine, whereas using "%CellSize%" produces an error.

Did anyone encounter a similar problem or has an idea for a solution? For the sake of user-friendliness it is vital that the variables function as parameters.

Thanks in advance.

Re: Using Parameters in Model causes Error; Solutions or Alternatives?

AdamMarinelli — Wed, 23 Jul 2014 13:29:32 GMT

Can you post a screenshot or more details about your model? What is the error you are getting?

Re: Using Parameters in Model causes Error; Solutions or Alternatives?

StefanieSteinbach — Wed, 23 Jul 2014 14:19:31 GMT

Yes sure, these are what's in the command (cost grid) and the error. Tell me if you need more information.

Re: Using Parameters in Model causes Error; Solutions or Alternatives?

JohannesBierer — Wed, 23 Jul 2014 14:32:30 GMT

This looks quite complicated, wouldn't it be a idea to export your model into python code.

In my opinion you would have better control about your variables ... ?

Re: Using Parameters in Model causes Error; Solutions or Alternatives?

AdamMarinelli — Wed, 23 Jul 2014 14:47:17 GMT

How are you actually pulling out the CellSize from your initial raster?

Re: Using Parameters in Model causes Error; Solutions or Alternatives?

StefanieSteinbach — Wed, 23 Jul 2014 14:59:19 GMT

It's just a 'cell size' variable with the input being the DEM. I am then using it as I would use an 'any value' variable. Same with the "%ElevationDifference%".

Re: Using Parameters in Model causes Error; Solutions or Alternatives?

StefanieSteinbach — Wed, 23 Jul 2014 15:03:11 GMT

The model itself is also quite complicated, so I find the better overview provided by model builder advantageous. Also, I am not too familiar with python coding.

And if it is not a bug in model builder, there should be a way to get this to work shouldn't it? I'm just running out of ideas

Re: Using Parameters in Model causes Error; Solutions or Alternatives?

AdamMarinelli — Wed, 23 Jul 2014 15:22:17 GMT

Try removing the quotations from around %Cell Size% as it is a number and not a string.

Re: Using Parameters in Model causes Error; Solutions or Alternatives?

StefanieSteinbach — Wed, 23 Jul 2014 15:47:43 GMT

Hm, it tried, but now it says it is an invalid SQL statement

Re: Using Parameters in Model causes Error; Solutions or Alternatives?

AdamMarinelli — Wed, 23 Jul 2014 15:53:22 GMT

Is the "invalid SQL statement" error occurring on the Raster Calculator or somewhere else in the model?

Re: Using Parameters in Model causes Error; Solutions or Alternatives?

StefanieSteinbach — Thu, 24 Jul 2014 07:13:07 GMT

Yes, it's the SQL statement from the raster calculator I use to calculate a cost grid with.

Re: Using Parameters in Model causes Error; Solutions or Alternatives?

AdamMarinelli — Thu, 24 Jul 2014 13:39:53 GMT

Without seeing or working with your model it is hard to troubleshoot. I would recommend exporting copies of the three input rasters that are part of the equation and creating a simpler model with just the raster calculator tool to see if you get different results.

Additionally, as the original error states, the problem is not with the Cell Size, but with the "GreaterThan" part of the equation.