08-07-2017 03:44 AM
I have installed M.App Enterprise 16.1 (released last Friday), and when trying to build or rebuild a vector set, I get
Oracle.DataAccess.Client.OracleException: ORA-00932: inconsistent datatypes: expected - got CLOB at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck, Int32 isRecoverable) at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck) at Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) at Oracle.DataAccess.Client.OracleCommand.ExecuteDbDataReader(CommandBehavior behavior) at MApp.Data.Database.ExecuteReader(String sql, Action`1 readCallback, IEnumerable`1 parameters, DbConnection connection, DbTransaction transaction) at MApp.Data.Database.ExecuteReader(String sqlCommand, Action`1 readCallback, IEnumerable`1 parameters) at MApp.Maps.MapContext.GetDatasets(Guid[] ids, String styleSet) at MApp.TileService.TileServiceQueue.OrderQueue()
Why is this? I have removed and readded the vector source as well.
08-07-2017 06:09 AM
This is actually not limited to the Vector Sets, but also appears when a user tries to list apps. So seems to be a fundamental issue.
08-18-2017 03:33 AM
Hi Richard,
Do you have your MAPPE metadata (installation, tenants) in Oracle too? It looks like this could be a problem.
Thanks,
Jan
08-18-2017 04:13 AM
I reproduced the issue when I tried to do that on Oracle metadata, I will create a bug report.
Jan
08-29-2017 04:26 AM
Hi Jan
Thanks for reproducing, although it would have been better if it was not reproducible!
Can you please let me know the bug report number.
What is the recommended use of databases for the MAPPE Metadata, feature data etc?
08-29-2017 06:34 AM
Hi Richard,
The issue number is SME-672 and it was already fixed by development. It is then expected to have it in next release cycle (MAPPE has shorter release cycles than other products).
The issue did not appear on Postgres- or MSSQL-based metadata. I could use Oracle data fine on those.
Regards,
Jan