tRr469jY

1Database: jdbc:sqlserver://mssql:1433;jaasConfigurationName=SQLJDBCDriver;serverPreparedStatementDiscardThreshold=10;enablePrepareOnFirstPreparedStatementCall=false;fips=false;socketTimeout=0;authentication=NotSpecified;authenticationScheme=nativeAuthentication;xopenStates=false;sendTimeAsDatetime=true;trustStoreType=JKS;trustServerCertificate=false;TransparentNetworkIPResolution=true;serverNameAsACE=false;sendStringParametersAsUnicode=true;selectMethod=direct;responseBuffering=adaptive;queryTimeout=-1;packetSize=8000;multiSubnetFailover=false;loginTimeout=15;lockTimeout=-1;lastUpdateCount=true;encrypt=false;disableStatementPooling=true;databaseName=DEVELOP;columnEncryptionSetting=Disabled;applicationName=Microsoft JDBC Driver for SQL Server;applicationIntent=readwrite; (Microsoft SQL Server 14.0)
2SQLServer does not support setting the schema for the current session. Default schema NOT changed to dbo
3Successfully validated 15 migrations (execution time 00:00.010s)
4Creating Schema History table: [DEVELOP].[dbo].[schema_version_mailchimp]
5Successfully baselined schema with version: 0
6Current version of schema [dbo]: 0
7Migrating schema [dbo] to version 1 - advertiser
8Migrating schema [dbo] to version 2 - ad group
9Migrating schema [dbo] to version 3 - default actions
10Migrating schema [dbo] to version 4 - ad group additional fields
11Migrating schema [dbo] to version 5 - unsubscription
12Migrating schema [dbo] to version 6 - mc vendor to event types
13Migrating schema [dbo] to version 7 - add mailchimp list id column
14Migrating schema [dbo] to version 8 - add subjectline to adgroup
15Migrating schema [dbo] to version 9 - add mailchimp status
16Migrating schema [dbo] to version 10 - add last sync datetime to mailchimp advertiser
17Migrating schema [dbo] to version 11 - mailchimp creative prototype
18ERROR: Migration of schema [dbo] to version 11 - mailchimp creative prototype failed! Changes successfully rolled back.
19ERROR: 
20Migration V11__mailchimp_creative_prototype.sql failed
21------------------------------------------------------
22SQL State  : S0000
23Error Code : 1767
24Message    : Foreign key 'FK_MailChimpCreativePrototype_CreativePrototype' references invalid table 'CreativePrototype'.
25Location   : ./mailchimp/V11__mailchimp_creative_prototype.sql (/opt/migrations/feature/./mailchimp/V11__mailchimp_creative_prototype.sql)
26Line       : 1
27Statement  : IF NOT EXISTS (SELECT 1 FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[MailChimpCreativePrototype]') AND type = N'U')
28BEGIN
29    CREATE TABLE dbo.MailChimpCreativePrototype (
30        Id int NOT NULL,
31        ChannelEntityId NVARCHAR(255),
32        CONSTRAINT FK_MailChimpCreativePrototype_CreativePrototype FOREIGN KEY(Id) REFERENCES CreativePrototype(Id),
33        CONSTRAINT UK_MailChimpCreativePrototype_ParentId UNIQUE (Id)
34    )
35END;
36
37Makefile:31: recipe for target 'db-campaign-manager-migrate' failed
38make: *** [db-campaign-manager-migrate] Error 1