Raff.
If you actually take a peak inside the sapextractor.sh file you can see what it's trying to do with these parameters. It's looking for a couple of jar files based on your OrgChart installation path.
Take a look in
/usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root/WEB-INF/lib/
I'm guessing you'll see two files in here something like this...
Assuming you do, you should just need to pass in the names of these files excluding the extension (as this is appended on by the script).
e.g. "NakisaFrameworkBin" and "NakisaTrollBin".
Hope that helps
Stephen.
Hi Stephen,
Thanks for your assist on this.
I manage to execute with below command:
sh /usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root/sapextractor.sh /sapmnt/NKD/exe/jvm/linuxx86_64/sapjvm_6.1.006/sapjvm_6/bin /usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root/.system/Admin_Config/__000__DHS_STAGED_001 /sapmnt/NKD/exe/jvm/linuxx86_64/sapjvm_6.1.006/sapjvm_6/jre/lib/amd64/server/sapjco3.jar NakisaFrameworkBin NakisaTrollBin true true true
And its throwing me this error:
Exception in thread "main" java.lang.NoClassDefFoundError: com/nakisa/sap/extractor/commandline/SAPExtractorCommandLine Caused by: java.lang.ClassNotFoundException: com.nakisa.sap.extractor.commandline.SAPExtractorCommandLine at java.net.URLClassLoader$1.run(URLClassLoader.java:261) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:249) at java.lang.ClassLoader.loadClass(ClassLoader.java:362) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:319) at java.lang.ClassLoader.loadClass(ClassLoader.java:307) at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:375)
The path to the OrgChart application looks to be pointing a few levels too deep. you want to be pointing to the deployment path of the application not to your Admin_Config directory. So I think you need to remove "/.system/Admin_Config/"
I think you've also missed a space out before the build name meaning that your 2nd parameter is a bit more wrong and your subsequent parameters are then either out of step or missing.
Passing .jar on the Framework and NakisaTrollBin resulted the same error.
sh /usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root/sapextractor.sh /sapmnt/NKD/exe/jvm/linuxx86_64/sapjvm_6.1.006/sapjvm_6/bin /usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root/.system/Admin_Config/__000__DHS_STAGED_001 /sapmnt/NKD/exe/jvm/linuxx86_64/sapjvm_6.1.006/sapjvm_6/jre/lib/amd64/server/sapjco3.jar NakisaFrameworkBin.jar NakisaTrollBin.jar true true true Exception in thread "main" java.lang.NoClassDefFoundError: com/nakisa/sap/extractor/commandline/SAPExtractorCommandLine Caused by: java.lang.ClassNotFoundException: com.nakisa.sap.extractor.commandline.SAPExtractorCommandLine at java.net.URLClassLoader$1.run(URLClassLoader.java:261) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:249) at java.lang.ClassLoader.loadClass(ClassLoader.java:362) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:319) at java.lang.ClassLoader.loadClass(ClassLoader.java:307) at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:375)
Cheers,
Raff
Don't add the ".jar".
Take a look in the sapextractor.sh file. You can see it adds the ".jar" for you. Just do a search for "$5" ... the substitution for the 5th parameter.
Hi Rafaello,
Try this - there was a mistake in yours:
sh /usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root/sapextractor.sh /sapmnt/NKD/exe/jvm/linuxx86_64/sapjvm_6.1.006/sapjvm_6/bin /usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root __000__DHS_STAGED_001 /sapmnt/NKD/exe/jvm/linuxx86_64/sapjvm_6.1.006/sapjvm_6/jre/lib/amd64/server/sapjco3.jar NakisaFrameworkBin NakisaTrollBin true true true
Best regards,
Luke
Hi Both,
Really appreciate for your assist:
The command quite confusing as I tought the its point to the __000__DHS_STAGED_001 directory.
I manage to use below command:
sh /usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root/sapextractor.sh /sapmnt/NKD/exe/jvm/linuxx86_64/sapjvm_6.1.006/sapjvm_6/bin /usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root/ __000__DHS_STAGED_001 /sapmnt/NKD/exe/jvm/linuxx86_64/sapjvm_6.1.006/sapjvm_6/jre/lib/amd64/server/sapjco3.jar NakisaFrameworkBin NakisaTrollBin true true true
And the here's the outcome: (are this correct ?)
-ap[length:3] 033/usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root//[length:81] -b[length:2] __000__DHS_STAGED_001[length:21] -e[length:2] true[length:4] -j[length:2] true[length:4] -a[length:2] true[length:4] [length:1] Using build path: __000__DHS_STAGED_001 Extract: true Generating Analytics: true Using joins: true Loading Manager Resources: /usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root//.system/Admin_Config/ManagerResources.xml Loading Manager Resources: /usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root//.system/Admin_Config/__000__DHS_STAGED_001/ManagerResources.xml Loading App Resources: /usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root//.system/Admin_Config/__000__DHS_STAGED_001/AppResources Loading Counts: /usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root//.system/Admin_Config/__000__DHS_STAGED_001/Analytics/Counts.xml Loading Extractor Configuration: /usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root//.system/Admin_Config/__000__DHS_STAGED_001/SAPExtractor/extractorSchema Extracting... Exception in thread "main" java.lang.NoClassDefFoundError: com/sap/mw/jco/IRepository at com.nakisa.framework.data.commandProcessor.impl.sap.BaseFunctionProcessor.call(BaseFunctionProcessor.java:86) at Nakisa.SAP.SAPeProcessor.RfcReadTable.getDataSet(RfcReadTable.java:47) at com.nakisa.framework.data.commandProcessor.impl.sap.BaseFunctionProcessor.getDataSetFinal(BaseFunctionProcessor.java:103) at com.nakisa.framework.data.commandProcessor.impl.sap.SAPCommandProcessor.getDataSet(SAPCommandProcessor.java:42) at com.nakisa.framework.data.commandProcessor.CommandProcessor.getDataSet(CommandProcessor.java:369) at com.nakisa.framework.data.DataAccess.getDataSet(DataAccess.java:26) at com.nakisa.sap.extractor.SAPExtractorProcessor.processSimpleFunction(SAPExtractorProcessor.java:1303) at com.nakisa.sap.extractor.SAPExtractorProcessor.processSimpleFunctionAt(SAPExtractorProcessor.java:716) at com.nakisa.sap.extractor.SAPExtractorProcessor.parseFunctionSchema(SAPExtractorProcessor.java:852) at com.nakisa.sap.extractor.SAPExtractorProcessor.extract(SAPExtractorProcessor.java:519) at com.nakisa.sap.extractor.commandline.SAPExtractorCommandLine.startExtractionProcess(SAPExtractorCommandLine.java:141) at com.nakisa.sap.extractor.commandline.SAPExtractorCommandLine.startExtraction(SAPExtractorCommandLine.java:112) at com.nakisa.sap.extractor.commandline.SAPExtractorCommandLine.<init>(SAPExtractorCommandLine.java:103) at com.nakisa.sap.extractor.commandline.SAPExtractorCommandLine.main(SAPExtractorCommandLine.java:70) Caused by: java.lang.ClassNotFoundException: com.sap.mw.jco.IRepository at java.net.URLClassLoader$1.run(URLClassLoader.java:261) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:249) at java.lang.ClassLoader.loadClass(ClassLoader.java:362) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:319) at java.lang.ClassLoader.loadClass(ClassLoader.java:307) at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:375) ... 14 more
Cheers,
Raff
Hi Raff,
It looks like you are using SAP JCo 3, but the extractor uses SAP JCo 2.1.8 or 2.1.10. See the Admin Guide page 54.
Best regards,
Luke
Hi Luke,
My Bad, my admin guide is for Nakisa 3.0 SP1 
I will download JC) 2.1.10 and will let you know.
Cheers,
Raff
Hi Luke,
I saw some fatal error premature when the scripts run.
Its looks done now, are this sign of good news ?
sh /usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root/sapextractor.sh /sapmnt/NKD/exe/jvm/linuxx86_64/sapjvm_6.1.006/sapjvm_6/bin /usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root __000__DHS_STAGED_001 /sapmnt/NKD/exe/jvm/linuxx86_64/sapjvm_6.1.006/sapjvm_6/jre/lib/amd64/server/sapjco.jar NakisaFrameworkBin NakisaTrollBin true true true
-ap[length:3] 033/usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root/[length:80] -b[length:2] __000__DHS_STAGED_001[length:21] -e[length:2] true[length:4] -j[length:2] true[length:4] -a[length:2] true[length:4] [length:1] [Fatal Error] :-1:-1: Premature end of file. [Fatal Error] :-1:-1: Premature end of file. Using build path: __000__DHS_STAGED_001 Extract: true Generating Analytics: true Using joins: true Loading Manager Resources: /usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root/.system/Admin_Config/ManagerResources.xml Loading Manager Resources: /usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root/.system/Admin_Config/__000__DHS_STAGED_001/ManagerResources.xml Loading App Resources: /usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root/.system/Admin_Config/__000__DHS_STAGED_001/AppResources Loading Counts: /usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root/.system/Admin_Config/__000__DHS_STAGED_001/Analytics/Counts.xml Loading Extractor Configuration: /usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root/.system/Admin_Config/__000__DHS_STAGED_001/SAPExtractor/extractorSchema Extracting... Done extracting. Joining tables... Done joining tables. Executing analytics... Admin_Analytics_Generating: PersonFTE ... Admin_Analytics_Generate_Success Admin_Analytics_Generating: TotalPersonFTE ... Admin_Analytics_Generate_Success Admin_Analytics_Generating: PositionFTE ... Admin_Analytics_Generate_Success Admin_Analytics_Generating: TotalPositionFTE ... Admin_Analytics_Generate_Success Admin_Analytics_Generating: Gender ... Admin_Analytics_Generate_Success Admin_Analytics_Generating: GenderDisab ... Admin_Analytics_Generate_Success Admin_Analytics_Generating: Nationality ... Admin_Analytics_Generate_Success Admin_Analytics_Generating: Disab ... Admin_Analytics_Generate_Success Admin_Analytics_Generating: Age ... Admin_Analytics_Generate_Success Admin_Analytics_Generating: Race ... Admin_Analytics_Generate_Success Admin_Analytics_Generating: Ethen ... Admin_Analytics_Generate_Success Admin_Analytics_Generating: UnOcPosCount ... Admin_Analytics_Generate_Success Admin_Analytics_Generating: OcPosCount ... Admin_Analytics_Generate_Success Admin_Analytics_Generating: UnOcVacPosCount ... Admin_Analytics_Generate_Success Admin_Analytics_Generating: OcVacPosCount ... Admin_Analytics_Generate_Success Admin_Analytics_Generating: PersonFTEPos ... Admin_Analytics_Generate_Success Admin_Analytics_Generating: PositionFTEPos ... Admin_Analytics_Generate_Success Admin_Analytics_Generating: GenderCounterPos ... Admin_Analytics_Generate_Success Admin_Analytics_Generating: GenderDisabCountPos ... Admin_Analytics_Generate_Success Admin_Analytics_Generating: NationalityPos ... Admin_Analytics_Generate_Success Admin_Analytics_Generating: DisabPos ... Admin_Analytics_Generate_Success Admin_Analytics_Generating: AgePos ... Admin_Analytics_Generate_Success Admin_Analytics_Generating: RacePos ... Admin_Analytics_Generate_Success Admin_Analytics_Generating: EthenPos ... Admin_Analytics_Generate_Success Admin_Analytics_Generating: UnOcPosCountPos ... Admin_Analytics_Generate_Success Admin_Analytics_Generating: OcPosCountPos ... Admin_Analytics_Generate_Success Admin_Analytics_Generating: UnOcVacPosCountPos ... Admin_Analytics_Generate_Success Admin_Analytics_Generating: OcVacPosCountPos ... Admin_Analytics_Generate_Success Done executing analytics.
Hi Raff,
Everything looks fine to me, despite the errors. The next thing is to check the database and the application to make sure it did actually work, but everything seems to point to that from the messagesyou received. However, I would still like to check that error message.
Best regards,
Luke
That looks good. Check the database and the cds.log to see what information it has in it.
You should see information about extract row counts, joins being completed, tables dropped and created and analytics being generated.
If you see errors that don't relate to dropping non-existent objects then you've still got issues.
You should also be able to see your data in OrgChart!
Hi Stephen,
This is what I've got from the log.
Hope it looks good 
13 Apr 2012 10:46:54 INFO com.nakisa.Logger - [Admin console] admin user 'admin' successfully logged in 13 Apr 2012 10:47:10 INFO com.nakisa.Logger - ManagerInit: Time took to setup Build: 7199 ms 13 Apr 2012 10:47:12 INFO com.nakisa.Logger - ManagerInit: Time took to load settingsResources: 115 ms 13 Apr 2012 10:47:15 INFO com.nakisa.Logger - ManagerInit: Time took to load appResources: 1072 ms 13 Apr 2012 10:47:15 INFO com.nakisa.Logger - ManagerInit: Time took to load extractorSchema: 67 ms 13 Apr 2012 10:47:15 INFO com.nakisa.Logger - ManagerInit: Time took to load OTFSchema: 120 ms 13 Apr 2012 10:47:15 INFO com.nakisa.Logger - ManagerInit: Time took to load Role Mapping: 2 ms 13 Apr 2012 10:47:15 INFO com.nakisa.Logger - ManagerInit: Time took to load Roles: 2 ms 13 Apr 2012 11:55:25 INFO com.nakisa.Logger - ManagerSave: Time took to save AppResources: 7494 ms 13 Apr 2012 11:55:27 INFO com.nakisa.Logger - ManagerSave: Time took to save Roles and RoleMapping: 43 ms 13 Apr 2012 11:55:27 INFO com.nakisa.Logger - ManagerSave: Time took to save LanguageDB: 52 ms 13 Apr 2012 11:55:27 INFO com.nakisa.Logger - ManagerSave: Time took to save ExtractorSchema: 159 ms 13 Apr 2012 11:55:27 INFO com.nakisa.Logger - ManagerSave: Time took to save OTFSchema: 122 ms 13 Apr 2012 11:55:29 INFO com.nakisa.Logger - ManagerPublish: Time took to move Tenant Deltas: 226 ms 13 Apr 2012 11:55:30 INFO com.nakisa.Logger - ManagerPublish: Time took to move Configs: 94 ms 13 Apr 2012 11:55:31 INFO com.nakisa.Logger - LoginSettingsObject Load: 8 13 Apr 2012 11:55:31 INFO com.nakisa.Logger - Refresh in-memory configurations: 135 13 Apr 2012 11:55:35 INFO com.nakisa.Logger - AppResources Load: 3001 13 Apr 2012 12:03:18 INFO com.nakisa.Logger - [Admin console] - logging out user : admin 13 Apr 2012 14:10:24 INFO com.nakisa.Logger - [Admin console] admin user 'admin' successfully logged in 13 Apr 2012 14:10:30 INFO com.nakisa.Logger - ManagerInit: Time took to setup Build: 786 ms 13 Apr 2012 14:10:31 INFO com.nakisa.Logger - ManagerInit: Time took to load settingsResources: 173 ms 13 Apr 2012 14:10:34 INFO com.nakisa.Logger - ManagerInit: Time took to load appResources: 1251 ms 13 Apr 2012 14:10:34 INFO com.nakisa.Logger - ManagerInit: Time took to load extractorSchema: 107 ms 13 Apr 2012 14:10:34 INFO com.nakisa.Logger - ManagerInit: Time took to load OTFSchema: 121 ms 13 Apr 2012 14:10:34 INFO com.nakisa.Logger - ManagerInit: Time took to load Role Mapping: 2 ms 13 Apr 2012 14:10:34 INFO com.nakisa.Logger - ManagerInit: Time took to load Roles: 2 ms 13 Apr 2012 15:59:28 INFO com.nakisa.Logger - [Admin console] - logging out user : admin 13 Apr 2012 16:15:53 INFO com.nakisa.Logger - [Admin console] admin user 'admin' successfully logged in 13 Apr 2012 16:16:02 INFO com.nakisa.Logger - ManagerInit: Time took to setup Build: 1169 ms 13 Apr 2012 16:16:04 INFO com.nakisa.Logger - ManagerInit: Time took to load settingsResources: 114 ms 13 Apr 2012 16:16:06 INFO com.nakisa.Logger - ManagerInit: Time took to load appResources: 918 ms 13 Apr 2012 16:16:07 INFO com.nakisa.Logger - ManagerInit: Time took to load extractorSchema: 49 ms 13 Apr 2012 16:16:07 INFO com.nakisa.Logger - ManagerInit: Time took to load OTFSchema: 119 ms 13 Apr 2012 16:16:07 INFO com.nakisa.Logger - ManagerInit: Time took to load Role Mapping: 2 ms 13 Apr 2012 16:16:07 INFO com.nakisa.Logger - ManagerInit: Time took to load Roles: 2 ms 13 Apr 2012 17:08:57 INFO com.nakisa.Logger - -ap: size=3 13 Apr 2012 17:08:57 INFO com.nakisa.Logger - 033/usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root//: size=81 13 Apr 2012 17:08:57 INFO com.nakisa.Logger - -b: size=2 13 Apr 2012 17:08:57 INFO com.nakisa.Logger - __000__DHS_STAGED_001: size=21 13 Apr 2012 17:08:57 INFO com.nakisa.Logger - -e: size=2 13 Apr 2012 17:08:57 INFO com.nakisa.Logger - true: size=4 13 Apr 2012 17:08:57 INFO com.nakisa.Logger - -j: size=2 13 Apr 2012 17:08:57 INFO com.nakisa.Logger - true: size=4 13 Apr 2012 17:08:57 INFO com.nakisa.Logger - -a: size=2 13 Apr 2012 17:08:57 INFO com.nakisa.Logger - true: size=4 : size=1012 17:08:57 INFO com.nakisa.Logger - 13 Apr 2012 17:08:57 INFO com.nakisa.Logger - <item><name><![CDATA[ap]]></name><value><![CDATA[033/usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root//]]></value></item>< item><name><![CDATA[b]]></name><value><![CDATA[__000__DHS_STAGED_001]]></value></item><item><name><![CDATA[e]]></name><value><![CDATA[true]]></value></item><item><name><![CDATA[j]]></name><value><! [CDATA[true]]></value></item><item><name><![CDATA[a]]></name><value><![CDATA[true]]></value></item> 13 Apr 2012 17:08:57 INFO com.nakisa.Logger - [Admin console] admin user 'admin' successfully logged in 13 Apr 2012 17:09:14 INFO com.nakisa.Logger - SAP Extractor : nullRfcReadTable(Read Table Function/BAPI).nullObjid, Stabs 13 Apr 2012 17:15:27 INFO com.nakisa.Logger - -ap: size=3 13 Apr 2012 17:15:27 INFO com.nakisa.Logger - 033/usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root/: size=80 13 Apr 2012 17:15:27 INFO com.nakisa.Logger - -b: size=2 13 Apr 2012 17:15:27 INFO com.nakisa.Logger - __000__DHS_STAGED_001: size=21 13 Apr 2012 17:15:27 INFO com.nakisa.Logger - -e: size=2 13 Apr 2012 17:15:27 INFO com.nakisa.Logger - true: size=4 13 Apr 2012 17:15:27 INFO com.nakisa.Logger - -j: size=2 13 Apr 2012 17:15:27 INFO com.nakisa.Logger - true: size=4 13 Apr 2012 17:15:27 INFO com.nakisa.Logger - -a: size=2 13 Apr 2012 17:15:27 INFO com.nakisa.Logger - true: size=4 : size=1012 17:15:27 INFO com.nakisa.Logger - 13 Apr 2012 17:15:27 INFO com.nakisa.Logger - <item><name><![CDATA[ap]]></name><value><![CDATA[033/usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root/]]></value></item><i tem><name><![CDATA[b]]></name><value><![CDATA[__000__DHS_STAGED_001]]></value></item><item><name><![CDATA[e]]></name><value><![CDATA[true]]></value></item><item><name><![CDATA[j]]></name><value><![ CDATA[true]]></value></item><item><name><![CDATA[a]]></name><value><![CDATA[true]]></value></item> 13 Apr 2012 17:15:27 INFO com.nakisa.Logger - [Admin console] admin user 'admin' successfully logged in 13 Apr 2012 17:15:43 INFO com.nakisa.Logger - SAP Extractor : nullRfcReadTable(Read Table Function/BAPI).nullObjid, Stabs
Hi Both,
Thanks for assisting me on this today.
The conclusion is:
This is the example command:
sh /usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root/sapextractor.sh /sapmnt/NKD/exe/jvm/linuxx86_64/sapjvm_6.1.006/sapjvm_6/bin /usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root __000__DHS_STAGED_001 /sapmnt/NKD/exe/jvm/linuxx86_64/sapjvm_6.1.006/sapjvm_6/jre/lib/amd64/server/sapjco.jar NakisaFrameworkBin NakisaTrollBin true true true
Cheers,
Raff
Hi Raff,
Try running this command:
sh /usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root/sapextractor.sh /usr/sap/NKD/J30/j2ee/JSPM/sapjvm/jre/bin /usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root __000__DHS_STAGED_001 /sapmnt/NKD/exe/jvm/linuxx86_64/sapjvm_6.1.006/sapjvm_6/jre/lib/amd64/server/sapjco3.jar NakisaFrameworkBin NakisaTrollBin true true true
Best regards,
Luke
Hi Luke,
I've just deleted the sapjco3.jar from the /sapmnt/NKD/exe/jvm/linuxx86_64/sapjvm_6.1.006/sapjvm_6/jre/lib/amd64/server/
Should I put it back ?
No, use this command instead
sh /usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root/sapextractor.sh /usr/sap/NKD/J30/j2ee/JSPM/sapjvm/jre/bin /usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root __000__DHS_STAGED_001 /sapmnt/NKD/exe/jvm/linuxx86_64/sapjvm_6.1.006/sapjvm_6/jre/lib/amd64/server/sapjco.jar NakisaFrameworkBin NakisaTrollBin true true true
Yes, its a same like in the bottom
I'm not sure why, if using JSPM both of the sapjco not work.
Cheers,
Raff
Since I curious, I put back sapjco3
And its seems like pointing to JSPM isn't work too, throwing the same error.
dhssps:nkdadm 271> sh /usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root/sapextractor.sh /usr/sap/NKD/J30/j2ee/JSPM/sapjvm/jre/bin /usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root __000__DHS_STAGED_001 /sapmnt/NKD/exe/jvm/linuxx86_64/sapjvm_6.1.006/sapjvm_6/jre/lib/amd64/server/sapjco3.jar NakisaFrameworkBin NakisaTrollBin true true true -ap[length:3] 033/usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root/[length:80] -b[length:2] __000__DHS_STAGED_001[length:21] -e[length:2] true[length:4] -j[length:2] true[length:4] -a[length:2] true[length:4] [length:1] [Fatal Error] :-1:-1: Premature end of file. [Fatal Error] :-1:-1: Premature end of file. Using build path: __000__DHS_STAGED_001 Extract: true Generating Analytics: true Using joins: true Loading Manager Resources: /usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root/.system/Admin_Config/ManagerResources.xml Loading Manager Resources: /usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root/.system/Admin_Config/__000__DHS_STAGED_001/ManagerResources.xml Loading App Resources: /usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root/.system/Admin_Config/__000__DHS_STAGED_001/AppResources Loading Counts: /usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root/.system/Admin_Config/__000__DHS_STAGED_001/Analytics/Counts.xml Loading Extractor Configuration: /usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root/.system/Admin_Config/__000__DHS_STAGED_001/SAPExtractor/extractorSchema Extracting... Exception in thread "main" java.lang.NoClassDefFoundError: com/sap/mw/jco/IRepository at com.nakisa.framework.data.commandProcessor.impl.sap.BaseFunctionProcessor.call(BaseFunctionProcessor.java:86) at Nakisa.SAP.SAPeProcessor.RfcReadTable.getDataSet(RfcReadTable.java:47) at com.nakisa.framework.data.commandProcessor.impl.sap.BaseFunctionProcessor.getDataSetFinal(BaseFunctionProcessor.java:103) at com.nakisa.framework.data.commandProcessor.impl.sap.SAPCommandProcessor.getDataSet(SAPCommandProcessor.java:42) at com.nakisa.framework.data.commandProcessor.CommandProcessor.getDataSet(CommandProcessor.java:369) at com.nakisa.framework.data.DataAccess.getDataSet(DataAccess.java:26) at com.nakisa.sap.extractor.SAPExtractorProcessor.processSimpleFunction(SAPExtractorProcessor.java:1303) at com.nakisa.sap.extractor.SAPExtractorProcessor.processSimpleFunctionAt(SAPExtractorProcessor.java:716) at com.nakisa.sap.extractor.SAPExtractorProcessor.parseFunctionSchema(SAPExtractorProcessor.java:852) at com.nakisa.sap.extractor.SAPExtractorProcessor.extract(SAPExtractorProcessor.java:519) at com.nakisa.sap.extractor.commandline.SAPExtractorCommandLine.startExtractionProcess(SAPExtractorCommandLine.java:141) at com.nakisa.sap.extractor.commandline.SAPExtractorCommandLine.startExtraction(SAPExtractorCommandLine.java:112) at com.nakisa.sap.extractor.commandline.SAPExtractorCommandLine.<init>(SAPExtractorCommandLine.java:103) at com.nakisa.sap.extractor.commandline.SAPExtractorCommandLine.main(SAPExtractorCommandLine.java:70) Caused by: java.lang.ClassNotFoundException: com.sap.mw.jco.IRepository at java.net.URLClassLoader$1.run(URLClassLoader.java:261) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:249) at java.lang.ClassLoader.loadClass(ClassLoader.java:362) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:319) at java.lang.ClassLoader.loadClass(ClassLoader.java:307) at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:375) ... 14 more
Cheers,
Raff
At another client we use the JSPM jvm as the 2nd parameter. SAP JCo 3 won't work so the statement will definitely error if you use it.
Sorry - I managed to miss that entire "premature end of file" notification ... I'm jumping around trying to wrap up things for the day.
That is a bad sign and the output in the cds.log looks rather limited too. I assume you don't have any data in the database.
I'm not 1005 on how I'm reading the output, but it looks like it is reporting the length of each parameter as it is being read in. So the command that actually gets executed is..
$1/java -Xmx1g -classpath "{lots of JAR file paths in here}" com.nakisa.sap.extractor.commandline.SAPExtractorCommandLine -ap \033$2/ -b $3 -e $7 -j $8 -a $9
Now line 2 you can see corresponds to the "-ap" in the line above ... which is three characters long.
So on through to the "trye" pass in for the -a (analytics).
After that it reads in a further parameter of length 1 ... which I think is a space at the end of the command from sapextractor.sh.
So at this point I think (and this is a big assumptive "think") Java tries to load all the JAR files in. Now a premature end of file isn't the same as not found, and so I think does lend further credence to Luke's observation about the SAP JCo version.
Should you still get the same issue after resolving the SAP JCo version I'd suggest going through the list of JAR files and just confirming they are all in place.
Hi Stephen,
Thanks for the great analysis.
I have checked on the table, but I'm not sure it was correct. But I will try to have a look again.
Hi Raff,
To test I recommend deleting all records from a table and then running the extract again (without the joins and analytics). If the table is populated then the extract worked.
It is worth bearing in mind that Nakisa released an updated version of the command line extractor in some recent builds, so it is recommended to raise an OSS message for the latest build.
I would also check your XML extractor configuration is valid if you have made any customizations.
Best regards,
Luke
Hi Both,
I have analyze the error and check on the scripts itself.
Basically the scripts will execute below parameter:
#!/bin/sh # $1 Path to the java sdk # $2 Path to the deployed Nakisa OrgChart application # $3 Build name (must match the build name displayed in the AdminConsole) # $4 Path to the SAP java connector file (sapjco.jar) # $5 Name of the NakisaFrameworkBinxx.jar file, where xx is the build number. Find this file in the [application directory]/WEB-INF/lib directory to get the build number. # $6 Name of the NakisaTrolBinxx.jar file, where xx is the build number. Find this file in the [application directory]/WEB-INF/lib directory to get the build number # $7 Extract data (options: true|false) # $8 Execute joins on extracted data (options: true|false) # $9 Generate analytics (options: true|false)
From the error below I can indicate something missing or not grabbed correcly as per Stephen Advised.
-ap[length:3] 033/usr/sap/NKD/J30/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root/[length:80] -b[length:2] __000__DHS_STAGED_001[length:21] -e[length:2] true[length:4] -j[length:2] true[length:4] -a[length:2] true[length:4] [length:1] [Fatal Error] :-1:-1: Premature end of file. [Fatal Error] :-1:-1: Premature end of file. Using build path: __000__DHS_STAGED_001 Extract: true Generating Analytics: true Using joins: true
I have checked all the scripts and mark it with * that the lib is there, so I can say, there is nothing wrong with the library as all is there:
$1/java -Xmx1g -classpath ".: $4: *$2/WEB-INF/lib/SAPExtractorCommandLine.jar: *$2/WEB-INF/lib/db2jcc.jar: *$2/WEB-INF/lib/db2jcc_license_cu.jar: *$2/WEB-INF/lib/commons-beanutils.jar: *$2/WEB-INF/lib/commons-codec-1.3.jar: *$2/WEB-INF/lib/commons-collections.jar: *$2/WEB-INF/lib/commons-dbcp.jar: *$2/WEB-INF/lib/commons-digester-1.8.jar: *$2/WEB-INF/lib/commons-fileupload.jar: *$2/WEB-INF/lib/commons-io.jar: *$2/WEB-INF/lib/commons-jelly-1.0.jar: *$2/WEB-INF/lib/commons-jexl-1.0.jar: *$2/WEB-INF/lib/commons-jxpath-1.2.jar: *$2/WEB-INF/lib/commons-lang.jar: *$2/WEB-INF/lib/commons-logging.jar: *$2/WEB-INF/lib/commons-pool.jar: *$2/WEB-INF/lib/core-renderer.jar: *$2/WEB-INF/lib/dom4j-1.5.2.jar: *$2/WEB-INF/lib/el-impl-1.0.jar: *$2/WEB-INF/lib/$5.jar: *$2/WEB-INF/lib/jsf-api.jar: *$2/WEB-INF/lib/jsf-facelets.jar: *$2/WEB-INF/lib/jsf-impl.jar: *$2/WEB-INF/lib/ldapbp.jar: *$2/WEB-INF/lib/log4j-1.2.15.jar: *$2/WEB-INF/lib/ojdbc5_g.jar: *$2/WEB-INF/lib/pd4ml.jar: *$2/WEB-INF/lib/sapdbc.jar: *$2/WEB-INF/lib/serializer.jar: *$2/WEB-INF/lib/spring-ldap-1.2.jar: *$2/WEB-INF/lib/spring.jar: *$2/WEB-INF/lib/sqljdbc.jar: *$2/WEB-INF/lib/ss_css2.jar: *$2/WEB-INF/lib/trinidad-api-1.2.11.jar: *$2/WEB-INF/lib/trinidad-impl-1.2.11.jar: *$2/WEB-INF/lib/$6.jar: *$2/WEB-INF/lib/webrendererse.jar: *$2/WEB-INF/lib/xalan.jar: *$2/WEB-INF/lib/xercesImpl.jar: *$2/WEB-INF/lib/xml-apis.jar" com.nakisa.sap.extractor.commandline.SAPExtractorCommandLine -ap \033$2/ - b $3 -e $7 -j $8 -a $9
After check on the database, and we do some test to remove the DB and SYNC back the data is populated.
Cheers,
Raff
Raff.
If you cleared the tables and they've re-populated, that's a good sign ....
That being said, those premature end of file messages are still appearing so I can't say in good conscience that you can trust the set of results being returned. The results could be correct - but error messages are there for a reason after all and they may not always be correct.
I did a quick search on this premature end of file error and there is another discussion from last September where someone else had the same error message (along with quite a few others by the sounds of it). I would suggest that you have a read through the whole thread to make sense of it and then review the actions undertaken in the last post on the thread. It looks like they were on SP1, but at this point it is worth a try and should that fail, then I think your best option (as per Luke's suggestions above) would be to get yourself onto the latest build (though SP3 did became available today) and failing that raise an OSS message for the error.
Stephen.
