Troubleshooting

When we ran the check script, no issues

SharkBWAPP1:~ #  ./check-libuuid.sh
[ check-libuuid.sh Revision : #24 $ Date : 2016/07/25 $ ]
SLES 12 (SP 0) system
libuuid package: libuuid1-2.28-1.43.x86_64
uuidd package: uuidd-2.28-1.43.x86_64
uuidd is active.
uuidd is running with --socket-activation.
installed libuuid and uuidd are ok!
/usr/sbin/uuidd -t ok!
SharkBWAPP1:~ #

When we checked the kernel, seems the version is too high, which is supposed to come with NW750. But our BW on HANA was NW740

We decided to downgrade the Kernel to see how it goes.

Kernel downgrade to 742 and uuidd is OK via SICK check

Later we figured out that a patch for the kernel 745 actually also resolved this error

Install add-on BI_CONT error

Run RSOR

During client copy the following errors happened

So we'll have to create the SAP in the source 000 system. The reason was originally the SAP was deleted in 000 due to the password locked out

After that re-start the client copy and it was OK

SAPGUI configuration for Shark BW on HANA

Note: If you're connecting from our VM insider, please use 'efglobe.com' instead of 'fandezhi.com'

HANA studio configuration

How to create a HANA user

Method 1: from Hana studio

Method 2: from HANA web http://www.fandezhi.com:8051/sap/hana/uis/clients/ushell-app/shells/fiori/FioriLaunchpad.html?siteId=sap|hana|admin|cockpit|app|cockpit

PATCH BW on HANA

Method 1: Use SUM (Software Update Manager), which requires to generate a specific XML file we don't have

Method 2: Use traditional SPAM to patch

Extract the downloaded .SAR files

SharkBWAPP1:a4hadm 57> ls -ltr
total 3937724
drwxrwx--x 5 shark sapsys 4096 Oct 12 01:36 EPS
drwxrwx--x 2 shark sapsys 4096 Oct 12 01:36 etc
drwxrwx--x 3 shark sapsys 4096 Oct 12 01:36 storage
drwxrwx--x 2 shark sapsys 4096 Oct 13 19:24 bin
drwxrwx--x 2 shark sapsys 4096 Oct 13 19:30 data
drwxrwx--x 2 shark sapsys 4096 Oct 13 19:30 cofiles
drwxrwx--x 2 shark sapsys 4096 Oct 13 19:30 buffer
drwxrwx--x 2 shark sapsys 4096 Oct 14 13:52 log
drwxrwx--x 2 shark sapsys 4096 Oct 14 22:18 sapnames
drwxrwx--x 2 shark sapsys 4096 Oct 15 01:51 tmp
-rwxrwxrwx 1 shark root 7522103 Oct 15 12:36 K-74001INSTPI.SAR
-rwxrwxrwx 1 shark root 10178315 Oct 15 12:36 K-74002INSTPI.SAR
-rwxrwxrwx 1 shark root 4691484 Oct 15 12:36 K-74003INSTPI.SAR
-rwxrwxrwx 1 shark root 10674395 Oct 15 12:36 K-74004INSTPI.SAR
-rwxrwxrwx 1 shark root 2579910 Oct 15 12:36 K-74009INPIBASIS.SAR
-rwxrwxrwx 1 shark root 8835615 Oct 15 12:36 K-74009INSAPGWFND.SAR
-rwxrwxrwx 1 shark root 1162132 Oct 15 12:36 K-74010INPIBASIS.SAR
-rwxrwxrwx 1 shark root 9585142 Oct 15 12:36 K-74010INSAPGWFND.SAR
-rwxrwxrwx 1 shark root 333197171 Oct 15 12:36 K-74010INSAPUI.SAR
-rwxrwxrwx 1 shark root 3060900 Oct 15 12:36 K-74011INPIBASIS.SAR
-rwxrwxrwx 1 shark root 21649519 Oct 15 12:36 K-74011INSAPGWFND.SAR
-rwxrwxrwx 1 shark root 528004976 Oct 15 12:36 K-74011INSAPUI.SAR
-rwxrwxrwx 1 shark root 1121209 Oct 15 12:36 K-74012INPIBASIS.SAR
-rwxrwxrwx 1 shark root 16076964 Oct 15 12:36 K-74012INSAPGWFND.SAR
-rwxrwxrwx 1 shark root 466975202 Oct 15 12:36 K-74012INSAPUI.SAR
-rwxrwxrwx 1 shark root 1222911 Oct 15 12:36 K-74013INPIBASIS.SAR
-rwxrwxrwx 1 shark root 20039327 Oct 15 12:36 K-74013INSAPGWFND.SAR
-rwxrwxrwx 1 shark root 186338071 Oct 15 12:36 K-74013INSAPUI.SAR
-rwxrwxrwx 1 shark root 1081672 Oct 15 12:36 K-74014INPIBASIS.SAR
-rwxrwxrwx 1 shark root 1850506 Oct 15 12:36 K-74014INSAPGWFND.SAR
-rwxrwxrwx 1 shark root 190034887 Oct 15 12:36 K-74014INSAPUI.SAR
-rwxrwxrwx 1 shark root 795815 Oct 15 12:36 K-74015INPIBASIS.SAR
-rwxrwxrwx 1 shark root 1543693 Oct 15 12:36 K-74015INSAPGWFND.SAR
-rwxrwxrwx 1 shark root 174520607 Oct 15 12:36 K-74015INSAPUI.SAR
-rwxrwxrwx 1 shark root 647684 Oct 15 12:36 K-75701INBICONT.SAR
-rwxrwxrwx 1 shark root 165415451 Oct 15 12:36 K-74016INSAPUI.SAR
-rwxrwxrwx 1 shark root 1030571 Oct 15 12:36 K-75701INBICONTXT.SAR
-rwxrwxrwx 1 shark root 2674077 Oct 15 12:36 K-75702INBICONT.SAR
-rwxrwxrwx 1 shark root 1223141 Oct 15 12:36 K-75702INBICONTXT.SAR
-rwxrwxrwx 1 shark root 27240372 Oct 15 12:36 K-75703INBICONT.SAR
-rwxrwxrwx 1 shark root 951175 Oct 15 12:36 K-75703INBICONTXT.SAR
-rwxrwxrwx 1 shark root 31134102 Oct 15 12:36 K-75704INBICONT.SAR
-rwxrwxrwx 1 shark root 765041 Oct 15 12:36 K-75705INBICONT.SAR
-rwxrwxrwx 1 shark root 951180 Oct 15 12:36 K-75704INBICONTXT.SAR
-rwxrwxrwx 1 shark root 951176 Oct 15 12:36 K-75705INBICONTXT.SAR
-rwxrwxrwx 1 shark root 7165704 Oct 15 12:36 K-75706INBICONT.SAR
-rwxrwxrwx 1 shark root 951163 Oct 15 12:36 K-75706INBICONTXT.SAR
-rwxrwxrwx 1 shark root 2894445 Oct 15 12:36 K-75707INBICONT.SAR
-rwxrwxrwx 1 shark root 59263262 Oct 15 12:36 K-75707INBICONTXT.SAR
-rwxrwxrwx 1 shark root 11423632 Oct 15 12:36 K-75708INBICONT.SAR
-rwxrwxrwx 1 shark root 13125739 Oct 15 12:36 K-75708INBICONTXT.SAR
-rwxrwxrwx 1 shark root 1202859 Oct 15 12:36 K-75709INBICONT.SAR
-rwxrwxrwx 1 shark root 9783798 Oct 15 12:36 K-75709INBICONTXT.SAR
-rwxrwxrwx 1 shark root 2616546 Oct 15 12:36 K-75710INBICONT.SAR
-rwxrwxrwx 1 shark root 9782916 Oct 15 12:36 K-75710INBICONTXT.SAR
-rwxrwxrwx 1 shark root 5148438 Oct 15 12:36 K-75711INBICONT.SAR
-rwxrwxrwx 1 shark root 9783989 Oct 15 12:36 K-75711INBICONTXT.SAR
-rwxrwxrwx 1 shark root 13098506 Oct 15 12:36 KA74009.SAR
-rwxrwxrwx 1 shark root 10317027 Oct 15 12:36 KA74010.SAR
-rwxrwxrwx 1 shark root 9805300 Oct 15 12:36 KA74011.SAR
-rwxrwxrwx 1 shark root 8214444 Oct 15 12:36 KA74012.SAR
-rwxrwxrwx 1 shark root 6324134 Oct 15 12:36 KA74013.SAR
-rwxrwxrwx 1 shark root 8641735 Oct 15 12:36 KA74014.SAR
-rwxrwxrwx 1 shark root 9625520 Oct 15 12:36 KA74015.SAR
-rwxrwxrwx 1 shark root 165374208 Oct 15 12:36 KB74009.SAR
-rwxrwxrwx 1 shark root 130624641 Oct 15 12:36 KB74010.SAR
-rwxrwxrwx 1 shark root 152507470 Oct 15 12:36 KB74011.SAR
-rwxrwxrwx 1 shark root 80885803 Oct 15 12:36 KB74012.SAR
-rwxrwxrwx 1 shark root 87429608 Oct 15 12:36 KB74013.SAR
-rwxrwxrwx 1 shark root 91017252 Oct 15 12:36 KB74014.SAR
-rwxrwxrwx 1 shark root 156287029 Oct 15 12:36 KB74015.SAR
-rwxrwxrwx 1 shark root 174461409 Oct 15 12:36 KW74009.SAR
-rwxrwxrwx 1 shark root 98492747 Oct 15 12:36 KW74010.SAR
-rwxrwxrwx 1 shark root 107572012 Oct 15 12:36 KW74011.SAR
-rwxrwxrwx 1 shark root 87427105 Oct 15 12:36 KW74012.SAR
-rwxrwxrwx 1 shark root 87487769 Oct 15 12:36 KW74013.SAR
-rwxrwxrwx 1 shark root 90693788 Oct 15 12:36 KW74014.SAR
-rwxrwxrwx 1 shark root 82610313 Oct 15 12:36 KW74015.SAR
SharkBWAPP1:a4hadm 58> SAPCAR -xvf '.SAR'
SAPCAR: processing archive KA74012.SAR (version 2.01)
x EPS/in/CSN0120061532_0095294.PAT
SAPCAR: 1 file(s) extracted
SAPCAR: processing archive KA74015.SAR (version 2.01)
x EPS/in/I720020751259_0102242.PAT
SAPCAR: 2 file(s) extracted
SAPCAR: processing archive KA74011.SAR (version 2.01)
x EPS/in/CSR0120031469_0093750.PAT
SAPCAR: 3 file(s) extracted
SAPCAR: processing archive KA74013.SAR (version 2.01)
x EPS/in/CSR0120031469_0097185.PAT
SAPCAR: 4 file(s) extracted
SAPCAR: processing archive K-74015INPIBASIS.SAR (version 2.01)
x EPS/in/I720020751259_0102240.PAT
SAPCAR: 5 file(s) extracted
SAPCAR: processing archive K-75705INBICONT.SAR (version 2.01)
x EPS/in/CSN0120061532_0092796.PAT
SAPCAR: 6 file(s) extracted
SAPCAR: processing archive K-74001INSTPI.SAR (version 2.01)
x EPS/in/CSR0120031469_0090837.PAT
SAPCAR: 7 file(s) extracted
SAPCAR: processing archive K-75708INBICONTXT.SAR (version 2.01)
x EPS/in/CSN0120061532_0099292.PAT
SAPCAR: 8 file(s) extracted
SAPCAR: processing archive K-74015INSAPGWFND.SAR (version 2.01)
x EPS/in/I720020751259_0102241.PAT
SAPCAR: 9 file(s) extracted
SAPCAR: processing archive K-75706INBICONTXT.SAR (version 2.01)
x EPS/in/CSN0120061532_0094792.PAT
SAPCAR: 10 file(s) extracted
SAPCAR: processing archive K-75706INBICONT.SAR (version 2.01)
x EPS/in/CSN0120061532_0094934.PAT
SAPCAR: 11 file(s) extracted
SAPCAR: processing archive K-75702INBICONT.SAR (version 2.01)
x EPS/in/CSN0120061532_0087348.PAT
SAPCAR: 12 file(s) extracted
SAPCAR: processing archive K-75703INBICONT.SAR (version 2.01)
x EPS/in/CSN0120061532_0083848.PAT
x EPS/in/CSN0120061532_0089237.PAT
SAPCAR: 14 file(s) extracted
SAPCAR: processing archive KW74013.SAR (version 2.01)
x EPS/in/CSR0120031469_0097187.PAT
SAPCAR: 15 file(s) extracted
SAPCAR: processing archive K-74014INSAPGWFND.SAR (version 2.01)
x EPS/in/CSN0120061532_0100092.PAT
SAPCAR: 16 file(s) extracted
SAPCAR: processing archive K-74009INPIBASIS.SAR (version 2.01)
x EPS/in/CSR0120031469_0090338.PAT
SAPCAR: 17 file(s) extracted
SAPCAR: processing archive KB74011.SAR (version 2.01)
x EPS/in/CSN0120061532_0099384.PAT
x EPS/in/CSR0120031469_0093998.PAT
SAPCAR: 19 file(s) extracted
SAPCAR: processing archive K-74002INSTPI.SAR (version 2.01)
x EPS/in/CSN0120061532_0095710.PAT
x EPS/in/CSR0120031469_0093292.PAT
SAPCAR: 21 file(s) extracted
SAPCAR: processing archive K-74013INSAPGWFND.SAR (version 2.01)
x EPS/in/CSR0120031469_0096706.PAT
x EPS/in/CSR0120031469_0097184.PAT
SAPCAR: 23 file(s) extracted
SAPCAR: processing archive K-75707INBICONT.SAR (version 2.01)
x EPS/in/CSR0120031469_0096635.PAT
x EPS/in/CSR0120031469_0096709.PAT
SAPCAR: 25 file(s) extracted
SAPCAR: processing archive K-74009INSAPGWFND.SAR (version 2.01)
x EPS/in/CSR0120031469_0090339.PAT
SAPCAR: 26 file(s) extracted
SAPCAR: processing archive K-74010INPIBASIS.SAR (version 2.01)
x EPS/in/CSN0120061532_0091944.PAT
SAPCAR: 27 file(s) extracted
SAPCAR: processing archive KB74013.SAR (version 2.01)
x EPS/in/CSN0120061532_0099384.PAT
x EPS/in/CSR0120031469_0097186.PAT
SAPCAR: 29 file(s) extracted
SAPCAR: processing archive K-75704INBICONTXT.SAR (version 2.01)
x EPS/in/CSN0120061532_0091184.PAT
SAPCAR: 30 file(s) extracted
SAPCAR: processing archive K-75702INBICONTXT.SAR (version 2.01)
x EPS/in/CSN0120061532_0087349.PAT
SAPCAR: 31 file(s) extracted
SAPCAR: processing archive K-75709INBICONTXT.SAR (version 2.01)
x EPS/in/CSN0120061532_0100628.PAT
x EPS/in/I720020751259_0101001.PAT
SAPCAR: 33 file(s) extracted
SAPCAR: processing archive KW74010.SAR (version 2.01)
x EPS/in/CSN0120061532_0092510.PAT
SAPCAR: 34 file(s) extracted
SAPCAR: processing archive K-74011INPIBASIS.SAR (version 2.01)
x EPS/in/CSR0120031469_0093748.PAT
SAPCAR: 35 file(s) extracted
SAPCAR: processing archive K-74016INSAPUI.SAR (version 2.01)
x EPS/in/I720020751259_0101729.PAT
SAPCAR: 36 file(s) extracted
SAPCAR: processing archive K-74011INSAPGWFND.SAR (version 2.01)
x EPS/in/CSR0120031469_0093997.PAT
SAPCAR: 37 file(s) extracted
SAPCAR: processing archive K-75710INBICONTXT.SAR (version 2.01)
x EPS/in/I710020751258_0103503.PAT
SAPCAR: 38 file(s) extracted
SAPCAR: processing archive KA74010.SAR (version 2.01)
x EPS/in/CSN0120061532_0091946.PAT
SAPCAR: 39 file(s) extracted
SAPCAR: processing archive KB74014.SAR (version 2.01)
x EPS/in/CSN0120061532_0100096.PAT
x EPS/in/CSN0120061532_0100571.PAT
SAPCAR: 41 file(s) extracted
SAPCAR: processing archive KB74010.SAR (version 2.01)
x EPS/in/CSN0120061532_0092519.PAT
x EPS/in/CSN0120061532_0099384.PAT
SAPCAR: 43 file(s) extracted
SAPCAR: processing archive K-75711INBICONT.SAR (version 2.01)
x EPS/in/I710020751258_0104157.PAT
x EPS/in/I720020751259_0105473.PAT
SAPCAR: 45 file(s) extracted
SAPCAR: processing archive KW74012.SAR (version 2.01)
x EPS/in/CSN0120061532_0095296.PAT
SAPCAR: 46 file(s) extracted
SAPCAR: processing archive K-75709INBICONT.SAR (version 2.01)
x EPS/in/CSR0120031469_0100977.PAT
SAPCAR: 47 file(s) extracted
SAPCAR: processing archive K-74004INSTPI.SAR (version 2.01)
x EPS/in/I710020751258_0104160.PAT
x EPS/in/I710020751258_0104345.PAT
SAPCAR: 49 file(s) extracted
SAPCAR: processing archive K-75705INBICONTXT.SAR (version 2.01)
x EPS/in/CSN0120061532_0092797.PAT
SAPCAR: 50 file(s) extracted
SAPCAR: processing archive KA74009.SAR (version 2.01)
x EPS/in/CSR0120031469_0090340.PAT
SAPCAR: 51 file(s) extracted
SAPCAR: processing archive K-74015INSAPUI.SAR (version 2.01)
x EPS/in/CSN0120061532_0099762.PAT
SAPCAR: 52 file(s) extracted
SAPCAR: processing archive K-74012INSAPUI.SAR (version 2.01)
x EPS/in/CSR0120031469_0093348.PAT
SAPCAR: 53 file(s) extracted
SAPCAR: processing archive KB74012.SAR (version 2.01)
x EPS/in/CSN0120061532_0095995.PAT
x EPS/in/CSN0120061532_0099384.PAT
SAPCAR: 55 file(s) extracted
SAPCAR: processing archive K-75701INBICONTXT.SAR (version 2.01)
x EPS/in/CSR0120031469_0085204.PAT
SAPCAR: 56 file(s) extracted
SAPCAR: processing archive K-75701INBICONT.SAR (version 2.01)
x EPS/in/CSR0120031469_0085202.PAT
SAPCAR: 57 file(s) extracted
SAPCAR: processing archive KW74009.SAR (version 2.01)
x EPS/in/CSR0120031469_0090817.PAT
SAPCAR: 58 file(s) extracted
SAPCAR: processing archive K-74014INPIBASIS.SAR (version 2.01)
x EPS/in/CSN0120061532_0100091.PAT
SAPCAR: 59 file(s) extracted
SAPCAR: processing archive K-74011INSAPUI.SAR (version 2.01)
x EPS/in/CSN0120061532_0091655.PAT
SAPCAR: 60 file(s) extracted
SAPCAR: processing archive K-74010INSAPGWFND.SAR (version 2.01)
x EPS/in/CSN0120061532_0092075.PAT
SAPCAR: 61 file(s) extracted
SAPCAR: processing archive K-74010INSAPUI.SAR (version 2.01)
x EPS/in/CSR0120031469_0090304.PAT
SAPCAR: 62 file(s) extracted
SAPCAR: processing archive K-74013INPIBASIS.SAR (version 2.01)
x EPS/in/CSR0120031469_0097183.PAT
SAPCAR: 63 file(s) extracted
SAPCAR: processing archive K-75704INBICONT.SAR (version 2.01)
x EPS/in/CSN0120061532_0091182.PAT
SAPCAR: 64 file(s) extracted
SAPCAR: processing archive KW74014.SAR (version 2.01)
x EPS/in/CSN0120061532_0100095.PAT
SAPCAR: 65 file(s) extracted
SAPCAR: processing archive K-74012INSAPGWFND.SAR (version 2.01)
x EPS/in/CSN0120061532_0095293.PAT
SAPCAR: 66 file(s) extracted
SAPCAR: processing archive KW74011.SAR (version 2.01)
x EPS/in/CSR0120031469_0093752.PAT
SAPCAR: 67 file(s) extracted
SAPCAR: processing archive KB74015.SAR (version 2.01)
x EPS/in/I720020751259_0102541.PAT
SAPCAR: 68 file(s) extracted
SAPCAR: processing archive K-75707INBICONTXT.SAR (version 2.01)
x EPS/in/CSR0120031469_0096637.PAT
SAPCAR: 69 file(s) extracted
SAPCAR: processing archive K-74013INSAPUI.SAR (version 2.01)
x EPS/in/CSN0120061532_0094893.PAT
SAPCAR: 70 file(s) extracted
SAPCAR: processing archive KB74009.SAR (version 2.01)
x EPS/in/CSN0120061532_0099384.PAT
x EPS/in/CSR0120031469_0090856.PAT
SAPCAR: 72 file(s) extracted
SAPCAR: processing archive K-75711INBICONTXT.SAR (version 2.01)
x EPS/in/I710020751258_0104168.PAT
x EPS/in/I720020751259_0105475.PAT
SAPCAR: 74 file(s) extracted
SAPCAR: processing archive K-75710INBICONT.SAR (version 2.01)
x EPS/in/I710020751258_0103497.PAT
x EPS/in/I720020751259_0101538.PAT
SAPCAR: 76 file(s) extracted
SAPCAR: processing archive K-75708INBICONT.SAR (version 2.01)
x EPS/in/CSN0120061532_0099293.PAT
x EPS/in/CSR0120031469_0098687.PAT
SAPCAR: 78 file(s) extracted
SAPCAR: processing archive KA74014.SAR (version 2.01)
x EPS/in/CSN0120061532_0100093.PAT
SAPCAR: 79 file(s) extracted
SAPCAR: processing archive K-74014INSAPUI.SAR (version 2.01)
x EPS/in/CSR0120031469_0096707.PAT
x EPS/in/CSR0120031469_0096837.PAT
SAPCAR: 81 file(s) extracted
SAPCAR: processing archive K-74003INSTPI.SAR (version 2.01)
x EPS/in/CSR0120031469_0096660.PAT
x EPS/in/CSR0120031469_0098463.PAT
SAPCAR: 83 file(s) extracted
SAPCAR: processing archive KW74015.SAR (version 2.01)
x EPS/in/I720020751259_0102244.PAT
SAPCAR: 84 file(s) extracted
SAPCAR: processing archive K-74012INPIBASIS.SAR (version 2.01)
x EPS/in/CSN0120061532_0095292.PAT
SAPCAR: 85 file(s) extracted
SAPCAR: processing archive K-75703INBICONTXT.SAR (version 2.01)
x EPS/in/CSN0120061532_0089239.PAT
SAPCAR: 86 file(s) extracted
SharkBWAPP1:a4hadm 59> pwd
/usr/sap/trans
SharkBWAPP1:a4hadm 60> rm .SAR
SharkBWAPP1:a4hadm 61>