Skip to Content
0

User's are not able to access the Crystal report

Jan 23 at 09:24 AM

67

avatar image

Dear All,

User's are not able to access the crystal reports.

  • I have cleared var/tmp folder with
  • find . -mtime +120 |grep .tmp |xargs rm
  • find . -mtime +120 |grep .rpt|xargs rm these commands.Then onwards they are not able to access.

issue.png issue2.png.log file also generated like "

  1. ErrorLog 2018 1 22 23:26:31.334 4511 48 (../cdtsagent.cpp:3191): CDTSagent::doOneRequest reqId=103: CSResultException thrown. ErrorSrc:"CRPE" FileName:"../reporthand
    ler.cpp" LineNum:1164 ErrorCode:501 ErrorMsg:"" DetailedErrorMsg:""

Environment details:

  • Business Objects Version (SP Level): 11.5.10.1263
  • Patch level of Business Objects: SP4
  • Deployment (Standalone/Clustered): Clustered
  • System Type:(Prod/Test/Dev): Production
  • Server OS (SP Level): Sun OS 5.10
  • Application Server (IIS/Tomcat/Others) : Others (WAS)
  • CMS database: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0.

My environment is Clustered with two node.I performed on node 1 but not in node 2.while request comes node 1 it showing blank page and request comes to 2node report is generating. Now what I did is Node1 all the RAS servers I have stopped for production impact.

Please Can you provide the solution.

issue.png (39.0 kB)
issue2.png (4.9 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Megh Vora Jan 23 at 12:58 PM
0

Hello Bhargava,

Firstly you are on a non supported platform. XI R2 is completely out of support and I strongly recommend you to come on a supported platform of 4.x. Preferably BI 4.2.x

Coming to your issue, since when you started facing this problem. Any other changes made apart from clearing the /var/tmp folder?

Try rebooting entire server box (both node 1 & 2) and bring primary node up first then the secondary one.

Try creating a new RAS and check.

Is the issue with only one report or all the CRs?

Thanks,

Megh

Show 4 Share
10 |10000 characters needed characters left characters exceeded

Thanks for the reply.

Any other changes made apart from clearing the /var/tmp folder? --->No changes made by me.only I cleared the /tmp.

we tried for the rebooting the server but it not worked and even I created new RAS server as well still we are getting same error.

It is impacting on Production environment. Please suggest the possiblilites.

0

we found these error in logging :

Timestamp ProcessID ThreadID Message
[Tue Jan 23 17:24:47 2018] 29035 1 assert failure: (src/sacom.cpp:353). (false : Library /opt/crystal/bobje/enterprise115/solaris_sparc/ras/librptdefmodel.
so could not be loaded: Loading shared object failed. First tried to load library /opt/crystal/bobje/enterprise115/solaris_sparc/ras/librptdefmodel.so and failed becaus
e of error: [ld.so.1: boe_crystalras: fatal: /opt/crystal/bobje/enterprise115/solaris_sparc/ras/librptdefmodel.so: open failed: No such file or directory]. Second tried
to load library /opt/crystal/bobje/enterprise115/solaris_sparc/ras/liblibrptdefmodel.so and failed because of error: [ld.so.1: boe_crystalras: fatal: /opt/crystal/bobj
e/enterprise115/solaris_sparc/ras/liblibrptdefmodel.so: open failed: No such file or directory])."

We found the few .so files and .crpe file got deleted in "/opt/crystal/bobje/enterprise115/solaris_sparc/ras" path ?

In box 2 these files are exist.

Please suggest what action we should take?

0

Try to source the environment variable (env.sh) and check.

To do this, stop the SIA on the affected node.

I am unsure of the exact location for XI R2 environment, but for XI 3.1, environment the env.sh it is under bobje/setup directory.

After stopping of the SIA, you need to source this env.sh file by running the command by either of the below ways

source env.sh

OR

./env.sh

OR

.env.sh

Next, under the bobje directory you will see a tmp directory; clear this directory.

Start the SIA and check if RAS now comes up.

You can also do ldd to the library name that is there in the error message and check for its dependencies. See KBA for reference:

1183210 - Page server fails to start on UNIX

Thanks,

Megh

0

[Thu Jan 25 07:53:37 2018] 6617 71 assert failure: (sessionmgr.cpp:1871). (0 : An expected entry in the session refcount map is not found).
[Thu Jan 25 07:53:37 2018] 6617 30 assert failure: (sessionmgr.cpp:1871). (0 : An expected entry in the session refcount map is not found).
[Thu Jan 25 07:53:39 2018] 6617 46 assert failure: (sessionmgr.cpp:1871). (0 : An expected entry in the session refcount map is not found).
[Thu Jan 25 07:54:23 2018] 6617 77 assert failure: (sessionmgr.cpp:1871). (0 : An expected entry in the session refcount map is not found).
[Thu Jan 25 07:54:39 2018] 6617 71 assert failure: (sessionmgr.cpp:1871). (0 : An expected entry in the session refcount map is not found).
bash-3.2$

we are getting the error.

0
Denis Konovalov
Jan 23 at 01:02 PM
0

If I understood correctly - you have 2 node cluster where one of the nods has failing RAS server and the other node is fine.
Correct ?
Based on error you presented - could be an issue with C++ libraries on that node -- was it recently updated ?
The BOE product you're using is very, very, very old and might not work with newer OS patches or updates.
You need to upgrade to current product version.

Show 8 Share
10 |10000 characters needed characters left characters exceeded

Hi Denis,

Based on error you presented - could be an issue with C++ libraries on that node -- was it recently updated?--->we have not updated any.Can you please explain.


we are in migration to 4.2 sp3 it is going to live with in 3 months.So we have to close the current production issue.Can you please suggest.

0

we found these error in logging :

Timestamp ProcessID ThreadID Message
[Tue Jan 23 17:24:47 2018] 29035 1 assert failure: (src/sacom.cpp:353). (false : Library /opt/crystal/bobje/enterprise115/solaris_sparc/ras/librptdefmodel.
so could not be loaded: Loading shared object failed. First tried to load library /opt/crystal/bobje/enterprise115/solaris_sparc/ras/librptdefmodel.so and failed becaus
e of error: [ld.so.1: boe_crystalras: fatal: /opt/crystal/bobje/enterprise115/solaris_sparc/ras/librptdefmodel.so: open failed: No such file or directory]. Second tried
to load library /opt/crystal/bobje/enterprise115/solaris_sparc/ras/liblibrptdefmodel.so and failed because of error: [ld.so.1: boe_crystalras: fatal: /opt/crystal/bobj
e/enterprise115/solaris_sparc/ras/liblibrptdefmodel.so: open failed: No such file or directory])."

We found the few .so files and .crpe file got deleted in "/opt/crystal/bobje/enterprise115/solaris_sparc/ras" path ?

In box 2 these files are exist.

Please suggest what action we should take?

0

how would those files get deleted ? you need to investigate this and root out the reason, because if that is allowed to happen - you're going to have this sort of issues continuously.

If the files were deleted, than obvious solution is to restore them.
If your second node is fine, then stop all BOE processes on both nodes and copy content of

/opt/crystal/bobje/enterprise115/solaris_sparc/ras/ from good node to the "bad" node.
Then start both and see.

0

Hi Denis,

Can you suggest me can I create new inputfrs server?we can disable the existing IFRS.

0

What does FRS has to do with anything ?
If you want to create new server, you can do it in serverconfig.sh

0

Now I got this error after add the removed files from box2 to box 1.

[Thu Jan 25 07:53:37 2018] 6617 71 assert failure: (sessionmgr.cpp:1871). (0 : An expected entry in the session refcount map is not found).
[Thu Jan 25 07:53:37 2018] 6617 30 assert failure: (sessionmgr.cpp:1871). (0 : An expected entry in the session refcount map is not found).
[Thu Jan 25 07:53:39 2018] 6617 46 assert failure: (sessionmgr.cpp:1871). (0 : An expected entry in the session refcount map is not found).
[Thu Jan 25 07:54:23 2018] 6617 77 assert failure: (sessionmgr.cpp:1871). (0 : An expected entry in the session refcount map is not found).
[Thu Jan 25 07:54:39 2018] 6617 71 assert failure: (sessionmgr.cpp:1871). (0 : An expected entry in the session refcount map is not found).
bash-3.2$

All the RAS services are automatically going to stop.

0

how exactly have you copied those files ?

0

Dear Denis ,

Thanks for the Support.Issue got fixed after the restoration of the .so files from BOX2 to BOX1.

1