Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-66322

Incorrect syntax in sql files generated by PostgreSQL Data Partitioning Tool

    Details

      Description

      Steps to reproduce:

      1. Start portal ee-7.0.x
      2. Create 2 virtual instances (www.able.com, www.baker.com)
      3. Add a page with a blog entry in the main instance and the 2 virtual instances
      4. Stop portal
      5. 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/
      6. Create and run the schema sql file against a blank database
      7. 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

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Days since last comment:
                3 years, 3 weeks, 1 day ago