Error while running the compare report:
Records Application Upgrade Compare started: 2007-11-22-10.50.37 (62,6)
System Error : SQL error. Stmt #: 6962 Error Position: 0 Return: 1 - End of fetch (SQLSTATE PS001) (62,16)
System Error : RUN RECSTATS FOR TABLE (PSPROJECTWORK,LOW) (62,16)
Records Compare Report Created : c:\temp\HC9_MP1_ML\Upg00Records.prt (75,9)
Internal Error: invalid transaction handle instance passed from SamDestroy 0: 70 vs 0
Resolutions:
1. In compare report window UNCHECK the Update Project Item/Child Status option .
2. In configuration manager - CHECK the Disable DB Stats box
Subscribe to:
Post Comments (Atom)
OCI - Attach Block Volume to Windows VM
Tip: Although creating and attaching Block Storage to a Windows VM is pretty straightforward (OCI documentation is pretty good for that), th...
5 comments:
so far I was in confuse about how to read compare reports.Today It clarified me every thing.I appreciate and keep posting very basic important concepts.
Thanks!
Thanks Sri... however, I am goin to write a new blog on Compare report soon that will make lots of things easier - like - how to run, what options should you select on different options, how to interprate the output, how to migrate the project and what all options should be selected while migrating the project and why... hopefully I'll get time to write it soon...
Hi Rakesh,
I also have a very strange error while running a compare report.
System Error : SQL error. Stmt #: 715 Error Position: 220 Return: 1401 - ORA-01401: inserted value too large for column (62,16)
System Error : INSERT INTO PSCHGCTLLOCK (OPRID, OBJECTTYPE, OBJECTID1, OBJECTVALUE1, OBJECTID2, OBJECTVALUE2, OBJECTID3, OBJECTVALUE3, OBJECTID4, OBJECTVALUE4, DTTM_ (62,16)
System Error : STAMP, PROJECTNAME, INCIDENT_ID, DESCRLONG) VALUES ('KPNBEH', 79, 73, 'c:\temp\KPHR2935\Upg43ApplicationEnginePeopleCo.prt', 0, ' ', 0, ' ', 0, ' ', S (62,16)
System Error : YSDATE, ' ', ' ', :1) (62,16)
Do you know how come ?
Regards,
Arjen van Dijk
Logica Netherlands
a.van.dijk@logica.com
Hi,
I never faced this issue, however, doing some R&D in PeopleSoft site, I came across a problem that is similar to yours. Here it is:
Problem:
There is an sql error while running a Compare Report if "Lock definition when it is opened" is ENABLED from Tools->Options->Change Control.
If this feature is NOT ENABLED, there is NO error.
Error is similar to yours:
System Error : SQL error. Stmt #: 715 Error Position: 220 Return: 1401 - ORA-01401: inserted value too large for column (62,16)
System Error : INSERT INTO PSCHGCTLLOCK (OPRID, OBJECTTYPE, OBJECTID1, OBJECTVALUE1, OBJECTID2, OBJECTVALUE2, OBJECTID3, OBJECTVALUE3, OBJECTID4, OBJECTVALUE4, DTTM_ (62,16)
System Error : STAMP, PROJECTNAME, INCIDENT_ID, DESCRLONG) VALUES ('KPNBEH', 79, 73, 'c:\temp\KPHR2935\Upg43ApplicationEnginePeopleCo.prt', 0, ' ', 0, ' ', 0, ' ', S (62,16)
System Error : YSDATE, ' ', ' ', :1) (62,16)
You can see that the 4th value c:\temp\KPHR2935\Upg43ApplicationEnginePeopleCo.prt is too large for the 30 character OBJECTVALUE1 field.
Why is AppDesigner trying to insert a full path & file name into PSCHGCTLLOCK?
Solution:
ICE incident id 1384255000 opened in regards to this issue which is now closed as it is fixed in PT 8.48.
Here is the workaround provided by PeopleSoft Developement team until then:
The problem is only in displaying the Compare Reports in the Application Designer viewspace when Change Control is on.
The Compare Report files are still generated to the output location, its just that they can not be opened/viewed/printed when Change Control is on.
And they only fail to open when the full path, including file name, is greater than 30 characters.
So what customer can do is to generate as normal with Change Control on.
Then open the reports (File > Report From File) later when Change Control is off, or from another machine where Change Control is off.
The report files can be copied to another machine (copy both the .IDX and .PRT files).
Or the report files can be copied to the root directory, and opened from there with Change Control on.
(This will still fail for the long object (30 char) names, like Application Engine Sections, etc)
* Source www.peoplesoft.com
Hope this helps.
Cheers!!!
Rakesh...
Hi Rakesh, good morning. - I am on 8.56.07 and applying change package for hcm pum 16-25. the change pkg is huge 2gb. in change assistant at the step "Running and Reviewing compare report - Running CP compare reports" this step fails, with the below error :
-ROD Compare Report Output Directory = D:\ca\pt856\output\chngpkg\dev\softwareupdatePUM25_CP_FULL_IS4615DEV2{HR92U025-PSHRDEV2}IP\
-PJUPGSTATUS Update Project Item Child Defintions Status = 0
Transforming XML. Please be patient.
Error opening Project PUM25_CP_FULL_IS4615DEV2 from File
Do you happen to know, why this is occurring, any help/suggestion in this regard is much appreciated. am I missing something. Thanks in advance.
Post a Comment