Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
4 replies Latest Post - ‏2012-07-19T11:20:58Z by Antonello_Supino
Antonello_Supino
Antonello_Supino
54 Posts
ACCEPTED ANSWER

Pinned topic SQW03023E: Metadata insertion failed for the application

‏2012-07-16T13:00:57Z |
Hello,
I have a DWH application that runs fine in Design Studio but during the deployment in ISW admin console it fails with the following error:

SQW03023E: Metadata insertion failed for the application: TEST_APP. Please refer to the logs for detailed information
This is the most detailed log I can find:
16/07/12 12:46:25:040 GMT 0000007e DSLog-12a14ec E ====================================================================================================================================
16/07/12 12:46:25:041 GMT 0000007e DSLog-12a14ec E |TIMESTAMP: Mon Jul 16 12:46:25 GMT 2012
16/07/12 12:46:25:041 GMT 0000007e DSLog-12a14ec E |OPERATION: DeployInstall.doFinish(true)
16/07/12 12:46:25:041 GMT 0000007e DSLog-12a14ec E |STATUS: FAILURE
16/07/12 12:46:25:042 GMT 0000007e DSLog-12a14ec E |STATUS CODE: 3023
16/07/12 12:46:25:042 GMT 0000007e DSLog-12a14ec E |STATUS MESSAGE: SQW03023E: Metadata insertion failed for the application: TEST_APP. Please refer to the logs for detailed information.
16/07/12 12:46:25:042 GMT 0000007e DSLog-12a14ec E |STATUS RESULT: com.ibm.datatools.sqwruntime.deployment.util.DeploymentHelper.insertApplication(DeploymentHelper.java:328)
com.ibm.datatools.sqwruntime.deployment.api.DeployInstall.insertApplication(DeployInstall.java:746)
com.ibm.datatools.sqwruntime.deployment.api.DeployInstall.doFinish(DeployInstall.java:1295)
com.ibm.datatools.sqwruntime.deployment.api.DeployInstall.doFinish(DeployInstall.java:934)
com.ibm.datatools.admin.sqw.appmgmt.DeployAppController.handleRequest(DeployAppController.java:114)
org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48
...
Could you please suggest me where I can find any log with more detailed information?

Maybe it is because a field is too long (maybe an email body) and if I could have further information of what (maybe a database insert) is failing this can help me a lot.

Thanks
Antonello Supino
Updated on 2012-07-19T11:20:58Z at 2012-07-19T11:20:58Z by Antonello_Supino
  • SystemAdmin
    SystemAdmin
    203 Posts
    ACCEPTED ANSWER

    Re: SQW03023E: Metadata insertion failed for the application

    ‏2012-07-17T01:59:06Z  in response to Antonello_Supino
    hi Antonello,
    Please work with the L2 team to create a PMR for this problem.
    • Antonello_Supino
      Antonello_Supino
      54 Posts
      ACCEPTED ANSWER

      Re: SQW03023E: Metadata insertion failed for the application

      ‏2012-07-17T08:49:20Z  in response to SystemAdmin
      Thanks, but I were able to figure out the error was caused by one of the email operator which body became long 1073 characters. After rewording it to something shorter the deployment issue disappeared.

      It seems that the email body is inserted into a metadata table column with a length of 1024 character, more or less, but there is no check or length limitation waning in the Design Studio operator to enforce this limit at user interface level.

      Is this limitation somewhere documented at least?

      Antonello
  • zxning
    zxning
    20 Posts
    ACCEPTED ANSWER

    Re: SQW03023E: Metadata insertion failed for the application

    ‏2012-07-19T09:39:12Z  in response to Antonello_Supino
    Yes, the email message length should be less than 1024. I cannot find where this was documented either. We suggest that if you want to send something longer than 1024, you can use the file attachment, instead of put a long text in the message body.