Re: ARInside error

2014-11-14 Thread John Kenny
Hey Rick:

 

Sounds more like an issue with the join than with ARInside. Have you tried 
opening the join form in Dev Studio and search for the field on the join. 

 

Ciao

 

John

 

 

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Phillips
Sent: November-14-14 6:04 PM
To: arslist@ARSLIST.ORG
Subject: ARInside error

 

** 

Has anyone seen this error with ARInside ARInside-3.1.2.662-win32?  I'm running 
it for the first time.

Schema: OBO:PeopleUserOuterJoin -- Failed to load field 100949: [ARERR 91] 
RPC call failed
  RPC: Can't decode result


Thanks,

Rick

_ARSlist: Where the Answers Are and have been for 20 years_ 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years


AIE Data Issue: Primary Key failure

2013-07-31 Thread John Kenny
Hello All:

We are running AIE 7.5 and have discovered a bug with AIE in regards to how it 
handles building the Primary Key. We run an import of data in CSV file daily 
and have been seeing that some of the data records are not getting loaded into 
Remedy. What we discovered was if any of the data in any column that is used to 
build the Primary Key has the pattern  AND  such as Name = JOHN KENNY AND 
SONS, AIE fails to build the Primary Key and AIE aborts its attempt to create 
a record in Remedy.  Remove the  AND  and the record imports fine. It appears 
that when AIE goes to build the Primary Key and sees  AND  in the data it 
treats as the AND operator. In our case simply removing any reference to  
AND  from the data prior to AIE import is not an option.

Has anyone experienced this issue and if so, is there a fix or workaround you 
can share.

Thanx in advance

John

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years


Run Process producess empty data file

2010-05-25 Thread John Kenny
Hello All:

ARS: 7.1 P4
Platform: Windows 2003 Server

I'm running into an issue where I am running a script that adds data to a 
csv file. I'm using the SED command (for windows, GNUWin32) to perform the 
substitution. 

Basically what this script does is append a column header and Request ID 
to the data file using SED and then imports the data file:

START:
cd /d %9

sed s/$/,%1/g %~7  tempfile.csv

sed 1s/%1/IMPORTID/ tempfile.csv  %~7

%2 -u %3 -p %4 -m %5 -d %6 -l %~8\%~7.log -o %~9\%~7 -x server name

Del tempfile.csv

END:

Where %1 is the Request ID and %7 is the file name. ARS is installed on 
the D drive whereas the data file is pushed to the C drive. When run thru 
a Run Process action, the tempfile.csv created in the first sed command 
ends up empty and therefore the original file (%7) also ends up empty. But 
if I run the command from the commandline it works fine. Just not thru 
Remedy. I even ran a test of pushing the data file to the D drive (D:\AR 
System) and running sed from there but same result.

Added the following to the script after the cd /d %9 command:

copy %7 importdatafile.csv

The copy command works fine and does copy the file and its contents fine 
thru Remedy's Run Process so it is not a delay issue of the data file 
being transferred.

Has anyone ever run into this type of behaviour before. Any assistance 
would be greatly appreciated. Thanx in advance

Have a great day

ciao

john

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


Re: Run Process produces empty data file

2010-05-25 Thread John Kenny
Hello Max:

The remedy system is running under local account. I don't think it is a 
permissions problem as I added the following command to the script to see if 
can see the file and copy it:

Copy %7 importfile.csv

It worked file when run thru Remedy.

Ciao

John

John Kenny | Manager, Solutions Architect | Burntsand Inc. | O: 416-234-3837 | 
M: 416-992-9913 | jke...@burntsand.com


-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Murnane, Phil
Sent: May-25-10 2:11 PM
To: arslist@ARSLIST.ORG
Subject: Re: Run Process produces empty data file

John:

When you ran your successful test from the command line, did you login to 
windows with the same ID that AR System runs under?  If not, you may be seeing 
a permissions issue.

Just a Thought,
--Phil

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of John Kenny
Sent: Tuesday, May 25, 2010 14:59
To: arslist@ARSLIST.ORG
Subject: Run Process producess empty data file

Hello All:

ARS: 7.1 P4
Platform: Windows 2003 Server

I'm running into an issue where I am running a script that adds data to a 
csv file. I'm using the SED command (for windows, GNUWin32) to perform the 
substitution. 

Basically what this script does is append a column header and Request ID 
to the data file using SED and then imports the data file:

START:
cd /d %9

sed s/$/,%1/g %~7  tempfile.csv

sed 1s/%1/IMPORTID/ tempfile.csv  %~7

%2 -u %3 -p %4 -m %5 -d %6 -l %~8\%~7.log -o %~9\%~7 -x server name

Del tempfile.csv

END:

Where %1 is the Request ID and %7 is the file name. ARS is installed on 
the D drive whereas the data file is pushed to the C drive. When run thru 
a Run Process action, the tempfile.csv created in the first sed command 
ends up empty and therefore the original file (%7) also ends up empty. But 
if I run the command from the commandline it works fine. Just not thru 
Remedy. I even ran a test of pushing the data file to the D drive (D:\AR 
System) and running sed from there but same result.

Added the following to the script after the cd /d %9 command:

copy %7 importdatafile.csv

The copy command works fine and does copy the file and its contents fine 
thru Remedy's Run Process so it is not a delay issue of the data file 
being transferred.

Has anyone ever run into this type of behaviour before. Any assistance 
would be greatly appreciated. Thanx in advance

Have a great day

ciao

john

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

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

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


Run Processes are failing to execute batch files from Filter Run Process

2010-05-18 Thread John Kenny
We are trying to implement a custom solution that involves the execution 
of a script (batch file) from a filter Run Process.

Workflow logging shows the command being executed with no error. However 
when checking on the results of the script running no action has taken 
place. It is as if the script was not actually run though from Remedy's 
perspective it has. I've run tests on both the development server and QA 
server with the same result.

Note: this behaviour is with all batch files that we've attempted to run. 
A simple test that we tried involved a regular form (core fields only), a 
filter to fire on submit to perform a run process that executes a batch 
file. The batch file simply copies a file. Workflow log shows it being 
executed without error but no file copied. Copy and paste the command from 
the workflow log in to a command window and it runs fine.

I get the same behaviour with Active Link Run Processes. Running 
arimportcmd.exe thru a Run Process works fine it just appears that running 
batch files does not

I'm running a VM image that is pretty much identical to this customer's 
development server and the execution of batch files is fine.

This customer is running ARS Server 7.1 Patch 4 with a SQL server 2005 on 
Win Server 2003

It feels like an environment issue rathe than a Remedy issue. Any suggests 
as to what to look for it would be greatly appreciated.

Have a great day

ciao

john

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


Re: Run Processes are failing to execute batch files from Filter Run Process

2010-05-18 Thread John Kenny
Hello LJ:

Thanx for responding. Here is the command for the simple copy test

``C:\TEMP\BulkImport-G14b\Testing\testarsrunprocess.bat``

Here is the script:

cd C:\TEMP\BulkImport-G14b\Testing

copy SOMTest1.csv SOMTest2.csv

I tried using Cmd c/ but same result. The script appears to be executed 
according to the log file but still no file is copied. Same with all of 
the other batch file tests I've run.

If you run the script from the commandline manually it works fine. 

ciao

john

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


Re: Direct URL firing workflow

2007-05-17 Thread John Kenny
Have you tried creating an active link that fires on window open of the
RR:SurveyResponseDialog form to perform a Change field action that
refreshes the table in ?

 

John Kenny
Burntsand Inc.
Manager, Solutions Architect
Office:  416-234-3837
Cell: 416-992-9913
Email:  [EMAIL PROTECTED]
Web site: www.burntsand.com



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Suwanski, Ron
Sent: Thursday, May 17, 2007 10:39 AM
To: arslist@ARSLIST.ORG
Subject: Direct URL firing workflow

 

Hi all,

   I am trying to simply users taking the survey in Remedy.  I have a
direct URL to bring me to the RR:SurveyResponseDialog, but the table is
empty.  Any Ideas on how I can get that table populated from the
SHR:Survey.

 

Thanks. 

 

Ron Suwanski 
Remedy Administrator / Developer 
DeVry Inc. 
Phone 630-472-2209  
Fax 630-382-2917 
[EMAIL PROTECTED] 

 

 

 

__20060125___This posting was submitted with HTML in
it___

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the 
Answers Are
image001.jpg

Mid-Tier, Single Sign-On

2007-03-01 Thread John Kenny
Hello All:

Just wondering if anyone has successfully implemented single sign-on to 
mid-tier. I have a customer who wants the user's network account to be 
used to log into mid-tier and bypass the mid-tier login screen. I already 
know how to set up the external authentication just need to know how to 
format the URL

Thanx in advance to those who respond.

John 

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