BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: Upcoming Events: PGHBOUG: Aug 23.

Error with Spatial Columns extract and load


 
Search this topic... | Search Data Integrator... | Search Box
Register or Login to Post    Forum Index -> Data Integrator  Previous TopicPrint TopicNext Topic
Author Message
philip3580
Senior Member
Senior Member



Joined: 07 Mar 2008

Posts: 36



PostPosted: Tue Jan 30, 2018 1:49 am 
Post subject: Error with Spatial Columns extract and load

Hi all

Im trying to develop a very simple job that reads from an oracle table with spatial columns and writes to an oracle table without any transformations

dataflow screen shot attached


When I Execute the job
Im getting the following error -


_______________________________________________________
Log: error_01_30_2018_15_23_31_183__83592cf1_0b19_4f98_8436_50bb0ce6924d.txt Job Server: CBNEWDV36:3500

Job name: Landbase_EO_Shareplex_jb
(14.2) 01-30-18 15:23:51 (E) (23232:22616) DBS-070301: |Data flow ed_pole_to_ed_pole_etl_df|Loader ED_POLE_ED_POLE_ETL
Oracle <EEDWHUT1> error message for operation <OCIStmtExecute>: <ORA-29532: Java call terminated by uncaught Java exception:
java.sql.SQLException: Malformed WKT
ORA-06512: at "MDSYS.SDO_UTIL", line 201
>.
(14.2) 01-30-18 15:23:51 (E) (23232:22616) RUN-051005: |Data flow ed_pole_to_ed_pole_etl_df|Loader ED_POLE_ED_POLE_ETL
Execution of <Regular Load Operations> for target <ED_POLE_ETL> failed. Possible causes: (1) Error in the SQL syntax; (2)
Database connection is broken; (3) Database related errors such as transaction log is full, etc.; (4) The user defined in the
datastore has insufficient privileges to execute the SQL. If the error is for preload or postload operation, or if it is for
regular load operation and load triggers are defined, check the SQL. Otherwise, for (3) and (4), contact your local DBA.
(14.2) 01-30-18 15:24:02 (E) (24172:17360) DBS-070301: |Data flow ed_pole_to_ed_pole_etl_df|Loader ED_POLE_ED_POLE_ETL
Oracle <EEDWHUT1> error message for operation <OCIStmtExecute>: <ORA-29532: Java call terminated by uncaught Java exception:
java.sql.SQLException: Malformed WKT
ORA-06512: at "MDSYS.SDO_UTIL", line 201
>.|<Regular Load Operations>|<ED_POLE_ETL>

_______________________________________________________

Table structure is as below
target and source have same structure-

Code:

--------------------------------------------------------
--  DDL for Table ED_POLE_ETL
--------------------------------------------------------

  CREATE TABLE "EDW_SWEO_OWNER"."ED_POLE_ETL"
   (   "ID" NUMBER(*,0),
   "SOURCE_ID" NUMBER(*,0),
   "STATUS" NUMBER(*,0),
   "OWNER_TYPE" NUMBER(*,0),
   "TYPE" VARCHAR2(20 CHAR),
   "MATERIAL" NUMBER(*,0),
   "CLASS" NUMBER(*,0),
   "NUMBER0" VARCHAR2(20 CHAR),
   "HEIGHT" NUMBER(*,0),
   "FRAME_TYPE" VARCHAR2(20 CHAR),
   "DATE_INSTALLED" DATE,
   "ASSET_ID" VARCHAR2(36 CHAR),
   "OWNER_NAME" VARCHAR2(120 CHAR),
   "REINFORCEMENT_TYPE" NUMBER(*,0),
   "USAGE" NUMBER(*,0),
   "RECEPTACLE" NUMBER(*,0),
   "SOURCE_DATA" VARCHAR2(6 CHAR),
   "REDUCED_LEVEL" NUMBER,
   "STRENGTH" NUMBER(*,0),
   "DEPTH" NUMBER,
   "TREATMENT" NUMBER(*,0),
   "DATE_MANUFACTURED" DATE,
   "DATE_REMOVED" DATE,
   "EE_ECORP_ASSET_ID" NUMBER(*,0),
   "EE_OPERATIONAL_DESCRIPTION" VARCHAR2(100 CHAR),
   "EE_OPERATIONAL_NAME" VARCHAR2(100 CHAR),
   "EE_OPERATIONAL_NUMBER" VARCHAR2(40 CHAR),
   "EE_POLE_USAGE_TYPE" NUMBER(*,0),
   "EE_REPORTING_AREA" NUMBER(*,0),
   "EE_ENERGISED_" CHAR(1 BYTE),
   "EE_POLE_ALIGNMENT" NUMBER,
   "EE_RL" NUMBER,
   "REMARKS_ANNOTATION" "MDSYS"."SDO_GEOMETRY" ,
   "TEXT_REMARKS_ANNOTATION" VARCHAR2(4000 CHAR),
   "LEADER_LINE" "MDSYS"."SDO_GEOMETRY" ,
   "ANNOTATION" "MDSYS"."SDO_GEOMETRY" ,
   "TEXT_ANNOTATION" VARCHAR2(4000 CHAR),
   "LOCATION" "MDSYS"."SDO_GEOMETRY" ,
   "EE_GPS_LOCATION" "MDSYS"."SDO_GEOMETRY" ,
   "REMARKS" VARCHAR2(4000 CHAR),
   "LOCATION_DESCRIPTION" VARCHAR2(4000 CHAR),
   "FK_EE_SPECIFICATION" NUMBER(*,0),
   "FK_ED_POLE_STRUCTURE" NUMBER(*,0)
   --, "LOCATION_PT_ORIENTATION" NUMBER
   ) SEGMENT CREATION IMMEDIATE
  PCTFREE 10 PCTUSED 0 INITRANS 80 MAXTRANS 255
NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 MAXSIZE UNLIMITED
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "EDW_LDG_SWEO"
  COLUMN REMARKS_ANNOTATION NOT SUBSTITUTABLE AT ALL LEVELS
  COLUMN LEADER_LINE NOT SUBSTITUTABLE AT ALL LEVELS
  COLUMN ANNOTATION NOT SUBSTITUTABLE AT ALL LEVELS
  COLUMN LOCATION NOT SUBSTITUTABLE AT ALL LEVELS
  COLUMN EE_GPS_LOCATION NOT SUBSTITUTABLE AT ALL LEVELS
VARRAY "REMARKS_ANNOTATION"."SDO_ELEM_INFO" STORE AS BASICFILE LOB
  (ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
  CACHE
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
VARRAY "REMARKS_ANNOTATION"."SDO_ORDINATES" STORE AS BASICFILE LOB
  (ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
  CACHE
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
VARRAY "LEADER_LINE"."SDO_ELEM_INFO" STORE AS BASICFILE LOB
  (ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
  CACHE
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
VARRAY "LEADER_LINE"."SDO_ORDINATES" STORE AS BASICFILE LOB
  (ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
  CACHE
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
VARRAY "ANNOTATION"."SDO_ELEM_INFO" STORE AS BASICFILE LOB
  (ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
  CACHE
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
VARRAY "ANNOTATION"."SDO_ORDINATES" STORE AS BASICFILE LOB
  (ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
  CACHE
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
VARRAY "LOCATION"."SDO_ELEM_INFO" STORE AS BASICFILE LOB
  (ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
  CACHE
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
VARRAY "LOCATION"."SDO_ORDINATES" STORE AS BASICFILE LOB
  (ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
  CACHE
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
VARRAY "EE_GPS_LOCATION"."SDO_ELEM_INFO" STORE AS BASICFILE LOB
  (ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
  CACHE
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
VARRAY "EE_GPS_LOCATION"."SDO_ORDINATES" STORE AS BASICFILE LOB
  (ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
  CACHE
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)) ;
--------------------------------------------------------
--  Constraints for Table ED_POLE
--------------------------------------------------------

  ALTER TABLE "EDW_SWEO_OWNER"."ED_POLE_ETL" MODIFY ("EE_ENERGISED_" NOT NULL ENABLE);
  ALTER TABLE "EDW_SWEO_OWNER"."ED_POLE_ETL" MODIFY ("EE_POLE_USAGE_TYPE" NOT NULL ENABLE);
  ALTER TABLE "EDW_SWEO_OWNER"."ED_POLE_ETL" MODIFY ("TREATMENT" NOT NULL ENABLE);
  ALTER TABLE "EDW_SWEO_OWNER"."ED_POLE_ETL" MODIFY ("STRENGTH" NOT NULL ENABLE);
  ALTER TABLE "EDW_SWEO_OWNER"."ED_POLE_ETL" MODIFY ("OWNER_TYPE" NOT NULL ENABLE);
  ALTER TABLE "EDW_SWEO_OWNER"."ED_POLE_ETL" MODIFY ("STATUS" NOT NULL ENABLE);
  ALTER TABLE "EDW_SWEO_OWNER"."ED_POLE_ETL" MODIFY ("ID" NOT NULL ENABLE);




Appreciate your help !


[/img]
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Data Integrator  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0321 seconds using 18 queries. (SQL 0.0026 Parse 0.0009 Other 0.0285)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo