An error might occur when you run the ANT-generated Data Definition Language script (sqlserver_state_vector_ddl.sql) during deployment. As a result, the deployment might fail to create the necessary SAS Anti-Money Laundering database schemas and tables in Microsoft SQL Server.
The sqlserver_state_vector_ddl.sql script contains a missing comma between column definitions in the select statement when creating the FSC_ACCOUNT_STATE_VECTOR_FACT table view.
Here is an example:
CREATE VIEW FCFBU1.FSC_ACCOUNT_STATE_VECTOR_FACT AS
SELECT FCFCORE.FSC_ACCOUNT_STATE_VECTOR_FACT.account_number (comma missing) FCFCORE.FSC_ACCOUNT_STATE_VECTOR_FACT.date_key, ...
To circumvent this issue, manually correct the syntax error in the script.
This issue will be fixed in SAS® Anti-Money Laundering 7.2 M1 Hot Fix 1.