This (emailing and ftp'ing from sqr's) has been discussed repeatedly on the SQR User Group. A search of the archives at www.sqrug.com would give you the...
8353
Prakash M
prakash.m@...
Jun 1, 2001 10:53 am
Hello, PEOpenPrintJob(file path): Invalid file name Possible Causes The report's source file (.rpt file) was deleted from the drive or moved from its original...
8354
Jacqueline Rossouw
jrossouw@...
Jun 1, 2001 10:53 am
Hi re Prakash.M trying to fire emails from notes. Just a few other things that I have stumbled on that you can look out for that are specific to lotus notes...
8355
Sathiyananthan Naraya...
snara_77@...
Jun 1, 2001 10:54 am
Hi, From a SQR program u can able to do FTP process. For this use 'call system using' command. with the help of call system command u can able run any UNIX OS ...
8356
Sathiyananthan Naraya...
snara_77@...
Jun 1, 2001 10:55 am
Hi, From a SQR program u can able to do FTP process. For this use 'call system using' command. with the help of call system command u can able run any UNIX OS ...
8357
cal.link@...
Jun 1, 2001 12:34 pm
My client has to manually stop the deduction by inserting a new row. If the employee returns, they must insert yet another row. It was the only way we got it...
8358
cal.link@...
Jun 1, 2001 12:38 pm
The PeopleSoft consultant who helped us set this up said that the best thing we could do to improve performance would be to remove any field definitions we did...
8359
celder@...
Jun 1, 2001 1:03 pm
Unfortunately you can't do a UNION ALL in PeopleSoft Query, only a UNION. ... From: afugate@... [mailto:afugate@...] Sent: Thursday, May...
8360
Heather Kepner
hkepner@...
Jun 1, 2001 1:14 pm
I am not sure how to do a between with a decode. Here is how greatest works: Decode(Greatest(x, y), x, Amt, NULL) This compares x and y and determines which is...
8361
michelle.galla@...
Jun 1, 2001 1:14 pm
I also encountered this just yesterday. I'm calling in a case to GSC. ... script ... found...
8362
Bradley Smith
bradley_e_smith@...
Jun 1, 2001 1:15 pm
If you are running on a UNIX process scheduler, check out my web site for how to do ftp'ing. It doesn't require any changes to the SQR, as the process is...
8363
Peter Clark
pgclark@...
Jun 1, 2001 1:19 pm
and your web site URL would be ... ? :-) ... If you are running on a UNIX process scheduler, check out my web site for how to do ftp'ing. It doesn't require...
8364
james_strange@...
Jun 1, 2001 1:19 pm
2.Attempted in development to change the defaulted transaction commit level from 300 records to every 60 minutes. Used the payroll interface run control panel...
8365
Christenson, Amy
amy.christenson@...
Jun 1, 2001 1:28 pm
I struggled with UA as well...my only suggestion is to review the configuration manager profile and UA configuration. If UA is not installed on the C: drive,...
8366
celder@...
Jun 1, 2001 1:29 pm
Unfortunately, no. Not with decode. However you can get creative using other functions combined with decode. I suggested using substr to pull out the first...
8367
Christenson, Amy
amy.christenson@...
Jun 1, 2001 1:33 pm
The peoplebooks should have come with your installation cd. There is an enormous amount of files! Too many to email. If you don't have the cd, I would...
8368
celder@...
Jun 1, 2001 1:35 pm
Additionally, these are now HTML files and not PDF. ... From: Christenson, Amy [mailto:amy.christenson@...] Sent: Friday, June 01, 2001 8:32 AM To:...
8369
celder@...
Jun 1, 2001 1:39 pm
We don't do any mail merge processes, but from what I understand of them you will probably either need to set up a Process Scheduler on an NT box, or run this...
8370
Mahon, Jack
Jack.Mahon@...
Jun 1, 2001 1:45 pm
Hi, You need significant memory and cpu speed on that workstation. Check customer connection for exact requirements but I seem to remember 256M ram and 433...
8371
celder@...
Jun 1, 2001 1:45 pm
I have run into issues with the UA as well. Mostly during the compares. The Financials compare process is split up into two projects. One would complete, but...
8372
Rhonda Hudgins
rhudgins@...
Jun 1, 2001 1:49 pm
I would use as much memory as you can get. 256 is barely ok. Thanks! Rhonda Hudgins @}---'----,---- Genencor International, Inc 716/256-5266 ...
8373
Christenson, Amy
amy.christenson@...
Jun 1, 2001 1:49 pm
Is the UA locking up or just sitting. If it is locking up then definitely, Jack is right you have a resource problem! I finally ended up running UA directly...
8374
Christenson, Amy
amy.christenson@...
Jun 1, 2001 1:51 pm
I ended up running approx 50% of my processes outside of UA for the same reason. Amy ... From: celder@... [mailto:celder@...]...
8375
Mahon, Jack
Jack.Mahon@...
Jun 1, 2001 1:52 pm
I though we could not yet modify trees via WEB version of tree manager, only view them. Has this changed? Jack Mahon Peoplesoft Project Lead National Grid,...
8376
Christenson, Amy
amy.christenson@...
Jun 1, 2001 1:53 pm
Yes, it changed with 8.13 but according to PeopleSoft it really does not work, they don't recommend it as it is very buggy. 8.14 is supposed to fix it. Amy ......
8377
Christenson, Amy
amy.christenson@...
Jun 1, 2001 2:00 pm
Just an FYI we found a bug in 8.13 security. Even though a component is not part of a permission list, it still shows up on the menus (PIA) AND the user can...
8378
Clark, Gregory
gclark@...
Jun 1, 2001 3:10 pm
We are in the process of creating an archive system for our older data. We are considering using Oracle 8 partitioning. Has anybody looked at or implemented...
8379
Steve Lee
stevenl@...
Jun 1, 2001 3:38 pm
Actually, we had to run the VERSION.SQR again. Apparently, you have to run it AFTER cleaning up the SYSAUDIT report, or it might not work properly. ... ...
8380
Harry Oxrider - Centu...
hoxrider@...
Jun 1, 2001 6:56 pm
Ran into the same problem with PS 7 to PS 8. Logged a case with PS and never got an answer. Our work around was to create a SQL script to insert the missing...
8381
Bradley Smith
bradley_e_smith@...
Jun 1, 2001 7:07 pm
sorry about that http://pegasus.cc.ucf.edu/~brad...