On Thursday 10 December 2009 21:16:14 Joe D'Souza wrote: > Hello Victor, > > That is what I suspected with the invalid identifier error.. if your table > was not recognized it would be invalid table or view name error which is > not your case.. Which is why the later part of my previous email holds > good.. Take a SQL log, you may find that offending column name or columns.. > > There is something in the way that ARS is naming the offending column or > columns causing that error.. > > When you find what column it is email the list or me directly and we'll try > to figure it out.. you might need to create a independent view in MS-SQL of > that table having names of fields that are legal to use in case there is a > column name there that the ARS converts into something else.. This is just > a speculative solution, we'll know more when you know more.. > > Cheers > > Joe > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[email protected]]on Behalf Of Victor > Sent: Thursday, December 10, 2009 3:00 PM > To: [email protected] > Subject: Re: View form from Oracle based AR system to remote MS SQL > server > > > Thanks Joe, > > I will try all you said and have you posted tomorrow(I'm out of office at > the moment) but I want to point out that will creating the view form I was > able to load the table and the pick the fields required for the form. > Only when I pressed "Create" the error occurred. > > .. and furthermore the ms sql username and password was hard-cored into the > public DB link created > > Victor > > ___________________________________________________________________________ >____ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are" Joe,
Thank you for pointing me to the right direction!. I set on SQL log as suggested and found out that while SELECTing fields from MSSQL server to create a view in Oracle for the view form, ARS was unable to parse fields created in Oracle db with fields from MSSQL server. This is because the field names in MSSQL were in lowercases while in Oracle they were all in uppercases! (can this behaviour be changed?) I redo the fields in SQL server to uppercases and I was able to complete the creation of the view form!. Thanks a lot for that. However, when I tried to submit to the form I received this error: "ARERR [552] Failure during SQL operation to the database: ORA-02047: cannot join the distributed transaction in progress" Once again I set on the SQL log. ARS was trying to INSERT the required values to the view created for the view form when the error occurred. I ran the command ARS was trying to run in sqlplus and it was executed successfully. Do you have an Idea what might be the cause of the error in ARS? Thanks very much for you suggestions so far. Victor _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
