ServerError 4864

[creacionesintegrales]

📝 Provide detailed reproduction steps (if any)

1. Upsize database to SQLSERVER version 15
2. At table ENAUTOCO error

✔️ Expected result

What is the expected result of the above steps?

Finish normal

❌ Actual result

What is the actual result of the above steps?

Error Wizard

📷 Screenshots

Are there any useful screenshots? WinKey+Shift+S and then just paste them directly into the form

I upload table, index and outputfile
upsize.zip

[creacionesintegrales]

When you give the error in the table should allow you to skip the table and continue with the rest. Instead it hangs and ends the conversion with error.

[creacionesintegrales]

The error occurs in the ExecuteSproc procedure when you want to process field 6. It is a date but does not recognize it as such does not load the array. It is for this reason that when processing this line
&lcArrayType.[lnCurrentRow, lnCurrentField] = trim(lcValue)
The error occurs

[creacionesintegrales]

I corrected the mistake.
Where he said:

• If this field is being upsized to Varchar, trim its values.
  lcField = field(lnCurrentField)
  lnField = ascan(laFieldNames, lcField, -1, -1, 1, 15)
  if lnField > 0
  for lnCurrentRow = 1 to &lcNumberofRows
  lcValue = &lcArrayType.[lnCurrentRow, lnCurrentField]
  &lcArrayType.[lnCurrentRow, lnCurrentField] = trim(lcValue)
  next lnCurrentRow
  endif lnField > 0

Now says

• If this field is being upsized to Varchar, trim its values.
  lcField = field(lnCurrentField)
  lnField = ascan(laFieldNames, lcField, -1, -1, 1, 15)
  if lnField > 0
  for lnCurrentRow = 1 to &lcNumberofRows
  lcValue = &lcArrayType.[lnCurrentRow, lnCurrentField]
  IF EMPTY(lcValue)
  &lcArrayType.[lnCurrentRow, lnCurrentField] = ''
  else
  &lcArrayType.[lnCurrentRow, lnCurrentField] = trim(lcValue)
  endif
  next lnCurrentRow
  endif lnField > 0

[DougHennig]

I cannot reproduce that error with the table you attached: it upsizes properly for me.

laFieldNames is an array containing only the names of fields being upsized to varchar. I am not sure why that date field was included in the array for you.

[creacionesintegrales]

lcValue = &lcArrayType.[lnCurrentRow, lnCurrentField]

lcValue in some cases it brings me .f. and that’s why it’s wrong.

I made the change I indicated and the error did not give me.

[DougHennig]

That is a symptom of the problem but not the problem itself. The real problem is why the Upsizing Wizard thinks the date field should be upsized as varchar. I do not have an answer for that.