Topic
  • 4 replies
  • Latest Post - ‏2012-07-19T11:20:58Z by Antonello_Supino
Antonello_Supino
Antonello_Supino
54 Posts

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

    Re: SQW03023E: Metadata insertion failed for the application

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

    Re: SQW03023E: Metadata insertion failed for the application

    ‏2012-07-17T08:49:20Z  
    hi Antonello,
    Please work with the L2 team to create a PMR for this problem.
    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

    Re: SQW03023E: Metadata insertion failed for the application

    ‏2012-07-19T09:39:12Z  
    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.
  • Antonello_Supino
    Antonello_Supino
    54 Posts

    Re: SQW03023E: Metadata insertion failed for the application

    ‏2012-07-19T11:20:58Z  
    • zxning
    • ‏2012-07-19T09:39:12Z
    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.
    Cheers
    Antonello