Question Re: CPQ: error by creating database tables in mysql in CRM and CX Q&A

CPQ: error by creating database tables in mysql

Former Member — Mon, 29 Jul 2019 15:12:21 GMT

Hi,

I'm trying to load data via cpq data loader into mysql database and get an error:

ERROR [0000002S::de.hybris.platform.servicelayer.internal.jalo.ServicelayerJob] (0000002S) [LocalAdminManager] Exception Details: com.sap.sxe.sys.exc.exc_internal_error: Syntax error in database script file! com.sap.sxe.sys.exc.exc_internal_error: Syntax error in database script file! com.sap.sxe.sys.exc.exc_database_error: No equivalent database specific datatype found for generic type: 9 ERROR [0000002S::de.hybris.platform.servicelayer.internal.jalo.ServicelayerJob] (0000002S) [ExceptionLog] Exception in SPC.com.sap.spc.base.exc.SPCException: An error encountered when creating database tables.

Detailed error message: Syntax error in database script file! com.sap.sxe.sys.exc.exc_internal_error: Syntax error in database script file! com.sap.sxe.sys.exc.exc_database_error: No equivalent database specific datatype found for generic type: 9 at com.sap.spc.base.admin.LocalAdminManager.throwCreatingDatabaseSPCException(LocalAdminManager.java:166) at com.sap.spc.base.admin.LocalAdminManager.generateTables(LocalAdminManager.java:105) at com.sap.custdev.projects.fbs.slc.dataloader.db.TableCreator.generateTables(TableCreator.java:62) at com.sap.custdev.projects.fbs.slc.dataloader.standalone.manager.DataloaderWorkerHybris.createTables(DataloaderWorkerHybris.java:88) at com.sap.custdev.projects.fbs.slc.dataloader.standalone.manager.DataloaderManagerImpl.createTables(DataloaderManagerImpl.java:94) at de.hybris.platform.sap.productconfig.model.impl.DataLoaderImpl.performInitialLoadRaisingException(DataLoaderImpl.java:78) at de.hybris.platform.sap.productconfig.model.impl.DataLoaderImpl.performInitialLoad(DataLoaderImpl.java:40) at de.hybris.platform.sap.productconfig.model.cronjob.DataLoaderJob.perform(DataLoaderJob.java:124) at de.hybris.platform.sap.productconfig.model.cronjob.EnvironmentAwareDataLoaderJob.performDataLoad(EnvironmentAwareDataLoaderJob.java:51) at de.hybris.platform.sap.productconfig.model.cronjob.EnvironmentAwareDataLoaderJob.perform(EnvironmentAwareDataLoaderJob.java:30) at de.hybris.platform.sap.productconfig.model.cronjob.DataLoaderJob.perform(DataLoaderJob.java:1) at de.hybris.platform.servicelayer.internal.jalo.ServicelayerJob.performCronJob(ServicelayerJob.java:38) at de.hybris.platform.cronjob.jalo.Job.execute(Job.java:1390) at de.hybris.platform.cronjob.jalo.Job.performImpl(Job.java:814) at de.hybris.platform.cronjob.jalo.Job.access$1(Job.java:767) at de.hybris.platform.cronjob.jalo.Job$JobRunable.run(Job.java:686) at de.hybris.platform.util.threadpool.PoolableThread.internalRun(PoolableThread.java:208) at de.hybris.platform.core.threadregistry.RegistrableThread.run(RegistrableThread.java:134)

It seems to be a problem with the numeric type like this "GRLNR_NUM" numeric(7,0) null.

Does anyone have an idea what could be wrong?

Re: CPQ: error by creating database tables in mysql

VinayKumarS — Mon, 29 Jul 2019 15:21:45 GMT

This is not due to a combination of a program error and a configuration error of the database parameter in hybris.

If the database parameter maintained in Local.properties in hybris are incorrect, the system cannot establish a connection to the database.

The system then calls the method responsible for the creation of the tables in the database schema with a null reference for the database connection parameter.

This leads to a NullPointerException and to the misleading error message "Syntax error in database script file".

The patch related to this note improves the error handling.

The major fix for this error however is to correct the database connection parameter in Local.properties and the network configuration in order to make sure that SAP CPQ can establish a JDBC connection to the SAP CPQ database.

More info you can find https://launchpad.support.sap.com/#/notes/2192306

Re: CPQ: error by creating database tables in mysql

Former Member — Mon, 29 Jul 2019 15:44:48 GMT

I think database connection is ok. Because I could create two tables in mysql database. This two tables have only the fields of varchar type. The next table I want to create has a field of type numeric. And this is the problem.

Re: CPQ: error by creating database tables in mysql

nicolabeghin — Mon, 29 Jul 2019 18:50:10 GMT

Try checking the PAM in relation to supported MySQL version. AFAIK, MySQL 5.6 is ok (it's the one we used in most CPQ projects) while 5.7 is not, leading to weird sql syntax errors like the one reported.

Re: CPQ: error by creating database tables in mysql

Former Member — Mon, 29 Jul 2019 21:57:40 GMT

I'm using mariadb of version 10.3.15 on MAC osx10.14 (x86_64)

Re: CPQ: error by creating database tables in mysql

nicolabeghin — Mon, 29 Jul 2019 22:38:44 GMT

I don't think MariaDB is part of any SAP PAM.. anyway MariaDB 10.3 should be MySQL 5.7, so far away from the 5.6 compatibility

MySQL 5.6 is compatible with MariaDB 10.0 and MySQL 5.7 is compatible with MariaDB 10.2

ref. https://mariadb.com/kb/en/library/mariadb-vs-mysql-compatibility/

Re: CPQ: error by creating database tables in mysql

Former Member — Tue, 30 Jul 2019 14:22:19 GMT

What is about MariaDB version 10.3? It seems to be compatible with MySQL 5.7. But CPQ data loader has problem with MySQL 5.7. Is it a bug in CPQ data loader? Can I open a ticket for it?

Re: CPQ: error by creating database tables in mysql

VinayKumarS — Tue, 30 Jul 2019 15:11:15 GMT

which version of hybris and which version of cpq jars you are using? may be you can give try putting a bcp ticket with product support

Re: CPQ: error by creating database tables in mysql

Former Member — Tue, 30 Jul 2019 16:35:59 GMT

We are using the hybris version 1808.9 and the cpq version 3.0.12.

Re: CPQ: error by creating database tables in mysql

nicolabeghin — Tue, 30 Jul 2019 17:30:24 GMT

I checked CPQ PAM, MySQL 5.6 is the latest supported. MySQL 5.7 is not

ref. https://apps.support.sap.com/sap(bD1pdCZjPTAwMQ==)/support/pam/pam.html#ts=6&s=SAP%20PRODUCT%20CONFIG%203.0&filter=&o=most_viewed%7Cdesc&st=l&rpp=20&page=1&pvnr=73555000100900002252&pt=t%7CDB&ainstnr=73555000104900005087&fclfilter=G1%7CMYSQL%20DATABASE%20SERVER