error in upgrade to Liferay CE 7

[Philippe Thibault, modificado 6 Anos atrás.]

Hi,

I am stuck with an error while running the liferay ce 7 upgrade tool on my 6.2 installation. I get a com.ctc.wstx.exc.WstxUnexpectedCharException: Illegal character exception. I am unable to guess from where the problem arises, any help would be greatly appreciated!

Here is the exception thrown (full upgrade log attached) :

com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.exception.SystemException: com.ctc.wstx.exc.WstxUnexpectedCharException: Illegal character (NULL, unicode 0) encountered: not valid in any content
 at [row,col {unknown-source}]: [1,1656]
	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:93)
	at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:175)
	at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:143)
	at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:125)
	at com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.java:164)
	at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:81)
	at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:153)
	at com.liferay.portal.tools.DBUpgrader.main(DBUpgrader.java:99)
Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.exception.SystemException: com.ctc.wstx.exc.WstxUnexpectedCharException: Illegal character (NULL, unicode 0) encountered: not valid in any content
 at [row,col {unknown-source}]: [1,1656]
	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:93)
	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:117)
	at com.liferay.portal.upgrade.UpgradeProcess_7_0_0.doUpgrade(UpgradeProcess_7_0_0.java:84)
	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:90)
	... 7 more
Caused by: com.liferay.portal.kernel.exception.SystemException: com.ctc.wstx.exc.WstxUnexpectedCharException: Illegal character (NULL, unicode 0) encountered: not valid in any content
 at [row,col {unknown-source}]: [1,1656]
	at com.liferay.portlet.PortletPreferencesFactoryImpl.createPreferencesMap(PortletPreferencesFactoryImpl.java:123)
	at com.liferay.portlet.PortletPreferencesFactoryImpl.toPreferencesMap(PortletPreferencesFactoryImpl.java:906)
	at com.liferay.portlet.PortletPreferencesFactoryImpl.fromXML(PortletPreferencesFactoryImpl.java:206)
	at com.liferay.portlet.PortletPreferencesFactoryImpl.fromXML(PortletPreferencesFactoryImpl.java:90)
	at com.liferay.portal.kernel.portlet.PortletPreferencesFactoryUtil.fromXML(PortletPreferencesFactoryUtil.java:63)
	at com.liferay.portal.upgrade.v7_0_0.UpgradeLookAndFeel.upgradePreferences(UpgradeLookAndFeel.java:40)
	at com.liferay.portal.kernel.upgrade.BaseUpgradePortletPreferences.updatePortletPreferences(BaseUpgradePortletPreferences.java:337)
	at com.liferay.portal.kernel.upgrade.BaseUpgradePortletPreferences.doUpgrade(BaseUpgradePortletPreferences.java:53)
	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:90)
	... 10 more
Caused by: com.ctc.wstx.exc.WstxUnexpectedCharException: Illegal character (NULL, unicode 0) encountered: not valid in any content
 at [row,col {unknown-source}]: [1,1656]
	at com.ctc.wstx.sr.StreamScanner.constructNullCharException(StreamScanner.java:615)
	at com.ctc.wstx.sr.StreamScanner.throwInvalidSpace(StreamScanner.java:644)
	at com.ctc.wstx.sr.BasicStreamReader.readTextPrimary(BasicStreamReader.java:4554)
	at com.ctc.wstx.sr.BasicStreamReader.nextFromTree(BasicStreamReader.java:2886)
	at com.ctc.wstx.sr.BasicStreamReader.next(BasicStreamReader.java:1019)
	at com.ctc.wstx.evt.WstxEventReader.peek(WstxEventReader.java:306)
	at com.liferay.portal.xml.StAXReaderUtil.read(StAXReaderUtil.java:38)
	at com.liferay.portlet.PortletPreferencesFactoryImpl.readPreference(PortletPreferencesFactoryImpl.java:786)
	at com.liferay.portlet.PortletPreferencesFactoryImpl.createPreferencesMap(PortletPreferencesFactoryImpl.java:115)
	... 18 more

[Alberto Chaparro, modificado 6 Anos atrás.]

Hi Philippe,

It seems that you have XML content with invalid characters in portletPreferences table.

This is the code which fails:
https://github.com/liferay/liferay-portal/blob/master/portal-impl/src/com/liferay/portlet/PortletPreferencesFactoryImpl.java#L95

Maybe you could try to do an script which run all portlet Preferences to check which ones are wrong before the upgrade so that you can fix it.

Let us know the results.

Regards.

[Philippe Thibault, modificado 6 Anos atrás.]

Thanks Alberto for the quick reply and precise info, much appreciated!

I am having a hard time running the java code portion upgrade process that is loading/saving xml portlet prefs from database. I went above at com.liferay.portal.kernel.upgrade.BaseUpgradePortletPreferences and took the code at updatePortletPreferences() into a simple java program that is connecting to my portal db and running it on my portletpreference table. I did succeed in building the program and run it by doing the initialization I think necessary ( PortletPreferencesFactoryImpl and BasicRegistryImpl ... ?). However my program is running endlessly at the point of setting up PortletPreferencesFactoryUtil . It says : "Loading jar:file:/opt/liferay/liferay-ce-portal-7.0-ga4/tomcat-8.0.32/webapps/ROOT/WEB-INF/lib/portal-impl.jar!/system.properties". I have attached the java code.

Any thoughts on how to make the portletpreference upgrade process run independently as a test?

thanks!

[Philippe Thibault, modificado 6 Anos atrás.]

ok finally got throught this, thanks to

com.liferay.portal.tools.ToolDependencies.wireBasic();

. Culprit xml pref found and deleted, upgrade process could go through!

[Alberto Chaparro, modificado 6 Anos atrás.]

Hi Philippe,

I am glad to hear that.

Thanks for sharing the solution.

Best regards.

[Pooja Joshi, modificado 6 Anos atrás.]

Hi Philippe,

Could you please tell me what is com.liferay.portal.tools.ToolDependencies.wireBasic();? and how to use it?

I am getting below exception while upgrading DB from liferay 6.2 to Liferay dxp.

2018-04-18 15:03:45.346 INFO [main][UpgradeProcess:103] Failed upgrade process com.liferay.portal.upgrade.UpgradeProcess_7_0_0 in 431243ms
com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.exception.SystemException: com.ctc.wstx.exc.WstxUnexpectedCharException: Unexpected character '"' (code 34) excepted space, or '>' or "/>"
at [row,col {unknown-source}]: [1,84]

Thanks in advance.

[Philippe Thibault, modificado 6 Anos atrás.]

Hi Pooja,

I found out this method call at the beginning of some test java program in liferay source. I kinda guessed that it would setup the environnement and static object needed to run liferay code, but I don't really know what it does appart from being needed in order to run the code portion pointed out by Alberto.

Phil