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
Toggle Comment visibility. Current Visibility: Viewable by all users

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

ThomasRushton avatar image ThomasRushton ♦♦ commented ·

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 ·
Show more comments
dcotterman avatar image dcotterman commented ·

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 ·
Show more comments
dcotterman avatar image dcotterman commented ·

it is short text

0 Likes 0 ·

1 Answer

·
dcotterman avatar image
dcotterman answered

it is short text

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

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.