Invalid pointer operation

This public forum is for user-to-user discussions of ASP.NET Maker. Note that this is not support forum.
Post Reply
muttou
User
Posts: 103

Invalid pointer operation

Post by muttou »

Hi, i am using asp.net maker 2022 with oracle 19c and getting this issue when make the connection "Invalid pointer operation". other databases are accessing and loading. only specific db is not being accessing. thank you for your help in this regards


MichaelG
User
Posts: 779

Post by MichaelG »

If you meant connection with the UI of ASP.NET Maker, make sure the connection is not blocked by firewall.


muttou
User
Posts: 103

Post by muttou »

I have already checked the firewall blocking before thread posting. moreover, checked with sysdba login but not succeeded. i am trying to implement this on oracle 19c Exa-8 database machine configured on network and accessing it remotely successfully for other databases that are working fine. moreover, accessing the same database with other db tools with successful connection.

I have to test this on big data (19 million) for CURD operations. hope will manage and run successfully after establishing the successful connection.

thank you in this regards.


MichaelG
User
Posts: 779

Post by MichaelG »

What client do you use to connect to Oracle? If you use Oracle client (assume you have installed), try direct connection, or vice versa.

Read Database Setup -> Oracle.


muttou
User
Posts: 103

Post by muttou »

Yes doing the same for database connection string like Server_IP:1521/service_name. still same issue . other databases are accessing the schema and generated the application successfully. now the bottleneck issue is this error. thank you for your update and response again.


MichaelG
User
Posts: 779

Post by MichaelG »

Please check the "Load table dynamically" option first before connecting. See if you are able to load the database schema. If yes, load the required tables one by one.

Also double check the database user you enter in the project has the permissions to access that database.

If the database has something other than tables and views (e.g. stored procedure, functions, triggers, etc.), try remove them first and test if they caused the problem.


muttou
User
Posts: 103

Post by muttou »

Dear thank you for your positive response. yes user name have proper privileges and other databases are loading except the production on. one thing that i am doing now is to replicate the schema table to my schema where application is working fine. hope issue will resolve.

Moreover, can i get the logs related to maker startup problems in my installed location. thank you once again for your positive response.


muttou
User
Posts: 103

Post by muttou »

One more thing yes target schema has some functions / procedures . hope that might be the reason for unloading the schema, I have made a double check also by enabling the load tables dynamically but not succeed and getting the same invalid pointer operations.

i have proposed this solution in our premise and run successful demo on my generated schema with millions of rows .. all operations runs successfully and operated fully over the network with full CURD operations.

thank you once again for your response in this regards.


muttou
User
Posts: 103

Post by muttou »

Hi i m doing the same by importing the db on my schema on same machine .. still same issue "invalid pointer operation" when load in asp.maker. what i did new?

  • clear all records and test on empty tables

  • only number, date, timestamp and varchar2 data type fields are in tables

  • just primary key index only.

    moreover, sharing the schema with you for 02 tables where issue being occurring. kindly need your assistance in this regards. thank you once again.

    Code: Select all

    -- ----------------------------
    -- Table structure for NDEP_HOUSEHOLD_ROSTER
    -- ----------------------------
    DROP TABLE "MNASIR"."NDEP_HOUSEHOLD_ROSTER";
    CREATE TABLE "MNASIR"."NDEP_HOUSEHOLD_ROSTER" (
      "UNIQUE_HH_ID" NUMBER VISIBLE,
      "UNIQUE_R_ID" NUMBER VISIBLE,
      "ENUMERATOR_SURVEY_ID" NUMBER VISIBLE,
      "R_ID" NUMBER VISIBLE,
      "CNIC_ENC" VARCHAR2(250 BYTE) VISIBLE,
      "CNIC" VARCHAR2(150 BYTE) VISIBLE,
      "HOUSEHOLD_MEMBER_NAMES_ENC" VARCHAR2(250 BYTE) VISIBLE,
      "HOUSEHOLD_MEMBER_NAMES" VARCHAR2(250 BYTE) VISIBLE,
      "HOUSEHOLD_HEAD_NAME_ENC" VARCHAR2(128 BYTE) VISIBLE,
      "HOUSEHOLD_HEAD_NAME" VARCHAR2(128 BYTE) VISIBLE,
      "RELATION_TO_HOUSEHOLD_HEAD" NUMBER VISIBLE,
      "SPOUSE_NAME_ENC" VARCHAR2(250 BYTE) VISIBLE,
      "SPOUSE_NAME" VARCHAR2(250 BYTE) VISIBLE,
      "SPOUSE_CNIC_ENC" VARCHAR2(40 BYTE) VISIBLE,
      "SPOUSE_CNIC" VARCHAR2(100 BYTE) VISIBLE,
      "FATHER_ROSTER_ID" NUMBER VISIBLE,
      "FATHER_NAME_ENC" VARCHAR2(250 BYTE) VISIBLE,
      "FATHER_NAME" VARCHAR2(250 BYTE) VISIBLE,
      "FATHER_CNIC_ENC" VARCHAR2(40 BYTE) VISIBLE,
      "FATHER_CNIC" VARCHAR2(100 BYTE) VISIBLE,
      "MOTHER_NAME_ENC" VARCHAR2(250 BYTE) VISIBLE,
      "MOTHER_NAME" VARCHAR2(250 BYTE) VISIBLE,
      "MOTHER_ROSTER_ID" NUMBER VISIBLE,
      "MOTHER_CNIC_ENC" VARCHAR2(30 BYTE) VISIBLE,
      "MOTHER_CNIC" VARCHAR2(100 BYTE) VISIBLE,
      "RELATION_TO_HOUSEHOLD_HEAD_STATUS" VARCHAR2(100 BYTE) VISIBLE,
      "GENDER" VARCHAR2(100 BYTE) VISIBLE,
      "DOB" VARCHAR2(100 BYTE) VISIBLE,
      "DOB_DATE" DATE VISIBLE,
      "AGE" NUMBER VISIBLE,
      "AGE_CALCULATION_TIMESTAMP" DATE VISIBLE,
      "MARITAL_STATUS_CODE" NUMBER VISIBLE,
      "MARITAL_STATUS" VARCHAR2(100 BYTE) VISIBLE,
      "SPOUSE_CODE" VARCHAR2(200 BYTE) VISIBLE,
      "MOTHER_CODE" NUMBER VISIBLE,
      "FATHER_CODE" NUMBER VISIBLE,
      "CNIC_OPTION" VARCHAR2(2 BYTE) VISIBLE,
      "ROSTER_RELATIONAL_ID" NUMBER VISIBLE,
      "DISABILITY_CODE" NUMBER VISIBLE,
      "DISABILITY_STATUS" VARCHAR2(100 BYTE) VISIBLE,
      "HAVING_CHRONIC_DISEASE_CODE" NUMBER VISIBLE,
      "HAVING_CHRONIC_DISEASE_STATUS" VARCHAR2(100 BYTE) VISIBLE,
      "IS_LITERATE" VARCHAR2(3 BYTE) VISIBLE,
      "GONE_TO_SCHOOL_CODE" NUMBER VISIBLE,
      "GONE_TO_SCHOOL_STATUS" VARCHAR2(100 BYTE) VISIBLE,
      "EDUCATION_LEVEL_CODE" NUMBER VISIBLE,
      "EDUCATION_LEVEL_STATUS" VARCHAR2(100 BYTE) VISIBLE,
      "WORK_STATUS_CODE" NUMBER VISIBLE,
      "WORK_STATUS" VARCHAR2(200 BYTE) VISIBLE,
      "LAST_WEEK_WORKING_HOURS" NUMBER VISIBLE,
      "EMPLOYMENT_CODE" NUMBER VISIBLE,
      "EMPLOYMENT_STATUS" VARCHAR2(200 BYTE) VISIBLE,
      "SURVEY_DATA_SOURCE" VARCHAR2(100 BYTE) VISIBLE,
      "INSERTION_TIMESTAMP" DATE VISIBLE,
      "FORM_NO" VARCHAR2(500 BYTE) VISIBLE,
      "UUID" VARCHAR2(200 BYTE) VISIBLE,
      "NAME_NADRA" VARCHAR2(400 BYTE) VISIBLE,
      "SPOUSE_NAME_NADRA" VARCHAR2(400 BYTE) VISIBLE,
      "FATHER_NAME_NADRA" VARCHAR2(400 BYTE) VISIBLE,
      "MARITAL_STATUS_NADRA" VARCHAR2(100 BYTE) VISIBLE,
      "GENDER_NADRA" VARCHAR2(100 BYTE) VISIBLE,
      "DOB_NADRA" VARCHAR2(100 BYTE) VISIBLE,
      "IS_DUP" VARCHAR2(20 BYTE) VISIBLE,
      "NADRA_UPDATED" VARCHAR2(20 BYTE) VISIBLE
    )
    LOGGING
    ROW STORE COMPRESS BASIC
    PCTFREE 10
    INITRANS 1
    STORAGE (
      INITIAL 65536 
      NEXT 1048576 
      MINEXTENTS 1
      MAXEXTENTS 2147483645
      BUFFER_POOL DEFAULT
    )
    PARALLEL 1
    NOCACHE
    ENABLE ROW MOVEMENT
    ;
    
    -- ----------------------------
    -- Records of NDEP_HOUSEHOLD_ROSTER
    -- ----------------------------
    INSERT INTO "MNASIR"."NDEP_HOUSEHOLD_ROSTER" VALUES ('30000003794103', '30000019580722', '3794103', '19580722', ' ', NULL, 'Manisha bibi', 'Manisha bibi', NULL, NULL, '187', NULL, 'shakir amin', NULL, '4250112313841', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'female', 'Dec 1, 1995', NULL, '22', NULL, '201', 'married', '1', '-3', '-3', '1', '2', '6', 'no disability', '15', 'no', 'no', '25', 'never', '0', NULL, '49', 'employers', '48', '56', 'seasonal wage employment / wage (non-agricultural)', 'pilot', TO_DATE('2017-12-07 20:43:50', 'SYYYY-MM-DD HH24:MI:SS'), '13932267', '1bbf596a-10f2-4326-94af-df6a843ef9cf', NULL, NULL, NULL, NULL, NULL, NULL, 'no', NULL);
    INSERT INTO "MNASIR"."NDEP_HOUSEHOLD_ROSTER" VALUES ('30000003794103', '30000019580723', '3794103', '19580723', ' ', NULL, 'Abhia bibi', 'Abhia bibi', NULL, NULL, '188', NULL, NULL, NULL, NULL, NULL, NULL, 'shakir amin', NULL, '4250112313841', NULL, 'nadia', NULL, NULL, NULL, NULL, 'female', 'Dec 1, 2015', NULL, '2', NULL, '200', 'unmarried', '-1', '2', '1', '-1', '3', '6', 'no disability', '15', 'no', ' ', '0', NULL, '0', NULL, '0', NULL, '0', '0', NULL, 'pilot', TO_DATE('2017-12-07 20:43:50', 'SYYYY-MM-DD HH24:MI:SS'), '13932267', '1bbf596a-10f2-4326-94af-df6a843ef9cf', NULL, NULL, NULL, NULL, NULL, NULL, 'no', NULL);
    INSERT INTO "MNASIR"."NDEP_HOUSEHOLD_ROSTER" VALUES ('30000003794103', '30000019580724', '3794103', '19580724', ' ', NULL, 'Noor bibi', 'Noor bibi', NULL, NULL, '188', NULL, NULL, NULL, NULL, NULL, NULL, 'shakir amin', NULL, '4250112313841', NULL, 'nadia', NULL, NULL, NULL, NULL, 'female', 'Jun 1, 2017', NULL, '0', NULL, '200', 'unmarried', '-1', '2', '1', '-1', '4', '6', 'no disability', '15', 'no', ' ', '0', NULL, '0', NULL, '0', NULL, '0', '0', NULL, 'pilot', TO_DATE('2017-12-07 20:43:50', 'SYYYY-MM-DD HH24:MI:SS'), '13932267', '1bbf596a-10f2-4326-94af-df6a843ef9cf', NULL, NULL, NULL, NULL, NULL, NULL, 'no', NULL);
    INSERT INTO "MNASIR"."NDEP_HOUSEHOLD_ROSTER" VALUES ('30000003794107', '30000019580736', '3794107', '19580736', ' ', NULL, 'Muhammad jawaid', 'Muhammad jawaid', NULL, NULL, '186', NULL, 'kawita', NULL, '4420686044084', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'head', 'male', 'Dec 1, 1992', NULL, '25', NULL, '201', 'married', '2', '-2', '-2', '1', '1', '6', 'no disability', '15', 'no', 'no', '25', 'never', '0', NULL, '49', 'employers', '48', '56', 'seasonal wage employment / wage (non-agricultural)', 'pilot', TO_DATE('2017-12-07 20:43:51', 'SYYYY-MM-DD HH24:MI:SS'), '13932299', 'e84e182b-29b9-4b77-ac13-ee940e4228c1', NULL, NULL, NULL, NULL, NULL, NULL, 'no', NULL);
    INSERT INTO "MNASIR"."NDEP_HOUSEHOLD_ROSTER" VALUES ('30000003794107', '30000019580738', '3794107', '19580738', ' ', NULL, 'Muhammad ayan ', 'Muhammad ayan', NULL, NULL, '188', NULL, NULL, NULL, NULL, NULL, NULL, 'ashok kumar', NULL, '4420622309489', NULL, 'kawita', NULL, NULL, '4420686044084', NULL, 'male', 'Jul 1, 2017', NULL, '0', NULL, '200', 'unmarried', '-1', '2', '1', '-1', '3', '6', 'no disability', '15', 'no', ' ', '0', NULL, '0', NULL, '0', NULL, '0', '0', NULL, 'pilot', TO_DATE('2017-12-07 20:43:51', 'SYYYY-MM-DD HH24:MI:SS'), '13932299', 'e84e182b-29b9-4b77-ac13-ee940e4228c1', NULL, NULL, NULL, NULL, NULL, NULL, 'no', NULL);
    INSERT INTO "MNASIR"."NDEP_HOUSEHOLD_ROSTER" VALUES ('30000003794208', '30000019581288', '3794208', '19581288', ' ', NULL, 'Muhammad Sajid', 'Muhammad Sajid', NULL, NULL, '188', NULL, NULL, NULL, NULL, NULL, NULL, 'Muhammad slaeem', NULL, '3110179846641', NULL, 'Bushra bibi', NULL, NULL, NULL, NULL, 'male', 'Dec 1, 2010', NULL, '7', NULL, '200', 'unmarried', '-1', '2', '1', '-1', '5', '6', 'no disability', '16', 'heart disease', ' ', '27', 'currently going (from people aged four years or older)', '28', 'less than first class', '0', NULL, '0', '0', NULL, 'pilot', TO_DATE('2017-12-07 20:46:55', 'SYYYY-MM-DD HH24:MI:SS'), '13561781', '22ae6d57-01aa-48d5-b422-92192b03571a', NULL, NULL, NULL, NULL, NULL, NULL, 'no', NULL);
    INSERT INTO "MNASIR"."NDEP_HOUSEHOLD_ROSTER" VALUES ('30000003794208', '30000019581289', '3794208', '19581289', ' ', NULL, 'Muhammad Rashid', 'Muhammad Rashid', NULL, NULL, '188', NULL, NULL, NULL, NULL, NULL, NULL, 'Muhammad slaeem', NULL, '3110179846641', NULL, 'Bushra bibi', NULL, NULL, NULL, NULL, 'male', 'Dec 1, 2012', NULL, '5', NULL, '200', 'unmarried', '-1', '2', '1', '-1', '6', '6', 'no disability', '15', 'no', ' ', '25', 'never', '0', NULL, '0', NULL, '0', '0', NULL, 'pilot', TO_DATE('2017-12-07 20:46:55', 'SYYYY-MM-DD HH24:MI:SS'), '13561781', '22ae6d57-01aa-48d5-b422-92192b03571a', NULL, NULL, NULL, NULL, NULL, NULL, 'no', NULL);
    INSERT INTO "MNASIR"."NDEP_HOUSEHOLD_ROSTER" VALUES ('30000003794216', '30000019581326', '3794216', '19581326', '31201-0347703-7', '3120103477037', 'Muhammad Ishaque', 'Muhammad Ishaque', NULL, NULL, '186', NULL, 'asifa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'head', 'male', 'Jan 1, 1968', NULL, '49', NULL, '201', 'married', '2', '-3', '-2', '2', '1', '6', 'no disability', '15', 'no', 'no', '25', 'never', '0', NULL, '49', 'employers', '36', '56', 'seasonal wage employment / wage (non-agricultural)', 'pilot', TO_DATE('2017-12-07 20:46:56', 'SYYYY-MM-DD HH24:MI:SS'), '13561381', 'e2cb40d7-09f6-4d27-ba08-771622bd7e1f', 'muhammad ishaq', 'shabiran', 'manzoor ahmad', 'married', 'male', '00-00-1968', 'no', NULL);
    INSERT INTO "MNASIR"."NDEP_HOUSEHOLD_ROSTER" VALUES ('30000003794216', '30000019581327', '3794216', '19581327', '31201-8867606-6', '3120188676066', 'Samira Bibi', 'Samira Bibi', NULL, NULL, '187', NULL, 'Muhammad ali', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'female', 'Jul 1, 1980', NULL, '37', NULL, '201', 'married', '1', '-3', '-3', '2', '2', '6', 'no disability', '15', 'no', 'no', '25', 'never', '0', NULL, '51', 'neither employment nor job seeker burden retired minutes, student, housewife, disability etc.', '0', '61', 'other', 'pilot', TO_DATE('2017-12-07 20:46:56', 'SYYYY-MM-DD HH24:MI:SS'), '13561381', 'e2cb40d7-09f6-4d27-ba08-771622bd7e1f', 'sumairan bibi', 'muhammad ishaq', 'lalo khan', 'married', 'female', '01-01-1981', 'no', NULL);
    INSERT INTO "MNASIR"."NDEP_HOUSEHOLD_ROSTER" VALUES ('30000003794225', '30000019581371', '3794225', '19581371', '31201-2863055-8', '3120128630558', 'Momina bibi', 'Momina bibi', NULL, NULL, '193', NULL, 'Hurmi', NULL, '4410386977168', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'son-in-law', 'female', 'Jan 1, 1975', NULL, '42', NULL, '201', 'married', '2', '-3', '-2', '2', '3', '6', 'no disability', '15', 'no', 'no', '25', 'never', '0', NULL, '51', 'neither employment nor job seeker burden retired minutes, student, housewife, disability etc.', '0', '61', 'other', 'pilot', TO_DATE('2017-12-07 20:46:56', 'SYYYY-MM-DD HH24:MI:SS'), '13805398', '0efcd3c6-0f42-4fa6-a158-ee2938cf8184', 'momina bibi', 'muhammad akmal', 'kalo khan', 'married', 'female', '01-01-1975', 'no', NULL);
    
    -- ----------------------------
    -- Table structure for NDEP_HOUSEHOLD_ROSTER_HIS
    -- ----------------------------
    DROP TABLE "MNASIR"."NDEP_HOUSEHOLD_ROSTER_HIS";
    CREATE TABLE "MNASIR"."NDEP_HOUSEHOLD_ROSTER_HIS" (
      "UNIQUE_HH_ID" NUMBER VISIBLE,
      "UNIQUE_R_ID" NUMBER VISIBLE,
      "ENUMERATOR_SURVEY_ID" NUMBER VISIBLE,
      "R_ID" NUMBER VISIBLE,
      "CNIC_ENC" VARCHAR2(250 BYTE) VISIBLE,
      "CNIC" VARCHAR2(150 BYTE) VISIBLE,
      "HOUSEHOLD_MEMBER_NAMES_ENC" VARCHAR2(250 BYTE) VISIBLE,
      "HOUSEHOLD_MEMBER_NAMES" VARCHAR2(250 BYTE) VISIBLE,
      "HOUSEHOLD_HEAD_NAME_ENC" VARCHAR2(128 BYTE) VISIBLE,
      "HOUSEHOLD_HEAD_NAME" VARCHAR2(128 BYTE) VISIBLE,
      "RELATION_TO_HOUSEHOLD_HEAD" NUMBER VISIBLE,
      "SPOUSE_NAME_ENC" VARCHAR2(250 BYTE) VISIBLE,
      "SPOUSE_NAME" VARCHAR2(250 BYTE) VISIBLE,
      "SPOUSE_CNIC_ENC" VARCHAR2(40 BYTE) VISIBLE,
      "SPOUSE_CNIC" VARCHAR2(100 BYTE) VISIBLE,
      "FATHER_ROSTER_ID" NUMBER VISIBLE,
      "FATHER_NAME_ENC" VARCHAR2(250 BYTE) VISIBLE,
      "FATHER_NAME" VARCHAR2(250 BYTE) VISIBLE,
      "FATHER_CNIC_ENC" VARCHAR2(40 BYTE) VISIBLE,
      "FATHER_CNIC" VARCHAR2(100 BYTE) VISIBLE,
      "MOTHER_NAME_ENC" VARCHAR2(250 BYTE) VISIBLE,
      "MOTHER_NAME" VARCHAR2(250 BYTE) VISIBLE,
      "MOTHER_ROSTER_ID" NUMBER VISIBLE,
      "MOTHER_CNIC_ENC" VARCHAR2(30 BYTE) VISIBLE,
      "MOTHER_CNIC" VARCHAR2(100 BYTE) VISIBLE,
      "RELATION_TO_HOUSEHOLD_HEAD_STATUS" VARCHAR2(100 BYTE) VISIBLE,
      "GENDER" VARCHAR2(100 BYTE) VISIBLE,
      "DOB" VARCHAR2(100 BYTE) VISIBLE,
      "DOB_DATE" DATE VISIBLE,
      "AGE" NUMBER VISIBLE,
      "AGE_CALCULATION_TIMESTAMP" DATE VISIBLE,
      "MARITAL_STATUS_CODE" NUMBER VISIBLE,
      "MARITAL_STATUS" VARCHAR2(100 BYTE) VISIBLE,
      "SPOUSE_CODE" VARCHAR2(200 BYTE) VISIBLE,
      "MOTHER_CODE" NUMBER VISIBLE,
      "FATHER_CODE" NUMBER VISIBLE,
      "CNIC_OPTION" VARCHAR2(2 BYTE) VISIBLE,
      "ROSTER_RELATIONAL_ID" NUMBER VISIBLE,
      "DISABILITY_CODE" NUMBER VISIBLE,
      "DISABILITY_STATUS" VARCHAR2(100 BYTE) VISIBLE,
      "HAVING_CHRONIC_DISEASE_CODE" NUMBER VISIBLE,
      "HAVING_CHRONIC_DISEASE_STATUS" VARCHAR2(100 BYTE) VISIBLE,
      "IS_LITERATE" VARCHAR2(3 BYTE) VISIBLE,
      "GONE_TO_SCHOOL_CODE" NUMBER VISIBLE,
      "GONE_TO_SCHOOL_STATUS" VARCHAR2(100 BYTE) VISIBLE,
      "EDUCATION_LEVEL_CODE" NUMBER VISIBLE,
      "EDUCATION_LEVEL_STATUS" VARCHAR2(100 BYTE) VISIBLE,
      "WORK_STATUS_CODE" NUMBER VISIBLE,
      "WORK_STATUS" VARCHAR2(200 BYTE) VISIBLE,
      "LAST_WEEK_WORKING_HOURS" NUMBER VISIBLE,
      "EMPLOYMENT_CODE" NUMBER VISIBLE,
      "EMPLOYMENT_STATUS" VARCHAR2(200 BYTE) VISIBLE,
      "SURVEY_DATA_SOURCE" VARCHAR2(100 BYTE) VISIBLE,
      "INSERTION_TIMESTAMP" DATE VISIBLE,
      "FORM_NO" VARCHAR2(500 BYTE) VISIBLE,
      "UUID" VARCHAR2(200 BYTE) VISIBLE,
      "NAME_NADRA" VARCHAR2(400 BYTE) VISIBLE,
      "SPOUSE_NAME_NADRA" VARCHAR2(400 BYTE) VISIBLE,
      "FATHER_NAME_NADRA" VARCHAR2(400 BYTE) VISIBLE,
      "MARITAL_STATUS_NADRA" VARCHAR2(100 BYTE) VISIBLE,
      "GENDER_NADRA" VARCHAR2(100 BYTE) VISIBLE,
      "DOB_NADRA" VARCHAR2(100 BYTE) VISIBLE,
      "IS_DUP" VARCHAR2(20 BYTE) VISIBLE
    )
    LOGGING
    ROW STORE COMPRESS BASIC
    PCTFREE 10
    INITRANS 1
    STORAGE (
      INITIAL 65536 
      NEXT 1048576 
      MINEXTENTS 1
      MAXEXTENTS 2147483645
      BUFFER_POOL DEFAULT
    )
    PARALLEL 1
    NOCACHE
    ENABLE ROW MOVEMENT
    ;
    
    -- ----------------------------
    -- Records of NDEP_HOUSEHOLD_ROSTER_HIS
    -- ----------------------------
    INSERT INTO "MNASIR"."NDEP_HOUSEHOLD_ROSTER_HIS" VALUES ('30000001673486', '30000008708330', '1673486', '8708330', '32202-4968821-5', '3220249688215', 'Zulafqar', 'Zulafqar', NULL, NULL, '186', NULL, 'zuhra', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'head', 'male', '1 Jan 1970', NULL, '47', NULL, '201', 'married', '2', '-3', '-3', '2', '1', '6', 'no disability', '15', 'no', 'no', '25', 'never', '0', NULL, '50', 'unemployed but looking for a job', '0', '56', 'seasonal wage employment / wage (non-agricultural)', 'pilot', TO_DATE('2017-05-26 21:02:19', 'SYYYY-MM-DD HH24:MI:SS'), '11812654', '2d96259d-bea6-4220-8117-49a7991734f6', 'zulfiqar', 'sharifan mai', 'allah wasaya', 'married', 'male', '01-01-1970', 'no');
    INSERT INTO "MNASIR"."NDEP_HOUSEHOLD_ROSTER_HIS" VALUES ('30000002391612', '30000012290821', '2391612', '12290821', '32203-1938854-0', '3220319388540', 'Fatima Bibi', 'Fatima Bibi', NULL, NULL, '190', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'father', 'female', '1 Jan 1958', NULL, '59', NULL, '202', 'widow', '-1', '-3', '-2', '2', '4', '6', 'no disability', '15', 'no', 'no', '25', 'never', '0', NULL, '51', 'neither employment nor job seeker burden retired minutes, student, housewife, disability etc.', '0', '61', 'other', 'pilot', TO_DATE('2017-07-13 18:09:20', 'SYYYY-MM-DD HH24:MI:SS'), '13248869', 'fac3c877-69bc-47c9-ae65-5e1f301b78fa', 'fatima bibi', 'imam bux', 'faiz ahmad', 'married', 'female', '00-00-1958', 'no');
    INSERT INTO "MNASIR"."NDEP_HOUSEHOLD_ROSTER_HIS" VALUES ('30000002408915', '30000012378281', '2408915', '12378281', '21406-9515390-3', '2140695153903', 'Muhammad Khan', 'Muhammad Khan', NULL, NULL, '186', NULL, 'Shereen', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'head', 'male', 'Jan 1, 1990', NULL, '27', NULL, '201', 'married', '2', '-3', '-3', '2', '1', '6', 'no disability', '15', 'no', 'no', '25', 'never', '0', NULL, '51', 'neither employment nor job seeker burden retired minutes, student, housewife, disability etc.', '0', '56', 'seasonal wage employment / wage (non-agricultural)', 'pilot', TO_DATE('2017-07-14 15:56:55', 'SYYYY-MM-DD HH24:MI:SS'), '11160918', '87b5d31c-fb26-4c11-9102-24b95b6b4c9f', 'muhammad khan', 'saeeda', 'gul jan', 'married', 'male', '01-01-1990', 'no');
    INSERT INTO "MNASIR"."NDEP_HOUSEHOLD_ROSTER_HIS" VALUES ('30000002408919', '30000012378306', '2408919', '12378306', '21406-7793939-2', '2140677939392', 'Fashmina Bibi', 'Fashmina Bibi', NULL, NULL, '187', NULL, 'Parwiz Ail', NULL, '5210310607803', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'female', 'Jan 1, 1974', NULL, '43', NULL, '201', 'married', '1', '-3', '-3', '2', '2', '6', 'no disability', '15', 'no', 'no', '25', 'never', '0', NULL, '50', 'unemployed but looking for a job', '0', '59', 'co-worker / helper in unpaid family profession)', 'pilot', TO_DATE('2017-07-14 15:56:56', 'SYYYY-MM-DD HH24:MI:SS'), '11160923', 'a19f2d02-3454-440f-95b3-4d73ef8504fc', 'pashmina bibi', 'ajmal khan', 'muhammad aziz', 'married', 'female', '00-00-1974', 'no');
    INSERT INTO "MNASIR"."NDEP_HOUSEHOLD_ROSTER_HIS" VALUES ('30000002418861', '30000012428654', '2418861', '12428654', '41407-5523777-9', '4140755237779', 'Qasim Chandyo ', 'Qasim Chandyo', NULL, NULL, '186', NULL, 'parie', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'head', 'male', 'Jan 1, 1994', NULL, '23', NULL, '201', 'married', '2', '-3', '-3', '2', '1', '6', 'no disability', '15', 'no', 'no', '25', 'never', '0', NULL, '49', 'employers', '48', '56', 'seasonal wage employment / wage (non-agricultural)', 'pilot', TO_DATE('2017-07-14 22:26:39', 'SYYYY-MM-DD HH24:MI:SS'), '14163854', '24d9674e-4832-416c-8cea-6d1de554831f', NULL, NULL, NULL, NULL, NULL, NULL, 'no');
    INSERT INTO "MNASIR"."NDEP_HOUSEHOLD_ROSTER_HIS" VALUES ('30000000049289', '30000000227569', '49289', '227569', '17101-0331575-9', '1710103315759', 'fazlerahman', 'fazlerahman', NULL, NULL, '186', NULL, 'Tahir Abbas', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'head', 'male', 'Apr 4, 1980', NULL, '37', NULL, '201', 'married', '2', '-1', '-2', '2', '1', '6', 'no disability', '15', 'no', 'yes', '26', 'has been in the past', '38', 'tenth', '50', 'unemployed but looking for a job', '0', '217', 'unemployed', 'pilot', TO_DATE('2017-03-02 09:16:51', 'SYYYY-MM-DD HH24:MI:SS'), '11137009', 'c2271b0c-2085-49c2-a358-49a04930a7eb', 'fazal rehman', NULL, 'abdul karim', 'married', 'male', '01-04-1980', 'no');
    INSERT INTO "MNASIR"."NDEP_HOUSEHOLD_ROSTER_HIS" VALUES ('30000000049289', '30000000227570', '49289', '227570', '17101-7603158-0', '1710176031580', 'Abida', 'Abida', NULL, NULL, '187', NULL, 'Shehnaz Tahir', NULL, '3130281673584', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'female', 'Jan 1, 1987', NULL, '30', NULL, '201', 'married', '1', '-3', '-2', '2', '2', '6', 'no disability', '15', 'no', 'no', '25', 'never', '0', NULL, '50', 'unemployed but looking for a job', '0', '217', 'unemployed', 'pilot', TO_DATE('2017-03-02 09:16:51', 'SYYYY-MM-DD HH24:MI:SS'), '11137009', 'c2271b0c-2085-49c2-a358-49a04930a7eb', 'abida', 'fazal rehman', 'bahadar khan', 'married', 'female', '01-01-1987', 'no');
    INSERT INTO "MNASIR"."NDEP_HOUSEHOLD_ROSTER_HIS" VALUES ('30000000170954', '30000000843702', '170954', '843702', '32202-2440992-6', '3220224409926', 'Banaizeer ', 'Banaizeer', NULL, NULL, '187', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'female', '1 Jan 1960', NULL, '57', NULL, '201', 'married', '-1', '-1', '-2', '2', '2', '6', 'no disability', '18', 'asthma', 'no', '25', 'never', '0', NULL, '50', 'unemployed but looking for a job', '0', '217', 'unemployed', 'pilot', TO_DATE('2017-03-14 09:10:20', 'SYYYY-MM-DD HH24:MI:SS'), '13105026', 'fff4a097-7f96-47fd-8bf0-fa67f6cc9f30', 'benazir', 'haq nawaz', NULL, 'married', 'female', '00-00-1960', 'no');
    INSERT INTO "MNASIR"."NDEP_HOUSEHOLD_ROSTER_HIS" VALUES ('30000000174199', '30000000860786', '174199', '860786', '43102-8336297-3', '4310283362973', 'akbar ali', 'akbar ali', NULL, NULL, '186', NULL, 'Shezana Munir', NULL, '3420160232222', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'head', 'male', 'Jun 29, 1984', NULL, '33', NULL, '201', 'married', '2', '-1', '-2', '2', '1', '6', 'no disability', '15', 'no', 'yes', '27', 'currently going (from people aged four years or older)', '40', 'fa / fsc / icom', '51', 'neither employment nor job seeker burden retired minutes, student, housewife, disability etc.', '0', '56', 'seasonal wage employment / wage (non-agricultural)', 'pilot', TO_DATE('2017-03-14 18:46:00', 'SYYYY-MM-DD HH24:MI:SS'), '14336219', 'ee1d97e7-003a-4e96-ab4c-03fa8ecd2615', 'akbar ali', NULL, 'jamal khan', 'unmarried', 'male', '29-06-1984', 'no');
    INSERT INTO "MNASIR"."NDEP_HOUSEHOLD_ROSTER_HIS" VALUES ('30000002351064', '30000012082710', '2351064', '12082710', '32203-1784560-3', '3220317845603', 'Muhammad Aziz ', 'Muhammad Aziz', NULL, NULL, '186', NULL, 'Ghulam batola', NULL, '4120561529630', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'head', 'male', '1 Jan 1973', NULL, '44', NULL, '201', 'married', '2', '-3', '-3', '2', '1', '6', 'no disability', '15', 'no', 'no', '25', 'never', '0', NULL, '49', 'employers', '48', '56', 'seasonal wage employment / wage (non-agricultural)', 'pilot', TO_DATE('2017-07-11 10:23:51', 'SYYYY-MM-DD HH24:MI:SS'), '13195340', '892dbe84-9bb6-4a6b-b767-012e1156b84e', 'muhammad aziz', 'uzma bibi', 'abdul rehman', 'married', 'male', '00-00-1973', 'no');

MichaelG
User
Posts: 779

Post by MichaelG »

I created the two tables in Oracle and they can be loaded without any problems. The issue was probably not related to the table schema provided.


muttou
User
Posts: 103

Post by muttou »

Sound great. did u check it with data? hope it will work on my local machine where i will be out of privileges and secure network. this will be last test on my end. Hope after that will go for the purchase . one more thing needs to know. when new release will be expected along with new features. if its not bother you.

thank you once again for overall efforts and cooperation .


MichaelG
User
Posts: 779

Post by MichaelG »

Yes, data is imported and the schema can be loaded without any problem.


Post Reply