on 11-24-2008 11:02 PM
Hey guys,
Maybe cuz it's time to go home but I've got this one last component to upgrade for our EP dev system to SP17. It involves the Table WCR_USERSTAT: Conversion currently not possible. Like I said, I've got all the rest of the stack deployed but this one. If someone has an idea for me from the log, that would be great:
Nov 24, 2008 4:39:30 PM Info: 16:39:30 2008-11-24 dbs-Info: WCR_USERSTAT modify column LOGONID from type : VARCHAR,len : 255,dec : 0,not null : false,default : | |
Nov 24, 2008 4:39:30 PM Info: 16:39:30 2008-11-24 dbs-Info: WCR_USERSTAT modify column LOGONID from type : VARCHAR,len : 255,dec : 0,not null : false,default : | |
Nov 24, 2008 4:39:30 PM Info: 16:39:30 2008-11-24 dbs-Info: WCR_USERSTAT modify column LOGONID to type : VARCHAR,len : 255,dec : 0,not null : true,default : | |
Nov 24, 2008 4:39:30 PM Info: 16:39:30 2008-11-24 dbs-Info: WCR_USERSTAT modify column LOGONID to type : VARCHAR,len : 255,dec : 0,not null : true,default : | |
Nov 24, 2008 4:39:30 PM Info: 16:39:30 2008-11-24 db4-Info: existsData() returns true.
Nov 24, 2008 4:39:30 PM Info: 16:39:30 2008-11-24 dbs-Info: Action: CONVERT
Nov 24, 2008 4:39:30 PM Info: 16:39:30 2008-11-24 dbs-Info: Action: CONVERT
Nov 24, 2008 4:39:30 PM Info: 16:39:30 2008-11-24 dbs-Info: Table has to be converted
Nov 24, 2008 4:39:30 PM Info: 16:39:30 2008-11-24 dbs-Info: Table has to be converted
Nov 24, 2008 4:39:30 PM Info:
Nov 24, 2008 4:39:30 PM Info: E R R O R ******* (DbModificationManager)
Nov 24, 2008 4:39:30 PM Info: 16:39:30 2008-11-24 dbs-Error: Table WCR_USERSTAT: Conversion currently not possible
Nov 24, 2008 4:39:30 PM Info:
Nov 24, 2008 4:39:30 PM Info: E R R O R ******* (DbModificationManager)
Nov 24, 2008 4:39:30 PM Info: 16:39:30 2008-11-24 dbs-Error: Table WCR_USERSTAT: Conversion currently not possible
Nov 24, 2008 4:39:30 PM Info: 16:39:30 2008-11-24 dbs-Info: Next archive object : WCR_WEBCNODESTAT.gdbtable
Nov 24, 2008 4:39:30 PM Info: 16:39:30 2008-11-24 dbs-Info: Next archive object : WCR_WEBCNODESTAT.gdbtable
Nov 24, 2008 4:39:30 PM Info: 16:39:30 2008-11-24 dbs-Info: <<< Analyze table WCR_WEBCNODESTAT >>>
Nov 24, 2008 4:39:30 PM Info: 16:39:30 2008-11-24 dbs-Info: <<< Analyze table WCR_WEBCNODESTAT >>>
Nov 24, 2008 4:39:30 PM Info: 16:39:30 2008-11-24 dbs-Info: predefined action is: >>>null<<<
Nov 24, 2008 4:39:30 PM Info: 16:39:30 2008-11-24 dbs-Info: predefined action is: >>>null<<<
Nov 24, 2008 4:39:30 PM Info: 16:39:30 2008-11-24 db4-Info: Converted default value UX'0020' to .
Nov 24, 2008 4:39:30 PM Info: 16:39:30 2008-11-24 dbs-Info: No action required for table
Nov 24, 2008 4:39:30 PM Info: 16:39:30 2008-11-24 dbs-Info: No action required for table
Nov 24, 2008 4:39:30 PM Info: 16:39:30 2008-11-24 db4-Info: Converted default value UX'0020' to .
Nov 24, 2008 4:39:30 PM Info: 16:39:30 2008-11-24 dbs-Info: Runtime XML of WCR_WEBCNODESTAT successfully written
Nov 24, 2008 4:39:30 PM Info: 16:39:30 2008-11-24 dbs-Info: Runtime XML of WCR_WEBCNODESTAT successfully written
Nov 24, 2008 4:39:30 PM Info: 16:39:30 2008-11-24 dbs-Info: Runtime XML of WCR_WEBCNODESTAT successfully written
Nov 24, 2008 4:39:30 PM Info: 16:39:30 2008-11-24 dbs-Info: Runtime XML of WCR_WEBCNODESTAT successfully written
Nov 24, 2008 4:39:30 PM Info: 16:39:30 2008-11-24 dbs-Info: Next archive object : WCR_WEBCONTENTSTAT.gdbtable
Nov 24, 2008 4:39:30 PM Info: 16:39:30 2008-11-24 dbs-Info: Next archive object : WCR_WEBCONTENTSTAT.gdbtable
Nov 24, 2008 4:39:30 PM Info: 16:39:30 2008-11-24 dbs-Info: <<< Analyze table WCR_WEBCONTENTSTAT >>>
Nov 24, 2008 4:39:30 PM Info: 16:39:30 2008-11-24 dbs-Info: <<< Analyze table WCR_WEBCONTENTSTAT >>>
Nov 24, 2008 4:39:30 PM Info: 16:39:30 2008-11-24 dbs-Info: predefined action is: >>>null<<<
Nov 24, 2008 4:39:30 PM Info: 16:39:30 2008-11-24 dbs-Info: predefined action is: >>>null<<<
Nov 24, 2008 4:39:30 PM Info: 16:39:30 2008-11-24 db4-Info: Converted default value UX'0020' to .
Nov 24, 2008 4:39:30 PM Info: 16:39:30 2008-11-24 db4-Info: Converted default value UX'0020' to .
Nov 24, 2008 4:39:30 PM Info: 16:39:30 2008-11-24 dbs-Info: No action required for table
Nov 24, 2008 4:39:30 PM Info: 16:39:30 2008-11-24 dbs-Info: No action required for table
Nov 24, 2008 4:39:30 PM Info: 16:39:30 2008-11-24 db4-Info: Converted default value UX'0020' to .
Nov 24, 2008 4:39:30 PM Info: 16:39:30 2008-11-24 db4-Info: Converted default value UX'0020' to .
Nov 24, 2008 4:39:30 PM Info: 16:39:30 2008-11-24 dbs-Info: Runtime XML of WCR_WEBCONTENTSTAT successfully written
Nov 24, 2008 4:39:30 PM Info: 16:39:30 2008-11-24 dbs-Info: Runtime XML of WCR_WEBCONTENTSTAT successfully written
Nov 24, 2008 4:39:30 PM Info: 16:39:30 2008-11-24 dbs-Info: Runtime XML of WCR_WEBCONTENTSTAT successfully written
Nov 24, 2008 4:39:30 PM Info: 16:39:30 2008-11-24 dbs-Info: Runtime XML of WCR_WEBCONTENTSTAT successfully written
Nov 24, 2008 4:39:30 PM Info: 16:39:30 2008-11-24 dbs-Info: Analysis and adjustment of tables finished with errors
Nov 24, 2008 4:39:30 PM Info: 16:39:30 2008-11-24 dbs-Info: Analysis and adjustment of tables finished with errors
Nov 24, 2008 4:39:30 PM Error: Aborted: development component 'com.sap.portal.activityreport.db'/'sap.com'/'SAP AG'/'7.0016.20080610125917.0000'/'1', grouped by :
No further description found.
Nov 24, 2008 4:39:30 PM Info: Starting to save the repository
Nov 24, 2008 4:39:31 PM Info: Finished saving the repository
Nov 24, 2008 4:39:31 PM Info: Starting: Update: Selected software component 'EP-PSERV'/'sap.com'/'SAP AG'/'1000.7.00.17.0.20080918061435''/'1' updates currently deployed software component 'EP-PSERV'/'sap.com'/'SAP AG'/'1000.7.00.10.0.20061109200900''/'0'.
Nov 24, 2008 4:39:31 PM Error: Aborted: software component 'EP-PSERV'/'sap.com'/'SAP AG'/'1000.7.00.17.0.20080918061435''/'1':
Failed deployment of SDAs:
development component 'com.sap.portal.activityreport.db'/'sap.com'/'SAP AG'/'7.0016.20080610125917.0000'/'1' : aborted
Please, look at error logs above for more information!
Nov 24, 2008 4:39:31 PM Info: Starting to save the repository
Nov 24, 2008 4:39:32 PM Info: Finished saving the repository
Nov 24, 2008 4:39:32 PM Info: J2EE Engine is in same state (online/offline) as it has been before this deployment process.
Nov 24, 2008 4:39:32 PM Error: -
At least one of the Deployments failed -
Again thanks for any help on this.
Ryan
Hi Ryan,
Please confirm your database mean while please refer SAP Note: 1156313 which can give you some idea.
Regards,
Ganesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You didn't indicate what your Portal version was. Check out SAP Note 1592995, valid since May 24, 2011. I couldn't deploy EP-PSERV on 7.02. I had to drop a databse table and resume JSPM. There will be five files in EP-PSERV that you will have to deploy through SDM.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Nice call Ganesh. I did a search in the notes myself but didn't find this one. I have made the changes suggested to the DB4 table and am deploying the change currently. Thanks for the help.
Ryan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ryan,
Just try to deploy from SDM.
This may help you.
Best Regards,
Kiranbabu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
11 | |
11 | |
10 | |
9 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.