View form issues
Folks, I have been trying to create a view form from one remedy/bmc server to another. It should not be rocket science, but maybe it is. I have the db link setup and this is what I am putting into the field to load [EMAIL PROTECTED] When I push the load button it says Requested database table not found. Please check the spelling (table name is case-sensitive) (ARERR 481). I have another view that is going to a completely different oracle DB and it is working. Config1: Solaris 9/oracle 10g/ARS 7.0.1 Config2: Solaris 9/oracle 9i/ARS5.1.2 Tell me it is not rocket science. -- *Rocky* Rocky Rockwell eMA Team – Remedy Developer [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Ph#1: 214-567-8874 Ph#2: 325-884-1263 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: View form issues
Does the same syntax work from a SQL Plus prompt within the ARSystem database? On 1/19/07, Rocky Rockwell [EMAIL PROTECTED] wrote: Folks, I have been trying to create a view form from one remedy/bmc server to another. It should not be rocket science, but maybe it is. I have the db link setup and this is what I am putting into the field to load [EMAIL PROTECTED] When I push the load button it says Requested database table not found. Please check the spelling (table name is case-sensitive) (ARERR 481). I have another view that is going to a completely different oracle DB and it is working. Config1: Solaris 9/oracle 10g/ARS 7.0.1 Config2: Solaris 9/oracle 9i/ARS5.1.2 Tell me it is not rocket science. -- *Rocky* Rocky Rockwell eMA Team – Remedy Developer [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Ph#1: 214-567-8874 Ph#2: 325-884-1263 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are -- Frank Caruso Specific Integration, Inc. Senior Remedy Engineer, ITIL Foundation Certified www.specificintegration.com 703-376-1249 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: View form issues
Yep, I do not understand it. I am sure it is something obvious, but I cannot see the forest for the trees. *Rocky* Rocky Rockwell eMA Team – Remedy Developer [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Ph#1: 214-567-8874 Ph#2: 325-884-1263 Frank Caruso wrote: ** Does the same syntax work from a SQL Plus prompt within the ARSystem database? On 1/19/07, *Rocky Rockwell* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Folks, I have been trying to create a view form from one remedy/bmc server to another. It should not be rocket science, but maybe it is. I have the db link setup and this is what I am putting into the field to load [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]. When I push the load button it says Requested database table not found. Please check the spelling (table name is case-sensitive) (ARERR 481). I have another view that is going to a completely different oracle DB and it is working. Config1: Solaris 9/oracle 10g/ARS 7.0.1 Config2: Solaris 9/oracle 9i/ARS5.1.2 Tell me it is not rocket science. -- *Rocky* Rocky Rockwell eMA Team – Remedy Developer [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Ph#1: 214-567-8874 Ph#2: 325-884-1263 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org http://www.arslist.org ARSlist:Where the Answers Are -- Frank Caruso Specific Integration, Inc. Senior Remedy Engineer, ITIL Foundation Certified www.specificintegration.com http://www.specificintegration.com 703-376-1249 __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: View form issues
Never mind. It was not rocket science, but it was being stupid on my part. The owner.CHG_Change needed to be OWNER.CHG_CHANGE. Just in case other have issues. *Rocky* Rocky Rockwell eMA Team – Remedy Developer [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Ph#1: 214-567-8874 Ph#2: 325-884-1263 Frank Caruso wrote: ** Does the same syntax work from a SQL Plus prompt within the ARSystem database? On 1/19/07, *Rocky Rockwell* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Folks, I have been trying to create a view form from one remedy/bmc server to another. It should not be rocket science, but maybe it is. I have the db link setup and this is what I am putting into the field to load [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]. When I push the load button it says Requested database table not found. Please check the spelling (table name is case-sensitive) (ARERR 481). I have another view that is going to a completely different oracle DB and it is working. Config1: Solaris 9/oracle 10g/ARS 7.0.1 Config2: Solaris 9/oracle 9i/ARS5.1.2 Tell me it is not rocket science. -- *Rocky* Rocky Rockwell eMA Team – Remedy Developer [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Ph#1: 214-567-8874 Ph#2: 325-884-1263 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org http://www.arslist.org ARSlist:Where the Answers Are -- Frank Caruso Specific Integration, Inc. Senior Remedy Engineer, ITIL Foundation Certified www.specificintegration.com http://www.specificintegration.com 703-376-1249 __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are