DSN Socket communication error while doing rpd online check in obiee12c

Avinash Pentyala

Hi All,

we have recently migrated from 11g to 12c version 12.2.1.2,the issue is while we are doing the check in online rpd the server is crashing and throwing an socket communication error

at the servername 9514.we have tried with 9514 only but still we are facing the issue.please find the crash report that is generated by the bi server after it shutting down when we close the rpd which is in online mode then only the server is working and we are able to login.

Im not able to connect with oracle bi server but its working with oracle bi server - oracle_home in dsn,is this causing the issue?

Please assist

BACKTRACE:

/obiee/fmw/bi/bifoundation/server/bin/libnqutilityserver64.so(+0x122dde)[0x7f1d16f35dde]

/lib64/libpthread.so.0(+0xf370)[0x7f1d15385370]

/obiee/fmw/bi/bifoundation/server/bin/libnqsexecevalutil64.so(_ZN14JobAcctBuffMgr16TableNameMatchedEP10ARpGatewayRK14NQStringVector+0x41)[0x7f1d1ef66af1]

/obiee/fmw/bi/bifoundation/server/bin/libnqsexecevalutil64.so(_ZN14JobAcctBuffMgr10InitializeERK23JobAccountingDescriptorRN7_SASSTL3mapIN3sup6StringIwNS3_9allocatorIwEEEEjNS3_4lessIS9_EENS7_INS3_4pairIKS9_jEEEEEERN10ServerInfo10TargetTypeERNSI_7CLITypeERS9_SN_RNS3_3setIS9_SB_NS7_IS9_EEEEP26DirectInsertJobAcctMgrBaseP10ARpGateway+0x298)[0x7f1d1ef6a8a8]

/obiee/fmw/bi/bifoundation/server/bin/libnqsexecevalutil64.so(_ZN26DirectInsertJobAcctMgrBase36SetJobAcctBuffMgrToAvailableSnapshotEN23JobAccountingDescriptor21JobAccountingInfoTypeE+0x252)[0x7f1d1ef3f302]

/obiee/fmw/bi/bifoundation/server/bin/libnqsexecevalutil64.so(_ZN22DirectInsertJobAcctMgr11WriteRecordER10AStatsBasebRKN3sup6StringIwN7_SASSTL9allocatorIwEEEEP10ARpGateway+0x111)[0x7f1d1ef3e891]

/obiee/fmw/bi/bifoundation/server/bin/libnqsserventry64.so(_ZN10NQSRequest31OutputAndClearRequestStatisticsEv+0x5b0)[0x7f1d191a8860]

/obiee/fmw/bi/bifoundation/server/bin/libnqsserventry64.so(_ZN10NQSRequest5ClearEv+0x8d)[0x7f1d191ac6ed]

/obiee/fmw/bi/bifoundation/server/bin/libnqsserventry64.so(_ZN10NQSRequest5FetchEPhjRjii+0xd45)[0x7f1d191af925]

/obiee/fmw/bi/bifoundation/server/bin/libnqsdriver64.so(_ZN13ServerRequest5FetchEPhjRjii+0xab)[0x7f1d1f53092b]

/obiee/fmw/bi/bifoundation/server/bin/libnqsdriver64.so(_Z5FetchRKN7_SASSTL6vectorIhNS_9allocatorIhEEEERS3_+0x3db)[0x7f1d1f52c79b]

/obiee/fmw/bi/bifoundation/server/bin/libnqutilitycomm64.so(_ZN15ServerResponder15HandleReadInputERK11NQMsgHeaderRKN7_SASSTL6vectorIhNS3_9allocatorIhEEEER17SocketServerEndPt+0xe7)[0x7f1d17562357]

/obiee/fmw/bi/bifoundation/server/bin/libnqutilitycomm64.so(_ZN15ServerResponder10ServerLoopER17SocketServerEndPt+0x1b5)[0x7f1d17561dd5]

/obiee/fmw/bi/bifoundation/server/bin/libnqutilitycomm64.so(_ZN16SocketPoolServer13ExecuteServerER17SocketServerEndPt+0x29)[0x7f1d17567289]

/obiee/fmw/bi/bifoundation/server/bin/libnqutilitycomm64.so(_ZN23SocketServerEndPtThread4MainEv+0x208)[0x7f1d175674c8]

/obiee/fmw/bi/bifoundation/server/bin/libnqutilitygeneric64.so(_ZN16NQExecutionState17ExecuteSystemMainEv+0x89)[0x7f1d17276f39]

/obiee/fmw/bi/bifoundation/server/bin/libnqutilitygeneric64.so(_ZN15NQThreadJobBase17ExecuteSystemMainEv+0x4c)[0x7f1d172b30bc]

/obiee/fmw/bi/bifoundation/server/bin/libnqutilitygeneric64.so(_ZN16NQExecutionState17ExecuteSystemMainEv+0x89)[0x7f1d17276f39]

/obiee/fmw/bi/bifoundation/server/bin/libnqutilitygeneric64.so(_ZN8NQThread17ExecuteSystemMainEv+0x56)[0x7f1d172b1f06]

/obiee/fmw/bi/bifoundation/server/bin/libnqutilitygeneric64.so(_ZN8NQThread15ThreadMainEntryEPv+0x2e)[0x7f1d172b24ae]

/lib64/libpthread.so.0(+0x7dc5)[0x7f1d1537ddc5]

/lib64/libc.so.6(clone+0x6d)[0x7f1d1488c73d]

================================================================

Avinash Pentyala

To implement the solution, please execute the following steps:

1) Back up the RPD with the changes

2) stop all the services with the stop.sh command from the directory <oracle_home>/user_projects/domains/bi/bitools/bin/

3) <<$ORACLE_HOME>>/domains/bi/bidata/service_instances/ssi/metadata/datamodel/customizations and delete liverpd.* and all other versions of RPD.

4) Navigate to the directory <oracle_home>/domains/bi/bitools/bin/ and run the command: nohup ./start.sh & to start all OBIEE 12c services in the background.

Run the command >>> tail -f nohup.out to view the starting progress

5) Once the services started with the default RPD, Login to OBIEE 12c as an administrator user to ensure that you can login.

6) Deploy the latest changed RPD using data-model-cmd.sh script in <obiee_home>/domains/bi/bitools/bin

Regards,

Avinash