Hi, Regarding Deployment Automation Manager, I noticed that there is

georgeb768 over 7 years ago

Hi,

Regarding Deployment Automation Manager, I noticed that there is a problem when I try to import an application from command prompt, together with a sql script that creates a view. I used the plugin succesfully with SQL scripts containing updates, inserts etc. The script starts like this "CREATE OR REPLACE VIEW "BUSINESS"."cdtcltaskdatafordashboard"("assessmenttype", "assessmentid", "parentprocessid") AS WITH "taskassignee" AS (SELECT .....". This SQL run succesfully afterwards in the target environment.

The output of Deployment Automation Manager is: Port set to 80 2016-07-20 10:16:41,464 - Status: In Progress. Current step: Inspecting Application. 2016-07-20 10:16:46,927 - Status: Failed. Current step: Executing DDL Scripts. Log file URL: intranet-test.rbro.rbg.cc/.../65163. Error message: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=ASWITH;, "parentprocessid");AS, DRIVER=3.63.75.

Th...

Discussion posts and replies are publicly visible

Parents

0 georgeb768 over 7 years ago

Hi,

I have tried the one-single line approach, replacing each new line with a space. The create view query looks fine and runs successfully from a DB2 IDE. From Deployment Automation Manager import command, I have another error: Error message: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-10, SQLSTATE=42603, SQLERRMC=', DRIVER=3.63.75.

What can I try further? Thanks.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 georgeb768 over 7 years ago

Hi,

I have tried the one-single line approach, replacing each new line with a space. The create view query looks fine and runs successfully from a DB2 IDE. From Deployment Automation Manager import command, I have another error: Error message: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-10, SQLSTATE=42603, SQLERRMC=', DRIVER=3.63.75.

What can I try further? Thanks.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data