topic Re: problem loading script. in QlikView

problem loading script.

Wed, 01 Jul 2015 05:33:59 GMT

Hi Qlikcommunity,

I reload my script after i edit it and it seems after 1 min and 3 sec this what happen, It stack to this (image below), then after 20-30min it error and said Error loading Script.

Please Help me,

Re: problem loading script.

PrashantSangle — Wed, 01 Jul 2015 05:46:29 GMT

Hi,

See document Log.

Regards

Re: problem loading script.

anat — Wed, 01 Jul 2015 05:50:31 GMT

HI ,

Debug your script,then you come to know where is the problem.

Re: problem loading script.

Wed, 01 Jul 2015 05:54:32 GMT

Hi ananth,

It doesn't have any error, I just stack after i Reload my script.

Re: problem loading script.

hariprasadqv — Wed, 01 Jul 2015 05:57:42 GMT

Hi,

Generate log file from document properties and look into that. Mostly sythatic keys and Circulr references or conncetion pooling will cause this issue along with sytactical difects.

Thanks

Re: problem loading script.

Wed, 01 Jul 2015 06:00:39 GMT

Hi Benedict,

Can you check your qvd size or debug ur code u will know error where it is exact.

Ramya.

Re: problem loading script.

Kushal_Chawda — Wed, 01 Jul 2015 06:04:57 GMT

May be Joining filed is missing.check your key field for joining tables.

Re: problem loading script.

anat — Wed, 01 Jul 2015 06:08:47 GMT

can you sent screen of your table viewer(may be sythatic keys and Circulr references),try to remove circular references by creating composite key.

Re: problem loading script.

MayilVahanan — Wed, 01 Jul 2015 06:10:30 GMT

I think, cross join happening in your case. Please check the link between the tables. Or post the script. It helps to find out the error.

Re: problem loading script.

Wed, 01 Jul 2015 06:15:55 GMT

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$#,##0.00;($#,##0.00)';

SET TimeFormat='h:mm:ss TT';

SET DateFormat='M/D/YYYY';

SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

//Input and update

//TAX Database

ODBC CONNECT32 TO tax (XUserId is SAWHaZFPTDcEXXdMSLZGXZFM, XPassword is EQRaZYAD);

Collectible:

LOAD pin,

"prop-type",

"user_id",

remarks,

todate,

"prev-assess",

"curr-assess",

year,

qtr,

"basic_sef",

tin,

"penalty-bal",

qtr2,

"disc-bal",

compro,

"mode",

"time_stamp",

PCINum,

MDINum,

BINum,

SINum,

Parcel,

PType,

RPUNum,

OwnerNum,

Basic,

SEF,

AssmtCount,

"Rev-Yr",

IdleTax;

SQL SELECT *

FROM PUB.collectible;

Store Collectible into C:\Users\SAMSUNG\Desktop\Qlikview - Allyssa\LAST QVD\Collectible.qvd;

OrFile:

LOAD ornum,

ordate,

payee,

"c-code",

BasicTax,

SEFTax,

IdleTax,

BasicPen,

SEFPen,

IdlePen,

BasicDis,

SEFDis,

IdleDis,

TotalDis,

TotalTax,

TotalPen,

TotalPay,

CancFlag,

"user_code",

"date_posted",

"time_posted",

BankName,

CheckNo,

CheckDate,

CheckAmt,

CashAmt,

remarks,

"abs-date",

"abs-no";

SQL SELECT *

FROM PUB.orfile;

Store OrFile into C:\Users\SAMSUNG\Desktop\Qlikview - Allyssa\LAST QVD\OrFile.qvd;

Payment:

LOAD pin,

"prop-type",

ornum,

ordate,

"user_id",

remarks,

checknum,

tin,

mcode,

bcode,

payee,

bankname,

checkdate,

todate,

discount,

penalty,

"prev-assess",

"curr-assess",

year1,

year2,

qtr1,

qtr2,

VOS,

"basic_sef",

tdno,

cancelled,

partial,

"abs-date",

compro,

"mode",

"time_stamp",

"c-code",

PCINum,

MDINum,

BINum,

SINum,

Parcel,

PType,

RPUNum,

OwnerNum,

"Discount_Basic",

"Discount_SEF",

"Penalty_Basic",

"Penalty_SEF",

Basic,

SEF,

AssmtCount,

"Rev-Yr",

"tc-amount",

ornumber,

taxcredit,

"Penalty_Idle",

"Discount_Idle",

TotalPay,

IdleTax,

"abs-no";

SQL SELECT *

FROM PUB.payment;

Store Payment into C:\Users\SAMSUNG\Desktop\Qlikview - Allyssa\LAST QVD\Payment.qvd;

PenaltyRate:

LOAD yr,

rate,

qtr,

taxyear;

SQL SELECT *

FROM PUB."penalty-rate";

Store PenaltyRate into C:\Users\SAMSUNG\Desktop\Qlikview - Allyssa\LAST QVD\PenaltyRate.qvd;

//sysdb Database

ODBC CONNECT32 TO sysdb (XUserId is GfMFbZFPTDcEXXdMSLZGXZdD, XPassword is XOdYQYER);

AcctForm:

LOAD stubno,

"cust_recvdate",

"orfm_ornum",

"orto_ornum",

"cust_issuedate",

"c-code",

"or_count";

SQL SELECT *

FROM PUB.acctform;

Store AcctForm into C:\Users\SAMSUNG\Desktop\Qlikview - Allyssa\LAST QVD\AcctForm.qvd;

Aword:

LOAD val,

word;

SQL SELECT *

FROM PUB.aword;

Store Aword into C:\Users\SAMSUNG\Desktop\Qlikview - Allyssa\LAST QVD\Aword.qvd;

Collect:

LOAD "c-code",

name,

designation;

SQL SELECT *

FROM PUB.collect;

Store Collect into C:\Users\SAMSUNG\Desktop\Qlikview - Allyssa\LAST QVD\Collect.qvd;

MenuFile:

LOAD "menu_order",

"menu_level",

"menu_obj",

"menu_program",

"menu_cat",

"menu_label",

"init_access";

SQL SELECT *

FROM PUB.menufile;

Store MenuFile into C:\Users\SAMSUNG\Desktop\Qlikview - Allyssa\LAST QVD\MenuFile.qvd;

UserProg:

LOAD "user_code",

"module_code",

"view_flag",

"create_flag",

"edit_flag",

"cancel_flag",

"delete_flag",

"process_flag",

"generate_flag",

"seq_no";

SQL SELECT *

FROM PUB.userprog;

Store UserProg into C:\Users\SAMSUNG\Desktop\Qlikview - Allyssa\LAST QVD\UserProg.qvd;

//tempdb Database

ODBC CONNECT32 TO tempdb (XUserId is YZESaZFPTDcEXXdMSLZGXZBZ, XPassword is PFbNUYIC);

AbsClass:

LOAD "tax_type",

ccode,

crank,

"curr_tax",

"curr_dis",

"curr_net",

"curr_pen",

"prec_tax",

"prec_pen",

"prev_tax",

"prev_pen",

"prev_taxsub",

"prev_pensub",

"currmo_coll",

"brgy_share",

"prevmo_coll",

"total_coll",

"class_type",

Name;

SQL SELECT *

FROM PUB.AbsClass;

Store AbsClass into C:\Users\SAMSUNG\Desktop\Qlikview - Allyssa\LAST QVD\AbsClass.qvd;

Abstract:

LOAD pcinum,

mdinum,

binum,

sinum,

parcel,

pType,

ordate,

ornum,

pin,

owner,

brgy,

"curr_assval",

"lot_no",

"yr_from",

"yr_to",

"adv_tax",

"curr_taxwdis",

"curr_taxodis",

"prec_tax",

"prev_tax",

"gross_coll",

"curr_disc",

"adv_disc",

"net_coll",

"tax_code",

"curr_pen",

"prec_pen",

"prev_pen",

"abs-date";

SQL SELECT *

FROM PUB.Abstract;

Store Abstract into C:\Users\SAMSUNG\Desktop\Qlikview - Allyssa\LAST QVD\Abstract.qvd;

BrgyShare:

LOAD BrgyCode,

BrgyName,

AdvPay,

CurrYrD,

CurrYrW,

PrecYr,

PrevYr,

CurrPen,

PrecPen,

PrevPen,

GrossC,

CurrDisc,

AdvDisc,

TotColl,

"gen_fund",

"brgy_share",

"brgy_50p",

"brgy_30p",

"brgy_total",

"brgy_50pA",

"brgy_50pO",

"brgy_30pA",

"brgy_30pO",

"brgy_totalA",

"brgy_totalO";

SQL SELECT *

FROM PUB.BrgyShare;

Store BrgyShare into C:\Users\SAMSUNG\Desktop\Qlikview - Allyssa\LAST QVD\BrgyShare.qvd;

DelinqFile:

LOAD pcinum,

mdinum,

binum,

sinum,

parcel,

pType,

owner,

"pin-short",

address1,

address2,

lotno,

assdval,

"yr_fm",

"yr_to",

taxdue,

pendue,

discdue,

totdue,

location,

arp,

propClass,

"area",

tctno,

Qtr1,

Qtr2;

SQL SELECT *

FROM PUB.delinqfile;

Store DelinqFile into C:\Users\SAMSUNG\Desktop\Qlikview - Allyssa\LAST QVD\DelinqFile.qvd;

Delsumm:

LOAD "brgy_code",

"brgy_name",

"rpu_cnt",

"rpu_taxable",

"rpu_exempt",

"rpu_delinq",

"rpu_per",

"tot_basic",

"tot_sef",

"tot_idle",

"tot_taxdue",

"tot_recv",

"tot_basicpen",

"tot_sefpen",

"tot_idlepen",

"tot_pendue",

"tot_amtdue",

"del_per",

"tot_del";

SQL SELECT *

FROM PUB.DelSumm;

Store Delsumm into C:\Users\SAMSUNG\Desktop\Qlikview - Allyssa\LAST QVD\Delsumm.qvd;

OrptFile:

LOAD seqno,

"prt_detail",

owner,

location,

lotno,

PIN,

instlno,

"assval_land",

"assval_imp",

basictax,

basicpen,

seftax,

sefpen,

totaldue;

SQL SELECT *

FROM PUB.orptfile;

Store OrptFile into C:\Users\SAMSUNG\Desktop\Qlikview - Allyssa\LAST QVD\OrptFile.qvd;

Pastdue:

LOAD pin,

assmtcnt,

lotno,

totarea,

proptype,

propclass,

propdesc,

assval,

ownernum,

oname,

lastpaid,

lpaidyr,

lpaidqtr,

lpaydesc,

lcollyr,

lcollqtr,

lcollyr2,

lcollqtr2,

lcolldesc,

basicdue,

sefdue,

idledue,

taxdue,

basicpen,

sefpen,

idlepen,

pendue,

totdue,

yrsdel,

mval,

titleno;

SQL SELECT *

FROM PUB.pastdue;

Store Pastdue into C:\Users\SAMSUNG\Desktop\Qlikview - Allyssa\LAST QVD\Pastdue.qvd;

RaaFile:

LOAD "tran_code",

"beg_fmor",

"beg_toor",

"beg_qty",

"rec_fmor",

"rec_toor",

"rec_qty",

"iss_fmor",

"iss_toor",

"iss_qty",

collname,

"end_fmor",

"end_toor",

"end_qty";

SQL SELECT *

FROM PUB.raafile;

Store RaaFile into C:\Users\SAMSUNG\Desktop\Qlikview - Allyssa\LAST QVD\RaaFile.qvd;

Rptar:

LOAD refdate,

refnum,

"assess-count",

"year-from",

"qtr-from",

"year-to",

"qtr-to",

"basic_tax",

"basic_penalty",

"basic_discount",

"sef_tax",

"sef_penalty",

"sef_discount",

"total_tax",

"total_penalty",

"total_discount",

"assess-value",

"total_paid";

SQL SELECT *

FROM PUB.rptar;

Store Rptar into C:\Users\SAMSUNG\Desktop\Qlikview - Allyssa\LAST QVD\Rptar.qvd;

TaxNotice:

LOAD YearType,

nyear,

nQtrFm,

nQtrTo,

nPeriod,

nArp,

nAssVal,

nBasTax,

nBasNet,

nSEFTax,

nSEFNet,

nIdleTax,

nIdleNet,

nTotal;

SQL SELECT *

FROM PUB.TaxNotice;

Store TaxNotice into C:\Users\SAMSUNG\Desktop\Qlikview - Allyssa\LAST QVD\TaxNotice.qvd;

TempSysparam:

LOAD "sys_lgutype",

"sys_provcode",

"sys_citycode",

"sys_muncode",

"sys_distcode",

"sys_provname",

"sys_cityname",

"sys_muniname",

"sys_provtreas",

"sys_currtrn",

"sys_ovrdate",

"sys_update",

"sys_reprint",

"sys_citytreas",

"sys_muntreas",

"sys_formcust",

"sys_custpos",

"sys_directory";

SQL SELECT *

FROM PUB."temp-sysparam";

Store TempSysparam into C:\Users\SAMSUNG\Desktop\Qlikview - Allyssa\LAST QVD\TempSysparam.qvd;

//Prop database

ODBC CONNECT32 TO prop (XUserId is UcMBYZFPTDcEXXdMSLZGXZNT, XPassword is GaEUSZFPTDcEXXdMSLZGXZdK);

AssLevel:

LOAD "prop-type",

classif,

description,

asslev,

Code,

yr;

SQL SELECT *

FROM PUB."ASS-LEVEL";

Store AssLevel into C:\Users\SAMSUNG\Desktop\Qlikview - Allyssa\LAST QVD\AssLevel.qvd;

BldgAssmt:

LOAD pin,

effectivity,

classif,

storey,

"area",

"area-comp",

"unit-val",

asslev,

"area-length",

"area-width",

"use-type-code",

depreciation,

"prop-type",

remarks,

cancelled,

yr,

"d-compltd",

"bldg-type",

"NPaint-Rate",

"SHM-Rate",

NR,

"eco-life",

mvalue,

"uval-yr",

"d-rate",

"e-count",

colum,

beams,

floorjt,

roof,

partition,

flooring,

ceiling,

windows,

doors,

elect,

numtb,

paint,

"paint-c",

"ex-walls",

"roof-frm",

founda,

"wall-fin",

dom,

pcount,

"entry_date",

"mode",

PCINum,

MDINum,

BINum,

SINum,

Parcel,

PType,

CCode,

AUCode,

Stairs,

TBath,

Plumbing;

SQL SELECT *

FROM PUB."Bldg-ASSMT";

Store BldgAssmt into C:\Users\SAMSUNG\Desktop\Qlikview - Allyssa\LAST QVD\BldgAssmt.qvd;

Brgy:

LOAD PCINum,

MDINum,

BINum,

BrgyName;

SQL SELECT *

FROM PUB.Brgy;

Store Brgy into C:\Users\SAMSUNG\Desktop\Qlikview - Allyssa\LAST QVD\Brgy.qvd;

LandAssmt:

LOAD pin,

effectivity,

classif,

Kind,

"area",

classrnk,

"unit-val",

adjmt,

asslev,

width,

remarks,

"corner-inf",

"UNDEVELOP-LVA",

taxability,

"prop-type",

Mcode,

mvalue,

depth,

cancelled,

yr,

"strip_area",

ctr,

NR,

"uval-yr",

"dst-pobl",

"dst-weath",

pcount,

"lva-pobl",

"lva-rdfrt",

"lva-weat",

kind2,

"entry_date",

"mode",

CRClassif,

WRF,

WSA,

Testat,

PCINum,

MDINum,

BINum,

SINum,

Parcel,

PType,

CCode,

AUCode,

ClassifType,

"dst-rdfrt";

SQL SELECT *

FROM PUB."Land-ASSMT";

Store LandAssmt into C:\Users\SAMSUNG\Desktop\Qlikview - Allyssa\LAST QVD\LandAssmt.qvd;

LandMV:

LOAD Kind,

"mv-kind",

unit,

classif,

treecode,

Mcode,

yr,

ZoneNum;

SQL SELECT *

FROM PUB."Land-MV";

Store LandMV into C:\Users\SAMSUNG\Desktop\Qlikview - Allyssa\LAST QVD\LandMV.qvd;

MTSRep:

LOAD YrOf,

MOf,

PCINum,

MDINum,

BINum,

Taxable,

RCode,

RPUs

Classif,

Cancelled,

"Area",

LMVal,

BMVal175B,

BMVal175U,

MMVal,

IMVal,

LAVal,

BAVal175B,

BAVal175U,

MAVal,

IAVal,

CutOff;

SQL SELECT *

FROM PUB.MTSRep;

Store MTSRep into C:\Users\SAMSUNG\Desktop\Qlikview - Allyssa\LAST QVD\MTSRep.qvd;

Owner:

LOAD tin,

tctno,

owner,

address,

admin,

address2,

"telno-1",

"telno-2",

lotno,

"c-status",

spouse,

"et_al",

others,

"mode",

"entry_date",

BIRTin,

AdmTin,

OwnerNum,

AdmNum;

SQL SELECT *

FROM PUB.Owner;

Store Owner into C:\Users\SAMSUNG\Desktop\Qlikview - Allyssa\LAST QVD\Owner.qvd;

Property:

LOAD pin,

tin,

assdate,

"prop-type",

arp,

cancelled,

"total-area",

"tot-assess",

lotno,

tctno,

tcode,

pcode,

Mcode,

bcode,

scode,

asslot,

"entry_date",

taxability,

classrnk,

demolished,

"new-assval",

yr,

Marketval,

NR,

remarks,

prevpin,

revnum,

pcount,

"mode",

Approved,

"Date_apprvd",

remote,

PCINum,

MDINum,

BINum,

SINum,

Parcel,

PType,

RPUNum,

"rev-yr",

BCCT,

TctDate,

AdmNum,

Qtr,

AssmtCount,

OwnerNum,

DateCancelled,

LBNum,

CBRpunum,

CBYr,

CBPCount,

Inactive,

Mortgage,

PTagNum,

PTagInfo,

Signatory,

SPos,

SDate;

SQL SELECT *

FROM PUB.Property;

Store Property into C:\Users\SAMSUNG\Desktop\Qlikview - Allyssa\LAST QVD\Property.qvd;

Qrep:

LOAD Mcode,

bcode,

QYr,

Quarter,

Taxable,

RCode,

RPUs,

"Area",

LMVal,

BMVal175B,

BMVal175U,

MMVal,

IMVal,

LAVal,

BAVal175B,

BAVal175U,

MAVal,

IAVal,

Classif,

PCINum,

MDINum,

BINum,

PKRpus,

Carpav,

Uliqav,

Oprav;

SQL SELECT *

FROM PUB.QRep;

Store Qrep into C:\Users\SAMSUNG\Desktop\Qlikview - Allyssa\LAST QVD\Qrep.qvd;

RevYear:

LOAD "rev-yr",

year1,

year2;

SQL SELECT *

FROM PUB.revyear;

Store RevYear into C:\Users\SAMSUNG\Desktop\Qlikview - Allyssa\LAST QVD\RevYear.qvd;

RPClass:

LOAD Kind,

description,

SubCode;

SQL SELECT *

FROM PUB."RP-CLASS";

Store RPClass into C:\Users\SAMSUNG\Desktop\Qlikview - Allyssa\LAST QVD\RPClass.qvd;

RPUnit:

LOAD RPUNum,

PCINum,

MDINum,

BINum,

SINum,

Parcel,

NumAndStreet,

PType,

LSurveyNum,

LLotNum,

LBlkNum,

LNBound,

LEBound,

LSBound,

LWBound,

LSketchFile,

BPermitNum,

BPIssued,

BCCT,

BCompletionIssued,

BOccupancyIssued,

BDateCompleted,

BDateOccupied,

MEAmenities,

Purok,

MPCINum,

MMDINum,

MSINum,

MParcel,

MPType,

MBINum,

LotBlkSurvey,

MTelecom;

SQL SELECT *

FROM PUB.RPUnit;

Store RPUnit into C:\Users\SAMSUNG\Desktop\Qlikview - Allyssa\LAST QVD\RPUnit.qvd;

//Load

AbsClass:

LOAD tax_type,

ccode,

crank,

curr_tax,

curr_dis,

curr_net,

ACcurr_pen,

ACprec_tax,

ACprec_pen,

ACprev_tax,

ACprev_pren,

prev_taxsub,

prev_pensub,

currmo_coll,

brgy_share,

prevmo_coll,

total_coll,

class_type,

Name

FROM

(qvd);

Abstract:

LOAD pcinum,

mdinum,

binum,

sinum,

parcel,

pType,

ATordate,

ATornum,

ATpin,

owner,

brgy,

curr_assval,

lot_no,

yr_from,

yr_to,

adv_tax,

curr_taxwdis,

curr_taxodis,

prec_tax,

prev_tax,

gross_coll,

curr_disc,

adv_disc,

net_coll,

tax_code,

curr_pen,

prec_pen,

prev_pen,

[ATabs=date]

FROM

(qvd);

AcctForm:

LOAD stubno,

cust_recvdate,

orfm_ornum,

orto_ornum,

cust_issuedate,

[c-code],

or_count

FROM

(qvd);

AssLevel:

LOAD ASSLproptype,

ASSLclassif,

description,

ASSLasslev,

Code,

ASSLyr

FROM

(qvd);

Aword:

LOAD val,

word

FROM

(qvd);

BldgAssmt:

LOAD BApin,

BAeffectivity,

classif,

storey,

BAarea,

[area-comp],

[BAunit-val],

BAasslev,

[area-length],

[area-width],

[use-type-code],

depreciation,

[BAprop-type],

BAremarks,

BAcancelled,

BAyr,

[d-compltd],

[bldg-type],

[NPaint-Rate],

[SHM-Rate],

BANR,

[eco-life],

BAmvalue,

[BAuva;-yr],

[d-rate],

[e-count],

colum,

beams,

floorjt,

roof,

partition,

flooring,

ceiling,

windows,

doors,

elect,

numtb,

paint,

[paint-c],

[ex-walls],

[roof-frm],

founda,

[wall-fin],

dom,

BApcount,

BAentrydate,

BAmode,

BAPCINum,

BAMDINum,

BABINum,

BASINum,

BAParcel,

BAPtype,

[BA-CCode],

[BA-AUCode],

Stairs,

TBath,

Plumbing

FROM

(qvd);

Brgy:

LOAD BRPCINum,

BRMDINum,

BRBINum,

BrgyName

FROM

(qvd);

BrgyShare:

LOAD BrgyCode,

BrgyName,

AdvPay,

CurrYrD,

CurrYrW,

PrecYr,

PrevYr,

CurrPen,

PrecPen,

PrevPen,

GrossC,

CurrDisc,

AdvDisc,

TotColl,

gen_fund,

brgy_share,

brgy_50p,

brgy_30p,

brgy_total,

brgy_50pA,

brgy_50pO,

brgy_30pA,

brgy_30pO,

brgy_totalA,

brgy_totalO

FROM

(qvd);

Collect:

LOAD [c-code],

name,

designation

FROM

(qvd);

Collectible:

LOAD Colpin,

[Colprop-type],

Coluser_id,

Colremarks,

Coltodate,

[Colprev-assess],

[Colcurr-assess],

year,

qtr,

Colbasic_sef,

Coltin,

[penalty-bal],

Colqtr2,

[disc-bal],

Colcompro,

Colmode,

Coltime_stamp,

ColPCINum,

ColMDINum,

ColBINum,

ColSInum,

Parcel,

ColPType,

ColRPUNum,

ColOwnerNum,

ColBasic,

ColSEF,

ColAssmtCount,

[ColRev-Yr],

ColIdleTax

FROM

(qvd);

DelinqFile:

LOAD Delpcinum,

Delmdinum,

binum,

Delsinum,

Delparcel,

DelpType,

Delowner,

[pin-short],

address1,

Deladdress2,

[Del-lotno],

assdval,

yr_fm,

Delyr_to,

Deltaxdue,

Delpendue,

discdue,

Deltotdue,

[Del-location],

Delarp,

propClass,

area,

Deltctno,

Qtr1,

Qtr2

FROM

(qvd);

Delsumm:

LOAD brgy_code,

brgy_name,

rpu_cnt,

rpu_taxable,

rpu_exempt,

rpu_delinq,

rpu_per,

tot_basic,

tot_sef,

tot_idle,

tot_taxdue,

tot_recv,

tot_basicpen,

tot_sefpen,

tot_idlepen,

tot_pendue,

tot_amtdue,

del_per,

tot_del

FROM

(qvd);

LandAssmt:

LOAD LAPin,

effectivity,

LAClassif,

LAKind,

area,

LAClassrnk,

[unit-val],

adjmt,

asslev,

width,

LARemarks,

[corner-inf],

[UNDEVELOP-LVA],

LATaxability,

LAProptype,

LAMcode,

mvalue,

depth,

LACancelled,

LAyr,

strip_area,

ctr,

LANR,

[uval-yr],

[dst-pobl],

[dst-weath],

LAPcount,

[lva-pobl],

[lva-rdfrt],

[lva-weat],

kind2,

LAEntrydate,

LAMode,

CRClassif,

WRF,

WSA,

Testat,

LAPCINum,

LAMDINum,

LABINum,

LASINum,

LAParcel,

LAPtype,

CCode,

AUCode,

ClassifType,

[dst-rdfrt]

FROM

(qvd);

LandMV:

LOAD Kind,

[mv-kind],

unit,

classif,

treecode,

LMVMcode,

LMVyr,

ZoneNum

FROM

(qvd);

MenuFile:

LOAD menu_order,

menu_level,

menu_obj,

menu_program,

menu_cat,

menu_label,

init_access

FROM

(qvd);

MTSRep:

LOAD YrOf,

MOf,

MTSPCINum,

MTSMDINum,

MTSBINum,

MTSTaxable,

MTSRCode,

MTSRPUs,

MTSClassif,

Cancelled,

MTSArea,

MTSLMVal,

MTSBMVal175B,

MTSBMVal175U,

MTSMMVal,

MTSIMVal,

MTSLAVal,

MTSBAVal175B,

MTSBAVal175U,

MTSMAVal,

MTSIAVal,

CutOff

FROM

(qvd);

OrFile:

LOAD OrFornum,

OrFordate,

OrFpayee,

[OrFc-code],

BasicTax,

SEFTax,

OrFIdleTax,

BasicPen,

SEFPen,

IdlePen,

BasicDis,

SEFDis,

IdleDis,

TotalDis,

TotalTax,

TotalPen,

OrFTotalPay,

CancFlag,

user_code,

date_posted,

time_posted,

BankName,

CheckNo,

CheckDate,

CheckAmt,

CashAmt,

OrFremarks,

[OrFabs-date],

[OrFabs-no]

FROM

(qvd);

OrptFile:

LOAD seqno,

prt_detail,

OFowner,

OFlocation,

OFlotno,

PIN,

instlno,

assval_land,

assval_imp,

basictax,

OFbasicpen,

seftax,

OFsefpen,

totaldue

FROM

(qvd);

Owner:

LOAD OwnerTin,

OwnerTctno,

owner,

address,

admin,

address2,

[telno-1],

[telno-2],

OwnerLotno,

[c-status],

spouse,

et_al,

others,

OwnerMode,

OwnerEntrydate,

BIRTin,

AdmTin,

OwnerNum,

OwnerAdmNum

FROM

(qvd);

Pastdue:

LOAD PDpin,

assmtcnt,

PDlotno,

totarea,

proptype,

propclass,

propdesc,

assval,

ownernum,

oname,

lastpaid,

lpaidyr,

lpaidqtr,

lpaydesc,

lcollyr,

lcollqtr,

lcollyr2,

lcollqtr2,

lcolldesc,

basicdue,

sefdue,

idledue,

taxdue,

basicpen,

sefpen,

idlepen,

pendue,

totdue,

yrsdel,

mval,

titleno

FROM

(qvd);

Payment:

LOAD pin,

[prop-type],

ornum,

ordate,

user_id,

remarks,

checknum,

tin,

mcode,

bcode,

payee,

bankname,

checkdate,

todate,

discount,

penalty,

[prev-assess],

[curr-assess],

year1,

year2,

qtr1,

qtr2,

VOS,

basic_sef,

tdno,

cancelled,

partial,

[abs-date],

compro,

mode,

time_stamp,

[c-code],

PCINum,

MDINum,

BINum,

SINum,

Parcel,

PType,

RPUNum,

OwnerNum,

Discount_Basic,

Discount_SEF,

Penalty_Basic,

Penalty_SEF,

Basic,

SEF,

AssmtCount,

[Rev-Yr],

[tc-amount],

ornumber,

taxcredit,

Penalty_Idle,

Discount_Idle,

TotalPay,

IdleTax,

[abs-no]

FROM

(qvd);

PenaltyRate:

LOAD yr,

rate,

PRqtr,

taxyear

FROM

(qvd);

Property:

LOAD [Prop-pin],

[Prop-tin],

assdate,

[Prop_prop-type],

arp,

Propcancelled,

[total-area],

[tot-assess],

lotno,

tctno,

tcode,

pcode,

Mcode,

Propbcode,

scode,

asslot,

entry_date,

taxability,

classrnk,

demolished,

[new-assval],

yr,

Marketval,

NR,

Propremarks,

prevpin,

revnum,

pcount,

Propmode,

Approved,

Date_apprvd,

remote,

PropPCINum,

PropMDINum,

PropBINum,

PropSInum,

PropParcel,

PropPType,

RPUNum,

[rev-yr],

BCCT,

TctDate,

AdmNum,

Qtr,

PropAssmtCount,

PropOwnerNum,

DateCancelled,

LBNum,

CBRpunum,

CBYr,

CBPCount,

Inactive,

Mortgage,

PTagNum,

PTagInfo,

Signatory,

SPos,

SDate

FROM

(qvd);

QRep:

LOAD QrepMcode,

QrepBcode,

QYr,

Quarter,

Taxable,

RCode,

RPUs,

Area,

LMVal,

BMVal175B,

BMVal175U,

MMVal,

IMVal,

LAVal,

BAVal175B,

BAVal175U,

MAVal,

IAVal,

Classif,

QrepPCINum,

QrepMDINum,

QrepBINum,

PKRpus,

Carpav,

Uliqav,

Oprav

FROM

(qvd);

RaaFile:

LOAD tran_code,

beg_fmor,

beg_toor,

beg_qty,

rec_fmor,

rec_toor,

rec_qty,

iss_fmor,

iss_toor,

iss_qty,

collname,

end_fmor,

end_toor,

end_qty

FROM

(qvd);

RevYear:

LOAD [rev-yr],

RYyear1,

RYyear2

FROM

(qvd);

RPClass:

LOAD Kind,

description,

SubCode

FROM

(qvd);

Rptar:

LOAD refdate,

refnum,

[assess-count],

[year-from],

[qtr-from],

[year-to],

[qtr-to],

basic_tax,

basic_penalty,

basic_discount,

sef_tax,

sef_penalty,

sef_discount,

total_tax,

total_penalty,

total_discount,

[assess-value],

total_paid

FROM

(qvd);

RPUnit:

LOAD RPUnitRPUNum,

RPUnitPCINum,

RPUnitMDINum,

PRUnitBINum,

RPUnitSINum,

Parcel,

NumAndStreet,

RPUnitPtype,

LSurveyNum,

LLotNum,

LBlkNum,

LNBound,

LEBound,

LSBound,

LWBound,

LSketchFile,

BPermitNum,

BPIssued,

RPUnitBCCT,

BCompletionIssued,

BOccupancyIssued,

BDateCompleted,

BDateOccupied,

MEAmenities,

Purok,

MPCINum,

MMDINum,

MSINum,

MParcel,

MPType,

MBINum,

LotBlkSurvey,

MTelecom

FROM

(qvd);

TaxNotice:

LOAD YearType,

nyear,

nQtrFm,

nQtrTo,

nPeriod,

nArp,

nAssVal,

nBasTax,

nBasNet,

nSEFTax,

nSEFNet,

nIdleTax,

nIdleNet,

nTotal

FROM

(qvd);

TempSysparam:

LOAD sys_lgutype,

sys_provcode,

sys_citycode,

sys_muncode,

sys_distcode,

sys_provname,

sys_cityname,

sys_muniname,

sys_provtreas,

sys_currtrn,

sys_ovrdate,

sys_update,

sys_reprint,

sys_citytreas,

sys_muntreas,

sys_formcust,

sys_custpos,

sys_directory

FROM

(qvd);

UserProg:

LOAD user_code,

module_code,

view_flag,

create_flag,

edit_flag,

cancel_flag,

delete_flag,

process_flag,

generate_flag,

seq_no

FROM

(qvd);

Re: problem loading script.

MayilVahanan — Wed, 01 Jul 2015 06:26:07 GMT

Actually, in ur script, there is no "COLOR" table.

Re: problem loading script.

Wed, 01 Jul 2015 06:28:20 GMT

Hi Mayil,

This is for the color.

COLOUR:

LOAD ColourID,

Colour_RGB

FROM

(ooxml, embedded labels, table is Colour);

For vCurser = 0 to NoOfRows('COLOUR')

LET vColourID =Peek('ColourID',vCurser, 'COLOUR');

Let vColour_RGB_$(vColourID) =Peek('Colour_RGB',vCurser, 'COLOUR');

Next vCurser

LET vCurser =;

LET vColourID =;

Re: problem loading script.

MayilVahanan — Wed, 01 Jul 2015 06:44:11 GMT

Try like this,

For vCurser = 0 to NoOfRows('COLOUR')

LET vColourID =Peek('ColourID',$(vCurser), 'COLOUR');

Let vColour_RGB_$(vColourID) =Peek('Colour_RGB', $(vCurser), 'COLOUR');

Next vCurser;

LET vCurser =;

LET vColourID =;

Exit script;

Check in the log file.

Document properties -> Generate log file.

You can able to find the error message in that.

Re: problem loading script.

Wed, 01 Jul 2015 06:56:03 GMT

Sir thank for helping but I think the reason why stack on loading script is the relationship on the tables, the synthetic keys i think. what do you think sir???

Thank for the help by the way

Re: problem loading script.

simospa — Wed, 01 Jul 2015 06:59:50 GMT

Lester,

as many of users said, you'd better to enable the log in Document Properties --> Generate log file and then reload script.

Analizing the generate file we'll be more useful to you.

Re: problem loading script.

simospa — Wed, 01 Jul 2015 07:02:48 GMT

Another solution to help you could be insert an exit script statement at the end of 2nd table, then reload and see the join in table viewer, then remove the exit script and put in at the end of 3rd table and so on.

Re: problem loading script.

PrashantSangle — Wed, 01 Jul 2015 07:02:59 GMT

Hi,

There is so many reason. Which include Synthetic Key, Circular Loop.

For that Debug you code with limited data take 10.

After completion of debug load check data model by ctrl+T

You will find reasons.

Regards