Decimal Figures Are Rounded during Synchronization with SQlite DB.
(Doc ID 1610261.1)
Last updated on FEBRUARY 16, 2019
Applies to:
Oracle Lite - Version 10.3.0.3.0 and laterInformation in this document applies to any platform.
Symptoms
On : 10.3.0.3.0 version, Mobile Server
ACTUAL BEHAVIOR
---------------
number(12,8) with Value: 12.3456789 is synchronized like:
sqlite> select LONGITUDE from TABLENAME;
12.346
EXPECTED BEHAVIOR
-----------------------
SQL> select LONGITUDE from Schemauser.TABLENAME;
LONGITUDE
----------
12.3456789
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. [oracle@olite-xp ~]$ export ORACLE_SID=MOBILE
[oracle@olite-xp ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Tue Nov 5 10:55:14 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options
SQL> create user schemauser identified by <PWD>;
User created.
SQL> grant connect, dba to schemauser;
Grant succeeded.
CREATE TABLE Schemauser.TABLENAME
(
CUSTOMER_NUMBER NUMBER(9) NOT NULL,
GPS_LOC_ID NUMBER(11) NOT NULL,
LOCATION_ID NUMBER(11) NOT NULL,
LONGITUDE NUMBER(12,8) NOT NULL,
LATITUDE NUMBER(12,8) NOT NULL,
ALTITUDE NUMBER(7,2) NOT NULL,
SATELITES NUMBER(3) NOT NULL,
CREATED_BY_USER_NUMBER NUMBER(6) DEFAULT 1 NOT NULL,
CREATE_DATE DATE DEFAULT SYSDATE NOT NULL,
CREATE_APPLICATION_ID NUMBER(2) DEFAULT 1 NOT NULL,
UPDATED_BY_USER_NUMBER NUMBER(6) DEFAULT 1 NOT NULL,
UPDATE_DATE DATE DEFAULT SYSDATE NOT NULL,
UPDATE_APPLICATION_ID NUMBER(2) DEFAULT 1 NOT NULL
)
TABLESPACE USERS
RESULT_CACHE (MODE DEFAULT)
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 1M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
FLASH_CACHE DEFAULT
CELL_FLASH_CACHE DEFAULT
)
LOGGING
NOCOMPRESS
NOCACHE
NOPARALLEL
MONITORING;
CREATE UNIQUE INDEX Schemauser.PK_TABLENAME ON Schemauser.TABLENAME
(GPS_LOC_ID, LOCATION_ID)
LOGGING
TABLESPACE USERS
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 1M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
FLASH_CACHE DEFAULT
CELL_FLASH_CACHE DEFAULT
)
NOPARALLEL;
CREATE INDEX Schemauser.TABLENAME_FKIND1 ON Schemauser.TABLENAME
(CUSTOMER_NUMBER, LOCATION_ID)
LOGGING
TABLESPACE USERS
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 1M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
FLASH_CACHE DEFAULT
CELL_FLASH_CACHE DEFAULT
)
NOPARALLEL;
insert into Schemauser.TABLENAME (CUSTOMER_NUMBER , GPS_LOC_ID,LOCATION_ID, LONGITUDE , LATITUDE , ALTITUDE , SATELITES )
values ('12.3456789','12.3456789','12.3456789','12.3456789','12.3456789','12.3456789','12.3456789');
commit;
2) Create PI Complete Refresh in Read only mode
3) Synchronize the PI.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |