Topic
  • 1 reply
  • Latest Post - ‏2012-06-11T08:12:58Z by mohkawa
mohkawa
mohkawa
9 Posts

Pinned topic IDMT running > 3 hours and insufficient privilege only for SINGLESM.xxx

‏2012-06-11T05:56:34Z |
1. I got insufficient privilege error only against something like the following SQLs.
SELECT MAX(dbms_lob.getlenth("PASSWORD")) from "SINGLESM"."BIN$pBCPOBJECTvgRAAhKKX/OA==$0"

Question:
What does this do? Should I solve this?
Does granting SELECT_CATALOG_ROLE solve this problem? (I am not sure if it's already added or not, because this is customer environment.)
This seems to check PASSWORD. So I am afraid that my customer wouldn't want to allow me.

2. In 50 minutes after starting running IDMT, the following message was displayed. After that, IDMT is still keeping running more than 3 hours without any messages.
http://2012-06-11 11.52.50.286 Blade_3 unloaded 5 rows in 0.63 sec xxx.xxx 2160/2213

The log file doesn't have anything after the above.
File dates are:
2012/06/11 11:53 218,046 IBMDataMovementTool.log
2012/06/11 11:18 5,351 IBMDataMovementToolError.log

The first file contains the following errors.
...
http://2012-06-11 11.04.32.623 Error in executing sql = SELECT MAX(DBMS_LOB.GETLENGTH("PASSWORD")) FROM "SINGLESM".xxxx
http://2012-06-11 11.04.32.670 Error in executing sql = SELECT MAX(DBMS_LOB.GETLENGTH("PASSWORD")) FROM "SINGLESM".xxxx
http://2012-06-11 11.04.32.701 Error in executing sql = SELECT MAX(DBMS_LOB.GETLENGTH("PASSWORD")) FROM "SINGLESM".xxxx
...
http://2012-06-11 11.18.39.994 Exception processing SQL=SELECT * FROM "MNTDV4URA"."TJT_OUTER_TAB_COLUMNS" Message=ORA-06564 Object DBAWORK_DIR doesn't exist.

The latter file contains only the above 4 errors.

Thanks,
Updated on 2012-06-11T08:12:58Z at 2012-06-11T08:12:58Z by mohkawa
  • mohkawa
    mohkawa
    9 Posts

    Re: IDMT running > 3 hours and insufficient privilege only for SINGLESM.xxx

    ‏2012-06-11T08:12:58Z  
    I extracted and loaded DDL only. It finished though the same error occurred.
    So can I ignore the error messages I mentioned before?
    When I tried extracting data only, it's the same. It keeps running after 2160/2213 data is unloaded.
    So I guess data may be huge.
    Is there way to know which table's data is being extracted?