SA-24642

Summary

The user created the Rule2 Schema and ran the migrate.bat . The migration failed.

Error Messages

[java] INFO: Resolving entity "null" / file:///E:/Pega7.2UPDATE_Template2/115042_Pega72UP/scripts/dynamic.ent
[java] Apr 29, 2016 2:44:35 PM com.pega.pegarules.data.ddl.SchemaManagerBasicEnvironmentAdapter logDebug
[java] INFO: Resolving URI "" / common.xsl
[java] Apr 29, 2016 2:44:35 PM com.pega.pegarules.data.ddl.SchemaManagerBasicEnvironmentAdapter logDebug
[java] INFO: Resolving URI "" / prolog.xsl
[java] Warning: on line 331
[java] Evaluation will always fail: there is no context item
[java] Warning: on line 331
[java] Evaluation will always fail: there is no context item
[java] Apr 29, 2016 2:44:35 PM com.pega.pegarules.data.ddl.SchemaGenerator generateCloneDDL
[java] SEVERE: Found errors generating ddl to clone the source schema.
[java] Apr 29, 2016 2:44:35 PM com.pega.pegarules.data.ddl.SchemaGenerator generateCloneDDL
[java] SEVERE: The generated sql is incomplete
[java] Apr 29, 2016 2:44:35 PM com.pega.pegarules.data.ddl.SchemaGenerator generateCloneDDL
[java] SEVERE: ERROR: The table pr_index_circumstance_def was ignored because the following column(s) were not recognized: CreatedInSendMailer: bit, IsPostACA: bit
[java] Exception in thread "main" java.lang.IllegalStateException: Error generating ddl for mssql, Rule2
[java] Generated DDL cannot be applied automatically due to parsing errors.
[java] at com.pega.pegarules.data.ddl.SchemaGenerator.main(SchemaGenerator.java:1639)
[java] Caused by: java.lang.Exception: Generated DDL cannot be applied automatically due to parsing errors.
[java] at com.pega.pegarules.data.ddl.SchemaGenerator.generateCloneDDL(SchemaGenerator.java:951)
[java] at com.pega.pegarules.data.ddl.SchemaGenerator.main(SchemaGenerator.java:1636)

BUILD FAILED
E:\Pega7.2UPDATE_Template2\115042_Pega72UP\scripts\migrateSystem.xml:532: The following error occurred while executing this line:
E:\Pega7.2UPDATE_Template2\115042_Pega72UP\scripts\setupDDL.xml:294: Java returned: 1

Total time: 1 minute 56 seconds
Exiting with Error

Steps to Reproduce

Run migrate.bat/sh

Root Cause

migrate.bat/sh is not able to handle SQL server data type 'bit' and throwing the error above. 

Resolution

Change data type from 'bit' to integer and run migrate.bat