Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
6 replies
Subscribers
6 subscribers
Views
4311 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Plug-Ins
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...
OriginalPostID-224608
OriginalPostID-224608
Discussion posts and replies are publicly visible
Parents
0
Eduardo Fuentes
Appian Employee
over 7 years ago
I'd try the one-single line approach.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Eduardo Fuentes
Appian Employee
over 7 years ago
I'd try the one-single line approach.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data