Re: ARInside error
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
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
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
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
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
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
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
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