Re: Getting Midtier to work on mobile devices: how far can it go?
Hey Rabi, I assumed your smartphone (since you claimed you are using that) is loaded with Windows mobile OS which is a MS product and uses Internet Explorer as its browser.. I was and still am under the impression that it was Microsoft that first coined the term smartphones for devices that were PDA's with a phone function included.. Hence my assumption that you had IE on your phone.. It has nothing to do on the day of the week I swear - such things have an effect on only mortal humans haha!! On a serious note, if you do not have IE, you must be using either a mac phone (iPhone) or a blackberry?? Or maybe even the latest Nuvi Garmin phone or one of the Nokia PDA/phones? In that case yes it MAY not be IE - About 5 years ago I did have had a fancy Nokia phone that was not a Windows mobile phone and did have IE in its OS.. If it is not IE that you are using then there is your small problem in the first place. The Mid-Tier application was generally tested for IE browsers on PC's and to the best of my knowledge IE browsers on wireless devices as well. I am not sure if it is even tested for blackberries.. I used the mid tier application on a my older phone that had a Windows 6 OS and did not have the same problem you said you are experiencing which is why I suggested downgrading it to a lower version (just in case the newer one is not compatible).. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Rabi Tripathi Sent: Sunday, December 13, 2009 11:58 PM To: arslist@ARSLIST.ORG Subject: Re: Getting Midtier to work on mobile devices: how far can it go? Joe: You said (a lot)-- Try lower version of IE. Try newer phone firmware. Consider it a bug on the phone browser. Open a ticket with phone company to find out why midtier won't work on their browser. It's not IE...but it's a Sunday reply, so I have to thank you. :) --- On Sun, 12/13/09, Joe D'Souza wrote: > From: Joe D'Souza > Subject: Re: Getting Midtier to work on mobile devices: how far can it go? > To: arslist@ARSLIST.ORG > Date: Sunday, December 13, 2009, 5:48 PM > Rabi, > > This could well be a problem with the version of IE used in > your smart > phone.. try backdating (if a lower version is available) or > updating the HTC > phones firmware if an update is available, so you can check > if a previous > version or a later released version works better? > > Also it looks like a bug with the browser on the smart > phone since all these > things work on browsers on a PC including non IE browsers > such as safari and > FireFox with a few limitations that are not really that > significant.. > > So I may raise a ticket with the vendors of your phone too > and have them try > out what you are experiencing and compare the difference > from a PC and a > smart phone in case you have your applications deployed on > the web so they > could access your pages and experience your problems first > hand.. > > Joe > > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:arsl...@arslist.org]on > Behalf Of Rabi Tripathi > Sent: Sunday, December 13, 2009 5:15 PM > To: arslist@ARSLIST.ORG > Subject: Re: Getting Midtier to work on mobile devices: how > far can it > go? > > > One more thing with Eris Droid: > double clicking on a table row is not registered, because > that is > intercepted by Droid to do a zoom out. This can perhaps be > changed in Droid > configuration. > > --- On Sun, 12/13/09, Rabi Tripathi > wrote: > > > From: Rabi Tripathi > > Subject: Getting Midtier to work on mobile devices: > how far can it go? > > To: arslist@arslist.org > > Date: Sunday, December 13, 2009, 5:08 PM > > Hi all, I just started testing > > Midtier performance on Smart Phone browsers. It > appears that > > forms and workflow tend to work on phone browsers, but > have > > limitations. Has anybody played around with this? > Your > > experience? > > > > I am trying a custom "console" form on HTC Eris Droid > that > > I just got from Verizon. This and many other more > complex > > pages render fine, but when working on the forms, > there are > > some issues. The most annoying for me at this point > are: > > -Menu selection doesn't work. Menus list items ok, but > I > > can't click on any of the item. The click either > doesn't > > register, or if the click happened over a field in > the > > background, the background field gets the click. > > > > -Native buttons such save, don't seem to work. > > > > Since what browsers get back from midtier is DHTML > > (HTML+javascript+...), and many (most?) mobile > browsers > > support basic HTML and javascript. I was hoping to get > a > > much better result. "basic" is perhaps the key here. > > > > Any comments? Don't tell me my expectations are out > of > > line. At least in a user community with a limited > number of > > devices/browsers, I would like to see midtier be > usable. I > > can live with some limitations.
Re: Getting Midtier to work on mobile devices: how far can it go?
Joe: You said (a lot)-- Try lower version of IE. Try newer phone firmware. Consider it a bug on the phone browser. Open a ticket with phone company to find out why midtier won't work on their browser. It's not IE...but it's a Sunday reply, so I have to thank you. :) --- On Sun, 12/13/09, Joe D'Souza wrote: > From: Joe D'Souza > Subject: Re: Getting Midtier to work on mobile devices: how far can it go? > To: arslist@ARSLIST.ORG > Date: Sunday, December 13, 2009, 5:48 PM > Rabi, > > This could well be a problem with the version of IE used in > your smart > phone.. try backdating (if a lower version is available) or > updating the HTC > phones firmware if an update is available, so you can check > if a previous > version or a later released version works better? > > Also it looks like a bug with the browser on the smart > phone since all these > things work on browsers on a PC including non IE browsers > such as safari and > FireFox with a few limitations that are not really that > significant.. > > So I may raise a ticket with the vendors of your phone too > and have them try > out what you are experiencing and compare the difference > from a PC and a > smart phone in case you have your applications deployed on > the web so they > could access your pages and experience your problems first > hand.. > > Joe > > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:arsl...@arslist.org]on > Behalf Of Rabi Tripathi > Sent: Sunday, December 13, 2009 5:15 PM > To: arslist@ARSLIST.ORG > Subject: Re: Getting Midtier to work on mobile devices: how > far can it > go? > > > One more thing with Eris Droid: > double clicking on a table row is not registered, because > that is > intercepted by Droid to do a zoom out. This can perhaps be > changed in Droid > configuration. > > --- On Sun, 12/13/09, Rabi Tripathi > wrote: > > > From: Rabi Tripathi > > Subject: Getting Midtier to work on mobile devices: > how far can it go? > > To: arslist@arslist.org > > Date: Sunday, December 13, 2009, 5:08 PM > > Hi all, I just started testing > > Midtier performance on Smart Phone browsers. It > appears that > > forms and workflow tend to work on phone browsers, but > have > > limitations. Has anybody played around with this? > Your > > experience? > > > > I am trying a custom "console" form on HTC Eris Droid > that > > I just got from Verizon. This and many other more > complex > > pages render fine, but when working on the forms, > there are > > some issues. The most annoying for me at this point > are: > > -Menu selection doesn't work. Menus list items ok, but > I > > can't click on any of the item. The click either > doesn't > > register, or if the click happened over a field in > the > > background, the background field gets the click. > > > > -Native buttons such save, don't seem to work. > > > > Since what browsers get back from midtier is DHTML > > (HTML+javascript+...), and many (most?) mobile > browsers > > support basic HTML and javascript. I was hoping to get > a > > much better result. "basic" is perhaps the key here. > > > > Any comments? Don't tell me my expectations are out > of > > line. At least in a user community with a limited > number of > > devices/browsers, I would like to see midtier be > usable. I > > can live with some limitations. > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor:rmisoluti...@verizon.net > ARSlist: "Where the Answers Are" > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Advanced Search Bar Field...
Yea I noticed the OTB apps since version 4 or something had fields like that and I always wondered how they did that until I stumbled on what I found you could do and I thought maybe they did it that way :-) Never knew about the driver possibility of doing the same thing.. 7.5 onwards you can do it right from the Developer Studio in a single step just by removing it from the view when created.. which I think they should have long implemented.. Its a useful feature at times. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Carey Matthew Black Sent: Sunday, December 13, 2009 8:02 PM To: arslist@ARSLIST.ORG Subject: Re: Advanced Search Bar Field... FWIW: You should also be able to do this with the command line tool called "driver" too. However you would not need to do as many steps. Basically you would modify the one field and not supply any view information for it. And this is a "as designed" feature of AR System. (AKA: A field that exists, and is not displayed on any views.) I am not sure you can find the idea talked about in the docs. However, the OOB applications have used this approach for some time, and it looked to me to be intentional too. :) -- Carey Matthew Black BMC Remedy AR System Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On Sat, Dec 12, 2009 at 9:27 AM, Joe D'Souza wrote: > ** > Lisa, > > I think you misunderstood.. > > Do not delete the field.. > > Remove it from the view using the file menu option Add/Remove fields from > view.. > > Let me recount the steps with more details > > 1) Create that temp view > 2) Save the form. > 3) Remove 1005 using the Add/Remove fields from view options from all views > except the temp view. > 4) Save the form. > 5) Delete the temp view containing the 1005 field. > 6) Save the form. > > I have used this method to remove fields from all views right from version 4 > or something when I discovered you can do that. And it works.. If you still > have a problem let me know and I'll give you my number you can call me at > and I'll try to guide you the best I can through it.. > > Cheers > > Joe ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Advanced Search Bar Field...
FWIW: You should also be able to do this with the command line tool called "driver" too. However you would not need to do as many steps. Basically you would modify the one field and not supply any view information for it. And this is a "as designed" feature of AR System. (AKA: A field that exists, and is not displayed on any views.) I am not sure you can find the idea talked about in the docs. However, the OOB applications have used this approach for some time, and it looked to me to be intentional too. :) -- Carey Matthew Black BMC Remedy AR System Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On Sat, Dec 12, 2009 at 9:27 AM, Joe D'Souza wrote: > ** > Lisa, > > I think you misunderstood.. > > Do not delete the field.. > > Remove it from the view using the file menu option Add/Remove fields from > view.. > > Let me recount the steps with more details > > 1) Create that temp view > 2) Save the form. > 3) Remove 1005 using the Add/Remove fields from view options from all views > except the temp view. > 4) Save the form. > 5) Delete the temp view containing the 1005 field. > 6) Save the form. > > I have used this method to remove fields from all views right from version 4 > or something when I discovered you can do that. And it works.. If you still > have a problem let me know and I'll give you my number you can call me at > and I'll try to guide you the best I can through it.. > > Cheers > > Joe ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Getting Midtier to work on mobile devices: how far can it go?
Rabi, This could well be a problem with the version of IE used in your smart phone.. try backdating (if a lower version is available) or updating the HTC phones firmware if an update is available, so you can check if a previous version or a later released version works better? Also it looks like a bug with the browser on the smart phone since all these things work on browsers on a PC including non IE browsers such as safari and FireFox with a few limitations that are not really that significant.. So I may raise a ticket with the vendors of your phone too and have them try out what you are experiencing and compare the difference from a PC and a smart phone in case you have your applications deployed on the web so they could access your pages and experience your problems first hand.. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Rabi Tripathi Sent: Sunday, December 13, 2009 5:15 PM To: arslist@ARSLIST.ORG Subject: Re: Getting Midtier to work on mobile devices: how far can it go? One more thing with Eris Droid: double clicking on a table row is not registered, because that is intercepted by Droid to do a zoom out. This can perhaps be changed in Droid configuration. --- On Sun, 12/13/09, Rabi Tripathi wrote: > From: Rabi Tripathi > Subject: Getting Midtier to work on mobile devices: how far can it go? > To: arslist@arslist.org > Date: Sunday, December 13, 2009, 5:08 PM > Hi all, I just started testing > Midtier performance on Smart Phone browsers. It appears that > forms and workflow tend to work on phone browsers, but have > limitations. Has anybody played around with this? Your > experience? > > I am trying a custom "console" form on HTC Eris Droid that > I just got from Verizon. This and many other more complex > pages render fine, but when working on the forms, there are > some issues. The most annoying for me at this point are: > -Menu selection doesn't work. Menus list items ok, but I > can't click on any of the item. The click either doesn't > register, or if the click happened over a field in the > background, the background field gets the click. > > -Native buttons such save, don't seem to work. > > Since what browsers get back from midtier is DHTML > (HTML+javascript+...), and many (most?) mobile browsers > support basic HTML and javascript. I was hoping to get a > much better result. "basic" is perhaps the key here. > > Any comments? Don't tell me my expectations are out of > line. At least in a user community with a limited number of > devices/browsers, I would like to see midtier be usable. I > can live with some limitations. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Getting Midtier to work on mobile devices: how far can it go?
One more thing with Eris Droid: double clicking on a table row is not registered, because that is intercepted by Droid to do a zoom out. This can perhaps be changed in Droid configuration. --- On Sun, 12/13/09, Rabi Tripathi wrote: > From: Rabi Tripathi > Subject: Getting Midtier to work on mobile devices: how far can it go? > To: arslist@arslist.org > Date: Sunday, December 13, 2009, 5:08 PM > Hi all, I just started testing > Midtier performance on Smart Phone browsers. It appears that > forms and workflow tend to work on phone browsers, but have > limitations. Has anybody played around with this? Your > experience? > > I am trying a custom "console" form on HTC Eris Droid that > I just got from Verizon. This and many other more complex > pages render fine, but when working on the forms, there are > some issues. The most annoying for me at this point are: > -Menu selection doesn't work. Menus list items ok, but I > can't click on any of the item. The click either doesn't > register, or if the click happened over a field in the > background, the background field gets the click. > > -Native buttons such save, don't seem to work. > > Since what browsers get back from midtier is DHTML > (HTML+javascript+...), and many (most?) mobile browsers > support basic HTML and javascript. I was hoping to get a > much better result. "basic" is perhaps the key here. > > Any comments? Don't tell me my expectations are out of > line. At least in a user community with a limited number of > devices/browsers, I would like to see midtier be usable. I > can live with some limitations. > > > > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Getting Midtier to work on mobile devices: how far can it go?
Hi all, I just started testing Midtier performance on Smart Phone browsers. It appears that forms and workflow tend to work on phone browsers, but have limitations. Has anybody played around with this? Your experience? I am trying a custom "console" form on HTC Eris Droid that I just got from Verizon. This and many other more complex pages render fine, but when working on the forms, there are some issues. The most annoying for me at this point are: -Menu selection doesn't work. Menus list items ok, but I can't click on any of the item. The click either doesn't register, or if the click happened over a field in the background, the background field gets the click. -Native buttons such save, don't seem to work. Since what browsers get back from midtier is DHTML (HTML+javascript+...), and many (most?) mobile browsers support basic HTML and javascript. I was hoping to get a much better result. "basic" is perhaps the key here. Any comments? Don't tell me my expectations are out of line. At least in a user community with a limited number of devices/browsers, I would like to see midtier be usable. I can live with some limitations. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Excel data query
I think use of underscores is necessary to check failing with some of the column names do not get translated correctly causing errors in the ODBC connection.. Try that if its not already been tried.. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Trond Valen Sent: Sunday, December 13, 2009 6:23 AM To: arslist@ARSLIST.ORG Subject: Re: Excel data query Yep, Same problem here... Are there any special options I need to check on the data source when import data from ARS to Excel using ODBC? brgds Trond Valen - Steria AS Mobile: +47 913 36 275 t...@steria.no -Opprinnelig melding- Fra: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] På vegne av Carey Matthew Black Lagt inn: 14. juli 2009 20:01 Lagt inn i: Remedy Diskusjon: Excel data query Emne: Re: Excel data query Fred, I have no idea if a new patch has been pushed on to my pc since I last tried this "function". However, as of this moment, I see this for my copy of Excel. ( I assume it is as current as it can be.) Microsoft Office Excel 2007 (12.0.6504.5001) SP2 MS0 (12.0.6425.1000) ( I finally found this after poking about 4 buttons to find the good old "About Excel" that use to be under the Help menu. I hate it when programs change key mappings or menus g. Sigh.) HTH. Do you know of any specific patch that helps/hurts/affects these features of Excel 2007? -- Carey Matthew Black BMC Remedy AR System Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On Tue, Jul 14, 2009 at 1:19 PM, Grooms, Frederick W wrote: > Do you know which Office 2007 ServicePack level they are on? > > -Original Message- > From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Carey Matthew Black > Sent: Tuesday, July 14, 2009 12:01 PM > To: arslist@ARSLIST.ORG > Subject: Re: Excel data query > > Steve, > > I can second the experience. > > But I can add that we are using Excel 2007 with ARS v6.3 and v7.1 and > the problem appears to exist against both ARS servers/ODBC drivers. I > like Kelly concluded that the commonality was Excel 2007 more than > ARS. It sure does not help me functionally, and it is a lot harder to > get my users to "blame Microsoft" (than BMC). So ultimately we hear > "Remedy doesn't work". We can all blame each other but at the end of > the day if the users can not get the job done, then ... other > processes/tools will be found. > > I have not had any time to try to fix it yet. Just to many bugs in all > the software that I use these days. :( > > -- > Carey Matthew Black > BMC Remedy AR System Skilled Professional (RSP) > ARS = Action Request System(Remedy) > > Love, then teach > Solution = People + Process + Tools > Fast, Accurate, Cheap Pick two. > > > On Wed, Jul 8, 2009 at 6:29 PM, Steve > McDonald wrote: >> ** >> Has anyone had problems extracting data via Excel after upgrading to Excel >> 2007? >> >> I have a user that the following error: >> >> Unable to obtain a list of tables from the data source. He said >> spreadsheets created with Excel 2003 work ok but nothing new. >> >> We're on 7.1 patch 6 on Unix 10/Informix 10. >> >> >> Thanks ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: View form from Oracle based AR system to remote MS SQL server
Victor,
Try that suggestion from Conny before the stored procedure I suggested.
Maybe that is what is required to insert that missing commit.
If Conny's suggestion still doesn't work, then write a stored procedure that
performs that update, with a commit at the end like I suggested a couple of
emails ago.. I'll copy the design of the body of that stored procedure just
for your benefit again because previously I suggested update but it looks
like its an insert you need to create a stored procedure for..
BEGIN
insert into tablen...@. ( ) values
();
commit;
END;
Maybe before you try all this (either mine or Conny's suggestion) SQL
logging may indicate where a commit is missing.. That is worth a try too..
Oracle SQL logging would also help you find where a commit is missing..
Joe
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of Conny Martin
Sent: Sunday, December 13, 2009 7:57 AM
To: arslist@ARSLIST.ORG
Subject: AW: View form from Oracle based AR system to remote MS SQL server
**
Victor,
running only the insert statement from sqlplus is not the whole story.
If you create an entry through ARS there are a bunch of statements which
gets executed. Immediately before the insert are 2 statements to generate
the request_id. You should see something like this in your sql-logfile.
update arschema set nextid = nextid + 1 where schemaid = ;
select nextid from arschema where schemaid = ;
insert into T (cxxx,cyyy,czzz) values ('x','y','z');
Try to run these 3 in sqlplus. IMHO error ORA-02047 indicates some
problem with handling distributed transactions. If this sequence of
statements generates an error in sqlplus try a commit; after the first 2
statements. If this solves the problem you can set "Next-ID-Commit: T" in
ar.conf. This causes ARS to issue a commit after generating the nextid.
HTH
Kind Regards Conny
--
Von: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] Im Auftrag von Victor Olufowobi
Gesendet: Sonntag, 13. Dezember 2009 09:41
An: arslist@ARSLIST.ORG
Betreff: Re: View form from Oracle based AR system to remote MS SQL server
**
Thanks again Joe,
I will try what you suggested and have the outcome posted - but I want you
to consider the following:
- I can update without problem using the view form created. It's when I'm
inserting (CREATE operation) the error occurs
- I can successfull run the INSERT command ARS is trying to run from
sqlplus
Victor
On Sat 12/12/09 14:56 , Joe D'Souza jdso...@shyle.net sent:
Victor,
Well that's half the battle won then.. Yes MS-SQL can be weird when it
comes
to case sensitivity of view names and columns within views even.. For
e.g.
if your ARS was hosted on a MS-SQL server, and the view name was in
small
case and you tried creating a view form in upper case, it would not
recognize that name. There is a way to override that case sensitivity
but we
won't deal with that since you already updated the view to have it upper
cased..
This is what I found for ORA-02047.
http://ora-02047.ora-code.com/
Based on the clue provided with the explanation of the error code, can
you
the Run Process Application-Release-Pending just an action before
updating
the MS-SQL view data in your workflow - and if that does not work the
same
action after the update action to that DB-Link? I'm assuming that will
force
any pending commits before (or if necessary after) you try updating the
external view using that DB-Link in light of what the article in the
above
link says..
If that does not work (and the commit is required while and not before
or
after the update), try writing a stored procedure that has a commit
inside
of it - e.g..
BEGIN
update tablen...@. set ... where ...;
commit;
END;
Use that stored procedure in a direct SQL at the point where you want to
run
that update to the foreign database. Make sure that you declare all the
variables that you need while defining the stored procedure.
Let me know how it goes..
Cheers
Joe
-Original Message-
From: Action Request System discussion list(ARSList)
[arsl...@arslist.org]on Behalf Of Victor
Sent: Saturday, December 12, 2009 3:48 AM
To: arslist@ARSLIST.ORG
Subject: Re: View form from Oracle based AR system to remote MS SQL
server
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
colum
AW: View form from Oracle based AR system to remote MS SQL server
Victor,
running only the insert statement from sqlplus is not the whole story.
If you create an entry through ARS there are a bunch of statements which
gets executed. Immediately before the insert are 2 statements to
generate the request_id. You should see something like this in your
sql-logfile.
update arschema set nextid = nextid + 1 where schemaid = ;
select nextid from arschema where schemaid = ;
insert into T (cxxx,cyyy,czzz) values ('x','y','z');
Try to run these 3 in sqlplus. IMHO error ORA-02047 indicates some
problem with handling distributed transactions. If this sequence of
statements generates an error in sqlplus try a commit; after the first 2
statements. If this solves the problem you can set "Next-ID-Commit: T"
in ar.conf. This causes ARS to issue a commit after generating the
nextid.
HTH
Kind Regards Conny
Von: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] Im Auftrag von Victor Olufowobi
Gesendet: Sonntag, 13. Dezember 2009 09:41
An: arslist@ARSLIST.ORG
Betreff: Re: View form from Oracle based AR system to remote MS SQL
server
**
Thanks again Joe,
I will try what you suggested and have the outcome posted - but I want
you to consider the following:
- I can update without problem using the view form created. It's when
I'm inserting (CREATE operation) the error occurs
- I can successfull run the INSERT command ARS is trying to run from
sqlplus
Victor
On Sat 12/12/09 14:56 , Joe D'Souza jdso...@shyle.net sent:
Victor,
Well that's half the battle won then.. Yes MS-SQL can be weird
when it comes
to case sensitivity of view names and columns within views
even.. For e.g.
if your ARS was hosted on a MS-SQL server, and the view name was
in small
case and you tried creating a view form in upper case, it would
not
recognize that name. There is a way to override that case
sensitivity but we
won't deal with that since you already updated the view to have
it upper
cased..
This is what I found for ORA-02047.
http://ora-02047.ora-code.com/
Re: Excell data query
Yep, Same problem here... Are there any special options I need to check on the data source when import data from ARS to Excel using ODBC? brgds Trond Valen - Steria AS Mobile: +47 913 36 275 t...@steria.no -Opprinnelig melding- Fra: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] På vegne av Carey Matthew Black Lagt inn: 14. juli 2009 20:01 Lagt inn i: Remedy Diskusjon: Excell data query Emne: Re: Excell data query Fred, I have no idea if a new patch has been pushed on to my pc since I last tried this "function". However, as of this moment, I see this for my copy of Excel. ( I assume it is as current as it can be.) Microsoft Office Excel 2007 (12.0.6504.5001) SP2 MS0 (12.0.6425.1000) ( I finally found this after poking about 4 buttons to find the good old "About Excel" that use to be under the Help menu. I hate it when programs change key mappings or menus g. Sigh.) HTH. Do you know of any specific patch that helps/hurts/affects these features of Excel 2007? -- Carey Matthew Black BMC Remedy AR System Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On Tue, Jul 14, 2009 at 1:19 PM, Grooms, Frederick W wrote: > Do you know which Office 2007 ServicePack level they are on? > > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:arsl...@arslist.org] On Behalf Of Carey Matthew Black > Sent: Tuesday, July 14, 2009 12:01 PM > To: arslist@ARSLIST.ORG > Subject: Re: Excell data query > > Steve, > > I can second the experience. > > But I can add that we are using Excel 2007 with ARS v6.3 and v7.1 and > the problem appears to exist against both ARS servers/ODBC drivers. I > like Kelly concluded that the commonality was Excel 2007 more than > ARS. It sure does not help me functionally, and it is a lot harder to > get my users to "blame Microsoft" (than BMC). So ultimately we hear > "Remedy doesn't work". We can all blame each other but at the end of > the day if the users can not get the job done, then ... other > processes/tools will be found. > > I have not had any time to try to fix it yet. Just to many bugs in all > the software that I use these days. :( > > -- > Carey Matthew Black > BMC Remedy AR System Skilled Professional (RSP) > ARS = Action Request System(Remedy) > > Love, then teach > Solution = People + Process + Tools > Fast, Accurate, Cheap Pick two. > > > On Wed, Jul 8, 2009 at 6:29 PM, Steve > McDonald wrote: >> ** >> Has anyone had problems extracting data via Excel after upgrading to Excel >> 2007? >> >> I have a user that the following error: >> >> Unable to obtain a list of tables from the data source. He said >> spreadsheets created with Excel 2003 work ok but nothing new. >> >> We're on 7.1 patch 6 on Unix 10/Informix 10. >> >> >> Thanks ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" This email originates from Steria AS, Biskop Gunnerus' gate 14a, N-0051 OSLO, http://www.steria.no. This email and any attachments may contain confidential/intellectual property/copyright information and is only for the use of the addressee(s). You are prohibited from copying, forwarding, disclosing, saving or otherwise using it in any way if you are not the addressee(s) or responsible for delivery. If you receive this email by mistake, please advise the sender and cancel it immediately. Steria may monitor the content of emails within its network to ensure compliance with its policies and procedures. Any email is susceptible to alteration and its integrity cannot be assured. Steria shall not be liable if the message is altered, modified, falsified, or even edited. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: View form from Oracle based AR system to remote MS SQL server
Thanks again Joe,
I will try what you suggested and have the outcome posted - but I
want you to consider the following:
- I can update without problem using the view form created. It's
when I'm inserting (CREATE operation) the error occurs
- I can successfull run the INSERT command ARS is trying to run from
sqlplus BODY { font-family:Arial, Helvetica,
sans-serif;font-size:12px; }
Victor
On Sat 12/12/09 14:56 , Joe D'Souza jdso...@shyle.net sent:
Victor,
Well that's half the battle won then.. Yes MS-SQL can be weird when
it comes
to case sensitivity of view names and columns within views even..
For e.g.
if your ARS was hosted on a MS-SQL server, and the view name was in
small
case and you tried creating a view form in upper case, it would not
recognize that name. There is a way to override that case
sensitivity but we
won't deal with that since you already updated the view to have it
upper
cased..
This is what I found for ORA-02047.
http://ora-02047.ora-code.com/ [1]
Based on the clue provided with the explanation of the error code,
can you
the Run Process Application-Release-Pending just an action before
updating
the MS-SQL view data in your workflow - and if that does not work
the same
action after the update action to that DB-Link? I'm assuming that
will force
any pending commits before (or if necessary after) you try updating
the
external view using that DB-Link in light of what the article in the
above
link says..
If that does not work (and the commit is required while and not
before or
after the update), try writing a stored procedure that has a commit
inside
of it - e.g..
BEGIN
update tablen...@. set ... where ...;
commit;
END;
Use that stored procedure in a direct SQL at the point where you
want to run
that update to the foreign database. Make sure that you declare all
the
variables that you need while defining the stored procedure.
Let me know how it goes..
Cheers
Joe
-Original Message-
From: Action Request System discussion list(ARSList)
[arsl...@arslist.org [2]]On Behalf Of Victor
Sent: Saturday, December 12, 2009 3:48 AM
To: arslist@ARSLIST.ORG [3]
Subject: Re: View form from Oracle based AR system to remote MS SQL
server
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)
> [arsl...@arslist.org [4]]On Behalf Of Victor
> Sent: Thursday, December 10, 2009 3:00 PM
> To: arslist@ARSLIST.ORG [5]
> 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 [6]
> Platinum Sponsor:rmisoluti...@verizon.net [7] 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
