[LPS-66322] Incorrect syntax in sql files generated by PostgreSQL Data Partitioning Tool - Liferay Issues

Details

Type: Bug
Status: Closed
Resolution: Fixed
Affects Version/s: 7.0.1 CE GA2
Fix Version/s: 7.0.1 CE GA2
Component/s: Core Infrastructure
Labels:
- EXP7

Fix Priority:
4
Databases:

PostgreSQL 9.3
Git Pull Request:
https://github.com/brianchandotcom/liferay-portal/pull/40495

Description

Steps to reproduce:

Start portal ee-7.0.x
Create 2 virtual instances (www.able.com, www.baker.com)
Add a page with a blog entry in the main instance and the 2 virtual instances
Stop portal

Use the partitioning tool to create control, delete, and paritioned sql files for each instance (expect 9 sql files in total)

java -classpath "postgresql.jar;com.liferay.portal.tools.data.partitioning.sql.builder-1.0.0.jar;com.liferay.portal.tools.data.partitioning.sql.builder.postgresql-1.0.0.jar" com.liferay.portal.tools.data.partitioning.sql.builder.Main --properties-file portal-upgrade-database.properties --schema-name lportal --company-ids 20116,31623,32221 --output-dir ./output/

Create and run the schema sql file against a blank database
Run the control and partition sql files (lportal-32221-control.sql, lportal-32221-partitioned.sql) against the database used in the previous step

Expected Result: Control and partition sql files run without errors.

Actual Result: Syntax errors in sql files.

control.sql

psql:C:/Users/Administrator/Desktop/lportal-32221-control.sql:824: invalid command \'Aquila',
psql:C:/Users/Administrator/Desktop/lportal-32221-control.sql:2849: ERROR:  syntax error at or near "Azur"
LINE 1: ... ('0', '3024', '3', 'U', 'Provence-Alpes-CA'te-d\'Azur', 'tr...
                                                             ^

partitioned.sql

psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:31: invalid command \'
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:34: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:37: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:38: invalid command \'
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:42: invalid command \'
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:43: invalid command \'
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:44: invalid command \'
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:45: invalid command \'
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:46: invalid command \'
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:47: invalid command \'
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:48: invalid command \'
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:49: invalid command \'
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:50: invalid command \'
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:51: invalid command \'
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:52: invalid command \'
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:53: invalid command \'
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:54: invalid command \'
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:55: invalid command \'
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:56: invalid command \'
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:79: invalid command \'
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:80: invalid command \'
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:81: invalid command \'
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:82: invalid command \'
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:83: invalid command \'
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:84: invalid command \'
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:85: invalid command \'
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:86: invalid command \'
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:87: invalid command \'
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:88: invalid command \'
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:89: invalid command \'
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:90: invalid command \'
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:91: invalid command \'
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:92: invalid command \'
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:93: invalid command \'
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:94: invalid command \'
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:158: invalid command \'#${navbarId}
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:164: invalid command \'.navbar-site
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:165: invalid command \'.navbar-site
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:168: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:203: invalid command \'boundingBox
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:205: invalid command \'.image-viewer-base-image-list,
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:207: invalid command \'auto
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:210: invalid command \'auto
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:216: invalid command \'#<@portlet.namespace
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:224: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:440: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:466: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:467: invalid command \'
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:627: invalid command \'${entry.getAttachmentsFileEntriesCount()
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:720: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:786: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:801: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:916: invalid command \'Map
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:921: invalid command \'<@portlet.namespace
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:924: invalid command \'featureClick
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:930: invalid command \'abstract
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:932: invalid command \'location
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:983: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:1000: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:1030: invalid command \'<span
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:1073: invalid command \'#${navbarId}
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:1079: invalid command \'.navbar-site
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:1080: invalid command \'.navbar-site
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:1083: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:1102: invalid command \'${namespace
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:1107: invalid command \'${namespace
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:1109: invalid command \'${name}
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:1110: invalid command \'${namespace
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:1134: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:1202: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:1284: invalid command \'#${navbarId}
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:1290: invalid command \'.navbar-site
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:1291: invalid command \'.navbar-site
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:1294: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:1324: invalid command \'<span
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:1367: invalid command \'#${navbarId}
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:1373: invalid command \'.navbar-site
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:1374: invalid command \'.navbar-site
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:1377: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:1394: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:1441: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:1456: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:1475: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:1505: invalid command \'<span
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:1548: invalid command \'#${navbarId}
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:1554: invalid command \'.navbar-site
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:1555: invalid command \'.navbar-site
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:1558: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:1603: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:1621: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:1650: invalid command \'true
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:1651: invalid command \'<span
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:1694: invalid command \'#${navbarId}
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:1700: invalid command \'.navbar-site
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:1701: invalid command \'.navbar-site
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:1704: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:1734: invalid command \'<span
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:1777: invalid command \'#${navbarId}
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:1783: invalid command \'.navbar-site
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:1784: invalid command \'.navbar-site
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:1787: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:1831: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:1898: invalid command \'#<@portlet.namespace
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:1900: invalid command \'pills
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:1905: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:1935: invalid command \'<span
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:1978: invalid command \'#${navbarId}
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:1984: invalid command \'.navbar-site
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:1985: invalid command \'.navbar-site
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:1988: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:2037: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:2067: invalid command \'<span
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:2110: invalid command \'#${navbarId}
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:2116: invalid command \'.navbar-site
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:2117: invalid command \'.navbar-site
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:2120: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:2280: invalid command \'${entry.getAttachmentsFileEntriesCount()
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:2373: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:2417: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:2443: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:2472: invalid command \'true
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:2473: invalid command \'<span
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:2516: invalid command \'#${navbarId}
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:2522: invalid command \'.navbar-site
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:2523: invalid command \'.navbar-site
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:2526: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:2556: invalid command \'<span
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:2599: invalid command \'#${navbarId}
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:2605: invalid command \'.navbar-site
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:2606: invalid command \'.navbar-site
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:2609: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:2639: invalid command \'<span
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:2682: invalid command \'#${navbarId}
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:2688: invalid command \'.navbar-site
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:2689: invalid command \'.navbar-site
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:2692: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:2722: invalid command \'<span
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:2765: invalid command \'#${navbarId}
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:2771: invalid command \'.navbar-site
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:2772: invalid command \'.navbar-site
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:2775: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:2805: invalid command \'<span
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:2848: invalid command \'#${navbarId}
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:2854: invalid command \'.navbar-site
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:2855: invalid command \'.navbar-site
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:2858: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:2940: invalid command \'#${navbarId}
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:2946: invalid command \'.navbar-site
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:2947: invalid command \'.navbar-site
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:2950: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:2980: invalid command \'<span
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:3023: invalid command \'#${navbarId}
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:3029: invalid command \'.navbar-site
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:3030: invalid command \'.navbar-site
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:3033: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:3063: invalid command \'<span
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:3106: invalid command \'#${navbarId}
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:3112: invalid command \'.navbar-site
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:3113: invalid command \'.navbar-site
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:3116: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:3161: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:3225: invalid command \'#${navbarId}
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:3231: invalid command \'.navbar-site
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:3232: invalid command \'.navbar-site
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:3235: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:3302: invalid command \'#<@portlet.namespace
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:3304: invalid command \'pills
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:3309: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:3358: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:3405: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:3471: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:3539: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:3554: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:3569: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:3588: invalid command \'${namespace
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:3593: invalid command \'${namespace
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:3595: invalid command \'${name}
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:3596: invalid command \'${namespace
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:3620: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:3655: invalid command \'boundingBox
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:3657: invalid command \'.image-viewer-base-image-list,
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:3659: invalid command \'auto
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:3662: invalid command \'auto
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:3668: invalid command \'#<@portlet.namespace
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:3676: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:3693: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:3710: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:3729: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:3747: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:3862: invalid command \'Map
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:3867: invalid command \'<@portlet.namespace
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:3870: invalid command \'featureClick
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:3876: invalid command \'abstract
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:3878: invalid command \'location
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:3929: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:4145: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:4146: invalid command \'
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:4147: invalid command \'
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:4148: invalid command \'
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:4149: invalid command \'
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:4157: invalid command \'
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:4158: invalid command \'
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:4159: invalid command \'
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:4160: invalid command \'
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:4161: invalid command \'
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:4163: invalid command \'
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:4164: invalid command \'
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:4165: invalid command \'
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:4166: invalid command \'
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:4167: invalid command \'
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:4361: invalid command \'
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:4365: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:4367: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:4369: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:4372: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:4374: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:4380: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:4385: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:4390: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:4393: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:4398: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:4403: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:4407: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:4412: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:4431: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:4432: invalid command \'
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:4433: invalid command \'
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:4456: invalid command \'
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:4458: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:5875: invalid command \'1.0
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:5876: invalid command \'
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:5877: invalid command \'
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:5878: invalid command \'
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:5879: invalid command \'
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:5880: invalid command \'
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:5881: invalid command \'
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:5882: invalid command \'
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:5883: invalid command \'
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:5884: invalid command \'
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:5885: invalid command \'
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:5886: invalid command \'
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:5887: invalid command \'
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:5888: invalid command \'
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:5890: invalid command \'
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:5891: invalid command \'
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:5892: invalid command \'
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:5894: invalid command \'
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:5895: invalid command \'
psql:C:/Users/Administrator/Desktop/lportal-32221-partitioned.sql:5905: ERROR:  syntax error at or near "1.0"
LINE 1: ...YY-MM-DD HH24:MI:SS:MS'), null, 'text', '<?xml version=\'1.0
                                                                    ^

Reproduced on:
Tomcat 8.0.32 + PostgreSQL 9.3
Portal ee-7.0.x Git Hash: 248837d0fd55142fcd767b701e6be4a1d819ba9b

Attachments

Options
- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

Attachments

lportal-32221-control.sql
311 kB
02/Jun/16 4:25 PM
lportal-32221-partitioned.sql
840 kB
02/Jun/16 4:25 PM
sqlserver2012-lportal-32035-control.sql
294 kB
03/Jun/16 11:04 AM

Activity

People

Assignee:

Brian Lee

Reporter:

Brian Lee

Participants of an Issue:

Brian Lee, Miguel Ángel Pastor Olivar

Recent user:

Esther Sanz

Votes:

0 Vote for this issue

Watchers:

0 Start watching this issue

Dates

Created:

02/Jun/16 4:24 PM

Updated:

06/Jun/16 9:55 AM

Resolved:

05/Jun/16 10:09 PM

Days since last comment:

3 years, 3 weeks, 1 day ago