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] > 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]] *On Behalf Of *LJ LongWing > *Sent:* Monday, December 19, 2016 2:22 PM > *To:* [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]> 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 <(312)%20676-8289> > > [email protected] | 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_ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
