You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

Error migrating tools 8.44 to 8.49

2 replies [Last post]
achavez's picture
User offline. Last seen 11 years 42 weeks ago. Offline
Joined: 08/14/2008
Posts: 1

Hi everybody,

We are having some troubles migrating PeopleTools 8.44 to PeopleTools 8.49. We are using Change Assistant and at Generate Updated PeopleTools Script we are getting an error on the alter table for some system tables. For example:

Error: Fatal error in function BldAlter on call to function GetOldRecDefn. Return code = 1. (76,6)
Error: PS_MCFAGNTPRS_LANG - Alter failed due to an unknown column type (NVARCHAR) found for field MCFUQAGENTID. (76,22)
Error: Fatal error in function BldAlter on call to function GetOldRecDefn. Return code = 1. (76,6)
Error: PSACECUBE - Alter failed due to an unknown column type (NVARCHAR) found for field ACEMODELID. (76,22)
Error: Fatal error in function BldAlter on call to function GetOldRecDefn. Return code = 1. (76,6)
Error: PSACECUBECOLL - Alter failed due to an unknown column type (NVARCHAR) found for field ACEMODELID. (76,22)
Error: Fatal error in function BldAlter on call to function GetOldRecDefn. Return code = 1. (76,6)

The same error is happening with 274 different tables.

Can anyone give us some direction about how to solve this issue?

Thank you for your help in advanced.

Lepa's picture
User offline. Last seen 1 year 38 weeks ago. Offline
Joined: 06/23/2008
Posts: 591
Re: Error migrating tools 8.44 to 8.49

>> Alter failed due to an unknown column type (NVARCHAR) found

Has the underlying Database changed? SQL server to Oracle for example?

Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog

Jason's picture
Jason (not verified)
Re: Error migrating tools 8.44 to 8.49

If you are running on Vista this was fixed in tools 8.49.11 see the information below from Oracle support site.

Solution

Problem has been reported in BUG:1746874000 This issue is targeted for a fix in PT 8.48.18 and PT 8.49.11.

WORKAROUND:

N/A

KEYWORDS:

MicroSoft Vista, application designer, alter audit, script ,build SPOTLIGHT