)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Timothy Powell
Sent: Wednesday, July 15, 2015 5:42 PM
To: arslist@ARSLIST.ORG
Subject: Re: View Forms and Attachments
**
Follow-up.
I have now tested this on an ARS 8.1 server with the same results.
I am still doing a set fields FROM the view form
Subject: Re: View Forms and Attachments - Resolved (Partially)
**
Resolved (partially).
Thanks to some help from Ganesh Gore and Jason Miller I was able to identify a
workaround.
Part of the data I was receiving from the web form was some information related
to the attachment, specifically:
1
: View Forms and Attachments
**
Thanks Doug. I did open a support ticket.
As a follow-up.
I added the extra step of doing a set fields FROM the view form TO the staging
form where View Form Request ID (VFRI) = the stored value of the VFRI on the
staging form and setting the attachment
003
C103962
0x1F8C020002000BD103006087D843
Tim
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Mueller, Doug
Sent: Friday, April 24, 2015 4:13 PM
To: arslist@ARSLIST.ORG
Subject: Re: View Forms
is posted to a database residing on the same database instance
the ARSystem DB resides on.
Attachment data is posted to a SQL Image column.
I have created a view form to see the posted data. Per page 190 of the
7.6.04 Integrations Guide:
# Beginning with release 7.6.02, view forms support
to a SQL Image column.
I have created a view form to see the posted data. Per page 190 of the 7.6.04
Integrations Guide:
# Beginning with release 7.6.02, view forms support additional data types. This
includes blobs (DB2, Oracle, and Informix) and images (Microsoft SQL Server and
Sybase), which map
To: arslist@ARSLIST.ORG
Subject: Re: View Forms and Attachments
**
Tim,
I regret to inform you that you have found a bug in BMC's server. You should
not be able to do anything to crash a server, period. I see that you are
already running the latest SP of your version, so I can't recommend doing
this correctly and the crash is an
un-intended consequence?
TP
*From:* Action Request System discussion list(ARSList) [mailto:
arslist@ARSLIST.ORG] *On Behalf Of *LJ LongWing
*Sent:* Friday, April 24, 2015 2:16 PM
*To:* arslist@ARSLIST.ORG
*Subject:* Re: View Forms and Attachments
**
Tim
] On Behalf Of Timothy Powell
Sent: Friday, April 24, 2015 11:54 AM
To: arslist@ARSLIST.ORG
Subject: Re: View Forms and Attachments
**
LJ,
Thanks for the quick reply.
Ok, so you’re saying that I am doing this correctly and the crash is an
un-intended consequence?
TP
From: Action Request System
failed within
the SQL database.
Form is created successfully, but the SQL view is not in place.: view name
where view name here is the name of the courtesy SQL view that Remedy
creates for each form (e.g. the Customer SQL view ARS will create for
your Customer form).
For view forms, the T table itself
view is not in place.: view
name
where view name here is the name of the courtesy SQL view that Remedy
creates for each form (e.g. the Customer SQL view ARS will create for
your Customer form).
For view forms, the T table itself is a SQL view defined on the
underlying SQL table (or view
SQL view that Remedy
creates for each form (e.g. the Customer SQL view ARS will create for
your Customer form).
For view forms, the T table itself is a SQL view defined on the
underlying SQL table (or view), and the courtesy SQL view that ARS then
creates is simply another SQL view on top
, but fundamentally, there is no issue
with Web Services and a
field 8 requirement.
Doug Mueller
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing
Sent: Tuesday, February 11, 2014 12:28 PM
To: arslist@ARSLIST.ORG
Subject: Re: View forms and Web
We use view forms in our application. Hence, not all the core fields are
present.
When executing a web service (probably on mid-tier also), an ARERR 9130 occurs
and report ???: 8 Field does not exist ... and a http 500 error is returned
(Internal Server Error).
I haven't touched a remedy web
discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Mac McMillan
Sent: Tuesday, February 11, 2014 12:05 PM
To: arslist@ARSLIST.ORG
Subject: View forms and Web Service ARERR 9130
We use view forms in our application. Hence, not all the core fields are
present.
When executing a web
Web service plugin uses field 8, any form that consumes a web service must
have a field 8 :)
On Feb 11, 2014 11:15 AM, Mac McMillan bethel.mcmil...@twtelecom.com
wrote:
We use view forms in our application. Hence, not all the core fields are
present.
When executing a web service (probably
, 2014 1:18 PM
To: arslist@ARSLIST.ORG
Subject: Re: View forms and Web Service ARERR 9130
Check your mapping and workflow. We use web services against View and Join
forms without this issue.
What is your web service doing? If it is doing a Push fields to another form
that may be where the issue
back to the user.
Fred
-Original Message-
From: Action Request System discussion list(ARSList) [mailto:
arslist@ARSLIST.ORG] On Behalf Of LJ LongWing
Sent: Tuesday, February 11, 2014 1:27 PM
To: arslist@ARSLIST.ORG
Subject: Re: View forms and Web Service ARERR 9130
**
Web service
I am looking into some possible migrations from different databases (SQL 2005)
to BMC 7.6.04 (SQL 2005). I can access the external databases (not AR SYSTEM)
using View Forms. The plans is to build workflow and then migrate some of the
data.
How can I best solve attachments? I understand
System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Terje Moglestue
Sent: 28 September 2011 13:05
To: arslist@ARSLIST.ORG
Subject: Get attachments from View Forms or direct SQL?
**
I am looking into some possible migrations from different databases (SQL 2005)
to BMC 7.6.04
To: arslist@ARSLIST.ORG
Subject: Get attachments from View Forms or direct SQL?
**
I am looking into some possible migrations from different databases (SQL
2005) to BMC 7.6.04 (SQL 2005). I can access the external databases (not AR
SYSTEM) using View Forms. The plans is to build workflow
System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Terje Moglestue
Sent: 28 September 2011 13:05
To: arslist@ARSLIST.ORG
Subject: Get attachments from View Forms or direct SQL?
**
I am looking into some possible migrations from different databases (SQL
2005) to BMC
possible migrations from different databases (SQL
2005) to BMC 7.6.04 (SQL 2005). I can access the external databases (not
AR SYSTEM) using View Forms. The plans is to build workflow and then
migrate some of the data.
How can I best solve attachments? I understand that field type 'image
From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] On
Behalf Of Misi Mladoniczky [m...@rrr.se]
Sent: 28 September 2011 13:34
To: arslist@ARSLIST.ORG
Subject: Re: Get attachments from View Forms or direct SQL?
Hi,
Sorry, I seem to have missed the NOT-part and Access
@ARSLIST.ORG
Subject: Get attachments from View Forms or direct SQL?
**
I am looking into some possible migrations from different databases (SQL 2005)
to BMC 7.6.04 (SQL 2005). I can access the external databases (not AR SYSTEM)
using View Forms. The plans is to build workflow and then migrate some
To: arslist@ARSLIST.ORG
Subject: Re: Get attachments from View Forms or direct SQL?
Hi,
Sorry, I seem to have missed the NOT-part and Access-part completely...
It might be easier to set up a WebService-interface to your AR System,
where you can let an external system extract the attachments
(ARSList) [arslist@ARSLIST.ORG]
On Behalf Of Misi Mladoniczky [m...@rrr.se]
Sent: 28 September 2011 13:34
To: arslist@ARSLIST.ORG
Subject: Re: Get attachments from View Forms or direct SQL?
Hi,
Sorry, I seem to have missed the NOT-part and Access-part completely...
It might be easier to set up
I recently updated a view on the database with an extra field and I would like
to add this field to my View Form. When I right click on my form I get the
option to select a field from my view, but when I click on it nothing comes up.
Are View Forms sort of locked out if you update your view
System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa
Sent: Monday, March 14, 2011 1:21 PM
To: arslist@ARSLIST.ORG
Subject: View Forms
**
I recently updated a view on the database with an extra field and I would like
to add this field to my View Form. When I right
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W
Sent: Monday, March 14, 2011 2:40 PM
To: arslist@ARSLIST.ORG
Subject: Re: View Forms
You updated the view and then opened the form to add the field
type, I would check to see if there is an
open known issue with AR system 7.1 Patch 7 or thereabouts with view
forms...
Joe
-Original Message-
From: Kemes, Lisa
Sent: Monday, March 14, 2011 3:32 PM Newsgroups:
public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Subject: Re: View
to meet everyone!
Lisa
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Joe D'Souza
Sent: Wednesday, September 01, 2010 5:20 PM
To: arslist@ARSLIST.ORG
Subject: Re: View Forms
**
Some of the joins that Remedy creates
I have a rather complicated Join that I would like to do on 2 AR Forms. If I
create a View (joining 2 AR Forms on the database) and put a View Form on top
of it, would I still be able to change the data from the AR View Form?
Lisa Kemes
AR System Developer
Tyco Electronics
717-810-2408 tel
As long as it isn't a UNION, I think you can..
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Kemes, Lisa
Sent: Wednesday, September 01, 2010 2:28 PM
To: arslist@ARSLIST.ORG
Subject: View Forms
**
I have a rather complicated Join that I
Even if it is a union you can.. Been there done that..
Joe
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of LJ LongWing
Sent: Wednesday, September 01, 2010 4:49 PM
To: arslist@ARSLIST.ORG
Subject: Re: View Forms
D'Souza
Sent: Wednesday, September 01, 2010 3:00 PM
To: arslist@ARSLIST.ORG
Subject: Re: View Forms
**
Even if it is a union you can.. Been there done that..
Joe
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of LJ LongWing
, September 01, 2010 5:13 PM
To: arslist@ARSLIST.ORG
Subject: Re: View Forms
**
I know there is some sort of limit on modifying/deleting records if there
is a join/union involved..don't know the specifics.but best case
scenario.you can try and let us know the outcome J
From: Action Request
Hi all,
i am just trying to create a remedy view form and environment details are
below
DB : Oracle
ARS: 7.0.01
i wont to pull the data from the form which is present in the same database(
as arsystem tablenamespace) under user sys(System tablenamespace) using
remedy view forms using SQL query
: 7.0.01
i wont to pull the data from the form which is present in the same
database(
as arsystem tablenamespace) under user sys(System tablenamespace) using
remedy view forms using SQL query.
my query in Remedy view form is SELECT TABLE_NAME FROM SYS.ALL_TABLES
WHERE
OWNER='ARADMIN
database(
as arsystem tablenamespace) under user sys(System tablenamespace) using
remedy view forms using SQL query.
my query in Remedy view form is SELECT TABLE_NAME FROM SYS.ALL_TABLES
WHERE
OWNER='ARADMIN' AND TABLE_NAME='T1'
when i am trying to load the columns its throwing error like
tablenamespace) under user sys(System tablenamespace) using
remedy view forms using SQL query.
my query in Remedy view form is SELECT TABLE_NAME FROM SYS.ALL_TABLES
WHERE
OWNER='ARADMIN' AND TABLE_NAME='T1'
when i am trying to load the columns its throwing error like
Failure during
To: arslist@ARSLIST.ORG
Subject: Remedy View forms and SQL
Hi all,
i am just trying to create a remedy view form and environment details are
below
DB : Oracle
ARS: 7.0.01
i wont to pull the data from the form which is present in the same database(
as arsystem tablenamespace) under user sys(System
Hi all,
I need some information regarding the remedy view forms.
How to find the view forms created with Native SQL(Prev6) which are not
having T tables?
Regards,
SRG
--
View this message in context:
http://old.nabble.com/View-forms-and-Remedy-Schema-tables-tp28630092p28630092.html
Sent from
-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Gopal-srg
Sent: May 21, 2010 8:30 AM
To: arslist@ARSLIST.ORG
Subject: View forms and Remedy Schema tables
Hi all,
I need some information regarding the remedy view forms.
How to find the view forms
Hi ben,
Thanks for ur response.we are having a situation here like there are some
view forms(Created using Native SQL Prev6), somehow for some os these view
forms the T ables ,H Tables and B tables has been dropped off from the
databse(Oracle). We need to find such those view forms.
Are we need
I read view forms(Created using Native SQL Prev6) in your email. You
cannot make a view form in Oracle. You can make an Oracle View. Also
you can make that view in any instance and under any id or schema - not
necessarily the ARS one. I also do not understand what Prev6 is.
If the view
Hi Ben,
Sorry for misleading you by putting question in wrong way.
Here Prev6 means Remedy View form created in ARS (versions prior to
version ARS v6.x)
view forms(Created using Native SQL Prev6) - means remedy view forms
createdd with Native SQL query which will query to other DB tables to get
Gopal,
I may be off base on this one.but I don't believe that Remedy creates
views of 'view forms'due to the fact that Remedy is not maintaining the
data for the form (the view is)I don't believe you will find T/H/B
tables for itsame thing for Display only Formsand I think
You should find an Oracle view of Txxx for your Remedy View Form.
For Regular forms Remedy creates T/H/B tables. For View forms Remedy creates T
views in the database.
Dialog and Vendor forms are not represented tables/views in the database.
Fred
-Original Message-
From: Action
OkI stand corrected :)
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W
Sent: Friday, May 21, 2010 8:28 AM
To: arslist@ARSLIST.ORG
Subject: Re: View forms and Remedy Schema tables
You should find
-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of LJ LongWing
Sent: May 21, 2010 3:58 PM
To: arslist@ARSLIST.ORG
Subject: Re: View forms and Remedy Schema tables
Gopal,
I may be off base on this one.but I don't believe that Remedy creates
views
Date components using VIEW Forms
Hi Listers,
Please look into the following issue.
I created the following table in oracle (Manually).
CREATE TABLE MIGRATE_DATE ('EMP_LAN_ID' char(10), 'FIRST_NAME' char(10),
DATE_HIRED DATE);
Then i created view for the above table using the following SQL Syntax
to create date fields in the
VIEW form using Developer Studio.
Best Regards,
Krishna B
--
View this message in context:
http://old.nabble.com/Create-Date-components-using-VIEW-Forms-tp26261651p26261651.html
Sent from the ARS (Action Request System) mailing list archive at Nabble.com
Lisa,
View Forms using synonyms are working only if the owner of the underlying
object is the same as the owner of the synonym. IMHO this is a bug.
Kind Regards Conny
-Ursprüngliche Nachricht-
Von: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] Im Auftrag
] On Behalf Of Axton
Sent: Wednesday, May 27, 2009 11:48 PM
To: arslist@ARSLIST.ORG
Subject: Re: View Forms and Synoyms
So what do the sql statements below return when run from your sql client? Are
synonyms available in all_tab_columns? If they are not then you are probably
out of luck using
Got a ticket into BMC, we are having problems using Synonyms for our View
Forms. Getting Requested Database table not found. Please check the spelling
(table name is case-sensitive) ARERR 481.
We are on 7.01 patch 3. I thought this bug was fixed with SW00180955?
Oracle 10i
Windows 2003
, May 27, 2009 10:44:30 AM
Subject: View Forms and Synoyms
** Got a ticket into BMC, we are having problems using Synonyms for our View
Forms. Getting Requested Database table not found. Please check the spelling
(table name is case-sensitive) ARERR 481.
We are on 7.01 patch 3. I thought
Subject: Re: View Forms and Synoyms
**
I thought I'd ask you the very obvious question... Can you query the view form
as aradmin from the SQL client when logged in as aradmin using that same view
name???
Joe
From: Kemes, Lisa lisa.ke...@tycoelectronics.com
' and
owner = 'DCC'
*/OK
Lisa
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W
Sent: Wednesday, May 27, 2009 12:12 PM
To: arslist@ARSLIST.ORG
Subject: Re: View Forms and Synoyms
Try adding
That won't work because ARAdmin is the owner of the synonym.
--Original Message--
From: Lisa Kemes
To: Arslist
ReplyTo: Arslist
Subject: Re: View Forms and Synoyms
Sent: May 27, 2009 12:27 PM
Thanks Fred. I tried this, but I'm still getting the error. (Even though it's
not captured
Take an SQL log and see what SQL the AR System throws to the database server at
the time you get that error.
Joe
From: Kemes, Lisa lisa.ke...@tycoelectronics.com
To: arslist@ARSLIST.ORG
Sent: Wednesday, May 27, 2009 12:27:21 PM
Subject: Re: View Forms
'
and owner = 'DCC'
*/OK
Lisa
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W
Sent: Wednesday, May 27, 2009 12:12 PM
To: arslist@ARSLIST.ORG
Subject: Re: View Forms and Synoyms
Try adding
Solution = People + Process + Tools
Fast, Accurate, Cheap Pick two.
On Tue, Mar 31, 2009 at 9:18 PM, Guillaume Rheault guilla...@dcshq.com wrote:
**
Can somebody confirm that View forms (only view forms, not vendor forms) use
the plug-in server in 7.5 ? Is this a new feature ? I am having
didn't have this error in ARS 7.1, this is new with 7.5... because
of the plug-in server error this leads me to believe that view forms use the
plug-in server in 7.5. My understanding, since the view form object was
available, was that the view form would go straight to the ARS server which in
turn
-in server error this leads me to believe that view forms
use the plug-in server in 7.5. My understanding, since the view form object
was available, was that the view form would go straight to the ARS server
which in turn connects to the database to pull the records from the database
table
Subject: Re: View forms use the plug-in server in 7.5 ??
Guillaume,
I find it strange to think that the AR System server would have to go
through the plugin server to talk to it's DB. Maybe there would be a
good reason for that design, but I just do not see it.
Given that workflow is involved then I
\axis2-kernel-1.4.jar;
com.bmc.arsys.pluginsvr.ARPluginServerMain -x servername -i C:\Program
Files\BMC Software\ARSystem
HTH.
Regards,
Maxim
--
View this message in context:
http://www.nabble.com/View-forms-use-the-plug-in-server-in-7.5tp22818613p22831837.html
Sent from the ARS (Action
by BMC QA
testers...
-Guillaume
-Original Message-
From: Action Request System discussion list(ARSList) on behalf of BMax
Sent: Wed 04/01/09 1:40 PM
To: arslist@ARSLIST.ORG
Subject: Re: View forms use the plug-in server in 7.5 ??
Guillaume,
check your armonitor.cfg. It seems like patch1
Can somebody confirm that View forms (only view forms, not vendor forms) use
the plug-in server in 7.5 ? Is this a new feature ? I am having stability
issues in ARS 7.5 that I did not have with ARS 7.1...
I searched the ARS 7.5 Release Notes, ARS 7.5 Integration Guide and the ARS 7.5
Form
We are suddenly getting the error when we do a query on our view form:
ARERR [482] This View Form contains Request IDs that are null. Ensure that the
key field is set to a non-null, unique column to avoid data corruption
We checked the table and there are no fields that are null and the field
From: Kemes, Lisa lisa.ke...@tycoelectronics.com
To: arslist@ARSLIST.ORG
Sent: Wednesday, March 25, 2009 10:48:52 AM
Subject: View Forms
** We are suddenly getting the error when we do a query on our view form:
ARERR [482] This View Form contains Request IDs that are null
...@arslist.org] On Behalf Of Kemes, Lisa
Sent: Wednesday, March 25, 2009 8:49 AM
To: arslist@ARSLIST.ORG
Subject: View Forms
We are suddenly getting the error when we do a query on our view form:
ARERR [482] This View Form contains Request IDs that are null. Ensure
that the key field is set
...@arslist.org] On Behalf Of Joe DeSouza
Sent: Wednesday, March 25, 2009 10:56 AM
To: arslist@ARSLIST.ORG
Subject: Re: View Forms
**
Lisa,
Delselect the primary key again from the view form definition, and choose an
alternate one.. save the form, then remove that alternate one, and readd the
original
Subject: Re: View Forms
**
Hi Lisa,
Have you checked the underlying DB Tables for any changes? This happened to me
in the past and the reason was that someone changed the length of the fields on
the DB tables.
Alex.
From: Action Request System discussion list
You are welcome.. glad I was of some help..
Cheers
Joe
From: Kemes, Lisa lisa.ke...@tycoelectronics.com
To: arslist@ARSLIST.ORG
Sent: Wednesday, March 25, 2009 11:11:15 AM
Subject: Re: View Forms
**
Thanks so much Joe. We just exported the form
: View Forms
**
Hi Lisa,
Have you checked the underlying DB Tables for any changes? This happened to me
in the past and the reason was that someone changed the length of the fields on
the DB tables.
Alex.
From:Action Request System discussion list(ARSList
. However it does
seem that there was an effect. I now need to check the other View forms that
connect to other external prod instances to see if they were effected.
Dave
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf
if this ends up being a duplicate. (FWIW it seems to work when I
send email to the listserv, but not when I try to post from the list's web
interface)
I ran an arsql.log and searched against one of the view forms. I found
that ARGetEntry is searching thusly:
... WHERE C1 = N'1025'
instead
21, 2008 9:24 AM
To: arslist@ARSLIST.ORG
Subject: Re: Update/Resend Re: Problem with view forms
For anyone still playing at home, the reinstall of AR Server did not help (on
the positive side, it did not make anything worse).
On Thu, Nov 20, 2008 at 10:45 AM, Bill Bookers [EMAIL PROTECTED] wrote
We had considered that, but stopped short of trying it. In SQL, for the
external table, under column properties it says data type = int, length =
4; in the Admin tool, it shows this field with a field length of 15. This is
how it's supposed to be, and it works this way on other servers, so we've
Just noticed a difference in the problematic database vs. another server
that works:
1. In SQL, right click on the database server (at the top of the tree)
2. Go to General
3. Look at Server Collation.
1. In Production (and on Development) this says
For now, we did end up going with something similar to what Fred
Grooms proposed. One of the DBAs suggested changing the int data type to
bigint. Since there isn't an actual T table in ARSystem for a view
form, we created one, and then changed int to bigint. So far,
everything's working like it
] On Behalf Of Bill Bookers
Sent: Friday, November 21, 2008 5:21 PM
To: arslist@ARSLIST.ORG
Subject: WORKAROUND: Problem with view forms
**
For now, we did end up going with something similar to what Fred Grooms
proposed. One of the DBAs suggested changing the int data type to
bigint. Since
I had replied to both Fred and Joe, but I never saw my messages go through.
My aplogies if this ends up being a duplicate. (FWIW it seems to work when I
send email to the listserv, but not when I try to post from the list's web
interface)
I ran an arsql.log and searched against one of the view
Greetings,
I'm having a problem with view forms, more specifically I believe it's a
problem with the mechanism wheby the view forms talk to their
respective external tables.
First, the setup:
ARS 6.3 patch 22
Remedy Help Desk 6.0
MS-SQL server 2005 (9.0.2047)
Windows 2003 server
A couple
P.S. A clarification: The first escalation writes once to this table, a new
row. It doesn't perform a lookup against this table.
On Wed, Nov 19, 2008 at 10:54 AM, Bill Bookers [EMAIL PROTECTED]wrote:
... (a write to the view form is OK, which would explain why the first of
the 2 escalations
@ARSLIST.ORG
Subject: Problem with view forms
**
Greetings,
I'm having a problem with view forms, more specifically I believe it's a
problem with the mechanism wheby the view forms talk to their
respective external tables.
First, the setup:
ARS 6.3 patch 22
Remedy Help Desk 6.0
MS-SQL server 2005
]
To: arslist@ARSLIST.ORG
Sent: Wednesday, November 19, 2008 10:54:31 AM
Subject: Problem with view forms
**
Greetings,
I'm having a problem with view forms, more specifically I believe it's a
problem with the mechanism wheby the view forms talk to their
respective external tables.
First, the setup
I'm trying to create a View Form that connects to a table on an Oracle
database and I'm getting the error message:
Requested database table not found. Please check the spelling (table
name is case-sensitive) (ARERR 481).
The table has aradmin added to the permission list. Is there anything
Also, I am typing the table name in CAPS.
Lisa
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa
Sent: Thursday, March 27, 2008 12:05 PM
To: arslist@ARSLIST.ORG
Subject: View Forms
**
I'm trying
] *On Behalf Of *Kemes, Lisa
*Sent:* Thursday, March 27, 2008 12:05 PM
*To:* arslist@ARSLIST.ORG
*Subject:* View Forms
**
I'm trying to create a View Form that connects to a table on an Oracle
database and I'm getting the error message:
Requested database table not found. Please check
] On Behalf Of Kemes, Lisa
Sent: Thursday, March 27, 2008 12:05 PM
To: arslist@ARSLIST.ORG
Subject: View Forms
**
I'm trying to create a View Form that connects to a table on an Oracle
database and I'm getting the error message:
Requested database table not found. Please check the spelling (table
--
*From:* Action Request System discussion list(ARSList) [mailto:
[EMAIL PROTECTED] *On Behalf Of *Kemes, Lisa
*Sent:* Thursday, March 27, 2008 12:05 PM
*To:* arslist@ARSLIST.ORG
*Subject:* View Forms
**
I'm trying to create a View Form that connects to a table on an Oracle
am typing the table name in CAPS.
Lisa
--
*From:* Action Request System discussion list(ARSList) [mailto:
[EMAIL PROTECTED] *On Behalf Of *Kemes, Lisa
*Sent:* Thursday, March 27, 2008 12:05 PM
*To:* arslist@ARSLIST.ORG
*Subject:* View Forms
Forms
**
These are not ARS tables. Just plain old tables from an Oracle
database. Our DBA was able to log into SQL developer with the aradmin
account and see these tables just fine. For some reason, my admin tool
must not be using the aradmin account for view forms? I'm connected to
our ARS
@ARSLIST.ORG
Subject: Re: View Forms
**
If they are not owned by aradmin, are you including the owner name?
Fred
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa
Sent: Thursday, March 27, 2008 2:29 PM
, March 27, 2008 3:32 PM
To: arslist@ARSLIST.ORG
Subject: Re: View Forms
**
If they are not owned by aradmin, are you including the owner name?
Fred
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa
Sent
Of *Kemes, Lisa
*Sent:* Thursday, March 27, 2008 2:29 PM
*To:* arslist@ARSLIST.ORG
*Subject:* Re: View Forms
** These are not ARS tables. Just plain old tables from an Oracle
database. Our DBA was able to log into SQL developer with the aradmin
account and see these tables just fine. For some
:51 PM
To: arslist@ARSLIST.ORG
Subject: Re: View Forms
** If you can log into the database as ARADMIN and see the tables then
you should be able to create the Remedy view. It would seem to me that
you might just want to create a simple form that runs the query select
table_name from user_tables
Of Kemes, Lisa
Sent: Thursday, March 27, 2008 3:59 PM
To: arslist@ARSLIST.ORG
Subject: Re: View Forms
**
Thanks, I'm going to try thisEverything points to the fact that this
should work.
I'll let you know!
Lisa
From: Action Request System
1 - 100 of 146 matches
Mail list logo