Archive for August, 2006
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 [...]
August 31st, 2006 | Posted in System Administration | No Comments
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
August 26th, 2006 | Posted in Crystal Reports | No Comments
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 [...]
August 26th, 2006 | Posted in System Administration | No Comments
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 [...]
August 26th, 2006 | Posted in System Administration | No Comments
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 [...]
August 26th, 2006 | Posted in System Administration | No Comments
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 [...]
August 26th, 2006 | Posted in System Administration | No Comments
(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)
August 26th, 2006 | Posted in SQR | No Comments
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 [...]
August 26th, 2006 | Posted in Miscellaneous | No Comments
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 [...]
August 26th, 2006 | Posted in PeopleTools | No Comments
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 [...]
August 26th, 2006 | Posted in Crystal Reports | No Comments