I am trying to install IBMApplicationCenter.apk ( Appcenter application shipped with Worklight server for android ),using the Worklight ApplicationCenter console. This results in this SQL Error:
Caused by: <openjpa-1.2.2-r422266:898935 nonfatal general error> org.apache.openjpa.persistence.PersistenceException: Data truncation: Incorrect datetime value: '' for column 'CREATED' at row 1 {prepstmnt 428593325 INSERT INTO APPLICATION_MD (ACTIVE, APNS_CERTIFICATE_PASSWORD, APNS_GATEWAY, CREATED, DESCRIPTION, IS_INSTALLER, LABEL, MANDATORY, OS, PKG, READY_PROD, RESOURCE_TYPE, UPDATED, VENDOR, VERSION, VERSION_NAME, VERSION_NUM, AUTHOR, ACL) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [params=(String) Y, (String) , (String) , (Timestamp) 2013-05-28 11:37:28.433, (String) The compiled package file for the Android version of the Application..., (String) N, (String) IBM App Center, (String) N, (String) Android, (String) com.ibm.appcenter@Android, (String) N, (String) apk, (Timestamp) 2013-05-28 11:37:28.433, (String) , (String) 1, (String) 1.0, (double) 1.0000099998474121, (int) 2, (int) 2]} [code=0, state=22001]
I had similar issues with the data type conversions and truncation while uploading the apps in Worklight Console. See this :
worklight-wlapp-deployment-sql-error-for-gadgets-table-on-mysql
Make me wonder whether there are issues with the schemas that are shipped with the Worklight Enterprise installation. I have tried cleaning and re-creating the Appcenter schema.
