Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-99941

The activate method has thrown an exception when Commerce is deployed on Sybase 16

    Details

      Description

      This issue is found on 7.1.x gauntlet and 7.1.x EE Development
      Steps to Reproduce:
      #Startup bundle

      Error log:

      [java] 2019-08-16 03:28:44.919 ERROR [main][LogService:93] Invocation to listener threw exception 
           [java] com.liferay.portal.kernel.upgrade.UpgradeException: Bundle com.liferay.commerce.data.integration.service_1.0.2 [427] has invalid content in tables.sql:
           [java] create table CDataIntegrationProcess (
           [java] 	CDataIntegrationProcessId LONG not null primary key,
           [java] 	companyId LONG,
           [java] 	userId LONG,
           [java] 	userName VARCHAR(75) null,
           [java] 	createDate DATE null,
           [java] 	modifiedDate DATE null,
           [java] 	name VARCHAR(75) null,
           [java] 	type_ VARCHAR(75) null,
           [java] 	typeSettings TEXT null,
           [java] 	system BOOLEAN,
           [java] 	active_ BOOLEAN,
           [java] 	cronExpression VARCHAR(75) null,
           [java] 	startDate DATE null,
           [java] 	endDate DATE null
           [java] );
           [java] 
           [java] create table CDataIntegrationProcessLog (
           [java] 	CDataIntegrationProcessLogId LONG not null primary key,
           [java] 	companyId LONG,
           [java] 	userId LONG,
           [java] 	userName VARCHAR(75) null,
           [java] 	createDate DATE null,
           [java] 	modifiedDate DATE null,
           [java] 	CDataIntegrationProcessId LONG,
           [java] 	error TEXT null,
           [java] 	output TEXT null,
           [java] 	status INTEGER,
           [java] 	startDate DATE null,
           [java] 	endDate DATE null
           [java] );
           [java] 	at com.liferay.portal.spring.extender.internal.context.ModuleApplicationContextExtender$InitialUpgradeStep.upgrade(ModuleApplicationContextExtender.java:161)
           [java] 	at com.liferay.portal.upgrade.internal.executor.UpgradeExecutor$UpgradeInfosRunnable.run(UpgradeExecutor.java:159)
           [java] 	at com.liferay.portal.output.stream.container.internal.OutputStreamContainerFactoryTrackerImpl.runWithSwappedLog(OutputStreamContainerFactoryTrackerImpl.java:119)
           [java] 	at com.liferay.portal.upgrade.internal.executor.UpgradeExecutor.executeUpgradeInfos(UpgradeExecutor.java:110)
           [java] 	at com.liferay.portal.upgrade.internal.executor.UpgradeExecutor.execute(UpgradeExecutor.java:87)
           [java] 	at com.liferay.portal.upgrade.internal.release.osgi.commands.ReleaseManagerOSGiCommands$UpgradeInfoServiceTrackerMapListener.keyEmitted(ReleaseManagerOSGiCommands.java:485)
           [java] 	at com.liferay.portal.upgrade.internal.release.osgi.commands.ReleaseManagerOSGiCommands$UpgradeInfoServiceTrackerMapListener.keyEmitted(ReleaseManagerOSGiCommands.java:474)
           [java] 	at com.liferay.osgi.service.tracker.collections.internal.map.ServiceTrackerMapImpl$DefaultEmitter.emit(ServiceTrackerMapImpl.java:222)
           [java] 	at com.liferay.osgi.service.tracker.collections.map.PropertyServiceReferenceMapper.map(PropertyServiceReferenceMapper.java:43)
           [java] 	at com.liferay.osgi.service.tracker.collections.internal.map.ServiceTrackerMapImpl$ServiceReferenceServiceTrackerCustomizer.addingService(ServiceTrackerMapImpl.java:260)
           [java] 	at com.liferay.osgi.service.tracker.collections.internal.map.ServiceTrackerMapImpl$ServiceReferenceServiceTrackerCustomizer.addingService(ServiceTrackerMapImpl.java:248)
           [java] 	at org.osgi.util.tracker.ServiceTracker$Tracked.customizerAdding(ServiceTracker.java:943)
           [java] 	at org.osgi.util.tracker.ServiceTracker$Tracked.customizerAdding(ServiceTracker.java:1)
           [java] 	at org.osgi.util.tracker.AbstractTracked.trackAdding(AbstractTracked.java:256)
           [java] 	at org.osgi.util.tracker.AbstractTracked.track(AbstractTracked.java:229)
           [java] 	at org.osgi.util.tracker.ServiceTracker$Tracked.serviceChanged(ServiceTracker.java:903)
           [java] 	at org.eclipse.osgi.internal.serviceregistry.FilteredServiceListener.serviceChanged(FilteredServiceListener.java:109)
           [java] 	at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEventPrivileged(ServiceRegistry.java:891)
           [java] 	at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEvent(ServiceRegistry.java:804)
           [java] 	at org.eclipse.osgi.internal.serviceregistry.ServiceRegistrationImpl.register(ServiceRegistrationImpl.java:127)
           [java] 	at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.registerService(ServiceRegistry.java:228)
           [java] 	at org.eclipse.osgi.internal.framework.BundleContextImpl.registerService(BundleContextImpl.java:469)
           [java] 	at org.eclipse.osgi.internal.framework.BundleContextImpl.registerService(BundleContextImpl.java:487)
           [java] 	at org.eclipse.osgi.internal.framework.BundleContextImpl.registerService(BundleContextImpl.java:1004)
           [java] 	at com.liferay.portal.spring.extender.internal.context.ModuleApplicationContextExtender$ModuleApplicationContextExtension._processInitialUpgrade(ModuleApplicationContextExtender.java:375)
           [java] 	at com.liferay.portal.spring.extender.internal.context.ModuleApplicationContextExtender$ModuleApplicationContextExtension.start(ModuleApplicationContextExtender.java:301)
           [java] 	at org.apache.felix.utils.extender.AbstractExtender.createExtension(AbstractExtender.java:259)
           [java] 	at org.apache.felix.utils.extender.AbstractExtender.modifiedBundle(AbstractExtender.java:232)
           [java] 	at org.apache.felix.utils.extender.AbstractExtender.addingBundle(AbstractExtender.java:192)
           [java] 	at org.osgi.util.tracker.BundleTracker$Tracked.customizerAdding(BundleTracker.java:475)
           [java] 	at org.osgi.util.tracker.BundleTracker$Tracked.customizerAdding(BundleTracker.java:1)
           [java] 	at org.osgi.util.tracker.AbstractTracked.trackAdding(AbstractTracked.java:256)
           [java] 	at org.osgi.util.tracker.AbstractTracked.trackInitial(AbstractTracked.java:183)
           [java] 	at org.osgi.util.tracker.BundleTracker.open(BundleTracker.java:159)
           [java] 	at org.apache.felix.utils.extender.AbstractExtender.startTracking(AbstractExtender.java:150)
           [java] 	at org.apache.felix.utils.extender.AbstractExtender.doStart(AbstractExtender.java:142)
           [java] 	at org.apache.felix.utils.extender.AbstractExtender.start(AbstractExtender.java:114)
           [java] 	at com.liferay.portal.spring.extender.internal.context.ModuleApplicationContextExtender.activate(ModuleApplicationContextExtender.java:71)
           [java] 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
           [java] 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
           [java] 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
           [java] 	at java.lang.reflect.Method.invoke(Method.java:498)
           [java] 	at org.apache.felix.scr.impl.inject.methods.BaseMethod.invokeMethod(BaseMethod.java:228)
           [java] 	at org.apache.felix.scr.impl.inject.methods.BaseMethod.access$500(BaseMethod.java:41)
           [java] 	at org.apache.felix.scr.impl.inject.methods.BaseMethod$Resolved.invoke(BaseMethod.java:664)
           [java] 	at org.apache.felix.scr.impl.inject.methods.BaseMethod.invoke(BaseMethod.java:510)
           [java] 	at org.apache.felix.scr.impl.inject.methods.ActivateMethod.invoke(ActivateMethod.java:317)
           [java] 	at org.apache.felix.scr.impl.inject.methods.ActivateMethod.invoke(ActivateMethod.java:307)
           [java] 	at org.apache.felix.scr.impl.manager.SingleComponentManager.createImplementationObject(SingleComponentManager.java:341)
           [java] 	at org.apache.felix.scr.impl.manager.SingleComponentManager.createComponent(SingleComponentManager.java:114)
           [java] 	at org.apache.felix.scr.impl.manager.SingleComponentManager.getService(SingleComponentManager.java:983)
           [java] 	at org.apache.felix.scr.impl.manager.SingleComponentManager.getServiceInternal(SingleComponentManager.java:956)
           [java] 	at org.apache.felix.scr.impl.manager.AbstractComponentManager.activateInternal(AbstractComponentManager.java:765)
           [java] 	at org.apache.felix.scr.impl.manager.DependencyManager$SingleStaticCustomizer.addedService(DependencyManager.java:1053)
           [java] 	at org.apache.felix.scr.impl.manager.DependencyManager$SingleStaticCustomizer.addedService(DependencyManager.java:1007)
           [java] 	at org.apache.felix.scr.impl.manager.ServiceTracker$Tracked.customizerAdded(ServiceTracker.java:1216)
           [java] 	at org.apache.felix.scr.impl.manager.ServiceTracker$Tracked.customizerAdded(ServiceTracker.java:1137)
           [java] 	at org.apache.felix.scr.impl.manager.ServiceTracker$AbstractTracked.trackAdding(ServiceTracker.java:944)
           [java] 	at org.apache.felix.scr.impl.manager.ServiceTracker$AbstractTracked.track(ServiceTracker.java:880)
           [java] 	at org.apache.felix.scr.impl.manager.ServiceTracker$Tracked.serviceChanged(ServiceTracker.java:1168)
           [java] 	at org.apache.felix.scr.impl.BundleComponentActivator$ListenerInfo.serviceChanged(BundleComponentActivator.java:125)
           [java] 	at org.eclipse.osgi.internal.serviceregistry.FilteredServiceListener.serviceChanged(FilteredServiceListener.java:109)
           [java] 	at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEventPrivileged(ServiceRegistry.java:891)
           [java] 	at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEvent(ServiceRegistry.java:804)
           [java] 	at org.eclipse.osgi.internal.serviceregistry.ServiceRegistrationImpl.register(ServiceRegistrationImpl.java:127)
           [java] 	at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.registerService(ServiceRegistry.java:228)
           [java] 	at org.eclipse.osgi.internal.framework.BundleContextImpl.registerService(BundleContextImpl.java:469)
           [java] 	at org.eclipse.osgi.internal.framework.BundleContextImpl.registerService(BundleContextImpl.java:487)
           [java] 	at org.eclipse.osgi.internal.framework.BundleContextImpl.registerService(BundleContextImpl.java:1004)
           [java] 	at com.liferay.registry.internal.RegistryImpl.registerService(RegistryImpl.java:369)
           [java] 	at com.liferay.portal.tools.DBUpgrader._registerModuleServiceLifecycle(DBUpgrader.java:443)
           [java] 	at com.liferay.portal.tools.DBUpgrader.main(DBUpgrader.java:116)
           [java] 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
           [java] 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
           [java] 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
           [java] 	at java.lang.reflect.Method.invoke(Method.java:498)
           [java] 	at com.liferay.portal.tools.db.upgrade.client.DBUpgraderLauncher.main(DBUpgraderLauncher.java:55)
           [java] Caused by: com.sybase.jdbc4.jdbc.SybSQLException: Incorrect syntax near the keyword 'output'.
           [java] 
           [java] 	at com.sybase.jdbc4.tds.Tds.processEed(Tds.java:4003)
           [java] 	at com.sybase.jdbc4.tds.Tds.nextResult(Tds.java:3093)
           [java] 	at com.sybase.jdbc4.jdbc.ResultGetter.nextResult(ResultGetter.java:78)
           [java] 	at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:289)
           [java] 	at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:271)
           [java] 	at com.sybase.jdbc4.jdbc.SybStatement.updateLoop(SybStatement.java:2514)
           [java] 	at com.sybase.jdbc4.jdbc.SybStatement.executeUpdate(SybStatement.java:2498)
           [java] 	at com.sybase.jdbc4.jdbc.SybStatement.executeUpdate(SybStatement.java:576)
           [java] 	at com.zaxxer.hikari.pool.ProxyStatement.executeUpdate(ProxyStatement.java:117)
           [java] 	at com.zaxxer.hikari.pool.HikariProxyStatement.executeUpdate(HikariProxyStatement.java)
           [java] 	at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:340)
           [java] 	at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:310)
           [java] 	at com.liferay.portal.dao.db.BaseDB.runSQLTemplateString(BaseDB.java:497)
           [java] 	at com.liferay.portal.dao.db.BaseDB.runSQLTemplateString(BaseDB.java:554)
           [java] 	at com.liferay.portal.spring.extender.internal.context.ModuleApplicationContextExtender$InitialUpgradeStep.upgrade(ModuleApplicationContextExtender.java:157)
           [java] 	... 76 more
      

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  7 weeks, 6 days ago

                  Packages

                  Version Package
                  7.1.X