[IQUG] [iqug] Error on select object_id on IQ 15.4 server (ESD 3)

Louie, David David.Louie at blackrock.com
Mon Aug 28 11:01:39 MST 2017


if object_id('adewh_stg.t_stg_worldscope_prelim_keys') is not null
select * from adewh_stg.t_stg_worldscope_prelim_keys


>[SQL] Script lines: 1-3 ----------------------------
if object_id('adewh_stg.t_stg_worldscope_prelim_keys') is not null
select * from adewh_stg.t_stg_worldscope_prelim_keys _

>[Error] Script lines: 1-3 --------------------------
SQL Anywhere Error -141: Table 'ysobjects' not found
Msg: 2706, Level: 11, State: 0
Line: 0 _


This is only happening on one of our IQ 15.4 servers.  Strange that it's looking for 'ysobjects' and not 'sysobjects'

Anyone ever seen this before?

Thanks
David


This message may contain information that is confidential or privileged. If you are not the intended recipient, please advise the sender immediately and delete this message. See http://www.blackrock.com/corporate/en-us/compliance/email-disclaimers for further information.  Please refer to http://www.blackrock.com/corporate/en-us/compliance/privacy-policy for more information about BlackRock's Privacy Policy.
For a list of BlackRock's office addresses worldwide, see http://www.blackrock.com/corporate/en-us/about-us/contacts-locations.

(c) 2017 BlackRock, Inc. All rights reserved.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: winmail.dat
Type: application/ms-tnef
Size: 12489 bytes
Desc: not available
URL: <http://iqug.org/pipermail/iqug/attachments/20170828/1b556465/attachment-0001.bin>


More information about the IQUG mailing list