RE: BMC Remedy Helix - is it really a thing?

[Aykut Koray Kuşat]

Hi all,

Btw,  anybody knows what is the difference between Business Workflows and 
Innovation Suite? Afaik, Innovation Suite is the Service Broker solution of 
BMC. But thats it, im totally ignorant on these solutions.

Cheers

From: ARSList  On Behalf Of Tauf Chowdhury
Sent: Friday, July 13, 2018 6:04 PM
To: ARSList 
Subject: Re: BMC Remedy Helix - is it really a thing?

Oh yes. Sorry. DWP, how rude of me not to keep up with the &$@!?$ acronyms
Sent from my iPhone

On Jul 13, 2018, at 10:58 AM, Carl Wilson 
mailto:carlbwil...@gmail.com>> wrote:
Yep,
Renamed a while back to DWP Basic and DWP Advanced.

Cheers
On Fri, 13 Jul 2018, 15:56 Scott Philben via ARSList, 
mailto:arslist@arslist.org>> wrote:

Yes. It is containerized in Docker. Whatever that means. And it is supposed to 
be available on AWS now with Azure and others in the future.

Ok. How about a few install instructions. Screenshots? Documentation? Anything 
at all on their website that’s not from the marketing department.

Oh, and myit  has now (in the grand bmc tradition) been renamed to DWP (Digital 
Work Place).


Sent from my iPhone

On Jul 13, 2018, at 10:45, Tauf Chowdhury 
mailto:taufc...@gmail.com>> wrote:
From some of the demos I’ve seen, the front end is basically SmartIt and myit. 
I think the big changes are with the way it’s deployed and DB options. I work 
at AWS now and I believe Helix can be installed against Aurora DB, and can also 
be containerized. Not sure if that’s kubernetes or docker or what.
Sent from my iPhone

On Jul 13, 2018, at 10:40 AM, Jason Miller 
mailto:jason.mil...@gmail.com>> wrote:
Have you seen this post?   
https://communities.bmc.com/community/bmcdn/bmc_it_service_support/blog/2018/06/16/bmc-helix-what-does-it-mean-for-remedy-itsm-customers

"BMC Helix is our common brand for the suite of SaaS offerings centered around 
Remedy,
 Business 
Workflows,
 Digital 
Workplace,
 
Discovery,
 Client 
Management
 and Innovation 
Suite."


Jason

On Fri, Jul 13, 2018 at 8:02 AM, Scott Philben via ARSList 
mailto:arslist@arslist.org>> wrote:
I am supposed to be looking into this Helix on AWS thing. However, other than a 
bunch of marketing stuff and youtube commercials, I can’t find hide nor hair of 
it.

Does anyone know anything about it? Any documentation at all? Its does not 
appear in the BMC Support site drop downs, there is really nothing on 
communities (links back to the marketing page), and when you click on the 
“Contact BMC Sales” button on the marketing site, the Product Interest menu 
drop down doesn’t list it either.

It was supposed to have been released in… May? It is now July and I can’t find 
it.

Anyone else see it in the wild?
--
ARSList mailing list
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist

--
ARSList mailing list
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist
--
ARSList mailing list
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist
--
ARSList mailing list
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist
--
ARSList mailing list
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist
-- 
ARSList mailing list
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist

Re: Looooooooooong update times on ARSCHEMA

[Alkan Koray]

Hi Guillaume,

Yes, that value is set to 20 already. But as Derek indicated: this issue
occurs only on Distributed Pending (T26) form - which I believe Request ID
Block Size changes have no effect on. 

Or am I wrong?

Thanks,
Alkan Koray
-- 
View this message in context: 
http://old.nabble.com/Looong-update-times-on-ARSCHEMA-tp26202209p31806727.html
Sent from the ARS (Action Request System) mailing list archive at Nabble.com.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are

Re: Looooooooooong update times on ARSCHEMA

[Alkan Koray]

Hello Derek,

I have been facing with the exact same situation as you are since for a
while sparodically. Although I have been in contact with BMC for months -
believe me - I still have no progress. 

Wondering - Has you issue been resolved by now? If yes, how did you manage
to do that?

Regards,
Alkan Koray
-- 
View this message in context: 
http://old.nabble.com/Looong-update-times-on-ARSCHEMA-tp26202209p31800734.html
Sent from the ARS (Action Request System) mailing list archive at Nabble.com.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are

Different Queries for the same Active Link on DB

[koray]

Hello all,

I have observed a weird issue on 2 different servers. I have an Active
Link with Set Fields action that retrieves data from another form on
both of the servers - say with qualification 'A (C3)' = B. After
logging, on Server 1 a sample query like below is executed :

select c1, c3 from Txxx where c3='B'

But on the other one,

select c1, c2, c3 from Txxx where c3='B'  -- say c1 has value 002
after the operation.
select c2 from Txxx where c1='002'

What is the reason for this difference and where is this configurable?

Regards,
Koray

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are

Re: AR System Email Messages - Error Behaviour?

[koray]

Yes, an escalation was needed to fulfill this task, or just a restart
of the email engine was enough.

Thank you!
Koray

On Nov 6, 12:24 am, Andrew Fremont andrewfrem...@gmail.com wrote:
 We sometimes need to re-start the email engine to have those emails going.



 On Fri, Nov 5, 2010 at 12:26 PM, Ramey, Anne anne.ra...@nc.gov wrote:
  I've had some email errors today, and when I click send in the error-ed
  message, the Send Message gets changed back to Yes, but the message never
  appears to retry.  I've run a report on those messages and the new once that
  are going out--but they appear the same  (I though maybe a hidden field/flag
  wasn't getting set).  Any idea why they aren't going or how I can get them
  to send?

  ARS 7.1 p 11
  ITSM 7.0.3 p 9
  Oracle 10g
  Linux RHEL4

  Anne Ramey
  ***
  E-mail correspondence to and from this address may be subject to the North
  Carolina Public Records Law and may be disclosed to third parties only by an
  authorized State Official.

  -Original Message-
  From: Action Request System discussion list(ARSList) [mailto:
  arsl...@arslist.org] On Behalf Of Guillaume Rheault
  Sent: Thursday, November 04, 2010 10:36 AM
  To: arsl...@arslist.org
  Subject: Possibly spam: Re: AR System Email Messages - Error Behaviour?

  I think this is the first time that somebody has asked this question.
  It does not retry by default. I think you would need to create some custom
  functionality to accomplish like, such as an escalation that queries the
  emails not sent because of an error and reset the flag to send it again.

  Guillaume

  
  From: Action Request System discussion list(ARSList) [arsl...@arslist.org]
  on behalf of koray [ko...@alkankoray.net]
  Sent: Thursday, November 04, 2010 7:40 AM
  To: arsl...@arslist.org
  Subject: AR System Email Messages - Error Behaviour?

  Hello together,

  I have one simple question: If an outgoing e-mail message is set to
  Error on ARS Email Messages form, does the system try re-sending it
  with any intervals?

  Thanks in advance,
  Koray

  ___
  UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
  attend wwrug11www.wwrug.comARSList: Where the Answers Are

  ___
  UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
  attend wwrug11www.wwrug.comARSList: Where the Answers Are

  If this message is a valid email, you can request that future messages from
  this source be processed normally through the email system by visiting
 http://www.ncmail.net/whitelist_procedures.htm

  ___
  UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
  attend wwrug11www.wwrug.comARSList: Where the Answers Are

 ___
 UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
 attend wwrug11www.wwrug.comARSList: Where the Answers Are

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are

Changing Server Time Format on Server Info

[koray]

Hi all,

How can I change the Server Time format on AR System
Administration:Server Information form?
E.g. Current format is mm/dd/yy and I would like to change it to dd/mm/
yy.

Regards,
Koray Alkan

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are

Re: Changing Server Time Format on Server Info

[koray]

UPDATE: have just accomplished that by setting the environment
variable ARDATE.

Please ignore this mail!

On Nov 24, 3:15 pm, koray ko...@alkankoray.net wrote:
 Hi all,

 How can I change the Server Time format on AR System
 Administration:Server Information form?
 E.g. Current format is mm/dd/yy and I would like to change it to dd/mm/
 yy.

 Regards,
 Koray Alkan

 ___ 
 
 UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
 attend wwrug11www.wwrug.comARSList: Where the Answers Are

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are

AR System Email Messages - Error Behaviour?

[koray]

Hello together,

I have one simple question: If an outgoing e-mail message is set to
Error on ARS Email Messages form, does the system try re-sending it
with any intervals?

Thanks in advance,
Koray

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are

Re: Is there any explanation for Canceled filter processing due to error?

[koray]

One additional information: user does not even receive any error or
warning.

On Oct 1, 3:25 am, LJ LongWing lj.longw...@gmail.com wrote:
 But there is WAY too little time between the select and the rollback to have
 requested user feedback and have received ittalking less than a tenth of
 a second.



 -Original Message-
 From: Action Request System discussion list(ARSList)

 [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W
 Sent: Thursday, September 30, 2010 6:01 PM
 To: arsl...@arslist.org
 Subject: Re: Is there any explanation for Canceled filter processing due to
 error?

 The snippet tells the whole story...   Select C6 ...

 The Last Modified Date has changed from when the record was pulled at the
 start of the transaction.  A user should have received the This record has
 been updated by another user since you retrieved it. error (Error 1203) and
 the user chose not to save the record.

 Fred

 -Original Message-
 From: Action Request System discussion list(ARSList)
 [mailto:arsl...@arslist.org] On Behalf Of LJ LongWing
 Sent: Thursday, September 30, 2010 9:16 AM
 To: arsl...@arslist.org
 Subject: Re: Is there any explanation for Canceled filter processing due to
 error?

 With the snipit you provided, I cannot see it, but it's obvious that
 somewhere earlier in your process something caused the DB to issue a
 rollback...you just need to find the 'what'

 -Original Message-
 From: Action Request System discussion list(ARSList)
 [mailto:arsl...@arslist.org] On Behalf Of koray
 Sent: Thursday, September 30, 2010 2:04 AM
 To: arsl...@arslist.org
 Subject: Re: Is there any explanation for Canceled filter processing due to
 error?

 Thanks for the feedback,

 I have had faced with a similar issue - a completely different one but
 identical to your example :
 - A script does a Push Fields to a form, but gets ARERR 382.
 - However, the Submit filters are executed after the operation as
 regular.
 - At the end of Phase, Canceled filter processing due to error
 appears.

 The .log file has the line
 /* UPDATE xxx SET ...
 /*
 /* ROLLBACK

 This totally seems to be okay, and supports your example.

 On the other hand, the current case has all queries seem to be
 executed successfully - ending with /* OK.

 So I cannot see why or which statement fails at all.

 BR,
 Koray

 On Sep 29, 5:57 pm, LJ LongWing lj.longw...@gmail.com wrote:
  Koray,
  You have your answer right thereor more than likely, somewhere earlier
  upbut the result is right there.

   /* Tue Sep 28 2010 12:24:43.4319 */ROLLBACK WORK

  I experience this type of scenario when I issue an out of phase delete of
 a
  record that I'm updating...here is my typical scenario

  I want to delete a recordthe easiest way to do a delete is to push to
  that record and set a 'delete' field to 'yes', and have a filter on that
  form do a record delete if that flag is yes

  Well...if that filter does an out of phase delete (phase 1), when phase 2
  goes through and tries to update the last mod by and last mod date on the
  record, that record doesn't exist, and as such, the db throws an error and
  causes a rollback...

  I don't know what your scenario is, but something in your processing is
  causing the db to throw and error and rollback the transaction.

  -Original Message-
  From: Action Request System discussion list(ARSList)

  [mailto:arsl...@arslist.org] On Behalf Of koray
  Sent: Wednesday, September 29, 2010 1:47 AM
  To: arsl...@arslist.org
  Subject: Re: Is there any explanation for Canceled filter processing due
 to
  error?

  And here is the SQL .log file corresponding to the same process :

   /* Tue Sep 28 2010 12:24:43.4296 */SELECT C6 FROM T904 WHERE C1 =
  '1308884'
   /* Tue Sep 28 2010 12:24:43.4317 */OK
   /* Tue Sep 28 2010 12:24:43.4319 */ROLLBACK WORK
   /* Tue Sep 28 2010 12:24:43.4697 */COMMIT WORK
   /* Tue Sep 28 2010 12:24:43.4705 */COMMIT WORK
   /* Tue Sep 28 2010 12:24:45.3386 */SELECT
 C1,C2,C3,C4,C5,C6,C7,C8,C112,...
   /* Tue Sep 28 2010 12:24:45.3738 */OK

  On Sep 29, 10:03 am, koray ko...@alkankoray.net wrote:
   Hello all,

   I have a weird issue that seems to be happening continously. Below is
   a portion from server-side filter .log file that took my attention:

/* Tue Sep 28 2010 12:24:43.4127 */     End of filter processing
 (phase
  1) -- Operation - SET on ZZZ - AD01589874
/* Tue Sep 28 2010 12:24:43.4130 */     Restart of filter processing
  (phase 2) -- Operation - SET on YYY - 1308884
/* Tue Sep 28 2010 12:24:43.4159 */     Filter Level:0 Number Of
  Filters:404 Checking IMSA:MAIN:TASK:Task:Get WIP Task
        0: Push Fields - IMSA:MAIN:Automated Pending:Task
              deferred from filter IMSA:MAIN:TASK:Task:Get WIP Task
/* Tue Sep 28 2010 12:24:43.4189 */     End of filter processing
 (phase
  2) -- Operation - SET on YYY - 1308884
/* Tue Sep 28 2010 12:24:43.4710 */Canceled

Re: Is there any explanation for Canceled filter processing due to error?

[koray]

Thanks for the feedback,

I have had faced with a similar issue - a completely different one but
identical to your example :
- A script does a Push Fields to a form, but gets ARERR 382.
- However, the Submit filters are executed after the operation as
regular.
- At the end of Phase, Canceled filter processing due to error
appears.

The .log file has the line
/* UPDATE xxx SET ...
/*
/* ROLLBACK

This totally seems to be okay, and supports your example.

On the other hand, the current case has all queries seem to be
executed successfully - ending with /* OK.

So I cannot see why or which statement fails at all.

BR,
Koray

On Sep 29, 5:57 pm, LJ LongWing lj.longw...@gmail.com wrote:
 Koray,
 You have your answer right thereor more than likely, somewhere earlier
 upbut the result is right there.

  /* Tue Sep 28 2010 12:24:43.4319 */ROLLBACK WORK

 I experience this type of scenario when I issue an out of phase delete of a
 record that I'm updating...here is my typical scenario

 I want to delete a recordthe easiest way to do a delete is to push to
 that record and set a 'delete' field to 'yes', and have a filter on that
 form do a record delete if that flag is yes

 Well...if that filter does an out of phase delete (phase 1), when phase 2
 goes through and tries to update the last mod by and last mod date on the
 record, that record doesn't exist, and as such, the db throws an error and
 causes a rollback...

 I don't know what your scenario is, but something in your processing is
 causing the db to throw and error and rollback the transaction.



 -Original Message-
 From: Action Request System discussion list(ARSList)

 [mailto:arsl...@arslist.org] On Behalf Of koray
 Sent: Wednesday, September 29, 2010 1:47 AM
 To: arsl...@arslist.org
 Subject: Re: Is there any explanation for Canceled filter processing due to
 error?

 And here is the SQL .log file corresponding to the same process :

  /* Tue Sep 28 2010 12:24:43.4296 */SELECT C6 FROM T904 WHERE C1 =
 '1308884'
  /* Tue Sep 28 2010 12:24:43.4317 */OK
  /* Tue Sep 28 2010 12:24:43.4319 */ROLLBACK WORK
  /* Tue Sep 28 2010 12:24:43.4697 */COMMIT WORK
  /* Tue Sep 28 2010 12:24:43.4705 */COMMIT WORK
  /* Tue Sep 28 2010 12:24:45.3386 */SELECT C1,C2,C3,C4,C5,C6,C7,C8,C112,...
  /* Tue Sep 28 2010 12:24:45.3738 */OK

 On Sep 29, 10:03 am, koray ko...@alkankoray.net wrote:
  Hello all,

  I have a weird issue that seems to be happening continously. Below is
  a portion from server-side filter .log file that took my attention:

   /* Tue Sep 28 2010 12:24:43.4127 */     End of filter processing (phase
 1) -- Operation - SET on ZZZ - AD01589874
   /* Tue Sep 28 2010 12:24:43.4130 */     Restart of filter processing
 (phase 2) -- Operation - SET on YYY - 1308884
   /* Tue Sep 28 2010 12:24:43.4159 */     Filter Level:0 Number Of
 Filters:404 Checking IMSA:MAIN:TASK:Task:Get WIP Task
           0: Push Fields - IMSA:MAIN:Automated Pending:Task
                 deferred from filter IMSA:MAIN:TASK:Task:Get WIP Task
   /* Tue Sep 28 2010 12:24:43.4189 */     End of filter processing (phase
 2) -- Operation - SET on YYY - 1308884
   /* Tue Sep 28 2010 12:24:43.4710 */Canceled filter processing due to
 error
   /* Tue Sep 28 2010 12:24:45.2824 */     Start filter processing (phase
 1) -- Operation - SET on XXX - 1308884

  The message Canceled filter processing due to error occurs but there
  are no details for it. The whole event restarts after a delay of 2-
  to-9 seconds, as seen in this example it was only 2.
  My question would be,

           In which circumstances this message would appear?

  Best Regards,
  Koray

 ___
 
  UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
  attend wwrug10www.wwrug.comARSlist:Where the Answers Are

 ___ _
 ___
 UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
 attend wwrug10www.wwrug.comARSlist: Where the Answers Are

 ___ 
 
 UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
 attend wwrug10www.wwrug.comARSlist: Where the Answers Are

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are

Is there any explanation for Canceled filter processing due to error?

[koray]

Hello all,

I have a weird issue that seems to be happening continously. Below is
a portion from server-side filter .log file that took my attention:

 /* Tue Sep 28 2010 12:24:43.4127 */ End of filter processing (phase 1) -- 
 Operation - SET on ZZZ - AD01589874
 /* Tue Sep 28 2010 12:24:43.4130 */ Restart of filter processing (phase 
 2) -- Operation - SET on YYY - 1308884
 /* Tue Sep 28 2010 12:24:43.4159 */ Filter Level:0 Number Of 
 Filters:404 Checking IMSA:MAIN:TASK:Task:Get WIP Task
 0: Push Fields - IMSA:MAIN:Automated Pending:Task
   deferred from filter IMSA:MAIN:TASK:Task:Get WIP Task
 /* Tue Sep 28 2010 12:24:43.4189 */ End of filter processing (phase 2) -- 
 Operation - SET on YYY - 1308884
 /* Tue Sep 28 2010 12:24:43.4710 */Canceled filter processing due to error
 /* Tue Sep 28 2010 12:24:45.2824 */ Start filter processing (phase 1) -- 
 Operation - SET on XXX - 1308884


The message Canceled filter processing due to error occurs but there
are no details for it. The whole event restarts after a delay of 2-
to-9 seconds, as seen in this example it was only 2.
My question would be,

 In which circumstances this message would appear?


Best Regards,
Koray

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are

Re: Is there any explanation for Canceled filter processing due to error?

[koray]

And here is the SQL .log file corresponding to the same process :

 /* Tue Sep 28 2010 12:24:43.4296 */SELECT C6 FROM T904 WHERE C1 = 
 '1308884'
 /* Tue Sep 28 2010 12:24:43.4317 */OK
 /* Tue Sep 28 2010 12:24:43.4319 */ROLLBACK WORK
 /* Tue Sep 28 2010 12:24:43.4697 */COMMIT WORK
 /* Tue Sep 28 2010 12:24:43.4705 */COMMIT WORK
 /* Tue Sep 28 2010 12:24:45.3386 */SELECT C1,C2,C3,C4,C5,C6,C7,C8,C112,...
 /* Tue Sep 28 2010 12:24:45.3738 */OK

On Sep 29, 10:03 am, koray ko...@alkankoray.net wrote:
 Hello all,

 I have a weird issue that seems to be happening continously. Below is
 a portion from server-side filter .log file that took my attention:

  /* Tue Sep 28 2010 12:24:43.4127 */     End of filter processing (phase 1) 
  -- Operation - SET on ZZZ - AD01589874
  /* Tue Sep 28 2010 12:24:43.4130 */     Restart of filter processing (phase 
  2) -- Operation - SET on YYY - 1308884
  /* Tue Sep 28 2010 12:24:43.4159 */     Filter Level:0 Number Of 
  Filters:404 Checking IMSA:MAIN:TASK:Task:Get WIP Task
          0: Push Fields - IMSA:MAIN:Automated Pending:Task
                deferred from filter IMSA:MAIN:TASK:Task:Get WIP Task
  /* Tue Sep 28 2010 12:24:43.4189 */     End of filter processing (phase 2) 
  -- Operation - SET on YYY - 1308884
  /* Tue Sep 28 2010 12:24:43.4710 */Canceled filter processing due to error
  /* Tue Sep 28 2010 12:24:45.2824 */     Start filter processing (phase 1) 
  -- Operation - SET on XXX - 1308884

 The message Canceled filter processing due to error occurs but there
 are no details for it. The whole event restarts after a delay of 2-
 to-9 seconds, as seen in this example it was only 2.
 My question would be,

          In which circumstances this message would appear?

 Best Regards,
 Koray

 ___ 
 
 UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
 attend wwrug10www.wwrug.comARSlist: Where the Answers Are

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are

C API - Input a Thread Possible?

[koray]

Hi all,

One simple question I am wondering about: Can I determine the thread
number my C script would run with a Run Process? So I would input a
paramtere like ./myscipt -rpc -thread?

Hope someone could cheer me up!

Best Regards,
Koray

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are

Re: C API - Input a Thread Possible?

[koray]

Hi all,

Then the only way seems to expand the current single queue+multiple
thread settings to multiple queue+single thread and give RPC as an
input.

Thank you for your answers!

Best Regards,
Koray

On Jul 15, 5:03 pm, Danny Kellett
danny.kell...@strategicworkflow.com wrote:
 Hi,

 No, the threads within the rpc queue are defined by the arserver.

 Regards
 Danny



 -Original Message-
 From: Action Request System discussion list(ARSList)

 [mailto:arsl...@arslist.org] On Behalf Of koray
 Sent: 15 July 2010 14:49
 To: arsl...@arslist.org
 Subject: C API - Input a Thread Possible?

 Hi all,

 One simple question I am wondering about: Can I determine the thread
 number my C script would run with a Run Process? So I would input a
 paramtere like ./myscipt -rpc -thread?

 Hope someone could cheer me up!

 Best Regards,
 Koray

 ___ _
 ___
 UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
 attend wwrug10www.wwrug.comARSlist: Where the Answers Are

 ___ 
 
 UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
 attend wwrug10www.wwrug.comARSlist: Where the Answers Are

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are

Date/Time Field - Bug Found

[koray]

Hello all,

My regional settings for date/time field is as follows:   6/24/2010
9:45:12 AM

If I (or the user) enters date/time as 24062010 9:45:12 remedy
creates the database entry with integer value of 24062010 - which maps
to actually 10/6/1970 2:53:30 PM.

Therefore this causes a big unstability and I guess another bug of
Remedy ARS.

BR,
Koray

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are

Notify Action - HTML/Plain Text?

[Alkan, Koray]

Hello together,

I need a fixed-width notification e-mail for some kind of a table by
using Notify action.
Is it possible that I can set the outgoing Notify E-mail to plain
text?
Or maybe can I use HTML formatting in the Notify text?

I tried adding HTML tags directly but it did not work.

Thanks in advance,
Koray

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are

Re: {Remedy ARS} Re: Replace New Line Character with 7.5, not possible anymore?

[Alkan, Koray]

Hello again,

Still no news but this workaround works perfect:

- Create a temporary char field
- Set that field with SQL : select chr(10) from dual
- Use this new field's value in replace functions.

Although CHR(13)+CHR(10) is the new line character for windows Remedy
uses CHR(10) for new lines.

Best Regards,
Koray

On May 21, 10:12 am, Alkan, Koray koray.al...@siemens-
ENTERPRISE.COM wrote:
 Hello all,

 Bad news, none of the above worked for 7.5
 In the meantime I will try contacting BMC to see if they have a
 workaround for this issue, but not with much hope.
 I will keep you updated.

 Koray

 On May 20, 6:30 pm, Grooms, Frederick W frederick.w.gro...@xo.com
 wrote:





  I have always used:    REPLACE($Text$, LTRIM(RTRIM( | )), )

  (The vertical bar above being the new line).  

  There was a problem with older versions where the new line would sometimes 
  be seen as a new line space (or space new line, I can't remember which) so 
  the trim of each side clears that up.

  Fred

  -Original Message-
  From: Action Request System discussion list(ARSList) 
  [mailto:arsl...@arslist.org] On Behalf Of Alkan, Koray
  Sent: Thursday, May 20, 2010 10:03 AM
  To: arsl...@arslist.org
  Subject: Replace New Line Character with 7.5, not possible anymore?

  Hello together,

  With Remedy 7.5 Replace function for new lines are not working anymore
  such as

  REPLACE($Text$, 
  , )

  Is there any workaround you know?

  Regards,
  Koray

  ___ 
  
  UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
  attend wwrug10www.wwrug.comARSlist:Where the Answers Are

  --
  You received this message because you are subscribed to the Google Groups 
  Remedy ARS group.
  To post to this group, send email to arsl...@googlegroups.com.
  To unsubscribe from this group, send email to 
  arslist+unsubscr...@googlegroups.com.
  For more options, visit this group 
  athttp://groups.google.com/group/arslist?hl=en.

 ___ 
 
 UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
 attend wwrug10www.wwrug.comARSlist: Where the Answers Are

 --
 You received this message because you are subscribed to the Google Groups 
 Remedy ARS group.
 To post to this group, send email to arsl...@googlegroups.com.
 To unsubscribe from this group, send email to 
 arslist+unsubscr...@googlegroups.com.
 For more options, visit this group 
 athttp://groups.google.com/group/arslist?hl=en.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are

Re: {Remedy ARS} Re: Replace New Line Character with 7.5, not possible anymore?

[Alkan, Koray]

Hello all,

Bad news, none of the above worked for 7.5
In the meantime I will try contacting BMC to see if they have a
workaround for this issue, but not with much hope.
I will keep you updated.

Koray

On May 20, 6:30 pm, Grooms, Frederick W frederick.w.gro...@xo.com
wrote:
 I have always used:    REPLACE($Text$, LTRIM(RTRIM( | )), )

 (The vertical bar above being the new line).  

 There was a problem with older versions where the new line would sometimes be 
 seen as a new line space (or space new line, I can't remember which) so the 
 trim of each side clears that up.

 Fred



 -Original Message-
 From: Action Request System discussion list(ARSList) 
 [mailto:arsl...@arslist.org] On Behalf Of Alkan, Koray
 Sent: Thursday, May 20, 2010 10:03 AM
 To: arsl...@arslist.org
 Subject: Replace New Line Character with 7.5, not possible anymore?

 Hello together,

 With Remedy 7.5 Replace function for new lines are not working anymore
 such as

 REPLACE($Text$, 
 , )

 Is there any workaround you know?

 Regards,
 Koray

 ___ 
 
 UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
 attend wwrug10www.wwrug.comARSlist: Where the Answers Are

 --
 You received this message because you are subscribed to the Google Groups 
 Remedy ARS group.
 To post to this group, send email to arsl...@googlegroups.com.
 To unsubscribe from this group, send email to 
 arslist+unsubscr...@googlegroups.com.
 For more options, visit this group 
 athttp://groups.google.com/group/arslist?hl=en.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are

Replace New Line Character with 7.5, not possible anymore?

[Alkan, Koray]

Hello together,

With Remedy 7.5 Replace function for new lines are not working anymore
such as

REPLACE($Text$, 
, )

Is there any workaround you know?

Regards,
Koray

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are

System Generated Forms List

[Alkan, Koray]

Hello together,

Where can I find a list of AR System forms generated automatically
such as User or Groups?

Kind Regards,
Koray

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are

Re: {Remedy ARS} Re: Active Link External $PROCESS$ on AR Server 7.5

[Alkan, Koray]

Hi Frederick,

Of course, it was LD_PRELOAD environment. After setting it to null,
everything went smooth.
Sorry for the late reply, I have been trying to save the world for the
past week..

Best Regards,
Koray

On Apr 22, 4:37 pm, Grooms, Frederick W frederick.w.gro...@xo.com
wrote:
 You mind telling the list which environment variable it was.   Info like that 
 can help the next person.



 -Original Message-
 From: Action Request System discussion list(ARSList) 
 [mailto:arsl...@arslist.org] On Behalf Of Alkan, Koray
 Sent: Wednesday, April 21, 2010 4:59 PM
 To: arsl...@arslist.org
 Subject: Re: {Remedy ARS} Re: Active Link External $PROCESS$ on AR Server 75

 Hi Conny,

 I did try removing the pre-set environment variables through my script
 one by one and it eventually I found the bad one and it worked.

 Thank you all for your efforts, the issue has been resolved!

 Best Regards,
 Koray

 On Apr 21, 8:56 pm, Conny Martin conny.mar...@t-systems.com wrote:
  Koray,

  to isolate the problem I would suggest the following.

  1. . ar_install_dir/bin/arsystem     don't forget the dot in front, so 
  you will have all the env-vars set by arsystem in your actual unix-shell
  2. try to start your script. It should abort with core dump
  3. unset ENV-VAR
  4. try to start your script
  5. unset NEXT-ENV-VAR
  6. try to start your script
  ...
  ...
  ...
  ...

  you should be able to find the env-var which is causing trouble and perhaps 
  this leads you to a solution.

  HTH

  Kind Regards Conny

  -Ursprüngliche Nachricht-
  Von: Action Request System discussion list(ARSList) 
  [mailto:arsl...@arslist.org] Im Auftrag von koray
  Gesendet: Mittwoch, 21. April 2010 15:57
  An: arsl...@arslist.org
  Betreff: Re: {Remedy ARS} Re: Active Link External $PROCESS$ on AR Server 
  7.5

  Update: FreeAREntryListFieldList causes this error, included with arfree.h 
  file..

  On Apr 21, 4:09 pm, koray ko...@alkankoray.net wrote:

   By the way, is there any way I can view the coredump file generated?

   On Apr 21, 3:47 pm, koray wrote:

A few of them were missing such as ARCONFIGDIR but although I tried
copying them from another server it didn't work again..
I did the server restart to see shell messages and it is exactly the
same : X Abort(coredump)

I am totally lost.

On Apr 21, 3:05 pm, Conny Martin conny.mar...@t-systems.com wrote:

 following env-vars are set by arsystem

 LANG
 TWO_TASK
 ARCONFIGDIR
 LC_ALL
 PATH
 ORACLE_HOME
 LD_LIBRARY_PATH
 ORA_NLS
 ORA_NLS32
 ORA_NLS33
 NLS_LANG
 NLSPATH
 CLIENT_LOCALE

 -Ursprüngliche Nachricht-
 Von: Action Request System discussion list(ARSList)
 [mailto:arsl...@arslist.org] Im Auftrag von koray
 Gesendet: Mittwoch, 21. April 2010 13:57
 An: arsl...@arslist.org
 Betreff: Re: {Remedy ARS} Re: Active Link External $PROCESS$ on AR
 Server 7.5

 Hello again,

 Can anyone send me the output of env command related to Remedy or 
 APIs?

 Best Regards,
 Koray

 On Apr 21, 12:24 pm, koray wrote:

  @Juan Ingles: The C script exits with 0 in any case.
  Trying above arsystem env mypath/script results with Abort -
  core dumped

  However the script isn't directly called in order to set the
  environment variables. mypath/script consists of

  #!/usr/bin/sh
  LD_LIBRARY_PATH=paths
  export LD_LIBRARY_PATH
  /mypath/the_c_script_itself $@

  @Conny: you are right, I doubt that this is really related to
  the environment variables.. But i am not sure how to overcome this..

  Best Regards,
  Koray

 ___ 
 
 UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
 attend wwrug10www.wwrug.comARSlist: Where the Answers Are

 ___ 
 
 UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
 attend wwrug10www.wwrug.comARSlist: Where the Answers Are

 --
 You received this message because you are subscribed to the Google Groups 
 Remedy ARS group.
 To post to this group, send email to arsl...@googlegroups.com.
 To unsubscribe from this group, send email to 
 arslist+unsubscr...@googlegroups.com.
 For more options, visit this group 
 athttp://groups.google.com/group/arslist?hl=en.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are

Re: {Remedy ARS} Re: Active Link External $PROCESS$ on AR Server 7.5

[koray]

@Juan Ingles: The C script exits with 0 in any case.
Trying above arsystem env mypath/script results with
Abort - core dumped

However the script isn't directly called in order to set the
environment variables. mypath/script consists of

#!/usr/bin/sh
LD_LIBRARY_PATH=paths
export LD_LIBRARY_PATH
/mypath/the_c_script_itself $@

@Conny: you are right, I doubt that this is really related to the
environment variables.. But i am not sure how to overcome this..

Best Regards,
Koray

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are

Re: {Remedy ARS} Re: Active Link External $PROCESS$ on AR Server 7.5

[koray]

Hello again,

Can anyone send me the output of env command related to Remedy or
APIs?

Best Regards,
Koray

On Apr 21, 12:24 pm, koray ko...@alkankoray.net wrote:
 @Juan Ingles: The C script exits with 0 in any case.
 Trying above arsystem env mypath/script results with
 Abort - core dumped

 However the script isn't directly called in order to set the
 environment variables. mypath/script consists of

 #!/usr/bin/sh
 LD_LIBRARY_PATH=paths
 export LD_LIBRARY_PATH
 /mypath/the_c_script_itself $@

 @Conny: you are right, I doubt that this is really related to the
 environment variables.. But i am not sure how to overcome this..

 Best Regards,
 Koray

 ___ 
 
 UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
 attend wwrug10www.wwrug.comARSlist: Where the Answers Are

 --
 You received this message because you are subscribed to the Google Groups 
 Remedy ARS group.
 To post to this group, send email to arsl...@googlegroups.com.
 To unsubscribe from this group, send email to 
 arslist+unsubscr...@googlegroups.com.
 For more options, visit this group 
 athttp://groups.google.com/group/arslist?hl=en.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are

Re: {Remedy ARS} Re: Active Link External $PROCESS$ on AR Server 7.5

[koray]

A few of them were missing such as ARCONFIGDIR but although I tried
copying them from another server it didn't work again..
I did the server restart to see shell messages and it is exactly the
same : X Abort(coredump)

I am totally lost.

On Apr 21, 3:05 pm, Conny Martin conny.mar...@t-systems.com wrote:
 following env-vars are set by arsystem

 LANG
 TWO_TASK
 ARCONFIGDIR
 LC_ALL
 PATH
 ORACLE_HOME
 LD_LIBRARY_PATH
 ORA_NLS
 ORA_NLS32
 ORA_NLS33
 NLS_LANG
 NLSPATH
 CLIENT_LOCALE

 -Ursprüngliche Nachricht-
 Von: Action Request System discussion list(ARSList) 
 [mailto:arsl...@arslist.org] Im Auftrag von koray
 Gesendet: Mittwoch, 21. April 2010 13:57
 An: arsl...@arslist.org
 Betreff: Re: {Remedy ARS} Re: Active Link External $PROCESS$ on AR Server 7.5

 Hello again,

 Can anyone send me the output of env command related to Remedy or APIs?

 Best Regards,
 Koray

 On Apr 21, 12:24 pm, koray ko...@alkankoray.net wrote:





  @Juan Ingles: The C script exits with 0 in any case.
  Trying above arsystem env mypath/script results with Abort - core
  dumped

  However the script isn't directly called in order to set the
  environment variables. mypath/script consists of

  #!/usr/bin/sh
  LD_LIBRARY_PATH=paths
  export LD_LIBRARY_PATH
  /mypath/the_c_script_itself $@

  @Conny: you are right, I doubt that this is really related to the
  environment variables.. But i am not sure how to overcome this..

  Best Regards,
  Koray

  __
  _  UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
  attend wwrug10www.wwrug.comARSlist:Where the Answers Are

  --
  You received this message because you are subscribed to the Google Groups 
  Remedy ARS group.
  To post to this group, send email to arsl...@googlegroups.com.
  To unsubscribe from this group, send email to 
  arslist+unsubscr...@googlegroups.com.
  For more options, visit this group 
  athttp://groups.google.com/group/arslist?hl=en.

 ___ 
 
 UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgattend 
 wwrug10www.wwrug.comARSlist: Where the Answers Are

 ___ 
 
 UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
 attend wwrug10www.wwrug.comARSlist: Where the Answers Are

 --
 You received this message because you are subscribed to the Google Groups 
 Remedy ARS group.
 To post to this group, send email to arsl...@googlegroups.com.
 To unsubscribe from this group, send email to 
 arslist+unsubscr...@googlegroups.com.
 For more options, visit this group 
 athttp://groups.google.com/group/arslist?hl=en.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are

Re: {Remedy ARS} Re: Active Link External $PROCESS$ on AR Server 7.5

[koray]

By the way, is there any way I can view the coredump file generated?

On Apr 21, 3:47 pm, koray ko...@alkankoray.net wrote:
 A few of them were missing such as ARCONFIGDIR but although I tried
 copying them from another server it didn't work again..
 I did the server restart to see shell messages and it is exactly the
 same : X Abort(coredump)

 I am totally lost.

 On Apr 21, 3:05 pm, Conny Martin conny.mar...@t-systems.com wrote:





  following env-vars are set by arsystem

  LANG
  TWO_TASK
  ARCONFIGDIR
  LC_ALL
  PATH
  ORACLE_HOME
  LD_LIBRARY_PATH
  ORA_NLS
  ORA_NLS32
  ORA_NLS33
  NLS_LANG
  NLSPATH
  CLIENT_LOCALE

  -Ursprüngliche Nachricht-
  Von: Action Request System discussion list(ARSList) 
  [mailto:arsl...@arslist.org] Im Auftrag von koray
  Gesendet: Mittwoch, 21. April 2010 13:57
  An: arsl...@arslist.org
  Betreff: Re: {Remedy ARS} Re: Active Link External $PROCESS$ on AR Server 
  7.5

  Hello again,

  Can anyone send me the output of env command related to Remedy or APIs?

  Best Regards,
  Koray

  On Apr 21, 12:24 pm, koray ko...@alkankoray.net wrote:

   @Juan Ingles: The C script exits with 0 in any case.
   Trying above arsystem env mypath/script results with Abort - core
   dumped

   However the script isn't directly called in order to set the
   environment variables. mypath/script consists of

   #!/usr/bin/sh
   LD_LIBRARY_PATH=paths
   export LD_LIBRARY_PATH
   /mypath/the_c_script_itself $@

   @Conny: you are right, I doubt that this is really related to the
   environment variables.. But i am not sure how to overcome this..

   Best Regards,
   Koray

   __
   _  UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
   attend wwrug10www.wwrug.comARSlist:Where the Answers Are

   --
   You received this message because you are subscribed to the Google Groups 
   Remedy ARS group.
   To post to this group, send email to arsl...@googlegroups.com.
   To unsubscribe from this group, send email to 
   arslist+unsubscr...@googlegroups.com.
   For more options, visit this group 
   athttp://groups.google.com/group/arslist?hl=en.

  ___ 
  
  UNSUBSCRIBE or access ARSlist Archives 
  atwww.arslist.orgattendwwrug10www.wwrug.comARSlist:Where the Answers Are

  ___ 
  
  UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
  attend wwrug10www.wwrug.comARSlist:Where the Answers Are

  --
  You received this message because you are subscribed to the Google Groups 
  Remedy ARS group.
  To post to this group, send email to arsl...@googlegroups.com.
  To unsubscribe from this group, send email to 
  arslist+unsubscr...@googlegroups.com.
  For more options, visit this group 
  athttp://groups.google.com/group/arslist?hl=en.

 ___ 
 
 UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
 attend wwrug10www.wwrug.comARSlist: Where the Answers Are

 --
 You received this message because you are subscribed to the Google Groups 
 Remedy ARS group.
 To post to this group, send email to arsl...@googlegroups.com.
 To unsubscribe from this group, send email to 
 arslist+unsubscr...@googlegroups.com.
 For more options, visit this group 
 athttp://groups.google.com/group/arslist?hl=en.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are

Re: {Remedy ARS} Re: Active Link External $PROCESS$ on AR Server 7.5

[koray]

Update: FreeAREntryListFieldList causes this error, included with
arfree.h file..

On Apr 21, 4:09 pm, koray ko...@alkankoray.net wrote:
 By the way, is there any way I can view the coredump file generated?

 On Apr 21, 3:47 pm, koray ko...@alkankoray.net wrote:





  A few of them were missing such as ARCONFIGDIR but although I tried
  copying them from another server it didn't work again..
  I did the server restart to see shell messages and it is exactly the
  same : X Abort(coredump)

  I am totally lost.

  On Apr 21, 3:05 pm, Conny Martin conny.mar...@t-systems.com wrote:

   following env-vars are set by arsystem

   LANG
   TWO_TASK
   ARCONFIGDIR
   LC_ALL
   PATH
   ORACLE_HOME
   LD_LIBRARY_PATH
   ORA_NLS
   ORA_NLS32
   ORA_NLS33
   NLS_LANG
   NLSPATH
   CLIENT_LOCALE

   -Ursprüngliche Nachricht-
   Von: Action Request System discussion list(ARSList) 
   [mailto:arsl...@arslist.org] Im Auftrag von koray
   Gesendet: Mittwoch, 21. April 2010 13:57
   An: arsl...@arslist.org
   Betreff: Re: {Remedy ARS} Re: Active Link External $PROCESS$ on AR Server 
   7.5

   Hello again,

   Can anyone send me the output of env command related to Remedy or APIs?

   Best Regards,
   Koray

   On Apr 21, 12:24 pm, koray ko...@alkankoray.net wrote:

@Juan Ingles: The C script exits with 0 in any case.
Trying above arsystem env mypath/script results with Abort - core
dumped

However the script isn't directly called in order to set the
environment variables. mypath/script consists of

#!/usr/bin/sh
LD_LIBRARY_PATH=paths
export LD_LIBRARY_PATH
/mypath/the_c_script_itself $@

@Conny: you are right, I doubt that this is really related to the
environment variables.. But i am not sure how to overcome this..

Best Regards,
Koray

__
_  UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
attend wwrug10www.wwrug.comARSlist:Where the Answers Are

--
You received this message because you are subscribed to the Google 
Groups Remedy ARS group.
To post to this group, send email to arsl...@googlegroups.com.
To unsubscribe from this group, send email to 
arslist+unsubscr...@googlegroups.com.
For more options, visit this group 
athttp://groups.google.com/group/arslist?hl=en.

   ___

   UNSUBSCRIBE or access ARSlist Archives 
   atwww.arslist.orgattendwwrug10www.wwrug.comARSlist:Where the Answers Are

   ___

   UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
   attend wwrug10www.wwrug.comARSlist:Where the Answers Are

   --
   You received this message because you are subscribed to the Google Groups 
   Remedy ARS group.
   To post to this group, send email to arsl...@googlegroups.com.
   To unsubscribe from this group, send email to 
   arslist+unsubscr...@googlegroups.com.
   For more options, visit this group 
   athttp://groups.google.com/group/arslist?hl=en.

  ___ 
  
  UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
  attend wwrug10www.wwrug.comARSlist:Where the Answers Are

  --
  You received this message because you are subscribed to the Google Groups 
  Remedy ARS group.
  To post to this group, send email to arsl...@googlegroups.com.
  To unsubscribe from this group, send email to 
  arslist+unsubscr...@googlegroups.com.
  For more options, visit this group 
  athttp://groups.google.com/group/arslist?hl=en.

 ___ 
 
 UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
 attend wwrug10www.wwrug.comARSlist: Where the Answers Are

 --
 You received this message because you are subscribed to the Google Groups 
 Remedy ARS group.
 To post to this group, send email to arsl...@googlegroups.com.
 To unsubscribe from this group, send email to 
 arslist+unsubscr...@googlegroups.com.
 For more options, visit this group 
 athttp://groups.google.com/group/arslist?hl=en.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are

Re: {Remedy ARS} Re: Active Link External $PROCESS$ on AR Server 7.5

[Alkan, Koray]

Hi Conny,

I did try removing the pre-set environment variables through my script
one by one and it eventually I found the bad one and it worked.

Thank you all for your efforts, the issue has been resolved!

Best Regards,
Koray

On Apr 21, 8:56 pm, Conny Martin conny.mar...@t-systems.com wrote:
 Koray,

 to isolate the problem I would suggest the following.

 1. . ar_install_dir/bin/arsystem     don't forget the dot in front, so you 
 will have all the env-vars set by arsystem in your actual unix-shell
 2. try to start your script. It should abort with core dump
 3. unset ENV-VAR
 4. try to start your script
 5. unset NEXT-ENV-VAR
 6. try to start your script
 ...
 ...
 ...
 ...

 you should be able to find the env-var which is causing trouble and perhaps 
 this leads you to a solution.

 HTH

 Kind Regards Conny

 -Ursprüngliche Nachricht-
 Von: Action Request System discussion list(ARSList) 
 [mailto:arsl...@arslist.org] Im Auftrag von koray
 Gesendet: Mittwoch, 21. April 2010 15:57
 An: arsl...@arslist.org
 Betreff: Re: {Remedy ARS} Re: Active Link External $PROCESS$ on AR Server 7.5

 Update: FreeAREntryListFieldList causes this error, included with arfree.h 
 file..

 On Apr 21, 4:09 pm, koray ko...@alkankoray.net wrote:





  By the way, is there any way I can view the coredump file generated?

  On Apr 21, 3:47 pm, koray ko...@alkankoray.net wrote:

   A few of them were missing such as ARCONFIGDIR but although I tried
   copying them from another server it didn't work again..
   I did the server restart to see shell messages and it is exactly the
   same : X Abort(coredump)

   I am totally lost.

   On Apr 21, 3:05 pm, Conny Martin conny.mar...@t-systems.com wrote:

following env-vars are set by arsystem

LANG
TWO_TASK
ARCONFIGDIR
LC_ALL
PATH
ORACLE_HOME
LD_LIBRARY_PATH
ORA_NLS
ORA_NLS32
ORA_NLS33
NLS_LANG
NLSPATH
CLIENT_LOCALE

-Ursprüngliche Nachricht-
Von: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] Im Auftrag von koray
Gesendet: Mittwoch, 21. April 2010 13:57
An: arsl...@arslist.org
Betreff: Re: {Remedy ARS} Re: Active Link External $PROCESS$ on AR
Server 7.5

Hello again,

Can anyone send me the output of env command related to Remedy or 
APIs?

Best Regards,
Koray

On Apr 21, 12:24 pm, koray ko...@alkankoray.net wrote:

 @Juan Ingles: The C script exits with 0 in any case.
 Trying above arsystem env mypath/script results with Abort -
 core dumped

 However the script isn't directly called in order to set the
 environment variables. mypath/script consists of

 #!/usr/bin/sh
 LD_LIBRARY_PATH=paths
 export LD_LIBRARY_PATH
 /mypath/the_c_script_itself $@

 @Conny: you are right, I doubt that this is really related to
 the environment variables.. But i am not sure how to overcome this..

 Best Regards,
 Koray

 
 __ _  UNSUBSCRIBE or access ARSlist Archives
 atwww.arslist.orgattend wwrug10www.wwrug.comARSlist:Where the
 Answers Are

 --
 You received this message because you are subscribed to the Google 
 Groups Remedy ARS group.
 To post to this group, send email to arsl...@googlegroups.com.
 To unsubscribe from this group, send email to 
 arslist+unsubscr...@googlegroups.com.
 For more options, visit this group 
 athttp://groups.google.com/group/arslist?hl=en.

__
_  UNSUBSCRIBE or access ARSlist Archives 
atwww.arslist.orgattendwwrug10www.wwrug.comARSlist:Where the Answers 
Are

__
_  UNSUBSCRIBE or access ARSlist Archives
atwww.arslist.orgattend wwrug10www.wwrug.comARSlist:Where the Answers 
Are

--
You received this message because you are subscribed to the Google 
Groups Remedy ARS group.
To post to this group, send email to arsl...@googlegroups.com.
To unsubscribe from this group, send email to 
arslist+unsubscr...@googlegroups.com.
For more options, visit this group 
athttp://groups.google.com/group/arslist?hl=en.

   
   ___  UNSUBSCRIBE or access ARSlist Archives
   atwww.arslist.orgattend wwrug10www.wwrug.comARSlist:Where the Answers 
   Are

   --
   You received this message because you are subscribed to the Google Groups 
   Remedy ARS group.
   To post to this group, send email to arsl...@googlegroups.com.
   To unsubscribe from this group, send email to 
   arslist+unsubscr...@googlegroups.com.
   For more options, visit this group 
   athttp://groups.google.com/group/arslist?hl=en

Active Link External $PROCESS$ on AR Server 7.5

[koray]

Hello together,

I have upgraded my ARS servers from 6.3 to 7.5 and facing with some
major problems since then.
The previous syntax to run an external process via an Active Link was

$PROCESS$ @@: /mypath/script -p1 parameter1 -p2 parameter2

and it worked perfect. But since the 7.5 upgrade I have been receiving
errors:

ACTL - Passed qualification -- perform if actions
ACTL  0: Set Fields

ACTL Process: /mypath/script -p1 parameter1 -p2
parameter2
ACTL  Error while performing active link action

Do you have any idea? What am I doing wrong here?
I even tried double-quoting the parameters but nothing seems to work.

Also removing : character from active link results with no error but
returns null.

Thanks in advance!
Koray

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are

Re: {Remedy ARS} Re: Active Link External $PROCESS$ on AR Server 7.5

[koray]

Script's working quite perfect. I tried copyingpasting /mypath/
script -p1 parameter1 -p2 parameter2 to UNIX shell and it returns as
expected. So it can't be the syntax.

On Apr 20, 7:21 pm, Frank Caruso caruso.fr...@gmail.com wrote:
 Is the problem with the syntax or with what /mypath/script is doing?





 On Tue, Apr 20, 2010 at 7:18 PM, koray ko...@alkankoray.net wrote:
  Hello together,

  I have upgraded my ARS servers from 6.3 to 7.5 and facing with some
  major problems since then.
  The previous syntax to run an external process via an Active Link was

  $PROCESS$ @@: /mypath/script -p1 parameter1 -p2 parameter2

  and it worked perfect. But since the 7.5 upgrade I have been receiving
  errors:

  ACTL     - Passed qualification -- perform if actions
  ACTL          0: Set Fields

  ACTL             Process: /mypath/script -p1 parameter1 -p2
  parameter2
  ACTL      Error while performing active link action

  Do you have any idea? What am I doing wrong here?
  I even tried double-quoting the parameters but nothing seems to work.

  Also removing : character from active link results with no error but
  returns null.

  Thanks in advance!
  Koray

  ___ 
  
  UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
  attend wwrug10www.wwrug.comARSlist: Where the Answers Are

 ___ 
 
 UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
 attend wwrug10www.wwrug.comARSlist: Where the Answers Are

 --
 You received this message because you are subscribed to the Google Groups 
 Remedy ARS group.
 To post to this group, send email to arsl...@googlegroups.com.
 To unsubscribe from this group, send email to 
 arslist+unsubscr...@googlegroups.com.
 For more options, visit this group 
 athttp://groups.google.com/group/arslist?hl=en.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are

Re: {Remedy ARS} Re: Active Link External $PROCESS$ on AR Server 7.5

[koray]

Hello Conny,

I activated arfork-log and here is the output:

arforkd version 7.5.00 PatchTue Apr 20 18:46:00 2010 Arforkd: Opening
log file in overwrite mode.
Tue Apr 20 18:46:00 2010 Awaiting record marker.
Tue Apr 20 18:46:04 2010 Received record marker.
Tue Apr 20 18:46:04 2010 Spawning child, shell , command /mypath/
script -p1 parameter1 -p2 parameter2.
Tue Apr 20 18:46:04 2010 Spawned /mypath/script -p1 parameter1 -p2
parameter2 as pid 886.
Tue Apr 20 18:46:04 2010 Awaiting record marker.
Tue Apr 20 18:46:06 2010 process id 886 has exited with status 0x86.
Tue Apr 20 18:46:14 2010 Received record marker.

@process id 886 has exited with status 0x86: Can you help me on what
0x86 status is?
@arserverd restart: How can I see the stdout messages related while
the restart?

Best Regards,
Koray

On Apr 20, 7:32 pm, Conny Martin conny.mar...@t-systems.com wrote:
 Koray,

 acivate arfork-log. If you don't see anything in arfork.log restart arserverd 
 in your Unix-shell to see stdout/stderr.

 HTH

 Kind Regards Conny

 -Ursprüngliche Nachricht-
 Von: Action Request System discussion list(ARSList) 
 [mailto:arsl...@arslist.org] Im Auftrag von koray
 Gesendet: Dienstag, 20. April 2010 18:29
 An: arsl...@arslist.org
 Betreff: Re: {Remedy ARS} Re: Active Link External $PROCESS$ on AR Server 7.5

 Script's working quite perfect. I tried copyingpasting /mypath/ script -p1 
 parameter1 -p2 parameter2 to UNIX shell and it returns as expected. So it 
 can't be the syntax.

 On Apr 20, 7:21 pm, Frank Caruso caruso.fr...@gmail.com wrote:





  Is the problem with the syntax or with what /mypath/script is doing?

  On Tue, Apr 20, 2010 at 7:18 PM, koray ko...@alkankoray.net wrote:
   Hello together,

   I have upgraded my ARS servers from 6.3 to 7.5 and facing with some
   major problems since then.
   The previous syntax to run an external process via an Active Link
   was

   $PROCESS$ @@: /mypath/script -p1 parameter1 -p2 parameter2

   and it worked perfect. But since the 7.5 upgrade I have been
   receiving
   errors:

   ACTL     - Passed qualification -- perform if actions ACTL          
   0: Set Fields

   ACTL             Process: /mypath/script -p1 parameter1 -p2
   parameter2
   ACTL      Error while performing active link action

   Do you have any idea? What am I doing wrong here?
   I even tried double-quoting the parameters but nothing seems to work.

   Also removing : character from active link results with no error
   but returns null.

   Thanks in advance!
   Koray

   
   ___  UNSUBSCRIBE or access ARSlist Archives
   atwww.arslist.orgattend wwrug10www.wwrug.comARSlist:Where the Answers 
   Are

  __
  _  UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
  attend wwrug10www.wwrug.comARSlist:Where the Answers Are

  --
  You received this message because you are subscribed to the Google Groups 
  Remedy ARS group.
  To post to this group, send email to arsl...@googlegroups.com.
  To unsubscribe from this group, send email to 
  arslist+unsubscr...@googlegroups.com.
  For more options, visit this group 
  athttp://groups.google.com/group/arslist?hl=en.

 ___ 
 
 UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgattend 
 wwrug10www.wwrug.comARSlist: Where the Answers Are

 ___ 
 
 UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
 attend wwrug10www.wwrug.comARSlist: Where the Answers Are

 --
 You received this message because you are subscribed to the Google Groups 
 Remedy ARS group.
 To post to this group, send email to arsl...@googlegroups.com.
 To unsubscribe from this group, send email to 
 arslist+unsubscr...@googlegroups.com.
 For more options, visit this group 
 athttp://groups.google.com/group/arslist?hl=en.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are

Re: {Remedy ARS} Re: Active Link External $PROCESS$ on AR Server 7.5

[koray]

Conny, thank you.
I will try and find a suitable timeframe for a restart and share the
results.

Best Regards,
Koray

On Apr 20, 7:58 pm, Conny Martin conny.mar...@t-systems.com wrote:
 Koray,

 when you restart arserverd in your shell and then execute the AL with run 
 process you will perhaps see some helpful error-messages.

 I think it's something related to the environment (ENV-Vars like 
 LD_LIBRARY_PATH or something like that).

 To execute your script with the same env. as arserverd do the following.

 /ar_install_dir/bin/arsystem env /mypath/script -p1 parameter1 -p2 
 parameter2

 Kind Regards Conny

 -Ursprüngliche Nachricht-
 Von: Action Request System discussion list(ARSList) 
 [mailto:arsl...@arslist.org] Im Auftrag von koray
 Gesendet: Dienstag, 20. April 2010 18:54
 An: arsl...@arslist.org
 Betreff: Re: {Remedy ARS} Re: Active Link External $PROCESS$ on AR Server 7.5

 Hello Conny,

 I activated arfork-log and here is the output:

 arforkd version 7.5.00 PatchTue Apr 20 18:46:00 2010 Arforkd: Opening log 
 file in overwrite mode.
 Tue Apr 20 18:46:00 2010 Awaiting record marker.
 Tue Apr 20 18:46:04 2010 Received record marker.
 Tue Apr 20 18:46:04 2010 Spawning child, shell , command /mypath/ script 
 -p1 parameter1 -p2 parameter2.
 Tue Apr 20 18:46:04 2010 Spawned /mypath/script -p1 parameter1 -p2 
 parameter2 as pid 886.
 Tue Apr 20 18:46:04 2010 Awaiting record marker.
 Tue Apr 20 18:46:06 2010 process id 886 has exited with status 0x86.
 Tue Apr 20 18:46:14 2010 Received record marker.

 @process id 886 has exited with status 0x86: Can you help me on what
 0x86 status is?
 @arserverd restart: How can I see the stdout messages related while the 
 restart?

 Best Regards,
 Koray

 On Apr 20, 7:32 pm, Conny Martin conny.mar...@t-systems.com wrote:





  Koray,

  acivate arfork-log. If you don't see anything in arfork.log restart 
  arserverd in your Unix-shell to see stdout/stderr.

  HTH

  Kind Regards Conny

  -Ursprüngliche Nachricht-
  Von: Action Request System discussion list(ARSList)
  [mailto:arsl...@arslist.org] Im Auftrag von koray
  Gesendet: Dienstag, 20. April 2010 18:29
  An: arsl...@arslist.org
  Betreff: Re: {Remedy ARS} Re: Active Link External $PROCESS$ on AR
  Server 7.5

  Script's working quite perfect. I tried copyingpasting /mypath/ script 
  -p1 parameter1 -p2 parameter2 to UNIX shell and it returns as expected. So 
  it can't be the syntax.

  On Apr 20, 7:21 pm, Frank Caruso caruso.fr...@gmail.com wrote:

   Is the problem with the syntax or with what /mypath/script is doing?

   On Tue, Apr 20, 2010 at 7:18 PM, koray ko...@alkankoray.net wrote:
Hello together,

I have upgraded my ARS servers from 6.3 to 7.5 and facing with
some major problems since then.
The previous syntax to run an external process via an Active Link
was

$PROCESS$ @@: /mypath/script -p1 parameter1 -p2 parameter2

and it worked perfect. But since the 7.5 upgrade I have been
receiving
errors:

ACTL     - Passed qualification -- perform if actions ACTL
0: Set Fields

ACTL             Process: /mypath/script -p1 parameter1 -p2
parameter2
ACTL      Error while performing active link action

Do you have any idea? What am I doing wrong here?
I even tried double-quoting the parameters but nothing seems to work.

Also removing : character from active link results with no error
but returns null.

Thanks in advance!
Koray

__
__ ___  UNSUBSCRIBE or access ARSlist Archives
atwww.arslist.orgattendwwrug10www.wwrug.comARSlist:Where the Answers 
Are

   
   __ _  UNSUBSCRIBE or access ARSlist Archives
   atwww.arslist.orgattend wwrug10www.wwrug.comARSlist:Where the
   Answers Are

   --
   You received this message because you are subscribed to the Google Groups 
   Remedy ARS group.
   To post to this group, send email to arsl...@googlegroups.com.
   To unsubscribe from this group, send email to 
   arslist+unsubscr...@googlegroups.com.
   For more options, visit this group 
   athttp://groups.google.com/group/arslist?hl=en.

  __
  _  UNSUBSCRIBE or access ARSlist Archives 
  atwww.arslist.orgattendwwrug10www.wwrug.comARSlist:Where the Answers Are

  __
  _  UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
  attend wwrug10www.wwrug.comARSlist:Where the Answers Are

  --
  You received this message because you are subscribed to the Google Groups 
  Remedy ARS group.
  To post to this group, send email to arsl...@googlegroups.com.
  To unsubscribe from this group, send email to 
  arslist+unsubscr...@googlegroups.com.
  For more options, visit this group 
  athttp://groups.google.com

Re: {Remedy ARS} Re: Active Link External $PROCESS$ on AR Server 7.5

[koray]

Hi Fred,

Removing the space after the colon was exactly the same thing I did
after starting to receive errors. I also used the exit(0) line :-)
I have no idea why it fails, the only way left seems a restart as
Conny said, i think.

Koray

On Apr 20, 8:20 pm, Grooms, Frederick W frederick.w.gro...@xo.com
wrote:
 I may be picky here but when I do an external $PROCESS$ from an AL I don't 
 put a space after the colon
   $PROCESS$ @@:/mypath/script -p1 parameter1 -p2 parameter2

 The 0x86 is what the script is exiting with as a status.  On scripts I don't 
 want to return an error to Remedy I exit them with an   exit 0  line.

 Fred



 -Original Message-
 From: Action Request System discussion list(ARSList) 
 [mailto:arsl...@arslist.org] On Behalf Of koray
 Sent: Tuesday, April 20, 2010 11:54 AM
 To: arsl...@arslist.org
 Subject: Re: {Remedy ARS} Re: Active Link External $PROCESS$ on AR Server 7.5

 Hello Conny,

 I activated arfork-log and here is the output:

 arforkd version 7.5.00 PatchTue Apr 20 18:46:00 2010 Arforkd: Opening
 log file in overwrite mode.
 Tue Apr 20 18:46:00 2010 Awaiting record marker.
 Tue Apr 20 18:46:04 2010 Received record marker.
 Tue Apr 20 18:46:04 2010 Spawning child, shell , command /mypath/
 script -p1 parameter1 -p2 parameter2.
 Tue Apr 20 18:46:04 2010 Spawned /mypath/script -p1 parameter1 -p2
 parameter2 as pid 886.
 Tue Apr 20 18:46:04 2010 Awaiting record marker.
 Tue Apr 20 18:46:06 2010 process id 886 has exited with status 0x86.
 Tue Apr 20 18:46:14 2010 Received record marker.

 @process id 886 has exited with status 0x86: Can you help me on what
 0x86 status is?
 @arserverd restart: How can I see the stdout messages related while
 the restart?

 Best Regards,
 Koray

 On Apr 20, 7:32 pm, Conny Martin conny.mar...@t-systems.com wrote:
  Koray,

  acivate arfork-log. If you don't see anything in arfork.log restart 
  arserverd in your Unix-shell to see stdout/stderr.

  HTH

  Kind Regards Conny

  -Ursprüngliche Nachricht-
  Von: Action Request System discussion list(ARSList) 
  [mailto:arsl...@arslist.org] Im Auftrag von koray
  Gesendet: Dienstag, 20. April 2010 18:29
  An: arsl...@arslist.org
  Betreff: Re: {Remedy ARS} Re: Active Link External $PROCESS$ on AR Server 
  7.5

  Script's working quite perfect. I tried copyingpasting /mypath/ script 
  -p1 parameter1 -p2 parameter2 to UNIX shell and it returns as expected. So 
  it can't be the syntax.

  On Apr 20, 7:21 pm, Frank Caruso caruso.fr...@gmail.com wrote:

   Is the problem with the syntax or with what /mypath/script is doing?

   On Tue, Apr 20, 2010 at 7:18 PM, koray ko...@alkankoray.net wrote:
Hello together,

I have upgraded my ARS servers from 6.3 to 7.5 and facing with some
major problems since then.
The previous syntax to run an external process via an Active Link
was

$PROCESS$ @@: /mypath/script -p1 parameter1 -p2 parameter2

and it worked perfect. But since the 7.5 upgrade I have been
receiving
errors:

ACTL     - Passed qualification -- perform if actions ACTL         
 
0: Set Fields

ACTL             Process: /mypath/script -p1 parameter1 -p2
parameter2
ACTL      Error while performing active link action

Do you have any idea? What am I doing wrong here?
I even tried double-quoting the parameters but nothing seems to work.

Also removing : character from active link results with no error
but returns null.

Thanks in advance!
Koray


___  UNSUBSCRIBE or access ARSlist Archives
atwww.arslist.orgattendwwrug10www.wwrug.comARSlist:Where the Answers 
Are

   __
   _  UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
   attend wwrug10www.wwrug.comARSlist:Where the Answers Are

   --
   You received this message because you are subscribed to the Google Groups 
   Remedy ARS group.
   To post to this group, send email to arsl...@googlegroups.com.
   To unsubscribe from this group, send email to 
   arslist+unsubscr...@googlegroups.com.
   For more options, visit this group 
   athttp://groups.google.com/group/arslist?hl=en.

  ___ 
  
  UNSUBSCRIBE or access ARSlist Archives 
  atwww.arslist.orgattendwwrug10www.wwrug.comARSlist:Where the Answers Are

  ___ 
  
  UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
  attend wwrug10www.wwrug.comARSlist:Where the Answers Are

  --
  You received this message because you are subscribed to the Google Groups 
  Remedy ARS group.
  To post to this group, send email to arsl...@googlegroups.com.
  To unsubscribe from this group, send email to 
  arslist+unsubscr...@googlegroups.com.
  For more options, visit this group 
  athttp

Re: Qualification EXTERNAL() Issue - Returns Nothing

[koray]

- Issue solved by moving form to a different server.

On Sep 7, 1:36 pm, koray ko...@alkankoray.net wrote:
 I just came across a FAIL statement in log file when I enter a
 qualification in char field :

 API  TID: ** RPC ID: 00 Queue: List      
 Client-RPC: **    USER: **                         /* Mon
 Sep 07 2009 12:31:24.0244 */+EXECAL ARExecuteProcessForActiveLink from
 Remedy User (protocol 11) at IP address ***.**.**.***

 API  TID: ** RPC ID: 00* Queue: List      
 Client-RPC: **    USER: **                         /* Mon
 Sep 07 2009 12:31:24.0247 */-EXECAL           FAIL

 While the char field is empty and the table is updated these 2 lines
 does not occur.

 Koray.

 On Sep 7, 10:26 am, koray ko...@alkankoray.net wrote:





  I tried both manually typing the qualification in the character field
  and putting it into a workflow, with correct syntax of double quotes.

  Neither using the Field ID or the database name of the Task ID field
  works correct.

  To sum up what exactly the problem is;

  - For a number of forms, EXTERNAL() function does work perfect where
  for FormX entering the qualification string with EXTERNAL() gives an
  output of SELECT ... FROM ... WHERE (1 = 0) even if I enter the
  qualification as 1=1.
  - Entering qualification string(s) manually into Table Properties
  window returns valid results, including 'Task ID' = TSK011
  - For workflow, results are the same.

  So,
  - Qualification strings I am using must be valid, both on EXTERNAL()
  and Table Properties.
  - I have also tried using Task ID field's Field ID, but no luck.

  Koray.

  On Sep 7, 4:51 am, Grooms, Frederick W frederick.w.gro...@xo.com
  wrote:

   I believe Shafqat is talking about when you build a set fields action to 
   populate your qualification field through workflow. If you are manually 
   entering into that field you will not double up the double quotes.

   Just to make sure things are clear...  You have a form (FormA) that has a 
   table field on it.  That table field is displaying data from FormX.  You 
   have a display only character field (zTempQualX) on FormA to hold the 
   external qualification for the table.

   If you just type into zTempQualX you can type  'Task ID' = TSK01  
   To build that string in workflow you would use   'Task ID' =  + 
   $SomeFieldOnFormA$ +   

   For your problem... Are you sure that the field on FormX is 'Task ID' ?  
   Try using the Field ID of the field on FormX   '1' = TSK01  

   I have seen problems where the field name does not always work, but using 
   the ID should.

   Fred

   -Original Message-
   From: Action Request System discussion list(ARSList) 
   [mailto:arsl...@arslist.org] On Behalf Of koray
   Sent: Saturday, September 05, 2009 11:49 AM
   To: arsl...@arslist.org
   Subject: Re: Qualification EXTERNAL() Issue - Returns Nothing

   Dear Shafqat,

   That issue does not seem to be because of a syntax error since I have
   indicated previously for some other forms EXTERNAL() command works
   perfect.

   It feels like it should have something to do with the properties of
   the form or the fields that I am trying to qualify from.

   Regards,

   Koray.

   On Sep 5, 4:09 am, Shafqat Ayaz shafq...@yahoo.com wrote:
Koray
if you are entering the qualification as 'Task ID' = TSK01 in an 
external qual it will not work, you need to put the double quotes 
within two double quotes so the 'TSK01' needs to be something like 
  TSK01   .
I have put spaces to show you the double quotes, you need to remove the 
spaces.
make your char field visible and then have a look at what the 
qualification looks like and you will what is wrong. you can enter the 
qual as you have shown in the EXTERNAL qualification field and just 
right click on the table and refresh it, it will show the correct data, 
but if you do a Set Fields then you have to triple the double quotes.
Let me know if this fixes your problem or you need further help.
 
thanks
 
shafqat ayaz

--- On Fri, 9/4/09, koray ko...@alkankoray.net wrote:

From: koray ko...@alkankoray.net
Subject: Re: Qualification EXTERNAL() Issue - Returns Nothing
To: arsl...@arslist.org
Date: Friday, September 4, 2009, 1:50 PM

Qualification I am using is something basic like 'Task ID' =
TSK01 just to test it.

Weird thing is that when I enter the qualification string manually on
Table Properties it works perfect, but not via the character field.

On Sep 4, 3:37 pm, Mark Lev mark@rightstarsystems.com wrote:

 Can you post what the char string is that you're using when it 
 doesn't work?  You have to build it out to include formatting.

 As for the 1=1 when you're leaving blank, it is probably building 
 that to show all, as it likely needs to put in something.  I don't 
 see that as anything

Re: Qualification EXTERNAL() Issue - Returns Nothing

[koray]

I tried both manually typing the qualification in the character field
and putting it into a workflow, with correct syntax of double quotes.

Neither using the Field ID or the database name of the Task ID field
works correct.

To sum up what exactly the problem is;

- For a number of forms, EXTERNAL() function does work perfect where
for FormX entering the qualification string with EXTERNAL() gives an
output of SELECT ... FROM ... WHERE (1 = 0) even if I enter the
qualification as 1=1.
- Entering qualification string(s) manually into Table Properties
window returns valid results, including 'Task ID' = TSK011
- For workflow, results are the same.

So,
- Qualification strings I am using must be valid, both on EXTERNAL()
and Table Properties.
- I have also tried using Task ID field's Field ID, but no luck.

Koray.

On Sep 7, 4:51 am, Grooms, Frederick W frederick.w.gro...@xo.com
wrote:
 I believe Shafqat is talking about when you build a set fields action to 
 populate your qualification field through workflow. If you are manually 
 entering into that field you will not double up the double quotes.

 Just to make sure things are clear...  You have a form (FormA) that has a 
 table field on it.  That table field is displaying data from FormX.  You have 
 a display only character field (zTempQualX) on FormA to hold the external 
 qualification for the table.

 If you just type into zTempQualX you can type  'Task ID' = TSK01  
 To build that string in workflow you would use   'Task ID' =  + 
 $SomeFieldOnFormA$ +   

 For your problem... Are you sure that the field on FormX is 'Task ID' ?  
 Try using the Field ID of the field on FormX   '1' = TSK01  

 I have seen problems where the field name does not always work, but using the 
 ID should.

 Fred



 -Original Message-
 From: Action Request System discussion list(ARSList) 
 [mailto:arsl...@arslist.org] On Behalf Of koray
 Sent: Saturday, September 05, 2009 11:49 AM
 To: arsl...@arslist.org
 Subject: Re: Qualification EXTERNAL() Issue - Returns Nothing

 Dear Shafqat,

 That issue does not seem to be because of a syntax error since I have
 indicated previously for some other forms EXTERNAL() command works
 perfect.

 It feels like it should have something to do with the properties of
 the form or the fields that I am trying to qualify from.

 Regards,

 Koray.

 On Sep 5, 4:09 am, Shafqat Ayaz shafq...@yahoo.com wrote:
  Koray
  if you are entering the qualification as 'Task ID' = TSK01 in an 
  external qual it will not work, you need to put the double quotes within 
  two double quotes so the 'TSK01' needs to be something like   
  TSK01   .
  I have put spaces to show you the double quotes, you need to remove the 
  spaces.
  make your char field visible and then have a look at what the qualification 
  looks like and you will what is wrong. you can enter the qual as you have 
  shown in the EXTERNAL qualification field and just right click on the table 
  and refresh it, it will show the correct data, but if you do a Set Fields 
  then you have to triple the double quotes.
  Let me know if this fixes your problem or you need further help.
   
  thanks
   
  shafqat ayaz

  --- On Fri, 9/4/09, koray ko...@alkankoray.net wrote:

  From: koray ko...@alkankoray.net
  Subject: Re: Qualification EXTERNAL() Issue - Returns Nothing
  To: arsl...@arslist.org
  Date: Friday, September 4, 2009, 1:50 PM

  Qualification I am using is something basic like 'Task ID' =
  TSK01 just to test it.

  Weird thing is that when I enter the qualification string manually on
  Table Properties it works perfect, but not via the character field.

  On Sep 4, 3:37 pm, Mark Lev mark@rightstarsystems.com wrote:

   Can you post what the char string is that you're using when it doesn't 
   work?  You have to build it out to include formatting.

   As for the 1=1 when you're leaving blank, it is probably building that to 
   show all, as it likely needs to put in something.  I don't see that as 
   anything to worry about.

   Thanks,
   Mark
    

   -Original Message-
   From: Action Request System discussion list(ARSList) 
   [mailto:arsl...@arslist.org] On Behalf Of koray
   Sent: Friday, September 04, 2009 8:31 AM
   To: arsl...@arslist.org
   Subject: Re: Qualification EXTERNAL() Issue - Returns Nothing

   Update on situation:

   When the qualification string is empty log files reads

   SELECT (..) FROM (...) WHERE (1 = 1) ORDER BY 6 ASC

   and lists all the data, as i had mentioned previously.

   On Sep 4, 3:13 pm, koray ko...@alkankoray.net wrote:
Dear List,

I again have an issue but this seems a bit meaningless to me.

I have a table on my form retrieving data from X form with every
fields of it added as columns.

I also created a Character Field and set the table's Qualification to
that char field as External().
When I refresh the table without any qualification - in other words
when

Re: Qualification EXTERNAL() Issue - Returns Nothing

[koray]

I just came across a FAIL statement in log file when I enter a
qualification in char field :

API  TID: ** RPC ID: 00 Queue: List  
Client-RPC: **USER: ** /* Mon
Sep 07 2009 12:31:24.0244 */+EXECAL ARExecuteProcessForActiveLink from
Remedy User (protocol 11) at IP address ***.**.**.***

API  TID: ** RPC ID: 00* Queue: List  
Client-RPC: **USER: ** /* Mon
Sep 07 2009 12:31:24.0247 */-EXECAL   FAIL

While the char field is empty and the table is updated these 2 lines
does not occur.

Koray.

On Sep 7, 10:26 am, koray ko...@alkankoray.net wrote:
 I tried both manually typing the qualification in the character field
 and putting it into a workflow, with correct syntax of double quotes.

 Neither using the Field ID or the database name of the Task ID field
 works correct.

 To sum up what exactly the problem is;

 - For a number of forms, EXTERNAL() function does work perfect where
 for FormX entering the qualification string with EXTERNAL() gives an
 output of SELECT ... FROM ... WHERE (1 = 0) even if I enter the
 qualification as 1=1.
 - Entering qualification string(s) manually into Table Properties
 window returns valid results, including 'Task ID' = TSK011
 - For workflow, results are the same.

 So,
 - Qualification strings I am using must be valid, both on EXTERNAL()
 and Table Properties.
 - I have also tried using Task ID field's Field ID, but no luck.

 Koray.

 On Sep 7, 4:51 am, Grooms, Frederick W frederick.w.gro...@xo.com
 wrote:





  I believe Shafqat is talking about when you build a set fields action to 
  populate your qualification field through workflow. If you are manually 
  entering into that field you will not double up the double quotes.

  Just to make sure things are clear...  You have a form (FormA) that has a 
  table field on it.  That table field is displaying data from FormX.  You 
  have a display only character field (zTempQualX) on FormA to hold the 
  external qualification for the table.

  If you just type into zTempQualX you can type  'Task ID' = TSK01  
  To build that string in workflow you would use   'Task ID' =  + 
  $SomeFieldOnFormA$ +   

  For your problem... Are you sure that the field on FormX is 'Task ID' ?  
  Try using the Field ID of the field on FormX   '1' = TSK01  

  I have seen problems where the field name does not always work, but using 
  the ID should.

  Fred

  -Original Message-
  From: Action Request System discussion list(ARSList) 
  [mailto:arsl...@arslist.org] On Behalf Of koray
  Sent: Saturday, September 05, 2009 11:49 AM
  To: arsl...@arslist.org
  Subject: Re: Qualification EXTERNAL() Issue - Returns Nothing

  Dear Shafqat,

  That issue does not seem to be because of a syntax error since I have
  indicated previously for some other forms EXTERNAL() command works
  perfect.

  It feels like it should have something to do with the properties of
  the form or the fields that I am trying to qualify from.

  Regards,

  Koray.

  On Sep 5, 4:09 am, Shafqat Ayaz shafq...@yahoo.com wrote:
   Koray
   if you are entering the qualification as 'Task ID' = TSK01 in an 
   external qual it will not work, you need to put the double quotes within 
   two double quotes so the 'TSK01' needs to be something like   
   TSK01   .
   I have put spaces to show you the double quotes, you need to remove the 
   spaces.
   make your char field visible and then have a look at what the 
   qualification looks like and you will what is wrong. you can enter the 
   qual as you have shown in the EXTERNAL qualification field and just right 
   click on the table and refresh it, it will show the correct data, but if 
   you do a Set Fields then you have to triple the double quotes.
   Let me know if this fixes your problem or you need further help.
    
   thanks
    
   shafqat ayaz

   --- On Fri, 9/4/09, koray ko...@alkankoray.net wrote:

   From: koray ko...@alkankoray.net
   Subject: Re: Qualification EXTERNAL() Issue - Returns Nothing
   To: arsl...@arslist.org
   Date: Friday, September 4, 2009, 1:50 PM

   Qualification I am using is something basic like 'Task ID' =
   TSK01 just to test it.

   Weird thing is that when I enter the qualification string manually on
   Table Properties it works perfect, but not via the character field.

   On Sep 4, 3:37 pm, Mark Lev mark@rightstarsystems.com wrote:

Can you post what the char string is that you're using when it doesn't 
work?  You have to build it out to include formatting.

As for the 1=1 when you're leaving blank, it is probably building that 
to show all, as it likely needs to put in something.  I don't see that 
as anything to worry about.

Thanks,
Mark
 

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of koray
Sent: Friday

Re: Qualification EXTERNAL() Issue - Returns Nothing

[koray]

Dear Shafqat,

That issue does not seem to be because of a syntax error since I have
indicated previously for some other forms EXTERNAL() command works
perfect.

It feels like it should have something to do with the properties of
the form or the fields that I am trying to qualify from.

Regards,

Koray.


On Sep 5, 4:09 am, Shafqat Ayaz shafq...@yahoo.com wrote:
 Koray
 if you are entering the qualification as 'Task ID' = TSK01 in an 
 external qual it will not work, you need to put the double quotes within two 
 double quotes so the 'TSK01' needs to be something like   TSK01  
  .
 I have put spaces to show you the double quotes, you need to remove the 
 spaces.
 make your char field visible and then have a look at what the qualification 
 looks like and you will what is wrong. you can enter the qual as you have 
 shown in the EXTERNAL qualification field and just right click on the table 
 and refresh it, it will show the correct data, but if you do a Set Fields 
 then you have to triple the double quotes.
 Let me know if this fixes your problem or you need further help.
  
 thanks
  
 shafqat ayaz

 --- On Fri, 9/4/09, koray ko...@alkankoray.net wrote:

 From: koray ko...@alkankoray.net
 Subject: Re: Qualification EXTERNAL() Issue - Returns Nothing
 To: arsl...@arslist.org
 Date: Friday, September 4, 2009, 1:50 PM

 Qualification I am using is something basic like 'Task ID' =
 TSK01 just to test it.

 Weird thing is that when I enter the qualification string manually on
 Table Properties it works perfect, but not via the character field.

 On Sep 4, 3:37 pm, Mark Lev mark@rightstarsystems.com wrote:





  Can you post what the char string is that you're using when it doesn't 
  work?  You have to build it out to include formatting.

  As for the 1=1 when you're leaving blank, it is probably building that to 
  show all, as it likely needs to put in something.  I don't see that as 
  anything to worry about.

  Thanks,
  Mark
   

  -Original Message-
  From: Action Request System discussion list(ARSList) 
  [mailto:arsl...@arslist.org] On Behalf Of koray
  Sent: Friday, September 04, 2009 8:31 AM
  To: arsl...@arslist.org
  Subject: Re: Qualification EXTERNAL() Issue - Returns Nothing

  Update on situation:

  When the qualification string is empty log files reads

  SELECT (..) FROM (...) WHERE (1 = 1) ORDER BY 6 ASC

  and lists all the data, as i had mentioned previously.

  On Sep 4, 3:13 pm, koray ko...@alkankoray.net wrote:
   Dear List,

   I again have an issue but this seems a bit meaningless to me.

   I have a table on my form retrieving data from X form with every
   fields of it added as columns.

   I also created a Character Field and set the table's Qualification to
   that char field as External().
   When I refresh the table without any qualification - in other words
   when the char field is empty - table lists all the data.

   But, when I enter a valid qualification string in the char field, I
   get nothing. Log file shows like

   SELECT (..) FROM (...) WHERE (1 = 0) ORDER BY 6 ASC

   1) where does 1=0 come from? Isn't it meaningless?
   2) Although I have not set any Order option from Table Properties
   ORDER BY 6 ASC occurs.

   Any ideas?

   Regards,

   Koray.

   ___

   UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
   Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are

  ___ 
  
  UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
  Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are

  ___ 
  
  UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
  Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are

 ___ 
 
 UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
 Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are

 ___ 
 
 UNSUBSCRIBE or access ARSlist Archives atwww.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

Qualification EXTERNAL() Issue - Returns Nothing

[koray]

Dear List,

I again have an issue but this seems a bit meaningless to me.

I have a table on my form retrieving data from X form with every
fields of it added as columns.

I also created a Character Field and set the table's Qualification to
that char field as External().
When I refresh the table without any qualification - in other words
when the char field is empty - table lists all the data.

But, when I enter a valid qualification string in the char field, I
get nothing. Log file shows like

SELECT (..) FROM (...) WHERE (1 = 0) ORDER BY 6 ASC

1) where does 1=0 come from? Isn't it meaningless?
2) Although I have not set any Order option from Table Properties
ORDER BY 6 ASC occurs.

Any ideas?

Regards,

Koray.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are

Re: Qualification EXTERNAL() Issue - Returns Nothing

[koray]

Update on situation:

When the qualification string is empty log files reads

SELECT (..) FROM (...) WHERE (1 = 1) ORDER BY 6 ASC

and lists all the data, as i had mentioned previously.

On Sep 4, 3:13 pm, koray ko...@alkankoray.net wrote:
 Dear List,

 I again have an issue but this seems a bit meaningless to me.

 I have a table on my form retrieving data from X form with every
 fields of it added as columns.

 I also created a Character Field and set the table's Qualification to
 that char field as External().
 When I refresh the table without any qualification - in other words
 when the char field is empty - table lists all the data.

 But, when I enter a valid qualification string in the char field, I
 get nothing. Log file shows like

 SELECT (..) FROM (...) WHERE (1 = 0) ORDER BY 6 ASC

 1) where does 1=0 come from? Isn't it meaningless?
 2) Although I have not set any Order option from Table Properties
 ORDER BY 6 ASC occurs.

 Any ideas?

 Regards,

 Koray.

 ___ 
 
 UNSUBSCRIBE or access ARSlist Archives atwww.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: Qualification EXTERNAL() Issue - Returns Nothing

[koray]

Qualification I am using is something basic like 'Task ID' =
TSK01 just to test it.

Weird thing is that when I enter the qualification string manually on
Table Properties it works perfect, but not via the character field.

On Sep 4, 3:37 pm, Mark Lev mark@rightstarsystems.com wrote:
 Can you post what the char string is that you're using when it doesn't work?  
 You have to build it out to include formatting.

 As for the 1=1 when you're leaving blank, it is probably building that to 
 show all, as it likely needs to put in something.  I don't see that as 
 anything to worry about.

 Thanks,
 Mark
  



 -Original Message-
 From: Action Request System discussion list(ARSList) 
 [mailto:arsl...@arslist.org] On Behalf Of koray
 Sent: Friday, September 04, 2009 8:31 AM
 To: arsl...@arslist.org
 Subject: Re: Qualification EXTERNAL() Issue - Returns Nothing

 Update on situation:

 When the qualification string is empty log files reads

 SELECT (..) FROM (...) WHERE (1 = 1) ORDER BY 6 ASC

 and lists all the data, as i had mentioned previously.

 On Sep 4, 3:13 pm, koray ko...@alkankoray.net wrote:
  Dear List,

  I again have an issue but this seems a bit meaningless to me.

  I have a table on my form retrieving data from X form with every
  fields of it added as columns.

  I also created a Character Field and set the table's Qualification to
  that char field as External().
  When I refresh the table without any qualification - in other words
  when the char field is empty - table lists all the data.

  But, when I enter a valid qualification string in the char field, I
  get nothing. Log file shows like

  SELECT (..) FROM (...) WHERE (1 = 0) ORDER BY 6 ASC

  1) where does 1=0 come from? Isn't it meaningless?
  2) Although I have not set any Order option from Table Properties
  ORDER BY 6 ASC occurs.

  Any ideas?

  Regards,

  Koray.

  ___ 
  
  UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
  Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are

 ___ 
 
 UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
 Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are

 ___ 
 
 UNSUBSCRIBE or access ARSlist Archives atwww.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: Qualification EXTERNAL() Issue - Returns Nothing

[koray]

Situation Update 2:
EXTERNAL() works on SOME other forms correctly with form 'Task ID' =
TSK1. I have double-checked every field's database name and
there should be no error.

Could there be any other, what i am going to call, weird reason?

Regards,

Koray.

On Sep 4, 4:36 pm, Mark Lev mark@rightstarsystems.com wrote:
 You need to build the string literally.

 String = 'Task ID' =  +  + TSK1 + 

 I may be slightly off on syntax of embedding a double quote, that may take a 
 little tweaking.  What I do is make the char string visible and editable, so 
 I can see what is being populated, and can manually tweak it to figure out 
 what is right.  If you're embedding a variable, i.e. $USER$, you may need to 
 put a \ in front of the var name $\USER$ so it isn't interpreted when 
 compiled.  Again, you will need to tweak to get it exactly right.

 Thanks,
 Mark
  



 -Original Message-
 From: Action Request System discussion list(ARSList) 
 [mailto:arsl...@arslist.org] On Behalf Of koray
 Sent: Friday, September 04, 2009 8:51 AM
 To: arsl...@arslist.org
 Subject: Re: Qualification EXTERNAL() Issue - Returns Nothing

 Qualification I am using is something basic like 'Task ID' =
 TSK01 just to test it.

 Weird thing is that when I enter the qualification string manually on
 Table Properties it works perfect, but not via the character field.

 On Sep 4, 3:37 pm, Mark Lev mark@rightstarsystems.com wrote:
  Can you post what the char string is that you're using when it doesn't 
  work?  You have to build it out to include formatting.

  As for the 1=1 when you're leaving blank, it is probably building that to 
  show all, as it likely needs to put in something.  I don't see that as 
  anything to worry about.

  Thanks,
  Mark
   

  -Original Message-
  From: Action Request System discussion list(ARSList) 
  [mailto:arsl...@arslist.org] On Behalf Of koray
  Sent: Friday, September 04, 2009 8:31 AM
  To: arsl...@arslist.org
  Subject: Re: Qualification EXTERNAL() Issue - Returns Nothing

  Update on situation:

  When the qualification string is empty log files reads

  SELECT (..) FROM (...) WHERE (1 = 1) ORDER BY 6 ASC

  and lists all the data, as i had mentioned previously.

  On Sep 4, 3:13 pm, koray ko...@alkankoray.net wrote:
   Dear List,

   I again have an issue but this seems a bit meaningless to me.

   I have a table on my form retrieving data from X form with every
   fields of it added as columns.

   I also created a Character Field and set the table's Qualification to
   that char field as External().
   When I refresh the table without any qualification - in other words
   when the char field is empty - table lists all the data.

   But, when I enter a valid qualification string in the char field, I
   get nothing. Log file shows like

   SELECT (..) FROM (...) WHERE (1 = 0) ORDER BY 6 ASC

   1) where does 1=0 come from? Isn't it meaningless?
   2) Although I have not set any Order option from Table Properties
   ORDER BY 6 ASC occurs.

   Any ideas?

   Regards,

   Koray.

   ___

   UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
   Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are

  ___ 
  
  UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
  Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are

  ___ 
  
  UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
  Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are

 ___ 
 
 UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
 Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are

 ___ 
 
 UNSUBSCRIBE or access ARSlist Archives atwww.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: Qualification EXTERNAL() Issue - Returns Nothing

[koray]

Seems like certain forms do not accept ANY External Qualifications.
Even setting 1=1 in Character Field for External Qualification gives

SELECT (..) FROM (...) WHERE (1 = 0) ORDER BY 6 ASC

in log file and returns nothing.



On Sep 4, 5:26 pm, koray ko...@alkankoray.net wrote:
 Situation Update 2:
 EXTERNAL() works on SOME other forms correctly with form 'Task ID' =
 TSK1. I have double-checked every field's database name and
 there should be no error.

 Could there be any other, what i am going to call, weird reason?

 Regards,

 Koray.

 On Sep 4, 4:36 pm, Mark Lev mark@rightstarsystems.com wrote:





  You need to build the string literally.

  String = 'Task ID' =  +  + TSK1 + 

  I may be slightly off on syntax of embedding a double quote, that may take 
  a little tweaking.  What I do is make the char string visible and editable, 
  so I can see what is being populated, and can manually tweak it to figure 
  out what is right.  If you're embedding a variable, i.e. $USER$, you may 
  need to put a \ in front of the var name $\USER$ so it isn't interpreted 
  when compiled.  Again, you will need to tweak to get it exactly right.

  Thanks,
  Mark
   

  -Original Message-
  From: Action Request System discussion list(ARSList) 
  [mailto:arsl...@arslist.org] On Behalf Of koray
  Sent: Friday, September 04, 2009 8:51 AM
  To: arsl...@arslist.org
  Subject: Re: Qualification EXTERNAL() Issue - Returns Nothing

  Qualification I am using is something basic like 'Task ID' =
  TSK01 just to test it.

  Weird thing is that when I enter the qualification string manually on
  Table Properties it works perfect, but not via the character field.

  On Sep 4, 3:37 pm, Mark Lev mark@rightstarsystems.com wrote:
   Can you post what the char string is that you're using when it doesn't 
   work?  You have to build it out to include formatting.

   As for the 1=1 when you're leaving blank, it is probably building that to 
   show all, as it likely needs to put in something.  I don't see that as 
   anything to worry about.

   Thanks,
   Mark
    

   -Original Message-
   From: Action Request System discussion list(ARSList) 
   [mailto:arsl...@arslist.org] On Behalf Of koray
   Sent: Friday, September 04, 2009 8:31 AM
   To: arsl...@arslist.org
   Subject: Re: Qualification EXTERNAL() Issue - Returns Nothing

   Update on situation:

   When the qualification string is empty log files reads

   SELECT (..) FROM (...) WHERE (1 = 1) ORDER BY 6 ASC

   and lists all the data, as i had mentioned previously.

   On Sep 4, 3:13 pm, koray ko...@alkankoray.net wrote:
Dear List,

I again have an issue but this seems a bit meaningless to me.

I have a table on my form retrieving data from X form with every
fields of it added as columns.

I also created a Character Field and set the table's Qualification to
that char field as External().
When I refresh the table without any qualification - in other words
when the char field is empty - table lists all the data.

But, when I enter a valid qualification string in the char field, I
get nothing. Log file shows like

SELECT (..) FROM (...) WHERE (1 = 0) ORDER BY 6 ASC

1) where does 1=0 come from? Isn't it meaningless?
2) Although I have not set any Order option from Table Properties
ORDER BY 6 ASC occurs.

Any ideas?

Regards,

Koray.

___
 
UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers 
Are

   ___

   UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
   Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are

   ___

   UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
   Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are

  ___ 
  
  UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
  Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are

  ___ 
  
  UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
  Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are

 ___ 
 
 UNSUBSCRIBE or access ARSlist Archives atwww.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: Windows Dialog Box for filename?

[koray]

Dear David Sanders,

That is exactly what I was looking for and it works perfect.

Thank you all for your time!

Regards,

Koray.

On Sep 2, 6:39 pm, David Sanders
david.sand...@westoverconsulting.co.uk wrote:
 Hi Koray

 Here is a sample dialog form that uses OLE to get a file name and path - of
 course, this will only work in the User tool, not the Mid-Tier

 HTH

 David Sanders
 Remedy Solution Architect
 Enterprise Service Suite @ Work
 ==

 tel +44 1494 468980
 mobile +44 7710 377761
 email david.sand...@westoverconsulting.co.uk

 webhttp://www.westoverconsulting.co.uk



 -Original Message-
 From: Action Request System discussion list(ARSList)

 [mailto:arsl...@arslist.org] On Behalf Of koray
 Sent: Wednesday, September 02, 2009 2:52 PM
 To: arsl...@arslist.org
 Subject: Windows Dialog Box for filename?

 I really needed that property..

 Well then, can I show a Windows Dialog Box to the user to locate for
 example a file and write the selected file's path and filename to a
 character field?

 Koray.

 On Sep 2, 4:23 pm, LJ Longwing lj.longw...@gmail.com wrote:
  Nope, other than upgrading to 7.1

  -Original Message-
  From: Action Request System discussion list(ARSList)

  [mailto:arsl...@arslist.org] On Behalf Of koray
  Sent: Wednesday, September 02, 2009 6:19 AM
  To: arsl...@arslist.org
  Subject: Right-click context menu for tables?

  Dear List,

  Is there any way to add right-click (contextual menu) items for a table in
  6.3?

  Regards,

  Koray.

 ___
 _
  ___
  UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgPlatinum
  Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are

 ___
 
  UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
  Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are

 ___ _
 ___
 UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
 Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are

 ___ 
 
 UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
 Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are



  xxGetFile.def
 4KViewDownload

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are

Re: Table Coloring W/O a Selection Field

[koray]

As a result, I had to edit SQL Views in order to add a new column and
set its value using CASE - THEN - ELSE method .
Works perfect!

Thank you all, issue solved!

Koray.

On Aug 31, 7:11 pm, Grooms, Frederick W frederick.w.gro...@xo.com
wrote:
 Actually I have had to add color to a View form with a db View.  In the db I 
 added an integer field I called DISPLAY_COLOR and put a Remedy selection 
 field against it.

 Depending on your database you can also add extra fields in a View of the db 
 Table so the table does not change.  In oracle you can use the DECODE or CASE 
 type statements to do this.

 Fred



 -Original Message-
 From: Action Request System discussion list(ARSList) 
 [mailto:arsl...@arslist.org] On Behalf Of koray
 Sent: Monday, August 31, 2009 10:00 AM
 To: arsl...@arslist.org
 Subject: Re: Table Coloring W/O a Selection Field

 I am creating Views in SQL and View Forms in Admin, populating the
 main form via these two. Therefore my circumstance is a bit more
 complicated that I can not add any type of extra fields and implement
 it that way.

 Otherwise, yes a hidden field would have saved my hours of research on
 this issue :)

 Koray.

 On Aug 31, 5:38 pm, Easter, David david_eas...@bmc.com wrote:
    Is there a particular reason you do not wish to use a selection field to 
  contain the enum for the color?  Hopefully you know that you could make the 
  field hidden and populated by workflow - it does not have to be a visible 
  field or a value selected by an end user.

  -David J. Easter
  Sr. Product Manager, Solution Strategy and Development
  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.

  -Original Message-
  From: Action Request System discussion list(ARSList) 
  [mailto:arsl...@arslist.org] On Behalf Of Carey Matthew Black
  Sent: Monday, August 31, 2009 6:39 AM
  To: arsl...@arslist.org
  Subject: Re: Table Coloring W/O a Selection Field

  Alkan,

  I noted that your post did not include what ARS version your using.
  That information may have been helpful to understand your full options.

  So... You do not want to use the feature that is built into the system
  to do the task that you are trying to do. But you still want to do the
  task.

  So How about any of the following alternatives?

  If you only want this to work on the Mid-Tier you could:

  Mid-Tier ONLY) Write some custom javascript that you trigger any time
  the form is refreshed (good luck trapping all of those cases, so there
  is more custom javascript needed for that) that would alter the CSS
  for the rows.

  Mid-Tier ONLY2) You could use a column that is a display only,
  HTML-ReadOnly column and change the color of that cell, or put a
  colored image in the cell, in the row by using Active Links to loop
  over the table and set the correct HTML into the column.

  But if you need this to work in the User Tool then you really need to
  use the feature as it is designed to work. ( Which should also work
  for the Mid-Tier client too. :)

  I guess there are other approaches you could take...

  Submit a UI enhancement request to BMC and wait (years?) to maybe see
  the second way to implement this feature show up in the product.

  Oh.. how about this idea... This could work

  You could create your own ARS client from the ground up. That would
  let you do all kinds of things in your UI. If it helps you would not
  be the first customer to do it. However it is no small task to achieve
  so that you can implement table field row colors based on something
  other than a selection field value from the table row.  (Note: The UI
  enhancement request might be faster (and cheaper) than this option.)

  Ok... I think I am totally out of ideas on this one...

  Anyone else know of a better way to skin this cat?

  HTH.

  --
  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 Mon, Aug 31, 2009 at 8:06 AM, Alkan, Korayko...@alkankoray.net wrote:
   **
   Dear List,

   I am looking for a way to color table rows according to the values of
   that table's specific row without using a dropdown list or a radio
   field.

   Regards,

   Alkan, Koray
   webhttp://www.alkankoray.net
   mobile (0090) 555 204 9218
   e-mail ko...@alkankoray.net

 ___ 
 
 UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
 Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are

___
UNSUBSCRIBE

Right-click context menu for tables?

[koray]

Dear List,

Is there any way to add right-click (contextual menu) items for a
table in 6.3?

Regards,

Koray.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are

Windows Dialog Box for filename?

[koray]

I really needed that property..

Well then, can I show a Windows Dialog Box to the user to locate for
example a file and write the selected file's path and filename to a
character field?

Koray.

On Sep 2, 4:23 pm, LJ Longwing lj.longw...@gmail.com wrote:
 Nope, other than upgrading to 7.1



 -Original Message-
 From: Action Request System discussion list(ARSList)

 [mailto:arsl...@arslist.org] On Behalf Of koray
 Sent: Wednesday, September 02, 2009 6:19 AM
 To: arsl...@arslist.org
 Subject: Right-click context menu for tables?

 Dear List,

 Is there any way to add right-click (contextual menu) items for a table in
 6.3?

 Regards,

 Koray.

 ___ _
 ___
 UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgPlatinum
 Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are

 ___ 
 
 UNSUBSCRIBE or access ARSlist Archives atwww.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: Windows Dialog Box for filename?

[koray]

Sorry, my bad, I just could not explain.

I am working on an export form and I'd like user to choose a folder
and a filename for the backup file to be created.
Not to input a previously created file.

Updating MidTier to 7.1 does not seem to be possible for the time, so
I will use buttons instead of right-click menus.

On Sep 2, 5:09 pm, LJ Longwing lj.longw...@gmail.com wrote:
 You can certainly do that.  If you set an attachment field to a char field,
 the value you get is the combined path and file name that the file was saved
 from.  If the attachment was added via the web, then all you get is the
 filename, but you certainly have that ability.

 On a separate note, it's possible to run a 7.1 MidTier against a 6.3 Remedy
 server if I'm not mistakenso if you wanted to upgrade your web, but not
 your server it's a possibility.



 -Original Message-
 From: Action Request System discussion list(ARSList)

 [mailto:arsl...@arslist.org] On Behalf Of koray
 Sent: Wednesday, September 02, 2009 7:52 AM
 To: arsl...@arslist.org
 Subject: Windows Dialog Box for filename?

 I really needed that property..

 Well then, can I show a Windows Dialog Box to the user to locate for example
 a file and write the selected file's path and filename to a character field?

 Koray.

 On Sep 2, 4:23 pm, LJ Longwing lj.longw...@gmail.com wrote:
  Nope, other than upgrading to 7.1

  -Original Message-
  From: Action Request System discussion list(ARSList)

  [mailto:arsl...@arslist.org] On Behalf Of koray
  Sent: Wednesday, September 02, 2009 6:19 AM
  To: arsl...@arslist.org
  Subject: Right-click context menu for tables?

  Dear List,

  Is there any way to add right-click (contextual menu) items for a
  table in 6.3?

  Regards,

  Koray.

  __
  _ _ ___ UNSUBSCRIBE or access ARSlist Archives
  atwww.arslist.orgPlatinumSponsor:rmisoluti...@verizon.net ARSlist:
  Where the Answers Are

  __
  _  UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
  Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are

 ___ _
 ___
 UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgPlatinum
 Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are

 ___ 
 
 UNSUBSCRIBE or access ARSlist Archives atwww.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

Table Coloring W/O a Selection Field

[Alkan, Koray]

Dear List,

I am looking for a way to color table rows according to the values of
that table's specific row without using a dropdown list or a radio
field.

Regards,

Alkan, Koray
web http://www.alkankoray.net
mobile (0090) 555 204 9218
e-mail ko...@alkankoray.net


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are

Re: Table Coloring W/O a Selection Field

[koray]

Well I'm using 6.3 and I'd like it done on User, not on mid-tier.

Hope someone knows how to do it although I feel a bit out of luck
today..


On Aug 31, 4:38 pm, Carey Matthew Black black@gmail.com wrote:
 Alkan,

 I noted that your post did not include what ARS version your using.
 That information may have been helpful to understand your full options.

 So... You do not want to use the feature that is built into the system
 to do the task that you are trying to do. But you still want to do the
 task.

 So How about any of the following alternatives?

 If you only want this to work on the Mid-Tier you could:

 Mid-Tier ONLY) Write some custom javascript that you trigger any time
 the form is refreshed (good luck trapping all of those cases, so there
 is more custom javascript needed for that) that would alter the CSS
 for the rows.

 Mid-Tier ONLY2) You could use a column that is a display only,
 HTML-ReadOnly column and change the color of that cell, or put a
 colored image in the cell, in the row by using Active Links to loop
 over the table and set the correct HTML into the column.

 But if you need this to work in the User Tool then you really need to
 use the feature as it is designed to work. ( Which should also work
 for the Mid-Tier client too. :)

 I guess there are other approaches you could take...

 Submit a UI enhancement request to BMC and wait (years?) to maybe see
 the second way to implement this feature show up in the product.

 Oh.. how about this idea... This could work

 You could create your own ARS client from the ground up. That would
 let you do all kinds of things in your UI. If it helps you would not
 be the first customer to do it. However it is no small task to achieve
 so that you can implement table field row colors based on something
 other than a selection field value from the table row.  (Note: The UI
 enhancement request might be faster (and cheaper) than this option.)

 Ok... I think I am totally out of ideas on this one...

 Anyone else know of a better way to skin this cat?

 HTH.

 --
 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 Mon, Aug 31, 2009 at 8:06 AM, Alkan, Korayko...@alkankoray.net wrote:
  **
  Dear List,

  I am looking for a way to color table rows according to the values of
  that table's specific row without using a dropdown list or a radio
  field.

  Regards,

  Alkan, Koray
  web http://www.alkankoray.net
  mobile (0090) 555 204 9218
  e-mail ko...@alkankoray.net

 ___ 
 
 UNSUBSCRIBE or access ARSlist Archives atwww.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: Table Coloring W/O a Selection Field

[koray]

I am creating Views in SQL and View Forms in Admin, populating the
main form via these two. Therefore my circumstance is a bit more
complicated that I can not add any type of extra fields and implement
it that way.

Otherwise, yes a hidden field would have saved my hours of research on
this issue :)

Koray.

On Aug 31, 5:38 pm, Easter, David david_eas...@bmc.com wrote:
   Is there a particular reason you do not wish to use a selection field to 
 contain the enum for the color?  Hopefully you know that you could make the 
 field hidden and populated by workflow - it does not have to be a visible 
 field or a value selected by an end user.

 -David J. Easter
 Sr. Product Manager, Solution Strategy and Development
 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.



 -Original Message-
 From: Action Request System discussion list(ARSList) 
 [mailto:arsl...@arslist.org] On Behalf Of Carey Matthew Black
 Sent: Monday, August 31, 2009 6:39 AM
 To: arsl...@arslist.org
 Subject: Re: Table Coloring W/O a Selection Field

 Alkan,

 I noted that your post did not include what ARS version your using.
 That information may have been helpful to understand your full options.

 So... You do not want to use the feature that is built into the system
 to do the task that you are trying to do. But you still want to do the
 task.

 So How about any of the following alternatives?

 If you only want this to work on the Mid-Tier you could:

 Mid-Tier ONLY) Write some custom javascript that you trigger any time
 the form is refreshed (good luck trapping all of those cases, so there
 is more custom javascript needed for that) that would alter the CSS
 for the rows.

 Mid-Tier ONLY2) You could use a column that is a display only,
 HTML-ReadOnly column and change the color of that cell, or put a
 colored image in the cell, in the row by using Active Links to loop
 over the table and set the correct HTML into the column.

 But if you need this to work in the User Tool then you really need to
 use the feature as it is designed to work. ( Which should also work
 for the Mid-Tier client too. :)

 I guess there are other approaches you could take...

 Submit a UI enhancement request to BMC and wait (years?) to maybe see
 the second way to implement this feature show up in the product.

 Oh.. how about this idea... This could work

 You could create your own ARS client from the ground up. That would
 let you do all kinds of things in your UI. If it helps you would not
 be the first customer to do it. However it is no small task to achieve
 so that you can implement table field row colors based on something
 other than a selection field value from the table row.  (Note: The UI
 enhancement request might be faster (and cheaper) than this option.)

 Ok... I think I am totally out of ideas on this one...

 Anyone else know of a better way to skin this cat?

 HTH.

 --
 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 Mon, Aug 31, 2009 at 8:06 AM, Alkan, Korayko...@alkankoray.net wrote:
  **
  Dear List,

  I am looking for a way to color table rows according to the values of
  that table's specific row without using a dropdown list or a radio
  field.

  Regards,

  Alkan, Koray
  web http://www.alkankoray.net
  mobile (0090) 555 204 9218
  e-mail ko...@alkankoray.net

 ___ 
 
 UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
 Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are

 ___ 
 
 UNSUBSCRIBE or access ARSlist Archives atwww.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