Topic
  • 2 replies
  • Latest Post - ‏2009-10-09T15:57:37Z by lenin2k
lenin2k
lenin2k
17 Posts

Pinned topic DSYC0698E Error

‏2009-05-22T15:46:41Z |
Hello,

I'm new at DB2e, my enviroment is:

Source DB: DB2 for iSeries AS/400
Mirror server: Windows XP Service Pack 2
Mobile: HP iPaq, Windows Mobile 5.0

I'm setting up the JDBC subscriptions for the source tables, It's fine, I synchronized the PDA and it Works (More than 50 tables). But for an specific table I'm getting the following error:

DSYC0698E: Error interno o estado incoherente. The table is created in the PDA but with no rows.

I've deleted and created the subscription so many times and it doesn't work. I've googled the error but there is a few information about it. Can someone help me to fix that error? Where can I find the trace files for the synchronization?
Here is the SQL Script for that table. It has about 8000 rows.
CREATE TABLE FBVENTAS.ARTICULOS (
IDARTICULO INTEGER GENERATED ALWAYS AS IDENTITY (
START WITH 1 INCREMENT BY 1
NO MINVALUE NO MAXVALUE
NO CYCLE NO ORDER
NO CACHE )
,
IDTIPOCOMPRA FOR COLUMN IDTIP00001 INTEGER NOT NULL DEFAULT 0 ,
IDPARTIDA INTEGER NOT NULL DEFAULT 0 ,
IDMARCA INTEGER NOT NULL DEFAULT 0 ,
NOMBRE VARCHAR(45) CCSID 284 DEFAULT NULL ,
DESCRIPCION FOR COLUMN DESCR00001 VARCHAR(500) CCSID 284 DEFAULT NULL ,
UNIDADVENTA FOR COLUMN UNIDA00001 INTEGER DEFAULT NULL ,
COSTOPROMEDIO FOR COLUMN COSTO00001 NUMERIC(15, 3) DEFAULT 0 ,
COSTOMERCADO FOR COLUMN COSTO00002 NUMERIC(15, 3) DEFAULT NULL ,
ULTIMOCOSTO FOR COLUMN COSTO00003 NUMERIC(15, 3) DEFAULT 0 ,
USO VARCHAR(255) CCSID 284 DEFAULT NULL ,
OBSERVACIONES FOR COLUMN OBSER00001 VARCHAR(500) CCSID 284 DEFAULT NULL ,
IDREFERENCIA FOR COLUMN IDREF00001 VARCHAR(26) CCSID 284 DEFAULT NULL ,
NACIONALIDAD FOR COLUMN NACIO00001 VARCHAR(45) CCSID 284 DEFAULT NULL ,
ROTACION INTEGER DEFAULT NULL ,
FECHACREACION FOR COLUMN FECHA00001 DATE DEFAULT NULL ,
TOLERANCIARECEPCION FOR COLUMN TOLER00001 DECIMAL(15, 5) DEFAULT NULL ,
MATERIAL VARCHAR(255) CCSID 284 DEFAULT NULL ,
ALTO NUMERIC(12, 3) DEFAULT NULL ,
LARGO NUMERIC(12, 3) DEFAULT NULL ,
ANCHO NUMERIC(12, 3) DEFAULT NULL ,
ESPESOR NUMERIC(12, 3) DEFAULT NULL ,
PESO NUMERIC(12, 3) DEFAULT NULL ,
CAPACIDAD NUMERIC(12, 3) DEFAULT NULL ,
IDUNIDADMEDIDAS FOR COLUMN IDUNI00001 BIGINT DEFAULT NULL ,
IDNUDADPESO FOR COLUMN IDNUD00001 BIGINT DEFAULT NULL ,
IDUNIDADCAPACIDAD FOR COLUMN IDUNI00002 BIGINT DEFAULT NULL ,
IDCOLOR INTEGER NOT NULL DEFAULT 0 ,
COD3DA INTEGER NOT NULL DEFAULT 0 ,
ACTIVO CHAR(1) CCSID 284 NOT NULL DEFAULT 'V' ,
CODVIEJO CHAR(7) CCSID 284 NOT NULL DEFAULT '' ,
AS4001 CHAR(26) CCSID 284 NOT NULL DEFAULT '' ,
AS4002 CHAR(26) CCSID 284 NOT NULL DEFAULT '' ,
AS4003 CHAR(26) CCSID 284 NOT NULL DEFAULT '' ,
AS4004 CHAR(26) CCSID 284 NOT NULL DEFAULT '' ,
UNIPALETA NUMERIC(10, 0) NOT NULL DEFAULT 0 ,
IDARANCELARIO FOR COLUMN IDARA00001 VARCHAR(10) ALLOCATE(1) CCSID 284 NOT NULL DEFAULT '0' ,
CONVER CHAR(1) CCSID 284 NOT NULL DEFAULT 'N' ,
CONSTRAINT FBVENTAS.Q_FBVENTAS_ARTICULOS_IDARTICULO_00001 PRIMARY KEY( IDARTICULO ) )
;
Updated on 2009-10-09T15:57:37Z at 2009-10-09T15:57:37Z by lenin2k
  • upupsky
    upupsky
    2 Posts

    Re: DSYC0698E Error

    ‏2009-10-09T15:43:44Z  
    Hi, have you solved the problem?
    If yes, could you please share your solution here?

    You can view the client trace trace-isyn to pinpoint the problem.
  • lenin2k
    lenin2k
    17 Posts

    Re: DSYC0698E Error

    ‏2009-10-09T15:57:37Z  
    • upupsky
    • ‏2009-10-09T15:43:44Z
    Hi, have you solved the problem?
    If yes, could you please share your solution here?

    You can view the client trace trace-isyn to pinpoint the problem.
    Hi,

    Yes, I've solved the problem,

    The cause could be:

    1-) In the VARCHAR fields called NOMBRE and DESCRIPCION I have text with Spanish Special Characters like ÁÉÍÓÚÑ. I think that special characters covers more than one position. I incremented the field's lenght on the source database.

    2-) The primary Key "IDARTICULO" wasn't declared as NOT NULL field, in DB2 iSeries when you declare primary keys without NOT NULL statement the database manager adds to the field a "CONSTRAIN CHECK" to validate NULL values. DB2 Everyplace doesnt support this kind of fields.

    3-) If you are going to allow devices to INSERT in the table on source database, any field can be declared as IDENTITY. I had in the table the primary key declared as IDENTITY (Thats why I was getting the error),

    I Hope that it could help someone with the same problem,

    Regards.

    Lenin Gómez