Another upgrade from 38xto400 error..?

 

Red Cell Innovation Inc.'s picture

I'm trying to update 3.8.2 to 4.0.0. When I apply the package I get this error:   Starting Update at Mon Mar 4 09:45:53 2013

Applying initialization scripts...

Import of initUpgrade.sql was successful.

Import of insertEvnttype.sql was successful.

Import of insertEvnttype2.sql was successful.

Import of fixDuplicateEventTypeNames.sql was successful.

Import of functions/dropifexists.sql was successful.

Import of createcolumn.sql was successful.

Import of alterQuitem.sql was successful.

Import of alterCoitem2.sql was successful.

Import of dropOldViews.sql was successful.

Import of initDropFunctions.sql was successful.

Import of functions/dropifexists.sql was successful.

Applying database change files...

Import of tables/schemaord.sql was successful.

Import of tables/invhistexpcat.sql was successful.

Import of types/cntctdup.sql was successful.

Import of types/seqiss.sql was successful.

Import of alterBomitem.sql was successful.

Import of alterCohead.sql was successful.

Import of alterImageass.sql was successful.

Import of alterItemsite.sql was successful.

Import of alterLocale.sql was successful.

Import of alterPoitem.sql was successful.

Import of alterPrj.sql was successful.

Import of alterWomatl.sql was successful.

Import of createContrct.sql was successful.

Import of createSaletype.sql was successful.

Import of alterCmhead.sql was successful.

Import of alterCohist.sql was successful.

Import of alterInvchead.sql was successful.

Import of alterIpsiteminfo.sql was successful.

Import of alterItem.sql was successful.

Import of alterItemsrc.sql was successful.

Import of alterItemsrcp.sql was successful.

Import of alterPrecision.sql was successful.

Import of alterQuhead.sql was successful.

Import of alterSalesaccnt.sql was successful.

Import of dropOldIps.sql was successful.

Import of fixNonUniqueCodes.sql was successful.

Import of insertPriv.sql was successful.

Import of insertState.sql was successful.

Import of alterAccnt.sql was successful.

Import of alterApopen.sql was successful.

Import of alterArcreditapply.sql was successful.

Import of alterAropen.sql was successful.

Import of alterCoitem.sql was successful.

Import of alterCurrRate.sql was successful.

The following error was encountered while trying to import alterFlrpt.sql into the database:

ERROR:  sequence must have same owner as table it is linked to
QPSQL: Unable to create query

 

The upgrade has been aborted due to an error and your database was rolled back to the state it was in when the upgrade was initiated.

 
mmcbride's picture
Offline
Joined: 09/22/2008
try this

Hi,

I've added a file to this forum post.  In a sandbox copy,  apply the fixacl.sql to your database.  Then, login and go to System->Utilities->Access Control and run the utility.  This should get you passed the error.  Once you have tested that this worked in your sandbox, apply the same steps to your live database.

Kindest Regards,

Monique

AttachmentSize
fixacl.sql.zip 1.39 KB
 
Red Cell Innovation Inc.'s picture
Offline
Joined: 08/26/2011
I tried the script and it

I tried the script and it didn't help, but I think that's because the table ownership/permissions were ok. The problem was that although I was applying updates using a priviledged (superuser) user, it was not the "admin" account. I don't know why, but the admin account had "can login" disabled and the expiry date was set to the epoch. I changed these and reset the password for good luck and it worked. Thanks again for your help.

 
Red Cell Innovation Inc.'s picture
Offline
Joined: 08/26/2011
Thanks Monique, I'll give it

Thanks Monique, I'll give it a try.

 

mead