CPQ: error by creating database tables in mysql

[Former Member]

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 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?

[Former Member]

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

[Former Member]

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?

[VinayKumarS]

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

[Former Member]

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

[nicolabeghin]

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/

[nicolabeghin]

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%20CONFI...

[nicolabeghin]

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.

[Former Member]

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.

[VinayKumarS]

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