DB error while running Repo Scan utility

[Former Member]

Hi,

I'm facing  below error while trying to run repository scan utility in BOXIR3.1SP6FP2 at Linux server 5.5.

TNSPING to db instance ABCD is working fine and connecting via SQLPlus however running the utility script is throwing below error. Please advce.

./boe_reposcan-dbdriver oracledatabasesubsystem -connect "UID=BOCMS;PWD=*******;DSN=ABCD;HOSTNAME=RAC;PORT=1521"
-inputfrsdir /opt/busobj/data/frsinput -outputfrsdir /opt/busobj/data/frsoutput -outputdir /opt/busobj/bobje/enterprise120/reposcan

Initializing...RepoScan
error: BusinessObjects Enterprise CMS: Unable to connect to the CMS system
database ""ABCD:RAC:1521"". Reason:
ORA-12541: TNS:no listener

Thanks.,

Karthik

[Former Member · Accepted solution]

Thanks all,

I've get past the TNS listener issue by repointing the env variables to 32bit version of Oracle client.

However got another error (see below) and found to be the bug with BOXIR3.1SP6FP2 & BI4.1.

Error:

./boe_reposcan.sh: line 56: 4871 Segmentation fault

(core dumped)

$CE_CMDLINE_PREFIX "$REPOSCANBIN" "$@"

Cause:

This was identified as a regression, and tracked as ADAPT01709286

• SAP BusinessObjects Enterprise XI 3.1, Fix Pack 6.3
• SAP BusinessObjects Enterprise XI 3.1, Service Pack 7
• SAP Business Intelligence Platform 4.1, Support Package 03

I've to wait till we upgrade to next higher packs.

Best regards,

Karthik

[srinivasan_vinayagam]

Hi Karthik,

Check ORACLE_HOME and TNS_ADMIN environment.

Make sure that the listener is up and listening on the address

lsnrctl status

Try to login  sqlplus "/ as sysdba"

SQL> connect username/password@ABCD as sysdba

Regards,

V Srinivasan

[former_member185603]

Can you try without adding Hostname and Port? If your TNSnames.ora file already has this information ], it is not necessary to define .

And also i did not see any repair option in your parameters.

[Former Member]

Hi Jawahar,

Repo script still throughing the same error even after removing the host name and port parameter.

I just want to find the existing inconsistencies between CMS and file reposiytory before repairing it.

Thanks,

Karthik