Order Comment field exceeds max length or precision - Vantage 8

Yahoo Archive
1
This is a progress issue. I've run into it several times. I don't recal the
exact solution, but if you search it on the OpenEdge knowledge base it
should come right up.

*John Driggers*
**
*Chief Data Wrangler*
*
*
*I have an Epicor blog <http://usdoingstuff.com/>. How useful is that?*
*
*:: 904.404.9233
:: waffqle@...
:: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>

*

*



On Thu, Sep 20, 2012 at 2:21 PM, Richard <rgraf@...> wrote:

> **
>
>
> Hi,
> Working with Vantage 8.03 and I'm trying to pull a field into a Crystal XI
> report. My report works great until I try to add the
> `OrderHed.OrderComment' field. As soon as I do I get a "Failed to retrieve
> data" error and then this error message:
>
> Database Connector Error: 'HY000:[DataDirect][ODBC Progress OpenEdge Wire
> Protocol driver][OPENEDGE]Column OrderComment in table PUB.OrderHed has
> value exceeding its max length or precision.[Database Vendor Code:-210012]'
>
> I use this same field in other reports with no troubles.
>
> Someone must have an idea how I can resolve this.
>
> Thanks in advance for ANY advice.
> Rick
>
>
>


[Non-text portions of this message have been removed]
2
Hi,
Working with Vantage 8.03 and I'm trying to pull a field into a Crystal XI report. My report works great until I try to add the `OrderHed.OrderComment' field. As soon as I do I get a "Failed to retrieve data" error and then this error message:

Database Connector Error: 'HY000:[DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Column OrderComment in table PUB.OrderHed has value exceeding its max length or precision.[Database Vendor Code:-210012]'

I use this same field in other reports with no troubles.

Someone must have an idea how I can resolve this.

Thanks in advance for ANY advice.
Rick
3
Rick,

Here is what I have received from Epicor on an issue similar to this before. See if this applies to your situation:

PROBLEM DESCRIPTION: This error or a similar error occur while using the DataDirect ODBC drive to pull information out of V8.00 to another program.

Database Connector Error: 'HY000:[DataDirect] [ODBC OPENEDGE drive] [OPENEDGE] Column <FieldName> in table PUB.<TableName> has value exceeding its max length or precision. [Database Vendor Code: -210012]'

PROBLEM RESOLUTION: The problem stems from a field within the Data Dictionary titled "SQL Width". This field can be set from 0 to 31995. The error occurs when there are more characters within the data field than what the SQL Width value is for. This typically occurs for fields that contain large descriptions or comments. Example: PartDesc, Comments, LineDesc, etc.

STEPS to Correct:
=-=-=-=-=-=-=-=-=-=--=-=-=-=-=-=-=-=--=-=-=-=-=-=-=-=-=-=-=--=-
Notes:
- The following steps should be done from the Server, with everyone logged out of Vantage.
- The syntax below is for V8.00. For V8.03 and OE 10.0B or OE 10.1B, adjust the syntax accordingly.

Stop the appserver

1. Go Start->Programs->Open Edge 10.0B->Data Dictionary.
2. Right-click on the Data Dictionary and choose Properties.
3. Add a -rx to the end of the Target line.
4. In the Dictionary Startup window, choose Connect to an Existing Database and click OK.
5. For the Physical Name, type mfgsys and click Options.
6. Choose Network TCP, check the Multiple Users box, put in you V8.00 server for Host Name, put in the port number of you database for Service Name (the default is 8000), and click OK.
7. In the Tables column, search for the table referenced in the error message. Highlight it and click the Fields button above.
8. In the Fields column, search for the field reference in the error message. Highlight it.
7. Go to the top of the window and select Options->Adjust Field Width.
10. Double click into the "Width" column on the Field which is causing the error.
11. Change the value to a number higher than the number of characters you have in the field or just use the maximum value of 31995.
12. Click [OK] and save the updates.
13. Close and exit the Data Dictionary.
14. Repeat the process that generated the error message.
15. Remove the -rx from the Target of the Data Dictionary Properties.

XA800
XA803


[Description: Description: Description: logo]
Austin Skrepak
Data Specialist / Developer
[Description: PHONE] 712.324.4854 Ext: 2019
[Description: EMAIL] askrepak@...<mailto:askrepak@...>
"Achievement is largely the product of steadily raising one's levels of aspiration and expectation."
- Jack Nicklaus

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Richard
Sent: Thursday, September 20, 2012 1:21 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Order Comment field exceeds max length or precision - Vantage 8.03



Hi,
Working with Vantage 8.03 and I'm trying to pull a field into a Crystal XI report. My report works great until I try to add the `OrderHed.OrderComment' field. As soon as I do I get a "Failed to retrieve data" error and then this error message:

Database Connector Error: 'HY000:[DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Column OrderComment in table PUB.OrderHed has value exceeding its max length or precision.[Database Vendor Code:-210012]'

I use this same field in other reports with no troubles.

Someone must have an idea how I can resolve this.

Thanks in advance for ANY advice.
Rick



[Non-text portions of this message have been removed]