Archive for August, 2006

Posting a 1099 File to Web

Recently I came across one issue that the 1099 Process is generating a file with .001 getting posted to Report Repository, but it is not producing any link in View log / trace.
The link is not showing up in View Log trace, because the file type .001 is not defined in the Process Scheduler [...]

Crystal Report Date format Issue

Process Scheduler changing the custom date format to default date format.
Workaround:
Go to Process Schduler -> Processes ->
Open the your crystal process definition
Go to Overrude options tab and Append the following to the Parameter List.
-LX0

Change Assistant: not showing up the environment name and system

Change Assistant not showing up the environment name and system type
While uploading the Environment to the peoplesoft gateway. The XML file is not including the environment name and system type.
Solution:
This happens when there is no environment name and system type not mentioned in PeopleTools options. Use the following navigation.
PeopleTools -> Utilities -> Administration -> Peopletools [...]

Unable to connect to RenServer

When One of our functional People running a report from the page they were getting the following error.
Unable to connect to RenServer
Solution:
I verified the Ping Test and Buffer Test by going to RenServer cluster, everything was working Normal. Then I changed the machine name to Lower Case and I was able to run the report successfully.
Strange [...]

Changing Access ID and Access Password

If you need to change the both Access Id and Access Password follow the following steps.
UPDATE PSSTATUS SET OWNERID = ‘ACCESSID’
UPDATE PSACCESSPRFL SET ACCESSID = ‘NEW_ACCESS_ID’, SYMBOLICID = ‘SYMBOLIC_ID’, ACCESSPSWD = ‘NEW_ACCESS_PASSWORD’, ENCRYPTED = 0
This AccessID should have dbo access when it created on database server.
Note: No need to encrypt this, when you open the [...]

REN server with DNS alias issue

I was getting REN server communication failed eror when I try to ping from REN Server cluster page, After changing the URL from machine name to a DNS alias.
Workaround:
Go to PeopleTools -> REN Server Configuration -> REN Server Cluster
Replace your machine name in Cluster URL and Browser URL point to your DNS name.
Recycle Your Application [...]

(SQR 4045) Function or operator ‘dateadd’ requires date

(SQR 4045) Function or operator ‘dateadd’ requires date argument. The above error will show up if you use dateadd function in SQR and didn’t declare the variable as date. use the following example.
declare-variable
date $sunday
end-declare
….let $date1 = dateadd($sunday,’minute’,1)

PeopleSoft FAQs

1. Where do you do the development in PeopleSoft ?.
A. Using Application Designer.
2. How do you trace in PeopleSoft ?.
A. When you go to 3-tier login screen you will see a link for Trace, there you will specify the trace settings.
3. How do you run an SQR in PeopleSoft ?.
A. You can run in 2 [...]

Inserting Objects in to Project Automatically

Objective:
Developer needs to include all his objects when they modified and saved into the project.
Method:
The following method shows you how to insert an object automatically into a project when you modified and saved or deleted.
1. Open Application Designer.
2. Click on Tools - > Options
3. Under Insert Definition into Project, select ‘When definition is modified [...]

Crystal Reports Print Engine error

I got the following error, when I tried to run a barcode report to PDF ouput type.
Crystal Reports Print Engine error text: Error in File d:\pt8.44tst\crw\eng\po003.rt:
Operation not yet t:
Operation not yet implemented. %6 %7 %8 %9 (65,30)
Message Set Number: 65
Message Number: 30
Message Reason: Crystal Reports Print Engine error text: Error in File d:\pt8.44tst\crw\eng\po003.rt:
Operation not yet [...]