Hi ZhaoKai,
Greetings!
I think the suggested solution was working for PS2020 but it is giving another error with PS2021.
Basically what is happening is that the SyntaxFromSQL function is referring to PB catalog/extended attributes tables which it could not find.
Upon analyzing we found that we have these tables were in another database within the same server. So we copied these tables to the connected database and then the error is resolved but for only those users who belong to dbo group(tables owner is dbo) like developers. But actual end users is still facing issue as the function is trying to refer these tables with transction user id like xyz.pbcatfmt etc.
We also tried adding "PBCatalogOwner='dbo'" to our app's transaction object connection string but no luck.
Kindly have a look into and suggest/advise if it is possible to somehow not to refer these tables by default or if need to refer is there some other way because in our production systems we do not have direct SELECT/UPDATE/INSERT permissions on tables.
Database backend is Sybase ASE 16 connected using ODBC ASE drivers
Error screenshot attached.
You may use any simple sql select statement like mentioned in this thread (no actual table rather table created and referred at runtime)
Thanks in advance and appreciate your help as always!
Thanks,
Nilotpal