Topic
2 replies Latest Post - ‏2011-11-24T06:45:51Z by [re-arrange]
[re-arrange]
[re-arrange]
2 Posts
ACCEPTED ANSWER

Pinned topic IDMT Error SQLCODE -4499 when deploying PL/SQL objects

‏2011-11-21T08:12:25Z |
Hi all,

I hope that this forum is being monitored actively. We are trying to migrate from Oracle10G to DB2 ESE 9.7.5 using IBM Data Movement Tools. All tables, sequences, views, synonyms and non PL/SQL object can be extracted and deployed. However when we try to deploy PL/SQL objects e.g triggers, functions, procedures and packages we hit either SQLCODE: -4499 ( or SQLCODE: -4470. This is deployed via Interactive Deploy tab.

Usually after a -4499 error has been hit, the connection is closed so subsequent objects deployment will return -4470.

We use Oracle packages heavily in our applications. In our Oracle packages, the "TYPE as Object" declaration are being used; it can be extracted, but the deployment failed. All triggers, functions, procedures and packages seem to be a fail deployment.

The attached screenshot is an example of our trigger being deployed and returned the mention error.

We use IDMT version 2.00-b2114.

The IDMT tool doesn't show any syntax error in the PL/SQL code and quick Googling on SQLCODE: -4499 / SQLCODE: -4470 doesn't help much.

What did we do wrong? And how can a PL/SQL objects extracted using IDMT be deployed into DB2?

Appreciate your replies...

Regards,
Sallehin.
Updated on 2011-11-24T06:45:51Z at 2011-11-24T06:45:51Z by [re-arrange]
  • SystemAdmin
    SystemAdmin
    708 Posts
    ACCEPTED ANSWER

    Re: IDMT Error SQLCODE -4499 when deploying PL/SQL objects

    ‏2011-11-23T15:43:02Z  in response to [re-arrange]
    When you right click on the line (which shows the error in bottom right hand pane), click on the get error message and that will show the detailed error message.
    • [re-arrange]
      [re-arrange]
      2 Posts
      ACCEPTED ANSWER

      Re: IDMT Error SQLCODE -4499 when deploying PL/SQL objects

      ‏2011-11-24T06:45:51Z  in response to SystemAdmin
      That doesn't helped either. Here's the detailed error message printed when I right-click:
      SQL Error Code = -4499
      Object Type = FUNCTION
      Object Name = JAZZ_CUSTOM_HASH
      Schema = ICBA10
      Line Num = -1
      Message =

      This is quite a weird error...