CommentText has value exceeding its max length (ODBC)

Yahoo Archive
1
The operation text does go to the displayed page. It is 1000
characters, in fact, it is usually a single JobOper record that does it
(particular work centers). The query already selects the fields I want
and nothing else.

How could I define a substring in a query then, so I can test it out?




Andrew

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Mark Wonsil
Sent: Tuesday, May 02, 2006 1:42 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] CommentText has value exceeding its max length
(ODBC)


> We are currently on Vantage 6.1 with a Progress 9.1D database. I am
> connecting to Vantage (Progress) from an ASP page via a component
built
> in VB.Net using a DSN-less connection string, but occasionally get
this
> error.
>
> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
> '[DataDirect-Technologies][ODBC PROGRESS driver][PROGRESS]Column
> CommentText in table PUB.JobOper has value exceeding its max length or
> precision.
>
> Has anyone delt with this error before?

Are you using that text in the ASP screen? If not, create a query that
accesses JobOper and select only the fields you want. If you are using
it, do
you need to display all 1000 records? If not, you can send a substring
of the
text as a defined item in the query.

Mark W.



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links




SPONSORED LINKS
Manufacturing software
<http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+softw
are&w4=Pda+database+software&w5=Database+management+software&w6=Database
+marketing+software&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA>
Membership database software
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ>
Database mortgage software
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manuf
acturing+software&w2=Membership+database+software&w3=Database+mortgage+s
oftware&w4=Pda+database+software&w5=Database+management+software&w6=Data
base+marketing+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A>
Pda database software
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufactur
ing+software&w2=Membership+database+software&w3=Database+mortgage+softwa
re&w4=Pda+database+software&w5=Database+management+software&w6=Database+
marketing+software&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg> Database
management software
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw>
Database marketing software
<http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manu
facturing+software&w2=Membership+database+software&w3=Database+mortgage+
software&w4=Pda+database+software&w5=Database+management+software&w6=Dat
abase+marketing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw>

________________________________

YAHOO! GROUPS LINKS



* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .


________________________________




[Non-text portions of this message have been removed]
2
We are currently on Vantage 6.1 with a Progress 9.1D database. I am
connecting to Vantage (Progress) from an ASP page via a component built
in VB.Net using a DSN-less connection string, but occasionally get this
error.

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
'[DataDirect-Technologies][ODBC PROGRESS driver][PROGRESS]Column
CommentText in table PUB.JobOper has value exceeding its max length or
precision.

Has anyone delt with this error before?

I found that some of our Operations have greater than 1000 characters in
the CommentText field. So far, the only options I see are to either
edit the Data Dictionary, or edit the comment text (not likely). I did
read a mention about dbtools or something like that, but we are on 9.1D,
not OpenEdge. My short-term solution is to detect the error and re-run
with a new SQL that NOT's out the offending operation (a particular work
center), but that will not work in the long run for what we want to
accomplish. Any help/insight is greatly appreciated.



Thanks in Advance!


Andrew Reed

Office Automation Specialist
Crestview Aerospace Corporation



[Non-text portions of this message have been removed]
3
> We are currently on Vantage 6.1 with a Progress 9.1D database. I am
> connecting to Vantage (Progress) from an ASP page via a component built
> in VB.Net using a DSN-less connection string, but occasionally get this
> error.
>
> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
> '[DataDirect-Technologies][ODBC PROGRESS driver][PROGRESS]Column
> CommentText in table PUB.JobOper has value exceeding its max length or
> precision.
>
> Has anyone delt with this error before?

Are you using that text in the ASP screen? If not, create a query that
accesses JobOper and select only the fields you want. If you are using it, do
you need to display all 1000 records? If not, you can send a substring of the
text as a defined item in the query.

Mark W.