Edgewall Software

Ticket #554: importlog.txt

File importlog.txt, 20.8 KB (added by mwilliams, 5 years ago)

dir

Line 
199 rows have been copied to table TAXTYPE
25 rows have been copied to table TAXAUTHORITY
35 rows have been copied to table TASKTYPE
479 rows have been copied to table TASKLIST
57 rows have been copied to table STATUS
612 rows have been copied to table ROLE
71 rows have been copied to table REPOSITORY
83 rows have been copied to table REPORTTYPE
92 rows have been copied to table REPORTQUERIES
1041 rows have been copied to table PROFILECLASSHISTORY
1120 rows have been copied to table PROFILECLASS
123 rows have been copied to table PREFERREDCONTACTMETHOD
13362132 rows have been copied to table MVW_EXEMPTCLASSMAIN
14371988 rows have been copied to table MVW_API_CLASSEXEMPTMERGE
15362132 rows have been copied to table MVW_API_CLASSEXEMPTIONMAIN
161 rows have been copied to table MD_EXEMPTFORMVALIDFIELDS
174 rows have been copied to table LICENSETYPE
1865 rows have been copied to table LEGACYTAXTYPE
19505 rows have been copied to table LEGACYGEOCODE_TEMP
2065765 rows have been copied to table LEGACYGEOCODE
213 rows have been copied to table IMPORTTYPE
223 rows have been copied to table IMPORTSEVERITY
236 rows have been copied to table IMPORTLOG
2419 rows have been copied to table IMPORT
253 rows have been copied to table HISTORICALACTIVITY
2611 rows have been copied to table FUNCTIONALAREA
2714106 rows have been copied to table FIPS_TEMP
2881612 rows have been copied to table FIPS
295 rows have been copied to table FILETYPE
3030 rows have been copied to table EXPORTTYPETOFIELDS
311 rows have been copied to table EXPORTTYPE
324 rows have been copied to table EXPORTSTATUS
333 rows have been copied to table EXPORTSEVERITY
34799 rows have been copied to table EXPORTLOG
353 rows have been copied to table EXPORTLOCATION
3630 rows have been copied to table EXPORTFIELDS
3741 rows have been copied to table EXPORT
38An Error Was Found When Copying Row 1 of Table EXPLANATION
39INSERT INTO EXPLANATION (EXPL_ID , SHORTDESCRIPTION , EXCD_ID , FULLDESCRIPTION) VALUES (366 , An exemption is available for the sale of telecommunication services to air carriers solely for the purpose of air safety and navigation where such telecommunication service is provided by an organization, at least ninety percent of which is owned, d , 612595 , An exemption is available for the sale of telecommunication services to air carriers solely for the purpose of air safety and navigation where such telecommunication service is provided by an organization, at least ninety percent of which is owned, directly or indirectly, by air carriers, and which organization's principal function is to fulfill the requirements of the federal aviation administration or the international civil aviation organization, relating to the existence of a communication system between aircraft and dispatcher, aircraft and air traffic control or ground station and ground station (or any combination or the foregoing) for the purposes of air safety and navigation.)
40STATE: 22005  [Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification
41
42An Error Was Found When Copying Row 2 of Table EXPLANATION
43INSERT INTO EXPLANATION (EXPL_ID , SHORTDESCRIPTION , EXCD_ID , FULLDESCRIPTION) VALUES (367 , An exemption is available for the sale of telecommunication services to air carriers solely for the purpose of air safety and navigation where such telecommunication service is provided by an organization, at least ninety percent of which is owned, d , 612596 , An exemption is available for the sale of telecommunication services to air carriers solely for the purpose of air safety and navigation where such telecommunication service is provided by an organization, at least ninety percent of which is owned, directly or indirectly, by air carriers, and which organization's principal function is to fulfill the requirements of the federal aviation administration or the international civil aviation organization, relating to the existence of a communication system between aircraft and dispatcher, aircraft and air traffic control or ground station and ground station (or any combination or the foregoing) for the purposes of air safety and navigation.)
44STATE: 22005  [Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification
45
46An Error Was Found When Copying Row 3 of Table EXPLANATION
47INSERT INTO EXPLANATION (EXPL_ID , SHORTDESCRIPTION , EXCD_ID , FULLDESCRIPTION) VALUES (503 , A sale for resale is not considered a retail sale and is therefore not subject to Nebraska sales and use tax. , 603807 , A sale for resale is not considered a retail sale and is therefore not subject to Nebraska sales and use tax.)
48STATE: 22005  [Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification
49
50An Error Was Found When Copying Row 4 of Table EXPLANATION
51INSERT INTO EXPLANATION (EXPL_ID , SHORTDESCRIPTION , EXCD_ID , FULLDESCRIPTION) VALUES (504 , Sales to the United States government, its agencies and corporations wholly owned by the United States government and to the state, counties, townships, cities, villages, educational service units, rural or suburban fire protection districts, natural , 603811 , Sales to the United States government, its agencies and corporations wholly owned by the United States government and to the state, counties, townships, cities, villages, educational service units, rural or suburban fire protection districts, natural resource districts, drainage districts (effective October 1, 2002), elected county fair boards (effective October 1, 2002), joint entities or agencies engaged in solid waste management, or city, county, or joint airport authorities are exempt from the tax.)
52STATE: 22005  [Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification
53
54An Error Was Found When Copying Row 5 of Table EXPLANATION
55INSERT INTO EXPLANATION (EXPL_ID , SHORTDESCRIPTION , EXCD_ID , FULLDESCRIPTION) VALUES (505 , The federal government or its instrumentalities are not subject to the tax.  Sales to the state of Rhode Island, its agencies and instrumentalities, or its political subdivisions are exempt from the tax , 641870 , The federal government or its instrumentalities are not subject to the tax.  Sales to the state of Rhode Island, its agencies and instrumentalities, or its political subdivisions are exempt from the tax)
56STATE: 22005  [Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification
57
58An Error Was Found When Copying Row 6 of Table EXPLANATION
59INSERT INTO EXPLANATION (EXPL_ID , SHORTDESCRIPTION , EXCD_ID , FULLDESCRIPTION) VALUES (506 , Sales for resale are exempt from the tax. , 641872 , Sales for resale are exempt from the tax.)
60STATE: 22005  [Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification
61
62An Error Was Found When Copying Row 7 of Table EXPLANATION
63INSERT INTO EXPLANATION (EXPL_ID , SHORTDESCRIPTION , EXCD_ID , FULLDESCRIPTION) VALUES (507 , The federal government or its instrumentalities are not subject to the tax.  Sales to the state of Rhode Island, its agencies and instrumentalities, or its political subdivisions are exempt from the tax , 641873 , The federal government or its instrumentalities are not subject to the tax.  Sales to the state of Rhode Island, its agencies and instrumentalities, or its political subdivisions are exempt from the tax)
64STATE: 22005  [Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification
65
66An Error Was Found When Copying Row 9 of Table EXPLANATION
67INSERT INTO EXPLANATION (EXPL_ID , SHORTDESCRIPTION , EXCD_ID , FULLDESCRIPTION) VALUES (632 , Non profit organizations that qualify as an exempt organization by the Federal Internal Revenue Code section 501(c)(3) are exempt from Massachusetts sales tax on tangible personal property only. Telecommunications services as well as any other taxabl , 575429 , Non profit organizations that qualify as an exempt organization by the Federal Internal Revenue Code section 501(c)(3) are exempt from Massachusetts sales tax on tangible personal property only. Telecommunications services as well as any other taxable services are taxable to non-profit organizations.
68
69Nonprofit organizations that qualify as exempt organizations by the Federal Internal Revenue Code Sec. 501(c)(3) are exempt from Massachusetts sales tax provided the following conditions are met: (1) Sales of tangible personal property or services are used in the conduct of religious, charitable, educational, or scientific enterprise.  (2) The corporation, foundation, institution, or organization claiming an exemption shall first obtain a certificate of exemption from the commissioner.  (3) The vendor shall keep a record of the sale including the sales price, name of the purchaser, the date of each sale, and the certificate number.  CH 64 Law Sec. 6(e).
70
71Vendors must obtain Form ST-5 from the exempt customer in order to make a tax free sale.  A copy of the exempt customer's ST-2 (Certificate of Exemption) must be attached to the Form ST-5.  The vendor is responsible for ensuring that the information contained on Form ST-5 matches that on Form ST-2, and that Form ST-2, which expires every 5 years, has not expired.)
72STATE: 22005  [Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification
73
74An Error Was Found When Copying Row 10 of Table EXPLANATION
75INSERT INTO EXPLANATION (EXPL_ID , SHORTDESCRIPTION , EXCD_ID , FULLDESCRIPTION) VALUES (635 , The following entities are exempt:
76
77- Sales to state universities. 65 Ill. Comp. Stat. 5/8-11-17(c)(9).
78
79- Sales of telecommunication services between a parent corporation and its wholly owned subsidiaries or between wholly owned subsidiaries fo , 530148 , The following entities are exempt:
80
81- Sales to state universities. 65 Ill. Comp. Stat. 5/8-11-17(c)(9).
82
83- Sales of telecommunication services between a parent corporation and its wholly owned subsidiaries or between wholly owned subsidiaries for their use of consumption and not for resale are exempt. 65 Ill. Comp. Stat. 5/8-11-17(c)(9).)
84STATE: 22005  [Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification
85
86An Error Was Found When Copying Row 12 of Table EXPLANATION
87INSERT INTO EXPLANATION (EXPL_ID , SHORTDESCRIPTION , EXCD_ID , FULLDESCRIPTION) VALUES (344 , Only the State of New Hampshire and its political subdivisions are exempt.  No other states or political subdivisions are exempt.  The services must be billed directly to the governmental agency or political subdivision to be exempt. , 608690 , Only the State of New Hampshire and its political subdivisions are exempt.  No other states or political subdivisions are exempt.  The services must be billed directly to the governmental agency or political subdivision to be exempt.)
88STATE: 22005  [Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification
89
90An Error Was Found When Copying Row 13 of Table EXPLANATION
91INSERT INTO EXPLANATION (EXPL_ID , SHORTDESCRIPTION , EXCD_ID , FULLDESCRIPTION) VALUES (22 , State statutes specifically exempt Texas state government and the United States government from the 911 Fee.   This would include Federal credit unions, but not State chartered credit unions.  , 670064 , State statutes specifically exempt Texas state government and the United States government from the 911 Fee.   This would include Federal credit unions, but not State chartered credit unions. )
92STATE: 22005  [Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification
93
94An Error Was Found When Copying Row 14 of Table EXPLANATION
95INSERT INTO EXPLANATION (EXPL_ID , SHORTDESCRIPTION , EXCD_ID , FULLDESCRIPTION) VALUES (345 , The statutes do not specifically address an exemption for resale.  However, because this surcharge is based on a per line charge and resellers do not have any lines or switches, the surcharge would not apply. , 608695 , The statutes do not specifically address an exemption for resale.  However, because this surcharge is based on a per line charge and resellers do not have any lines or switches, the surcharge would not apply.)
96STATE: 22005  [Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification
97
98An Error Was Found When Copying Row 15 of Table EXPLANATION
99INSERT INTO EXPLANATION (EXPL_ID , SHORTDESCRIPTION , EXCD_ID , FULLDESCRIPTION) VALUES (346 , Sales to the United States government, its unincorporated agencies and instrumentalities, and any incorporated agency or instrumentality wholly owned by the United States or by a corporation wholly owned by the United States are exempt from the tax.  , 607141 , Sales to the United States government, its unincorporated agencies and instrumentalities, and any incorporated agency or instrumentality wholly owned by the United States or by a corporation wholly owned by the United States are exempt from the tax.  Sales to the state of Nevada, its unincorporated agencies and instrumentalities, and any county, city, district, or other political subdivision of the state are exempt from the tax.)
100STATE: 22005  [Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification
101
102An Error Was Found When Copying Row 16 of Table EXPLANATION
103INSERT INTO EXPLANATION (EXPL_ID , SHORTDESCRIPTION , EXCD_ID , FULLDESCRIPTION) VALUES (347 , Sales to the United States government, its unincorporated agencies and instrumentalities, and any incorporated agency or instrumentality wholly owned by the United States or by a corporation wholly owned by the United States are exempt from the tax.  , 607142 , Sales to the United States government, its unincorporated agencies and instrumentalities, and any incorporated agency or instrumentality wholly owned by the United States or by a corporation wholly owned by the United States are exempt from the tax.  Sales to the state of Nevada, its unincorporated agencies and instrumentalities, and any county, city, district, or other political subdivision of the state are exempt from the tax.)
104STATE: 22005  [Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification
105
106An Error Was Found When Copying Row 17 of Table EXPLANATION
107INSERT INTO EXPLANATION (EXPL_ID , SHORTDESCRIPTION , EXCD_ID , FULLDESCRIPTION) VALUES (348 , Sales to the United States government, its unincorporated agencies and instrumentalities, and any incorporated agency or instrumentality wholly owned by the United States or by a corporation wholly owned by the United States are exempt from the tax.  , 607143 , Sales to the United States government, its unincorporated agencies and instrumentalities, and any incorporated agency or instrumentality wholly owned by the United States or by a corporation wholly owned by the United States are exempt from the tax.  Sales to the state of Nevada, its unincorporated agencies and instrumentalities, and any county, city, district, or other political subdivision of the state are exempt from the tax.)
108STATE: 22005  [Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification
109
110An Error Was Found When Copying Row 18 of Table EXPLANATION
111INSERT INTO EXPLANATION (EXPL_ID , SHORTDESCRIPTION , EXCD_ID , FULLDESCRIPTION) VALUES (241 , Sales made to churches, to organizations exempt from federal taxation under IRC Sec. 501{c)(3), and to nonprofit organizations operated exclusively for charitable purposes are exempt from sales tax. , 620464 , Sales made to churches, to organizations exempt from federal taxation under IRC Sec. 501{c)(3), and to nonprofit organizations operated exclusively for charitable purposes are exempt from sales tax.)
112STATE: 22005  [Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification
113
114An Error Was Found When Copying Row 19 of Table EXPLANATION
115INSERT INTO EXPLANATION (EXPL_ID , SHORTDESCRIPTION , EXCD_ID , FULLDESCRIPTION) VALUES (242 , Sales made to churches, to organizations exempt from federal taxation under IRC Sec. 501{c)(3), and to nonprofit organizations operated exclusively for charitable purposes are exempt from sales tax. , 620466 , Sales made to churches, to organizations exempt from federal taxation under IRC Sec. 501{c)(3), and to nonprofit organizations operated exclusively for charitable purposes are exempt from sales tax.)
116STATE: 22005  [Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification
117
118An Error Was Found When Copying Row 21 of Table EXPLANATION
119INSERT INTO EXPLANATION (EXPL_ID , SHORTDESCRIPTION , EXCD_ID , FULLDESCRIPTION) VALUES (244 , The receipts of various non-profit organizations are exempt from the gross receipts tax.  All receipts of organizations exempt from paying federal income tax under IRC Sec. 501(c)(3) are exempt from the gross receipts tax.     , 608737 , The receipts of various non-profit organizations are exempt from the gross receipts tax.  All receipts of organizations exempt from paying federal income tax under IRC Sec. 501(c)(3) are exempt from the gross receipts tax.    )
120STATE: 22005  [Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification
121
122An Error Was Found When Copying Row 22 of Table EXPLANATION
123INSERT INTO EXPLANATION (EXPL_ID , SHORTDESCRIPTION , EXCD_ID , FULLDESCRIPTION) VALUES (200 , Sales to the government of the United States as well as sales to state or local governmental units are exempt from the sales and use taxes by Vermont statute.    , 752662 , Sales to the government of the United States as well as sales to state or local governmental units are exempt from the sales and use taxes by Vermont statute.   )
124STATE: 22005  [Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification
125
126An Error Was Found When Copying Row 23 of Table EXPLANATION
127INSERT INTO EXPLANATION (EXPL_ID , SHORTDESCRIPTION , EXCD_ID , FULLDESCRIPTION) VALUES (64 , Exemption from tax exists for:  any nonprofit charitable, nonprofit education, nonprofit religious or any other nonprofit organization that is is exempt from federal income tax under IRC, 501c.   , 670085 , Exemption from tax exists for:  any nonprofit charitable, nonprofit education, nonprofit religious or any other nonprofit organization that is is exempt from federal income tax under IRC, 501c.  )
128STATE: 22005  [Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification
129
1303 rows have been copied to table EXPLANATION
1311463796 rows have been copied to table DATAEXPORT
1321 rows have been copied to table CUSTOMERVIEW
1331 rows have been copied to table CUSTOMEREXFORMVALIDFIELDS
13433446 rows have been copied to table CUSTOMEREXFORMHISTORY
13520 rows have been copied to table CUSTOMERCLASS
13677023 rows have been copied to table CINGULARGEO
13765642 rows have been copied to table CINGGEOFIPS
138381756 rows have been copied to table C3RATE
1392 rows have been copied to table BUSINESSOBJECT
1403 rows have been copied to table BUSINESSFIELDTYPE
1413353064 rows have been copied to table BOBJECTFIELDDATAHISTORY
1423 rows have been copied to table APPLICATION
143478998 rows have been copied to table ADDRESS
1443 rows have been copied to table ACCESSLEVEL
145495 rows have been copied to table TAX
14682 rows have been copied to table TASK
14755 rows have been copied to table PROFILECLASSHEADERHISTORY
14825 rows have been copied to table PROFILECLASSHEADER
1491 rows have been copied to table LICENSE
15062952 rows have been copied to table GEOCODECROSSREFBACKUP
15175896 rows have been copied to table GEOCODECROSSREF
15215 rows have been copied to table DOCUMENTTYPE
1537 rows have been copied to table BUSINESSOBJECTFIELD
1541 rows have been copied to table APPLICATIONLICENSE
155114 rows have been copied to table TASKHISTORY
15636 rows have been copied to table PROFILECLASSEXEMPTION
15722 rows have been copied to table PRIVILEGE
15847506 rows have been copied to table JURISDICTIONTAX
159143218 rows have been copied to table GEOCODECROSSREFHISTORY
1601 rows have been copied to table COMPANY
161367984 rows have been copied to table CLASSEXEMPTION
1623353064 rows have been copied to table BUSINESSOBJECTFIELDDATA
16398 rows have been copied to table ROLEPRIVILEGE
16480 rows have been copied to table PROFCLASSEXEMPTIONHISTORY
16515 rows have been copied to table CLASSEXEMPTIONOVERRIDE
1661 rows have been copied to table BUSINESSENTITY
16785 rows have been copied to table WORKSPACE
16897 rows have been copied to table SECURITY
16915 rows have been copied to table CLASSEXEMPTIONHISTORY
170An Error Was Found When Copying Table SESSION
171SELECT SESSION_ID , SESSSTATE_ID , STARTTIME , ENDTIME , NOTES , MACHINE , BE_ID , COMPANY_ID , SEC_ID FROM SESSION
172STATE: S0002  [Oracle][ODBC][Ora]ORA-00903: invalid table name
173
174
175658 rows have been copied to table SECURITYHISTORY
17632 rows have been copied to table PASSWORDHISTORY
1775 rows have been copied to table LEGACYTAXAUTHORITY
178219 rows have been copied to table DIRECTORY
179479024 rows have been copied to table CUSTOMER
180325 rows have been copied to table LEGACYTAX
18133871 rows have been copied to table DOCUMENT
182173 rows have been copied to table TAXCROSSREF
18333857 rows have been copied to table REVISION
184355 rows have been copied to table EXEMPTIONFORM
18533395 rows have been copied to table CUSTOMEREXFORM
186182 rows have been copied to table TAXCROSSREFHISTORY
1872162 rows have been copied to table EXEMPTIONFORMVALIDFIELDS