Jump to content
Sign in to follow this  
mshece

Knowledge search fails

Recommended Posts

Hi

Knowledge search failed. It happened earlier also. But after running pdm_k_index.exe , it worked fine.

But now, Its getting error while execution..

"The program was not successful due to a critical error. Please see the log files for further details."

in logs we found the following errors :

9/01 09:10:17.31 :EBR_FULLTE 4579 ERROR orclclass.c 1264 SQL Statement Failed. ORA: 1000 Message: ORA-01000: maximum open cursors exceeded

09/01 09:10:17.31 sqlagt:EBR_FULLTE 4579 ERROR orclclass.c 1265 TRUNCATE TABLE EBR_FULLTEXT

09/01 09:10:17.31 . pdm_k_reindex 414 SEVERE_ERROR BPebrReindex.c 622 EBR::REINDEX::EBR::BPebrReindex::recvmsg::in "MTH::EBR::REINDEX::truncate_table_reply::EBR_FULLTEXT" method. Error: 15: AHD04199:An unexpected error occurred. Contact your administrator. ORA-01000: maximum open cursors exceeded

please help me to get it resolved..

Regards

MX

Share this post


Link to post
Share on other sites
Hi,

have you google it?

http://stackoverflow.com/questions/1219259...ursors-exceeded

Seems you need to contact CA Support.

Hi

Now i executed pdm_k_reindex.exe. but while executing the log errors as follows.

09/03 09:57:24.85 xxxxx. sqlagt:EBR_FULLTE 4579 ERROR orcl.c 548 Max number of connections retries (NX_SQL_CONNECTION_RETRY=5) has been reached for upinde_agent

09/03 09:57:24.86 xxxxxx. sqlagt:EBR_FULLTE 4579 ERROR orcl.c 549 Failed clause (INSERT INTO EBR_FULLTEXT_ADM ( DOC_TYPE, ENTITY_ID, FULL_WORD, FULL_WORD_REVERSE, PERMISSION_INDEX_ID, PRODUCT, SHORT_WORD, TABLE_ID, WORD_COUNT, WORD_COUNT_PROBLEM, WORD_COUNT_RESOLUTION, WORD_COUNT_SUMMARY, WORD_COUNT_TITLE, WORD_IDF, WORD_ORDER, WORD_TYPE, last_mod_by, last_mod_dt, ID ) VALUES ( :val1 , :val2 , :val3 , :val4 , :val5 , :val6 , :val7 , :val8 , :val9 , :val10 , :val11 , :val12 , :val13 , :val14 , :val15 , :val16 , :val17 , :val18 , :val19 ))

09/03 09:57:24.86 xxxxxxxx. sqlagt:EBR_FULLTE 4579 ERROR

from UI docs are not retrieving at all. please help to get it resolved.

Regards

MX

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...