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

Louie, David David.Louie at blackrock.com
Tue Aug 29 08:00:53 MST 2017


Ok.  We found the issue.

We have gremlins in our shop.

The functions object_id and object_name were pointing to 'dbo.ysobjects' and not 'dbo.sysobjects'  hense the object was not found.

Didn't think to reverse engineer the function and check the code as I would never have thought the function was not pointing to the correct table name.

David


-----Original Message-----
From: Mark Mumy [mailto:markdmumy at gmail.com] 
Sent: Monday, August 28, 2017 2:25 PM
To: Louie, David <David.Louie at blackrock.com>
Cc: IQ Users Group <iqug at dssolutions.com>
Subject: Re: [IQUG] [iqug] Error on select object_id on IQ 15.4 server (ESD 3)

Likely something in the ASE compatibility function is messed up.   Have you tried an alter database upgrade to have the proc reapplied?

I’d rewrite to be more native IQ friendly anyway:

if ( select 1 from systable where lower( table_name ) = ’t_stg_worldscope_prelim_keys’ and creator = suser_id ( ‘adewh_stg’ ) )
	is not null
select * from adewh_stg.t_stg_worldscope_prelim_keys

Mark


> On Aug 28, 2017, at 13:01, Louie, David <David.Louie at blackrock.com> wrote:
> 
> 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.
> <winmail.dat>_______________________________________________
> IQUG mailing list
> IQUG at iqug.org
> https://urldefense.proofpoint.com/v2/url?u=http-3A__iqug.org_mailman_l
> istinfo_iqug&d=DwIFaQ&c=zUO0BtkCe66yJvAZ4cAvZg&r=hvVkP5y30w3_fHBwXsoZ2pqbwQXietniE01Z666b0tE&m=J8YVXu1p_XIkzW-62br37Ljv0B4lVKv8Ueo9ndg3yA8&s=qvPORJRVL12EUn09ZT1O54Ugib1Mf7rgJRSpUm1xIQ0&e=



For a list of BlackRock's office addresses worldwide, see http://www.blackrock.com/corporate/en-us/about-us/contacts-locations.

© 2017 BlackRock, Inc. All rights reserved.


More information about the IQUG mailing list