Remedy create wrong SELECT !!!
Hi, all
I found interesting thing. For example, we have form (Form1) that
contain character field $Name$ and table. Table look at another form
(Form2) that contain only character field $Name$. Table qualification is
( 'Name' = $Name$) OR ( $Name$ = ).
Open Remedy User and turn on database log. Open Form1. Leave $Name$
field empty and refresh table. See log:
SELECT T710.C1,C536870913,T710.C1 FROM T710 WHERE ((T710.C536870913 = '
') OR (' ' = '')) ORDER BY 1 ASC
((T710.C536870913 = ' ') OR (' ' = '')) is ( 'Name' = $Name$) OR (
$Name$ = ). Empty field $Name$ is ' ' (space) in SELECT expression.
Why Remedy replace NULL character fields with space in SELECT.
MS SQL Server convert (' ' = '') to ('' = '') automatically but Oracle
doesn't. Refreshing table works on SQL Server but does not work on
Oracle.
What can I do?
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Remedy create wrong SELECT !!!
I know it. But I have my own big application that was developed for MS
SQL. Now I need move it to Oracle. Qualification like $Name$= very
much.
How could we correct it?
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Misi Mladoniczky
Sent: Thursday, June 19, 2008 11:05 AM
To: arslist@ARSLIST.ORG
Subject: Re: Remedy create wrong SELECT !!!
Hi!
It has allways worked like that.
Change your qualification to $Name$= instead of $Name$=.
Best Regards - Misi, RRR AB, http://rrr.se
Hi, all
I found interesting thing. For example, we have form (Form1) that
contain character field $Name$ and table. Table look at another form
(Form2) that contain only character field $Name$. Table qualification
is
( 'Name' = $Name$) OR ( $Name$ = ).
Open Remedy User and turn on database log. Open Form1. Leave $Name$
field empty and refresh table. See log:
SELECT T710.C1,C536870913,T710.C1 FROM T710 WHERE ((T710.C536870913 =
'
') OR (' ' = '')) ORDER BY 1 ASC
((T710.C536870913 = ' ') OR (' ' = '')) is ( 'Name' = $Name$) OR (
$Name$ = ). Empty field $Name$ is ' ' (space) in SELECT
expression.
Why Remedy replace NULL character fields with space in SELECT.
MS SQL Server convert (' ' = '') to ('' = '') automatically but Oracle
doesn't. Refreshing table works on SQL Server but does not work on
Oracle.
What can I do?
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
--
This message was scanned by ESVA and is believed to be clean.
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Superdom
Hi Have everyone successful experience with building ARSystem databases on Superdom? What can I have problem, and it's possible at all? Danila ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: SuperDome
Yes, I mean HP SuperDome (server Itanium x64), and I do it first time. I want know what problem I can meet? Now thanks to you I know, that installing of AR System on HP SuperDome is possible. Thanks. Danila From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Easter, David Sent: Wednesday, January 30, 2008 8:23 PM To: arslist@ARSLIST.ORG Subject: Re: Superdom I believe that AR System 7.1 is natively supported on Itanium architecture. There is a controlled available version of AR System 7.1.00 where the AR System server executable is both native Itanium and 64-bit. More information on this is available in the Statement of Direction which can be found at: http://www.bmc.com/products/documents/63/68/86368/86368.pdf AR System 7.0.01 is supported on the Itanium platform, but the executables are still PA-RISC and thus are run by taking advantage of the ARIES emulator. -David J. Easter Sr. Product Manager, Service Management Business Unit BMC Software, Inc. The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Shyam Attavar Sent: Wednesday, January 30, 2008 9:12 AM To: arslist@ARSLIST.ORG Subject: Re: Superdom ** If you are asking if the HW platform is a HP SuperDome, then I know for a fact that we were on a HP SuperDome with PA/RISC processor until recently. However, we moved away from the HP SuperDome with Itanium processor since the version we have running is not natively supported on this architecture. I believe that AR System 7.1 is natively supported on Itanium architecture. But we are not moving to 7.1 anytime soon. HTH, -- Shyam - Original Message - From: Beketov Danila mailto:[EMAIL PROTECTED] Newsgroups: gmane.comp.crm.arsystem.general To: arslist@ARSLIST.ORG Sent: Wednesday, January 30, 2008 4:24 AM Subject: Superdom ** Hi Have everyone successful experience with building ARSystem databases on Superdom? What can I have problem, and it's possible at all? Danila __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Remedy User parameters
It's external system, from which I need to start Remedy User for specific form and record. There's form of some system. When I click button on this form Remedy User must start and show form and record I need. Using anything .exe files to generate .ARTask file is undesirable. I need direct command without external tools to start Remedy User with form and record. Form name and request ID is known. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black Sent: Friday, January 25, 2008 4:40 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy User parameters Danila, If the Mid-Tier is an option... then opening the Mid-Tier ( with a URL for the specific form/Entry ID value) would be a snap. (But you still need something on the client to call or start that URL. Maybe you can add some context to this request for help? What is the starting point? (An Email? An IM? A smoke signal? A User clicking on something? Some other application? etc... etc...) Knowing what the full desired sequence of events might be very helpful to this discussion. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On Jan 25, 2008 1:29 AM, Beketov Danila [EMAIL PROTECTED] wrote: This way is not right for me. In that case I need to copy .exe file on every client machine. There's another way? snip -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Beketov Danila Sent: Wednesday, January 23, 2008 11:47 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy User parameters Yes! I have a external system, from which I need to launch Remedy User with dynamic form and record -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96 CS/SCCE Sent: Wednesday, January 23, 2008 6:22 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy User parameters Can you be very specific about what you're trying to accomplish? Perhaps with more info we can provide a workable solution. I take it you want to automatically open a request by Request ID? I'm assuming that the Request ID is also dynamic? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Beketov Danila Sent: Wednesday, January 23, 2008 9:12 AM To: arslist@ARSLIST.ORG Subject: Re: Remedy User parameters What I can do it by alternate tools? Maybe another way does exist? snip -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Beketov Danila Sent: Wednesday, January 23, 2008 8:44 AM To: arslist@ARSLIST.ORG Subject: Remedy User parameters ** Hi, How can I open Remedy User from cmd.exe for open specific record of specific form? Maybe Remedy User can run with parameters? Danila ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Remedy User parameters
This way is not right for me. In that case I need to copy .exe file on every client machine. There's another way? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96 CS/SCCE Sent: Thursday, January 24, 2008 5:21 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy User parameters Well, if you know how to code a little, you could write a simple little app that generates an ARTASK file and then call it with artask.exe. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Beketov Danila Sent: Wednesday, January 23, 2008 11:47 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy User parameters Yes! I have a external system, from which I need to launch Remedy User with dynamic form and record -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96 CS/SCCE Sent: Wednesday, January 23, 2008 6:22 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy User parameters Can you be very specific about what you're trying to accomplish? Perhaps with more info we can provide a workable solution. I take it you want to automatically open a request by Request ID? I'm assuming that the Request ID is also dynamic? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Beketov Danila Sent: Wednesday, January 23, 2008 9:12 AM To: arslist@ARSLIST.ORG Subject: Re: Remedy User parameters What I can do it by alternate tools? Maybe another way does exist? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96 CS/SCCE Sent: Wednesday, January 23, 2008 6:00 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy User parameters The User tool can be opened from the command prompt and it does accept some parameters, but unfortunately, form name and Request ID are not available as parameters. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Beketov Danila Sent: Wednesday, January 23, 2008 8:44 AM To: arslist@ARSLIST.ORG Subject: Remedy User parameters ** Hi, How can I open Remedy User from cmd.exe for open specific record of specific form? Maybe Remedy User can run with parameters? Danila __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
[no subject]
Hi, How can I open Remedy User from cmd.exe for open specific record of specific form? Maybe Remedy User can run with parameters? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Remedy User parameters
Hi, How can I open Remedy User from cmd.exe for open specific record of specific form? Maybe Remedy User can run with parameters? Danila ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Remedy User parameters
What I can do it by alternate tools? Maybe another way does exist? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96 CS/SCCE Sent: Wednesday, January 23, 2008 6:00 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy User parameters The User tool can be opened from the command prompt and it does accept some parameters, but unfortunately, form name and Request ID are not available as parameters. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Beketov Danila Sent: Wednesday, January 23, 2008 8:44 AM To: arslist@ARSLIST.ORG Subject: Remedy User parameters ** Hi, How can I open Remedy User from cmd.exe for open specific record of specific form? Maybe Remedy User can run with parameters? Danila __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Remedy User parameters
Yes! I have a external system, from which I need to launch Remedy User with dynamic form and record -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96 CS/SCCE Sent: Wednesday, January 23, 2008 6:22 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy User parameters Can you be very specific about what you're trying to accomplish? Perhaps with more info we can provide a workable solution. I take it you want to automatically open a request by Request ID? I'm assuming that the Request ID is also dynamic? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Beketov Danila Sent: Wednesday, January 23, 2008 9:12 AM To: arslist@ARSLIST.ORG Subject: Re: Remedy User parameters What I can do it by alternate tools? Maybe another way does exist? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96 CS/SCCE Sent: Wednesday, January 23, 2008 6:00 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy User parameters The User tool can be opened from the command prompt and it does accept some parameters, but unfortunately, form name and Request ID are not available as parameters. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Beketov Danila Sent: Wednesday, January 23, 2008 8:44 AM To: arslist@ARSLIST.ORG Subject: Remedy User parameters ** Hi, How can I open Remedy User from cmd.exe for open specific record of specific form? Maybe Remedy User can run with parameters? Danila __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
FW: Problem with MS SQL Server 2005
I sent my forms to BMC Support, they could simulate my problem. It's BMC Remedy defect. Thanks for all. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Hall Chad - chahal Sent: Friday, November 09, 2007 5:43 PM To: arslist@ARSLIST.ORG Subject: Re: Problem with MS SQL Server 2005 Looks like something crashed your server when it made the query. Check your arerror.log and arthread.log and see if you find more details on that. Chad Hall (501) 342-2650 __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: [SPAM] Re: [SPAM] Re: Problem with MS SQL Server 2005
There's two regular form. For example: rf1 and rf2, add into rf1 form four character fields with name ch1, ch2, ch4 and ch5; into rf2 form - ch1, ch2, ch3. Create join form jf1: join two forms rf1 with rf2 (inner), add into join form fields ch[1-5]. Join criteria: ch1 - ch1, ch2 - ch2. Create next join jf2: join form jf1 with itselt (outer), add into join form fields ch[1-5], criteria is ch3 - ch4. Create regular form rf3 with character field ch5. Create join form jf3: join jf2 with rf3 (outer) , add into join form fields ch[1-5], criteria is ch5 - ch5. Add data in regular forms in that way it meet the criteria. Open Remedy User, open form 'jf3' and press F5. It work. Change data in that way it don't meet the criteria, it don't work (only mssql server 2005). From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Thursday, November 08, 2007 7:37 PM To: arslist@ARSLIST.ORG Subject: [SPAM] Re: [SPAM] Re: Problem with MS SQL Server 2005 What's your join criteria? Try removing that criteria, SAVE the join, then put the criteria back again and SAVE it again.. Maybe for some reason your join definition has got corrupted and recreating the join as described might fix it. Have you seen the query it runs on the SQL server when you perform a search? Joe D'Souza -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Beketov Danila Sent: Thursday, November 08, 2007 11:28 AM To: arslist@ARSLIST.ORG Subject: Re: [SPAM] Re: Problem with MS SQL Server 2005 ** Each regular form have 1 record. All join form joined as outer. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Thursday, November 08, 2007 7:10 PM To: arslist@ARSLIST.ORG Subject: [SPAM] Re: Problem with MS SQL Server 2005 Let me guess.. large tables in the join, unindexed join criteria? Resulting in a table scan - it will eventually show the results if you do not press Stop, but your solution is check the join criteria and make sure that the fields in that criteria are indexed from the AR System. A DB level index will not help the AR System to interpret the index. Joe D'Souza -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Beketov Danila Sent: Thursday, November 08, 2007 9:32 AM To: arslist@ARSLIST.ORG Subject: Problem with MS SQL Server 2005 ** I have a serious problem with MS SQL Server 2005. I create some join forms and I get data from last join on MS SQL Server 2000. When I try create the same join forms and retrieve data from its I contemplate this massage Performing Search. It last until I press button Stop Search. Anybody confronted with this problem? I attached sample where join 6 do not work on MS SQL Server 2005, but successfully work on MS SQL Server 2000. __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: [SPAM] Re: Problem with MS SQL Server 2005
Each regular form have 1 record. All join form joined as outer. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Thursday, November 08, 2007 7:10 PM To: arslist@ARSLIST.ORG Subject: [SPAM] Re: Problem with MS SQL Server 2005 Let me guess.. large tables in the join, unindexed join criteria? Resulting in a table scan - it will eventually show the results if you do not press Stop, but your solution is check the join criteria and make sure that the fields in that criteria are indexed from the AR System. A DB level index will not help the AR System to interpret the index. Joe D'Souza -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Beketov Danila Sent: Thursday, November 08, 2007 9:32 AM To: arslist@ARSLIST.ORG Subject: Problem with MS SQL Server 2005 ** I have a serious problem with MS SQL Server 2005. I create some join forms and I get data from last join on MS SQL Server 2000. When I try create the same join forms and retrieve data from its I contemplate this massage Performing Search. It last until I press button Stop Search. Anybody confronted with this problem? I attached sample where join 6 do not work on MS SQL Server 2005, but successfully work on MS SQL Server 2000. __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: [SPAM] Re: Problem with MS SQL Server 2005
No logs is created by SQL. It seems remedy suspend and SQL do not get query from remedy. I think It's Remedy bug. I tried on version 7.0.01 patch 004 and 7.1. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Friday, November 09, 2007 12:42 AM To: arslist@ARSLIST.ORG Subject: [SPAM] Re: Problem with MS SQL Server 2005 Have you seen what is the query it runs against the database? Run an SQL log and see what you get.. Joe D'Souza -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Beketov Danila Sent: Thursday, November 08, 2007 12:26 PM To: arslist@ARSLIST.ORG Subject: Re: [SPAM] Re: [SPAM] Re: Problem with MS SQL Server 2005 ** There's two regular form. For example: rf1 and rf2, add into rf1 form four character fields with name ch1, ch2, ch4 and ch5; into rf2 form - ch1, ch2, ch3. Create join form jf1: join two forms rf1 with rf2 (inner), add into join form fields ch[1-5]. Join criteria: ch1 - ch1, ch2 - ch2. Create next join jf2: join form jf1 with itselt (outer), add into join form fields ch[1-5], criteria is ch3 - ch4. Create regular form rf3 with character field ch5. Create join form jf3: join jf2 with rf3 (outer) , add into join form fields ch[1-5], criteria is ch5 - ch5. Add data in regular forms in that way it meet the criteria. Open Remedy User, open form 'jf3' and press F5. It work. Change data in that way it don't meet the criteria, it don't work (only mssql server 2005). From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Thursday, November 08, 2007 7:37 PM To: arslist@ARSLIST.ORG Subject: [SPAM] Re: [SPAM] Re: Problem with MS SQL Server 2005 What's your join criteria? Try removing that criteria, SAVE the join, then put the criteria back again and SAVE it again.. Maybe for some reason your join definition has got corrupted and recreating the join as described might fix it. Have you seen the query it runs on the SQL server when you perform a search? Joe D'Souza -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Beketov Danila Sent: Thursday, November 08, 2007 11:28 AM To: arslist@ARSLIST.ORG Subject: Re: [SPAM] Re: Problem with MS SQL Server 2005 ** Each regular form have 1 record. All join form joined as outer. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Thursday, November 08, 2007 7:10 PM To: arslist@ARSLIST.ORG Subject: [SPAM] Re: Problem with MS SQL Server 2005 Let me guess.. large tables in the join, unindexed join criteria? Resulting in a table scan - it will eventually show the results if you do not press Stop, but your solution is check the join criteria and make sure that the fields in that criteria are indexed from the AR System. A DB level index will not help the AR System to interpret the index. Joe D'Souza -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Beketov Danila Sent: Thursday, November 08, 2007 9:32 AM To: arslist@ARSLIST.ORG Subject: Problem with MS SQL Server 2005 ** I have a serious problem with MS SQL Server 2005. I create some join forms and I get data from last join on MS SQL Server 2000. When I try create the same join forms and retrieve data from its I contemplate this massage Performing Search. It last until I press button Stop Search. Anybody confronted with this problem? I attached sample where join 6 do not work on MS SQL Server 2005, but successfully work on MS SQL Server 2000. __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
AR Server 7.01 silent installation
Hi I try to install Remedy Server 7.01 in silent mode. I do: 1. I create file ar_svr_silent.txt: --- [Silent] remedy.arsystem.server.name=mbpsd-1 remedy.arsystem.server.portmapper=True remedy.arsystem.server.tcpport= remedy.arsystem.server.pluginport= remedy.arsystem.server.autostart=True remedy.arsystem.server.debugmode= remedy.arsystem.install.component.samples=True remedy.arsystem.install.component.api=True remedy.arsystem.install.component.central.preferences=True remedy.arsystem.install.component.area.ldap=False remedy.arsystem.install.component.ardbc.ldap=False remedy.arsystem.install.component.webservices=False remedy.arsystem.server.plugin.wasp=False remedy.arsystem.server.wasp.url= remedy.arsystem.install.component.snmp=False remedy.arsystem.install.component.fts=False remedy.arsystem.server.fts.configdir= remedy.arsystem.server.fts.colldir= remedy.arsystem.server.fts.tempdir= remedy.arsystem.install.language.view.fr=False remedy.arsystem.install.language.view.de=False remedy.arsystem.install.language.view.it=False remedy.arsystem.install.language.view.ja=False remedy.arsystem.install.language.view.ko=False remedy.arsystem.install.language.view.es=False remedy.arsystem.install.language.view.ru=True remedy.arsystem.install.language.view.zh_CN=False remedy.arsystem.install.dir=C:\Program Files\AR System\mbpsd-1 remedy.arsystem.db.unicode=False remedy.arsystem.db.type=MSSQL remedy.arsystem.install.mode=Overwrite remedy.arsystem.server.dso.local.password= remedy.arsystem.server.apps.service.password= remedy.arsystem.server.midtier.password= remedy.arsystem.db.ars.user=ARAdmin remedy.arsystem.db.ars.password= remedy.arsystem.db.dba.user=sa remedy.arsystem.db.dba.password= remedy.arsystem.db.remote=False remedy.arsystem.db.sql.windows.authorization=False remedy.arsystem.db.server=MBPSD-1 remedy.arsystem.db.name=ARSystem remedy.arsystem.db.sql.data.filename= remedy.arsystem.db.sql.data.size= remedy.arsystem.db.sql.log.filename= remedy.arsystem.db.sql.log.size= 2. I run command: server.exe -S -i ar_svr_silent.txt In my temp directory I open file BSM_Error.log and find following: remedy.arsystem.install.status=FAILURE remedy.arsystem.install.reason=0: Portmapper not being used, TCP and plugin ports must be set. In ar_svr_silent.txt the key remedy.arsystem.server.portmapper=True What I do wrong? Beketov Danila ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Checking whether exist schema by Remedy
Hi! How can I check by Remedy 6.3 whether exist schema or no, and process result? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Problem with function FreeARQualifierStruct
The answer on Appajee's message. I have compiled 'driver' with MSVS.NET2005 and memory allocation problem has occurred. But It take place in debug mode (when I press 'F5'). If I compile program and execute it by running .exe file or pressing 'CTRL+F5', 'driver' and my own program execute without errors. In 'driver' project properties C/C++ - Code Generation - Basic Runtime Checks has been set to 'default', in my project to 'Both (/RTC1, equiv. to /RTCsu)'. My program run without errors (in non-debug mode, of cause) when I changed my properties like 'driver'. If I comment all except the QualifierStruct's initialization and ARFree, I get the same error. It's all the same. I will use my own free function or use both functions in the following way for example: #ifndef FREE_AR free(qualifier.u.andor.operandLeft-u.relOp); free(qualifier.u.andor.operandRight-u.relOp); free(qualifier.u.andor.operandLeft); free(qualifier.u.andor.operandRight); #else FreeARQualifierStruct(qualifier, FALSE); #endif Answer to Dan. I don't want to use new/delete because program will be less cross-platform. And I don't know where I can know how to define 'structure byte alignment' from? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Problem with function FreeARQualifierStruct
But driver define qualifier in the same way (malloc), for example see function APIARGetListEntry in api.c, and FreeAR.. works without errors. Why ??? From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ben Chernys Sent: Tuesday, May 29, 2007 11:16 AM To: arslist@ARSLIST.ORG Subject: Re: Problem with function FreeARQualifierStruct Addendum: I might add that the results are also consistent (in their inconsistency at least) on a different OS and hardware platform. One in which I can trap buffer overwrites, double frees and the like on the instruction that they occur. (see ElectricFence - unfortunately, not available for Windows). The only thing I can think is that the API is adjusting addresses or playing with a cache of some sort when allocating and freeing some of its objects. I would certainly consider this a bug in the API (BMC: hint hint). Cheers Ben ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Problem with function FreeARQualifierStruct
I use MS Visual Studio .NET 2005 (8.0), lib-files I get from Remedy 7.01 and I have problem with FreeAR...() From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Hugo Visser Sent: Tuesday, May 29, 2007 12:19 PM To: arslist@ARSLIST.ORG Subject: Re: Problem with function FreeARQualifierStruct ** Most likely you are compiling against a different msvcrt version then the Remedy API is compiled against. I've run in to this when writing plugins, aparently it's also an issue with normal API's. What happens is that somewhere along the line the Remedy API allocates some memory. But since the API is compiled against a different msvcrt, the memory is allocated from a different heap. When you try to free the pointer to the allocated memory in your program, the memory region cannot be free'd because it wasn't allocated on your own heap. When coding plugins, the server will pass in a struct and you should allocate memory that the server attempts to free. At this point the same problems will occur. If you provide your own FreeAR* equivalents you should be fine, since you are managing your own heap again. Unfortunately the versions of msvcrt are tied to the versions of Visual Studio. VS 6 will use msvcrt.dll, VS.NET http://VS.NET will use msvcrt7.dll (or something like that) etc. The C API guide has a comment about the versions of Visual Studio you should use for a particular version of the API, to prevent heap allocation problems. I'm not sure if this is also a problem on unix platforms, but I don't think so as the libc is a system component on unix, so every api that links to libc uses the same heap, if linked dynamically. Hugo ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Problem with function FreeARQualifierStruct
Yes, I develop plug-in for Remedy. It's stranger that this problem go away when I just compile and occur when I start debug. Ok, thanks for information From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Hugo Visser Sent: Tuesday, May 29, 2007 1:04 PM To: arslist@ARSLIST.ORG Subject: Re: Problem with function FreeARQualifierStruct ** From the C API Reference guide: ** Before you write C API programs, you must verify system requirements and install the API package, which includes the following components: Microsoft Visual Studio .NET 2003 or later, or built with Microsoft Visual C++ version 7.0 (for Windows) Code generation: Multithreaded DLL Structure member alignment: 8 bytes (default) Set code generation to Multithreaded DLL, not Debug Multithreaded DLL. Where other included libraries cause conflicts, add /nodefaultlib:MSVCRTD to the project options to avoid using the Debug C runtime library. If your program references this library at runtime, memory management errors will occur when memory pointers are referenced by both the Debug and Release C runtime libraries. *** They state .NET 2003 or later, but that is not what I experienced. If possible try the same in VS.NET http://VS.NET 2003, and test with a release build. The 7.01 API is linked against MSVCR71.DLL, while 2005 is using MSVCR80.DLL. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
[no subject]
Hi I have a problem with Remedy C API function FreeARQualifierStruct. I need to load qualifier structure manually, see follow: ARQualifierStruct qualifier; memset((char *) qualifier, '\0', sizeof(ARQualifierStruct)); qualifier.operation = AR_COND_OP_REL_OP; qualifier.u.relOp = (ARRelOpStruct *) malloc(sizeof(ARRelOpStruct)); qualifier.u.relOp-operation = (unsigned int) AR_REL_OP_EQUAL; qualifier.u.relOp-operandLeft.tag = (unsigned int) AR_FIELD; qualifier.u.relOp-operandLeft.u.fieldId = (ARInternalId) 7; qualifier.u.relOp-operandRight.tag = (unsigned int) AR_VALUE; qualifier.u.relOp-operandRight.u.value.dataType = AR_DATA_TYPE_INTEGER; qualifier.u.relOp-operandRight.u.value.u.intVal = (ARLong32) 1; If execute FreeARQualifierStruct(qualifier, FALSE); I get the follow error: It's mean I have a problem with feeing allocated memory, but when I load qualifier with ARLoadARQualifierStruct I get the same qualifier that was defined above (I check it in debugger), and FreeARQualifierStruct exicute without errors. I don't understand this situation. What I do wrong? Sorry for my bad english ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are image002.jpg
Problem with function FreeARQualifierStruct
Hi I have a problem with Remedy C API function FreeARQualifierStruct. I need to load qualifier structure manually, see follow: ARQualifierStruct qualifier; memset((char *) qualifier, '\0', sizeof(ARQualifierStruct)); qualifier.operation = AR_COND_OP_REL_OP; qualifier.u.relOp = (ARRelOpStruct *) malloc(sizeof(ARRelOpStruct)); qualifier.u.relOp-operation = (unsigned int) AR_REL_OP_EQUAL; qualifier.u.relOp-operandLeft.tag = (unsigned int) AR_FIELD; qualifier.u.relOp-operandLeft.u.fieldId = (ARInternalId) 7; qualifier.u.relOp-operandRight.tag = (unsigned int) AR_VALUE; qualifier.u.relOp-operandRight.u.value.dataType = AR_DATA_TYPE_INTEGER; qualifier.u.relOp-operandRight.u.value.u.intVal = (ARLong32) 1; If execute FreeARQualifierStruct(qualifier, FALSE); I get the follow error: It's mean I have a problem with feeing allocated memory, but when I load qualifier with ARLoadARQualifierStruct I get the same qualifier that was defined above (I check it in debugger), and FreeARQualifierStruct exicute without errors. I don't understand this situation. What I do wrong? Sorry for my bad english ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are image002.jpg
Re: Load qualification string in ARQualifierStruct
I use Remedy C API for create and manage class items and I need to
create join forms with C functions. I want to load ARQualifierStruct
from c-string, for example:
my function, that I will create
loadQualifierStruct(('Operator' != $NULL$) AND ('Operator' = 2),
qualifier);
The ARQualifierStruct structure must be filed with
ARLoadARQualifierStruct, that not allow to use two schemata, or with
ARDecodeARQulifierStruct, that not be used in that case, or I must
create my own function. If Remedy C API have already this function, it
will be easier for me.
Danila
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Papolu, Appajee
Sent: Friday, May 18, 2007 5:44 PM
To: arslist@ARSLIST.ORG
Subject: Re: Load qualification string in ARQualifierStruct
(Unfortunately) the LoadQual C API function only handles qualifications
involving only one schema/form. The logic for Set/Push fields condition
processing is built in into Admin Tool and the run-time clients
(User/Mid-tier). However if it is an option, you might want to check out
the Java API or the .NET API which have surfaced similar capability as
an API method.
In any case, may I know what your use case is, in case we can suggest
some other alternative?
Regards
Appajee
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Danya
Sent: Friday, May 18, 2007 12:42 AM
To: arslist@ARSLIST.ORG
Subject: Load qualification string in ARQualifierStruct
Hello
I'm beginner at Remedy C API. I have a follow question.
There's ARLoadARQualifierStruct function that may load qualifier
struct
for only one schema. For example Run If in filter.
I need to load qualifier struct for join criteria (and Set Field
and
Push Field actions) where two schemata take a part.
For example: Set Field from schema 1 to schema 2
'Operator' = $Operator$ AND 'Status' != $NULL$
Sorry for my bad english!
--
View this message in context:
http://www.nabble.com/Load-qualification-string-in-ARQualifierStruct-tf3
776197.html#a10677797
Sent from the ARS (Action Request System) mailing list archive at
Nabble.com.
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where
the Answers Are
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where
the Answers Are
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the
Answers Are
