Skip to Main Content
Cloud Platform

Shape the future of IBM!

We invite you to shape the future of IBM, including product roadmaps, by submitting ideas that matter to you the most. Here's how it works:

Post your ideas

Start by posting ideas and requests to enhance a product or service. Take a look at ideas others have posted and upvote them if they matter to you,

  1. Post an idea

  2. Upvote ideas that matter most to you

  3. Get feedback from the IBM team to refine your idea

Help IBM prioritize your ideas and requests

The IBM team may need your help to refine the ideas so they may ask for more information or feedback. The offering manager team will then decide if they can begin working on your idea. If they can start during the next development cycle, they will put the idea on the priority list. Each team at IBM works on a different schedule, where some ideas can be implemented right away, others may be placed on a different schedule.

Receive a notification on the decision

Some ideas can be implemented at IBM, while others may not fit within the development plans for the product. In either case, the team will let you know as soon as possible. In some cases, we may be able to find alternatives for ideas which cannot be implemented in a reasonable time.

If you encounter any issues accessing the Ideas portals, please send email describing the issue to ideasibm@us.ibm.com for resolution.

For more information about IBM's Ideas program visit ibm.com/ideas.

Status Not under consideration
Workspace UrbanCode
Categories Deploy
Created by Guest
Created on Apr 11, 2016

Update SQLCMD and SQL JDBC plugin to enhance error handling

By the end of the DB deployment, our process demands a list of all such files that failed during execution. As with the current palettes ? RunSQLCmd and SQL JDBC, it is not possible to get the output of each file on some location, we are trying to pull a list of all failed scripts from the UDeploy logs. But we are facing some challenge ? The output in UDeploy log is such that the name of the failed script is not appearing next to this line: ?Failed to execute?. Instead, the entire script code that got failed gets written next to ?Failed to execute?. In such a case it is challenging for us to pull a list of files that failed.

This can probably be achieved through shell scripting, but we are trying to make use of as many palettes as possible other than shell scripting palette. Can you please suggest on this and check to see if the Udeploy log format for JDBC plugin could be changed so that we can get the failed file name right next to this line- ?Failed to execute?.

[sql] Executing resource: C:\ibm-ucd\XXX\var\work\DDL_DB_Deployment_Testing2\FirstScript.sql
[sql] Executing resource: C:\ibm-ucd\xxxxxxx\var\work\DDL_DB_Deployment_Testing2\SecondScript.sql
[sql] Executing resource: C:\ibm-ucd\xxxxx\var\work\DDL_DB_Deployment_Testing2\ThirdScript.sql
[sql] 1 of 3 SQL statements executed successfully
[sql] Failed to execute: use BondDeploy update bond_deplmj,hjkoy_log set project='Rock' where [db_name] ='DBREF001'
[sql] com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near ','.
[sql] Failed to execute: use BondDeploy update bond_deploy_log set project='Diamond' where [db_name] ='DBCAM001' dhfhyjuty select * from bond_deploy_log
[sql] com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'dhfhyjuty'.

Idea priority Medium
RFE ID 86663
RFE URL
RFE Product UrbanCode Deploy
  • Admin
    Osman Burucu
    Jun 22, 2022

    Thank You for entering and providing information to this RFE. Due the age and changes in the products over time additional functionality was introduced which could help to adress this RFE, this RFE will be closed.

    Please provide a new RFE based on the latest versions if needed

  • Guest
    Apr 12, 2016

    Although the theme of this request is consistent with our business strategy, it is not committed to the release that is currently under development. The development team will look to adding highlighting to the output of the plugins.