question

dcotterman avatar image
dcotterman asked

Invalid metadata for column error?

I'm writing a query and getting this error. I've written other queries on the same database but not his specific table. It is through a linked server in MSSQL to Progress Openedge version 11.3.3.

Here is the query:

SELECT scheduled_qty FROM PROD_AXS.AXS.PUB.sols AS axs_sols

Here is the error:

The OLE DB provider "MSDASQL" for linked server "Prod_Axs" supplied invalid metadata for column "schedule_qty". The precision exceeded the allowable maximum.

Any help would be greatly appreciated.

Thanks

Dave

errorcolumnlinked servermetadata
5 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

What's the data type of PROD_AXS.AXS.PUB.sols.scheduled_qty? Sounds as though it could be fixed by an appropriate CAST / CONVERT.

0 Likes 0 ·

I've tried this but get the same error:

SELECT CAST(schedule_qty AS decimal(38, 6)) AS expr1

FROM PROD_AXS.AXS.PUB.sols AS axs_sols

0 Likes 0 ·

What datatype is schedule_qty?

0 Likes 0 ·

it is short text

0 Likes 0 ·

1 Answer

· Write an Answer
dcotterman avatar image
dcotterman answered

it is short text

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.