This field will be generated as varchar(max)

Posted by Valeriy Bashkatov on 19-Apr-2017 05:39

Hello,

Pro2Oracle v.4.6.7
OpenEdge 11.6.3 

When I generate "Target Schema" in the error log (SchemaCreateErrs.txt) appears warning for some fields:

Warning, <db-name>.<table-name>.<field-name>
- has a width greater than the max currently allowed.
- This field will be generated as varchar(max).
- Any associated Indices will therefore not be generated.

What problems can be with this when Pro2 work?
What and how I should do to fix this?

Regards,
Valeriy

Posted by Kunal Berlia on 20-Apr-2017 02:22

Hi,

There is no problem in it, it is just a warning. If the source field of a source table exceeds maximum width then it will show the above error. If the Width is more than 4000, then it will assign the field width as Varchar(4000).

The above error has been fixed in 5.0 release. In the Oracle, the maximum width for "VARCHAR" datatype allowed  is "4000".

Thanks.

All Replies

Posted by Kunal Berlia on 20-Apr-2017 02:22

Hi,

There is no problem in it, it is just a warning. If the source field of a source table exceeds maximum width then it will show the above error. If the Width is more than 4000, then it will assign the field width as Varchar(4000).

The above error has been fixed in 5.0 release. In the Oracle, the maximum width for "VARCHAR" datatype allowed  is "4000".

Thanks.

Posted by Valeriy Bashkatov on 24-Apr-2017 06:19

Thank you!

This thread is closed