Maximo Open Forum

 View Only

 Doclinks to Asset Table --Error converting data type varchar to bigint.

  • Analytics
  • Assets
  • Everything Maximo
Ashley Green's profile image
Ashley Green posted 03-08-2024 12:06

I have this query and get error below. How can I correct my query.

Error converting data type varchar to bigint.

QUERY

SELECT a.assetnum,a.description,di.document,di.description,di.urlname
FROM docinfo di
JOIN doclinks dl ON dl.docinfoid=di.docinfoid
JOIN asset a ON a.assetnum=dl.ownerid
WHERE dl.ownertable='ASSET';

Alex Walter's profile image
Alex Walter posted 03-09-2024 09:29

Ashley,

Try changing your second join clause to:

JOIN asset a ON a.assetuid=dl.ownerid

The OWNERID column is the sequenced numeric value assigned to each row in each table in the database. It can be found for each table in the Database Configuration application:

Hope this helps,

Alex

Related Content