Yep, that was it. As soon as he ran: create view V_EQUIPMENT_LIST as select * from <PUBLIC_DB_LINK>
I was able to pull them up. So, yes, we had views in remote DB for 8.1.2 but we now have local views in the 9.1.2 DB and all is working. Clearly, I didn't read the 9.1.2 instructions carefully. <facepalm> From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of LJ LongWing Sent: Tuesday, December 20, 2016 11:55 AM To: [email protected] Subject: Re: Creating view form in 9.1.2 Error:5165 ** Vinod mentioned yesterday (just after I replied) that 9.x doesn't support symonyms and require it to be a view in the Remedy DB that's doing the connections....is it or is it a view in the remote db.....try creating a local view if you don't have one and see if that helps Have you done this? https://docs.bmc.com/docs/display/public/ars91/Setting+up+a+remote+database+for+view+forms On Tue, Dec 20, 2016 at 10:47 AM, Sinclair, Keith <[email protected]<mailto:[email protected]>> wrote: ** Well, the columns are the same as the DB link for each system is pointed to the same external system, so the link is using the same VIEW table on the external DB. Like I said, link works fine in 8.1.2 but same exact DB link which tests fine in 9.1.2 DB cannot see squat. I am sure it's something simple but I just do not know what at this point. From: Action Request System discussion list(ARSList) [mailto:[email protected]<mailto:[email protected]>] On Behalf Of LJ LongWing Sent: Monday, December 19, 2016 2:22 PM To: [email protected]<mailto:[email protected]> Subject: Re: Creating view form in 9.1.2 Error:5165 ** Keith, If logged into the Remedy DB and issuing the same query, I assume you see the values expected. What are the types of columns available in the remote db and what are their sizes? I know that between 8.x and 9.x Remedy changed from C to Java...which means the criteria may have changed a bit as well, but shouldn't have changed significantly... On Mon, Dec 19, 2016 at 1:05 PM, Sinclair, Keith <[email protected]<mailto:[email protected]>> wrote: ** List, I am banging my head against the wall on this one as I am not finding out any decent information. I cannot create a view form that links to an external DB whereas the same view form in my 8.1.2 test system connects without issue. I have gone through both systems and they seem to be an apples to apples comparison. Both DB links are public database links. Both are accessible and working inside SQL developer. Thoughts? 5165 Error Table fields must have at least one column. Table fields must have at least one column. See the section on Tables for more information. 91.2 Running RedHat on Oracle 11g Keith Sinclair Remedy Development ShopperTrak Chicago, USA O 312.676.8289<tel:(312)%20676-8289> [email protected]<mailto:[email protected]> | shoppertrak.com<http://shoppertrak.com> Retail Profitability, Improved. _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
