UCMDB and UD Practitioners Forum (Previously CMS)
Showing results for 
Search instead for 
Do you mean 

UCMDB population from UCMCB: ORA-00936

SOLVED
Go to Solution
Valued Contributor

UCMDB population from UCMCB: ORA-00936

Hello,

I have UCMDB 10.x integrastion point.  Population job loops until restart Integration Service.

probe-infra.log:
<2016-06-02 13:56:36,890> [WARN ] [JobExecuterWorker-0:DS_UCMDB_XX_xx] (DBLog.java:53) - Failed com.hp.ucmdb.discovery.library.dal.ProcessRedundantDAO:insertDiscoveryResults select objectid from DDM_DISCOVERY_RESULTS where OBJECTID in () order by result_id for update nowait. Message: [mercury][Oracle JDBC Driver][Oracle]ORA-00936: missing expression

PS: UCMDB 10.22 CUP1, CP19

3 REPLIES
Valued Contributor

Re: UCMDB population from UCMCB: ORA-00936

Hi,

I'm having the same problem.

Today I tested fresh installation of 10.22 CP 15 (I did not updated CP).

I was installing patch by patch (10.20, 10.20 CUP1, 10.21, 10.21 CUP1, 10.22) and after installing 10.22 CUP 1 IS went crazy with same error messages. Until then every import from RTSM to UCMDB went well.

So 10.22 CUP1 is probably corrupted or something.

Valued Contributor

Re: UCMDB population from UCMCB: ORA-00936

I installed UCMDB 10.22 CUP2. Problem fixed.

Valued Contributor

Re: UCMDB population from UCMCB: ORA-00936

I can confirm also that there is no ORA error messages and that import from BSM to UCMDB works as expected.

//Add this to "OnDomLoad" event