cancel
Showing results for 
Search instead for 
Did you mean: 

EP-PSERV component fails using JSPM

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Ryan,

Please confirm your database mean while please refer SAP Note: 1156313 which can give you some idea.

Regards,

Ganesh

Answers (3)

Answers (3)

Former Member
0 Kudos

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.

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi Ryan,

Just try to deploy from SDM.

This may help you.

Best Regards,

Kiranbabu