Forum Stats

  • 3,839,596 Users
  • 2,262,511 Discussions
  • 7,901,008 Comments

Discussions

API0259: Read-Only mode when running OMBPlus.sh Import

ilkeun-Oracle
ilkeun-Oracle Member Posts: 4 Employee
edited Oct 6, 2008 12:18AM in Warehouse Builder
hi,

I got
ORA-27369: job of type EXECUTABLE failed with exit code: Not owner STANDARD_ERROR="PUB04202: Import of XXEGO_AGENT_APPROVE_V1 into oracle module APPS failed due to non-internal reasons: API0259: The object cannot be edited in Read-Only mode!."
during import oracle db(syncronize) objects via OMBPlus.sh w/tcl.


-- script

OMBCREATE TRANSIENT IMPORT_ACTION_PLAN 'IMPORT_PLAN_ERPINT2_XXAP' ADD ACTION 'IMPORT_ACTION_ERPINT2_XXAP' \
SET REF SOURCE TABLE 'XXAP_C_INVOICE1' \
SET REF SOURCE TABLE 'XXAP_C_INVOICE2' \
SET REF SOURCE TABLE 'XXAP_C_INVOICE3' \
...
SET REF TARGET ORACLE_MODULE '$Module']

OMBIMPORT FROM METADATA_LOCATION FOR IMPORT_ACTION_PLAN 'IMPORT_PLAN_ERPINT2_XXAP'
OMBSAVE

-- script end


I'm the only user in owb, there is connect session when running.
It's occured not to every object but specific object.
And it is ok when first import to the module, it occurs when import to exsiting objects (= syncronize).
Tagged:

Answers

  • ilkeun-Oracle
    ilkeun-Oracle Member Posts: 4 Employee
    bolow is the result after set debug on




    API0254: Cannot have write lock on the component.
    at oracle.wh.repos.pdl.lock.LockMaster.verifyWriteLock(LockMaster.java:289)
    at oracle.wh.repos.pdl.lock.TransactionToHolderMap.beforeEditComponent(TransactionToHolderMap.java:49)
    at oracle.wh.repos.pdl.lock.LockModuleImpl.beforeEditComponent(LockModuleImpl.java:160)
    at oracle.wh.repos.pdl.dispatcher.EventDispatcherImpl.beforeEditNonNameField(EventDispatcherImpl.java:672)
    at oracle.wh.repos.pdl.foundation.OWBRoot.beforeEdit(OWBRoot.java:3537)
    at oracle.wh.repos.owbGen.CMPWBViewGen.setSelectQuery(CMPWBViewGen.java:284)
    at oracle.wh.repos.impl.relational.CMPWBView.setSubjectSelectQuery(CMPWBView.java:129)
    at oracle.wh.repos.impl.relational.CMPWBView.setSelectQuery(CMPWBView.java:596)
    at oracle.wh.ui.integrator.common.ImportEntityAlgorithm.importViewDefinition(ImportEntityAlgorithm.java:2507)
    at oracle.wh.ui.integrator.common.ImportEntityAlgorithm.importView(ImportEntityAlgorithm.java:1183)
    at oracle.wh.ui.integrator.common.ImportEntityAlgorithm.dispatchElement(ImportEntityAlgorithm.java:557)
    at oracle.wh.ui.integrator.common.ImportEntityAlgorithm.importElement(ImportEntityAlgorithm.java:368)
    at oracle.wh.ui.integrator.sdk.EntityAccessor.importElement(EntityAccessor.java:80)
    at oracle.owb.oracle.OracleModuleImpl.importObject(OracleModuleImpl.java:1917)
    at oracle.owb.oracle.OracleModuleImpl.dbImport(OracleModuleImpl.java:1641)
    at oracle.owb.scripting.executers.ImportCmdExecuter.executeImportActionPlan(ImportCmdExecuter.java:230)
    at oracle.owb.scripting.parsers.ImportCmdParser.oracleDBImportCommand(ImportCmdParser.java:352)
    at oracle.owb.scripting.parsers.ImportCmdParser.ImportCommand(ImportCmdParser.java:155)
    at oracle.owb.scripting.parsers.ImportCmdParser.parseCommand(ImportCmdParser.java:112)
    at oracle.owb.scripting.commands.OMBMetaDataImportCmd.executeCommand(OMBMetaDataImportCmd.java:77)
    at oracle.owb.scripting.commands.OMBCommand.cmdProc(OMBCommand.java:69)
    at tcl.lang.Parser.evalObjv(Parser.java(Compiled Code))
    at tcl.lang.Parser.eval2(Parser.java(Compiled Code))
    at tcl.lang.Parser.evalTokens(Parser.java(Compiled Code))
    at tcl.lang.Parser.eval2(Parser.java:1208)
    at tcl.lang.Interp.eval(Interp.java:2189)
    at tcl.lang.Interp.evalFile(Interp.java:2368)
    at tcl.lang.TclShell.run(TclShell.java:124)
    at tcl.lang.TclShell.run(TclShell.java:68)
    at oracle.owb.scripting.OMBShell.main(OMBShell.java:38)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:85)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:58)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:60)
    at java.lang.reflect.Method.invoke(Method.java:391)
    at Launcher.main(Launcher.java:167)
    oracle.owb.foundation.OWBException: PUB04202: Import of XXEGO_AGENT_APPROVE_V1 into oracle module APPS failed due to non-internal re
    asons: API0259: The object cannot be edited in Read-Only mode!.
    at oracle.owb.oracle.OracleModuleImpl.importObject(OracleModuleImpl.java:1921)
    at oracle.owb.oracle.OracleModuleImpl.dbImport(OracleModuleImpl.java:1641)
    at oracle.owb.scripting.executers.ImportCmdExecuter.executeImportActionPlan(ImportCmdExecuter.java:230)
    at oracle.owb.scripting.parsers.ImportCmdParser.oracleDBImportCommand(ImportCmdParser.java:352)
    at oracle.owb.scripting.parsers.ImportCmdParser.ImportCommand(ImportCmdParser.java:155)
    at oracle.owb.scripting.parsers.ImportCmdParser.parseCommand(ImportCmdParser.java:112)
    at oracle.owb.scripting.commands.OMBMetaDataImportCmd.executeCommand(OMBMetaDataImportCmd.java:77)
    at oracle.owb.scripting.commands.OMBCommand.cmdProc(OMBCommand.java:69)
    at tcl.lang.Parser.evalObjv(Parser.java(Compiled Code))
    at tcl.lang.Parser.eval2(Parser.java(Compiled Code))
    at tcl.lang.Parser.evalTokens(Parser.java(Compiled Code))
    at tcl.lang.Parser.eval2(Parser.java:1208)
    at tcl.lang.Interp.eval(Interp.java:2189)
    at tcl.lang.Interp.evalFile(Interp.java:2368)
    at tcl.lang.TclShell.run(TclShell.java:124)
    at tcl.lang.TclShell.run(TclShell.java:68)
    at oracle.owb.scripting.OMBShell.main(OMBShell.java:38)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:85)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:58)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:60)
    at java.lang.reflect.Method.invoke(Method.java:391)
    at Launcher.main(Launcher.java:167)
    tcl.lang.TclException: PUB04202: Import of XXEGO_AGENT_APPROVE_V1 into oracle module APPS failed due to non-internal reasons: API025
    9: The object cannot be edited in Read-Only mode!.
    at oracle.owb.scripting.commands.OMBMetaDataImportCmd.throwTclException(OMBMetaDataImportCmd.java:102)
    at oracle.owb.scripting.commands.OMBMetaDataImportCmd.executeCommand(OMBMetaDataImportCmd.java:80)
    at oracle.owb.scripting.commands.OMBCommand.cmdProc(OMBCommand.java:69)
    at tcl.lang.Parser.evalObjv(Parser.java(Compiled Code))
    at tcl.lang.Parser.eval2(Parser.java(Compiled Code))
    at tcl.lang.Parser.evalTokens(Parser.java(Compiled Code))
    at tcl.lang.Parser.eval2(Parser.java:1208)
    at tcl.lang.Interp.eval(Interp.java:2189)
    at tcl.lang.Interp.evalFile(Interp.java:2368)
    at tcl.lang.TclShell.run(TclShell.java:124)
    at tcl.lang.TclShell.run(TclShell.java:68)
    at oracle.owb.scripting.OMBShell.main(OMBShell.java:38)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:85)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:58)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:60)
    at java.lang.reflect.Method.invoke(Method.java:391)
    at Launcher.main(Launcher.java:167)
    PUB04202: Import of XXEGO_AGENT_APPROVE_V1 into oracle module APPS failed due to non-internal reasons: API0259: The object cannot be
    edited in Read-Only mode!.
  • SweAnderline
    SweAnderline Member Posts: 219
    try to login as sys(as sysdba) and
    grant execute any procedure to username
  • ilkeun-Oracle
    ilkeun-Oracle Member Posts: 4 Employee
    Thanks, SweAnderline

    I grant execute any procedure to owbadmin (repository owner)

    but, I got same problem.

    Is there any comments?

    Thanks again.
  • SweAnderline
    SweAnderline Member Posts: 219
    Im not sure what the problem might be, you seem to have privilege issues(looks like resp owner issues). You are tying to import data into a existing module? Did you check your targetlocation?

    Cheers
  • ilkeun-Oracle
    ilkeun-Oracle Member Posts: 4 Employee
    It happens only when it's impoeted to exsiting project/module/object(tables/views). When it's imported first time (need to create), there is no error.
    btw.
    I granted dba to repository owner, but same ploblem.
This discussion has been closed.