Problem with deleting application version

oleg_d

Active Member
I have following situation:
1. in IV for some application new version added P4210|M999
2. in OMV(OL) in my default project this P4210|M999 appears
3. I'm trying to delete from project P4210|M999 and getting error - "General Error in method, Delete", in OMW Logging presents information "OMW Object Type APPLVER, Object ID P4210!M999 delete failed.
";
in jdedebug.log after deleting (DELETE FROM PY810.F983051 WHERE ( VRPID = 'P4210' AND VRVERS = 'M999' ))
I have found just following incorrect (IMHO) lines, which can somehow explains situation:
[ QUOTE ]
Entering JDB_FetchKeyed
ORACLE DBRsetReq conn=0A1B3D50 requ=11CE13E0 HS201 (ORCL)
SELECT * FROM DD810.F9207 WHERE ( FRDTAI = '138U' )
ORACLE DBFetch: Invoke OCI Fetch fetchNumRows = 100
Fetched the record
Entering jdeCloseDictionary
Entering JDB_FreeUser (UserHandle 11C4B7D8)
Exiting JDB_FreeUser with Success(UserHandle 11C4B7D8)
Exited jdeCloseDictionary with DDType 0
ERROR INFO JDEERR - ID= 0, Error= 138U - \b9\client\jdeomw\OMWProject\OMWProject.cpp, Line= 3387
Entering JDB_FreeUser (UserHandle 11D503C0)
Exiting JDB_FreeUser with Success(UserHandle 11D503C0)
Decermenting a reference on an Environment Context at address, 0x11946230
Entering JDB_RollbackUser (UserHandle 11D3D850)
Rolling back commit point 1 of the transaction : 1560608778_2520_3244_255382977
ORACLE DBRollbackCon envr=0A1B3C48 conn=11D23448
Starting Commit Point No : 2 for Transaction ID : 1560608778_2520_3244_255382977
Exiting JDB_RollbackUser with Success (UserHandle 11D3D850)
Successfully rolled back the transaction.
Entering JDB_CloseTable
Entering JDB_CloseTable(Table = F983051)
Entering JDB_ClearSequencing
Exiting JDB_ClearSequencing with Success


[/ QUOTE ]
there transaction is rolled back and result - version is not deleted.
Does anybody know what is the problem with E1?

Thanks
 
Hello,

Make sure the version isn't in any other projects besides the one you are trying to delete the version in.

Matthew
 
A couple of things to try or check:

1.) Anything in the jde.log?
2.) Have you tried using the OMW logging?
3.) Try checking out/checking in and then deleting
4.) Turn debug on and try deleting to see what is actually happening.
The logging and the jde.log are your best bet.
 
[ QUOTE ]
A couple of things to try or check:

1.) Anything in the jde.log?
2.) Have you tried using the OMW logging?
3.) Try checking out/checking in and then deleting
4.) Turn debug on and try deleting to see what is actually happening.
The logging and the jde.log are your best bet.

[/ QUOTE ]

Hi!
1. I tested this problem on new version, so it wasn't placed in other projects.
2. jde.log dosn't have any information
3. jdedebug.log has information only that I have already post it above.(as I think, I can attach compressed jdedebug.log);
I post information from log file with full debug mode.
4.OMW Logging - just said that deleting failed:
[ QUOTE ]
OMW Object Type APPLVER, Object ID P4210!M705 delete failed.

[/ QUOTE ]
5. I will try to check in/out.

Thanks

P.S. I have attached jdedebug.log (there are a lot of lines
smile.gif
and after operation <font class="small">Code:</font><hr /><pre> DELETE FROM PY810.F983051 WHERE ( VRPID = 'P4210' AND VRVERS = 'M705' ) </pre><hr />
you can see(if you will open log file) a little below rollback operation:
[ QUOTE ]
ERROR INFO JDEERR - ID= 0, Error= 138U - \b9\client\jdeomw\OMWProject\OMWProject.cpp, Line= 3387
Entering JDB_FreeUser (UserHandle 124D69F8)
Exiting JDB_FreeUser with Success(UserHandle 124D69F8)
Decermenting a reference on an Environment Context at address, 0x12331cd8
Entering JDB_RollbackUser (UserHandle 124D6CF8)
Rolling back commit point 1 of the transaction : 1543831562_3868_1132_255374752
ORACLE DBRollbackCon envr=0A20D3A0 conn=1256D6A8
Starting Commit Point No : 2 for Transaction ID : 1543831562_3868_1132_255374752
Exiting JDB_RollbackUser with Success (UserHandle 124D6CF8)
Successfully rolled back the transaction.


[/ QUOTE ]
and I think between this places some problem
grin.gif
grin.gif
grin.gif
 
Back
Top